Talk:Documentation/Calc Functions/IRR

SF Comments

 * (1) Summary. Replace 1st sentence with “Calculate the internal rate of return for a series of cash flows, iterating to find the rate of return which gives a zero net present value for the cash flows”. Also, suggest delete 2nd sentence as it contains material that should be in the Arguments section.
 * (2) Returns. Insert “decimal” before “fraction”. Change “a series of investments” to “the series of cash flows”.
 * (3) Arguments, Values. Are you sure that you can use an array as an argument? I have not managed to do so.
 * (4) Arguments, Guess. Change “in percentage or fraction” to “as a percentage or decimal fraction”.
 * (5) Arguments, Warning. I see no need for this to be a warning on the wiki – I would prefer it to be a bullet – consistent with many other pages that highlight error conditions.
 * (6) Arguments, general. We need to define the constraints on the values. At least one of the cash flows must be negative and at least one positive - to allow the net present value to be zero. The order of the cash flows is significant; make sure that you arrange them in the correct sequence.
 * (7) Additional details. Include a link to Wikipedia’s page entitled “Internal rate of return”.
 * (8) Additional details. Might also be worth adding that the result of IRR is the rate at which the NPV function will return zero with the given values (perhaps formatted as a formula).
 * (9) Examples. Both formulas refer to A1:A16 – presumably, this should be A1:A6? Also, are we being inconsistent by not having an error example?
 * (10) Related LibreOffice functions. Should MIRR be included?

--Stevefanning (talk) 2020-11-20T14:30:26 (UTC)