OpenParable
Skip to content
← Back to skills

Waterfall Calculator

Business
waterfall-calculator

Waterfall Calculator is an Agent Skill for business published in the a5c-ai/babysitter repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Calculates distribution waterfalls per LPA terms, carry, clawback

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/a5c-ai/babysitter/blob/HEAD/library/specializations/domains/business/venture-capital/skills/waterfall-calculator/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/waterfall-calculator, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

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

ComponentDescription
Return of CapitalLPs receive contributed capital first
Preferred ReturnLPs receive hurdle (typically 8%)
GP Catch-upGP catches up to carry percentage
Carried Interest80/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

TypeCarry Calculation Basis
AmericanDeal-by-deal, immediate carry
EuropeanWhole fund, after capital return
HybridCombination 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