IRR

Returns the internal rate of return for a series of cash flows occurring at regular periods.

Function syntax

IRR(cell_range, guess)

Arguments:

• cell_range: A range of cells containing payments (negative values) and income (positive values).
• guess: (optional) An estimate for the expected rate of return. Defaults to 0.1 (10%).

Examples

• IRR(C1:C4) - Returns the internal rate of return for the four values in cells C1 through C4.
• IRR(C1:C4, 0.12) - Returns the internal rate of return for the four values in cells C1 through C4, starting with a guess of 12%.