FIN - NPV and IRR calculations
| Cost of Capital |
10.00% |
|
|
|
|
|
| Time/yr |
0 |
1 |
2 |
3 |
4 |
5 |
Cash flow
|
|
|
|
|
|
|
| Discounted CF |
0 |
0 |
0 |
0 |
0 |
0 |
| NPV |
0 |
=cf1/((1+n)^1) |
=cf2/((1+n)^2) |
=cf3/((1+n)^3) |
=cf4/((1+n)^4) |
=cf5/((1+n)^5) |
| PV factor |
|
0.909090909 |
0.826446281 |
0.751314801 |
0.683013455 |
0.620921323 |
Find the IRR and NPV for given question