Net Present Value - Data360_Analyze - 3.12

Data360 Analyze Server Help

Product
Data360 Analyze
Version
3.12
Language
English
Portfolio
Verify
Product family
Data360
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

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.