In: Finance
Using the following table calculate the following:
a. PV
b. NPV
c. PI
Which investment is the best if you have unlimited capital? (Why)
Which investment is the best if you have limited capital? (Why
| Profitability Index (PI) | |||
| 3 Investment alternatives | |||
| System A | System B | System C | |
| Initial Cost | $ 100,000 | $ 165,000 | $ 50,000 | 
| CF Year 1 | $ 40,000 | $ 60,000 | $ 10,000 | 
| CF Year 2 | $ 40,000 | $ 60,000 | $ 12,000 | 
| CF Year 3 | $ 40,000 | $ 60,000 | $ 20,000 | 
| CF Year 4 | $ 40,000 | $ 70,000 | $ 40,000 | 
| r | 10% | 10% | 10% | 
| System A | Discount factor @10% | Present value | System B | Discount factor @10% | Present value | System C | Discount factor @10% | Present value | |||
| CF Year 1 | $ 40,000 | $ 0.90909 | $ 36,364 | $ 60,000 | $ 0.90909 | $ 54,545 | $ 10,000 | $ 0.90909 | $ 9,091 | ||
| CF Year 2 | $ 40,000 | $ 0.82645 | $ 33,058 | $ 60,000 | $ 0.82645 | $ 49,587 | $ 12,000 | $ 0.82645 | $ 9,917 | ||
| CF Year 3 | $ 40,000 | $ 0.75131 | $ 30,053 | $ 60,000 | $ 0.75131 | $ 45,079 | $ 20,000 | $ 0.75131 | $ 15,026 | ||
| CF Year 4 | $ 40,000 | $ 0.68301 | $ 27,321 | $ 70,000 | $ 0.68301 | $ 47,811 | $ 40,000 | $ 0.68301 | $ 27,321 | ||
| a) | Present value | $ 126,795 | $ 197,022 | $ 61,355 | |||||||
| Initial Cost | $ 100,000 | 1 | $ 100,000 | $ 165,000 | 1 | $ 165,000 | $ 50,000 | 1 | $ 50,000 | ||
| b) | Net present value | $ 26,795 | $ 32,022 | $ 11,355 | |||||||
| c) | Profitability index | 1.27 | 1.19 | 1.23 | |||||||
| Profitability Index= Present value of cash inflows/cash outflow | |||||||||||
| All the investments are good with unlimited capital as all of them have positive net present value. | |||||||||||
| With limited capital, the investments need to be made in the following order 1) system B 2) system A and 3) system C i.e. highest net present value project should taken up first. | |||||||||||