A:

The debt-to-equity (D/E) ratio is an important leverage metric in corporate finance. It is a measure of the degree to which a company is financing its operations through debt versus wholly owned funds. More specifically, it reflects the ability of shareholder equity to cover all outstanding debts in the event of a business downturn.

Defining the Debt-to-Equity Ratio

The D/E ratio is calculated by dividing total debt by the total shareholder equity. Though it is a simple calculation, this ratio carries a lot of weight. While the optimal ratio varies from industry to industry, companies with very high D/E ratios are often considered to be a greater risk by investors and lending institutions. A greater degree to which operations are funded by borrowed money means a greater risk of bankruptcy if business declines. Minimum payments on loans and other debts must still be met even if, due to economic downturn or simple market competition, a business does not turn enough profit to meet its obligations. For a highly leveraged company, a particularly bad quarter could end in disaster.

However, it's not as simple as saying a high D/E ratio is a sign of poor business practices. In fact, a certain amount of debt can actually be the catalyst that allows a company to expand operations and generate additional income for both the business and its shareholders. Some industries, such as the auto and construction industries, typically have higher ratios than others because getting started and maintaining inventory are capital-intensive. Companies with intangible products, such as online services, may have lower standard D/E ratios. Therefore, it's important to consider a company's historical ratio, as well as the D/E ratios of similar companies in the same industry, when evaluating financial health. (For related reading, see "What Is the Best Measure of a Company's Financial Health?")

Calculating the Debt-to-Equity Ratio in Excel

Business owners use a variety of software to track D/E ratios and other financial metrics. Microsoft Excel provides a number of templates, such as the debt ratio worksheet, that perform these types of calculations. However, even the amateur trader may want to calculate a company's D/E ratio when evaluating a potential investment opportunity, and it can be calculated without the aid of templates.

To calculate this ratio in Excel, locate the total debt and total shareholder equity on the company's balance sheet. Input both figures into two adjacent cells, say B2 and B3. In cell B4, input the formula "=B2/B3" to render the D/E ratio.

A Brief Example of the Debt-to-Equity Ratio

The owner of a bookshop wants to expand his or her business and is looking to leverage existing capital by taking on an additional loan. Because the book sales industry is beset by new digital media, a business with a large amount of debt would be considered a risky prospect by creditors. However, upon reviewing the company's finances, the loan officer determines the company has debt totaling $60,000 and shareholder equity totaling $100,000. With a D/E ratio of 0.6, the business should be able to take on some additional outside funding without being too highly leveraged.

(For related reading, see "Why Do Debt to Equity Ratios Vary from Industry to Industry?")

RELATED FAQS
  1. What debt-to-equity ratio is common for a bank?

    Take a look at the important debt-to-equity ratio, a key metric of financial leverage, and learn what the average debt/equity ... Read Answer >>
  2. What are financial risk ratios and how are they used to measure risk?

    Explore some of the primary financial risk ratios that investors and analysts commonly use to evaluate a company's overall ... Read Answer >>
  3. If a company has a high debt to capital ratio, what else should I look at before ...

    Learn about some of the financial leverage and profitability ratios that investors can analyze to supplement examining the ... Read Answer >>
  4. What debt-to-equity ratio is common for companies in the telecommunications sector?

    Learn the average debt-to-equity ratio for the telecommunications sector and how including operating leases can substantially ... Read Answer >>
  5. What are the most common leverage ratios for evaluating a company?

    Learn more about some of the most common leverage ratios used by traders to determine whether a company is using debt in ... Read Answer >>
Related Articles
  1. Investing

    Why do Debt to Equity Ratios Vary From Industry to Industry?

    Obtain a better understanding of the debt/equity ratio, and learn why this fundamental financial metric varies significantly between industries.
  2. Investing

    Typical debt-to-equity (D/E) ratios for the real estate sector

    Learn the typical debt-to-equity (D/E) ratios for companies in the real estate sector and discover how this measure of financial health determines leverage.
  3. Investing

    Analyzing Oracle's Debt Ratios in 2016 (ORCL, SAP)

    Learn how the debt ratio, debt-to-equity ratio and debt-to-capital ratio are used to evaluate Oracle Corp.'s liabilities, equity and assets.
  4. Investing

    Financial Ratios to Spot Companies Headed for Bankruptcy

    Obtain information about specific financial ratios investors should monitor to get early warnings about companies potentially headed for bankruptcy.
  5. Investing

    Debt Ratio

    The debt ratio divides a company’s total debt by its total assets to tell us how highly leveraged a company is—in other words, how much of its assets are financed by debt. The debt component ...
  6. Investing

    Useful Balance Sheet Metrics

    These metrics can help you better understand the information found on balance sheets.
  7. Investing

    Ratio Analysis

    Ratio analysis is the use of quantitative analysis of financial information in a company’s financial statements. The analysis is done by comparing line items in a company’s financial ...
  8. Investing

    Analyzing Pepsico's Debt Ratios in 2016 (PEP)

    Learn about PepsiCo and its financial leverage by looking at its debt-to-equity ratio, interest-coverage ratio and operating cash flow-to-debt ratio.
  9. Investing

    Key Financial Ratios to Analyze Tech Companies

    Understand the technology industry and the companies that operate in it. Learn about the key financial ratios used to analyze tech companies.
  10. Investing

    Analyzing Amgen's Debt Ratios in 2016 (AMGN)

    Learn about Amgen Inc. and its key debt ratios, such as the debt-to-equity ratio, interest coverage ratio and cash flow-to-debt ratio.
RELATED TERMS
  1. Debt/Equity Ratio

    The Debt/Equity (D/E) ratio indicates how much debt a company ...
  2. Accounting Ratio

    Accounting ratios, also known as financial ratios, are used to ...
  3. Ratio Analysis

    A ratio analysis is a quantitative analysis of information contained ...
  4. Long-Term Debt To Total Assets Ratio

    The long-term debt to total assets ratio is a measurement representing ...
  5. Funded Debt

    A funded debt is a company's debt that will mature in more than ...
  6. Funds From Operations (FFO) To Total Debt Ratio

    Funds from operations (FFO) to total debt ratio is a leverage ...
Trading Center