A formula for IRR

[DrD]

A couple of things to say here:

1. You don't really need to declare a local variable I, since I is an available global already.
2. The dummy variable "flows" can not be typecast to a list directly that way. To demonstrate (using a predefined list variable):

Code:


EXPORT IRR(L1)
BEGIN
local irr, sz;
flows:=L1;
sz:= SIZE(flows);
irr:= fsolve(ΣLIST(MAKELIST((flows(I)/X^(I-1)),I,1,sz)), X)-1;
RETURN irr;
END;

I included the list variable "flows," only to demonstrate the need for a type: list variable. I know the code is redundant, instead you may prefer this:

Code:


EXPORT IRR(L1)
BEGIN
  RETURN fsolve(ΣLIST(MAKELIST((flows(I)/X^(I-1)),I,1,size(L1))), X)-1;
END;

-Dale-