Skip to content
100% Client-Side • Amortization Excel Export

Canadian Mortgage Stress Test Calculator

💡 Direct Answer: In Canada, OSFI requires homebuyers to qualify at their contract interest rate plus 2.00% (or the 5.25% floor). On a $600,000 home with 20% down ($120,000) and a 5.0% contract rate, you must qualify at 7.0%, requiring roughly $118,000 in gross household income.

Mortgage Calculator with Amortization Schedule

Calculate your total monthly mortgage payment including principal, interest, taxes, insurance, and PMI with full amortization schedule export.

SheetJS Export
$
$
%
Taxes, Insurance & Extra Payments
$
$
$

Shortens loan term & saves interest

Monthly Payment Breakdown

Total Monthly Payment
$3,842.54

Principal & Interest: $3,392.54 • Taxes: $350 • Insurance: $100

Loan Amount Financed
$480,000
Total Interest Paid
$537,762.06
Total Loan Cost (P+I)
$1,017,762.06
Payoff Time
25.1 Years (301 mos)
Loading interactive chart...
Amortization Schedule (26 Years)
Showing first 26 rows
PeriodPaymentPrincipalInterestTotal InterestBalance
Year 1$40,710.48$7,343.1$33,367.38$33,367.38$472,656.9
Year 2$40,710.48$7,873.93$32,836.55$66,203.93$464,782.97
Year 3$40,710.48$8,443.15$32,267.33$98,471.26$456,339.82
Year 4$40,710.48$9,053.51$31,656.97$130,128.23$447,286.31
Year 5$40,710.48$9,707.98$31,002.5$161,130.73$437,578.33
Year 6$40,710.48$10,409.78$30,300.7$191,431.43$427,168.55
Year 7$40,710.48$11,162.29$29,548.19$220,979.62$416,006.26
Year 8$40,710.48$11,969.22$28,741.26$249,720.88$404,037.04
Year 9$40,710.48$12,834.48$27,876$277,596.88$391,202.56
Year 10$40,710.48$13,762.27$26,948.21$304,545.09$377,440.29
Year 11$40,710.48$14,757.14$25,953.34$330,498.43$362,683.15
Year 12$40,710.48$15,823.95$24,886.53$355,384.96$346,859.2
Year 13$40,710.48$16,967.86$23,742.62$379,127.58$329,891.34
Year 14$40,710.48$18,194.47$22,516.01$401,643.59$311,696.87
Year 15$40,710.48$19,509.73$21,200.75$422,844.34$292,187.14
Year 16$40,710.48$20,920.11$19,790.37$442,634.71$271,267.03
Year 17$40,710.48$22,432.44$18,278.04$460,912.75$248,834.59
Year 18$40,710.48$24,054.07$16,656.41$477,569.16$224,780.52
Year 19$40,710.48$25,792.94$14,917.54$492,486.7$198,987.58
Year 20$40,710.48$27,657.52$13,052.96$505,539.66$171,330.06
Year 21$40,710.48$29,656.85$11,053.63$516,593.29$141,673.21
Year 22$40,710.48$31,800.77$8,909.71$525,503$109,872.44
Year 23$40,710.48$34,099.65$6,610.83$532,113.83$75,772.79
Year 24$40,710.48$36,564.73$4,145.75$536,259.58$39,208.06
Year 25$40,710.48$39,208$1,502.48$537,762.06$0.06
Year 26$0.06$0.06$0$537,762.06$0
National Benchmark Rates

Compare Top Mortgage & Refinance Rates

Estimated monthly principal & interest based on a $480,000 mortgage.

No SSN or Credit Pull Required
Loan ProductInterest RateAPREst. Monthly P&IAction
30-Year Fixed
6.68%6.75%$3,091/moCheck Rates
15-Year Fixed
5.92%6.04%$4,030/moCheck Rates
5/1 Adj. Rate (ARM)
6.18%6.55%$2,934/moCheck Rates
FHA / VA 30-Year
6.15%6.82%$2,924/moCheck Rates

Shop Multiple Lenders

Borrowers who compare 3+ quotes save an average of $84,000 over a 30-year term.

Points vs Zero-Cost

Paying discount points lowers your ongoing interest rate if you plan to stay 5+ years.

PMI Removal Rules

Request private mortgage insurance cancellation as soon as your loan-to-value reaches 80%.

Advertising & Affiliate Disclosure: ConvertSheet is an independent educational calculation service and may receive compensation from partner financial institutions when users click to compare rates. Zero client data or calculated figures are ever shared.

Advertisement / Sponsored

Horizontal Responsive (Responsive Banner)

About Canadian Mortgage Stress Test Calculator

Under Canada's Office of the Superintendent of Financial Institutions (OSFI) B-20 guidelines, all insured and uninsured residential mortgages must pass a qualifying stress test. ConvertSheet models both your actual contractual monthly payment and the stress-tested qualifying threshold, ensuring Canadian prospective buyers understand their debt service ratios (GDSR / TDSR) and can export full Canadian amortization tables to Excel.

Related Mortgage Calculator & Amortization Schedule Calculations

Help & Documentation

Frequently Asked Questions: Canadian Mortgage Stress Test Calculator

Clear mathematical answers to key questions, calculations, and loan parameters.

What is the mortgage stress test in Canada?

The Canadian mortgage stress test proves you can afford loan payments if interest rates rise. You must qualify at either the Bank of Canada benchmark rate (5.25%) or your lender's contract rate plus 2%, whichever is higher.

Why is the typical Canadian amortization 25 years instead of 30 years?

In Canada, high-ratio insured mortgages (down payment under 20%) are legally capped at a maximum 25-year amortization period by CMHC and the federal government.