Assume the annual retention rate for a cell phone subscriber is 70 percent and the customer generates $300 per year in profit. Assuming an annual discount rate of 8 percent, compute the value of a customer.
The value of the customer can be calculated by considering the profit they generate, retention rate, and the discount.
Value = Profit per year * retention rate * (1 - discount)
Value = 300 * 0.7 * (1 - 0.08) = 300 * 0.7 * 0.92 = 193.2
The value of a customer is $193.2.
Assume the annual retention rate for a cell phone subscriber is 70 percent and the customer...
A magazine company hired you to calculate the lifetime value of its subscribers. A subscriber pays for the whole year at the beginning of the subscription period. After each year the subscribers decide to either to pay for another year or to cancel the subscription. During a year, a subscriber receives magazines each week. On average, the profit (contribution margin) from each subscriber is $20 per year. The average yearly retention rate is 30%. The CFO of the company believes...
Assume that a customer shops at a local grocery store spending an average of $400 per week, resulting in a retail profit of $40 per week from this customer. Assuming the shopper visits the store all 52 weeks of the year, calculate the customer lifetime value if this shopper remains loyal over a 10-year life span. Also, assume a 8 percent annual interest rate and no initial cost to acquire the customer.
Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every two years (or every 0.5 year) for $50, when the gross margin on the drill averages 50 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Х Open spreadsheet Questions 1. What is the value of a loyal customer (VLC) if...
Q1: Using CLV to evaluate spending on customer acquisition and customer retention. Brushes & Buckets, a paint wholesaler, sells paint to professional painters. On average, each painter spends $38,333 per year on paint. The average gross margin for Brushes & Buckets is 35%, and it currently has $4.2 million of sales in this segment. The current retention rate of each painter is 80%, and the revenue per painter is stable over time. (Assume a 10% discount rate.) The marketing director...
Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every two years (or every 0.5 year) for $100, when the gross margin on the drill averages 30 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Questions 1. What is the value of a loyal customer (VLC) if...
Assume that a customer shops at a local grocery store spending an average of $200 a week, resulting a retailer profit of $10 each week from this customer. Assuming the shopper visits the store all 52 weeks of the year, calculate the customer lifetime value if this shopper remains loyal over a 10-year lifespan. Also assume a 5 percent annual interest rate and no initial cost to acquire the customer. Describe ways marketers can increase the lifetime value of a...
Use XNPV to value the following investment. Assume that the annual discount rate is 12 percent. (please provide excel work and functions) A B 1 Date Cash flow 2 30-Jun-07 -600 3 14-Feb-08 100 4 14-Feb-09 300 5 14-Feb-10 400 6 14-Feb-11 600 7 14-Feb-12 800 8 14-Feb-13 -1,900
The Phone Company has the following costs of producing and selling a cell phone assuming it produces and sells the normal volume of 100,000 of these cell phones per month: Per unit manufacturing cost Direct materials $50.00 Direct labor 10.00 Variable manufacturing overhead cost 40.00 Fixed manufacturing overhead cost 30.00 Per unit selling cost Variable 15.00 Fixed 10.00 Note that 100,000 (normal volume of production and sales) is...
The number of cell phone subscribers in a country in the years 2000-2005 was projected to follow the equation N(t)=39t + 72 million subscribers in year t (t = 0 represents January 2000). The average annual revenue per cell phone user was $350 in 2000. If we assume that due to competition the revenue per cell phone user decreases continuously at an annual rate of 20%, we can model the annual revenue as R(t) = 350(39t + 72)e^0.2t million dollars....
please show work Customer Lifetime Value (CLV) 1. An internet service provider (ISP) charges $19.95 per month. With an average of marketing spending of $6 per year for each customer, it's estimated that each month about 2% of customers leave ISP. Other variable costs are about $1.50 per account per month. The average upfront cost to acquire a customer is $34. What's the CLV of a customer at a discount rate of 5%? I 2. A credit card company has...