Visual Basic for Applications Reference
NPV Function
Returns a Double specifying the net present value of an investment based on
a series of periodic cash flows (payments and receipts) and a discount rate.
Syntax
NPV(rate, values())
The NPV function has these named arguments:
Part Description
rate Required. Double specifying discount rate over the length of the
period, expressed as a decimal.
values() Required. Array of Double specifying cash flow values. The array
must contain at least one negative value (a payment) and one positive value
(a receipt).
Remarks
The net present value of an investment is the current value of a future
series of payments and receipts.
The NPV function uses the order of values within the array to interpret the
order of payments and receipts. Be sure to enter your payment and receipt
values in the correct sequence.
The NPV investment begins one period before the date of the first cash flow
value and ends with the last cash flow value in the array.
The net present value calculation is based on future cash flows. If your
first cash flow occurs at the beginning of the first period, the first value
must be added to the value returned by NPV and must not be included in the
cash flow values of values( ).
The NPV function is similar to the PV function (present value) except that
the PV function allows cash flows to begin either at the end or the
beginning of a period. Unlike the variable NPV cash flow values, PV cash
flows must be fixed throughout the investment.
Dana E. Johnson
Sr. Web Developer
CIT
VTF/Technology Financing Services
[EMAIL PROTECTED]
(904) 620-7458
-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 9:11 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Net Present Value NPV()
I don't have a VB manual in fron of me, what does NPV do?
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: Johnson, Dana [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 9:43 AM
To: '[EMAIL PROTECTED]'
Subject: Net Present Value NPV()
does anybody have a workaround for the VB function NPV() for use in cold
fusion.
Dana E. Johnson
Sr. Web Developer
CIT
VTF/Technology Financing Services
[EMAIL PROTECTED]
(904) 620-7458
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
