FV Function

Returns the end-of-period future value for a series of payments given the interest rate, number of periods, payment amount, and initial principal

Syntax

FV(rate, numberOfPeriods, paymentAmount, presentValue)

Returns the end-of-period future value for a series of payments given the interest rate, number of periods, payment amount, and initial principal

Arguments

rate Numeric - the interest rate

numberOfPeriods Numeric - the number of periods

paymentAmount Numeric - the payment made each period

presentValue Numeric - the initial principal amount

Remarks

Example:

FV(0.05, 36, -100, 0); // returns 9583.632