Important Notice
The pages on this site contain documentation for very old MS-DOS software,
purely for historical purposes.
If you're looking for up-to-date documentation, particularly for programming,
you should not rely on the information found here, as it will be woefully
out of date.
NPV# Function Details
◄Summary► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back►
─────────────────────────────────────────────────────────────────────────────
NPV# (rate#, valuearray#(), valuecount%, status%)
Usage Notes
■ The differences between NPV# and PV# are:
PV# cash flows NPV# cash flows
═══════════════════════════════ ═════════════════════════════════
• Begin at the end or the start • Occur at the end of the period
of the period
• Are constant throughout the • Are variable
investment
■ The argument rate# is the interest rate per period. For example, if you
get a car loan at a 10% annual interest rate and make monthly payments,
the rate per period would be .10/12, or .0083.
■ The argument valuearray#() must contain at least one negative value (a
payment) and one positive value (a receipt).
■ The argument status% can be any variable that returns information about
the success or failure of the calculation. The value of status% will be
0 if the calculation was successful, and 1 if it was not.
■ The net present value of an investment is today's value of a future
series of payments (negative values) and receipts (positive values).
■ The cash flow values must be equally spaced in time and occur at the
end of each period.
■ NPV# uses the order of values within the array to interpret the order
of cash flows. 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 in the list.
■ The NPV# 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 NPV# result, not included in the cash flow values of
valuearray#().