Compound Interest Calculator In Excel - Calculate Savings Using FV Function

We build a compound interest calculator in Excel to calculator your savings. In other words, based on your initial investment, annual interest rate, savings term, compound frequency and monthly standing order we’ll use the future value formula to calculate the final savings amount which can be used to calculate the annual interest gained. We also build a calculation table to provide a periodic breakdown of your savings and check that the future value calculation is correct.
DISCLAIMER: Although I have taken great care to check all of the calculations, I am not a qualified accountant or advisor and you should not use this video to substitute financial advice. Make sure you talk to your own accountant or financial advisor before you use this calculator to make any financial decisions.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Compound Interest Calc...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[e-mail]
Overview: (0:00)
Inputs: (0:38)
Calculate Savings Using FV Function: (1:34)
Calculation Table: (3:06)
Testing: (5:00)

[@shilabass7292]

I've been looking for a way to do this on excel and none of the results made me understand and now i have finally been able to complete my Savings excel sheet! Thank you so much!

[@andrewspencer4843]

The most succinct explanation of this topic I've seen. Thank you!

[@theexcelhub]

Thank you very much!

[@Locomaid]

Thank you! Short, simple and sweet 😊

[@DakodaS246]

Thank you! I have been looking for days for something like this.

[@ksumar]

Amazing this is the formula I was looking for. I did it in my ACCA a long time ago but your layout is amazing. Thank you Sir!

[@aalhaidari]

Thank you! That was very helpful, and easy to apply!

[@VP-yp8ip]

This example is well explained. Thanks a lot for your help.

[@care.nuegado]

Thank you very much, your an Absolute Legend 🙌

[@ffarag]

Great Tips Sir, many many thanks for your time and efforts

[@santumos]

Wonderful! Thank you

[@NimeroRamones]

You saved me, thank you!

[@MrMox1962]

Excellent video, does exactly what I wanted.

[@theexcelhub]

Thank you!

[@davelardner6644]

Excellent exactly what I needed, thanks.

[@theexcelhub]

Glad it helped!

[@dumitruserban1602]

Ty very much!!!

[@andrewjohnclaveria-mk1jh]

Thank you heaps

[@NUMAIRLNS]

Cheers for the information. This video made much more sense than anything else on youtube. I was wondering if you could rework your formula to deal with a long term investment. Say a stocks and shares isa being used as a retirement pot. Compound over 20 odd years.

[@theexcelhub]

Thanks for watching! Is there anything stopping you from using 20 as the length of time and 1 as the compound frequency if it compounds annually?

[@rajesha7176]

Thank you. How to change for varying monthly contribution ?

[@kirtxpress]

Thanks for this. What do I do if I don't make equal contributions monthly? some months willl be more than others.

[@chrisb2087]

Nice fit dude, I like the scalability / flexibility. A little too fast when describing the FL formula though.

[@serenadesay2334]

What if I contribute monthly with different amount and I put it in Term deposit of 1 year and rollover principle + interest. How do I calculate that?

[@RomyMacias]

The formula =-FV(C7/C9,C8*C9,C10,C6,1) gave me this: #¿NOMBRE? Could you please direct me towards what I did wrong? Thanks!

[@karthikeyang5079]

Could share that excel sheet

[@qcfpwubster9262]

How about daily compound of 1 %?

[@josephoconnor3168]

Can someone please post the formula?

[@karthikeyang5079]

If we don't have contribution period. How can we use the table

[@theexcelhub]

Have you considered inputting 0 for the contribution per period input?

[@karthikeyang5079]

@@theexcelhub yes

[@suryaprakashg]

your website is down

[@zapierdzialekalesony9260]

what about inflation?;)

[@scajoh3001]

THIS IS NOT ACCURATE! The error is marginal, but with the biggest numbers the error can increase to millions. You cannot divide the interest directly by months. The interest must be calculated with a higher root =(1 + r) ^ (1/12) -1 (1+1.5%)^(1/12)-1 NOT 1.5%/12

[@tristonstephens5728]

This formula is not accurate