Returns the net present value of an investment based on the specified series of periodic cash flows and the specified discount rate.
Syntax
 Copy Code
|
|---|
NPV( Number rate, Number value1, Number value2, ... ) → Currency |
Parameters
- rate
- Required. The discount rate over the length of the period.
- value1
value2
… - A list of numbers representing payments and income.
Remarks
This function computes the net present value for a series of periodic cash flows with the discount rate rate. The values should be positive if they are received as income, and negative if the amounts are paid as outgo. The result is affected by the order of values.
See Also
Function Reference
FV Function
IRR Function
NPER Function
PMT Function
PV Function