Real estate waterfall models: Tiers, catch-ups and examples

Two agreements can both describe an 8% preferred return and an 80/20 profit split yet distribute different amounts to investors. The difference may be a catch-up provision, the preference calculation or the definition of capital that must be repaid first.

A useful waterfall model makes each of those terms visible. It shows the cash available, the amount allocated at each tier and the balance carried into the next period.

This guide explains the main terms, compares two allocations of the same exit proceeds and works through a separate example with IRR hurdles.

What is a commercial real estate waterfall?

A commercial real estate waterfall is the set of sequential rules that allocate distributable cash between limited partners and the general partner. Cash fills one tier, then the next, and each tier names who is paid, on what base, and at what split.

A hold-to-sale agreement may return capital before paying the preferred return, followed by a catch-up and residual profit split. Other agreements pay a current preferred return from operating cash before returning capital. Use the sequence specified in the governing agreement.

Return of capital repays invested equity. A preferred return gives investors priority to receive a stated return before the sponsor participates in specified profits.

Payment depends on available cash and the agreement. A cumulative preference carries unpaid amounts forward; compounding also earns a return on those unpaid amounts. With no interim payments, 8% simple preference on $4 million over five years is $1.6 million. Annual compounding produces approximately $1.877 million.

The promote is the sponsor’s performance-based share of profit. If the GP also contributes capital, model the return on that contribution separately and apply the terms of its investment class.

The operating agreement or limited partnership agreement defines cash-distribution rights. Tax allocations are a related but separate calculation: section 704 and IRS Publication 541 address partners’ shares of taxable income and other tax items. Do not assume that a cash-distribution label determines its tax treatment.

The Financial Times reported in September 2026 that three Hackman studio-property loans led by Deutsche Bank, totaling about $950 million, were in default or foreclosure. For an equity waterfall, refinancing pressure makes cash available after lender claims a critical input. Test reduced proceeds and a delayed exit before estimating any promote.

New equity can also change payment priority even if the advertised 80/20 residual split stays the same. Consider a separate hypothetical recapitalization with $5 million available after debt and transaction costs. If the amended agreement gives a new preferred-equity class a $2 million claim ahead of existing equity, only $3 million reaches the original waterfall. That amount must still satisfy the original capital-return and preference tiers before any residual split.

This example illustrates allocation priority, not the reported Hackman transactions or whether rescue funding improves overall returns. Before accepting new capital, identify where the new class ranks, how its return accrues and which approvals the agreement requires. Show existing LPs the revised payment order and distributions under several exit outcomes.

The first example below assumes that all preference accrues until exit because the partnership makes no interim distributions.

Check the preference base. A rate applied to unreturned capital decreases as capital is repaid. A rate applied to original contributed capital may continue on a larger amount if the agreement provides for it. Record the base and its changes explicitly.

Additional hurdles can increase the sponsor’s share after an investor return threshold is met. For example, a residual split may move from 80/20 to 70/30 once the LP reaches a specified IRR.

Worked example: How a catch-up changes an 80/20 split

Assume $4 million of LP equity and no GP co-investment. This hypothetical comparison isolates the promote; it excludes sponsor fees and investor taxes.

The investment is held for five years with no interim distributions. At exit, $6.4 million is available to equity after debt repayment, closing costs and required reserves. Profit available for the waterfall is therefore $2.4 million.

The agreement first returns the $4 million of capital, then pays an 8% simple cumulative preference of $1.6 million. That leaves $800,000 for the catch-up, if any, and residual split.

Structure A, 80/20 residual and no catch-up. The $800,000 splits 80/20, which is $640,000 to the LP and $160,000 to the GP. LP total is $6,240,000, so the GP share of the $2,400,000 profit is 6.7%.

Structure B adds a 100% GP catch-up until the GP reaches a 20% share of total profit, followed by an 80/20 residual split. Solve for catch-up C:

C + 0.20 times ($800,000 minus C) equals 0.20 times $2,400,000.

C equals $400,000 to the GP. Residual $400,000 then splits 80/20: LP $320,000 and GP $80,000.

LP total is $5,920,000 and GP promote is $480,000, which is 20.0% of profit.

Structure	LP total	GP promote	GP share of profit
A, 80/20 after pref, no catch-up	$6,240,000	$160,000	6.7%
B, full catch-up to 20% of profit	$5,920,000	$480,000	20.0%

The catch-up increases the GP’s allocation by $320,000 in this example. Showing the actual allocation alongside the stated split makes the economic difference clear.

Structure B runs in this order:

• Return of capital: $4,000,000 to the LP. Remaining $2,400,000.
• Preferred return (8% simple times five years): $1,600,000 to the LP. Remaining $800,000.
• Catch-up: $400,000 to the GP. Remaining $400,000.
• Residual 80/20: LP $320,000 and GP $80,000.

The equity multiple on Structure A is 1.56x ($6,240,000 / $4,000,000). On Structure B, it is 1.48x.

The different exit allocations also produce different LP IRRs. Compare net investor returns using the waterfall that will actually govern the investment.

Changing the preference to 8% compounded annually would increase accrued preference to about $1.877 million before applying later tiers. Use the agreement’s specified method throughout the model.

A hard hurdle without catch-up allocates the GP a share of profit above the preferred return. A full catch-up can bring the GP to a stated share of total profit, provided sufficient cash remains.

Explain the catch-up in investor materials using the same economic terms as the agreement. A short worked allocation is often easier to understand than the split percentage alone.

Keep the private placement memorandum, financial model and governing agreement consistent. Form D is a notice filing for an exempt offering and does not constitute SEC approval of the terms.

A multi-tier waterfall with IRR hurdles, year by year

