- 4'737 Downloads
- 16 KB File Size
- January 4, 2022 Updated
- 3 Number of comments
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.
You can download the file here.
We are sorry 🙁
Help us improve!
How we can improve this template?
hello ( )
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.
pushap jain ( )
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.
Hanumesh ( )
I need a formula which will calculate a monthly investment (say 1000) increasing annually by say 10% with a investment return of say 12% over say 10 years.
What is the formula?, answer is 326 889.85
I need the formula for Excel.