Description：
The function equals the Excel IRR function.
Syntax：
Firr(values,guess)
Note：
The external library function (See External Library Guide) calculates the internal rate of return for a series of cash flows represented by numeric values. The internal rate of return is the rate that makes the net present value from a particular investment equal to zero, that is, the current value of the returns received from the investment happens to be equal to the the investment cost.
Parameter：
|
values |
A sequence containing the values of a series of cash flows used to calculate the internal rate of return. It must contain at least one periodic payment (negative value) and at least one periodic income (positive value) |
|
guess |
An estimated value for IRR function’s calculation. If omitted, it will take on the default value of 0.1 |
Example：
|
Firr([-70000,12000,15000,18000,21000]) |
-0.02124484827331908 |
|
Firr([-70000,12000,15000,18000,21000,26000]) |
0.08663094803666999 |
|
Firr([-70000,12000,15000,18000,21000,26000],-0.1) |
0.08663094803655035 |