MIRR Function Explained
The MIRR Function in Microsoft Excel calculates the modified internal rate of return for a series of cash flows. It takes two arguments: values (required) and finance_rate (required) and reinvest_rate (optional). The values argument is an array or a reference to cells that contain numbers for which you want to calculate the modified internal rate of return. The finance_rate argument is the interest rate you pay on the money used in the cash flows. The reinvest_rate argument is the interest rate you receive on the cash flows when you reinvest them. The MIRR Function returns the modified internal rate of return for a series of cash flows.
MIRR Function Syntax
MIRR(values, finance_rate, reinvest_rate)
- values: The range or array of cash flows that you want to use to calculate the modified internal rate of return.
- finance_rate: The interest rate you pay on the money used in the cash flows.
- reinvest_rate: The interest rate you receive on the cash flows when you reinvest them.