Profitability Cohort Margin & LTV Analyzer

Formula

LTV = Σ(Monthly Revenue × Retention Rate × Margin %); LTV:CAC Ratio = LTV / Customer Acquisition Cost; Payback = CAC / Monthly Profit

Customer lifetime value is calculated by summing revenue across customer lifespan, adjusted for retention decay and margin. For cohort: track actual cumulative revenue over 12-24 months, multiply by margin to get profit, divide by cohort size for per-customer LTV. LTV:CAC ratio compares customer value to acquisition cost—higher is better, 3:1 target. Payback period divides CAC by monthly profit, showing months to recover acquisition investment. Example: 1,000 customer cohort, $50K acquisition ($50 CAC), generate $600K revenue over 24 months ($600 LTV), 60% margin = $360K profit. LTV:CAC = $360/$50 = 7.2:1 (excellent). If monthly profit = $20/customer, payback = $50/$20 = 2.5 months. These formulas work because they connect investment (CAC) to return (LTV) over time, accounting for churn (retention curve shows customer decay) and profitability (margin, not just revenue). The time dimension is critical—$500 LTV in 1 month is different from $500 over 5 years (time value of money, cash flow).

Worked Examples

Example 1: SaaS Cohort LTV Analysis

Problem:1,000 customers acquired at $50 CAC. Monthly subscription $100, 60% margin, 90% monthly retention, 100% pay monthly (subscription model). Calculate LTV and payback.

Solution:Subscription Model: - Cohort: 1,000 customers - CAC: $50/customer - Monthly fee: $100 - Margin: 60% - Monthly profit/customer: $60 - Monthly retention: 90% Month-by-Month: M1: 1,000 × $100 × 60% = $60,000 profit M2: 900 × $100 × 60% = $54,000 M3: 810 × $100 × 60% = $48,600 ... M12: 1,000 × 0.9^12 = 282 × $60 = $16,920 Cumulative: - M12 cumulative profit: ~$465K - Per customer: $465 - CAC: $50 - Net profit/customer: $415 - LTV:CAC: $465 / $50 = 9.3:1 (excellent) Payback Period: - Profit/month: $60 - CAC: $50 - Payback: $50 / $60 < 1 month (immediate) 24-Month LTV: - Retention at M24: 0.9^24 = 10% - Cumulative: ~$650/customer - LTV:CAC: 13:1 (world-class) Conclusion: - Unit economics are excellent - Payback <1 month (can scale aggressively) - LTV:CAC 9:1 suggests can increase CAC 3× and

Result:LTV:CAC 9.3:1 (excellent) | Payback <1 month | Can 3× CAC and still hit 3:1 target | Scale aggressively

Frequently Asked Questions

What is cohort profitability analysis?

Cohort analysis tracks group of customers acquired in same period (e.g., January 2024 cohort) through their lifecycle. Measures: retention rates, revenue per cohort, cumulative profit. Unlike aggregate metrics (all customers mixed), cohorts reveal: when profitability happens, retention curves, LTV trends. Example: January cohort 1,000 customers, Month 1 revenue $100K, Month 12 $30K (retention degraded). Calculate LTV, payback period, and long-term profitability per cohort.

What is LTV:CAC ratio and why does it matter?

LTV:CAC = Customer Lifetime Value / Customer Acquisition Cost. Measures payback on acquisition. Target: 3:1 (every $1 spent acquiring returns $3 in lifetime value). Example: CAC $100, LTV $300 → 3:1 (healthy). Below 1:1 = losing money on each customer. 1-2:1 = payback but tight. 2-3:1 = acceptable. >3:1 = excellent (or underinvesting in growth—could spend more on acquisition profitably). VCs use this to assess SaaS health.

How do I calculate customer lifetime value (LTV)?

