In: Finance
Assume that McDonald’s is considering expanding its product line
to include one new sandwich. The estimated cash flows for 2 options
are listed below. The required return is 18%. What do you
recommend? Why?
Cash flows in millions
|
Year |
Sandwich A |
Sandwich B |
|
0 |
-25,000 |
-72,000 |
|
1 |
16,000 |
30,000 |
|
2 |
16,000 |
30,000 |
|
3 |
3,000 |
15,000 |
|
4 |
3,000 |
10,000 |
Assume that neither sandwich would be sold after 4 years because
McDonald’s assumes that neither sandwich will be profitable after 4
years.
| Statement showing Cash flows | Sandwich A | Sandwich B | ||||
| Particulars | Time | PVf 18% | Amount | PV | ||
| Cash Outflows | - | 1.00 | (25,000.00) | (25,000.00) | (72,000.00) | (72,000.00) |
| PV of Cash outflows = PVCO | (25,000.00) | (72,000.00) | ||||
| Cash inflows | 1.00 | 0.8475 | 16,000.00 | 13,559.32 | 30,000.00 | 25,423.73 |
| Cash inflows | 2.00 | 0.7182 | 16,000.00 | 11,490.95 | 30,000.00 | 21,545.53 |
| Cash inflows | 3.00 | 0.6086 | 3,000.00 | 1,825.89 | 15,000.00 | 9,129.46 |
| Cash inflows | 4.00 | 0.5158 | 3,000.00 | 1,547.37 | 10,000.00 | 5,157.89 |
| PV of Cash Inflows =PVCI | 28,423.53 | 61,256.61 | ||||
| NPV= PVCI - PVCO | 3,423.53 | (10,743.39) | ||||
| We would recommend Sandwich A as it has positive NPV | ||||||