CODEWITHSUNDEEP
libreoffice-calcxirr
Richard Parkins
Richard Parkins

Reputation: 532

XIRR function in LibreOffice giving strange results

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?

Upvotes: 0

Views: 335

Answers (1)

urznow
urznow

Reputation: 1801

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.

Upvotes: 0

Related Questions