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/waterfall_formatter.py

View on GitHub
#!/usr/bin/env python3
"""
cap-table-waterfall/scripts/waterfall_formatter.py
Reads captable_output.json + waterfall_output.json, prints final report.
"""

import json
import sys
import os


def fmt_usd(val) -> str:
    if val is None or val == 0:
        return "$0"
    v = float(val)
    if abs(v) >= 1_000_000:
        return f"${v/1_000_000:.1f}M"
    if abs(v) >= 1_000:
        return f"${v/1_000:.0f}K"
    return f"${v:.0f}"


def main():
    script_dir  = os.path.dirname(os.path.abspath(__file__))
    output_dir  = os.path.join(script_dir, "..", "output")
    ct_path     = os.path.join(output_dir, "captable_output.json")
    wf_path     = os.path.join(output_dir, "waterfall_output.json")

    if not os.path.exists(ct_path):
        print("ERROR: captable_output.json not found.", file=sys.stderr)
        sys.exit(1)

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

    wf = {}
    if os.path.exists(wf_path):
        with open(wf_path, "r", encoding="utf-8") as f:
            wf = json.load(f)

    sep = "━" * 54

    lines = [
        "",
        sep,
        f"CAP TABLE  ·  {ct.get('company', 'Unknown')}",
        sep,
        "",
        f"  Pre-Round Shares:   {ct.get('pre_round_shares', 0):>12,}",
        f"  Post-Round Shares:  {ct.get('post_round_shares', 0):>12,}",
        f"  Round Price/Share:  {fmt_usd(ct.get('round_price_per_share', 0)):>12}",
        f"  Post-Money Val:     {fmt_usd(ct.get('post_money_valuation', 0)):>12}",
        "",
    ]

    # Cap table
    lines += [sep, "OWNERSHIP TABLE", sep]
    lines.append(f"  {'Stakeholder':<22}  {'Shares':>10}  {'Pre %':>7}  {'Post %':>7}  {'Dilution':>8}")
    lines.append(f"  {'─'*22}  {'─'*10}  {'─'*7}  {'─'*7}  {'─'*8}")

    for h in ct.get("post_ownership", []):
        dilution = h.get("dilution", 0)
        dil_str  = f"-{dilution:.1f}%" if dilution > 0 else ("—" if dilution == 0 else f"+{abs(dilution):.1f}%")
        lines.append(
            f"  {h['name']:<22}  {h['shares']:>10,}  {h.get('pre_pct', 0):>6.1f}%  {h.get('post_pct', 0):>6.1f}%  {dil_str:>8}"
        )

    # SAFE conversions
    safe_results = ct.get("safe_conversions", [])
    if safe_results:
        lines += ["", sep, "SAFE CONVERSIONS", sep]
        for r in safe_results:
            lines += [
                f"  Investor:         {r.get('investor', '')}",
                f"  Principal:        {fmt_usd(r.get('principal', 0))}",
                f"  Valuation Cap:    {fmt_usd(r.get('valuation_cap', 0))}",
                f"  Conversion Price: {fmt_usd(r.get('conversion_price', 0))} per share ({r.get('conversion_method', '')})",
                f"  Shares Issued:    {r.get('shares_issued', 0):,}",
                "",
            ]

    # Waterfall scenarios
    scenarios = wf.get("scenarios", [])
    if scenarios:
        lines += [sep, "EXIT WATERFALL SCENARIOS", sep]
        holders = [h["name"] for h in ct.get("post_ownership", []) if h.get("shares", 0) > 0]

        # Header row
        header = f"  {'Stakeholder':<22}"
        for s in scenarios:
            header += f"  {s['label']:>12}"
        lines.append(header)
        lines.append(f"  {'─'*22}" + "  " + "  ".join(["─"*12]*len(scenarios)))

        for name in holders:
            row = f"  {name:<22}"
            for s in scenarios:
                val = s.get("proceeds", {}).get(name, 0)
                row += f"  {fmt_usd(val):>12}"
            lines.append(row)

        # Exit prices
        lines.append("")
        price_row = f"  {'Exit Price':<22}"
        for s in scenarios:
            price_row += f"  {fmt_usd(s.get('exit_price', 0)):>12}"
        lines.append(price_row)

    lines += [
        "",
        sep,
        "Audit files: captable_inputs.json · captable_output.json · waterfall_output.json",
        sep,
        "",
    ]

    print("\n".join(lines))


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