The XIRR function returns the internal rate of return for scheduled cash flows that are not necessarily periodic.
Syntax
XIRR(
table,
values,
dates
[, guess]
)
Parameters
- table: Table for which the expressions of the values and dates will be calculated.
- values: Expression that returns the cash flow values for each row of the table.
- dates: Expression that returns the dates of the cash flows for each row of the table.
- guess: Optional argument. Initial estimate for the internal rate of return. If omitted, the default value of 0.1 is used.
Returned value
The XIRR function returns a real number.
Additional Information
The result is calculated as the rate that satisfies the following function:
Where Pj is the j-th payment, dj is the date corresponding to the j-th payment and d1 is the date of the first payment.
The set of cash flows must have at least one positive value and one negative value.
Examples
If we have the following cash flows:
We can calculate the internal rate of return with the following measure:
TIR = XIRR(Pagos, Pagos[Pago], Pagos[Fecha])
Related functions
Category
Statistical
