I am a newly promoted associate (ignore title) and I was wondering if anyone could share tips on how to check efficiently an LBO model that an Analyst did? Any tips is much appreciated - At the moment I am checking cell by cell and it takes forever / it is not efficient at all
| +69 | Wealthy Parents / Jaded | 23 | 7h |
| +49 | How are hours rn for SA (interns) | 29 | 16h |
| +46 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 4h |
| +36 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 9 | 17m |
| +33 | Boutique firm wants access to my LinkedIn? | 19 | 2h |
| +27 | Investment Banking in Mexico | 7 | 1d |
| +25 | MM bottom bucket bonus | 9 | 2d |
| +24 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 12 | 1d |
| +21 | Excel macros for QOL formatting | 0 | 3d |
| +20 | Freshman at Rutgers Newark — Best Way to Get an IB Internship? | 10 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Think of sanity checks. For example, what kind of MOIC achieves a specific IRR in 3, 5, and 10 years. Write these down or commit them to memory.
Then, look at the MOIC, look at the exit period, and see what IRR is being spit out. If it is in the ballpark of your heuristics that you have committed to memory, it is likely correct. If it is off, well, then you go cell by cell.
Just something that works for me (albeit I use this for most things, I don't do too many LBOs admittedly).
Second this. I still check valuations and the first thing I do is check the IRR and MM.
I've pretty much memorised the table by now so I can quickly see if something is fishy.
Also agree with below on checking major items and transaction assumptions first.
I would check major line items and then see if the results give you what you are looking for -> I mean the only way to truely make sure its okay is to check every everything, I think the amount of checking is also dependent on the trust you have in your analyst.
Man I have 0 trust
Biggest issues I’ve seen are debt schedule calcs and formulas. Also can’t forget about the 30% limit on interest expenses deduction for cash tax purposes.
Start by checking sources and uses (e.g., how is entry EV calculated? Is this the correct minimum cash balance? Is sponsor equity reasonable?
Once you iron out the mechanics and ensure everything is flowing correctly, do a sanity check on assumptions. What’s the spread on the TL (2%? in this market? lol).
It takes me ~20-30min to get through a relatively simple LBO (~2 tranches) and a lot longer for more complex ones. Key here is that you need to be good at the task itself before you are able to provide thoughtful comments. Assuming you know the ins and outs of an LBO, you’ll get faster at checking as your get more reps.
Rem error id eum aut. Aperiam odit aut molestias occaecati maxime explicabo voluptas. Molestiae non voluptas et.
Culpa non officia suscipit sequi. Illo sed qui ea dolores voluptatum.
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...