Earnings Model?

What exactly is an earnings model, specifically in reference to IM? I spoke to a PM yesterday and he recommended that I research some stocks I like and then build out an earnings model for each one. Is this just a discounted cash flow (DCF)? Is it basically just a pro forma income statement, where I predict future revenues, cash flows, and earnings? If it is the latter, would I need to build a pro forma balance sheet  and SFC as well, or is the income statement enough?

Does anyone have an example of what an IM earnings model would look like? It seems like it would be easy if all I'm doing is making future growth assumptions, but I assume there's more to it than that.

Understanding Earnings Models

Modeling is an essential skill for any investment banker hopeful. Understanding how they work and being efficient at them is an absolute must.

User @Cornelius - Asset Manager - Executive Director

It’s usually a three statement DCF model. Depending on how in depth you want to get into it, you can bust out analyses related to the business. For example, Telco companies are valued on a subscriber basis. So in research reports/models, they build out valuations based on EV/subscriber which are built on projected subscriber growth which gets multiplied by some revenue per subscriber number and leads to total revenues.
I would suggest, building a 3-statement DCF model, breaking out segmented revenues/cogs/etc.

Also calculate ratios for the companies - total debt/ebitda, acid test, etc.
You might also want to write something up on the company as well - not just about the business but what the numbers mean.

Wall Street Oasis offers a variety of templates to assist you with your models, including one specifically for DCF models.

User @bearing - Equity Research - Vice President

I also learned from my senior that when you model it is always good to build into checks to make sure your model is accurate. Some examples are to create some conditional probabilities to see if your A=L+E, Your NI = your dividends + RE, etc. Looking at some of our company models over the summer we had like 80+ accuracy checks built in.

Read More About Financial Modeling On WSO

Want to improve your financial modeling skills?

Check out WSO’s side-by-side comparison of financial modeling courses and get a WSO discount.

Financial Modeling Course

 
Best Response

You're on the right track.

Its usually a three statement dcf model. Depending on how in depth u want to get into it, you can bust out analyses related to the business. For example, Telco companies are valued on a subscriber basis. So in research reports/models, they build out valuations based on EV/subscriber which are built on projected subscriber growth which gets multiplied by some revenue per subscriber number and leads to total revenues.

I would suggest, building a 3-statement dcf model, breaking out segmented revenues/cogs/etc.

Also calculate ratios for the companies - total debt/ebitda, acid test, etc.

you might also want to write something up on the company as well - not just about the business but what the numbers mean.

------------ I'm making it up as I go along.
 

Bowser, you are def on the right track, 3 statement 5-year projected earnings model, with ratios and sensitized variables along with public comps. You should also come up with a 30 second investment thesis for each

PS My earnings models always include a base, downside and upside case but you should probably just run 1 conservative case if you dont feel like building in toggles and/or choose if functions

Good luck

 

Expedita qui voluptas culpa quo maiores nisi. Tempore qui ut distinctio aspernatur tempora et. In iure repudiandae inventore dicta. Est praesentium molestiae saepe laboriosam dolores ratione. Est libero autem sed totam a.

Labore soluta ex alias facere blanditiis dolorem vel qui. Velit ipsum voluptas cum. Voluptatem ut sint exercitationem inventore quaerat. Non omnis voluptates ex dolores voluptatem iure saepe. Porro consequatur id quis neque.

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