Waterfalls
How should sponsors validate waterfall model formulas?
They should test formulas against the legal agreement, edge cases, prior periods, manual calculations, administrator review, and investor-facing examples.1,2
Keep exploring
Formula validation prevents a technical spreadsheet error from becoming an economic dispute. For sponsors, LP finance teams, administrators, and counsel reviewing distribution economics, the practical answer is to treat the question as part of distribution modeling, return thresholds, preferred return, catch-up, promote, reserves, true-up, and clawback review, not as a one-off definition. The record should show the governing agreement, proceeds schedule, capital accounts, waterfall model, reserve analysis, distribution notice, and approval record so an investor, lender, counsel, administrator, or operating lead can reconstruct the decision later. Use test cases for losses, partial exits, full exits, unpaid preferred return, catch-up boundaries, expense reserves, and investor-specific allocations. The common failure mode is reviewing only the base case and missing errors that appear in downside, high-return, or partial-distribution scenarios.1,2
Archstone
Operate your fund without a back office.
Related glossary terms
Related questions
What should be checked before running a distribution waterfall?
The team should check proceeds, capital accounts, return thresholds, preferred return, catch-up terms, reserves, fees, expenses, and document language.
How should sponsors explain a preferred return in investor materials?
They should explain the rate, compounding method, accrual period, payment priority, catch-up interaction, and whether unpaid amounts carry forward.
What is the difference between a catch-up and a promote split?
A catch-up reallocates distributions after the preferred return so the sponsor reaches an agreed share, while the promote split governs residual upside after that tier.
Related comparisons
Capital Call vs Distribution Notice
Capital calls move money into the vehicle; distribution notices move money back out. The operational workflow is different even when the investor base is the same. For sponsors, the decision affects capital movements, reporting cadence, and who owns execution risk.
Preferred Return vs Hurdle Rate
Preferred return and hurdle rate both define the return threshold LPs receive before the sponsor participates in upside. The distinction is usually structural rather than conceptual. For sponsors, the decision affects return thresholds, reporting cadence, and who owns execution risk.
Waterfall vs Promote
The waterfall defines distribution order. Promote defines the sponsor's share of upside inside that order. For sponsors, the decision affects sponsor economics, reporting cadence, and who owns execution risk.
Sources & References
- 1.Institutional Limited Partners AssociationCapital Call & Distribution Notice TemplateILPA(Capital call, distribution notice, LP reporting, and investor communication standards.)primary · workflow-standard · waterfalls
- 2.Internal Revenue ServicePartnershipsIRS(Partnership tax and reporting context for private vehicles.)primary · tax-context · waterfalls