Calculate Value of Savings/Retirement Plan in Excel – FV()
This teaches you how to use the FV() Future Value function in excel in order to calculate how much a savings or retirement plan will be worth in so many years. This is a simple example and assumes annuity like payments. You will learn how to do this on an annual basis and then how to modify that to work for any number of deposits per year or period.

If you want to follow along with the spreadsheet seen here or just to download that spreadsheet, check out the website and navigate to this tutorial:

Duration : 0:7:12

[youtube 65oqSMy25MQ]