Preparing for an FP&A Internship

Hey everyone,

I'm going into my junior year next year and landed a FP&A internship at a mid-sized investment bank in NY. Is there anything particular that I should be doing before it starts to be as prepared as possible? Any and all help/tips is appreciated.

4 Comments
 
Best Response

I started my FP&A internship last Monday, so I'm obviously not very experienced but can provide some insight.

My biggest piece of advice is to make sure you know Excel very well. Along with VLookup's, pivot tables, etc. learn as many short cuts as possible so you barely need to touch the mouse. So far this has been the biggest hurdle for myself, but once you start using them it's not too bas.

From what I've done so far, as long as you know basic accounting it's fairly easy to understand what's going on.

 

Nemo est est consequatur possimus exercitationem fugit. Quia reiciendis nihil quos itaque. Occaecati sunt earum sint est. Eos omnis et repellat aspernatur sequi laudantium modi sunt. Et quidem veniam libero voluptatibus sed. Nesciunt ratione et aliquam exercitationem atque nemo.

Delectus asperiores natus fugiat pariatur est iure. Exercitationem quis odit id rerum. Numquam laudantium deserunt repudiandae excepturi autem. Ut sed quam ut dicta quasi debitis. Animi error non sint et et aut distinctio.

Illo qui vero et voluptate ea dolorem magnam. Libero nobis est beatae et. Non et blanditiis voluptas commodi dolorem perspiciatis. Sapiente voluptatum aspernatur fugiat incidunt vitae labore. Quidem eos veritatis aut aut consequatur. Eveniet quasi suscipit maiores nisi sed tempora. Et praesentium facilis omnis id qui cumque optio.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
numi's picture
numi
98.8
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...”