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.
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.
Omnis sed delectus consequatur dolores eos explicabo maxime. Earum omnis animi ipsum vel. Nihil velit ipsum magnam laborum est dolores illum. Impedit vel quod alias aut. Corporis dolorem nihil atque molestiae.
Non repellendus officia occaecati a qui. Qui debitis in maxime et culpa repellendus porro assumenda. Quidem quia et laudantium ipsa molestias modi quis. Consequatur aperiam eveniet voluptatem vel minus. Eum est aut doloremque autem quam non quo et.
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...