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

Leverage ratio: definition and how to calculate

There are many financial metrics commonly used to evaluate a company’s financial performance. These cover all aspects of the company’s finances by focusing on different metrics. Leverage ratios are used to express a company’s financial stability in terms of its level of debt. This is especially important when looking for funding, whether it’s a loan from a bank or a venture capitalist.

In this article, you will learn about different types of leverage ratios and how to interpret them. You will also learn how to calculate the most common financial leverage ratios in Google Sheets. To learn more about financial ratios, take a look at these articles: Profitability Analysis and Budget Variance Analysis.

What is a leverage ratio?

Leverage ratio is an umbrella term for a series of financial ratios that express a company’s leverage with respect to liabilities, assets, and equity. These ratios can be useful indicators of a company’s ability to meet its financial obligations as long as they are assessed in context.

Generally speaking, there are three main types of leverage ratios: operating, financial, and combined. Operating leverage ratios focus on the ratio of fixed to variable costs, and financial leverage ratios focus on the extent to which the company is financed by debt or obligation.

What is a good total leverage ratio?

A ratio lower than 1 is generally considered good, although there are a few exceptions. The lower the value, the less likely the company will fail to meet financial responsibilities. A ratio above 1 is considered risky, but the context may justify it. If it climbs above 2, there may be cause for concern.

However, some of the ratios used to evaluate leverage are interpreted differently, as a higher ratio indicates an increased ability to pay back debt and other financial obligations.

There are multiple factors to be considered when analyzing leverage ratios. For instance, certain industries require a larger investment in equipment or material than others, so it’s important to use appropriate benchmarks. The ratios for startups and established businesses in the same industry are also likely to be very different, as the former has startup costs to cover.

How to calculate leverage ratios?

The calculations involved in finding leverage ratios are very simple, but there’s no excuse for doing it manually. Let spreadsheet software like Excel or Google Sheets take care of the arithmetic while you focus on analyzing and contextualizing the results.

As mentioned, there is a wide array to choose from regarding leverage ratios, but you’ll find a selection of frequently used ratios below. The first four express the relationship between the company’s total debt and various other metrics, like total assets, total equity, total capital, and Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA). The last evaluates the relationship between the company’s assets and its equity.

Debt-to-assets ratio

This ratio expresses the company’s debt in relation to its assets. To calculate it, use the following formula:

debt-to-assets ratio = total debt / total assets

Debt-to-equity ratio

Another ratio of interest is the amount of debt relative to the company’s total equity. Our guide to the debt-to-equity ratio covers it in more detail. Use the following formula to calculate it:

debt-to-equity ratio = total debt / total equity

Debt-to-capital ratio

By dividing debt by the sum of debt and equity, you get the company’s debt-to-capital ratio. Use this formula to calculate it:

debt-to-capital ratio = total debt / (total debt + total equity)

Debt-to-EBITDA ratio

This ratio expresses debt in relation to Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA). Use the following formula to calculate it:

debt-to-EBITDA ratio = total debt / EBITDA

Asset-to-equity ratio

This ratio expresses the proportion of the company’s assets that is funded by shareholder equity. To calculate it, use the following formula:

asset-to-equity ratio = total assets / total equity

How to calculate leverage ratios in Google Sheets?

Financial leverage ratios can be calculated easily with Google Sheets. Whether you’re doing internal analysis or you want to present a proposal for funding, you’ll need to provide a realistic picture of your company’s ability to meet financial obligations.

It’s common for the data you need to be spread out over multiple spreadsheets in various formats. Additionally, collaboration and synchronization can be problematic when working with a team. With Sheetgo’s AI automations, you can connect those spreadsheets and keep them in sync, so every ratio uses the latest figures. For recurring finance work, Sheetgo’s AI finance virtual employee can collect the figures and keep your ratios up to date.

1. In Google Sheets, set up a table for the required data. You can find the information you need in the company’s balance sheet and income statements.

Leverage ratio in Google Sheets — table with Total Assets, Total Debt, Total Equity, and EBITDA labels and empty value cells

2. Using cell references, type in the formula for the leverage ratios you want. To calculate the debt-to-assets ratio, simply select the cell with the value for “Total Debt” and divide by the cell with the value for “Total Assets”.

Leverage ratio formula — debt-to-assets cell with the formula =B2/B1 next to the data table and a list of ratio names

3. Add the formulas for any other ratios you need to calculate. You can save this as a template and update the relevant fields as needed. You can safely ignore the errors, as they will disappear once you add values.

Leverage ratio formulas — debt-to-assets, debt-to-equity, debt-to-capital, debt-to-EBITDA, and asset-to-equity rows showing #DIV/0! before values are added

4. That’s it. Add values to the table to see the corresponding leverage ratios.

Leverage ratio calculation — total assets $100,000, debt $40,000, equity $50,000, and EBITDA $20,000 giving ratios of 0.4, 0.8, 0.44, 2, and 2

Examples of leverage ratios

  • debt-to-assets ratio = total debt / total assets = $40,000 / $100,000 = 0.4
  • debt-to-equity ratio = total debt / total equity = $40,000 / $50,000 = 0.8
  • debt-to-capital ratio = total debt / (total debt + total equity) = $40,000 / ($40,000 + $50,000) = 0.44
  • debt-to-EBITDA ratio = total debt / EBITDA = $40,000 / $20,000 = 2
  • asset-to-equity ratio = total assets / total equity = $100,000 / $50,000 = 2

Conclusion

As you have seen, financial leverage ratios can provide useful information about a company’s ability to meet financial responsibilities. However, it’s important to analyze them in context, using suitable examples for comparison. Additionally, you need to remember that while most of the debt-related ratios are considered better when they have low values, there are others for which higher values are preferable.

You now know about leverage ratios and how to interpret them, as well as how to calculate them. You also know how to use Google Sheets to calculate the most commonly used financial leverage ratios. To learn more about related financial analyses, take a look at the following articles:

● 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...