Mortgage Amortization Tracker
A printable multi-year payment log for the life of a mortgage: principal vs interest year by year, extra-principal payments, refinance and renewal events with their breakeven, and annual equity snapshots.
Mortgage Amortization Tracker
Fill the snapshot once, then add one row per year from your year-end mortgage statement. Milestone years (5, 10, 15, 20, 25, 30) are pre-marked in bold so equity progress is skimmable at a glance.
Mortgage Snapshot
Annual Amortization Log
| Year | Starting balance | P&I paid this year | Principal portion | Interest portion | Extra principal | Ending balance | Tax + insurance paid | Notes |
|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 (milestone) | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 (milestone) | ||||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 (milestone) | ||||||||
| 16 | ||||||||
| 17 | ||||||||
| 18 | ||||||||
| 19 | ||||||||
| 20 (milestone) | ||||||||
| 21 | ||||||||
| 22 | ||||||||
| 23 | ||||||||
| 24 | ||||||||
| 25 (milestone) | ||||||||
| 26 | ||||||||
| 27 | ||||||||
| 28 | ||||||||
| 29 | ||||||||
| 30 (milestone) |
Extra-Principal Scenarios (Reference)
Pre-computed on a $300,000 loan at 6.75% over 30 years (P&I about $1,946/month). Scale roughly with your balance; the percentages of interest saved hold across loan sizes at the same rate. Confirm extras are applied to principal, and in Canada check your annual prepayment allowance first.
| Extra per month | New payoff | Months saved | Interest saved |
|---|---|---|---|
| $0 (baseline) | 30 years 0 months | 0 | $0 (total interest about $400,500) |
| $50 | 27 years 9 months | 27 | About $36,000 |
| $100 | 25 years 11 months | 49 | About $65,000 |
| $200 | 23 years 0 months | 84 | About $110,000 |
| $500 | 17 years 5 months | 151 | About $190,000 |
Refinance and Renewal Log
One row per event. US: refinances. Canada: record every term renewal here too (no penalty at renewal), and include any IRD penalty paid in the closing-cost column if you broke a term early.
| Date | Old balance | New loan amount | New rate | New term | New payment | Closing cost paid | Breakeven month |
|---|---|---|---|---|---|---|---|
Equity Tracker (Annual Snapshot)
Once a year: estimated home value (appraisal, tax assessment, or comparable sales) minus the loan balance. US borrowers: PMI can usually be removed at roughly 20% equity.
| Year | Estimated home value | Loan balance | Equity ($) | Equity (%) | Notes |
|---|---|---|---|---|---|
Quick Reference: P&I per $1,000 Borrowed
Sanity-check any payment quote: multiply the factor by your loan amount in thousands. A $320,000 loan at 6.5% over 30 years is 320 x $6.32 = about $2,022/month before tax and insurance.
| Rate | 15-year term | 30-year term |
|---|---|---|
| 4.0% | $7.40 | $4.77 |
| 4.5% | $7.65 | $5.07 |
| 5.0% | $7.91 | $5.37 |
| 5.5% | $8.17 | $5.68 |
| 6.0% | $8.44 | $6.00 |
| 6.5% | $8.71 | $6.32 |
| 7.0% | $8.99 | $6.65 |
| 7.5% | $9.27 | $6.99 |
| 8.0% | $9.56 | $7.34 |
| Rule of 72 | What it tells you |
|---|---|
| 72 / interest rate = years to double | At 4% money doubles in about 18 years; at 6% about 12; at 8% about 9. Works for savings growth and for understanding why high-rate debt compounds so fast. |
| Canada renewal note | Rates reset at every term renewal (typically 5 years). Record the new rate and adjusted P&I in the Refinance and Renewal Log so the annual rows stay accurate across terms. |
Notes
Frequently Asked Questions
How do I use a mortgage amortization tracker?
Fill the mortgage snapshot once at the top (original loan, rate, term, monthly P&I, and the tax and insurance escrow lines), then add one row to the annual log each year: the balance you started the year with, the total principal-and-interest you paid, how that split between principal and interest (your year-end mortgage statement shows both), any extra principal you sent, and the ending balance. The milestone rows at years 5, 10, 15, 20, 25, and 30 are pre-marked so you can skim a decade of equity progress at a glance. Once a year, also add a row to the equity tracker: estimated home value minus loan balance.
How much does paying extra principal on a mortgage save?
More than almost any other routine financial move. On a $300,000 loan at 6.75% over 30 years (P&I about $1,946/month), an extra $100 per month pays the loan off 4 years early and saves about $65,000 of interest; $200/month saves 7 years and about $110,000; $500/month pays it off in roughly 17.5 years and saves about $190,000. The reference table on the sheet pre-computes these so you can pick a number and start. Two cautions: confirm your lender applies extras to principal (not next month's payment), and in Canada check your annual prepayment allowance (typically 10 to 20% of the original principal per year on closed mortgages) before sending large lump sums.
What should I record when I refinance or renew?
Use the refinance and renewal log: the date, old balance, new loan amount, new rate, new term, new payment, the closing costs you paid (including any Canadian IRD penalty), and the projected breakeven month (closing costs divided by monthly savings). Recording the breakeven at signing time is the honest accounting most refinancers skip: it tells future-you exactly when the refinance starts actually saving money. The refinance guide walks through the full decision, and Canadian renewals belong here too even though they are penalty-free: record the new rate and the adjusted P&I so the annual log stays accurate across terms.
Why track home equity separately from the loan balance?
Because equity moves for two reasons and the loan balance only captures one. Your balance falls with every principal payment on a known schedule, but the home's market value moves on its own, and the sum of the two effects is what a sale, a HELOC application, or a PMI-removal request actually cares about. One row a year (estimated value from an appraisal, a tax assessment, or comparable sales, minus the balance) is enough to see the trend, to know when US borrowers cross the roughly 20% equity line where PMI can be removed, and to keep renovation and refinance decisions anchored to real numbers. Pair it with the Net Worth Tracker for the full household picture.