NOMINAL Function

Converts an effective annual rate into the quoted rate for a compounding frequency.

Category

Financial

Available in

All versions, Microsoft 365

Returns

A nominal annual rate

Want to practice NOMINAL in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

NOMINAL is the reverse of EFFECT: given the true annual rate, it returns the quoted rate that compounds to it.

Divide the result by npery to get the rate per period to use in PMT or FV.

Syntax

=NOMINAL(effect_rate, npery) Explain

Arguments

ArgumentRequired?What it does
effect_rateYesThe effective annual rate.
nperyYesCompounding periods per year.

Examples

Example 1 — Back to the quoted rate

A bank advertises 6.17% effective. What nominal rate is that?

C2fx=NOMINAL(6.17%,B2)
ABC
1CompoundingPer yearNominal rate
2Monthly126.00%
3Quarterly46.03%

Common mistakes

  • #NUM! error. effect_rate must be above 0 and npery at least 1.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.