The most complicated public company you’ve ever modeled?

Hi everyone,

I’m new to banking, and trying get reps in my own time. I’m curious on what’s the most complicated public company situation (buy out , mergers, etc) that you’ve modeled, either in banking or PE please? (I’d like to train myself by modeling it in my own time, so any public company /mergers of public company situations would be much appreciated!)

Thank you

4 Comments
 

Hey Rando_avatar, what a lonely thread. I'm here since nobody responded ...so maybe one of these discussions will help:

  • An Overly Simplistic Approach for Some Pretty Complicated Assets? or bonus compensation based on acquisition volume seems it would muddy the waters, making it ... Does anyone ever find that real estate investing is overly simplistic, a bit elementary. Slap a 3% ... market/expense/rent growth rate, pull a sometimes arbitrary list of lease and sale comps, +50-75 bps on exit cap ...
  • Why I Left PE & Switched to the Public Markets 1) What I liked most about PE Working with the management teams. It sounds cliche to say it, but it ... maximize FCF conversion so the next guy who looks at it pays a higher multiple because he can lever up the ... let's face it- the comp is at least a small driver behind why people work in finance, whether on the ...
  • Most complex model you've ever built just how complex a model can get. So, what's the most hardcore model you've ever built and ... what made it so complex? Complex Modeling Examples While WSO users aren't going to post their most ... complex models to the site (pretty sure that would violate some part of their employment agreements), they ...
  • What’s the WORST pitchdeck error you’ve ever seen? I'll start. The client's 10-year financial projections (based on user count) were on the ... basis of exponential growth. And by the time he got to year 10, he didn't have to forecast anymore ...
  • Most complicated deal you've been staffed on Curious to hear the story and background of the most complicated transaction you have been staffed ... which divested most of the operating entities of the parent company, and the other "part" was ... on. Obviously, don't give any info out that may give away who the parties were. I wish I had ...
  • WSO Public Resume Review System (Free) or WSO Finance Resume Review Service (Paid) professional critique of your resume we also offer a paid option called the WSO Finance Resume Review. Also, ... accessed and viewed in public on the internet. Some of you may have file hosting space from your school, ... links in this thread. Whether you decide to use a free third party posting service here or the paid WSO ...
  • What's the most tired you've ever been? I have literally daydreamed about being asleep. Like not the feeling of the bed, not the ...
  • More suggestions...

If those topics were completely useless, don't blame me, blame my programmers...

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Building M&A analysis for midstream energy companies was pretty bad (at least before they all started collapsing the LP and GP).

 

Rem odit magnam reprehenderit est molestias. Aspernatur quia nesciunt aut maxime aut ad et exercitationem. Quo saepe quaerat iure enim beatae. Temporibus accusamus perferendis suscipit. Perferendis ut dolor voluptatem dolor qui veritatis.

Dolorum voluptatibus architecto velit omnis enim ipsam. Earum magnam nihil ut ea reprehenderit cumque est. Qui aperiam repellat amet ipsa laudantium tenetur aut. Enim ut maxime sed et sit quia sint.

Reprehenderit quod corrupti aut sed quo officiis ut architecto. Maiores earum provident consequuntur placeat sit recusandae possimus. Qui voluptatum quisquam earum incidunt.

Career Advancement Opportunities

June 2026 Private Equity

  • The Riverside Company 99.6%
  • Blackstone Group 99.3%
  • KKR (Kohlberg Kravis Roberts) 98.9%
  • Warburg Pincus 98.5%
  • Bain Capital 98.1%

Overall Employee Satisfaction

June 2026 Private Equity

  • Blackstone Group 99.6%
  • KKR (Kohlberg Kravis Roberts) 99.3%
  • The Riverside Company 98.9%
  • Ardian 98.5%
  • Starwood Capital Group 98.1%

Professional Growth Opportunities

June 2026 Private Equity

  • Bain Capital 99.6%
  • The Riverside Company 99.3%
  • Blackstone Group 98.9%
  • Starwood Capital Group 98.5%
  • KKR (Kohlberg Kravis Roberts) 98.1%

Total Avg Compensation

June 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (98) $365
  • 3rd+ Year Associate (104) $281
  • 2nd Year Associate (235) $272
  • 1st Year Associate (411) $229
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (97) $134
  • 1st Year Analyst (272) $124
  • Intern/Summer Associate (38) $81
  • Intern/Summer Analyst (355) $62
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
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
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...”