A formula for IRR

[salvomic]

(05-18-2015 02:47 PM)DrD Wrote:  Ok, QRZ OM, would you buy this? (pre-set your flows in L1, L1:={-123400, 36200, 54800, 48100}; then run this program):

Code:


EXPORT IRR()
BEGIN    
   return fsolve(ΣLIST(MAKELIST((L1(I)/X^(I-1)),I,1,SIZE(L1))),X)-1; //  (Original command line from Cyrille and Akmon)
END;

I know, its closer but no cigar....

QSO CQ
I would buy it, Sir, but... :-)
Now the program it's ok but only with L1, instead, as first, with flows it's good also for L3 ora a new list, but... flows must be predefined...

We need a new cigar: between those two :-)