Private Equity Fund Waterfall Modelling: Worked Examples
Learn how distributions move between limited partners and general partners, how a preferred return differs from carried interest, and why waterfall mechanics can change investment outcomes.
Start with the economic contract
A fund waterfall is not merely a spreadsheet formula. It is the contractual allocation of proceeds among investors and the manager. The limited partnership agreement governs the priority of return of capital, preferred return, GP catch-up, carried interest, clawback and any escrow. A European-style waterfall typically measures performance across the fund, whereas an American-style arrangement may allocate carry deal by deal subject to protections. Never assume the terms of one fund apply to another.
Core vocabulary and formulas
Committed capital is the amount an investor agrees to contribute; paid-in capital is what has actually been called. Distributable proceeds are cash available for allocation after applicable obligations. A preferred return is a contractual hurdle and may be compounded or simple. Carried interest is a share of eligible profits, not necessarily a flat percentage of every distribution. DPI = cumulative distributions / paid-in capital; RVPI = residual value / paid-in capital; TVPI = DPI + RVPI. Those multiples are not annualised returns.
Worked case: simplified whole-fund distribution
Assume LPs contributed $100m, the fund has $160m of distributable cash, and the illustrative contract specifies return of $100m capital, then an $8m preferred-return amount, then an 80/20 split of the remaining $52m with no catch-up. LPs receive $100m + $8m + $41.6m = $149.6m. The GP receives $10.4m. Total = $160m. This is deliberately a simplified no-catch-up example; real fund terms can materially change the allocation.
Build the spreadsheet in five stages
First create an inputs tab containing contributions, dates, cash proceeds and governing terms. Second establish a chronological capital account and hurdle schedule. Third allocate proceeds to unreturned capital. Fourth calculate the preferred return according to the actual compounding and accrual conventions. Fifth calculate catch-up and residual sharing, then reconcile total allocated cash to total distributable cash. Keep deal-level and fund-level logic separate.
How to test the model
Run a zero-profit case, a loss case, an exactly-at-hurdle case and a large-gain case. Check that distributions never exceed available cash, the GP does not receive carry before the applicable contractual threshold, and clawback liabilities are visible. Reconcile each investor class separately. When cash flows occur on multiple dates, compare the waterfall with an independently calculated XIRR schedule.
Course selection checklist
A useful waterfall course should include a real spreadsheet build, European and American structures, catch-up mechanics, escrow or clawback, capital accounts, timing of cash flows and sensitivity analysis. Ask whether learners receive a model with formulas rather than screenshots. The most valuable assessment is a timed allocation exercise followed by a written explanation of why LP and GP incentives differ.
Common mistakes
Do not equate preferred return with a guaranteed return. Do not apply a 20% carry rate automatically to all proceeds. Do not treat a simple preferred-return dollar amount as interchangeable with a compounded annual hurdle. Avoid mixing gross deal IRR, net fund IRR and TVPI. Finally, do not represent a simplified classroom waterfall as legal advice or a substitute for fund documents.
What the learner should be able to produce
By the end of this module, a learner should have a transparent input sheet, an auditable calculation schedule, at least two downside sensitivities and a one-page investment or transaction memo. The memo should identify the decision, supporting evidence, unresolved questions and assumptions that could change the conclusion.
Reviewers should assess arithmetic accuracy, quality of supporting evidence, separation of facts from assumptions, and the clarity of the commercial recommendation. These are more useful measures of competence than simply completing a multiple-choice quiz.
Frequently asked questions
What is a GP catch-up?
A contractual stage that can direct a larger share of incremental distributions to the GP until the agreed carried-interest split is achieved.
Is an 8% hurdle always compounded?
No. The fund agreement defines the accrual convention and timing.
What is the difference between DPI and TVPI?
DPI measures cash returned relative to paid-in capital; TVPI includes residual value.
Can a GP receive carry before the entire fund is profitable?
Certain deal-by-deal structures can allow earlier carry, subject to terms such as escrow and clawback.
References and further reading
These sources provide broader professional context. The worked case and diagrams above were created for this guide; they are not reproduced from the linked publications.
Editorial disclosure: This educational draft was prepared with AI assistance. Calculations and external references should be reviewed by a qualified subject-matter editor before publication. No provider has been independently tested or endorsed in this article. The canonical and related-page URLs are proposed and must be updated to match the final WordPress slugs.
