Returns the internal rate of return for a series of cash flows represented by the numbers in values.
Sintaxe
IRR(values, [guess])Argumentos
valuesobrigatório
An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.
guessopcional
A number that you guess is close to the result of IRR; defaults to 0.1 (10%).
The internal rate of return is the interest rate received for an investment consisting of payments and income that occur at regular periods. IRR is calculated using an iterative method, starting with the guess provided, and cycles through the calculation until the result is accurate within 0.00001 percent.
=IRR({-1000, 300, 400, 500})→0.0889Calculates the internal rate of return for an initial investment of 1000 followed by three annual returns.
Prepare cash flow data
List your initial investment as a negative number followed by the subsequent periodic returns in a contiguous range of cells.
Apply the IRR function
Select a cell and enter =IRR(range), referencing the cells containing your cash flow data.
This usually happens if the function cannot find a result after 20 iterations, or if the cash flows do not contain at least one negative and one positive value.