Mortgage Payoff Calculator Spreadsheet, Extra Payment Amortization Schedule, Google Sheets, Excel, Printable PDF

See how extra payments change everything. Enter your current balance, rate and years left, try an extra monthly amount or a one-time lump sum, and see your new payoff date and interest saved.

WHAT'S INCLUDED
- Mortgage Payoff Calculator spreadsheet (.xlsx), blank
- Example file with a sample loan
- Printable PDF (US Letter + A4): mortgage details + extra payment log, 1% payoff progress chart, yearly review

FEATURES
- Works from your current balance (new or existing fixed-rate loans)
- Calculates your P&I payment, or enter your own
- Extra principal every month + up to 12 one-time payments by date
- Interest saved and time saved
- Full amortization schedule (up to 40 years) vs. the regular schedule

HOW TO USE
1. Download the files from your Etsy Purchases page (instant download, nothing is shipped).
2. Excel: open the .xlsx file. Google Sheets: upload the .xlsx to Google Drive, open it, then choose File > Save as Google Sheets.
3. Start on the 'Start Here' tab and fill in the pale-yellow cells. Everything else calculates for you.
4. Print the PDF pages at home or at a print shop (US Letter and A4 included).

GOOD TO KNOW
- Digital download only. No physical item will be shipped.
- Works in Microsoft Excel 2010 or newer (Windows and Mac) and Google Sheets (free). Apple Numbers and LibreOffice not fully tested.
- Formula cells are protected (no password) to prevent accidental edits.
- Colors may look slightly different on screen vs. print.
- For personal use only. Please don't resell or share the files. (c) Porchlight Ledger
- Estimates only. Lenders may calculate interest daily or apply extra payments differently. Not for adjustable-rate or interest-only loans. Not financial advice.

ALSO IN THE SHOP
- Net Worth Tracker (track your home equity and net worth): https://www.etsy.com/au/listing/4587778214/net-worth-tracker-spreadsheet-monthly
- Debt Payoff Planner (snowball or avalanche plan for your other debts): https://www.etsy.com/au/listing/4587773080/debt-payoff-planner-spreadsheet-snowball
- Budget Spreadsheet Bundle (six matching planners in one download): https://www.etsy.com/au/listing/4587781978/budget-spreadsheet-bundle-debt-payoff
- Home Buying Planner (compare homes and plan your cash to close): https://www.etsy.com/au/listing/4587812227/home-buying-planner-spreadsheet-house

AI disclosure: I used AI tools to help build this template (formula drafting, layout, written instructions and the product preview images). Every formula was reviewed and tested in LibreOffice with sample data, and the files were checked before listing.