NPV function

The NPV function is one of the financial functions. It is used to calculate the net present value of an investment based on a specified discount rate.

Syntax

NPV(rate, value1, [value2], ...)

The NPV function has the following arguments:

Argument	Description
rate	The discount rate.
value1/2/n	Up to 255 arguments representing future payments (negative values) and income (positive values).

Notes

How to apply the NPV function.

Examples

The figure below displays the result returned by the NPV function.