XNpv(rate, values, dates, I)
Computes the net present value (NPV) of a non-periodic cash flow with constant discount rate.
- «rate»: the annual discount rate for a 365 day year.
- «values»: indexed by «I» and contains the cash flow amounts, with positive values indicating inflows (payments received) and negative values indicating outflows (payments made).
- «dates»: also be indexed by «I» and contains the date in which each payment is made. The date is expressed as the number of days since the date origin (e.g., Jan 4, 1904). The first date is the reference date, which received no discounting.
- «I»: The index shared by «values» and «dates».