# 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.

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.