WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Financial Calculators » Savings Calculator

Savings Calculator

Simple Savings Calculator

This simple savings calculator can be used to calculate what will the total value of investment done by the investor over a period of time.

Savings Calculator

P*(1+r)n + I*[(1+r)n – 1 / r ]


Wherein,
  • P is the Initial amount invested
  • I is the periodically equal savings invested
  • r is the rate of interest per annum
  • n is the number of period or frequency wherein the amount is to be invested
Initial amount invested
$
periodically equal savings invested
$
rate of interest
%
number of period or frequency wherein the amount is to be invested

About Savings Calculator

The formula is per below:

P*(1+r)n + I*[(1+r)n – 1 / r ]

Wherein,

  • P is the Initial amount invested
  • I is the periodically equal savings invested
  • r is the rate of interest per annum
  • n is the number of period or frequency wherein the amount is to be invested

It can be used to calculate the future value of the investment amount where the investor invests a lumpsum amount and, thereafter, invests a smaller equal amount periodically as per his convenience. This calculator can be used where an investor invests either in recurring fixed deposits or in mutual funds or any other product where the investor is required to invest in equal installments with equal amounts. This can help the investor decide where to invest in and which product to select and what amount will be due to him at the end of the investment period or, in other words, at the time of maturity.

How to Calculate Using Savings Calculator?

One needs to follow the below steps in order to calculate the investment maturity value.

Step #1 – First of all, determine the initial amount that is to be invested as a lumpsum amount.

Step #2 – Now, Compound the initial amount either monthly, quarterly, semi-annually, or annually by the rate of interest until the maturity period as the case may be.

Step #3 – We now need to determine the future value of the monthly installment amount with the same rate of interest that was used to calculate the maturity value of the initial investment.

Step #4 – Now, we can take a total of values arrived on step 3 and step 4, which shall be the savings maturity value.

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
You can download this Savings Calculator Excel Template here – Savings Calculator Excel Template

Example #1

Mr. Winter is a newbie in the investment field and wants to invest in the stock market. However, he does not want to take the risk. He approaches a financial advisor, and he gets confused with the term he uses; and in his final discussion, the advisor tells him to learn about the markets first and start investing in mutual funds. Since he was sitting with idle cash, the financial advisor advises him to invest $5,000 as a lump sum in a debt scheme and invest $100 monthly for 3 years to learn about the market and sees how the investment grows. On average, the debt scheme in which he will be investing earns 7.5% p.a.

Based on the given information, you are required to calculate what would be the value of an investment after 3 years, assuming that the investment takes place at the end of the period?

Solution:

We need to calculate the maturity value of the initial investment, which is $5,000 here, and along with it, we need to calculate what will be the future value of the monthly savings that are invested in this debt scheme, which is $100, and the term is 3 years which is 36 months.

The interest earned on the investment is 7.5%, and when it compounds monthly, it shall be 7.5%/12, which is 0.63%.

Example 1 (Given Data)

We can now use the below formula to calculate the savings total.

Installment = P * (1+r)n  +  I * [(1+r)n – 1 / r ]

Savings Calculator Example 1

= $5,000 x (1+0.63%)36 + $100 x [ (1+0.63%)36 – 1 / 0.63% ]

= $10,280.37

Hence, the maturity value will be $10,280.37

Example #2

Mrs. Kavita aging 57 years, is nearing retirement from the firm where she has worked for around 20 years. She now has become a risk-averse person and wants to lead a safe life now wherein she gets a quarterly fixed amount for her spending. She is interested in investing in a fixed deposit scheme where she will deposit $56,000 as initial and then she would be depositing quarterly $2,000 until the next 3 years so that after she retires, she has the lump sum amount which then she will use to invest in quarterly paying out interest fixed deposit scheme. The current rate of interest is 8%.

Based on the given information, you are required to calculate the savings she would have at the time of retirement.

Solution:

We need to calculate the maturity value of the initial investment, which is $56,000 here, and along with it, we need to calculate what will be the future value of the quarterly savings that are invested in this fixed deposit scheme, which is $2,000, and the term is 3 years which is 12 quarters.

The interest earned on the investment is 8.00%, and when it compounds quarterly, it shall be 8.00%/4, which is 2.00%.

Example 2 (Given Data)

We can now use the below formula to calculate the savings total.

Savings = P*(1+r)n  +  I * [(1+r)n – 1 / r ]

Savings Calculator Example 2 (Result)

 =$56,000 x (1+2.00%)12 + $2,000 x [ (1+2.00%)12 – 1 / 2.00% ]

=$97,845.72

Hence, the maturity value will be $97,845.72.

Conclusion

The savings calculator, as discussed, can be used to calculate the maturity value of the investment, which is done in periodical installments and as well as by investing a certain amount as lumpsum. The rate of interest earned could be monthly, quarterly, semi-annually, or annually.

Recommended Articles

This has been a guide to the Savings Calculator. Here we discuss how to calculate the savings done by the investors over a period of time along with step by step examples. You may also take a look at the following useful articles –

  • Examples of CD Interest Calculator
  • Examples of Mortgage Points Calculator
  • Formula of Compound Interest in Excel
  • Investment vs Savings
4 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 Savings Calculator Excel Template

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