Question: how to calculate the nominal interest rate in excel?
Answer: Summary. ... 
Get annual nominal interest rate.
Nominal interest rate.
=NOMINAL (effect_rate, npery)
effect_rate - The effective annual interest rate. ... 
The Excel NOMINAL function calculates the nominal interest rate, given an effective annual interest rate and the number of compounding periods per year. ... 
Excel EFFECT Function.