I have a set of dates and values and need to calculate the XIRR - however I have picked up a weird discrepancy, and in an attempt to try and decipher the issue I have replicated the same data set
- MSoft Excel
- Google Sheets
- LibreOffice Calc
- PHP Code.
MSoft Excel gets stuck at some point, and seems to be disregarding the cashflow from a certain point, resulting in a 148.15 XIRR value
ALL the others return -0.09 XIRR value.
The sheet is attached showing columns E,F and G showing what values are returned for each platform.
Column I shows the live calculation - which 'should' be your system's interpretation.
On each row - I calculated the XIRR from row 1 up-to-including the formula row.
Can anyone explain to me what is wrong here ?
Thanks
Bookmarks