昨天有件事忘写,Abbott拆分RD前后的debt offering,有点扑朔迷离。
debt/asset ratio,资产负债率,在combined firm level的spinoff前后,都是类似的,0.3。
但spinoff后,母公司Abbott降到0.15,spinco升到0.5.
$50 billion的spinoff规模,debt offering 达$14.7 billion,为史上最大的investment grade级别的公司债。spinoff发生于2013年1月。
今早汇报:
last_mf_count 4.51
mf_count 4.47
next_mf_count 4.83
对照组(但我给每个阶段的spinoff都找了不同的对照组,这样不对!!!要盯着一个公司。重来!!!不过以下结果先显示不同对照组的结果。)
control_last_mf_count 2.75
control_mf_count 3.88
control_next_mf_count 3.44
Friday, January 16, 2015
Thursday, January 15, 2015
Dairy 20150115
1. 用pcl function merge firm name 效果不好,那些公司cusip找不到,应该就是没有mf.
2. 粗略结果。sp公司的mf频率变化不大,control group的频率明显增高。
2. 粗略结果。sp公司的mf频率变化不大,control group的频率明显增高。
Wednesday, January 14, 2015
Dairy 20150114
早汇报三件事,关于律所的报告。
1. No shareholder meetings needed
2. Filings include:
Form 10 for parents
S-1 or 8-A for IPO subsidiaries
3. Debt offering - Cash transactions
Example:
Abbott $50 billion spin off
$14 billion debt offering
力力的问题,
10-K怎么显示俩公司的负债情况?
老克的问题,
generally speaking, stock dividend, splits-off, spin-offs, carve-outs在美国都是谁起头的?MGMT or shareholders? 查Delaware州法律即可。
1. No shareholder meetings needed
2. Filings include:
Form 10 for parents
S-1 or 8-A for IPO subsidiaries
3. Debt offering - Cash transactions
Example:
Abbott $50 billion spin off
$14 billion debt offering
力力的问题,
10-K怎么显示俩公司的负债情况?
老克的问题,
generally speaking, stock dividend, splits-off, spin-offs, carve-outs在美国都是谁起头的?MGMT or shareholders? 查Delaware州法律即可。
Tuesday, January 13, 2015
20150113 Lunch Room Presentation
1. What are the rules for spinoff shareholder meetings?
Do they need a meeting? Kris said in Sweden 必须有那么一个会议。
美国的规定不一样,那么多少$以上,或者占公司比重多少的spinoff,需要那样的会议?
2. Management forecasts始于何时?time series中怎样变化?
3. Analysts forecasts始于何时?time series中怎样变化?
To-do-list
2015.1.13
1. Control Group
2. Expand time to 1998 (IBES)
3. SDC Plantinum, user initial?
4. BUPC email list
5. Bed Frame (Walmart)
6. Credit Card - Holland America?
7. Credit Card Receipt - $500?
8. Register 1 credit in Srping
9. Campus Pre-School Material
10. Rocky 10:30AM Appointment
11. SIC in CRSP?
12. Lunch room presentation Qs
老克的建议
(1) 不要用Information asymmetry这样的字眼,我们不知道管理层到底是不是知道。用Value!!!因为市场低估了Value。
(2) 找control group过程中
条件: a. 两位SIC相同
b. 10%以内的total assets
c. 最接近的MB ratio
如果条件二不满足,把第一条限制去掉。
=====================================
想起小马跟我讲的。debt的原因。
律所的这篇文章,讲起spin off其实也经常牵涉"钱"的问题。比如子公司被spun off前,借了笔钱,然后把现金都给了母公司,在spun off以后,把债务带走。
http://www.wlrk.com/files/2014/SpinOffGuide.pdf
Wachtell, Lipton, Rosen & Katz
Spin-Off Guide
spin off的CAR是最高的,比carve-out和卖部门的CAR都高。如果和钱有关,与debt有关的spin off应该CAR较低。
和力力谈谈这个alternative explanation.
https://books.google.com/books?id=t2qrbAo0fs4C&printsec=frontcover#v=onepage&q&f=false
Do they need a meeting? Kris said in Sweden 必须有那么一个会议。
美国的规定不一样,那么多少$以上,或者占公司比重多少的spinoff,需要那样的会议?
2. Management forecasts始于何时?time series中怎样变化?
3. Analysts forecasts始于何时?time series中怎样变化?
To-do-list
2015.1.13
1. Control Group
2. Expand time to 1998 (IBES)
3. SDC Plantinum, user initial?
4. BUPC email list
5. Bed Frame (Walmart)
6. Credit Card - Holland America?
7. Credit Card Receipt - $500?
8. Register 1 credit in Srping
9. Campus Pre-School Material
10. Rocky 10:30AM Appointment
11. SIC in CRSP?
12. Lunch room presentation Qs
老克的建议
(1) 不要用Information asymmetry这样的字眼,我们不知道管理层到底是不是知道。用Value!!!因为市场低估了Value。
(2) 找control group过程中
条件: a. 两位SIC相同
b. 10%以内的total assets
c. 最接近的MB ratio
如果条件二不满足,把第一条限制去掉。
=====================================
想起小马跟我讲的。debt的原因。
律所的这篇文章,讲起spin off其实也经常牵涉"钱"的问题。比如子公司被spun off前,借了笔钱,然后把现金都给了母公司,在spun off以后,把债务带走。
http://www.wlrk.com/files/2014/SpinOffGuide.pdf
Wachtell, Lipton, Rosen & Katz
Spin-Off Guide
spin off的CAR是最高的,比carve-out和卖部门的CAR都高。如果和钱有关,与debt有关的spin off应该CAR较低。
和力力谈谈这个alternative explanation.
https://books.google.com/books?id=t2qrbAo0fs4C&printsec=frontcover#v=onepage&q&f=false
Monday, January 12, 2015
* 20 parent firms do not have AT in the current year;
* 20 parent firms do not have AT in the current year;
* Airborne Inc-Air Operations, AIRBORNE INC acquired by DHL;
* US Bancorp Piper Jaffray Inc, Parent New GVKEY 4723(1963-2013), Old gvkey 4682;
* Tronox Inc, KERR-MCGEE CORP, parent acquired by Anadarko;
* Fidelity National Title Group, merge after spinoff;
http://www.investor.fnf.com/releasedetail.cfm?ReleaseID=201868
* CPEX Pharmaceuticals Inc, Bentley Pharmaceuticals & Teva Pharmaceutical Industries Ltd. Merger;
* Airborne Inc-Air Operations, AIRBORNE INC acquired by DHL;
* US Bancorp Piper Jaffray Inc, Parent New GVKEY 4723(1963-2013), Old gvkey 4682;
* Tronox Inc, KERR-MCGEE CORP, parent acquired by Anadarko;
http://www.anadarko.com/Investor/Pages/NewsReleases/NewsReleases.aspx?release-id=894918
https://www.quanex.com/News-Room/News-Releases/Investors/Quanex-Corporation-Announces-Plan-to-Separate-Its.aspx
* Suncoke Energy Inc, Energy Transfer Partners, L.P. Acquisition of Sunoco, Inc.;
file:///C:/Users/qzhang25/Downloads/ETP%20to%20Acquie%20SUN%20Investor%20Presentation%20(1).pdf
http://en.wikipedia.org/wiki/Sunoco
* Adelphia Business Solutions, ADELPHIA COMMUN -CL A, two missing years of AT in Compustat;
* Comverse Inc, parent COMVERSE TECHNOLOGY INC merger with VRNT;
http://www.spinoffresearch.com/Stock-Spin-Off-Research-Report-blog/bid/161470/CMVT-Spin-Off-Comverse-Technology-Comverse-Inc-When-Issued-Trading
* Fidelity National Title Group, merge after spinoff;
http://www.investor.fnf.com/releasedetail.cfm?ReleaseID=201868
* CPEX Pharmaceuticals Inc, Bentley Pharmaceuticals & Teva Pharmaceutical Industries Ltd. Merger;
http://www.drugs.com/news/bentley-pharmaceuticals-amp-teva-pharmaceutical-industries-ltd-merger-consideration-established-14-8367.html
* SurgiCount Medical Inc, Compustat doesn't record any AT in any year;
* BioVeris Corp, ROCHE TO ACQUIRE IGEN, parent;
http://www.sec.gov/Archives/edgar/data/916304/000095015703000463/form8-k.txt
* Cohesant Inc, merger & spinoff;
http://www.businesswire.com/news/home/20080227006151/en/Cohesant-Technologies-Completes-Sale-Glascraft-Graco-Completes#.VLQreSvF8UN
* Straight Path Communications, IDT CORP 62396, full info in AT, cannot UNDERSTAND!!!;
* Marlborough Software, merge & spinoff;
http://www.sec.gov/Archives/edgar/data/818813/000119312511307245/d255179dex991.htm
* 8 parent firms do not have AT in the next year;
SAS Pro\Spinoff
New20150112.SAS
* 8 parent firms do not have AT in the next year;
* Cadbury Schweppes Americas, Cadbury, Demerger of Cadbury Schweppes plc, cease trading on NYSE in 2008;
* Flamemaster Aerospace Corp, FLAMEMASTER CORP, reorganize;
* Monsanto Co, PHARMACIA CORP, stopped trading in 2002;
* Post Foods LLC, RALCORP HOLDINGS INC, ConAgra Foods agreed to acquire Ralcorp on November 26, 2012;
* PPD Inc-Furiex Pharm Inc, delist from NASDAQ;
New20150112.SAS
* 8 parent firms do not have AT in the next year;
* Cadbury Schweppes Americas, Cadbury, Demerger of Cadbury Schweppes plc, cease trading on NYSE in 2008;
* Flamemaster Aerospace Corp, FLAMEMASTER CORP, reorganize;
* Monsanto Co, PHARMACIA CORP, stopped trading in 2002;
* Post Foods LLC, RALCORP HOLDINGS INC, ConAgra Foods agreed to acquire Ralcorp on November 26, 2012;
* PPD Inc-Furiex Pharm Inc, delist from NASDAQ;
http://www.getfilings.com/sec-filings/111205/PHARMACEUTICAL-PRODUCT-DEVELOPMENT-INC_8-K/
* Strategos Inc, INNOVARO INC, delist from NYSE;
http://www.businesswire.com/news/home/20121205006638/en/Innovaro-Receives-Delisting-Notification-NYSE-MKT#.VLQZbyvF8UM
* Abraxis Pharmaceutical, APP PHARMACEUTICALS INC, remove from NASDAQ;
http://services.corporate-ir.net/SEC.Enhanced/SecCapsule.aspx?c=130431&fid=5307510
Unique ID in Compustat
Topic: Unique Identifier
Q: How to find unique obs in Compustat?
A: DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D
web:
https://cobweb.business.nd.edu/Portals/0/MendozaIT/Research/Shared%20Documents/CCM/Data%20Guides/CRSP-Compustat%20Merged%20Database%20Guide.pdf
page 11
问了力力,他说,看似是对的。就是keyset=0的那一行。找一个WRDS的sample program来看看。
我找了以下的。应该是对的。
http://wrds-web.wharton.upenn.edu/wrds/support/Data/_003Sample%20Programs/Compustat/compna_funda1.cfm
Q: How to find unique obs in Compustat?
A: DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D
web:
https://cobweb.business.nd.edu/Portals/0/MendozaIT/Research/Shared%20Documents/CCM/Data%20Guides/CRSP-Compustat%20Merged%20Database%20Guide.pdf
page 11
问了力力,他说,看似是对的。就是keyset=0的那一行。找一个WRDS的sample program来看看。
我找了以下的。应该是对的。
http://wrds-web.wharton.upenn.edu/wrds/support/Data/_003Sample%20Programs/Compustat/compna_funda1.cfm
Subscribe to:
Posts (Atom)
