Partilhar via

FV( ) Function

  • Artigo

Returns the future value of a financial investment.

FV(nPayment, nInterestRate, nPeriods)

Return Values

Numeric

Parameters

  • 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.

Example

STORE 500 TO gnPayment  && Monthly payment
STORE .075/12 TO gnInterest     && 7.5% annual interest rate
STORE 48 TO gnPeriods  && Four years (48 months)

CLEAR
? FV(gnPayment, gnInterest, gnPeriods)    && Displays 27887.93

See Also

CALCULATE | PV( ) | STORE Command