NPV

Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.

Parameter List

Syntax
NPV(discountcashflow1)
discount

The discount rate of the investment over one period. For example: 8% or 0.08.

cashflow1

The first cash flow. For example: 200.

Examples

NPV(8%, A1, A2:A5) returns $3,201.1