LTV = Avg Order Value × Purchase Frequency × Margin % × Avg Customer Lifespan. Example: $50 AOV, 3 purchases/year, 40% margin, 4 year lifespan = $50 × 3 × 0.4 × 4 = $240. Subscription: LTV = Monthly fee × Margin % × (1 / Monthly churn rate). Example: $100/month, 70% margin, 5% churn = $100 × 0.7 / 0.05 = $1,400. Cohort method (more accurate): Track actual cohort cumulative revenue over time.

What causes cohort profitability to vary?

Cohorts differ by: (1) Acquisition channel (paid ads vs. organic have different CAC and quality), (2) Seasonality (holiday shoppers may have lower retention), (3) Product changes (feature launches improve retention), (4) Market conditions (recession cohorts churn more), (5) Targeting (improved ICP targeting increases LTV). Compare cohorts to identify: which acquisition sources have best LTV:CAC? Which product versions retain best? Optimize acquisition toward high-LTV cohorts.

Should I optimize for LTV or CAC?

Both. High LTV with high CAC may be unprofitable (LTV $500, CAC $400 = $100 profit but long payback). Low LTV with low CAC can be profitable (LTV $50, CAC $10 = $40 profit). Optimize: (1) Increase LTV (retention, upsells, cross-sells), (2) Reduce CAC (organic, referrals, conversion optimization), (3) Balance both (if LTV:CAC is 2:1, can afford higher CAC to grow faster). Context: Growth stage = tolerate higher CAC; mature = focus on efficiency.

What is the difference between gross and net margin?

Gross margin = (Revenue - COGS) / Revenue. COGS: direct costs (product, shipping). Net margin = (Revenue - All costs including opex) / Revenue. LTV calculations typically use gross margin (customer-level economics). Net margin includes: salaries, rent, marketing (not attributable to individual customer). Example: $100 sale, $40 COGS = 60% gross margin. But $30 opex → 30% net margin. Use gross margin for LTV; net margin for company profitability.

How long should I track cohorts?

Depends on customer lifecycle. Subscription: 24-36 months (see full churn curve). E-commerce: 12-18 months (most repurchase behavior visible). B2B contracts: Contract length + renewal (12 months for annual contracts). Don't need lifetime data—use cohort trends to extrapolate. Example: Month 12 retention 40%, Month 24 retention 30%. Extrapolate: stabilizes around 25%. Forecast LTV from stabilized retention.

What is blended LTV and when should I use it?

Blended LTV = Weighted average LTV across acquisition channels. Example: Organic LTV $200 (50% of customers), Paid LTV $120 (50%). Blended: ($200 + $120) / 2 = $160. Use blended for: Overall company economics, board reporting, high-level planning. Use channel-specific LTV for: Budget allocation (spend more on high-LTV channels), optimization (improve low-LTV channels), forecasting. Don't mask channel differences with blended average—lose actionable insight.

What cohort retention rate is healthy?

Varies by business model. SaaS: Month 1→2 retention 90-95%, Month 12 retention 50-70%. E-commerce: Month 1→2 purchase 20-30%, Month 12 purchase 10-15%. Consumer apps: Day 1 retention 40%, Day 30 retention 10-20%. Compare to industry benchmarks. Improving retention compounds: 90% vs. 95% monthly retention → Month 12: 28% vs. 54% retained (2× difference). Focus on: First 30-90 days (onboarding critical), then ongoing value delivery.

What is the difference between markup and margin?

Markup is the percentage added to cost to get the selling price: Markup = (Price - Cost) / Cost. Margin is the percentage of the selling price that is profit: Margin = (Price - Cost) / Price. A 50% markup on a 10 dollar item sets the price at 15 dollars, but the margin is 33.3%. Margin is always lower than markup for the same product.

Background & Theory

