Fundamental analysisGuru functionsValuation Models

Thinking Of A Takeover…Well How About ‘The Acquirer’S Multiple’

Written by Luckjit Lalli
Sat Sep 16 2017
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

The Acquirer’s Multiple – BackgroundMany people have heard of the infamous Magic Formula documented by Joel Greenblatt in his book “The Little Book That Beats the Market” which is a direct quantitative value investment model in ranking stocks by price and ROIC. In a similar nature, The Acquirer’s Multiple founded by Tobias Carlisle is a valuation technique, combining both value + quality in order to find the top 30 most attractive takeover candidates, based on the investment strategy described in his superb book “Deep Value: Why Activist and Other Contrarians Battle for Control of Losing Corporations.”

This is a form of Deep Value investing, and it was the original investment style that Warren Buffett used while he was learning under his mentor Benjamin Graham. In a nutshell, deep value investors are concerned about protecting their downside, and look for undervalued stocks with a large margin of safety between value and price – “Corporate gold dollars are now available for 50 cents or less – but they do have strings attached.” – Benjamin Graham (1932).

The Makeup of The Acquirer’s Multiple

The premise of the methodology is to examine several financial statement pieces such as debt, preferred stock, minority interests, interest, depreciation, and amortization. The actual formulation is:Enterprise Value / Operating Earnings (TTM)

You can use MarketXLS formulas like shown below to calculate The Acquirer’s Multiple.The Acquirer's Multiple

Using the same formulas, we calculated the Acquirer’s multiple for all of the S&P 500 stocks. Below are the top 10 companies with lowest figures.

For the Q2 2018, below is the full list of S&P stocks with their respective Acquirer’s Multiple Values. Negative values are ignored. Many other symbols were ignored for which the data could not be obtained. The following table is just an indicator of the concept and MUST NOT be relied on for any decision making.

This link

The Enterprise Value is the total cost to buy out a company and it is calculated as:Market Cap + Preferred Equity + Non-controlling Interests + Total Debt – Cash and Cash Equivalents

The reason why we use this rather than just the Market Cap (Share price x Total Shares Outstanding) is that it includes additional liabilities such as debt, preferred equity and non-controlling interests which the owner will need to adjust for.

It uses Operating Earnings rather than EBIT, whilst similar have a distinction in that Operating Earnings is calculated from the top down whilst EBIT is constructed from the bottom up. This process allows us to use a variable that is standard and can be compared on a like for like basis across different companies, industries, and sectors.

Operating Earnings is calculated as:Revenue – (Costs of Goods sold + Selling, General and Admin costs + Depreciation and Amortization)

Interest repayments reduce earnings and are tax-deductible, so a company’s debt impacts it’s reported earnings and therefore removing this and tax allows us to compare companies with different capital structures.

Final Words

To sum up, this is a great process for identifying shares that have an optimal blend of value and quality in your chosen market that is not only simple but as effective as Joel Greenblatt’s Magic Formula. I would love to find out your thoughts and personal experiences on The Acquirer’s Multiple below…

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

92.84
 
USD
 
2.48
 
(2.74%)
84
Rank
Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
69.32   
   93.45
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

51.55
 
USD
 
1.94
 
(3.91%)
81
Rank
Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
BWX Technologies Inc. logo

BWX Technologies Inc.

56.44
 
USD
 
1.35
 
(2.45%)
80
Rank
Optionable: Yes
Market Cap: 4,846 M
Industry: Aerospace & Defense
52 week range    
42.22   
   61.75
Ritchie Bros. Auctioneers Incorporated logo

Ritchie Bros. Auctioneers Incorporated

67.49
 
USD
 
2.43
 
(3.74%)
77
Rank
Optionable: Yes
Market Cap: 6,928 M
Industry: Business Services
52 week range    
48.44   
   75.28
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

24.33
 
USD
 
-0.16
 
(-0.65%)
77
Rank
Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
19.49   
   29.33
General Mills Inc. logo

General Mills Inc.

75.79
 
USD
 
0.34
 
(0.45%)
76
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   75.96
CRA InternationalInc. logo

CRA InternationalInc.

89.15
 
USD
 
-0.17
 
(-0.19%)
76
Rank
Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
78.05   
   115.47
ConAgra Brands Inc. logo

ConAgra Brands Inc.

34.56
 
USD
 
0.32
 
(0.93%)
76
Rank
Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
29.80   
   36.67
Agree Realty Corporation logo

Agree Realty Corporation

73.53
 
USD
 
1.40
 
(1.94%)
76
Rank
Optionable: Yes
Market Cap: 5,522 M
Industry: REIT - Retail
52 week range    
60.78   
   74.67
International Money Express Inc. logo

International Money Express Inc.

21.77
 
USD
 
1.30
 
(6.35%)
75
Rank
Optionable: Yes
Market Cap: 781 M
Industry: Business Services
52 week range    
14.66   
   22.86

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!