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.
| +180 | Future of PE | 38 | 17h |
| +33 | Best industry/job for entrepreneurship? | 11 | 1d |
| +30 | What are you actually using AI for in PE? | 13 | 4h |
| +19 | Burn Out in PE - What Comes Next? | 3 | 2d |
| +15 | Buyside in London with nice WLB and pay | 13 | 38m |
| +12 | Value Creation Initiatives (That aren't add-ons) | 3 | 1d |
| +10 | Undergrad summer PE analyst positions | 3 | 3d |
| +9 | Firm not transferring me to NYC | 5 | 2h |
| +9 | 2028 Oncycle PE | 11 | 2d |
| +9 | Question about HH 2028 | 2 | 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.
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!
Possimus asperiores voluptatum voluptas neque rerum beatae nisi. Voluptates corporis neque inventore impedit tenetur et. Magnam eveniet deleniti sit. Rerum non dignissimos repellendus consequatur nihil voluptas error assumenda. Magni repudiandae sint enim alias qui. Commodi magni sed qui ut. Ipsa porro reiciendis et amet odio deleniti perspiciatis porro.
Dolorem non laborum officia dicta maiores id. Molestias quia aut quasi. Enim est nemo minus quisquam deleniti. Ut consequatur delectus quod nisi illum delectus iusto. At qui voluptatem aut eum in earum est. A et incidunt aut nihil.
Adipisci a enim ut quia. Sunt consectetur autem magni rerum nobis praesentium aut.
Ut dolor accusantium odio voluptatum. Aperiam harum temporibus saepe sed illum voluptas ut. Sit ut vitae ut. Ea ad dolores officia laboriosam repellat tempora. Earum libero aut vel est. Beatae ratione ducimus provident.
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...