FINANCIAL MODELING
DSCR Calculator and Formula: Debt Service Coverage Ratio for Commercial Real Estate (2026)
Key Takeaways
- DSCR = NOI ÷ Annual Debt Service. A property generating $5.0M of NOI with $3.79M of annual debt service produces a 1.32x DSCR — the institutional minimum for most CMBS conduit and agency multifamily deals sits in the 1.20–1.25x range.
- Annual debt service is not interest expense. For an amortizing loan, it is
PMT(rate/12, n_months, −loan) × 12. During an interest-only period, it israte × loan. Confusing the two understates debt service by 30–50% and overstates DSCR. - The same $50M loan looks fine at IO and binds at amortization. The widget below makes that visible — toggle the IO period to see year-1 DSCR drop into the danger zone once the amortizing leg kicks in.
- 2026 rate environment. 10-year UST at ~4.20–4.40%; agency multifamily take-out at 5.75–6.25% all-in; CMBS conduit at 5.75–6.50%; bridge at 7.50–9.50%. 2021–2022 vintage loans sized at 3.5% are refinancing into a DSCR gap of roughly 0.35–0.45x on the same NOI.
- DSCR is one of three sizing constraints — not the only one. Lenders also size to LTV and debt yield. In the 2024–2026 environment, debt yield often binds before DSCR. Run all three; the constraint that binds is rarely the one the broker is selling.
A note on terminology. "DSCR loan calculator" (~3,600 searches/month) is a separate query that attracts residential single-family and non-QM mortgage shoppers — the cohort buying a $300,000 rental house and qualifying for a Griffin Funding, Angel Oak, Newfi, or FundLoans loan based on the property's rent rather than personal income. This is not that calculator. If you are shopping for a DSCR loan on a rental house, the lender pages cited above are the correct destinations. This article is for institutional commercial real estate practitioners sizing debt on multifamily, industrial, office, retail, or hospitality acquisitions — loans typically $5M and up, originated by agency lenders (Fannie, Freddie), CMBS conduits, life insurance companies, banks, debt funds, and bridge lenders.
Calculate Your DSCR
Enter your NOI, loan amount, interest rate, amortization, and IO period. The calculator computes annual debt service via PMT on the amortizing portion, then divides NOI by debt service to produce DSCR. The 3×3 grid below the primary outputs stresses the result across NOI shocks (±15%) and rate shocks (±100 bps).
Stressed Sensitivity: DSCR at NOI × Rate
| Rate −100 bps | Base Rate | Rate +100 bps | |
|---|---|---|---|
| NOI +15% | — | — | — |
| Base NOI | — | — | — |
| NOI −15% | — | — | — |
DSCR ≥ 1.30x (lender comfort) DSCR < 1.20x (below most institutional minimums)
Want this run across every term sheet in parallel — amortizing vs IO, stressed scenarios, all lender minimums compared on one screen? Try Apers free →
BUILD IT IN APERS
Apers sizes DSCR across every term sheet in parallel — amortizing vs IO, stressed scenarios, all lender minimums compared. Every formula auditable. Try Apers free →
Or start in a pocket model: AQ-110 (multifamily) → · AQ-141 (opportunistic with bridge) → · AQ-301 (anchored retail) →
What DSCR Measures
The debt service coverage ratio measures how comfortably a property's net operating income covers its annual debt service. The formula is short:
DSCR = NOI ÷ Annual Debt Service
A property generating $5,000,000 of NOI with $3,787,000 of annual debt service produces a 1.32x DSCR — meaning NOI covers debt service 1.32 times over. The reciprocal interpretation is the safety cushion: 1.32x means NOI could fall to roughly 76% of in-place ($1 ÷ 1.32) before the property fails to cover its own debt payments. That cushion is what lenders are buying.
The hard part is not the ratio — it is the two numbers feeding into it. NOI is in-place income net of operating expenses, with replacement reserves typically held below the line; broker NOIs and institutional NOIs often differ by 5–10%, which propagates one-for-one into DSCR. Annual debt service is the loan's principal-plus-interest payment, computed from the loan amount, the interest rate, the amortization schedule, and any interest-only period. Most practitioner errors in DSCR come from misstating one of these two inputs, not from the division.
For the full formula derivation, the constraint hierarchy against LTV and debt yield, and the institutional sizing methodology, see the deeper sibling article: DSCR Sizing Constraints: Amortizing vs Interest-Only. This article focuses on the calculator and the practitioner interpretation.
How to Use This Calculator
The widget's default inputs reproduce a benchmark deal: a $50M loan on a $5M-NOI property at 6.50% with 30-year amortization and no IO period. The math: monthly rate is 0.5417% (6.50% ÷ 12); over 360 months, the PMT calculation produces a monthly payment of approximately $315,613, or roughly $3,787,000 per year. DSCR = $5,000,000 ÷ $3,787,000 ≈ 1.32x. That sits inside the institutional comfort zone for agency multifamily and CMBS conduit but is below the 1.35–1.50x range that life insurance companies typically require.
Toggle the IO period. Change the IO from 0 to 36 months. The widget reports two debt service numbers: an interest-only debt service during the IO years (rate × loan) and an amortizing debt service after IO expires. With a $50M loan at 6.50%, the IO debt service is $3,250,000 (DSCR 1.54x), while the post-IO amortizing debt service rises to approximately $3,787,000 (DSCR 1.32x) — assuming a 30-year original amortization. The same loan, the same NOI, but a 22-basis-point swing in DSCR depending on which leg you are pricing. Lenders size to the amortizing leg. The IO period is a cash-flow benefit to the sponsor in years 1–3, not a sizing benefit.
Read the 3×3 grid. The sensitivity table stresses two variables independently: NOI (±15%, capturing the broker-vs-institutional NOI risk and a recession scenario) and rate (±100 bps, capturing the typical stressed-rate convention agency lenders use). Cells flagged red show combinations where DSCR drops below 1.20x — the threshold where most institutional lenders refuse to size. Cells flagged green show DSCR at 1.30x or higher, comfortably inside life-company and conduit minimums. The center cell is your base case. The institutional question is not "what is base DSCR?" — it is "how many cells in this grid are red, and are any of them plausible?"
Institutional DSCR Minimums
Different lender types apply different DSCR floors. The ranges below cover the most common 2026 conventions for stabilized core and core-plus assets; construction and transitional debt vary case by case. For the full lender-by-lender treatment, including stressed-rate conventions and how minimums shift by asset class, see the sizing constraints sibling article.
| Lender Type | Typical DSCR Minimum | Stressed-Rate Convention |
|---|---|---|
| CMBS Conduit | 1.20–1.25x | Usually note rate; some SASB pools 1.20x |
| CMBS Single-Asset / Single-Borrower | 1.25–1.35x | Note rate; conservative on lower DSCR pools |
| Agency Multifamily (Fannie / Freddie) | 1.20–1.55x | Note rate +100–300 bps; lower of the two |
| Bank (Regional / Money-Center) | 1.25–1.40x | Variable; often note rate or note +50–100 |
| Life Insurance Company | 1.30–1.50x | Note rate; conservative on lower-DSCR deals |
| Debt Fund / Bridge | 1.10–1.20x | Often interest-only sized; stabilized take-out tested |
Institutional DSCR minimums by lender type, May 2026. Ranges reflect stabilized core / core-plus underwriting; transitional and construction debt apply different conventions. Sources: Mortgage Bankers Association quarterly survey data; Boulder Group net lease lender survey; AdventuresinCRE institutional sizing notes.
Amortizing vs IO: Why the Choice Matters
The single most common DSCR mistake in institutional underwriting is sizing the loan on interest-only debt service when the loan amortizes. A $50M loan at 6.50% interest-only carries $3.25M of debt service. The same loan on a 25-year amortization at the same rate carries $4.07M of debt service. At a $5.0M NOI, the IO DSCR is 1.54x and the 25-year amortizing DSCR is 1.23x — the difference between "comfortable" and "barely qualifies." On the same NOI, an IO-sized loan can be roughly 20–25% larger than an amortizing-sized loan at the same DSCR target. That is why the loan-to-cost looks generous in the term sheet and binds at IC.
Lenders know this. Agency multifamily and CMBS conduit lenders typically size to the amortizing debt service even when the loan has an IO period for the first 3–5 years. The IO is a cash-flow accommodation to the sponsor — not a sizing concession. The full worked example, including the $50.4M vs $61.5M sized-loan comparison at the same 1.30x DSCR target across 25-year amortizing and full-term IO structures, lives in the sizing constraints article. Use this calculator to spot-check; use the sibling article to understand why the convention exists and how to negotiate against it.
Common Mistakes in DSCR Calculation
-
Using broker pro forma NOI instead of in-place NOI. Brokers normalize T-12 to a "stabilized" number by excluding bad months, marking vacancy to submarket, normalizing management fees to "market," and assuming rent growth that is already in the price. The institutional lender rebuilds NOI from the actual T-12 with bad months in. A pro forma DSCR of 1.30x is frequently an in-place DSCR of 0.95–1.05x. The deal binds at credit committee, not at LOI.
-
Computing DSCR on interest-only debt service when the loan amortizes. Year 1 looks fine at 1.50x; year 4 binds at 1.22x once the amortizing leg kicks in. Lenders size to the amortizing payment, not the IO payment — check the term sheet language explicitly. Sponsors who size deals on IO DSCR alone are systematically over-levering.
-
Using gross potential rent instead of effective gross income. NOI is built from EGI: gross rent + other income, less vacancy and credit loss. Building NOI from gross rent without deducting vacancy overstates NOI by the full vacancy rate — typically 5–8% for stabilized multifamily, more for office and retail. DSCR moves one-for-one with NOI, so this single error propagates directly into the ratio.
-
Mishandling replacement reserves. Institutional convention (NCREIF, MBA reporting standards) holds replacement reserves below the NOI line. Some lender term sheets require reserves to be deducted from NOI for DSCR purposes (typically $300–$400 per unit per year for multifamily; more for hospitality and office). Read the term sheet language — if reserves are above the line for DSCR purposes, the calculation produces a lower DSCR than the broker quote.
-
Ignoring stressed-rate sizing for agency loans. Fannie Mae and Freddie Mac both size to the lower of (a) DSCR at the in-place note rate and (b) DSCR at the note rate plus a stress add-on (typically +100–300 bps depending on the product). In the current rate environment, the stressed test almost always binds. A deal sized to a 1.30x note-rate DSCR can fail at a 1.20x stressed DSCR — the agency cuts proceeds until the stressed test passes.
-
Confusing DSCR with interest coverage ratio. ICR = NOI ÷ interest expense. DSCR = NOI ÷ debt service (interest plus principal). A 1.50x ICR on a 30-year amortizing loan corresponds to roughly a 1.20–1.25x DSCR — meaningfully tighter. Project-finance and corporate-banking audiences sometimes quote DCR (debt coverage ratio) interchangeably with DSCR; in CRE the two are synonyms, but watch for ICR slipping in as a proxy.
-
Treating DSCR as the only sizing constraint. Lenders size to the most restrictive of DSCR, LTV, and debt yield. In low-cap-rate / high-leverage markets, LTV usually binds. In high-rate / cap-rate-flat markets like 2024–2026, debt yield often binds before DSCR — agency multifamily requires 7.5–9.0% debt yield minimums and CMBS conduit requires 8.0–10.0%. Run all three constraints; the binding one drives the loan amount.
Related Articles
The DSCR calculator pillar links into the broader debt analysis and valuation clusters on Apers Learn:
- DSCR Sizing Constraints: Amortizing vs Interest-Only — the methodology sibling. Full institutional treatment of how DSCR binds in real deals: constraint hierarchy against LTV and debt yield, lender-by-lender minimums, the 25-year amortizing vs IO worked example showing $50.4M vs $61.5M sized at the same DSCR target, and the stressed-rate sizing discipline.
- NOI Calculator and Formula — the input that drives the numerator of DSCR. Includes the institutional NOI vs broker NOI distinction that propagates into DSCR.
- Cash-on-Cash Return Calculator and Formula — the levered cash-flow metric that pairs with DSCR. Once the loan is sized, cash-on-cash measures the equity yield.
- Cap Rate Calculator and Formula — the unlevered yield that sets the LTV constraint. Cap rate, DSCR, and debt yield together drive the sizing decision.
- IRR Calculator and Formula for Real Estate — the multi-year levered return that incorporates the loan sized via DSCR.
FAQ
Frequently Asked Questions
What is a good DSCR ratio for commercial real estate?
It depends on lender type and asset class. CMBS conduit and agency multifamily typically require 1.20–1.25x. Banks require 1.25–1.40x. Life insurance companies require 1.30–1.50x. Bridge and debt fund debt operates on 1.10–1.20x. A DSCR of 1.30x is broadly comfortable across most institutional lenders; below 1.20x is below most minimums; above 1.50x is typically over-collateralized in current market conditions.
How do you calculate DSCR?
Divide net operating income by annual debt service. NOI is in-place gross income less vacancy, credit loss, and operating expenses (with replacement reserves typically held below the line). Annual debt service for an amortizing loan is PMT(rate/12, n_months, –loan) × 12. For an interest-only loan, debt service is rate × loan. DSCR = NOI ÷ Debt Service. Example: $5,000,000 NOI ÷ $3,787,000 debt service = 1.32x DSCR.
What is the formula for DSCR?
DSCR = NOI ÷ Annual Debt Service. The numerator is institutional net operating income — gross revenue, less vacancy and credit loss, less operating expenses, with capital reserves below the line. The denominator is annual principal and interest payments. For an amortizing loan, debt service is computed via the PMT function: PMT(rate/12, n_months, –loan) × 12.
What is the minimum DSCR for a commercial loan?
Most institutional commercial lenders require a minimum DSCR of 1.20–1.25x. CMBS conduit floors at 1.20x, agency multifamily at 1.20–1.25x base (with a stressed-rate test that often binds tighter), banks at 1.25–1.40x, life insurance companies at 1.30–1.50x, and bridge/debt fund at 1.10–1.20x. Construction and transitional loans may apply different conventions, including DSCR tested at stabilization rather than at origination.
What's the difference between DSCR and DCR?
In commercial real estate, DSCR and DCR are typically synonyms — both refer to NOI ÷ debt service. In project finance and infrastructure, DSCR sometimes refers to a period-by-period coverage ratio while DCR (debt coverage ratio) refers to the average across the loan life. Some lenders distinguish in-period DSCR from average DSCR for sizing purposes. For CRE underwriting, treat them as the same metric.
How is DSCR calculated for a CMBS loan?
CMBS conduit DSCR is computed on stabilized NOI divided by amortizing debt service at the note rate, with replacement reserves and TI/LC reserves typically deducted from NOI for sizing. Conduit minimum is 1.20–1.25x; single-asset/single-borrower (SASB) deals run 1.25–1.35x. Some recent SASB pools have negotiated 1.20x stabilized as the convention loosens at the institutional end.
Does DSCR include principal?
Yes. DSCR uses full annual debt service — principal and interest. This is the key distinction from interest coverage ratio (ICR), which uses only interest expense. On a 30-year amortizing loan, a 1.50x ICR corresponds to roughly a 1.20–1.25x DSCR. Lenders quote DSCR to capture the full debt-service burden.
What is DSCR vs interest coverage ratio?
Interest coverage ratio = NOI ÷ interest expense. DSCR = NOI ÷ debt service (interest plus principal). DSCR is tighter than ICR on any amortizing loan because the denominator includes principal repayment. CRE lenders use DSCR; some corporate banking and project finance audiences use ICR for credit analysis but switch to DSCR for sizing.
What's the difference between stressed DSCR and in-place DSCR?
In-place DSCR is computed at the note rate (the contractual interest rate of the loan). Stressed DSCR is computed at the note rate plus a stress add-on, typically +100–300 bps. Agency multifamily lenders (Fannie Mae, Freddie Mac) size to the LESSER of in-place DSCR at the note rate and stressed DSCR at the elevated rate. In the 2024–2026 rate environment, the stressed test almost always binds and produces lower sized proceeds than the headline note-rate DSCR suggests.
How do you compute DSCR in Excel?
Annual debt service for an amortizing loan: =PMT(rate/12, years*12, -loan)*12. For an interest-only loan: =rate*loan. DSCR: =NOI/debt_service. Example: =PMT(0.065/12, 360, -50000000)*12 returns approximately $3,787,000; $5,000,000/$3,787,000 returns approximately 1.32x. Note the negative sign on the loan amount to make PMT return a positive payment value.
Does the calculator handle interest-only periods?
Yes. Enter the IO period in months. The calculator reports two debt service numbers when IO > 0: an interest-only debt service during the IO years (rate × loan) and an amortizing debt service after IO expires (PMT on the remaining balance over the remaining amortization). Lenders size to the amortizing leg, not the IO leg — toggle the IO period to confirm your deal still qualifies once the amortizing payment begins.
Why does my DSCR drop after the IO period ends?
Because debt service increases. During IO, you pay only interest on the loan balance. After IO, you pay principal plus interest, computed on the remaining balance over the remaining amortization. For a 30-year originally-amortizing loan with a 36-month IO period, the post-IO payment is computed over the remaining 27 years on the original balance — producing a payment roughly 15–20% higher than the IO debt service. DSCR drops by the same proportion at the same NOI.