I need some help in Finance projects
cvyney200
npvandirr_template_3year.xlsSheet1
| NPV and IRR Template | ||||
| Assumptions & inputs: | ||||
| required rate of return | 20.0% | |||
| Investment | Year 1 | year 2 | year 3 | |
| $ (110,000.0) | $ 51,781.00 | $ 51,780.00 | $ 71,780.00 | |
| discount factor | 1.20 | 1.44 | 1.73 | |
| Present values | $ 43,150.8 | $ 35,958.3 | $ 41,539.4 | |
| Total present value | $ 120,648.5 | |||
| NPV | $ 10,648.5 | |||
| IRR | 25.8% |
