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