How long should it take a good analyst to...
Develop a comp set?
Develop a model?
Generally, get "up to speed" on a company?
After reading Monkey Business, I have the feeling that I will be expected to crank out a model the same day my MD/VP asks me to develop one. That book also skewed my perception on the time it should take me to do the other tasks mentioned above.
| +3,995 | Bank of America - Juniors Strike to start Monday May 6th | 419 | 2s | |
| +849 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 79 | 1d | |
| +596 | This is a dark day for Wall Street. | 46 | 12h | |
| +445 | BofA Associate Death - WSJ, FT, CNBC, Bloomberg | 48 | 28m | |
| +191 | How to strike without being fired. | 21 | 17h | |
| +184 | Analyst at Bofa FIG-Thoughts | 28 | 1d | |
| +171 | Big Layoff at Barclays - 5/1/24 | 88 | 1d | |
| +165 | Hey WSJ, BBG, CNBC, FT, it's been more than 72 hours that this BofA IBD Associate was reported dead | 23 | 11h | |
| +150 | BofA List | 37 | 11h | |
| +138 | Reporters, please post your info in this thread for visibility so people can easily reach out. | 4 | 2h |
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.
in the early stages it will all take hours... With time, you'll be flying through it all.
it will always take many hours you will just become more efficient over time
especially after you learn the hot keys and stuff on excel. but it's also one of those things that you need to keep up with. i haven't done a model in awhile and i definitely need to brush up on my skills.
Thanks for the feedback so far. so initially, it should take
4-5 hrs for the comp set?
6-8 hrs for the full model?
3-4 hrs to get comfortable talking about a company's operations?
I know that the time to complete each of these varies based on experience, the size of the company, the availability of information, etc.
its a case by case basis you really cant set a time frame
Yes, it really is a case by case basis. A quick and dirty lbo model using blanket assumptions for simple IRR purposes can take 2-4 hours to build from scratch (the kind you build for modeling interviews). More complex models will take days, or up to a week with multiple iterations as you learn more about the company and create revenue build-ups and different scenerios.
I recently built a model that started as a quick and dirty LBO model that over the course of the week blew up into a halfway full-blown model (about 30 pages printed) with 20 scenerios (different synergy/cannibalization cases, rollover equity between another sponsor backed entity we were acquiring - e.g. multiple discounts, and store build-up). That took me about 3 or 4 days (and about 8 hours out of my vacation time).
The quickest and dirtiest of LBO template models may take no longer than an hour (this is particularly true when an hour is all the time you're given).
As Gametheory pointed out, however, more complex modeling work can take much longer. Although since gaining more work experience I've learned to push back, and would push quite hard if asked to do 20 scenarios, since this kind of work generally leads to a false sense of precision anyway.
I recall having to put together a model with a ton of sensitivities, and ended up with 144 different IRRs showing on a single returns page. It was ridiculous, nobody can make a logical investment decision based off of reviewing 144 varying outcomes.
Yes, the output was pretty ridiculous. The main problem was that when you changed the multiple discount paid vis a vis our company, it would change all the returns for each scenerio (i.e. standalone, 5mm synergies, 10mm synergies, 20mm synergies), so you had to rerun them - no way around it. I eventually just created an output with some self-referencing if's and creating a macro to run through the scenerios in the toggle.
It's the kind of "war story" I like to tell the girls at the bars.
Aliquam nobis aut quos alias. Sint consequatur odio eos quos id maxime reprehenderit ut. Accusamus earum quis aliquam consequuntur. Autem voluptatum harum explicabo adipisci aut voluptatem.
Deleniti veritatis similique et ducimus omnis est. Praesentium et nobis ea ad non. Et autem magni aspernatur quos voluptatibus perferendis. Sit dignissimos atque eum voluptatem et in doloribus. Ipsum blanditiis voluptatibus praesentium aliquam maxime nesciunt.
Qui qui et sequi omnis. Et et aut aliquid blanditiis quia et nisi. Perferendis natus nulla saepe. Reiciendis libero laudantium laborum in rem ducimus.
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...