Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The CEO asks the chief marketing officer to compute customer lifetime value (CLV) for catalog customers and online customers. The following information pertains to the

image text in transcribed
image text in transcribed
The CEO asks the chief marketing officer to compute customer lifetime value (CLV) for catalog customers and online customers. The following information pertains to the company's operations in the online channel: Online Customer 102,500 new online customers were acquired in a year Average customer retentson rate is 63% Average length of the online customer relationship is five years Average online customer spends 554 per purchase Average online customer buys from the online store three times a you Cost of sales is 52% 07. What is Customer Lifetime Value for online customers? You will seed to construct the analysis in space below following the Starbucks example we wed in con which is the formula for CLV Duration of relationship. This problem must be computed using MS Excel points) 07 Customer Lifetime Value The one other assumption of the model is that the firm uses an infinite horizon when it calculates the present value of future cash flows. Although no firm actually has an infi: nite horizon, the consequences of assuming one are discussed in the following section Customer Lifetime Value: The CLV formula multiplies the per-period cash margin (hereafter we will just use the term margin") by a factor that represents the present value of the expected length of the customer relationship: Customer Lifetime Value ($) = Margin ($) Retention Rate (%) 1 + Discount Rate (%) - Retention Rate (%) a Under the assumptions of the model, CLV is a multiple of the margin. The multipli- cative factor represents the present value of the expected length (number of periods) of the customer relationship. When retention equals 0, the customer will never be retained, and the multiplicative factor is zero. When retention equals 1, the customer is always retained, and the firm receives the margin in perpetuity. The present value of the margin in perpetuity turns out to be Margin/Discount Rate. For retention values in between, the CLV formula tells us the appropriate multiplier

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

Interpreting Company Reports And Accounts

Authors: Geoffrey Holmes, Alan Sugden, Paul Gee

10th Edition

0273711415, 9780273711414

More Books

Students also viewed these Accounting questions

Question

2. Talk to other teachers or parents about ideas for reinforcers.

Answered: 1 week ago

Question

Is having a positive self-concept really all that important?

Answered: 1 week ago