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

Canadian Mortgage Stress Test Calculator

Key Financial Facts & Estimates (At a Glance)
Monthly P&I Payment$3,393/mo
Total Lifetime Interest$537,762
Total Loan Cost$1,017,762
Recommended Income (28% DTI)$145,395/yr

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
100% Client-Side In-Browser Computation • No loan or financial data leaves your browser
Updated for October 2026 Freddie Mac PMMS (October 25, 2026): 30-Year Fixed at 7.32%, 15-Year Fixed at 6.68% (10-Yr Treasury 5.00%, Fed Funds Target 3.75%–4.00%)
$
Home price slider$600,000
$50000 $2000000
$
Down payment percentage slider20 %
0 %50 %
%
Mortgage interest rate slider7 %
2 %14 %
Taxes, Insurance & Extra Payments
$
$
$

Shortens loan term & saves interest

Monthly Payment Breakdown

Total Monthly Payment
$3,843

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

Loan Amount Financed
$480,000
Total Interest Paid
$537,762
Total Loan Cost (P+I)
$1,017,762
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
Private & Secure: 100% computed in browser. Zero data or files sent to servers.
National Benchmark Rates • Freddie Mac PMMS (October 2026)

Compare Top Mortgage & Refinance Rates

Estimated monthly principal & interest based on a $480,000 mortgage. Primary source: Freddie Mac PMMS (October 2026).

No SSN or Credit Pull Required
Loan ProductInterest RateAPREst. Monthly P&IAction
30-Year Fixed
7.40%7.48%$3,323/moCheck Rates
15-Year Fixed
6.71%6.84%$4,237/moCheck Rates
5/1 Adj. Rate (ARM)
6.65%7.15%$3,081/moCheck Rates
FHA / VA 30-Year
6.85%7.35%$3,145/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.

Side-by-Side Analysis

15-Year vs. 30-Year Mortgage Side-by-Side

Compare monthly payments against lifetime interest costs on a $480,000 loan.

Quick Amounts:
Total Interest Saved with 15-Year
$372,424
Save 60.8% on total interest
Monthly payment is +$965 higher
Monthly Payment Burden+$965/mo on 15-Yr
15-Year Fixed (5.8%)$3,999/mo
30-Year Fixed (6.5%)$3,034/mo
Lifetime Interest CostSave $372,424
15-Year Fixed (Interest)$239,790
30-Year Fixed (Interest)$612,214
Financial Metric15-Year Fixed (5.8%)30-Year Fixed (6.5%)Difference
Monthly P&I Payment$3,999$3,034+$965 /mo
Total Interest Paid$239,790$612,214-$372,424
Total Cost of Mortgage$719,790$1,092,214-$372,424
Payoff Timeframe180 Months (15 Yrs)360 Months (30 Yrs)15 Years Sooner

15-Year Forced Discipline vs. 30-Year Payment Flexibility

✓ Choose 15-Year Fixed for Forced Wealth Accumulation

Guarantees full debt freedom in 15 years while saving $372,424 in interest. Ideal for stable, high-earning households where the +$965/mo higher payment stays below 28% of monthly income.

✓ Choose 30-Year Fixed with Voluntary Prepayment

Protects cash-flow with a lower required payment ($3,034/mo). You can voluntarily apply the extra $965/mo toward principal when finances allow, achieving a 15-year payoff without strict obligation.

Total Monthly Payment$3,843/mo
💡 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.

Side-by-Side Term Comparison: Canadian Mortgage Stress Test Calculator

Loan TermEst. APRMonthly PaymentTotal InterestTotal Loan Cost
15-Year Fixed6.4%$4,155/mo$267,895$747,895
20-Year Fixed6.7%$3,635/mo$392,518$872,518
30-Year Fixed (Standard)7%$3,193/mo$669,643$1,149,643
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.

