Lesson 2 - Value of Money - Part 7

Click Here to Open The Chart in a New Tab

As we can see from the chart we need a few variables in order to calculate how much savings will be required to achieve our Goals. We have provided an Excel file which can be downloaded with all of the equations already built in.

We will go over some variables that are required. First we must know how long we have before we need the money for whatever Goal it might be. In our example, we will retire in 34 years. This is how long we have to save, and so on. In the next column we have our Inflation Rate. Since Our Goals take place in the future, we must assume that things will cost more in the future. I’m certain that $100 dollars today will not be able to buy the same amount of goods 40 years from now.

Therefore, we must adjust the cost of our Goals for how much inflation they will incur over the years. Luckily calculating the amount of inflation that will affect our savings requirements is the same as calculating an Ordinary Annuity. Reminder an Ordinary Annuity is calculated by: C = Cash Amount
i = Interest Rate
n = number of payments

In our spread sheet we have already entered the calculations.

It is important for us to keep in mind that some of our Goals might increase at lower or higher inflation rates. Our overall economy should expect about a 3% inflation every year. However, the cost of college has been going up almost twice as fast as inflation at around 6%. If we miss this important knowledge, we could come up short when it’s time to pay for our childes college. This is only an example and it could be another one of your life Goals.

If we look at the column labeled “Future Value of $1” this is our Ordinary Annuity Calculation with 1 dollar. If we look at the column labeled “Retirement” If a sandwich costs $1.00 today, in 34 years it will cost $2.73 dollars in today’s money.


Please Join or Login to Join the Conversation