1.Given the following inputs, create a three year subscriber LTV table for a company. What is the third year LTV? Year 1 data: Subscribers 600,000; Unsub Rate 85; Undeliver rate 7%; Delivered e-mails 62,400,000 Open rate 11%; Unique click rate 19%; e-mail conversion rate (of clicks) 3%; Off e-mail multiplier 4.00; Average order value: $61.47; Cost rate 40%; acquisition cost each $0.12; E-mail sending CPM $5.00; e-mail creation CPM $3.00 ; Database maintenance $1 per subscriber; Discount rates: 1, 1.1, 1.21