User Activity Modal/Pop Up Component
banner

How to Calculate Fixed Deposit Interest?

Learn fixed deposit interest calculation formula and methodologies using simple interest and compound interest method.

#Investments 100 Views 83 Shares
banner
avatar-image

Written by

Updated :

Reviewed by

Rated by users

Fixed deposits are a popular investment option in India and this option is widely availed for reaching both short-term and long-term financial goals. The main reasons for this popularity of fixed deposits in India is linked to its 2 key features – assured returns and low risk (practically zero risk) to the principal amount invested. After all, who does not like an investment that allows you to predict returns ahead of time? However, one common question that comes up from time to time is how to calculate fixed deposit interest and is there more than one way to know the future interest earning from your FD?

While the simple answer to both questions is yes, let’s take a closer look at how to calculate FD interest using the FD interest calculation formula, FD formula in Excel and using an online FD calculator.   

What are the Two Ways to Calculate Interest on Deposits?

There are two major ways in which interest is calculated on term deposits. One is simple interest and the other is compound interest. Each method of fd interest calculation uses a different formula to calculate interest earned from the FD. Currently, interest on fixed deposits is calculated using the compound interest calculation formula. However, a clear understanding of simple interest calculation and formula is necessary to get a clear understanding of why FD interest is calculated this way.  

What is Simple Interest Calculation Formula?

Below is the simple interest calculation formula:

Simple Interest = Principal X Interest Rate X Time

Here, Principal is the original investment amount and time refers to the duration of the investment in years or months. Interest rate is usually represented as a percentage value either as an annual or monthly rate. So, in this fd interest calculation you will earn more interest if you stay invested longer, receive a higher interest rate on your deposit or invest a larger amount.

So, if you invest Rs. 5,000 for 3 years at 5% per annum interest rate, the simple interest earned will be as below:

Total Interest Earned = 5000 x 3 x 0.05 = Rs. 750. 

While, the above interest calculation formula is easy to understand and calculate, simple interest has a key drawback. There is no compounding i.e. your interest earnings do not play any part in growing your wealth further. In case you are wondering how to calculate FD interest accounting for compounding, this is taken into account by the compound interest formula. 

How is FD Interest Calculated Using Compound Interest Formula? 

Compound interest calculation formula takes into account compounding i.e. interest earned in the previous cycle earns interest in the subsequent cycle. So, in the case of annual compounding, interest earned on your deposit at the end of the 1st year will become part of the principal used to calculate FD interest in the second year. This is how the power of compounding helps investors grow their wealth the longer they stay invested.

The compound interest calculation formula for FD looks like this:

Compound Interest = [P {1+ R /(100 X n)} (nt)] - P  

In the above formula, P= Principal, R= Annual interest rate, t= time period of investment, n= Number of times compounding occurs in a year. So, for annual compounding i.e. when interest is added to the principal amount once in year, the formula can be simplified as below:

Compound Interest (annual compounding) = P {1+(r/100)}t - P

If you look at the above formula closely, you will realize that key difference between the simple interest and compound interest calculation of FD interest is that the interest in the previous period becomes the principal for the subsequent period, so, essentially you earn interest on interest just by staying invested leading to compounding of your investment.

Let’s see how this leads to capital appreciation using the previous example of initial investment of Rs. 5000, for a 3 year period and rate of 5% per annum compounded annually. With this data, the compound interest FD calculation will look like this:

Compound Interest = [5000 {1+(5/100)} 3] – 5000 = Rs. 788    

As you can see, how you calculate FD interest does impact how much interest is earned and compound interest earned was around Rs. 38 more even for the relatively short investment tenure of 3 years. If the tenure is longer, this difference in FD interest earned will be greater as the number of times compounding occurs will increase. You can easily check these differences using an online compound interest calculator

How Fixed Deposit Interest is Calculated Using MS Excel

The above formula to calculate FD compound interest can be quite tedious and time-consuming if you are calculating for fixed deposits of long duration like 10 or 20 years. An alternative way to calculate FD interest in such cases is to use an Excel sheet which can also show the yearly growth of your investment.

