Mortgage amortization schedule (Canada)
Payments, interest and yearly balance with Canadian semi-annual compounding, accelerated payments and annual prepayments. Download as Excel or CSV.
Input
How to use this tool
- Enter your values or choose a local file. Replace the example data with your own.
- Review options, units and assumptions, then run the tool.
- Check the result before copying or downloading it. Keep an original copy of important files.
Method & assumptions
Payments, interest and yearly balance with Canadian semi-annual compounding, accelerated payments and annual prepayments. Download as Excel or CSV.
periodic rate = (1 + r/2)^(2/n) − 1; accelerated = monthly payment ÷ 2 or ÷ 4Worked example
Mortgage amount: 500,000 Interest rate (%): 4.29 Amortization (years): 25 Payment frequency: Monthly Extra lump sum each year: 0 Download as: Excel workbook (.xlsx) → Payment: CAD 2,709.29 → Total interest: CAD 312,788.01 → Paid off in: 25 years
Limits & important notes
Basic release. Review the result before relying on it. File limits, supported cases and processing requirements are shown above.
Content updated:
Privacy & Free to use
Are my inputs stored?
Your inputs stay in this tab. We do not receive your files, pasted text or calculation values.
Is this tool free?
Yes. No signup or payment is required.
Useful next steps
Mortgage stress test calculator Canada
How much mortgage you qualify for under the stress test (greater of your rate + 2% or 5.25%) with GDS 39% and TDS 44%.
Home & mortgage · CanadaCMHC mortgage insurance calculator
Minimum down payment, CMHC premium, total mortgage and provincial tax on the premium for purchases under $1.5M.
Home & mortgage · CanadaLand transfer tax calculator Canada 2026
Land transfer tax for Ontario, Toronto, BC, Quebec, Montréal, Manitoba, New Brunswick, PEI and Nova Scotia, with first-time buyer rebates.
Home & mortgage · Canada