Calculate the lifetime value of a comcast

Assignment Help Finance Basics
Reference no: EM132505953

Comcast, Inc. (the cable tv company) is trying to determine the Lifetime Value of its customers. Here are some facts related to Comcast customers:

- A study of historical sales data reveals that the average customer brings in about $2500 of sales revenues each year.

- A study of historical cost data reveals that the average cost to service and retain a customer is about $700 per year.

- Comcast spends about $500 to acquire a new customer, on average.

- Comcast retains approximately 75% of its customers from one year to the next.

- Comcast's discount rate is 7%.

a. Calculate the Lifetime Value of a Comcast customer using the infinite time horizon version of the CLV formula.

b. How does your answer to a. change if year-to-year customer retention drops to 50% (and everything else stays the same)?

c. What is the maximum amount Comcast can spend to acquire a customer and still maintain a positive Customer Lifetime Value (CLV)? (use the original assumptions above and ignore the fact that Comcast currently spends $500 to acquire a customer)

Reference no: EM132505953

Questions Cloud

Describe the ideas and stance on such issues : Network defense can be a tricky item to deal with; there are threats that reside both internal and external to a given organization. Hence, while there are.
What is an internal consultant : What is an internal consultant? How does an internal consultant differ from an external one and Kenton, Moody, & Taylor present a "new model" for internal
Find the break-even point in units will : Fixed costs are $40,000. If the sales price increases by $2 and all the other costs remain unchanged, the break-even point in units will
What annual rate of return did aunt mary earn : Your Aunt Mary recently, She found out that the painting is now worth $50,000. What annual rate of return did Aunt Mary earn on this painting?
Calculate the lifetime value of a comcast : Comcast, Inc. (the cable tv company) is trying to determine the Lifetime Value of its customers. Here are some facts related to Comcast customers:
What would be the value of the zero-coupon rate bond : If immediately upon issue, interest rates increased to 8 percent, what would be the value of the zero-coupon rate bond? (Assume annual compounding)
Discuss one principle of human-computer interface design : Security breaches threaten patient privacy when confidential health information is made available to others without the individual's consent or authorization.
Presentation on recruitment and selection procedures : Presentation on Recruitment and Selection Procedures in Mouchel Company - Two Interviews Regarding Selection and Recruitment Procedures
Maintain without resorting to additional equity issues : Its return on equity is 30%. What is the maximum possible dividend payout rate the firm can maintain without resorting to additional equity issues?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd