MIRR

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_rate	The interest rate paid (Double).
reinvest_rate	The 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 interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
* You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals.
* The equivalent Excel function is Application.WorksheetFunction.MIRR
* The equivalent .NET function is [[Microsoft.VisualBasic.Financial.Mirr]]
* For the Microsoft documentation refer to learn.microsoft.com

Dim ardoubles(3) as Double 
ardoubles(0) = -20 
ardoubles(1) = 10 
ardoubles(2) = 10 
ardoubles(3) = 20 
Debug.Print Mirr(ardoubles, 10, 10)   '= 3.061548