What is the appropriate level of DCF knowledge for an IB summer internship?

Hi there,

I'm a rising junior at a target school with a good GPA. I'll be applying to internships for the summer of 2019 this summer and although I have my heart set of asset management and investing, I'll be applying for IB spots if asset management isn't an option. I have a bunch of investing-related activities on my resume, but under the technical skills section that most people include, I didn't have any noteworthy abilities outside of typical Microsoft Office stuff. I know modeling is a large part of IB, and I wanted to learn about DCF's so over the past week, I've reviewed the DCF sections of both the Vault guide and the more recent Rosenbaum and Pearl guide.

Although I understand all the formulas involved, all the logic, and the basic fundamentals behind DCF analysis, I'm having a hard time figuring out how to decipher the Excel sheet that comes with the Rosenbaum and Pearl book. I have to return to school in a few days, and it seems exceedingly difficult to figure out what the Excel sheet is talking about. I was wondering if it's totally necessary to understand how to build a DCF model from scratch in Excel in order to get one of these internships or if my level of knowledge right now is enough. Furthermore, I was wondering if this kind of more detailed modeling knowledge is necessary for an internship in asset management.Thanks a lot and sorry for the long question!

2 Comments
 
Most Helpful

IMO you should be able to

  • 1) Understand the logic of a DCF and which steps you would need to take in order to create one from scratch (this is something that is frequently asked in interviews). This includes the drivers of a DCF model and common pitfalls

  • 2) Execute on this manual in a simplified manner. I don't think anyone expects you to be an excel god by the time you start your internship. However, you should have created at least 1-2 simple models in excel. By that i mean dont get worked up too much about which formula to use for convenience enhancing things, but rather focus on an intelligent layout that enables swift readability. Grab yourself any listed company and get stuck in. You will quickly gain pace and learn from your own mistakes.

  • 3) Quickly analyze the DCF template that is usually given to you. You can practice by downloading Internet DCF templates from reputable sources and fill them out.

Hope that helps.

 

Aut nihil sunt ab molestias. Quo et ut aut eum temporibus ut. Rerum ullam omnis et quo quidem voluptate. Quos sunt ut eveniet molestias placeat id. Mollitia quae et velit enim distinctio commodi dolores dolor. Et rerum ratione autem consequuntur debitis accusamus aut ut.

Saepe minima veritatis corporis itaque mollitia. Voluptatem dolore culpa provident et est tempore. Accusantium et quidem voluptatem. Quis iste unde consequatur perferendis. Blanditiis minus accusamus earum dolores molestiae vel architecto. Qui est autem et. Ullam aspernatur et quasi rerum ut aut adipisci.

Et blanditiis tempore ut cum eum rerum. Optio veniam omnis ipsa qui voluptatem quasi. Sunt rerum dolor distinctio qui et est aspernatur. Corporis numquam dolores et rerum. Aut et fuga et consequatur molestiae. Dolorum earum atque cupiditate nemo aspernatur ut.

Array

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