Skip to content
Alternative Finance

Commercial loans · Brokers, investors and lenders

Commercial real estate DSCR calculator

This commercial real estate DSCR calculator builds net operating income the way a lender does, from scheduled rent and other income less vacancy, operating expenses and replacement reserves, then divides it by annual debt service on the proposed loan. It also shows the largest loan the target DSCR supports and how the ratio moves if the rate rises one point, vacancy rises five points or expenses rise ten percent. Watch the sensitivity table: a loan that passes at 1.25 today and fails under a one-point rate rise will be sized down.

DSCR
1.12
Net operating income
$181,040
Annual debt service
$161,146
Maximum loan at target DSCR
$1,707,653
Effective gross income
$305,040
Expense ratio
41%

NOI = effective gross income − operating expenses − reserves. Lenders underwrite to their own vacancy and expense assumptions, which are usually more conservative than the seller's.

DSCR sensitivity
ScenarioDSCR
Rate +1%1.03
Vacancy +5 pts1.02
Expenses +10%1.05

Your funding estimate

$1,707,653

Estimated amount from your inputs. An example calculation, not an offer from any lender.

Compare funding options

Formula

Effective gross income (EGI) = (Gross scheduled annual rent + Other income) × (1 − Vacancy and credit loss ÷ 100)

Net operating income (NOI) = EGI − Operating expenses − Replacement reserves

Annual debt service = 12 × Proposed loan × r ÷ (1 − (1 + r)^−N), where r = Interest rate ÷ 12 and N = Amortization (years) × 12

DSCR = NOI ÷ Annual debt service; Maximum loan at target DSCR = present value, at r over N, of a monthly payment of (NOI ÷ Target DSCR) ÷ 12

Expense ratio = (Operating expenses + Replacement reserves) ÷ EGI; the sensitivity rows recompute DSCR with the rate +1 point, vacancy +5 points and expenses ×1.1

Worked examples

Example 1: $328,000 gross income, 7 percent vacancy, $1.9 million loan at 7 percent

Use the defaults: Gross scheduled annual rent $320,000, Other income $8,000, Vacancy 7 percent, Operating expenses $118,000, Replacement reserves $6,000, Proposed loan $1,900,000, Interest rate 7 percent, Amortization 25 years, Target DSCR 1.25. Gross potential income = $320,000 + $8,000 = $328,000. EGI = $328,000 × 0.93 = $305,040. NOI = $305,040 − $118,000 − $6,000 = $181,040. Monthly rate r = 0.07 ÷ 12 = 0.0058333; N = 300. Monthly payment = $1,900,000 × 0.0058333 ÷ (1 − 1.0058333^−300) = $13,428.80; Annual debt service = $161,146. DSCR = $181,040 ÷ $161,146 = 1.12, below the 1.25 target, so the result shows a warning. Maximum loan at 1.25: allowed debt service = $181,040 ÷ 1.25 = $144,832 a year = $12,069.33 a month; the loan that payment supports at 7 percent over 300 months = $1,707,653. Expense ratio = ($118,000 + $6,000) ÷ $305,040 = 41 percent. Sensitivity: at 8 percent the payment rises to about $14,664 and DSCR falls to 1.03; at 12 percent vacancy EGI falls to $288,640, NOI to $164,640 and DSCR to 1.02; with expenses at $129,800 NOI falls to $169,240 and DSCR to 1.05. The lender will offer about $1.7 million, not $1.9 million.

Example 2: a small building where the proposed loan is far too large

