Most Helpful

The revenue model is the one tab in my models that has 0 template. I build every revenue model from scratch. How to do it will depend on the company, so it is tough to have anything pre-built. A couple different ways I tend to do it:

Top Down You want to start by sizing the market. Start with a broad concept of the market, then forecast the share of the broader market of the specific industry your company is in. Then forecast the individual company shares within that industry. I generally tend to prefer this top down method, but because I look at a lot of diversified large caps it doesn't always make sense to do it this way.

Investment-Based Once you've entered in all of your historicals and figured out ROIC, you can forecast growth based on what you expect as far as investment. Your first item to figure out here is IC turnover, which is just sales divided by IC. You can either forecast IC turnover to change going forward or hold it constant (much harder for a company to change its turnover vs change its NOPAT margin). From there you would forecast how much you expect the various levels of investment to grow (Capex, R&D, Net Working Capital) which will then drive your top line forecast. This isn't always the most intuitive way to do it, especially since most are used to forecasting the IC investment lines as a % of sales, but it makes the most economic sense.

Volume + Price IMH this is usually a tougher way to do it because my companies rarely break out growth this way, but this is probably more common for modeling consumer companies.

How you decide to model revenue is the most important piece of the model, given that it drives so much of the rest of the model, so it is worth taking the time to do it right and thoughtfully. How you decide to do it will depend on the company, the industry, the level of disclosures you are given, and what management gives guidance on. When in doubt, just model something around GDP.

 

Cumque nam a sunt. Minima expedita sunt dolores reprehenderit tempora.

Nihil provident qui eius in. Quisquam possimus deleniti culpa necessitatibus optio dolore vel. Distinctio ut aspernatur at laboriosam error dolor voluptas. Aut quo nam quibusdam sequi dicta possimus et.

Voluptatibus et voluptas ipsam. Sit dolor fugiat exercitationem illum. Quisquam dolore sed dolorem ea autem omnis sint. Fugiat dicta eligendi ut similique dolores rerum.

Career Advancement Opportunities

April 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 03 97.1%

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

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