How to read your amortization schedule
1 min read
Each row is one month. Month: the payment number. Payment: what you pay that month. Interest: the portion that covers the cost of the loan. Principal: the portion that reduces your debt. Balance: what you still owe after that payment.
Look at two things: how much interest you pay in total and the month when your balance falls to half.
You can download the schedule as a CSV to open it in your spreadsheet.
Frequently asked questions
Why is the last payment different?
If you pay extra, the last payment can be smaller because it only covers what remains.
Will it match my bank's schedule?
It should be similar; if not, fees or insurance may be included.
Sources
- Standard structure of an amortization schedule.
Calculate yours
Calculate my loanRelated guides
How loan amortization works
What an amortization schedule is and how each payment is split between interest and principal.
Why you pay more interest than principal at first
How the proportion of interest and principal changes over the life of your loan.
Did this help?