Answered step by step
Verified Expert Solution
Link Copied!

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?image text in transcribed

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.97

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pricing And Liquidity Of Complex And Structured Derivatives

Authors: Mathias Schmidt

1st Edition

3319459694, 978-3319459691

More Books

Students also viewed these Finance questions

Question

Provide an example of talent management-oriented appraisals.

Answered: 1 week ago