mortgage calculator

Loan Calculator

Loan Calculator Excel is used to calculate monthly payment for your loan. You can use the loan calculator to calculate any type of loans, such as personal loans, student loans and etc. You can generate an amortization table that shows you all the details of your monthly payment, and the result is exportable as an excel and pdf file. Simply enter the loan amount, terms, interest rate to get started. The loan calculator excel has the option to show the amortization schedule in monthly or yearly form, and choose any start date for your loan.

Loan Calculator Excel

Loan Amount
Loan Terms
years
Interest Rate
First Payment Date
Amortization schedule
Show By Month Show By Year
https://mortgage-calculator.net

Loan & Payment Summary

Loan Amount:
$60,000.00
Monthly Payment:
$1,132.27
Total # Of Payments:
60
Start Date:
Jun, 2021
Payoff Date:
May, 2026
Total Interest Paid:
$7,936.44
Total Payment:
$67,936.44

Amortization Schedule

Payment Date Payment # Interest Paid Principal Paid Total Payment Remaining Balance
Jun, 2021 1 $250.00 $882.27 $1,132.27 $59,117.73
Jul, 2021 2 $246.32 $885.95 $1,132.27 $58,231.78
Aug, 2021 3 $242.63 $889.64 $1,132.27 $57,342.13
Sep, 2021 4 $238.93 $893.35 $1,132.27 $56,448.79
Oct, 2021 5 $235.20 $897.07 $1,132.27 $55,551.71
Nov, 2021 6 $231.47 $900.81 $1,132.27 $54,650.91
Dec, 2021 7 $227.71 $904.56 $1,132.27 $53,746.34
Jan, 2022 8 $223.94 $908.33 $1,132.27 $52,838.01
Feb, 2022 9 $220.16 $912.12 $1,132.27 $51,925.90
Mar, 2022 10 $216.36 $915.92 $1,132.27 $51,009.98
Apr, 2022 11 $212.54 $919.73 $1,132.27 $50,090.25
May, 2022 12 $208.71 $923.56 $1,132.27 $49,166.68
Jun, 2022 13 $204.86 $927.41 $1,132.27 $48,239.27
Jul, 2022 14 $201.00 $931.28 $1,132.27 $47,307.99
Aug, 2022 15 $197.12 $935.16 $1,132.27 $46,372.84
Sep, 2022 16 $193.22 $939.05 $1,132.27 $45,433.78
Oct, 2022 17 $189.31 $942.97 $1,132.27 $44,490.82
Nov, 2022 18 $185.38 $946.90 $1,132.27 $43,543.92
Dec, 2022 19 $181.43 $950.84 $1,132.27 $42,593.08
Jan, 2023 20 $177.47 $954.80 $1,132.27 $41,638.28
Feb, 2023 21 $173.49 $958.78 $1,132.27 $40,679.50
Mar, 2023 22 $169.50 $962.78 $1,132.27 $39,716.72
Apr, 2023 23 $165.49 $966.79 $1,132.27 $38,749.93
May, 2023 24 $161.46 $970.82 $1,132.27 $37,779.12
Jun, 2023 25 $157.41 $974.86 $1,132.27 $36,804.26
Jul, 2023 26 $153.35 $978.92 $1,132.27 $35,825.33
Aug, 2023 27 $149.27 $983.00 $1,132.27 $34,842.33
Sep, 2023 28 $145.18 $987.10 $1,132.27 $33,855.23
Oct, 2023 29 $141.06 $991.21 $1,132.27 $32,864.02
Nov, 2023 30 $136.93 $995.34 $1,132.27 $31,868.68
Dec, 2023 31 $132.79 $999.49 $1,132.27 $30,869.19
Jan, 2024 32 $128.62 $1,003.65 $1,132.27 $29,865.54
Feb, 2024 33 $124.44 $1,007.83 $1,132.27 $28,857.71
Mar, 2024 34 $120.24 $1,012.03 $1,132.27 $27,845.67
Apr, 2024 35 $116.02 $1,016.25 $1,132.27 $26,829.42
May, 2024 36 $111.79 $1,020.48 $1,132.27 $25,808.94
Jun, 2024 37 $107.54 $1,024.74 $1,132.27 $24,784.20
Jul, 2024 38 $103.27 $1,029.01 $1,132.27 $23,755.20
Aug, 2024 39 $98.98 $1,033.29 $1,132.27 $22,721.90
Sep, 2024 40 $94.67 $1,037.60 $1,132.27 $21,684.30
Oct, 2024 41 $90.35 $1,041.92 $1,132.27 $20,642.38
Nov, 2024 42 $86.01 $1,046.26 $1,132.27 $19,596.12
Dec, 2024 43 $81.65 $1,050.62 $1,132.27 $18,545.49
Jan, 2025 44 $77.27 $1,055.00 $1,132.27 $17,490.49
Feb, 2025 45 $72.88 $1,059.40 $1,132.27 $16,431.09
Mar, 2025 46 $68.46 $1,063.81 $1,132.27 $15,367.28
Apr, 2025 47 $64.03 $1,068.24 $1,132.27 $14,299.04
May, 2025 48 $59.58 $1,072.69 $1,132.27 $13,226.34
Jun, 2025 49 $55.11 $1,077.16 $1,132.27 $12,149.18
Jul, 2025 50 $50.62 $1,081.65 $1,132.27 $11,067.53
Aug, 2025 51 $46.11 $1,086.16 $1,132.27 $9,981.37
Sep, 2025 52 $41.59 $1,090.68 $1,132.27 $8,890.68
Oct, 2025 53 $37.04 $1,095.23 $1,132.27 $7,795.45
Nov, 2025 54 $32.48 $1,099.79 $1,132.27 $6,695.66
Dec, 2025 55 $27.90 $1,104.38 $1,132.27 $5,591.29
Jan, 2026 56 $23.30 $1,108.98 $1,132.27 $4,482.31
Feb, 2026 57 $18.68 $1,113.60 $1,132.27 $3,368.71
Mar, 2026 58 $14.04 $1,118.24 $1,132.27 $2,250.47
Apr, 2026 59 $9.38 $1,122.90 $1,132.27 $1,127.58
May, 2026 60 $4.70 $1,127.58 $1,132.27 $0.00

