Savings Calculator

  • Version
  • 5'680 Downloads
  • 16 KB File Size
  • January 4, 2022 Updated
  • 3 Number of comments
  • 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.

Savings Calculator

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.

You can download the file here.

How useful was this template?

Click on a star to rate it!

Average rating 4.7 / 5. Vote count: 49

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

We are sorry 🙁

Help us improve!

How we can improve this template?

Annuity Calculator

14 KB / 5486 downloads
Compound Interest Calculator

16 KB / 4721 downloads
Net Worth Calculator

14 KB / 5176 downloads
View Comments