Question: how to calculate nominal annual 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.