What's in a REPE financial modelling test of ONE hour?

Hi everyone,

Next week I will have to make a financial modelling test for an analyst role at a REPE boutique, though the confirmation email says that the test will take 1 hour. It does not specify what the test will comprise off, I have not made one before (I am nervous) and apart from some discussions I read here I cannot find that much information about what could be in it.

Anyone has experience with these test for juniors / recent graduates, and what would likely be in a test only 1 hour?

Hope you can help :)

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (10)

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Most Helpful
Jan 30, 2020 - 1:24pm

Would expect to do a debt amortization table (make sure it sums to 0), a rent roll summary table (make sure you know sumifs and pmt forumlas), and a 10 year cash flow with a lease up period, I suggest using A.CRE (Adventrues in commercial real estate) development model video on Youtube for this. The video is a little more than an hour and also teaches you everything you'll need to know and more including an equity waterfall. I doubt a waterfall will be on there if the test is just and hour but if you can do everything in that video and understand why the formulas make sense you can go into that test confidently. I don't think there is anything else they could throw at you that you couldn't get. Might also want to just practice doing a basic 10 year proforma for acquiring a stabilized asset and ensure you can calculate all the return metrics (NPV, IRR, EM).

Feb 3, 2020 - 11:16am

Inventore accusamus qui quo asperiores eum. Natus inventore doloribus aperiam error eum recusandae. Eum cum nam sunt repudiandae sit aut enim. Maxime facere id beatae voluptatem ut aut odit.

Sint fugit asperiores deleniti sit deserunt reiciendis ipsam corrupti. Molestiae aperiam architecto voluptatum deleniti eligendi suscipit qui.

Start Discussion

Total Avg Compensation

October 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (39) $363
  • Associates (228) $232
  • 2nd Year Analyst (137) $154
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (103) $143
  • 1st Year Analyst (500) $135
  • Intern/Summer Analyst (386) $83