Share My Mortgage Calculation




Amortization Calculator Excel
Additional Mortgage Payment Calculator



Early Mortgage Payoff Calculator
Mortgage Payoff Calculator
Mortgage Refinance Calculator
Commercial Mortgage Calculator
Mortgage Comparison Calculator
Balloon Mortgage Calculator
Mortgage Calculator App
Monthly Mortgage Payment Calculator
Biweekly Mortgage Calculator with Extra Payments
Interest Only Mortgage Calculator
Simple Mortgage Calculator
Advanced Mortgage Calculator
FHA Loan Calculator
VA Loan Calculator
USDA Loan Mortgage Calculator
Mortgage Calculator By State
Down Payment Calculator
Reverse Mortgage Calculator
Mortgage Affordability Calculator
Mortgage Balance Calculator
Cash Out Refinance Calculator
Refinance Break Even Calculator
How Much House Can I Afford
HELOC Calculator
HELOC Payoff Calculator
HELOC Payment Calculator
Mortgage Prepayment Calculator
Mortgage Calculator Canada
Mortgage Calculator UK
PMI Calculator
Real Estate Commission Calculator
Mortgage Calculator With Extra Payments
APR Calculator
Property Tax Calculator
Investment Property Calculator
Interest Rate Calculator
Mortgage Interest Tax Deduction Calculator
Mortgage Calculator Excel
Amortization Schedule With Irregular Payments
15 Year Mortgage Calculator
30 Year Mortgage Calculator
Condo Mortgage Calculator
Second Mortgage Calculator
Home Improvement Loan Calculator
Home Sale Net Proceeds Calculator
Closing Costs Calculator
Construction Loan Calculator
Amortization Calculator Excel

Auto Loan Calculator

Car Loan Calculator
Auto Loan Payoff Calculator
Auto Loan Calculator with Trade in
Auto Refinance Calculator
RV Loan Calculator
Motorcycle Loan Calculator
Car Lease Calculator
Car Depreciation Calculator
LTV Calculator Auto

Loan Calculator

Printable Amortization Schedule
Amortization Schedule Excel
LTV Calculator
Debt To Income Ratio Calculator
Debt Payoff Calculator
How Much Rent Can I Afford
Boat Loan Calculator
Student Loan Calculator
Student Loan Payoff Calculator
Personal Loan Calculator
Personal Loan Payoff Calculator
Land Loan Calculator
Loan Payoff Calculator
Loan Calculator

Savings & Investments Calculator

Compound Interest Calculator
Airbnb Calculator

Credit Card Calculators

Credit Card Calculator
Credit Card Payoff Calculator
Credit Card Minimum Payment Calculator
Credit Card Interest Calculator
Multiple Credit Card Payoff Calculator

Mortgage Guide

How to Pay Off Mortgage Earlier
How to Improve Credit Score
What Percent Do Real Estate Agents Make

Mortgage Calculator Widget

Free Mortgage Calculator Widget

Mortgage Calculator | Terms | Privacy | Disclaimer | Contact

©2021 Mortgage Calculator Excel