Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

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

Written by Luckjit Lalli on 
Sat Sep 16 2017
 about Fundamental analysisGuru functionsValuation Models
Thinking Of A Takeover…Well How About ‘The Acquirer’S Multiple’ - MarketXLS
Boost your market advantage with MarketXLS. Real-time, enterprise-grade data. Book a demo or subscribe now!
Thinking Of A Takeover…Well How About ‘The Acquirer’S Multiple’ - MarketXLS

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
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord