1. Home  » 
  2. Business

How to Calculate Debt to Equity Ratio?

To calculate the Debt to Equity Ratio, first find the company's total debt and total shareholder equity on the balance sheet. Then, divide the total debt by the total shareholder equity.

by S Samayanka

Updated Apr 22, 2024

Article continues below advertisement
How to Calculate Debt to Equity Ratio?

Debt to Equity Ratio

The Debt to Equity ratio is a financial leverage ratio used to evaluate your company. If there is a fall in the company's profit, the debt to equity ratio can help you assess if there will be enough shareholder equity to settle the debt. 

By calculating the debt-to-equity ratio, investors can evaluate the liquidity and overall health of a company. A healthy debt-to-equity ratio is one that is less than 1.0, though this varies by industry. It is best to aim for one that is less than 2.0. 

Article continues below advertisement
Article continues below advertisement

How to Calculate Debt to Equity Ratio?

Here is how to calculate Debt to Equity Ratio:

  • Firstly, find the company's total debt. You can usually find the details on the balance sheet of the company, which is also a financial statement. 
  • Find the total shareholders' equity this represents the total amount of money the owners of the company have invested.
  • Now divide the total debt by the total shareholders' equity.

Debt to equity ratio = Total liabilities / Total shareholders' equity

Article continues below advertisement
Article continues below advertisement

What Information Does the Debt to Equity Ratio Provide?

  • The debt-to-equity ratio measures how much debt a company has compared to its value after taking out what it owes.
  • If the debt-to-equity ratio is high, it means the company depends a lot on borrowing money.
  • Borrowing money can help a company earn more, but if the costs are too high, it might not benefit.
  • This ratio helps to see if a company is taking on more or less debt compared to its value.
Article continues below advertisement
Article continues below advertisement

How to Decrease Your Debt to Equity Ratio?

Follow these steps to decrease your Debt to Equity Ratio:

  • Pay off your loans, as it helps to balance the ratio. Avoid taking on more debt to keep it low.
  • To increase the profitability of the firm, work on making more sales and lowering costs.
  • Make sure your inventory levels don't exceed what is necessary to fulfill orders, so make sure you effectively use the inventory.
  • If you have loans with high interest, think about refinancing them when market rates are low. 

How to Calculate the Debt to Equity Ratio Ratio in Excel?

Learn how to calculate the debt-to-equity ratio in Microsoft Excel using these simple steps. 

  • Now look at the firm's balance sheet and find out the total debt and total shareholder equity.
  • Once you have identified the numbers, open the Excel template and put them in the right places. 
  • For example, say B2 and B3, then add the formula “=B2/B3” in cell B4 to obtain the Debt to Equity ratio.

What are the Pros and Cons of a High Debt to Equity Ratio?

Pros of High D/E Ratio

Cons of High D/E Ratio

It shows a firm can easily service its debt obligations through cash flow

If the ratio is too high, the company may struggle to pay back debt

It Increases equity returns by leveraging debt

Losses can compound, making it hard to pay debt

It Can lower the weighted average cost of capital (WACC)

High borrowing costs if the ratio is too high

Debt is often cheaper than equity

High WACC can lower share price

How to Calculate Debt to Equity Ratio? - FAQs

1. What is the Debt to Equity Ratio?  

It shows how much a company relies on debt compared to what it owns.
 

2. How Do I Calculate Debt to Equity Ratio?

Divide total debt by total shareholder equity.
 

3. What does a high Debt to Equity ratio mean?  

It suggests the company depends heavily on borrowing money.
 

4. What's a Healthy D/E Ratio?  

It is usually less than 2.0, but varies by industry.

Disclaimer : The above information is for general informational purposes only. All information on the Site is provided in good faith, however we make no representation or warranty of any kind, express or implied, regarding the accuracy, adequacy, validity, reliability, availability or completeness of any information on the Site.