Public Function NetPresentValue( _ ByVal vRate As Variant _ , ByVal vValues As Variant _ ) As Variant
NetPresentValue(0.07, Array(-3000, -4000, 10000)) - 2000 = -134.51446194133Example: What is the net present value of an transaction where $2,000 is received at the end of year one, $3,000 is received at the end of year two, $4,000 is received at the end of year three, and $10,000 is paid at the end of year four, assuming the annual interest rate is 7%? Approximately $125.71.
NetPresentValue(0.07, Array(2000, 3000, 4000, -10000)) = 125.714450412458See the NetPresentValueVerify Subroutine for more examples of this Function.
UnevenNetPresentValue Function PresentValue Function InternalRateOfReturn Function ModifiedInternalRateOfReturn Function UnevenInternalRateOfReturn Function XIRR Function NPV Function (Visual Basic) NPV 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 order of the values within the array vValues as the order of the payments and receipts. The investment begins one period before the the first cash flow in vValues. If the first cash flow occurs at the beginning of the first period, that first value must be added to the value returned by this function and must not be included in the cash flow values array vValues.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.