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.
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.