Documentation/Calc Functions/NPV

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


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.

Net Present Value

Related LibreOffice functions:

IRR

XNPV

FV

PMT

PV

NPER

ODF standard:

part 2, Section 6.12.30

Equivalent Excel functions:

NPV