FV( ) Function
Returns the future value of a financial investment.
FV(nPayment, nInterestRate, nPeriods)
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.
Return Value
Numeric
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