In: Finance
A project has the following cash flows for years 0 through 2, respectively: -10,556, 9,776, 9,987. What is the internal rate of return on this project?
rate | 54.0327% | ||
Cash flows | Year | Discounted CF= cash flows/(1+rate)^year | Cumulative cash flow |
(10,556.00) | 0 | (10,556.00) | (10,556.00) |
9,776.000 | 1 | 6,346.70 | (4,209.30) |
9,987.000 | 2 | 4,209.29 | (0.00) |
Use IRR funcion in Excel
IRR = 54.03%