NETPV Function

Returns the net present value as a percent.

Category:	Financial
Returned data type:	DOUBLE

Syntax

Arguments

Details

Example

Syntax

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

Arguments

r

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

Range	r >= 0
Data type	DOUBLE

freq

is numeric, the number of payments during the base period of time that is 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

Details

The NETPV function returns the net present value at time 0 for the set of cash payments c0,c1, ...,cn, with a rate r over a specified base period of time. The argument freq>0 describes the number of payments that occur over the specified base period of time.

The net present value is given by the equation:

table with 1 row and 1 column , row1 column 1 , n e t p v . open r comma f r e q comma , c sub 0 , comma , c sub 1 , comma . . . comma , c sub n , close . equals . modified cap sigma with i equals 0 below and with n above . c sub i , x to the i , end table

The following relationship applies to the preceding equation:

$table with 1 row and 1 column , row1 column 1 , x equals left brace . table with 2 rows and 2 columns , row1 column 1 , fraction 1 , over open 1 plus r close super open 1 slash f r e q close end super end fraction , column 2 f r e q greater than 0 , row2 column 1 , epsilon super negative r end super , column 2 f r e q equals 0 , end table , end table$

Missing values in the payments are treated as 0 values. When freq>0, the rate r is the effective rate over the specified base period. To compute with a quarterly rate (the base period is three months) of 4% with monthly cash payments, set freq to 3 and set r to .04.

If freq is 0, continuous discounting is assumed. The base period is the time interval between two consecutive payments, and the rate r is a nominal rate.

To compute with a nominal annual interest rate of 11% discounted continuously with monthly payments, set freq to 0 and set r to .11/12.

Example

For an initial investment of $500 that returns biannual payments of $200, $300, and $400 over the succeeding 6 years and an annual discount rate of 10%, the net present value of the investment can be expressed as follows:

select netpv(.10,.5,-500,200,300,400);

The value that is returned is 95.982864829.

NETPV Function

Syntax

Arguments

r

freq

c0, c1 ,..., cn

Details

Example

See Also