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 ...

If Guess is omitted, it is assumed by Excel to be 0.1 (10 per cent). Here’s how the IRR function works. First, list out in an Excel sheet the series of cash flows in the correct sequence.