Digging deeper into financial modeling

Hi guys, I have an issue regarding financial modeling. I have learned it from scratch from the everywhere-recommended Rosenbaum's book [Investment Banking], but I have a feeling that it is a really flat guide when it comes to many different nuances and real-life advanced modeling. For example there's no description of how to spread debt schedule or deprecation schedule, they base their projections for most of the items simply by taking it as a % of sales, the UFCF is simply EBIAT+D&A+CapEX-change in working cap, completely omitting the equity-based compensation (which sometimes happens to be a really significant item) etc. I am convinced that I could come up with more examples of "inaccuracies", but it is not the point. The point is that I notice those omissions simply because I have heared about certain solutions in modeling here and there, but those aren't event mentioned in the book, so probably there is even more that I am not aware of. So, back to the main issue: how shall I proceed further in order to really deeply and truly understand all of the nuances in the modeling and valuation and what possible sources like books (preferably) or online courses would do the job? The main point is that I want to feel that I have a really deep understanding of the matter and maybe in the end in the most of the cases I will be using simplified models like those in the Rosenbaum's book, but I feel really intelectually dishonest with so limited knowledge.

Also, a side question: I am convinced that such simplified models like those presented in the Rosenbaum's book wouldn't be sufficient for investment pitches prepared for a job interview (HF/AM/SS equity research), because they lack the must-have detailed knowledge and projections required in order to be grilled and not killed by the potential employer (of course it depends on the funds strategy, but you get the point).

 

You just answered your own question. Any edge you have in generating alpha comes from your ability to do fundamental research. As complicated as it seems initially, it is not rocket science to mechanically build a three-statement model and forecast items.

To generate alpha in investment pitches, you have to (a) have assumptions that differ from the street consensus (b) your assumptions turn out to be correct (effectively rendering everyone else's wrong)

 

Officiis est quia molestiae architecto assumenda voluptas ipsa voluptatem. Aut aut voluptatem excepturi qui earum.

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 (20) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
kanon's picture
kanon
98.9
9
Jamoldo's picture
Jamoldo
98.8
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...”