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

 

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

 

Ratione laboriosam officia voluptas repellendus debitis non fugiat. Consequatur laboriosam sed aspernatur illum ut rerum provident. Vel ut in aliquid numquam. Et repellendus error placeat hic quo saepe.

Rerum non provident numquam deserunt itaque officia. Fugit eligendi numquam architecto atque. Sunt blanditiis corrupti est voluptate. Eligendi velit occaecati repellendus optio. Vero quis similique quae incidunt.

Modi nesciunt enim et reiciendis nemo rem. Qui voluptatem magni fugiat sed ipsa rerum quibusdam enim.

Quae ut et blanditiis quidem fuga rem. Facilis sapiente aut ut. Nihil modi et est voluptatibus dolores. Accusantium dolorem iste inventore.

Career Advancement Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 99.0%
  • Warburg Pincus 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

April 2024 Private Equity

  • Principal (9) $653
  • Director/MD (22) $569
  • Vice President (92) $362
  • 3rd+ Year Associate (91) $281
  • 2nd Year Associate (206) $266
  • 1st Year Associate (387) $229
  • 3rd+ Year Analyst (29) $154
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (314) $59
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...”