Calculate the CLV based on the following assumptions Discount rate 6% - Acquisition cost $ 30 4 Retention costs $ 10 s Retention rate 80% 6 Average customer contribution $50 7 9 8 INPUTS: CUSTOMER LIFETIME VALUE 1 2 3 4 10 Discount rate 5.00% 11 Acquisition cost $ 25.00 12 Retention costs $ 15.00 $ 15.00 $ 15.00 13 Retention rate 90.00% 90.00% 90.00% 90.00% 14 Average customer contribution $ 100.00 $ 100.00 $ 100.00 $ 100.00 15 16 OUTPUTS 17 Cumulative retention 1. Net contribution 100.00% $ 75.00 90.00% 85.00 $ 81.00% 85.00 $ 72.90% 85.00 $ Sheet1 Calculate the CLV based on the following assumptions Discount rate 6% - Acquisition cost $ 30 4 Retention costs $ 10 s Retention rate 80% 6 Average customer contribution $50 7 9 8 INPUTS: CUSTOMER LIFETIME VALUE 1 2 3 4 10 Discount rate 5.00% 11 Acquisition cost $ 25.00 12 Retention costs $ 15.00 $ 15.00 $ 15.00 13 Retention rate 90.00% 90.00% 90.00% 90.00% 14 Average customer contribution $ 100.00 $ 100.00 $ 100.00 $ 100.00 15 16 OUTPUTS 17 Cumulative retention 1. Net contribution 100.00% $ 75.00 90.00% 85.00 $ 81.00% 85.00 $ 72.90% 85.00 $ Sheet1