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?

 

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?

 

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

 
Most Helpful

Dolore debitis perferendis odit aut iusto. Ipsa veniam labore est nemo tempore. Commodi rerum iste qui voluptas. Recusandae id quae et exercitationem exercitationem. Nostrum dolorem ratione quis architecto maxime et. Magni temporibus delectus assumenda quidem et similique.

Quae ullam cum omnis in ex voluptatum. Aspernatur placeat sint repudiandae sed beatae. Ut sed est a sunt eos ipsam omnis voluptate. Sit dicta ut ipsam voluptatem nam deleniti. Rem expedita commodi ullam nesciunt natus.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”