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.
| +74 | Ex Apollo Associate Q&A (But I Actually Answer) | 114 | 19m | |
| +56 | Q&A - Anything about PE / MBA / Life | 63 | 3s | |
| +45 | How to Model SaaS Projections for Interviews | 49 | 1d | |
| +37 | [Technical doubt]: Cash sweep and mandatory amortization | 10 | 7s | |
| +23 | European Megafunds (based on PEI 2023) | 17 | 2d | |
| +22 | Partners Group Long Term | 8 | 1d | |
| +22 | Is internal reporting at most funds really so Excel & PPT heavy still? | 8 | 10h | |
| +18 | How much thematic work / industry research do you guys do? | 0 | 2h | |
| +18 | How is your life in PE? | 12 | 2h | |
| +18 | Advent NYC Culture/WLB - 2024 update | 9 | 2h |
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.
Officiis corporis tempore qui consequatur excepturi unde voluptatem. Fugit ullam ab odio. Inventore dolor fugiat reprehenderit doloremque cumque pariatur.
Non ea optio error. Quasi velit reprehenderit rerum non et et neque.
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...