In step 4, we calculate debt repayments via a cash sweep mechanism Our cash sweep is going to work between the cash flow statement and the debt schedule Let's do it for the revolver to start with. What I want to here, is I want to use that 50.9 of cash I've got available to pay off the revolver if I've got one. But if I don't have a revolver I don't want to use it So I want to take the minimum of those two numbers. I also want this to be shown as a negative So it'll be a minus min So I want the minus minimum of cash I've got available and the revolver balance, so I scroll up to my debt schedule And in my debt schedule, I can see that in that year my beginning balance of the revolver is zero. So I want the minimum of zero and 50.9, it's going to choose zero Great! Now we move on to term loan A, so term loan A I want a similar thing to happen (I want the minus minimum) But I may have used up some of that 50.9, I may have used some of it on the revolver So imagine I had used 10 on the revolver here, I would now be asking for the minimum of 40.9 because that would be the cash that I've still got available Okay in this case, I've still got 50.9, so I want the minimum of 50.9 and my term loan A beginning balance So again scroll up to term loan A's beginning balance Which is 425, so clearly there's far too much debt at the moment So I can't pay all of it off, I'm going to pay off 50.9 And that's what happens Next up, term loan B. I want to do something similar again How much cash did I have? I had 50.9, but then I spent zero on the revolver and I've spent 50.9 on term loan A So at the moment I've got no cash, so I'm not going to make a repayment unfortunately on term loan B However I could make a repayment in the future So I want the minus minimum of my cash at this stage and my beginning balance of term loan B So scroll up again, find term loan B's beginning balance And that's 165 At the moment, no repayment of term loan B So my net cash flow is the sum of cash that I had available for debt repayment and any repayment I actually made My eventual cash balance at the end then will be cash balance plus my net cash flow of zero Now if I copy these to the right, we'll going to find sum very silly numbers appear because I haven't finished up my debt schedule So we find that yes it works in year but then I find that I use all of my cash to repay the revolver That's because if I went and looked at the beginning balance of the revolver, I would just see some blank cells As we fill the debt schedule in, these figures will automatically update