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%




2 comments:

  1. Great post ADY....thanks for the analysis! We have ESV and TGT in our portfolio. We are watching IBM closely and may consider picking up shares on a dip. I definitely need to take a look at NOV. Based on the average dividend yield, it appears to be a great value.

    Thanks for sharing...best wishes! AFFJ

    ReplyDelete
    Replies
    1. FFJ,

      Glad you like the post. I've been wanting to post my entire Excel file but haven't had time to figure out how to do that.

      Was happy to see a dip yesterday and hope it will continue for some time to come. I bought some OXY and TSCDY. Tesco hasn't raised its dividend in 3 years but I think the value is there - only bought 100 shares anyway.

      Thanks for the comment and good luck.

      Delete