A:

What is Compound Interest?

Compound interest, also known as compounded interest, is interest that's calculated both on the initial principal of a deposit or loan, and on all previously accumulated interest.

For example, let's say $100 represents the principal of a loan, which carries a compounded interest rate of 10%. After one year you have $100 in principal and $10 in interest, for a total base of $110. In year two, the interest rate (10%) is applied to the principal ($100, resulting in $10 of interest) and the accumulated interest ($10, resulting in $1 of interest), for a total of $11 in interest gained that year. The second year's increase is $11, instead of $10, because the interest is compounding – that is, it's being applied to a larger base ($110 compared to $100, our starting point). Each year, the base increases by 10%: $110 after the first year, then $121 after the second year.

What Is The Formula for Compound Interest?

It's similar to the Compounded Annual Growth Rate (CAGR). For CAGR, you are computing a rate which links the return over a number of periods. For compound interest, you most likely know the rate already; you are just calculating what the future value of the return might be.

For the formula for compound interest, just algebraically rearrange the formula for CAGR. You need the beginning value, interest rate, and number of periods in years. The interest rate and number of periods need to be expressed in annual terms, since the length is presumed to be in years. From there you can solve for the future value. The equation reads:

Beginning Value * (1 + (interest rate/number of compounding periods per year))^(years * number of compounding periods per year) = Future Value

This formula looks more complex than it really is, because of the requirement to express it in annual terms. Keep in mind, if it's an annual rate, then the number of compounding periods per year is one, which means you're dividing the interest rate by one and multiplying the years by one. If compounding occurs quarterly, you would divide the rate by four, and multiply the years by four.

Calculating Compound Interest in Excel

Financial modeling best practices require calculations to be transparent and easily auditable. The trouble with piling all of the calculations into a single formula is that you can't easily see what numbers go where, or what numbers are user inputs or hard-coded.

There are two ways to set this up in Excel. The most easy to audit and understand is to have all the data in one table, then break out the calculations line by line. Conversely, you could calculate the whole equation in one cell to arrive at just the final value figure. We recommend the first approach, but both are detailed below.

In the example below, you can input the data in yellow, and choose the compounding period.  

RELATED FAQS
  1. What formula can I use to calculate interest on interest?

    Find out more about compounding interest, what it measures and how to calculate the amount of compound interest accrued using ... Read Answer >>
  2. How do I use the rule of 72 to calculate continuous compounding?

    Find out why the rule of 72 does not accurately reflect the growth caused by continuous compounding, and which number can ... Read Answer >>
  3. How do mutual funds compound interest?

    Learn how mutual funds can grow wealth over time through the magic of compound interest by reinvesting dividends back into ... Read Answer >>
  4. How can I tell if a loan uses simple or compound interest?

    Learn the differences between simple and compound interest and how you can identify which one a loan uses. Read Answer >>
  5. What is the difference between continuous compounding and discrete compounding?

    Learn to differentiate between and calculate the continuous and discrete compounding formulas for interest-generating investments ... 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

    Learn Simple and Compound Interest

    Interest is defined as the cost of borrowing money, and depending on how it is calculated, it can be classified as simple interest or compound interest.
  3. Investing

    Accelerating Returns With Continuous Compounding

    Investopedia explains the natural log and exponential functions used to calculate this value.
  4. 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.
  5. Personal Finance

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

    Banks use these rates to entice borrowers and investors. Find out what you're really getting.
  6. Financial Advisor

    Compound Annual Growth Rate (CAGR)

    The compound annual growth rate is an important tool for measuring investment performance and comparing it across asset classes. Discover how it is calculated and how it can inform your investment ...
  7. Investing

    How to Calculate Your Investment Return

    How much are your investments actually returning? Find out why the method of calculation matters.
  8. Investing

    The Interest Rates: APR, APY And EAR

    When most people shop for financial products, all they focus on is the listed interest rate. Human eyes instinctively dismiss the fine print, which usually includes the terms APR (annual percentage ...
  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.
  10. Insights

    Simple Interest

    Simple interest is a quick method of calculating the interest charged on a loan. Simple interest is determined by multiplying the interest rate by the principal by the number of periods.
RELATED TERMS
  1. Compound Interest

    Compound Interest is interest calculated on the initial principal ...
  2. Discrete Compounding

    Discrete compounding refers to the method by which interest is ...
  3. Periodic Interest Rate

    The interest rate charged on a loan or realized on an investment ...
  4. Effective Annual Interest Rate

    Effective Annual Interest Rate is an investment's annual rate ...
  5. Continuous Compounding

    The process of earning interest on top of interest. The interest ...
  6. Compounding

    The ability of an asset to generate earnings, which are then ...
Hot Definitions
  1. Retirement Planning

    Retirement planning is the process of determining retirement income goals and the actions and decisions necessary to achieve ...
  2. Drawdown

    The peak-to-trough decline during a specific record period of an investment, fund or commodity. A drawdown is usually quoted ...
  3. Inverse Transaction

    A transaction that can cancel out a forward contract that has the same value date.
  4. Redemption

    The return of an investor's principal in a fixed income security, such as a preferred stock or bond; or the sale of units ...
  5. Solvency

    The ability of a company to meet its long-term financial obligations. Solvency is essential to staying in business, but a ...
  6. Dilution

    A reduction in the ownership percentage of a share of stock caused by the issuance of new stock. Dilution can also occur ...
Trading Center