XNPV
Returns the net present value for a schedule of cash flows that is not necessarily periodic
Syntax
XNPV(rate, values, dates)
Parameters
- rate: Required. The discount rate to apply to the cash flows
- values: Required. A series of cash flows that corresponds to a schedule of payments in dates
- dates: Required. A schedule of payment dates that corresponds to the cash flow payments
Example
=XNPV(0.09, A1:A5, B1:B5)