Greenblatt’s Magic Formula

by John Bajkowski

Greenblatt’s Magic Formula Splash image

Long-term success relies on both a sound strategy and the discipline to follow your approach during bull and bear markets. In “The Little Book That Still Beats the Market” (John Wiley & Sons, 2010), Joel Greenblatt shows that his “Magic Formula” approach holds up over the long term, but that you need to be prepared for brief runs when it underperforms the market. The approach seeks out good companies with a high return on invested capital that can be purchased at an attractive pretax earnings yield.

Greenblatt measures the strength of a business by examining its return on capital, which he defines as operating profit (EBIT, earnings before interest and taxes) divided by tangible investment capital (net working capital plus net fixed assets). If you do not have access to this variable, Greenblatt suggests that investors use return on assets (net income divided by assets) or visit his website (www.magicformulainvesting.com), which has a free magic formula screening tool.

To help value a business, Greenblatt takes the price-earnings ratio, inverts it and tweaks the variables slightly. Greenblatt calculates earnings yield by dividing EBIT by the enterprise value. The enterprise value tries to reflect the minimum value to purchase a company outright. It is calculated by adding market capitalization, preferred stock, and total debt and subtracting excess cash. Greenblatt notes that you can also look for low price-earnings ratios, but warns to avoid firms with extremely low ratios because earnings may be unusual in some way.

...To continue reading this article you must be registered with AAII.

Gain exclusive access to this article and all of the member benefits and investment education AAII offers.
JOIN TODAY for just $29.
Log in
Already registered with AAII? Login to read the rest of this article.

Register for FREE
to read this article and receive access to future AAII.com articles.
  
John Bajkowski is president of AAII.


Discussion

John from Colorado posted over 2 years ago:

Is there anyway to make the spreadsheet user friendly readable on my MAC, without having to print it out? On my MAC I can't drag the corners to have the sheet appear completely. It requires that I use the up/ down and side to side arrows. which causes me to lose the left and irght columns/rows that define the criteria of the company's.


Wesley from New Mexico posted over 2 years ago:

Nice summary of Greenblatt's book. I read the book and there is very little to add beyond your article. I think this is a good shortcut to estimating company value. But I would hesitate to follow the investment advice. There are probably several reasons why this could be viewed as inadequate; I shall list two:
1. There is no decision threshold in this process, just the magic number 30. Presumably there are times when no company is a value and it would be prudent to withhold from the market. There may be other times when many companies are selling at a value. A decision threshold or at least a guideline would be useful in making the distinction.
2. In addition to a company being a value, I am concerned about issues of debt (risk of bankruptcy and potential future interest burden) and persistent dividend yield (an additional measure of strength and durability). Adding Greenblatt's formula to a short list of additional criteria seems valuable. Using it as a standalone omits a lot of valuable information.


David from Alabama posted over 2 years ago:

Thanks a million for providing the info for use in Stock Investor Pro. This is very helpful and greatly appreciated. Please continue to provide this type of assistance.


Donald from Michigan posted over 2 years ago:

I've been tracking the performance of a portfolio of 30 MFI stocks with a market cap of $50M purchased on the first of each month since August. You can see the holdings and performance of the 5 portfolios here:
http://dark-liquidity.com/MFI.php


Terry from California posted over 2 years ago:

The "Magic Tangible Capital" calculation should include PPE.


John from Wyoming posted over 2 years ago:

Is there anyway to make the spreadsheet user friendly readable on my Windows PC, without having to print it out? On my PC I can't drag the corners to have the sheet appear completely. It requires that I use the up/ down and side to side arrows. which causes me to lose the left and irght columns/rows that define the criteria of the company's.


Daniel from Arizona posted over 2 years ago:

I would like to reinforce what John from Colorado said about the worksheet, as well as John from Wyoming. I use Ubuntu Linux and have the same problem.


Donald from Michigan posted over 2 years ago:

If you are referring to the Magic Formula Stocks table you can download the worksheet here into excel (and other formats):

https://docs.google.com/spreadsheet/ccc?key=0Ar-HKg-x7RcadFdpbGNPbDc2Tk9WMDZGckhKT0VmV1E


Charles from Illinois posted over 2 years ago:

We adjusted the table to appear in a spreadsheet format. If you click on "Full Screen View," you should be able to see the table without scrolling on all PCs. - Charles Rotblut


Arnold from Hawaii posted over 2 years ago:

On the spreadsheet, the ranks are given in columns C & D. How were these determined and printed. I am aware that the Magic Formula Total is the sum of these to columns. Thanks


William from Florida posted over 2 years ago:

I don't know why you've programmed a web site to demand cookies to display a simple spreadsheet.

This is one page I won't be looking at as I'm unwilling to putz around that much to see a simple table.


Lee from Massachusetts posted over 2 years ago:

can't fine the list of 30 stocks and can't find any spreadsheet.


David from New York posted over 2 years ago:

This is the first AAII article with a screen which was not viewable 'because cookies are not enabled in your browser'. But they are. Please correct.


Paul from California posted over 2 years ago:

The cookie issue is because the spreadsheet is hosted on Zoho. To see the spreadsheet using Safari (and possibly FireFox and other browsers) you need to enable "Always Accept Cookies". By default it is safer to only accept cookies from sites you visit. If you trust AAII and Zoho then go ahead and accept setting a cookie from a site you haven't navigated to directly.


E b from Florida posted over 2 years ago:

I gather that the ranking of the companies by enterprise value and return on captital is something that is unavailable inside of Stock Investor Pro.
This article was of great interest to me since I had purchased the book not so long ago.


Arnold from Hawaii posted over 2 years ago:

The screen criteria and the custom fields for use with SIP are available for SIP subscribers. However, I can get no help on setting up a View Menu to show the "Ratio - Rank" for the EBIT/Enterprise Value or the Return on Capital. Would appreciate help.


You need to log in as a registered AAII user before commenting.
Create an account

Log In