When calculating interestoninterest, 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.

How to calculate compound loan interest in Excel?
Find out about compound interest and how to use the compounding interest formula in Microsoft Excel to calculate the compound ... Read Answer >> 
How do I calculate compound interest using Excel?
Learn how to calculate compound interest using three different techniques in Microsoft Excel. Read Answer >> 
Simple versus compound interest
Different methods in interest calculation can end up different interest payment. Learn the differences between simple and ... Read Answer >> 
Continuous compounding versus discrete compounding
Learn to differentiate between and calculate the continuous and discrete compounding formulas and see how it is going to ... 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 or the rate paid on a deposit to an investor. Interest can be classified as simple interest or compound interest. 
Investing
Continuous compound interest
Different frequency in compound interest results in different returns. Check out how continuous compounding accelerates your return. 
Personal Finance
How Interest Rates Work on Savings Accounts
Here's what you need to know to grow your rainyday fund. 
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. 
Personal Finance
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. 
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. 
Personal Finance
Simple Interest Loans: Do They Exist?
Yes, they do. Here is what they are – and how to use them to your advantage. 
Retirement
Using Compounding to Boost Retirement Savings
Allowing growth on your investments to compound over time gives you immense returns when saving for retirement.

Compound Interest
Compound Interest is interest calculated on the initial principal ... 
Compound
Compound is the ability of an asset to generate earnings, which ... 
Periodic Interest Rate
The periodic interest rate is the interest rate charged on a ... 
Effective Annual Interest Rate
The effective annual interest rate is an investment's annual ... 
Continuous Compounding
Continuous compounding is the process of calculating interest ... 
Compounding
Compounding is the process in which an asset's earnings, from ...