IRR

FINANCE.IRR

FINANCE.IRR(values...)

Calculates the internal rate of return for a series of cash flows.

• values: Income or payments associated with the investment. Must contain at least 1 negative and 1 positive value, and the first amount must be negative.