4-Tier IRR Pari Passu Equity Waterfall Model with JV Split
A free Excel JV equity waterfall model for real estate deals with two partners on the GP side. It runs a four-tier IRR waterfall with a pari passu preferred return between the limited partner and the JV entity, then splits the JV entity's share between the GP and a Co-GP, so each partner sees its own capital, promote and returns.
What’s inside
Model Features
Four IRR-Based Distribution Tiers
A pari passu preferred return followed by three promote tiers, each triggered by an LP IRR hurdle.
Pari Passu Preferred Return
The LP and the JV entity receive the preferred return in proportion to the equity each contributed.
Two-Level Waterfall
Cash flow is distributed between the LP and the JV entity first, then split again inside the JV entity.
GP and Co-GP Split
Share of JV equity and share of promote are separate inputs, so capital and promote can be divided differently.
Returns for Every Partner
Profit, IRR and equity multiple for the LP, the JV entity, the GP and the Co-GP.
Promote Tracked by Tier
Shows how much of each partner's distributions comes from each promote tier, separate from its return on capital.
Editable Assumptions
Hurdle rates, preferred return, promote splits and the GP and Co-GP shares are all inputs.
Which version fits
How This Differs from the Standard Version
The JV split is the difference. The standard model treats the GP side as a single general partner. This version adds a second level for deals where two partners share the GP side, such as an operating partner and a capital partner, and splits the JV entity's cash flow between them by share of equity and share of promote.
If a single GP sits on the general partner side, use the 4-Tier IRR Pari Passu Waterfall instead.
How it works
How a JV Equity Waterfall with a GP and Co-GP Split Works
Many real estate joint ventures have more than one partner on the GP side, for example an operating partner that sources and runs the deal and a capital partner that funds most of the GP co-invest. This model handles that with two levels:
- 01
Deal-Level Waterfall
Cash flow is split between the LP and the JV entity through return of capital, a pari passu preferred return and three IRR promote tiers.
- 02
JV Entity Split
The JV entity's share is then divided between the GP and the Co-GP. Return of capital and preferred return follow each partner's share of JV equity, and promote follows its separately negotiated share of promote.
Splitting equity and promote separately lets you model a common arrangement where the capital partner contributes most of the GP co-invest but the operating partner keeps most of the promote.
Who it’s for
Who Uses This Model
Operating partners and capital partners negotiating a GP-level joint venture, CRE firms and developers bringing in a co-GP on a larger deal, and analysts who need returns for every party in a multi-partner structure.
Questions
Frequently Asked Questions
What is a JV split in a real estate equity waterfall?
A JV split divides the GP side's distributions between two or more partners, typically a GP and a Co-GP, after the deal-level waterfall has allocated cash between the LP and the JV entity.
How are capital and promote divided between the GP and Co-GP?
Separately. Each partner's share of JV equity drives its return of capital and preferred return, and a separate share of promote drives how the promote is divided. Both are inputs.
Does this model include a GP catch-up?
No. The preferred return is paid pari passu and the promote applies only to cash above each hurdle. Use the GP Catch-Up Waterfall with JV Split if your deal has a catch-up.
Is this JV waterfall model really free?
Yes. Enter your name and email and the Excel template downloads with live formulas. Nothing is locked or hardcoded.
Can Reina Property Group build a waterfall to match our JV agreement?
Yes. RPG's investment team builds custom waterfalls for multi-partner structures and can review proposed GP and LP terms before they are signed.
Custom models
Need a Waterfall Built to Your Operating Agreement?
Free templates cover standard structures. When your deal has its own hurdles, fees, clawbacks or partner splits, Reina Property Group's investment team builds the model to match the documents. See our real estate financial modeling services, or, if you are financing the deal, our capital raising advisory. More free templates are in the model library.
Free download
Download the Model
Enter your name and email below and the Excel file is yours. Live formulas, nothing locked.