Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
XIRR(values, dates, [guess])XIRR calculates the annual internal rate of return for an investment with irregular payment dates. It is more flexible than the IRR function because it accounts for specific dates associated with each cash flow.
=XIRR({-1000, 300, 800}, {"2023-01-01", "2023-06-01", "2024-01-01"})Result: 0.1088
Calculates the annual return for an initial investment of 1000 followed by two irregular repayments.
This usually happens if the cash flows do not contain at least one positive and one negative value, or if the calculation fails to converge.