Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Sintaxis
XIRR(values, dates, [guess])Argumentos
valuesobligatorio
A series of cash flows that corresponds to a schedule of payments in dates.
datesobligatorio
A schedule of payment dates that corresponds to the cash flow payments.
guessopcional
An optional estimate of what the result of XIRR will be; defaults to 0.1 (10%).
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"})→0.1088Calculates the annual return for an initial investment of 1000 followed by two irregular repayments.
Prepare your data
List your cash flows in one column and their corresponding dates in an adjacent column.
Apply the function
Enter the XIRR function, selecting the values range first, followed by the dates range.
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.