EFFECTIVE( ) function

Returns the effective annual interest rate on a loan.

Syntax

EFFECTIVE(nominal_rate, periods)

Parameters

Name Type Description
nominal_rate numeric The nominal annual interest rate.
periods numeric

The number of compounding periods per year.

Note

Specify an integer. If you specified a decimal portion, it is truncated.

Output

Numeric. The rate is calculated to eight decimals places.

Examples

Basic examples

Returns 0.19561817 (19.56%), the effective annual rate of interest on the unpaid balance of a credit card that charges 18% per annum, compounded monthly:

EFFECTIVE(0.18, 12)

Remarks

What is the effective annual interest rate?

The effective annual interest rate on a loan is the actual annual rate of interest paid, taking into account interest on the remaining balance, compounded monthly or daily.

Related functions

The NOMINAL( ) function is the inverse of the EFFECTIVE( ) function.

ACL Scripting Guide 14.1