Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Times Interest Earned Ratio (And 4 More To Analyse A Company’S Debt)

Written by  MarketXLS Team on 
Sun Jul 30 2017
 about Fundamental analysis
Times Interest Earned Ratio (And 4 More To Analyse A Company’S Debt) - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
Times Interest Earned Ratio (And 4 More To Analyse A Company’S Debt) - MarketXLS

What is Times Interest Earned Ratio

Times interest earned ratio indicates a company’s ability to meet interest payments when they come due. The higher the ratio the more easily the company can meet its interest expenses. Times interest earned ratio is also known as Interest Coverage Ratio

Typically you would look at this ratio along with the debt to total assets ratio. The debt to total assets ratio measures the percentage of the assets provided by creditors. A higher debt to total assets ratio could raise doubts about the company’s ability to meet its obligations.

If a company has very high debt to total assets ratio and also a very high times interest and ratio, it would mean that even though the debt is high but with its operating income the company will be able to meet its obligations of interest expenses. So what you want to see here are high, times interest earned ratio.

This ratio is a solvency ratio, and it tells us how many times our income can cover our interest expense.

Times Interest Earned Ratio Formula

We can calculate times interest on earnings ratio as follows

times interest earned ratio

We can calculate Debt to Total Assets Ratio is by dividing Total Debts by the Total Assets

You can use these two tools to analyze the long-term debt situation of the company. A very high debt to asset ratio and low times interest ratio can indicate financial difficulties. We must use these ratios with care when analyzing companies in different industries because of the difference in borrowing models. When analyzing financial services companies we need to look at this ratio differently against when analyzing a traditional manufacturing business.

Also, note that some companies may not have an interest expense but they may have interest income. For companies that have positive interest income, where they get more interest income than they what they pay, this ratio should not be calculated. If this ratio increases for a few years and there is no change in the debt, it may suggest operational inefficiency.

Calculate Times Interest Earned Ratio with MarketXLS Formulas

MarketXLS provides the formula as for earnings before interest and taxes and also for the interest expenses. So not only you could calculate the latest ratio but you can easily create a model to analyze it over last few years. MarketXLS is not a calculator but it provides the formula you need to make a calculator yourself. So, once you know how to calculate a ratio you can yourself use the component functions and make your own custom formulas.

In the example below I calculate this ratio for a few companies.

alt="Times Interest Earned Ratio (And 4 More To Analyse A Company’S Debt)">TCI-Ratio-calculation.png” alt=”times interest earned ratio” width=”567″ height=”472″ />

Morningstar website also shows the CRM&region=usa&culture=en-US”>same values.

What does this ratio reflect?

Let’s look at salesforce.com and see if we can make sense of consistent decline in the times interest earned ratio. So let’s first calculate the debt to asset ratio.

times interest earned ratio

You may notice that from 2014 they have also been a consistent decline in the debt to the asset ratio as well. So overall, this looks like a good sign for salesforce.com because not only do seem to be earning more and more but also they seem to be getting stronger with respect to their debt situation.

Even though the time interest earned ratio is a favorable one, we must analyze it very carefully. A high ratio could also mean that the company is not managing its debt on its financial leveraged in a most efficient way. It could also mean that the company is the paying its debt fast to reduce its liabilities and is not investing enough in the growth of the company through new projects.

Other similar ratios on the same concept

There are some other useful ratios that are very similar in nature. The Fixed Payment Coverage ratio suggests the company’s ability to pay for the fixed payments with its operating income before tax. The cash coverage reflects a company’s ability to pay for its interest expenses with cash.

The EBITDA coverage reflects the company’s ability to pay for its average liabilities with EBITDA. And the cash coverage ratio reflects its ability to pay for average liabilities with the cash in hand.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord