|
Returns
the number of periods needed for an investment earning a fixed,
but compounded, interest rate to grow to a future value.
Note:
Interest rate calculation methods differ from
country to country. This function calculates an interest rate based
on U.S. interest rate standards.
Syntax
CTerm(
n1
,
n2
,
n3
)
Parameters
|
Parameter
|
Description
|
|
n1
|
A numeric value or expression representing
the interest rate per period.
|
|
n2
|
A numeric value or expression representing
the future value of the investment.
|
|
n3
|
A numeric value or expression representing
the amount of the initial investment.
|
If any parameter is null, the function
returns null. If any parameter is negative or 0, the function returns
an error.
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 that use the
CTerm
function:
|
Expression
|
Returns
|
|
CTerm(0.02, 1000, 100)
|
116.2767474515
|
|
CTerm(0.10, 500000, 12000)
|
39.13224648502
|
|
CTerm(0.0275 + 0.0025, 1000000, 55000 * 0.10)
|
176.02226044975
|
|
CTerm(Int_Rate, Target_Amount, P_Value)
|
This example uses variables in place of
actual numeric values or expressions.
|
|
|
|
