Tuesday, May 5, 2015

一些问题

Q1. Consolidated financial statements的标准?

50%, 必须纳入母公司。

Q2. IBES的EPS算法很奇怪,怎么办?

全部用IBES的算法就好,不要自己用Compustat和CRSP来算EPS。

Q3. 现在把SDC其他数据合并过来,看看spinoff之前的持股比例,再来定Total Assets的情况。

Q4. 我的parent和sub的MV都大的吓死人,尤其sub。有可能,没有排除REIT。

CRSP有个share code, (shrcd)但是在DSE下面,都是missing状态。

Compustat说SIC code

Try1:
我把sub凡是-1年有MV的,全都删除了。没什么效果。

Try2:
我把SHRCD凡是18(第二位数字8,代表REIT),删除了。也没什么效果。

Monday, May 4, 2015

母公司合并报表,有包括子公司吗?

ID 1019

01AUG2013  Straight Path Communications

貌似没有

母公司IDT
子公司Straight Path Communications

spin-off前一年的10-K在这里,根本搜索不到子公司关键词。

https://www.sec.gov/Archives/edgar/data/1005731/000119312512423374/d400668d10k.htm#fin400668_5

=======================================================

ID 430

30SEP1997 Crescendo Pharmaceuticals Corp

spin-off前一年的10-K,也没有搜到子公司名

https://www.sec.gov/Archives/edgar/data/4310/0000912057-97-011202-index.html

=======================================================

ID 524 03MAY1999 VoiceStream Wireless Corp

母公司说的很清楚,没有计入合并报表。

https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000930738&type=10-K&dateb=&owner=exclude&count=40

https://www.sec.gov/Archives/edgar/data/930738/0000891020-99-000582.txt

      Western Wireless' ownership interest in these unconsolidated affiliates
range from 18% to 63%. Those ownership interests greater than 50% are temporary,
therefore the entities are not consolidated.

        VoiceStream Investments:

        A subsidiary of VoiceStream holds a 49.9% interest in Cook Inlet Western
Wireless PV/SS PCS, L.P. ("Cook Inlet PCS"). Cook Inlet PCS is subject to the
FCC build-out requirements and will require significant additional amounts to
complete the build-out of its PCS systems and to meet the government debt
service requirements on its C and F Block licenses. The potential sources of
such additional funding include vendor loans, loans or capital contributions by
the partners of Cook Inlet PCS or other third party financing. VoiceStream
funded the operations of Cook Inlet PCS during 1998 and 1997 through loans
evidenced by promissory notes which are due 180 days after the date of issuance.
The weighted average interest rate was 15% for 1998 and 1997. All promissory
notes that have come due were replaced with new promissory notes.

=======================================================

ID 602 11DEC2000 Sybron Dental Specialties Inc


https://www.sec.gov/Archives/edgar/data/824803/000095012400007554/0000950124-00-007554-index.htm


https://www.sec.gov/Archives/edgar/data/824803/000095012400007554/c58049e10-k405.txt


(1) SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES

     The subsidiaries of Sybron International Corporation are leading
manufacturers of value-added products for the laboratory market in the United
States and abroad. The Company's laboratory subsidiaries manufacture products
for the Labware and Life Sciences, Clinical and Industrial, Diagnostic and
Microbiology and Laboratory Equipment business segments. See note 16.

     On November 8, 2000, Sybron International Corporation announced that it had
