Analyst's model building
How do analysts build models? By that I mean, are they pretty much built already and your just plugging numbers? And if that is the case, why does it take so long?
How do analysts build models? By that I mean, are they pretty much built already and your just plugging numbers? And if that is the case, why does it take so long?
Career Resources
I am also interested in this
To your first point, how to build a model is not something can be answered via a forum post. I recommend Dealmaven or another IBanking prep program to learn this skill.
Every BB bank and I assume most boutiques have model templates that analysts will often use when they begin a model. Of course, a model can't be built to accommodate every company that one wishes to analyze. So, even with a template, expect to be making additions and changes.
Finally, I guess it depends on what you deem 'long', but experienced bankers can build entire models in about 1/2 day. Like anything, it just takes practice.
there are model templates, but when there's time you learn the most and have the most grasp over the model built from scratch.
For a quick merger model, acc/dil, LBO, or whatever there are standard templates that can be used in a few hours. For more customized items, a skilled analyst can build a fairly impressive model in under a day.
Personally, I built myself a few easy to use base models, that I then build off of. Rebuilding a complex depreciation/tax/debt model each time is silly when if you build it properly it'll work in every situation. For anything thats not ordinary, like a strange JV, reverse Morris Trust, or whatever else, you just start from scratch. Remember, most models don't need to have a lot of functionality. A DCF can be done quite accurately in about 5 lines. A simple LBO, if you have a cash flow model already, can be done in under 10 minutes.
On the other hand, for a transaction modeling takes weeks, if not months. These models have detailed operations methodologies, every possible sensitivity you can imagine, numerous outputs, and change constantly. The model will also have to be vetted by accountants if it is for certain types of transactions or if it has to go into a dataroom.
The most complex modeling I've had to do was for a profits interest waterfall on a ridiculously complicated deal that included LLCs, C-corps, S-corps and multiple merger-sub holding companies, all of which had to be 'made whole' for a variety of tax liabilities.
The proceeds waterfall included 6 classes of management options (time vesting and tiered performance vesting), 4 classes of profit sharing options (some of which diluted specific classes of management options but were pari passu with others) and 4 tranches of senior units that were comprised of varied allocations of preferred / common membership interests.
By far, the most complicated part was dealing with the massive circular logic required to build in appropriate proceeds distributions that included pro-rata, catch-up, tag-a-long and drag-a-long provisions, among others.
I spent a good 2 days building the waterfall and the following week or so just explaining it to lawyers and bankers on both sides of the deal to ensure the structure was properly captured in the definitive purchase agreement. Needless to say, it was a fucking nightmare.
That sounds fucking miserable. Holy fucking shit.
They can give you a quick view that is close to what you need, but a model built from scratch using the theories correctly will always be better. You can use a template as a guide but you will need to make adjustments for it to be good.
If I have a good finance backgroun in terms of undergrad coursework and fairly good excel skills, how hard will this be for me to pick up? I understand the components that go into a dcf, and have done one by hand given assumptions, but never looked at a company, and built one from scratch. Is that something I should look into doing prior to my SA start date?
Remember, there are different complexities of models for each different situation. If you're working on a pitch, you're model will be more simple. Once you're mandated, the little details matter, and you may need to create a model from scratch.
KMM - Having a good understanding of finance and excel is a great start. They'll teach you how to build basic models, and with practice, you'll start working on the more complex models. Most likely, you won't be staffed on a live deal from day 1, usually the analysts that pitch the deal are on the deal team. What they're looking for in analysts is someone that is smart. For your model to balance (i.e. future projected income statements, balance sheets and cash flows all match) you need to be able to understand how each item affects the other. This is easy for a basic model, but you gotta be really smart for a complex model.
The tricky part is building a very flexible model. You've plugged the numbers in, but there is always an assoc or vp that would ask, what about this? What is we adjust the debt stucture like so? I don't think your valuation is right, it should be X, make it X.
first year analyst: modeling (Originally Posted: 10/22/2011)
do first year analysts typically get to run the model or model at all? or is it something the second year/associate does? would good first years get to touch analysis after awhile?
so what do u think first analysts do then? or why do you think they are called analysts then?
some groups have 1st years do all the bitch work (comps, pitch books, pibs, research, etc) while 2nd years do all the "interesting work". It depends on your group
depends on company to. a place like wells fargo is like 10:1 pitch/working on actual deal ratio a place like harris williams is like 1:1
in short, yes. 4 months in. i'm on track to close 3 deals by end of next month.
Im in the same boat as guts. But some places wont let you do that shit til youre and associate
Depends on the company and structure. If it is a bigger company you will prob be doing mostly pitches whereas if you're at an MM with lower headcount you will prob be doing a little bit of everything including modeling.
Financing Modelling as a First-Year Analyst (Originally Posted: 08/23/2014)
How much financial modelling does one get to do as a first- or second-year at an MBB firm or other top-ranked strategy consulting group? I'm not looking to get the financial modelling work so I can leverage the experience for a PE exit opp or what have you. I'm definitely interested in strategy work for my career, but still find some aspects of financial modelling interesting--curious to know how much exposure there is to this type of work. Thanks in advance.
bump
Illum modi esse optio. Molestiae laborum mollitia ad ipsum. Consectetur illo consectetur est quidem repudiandae beatae repellendus.
Aut corrupti incidunt animi ducimus. Id ut et numquam repudiandae. In dolorum repellat praesentium.
Eveniet similique culpa nobis odit rerum. Ea cupiditate temporibus et suscipit minus et repellat. Hic aut id ea quisquam provident ut.
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...