kynny
This monthly article series shows a dashboard with aggregate industry metrics in information technology. It may also serve as a top-down analysis of sector ETFs like the Technology Select Sector SPDR ETF (XLK) and SPDR NYSE Technology ETF (NYSEARCA:XNTK), whose 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 |
-36.52 |
-42.60 |
0.0270 |
1.3249 |
-0.0094 |
1.74 |
37.62 |
0.0360 |
0.9516 |
0.0395 |
7.09 |
41.67 |
-12.30% |
-22.21% |
Comm. Equip. |
-28.97 |
-25.29 |
0.0246 |
0.3461 |
0.0039 |
10.71 |
51.95 |
0.0313 |
0.2772 |
0.0404 |
15.87 |
63.41 |
-4.48% |
3.58% |
Electronic Equip. |
-15.47 |
23.00 |
0.0420 |
0.6745 |
0.0277 |
17.89 |
38.80 |
0.0425 |
0.7952 |
0.0396 |
13.02 |
35.71 |
-9.54% |
-4.64% |
Software |
-18.60 |
-6.08 |
0.0244 |
0.1236 |
0.0290 |
16.40 |
82.06 |
0.0265 |
0.1706 |
0.0364 |
17.76 |
85.97 |
-8.71% |
-14.18% |
Semiconductors |
-0.61 |
17.70 |
0.0555 |
0.2187 |
0.0306 |
32.13 |
62.58 |
0.0460 |
0.2434 |
0.0349 |
23.82 |
62.25 |
-5.07% |
-2.02% |
IT Services |
-19.18 |
0.37 |
0.0342 |
0.2384 |
0.0260 |
28.33 |
50.77 |
0.0382 |
0.3247 |
0.0327 |
26.04 |
55.22 |
-11.30% |
-10.53% |
Value And Quality chart
The next chart plots the Value and Quality Scores by industry (higher is better).
Value and Quality in technology (chart: author; data: Portfolio123)
Evolution since last month
The value score has significantly deteriorated in hardware and improved in other industries. Quality has deteriorated in communication equipment, and is stable elsewhere.
Score variations (chart: author; data: Portfolio123)
Momentum
The next chart plots momentum data.
Momentum in technology (chart: author; data: Portfolio123)
Interpretation
Semiconductors are close to their historical baseline in value score, and above it in quality. Other industries are overvalued by 15% to 37% relative to 11-year averages. It may be justified by a good quality score for electronic equipment. Hardware, which has suffered a serious deterioration in valuation and quality for a few months, is now the worst-ranked subsector regarding both scores.
Fast facts on XNTK
SPDR NYSE Technology ETF (XNTK) was launched on 9/25/2000 and tracks the NYSE Technology Index. It has a total expense ratio of 0.35%, whereas capital-weighted ETFs in the same sector like XLK and VGT have just a 0.10% fee.
As described by SSGA, the index is…
composed of 35 leading U.S.-listed technology-related companies. (…) Stocks must also meet at least one of the following three revenue- and sales-based criteria: (i) have an increase in sales over the last twelve months, (ii) have only one consecutive quarter of negative sales growth over the last two years, or (iii) have revenue totals from the last four quarters that classify it within the top 75 companies within the specific industry classification (…) The Index is equal-weighted and rebalanced annually.
Constituent weights are equal after every annual rebalancing, but they may drift with price action. The next table shows the top 10 holdings now with their current weights and fundamental ratios. These are the index constituents with the highest price return since the last rebalancing in December. Together, they represent 33.9% of asset value, and the heaviest one is below 5%. Risks related to top holdings are much lower than for capital weighted ETFs, where Apple Inc (AAPL) and Microsoft Corp (MSFT) together represent over 40% of asset value.
Ticker |
Name |
Weight% |
EPS growth %TTM |
P/E TTM |
P/E fwd |
Yield% |
Meta Platforms, Inc. |
4.49 |
-37.78 |
23.03 |
19.97 |
0 |
|
NVIDIA Corp. |
3.74 |
-54.71 |
139.13 |
54.95 |
0.07 |
|
Salesforce, Inc. |
3.67 |
-86.26 |
886.62 |
25.72 |
0 |
|
Advanced Micro Devices, Inc. |
3.44 |
-65.63 |
101.34 |
28.70 |
0 |
|
Uber Technologies, Inc. |
3.17 |
-1423.29 |
N/A |
N/A |
0 |
|
Airbnb, Inc. |
3.16 |
466.82 |
40.78 |
31.83 |
0 |
|
Booking Holdings, Inc. |
3.14 |
176.83 |
31.02 |
18.63 |
0 |
|
Palo Alto Networks, Inc. |
3.04 |
104.82 |
2415.24 |
45.97 |
0 |
|
Broadcom Inc. |
3.03 |
67.70 |
21.28 |
15.09 |
2.94 |
|
Shopify, Inc. |
2.98 |
-216.55 |
N/A |
973.07 |
0 |
Data calculated with Portfolio123
In the last 10 years, XNTK has underperformed not only XLK, but also another equal-weight technology ETF: Invesco S&P 500 Equal Weight Technology ETF (RYT).
XNTK vs. XLK, RYT, last 10 years (Seeking Alpha)
It has also been lagging in the last 12 months:
XNTK vs. XLK, RYT, last 12 months (Seeking Alpha)
XNTK has an average daily trading volume of about 11K shares, much weaker than RYT (about 68K, with a more expensive share). In summary, XNTK is an equal-weight tech ETF and a competitor to RYT, but neither past performance nor liquidity makes it attractive.
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 an earnings yield above 0.0270 (or price/earnings below 37.04) 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. The list below was sent to subscribers several weeks ago based on data available at this time.
Veeco Instruments, Inc. |
|
Belden, Inc. |
|
Diodes, Inc. |
|
QUALCOMM, Inc. |
|
NXP Semiconductors NV |
|
Gen Digital Inc. |
It is a rotational list with a statistical bias toward excess returns on the long-term, not the result of an analysis of each stock.