Documentation/Calc Functions/NPV

Function name:
NPV

Category:
Financial Analysis

Summary:
NPV stands for Net Present Value. The function calculates 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; Number 1 [; Number 2 [; … [; Number 254]])

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

Arguments:
Rate is a real number(expressed as a percentage or fraction) or a reference to the cell containing that number which is the discount rate for a period.

Number 1, Number 2, … ,Number 254 are real numbers, references to cells or to cell ranges of numbers.


 * If Rate is -100% or -1 then the function returns a numeric (#NUM!) error.

Additional details:

 * The formula for NPV is:


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

Related LibreOffice functions:
FV

IRR

NPER

PMT

PV

XNPV

ODF standard:
Section 6.12.30, part 2

Equivalent Excel functions:
NPV