How Waterfall Distributions Work in Real Estate Funds

The short version:

• A waterfall distribution flows cash through four tiers in strict order: return of capital → preferred return → GP catch-up → profit split. Every tier must be fully satisfied before a single dollar moves to the next.
• Preferred return must be time-weighted by each investor's actual funding date. A flat-rate calculation overpays investors who funded late and underpays investors who funded early — by tens of thousands on a typical fund.
• The GP catch-up tier exists to bring the GP's share of cumulative profits in line with their promote percentage. Skip it and the GP's effective promote drops dramatically.
• Day count convention (Actual/365 vs. Actual/360 vs. 30/360) changes the pref accrual math. Your operating agreement should specify which one applies.
• The math is precise but not complex. The hard part is tracking funding dates across multiple tranches and rounding pennies consistently across many investors.

---

You have $1.2M to distribute across five investors. They committed different amounts. Two of them funded on different dates. One is an LLC with three members. Your operating agreement says 8% pref, 20/80 split, catch-up enabled.

Where does the money go?

If you're reaching for a spreadsheet right now, you're not alone. Most GPs running $5M–$100M funds manage their waterfall in Excel. And most of those spreadsheets have at least one error that would change an investor's statement — sometimes by tens of thousands of dollars.

This article walks through exactly how waterfall distributions work, tier by tier, with real dollar amounts. No rounding. No hand-waving. By the end, you'll know how to verify every line on every investor's distribution notice — or know exactly what to configure if you're automating it.

The Four Tiers

A waterfall distribution is a sequential priority system. Cash flows through four tiers in order, and each tier must be fully satisfied before a single dollar moves to the next. Skip a tier or process them out of order, and you've got an LP with a legitimate complaint.

Here's the fund we'll use throughout this article:

The fund made $180,000 in profit ($1,200,000 minus $1,020,000 in contributed capital). Now let's distribute it.

Tier 1: Return of Capital

Every investor gets their money back before anyone sees a dime of profit. This is the foundational promise of the waterfall — capital preservation comes first.

The $1,020,000 in total funded capital gets returned pro-rata based on each investor's contribution:

After Tier 1: $180,000.00 remaining to distribute.

Two things to note. First, only funded capital counts. If you issued a $100,000 capital call to LP A and they haven't paid it yet, that $100,000 is not part of the ROC base. This is one of the most common spreadsheet errors — more on that below. Second, the GP's co-invest gets treated the same as LP capital in this tier. They put money in, they get it back first.

Tier 2: Preferred Return

Now that everyone has their capital back, LPs (and the GP on their co-invest) receive their preferred return — the minimum annual return on their contributed capital before the GP earns any promote.

The formula:

Accrued Pref = Principal × Rate × (Days Deployed / 365)

Since all investors funded on January 1 and we're distributing on December 31, everyone accrues for exactly 365 days:

After Tier 2: $180,000.00 − $81,600.00 = $98,400.00 remaining.

The preferred return is not a guaranteed return. It's a priority of payment. If the fund only had $50,000 of profit to distribute, that $50,000 would go entirely to Tier 2 (pro-rata among investors), and nobody would see Tiers 3 or 4. The pref means the GP doesn't participate in profits until LPs have received their 8%.

Tier 3: GP Catch-Up

This is the tier most people struggle with — and the one that makes or breaks the GP's economics.

Here's the problem. After Tier 2, the fund has distributed $81,600.00 in profits (the preferred return). All of it went to investors proportionally. The GP's promote is supposed to be 20% of total profits. But right now, the GP has received $1,600.00 of profit (their pref on the co-invest) — 1.96% of profit distributed, nowhere close to 20%.

The catch-up fixes this by directing 100% of the next distributions to the GP until the GP's cumulative profit share reaches their promote percentage of all profit distributed.

Catch-Up Target = Total Pref Paid × (GP Promote % / LP Promote %)

