In: Finance
You are asked to evaluate the following two projects for the Norton corporation. Use a discount rate of 12 percent. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods.
Project X (Videotapes of the Weather Report) ($48,000 Investment) |
Project Y (Slow-Motion Replays of Commercials) ($68,000 Investment) |
|||||||||
Year | Cash Flow | Year | Cash Flow | |||||||
1 | $ | 24,000 | 1 | $ | 34,000 | |||||
2 | 22,000 | 2 | 27,000 | |||||||
3 | 23,000 | 3 | 28,000 | |||||||
4 | 22,600 | 4 | 30,000 | |||||||
a. Calculate the profitability index for project
X. (Do not round intermediate calculations
and round your answer to 2 decimal places.)
b. Calculate the profitability index for project
Y. (Do not round intermediate calculations and round your
answer to 2 decimal places.)
c. Which project would you select based on the profitability index?
Project X
Project Y
a
Project X | |||||
Discount rate | 0.12 | ||||
Year | 0 | 1 | 2 | 3 | 4 |
Cash flow stream | -48000 | 24000 | 22000 | 23000 | 22600 |
Discounting factor | 1 | 1.12 | 1.2544 | 1.404928 | 1.5735194 |
Discounted cash flows project | -48000 | 21428.57 | 17538.27 | 16370.95 | 14362.709 |
NPV = Sum of discounted cash flows | |||||
NPV Project X = | 21700.49 | ||||
Where | |||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||
PI= (NPV+initial inv.)/initial inv. | |||||
=(21700.49+48000)/48000 | |||||
1.45 | |||||
b | |||||
Project Y | |||||
Discount rate | 0.12 | ||||
Year | 0 | 1 | 2 | 3 | 4 |
Cash flow stream | -68000 | 34000 | 27000 | 28000 | 30000 |
Discounting factor | 1 | 1.12 | 1.2544 | 1.404928 | 1.5735194 |
Discounted cash flows project | -68000 | 30357.14 | 21524.23 | 19929.85 | 19065.542 |
NPV = Sum of discounted cash flows | |||||
NPV Project Y = | 22876.77 | ||||
Where | |||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||
PI= (NPV+initial inv.)/initial inv. | |||||
=(22876.77+68000)/68000 | |||||
1.34 | |||||
c
Choose Project X as it has higher PI