### 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 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 `