Skip to content

davepoon/buildwithclaude / plugins/venture-capital-intelligence/skills/financial-model

financial-model

Verified

FileKindSize
SKILL.mdskill md4.4 KB
scripts/financial_calc.pyscript10.5 KB
scripts/report_formatter.pyscript3.9 KB

scripts/report_formatter.py

View on GitHub
#!/usr/bin/env python3
"""
financial-model/scripts/report_formatter.py
Reads model_output.json and prints the formatted financial report.
"""

import json
import sys
import os


def fmt_usd(val) -> str:
    if val == "N/A" or val is None:
        return "N/A"
    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 health_icon(status: str) -> str:
    return {"HEALTHY": "✅", "WATCH": "⚠️ ", "CRITICAL": "❌"}.get(status, " ")


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, "model_output.json")

    if not os.path.exists(output_path):
        print("ERROR: model_output.json not found. Run financial_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
    sm  = data.get("saas_metrics", {})
    rm  = data.get("revenue_multiple", {})
    dcf = data.get("dcf", {})
    h   = sm.get("health", {})
    vr  = data.get("valuation_range", {})
    bm  = data.get("benchmarks", {})

    lines = [
        "",
        sep,
        f"FINANCIAL MODEL  ·  {data.get('company', 'Unknown')}  ·  {data.get('stage', '')}",
        sep,
        "",
        f"  ARR: {fmt_usd(data.get('arr', 0))}",
        "",
        "VALUATION RANGE",
        f"  Low:   {fmt_usd(vr.get('low', 0))}",
        f"  High:  {fmt_usd(vr.get('high', 0))}",
        "",
        "  DCF Intrinsic Value:     " + fmt_usd(dcf.get("dcf_value", 0)),
        f"  Revenue Multiple (low):  {fmt_usd(rm.get('implied_value_low', 0))}  ({rm.get('multiples', {}).get('low', 0)}× ARR)",
        f"  Revenue Multiple (mid):  {fmt_usd(rm.get('implied_value_mid', 0))}  ({rm.get('multiples', {}).get('mid', 0)}× ARR)",
        f"  Revenue Multiple (high): {fmt_usd(rm.get('implied_value_high', 0))}  ({rm.get('multiples', {}).get('high', 0)}× ARR)",
        "",
        sep,
        "SAAS HEALTH METRICS",
        sep,
        f"  {health_icon(h.get('ltv_cac'))}  LTV:CAC Ratio       {sm.get('ltv_cac_ratio', 'N/A')}×   (target: > 3×)",
        f"  {health_icon(h.get('payback'))}  CAC Payback         {sm.get('cac_payback_months', 'N/A')} months  (target: < 18 months)",
        f"  {health_icon(h.get('nrr'))}  Net Revenue Retention {sm.get('nrr_pct', 'N/A')}%   (target: > 100%)",
        f"  {health_icon(h.get('burn'))}  Burn Multiple       {sm.get('burn_multiple', 'N/A')}×   (target: < 2×)",
        f"     LTV                 {fmt_usd(sm.get('ltv', 0))}",
        f"     Cust. Lifetime      {sm.get('customer_lifetime_months', 'N/A')} months",
        f"     Runway              {sm.get('runway_months', 'N/A')} months",
        f"     Rule of 40 Score    {sm.get('rule_of_40', 'N/A')}",
        f"     ARR Growth (annual) {sm.get('arr_growth_annual_pct', 'N/A')}%",
        "",
    ]

    if bm:
        lines += [sep, "STAGE BENCHMARKS", sep]
        for k, v in bm.items():
            label = k.replace("_", " ").title().ljust(24)
            lines.append(f"  {label}  {v}")
        lines.append("")

    # DCF projection table
    revs = dcf.get("revenues", [])
    fcfs = dcf.get("fcfs", [])
    if revs:
        lines += [sep, "DCF PROJECTION", sep]
        lines.append(f"  {'Year':<6} {'Revenue':>12} {'FCF':>12}")
        lines.append(f"  {'────':<6} {'────────':>12} {'───':>12}")
        for i, (r, f) in enumerate(zip(revs, fcfs), start=1):
            lines.append(f"  Yr {i:<3} {fmt_usd(r):>12} {fmt_usd(f):>12}")
        lines += [
            f"  Terminal Value: {fmt_usd(dcf.get('terminal_value', 0))}",
            "",
        ]

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