Calculates the internal rate of return for an investment where the payments occur at regular intervals, such as monthly or annually.
Sample Usage
IRR(A3:A7)
Syntax
IRR(values, [guess])
- values - The series of payments entered as a cell reference.
- guess - [OPTIONAL] Estimated internal rate of return value. The default is 10%.
Examples
IRR(A3:A7) calculates the internal rate of return for payments A3:A7, with an internal rate of return value of 10%.
Notes
- If the days specified in dates are at an irregular interval, use XIRR instead.
- Each cell in values should be positive if it represents income from the perspective of the owner of the investment or negative if it represents payments.
- values must contain at least one negative and one positive cash flow to calculate rate of return.