Skip to content

davepoon/buildwithclaude / plugins/venture-capital-intelligence/skills/fund-operations

fund-operations

Verified

FileKindSize
SKILL.mdskill md4.4 KB
scripts/fund_formatter.pyscript3.7 KB
scripts/fund_kpi_calc.pyscript7.8 KB

scripts/fund_formatter.py

View on GitHub
#!/usr/bin/env python3
"""
fund-operations/scripts/fund_formatter.py
Reads fund_output.json and prints the formatted fund performance report.
"""

import json
import sys
import os


def fmt_usd(val) -> str:
    if val is None:
        return "N/A"
    v = float(val)
    if abs(v) >= 1_000_000_000:
        return f"${v/1_000_000_000:.2f}B"
    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 moic_label(moic: float) -> str:
    if moic >= 5:   return "🔥"
    if moic >= 3:   return "⭐"
    if moic >= 1.5: return "✅"
    if moic >= 1:   return "─"
    return "🔴"


def main():
    script_dir  = os.path.dirname(os.path.abspath(__file__))
    output_dir  = os.path.join(script_dir, "..", "output")
    output_path = os.path.join(output_dir, "fund_output.json")

    if not os.path.exists(output_path):
        print("ERROR: fund_output.json not found. Run fund_kpi_calc.py first.", file=sys.stderr)
        sys.exit(1)

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

    sep   = "━" * 54
    kpis  = data.get("kpis", {})
    carry = data.get("carry", {})

    lines = [
        "",
        sep,
        f"FUND REPORT  ·  {data.get('fund_name', 'Fund')}  ·  Vintage {data.get('vintage_year')}  ·  Age {data.get('fund_age_years')} yrs",
        sep,
        "",
        "FUND SNAPSHOT",
        f"  Committed Capital:    {fmt_usd(data.get('committed_capital'))}",
        f"  Total Invested:       {fmt_usd(data.get('total_invested'))}",
        f"  Unrealized FMV:       {fmt_usd(data.get('total_fmv'))}",
        f"  Total Realized:       {fmt_usd(data.get('total_realized'))}",
        f"  Total Value:          {fmt_usd(data.get('total_value'))}",
        f"  Investments:          {data.get('num_investments')} ({data.get('num_active')} active, {data.get('num_exited')} exited)",
        "",
        sep,
        "FUND KPIs",
        sep,
        f"  TVPI (Total Value Multiple)   {kpis.get('tvpi', 0):.2f}×",
        f"  DPI  (Distributions/Paid-In)  {kpis.get('dpi', 0):.2f}×",
        f"  RVPI (Residual Value)         {kpis.get('rvpi', 0):.2f}×",
        f"  IRR  (Annualized Return)      {kpis.get('irr_pct', 0):.1f}%",
        "",
        f"  J-Curve Position: {data.get('j_curve', '')}",
        "",
        sep,
        "FUND ECONOMICS",
        sep,
        f"  Management Fees (to date):    {fmt_usd(data.get('management_fee_total'))}",
        f"  Total Invested (net of fees): {fmt_usd(data.get('total_invested'))}",
        f"  Preferred Return to LPs:      {fmt_usd(carry.get('preferred_return'))}",
        f"  Profits Above Hurdle:         {fmt_usd(carry.get('profits_above_hurdle'))}",
        f"  Carry Earned (GP):            {fmt_usd(carry.get('carry_earned'))}  ({int(carry.get('carry_pct', 0.20)*100)}%)",
        f"  LP Total Proceeds:            {fmt_usd(carry.get('lp_total_proceeds'))}",
        "",
        sep,
        "PORTFOLIO COMPANIES (ranked by MOIC)",
        sep,
        f"  {'Company':<20}  {'Invested':>10}  {'FMV':>10}  {'Realized':>10}  {'MOIC':>7}  {'Status':<8}",
        f"  {'─'*20}  {'─'*10}  {'─'*10}  {'─'*10}  {'─'*7}  {'─'*8}",
    ]

    for c in data.get("company_metrics", []):
        icon   = moic_label(c.get("moic", 0))
        status = c.get("status", "").capitalize()
        lines.append(
            f"  {c['company']:<20}  {fmt_usd(c['invested']):>10}  {fmt_usd(c['current_fmv']):>10}"
            f"  {fmt_usd(c['realized']):>10}  {c['moic']:>5.2f}×  {icon} {status}"
        )

    lines += [
        "",
        sep,
        "Audit files: fund_inputs.json · fund_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