For example: A Rogers cable customer costs $450 to acquire and generates a yearly profit of $1,450. The retention rate is 60% but the average lifetime of a customer is 10 years. Calculate the Customer Lifetime Value (CLV) using a 15% discount Rate Procedure Use the Customer Lifetime Value spreadsheet to perform your calculations. All you have to do is plug in the numbers from the example above When finished, input your vales in the table below Question: Answer: Yearly Profit Retention Rate Discount Rate Acquisition Cost Lifetime in Years Customer Lifetime Value 2 2 2 2 2 2