In the example below, why are the calculations of the IRR in cell B13 and XIRR in cell B14 different?

Transcribed Image Text:

A B 1 IRR vs XIRR 23456789 Date Cash flow 01-Jan-18 -1,000 01-Jan-19 01-Jan-20 300 300 01-Jan-21 300 01-Jan-22 300 01-Jan-23 300 01-Jan-24 300 10 01-Jan-25 300 11 01-Jan-26 12 13 IRR 14 XIRR 1,300 30.00%