This monthly article series shows a dashboard with aggregate industry metrics in technology. It may also serve as a top-down analysis of sector ETFs like Vanguard Information Technology ETF (VGT), Technology Select Sector SPDR ETF (XLK) and iShares U.S. Technology ETF (NYSEARCA:IYW), whose largest holdings are used to calculate these metrics.
Shortcut
The next two paragraphs in italic describe the dashboard methodology. They are necessary for new readers to understand the metrics. If you are used to this series or if you are short of time, you can skip them and go to the charts.
Base Metrics
I calculate the median value of five fundamental ratios for each industry: Earnings Yield (“EY”), Sales Yield (“SY”), Free Cash Flow Yield (“FY”), Return on Equity (“ROE”), Gross Margin (“GM”). The reference universe includes large companies in the U.S. stock market. The five base metrics are calculated on trailing 12 months. For all of them, higher is better. EY, SY and FY are medians of the inverse of Price/Earnings, Price/Sales and Price/Free Cash Flow. They are better for statistical studies than price-to-something ratios, which are unusable or non available when the “something” is close to zero or negative (for example, companies with negative earnings). I also look at two momentum metrics for each group: the median monthly return (RetM) and the median annual return (RetY).
I prefer medians to averages because a median splits a set in a good half and a bad half. A capital-weighted average is skewed by extreme values and the largest companies. My metrics are designed for stock-picking rather than index investing.
Value and Quality Scores
I calculate historical baselines for all metrics. They are noted respectively EYh, SYh, FYh, ROEh, GMh, and they are calculated as the averages on a look-back period of 11 years. For example, the value of EYh for hardware in the table below is the 11-year average of the median Earnings Yield in hardware companies.
The Value Score (“VS”) is defined as the average difference in % between the three valuation ratios (EY, SY, FY) and their baselines (EYh, SYh, FYh). The same way, the Quality Score (“QS”) is the average difference between the two quality ratios (ROE, GM) and their baselines (ROEh, GMh).
The scores are in percentage points. VS may be interpreted as the percentage of undervaluation or overvaluation relative to the baseline (positive is good, negative is bad). This interpretation must be taken with caution: the baseline is an arbitrary reference, not a supposed fair value. The formula assumes that the three valuation metrics are of equal importance.
Current data
The next table shows the metrics and scores as of last week’s closing. Columns stand for all the data named and defined above.
VS |
QS |
EY |
SY |
FY |
ROE |
GM |
EYh |
SYh |
FYh |
ROEh |
GMh |
RetM |
RetY |
|
Hardware |
-48.99 |
-58.98 |
0.0268 |
0.9358 |
-0.0077 |
-0.61 |
37.82 |
0.0355 |
0.9579 |
0.0382 |
6.88 |
41.59 |
4.09% |
-5.60% |
Comm. Equip. |
-25.46 |
-13.62 |
0.0270 |
0.3183 |
0.0087 |
13.37 |
56.07 |
0.0312 |
0.2764 |
0.0397 |
15.90 |
63.26 |
-1.88% |
1.75% |
Electronic Equip. |
-2.19 |
16.13 |
0.0412 |
0.7671 |
0.0383 |
16.18 |
38.77 |
0.0418 |
0.7855 |
0.0394 |
13.06 |
35.76 |
3.90% |
1.39% |
Software |
-28.08 |
-10.20 |
0.0203 |
0.1135 |
0.0253 |
14.94 |
82.07 |
0.0262 |
0.1679 |
0.0358 |
17.77 |
85.92 |
0.85% |
0.57% |
Semiconductors |
-5.15 |
13.64 |
0.0501 |
0.2080 |
0.0303 |
31.10 |
60.58 |
0.0456 |
0.2402 |
0.0344 |
23.92 |
62.30 |
5.53% |
6.11% |
IT Services |
-30.50 |
7.30 |
0.0290 |
0.1958 |
0.0229 |
29.37 |
56.61 |
0.0378 |
0.3205 |
0.0324 |
26.25 |
55.12 |
-1.35% |
-5.33% |
Value And Quality chart
The next chart plots the Value and Quality Scores by industry (higher is better).
Evolution since last month
Quality has improved in communication equipment and electronic equipment. Both valuation and quality have significantly deteriorated in hardware.
Momentum
The next chart plots median returns by subsector.
Interpretation
Electronic equipment and semiconductors are close to 11-year averages in valuation, and their quality score is above the baseline. Other subsectors are overvalued by 25% to 49% relative to historical averages. IT services have a good quality score, but it is not high enough to justify overvaluation. Hardware is the less attractive subsector, with both scores far in negative territory.
Focus on IYW
iShares U.S. Technology ETF has been tracking the Dow Jones U.S. Technology Capped Index since 5/15/2000. It has a total expense ratio of 0.39%, whereas other passive index ETFs like VGT and XLK charge only 0.10%. IYW holdings are capital-weighted with a capping methodology: the weight of any single issuer is limited to a maximum of 22.50%, and the aggregate weight of constituents exceeding 4.50% of the index is limited to a maximum of 45%. These conditions are assessed quarterly.
As of writing, the fund has 139 holdings, but it is very concentrated in the top names. The three heaviest companies are Microsoft (MSFT), Apple (AAPL) and Alphabet (GOOG, GOOGL): they weigh between 10% and 20% each, and almost 48% together. Exposure to risks related to other constituents is moderate. The next table lists the top 10 companies with growth and valuation ratios. They represent about 68% of the fund’s assets (the two stock series of Alphabet are aggregated in the same line).
Ticker |
Name |
Weight% |
EPS growth %TTM |
P/E TTM |
P/E fwd |
Yield% |
AAPL |
Apple Inc. |
19.28 |
-4.33 |
29.76 |
29.27 |
0.55 |
MSFT |
Microsoft Corp. |
17.63 |
-3.75 |
34.51 |
33.11 |
0.85 |
GOOGL,GOOG |
Alphabet, Inc. |
10.73 |
-19.87 |
27.71 |
22.77 |
0 |
NVDA |
NVIDIA Corp. |
5.06 |
-54.71 |
179.53 |
68.05 |
0.05 |
META |
Meta Platforms, Inc. |
4.29 |
-39.04 |
30.47 |
20.87 |
0 |
AVGO |
Broadcom Inc. |
2.75 |
67.70 |
23.19 |
16.49 |
2.70 |
CRM |
Salesforce, Inc. |
2.34 |
-86.26 |
1019.68 |
29.47 |
0 |
AMD |
Advanced Micro Devices, Inc. |
1.98 |
-91.00 |
438.72 |
37.13 |
0 |
ADBE |
Adobe, Inc. |
1.96 |
0.73 |
36.59 |
23.97 |
0 |
ORCL |
Oracle Corp. |
1.82 |
16.69 |
33.79 |
20.42 |
1.56 |
Data calculated with Portfolio123
IYW and XLK show very similar behaviors and total returns since June 2000. The difference in annualized return is insignificant.
In summary, IYW holds much more stocks than XLK (currently 139 vs. 64), but both funds are equivalents in performance since inception. XLK is a better choice regarding management fees and liquidity. Investors who want to avoid high weights in the top holdings may prefer the Invesco S&P 500 Equal Weight Technology ETF (RYT).
Dashboard List
I use the first table to calculate value and quality scores. It may also be used in a stock-picking process to check how companies stand among their peers. For example, the EY column tells us that a hardware company with earnings yield above 0.0268 (or price/earnings below 37.31) is in the better half of the industry regarding this metric. A Dashboard List is sent every month to Quantitative Risk & Value subscribers with the most profitable companies standing in the better half among their peers regarding the three valuation metrics at the same time. Below is an excerpt of the list sent to subscribers several weeks ago based on data available at this time.
VECO |
Veeco Instruments, Inc. |
BDC |
Belden Inc. |
PRGS |
Progress Software Corp. |
ON |
ON Semiconductor Corp. |
QCOM |
QUALCOMM, Inc. |
NXPI |
NXP Semiconductors N.V. |
JBL |
Jabil Inc. |
GEN |
Gen Digital Inc. |
It is a rotating list with a statistical bias toward excess returns on the long-term, not the result of an analysis of each stock.
Read the full article here