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 Times Interest Earned Ratio Formula
 

Times Interest Earned Ratio Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 25, 2023

Times Interest Earned Ratio Formula

 

 

Times Interest Earned Ratio Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is the Times Interest Earned Ratio Formula?

The term “times interest earned ratio” refers to the financial metric that is used to assess the ability of a company to pay an interesting part of the debt obligations.

In other words, this financial metric indicates how many times the pre-tax earnings of a company can cover its interest expense. Times interest earned ratio is also known as the interest coverage ratio. The formula for times interest earned ratio can be derived by dividing the EBIT (earnings before interest and taxes) or operating income of the company by its interest expense. Mathematically, it is represented as,

Watch our Demo Courses and Videos

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

Times Interest Earned Ratio = Operating Income / Interest Expense

Examples of Times Interest Earned Ratio Formula (With Excel Template)

Let’s take an example to understand the calculation of Times Interest Earned Ratio in a better manner.

You can download this Times Interest Earned Ratio Formula Excel Template here – Times Interest Earned Ratio Formula Excel Template

Times Interest Earned Ratio Formula – Example #1

Let us take the example of a company that is engaged in the business of food store retail. During the year 2018, the company registered a net income of $4 million on revenue of $50 million. Further, the company paid interest at an effective rate of 3.5% on an average debt of $25 million along with taxes of $1.5 million. Calculate the Times interest earned ratio of the company for the year 2018.

Example of A Company-1.1

Solution:

Interest Expense is calculated using the formula given below

Interest Expense = Effective Interest Rate * Average Debt

Times Interest Earned Ratio Formula-1.2

  • Interest Expense = 3.5% * $25 million
  • Interest Expense = $0.875 million

Operating Income is calculated using the formula given below

Operating Income = Net Income + Interest Expense + Taxes

Operating Income -1.3

  • Operating Income = $4 million + $0.875 million + $1.5 million
  • Operating Income = $6.375 million

Times Interest Earned Ratio is calculated using the formula given below

Times Interest Earned Ratio = Operating Income / Interest Expense

Times Interest Earned Ratio Formula-1.4

  • Times Interest Earned Ratio = $6.375 million / $0.875 million
  • Times Interest Earned Ratio = 7.29x

Therefore, the Times interest earned ratio of the company for the year 2018 stood at 7.29x.

Times Interest Earned Ratio Formula – Example #2

Let us take the example of Apple Inc. to illustrate the computation of Times interest earned ratio. As per the annual report of 2018, the company registered an operating income of $70.90 billion while incurring an interest expense of $3.24 billion during the period. Calculate the Times interest earned ratio of Apple Inc. for the year 2018.

Example of Apple Inc.-2.1

Solution:

Times Interest Earned Ratio is calculated using the formula given below

Times Interest Earned Ratio = Operating Income / Interest Expense

Times Interest Earned Ratio Formula-2.2

  • Times Interest Earned Ratio = $70.90 billion / $3.24 billion
  • Times Interest Earned Ratio = 21.88x

Therefore, Apple Inc.’s Times interest earned ratio for the year 2018 stood at 21.88x.

Times Interest Earned Ratio Formula-2.5

Source Link: Apple Inc. Balance Sheet

Times Interest Earned Ratio Formula – Example #3

Let us take the example of Walmart Inc.’s annual report for the year 2018 to compute its Times interest earned ratio. According to the annual report, the company’s net income during the period was $10.52 billion. The interest expense towards debt and lease was $1.98 billion and $0.35 billion respectively. Calculate the Times interest earned ratio of Walmart Inc. for the year 2018 if the taxes paid during the period was $4.60 billion.

Example of Walmart Inc.’s -3.1

Solution:

Interest Expense is calculated using the formula given below

Interest Expense = Interest Expense for Debt + Interest Expense for Lease

Interest Expense -3.2

  • Interest Expense = $1.98 billion + $0.35 billion
  • Interest Expense = $2.33 billion

Operating Income is calculated using the formula given below

Operating Income = Net Income + Interest Expense + Taxes

Operating Income -3.3..

  • Operating Income = $10.52 billion + $2.33 billion + $4.60 billion
  • Operating Income = $17.45 billion

Times Interest Earned Ratio is calculated using the formula given below

Times Interest Earned Ratio = Operating Income / Interest Expense

Times Interest Earned Ratio Formula-3.4

  • Times Interest Earned Ratio = $17.45 billion / $2.33 billion
  • Times Interest Earned Ratio = 7.49x

Therefore, the ratio of Times interest earned of Walmart Inc. for the year 2018 stood at 7.49x.

Statement of Walmart Inc-3.5

Source: Walmart Annual Reports (Investor Relations)

Explanation

The formula for times interest earned ratio can be derived by using the following steps:

Step 1: Firstly, determine the interest expense incurred by the company. It is easily available from the income statement of the company.

Step 2: Next, determine the operating income of the subject company. In the most income statements, operating income or EBIT is mentioned as a separate line item. In case not provided in the income statement, it can be derived adding back the interest charge and taxes paid to the net income of the company.

Operating Income = Net Income + Interest Expense + Taxes

Step 3: Finally, the formula for times interest earned ratio can be derived by dividing the operating income (step 2) of the company by its interest expense (step 1) as shown below.

Times Interest Earned Ratio = Operating Income / Interest Expense

Relevance and Use of Times Interest Earned Ratio Formula

It is important to understand the concept of “Times interest earned ratio” as it is one of the predominantly financial metrics used to assess the financial health of a company. In case a company fails to meet its interest obligations, it is reported as an act of default and this could manifest into bankruptcy in some cases. So, it is very important that a company generating adequate cash flow to make timely principal and interest payments in order to avoid any kind of financial shortcomings.

Times Interest Earned Ratio Formula Calculator

You can use the following Calculator

Operating Income
Interest Expense
Times Interest Earned Ratio
 

Times Interest Earned Ratio =
Operating Income =
Interest Expense
0 = 0
0

Recommended Articles

This is a guide to Times Interest Earned Ratio Formula. Here we discuss how to calculate Times Interest Earned Ratio along with practical examples. We also provide a Times Interest Earned Ratio calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. Formula for Labor Force Participation Rate Formula
  2. How to calculate Net Cash Flow Formula
  3. Example of Accounting Rate of Return Formula
  4. Calculation of Coverage Ratio Formula
  5. Interest vs Dividend | Top 8 Key Differences You Should Know
  6. How to Calculate Cash Flow Formula?
  7. Coverage Ratio | Advantages and Disadvantages

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 Times Interest Earned Ratio Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Times Interest Earned Ratio Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW