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.

1
Set the effective rate and compounding frequency Supply the effective annual interest rate and the number of compounding periods per year.
2
Calculate the nominal annual rate NOMINAL finds the periodic rate that reproduces the effective annual rate, then multiplies it by the number of compounding periods per year.

NOMINAL syntax & arguments

Syntax

=NOMINAL(effective_rate, npery)
Required Optional
  1. 1

    effective_rate

    Required

    The positive effective annual interest rate. This is the total annual rate after accounting for compounding within the year.

  2. 2

    npery

    Required

    The 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 by npery to obtain the rate per compounding period.

  • Compounding periods are counted per year

    npery counts compounding periods within one year, regardless of the total term of the loan or investment. For example, a three-year loan with monthly compounding uses 12, not 36.

  • Fractional period counts are truncated

    Excel removes the fractional part of npery. For example, =NOMINAL(6%,12.9) uses 12 compounding periods, not 13. A value below 1 returns #NUM!.

  • The input rate must be positive

    A zero or negative effective_rate returns #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) returns 6%. 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.

Open full problem

Advanced NOMINAL practice problems

Use NOMINAL alongside other Excel functions in realistic, less-prescriptive challenges.

No advanced NOMINAL problems are currently available.