calculating customer lifetime value
TRANSCRIPT
![Page 1: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/1.jpg)
1
![Page 2: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/2.jpg)
Step 1: Calculate net sales per customer, M
Net sales = Sales - discounts, returns and allowances / total customers 2
![Page 3: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/3.jpg)
Step 2: Determine retention spending per customer, R
3
![Page 4: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/4.jpg)
Step 3: Subtract these two to get Contribution Margin per Customer
4
![Page 5: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/5.jpg)
Now perform the CLV calculation on a customer cohort acquired in a given
period (Month 1)
5
![Page 6: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/6.jpg)
Customers in Month 1 (24)
Multiply (M-R) by Total Customers in Month 1 to Get Total Net Profit:
6
![Page 7: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/7.jpg)
Now, factor in customer churn.
You will likely lose some customers between Period 1 and Period 2. The percentage of customers you keep is the retention rate. For each subsequent
period, we multiply customer count by the retention rate, like so:
7
![Page 8: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/8.jpg)
Customers in Month 2(0.8 * 24 = 19)
Assume a retention rate of 80%. Repeat calculation for Month 2.
8
![Page 9: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/9.jpg)
Repeat calculation for Month 3, again reducing customer population by retention rate.
Customers in Month 3(0.8 * 19 = 15)
9
![Page 10: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/10.jpg)
Remember what we’re doing here.
We’re calculating the present value of future cash flows from these customers. So we want to do this calculation for month after month after month, up to
infinity...like this:
10
![Page 11: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/11.jpg)
Month 1
Month 2
Month 3
Extend this calculation to infinity...
![Page 12: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/12.jpg)
The problem: That would take forever to do by hand.
So you use the following calculation, which takes Net Profit and Multiplies it by a long-term multiplier:
12
![Page 13: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/13.jpg)
Long-term multiplier(where d is discount rate and r is
retention rate
Contribution margin per customer
13
![Page 14: Calculating customer lifetime value](https://reader034.vdocuments.us/reader034/viewer/2022042611/58851c6f1a28abd05e8b79b1/html5/thumbnails/14.jpg)
14
There you have it.Read more about CLV at my blog, sandranoonan.com.