declared a pro rata distribution to its shareholders of the common stock and
related preferred stock purchase rights of Sybron Dental Specialties, Inc.
(formerly known as SDS Holding Co.) (the "Distribution"). On December 11, 2000,
shareholders of record as of November 30, 2000 received one share of Sybron
Dental Specialties, Inc. common stock for every three shares of Sybron
International common stock they owned as of the record date. Sybron Dental
Specialties, Inc. owns all of the outstanding stock of Sybron Dental Management,
Inc., formerly named Sybron Dental Specialties, Inc. Prior to the Distribution,
Sybron Dental Management, Inc. was a direct wholly-owned subsidiary of the
Company and operated the Company's dental business. Immediately prior to the
Distribution, the Company contributed all of the stock of Sybron Dental
Management, Inc. to Sybron Dental Specialties, Inc. As used in these Notes to
the Consolidated Financial Statements, the term "SDS" means Sybron Dental
Management, Inc. (formerly known as Sybron Dental Specialties, Inc.) for the
periods prior to the Distribution, and Sybron Dental Specialties, Inc. (formerly
known as SDS Holding Co.) for periods after the Distribution.

  (a) Principles of Consolidation and Fiscal Year End

     The consolidated financial statements reflect the accounts of Sybron
International Corporation and its subsidiaries. The term "Company" or "Sybron"
as used herein refers to Sybron International Corporation and its subsidiaries
and their respective predecessors, unless the context otherwise requires. All
significant intercompany balances and transactions have been eliminated. The
Company's fiscal year ends on September 30. The fiscal years ended September 30,
1998, 1999 and 2000 are hereinafter referred to as "1998," "1999" and "2000,"
respectively. On March 31, 1999 and December 11, 2000, respectively, the Company
sold Nalge Process Technologies Group, Inc. ("NPT") (the "NPT Sale") and
completed the Distribution. The net assets and results of operations of SDS and
NPT have been presented as discontinued operations in all years presented
herein.

=======================================================

ID 681 14MAR2003 MOD PAC CORP

没有包含这个子公司。

https://www.sec.gov/Archives/edgar/data/8063/000089979703000139/0000899797-03-000139-index.htm

https://www.sec.gov/Archives/edgar/data/8063/000089979703000139/exhibit13.htm 

NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
Note 1
Summary of Significant Accounting Principles and Practices
Principles of Consolidation
The consolidated financial statements include the accounts of the Company and its wholly-owned subsidiaries, except for MOD-PAC Corp., which is presented with discontinued operations. All intercompany transactions and balances have been eliminated.

Wednesday, April 22, 2015

Total Assets

Q1. Do consolidated financial statements include public carve-outs before spin-offs?

Q2. TA是受outlier影响吗?为什么会变小,变大?

bm more than 1.2是怎么回事?

05AUG1997 Enserch Exploration Inc
Parent: TXU GAS CO


Compustat 收集的Outstanding Shares #,是0.202,貌似不对。
Compustat prcc_f=$19.75在合理范围内,根据以下期权推测的。


Merger with TUC

     On August 5, 1997 (Merger Date or Acquisition Date), the merger
transactions (Merger) between the former Texas Utilities Company, now known as
TEI, and ENSERCH were completed.  At the effective time of the Merger: (i) the
former Texas Utilities Company changed its name to TEI, (ii) TEI and ENSERCH
merged with wholly-owned subsidiaries of TUC Holding Company, which, as a
result, owned all the common stock of TEI and of ENSERCH, (iii) TUC Holding
Company changed its name to Texas Utilities Company, (iv) each share of TEI's
common stock was automatically converted into one share of common stock of
TUC, and (v) each share of common stock of ENSERCH was automatically converted
into 0.225 shares of common stock of TUC, with cash issued in lieu of
fractional shares.  The share conversions were tax-free transactions.  In the
Merger, approximately 15.9 million shares of TUC common stock were issued to
former holders of ENSERCH common stock.  The value assigned to the TUC shares
issued and costs incurred in connection with the acquisition of ENSERCH
aggregated $579 million.  At the date of the Merger, ENSERCH had debt and
preferred stock outstanding of approximately $1.3 billion.

发生了Merge.

https://www.sec.gov/Archives/edgar/data/33015/0000033015-98-000002.txt

============================================================

04JAN2000 Coors Ceramics Co
Parent: GRAPHIC PACKAGING INTL CORP



