# Documentation/Calc Functions/NPV Under construction. For now, see the system Help files.

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.

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.

IRR

XNPV

FV

PMT

PV

NPER

## ODF standard:

part 2, Section 6.12.30

NPV