Entering text into the input field will update the search result below

Finding CAGRs In The Spreadsheets Of The CCC List

Dec. 11, 2014 10:32 AM ET2 Comments
Factoids profile picture
Factoids's Blog
4.68K Followers
Please Note: Blog posts are not selected, edited or screened by Seeking Alpha editors.

If you are a regular Seeking Alpha reader, you have probably read several articles that refer to David Fish's CCC list. For those who know only a little about it - I will quickly tell you a little more.

The most recent pdf document can be found at - http://dripinvesting.org/Tools/U.S.DividendChampions.pdf

His profile is at https://seekingalpha.com/author/david-fish?s=david-fish

The Dividend Champions spreadsheet (and PDF) is updated at the end of each month. It lists "Champions" that have increased their dividend payout for at least 25 consecutive years; "Contenders" that have increased their payouts for 10-24 years; and "Challengers" that have increased their payouts for 5-9 years. The full list contains around 544 names. It's a great resource.

Each 'C segment' contains a series of spreadsheets. The CAGR is found in the second. I have attempted to 'copy and paste' the data -- and the appearance of the data is so different that the copy is useless.

Going from left to right, you will find column headers for (1) Company Name; (2) Ticker; (3) Annual Dividend; (4) EPS Payout %; (5)Graham #; (6) TTM PE; (7) FYE month; (8) TTM EPS; (9) PEG Ratio; (10) TTM Price/Sales (11) MRQ Price/Book; (12) TTM ROE; (13) TY % Growth; (14) NY % Growth; (15) Past 5 year Growth; (16) Est 5 year Growth; (17) etc

I use the "est 5 year growth" number for a dividend CAGR projection. Mr Fish's CAGR number is a projection for earnings growth.

Seeking Alpha's Disclosure: Past performance is no guarantee of future results. No recommendation or advice is being given as to whether any investment is suitable for a particular investor. Any views or opinions expressed above may not reflect those of Seeking Alpha as a whole. Seeking Alpha is not a licensed securities dealer, broker or US investment adviser or investment bank. Our analysts are third party authors that include both professional investors and individual investors who may not be licensed or certified by any institute or regulatory body.

Recommended For You