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% |
広告
「My dividend stock evaluation tool」への1件のフィードバック