NPV Function

Returns the net present value of an investment


Description

The function NPV returns a value specifying the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate.


Syntax

NPV (Rate, ValueArray)


Required Parameters

Rate

The discount rate over the length of the period, expressed as a decimal.


ValueArray

Array of Double specifying cash flow values. The array must contain at least one negative value (a payment) and one positive value (a receipt).