Profitability cohort margin and LTV analysis tracks customer groups through lifecycle to calculate lifetime value, payback periods, and unit economics, enabling acquisition budget optimization and identification of profitable vs. unprofitable customer segments. ## Concept Overview Cohort analysis answers: Are customers profitable and when? Track 1,000 customers acquired in January through their lifecycle. Month 1: Pay $50K CAC, generate $30K revenue (60% margin = $18K profit), cumulative profit = -$32K. Month 3: Cumulative $60K revenue, $36K profit, total -$14K. Month 6: Break even. Month 12: +$50K cumulative profit. Month 24: +$120K ($120 profit per customer, LTV:CAC = 120/50 = 2.4:1). This reveals: (1) Payback period (6 months), (2) LTV at different time horizons ($60 at 12 months, $120 at 24 months), (3) Retention curve (how many remain active), (4) Whether cohort is profitable (yes, eventually). Compare across cohorts: June cohort has 3-month payback (better onboarding), December cohort has 9-month payback (holiday shoppers have lower LTV). Strategic implication: If LTV:CAC is 4:1, you can afford higher CAC to accelerate growth. If 1.5:1, focus on retention and efficiency before scaling acquisition. Cohort analysis prevents growth-at-all-costs disasters where burning cash for unprofitable customers. ## Key Variables & Intuition • **Cohort Size** — Number of customers acquired in period; denominator for per-customer metrics • **CAC** — Customer acquisition cost; upfront investment to recover • **Avg Order Value** — Revenue per transaction; determines LTV numerator • **Gross Margin %** — Profit per dollar of revenue; applies to LTV calculation • **Monthly Retention** — % remaining active each month; compounds over time (90%^12 = 28% year 1 retention) • **Repeat Purchase Rate** — How often customers buy (subscription = 100%, e-commerce = 10-40%) ## Assumptions • Cohort is representative (seasonality, market conditions) • Retention rates are stable (product/market conditions don't radically change) • Margin % is consistent (no major cost structure changes) • Revenue comes from core product (not one-time bonuses or irregular events) • Acquisition channel is sustainable (CAC doesn't inflate 3× as you scale) ## Limitations & Edge Cases • **Small cohorts** — <100 customers = noisy data; need larger sample for statistical reliability • **Long sales cycles** — B2B enterprise may take 6-12 months to first purchase; cohort tracking starts later • **Network effects** — Platform value grows with users; early cohorts may have lower LTV (before network effects kicked in) • **Seasonal businesses** — Cohorts acquired in peak season behave differently than off-peak • **Product changes** — Major feature launches or pivots create discontinuity (pre/post cohorts not comparable) **Scenario:** A DTC brand acquires two cohorts: Organic (CAC $20, 12-month LTV $150, retention 80%) and Paid Social (CAC $80, 12-month LTV $100, retention 60%). Blended metrics: CAC $50, LTV $125, LTV:CAC 2.5:1 (seems healthy). But disaggregated: Organic 7.5:1 (amazing), Paid 1.25:1 (barely profitable). Decision: Scale organic (content, SEO, referrals), reduce paid social (unprofitable). Blended metrics would hide that paid social is burning cash. Lesson: Always segment cohorts by acquisition channel. ## Interpretation Guide **LTV:CAC Ratio:** - >4:1: Excellent (underinvesting in growth) - 3-4:1: Great (healthy balance) - 2-3:1: Good (break-even+ acceptable) - 1-2:1: Fair (tight; improve retention) - <1:1: Unprofitable (losing money on customers) **Payback Period:** - <6 months: Excellent (fast cash recovery) - 6-12 months: Good (standard for SaaS) - 12-18 months: Acceptable (longer but manageable) - >18 months: Slow (cash flow challenge) **Monthly Retention:** - >95%: Excellent (sticky product) - 90-95%: Good (standard for SaaS) - 85-90%: Fair (needs improvement) - <85%: Poor (churn problem) ## Practical Tips • **Track cohorts from Day 1** — Don't wait until "enough customers"; start with first 100 • **Segment by channel** — Organic, paid, referral have different economics; analyze separately • **Focus on early months** — Month 1-3 retention predicts long-term; optimize onboarding • **Calculate at multiple horizons** — 6-month, 12-month, 24-month LTV (understand trajectory) • **Compare to benchmarks** — SaaS LTV:CAC averages 3:1; yours is 2:1 = room for improvement • **Use for budget setting** — LTV $300, target 3:1 → max CAC $100 → monthly acquisition budget • **Trend matters** — Are cohorts improving (product getting better) or degrading (market saturating)? ## Common Mistakes • **Using blended LTV** — Hiding channel differences; some channels may be unprofitable • **Not tracking payback** — LTV looks good but 24-month payback creates cash crisis • **Ignoring cohort size** — Small cohorts (<50) have high variance; conclusions may be noise • **Extrapolating too early** — Month 3 data doesn't reliably predict Month 24 LTV; wait for trends • **No retention curve** — Just calculating total LTV without understanding when customers churn • **Optimistic churn** — Assuming retention plateaus at 70%; often decays to 20-30% eventually ## When NOT to Focus on Cohort LTV • **Pre-product-market fit** — Focus on user feedback and iteration; premature to optimize economics • **One-time sale businesses** — No repeat purchases; customer value = single transaction margin • **Long-term contracts** — If customers locked in 3-year agreements, monthly cohort tracking is overkill • **Very early stage** — <1,000 customers; cohorts are too small for reliable analysis

