Skip to content

Mortgage Amortization Schedule Spreadsheet, Payment and Payoff Calculator

$5.99

Price 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

FormatsXLSX, ODS, ZIP
DimensionsZIP: XLSX + ODS, 5 tabs
Downloadable files1 ZIP download · XLSX, ODS, ZIP formats
CategoryPlanners & Printables
Last updated

What you’ll download

  • ziploan-amortization-calculator-home-2027.zip171 KB

Usage

Educo states how these files may be used in the listing description. Check it before you buy, and message the shop if you’re unsure.

Reselling, sharing or redistributing the original files as they are isn’t allowed, including in free packs or AI training sets.

Related searches

Reviews for this item

No reviews yet.

Questions about this file

No questions yet.

Quick answers

What files are included with Mortgage Amortization Schedule Spreadsheet, Payment and Payoff Calculator?

1 ZIP download · XLSX, ODS, ZIP formats; ZIP: XLSX + ODS, 5 tabs. See Item details and What you’ll download for the contents of each package.

How can I use these files?

The shop states how its files may be used in the listing description, so check it before buying and message the shop if you’re unsure. Reselling or redistributing the original files as they are isn’t allowed.

Which apps and devices does it work with?

The seller lists XLSX spreadsheet apps, ODS spreadsheet apps. The supplied formats are XLSX, ODS, ZIP. Check that your app and device support these files and the features you need before buying.

How do I get my files after buying?

After payment, download your files right away. Your receipt email links to them, and with an Esano account they also stay in Purchases. If a download is a ZIP, unzip it to access the files inside. No physical item is shipped.

Meet the shop

Educo

To draw out potentical · On Esano since 2026

More from Educo

Visit shop

You may also like