也没错。

As  a  result  of the spin-off of CoorsTek on December  31,
1999,  the market price of the Company's stock opened on  January
3, 2000 at $5.875 per share, versus the closing price of $10.6875
per share on December 31, 1999.

      During 2000, 1999 and 1998, no cash dividends were paid  by
the Company to its common shareholders.  During 2000, the Company
declared  $3,806,000 of dividends on its 10% Series  B  preferred
stock.   At  this time, the Company anticipates that, except  for
the  10%  Series B preferred stock dividends, it will retain  any
earnings  and  that  the Company will not pay  dividends  to  its
common  shareholders  in  the  foreseeable  future.   Also,   the
Company's credit facilities currently prohibit the payment of any
cash  dividends, except on the Series B preferred stock, and  the
Company expects this limitation to remain in effect through 2001.

市场对于spinoff反应不佳。

https://www.sec.gov/Archives/edgar/data/892793/000089279301500004/fourthquarterk.txt

============================================================

30SEP2008 Genworth Finl-US Mortgage-Ins
Parent: GENWORTH FINANCIAL INC

We consider our market capitalization in assessing the reasonableness of the fair values estimated for our reporting units in connection with our goodwill impairment testing. In considering our 2008 stock price, which was lower than our book value per share as of December 31, 2008, we noted there are several reasons that would result in our market capitalization being lower than the fair value of our reporting units that are tested for goodwill impairment. The inputs that are reflected in our stock price that would not be reflected in the valuation of our reporting units with goodwill include: any anticipated potential equity dilution; negative market sentiment, or very low valuations, associated with certain reporting units that no longer have goodwill; and increased risk premium for the enterprise exposure to the U.S. residential housing market, in terms of both mortgage insurance and residential mortgage-backed securities, for reporting units that no longer have goodwill. For businesses that do not have goodwill and are not subject to goodwill impairment testing, we estimate the values for those businesses when reconciling to our market capitalization. Additionally, we also consider the negative value that would be associated with corporate debt, which would be subtracted from the fair value of our businesses to calculate the total value attributed to equity holders. We then compare the total value attributed to equity holders

Compustat prcc_f
$25.45 =>  $2.83 => $11.35

https://www.sec.gov/Archives/edgar/data/1276520/000119312509041694/d10k.htm#tx27920_23

============================================================

20NOV1995 Union Property Investors Inc
MILESTONE PROPERTIES INC


数字也都没错。

Due primarily to the continuing negative effects of the economy on our advertising revenues and those of other publishing companies, and the difference between our stock price following the spin-off of SNI to our shareholders and the per-share carrying value of our remaining net assets, we determined that indications of impairment existed as of June 30, 2008.

解释了股价不好的原因,主要是经济对于广告收入的负面影响。

https://www.sec.gov/Archives/edgar/data/832428/000095015209002072/l35132ae10vk.htm

============================================================

01JUL2008 Scripps Networks

EW SCRIPPS -CL A


有一个stock split,所以股价降的很厉害。

https://www.sec.gov/Archives/edgar/data/832428/000095015209002072/l35132ae10vk.htm

============================================================

29JUN1995 Dave and Buster's(Edison)
EDISON BROTHERS STORES




See Management s Discussion and Analysis for significant items affecting
     data comparability among 1993, 1994, and 1995.  See Note 18 to the
     consolidated financial statements for discussion of the restatement of
     income in 1993.  The effect of restatement in 1992 and 1991 was a $.7 (3
     cents per share) and a $2.0 (9 cents per share) reduction of income,
     respectively.  Long-term debt has been reclassified to liabilities subject
     to settlement under reorganization proceedings (see Note 5 to the
     consolidated financial statments).


股价一直下降,跟restatement有关。