History

Cohort profitability analysis evolved from aggregate customer metrics to time-based cohort tracking as subscription businesses discovered that average LTV masked huge variation across acquisition periods and that understanding when customers became profitable enabled growth investment optimization. ## Origins & Why It Emerged Traditional businesses (retail, manufacturing) measured annual profitability: total revenue - total costs. Customer-level economics weren't tracked—too complex pre-digital. Loyalty programs (airlines, 1980s) began tracking individual customer value but didn't segment by acquisition cohort. The subscription revolution (SaaS, 2000s-2010s) made cohort analysis critical. Unlike one-time sales, subscriptions accumulate value over time. A $10/month customer seems low-value Month 1 but may generate $500 over 4 years. The question became: When does a customer become profitable? How does this vary by acquisition month? Early SaaS companies reported vanity metrics: total users, total revenue. Investors learned these were misleading. A company with 10,000 users and $1M revenue could be healthy (high retention, profitable cohorts) or dying (high churn, unprofitable cohorts). Cohort analysis revealed truth: are customers staying and generating profit? ## How It Evolved in Practice 2000s: SaaS companies (Salesforce, Constant Contact) started tracking monthly cohorts manually in spreadsheets. Insight: customers acquired in January had different retention than those acquired in June (seasonality, product iteration, market maturity). 2010s: Analytics tools (Mixpanel, Amplitude, ChartMogul) automated cohort analysis. The standard metrics emerged: Month 1 retention, Month 6 retention, Month 12 retention, cumulative revenue, payback period, LTV:CAC. VCs demanded these in diligence. The practice matured: Companies learned growth at all costs (high CAC, negative LTV) was unsustainable. The "growth with profitability" era began. Cohorts enabled balancing: some cohorts (organic, high LTV) fund growth of experimental cohorts (paid, learning LTV). ## Modern Usage Today Modern subscription businesses review cohorts monthly: compare new cohorts to historical (improving or degrading?), track retention curves, calculate payback, and set CAC targets based on LTV. Cohort analysis is standard in board decks—investors demand it. ## Common Misconceptions Historically • **"Overall LTV is sufficient"** — Blended LTV hides channel differences; some cohorts may be unprofitable • **"LTV is static"** — Product improvements, retention initiatives change LTV; track trends • **"Payback doesn't matter if LTV is good"** — Long payback (>18 months) strains cash flow even if eventual profit is positive • **"All cohorts should be identical"** — Seasonal, market, and product variations create natural cohort differences