CapRate Analyzer v8 — Allen Ehlert

CapRate Analyzer

Investor-grade screening: cap rate, benchmarks, valuation, DSCR (Canadian compounding), CMHC insurance, sensitivity, and rankings.

Decision: —

Grade: —

Score: — / 100

Risk: —

Completeness: —

Fast Screen

—

NOI gap vs benchmark: —

Inputs

Benchmarks screen deals fast. DSCR confirms whether the income can carry a mortgage.

Property Label

Location (optional)

Value / Purchase Price (CAD)

Units

Avg Monthly Rent per Unit (CAD)

Other Income (Annual CAD)

Vacancy Rate (%)

Property Taxes (Annual CAD)

Insurance (Annual CAD)

Utilities (Annual CAD)

Repairs & Maintenance (Annual CAD)

Condo Fees (Annual CAD)

Property Mgmt (Mode)

Property Mgmt (%, or Annual CAD)

CapEx Reserve (Mode)

CapEx Reserve (%, or Annual CAD)

Benchmark Cap Rate (%)

5-Year Bond Yield (%)

Market Posture Preset (core / balanced / yield)

Target Cap Rate (%)

Market Cap Range — Low (%)

Market Cap Range — High (%)

Snow/Landscaping (Annual CAD)

Admin / Accounting / Legal (Annual CAD)

Miscellaneous (Annual CAD)

Rent Haircut (Stress) (%)

Vacancy Add-on (Stress, pp)

OpEx Increase (Stress, %)

Expense Floor (Mode)

Expense Floor (% of EGI)

DSCR & Financing

DSCR uses NOI ÷ annual debt service (Canadian semi-annual compounding per Interest Act). Stress DSCR applies max(contract+2%, OSFI B-20 floor of 5.25%) to the stress NOI.

LTV (%)

Amortization (years)

Contract Rate (%, nominal semi-annual)

Payment Frequency

Stress Rule (max of…): Buffer (pp)

Stress Floor / OSFI B-20 (%)

CMHC Mortgage Insurance

When enabled, the CMHC premium is added to the loan principal and reflected in debt service. Applies to insured purchases with <20% down and purchase price <$1.5M (Homeowner & Small Rental — 1 to 4 units only; cap raised from $1M effective Dec 15, 2024). Minimum down payment: 5% on first $500K + 10% on the amount above $500K. Maximum amortization: 25 years for income/investment property; 30 years only for first-time buyers or new builds (surcharge +0.20% applies). Rates: CMHC Homeowner & Small Rental schedule — confirm at cmhc-schl.gc.ca before advising clients.

Apply CMHC Mortgage Insurance to loan

One-Click Sensitivity

3×3 grid: Rent ±5% × Vacancy ±2pp. Choose OpEx stress (−5% / base / +5%). DSCR row (below divider) shows debt-service coverage at each rent level — debt service is held constant across all cells.

Show Cap Show NOI

Tip: Use DSCR + the sensitivity grid to decide whether a deal is sturdy enough to deserve deeper underwriting.

Market Lens

Benchmark against expectations

Cap Rate

—

NOI ÷ Value
—

Spread vs Benchmark

—

Subject − Benchmark
—

Position vs Market Range

—

Low–High
—

Operating Lens

Income quality & durability

Net Operating Income

—

Annual NOI
—

Expense Ratio

—

OpEx ÷ EGI
—

Break-Even Vacancy

—

Vacancy at NOI = 0
—

Financing Lens

DSCR confirms debt service support (Canadian semi-annual compounding)

DSCR

—

NOI ÷ Debt Service
—

DSCR (Stress)

—

Stress NOI ÷ Stress DS
—

CMHC Premium

—

Premium on insured loan
—

Valuation Lens

Estimate value from income

Implied Value (Benchmark Cap)

—

NOI ÷ Benchmark
—

Target Purchase Price (Target Cap)

—

NOI ÷ Target
—

Quick Triage

Fast screens before deeper analysis

NOI Margin

—

NOI ÷ GSI
—

Gross Rent Multiplier

—

Value ÷ GSI
—

Cap Rate (Stress)

—

Rent ↓ / Vacancy ↑ / OpEx ↑
—

NOI Required (at Benchmark Cap)

—

Value × Benchmark
—

Spread vs 5-Year Bond

—

Cap − Bond
—

Sensitivity Grid

Rent ±5% × Vacancy ±2pp (OpEx selectable)

Cap Rate

Columns = Rent shock (−5%, 0, +5%). Rows = Vacancy shock (−2pp, 0, +2pp). OpEx shock uses the selector in Advanced. DSCR row (below divider): base vacancy, each rent column — debt service held constant.

Opportunity Ranking

Auto-ranks properties using score + data-quality penalty

#	Property	Score	Grade	Cap	Spread	Exp Ratio	BE Vacancy
Add properties to compare to see rankings.

Disclosure: Educational screening only. Results depend on verified rents, lease terms, vacancy, CapEx needs, and local market conditions. Mortgage calculations use Canadian semi-annual compounding per the federal Interest Act. CMHC premium rates are based on the published Homeowner & Small Rental schedule. Copyright (c) Allen Ehlert Inc., 2026.