I need some help in Finance projects
cvyney200
npvandirr_template_5year-2.xlsSheet1
| NPV and IRR Template_ five years | ||||||
| Assumptions & inputs: | ||||||
| required rate of return | 9.0% | |||||
| Investment | Year 1 | year 2 | year 3 | year 4 | year 5 | |
| $ (100,000.0) | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | |
| discount factor | 1.09 | 1.19 | 1.30 | 1.41 | 1.54 | |
| Present values | $ 22,935.8 | $ 21,042.0 | $ 19,304.6 | $ 17,710.6 | $ 16,248.3 | |
| Total present value | $ 97,241.3 | |||||
| NPV | $ (2,758.7) | |||||
| IRR | 7.9% |
