DSCR
NOI ÷ debt service with **`max(annualDebtService, 1)`**—mirrors underwriting worksheets without exposing loan tape detail.
Example scenario
An anchored neighborhood retail strip publishes trailing-twelve stabilized net operating income near one hundred eighteen thousand dollars after landlord reimbursements but before corporate overhead allocations unrelated to the borrowing entity. Senior financing amortizes principal-and-interest burden near eighty-six thousand five hundred dollars annually—capturing fixed-rate senior coupon plus scheduled amortization before supplemental mezzanine feeds modeled offline. Dividing property-level NOI by contractual debt service yields debt service coverage near one point three six times—leaving roughly thirty-one thousand five hundred dollars of cash after scheduled debt before capex reserves lenders sweep separately into escrow waterfalls.
DSCR
Annual NOI ÷ annual debt service
Want a similar calculator on your website?
Describe your fields and formula in plain English, match your brand, and embed the widget anywhere—WordPress, Webflow, Shopify, or custom HTML. Capture leads when you're ready.
How to calculate debt service coverage ratio from NOI and P&I
- Compile annual NOI consistent with lender underwriting—exclude mortgage payments already baked into debt-service denominator while normalizing vacancy and credit loss assumptions.
- Sum annual debt service as scheduled principal and interest per amortization tables—add required reserves only when loan agreements capitalize replacement draws into DSCR tests explicitly.
- Divide NOI by debt service—minimum one-dollar denominator protects spreadsheet QA while stress-testing tiny facilities.
- Compare surplus cash after debt service against capex, leasing commissions, and partnership distributions—positive surplus alone never proves liquidity without reserve waterfall clarity.
How lenders benchmark DSCR against covenant floors
- Typical stabilized CRE covenant bands
- Life-company and agency lenders frequently underwrite stabilized assets toward minimum one point two zero to one point two five times DSCR—exact triggers vary by leverage point, recourse, and tenant credit
- NOI normalization discipline
- Underwriting trims one-time recoveries and non-recurring expenses—model stress NOI haircuts before relying on trailing-twelve prints lifted by litigation settlements
- Interest-only versus amortizing debt service
- IO periods inflate headline DSCR until amortization resumes—compare constant debt-service ladders across refinance horizons rather than spot months
Best use cases
- Forecasting and scenario planning
- Client education and pre-qualification
- Budget and performance decision support
Frequently asked questions
Should annual NOI match GAAP net income?
Rarely—NOI strips depreciation and corporate allocations while focusing property-level income—sync definitions with lender appraisal packets rather than corporate consolidated statements alone.
Where do balloon payments belong in annual debt service?
Model balloon years explicitly—straight-line amortization understates spike risk unless refinance assumptions accompany maturity schedules.
Why cap debt service at one dollar minimum in the divisor?
Avoid divide-by-zero artifacts during sensitivity toggles—still interpret infinite-looking coverage skeptically when scenarios toy with zero debt.
Does strong DSCR eliminate refinance risk?
No‒01market shifts, tenant rollover, and appraisal haircuts still threaten liquidity—pair ratio tests with loan-to-value and debt yield analytics banks publish alongside DSCR.
Glossary
Scenario modeling
Testing multiple assumptions to estimate possible outcomes before execution.
Commercial intent
User behavior indicating readiness to buy, subscribe, or request a quote.
Related calculators
Category: Commercial real estate finance & debt underwritingTopics: Debt service coverage ratio, Net operating income, Commercial mortgage underwriting
Last reviewed: 2026-05-07
Reviewed by: Calclet Growth Team