EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Coverage Ratio Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Coverage Ratio Formula

By Madhuri ThakurMadhuri Thakur

Coverage Ratio Formula

Coverage Ratio Formula (Table of Contents)

  • Coverage Ratio Formula
  • Examples of Coverage Ratio Formula
  • Coverage Ratio Formula in Excel (With Excel Template)

Coverage Ratio Formula

A Coverage ratio is a group of measurement to find out the capability of a specific company to serve its debt and financial commitment such as interest payments and liabilities to pay back at a particular time. High ratio value indicates high ability whereas low value indicates less ability. Many factors are considered to examine this such as Net income, interest, total assets, Liabilities unpaid, etc. The low ratio does not always mean less capacity. Other financial conditions are as applicable such as liquidity, solvency capacity. Though there are multiple types of coverage ratio, three ratios are commonly used by investors in the market.

Start Your Free Investment Banking Course

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

#1 – Interest Coverage Ratio

This is also known as the time’s interest earned ratio. It is the ability of a company to pay back the interest within the given time on a particular debt.

Interest Coverage Ratio (ICR) = EBIT / Interest Expense

#2 – Debt Service Coverage Ratio

This is the capacity to pay the complete debt service by a company. While calculating this, the principal + interest are considered for the upcoming term also from the income statement. It can be calculated by the following formula.

Debt Service Coverage Ratio (DSCR) = Net Operating Income / Total Debt Service

#3 – Asset Coverage Ratio

This is the capacity to pay the complete debt service for owing the assets by a company. The assets are tangible assets such as land, machinery, infrastructures, houses, etc. which comes in the balance sheet. It can be calculated by the following formula.

Asset Coverage Ratio (ACR) = (Total Tangible Assets – Short Term Liabilities) / Total Outstanding Debt

Examples of Coverage Ratio Formula

You can download this Coverage Ratio Formula Excel Template here – Coverage Ratio Formula Excel Template

Coverage Ratio Formula – Example #1

ABC is a small beauty Products Company. Its EBIT is Rs.400000 and respective Interest Payments of 100000. The same Company generates a profit of Rs.200000 quarterly and its quarterly principal payment is 140000. Company ABC has tangible assets of RS.3600000 and it has tax payments for 600000 worth and the company’s total debt equals 2000000. Calculate Coverage Ratio using the following information.

Example 1-1

Solution:

Interest Coverage Ratio is calculated using the formula given below

Interest Coverage Ratio (ICR) = EBIT / Interest Expense

Coverage Ratio Formula Example 1-2

  • Interest Coverage Ratio = 400000 / 100000
  • Interest Coverage Ratio = 4

Which shows Good capacity of Debt coverage by ABC.

Total Debt Service is calculated using the formula given below

Total Debt Service = Interest Expense + Principal Payment

Calculation of Total Debt Service Example 1

  • Total Debt Service = 100000 + 140000
  • Total Debt Service = 240000

Debt Service Coverage Ratio is calculated using the formula given below

Debt Service Coverage Ratio (DSCR) = Net Operating Income / Total Debt Service

Calculation of Debt Service Coverage Ratio Example 1

  • Debt Service Coverage Ratio = 200000 / 240000
  • Debt Service Coverage Ratio = 0.833

Which shows less capacity of Debt coverage by ABC.

Asset Coverage Ratio is calculated using the formula given below

Asset Coverage Ratio (ACR) = (Total Tangible Assets – Short Term Liabilities) / Total Outstanding Debt

Coverage Ratio Formula Example 1-5

  • Asset Coverage Ratio = (3600000 – 600000) / 2000000
  • Asset Coverage Ratio = 1.5

Which shows the Optimum capacity of Asset coverage by ABC.

Coverage Ratio Formula – Example #2

Let’s assume Dyeing Company Camex makes a profit of RS.5000000 semi-annually and its EBIT is Rs.8000000. It has total tangible assets of 6700000 and respective Interest Payments of 6000000 and Intangible assets such as logo, trademark worth RS.200000 and Current Liabilities of Rs.300000, short term liability of Rs.100000.Its Quarterly principal payment is 1400000. Total Debt Equals 9000000. Calculate Coverage Ratio using the following information.

Example 2-1

Solution:

Interest Coverage Ratio is calculated using the formula given below

Interest Coverage Ratio (ICR) = EBIT / Interest Expense

Coverage Ratio Formula Example 2-2

  • Interest Coverage Ratio = 8000000 / 6000000
  • Interest Coverage Ratio = 1.333

Total Debt Service is calculated using the formula given below

Total Debt Service = Interest Expense + Principal Payment

Calculation of Total Debt Service Example 2

  • Total Debt Service = 6000000 + 1400000
  • Total Debt Service = 7400000

Debt Service Coverage Ratio is calculated using the formula given below

Debt Service Coverage Ratio (DSCR) = Net Operating Income / Total Debt Service

Calculation of Debt Service Coverage Ratio Example 2

  • Debt Service Coverage Ratio = 5000000 / 7400000
  • Debt Service Coverage Ratio = 0.676

Asset Coverage Ratio is calculated using the formula given below

Asset Coverage Ratio (ACR) = (Total Tangible Assets – Short Term Liabilities) / Total Outstanding Debt

