Crush The Market Tool

Last Updated: 01/21/2017

What the tool does:
– Data goes back to 1/2/1970 if stock was trading
– Data goes back to the first date available if not 1/2/1970
– Accounts for splits and dividends
– Displays the CAGR (Cumulative Annual Growth Rate) for each stock
– Displays the current Dividend Yield %
– Displays the current Annual Dividend in $’s
– Displays the Ex-Dividend Date
– Displays Number of years of stock history
– Can search the entire table
– Can sort any of the columns (Ascending & Descending)
– S&P 500 CAGR is listed at the bottom of the table. I listed the S&P 500 at the bottom of the table since it performs worse than the majority of the Dividend Aristocrats.

How to Use:
– Find the best performing stock? Sort Descending by “CAGR” column.
– Find the highest dividend yield? Sort Descending by “Dividend Yield %” column.
– Find the highest dividend amount ($)? Sort Descending by “Annual Dividend $” column.
– Find when a you need to buy a stock to get the next quarterly dividend payment? Sort Ascending by “Ex-Date” column and add 3 months. Look the stock up on your favorite stock website to find the exact Ex-Dividend Date.
– Find out if you just missed buying a stock to get the next quarterly dividend payment? Sort Descending by “Ex-Date” column and add 3 months. Look the stock up on your favorite stock website to find the exact Ex-Dividend Date.

Company NameTickerNumber of YearsCAGRDividend Yield %Annual Dividend $Ex-Date
Abbott LaboratoriesABT34.0213.202.621.062017-01-11
Archer-Daniels-Midland CoADM34.029.902.681.202016-11-14
Air Products & Chemicals Inc.APD34.0213.102.212.282016-12-07
AFLAC Inc.AFL33.0217.002.451.722016-11-14
Automatic Data ProcessingADP34.0212.302.353.442016-12-29
C. R. BardBCR34.0212.600.4491.042017-01-19
Becton DickinsonBDX34.0213.801.692.922016-12-07
Franklin ResourcesBEN35.0223.102.00.802016-12-28
Bemis CompanyBMS33.0212.602.331.162016-11-14
Cardinal Health Inc.CAH30.0217.002.401.802016-12-29
Cincinnati Financial CorpCINF29.0210.905.463.842016-12-19
The Clorox CompanyCLX34.0214.102.643.202016-10-24
Cintas CorpCTAS28.0212.804.675.322016-11-02
Chevron Corp.CVX46.037.303.744.322016-11-16
Dover CorpDOV32.0210.402.231.762016-11-28
Ecolab IncECL29.0214.201.251.482016-12-16
Consolidated Edison IncED46.0310.103.672.682016-11-14
Emerson ElectricEMR45.039.603.261.922016-11-08
Genuine Parts CompanyGPC34.0210.802.642.632016-12-07
W. W. GraingerGWW33.0213.201.984.882016-11-09
Hormel Foods CorpHRL27.0213.201.90.682017-01-12
Illinois Tool WorksITW33.0212.702.102.602016-12-28
Johnson & JohnsonJNJ46.0312.802.803.202016-11-18
Coca-Cola CoKO46.0311.903.391.402016-11-29
Leggett & PlattLEG30.0212.702.851.362016-12-13
Lowe's Companies, Inc.LOW32.0216.301.951.402016-10-17
McCormick & CompanyMKC40.038.702.011.882016-12-28
3M CompanyMMM46.0310.702.494.442016-11-16
Altria GroupMO46.0320.603.492.442016-12-20
Procter & GamblePG46.
Phillip MorrisPM9.0112.004.404.162016-12-20
PPG IndustriesPPG34.0210.001.621.602016-11-08
Stanley Black & Decker Inc.SWK32.029.601.932.322016-11-30
Target CorporationTGT34.0211.003.742.402016-11-14
T. Rowe PriceTROW29.0215.002.932.162016-12-13
VF CorporationVFC32.0210.303.241.682016-12-07
Exxon Mobil CorpXOM46.0310.003.493.002016-11-08

Benchmark: S&P 500 CAGR since 1/3/1970 is 7.02%. All but one stock in the above list have beaten the S&P 500 since 1970.