NPV()

Returns the net present value for series of values and specified interest rate. Input numericExpression should have a value for every time step; missing values will be treated as 0.

Syntax

NPV(expression, rate)

• expression: signal expression
• rate:  interest rate in decimal fraction

Example

NPV("oil production rate" in "m3/h", 0.15)

NPV Overload to specify a start date

Returns the net present value for series of values and specified rate from the specified start date forward to the end of the scope. Input numericExpression should have a value for every time step; missing values will be treated as 0.

Calculates a forward NPV value from that time step.

Syntax

NPV(expression, Rate, Time Step)

Example

NPV("cash flow" in "USD", 0.15, CurrentStep())

NPV(Column "Cash flow" in "USD", 0.10, CurrentStep())