Using the Magic Formula for Investing

by Cara Scatizzi

Learning to successfully invest in the stock market is simple, according to Joel Greenblatt’s “The Little Book That Beats the Market” (Wiley, 2005). Greenblatt is the founder and a managing partner of Gotham Capital, a private investment partnership. He is an adjunct professor at the Columbia University Graduate School of Business, and holds a B.S. and an MBA from the Wharton School.

Greenblatt wanted to write an investing book his children could read and learn from. The main point Greenblatt makes is that investors should buy good companies at bargain prices—businesses with high return on investment that are trading for less than they are worth.

Print this article

In this article


Share this article


About the author

Cara Scatizzi is a former associate financial analyst at AAII.
Cara Scatizzi Profile
All Articles by Cara Scatizzi

Finding Bargain Prices

To those familiar with the value investing style of Benjamin Graham, the latter point is fairly obvious: buy stocks at a lower price than their actual value. This assumes you are able to somewhat accurately estimate a company’s actual value based on future earnings potential.

Greenblatt says that stock prices of a firm can experience “wild” swings even as the value of the company does not change, or changes very little. He views these price fluctuations as opportunities to buy low and sell high.

First:   
Last:   
Email:

              

He follows Graham’s “margin of safety” philosophy to allow some room for estimation errors. Graham said that if you think a company is worth $70 and it is selling for $40, buy it. If you are wrong and the fair value is closer to $60 or even $50, you will still be purchasing the stock at a discount.

Finding Good Companies

Greenblatt believes that a company with the ability to invest in its business and receive a good return on that investment is usually a “good” company. He uses the example of a company that can spend $400,000 on a new store and earn $200,000 in the next year. The return on investment will be 50%. He compares this to another company that also spends $400,000 on a new store, but makes only $10,000 in the next year. Its return on the investment is only 2.5%. He would expect you to pick the company with the higher expected return on investment.

Companies that can earn a high return on capital (the return a company makes after investing in the business) over time generally have a special advantage that keeps competition from destroying it. This could be name recognition, a new product that is hard to duplicate or even a unique business model.

Magic Formula Basics

EBIT to Enterprise Value

Greenblatt compares a company’s ratio of EBIT (earnings before interest and taxes) to enterprise value against the risk-free rate. Enterprise value is a measure of company value that takes into consideration the firm’s capital structure (debt versus equity). You could do a simple earnings yield calculation by dividing net earnings by the market value of the company’s stock, but Greenblatt has a different take. He divides earnings before interest and taxes by a stock’s enterprise value.

A company’s enterprise value represents its economic value, which is the minimum value that would be paid to purchase the company outright. In keeping with value investment strategies, this is similar to book value.

Enterprise value is equal to the market value of equity (including preferred stock) plus interest-bearing debt minus excess cash.

Greenblatt uses enterprise value instead of just the market value of equity because it takes into account both the market price of equity and the debt used to generate earnings.

Companies with debt must pay interest on the debt and eventually pay off the debt. This makes the debt’s true acquisition cost higher. Adding debt to market capitalization lowers the EBIT-to-enterprise-value ratio, making a company less attractive.

See Member Benefits »

Take a peek
at all the member benefits AAII has to offer.
AAII is a nonprofit association dedicated to investment education.

Excess cash is subtracted from enterprise value because the un-needed cash reduces the overall cost of acquiring a business. If a company is holding $25 million in cash, the effective acquisition cost is reduced by that amount. Excess cash raises the EBIT-to-enterprise-value ratio, making the company more attractively priced.

The ratio of EBIT to enterprise value helps to measure the earnings potential of a stock versus its value. If the EBIT-to-enterprise-value ratio is greater than the risk-free rate (typically the 10-year U.S. government bond rate), Greenblatt believes you may have a good investment opportunity—and the higher the ratio, the better.

Return on Capital

Return on capital, or return on invested capital (ROIC) is similar to return on equity (the ratio of earnings to outstanding shares) and return on assets (the ratio of earnings to a firm’s assets), but Greenblatt makes a few changes. He calculates return on capital by dividing earnings before interest and taxes EBIT by tangible capital.

Instead of using net income, return on invested capital emphasizes EBIT, also known as pretax operating earnings. Greenblatt uses this number because the focus is on profitability from operations as it relates to the cost of the assets used to produce those profits.

