Interest Coverage Calculator

With the help of the interest coverage calculator, it is very easy to calculate the interest coverage ratio or times interest earned. You just need to find out three figures, i.e., EBIT, Interest Expenses, and Taxes, from the income statement of an entity. It is one of the important financial ratios, especially useful for lenders, debenture holders, financial institutions, etc. Looking from the interest of lenders, they are interested in evaluating the ability of an entity to pay fixed interest.

We would ask – What is the source of making payment of interest? PROFITS or CASH? The formula we use for our calculator is quite different from most websites and books. We have kept CASH into consideration rather than PROFITS, and that is why we have used the following formula.

The following formula is used to calculate the interest coverage ratio.

    PBIT + Non-Cash Expenses – Taxes
Interest Service Coverage Ratio (ISCR) = ————————-
    Interest

The numerator of the formula has three components

  1. PBIT is absolutely basic.
  2. Non-cash Expenses are added to PBIT when approach is relatively less conservative.
  3. Tax deducted from above because they are also confirmed payments.

Interest Coverage Calculator

How to Calculate using a Calculator?

We just need to plug in the following figures in the calculator.

PBIT – It can easily be calculated from the income statement. The full form of PBIT is profit before interest and taxes.

Non- Cash Expenses – Non-cash expenses mean expenses present in the income statement but not paid in cash. For example, depreciation, amortization, provisions, etc., are deducted from the income statement but are not paid in cash.

Interest Expense – Interest expense can be easily found out from the face of the income statement.

Taxes – The total tax on net profits that the entity is going to pay.

Excel Calculator – Interest Coverage Ratio

You can also download our excel based calculator for interest coverage ratio.

Excel Calculator for Interest Coverage Ratio (84 downloads )


Sanjay Borad

Sanjay Bulaki Borad

MBA-Finance, CMA, CS, Insolvency Professional, B'Com

Sanjay Borad, Founder of eFinanceManagement, is a Management Consultant with 7 years of MNC experience and 11 years in Consultancy. He caters to clients with turnovers from 200 Million to 12,000 Million, including listed entities, and has vast industry experience in over 20 sectors. Additionally, he serves as a visiting faculty for Finance and Costing in MBA Colleges and CA, CMA Coaching Classes.

4 thoughts on “Interest Coverage Calculator”

  1. 1.93. It means that the entity has 2.07 times of cash available to pay for the interest expense in the period.
    I believe there should be 1.93 times cash rather than 2.07 times cash . Thank you

    Reply
  2. Hello Sanjay,
    You may have corrected it already but the calculations in this piece are incorrect. The actual calculation resulting in 1.93 would be correct if the tax amount used was 24,000, not the 16,000 amount shown in the equation.
    Additionally, in the Interpretation paragraph, the inverse of the above error is described thus resulting in a separate error on it’s own.
    As you know, for every equation, there is only one correct answer. 1.93 can not be interpreted as 2.07.
    Thanks for all the great material you produce. I’ve been following eFinanceManagement for about a year and while I don’t fully review everything or see everything…..This is the first time I’ve noticed any errors. So, No Worries Kind Sir.
    Kind Regards,
    Greg Stecher

    Reply

Leave a Comment