NOMINAL

NOMINAL

Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

Syntax

NOMINAL(effect_rate,npery)

Effect_rate   is the effective interest rate.

Npery   is the number of compounding periods per year.

Remarks

  • Npery is truncated to an integer.
  • If either argument is nonnumeric, NOMINAL returns the #VALUE! error value.
  • If effect_rate £ 0 or if npery < 1, NOMINAL returns the #NUM! error value.
  • NOMINAL is related to EFFECT as shown in the following equation:

Example

NOMINAL(5.3543%,4) equals 0.0525 or 5.25 percent