DSCR Calculator for Real Estate: Compute It, Size the Loan, Stress It
The debt service coverage ratio is the single number lenders check first on an income-property loan, and the free DSCR calculator on this page runs all three versions of the calculation: coverage from your deal's numbers, maximum loan proceeds from a lender's minimum, and how both move when rates do.
This guide explains the formula behind the calculator, walks a worked example through each mode, and covers the lender conventions that trip up borrowers. All figures are illustrative examples, not market data.
The DSCR Formula
DSCR = Net Operating Income ÷ Annual Debt Service
Both terms have precise meanings, and using the wrong version of either is the most common way to calculate DSCR incorrectly:
- Net operating income (NOI) is effective gross income minus operating expenses — before debt service, income taxes, depreciation, and capital expenditures. Lenders typically use their own underwritten NOI, not yours: they may apply a minimum vacancy factor, insert a market management fee, and deduct replacement reserves even though reserves sit below the NOI line in a standard pro forma. Ask any lender whether their coverage test runs on NOI or on NOI less reserves; the answer changes your number.
- Annual debt service is the full year of principal and interest payments. Two conventions matter: use the amortizing payment (not interest-only, unless the loan is IO and the lender tests it that way), and use twelve months of payments, not one.
Worked example: a property with $240,000 of underwritten NOI carrying a loan with $192,000 of annual debt service:
DSCR = $240,000 ÷ $192,000 = 1.25x
The property generates $1.25 of net income for every $1.00 of debt payments. The cushion — the 0.25 — is what protects the lender when vacancy rises or expenses spike, which is exactly why lenders set minimums above 1.00x.
Reading the Number
- Below 1.00x: the property does not cover its own debt payments; the shortfall comes out of the owner's pocket every month.
- 1.00x: break-even — every dollar of NOI goes to the lender, with nothing for reserves, surprises, or the owner.
- Typical lender minimums: commonly quoted in the 1.20x–1.25x range for stabilized commercial and multifamily loans, with variation by asset class, market, and lender — riskier collateral generally means higher required coverage. Treat any specific minimum as a term to confirm on your term sheet, not a law of nature.
Coverage is also not a one-time test. Loans can carry ongoing covenants, and a deal underwritten at 1.25x in year one can drift toward the floor if income softens. A serious model tracks DSCR by year across the hold, not just at closing.
The Back-Solve: From DSCR to Maximum Loan
The more powerful use of the formula is running it in reverse. If you know the lender's minimum DSCR, your NOI, and the loan terms, you can compute the maximum loan the income supports — before you ever submit a package:
- Maximum annual debt service = NOI ÷ minimum DSCR
- Maximum loan = maximum debt service ÷ the loan's annual mortgage constant (the annual payment per dollar borrowed at a given rate and amortization)
Worked example: $240,000 NOI, a 1.25x minimum, and a 30-year amortization at an illustrative 6.75% rate:
- Max debt service = $240,000 ÷ 1.25 = $192,000
- Annual constant at 6.75%/30-year ≈ 7.78%
- Max loan ≈ $192,000 ÷ 0.0778 ≈ $2.47 million
The calculator on this page runs this back-solve directly. For the full derivation — including the mortgage constant math and why amortization period moves the answer as much as rate does — see the max loan amount from DSCR explainer.
Remember that DSCR is only one of the sizing constraints; lenders test proceeds against loan-to-value (and often debt yield) simultaneously and lend to the most restrictive of them. Our loan sizing calculator guide runs all three constraints side by side to show which one binds a given deal.
Stress It: What Rate Movement Does to Proceeds
Because the mortgage constant sits in the denominator of the back-solve, DSCR-constrained loan proceeds are directly exposed to rates — and the sensitivity is larger than intuition suggests.
Rerun the example 50 basis points higher, at 7.25%:
- Annual constant ≈ 8.19%
- Max loan ≈ $192,000 ÷ 0.0819 ≈ $2.35 million
A half-point rate move cut roughly $120,000 of proceeds from the same property with the same income — a gap the borrower must fill with equity. This is why deals negotiated in a rising-rate window can come up short at closing, and why the stress mode of a DSCR calculator is not optional: run your coverage and your proceeds at the quoted rate, and again at meaningfully higher rates, before you commit deposit money to a timeline.
The same stress works on the income side. Hold the loan fixed and haircut NOI — a few points more vacancy, an expense surprise — and watch where coverage lands relative to the covenant. On our example, a 10% NOI haircut takes $240,000 to $216,000, and coverage on the $192,000 of debt service falls from 1.25x to 1.125x — through a 1.20x covenant on a downturn no worse than one bad year. Run the reverse question too: how much NOI can this deal lose before coverage touches the minimum? At a 1.20x floor, the answer is NOI down to $230,400 — a cushion of just 4%. A deal that reads as comfortably financed at the headline DSCR can carry almost no absorption capacity underneath, and this two-line stress is how you find out before the lender's asset-management team does.
Where DSCR Sits in the Full Underwriting
Coverage is a gate, not a verdict. A deal can clear 1.25x and still be a poor investment (thin returns on the equity), or scrape 1.20x and be excellent (a value-add ramping toward much stronger coverage). In a complete model, DSCR does three jobs: it sizes the loan at close, it constrains the refinance in any bridge-to-perm plan, and it runs as a by-year covenant check across the hold. The calculator on this page handles the first job in isolation; the other two need the full pro forma around them.
Common DSCR Calculation Mistakes
- Using cash flow instead of NOI. Debt service does not belong inside the numerator that measures the ability to pay debt service.
- Using gross income. Rent before vacancy and expenses is not NOI; the ratio will be flattered badly.
- Ignoring the lender's NOI adjustments. Your pro forma NOI and the lender's underwritten NOI are different numbers; the lender's is the one that sizes the loan.
- Testing interest-only payments on an amortizing loan. IO payments overstate coverage; know which payment the lender tests.
- Computing at close and never again. Coverage is a covenant through the hold, not a gate at origination.
Frequently Asked Questions
What is a good DSCR for real estate? Above the lender's minimum with room to spare. Minimums commonly sit around 1.20x–1.25x for stabilized property, but the practical answer is deal-specific: the right question is how much NOI deterioration your coverage can absorb before touching the covenant.
Is DSCR calculated monthly or annually? The convention is annual: twelve months of NOI over twelve months of debt service. Monthly calculation gives the same ratio if both terms are monthly — errors come from mixing periods.
Does DSCR include principal payments? Yes. Debt service means principal plus interest on an amortizing loan. Testing interest-only when the loan amortizes overstates coverage.
What is the difference between DSCR and debt yield? DSCR compares NOI to the loan's payments, so it moves with rate and amortization. Debt yield compares NOI to the loan amount, ignoring terms entirely — which is precisely why some lenders use it as a rate-proof second test.
Is this the same DSCR used for residential DSCR loans? Same ratio, different conventions — DSCR loan programs for rental properties often compute it with the full PITIA payment in the denominator. If you are qualifying for a DSCR loan product specifically, see our DSCR loan calculator guide for the program-specific version. For the conceptual foundations of the ratio itself, the DSCR explained primer is the deeper treatment.
Beyond the Calculator
The free calculator answers the three questions above. The DSCR & Debt Underwriting Calculator is the full Excel implementation: coverage computed the way lenders underwrite it, the LTV/DSCR/debt-yield triple-constraint sizing with the binding constraint flagged, a complete amortization schedule with DSCR tracked by year, and rate stress built in — fully unlocked, formula-transparent, with a documented methodology PDF.
And if you would rather run this analysis in a guided web app than a spreadsheet, the YieldSheets underwriting platform is in development — join the waitlist to get access when it opens.
This article is for educational purposes only and does not constitute investment, legal, or tax advice. All figures are illustrative examples, not market data or rate quotes. Lender requirements vary; confirm terms with your lender. Consult qualified professionals before making investment decisions.
Get the next breakdown in your inbox
New CRE modeling walkthroughs 3× per week. No spam, unsubscribe anytime.
