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_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 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

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