HomeMy WebLinkAboutCOM 0070.010 1998-2000 >s. D . cheBank Research �., 9rr Re s ah � °
Dr. Edward Yardeni, Chief Economist Marisol Myung, Research Associate
Phone: (212) 469 -5715 Phone: (212) 469 -5078
Fax: (212) 469-5725 Fax: (212) 469 -5725
E -Mail: yardeni@yardeni.com E -Mail: myung @yardeni.com
Web Site: http: / /www.yardeni.com/
December 8, 1998
. .t RECEIVEO'W- #31
1 -- - --
Date - - - - ab `l . .,c
County Councll1 P -44S 4 "EbC
THE Y2K REPORTER
•
Y2K Disclosure
S &P 500 Companies
Lots of Laggards
Third Quarter 1998
See also Year 2000 Recession?
www.yardent.com/y2kbook.html
Comm. No. 70. /
File
Ref To: Presented HS e O C
Ref. Date, JAN 15 1T J
0 0
No Full Monty Yet. Corporate managers have yet to perform the Full Monty for
investors. As discussed in the previous issue of The Y2K Reporter, publicly traded
corporations continue to provide inadequate disclosure of their progress in fixing the Year
2000 Problem for investors. This is despite the Securities and Exchange Commission
(SEC) July 1998 Interpretative Memo, which strongly advised them to provide much more
information on the subject. I continue to sift through the mostly useless verbiage in the
quarterly (10Q) and annual (10K) reports filed by corporations with the SEC for the any
worthwhile nuggets of information.' I provided excerpts of some of them in the previous
Reporter.
Slow Progress. In this study, I examine corporate progress by studying Y2K budget data
available in some of the third quarter filings. Only 315 of the 415 S &P 500 companies
currently showing a third quarter report on the SEC's Edgar database, detail the total
estimated cost of the Y2K project and also how much has been spent so far. Clearly, many
companies simply ignored the SEC's request that all corporations provide this
information.'
The following charts and tables detail the percentage of Y2K budgets that have been spent
as of the third quarter for the companies reporting this information. I believe that there
must be a good direct correlation between the percentage of budget spent and progress in
Y2K remediation. If this assumption is correct, then many companies have a great deal of
work to do in a very short period of time before the Y2K "dreadline."
Indeed, all told, the companies in my sample collectively have spent only 42% of their
budgets as of the end of the third quarter. Though not strictly comparable, the US
government seems to be making more progress than American corporations. According to
the latest progress report from the Office of Management and Budget, 61% of mission -
critical systems were fixed by the federal agencies as of mid - November 1998.'
Why do companies have so much of their budgets to spend during the final three months
of 1998 and all of 1999? Many information technology experts believe that the toughest,
and most time - consuming part of the Y2K remediation process may be the final phase,
namely, end -to -end regression testing.
Lots Of Laggards. Here are some additional conclusions based on the data presented in
the following charts and tables.
1) On average, the S &P 500 industry that is at the top of the spending -to- budget
progress list is the financial sector, with a ratio of 53.3 %. It is followed by capital
The SEC July 1998 memo is at http: / /www. sec .gov /rules /concept/33- 7558.htm
2 The Y2K Reporter #30, "Y2K Disclosure Statements, S &P 500 Companies Overview, Third Quarter
1998," November 30, 1998. http:// www .yardeni.com /y2kreporter.html
The SEC Edgar database can be found at http: / /www.sec.gov /edgarhp.htm
4 The federal agency progress reports are compiled by the Office of Management and Budget, and can be
found at http: / /cio.gov /2000.htm
Page 2 / December 8, 1998 / Deutsche Bank Research The Y2K Reporter
0 0
goods (45.6 %), health care (42.2 %), consumer cyclicals (41.8 %), consumer staples
(41.5 %), transports (40.0 %), energy (39.9 %), technology (36.9 %), basic materials
(36.0 %), communications (35.3 %), and utilities (31.4 %). Utilities are at the bottom of
the list of S &P industry sectors! If they don't work, nothing else will.
2) No industry is uniformly ahead of the others. There are laggards in every major
industry. Even in the leading financial sector, 36% of the sample has spent less than
half of their Y2K budget through the third quarter of 1998.
3) There are a disturbing number of laggards. Fully 33% of the companies I surveyed
spent less than one -third of their budgets so far. And 14% of the companies spent less
than 20% of their projected Y2K budget through the third quarter of 1998.
4) Only 8 companies claim that they are nearly finished, having spending -to- budget ratios
of 80% or more.
5) In the utility sector, only five of the 34 companies in my survey claim to have spent
more than 50% of their budget. And 10 of these have spent less than 20 %! Near the
bottom of the list are Niagara Mohawk Power (12 %), Sonat (13 %), and
Consolidated Natural Gas (15 %). Among the telephone companies, MCI
Worldcom seems to be significantly behind with a 30.2% reading compared to 42.2%
for AT &T, 47.8% for GTE. Bell Atlantic is also lagging with a 31.8% score.
6) In the energy sector, Chevron is second from the bottom with a shockingly low
13.3 %. Merger partners Exxon and Mobil are right next to each other with in -the-
middle readings of 47.3% and 49.6 %, respectively. In basic materials, Union Carbide,
is fourth from the bottom of the list with 11.7 %.
7) In capital goods, Boeing, which just announced a major cutback in employment and
production, is second from the bottom of the list with only 15.2 %. In the technology
sector, Motorola, which may have sold lots of noncompliant products over the years,
is only 20.6 %. Intel is surprisingly low at 14.0 %.
8) In the health care sector, Pfizer is at only 23 %, well below Eli Lilly's (55 %),
Schering- Plough (60 %), and Pharmacia & Upjohn (66.7 %).
Hedge Clause. Use the following information with caution. Companies that have spent
most of their projected budgets are most likely to be Year 2000 compliant. However, keep
in mind that most, if not all Y2K disclosure is self - reported; it is not independently
verified, audited, or certified. Also, please read the entire Y2K disclosure statement before
jumping to any conclusions from the following data. You are likely to find that companies
that rank highly in the following spending progress tables are also very worried about the
readiness of their key vendors. In other words, even compliant companies could suffer
greatly in 2000 if plausible worst -case scenarios unfold.
Page 3 / December 8, 1998 / Deutsche Bank Research The Y2K Reporter
0
Should ,you sell the stocks you own of companies near the bottom of the spending
progress tables? That's up to yott. Some companies may be overestimating the total cost
of their project. Such liberal budgeting would indicate that management is actually taking
the problem seriously and committing more than enough money to fix the problem. Some
companies reported Y2K budget ranges. The top of the range was used for this study.
Nevertheless, if you own some of the spending laggards, you probably should spend some
time reading the Y2K disclosure statements in all their SEC filings since the beginning of
1998.
One last warning: Reading through so many disclosure reports to find the data for this
study was not much fun. There could be errors. The data was double- checked, but you
may want to check it again for specific companies you are concerned about. If you do start
doing some heavy sifting, please pass along any interesting findings.
Index of Exhibits:
1: Percent of Y2K Budget Spent by all S &P companies
2: Percent of Y2K Budget Spent by all S &P financial companies
3: S &P 500 Companies: Disclosed Y2K Costs
4: S &P Financials
5 S &P Utilities
6: S &P Communications Services
7: S &P Energy
8: S &P Technology
9: S &P Basic Materials
10: S &P Transports
11: S &P Capital Goods
12: S &P Health Care
13: S &P Consumer Staples
14: S &P Consumer Cyclicals
15: A -Z S &P 500 Companies: Disclosed Y2K Costs
5 My Y2K Disclosure Database for the S &P 500 includes all the Y2K disclosure statements since the start
of 1998. See http: / /www.progsys.com /yardeni /y2kfind.asp
Page 4 / December 8, 1998 / Deutsche Bank Research The Y2K Reporter
0 0
Exhibit 1: Percent of Y2K Budget Spent by all S&P 500 companies
60
•
•
50 — •
•
•. '5=
4 , ^,,
as 40-
0
0 • ..; -;;
a0 —
fr a
3
1 t . • 11/ :;")';'"
1 ; :14. tE; ;C■ltY".•
0% 10%- 20%- 30%- 40%- 50%- 60%- 70%- 80%- 90%-
9% 19% 29% 39% 49% 59% 69% 79% 89% 100%
*315 reported both total costs and costs-to-date as of December 3, 1998 for 1998 Q3
Exhibit 2: Percent of Y2K Budget Spent by all S&P financial companies
14
•
12 — •
(- !.•;;;;4,
a 10 —
E
E 8 —
, IS :2 ■ I I ' 4: 4. ; .7;4 ■
2 —
0% 10%- 20%- 30%- 40%- 50%- 60%- 70%- 80%- 90%-
9% 19% 29% 39% 49% 59% 69% 79% 89% 100%
*55 reported both total costs and costs-to-date as of December 3, 1998 for 1998 Q3
•
Page 5/ December 8, 1998 / Deutsche Rank Research The Y2K Reporter
0 0
Exhibit 3: S &P 500 Companies: Disclosed Y2K Costs (1998 Q3) ,
COMPANY TOTAL COST COST TO DATE PERCENTAGE
(E million) is million) SPENT
GANNETT CO. (GCI) 250 225 900
PROGRESSIVE CORP. (PGR) 11.8 10.6 89.8
KERR -MCGEE (KMG) 45.0 38.0 84 4
W R WRIGLEY (WW{) 15.0 12.5 83.3
RUSSELL CORP. (RML) 1.8 1.5 83 1
V.F. CORP. (VFC) 25.0 20.0 80.0
VIACOM INC. (VIA B) 25.0 20.0 80 0
REPUBLIC NEW YORK (RNB) 60.0 47.3 78.8
CAPITAL ONE FINANCIAL (CF) 6.0 4.7 78.3
REYNOLDS METALS (RLM) 18.0 14.0 77.8
WASHINGTON MUTUAL, INC. (WAMU) 49.9 38.7 77.6
OWENS CORNING (OM) 185.0 143 0 77.3
PROVIDENT INSURANCE (PVT) 8.3 8.4 77.1
CINERGY CORP. (CIN) 13.0 10.0 76.9
COOPER INDUSTRIES (CBE) 75.0 56.3 75.0
INGERSOLL-RAND (IR) 60.0 45.0 75.0
COSTCO CO (COST) 0.0 0 0 75.0
NEWELL CO (NWL) 16.0 12.0 75.0
TORCHMARK CORP. (TMK) 6.0 4.5 750
WACHOVIA CORP. (WB) 80.0 60.0 75.0
CONSOLIDATED EDISON 27.0 20.0 74.1
MCDONALD'S (MCD) 30.0 22.0 73.3
KEY CORP. (KEY) 54.0 39.0 72.2
CINCINNATI FINANCIAL 9 5 6.8 71.6
MANN -DIXIE (WIN) 15.0 10.7 71.3
TUPPERWARE CORP. (TUP) 4.8 3.4 70 8
ENGELHARD CORP. (EC) 14.2 9.9 69 7
J.P. MORGAN (JPM) 300 0 207.0 69.0
SEMPRA ENERGY (SRE) 48 I) 330 68.8
XEROX CORP (XRX) 85.0 58.0 68.2
ASSOCIATES FIRST CAPITAL (AFS) 22.0 15.0 68.2
SCIENTIFIC - ATLANTA (SEA) 2.5 1.7 68 0
GENERAL ELECTRIC (GE) 550.0 366 7 66.7
CORNING INC. (GLV1/) 21.0 14.0 66.7
REEBOK INTERNATIONAL (RBK) 75.0 50.0 66 7
PHARMACIA B UPJOHN (PNU) 150.0 100.0 66.7
UNISYS CORP. (UIS) 15 0 10.0 86.7
SLM HOLDINGS CORP (SLM) 12,0 8.0 86.7
CATERPILLAR INC. (CAT) 130.0 88.7 66.7
EATON CORP. (ETN) 950 63.3 68.6
LOEWS CORP (LTR) 80 0 53 0 66 3
EASTERN ENTERPRISES (EFU) 15.0 9.9 66
SUN TRUST BANKS (STI) 45.0 29 6 65.8
CHASE MANHATTAN (CMB) 363.0 236.0 65 0
LIZ CLAIBORNE (LIZ) 60.0 39.0 65.0
MELLON BANK (MEL) 95.0 61 8 65.0
BANK AMERICA CORP. (BAC) 550 0 353.0 64.2
DUN 8 BRADSTREET (DNB) 5.3 3.4 64.2
SUPERVALU INC. (SVU) 26.3 16.8 83.9
IMS HEALTH INC. (RX) 70.0 43.9 62.7
MATTEL (MAT) 8.0 5 0 62.5
JOSTENS INC. (JOS) 50.0 30.8 61.8
CITIGROUP (CCI) 650.0 400.0 61.5
ALLEGHENY TELEDYNE INC. (ALT) 18.0 11.0 61.1
AMR CORP. (AMR) 250.0 152.0 60.8
BANC ONE CORP. (ONE) 190.0 115 4 60.7
NACCO (NC) 5.3 3.2 60.4
CONSECO INC. (CNC) 67.0 40.2 60.0
DPW CHEMICAL (DOW) 500 30.0 60.0
ECOLAB INC. (ECL) 5.0 3.0 60.0
Page 6 / December 8, 1998 / Deutsche Bank Research The Y2K Reporter
I
• ^ WE -n I a
O 0
•
Sl yl, 5 ,
•
Exhibit 3: sitiP 500 Companies: Disclosed Y2K Costs (gontinued))
COMPANY TOTAL COST COST TO DATE PERCENTAGE
(S million) (5 million) SPENT
ITT INDUSTRIES, INC. (IIN) 20.0 12.0 60.0
KELLOGG CO. (K) 70.0 42 0 60 0
•
BURLINGTON RESOURCES (BR) 5.0 3.0 60.0
SCHERING - PLOUGH (SGP) 1 500 30.0 60.0
FRONTIER CORP. (FRO) . 1 12.0 7.2 60.0
MERRILL LYNCH (MER) 400.0 240.0 60.0
PNC BANK (PNC) 30.0 18.0 60.0
PROVIDIAN FINANCIAL (PVN) 10.0 6.0 60 0
SAFECO CORP. (SAFC) 17.0 10.0 58.8
ASCEND COMMUNICATIONS (ASND) 19.0 11 0 57.9
TEXTRON INC. (TXT) t 1250 72.0 57.6
EASTMAN KODAK (EK) 58.0 33.3 57.4
COLUMBIA/HCA HEALTHCARE (COL) 75.0 43.0 57 3
CLOROX CO. (CLX) 46 9 26.7 57.0
AMERICAN GENERAL (AGC) 93.0 53.0 57.0
AMERICAN EXPRESS (AXP) 546.0 311.0 57.0
FORTUNE BRANDS, INC. (FO) 25.0 14.0 56 0
ATLANTIC RICHFIELD (ARC) 25.0 14 0 56.0
TEXAS INSTRUMENTS (TXN) 90.0 50.0 55.6
HERSHEY FOODS (HSY) 98 0 54.3 55.4
WENDY•S INTERNATIONAL (WEN) 4 0 2.2 55 0
ELI LILLY (LLY) 190.0 104.5 55.0
HOUSEHOLD INTERNATIONAL (HI) 200 11.0 550
MINN. MINING & MFG. (MMM) 75.0 41.0 54 7
BANKERS TRUST N Y. (BT) 260 0 141.0 54.2
DUKE ENERGY (DUK) 65.0 35.0 53.8
NORTHERN TRUST CORP (NTRS) 35.0 18.7 53.4
AMOCO (AN) 155.0 82.0 52.9
AVON PRODUCTS (AVP) 23.5 12 4 52.8
BANK OF NEW YORK (BK) 820 43.0 52.4
MONSANTO (MTC) 25.0 13.0 52 0
SAFEWAY (SWY) 25.0 13.0 520
CIRCUIT CITY GROUP (CC) 16.4 8.5 51.8
GOODRICH (B.F ) (GR) 45.0 23.0 51.1
AON CORP. (AOC) 65 0 33 0 50.8
BB&T CORP. (BBK) 30.0 15.2 50.7
WELLS FARGO & CO. (WFC) 300.0 151.0 50.3
LEHMAN BROTHERS HOLDINGS (LEH) 76.5 38.5 50 3
HOMESAKE MINING (HM) 1.5 0 8 50.0
ROHM & HMS (ROH) 16 0 8.0 50.0
WORTHINGTON INDUSTRIES (WrHG) 2.0 1.0 50.0
HONEYWELL (HON) 60.0 30.0 50.0
ILLINOIS TOOL WORKS (ITWO 300 15.0 50.0
THOMAS & BETTS (TNB) 2 0 1.0 50.0
DOWJONES &CO(DOW 20.0 10.0 500
MASCO CORP (MAS) 15.0 75
50.0
MAYTAG (MYG) 20.0 10.0 50.0
CVS CORP. (CVS) 7 3.5 50.0
SARA LEE CORP. (SLE) 50.0 25.0 50.0
TIME WARNER INC. (TWX) 175.0 87.5 50.0
WALGREEN CO (WAG) 100 5.0 50.0
SUN CO., INC. (SUN) 36.0 18 0
50.0
BAXTER INTERNATIONAL INC. (BAX) 130 0 65.0 50.0
HUMANA INC. (HUM) 24.0 12.0 50.0
PAYCHEX INC. (PAYX) 5.0 2.5 50.0
ALLTEL CORP. (AT) 80.0 40 0 50.0
UNION PACIFIC (UNP) 61.0 30.5 50.0
MBNA (KRB) 40.0 20 0 50.0
MOBIL CORP (MOB) 490.0 243.0 496
MORGAN STANLEY DEAN WTTER (MWD) 237.5 117.0 49.3
PULTE CORP (PI-1M) 0 0.0 48 8
Page 7 / December 8, 1998 1 Deutsche Bank Research The Y2K Reporter
0 O
•
Exhibit 3: S&P 500 Companies: Disclosed Y2K Costs (continued)
COMPANY TOTAL COST COST TO DATE PERCENTAGE
1S million) (S million) SPENT
PACCAR CORP.(PCAR) 25.0 12.0 48.0
JOHNSON & JOHNSON (JNJ) 250.0 120.0 48.0
GTE CORP. (GTE) 370.0 177.0 47.8
PITNEY -BOWES (PBI) 480 22.0 47.8
SPRINGS INDUSTRIES INC (SMI) 18.0 8.6 47.8
DELUXE CORP. (DLX) 26.5 12.6 47.5
RYDER SYSTEM (R) 38.0 18 0 47 4
ALLIED SIGNAL (ACID) 150.0 71.0 47.3
FLEET FINANCIAL GROUP (FLT) 150.0 71.0 47 3
EXXON CORP (XON) 275 0 130.0 47.3
COASTAL CORP (CGP) 17.0 8.0 47.1
SEARS, ROEBUCK & CO. (5) 143.0 67.0 46.9
WFIIRLPOOL CORP. (WHR) 30.0 14.0 46 7
TEXACO INC. (TX) 75.0 35.0 46.7
ROWAN COS. (RDC) 2 8 1.3 46.4
NIKE INC. (NKE) 50.0 23.0 46.0
COORS (ADOLPH) (ACCOB) 35.0 16.0 45.7
PHILIP MORRIS (MO) 550.0 250 0 45.5
CHARLES SCHWAB (SCH) 75.0 34.0 45 3
BAKER HUGHES (BHP 45.0 20.0 44 4
COUNTRY WIDE CREDIT INDUSTRIES (CCR) 36 0 18.0 44.4
FIRST ENERGY CORP (FE) 111.0 49.0 44.1
PPG INDUSTRIES (PPG) 25.0 11.0 44.0
EQUIFAX INC. (EFX) ' 48.0 21.0 43.8
BEAR STERNS COMPANIES (BSC) 60 0 26.1 43.5
HARRIS CORP (HRS) 46 0 20.0 43.5
BARD (C.R.) INC. (BCR) 8 3 36 43.4
CIGNA CORP. (CI) 150.0 65.0 433
CRANE COMPANY (CR) 26.9 11.6 43.1
HCR MANOR CARE (HCR) 35.0 15.0 42.9
FPL GROUP (FPL) 70.0 30.0 42 9
NORTHERN STATES POWER (NSP) 24 5 10.5 42.9
AT&T CORP. (T) 711 0 300.0 42.2
ASARCO INC. (AR) 3.1 1.3 41 9
PHILLIPS PETROLEUM (P) 63 0 26.0 41.3
ARMSTRONG WORLD (ACK) 17.0 7.0 41
TRANSAMERICA CORP. (TA) 35 0 14 4 41.1
REGIONS FINANCIAL CORP (RGBK) 20.0 8.2 41.0
FIRST DATA (FDC) 203.0 83.0 40.9
JEFFERSON -PILOT (JP) 26.0 10.5 40.4
FDX HOLDING CORP. (FDX) 142.0 570 40.1
CHAMPION INTERNATIONAL (CHA) 200 8.0 400
HERCULES INC. (HPC) 8 4 3.4 40 0
CUMMINS ENGINE CO. INC. (CUM) 45.0 18.0 40.0
FOSTER WHEELER (FVVC) 10.0 4.0 40 0
OWENS- ILLINOIS (01) 50.0 20.0 40.0
BRUNSWICK CORP (BC) 15.0 60 40.0
• HASBRO INC. (HAS) 0.0 0 0 40.0
DARDEN RESTAURANTS (DRI) 50 2.0 40.0
UST INC. (UST) 20.0 8.0 40.0
UNION PACIFIC RESOURCES (UPR) 2.5 1.0 40.0
PP &L RESOURCES (PPL) 15 0 6.0 40.0
UNITED HEALTHCARE CORP. (UNH) 79.0 31.0 39.2
NATIONAL CITY CORP. (NCC) 65.0 25.0 38.5
MALLINCKRODT INC. (MKG) 21.0 8.0 38
CSX CORP. (CSX) 86.8 33.0 38 0
CASE CORP. (CSE) 50.0 19.0 38.0
MCDERMOTT INTERNATIONAL (MDR) 37.0 14.0 37.8
INTERNATIONAL FLAV /FRAG (IFF) 45.0 17.0 37.8
RJB NABISCO HOLDINGS CORP. (RN) 90.0 34 0 37.8
Page 8 / December 8, 1998 / Deutsche Bank Research The Y2K Reporter
•
0 0
Exhibit 3: S &P 500 Companies: Disclosed Y2K Costs (continued)
COMPANY TOTAL COST COST TO DATE PERCENTAGE
(S million) IS million) SPENT
COCA COLA CO. (KO) 160.0 60 0 37.5
DONNELLEY (R R.) 8 SONS (DNY) 80.0 30.0 37.5
SOUTHWEST AIRLINES(LUV) 21.1 7.9 • 37.4
MERCANTILE BANCORP (MTL) 30.0 11.2 37.4
ANHEUSER -BUSCH (BUD) 42.8 15.8 38.9
USX - U.S .STEEL GROUP (X) 25.0 9.0 360
TRIBUNE CO. (TRB) 25.0 9.0 360
CENDANT CORP. (CD) 53.0 19.0 35.8
BALTIMORE GAS 8 ELECTRIC (BGE) 42.0 15.0 35.7
SBC COMMUNICATIONS (SBC) 250.0 89.0 35.6
GOODYEAR TIRE 8 RUBBER (GT) 130.0 46.0 35 4
TRICON GLOBAL RESTAURANT (YUM) 65.0 23.0 35.4
ARMCO INC. (AS) 17.0 6.0 35.3
TEMPLE - INLAND (TIN) 12.8 4.5 35.2
DU PONT (E I.) (DD) 400 0 140.0 35.0
UNION CAMP (UCC) 20 0 7 0 35.0
WILLAMETTE INDUSTRIES (WLL) 10.0 3.5 350
AMP INC. (AMP) 400 14.0 35.0
KAUFMAN AND BROAD HOME CORP (KBH) 4.0 1 4 35.0
GENERAL RE CORP (GRN) 20.0 7.0 35.0
CENTRAL 8 SOUTH WEST (CSR) 61.0 21.3 34.8
FORT JAMES CORP (FJ) 95.0 33.0 34 7
AMERICAN GREETINGS (AM) 35.0 12.0 34.3
SOUTHERN CO. (SO) 114 0 39.0 34 2
SUMMIT BANCORP (SUB) 230 78 33.9
KIMBERLY CLARK (KMB) 80.0 27.0 33.8
TANDY CORP (TAN) 14.0 4.7 33 6
KROGER (KR) 32 1 10.7 33.3
AMERADA HESS (AHC) 15.0 5.0 33.3
COMPAQ COMPUTER (CPQ) 120.0 40.0 33.3
BELL ATLANTIC (BEL) 550 0 175.0 31.8
SHERWIN- WILLIAMS (SHIN) 35.0 11 0 31 4
COCA COLA ENTERPRISES (CCE) 45.0 14.0 31.1
HALLIBURTON CO. (HAL) 65.0 20.0 30 8
PG 8 E CORP. (PCG) 260.0 80.0 30.8
CBS CORP. (CBS) 360 11.0 306
MCI WORLDCOM (WCOM) 3840 1160 30.2
NATIONAL SERVICE IND (NSI) 5.0 1 5 300
COLGATE PALMOLIVE (CL) 30.0 9.0 300
PACIFICORP (PPVh 30 0 8.9 29.7
FORD MOTOR (F) 375.0 110.0 29.3
DANA CORP. (DCN) 116.0 34 0 29.3
FIRST UNION CORP. (FTU) 650 190 292
CARDINAL HEALTH INC. (CAH) 24.0 7 0 29.2
CLEAR CHANNEL COMMUNICATION (CCU) 12 0.4 292
CHUBB CORP. (CB) 24.0 7.0 29.2
PUBLIC SERV. ENTERPRISE (PEG) 920 26.8 29.1
MBIA(MBI) 1.1 0.3 28.8
UNITED TECHNOLOGIES (UTX) 195.0 55.0 28 2
CAMPBELL SOUP (CPB) 50.0 14 0 28.0
COMPUTER SCIENCES CORP. (CSC) 61.0 17.0 27 9
CYPRUS AMAX MINERALS CO. (CYM) 29.0 8 0 27.6
QUAKER OATS (OAT) 15.0 4.0 26.7
BAUSCH & LOMB (BOL) 75.0 20.0 26.7
FRUIT OF THE LOOM (FTL) 16 6 4.4 26.5
GOLDEN WEST FINANCIAL (GDW) 19.0 5.0 26.3
US AIRWAYS GROUP INC. (U) 8.0 2 1 26 3
RAYTHEON CO. (RTN 8) 180.0 47.0 28.1
, ALCAN ALUMINUM (AL) 50.0 13.0 26 0
Page 9 / December 8, 1998 / Deutsche Bank Research The Y2K Reporter
0 0
Exhibit 3: S &P 500 Companies: Disclosed Y2K Costs (continued)
COMPANY TOTAL COST COST TO DATE PERCENTAGE
($ million) is million) SPENT
MCGRAW -HILL (MHP) 24.0 6.0 25.0
ELECTRONIC DATA SYSTEMS (EDS) 80.0 20 0 25.0
EDISON INTL. (EIX) 80.0 20 0 25.0
RIGOR INC (GAS) 12.0 3.0 25.0
KNIGHT - RIDDER INC (KRI) 80.0 19.3 24.1
CAROLINA POWER 8 LIGHT (CPL) 17.0 4.0 23.5
TEXAS UTILITIES HLDG. COS. (TXU) 73 1 17.1 23.4
MIRAGE RESORTS (MIR) 30 0 7.0 23.3
TENET HEALTHCARE CORP (THC) 73.0 17.0 23 3
PFIZER (PFE) 100 0 23.0 23 0
AMERITECH (AIT) 252.0 57.0 22.6
GENERAL MOTORS (GM) 5855 131.5 225
AMERICAN ELECTRIC POWER (AEP) 68.0 15.0 22.1
WEYERHAEUSER CORP. (WY) 100.0 220 22.0
GEORGIA - PACIFIC GROUP (GP) 80.0 17.5 21.9
PEPSI CO INC. (PEP) 130.0 28.0 21 5
USX - MARATHON GROUP(MRO) 28.0 6.0 21.4
AIRTOUCH COMMUNICATIONS (ATI) 75 0 16 0 21.3
UNICOM CORP. (UCM) 60.0 12.7 21.2
STANLEY WORKS (SWK) 120.0 25.0 20.8
SYNOVUS FINANCIAL (SNV) 140 2.9 20.7
TRW INC. (TRW) 150.0 31.0 20.7
MOTOROLA (MOT) 340.0 70.0 20.6
NEW CENTURY ENERGIES (NCE) 400 8.1 203
GREAT LAKES CHEMICAL (GLK) 20 0 4.0 20.0
LOUSIANA PACIFIC (LPX) 5.0 1 0 200
PIONEER HI -BRED (PHB) 5.0 1.0 20.0
CROWN CORK 8 SEAL (CCK) 30 0 6.0 20.0
GENUINE PARTS (GPC) 10.0 2.0 200
COMCAST CLASS A SPECIAL (CMCSK) 25.0 5.0 200
BURLINGTON NORTHERN SANT (BNI) 20.0 4.0 20.0
WILLIAMS CO. (WMB) 50.0 10.0 20.0
CERIDIAN CORP. (CEN) 52 0 10.0 19.2
ENTERGY CORP. (ETR) 81.0 15.0 18.5
HARRAH'S ENTERTAINMENT (HET) 12.5 2.3 78 4
GREAT A 8 P (GAP) 10.0 1.8 18.0
MEAD CORP (MEA) 45.0 8.0 17.8
GATEWAY INC. (GTW) 160 2.8 17.5
DTE ENERGY CO. (DTE) 75.0 13.0 17.3
SIGMA - ALDRICH (SIAL) 30 0.5 167
MILLIPORE CORP (MIL) 0.0 0.0 16.7
ORYX ENERGY CO. (ORX) 6.0 1.0 16 7
MEREDITH CORP (MDP) 5.0 0.8 16.0
POLAROID (PRD) 25.0 4.0 16.0
DOMINION RESOURCES (D) 55.0 8.5 155
BOEING COMPANY (BA) 105 0 16 0 15 2
CONSOLIDATED NATURAL GAS (CNG) 22.6 3.4 15.0
HOUSTON INDUSTRIES(HOU) 400 60 150
LINCOLN NATIONAL (LNC) 74.2 11.0 14 8
UNOCAL CORP. (UCL) 35.0 5.0 14.3
ADVANCED MICRO DEVICES (AMD) 35.0 5.0 14.3
INTEL CORP (INTC) 250.0 35.0 14.0
LAIDLAW (LAW) 10 0 1.4 14 0
CHEVRON CORP. (CHV) 300.0 400 13.3
AMEREN CORP. (AEE) 15.0 2.0 13.3
HUNTINGTON BANCSHARES (HBAN) 33.3 4.4 13.2
SONAT INC. (SNT) 10.0 1.3
CONAGRA INC. (CAG) 13.0
80.0 10.0 12.5
NIAGARA MOHAWK POWER (NMK) 400 4.8
12.0
Page 10 / December 8, 1998 / Deutsche Bank Research The Y2K Reporter