◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
NPV# (rate#, valuearray#(), valuecount%, status%)
 
    ■ rate#             The discount rate over the length of the period,
                        expressed as a decimal.
    ■ valuearray#()     An array of cash flow values.
    ■ valuecount%       The total number of cash flow values.
    ■ status%     A variable that returns a value indicating calculation
                  failure or success: 0 = success; 1 = failure.
 
Returns
    The net present value of an investment based on a series of periodic
    cash flows (payments and receipts) and a discount rate.
 
See Also    ◄FV#►    ◄IRR#►    ◄PV#►