,Xnpv(Rate, Values, Dates)
Rate. The discount rate to apply to the cash flows.
Values. The range of cells that contains values of cash flows corresponding to payment schedule given in the DateTimes parameter. The first payment is optional and corresponds to the starting investment payment. All subsequent payments are discounted based on the 365-day year. The sequence of values must contain at least one positive cash flow and one negative cash flow.
Dates. Payment date schedule corresponding to a series of cash flows. The first date is the starting one in the payment schedule. All the other dates must be later than this date, but can have arbitrary order.
NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.
It returns the net present value of cash flows that are optionally periodic.
The Xnpv function is calculated using the following formula:
,
where:
di. Date of the i-th or the last payment.
d1. Date of the zero or first payment.
Pi. Sum of thei-th or last payment.
Rate. Rate.
| Formula | Result | Description |
| =Xnpv(0.09, A0:E0, A1:E1) | 2086,65 | Net present value of cash flows based on the discounting rate 0.09 and the payment value specified within the cell range A0:E0. Payment date schedule is given within the A1:E1 cell range. The A0:E0 range includes the following values: -10.000, 2.750, 4.250, 3.250, 2.750. The A0:E0 range includes the following values: 01.01.2008, 01.03.2008, 03.10.2008, 15.02.2009, 01.04.2009. |
See also:
Function Wizard │Financial Functions │Npv │Pv