Calculates the Net Present Value (NPV) of an investment based on the discount rate and a set of future payments and income in the input data set.
Note: This node has been superseded by the Net Present Value node which provides similar functionality, but the underlying code is Python rather than Data360 Analyze Script. The Net Present Value (Superseded) node is provided for backwards compatibility, but where possible it is recommended that you use the new Net Present Value node.
Properties
InputField
Specify the field used to calculate the Net Present Value.
A value is required for this property.
DiscountRate
Specify the rate used to discount future cash flows to the present value.
Note: If the DiscountRate is set to a field name then the first record found will be used as the discount rate.
A value is required for this property.
InitialInvestment
Optionally specify the field used to indicate whether the first record in the input dataset represents the initial investment or not.
The default value is False.
Inputs and outputs
Inputs: in1.
Outputs: out1.