Livecycle

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 of using 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.

CTerm