A waterfall can also use multiple IRR hurdles. In this separate example, 100% goes to the LP until an 8% IRR hurdle is met, then cash splits 80/20 until the LP reaches 12%, and remaining cash splits 70/30. The model maintains a balance at each hurdle rate, reduced by relevant LP distributions.

Assume $4 million of LP equity, no GP co-investment or catch-up, annual year-end cash flows and a five-year hold. Annual compounding applies to both hurdles. Distributable cash is already net of debt service, fees, expenses and reserves. Year five includes the sale and provides $6.16 million; total cash over the hold is $7.4 million.

Year	Cash available	Tier 1: capital + 8% (100% LP)	Tier 2: 80/20 to a 12% LP IRR	Tier 3: 70/30	LP receives	GP receives
1	$280,000	$280,000	$0	$0	$280,000	$0
2	$300,000	$300,000	$0	$0	$300,000	$0
3	$320,000	$320,000	$0	$0	$320,000	$0
4	$340,000	$340,000	$0	$0	$340,000	$0
5	$6,160,000	$4,378,014	$1,283,851	$498,135	$5,753,789	$406,211
Total	$7,400,000	$5,618,014	$1,283,851	$498,135	$6,993,789	$406,211

How the year-5 row is built. The tier-1 balance starts at $4,000,000, grows 8 percent a year, and shrinks by each operating distribution, so it stands at $4,378,014 in year 5 and tier 1 takes that first. The tier-2 balance runs the same way at 12 percent, netting every dollar the LP has received in tier 1 as well, which leaves $1,027,081 of LP shortfall to the 12 percent hurdle. Tier 2 pays 80/20 until that shortfall is filled, which takes $1,283,851 of cash ($1,027,081 to the LP, $256,770 to the GP). The remaining $498,135 splits 70/30.

The LP receives approximately $6.994 million, a 1.75x multiple and 13.2% IRR. The GP receives approximately $406,000. Later-tier distributions lift the LP’s final return above the 12% boundary. A capital call, refinance or delayed exit requires the schedule to be recalculated.

How to build the model in Excel

Build the model in the following order:

1. Agreement inputs. Record capital by investor and class, preference base, compounding, catch-up, hurdle rates and residual splits. Include any side-letter terms.
2. Available cash. Start with property cash flow after debt service, expenses, fees and required reserves. Identify operating, refinancing and sale proceeds separately.
3. First hurdle. In this annual IRR-hurdle example, grow the opening balance by the hurdle rate, then subtract applicable LP distributions. Allocate no more than the cash available. A simple-preference agreement requires a different accrual formula.
4. Later hurdles. Track each hurdle independently and credit all eligible earlier LP distributions. Divide the remaining LP shortfall by the LP percentage in that tier to find the total cash needed to clear it.
5. Catch-up. Where required, allocate the agreed percentage to the GP until the target profit share is reached. Cap the allocation at the cash remaining.
6. Checks. Confirm that allocations equal available cash, no tier receives a negative amount, capital balances reconcile and each hurdle is satisfied at its boundary. Then calculate final investor returns across all tiers. Test a loss, a delayed exit and a partial capital repayment.

Use the agreement’s timing and compounding convention. IRR applies to equally spaced periods; XIRR uses actual dates and an annualized day-based convention. Confirm that the spreadsheet’s formula implements the contract before using it for distributions.

Deal-by-deal and whole-of-fund waterfalls

The terms American and European describe distribution structures that can be used in different jurisdictions.

A deal-by-deal waterfall can pay carry after a realized investment satisfies the agreement’s capital and return requirements. A whole-of-fund waterfall generally requires repayment of the specified fund-wide capital and preferred return before carry is paid. Agreements differ in their treatment of expenses, write-downs and unrealized investments.

CalPERS’ cash-flow distribution examples illustrate how the timing differs. Review the actual fund terms when comparing either structure.

Compare the payment timing and investor protections in the governing agreement:

Comparison	American (deal-by-deal)	European (whole-of-fund)
Unit of the waterfall	Each realized deal	The fund as a whole
When the GP can take promote	After defined deal-level capital and return tests	After defined fund-wide capital and return tests
Typical home	Single-asset syndications; some multi-asset funds	Institutional multi-asset funds
If later deals fail	Promote may already have been paid	Earlier losses can delay promote
LP backstop	Clawback, if drafted and collectible	Fund-wide hurdle and contractual clawback

For a single-asset investment, there is no broader portfolio of deals over which to apply a fund-wide test. In a multi-asset fund, the choice affects whether early successful exits can generate carry while other investments remain unresolved.

A catch-up allocates additional cash to the GP during a distribution. A clawback can require the GP to repay excess carry after later results establish that it received more than its agreed entitlement.

When reviewing a clawback, check who owes repayment, when it is tested, whether taxes reduce the amount owed and whether an escrow or guarantee supports collection. The existence of a clause and the resources available to satisfy it are separate diligence questions.

Running the waterfall after closing

Keep the governing agreement and any amendments alongside a reconciled investor ledger. The ledger should track contributions, unreturned capital, accrued preference and prior distributions by investor and class.

Compare actual distributions with the underwriting model, while using the signed agreement to determine payment rights.

Agora’s waterfall automation supports configurable tiers, preferred returns and investor-specific terms, including side letters. Teams can review calculation breakdowns before approving distributions.

Connect the allocations to payment execution and investor statements. Explain the treatment of capital repayment and investment returns in each distribution, and reconcile the result to the ledger.

Keep the governing documents accessible in the data room and deliver the resulting statements through investor reporting.

Conclusion

A waterfall model should reproduce the signed economics in dollars. In the first example, the catch-up changes the GP’s allocation from $160,000 to $480,000. Confirm the preference method, payment order and definition of profit before relying on an advertised split.

Explore Agora’s automated waterfall calculations for managing investor allocations and distributions.