How to use the DSCR calculator
Enter the property's net operating income for a year, then the loan: its amount, the interest rate and the amortization period in years. Tick interest-only if the loan pays no principal, which is common in the first years of bridge and some agency loans.
The calculator shows the annual debt service, the monthly payment and the DSCR. Enter the lender's minimum in the target box, 1.25 for example, to see the largest loan the income supports at that coverage, and how far NOI could fall before it only just covers the payments.
The DSCR formula
The debt service coverage ratio is net operating income divided by annual debt service. Debt service is a year of loan payments, principal and interest together. A DSCR of 1.00x means the property earns exactly enough to make its payments; 1.25x means it earns 25% more than it needs.
For an amortizing loan the monthly payment is the level payment that repays the loan over the amortization period at the stated rate, and debt service is twelve of them. For an interest-only loan it is simply the loan amount times the rate. To size a loan, the formula runs backwards: divide NOI by the target DSCR to get the debt service the lender will allow, then divide by the loan constant, which is a year's payments per dollar borrowed.
Formula
DSCR = NOI ÷ annual debt service. Maximum loan = NOI ÷ target DSCR ÷ loan constant, where the loan constant = annual debt service ÷ loan amount.
Worked example: a $2,500,000 loan against $250,000 of NOI
The calculator opens on this loan. The property earns $250,000 of NOI. The loan is $2,500,000 at 6.5%, amortized over 30 years, and the lender wants a DSCR of at least 1.25x.
| Line | Amount |
|---|---|
| Net operating income | $250,000 |
| Monthly payment ($2,500,000 at 6.5%, 30 years) | $15,802 |
| Annual debt service | $189,620 |
| DSCR ($250,000 ÷ $189,620) | 1.32x |
| Debt service allowed at 1.25x ($250,000 ÷ 1.25) | $200,000 |
| Largest loan at 1.25x | $2,636,847 |
| NOI can fall this far before 1.00x | 24.15% |
Check the numbers
A loan of $2,636,847 at 6.5% over 30 years costs $200,000 a year, which is $250,000 ÷ 1.25. On interest-only terms the $2,500,000 loan costs $162,500 a year and covers 1.54x.
What a good DSCR looks like
Lenders set a minimum, and it varies with the property and the loan. For commercial and multifamily mortgages a minimum of about 1.20x to 1.35x is typical, with 1.25x the figure quoted most often. Riskier income, such as hotels or single-tenant buildings, is usually asked to cover by more. Loans for small residential rentals that are underwritten on the property's income are sometimes made at or just above 1.00x, at a higher rate.
From the borrower's side, a higher DSCR means more room for a vacancy, a repair bill or a rate reset before the property stops paying for its own loan. These ranges are typical, not rules; each lender publishes its own terms and tests them on its own version of NOI.
The NOI a lender uses
The NOI in a lender's DSCR is often lower than the one in the sales brochure. Underwriters commonly apply a minimum vacancy rate even to a full building, add a management fee even if the owner manages, and deduct a yearly reserve for replacements. Some test the ratio at a higher interest rate than the actual one, to see whether the loan still covers if rates rise.
The ratio is also tested more than once. It is measured when the loan is made and, for many commercial loans, again every quarter or year as a covenant. Falling below the covenant level can trigger a cash sweep or other remedies in the loan agreement, so it is worth knowing how far NOI can fall before that happens.
Common DSCR mistakes
Most errors make coverage look better than a lender will see it.
- Using interest-only payments to size a loan that will amortize later.
- Leaving principal out of debt service. Coverage is measured against the whole payment.
- Using gross income or projected NOI where the lender uses actual, adjusted NOI.
- Forgetting other debt. Mezzanine loans and seller notes have payments too, and a combined DSCR includes them.
- Assuming today's rate on a floating-rate loan.
DSCR, debt yield and loan-to-value
Lenders usually size a loan three ways and lend the smallest answer. Loan-to-value caps the loan against the property's value. DSCR caps it against the income, at the loan's own rate and amortization. Debt yield, NOI divided by the loan amount, caps it against the income without reference to the rate, so it cannot be flattered by a low interest rate or an interest-only period.
When rates are low, DSCR allows a large loan and debt yield or loan-to-value tends to be the limit. When rates are high, DSCR usually binds first. Run the same NOI through the debt yield calculator to see both.