MIRR Function

The MIRR function is one of the financial functions. It is used to calculate the modified internal rate of return for a series of periodic cash flows.

Syntax

MIRR(values, finance_rate, reinvest_rate)

The MIRR function has the following arguments:

Argument	Description
values	An array that contains the series of payments occuring at regular periods. At least one of the values must be negative and at least one positive.
finance_rate	The interest rate paid on the money used in the cash flows.
reinvest_rate	The interest rate received on the cash reinvestment.

Notes

How to apply the MIRR function.

Examples

The figure below displays the result returned by the MIRR function.