Brushing up on Excel + Powerpoint skills would be more helpful given that a majority of your work will be using those applications. Efficiency and minimizing mistakes are two stand-out traits for interns, and while the latter is hard to avoid during the first couple of weeks, being more efficient than your peers is something you can achieve by being more adept at Excel and Powerpoint. You'll receive a crash course on valuation anyways during your one week of training.

 

Both. However, I would suggest only rereading accounting/valuation books for concepts you do not understand. What worked best for me was performing the actual modeling; cracking open 10K's, firing up the excel and building the model.

Some grasp the concepts only from reading, but for me, working through the model reinforced the topics taught in the books.

 

When you were building your first couple models would you input the financial statements manually or pull them from Bloomberg or Eikon? A huge bottle neck for me right now is cleaning up financial statements after I pull them from Bloomberg. I feel like I understand the rest of the model relatively well but can’t get establish a good foundation in my financial statements.

How much time should I put in before my summer internship? I have 3 months.

 
Best Response

I don't have the luxury of BBG, FactSet or CapIQ right now, although that those tools would be immensely helpful. I download the excel files of the 10K's for the company I am modeling out. Usually their IS includes financials for the past 3 years and BS the last 2, however you can open the prior years 10K and fill the gap should you want consistency in having 3 historic years of IS and BS.

Spend the next 2 months diving into modeling and working through the financials. It'd be nice to have a lot of it down by the time you start, but even having half of it would still be impressive to those you will be working with (assuming you're a Jr Summer Analyst). The last month you can revisit your work, but honestly, just try to relax and have some down time for yourself so you can start your internship fresh.

Always willing to talk via PM if you need any more guidance. Godspeed.

(Whoops, forgot to reply to your comment instead of the thread.)

 

Omnis et vitae ut ipsum id dolor debitis similique. Architecto et quia assumenda sapiente sapiente voluptas minima. Quam natus laboriosam aut sit magnam animi consequatur.

Ut recusandae sint eos maxime omnis soluta est. Sit est quidem dolorem et labore. Nihil et sapiente asperiores ut. Omnis voluptatem quis at dolorum.

Architecto illum nesciunt soluta maiores iure. Perspiciatis corporis et ut quibusdam. Vero eum explicabo autem consectetur ut doloribus.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.9%
  • Harris Williams & Co. 25 98.3%
  • Goldman Sachs 17 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

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

Professional Growth Opportunities

May 2024 Investment Banking

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

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $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

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