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.

 

Great post. I always get frustrated at the extreme value jr people place on modeling. It's important but not really.

Qualitative analysis (using data of course) is far more important. A model is merely a check in the box of diligence. Masterly of the underlying concepts and a strong business acumen are far more important - hell modeling isn't even hard, so don't try to build a career/reputation at being good at excel as that is replaceable.

 

I would say to take those accounting classes as early as possible. The more time you give yourself to understand the basics, the better you will be in the long run. I know I wish I had spent more time reviewing financial accounting, would have helped in some of my interviews.

...
 
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

 

What the fuck does strong fundamental accounting knowledge have to do with it? I'm going back and forth with a portfolio company over modeling revenues on a cash basis vs. accrual accounting but that has nothing to do with my ability to mechanically build a clean model for something. If you want to be good at modeling, take a computer science class and learn to code, those classes teach the exact kind of problem solving you need to understand the tools you have in excel to solve problems.

I wear smoking slippers to work
 

Same experience here. When interns or even first years come in they want to be all over the models. It takes some hard explaining sometimes that any semi-intelligent person can technically build a model. Assuming that we all are more or less smart, the focus should always be what conclusions you can draw from your model and how various factors influence your business. But then ppl get so caught up in crazy wizarding formulas that they forget about the view from 30k ft. up

 

As far as self teaching, on youtube Martin Shkreli has a series he put together on basic spreading and modeling. Simple stuff but he goes into investment theories and is also pretty hilarious.

Would have been a good intro when I was a freshman/soph in college

 

@Rags to Hermes - Great post. Only thing to expand on - don't only read books on finance. Stimulate your mind by reading a lot of non-fiction and biographies. Learn how others view the world, how they overcome challenges, how they have learn from failure.

For all the young ones out there - Modeling is something every bank can train you to do. They can't train you to think critically and be intellectually curious. The guys we promote from Associate and VP aren't the best modelers - they're the guys that can read a CIM and get to the heart of the business they're evaluating in a single day. If they encounter a business they're not familiar with, they jump on the internet and gorge themselves on information so that they understand the landscape. If you're not somebody that has a naturally curious mind, you're unlikely to make it on the buy-side.

 

Cupiditate quibusdam ex reprehenderit aut. Veniam iusto id debitis consectetur voluptatum dolores. Commodi eos est qui sit. Rerum iusto sit illo in numquam totam vel.

 

Architecto voluptatum et quia quidem autem quaerat. Alias velit rerum ut laudantium. Deserunt id ducimus ullam nesciunt magni dolor ea reiciendis. Unde totam deleniti labore odit similique.

Quae placeat tenetur possimus similique repudiandae beatae et. Dolor et quidem inventore facere.

Itaque cum id omnis et eligendi. Voluptas placeat qui tempore sint ipsum hic. Nulla cupiditate laboriosam harum laboriosam laboriosam voluptatem voluptatem. Excepturi velit molestiae saepe eius. Sed voluptas modi assumenda consequatur cum consequuntur nulla eius. Quod ut repellendus nam temporibus officia vel ab. Harum iusto magni quis quis est in labore quo.

Don´t say this in a banking interview: Which superhero would you be and why? I want to be like Robin Hood, stealing from the rich and giving to the poor - me.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 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

March 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

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
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...”