From the course: Excel for Finance: Building a Three-Statement Operating Model

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Modeling the revolver

Modeling the revolver - Microsoft Excel Tutorial

From the course: Excel for Finance: Building a Three-Statement Operating Model

Start my 1-month free trial Buy for my team

Modeling the revolver

“

- [Instructor] Alright, so now let's move on to modeling out the revolver portion of the debt schedule because we've completed the cash flow sweep. However, I do want to make note one small change we need to make to this formula. So hit F2. It actually shouldn't be the negative maximum so get rid of that negative. It should be the maximum of the negative cash flow available to sweep multiplied by the sweep percentage and the negative sum of my debt balances. So just make that small change. Sorry about that. Hit enter and then drag this out to the right, right? I said it was a complicated formula. All right, so now let's go down to the revolver. So what we need to do with the revolver is in terms of the cash flow sweep, we've already calculated here whether we need to borrow or pay down. And so for the revolver we just need to capture the borrowing amount, otherwise just pay it down in full. We just can't pay it down…

Contents