mortgage calculator
Compare Today's Home Equity Rates

Loan Calculator Excel

Today's Home Equity Rates
Check Today's Mortgage Rates

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

Share My Mortgage Calculation




Amortization Calculator Excel
Additional Mortgage Payment Calculator

Mortgage Calculator | Terms | Privacy | Disclaimer | Contact

©2024 Mortgage Calculator