In: Finance
Question 1 has already been answered. Please answer question 2 below the table only.
Assume I=6%.
(60 points)
Project |
CF0 |
CF1 |
CF2 |
CF3 |
CF4 |
CF5 |
A |
-12,000 |
3000 |
3000 |
4000 |
4000 |
1000 |
B |
-12,000 |
4000 |
4000 |
3000 |
3000 |
1000 |
C |
-12,000 |
3000 |
3000 |
3000 |
3000 |
1000 |
D |
-12,000 |
5000 |
3000 |
5000 |
3000 |
0 |
E |
-12,000 |
3000 |
3000 |
3000 |
3000 |
5000 |
F |
-12,000 |
0 |
0 |
6000 |
6000 |
6000 |
Calculation of NPV of project | |||||||||||||
Year | Discount Factor @ 6% | Project A | Project B | Project C | Project D | Project E | Project F | ||||||
Cash flow | Present value | Cash flow | Present value | Cash flow | Present value | Cash flow | Present value | Cash flow | Present value | Cash flow | Present value | ||
0 | 1.00000 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 | -$12,000.00 |
1 | 0.94340 | $3,000.00 | $2,830.19 | $4,000.00 | $3,773.58 | $3,000.00 | $2,830.19 | $5,000.00 | $4,716.98 | $3,000.00 | $2,830.19 | $0.00 | $0.00 |
2 | 0.89000 | $3,000.00 | $2,669.99 | $4,000.00 | $3,559.99 | $3,000.00 | $2,669.99 | $3,000.00 | $2,669.99 | $3,000.00 | $2,669.99 | $0.00 | $0.00 |
3 | 0.83962 | $4,000.00 | $3,358.48 | $3,000.00 | $2,518.86 | $3,000.00 | $2,518.86 | $5,000.00 | $4,198.10 | $3,000.00 | $2,518.86 | $6,000.00 | $5,037.72 |
4 | 0.79209 | $4,000.00 | $3,168.37 | $3,000.00 | $2,376.28 | $3,000.00 | $2,376.28 | $3,000.00 | $2,376.28 | $3,000.00 | $2,376.28 | $6,000.00 | $4,752.56 |
5 | 0.74726 | $1,000.00 | $747.26 | $1,000.00 | $747.26 | $1,000.00 | $747.26 | $0.00 | $0.00 | $5,000.00 | $3,736.29 | $6,000.00 | $4,483.55 |
NPV | $774.29 | $975.97 | -$857.42 | $1,961.35 | $2,131.61 | $2,273.83 | |||||||
Project | NPV | ||||||||||||
A | $774.29 | ||||||||||||
B | $975.97 | ||||||||||||
C | -$857.42 | ||||||||||||
D | $1,961.35 | ||||||||||||
E | $2,131.61 | ||||||||||||
F | $2,273.83 | ||||||||||||
Answer a | |||||||||||||
I will invest in Projects A,B,D,E and F as these projects have positive NPV. | |||||||||||||
Answer B | |||||||||||||
I will invest in Project F as it has highest NPV compared to other projects. | |||||||||||||
Answer C | |||||||||||||
I will invest in Project E and F as these combination will give highest NPV. | |||||||||||||
Answer D | |||||||||||||
I will invest in Project D,E and F as these combination will give highest NPV. | |||||||||||||