Year
|
Chicken pizza
|
Vegetable pizza
|
0
|
-300
|
-500
|
1
|
100
|
150
|
2
|
200
|
275
|
3
|
120
|
240
|
4
|
100
|
160
|
Answer on excel:
1. What is the payback period for each proposed pizza?
2. What is the discounted payback period for each proposed pizza?
3. What is the NPV for each proposed pizza?