Returns the internal rate of return for a series of cash flows represented by the numbers in values.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
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})Kết quả: 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.