How Do You Train PE Juniors When Banks Do All the Modelling?
I work at a mid-market PE fund where, a couple of years ago, we made the decision to only hire graduates or Analysts from our internship programme, rather than hiring Associates externally.
As we now typically have a financial adviser on each deal, I feel that our juniors are not developing enough modelling and analytical skills, as a lot of this work gets delegated to the banks. At the same time, they don't yet have enough experience to properly review or take full ownership of this work, as they have never really got their hands dirty doing it themselves.
How do you make sure this doesn't happen? Not having an FA involved would be inefficient, so that doesn't feel like the right solution. I also don't think hiring only very junior Analysts is the most effective setup for us, but there is not much we can do about that, as hiring Associates from banks is simply too expensive.
Boss, there is no substitute for actually doing the work. I think you delegating the modelling is a mistake both in terms of training your juniors on how to think / what levers drive returns, but also for yourself as the person who is overseeing the case building and understands these at a deeper level.
In the end, the model is a simplified version of the world where you bring together the key assumptions that drive your investment. Those are the key assumptions you test when you do diligence.
And I'll share a little secret: I was on the LP side for a few years before I eventually transitioned into direct PE (more specifically, a very large sector specialist UMM). I've seen models from a few MFs and I've obv worked with the models at my UMM. Advent sent us a model for a distributor that was 10 Mb in size, 30 tabs, they'd modelled out working capital on specific sets of SKUs. I just could not work with that model, it was so detailed and falsely precise that it told me nothing about what mattered. I much prefer the simpler versions in our UMM, where we emphasized getting the key commercial drivers / assumptions right vs. a huge, unwieldy model.
So my advice is: create a template you're happy with, ignore e.g. monthly or quarterly forecasts, but have a simple model that's yearly, has a solid price x volume build for revenues, a few lines for major expenses (we tended to use functional). That should be enough. The only flourishes we allowed ourselves were the option for M&A and refis. Then get your analysts to drive this simpler model.
If you use the template, they'll learn faster + it'll be easier for you to review as you're already familiar with it.
Your point about a model's detail such an important one and often goes underappreciated.
Just because your model is more specific (ie - has 30 tabs, captures every sku separately, etc) doesn't mean it is better. There are often only 2-3 things that actually matter. Go into detail on those and let that drive the model. A more detailed answer doesn't mean it is a better answer.
Writing 100 pages on why the earth is flat doesn't make for a better work product than 1 sentence saying "We know the Earth isn’t flat because multiple independent scientific observations — such as ships disappearing hull‑first over the horizon, the Earth’s always‑round shadow during lunar eclipses, and the changing constellations visible from different latitudes — all match the predictions of a spherical (oblate spheroid) model confirmed by modern satellite imaging."
Thank you! Can you make some concrete examples? i.e. you ask your Analyst to be the one holding the pen on the model, with juniors at IB only doing process management? At the MF / UMM funds, was the junior at the fund preparing the model and then handing it over to the IB?
We used juniors in IB mostly for comps research. If you really don't have enough resources in house, it is also worth asking them to look at the customer database and creating customer cuts, but usually we did this in-house or I've sometimes seen it done by FDD providers.
No point in having junior IB people prepare models. Again, the model itself should be simple: if it takes your analyst more than a day to pull together, it's way too complicated. One sheet for the LBO, one sheet for the operating model, done.
cheap labor?
Can't confirm nor deny
I've attempted this by taking a modular approach. Caveat that my experience is wholly in Infrastructure Equity, so it might not be an exact comparison. In training non-bank grands, laterals from other spaces, I've found that asking the new person to build out one section at a time to be most helpful - i.e. as what other commenters have said, build out revenue section, build out debt section etc. You can always use dummy numbers and in any case, it's more important to get mechanics right and keep an eye on detail as how assumptions + formulas create the outputs, then with more repetitions see where the mistakes / surprising results are coming from.
Once you've got the modular bits down, next exercise would be to build the whole model by themselves.
At my fund, analysts own the model and constantly have to update the economics to show the deal team different structures, sensitivities, and downside scenarios. I didn't realize other sponsors outsourced this—how does that dynamic with the bank running the model actually work in practice?
How did you switch from lp to gp?
Not easy: MBA then to MBB then to PE. It's doable in Europe, I suspect not so much in the US.
bump
bump
This is a classic mid-market PE problem. One solution we've used: insist on a 'shadow modelling' process. Even if the bank builds the model, your juniors must independently rebuild it from the CIM and management accounts, then compare variance. It slows things down initially but forces them to actually think. Another approach is to rotate juniors onto portfolio company work (add-ons, refinancing) where there's no FA involved—that's where they get their hands dirty. Also, don't underestimate the value of teaching them to 'audit' the bank's model critically; that's a skill in itself and often more valuable than building from scratch.
In sit possimus dolore sapiente ad quidem. Qui sapiente sapiente hic suscipit qui. Blanditiis sint praesentium odio officia sit.
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...