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.

Leaving data volume aside, the built-in IRR Excel function doesn’t perform periodic calculations. Instead, it expects data to be modeled in Excel on a monthly basis, creating internal time waste and ...