Methodology
Version 1.2 · effective 2026-08-15
Every figure on this site comes from one of the four definitions below. Each carries its formula, its source series, how often it moves, how it is classified, and where it stops being reliable.
Insurelor Commercial Debt Rate Index
indicative rate = GoC 5-year benchmark + product spread (bps ÷ 100)
- Inputs
- Government of Canada 5-year benchmark bond yield from the Bank of Canada Valet API , plus a documented spread maintained by the Data Desk.
- Refresh cadence
- Benchmark refreshes each business day at 06:00 ET. Spreads are reviewed monthly.
- Provenance
- Benchmark: observed. Spread and resulting indicative rate: modelled.
- Known limits
- An index level is not a quote. It excludes lender fees, rate holds, prepayment structure, recourse, and covenant pricing, and it does not adjust for asset class or sponsor strength. Real quotes routinely land 50–150 bps either side of the index.
Insurelor Lender Density Score
score = min(100, round((lenders ÷ commercial buildings) × 10,000 × 12))
- Inputs
- Lender and broker count from the Insurelor lender census; commercial building count from the Insurelor building inventory built on Statistics Canada geography.
- Refresh cadence
- Census refreshes monthly; building inventory refreshes annually.
- Provenance
- Lender count: observed. Building inventory: observed. Score: modelled.
- Known limits
- The score measures how many firms are present, not how much capital they will deploy or how aggressively they price. A single very active lender can make a low-score market behave like a high-score one for a specific asset class.
Insurelor DSCR Stress Band
DSCR = NOI ÷ annual debt service · max loan = (NOI ÷ target DSCR) ÷ annual constant · break-even rate solved by bisection on DSCR = floor
- Inputs
- Product DSCR floor and amortization from the Insurelor product set; NOI implied by the market cap-rate seed applied to the average transaction size, or your own inputs in the calculators.
- Refresh cadence
- Product floors reviewed monthly; cap-rate seeds reviewed quarterly.
- Provenance
- Product floors: observed from lender term sheets. NOI implied from seeds: baseline seed. Coverage math: modelled.
- Known limits
- Coverage uses a constant-payment amortization and ignores interest-only periods, escrows, reserves, and cash traps. Lenders apply their own stressed rate — often the greater of the contract rate plus 100–200 bps or a floor — so a deal clearing here can still fail at credit.
Publishability gate (anti-doorway rule)
publishable = tierAllows(city, product) AND metricsRows(city, product) > 0
- Inputs
- City tier (1–3) and product tier (1–3). Tier 1 cities carry all products; tier 2 cities carry tier 1–2 products; tier 3 cities carry anchor products only.
- Refresh cadence
- Evaluated on every request, at render time.
- Provenance
- Deterministic rule, not a measurement.
- Known limits
- The gate governs indexation, not accuracy. A page can pass the gate and still be backed by baseline seeds — which is why provenance labels exist alongside it.
Provenance classes
How these figures were produced
- Observed — Recorded directly from the cited source series, unadjusted.
- Modelled — Derived arithmetically from observed inputs using the published method; not a market quote.
- Baseline seed — A documented starting estimate awaiting first observation. Treat as an order-of-magnitude figure only.
Revision log
v1.2 ·
Added provenance classes (observed / modelled / baseline seed) and required every published figure to carry one. Documented the coverage-versus-leverage binding test used on product-by-market pages.
v1.1 ·
Anti-doorway gate formalised: a product-by-market page is indexable only when the tier rule allows it and at least one metrics row backs it.
v1.0 ·
First publication of the Commercial Debt Rate Index, Lender Density Score, and DSCR Stress Band definitions.
Method changes are versioned here. Data corrections are logged separately.
Questions about the method
Why anchor to the GoC 5-year rather than to bank prime or CORRA?
Most Canadian fixed-rate commercial term debt is priced as a spread over the Government of Canada bond matching the term. Prime and CORRA drive floating-rate and construction pricing, which is why those products carry wider, separately maintained spreads.
Why is the density score capped at 100?
Above the cap, additional lenders per building stop changing borrower outcomes — a market with 40 bidders does not behave twice as competitively as one with 20. The cap keeps the top of the scale interpretable.
How is the break-even rate solved?
By bisection on the coverage equation with loan and NOI held constant: the rate is bracketed between 0.5% and 25% and halved 60 times until coverage equals the product's DSCR floor.
Can I reproduce these numbers myself?
Yes — that is the point. Every formula above is stated in full and every input is either cited to a public source or shown on the page. The calculators run the identical arithmetic on your own inputs.
Not advice — Insurelor is a data publisher. We do not sell, place, broker or advise on any product, and nothing here is a quote, an offer, or professional advice. Figures are indicative benchmarks for comparison and must be confirmed with a licensed professional before you rely on them. About Insurelor