CTerm

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.