Amortization Schedule Calculator
Generate a full month-by-month amortization schedule showing each payment's principal, interest and remaining balance — downloadable as CSV.
For information and education only — not financial advice. Results are estimates based on the numbers you enter; check important decisions with a qualified professional.
How to use
- 1Enter the loan amount, rate and term.
- 2Scroll the monthly table or download it as a CSV for Excel or Google Sheets.
How it's calculated
Each month: interest = balance × rate ÷ 12; principal = payment − interest; new balance = balance − principal.
Frequently asked questions
Why is so much of my early payment interest?
Interest is charged on the remaining balance, which is largest at the start. As the balance falls, more of each payment goes to principal.
When do I start paying more principal than interest?
It depends on the rate and term. The schedule's 'principal' and 'interest' columns show exactly when they cross.
Can I add extra payments?
Yes — enter a monthly extra payment to see how the schedule shortens.