How to Calculate NPV for Marketing Campaigns & Customer Lifetime Value
Modern marketing investments in customer acquisition yield recurring subscriptions and repeat purchases across years. Learn how to discount Customer Lifetime Value (LTV) against CAC using NPV.
Key Takeaways
- Single-quarter ROAS underestimates the true economic value of subscription and repeat customer cohorts.
- Marketing NPV = -Upfront Campaign CAC + Sum of Discounted Multi-Year Customer Gross Profit.
- Discount rates for marketing campaigns should reflect corporate cost of capital plus customer churn risk (typically 10%–15%).
1. Why Simple Marketing ROI Fails for Multi-Year Customer Journeys
Standard marketing Return on Ad Spend (ROAS) only measures immediate initial sales. For SaaS companies, D2C brands, and B2B enterprises with high customer retention, acquiring a customer generates recurring cash flows for 3 to 7 years.
Treating a $250,000 acquisition campaign as a single-period expense creates the illusion of a loss, when in reality the discounted cash flows over time produce exceptional long-term Net Present Value.
2. The Marketing NPV Formula
The formula for evaluating marketing acquisition cohorts is:
$$\text{NPV}_{\text{marketing}} = -\text{CAC} + \sum_{t=1}^n \frac{\text{Gross Profit}_t \times (\text{Retention Rate})^t}{(1 + r)^t}$$
Where: - $\text{CAC}$ = Total campaign budget and customer acquisition expenditure - $\text{Gross Profit}_t$ = Projected net contribution margin per customer cohort in year $t$ - $\text{Retention Rate}$ = Annual customer retention percentage (e.g. 80%) - $r$ = Corporate hurdle rate (e.g. 10%)
3. Worked Marketing Case Study: $250,000 B2B SaaS Campaign
A software company invests $250,000 in a targeted digital campaign, acquiring 200 annual subscribers paying $2,000/yr at an 80% gross margin ($1,600 gross profit per customer/yr = $320,000 Year 1). Assuming 80% annual retention and a 10% discount rate:
| Period (t) | Retained Customers | Nominal Gross Margin | Discount Factor (10%) | Present Value (PV) | Running Cumulative NPV |
|---|---|---|---|---|---|
| Period 0 | 0 (Campaign Ad Spend) | -$250,000 | 1.0000 | -$250,000 | -$250,000 |
| Period 1 | 200 Accounts (100%) | +$320,000 | 0.9091 | +$290,909 | +$40,909 (Payback 10.3 mo) |
| Period 2 | 160 Accounts (80%) | +$256,000 | 0.8264 | +$211,570 | +$252,479 |
| Period 3 | 128 Accounts (64%) | +$204,800 | 0.7513 | +$153,869 | +$406,348 |
| Period 4 | 102 Accounts (51.2%) | +$163,840 | 0.6830 | +$111,905 | +$518,253 |
| Period 5 | 82 Accounts (41%) | +$131,072 | 0.6209 | +$81,385 | +$599,638 (Final NPV) |
Calculate Net Present Value Live
Run your cash flows through our free, real-time Net Present Value calculator.