Sunday, 27 July 2014

Average Dividend Yield

Those that follow my blog know that I tend to purchase shares in companies that are undervalued relative to their Average Dividend Yield. Since starting my blog almost 2 years ago, I've published numerous tables that show ADYs for various companies.

I've compiled a résumé of ADY data for all companies I follow into one mega table, which provides a birds eye view of company valuations based on ADY.

The table indicates that ESV, IBM, NOV, RCI.B, TGT and TSCDY offer very good dividend yields when compared to their historic yields.


Ticker
High Yield
Today's Price
Yield Analysis
5y Price
3y Price
Lowest of the 3y or 5y
$
%
ACN PLC
$71.70
$71.22
$71.22
USD 80.38
$9.16
11.39%
ACO.X
$36.94
$41.52
$36.94
$50.56
$13.62
26.93%
ADP:US
$52.07
$61.69
$52.07
USD 82.61
$30.54
36.97%
AFL:US
$31.36
$42.70
$31.36
USD 63.59
$32.23
50.68%
APD:US
$91.77
$95.58
$91.77
USD 135.87
$44.10
32.46%
ATD.B
$12.67
$11.98
$11.98
$30.10
$18.12
60.21%
AXP:US
$36.50
$64.15
$36.50
USD 91.93
$55.43
60.29%
AZN PLC
$42.38
$41.84
$41.84
USD 74.48
$32.64
43.82%
BAX:US
$75.68
$72.80
$72.80
USD 76.65
$3.85
5.03%
BDX:US
$90.96
$86.38
$86.38
USD 118.37
$31.99
27.02%
BMO
$47.87
$60.52
$47.87
$82.30
$34.43
41.83%
BNS
$49.96
$59.04
$49.96
$73.53
$23.57
32.05%
BP PLC
$40.28
$44.05
$40.28
$50.92
$10.64
20.89%
BTI PLC
$81.84
$90.40
$81.84
$120.28
$38.44
31.96%
BTI PLC
£26.98
£29.13
£26.98
£35.40
£8.41
23.77%
CAT:US
$73.18
$105.16
$73.18
USD 104.85
$31.67
30.21%
CCA
$52.09
$46.14
$46.14
$60.53
$14.39
23.78%
CJR.B
$23.80
$23.19
$23.19
$24.35
$1.16
4.77%
CL:US
$50.39
$51.69
$50.39
USD 67.59
$17.20
25.45%
CLX:US
$77.19
$79.37
$77.19
USD 89.48
$12.29
13.73%
CMI:US
$132.21
$155.18
$132.21
USD 150.15
$17.94
11.95%
CNR
$46.82
$50.30
$46.82
$74.02
$27.20
36.75%
COV PLC
$60.61
$63.66
$60.61
USD 87.79
$27.18
30.96%
CSX:US
$21.46
$23.04
$21.46
USD 31.00
$9.54
30.79%
CU
$31.50
$34.81
$31.50
$40.16
$8.66
21.57%
CVS:US
$72.29
$65.75
$65.75
USD 79.12
$13.37
16.90%
CVX:US
$108.04
$118.69
$108.04
USD 133.57
$25.53
19.11%
DE:US
$84.37
$99.27
$84.37
USD 86.17
$1.80
2.09%
DEO PLC
$77.40
$93.63
$77.40
USD 122.34
$44.94
36.73%
DIS:US
$53.58
$57.40
$53.58
USD 86.23
$32.65
37.87%
DOV:US
$48.10
$54.42
$48.10
USD 88.56
$40.46
45.69%
EMA
$27.43
$27.64
$27.43
$34.64
$7.21
20.80%
EMP.A
$61.24
$67.47
$61.24
$74.80
$13.56
18.12%
EMR:US
$44.99
$49.36
$44.99
USD 67.43
$22.44
33.28%
ENB
$40.88
$42.71
$40.88
$55.12
$14.24
25.84%
ESV PLC
$97.17
$76.54
$76.54
$53.25
$23.29
-43.74%
FTS
$28.94
$31.75
$28.94
$32.96
$4.02
12.19%
FTT
$24.46
$29.27
$24.46
$31.76
$7.30
22.99%
GE:US
$15.20
$22.79
$15.20
USD 25.79
$10.59
41.07%
GIS:US
$47.11
$47.52
$47.11
USD 52.81
$5.70
10.80%
GPC:US
$53.92
$63.87
$53.92
USD 85.31
$31.39
36.80%
GWO
$18.10
$20.81
$18.10
$31.50
$13.40
42.53%
GWW:US
$201.58
$232.15
$201.58
USD 241.16
$39.58
16.41%
HAS:US
$44.30
$41.33
$41.33
USD 51.46
$10.13
19.68%
IBM:US
$203.76
$219.55
$203.76
USD 194.40
$9.36
-4.81%
IFC
$53.91
$62.77
$53.91
USD 71.34
$17.43
24.43%
INTC:US
$21.11
$20.63
$20.63
USD 34.25
$13.62
39.76%
ITW:US
$48.80
$54.67
$48.80
USD 85.16
$36.36
42.69%
JNJ:US
$72.28
$73.13
$72.28
USD 102.11
$29.83
29.22%
JPM:US
$58.01
$49.59
$49.59
USD 59.01
$9.42
15.97%
K:US
$51.83
$52.88
$51.83
USD 65.37
$13.54
20.72%
KMB:US
$75.00
$81.00
$75.00
USD 108.53
$33.53
30.90%
KO:US
$35.60
$39.79
$35.60
USD 41.00
$5.40
13.18%
KRFT:US



