Phase V Tasks Accounting for the Lifetime Value of the Customer As before, suppose the firm...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Phase V Tasks Accounting for the Lifetime Value of the Customer As before, suppose the firm only offers the subscription plan consisting of NBC, CBS and ESPN on LG devices. Suppose also that it prices this plan at the rate you computed in Question 3 of Phase VI. Using other existing field data on consumers who have already adopted the service, you know that an existing customer has a 70% chance of defecting in any given month when you charge the price computed in Question 3 of Phase VI. Assume that you have 150,000 existing customers and that your total potential customers amount to 500,000, including the current existing customer base. From accounting, you also know that the cost of providing service to a customer is $8 per month. Moreover, the cost of contacting a prospective customer with an offer to sign up for the service is roughly $5. This "initial marketing contact" cost does not apply to existing customers. Finally, the firm's monthly borrowing cost of capital used to discount future revenues from a customer is 5% (i.e., the monthly discount factor is 1/(1+0.05)). 1) (6 points) What fraction (in percentage) of the prospective consumer market would you predict will adopt the service at this price? This fraction constitutes the probability that a randomly selected prospective customer adopts the service at the given price level. Round your answer to the nearest tenth. 2) (12 points) Build an LTV model and calculate the net present value of a prospective and an existing customer, respectively. Assume that an existing customer may terminate the subscription only at the beginning of the month and that a prospective customer may start the subscription only at the beginning of the month. Assume that all prospective customers are contacted once in the middle of the month. Round your answers to the nearest cent. Show your work. 3) (15 points) Recently, HBO has contacted your firm to negotiate a contract that would add HBO as part of the monthly subscription plan. The proposed contract would bill your firm an upfront one-time fixed payment of $50 million irrespective of the number of subscribers and a monthly payment of $2 per subscriber. Suppose you would continue to charge the price calculated in Question 3 of Phase VI even after adding HBO to the subscription. Would adding HBO to the subscription package be profitable in the long term? Show your work. Phase V Tasks Accounting for the Lifetime Value of the Customer As before, suppose the firm only offers the subscription plan consisting of NBC, CBS and ESPN on LG devices. Suppose also that it prices this plan at the rate you computed in Question 3 of Phase VI. Using other existing field data on consumers who have already adopted the service, you know that an existing customer has a 70% chance of defecting in any given month when you charge the price computed in Question 3 of Phase VI. Assume that you have 150,000 existing customers and that your total potential customers amount to 500,000, including the current existing customer base. From accounting, you also know that the cost of providing service to a customer is $8 per month. Moreover, the cost of contacting a prospective customer with an offer to sign up for the service is roughly $5. This "initial marketing contact" cost does not apply to existing customers. Finally, the firm's monthly borrowing cost of capital used to discount future revenues from a customer is 5% (i.e., the monthly discount factor is 1/(1+0.05)). 1) (6 points) What fraction (in percentage) of the prospective consumer market would you predict will adopt the service at this price? This fraction constitutes the probability that a randomly selected prospective customer adopts the service at the given price level. Round your answer to the nearest tenth. 2) (12 points) Build an LTV model and calculate the net present value of a prospective and an existing customer, respectively. Assume that an existing customer may terminate the subscription only at the beginning of the month and that a prospective customer may start the subscription only at the beginning of the month. Assume that all prospective customers are contacted once in the middle of the month. Round your answers to the nearest cent. Show your work. 3) (15 points) Recently, HBO has contacted your firm to negotiate a contract that would add HBO as part of the monthly subscription plan. The proposed contract would bill your firm an upfront one-time fixed payment of $50 million irrespective of the number of subscribers and a monthly payment of $2 per subscriber. Suppose you would continue to charge the price calculated in Question 3 of Phase VI even after adding HBO to the subscription. Would adding HBO to the subscription package be profitable in the long term? Show your work.
Expert Answer:
Answer rating: 100% (QA)
1A PVofrevenuefromexistingcustomers 150000 x 12 x 8 1005 1068667 PVofrevenuefromnewcustomers 500000 ... View the full answer
Related Book For
Customer Service Career Success Through Customer Loyalty
ISBN: 978-0133056259
6th edition
Authors: Paul R. Timm
Posted Date:
Students also viewed these marketing questions
-
To what does the lifetime value of the customer refer, and how is it calculated?
-
Why is determining the lifetime value of a customer an important analysis for a company to make?
-
1. Explain what the lifetime value of a customer is. 2. Explain tarrifs, GDP, foreign exchange rate, trade agreements, economic communities and common markets. 3. What are the different levels of...
-
what would you like to recommend to Australian government in regards to their fiscal stimulus policy for supporting covid affected society?
-
Zambelli is one of the oldest and largest fireworks companies in the United States, doing business in most states. Wood was hired by Zambelli in 2001 to work as a pyrotechnician and choreographer,...
-
An analyst uses quarterly data to study the relationship between retail sales (y, in $ millions), gross national product (x, in $ billions), and a dummy variable d that equals 1 if the sales are for...
-
Calculate \(|19|\).
-
You have just been hired as a loan officer at Fairfield State Bank. Your supervisor has given you a file containing a request from Hedrick Company, a manufacturer of auto components, for a $1,000,000...
-
11.24 Your ?rm, Webster & Willis, is the auditor of Dogs World Ltd for the year ended 30 June 2018. Dogs World manufactures products for dogs, including food, toys, beds, treats, out?ts and ke...
-
1. The clear majority of compute nodes in modern enterprise environments are networked. Can you think of any circumstances where a compute node would NOT be networked? Describe. 2. Many commercial...
-
1.Analysts expect Walmart to have earnings per share of $5.60 for the coming year (year 1). Walmart intends to invest heavily in its online platform in the near term and therefore plans to retain and...
-
(1). Discuss the need for religion/spirituality at the end of life AND some potential barriers to religious/spiritual care (2). Thoughtfully contemplate what spiritual or religious needs you might...
-
Question 3 Value of Risk Management. Suppose it is 2030, and Tesla is finally profitable. Suppose that their beta is 2.5, the risk-free rate of return is 2%, and the market rate of return is 7%....
-
BNSF Railway Company v. U.S. Dept. of Transportation 566 F. 3d 200; 2009 U.S. App LEXIS 10288 (U.S. Court of Appeals DC Circuit) The issue is whether requiring direct observation of urine testing of...
-
What factors have affected (and will continue to affect) the growth of health psychology? What were Freud's major psychological contributions to Health Psychology? Compare and contrast the...
-
After reading the LMDC and Multi-site reports, examine the issues related to inmate deaths occurring in the LMDC facilities. Then, find at least three (3) peer-reviewed articles that demonstrate...
-
Video Planet (VP) sells a big screen TV package consisting of a 60-inch plasma TV, a universal remote, and on-site installation by VP staff. The installation includes programming the remote to have...
-
The following exercises are not grouped by type. Solve each equation. x610x -9
-
Early one morning Harry found himself hungry, alone, and lost in the land of no customer service as he stumbled into a donut shop. It was a rainy, gray morning and he was tired. Cars were parked at...
-
Let's go back to the ongoing case you selected. This will be either your current employer, a specific organization you want to work in, or one of the two hypothetical organizations described in...
-
Bruno LeBron was recently assigned as the technology officer for a midsized, business-to-business (B2B) consulting firm. His company offered other businesses help with planning locations for new...
-
PCs are considered risk-free investments. This makes them appealing to investors who are looking for protection against inflation but who do not have a lot of money to invest. How would you interest...
-
Samantha inherited a diamond-and-ruby necklace from her grandmothers estate. Unfortunately, the settings for the stones are damaged beyond repair. Samantha is trying to decide what to do with her...
-
Compare and contrast direct and indirect real estate investments.
Study smarter with the SolutionInn App