Netflix charges $$20$ per month and one of its pricing plans. Based on this monthly fee we have already laid out the main profit each year for an average customer in the table below. Calculate the CLV per customer in D$6$ based on a $20$ year horizon and convert it to the beginning of the year in D$7.$ The number you have reached in cell D$7$ will depend on three inputs: monthly fee $($B$6),$ retention rate $($B$7),$ and interest rate $($B$8).$ Use the table on the right to examine how the converted CLV in cell D$7$ varies with retention rate and monthly fee $($use the excel "data table" function$)$

Transcribed Image Text:

5 1 6 Monthly Fee 7 Retention Rate 8 Interest Rate 9 10 Year 11 0.10 Mean Profit (if still here) $20 CLV per customer 0.89 Converting into beginning of the year Number ($60.00) 12 2 $80.00 13 3 $80.00 14 4 $80.00 15 5 $80.00 16 6 $80.00 17 7 $80.00 18 8 $80.00 19 9 $80.00 20 10 $80.00 21 11 $80.00 22 12 $80.00 23 13 $80.00 24 14 $80.00 25 15 $80.00 26 16 $80.00 27 17 $80.00 28 18 $80.00 29 19 $80.00 30 20 $80.00 31 Monthly Fee $ 8 $ 10 $ 12 $ 14 $ 16 $ 18 $ 20 $ 22 $ 24 $ 26 $ 28 0.6 0.65 Profit 0.7 100 Retention Rate 0.75 0.8 0.85 0.9 5 1 6 Monthly Fee 7 Retention Rate 8 Interest Rate 9 10 Year 11 0.10 Mean Profit (if still here) $20 CLV per customer 0.89 Converting into beginning of the year Number ($60.00) 12 2 $80.00 13 3 $80.00 14 4 $80.00 15 5 $80.00 16 6 $80.00 17 7 $80.00 18 8 $80.00 19 9 $80.00 20 10 $80.00 21 11 $80.00 22 12 $80.00 23 13 $80.00 24 14 $80.00 25 15 $80.00 26 16 $80.00 27 17 $80.00 28 18 $80.00 29 19 $80.00 30 20 $80.00 31 Monthly Fee $ 8 $ 10 $ 12 $ 14 $ 16 $ 18 $ 20 $ 22 $ 24 $ 26 $ 28 0.6 0.65 Profit 0.7 100 Retention Rate 0.75 0.8 0.85 0.9