Payments are expressed as negative values and income as positive values.
If the first value is a cost or payment, it must be a negative value.
Subsequent payments are discounted based on a 365-day year.
XIRR is related to theXNPV function.
The rate returned by XIRR is the interest rate when XNPV = 0.
The XIRR function uses iteration to arrive at a result.
If no result is found after 100 tries, XIRR returns the #NUM!
The XIRR function takes threearguments:values,dates, andguess.Valuesrepresent a series of cash flows.
The first value is optional and corresponds to a cost at the beginning of the investment.
Ifvaluescontains any non-numeric values, XIRR returns a #VALUE!
Thedatesargument represents a schedule of dates that correspond tovalues.
The values supplied fordatesmust be validExcel dates.
Datesdo notneed to be entered in chronological order.
Typically,datesis supplied as arange.
If any date is not recognized as a date, XIRR returns a #VALUE!
Theguessargument is optional and represents the seed value to start with for the iterative calculation used by XIRR.
If not provided,guessdefaults to 10% (0.10).
Typically, you’re able to safely omitguess.
