Skip to content

Covestly

Free calculator

Real estate waterfall calculator: split a distribution between LPs and GP

Enter the capital, the preferred return, an optional GP catch-up and up to three promote tiers. This distribution waterfall calculator shows what the limited partners and the general partner each receive, tier by tier, with the LP equity multiple and IRR and the GP's promote.

Capital

What the investors put in.

The sponsor's own capital, paid alongside the LPs'. 0 if none.

Preferred return and hold

Cumulative. 0 for none.

Whole years, 1 to 40.

Cash to distribute

Everything paid out, all at the end of the hold.

Catch-up and promote

The GP's share of each dollar after capital and pref, until it holds tier 1's share of all profit. 0 for none.

80% to capital, 20% to the GP

70% to capital, 30% to the GP

60% to capital, 40% to the GP

On everything above the last hurdle.

To the LPs

$9,297,716

To the GP

$2,702,284

LP equity multiple
2.07x
LP IRR
15.62%
GP promote, catch-up included
$1,669,204
Promote as a share of profit
23.85%
GP return on its co-invest
$1,033,080
Total profit
$7,000,000

A whole-deal waterfall in yearly periods. Its assumptions are listed under the table.

Tier by tier, in the order the cash is paid
StepTo the LPsTo the GPTotal
Preferred return (8% simple)$1,800,000$200,000$2,000,000
Return of capital$4,500,000$500,000$5,000,000
GP catch-up (100% to the GP)$0$500,000$500,000 promote$500,000
Tier 1: 80/20 until a 12% LP IRR$1,630,538$634,098$452,927 promote$2,264,636
Tier 2: 70/30 until a 15% LP IRR$1,120,569$658,112$533,604 promote$1,778,681
Tier 3: 60/40 on everything above$246,609$210,074$182,673 promote$456,683
Total$9,297,716$2,702,284$12,000,000

What this model assumes

  • A whole-deal (European-style) waterfall: the GP earns no catch-up or promote until all capital is back and the preferred return is paid to date.
  • Yearly periods. Capital goes in on day one; cash is paid at the end of a year. The pref is cumulative and accrues on capital not yet returned.
  • Each payment covers the preferred return owed first, then returns capital. With one payout at the end the other order gives the same totals.
  • GP co-invest is paid like LP capital, side by side, in every step. The GP share of a tier is promote on top; the rest of the tier follows capital.
  • Hurdles are the LPs' IRR, compounded yearly. Amounts are whole dollars. No fees, taxes, clawback or reserves.

Formula: Distribution = preferred return + return of capital + GP catch-up + promote splits, paid in that order

Runs in your browser. Nothing you type is sent or saved. Updated .

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.

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.

Common questions

What is a real estate distribution waterfall?

It is the order in which a deal's cash is paid to its partners. Investors typically receive a preferred return and their capital back first; the sponsor may then receive a catch-up, and the remaining profit is split between investors and the sponsor as the promote.

How do you calculate a waterfall distribution?

Work down the tiers in order. Pay the preferred return accrued on unreturned capital, return the capital, pay any catch-up to the sponsor, then split what is left by each tier's percentages until the investors reach that tier's IRR hurdle. This calculator does those steps and shows each one.

What is a GP catch-up?

A tier that pays the sponsor most or all of the cash after the preferred return until the sponsor holds its agreed share of all profit paid so far. With a 100% catch-up to 20%, the catch-up equals one quarter of the preferred return.

What does an 80/20 split mean in a waterfall?

Of each dollar in that tier, 20% goes to the sponsor as promote and 80% goes to the capital partners in proportion to what they invested. If the sponsor also invested capital, part of the 80% is the sponsor's too.

What is the difference between a European and an American waterfall?

A European, or whole-deal, waterfall pays the sponsor no promote until investors have all their capital and preferred return back. An American waterfall pays the promote deal by deal or as cash comes in, usually with a clawback. This calculator models the whole-deal kind.

Is the preferred return the same as an IRR hurdle?

Not necessarily. A simple preferred return accrues on unreturned capital without compounding, while an IRR hurdle compounds. A preferred return that compounds yearly and is tested on the same cash flows works like an IRR hurdle at that rate.

Do this for every deal, automatically

Covestly works out capital calls, waterfalls and investor returns from one record, and shows each investor their own numbers.

  • 14-day free trial with every add-on
  • Investors are always free
  • Unlimited staff
  • Cancel any time