FV

This method specifies the future value of an annuity based on periodic fixed payments and a fixed interest rate.

Syntax

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

Parameters

financial

Reference to a Financial control.

rate

Required. Variant that specifies the interest rate per period.

nper

Required. Variant that specifies the total number of payment periods in the annuity.

pmt

Required. Variant that specifies the payment to be made each period.

pv

Optional. Variant that specifies the present value, or lump sum, of a series of future payments. If omitted, 0 is assumed.

type

Optional. Variant that specifies when payments are due. Use 0 if payments are due at the end of the payment period or 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

Return Value

Result of the FV calculation.

Remarks

Calculate rate and nper parameters using payment periods expressed in identical units. For example, if you calculate rate using months, you must calculate nper using months.

For all parameters, negative numbers represent cash paid out and positive numbers represent cash received.