REPE | Return Attribution
Hi guys! I'm trying to be creative with an analysis for a real estate development project. Is there a way to calculate a return attribution analysis similar to traditional LBOs? You know that for this type of project, EBITDA (NOI) is 0 at the beginning, so there's no Entry Cap / Multiple to compute EBITDA Growth and Multiple Expansion. Additionally, Purchase Price is not paid upfront, instead is expensed as needed by CapEx. Any idea is appreciated. Happy New Year!
Happy New Year! Based on the most helpful WSO content, here's how you can approach return attribution for a real estate development project, even without traditional LBO metrics like EBITDA growth or multiple expansion:
NOI Growth Attribution: Since NOI (Net Operating Income) starts at zero, focus on the growth in stabilized NOI over the project timeline. Break down the drivers of NOI growth:
Cap Rate Compression/Expansion: Analyze the impact of changes in cap rates between the time of development and exit. For example:
CapEx Attribution: Since the purchase price is expensed as CapEx over time, you can attribute returns to:
Leverage Impact: If debt financing is used, calculate the contribution of leverage to the overall return. This includes:
Timing of Cash Flows: Since real estate development projects often have uneven cash flows, consider the timing of CapEx, NOI stabilization, and sale proceeds. Use IRR to measure the time-weighted return and attribute it to:
Sensitivity Analysis: To further refine your attribution, run sensitivity analyses on key variables like exit cap rate, NOI growth, and CapEx. This will help you understand which factors have the most significant impact on returns.
By breaking down the return drivers into these components, you can create a detailed return attribution analysis tailored to real estate development projects. Good luck with your analysis!
Sources: Real Estate Private Equity Technical Qs, Thinking like an Investor: The key financial metrics, REPE Interview Question: Evaluating whether to carry out CapEx?, Real Estate Development Modeling, Real Estate PE Technical Interview Question - Case Study
In development models, there is no initial cap rate. You analyse the opportunity with its yield on cost -potential rent/(CapEx+land acquisition+costs associated with the acquisition)-.
Just google examples of similar pro forma models and you will have a better idea.
I appreciate it, thanks.
Assuming it's a merchant built deal with no hold period, I'd probably focus in on the operational value creation from project completion to sale as you get it leased and sold - here you could do your traditional return decomposition with the original value set to total cost, entry cap set to Y1 YOC, etc. If it's a weirder deal that's sold empty/spec, you could probably do the same but substitute Y1 YOC to expected yield and run the same attribution from there.
Sed sint culpa eum est modi debitis. Reprehenderit necessitatibus iusto quo corrupti sit recusandae. Voluptate ipsum impedit eos maxime quod totam.
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...