Fundamental analysis

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

Written by admin
Sun Jul 30 2017
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

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.

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
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Cowen Inc. logo

Cowen Inc.

30.93
 
USD
 
6.89
 
(28.66%)
83
Rank
Optionable: Yes
Market Cap: 859 M
Industry: Capital Markets
52 week range    
21.35   
   41.05
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

90.12
 
USD
 
-2.72
 
(-2.93%)
82
Rank
Optionable: Yes
Market Cap: 11,928 M
Industry: Business Services
52 week range    
69.32   
   93.45
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

51.41
 
USD
 
-0.14
 
(-0.27%)
81
Rank
Optionable: No
Market Cap: 2,846 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Amdocs Limited logo

Amdocs Limited

83.04
 
USD
 
-1.41
 
(-1.67%)
80
Rank
Optionable: Yes
Market Cap: 10,201 M
Industry: Software - Infrastructure
52 week range    
67.36   
   87.76
NBT Bancorp Inc. logo

NBT Bancorp Inc.

38.30
 
USD
 
0.14
 
(0.37%)
79
Rank
Optionable: Yes
Market Cap: 1,640 M
Industry: Banks - Regional - US
52 week range    
31.68   
   41.70
CRA InternationalInc. logo

CRA InternationalInc.

89.64
 
USD
 
0.49
 
(0.55%)
79
Rank
Optionable: Yes
Market Cap: 661 M
Industry: Business Services
52 week range    
78.05   
   115.47
CatchMark Timber Trust Inc. Class A logo

CatchMark Timber Trust Inc. Class A

10.23
 
USD
 
0.01
 
(0.10%)
78
Rank
Optionable: Yes
Market Cap: 504 M
Industry: REIT - Diversified
52 week range    
7.05   
   12.39
America's Car-Mart Inc. logo

America's Car-Mart Inc.

107.19
 
USD
 
5.55
 
(5.46%)
77
Rank
Optionable: Yes
Market Cap: 683 M
Industry: Auto & Truck Dealerships
52 week range    
72.50   
   165.50
ManTech International Corporation logo

ManTech International Corporation

95.66
 
USD
 
0.26
 
(0.27%)
76
Rank
Optionable: Yes
Market Cap: 3,917 M
Industry: Software - Application
52 week range    
66.09   
   95.87
CACI International Inc. Class A logo

CACI International Inc. Class A

279.18
 
USD
 
-8.01
 
(-2.79%)
76
Rank
Optionable: Yes
Market Cap: 6,536 M
Industry: Information Technology Services
52 week range    
238.29   
   313.52

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!