7,627
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 11:10, 1 July 2019
, 11:10, 1 July 2019→LBO data
SELECT LPAD(gvkey::text, 6, '0') as gvkey
There are currently supposed to be 521 LBOs, and we have data on 483 (these are exported to Z:\lbo\LBOBase.txt). We are therefore missing data on 521-483=38. Their names and dealnums (including for Aurora Electronics Inc) into E:\projects\lbo\MissingLBOFirmNames.txt. The DISTINCT conm (names) and GVKEYs of all COMPUSTAT firms are in DistinctCSconm.txt (37759). These were matched using the Matcher. The results are in MissingLBOFirmNames.txt-DistinctCSconm.txt.matched, which is also a sheet called Matching in 484_LBOs_Outcomes_Master_Table.xlsx, as well as posted below.
File1:Coname |File1:Dealnu|File2:conm |File2:gvkey|Normalization
-------------------------------------------------------------------------------------------------------------
Baldwin Piano & Organ | 19|BALDWIN PIANO & ORGAN CO | 12656|Hall
Pamida Inc | 70|PAMIDA INC | 8306|Hall-Warning:Multiple
Pamida Inc | 70|PAMIDA INC-DEL | 14838|Hall-Warning:Multiple
Boys Markets Inc | 71|BOYS MARKETS INC | 13739|Hall
Budget Rent-A-Car Corp| 77|BUDGET RENT-A-CAR CORP | 13394|Hall
Amphenol Corp | 97|AMPHENOL CORP | 14282|Hall
Eagle Food Centers | 114|EAGLE FOOD CENTERS INC | 15424|Hall
Grand Union Co | 132|GRAND UNION CO | 61094|Hall-Warning:Multiple
Grand Union Co | 132|GRAND UNION CO -OLD | 5261|Hall-Warning:Multiple
Grand Union Co | 208|GRAND UNION CO | 61094|Hall-Warning:Multiple
Grand Union Co | 208|GRAND UNION CO -OLD | 5261|Hall-Warning:Multiple
Advantage Health Corp | 225|ADVANTAGE HEALTH CORP | 24927|Hall
Gruntal Financial | 250|GRUNTAL FINANCIAL CORP | 11710|Hall
Constar International | 294|CONSTAR INTERNATIONAL INC| 4049|Hall
Woodstream Corp | 393|WOODSTREAM CORP | 11578|Hall
Loehmanns Holdings Inc| 406|LOEHMANN'S HOLDINGS INC | 15346|Hall
Collins Industries Inc| 491|COLLINS INDUSTRIES INC | 3178|Hall
EMPIRE INC. | 541|EMPIRE CO LTD -CL A | 14312|Hall
PANNILL KNITTING | 551|PANNILL KNITTING CO INC | 12325|Hall
GENERAL HOST CORP | 565|GENERAL HOST CORP | 5060|Hall
SBARRO INC | 568|SBARRO INC | 9441|Hall
There are 18 matches (counting both Grand Union Co), but Pamida matches to two GVKEYs and we need to work out which Grand Union Co is which.
After name-based matching, there are 20 LBOs still unmatched. They are (also in StillMissingLBOs.txt in the dropbox and E:\lbo):
LBOName DealNum
-------- -------
AME Inc 196
American Electric Auto Co Inc 358
Anderson Tully Co 440
Becor Western Inc 94
Borg-Warner Corp 98
Camelot Music Holdings 234
Colt Industries Inc 140
Condec Corp 14
Consolidated Hydro Inc 165
EFTC Corp 342
Finl Institutions Ins Grp Ltd 242
Florida Steel Corp 166
G N I GROUP INC 566
Genesis Health Ventures Inc 318
International Controls Corp 100
Katz Capital Corp 237
MIDAMERICAN ENERGY HLDGS CO NEW (not really an LBO) 567
Research Cottrell Inc 107
Steel Heddle Manufacturing Co 179
===Code===
