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
В | Copy Code |
---|---|
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 |