Each company and each analysis is different, however, the "bare-bones" fundamentals are the same for DCF, Comps, precedent transactions, etc.
So with that, do you guys build models and valuations from scratch (as in format, labels, sheets, cells, everything) or do you use a generic bare-bones template then modify accordingly?
Cheers!
| +150 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 22 | 4h |
| +140 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 21 | 4h |
| +123 | Is pay at BofA really that bad? | 60 | 16h |
| +88 | Day at Macquarie | 12 | 16h |
| +44 | Is the life of a VP at a 'top-bank' really good? | 15 | 3d |
| +44 | How bad did I mess up | 10 | 22h |
| +31 | Misrepresented Houston IB | 14 | 1d |
| +29 | Law school instead of MBA for RX Banking | 6 | 20h |
| +29 | No BB RO 2026 | 10 | 2d |
| +28 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 12h |
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.
Hi Marcus Nietzsche, check out these threads:
More suggestions...
I hope those threads give you a bit more insight.
Models - From Scratch, Template, or Somewhere In-Between? (Originally Posted: 05/31/2016)
Hello pitch-singers and shit-flingers,
I know that there have been similar topics in the past, but the newest I could find was almost 3 years old, and I know new resources have become available during that time period. Here's the question:
When building a full 3-statement model (for IBD or PE (or anything similar, really)), do you prefer to start from scratch for each company, use a template (such as a proprietary one, one from a Book's website, WSP, etc.), or something in-between (e.g., take the last similar model you did and just tweak)?
I'd like to hear some varying perspectives on this. Also if you use a template and have tried multiple ones, have you found one that you consider the best?
I always start from template. no reason to spend all that time and effort on first pass at the CIM.
Model Templates (Originally Posted: 10/25/2010)
In terms of MM banks, how many of you build your own models from scratch and how many use templates supplied by your bank?
NoT banking but MM PE. We have a pretty robust LBO model we use. But no model is perfect and there is always a pretty decent amount of customization that goes into each transaction.
Most MM's have templates for comps, DCF, LBO, etc. And as ^ noted, you will often have to tweak and customize for specific cases.
We use templates for most and tweak scenarios. But for some special projects depending on the deal we will build more sophisticated models from ground up.
Modeling and Templates (Originally Posted: 11/01/2010)
So as we all know, one of the most important things an analyst leaves an IB program with after two years is his or her modeling abilities. My question is how is one supposed to develop these skills when the majority (I'd probably say all but feel free to correct me if I'm wrong) of banks use a lot of templates for analyses?
Whether it's a simple DCF, merger model or a full-blown LBO, it seems there are templates for everything. While there is usually some customization for every pitch / deal, my experience has been those are generally fairly minor (throwing in additional scenarios etc) and the bulk of the heavy lifting has already been done. Any thoughts on this?
Ab rerum temporibus illo temporibus nulla repellendus. Voluptates qui enim nam qui iste eligendi sit vel. Amet architecto perspiciatis quis velit repudiandae iste aperiam.
Sed sit nemo quaerat eaque. Rerum unde quas sint nam nam officiis. Repellendus et ullam qui eum odit. Est tempora et sed earum. Facilis temporibus saepe autem ut. Et provident et dolorum cum rerum.
Deserunt architecto optio eius. Mollitia officia in et labore. Harum ut voluptatem ea et consectetur rem officiis iusto. Eos officia deserunt quod aperiam aut alias. Voluptatem ea illo voluptatem minima hic tempora. Aperiam quae deserunt consequuntur.
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...