Wall Street Prep

Debt-to-Equity Ratio (D/E)

Understand the Debt-to-Equity Ratio (D/E)

Learn Online Now

Debt-to-Equity Ratio (D/E)

In This Article
  • What is the definition of the debt-to-equity ratio?
  • Which formula is used to calculate the debt-to-equity ratio?
  • How is the value of the D/E ratio interpreted?
  • What does it mean if the D/E ratio is negative?

Debt-to-Equity Ratio Formula

The debt-to-equity ratio compares the total debt balance on a company’s balance sheet to the value of its total shareholders’ equity.

The D/E ratio represents the proportion of financing that came from creditors (debt) versus shareholders (equity).

The debt amount is comprised of short-term borrowings, long-term debt, and any debt-like items, whereas the shareholders’ equity includes any equity contributed by the owners, equity raised in the capital markets, and retained earnings.

In general, if a company’s D/E ratio is too high, that signals that the company is at risk of financial distress (i.e. at risk of being unable to meet required debt obligations).

However, a low D/E ratio is not necessarily a positive sign, as the company could be relying too much on equity financing, which is costlier than debt.

In addition, the reluctance to raise debt can cause the company to miss out on growth opportunities to fund expansion plans, as well as not benefit from the “tax shield” from interest expense.

D/E Ratio Formula

  • Debt-to-Equity Ratio = Total Debt / Total Shareholders Equity

Interpreting the Debt-to-Equity Ratio (D/E)

Lenders and debt investors prefer lower debt-to-equity ratios as that implies there is less reliance on debt financing to fund operations – i.e. working capital requirements such as the purchase of inventory.

By contrast, higher D/E ratios imply the company’s operations depend more on debt capital – which means creditors have greater claims on the assets of the company in a liquidation scenario.

For lenders, the existing debt on the balance sheet causes the borrower to be riskier to work with, especially for risk-averse debt lenders – and for shareholders, more debt means there are more claims on the company’s assets with higher priority than that of the shareholders.

Lenders and investors perceive borrowers funded primarily with equity (e.g. owners’ equity, outside equity raised, retained earnings) more favorably.

Under a hypothetical liquidation, including for creditors placed lower in the capital structure behind senior lenders, full recovery is not guaranteed – therefore, pre-existing creditors holding substantial claims on the company’s assets (and liens) increase the risk to creditors of lower seniority and equity holders.

D/E Ratio Example Interpretation

The D/E ratio answers, “For each dollar of equity contributed, how much in debt financing is there?”

For example, a debt-to-equity ratio of 2.0x indicates the company is financed with $2.00 of debt for each $1.00 of equity.

That said, if the D/E ratio is 1.0x, creditors and shareholders have an equal stake in the company’s assets, while a higher D/E ratio implies there is greater credit risk due to the higher relative reliance on debt.

Negative Debt-to-Equity Ratio (D/E)

While not a regular occurrence, it is possible for a company to have a negative D/E ratio, which means the company’s shareholders’ equity balance has turned negative.

A negative D/E ratio means the company in question has more debt than assets.

In the majority of cases, a negative D/E ratio is considered a risky sign, and the company might be at risk of bankruptcy. However, it could also mean the company issued shareholders significant dividends.

Debt-to-Equity Ratio (D/E) Calculator – Excel Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl
Submitting ...

Debt-to-Equity Ratio Example Calculation

In our D/E ratio modeling exercise, we’ll forecast a hypothetical company’s balance sheet for five years.

As of Year 1, the following assumptions will be used and extended across the entire projection period (i.e. held constant).

Model Assumptions
  • Cash & Equivalents = $60m
  • Accounts Receivable (A/R) = $50m
  • Inventory = $85m
  • Property, Plant & Equipment (PP&E) = $100m
  • Short-Term Debt = $40m
  • Long-Term Debt = $80m

From the above, we can calculate our company’s current assets as $195m and total assets as $220m in the first year of the forecast – and on the other side, $50m in total debt in the same period.

For purposes of simplicity, the liabilities on our balance sheet are short-term and long-term debt.

Thus, the total equity in Year 1 is $175m for the balance sheet to remain in balance.

For the remainder of the forecast, the short-term debt will grow by $2m each year while the long-term debt will grow by $5m.

The debt-to-equity ratio (D/E) is calculated by dividing the total debt balance by the total equity balance, as shown below.

In Year 1, for instance, the D/E ratio comes out to 0.7x.

  • Debt-to-Equity Ratio (D/E) = $120m / $175m = 0.7x

Debt-to-Equity Formula Excel

And then from Year 1 to Year 5, the debt-to-equity ratio (D/E) increases each year until reaching 1.0x in the final projection period.

  • Year 1 = 0.7x
  • Year 2 = 0.8x
  • Year 3 = 0.8x
  • Year 4 = 0.9x
  • Year 5 = 1.0x

Since the debt amount and equity amount are practically the same – $148m vs $147m – the takeaway is that in Year 5, the value attributable to creditors and shareholders is equivalent according to the balance sheet.

Debt-to-Equity Output

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
guest
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.