In: Finance
You are asked to evaluate the following two projects for Boring Corporation. Use a discount rate of 13 percent. Use Appendix B.
|
Project X (DVDs |
Project Y (Slow-Motion |
|||||||||
| Year | Cash Flow | Year | Cash Flow | |||||||
| 1 | $9,000 | 1 | $19,000 | |||||||
| 2 | 7,000 | 2 | 12,000 | |||||||
| 3 | 8,000 | 3 | 13,000 | |||||||
| 4 | 7,600 | 4 | 15,000 | |||||||
a. Calculate the profitability index for project X. (Round "PV Factor" to 3 decimal places. Round the final answer to 2 decimal places.)
PI
b. Calculate the profitability index for project Y. (Round "PV Factor" to 3 decimal places. Round the final answer to 2 decimal places.)
PI
c. Using the NPV method combined with the PI approach, which project would you select? Use a discount rate of 13 percent.
Project Y
Project X
NPV = PV of Cash Inflwos - PV of Cash outflows
PI = PV of Cash inflwos / PV of Cash Outflows
PI Project X:
| Year | CF | PVF @13% | Disc CF |
| 1 | $9,000.00 | 0.8850 | $ 7,964.60 |
| 2 | $7,000.00 | 0.7831 | $ 5,482.03 |
| 3 | $8,000.00 | 0.6931 | $ 5,544.40 |
| 4 | $7,600.00 | 0.6133 | $ 4,661.22 |
| PV of Cash Inflows | $23,652.25 | ||
| PV of Cash Outflows | $18,000.00 | ||
| PI | 1.31 |
PI Project Y:
| Year | CF | PVF @13% | Disc CF |
| 1 | $19,000.00 | 0.8850 | $16,814.16 |
| 2 | $12,000.00 | 0.7831 | $ 9,397.76 |
| 3 | $13,000.00 | 0.6931 | $ 9,009.65 |
| 4 | $15,000.00 | 0.6133 | $ 9,199.78 |
| PV of Cash Inflows | $44,421.35 | ||
| PV of Cash Outflows | $38,000.00 | ||
| PI | 1.17 |
NPV :
Project X:
| Year | CF | PVF @13% | Disc CF |
| 1 | $9,000.00 | 0.8850 | $ 7,964.60 |
| 2 | $7,000.00 | 0.7831 | $ 5,482.03 |
| 3 | $8,000.00 | 0.6931 | $ 5,544.40 |
| 4 | $7,600.00 | 0.6133 | $ 4,661.22 |
| PV of Cash Inflows | $23,652.25 | ||
| PV of Cash Outflows | $18,000.00 | ||
| NPV | 5,652.25 |
Project Y:
| Year | CF | PVF @13% | Disc CF |
| 1 | $19,000.00 | 0.8850 | $16,814.16 |
| 2 | $12,000.00 | 0.7831 | $ 9,397.76 |
| 3 | $13,000.00 | 0.6931 | $ 9,009.65 |
| 4 | $15,000.00 | 0.6133 | $ 9,199.78 |
| PV of Cash Inflows | $44,421.35 | ||
| PV of Cash Outflows | $38,000.00 | ||
| NPV | 6,421.35 |
| Particular | Project X | Project Y | Selected |
| PI | 1.31 | 1.17 | Project X |
| NPV | $5,652.25 | $ 6,421.35 | Project Y |
Plz comment, if any further assistance is required