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.
