What is NOMINAL function in Excel?
NOMINAL function is one of the Financial functions in Microsoft Excel that returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
Syntax of NOMINAL function
NOMINAL(effect_rate, npery)
The NOMINAL function syntax has the following arguments:
- Effect_rate: The effective interest rate.
- Npery: The number of compounding periods per year.
NOMINAL formula explanation
- Npery is truncated to an integer.
- If either argument is nonnumeric, NOMINAL returns the #VALUE! error value.
- If effect_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value.
- NOMINAL (effect_rate,npery) is related to EFFECT(nominal_rate,npery) through effective_rate=(1+(nominal_rate/npery))*npery -1.
- The relationship between NOMINAL and EFFECT is shown in the following equation:
Example of NOMINAL function
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.
You can adjust the column widths to see all the data, if need be.
| Data | Description | |
| 0.053543 | Effective interest rate | |
| 4 | Number of compounding periods per year | |
| Formula | Description | Result |
| =NOMINAL(A2,A3) | Nominal interest rate with the terms above | 0.05250032 |