NPV
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
Syntax
NPV(rate, value1, [value2], ...)
Parameters
- rate: Required. The rate of discount over the length of one period
- value1: Required. The first cash flow
- value2: Optional. Additional cash flows, up to 254
Example
=NPV(0.1, -10000, 3000, 4200, 6800)