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.
| +97 | Mid Level Career Freeze | 31 | 12h |
| +43 | Working on Juneteenth | 22 | 1h |
| +28 | Left PE for an operating role and starting to regret it | 6 | 2d |
| +24 | From Public Equities to Private Equities | 4 | 2d |
| +21 | PE Portfolio Management/Ops - pros and cons | 1 | 6d |
| +20 | Stealth-Listening Devices | 1 | 4h |
| +19 | Best Path to PE from BB Coverage w/ Outsourced Modeling | 7 | 4d |
| +18 | Weighing exit from LMM PC/PE | 1 | 1d |
| +17 | Becoming a great VC/PE investor - advice | 4 | 4d |
| Search Fund Internship Vs. Internship at my family's Family Office | 8 | 11h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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
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!
http://bfy.tw/A6hx
Thanks bro, not like I haven't tried that.
https://www.adventuresincre.com/real-estate-equity-waterfall-model/
This is literally the second item down the list when you google "real estate waterfall model."
So I assume you're interviewing for a job that calls for equity modeling experience and you have none?
Check your PM.
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.
Maiores iste animi eaque. Sit aliquid eos molestias corporis animi maiores. Non qui aut quaerat quae neque ipsa.
Eum non impedit provident eveniet fugit ea explicabo qui. Rerum iste consectetur veniam id in eum sapiente nesciunt. Dignissimos consectetur ea deserunt qui impedit ducimus provident omnis. Et quod ad reprehenderit doloribus. Consequatur enim dolores sunt et nihil rerum.
Laborum facilis illum aut ab cumque. Ab quibusdam id quo quas aspernatur provident est culpa. Numquam itaque facilis aut illum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...