How many models did you build in your 1st year as an analyst?
How many? What types of models?
Would be helpful if you include what group and what size bank you are at
Trending Content - Investment Banking Forum
Career Resources
Only one model (LBO) I was in charge of projecting interest expenses, which I hard coded as a percentage of sales Leveraged finance group, top european bank
LBO, DCF, MM, and of course company forecasts. Usually, in your the first year you'll copy other peoples' models or use a friend's template. 2nd year I built my own from scratch so that I could drop in a forecast and a couple of assumptions to have a working model in 15 mins.
My experience reflects M&A group at an EB.
Our first year analysts typically build over ~30 full LBO models from scratch in their first year. At least 10+ practice models starting out, then a new model/LBO situation every two weeks on average throughout the year.
Financial Sponsors, BB.
EDIT: LOL, >dozen SB for the above commenter "one model," MS for me truthfully explaining that our analysts do a lot of models. Guys, don't be triggered. This should inform your view while recruiting that different banks (and David could even be at the same bank as I am since our LevFin team doesn't model) approach deals differently.
Can I ask why? Like you are literally having the analysts building out the sources/uses, cash sweeps, PF balance sheets, etc. from a blank excel every time?
I understand why it is helpful to have them build the practice models from scratch, but a good LBO model template should have enough functionality to be modified to fit a new deal scenario, no?
Have found templates to be more trouble than they're worth. At least at our bank, the template is so complicated to be able to fit "any scenario" that in a simple scenario, there are tons of unused lines and checking the model becomes tedious. Our team prefers to create a new model that only has what's necessary, and build out complexity as it comes. It has the added benefit of making our first year analysts pretty fluent at modelling at the cost of only a few hours per new model.
Change "build" to "bang" and we could get a much more interesting thread goin here
and the number is still the same for 99% of people on here
"Models" can be extremely vague.. As a first year, I probably created 5-10 models but at various ranges of difficulty. The 1 full sell-side operating and valuation model with 40 tabs (financial statements, depreciation/capex schedules, debt financing scenarios, etc.) would not compare to the quick and dirty LBOs I'd create to run transaction scenarios. That being said, your first year experience should incorporate a variety of modeling to help you get familiar and prepare you to be able to add functionality in any scenario.
Top bucket analyst, EB. Transitioned to MM PE after first year.
Any model with less than 65 tabs is bullshit. If an analyst ever shows me a model with less than 65 tabs I make them go add more before I review.