How to Build a Real Estate Waterfall Distribution Model in Excel (Free Template)

#excel #realestate #investing #finance

If you're syndicating real estate or analyzing LP deals, you need to understand waterfall distributions.

A 4-tier waterfall (preferred return → catch-up → promote → final split) determines exactly how profits flow between investors and sponsors. Here's how to model it in Excel:

Step 1: Set Up Your Inputs

Create cells for: total equity, pref rate, catch-up threshold, promote threshold, and final split percentages.

Step 2: Model the Cash Flow Waterfall

For each year, calculate:

Tier 1: Preferred return to investors (equity × pref rate)
Tier 2: Catch-up to sponsor (remaining CF × sponsor catch-up share)
Tier 3: Promote split (remaining CF × promote sponsor share)
Tier 4: Final split according to agreed percentage

Step 3: Calculate IRR

Use Excel's XIRR function with the cash flow stream and dates.

Step 4: Sensitivity Analysis

Build a data table showing how sponsor promote changes with different IRR thresholds.

Need a pre-built version? Grab the full template with formulas, example deal, and sensitivity table:
https://microtoolsb2b.gumroad.com/l/real-estate-waterfall-excel

Happy modeling!