PortalKota – Calculate Value of Savings/Retirement Plan in Excel – FV(). In this tutorial, I'm going to show you how to use the future value function and Excel in order to figure out how much a series of annual deposits are going to give you in certain amount of time.
So if you have a savings or Retirement Plan, say you want it for 40 years and you'll get 5 percent and you deposit so much every year.
How much is it going to be worth so? This is a very basic example and it's showing you how to use the future value. What I have here, I have two sets.
I have doing this annually right here. So what it's going to do is say you deposit so much every year. At the end of the year or the beginning of the year and then down here, I assume that you deposit so much monthly.
The point is just to show you what you have to change to change the amount of periods.
Calculate Value of Savings/Retirement Plan in Excel – FV()
Now here I have the years so how many years you want to have it, I guess vesting the rate you think you'll get the starting amount, so the starting amount is how much you already have any account or the Retirement Plan.
When you start the calculation and here the annual deposits, now really the only place you need, the formula is to get the value over here. So that's the only place you're going to have and it's going to be a future value formula.