Xnpv(Rate: Double; Values: Array; DateTimes: Array): Double;
| Parameters | Description | Constraints |
| Rate | Discount rate, applied to cash flows. | Must be positive. |
| Values | A set of cash flows, corresponding to the payment schedule, given in the date argument. The first payment is optional and corresponds to the starting investment payment. All the next payments are discounted on the basis of a 365-days year. | It is required to use an array of the Double. |
| DateTimes | A schedule of payment dates, which corresponds to the set 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. | It is required to use an array of the DateTime. |
The Xnpv method returns net present value for cash flows, which do not have to be regular.
The set of Values must contain at least one positive and one negative value.
The Xnpv function is calculated using the following formula:
Where:
di. Date of the i-th (last) payment.
d1. Date of the 0-th payment (start date).
Pi. Sum of the i-th (last) payment.
To execute the example, add a link to the MathFin system assembly.
Sub UserProc;
Var
r: Double;
Values: Array[5] Of Double;
Dates: Array[5] Of DateTime;
Begin
Values[0] := -10000;
Values[1] := 2750;
Values[2] := 4250;
Values[3] := 3250;
Values[4] := 2750;
Dates[0] := DateTime.parse("01.01.2008");
Dates[1] := DateTime.parse("01.03.2008");
Dates[2] := DateTime.parse("01.10.2008");
Dates[3] := DateTime.parse("15.02.2009");
Dates[4] := DateTime.parse("01.04.2009");
r := Finance.Xnpv(0.09, Values, Dates);
Debug.WriteLine(r);
End Sub UserProc;
After executing the example the console window displays the present value equal to 2113.83.
See also: