What level of modeling expected for interns?

Coming from a nontarget and frankly don't know much other than basic excel skills and the M&I 400. Some of the discourse seems like your expected to know 3-statement and DCF by the time you walk in the door, but I find that hard to believe.

What are you really expected to know and what would you focus on if you had 2 weeks before the start of the internship?

3 Comments
 
Most Helpful

I would practice PowerPoint, especially how to align stuff. Maybe just 2 hours total ahead of your internship. Most interns are pretty useless and you’ll probably spend more time on team pages and logos than anything else at the start.

- Quick access Toolbar for aligning things left, right, center and top, middle, and bottom

- moving things to front and back

- Removing backgrounds of logos (alt J + P + I + S)

- crop pictures to shapes

- The little insert icons to find things like the clipboard, handshake, and chart

- how to make your bullets check marks and little Xs and change the colors

- how to add a shadow

 

Consequatur quod quasi voluptatibus dolorem. Facilis et ut quam numquam quo sit. Ad sequi velit omnis et ipsa ratione deleniti.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (50) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (75) $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...”