ClassMicrosoft.VisualBasic.Financial SyntaxDim result As Double = NPV(rate, valueArray( ))
DescriptionThe NPV function calculates the net present value of an investment based on a series of periodic variable cash-flow events (payments and receipts) and a discount rate. The net present value is the value today of a series of future cash-flow events discounted at some rate back to the first day of the investment period. Usage at a Glance
See AlsoFV Function, IPmt Function, NPer Function, Pmt Function, PPmt Function, PV Function, Rate Function |