Fmirr()

Description:

The function equals the Excel MIRR function.

Syntax:

Fmirr(values,finance_rate,reinvest_rate)

Note:

The function 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.

Parameters:

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