Another difference in Greenblatt’s approach is the use of tangible capital in place of equity or assets. Debt levels and tax rates vary from company to company, which can cause distortions to earnings and muddy cash flows. Greenblatt believes tangible capital better captures the actual operating capital used.

The equity value typically used to calculate return on equity ignores assets financed via debt, and the total assets value used in the return on assets calculation includes intangible assets that may not be tied to the firm’s primary operation.

The higher the return on capital, the better the investment, according to Greenblatt.

Learn More »

Learning something new?
AAII is a nonprofit association dedicated to investment education. Take a peek at all the member benefits AAII has to offer.

Implementing the Magic Formula

Table 1 outlines the primary criteria Greenblatt used in his original study as well as his method for portfolio construction. The search started with a universe of the 3,500 largest exchange-traded stocks, based on market capitalization (shares outstanding multiplied by share price). Greenblatt used a market capitalization floor of $50 million, but advised that, based on your liquidity needs and risk aversion, you can set the minimum as high as $5 billion.

He then ranked the stocks from one to 3,500 based on return on capital (the highest return on capital got a rank of one; the lowest received a rank of 3,500).

Next, he ranked the stocks based on their ratio of EBIT to enterprise value, with the highest ratio assigned a rank of one and the lowest assigned a rank of 3,500. Finally, he combined the rankings (if a company ranked 20 for return on capital and 10 for EBIT to enterprise value, the combined ranking was 30).

For practical purposes, Greenblatt recommends investing in 20 to 30 stocks by purchasing five to seven with the lowest combined rank every few months. The holding period he advises for each stock is one year. He believes this strategy will allow you to make changes on only a few stocks at a time as opposed to liquidating and repurchasing the entire portfolio at once.

Table 1. Joel Greenblatt’s Magic Formula Investing

Stock Universe

  • Establish a minimum market capitalization that meets your liquidity needs. Greenblatt chose $50 million as his floor.
  • Exclude foreign companies (ADR/ADS).
  • Exclude stocks of utilities and financials.

Ranking

  • Rank the stocks in descending order based on the ratio of EBIT to enterprise value* and assign a rank number to each.
  • Rank the same stocks in descending order based on return on capital* and assign a rank number to each.
  • Add the rankings and select stocks that have the best (lowest) combined ranking score.

See Member Benefits »

Take a peek
at all the member benefits AAII has to offer.
AAII is a nonprofit association dedicated to investment education.

Portfolio Construction and Monitoring

  • Construct a 20- to 30-stock portfolio by selecting five to seven stocks every two to three months until fully invested.
  • Sell each stock after one year.

— In taxable accounts, pay attention to aftertax returns and time the sales. Sell stocks showing a loss a few days before the one-year holding period ends and sell stocks with a gain just after the one-year holding period ends.

— Repeat initial investment steps to reinvest the proceeds of securities sold.

*For more information about calculating the ratio of EBIT to enterprise value and return on capital, see Table 2.

Performance

Greenblatt tested his investing strategy over a 17-year period and earned an average annual return of 30.8%. He held 30 stocks at a time and held each stock for one year.

In the book, Greenblatt devotes an entire chapter to explaining that the strategy is not a “magic bullet” that always works. During his test period, he found that, on average, five of every 12 months underperformed the market. Looking at full-year periods, once every four years the approach failed to beat the market.

Sticking to a strategy that is not working in the short run even if it has a good long-term record can be difficult, Greenblatt says, but he believes you will be better off doing just that. Following the latest fad or short-term investment ideas will not yield market-beating results, in his opinion. Discipline is his key to successful investing.

Learn More »

Learning something new?
AAII is a nonprofit association dedicated to investment education. Take a peek at all the member benefits AAII has to offer.

Choosing Magic Formula Stocks

Magic Formula Web Site

Greenblatt runs a free Web site (www.magicformulainvesting.com) with a Magic Formula screening tool. After you register with the site, you can use the simple screener (Figure 1 shows the screener and the passing company list). The only choices you can make are minimum market capitalization (any number between $50 million and $5 billion) and the number of companies you wish to see (30 or 50).

The Web site does the rest for you. It orders the stocks based on the combined rank of EBIT-to-enterprise-value ratio and return on capital, and presents the top stocks. The prior day’s closing prices are used.

Interpreting the Screen Using a Stock Screening Program

