Negative values represent cash paid out; positive values represent cash received.
The first date indicates the beginning of the schedule of payments and must be the earliest date.
Subsequent dates may occur in any order.
Enterrateas a percentage like 6% or the decimal value 0.06.
Valuesrepresent a series of cash flows that correspond todates.
The first value is optional and corresponds to a cost at the beginning of the investment.
If the first value is a cost or payment, it must be a entered as a negative number.
Thedatesargument represents a schedule of dates that correspond tovalues.
The values supplied fordatesmust be validExcel dates.
The first payment date indicates the beginning of the schedule of payments and must be the earliest date.
Other dates must be later than this date, butdo notneed to be in chronological order.
Typically,datesis supplied as arange.
XNPV does not discount the initial cash flow.
Subsequent payments are discounted based on a 365-day year.
The XIRR function uses iteration to arrive at a result.
