In: Finance
You are asked to evaluate the following two projects for Boring Corporation. Use a discount rate of 12 percent. Use Appendix B.
Project X (DVDs |
Project Y (Slow-Motion |
|||||||||
Year | Cash Flow | Year | Cash Flow | |||||||
1 | $18,000 | 1 | $28,000 | |||||||
2 | 16,000 | 2 | 21,000 | |||||||
3 | 17,000 | 3 | 22,000 | |||||||
4 | 16,600 | 4 | 24,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 12 percent.
Project Y
Project X
a.
Project X | Project Y | |
NPV | $ 15,487.60 | $ 16,669.00 |
b.
Project X | Project Y | |
Profitability Index (PI) | 1.43 | 1.30 |
c.
Project Y
Based on NPV, Project Y is better. But, based on PI, Project X is better.
The objective of investment is to created money.So, NPV method is preferred over others to decide in case of conflict of decison.
Thus, Project Y is better.
Step-1:Calculation of present value of annual cash flow | ||||
Project X: | ||||
Year | Cash Flow | Discount factor | Present Value | |
a | b | c=1.12^-a | d=b*c | |
1 | $ 18,000 | 0.893 | $ 16,074.00 | |
2 | $ 16,000 | 0.797 | $ 12,752.00 | |
3 | $ 17,000 | 0.712 | $ 12,104.00 | |
4 | $ 16,600 | 0.636 | $ 10,557.60 | |
Total | $ 51,487.60 | |||
Project Y: | ||||
Year | Cash Flow | Discount factor | Present Value | |
a | b | c=1.12^-a | d=b*c | |
1 | $ 28,000 | 0.893 | $ 25,004.00 | |
2 | $ 21,000 | 0.797 | $ 16,737.00 | |
3 | $ 22,000 | 0.712 | $ 15,664.00 | |
4 | $ 24,000 | 0.636 | $ 15,264.00 | |
Total | $ 72,669.00 | |||
Step-2:Calculation of NPV and PI | ||||
NPV of: | ||||
Project X | = | Present Value of annual cash flow | - | Investment |
= | $ 51,487.60 | - | $ 36,000.00 | |
= | $ 15,487.60 | |||
Project Y | = | Present Value of annual cash flow | - | Investment |
= | $ 72,669.00 | - | $ 56,000.00 | |
= | $ 16,669.00 | |||
Profitability Index of : | ||||
Project X | = | Present Value of annual cash flow | / | Investment |
= | $ 51,487.60 | / | $ 36,000.00 | |
= | 1.43 | |||
Project Y | = | Present Value of annual cash flow | / | Investment |
= | $ 72,669.00 | / | $ 56,000.00 | |
= | 1.30 |