Using a stock screening program to implement the Magic Formula requires some interpretation. The First Cut column in the May 2009 issue of the AAII Journal introduced the Magic Formula investing strategy. Greenblatt’s criteria were interpreted and updated to work within the parameters of AAII’s fundamental stock screening program, Stock Investor Pro. Table 2 presents a summary of the screen criteria. Table 3 lists the screen criteria for use in AAII’s Stock Investor Pro, and Table 4 lists the custom fields used in the screening process. [Stock Investor Pro subscribers: Click here to download a .txt file with the custom fields for copying and pasting into the Custom Field Editor.]

Table 2. Translating Criteria for Use in a Screening Program

Exchange-Listed

Greenblatt’s initial database included only exchange-listed stocks. We eliminated all stocks in the database that are not traded on a U.S. exchange.

See Member Benefits »

Take a peek
at all the member benefits AAII has to offer.
AAII is a nonprofit association dedicated to investment education.

Exclude ADRs and Foreign-Based Companies

ADRs, or American depositary receipts, are issued by a U.S. bank in place of the foreign shares of a company held in trust by that bank. Foreign stocks are excluded because Greenblatt’s universe included only U.S. companies.

Exclude Financials and Utilities

Due to their unique financial structures, all stocks in the financial and utility sectors are excluded.

Market Capitalization

Because small companies can be hard to invest in due to lack of liquidity, Greenblatt only considered stocks with a market capitalization greater than or equal to $50 million.

Return on Capital

Return on capital, or return on invested capital, is found by dividing earnings before interest and taxes EBIT by tangible capital. For this screen, we require a ROIC greater than 25%.

Earnings Before Interest and Taxes

EBIT (or pretax operating earnings) focuses on profitability from operations as it relates to the cost of the assets used to produce those profits. EBIT is found by adding interest expense to pretax income.

Learn More »

Learning something new?
AAII is a nonprofit association dedicated to investment education. Take a peek at all the member benefits AAII has to offer.

Tangible Capital

Compared to using equity or assets (in the case of ROE and ROA calculations), tangible capital captures actual operating capital used. Equity values ignore assets financed by debt. Total asset values include intangible assets that may not be tied to the firm’s primary operation. Tangible capital is accounts receivable + inventory + cash – accounts payable.

EBIT to Enterprise Value

The ratio of EBIT to enterprise value helps to measure the earnings potential of a stock versus its value. To calculate, Greenblatt divides EBIT by enterprise value. For this screen we chose the 30 stocks with the highest EBIT-to-enterprise-value ratios.

Enterprise Value

A company’s enterprise value represents its economic value, which is the minimum value that would be paid to purchase the company outright. Enterprise value is equal to the market value of equity (including preferred stock) plus interest-bearing debt minus excess cash. Enterprise value is used instead of market value of equity because it takes into account both the market price of equity and the debt used to generate earnings. Companies with debt must pay interest on the debt and eventually pay off the debt, therefore companies with more debt have lower ratios of EBIT to enterprise value. Excess cash is subtracted from enterprise value because holding un-needed cash reduces the overall cost of acquiring a business. This raises the ratio of EBIT to enterprise value.

 

Narrowing the Stock Universe

The first step is to remove all over-the-counter stocks (OTC) and ADRs (shares of foreign companies trading on U.S. exchanges). Greenblatt’s initial database of stocks included only exchange-traded stocks. Next, all stocks in the financial and utility sectors are excluded due to their unique financial structures.

See Member Benefits »

Take a peek
at all the member benefits AAII has to offer.
AAII is a nonprofit association dedicated to investment education.

Table 3. Magic Formula Screen Criteria for Use With AAII’s Stock Investor Pro

Data Category Field Operator Factor Compare To
Company Information Exchange  Not Equal   Over the Counter
Company Information ADR/ADS Stock Is False    
Company Information Sector Not Equal   Utilities
Company Information Sector Not Equal   Financial
Company Information Country Equals   United States
Price and Share Statistics Market Cap >=   50
  Magic Return on Capital* >   25
  Magic EBIT to Enterprise Value* >   value changes until exactly 30 companies pass
         

 

Market Capitalization

The screening tool found at MagicFormulaInvesting.com lets you choose a minimum value for market capitalization between $50 million and $5 billion; however, Greenblatt’s original study included stocks with market capitalizations of $50 million or greater.

Return on Invested Capital

Return on capital measures the return a company achieves after investing in the business; the higher the return on capital, the better the investment.

