FD Calculator – Fixed Deposit Interest Calculator

This FD Calculator helps you to know how much interest you can get in Fixed deposits opened in bank or post office. FD interest is compounded on quarterly basis.

You can open Fixed deposits for tenure between 7 days to 10 years to park for fixed interest on pre defined interest rate.

Download Fixed Deposit EXCEL Calculator from here

Download our Android App FinCalC to see Slab-wise details of your Income Tax Calculation

SHOW your Support!

Found this Helpful? DONATE any amount to see more useful Content. Scan below QR code using any UPI App!

fincalc donate

UPI ID: abhilashgupta8149-1@okhdfcbank

Verify that you are “Paying Abhilash Gupta” before making the transaction so that it reaches me. It makes my Day 🙂

Thank you for Donating. Stay Tuned!

Share this Free FD Calculator with your friends and family members and help them in FD Interest Calculation!

ALSO READ: Latest Interest Rates in Post Office

What is FD?

FD full for in Fixed Deposit, also known as Term Deposit. FD can be booked in any nationalized or private banks or in post office in India. The main goal of booking FD should be to use the invested amount in some future buying.

For example, you have enough amount to buy a new smartphone with a budget of Rs. 10,000, but you can wait for the next 1 year to check if you get a good deal within your budget with upcoming new smartphones. So you can book an FD for 1 year, post which, you can use the fund to buy a new smartphone of your choice. And this is how, you should link your FD investment to your goals.

You get additional interest amount as bonus, higher than savings account in Fixed Deposits.

Watch how FD interest is calculated in excel

YouTube player

Watch more Excel Videos Here

You can download the Fixed Deposit Excel Calculator from here.

How FD Calculator works?

FD Calculator helps you to know how much interest you can earn if you book a FD with specific amount, with interest rate and tenure provided to the calculator. This will help you plan your investments for goals accordingly.

There are 2 types of FD:

  • Cumulative Fixed Deposits: A type of FD that helps you accumulate interest amounts that you gain every quarter. This interest amount helps you earn more interest over long run which is known as Compounding. Compounding in FD usually happens on quarterly basis, which means, your interest calculated every month will be added to your balance every quarter. This increase in balance will help you earn more interest in upcoming quarters and that is why cumulative Fixed Deposits must be preferred.
  • Non Cumulative Fixed Deposits: In this type of FD you get regular payouts may be quarterly or half yearly. This payouts are usually the interest amounts you gain over a quarter of half year. Instead of adding this interest to your balance amount, it is paid out to you which you can treat as a bonuses on regular intervals.

Cumulative Fixed Deposits earn higher interest amounts compared to non cumulative fixed deposits.

The above calculator helps you calculate interest of cumulative fixed deposits.

ALSO TRY: SIP Returns Calculator

How to Calculate FD Interest?

Let us take an example of how to calculate Fixed Deposit interest.

For example, if you deposit Rs. 5000 in cumulative Fixed Deposit with 4.5% annual interest rate for 1 year, below are the steps to calculate FD interest:

  1. Calculate monthly interest rate from annual interest rate – 4.5 / 12 = 0.375%. This is the monthly interest rate in our example
  2. Now use monthly interest rate to calculate monthly interest you’ll get using formula – monthly interest rate * amount / 100 = 0.375% * Rs. 5000 / 100 = Rs. 18.75
  3. Since we are considering quarterly compounding, we have to calculate 3 months interest by multiplying one month interest with 3 = Rs. 18.75 * 3 = Rs. 56.25 (3 months interest on Rs. 5000)
  4. Now this interest is added to you balance amount of Rs. 5000, which now becomes Rs. 5056.25
  5. Repeat steps 2-4 using updated balance amounts.

Below is the screenshot showing total interest earned in our example:

FD Calculator - FD Interest Calculation using Excel
FD Calculator – FD Interest Calculation using Excel

As seen above, we get total interest of approx. Rs. 229 and a total maturity amount of approx. Rs. 5229 based on above example.

Watch above video to know how quarterly compounding is done in FD and how total interest is calculated.

