**You can take notes as you view lessons.**

Sign in or start a free trial to avail of this feature.

Loan covenants often contain specific ratios that a company must abide by. Find out how to calculate these ratios in this lesson.

**Key Metrics for Covenants**

- Covenant metrics focus on MarkerCo's ability to repay debt from free cashflow and EBITDA

- They include various ways to combine EBITDA, Capex, Interest, Net Debt and cashflow

- The covenant metrics included in this lesson are:

--- Net Debt / EBITDA

--- Net Debt / (EBITDA - CapEx)

--- EBITDA / Net Interest Expense

--- (EBITDA - CapEx) / Net Interest Expense

--- Debt Service Coverage Ratio (i.e. Net Operating Income / Total Debt Service)

In this lesson, we're going to calculate some key ratios for MarkerCo. In the past, we focused on operating metrics such as profit margin, EBITDA margin, and days receivable. Here, I'm going to focus on some new metrics that lenders will normally be very interested in. Primarily gauging the reliability of MarkerCo. to repay its loans.

As you can see from this list, the words "net debt" appear quite often. Net debt is a relatively simple concept and found by subtracting the ending cash balance from the ending debt balance each year. I'll now do this quickly, starting by calculating the total ending debt balance. This will equal to the ending debt balance for the senior notes plus subordinated notes.

And I'll copy across for the remaining cells.

And as you can imagine, the ending debt balance decreases over time as the senior notes are paid back.

To calculate net debt, I simply take this number and subtract the ending cash balance.

And again I'll copy across for the remaining cells. And as you can see, net debt turns negative in 2019 because the cash balance is now greater than the debt remaining. Let's now calculate our first ratio.

So I'll take net debt and divide by EBITDA which I can find in the Income Statement And I'll copy across for the remaining cells.

The next ratio I'm going to calculate is EBITDA divided by interest expense. Again I can find these numbers in my Income Statement, so I'll write equals, scroll up to my Income Statement, find EBITDA, and divide by the interest expense.

This can be found here. And I'll include a minus sign because I don't want my metric being a negative number. And I'll scroll across and copy with Ctrl + R.

As an exercise, try and complete these ratios replacing EBITDA with EBITDA minus CapEx.

Off camera, I will now perform these calculations to save some time.

The last metric I'm going to calculate here is the debt service coverage ratio which compares the amount of cash available to pay down debt against the amount of debt that must be paid each year up to 2020. So I'll start by taking the free cash flow and adding the interest payments to this number.

And then I'll divide by the amount of debt that must be paid back each year and interest.

So here's the interest plus the mandatory payment on subordinated notes plus the mandatory payment on senior notes. And I'll just change the sign of this also.

And I'll copy across for the remaining cells. And as you can imagine, the debt service coverage ratio grows over time as our debt is paid down. Off camera, I'm going to update the heading for this section and reformat these ratios so that they're easier to read. From a lender's perspective, the debt service coverage ratio is worrying, particularly in the early years. The larger interest and principle payments due cannot be covered by operating income, and as a result the debt service ratio is below one right up until year three.

A lender would ideally like this above 1.1 if at all possible. Essentially, Privak is using MarkerCo.'s large cash balance to pay debt down in the early years until EBITDA growth and a smaller debt balance improves my key metrics in later years. When analyzing these metrics, it's important to rationalize a story behind the numbers, as I have done here, that lets you know how the debt will be paid for and what causes a change in your values over the life of an investment. It's also worth noting that banks calculate the debt service coverage ratio in different ways and you may need to adjust this formula depending on how your client or the lender calculates the debt service coverage ratio.

Sign in or start a free trial to avail of this feature.