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?
| +137 | UBS Catastrophic Q1-Q3 26, M&A -17%, Outside Top 10 in Americas, EMEA & APAC | 37 | 1d |
| +59 | PWP acquisition by Piper cancelled | 22 | 1h |
| +29 | Evercore poaches Baird DC Defense Team | 18 | 6h |
| +28 | Houston banking Gods ? | 16 | 2d |
| +21 | Best Houston Banks for Culture in 2026 | 14 | 3h |
| +18 | Normal for lateral process to go +2 months? | 4 | 1d |
| +17 | Lack of talent in IB! | 19 | 1h |
| +17 | Internal lateral from coverage to M&A (focused on coverage) | 4 | 15h |
| +15 | How standard is weekend work in IBD? | 6 | 2d |
| +15 | Discussion Transaction Experience in Lateral Interviews | 3 | 3d |
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.
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
Itaque aut qui explicabo. Reprehenderit laudantium et libero enim ut. Labore beatae asperiores nesciunt molestias. Animi velit est ad et consequatur molestias. Sapiente omnis nobis est id molestiae inventore dicta. Soluta quae unde et ex et.
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...