Taking our earlier example of Rs. 5000, Annual interest rate of 5% and investment period of 3 years, your Excel Sheet with annual growth will look like this:

Year

Principal

Interest Rate

Interest Earned

Total Amount at End of Year

1st Year

5000

5%

250

5250

2nd Year

5250

5%

262.5

5512.5

3rd Year

5512.5

5%

275.625

5788.125

As you can see, the sum of interest and principal at the end of every year gets carried forward to the next year. All you need to do is then multiply the interest rate to the principal for each year in the excel sheet using the multiplication function to find the interest earned in each year. For more details and other ways to calculate FD interest, you can easily refer to the many excel tutorials that are available online for free.  

How FD Interest is Calculated Using FD Interest Calculator?

Perhaps the easiest way to calculate interest on fixed deposit accounts is to use an online FD calculator. This is a simple tool that is free to use on a number of websites and gives error-free instant results with minimum inputs from the user. The 3 pieces of data that needs to be provided for using an online FD calculator are investment amount, rate of interest and investment tenure as shown below:

How FD Interest is Calculated Using FD Interest Calculator?

Perhaps the easiest way to calculate interest on fixed deposit accounts is to use an online FD calculator. This is a simple tool that is free to use on a number of websites and gives error-free instant results with minimum inputs from the user. The 3 pieces of data that needs to be provided for using an online FD calculator are investment amount, rate of interest and investment tenure as shown below:

The output from the FD calculator shows the total interest and maturity is instantaneous and would look like this: 

As you can see, the output of the calculator contains key details such as interest earned from FD and the Maturity Amount of your investment. Using an online FD calculator is easy and ensures you do not have to worry about crunching numbers and engaging in tedious calculations

Frequently Asked Questions (FAQs)

Q. Does quarterly compounding give more interest at maturity than annual compounding?

A. If the interest rate, principal amount deposited and investment period remains the same, quarterly compounding will lead to higher interest earnings than annual compounding. This is because, interest gets added 4 times in the case of quarterly compounding, whereas, interest gets added only once when compounding occurs annually. So, capital appreciation will occur faster in the case of quarterly compounding vs annual compounding.

 Q. What is cumulative FD?

A. In the case of cumulative FD, the calculation of FD interest occurs as per the applicable sc payout occurs at maturity, so the principal amount invested and interest accrued has greater time to grow. Longer the investment period, greater the amount of cumulative FD interest that you can earn.     

Q. What is Non-Cumulative FD?  

 A. In the case of a non-cumulative fixed deposit, interest payouts can occur periodically either on a monthly, quarterly, semi-annual or annual basis. While capital appreciation in the case of a non-cumulative FD might be slower as compared to a cumulative FD, the periodic interest payout provides regular income to the investor.    

Q. Can FD interest rate change after booking the deposit?

A. No, FD interest rate gets locked-in once you have booked the deposit, so, it does not change and will offer assured returns on the deposit till maturity. 

Q. Will I get less fixed deposit interest if I withdraw prematurely?

A. Yes, in the case of premature FD withdrawal i.e. closure of FD account before maturity, the interest earned from FD will be less due to penalties charged by the bank or NBFC. These penalties vary based on the type of FD account and the duration for which the deposit was originally booked for.

Sources:

https://www.aubank.in/blogs/how-does-bank-calculate-interest-on-your-fixed-deposit

https://cred.club/calculators/articles/how-does-a-bank-calculate-interest-on-your-fixed-deposits

https://www.cuemath.com/commercial-math/compound-interest/

https://www.automateexcel.com/formulas/compound-interest-calculate-excel/

https://www.icicibank.com/calculator/fd-calculator

https://mintgenie.livemint.com/news/personal-finance/fd-investing-how-quarterly-compounding-is-better-than-annual-compounding-151655790575558

https://www.mahindrafinance.com/insights/investment/difference-between-cumulative-and-non-cumulative-interest-rates

https://www.bankofbaroda.in/banking-mantra/investment/articles/premature-withdrawal-of-fixed-deposit

ARN No : July23/Bg/04A

User Activity Modal/Pop Up Component
User Activity Modal/Pop Up Component