Finc615 unit4 worksheet
NPV - IRR
| FIN 615 | ||||||
| NPV and IRR calculations | ||||||
| Cost of Capital | 10.00% | |||||
| Time/yr | 0 | 1 | 2 | 3 | 4 | 5 |
| Cash flow Input here | ||||||
| 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.9090909091 | 0.826446281 | 0.7513148009 | 0.6830134554 | 0.6209213231 | |
| IRR | 0.00% |