PE Model Tests

For interview model tests that are supposed to start from scratch, is there any reason I shouldn't have a personal template to leverage? Not necessarily a super complex template with formulas flowing throughout, but a shell with different sections broken out (S&U, IS, BS, CFS, DS, etc.). Feels like this could save 10 - 15 minutes of formatting. Could just copy and paste the shell into a new excel file when completing a test.

11 Comments
 

I mean if you want, but that’s kind of like going to the Tour de France with a bike with training wheels. This shit is not that deep. Perfect the shell and structure enough where you can create it from scratch quickly and seamlessly.

The reality is that for any >$1B fund, the acceptance rate is sub 5% after getting interviews. Being “ok” isn’t really enough here.

 
Most Helpful

Yes, recommend doing this for at home tests. Would suggest making a template with live formulas (basic IS which includes revenue EBITDA, interest etc., basic CFS with all common items, basic debt schedule with 1-2 tranches and Returns section) and thoroughly checking it through ahead of time to make sure no linking errors and so that you’re very familiar with it and can make small adjustments to the structure as needed on the fly during the test. Make it look nice with basic formatting.

Doing this gives you a nicely formatted (basic) template that you can just plug in assumptions (pending small modifications as needed) and get returns very fast. This saves a bunch of time and if it’s a test that requires a write up, this lets you allocate more time to a thoughtful written analysis. Would caution not to make its super fancy to the point where it’s COMPLETELY obvious that you had stuff clearly prepared ahead of time (don’t include a ton of unneeded bells and whistles).

Lastly, also make sure you CAN do similar work from scratch under real time constraints. Firms aren’t stupid and sometimes will have you do a second (more complex) model test or case study in person. Good luck!

 

A delectus fugit ex quidem est. Veniam ullam pariatur et et consequatur suscipit. Natus quam et distinctio suscipit amet autem voluptatem. Corporis quaerat modi quasi praesentium. Nemo officiis pariatur suscipit maiores earum omnis dolores.

Quod ut dicta ut natus ratione quas distinctio. In rerum dolorum et sed praesentium id quis optio. Atque iure hic reprehenderit. Eum provident dolores ut.

Est mollitia tempora qui accusamus. Iure asperiores vel aut sed. Aut distinctio vel aliquid. Aspernatur ipsum libero dicta id.

Career Advancement Opportunities

November 2026 Private Equity

  • Blackstone Group 99.6%
  • The Riverside Company 99.3%
  • KKR (Kohlberg Kravis Roberts) 98.9%
  • Warburg Pincus 98.5%
  • Vista Equity Partners 98.2%

Overall Employee Satisfaction

November 2026 Private Equity

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

Professional Growth Opportunities

November 2026 Private Equity

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

Total Avg Compensation

November 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (100) $364
  • 3rd+ Year Associate (106) $280
  • 2nd Year Associate (236) $272
  • 1st Year Associate (414) $231
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (97) $134
  • 1st Year Analyst (274) $126
  • Intern/Summer Associate (40) $79
  • Intern/Summer Analyst (357) $61
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...”