Canada Housing And Property

Canadian Mortgage Stress Test & Affordability Calculator

Determine your true buying power under OSFI B-20 regulations and avoid mortgage rejection

#stress-test#osfi#mortgage#canada#affordability
P
Created by PromptLib Team
Published February 11, 2026
2,158 copies
3.9 rating
Act as a certified Canadian Mortgage Broker specializing in OSFI B-20 stress test regulations and CMHC guidelines. Conduct a comprehensive mortgage qualification analysis using the following data:

**INPUT VARIABLES:**
- Gross Annual Household Income: [ANNUAL_INCOME]
- Total Monthly Debt Payments: [MONTHLY_DEBTS] (car loans, student loans, credit cards, lines of credit - use minimum payments)
- Available Down Payment: [DOWN_PAYMENT] (include RRSP Home Buyers' Plan funds if applicable)
- Contract Interest Rate Offered: [CONTRACT_RATE] (e.g., 4.79%)
- Property Type & Location: [PROPERTY_TYPE] in [LOCATION] (affects taxes and heating estimates)
- Target Property Price: [TARGET_PRICE] (enter specific amount or 'CALCULATE_MAX' to find limit)
- Monthly Condo Fees: [CONDO_FEES] (enter 0 if house/townhouse without fees)
- Estimated Heating Costs: [HEATING_COST] (enter 'ESTIMATE' to use lender minimums: $100 house/$50 condo)
- Amortization Period: [AMORTIZATION] (25 or 30 years)

**CALCULATION REQUIREMENTS:**
1. Determine Qualifying Rate: Use the GREATER of ([CONTRACT_RATE] + 2%) OR (Current Bank of Canada Benchmark 5-Year Rate ~5.25%)
2. Calculate Gross Debt Service (GDS): (Mortgage Payment + Property Taxes + Heating + 50% of Condo Fees) / Gross Monthly Income. Must be ≤39%.
3. Calculate Total Debt Service (TDS): (GDS expenses + Other Monthly Debts) / Gross Monthly Income. Must be ≤44%.
4. If Down Payment <20%: Calculate CMHC insurance premium (2.8-4.0% based on LTV) and add to mortgage principal.
5. Calculate Maximum Mortgage: Using the Qualifying Rate (not contract rate) and GDS/TDS constraints.
6. Determine Maximum Purchase Price: Down Payment + Maximum Mortgage Amount.

**OUTPUT FORMAT:**
**Executive Summary**: Pass/Fail status for target price + Maximum affordable price
**Stress Test Analysis**: Contract rate vs Qualifying rate comparison, monthly payment differential
**Debt Ratios**: Detailed GDS and TDS breakdowns with percentages
**Affordability Matrix**: 
- Maximum mortgage qualified
- Required down payment for target
- CMHC premium (if applicable)
- Monthly carrying costs (PITH + condo fees)
**Cash Flow Buffer**: Remaining monthly income after housing costs and debts
**Risk Assessment**: 
- Rate exposure level (Low/Med/High)
- Vulnerability to 1-2% rate increases
- Recommendation on Fixed vs Variable
**Optimization Strategies**: 3 specific actions to improve qualification or reduce monthly burden

**CONSTRAINTS:**
- Use 2024-2025 OSFI B-20 guidelines
- Property taxes: Use provincial averages if specific municipality unknown (e.g., ON ~1%, BC ~0.25-1%, QC ~1.2%)
- Heating minimums: $100/month houses, $50/month condos
- Closing costs reminder: 1.5-4% of purchase price must remain in savings separate from down payment
Best Use Cases
First-time homebuyers determining realistic budgets before viewing homes and avoiding disappointment
Current homeowners stress-testing finances before renewing into higher interest rate environments
Real estate investors calculating maximum leverage capacity for rental property acquisitions
New immigrants with limited Canadian credit history understanding qualification requirements and alternative lending options
Couples combining incomes to determine optimal down payment strategy and joint qualification amounts
Frequently Asked Questions

More Like This

Back to Library

AI Home Insurance Calculator - Canada

This prompt transforms AI into an expert Canadian insurance advisor that calculates personalized home insurance premiums based on property details, provincial regulations, and specific risk factors. It provides comprehensive coverage breakdowns, identifies gaps, and offers actionable recommendations for homeowners across all Canadian provinces and territories.

#canada#home insurance+3
4,942
4.6

AI Multi-Family Analysis Tool

This prompt transforms raw property data into institutional-quality investment analysis tailored for the Canadian market. It evaluates cash flow projections, financing structures, regulatory compliance, and risk-adjusted returns while incorporating CMHC programs, provincial tenancy laws, and local market dynamics.

#real estate investment#multi-family housing+3
3,429
3.9

AI Property Portfolio Optimizer

This comprehensive prompt template transforms any AI into a specialized Canadian real estate investment analyst. It analyzes your current property holdings, market conditions, and financial goals to provide actionable strategies for portfolio optimization, tax efficiency, and risk management specific to Canadian housing regulations and provincial tax laws.

#real estate investing#canadian housing market+3
1,402
3.9
Get This Prompt
Free
Quick Actions
Estimated time:13 min
Verified by49 experts