Published Sun, 19 May 2019 09:00:00 -0400 on Seeking Alpha
From time to time, I compile a virtual portfolio of the top 50 holdings of Dividend ETFs. This is an informative exercise and certainly worth the effort.
Below is a brief summary of the methodology. For details, please refer to the June 2017 edition in this series. And if you want to learn about Dividend ETFs and ETF resources, the December 2016 article is worth revisiting.
Dividend ETF Analysis
Dividend ETFs invest in stocks that pay and regularly increase dividends. The issuers of ETFs provide data about the holdings of each ETF, including the percentage of assets under management allocated to each holding.
I collect these data from established Dividend ETFs and compile a spreadsheet with tickers of the top 25 holdings in each ETF, along with the relative weight of each holding.
To rank the top holdings, I use the relative weight of each holding and score tickers of the top 25 holdings proportionally, favoring larger investments over smaller ones within the same ETF.
Then I assign weights to each ETF based on the total assets under management. Rather than doing so proportionally, I use a log-based formula:
w = floor (log10 (assets in millions))
ETFs with assets under $100 million get a weight of 1. ETFs with assets under $1,000 million (but ≥ $100 million) get a weight of 2. ETFs with assets under $10,000 million (but ≥ $1,000 million) get a weight of 3. ETFs with assets under $100,000 million (but ≥ $10,000 million) get a weight of 4. With... Read more
|Stock name||Last trade||P/E||Earnings/Share||Dividend/Share||Dividend yield|
|JOHNSON & JOHNSON||130.43||21.6||6.03||3.80||2.93|
|PROCTER & GAMBLE||122.77||90.3||1.36||2.98||2.49|
Older articles featuring At&t (T):Revisiting A Dividend Portfolio Of The World's Best Dividend ETFs
DGI For The DIY: Q2 2019 Dividend Portfolio Update
A Dividend Growth Analysis Of The Dividend Champions
Your 57 September S&P 500 Dividend Aristocrats
My Dividend Growth Portfolio: End Of Summer Review
My Dividend Growth Portfolio July Update: 44 Holdings, 3 New, 5 Buys, 3.45% Yield
The Retirees' Dividend Portfolio - John And Jane's August Taxable Account Update: MLP Update
Brookfield Infrastructure Partners L.P.: One Dividend Stock to Own Forever?
100-Stock Dividend Portfolio Update For August 2019
Dividend Diligence: The Quant Model Speaks