MIRR(values(), finance_rate, reinvest_rate)

Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double).


values()The array of cash flow values (Double).
finance_rateThe interest rate paid (Double).
reinvest_rateThe interest rate received (Double).

REMARKS
* The "values()" must contain at least one negative value (a payment) and one positive value (a receipt).
* The internal rate of return is the rate of return when payments and receipts are financed at different rates.
* The "finance_rate" is the interest rate paid of the cost on the investment.
* The "reinvest_rate" is the interest rate received on reinvesting the cash.
* The "finance_rate" and "reinvest_rate" are percentages and must be expressed as decimals (ie 5% = 0.05)
* This function uses the order of values within the array to interpret the order of payments and receipts.
* It is important to ensure that the values in your array are in the correct order.
* You can use the IRR function to return the internal rate of return for a series of unequal cash flows at regular intervals (implicit reinvestment rate)
* The equivalent Excel function is Application.WorksheetFunction.MIRR
* The equivalent .NET function is Microsoft.VisualBasic.Financial.Mirr
* For the Microsoft documentation refer to docs.microsoft.com

Dim ardoubles(3) as Double 
ardoubles(0) = -20
ardoubles(1) = 10
ardoubles(2) = 10
ardoubles(3) = 20
MIrr(ardoubles, 10, 10) = 3.061548

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top