NOMINAL:
Returns the annual nominal interest rate
The NOMINAL function returns the annual nominal interest rate.
NOMINAL takes
2 required arguments and
no optional arguments:
Syntax: NOMINAL(effect_rate,
npery)
Using the NOMINAL function:
The arguments for the NOMINAL function are:
Argument

Required?

Description

effect_rate 
Required 
The effective interest rate 
npery 
Required 
The number of compounding periods per year. 
• npery is truncated to an integer. 
• If either argument is nonnumeric, NOMINAL returns the #VALUE! error value. 
• If nominal_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value. 
• NOMINAL (effect_rate,npery) is related to EFFECT(nominal_rate,npery) through effective_rate=(1+(nominal_rate/npery))*npery 1. 
The NOMINAL function returns the annual nominal interest rate.