In: Finance
You are asked to evaluate the following two projects for the Norton corporation. Use a discount rate of 14 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) ($20,000 Investment) Project Y (Slow-Motion Replays of Commercials) ($40,000 Investment) Year Cash Flow Year Cash Flow 1 $ 10,000 1 $ 20,000 2 8,000 2 13,000 3 9,000 3 14,000 4 8,600 4 16,000 a. Calculate the profitability index for project X. (Do not round intermediate calculations and round your answer to 2 decimal plac es.) 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? Project X Project Y
(a)-Profitability Index (PI) for Project X (Videotapes of the Weather Report)
| 
 Year  | 
 Annual cash inflow ($)  | 
 Present Value factor at 14.00%  | 
 Present Value of Annual cash inflow ($)  | 
| 
 1  | 
 10,000  | 
 0.877193  | 
 8,771.93  | 
| 
 2  | 
 8,000  | 
 0.769468  | 
 6,155.74  | 
| 
 3  | 
 9,000  | 
 0.674972  | 
 6,074.74  | 
| 
 4  | 
 8,600  | 
 0.592080  | 
 5,091.89  | 
| 
 TOTAL  | 
 26,094.30  | 
||
Profitability Index (PI) for Project X = Present Value of annual cash inflows / Initial Investment
= $26,094.30 / $20,000
= 1.30
(b)-Profitability Index (PI) for Project Y (Slow-Motion Replays of Commercials)
| 
 Year  | 
 Annual cash inflow ($)  | 
 Present Value factor at 14.00%  | 
 Present Value of Annual cash inflow ($)  | 
| 
 1  | 
 20,000  | 
 0.877193  | 
 17,543.86  | 
| 
 2  | 
 13,000  | 
 0.769468  | 
 10,003.08  | 
| 
 3  | 
 14,000  | 
 0.674972  | 
 9,449.60  | 
| 
 4  | 
 16,000  | 
 0.592080  | 
 9,473.28  | 
| 
 TOTAL  | 
 46,469.82  | 
||
Profitability Index (PI) for Project Y = Present Value of annual cash inflows / Initial Investment
= $46,469.82 / $40,000
= 1.16
DECISION
We should select “Project X (Videotapes of the Weather Report)“. Since it has the higher Profitability Index of 1.30.
NOTE
The formula for calculating the Present Value Inflow Factor (PVIF) is [1 / (1 + r)n], where “r” is the Discount Rate/Cost of capital and “n” is the number of years.