Twitter

Link your Twitter Account to Market Wire News


When you linking your Twitter Account Market Wire News Trending Stocks news and your Portfolio Stocks News will automatically tweet from your Twitter account.


Be alerted of any news about your stocks and see what other stocks are trending.



home / news releases / vdc consumer staples dashboard for december


PEP - VDC: Consumer Staples Dashboard For December

2023-12-17 04:59:09 ET

Summary

  • The consumer staples sector is overvalued by about 6% relative to 11-year averages.
  • Staple/food retail has good value and quality scores.
  • VDC fast facts.
  • 9 stocks cheaper than their peers in December.

This monthly article series shows a dashboard with aggregate industry metrics in consumer staples. It may also serve as a top-down analysis of sector ETFs like the Consumer Staples Select Sector SPDR ETF ( XLP ) and the Vanguard Consumer Staples ETF ( VDC ), 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 food in the table below is the 11-year average of the median Earnings Yield in food 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

Staple/Food Retail

16.91

5.79

0.0482

2.6349

0.0262

20.00

19.45

0.0394

1.8960

0.0293

16.43

21.64

4.31%

0.90%

Food

-8.28

-7.31

0.0499

0.7249

0.0122

13.43

32.20

0.0450

0.6491

0.0232

15.24

33.10

4.48%

-11.30%

Beverage

10.59

-6.53

0.0349

0.2705

0.0213

22.67

47.71

0.0346

0.2617

0.0167

23.58

52.55

1.27%

-2.67%

Household prod.

24.06

-21.91

0.0231

1.2175

0.0661

9.51

40.90

0.0452

0.8760

0.0363

16.90

40.94

14.09%

15.12%

Personal care

-8.77

1.17

0.0375

0.3938

0.0152

19.34

60.11

0.0365

0.4290

0.0192

20.30

56.15

7.09%

-0.78%

Tobacco

82.35

-38.11

0.0808

0.8446

0.0399

8.98

50.59

0.0601

0.5033

0.0163

33.92

51.98

4.94%

5.56%

Value And Quality chart

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

Value and quality in consumer staples (chart: author; data: Portfolio123)

Evolution since last month

Valuation has deteriorated in the tobacco, personal care, food and household product industries. Quality has improved in staple/food retail and household products.

Score variations (chart: author; data: Portfolio123)

Momentum

The next chart plots momentum data.

Momentum in consumer staples (chart: author; data: Portfolio123)

Interpretation

The consumer staples sector is overvalued by about 6% relative to 11-year averages according to my S&P 500 monthly dashboard . Tobacco is the most undervalued industry in the sector, but its quality score is significantly below the historical baseline. Moreover, there are only five tobacco companies in this universe, so statistics may be less reliable than in other industries. Household products are undervalued by about 24% relative to the historical baseline, but they also have a quality problem. Staple/food retail may be more attractive: it is undervalued by 17%, and quality looks better. Food, beverage and personal care products are close to their baselines regarding both valuation and quality.

VDC fast facts

Vanguard Consumer Staples ETF has been tracking the MSCI USA IMI Consumer Staples 25/50 Index since 01/26/2004. It has 106 holdings, a trailing 12-month distribution yield of 2.49% and a total expense ratio of 0.10%, the same as XLP.

The next table lists the top 10 holdings with some fundamental ratios. The portfolio is very concentrated: they represent 61% of asset value. In particular, the fund is quite exposed to risks related to the top five names, whose weights are between 7% and 13%.

PG

Procter & Gamble Co.

12.70%

6.63

23.40

22.38

2.61

COST

Costco Wholesale Corp.

8.90%

10.87

44.91

42.26

0.62

KO

The Coca-Cola Co.

8.05%

8.73

23.63

21.83

3.14

PEP

PepsiCo, Inc.

7.72%

-14.30

27.87

22.11

3.03

WMT

Walmart, Inc.

7.70%

86.16

25.36

23.64

1.49

PM

Philip Morris International, Inc.

4.48%

-8.34

18.36

15.46

5.51

MDLZ

Mondelez International, Inc.

3.85%

48.80

21.13

21.88

2.40

MO

Altria Group, Inc.

3.00%

90.49

8.51

8.41

9.39

CL

Colgate-Palmolive Co.

2.50%

-16.61

40.26

23.98

2.49

TGT

Target Corp.

2.38%

7.48

17.63

16.68

3.18

Ratios: Portfolio123

VDC has slightly outperformed XLP since inception, but the difference in annualized return is barely significant (47 bps). The two funds have similar risk metrics (drawdown and volatility in the table below).

Total Return

Annual Return

Max Drawdown

Sharpe

StdDev

VDC

482.14%

9.27%

-34.24%

0.67

11.71%

XLP

434.29%

8.80%

-32.39%

0.64

11.79%

In summary, Vanguard Consumer Staples ETF is a fund with cheap fees for investors seeking capital-weighted exposure in consumer staples. It holds much more stocks than XLP (currently 106 vs. 40), but this has not made much difference in return since 2004. For long-term investors, XLP and VDC are equivalents. However, liquidity makes XLP a better choice for tactical allocation and trading. VDC is significantly exposed to risks related to the top five holdings, which weigh 45% together. Investors seeking a more diversified portfolio may prefer Invesco S&P 500 Equal Weight Consumer Staples ETF ( RSPS ).

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 food company with an earnings yield above 0.0499 (or price/earnings below 20.04 is in the better half of the industry regarding this metric. A Dashboard List is sent every month to 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.

CALM

Cal-Maine Foods, Inc.

ENR

Energizer Holdings, Inc.

POST

Post Holdings, Inc.

JBSS

John B. Sanfilippo & Son, Inc.

USNA

USANA Health Sciences, Inc.

MED

Medifast, Inc.

EPC

Edgewell Personal Care Co.

COTY

Coty, Inc.

KMB

Kimberly-Clark Corp.

It is a rotational model with a statistical bias toward excess returns on the long-term, not the result of an analysis of each stock.

For further details see:

VDC: Consumer Staples Dashboard For December
Stock Information

Company Name: PepsiCo Inc.
Stock Symbol: PEP
Market: NASDAQ
Website: pepsico.com

Menu

PEP PEP Quote PEP Short PEP News PEP Articles PEP Message Board
Get PEP Alerts

News, Short Squeeze, Breakout and More Instantly...