Spread Formula Reference
Formula Functions / Functions T to Z / XIRR
In This Topic
    XIRR
    In This Topic

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

    Syntax

    XIRR(values,dates,guess)

    Arguments

    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 corresponds 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)

    Remarks

    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 are required to prevent a #NUM! error. A #VALUE! error is returned if dates is invalid. 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.

    Data Types

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

    Examples

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

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    IRR | XNPV | MIRR | Financial Functions