Enter Gross scheduled annual rent $150,000, Other income $0, Vacancy 10 percent, Operating expenses $62,000, Replacement reserves $3,000, Proposed loan $900,000, Interest rate 7.5 percent, Amortization 25 years, Target DSCR 1.25. EGI = $150,000 × 0.90 = $135,000. NOI = $135,000 − $62,000 − $3,000 = $70,000. r = 0.075 ÷ 12 = 0.00625; monthly payment on $900,000 = $6,650.90; Annual debt service = $79,811. DSCR = $70,000 ÷ $79,811 = 0.88: the property does not cover the debt at all. Maximum loan at 1.25 = present value of ($70,000 ÷ 1.25) ÷ 12 = $4,666.67 a month over 300 months at 0.625 percent = $631,492. Expense ratio = $65,000 ÷ $135,000 = 48 percent. Sensitivity drops to 0.80, 0.78 and 0.80. The buyer asked for $900,000 against NOI that supports about $630,000. Unless the price falls or the equity rises by roughly $270,000, there is no conventional loan here; the number to lead with in the conversation is the maximum loan, not the DSCR.

Example 3: a larger property on a 30-year amortization with a 1.30 target

Enter Gross scheduled annual rent $600,000, Other income $20,000, Vacancy 5 percent, Operating expenses $230,000, Replacement reserves $12,000, Proposed loan $3,500,000, Interest rate 6.75 percent, Amortization 30 years, Target DSCR 1.30. Gross potential = $620,000; EGI = $620,000 × 0.95 = $589,000; NOI = $589,000 − $230,000 − $12,000 = $347,000. r = 0.0675 ÷ 12 = 0.005625; N = 360; monthly payment = $22,700.90; Annual debt service = $272,411. DSCR = $347,000 ÷ $272,411 = 1.27, just below the 1.30 target. Maximum loan at 1.30 = present value of ($347,000 ÷ 1.30) ÷ 12 = $22,243.59 a month over 360 months = $3,429,487, about $70,000 below the request. Expense ratio = $242,000 ÷ $589,000 = 41 percent. Sensitivity: 1.15 at 7.75 percent, 1.16 at 10 percent vacancy, 1.19 with expenses up ten percent. This is a close call that a lender resolves by trimming the loan to $3.43 million or by accepting 1.27 against a 1.25 policy minimum if the 1.30 was a target rather than a floor.

Building NOI the way the lender will

A commercial real estate DSCR calculator is only as good as its NOI, and the NOI a lender underwrites is rarely the one in the offering memorandum. Start with gross scheduled rent from the rent roll at in-place lease rates, not market rates and not the rent a new owner hopes to charge. Add other income that is contractual or has a history: parking, storage, laundry, late fees, reimbursements for taxes and common-area costs. Then deduct vacancy and credit loss as a percentage, using the higher of the property's actual history and the lender's minimum, which is commonly five to ten percent even on a fully leased building because leases expire and tenants fail.

