Forex Compounding Spreadsheet
The Best Secret in Investment and Trading – Compound Interest
Albert Einstein – yes, the "and equal" mc squared, said interest compound was the greatest mathematical discovery of all time, and this brief summary that just might convince the right he was.
When one examines first a potential investment, is naturally viewed in the title is expected rate of return, but the composition of the interest (or profits) in the main that creates the greatest return over time.
The capitalization of profits, dividends or interest or apply in all financial markets, so if you are a short-term trader, stock market, property investors and other holders of assets for short or long, can find the magic of compound interest interesting. Let see here how although the use CFDs and compound interest can potentially generate a staggering cost.
The rule of 72 and long-term
You may not have learned this in school, but Einstein's rule of 72 is one of the most magical and simple formulas around. What this says is that to work for how long it takes to double the value of an investment, simple return is divided by 72.
So if you say that the stock market has returned around 11% on average over the last hundred years or so, (and the property is not far behind for that matter), after working an average time it would take an investment in the market has doubled, the calculation is 72 divided by 11, equivalent to about six years.
A few quick points need to be clear here. First, this rounded figure assumes all dividends are reinvested, and no charges for investment, which obviously is not realistic most investors. Does not include taxes of any kind, which would also have to take into account any refunds.
Duplication and doubling again
Once we have the time to double your money, this is where the magic of compound interest comes in, because it is possible to extrapolate some very tasty numbers in the long term.
If we return to long-term investment equity, and say that the real performance of the shares (which follows inflation and expenses) ie 5%, then you could calculate how much investment is needed and how long to give you a future value of $ 1M pounds in saying that today's money.
A simple spreadsheet can do this, but let's say you started with £ 10,000 and each year its investment appreciates by 5% in real terms. To double the original figure would take (72 divided by 5 or so) a little over fourteen years. Another fourteen years is what it takes to double again, and after 42 years of work, his £ 10,000 becomes £ 77,615 in real terms. However, this does not sound much, but of course this does not include any additional contribution made through their working lives.
But going back to nominal income, the story is dramatically different. Assuming a round of 10% per annum returns after expenses, it takes more than seven years to double your money. After 42 years, her £ 10,000 now worth £ 547,637 – a figure rather surprising. Now you can see the relationship with the evolution of property prices based on these long-term returns of the past, but As mentioned above the total return figures in the stock market (not just the number of indices have gone up) is even greater.
Only to show how this type of composition of works in the real world, Warren Buffett started with $ 105,000 for six fifties – it was a lot of money is true then. His fund's performance have been composed around 25% per year, and his fortune is over £ 50 billion today, becoming the second man rich earth.
monthly statements and hitting the magic million
How then does all this with the short term, and in particular CFD trading? The first thing we have to assume it is a good trading methodology is crucial to all traders, whether in shares, indices, currencies or raw materials. It is then possible to exploit their short-term investments for spectacular profits in just a few years.
Back to our Fiction £ 10,000 starting investment, but this time we will measure performance in months, not years. A very good trading system would return 1.5% per month after costs, adding to the 19.6% per year. This is not far from the kind of character that only the best hedge funds aim to match or improve the long term.
Without leverage, makes £ 10,000 £ 24,432 over five years, which is a very good lap on his own.
Using just three times without But take the return jumps to a staggering £ 140,274 in just five years.
You theoretically reach a million in less than nine years, and that's just from £ 10,000!
A word about the risk / reward
All the simulations above (with the exception of Warren Buffett) are based on average performance over the long term and ignore short-term movements. CFD traders should of course be aware that by increasing their leverage, the risk of significant declines in capital increases accordingly.
It is essential that all traders have applied systems money management and stop losses in place to protect against possible difficulties in trade, but through the use of CFDs with a profitable trading system and leverage, the sky is really the limit.
About the Author
Mike Estrey is the Head of Research for Blue Index, the Day Trading specialists in Contracts for Difference. Foreign Exchange Trading also forms part of their extensive services.