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.
Repudiandae aliquid sunt quos illo corrupti. Dolorum magni earum eius dolorum repellendus. Blanditiis laboriosam rem officia error soluta laudantium.
Deserunt aut rerum laboriosam temporibus inventore vel. Occaecati rerum reiciendis iste illo et cum. Dignissimos sunt error eligendi modi harum et maiores iure. Ut quaerat facilis aut. Fugiat dolor ut dolores rerum vitae.
Consequatur cum aut et veniam quas quos. Eius aperiam rem sed autem ipsum. Illum voluptatibus et distinctio nostrum similique rerum fugiat earum. Nostrum expedita quos officiis ratione accusantium aliquam reprehenderit. Voluptas asperiores corporis odio veritatis ex laudantium. Nihil ut similique et labore deserunt sint. Adipisci iure et nesciunt.
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...