# Savings Calculator

• Version
• 16 KB File Size
• September 15, 2009 Updated
• Yes Free
• Rating
table of content

This is a savings calculator in excel you can use if you want to know how much your savings will grow after one year or ten years or event 30 years from now. With this spreadsheet, you can simulate several scenario on saving your money in your aimed bank. Or, by seeing the excel built-in function inside the spreadsheet, you can do the calculation by yourself.

This calculator uses the future value built-in function, FV(rate,nper,pmt,pv,type), where rate is your savings interest rate, nper is your savings period, pmt is your savings amount if you plan to save your money regularly, pv is your current savings, and type is the time when you save your money.

In my calculator, I made two future value of savings based on regular monthly or yearly savings, so you can compare how your savings will grow. As you can see in the calculation result, even though the absolute savings amount is the same for one year period, your savings amount will be higher if you save your money monthly. Use this calculator as your side reference only, because your banks probably have different interest calculation that will make the result different from this excel calculation.

Click on a star to rate it!

Average rating 4.9 / 5. Vote count: 42

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

sir,

i need formula for Earth work calculation and chart on Excel sheet. i want to calculate “filling and cutting” quantities for soil. please if u can do it then send me by mail.

very very thanks for you.

I need a calculator which can calculate interest after a specified period at a fixed rate of interest.
however, in this specified period there may be no. of deposit & no. of withdrawls on different dates.
for example, say I have an opening balance of 10000\$ on 01/04/2009.
I withdraw 50\$ on 12/05/2009.
I deposit 78\$ on 15/06/2009.
I deposit 12\$ on 18/06/2009
I withdraw 112\$ on 22/09/2009
I withdraw 80\$ on 12/12/2009

I get 5% interest on my deposit on yearly basis.
What will be the interest on 31/03/2010.