Firr()

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