NPV Function

Returns the net present value with the rate expressed as a percentage.

Category: Financial
Returned data type: DOUBLE

Syntax

NPV(r, freq, c0, c1, ..., cn)

Arguments

r

is numeric, the interest rate over a specified base period of time expressed as a percentage.

Data type DOUBLE

freq

is numeric, the number of payments during the base period of time specified with the rate r.

Range freq > 0
Data type DOUBLE
Note The case freq = 0 is a flag to allow continuous discounting.

c0, c1, ..., cn

are numeric cash flows that represent cash outlays (payments) or cash inflows (income) occurring at times 0, 1, ...n. These cash flows are assumed to be equally spaced, beginning-of-period values. Negative values represent payments, positive values represent income, and values of 0 represent no cash flow at a given time. The c0 argument and the c1 argument are required.

Data type DOUBLE

Comparisons

The NPV function is identical to NETPV, except that the r argument is provided as a percentage.

Example

The following statement illustrates the NPV function:
Statements
Results
select npv(1,2,3,4,5,6,7,8);
32.50727639

See Also

Functions:
Last updated: February 23, 2017