S&P 100 Companies and Their Ticker Symbols
Companies Assigned to Groups
Symbol Name 1 AMGN
AA ALCOA 2 BMY
AAPL Apple Inc 3 CSCO
ABT Abbott Laboratories 4 EMC
AEP American Electric Power Co. 5 GILD
ALL Allstate Corp 6 MDT
AMGN Amgen Inc. 7 MO
AMZN Amazon.com 8 NSC
AVP Avon Products Inc 9 SLB
AXP American Express Inc 10 UNH
BA Boeing Co 11 UTX
BAC Bank of America Corp 12 WMB
BAX Baxter International Inc
BHI Baker Hughes Backup Companies (if needed)
BK Bank of New York 13 ABT
BMY Bristol-Myers Squibb 14 DVN
BRK.B Berkshire Hathaway 15 MET
CAT Caterpillar Inc 16 SO
C Citigroup Inc
P-1 Part I - Setup: The instructor will assign your team a company from
CL Colgate-Palmolive Co
companies (see http://www.sba.oakland.edu/Faculty/doane/downlo
CMCSA Comcast Corporation
complete list). Obtain the most recent annual time series data from
COF Capital One Financial Corp sales revenue, net income, EPS). If you are more ambitious, use quart
COP ConocoPhillips annual data. Also, obtain daily stock price data for your company from
COST Costco (for as many months as you wish). Part II
CPB Campbell Soup Company and its main products and services. (b) Describe the general pattern i
CSCO Cisco Systems the underlying forces of causation (e.g., changing conditions of supply
CVS CVS Caremark competitors, substitutes, innovations). (c) Fit several trends (e.g., line
CVX Chevron exponential) using Excel or MegaStat. (d) Interpret each fitted trend e
DD DuPont their R2 statistics. (e) Use the fitted equations to make numerical fore
DELL Dell stock price. Plot your forecasts (3 years if annual data,
DIS The Walt Disney Company daily data). Bottom line: Which trend model is best? Do the trend mo
DOW Dow Chemical
DVN Devon Energy
EMC EMC Corporation
ETR Entergy
EXC Exelon
F Ford Motor
FCX Freeport-McMoran
FDX FedEx
GD General Dynamics
GE General Electric Co.
GILD Gilead
GOOG Google Inc.
GS Goldman Sachs
HAL Halliburton
HD Home Depot
HNZ H. J. Heinz Company
HON Honeywell
HPQ Hewlett Packard Co
IBM International Business Machines
INTC Intel Corporation
JNJ Johnson & Johnson Inc
JPM JP Morgan Chase & Co
KFT Kraft Foods Inc
KO The Coca-Cola Company
LMT Lockheed-Martin
LOW Lowe's
MA Mastercard Inc
MCD McDonald's Corp
MDT Medtronic Inc.
MET Metlife Inc.
MMM 3M Company
MO Altria Group
MON Monsanto
MRK Merck & Co.
MS Morgan Stanley
MSFT Microsoft
NKE Nike
NOV National Oilwell Varco Inc
NSC Norfolk Southern Corp
NWSA News Corp.
NYX NYSE Euronext
ORCL Oracle Corporation
OXY Occidental Petroleum Corp
PEP Pepsico Inc
PFE Pfizer Inc
PG Procter & Gamble Co
PM Phillip Morris International
QCOM Qualcomm Inc
RF Regions Financial
RTN Raytheon Co (NEW)
S Sprint Nextel Corp
SLB Schlumberger
SLE Sara Lee Corporation
SO Southern Company
T AT&T Inc
TGT Target Corp
TWX Time Warner Inc
TXN Texas Instruments
UNH UnitedHealth Group Inc
UPS United Parcel Service Inc
USB US Bancorp
UTX United Technologies Corp
VZ Verizon Communications Inc
WAG Walgreen's
WFC Wells Fargo
WMB Williams Companies
WMT Wal-Mart
WY Weyerhauser Co
XOM Exxon Mobil Corp
XRX Xerox Corp
Which Team?
Companies Assigned to Groups 10:40 Class 12:00 Class
Amgen Inc. 5 2
Bristol-Myers Squibb 12 8
Cisco Systems 9 9
EMC Corporation 10 6
Gilead 3 10
Medtronic Inc. 4 3
Altria Group 8 5
Norfolk Southern Corp 6 4
Schlumberger 1 7
UnitedHealth Group Inc 11 1
United Technologies Corp 7 12
Williams Companies 2 11
Backup Companies (if needed)
Abbott Laboratories
Devon Energy
Metlife Inc.
Southern Company
instructor will assign your team a company from the list of S&P 100
/www.sba.oakland.edu/Faculty/doane/downloads.htm for the
the most recent annual time series data from Mergent OnLine (e.g.,
ome, EPS). If you are more ambitious, use quarterly data instead of
ain daily stock price data for your company from finance.yahoo.com
as you wish). Part II - Analysis: (a) Briefly describe the company’s history
and services. (b) Describe the general pattern in the data, and discuss
of causation (e.g., changing conditions of supply and demand,
tes, innovations). (c) Fit several trends (e.g., linear, quadratic,
cel or MegaStat. (d) Interpret each fitted trend equation and compare
Use the fitted equations to make numerical forecasts for revenue and
forecasts (3 years if annual data, 4 quarters if quarterly data, 5 days if
Which trend model is best? Do the trend models yield credible