Skip to content
Property Value
Hex Value $BB01
Categories
Localizations
  • FR: tauxRi(

irr(

Overview

Returns the interest rate at which the net present value of the cash flow is equal to zero.

Availability: Token available everywhere.

Syntax

irr(CF0,CFList[,CFFreq])

Arguments

NameTypeOptional
CF0
CFList
CFFreqYes

Location

apps, 1:Finance, CALC, 8:irr(


Description

The irr( command finds the Internal Rate of Return of an investment, which is a measure of its efficiency. Its mathematical interpretation is the interest rate for which npv( will return 0 for the same cash flows.

irr( takes three arguments: an initial cash flow (CF0), a list of further cash flows (CFList), and an optional frequency list.

Advanced Uses

irr( can be used to find a root of a polynomial of any degree, give by a list of its coefficients:

1+.01irr(0,{list of coefficients})

However, this method is limited to finding roots greater than 0, and will throw an error (ERR:NO SIGN CHG or ERR:DIVIDE BY 0) if it can't find such roots. By reversing the list of coefficients and taking the reciprocal of the roots found, you could find roots less than 0, but this would still result in errors if such roots don't exist either.

Using solve( to find roots of polynomials is less efficient, but more reliable, since it doesn't throw an error unless there are no roots at all to be found.

Formulas

Solving for irr( requires solving a polynomial with degree equal to the total number of cash flows. As such, there is no general formula for calculating irr(, though numerical methods are possible for finding an approximate solution.

The polynomial associated with the calculation is:

(1) \(\begin{align} \sum_{i=0}^{N}{C_i\left(1+\frac{\mathrm{Irr}}{100}\right)^{N-i}}=0 \end{align}\)

Here, Irr is the internal rate of return, N is the number of cash flows, and Ct is the t th cash flow.

To the calculator, only roots for which Irr>0 are considered to be viable.

Error Conditions


Source: parts of this page were written by the following TI|BD contributors: DarkerLine, GoVegan, kg583.

History

Calculator OS Version Description
TI-83 0.01013 Added
Authors: Adrien Bertrand