125
edits
Changes
Jump to navigation
Jump to search
Winner's Curse in Acquisitions (Academic Paper) (view source)
Revision as of 11:36, 14 October 2016
, 11:36, 14 October 2016→Normalizing SDC data
=== Normalizing SDC data ===
Make sure that the first line of the data file starts with the column names and column name are not preceded by empty lines. Also, remove the summary/report lines at the bottom of the text file.
A copy of the normalizer is save here
# Drag and drop NormalizeFixedWidth.pl in Komdo
# Click on the start or continue debugging
# Type : '''-file=SDC_MA_Oct10v3SDC_MA_Oct10v4.txt''in Script Arguments textbox. # Click on OK# Enter the number of last line of the header and press return. This should be the line immediately followed by the first row of data. ########################################################## # NormalizeFixedWidth.pl # # v0.01 # # (c)Ed Egan, 2010 # ########################################################## Starting the program... [Done] Your run options are: File to read from... [SDC_MA_Oct10v4.txt] File to write to... [SDC_MA_Oct10v4-normal.txt] Opening the input file to read... [Done] ########################################################## Choose the last line of the header (inc. blanks): 0 Date Date Target Name 1 Announced Effective 2 3 4 5 6 01/01/85 01/01/85 Gladieux Corp 7 01/02/85 01/02/85 STG Electrosystems Inc 8 01/03/85 01/03/85 American Title Co 9 01/04/85 01/04/85 Bee Chemical Co Your Choice: 5 Thank you - Proceeding now... ########################################################## Determining markers... [Done] Processing the header... [Done] Processing the body... [Done] Removing dead columns... [Done] ########################################################## Choose any columns you want repeated down (e.g. 0,1,2): 0 Date Announced 1 Date Effective 2 Target Name 3 Target Industry Sector 4 Target Nation 5 Acquiror Name 6 Acquiror Industry Sector 7 Acquiror Nation 8 Pc of Shares Acq 9 Pc Owned After Transaction 10 Value of Transaction mil 11 Enterprise Value mil 12 Equity Value mil 13 Acquiror CUSIP 14 Acquiror Immediate Parent CUSIP 15 Acquiror Ultimate Parent CUSIP 16 Target Immediate Parent CUSIP 17 Target Ultimate Parent CUSIP 18 Target CUSIP 19 Acquiror Primary Ticker Symbol 20 Acquiror Ultimate Parent Primary Ticker Symbol 21 Target Primary Ticker Symbol 22 Target Ultimate Parent Primary Ticker Symbol 23 Acquiror Primary NAIC Code 24 Acquiror Ultimate Parent Primary NAIC Code 25 Target Primary NAIC Code 26 Target s Ultimate Parent Primary NAIC Code 27 Number of Bidders 28 Status 29 Value Est 30 Value Amended Flag 31 Date Announced is Estimated 32 Consideration Structure 33 Number of Considerations Offered 34 Number of Considerations Sought 35 Consid Structure Description 36 Pc of Cash 37 Pc of Other 38 Pc of Stock 39 Pc of Unknown 40 Acquiror Full Name 41 Target Name 42 Acquiror City 43 Target City 44 Acquiror Zip Code 45 Target Zip Code 46 Acquiror State 47 Target State 48 Deal Currency Code 49 Target Bankrupt 50 Challenged Deal 51 Debt Restructuring 52 RecapDefense 53 Government Owned Involvement Flag 54 Joint Venture 55 Restructuring 56 Acquiror is a Leveraged Buyout Firm 57 LBO 58 IPO FlagY N 59 Target is a Leveraged Buyout Firm 60 Merger of Equals 61 Reverse Takeover 62 Deal Began as a Rumor 63 Acquiror is a White Knight 64 White Knight Defense 65 Back End Defense 66 FlipOver Defense 67 Voting Plan Defense 68 Poison Pill 69 Creeping Acquisition 70 Repurchase Defense 71 Pacman Defense 72 Lockup FlagY N 73 Target Lockup 74 Greenmail 75 Asset Lockup 76 Scorched Earth Defense 77 SelfTender Defense 78 Stock Lockup 79 Defense 80 White Squire 81 Acquiror Includes Employees 82 Acquiror Includes an ESOP 83 Significant Family Ownership of Target 84 Acquiror Lockup 85 Financial Acquiror 86 2 Step Spinoff 87 Acquiror Includes Mgmt 88 Open Market Purchases 89 Proxy Fight 90 Purpose Code 91 Related Deals 92 Foreign Provider of Funds 93 Stock Swap 94 Asset Swap Flag 95 Sweep the Street 96 SelfTender 97 Tender Offer 98 Unsolicited 99 Acquiror TermFee 100 Target TermFee 101 Forced vote provisions FlagY N 102 Walkaway 103 Acquiror Ultimate Parent Street Address 1 104 Acquiror Ultimate Parent Street Address 2 105 Target Ultimate Parent Street Address 1 106 Target Ultimate Parent Street Address 2 107 Acquiror Primary Stock ExchangeName 108 Target Primary Stock ExchangeName 109 Target Net Sales LTM mil 110 Target Net Assets mil 111 Target Total Assets mil 112 Target Common Equity mil 113 Target Book Value Per Share LTMUS 114 Target Intangible Assets mil 115 Target R D One Year Priormil 116 Target Total Liabilities mil Your Choice: Thank you - Proceeding now... ########################################################## Writing the output file... [Done] ########################################################## Thank you for processing data with NormalizeFixedWidth Please cite any Ed Egan corporate finance paper in your references or otherwise acknowledge this help to your work. (c)Ed Egan, 2010. Enjoy. (US dollars preferred.) ##########################################################
==Previous Papers==
