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. Minimums commonly quoted for CMBS conduit and agency multifamily deals sit around 1.20–1.25x (illustrative, and product-specific in practice).
- 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 roughly 14–20% on a 25–30 year amortization at 6.50% (amortizing debt service runs 17–25% higher than interest-only) and overstates DSCR by the same 17–25%. - 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 about 5.3% in early October 2026, up from roughly 4.4–4.7% in May 2026 (FRED DGS10). The all-in rates below are illustrative inputs for the worked example, not current quotes: agency multifamily take-out at 5.75–6.25%, 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.43–0.50x on the same NOI (for example, 1.86x at 3.5% falls to 1.35–1.43x at 5.75–6.25% on a 30-year amortizing $50M loan with $5M of NOI).
- DSCR is one of three sizing constraints, not the only one. Lenders also size to LTV and debt yield. Run all three; the constraint that binds varies by lender and by deal, and it is rarely the one the broker is selling.
A note on terminology. "DSCR loan calculator" is a separate query that attracts residential single-family and non-QM mortgage shoppers: the cohort buying a rental house and qualifying for a 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, speak to a residential non-QM lender. This article is for institutional commercial real estate practitioners sizing debt on multifamily, industrial, office, retail, or hospitality acquisitions, with 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% | n/a | n/a | n/a |
| Base NOI | n/a | n/a | n/a |
| NOI −15% | n/a | n/a | n/a |
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,792,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. Whether replacement reserves come out before the DSCR test depends on the lender (see Common Mistakes below). Broker NOIs and institutional NOIs can differ materially, and any difference 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 $316,034, or roughly $3,792,000 per year. DSCR = $5,000,000 ÷ $3,792,000 ≈ 1.32x. That clears the commonly quoted floors for agency multifamily and CMBS conduit and sits at the low end of the 1.30–1.50x range quoted for life insurance companies.
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,792,000 (DSCR 1.32x), assuming a 30-year original amortization. The same loan, the same NOI, but a 0.22x swing in DSCR depending on which leg you are pricing. Agency lenders size to the amortizing leg (see Fannie Mae Multifamily Guide Sec. 203.02). 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, a modest rate stress; actual lender stress conventions are product-specific). Cells flagged red show combinations where DSCR drops below 1.20x, below the floor of most institutional ranges. Cells flagged green show DSCR at 1.30x or higher, at or above the floor of most life-company and conduit ranges. The center cell is your base case. The institutional question is not "what is base DSCR?" but "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 are illustrative of 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 |
| CMBS Single-Asset / Single-Borrower | 1.25–1.35x | Note rate; conservative on lower DSCR pools |
| Agency Multifamily (Fannie / Freddie) | 1.25x typical (Freddie Mac fixed-rate minimum 1.25x; Fannie Mae sets minimums by underwriting tier) | Level amortizing payment (including for IO loans) at the greater of note rate and a rate floor; floating-rate products use a product-specific stressed rate |
| 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. Ranges are an illustrative market-practice summary for stabilized core / core-plus underwriting, not a published survey; transitional and construction debt apply different conventions. The agency row follows the Fannie Mae and Freddie Mac documents listed under Sources.
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.05M 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 17% larger than an amortizing-sized loan against a 30-year amortization and about 25% larger against a 25-year amortization, at the same DSCR target. That is why a loan sized on IO debt service looks generous in the term sheet and then shrinks once the lender sizes to the amortizing payment.
Lenders know this. Fannie Mae and Freddie Mac size to the amortizing debt service even when the loan has an IO period (Fannie Mae Sec. 203.02; Freddie Mac Optigo fixed-rate term sheet). The IO is a cash-flow accommodation to the sponsor, not a sizing concession. The full worked example, including the $49.4M vs $61.5M sized-loan comparison at the same 1.25x 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 falls to roughly 1.17–1.24x if in-place NOI is 5–10% lower, and lower still where the T-12 contains concessions or bad debt the pro forma excluded. 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; once the amortizing leg kicks in, the same loan is 1.29x on a 30-year schedule or 1.20x on a 25-year schedule at 6.50%. Agency lenders size to the amortizing payment, not the IO payment, so 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 dollars, which might be 5–8% of gross potential rent for stabilized multifamily (illustrative; more for office and retail) but is a larger percentage of NOI. At a 40% expense ratio, omitting a 6% vacancy overstates NOI, and therefore DSCR, by about 11%. DSCR moves one-for-one with NOI, so this single error propagates directly into the ratio.
Mishandling replacement reserves. Reserve treatment varies. Appraisal and reporting NOI usually sits above replacement reserves, but Fannie Mae's underwritten net cash flow deducts a replacement reserve expense (minimum $200 per unit per year) before computing DSCR, whether or not the escrow is funded (Multifamily Guide Sec. 203.01). Confirm which basis the term sheet uses; DSCR on NOI before reserves will be higher than lender DSCR.
Ignoring stressed-rate sizing for agency loans. Fannie Mae sizes DSCR on underwritten net cash flow using a level amortizing payment at the greater of the note rate and its Underwriting Interest Rate Floor, regardless of any IO period (Multifamily Guide Sec. 203.02). Freddie Mac's fixed-rate Optigo product requires a minimum 1.25x amortizing DCR at every term (term sheet). Stress rates and floors vary by product and by floating- vs fixed-rate structure, so confirm the test in the term sheet and run your own stressed case.
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.25–1.32x DSCR at 6–7% (lower at lower rates or shorter amortization), which is 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 can bind before DSCR; CMBS conduit debt yield minimums are commonly quoted at 8.0–10.0% (illustrative). 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 $49.4M vs $61.5M sized at the same 1.25x 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. Commonly quoted ranges: CMBS conduit 1.20–1.25x; agency multifamily around 1.25x (Freddie Mac's fixed-rate minimum is 1.25x and Fannie Mae varies by underwriting tier); banks 1.25–1.40x; life insurance companies 1.30–1.50x; bridge and debt fund 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 above the top of most of these ranges.
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. Whether replacement reserves are deducted before the DSCR test depends on the lender (Fannie Mae's underwritten net cash flow deducts them), so confirm the basis in the term sheet. 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,792,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. Some lenders also deduct replacement reserves (Fannie Mae's underwritten net cash flow does), so confirm the basis in the term sheet. 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?
Commonly quoted institutional minimums start around 1.20–1.25x. CMBS conduit at 1.20–1.25x, agency multifamily around 1.25x (Freddie Mac's fixed-rate minimum is 1.25x; Fannie Mae varies by underwriting tier), 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, lenders often track minimum and average DSCR separately. For CRE underwriting, treat DSCR and DCR 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 minimums are commonly quoted at 1.20–1.25x and single-asset/single-borrower (SASB) deals at 1.25–1.35x (illustrative ranges).
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.25–1.32x DSCR at 6–7% (lower at lower rates or shorter amortization). 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 a higher rate than the note rate. Fannie Mae sizes on a level amortizing payment at the greater of the note rate and its Underwriting Interest Rate Floor (Multifamily Guide Sec. 203.02), so a floor above the note rate reduces sized proceeds relative to the headline note-rate DSCR. Freddie Mac's fixed-rate Optigo product requires a minimum 1.25x amortizing DCR at every term. Stress rates and floors vary by product and by floating- vs fixed-rate structure, so confirm the test in the term sheet.
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,792,000; $5,000,000/$3,792,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 (a level payment on the original balance over the full amortization, the convention the calculator uses). Agency lenders size to the amortizing leg, not the IO leg, so 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. Under the convention the calculator uses (a level payment on the original balance over the full amortization, which is also how Fannie Mae underwrites IO loans), the post-IO payment on a $50M, 6.50%, 30-year loan is about 17% higher than the IO payment ($3.79M vs $3.25M), so DSCR falls from 1.54x to 1.32x at the same NOI. If the amortization clock only starts after the IO period, the payment is computed over the remaining term and is higher still.
Sources
- Fannie Mae Multifamily Guide, Sec. 203.02, Underwritten DSCR: mfguide.fanniemae.com/node/10786
- Fannie Mae Multifamily Guide, Sec. 203.01, Underwritten Net Cash Flow: mfguide.fanniemae.com/node/7531
- Freddie Mac Optigo Conventional Fixed-Rate term sheet: mf.freddiemac.com/docs/product/fixed_rate.pdf
- Federal Reserve Bank of St. Louis, FRED, Market Yield on U.S. Treasury Securities at 10-Year Constant Maturity (DGS10): fred.stlouisfed.org/series/DGS10