After FD maturity, you have 3 options:

  • Take Maturity (total) amount in your Savings account
  • Renew FD (Principal amount only)
  • Renew FD (Principal + Interest amounts)

So it depends on you after FD maturity whether you want to renew the amounts for some more time.

Latest FD Interest Rates in Post Office

Below are the latest FD interest rates in post office for quarter April to June 2024:

TenureInterest RateMinimum DepositMaximum Deposit
1 Year6.9%Rs. 1000No Limit
2 Years7.0%Rs. 1000No Limit
3 Years7.1%Rs. 1000No Limit
5 Years7.5%Rs. 1000No Limit
Latest FD Interest Rates in Post Office

How much you will get on Rs. 1 Lakh FD?

Based on the calculator, for FD of amount = Rs. 1 Lakh, interest rate = 4.5% and tenure = 1 Year, you’ll get total interest = Rs. 4577 and maturity amount = Rs. 1,04,577

Love Reading Books? Here are some of the Best Books you can Read: (WITH LINKS)

More Recommended Books Here

In How many years FD will double?

It depends on interest rate you are getting on FD. Senior citizens and bank staff gets higher interest rates on FD compared to others. Considering quarterly compounding, and interest rate of 5%, your investment amount will double in approx. in 14 years. So after 14 years, your FD of Rs. 1 Lakh with annual interest rate of 5%, you’ll get approx. 2 Lakh as maturity amount.

Below is the table showing in how many years FD will double based on interest rates:

Annual Interest Rate %Years it will take for double amount
3%23.5 Years
3.5%20 Years
4%17.5 Years
4.5%15.5 Years
5%14 Years
5.5%12.6 Years
6%11.7 Years
6.5%10.8 Years
7%10 Years
Years for FD amount to double

Which Bank FD is Best?

You can book FD in any bank including SBI, ICICI, Axis, etc. Above calculator gives approx. interest and maturity amounts for FDs booked in SBI as well. So above FD calculator can be treated as FD calculator for SBI.

Apart from banks, you can also check out FD interest rates in Post Office as well. Some Post offices provide higher interest rates compared to banks so they are worth checking.

Does FD give monthly Interest?

Yes, monthly interest is calculated in FD and is compounded on quarterly basis. As explained above, monthly interest are calculated thrice before adding this sub-interest amount in the balance, on which upcoming months interest will be calculated.

Income Tax Saving on FD

You can save income tax on FD under Section 80C. But the tenure for saving income tax in FD must be 5 years. Other tenures FD cannot help you save income tax. Maximum of Rs. 1.5 Lacs can be claimed as deduction under Section 80C while saving income tax.

You can read about more tax saving options here.

More Calculators

Income Tax Calculator

Step up SIP Calculator

PPF Calculator

SHOW your Support!

Found this Helpful? DONATE any amount to see more useful Content. Scan below QR code using any UPI App!

fincalc donate

UPI ID: abhilashgupta8149-1@okhdfcbank

Verify that you are “Paying Abhilash Gupta” before making the transaction so that it reaches me. It makes my Day 🙂

Thank you for Donating. Stay Tuned!

Income Tax Calculator App – FinCalC

For Income Tax Calculation on your mobile device, you can Download my Android App “FinCalC” which I have developed for you to make your income tax calculation easy.

What you can do with this mobile App?

  • Calculate Income Tax for new FY 2023-24 and previous FY 2022-23
  • Enter estimated Investments to check income tax with Old and New Tax Regime
  • Save income tax details and track regularly
  • Know how much to invest more to save income tax
  • More calculators including PPF, SIP returns, Savings account interest and lot more
Download Income Tax Calculator APP from play store
Download Income Tax Calculator APP from play store

Use Popular Calculators:

I’d love to hear from you if you have any queries about Personal Finance and Money Management.

JOIN Telegram Group and stay updated with latest Personal Finance News and Topics.

Download our Free Android App – FinCalC to Calculate Income Tax and Interest on various small Saving Schemes in India including PPF, NSC, SIP and lot more.

Follow the Blog and Subscribe to YouTube Channel to stay updated about Personal Finance and Money Management topics.