$81,600.00 × (20 / 80) = $20,400.00

The GP receives $20,400.00. Every dollar comes from the remaining pool until this target is hit.

After Tier 3: $98,400.00 − $20,400.00 = $78,000.00 remaining.

Why does the catch-up exist? Without it, the GP's 20% promote only kicks in at Tier 4 — the profit split. They'd miss their share of the profits that were distributed as pref in Tier 2. The catch-up "catches up" the GP so that, by the time Tier 4 begins, cumulative profit distributions are effectively at the target split ratio.

After catch-up, total profits distributed are $81,600.00 (pref) + $20,400.00 (catch-up) = $102,000.00. The GP has received $1,600.00 + $20,400.00 = $22,000.00 of that — about 21.6%, slightly above 20% because the GP also earned pref on their co-invest. The catch-up has done its job.

Tier 4: Profit Split

Everything left gets split at the agreed promote ratio. The LP portion is allocated pro-rata among LPs based on their ownership percentages.

LP ownership percentages here are relative to each other: LP A committed $600,000 of the $1,000,000 LP pool (60%), LP B committed $400,000 (40%).

The Complete Picture

Here's what each investor receives across all four tiers:

The GP invested $20,000 and received $57,600 — a 2.88× multiple on co-invested capital. LP A invested $600,000 and received $685,440 — a 1.14× multiple. LP B invested $400,000 and received $456,960 — also 1.14×.

The LPs earned the same multiple because they funded on the same date with the same terms. That won't always be the case.

Try these numbers yourself in the free waterfall calculator →

Time-Weighted Preferred Return

The example above was clean: every investor funded on the same date. That almost never happens in practice. Capital calls go out in tranches — maybe $500K at closing, another $300K six months later when a second property is acquired. When investors fund at different times, the preferred return calculation changes fundamentally.

Here's the example that exposes the bug in most spreadsheets.

Distribution date: December 31. Same year. Same 8% pref rate. Same commitment amount.

LP A has had capital deployed for 365 days:

$500,000 × 8% × (365 / 365) = $40,000.00

LP B has had capital deployed for 184 days (July 1 through December 31):

$500,000 × 8% × (184 / 365) = $20,164.38

A flat-rate spreadsheet — one that calculates pref as commitment × rate with no date adjustment — gives both LPs $40,000. That's $19,835.62 of LP A's money going to LP B.

LP A's capital was at work for six months longer. Their pref should reflect that. A flat-rate calculation effectively subsidizes late-funding investors at the expense of early-funding ones. And this is a single-year example. Over a five-year hold with multiple staggered capital calls, the misallocation can run into six figures on a moderately sized fund.

This is the kind of error that sophisticated LPs catch when they review their annual statements — because their accountants know the math, even if the spreadsheet doesn't.

Multi-Tranche Accrual

It gets more nuanced. A single investor might fund multiple capital calls at different dates. Each tranche accrues independently:

LP A's total pref is $36,054.79 — not the $40,000 a flat-rate calculation would produce. The $200,000 second tranche has only been deployed for 275 days, not a full year.

If you're building this in a spreadsheet, you need a row per tranche per investor, not a row per investor. That's where most templates fall apart.

Day Count Conventions

The pref formula uses 365 as the denominator: Principal × Rate × (Days / 365). That denominator is the day count convention, and your operating agreement should specify which one applies.

Actual/365

Count the actual number of calendar days between the funding date and the distribution date, divide by 365. A non-leap year produces a pref multiplier of exactly 1.0× for a full year. A leap year with 366 days produces 366/365 = 1.00274× — slightly more than a full year's pref. This is the standard for equity waterfalls and the default assumption when the operating agreement is silent on convention.

Actual/360

