Answered step by step
Verified Expert Solution
Question
1 Approved Answer
9. (14 points) A local restaurant is trying to evaluate opening a new location. This location is in a completely different neighborhood, and they do
9. (14 points) A local restaurant is trying to evaluate opening a new location. This location is in a completely different neighborhood, and they do not expect any of their current customers to frequent the new location. They expect acquiring new customers will cost approximately $21 per customer gained, and they have set the ambitious goal of acquiring 3,500 customers in their initial marketing campaign. They assume no maintenance costs in years 2 and 3. They would like you to use a discount rate of 20% (10% interest rate and a risk factor of 2). They have provided you with a few additional pieces of information about their business, and would like your help evaluating the customer lifetime value after 2 years. Complete cells a - zb in the table below (shaded cells do not need to be completed): Revenues Year 1 Year 2 Year 3 Customers 3,500 Retention Rate 58% 70% 80% Average Purchase Size $35 $45 $55 Total Revenue Costs Variable Cost (%) 55% 55% 55% Variable Cost ($) Acquisition Cost ($) Total Costs Gross Profit Discount rate applied 4 NPV Cumulative NPV 60 = LTV
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started