XIRR Calculator

The XIRR is the modification of IRR (Internal Rate of Return) for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function.

The XIRR function syntax has the following arguments:

• Payments Required. A series of cash flows that corresponds to a schedule of payments in dates. The first payment is negative number and corresponds to a cost or payment that occurs at the beginning of the investment. The series of values must contain at least one positive and one negative value.

• Dates Required. A schedule of payment dates that corresponds to the cash flow payments. Dates may occur in any order. Dates should be entered by using the DATE widget.

Note

• If any number in dates is not a valid date, XIRR returns the error value.

• Guess is assumed to be 0.1 (10 percent).

• The calculate uses an iterative technique for calculating XIRR. Using a changing rate (starting with guess), XIRR cycles through the calculation until the result is accurate within 0.000001 percent. The XIRR formula is: where:

Where

di = the ith payment date

d1 = the 0th payment date

Pi = the ith payment