- Home
- Calculators
- Waterfall Calculator
Commercial Real Estate Waterfall Calculator
Free equity waterfall calculator for CRE deals. Build tiered promote structures and see LP and GP distributions, IRR, and year-by-year cash flow instantly.
Real Estate Waterfall Calculator
The LP/GP waterfall calculator below models how equity distributions split between a limited partner and general partner across a multi-tier promote structure.
Enter the total equity, set the GP co-investment percentage, define annual cash flows through the hold period, and build the waterfall tiers with IRR hurdles and split ratios.
The calculator returns Deal IRR, LP IRR, and GP IRR or GP Promote, alongside a full year-by-year distribution breakdown and a tier-by-tier table.
A single equity split ratio tells an incomplete story. The same 80/20 split at a 15% IRR hurdle produces fundamentally different outcomes than an 80/20 split at a 10% hurdle on the same deal. The tier structure, the hurdle sequence, and the actual deal IRR together determine how much of the total return flows to each partner. Presenting the full waterfall alongside the headline IRR is the only way to evaluate whether the promote structure is aligned with performance.
Who this is built for: family offices, investors and developers, and analysts reviewing offering memoranda, building GP/LP structures for new deals, or stress-testing promote economics before presenting to limited partners.
LP / GP Waterfall Distribution Calculator
How to Use This Calculator
The calculator runs in three input blocks and produces returns for both partners. Start with Deal Setup, enter the cash flows, then define the promote structure.
Step 1: Set up the deal
The first block defines who puts up capital and how much.
- Total Equity: total capital contribution at Year 0, in dollars.
- GP Contribution: general partner’s share of equity, from 0% to 50%. When set to 0%, the GP is promote-only and earns entirely through the waterfall splits.
- LP Contribution: computed automatically as Total Equity minus GP Contribution.
Step 2: Enter the deal cash flows
The second block captures the property’s total cash flows before any distribution.
- Y0: locked to negative Total Equity. Set automatically.
- Y1 through Y(N-1): operating cash flows each year, after debt service if the deal is levered.
- Final year (Exit): operating cash flow plus net sale proceeds. For a levered deal, subtract the outstanding loan balance from the sale price.
- Add or remove years with the buttons. Up to 15 years supported.
Step 3: Define the waterfall tiers
The third block sets the promote structure. Each tier defines an IRR ceiling and how cash inside that tier splits between LP and GP.
- Tier 1: cash goes here first, up to the specified LP IRR. Typical preferred return tier, often 8% at 100/0.
- Tier 2 through Tier N-1: intermediate promote tiers. LP IRR passes through each ceiling before moving to the next.
- Last tier: no ceiling. Catches all residual cash and splits it by the last tier’s ratio.
- Add or remove tiers with the buttons. Two to five tiers supported.
- GP Split: computed automatically as 100 minus LP Split.
The calculator updates with every input change. There is no submit button.
How to Read the Results
The three hero cards at the top of the results column report the deal from three perspectives: the property, the LP, and the GP. Everything below breaks down how the cash gets there.
Hero metrics
- Deal IRR: IRR on the total project cash flows before any promote is paid. The property’s return on total invested capital, independent of the LP/GP structure.
- LP IRR: IRR on the LP’s cash flows after the promote is paid. Sits at or below Deal IRR when a promote exists. The gap between the two is the cost of the promote to the LP.
- GP IRR or GP Promote: When the GP contributes capital, this is the GP’s IRR on their equity, typically much higher than Deal IRR because of promote leverage. When the GP contributes 0%, IRR is mathematically undefined and the card switches to a dollar amount labeled GP Promote.
Contribution and distribution totals
- LP Contribution / GP Contribution: capital invested by each partner at Year 0.
- Total to LP / Total to GP: all cash received across the life of the deal, before subtracting the initial contribution.
Distributions by tier
Shows how much cash flowed through each tier and how it split between LP and GP. Reading down the table tells the story of the deal: how much of the total distribution was pref, how much was middle-tier promote, and how much was residual.
Year-by-Year distributions
Reports actual cash movement each year.
- Cash: total project cash flow that year.
- LP and GP: distributions each partner received in that year.
- Cum. LP and Cum. GP: running totals from Year 0 onward.
- Year 0 shows contributions as negative numbers.
- The exit year is highlighted, since it typically contains both operating cash flow and net sale proceeds.
LP vs GP chart
Stacked bars by year. Blue is LP, gold is GP. Lets you see visually how each partner is paid across the hold. In most deals, early years are heavily LP as the pref accrues. The exit year shows the promote splits in full, with the GP bar growing tallest when the deal outperforms.
A healthy waterfall for the LP shows the GP earning a meaningful promote only when the deal actually outperforms the pref. A GP-friendly waterfall has aggressive splits kicking in at low hurdles. Reading the tier breakdown against the deal IRR tells you where the split actually landed and whether the promote structure was worth the discount to LP return.
Limitations of Waterfall Calculations
The waterfall model above runs on equity-level cash flows and a discrete promote structure. It does not model preferred equity or mezzanine tranches sitting between the LP and the senior loan. It assumes all capital is contributed at Year 0 and does not account for capital calls, staged equity deployment, or GP catch-up provisions.
IRR hurdles are calculated on LP cash flows using a standard XIRR-equivalent approach. The calculator does not support look-back IRR or European waterfall mechanics, where promote is calculated only at the end of the hold rather than tier by tier.
For deals with catch-up provisions, multiple close dates, or fund-level waterfall structures, a custom model is more appropriate than a single-property calculator. For a complete explanation of how waterfall mechanics work, how hurdle rates are set, and how the promote affects LP returns, see: Real Estate Waterfall Models Explained.
Frequently Asked Questions
What is the difference between Deal IRR and LP IRR in a waterfall?
Deal IRR is the return on total invested capital before any promote is paid. It reflects the property's performance independent of the LP/GP structure. LP IRR is the return on the LP's equity after the promote is distributed to the GP. When a promote exists, LP IRR will sit at or below Deal IRR. The gap between the two is the cost of the promote structure to the LP. A promote aligned with performance narrows that gap at lower deal IRRs and widens it only when the property significantly outperforms the hurdle.
What is a preferred return, and how does it appear in the waterfall?
A preferred return is a minimum IRR threshold that LP capital must clear before the GP earns any promote above its pro-rata share. In the waterfall, it appears as the first tier, where cash flows at or near 100% to LP until LP IRR reaches the hurdle, typically 6% to 9% for real estate deals. Cash in excess of that threshold flows into the next tier, where the split changes to reflect the promote. The preferred return is an IRR hurdle, not a floor on dollar distributions.
How does GP co-investment affect the promote calculation?
When a GP contributes capital alongside the LP, the GP receives distributions on its co-invested equity pro-rata through each tier, in addition to the promote share it earns above the LP split. A GP contributing 10% of equity in an 80/20 structure receives 10% of cash pro-rata plus the additional promote above the LP's 80% share. When GP contribution is set to 0%, the GP earns purely through the promote. At 0% GP contribution, the GP IRR card switches to a dollar amount labeled GP Promote, since IRR is undefined without a negative cash flow at Year 0.
What does it mean when the deal IRR is below the first-tier hurdle?
If deal IRR falls below the first tier's IRR ceiling, all cash flows through the waterfall at the first-tier split, typically 100% to the LP. The GP earns no promote above its pro-rata co-investment share, if any. This is the alignment mechanism the waterfall creates: the GP participates in upside only when the deal outperforms the preferred return threshold. A deal IRR below the pref hurdle signals that the property underperformed the return threshold the LP required at the time of investment.
Share on:
Our Services
Request a Consultation
Schedule a consultation to discuss your next development, acquisition, or market analysis needs
Recent Posts
Real Estate Waterfall Model: How LP/GP Distributions Work
Most waterfall guides assume the preferred return compounds like an IRR. Many operating agreements specify…
How to Evaluate Commercial Real Estate: 7 Key Investment Metrics
Most guides to evaluating commercial real estate stop at cap rate and cash flow. Institutional…
The Sales Comparison Approach in Commercial Real Estate: Comps, Adjustments,…
The sales comparison approach works differently in commercial real estate than most explanations suggest. Comp…