How Do You Calculate Eir

Effective annual interest rate = (1 + (nominal rate / number of compounding periods)) ^ (number of compounding periods) – 1. For investment A, this would be: 10.47% = (1 + (10% / 12)) ^ 12 – 1. And for investment B, it would be: 10.36% = (1 + (10.1% / 2)) ^ 2 – 1.

What is effective interest rate with example?

Calculation. For example, a nominal interest rate of 6% compounded monthly is equivalent to an effective interest rate of 6.17%. 6% compounded monthly is credited as 6%/12 = 0.005 every month. After one year, the initial capital is increased by the factor (1 + 0.005)12 ≈ 1.0617.

How do I calculate effective interest rate in Excel?

1. Effective Interest Rate = (1 + 9%/365) 365 – 1.
2. Effective Interest Rate = 9.42%