# Documentation/Calc Functions/NPV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

NPV

## Category:

Financial Analysis

## Summary:

**NPV** stands for *Net Present Value*. Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.

## Syntax:

NPV(**Rate**; **Value 1**; **Value 2**; ...; **Value 30**)

## Returns:

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

## Arguments:

**Rate** is the discount rate for a period.

**Value 1**, **Value 2**, ..., **Value 30** are up to 30 values, which represent deposits or withdrawals.

## Additional details:

If the payments take place at irregular intervals, use the XNPV function.

## Examples:

What is the net present value of periodic payments of 10, 20, and 30 currency units with a discount rate of 8.75%. At time zero the costs were paid as -40 currency units.

=NPV(8.75%;10;20;30) = 49.43 currency units. The net present value is the returned value minus the initial costs of 40 currency units, therefore 9.43 currency units.

## Related LibreOffice functions:

## ODF standard:

part 2, Section 6.12.30

## Equivalent Excel functions:

NPV