Mortgage Amortization Schedule Spreadsheet, Payment and Payoff Calculator
By EducoPrice in USD. Local taxes calculated at checkout.
Buy 3 or more, save 20% from this shop
- 1 ZIP download · XLSX, ODS, ZIP formats · ZIP: XLSX + ODS, 5 tabs
- Buyer protection. Corrupt or mismatched files? Full refund.
Item details
Type the amount, rate and term of a mortgage and get the monthly payment, a payment-by-payment schedule, total interest and payoff date. Add an extra monthly payment to see how much interest you save.
Tabs inside: Example Loan - worked mortgage example, yearly summary and charts | Example Schedule - full example schedule (275 payments) | Loan - blank inputs, results, yearly summary and two charts | Schedule - blank schedule engine for up to 360 payments
What you get: - Interest is rounded to the cent each period and the final payment clears the exact balance. - Interest saved and months saved compared with the scheduled term, plus payoff date. - Schedule tab with up to 360 payments: date, opening balance, payment, interest, principal, extra payment and closing balance. - Inputs for loan amount, annual interest rate, term in years (1-30), first payment date and extra monthly payment. - The Example tabs are set up for a fictional mortgage of $285,000 at 6.25% over 30 years with $200 extra a month.
Your single ZIP download holds two files, an .xlsx workbook and a matching .ods version, each with the same 5 tabs and formulas. Use a spreadsheet application that supports XLSX or ODS. The design is set in the free open-license Atkinson Hyperlegible typeface in a dusty rose colour theme; if the font is not installed your app swaps in a similar one without breaking the layout. Instant digital download, no physical item.
The XLSX edition includes editable charts. The ODS edition contains the matching worksheets and formulas without embedded charts.
Works with XLSX spreadsheet apps, ODS spreadsheet apps.
File specs
| Formats | XLSX, ODS, ZIP |
|---|---|
| Dimensions | ZIP: XLSX + ODS, 5 tabs |
| Downloadable files | 1 ZIP download · XLSX, ODS, ZIP formats |
| Category | Planners & Printables |
| Last updated |
What you’ll download
- ziploan-amortization-calculator-home-2027.zip171 KB
License and usage
- Personal · $5.99
- Use the files in your own non-commercial projects: home prints, gifts, personal social posts and school work. Anything made with them can’t be sold.
- Commercial · $12.98
- Use the files in client work and in products you sell, up to 5,000 units across all products. Credit is appreciated but not required.
No license allows reselling, sharing or redistributing the original files as they are, including in free packs or AI training sets.
