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.