The iSharp Inc., a web-based consumer electronics direct marketing company, has acquired 15,000 new customers last year. 

iSharp spent $180,000 for acquiring those new customers and the average purchase per customer is $120. 

Assume that the proportion of variable cost is 55% of the revenue.  Given the 12% discount rate and 35% retention rate, you can obtain the customer lifetime value of an average customer in Year 1.

From Year 2, we assume that:

Retention rate will increase by 6% each year.

Average purchase will increase by 7% each year.

Variable costs will decrease by 8% each year.

Complete the 4-year CLV sheet in Q4_CLV.

CLV Year 1: $42

CLV Year 2: _____ ____

CLV Year 3: ____ _____

CLV Year 4: ____ _____