Sector Valuation - Fisher College of Business

Download Report

Transcript Sector Valuation - Fisher College of Business

Greg Price
Greg Shaskus
Min Shen
Matt Sims
Chris Stuart
Recommendation
 100 bps increase in SIM allocation for IT resulting in
227 bps overweight
Support:
 Sector Size and Composition
 Business Analysis
 Economic Analysis
 Financial Analysis
 Valuation Analysis
Sector Overview
 Largest Weight
 16 Industries
 Highly Cyclical
 Revenues up 8% last quarter
 EPS up 56% last quarter
Sector
Info Tech
Financials
Health Care
Cons Staples
Energy
Industrials
Cons Disc
Utilities
Materials
Telecom
Market Cap
(Millions)
$
1,966,161
$
1,742,608
$
1,223,100
$
1,167,036
$
1,148,905
$
1,122,994
$
1,100,889
$
367,268
$
355,185
$
288,242
Source: Standard and Poors
 Estimated 63% increase in earnings this quarter
SIM Sector Allocation
 Currently 127 Basis points overweight S&P 500
Sector
Percentage
Consumer Discretionary
4.00%
3.00%
2.00%
1.00%
0.00%
-1.00%
-2.00%
-3.00%
-4.00%
-5.00%
-6.00%
Series1
S&P 500
SIM
Weight Weight
10.55%
10.44%
+/-0.11%
Consumer Staples
10.91%
11.71%
0.80%
Energy
11.18%
9.76%
-1.43%
Financials
16.47%
11.41%
-5.07%
Health Care
11.55%
14.63%
3.07%
Industrials
10.76%
13.10%
2.34%
Info Tech.
18.91%
20.18%
1.27%
Materials
3.45%
1.64%
-1.82%
Telecom
2.73%
3.70%
0.98%
Utilities
3.48%
2.10%
-1.38%
CD
CS
Engy.
Fin.
HC
Ind.
IT
Mat.
Tel.
Util.
-0.11%
0.80%
-1.43%
-5.07%
3.07%
2.34%
1.27%
-1.82%
0.98%
-1.38%
Industries
 By Market Cap:
Rank
Industry
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Systems Software
Computer Hardware
IT Consulting
Internet Software
Communications Equipment
Semi-conductors
Services, Data
Computer Storage
Electronic Component
Office Electronics
Application Software
Semi-conductor Equipment
Electronic Equipment
Home Entertainment Soft.
Electronic Manufacturing
Technology Distribution
Market Cap
Holdings
(billions)
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
185.9
165.3
142.6
113.7
99.5
69.3
31.9
23.6
23.1
13.2
11.4
11.3
9.2
5.8
3.3
2.7
ORCL
HPQ, NCR
RIMM
INTC
Industry Performance
 By revenue growth:
Industry Performance
 By earnings per share growth:
Rank
Industry
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Semiconductor Equipment
IT Consulting
Communications Equipment
Services, Data
Computer Hardware
Office Electronics
Semiconductors
Electronic Manufacturing
Internet Software
Electronic Component
Electronic Equipment
Technology Distribution
Home Entertainment Soft.
Systems Software
Application Software
Computer Storage
Market Cap
EPS
Holdings
EPS est.
(billions)
(current)
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
11.3
142.6
99.5 RIMM
31.9
165.3 HPQ,NCR
13.2
69.3
INTC
3.3
113.7
23.1
9.2
2.7
5.8
185.9
ORCL
11.4
23.6
589%
350%
70%
69%
49%
48%
45%
39%
28%
21%
7%
7%
-6%
-12%
-17%
-41%
221%
173%
111%
313%
104%
80%
100%
7%
31%
19%
5%
65%
-12%
8%
158%
114%
Industries: Summary
 Attractive industries:






Semiconductor Equipment
Data Services
IT Consulting
Computer Hardware (HPQ, NCR)
Semiconductors (INTC)
Communications Equipment (RIMM)
 Industries to Avoid:




Home Entertainment Software
Systems Software (ORCL)
Electronic Equipment
Electronic Manufacturing
Largest Companies
 10 largest companies in S&P 500:
