Irr

Syntax

Irr(Values[, Guess])

Parameters

Values. Cell range containing values, for which internal yield rate should be calculated. The values must include at least one positive and one negative value.

Guess. Optional parameter. A number, which is considered to be close to the result of Irr. The default value is 0.1. In most cases you do not need to specify this parameter.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the internal rate of return for a series of cash flows presented with their numeric values.

Comments

Irr uses values order to interpret payments and receipts order. Make sure to enter your payment and income values in the sequence you want.

If Irr returns an error or if the result is much different from the expected one, try to repeat the calculations using another value for the Guess parameter.

These cash flows do not have to be equal, as in the case with annuity. However they must occur after equal time periods, for example monthly or annually. Internal bill rate is an interest rate, used for an investment, consisting of payments (negative values) and yields (positive values), which are done sequentially in equal periods.

Example

Formula	Result	Description
=Irr(A0:C0)	1,5	The rate of return for the series of cash flows, specified within the A0:C0 range. The A0:C0 range includes the following values: -1, 1.5, 2.5.