Skip to content
cccskills
Official · ClaudeFreePublished on GitHub

unit-economics

Analyze customer profitability and revenue durability for SaaS, subscription, and other recurring businesses. Examine acquisition costs, retention, and revenue trends by customer group, then produce an Excel workbook, summary slide, and issues for further investigation.

OriginalShow the original description

Analyze unit economics for PE targets — ARR cohorts, LTV/CAC, net retention, payback periods, revenue quality, and margin waterfall. Essential for software/SaaS, recurring revenue, and subscription businesses. Use when evaluating revenue quality, building a cohort analysis, or assessing customer economics. Triggers on "unit economics", "cohort analysis", "ARR analysis", "LTV CAC", "net retention", "revenue quality", or "customer economics".

See how to install

Good for

  • Assessing recurring revenue quality in an investment target
  • Tracking revenue by customer acquisition year
  • Comparing acquisition costs with customer lifetime value
  • Examining churn alongside revenue from existing customers

Files included (1)

  • SKILL.md4.1 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Unit Economics Analysis

Workflow

Step 1: Identify Business Model

Determine the revenue model to tailor the analysis:

  • SaaS / Subscription: ARR, net retention, cohorts
  • Recurring services: Contract value, renewal rates, upsell
  • Transaction / usage-based: Revenue per transaction, volume trends, take rate
  • Hybrid: Break down by revenue stream

Step 2: Core Metrics

ARR / Revenue Quality

  • ARR bridge: Beginning ARR → New → Expansion → Contraction → Churn → Ending ARR
  • ARR by cohort: Vintage analysis — how does each annual cohort retain and grow?
  • Revenue concentration: Top 10/20/50 customers as % of total
  • Revenue by type: Recurring vs. non-recurring vs. professional services
  • Contract structure: ACV distribution, multi-year %, auto-renewal %

Customer Economics

  • CAC (Customer Acquisition Cost): Total S&M spend / new customers acquired
  • LTV (Lifetime Value): (ARPU × Gross Margin) / Churn Rate
  • LTV:CAC ratio: Target >3x for healthy businesses
  • CAC payback period: Months to recover acquisition cost
  • Blended vs. segmented: Break down by customer segment (enterprise vs. SMB vs. mid-market)

Retention & Expansion

  • Gross retention: % of beginning ARR retained (excludes expansion)
  • Net retention (NDR): % of beginning ARR retained including expansion
  • Logo churn: % of customers lost
  • Dollar churn: % of revenue lost (often different from logo churn)
  • Expansion rate: Upsell + cross-sell as % of beginning ARR

Cohort Analysis

Build a cohort matrix showing:

CohortYear 0Year 1Year 2Year 3Year 4
2020$1.0M$1.1M$1.2M$1.1M
2021$1.5M$1.7M$1.8M
2022$2.0M$2.3M
2023$3.0M

Show both absolute $ and indexed (Year 0 = 100%) views.

Margin Waterfall

  • Revenue → Gross Profit → Contribution Margin → EBITDA
  • Fully loaded unit economics: what does it cost to acquire, serve, and retain a customer?
  • Gross margin by revenue stream (subscription vs. services vs. other)

Step 3: Benchmarking

Compare unit economics to relevant benchmarks:

  • SaaS Rule of 40: Growth rate + EBITDA margin > 40%
  • SaaS Magic Number: Net new ARR / prior period S&M spend > 0.75x
  • NDR benchmarks: Best-in-class >120%, good >110%, concerning <100%
  • LTV:CAC: Best-in-class >5x, good >3x, concerning <2x
  • Gross retention: Best-in-class >95%, good >90%, concerning <85%
  • CAC payback: Best-in-class <12mo, good <18mo, concerning >24mo

Step 4: Revenue Quality Score

Synthesize into a revenue quality assessment:

FactorScore (1-5)Notes
Recurring %
Net retention
Customer concentration
Cohort stability
Growth durability
Margin profile
Overall

Step 5: Output

  • Excel workbook with ARR bridge, cohort matrix, unit economics dashboard
  • Summary slide with key metrics and benchmarks
  • Red flags and areas for further diligence

Important Notes

  • Always ask for raw customer-level data if available — aggregate metrics can hide problems
  • NDR above 100% can mask high gross churn if expansion is strong enough — always show both
  • Cohort analysis is the single most important view for revenue quality — push for this data
  • Differentiate between contracted ARR and actual recognized revenue
  • For usage-based models, focus on consumption trends and expansion patterns rather than traditional ARR metrics
  • Professional services revenue should be evaluated separately — it's not recurring and margins are typically lower

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

3-statement-model

Official · ClaudeFreeSummary

Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.

  • Complete a partially filled financial model
  • Link forecasts across three financial statements
  • Check balance sheet and cash flow consistency
anthropics/financial-services40.7KUpdated Sep 22, 2026

accrual-schedule

Official · ClaudeFreeSummary

Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.

  • Preparing an accrual schedule for month-end close
  • Calculating audit fee, bonus, or utilities accruals
  • Drafting journal entries with supporting references
anthropics/financial-services40.7KUpdated Sep 22, 2026

ai-readiness

Official · ClaudeFreeSummary

Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.

  • Quarterly reviews of AI opportunities across portfolio companies
  • Prioritizing companies for AI investment and operational support
  • Finding ways to reuse successful AI projects across companies
anthropics/financial-services40.7KUpdated Sep 22, 2026

audit-xls

Official · ClaudeFreeSummary

Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.

  • Checking formulas in a selected range
  • Investigating a balance sheet that does not balance
  • Reviewing a financial model before client delivery
anthropics/financial-services40.7KUpdated Sep 22, 2026

bond-futures-basis

Official · ClaudeFreeSummary

Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.

  • Comparing bond futures with cash bond prices
  • Identifying the cheapest bond to deliver
  • Comparing implied financing rates with market rates
anthropics/financial-services40.7KUpdated Sep 22, 2026

bond-relative-value

Official · ClaudeFreeSummary

Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.

  • Comparing the relative value of candidate bonds
  • Separating credit risk from other yield differences
  • Estimating gains and losses under interest rate shifts
anthropics/financial-services40.7KUpdated Sep 22, 2026

See all skills by anthropics

Report a problem with this skill