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.
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.
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.