Note 4: Dispositions

     Effective June 29, 1995, the company distributed all of the outstanding
     shares of common stock of Dave & Buster's, Inc. owned by the company to
     Edison Brothers' stockholders of record as of June 19, 1995.  Prior to the
     distribution, Dave & Buster's had been a majority-owned subsidiary engaged
     in the ownership and operation of restaurant/entertainment complexes.  No
     gain or loss was recorded as a result of the distribution.   The
     distribution was recorded as a dividend and, accordingly, the company
     reduced retained earnings by the net book value distributed.  Through the
     distribution date, Dave & Buster's reported 1995 net income of $1.0.  As of
     June 29, 1995, it had total assets of $49.2 and a net book value of $30.9. 
     For fiscal years 1994 and 1993, Dave & Buster's reported net income of $2.4
     and $1.2, respectively.  At the end of 1994 Dave & Buster's had total
     assets of $49.0 and a net book value of $27.7.  The company has guaranteed
     certain Dave & Buster's lease obligations with a present value of $8.2. 
     Dave & Buster's has agreed, among other things, to indemnify the company
     from loss under the lease guarantees and has granted the company a
     subordinated security interest in Dave & Buster's leasehold interests in
     the guaranteed leases and all real and personal property owned by Dave &
     Buster's on the date of the agreement.  The company believes it has
     adequate security against loss under the guarantees.




















bm less than 0.2是怎么回事?

14-Dec-06 Mueller Water Products Inc
Parent: WALTER ENERGY INC

NOTE 2—Discontinued Operations
Acquisition, Initial Public Offering and Spin-off of Mueller Water Products, Inc.
Acquisition
In October 2005, the Company acquired all of the outstanding common stock of Mueller Water Products, Inc. (“Mueller Water”) for $943.4 million and assumed approximately $1.1 billion of indebtedness at Mueller Water. In conjunction with the acquisition, the Company’s wholly owned subsidiary, United States Pipe and Foundry Company, LLC, (“U.S. Pipe”) was contributed to Mueller Water.
Also in October 2005, the Company announced its plan to undertake an initial public offering and spin-off of Mueller Water to unlock shareholder value by creating a “pure play” water infrastructure company and a predominantly “pure play” coal company.
Initial public offering
In June 2006, Mueller Water completed its initial public offering (“IPO”) of 28.8 million shares of Series A common stock, at $16 per share (NYSE: MWA). The net proceeds of $428.9 million were used to repay a portion of Mueller Water’s existing debt and the Company recognized a gain of $132.0 million on the sale of the 25.1% ownership interest which has been included in stockholders’ equity. In connection with the IPO, Mueller Water issued approximately 85.8 million shares of Series B common stock to the Company in exchange for the Company’s one share held prior to the IPO.
Spin-off
On December 14, 2006, the Company distributed all of its 85.8 million shares of Mueller Water Series B common stock to its shareholders. The distribution took place in the form of a pro rata common stock dividend whereby each shareholder received 1.6524432  shares of Mueller Water Series B common stock for each share of Company common stock held on the record date (“the spin-off”). The spin-off was intended to be tax-free to the Company and to the shareholders of the Company for U.S. income tax purposes, except for any cash received in lieu of fractional shares.
As a result of the distribution, the Company no longer has any ownership interest in Mueller Water. The Company and Mueller Water have entered into several agreements to facilitate the spin-off, including a Transition Services Agreement to provide certain services to each other, including tax, accounting, human resources and communication. The term of the services to be provided varies, but the Agreement is expected to terminate one year from the spin-off date. The Company and Mueller Water entered into an Income Tax Allocation Agreement that sets forth the rights and obligations of the Company and Mueller Water with respect to taxes and other liabilities that could be imposed in the event of a determination by the Internal Revenue Service, upon audit, that the transaction is inconsistent with the tax-free status of the spin-off. Additionally, the Company and Mueller also entered into a Joint Litigation Agreement that allocates responsibilities for pending and future litigation and claims, allocates insurance coverages and third-party indemnification rights, where appropriate, and provides that each party should cooperate with each other regarding such litigation claims and rights on a going forward basis.
As a result of the spin-off, amounts previously reported in the Mueller Co., Anvil and U.S. Pipe segments (collectively, “Mueller Water”) are presented as discontinued operations for all periods presented.
The Company allocated certain corporate expenses, limited to specifically identified costs and other corporate shared services which supported segment operations to discontinued operations, in accordance with EITF 87-24, “Allocation of Interest to Discontinued Operations.”  These costs represent expenses that have historically been allocated to and recorded by the Company’s operating segments as selling, general and administrative expenses. The Company did not elect to allocate additional interest expense to discontinued operations in accordance with EITF 87-24.
https://www.sec.gov/Archives/edgar/data/837173/000110465907015143/a07-5258_110k.htm

