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?
-
Define each of the following terms, and explain the relationship among them: (a) Overhead cost distribution. (b) Service department cost allocation, and (c) Overhead application.
-
The total cost of producing x units for which the fixed costs are $2500 and the cost per unit is $40 Write an algebraic expression for the verbal description.
-
The compressive strength, in kilopascals, was measured for concrete blocks from five different batches of concrete, both three and six days after pouring. The data are as follows: Can you conclude...
-
Change to LIFO Retail Diderot Stores Inc., which uses the conventional retail inventory method, wishes to change to the LIFO retail method beginning with the accounting year ending December 31,...
-
Superior Markets, Incorporated Income Statement For the Quarter Ended September 3 0 Total North Store South Store East Store Sales $ 3 , 3 0 0 , 0 0 0 $ 7 9 2 , 0 0 0 $ 1 , 3 2 0 , 0 0 0 $ 1 , 1 8 8...
-
The paralegal is assigned the task of preparing an office legal memorandum. The memorandum is due in 10 days, and there is a 5-page limit. The facts and law are as follows: Facts: Mary was Tom's...
-
Volkswagen developed an 18-month-long project to gain a better understanding of the North American culture so it could develop cars more appealing to this market. The project was called Moonraker and...
-
Concepts & Connections 10.2 discusses Charleston Area Medical Centers use of Six Sigma practices. List three tangible benefits provided by the program. Explain why a commitment to quality control is...
-
Tommy has two loan alternatives: (1) \($700\),000 at a fixed rate of 4.00% for 25 years or (2) \($800\),000 at a fixed rate of 5.00% for 25 years. What is the incremental cost of borrowing (Must show...
-
If Grant pays \($5\),000/month instead of the minimum payment required, how many months will it take him to pay off a \($400\),000 mortgage at an interest rate of 3.0% for 30 years? (Must show HP-12C...
-
Apply the normal-latent beta model to data on short-term changes in depression ratings (Tarpey and Petkova, 2010). Such changes in depression are unlikely to be due to the pharmacological...
-
To become more skilled at interpreting meanings associated with nonverbal communication. INSTRUCTIONS Assume your boss exhibits each of the four behaviors listed below over the course of a month....
-
implement the RecursiveCrawler class in Java . import org.jsoup.Jsoup; import org.jsoup.nodes.Document; import org.jsoup.nodes.Element; import java.io.*; import java.util.*; public class...
-
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...
-
What three decisions must be made about substantive tests when they are designed?
-
The general framework of an audit includes all of the following steps except a. Planning the audit. b. Gathering the necessary evidence to form an opinion. c. Issuing a letter on controls to...
-
How does an auditor make a preliminary judgment about materiality during the planning phase?
Study smarter with the SolutionInn App