In: Finance
Pepsico is considering two mutually exclusive projects. Both require an initial investment of $10,000, and their risks are average for the firm. Project X has an expected life of 2 years with after-tax cash inflows of $5,300 and $7,000 at the end of Years 1 and 2, respectively. Project Y has an expected life of 4 years with after-tax cash inflows of $3,700 at the end of each of the next 4 years. The firm's WACC is 8%. Use the replacement chain approach to determine the NPV of the most profitable project.
| Project X | |||||
| Discount rate | 8.000% | ||||
| Year | 0 | 1 | 2 | 3 | 4 | 
| Cash flow stream | -10000 | 5300 | -3000 | 5300 | 7000 | 
| Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 | 1.360 | 
| Discounted cash flows project | -10000.000 | 4907.407 | -2572.016 | 4207.311 | 5145.209 | 
| NPV = Sum of discounted cash flows | |||||
| NPV Project X = | 1687.91 | ||||
| Where | |||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||
| Project Y | |||||
| Discount rate | 8.000% | ||||
| Year | 0 | 1 | 2 | 3 | 4 | 
| Cash flow stream | -10000 | 3700 | 3700 | 3700 | 3700 | 
| Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 | 1.360 | 
| Discounted cash flows project | -10000.000 | 3425.926 | 3172.154 | 2937.179 | 2719.610 | 
| NPV = Sum of discounted cash flows | |||||
| NPV Project Y = | 2254.87 | ||||
| Where | |||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||
Choose project Y as NPV is higher