MIRR
Returns the modified internal rate of return for a series of periodic cash flows
Syntax
MIRR(values, finance_rate, reinvest_rate)
Parameters
- values: Required. An array or reference to cells that contain numbers
- finance_rate: Required. The interest rate you pay on the money used in the cash flows
- reinvest_rate: Required. The interest rate you receive on the cash flows as you reinvest them
Example
=MIRR({-120000, 39000, 30000, 21000, 37000, 46000}, 0.10, 0.12)