valuearray( ) (required; Array of Double)
An array of cash flow values
The interest rate paid as the cost of financing
The interest rate received on gains from cash investment
A Double representing the modified internal rate of return
Calculates the modified internal rate of return, which is the internal rate of return when payments and receipts are financed at different rates
valuearray must be a one-dimensional array
that contains at least one negative value (a payment) and one
positive value (a receipt). The order of elements within the array
should reflect the order in which payments and receipts occur.
reinvestrate are percentages expressed as
decimal values. For example, 10% is expressed as 0.10.
Each element of
valuearray represents a
payment or a receipt that occurs at a regular time interval. If this
is not the case, MIRR will return erroneous