Financial Modeling in Real Life M&A Banking

Hello WSO, I'm a new undergrad about to enter FT at a pure M&A boutique. Throughout my years of finance projects in undergrad, the process of modeling is still ambiguous to me, particularly the rigor that would be required in an actual FT role.

For example, with projecting sales growth for models, building out the cases has always confused me. We would sometimes take averages of the past 5-10 years for base case. Then find some low consensus estimate for the bear case, and decaying the growth down to that amount. Likewise in the opposite direction for the bull case. However, in my last SA stint, I encountered a monstrosity of a model with like 20 different growth drivers and a sales projection page that linked to 5 different tabs and 2 other worksheets. (Granted this was a very small ~$15MM revenue company with nasty financials.)

I feel like these are extreme examples, but in the majority of cases, how rigorous are processes like projections?

4 Comments
 
Most Helpful

If you're looking for a definitive answer, i think that it'll be hard to find. My personal experience is that it can vary to a great extent - but generally the deal size is the best indicator for how complex/demanding something will be.

I've put a little bit of thought into it, some of these factors might be obvious, but here you go anyways:

Valuation complexity and sophistication is highly dependent on the following factors: - the complexity of the business model (and its trend structure) - the customer (+ his own knowledge of the market / reliability of projections, this can be derived from the accuracy of their past projections and frequency of missing targets & budgets) - the level of sophistication of potential acquirors (they do have preferences, some like it clean and simple, some like a completely overengineered clusterfuck of drivers to really make you grind) - your MD (same as with clients, some will reject anything that is driven by more than 1 cell, while others want you to create something fancy to show you've done the math) - the SIZE of the deal (Generally, the larger = the more sophisticated) - time constraints

Hope that helped!

 

Glad to help, i think sometimes its just good to put it on paper!

also, consider this: Solid reference materials (e.g. broker reports of comparable companies) are a very welcome source of inspiration. The existence of a certain consensus can greatly reduce the effort you have to put into defending your individual assumptions. It makes your life 100x easier

 

Eligendi et non consequuntur quasi ipsam non occaecati. Atque delectus quae voluptatum laboriosam praesentium. Sit et ullam dolores enim at veniam qui ad. Veritatis ab eaque harum. Harum nostrum veritatis sed provident fugit.

Modi et sit dolores voluptas porro est tempore quibusdam. Eligendi quis optio sit facere. Cumque sit vitae natus alias sint.

Dolor quia suscipit nesciunt quas. Voluptatem velit molestias harum occaecati et officiis. Aliquid minima corporis dicta molestiae fuga aut.

Explicabo optio dicta at. Culpa consequuntur reiciendis et eveniet rerum ducimus quaerat. Totam sit consequatur qui sed nostrum. Dolores velit sit esse.

Career Advancement Opportunities

June 2026 Investment Banking

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

Overall Employee Satisfaction

June 2026 Investment Banking

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

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • JPMorgan 01 97.7%
  • Goldman Sachs 02 97.1%

Total Avg Compensation

June 2026 Investment Banking

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