Debt Service Coverage Ratio Calculator (DSCR)

What this DSCR calculator estimates

The debt service coverage ratio compares net operating income with required debt payments over the same period. It is commonly used in commercial real estate, project finance, and business lending because it focuses on the cash generated by the financed asset or operation. A ratio of 1.00 means income exactly equals debt service. A ratio above 1.00 indicates a positive cushion; a ratio below 1.00 indicates that operating income alone does not fully cover the scheduled payment.

This tool calculates the monthly loan payment from principal, annual interest rate, and amortization term, unless you enable a custom monthly debt-service amount. It then calculates DSCR, annualized income and debt service, the monthly cash-flow cushion, and the minimum NOI required to meet your target ratio. The chart and schedule use the same current-state model as the summary and Excel export.

How to complete each input

Total loan amount

Enter the principal balance to be amortized. Use the amount actually financed rather than the purchase price. A larger loan generally increases the monthly payment and lowers DSCR when NOI, rate, and term remain unchanged. Enter a positive dollar amount. A blank or zero balance clears the amortization schedule and prevents a calculated payment.

Annual interest rate

Enter the nominal annual rate as a percentage, such as 7% rather than 0.07. A higher rate increases interest expense and usually reduces DSCR. A zero rate is supported and produces a straight-line principal payment. Do not add lender fees or points to the rate unless you intentionally want an all-in approximation.

Loan term

Enter the amortization period and choose years or months. Changing the selector converts the current value instead of merely relabeling it. A longer term typically lowers the monthly payment and raises DSCR, but it also increases the time needed to repay principal and may increase total interest. The amortization term is not necessarily the same as loan maturity when a balloon payment is required.

Monthly debt service and custom payment

By default, the payment is calculated from the loan terms. Enable the custom-payment option when a lender has supplied a contractual monthly payment, when the debt is interest-only, or when several obligations should be combined into one amount. The DSCR always uses the displayed debt-service amount. The schedule uses the custom payment too, so a payment below monthly interest will show negative amortization rather than silently forcing a payoff.

Monthly net operating income

In direct mode, enter monthly NOI after recurring operating expenses and vacancy loss but before financing costs, depreciation, and income taxes. Keep the measurement period consistent: monthly NOI must be compared with monthly debt service. Higher NOI raises DSCR dollar for dollar. Negative NOI is allowed for diagnostic purposes and will produce a negative ratio.

Gross income, operating expenses, and vacancy

In estimate mode, gross income is the property’s potential recurring monthly income. The operating expense rate represents costs such as property management, maintenance, insurance, property taxes, and owner-paid utilities. The vacancy rate represents expected lost income from empty units and collection problems. This calculator estimates NOI as gross income multiplied by one minus vacancy and then by one minus the expense rate. Rates must stay between 0% and 100%. Avoid counting the same vacancy or expense twice.

Target DSCR

The target is a planning benchmark used to calculate the minimum NOI required. A target of 1.25 means NOI should equal 125% of debt service. The common 1.25 figure is not universal: lender requirements depend on asset type, market, leverage, borrower strength, and loan structure. Review the actual covenant or term sheet rather than treating any generic threshold as approval guidance.

How the model works

Monthly payment = P × r × (1 + r)^n ÷ ((1 + r)^n − 1)
DSCR = monthly NOI ÷ monthly debt service
Estimated NOI = gross income × (1 − vacancy rate) × (1 − expense rate)

In the payment formula, P is principal, r is the monthly interest rate, and n is the number of monthly payments. When the rate is zero, the payment equals principal divided by the number of months. The same formulas are applied at full precision, with rounding only for display and workbook formatting.

How to interpret the results

DSCR is the primary coverage measure. Above 1.00 means operating income covers debt service; exactly 1.00 means no operating cushion; below 1.00 means a shortfall. A negative ratio reflects negative NOI. The status message compares the result with both break-even and your selected target.

Monthly cash-flow cushion equals NOI minus debt service. It shows the dollar buffer after the scheduled payment, not distributable profit. Capital expenditures, reserves, taxes, and owner distributions may still reduce cash available. NOI required at target equals debt service multiplied by the target ratio and is useful for rent, occupancy, or expense planning.

Annual NOI and annual debt service simply annualize the monthly amounts. The chart compares the two monthly measures on a common scale. The schedule separates each payment into principal and interest and shows the ending balance. If a custom payment pays the loan off early, the schedule stops at payoff; if it is too low, the balance may rise.

Decision use, tradeoffs, and common mistakes

• Stress-test NOI for rent declines, vacancy, repairs, and insurance increases rather than relying only on a current best case.
• Match periods exactly. Do not divide annual NOI by a monthly payment or monthly NOI by annual debt service.
• Exclude principal and interest from operating expenses when NOI is intended to be pre-debt-service.
• Check whether the lender uses property NOI, business cash flow, EBITDA, or another covenant definition.
• Do not assume a high DSCR guarantees approval; collateral, leverage, liquidity, and documentation also matter.

For broader context, review the Investopedia overview of DSCR, JPMorgan’s explanation of DSCR in commercial real estate, the U.S. Small Business Administration’s loan-program guidance, and the Federal Reserve’s community development resources. These sources provide context, but the governing loan documents and lender underwriting standards control the actual calculation.