Financial

NOMINAL Function in Excel

Returns the annual nominal interest rate.

Syntax

  • =NOMINAL(effect_rate, npery)

Arguments

  • effect_rate (required): Effective annual rate
  • npery (required): Compounding periods per year

Examples

  • =NOMINAL(0.0535, 4) - Nominal rate - Result: 0.0525

Excel NOMINAL function documentation

  • NOMINAL returns the nominal annual interest rate given an effective annual rate and compounding periods.
  • Syntax: =NOMINAL(effect_rate, npery).
  • Use NOMINAL when contracts quote periodic compounding conventions but planning starts from effective returns.
  • Related formulas: [EFFECT](/functions/effect/), [PMT](/functions/pmt/), [PV](/functions/pv/), [Financial functions](/categories/financial/).

NOMINAL arguments and practical notes

  • effect_rate must be positive and expressed as decimal annual effective rate.
  • npery is compounding periods per year and must be >= 1.
  • NOMINAL is inverse-oriented relative to EFFECT under consistent assumptions.
  • Always document compounding frequency to avoid reporting confusion.

Step-by-step: derive contract rate from target effective return

  • Step 1 — Set target effective annual rate in B1.
  • Step 2 — Set desired compounding periods per year in B2.
  • Step 3 — Compute nominal quote with =NOMINAL(B1,B2).
  • Step 4 — Verify round trip using =EFFECT(NOMINAL(B1,B2),B2).
  • Step 5 — Use resulting nominal rate in downstream payment projections.

NOMINAL vs EFFECT in modeling

  • NOMINAL converts effective annual to stated annual with compounding convention.
  • EFFECT converts stated annual to effective annual.
  • Neither function builds full amortization schedules by itself.
  • For cash-flow valuation, combine rate conversions with [NPV](/functions/npv/) or [IRR](/functions/irr/).

Worked examples to copy

  • Monthly compounding nominal: =NOMINAL(0.1268,12).
  • Quarterly contract rate: =NOMINAL(0.0824,4).
  • Daily convention proxy: =NOMINAL(0.075,365).
  • Check conversion consistency: =EFFECT(NOMINAL(eff,n),n).

People also ask

  • Why is NOMINAL lower than effective? — Effective includes compounding impact.
  • Can NOMINAL return errors? — Yes if effect_rate <= 0 or npery < 1.
  • Should I report nominal or effective? — Depends on contract and compliance context; often both.
  • How to compare investments? — Normalize rates, then evaluate cash flows with [NPV](/functions/npv/).

Common errors

  • #NUM! if npery < 1

Use cases

  • Rate conversion
  • APR calculation
  • Loan comparison

Frequently asked questions

  • What is NOMINAL used for? NOMINAL converts an effective annual rate (APY) back to a nominal rate (APR) for a given compounding frequency. If you know the true annual yield and need the stated rate, NOMINAL calculates it. It's the inverse of EFFECT.
  • How do I find the APR from APY? Use =NOMINAL(APY, compounding_periods). If a savings account yields 5.12% APY with monthly compounding: =NOMINAL(0.0512, 12) = 5.00% APR. Banks advertise APY; NOMINAL helps you find the underlying nominal rate.
  • When would I need to convert APY to APR? When comparing to loans (usually quoted as APR), when calculating periodic interest amounts, or when the nominal rate is needed for other calculations. Monthly interest = NOMINAL(APY, 12) / 12 × principal.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use NOMINAL

  • Rate conversion — common Financial scenario for NOMINAL.
  • APR calculation — common Financial scenario for NOMINAL.
  • Loan comparison — common Financial scenario for NOMINAL.

NOMINAL in the Financial category

  • Browse all Financial functions at /categories/financial/ for related formulas.
  • NOMINAL syntax: =NOMINAL(effect_rate, npery)
  • effect_rate (required): Effective annual rate
  • npery (required): Compounding periods per year
  • Confirm NOMINAL arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm NOMINAL arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • EFFECT (/functions/effect/): Returns the effective annual interest rate.
  • RATE (/functions/rate/): Returns the interest rate per period of an annuity.

Errors to watch for

  • #NUM! if npery < 1 — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter NOMINAL on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

NOMINAL worked examples to copy

  • =NOMINAL(0.0535, 4) — Nominal rate. Expected result: 0.0525.

NOMINAL reference summary for crawlers and offline review

  • NOMINAL belongs to the Financial category in Excel. Returns the annual nominal interest rate.
  • Full syntax: =NOMINAL(effect_rate, npery). Open /functions/nominal/ for parameters, FAQs, and related pages.
  • Common mistakes: #NUM! if npery < 1
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.