B.Using the data in the Chase addendum provided and assuming a 3 year planning period.

Calculate the Segment Level CLV you can expect for each segment if you keep the investments to acquire and retain customers constant at the same % they are in the current period (Year 1). Assume a 3 year planning period for your calculation.

Excel File Edit View Insert Format Tools Data Window Help 96% Fri 8:39 PM Q = ... Chase addendum Spring 2021 Q Search Sheet M Inbc Home Home Insert Draw Page Layout Formulas Data Review View + Share ~ C Arial A- A Wrap Text Accounting Paste Apps iClou Paste B I UV KELLE Merge & Center $ 7 % 2 08 0 Conditional Format Cell Insert Delete Format Sort & Find & Fall/20 Andrew Kruger Formatting as Table Styles Filter H12 fx Google B C D E F G H M N O P Q Transactors Revolvers Contact Cost 50.00 $ 50.00 Grizzly X-ray graphs 51 Response Rate 5 0% 4.0% Acquisition Cost (contact 6 cost/response rate) $ 1,000.00 $ 1,250.00 8 Revenue 9 Annual Spend $ 20,000.00 $ 10,000.00 Internship/ 10 Percent of Balance Not paid off 2.5% 50.0% CareerLeader resumes Interest Rate on Balance not paid off 20.5% 20.5% 12 Interchange Fee on Spend 1.5% 1.5% 13 Ar Annual Card Fee 95.00 $ 14 Annual Unit Revenue 497.50 1,270.00 Unit Cost of Goods Sold (25% GSM-5109 16 of Annual Revenue) $ 124.38 $ 317.50 GSM-5112 Annual Margin Before Marketing $ 373.13 $ 952.50 18 Marketing Retention Costs as 19 % of Annual Revenue 4.5% 4.5% (includes perks, points GSM-630 GSM-5114 20 customer service) 22 Retention Rate 85.0% 75.0% 23 Discount Rate 10.0% 24 Forecast Years of Retention number of years of customer 25 life ) NWNICU GSM-5107 26 Market Segment Size 7 (assuming 75 million cards) 26,250,000 33,750,000 Market Segment Growth Rate 5% 4% Current Market Share (cards) 3.50% 2.5% GSM-IKEW Ikew XLSX XLSX Practice Exercise Bethesda.xIsx P14 P15 (2).xIsx Midterm 2 Spring Practice Exercise 2021 P14 P15 .xIsx free-clv-templ Segment Info + Page 5 Ready 100% 26 "tv 4 7 x P N W R