I have the excel answer but would like a solution without using excel and instead using formula.

8. A proposed project requires an initial investment of 5 million and a second investment of 3 million at the end of year 2. It will generate of return of 2 million at the end of three years and a return of 4 million at the end of years 5 and 6. Calculate the project's internal rate of return. year cash flow 3,000,000 3.000.000 2.000.000 -NMtos 4,000,000 4.000000 5.40% IRR =