Free Loan Amortization Schedule
A free loan amortization schedule for Excel and Google Sheets with monthly, two-weekly or weekly payments, extra and lump-sum payments, interest saved, a yearly balance chart and a three-loan comparison.
Free ยท Excel and Google Sheets workbook, 5 tabs, up to 600 payments
Specifications
| Brand | Stelaah |
|---|---|
| Category | Spreadsheets and tools |
| Format | Excel and Google Sheets workbook, 5 tabs, up to 600 payments |
| Price | Free |
| Files | Stelaah Loan Amortization Schedule.xlsx (91 KB) |
| Works with | Open the .xlsx in Excel 365, Google Sheets or Numbers. |
| Licence | Use it yourself, on all your devices. Please do not share or resell the files. |
| Language | English |
| Includes | 600 payments, 3 offers compared, 5 tabs |
A free loan amortization schedule for a mortgage, a car loan or a business loan, in any currency. Type the amount, rate, term and how often you pay, and it builds every payment: interest, principal and the balance left.
See what paying extra does. Add an amount to every payment, a one-off lump sum or both, and it shows the new payoff date, the interest you save and the time you save. The example, a 250,000 loan at 6.5% over 30 years with 200 extra a month and one 5,000 payment, saves 110,525.78 in interest and 8 years 9 months.
The By year tab totals each year with a balance chart, and Compare puts three loan offers side by side, fees included, so you can see which one costs least.
Get it free in the Stelaah Store
See inside
What's inside
1 spreadsheet in one download.
| Section | Pages or size |
|---|---|
| Start here | 1 tab |
| Loan: details, extra payments and summary | 1 tab |
| Schedule: every payment | 600 rows |
| By year with balance chart | 1 tab |
| Compare three offers | 1 tab |
Who it's for
- Home buyers and home owners with a mortgage
- People paying off a car or personal loan
- Small businesses comparing loan offers
You may be looking for
- amortization schedule
- loan amortization schedule
- mortgage amortization schedule
- amortization calculator excel
- extra payment calculator
- loan comparison spreadsheet
Works with
Open the .xlsx in Excel 365, Google Sheets or Numbers.
Questions
- Does it work in Google Sheets?
- Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. It also opens in Excel 365 and Numbers.
- How is it different from the Debt Snowball Spreadsheet?
- The debt snowball pays off many debts in order. This schedule goes deep on one loan: every payment, extra payments and what they save, plus a compare tab for offers.
- Is this financial advice?
- No. It is a calculator. Your lender's figures can differ because of fees, rounding and how they apply extra payments, so check with them before you decide.
- Which apps does it work with?
- Open the .xlsx in Excel 365, Google Sheets or Numbers.
- Is it really free?
- Yes. Add your name and email once and every free Stelaah download opens on this browser. No account is needed.
- What do I download?
- Stelaah Loan Amortization Schedule.xlsx (91 KB).
- Can I share or resell it?
- Use it yourself, on all your devices. Please do not share or resell the files.