Mortgage Calculator
Canadian semi-annual compounding with a full amortization schedule.
Also available as an Excel template — $9
One-time purchase · 1 download · works in Excel and Google Sheets. Sample data below is not saved.
Each payment
$3,659
$3,659 per month equivalent
Mortgage amount
$642,200
Total interest
$455,400
Total cost
$1,097,600
| Year | Starting balance | Principal paid | Interest paid | Ending balance |
|---|---|---|---|---|
| 1 | $642,200 | $13,741 | $30,163 | $628,459 |
| 2 | $628,459 | $14,407 | $29,497 | $614,051 |
| 3 | $614,051 | $15,106 | $28,798 | $598,945 |
| 4 | $598,945 | $15,838 | $28,066 | $583,107 |
| 5 | $583,107 | $16,606 | $27,298 | $566,502 |
| 6 | $566,502 | $17,411 | $26,493 | $549,091 |
| 7 | $549,091 | $18,255 | $25,649 | $530,836 |
| 8 | $530,836 | $19,140 | $24,764 | $511,697 |
| 9 | $511,697 | $20,067 | $23,837 | $491,629 |
| 10 | $491,629 | $21,040 | $22,864 | $470,589 |
| 11 | $470,589 | $22,060 | $21,844 | $448,529 |
| 12 | $448,529 | $23,129 | $20,775 | $425,400 |
| 13 | $425,400 | $24,250 | $19,654 | $401,150 |
| 14 | $401,150 | $25,426 | $18,478 | $375,724 |
| 15 | $375,724 | $26,658 | $17,246 | $349,065 |
| 16 | $349,065 | $27,951 | $15,953 | $321,115 |
| 17 | $321,115 | $29,306 | $14,599 | $291,809 |
| 18 | $291,809 | $30,726 | $13,178 | $261,083 |
| 19 | $261,083 | $32,215 | $11,689 | $228,868 |
| 20 | $228,868 | $33,777 | $10,127 | $195,091 |
| 21 | $195,091 | $35,414 | $8,490 | $159,676 |
| 22 | $159,676 | $37,131 | $6,773 | $122,545 |
| 23 | $122,545 | $38,931 | $4,973 | $83,615 |
| 24 | $83,615 | $40,818 | $3,086 | $42,797 |
| 25 | $42,797 | $42,797 | $1,107 | $0 |
This platform provides financial planning tools and calculations for informational and educational purposes only. It does not provide financial, investment, tax, legal or mortgage advice. Results are based on user-provided information and assumptions. Contribution limits, tax rates and regulatory parameters reflect the rules in effect as of the latest update (2026) and may change; always verify official amounts with the CRA or a licensed professional.