Tools · Ratios

DSCR calculator

Debt service coverage is the cash flow available for debt service divided by a year of debt service. Type the cash flow and the loan terms to see where a deal stands and how much cushion it has.

By Research desk, The Lender Report ·Sources reviewed

Try your numbers

Runs in your browser. Nothing you type is sent to a server or saved.

For a property, its net operating income. For an operating business, earnings before interest, taxes, depreciation and amortization.

A lender's minimum, or one of the published minimums below.

JavaScript is off, so the form cannot calculate. The worked example below shows the same arithmetic for sample numbers, and the formula is written out under it.

A worked example

Cash flow $412,000, loan $3,500,000 at 6.75% amortized over 25 years. These are example numbers.

Monthly payment, principal and interest
$24,182
Debt service for a year
$290,183
Debt service coverage
1.42x

Cash flow could fall 29.6% before coverage reaches 1.00x.

At 1.25x and these terms the cash flow supports a loan of $3,975,425, which is $475,425 more than this one.

The same loan on a 30-year amortization covers 1.51x. Interest only covers 1.74x. The cash flow did not change. Only the way the payment is counted did, which is why the first question to ask a lender is what rate and amortization it uses to test coverage.

The formula

Coverage is cash flow divided by debt service. Debt service is twelve monthly payments. The monthly payment on a loan that fully amortizes is the loan times r, divided by one minus (1 plus r) to the power of minus n, where r is the monthly rate (the annual rate divided by 12) and n is the number of months.

Two loans with the same payment on the same cash flow have the same coverage. Coverage is a statement about the payment, not about the property.

What goes in the cash flow

The SBA defines the measure for its loans. In a change of ownership, historical coverage is earnings before interest, taxes, depreciation and amortization divided by the combined debt service after the transaction. For a 504 loan the development company must prepare a global cash flow and justify each addition and subtraction, such as rent payments, unfunded capital spending, non-recurring income and distributions.

For a conventional loan the lender's own policy decides which expenses, reserves and vacancy it counts, so the cash flow a lender uses is often not the one on the owner's statement. Ask for the lender's definition in writing before you size a request around a ratio.

The minimums SBA publishes

A bank's minimum coverage is its own loan policy, and it is not published. The interagency real estate lending guidelines (12 CFR part 365, Appendix A) tell each bank to set minimum standards for net worth, cash flow and debt service coverage in its own policy, and give no numbers. SBA does publish its minimums, in SOP 50 10 8.1:

Debt service coverage that SBA requires, SOP 50 10 8.1
LoanMinimumBasis
Standard 7(a), over $350,0001.15xHistorical or projected cash flow, and 1.00x on a global basis
7(a) Small Loan, not a change of ownership1.10xHistorical or projected
Change of ownership: initial acquisition, owner buyout, ESOP, cooperative1.25xLast fiscal year or the average of the last two
Change of ownership: business expansion1.15xLast fiscal year or the average of the last two
5041.15xHistorical, last fiscal year or the average of the last two

For a start-up or any request that relies on projections, SOP 50 10 8.1 asks for projections that reach 1.15x within two years of funding, or within two years of the end of construction. Debt service in the 7(a) test means the future required principal and interest on all business debt, including the new SBA loan.

Using it well

  1. Test at the lender's terms. Use the rate and amortization the lender will size on, not the ones you hope for. A quoted rate can sit below the rate a lender uses to test coverage.
  2. Read the cushion. Coverage of 1.42x means cash flow can fall about 30 percent before the payment is no longer covered. That cushion is what a lender is buying.
  3. Size the loan, not only the deal. If coverage is short, the maximum loan calculator shows the loan that does work, and which test sets it.

In the data here

No public file carries a debt service coverage ratio. Call reports hold balances, HMDA holds the amount, rate, term and loan to value as filed, and the SBA files hold the loan and its processing method. Coverage lives in the lender's credit file. The lender page shows what a lender holds and has made, so you can find lenders at your size, and the lender tells you the rest.

Terms used here

Sources

  1. SBA SOP 50 10 8.1, Lender and Development Company Loan Programs (Section B Chapters 1 and 2, Section C Chapter 1, Appendix 15), effective .
  2. 12 CFR part 365, Appendix A, Interagency Guidelines for Real Estate Lending Policies, current as of .

Next step: check the record

Keep reading

Estimate from your inputs. Not a quote or advice about which loan to take. Another tool: all calculators.