For the AAII First Cut screen, tangible capital was defined as accounts receivable plus inventory plus cash minus accounts payable. This figure is based on the fact that a company needs to fund its receivables and inventory but does not have a cash outlay for accounts payable.

For this screen, we require a return on invested capital of greater than 25%, as specified in Greenblatt’s alternative screening suggestions.

 

Learn More »

Learning something new?
AAII is a nonprofit association dedicated to investment education. Take a peek at all the member benefits AAII has to offer.

Table 4. Custom Fields for Use With AAII’s Stock Investor Pro

Custom Field Name Formula
Enterprise Value [Market Cap Q1] + [Long-term debt Q1] + [Preferred stock Q1] + [Short-term debt Q1] - [Cash Q1]
Magic EBIT [Pre-tax income 12m] + IIF(IsFieldNull ( [Interest expense 12m] ) =0,0, [Interest expense 12m] )
Magic EBIT to Enterprise Value (IIF( [Magic EBIT]>0, [Magic EBIT], null) / IIF( [Enterprise Value]>0, [Enterprise Value], null))*100
Magic Tangible Capital [Accounts receivable Q1] + [Inventory Q1] + [Cash Q1] - [Accounts payable Q1]
Magic Return on Capital (IIF( [Magic EBIT]>0, [Magic EBIT], null) / IIF( [Magic Tangible Capital]>0, [Magic Tangible Capital], null))*100
   

EBIT to Enterprise Value

The ratio of EBIT to enterprise value helps to measure the earnings potential of a stock versus its value. To calculate, Greenblatt divides EBIT by enterprise value. For this screen, we use the EBIT-to-enterprise-value ratio to narrow the field to 30 stocks by choosing those with the highest ratio.

“Magic” Stocks

Table 5 lists the 30 companies with the highest EBIT to enterprise value from the Stock Investor Pro database as of July 3, 2009. Trancept Pharmaceuticals TSPT has the highest ratio of EBIT to enterprise value at close to 95%. The company has an enterprise value of 29, mainly due to high levels of excess cash from a recent merger, but also due to minimal debt.

The company with the highest return on capital is Petroleum Development Corp. PETD. Its ROIC of 1,547% can be attributed to a high EBIT and low tangible capital levels.

Company (Exchange: Ticker) Market
Cap
($M)
EBIT to
Enterprise
Value
(%)
Return
on
Capital
(%)
Relative Strength  
 
13-Wk
(%)
52-Wk
(%)
 
Industry
Transcept Pharmaceuticals, Inc. (M: TSPT) 63 94.5 81.3 51 -45 Biotechnology & Drugs
Solutia Inc. (N: SOA) 565.8 77.6 285.3 143 -33 Chemical Manufacturing
Matrixx Initiatives, Inc. (M: MTXX) 61.1 62.8 49.2 -65 -43 Biotechnology & Drugs
CuraGen Corporation (M: CRGN) 81.2 59.6 65.3 47 122 Biotechnology & Drugs
Innophos Holdings, Inc. (M: IPHS) 359 53.6 92 24 -16 Chemical Manufacturing
i2 Technologies, Inc. (M: ITWO) 270.4 53.3 66.2 37 38 Software & Programming
VAALCO Energy, Inc. (N: EGY) 228.4 51.5 127.4 -31 -33 Oil & Gas Operations
Hawaiian Holdings, Inc. (M: HA) 294.6 45.5 51.9 24 15 Airline
EV Energy Partners, L.P. (M: EVEP) 245.5 43.4 746 17 -8 Oil & Gas Operations
K-V Pharmaceutical Company (N: KV.A) 158.3 42.5 49.1 111 -77 Biotechnology & Drugs
BreitBurn Energy Partners L.P. (M: BBEP) 386.8 41.9 1,361.90 -7 -52 Oil & Gas - Integrated
Northstar Realty Finance Corp. (N: NRF) 185.7 38.9 691.8 -17 -53 Real Estate Operations
Terra Industries Inc. (N: TRA) 2,592.20 37.8 60.8 -12 -19 Chemical Manufacturing
Fisher Communications, Inc. (M: FSCI) 103.3 36.7 79.6 5 -50 Broadcasting & Cable TV
China North East Petroleum Hld (A: NEP) 96.6 36.5 272.8 177 25 Oil & Gas Operations
PRG-Schultz International, Inc. (M: PRGX) 64.2 35.9 52.4 -16 -56 Business Services
Maxygen, Inc. (M: MAXY) 269.9 34.6 28 -7 123 Biotechnology & Drugs
Ceradyne, Inc. (M: CRDN) 445.4 32.8 33.2 -19 -29 Aerospace and Defense
Ensco International Inc. (N: ESV) 4,758.90 32.8 98.9 10 -38 Oil Well Services & Equipment
CF Industries Holdings, Inc. (N: CF) 3,595.80 32.7 74.1 -5 -27 Chemical Manufacturing
USA Mobility, Inc. (M: USMO) 284.4 32.2 82 25 136 Communications Services
United States Steel Corp. (N: X) 4,752.30 32 61.8 26 -69 Iron & Steel
Gentiva Health Services, Inc. (M: GTIV) 460.7 31.7 76.9 -6 20 Healthcare Facilities
Dawson Geophysical Company (M: DWSN) 215.8 31.5 60.8 68 -33 Oil Well Services & Equipment
Rowan Companies, Inc. (N: RDC) 2,026.30 31.5 67.4 26 -42 Oil Well Services & Equipment
Caraco Pharmaceutical Lab (A: CPD) 118 31.5 27.3 -21 -66 Biotechnology & Drugs
Sunoco, Inc. (N: SUN) 2,712.00 31.2 696.9 -23 -20 Oil & Gas Operations
Versant Corporation (M: VSNT) 54.8 30 29.2 -16 -19 Software & Programming
Petroleum Development Corp. (M: PETD) 217.2 29.4 1,547.10 0 -69 Oil & Gas - Integrated
BIDZ.com, Inc. (M: BIDZ) 67.6 29.2 53.9 -41 -56 Retail (Catalog & Mail Order)
             

 

