30 Tuscan Lifestyles LTV 31 Initial Order >$50 32 33 REVENUES 34 Number of Initial Customers...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
30 Tuscan Lifestyles LTV 31 Initial Order >$50 32 33 REVENUES 34 Number of Initial Customers 35 Number Ordering Customers 36 Response Rate 37 Retention Rate 38 Number of Orders 39 Average Order Size 40 Revenues 41 42 COSTS 43 COGS (rough %) 44 COGS ($) 45 Acquisition Costs 46 Maintenance Mailing Costs 47 TOTAL COSTS 48 49 GROSS PROFIT 50 Gross Profit 51 Discount rate applied NPV 52 53 Cumulative NPV 54 55 LIFETIME VALUE (First purchase) Year 1 3296 3296 2.30% 1 3296 $95.55 58% (5 years ago) Year 2 3296 3296 727 608 ΝΑ ΝΑ 1 ΝΑ 3416 2383 1185 952 792 93.02 84.02 77.75 70.61 78.26 $314,932.80 317756.3 200219.7 92133.75 67220.72 61981.92 $0 1 3296 2825 ΝΑ 1 Year 3 1.06 3296 1633 Year 4 ΝΑ 1 58% 58% 58% 58% $182,661.02 184298.7 116127.4 53437.58 38988.02 $0 $0 $0 $0 Year 5 3296 826 ΝΑ 1 Year 6 58% 35949.51 $0 1. What is the LTV over five years for customers who initially spend less than $50? 2. What is the LTV over five years for customers who initially spend $50 or more? 3. Based on your findings, which group of customers has higher LTV? 4. Since when has the higher LTV group of customers become profitable? 5. Should you keep sending catalogs to the lower LTV group of customers? Why or why not? 6. Hand in your CLV chart for each group. 30 Tuscan Lifestyles LTV 31 Initial Order >$50 32 33 REVENUES 34 Number of Initial Customers 35 Number Ordering Customers 36 Response Rate 37 Retention Rate 38 Number of Orders 39 Average Order Size 40 Revenues 41 42 COSTS 43 COGS (rough %) 44 COGS ($) 45 Acquisition Costs 46 Maintenance Mailing Costs 47 TOTAL COSTS 48 49 GROSS PROFIT 50 Gross Profit 51 Discount rate applied NPV 52 53 Cumulative NPV 54 55 LIFETIME VALUE (First purchase) Year 1 3296 3296 2.30% 1 3296 $95.55 58% (5 years ago) Year 2 3296 3296 727 608 ΝΑ ΝΑ 1 ΝΑ 3416 2383 1185 952 792 93.02 84.02 77.75 70.61 78.26 $314,932.80 317756.3 200219.7 92133.75 67220.72 61981.92 $0 1 3296 2825 ΝΑ 1 Year 3 1.06 3296 1633 Year 4 ΝΑ 1 58% 58% 58% 58% $182,661.02 184298.7 116127.4 53437.58 38988.02 $0 $0 $0 $0 Year 5 3296 826 ΝΑ 1 Year 6 58% 35949.51 $0 1. What is the LTV over five years for customers who initially spend less than $50? 2. What is the LTV over five years for customers who initially spend $50 or more? 3. Based on your findings, which group of customers has higher LTV? 4. Since when has the higher LTV group of customers become profitable? 5. Should you keep sending catalogs to the lower LTV group of customers? Why or why not? 6. Hand in your CLV chart for each group.
Expert Answer:
Answer rating: 100% (QA)
To answer these questions wed need to analyze data for both groups of customers those who initially ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
List A and List B each contains 30 numbers. Frequency distributions for each list are recorded in the histograms below. The average (arithmetic mean) of the numbers in list A is 3.7, and the average...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
On January 1, 2018, Rastall Co. signed a long-term finance lease for an office building. The terms of the lease required Rastall to pay $30,000 annually, beginning December 31, 2018, and continuing...
-
A firm is considering an investment in which its cash flow is 1 = $1 (million), 2 = -$12, 3 = $20, and t = 0 for all other t. The interest rate is 7%. Use the net present value rule to determine...
-
Write the binomial expansion of the expression. V3P
-
Consider the following cash flow profile, and assume MARR is 10 percent/year. a. What does Descartes' rule of signs tell us about the IRR(s) of this project? b. What does Norstrom's criterion tell us...
-
Prepare journal entries in the General Fund of the Brownville School District. a. The District had outstanding encumbrances of $13,000 for band instruments from the previous year. It is the Districts...
-
Consider the function f(x) = -x + 5. . - Given the graph of f(x) = x + 5, accurately sketch the graph of y(x) on the same set of axes. (1 mark) Algebraically determine the invariant points as exact...
-
Blossom Corporation is preparing the comparative financial statements to be included in the annual report to stockholders. Blossom employs a fiscal year ending May 31. Income from operations before...
-
Elevation Ltd manufactures water tanks. Use a table such as illustrated below, to check the columns for the following 5 costs items that most likely apply: Cost Product Period Justification Variable...
-
I am working on financial ratio analysis and what does negative bookvalue/share and negative price to book value mean?
-
12 Let a be a positive number, let : [2,) R, f(x) = ax and let g: (-0, 1] R, g(x) = x + a. Find all values of a for which both fog and g of exist.
-
The average monthly return of a mutual fund for the last ten years is 0.94%, with the variance 15.99%. The mean return of the benchmark index for the same period 1.33%, with the variance 13.3%....
-
The following variables have been declared: int num1=17; double num2=46.0; float answer; Write the Java statement to divide num2 by num1 and store the correct result in answer. View keyboard...
-
The expected return on a firm's stock is 30% and the firm currently has $500 million in debt and $500 million in equity. The firm is contemplating issuing $100 million in new equity and using the...
-
Assess the financial aspects of the focus business to that of the packaging business undertaking: Why is the benefit so unmistakable? The intentions in the distinctions can be characterized in those...
-
A sprinkler head malfunctions at midfield in an NFL football field. The puddle of water forms a circular pattern around the sprinkler head with a radius in yards that grows as a function of time, in...
-
A researcher wanted to find out if there was difference between the estimates given for a female actors earnings and a male actors earnings. The researcher hypothesized that the estimates would be...
-
The table below displays Trip Advisor ratings, as of March 2017, of the Prado National Museum in Madrid and the National Museum of Anthropology in Mexico. Use the data in the table to determine...
-
The table below displays the 10 fastest growing metropolitan statistical areas in the U.S. by net change from 2000 to 2010. Use the information in the table to answer the questions shown below the...
-
The perfectly competitive model assumes that firms know when marginal revenue equals marginal costs. a. If a firm doesnt have this information, can it produce at the profit-maximizing level of...
-
Hundreds of music stores have been closing in the face of stagnant demand for CDs because of new competition by online music vendors. a. How would price competition from these new sources cause a...
-
A California biotechnology firm submitted a tomato that will not rot for weeks to the U.S. Food and Drug Administration. It designed such a fruit by changing the genetic structure of the tomato. What...
Study smarter with the SolutionInn App