Amortization Schedule


Amortization Schedule Excel


Amortization Schedule Excel is a loan calculator that outputs an amortization schedule in excel spreadsheet. The loan amortization schedule excel has all the monthly payments for your loan with breakdown for interest, principle and remaining balance.

Amortization Calculator Excel

Loan Amount
Loan Terms
years
Interest Rate
First Payment Date
Amortization schedule
Show By Month Show By Year

Loan Summary

Loan Amount:
$50,000.00
Monthly Payment:
$1,476.20
Total # Of Payments:
36
Start Date:
Sep, 2022
Payoff Date:
Aug, 2025
Total Interest Paid:
$3,143.17
Total Payment:
$53,143.17

Amortization Schedule

Payment Date Payment # Interest Paid Principal Paid Total Payment Remaining Balance
Sep, 2022 1 $166.67 $1,309.53 $1,476.20 $48,690.47
Oct, 2022 2 $162.30 $1,313.90 $1,476.20 $47,376.57
Nov, 2022 3 $157.92 $1,318.28 $1,476.20 $46,058.29
Dec, 2022 4 $153.53 $1,322.67 $1,476.20 $44,735.62
Jan, 2023 5 $149.12 $1,327.08 $1,476.20 $43,408.54
Feb, 2023 6 $144.70 $1,331.50 $1,476.20 $42,077.04
Mar, 2023 7 $140.26 $1,335.94 $1,476.20 $40,741.09
Apr, 2023 8 $135.80 $1,340.40 $1,476.20 $39,400.70
May, 2023 9 $131.34 $1,344.86 $1,476.20 $38,055.83
Jun, 2023 10 $126.85 $1,349.35 $1,476.20 $36,706.49
Jul, 2023 11 $122.35 $1,353.84 $1,476.20 $35,352.64
Aug, 2023 12 $117.84 $1,358.36 $1,476.20 $33,994.29
Sep, 2023 13 $113.31 $1,362.88 $1,476.20 $32,631.40
Oct, 2023 14 $108.77 $1,367.43 $1,476.20 $31,263.97
Nov, 2023 15 $104.21 $1,371.99 $1,476.20 $29,891.99
Dec, 2023 16 $99.64 $1,376.56 $1,476.20 $28,515.43
Jan, 2024 17 $95.05 $1,381.15 $1,476.20 $27,134.28
Feb, 2024 18 $90.45 $1,385.75 $1,476.20 $25,748.53
Mar, 2024 19 $85.83 $1,390.37 $1,476.20 $24,358.16
Apr, 2024 20 $81.19 $1,395.01 $1,476.20 $22,963.15
May, 2024 21 $76.54 $1,399.66 $1,476.20 $21,563.50
Jun, 2024 22 $71.88 $1,404.32 $1,476.20 $20,159.18
Jul, 2024 23 $67.20 $1,409.00 $1,476.20 $18,750.17
Aug, 2024 24 $62.50 $1,413.70 $1,476.20 $17,336.48
Sep, 2024 25 $57.79 $1,418.41 $1,476.20 $15,918.06
Oct, 2024 26 $53.06 $1,423.14 $1,476.20 $14,494.93
Nov, 2024 27 $48.32 $1,427.88 $1,476.20 $13,067.04
Dec, 2024 28 $43.56 $1,432.64 $1,476.20 $11,634.40
Jan, 2025 29 $38.78 $1,437.42 $1,476.20 $10,196.98
Feb, 2025 30 $33.99 $1,442.21 $1,476.20 $8,754.77
Mar, 2025 31 $29.18 $1,447.02 $1,476.20 $7,307.76
Apr, 2025 32 $24.36 $1,451.84 $1,476.20 $5,855.92
May, 2025 33 $19.52 $1,456.68 $1,476.20 $4,399.24
Jun, 2025 34 $14.66 $1,461.54 $1,476.20 $2,937.70
Jul, 2025 35 $9.79 $1,466.41 $1,476.20 $1,471.29
Aug, 2025 36 $4.90 $1,471.29 $1,476.20 $0.00



Loan Amortization Schedule Excel

The simple amortization calculator excel requires only 3 fields, loan amount, terms, and interest rate. To get a home loan amortization schedule with taxes and insurance, please use the amortization schedule with extra payments.

Amortization Schedule | Terms | Privacy | Disclaimer | Contact

©2022 Amortization Schedule