Skip to main content

Profitability Cohort Margin & LTV Analyzer

Analyze customer cohort profitability, calculate lifetime value, payback periods, and LTV:CAC ratios.

Share this calculator

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:\n- Cohort: 1,000 customers\n- CAC: $50/customer\n- Monthly fee: $100\n- Margin: 60%\n- Monthly profit/customer: $60\n- Monthly retention: 90%\n\nMonth-by-Month:\nM1: 1,000 × $100 × 60% = $60,000 profit\nM2: 900 × $100 × 60% = $54,000\nM3: 810 × $100 × 60% = $48,600\n...\nM12: 1,000 × 0.9^12 = 282 × $60 = $16,920\n\nCumulative:\n- M12 cumulative profit: ~$465K\n- Per customer: $465\n- CAC: $50\n- Net profit/customer: $415\n- LTV:CAC: $465 / $50 = 9.3:1 (excellent)\n\nPayback Period:\n- Profit/month: $60\n- CAC: $50\n- Payback: $50 / $60 < 1 month (immediate)\n\n24-Month LTV:\n- Retention at M24: 0.9^24 = 10%\n- Cumulative: ~$650/customer\n- LTV:CAC: 13:1 (world-class)\n\nConclusion:\n- Unit economics are excellent\n- Payback <1 month (can scale aggressively)\n- LTV:CAC 9

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.

Background & Theory

The Profitability Cohort Margin & LTV Analyzer applies the following established principles and formulas. Break-even analysis identifies the sales volume at which total revenue equals total costs, producing neither profit nor loss. The formula divides total fixed costs by the contribution margin per unit, where contribution margin equals selling price minus variable cost per unit. If a software product has $50,000 in monthly fixed costs and each licence generates $20 above its variable cost, break-even requires 2,500 unit sales per month. Above that threshold, each additional unit contributes directly to profit. Gross margin expresses the percentage of revenue remaining after direct cost of goods sold: gross margin equals revenue minus COGS, divided by revenue. A SaaS company with 80 percent gross margins retains $0.80 of every revenue dollar to cover operating expenses, while a manufacturer with 30 percent gross margins faces much tighter operating leverage. Customer acquisition cost (CAC) divides total sales and marketing expenditure in a period by the number of new customers acquired in that same period. Customer lifetime value (LTV) estimates the total profit attributable to a customer relationship. The standard formula multiplies average revenue per user (ARPU) by gross margin and divides by the monthly churn rate. A business with $50 ARPU, 75 percent gross margin, and 2 percent monthly churn has an LTV of $1,875. The LTV:CAC ratio benchmarks unit economics health; a ratio above 3:1 is generally considered sustainable, while ratios below 1:1 indicate the business is acquiring customers at a loss. Burn rate measures monthly cash expenditure net of revenue. Cash runway equals current cash reserves divided by net monthly burn. A company with $1.2 million in the bank burning $100,000 per month has twelve months of runway. The Rule of 40 is a benchmark for SaaS health: the sum of annual revenue growth rate (as a percentage) and profit margin (as a percentage) should equal or exceed 40. High-growth companies burning cash can still pass this rule if their growth rate compensates.

History

The history behind the Profitability Cohort Margin & LTV Analyzer traces back through the following developments. Early economic thought centred on mercantilism, the 16th and 17th century doctrine that national wealth derived from accumulating precious metals through export surpluses and colonial extraction. Adam Smith's "Wealth of Nations" in 1776 dismantled this framework, arguing that genuine prosperity arose from specialisation, division of labour, and freely operating markets. David Ricardo extended Smith's work with the theory of comparative advantage in 1817, demonstrating mathematically that mutually beneficial trade was possible even when one country was less productive in every industry. Alfred Marshall's "Principles of Economics" published in 1890 provided the modern framework of supply and demand curves, consumer surplus, price elasticity, and marginal analysis, establishing neoclassical economics as the dominant academic paradigm for decades. The Great Depression exposed the limits of laissez-faire assumptions, and John Maynard Keynes's "General Theory of Employment, Interest and Money" in 1936 argued that private-sector aggregate demand failures required countercyclical government fiscal intervention to restore full employment, shifting the policy consensus toward active macroeconomic management. The post-World War II decades constructed mixed-economy models combining market allocation with expanded welfare states and Keynesian demand management. Milton Friedman and the Chicago School challenged this consensus from the 1960s onward, championing monetarism and arguing that stable money supply growth was superior to discretionary fiscal policy. Their influence shaped the deregulatory and privatisation policies of the Reagan and Thatcher eras in the 1980s. Behavioural economics emerged through the work of Daniel Kahneman and Amos Tversky in the 1970s and Richard Thaler in the 1980s, using psychology to demonstrate that real human decision-making deviates systematically from rational-actor models through heuristics and biases. The rise of the internet and mobile platforms in the 2000s and 2010s created a new category of platform economics, where network effects, near-zero marginal cost of digital goods, and two-sided market dynamics generated winner-take-most competitive outcomes requiring new analytical frameworks for business valuation.

References