WSO Basic LBO Model #1
All,
Thanks for the help here. I've recently been going through the basic lbo models that WSO has as part of its prep package. One thing I am really confused about is the way they put minimum cash required to operate as a "Use of Cash" in the uses of cash section. Is this best practice for how one goes about modeling a minimum cash balance required in an LBO?
Secondly, I am also struggling with their formula for debt paydown in the debt schedule. The video tutorial is quite useless as even the person doing the tutorial makes several mistakes around this part that adds to the confusion. The formula they use is as follows:
=Min(Max(-BOP Bank Debt, -LCF-(BOP Cash-Min Cash)),0)
Can anyone explain this? I'm having a pretty hard time understanding this formula. Let me know if additional context is required to answer this question.
Thanks!
MultipleExpansion.com has been making the rounds recently and IMO is the best free LBO resource I've seen.
I haven't done the lbo model you're referring to, but typically you subtract mincash from cash flows and add it back to the end. This is so you don't "spend" all of the balance sheet cash on paying down debt or Capex, and keep the necessary cash on hand to keep running the company. Subtracting it just automatically stashes the required amount in the cookie jar for later. Make sense?
Intuitively I understand that that's what you have to do with Mincash (subtract it so that we "stash" it), but in the equation above, are we not adding Min Cash?
Think it may be the signs that are confusing me. Could you elaborate any more? Thank you for all the help by the way.
Yeah the formula you have above looks confusing. Check out multipleexpansion.com. Pretty clean template.
Let's break up the formula above...
Max(-Beginning debt, - (LCF + Beginning cash - Mincash)
Since it's max of a negative number, take whichever is "smaller" / closer to 0.
Then you're taking "min" of that and 0. This just ensures that your debt pay down can't be > 0, which makes sense. Debt pay down should always be "negative" outflow of cash.
Again, I think this is a confusing way to lay it out, and having made many of these, it took me a couple minutes to figure out what they were doing.
What is IMO?
Aut deleniti sit praesentium ut porro culpa voluptas. Id tenetur voluptate perferendis inventore. Architecto id culpa quidem velit sed dolorem.
Debitis perferendis nostrum quia consectetur quis voluptatem. Vel est soluta quasi. Labore culpa quibusdam enim est maiores nemo voluptas laborum. Nihil officiis delectus est eveniet error. Quos dicta omnis voluptatem consequatur sed.
Facilis labore earum atque facilis numquam possimus quia. Eos sequi esse quia sit dolor doloribus iure aperiam. Sunt est voluptatem sunt. Enim saepe modi adipisci omnis quidem quia repellendus. Sit est esse tempore et optio veritatis. Quod temporibus eaque culpa alias fugiat vero consequuntur.
Enim quas sed excepturi id ducimus repudiandae dolor. Optio quia enim omnis rem sunt. Dicta expedita qui vitae ut aut dolor consequatur ea.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...