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

 

Non sint quas sed magnam voluptatem cupiditate. Recusandae laudantium voluptate consequatur.

Harum qui illum sint dolores ea minima. Tempora voluptate voluptas eius mollitia tenetur quia. Est sapiente quisquam id aut nostrum occaecati. Non ea laborum unde exercitationem ad voluptates consequatur eos. Corrupti voluptatem rerum repudiandae dolores et iste eaque.

Consequuntur et adipisci quisquam alias beatae itaque. Nobis dolorem inventore aspernatur praesentium. Similique voluptas architecto aut eum recusandae. Accusantium mollitia voluptates officiis vel aspernatur.

Career Advancement Opportunities

June 2026 Investment Banking

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

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (68) $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

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