We cover how to calculate the future value for an investment that has variable returns using FVSCHEDULE. In reality, it's unlikely that investments will have the same returns every year, which therefore makes the Future Value function less suitable as this assumes fixed returns. In our example, we’re going to assume that we invest £10,000 for a duration of 5 years and the returns we get will be 5% in year 1, 6% in year 2%, 4% in year 3, a drop of 5% in year 4 and a gain of 9% in year 5.
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.
Compound Interest Calculator In Excel - Calculate Savings Using FV Function:
https://youtu.be/TvMKLRNnS6k
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/l8ShzCWF-Wc
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/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:
[email protected]Overview: (0:00)
Build calculation table: (0:43)
Use FVSCHEDULE: (1:46)