Excel NOMINAL Function
NOMINAL converts an effective annual interest rate into a nominal annual rate for a specified compounding frequency.
Use it to find the nominal annual quote that produces a known effective annual rate when interest compounds within the year.
NOMINAL syntax & arguments
Syntax
=NOMINAL(effective_rate, npery)
-
1
effective_rate
RequiredThe positive effective annual interest rate. This is the total annual rate after accounting for compounding within the year.
-
2
npery
RequiredThe number of compounding periods per year. The value must be at least 1. Fractional values are truncated to an integer.
Example
=NOMINAL(6%,12)
Return the nominal annual interest rate corresponding to an effective annual rate of 6% with monthly compounding.
NOMINAL caveats
-
The input and result are both annual rates
Supply the effective annual rate. NOMINAL returns the equivalent nominal annual rate for the compounding frequency specified by
npery. Divide the result bynperyto obtain the rate per compounding period. -
Compounding periods are counted per year
nperycounts compounding periods within one year, regardless of the total term of the loan or investment. For example, a three-year loan with monthly compounding uses12, not36. -
Fractional period counts are truncated
Excel removes the fractional part of
npery. For example,=NOMINAL(6%,12.9)uses12compounding periods, not13. A value below1returns#NUM!. -
The input rate must be positive
A zero or negative
effective_ratereturns#NUM!. For example,=NOMINAL(0,12)returns an error rather than a zero rate. -
The two rates match with annual compounding
With
npery=1, there is no compounding within the year, so the nominal and effective rates are equal. For example,=NOMINAL(6%,1)returns6%. With more than one compounding period and a positive rate, the nominal annual rate is lower than the effective annual rate.
Need the reverse conversion? Use EFFECT to convert a nominal annual rate to an effective annual rate for a specified compounding frequency.
Intro NOMINAL practice problem
Solve the intro problem directly here, or open it on its own page.
Advanced NOMINAL practice problems
Use NOMINAL alongside other Excel functions in realistic, less-prescriptive challenges.
No advanced NOMINAL problems are currently available.