Home Trading ETFs iShares IVV ETF: S&P 500 Dashboard For December

iShares IVV ETF: S&P 500 Dashboard For December

by Vidya
Fred Piard profile picture


Worawut Prasuwan

This monthly dashboard series reports sector metrics in the S&P 500 Index (SP500). It is also a top-down analysis of all exchange-traded funds (“ETFs”) tracking this index. Among them, the iShares Core S&P 500 ETF (NYSEARCA:IVV) is the second most popular behind the SPDR S&P 500 ETF (SPY) regarding assets under management and average daily volume. It is also cheaper in management fee, with a 0.03% expense ratio vs. 0.09% for SPY.

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 in every sector: Earnings Yield (“EY”), Sales Yield (“SY”), Free Cash Flow Yield (“FY”), Return on Equity (“ROE”), Gross Margin (“GM”). All are calculated on trailing 12 months. For all these ratios, higher is better and negative is bad. 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 when the “something” is close to zero or negative (for example, companies with negative earnings). I also calculate two momentum metrics for each group: the median monthly return (RetM) and the median annual return (RetY).

I prefer medians rather than averages because a median splits a set in a good half and a bad half. Capital-weighted averages are skewed by extreme values and the largest companies. As a consequence, these metrics are designed for stock-picking rather than index investing.

Value and Quality Scores

Historical baselines are calculated as the averages on a look-back period of 11 years for all metrics. They are noted respectively EYh, SYh, FYh, ROEh, GMh. For example, the value of EYh for technology in the table below is the 11-year average of the median Earnings Yield of S&P 500 tech companies.

The Value Score “VS” is 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).

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, except in energy and utilities where the Free Cash Flow Yield is ignored to avoid some inconsistencies. VS and QS are capped between -100 and +100 when the calculation goes beyond these values.

Current data

The next table shows the metrics and scores as of last week’s closing. Columns stand for all the data defined above.

VS

QS

EY

SY

FY

ROE

GM

EYh

SYh

FYh

ROEh

GMh

RetM

RetY

All

-15.77

8.36

0.0417

0.3700

0.0229

17.29

46.57

0.0453

0.4458

0.0295

15.00

45.91

6.94%

-2.45%

Cs. Discretionary

-24.17

-0.41

0.0403

0.5918

0.0159

22.44

34.14

0.0466

0.6609

0.0309

21.28

36.43

9.60%

-11.22%

Cs. Staples

-20.99

-2.93

0.0369

0.4417

0.0144

24.04

37.89

0.0440

0.4969

0.0224

23.66

40.96

4.60%

16.98%

Energy

100.00

100.00

0.1084

0.5072

0.0609

30.37

48.66

0.0188

0.5392

-0.0146

5.34

42.59

2.12%

77.50%

Financials

-7.93

13.17

0.0696

0.3886

0.0627

12.55

79.75

0.0692

0.4508

0.0701

10.70

73.14

5.34%

-0.12%

Healthcare

-9.62

8.20

0.0368

0.2570

0.0318

18.06

65.90

0.0373

0.3003

0.0366

16.23

62.69

5.96%

0.04%

Industrials

-32.39

7.17

0.0356

0.3893

0.0172

24.07

36.15

0.0470

0.5779

0.0288

20.66

36.94

8.41%

-0.17%

Technology

-25.48

16.02

0.0339

0.1917

0.0268

27.72

62.83

0.0404

0.2852

0.0370

21.03

62.71

8.19%

-18.15%

Communication

-3.51

-14.19

0.0391

0.7998

0.0225

11.77

55.39

0.0492

0.5283

0.0384

16.81

54.51

6.44%

-24.75%

Materials

-19.84

23.02

0.0521

0.5345

0.0094

24.27

37.19

0.0448

0.6206

0.0247

16.96

36.13

11.71%

-4.85%

Utilities

-14.43

2.93

0.0481

0.4143

-0.0782

10.17

39.52

0.0510

0.5393

-0.0469

9.67

39.26

8.69%

13.78%

Real Estate

47.42

36.11

0.0335

0.1122

0.0124

10.89

64.83

0.0210

0.1149

0.0067

6.29

65.44

6.79%

-16.71%

* capped for convenience

Score charts

The next chart plots the Value and Quality Scores by sectors (higher is better).

Value and Quality in sectors

Value and Quality in sectors (Chart: author; data: Portfolio123)

Score variation since last month:

Value and Quality variations

Value and Quality variations (Chart: author; data: Portfolio123)

The next chart plots momentum data.

Momentum in sectors

Momentum in sectors (Chart: author; data: Portfolio123)

Interpretation

A hypothetical S&P 500 “median” company is overvalued by about 16% relative to average valuation metrics since 2011. The quality score is about 8 points above the baseline. We can translate median yields in their inverse ratios:

Price/Earnings: 24 – Price/Sales: 2.7 – Price/Free Cash Flow: 43.7

Energy has been the best-ranked sector regarding value, quality and momentum for a long time. Real estate also has excellent value and quality scores. The ratios used to calculate scores are not the most relevant for real estate and finance in absolute value, but looking at their evolution in time makes sense (it is what the scores do). Financials, healthcare, communication and utilities are overvalued by less than 15% relative to 11-year averages. It may be justified for financials and healthcare by good quality scores. Other sectors are overvalued by 20% to 32% relative to their historical baselines. Good quality scores partially offset overvaluation in technology and materials. The most overpriced sector is industrials

The S&P 500 is down -10.4% in 12 months, the momentum measured in median return is -2.5% (reported in the table above) and the equal-weight average is -2.9% (measured on RSP). It means that S&P 500 performance in 2022 has been significantly skewed to the downside by mega-cap companies. The S&P mid-cap 400 index beats the S&P 500 (-5.2% YTD for MDY), but the small cap index Russell 2000 is lagging (-15% for IWM). Performance has been quite homogeneous in the large and mid-cap segments. Mega-cap and small cap stocks have suffered the most.

We use the table above 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 that a large consumer staples company with an Earnings Yield above 0.0369 (or price/earnings below 27.10) is in the better half of the sector 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.



Source links Google News

Related Articles

Leave a Comment

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Privacy & Cookies Policy