Returns the internal rate of return for a series of cash flows represented by the numbers in values.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
IRR(values, [guess])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})Résultat : 0.0889
Calculates the internal rate of return for an initial investment of 1000 followed by three annual returns.
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.