Compound 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 you have a deposit of $100 that earns a 10% compounded interest rate. TheÂ $100 grows into $110 after the first year, then $121 after the second year. Â Each year the base increases by 10%. Â The reason the second year's gain is $11 instead of $10 is as a result of the same rate (10% in this example) being applied to a larger base ($110 compared to $100, our starting point). Â
Or let's say, $100 is the principal of a loan, and the compound interest rate is 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, and $21 for both years. (Want to improve your excel skills? Visit InvestopediaÂ Academy to view our excel for finance courses.)Â Â Â
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 formula is that you can't easily see what numbers go where, or what numbers are user inputs or hardcoded. Â
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 breakout the calculations line by line. Conversely, you could calculate the whole equation in one cell to arrive at just the final value figure. Â Both are detailed below:
Â
Â

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 >> 
What is the difference between continuous compounding and discrete compounding?
Learn to differentiate between and calculate the continuous and discrete compounding formulas for interestgenerating investments ... Read Answer >> 
What is the difference between stated annual return and effective annual return?
Essentially, the effective annual return accounts for intrayear compounding, and the stated annual return does not. The ... Read Answer >>

Investing
Understanding the Power of Compound Interest
Understanding compound interest is important for both investing and borrowing money. 
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. 
Investing
Accelerating Returns With Continuous Compounding
Investopedia explains the natural log and exponential functions used to calculate this value. 
Investing
Explaining Interest
Interest is the price charged to borrow money, and is typically expressed as a percentage of the principal, or the amount loaned. 
Investing
Calculating Future Value
Future value is the value of an asset or cash at a specified date in the future that is equivalent in value to a specified sum today. 
Personal Finance
Simple Interest Loans: Do They Exist?
Yes, they do. Here is what they are â€“ and how to use them to your advantage. 
Investing
How to Calculate Your Investment Return
How much are your investments actually returning? Find out why the method of calculation matters. 
Personal Finance
Schedule Loan Repayments with Excel Formulas
Calculate all the particulars of a loan using Excel, and set up a schedule of repayment for a mortgage or any other loan. 
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 ... 
Financial Advisor
Shareholders' Equity
Learn how to calculate this common formula in finance.

Compound Interest
Compound Interest is interest calculated on the initial principal ... 
Discrete Compounding
Discrete compounding refers to the method by which interest is ... 
Periodic Interest Rate
The interest rate charged on a loan or realized on an investment ... 
Effective Annual Interest Rate
Effective Annual Interest Rate is an investment's annual rate ... 
Continuous Compounding
The process of earning interest on top of interest. The interest ... 
Annual Percentage Yield  APY
The effective annual rate of return taking into account the effect ...