https://bugs.documentfoundation.org/show_bug.cgi?id=146599
Bug ID: 146599
Summary: XIRR produces incorrect value
Product: LibreOffice
Version: 7.1.8.1 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Comparing XIRR and RATE for the same two cash flows, XIRR produces 38% while an
equivalent (IMO) RATE calculation produces 32%. In addition, the HP 10bII
calculator agrees with the RATE calculation.
Steps to Reproduce:
1.Please see attached PDF, containing a snapshot of an open Calc SS with the
two formulas revealed.
2.
3.
Actual Results:
38%
Expected Results:
32%
Reproducible: Always
User Profile Reset: No
Additional Info:
The XIIR calculation for a starting negative cash flow and an ending positive
cash flow should produce the same compounding interest rate as the RATE
function with zero additional payments over the same period. In fact, to get
close to 38% produced by the XIRR function by using the RATE function would
require the use of 54 days rather than the actual 64 days in the period.
--
You are receiving this mail because:
You are the assignee for the bug.
