Compound Interest

Red balloons with white percentage symbol on them

Interest is the money you earn on your savings or the charge you pay to borrow money. As a rule, you will receive a lower rate of interest on savings than you will pay to borrow money. Interest can be simple or compound.

Simple interest is calculated on the original savings amount or the initial loan or amount borrowed. Compound interest is calculated on the original amount plus the accrued interest from previous periods. Your money grows faster with compound interest. Compound interest is great for savings but punitive when you have debt.

Compound interest is the eighth wonder of the world. He who understands it, earns it, he who doesn’t, pays it!

Albert Einstein
Red balloons with white percentage symbol on them

Compound interest is interest on interest. It is a powerful financial tool, but many people don’t fully understand its benefits, particularly over an extended period. Compound interest grows wealth exponentially but can add significant costs to debt. Understanding how compound interest works is vital for growing wealth and understanding the impact on debt, allowing you to make more informed financial decisions.

With simple interest, a savings account with ยฃ1,000 earning 5% interest will generate interest of ยฃ50 every year. With compound interest, the same savings account will receive interest of ยฃ51 for the first year. In year two the interest will be ยฃ53 and in year three ยฃ57.

To further illustrate the power of compound interest, let’s assume you have a savings pot of ยฃ500 earning 10% compounding interest:

At the beginning of the month, your savings account has a balance of ยฃ500. In the first month, the interest is ยฃ4.17 (ยฃ500 x 10% divided by 12 months). In the second month, you will earn interest on your new account balance of ยฃ504, which is ยฃ4.20. At the end of month two the account balance is ยฃ508. At the end of month three the account balance is ยฃ513, after interest of ยฃ4.24. As you can see the amount of interest increases exponentially every month. The actual rate of interest is 10.5%.

Whilst this is wonderful for savings, compound interest isn’t quite so appealing for debt. To learn more about the impact of compounding interest on mortgages and credit cards, follow the links:

A quick and easy way to determine the impact of compound interest is the rule of 72. This is a handy tool when you want to know how long it will take to double the value of an investment. With an investment earning 10% interest, divide 72 by the interest rate of 10%, which is 7.2 years. This is roughly the time it will take to double the investment amount. There is a mathematical financial formula which calculates the future value of an investment earning a specified interest rate. We cover this later in this article.

The table below illustrates the exponential growth in interest and the value of the investment after 7 years. These figures agree with the rule of 72.

In this example, the compound interest is ยฃ10,080 over 7 years, doubling the investment.

YearOpening balanceAnnual interestBalance including interest
110,0001,04711,047
211,0471,15712,204
312,2041,27813,482
413,4821,41214,894
514,8941,56016,454
616,4541,72318,177
718,1771,90320,080
Monthly compounding interest of 10% over 7 years on initial amount of ยฃ10,000

For those of you interested in maths, the financial formula for compounding interest is: A = P(1+r/n)^nt

Where:

  • A = the future value of the investment plus interest
  • P = the initial or capital amount of the investment
  • r = the annual rate of interest expressed as a decimal value
  • n = the number of times interest is compounded over a period
  • t = the amount of time that the money is invested for
  • ^ = to the power of

In this example, assume an investment of ยฃ5,000, invested for 5 years, earning 5% interest, and compounding monthly.

A =5,000(1+0.05/12)^12*5
A =5,000(1.004167)^60
A =5,000 x 1.283359
A =6,416.79
Calculation of the future value of ยฃ5,000 invested for 5 years with a 5% return

To use Excel to calculate the future value, enter the data as follows:

=5000*(1+0.05/12)^(12*5)


Posted

in

by

Tags: