Calculation guide
For business owners exploring costs, cash flow or valuation scenarios.
Keep revenue, cost and time periods consistent. Profit margin divides by revenue; markup divides by cost. Discounted cash flows are scenario assumptions, and terminal growth must be below the discount rate. Payback uses linear interpolation within the recovery period. Customer lifetime value uses the entered finite horizon, retention, margin and discount assumptions. No valuation or business outcome is guaranteed.
Inputs
Revenue per period
Expected revenue from one active customer in each modeled period.
Gross margin
Share of revenue left after direct costs, before customer acquisition cost.
Periods
Number of equally spaced payment or forecast periods, not automatically years.
Retention
Share of customers expected to stay into the next period; the first period assumes an active customer.
Discount rate per period
Discount rate per modeled customer period, not necessarily per year.
Acquisition cost
One-off cost of gaining one customer, subtracted from discounted customer profit.
Worked example
| Input | Value |
|---|---|
| Revenue per period | 1,000 |
| Gross margin | 60% |
| Periods | 24 |
| Retention | 95% |
| Discount rate per period | 0% |
| Acquisition cost | 0 |
Formula:
CLV=Σ_{t=1}^N Revenue·Margin·Retention^(t−1)/(1+d)^t−CAC
Net lifetime value = 8496.13170793473
Period = 1.00000000000000; Expected revenue = 1000.00000000000; Profit present value = 600.000000000000; Net lifetime value = 600.000000000000
Period = 24.0000000000000; Expected revenue = 307.356867725024; Profit present value = 184.414120635014; Net lifetime value = 8496.13170793473
| Result | Value |
|---|---|
| Net lifetime value | 8,496.131708 |
| Gross profit present value | 8,496.131708 |
| Revenue present value | 14,160.219513 |
| Acquisition cost | 0 |
Interpreting the result
Discounted expected customer profit minus one-off acquisition cost.
Expected customer revenue multiplied by margin and discounted across the entered retention horizon.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Revenue per period | 1,000 | 1,100 | Net lifetime value | 8,496.131708 | 9,345.744879 |
| Gross margin | 60% | 66% | Net lifetime value | 8,496.131708 | 9,345.744879 |
| Periods | 24 | 26 | Net lifetime value | 8,496.131708 | 8,837.758866 |
| Retention | 95% | 85% | Net lifetime value | 8,496.131708 | 3,919.06913 |
| Discount rate per period | 0% | 1% | Net lifetime value | 8,496.131708 | 7,700.393349 |
| Acquisition cost | 0 | 1 | Net lifetime value | 8,496.131708 | 8,495.131708 |
