Modeling resources

Hi all, wondering if anyone has any recommendations about a free modeling course/videos/content that anyone has used and found helpful in the past. Starting an internship in a few weeks and want to brush up. Thanks!

 
Most Helpful

If you made it through the interviews, you should be fine.

What's most important IMO is understanding the underlying accounting and finance concepts. A financial model really just reflects these basic mechanisms in a structured way; that's all. If you don't understand what happens in the three financial statements if an asset depreciates or you buy assets using debt, then how on earth do you want to model it? You can't, no matter how many fancy Excel tricks you know. It still amazes me how many applicants fail here.

Anyway, the standard resource for M&A that is Rosenbaum/Pearl; if you intern in a different field (say ECM/DCM/S&T), you might want to brush up on some more specific capital market skills too, but you get the point.

For the actual modeling, I personally think that F1F9's free email course is a nice intro. They teach you how to set up a model using the FAST standard. The FAST standard is really just a set of rules that you can also download and read through (which I recommend after getting used to it).

As I said, I work in project finance. We usually build our models like that. For M&A, I have seen equivalently beautifully structured models, but also some nasty models. Maybe someone else can chime in on how you M&A guys do it.

 

Thanks, really appreciate it. I have good understanding that helped through the interviews but want to be able to set myself apart before getting there. Will definitely look into your recommendations!

 

I used ME to prep for some of my banking associate interviews and it's been invaluable to me on the job. We haven't had any sort of formal discussion internally, but I'm going to suggest this to a few peers as part of summer training

 

Quaerat minima magnam aut dolorem. Rerum sit quia sint qui. Ad ad non mollitia eaque. Ea possimus voluptatem praesentium facilis quisquam. Magni sunt quasi nihil sint placeat exercitationem.

Blanditiis libero minus consequatur et officiis quas quas. Molestiae ex non dicta nemo libero repudiandae. Ratione voluptatibus dolorem quis cum. Sit et et distinctio et amet. Id qui velit vel sed. Aut dolor officia soluta aspernatur voluptas.

Career Advancement Opportunities

May 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 04 97.1%

Overall Employee Satisfaction

May 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

May 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

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
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...”