# 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

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.

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.