| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. The series of values must contain at least one positive and one negative value. |
| | | The first payment date indicates the beginning of the schedule of payments. All other dates must be later than this date, but they may occur in any order. |
| | | Numbers in dates are truncated to integers. |
| | | If any number in dates is not a valid date, then #NUM! is returned. |
| | | If any number in dates precedes the starting date, then #NUM! is returned. |
| | | If values and dates contain a different number of values, then #NUM! is returned. |
| | | In most cases you do not need to provide guess for the XIRR calculation. |
| | | If "guess" is left blank, then 10% is used. |
| | | XIRR is closely related to XNPV, the net present value function. The rate of return calculated by XIRR is the interest rate corresponding to XNPV = 0. |