USD 58.30


LMT:US
$124.82
$119.69
$119.69
USD 170.04
$50.35
29.61%
LNF
$12.04
$12.11
$12.04
$14.52
$2.48
17.11%
LO:US
$40.36
$43.12
$40.36
USD 60.73
$20.37
33.54%
LOW:US
$34.38
$34.33
$34.33
USD 47.70
$13.37
28.02%
MAT:US
$31.44
$36.24
$31.44
USD 35.30
$3.86
10.95%
MCD:US
$88.95
$93.03
$88.95
USD 95.72
$6.77
7.08%
MDT:US
$41.71
$42.71
$41.71
USD 62.90
$21.19
33.69%
MFC
$9.52
$11.10
$9.52
$22.09
$12.57
56.91%
MKC:US
$54.16
$60.78
$54.16
USD 69.22
$15.06
21.75%
MMM:US
$101.64
$116.76
$101.64
USD 145.12
$43.48
29.96%
MRU
$66.49
$68.85
$66.49
$70.11
$3.62
5.16%
MSFT:US
$35.80
$34.54
$34.54
USD 44.50
$9.96
22.38%
NGG PLC
$45.32
$48.49
$45.32
USD 76.21
$30.89
40.53%
NOV:US
$164.13
$171.95
$164.13
USD 85.17
$78.96
-92.71%
NSC:US
$64.31
$71.24
$64.31
USD 107.50
$43.19
40.18%
NWC
$17.55
$21.33
$17.55
$24.26
$6.71
27.64%
O:US
$30.01
$37.40
$30.01
$44.69
$14.68
32.86%
OMC:US
$73.97
$72.35
$72.35
USD 74.12
$1.77
2.39%
OXY:US
$107.34
$99.20
$99.20
USD 100.09
$0.89
0.89%
PEP:US
$76.29
$78.53
$76.29
USD 91.55
$15.26
16.67%
PG:US
$66.07
$71.65
$66.07
USD 79.56
$13.49
16.96%
PH:US
$77.22
$84.46
$77.22
USD 122.93
$45.71
37.18%
PJC.A
$16.32
$16.99
$16.32
$21.23
$4.91
23.12%
PM:US
$72.63
$83.71
$72.63
$84.85
$12.22
14.40%
PNR:US
$35.73
$41.48
$35.73
$72.27
$36.54
50.56%
POW
$20.66
$22.41
$20.66
$31.81
$11.15
35.04%
PSI
$16.28
$15.49
$15.49
$28.56
$13.07
45.77%
PSO PLC
$16.11
$17.91
$16.11
USD 19.32
$3.21
16.60%
PWF
$22.11
$24.81
$22.11
$35.00
$12.89
36.83%
RBA
$21.52
$20.22
$20.22
$26.96
$6.74
24.99%
RBGLY PLC



$17.28


RCH
$31.03
$33.30
$31.03
$50.61
$19.58
38.69%
RCI.b
$42.93
$42.81
$42.81
$42.46
$0.35
-0.83%
RDS.B PLC
$57.46
$67.72
$57.46
$86.36
$28.90
33.47%
RTN:US
$61.96
$57.99
$57.99
$92.07
$34.08
37.02%
SAP
$40.50
$46.09
$40.50
$66.66
$26.16
39.24%
SJM:US
$82.81
$90.05
$82.81
USD 104.63
$21.82
20.85%
SLF
$19.55
$20.47
$19.55
$41.40
$21.85
52.78%
SNC
$43.72
$40.76
$40.76
$57.74
$16.98
29.41%
SYK:US
$73.57
$69.52
$69.52
$80.44
$10.92
13.58%
T
$27.51
$31.85
$27.51
$37.54
$10.03
26.72%
TEVA:US
$56.40
$43.90
$43.90
USD 54.47
$10.57
19.41%
TFI
$9.46
$15.78
$9.46
$27.82
$18.36
65.99%
TGT:US
$84.36
$78.52
$78.52
USD 60.39
$18.13
-30.03%
TIH
$27.99
$24.08
$24.08
$26.38
$2.30
8.71%
TJX:US
$42.50
$50.14
$42.50
USD 52.55
$10.05
19.13%
TRI:US
$28.69
$27.85
$27.85
USD 36.89
$9.04
24.51%
TRP
$40.33
$43.62
$40.33
$55.86
$15.53
27.80%
TSCDY PLC
$15.25
$14.70
$14.70
USD 13.85
$0.85
-6.14%
TXN:US
$42.99
$42.49
$42.49
USD 46.82
$4.33
9.25%
UL PLC
$38.10
$39.17
$38.10
USD 44.45
$6.35
14.30%
UNP:US
$65.92
$70.20
$65.92
USD 101.66
$35.74
35.15%
UTX:US
$77.91
$85.16
$77.91
USD 108.88
$30.97
28.45%
WAG:US
$44.86
$40.53
$40.53
USD 73.29
$32.76
44.70%
WMT:US
$73.64
$69.52
$69.52
USD 75.97
$6.45
8.49%