IRR Function

Returns the internal rate of return as a percentage

Category: Financial

Syntax

IRR ( freq,c0,cl,...,cn )

Arguments

freq

• is numeric, the number of payments over a specified base period of time that is associated with the desired internal rate of return.

• Range: freq > 0.

• Exception: The case freq = 0 is a flag to allow continuous compounding .

c0,c1,...,cn

• are numeric, the optional cash payments.

Comparisons

The IRR function is identical to INTRR, except that the rate returned is a percentage.