Real Estate PE/Corp Dev - case study difficulty rating
Hi all -
I'm setting a case study for a Real Estate PE / Corp Dev role (UK/Europe based) for someone with 1-4yrs experience. Candidates generally all have Real Estate IB/Investment backgrounds. Timing is 2.5 hrs to build cashflows from scratch and prepare a few slides summarising to the IC: cashflow outputs, Sources and Uses, & provide an investment recommendation.
I'm trying to get a feel for what seems reasonable as a case study within the timeframe . Am thinking the following:
- Build cashflows to acquire and develop a new build MFH portfolio
- All development costings & cashflows provided by in XLS for the candidate
- No need to work off complex rent rolls i,e candidates can basically take a starting portfolio rent at PC date, grow by X% p.a., and apply a single NOI margin across the portfolio which changes each year to get to NOI. All assumptions provided
- Financing schedule: Model an equity first development loan (with commitment fees) which flips into an investment loan after 2 yrs. Excess proceeds paid back to investor as a dividend recap. All financing assumptions provided in the briefing.
- Tax assumptions: v. simple running tax assumption provided. No exit tax.
- Exit cap rate and fees: assumptions provided.
- Fund fees/costs: assumptions provided. Candidate needs to model out recurring fees, a one-off fee upfront, and a simple 1 tier carried interest schedule
- Term: 4 yr hold
When I had a go from scratch the model took me about 1.05hrs to complete albeit I know the sector/this type of cashflow model quite well, but would be appreciated if I could get a sense check re if this all seems sensible /on-market in terms of difficulty?
Let me know if helpful to clarify any points.
Thanks!
Dolorem id porro sunt numquam quibusdam. Pariatur totam voluptas iusto illum et nostrum et asperiores. Voluptas est neque omnis sapiente magnam. Et aut ratione iste nemo est placeat.
Quia provident delectus blanditiis. Consequatur sint omnis laudantium dolor.
Commodi recusandae velit voluptatem sit omnis omnis. Autem voluptatem tempora dolores similique expedita sequi culpa tempore. Porro illo aut ea voluptatem iusto et sint autem. Est in reprehenderit quasi velit.
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...