Constituent
Exxon Mobil Corp
Apple Inc.
Microsoft Corp
General Electric Co
Procter & Gamble
Johnson & Johnson
Bank of America Corp
Wells Fargo & Co
JP Morgan Chase & Co
Intl Business Machines Corp
Symbol
XOM
AAPL
MSFT
GE
PG
JNJ
BAC
WFC
JPM
IBM
Sector
Energy
Info. Tech.
Info. Tech.
Industrials
Consumer Staples
Health Care
Financials
Financials
Financials
Info. Tech.
Price ($)
65.23
253.99
28.93
18.04
62.42
64.75
17.3
32.97
41.95
126.27
Sector Performance
Price Returns by
Sector
Energy
Materials
Industrials
Cons Disc
Cons Staples
Health Care
Financials
Info Tech
Telecom
Utilities
MTD
QTD
YTD
-4.22%
-4.13%
-2.71%
-2.73%
-0.26%
-1.29%
-1.40%
-3.05%
-1.40%
-1.64%
0.02%
-3.74%
1.27%
3.13%
-1.81%
-5.14%
-0.12%
-1.34%
-2.78%
0.75%
0.11%
-1.42%
13.88%
13.49%
3.14%
-2.40%
10.69%
0.31%
-8.28%
-3.90%
YTD
Rank
6
7
1
2
4
8
3
5
10
9
Business Analysis
 Sector growth depends on
 Innovation
 Technological advancement
 Cost reduction
 Highly diverse with companies in growth and mature phases
 Few dominant players in each industry within the sector
 Dependence on cutting edge technology leads to enormous
R&D costs
 R&D spending is 2.5 times of the automotive industry and
more than 3 times of the pharmaceutical industry
 R&D costs largest barrier to entry
 Huge threat of substitutes and piracy
Business Analysis (cont.)
 Highly cyclical sector with large impact on SIM
 Tends to have large growth during market recoveries
 Can be highly volatile
 Affected by customer and corporate spending
 Signals point that both are increasing


Intel’s most recent earnings forecast signals a rebound in
corporate IT spending
The iPad sold over 1 million units in just 28 days
Business Analysis (cont.)
 Growth potential in the smart phone and tablet
market
 Apple, Google, and RIM dominate the market making
it difficult for other companies to be successful
 Increased competition will decrease prices and result
in lower margins
 Growth potential in India, China, and Africa
 As penetration rates approach 90% in developed
regions companies look for new opportunities
Business Analysis (cont.)
 Other growth opportunities
 Microsoft Office 2010 to be released in June
 IT Solution Services
 Risks of W-recession or
unstable recovery
 Last Thursday and Friday was a
perfect example


Tech stocks were hit hard
Many lost all of their gains for the
year
Business Analysis Summary
 Long-term
 IT growth opportunities outweigh risks
 Demand will continue to increase
 IT becoming a business staple with massive growth
potential
 Short-term
 Corporate spending/profits continue to increase
 GDP growth
Stovall’s guide to S&P
Sector Rotation
Stovall’s Sector Rotation
 IT generally does well where business is down,
unemployment is up, GDP is down, interest rates are falling
and consumer expectations are down.
 Fundamentals of companies can be influenced greatly by
the surrounding economy
 Business Cycle is used to understand the present position
of the cycle and to predict what areas of the economy will
be stronger in the future.
 Strategy is to buy into a sector that is about to take off and
sell at the peak.
Capital Spending V. IT Sector
Federal Funds Rate V. IT Sector
Velocity of Money V. IT Sector
Consumer Confidence V. IT Sector
Consumer Spending V. IT Sector
Employment V. IT Sector
Real GDP V. IT Sector
Market Pyramid
Railroad: Total International
Traffic
Revenue (Indexed)
150%
125%
100%
EBITDA Margin
30%
1.6
Sector
25%
1.4
1.2
20%
1.0
15%
0.8
0.6
10%
Relative to S&P 500
5%
0%
0.4
0.2
0.0
Absolute
Relative
High
26.5
1.4
Low
21.2
.8
Median
22.2
1.1
Current
26.5
1.4
Net Profit Margin
14%
2.0
Relative to S&P 500
1.8
13%
1.6
13%
1.4
12%
1.2
1.0
12%
Sector
11%
11%
10%
0.8
0.6
0.4
0.2
0.0
Absolute
Relative
High
12.9
1.9
Low
11.3
1.2
Median
11.8
1.4
Current
12.9
1.9
EPS Growth (yr over yr)
60%
50%
40%
Sector
30%
20%
10%
0%
-10%
-20%
Relative to S&P 500
-30%
(%)
Absolute
Relative
High
47.8
35.5
Low
-18.2
-33.9
Median
16.0
-
Current
.4
5.3
Return on Equity
25%
2.0
1.8
20%
15%
1.6
Sector
1.4
10%
Relative to S&P 500
5%
0%
1.2
1.0
0.8
Absolute
Relative
High
23.5
1.8
Low
18.7
.9
Median
19.5
1.3
Current
23.5
1.6
Financial Analysis
 Strong overall performance
 Growth potential within sector
 EPS projections
 Sector rotation
