Compound Interest: Definition, Formula & How To Calculate With Short Trick

After every illustration of the NCERT course reading, there are models and exercises. After you are finished with every illustration, check through the tackled models and ensure you comprehend and learn them appropriately. Then, at that point, go to the activities and attempt to settle them. There is a potential that similar issues will show up in the test, hence understudies should rehearse the aggregates in the activities completely. CI is determined by increasing the chief sum by one or more the interest to the force of the accumulating time frames. At last, the essential sum should be eliminated to compute the CI.

compound interest formula in excel

Additionally, it consists of a start date that will help to make the cumulative interest & payment schedule. Very valuable and easy sollution you have given and easy to undrstand too. In the above example, with $10000 of principal amount and 10% interest for 5 years, we will get $16486. In the above example, with $10000 of principal amount and 10% interest for 5 years, we will get $16453. In the above example, with $10000 of principal amount and 10% interest for 5 years, we will get $16386. In the above example, with $10000 of principal amount and 10% interest for 5 years, you will get $16105.


Compound Interest was called the 8th Wonder of the World by Albert Einstien. It is what makes your money grow so that even small amounts can over time create a huge corpus. ET Money’s compound interest calculator is a free, online tool that you can use to find out how your small savings will accumulate over time to make you wealthy. To Calculate the compound interest we multiply the initial principal amount by one plus the annual interest rate raised to the number of compound periods minus one.

compound interest formula in excel

The entire idea depends on creating critical returns by building interest on the primary sum. The time is in years and the rate of interest is in percentage (%). To get the monthly interest, divide the Simple Interest by 12 for 1 year, 24 months for 2 years and so on.

Frequently Asked Questions

It is the easiest technique under which the principal amount remains constant, which means you do not have to pay interest on the previously accumulated interest. Compound interest isn’t unique to 1 kind of investment car. Your interest is likely to compound whether you get a financial savings account, certificate of deposit , and even some checking accounts. Therefore, do not simply assume that you have to put your cash in a savings account to earn this type of curiosity.

You get the best effective rate when you have daily compounding and slightly worse with monthly or yearly compounding. A compound interest calculator makes it easier to calculate compound interest so that you don’t need to make any manual calculations. You can also use a compound interest calculator to calculate returns on investments that offer compounding returns, like mutual funds.

The compounding frequency remains unchanged; what changes is the time and consequently the total compounding frequency . When we are calculating compound interest, the number of compounding periods makes a significant difference. Interest can be compounded on any given frequency schedule, from continuous to daily monthly, or annually. Accumulate revenue, then again, is most regularly used in contributing. Accumulate revenue is likewise utilized by fixed stores, shared assets, and whatever other speculation that considers benefit reinvestment. We as a whole realize that Simple Interest and Compound Interest are two key ideas that are every now and again utilized in different monetary administrations, especially in banking.

compound interest formula in excel

Aman spends 18,000 partially in scheme ‘A’ which offers 15% pa at C.I. Find amount invested on scheme ‘B’ is what percent less or more than the amount invested on scheme ‘A’. A sum becomes Rs 6888 in 8 years and becomes Rs 7380 in 10 years at the same rate on simple interest. Find compound interest earned in 3 years on Rs 4000 at same rate of interest. We already know from the SI vs CI definition that the interest is typically expressed as a percentage, and can be Simple or Compound Interest.

Satish invested Rs. 14,000 partially in scheme A which offer 20% p.a. Find the amount invested in scheme B if total interest earns after 2 years is Rs. 6640. The count of a certain breed of bacteria was found to increase at the rate of 5% per hour. What will be the growth of bacteria at the end of 3 hours if the count was initially 6000. Groww offers you a customizable compound interest rate calculator which helps you assign values based on your requirements.

Download HDFC Life App

Most interest bearing accounts calculate interest considered one of two methods. The longer money sits in a compound interest account, the more benefit you will reap over the long term. A difference of even 1% in the interest rate will increase your capital gains.

  • Hence, you receive not only interest on your principal amount but also the added interest each year.
  • I have worked in Excel and like to share functional excel templates at ExcelDataPro.
  • Total compound interest is the final amount excluding the principal amount.
  • Though the actual investment period is 5 years and the rate is 5%, the formula takes the time as 20 and the rate as 1.25% (5% ÷ 4).

In the first method, we can directly substitute the values in the formula. In the second method, compound interest can be obtained by splitting the given time bound into equal periods. The interest calculated on the initial principal is called Compound interest and it includes all of the accumulated interest from previous periods on a deposit or loan. Simple Interest is the method or technique to calculate the interest on a sum over a period of time at a given rate of interest.


Simple interest is a quick and easy method of calculating the interest charge on a loan. Simple interest is determined by multiplying the daily interest rate by the principal by the number of days that elapse between payments. Mutual funds andUnit-Linked Insurance Plans are two of the most common investments that utilise compound interest formulae to grow your money. Both investment avenues work in a similar fashion, with the main difference being that ULIPs offer the additional benefit of life cover. Compound interest investment plans are especially useful in planning your finances for your retirement.

To calculate the quarterly compound interest you can use the below-mentioned formula. The interest you earn each year is added to your principal, so that the balance doesn’t merely grow, it grows at an increasing rate. The total interest earned is relatively higher with compound interest and therefore favourable for investors. This handy, free-to-use tool automatically computes your interest outgo, total debt and monthly instalments without the need for any manual calculations.

The rate is calculated as ‘Annual Interest Rate / Compounding frequency ’. The compound interest at the end of 3 years using the compound interest formula in excel is as shown below. Have you ever wondered how to calculate compound interest in Excel? That’s why we’ve written up this step-by-step tutorial on how to use the compound interest formula in Excel to get the job done. These calculations only work if you consider that the interest rate is not recalculated to be equivalent. By using the above methods, I have created a cumulative interest calculator to calculate all of the above calculations for interest in a single worksheet.

Compounding Interest Calculator

Where, Amount is equal to the total money paid back at the end of the time period for which the money was borrowed. We can determine this by Simple Interest multiplying the daily rate of interest by the principal by the number of days that elapse between payments. Simple interest is calculated on the principal amount on a daily/monthly/annual basis. While both types of interest will grow your money over time, there is a big difference between the two. Specifically, simple interest is only paid on principal, while compound interest is paid on the principal plus all of the interest that has previously been earned. Law of compoundingis the backbone of financial returns through investment and security through insurance.

Here we have provided the Compound Interest Formula when the amount is compounded quarterly. When the rate is compounded quarterly, we divide the rate by four and multiply the time by 4 in the general formula. Suppose you borrow ₹5000 from a moneylender on a 10% per annum interest rate.

From the second period, the interest is also calculated on the interest thus earned on the previous period of time, that is why it is known as interest on interest. Let us learn more about the monthly compound interest formula along with solved examples. Among the particulars of a personal loan, the monthly instalments or EMIs are those you should pay maximum attention to.

Compound Interest starts when your investment earns interest. At this point, the interest is added to the initial investment amount. When it earns interest again, it will determine the newly earned interest by calculating the initial capital invested and the earned interest.

Leave a Comment