Operating expenses are everything it costs to run the building before debt: real estate taxes (re-assessed at the purchase price, not the seller's old bill), insurance at a current quote, utilities the landlord pays, repairs and maintenance, contract services, management (charged even if the owner self-manages, because the lender assumes a third party could have to step in), payroll and administrative costs. Replacement reserves are a separate line for capital items such as roofs, parking lots and mechanical systems, commonly set per unit or per square foot by property type. The tool keeps reserves separate because some lenders include them in NOI and others deduct them below the line; enter them where your lender does.

Reading the DSCR and the maximum loan

DSCR is NOI divided by annual debt service. A ratio of 1.00 means the property exactly covers the payment with nothing left; 1.25 means there is 25 percent of debt service as cushion. Wikipedia's DSCR entry gives the general definition; in commercial real estate lending the convention is to compute it on NOI after reserves and on the fully amortizing payment, even during an interest-only period, because that is the payment the property must eventually carry. Lenders commonly require 1.20 to 1.25 on stabilized multifamily and 1.25 to 1.35 on office, retail, industrial and self-storage, with higher floors for hospitality, special-purpose and single-tenant buildings.

Maximum loan at target DSCR is the number that matters when the ratio fails. It converts the allowed debt service into a loan at the entered rate and amortization. Lenders use the same arithmetic and then take the lower of this figure and their loan-to-value limit; the commercial mortgage calculator applies both constraints and adds debt yield. In example 1 the DSCR-sized loan is $1,707,653 against a request of $1,900,000; the borrower needs about $192,000 more equity, a lower price or a lender with a lower floor. A longer amortization raises the maximum loan, which is why borrowers ask for 30 years and lenders, who know the balloon is larger, resist.

Interpreting the DSCR output
DSCRWhat it meansTypical lender response
Below 1.00NOI does not cover the paymentDecline, or a bridge loan with a reserve pending lease-up
1.00 to 1.15Covers with little cushionLoan sized down to the maximum at the floor; higher rate or more equity
1.15 to 1.25MarginalApproved only if the policy floor is 1.15 or 1.20 and other factors are strong
1.25 to 1.40Meets most policiesStandard approval; LTV may be the binding constraint instead
Above 1.40ComfortableBorrower may be under-leveraged; lender may offer more if LTV allows

Why the sensitivity table is the part lenders read first

A DSCR that passes today is a snapshot. The sensitivity rows ask whether it passes tomorrow. Rate +1 percent re-prices the loan one point higher and recomputes the payment; it approximates both a higher rate at closing and the reset risk on a floating or hybrid note. Vacancy +5 points removes five percent of gross income, roughly one tenant in a twenty-tenant building or a few months of downtime on a single-tenant one. Expenses +10 percent models a tax re-assessment, an insurance renewal or a utility spike. In example 1 all three push the ratio from 1.12 to between 1.02 and 1.05, which tells the lender the property is at the edge even before the request is cut.

Lenders stress loans this way because supervisory guidance expects it. The OCC's commercial real estate lending handbook and the interagency real estate lending standards published through the FDIC call for underwriting that considers interest-rate sensitivity and realistic vacancy and expense assumptions. The Federal Reserve's H.15 release publishes the prime and Treasury rates that commercial notes reference, so the one-point stress can be checked against how far those indexes have moved in the past. Operating-cost pressure is visible in the price indexes the Bureau of Labor Statistics publishes for insurance, utilities and construction inputs.

A borrower who presents the sensitivity table before being asked signals that the request has been underwritten honestly. A request that passes 1.25 in the base case and stays above 1.10 in every stress row usually closes at the requested amount; one that falls below 1.00 in any row will be sized down regardless of the base case.

Using the result in a loan request

  1. 1

    Reconcile the rent roll to the leases

    Every rent figure must tie to a signed lease with its expiry date. Lenders test the rent roll against the leases and against bank deposits.

  2. 2

    Reconcile expenses to the operating statements and tax bills

    Two to three years of actual statements, the current tax assessment and an insurance quote in the buyer's name. Where your figures differ from the actuals, explain why.

  3. 3

    Run the loan at the lender's floor, not yours

    Set Target DSCR to the lender's published minimum and take the maximum loan output as the ceiling of the request.

  4. 4

    Test the alternatives

    If the maximum loan is too low, re-run with a longer amortization, a lower rate from a different lender, or a lower proposed loan with more equity. If the property is owner-occupied, an SBA 504 structure may allow more leverage; screen with the SBA loan qualification checker.

  5. 5

    Present all three ratios

    DSCR, LTV and debt yield on the first page of the package, with the sensitivity table beneath them.

For investors evaluating a purchase rather than a loan, the maximum loan at the target DSCR also sets the price. If the lender will advance $1.7 million and the investor has $500,000 of equity, the property is worth $2.2 million to that buyer regardless of the asking price. Investors who start from the DSCR loan and work backwards to price rarely overpay; those who start from price and hope the loan follows are the ones in example 2.

DSCR covenants after closing

Most commercial mortgages include an ongoing DSCR covenant tested from annual operating statements the borrower must deliver. A breach typically triggers a cash management sweep, a requirement to post additional collateral or principal to restore the ratio, or in some notes a default. Re-run this calculator each year with the actual rent roll and expenses to see the covenant test before the lender does. A property that drifts from 1.30 to 1.18 over three years because taxes and insurance rose faster than rents is a common pattern, and catching it early allows rent increases or expense cuts rather than a scramble to re-margin.

The same arithmetic applies to the refinancing event at maturity. The balloon on a 25-year amortization with a 10-year term, shown in the commercial loan calculator, must be refinanced at the DSCR of that day; a property whose NOI has not grown while rates have risen will refinance for less than it owes. Tracking DSCR annually is the only way to see that problem five years out rather than five months out.

Glossary

  • Gross potential income: scheduled rent plus other income before any vacancy deduction.
  • Effective gross income: gross potential income after vacancy and credit loss.
  • Net operating income: EGI less operating expenses and, in this tool, less replacement reserves; before debt service, depreciation and income tax.
  • Expense ratio: operating expenses plus reserves as a share of EGI; a quick check against property-type norms.
  • Debt service: annual principal and interest on the loan at the fully amortizing payment.
  • Loan constant: annual debt service divided by loan amount; DSCR equals cap rate on cost divided by the loan constant, which is why a cap rate below the constant always produces a DSCR below 1.00 at full leverage.
  • Replacement reserves: an annual allowance for capital items, often escrowed with the lender.

Questions people ask

What DSCR do commercial real estate lenders require?

Commonly 1.20 to 1.25 on stabilized multifamily and 1.25 to 1.35 on office, retail, industrial and self-storage, with higher floors for hospitality, special-purpose and single-tenant buildings. The floor is applied to NOI after vacancy, expenses and usually reserves, divided by the fully amortizing annual payment. Set the Target DSCR field to the lender's floor to see the maximum loan.

How do I calculate NOI for a DSCR calculation?

Gross scheduled rent plus other income, times one minus the vacancy and credit loss rate, gives effective gross income. Subtract operating expenses (taxes at the re-assessed value, insurance, utilities, repairs, management, administration) and replacement reserves. Do not subtract debt service, depreciation or income tax. The tool does this arithmetic from the five income and expense fields.

Why does the lender's NOI differ from the seller's?

Sellers present rents at market or projected levels, omit management when self-managed, use the old tax bill and set vacancy to zero. Lenders use in-place rents, charge management regardless, re-assess taxes at the purchase price, require a minimum vacancy and deduct reserves. Each adjustment lowers NOI and the maximum loan; underwriting with the lender's assumptions avoids a surprise at approval.

What happens if the DSCR is below the target?

The lender sizes the loan down to the maximum loan at target DSCR, which the tool shows, and the borrower must bring more equity, negotiate a lower price or find a lender with a lower floor or a longer amortization. In example 1 a $1.9 million request falls to about $1.7 million. If DSCR is below 1.00 the property does not cover the debt and a conventional loan is unlikely.

Does a longer amortization improve DSCR?

Yes, because the annual payment falls. Moving from 25 to 30 years lowers the payment and raises both the DSCR and the maximum loan. Lenders limit amortization by property type and age, and a longer schedule leaves a larger balloon at maturity, so the improvement in DSCR is bought with refinancing risk later. Debt yield, which some lenders also test, does not change with amortization.

Is the commercial real estate DSCR calculator suitable for owner-occupied buildings?

It is built for income property. For an owner-occupied building the lender underwrites the operating business, using its cash flow available for debt service plus the rent it currently pays rather than a rent roll. Use the commercial mortgage calculator with that figure as NOI, and the EBITDA and cash flow underwriting guide for the add-backs lenders accept.

Sources and further reading

Site calculators on the same topic

Related tools and guides

More commercial loans

Updated October 12, 2026 · By Alternative Finance editorial team

Next step

Turn the estimate into real offers

One request, several funding partners, side-by-side payback. Nothing is binding until you accept an offer.

  • Soft inquiry to request offers; a hard pull only if you proceed with a funder.
  • Decisions in as little as 24 hours for many products; funding often within days.
  • Use our calculators to check the true cost before you accept anything.

Check commercial real estate loans offers

Takes about a minute. Requesting offers does not affect your credit score. Free, no obligation.

We are not a lender or broker. Requests are forwarded to funding partners free of charge. How the site is paid.