Copy to Complete the Model
- 03:20
LBO modeling complexities copy to complete the model
Downloads
No associated resources to download.
Glossary
LBO LBO modeling Private EquityTranscript
Now that the model balances, and I have interest income and expense flowing through the model, it's a really good time to copy across. I still have a little bit of work to do on the sale leaseback, the dividend portion, and I wanna look at the returns, but the returns will make a lot more sense if I actually have some data in the outer cells. So before I go ahead and copy across, I want to turn my circular switch off, and that's a safer way to do it. I have some formulas displaying as text in the outer columns and they're gonna wreak havoc with the circular reference. Next thing I wanna do is I wanna go to my calcs and I wanna start at the very top and copy across. I wanna be careful not to pick up any hard-coded numbers, any assumptions that I might be copying over, and I wanna work across. Now for the income statement, I've already got 2016 and 2017 done. I gotta be careful of 2016 'cause it's this odd year that jumps across three columns. So I wanna make sure that I'm actually starting in 2017. And then I'm gonna go to the balance sheet, and immediately we already see that we're out of balance because of that interest component with the mezzanine non-cash interest. The balance sheet is gonna be out of whack until we get everything copied, and until we get the interest income and expense flowing back into the model again. In this model, we only really have interest expense. So the last thing that I'll do here is copy down the debt and then I will take a quick look at my balance sheet. It looks like I'm off only by the amount of the mezzanine, so I'm gonna go back to my page, info page, and turn on the switch and then I'll go back to my balance sheet and it looks like we are good to go.
So the next thing that I would want to do at this point, having copied, is just take a look at my scenarios and see if they are working in this copied model. There was a lot of anchoring of cells and whatnot. So what I'm gonna do is, first of all, I can try turning on and off my switches and see if that actually works and it looks like it does. So I'll turn these back on, and then I'm gonna switch my capital structure out to the Unitranche and make sure that's working.
So I'll go to the debt page and take a look down at my Unitranche and that does seem to be flowing. I have the cash sweep off, so I'll put that on, and that looks to be working as well.
And then lastly, I will look at how the sale leaseback is working, at least from a debt perspective, and that seems to be working as well.
So now that I've got the model copied across, I am ready to take a look at the returns.