NPV# Function
◄Summary► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
Financial Functions available in Professional Edition only
──────────────────────────────────────────────────────────────────────────────
Returns the net present value of an investment based on a series of periodic
cash flows (payments and receipts) and a discount rate. Requires FINANCE.QLB
(FINANCE.LIB when compiling); include FINANCE.BI.
NPV# (rate#, valuearray#(), valuecount%, status%)
■ rate# Discount rate over the length of the period,
expressed as a decimal
■ valuearray#() Array of cash flow values
■ valuecount% Total number of cash flow values
■ status% Variable that returns a value indicating calculation
failure or success:
0 = success
1 = failure
See Also
◄Financial Function Summary► ◄$INCLUDE Metacommand► ◄Quick Libraries►