Times Interest Earned Calculator

The times interest earned ratio, sometimes referred to as the interest coverage ratio, is a leverage ratio designed to measure the amount of earnings a business has available has to make interest payments on its borrowings.

The earnings before interest and tax is what is left of the income after the business has paid all its operating expenses, this at the very least should be sufficient to pay the interest due on the borrowings of the business.

If the times interest earned cover falls too low, the business may be deemed to be a high risk by the lenders and as such may find its borrowing facilities reduced or even withdrawn.

times interest earned calculator v 1.0
Times Interest Earned Calculator Preview

The ratio is calculated using the times interest earned ratio formula by dividing the earnings before interest and tax by the interest expense.

Times interest earned = Earnings before interest and tax (EBIT) / Interest expense

Both figures are found on the income statement of the business.

Using the times interest earned Calculator

The Excel times interest earned calculator, available for download below, calculates the times interest earned ratio by entering details relating to the earnings before interest and tax, and interest expense from the income statement. The calculator is used as follows:

  • The earnings before interest and tax is entered. Earnings before interest and tax (EBIT) is found on the income statement of the business. It is sometimes referred to as profit before interest and tax (PBIT).
  • The interest expense is entered. The interest expense is also found on the income statement of the business and represents the amount of interest charged on borrowings for the year.
  • The times interest earned ratio is calculated. The times interest earned calculator calculates the TIE ratio.

There is no correct value for the times interest earned ratio as it depends on the industry in which the business operates. It is useful to compare the calculated figure with other businesses in you industry using figures available from published financial statements. The times interest ratio should always be higher than 1 otherwise the business is not generating enough income to meet its interest obligations.

Times Interest Earned Calculator Download

The times interest earned spreadsheet calculator is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this times earned interest ratio calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a tool that you might use to show how to calculate times interest earned. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in the times interest earned calculator, please let us know and we will try to fix it.
Times Interest Earned Calculator November 6th, 2016Team

You May Also Like

Related pages

accounts template excelfuture value of annuity due formulareconciliation sheet templatebookkeeping definitionfifo equationmargin to markuppresent value of an annuity chartaccrued expenses income statementjob cost sheet formatpmt accountingannuity cash flow formulahow to calculate interest rate implicit in the leasetrading marketable securitiesmicrosoft balance sheet templateasset turnover ratio analysisinternal rate of return discount ratewhat is annuity duepresent value of annuityfixed asset turnover exampleunder the allowance method writing off an uncollectible accountpv of perpetuity calculatorexamples of journal entries with narrationdouble declining balance depreciation examplecommon bookkeeping entrieshow to reconcile retained earningsdouble entry bookkeeping examplewhat is recourse factoringinventory turnover formula examplewhat is annuity formulapresent value of lump sum formulacapital lease entriesfv annuity due formulainterest accrual journal entryopposite of accrueannualization calculatorcalculate future value of an annuitydebtors turnover formulabad debt provision ifrsdegrees of operating leveragepayroll accounting tutorialfob freight prepaidbad debt expense journal entrymonthly bank statement templategeneral ledger chart of accounts exampleshow to record depreciation expense journal entrycalculating the payback periodtransposition errorsannuity pv calculatorbank reconciliation reconciling itemsspecimen of trial balancestraight line depreciation book valuetimes interest coverage ratioliquidation of partnership accountingsum of years digits depreciation formula10 steps in the accounting cyclepresent value of a annuityhow to calculate ending raw materials inventorypetty cash on balance sheetsmall business accounting excel spreadsheetdirect material price variancewhat is beginning inventorysimple ledger templatedouble declining balance depreciation methodaccounting solverconvertible note accounting treatmentaccounting entries for finance leaseadjusting entries affectaccount receivable template excel formatdefine bills receivablejournal entries for dummiesdefine notes payabletotal variable cost equationflexible budget definitionpresent value of future annuity calculatorcapital gearing ratioconsignee and consignorbank reconcilationshow to do vertical analysis of income statementprovision for bad debts in trial balanceaccounting double entry system examplesuspense account accountingmeaning of deferred tax liabilities