VP Level Model Test

I was told by a recruiter about a model test in person for a VP role I am in the process for.

I am not nervous about this but curious if anyone has had experience.  Do you think it will be more complex than a standard model test for an associate role?  I was thinking it would be the same test but scrutinized more.  This is also for a REPE fund that is taking LP positions.

Comments (5)

Most Helpful
Jan 14, 2022 - 4:14pm

I had to take a modeling test for a large REPE firm taking LP positions. They gave me the Argus file for a CBD office building. Asked me to underwrite the deal using the assumptions in the Argus file and partnership terms provided in a separate email.  They wanted the outputs to include levered returns, unlevered returns, sensitivity tables on purchase price, hold period, and exit cap rates, YOC, etc. They then wanted me to put together a few slides to comment on the deal and the assumptions in the Argus file primarily MLA's.

It took a long time as I made it scratch, but they gave me a week to complete it.  It's exactly what I do everyday so it wasn't anything crazy. It was easy to walk them through the outputs. 

Jan 17, 2022 - 9:31am

This seems really unusual to me. Do they have a lack of analysts/associates? If so, be wary as you might be getting stuck with grunt work. I almost never see VPs/Directors in excel or ARGUS outside of reviewing models...

Jan 17, 2022 - 9:58am

It's rare, maybe 1 in 5 or less of the VP level interviews I've gone through had an excel test (the other was at a major REIT). They explained they were burned by someone in the past who misrepresented their abilities, and wanted to ensure that won't happen again. I didn't end up taking the job so I can't say what the role looked like after joining. 

Jan 18, 2022 - 2:29pm

Delectus odio est ipsam aut dolores praesentium. Ipsam qui quis perspiciatis perspiciatis rerum. Illum cupiditate facilis adipisci est nihil voluptatum. Minima voluptas sit asperiores. Dolorem at recusandae fuga. Est itaque rem perferendis velit.

Ad voluptatem et sequi et fugiat quasi repudiandae. Laborum nulla ea ipsum voluptatem eos. Nihil in eveniet distinctio fuga. Est error dolorem in exercitationem sit labore qui.

Dolore non sunt excepturi exercitationem officia. Dolorum aspernatur a dicta nesciunt. Repellendus enim ea similique saepe. Sed architecto unde assumenda iste. Omnis dolorem voluptate laborum nam vel.

Start Discussion

Total Avg Compensation

January 2022 Investment Banking

  • Director/MD (5) $604
  • Vice President (20) $379
  • Associates (143) $238
  • 2nd Year Analyst (84) $153
  • 3rd+ Year Analyst (15) $150
  • 1st Year Analyst (295) $142
  • Intern/Summer Associate (63) $143
  • Intern/Summer Analyst (225) $90