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|Range)

where:

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

Example:

With -5000 in cell A1 and 500 in cells A2:A14 and a guessed rate of return of 0.05 in A16, the formula

IRR(A16, A1:A14)

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