IRR(values() [,guess])

Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double).


values()The array of cash flow values (Double).
guess(Optional) The estimate to the value returned by this function (Double).

REMARKS
* The internal rate of return is the interest rate received for an investment consisting of payments and receipts that occur at regular intervals.
* The first value in the "values()" array must be negative ??
* The "values()" must contain at least one negative value (a payment) and one positive number (a receipt)
* If "guess" is left blank, then 0.1 (10%) is used.
* It is important to ensure that the values in your array are in the correct order.
* This function uses iteration in it calculation and if the function cannot find a result after 20 tries, to within 0.001% it fails ??
* You can use the MIRR function to return the internal rate of return for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
* The equivalent Excel function is Application.WorksheetFunction.IRR
* The equivalent .NET function is Microsoft.VisualBasic.Financial.Irr
* 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
Irr(ardoubles) = 0.38367

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