Table 6 compares the median market cap, ratio of EBIT to enterprise value, return on capital and relative strength of the companies passing the Magic Formula screen to all exchange-listed stocks and the stocks in the S&P 500 index. As expected, the Magic Formula stocks have a much higher EBIT-to-enterprise-value ratio (36.2%, versus 8.9% for exchange-listed stocks and 8.4% for S&P 500 stocks). Magic Formula stocks also have a higher return on capital (70.8%, compared to 38.7% for exchange-listed and 51.0% for S&P 500 stocks).

See Member Benefits »

Take a peek
at all the member benefits AAII has to offer.
AAII is a nonprofit association dedicated to investment education.

Interestingly, the Magic Formula stocks have a lower relative strength than exchange-listed stocks for both the 13- and 52-week period. This could be for a number of reasons—one being that, as Greenblatt mentions in his book, the Magic Formula doesn’t always beat the market. Another reason could be that these stocks have been underperforming the market and are “on sale.” Perhaps this relative underperformance points to an attractive buying opportunity.

  Magic
Formula
Exchange-
Listed
Stocks
 
S&P 500 
Stocks
Market cap ($M) 257.7 283.9 6,770.90
EBIT-to-enterprise-value ratio (%) 36.2 8.9 8.4
Return on capital (%) 70.8 38.7 51
13-week rel strength vs S&P 500 (%) 2.5 7
52-week rel strength vs S&P 500 (%) -33 -1
       

 

Conclusion

Like any stock screening strategy, blindly buying and selling stocks is never a good idea. Developing and implementing disciplined buy, sell and hold strategies is a better option. Greenblatt’s Magic Formula is not revolutionary, but does provide a new twist on the old value investing ideas. While his past record is impressive, it will be interesting to see how the screen holds up during this period of market turmoil and its aftermath.

Click here for the latest passing companies and performance data for the Magic Formula screen.
Cara Scatizzi is a former associate financial analyst at AAII.


Discussion

I have bought and read Joel Greenblatt’s book, and occasionally visit his web site

www.magicformulainvesting.com

for ideas. His methodology has been very useful for investing my mother's trust which is managed for income and capital preservation.

posted 9 months ago by Joseph from Minnesota

For tangible capital, you should also include net PP&E. As it stands now, the formula for tangible capital only has working capital, which gives capital intensive businesses a free ride when determining ROIC. Another perspective on the formula would subtract goodwill/intangibles from total assets. As I recall, JG uses working capital plus net PP&E to calculate tangible capital.

posted 9 months ago by John from New Jersey

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

Log In