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.