Your full loan schedule — and how much extra payments save
Type the loan amount, rate and term to get the payment and every installment with interest and principal. Add an extra payment and see the interest you save.
- ⚡ Instant download
- 🔒 Secure checkout by Stripe
- ↩️ 7-day guarantee
Sound familiar?
- You don’t know how much of each payment is interest
- You wonder if paying extra is worth it
- Bank statements don’t show the full picture
The Loan Amortization Schedule fixes that in a few minutes, for $2.
What changes when you use it
Every payment explained
Date, start balance, payment, interest, principal and end balance.
See the power of extra payments
Payoff date, total interest and interest saved with an extra amount per period.
Works for any fixed-rate loan
Car, personal, student loans or mortgages — monthly or other frequencies.
The yearly view
Principal and interest paid each year with a stacked chart.
What's inside the spreadsheet
- Loan amount, rate, term, payments per year and first payment date
- Extra payment per period
- Scheduled payment (PMT)
- Number of payments and payoff date with extra
- Total interest with and without extra, and interest saved
- Schedule of up to 360 payments
- By year tab with principal, interest and balance
- Stacked chart
Ready in 3 simple steps
Buy securely
Pay $2 once through the secure checkout (Stripe).
Download instantly
Your file is ready right after payment and also arrives in your e-mail.
Fill in and use
Open it in Excel, type your data and let the formulas do the work.
Made for
Everything you get
- Loan Amortization Schedule (.xlsx file), 100% editable
- Instant download right after payment, plus the link in your e-mail
- Use it on as many of your own computers as you need
- No subscription and no monthly fees, ever
- Free e-mail support to help you get started
- 7-day money-back guarantee
Works with: Excel 2010 or newer on Windows or Mac · also opens in Google Sheets
Buying a home? See the Mortgage Calculator with taxes and insurance.Loan Amortization Schedule
$2
One extra payment idea from this file can save you hundreds.
Download nowFrequently asked questions
Does it work for variable-rate loans?
It assumes a fixed rate. For variable loans, update the rate and balance when it changes.
Can I use weekly or biweekly payments?
Yes. Set payments per year to 52 or 26.
Does the extra payment have to be every period?
In this template, yes — the same extra amount each period.
How do I receive the spreadsheet?
Right after payment you get the download link on screen and by e-mail. Lost it? Get new links anytime on the "My downloads" page.
Which software do I need?
Microsoft Excel 2010 or newer (including Microsoft 365) on Windows or Mac. It also opens in Google Sheets and LibreOffice, although some formatting may look slightly different.
Can I edit it and add my logo?
Yes. The file is not locked: you can rename labels, add rows and put your own logo in it.
What language is the file in?
English.
Is it a subscription?
No. You pay $2 once and the file is yours to use for as long as you want.
What if it is not what I need?
You have 7 days to try it. If it does not meet your needs, write to us and we will help you, exchange it for another template or refund your payment.
More about the Loan Amortization Schedule
Type the loan amount, rate and term to get the payment and every installment with interest and principal. Add an extra payment and see the interest you save.
What's inside
- Loan amount, rate, term, payments per year and first payment date
- Extra payment per period
- Scheduled payment (PMT)
- Number of payments and payoff date with extra
- Total interest with and without extra, and interest saved
- Schedule of up to 360 payments
- By year tab with principal, interest and balance
- Stacked chart
Works in Microsoft Excel 2010 or newer (Windows and Mac) and opens in Google Sheets. One-time payment, instant download.
Get organized today for just $2
Download the Loan Amortization Schedule now and start using it in minutes.
Download now for $2One-time payment · Instant download · 7-day guarantee
