In: Finance
If you invest 3000 today and expect to profit $200 a year for 10 years what id the IRR on the investment?
| Project | |||||||||||
| IRR is the rate at which NPV =0 | |||||||||||
| IRR | -0.067657639 | ||||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 
| Cash flow stream | -3000 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 
| Discounting factor | 1 | 0.932342 | 0.869262 | 0.81045 | 0.7556169 | 0.704494 | 0.656829 | 0.61239 | 0.570957 | 0.532327 | 0.496311 | 
| Discounted cash flows project | -3000 | 214.5135 | 230.0802 | 246.7765 | 264.68439 | 283.8918 | 304.4931 | 326.5894 | 350.2891 | 375.7087 | 402.9729 | 
| NPV = Sum of discounted cash flows | |||||||||||
| NPV Project = | -0.00043689 | ||||||||||
| Where | |||||||||||
| Discounting factor = | (1 + IRR)^(Corresponding period in years) | ||||||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||||||
| IRR= | -6.77% | ||||||||||