I've done about a dozen joint venture waterfall frameworks and this most recent one is different enough from the rest that it deserves its own version. The way capital is repaid and the pref. works is unique to any other template I've done.
$45.00 USD
(both versions included)
Both templates will be immediately available to download after purchase. They are also included in the joint venture templates bundle and the Super Smart Bundle.
Overview of the Second Version
Version 2 is Included Above (separate distributions for income vs exit/accrued pref. payment)
Waterfall Structure version 1:
- 100% of LP capital repaid first.
- An accrued (non-compounding) preferred return is paid to LP investors who invested above a defined threshold. This is paid at a selected year (usually a REFI or Exit event).
- Any remaining cash is distributed to LP (both investor types) and GP pools according to a defined percentage split.
Waterfall Structure version 2:
- Separate distribution row for annual profit share and exit liquidity.
- Exit liquidity distributions go to repay all LP capital first, then accrued pref. and then any remaining from that goes to the carry split.
- This gives a way for the GP to earn a portion of the annual profits during the hold period.
Template Features:
- Model up to 10 years.
- Dynamic inputs for investor contributions (up to 35 individual investor slots)
- Adjustable preferred return rate.
- Adjustable carry percentages.
- automatically buckets investors into pref. and non-pref. earning buckets.
- Shows IRR and Equity Multiple for each individual LP investor.
- All formulas and cells are unlocked and editable.
- Color formatting makes it easy to know what cells are supposed to be adjusted (light yellow).
- The main waterfall distribution logic is on a single tab, a second tab holds individual investor inputs.
The model is a great tool for explaining a deal to investors. You can plug in different cash flow levels, different exit timelines / liquidity events, preferred return rates, and different investment amounts to show an investor how they may fair given those assumptions and the deal terms therein.
Similar Templates:
- Preferred Return with Hybrid IRR / MOIC Hurdle in Tier 3
- Preferred Return - Basic
- Preferred Return with Multiple GP Catch-up Options
- Preferred Equity with a Subordinate IRR Hurdle Waterfall
- Preferred Equity (equity multiple hurdle)
- General Cash Flow Waterfall: 3 IRR Hurdles
- IRR Hurdles with GP Catch-up
- Preferred Return - Simple Interest / Multiple Hurdles / Non-Compounding
- Preferred Return Fund Tracker (IRR Hurdles)
- Cumulative Distributions
- Mixed-Use Real Estate
- Multi-family Real Estate Acquisition
- Joint Venture Model - IRR Hurdles / Waterfall
- Hedge Fund Fee Model with a Soft Hurdle
- Self Storage: Multi-Fund
