Public Function UnevenNetPresentValue( _
ByVal vRate As Variant _
, ByVal vValues As Variant _
, ByVal vDates As Variant _
) As Variant
Calculate the Net Present Value for a series of cash flows that may not be periodic. Example: What is the net present value of an investment where $2,000 is paid on 1/1/1996, $3,000 is paid on 4/1/1997, $4,000 is paid on 4/1/1998, and $10,000 is received on 10/1/1999, assuming the annual interest rate is 7%? Approximately $-433.42.
UnevenNetPresentValue(0.07, Array(-2000, -3000, -4000, 10000), Array(#1/1/96#, #4/1/97#, #4/1/98#, #10/1/99#)) = -433.424793708218See also:
XNPV Function (Microsoft Excel)Summary: The net present value of an investment is the current value of a future series of cash flows. This function uses the date that corresponds to each cash flow to determine when the cash flows occurs.
vRate: Discount rate used throughout the investment. For example, 9% would be represented as 0.09.
vValues: One dimensional array of values representing the cash flows. The array must contain at least one payment (a negative value) and at least one receipt (a positive value). Every element of this array is examined and considered to be one cash flow, unlike some other Entisoft Tools functions which examine arrays beginning with element #1.
vDates: One dimensional array of values representing the dates on which the corresponding cash flow occurs.
Initial Cash Flow: The earliest cash flow does not necessarily need to be the first element within the vAmts and vDates array. The cash flows and their corresponding dates do not necessarily need to be in chronological order within these arrays.
Related functions: Use the NetPresentValue function if the cash flows are periodic (they occur at regular intervals). Use the PresentValue function if the cash flows are both fixed (they are all the same amount) and periodic (they occur at regular intervals).
v2.0 Addition: This function is new to this version of Entisoft Tools.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.