IRR()

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

Added to version 5.0.

rate = IRR(array values)

Argument	Contents
values	Array of numbers

The internal rate of return for the array of values.

The cash flows do not have to be even, as they would be for an annuity.
The cash flows must occur at regular intervals, such as monthly or annually.
The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods.

values = {-70000, 12000, 15000, 18000,21000,26000}

rate = IRR(values)

ShowMessage("The internal rate of return is: " + string(rate))