Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the formula for figuring out the Cumulative NPV Profit? Lifetime Value Before New Programs Year 3 Year 1 Year 2 5.000 3500 2,590
What is the formula for figuring out the Cumulative NPV Profit?
Lifetime Value Before New Programs Year 3 Year 1 Year 2 5.000 3500 2,590 Customers 70.0% 74.0% 80.0% Retention Rate 0.69 0.78 0.64 Visits/Week S33 S45 S55 Average Basket 5,280,000 5,433,750 S5,555,550 Total Sales 83.0% B0.0% 79.0% Cost Percent $4,388,885 Direct Costs $4,382,400 $4,347,000 $597,713 S611,111 Labor Benefits 11% $580,800 Card Program $16, $8 $80,000 $28,000 820,720 S111,111 Advertising 2% S105,600 $108,675 S5,131,826 S5,148,800 $5,081,388 Total Costs S131,200 423,724 $352,363 Gross Profit 1.00 11.20 1.44 Discount Rate S294, 253 $131,200 $293,635 NPV Profit S131,200 $424,835 $719,088 Cum. NPV Profit 143.82 Lifetime Value S26.24 $84.97Step 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