The interest rate per period.
The total number of payment periods in an annuity.
Optionalpmt: number = 0The 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.
Optionalpv: number = 0The 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.
Optionaltype: 0 | 1 = 0The number 0 or 1 and indicates when payments are
due. If type is omitted, it is assumed to be 0. Set type equal to 0
if payments are due at the end of the period. Set type equal to 1 if
payments are due at the beginning of the period.
The future value.
Calculates 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.
Remarks:
rateandnper. For example, for monthly payments on a four-year loan at 12% annual interest, use12%/12forrateand4*12fornper. For annual payments, use12%forrateand4fornper.