Finance template
Loan amortization schedule
See every monthly payment split into interest and principal, with room for extra payments. Find out how much interest and time extra payments save.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Loan
967 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 1,115 filled cells in all.
Built in
- Charts
- Conditional formatting
- Named ranges
- Frozen headers
- 1 chart
- 2 conditional format rules
A look at the Loan sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Loan amortization schedule | |||||||
| 2 | Change the yellow inputs. Type over the Extra column to plan one off extra payments. | |||||||
| 3 | ||||||||
| 4 | Loan amount | $28,000.00 | Monthly payment | $553.11 | ||||
| 5 | Annual interest rate | 6.90% | Payments with extra | 50 | ||||
| 6 | Term (years) | 5 | Payoff date | Jan 1, 2031 | ||||
| 7 | First payment date | 12/1/2026 | Total interest | $4,242.04 | ||||
| 8 | Extra each month | $100.00 | Interest saved | $944.77 | ||||
| 9 | First payment interest | $161.00 | ||||||
| 10 | First payment principal | $392.11 | ||||||
| 11 | ||||||||
| 12 | No. | Date | Balance | Payment | Extra | Interest | Principal | End balance |
- loan
- amortization
- interest
- extra payments
More finance templates
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
FinanceInvoice trackerTrack every invoice you send, what has been paid and what is overdue today. An aging summary groups open balances by how late they are.
FinanceBreak-even analysisFind how many units you need to sell to cover fixed costs, and what it takes to hit a profit goal. A chart shows revenue crossing total cost.
FinanceCap tableModel ownership through seed and Series A rounds with share prices worked out from each pre-money valuation. See fully diluted ownership and a simple payout at an exit value.
Start your loan amortization schedule now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.