← ClaudeAtlas

ltv-caclisted

Compute SaaS LTV, CAC payback, and LTV/CAC ratio with multiple frameworks side by side (Skok basic, NDR-adjusted, AI-inference-adjusted, Sequoia contribution margin). Outputs a styled Excel workbook with verdict, sensitivity heatmap, and 36-month cohort projection. Use when the user says "/ltv-cac", "calculate LTV", "LTV CAC ratio", "is this business healthy", "unit economics", or "should I scale acquisition". One-shot, no warehouse.
NachoLafuente/5050-gtm · ★ 3 · AI & Automation · score 76
Install: claude install-skill NachoLafuente/5050-gtm
# LTV / CAC Compute LTV, CAC payback, and LTV/CAC ratio with the four canonical formulas side by side. Anchor the verdict on Skok's 3:1 rule, layer on a16z NDR, Sequoia contribution-margin, and Tunguz AI-inference adjustments. Output a styled Excel workbook with a sensitivity heatmap and a 36-month synthetic cohort projection. ## Step 1: Ask the user up to 6 inputs Ask in order. The first 3 are required; the rest have defaults. 1. **ARPU** (monthly revenue per customer, $), e.g. `200` 2. **Customer churn rate** (monthly, decimal), e.g. `0.03` for 3%/mo 3. **CAC** (customer acquisition cost, $), e.g. `1500` 4. **Net revenue expansion** (monthly, decimal, optional), e.g. `0.005` for 0.5%/mo. Default `0`. If they have NDR > 100%, this is positive. 5. **Gross margin** (decimal, optional), e.g. `0.78`. Default `0.78` (78%, typical SaaS). 6. **Inference / variable cost per customer per month** ($, optional), only relevant for AI products. Default `0`. If the user is hesitant on inputs, suggest they start with the example fixture (`examples/inputs.json`). ## Step 2: Run ```bash python skills/ltv-cac/run.py \ --arpu 200 \ --churn 0.03 \ --cac 1500 \ --expansion 0.005 \ --gross-margin 0.78 \ --inference-cost 0 \ --out-dir /tmp/ltv-cac-<client>-<date> ``` Or load all inputs from a JSON file: ```bash python skills/ltv-cac/run.py --inputs path/to/inputs.json --out-dir /tmp/ltv-cac ``` ## Step 3: KPIs the user gets **Verdict sheet (the headline)** - **Skok basic L