============================================================


10APR2008 Globys Inc
Parent: VERISIGN INC


2008年有个超夸张的Accumulated Deficit.

Reclassifications – Other

During 2008, the Company identified that it had not accrued for penalties incurred related to late payment of federal and state payroll taxes for the periods during fiscal 2004 through fiscal 2007 of approximately $9.6 million. However, the cumulative amount of unrecorded penalties identified during 2008 are significant to the results of operations of fiscal 2008. During the quarter ended June 30, 2008, the Company corrected the prior periods, as presented, by recording the penalties and interest in their respective prior periods, resulting in increased operating expenses and decreased net income (loss) from previously reported amounts. As a result, the Company recorded penalties and interest of approximately $6.0 million and $1.0 million for the years ended December 31, 2007 and 2006, respectively. The Company recorded penalties and interest for an aggregate of $2.6 million as a cumulative adjustment to Accumulated deficit and Accounts payable and accrued liabilities as of January 1, 2006.

原因看来是TAX的罚款。但完全没有提及spin off.关键词"Globys"子公司名字,也是频率0。

https://www.sec.gov/Archives/edgar/data/1014473/000119312509043713/d10k.htm

============================================================

10MAY1995 Darden Restaurants Inc
Parent: GENERAL MILLS INC


MANAGEMENTS DISCUSSION OF RESULTS OF OPERATIONS AND FINANCIAL
CONDITION

In fiscal 1995 the General Mills Board of Directors decided to
separate the Company into two independent public corporations, one
for consumer foods and one for restaurants.  The Board's decision
was based on the belief that separate corporations with highly
integrated strategies, organizations and incentive programs will
produce the strongest growth performance and thereby enhance long-
term shareholder value.  General Mills completed the spin-off
distribution of the Restaurant operations as a separate, free-
standing company, Darden Restaurants, Inc. (Darden), to our
shareholder on May 28, 1995.  Also in May 1995, General Mills sold
the Gorton's frozen and canned seafood products business to allow
management to sharpen its focus on the best growth and return
opportunities in Foods.

https://www.sec.gov/Archives/edgar/data/40704/0000040704-95-000016.txt

============================================================

11JAN2013 Liberty Spinco Inc
Parent: STARZ


https://www.sec.gov/Archives/edgar/data/1507934/000150793414000013/starz_10-kx12312013.htm

