Effective Interest Rate Formula

The formula for the effective interest rate per period is:

i = (1 + r/m)ᵐ – 1

Where:

• i = effective interest rate per period (in decimal form)
• r = nominal interest rate per period (in decimal form)
• m = number of compounding intervals per period

If you want the effective interest rate over multiple periods (like 5 years instead of 1):

iₜ = (1 + i)ᵗ – 1

Or, substituting the first equation into the second:

iₜ = (1 + r/m)ᵐᵗ – 1

If you’ve found your nominal rate, you can check its real-world effect through:

• The Effective Annual Rate Calculator for annualized returns.
• The Periodic Interest Rate Calculator for interval-based rates.
• The Equivalent Interest Rate Calculator for cross-rate comparison.
• See all rate options summarized in the Interest Rate Table.

Key Terms Explained

• Nominal Interest Rate (R): The stated annual rate. Example: 7% → r = 0.07.
• Compounding Periods (m): How often interest compounds in a year (monthly = 12, quarterly = 4, daily = 365).
• Effective Interest Rate (i): The real rate per period after compounding.
• Compounded Interest Rate (I): The total interest rate for multiple periods.
• Continuous Compounding: Interest compounded infinitely, expressed with the formula i = eʳ – 1.

Example: Effective Annual Interest Rate

Suppose you invest in an account with a 7% nominal interest rate, compounded monthly (12 times per year). You want to calculate the Effective Annual Rate (EAR).

Step 1 – Apply the formula:
i = (1 + r/m)ᵐ – 1

i = (1 + 0.07/12)¹² – 1
i = (1 + 0.0058333)¹² – 1
i = 1.0722901 – 1
i = 0.07229 = 7.23%

So, the Effective Annual Rate is 7.23%, slightly higher than the 7% nominal rate.

Step 2 – Multi-year return:
For 5 years, use iₜ = (1 + i)ᵗ – 1

i₅ = (1 + 0.07229)⁵ – 1
i₅ = 1.417625 – 1
i₅ = 41.76%

This means your investment grows by 41.76% in 5 years.

Continuous Compounding Formula

In cases of continuous compounding, interest compounds at every possible instant. The formula becomes:

i = eʳ – 1

Where e ≈ 2.71828 (Euler’s number).

Example: For a 7% nominal rate with continuous compounding:

i = e⁰·⁰⁷ – 1
i ≈ 1.072508 – 1
i ≈ 7.25%

Continuous compounding gives a slightly higher return than monthly compounding.

Effective Interest Rate in Excel

If you want to calculate directly in Excel, use:

=EFFECT(nominal_rate, npery)

Where:

• nominal_rate = nominal annual rate (as a decimal)
• npery = number of compounding periods per year

Example: =EFFECT(0.07,12) → 0.07229 = 7.23%

Comparison: Nominal vs Effective Rate

Nominal Rate (R)	Compounding	Effective Rate (i)
7%	Annual (m=1)	7.00%
7%	Quarterly (m=4)	7.19%
7%	Monthly (m=12)	7.23%
7%	Daily (m=365)	7.25%
7%	Continuous	7.25%

This shows how compounding frequency raises the effective interest rate.

When Should You Use the Effective Interest Rate?

• Loans & Mortgages: To compare offers with different compounding schedules.
• Savings Accounts: To see which account truly grows your money faster.
• Bonds & Investments: To measure the real return when compounding is quarterly, semi-annual, or monthly.

Try the Effective Interest Rate Calculator

Instead of manually applying formulas, use the Effective Interest Rate Calculator. Simply input:

• Nominal interest rate (R)
• Compounding periods (m)
• Number of periods (t)

The calculator instantly shows your effective rate per year, or the total compounded return over multiple years.

The Effective Interest Rate Calculator gives you the clearest picture of your actual borrowing cost or investment growth. Compounding makes a significant difference over time, so understanding the difference between nominal and effective rates is essential for making smart financial decisions.

Whether you’re comparing bank loans, mortgage offers, or investment accounts, calculating the effective interest rate ensures you’re seeing the true financial impact.