Excel functions / Financial
NOMINAL function
The quoted yearly rate behind an effective rate. The reverse of EFFECT.
Syntax
=NOMINAL(effect_rate, npery)
Arguments
effect_rate: The effective yearly rate.npery: How many times a year interest is added.
When to use it
NOMINAL turns an effective yearly rate back into the quoted rate for a given compounding: the rate a bank would advertise. It is the inverse of EFFECT.
Examples
The quoted rate behind 5.3543% effective, quarterly
A B C D 1 Effective Per year 2 5.3543% 4 5.250% In D2:
=NOMINAL(A2, B2)→ 5.250%
Common mistakes
- Periods per year. The second argument is the compounding periods per year, rounded down to a whole number.
NOMINAL in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: NOMINAL
- Danish: NOMINEL
- Dutch: NOMINALE.RENTE
- Finnish: KORKO.VUOSI
- French: TAUX.NOMINAL
- German: NOMINAL
- Hungarian: NÉVLEGES
- Italian: NOMINALE
- Norwegian: NOMINELL
- Polish: NOMINALNA
- Portuguese (Brazil): NOMINAL
- Portuguese (Portugal): NOMINAL
- Russian: НОМИНАЛ
- Spanish: TASA.NOMINAL
- Swedish: NOMRÄNTA
- Turkish: NOMİNAL