IDU: Utilities Dashboard For November (NYSEARCA:IDU)

This monthly article series shows a dashboard with aggregate industry metrics in utilities. It is also a top-down analysis of sector ETFs like the Utilities Select Sector SPDR ETF (XLU) and the iShares U.S. Utilities ETF (NYSEARCA:IDU), 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 two valuation ratios (EY, SY) and their baselines (EYh, SYh). FY is reported for consistency with other sector dashboards, but it is ignored in utilities’ score to avoid some inconsistencies. 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 two valuation ratios 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
Gas	-6.03	-3.38	0.0515	0.5082	-0.0987	9.04	35.92	0.0479	0.6319	-0.0597	9.40	37.00	11.30%	14.40%
Water	-30.52	4.63	0.0290	0.1583	-0.0470	10.40	56.06	0.0376	0.2560	-0.0322	9.61	55.43	13.70%	1.64%
Electricity	-12.17	-2.34	0.0499	0.4243	-0.0770	9.37	38.60	0.0520	0.5324	-0.0449	9.83	38.62	8.18%	0.52%

Click to enlarge

Value and Quality chart

The next chart plots the Value and Quality Scores by industry. Higher is better.

Evolution since last month

Value scores have deteriorated in gas and water.

Momentum

The next chart plots median returns by subsector.

Interpretation

Gas utilities are close to 11-year averages in both valuation and quality. Electricity utilities are overvalued by about 12% relative to the baseline. Water utilities are overvalued by over 30% regarding the same metrics.

Focus on IDU

The Vanguard Utilities ETF (IDU) has been tracking the Russell 1000 Utilities RIC 22.5/45 Capped Index since 6/12/2000. The expense ratio of 0.39% is significantly more expensive than XLU (0.10%), which tracks another index with a higher market capitalization threshold.

As of writing, it has 48 holdings. The next table shows the top 10 names with some fundamental ratios. Their aggregate weight is 54.4%.

Ticker	Name	Weight	EPS growth %TTM	P/E TTM	P/E fwd	Yield%
NEE	NextEra Energy, Inc.	14.22	61.60	42.17	28.34	2.08
DUK	Duke Energy Corp.	6.37	27.82	19.21	17.80	4.21
SO	The Southern Co.	6.01	12.59	20.45	17.98	4.21
WM	Waste Management, Inc.	5.71	30.46	29.28	27.61	1.65
D	Dominion Energy, Inc.	4.46	-12.42	20.87	14.09	4.61
SRE	Sempra Energy	4.23	94.05	21.85	17.74	2.94
AEP	American Electric Power Co., Inc.	4.02	8.27	17.47	17.67	3.74
EXC	Exelon Corp.	3.38	26.65	17.58	16.87	3.55
XEL	Xcel Energy, Inc.	3.2	4.91	21.82	21.10	2.92
ED	Consolidated Edison, Inc.	2.75	42.49	18.74	19.71	3.54

Click to enlarge

The return and risk metrics of IDU and XLU since June 2000 are almost identical (see table below).

	Total Return	Annual. Return	Drawdown	Sharpe ratio	Volatility
IDU	386.53%	7.32%	-53.88%	0.46	15.12%
XLU	397.29%	7.42%	-52.78%	0.48	14.77%

Click to enlarge

Data calculated with Portfolio123

In summary, IDU is very similar to XLU in performance and volatility, despite a larger number of holdings (currently 48 vs. 32). IDU has a higher expense ratio and a much lower liquidity, so there is no advantage to hold or trade it instead of XLU. Exposure to the top names is high in both funds, especially to NextEra Energy, which weighs 14.2% of asset value in IDU and 15.8% in XLU. Investors seeking a more balanced portfolio may prefer the Invesco S&P 500 Equal Weight Utilities ETF (RYU).

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 an electricity 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 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.

NRG	NRG Energy, Inc.
FE	FirstEnergy Corp.
NI	NiSource, Inc.
CMS	CMS Energy Corp.
ETR	Entergy Corp.
HE	Hawaiian Electric Industries, Inc.
CNP	CenterPoint Energy, Inc.
BKH	Black Hills Corp.
PNW	Pinnacle West Capital Corp.
POR	Portland General Electric Co.

Click to enlarge

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.