IRR

Calculates the internal rate of return on an investment based on a series of periodic cash flows.

Parameter List

Syntax
IRR(cashflow_amounts
[rate_guess]
)
cashflow_amounts

An array or range containing the income or payments associated with the investment. For example: A2:A24

[optional] rate_guess

An estimate for what the interest rate will be. For example: 1%. 0.1 by default.

Examples

IRR(A2:A4) returns 1654.80%