XIRR Function Explained
The XIRR Function in Microsoft Excel calculates the internal rate of return for a series of cash flows that occur at irregular intervals. It takes two arguments: values (required) and dates (required). The values argument is an array of cash flows, and the dates argument is an array of corresponding dates. The XIRR Function returns the internal rate of return as a decimal number.
XIRR Function Syntax
XIRR(values, dates, [guess])
- values: An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.
- dates: An array or a reference to cells that contain the payment dates associated with the cash flow.
- guess: (optional) A number that you guess is close to the result of XIRR. If omitted, XIRR uses 0.1 (10 percent).