Are templates given for modelling on interviews?
Just wondering.
Would help if anyone can give some experience based on their past interview at a large PE shop.
Just wondering.
Would help if anyone can give some experience based on their past interview at a large PE shop.
+41 | Boomerang from PE back to IB? | 6 | 3d | |
+40 | Trading PE Secondaries? | 27 | 3d | |
+35 | Best Tech PE Deals Ever? | 29 | 1d | |
+31 | Joining an exciting new Software Rollup over PE/ Growth Equity? | 24 | 1d | |
+20 | Autism in PE | 4 | 3d | |
+20 | Advice Needed: Starting Career at Smaller PE Firm | 6 | 2d | |
+20 | F500 Corp Dev (Manager), Or PE Portco Corp Dev (Mid-Level) | 5 | 7h | |
+19 | Funds with the best culture | 20 | 7h | |
+19 | PE BD/IR | 7 | 4d | |
+18 | PE offer — Post reference check waiting too long | 6 | 1d |
Career Resources
some places do, some places don't. However most have basic starting lines laid out for you (income statement + BS line items). Most have you project future years and build out CF/debt schedule.
Totally firm-dependent. Some were blank sheets of excel but the instructions gave you all the assumptions you needed, others had a template but you had to read through some research pieces to come up with assumptions yourself, and others still were somewhere in between.
Of the megafunds, KKR has a modeling test from scratch, TPG, Warburg, and Apax use templates, Bain and Apollo don't have modeling tests, not sure about Blackstone or Carlyle
Thanks for the feedback!
As mentioned, it varies widely. I always figured most were template-based too so I had a pretty big "oh shit" moment when I got handed a redacted CIM and a blank excel sheet.
Another question:
How in depth are the case studies? I've read anywhere from simple 3 statement and LBO to beyond that with valuation, etc.
I can do the valuation portion, just curious though. I'm mainly debt oriented, so that's why I wonder.
Pull a random CIM off the drive - can you come up with a rough valuation of the company? What's the trxn structure look like and why? How do you incorporate various merits and risks? Can you present a coherent and logical case for investment (or alternatively, why you'd turn it down) in a few minutes? I think that covers the bulk of most case studies.
Carlyle is group specific. And for the templated ones named above... its a spectrum, varying from a blank excel with a couple of rows of financials pre-entered for you to basically a fully build model lacking some of the pertinent connecting aspects that would demonstrate you know how to build a model.
While it may seem less stressful to use a template, it is in fact actually more stressful IMO. First off, they give you substantially less time. And second, atleast if you practice building a model from scratch over and over you have the muscle memory and layout and mechanics drilled into your brain. When you have semi-pre-assembled model in another format, you effectively gave up your home court advantage and have to build it according to how they have it laid out and wired. Doesn't seem that significant, but when you're in the heat of the moment... it makes a huge difference when you can just drop into auto-pilot and don't have the anxiety of the unknown.
That being said... many of the templated modeling tests are floating around most of the banks.
no, i don't think so
Aspernatur aliquam et vel in. Adipisci modi eos sint at totam nesciunt nisi. Nobis animi nihil voluptas nihil error eligendi consequatur. Dolore sint consequuntur qui qui debitis quam vel.
Aut ut esse dolores sequi. Quia nulla quam adipisci eaque ipsam. Omnis iure occaecati et molestias. Dolor magnam repudiandae exercitationem dolor et cum exercitationem. Dolores alias sed neque ratione aut ullam ut.
Vero quasi in sunt nihil corporis eius distinctio. Autem alias reprehenderit aut atque suscipit laboriosam aperiam quibusdam. Cumque voluptatem pariatur ab placeat. Itaque aut aspernatur repellat dolor enim optio fugiat officia. Voluptas dolores qui et voluptas molestiae error. Iure sed blanditiis quod est libero mollitia nostrum.
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...