EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Debt to Asset Ratio Formula
 

Debt to Asset Ratio Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 29, 2023

Debt to Asset Ratio Formula

 

 

Debt to Asset Ratio Formula (Table of Contents)
  • Debt to Asset Ratio Formula
  • Examples of Debt to Asset Ratio Formula (With Excel Template)
  • Debt to Asset Ratio Formula Calculator

Debt to Asset Ratio Formula

The term Debt to Asset ratio is used to analyze what portion of Asset is funded by Debt capital. A business can use mainly two sources of capital to support its business- Equity and Debt. Business deploys capital to either purchase Assets (Current or non-Current) or to fund its operational expense.

(There are different school of thoughts regarding what all liabilities should be included in the term Debt while calculating Debt to Asset Ratio. Some group of Analyst advocates to consider all sort of liabilities to be included in Debt other than common shareholder’s capital whereas the other group are the proponents of considering only interest bearing liabilities as Debt. The article would be considering only interest-bearing liabilities as debts for explaining the Debt to Asset ratio.)

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

The formula for Debt to Asset Ratio is:

Debt to Asset Ratio = Total Debts / Total Assets
  • Total Debts: It includes interest-bearing Short term and Long term debts.
  • Total Assets: It includes Current Assets and Non-Current Assets.

Step 1: You can find interest bearing short term debt under the current liabilities section in the Liability side of the Balance Sheet and long term debt under the non-current liabilities section in the Liability side of the Balance Sheet.

Step 2: You can find the Total Assets current as well as non-current assets from the current and non-current assets section of the Asset side of the balance sheet, respectively.

Step 3: Once you performed the above steps to arrive at the Debt to Asset Ratio, you have to divide total debt with total assets.

Examples of Debt to Asset Ratio Formula (With Excel Template)

Let’s take an example to understand the calculation of the Debt to Asset Ratio formula in a better manner.

You can download this Debt to Asset Ratio Formula Excel Template here – Debt to Asset Ratio Formula Excel Template

Example #1

Let’s consider an example to calculate Debt to Asset Ratio, assume company ABC is an FMCG company. At the end of the financial year Balance sheet of ABC looks like this. 

Debt to Asset Ratio Example 1-1

Solution:

Short Term Debts is calculated as:

Short Term Debts = Short Term Loan

Debt to Asset Ratio Example 1-2

Short Term Debts = 300

Long Term Debts is calculated as:

Long Term Debts = Secured Debt + Term Loan + Long Term Debts

Debt to Asset Ratio Example 1-3

  • Long Term Debts = 600 + 300 + 800
  • Long Term Debts = 1700

Debt to Asset Ratio is calculated using the formula given below

Debt to Asset Ratio = (Short Term Debts + Long Term Debts) / Total Assets

Debt to Asset Ratio Example 1-4

  • Debt to Assets Ratio = (300 + 1700) / 5750
  • Debt to Assets Ratio = 2000 / 5750
  • Debt to Assets Ratio = 34.78%

Example #2

Let’s take another example, this time; we are taking the financials of IFB industries. A publically traded stock in NSE and BSE. The company IFB Industries Ltd is into manufacturing and selling consumer durable goods such as Washing machines and Microwave ovens.

Debt to Asset Ratio Example 2-1

This is the balance sheet of IFB Industries Ltd for the period FY18 (Figures are in INR Lacs)

Solution:

Total Assets can be figured out from the asset side of the Balance Sheet

Total Assets =1,08,200 for the period ending 31st March 2018

Total Debts is calculated as:

  • Total Debts = Borrowings (15) + Other Financial Liabilities (16) + Borrowings (20)
  • Total Debts = 1000 + 9+ 408
  • Total Debts =1417

Debt to Asset Ratio is calculated using the formula given below

Debt to Asset Ratio = Total Debts / Total Assets

Example 2-2

  • Debt to Asset Ratio = 1417 / 1,08,200
  • Debt to Asset Ratio = 1.31%

Example #3

Let’s consider one more example; the company in the example is Dabur India Ltd. The company is in FMCG vertical.

Example 3-1

This is the balance sheet of Dabur India Ltd for the period FY18 (Figures are in INR crores)

Solution:

Total Assets can be figured out from the asset side of the Balance Sheet

Total Assets = 5812.70 for the period ending 31st March 2018

Total Debts is calculated as:

  • Total Debts = Borrowings (22) + Other Financial Liabilities (23) + Borrowings (26)
  • Total Debts = 201.04 + 4.25 + 85.49
  • Total Debts = 290.78

Debt to Asset Ratio is calculated using the formula given below

Debt to Asset Ratio = Total Debts / Total Assets

Example 3-2

  • Debt to Asset Ratio = 290.78 / 5812.70
  • Debt to Asset Ratio = 5%

Relevance and Uses

For a business to operate and grow, it has to make revenue as well as capital expenditure. For this, firms can take capital either in the form of Equity or Debt. Each source of capital has advantages and disadvantages.

Debt is relatively less costly compared to equity for the Business. But business can’t run fully on debt. So business has to mix its capital structure with equity and some part with debt.

There are industry benchmarks for an optimum capital structure that are perceived to be ideal.

The debt to Asset ratio formula calculates what percent of a Business’s asset is funded using debt. Lesser the usage of debt is perceived to be sub-optimal usage of low-cost capital since debt is a cheap cost of capital and interest expense is a tax-deductible expense, optimum use of debt in the capital structure will help to maximize the shareholder’s wealth.

At the same time, excess debt in the capital structure perceived to be risky as debt is an interest-bearing instrument and demands fixed payments periodically. If the business is not performing well and operating profit is not enough to cover the fixed debt obligation, then this can trigger an event of default and take the company to bankruptcy.

The debt to Asset ratio is mainly used by Analyst, Investors, .and Lenders who track the company for various purpose.

  • If Debt to Asset Ratio is >100%: This situation is extremely risky; this means the company has eroded all its net worth and has been making losses, and entire assets, as well as losses, are funded by Debts.
  • If Debt to Asset Ratio is = 100%: This situation is also considered to be risky, this means the company has lost all the net worth, and the entire assets are funded by Debt.
  • If Debt to Asset Ratio is < 100%: This situation is considered to be less risky, this indicates the Assets of the company are funded by a mix of Debt and Equity Capital.

There is no single Debt to Asset Ratio which is considered to be optimal. The company under evaluation is considered to be safe if its Debt to Asset Ratio is in line with the Industry benchmark in which it is operating.

The debt to Asset Ratio formula is very important to assess the Financial Risk of a Company.

Debt to Asset Ratio Formula Calculator

You can use the following Debt to Asset Ratio Calculator.

Total Debts
Total Assets
Debt to Asset Ratio Formula
 

Debt to Asset Ratio Formula =
Total Debts =
Total Assets
0 = 0
0

Recommended Articles

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

  1. The formula for Expected Return
  2. Debt Service Coverage Ratio Formula
  3. How to Calculate Discount Factor?
  4. Calculator for Sharpe Ratio Formula

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

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

Download Debt to Asset Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Debt to Asset Ratio Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW