Investment banking modeling
In IB is there like a prebuilt set up when building dcf,comparable, or precedent transaction models? Like is it mostly entering in number to a format that is already constructed by your firm?Or does a analyst build it from absolute scratch like a blank excel sheet?
Should never make the models from scratch. Use models from past deals by updating the historicals, assumptions, etc.
Besides not being time efficient, why not? Wouldn't the model be more accurate if it was done from scratch? Or do things move too fast for a junior banker to make one from scratch?
By building from template, you can choose to build from scratch while having it generally pre-formatted.
Not being time efficient is the big one but there’s also sufficient room for error when building a model from scratch (formulas, references, etc.). Would take a long time to build and a long time to “proofread”. When using an existing model you can rest assured that the model will be correct as long as you don’t mess with the formulas
Once you work in banking you’ll understand why building a new model/template every time is a very silly idea
Ut nobis similique et sit. Ut necessitatibus ut rerum explicabo ab. Harum veritatis commodi odit et voluptatibus velit.
At quas earum voluptatem perferendis. Non eveniet ipsum aut tempora. Enim quis optio repellendus fuga. Suscipit voluptate minus quia consequatur facilis rerum sunt.
Laborum magnam in voluptas officia et. Vel ex provident accusantium eum mollitia est. Architecto culpa dicta voluptatibus accusantium in labore. Ipsum sit et facere quos aut dolore.
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...