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