My dividend stock evaluation tool

I have a simple excel file that evaluates potential investment opportunities by the following criteria.

1. Dividend Yield, 2. Payout ratio, 3. Free Cash Flow coverage, 4. Deviation between 52W low and 52W high. I borrowed several macro codes from the cloud and created this tool. Please note that your first stock has to be A5. Otherwise, an error. I have attached a copy of tool on this entry. I make it copyright free for good cause.

Here’s an example. Both EMR and CAT look very attractive.

Dividendsamurai div stock evaluation tool v1

Ticker	Price	Yield	PE	Payout	FCF	M CAP	Price to FCF	Coverage	Ex Dividend	52w low	52w High	Deviation
DIS	111.13	1.10%	24.75	27.2%	6.15B	189.19B	30.8	2.96	2014/12/11	76.88	111.53	99%
MSFT	47.6	2.50%	19.25	48.1%	23.02B	391.40B	17.0	2.35	2015/5/19	38.51	50.05	79%
EMR	57.98	3.10%	18.58	57.6%	2.90B	39.85B	13.7	2.35	2015/2/11	54.95	69.18	21%
CAT	84.52	3.30%	14.39	47.5%	5.36B	51.09B	9.5	3.18	2015/4/16	78.19	111.46	19%
MDT	77.44	1.60%	24.93	39.9%	3.52B	110.67B	31.4	1.99	2015/3/26	58	79.5	90%

広告