Debt Schedule Tour
- 02:57
A look around an advanced LBO debt schedule to familiarize ourselves with what's to come before diving in
Downloads
Transcript
A way to sum up the debt schedule is that you take a big pile of cash and then you use that cash to pay off debt. So you have to start the debt schedule by working out that big pile of cash. At the top of the debt schedule here, we've got some assumptions, we've got some interest rate assumptions, and then you've got some debt issuance or repayment assumptions. But underneath that that's where your big pile of cash starts. You start with your EBITDA and then you look for any non-refinancing cash flow, such as tax expense increase, decrease in balance sheet items. That gets you down to your CFADs, your cash flow available for debt service. And we've got that in row 33, CFADs. With that cash flow, you ask what do I need to do with it? And the first thing you need to do is pay off the interest associated with any debt items. You then add on your interest income and then you pay off any mandatory repayment of debt. So our big pile of cash has already had a lot of use. We've used it to pay of interest and mandatory repayments of debt, but there are still some other items left over. So I get down to now cash flow still available before revolver, refinance facility and sweep. You add on any beginning cash, so any cash you had left over from last year. Subtract off any minimum required cash that you've got to leave lying around maybe as a cushion, as a buffer. And that now gets you your cash available for the remaining items. For your RCF, revolving credit facility, your refinance facility and to sweep. Sweep means to make accelerated repayments on your debt items. At the moment, you've only made mandatory repayments. So now let's go do those three things. We start with the RCF or revolver, we make repayments of it there, and underneath that you've got your interest. After that, you move on to the refinance facility, draw down all repayment there. Underneath that, it's interest and then you get onto the sweep. An interesting calculation has to happen here. This says that the more leverage you have, the more cash you have to use towards your sweep but if your leverage reduces, then you get to use less cash towards your sweep and maybe the remaining cash you can use for other items, which opens up the possibility that that cash that you're not using to pay off the sweep can maybe be paid as a dividend. Once you've worked out how much cash you're going to use in your sweep, you then use it to start paying off debt and we'll use it in term loan B first and then the remaining debt items underneath. Second lien, high yield, mezzanine, CapEx facility and then your debt original issuer discount. Some of them are not gonna be involved in the sweep. Underneath that, you then total up your total debts. Those items can go to the balance sheets and then we've got some checks. We just want to check that the cash in the cash flow statement and in the balance sheet equals the cash at the end of the debt schedule.