To All Freshman and Sophomores

So I have been asked twice in the past week by ambitious young monkeys "What are the best sources to learn to build a financial model". The problem is these guys are only freshman and sophomores in college. A FINANCIAL MODEL IS USELESS UNLESS YOU HAVE A STRONG UNDERSTANDING OF ACCOUNTING, and corporate finance. Until you have been at least through intermediate accounting and taken at least corporate finance, I highly suggest you spend your time on other things that are better value added to your development.

You young guys think a financial model is this magical thing and knowing how to do it will all of a sudden make you a great investor/financier. What you don't know is that a financial model is simply a tool for us to use to back up our qualitative assumptions of the company. A model is only as good as the assumptions that are made, and these assumptions are developed by knowledge of the business, how it generates revenue, and how market and economic factors will impact the business.

What should you do instead?

READ!! READ!!! READ!!!

1. Before you learn the technical skills of finance, you should develop your qualitative finance skills.

Every freshman and sophomore on this board that wants to go into investments should get a subscription to the Wall Street Journal. Read it for 20 minutes a day so you can learn how the markets work, what drives the market, how do different businesses operate, what drives the economy. Building a knowledge background about the markets and how it operates will make you twenty times more qualified to a potential employer because you actually sound smart. Read articles on other sources like Seeking Alpha, this forum, Fortune, Forbes etc...

2. Read books about the industry you want to go into.

If you want to go into Investment Banking, I highly suggest you read books about the industry so you know what you are getting yourself into. You can start with Monkey Business and Liar's Poker are a good start.

What if I don't like to read?

Well what you don't know is that reading is crucial to this industry. Constantly everyday a real investment professional is constantly reading about the markets, the companies they are following, and the industry they are doing work on. If you don't have a natural curiosity then it will be tough for you. However, you can develop that curiosity by reading.

So when do I start to learn modeling?

You can begin to learn modeling after you have completed at least three accounting classes and taken at least two finance classes. For most people this is sometime in Junior year. Then you will have the basic background to build and understand a financial model. The knowledge base you will have built from reading will supplement this greatly and you will be a rock-star candidate for IB/ER internships Junior Year. Good luck monkeys.

 
Best Response

In addition to reading, this is roughly the trajectory of learning how to model:

  1. Learn the 3 statements and their intricacies
  2. Read up on time value of money and net present value, CAPM, capital structures, WACC, and FCFF vs. FCFE
  3. Important: learn Excel functions and shortcuts
  4. Read up on DCF and Comps analysis. Practice building out historicals and simple projections. And eventually scale up to a full model.

The basic tools of finance is pretty straightforward. You need to make sure you understand valuation theory cold

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.8%
  • Goldman Sachs 18 98.3%
  • Harris Williams & Co. New 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 (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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
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
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...”