MIRR Function

Modified internal rate of return for a series of periodic cash flows


Description

The function MIRR returns a value specifying the modified internal rate of return for a series of periodic cash flows (payments and receipts).


Syntax

MIRR (ValueArray, FinanceRate, ReinvestRate)


Required Parameters

ValueArray

Array of Double specifying cash-flow values. The array must contain at least one negative value (a payment) and one positive value (a receipt).


FinanceRate

The interest rate paid as the cost of financing.


ReinvestRate

The interest rate received on gains from cash reinvestment.