Same numerator (actual calendar days), but the denominator is 360 instead of 365. This convention is common in commercial lending — it's how most banks calculate loan interest. A full year of 365 days produces a multiplier of 365/360 = 1.01389×. On an 8% pref with $1M committed, that's $81,111.11 instead of $80,000.00 — an extra $1,111.11 per year per million. Some operating agreements specify Actual/360 intentionally to give LPs a slightly higher effective return. Others specify it because the attorney copied language from a loan document. Either way, it changes the math.

30/360

Every month is treated as 30 days. Every year is 360 days. January has 30 days. February has 30 days. It simplifies accrual calculations at the cost of precision. This convention is standard in corporate bond markets and appears in some older fund documents, but it's rare in modern equity waterfalls. If your operating agreement doesn't mention a day count convention, don't use this one.

The takeaway: check your operating agreement. If it specifies a convention, use it. If it doesn't, Actual/365 is the safe default. And if you're drafting a new agreement, specify the convention explicitly — it removes ambiguity for everyone.

Common Mistakes

These are the errors that show up most often in fund distribution spreadsheets and manually configured waterfall engines. Each one changes investor allocations by real dollar amounts.

Counting unpaid capital calls in the ROC base

If you issued a $200,000 capital call and LP A hasn't paid it yet, that $200,000 is not part of their funded capital. Their ROC entitlement should be calculated against what they've actually funded, not what they've been called for. Including unpaid calls inflates the ROC tier, which means less cash flows to Tier 2 and beyond — effectively letting delinquent investors hold up distributions for everyone else.

Flat-rate pref instead of date-weighted

The single most common waterfall error, and it compounds over time. If your pref calculation is commitment × rate with no date component, it's wrong for any fund where investors funded at different times. The error always runs the same direction: it overpays late-funding investors and underpays early-funding investors. See the time-weighted section above for the full math.

Forgetting that GP co-invest earns pref

The GP co-invests 1–5% of fund capital alongside LPs. That co-invest earns preferred return just like LP capital — the GP is an investor in the fund, not just the manager. Excluding the GP from Tier 2 underpays them on pref and throws off the catch-up calculation in Tier 3, since the catch-up target is derived from total pref paid.

The penny problem

$1,000.00 divided among three equal investors is $333.33 each — totaling $999.99. Where does the missing penny go?

In a consumer app, nobody notices. In a fund distribution, every cent must be accounted for. The standard approach: compute each investor's allocation as a precise decimal, floor each to the nearest cent, then assign the remaining pennies to the investor with the largest allocation. This is deterministic, auditable, and guarantees the distribution total matches to the penny.

It sounds trivial until you have 25 investors and the rounding error is 4 cents spread across three tiers. You need a clear, consistent rule — not an approximation.

Skipping catch-up and going straight to profit split

Some GPs calculate the waterfall as three tiers — ROC, pref, then split — because catch-up feels like an unnecessary complication. The math shows why it's not optional when the operating agreement calls for it.

Using our original example with $180,000.00 in profit:

Without catch-up, the GP goes straight from pref to the 80/20 split on the remaining $98,400.00. Their 20% share is $19,680.00, for a total of $21,280.00 in profit — $16,320.00 less than with catch-up enabled. That's the difference between the GP receiving 20.9% of total profits and 11.8%.

If your operating agreement specifies catch-up and your spreadsheet skips it, you're underreporting the GP's entitlement. If it doesn't specify catch-up and you include it, you're overpaying the GP. The operating agreement is the source of truth.

Automate It

This is exactly what Capgist's waterfall engine handles — time-weighted pref accrual across every funding tranche, penny-accurate allocation with deterministic rounding, and sequential tier enforcement that won't let a profit-split distribution go out before ROC is complete.

Configure your fund's pref rate, GP promote percentage, catch-up preference, and day count convention once. Every distribution after that flows through the waterfall automatically. Each investor's statement shows the exact breakdown by tier, the accrual days per tranche, and the math behind every dollar.

Try the numbers from this article in the free waterfall calculator →

See how Capgist automates fund distributions →