A formula for IRR

[salvomic]

(05-18-2015 05:47 AM)cyrille de brébisson Wrote:  Hello,

Easiest way to do it is as follow:

Enter your cashflow in L1, following usual +/- signs
enter the SOLVE aplet, but do NOT use the SOLVE UI as it will try to set L1 to 0..
Instead, on the command line, type:

SOLVE(ΣLIST(MAKELIST((L1(I)/X^(I-1)),I,1,SIZE(L1))),X)

This shold solve your IRR problem if I am not mistaken (verify the /X^(I-1), it might not be exactly what is needed)

Cyrille

thank you Cyrille, interesting.
However in the first try, I made some errors, so Solve has deleted the list then the Prime reset...
I'll make other tries...
maybe it should be:
SOLVE(ΣLIST(MAKELIST((L1(I)/(I+1)^X),I,1,SIZE(L1))),X)
but I get this warning ""argument is not an equation, solving 130000=0", then a void [].
130000 is the last item of the list...

Salvo

EDIT: for test I'm using the 12C example: {-80000, -500, 4500, 5500, 4500, 130000} CF0=-80000, then the CFj. Its IRR is about 13.06, at this rate the NPV of the list is about 0