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.

P*(1+r)ⁿ + I*[(1+r)ⁿ – 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

ROI (r)

About Savings Calculator

The formula is per below:

P*(1+r)ⁿ+ I*[(1+r)ⁿ – 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.

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 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 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%.

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

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

= $5,000 x (1+0.63%)³⁶ + $100 x [ (1+0.63%)³⁶ – 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 to invest in a fixed deposit scheme where she will deposit $56,000 as initial and then she would be depositing quarterly $2,000 until 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%.

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

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

=$56,000 x (1+2.00%)¹² + $2,000 x [ (1+2.00%)¹² – 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.