Skip to content

davepoon/buildwithclaude / plugins/venture-capital-intelligence/skills/cap-table-waterfall

cap-table-waterfall

Verified

FileKindSize
SKILL.mdskill md4.4 KB
scripts/captable_calc.pyscript5.6 KB
scripts/waterfall_calc.pyscript5.9 KB
scripts/waterfall_formatter.pyscript3.8 KB

scripts/captable_calc.py

View on GitHub
#!/usr/bin/env python3
"""
cap-table-waterfall/scripts/captable_calc.py
Reads captable_inputs.json, computes SAFE conversions and post-round ownership.
Writes captable_output.json.
"""

import json
import sys
import os


def safe_conversion(safe: dict, pre_round_shares: int, pre_money_valuation: float) -> dict:
    """Compute SAFE conversion shares at the new priced round."""
    principal      = safe.get("principal", 0)
    cap            = safe.get("valuation_cap", 0)
    discount       = safe.get("discount_rate", 0.20)
    safe_type      = safe.get("type", "post-money-safe")

    if pre_round_shares <= 0 or pre_money_valuation <= 0:
        return {"error": "Invalid pre-round shares or valuation", "shares": 0}

    round_price    = pre_money_valuation / pre_round_shares
    discount_price = round_price * (1 - discount)

    if cap > 0:
        cap_price          = cap / pre_round_shares
        conversion_price   = min(cap_price, discount_price)
        conversion_method  = "cap" if cap_price <= discount_price else "discount"
    else:
        conversion_price  = discount_price
        conversion_method = "discount"

    shares = int(principal / conversion_price) if conversion_price > 0 else 0

    return {
        "investor":          safe.get("investor", "SAFE Investor"),
        "principal":         principal,
        "valuation_cap":     cap,
        "discount_rate":     discount,
        "round_price":       round(round_price, 6),
        "conversion_price":  round(conversion_price, 6),
        "conversion_method": conversion_method,
        "shares_issued":     shares,
        "effective_pct":     0,  # filled after total shares known
    }


def main():
    script_dir = os.path.dirname(os.path.abspath(__file__))
    output_dir = os.path.join(script_dir, "..", "output")
    os.makedirs(output_dir, exist_ok=True)

    inputs_path = os.path.join(output_dir, "captable_inputs.json")
    output_path = os.path.join(output_dir, "captable_output.json")

    if not os.path.exists(inputs_path):
        print(f"ERROR: captable_inputs.json not found at {inputs_path}", file=sys.stderr)
        sys.exit(1)

    with open(inputs_path, "r", encoding="utf-8") as f:
        inputs = json.load(f)

    stakeholders = inputs.get("stakeholders", [])
    safes        = inputs.get("safes", [])
    new_round    = inputs.get("new_round", {})

    pre_money    = new_round.get("pre_money_valuation", 0)
    new_money    = new_round.get("new_money", 0)
    pool_pct     = new_round.get("new_option_pool_pct", 0.10)

    # Pre-round total shares
    pre_shares = sum(s.get("shares", 0) for s in stakeholders)
    if pre_shares == 0:
        print("ERROR: No shares found in stakeholders.", file=sys.stderr)
        sys.exit(1)

    # Pre-round ownership
    pre_ownership = [
        {
            "name":    s["name"],
            "shares":  s["shares"],
            "type":    s.get("type", "common"),
            "pct":     round(s["shares"] / pre_shares * 100, 2),
        }
        for s in stakeholders
    ]

    # SAFE conversions
    safe_results = [safe_conversion(safe, pre_shares, pre_money) for safe in safes]
    safe_shares  = sum(r["shares_issued"] for r in safe_results)

    # New investor shares
    round_price     = pre_money / pre_shares if pre_shares > 0 else 0
    new_inv_shares  = int(new_money / round_price) if round_price > 0 else 0

    # Post-round option pool increase
    post_total_est  = pre_shares + safe_shares + new_inv_shares
    pool_new_shares = int(post_total_est * pool_pct)

    # Post-round total
    post_total = pre_shares + safe_shares + new_inv_shares + pool_new_shares

    # Post-round ownership table
    post_ownership = []
    for s in pre_ownership:
        post_ownership.append({
            "name":     s["name"],
            "shares":   s["shares"],
            "type":     s["type"],
            "pre_pct":  s["pct"],
            "post_pct": round(s["shares"] / post_total * 100, 2),
            "dilution":  round(s["pct"] - s["shares"] / post_total * 100, 2),
        })

    for r in safe_results:
        post_ownership.append({
            "name":     r["investor"],
            "shares":   r["shares_issued"],
            "type":     "converted-safe",
            "pre_pct":  0,
            "post_pct": round(r["shares_issued"] / post_total * 100, 2),
            "dilution":  0,
        })

    post_ownership.append({
        "name":     "New Investor (Round)",
        "shares":   new_inv_shares,
        "type":     "preferred",
        "pre_pct":  0,
        "post_pct": round(new_inv_shares / post_total * 100, 2),
        "dilution":  0,
    })

    post_ownership.append({
        "name":     "New Option Pool",
        "shares":   pool_new_shares,
        "type":     "options",
        "pre_pct":  0,
        "post_pct": round(pool_new_shares / post_total * 100, 2),
        "dilution":  0,
    })

    output = {
        "company":          inputs.get("company", "Unknown"),
        "pre_round_shares": pre_shares,
        "post_round_shares": post_total,
        "round_price_per_share": round(round_price, 6),
        "post_money_valuation": pre_money + new_money,
        "safe_conversions": safe_results,
        "pre_ownership":    pre_ownership,
        "post_ownership":   post_ownership,
        "new_round":        new_round,
        "exit_scenarios":   inputs.get("exit_scenarios", []),
    }

    with open(output_path, "w", encoding="utf-8") as f:
        json.dump(output, f, indent=2)

    print(f"captable_calc.py: pre={pre_shares:,} shares, post={post_total:,} shares, round_price=${round_price:.4f}")
    print(json.dumps(output, indent=2))


if __name__ == "__main__":
    main()
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall