PE modelling tests - dumb q

So for on-cycle, we gotta do these tests. Now, in my (limited) experience, it seems like the marginal increase in accuracy of doing a full LBO as opposed to doing a simpler one (ie skip transaction BS, 3 statement, D&A schedule for financing fees) basically gets you the same IRR and MoM — especially if u just include a senstivity table. So my question is, how in dept do our models need to be? Is it common for PE firms to ask for a full blown LBO or do they just give u an hr ish and u make the basic one. Would love to get some color on this cause I’m struggling to see the point of doing a full LBO in these tests when I can reach the same conclusions without it. Thank you in advance for any help:)

 
Most Helpful

No one is asking you to build a 3-statement model, D&A schedule, etc. because they expect your MOIC/IRR calculations to be more accurate. They want to see that you are capable of doing it so that when you start the job firms don't need to spend the time training you to do it.

With that being said, most on-cycle modeling test (from what I've seen) are 1-2 hours long and generally half pre-built

 

Suprised to hear oncycle has a lot of templated out / half built models.. At the more technical MF would one expect a higher likelihood of building out from scratch?

 

Every model test I've done (about 4-5 of them, Infra PE), basically consisted of them sending you a prompt or occasionally a mostly blank template spreadsheet via email and telling you to send back what you have at the end of the 1h/1.5h period scheduled for it. So either is fine, depending on what you have on hand - I've done one on only the laptop at a coffeeshop before due to a packed schedule.

 

I am assuming in oncycle you do it on their laptop in office, meaning no pre-set shortcuts / optimized task bar. That is how I am practicing

 

Voluptatem omnis similique porro ullam maxime sunt labore. Nemo impedit nemo et adipisci nostrum qui alias tenetur. Officia consequatur fugit explicabo aperiam perferendis. Non nemo odit voluptas voluptatum accusantium sunt. Et asperiores ut nisi non quia et.

Dolorem minima consequatur voluptate dicta placeat. Praesentium laboriosam aut distinctio sapiente. Iste fuga expedita iure dolor eveniet. Cum quia fugit impedit veritatis explicabo ullam rerum dolorum. Tenetur ullam ut nemo omnis et deleniti.

Atque iste asperiores quidem porro. Quia repudiandae consequatur at excepturi. Qui consequuntur nisi et officiis est quaerat et. Sequi qui qui explicabo est dignissimos. Accusamus atque minus quia impedit et.

Career Advancement Opportunities

June 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

June 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

June 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

June 2024 Private Equity

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