How does it help with clawback prevention?

The skill includes a quality check that flags clawback exposure if the cumulative GP carry exceeds the amount permitted by a whole-fund lookback calculation.

What documentation does the skill generate?

It produces a tier-by-tier allocation table, partner-level distribution notices, a carry calculation summary, and a waterfall status tracker.

What types of waterfall structures does this skill support?

It supports standard private equity and venture capital waterfalls, including American and European styles, featuring preferred returns, GP catch-ups, and various carried interest splits.

Can it handle preferred return compounding?

Yes, the skill can process both IRR-based hurdles and cumulative compounded rates based on the specific day-count conventions and compounding frequency defined in the LPA.

Does this skill account for LP-specific side letters?

Yes, the workflow includes steps to apply LP-specific economics, such as fee discounts or carry reductions, without affecting the aggregate economics of other partners.

Fund Distribution & Waterfall Calculator

Name: Fund Distribution & Waterfall Calculator
Author: lev-os

bylev-os

•

Productivity & Workflow

Automates complex partnership waterfall calculations including preferred returns, GP catch-up, and carried interest allocations.

This skill provides a structured framework for managing private equity and venture capital distribution waterfalls directly within Claude. It guides users through the entire lifecycle of a realization event, from validating capital account data and calculating tiered returns to generating partner-level distribution notices. By ensuring adherence to Limited Partnership Agreements (LPA) and providing built-in quality checks for IRR compounding and clawback exposure, it streamlines the complex reconciliation process between fund administrators, general partners, and limited partners.

Key Features

01Automated reconciliation and clawback exposure flagging

02Partner-level pro-rata distribution scheduling and side-letter adjustments

03Preferred return modeling with IRR or cumulative compounding options

04GP Catch-up and tiered Carried Interest allocation tracking

05Multi-tier waterfall calculation (Return of Capital, Pref, Catch-up, Carry)

062 GitHub stars

Use Cases

01Processing an asset sale or refinancing event to determine LP and GP distributions

02Modeling prospective exit scenarios and carry accruals for quarterly investor reporting

03Reconciling third-party fund administrator waterfall calculations against LPA provisions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lev-os/agents managing-distribution-waterfall-calculations

For use in Claude.ai and ChatGPT

Key Features

01Automated reconciliation and clawback exposure flagging

02Partner-level pro-rata distribution scheduling and side-letter adjustments

03Preferred return modeling with IRR or cumulative compounding options

04GP Catch-up and tiered Carried Interest allocation tracking

05Multi-tier waterfall calculation (Return of Capital, Pref, Catch-up, Carry)

062 GitHub stars

Use Cases

01Processing an asset sale or refinancing event to determine LP and GP distributions

02Modeling prospective exit scenarios and carry accruals for quarterly investor reporting

03Reconciling third-party fund administrator waterfall calculations against LPA provisions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lev-os/agents managing-distribution-waterfall-calculations

For use in Claude.ai and ChatGPT