# NPV function

NPV(discountRate, firstNumber, numbers...) NPV(discountRate; firstNumber; numbers...)

## discountRate

Number or { Number }

The discount rate (expressed as a fraction of 1) which applies to one single period. (It is assumed to be constant for all periods.)

## firstNumber

Number or { Number }

The first payment made at the end of a series of fixed length periods.

## numbers

Number or { Number } (accepts many)

Payments made at the end of a series of fixed length periods.

## Returns

Number or { Number }

The net present value of an investment.

Returns the net present value of an investment with regular cash payments.

## Examples

NPV(8.75%, 1000, 2000, 3000)NPV(8,75%; 1000; 2000; 3000)

Returns roughly \$4,943.21. The discount rate 8.75% is the assumed competitive return over one year, and \$1,000 is paid at the end of year one, \$2,000 at the end of year two and \$3,000 at the end of year three.

NPV(8.75%, { 1000, 2000, 3000 })NPV(8,75%; { 1000; 2000; 3000 })

Returns roughly \$4,943.21. The discount rate 8.75% is the assumed competitive return over one year, and \$1,000 is paid at the end of year one, \$2,000 at the end of year two and \$3,000 at the end of year three. The payments can also be expressed as an array.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.