FV( ) Function

Example   See Also

Returns the future value of a financial investment.

Syntax

FV(nPayment, nInterestRate, nPeriods)

Returns

Numeric

Arguments

nPayment

Specifies the constant periodic payment (which can be negative or positive).

nInterestRate

Specifies the periodic interest rate. If the interest rate is annual but the payments are made monthly, divide the annual interest rate by 12.

nPeriods

Specifies the number of periods over which payments are made. FV( ) assumes that the periodic payments are made at the end of each period.

Remarks

FV( ) computes the future value of a series of constant periodic payments earning fixed compound interest. The future value is the total of all payments and the interest.