The debt-service coverage ratio applies to corporate, government, and personal finance. In the context of corporate finance, the debt-service coverage ratio (DSCR) is a measurement of a firm's available cash flow to pay current debt obligations. The DSCR shows investors whether a company has enough income to pay its debts.
The debt-service coverage ratio (DSCR) is a measure of the cash flow available to pay current debt obligations.
DSCR is used to analyze firms, projects, or individual borrowers.
The minimum DSCR that a lender demands depends on macroeconomic conditions. If the economy is growing, lenders may be more forgiving of lower ratios.
0 seconds of 1 minute, 39 secondsVolume 75%
1:39
The formula for the debt-service coverage ratio requires net operating income and the total debt servicing for the entity. Net operating income is a company's revenue minus certain operating expenses (COE), not including taxes and interest payments. It is often considered the equivalent of earnings before interest and tax (EBIT).
\begin{aligned} &\text{DSCR} = \frac{ \text{Net Operating Income} }{ \text{Total Debt Service} } \\ &\textbf{where:} \\ &\text{Net Operating Income} = \text{Revenue} - \text{COE} \\ &\text{COE} = \text{Certain operating expenses} \\ &\text{Total Debt Service} = \text{Current debt obligations} \\ \end{aligned}DSCR=Total Debt ServiceNet Operating Incomewhere:Net Operating Income=Revenue−COECOE=Certain operating expensesTotal Debt Service=Current debt obligations
Some calculations include non-operating income in EBIT. As a lender or investor comparing different companies' creditworthiness—or a manager comparing different years or quarters—it is important to apply consistent criteria when calculating DSCR. As a borrower, it is important to realize that lenders may calculate DSCR in slightly different ways.
Total debt service refers to current debt obligations, meaning any interest, principal, sinking fund, and lease payments that are due in the coming year. On a balance sheet, this will include short-term debt and the current portion of long-term debt.
Income taxes complicate DSCR calculations because interest payments are tax deductible, while principal repayments are not. A more accurate way to calculate total debt service is, therefore, to compute the following:
\begin{aligned} &\text{TDS} = ( \text{Interest} \times ( 1 - \text{Tax Rate} ) ) + \text{Principal} \\ &\textbf{where:} \\ &\text{TDS} = \text{Total debt service} \\ \end{aligned}TDS=(Interest×(1−Tax Rate))+Principalwhere:TDS=Total debt service
To create a dynamic DSCR formula in Excel, you cannot simply run an equation that divides net operating income by debt service. Rather, you would title two successive cells, such as A2 and A3, "net operating income" and "debt service." Then, adjacent to those cells, in B2 and B3, you would place the respective figures from the income statement.
In a separate cell, enter a formula for DSCR that uses the B2 and B3 cells rather than actual numeric values (e.g., B2 / B3).
Even for a calculation this simple, it is best to use a dynamic formula that can be adjusted and recalculated automatically. One of the primary reasons to calculate DSCR is to compare it to other firms in the industry, and these comparisons are easier to run if you can simply plug in the numbers.
In the context of government finance, the DSCR is the amount of export earnings needed by a country to meet annual interest and principal payments on its external debt. In the context of personal finance, it is a ratio used by bank loan officers to determine income property loans.
Whether the context is corporate finance, government finance, or personal finance, the debt-service coverage ratio reflects the ability to service debt given a particular level of income. The ratio states net operating income as a multiple of debt obligations due within one year, including interest, principal, sinking funds, and lease payments.
Lenders will routinely assess a borrower's DSCR before making a loan. A DSCR of less than 1 means negative cash flow, which means that the borrower will be unable to cover or pay current debt obligations without drawing on outside sources—in essence, borrowing more.
For example, a DSCR of 0.95 means that there is only sufficient net operating income to cover 95% of annual debt payments. In the context of personal finance, this would mean that the borrower would have to delve into their personal funds every month to keep the project afloat. In general, lenders frown on negative cash flow, but some allow it if the borrower has strong resources in addition to their income.
If the debt-service coverage ratio is too close to 1, for example, 1.1, the entity is vulnerable, and a minor decline in cash flow could render it unable to service its debt. Lenders may, in some cases, require that the borrower maintain a certain minimum DSCR while the loan is outstanding. Some agreements will consider a borrower who falls below that minimum to be in default. Typically, a DSCR greater than 1 means the entity—whether an individual, company, or government—has sufficient income to pay its current debt obligations.
The minimum DSCR a lender will demand can depend on macroeconomic conditions. If the economy is growing, credit is more readily available, and lenders may be more forgiving of lower ratios. A tendency to lend to less-qualified borrowers can, in turn, affect the economy's stability, as was the case leading up to the 2008 financial crisis. Subprime borrowers were able to obtain credit, particularly mortgages, with little scrutiny. When these borrowers began to default en masse, the financial institutions that had financed them collapsed.1
Let's say a real estate developer is looking to obtain a mortgage loan from a local bank. The lender will want to calculate the DSCR to determine the ability of the developer to borrow and pay off their loan as the rental properties they build generate income.
The developer indicates that net operating income will be $2,150,000 per year, and the lender notes that debt service will be $350,000 per year. The DSCR is calculated as 6.14x, which should mean the borrower can cover their debt service more than six times given their operating income.