mortgage calculator

Loan Calculator Excel

Loan Calculator Excel to calculate the monthly payments 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. Enter the loan amount, terms, interest rate to get started. The loan calculator has the option to download the loan repayment schedule (amortization schedule) in an excel spreadsheet in monthly or yearly form.

Loan Calculator

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:
Sep, 2023
Payoff Date:
Aug, 2028
Total Interest Paid:
$7,936.44
Total Payment:
$67,936.44

Amortization Schedule

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

Share My Mortgage Calculation




Amortization Calculator Excel
Additional Mortgage Payment Calculator
Check Today's Mortgage Rates
Today's Home Equity Rates



Mortgage Calculators

Refinance Calculators

Early Mortgage Payoff Calculators

Real Estate Investment Calculators





Mortgage Related Calculators

Auto Loan Calculators

Loan Calculators

Savings & Investments Calculators

Credit Card Calculators

Mortgage Guide

Mortgage Calculator Widget

Mortgage Calculator | Amortization Schedule | Terms | Privacy | Disclaimer | Contact

©2023 Mortgage Calculator Excel