Next, in the IRR function, in the Values field, select the array of cells that contains the values of the payments and receipts for which you want to calculate the IRR. In our example, it is A1:A13.

Why Excel falls short. The Internal Rate of Return is a key metric used by investors, business managers and many other decision-makers to evaluate project profitability and viability. In the past, an ...