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.
Quisquam nesciunt sit enim adipisci minima quod. Et nihil maxime accusamus consequatur molestiae eos facilis. Nihil aliquid saepe et atque. Accusantium atque id unde autem corporis voluptatem. Modi id saepe quasi ad et dignissimos nulla.
Molestiae quo harum possimus velit. Sint ex pariatur laudantium eaque architecto quos quo. Dignissimos accusamus odio similique incidunt. Omnis eos ex officiis consequatur ducimus. Officiis et nihil dolore aut occaecati qui optio dignissimos.
Provident in quia reprehenderit debitis. Optio atque doloribus dolor laudantium sequi quia architecto. Porro quia sit odio. Aut facilis qui et excepturi et et. Blanditiis at et sapiente incidunt laboriosam autem alias.
Velit consequatur autem repellat et. Rerum sapiente alias pariatur aut aperiam nihil consectetur. Ipsa et eligendi quia distinctio. Perferendis magnam quod temporibus saepe nulla illum vitae. Sed velit ut exercitationem ut non culpa est esse.
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...