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. Financial institutions make money by giving you a lower interest rate on your savings and charging a higher interest rate to borrow money. Interest can be simple or compound.

Simple interest is calculated on the original savings amount or initial amount borrowed. Compound interest is calculated on the original savings or debt amount plus the accrued interest from previous periods. Your money grows faster with compound interest which makes compound interest great for savings but punitive for 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 essentially interest earned on interest. It is a powerful financial tool, but many people don’t fully understand its benefits, especially 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 each year. With compound interest, the same savings account will earn interest of ยฃ51 in the first year. In year two the interest will be ยฃ53 and in year three it will be ยฃ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. At the end of the first month, you earn interest of ยฃ4.17 (ยฃ500 x 10%=ยฃ50 divided by 12 months). In the second month, you earn interest on the increased 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 adding 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 way to calculate compound interest and its exponential qualities 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 to calculate the future value of an investment, which we cover 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 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: