Verizon is known to spend $500 to acquire a new mobile phone subscriber and $100 per year to provide services for a customer on average. The average monthly churn rate of the industry is known as 2.5% and the interest rate (discount rate or IRR) per year is 1096. When an average customer pays $60 per month to Verizon for one s subscription, what is the CLV of the customer for the next three years? Fill out ALL cells in the table below. * Round a number to two decimal places if necessary, and pay special attention to positive (+) numbers and negative (-) numbers. Year o Year 1 Year 2 Year 3 2020 2021 2022 2023 (1) Revenue (Gross Margin) 0 720 (2) Total marketing costs - Acquisition Cost 0 0 Maintenance Cost 0 100 (3) Value #1 -500 620 |(4) Rentention rate 0.34 (5) Value #2 303.8 210.8 (6) Discount factor 0.75 (7) Present Value (8) CLV for the next 3 years Verizon is known to spend $500 to acquire a new mobile phone subscriber and $100 per year to provide services for a customer on average. The average monthly churn rate of the industry is known as 2.5% and the interest rate (discount rate or IRR) per year is 1096. When an average customer pays $60 per month to Verizon for one s subscription, what is the CLV of the customer for the next three years? Fill out ALL cells in the table below. * Round a number to two decimal places if necessary, and pay special attention to positive (+) numbers and negative (-) numbers. Year o Year 1 Year 2 Year 3 2020 2021 2022 2023 (1) Revenue (Gross Margin) 0 720 (2) Total marketing costs - Acquisition Cost 0 0 Maintenance Cost 0 100 (3) Value #1 -500 620 |(4) Rentention rate 0.34 (5) Value #2 303.8 210.8 (6) Discount factor 0.75 (7) Present Value (8) CLV for the next 3 years