IRR Function [VBA]
Calculates the internal rate of return for an investment.
IRR(Values() as Double , [Guess as Variant])
Double
Values(): The array of values of the cash-flow. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).
Guess Wstępne oszacowanie tego, jaka będzie stopa IRR.
REM ***** BASIC *****
Option VBASupport 1
Sub ExampleIRR
Dim cashFlow(0 to 3) As Double
cashFlow(0) = -10000
cashFlow(1) = 3500
cashFlow(2) = 7600
cashFlow(3) = 1000
irrValue = IRR(cashFlow) * 100
Print irrValue ' zwraca 11,3321028236252. Wewnętrzna stopa zwrotu z przepływów pieniężnych.
End Sub