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)
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 A1
6, the formula
IRR(A16, A1:A14)
will return the internal rate of return for the cash flows in column A
.