This report should not be construed as providing investment
advice. It is for educational purposes only.
Before making any investment decision, you should always do your own
research or consult a investment professional. |
|
|
|
|
|
|
|
|
While I try to be
accurate, I assume no responsibility for any figure in this spreadsheet. |
|
|
|
|
|
|
|
|
|
Estimates |
Estimates |
Estimates |
|
|
|
|
|
|
|
See my website on
stocks or see my blog at the following sites. |
|
|
|
https://spbrunner.com/stocks.html |
|
https://spbrunner.blogspot.com/ |
Q2 2023 |
|
|
|
|
|
|
|
|
|
ATCO Ltd |
|
|
|
|
TSX: |
ACO.X |
OTC: |
ACLLF |
https://www.atco.com/en-ca.html |
|
|
Fiscal Yr: |
Dec 31 |
|
|
|
|
|
|
|
|
|
|
Year |
12/31/10 |
12/31/11 |
12/31/12 |
12/31/13 |
12/31/14 |
12/31/15 |
12/31/16 |
12/31/17 |
12/31/18 |
12/31/19 |
12/31/20 |
12/31/21 |
12/31/22 |
12/31/23 |
12/31/24 |
12/31/25 |
|
Value |
Description |
#Y |
Item |
Total G |
|
Accounting Rules |
C GAAP |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
|
|
|
|
Accounting Rules |
|
|
Split Date |
|
|
|
Jun 13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Split |
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$3,273 |
<-12 mths |
-1.53% |
|
|
|
|
|
|
|
Cost of Sales |
|
|
|
$3,179 |
$3,406 |
$3,340 |
$2,772 |
$3,539 |
$3,724 |
$3,362 |
$2,923 |
$3,324 |
$3,324 |
$3,273 |
<-12 mths |
|
|
4.56% |
<-Total Growth |
9 |
Cost of Sales |
|
|
Change |
|
|
|
|
7.14% |
-1.94% |
-17.01% |
27.67% |
5.23% |
-9.72% |
-13.06% |
13.72% |
0.00% |
-1.53% |
<-12 mths |
|
|
0.00% |
<-Median-> |
9 |
Change |
|
|
Ratio |
|
|
|
0.73 |
0.75 |
0.81 |
0.69 |
0.78 |
0.76 |
0.71 |
0.74 |
0.78 |
0.67 |
0.66 |
|
|
|
0.74 |
<-Median-> |
10 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$4,968 |
<-12 mths |
-0.20% |
|
|
|
|
|
|
|
Revenue* |
$3,445.4 |
$3,991 |
$4,362 |
$4,359 |
$4,554 |
$4,131 |
$4,045 |
$4,541 |
$4,888 |
$4,706 |
$3,944 |
$4,289 |
$4,978 |
$5,062 |
$5,207 |
$5,469 |
|
14.12% |
<-Total Growth |
10 |
Revenue |
|
|
Increase |
10.82% |
15.84% |
9.30% |
-0.07% |
4.47% |
-9.29% |
-2.08% |
12.26% |
7.64% |
-3.72% |
-16.19% |
8.75% |
16.06% |
1.69% |
2.86% |
5.03% |
|
1.33% |
<-IRR #YR-> |
10 |
Revenue |
14.12% |
|
5 year Running Average |
$3,117 |
$3,343 |
$3,635 |
$3,853 |
$4,142 |
$4,279 |
$4,290 |
$4,326 |
$4,432 |
$4,462 |
$4,425 |
$4,474 |
$4,561 |
$4,596 |
$4,696 |
$5,001 |
|
1.85% |
<-IRR #YR-> |
5 |
Revenue |
9.62% |
|
Revenue per Share |
$29.74 |
$34.57 |
$37.92 |
$37.86 |
$39.55 |
$35.91 |
$35.28 |
$39.60 |
$42.63 |
$41.04 |
$34.43 |
$37.50 |
$43.70 |
$44.44 |
$45.71 |
$48.01 |
|
2.30% |
<-IRR #YR-> |
10 |
5 yr Running Average |
25.49% |
|
Increase |
11.39% |
16.23% |
9.72% |
-0.16% |
4.46% |
-9.20% |
-1.76% |
12.26% |
7.64% |
-3.73% |
-16.10% |
8.90% |
16.54% |
1.69% |
2.86% |
5.03% |
|
1.06% |
<-IRR #YR-> |
5 |
5 yr Running Average |
5.43% |
|
5 year Running Average |
$26.85 |
$28.87 |
$31.44 |
$33.36 |
$35.93 |
$37.16 |
$37.31 |
$37.64 |
$38.60 |
$38.89 |
$38.60 |
$39.04 |
$39.86 |
$40.22 |
$41.16 |
$43.87 |
|
1.43% |
<-IRR #YR-> |
10 |
Revenue per Share |
15.23% |
|
P/S (Price/Sales) Med |
0.89 |
0.88 |
0.92 |
1.19 |
1.25 |
1.16 |
1.18 |
1.22 |
0.94 |
1.09 |
1.20 |
1.09 |
1.01 |
0.92 |
0.00 |
0.00 |
|
1.99% |
<-IRR #YR-> |
5 |
Revenue per Share |
10.34% |
|
P/S (Price/Sales) Close |
0.99 |
0.87 |
1.06 |
1.23 |
1.21 |
0.99 |
1.27 |
1.14 |
0.91 |
1.21 |
1.06 |
1.14 |
0.97 |
0.85 |
0.82 |
0.78 |
|
2.40% |
<-IRR #YR-> |
10 |
5 yr Running Average |
26.79% |
|
*Revenue in M CDN $ |
|
|
|
|
P/S Med |
20 yr |
0.98 |
15 yr |
1.09 |
10 yr |
1.17 |
5 yr |
1.09 |
|
-27.64% |
Diff M/C |
|
1.15% |
<-IRR #YR-> |
5 |
5 yr Running Average |
5.89% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,362 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$4,978 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,541 |
$0 |
$0 |
$0 |
$0 |
$4,978 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3,635 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$4,561 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,326 |
$0 |
$0 |
$0 |
$0 |
$4,561 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$37.92 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$39.60 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$31.44 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$39.86 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$37.64 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$39.86 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$421 |
<-12 mths |
-0.47% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$3.71 |
<-12 mths |
0.00% |
|
|
|
|
|
|
|
Adjusted Profit CDN$ |
$296 |
$330 |
$370 |
$390 |
$374 |
$293 |
$360 |
$335 |
$355 |
$365 |
$352 |
$382 |
$423 |
$410 |
$414 |
$421 |
|
|
|
|
|
|
|
Pre-split 2013 |
$5.09 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Basic Adjusted Earnings |
$2.54 |
$2.86 |
$3.22 |
$3.40 |
$3.26 |
$2.55 |
$3.15 |
$2.93 |
$3.10 |
$3.19 |
$3.08 |
$3.35 |
$3.71 |
$3.60 |
$3.63 |
$3.69 |
|
15.33% |
<-Total Growth |
10 |
AEPS |
|
|
Pre-split 2013 |
$5.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AEPS* Dilued is Calc |
$2.54 |
$2.85 |
$3.20 |
$3.38 |
$3.24 |
$2.54 |
$3.13 |
$2.92 |
$3.09 |
$3.18 |
$3.07 |
$3.34 |
$3.70 |
$3.59 |
$3.62 |
$3.68 |
|
15.65% |
<-Total Growth |
10 |
AEPS |
|
|
Increase |
5.86% |
12.25% |
12.37% |
5.49% |
-4.07% |
-21.55% |
23.35% |
-6.93% |
6.00% |
2.85% |
-3.53% |
8.77% |
10.91% |
-3.01% |
0.83% |
1.65% |
|
10 |
0 |
10 |
Years of Data, EPS P or N |
100.00% |
|
AEPS Yield |
8.58% |
9.46% |
7.93% |
7.24% |
6.80% |
7.12% |
7.02% |
6.48% |
8.01% |
6.39% |
8.41% |
7.82% |
8.73% |
9.54% |
9.62% |
9.78% |
|
1.46% |
<-IRR #YR-> |
10 |
AEPS |
15.65% |
|
5 year Running Average |
$2.04 |
$2.36 |
$2.66 |
$2.87 |
$3.04 |
$3.04 |
$3.10 |
$3.04 |
$2.99 |
$2.97 |
$3.08 |
$3.12 |
$3.28 |
$3.38 |
$3.46 |
$3.59 |
|
4.88% |
<-IRR #YR-> |
5 |
AEPS |
26.88% |
|
Payout Ratio |
20.89% |
20.01% |
20.46% |
22.21% |
26.55% |
38.96% |
36.37% |
44.90% |
48.71% |
50.90% |
56.73% |
53.73% |
49.89% |
52.99% |
52.55% |
51.70% |
|
2.11% |
<-IRR #YR-> |
10 |
5 yr Running Average |
23.27% |
|
5 year Running Average |
24.19% |
21.53% |
20.52% |
20.89% |
22.02% |
25.64% |
28.91% |
33.80% |
39.10% |
43.97% |
47.52% |
50.99% |
51.99% |
52.85% |
53.18% |
52.17% |
|
1.50% |
<-IRR #YR-> |
5 |
5 yr Running Average |
7.71% |
|
Price/AEPS Median |
10.38 |
10.64 |
10.88 |
13.29 |
15.30 |
16.34 |
13.33 |
16.58 |
12.96 |
14.04 |
13.49 |
12.28 |
11.96 |
11.39 |
0.00 |
0.00 |
|
13.41 |
<-Median-> |
10 |
Price/AEPS Median |
|
|
Price/AEPS High |
11.92 |
11.56 |
12.61 |
14.74 |
17.03 |
19.57 |
15.76 |
17.87 |
14.55 |
16.02 |
17.84 |
13.72 |
13.07 |
12.63 |
0.00 |
0.00 |
|
15.89 |
<-Median-> |
10 |
Price/AEPS High |
|
|
Price/AEPS Low |
8.84 |
9.71 |
9.15 |
11.85 |
13.57 |
13.12 |
10.91 |
15.28 |
11.37 |
12.05 |
9.14 |
10.85 |
10.85 |
10.16 |
0.00 |
0.00 |
|
11.61 |
<-Median-> |
10 |
Price/AEPS Low |
|
|
Price/AEPS Close |
11.66 |
10.57 |
12.61 |
13.82 |
14.71 |
14.05 |
14.25 |
15.42 |
12.48 |
15.65 |
11.89 |
12.79 |
11.45 |
10.48 |
10.40 |
10.23 |
|
13.93 |
<-Median-> |
10 |
Price/AEPS Close |
|
|
Trailing P/AEPS Close |
12.34 |
11.87 |
14.17 |
14.58 |
14.12 |
11.02 |
17.57 |
14.36 |
13.23 |
16.09 |
11.47 |
13.92 |
12.70 |
10.17 |
10.48 |
10.40 |
|
14.02 |
<-Median-> |
10 |
Trailing P/AEPS Close |
|
|
Median Values |
|
DPR |
10 Yrs |
46.80% |
5 Yrs |
50.90% |
P/CF |
5 Yrs |
in order |
12.96 |
14.55 |
10.85 |
12.48 |
|
-19.08% |
Diff M/C |
|
|
|
|
DPR 75% to 95% best |
|
|
* Adjusted Earnings per Share |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.20 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.92 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.66 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.28 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.04 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.28 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$3.50 |
<-12 mths |
8.02% |
|
|
|
|
|
|
|
pre split '13 |
$5.04 |
|
$6.48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EPS Basic |
$2.52 |
$2.82 |
$3.24 |
$3.64 |
$3.66 |
$1.34 |
$2.97 |
$1.78 |
$2.87 |
$4.49 |
$2.21 |
$2.16 |
$3.25 |
|
|
|
|
0.31% |
<-Total Growth |
10 |
EPS Basic |
|
|
pre split '05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
$5.02 |
$5.64 |
$6.48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EPS Diluted* |
$2.51 |
$2.82 |
$3.24 |
$3.62 |
$3.64 |
$1.33 |
$2.96 |
$1.77 |
$2.86 |
$4.47 |
$2.20 |
$2.15 |
$3.24 |
$3.57 |
$3.60 |
$3.69 |
|
0.00% |
<-Total Growth |
10 |
EPS Diluted |
|
|
Increase |
2.87% |
12.35% |
14.89% |
11.73% |
0.55% |
-63.46% |
122.56% |
-40.20% |
61.58% |
56.29% |
-50.78% |
-2.27% |
50.70% |
10.19% |
0.84% |
2.50% |
|
10 |
0 |
10 |
Years of Data, EPS P or N |
|
|
Earnings Yield |
8.5% |
9.4% |
8.0% |
7.8% |
7.6% |
3.7% |
6.6% |
3.9% |
7.4% |
9.0% |
6.0% |
5.0% |
7.6% |
9.5% |
9.6% |
9.8% |
|
0.00% |
<-IRR #YR-> |
10 |
Earnings per Share |
0.00% |
|
5 year Running Average |
$2.23 |
$2.45 |
$2.67 |
$2.93 |
$3.17 |
$2.93 |
$2.96 |
$2.66 |
$2.51 |
$2.68 |
$2.85 |
$2.69 |
$2.98 |
$3.13 |
$2.95 |
$3.25 |
|
12.85% |
<-IRR #YR-> |
5 |
Earnings per Share |
83.05% |
|
10 year Running Average |
$1.71 |
$1.89 |
$2.08 |
$2.34 |
$2.57 |
$2.58 |
$2.70 |
$2.67 |
$2.72 |
$2.92 |
$2.89 |
$2.82 |
$2.82 |
$2.82 |
$2.82 |
$3.05 |
|
1.13% |
<-IRR #YR-> |
10 |
5 yr Running Average |
11.84% |
|
* Diluted ESP per
share |
|
|
|
|
|
|
|
|
E/P |
10 Yrs |
7.02% |
5Yrs |
7.41% |
|
|
|
|
2.29% |
<-IRR #YR-> |
5 |
5 yr Running Average |
12.01% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.24 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.77 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.67 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.98 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.66 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.98 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend* |
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.90 |
$1.95 |
$2.01 |
|
|
Estimates |
|
Dividend* |
|
|
Increase |
|
|
|
|
|
|
|
|
|
|
|
|
|
2.88% |
2.63% |
3.08% |
|
|
Estimates |
|
Increase |
|
|
Payout Ratio EPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
53.22% |
54.17% |
54.47% |
|
|
Estimates |
|
Payout Ratio EPS |
|
|
Special Dividends |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
$0.00 |
<-Median-> |
10 |
Special Dividends |
|
|
pre split '05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
$1.06 |
$1.14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend* |
$0.5300 |
$0.5700 |
$0.6550 |
$0.7500 |
$0.8600 |
$0.9900 |
$1.1400 |
$1.3100 |
$1.5064 |
$1.6192 |
$1.7408 |
$1.7932 |
$1.8468 |
$1.9024 |
$1.9024 |
$1.9024 |
|
181.95% |
<-Total Growth |
10 |
Dividends |
|
|
Increase |
6.00% |
7.55% |
14.91% |
14.50% |
14.67% |
15.12% |
15.15% |
14.91% |
14.99% |
7.49% |
7.51% |
3.01% |
2.99% |
3.01% |
0.00% |
0.00% |
|
30 |
0 |
34 |
Years of data, Count P, N |
|
|
Average Increases 5 Year
Running |
6.88% |
6.81% |
8.33% |
9.87% |
11.53% |
13.35% |
14.87% |
14.87% |
14.97% |
13.53% |
12.01% |
9.58% |
7.20% |
4.80% |
3.30% |
1.80% |
|
12.68% |
<-Median-> |
10 |
Average Incr 5 Year Running |
|
|
Dividends 5 Yr Running |
$0.47 |
$0.50 |
$0.55 |
$0.60 |
$0.67 |
$0.77 |
$0.88 |
$1.01 |
$1.16 |
$1.31 |
$1.46 |
$1.59 |
$1.70 |
$1.78 |
$1.84 |
$1.87 |
|
212.16% |
<-Total Growth |
10 |
Dividends 5 Yr Running |
|
|
Yield H/L Price |
2.01% |
1.88% |
1.88% |
1.67% |
1.74% |
2.38% |
2.73% |
2.71% |
3.76% |
3.63% |
4.20% |
4.37% |
4.17% |
4.65% |
|
|
|
3.18% |
<-Median-> |
10 |
Yield H/L Price |
|
|
Yield on High Price |
1.75% |
1.73% |
1.62% |
1.51% |
1.56% |
1.99% |
2.31% |
2.51% |
3.35% |
3.18% |
3.18% |
3.92% |
3.82% |
4.20% |
|
|
|
2.84% |
<-Median-> |
10 |
Yield on High Price |
|
|
Yield on Low Price |
2.36% |
2.06% |
2.24% |
1.87% |
1.96% |
2.97% |
3.33% |
2.94% |
4.29% |
4.22% |
6.20% |
4.95% |
4.60% |
5.22% |
|
|
|
3.78% |
<-Median-> |
10 |
Yield on Low Price |
|
|
Yield on Close Price |
1.79% |
1.89% |
1.62% |
1.61% |
1.80% |
2.77% |
2.55% |
2.91% |
3.90% |
3.25% |
4.77% |
4.20% |
4.36% |
5.05% |
5.05% |
5.05% |
|
3.08% |
<-Median-> |
10 |
Yield on Close Price |
|
|
Payout Ratio EPS |
21.12% |
20.21% |
20.22% |
20.72% |
23.63% |
74.44% |
38.51% |
74.01% |
52.67% |
36.22% |
79.13% |
83.40% |
57.00% |
53.29% |
52.84% |
51.56% |
|
54.84% |
<-Median-> |
10 |
DPR EPS |
|
|
DPR EPS 5 Yr Running |
21.10% |
20.52% |
20.43% |
20.54% |
21.26% |
26.11% |
29.72% |
37.91% |
46.23% |
49.03% |
51.31% |
59.25% |
57.01% |
56.96% |
62.23% |
57.52% |
|
42.07% |
<-Median-> |
10 |
DPR EPS 5 Yr Running |
|
|
Payout Ratio CFPS |
6.52% |
4.44% |
4.76% |
4.45% |
5.89% |
6.78% |
7.30% |
11.29% |
17.29% |
12.04% |
10.82% |
11.00% |
8.78% |
11.53% |
10.81% |
10.69% |
|
9.80% |
<-Median-> |
10 |
DPR CF |
|
|
DPR CF 5 Yr Running |
6.35% |
5.76% |
5.42% |
5.08% |
5.08% |
5.26% |
5.83% |
6.89% |
8.91% |
10.26% |
11.18% |
12.05% |
11.25% |
10.68% |
10.50% |
10.48% |
|
7.90% |
<-Median-> |
10 |
DPR CF 5 Yr Running |
|
|
Payout Ratio CFPS WC |
6.60% |
4.09% |
4.09% |
4.33% |
5.27% |
6.82% |
6.84% |
8.29% |
9.13% |
9.70% |
11.16% |
11.40% |
9.91% |
11.53% |
10.81% |
10.69% |
|
8.71% |
<-Median-> |
10 |
DPR CF WC |
|
|
DPR CF WC 5 Yr Running |
6.20% |
5.53% |
5.04% |
4.75% |
4.70% |
4.90% |
5.44% |
6.26% |
7.28% |
8.19% |
9.00% |
9.92% |
10.23% |
10.71% |
10.93% |
10.84% |
|
6.77% |
<-Median-> |
10 |
DPR CF WC 5 Yr Running |
|
|
Median Values |
10 Yr Med |
10 Yr Cl |
3.18% |
3.08% |
5 Yr Med |
5 Yr Cl |
4.17% |
4.20% |
5 Yr Med |
Payout |
57.00% |
11.00% |
9.91% |
|
|
|
|
7.11% |
<-IRR #YR-> |
5 |
Dividends |
40.98% |
|
* Dividends per share |
10 Yr Med |
and Cur. |
59.09% |
63.98% |
5 Yr Med |
and Cur. |
21.20% |
20.35% |
Last Div Inc ---> |
$0.4617 |
$0.4756 |
3.01% |
|
|
|
|
10.92% |
<-IRR #YR-> |
10 |
Dividends |
181.95% |
|
Dividends Growth 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.04% |
<-IRR #YR-> |
15 |
Dividends |
319.73% |
|
Dividends Growth 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9.70% |
<-IRR #YR-> |
20 |
Dividends |
536.83% |
|
Dividends Growth 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.71% |
<-IRR #YR-> |
25 |
Dividends |
1173.66% |
|
Dividends Growth 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12.10% |
<-IRR #YR-> |
30 |
Dividends |
|
|
Dividends Growth 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11.20% |
<-IRR #YR-> |
34 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
|
|
|
|
|
-$1.31 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.85 |
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
Dividends Growth 10 |
|
|
-$0.66 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.85 |
|
|
|
|
|
|
|
Dividends Growth 10 |
|
|
Dividends Growth 15 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.85 |
|
|
|
|
|
|
|
Dividends Growth 15 |
|
|
Dividends Growth 20 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.85 |
|
|
|
|
|
|
|
Dividends Growth 20 |
|
|
Dividends Growth 25 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.85 |
|
|
|
|
|
|
|
Dividends Growth 25 |
|
|
Dividends Growth 30 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.85 |
|
|
|
|
|
|
|
Dividends Growth 30 |
|
|
Dividends Growth 35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.85 |
|
|
|
|
|
|
|
Dividends Growth 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Historical Dividends |
Historical |
High Div |
4.41% |
Low Div |
1.49% |
10 Yr High |
6.08% |
10 Yr Low |
1.51% |
Med Div |
2.16% |
Close Div |
2.00% |
|
|
|
|
|
|
|
Historical Dividends |
|
|
High/Ave/Median Values |
Curr diff |
Cheap |
14.61% |
Cheap |
239.21% |
Exp. |
-16.87% |
|
234.72% |
Cheap |
133.99% |
Cheap |
152.71% |
|
|
|
|
|
|
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
7.13% |
earning in |
5 |
Years |
at IRR of |
7.11% |
Div Inc. |
40.98% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
10.04% |
earning in |
10 |
Years |
at IRR of |
7.11% |
Div Inc. |
98.75% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
14.16% |
earning in |
15 |
Years |
at IRR of |
7.11% |
Div Inc. |
180.19% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$2.68 |
earning in |
5 |
Years |
at IRR of |
7.11% |
Div Inc. |
40.98% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$3.78 |
earning in |
10 |
Years |
at IRR of |
7.11% |
Div Inc. |
98.75% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$5.33 |
earning in |
15 |
Years |
at IRR of |
7.11% |
Div Inc. |
180.19% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$10.96 |
over |
5 |
Years |
at IRR of |
7.11% |
Div Cov. |
29.13% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$23.74 |
over |
10 |
Years |
at IRR of |
7.11% |
Div Cov. |
63.07% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$41.75 |
over |
15 |
Years |
at IRR of |
7.11% |
Div Cov. |
110.92% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yield if held 5 years |
2.99% |
2.69% |
2.42% |
3.38% |
4.33% |
3.76% |
3.76% |
3.76% |
3.36% |
3.27% |
4.19% |
4.29% |
3.82% |
4.75% |
4.26% |
4.59% |
|
3.76% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 10 years |
5.67% |
4.73% |
5.27% |
6.60% |
6.56% |
5.58% |
5.37% |
4.83% |
6.80% |
8.15% |
6.61% |
5.92% |
5.30% |
4.24% |
3.84% |
4.58% |
|
6.24% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 15 years |
13.05% |
10.95% |
9.23% |
8.71% |
8.94% |
10.59% |
9.45% |
10.53% |
13.26% |
12.35% |
9.81% |
8.45% |
6.81% |
8.58% |
9.58% |
7.22% |
|
9.63% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 20 years |
19.60% |
18.06% |
22.65% |
21.43% |
21.93% |
24.37% |
21.91% |
18.47% |
17.49% |
16.82% |
18.62% |
14.87% |
14.85% |
16.75% |
14.51% |
10.73% |
|
18.54% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 25 years |
|
|
|
33.56% |
36.44% |
36.62% |
36.12% |
45.31% |
43.04% |
41.29% |
42.85% |
34.46% |
26.03% |
22.09% |
19.77% |
20.35% |
|
36.53% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 30 years |
|
|
|
|
|
|
|
|
67.40% |
68.61% |
64.38% |
56.81% |
63.88% |
54.35% |
48.51% |
46.83% |
|
64.38% |
<-Median-> |
5 |
Paid Median Price |
|
|
Yield if held 35 years |
|
|
|
|
|
|
|
|
|
|
|
|
|
85.12% |
80.61% |
70.36% |
|
#NUM! |
<-Median-> |
0 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cost covered if held 5
years |
13.25% |
11.83% |
10.05% |
13.56% |
16.95% |
14.52% |
14.51% |
14.50% |
12.93% |
13.25% |
17.62% |
19.07% |
17.59% |
22.22% |
20.57% |
22.58% |
|
14.52% |
<-Median-> |
10 |
Paid Median Price |
Item |
|
Cost covered if held 10
years |
42.25% |
35.32% |
37.19% |
44.50% |
42.44% |
34.81% |
32.54% |
28.68% |
39.76% |
50.01% |
42.31% |
40.81% |
38.93% |
32.77% |
31.78% |
40.12% |
|
40.28% |
<-Median-> |
10 |
Paid Median Price |
EPS |
|
Cost covered if held 15
years |
118.77% |
101.19% |
81.41% |
73.79% |
72.88% |
83.16% |
71.75% |
77.79% |
95.62% |
92.52% |
76.06% |
70.09% |
60.07% |
79.93% |
96.27% |
77.80% |
|
74.92% |
<-Median-> |
10 |
Paid Median Price |
AEPS |
|
Cost covered if held 20
years |
190.94% |
179.72% |
216.77% |
198.79% |
197.61% |
212.92% |
185.66% |
152.60% |
141.21% |
141.10% |
161.41% |
137.82% |
146.18% |
174.00% |
162.58% |
128.76% |
|
157.00% |
<-Median-> |
10 |
Paid Median Price |
CFPS |
|
Cost covered if held 25
years |
|
|
|
324.27% |
341.42% |
332.41% |
318.97% |
391.44% |
364.68% |
365.02% |
393.02% |
338.83% |
272.51% |
244.57% |
236.53% |
261.38% |
|
340.12% |
<-Median-> |
10 |
Paid Median Price |
FCF |
|
Cost covered if held 30
years |
|
|
|
|
|
|
|
|
584.07% |
619.62% |
603.01% |
571.47% |
685.65% |
619.04% |
599.23% |
623.10% |
|
603.01% |
<-Median-> |
5 |
Paid Median Price |
|
|
Cost covered if held 35
years |
|
|
|
|
|
|
|
|
|
|
|
|
|
982.38% |
1008.84% |
948.72% |
|
#NUM! |
<-Median-> |
0 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yr |
Item |
Tot. Growth |
Revenue Growth |
|
|
|
|
|
|
|
$4,541 |
$4,888 |
$4,706 |
$3,944 |
$4,289 |
$4,978 |
$27,346 |
|
|
|
9.62% |
<-Total Growth |
5 |
Revenue Growth |
9.62% |
|
AEPS Growth |
|
|
|
|
|
|
|
$2.92 |
$3.09 |
$3.18 |
$3.07 |
$3.34 |
$3.70 |
$19.30 |
|
|
|
26.88% |
<-Total Growth |
5 |
AEPS Growth |
26.88% |
|
Net Income Growth |
|
|
|
|
|
|
|
$203 |
$328 |
$513 |
$252 |
$246 |
$370 |
$1,912 |
|
|
|
82.27% |
<-Total Growth |
5 |
Net Income Growth |
82.27% |
|
Cash Flow Growth |
|
|
|
|
|
|
|
$1,331 |
$999 |
$1,542 |
$1,843 |
$1,864 |
$2,396 |
$9,975 |
|
|
|
80.02% |
<-Total Growth |
5 |
Cash Flow Growth |
80.02% |
|
Dividend Growth |
|
|
|
|
|
|
|
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$1.85 |
$9.82 |
|
|
|
40.98% |
<-Total Growth |
5 |
Dividend Growth |
40.98% |
|
Stock Price Growth |
|
|
|
|
|
|
|
$45.00 |
$38.61 |
$49.77 |
$36.49 |
$42.70 |
$42.38 |
|
|
|
|
-5.82% |
<-Total Growth |
5 |
Stock Price Growth |
-5.82% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenue Growth |
|
|
$4,362 |
$4,359 |
$4,554 |
$4,131 |
$4,045 |
$4,541 |
$4,888 |
$4,706 |
$3,944 |
$4,289 |
$4,978 |
$48,797 |
|
|
|
14.12% |
<-Total Growth |
10 |
Revenue Growth |
14.12% |
|
AEPS Growth |
|
|
$3.20 |
$3.38 |
$3.24 |
$2.54 |
$3.13 |
$2.92 |
$3.09 |
$3.18 |
$3.07 |
$3.34 |
$3.70 |
$34.79 |
|
|
|
15.65% |
<-Total Growth |
10 |
AEPS Growth |
15.65% |
|
Net Income Growth |
|
|
$375 |
$418 |
$420 |
$154 |
$340 |
$203 |
$328 |
$513 |
$252 |
$246 |
$370 |
$3,619 |
|
|
|
-1.33% |
<-Total Growth |
10 |
Net Income Growth |
-1.33% |
|
Cash Flow Growth |
|
|
$1,584 |
$1,939 |
$1,681 |
$1,680 |
$1,790 |
$1,331 |
$999 |
$1,542 |
$1,843 |
$1,864 |
$2,396 |
$18,649 |
|
|
|
51.26% |
<-Total Growth |
10 |
Cash Flow Growth |
51.26% |
|
Dividend Growth |
|
|
$0.66 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$1.85 |
$14.2 |
|
|
|
181.95% |
<-Total Growth |
10 |
Dividend Growth |
181.95% |
|
Stock Price Growth |
|
|
$40.36 |
$46.66 |
$47.66 |
$35.70 |
$44.66 |
$45.00 |
$38.61 |
$49.77 |
$36.49 |
$42.70 |
$42.38 |
|
|
|
|
5.00% |
<-Total Growth |
10 |
Stock Price Growth |
5.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends on Shares |
|
|
|
$18.75 |
$21.50 |
$24.75 |
$28.50 |
$32.75 |
$37.66 |
$40.48 |
$43.52 |
$44.83 |
$46.17 |
$47.56 |
$47.56 |
$47.56 |
|
$338.91 |
No of Years |
10 |
Total Divs |
12/31/12 |
|
Paid |
|
|
$1,009.00 |
$1,166.50 |
$1,191.50 |
$892.50 |
$1,116.50 |
$1,125.00 |
$965.25 |
$1,244.25 |
$912.25 |
$1,067.50 |
$1,059.50 |
$941.00 |
$941.00 |
$941.00 |
|
$1,059.50 |
No of Years |
10 |
Worth |
$40.36 |
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1,398.41 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. AEPS |
$33.03 |
$34.65 |
$38.50 |
$43.44 |
$44.49 |
$40.84 |
$46.70 |
$45.35 |
$47.74 |
$49.97 |
$49.42 |
$51.95 |
$56.57 |
$56.11 |
$56.34 |
$56.80 |
|
46.93% |
<-Total Growth |
10 |
Graham Price AEPS |
|
|
Price/GP Ratio Med |
0.80 |
0.87 |
0.90 |
1.03 |
1.11 |
1.02 |
0.89 |
1.07 |
0.84 |
0.89 |
0.84 |
0.79 |
0.78 |
0.73 |
|
|
|
0.89 |
<-Median-> |
10 |
Graham Price |
|
|
Price/GP Ratio High |
0.92 |
0.95 |
1.05 |
1.15 |
1.24 |
1.22 |
1.06 |
1.15 |
0.94 |
1.02 |
1.11 |
0.88 |
0.86 |
0.81 |
|
|
|
1.08 |
<-Median-> |
10 |
Graham Price |
|
|
Price/GP Ratio Low |
0.68 |
0.80 |
0.76 |
0.92 |
0.99 |
0.82 |
0.73 |
0.98 |
0.74 |
0.77 |
0.57 |
0.70 |
0.71 |
0.65 |
|
|
|
0.75 |
<-Median-> |
10 |
Graham Price |
|
|
Price/GP Ratio Close |
0.90 |
0.87 |
1.05 |
1.07 |
1.07 |
0.87 |
0.96 |
0.99 |
0.81 |
1.00 |
0.74 |
0.82 |
0.75 |
0.67 |
0.67 |
0.66 |
|
0.92 |
<-Median-> |
10 |
Graham Price |
|
|
Prem/Disc Close |
-10.46% |
-13.07% |
4.84% |
7.40% |
7.13% |
-12.59% |
-4.38% |
-0.78% |
-19.12% |
-0.39% |
-26.16% |
-17.81% |
-25.08% |
-32.91% |
-33.19% |
-33.74% |
|
-8.49% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. EPS |
$32.85 |
$34.48 |
$38.73 |
$44.98 |
$47.16 |
$29.55 |
$45.39 |
$35.33 |
$45.91 |
$59.23 |
$41.85 |
$41.70 |
$52.92 |
$55.95 |
$56.18 |
$56.88 |
|
36.63% |
<-Total Growth |
10 |
Graham Price EPS |
|
|
Price/GP Ratio Med |
0.80 |
0.88 |
0.90 |
1.00 |
1.05 |
1.41 |
0.92 |
1.37 |
0.87 |
0.75 |
0.99 |
0.98 |
0.84 |
0.73 |
|
|
|
0.99 |
<-Median-> |
10 |
Graham Price |
|
|
Price/GP Ratio High |
0.92 |
0.95 |
1.04 |
1.11 |
1.17 |
1.68 |
1.09 |
1.48 |
0.98 |
0.86 |
1.31 |
1.10 |
0.91 |
0.81 |
|
|
|
1.10 |
<-Median-> |
10 |
Graham Price |
|
|
Price/GP Ratio Low |
0.68 |
0.80 |
0.76 |
0.89 |
0.93 |
1.13 |
0.75 |
1.26 |
0.77 |
0.65 |
0.67 |
0.87 |
0.76 |
0.65 |
|
|
|
0.82 |
<-Median-> |
10 |
Graham Price |
|
|
Price/GP Ratio Close |
0.90 |
0.87 |
1.04 |
1.04 |
1.01 |
1.21 |
0.98 |
1.27 |
0.84 |
0.84 |
0.87 |
1.02 |
0.80 |
0.67 |
0.67 |
0.66 |
|
1.00 |
<-Median-> |
10 |
Graham Price |
|
|
Prem/Disc Close |
-9.97% |
-12.64% |
4.20% |
3.73% |
1.06% |
20.82% |
-1.60% |
27.38% |
-15.89% |
-15.97% |
-12.80% |
2.41% |
-19.92% |
-32.72% |
-33.00% |
-33.83% |
|
-0.27% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
$59.15 |
$60.24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price Close |
$29.58 |
$30.12 |
$40.36 |
$46.66 |
$47.66 |
$35.70 |
$44.66 |
$45.00 |
$38.61 |
$49.77 |
$36.49 |
$42.70 |
$42.38 |
$37.64 |
$37.64 |
$37.64 |
|
5.00% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
28.11% |
1.84% |
34.00% |
15.61% |
2.14% |
-25.09% |
25.10% |
0.76% |
-14.20% |
28.90% |
-26.68% |
17.02% |
-0.75% |
-11.18% |
0.00% |
0.00% |
|
15.82 |
<-Median-> |
10 |
CAPE (10 Yr P/E) |
|
|
P/E |
11.78 |
10.68 |
12.46 |
12.89 |
13.09 |
26.84 |
15.09 |
25.42 |
13.50 |
11.13 |
16.59 |
19.86 |
13.08 |
10.54 |
10.46 |
10.20 |
|
-1.19% |
<-IRR #YR-> |
5 |
Stock Price |
-5.82% |
|
Trailing P/E |
12.12 |
12.00 |
14.31 |
14.40 |
13.17 |
9.81 |
33.58 |
15.20 |
21.81 |
17.40 |
8.16 |
19.41 |
19.71 |
11.62 |
10.54 |
10.46 |
|
0.49% |
<-IRR #YR-> |
10 |
Stock Price |
5.00% |
|
CAPE (10 Yr P/E) |
17.25 |
15.90 |
19.38 |
19.97 |
18.56 |
13.85 |
16.53 |
16.88 |
14.20 |
17.03 |
12.62 |
15.12 |
15.01 |
13.35 |
13.37 |
12.34 |
|
2.67% |
<-IRR #YR-> |
5 |
Price & Dividend |
13.08% |
|
Median 10, 5 Yrs |
|
D. per yr |
3.19% |
3.86% |
% Tot Ret |
86.71% |
144.72% |
|
Price Inc |
-0.75% |
P/E: |
14.29 |
13.50 |
|
|
|
|
3.68% |
<-IRR #YR-> |
10 |
Price & Dividend |
38.59% |
|
Price 15 |
|
D. per yr |
2.94% |
|
% Tot Ret |
50.34% |
|
|
|
|
|
CAPE Diff |
-33.37% |
|
|
|
|
2.90% |
<-IRR #YR-> |
15 |
Stock Price |
53.52% |
|
Price 20 |
|
D. per yr |
3.65% |
|
% Tot Ret |
33.98% |
|
|
|
|
|
|
|
|
|
|
|
7.10% |
<-IRR #YR-> |
20 |
Stock Price |
294.23% |
|
Price 25 |
|
D. per yr |
3.25% |
|
% Tot Ret |
32.44% |
|
|
|
|
|
|
|
|
|
|
|
6.76% |
<-IRR #YR-> |
25 |
Stock Price |
413.70% |
|
Price 30 |
|
D. per yr |
3.91% |
|
% Tot Ret |
29.95% |
|
|
|
|
|
|
|
|
|
|
|
9.16% |
<-IRR #YR-> |
30 |
Stock Price |
|
|
Price 35 |
|
D. per yr |
3.87% |
|
% Tot Ret |
28.84% |
|
|
|
|
|
|
|
|
|
|
|
9.54% |
<-IRR #YR-> |
34 |
Stock Price |
|
|
Price & Dividend 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.84% |
<-IRR #YR-> |
15 |
Price & Dividend |
112.50% |
|
Price & Dividend 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.75% |
<-IRR #YR-> |
20 |
Price & Dividend |
463.36% |
|
Price & Dividend 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.01% |
<-IRR #YR-> |
25 |
Price & Dividend |
6.4801697 |
|
Price & Dividend 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13.07% |
<-IRR #YR-> |
30 |
Price & Dividend |
|
|
Price & Dividend 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13.41% |
<-IRR #YR-> |
34 |
Price & Dividend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price 5 |
|
|
|
|
|
|
|
-$45.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$42.38 |
|
|
|
|
|
|
|
Price 5 |
|
|
Price 10 |
|
|
-$40.36 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$42.38 |
|
|
|
|
|
|
|
Price 10 |
|
|
Price & Dividend 5 |
|
|
|
|
|
|
|
-$45.00 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$44.23 |
|
|
|
|
|
|
|
Price & Dividend 5 |
|
|
Price & Dividend 10 |
|
|
-$40.36 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$44.23 |
|
|
|
|
|
|
|
Price & Dividend 10 |
|
|
Price 15 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$42.38 |
|
|
|
|
|
|
|
Price 15 |
|
|
Price 20 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$42.38 |
|
|
|
|
|
|
|
Price 20 |
|
|
Price 25 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$42.38 |
|
|
|
|
|
|
|
Price 25 |
|
|
Price 30 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$42.38 |
|
|
|
|
|
|
|
Price 30 |
|
|
Price 35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$42.38 |
|
|
|
|
|
|
|
Price 35 |
|
|
Price & Dividend 15 |
$0.53 |
$0.57 |
$0.66 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$44.23 |
|
|
|
|
|
|
|
Price & Dividend 15 |
|
|
Price & Dividend 20 |
$0.53 |
$0.57 |
$0.66 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$44.23 |
|
|
|
|
|
|
|
Price & Dividend 20 |
|
|
Price & Dividend 25 |
$0.53 |
$0.57 |
$0.66 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$44.23 |
|
|
|
|
|
|
|
Price & Dividend 25 |
|
|
Price & Dividend 30 |
$0.53 |
$0.57 |
$0.66 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$44.23 |
|
|
|
|
|
|
|
Price & Dividend 30 |
|
|
Price & Dividend 35 |
$0.53 |
$0.57 |
$0.66 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$44.23 |
|
|
|
|
|
|
|
Price & Dividend 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price Med. H/L Med |
$26.34 |
$30.30 |
$34.83 |
$44.89 |
$49.57 |
$41.54 |
$41.80 |
$48.36 |
$40.07 |
$44.65 |
$41.41 |
$41.00 |
$44.29 |
$40.90 |
|
|
|
27.16% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
32.62% |
15.05% |
14.94% |
28.90% |
10.41% |
-16.20% |
0.64% |
15.69% |
-17.14% |
11.43% |
-7.27% |
-0.99% |
8.03% |
-7.65% |
|
|
|
2.43% |
<-IRR #YR-> |
10 |
Stock Price |
27.16% |
|
P/E |
10.49 |
10.74 |
10.75 |
12.40 |
13.62 |
31.23 |
14.12 |
27.32 |
14.01 |
9.99 |
18.82 |
19.07 |
13.67 |
11.46 |
|
|
|
-1.75% |
<-IRR #YR-> |
5 |
Stock Price |
-8.43% |
|
Trailing P/E |
10.79 |
12.07 |
12.35 |
13.85 |
13.69 |
11.41 |
31.43 |
16.34 |
22.64 |
15.61 |
9.26 |
18.63 |
20.60 |
12.62 |
|
|
|
5.80% |
<-IRR #YR-> |
10 |
Price & Dividend |
9.16% |
|
P/E on Run. 5 yr Ave |
11.83 |
12.39 |
13.05 |
15.34 |
15.66 |
14.18 |
14.13 |
18.15 |
15.95 |
16.67 |
14.52 |
15.24 |
14.84 |
13.08 |
|
|
|
1.89% |
<-IRR #YR-> |
5 |
Price & Dividend |
66.09% |
|
P/E on Run. 10 yr Ave |
15.36 |
16.00 |
16.72 |
19.21 |
19.30 |
16.11 |
15.47 |
18.14 |
14.74 |
15.28 |
14.32 |
14.52 |
15.68 |
14.51 |
|
|
|
10.59 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
D. per yr |
3.36% |
3.63% |
% Tot Ret |
58.04% |
192.41% |
T P/E |
15.97 |
18.63 |
P/E: |
14.07 |
14.01 |
|
|
|
|
|
Count |
35 |
Years of data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$34.83 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$44.29 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$48.36 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$44.29 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$34.83 |
$0.75 |
$0.86 |
$0.99 |
$1.14 |
$1.31 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$46.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$48.36 |
$1.51 |
$1.62 |
$1.74 |
$1.79 |
$46.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
High Months |
Dec |
May |
Dec |
Nov |
Apr |
Feb |
Aug |
Mar |
Jan |
Dec |
Feb |
Jun |
Aug |
May |
|
|
|
|
|
|
|
|
|
pre split '05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
$60.48 |
$65.85 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price High |
$30.24 |
$32.93 |
$40.36 |
$49.77 |
$55.17 |
$49.72 |
$49.40 |
$52.15 |
$44.99 |
$50.96 |
$54.75 |
$45.78 |
$48.39 |
$45.33 |
|
|
|
19.90% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
30.99% |
8.88% |
22.58% |
23.32% |
10.85% |
-9.88% |
-0.64% |
5.57% |
-13.73% |
13.27% |
7.44% |
-16.38% |
5.70% |
-6.32% |
|
|
|
1.83% |
<-IRR #YR-> |
10 |
Stock Price |
19.90% |
|
P/E |
12.05 |
11.68 |
12.46 |
13.75 |
15.16 |
37.38 |
16.69 |
29.46 |
15.73 |
11.40 |
24.89 |
21.29 |
14.94 |
12.70 |
|
|
|
-1.49% |
<-IRR #YR-> |
5 |
Stock Price |
-7.21% |
|
Trailing P/E |
12.39 |
13.12 |
14.31 |
15.36 |
15.24 |
13.66 |
37.14 |
17.62 |
25.42 |
17.82 |
12.25 |
20.81 |
22.51 |
13.99 |
|
|
|
12.31 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
17.72 |
20.81 |
P/E: |
16.21 |
15.73 |
|
|
|
|
15.62 |
P/E Ratio |
|
Historical High |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$40.36 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$48.39 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$52.15 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$48.39 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Low Months |
Feb |
Aug |
Jan |
Jan |
Dec |
Dec |
Jan |
Jan |
Oct |
Jan |
Mar |
Jan |
Oct |
Aug |
|
|
|
|
|
|
|
|
|
pre split '05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
$44.86 |
$55.34 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price Low |
$22.43 |
$27.67 |
$29.29 |
$40.01 |
$43.96 |
$33.35 |
$34.20 |
$44.57 |
$35.15 |
$38.34 |
$28.06 |
$36.21 |
$40.18 |
$36.46 |
|
|
|
37.18% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
34.88% |
23.36% |
5.85% |
36.60% |
9.87% |
-24.14% |
2.55% |
30.32% |
-21.14% |
9.08% |
-26.81% |
29.04% |
10.96% |
-9.26% |
|
|
|
3.21% |
<-IRR #YR-> |
10 |
Stock Price |
37.18% |
|
P/E |
8.94 |
9.81 |
9.04 |
11.05 |
12.08 |
25.08 |
11.55 |
25.18 |
12.29 |
8.58 |
12.75 |
16.84 |
12.40 |
10.21 |
|
|
|
-2.05% |
<-IRR #YR-> |
5 |
Stock Price |
-9.85% |
|
Trailing P/E |
9.19 |
11.02 |
10.39 |
12.35 |
12.14 |
9.16 |
25.71 |
15.06 |
19.86 |
13.41 |
6.28 |
16.46 |
18.69 |
11.25 |
|
|
|
9.04 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
14.23 |
16.46 |
P/E: |
12.35 |
12.40 |
|
|
|
|
7.36 |
P/E Ratio |
|
Historical Low |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$29.29 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$40.18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$44.57 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$40.18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$390 |
<-12 mths |
-52.03% |
|
|
|
|
|
|
|
Free Cash Flow WSJ |
|
|
|
|
|
-$327 |
$58 |
-$314 |
-$607 |
-$84 |
$490 |
$263 |
$535 |
|
|
|
|
263.61% |
<-Total Growth |
7 |
Free Cash Flow WSJ |
WSJ, MS |
|
Change |
|
|
|
|
|
|
117.74% |
-641.38% |
-93.31% |
86.16% |
683.33% |
-46.33% |
103.42% |
|
|
|
|
$0.86 |
<-Median-> |
7 |
Change |
MktS |
|
Free Cash Flow MS |
$311 |
-$17 |
-$905 |
-$529 |
-$616 |
-$91 |
$357 |
$2 |
-$235 |
$340 |
$815 |
$518 |
$813 |
$746 |
$862 |
$864 |
|
189.83% |
<-Total Growth |
10 |
Free Cash Flow |
Disagree |
|
Change |
|
-105.47% |
-5223.53% |
41.55% |
-16.45% |
85.23% |
492.31% |
-99.44% |
-11850% |
244.68% |
139.71% |
-36.44% |
56.95% |
-8.24% |
15.55% |
0.23% |
|
232.52% |
<-IRR #YR-> |
5 |
Free Cash Flow MS |
40550.00% |
|
FCF/CF from Op Ratio |
0.33 |
-0.01 |
-0.57 |
-0.27 |
-0.37 |
-0.05 |
0.20 |
0.00 |
-0.24 |
0.22 |
0.44 |
0.28 |
0.34 |
0.40 |
0.43 |
0.43 |
|
#NUM! |
<-IRR #YR-> |
10 |
Free Cash Flow MS |
189.83% |
|
Dividends paid |
$61 |
$66 |
$75 |
$86 |
$99 |
$114 |
$1,631 |
$150 |
$173 |
$186 |
$200 |
$205 |
$205 |
$217 |
$217 |
$217 |
|
172.11% |
<-Total Growth |
10 |
Dividends paid |
|
|
Percentage paid |
|
|
|
|
|
-125.27% |
456.86% |
7500.00% |
-73.62% |
54.71% |
24.54% |
39.58% |
25.22% |
29.05% |
25.14% |
25.08% |
|
$0.32 |
<-Median-> |
8 |
Percentage paid |
|
|
5 Year Coverage |
|
|
|
|
|
|
|
|
|
604.29% |
182.96% |
63.47% |
43.05% |
31.33% |
27.79% |
27.88% |
|
|
|
|
5 Year Coverage |
|
|
Dividend
Coverage Ratio |
|
|
|
|
|
-0.80 |
0.22 |
0.01 |
-1.36 |
1.83 |
4.08 |
2.53 |
3.97 |
3.44 |
3.98 |
3.99 |
|
1.02 |
<-Median-> |
8 |
Dividend Coverage Ratio |
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
0.17 |
0.55 |
1.58 |
2.32 |
3.19 |
3.60 |
3.59 |
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2 |
$0 |
$0 |
$0 |
$0 |
$813 |
|
|
|
|
|
|
|
|
|
|
|
|
|
$905 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$813 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Market Cap in $M |
$3,426 |
$3,478 |
$4,642 |
$5,372 |
$5,488 |
$4,106 |
$5,120 |
$5,160 |
$4,427 |
$5,707 |
$4,180 |
$4,884 |
$4,828 |
$4,288 |
$4,288 |
$4,288 |
|
4.00% |
<-Total Growth |
10 |
Market Cap |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
58.33 |
57.93 |
57.51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Diluted # of Shares in
Million |
116.65 |
115.85 |
115.60 |
115.50 |
115.46 |
115.30 |
114.85 |
114.82 |
114.79 |
114.75 |
114.71 |
114.45 |
114.27 |
114.27 |
114.27 |
114.27 |
|
-1.15% |
<-Total Growth |
10 |
Diluted |
|
|
Change |
0.44% |
-0.68% |
-0.22% |
-0.08% |
-0.04% |
-0.14% |
-0.39% |
-0.02% |
-0.03% |
-0.04% |
-0.03% |
-0.23% |
-0.16% |
0.00% |
0.00% |
0.00% |
|
-0.06% |
<-Median-> |
10 |
Change |
|
|
Difference Diluted/Basic |
-0.3% |
-0.3% |
-0.5% |
-0.6% |
-0.5% |
-0.4% |
-0.4% |
-0.4% |
-0.3% |
-0.3% |
-0.3% |
-0.2% |
-0.3% |
-0.3% |
-0.3% |
-0.3% |
|
-0.36% |
<-Median-> |
10 |
Difference Diluted/Basic |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
58.17 |
57.78 |
57.51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Basic # of Shares in
Millions |
116.34 |
115.56 |
115.02 |
114.80 |
114.85 |
114.83 |
114.41 |
114.35 |
114.39 |
114.37 |
114.40 |
114.17 |
113.96 |
113.96 |
113.96 |
113.96 |
|
-0.93% |
<-Total Growth |
10 |
Average |
|
|
Change |
0.47% |
-0.68% |
-0.46% |
-0.19% |
0.04% |
-0.01% |
-0.37% |
-0.05% |
0.04% |
-0.02% |
0.02% |
-0.20% |
-0.19% |
0.00% |
0.00% |
0.00% |
|
-0.04% |
<-Median-> |
10 |
Change |
|
|
Difference
Basic/Outstanding |
-0.4% |
-0.1% |
0.0% |
0.3% |
0.3% |
0.2% |
0.2% |
0.3% |
0.2% |
0.3% |
0.1% |
0.2% |
0.0% |
0.0% |
0.0% |
0.0% |
|
0.22% |
<-Median-> |
10 |
Difference Basic/Outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2,061 |
<-12 mths |
-13.98% |
|
|
|
|
|
|
|
pre split '05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Class I |
51.071 |
50.891 |
50.679 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Class II |
6.853 |
6.839 |
6.829 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pre split '13 |
57.924 |
57.730 |
57.508 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Class I Non-Voting |
102.142 |
101.782 |
101.358 |
101.473 |
101.506 |
101.451 |
101.221 |
101.328 |
101.429 |
101.464 |
101.348 |
101.188 |
101.369 |
101.369 |
101.369 |
101.369 |
|
0.01% |
<-Total Growth |
10 |
Class I Non-Voting |
88.99% |
|
Class II Voting |
13.707 |
13.677 |
13.659 |
13.651 |
13.635 |
13.573 |
13.432 |
13.331 |
13.231 |
13.203 |
13.196 |
13.196 |
12.543 |
12.543 |
12.543 |
12.543 |
|
-8.17% |
<-Total Growth |
10 |
Class II Voting |
11.01% |
|
# of Share in Millions |
115.849 |
115.459 |
115.017 |
115.124 |
115.141 |
115.024 |
114.653 |
114.660 |
114.660 |
114.667 |
114.544 |
114.384 |
113.913 |
113.913 |
113.913 |
113.913 |
|
-0.10% |
<-IRR #YR-> |
10 |
Shares |
-0.96% |
|
Increase |
-0.51% |
-0.34% |
-0.38% |
0.09% |
0.02% |
-0.10% |
-0.32% |
0.01% |
0.00% |
0.01% |
-0.11% |
-0.14% |
-0.41% |
0.00% |
0.00% |
0.00% |
|
-0.13% |
<-IRR #YR-> |
5 |
Shares |
-0.65% |
|
CF fr Op $M |
$942.1 |
$1,483.0 |
$1,584 |
$1,939 |
$1,681 |
$1,680 |
$1,790 |
$1,331 |
$999 |
$1,542 |
$1,843 |
$1,864 |
$2,396 |
$1,880 |
$2,005 |
$2,028 |
|
51.26% |
<-Total Growth |
10 |
Cash Flow |
|
|
Increase |
6.90% |
57.41% |
6.81% |
22.41% |
-13.31% |
-0.06% |
6.55% |
-25.64% |
-24.94% |
54.35% |
19.52% |
1.14% |
28.54% |
-21.55% |
6.67% |
1.14% |
|
SO, |
Buy Backs |
|
Conv Class II to Class I |
|
|
5 year Running Average |
$859 |
$1,009 |
$1,161 |
$1,366 |
$1,526 |
$1,673 |
$1,735 |
$1,684 |
$1,496 |
$1,468 |
$1,501 |
$1,516 |
$1,729 |
$1,905 |
$1,997 |
$2,034 |
|
48.90% |
<-Total Growth |
10 |
CF 5 Yr Running |
|
|
CFPS |
$8.13 |
$12.84 |
$13.77 |
$16.84 |
$14.60 |
$14.61 |
$15.61 |
$11.61 |
$8.71 |
$13.45 |
$16.09 |
$16.30 |
$21.03 |
$16.50 |
$17.60 |
$17.80 |
|
52.73% |
<-Total Growth |
10 |
Cash Flow per Share |
|
|
Increase |
7.44% |
57.95% |
7.22% |
22.30% |
-13.32% |
0.04% |
6.89% |
-25.65% |
-24.94% |
54.35% |
19.65% |
1.28% |
29.07% |
-21.55% |
6.67% |
1.14% |
|
4.23% |
<-IRR #YR-> |
10 |
Cash Flow |
51.26% |
|
5 year Running Average |
$7.40 |
$8.72 |
$10.05 |
$11.83 |
$13.24 |
$14.53 |
$15.09 |
$14.65 |
$13.03 |
$12.80 |
$13.09 |
$13.23 |
$15.12 |
$16.67 |
$17.50 |
$17.85 |
|
12.48% |
<-IRR #YR-> |
5 |
Cash Flow |
80.02% |
|
P/CF on Med Price |
3.24 |
2.36 |
2.53 |
2.67 |
3.39 |
2.84 |
2.68 |
4.17 |
4.60 |
3.32 |
2.57 |
2.52 |
2.11 |
2.48 |
0.00 |
0.00 |
|
4.33% |
<-IRR #YR-> |
10 |
Cash Flow per Share |
52.73% |
|
P/CF on Closing Price |
3.64 |
2.34 |
2.93 |
2.77 |
3.26 |
2.44 |
2.86 |
3.88 |
4.43 |
3.70 |
2.27 |
2.62 |
2.01 |
2.28 |
2.14 |
2.11 |
|
12.62% |
<-IRR #YR-> |
5 |
Cash Flow per Share |
81.20% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-17.36% |
Diff M/C |
|
4.17% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
50.46% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1,972 |
<-12 mths |
-7.07% |
|
|
|
|
|
|
|
Excl.Working Capital CF |
-$12.2 |
$126.0 |
$259.0 |
$54.0 |
$198.0 |
-$10.0 |
$122.0 |
$480.0 |
$893.0 |
$372.0 |
-$56.0 |
-$65.0 |
-$274.0 |
$0 |
$0 |
$0 |
|
0.62% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
3.15% |
|
CF fr Op $M WC |
$929.9 |
$1,609.0 |
$1,843 |
$1,993 |
$1,879 |
$1,670 |
$1,912 |
$1,811 |
$1,892 |
$1,914 |
$1,787 |
$1,799 |
$2,122 |
$1,880 |
$2,005 |
$2,028 |
|
15.14% |
<-Total Growth |
10 |
Cash Flow less WC |
|
|
Increase |
-0.56% |
73.03% |
14.54% |
8.14% |
-5.72% |
-11.12% |
14.49% |
-5.28% |
4.47% |
1.16% |
-6.64% |
0.67% |
17.95% |
-11.43% |
6.67% |
1.14% |
|
1.42% |
<-IRR #YR-> |
10 |
Cash Flow less WC |
15.14% |
|
5 year Running Average |
$880 |
$1,050 |
$1,250 |
$1,462 |
$1,651 |
$1,799 |
$1,859 |
$1,853 |
$1,833 |
$1,840 |
$1,863 |
$1,841 |
$1,903 |
$1,900 |
$1,918 |
$1,967 |
|
3.22% |
<-IRR #YR-> |
5 |
Cash Flow less WC |
17.17% |
|
CFPS Excl. WC |
$8.03 |
$13.94 |
$16.02 |
$17.31 |
$16.32 |
$14.52 |
$16.68 |
$15.79 |
$16.50 |
$16.69 |
$15.60 |
$15.73 |
$18.63 |
$16.50 |
$17.60 |
$17.80 |
|
4.29% |
<-IRR #YR-> |
10 |
CF less WC 5 Yr Run |
52.26% |
|
Increase |
-0.05% |
73.61% |
14.98% |
8.04% |
-5.73% |
-11.03% |
14.86% |
-5.29% |
4.47% |
1.16% |
-6.54% |
0.81% |
18.44% |
-11.43% |
6.67% |
1.14% |
|
0.53% |
<-IRR #YR-> |
5 |
CF less WC 5 Yr Run |
2.69% |
|
5 year Running Average |
$7.58 |
$9.08 |
$10.82 |
$12.67 |
$14.32 |
$15.62 |
$16.17 |
$16.12 |
$15.96 |
$16.04 |
$16.25 |
$16.06 |
$16.63 |
$16.63 |
$16.81 |
$17.25 |
|
1.52% |
<-IRR #YR-> |
10 |
CFPS - Less WC |
16.25% |
|
P/CF on Med Price |
3.28 |
2.17 |
2.17 |
2.59 |
3.04 |
2.86 |
2.51 |
3.06 |
2.43 |
2.67 |
2.65 |
2.61 |
2.38 |
2.48 |
0.00 |
0.00 |
|
3.36% |
<-IRR #YR-> |
5 |
CFPS - Less WC |
17.94% |
|
P/CF on Closing Price |
3.68 |
2.16 |
2.52 |
2.70 |
2.92 |
2.46 |
2.68 |
2.85 |
2.34 |
2.98 |
2.34 |
2.71 |
2.28 |
2.28 |
2.14 |
2.11 |
|
4.40% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
53.76% |
|
*Operational Cash Flow per
share |
|
|
CF/-WC |
P/CF Med |
10 yr |
2.76 |
5 yr |
2.57 |
P/CF Med |
10 yr |
2.63 |
5 yr |
2.61 |
|
-13.27% |
Diff M/C |
|
0.62% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
3.14% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-115.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
113.9 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
|
|
|
|
|
-114.7 |
0.0 |
0.0 |
0.0 |
0.0 |
113.9 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
-$1,584 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$2,396 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
|
|
|
|
|
-$1,331 |
$0 |
$0 |
$0 |
$0 |
$2,396 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
-$13.77 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$21.03 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
|
|
|
|
|
-$11.61 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$21.03 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
-$10.05 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$15.12 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$14.65 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$15.12 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
-$1,843 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$2,122 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
|
|
|
|
|
-$1,811 |
$0 |
$0 |
$0 |
$0 |
$2,122 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
-$1,250 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$1,903 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
|
|
|
|
|
-$1,853 |
$0 |
$0 |
$0 |
$0 |
$1,903 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
-$16.02 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$18.63 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
|
|
|
|
|
-$15.79 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$18.63 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
-$10.82 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$16.63 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$16.12 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$16.63 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable |
|
|
|
|
|
$47 |
$5 |
-$114 |
-$55 |
$64 |
$28 |
-$110 |
-$120 |
|
|
|
|
|
|
|
|
|
|
Inventories |
|
|
|
|
|
-$26 |
$25 |
-$11 |
$6 |
-$5 |
-$2 |
$12 |
-$9 |
|
|
|
|
|
|
|
|
|
|
Prepaid Expenses & other C. assets |
|
|
|
|
|
$13 |
$2 |
-$10 |
-$149 |
-$37 |
-$4 |
-$4 |
$6 |
|
|
|
|
|
|
|
|
|
|
Accounts Payable and accrued liabilites |
|
|
|
|
$16 |
-$9 |
$133 |
$140 |
-$202 |
$12 |
$115 |
$281 |
|
|
|
|
|
|
|
|
|
|
provisions and other current liabilites. |
|
|
|
|
$41 |
-$68 |
$36 |
-$37 |
-$25 |
$5 |
-$9 |
-$11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chges in NC WC |
$12 |
-$31 |
-$105 |
$70 |
-$105 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Div, Distri rec |
|
|
|
|
|
|
|
$2 |
$5 |
$13 |
|
$46 |
$73 |
|
|
|
|
|
|
|
|
|
|
Dividend rece from Associate Co |
|
|
|
|
|
|
|
|
|
|
$17 |
$15 |
$15 |
|
|
|
|
|
|
|
|
|
|
Interest Rec |
|
|
|
|
|
|
|
|
|
|
|
|
$39 |
|
|
|
|
|
|
|
|
|
|
Income Taxes paid |
|
-$95 |
-$154 |
-$124 |
-$93 |
-$81 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chge in Receivable under service conession
arrangment |
|
|
|
|
-$77 |
-$516 |
-$803 |
-$180 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sum |
$12 |
-$126 |
-$259 |
-$54 |
-$198 |
$10 |
-$122 |
-$480 |
-$893 |
-$372 |
$56 |
$65 |
$274 |
|
|
|
|
|
|
|
|
|
|
Google --> TD
2017 |
|
|
-$259 |
-$54 |
-$198 |
$10 |
-$185 |
-$562 |
-$948 |
-$466 |
$56 |
$65 |
$274 |
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
$0 |
$0 |
$0 |
$0 |
$63 |
$82 |
$55 |
$94 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
TD |
|
|
|
-$54 |
-$198 |
$10 |
-$122 |
-$480 |
-$893 |
-$372 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2021 |
2021 |
2021 |
2021 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPM |
8.5% |
8.2% |
8.6% |
9.6% |
9.2% |
3.7% |
8.4% |
4.5% |
6.7% |
10.9% |
6.4% |
5.7% |
7.4% |
8.0% |
|
|
|
-13.54% |
<-Total Growth |
10 |
OPM |
|
|
Increase |
-6.71% |
-3.62% |
4.93% |
11.54% |
-3.82% |
-59.58% |
125.47% |
-46.82% |
50.11% |
62.45% |
-41.39% |
-10.23% |
29.59% |
7.11% |
|
|
|
|
Should increase |
|
or be stable. |
|
|
Diff from Ave |
20.2% |
15.9% |
21.6% |
35.6% |
30.4% |
-47.3% |
18.9% |
-36.8% |
-5.1% |
54.2% |
-9.6% |
-18.9% |
5.1% |
12.6% |
|
|
|
0.00 |
<-Median-> |
10 |
OPM |
|
|
*Operational Profit Margin
(Net income/Revenue) Ratio |
|
|
|
|
|
|
|
|
OPM |
10 Yrs |
7.07% |
5 Yrs |
6.71% |
|
|
|
|
should be |
zero, it is a |
|
check on
calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Type |
|
Property, Plant and
Equipment |
|
|
$12,200 |
$13,365 |
$15,117 |
$16,230 |
$16,941 |
$17,343 |
$17,865 |
$17,857 |
$18,327 |
$18,791 |
$19,504 |
$20,483 |
|
|
|
59.87% |
<-Total Growth |
10 |
Property, Plant and Equipment |
Lg Term A |
|
Change |
|
|
|
9.55% |
13.11% |
7.36% |
4.38% |
2.37% |
3.01% |
-0.04% |
2.63% |
2.53% |
3.79% |
5.02% |
|
|
|
3% |
<-Median-> |
10 |
Change |
Lg Term R |
|
Long Term Debt/Asset Ratio |
|
|
0.46 |
0.47 |
0.48 |
0.49 |
0.48 |
0.57 |
0.58 |
0.52 |
0.51 |
0.51 |
0.51 |
0.52 |
|
|
|
0.51 |
<-Median-> |
10 |
Long Term Debt/Asset Ratio |
Intang/GW |
|
Long Term Debt |
$3,460 |
$4,588 |
$5,652 |
$6,230 |
$7,256 |
$7,943 |
$8,149 |
$9,953 |
$10,290 |
$9,263 |
$9,423 |
$9,502 |
$9,978 |
$10,587 |
|
|
|
76.54% |
<-Total Growth |
10 |
Debt |
Liquidity |
|
Change |
-3.29% |
32.59% |
23.19% |
10.23% |
16.46% |
9.47% |
2.59% |
22.14% |
3.39% |
-9.98% |
1.73% |
0.84% |
5.01% |
6.10% |
|
|
|
4% |
<-Median-> |
10 |
Change |
Liq. + CF |
|
Debt/Market Cap Ratio |
1.01 |
1.32 |
1.22 |
1.16 |
1.32 |
1.93 |
1.59 |
1.93 |
2.32 |
1.62 |
2.25 |
1.95 |
2.07 |
2.47 |
|
|
|
1.93 |
<-Median-> |
10 |
% of Market C. |
Debt Ratio |
|
Assets/Current Liabilities
Ratio |
16.49 |
12.49 |
12.49 |
13.42 |
15.40 |
19.77 |
19.94 |
21.06 |
13.35 |
23.85 |
20.67 |
14.50 |
15.82 |
22.60 |
|
|
|
17.79 |
<-Median-> |
10 |
Assets/Current Liabilities |
Leverage |
|
Debt to Cash Flow (Years) |
3.67 |
3.09 |
3.57 |
3.21 |
4.32 |
4.73 |
4.55 |
7.48 |
10.30 |
6.01 |
5.11 |
5.10 |
4.16 |
5.63 |
|
|
|
4.91 |
<-Median-> |
10 |
Debt to Cash Flow (Years) |
D/E Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intangibles |
|
$306 |
$345 |
$387 |
$416 |
$502 |
$546 |
$587 |
$672 |
$662 |
$685 |
$752 |
$870 |
$966 |
|
|
|
152.17% |
<-Total Growth |
10 |
Intangibles |
|
|
Goodwill |
|
$71 |
$71 |
$71 |
$71 |
$71 |
$71 |
$71 |
$82 |
$82 |
$82 |
$73 |
$89 |
$237 |
|
|
|
25.35% |
<-Total Growth |
10 |
Goodwill |
|
|
Total |
|
$377 |
$416 |
$458 |
$487 |
$573 |
$617 |
$658 |
$754 |
$744 |
$767 |
$825 |
$959 |
$1,203 |
|
|
|
130.53% |
<-Total Growth |
10 |
Total |
|
|
Change |
|
|
10.34% |
10.10% |
6.33% |
17.66% |
7.68% |
6.65% |
14.59% |
-1.33% |
3.09% |
7.56% |
16.24% |
25.44% |
|
|
|
7.62% |
<-Median-> |
10 |
Change |
|
|
Intangible/Market Cap
Ratio |
|
0.11 |
0.09 |
0.09 |
0.09 |
0.14 |
0.12 |
0.13 |
0.17 |
0.13 |
0.18 |
0.17 |
0.20 |
0.28 |
|
|
|
0.13 |
<-Median-> |
10 |
% of Market C. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Assets |
$1,392.1 |
$1,618 |
$1,559 |
$1,652 |
$1,549 |
$1,611 |
$1,384 |
$2,275 |
$2,097 |
$2,037 |
$2,039 |
$2,221 |
$2,361 |
$1,748 |
|
|
|
51.44% |
<-Total Growth |
10 |
Current Assets |
|
|
Current Liabilities |
$620.8 |
$997 |
$1,146 |
$1,193 |
$1,149 |
$964 |
$989 |
$1,034 |
$1,748 |
$910 |
$1,074 |
$1,586 |
$1,526 |
$1,097 |
|
|
|
33.16% |
<-Total Growth |
10 |
Current Liabilities |
|
|
Liquidity |
2.24 |
1.62 |
1.36 |
1.38 |
1.35 |
1.67 |
1.40 |
2.20 |
1.20 |
2.24 |
1.90 |
1.40 |
1.55 |
1.59 |
|
|
|
1.47 |
<-Median-> |
10 |
Ratio |
|
|
Liq. with CF aft div |
3.66 |
3.04 |
2.68 |
2.94 |
2.72 |
3.30 |
3.08 |
3.34 |
1.67 |
3.73 |
3.43 |
2.45 |
2.98 |
3.11 |
|
|
|
2.98 |
<-Median-> |
5 |
Liq. with CF aft div |
|
|
Liq. CF re Inv+Div |
1.54 |
1.12 |
0.91 |
0.97 |
0.97 |
1.04 |
1.17 |
1.48 |
0.86 |
2.83 |
1.72 |
1.31 |
1.50 |
3.11 |
|
|
|
1.50 |
<-Median-> |
5 |
Liq. CF re
Inv+Div |
|
|
Curr Long Term Db |
|
|
$52 |
$138 |
$138 |
$138 |
$138 |
$138 |
$138 |
$173 |
$196 |
$350 |
$109 |
$129 |
|
|
|
|
|
|
Curr Long Term Db |
|
|
Liquidity Less CLTD |
|
|
1.43 |
1.57 |
1.53 |
1.95 |
1.63 |
2.54 |
1.30 |
2.76 |
2.32 |
1.80 |
1.67 |
1.81 |
|
|
|
1.80 |
<-Median-> |
5 |
Liquidity Less CLTD |
|
|
Liq. with CF aft div |
|
|
2.80 |
3.32 |
3.10 |
3.85 |
3.58 |
3.86 |
1.82 |
4.60 |
4.19 |
3.14 |
3.21 |
3.52 |
|
|
|
3.21 |
<-Median-> |
5 |
Liq. with CF aft div |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Assets |
$10,240 |
$12,453 |
$14,315 |
$16,010 |
$17,689 |
$19,055 |
$19,724 |
$21,775 |
$23,344 |
$21,703 |
$22,200 |
$23,004 |
$24,139 |
$24,789 |
|
|
|
68.63% |
<-Total Growth |
10 |
Assets |
|
|
Liabilities |
$5,594 |
$7,790 |
$9,399 |
$9,997 |
$11,409 |
$12,162 |
$12,525 |
$14,548 |
$15,902 |
$13,845 |
$14,351 |
$15,055 |
$15,795 |
$16,302 |
|
|
|
68.05% |
<-Total Growth |
10 |
Liabilities |
|
|
Debt Ratio |
1.83 |
1.60 |
1.52 |
1.60 |
1.55 |
1.57 |
1.57 |
1.50 |
1.47 |
1.57 |
1.55 |
1.53 |
1.53 |
1.52 |
|
|
|
1.55 |
<-Median-> |
10 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimates BVPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
$39.80 |
$41.70 |
$43.70 |
|
|
Estimates |
|
Estimates BVPS |
|
|
Estimate Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
$4,533.7 |
$4,750.2 |
$4,978.0 |
|
|
Estimates |
|
Estimate Book Value |
|
|
P/B Ratio (Close) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.95 |
0.90 |
0.86 |
|
|
Estimates |
|
P/B Ratio (Close) |
|
|
Difference from 10 year
median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-28.12% |
Diff M/C |
|
|
Estimates |
|
Difference from 10 yr med. |
|
|
Total Equity |
$4,645 |
$4,663 |
$4,916 |
$6,013 |
$6,280 |
$6,893 |
$7,199 |
$7,227 |
$7,442 |
$7,858 |
$7,849 |
$7,949 |
$8,344 |
$8,487 |
$8,487 |
$8,487 |
|
69.73% |
<-Total Growth |
10 |
Total Equity |
|
|
Non-Control. Int |
$2,431.5 |
$2,500 |
$2,549 |
$3,153 |
$3,153 |
$3,537 |
$3,653 |
$3,634 |
$3,687 |
$3,858 |
$3,797 |
$3,838 |
$3,968 |
$4,048 |
$4,048 |
$4,048 |
|
55.67% |
<-Total Growth |
10 |
Non-Control. Int |
|
|
Preferred Stock |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
|
|
|
|
Preferred Stock |
|
|
Book Value |
$2,213.9 |
$2,163 |
$2,367 |
$2,860 |
$3,127 |
$3,356 |
$3,546 |
$3,593 |
$3,755 |
$4,000 |
$4,052 |
$4,111 |
$4,376 |
$4,439 |
$4,439 |
$4,439 |
|
84.88% |
<-Total Growth |
10 |
Book Value |
|
|
BV per share |
$19.11 |
$18.73 |
$20.58 |
$24.84 |
$27.16 |
$29.18 |
$30.93 |
$31.34 |
$32.75 |
$34.88 |
$35.38 |
$35.94 |
$38.42 |
$38.97 |
$38.97 |
$38.97 |
|
86.67% |
<-Total Growth |
10 |
Book Value per Share |
|
|
Change |
10.73% |
-1.97% |
9.85% |
20.72% |
9.32% |
7.43% |
6.00% |
1.32% |
4.51% |
6.52% |
1.41% |
1.60% |
6.89% |
1.44% |
0.00% |
0.00% |
|
-31.30% |
P/B Ratio |
|
Current/Historical Median |
|
|
P/B Ratio (Median) |
1.38 |
1.62 |
1.69 |
1.81 |
1.83 |
1.42 |
1.35 |
1.54 |
1.22 |
1.28 |
1.17 |
1.14 |
1.15 |
1.05 |
0.00 |
0.00 |
|
1.41 |
P/B Ratio |
|
Historical Median |
|
|
P/B Ratio (Close) |
1.55 |
1.61 |
1.96 |
1.88 |
1.75 |
1.22 |
1.44 |
1.44 |
1.18 |
1.43 |
1.03 |
1.19 |
1.10 |
0.97 |
0.97 |
0.97 |
|
6.44% |
<-IRR #YR-> |
10 |
Book Value per Share |
86.67% |
|
Change |
15.70% |
3.89% |
21.98% |
-4.23% |
-6.56% |
-30.28% |
18.01% |
-0.55% |
-17.90% |
21.02% |
-27.70% |
15.18% |
-7.14% |
-12.45% |
|
|
|
4.16% |
<-IRR #YR-> |
5 |
Book Value per Share |
22.59% |
|
Leverage (A/BV) |
2.20 |
2.67 |
2.91 |
2.66 |
2.82 |
2.76 |
2.74 |
3.01 |
3.14 |
2.76 |
2.83 |
2.89 |
2.89 |
2.92 |
|
|
|
2.82 |
<-Median-> |
10 |
A/BV |
|
|
Debt/Equity Ratio |
1.20 |
1.67 |
1.91 |
1.66 |
1.82 |
1.76 |
1.74 |
2.01 |
2.14 |
1.76 |
1.83 |
1.89 |
1.89 |
1.92 |
|
|
|
1.82 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
|
Sharerholders Equity |
|
|
|
|
|
|
|
|
P/BV |
10 yr Med |
1.32 |
5 yr Med |
1.17 |
|
-26.59% |
Diff M/C |
|
2.76 |
Historical |
|
A/BV |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$20.58 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$38.42 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$31.34 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$38.42 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$273 |
<-12 mths |
-25.21% |
|
|
|
|
|
|
|
Total Comprehensive Income |
$290.1 |
$492 |
$501 |
$934 |
$683 |
$522 |
$618 |
$396 |
$718 |
$893 |
$509 |
$635 |
$683 |
|
|
|
|
36.33% |
<-Total Growth |
10 |
Total Comprehensive Income |
|
|
NCI |
$0.0 |
$223 |
$223 |
$412 |
$318 |
$263 |
$313 |
$229 |
$350 |
$462 |
$252 |
$311 |
$318 |
|
|
|
|
42.60% |
<-Total Growth |
10 |
NCI |
|
|
Shareholders Comp. Income |
$269.0 |
$269 |
$278 |
$522 |
$365 |
$259 |
$305 |
$167 |
$368 |
$431 |
$257 |
$324 |
$365 |
|
|
|
|
31.29% |
<-Total Growth |
10 |
Shareholders Comp. Income |
|
|
Increase |
0.00% |
0.00% |
3.35% |
87.77% |
-30.08% |
-29.04% |
17.76% |
-45.25% |
120.36% |
17.12% |
-40.37% |
26.07% |
12.65% |
|
|
|
|
17.12% |
<-Median-> |
5 |
Comprehensive Income |
|
|
5 Yr Running Average |
$269 |
$269 |
$271 |
$321 |
$341 |
$339 |
$346 |
$324 |
$293 |
$306 |
$306 |
$309 |
$349 |
|
|
|
|
2.76% |
<-IRR #YR-> |
10 |
Comprehensive Income |
31.29% |
|
ROE |
12.2% |
12.4% |
11.7% |
18.3% |
11.7% |
7.7% |
8.6% |
4.6% |
9.8% |
10.8% |
6.3% |
7.9% |
8.3% |
|
|
|
|
16.93% |
<-IRR #YR-> |
5 |
Comprehensive Income |
118.56% |
|
5Yr Median |
15.2% |
13.4% |
12.4% |
12.4% |
12.2% |
11.7% |
11.7% |
8.6% |
8.6% |
8.6% |
8.6% |
7.9% |
8.3% |
|
|
|
|
2.57% |
<-IRR #YR-> |
10 |
5 Yr Running Average |
28.88% |
|
% Difference from NI |
-8.2% |
-17.7% |
-25.9% |
24.9% |
-13.1% |
68.2% |
-10.3% |
-17.7% |
12.2% |
-16.0% |
2.0% |
31.7% |
-1.4% |
|
|
|
|
1.52% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
7.85% |
|
Median Values |
|
|
|
|
|
|
|
|
|
Diff |
5, 10 yr |
0.3% |
2.0% |
|
|
|
|
8.3% |
<-Median-> |
5 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$278.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$365.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$167.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$365.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$270.8 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$349.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$323.6 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$349.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Liability Coverage
Ratio |
1.50 |
1.61 |
1.61 |
1.67 |
1.64 |
1.73 |
1.93 |
1.75 |
1.08 |
2.10 |
1.66 |
1.13 |
1.39 |
1.71 |
|
|
|
|
|
|
CFO / Current Liabilities |
|
|
5 year Median |
1.39 |
1.50 |
1.50 |
1.61 |
1.61 |
1.64 |
1.67 |
1.73 |
1.73 |
1.75 |
1.75 |
1.66 |
1.39 |
1.66 |
|
|
|
1.67 |
<-Median-> |
10 |
Current Liability Cov Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Asset Efficiency Ratio |
9.08% |
12.92% |
12.87% |
12.45% |
10.62% |
8.76% |
9.69% |
8.32% |
8.10% |
8.82% |
8.05% |
7.82% |
8.79% |
7.58% |
|
|
|
|
|
|
CFO / Total Assets |
|
|
5 year Median |
9.84% |
10.58% |
10.74% |
12.45% |
12.45% |
12.45% |
10.62% |
9.69% |
8.76% |
8.76% |
8.32% |
8.10% |
8.10% |
8.05% |
|
|
|
8.8% |
<-Median-> |
10 |
Return on Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Assets ROA |
2.86% |
2.63% |
2.62% |
2.61% |
2.37% |
0.81% |
1.72% |
0.93% |
1.41% |
2.36% |
1.14% |
1.07% |
1.53% |
1.63% |
|
|
|
Net |
Income/Assets |
|
Return on Assets |
|
|
5Yr Median |
2.86% |
2.86% |
2.85% |
2.63% |
2.62% |
2.61% |
2.37% |
1.72% |
1.41% |
1.41% |
1.41% |
1.14% |
1.41% |
1.53% |
|
|
|
1.5% |
<-Median-> |
10 |
Asset Efficiency Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Equity ROE |
13.23% |
15.12% |
15.84% |
14.62% |
13.43% |
4.59% |
9.59% |
5.65% |
8.74% |
12.83% |
6.22% |
5.98% |
8.46% |
9.08% |
|
|
|
Net Inc/ |
Shareholders' equity |
|
Return on Equity |
|
|
5Yr Median |
14.45% |
15.12% |
15.12% |
14.62% |
14.62% |
14.62% |
13.43% |
9.59% |
8.74% |
8.74% |
8.74% |
6.22% |
8.46% |
8.46% |
|
|
|
8.6% |
<-Median-> |
10 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$398 |
<-12 mths |
7.57% |
|
|
|
|
|
|
|
Total Net Income |
$545 |
$597 |
$677 |
$736 |
$791 |
$356 |
$675 |
$462 |
$671 |
$1,007 |
$497 |
$469 |
$707 |
|
|
|
|
4.43% |
<-Total Growth |
10 |
Total Net Income |
|
|
NCI |
$252 |
$270 |
$302 |
$318 |
$371 |
$202 |
$335 |
$259 |
$343 |
$494 |
$245 |
$223 |
$337 |
|
|
|
|
11.59% |
<-Total Growth |
10 |
NCI |
|
|
Shareholders Net Income |
$292.9 |
$327 |
$375 |
$418 |
$420 |
$154 |
$340 |
$203 |
$328 |
$513 |
$252 |
$246 |
$370 |
$403 |
$413 |
$422 |
|
-1.33% |
<-Total Growth |
10 |
Shareholders Net Income |
|
|
Increase |
3.39% |
11.64% |
14.68% |
11.47% |
0.48% |
-63.33% |
120.78% |
-40.29% |
61.58% |
56.40% |
-50.88% |
-2.38% |
50.41% |
8.92% |
2.48% |
2.18% |
|
EPS/CF Ratio should not be higher than 1.00 |
|
|
5 Yr Running Average |
$261 |
$285 |
$310 |
$339 |
$367 |
$339 |
$341 |
$307 |
$289 |
$308 |
$327 |
$308 |
$342 |
$357 |
$337 |
$371 |
|
-0.13% |
<-IRR #YR-> |
10 |
Net Income |
-1.33% |
|
Operating Cash Flow |
$942.1 |
$1,483 |
$1,584 |
$1,939 |
$1,681 |
-$1,853 |
-$1,853 |
-$1,853 |
-$1,853 |
-$1,853 |
-$1,853 |
-$1,853 |
-$1,853 |
|
|
|
|
12.76% |
<-IRR #YR-> |
5 |
Net Income |
82.27% |
|
Investment Cash Flow |
-$855.7 |
-$1,701 |
-$2,223 |
-$2,422 |
-$2,078 |
-$2,078 |
-$1,611 |
-$1,300 |
-$1,644 |
-$289 |
-$1,061 |
-$1,383 |
-$1,496 |
|
|
|
|
0.98% |
<-IRR #YR-> |
10 |
5 Yr Running Ave. |
10.28% |
|
Total Accruals |
$207 |
$545 |
$1,014 |
$901 |
$817 |
$4,085 |
$3,804 |
$3,356 |
$3,825 |
$2,655 |
$3,166 |
$3,482 |
$3,719 |
|
|
|
|
2.17% |
<-IRR #YR-> |
5 |
5 Yr Running Ave. |
11.34% |
|
Total Assets |
$10,240 |
$12,453 |
$14,315 |
$16,010 |
$17,689 |
$19,055 |
$19,724 |
$21,775 |
$23,344 |
$21,703 |
$22,200 |
$23,004 |
$24,139 |
|
|
|
|
|
Balance Sheet |
|
Assets |
|
|
Accruals Ratio |
2.02% |
4.38% |
7.08% |
5.63% |
4.62% |
21.44% |
19.29% |
15.41% |
16.39% |
12.23% |
14.26% |
15.14% |
15.41% |
|
|
|
|
15.14% |
<-Median-> |
5 |
Ratio |
|
|
EPS/CF Ratio |
0.31 |
0.20 |
0.20 |
0.21 |
0.22 |
0.09 |
0.18 |
0.11 |
0.17 |
0.27 |
0.14 |
0.14 |
0.17 |
|
|
|
|
0.17 |
<-Median-> |
10 |
EPS/CF Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$375.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$370.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$203.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$370.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$309.9 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$341.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$307.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$341.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change in Close |
28.11% |
1.84% |
34.00% |
15.61% |
2.14% |
-25.09% |
25.10% |
0.76% |
-14.20% |
28.90% |
-26.68% |
17.02% |
-0.75% |
-11.18% |
0.00% |
0.00% |
|
|
Count |
28 |
Years of data |
|
|
up/down |
|
|
|
down |
down |
|
down |
down |
down |
down |
down |
down |
down |
down |
|
|
|
|
Count |
12 |
42.86% |
|
|
Meet Prediction? |
|
|
|
|
|
|
|
|
Yes |
|
Yes |
|
Yes |
|
|
|
|
% right |
Count |
4 |
33.33% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financial Cash Flow |
-$449.6 |
$318 |
$394 |
$757 |
$236 |
$343 |
-$367 |
-$128 |
$837 |
-$782 |
-$823 |
-$486 |
-$953 |
|
|
|
|
|
C F Statement |
|
Financial CF |
|
|
Total Accruals |
$656 |
$227 |
$620 |
$144 |
$581 |
$3,742 |
$4,171 |
$3,484 |
$2,988 |
$3,437 |
$3,989 |
$3,968 |
$4,672 |
|
|
|
|
|
|
|
Accruals |
|
|
Accruals Ratio |
6.41% |
1.82% |
4.33% |
0.90% |
3.28% |
19.64% |
21.15% |
16.00% |
12.80% |
15.84% |
17.97% |
17.25% |
19.35% |
|
|
|
|
17.25% |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash |
$645.2 |
$755 |
$508 |
$741 |
$590 |
$799 |
$601 |
$404 |
$691 |
$1,140 |
$1,100 |
$1,088 |
$1,033 |
$395 |
|
|
|
|
|
|
Cash |
|
|
Cash Per Share |
$5.57 |
$6.54 |
$4.42 |
$6.44 |
$5.12 |
$6.95 |
$5.24 |
$3.52 |
$6.03 |
$9.94 |
$9.60 |
$9.51 |
$9.07 |
$3.47 |
|
|
|
$9.51 |
<-Median-> |
5 |
Cash per Share |
|
|
Percentage of Stock Price |
18.8% |
21.7% |
10.9% |
13.8% |
10.8% |
19.5% |
11.7% |
7.8% |
15.6% |
20.0% |
26.3% |
22.3% |
21.4% |
9.2% |
|
|
|
21.40% |
<-Median-> |
5 |
% of Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Notes: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
August 18,
2023. Last estimates were for 2022,
2023 and 2024 of $4719M, $4858M and $4858M for Revenue, $3.63, $3.43 and
$3.60 for Basic AEPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$3.54, $3.44
and $3.60 for EPS, $1.85, $1.89 and $1.91 for Dividends, $416M, $631M and
$509M for FCF, $19.20, $16.10 and $17.00 for CFPS, $588M, $580M and $414M for
Net Income. |
|
|
|
|
|
|
|
|
|
|
August 19,
2022. Last estimates were for 2021,
2022 and 2023 of $4264M, $4495M and $4738M for Revenue, $2.97, $3.17 and
$3.21 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.79, $1.84
and $1.87 for Dividends, $32M, $173M and $653M for FCF, $16.30, $16.30 and
$17.50 for CFPS, $318M, $438M and $474M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
August 21,
2021. Last estimates were for 2020,
2021 and 2022 of $4039M, $4231M and $4107M for Revenue, $2.82, $3.01 and $3.15 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.74, $1.84
and $1.93 for Div, $383M, $359M and $469M for FCF, $14.80 and 15.30 for CFPS
for 2020-21, and $316M, $406M and $472M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
August 26,
2020. Last estimates were for $5198M,
$5133 and $5222 for Revenue, $3.18, $3.09 and $3.27 for EPS. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$14.10 and
$13.80 for CFPS for 2019 and 2020 and $399M, $355M and $376M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
August 30,
2019. Last estmates were for 2018,
2019 and 2020 of $4348M, $4814M and $4900M for Revenue, $3.12, $3.13 and
$3.33 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$11.70, $13.15
and $12.30 for CFPS and $300M $360M and $384M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 3,
2018. Last estimates were for 2017,
2018 and 2019 of $4407M, $4574M and $4641M for Revenue, $3.04, $3.17 and
$3.27 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$15.50, $15.70
and $14.70 for CFPS and $347M, $364M and $376M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 6,
2017. Last estimates were for 2016,
2017 and 2018 of $4571M, $4515M and $4647M for Revenue, $2.88, $3.04 and
$3.13 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$14.40, $14.50
and $14.90 for CFPS and $332M $347M and $358M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 10,
2016. Last estimates were for 2015, 2016 and 2017 of $4414M, $4956M and
$5481M for Revenue, $2.36, $3.21 and $3.55 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$10.20, $11.40
and $12.30 for CFPS and $342M, $389M and $410M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 13,
2015. Last estimates were for 2014,
2015 and 2016 of $4768M, $5091M and $5467M for Revenue, $3.46, $3.79 and
$3.87 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$12.00, $13.75
and $14.00 for CFPS and $660M, $412M and $433M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
August 29,
2014. Last estimates were for 2013 and
2014 of $4626M and $5145M for Revenue, $3.39, $3.68 and for 2015 $3.79 for
EPS, $10.50 and 11.60 for CFPS. |
|
|
|
|
|
|
|
|
|
|
|
|
August 17,
2013. Last estimates were for 2012 and
2013 of $3.854 M for Revenue (2012 only), $3.11 and $3.28 for EPS. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
October 6,
2012. Last estimates were for 2011 and
2012 of $3,726M, $3,854M for Revenue, $5.36, $6.22 and $6.55 (2013) for EPS
and $16.35 and $14.38 for CFPS. |
|
|
|
|
|
|
|
|
|
|
|
|
Jul 16,
2011. Last I looked, I got estimates
for 2010 and 2011 of $4.75 and $4.81 for earnings and $16. and $14.52 for CF. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Aug 30
2010. When I last looked I got
estimates for 2010 and 2011 of $4.45 and $4.68 and CF of $13.44 and $14.30. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
May 17,
2010. when I last reviewed this stock
I got estimates for 2009 and 2010 of $4.00 and $4.05 and CF of $14.30 and
$14.70. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Oct 14, 2009.
When I looked at this stock in May 2009, I got 2009 and 2010 earnings of
$3.90 and $4.00 and also cash flow of $14.30 and $14.70. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
May 13, 2009 AR
2008. when I last looked at this stock
in Feb 2009, I got earnings estimates of $4.12 and $3.83 for 2008 and
2009. I also got CF estimates of
$12.72 and $12.81 for 2008 and 2009. |
|
|
|
|
|
|
|
|
|
|
Earnings came
in at $4.70 ($4.66 diluted). 2009 was
increase somewhat to $3.90. Cash Flow
for 2008 was $15.83 and 2009 estimate incr. to $14.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I think it is a
good company and it should be one of my core companies after purchase if I
purchase it at some time. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20045. For Net
Income I used net of tax figure 2004 not $159.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 2014 dividend
per share has increased for 21 consecutive years, so started in 1993. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sector: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Power, Utility |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Classified
:Management and Diversified |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What should this
stock accomplish? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Would I buy this
company and Why. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This is a
dividend growth utility stock and as such I would consider it if I was
looking for such a stock. Some people do not like the share structure. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This stock is
closely linked to Canadian Utilities (TSX-CU), so you would not buy both. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Why am I following this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I started to
look at this stock in 2009 because it was a dividend paying stock that was on
everyone’s list. At that time this
stock was on the Dividend Achievers list, the Dividend Aristocrats list and
also was on Mike Higgs’ list. |
|
|
|
|
|
|
|
|
ATCO (TSX-ACO-X)
owns 52.3% (2021) Canadian Utilities (TSX-CU), so you would not buy both
these stocks. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends are
paid in Cycle 3, which is March, June, September and December. Dividends are
declared for shareholders in one month for payment in the same month. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For exaple, the
dividend paid for shareholders of record of March 8, 2013 was paid on March 31, 2013. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ATCO has
increased its for 21 consecutive years in 2015. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Class I
Non-Voting Symbol ACO.X and Class II Voting Symbol ACO.Y |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
How they make their money. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Atco Ltd is a
Canadian holding company that offers gas, electric, and infrastructure
solutions. Atco's primary segments
include Structures and Logistics; Utilities; |
|
|
|
|
|
|
|
|
|
|
|
|
|
Energy
Infrastructure; Neltume Ports and Corporate and Other. Geographically, it
derives most of its revenue from Canada. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For most
ratios, lower is better when looking for a good stock price. However, there are exceptions such as for
yield and asset/liability ratios and here you want a higher ratios to
indicate a good stock price. |
|
|
|
|
|
|
|
|
|
Also, for the
Operational Profit Margin, a higher percentage is better. With the OPM, you should only compare
companies in similar industries. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Alberta-based ATCO
Ltd., delivers service excellence and innovative business solutions
worldwide with leading companies engaged |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
in Utilities
(pipelines, natural gas and electricity transmission and distribution),
Energy (power generation, natural gas gathering, processing, storage and
liquids extraction), |
|
|
|
|
|
|
|
|
|
|
|
|
Structures &
Logistics (manufacturing, logistics and noise abatement) and Technologies
(business systems solutions). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
July 2011. It
looks like Ronald Southern (age 80) is turning over the company to his
daughter Nancy Southern(Age 54). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Class I |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Class II |
|
Shares; '%, Value $M |
%, Val $M |
Shares |
%, Val $M |
Shares |
%, Val $M |
Shares |
%, Val $M |
Shares |
%, Val $M |
Shares |
%, Val $M |
Shares |
%, Val $M |
Shares |
%, Val $M |
|
|
Shares |
%, Val $M |
|
|
Change |
|
Date |
2015 |
Sep 10 |
2016 |
Sep 06 |
2017 |
Sep 03 |
2018 |
Aug 30 |
2019 |
Aug 26 |
2020 |
Aug 21 |
2021 |
Aug 19 |
2022 |
|
|
Aug 18 |
2023 |
|
|
|
|
Southern, Nancy C. |
0.31% |
26.316 |
26.00% |
26.302 |
25.96% |
26.500 |
26.13% |
26.589 |
26.21% |
26.628 |
26.27% |
26.877 |
26.56% |
27.118 |
26.75% |
|
|
27.222 |
26.85% |
I |
|
0.38% |
|
CEO & Chairman - Class
I |
$11.085 |
|
$1,175.283 |
|
$1,183.583 |
|
$1,023.176 |
|
$1,323.352 |
|
$971.641 |
|
$1,147.663 |
|
$1,149.266 |
|
|
|
$1,024.634 |
I |
|
|
|
Class II |
0.45% |
11.513 |
85.71% |
11.513 |
86.36% |
11.502 |
86.93% |
11.533 |
87.35% |
11.535 |
87.41% |
11.538 |
87.43% |
11.538 |
91.98% |
|
|
11.538 |
91.98% |
II |
|
0.00% |
|
Amount |
$2.178 |
|
$514.149 |
|
$518.063 |
|
$444.105 |
|
$574.018 |
|
$420.909 |
|
$492.669 |
|
$488.977 |
|
|
|
$434.287 |
II |
|
|
|
Options - percentage |
0.91% |
0.870 |
0.76% |
1.425 |
1.24% |
0.585 |
0.51% |
0.585 |
0.51% |
0.715 |
0.62% |
1.615 |
1.41% |
1.165 |
1.02% |
|
|
1.440 |
1.26% |
|
|
23.61% |
|
Options - amount |
$37.235 |
|
$38.854 |
|
$64.125 |
|
$22.587 |
|
$29.115 |
|
$26.090 |
|
$68.961 |
|
$49.373 |
|
|
|
$54.202 |
|
Potential |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Patrick, Katie, J. |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.001 |
0.01% |
|
|
0.001 |
0.00% |
|
|
8.33% |
|
CFO - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.052 |
|
|
|
$0.050 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.019 |
0.02% |
|
|
0.079 |
0.07% |
|
|
324.32% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.784 |
|
|
|
$2.955 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
deChamplain, Dennis |
|
|
|
0.020 |
0.02% |
0.025 |
0.02% |
0.047 |
0.05% |
0.044 |
0.04% |
0.015 |
0.11% |
|
|
|
|
|
|
I |
Last report Aug 2021 |
|
|
CFO - Shares - Amount |
|
|
|
|
$0.888 |
|
$0.976 |
|
$2.321 |
|
$1.593 |
|
$0.643 |
|
|
|
|
|
|
I |
|
|
|
Options - percentage |
|
|
|
0.023 |
0.02% |
0.025 |
0.02% |
0.025 |
0.02% |
0.045 |
0.04% |
0.165 |
0.14% |
|
|
|
|
|
|
|
|
|
|
Options - amount |
|
|
|
|
$1.035 |
|
$0.965 |
|
$1.244 |
|
$1.642 |
|
$7.046 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Constantinescu, M. George |
|
|
|
|
|
|
|
|
|
0.005 |
0.00% |
0.001 |
0.00% |
0.005 |
0.04% |
|
|
0.005 |
0.01% |
I |
|
12.38% |
|
Officer - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
$0.167 |
|
$0.053 |
|
$0.204 |
|
|
|
$0.204 |
I |
|
|
|
Class II |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.001 |
0.01% |
|
|
0.002 |
0.02% |
II |
|
48.57% |
|
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.059 |
|
|
|
$0.078 |
II |
|
|
|
Options & rights,
Percentage |
|
|
|
|
|
|
|
|
|
0.004 |
0.00% |
0.008 |
0.01% |
0.008 |
0.01% |
|
|
0.008 |
0.01% |
|
|
0.00% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
$0.146 |
|
$0.342 |
|
$0.339 |
|
|
|
$0.301 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Kiefer, Siegfried W. |
|
|
|
|
|
0.074 |
0.07% |
0.018 |
0.02% |
0.018 |
0.02% |
0.046 |
0.04% |
|
|
|
|
|
|
|
Last filed Jun 2021 |
|
|
Officer - Shares - Amount |
|
|
|
|
|
|
$2.864 |
|
$0.918 |
|
$0.673 |
|
$1.952 |
|
|
|
|
|
|
|
Ceased insider Feb 2022 |
|
|
Options & rights,
Percentage |
|
|
|
|
|
0.090 |
0.08% |
0.017 |
0.01% |
0.017 |
0.01% |
0.230 |
0.20% |
|
|
|
|
|
|
|
|
|
|
Options - amount |
|
|
|
|
|
|
$3.475 |
|
$0.846 |
|
$0.620 |
|
$9.821 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ellard, Denis M. |
|
|
|
|
|
0.006 |
0.01% |
0.008 |
0.01% |
0.009 |
0.01% |
0.011 |
0.01% |
0.013 |
0.10% |
|
|
|
|
I |
|
|
|
Director - Share - Amount |
|
|
|
|
|
|
$0.251 |
|
$0.400 |
|
$0.343 |
|
$0.476 |
|
$0.558 |
|
|
|
|
I |
|
|
|
Options - percentage |
|
|
|
|
|
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
|
|
|
|
|
|
|
|
Options - amount |
|
|
|
|
|
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Routs, Robert John |
|
|
|
|
|
|
|
|
|
0.015 |
0.01% |
0.018 |
0.02% |
0.021 |
0.16% |
|
|
0.024 |
0.02% |
I |
|
14.64% |
|
Director - Share - Amount |
|
|
|
|
|
|
|
|
|
|
$0.538 |
|
$0.755 |
|
$0.875 |
|
|
|
$0.891 |
I |
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
#DIV/0! |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Booth, Robert T. |
0.01% |
0.017 |
0.01% |
0.018 |
0.02% |
0.019 |
0.02% |
0.020 |
0.02% |
0.021 |
0.02% |
0.023 |
0.02% |
0.025 |
0.20% |
|
|
0.026 |
0.02% |
I |
Last report Mar 2023 |
6.89% |
|
Director - Share - Amount |
$0.513 |
|
$0.751 |
|
$0.795 |
|
$0.715 |
|
$0.994 |
|
$0.775 |
|
$0.979 |
|
$1.041 |
|
|
|
$0.988 |
I |
|
|
|
Options - percentage |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
#DIV/0! |
|
Options - amount |
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Southern, Ronald D. |
25.51% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I |
Values for 2013 cannot |
|
|
Founder Class I |
######## |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I |
be right |
|
|
Class II |
83.98% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
II |
|
|
|
Amount |
$545.779 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
II |
|
|
|
Options & rights,
Percentage |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Various strike prices |
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Heathcott, Linda A. |
|
26.008 |
25.69% |
26.009 |
25.67% |
26.186 |
25.82% |
26.264 |
25.88% |
26.302 |
25.95% |
26.550 |
26.24% |
26.550 |
26.19% |
|
|
26.838 |
26.48% |
I |
Several people have 11M |
1.08% |
|
Vice Chair Class I |
|
|
$1,161.532 |
|
$1,170.421 |
|
$1,011.036 |
|
$1,307.140 |
|
$959.769 |
|
$1,133.691 |
|
$1,125.195 |
|
|
|
$1,010.189 |
I |
Class II, cannot be right |
|
|
Class II |
|
11.461 |
85.33% |
11.461 |
85.97% |
11.452 |
86.55% |
11.493 |
87.05% |
11.494 |
87.10% |
11.497 |
87.13% |
11.497 |
91.66% |
|
|
11.497 |
91.66% |
II |
last Filing Apr 2023 |
0.00% |
|
Amount |
|
|
$511.849 |
|
$515.746 |
|
$442.155 |
|
$572.005 |
|
$419.433 |
|
$490.942 |
|
$487.263 |
|
|
|
$432.765 |
II |
10% Holder |
|
|
Options & rights,
Percentage |
|
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
|
|
0.210 |
0.18% |
|
Vice-Chair in 2022 |
#DIV/0! |
|
Various strike prices |
|
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
|
|
$7.904 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chairman - see above |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Increase in O/S Shares |
0.13% |
0.159 |
0.14% |
0.089 |
0.08% |
0.042 |
0.04% |
0.117 |
0.10% |
0.108 |
0.09% |
0.027 |
0.02% |
0.060 |
0.05% |
|
|
0.015 |
0.01% |
|
|
|
|
due to SO |
$7.039 |
|
$7.559 |
|
$3.975 |
|
$1.868 |
|
$4.525 |
|
$5.373 |
|
$0.996 |
|
$2.551 |
|
|
|
$0.644 |
|
|
|
|
Book Value |
$2.000 |
|
$4.000 |
|
$3.000 |
|
$2.000 |
|
$3.000 |
|
$3.000 |
|
$1.000 |
|
$2.000 |
|
|
|
$0.575 |
|
|
|
|
Insider Buying |
-$1.564 |
|
-$3.511 |
|
$0.000 |
|
-$0.470 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
-$8.604 |
|
|
|
-$4.148 |
|
|
|
|
Insider Selling |
$3.093 |
|
$7.303 |
|
$2.123 |
|
$5.787 |
|
$4.208 |
|
$0.915 |
|
$0.280 |
|
$0.102 |
|
|
|
$0.000 |
|
|
|
|
Net Insider Selling |
$1.530 |
|
$3.791 |
|
$2.123 |
|
$5.317 |
|
$4.208 |
|
$0.915 |
|
$0.280 |
|
-$8.503 |
|
|
|
-$4.148 |
|
|
|
|
% of Market Cap |
0.04% |
|
0.07% |
|
0.04% |
|
0.12% |
|
0.07% |
|
0.02% |
|
0.01% |
|
-0.18% |
|
|
|
-0.10% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Directors |
|
10 |
|
10 |
|
10 |
|
10 |
|
9 |
|
9 |
|
9 |
|
|
|
9 |
|
|
|
|
|
Women |
27% |
3 |
30% |
3 |
30% |
3 |
30% |
3 |
30% |
3 |
33% |
3 |
33% |
3 |
33% |
|
|
3 |
33% |
|
|
|
|
Minorities |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
|
|
0 |
0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Institutions/Holdings |
1.37% |
133 |
38.79% |
165 |
38.29% |
177 |
34.02% |
177 |
34.02% |
|
|
20 |
26.59% |
20 |
26.59% |
|
|
20 |
17.92% |
|
|
|
|
Total Shares Held |
0.16% |
39.202 |
34.19% |
38.802 |
33.84% |
34.534 |
30.12% |
34.534 |
30.12% |
|
|
30.406 |
26.58% |
30.406 |
26.58% |
|
|
20.315 |
17.83% |
|
|
|
|
Increase/Decrease 3 Mths |
-79.11% |
0.028 |
0.07% |
0.201 |
0.52% |
0.261 |
0.76% |
0.261 |
0.76% |
|
|
-0.722 |
-2.32% |
-0.722 |
-2.32% |
|
|
0.086 |
0.43% |
|
|
|
|
Starting No. of Shares |
|
39.174 |
|
38.601 |
|
34.272 |
|
34.272 |
|
|
|
31.128 |
Top 20 MS |
31.128 |
Top 20 MS |
|
|
20.228 |
Top 20 MS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright © 2008
Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|