1.5 Hour LBO Test
Just had a modeling test and was given a CIM to build a 3-statement model in 1.5 hours. I tried my best to construct everything (i.e., debt schedule, operating model, etc.), but wasn't able to build out a clean BS and CFS.
Was able to get all my assumptions and IRR/MOIC. Wish I had more time. Has anyone had an experience like this in the past?
This happened to one of my roommates on one of his modeling tests. I think it depends on how close you were. The BS is generally the least important part of an LBO so as long as you get NWC, I think you should be fine there. The CFS is more important, but it could be okay as long as you got to LFCF & cash available for debt paydown and flows through your debt schedule properly.
Did they give you a lot of the assumptions around the operating model and transaction assumptions? 1.5 hours for a full LBO where you have to go through the CIM, hard-code numbers, and apply your own assumptions sounds like a tall order to me. Also, if they gave you a lot of the assumptions and you got the IRR and MOI calculations right, I think that definitely helps your cause.
Appreciate the response. I was able to get LFCF and a proper debt schedule down. Everything else flowed well as well as some sensitivity tables at the end.
I had to come up with all my assumptions using the CIM. Their instructions were just two lines: Build a 3 statement model and create your assumptions using the CIM.
Was your roommate able to move forward in the process?
Agree here. Same thing happened to me, where i had a properly flowing LBO but did not build out a separate BS or CFS - only the model, debt paydown schedule, resulting LFCF, and resulting MOIC/IRRs.
Not sure how these models are reviewed after, but I imagine the Associates were too lazy to go into detail and just cared about the LBO itself.
I got the offer
Might be a dumb q but how do you get to debt paydown, lfcf, moic and irr without a clean cfs?
Check your PM, I dropped you a note.
I incorporated this as part of the interview process for our associates. I also did this when I was interviewing at a couple different shops.
The expectation is to just jam something functional together. You will be judged on if it balances and is complete, not necessarily on your assumptions.
I'd say that when I was checking these about 2/5 were complete and correct. A lot of kids try getting too elaborate and don't finish
Feel like there are two schools of thought here.
In a situation like this, what do you guys think is best?
1) just getting a full 3 statement model that is balanced / working with very high level assumptions (e.g., revenue growth in-line with GDP, ~200 bps of margin improvement due to operating leverage)
2) being thoughtful about the drivers (e.g., splitting out revenue by price vs. volume and making assumptions on each) and making simplified assumptions on the things that are not as impactful (e.g., NWC as a % of sales)?
Pretty classic. Practice makes perfect.
I think you will likely be fine. In my experience, the model is more of a implementation exercise and a pass / fail type effort - doing a great job won’t get you the role but doing a bad job will keep you out. I think anything that is a higher than a B+ will probably get you to the next round.
At my previous fund, the important thing was that the model was dynamic and flowed correctly. For example, if the instructions said 2% transaction fees but a candidate put in 1% or 3% or whatever on accident and if the returns changed after we put in 2% - not that big of a deal. But if everything was right but we couldn’t toggle assumptions / have returns move - that’s probably below the B+.
Would be curious to hear how other funds score their model tests.
Qui rem laudantium magni asperiores qui a. Consequatur dolor sit ratione. Est animi quo veritatis. Dolore ut temporibus quis.
Deleniti earum quia et doloribus voluptatem. Aliquid qui cupiditate blanditiis voluptatem et vitae temporibus.
Aliquid laboriosam fugiat quia aspernatur. Sapiente adipisci accusamus sed. Voluptatem dolorem omnis quia laboriosam corrupti et. Optio est architecto quae quia debitis cupiditate et.
Animi quas inventore magnam laboriosam excepturi. Repellendus adipisci doloremque quasi consequatur sunt inventore dicta. Velit velit beatae qui voluptatem consequuntur quia.
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...