How to Calculate DSCR | CREFCOA (2024)

What is the debt service coverage ratio (DSCR)?

The debt service coverage ratio (DSCR) is the relationship between a property’s annual net operating income and its annual mortgage debt.

How do I calculate the debt service coverage ratio (DSCR)?

To calculate the debt service coverage ratio (DSCR) you divide the annual net operating income by the annual mortgage debt.

What is the debt service coverage ratio (DSCR) used for?

The debt service coverage ratio is used to determine if there is enough income available to pay the mortgage debt. Or, simply put, the DSCR on an income producing property is an indication of how strong a property’s cash flow is. The higher the DSCR the stronger and more profitable a property is.

Why does the debt service coverage (DSCR) matter?

The debt service coverage ratio is the most important ratio used by lenders as it provides an indication of a property’s ability, after paying all other expenses, to service the mortgage debt. For example, a property with a DSCR of 1.50 means that after paying all operating expenses a property can cover the mortgage payment by 1.5 times or 150%. Whereas a property with a 1.00 DSCR means that after paying all operating expenses and the mortgage debt there is no money left over. A lender requires there to be money left over after paying all expenses and mortgage debt to provide a buffer to ensure there is enough cash flow available to pay the mortgage payment in case expenses rise or income falls.

Now that we have calculated the NOI, we must calculate the annual debt service for the property. The annual debt service is the simply the total amount of principal and interest payments made over a 12 month period. Taxes and insurance are not included in this calculation as they are accounted for in the expenses of the property.

To calculate the debt service coverage ratio, simply divide the net operating income (NOI) by the annual debt.

Commercial Loan Size: $10,000,000
Interest Rate: 6.5%
Term: 30 Years
Annual Payments (Debt Service) = $758,475

Net Operating Income (NOI) = $845,000

Now we can calculate the DSCR:

DSCR = Net Operating Income / Annual Debt Service

(NOI) = $845,000
Total Debt Service = $758,475
DSCR = 1.10 ($845,000 / $758,475)

What this example tells us is that the cash flow generated by the property will cover the new commercial loan payment by 1.10x. This is generally lower than most commercial mortgage lenders require. Most lenders will require a minimum DSCR of 1.20x.

If a DSCR is 1.0x, this is called breakeven, and a DSCR below 1.0x would signal a net operating loss based on the proposed debt structure.

How to Calculate DSCR | CREFCOA (2024)

FAQs

How to Calculate DSCR | CREFCOA? ›

The formula to calculate DSCR divides the net operating income (NOI) of a property by its annual debt service, which includes interest payments and principal amortization. A higher DSCR implies less credit risk, while a lower DSCR suggests more credit risk.

What is the simple formula for DSCR? ›

The DSCR is calculated by taking net operating income and dividing it by total debt service (which includes the principal and interest payments on a loan). For example, if a business has a net operating income of $100,000 and a total debt service of $60,000, its DSCR would be approximately 1.67.

How is DSCR calculated for rental property? ›

A simple way to calculate your DSCR and measure your cash flow is to divide the monthly rent by the PITIA (principal, taxes, interest, insurance, and association dues).

How do you calculate debt service ratio? ›

Debt service ratios are used by lenders to determine if you have the capacity to make payments on a loan or mortgage. In its simplest terms, your debt ratio is calculated by dividing your monthly debt by your monthly income (before taxes).

What does a 1.5 DSCR mean? ›

DSCR = 1.5

This means that the company generates 1.5 times the income needed to cover its debt obligations. A DSCR greater than 1 indicates that the company has sufficient income to meet its debt payments, which is generally viewed positively by lenders.

How do you calculate DSCR with example? ›

Here's an explanation of how to calculate the debt service coverage ratio. Let's consider the example of an organization generating an annual net operating income of ₹ 15 crore. On the other hand, its total debt service, including principal and interest payments, is ₹ 12 crore. DSCR = ₹ 15 Crore / ₹ 12 Crore = 1.25.

How do I calculate DSCR ratio in Excel? ›

As a reminder, the formula to calculate the DSCR is as follows: Net Operating Income / Total Debt Service. Place your cursor in cell D3. The formula in Excel will begin with the equal sign. Type the DSCR formula in cell D3 as follows: =B3/C3.

What is the rule of thumb for DSCR? ›

A DSCR of less than 1 suggests an inability to serve the company's debt. For example, a DSCR of 0.9 means that there is only enough net operating income to cover 90% of annual debt and interest payments. As a general rule of thumb, an ideal debt service coverage ratio is 2 or higher.

What is a DSCR loan for dummies? ›

A DSCR Loan is a mortgage loan for a residential income-producing property. It is primarily based on the “Debt Service Coverage Ratio” or the cash flow of the property, rather than the borrower's income. A traditional mortgage loan will require income verification, tax returns and a “Debt-to-Income” (DTI) ratio.

What is the math for DSCR loan? ›

The simplest way to calculate DSCR is to divide Net Operating Income (NOI) by Principal and Interest (P&I).

Does DSCR include taxes and insurance? ›

A lender's DSCR calculation might include property taxes and insurance, as well. If these are included as debt obligations, they should not be factored into the operating expenses when calculating total NOI.

What if DSCR is more than 2? ›

DSCR > 2: When a company's DSCR is above 2 then the company is able to cover at least double its debt obligation amount. A high DSCR ratio suggests a healthy cash flow operation and a low debt risk profile.

How do you calculate maximum loan amount using DSCR? ›

The DSCR is calculated by taking the net cash flow divided by the annual debt-service payments at the requested loan amount. If the net cash flow is insufficient to cover the requested loan at the target DSCR, then the loan amount will be constrained by the minimum DSCR.

Is a DSCR of 3 good? ›

A ratio of 2 or higher is generally seen to be healthy. “If you're at 1, all of the EBITDA you earn is going straight to debt,” Sood says.

Can you get a DSCR loan with no money down? ›

Down payment: DSCR loans typically require a down payment of 20-25% of the purchase price. However, some lenders may offer lower down payment options to borrowers with strong credit and experience with investment properties.

What is the formula for ratio? ›

Ratio Formula

The general form of representing a ratio of between two quantities say 'a' and 'b' is a: b, which is read as 'a is to b'. The fraction form that represents this ratio is a/b. To further simplify a ratio, we follow the same procedure that we use for simplifying a fraction. a:b = a/b.

What is a common DSCR ratio? ›

Most commercial banks and equipment finance firms want to see a minimum of 1.25x but strongly prefer something closer to 2x or more. Many small and middle market commercial lenders will set minimum DSC covenants at not less than 1.25x.

Top Articles
Latest Posts
Article information

Author: Cheryll Lueilwitz

Last Updated:

Views: 6013

Rating: 4.3 / 5 (74 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Cheryll Lueilwitz

Birthday: 1997-12-23

Address: 4653 O'Kon Hill, Lake Juanstad, AR 65469

Phone: +494124489301

Job: Marketing Representative

Hobby: Reading, Ice skating, Foraging, BASE jumping, Hiking, Skateboarding, Kayaking

Introduction: My name is Cheryll Lueilwitz, I am a sparkling, clean, super, lucky, joyous, outstanding, lucky person who loves writing and wants to share my knowledge and understanding with you.