For interview model tests that are supposed to start from scratch, is there any reason I shouldn't have a personal template to leverage? Not necessarily a super complex template with formulas flowing throughout, but a shell with different sections broken out (S&U, IS, BS, CFS, DS, etc.). Feels like this could save 10 - 15 minutes of formatting. Could just copy and paste the shell into a new excel file when completing a test.
| +43 | Lateraling at senior associate / VP level | 15 | 11h |
| +27 | Imposter Syndrome: PE to Publics | 4 | 3d |
| +26 | Ares buying LGP...now what? | 8 | 2d |
| +19 | Do PE VPs Always Have An Associate Under Them? | 12 | 2d |
| +17 | GTCR vs BDT MSD vs MDP | 16 | 1d |
| +16 | Hours at MF Infra Funds in London | 2 | 19h |
| +14 | Setting the right LBO entry multiple without information | 3 | 6d |
| MBA to EM Infra Investing? | 3 | 3d | |
| +11 | Committing to CD&R? | 6 | 8h |
| +11 | London Version: PE Check-in on Attrition, Promotions and State of Play | 6 | 1d |
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.
bump
I have some solid resources that could be helpful, if interested feel free to D.M.
Interested, could you please share
Same here - could you please share
PM Sent
interested, would be grateful if you could share!
Yeah everyone does this
Are most of these not typically done in house? I’d always assumed modelling tests were done at the firm?
Please correct if I’m misunderstood
I mean if you want, but that’s kind of like going to the Tour de France with a bike with training wheels. This shit is not that deep. Perfect the shell and structure enough where you can create it from scratch quickly and seamlessly.
The reality is that for any >$1B fund, the acceptance rate is sub 5% after getting interviews. Being “ok” isn’t really enough here.
Yes, recommend doing this for at home tests. Would suggest making a template with live formulas (basic IS which includes revenue EBITDA, interest etc., basic CFS with all common items, basic debt schedule with 1-2 tranches and Returns section) and thoroughly checking it through ahead of time to make sure no linking errors and so that you’re very familiar with it and can make small adjustments to the structure as needed on the fly during the test. Make it look nice with basic formatting.
Doing this gives you a nicely formatted (basic) template that you can just plug in assumptions (pending small modifications as needed) and get returns very fast. This saves a bunch of time and if it’s a test that requires a write up, this lets you allocate more time to a thoughtful written analysis. Would caution not to make its super fancy to the point where it’s COMPLETELY obvious that you had stuff clearly prepared ahead of time (don’t include a ton of unneeded bells and whistles).
Lastly, also make sure you CAN do similar work from scratch under real time constraints. Firms aren’t stupid and sometimes will have you do a second (more complex) model test or case study in person. Good luck!
Dolores excepturi ducimus aut est voluptate. Expedita accusamus et sed iusto labore. Ut qui aliquid eius nihil voluptas. Aut ea non nemo quam et tempore odio.
Recusandae harum quis eos illum. Aut hic consequatur fuga eos aut modi est. Aut mollitia dolores recusandae dicta.
Consequatur suscipit nihil suscipit suscipit doloremque sint aut. Laudantium error minus culpa debitis modi. In est aperiam dolore asperiores itaque eum. Et aut exercitationem molestiae earum quaerat voluptas. Architecto voluptatem non in ut.
Repellendus et nam iusto ut ea. Illo temporibus et quod omnis quod. Qui enim veritatis voluptatum aliquam fugit earum ut.
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...