Loan amortization schedule template
A spreadsheet that builds the complete repayment schedule of any fixed-rate loan or mortgage. Enter the amount, rate, term and start date; add an extra monthly payment to see how much sooner the loan is paid off.
Loan amortization schedule
Download template (38 KB)The file contains only formulas and example numbers — no macros, no links, nothing that connects to the internet.
What's inside
- Monthly payment worked out with the PMT formula
- Up to 40 years of monthly rows: date, payment, principal, interest, balance
- Extra payment column and interest saved
- Payoff date and total interest summary
Prefer to calculate online? Use the Amortization calculator.
How to use it
- Download the file with the button above and open it in Excel, Google Sheets (File → Import), LibreOffice or Numbers.
- Fill in the yellow cells — they hold your own numbers. The example values show the expected format.
- Everything else is worked out by formulas. Save a copy whenever you want to keep a snapshot.
Common questions
Does it work for mortgages and car loans?
Yes — any loan repaid in equal monthly instalments at a fixed rate: mortgages, car loans, personal and student loans.
Can I change the extra payment for a single month?
Yes. The extra column is filled from the summary, but you can overwrite any month's cell with a different amount and the rest of the schedule updates.
More free templates
- Monthly budget plannerPlanned vs actual spending by category, with a 12-month overview.
- Expense trackerLog every purchase; totals by category and month appear automatically.
- Debt snowball and avalanche plannerPayoff order, dates and interest for up to 10 debts.
- Savings goal trackerTrack up to 10 goals: progress bars and the monthly amount still needed.
- Net worth trackerAssets minus debts, month by month for a year, with a chart.
- Loan comparisonThree loan offers side by side: payment, total cost and APR with fees.
- Monthly timesheetDaily start, end and breaks; hours, overtime and pay for the month.
Ads on this page help keep Abacurio and these templates free. Thank you for your support.