Livecycle

Apr

Returns the annual percentage rate for a loan.

Note:

Interest rate calculation methods differ from country to country. This function calculates an interest rate based on U.S. interest rate standards.

Syntax

Apr(n1, n2, n3)

Parameters

 

Parameter	Description
n1	A numeric value or expression representing the principal amount of the loan.
n2	A numeric value or expression representing the payment amount on the loan.
n3	A numeric value or expression representing the number of periods in the loan’s duration.

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 Apr function:

 

Expression	Returns
Apr(35000, 269.50, 360)	0.08515404566 for a $35,000 loan repaid at $269.50 a month for 30 years.
Apr(210000 * 0.75, 850 + 110, 25 * 26)	0.07161332404
Apr(-20000, 250, 120)	Error
Apr(P_Value, Payment, Time)	This example uses variables in place of actual numeric values or expressions.

Apr