XIRR
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
Syntax
XIRR(values, dates, [guess])
Parameters
- values: Required. A series of cash flows that corresponds to a schedule of payments in dates
- dates: Required. A schedule of payment dates that corresponds to the cash flow payments
- guess: Optional. A number that you guess is close to the result (default 0.1)
Example
=XIRR(A1:A5, B1:B5, 0.1)