1---2name: draft-distribution-waterfall-memorandum3description: Guides step-by-step modeling and memorandum drafting for a private equity fund distribution waterfall, requiring application of the limited partnership agreement's fee offset provisions, the correct compounding convention, GP catch-up shortfall analysis, clawback assessment, and carried-interest holding-period analysis under the applicable tax rules.4---56# Skill: Draft Distribution Waterfall Memorandum78## 1. Subject-matter triage9- Confirm the governing fund documents, the disposition proceeds, and the relevant payment dates before modeling.10- Identify whether there is one disposition or multiple tranches of proceeds; if multiple, treat each as a separate waterfall pass and then aggregate only at the end.11- Separate fund-level economics from tax treatment: the memorandum should explain allocations under the partnership agreement first, then address carry and holding-period tax consequences as a distinct analysis.1213## 2. Failure modes the skill is correcting14- Computing the waterfall using gross management fees without applying the agreement’s fee-offset provision, which overstates the amount allocated to return of capital and understates the LP preferred-return base.15- Applying a preferred-return convention by intuition rather than the exact compounding or simple-return instruction in the agreement.16- Treating GP catch-up as automatically complete even when the available proceeds only partially fund it, which leaves the residual shortfall untracked.17- Omitting prior portfolio-company distributions from the clawback review and therefore overstating the GP’s retained carry.18- Describing the result narratively without a usable waterfall table, running totals, and appendix calculations.19- Blending tax holding-period analysis into the distribution math without distinguishing the economic allocation from the carry character analysis.2021## 3. Legal frameworks / domain conventions that apply22- Fee offset provision: many limited partnership agreements reduce management fees by specified categories of portfolio-company income or similar receipts; the waterfall must use the net fee after the contractual offset, not a gross-fee proxy.23- Return of capital and preferred return: the LPs are generally entitled to return of capital and any stated hurdle before the GP participates in residual profits; the agreement controls the priority, base, and accrual method.24- Preferred-return compounding convention: the agreement may require simple accrual, annual compounding, quarterly compounding, or another stated method; the selected convention governs the accumulated hurdle over the actual holding period.25- GP catch-up mechanism: once LPs receive capital and preferred return, the GP may receive a catch-up distribution until the cumulative split matches the carried-interest percentage specified in the agreement.26- Clawback framework: the GP’s prior carry must be tested against the whole-fund economics described by the agreement, not only the last transaction; the memorandum should state whether any excess carry is potentially returnable.27- Carried-interest holding period: tax characterization of carry depends on the applicable partnership-interest holding-period rules and the fund’s acquisition-to-disposition timeline for the sold investment.2829## 4. Analytical scaffolds30- Start with a clean chronology: contribution date, acquisition date, fee accrual periods, preferred-return start date, disposition date, and distribution date.31- Build the waterfall in order:32 1. return of capital,33 2. preferred return,34 3. GP catch-up,35 4. residual carried-interest split.36- For each step, state the governing source clause, the base amount, the applicable rate or percentage, the accrual period, and the resulting allocation.37- If the agreement contains multiple allocation buckets, run the waterfall separately for each bucket and reconcile the totals to the full disposition proceeds.38- For catch-up, show whether the available proceeds fully fund the catch-up or leave a shortfall to be carried forward.39- For clawback, compare cumulative GP distributions against the GP’s whole-fund entitlement after taking account of all relevant portfolio-company realizations.40- For tax character, identify whether the holding period meets the required threshold and explain the consequence for carry character without mixing that issue into the fund-accounting allocation.4142## 5. Vertical / structural / temporal relationships43- Distinguish among LP capital, GP capital, fund-level expenses, and management-fee offsets; each affects the return-of-capital base differently.44- Track the temporal sequence of accrual and payment; preferred return and catch-up are time-sensitive, and the end date for each accrual period matters.45- If proceeds are distributed in stages, preserve running cumulative totals across stages so later tranches reflect amounts already paid.46- Keep the economics and tax sections vertically separate: the distribution waterfall should come first, followed by clawback and holding-period analysis.4748## 6. Output structure conventions49- Draft a formal memorandum in polished legal style with an introduction, assumptions, waterfall analysis, and conclusion.50- Include at least one waterfall table showing each step, amount distributed, recipient, and running cumulative total.51- Include supporting calculation tables in an appendix, with formulas or references to the governing input fields used in the model.52- Include a clawback analysis section that states the comparison being made, the conclusion, and any excess carry to date.53- Include a carried-interest holding-period section that states the relevant acquisition and disposition dates, the applicable holding-period rule, and the resulting tax characterization.54- If there is more than one affected period, scenario, or tranche, present separate rows for each before summarizing the aggregate result.55- End with practical recommendations or drafting notes only if the task requires them; otherwise keep the memorandum focused on the economic and tax analysis.