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.
Syntax
FV(
n1
,
n2
,
n3
)
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:
Either of
n1
or
n3
are
negative or 0.
n2
is negative.
If any of the parameters
are null, the function returns null.
Note:
FormCalc
follows the IEEE-754 international standard when handling floating
point numeric values. For more information, see
Number literals
.
Examples
The
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.
