casemark/managing-distribution-waterfall-calculations

Managing Distribution Waterfall Calculations

Executes distribution calculations through partnership waterfall with preferred return, GP catch-up, and carried interest allocation.

When To Use

• Processing a realization event (asset sale, refinancing proceeds, dividend recap) that triggers LP/GP distributions
• Running quarterly or annual waterfall calculations for investor reporting
• Modeling prospective distributions for a pending exit
• Reconciling prior distributions against cumulative waterfall tiers
• Responding to LP inquiries about carry accrual or distribution allocations

Inputs To Gather

• LPA waterfall provisions — exact tier structure, preferred return rate, catch-up percentage, carry split, and any clawback or giveback language [VERIFY against the specific fund's LPA]
• Capital account data — each LP's committed capital, contributed capital, and unfunded commitments
• Prior distribution history — cumulative distributions by partner, broken out by return of capital vs. profit
• Current distributable amount — net proceeds available after transaction costs, reserves, and GP-level holdbacks
• Preferred return parameters — rate (e.g., 8% IRR or 8% cumulative compounded), compounding frequency, accrual start date (funding date vs. commitment date) [VERIFY compounding convention]
• GP commitment details — GP co-invest amount and whether GP participates pro rata through the waterfall or only at the carry tier
• Reserve and holdback amounts — tax withholding, escrow holdbacks, contingency reserves

Workflow

1. Validate capital accounts

   • Confirm each partner's contributed capital, prior distributions (ROCR vs. profit), and net funded amount
   • Reconcile against the fund administrator's records; flag any discrepancies as [VERIFY]

2. Determine distributable proceeds

   • Start with gross realization proceeds
   • Deduct transaction expenses, organizational expense recoupment (if applicable), and management fee offsets
   • Set aside approved reserves (escrow, tax withholding, contingency)
   • Resulting figure = net distributable amount

3. Run Tier 1 — Return of Capital

   • Allocate distributions to LPs (and GP co-invest) until each partner has received cumulative distributions equal to their contributed capital
   • Track remaining distributable amount after Tier 1 is satisfied

4. Run Tier 2 — Preferred Return

   • Calculate accrued preferred return for each partner based on LPA terms (IRR-based or cumulative compounded)
   • For IRR-based waterfalls: solve for the distribution amount that brings each partner's IRR to the hurdle rate on contributed capital, netting prior profit distributions
   • For cumulative-compounded waterfalls: compute accrued preferred on outstanding capital balances from each drawdown date, less prior preferred distributions
   • Allocate available proceeds to satisfy accrued preferred; if insufficient, allocate pro rata among partners based on their respective unpaid preferred amounts

5. Run Tier 3 — GP Catch-Up

   • After preferred return is fully satisfied, allocate proceeds to the GP until the GP has received its stated share (commonly 20%) of all cumulative profits distributed (Tiers 2 + 3 combined)
   • Determine if catch-up is 100% to GP or a blended split (e.g., 80/20) [VERIFY catch-up formula in LPA]
   • If distributable amount is insufficient to complete catch-up, allocate the entire remaining amount to the GP per LPA terms

6. Run Tier 4 — Carried Interest Split

   • Allocate remaining proceeds according to the stated profit split (e.g., 80% LP / 20% GP carry)
   • Apply any tiered carry structure if applicable (e.g., carry increases to 25% above a second hurdle) [VERIFY whether multi-tier carry applies]

7. Allocate across individual partners

   • Distribute LP-level amounts pro rata based on each LP's share of aggregate LP commitments (or contributed capital, per LPA)
   • Apply any LP-specific side letter economics (fee discounts, carry reductions, co-invest offsets) [VERIFY side letter terms]

8. Reconcile and cross-check

   • Confirm total distributions across all partners equals the net distributable amount
   • Verify cumulative waterfall position: which tiers are fully satisfied, partially satisfied, or unsatisfied
   • Run a reverse check — compute implied net IRR and equity multiple for LPs to validate reasonableness

Output

• Distribution waterfall schedule — tier-by-tier allocation table showing current-period and cumulative amounts per tier
• Partner-level distribution notice — each partner's allocated distribution broken into return of capital and profit components
• Carry calculation summary — GP carried interest earned in the current period, cumulative carry to date, and any carry reserve or clawback exposure
• Waterfall status tracker — current position in the waterfall (e.g., "Tier 2: Preferred Return — 62% satisfied") with remaining amounts to clear each tier
• Tax character breakdown — allocation of distributions by tax character (capital gain vs. ordinary income) if tax data is available [VERIFY with fund tax advisor]

Quality Checks

• All partner distributions sum exactly to the net distributable amount (zero residual)
• Preferred return calculations use the correct compounding convention and day-count basis per the LPA
• GP catch-up allocation does not exceed the amount required to reach the stated carry percentage of total profits
• Prior distributions are correctly credited against each waterfall tier before applying current proceeds
• Side letter adjustments are applied only to the affected LP and do not alter aggregate economics for other partners
• Clawback exposure is flagged if cumulative GP carry exceeds what a whole-fund lookback would produce [VERIFY clawback methodology]
• Distribution amounts reconcile with the fund administrator's independent calculation before release