Agent skill

waterfall-calculator

Calculates distribution waterfalls per LPA terms, carry, clawback

Stars 514
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/a5c-ai/babysitter/tree/main/library/specializations/domains/business/venture-capital/skills/waterfall-calculator

Metadata

Additional technical details for this skill

domain
business
skill id
vc-skill-025
specialization
venture-capital

SKILL.md

Waterfall Calculator

Overview

The Waterfall Calculator skill calculates distribution waterfalls according to Limited Partnership Agreement (LPA) terms. It models carried interest, clawback provisions, and LP/GP distributions across various waterfall structures common in venture capital.

Capabilities

Waterfall Structure Modeling

  • Support American (deal-by-deal) waterfalls
  • Support European (whole-fund) waterfalls
  • Handle hybrid waterfall structures
  • Model fund-of-funds structures

Carried Interest Calculation

  • Calculate GP carry based on LPA terms
  • Model catch-up provisions
  • Handle tiered carry structures
  • Track crystallized vs. unrealized carry

Clawback Modeling

  • Calculate potential clawback obligations
  • Model true-up scenarios
  • Track escrow requirements
  • Project final settlement amounts

Distribution Modeling

  • Calculate LP and GP distributions
  • Model management fee offsets
  • Handle recycling provisions
  • Track return of capital vs. profits

Usage

Calculate Waterfall

Input: Fund terms, realized/unrealized values
Process: Apply waterfall mechanics
Output: Distribution allocation, carry calculation

Model Distribution Scenario

Input: Exit scenario, fund status
Process: Calculate pro forma distributions
Output: LP/GP split, carry amount

Calculate Clawback Exposure

Input: Fund history, projected outcomes
Process: Model potential clawback
Output: Clawback exposure, escrow adequacy

Project Final Settlement

Input: Portfolio status, exit projections
Process: Model fund conclusion scenarios
Output: Projected final distributions

Waterfall Components

Component Description
Return of Capital LPs receive contributed capital first
Preferred Return LPs receive hurdle (typically 8%)
GP Catch-up GP catches up to carry percentage
Carried Interest 80/20 split (typically) on remaining

Integration Points

  • Distribution Waterfall Calculation Process: Core skill
  • Cap Table Modeler (Agent): Connect to ownership data
  • K1 Generator: Feed into tax reporting
  • Fund Accountant (Agent): Support accounting work

Waterfall Types

Type Carry Calculation Basis
American Deal-by-deal, immediate carry
European Whole fund, after capital return
Hybrid Combination with clawback

Best Practices

  1. Model precisely per LPA terms
  2. Track management fee offsets
  3. Maintain accurate capital account balances
  4. Model clawback sensitivity
  5. Reconcile with fund administrator

Expand your agent's capabilities with these related and highly-rated skills.

a5c-ai/babysitter

gsd-tools

Central utility skill for GSD operations. Provides config parsing, slug generation, timestamps, path operations, and orchestrates calls to other specialized skills. Acts as the unified entry point that the original gsd-tools.cjs provided via its lib/ modules (commands, config, core, init).

514 31
Explore
a5c-ai/babysitter

model-profile-resolution

Resolve model profile (quality/balanced/budget) at orchestration start and map agents to specific models. Enables cost/quality tradeoffs by selecting appropriate AI models for each agent role.

514 31
Explore
a5c-ai/babysitter

verification-suite

Plan structure validation, phase completeness checks, reference integrity verification, and artifact existence confirmation. Provides the structured verification layer ensuring GSD artifacts are well-formed and complete.

514 31
Explore
a5c-ai/babysitter

state-management

STATE.md reading, writing, and field-level updates. Provides cross-session state persistence via .planning/STATE.md with structured fields for current task, completed phases, blockers, decisions, and quick tasks.

514 31
Explore
a5c-ai/babysitter

git-integration

Git commit patterns, formats, and conventions for GSD methodology. Provides atomic commits per task, structured commit messages, planning file commits, branch management, and milestone tag operations.

514 31
Explore
a5c-ai/babysitter

frontmatter-parsing

YAML frontmatter parsing and manipulation for .planning/ documents. Provides read, write, update, query, and validation operations on frontmatter blocks in GSD markdown artifacts.

514 31
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results