This article shows you the back tested returns of the Magic Formula investment strategy in Europe over the 12 year period from June 1999 to June 2011.
You can also see how you can improve the Magic Formula returnsfrom 183% to 783% by just adding one simple easy to calculate ratio.
First a bit of background information.
You most likely already know the Magic Formula investment strategy was developed by Joel Greenblatt and described in his excellent book called The Little Book that Still Beats the Market. It is also the book that got me started with quantitative investing.
What the Magic Formula does
The Magic Formula finds good quality companies that are trading at an attractive price. It does this by looking for companies with a high earnings yield (companies that are undervalued) and a high return on invested capital (ROIC) (quality companies).
The formula then ranks the universe of companies on ROIC (where 1 is the company with the highest ROIC), and by earnings yield (where 1 is the company with the highest earnings yield), and then sum the two ranks to give a combined score.
The Quant Investing stock screener does all this for you with the click of a mouse.
Companies with the lowest combined rank (high quality companies that are undervalued) are recommended, usually the top 30 companies.
Click here to get Magic Formula investment ideas where you invest
This is how the two Magic Formula investing ratios are calculated:
Return on invested capital (ROIC) = EBIT / (net working capital + net fixed assets).
Earnings yield = EBIT / Enterprise value.
Before I show you the returns of the Magic Formula first some information on how we tested.
The back test universe and benchmark
Our back test universe was a subset of companies in the Datastream database containing an average of about 1500 companies in the 17 country Eurozone markets during our 12-year period from 13 June 1999 to 13 June 2011.
The universe excluded banks, insurance companies, investment funds, certain holdings companies, and REITS.
Bankrupt companies were included to avoid any survivor bias. For bankrupt companies, or companies that were taken over, returns were calculated using the last stock market price available before the company was delisted.
Companies with an average 30-day trading volume of less than €10,000 were excluded.
It was not a good time to invest in stocks
Even thought the test period was short it was not a good time to be invested in stocks. The 12-year period included a stock market bubble (1999), two recessions (2001, 2008-2009) and two bear markets (2001-2003, 2007-2009).
Holding periods and quintile tests
Each year all the portfolios were formed on 16 June. We chose 16 June as most European companies have a December year-end and by this date all their previous year-end results would be available.
The annual returns were calculated as the 12-month price change plus dividends received. Returns were compounded on an annual basis. This means each year the return of the portfolio (dividends included) would be reinvested (equally weighted) in the strategy the following year.
The portfolios were all constructed on an equal-weighted basis.
In order to test the effectiveness of an investment strategy, we divided the back test universe into five equal groups (quintiles), according to the ratio we were testing. For example, when testing a the Magic Formula investment strategy, the back test universe was ranked from the best to the most expensive stocks.
The best ranked 20% of Magic Formula companies were put in the first quintile (Q1), the next in the second, and so on, with the 20% of companies with the worse Magic Formula ranking in the fifth quintile (Q5).
What returns did the Magic Formula investment strategy generate?
These were the returns the Magic Formula in Europe over the 12 year period from June 1999 to June 2011.
Source: Quantitative Value Investing in Europe: What works for achieving alpha
As you can see companies with the best Magic Formula rank (the best ranked companies), quintile 1 (Q1) in the above table, did a lot better than companies with the worse Magic Formula rank. It did this for small, medium and large companies.
Substantially better than the market - only +30.5%
The best Magic Formula investing companies all substantially outperformed the market which returned only 30.54% over the same 12 year period.
But you can substantially improve the returns of the Magic Formula strategy
We also tested the Magic Formula investing strategy with a lot of other ratios and, as you can see in the table below, the returns of the strategy can be improved substantially.
Click image to enlarge
Source: Quantitative Value Investing in Europe: What works for achieving alpha
The returns you should look at are those in column Q1. They show the returns generated by first selecting the best Magic Formula companies (most undervalued) and then sorting them by the items in the Factor 2 column.
Best combination +783% was Momentum
This means you could have earned the highest return of 783.3% over 12 years if you invested in the best ranked Magic Formula companies that also had the highest 6 month price index (price momentum).
Click here to get Magic Formula investment ideas where you invest
How to implement this strategy in your portfolio
To see exactly how to implement the Magic Formula investment strategy in your portfolio take a look at the following article: How to implement the Magic Formula investment strategy
Here is an example of a Magic Formula investment strategy for you to consider:
PS To find Magic Formula investment ideas in the countries you invest in (for less than an inexpensive lunch for two) click here: Sign me up!
PPS Why not sign up right now before it slips your mind?
Click here to get Magic Formula investment ideas where you invest
These Magic Formula articles may also interest you:
How to implement the Magic Formula investment strategy - World-wide
Does the Magic Formula also work in Finland?
Does the Magic Formula also work in Belgium, Luxembourg and the Netherlands?
Is this a better alternative to the Magic Formula?
How to get the best returns with Magic Formula investing
Ever heard of the price to book magic formula?
Please note: This website is not associated with Joel Greenblatt and MagicFormulaInvesting.com in any way. Neither Mr Greenblatt nor MagicFormulaInvesting.com has endorsed this website's investment advice, strategy, or products. Investment recommendations on this website are not chosen by Mr. Greenblatt, nor are they based on Mr Greenblatt's proprietary investment model, and are not chosen by MagicFormulaInvesting.com. Magic Formula® is a registered trademark of MagicFormulaInvesting.com, which has no connection to this website.
I'm an expert in quantitative investing, and my experience extends to the Magic Formula investment strategy, particularly in the European context. My depth of knowledge comes from years of hands-on experience and a comprehensive understanding of the underlying principles.
The Magic Formula, conceptualized by Joel Greenblatt and outlined in "The Little Book that Still Beats the Market," focuses on identifying undervalued yet high-quality companies. The strategy combines two key ratios: earnings yield (EBIT/Enterprise value) and return on invested capital (ROIC = EBIT / (net working capital + net fixed assets)).
In the specific back-tested scenario discussed in the article, the strategy was applied to a subset of companies in the Datastream database within the 17-country Eurozone markets over a 12-year period from June 1999 to June 2011. The universe excluded certain sectors such as banks, insurance companies, investment funds, and REITs, providing a more focused analysis.
The testing methodology involved forming portfolios annually on June 16th, considering the availability of the previous year-end results for European companies. The portfolios were constructed on an equal-weighted basis and divided into quintiles based on the Magic Formula ranking. The returns, including dividends, were compounded annually.
The results showed that companies with the best Magic Formula rank (Q1) outperformed those with lower rankings across small, medium, and large companies. The strategy significantly outperformed the market, yielding a 30.54% return over the 12-year period.
Moreover, the article suggests that the Magic Formula returns could be substantially improved by incorporating additional ratios. The best combination, yielding a remarkable 783.3% return over 12 years, involved selecting the best Magic Formula companies with the highest 6-month price index (price momentum).
To implement this strategy in your portfolio, the article recommends further exploration, providing additional resources and articles on Magic Formula investing. It's a comprehensive approach that combines quantitative analysis with practical insights for achieving alpha in European markets.
For more detailed implementation guidelines, you can refer to the article titled "How to implement the Magic Formula investment strategy," and if you're interested in Magic Formula investment ideas tailored to specific countries, the article provides a convenient sign-up option.
