Please calculate net CLV

.

XYZ has determined that market dynamics will result in some annual variations in the numbers they had previously estimated. Deeper market research has revealed that the cost of acquiring a customer is estimated to be $2,000. Also, estimates over five years for the remaining customers at the end of each year with average revenues and cost for each customer are presented in the following table. Considering a discount rate of 15%, calculate the net CLV for XYZ Discount rate = 15% Year o Year 1 Year 2 Year 3 Year 4 Year 5 Number of Customers 200 150 120 90 72 54 5,000 5,000 5,500 5,500 6,000 Revenue Per Customer Variable Cost Per Customer 2,000 2,000 1,800 1,800 1,500 Enter your answer here XYZ has determined that market dynamics will result in some annual variations in the numbers they had previously estimated. Deeper market research has revealed that the cost of acquiring a customer is estimated to be $2,000. Also, estimates over five years for the remaining customers at the end of each year with average revenues and cost for each customer are presented in the following table. Considering a discount rate of 15%, calculate the net CLV for XYZ Discount rate = 15% Year o Year 1 Year 2 Year 3 Year 4 Year 5 Number of Customers 200 150 120 90 72 54 5,000 5,000 5,500 5,500 6,000 Revenue Per Customer Variable Cost Per Customer 2,000 2,000 1,800 1,800 1,500 Enter your answer here