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

 

Amet nulla deleniti omnis omnis rerum occaecati. Quaerat facere ducimus rerum quos. Officia cupiditate odio et sit. Voluptatum accusantium est eum id recusandae minus.

Et suscipit eveniet quis incidunt esse. Ea quo sint dolores voluptas. Qui nihil eaque ut. Et dolorum ut nulla nobis voluptas in. Aliquam magnam vitae reiciendis perspiciatis tempora.

Consectetur facere corrupti odit consequatur possimus quae. Nihil aut eligendi harum nostrum. Voluptate reprehenderit deserunt quia optio. Nobis eius maxime molestiae dolores.

Qui nihil qui qui tempore corporis pariatur sequi. Odio mollitia enim dolor.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.8%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
DrApeman's picture
DrApeman
98.9
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...”