We found cash available for term loan B sweep 5.1. What we need to do now is start actually paying off some of term loan B. So I need to start with the closing balance in the proforma column. I can find that on the Input tab. In the Input tab, we've got that in our sources of funds. How much did we start the deal with? The term loan B was 800. That's going to be my opening balance next period and my mandatory repayment is given in the assumptions but it may be the case that with these accelerated repayments that we might not need to make mandatory repayments in the future. So what I'm gonna say is I want the minus minimum of my beginning balance or the 800 locked times by the assumption given at the top. The assumption for our term loan B was 0%. What's the minimum of zero or the beginning balance? It's going to be zero. So we're not going to pay off any of our term loan B using monetary repayments this period. But that means I do still have some cash available, 5.1, to make an accelerated repayment. So here again, I want to use the minus MIN function. I want the minus minimum of the 800 plus anything I've paid off versus the 5.1, and in this case, 5.1 is paid off. I've got 800 or 5.1. I'm only gonna pay 5.1.

Some my ending balance has now reduced. We're gonna skip over the interest and now work out if there's any cash still available for the second lien sweep. Unfortunately, we had 5.1 and I'm now going to spend 5.1 of it. You may be asking, hang on, hang on. Why have you not included the mandatory repayment? Well, the mandatory repayment has been included way further up here when we've worked out our cash flow available for debt service. Then we paid off the interest, we then paid off the mandatory repayments here. Those figures have then flown through into calculating that 10.3 available and the 5.1 that we're actually using to pay off.

So unfortunately you had 5.1, you spent 5.1. So we now carry on. We do pretty much the same thing for the second lien. Again, I go to the Input tab. On the Input tab, I find the second lien of 300, which becomes my beginning balance of 300. My mandatory repayment is again that minus minimum of beginning balance versus the 300 times by that assumption at the top. So second lien again was 0%. So I pay off nothing. My accelerated repayment says I want to take the minus minimum of the 300 less anything you paid off or the zero.

So basically, do you have debt to pay off? Yes, 300. Do you have any cash with which to pay it off with? No, unfortunately, we don't. So we don't do any accelerated repayments.

So that's our cash sweep done. We carry on past the interest expense and we now go to the high yield. Here there's only mandatory repayments and accelerated isn't available. Again, I go to the Input tab, I find the high yield at deal start, it was 100. That becomes my opening balance and my repayment. I don't need to do any minus mins here. It's simply going to be the 100 balance you started with. Gonna lock that and then multiply that by the assumption at the top.

High yield and at the moment, paying off nothing.