Coverage Ratio Formula Example 2-5

  • Asset Coverage Ratio = (6700000 – 200000 – 300000 – 100000) / 9000000
  • Asset Coverage Ratio = 0.678

Explanation

Here is the step by step approach for calculating all 3 coverage Ratios.

  1. Interest Coverage Ratio:

Step 1: EBIT Value is noted. EBIT is the Earnings before Interests and taxes value.

Step 2: Interest Expense value is noted. This is the regular interest payments by a company.

Step 3: The values are applied in the below to get the Interest coverage ratios calculated.

Interest Coverage Ratio (ICR) = EBIT/ Interest Expense

2 or higher Interest Coverage ratio is generally considered for good capacity. It can be calculated using the below formula.

  1. Debt Service Coverage Ratio:

Step 1: Net Operating Income Value is noted. As the variable name says, it is the net income when a company is operational.

Step 2: Total Debt Service value is noted. This is the value of the debt a company owes.

Step 3: The values are applied in the below formula to get the Debt Service coverage ratios calculated.

Debt Service Coverage Ratio (DSCR) = Net Operating Income/ Total Debt Service

1 or higher the ratio value says a company has good earnings to remunerate its entire debt obligations

  1. Asset Coverage Ratio:

Step 1: Total Tangible Assets Value is noted. This includes tangible assets such as buildings, vehicles, machinery, land, houses, etc.

Step 2: Total Short term liabilities value is noted. This includes such as dividends payables, taxes payables, customer deposits, etc.

Step 3: Total Outstanding Debt value is noted. This is unpaid remaining total debt amount including the near term payments.

Step 4: The values are applied in the below formula to get the Asset coverage ratios calculated.

Asset Coverage Ratio (DSCR) = (Total Tangible Assets- Short term liabilities)/ Total Outstanding Debt

1.5 is considered as a good value in normal whereas for companies like industries 2 is considered satisfactory.

Relevance and Use of Coverage Ratio Formula

Coverage Ratio helps to identify the ability of a company when it is in potentially troubled financial Situations. It can help in 2 situations. For Company situation over time, we can track the changes. We need Debt History in this case. This is the ideal key to find the relationship between a company and its competitors. But each field has different key factors to be compared with and it is riskier too. So Business comparison and evaluation in different fields are not that easy. Hence using ICR, DSCR and ACR one can easily compare between companies in the same field as it gives depth insights.

Coverage Ratio Formula in Excel (With Excel Template)

Here we will do the example of the Coverage Ratio formula. It is very easy and simple.

Now let us take the real-life example below to calculate Coverage Ratios with 2 sets of Different Values of different companies.

Example 3-1

Interest Coverage Ratio is calculated using the formula given below

Interest Coverage Ratio (ICR) = EBIT / Interest Expense

Coverage Ratio Formula Example 3-2

For MomCorp

  • Interest Coverage Ratio = 8500000 / 8000000
  • Interest Coverage Ratio = 1.063

For Bioherb

  • Interest Coverage Ratio = 5000000 / 300000
  • Interest Coverage Ratio = 16.667

Total Debt Service is calculated using the formula given below

Total Debt Service = Interest Expense + Principal Payment

Calculation of Total Debt Service Example 3

For MomCorp

  • Total Debt Service = 8000000 + 6000000
  • Total Debt Service = 14000000

For Bioherb

  • Total Debt Service = 300000 + 500000
  • Total Debt Service = 800000

Debt Service Coverage Ratio is calculated using the formula given below

Debt Service Coverage Ratio (DSCR) = Net Operating Income / Total Debt Service

Calculation of Debt Service Coverage Ratio Example 3

For MomCorp

  • Debt Service Coverage Ratio = 9000000 / 14000000
  • Debt Service Coverage Ratio = 0.643

For Bioherb

  • Debt Service Coverage Ratio = 9000000 / 800000
  • Debt Service Coverage Ratio = 11.25

Asset Coverage Ratio is calculated using the formula given below

Asset Coverage Ratio (ACR) = (Total Tangible Assets – Short Term Liabilities – Current Liability) / Total Outstanding Debt

Coverage Ratio Formula Example 3-5

For MomCorp

  • Asset Coverage Ratio = (3400000 – 1100000 – 2000000) / 6000000
  • Asset Coverage Ratio = 0.05

For Bioherb

  • Asset Coverage Ratio = (7000000 – 400000 – 0) / 200000
  • Asset Coverage Ratio = 33

Here if you take Bioherb, it has better coverage ratios in all aspects when compared with MomCorp. But as it is said earlier, we cannot compare companies which are in different fields.

Recommended Articles

This has been a guide to Coverage Ratio formula. Here we discuss how to calculate Coverage Ratio along with practical examples and downloadable excel template. You may also look at the following articles to learn more –

  1. Guide To Market to Book Ratio Formula
  2. How To calculate Capital Adequacy Ratio?
  3. Examples of Debt to Asset Ratio Formula
  4. Formula For Marginal Propensity to Consume
  5. Formula and Examples of Interest Coverage Ratio
  6. Complete Guide to Coverage Ratio
Popular Course in this category
Financial Analyst Masters Training Program
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Investment Banking Training4.9
Investment Banking Training4.8
Financial Modeling Training4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • 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
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

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

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

Download Coverage Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

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

EDUCBA

डाउनलोड Coverage Ratio Formula Excel 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