RE Private Equity Excel Test

I have been interviewing with a REPE firm and they have asked me back for a final round excel test. Was just wondering if anyone had any idea what I should expect? How I should prepare? Maybe a practice modeling test?

The position is for a lightly experienced professional and its on a firms acquisitions team. Would really appreciate any and all help you maybe able to offer.

Private Equity Interview Course

  • 2,447 questions - 203 PE funds. Crowdsourced from 750k+ members
  • 9 Detailed LBO Modeling Tests and 15+ hours of video solutions.
  • Trusted by over 1,000 aspiring private equity professionals just like you.

Comments (9)

Aug 18, 2016 - 9:00am

I joined a REPE firm last year and was asked do something similar. Effectively I was required to build an underwriting model from scratch based on a few assumptions and provide an analysis. It was pretty straight forward but I would be prepared to need to know the basic fundamentals of what goes into an underwriting model. Mine was specific to a multifamily asset, so understanding of NOI, cap rates, levered and unlevered cash flows, IRRs, etc. was required

Aug 18, 2016 - 9:01am

REPE Excel Test Help (Originally Posted: 02/15/2017)

Hi all,

I have an excel test this Friday for a small NYC based RE investment shop. They said I would have 2 hours to complete a basic cash flow and waterfall model. For studying measures, I am trying to teach myself how to model the waterfall but am struggling. Can please anyone provide (PM) a basic template for a waterfall? Anything is helpful!

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
Aug 18, 2016 - 9:07am

Does anyone have a basic waterfall model that could be completed in sub-15 minutes? I'm really looking for an effective yet simplified model.

Robert Clayton Dean: What is happening?
Brill: I blew up the building.
Robert Clayton Dean: Why?
Brill: Because you made a phone call.

Start Discussion

Total Avg Compensation

April 2021 Private Equity

  • Principal (7) $694
  • Director/MD (15) $627
  • Vice President (63) $371
  • 3rd+ Year Associate (66) $267
  • 2nd Year Associate (127) $250
  • 1st Year Associate (266) $224
  • 3rd+ Year Analyst (24) $164
  • 2nd Year Analyst (60) $136
  • 1st Year Analyst (171) $117
  • Intern/Summer Associate (18) $71
  • Intern/Summer Analyst (191) $60