Returns the present value for a schedule of cash flows that is not necessarily periodic.
XNPV(<table>, <values>, <dates>, <rate>)
|table||A table for which the values and dates expressions should be calculated.|
|values||An expression that returns the cash flow value for each row of the table.|
|dates||An expression that returns the cash flow date for each row of the table.|
|rate||The discount rate to apply to the cash flow for each row of the table.|
Net present value.
The value is calculated as the following summation:
The series of cash flow values must contain at least one positive number and one negative number.
The following calculates the present value of the CashFlows table:
Present value := XNPV( CashFlows, [Payment], [Date], 0.09 )
Present value = 2086.65