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 that use 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.