EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Debt Ratio Formula

Debt Ratio Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated August 2, 2023

Debt-Ratio-Formula

Debt Ratio Formula (Table of Contents)
  • Debt Ratio Formula
  • Debt Ratio Calculator
  • Debt Ratio Formula in Excel (With Excel Template)

Debt Ratio Formula

The formula for calculating the Debt Ratio is as follows:

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Debt Ratio Formula

Where,

Total liabilities are the total debt and financial obligations payable by the company to organizations or individuals at any defined period. Total liabilities are stated on the balance sheet by the company.

Total Assets are the total amount of assets owned by an entity or an individual. Assets are items of monetary value used over time to produce a benefit for the asset’s holder. If the owners of Assets are a company, these assets are stated in the balance sheet for the accounting records.

Examples of Debt Ratio Formula

Example #1

You can download this Debt Ratio Template here – Debt Ratio Template

Let’s assume Company Anand Ltd has stated $15 million of debt and $20 million of assets on its balance sheet; we must calculate the Debt Ratio for Anand Ltd.

We can calculate the Debt Ratio for Anand Ltd by using the Debt Ratio Formula:

  • Debt Ratio = Total Liabilities / Total Assets
  • Debt Ratio = $15,000,000 / $20,000,000
  • Debt Ratio = 0.75 or 75%

This shows that for every $1 of assets that Company Anand Ltd has, they have $0.75 of debt. A ratio below 1.0 indicates that the company has less debt than assets.

Example #2

Jagriti Group of Companies has the following details as per its audited financials for the year ended 2017-18:

  • Current Assets – $45,000
  • Non-current Assets – $200,000
  • Current Liabilities – $50,000
  • Non-current Liabilities – $60,000

We need to calculate the debt ratio of the Jagriti Group of Companies.

As we can see in the above case, the Total Assets and Total Liability are not provided, then we have to calculate Total Assets and Total Liability by using the below formula:

  • Total assets = (Current Assets + Non-current Assets)
  • Total assets = ($45,000 + $200,000)
  • Total assets = $245,000
  • Total liabilities = Current Liabilities + Non-current Liabilities
  • Total liabilities = ($50,000 + $60,000)
  • Total liabilities = $110,000

We can calculate the Debt Ratio for Jagriti Groupby using the Debt Ratio Formula:

  • Debt Ratio = Total Liabilities / Total Assets
  • Debt Ratio = $110,000 / $245,000
  • Debt Ratio = 0.45 or 44%

The debt ratio of Jagriti Group of Companies is 0.45.

Example #3

The following figures have been obtained from the balance sheet of the Anand Group of Companies.

  • Current Assets – $50,000
  • Non-current Assets – $200,000
  • Total Liabilities – $90,000
  • Shareholder Equity- $160,000

We need to calculate the debt ratio of the Anand Group of Companies.

For calculating the Debt Ratio, we need Total Liability and Total Assets. We need to calculate Total Assets by using the formula.

  • Total assets = Current Assets + Non-current Assets
  • Total Assets = ($50,000 + $200,000)
  • Total Assets = $250,000

We can calculate the Debt Ratio for Anand Group of Companies Group by using the Debt Ratio Formula:

  • Debt Ratio = Total Liabilities / Total Assets
  • Debt Ratio= $90,000/ $250,000
  • Debt Ratio = 0.36 or 36%

The debt ratio of Anand Group of Companies is 0.36.

Explanation

The debt ratio measures the weightage of leverage in a company’s capital structure; it is further used for measuring risk. If the debt ratio is high, it shows the company has a higher burden of repaying the principal and interest, which may impact the company’s cash flow. It can create a glitch in financial performance, or the default situation may arise.

Assets and Liabilities are the two most important terms in any company’s balance sheet. Investors can interpret whether the company has enough assets to pay off its liabilities by looking at these two items. And this is what we call the debt ratio.

The debt ratio can be used as a measure of financial leverage. If a company has a Debt Ratio greater than 0.50, then the company is called a Leveraged Company. This shows the company has more debt funding in its capital structure. If the company has a lower debt ratio, then the company is called a Conservative company.

Significance and Use of Debt Ratio Formula

Company executives or investors mainly use the debt ratio formula:

The company’s top management can use the debt ratio formula to make the top-level decision of the company related to its capital structure and future funding. Using the Debt ratio, the top management can decide to raise funds. Whether they want to raise funds from external sources like loans or debts or through equity. If the company has enough capital to repay its obligations, it can raise funds from external sources.

Investors who want to invest in a company can use the debt ratio formula. This formula shows whether the firm has enough assets or capital to repay the debts and other obligations as the company pays dividends to shareholders after paying all the debts and obligations of the company.

The debt ratio can be used as a measure of financial leverage. If a company’s Debt Ratio exceeds 0.50, it is classified as a Leveraged Company. This shows the company has more debt funding in its capital structure. People commonly refer to a company with a lower debt ratio as a conservative company.

If a company has a Debt Ratio lower than 0.50 shows the company is stable and has a potential for longevity. A company can raise more funds from outside for the expansion. For every industry, the benchmark of Debt ratio may vary, but the 0.50 Debt ratio of a company can be reasonable. This shows that the company has two times the assets of its liabilities. Or we can say the company’s liabilities are 50 % of its total assets.

If a company has a Debt Ratio of 1, it has total liabilities equal to its total assets. Or we can say if a company wants to pay off its liabilities, it would have to sell off all its assets. If the company needs to pay off the liabilities, it must sell off all its assets; in that case, it can no longer operate.

Debt Ratio Calculator

You can use the following Debt Ratio Calculator

Total Liabilities
Total Assets
Debt Ratio Formula
 

Debt Ratio Formula =
Total Liabilities =
Total Assets
0 = 0
0

Debt Ratio Formula in Excel (With Excel Template)

Here we will do the same example of the Debt Ratio formula in Excel. It is straightforward. You need to provide the two inputs, i.e., Total Liabilities and Total Assets.

You can easily calculate the Debt Ratio Using the Formula in the template provided.

First, we need to calculate the Total Liabilities

calculation of Total Liabilities

Then, we need to calculate the Total Assets

Calculation of Total Assets

Now, we can calculate the Debt Ratio Using Formula

Debt Ratio Example 1-3

Recommended Articles

This has been a guide to a Debt Ratio formula. Here we discuss its uses along with practical examples. We also provide a Debt Ratio Calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Formula for Inventory Turnover Ratio
  2. Guide to Overhead Ratio Examples
  3. Retention Ratio Excel Template
  4. Calculator for Present Value Factor Formula
  5. Inventory Turnover Ratio
EQUITY RESEARCH ANALYST Certification Course Bundle - 23 Courses in 1 | 8 Mock Tests
94+ Hours of HD Videos
23 Courses
8 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.9
FOREX TRADING Certification Course Bundle - 5 Courses in 1 | 3 Mock Tests
29+ Hours of HD Videos
5 Courses
3 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
CFA LEVEL 1 Prep Course Bundle - 20 Courses in 1 | 29 Mock Tests
113+ Hours of HD Videos
20 Courses
29 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
IFRS Course Bundle - 30 Courses in 1 | 5 Mock Tests
42+ Hour of HD Videos
30 Courses
5 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training
 278+ Hours of HD Videos
51 Courses
30 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.6
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Debt Ratio Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Debt Ratio Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more