XIRR

This function calculates the internal rate of return for a schedule of cash flows that may not be periodic.

Syntax

XIRR(values, dates, guess)

This function has these arguments:

Argument	Description
values	Series of cash flows that correspond to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment
dates	Schedule of payment dates that correspond to the cash flow payments in values
guess	[Optional] Estimate of the internal rate of return that you guess is close to the result of this function; if omitted, the calculation uses 0.1 (10 percent)

For a schedule of cash flows that is periodic, use IRR. Numbers in dates are truncated to integers.

Both a positive and negative cash flow is required to prevent a #NUM! error.

The function returns an error in the following cases:

If dates is invalid, a #VALUE! error is returned.
If a number in dates precedes the starting date, a #NUM! error is returned.
If values and dates contain a different number of values, a #NUM! error is returned.
If the function can not find a result that works after 100 tries, a #NUM! error is returned.

Accepts numeric data for values and guess, DateTime object data for dates. Returns numeric data.

XIRR(B2:B6,C2:C6,0.2)