A formula for IRR

[salvomic]

(05-18-2015 03:32 PM)DrD Wrote:  Here's a twist on the theme, requires NO pre-definition, but will work with the list, if it is predefined:

Code:


EXPORT IRR()
...

You would need to clear the input line if you input a brace enclosed set of values, of course.

well!
another approach, that maybe "purists" could also accept...

Code:


EXPORT IRR()
// Thanks Cyrille, Akmon, Dale, salvomic
BEGIN
EDITLIST(flows);
RETURN fsolve(ΣLIST(MAKELIST((flows(I)/X^(I-1)),I,1,SIZE(flows))),X)-1;
END;

If flows is not set, user can add CF items, if it's present, he/she can edit the list, then calculates IRR...