RangeNPV() returns the net present value of an investment based on a discount rate and a series of future periodic payments (negative values) and incomes (positive values). The result has a default number format of money.
For cash flows that are not necessarily periodic, see RangeXNPV - script and chart function.
RangeNPV(discount_rate, value[,value][, Expression])
Return data type: numeric
|discount_rate||The interest rate per period.|
|value||A payment or income occurring at the end of each period. Each value may be a single value or a range of values as returned by an inter-record function with a third optional parameter.|
|Expression||Optional expressions or fields containing the range of data to be measured.|
Text values, NULL values and missing values are disregarded.
Add the example script to your app and run it. To see the result, add the fields listed in the results column to a sheet in your app.
recno() as RangeID,
RangeNPV(Field1,Field2,Field3) as RangeNPV;
LOAD * INLINE [
] (delimiter is '|');