Calculate Net Present Value in D24:R24 using the NPV function excel for each of those rates for Years 1-15 plus Project End, adding the initial Startup profit value in C21 to the result of the NPV in each cell.
Calculate the internal rate of return in C26 using the IRR function, using profit for the entire time period (including startup and project end).
Solved by S. H. in 19 mins