FV - Find future value of an investment in Informatica

Syntax
FV( rate, terms, payment [, present value, type] )

ArgumentRequired/OptionalDescription
rateRequiredNumeric. Interest rate earned in each period. Expressed as a decimal number. Divide the percent rate by 100 to express it as a decimal number. Must be greater than or equal to 0.
termsRequiredNumeric. Number of periods or payments. Must be greater than 0.
paymentRequiredNumeric. Payment amount due per period. Must be a negative number present value Optional Numeric. Current value of the investment. If you omit this argument, FV uses 0.
typeOptionalInteger. Timing of the payment. Enter 1 if payment is at the beginning of period. Enter 0 if payment is at the end of period. Default is 0. If you enter a value other than 0 or 1, the Integration Service treats the value as 1.