Skip to main contentSkip to navigationSkip to footer

Syndication Waterfall Modeling Case Study

13 minPRO
5/6

Key Takeaways

  • The preferred return protects LP downside—in all scenarios, LPs receive their 8% pref before GP earns any promote.
  • GP returns are highly leveraged through promote tiers—GP equity multiples range from 2.15x to 6.46x across scenarios.
  • Small changes in project-level returns create large swings in GP economics due to waterfall tier thresholds.
  • Fees (acquisition, asset management) provide GP compensation even in downside scenarios, creating potential misalignment.

Syndication waterfalls determine how returns are split between general partners (GPs) who operate the deal and limited partners (LPs) who provide most of the capital. A seemingly small change in waterfall terms can dramatically shift economic outcomes. This case study walks through a complete waterfall model for a $5M multifamily syndication, calculating LP and GP returns under three performance scenarios.

Scenario 1
Basic

Deal Setup: 50-Unit Syndication

Property: 50-unit apartment complex. Purchase Price: $5,000,000. Total capitalization: $5,500,000 (including $500,000 renovation budget). Senior debt: $4,000,000 (72.7% of total cap). Total equity: $1,500,000, of which LPs contribute $1,350,000 (90%) and GP contributes $150,000 (10%). Waterfall structure: Tier 1—8% cumulative preferred return to all equity pro rata; Tier 2—return of capital to all equity pro rata; Tier 3—70% LP / 30% GP split on profits until LPs achieve 15% IRR; Tier 4—50% LP / 50% GP split on all remaining profits. The GP also earns a 2% acquisition fee ($100,000) and 1.5% annual asset management fee.

Waterfall TierDistributionPurpose
Tier 18% cumulative pref to all equityMinimum return guarantee to LPs
Tier 2Return of capital pro rataLPs get their money back
Tier 370% LP / 30% GP until 15% LP IRRGP incentive to outperform
Tier 450% LP / 50% GP on remainingGP reward for exceptional performance

Four-tier syndication waterfall structure

Scenario 2
Moderate

Base Case: 18% Project IRR

Under the base case, the project generates 18% IRR over 5 years with total equity distributions of $3,150,000 on $1,500,000 invested (2.10x equity multiple). Waterfall distribution: Tier 1—8% pref x $1,500,000 x 5 years = $600,000 distributed pro rata (LP receives $540,000, GP receives $60,000). Tier 2—return of $1,500,000 capital pro rata (LP receives $1,350,000, GP receives $150,000). Remaining profit = $3,150,000 - $600,000 - $1,500,000 = $1,050,000. Tier 3 applies until LP achieves 15% IRR—approximately $630,000 of profit flows through Tier 3 (LP gets $441,000 at 70%, GP gets $189,000 at 30%). Remaining $420,000 flows through Tier 4 (LP gets $210,000 at 50%, GP gets $210,000 at 50%). LP total: $2,541,000 on $1,350,000 (1.88x, ~14.8% IRR). GP total: $609,000 on $150,000 equity plus $100,000 acquisition fee plus $412,500 asset management fees.

Scenario 3
Complex

Downside and Upside Comparisons

Downside scenario (12% project IRR, 1.65x multiple): Total distributions = $2,475,000. After pref ($600,000) and return of capital ($1,500,000), only $375,000 in profit remains. All flows through Tier 3 at 70/30: LP gets $262,500, GP gets $112,500. LP total: $2,152,500 (1.59x, ~10.5% IRR). GP total: $322,500 on equity plus fees. Upside scenario (24% project IRR, 2.60x multiple): Total distributions = $3,900,000. Profit of $1,800,000 flows through Tiers 3 and 4. LP total: $2,931,000 (2.17x, ~18.2% IRR). GP total: $969,000 on equity plus fees. The GP's promote creates asymmetric outcomes—GP equity returns range from 2.15x (downside) to 6.46x (upside), while LP returns range from 1.59x to 2.17x. This asymmetry aligns GP incentives with LP performance but concentrates risk.

Watch Out For

Confusing project-level IRR with LP IRR in syndication presentations

LPs expect project-level returns but actually receive less after GP promote and fees reduce their share

Fix: Always present LP-level returns separately from project-level returns; disclose fee impact on LP returns

Not modeling the waterfall on a period-by-period basis

Aggregate calculations miss the timing of tier transitions, producing inaccurate IRR calculations

Fix: Model distributions period-by-period (quarterly or annually) to capture when each tier threshold is crossed

Ignoring GP fees when calculating total GP compensation

Understating the true economic split between GP and LP, leading to investor misunderstandings

Fix: Disclose all fee income alongside promote income to show total GP compensation as a percentage of total returns

Key Takeaways

  • The preferred return protects LP downside—in all scenarios, LPs receive their 8% pref before GP earns any promote.
  • GP returns are highly leveraged through promote tiers—GP equity multiples range from 2.15x to 6.46x across scenarios.
  • Small changes in project-level returns create large swings in GP economics due to waterfall tier thresholds.
  • Fees (acquisition, asset management) provide GP compensation even in downside scenarios, creating potential misalignment.

Common Mistakes to Avoid

Confusing project-level IRR with LP IRR in syndication presentations

Consequence: LPs expect project-level returns but actually receive less after GP promote and fees reduce their share

Correction: Always present LP-level returns separately from project-level returns; disclose fee impact on LP returns

Not modeling the waterfall on a period-by-period basis

Consequence: Aggregate calculations miss the timing of tier transitions, producing inaccurate IRR calculations

Correction: Model distributions period-by-period (quarterly or annually) to capture when each tier threshold is crossed

Ignoring GP fees when calculating total GP compensation

Consequence: Understating the true economic split between GP and LP, leading to investor misunderstandings

Correction: Disclose all fee income alongside promote income to show total GP compensation as a percentage of total returns

"Advanced Underwriting: Value-Add, Syndication & Portfolio Models" is a Pro track

Upgrade to access all lessons in this track and the entire curriculum.

Immediate access to the rest of this content

1,746+ structured curriculum lessons

All 33+ real estate calculators

Metro-level data across 50+ regions

Test Your Knowledge

1.In a typical syndication waterfall, what is the first priority of cash distributions?

2.How does a GP promote (carried interest) work?

3.Why is the acquisition fee a source of potential GP/LP misalignment?

Was this lesson helpful?

Your feedback helps us improve the curriculum.

Share this