Visual Basic Financial Function : IRR

Purpose : The IRR function to return the internal rate of return for a series of periodic payments and receipts.

Syntax :
IRR ( dblValuesArray ( ) [ , vGuess ] )

dblValuesArray : Array of cash flows.
vGuess : Estimate for the IRR use as a starting point in the first iteration.

dblMoney(0) = 50000
dblMoney(1) = 25000
dblMoney(2) = 0
dblMoney(3) = 10000
dblMoney(4) = 30000
dblMoney(5) = 50000
dblMoney(6) = 200000

trnVal = IRR ( dblMoney () , 0.20 ) * 100

The IRR function can provide the overall tate of return for an investment that has a varying payment and receipt schedule. the dblValuesArray () argument is a one-dimensional array holding the monetary values . it must have at least one negative amount ( the payment ) and one positive amount ( the receipt ). and we can provide a varying cas flow stream for the function to evaluate.