Returns
the future value of consistent payment amounts made at regular intervals
at a constant interest rate.
Note: Interest rate calculation methods differ from
country to country. This function calculates an interest rate based
on U.S. interest rate standards.
Parameters
Parameter
|
Description
|
n1
|
A numeric value or expression representing
the payment amount.
|
n2
|
A numeric value or expression representing
the interest per period of the investment.
|
n3
|
A numeric value or expression representing
the total number of payment periods.
|
The function returns an error if either
of the following conditions are true:
ExamplesThe
following expressions are examples of the FV function:
Expression
|
Returns
|
FV(400, 0.10 / 12, 30 * 12)
|
904195.16991842445. This
is the value, after 30 years, of a $400 a month investment growing
at 10% annually.
|
FV(1000, 0.075 / 4, 10 * 4)
|
58791.96145535981. This
is the value, after 10 years, of a $1000 a month investment growing
at 7.5% a quarter.
|
FV(Payment[0], Int_Rate / 4, Time)
|
This example uses variables in place of
actual numeric values or expressions.
|
|
|
|