Difference between revisions of "Information Asymmetry Measures"

From edegan.com
Jump to navigation Jump to search
imported>Ed
imported>Ed
 
(29 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
This page is referenced in:  
 
This page is referenced in:  
*VC Acquisitions Paper  
+
*[[VC Acquisitions Paper]]
  
 
This page provides a summary details from the [[Information Asymmetry in Acquisitions Lit Review]] and the begining of the build notes for these variables.
 
This page provides a summary details from the [[Information Asymmetry in Acquisitions Lit Review]] and the begining of the build notes for these variables.
+
 
 +
==New Measures==
 +
 
 +
The prior usage of these measures (except for distance and patents) is in the table in the next section ([[#Table of Measure Usage|Table of Measure Usage]]). The build notes for each of these measures are included in the [[#Build Notes|Build Notes]] section below.
 +
 
 +
 
 +
'''Deal-level IA Measures:'''
 +
*iagoogledist - The distance between the target and acquirer HQ as calculated by Google Maps
 +
*iagoogledur - The driving time between the target and acquirer HQ as calculated by Google Maps
 +
*iagoogledur20m - Binary variable: Whether the target is within 20mins drive of the acquirer (the 20minute rule)
 +
*iagoogledur60m - Binary variable: Whether the target is within 1hr drive of the acquirer
 +
*iagoogledur120m - Binary variable: Whether the target is within 2hr drive of the acquirer
 +
*samestate - Whether the target and the acquirer are headquartered in the same state
 +
 
 +
 
 +
'''Target-level IA Measures:'''
 +
*patents - Binary Variable: Whether the target has patents
 +
*patentcount - The count of patents held by the target
 +
 
 +
 
 +
'''Industry-Year IA Measures (Industry defined at 3dg NAIC, year is transaction year):'''
 +
*From Compustat (Accounting Measures):
 +
**iacstatmktba - The Market-to-Book Value of Assets ratio
 +
**iacstatmktbe - The Market-to-Book Value of Assets ratio
 +
**iacstatepratio - Earnings-to-Price Ratio
 +
**iacstattotalassets - Total Assets
 +
**iacstatmkval - Matket value (Shares Outstanding x Price)
 +
**iacstatdevstage - Binary variable for Development Stage: Sales < 0.5b
 +
**iacstatrandd - R&D expenditure
 +
**iacstattotalrandd - Total R&D expenditure (includes R&D in process)
 +
**iacstatranddsaleratio - Ration of R&D to Sales
 +
**iacstatintan - Intangible assets on balance sheet
 +
**iacstatintanratio - Ratio of intangible to tangible assets
 +
*From CRSP (Stock Market Measures):
 +
**iacrspvolratio - Ratio of shares traded to shares outstanding
 +
**iacrsprmse - Idiosyncratic volatility (Root mean squared error) of stock returns (see below)
 +
*FROM IBES (Analyst measures):
 +
**iaibesrange - Range of forecasts
 +
**iaibesnumest - Number of estimates made by analysts
 +
**iaibesforecasterror - Forecast error (see below)
 +
**iaibesforecastsd - Std. Deviation of forecase error (see below)
 +
 
 +
 
 +
The following variables are also provided in '''log form''' (note the 'l' on the end):
 +
*iagoogledistl
 +
*iagoogledurl
 +
*iacstattotalassetsl
 +
**iacstatmkvall
 +
**iacstatranddl
 +
*iacstattotalranddl
 +
*iacstatintanl
 +
*patentcountl
 +
 
 
==Table of Measure Usage==
 
==Table of Measure Usage==
  
 
In a review of 28 papers that used one or more information asymmetry measures to explain stock price events (acquisitions, earning announcements, diversitures, etc.), the following measures were found:
 
In a review of 28 papers that used one or more information asymmetry measures to explain stock price events (acquisitions, earning announcements, diversitures, etc.), the following measures were found:
  
{| class="wikitable sortable" border="0.5" cellpadding=0 cellspacing=0 bgcolor="grey"  
+
{| class="wikitable sortable" style="border: 1px solid darkgray; bgcolor: #f9f9f9"
 
|-
 
|-
 
|  || D91 || CS01 || Mea07 || KS99 || FL04 || O07 || L92 || T02 || Aea02 || AB94 || LT07 || T10 || UC97 || Oea09 || M96 || ES99 || AL00 || Y03 || CS07 || Cea04 || Others* || Count
 
|  || D91 || CS01 || Mea07 || KS99 || FL04 || O07 || L92 || T02 || Aea02 || AB94 || LT07 || T10 || UC97 || Oea09 || M96 || ES99 || AL00 || Y03 || CS07 || Cea04 || Others* || Count
 
|-
 
|-
| '''Price/Volume Metrics || y ||  || y || y || y ||  ||  || y ||  ||  ||  || y || y ||  || y ||  ||  ||  ||  ||  ||  || 8'''
+
| '''Price/Volume Metrics''' || y ||  || y || y || y ||  ||  || y ||  ||  ||  || y || y ||  || y ||  ||  ||  ||  ||  ||  || 8
 
|-
 
|-
| Idiosyncratic Volatility || Y ||  || y || y ||  ||  ||  || y ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 5
+
| Idiosyncratic Volatility || y ||  || y || y ||  ||  ||  || y ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 5
 
|-
 
|-
 
| R-Squared from Earnings, Book Val. On Price ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || 1
 
| R-Squared from Earnings, Book Val. On Price ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || 1
Line 30: Line 82:
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|-
 
|-
| Analyst Forecasts ||  || y ||  || y || y || y || y || y || y || y || y || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 10
+
| '''Analyst Forecasts''' ||  || y ||  || y || y || y || y || y || y || y || y || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 10
 
|-
 
|-
 
| Forecast Error ||  || y ||  || y ||  ||  ||  || y || y ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || 4
 
| Forecast Error ||  || y ||  || y ||  ||  ||  || y || y ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || 4
Line 46: Line 98:
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|-
 
|-
| News || y ||  ||  ||  || y ||  ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 3
+
| '''News''' || y ||  ||  ||  || y ||  ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 3
 
|-
 
|-
 
| News Announcements || Y ||  ||  ||  || y ||  ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 3
 
| News Announcements || Y ||  ||  ||  || y ||  ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || 3
Line 52: Line 104:
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|-
 
|-
| Capital Structure ||  ||  || y ||  ||  ||  || y ||  ||  ||  ||  || y || y ||  ||  || y || y ||  ||  ||  ||  || 6
+
| '''Capital Structure''' ||  ||  || y ||  ||  ||  || y ||  ||  ||  ||  || y || y ||  ||  || y || y ||  ||  ||  ||  || 6
 
|-
 
|-
 
| Breadth of Ownership/Block Holdings ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  ||  ||  || 2
 
| Breadth of Ownership/Block Holdings ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  ||  ||  || 2
Line 64: Line 116:
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|-
 
|-
| Accounting-based Measures ||  || y || y ||  ||  ||  || y || y ||  ||  ||  || y ||  || y || y || y ||  ||  || y || y ||  || 10
+
| '''Accounting-based Measures''' ||  || y || y ||  ||  ||  || y || y ||  ||  ||  || y ||  || y || y || y ||  ||  || y || y ||  || 10
 
|-
 
|-
 
| Market-to-Book-Assets (or Q) ||  || y || y ||  ||  ||  || y ||  ||  ||  ||  || y ||  ||  || y || y ||  ||  ||  || y ||  || 7
 
| Market-to-Book-Assets (or Q) ||  || y || y ||  ||  ||  || y ||  ||  ||  ||  || y ||  ||  || y || y ||  ||  ||  || y ||  || 7
Line 88: Line 140:
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|-
 
|-
| External Responses ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  ||  || 1
+
| '''External Responses''' ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  ||  || 1
 
|-
 
|-
 
| Ratings Change ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  ||  || 1
 
| Ratings Change ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  ||  || 1
Line 94: Line 146:
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|-
 
|-
| Transaction Characteristics ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || y || y || y || y || y || +8 || 14
+
| '''Transaction Characteristics''' ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || y || y || y || y || y || +8 || 14
 
|-
 
|-
 
| Method of Payment ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || y || y || y ||  || y || +7 || 12
 
| Method of Payment ||  ||  ||  ||  ||  || y ||  ||  ||  ||  ||  ||  ||  ||  ||  || y || y || y ||  || y || +7 || 12
Line 106: Line 158:
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  
 
|-
 
|-
| Target Characteristics ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  || 1
+
| '''Target Characteristics''' ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  || 1
 
|-
 
|-
 
| Target Age ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  || 1
 
| Target Age ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  ||  || y ||  ||  || 1
Line 115: Line 167:
 
===Paper Codes===
 
===Paper Codes===
  
The paper codes are as follows:
+
The paper codes are as follows (where 'ea' denotes et al.):
  
 
  '''Code  Paper'''
 
  '''Code  Paper'''
  AL00   Aboody and Lev 2000
+
  AL00   Aboody and Lev 2000
 
  Aea02  Affleck-Graves et al. 2002
 
  Aea02  Affleck-Graves et al. 2002
 
  Aea90  Amihud et al 1990
 
  Aea90  Amihud et al 1990
  AB94   Atiase and Bamber 1994
+
  AB94   Atiase and Bamber 1994
  BC11   Basu and Chevrier 2011
+
  BC11   Basu and Chevrier 2011
  BR91   Brown and Ryngaert 1991
+
  BR91   Brown and Ryngaert 1991
  CL87   Calvet and Lefoll 1987
+
  CL87   Calvet and Lefoll 1987
  CS07   Capron and Shen 2007
+
  CS07   Capron and Shen 2007
 
  Cea04  Carrow et al. 2004
 
  Cea04  Carrow et al. 2004
  C98   Chang 1998
+
  C98     Chang 1998
  CS01   Clarke and Shastri 2001
+
  CS01   Clarke and Shastri 2001
  D91   Dierkens 1991
+
  D91     Dierkens 1991
  ET00   Eckbo and Thorburn 2000
+
  ET00   Eckbo and Thorburn 2000
 
  Eea90  Eckbo et al 1990
 
  Eea90  Eckbo et al 1990
  ES99   Emery and Switzer 1999
+
  ES99   Emery and Switzer 1999
  FL04   Frankel and Li (2004)
+
  FL04   Frankel and Li 2004
 
  Fea02  Fuller et al. 2002
 
  Fea02  Fuller et al. 2002
  KS99   Krishnaswami and Subramaniam 1999
+
  KS99   Krishnaswami and Subramaniam 1999
  L92   Lee (1992)
+
  L92     Lee 1992
  LT07   Lobo and Tung 1997
+
  LT07   Lobo and Tung 1997
  M96   Martin 1996
+
  M96     Martin 1996
 
  Mea07  Moeller et al. 2007
 
  Mea07  Moeller et al. 2007
  O07   Officer (2007)
+
  O07     Officer 2007
 
  Oea09  Officer et al. 2009
 
  Oea09  Officer et al. 2009
  T10   Tetlock 2010
+
  T10     Tetlock 2010
  T02   Thomas (2002)
+
  T02     Thomas 2002
  UC97   Utama and Cready 1997
+
  UC97   Utama and Cready 1997
  Y03   Yook 2003
+
  Y03     Yook 2003
 +
 
 +
==Summary Of Usage==
 +
 
 +
There are 28 papers and 33 distinct variables broken into 8 distinct categories: Price/Vol, Analyst, News, CapX, Accounting, External, Transaction, and Target. '''Market Microstructure''' papers and measures are excluded from the summary and tabulation but included in [[Information Asymmetry in Acquisitions Lit Review]] with comments.
 +
 
 +
The average paper uses 2.8 variables from 1.7 categories. The most variables and categories covered by a single paper are 9 and 4 respectively, for Tetlock 2010.
 +
 
 +
Method of payment measures (cash vs. stock) are most popular, and present in half of all papers covered. Other transaction characteristics are rarely used. Acccounting-based measures, particularly Tobin's Q, and Analyst Forecast measures, particularly the Std. Dev. of Forecasts, are the next most popular and occur in approximately 1/3rd of all papers covered. Price/Volume measures, particularly the idiosyncratic volatility, are the next most popular, occuring in approximately 1/5th of all papers covered.
 +
 
 +
==Rejecting Variables==
 +
 
 +
The following variables are explicitly or implicitly related to the CAR in an acquisition and so unsuitable:
 +
*Pre-CAR
 +
*Abnormal/Unexpected Turnover
 +
*Momentum - It is unclear from a quick read of Tetlock (the only paper that uses this measure) whether momentum is an artifact of information asymmetry or a response to it's mitigation.
 +
*Stock Illiquidity - see Momentum above.
 +
 
 +
The following are simply too hard to get on a reasonable timescale:
 +
*News Announcements
 +
*Ratings Changes
 +
*Target Age (not in SDC, so we would have to get another source...)
 +
*R-Squared from Earnings, Book Value - this was used in a single paper and isn't worth it (it requires joining CRSP to COMPUSTAT before running the regressions)
 +
 
 +
===Rejecting for now...===
 +
 
 +
All of the capital structure measures:
 +
*Sources include 'Thompson 13' (Tetlock 2010), 'Value Line Investment Survey' (Emery and Switzer 1999), 'Compact Disclosure' data base of 13f filings (Utama and Cready 1997), 'CDA/Investnet' (Aboody and Lev 2000), etc.
 +
*It appears that Thomson 13, which was formerly CDA/Spectrum is now available through WRDS.
 +
*Likewise, also under Thompson Reuters is the S12 data which details mutual fund holdings.
 +
*There is also BlockHolders data in WRDS that covers 1,913 firms for the period 1996-2001. This is clean data from the paper by Gompers et al.
 +
 
 +
===Microstructure Measures===
 +
 
 +
We are '''not''' using Microstructure measures and don't plan to. But NYSE TAQ is available through WRDS to some subscribers (not me).
 +
 
 +
==Build Notes==
 +
 
 +
===Idiosyncratic Variability===
 +
 
 +
We want <math>\sigma_{\epsilon}^2</math> from <math>R_it = \alpha + \beta_i R_mt + \epsilon</math> run annually for each publicly-traded firm in the NYSE/Nasdaq/Amex universe.
 +
 
 +
This is equivalent to the RMSE as:
 +
 
 +
<math>\mathbb{E}(\epsilon) = 0 \quad \mathbb{V}(\epsilon)= \mathbb{E} \left( (R-\hat{R}) - (\alpha-\hat{\alpha}) - (\beta - \hat{\beta})R_m \right)^2 = RMSE^2</math>
 +
 
 +
Data:
 +
*Annual data from CRSP
 +
*Draw entire universe (>2Gb?)
 +
*Rely on date stamps
 +
*Use CRSP Permo (or Cusip?) - Don't need to draw NAICS if we are going to join back...
 +
*Holding Period Return
 +
*Value-Weighted Return inc. distributions
 +
 
 +
Run the regressions on raw data (i.e., don't join to COMPUSTAT first).
 +
 
 +
Specs:
 +
*Date Range: 1/1/78 -> 12/31/11
 +
*Company Codes: PERMNO
 +
*SEARCH ENTIRE DATABASE
 +
*ID Info: CUSIP, NAICS
 +
*Time Series: VOL (Share Volume, -99 is missing), RET (Holding Period Return, error codes -66.0 -77.0, -88.0, -99.0)
 +
*Share info: SHROUT (No. Shares Outstanding in K)
 +
*Mkt Info: VWRETD (Value-Weighted Return inc. Dists)
 +
*Output: tab-delimited txt
 +
*Date Format: YYMMDDn8 (corresponds to ISO 8601 and is Postgres compatible)
 +
 
 +
RET errors:
 +
*E -44.0 No valid comparison for an excess return
 +
*D -55.0 No listing information
 +
*C -66.0 more than 10 periods between time t and the time of the preceding price t?
 +
*B -77.0 not trading on the current exchange at time t
 +
*A -88.0 no return, array index t not within range of BEGRET and ENDRET
 +
*'' -99.0 missing return due to missing price at time t
 +
 
 +
Get file:
 +
*e5da94cf0a760426.txt (3195.8 MB, 60127561 observations 8 variables)
 +
 
 +
Plan: Pull into Postgres, Index, Cut into chunks (yearly? Want < 250mb?), Run regressions in STATA using a batch script with dispatch to Bear.
 +
 
 +
===Ratio of Shares Traded===
 +
 
 +
Defined as: "the ratio of number of shares traded during the last year ending before the equity issue announcement, divided by the number of shares outstanding at the end of the fiscal year before the ... announcement."
 +
 
 +
We can compute it on an average over an annual basis using CRSP quarterly ("Shares Traded" isn't in COMPUSTAT), or using CRSP daily (same data as above), either way we want:
 +
 
 +
Data:
 +
*Share Volume (VOL)
 +
*No. of Shares Outstanding (SHROUT in K)
 +
*And to take an average over the year for each firm.
 +
 
 +
===Analyst Forecasts===
 +
 
 +
At least one paper reported problems with the data before 1991 (see the lit review).
 +
 
 +
*Forecast Error (Analysts over and under react): <math>ForecastError=\frac{|ACT_t-EST_t|}{|Act_t|}</math>
 +
*Std. Deviation of forecasts (Correlated with riskiness): <math> ForecastSD=\frac{SD_t}{|Act_t|}</math>
 +
*Range of Forcasts
 +
*No. Estimates
 +
*No. Analysts
 +
*Normalized forecast error:  <math>NormForecastError=\frac{ForecastError}{\sigma_{ACT_t - ACT_0}}</math>
 +
 
 +
I.e., Over some time period calculate the detrended variation in Earnings. This probably isn't worth it.
 +
From KS99: "the normalized forecast error, which is defined as the ratio of the forecast error in earnings to the earnings volatility of the firm. Earnings volatility is the standard deviation of the firm's detrended quarterly earnings in the five-year period before the announcement of the spin-off."
 +
 
 +
Data drawn from I/B/E/S Summary file:
 +
*Jan1978-Jan2012
 +
*CUSIP (8Dg)
 +
*Entire DB (US and International - both)
 +
*EPS
 +
*Fiscal Yr1
 +
*ID: CUSIP, Company Name, OFTIC, TICKER
 +
*Other: Forecast Period End Date, Number of Estimates, Mean Estimate, Median Estimate, Standard Deviation, High Est., Low Est., Actual Value, US Firm
 +
*Sort: Cusip, Forecast period End
 +
*Output: Tab delimited, None, YYMMDDn8
 +
 
 +
Get file:
 +
*b5191ac65df7b6c4.txt (197.3 MB, 2569173 observations 15 variables
 +
 
 +
Match back to COMPUSTAT to get NAICS. See: http://wrds-web.wharton.upenn.edu/wrds/support/Data/_010Linking%20Databases/_000Linking%20IBES%20and%20CRSP%20Data.cfm
 +
 
 +
===Accounting Variables===
 +
 
 +
Data source: COMPUSTAT - North America Fundamentals Annual
 +
 
 +
Ref vars:
 +
*Company Name
 +
*CUSIP
 +
*NAICS
 +
 
 +
Variables:
 +
*Market-to-Book-Assets (or Q): MKVALT (Sup: Market Value Total) / AT (Bal: Assets Total)
 +
*Market-to-Book-Equity: CEQ MKVALT (Sup: Market Value Total) / (Bal: Common/Ordinary Equity Total), TEQ  (Bal: Shareholder's Equity Total)
 +
*Earnings to Price Ratio: RE (Inc: Retained Earnings), EBIT (Inc: Earnings before Income Taxes), EPSPI (Inc: Earnings Per Share (Basic) Including Extraordinary Items), PRCC_F (Sup: Price Close - Annual - Fiscal)
 +
*Firm Size: AT, MKVALT (as above)
 +
*Development Stage (Sales<0.5b): SALE (Inc: Sales/Turnover (Net))
 +
*R&D Expenditure (XRD: Inc: Research and Development Expense), RDIP (Inc: In Process R&D Expense)
 +
*Ratio of R&D to Sales: XRD/SALE (as above)
 +
*Intangible Assets: INTAN (Intangible Assets - Total)
 +
*Ratio of Intangible Assets INTAN/AT
 +
*Sales Growth: <math>\frac{SALE_t - SALE_{t-1}}{SALE_{t-1}}</math>
 +
*Common shares: CSHPRI - Common Shares Used to Calculate Earnings Per Share Basic
 +
 
 +
Draw Notes:
 +
*Jan 1978 to Jul 2012
 +
*GVKey (note: No Permno anymore?)
 +
*No output on screening, otherwise all defaults
 +
*ID: Company Name, Ticker Symbol, CUSIP, Stock Exchange Code, Fiscal Year-End
 +
*ID Cont: NAICS
 +
*Desc: FYear
 +
*Bal: AT, CEQ, INTAN, RE
 +
*Inc: EBIT, EBITDA, EPSPI, RDIP, SALE, XRD
 +
*Misc: CSHPRI, TEQ
 +
*Sup: PRCC_F, MKVAL
 +
*tab delimited, no compression, YYMMDDn8
 +
 
 +
Get file:
 +
*0d1f67dfbaded51a.txt (50.0 MB, 347184 observations 24 variables)
 +
 
 +
===Target Characteristics===
 +
 
 +
We already have:
 +
*Method of Payment
 +
*Diversification/Related (i.e., Horiz, vert, cong)
 +
*Acquirer Experience
 +
*Patent Counts
 +
 
 +
We need:
 +
*Distance btw Acquirer and Target
 +
*Citations Recd to patents
 +
 
 +
====Distance btw Acquirer and Target====
 +
 
 +
Addresses for both the Acquirer and the Target are available from SDC in the vast majority of cases.
 +
We will build a quick XML API to access: https://developers.google.com/maps/documentation/distancematrix/
 +
 
 +
We can pass 2,500 'elements' per IP address per day (24hrs) to this service, with a max of 100 elements per query and a max of 100 elements per 10 seconds. Note that URLs are restricted to 2048 characters, before URL encoding (particularly relevant if using multiple elements) and an element is an origin-destination pair. Returned data includes:
 +
*Road Distances (in meters/ft(?) in the value field, and km/miles in text)
 +
*Driving Times (in seconds in the value field, and hours in text)
 +
 
 +
Geocoding is internal. We can explicitly use Google's geocoding to get longitude/latitude if we want to calculate Great Circle Distances (etc): https://developers.google.com/maps/documentation/geocoding/#XML
 +
 
 +
Example query:
 +
http://maps.googleapis.com/maps/api/distancematrix/xml?origins=Bobcaygeon+ON|41.43206,-81.38992&destinations=Darling+Harbour+NSW+Australia&mode=driving&units=metric&sensor=false
 +
 
 +
The sensible thing is probably to fire one element per query - as there is no gain to doing multiple elements.
 +
 
 +
Useful code references include:
 +
*[http://search.cpan.org/~gaas/libwww-perl-6.04/lib/LWP.pm#The_User_Agent LWP]
 +
*[http://search.cpan.org/~makamaka/JSON-2.53/lib/JSON.pm#decode_json JSON]

Latest revision as of 18:55, 25 July 2013

This page is referenced in:

This page provides a summary details from the Information Asymmetry in Acquisitions Lit Review and the begining of the build notes for these variables.

New Measures

The prior usage of these measures (except for distance and patents) is in the table in the next section (Table of Measure Usage). The build notes for each of these measures are included in the Build Notes section below.


Deal-level IA Measures:

  • iagoogledist - The distance between the target and acquirer HQ as calculated by Google Maps
  • iagoogledur - The driving time between the target and acquirer HQ as calculated by Google Maps
  • iagoogledur20m - Binary variable: Whether the target is within 20mins drive of the acquirer (the 20minute rule)
  • iagoogledur60m - Binary variable: Whether the target is within 1hr drive of the acquirer
  • iagoogledur120m - Binary variable: Whether the target is within 2hr drive of the acquirer
  • samestate - Whether the target and the acquirer are headquartered in the same state


Target-level IA Measures:

  • patents - Binary Variable: Whether the target has patents
  • patentcount - The count of patents held by the target


Industry-Year IA Measures (Industry defined at 3dg NAIC, year is transaction year):

  • From Compustat (Accounting Measures):
    • iacstatmktba - The Market-to-Book Value of Assets ratio
    • iacstatmktbe - The Market-to-Book Value of Assets ratio
    • iacstatepratio - Earnings-to-Price Ratio
    • iacstattotalassets - Total Assets
    • iacstatmkval - Matket value (Shares Outstanding x Price)
    • iacstatdevstage - Binary variable for Development Stage: Sales < 0.5b
    • iacstatrandd - R&D expenditure
    • iacstattotalrandd - Total R&D expenditure (includes R&D in process)
    • iacstatranddsaleratio - Ration of R&D to Sales
    • iacstatintan - Intangible assets on balance sheet
    • iacstatintanratio - Ratio of intangible to tangible assets
  • From CRSP (Stock Market Measures):
    • iacrspvolratio - Ratio of shares traded to shares outstanding
    • iacrsprmse - Idiosyncratic volatility (Root mean squared error) of stock returns (see below)
  • FROM IBES (Analyst measures):
    • iaibesrange - Range of forecasts
    • iaibesnumest - Number of estimates made by analysts
    • iaibesforecasterror - Forecast error (see below)
    • iaibesforecastsd - Std. Deviation of forecase error (see below)


The following variables are also provided in log form (note the 'l' on the end):

  • iagoogledistl
  • iagoogledurl
  • iacstattotalassetsl
    • iacstatmkvall
    • iacstatranddl
  • iacstattotalranddl
  • iacstatintanl
  • patentcountl

Table of Measure Usage

In a review of 28 papers that used one or more information asymmetry measures to explain stock price events (acquisitions, earning announcements, diversitures, etc.), the following measures were found:

D91 CS01 Mea07 KS99 FL04 O07 L92 T02 Aea02 AB94 LT07 T10 UC97 Oea09 M96 ES99 AL00 Y03 CS07 Cea04 Others* Count
Price/Volume Metrics y y y y y y y y 8
Idiosyncratic Volatility y y y y y 5
R-Squared from Earnings, Book Val. On Price y 1
Momentum y 1
Stock Illiquidity y 1
Pre-CAR y 1
Ratio of shares traded to outstanding y y 2
Abnormal/Unexpected Turnover y y 2
Analyst Forecasts y y y y y y y y y y 10
Forecast Error y y y y 4
Std. Dev. Of Forecasts y y y y y y y y 8
Normalized Forecast Error y y 2
Range of Forecasts y y 2
No. Estimates y 1
No. Analysts y y y 3
News y y y 3
News Announcements Y y y 3
Capital Structure y y y y y y 6
Breadth of Ownership/Block Holdings y y 2
Institutional Ownership/Holdings y y 2
Managerial Holdings y 1
No. Wholy Owned Subs. y 1
Accounting-based Measures y y y y y y y y y y 10
Market-to-Book-Assets (or Q) y y y y y y y 7
Market-to-Book-Equity y 1
Earnings to Price Ratio y 1
Firm Size y y 2
Development Stage (Sales<0.5b) y 1
R&D Expenditure y y 2
Ratio of R&D to Sales y 1
Intangible Assets y 1
Ratio of Intangible Assets y 1
Sales Growth y 1
External Responses y 1
Ratings Change y 1
Transaction Characteristics y y y y y y +8 14
Method of Payment y y y y y +7 12
Diversification/Related y y 2
Acquirer Experience y y 2
Distance between A&T +1 1
Target Characteristics y 1
Target Age y 1

Note that C98, Eea90, Aea90, BR91, Fea02, ET00, and CL87 (not listed above) all used payment method only, and BC11 used a distance measure.

Paper Codes

The paper codes are as follows (where 'ea' denotes et al.):

Code   Paper
AL00    Aboody and Lev 2000
Aea02   Affleck-Graves et al. 2002
Aea90   Amihud et al 1990
AB94    Atiase and Bamber 1994
BC11    Basu and Chevrier 2011
BR91    Brown and Ryngaert 1991
CL87    Calvet and Lefoll 1987
CS07    Capron and Shen 2007
Cea04   Carrow et al. 2004
C98     Chang 1998
CS01    Clarke and Shastri 2001
D91     Dierkens 1991
ET00    Eckbo and Thorburn 2000
Eea90   Eckbo et al 1990
ES99    Emery and Switzer 1999
FL04    Frankel and Li 2004
Fea02   Fuller et al. 2002
KS99    Krishnaswami and Subramaniam 1999
L92     Lee 1992
LT07    Lobo and Tung 1997
M96     Martin 1996
Mea07   Moeller et al. 2007
O07     Officer 2007
Oea09   Officer et al. 2009
T10     Tetlock 2010
T02     Thomas 2002
UC97    Utama and Cready 1997
Y03     Yook 2003

Summary Of Usage

There are 28 papers and 33 distinct variables broken into 8 distinct categories: Price/Vol, Analyst, News, CapX, Accounting, External, Transaction, and Target. Market Microstructure papers and measures are excluded from the summary and tabulation but included in Information Asymmetry in Acquisitions Lit Review with comments.

The average paper uses 2.8 variables from 1.7 categories. The most variables and categories covered by a single paper are 9 and 4 respectively, for Tetlock 2010.

Method of payment measures (cash vs. stock) are most popular, and present in half of all papers covered. Other transaction characteristics are rarely used. Acccounting-based measures, particularly Tobin's Q, and Analyst Forecast measures, particularly the Std. Dev. of Forecasts, are the next most popular and occur in approximately 1/3rd of all papers covered. Price/Volume measures, particularly the idiosyncratic volatility, are the next most popular, occuring in approximately 1/5th of all papers covered.

Rejecting Variables

The following variables are explicitly or implicitly related to the CAR in an acquisition and so unsuitable:

  • Pre-CAR
  • Abnormal/Unexpected Turnover
  • Momentum - It is unclear from a quick read of Tetlock (the only paper that uses this measure) whether momentum is an artifact of information asymmetry or a response to it's mitigation.
  • Stock Illiquidity - see Momentum above.

The following are simply too hard to get on a reasonable timescale:

  • News Announcements
  • Ratings Changes
  • Target Age (not in SDC, so we would have to get another source...)
  • R-Squared from Earnings, Book Value - this was used in a single paper and isn't worth it (it requires joining CRSP to COMPUSTAT before running the regressions)

Rejecting for now...

All of the capital structure measures:

  • Sources include 'Thompson 13' (Tetlock 2010), 'Value Line Investment Survey' (Emery and Switzer 1999), 'Compact Disclosure' data base of 13f filings (Utama and Cready 1997), 'CDA/Investnet' (Aboody and Lev 2000), etc.
  • It appears that Thomson 13, which was formerly CDA/Spectrum is now available through WRDS.
  • Likewise, also under Thompson Reuters is the S12 data which details mutual fund holdings.
  • There is also BlockHolders data in WRDS that covers 1,913 firms for the period 1996-2001. This is clean data from the paper by Gompers et al.

Microstructure Measures

We are not using Microstructure measures and don't plan to. But NYSE TAQ is available through WRDS to some subscribers (not me).

Build Notes

Idiosyncratic Variability

We want [math]\sigma_{\epsilon}^2[/math] from [math]R_it = \alpha + \beta_i R_mt + \epsilon[/math] run annually for each publicly-traded firm in the NYSE/Nasdaq/Amex universe.

This is equivalent to the RMSE as:

[math]\mathbb{E}(\epsilon) = 0 \quad \mathbb{V}(\epsilon)= \mathbb{E} \left( (R-\hat{R}) - (\alpha-\hat{\alpha}) - (\beta - \hat{\beta})R_m \right)^2 = RMSE^2[/math]

Data:

  • Annual data from CRSP
  • Draw entire universe (>2Gb?)
  • Rely on date stamps
  • Use CRSP Permo (or Cusip?) - Don't need to draw NAICS if we are going to join back...
  • Holding Period Return
  • Value-Weighted Return inc. distributions

Run the regressions on raw data (i.e., don't join to COMPUSTAT first).

Specs:

  • Date Range: 1/1/78 -> 12/31/11
  • Company Codes: PERMNO
  • SEARCH ENTIRE DATABASE
  • ID Info: CUSIP, NAICS
  • Time Series: VOL (Share Volume, -99 is missing), RET (Holding Period Return, error codes -66.0 -77.0, -88.0, -99.0)
  • Share info: SHROUT (No. Shares Outstanding in K)
  • Mkt Info: VWRETD (Value-Weighted Return inc. Dists)
  • Output: tab-delimited txt
  • Date Format: YYMMDDn8 (corresponds to ISO 8601 and is Postgres compatible)

RET errors:

  • E -44.0 No valid comparison for an excess return
  • D -55.0 No listing information
  • C -66.0 more than 10 periods between time t and the time of the preceding price t?
  • B -77.0 not trading on the current exchange at time t
  • A -88.0 no return, array index t not within range of BEGRET and ENDRET
  • -99.0 missing return due to missing price at time t

Get file:

  • e5da94cf0a760426.txt (3195.8 MB, 60127561 observations 8 variables)

Plan: Pull into Postgres, Index, Cut into chunks (yearly? Want < 250mb?), Run regressions in STATA using a batch script with dispatch to Bear.

Ratio of Shares Traded

Defined as: "the ratio of number of shares traded during the last year ending before the equity issue announcement, divided by the number of shares outstanding at the end of the fiscal year before the ... announcement."

We can compute it on an average over an annual basis using CRSP quarterly ("Shares Traded" isn't in COMPUSTAT), or using CRSP daily (same data as above), either way we want:

Data:

  • Share Volume (VOL)
  • No. of Shares Outstanding (SHROUT in K)
  • And to take an average over the year for each firm.

Analyst Forecasts

At least one paper reported problems with the data before 1991 (see the lit review).

  • Forecast Error (Analysts over and under react): [math]ForecastError=\frac{|ACT_t-EST_t|}{|Act_t|}[/math]
  • Std. Deviation of forecasts (Correlated with riskiness): [math] ForecastSD=\frac{SD_t}{|Act_t|}[/math]
  • Range of Forcasts
  • No. Estimates
  • No. Analysts
  • Normalized forecast error: [math]NormForecastError=\frac{ForecastError}{\sigma_{ACT_t - ACT_0}}[/math]

I.e., Over some time period calculate the detrended variation in Earnings. This probably isn't worth it. From KS99: "the normalized forecast error, which is defined as the ratio of the forecast error in earnings to the earnings volatility of the firm. Earnings volatility is the standard deviation of the firm's detrended quarterly earnings in the five-year period before the announcement of the spin-off."

Data drawn from I/B/E/S Summary file:

  • Jan1978-Jan2012
  • CUSIP (8Dg)
  • Entire DB (US and International - both)
  • EPS
  • Fiscal Yr1
  • ID: CUSIP, Company Name, OFTIC, TICKER
  • Other: Forecast Period End Date, Number of Estimates, Mean Estimate, Median Estimate, Standard Deviation, High Est., Low Est., Actual Value, US Firm
  • Sort: Cusip, Forecast period End
  • Output: Tab delimited, None, YYMMDDn8

Get file:

  • b5191ac65df7b6c4.txt (197.3 MB, 2569173 observations 15 variables

Match back to COMPUSTAT to get NAICS. See: http://wrds-web.wharton.upenn.edu/wrds/support/Data/_010Linking%20Databases/_000Linking%20IBES%20and%20CRSP%20Data.cfm

Accounting Variables

Data source: COMPUSTAT - North America Fundamentals Annual

Ref vars:

  • Company Name
  • CUSIP
  • NAICS

Variables:

  • Market-to-Book-Assets (or Q): MKVALT (Sup: Market Value Total) / AT (Bal: Assets Total)
  • Market-to-Book-Equity: CEQ MKVALT (Sup: Market Value Total) / (Bal: Common/Ordinary Equity Total), TEQ (Bal: Shareholder's Equity Total)
  • Earnings to Price Ratio: RE (Inc: Retained Earnings), EBIT (Inc: Earnings before Income Taxes), EPSPI (Inc: Earnings Per Share (Basic) Including Extraordinary Items), PRCC_F (Sup: Price Close - Annual - Fiscal)
  • Firm Size: AT, MKVALT (as above)
  • Development Stage (Sales<0.5b): SALE (Inc: Sales/Turnover (Net))
  • R&D Expenditure (XRD: Inc: Research and Development Expense), RDIP (Inc: In Process R&D Expense)
  • Ratio of R&D to Sales: XRD/SALE (as above)
  • Intangible Assets: INTAN (Intangible Assets - Total)
  • Ratio of Intangible Assets INTAN/AT
  • Sales Growth: [math]\frac{SALE_t - SALE_{t-1}}{SALE_{t-1}}[/math]
  • Common shares: CSHPRI - Common Shares Used to Calculate Earnings Per Share Basic

Draw Notes:

  • Jan 1978 to Jul 2012
  • GVKey (note: No Permno anymore?)
  • No output on screening, otherwise all defaults
  • ID: Company Name, Ticker Symbol, CUSIP, Stock Exchange Code, Fiscal Year-End
  • ID Cont: NAICS
  • Desc: FYear
  • Bal: AT, CEQ, INTAN, RE
  • Inc: EBIT, EBITDA, EPSPI, RDIP, SALE, XRD
  • Misc: CSHPRI, TEQ
  • Sup: PRCC_F, MKVAL
  • tab delimited, no compression, YYMMDDn8

Get file:

  • 0d1f67dfbaded51a.txt (50.0 MB, 347184 observations 24 variables)

Target Characteristics

We already have:

  • Method of Payment
  • Diversification/Related (i.e., Horiz, vert, cong)
  • Acquirer Experience
  • Patent Counts

We need:

  • Distance btw Acquirer and Target
  • Citations Recd to patents

Distance btw Acquirer and Target

Addresses for both the Acquirer and the Target are available from SDC in the vast majority of cases. We will build a quick XML API to access: https://developers.google.com/maps/documentation/distancematrix/

We can pass 2,500 'elements' per IP address per day (24hrs) to this service, with a max of 100 elements per query and a max of 100 elements per 10 seconds. Note that URLs are restricted to 2048 characters, before URL encoding (particularly relevant if using multiple elements) and an element is an origin-destination pair. Returned data includes:

  • Road Distances (in meters/ft(?) in the value field, and km/miles in text)
  • Driving Times (in seconds in the value field, and hours in text)

Geocoding is internal. We can explicitly use Google's geocoding to get longitude/latitude if we want to calculate Great Circle Distances (etc): https://developers.google.com/maps/documentation/geocoding/#XML

Example query: http://maps.googleapis.com/maps/api/distancematrix/xml?origins=Bobcaygeon+ON%7C41.43206,-81.38992&destinations=Darling+Harbour+NSW+Australia&mode=driving&units=metric&sensor=false

The sensible thing is probably to fire one element per query - as there is no gain to doing multiple elements.

Useful code references include: