Real estate syndication is one of the most powerful ways to pool capital for larger deals. But if you're a syndicator or fund manager, you know the hardest part isn't finding the deal — it's explaining the waterfall structure to investors so they trust your numbers.
A waterfall model determines how profits are split between the sponsor (GP) and limited partners (LPs). Get it wrong, and either investors don't get their promised returns or the sponsor leaves money on the table.
In this post, I'll walk through the 4-tier waterfall structure I use professionally and share my Excel template that automates the whole process.
The 4 Tiers of a Real Estate Waterfall
Tier 1: Preferred Return
The LP gets first priority on distributions — typically 8-10% annual return before the GP gets anything. This aligns incentives: investors are paid first.
Tier 2: Hurdle IRR 1 (e.g., 10%)
After preferred return is met, remaining cash gets split — typically 80% to LP, 20% to GP.
Tier 3: Hurdle IRR 2 (e.g., 15%)
As returns compound, the sponsor's share increases. Common split: 70/30.
Tier 4: Hurdle IRR 3 (e.g., 20%)
At the highest tier, the sponsor collects 40% or more. This incentivizes the GP to push for maximum returns.
Why You Need a Spreadsheet Model
Manual calculations with 4 tiers across 10-year projections is error-prone. One wrong formula in IRR and your investor returns will be off by thousands.
My Excel model handles all of this automatically:
- Input your property assumptions (price, LTV, interest rate, etc.)
- Set your waterfall structure (preferred return, split ratios, hurdle IRRs)
- The model calculates LP vs GP returns for each year
- Scenario Manager lets you stress-test assumptions
Grab the complete template here: Real Estate Syndication Waterfall Model — Excel
What waterfall structure do you use in your syndications? Drop a comment below.
Top comments (0)