IRR

IRR internal rate of return

Synopsis

IRR(values,guess)

Arguments

values: cash flow

guess: an estimate of what the result should be

Description

IRR calculates the internal rate of return of a cash flow with periodic payments. values lists the payments (negative values) and receipts (positive values) for each period.

Note

The optional guess is needed because there can be more than one valid result. It defaults to 10%.

See also

XIRR.