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

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




    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)


    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.



    Version Available

    This function is available in product version 2.0 or later.

    See Also

    IRR | XNPV | MIRR | Financial Functions