Excel templates
Loan repayment schedule in Excel
Enter the amount, interest rate and term: the workbook calculates the monthly payment, splits every payment into interest and principal and shows what an extra payment saves.
Download free (.xlsx)Free · no sign-up
Works in Excel, Google Sheets, Apple Numbers and LibreOffice.
Loan-schedule-Planmero.xlsx
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | No. | Date | Payment | Interest | Principal | Balance after |
| 2 | 1 | 1/15/2027 | $716.13 | $500.00 | $216.13 | $149,783.87 |
| 3 | 2 | 2/15/2027 | $716.13 | $499.28 | $216.85 | $149,567.02 |
| 4 | 3 | 3/15/2027 | $716.13 | $498.56 | $217.57 | $149,349.45 |
| 5 | 4 | 4/15/2027 | $716.13 | $497.83 | $218.30 | $149,131.15 |
| 6 | 5 | 5/15/2027 | $716.13 | $497.10 | $219.03 | $148,912.12 |
| 7 | 6 | 6/15/2027 | $716.13 | $496.37 | $219.76 | $148,692.36 |
How to useCalculatorScheduleBy year
What's inside
- Monthly payment, total paid and total interest
- A schedule for up to 40 years: date, interest, principal and balance of every payment
- Extra monthly payment: when the loan is paid off and how much interest it saves
- Yearly summary of interest and principal
- Charts of interest vs. principal and of the balance over time
How to use it
- 1On the Calculator sheet enter the loan amount, the yearly interest rate, the term in years and the date of the first payment.
- 2If you want to pay more each month, enter the extra amount — the schedule shortens and you see the interest saved.
- 3The Schedule sheet lists every payment: interest, principal, extra payment and the balance after it.
- 4The By year sheet sums interest and principal per year and draws the charts.
Questions
- Is it for mortgages too?
- Yes — any loan with a fixed rate and equal monthly payments (annuity): mortgage, car loan, personal loan.
- What if the rate changes after the fixed period?
- Enter the balance at the end of the fixed period as a new amount, the new rate and the remaining term, and you get the new schedule.
- Why is the first payment mostly interest?
- Interest is charged on what you still owe, which is highest at the start. As the balance falls, more of each payment goes to principal.
Tips
- Compare offers by the total interest, not only the monthly payment.
- An extra payment early in the loan saves the most interest.
- Fees and insurance are not included — add them to the monthly payment yourself.