Investment Analysis

Waterfall Distribution Modeling Made Simple

Model institutional-quality GP/LP waterfall structures with preferred returns, catch-up provisions, and multi-tier promote splits — without a finance degree or a $15,000/yr software license.

Build a Waterfall Free See DCF Analysis

What Is a Waterfall Distribution?

A waterfall distribution is the agreed-upon structure that determines how investment returns flow to different classes of investors. In commercial real estate, this typically involves a General Partner (GP) — the deal sponsor — and Limited Partners (LPs) — passive investors who provide most of the equity.

Returns "cascade" through tiers, much like water flowing over ledges. Each tier must be satisfied before the next tier begins. This aligns GP incentives with LP outcomes: the GP earns a disproportionate share (promote) only after LPs receive their target returns.

The Standard 4-Tier Structure

Most institutional JV agreements follow this pattern

1

Return of Capital

LPs receive 100% of their invested capital back before any profit distributions begin.

LP: 100% / GP: 0%

2

Preferred Return

LPs receive a preferred return (typically 6–10% IRR) before the GP participates in profits.

LP: 100% / GP: 0%

3

GP Catch-Up

GP receives 100% of distributions until they've "caught up" to their promote share of all prior distributions.

LP: 0% / GP: 100%

4

Residual Split

Remaining profits split according to the agreed promote structure (e.g., 70/30 LP/GP or 80/20).

LP: 70% / GP: 30%

Key Waterfall Concepts

Preferred Return (Pref)

The minimum annual return LPs must receive before the GP earns a promote. Usually expressed as an IRR hurdle (e.g., 8%). Acts as a "floor" that protects LP downside.

GP Catch-Up

After LPs hit their pref, the GP receives 100% of distributions until they've accumulated their promote share. A "50% catch-up" means the GP gets 50% of each dollar until caught up.

Promote / Carried Interest

The GP's disproportionate share of profits above the pref hurdle. E.g., a 20% promote means the GP receives 20% of residual profits despite contributing only 5–10% of equity.

GP Transaction Fees

Fees charged by the GP at various stages: acquisition fee (1–2% of purchase price), asset management fee (1–2% of revenue), disposition fee (1% of sale price), and construction management fee.

Model Any Waterfall in Solsten

From simple 2-tier JVs to complex institutional structures

📊

4-Tier Standard Template

Start with the industry-standard waterfall and customize hurdle rates, catch-up percentages, and residual splits.

👥

Inline Investor Editing

Add GP and LP investors directly in the form. Set ownership percentages, capital contributions, and K-1 distribution preferences.

💰

Reserve & Equity Injections

Model reserve contributions, draws, and equity injections with a year-by-year reserve forecast timeline.

📈

Exit Scenario Analysis

See IRR, NPV, and equity multiple for every possible exit year. Optimal exit highlighted automatically.

🏦

GP Fee Tracking

Acquisition fees, asset management fees, disposition fees, and construction management fees — all tracked and factored into returns.

📋

Full Operating Statement

Waterfall distributions tie directly into your proforma. Annual and monthly operating statements with debt service and DSCR tracking.

Waterfall Distribution FAQ

What is a waterfall distribution in commercial real estate? +
A waterfall distribution is the contractual structure that determines how investment returns are divided between General Partners (GPs) and Limited Partners (LPs). Returns "cascade" through tiers — typically return of capital, preferred return, GP catch-up, and a residual profit split — so the GP only earns a disproportionate share (promote) after LPs hit their target return.
What is a preferred return (pref)? +
A preferred return is the minimum annual return that LPs must receive before the GP earns any promote or carried interest. It is usually expressed as an IRR hurdle, commonly 6–10%. It acts as a floor that protects LP downside and aligns GP incentives.
What is GP catch-up in a waterfall? +
GP catch-up is a tier where the GP receives 100% of distributions until they accumulate their promote share of all prior profits. For example, a 50% catch-up means the GP gets 50 cents of every dollar until caught up. This rewards the GP for exceeding the LP's preferred return hurdle.
What is carried interest (promote)? +
Carried interest, or a promote, is the GP's disproportionate share of profits above the preferred return hurdle. For example, a 20% promote means the GP receives 20% of residual profits despite contributing only 5–10% of the total equity.
Can Solsten model custom waterfall structures? +
Yes. Solsten includes a standard 4-tier template (return of capital → preferred return → GP catch-up → residual split) and lets you create custom multi-tier structures with configurable hurdle rates, catch-up percentages, and residual splits. You can model simple 2-tier JVs or complex institutional structures.
How does Solsten differ from Excel for waterfall modeling? +
Solsten ties waterfall distributions directly to a live proforma engine, so distributions update automatically when underlying property data changes. It includes built-in GP fee tracking, investor management, and exit scenario analysis — eliminating the manual formula maintenance and error risk of Excel models.

Build Institutional-Quality Waterfalls

Stop building waterfall models in Excel. Solsten gives you a visual, auditable waterfall engine powered by a full proforma — at a fraction of the cost of ARGUS or Juniper Square.

Try Solsten Free

No credit card required. Full access during beta.