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
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top