Financial Statement Analysis
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis Advantages
 Ratio Analysis
 Liquidity Ratios
 Cash Ratio
 Cash Ratio Formula
 Quick Ratio
 Quick Ratio Formula
 Current Ratio
 Current Ratio Formula
 Acid Test Ratio Formula
 Defensive Interval Ratio
 Working Capital Ratio
 Working Capital Formula
 Net Working Capital Formula
 Changes in Net Working Capital
 Cash Flow from Operations Ratio
 Cash Reserve Ratio
 Operating Cycle Formula
 Current Ratio vs Quick Ratio
 Bid Ask Spread
 Liquidity vs Solvency
 Liquidity
 Solvency
 Solvency Ratios
 Equity Ratio
 Capital Adequacy Ratio
 Liquidity Risk
 Altman Z Score
 Turnover Ratios
 Inventory Turnover Ratio
 Accounts Receivable Turnover
 Accounts Receivables Turnover Ratio
 Accounts Payable Turnover Ratio
 Days Inventory Outstanding
 Days in Inventory
 Days Sales Outstanding
 Average Collection Period
 Days Payable Outstanding
 Cash Conversion Cycle
 Cash Conversion Cycle (CCC) Formula
 Fixed Asset Turnover Ratio Formula
 Debtor Days Formula
 Working Capital Turnover Ratio
 Profitability Ratios
 Profitability Ratios Formula
 Common Size Income Statement
 Vertical Analysis of Income Statement
 Profit Margin
 Gross Profit Margin Formula
 Gross Profit Percentage
 Operating Profit Margin Formula
 EBIT Margin Formula
 Operating Income Formula
 Net Profit Margin Formula
 EBIDTA Margin
 Degree of Operating Leverage Formula (DOL)
 NOPAT Formula
 OIBDA
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 Return on Sales
 ROIC Formula (Return on Invested Capital)
 Return on Investment Formula (ROI)
 ROIC vs ROCE
 ROE vs ROA
 CFROI
 Cash on Cash Return
 Return on Total Assets (ROA)
 Return on Average Capital Employed
 Capital employed Employed
 Return on Average Assets (ROAA)
 Return on Average Equity (ROAE)
 Return on Assets Formula
 Return on Equity Formula
 DuPont Formula
 Net Interest Margin Formula
 Earnings Per Share Formula
 Diluted EPS Formula
 Contribution Margin Formula
 Unit Contribution Margin
 Revenue Per Employee Ratio
 Operating Leverage
 EBIT vs EBITDA
 EBITDAR
 Capital Gains Yield
 Tax Equivalent Yield
 LTM Revenue
 Operating Expense Ratio Formula
 Overhead Ratio Formula
 Variable Costing Formula
 Capitalization Rate
 Cap Rate Formula
 Comparative Income Statement
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Asset Ratio Formula
 Coverage Ratio
 Coverage Ratio Formula
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 DSCR Formula (Debt service coverage ratio)
 Financial Leverage Ratio
 Financial Leverage Formula
 Degree of Financial Leverage Formula
 Net Debt Formula
 Leverage Ratios
 Leverage Ratios Formula
 Operating Leverage vs Financial Leverage
 Current Yield
 Debt Yield Ratio
 Solvency Ratio Formula
Debt to Equity Ratio Formula
Debt to equity is a formula that is viewed as a long term solvency ratio. It is a comparison between “external finance” and the “internal finance”.
Let’s have a look at the formula –
In the numerator, we will take “total liabilities” of the firm; and in the denominator, we will consider shareholders’ equity. As shareholders’ equity also includes “preferred stock”, we will also consider that.
Recommended Courses
Example of Debt to Equity Ratio Formula
Let’s take a simple example to illustrate the debtequity ratio formula.
Youth Company has the following information –
 Current Liabilities – $49,000
 Noncurrent Liabilities – $111,000
 Common Stocks – 20,000 shares of $25 each
 Preferred Stocks – $140,000
Find out the debtequity ratio of Youth Company.
In this example, we have all the information. All we need to do is to find out the total liabilities and the total shareholders’ equity.
 Total liabilities = (Current liabilities + Noncurrent liabilities) = ($49,000 + $111,000) = $160,000.
 Total shareholders’ equity = (Common stocks + Preferred stocks) = [(20,000 * $25) + $140,000] = [$500,000 + $140,000] = $640,000.
The debt equity ratio formula is –
 Debt equity ratio formula = Total liabilities / Total shareholders’ equity = $160,000 / $640,000 = ¼ = 0.25.
 So the debt to equity of Youth Company is 0.25.
In normal situation, a ratio of 2:1 is considered healthy. From generic perspective, Youth Company could use a little more external financing and it will also help them in accessing the benefits of financial leverage.
Explanation of Debt to Equity Ratio Formula
By using the D/E ratio formula the investors get to know how a firm is doing in capital structure; and also how solvent the firm is, as a whole. When an investor decides to invest into a company, she needs to know the approach of a company.
If the total liabilities of the company are higher compared to the shareholders’ equity, the investor would think whether to invest in the company or not; because having too much debt is too risky for a firm in the long run.
4.8 (388 ratings)
If the total liabilities of the company are too low compared to the shareholders’ equity, the investor would also think twice about investing in the company; because then, the company’s capital structure is not conducive enough to achieve financial leverage. However, if the company balances both internal and external finance, then maybe the investor would feel that the company is ideal for investment.
Pepsi Debt to Equity was at around 0.50x in 20091010. however, it started rising rapidly and is at 2.792x currently. Looks like an overleveraged situation.
Use of Debt to Equity Ratio Formula
The formula of D/E is the very common ratio in terms of solvency.
If an investor wants to know the solvency of a company, debt to equity would be the first ratio to cross her mind.
By using debt to equity, the investor not only understands the immediate stance of the company; but also can understand the longterm future of the company.
For example, if a company is using too less of external finance; through debt to equity, the investor would be able to understand that the company is trying to become wholeequity firm. And as a result, the firm wouldn’t be able to use the financial leverage in the long run.
Calculator
You can use the following formula of D/E Ratio Calculator
Total Liabilities  
Shareholders' Equity  
Debt to Equity Ratio Formula =  
Debt to Equity Ratio Formula = 


Debt Equity Ratio in Excel (with excel template)
Let us now do the same example above in Excel.
This is very simple. You need to provide the two inputs of total liabilities and the total shareholders’ equity.
You can easily calculate the ratio in the template provided.
Here, First We will find out the Total Liabilities and shareholders’ Equity
Now We will calculate the Debt Equity Ratio using the formula of debt to equity ratio
You can download this formula of debt to equity ratio template here – Debt to Equity Ratio Excel Template
Debt to Equity Ratio Formula Video
Recommended Articles
This has been a guide to Debt to Equity Ratio Formula, practical examples, and a Debt to Equity ratio calculator along with excel templates. You may also have a look at these articles below to learn more about Financial Analysis –
 Explanation of Leverage Ratios Formula
 NonCurrent Liabilities Examples
 Ratio in Excel Formula  Examples
 Examples of Solvency Ratio Formula (with Excel Template)
 Examples of Coverage Ratio Formula(with Excel Template)
 Explanation of the Common Stock Formula
 Shareholder’s Equity Formula
 Equity Ratio
 Debt Coverage Ratio Formula
 Asset Turnover Ratio Formula
 Leverage Ratios Formulas
 Debt Ratio Formula
Leave a Reply