Issue with IRR Calculation

FRom others on this forum more knowledgeable than me, I have learned that Excel's XIRR() function has some numerical instabilities in it that cause it to return incorrect results in some cases. That 2.98E-9 result is one indication that the XIRR() calculation is not converging on the correct result. If I enter an optional "gues" to your XIRR() function =XIRR(current argument, currentargument,-.5), then I get the XIRR() functions to return -1.55% and -3.34% (I did this in Gnumeric and LO Calc -- I know I have seen Excel's XIRR() function be less stable than these other spreadsheets). From what I can tell, any time you get that 2.98E-9 result, that tells you that you need to supply a "guess" argument, until you find a suitable value that allows Excel's XIRR() to calculate the true rate of return.

see discussion here: https://www.excelforum.com/excel-gen...ml#post4809641
https://www.excelforum.com/excel-for...ml#post4831063

See if that helps.