XIRR function in LibreOffice giving strange results

Question

Version: 7.2.3.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 8; OS: Linux 5.3;
UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded

http://www.zen224037.zen.co.uk/LibreOfficeBug.ods

The two calculations are exactly the same apart from the one day difference between the dates in C1 and C3, which shouldn't affect the result anyway because the cash flows for that date are zero.

Can anyone explain this?

Answer 1

Explain? No. But the wiki.documentfoundation.org article on XIRR (quoting the ODF standard) says,

The first cash-flow amount is a negative number that represents the investment.

If you change the amount in cell C4 from 0 to -0.01 both XIRR functions return -12.14%. I'd make C2 non-zero as well.