How to use the waterfall calculator
Start with the capital: what the limited partners (LPs) put in and what the general partner (GP, the sponsor) invested alongside them. Then set the preferred return, the hold period in whole years, and the cash to run through the waterfall. You can enter one payout at the end, which suits a sale or a quick check of a term sheet, or a yearly cash flow plus sale proceeds in the final year.
Next come the sponsor's terms. The catch-up is the share of each dollar the GP takes after capital and the preferred return are paid, until it holds the tier 1 share of all profit; enter 0 if the deal has none. Then choose one, two or three promote tiers. Each tier has a GP share, and every tier except the last ends when the LPs have earned a set IRR.
The result updates as you type: a table with one row per tier showing what goes to the LPs and to the GP, the LP equity multiple and IRR, and the GP's promote in dollars and as a share of the deal's profit. The page opens on a worked example, explained below, so you can change one number at a time and watch what moves.
How the waterfall is calculated
A distribution waterfall pays cash in a fixed order. Each step must be full before a dollar reaches the next one.
- Preferred return: the capital partners receive the preferred return accrued on the capital they still have in the deal. It is cumulative, so anything unpaid in one year is owed in the next. Simple accrual is rate times capital times years; compounding adds unpaid preferred return to the base once a year.
- Return of capital: the partners get back what they contributed, LP and GP capital side by side in proportion to what each put in.
- GP catch-up: the GP takes its catch-up share of each dollar until its promote equals the tier 1 share of all profit paid so far. With a 100% catch-up to 20%, the catch-up comes to a quarter of the preferred return.
- Promote tiers: in each tier the GP share is paid to the GP as promote and the rest follows capital. A tier with a hurdle lasts until the LPs' IRR reaches it; the last tier takes whatever is left.
Formula
Catch-up at 100% to a share s = preferred return paid × s ÷ (1 − s). With one payout at the end, the dollars the LPs need to reach an IRR hurdle h after n years = LP capital × (1 + h) to the power of n.
Worked example: a $12,000,000 payout on $5,000,000 of equity
The calculator opens on this deal. The LPs invest $4,500,000 and the GP co-invests $500,000, so the LPs hold 90% of the capital. Five years later a sale leaves $12,000,000 to distribute in a single payout. The terms are an 8% simple preferred return, a 100% catch-up, then 80/20 until the LPs reach a 12% IRR, 70/30 until 15%, and 60/40 above that.
The preferred return is 8% × 5 years × $5,000,000 = $2,000,000, shared 90/10 by capital. Capital comes back next. The catch-up is a quarter of the preferred return, $500,000, all to the GP. For a 12% IRR over five years the LPs need $4,500,000 × 1.12 to the power of 5, which is $7,930,538. They have $6,300,000 so far, so tier 1 must pay them another $1,630,538. The LPs receive 72 cents of each tier 1 dollar (80% goes to capital, and they hold 90% of it), so the tier is $2,264,636. Tier 2 works the same way toward 15%, and the last $456,683 is split 60/40.
Distributing $12,000,000 through the waterfall
Preferred return (8% simple)
- To the LPs
- $1,800,000
- To the GP
- $200,000
- Total
- $2,000,000
Return of capital
- To the LPs
- $4,500,000
- To the GP
- $500,000
- Total
- $5,000,000
GP catch-up (100% to the GP)
- To the LPs
- $0
- To the GP
- $500,000
- Total
- $500,000
Tier 1: 80/20 until a 12% LP IRR
- To the LPs
- $1,630,538
- To the GP
- $634,098
- Total
- $2,264,636
Tier 2: 70/30 until a 15% LP IRR
- To the LPs
- $1,120,569
- To the GP
- $658,112
- Total
- $1,778,681
Tier 3: 60/40 on everything above
- To the LPs
- $246,609
- To the GP
- $210,074
- Total
- $456,683
Total
- To the LPs
- $9,297,716
- To the GP
- $2,702,284
- Total
- $12,000,000
Check the numbers
The LPs turn $4,500,000 into $9,297,716, a 2.07x equity multiple and a 15.62% IRR. The GP's $2,702,284 is $1,033,080 earned on its own $500,000 and $1,669,204 of promote, which is 23.85% of the deal's $7,000,000 profit.
What typical waterfall terms look like
There is no standard waterfall, only common patterns. Preferred returns of 6% to 8% a year are typical in real estate syndications. Many deals then use a single split, often 70/30 or 80/20 in the investors' favor. Larger or institutional deals more often step the GP share up across IRR hurdles, for example 80/20 to a low-teens IRR and 70/30 or 60/40 beyond it.
A catch-up is more common in funds than in single-property syndications, and it matters more than it looks. In the worked example, setting the catch-up to 0 lifts the LPs' total from $9,297,716 to $9,567,716. These are typical ranges, not rules: the operating agreement of each deal is what counts.
What this model assumes
A waterfall can be written many ways, so it helps to know exactly which one this is. It is a whole-deal waterfall, often called European style: the GP receives no catch-up or promote until the capital partners have all their capital back and the preferred return paid to date. Time runs in whole years. Capital goes in on day one and cash is paid at the end of a year.
- Each payment covers the preferred return owed first, then returns capital. With one payout at the end, paying capital first gives the same totals; with yearly cash flow the order changes how early distributions are labeled.
- With yearly cash flow, anything paid above the preferred return due returns capital, which lowers the preferred return that accrues afterwards.
- The GP's co-invest is treated exactly like LP capital. An 80/20 tier therefore pays 20% to the GP as promote and 80% to all capital, of which the GP's own capital takes its share.
- Hurdles are measured on the LPs' cash flows as an IRR compounded yearly. A simple preferred return is not the same thing: 8% simple for five years with nothing paid along the way is an IRR of about 7%.
- Fees, taxes, reserves, clawbacks and deal-by-deal (American) promotes are left out, and amounts are rounded to whole dollars.
Common mistakes when modeling a waterfall
Most disagreements about a waterfall come down to a handful of details that are easy to get wrong in a spreadsheet.
- Mixing up simple and compounding preferred returns, or treating a preferred return rate as an IRR hurdle.
- Reading 80/20 as the LPs' share when the sponsor also holds capital. The 80% belongs to all capital, including the GP's co-invest.
- Computing the catch-up on total distributions instead of on profit.
- Forgetting that timing moves IRR hurdles. The same total paid a year earlier reaches a hurdle with fewer dollars, so more cash lands in the higher tiers.
- Applying a whole-deal waterfall to an agreement that pays the promote deal by deal, or the reverse.
How the waterfall relates to IRR, equity multiple and preferred return
The waterfall decides who is paid; the return measures describe the result. The LP equity multiple is what the LPs received divided by what they invested, and the LP IRR is the yearly rate those cash flows earned. Because hurdles are IRR tests, the waterfall and the IRR are tied together: a tier ends at the exact dollar where the LPs' IRR equals its hurdle.
The promote as a share of profit is a useful single number for comparing structures. A plain 80/20 split with a full catch-up gives the GP 20% of profit; tiers push it higher as the deal does better, which is the point of them. To see the preferred return on its own, year by year, use the preferred return calculator.