FV function

This topic describes the formula syntax and usage of the FV function in the Data Quality Execute Formula transform.

Description

Returns the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment.

Syntax

FV(rate,nper,pmt,[pv],[type])

The FV function syntax has the following arguments:

rate Required. The interest rate per period.
nper Required. The total number of payment periods in an annuity
pmt Required. The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.
pv Optional. The present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument.
type Optional. The number 0 or 1 and indicates when payments are due. Set this to 0 if at the beginning of the period. Set this to 1 if at the end of the period. If type is omitted, it is assumed to be 0.