Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

What is debt-to-equity ratio and how to calculate it?

Ratios are indications and play a vital role in corporate finance. Several financial ratios evaluate the profitability, liquidity, performance, or financial strength of a company or business. The debt-to-equity ratio is one of the vital parameters used by financial professionals that indicates a company’s financial leverage. It is used to assess how much the company’s funds have been derived from shareholder’s capital and how much borrowed or raised through a loan; thus, it is essential to understand this ratio if you aim to become a master of finance.

What is debt-to-equity ratio?

Debt-to-equity is an essential measure to analyze a company’s position and financial ability. It reflects the degree to which a firm’s financing has been generated through owned funds versus debt. It exhibits the shareholder’s capital to pay off its borrowings if it goes bankrupt or decides to close business or liquidate. It is a specific kind of gearing ratio.

To see what that borrowing costs the company, read how to calculate the cost of debt.

How to calculate the debt-to-equity ratio?

It is simple to calculate the debt-to-equity ratio if you have input data, i.e., the company’s debt and equity. Both can be extracted from the company’s balance sheet. It is calculated by dividing a business’s debt value by the value of its equity.

Debt / Equity = Total Liabilities / Total Shareholders’ Equity

Suppose company ABC has equity of $500,000 and liabilities of $1,500,000, then its debt-to-equity ratio will be derived as $1,500,000 divided by $500,000, equal to 3.00. It means the company’s debt is three times its equity.

Usually, finance professionals consider only long-term debt while calculating the debt-to-equity ratio. A significant chunk of liability and uncertainty related to long-term debt is different from that associated with short-term payables and debt. Although short-term liabilities will also be constituent of the firm’s overall leverage position, these will be paid off within a year, thus considered comparatively less risky. So, the modified ratio can be:

Long-Term Debt / Equity = Long-Term Liabilities / Total Shareholders’ Equity

Let’s continue the above example of company ABC, suppose out of $1,500,000 total debt, the current portion is $1,000,000 and the remaining $500,000 is long-term debt. In contrast, its competitor company XYZ’s balance sheet exhibits a long-term liability of $1,000,000 and short-term payables of $500,000. Considering the same amount of equity for both companies, i.e., $500,000, both will have the same D/E ratio, i.e., 3.00. But company XYZ is at high risk due to a high proportion of long-term debt. The long-term debt to equity ratios are 1.00 and 2.00 for ABC and XYZ, respectively.

Let’s look at the balance sheet of Apple Inc. as of September 30, 2017, and calculate the D/E ratio. Apple reported total liabilities of $241,272 million and total shareholders’ equity of $134,047 million. The D/E ratio will be:

Debt / Equity = Total Liabilities / Total Shareholders’ Equity = $241,272 / $134,047 = 1.79

The result reflects that Apple had $1.79 of liability for each dollar of equity.

In case you don’t have the amount of equity, but you have the value of total assets, then the value of equity can be found out as:

Equity = Asset – Liabilities
Where, Liabilities = Long-term debt + Short-term debt

Debt and equity are not only components of a corporation’s balance sheet; instead, these belong to individuals’ finances. Thus, besides corporate D/E, an individual can also evaluate the D/E of their funds as:

Debt / Equity = Total Personal Liabilities / (Personal Assets − Liabilities)

Moreover, most investors derive this and several other metrics using various software with other analytical tools. Even an Excel-based financial model can be used to determine financial ratios.

What are the debt-to-equity ratio implications?

So, now one should understand what the value of D/E reflects; is it good or bad? What is an ideal D/E ratio? There isn’t a single perfect Debt to Equity ratio. It is unjustifiable to compare the D/E of different industries because of the difference in debt, industry nature, and even its characteristics. Therefore, it is necessary to compare similar businesses or companies such as US FMCGs or UK’s private OMCs, etc., since the D/E benchmark can vary from industry to industry and company to company. For instance, you can compare the D/E ratio of Toyota and Honda. Still, you cannot compare Toyota and Unilever due to the different nature of their businesses or sectors. Similarly, you may not compare the D/E ratio of Coke UK with Coke Pakistan due to the difference in the country’s regulations and environment.

A higher D/E ratio or increase in D/E ratio means the business is highly dependent on debt or bank borrowing. Thus, increased risk for business, specifically if debt or interest rates are rising. Whereas, lower D/E ratio or decrease in D/E ratio indicates that organizations rely more on shareholder’s funds or equity to finance stock or assets that might cause a reduction in dividend and lead to shareholder’s demotivation. Hence, the company must balance both considering its ability to bear the risk and pay interest and shareholder’s worth.

A D/E ratio below 1.0 is considered comparatively safe, while the ratio of 2.0 or above is generally considered riskier. However, the D/E of specific sectors usually are higher such as the Banking industry. Remember that too low D/E can also be unfavorable because it means business is not benefiting from debt financing and losing potential opportunities to expand and grow.

