FV

Syntax:

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

Description: Computes the future value of an investment based on periodic, constant payments and a constant interest rate.

Arguments:

Name

Type

Description

rate

number

The interest rate.

nper

number

The total number of payment periods, truncated to integer.

pmt

number

The payment made each period; it cannot change over the life of the annuity.
Note: : Typically, pmt contains principal and interest, but no other fees or taxes.
If omitted, pv shall be provided.

pv

number

The the present value, or the lump-sum amount that a series of future payments is worth right now. If omitted, it is assumed to be 0, and pmt shall be provided.

type

number

The timing of the payment, truncated to integer, as follows:

Value

Timing

0

Payment at the end of the period

1

Payment at the beginning of the period

Arguments representing cash paid by investor shall be expressed as negative numbers; arguments representing cash received by the investor shall be expressed as positive numbers.

Return Type and Value: number – The future value of an investment based on periodic, constant payments and a constant interest rate.

However, if type is any number other than 0 or 1, #NUM! is returned.

example: