Debt - Ending Cash Checks
- 04:30
Reviewing cash used in the debt schedule to see what it has been used for
Transcript
Let's total up debt and it will then be ready to be put into the balance sheet. We start with the revolving credit facility and we've got that all the way up in row 64.
So there's our revolver and we just want the closing balance and that was zero in this period.
We then move on to the refinancing facility. That was up in row 82.
Closing balance of zero. CapEx, I just want to look at the facility that was drawn down here. I don't want to include any undrawn portion. We've got that just a little bit further up in row 159 and it was 50. Term loan B, closing balance 794.9. Second lien, closing balance of 300. High yield, 100, and mezzanine, 100 as well. So our total debt, 1,344.9.
Next in the ending cash checks, we want to check that our ending cash here equals the ending cash we're going to have in our balance sheet. So I start off with CFADS, our cash flow available for debt service. We've got that all the way up near the top in row 33. There's our CFADS, 30.3, but what did we do with it? Well, we spent a considerable amount of it on interest. At the moment that interest is showing zero because we haven't hooked interest up yet. So row, 45 net cash interest expense, a little bit of interest income, maybe zero. We also had mandatory repayments.
Up in row 52, again zero. Now, the remaining items are debt pay downs that aren't included in the mandatory repayments. The first of these was the revolver. Now the revolver, we need to include repayments but also drawdown as well. So I'm going to take row 62 and 63 and we had a little bit of a payoff there. The refinancing facility, we had nothing drawn down in this period. Term B's accelerated repayment only. We're not looking at the mandatory repayment here because the mandatory repayments will have gone through row 190. Exactly the same for our second lien. We just want to look at the accelerated repayment here. There's our second lien. No accelerator repayment in this period. And then I want to look at the CapEx drawdown. Now, I don't want to look at any CapEx repayments. So the drawdown was 50 because any repayments again will have gone through the mandatory repayments up here. So our net cash flow adds up to 55.1. Now, I need to add that onto any cash we had from the previous period. I'll need to go to the Deal_Date tab to get that. And in the Deal_Date tab, there it is in H61, it was 30.
That becomes my beginning balance. I add on the net cash flow and my ending cash comes to 85.1.
Let's make sure that we understand that properly. Let's do a little alternative check here, a shorter version if you will. We start with our ending cash last period of 30. That becomes my beginning cash this period. I then add on any cash flow available after refinance. So what cash flows are these? Well, that's gonna be my CFADS all the way down to my refinancing facility. So CFADS plus interest and monthly repayments and any revolver or refinancing repayments or drawdowns going on.
But we also then spent some money on the sweep. So I want to total up two items from above. We swept term B and the second lien. And lastly, we had our CapEx drawdown. The CapEx drawdown was 50. If I add it all up, it comes at 85.1, exactly the same figure. We would expect that 85.1 to appear in the deal model balance sheet once all of the debt items have been linked up to the balance sheet.