NPV

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

Syntax

NPV( Number rate, Number value1, Number value2, ... ) → Currency

Parameters

rate

Required. The discount rate over the length of the period.

value1
value2
…

A list of numbers representing payments and income.

Remarks

This function computes the net present value for a series of periodic cash flows with the discount rate rate. The values should be positive if they are received as income, and negative if the amounts are paid as outgo. The result is affected by the order of values.

See Also

Function Reference
FV Function
IRR Function
NPER Function
PMT Function
PV Function