MIRR
Description
Returns the modified internal rate of return for a specified series of periodic cash
flows.
Syntax
MIRR(
values
,
finance_rate
,
reinvest_rate
)
- values: The array or reference to a range of cells containing the cash flow information.
- finance_rate: The interest rate for the money used in the cash flows.
- reinvest_rate: The interest rate for the reinvested cash flows.
Notes
- MIRR() results show all digits of precision. Microsoft® Excel® rounds results to nearest hundredth (percent).