# Magic Formula investing & Price Index 6m

This article shows you the returns the Magic Formula investment strategy achieved in Europe over the 12 year period from June 1999 to June 2011.

### How to improve the Magic Formula from 183% to 783%

You can also see how you can improve the Magic Formula returns from 183% to 783% by just adding one simple easy to calculate ratio.

First a bit of background information.

As 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 capita**l (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 screener does all this for you with the click of a button.

Companies with the lowest combined rank (high quality companies that are undervalued) are recommended for purchase, usually the top 30 companies.

** **

### 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 applied to European companies first some information on how we tested.

### Methodology

We only use historical accounting data and no forecasts. The reason is that there is a lot of evidence that forecasts cannot be relied
on. In * The New Contrarian Investment
Strategy*, David Dreman writes about a study that used a sample of 67.375
analysts' quarterly estimates for companies listed on US stock
exchanges.

The study found that the average analysts’ error was 40%, and that the estimates were misleading two-third - 66% - of the time!

### The backtest universe and benchmark

Our backtest universe is a subset of companies in the Datastream database containing an average of about 1500 companies in the 17 country Eurozone market 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 also excluded.

### It was not a good time to invest in stocks

The test period was most certainly 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 publicly 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 low price-to-book (PB) value strategy, the back test universe was ranked from the cheapest (lowest PB) to the most expensive (highest PB) stocks.

The cheapest 20% of 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 generate?

These were the returns the Magic Formula investment strategy 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 most undervalued 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**

The best Magic Formula investing companies all substantially outperformed the market which returned only 30.54% over the same 12 year period.

** **

### You can improve the returns of the Magic Formula strategy

We also tested the Magic Formula investing strategy with a lot of other ratios as you can see in the table below the returns of the strategy can be improved substantially.

*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).

### 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

**PS** To find Magic Formula investment ideas in the countries you invest in (for less than an inexpensive lunch for two) click here: Join today

### 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.

**Period**

May 1999 - May 2011

**Index**

+2.25% pa

**Return**

+19.9% pa +783.3% 12yr