NPV function
DiscountRate
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
The first payment made at the end of a series of fixed length periods.
Numbers
Payments made at the end of a series of fixed length periods.
Returns
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.