Value Added, Employment, and Capital Expenditures of Nonbank U.S. Multinational Companies: 1982 to 2004 (Statistical Abstract 2008 Table 0771)

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns.
The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

1. A few files had extraneous characters in the title. These were
   corrected to be consistent. A few files have a sheet of crufty
   gibberish in the first slot. The sheet order was shuffled but no
   data were changed.

1. The first four files have been restructured to allow full
   comprehension of the table. If you’d like to help clean up the data
   follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

notes (pg 1)

1. Beginning with the revised 1999 benchmark
   estimates the source has expanded its estimates
   of the operations of U.S. multinational corporations in order to provide
   fuller coverage of the multinational corporation universe. In the past,
   the source data excluded estimates for very small foreign affiliates
   and for parents that had only very small foreign
   affiliates. Estimates for very small foreign affiliates
   were excluded because only very limited information
   was reported for them, and their inclusion would not
   have had a material impact on the aggregate direct investment
   estimates, in terms of value. Estimates for
   parents of only very small affiliates were excluded to
   maintain consistency between the parent and affiliate
   estimates. Estimates for these formerly excluded parents
   and affiliates are now included in the multinational corporation operations
   data in order to eliminate the small downward
   bias attributable to these exclusions.
   For very small affiliates, a few data items were required
   to be reported on a supplement to the 1999
   benchmark survey forms. In the revised benchmark es-
   timates for 1999 presented here, these data items were
   included in the published totals and were also used as
   the basis to estimate other items covered by the survey.
   In the 2000 annual estimates, the 1999 data were extrapolated
   based on the movement in the data for
   somewhat larger affiliates.
   The impact of the inclusion of the new estimates for
   very small affiliates on the published aggregate estimates
   is less significant for foreign affiliates than it is
   for U.S. parents. Overall, the values for very small affiliates
   are generally negligible, although they may be significant
   for a few data items or for a few individual
   host countries (particularly those that are less developed).
   For example, in 1999, very small majority-owned foreign affiiates accounted
   for 0.5 percent of the assets, 1.0 percent of the
   value added, 3.2 percent of the employment, and less
   than 0.1 percent of the capital expenditures of all
   majority-owned foreign affiiates. In India, the employment of very small affiliates
   accounted for a substantially larger share9.8
   percentof the employment of all majority-owned foreign affiiates in 1999.
   The values for parents of only very small affiliates,
   however, are more significant. Parents of only very
   small affiliates accounted for 1.6 percent of the assets,
   3.8 percent of the value added, 6.1 percent of the employment,
   and 2.7 percent of the capital expenditures
   of all nonbank U.S. parent companies in 1999. Thus,
   the addition of data for parents of only very small affiliates
   does affect the comparability of the 1999 and
   2000 data with data for earlier years for some data
   items for U.S. parents and for U.S. multinational corporations overall.

[Value added and capital expenditures in billions of dollars; employees in thousands.
Consists of non-bank U.S. parent companies and their non-bank foreign affiliates.
U.S. parent compromises the domestic operations of a multinational and is a U.S. person that owns or controls directly or
indirectly, 10 percent or more of the voting securities of an
incorporated foreign business enterprise, or an equivalent interest in
an unincorporated foreign business enterprise. A U.S. person can be an
incorporated business enterprise. A foreign affiliate is a foreign
business enterprise owned or controlled by a U.S. parent company.
A majority-owned foreign affiliate (MOFA) is a foreign business
enterprise in which a U.S. parent company owns or controls more than 50%
of the voting securities.
Minus sign (-) indicates decrease]

table: [73, 1]

notes (pg 1)

• (NA) Not available.

0771

2008