Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

will upvote for fast correct answer C-Spire Communications, a cellalar comrsanications provider based in Mississippi, charges $79 per month for as unlimited service plan. The

will upvote for fast correct answer image text in transcribed
C-Spire Communications, a cellalar comrsanications provider based in Mississippi, charges $79 per month for as unlimited service plan. The company wasts to determine Customer Lifetime Value (CLV). Variable costs per account are $30 and monthly retention marketing expenditures are $6 per account. C.Spire has a custoence retention rate of 84%. The discount rate used to project present value of future profis is 10%. 11. Calculate the current Customer Lifetime Value for C-Spire Commanications. Calculate in cell M11, (2 points) 12. In a guest to boost long -term profits, C-Spire's ditector of matketing is considering two approaches: - Increase monthly price to 585 - Imperve customer service in an effort to increase retention rate from 84% so 87.5%. Caloulas CLV for each approach being considered. For each caloulation enly chaege the focal variable (revenae of retention rate). Hold all cher variables constant froen the original scenario. Calculate in cells M16 and M18. (2 points) 13. Which approach should C-Spire Corrmunications make a focus for increasing CLV? Why? Enter answer in space below. (2 points) Moathly nate Costs per account Retention Rate Discount Rate CLV Increase retention rate 579 $36 84% 10% Inerease revenue Q13

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Walter T. Harrison Jr., Charles T. Horngren, C. William Thomas, W. Morley Lemon, Catherine Seguin, Sandra Robertson Lemon

4th Canadian Edition

0131384333, 9780131384330

More Books

Students also viewed these Accounting questions