A:

When calculating interest-on-interest, use the compound interest formula to determine the amount of accumulated interest on the principal amount invested or borrowed. To figure out compound interest on a loan or deposit, you need to know the principal amount, the annual interest rate and the number of compounding periods.

Compound interest is the interest owed or received that grows at a faster rate than basic interest.

How to Calculate Interest on Interest (Compound Interest)

The formula to calculate compound interest is the principal amount multiplied by 1, plus the annual interest rate in percentage terms, raised to the total number of compound periods. The principal amount is then subtracted from the resulting value.

Compound Interest = [P (1 + i)n] – P

(Where P = Principal, i = nominal annual interest rate in percentage terms, and n = number of compounding periods.)

For example, assume you want to calculate the compound interest on a $1 million deposit. The principal is compounded annually at a rate of 5%. The total number of compounding periods is five years.

The resulting compounded interest on the deposit is $276,281.60, or $1,000,000 * (1 + 0.05) ^ 5 - $1,000,000.

Assume you want to calculate the compound interest on a $1 million deposit. However, this particular deposit is compounded monthly. The annual interest rate is 5%, and the interest accrues at a compounding rate for five years.

To calculate the monthly interest, simply divide the annual interest rate by 12 months. The resulting monthly interest rate is 0.417%. The total number of periods is calculated by multiplying the amount of years by 12 months, since the interest is compounding at a monthly rate. In this case, the total number of periods is 60, or 5 years * 12 months.

The resulting interest, compounded monthly, is $283,614.31, or ($1,000,000)*(1+0.00417) ^ 60 - $1,000,000.

RELATED FAQS
  1. How do I calculate compound interest using Excel?

    Learn how to calculate compound interest using three different techniques in Microsoft Excel. Read Answer >>
  2. Simple versus compound interest

    Different methods in interest calculation can end up different interest payment. Learn the differences between simple and ... Read Answer >>
Related Articles
  1. Investing

    Understanding the Power of Compound Interest

    Understanding compound interest is important for both investing and borrowing money.
  2. Investing

    The Effective Annual Interest Rate

    The effective annual interest rate is a way of restating the annual interest rate so that it takes into account the effects of compounding.
  3. Investing

    Overcoming Compounding's Dark Side

    Understanding how money is made and lost over time can help you improve your returns.
  4. IPF - Banking

    APR and APY: Why Your Bank Hopes You Can't Tell The Difference

    Do you know the difference between Annual Percentage Rate and Annual Percentage Yield? Check out how they can affect your own account balance.
  5. Investing

    4 Ways Simple Interest Is Used In Real Life

    Simple interest works in your favor when you're a borrower, but against you when you're an investor.
  6. Personal Finance

    Simple Interest Loans: Do They Exist?

    Yes, they do. Here is what they are – and how to use them to your advantage.
  7. Investing

    Compounding: My Favorite Term

    Vanguard CEO Bill McNabb shares why "compounding" is his favorite financial term.
  8. Investing

    Let the Power of Compounding Increase Your Investments

    The power of compounding can exponentially increase the value of your investments over time.
  9. Investing

    5 Best Ways to Earn Interest

    Learn how to use tools to increase your interest earnings. Use compounding interest and breakpoints to increase your interest income.
RELATED TERMS
  1. Compounding

    Compounding is the process in which an asset's earnings, from ...
  2. Interest Rate

    Interest rate is the amount charged, expressed as a percentage ...
  3. Future Value - FV

    Future value (FV) is the value of a current asset at a date to ...
  4. Biotech Compound

    A biotech compound is a chemical identified by scientists as ...
  5. Annual Equivalent Rate - AER

    Interest that is calculated under the assumption that any interest ...
  6. Compound Net Annual Rate - CNAR

    The compound net annual rate (CNAR) is the return earned on an ...
Trading Center