The first entries below are from the main article that accompanied the data viz. Additional details are then provided below that.
Remapping Debate examined quartely SEC filing data for the period closest to June 30th in 2012, 2006, and 2000. For 10 companies in 2000, comparable data were not available.
All figures have been inflation-adjusted to 2012 dollars.
Important wrinkle in respect to Caterpillar, International Paper, Kroger, Target, and Valero: in one or more years, one or more of these companies did not disaggregate their CCE amount from their short-term investment amount. In each such case, we attributed all of the non-differentiated amount to CCE (thereby likely overstating CCE and understating short-term investments). In each affected year, short-term investments are listed as “not available” (and are reflected on the pie chart as an undifferentiated portion of CCE). For the short-term investment sorts, affected companies are listed at the bottom. For CCE sorts, however, the affected companies are listed as they would be if all CCE and short-term investment were properly attributed to CCE, thereby potentially skewing the rankings. This issue has no impact on the rankings for CCE and short-term investments combined.
Note: when you change views, neither the pie chart nor the dollar and percentage values change to the first-listed company; you must manually click on a company name to refresh the data.
Additional detail: companies with no data for 2000:
Aetna – No data for 2000. Aetna sold its financial services and international businesses to ING in 2000 and spun off its health business as an independent publicly held company.
Amerisourcebergen – No data for 2000. Amerisourcebergen was created by the merger of Bergen Brunswig with AmeriSource in 2001.
ConocoPhillips – No data for 2000. ConocoPhillips was created by the merger of Conco Inc. with Phillips Petroleum Company in 2002.
Google – No data for 2000. Google’s initial public offering was held August 19, 2004.
Kraft – No data for 2000. Kraft was purchased by Philip Morris in 2000, at which point it was merged with Nabisco Holdings. In 2007 Kraft once again became an independent publicly held company.
News Corp. – No data for 2000. News Corp. was initially incorporated in South Australia until 2004, when it re-incorporated under Delaware General Corporation Law.
Sears – No data for 2000. Sears was purchased by and merged with Kmart Holdings Corporation in 2005.
Sprint Nextel – No data for 2000. Sprint Nextel was created by the merger of Sprint with NEXTEL in 2005.
Time Warner – No data for 2000. Time Warner was purchased by and merged with AOL in 2000.
WellPoint – No data for 2000. WellPoint as it currently exists was created by the merger of WellPoint Health Networks, Inc. with Anthem, Inc. in 2004.
Additional detail: companies that did not disaggregate CCE from short-term investment in one or more years:
Caterpillar (2012, 2006, 2000) – Caterpillar includes short-term investments in calculating its cash and cash equivalents disclosure. A separate short-term investments figure is unavailable.
International Paper (2012, 2006, and 2000) – International Paper includes short-term investments in calculating its cash and cash equivalents disclosure. A separate short-term investments figure is unavailable.
Kroger (2006) – Kroger includes short-term investments in calculating its cash and cash equivalents disclosure. A separate short-term investments figure is unavailable.
Target (2012) – Target includes short-term investments in calculating its cash and cash equivalents disclosure. A separate short-term investments figure is unavailable.
Valero (2012, 2006, and 2000) – Valero includes short-term investments in calculating its cash and cash equivalents disclosure. A separate short-term investments figure is unavailable.