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.
Created attachment 177339 [details] Snapshot of an open Calc SS with two formulas revealed
Can you upload the test document? Setting this as OS all, as I doubt it's limited to macOS
Created attachment 178100 [details] The ODS file corresponding to the pdf file showing the problem Happy to supply the example ODS file.
Thanks! I opened your document in Excel, saved as xlsx, and recalculated: The output is identical as LO So without going into the calculation logic behind it, it seems like spreadsheet software do see this as two different cashflows on the backend Resolving as not a bug