How to Create FD Interest Calculator in Excel (with Easy Steps)

While working in Microsoft Excel sometimes we need to determine some financial calculations. You can calculate the Accused, Fixed Deposit Interest using Excel. What if I offer you a calculator where you can provide your information and get the value within seconds? Today, I am sharing an FD interest calculator in Excel in this article.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Simple Steps to Create FD Interest Calculator in Excel

In the following, I have shared 3 simple and easy steps to create an FD interest calculator in Excel. Stay tuned!


Step 1: Create a Dataset with Proper Information

First, let’s create a dataset with some information to determine the fixed deposit interest and total amount.

  • Here, we have “Deposit amount”, “No. of Period”, “Frequency”, and “Interest Rate”. Using these values we will determine the interest amount.

  • Hence, we will create two cells with “Total Maturity Amount” and “Total Interest Amount” where we will collect the total amount.

Create a Dataset with Proper Information to Create FD Interest Calculator in Excel

  • Now, suppose we have a scenario where we have a “Deposit Amount” of $50,000, “No. of Period” is 3 years and an “Interest Rate” of 6.2%. Using these values we will generate our total interest amount.

Create a Dataset with Proper Information to Create FD Interest Calculator in Excel

Read More: How to Calculate Interest Rate in Excel (3 Ways)


Step 2: Categorize Deposit Frequency

In this step, we need to categorize the deposit frequency. This can be days, months, or years. Let’s start.

  • As the fixed deposit can be calculated over days, months, and years. Thus we will build a drop-down list for calculation advantage.
  • For that, choosing a cell (D5), choose the “Data Validation” option from the “Data” feature.

Categorize Deposit Frequency to create FD Interest Calculator in Excel

  • A new dialog box will pop up named “Data Validation”.
  • From the box, choose “List” from the drop-down list and type “Months, Days, Years” in the “Source” section.
  • To finish, click OK.

  • Now coming back to the worksheet, our drop-down list will be ready in our hands.

Categorize Deposit Frequency to create FD Interest Calculator in Excel

  • Similarly, we will make a drop-down list for the cell (C6) so that we can change the frequency for calculation.
  • Choosing cell (C6), go to the “Data Validation” feature.

  • In the same fashion, choose “List” in the “Allow” section and type “SimpleInterest, Monthly, Quarterly, Halfyearly, Annually” in the source section.
  • Gently, hit OK.

Categorize Deposit Frequency to create FD Interest Calculator in Excel

  • In summary, our second drop-down list will be ready.

Categorize Deposit Frequency to create FD Interest Calculator in Excel

Read More: How to Calculate Accrued Interest on Fixed Deposit in Excel (3 Methods)


Similar Readings


Step 3: Apply Formula to Calculate FD Interest

After all the prerequisites we have met now it’s time to calculate the final output, the end of the day that matters. We are prepared to apply a simple formula and get our desired result.

  • Now, select a cell (C9) and apply the following formula down-
=IF(C6="SimpleInterest",(C4*(1+((C7*5)/((IF(D5="years",1,IF(D5="months",12,IF(D5="days",365))))*100)))),IF(C4="Annually",(C4*(1+(C7/100))^(C5*(1/(IF(D5="years",1,IF(D5="months",12,IF(D5="days",365))))))),IF(C6="Halfyearly",(C4*(1+(C7/(100*2)))^(C5*(2/(IF(D5="years",1,IF(D5="months",12,IF(D5="days",365))))))),IF(C6="Quarterly",(C4*(1+(C7/(100*4)))^(C5*(4/(IF(D5="years",1,IF(D5="months",12,IF(D5="days",365))))))),IF(C6="Monthly",(C4*(1+(C7/(100*12)))^(C5*(12/(IF(D5="years",1,IF(D5="months",12,IF(D5="days",365))))))))))))

Apply Formula to Calculate FD Interest

Formula Breakdown:

  • =IF(C6=”SimpleInterest”,(C4*(1+((C7*5)/((IF(D5=”years”,1,IF(D5=”months”,12,IF(D5=”days”,365))))*100))))) → Here, the IF function will display the calculated amount if the statement (C4*(1+((C7*5)/((IF(D5=”years”,1,IF(D5=”months”,12,IF(D5=”days”,365))))*100)) is true otherwise it will move to the next argument.
  • Similarly, the IF function will run the argument for “Annually, Halfyearly, Quarterly, Monthly” selections from the drop-down list in cell (C6) until it finds the proper selection. After matching the selection from the cell (C6), it will calculate the amount matching the criteria from this argument (IF(D5=”years”,1,IF(D5=”months”,12,IF(D5=”days”,365))))*100) which explains if the value in cell (D5) is in years it will multiply the cell (C5) value with 1. Otherwise, move to the next loop search for the proper selection, and display output according to it.
  • Hit ENTER to get the “Total Maturity Amount”.
  •  

    • Therefore, select another cell (C11) and apply the below formula where we will get the total interest amount by subtracting the “Total Maturity Amount” from the “Deposit amount”-
    =C9-C4

    Apply Formula to Calculate FD Interest

    • In conclusion, we have got out the “Total Interest Amount” for our Fixed Deposit amount. You can also calculate the FD interest from the Excel sheet placing your desired values. Enjoy!

    FD Interest Calculator Excel

    Read More: Simple Interest Formula in Excel (With 3 Practical Examples)


    Things to Remember

    • Don’t forget to put closing brackets at the end of the formula. Otherwise, the formula won’t work.

    Conclusion

    In this article, I have tried to cover all the methods to create an FD interest calculator in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


    Related Articles

    Wasim Akram

    Wasim Akram

    Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

    We will be happy to hear your thoughts

    Leave a reply

    5 Excel Tips
    You Never Knew

    Genius tips to help you unlock Excel's hidden features

    FREE EMAIL BONUS

    ExcelDemy
    Logo