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 |