I. Reasons for spin-off:
Per the company's filing:
The board of directors of Liberty Media periodically reviews with management the strategic goals and prospects of its various businesses, equity affiliates and other investments. As a result of a review undertaken during the summer of 2012 the Liberty Media board determined that the Spin-Off would allow each of Starz and Spinco to pursue strategic opportunities that are not otherwise available to them in Liberty Media's current configuration and, over time, enhance the operating performance of the two companies. Among the factors considered by the Liberty Media board in arriving at its determination were the following:
• By separating the more complex collection of businesses and investments that currently comprise Liberty Media from Starz, LLC, Liberty Media believes that the conglomerate or "holding company" discount inherent in Liberty Media's common stock will be eliminated, as Starz will become a "pure play" media company valued in a manner consistent with other companies in the premium television industry. The elimination of the holding company discount at Starz will create a more efficiently priced equity security for Starz to use to effect a complementary business combination using its equity and enable Starz's stock to be more accurately valued by potential acquirors.
• The Spin-Off is expected to cause the holding company discount with respect to the Spinco common stock to be reduced, as separating Starz, LLC and its subsidiaries will better highlight the discount at which the Liberty Media common stock historically has traded relative to its underlying asset composition. This reduction of the holding company discount associated with the Spinco common stock would enhance the ability of Spinco to issue its equity for purposes of making strategic acquisitions with less dilution to its stockholders.
• By effecting the Spin-Off, both companies will be better positioned to take advantage of business opportunities that are not available to them under Liberty Media's existing configuration. Each of Starz and Spinco will have greater flexibility in structuring strategic alliances, acquisitions and other business combinations and a stronger acquisition currency.
• The contribution of cash to Spinco in connection with the Spin-Off will provide Spinco with greater liquidity to acquire additional shares of its equity affiliates, invest in complementary businesses and pursue other strategic objectives and acquisitions.
• In connection with the internal restructuring and the cash contribution to Spinco, Starz will optimize its capital structure, through the draw down of the Starz credit facility, which is expected to provide for more attractive leveraged equity returns for Starz's stockholders.
Conclusion: The reasons for the spin off seem compelling. If things go as expected, not only will Starz benefit from the removal of discount associated with being part of a complex conglomerate but also it will benefit from a leveraged equity position, which may provide better returns.

http://www.gurufocus.com/news/240862/easy-does-it--my-best-investment-in-2013


但还是不能解释,为什么很low的bm情形下,他们还觉得自己的market value被低估了?
============================================================

31DEC1998 Convergys Corp
Parent: CINCINNATI BELL INC

没错啊。CEQ, Shares #, Price

https://www.sec.gov/Archives/edgar/data/716133/0001047469-99-012839.txt

Cincinnati Bell Inc. announced it will spin off its fastest-growing subsidiaries, Matrixx Marketing and Cincinnati Bell Information Systems, to create a new company called Covergys Corp. Cincinnati Bell intends to take Convergys public in May and later spin it off in a tax-free distribution to shareholders. Company officials and experts believe creating Convergys will allow the stock of faster-growing and unregulated Matrixx, a telemarketing company, and CBIS, a maker of billing software for wireless communications, to be valued at a higher price than the regulated phone business, benefiting shareholders. Bell also announced first-quarter sales of $508 million and net income of $49 million, down 14 percent from the first quarter of 1997.

http://www.bizjournals.com/cincinnati/stories/1998/04/27/daily1.html
============================================================






Tuesday, April 21, 2015

Tuesday's Presentation, Apr. 21

1. bm小于0.2,或者大于1.2,都发生了什么?

2. MV的涨幅如此巨大,bm怎么反而会变小?

3. 另一种bm算法。(market value+debt)/assets。跳过CEQ。

4. diff-by-diff中,former public sub有没有在consolidated parent financial statements中,看EDGAR!

5. 其他variables呢?

a. R&D/Sales
b. pct change /absolute change in sales
c. cash/assets

Monday, April 20, 2015

Monday's Presentation, Apr. 20

1. SDC Synopsis (A little summary)

2. Two database 要说清楚

a) SDC M&A
b) SDC New Issuing

3. "x" in summary 3.0
Put reasons in the column, but not now.

4. SDC unique number "DEAL NAME"?
正好说道,我给每个spinoff obs一个ID。

5. Distribution of time between effective and announcement dates

6. Never touch original data
如果要改参数的话,比如AT<0要设置成AT=.的话
换个别的名字。

7. diff-by-diff AT

ratio = > change
value = > percentage change

ttest

8. combined firm

pick a firm, print it last, now, next AT in SAS codes

9. double accounting