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).|
|* 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 docs.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
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top