Nominal interest rate is typically the stated rate on a financial product.

Effective annual interest rate is the interest rate actually earned due to compounding.

Effective annual interest rate is the interest rate actually earned due to compounding.

Excel EFFECT function