Sector Valuation: Info Tech (22 years)
Absolute Basis
High
Low
Median
Current
P/Trailing E
74.6
11.1
26.1
18.9
P/Forward E
64.7
12.1
22.5
14.4
P/B
15.1
2.3
4.1
3.7
P/S
6.7
0.8
2.5
2.4
P/CF
45.8
8.2
16.0
12.1
Green= Cheap
Red= Expensive
Sector Valuation: Info Tech (22 years)
Relative to
SP 500
High
Low
Median
Current
P/Trailing E
2.6
0.91
1.4
1.1
P/Forward E
2.7
0.98
1.3
1.0
P/B
3.0
0.9
1.4
1.7
P/S
3.0
0.9
1.7
2.0
P/CF
2.6
1.1
1.5
1.3
Green= Cheap
Red= Expensive
Sector Valuation: Info Tech (5 years)
Absolute Basis
High
Low
Median
Current
P/Trailing E
25.0
11.1
20.8
18.9
P/Forward E
22.4
12.1
18.9
14.4
P/B
4.8
2.3
3.9
3.7
P/S
3.0
1.3
2.5
2.4
P/CF
17.7
8.2
14.1
12.1
Green= Cheap
Red= Expensive
Sector Valuation: Info Tech (5 years)
Relative to
SP 500
High
Low
Median
Current
P/Trailing E
1.5
0.91
1.2
1.1
P/Forward E
1.4
0.98
1.3
1.0
P/B
1.8
1.2
1.5
1.7
P/S
2.1
1.5
1.7
2.0
P/CF
1.6
1.1
1.3
1.3
Green= Cheap
Red= Expensive
Industry Valuation:
Computer Hardware (HPQ, NCR)
Absolute Basis
High
Low
Median
Current
P/Trailing E
95.1
10.4
21.9
17.0
P/Forward E
45.6
10.8
19.5
14.9
P/B
11.2
1.0
3.9
5.0
P/S
3.3
0.4
1.3
1.7
P/CF
29.2
7.1
13.6
11.2
Green= Cheap
Red= Expensive
Industry Valuation:
Computer Hardware (HPQ, NCR)
Relative to
SP500
High
Low
Median
Current
P/Trailing E
5.7
0.75
1.2
0.98
P/Forward E
1.9
0.81
1.2
1.0
P/B
2.5
0.4
1.3
2.4
P/S
1.5
0.5
1.0
1.4
P/CF
1.7
0.8
1.2
1.2
Green= Cheap
Red= Expensive
Industry Valuation:
Semiconductor (INTC)
Absolute Basis
High
Low
Median
Current
P/Trailing E
135.8
11.6
23.5
26.4
P/Forward E
422.1
11.9
24.1
11.9
P/B
13.8
1.6
3.6
3.0
P/S
13.0
0.7
3.3
3.0
P/CF
37.3
6.4
14.3
9.9
Green= Cheap
Red= Expensive
Industry Valuation:
Semiconductor (INTC)
Relative to
SP500
High
Low
Median
Current
P/Trailing E
5.6
0.74
1.4
1.5
P/Forward E
34.7
0.60
1.4
0.84
P/B
2.6
0.8
1.3
1.4
P/S
5.8
0.9
2.4
2.5
P/CF
2.4
0.9
1.3
1.0
Green= Cheap
Red= Expensive
Industry Valuation:
Systems Software (ORCL)
Absolute Basis
High
Low
Median
Current
P/Trailing E
75.6
9.4
26.9
15.3
P/Forward E
35.1
9.8
19.7
14.3
P/B
26.6
3.0
5.8
4.6
P/S
21.8
2.2
7.8
3.6
P/CF
65.6
8.2
19.2
12.1
Green= Cheap
Red= Expensive
Industry Valuation:
Systems Software (ORCL)
Relative to
SP500
High
Low
Median
Current
P/Trailing E
2.5
0.83
1.4
0.88
P/Forward E
1.7
0.78
1.2
1.0
P/B
5.5
1.3
2.2
2.2
P/S
9.7
2.8
5.6
3.0
P/CF
3.7
1.0
1.8
1.3
Green= Cheap
Red= Expensive
Industry Valuation:
Communications Equipment (RIMM)
Absolute Basis
High
Low
Median
Current
P/Trailing E
211.9
11.0
25.4
20.9
P/Forward E
475.1
12.1
22.4
16.8
P/B
12.1
1.0
4.3
3.0
P/S
5.1
0.7
2.1
3.2
P/CF
55.5
8.8
17.6
14.5
Green= Cheap
Red= Expensive
Industry Valuation:
Communications Equipment (RIMM)
Relative to
SP500
High
Low
Median
Current
P/Trailing E
10.1
0.91
1.4
1.2
P/Forward E
29.1
1.0
1.4
1.2
P/B
2.4
0.3
1.4
1.4
P/S
3.0
0.7
1.6
2.7
P/CF
3.2
0.8
1.6
1.5
Green= Cheap
Red= Expensive
Conclusions Based on Valuation:
• Sector as a whole and most industries within
are currently undervalued;
• Economy likely to pick up, upside potential in
this sector.
Recommendation
 100 bps increase in weight to 227 bps overweight
 Top-line growth prospects: Office electronics, Data
Services, Electronic Equipment, Semiconductor
Equipment industries
 Current phase of business cycle favors investment in
the IT sector
 Sector as a whole and the industries are currently
undervalued