Development Waterfall and Promote Checklist
Executive Summary
Key Takeaways
- ✓ A real estate waterfall and promote structure carries tier-sequencing, hurdle-timing, and catch-up/clawback mechanics that a general financial model audit checklist does not test in this depth.
- ✓ Each waterfall tier should be checked as its own independent calculation, since a single blended formula error can propagate undetected through every subsequent distribution.
- ✓ Hurdle rate tests should be verified against actual cumulative cash distribution timing, not a static percentage-of-profit assumption.
- ✓ Clawback exposure should be checked as a running, cumulative calculation across the investment life, not only at final exit.
Objective¶
This checklist verifies the structural mechanics specific to a real estate waterfall and promote calculation: tier sequencing, hurdle rate testing, and catch-up and clawback mechanics. It exists as a distinct checklist because these mechanics do not appear in a standard corporate model and are not covered by the general Financial Model Audit Checklist or the Real Estate Development Model Checklist, both of which this checklist assumes have already been applied to the underlying appraisal.
Applicability¶
Applicable when reviewing a real estate sponsor-investor waterfall and promote (carried interest) calculation, whether for a single development, a build-to-rent investment, or a fund-level structure distributing across multiple assets.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | Each waterfall tier (return of capital, preferred return, catch-up, promote splits) is built as its own separate, labelled calculation block | A single blended formula cannot be checked tier by tier, and an embedded error propagates undetected through every subsequent distribution | Tier-by-tier formula trace |
| 2 | IRR-based hurdles (e.g., preferred return) are tested against actual cumulative cash distribution timing, not a static percentage split | A static split misrepresents a genuinely time-sensitive hurdle test required by the underlying agreement | Hurdle calculation methodology documentation |
| 3 | The catch-up provision is modelled as its own explicit step, with both its trigger point and target overall ratio independently verifiable | An implicit or blended catch-up calculation cannot be checked against the agreement's stated target split | Catch-up formula trace against agreement terms |
| 4 | Clawback liability is tracked as a running, cumulative calculation across the investment life, not only at final exit | Clawback exposure depends on the gap between interim and final performance, which requires ongoing tracking | Cumulative clawback tracking schedule |
| 5 | The waterfall's tier thresholds and split percentages match the underlying legal agreement (LPA, JV agreement, or development agreement) | A model that diverges from the actual agreed terms produces a legally inconsistent distribution | Side-by-side comparison against the executed agreement |
| 6 | Distributions are sequenced against the model's actual projected or actual cash timing, not assumed to occur on a uniform schedule | Misaligned timing produces an incorrect hurdle test result even where the tier formulas themselves are correct | Distribution timing schedule cross-check |
| 7 | Any GP/LP or sponsor/investor co-investment split within a given tier is calculated consistently with the stated ownership percentages | An inconsistent split percentage produces a distribution that does not match the parties' actual economic interests | Ownership and co-investment schedule |
| 8 | Sensitivity testing is applied to the waterfall's key drivers (exit value, exit timing) to confirm tier thresholds behave correctly across a range of outcomes | A waterfall that appears correct in the base case can contain a formula error only exposed under a different exit scenario | Sensitivity test results across a range of exit assumptions |
Common Failures¶
- A single blended formula approximating the overall promote split rather than explicit, separately verifiable tiers.
- A preferred return hurdle tested as a static percentage-of-profit split rather than the agreement's actual IRR-based, time-sensitive test.
- A catch-up calculation with no clearly identifiable trigger point or target ratio, making it impossible to confirm against the agreement.
- Clawback exposure calculated only once, at assumed final exit, with no interim tracking through the investment life.
- Tier thresholds or split percentages that do not match the executed legal agreement.
Recommended Evidence¶
A completed waterfall review should be accompanied by a tier-by-tier formula trace, a side-by-side comparison against the executed legal agreement, and a cumulative clawback tracking schedule. The table above is structured for direct use in investor reporting review, fund administration working papers, or an independent audit file.
How to Use This Checklist¶
Apply the general Financial Model Audit Checklist and, where relevant, the Real Estate Development Model Checklist first, then work through this checklist with particular attention to tier separation and hurdle timing, the two items most likely to conceal a formula error. See Development Waterfall and Promote Structure for the full construction methodology.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Checklists¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Why does a waterfall and promote structure need its own dedicated checklist?
Because it carries tiered hurdle testing, catch-up mechanics, and clawback provisions that a general financial model audit checklist does not test in this depth, and formula errors in a blended waterfall calculation are both common and hard to detect without tier-by-tier verification.
What is the single highest-priority item on this checklist?
Confirming each waterfall tier is built as its own independently checkable calculation block, since a single blended formula approximating the overall split cannot be verified tier by tier and any embedded error propagates undetected through every subsequent distribution.
How should hurdle rate tests be verified?
Against the model's actual cumulative cash distribution timeline, confirming any IRR-based hurdle (such as a preferred return) is calculated using genuine distribution dates and amounts, not a static percentage-of-profit split applied as an approximation.
How should clawback exposure be checked?
As a running, cumulative calculation tracking promote already distributed against projected final, whole-scheme performance throughout the investment life, not a single calculation performed only once at final exit.
Who should use this checklist?
Sponsors preparing a waterfall calculation for investor reporting, investors reviewing a proposed or actual distribution, and advisors conducting an independent review of a waterfall structure ahead of an investment or distribution decision.
Does this checklist cover the underlying development appraisal itself?
No. It is specific to the waterfall and promote calculation. The underlying development appraisal or income model feeding the cash flow the waterfall distributes should be reviewed against the Real Estate Development Model Checklist.
Related Articles
Development Waterfall and Promote Structure
A real estate waterfall and promote structure allocates returns between sponsor and investor across defined hurdle rates of return, and should be built as an explicit, tiered calculation, one clearly labelled block per tier, sequenced against actual cash distribution timing, rather than a single blended split formula. This guide sets out how each waterfall tier, including catch-up and clawback mechanics, should be structured and tested.
Real Estate Development Model Checklist
This checklist covers the structural checks specific to real estate development financial models, on top of the general financial model audit baseline. It focuses on development phasing and cost drawdown mechanics, residual land value calculation, sales and leasing absorption assumptions, and interest during construction. It is intended for developers, lenders financing development, and advisors reviewing a development model ahead of a funding or investment decision.
Cash Waterfall
A cash waterfall is the contractually defined priority sequence in which cash generated by a project is allocated to successive payment obligations. In a project finance structure, the cash waterfall determines the order in which operating costs, debt service (interest and principal), reserve contributions, and equity distributions are paid from the project's revenue. Senior obligations are paid first; junior obligations and distributions are paid only after senior obligations are fully satisfied. The DSCR and other coverage covenants are calculated at specific points within the waterfall to determine whether cash can flow to the next level.