npv
Net present value of a stream of cash flows.
Syntax
Section titled “Syntax”v = npv(rate, value1, value2, ...)Description
Section titled “Description”Returns the net present value at periodic discount rate rate. Cash flows occur at the end of each period (so value1 is at the end of period 1, not at period 0). To include a period-0 flow, add it un-discounted: npv(rate, ...) + value0.
Example
Section titled “Example”npv(0.1, -10000, 3000, 4200, 6800)