Higher debt can raise retained earnings or dividends as a company mainly covering its investment with debt and revenue or growth. Still, high debt comes with high interest or cost of debt that will ultimately affect profits negatively. Debt financing can be favorable for a company if the increase in earnings is more than the increase in the cost of debt; otherwise, it might result in unprofitable borrowing.

You might be wondering whether a company can have a negative D/E. Can this ratio go below 0? The answer is yes, it can but in rare scenarios. A negative D/E means the company’s liabilities are larger than its assets, so its shareholders’ equity is below zero. That situation can lead to liquidation or bankruptcy.

Investors often use corporate D/E to evaluate a company’s position and worth, potential shareholders to assess the company’s financial capability, and banks to analyze the creditworthiness and capacity of the company to pay off debt while generating feasibility or decision regarding loans application of any company.

Similarly, personal D/E plays a vital role in an individual’s loan application and facilitates lenders to assess borrowers’ ability to make loan payments even in their downtime.

It implies that if a person has an excellent D/E ratio, they will be able to pay off their loan from assets or own equity in case they lose their job or become temporarily unemployed. This loan can be either a borrowed prospective mortgage, small business loan, or line of credit. If your personal D/E is high, these debt reduction spreadsheets can help you plan your payments.

What is the difference between the gearing ratio and the debt-to-equity ratio?

Gearing refers to financial leverage; it is a broad category comprised of a group of ratios. Gearing and leverage are both interchangeable terms, but gearing can be distinguished from leverage in fundamental analysis. Leverage mainly indicates the value of debt acquired for investments to generate a higher return and profitable growth. In contrast, gearing signifies the amount of debt related to equity or the proportion of borrowing in the company’s funds. The difference is similar to the difference between debt and the D/E ratio.

What are the debt-to-equity ratio limitations?

D/E ratios of all companies are not easily comparable; thus, it is crucial to consider its sector. D/E metric of companies that belong to the same industry or operating in the same sector can be compared. For instance, if the D/E of a company is much higher than the D/E of its competitors, that would indicate issues with its internal management. The external environment is similar for firms operating in the same sector. Moreover, the D/E of a few sectors can be relatively high, whereas some industries might have a relatively lower D/E ratio because of the difference in capital requirement and growth rates.

Investors are usually confused with an explanation of debt. For example, preferred stock is a component of equity, but it has many similarities with debt; therefore, the inclusion of preferred stock in equity value might confuse analysts. But it might not be viable to include it in debt, increasing the D/E ratio and displaying a company as riskier. Thus, allocating preferred stock in equity and debt is still confusing and not consistent for all.

Let’s understand how preferred stock and its reclassification can distort the ratio. Imagine a company with the preferred stock of $200,000, the debt of $600,000 (excluding preferred stock), and equity of $800,000 (excluding preferred stock).

Considering preferred stock as part of liability will give D/E ratio as:

Debt-to-Equity ratio = ($600,000 + $200,000) / $800,000 = 1.00

On the contrary, the D/E ratio with the inclusion of preferred stock in equity will be:

Debt-to-Equity ratio = $600,000 / ($800,000 + $200,000) = 0.60

D/E ratio excluding the preferred stock will be:

Debt-to-Equity ratio = $600,000 / $800,000 = 0.75

As observed in the above example, the inclusion of preferred stock in debt has increased the ratio, and equity value has decreased it, resulting in an unclear picture of the company’s leverage position. Therefore, most analysts exclude it from calculation to avoid distortion and treat it separately using other ratios.

Conclusion

Debt-to-equity ratio is a valuable metric for evaluating a company’s financial health and risk level, helping investors and analysts understand how a business is financing its operations. By monitoring this ratio, stakeholders can make more informed decisions regarding investments and overall company stability.

If you’re looking to manage your own debt effectively, check out our guide on the Debt Snowball Spreadsheet. This method provides a practical way to reduce debt over time, using free templates to keep you organized and motivated on your journey to financial freedom.

The D/E ratio is only one part of the picture. To see how it changes from one year to the next, use horizontal analysis or trend analysis, and check operating cash flow to see whether the business brings in enough cash to cover its interest payments. If your finance team pulls these figures from several spreadsheets, Sheetgo’s AI finance virtual employee can gather the numbers and keep your reports up to date.

● Available 24/7

Put Owen on your finance ops

Sheetgo's finance virtual employee keeps your numbers current and your reporting on time. Your data stays in Google Sheets; you work with Owen in Slack, Teams, or Google Chat.

You may also like…

simple finance add on featured image

Build a stock portfolio spreadsheet, track your investments

Staying on top of your investments can be a real challenge, particularly if you manage them through many brokers. In this post we will...
finance

How to use Google Sheets for currency conversion

Staying up to date with the latest conversion rates can be a daunting task. But it doesn’t have to be. Read on to learn how to use Google...
finance processes and templates

8 steps to prepare a bank reconciliation statement

Bank reconciliation is a crucial financial process for businesses to ensure that records match bank statements. In this post, we'll...