Fmirr()

Description:

The function equals the Excel MIRR function.

Syntax:

Fmirr(values,finance_rate,reinvest_rate)

Note:

The external library function (See External Library Guide) returns the modified internal rate of return for a series of periodic cash flows, taking into consideration the cost of the investment and the interest on the reinvestment of cash.

Parameter:

values

A sequence containing the values of payment (negative value) and income (positive value) at each of the regular periods. At least one negative value and at least one positive value must be contained.

finance_rate

The interest rate paid on the money invested.

reinvest_rate

The interest rate paid on the reinvested cash which is the net income from the regular periods.

Example:

Fmirr([-120000,39000,30000,21000,37000,46000],0.1,0.12)

0.1260941303659051