WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Financial Calculators » Fixed Deposit Calculator

Fixed Deposit Calculator

By Harsh KataraHarsh Katara | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Fixed Deposit Amount Calculator

The fixed Deposit amount calculator calculates the maturity amount along with the compounded interest that would have earned either monthly, quarterly, semi-annually, or annually.

Fixed Deposit Rate of Interest

P x ( 1 + r/N )nxN


Wherein,
  • P is the Principal amount that is invested initially
  • r is the fixed rate of interest
  • N is the frequency of interest being paid
  • n is the number of periods for which investment shall be made
Principal Amount
$
Fixed Rate of Interest
%
Frequency of Interest
Number of Periods

The formula for calculating this is per below:

Mathematically it can be calculated: A=P*(1+r/N)n*N

Wherein,

  • A is the total maturity amount
  • P is the Principal amount that is invested initially
  • r is the fixed rate of interest
  • N is the frequency of interest is paid
  • n is the number of periods for which investment shall be made.

About Fixed Deposit Calculator

This calculator can be used to calculate the amount of interest that shall be earned on the amount invested for a particular period. This calculator will provide us with the maturity amount at the end of the investment period. The interest could be paid either monthly, quarterly, semi-annually, or annually, and accordingly, the calculation needs to be made. This calculator can be used only if there is interest payment, which is compounded and not simple interest.

How to Calculate Fixed Deposit Maturity Amount?

One needs to follow the below steps –

Step #1 – Determine the initial amount which is supposed to be invested, which shall be your Principal amount.

Step #2 – Figure out the rate of interest that is being provided on the investment amount and the frequency of the same being paid, which shall be N.

Step #3 – Now, determine the period for which it shall be invested.

Step #4 – Divide the rate of interest by appropriate value depending upon the frequency. For example, if the rate of interest is 5% and it pays semi-annually, then the rate of interest would be 5%/2, which is 2.5%.

Step #5 – Now multiply the principal amount by a compounded rate of interest.

Step #6 – The resultant figure will be the maturity amount.

You can download this Fixed Deposit Calculator Excel Template here – Fixed Deposit Calculator Excel Template

Fixed Deposit Calculator Examples

Example #1

Bank Abu is one of the biggest banks in the country XYZ. It operates in multiple business-like commercial loans, corporate loans, overdraft facilities, overseas funding, locker facilities, etc. it has been in existing for almost 35 years now. One of the best products of the company is its fixed deposit. Customers are happy with the product as it provides the highest rate in the country. The interest rate differs for all the maturities. Below are the details for same:

Popular Course in this category
Sale
Financial Modeling Course (with 15+ Projects)
4.9 (927 ratings)
16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Mr. Umesh is interested in investing $100,000 for a period of 5 years. The bank pays interest quarterly. Based on the given information, you are required to compute the compounded interest as well the amount that Mr. Umesh will receive at the end of the maturity period.

Solution:

We are given the below details:

  • P = $100,000
  • R = Rate of interest, which is 7.50% that is applicable for a period of 5 years
  • N = Frequency which is quarterly here; hence it will be 4
  • n = number of years the investment proposed to be made, which is 5 years here.

Now, we can use the below formula to calculate the maturity amount.

A = P x ( 1 + r/N )nxN

Fixed deposit rate of interest example 1 (Maturity Amount)

= 100,000 x ( 1 + 7.50 / (4 x 100 ) )4 x 5

= 100,000 x ( 1.0188)20

= 144,994.80

Compounded interest will be:

Fixed deposit rate of interest example 1 (Compound Interest)

Compounded interest amount = 144,994.80 – 100,000 which shall be 44,994.80

Example #2

Mr. Seth is confused as to what period should he invest in and what product should he select from the below products. He wants to invest $50,000.

Fixed deposit rate of interest example 2

Based on the above information, you are required to advise Mr. Seth as to which product he should select?

Solution:

We are given the below details:

Product I

  • P = $50,000
  • R = Rate of interest, which is 9.60% that is applicable for a period of 10 years
  • N = Frequency which is semi-annually here, hence it will be 2
  • n = number of years the investment proposed to be made, which is 10 years here.

Now, we can use the below formula to calculate the maturity amount.

A = P*(1+r/N)n*N

Fixed deposit rate of interest example 2 (Maturity Amount)

= 50,000 x ( 1 + 9.60 / (2 x 100 ) )2 x 10

= 100,000 x ( 1.048)20

= 127,701.40

Compounded Interest will be:

Fixed deposit rate of interest example 2 (Compound Interest).png

Compounded interest amount = 127,701.40 – 50,000 which shall be 77,701.40

Product II

  • P = $50,000
  • R = Rate of interest which is 9.50% that is applicable for a period of 9 years
  • N =  Frequency which is Quarterly here, hence it will be 4
  • n = number of years the investment proposed to be made which is 9 years here.

Now, we can use the below formula to calculate the maturity amount.

A = P*(1+r/N)n*N

Example 2 - Product 2 (Maturity amount)

= 50,000 x ( 1 + 9.60 / (2 x 100 ) )9 x 4

= 50,000 x ( 1.0238)36

= 116,399.45

Compounded Interest will be:

Example 2 - Product 2 (Compound Interest).png

Compounded interest amount = 116,399.45 – 50,000 which shall be 66,399.45

Product III

  • P = $50,000
  • R = Rate of interest which is 9.45% that is applicable for a period of 9 years
  • N = Frequency which is Quarterly here, hence it will be 12
  • n = number of years the investment proposed to be made which is 9 years here.

Now, we can use the below formula to compute the maturity amount.

A = P*(1+r/N)n*N

Example 2 - Product 3 (Maturity Amount)

= 50,000 x ( 1 + 9.45 / (12 x 100 ) )9 x 12

= 50,000 x ( 1.0079)108

= 116,651.59

Compounded Interest will be:

Example 2 - Product 3 (Compound Interest)

Compounded interest amount = 116,651.59 – 50,000 which shall be 66,651.59

Hence, Mr. Seth should invest in product I to maximize wealth.

Conclusion

This calculator can be used to compare different fixed deposit schemes, and accordingly, the one that maximizes wealth will be chosen. Further, this calculator also depicts how the compounded works and how the amount increases

Recommended Articles

This has been a Guide to Fixed Deposit Calculator. Here we provide you the calculator that is used to calculate the fixed deposit maturity amount along with step by step examples. You may learn more about banking from the following articles –

  • Fixed Income
  • How to Calculate Auto Refinance Loan?
  • Auto Lease Calculator
  • Certificate of Deposit (CD)
  • Retirement Income Calculator
13 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Fixed Deposit Calculator Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More