How to Calculate Future Values Using Timelines

In economy it’s important to know about future values, as the value of money changes over time. $1 today is not worth the same as $1 will be worth in a year. Inflation and the general economic development in the world is affecting the value of money. This is important to take into consideration when looking at money from different time periods.

Theory

Future Value

When we talk about future values, we are describing how much money will be worth some time in the future. Future values are often related to saving and repayment of loans, and has a quotient

k = growth factor = (1 + p 100) n.

The future value Kn of a sum of money K0 you want to use in n periods of time is given as

Kn = K0 (1 + p 100) n,

where p is the interest in percentages.

Example 1

Given that you deposit $5000 into a fund for saving that guarantees an annual return of 7.5% for the next 20 years, how much money will you have in 20 years?

Kn = 5000 (1 + 7.5 100) 20 = 21239.26$

Kn = 5000 (1 + 7.5 100) 20 = 21239.26$

This means that if you deposit $5000 into the fund today, that money will be worth $21239 in 20 years.

Installment and Savings

When we’re looking at installments and savings, it’s often smart to draw timelines. A timeline helps you keep control of how many periods of time give you interest on your money. Here is an example of future values connected to saving.

Example 2

How much money will you have in the bank if you save $100 each month for 15 years? You deposit the money once a year, and the interest is 4.7%.

For this type of exercises it is a good idea to use timelines. But first we need to find out how much money you will save each year:

100 12 = $1200

Then the timeline looks like this:

Timeline showing the future value of the yearly deposits

This gives you the geometric series

1200 1.047 + 1200 1.0472 + + 1200 1.04715,

1200 1.047 + 1200 1.0472 + + 1200 1.04715,

with

a1 = 1200 1.047,k = 1.047,n = 15.

a1 = 1200 1.047,k = 1.047,n = 15.

You can then insert these numbers into the formula for the sum of a geometric series:

S15 = (1200 1.047) 1.04715 1 1.047 1 = $26507.13

S15 = (1200 1.047) 1.04715 1 1.047 1 = $26507.13

This means that you save $26507.13 in 15 years. If there was no interest on the money, you would have saved 1200 15 = $18000. That makes the total amount of interest you’ve gotten

$26507.13 $18000 = $8507.13,

which is quite amazing!

Example 3

You created a bank account on 01.01.2015 with an interest rate of 4.5% and deposited $1000 into the account. You will continue to deposit $1000 at the start of every new year.

Part 1 You want to save a total of $25000. How many years will you have to save to get $25000 in the account, given that the interest rate doesn’t change from 4.5%?

This gives you the geometric series

1000 1.045 + 1000 1.0452 + + 1000 1.045n.

1000 1.045 + 1000 1.0452 + + 1000 1.045n.

The geometric series can also be shown as a timeline like this:

Timeline of saving 1000 dollars per year over n years

Where a1 = 1000 1.045 and k = 1.045.

The final sum is set to be Sn = 25000, which makes n the unknown you need to find. That means you need to use the formula for the sum of a geometric series and solve the equation for n. You will then get the number of years you need to save in order to get the final sum you wanted.

Sn = a1kn 1 k 1 25000 = 1000 1.045 1.045n 1 1.045 1

This equation can be input into a digital tool like CAS in GeoGebra. That will give you the solution n = 16.6. This means that you have to save for 17 years to reach the total of $25000 you wanted in your account.

Part 2 – You would like to achieve the total sum of $25000 in just 15 years. If the interest rate stays the same at 4.5%, how much would you have to deposit every year to achieve this?

This can be expressed as the geometric series

x 1.045 + x 1.0452 + + x 1.04514 + x 1.04515,

x 1.045 + x 1.0452 + + x 1.04514 + x 1.04515,

which can also be represented as the following timeline:

Timeline of saving x dollars per year over 15 years

This time the unknown is the annual deposit x. This gives you

a1 = x 1.045,k = 1.045, n = 15,Sn = 25000.

a1 = x 1.045,k = 1.045,n = 15,Sn = 25000.

You can use the same formula as in part 1, but now you solve it for x:

Sn = a1kn 1 k 1 25000 = x 1.045 1.04515 1 1.045 1

You can solve this equation with a digital tool, which will give you that the annual deposit has to be $1151.05 to get $25000 in the account after 15 years.

Want to know more?Sign UpIt's free!