Say we invest \$5000 at 6% per annum where interest is compounded monthly. At the end of each month, after the interest has been added, we'll make an additional deposit of \$100.
Firstly we need to change our interest rate from annually to monthly by dividing by 12, so we get 0.5%.
The balance at the end of the first few months can be calculated as follows.
End of month 1 | 1.005\times 5000+100 | = | \$5125 |
---|---|---|---|
End of month 2 | 1.005\times 5125+100 | = | \$5250.63 |
End of month 3 | 1.005\times 5250.63+100 | = | \$5376.88 |
Notice for our purposes here we round each balance to 2 decimal places and then use the rounded amount in our summary.
To be able to examine the balance in a few years time, we don't really want to manually calculate the values in the table. Instead, we'll write a recurrence relation and then analyse it using a spreadsheet.
B_{n+1}, the balance at the end of month n, can be defined as:
B_{n+1}=1.005B_n+100, where B_0=5000
Notice I've used our initial investment amount and provided B_0=5000 rather than using B_1=5125. We can use either of these.
To determine the value of our investment after 2 years, we'll use the spreadsheet applet below:
You can change the original investment amount, the annual interest rate, how often the interest is compounded and the regular deposit amount. Note that here our extra deposits always match the number of compounding periods each year.
For the example above, the amount invested is \$5000, the annual interest rate is 6\%, the number of compounding periods is 12 per year and the deposit amount is \$100. So the values in cells B1
to B4
are correct for our example. However, the data only goes to the 12th month, and we need to go up to the 24th month.
In cell E30
you should have a total of \$8178.99 after 24 months.