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.
NPV(Rate; Value 1; Value 2; ...; Value 30)
Returns the present value of an investment based on a series of periodic cash flows and a discount rate.
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.
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:
part 2, Section 6.12.30
Equivalent Excel functions: