XIRR
Description
Returns the internal rate of return for a specified series of cash flows that is not necessarily periodic.
Syntax
XIRR(
values
,
dates
, [
guess
])
- values: The array or reference to a range of cells containing the cash flow information.
- dates: The dates corresponding to the cash flows.
- guess: The estimated rate of return. The default is 0.1 (10%).