Formula & Computation Model
Exact Computation
Monthly P&I = P * [r(1+r)^n] / [(1+r)^n - 1]
Variable Definitions:
P = Principal Loan Amountr = Monthly Interest Rate (Annual Rate / 12)and n = Total Number of Payments (Months).

Related Mortgage Calculator & Amortization Schedule Calculations

$150,000 Mortgage Payment Calculator$175,000 Mortgage Payment Calculator$225,000 Mortgage Payment Calculator$200,000 Mortgage Payment Calculator$250,000 Mortgage Payment Calculator$300,000 Mortgage Payment Calculator$350,000 Mortgage Payment Calculator$400,000 Mortgage Payment Calculator$500,000 Mortgage Payment Calculator$600,000 Mortgage Payment Calculator$700,000 Mortgage Payment Calculator$750,000 Mortgage Payment Calculator$800,000 Mortgage Payment Calculator$900,000 Mortgage Payment Calculator$1,000,000 Jumbo Mortgage Calculator$1.5 Million Jumbo Mortgage Calculator$2 Million Jumbo Mortgage Calculator15-Year vs 30-Year Mortgage Calculator20-Year Fixed Mortgage Calculator30-Year Fixed Rate Mortgage Calculator5/1 ARM Adjustable Rate Mortgage CalculatorTexas Mortgage & Property Tax CalculatorCalifornia Mortgage & Prop 13 Tax CalculatorFlorida Mortgage & Insurance CalculatorNew York Mortgage & Property Tax CalculatorNew Jersey Mortgage & Property Tax CalculatorIllinois Mortgage & Property Tax CalculatorPennsylvania Mortgage & Property Tax CalculatorOhio Mortgage & Property Tax CalculatorUK 2-Year & 5-Year Fixed Mortgage Calculator$500,000 Canada Mortgage Calculator (OSFI Stress Test & CMHC)$750,000 Canada Mortgage Calculator (Toronto & Vancouver Benchmark)$1,000,000 Canada Mortgage Calculator (Uninsured Jumbo)£300,000 UK Mortgage Repayment Calculator£400,000 UK Mortgage Repayment Calculator (London & South East)£600,000 UK Mortgage Repayment CalculatorSalary Needed for a $400,000 MortgageSalary Needed for a $500,000 MortgageSalary Needed for a $1 Million Dollar HomeIncome Needed to Buy a House in New YorkIncome Needed to Buy a House in California$500,000 Mortgage Payment Calculator (30-Year Fixed)$700,000 Mortgage Payment Calculator (30-Year Fixed)15 vs 30 Year Mortgage Calculator$275,000 Mortgage Payment Calculator (30-Year Fixed)$325,000 Mortgage Payment Calculator (30-Year Fixed)$375,000 Mortgage Payment Calculator (30-Year Fixed)$425,000 Mortgage Payment Calculator (30-Year Fixed)$475,000 Mortgage Payment Calculator (30-Year Fixed)$525,000 Mortgage Payment Calculator (30-Year Fixed)$550,000 Mortgage Payment Calculator (30-Year Fixed)$600,000 Mortgage Payment Calculator (30-Year Fixed)$650,000 Mortgage Payment Calculator (30-Year Fixed)$750,000 Mortgage Payment Calculator (30-Year Fixed)$800,000 Mortgage Payment Calculator (30-Year Fixed)$850,000 Mortgage Payment Calculator (30-Year Fixed)$900,000 Mortgage Payment Calculator (30-Year Fixed)$950,000 Mortgage Payment Calculator (30-Year Fixed)$1,000,000 Mortgage & Commercial Real Estate Loan Calculator$1,100,000 Mortgage Payment Calculator (30-Year Fixed)$1,200,000 Mortgage Payment Calculator (30-Year Fixed)
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.

Free Embeddable Widget

Add Mortgage Calculator & Amortization Schedule to Your Website or Blog

Enhance your financial articles, portals, or docs with this interactive calculator. 100% free, responsive, zero backend required.

All 50+ Widgets