IRR


Description Returns the internal rate of return for a series of periodic cash flows.

Syntax IRR ( cash_flow [, guess] )

Argument Description
cash_flow A reference to a range that contains values for which to calculate the internal rate of return. The values must contain at least one positive and one negative value. During calculation, IRR uses the order in which the values appear to determine the order of the cash flow. Text, logical values, and empty cells in the range are ignored.
[guess] Optional. The estimate of the internal rate of return. If this argument is omitted, 10 is used.

Remarks The internal rate of return is the interest rate received for an investment consisting of payments (specified by negative numbers) and investments (specified by positive numbers).

IRR is calculated iteratively, cycling through the calculation until the result is accurate to .00001 percent. If the result cannot be found after 20 iterations, #NUM! is returned. When this occurs, supply a different value for guess.

Examples The following examples use this worksheet.


This function returns 3.72 percent:

IRR(B1:B6)

This function returns -49.26 percent:

IRR(B1:B3, -20%)

See Also MINVERSE, NPV, RATE