◄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►