Preferred Equity Waterfall Model - Private Equity & Real Estate - IRR & Equity Multiples - Annual & Monthly Basis

Description
Highly flexible ready-to-use template used by private equity and real estate professionals, modeling the waterfall distribution of preferred equity.

This Excel model provides a 3-hurdle waterfall profit sharing scheme allowing the user to define the allocation of capital gains between the General Partner and the Limited Partner(s).

Multiple options are available, allowing for dozens of different scenarios:
- Annual and monthly bases
- Forecast period: up to 20 years
- Up to 3 hurdle rates
- Hurdles defined by IRR or Equity Multiple (or the most beneficial between IRR and Equity Multiple)
- Priority distribution to the LPs possible, otherwise Pari passu between stakeholders
- GP catch-up option available
- Outputs automatically generated

A spreadsheet "Outputs" highlights the most relevant information, allowing for a quick and easy understanding of the deal between GP and LPs. It shows :
- The deal risk / reward profile
- The expected returns per stakeholder (project, GP and LPs), both for IRR and Equity Multiple methods
- The cash-flow profile per stakeholder (GP and LPs)


The model is dynamic, you just need to fill out inputs cells (which mostly consists in filling out the project cash-flows), and the rest will calculate automatically! You can then play around with variables and main assumptions to evaluate different scenarios.

Feel free to share thoughts, ideas, recommendations... this is warmly welcomed!