IRR

Returns the calculated internal rate of return of an initial series of expected returns, based on an initial guess.

Syntax:

IRR(guess:number, data:array)

guess The guessed rate of return, entered as a decimal fraction.
data The initial investment should be entered as a negative number in the first cell in the range or element of the array. Further cells in the range or elements of the array should contain positive numbers, the expected returns on the investment.

For example, with -5000 in cell A1 and 500 in cells A2 to A14 and a guessed rate of return of 0.05 in A16:

IRR(A16, A1:A14)

will return the internal rate of return for the cash flows in column A.