| This report is for educational purposes only, and not to provide
investment advice. 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 |
|
https://www.annualreports.com/Company/canadian-national-railway-company |
|
| See my website
on stocks or see my blog at the following sites. |
|
|
|
https://spbrunner.com/stocks.html |
|
https://spbrunner.blogspot.com/ |
|
|
|
|
|
|
|
|
|
|
| Canadian National
Railway |
|
|
|
|
|
TSX: |
CNR |
NYSE: |
CNI |
https://www.cn.ca/ |
Fiscal Yr: |
Dec 31 |
|
|
|
|
|
|
|
|
|
|
| Year |
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 |
12/31/26 |
|
Value |
Description |
#Y |
Item |
Total G |
|
| Accounting Rules |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
|
|
|
|
Accounting Rules |
|
|
| Split Date |
|
|
12/02/13 |
|
|
|
|
|
|
|
|
|
unaudited |
|
|
|
|
|
|
|
|
|
|
| Split |
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Split |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$16,771 |
<-12 mths |
-0.34% |
|
|
|
|
|
|
|
| 98 Act chge |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Revenue* |
$9,028 |
$9,920 |
$10,575 |
$12,134 |
$12,611 |
$12,037 |
$13,041 |
$14,321 |
$14,917 |
$13,819 |
$14,477 |
$17,107 |
$16,828 |
$17,733 |
$18,734 |
$19,190 |
|
59.13% |
<-Total Growth |
10 |
Revenue |
+ Alpha Sp |
|
| Increase |
8.81% |
9.88% |
6.60% |
14.74% |
3.93% |
-4.55% |
8.34% |
9.82% |
4.16% |
-7.36% |
4.76% |
18.17% |
-1.63% |
5.38% |
5.64% |
2.43% |
|
4.76% |
<-IRR #YR-> |
10 |
Revenue |
59.13% |
|
| 5 year Running Average |
$8,214 |
$8,619 |
$9,037 |
$9,991 |
$10,854 |
$11,455 |
$12,080 |
$12,829 |
$13,385 |
$13,627 |
$14,115 |
$14,928 |
$15,430 |
$15,993 |
$16,976 |
$17,918 |
|
3.28% |
<-IRR #YR-> |
5 |
Revenue |
17.51% |
|
| Revenue per Share |
$10.21 |
$11.58 |
$12.73 |
$14.99 |
$16.02 |
$15.80 |
$17.56 |
$19.74 |
$20.94 |
$19.46 |
$20.65 |
$25.49 |
$26.18 |
$27.59 |
$29.15 |
$29.86 |
|
5.49% |
<-IRR #YR-> |
10 |
5 yr Running Average |
70.73% |
|
| Increase |
13.07% |
13.39% |
9.97% |
17.75% |
6.86% |
-1.40% |
11.17% |
12.43% |
6.06% |
-7.10% |
6.17% |
23.43% |
2.70% |
5.38% |
5.64% |
2.43% |
|
3.76% |
<-IRR #YR-> |
5 |
5 yr Running Average |
20.27% |
|
| 5 year Running Average |
$8.83 |
$9.51 |
$10.27 |
$11.71 |
$13.11 |
$14.22 |
$15.42 |
$16.82 |
$18.01 |
$18.70 |
$19.67 |
$21.26 |
$22.55 |
$23.88 |
$25.81 |
$27.66 |
|
7.48% |
<-IRR #YR-> |
10 |
Revenue per Share |
105.65% |
|
| P/S (Price/Sales) Med |
3.57 |
3.60 |
4.19 |
4.76 |
4.96 |
5.09 |
5.62 |
5.30 |
5.40 |
6.25 |
7.10 |
6.12 |
5.97 |
6.07 |
0.00 |
0.00 |
|
5.81% |
<-IRR #YR-> |
5 |
Revenue per Share |
32.61% |
|
| P/S (Price/Sales) Close |
3.92 |
3.90 |
4.76 |
5.34 |
4.83 |
5.72 |
5.90 |
5.12 |
5.61 |
7.19 |
6.56 |
6.31 |
6.36 |
6.04 |
5.72 |
5.58 |
|
8.18% |
<-IRR #YR-> |
10 |
5 yr Running Average |
119.44% |
|
| *Revenue in M CDN
$ |
|
|
|
|
P/S Med |
20 yr |
4.48 |
15 yr |
5.09 |
10 yr |
5.81 |
5 yr |
6.36 |
|
3.94% |
Diff M/C |
|
6.03% |
<-IRR #YR-> |
5 |
5 yr Running Average |
34.02% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$10,575 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$16,828 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$14,321 |
$0 |
$0 |
$0 |
$0 |
$16,828 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9,037 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$15,430 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$12,829 |
$0 |
$0 |
$0 |
$0 |
$15,430 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$12.73 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$26.18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$19.74 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$26.18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$10.27 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$16.82 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$7.21 |
<-12 mths |
-0.96% |
|
|
|
|
|
|
|
| Adjusted Profit CDN$ |
$2,194 |
$2,456 |
$2,582 |
$3,095 |
$3,580 |
$3,581 |
$3,778 |
$4,056 |
$4,189 |
$3,784 |
$4,225 |
$5,134 |
$4,800 |
|
|
|
|
85.90% |
<-Total Growth |
10 |
Adjusted Profit CDN$ |
|
|
| Return on Equity ROE |
20.54% |
22.29% |
19.93% |
22.98% |
23.95% |
24.13% |
22.68% |
22.99% |
23.22% |
19.26% |
18.58% |
24.01% |
23.86% |
|
|
|
|
23.11% |
<-Median-> |
10 |
Return on Equity ROE |
|
|
| 5Yr Median |
|
17.51% |
19.93% |
20.54% |
22.29% |
22.98% |
22.98% |
22.99% |
23.22% |
22.99% |
22.68% |
22.99% |
23.22% |
|
|
|
|
16.48% |
<-Total Growth |
10 |
AEPS |
|
|
| Basic |
$2.43 |
$2.82 |
$3.07 |
$3.77 |
$4.47 |
$4.61 |
$5.02 |
$5.52 |
$5.81 |
$5.32 |
$5.96 |
$7.48 |
$7.30 |
|
|
|
|
137.73% |
<-Total Growth |
10 |
AEPS |
|
|
| pre-split '13 |
$4.84 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AEPS* Dilued |
$2.42 |
$2.81 |
$3.06 |
$3.76 |
$4.44 |
$4.59 |
$4.99 |
$5.50 |
$5.80 |
$5.31 |
$5.83 |
$7.46 |
$7.28 |
$8.02 |
$9.03 |
$9.92 |
|
137.91% |
<-Total Growth |
10 |
AEPS |
|
|
| Increase |
15.24% |
16.12% |
8.90% |
22.88% |
18.09% |
3.38% |
8.71% |
10.22% |
5.45% |
-8.45% |
9.79% |
27.96% |
-2.41% |
10.16% |
12.59% |
9.86% |
|
10 |
0 |
10 |
Years of Data, EPS P or N |
100.00% |
|
| 5 year Running Average |
$1.60 |
$2.16 |
$2.40 |
$2.83 |
$3.30 |
$3.73 |
$4.17 |
$4.66 |
$5.06 |
$5.24 |
$5.49 |
$5.98 |
$6.34 |
$6.78 |
$7.52 |
$8.34 |
|
9.05% |
<-IRR #YR-> |
10 |
AEPS |
137.91% |
|
| AEPS Yield |
6.04% |
6.22% |
5.05% |
4.70% |
5.74% |
5.08% |
4.81% |
5.44% |
4.94% |
3.79% |
4.31% |
4.64% |
4.37% |
4.81% |
5.42% |
5.95% |
|
5.77% |
<-IRR #YR-> |
5 |
AEPS |
32.36% |
|
| Payout Ratio |
26.86% |
26.69% |
28.10% |
26.60% |
28.15% |
32.68% |
33.07% |
33.09% |
37.07% |
43.31% |
42.20% |
39.28% |
43.41% |
42.14% |
37.43% |
34.07% |
|
10.19% |
<-IRR #YR-> |
10 |
5 yr Running Average |
163.78% |
|
| 5 year Running Average |
|
27.05% |
27.71% |
26.79% |
27.28% |
28.44% |
29.72% |
30.72% |
32.81% |
35.84% |
37.75% |
38.99% |
41.05% |
42.07% |
40.89% |
39.27% |
|
6.36% |
<-IRR #YR-> |
5 |
5 yr Running Average |
36.08% |
|
| Price/AEPS Median |
15.08 |
14.83 |
17.45 |
18.99 |
17.89 |
17.53 |
19.77 |
19.03 |
19.49 |
22.91 |
25.15 |
20.91 |
21.46 |
20.89 |
0.00 |
0.00 |
|
19.63 |
<-Median-> |
10 |
Price/AEPS Median |
|
|
| Price/AEPS High |
16.59 |
16.32 |
20.09 |
22.61 |
19.84 |
20.01 |
21.57 |
21.51 |
21.96 |
27.76 |
28.73 |
23.19 |
23.11 |
21.13 |
0.00 |
0.00 |
|
22.28 |
<-Median-> |
10 |
Price/AEPS High |
|
|
| Price/AEPS Low |
13.56 |
13.34 |
14.81 |
15.37 |
15.95 |
15.04 |
17.98 |
16.55 |
17.03 |
18.06 |
21.58 |
18.62 |
19.80 |
20.66 |
0.00 |
0.00 |
|
17.50 |
<-Median-> |
10 |
Price/AEPS Low |
|
|
| Price/AEPS Close |
16.56 |
16.07 |
19.79 |
21.28 |
17.42 |
19.69 |
20.77 |
18.38 |
20.25 |
26.35 |
23.23 |
21.56 |
22.88 |
20.78 |
18.46 |
16.80 |
|
21.03 |
<-Median-> |
10 |
Price/AEPS Close |
|
|
| Trailing P/AEPS Close |
19.08 |
18.66 |
21.55 |
26.15 |
20.57 |
20.35 |
22.58 |
20.26 |
21.36 |
24.13 |
25.50 |
27.59 |
22.33 |
22.89 |
20.78 |
18.46 |
|
22.45 |
<-Median-> |
10 |
Trailing P/AEPS Close |
|
|
| Median Values |
|
DPR |
10 Yrs |
35.08% |
5 Yrs |
42.20% |
P/CF |
5 Yrs |
in order |
21.46 |
23.19 |
18.62 |
22.88 |
|
-3.15% |
Diff M/C |
|
|
|
|
DPR 75% to 95% best |
|
|
| * Adjusted Net Income |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.06 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$7.28 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$5.50 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$7.28 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.40 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.34 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4.66 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.34 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$8.44 |
<-12 mths |
-1.02% |
|
|
|
|
|
|
|
| Difference Basic and
Diluted |
0.55% |
0.65% |
0.32% |
0.26% |
0.68% |
0.43% |
0.55% |
0.34% |
0.34% |
0.20% |
0.14% |
0.27% |
0.23% |
|
|
|
|
0.00 |
<-Median-> |
0 |
Difference Basic and Diluted |
+ Alpha Sp |
|
| pre-split '99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '04 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| EPS Basic |
$2.72 |
$3.08 |
$3.10 |
$3.86 |
$4.42 |
$4.69 |
$7.28 |
$5.89 |
$5.85 |
$5.01 |
$6.90 |
$7.46 |
$8.55 |
|
|
|
|
175.81% |
<-Total Growth |
10 |
EPS Basic |
|
|
| pre-split '99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '04 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
$5.41 |
$6.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| EPS Diluted* |
$2.71 |
$3.06 |
$3.09 |
$3.85 |
$4.39 |
$4.67 |
$7.24 |
$5.87 |
$5.83 |
$5.00 |
$6.89 |
$7.44 |
$8.53 |
$8.00 |
$8.99 |
|
|
176.05% |
<-Total Growth |
10 |
EPS Diluted |
|
|
| Increase |
20.76% |
13.12% |
0.98% |
24.60% |
14.03% |
6.38% |
55.03% |
-18.92% |
-0.68% |
-14.24% |
37.80% |
7.98% |
14.65% |
-6.24% |
12.34% |
|
|
10 |
0 |
10 |
Years of Data, EPS P or N |
100.00% |
|
| Earnings Yield |
6.7% |
6.8% |
5.1% |
4.8% |
5.7% |
5.2% |
7.0% |
5.8% |
5.0% |
3.6% |
5.1% |
4.6% |
5.1% |
4.8% |
5.4% |
|
|
10.69% |
<-IRR #YR-> |
10 |
Earnings per Share |
176.05% |
|
| 5 year Running Average |
$2.20 |
$2.39 |
$2.61 |
$2.99 |
$3.42 |
$3.81 |
$4.65 |
$5.20 |
$5.60 |
$5.72 |
$6.17 |
$6.21 |
$6.74 |
$7.17 |
$7.97 |
|
|
7.76% |
<-IRR #YR-> |
5 |
Earnings per Share |
45.32% |
|
| 10 year Running Average |
$1.70 |
$1.94 |
$2.16 |
$2.43 |
$2.74 |
$3.01 |
$3.52 |
$3.91 |
$4.29 |
$4.57 |
$4.99 |
$5.43 |
$5.97 |
$6.39 |
$6.85 |
|
|
9.94% |
<-IRR #YR-> |
10 |
5 yr Running Average |
158.06% |
|
| * Diluted ESP per
share |
|
|
|
|
|
|
|
|
E/P |
10 Yrs |
5.10% |
5Yrs |
4.96% |
|
|
|
|
5.30% |
<-IRR #YR-> |
5 |
5 yr Running Average |
29.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.09 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$8.53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$5.87 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$8.53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.61 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$5.20 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividend* |
|
|
|
|
|
|
|
|
|
|
|
|
|
$3.42 |
$3.55 |
|
|
|
Estimate |
|
Dividend* |
|
|
| Increase |
|
|
|
|
|
|
|
|
|
|
|
|
|
8.29% |
3.59% |
|
|
|
Estimate |
|
Increase |
|
|
| Payout Ratio EPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
42.79% |
39.45% |
|
|
|
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 '99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '04 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
$1.30 |
$1.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividend* |
$0.65 |
$0.75 |
$0.86 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$3.16 |
$3.38 |
$3.38 |
$3.38 |
|
267.44% |
<-Total Growth |
10 |
Dividends |
|
|
| Increase |
20.37% |
15.38% |
14.67% |
16.28% |
25.00% |
20.00% |
10.00% |
10.30% |
18.13% |
6.98% |
6.96% |
19.11% |
7.85% |
6.96% |
0.00% |
0.00% |
|
27 |
0 |
27 |
Years of data, Count P, N |
100.00% |
|
| Average Increases 5
Year Running |
15.17% |
12.40% |
13.43% |
14.73% |
18.34% |
18.27% |
17.19% |
16.32% |
16.69% |
13.08% |
10.47% |
12.29% |
11.80% |
9.57% |
8.17% |
6.78% |
|
-12.09% |
<-Total Growth |
10 |
Average Incr 5 Year Running |
|
|
| Dividends 5 Yr Running |
$0.52 |
$0.58 |
$0.66 |
$0.76 |
$0.90 |
$1.07 |
$1.25 |
$1.44 |
$1.67 |
$1.88 |
$2.08 |
$2.33 |
$2.60 |
$2.85 |
$3.06 |
$3.25 |
|
293.34% |
<-Total Growth |
10 |
Dividends 5 Yr Running |
|
|
| Yield H/L Price |
1.78% |
1.80% |
1.61% |
1.40% |
1.57% |
1.86% |
1.67% |
1.74% |
1.90% |
1.89% |
1.68% |
1.88% |
2.02% |
2.02% |
|
|
|
1.80% |
<-Median-> |
10 |
Yield H/L Price |
Item |
|
| Yield on High Price |
1.62% |
1.64% |
1.40% |
1.18% |
1.42% |
1.63% |
1.53% |
1.54% |
1.69% |
1.56% |
1.47% |
1.69% |
1.88% |
1.99% |
|
|
|
1.55% |
<-Median-> |
10 |
Yield on High
Price |
EPS |
|
| Yield on Low Price |
1.98% |
2.00% |
1.90% |
1.73% |
1.77% |
2.17% |
1.84% |
2.00% |
2.18% |
2.40% |
1.96% |
2.11% |
2.19% |
2.04% |
|
|
|
2.05% |
<-Median-> |
10 |
Yield on Low Price |
AEPS |
|
| Yield on Close Price |
1.62% |
1.66% |
1.42% |
1.25% |
1.62% |
1.66% |
1.59% |
1.80% |
1.83% |
1.64% |
1.82% |
1.82% |
1.90% |
2.03% |
2.03% |
2.03% |
|
1.73% |
<-Median-> |
10 |
Yield on Close Price |
CFPS |
|
| Payout Ratio EPS |
24.03% |
24.51% |
27.83% |
25.97% |
28.47% |
32.12% |
22.79% |
31.01% |
36.88% |
46.00% |
35.70% |
39.38% |
37.05% |
42.26% |
37.62% |
#DIV/0! |
|
33.91% |
<-Median-> |
10 |
DPR EPS |
FCF |
|
| DPR EPS 5 Yr Running |
23.40% |
24.33% |
25.32% |
25.43% |
26.38% |
28.12% |
26.94% |
27.75% |
29.89% |
32.93% |
33.67% |
37.58% |
38.59% |
39.68% |
38.43% |
#DIV/0! |
|
29.01% |
<-Median-> |
10 |
DPR EPS 5 Yr Running |
|
|
| Payout Ratio CFPS |
19.31% |
21.00% |
20.13% |
16.75% |
19.14% |
21.97% |
22.21% |
22.31% |
25.86% |
26.50% |
24.73% |
29.49% |
29.16% |
28.64% |
25.61% |
#DIV/0! |
|
23.52% |
<-Median-> |
10 |
DPR CF |
|
|
| DPR CF 5 Yr Running |
18.82% |
19.68% |
19.57% |
18.59% |
19.02% |
19.73% |
20.18% |
20.68% |
22.46% |
23.90% |
24.41% |
25.89% |
27.25% |
27.79% |
27.48% |
#DIV/0! |
|
21.57% |
<-Median-> |
10 |
DPR CF 5 Yr Running |
|
|
| Payout Ratio CFPS WC |
16.31% |
17.03% |
18.53% |
16.18% |
18.58% |
20.81% |
22.00% |
22.58% |
25.28% |
27.74% |
25.90% |
28.64% |
30.74% |
28.64% |
25.61% |
#DIV/0! |
|
23.93% |
<-Median-> |
10 |
DPR CF WC |
|
|
| DPR CF WC 5 Yr Running |
16.26% |
16.54% |
17.20% |
16.74% |
17.39% |
18.38% |
19.41% |
20.24% |
22.02% |
23.81% |
24.80% |
26.15% |
27.78% |
28.40% |
27.83% |
#DIV/0! |
|
21.13% |
<-Median-> |
10 |
DPR CF WC 5 Yr Running |
|
|
| Median 5 Yrs |
10 Yr Med |
10 Yr Cl |
1.80% |
1.73% |
5 Yr Med |
5 Yr Cl |
1.89% |
1.82% |
5 Yr Med |
Payout |
37.05% |
26.50% |
27.74% |
|
|
|
|
11.67% |
<-IRR #YR-> |
5 |
Dividend |
73.63% |
|
| * Dividends per
share |
10 Yr Med |
and Cur. |
12.56% |
17.24% |
5 Yr Med |
and Cur. |
7.28% |
11.34% |
Last Div Inc ---> |
$0.7900 |
$0.8450 |
6.96% |
|
|
|
|
13.90% |
<-IRR #YR-> |
10 |
Dividend |
267.44% |
|
| Dividends Growth 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13.71% |
<-IRR #YR-> |
15 |
Dividends |
586.96% |
|
| Dividends Growth 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15.82% |
<-IRR #YR-> |
20 |
Dividends |
1786.57% |
|
| Dividends Growth 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15.38% |
<-IRR #YR-> |
25 |
Dividends |
3280.00% |
|
| Dividends Growth 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15.36% |
<-IRR #YR-> |
27 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends Growth 5 |
|
|
|
|
|
|
|
-$1.82 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.16 |
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
| Dividends Growth 10 |
|
|
-$0.86 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.16 |
|
|
|
|
|
|
|
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 |
$3.16 |
|
|
|
|
|
|
|
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 |
$3.16 |
|
|
|
|
|
|
|
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 |
$3.16 |
|
|
|
|
|
|
|
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 |
$3.16 |
|
|
|
|
|
|
|
Dividends Growth 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Historical Dividends |
Historical |
High Div |
2.27% |
Low Div |
1.05% |
10 Yr High |
2.38% |
10 Yr Low |
1.20% |
Med Div |
1.67% |
Close Div |
1.60% |
|
|
|
|
|
|
|
Historical Dividends |
|
|
| High/Ave/Median Values |
Curr diff |
Exp. |
-10.65% |
|
93.16% |
Exp. |
-14.78% |
|
69.02% |
Cheap |
21.45% |
Cheap |
26.45% |
|
|
|
|
|
|
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Future Dividend Yield |
|
|
|
|
Div Yd |
3.52% |
earning in |
5 |
Years |
at IRR of |
11.67% |
Div Inc. |
73.63% |
|
|
|
|
|
|
|
Future Dividend Yield |
Div Yd |
|
| Future Dividend Yield |
|
|
|
|
Div Yd |
6.11% |
earning in |
10 |
Years |
at IRR of |
11.67% |
Div Inc. |
201.46% |
|
|
|
|
|
|
|
Future Dividend Yield |
3.52% |
|
| Future Dividend Yield |
|
|
|
|
Div Yd |
10.62% |
earning in |
15 |
Years |
at IRR of |
11.67% |
Div Inc. |
423.42% |
|
|
|
|
|
|
|
Future Dividend Yield |
6.11% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.62% |
|
| Future Dividend Paid |
|
|
|
|
Div Paid |
$5.87 |
earning in |
5 |
Years |
at IRR of |
11.67% |
Div Inc. |
73.63% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
| Future Dividend Paid |
|
|
|
|
Div Paid |
$10.19 |
earning in |
10 |
Years |
at IRR of |
11.67% |
Div Inc. |
201.46% |
|
|
|
|
|
|
|
Future Dividend Paid |
Div Pd |
|
| Future Dividend Paid |
|
|
|
|
Div Paid |
$17.69 |
earning in |
15 |
Years |
at IRR of |
11.67% |
Div Inc. |
423.42% |
|
|
|
|
|
|
|
Future Dividend Paid |
$5.87 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$10.19 |
|
| Dividend Covering Cost |
|
|
|
|
Total Div |
$21.33 |
over |
5 |
Years |
at IRR of |
11.67% |
Div Cov. |
12.80% |
|
|
|
|
|
|
|
Dividend Covering Cost |
$17.69 |
|
| Dividend Covering Cost |
|
|
|
|
Total Div |
$52.50 |
over |
10 |
Years |
at IRR of |
11.67% |
Div Cov. |
31.50% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
| Dividend Covering Cost |
|
|
|
|
Total Div |
$106.61 |
over |
15 |
Years |
at IRR of |
11.67% |
Div Cov. |
63.97% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| I am earning GC |
|
|
|
|
Div Gr |
562.75% |
28/01/09 |
# yrs -> |
15 |
2009 |
$22.32 |
Cap Gain |
646.64% |
|
|
|
|
|
|
|
I am earning GC |
|
|
| I am earning Div |
|
|
|
|
org yield |
2.28% |
12/31/24 |
Trading |
Div G Yrly |
12.60% |
Div start |
$0.51 |
-2.28% |
15.14% |
|
|
|
|
|
|
I am earning Div |
Item |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenue Growth |
| I am earning GC |
|
|
|
|
Div Gr |
1252.00% |
06/07/05 |
# yrs -> |
19 |
2005 |
$18.03 |
Cap Gain |
824.29% |
|
|
|
|
|
|
|
I am earning GC |
AEPS Growth |
| I am earning Div |
|
|
|
|
org yield |
1.39% |
12/31/24 |
Trading |
Div G Yrly |
14.29% |
Div start |
$0.25 |
-1.39% |
18.75% |
|
|
|
|
|
|
I am earning Div |
Net Income Growth |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Growth |
| Yield if held 5 years |
2.59% |
2.82% |
3.51% |
4.13% |
4.10% |
4.11% |
3.96% |
3.41% |
3.01% |
2.89% |
3.06% |
2.97% |
3.02% |
2.99% |
2.78% |
2.30% |
|
3.23% |
<-Median-> |
10 |
Paid Median Price |
Dividend Growth |
| Yield if held 10 years |
6.49% |
6.36% |
7.17% |
6.28% |
6.15% |
5.99% |
6.21% |
7.42% |
8.89% |
7.54% |
6.74% |
7.03% |
5.92% |
4.73% |
4.25% |
4.20% |
|
6.51% |
<-Median-> |
10 |
Paid Median Price |
Stock Price Growth |
| Yield if held 15 years |
|
14.43% |
12.95% |
13.50% |
18.03% |
14.98% |
13.98% |
15.17% |
13.51% |
11.32% |
9.82% |
11.03% |
12.89% |
13.98% |
11.08% |
9.26% |
|
13.50% |
<-Median-> |
10 |
Paid Median Price |
|
|
| Yield if held 20 years |
|
|
|
|
|
|
31.74% |
27.41% |
29.02% |
33.17% |
24.57% |
24.83% |
26.33% |
21.24% |
16.63% |
13.49% |
|
27.41% |
<-Median-> |
7 |
Paid Median Price |
Revenue Growth |
| Yield if held 25 years |
|
|
|
|
|
|
|
|
|
|
|
56.37% |
47.59% |
45.62% |
48.75% |
33.76% |
|
51.98% |
<-Median-> |
2 |
Paid Median Price |
AEPS Growth |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Income Growth |
| Cost covered if held 5
years |
10.28% |
10.93% |
13.48% |
15.71% |
14.78% |
14.69% |
15.02% |
13.52% |
11.72% |
11.86% |
12.90% |
11.82% |
12.42% |
12.59% |
12.58% |
11.07% |
|
13.21% |
<-Median-> |
10 |
Paid Median Price |
Cash Flow Growth |
| Cost covered if held 10
years |
36.51% |
36.12% |
41.29% |
36.20% |
33.27% |
31.67% |
34.50% |
42.92% |
50.32% |
45.66% |
43.14% |
43.01% |
37.87% |
31.66% |
31.13% |
33.08% |
|
40.39% |
<-Median-> |
10 |
Paid Median Price |
Dividend Growth |
| Cost covered if held 15
years |
|
93.13% |
84.53% |
87.91% |
110.28% |
90.05% |
89.17% |
101.46% |
88.80% |
79.63% |
73.11% |
78.39% |
95.94% |
109.16% |
95.85% |
87.63% |
|
88.99% |
<-Median-> |
10 |
Paid Median Price |
Stock Price Growth |
| Cost covered if held 20
years |
|
|
|
|
|
|
213.56% |
193.27% |
200.89% |
246.14% |
193.72% |
187.99% |
209.79% |
178.22% |
154.97% |
137.89% |
|
200.89% |
<-Median-> |
7 |
Paid Median Price |
|
|
| Cost covered if held 25
years |
|
|
|
|
|
|
|
|
|
|
|
437.89% |
389.07% |
392.97% |
466.96% |
355.81% |
|
413.48% |
<-Median-> |
2 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yr |
Item |
Tot. Growth |
| Revenue Growth |
|
|
|
|
|
|
|
$14,321 |
$14,917 |
$13,819 |
$14,477 |
$17,107 |
$16,828 |
$16,771 |
<-12 mths |
-0.34% |
|
17.51% |
<-Total Growth |
5 |
Revenue Growth |
17.51% |
|
| AEPS Growth |
|
|
|
|
|
|
|
$5.50 |
$5.80 |
$5.31 |
$5.83 |
$7.46 |
$7.28 |
$7.21 |
<-12 mths |
-0.96% |
|
32.36% |
<-Total Growth |
5 |
AEPS Growth |
32.36% |
|
| Net Income Growth |
|
|
|
|
|
|
|
$4,328 |
$4,216 |
$3,562 |
$4,892 |
$5,118 |
$5,625 |
$5,513 |
<-12 mths |
-1.99% |
|
29.97% |
<-Total Growth |
5 |
Net Income Growth |
29.97% |
|
| Cash Flow Growth |
|
|
|
|
|
|
|
$5,918 |
$5,923 |
$6,165 |
$6,971 |
$6,667 |
$6,965 |
<-12 mths |
<-12 mths |
#VALUE! |
|
17.69% |
<-Total Growth |
5 |
Cash Flow Growth |
17.69% |
|
| Dividend Growth |
|
|
|
|
|
|
|
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$3.16 |
$3.38 |
<-12 mths |
6.96% |
|
73.63% |
<-Total Growth |
5 |
Dividend Growth |
73.63% |
|
| Stock Price Growth |
|
|
|
|
|
|
|
$101.11 |
$117.47 |
$139.94 |
$135.42 |
$160.84 |
$166.55 |
$166.65 |
<-12 mths |
0.06% |
|
64.72% |
<-Total Growth |
5 |
Stock Price Growth |
64.72% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Revenue Growth |
|
|
$10,575 |
$12,134 |
$12,611 |
$12,037 |
$13,041 |
$14,321 |
$14,917 |
$13,819 |
$14,477 |
$17,107 |
$16,828 |
$17,733 |
<-this year |
5.38% |
|
59.13% |
<-Total Growth |
10 |
Revenue Growth |
59.13% |
|
| AEPS Growth |
|
|
$3.06 |
$3.76 |
$4.44 |
$4.59 |
$4.99 |
$5.50 |
$5.80 |
$5.31 |
$5.83 |
$7.46 |
$7.28 |
$8.02 |
<-this year |
10.16% |
|
137.91% |
<-Total Growth |
10 |
AEPS Growth |
137.91% |
|
| Net Income Growth |
|
|
$2,612 |
$3,167 |
$3,538 |
$3,640 |
$5,484 |
$4,328 |
$4,216 |
$3,562 |
$4,892 |
$5,118 |
$5,625 |
$5,049 |
<-this year |
-10.24% |
|
115.35% |
<-Total Growth |
10 |
Net Income Growth |
115.35% |
|
| Cash Flow Growth |
|
|
$3,548 |
$4,831 |
$5,140 |
$5,202 |
$5,516 |
$5,918 |
$5,923 |
$6,165 |
$6,971 |
$6,667 |
$6,965 |
$7,584 |
<-this year |
8.89% |
|
96.31% |
<-Total Growth |
10 |
Cash Flow Growth |
96.31% |
|
| Dividend Growth |
|
|
$0.86 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$3.16 |
$3.42 |
<-this year |
8.29% |
|
267.44% |
<-Total Growth |
10 |
Dividend Growth |
267.44% |
|
| Stock Price Growth |
|
|
$60.56 |
$80.02 |
$77.35 |
$90.36 |
$103.65 |
$101.11 |
$117.47 |
$139.94 |
$135.42 |
$160.84 |
$166.55 |
$174.90 |
<-this year |
5.01% |
|
175.02% |
<-Total Growth |
10 |
Stock Price Growth |
175.02% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends on Shares |
$144.95 |
$167.25 |
$191.78 |
$223.00 |
$278.75 |
$334.50 |
$367.95 |
$405.86 |
$479.45 |
$512.90 |
$548.58 |
$653.39 |
$704.68 |
$753.74 |
$753.74 |
$753.74 |
|
$5,797.44 |
Total Divs |
27 |
Total Divs |
12/31/96 |
|
| Paid |
$8,936.73 |
$10,071.80 |
$13,504.88 |
$17,844.46 |
$17,249.05 |
$20,150.28 |
$23,113.95 |
$22,547.53 |
$26,195.81 |
$31,206.62 |
$30,198.66 |
$35,867.32 |
$37,140.65 |
$37,162.95 |
$37,162.95 |
$37,162.95 |
|
$37,140.65 |
Worth |
27 |
Worth |
$4.49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$42,938.09 |
|
|
|
|
|
| Dividends on Shares |
|
|
|
$17.00 |
$21.25 |
$25.50 |
$28.05 |
$30.94 |
$36.55 |
$39.10 |
$41.82 |
$49.81 |
$53.72 |
$57.46 |
$57.46 |
$57.46 |
|
$343.74 |
Total Divs |
10 |
Total Divs |
12/31/13 |
|
| Paid |
|
|
$1,029.52 |
$1,360.34 |
$1,314.95 |
$1,536.12 |
$1,762.05 |
$1,718.87 |
$1,996.99 |
$2,378.98 |
$2,302.14 |
$2,734.28 |
$2,831.35 |
$2,833.05 |
$2,833.05 |
$2,833.05 |
|
$2,831.35 |
Worth |
10 |
Worth |
$60.56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$3,175.09 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Graham No. AEPS |
$25.65 |
$28.51 |
$32.77 |
$37.52 |
$43.56 |
$44.85 |
$50.18 |
$54.86 |
$57.49 |
$57.49 |
$65.24 |
$73.14 |
$71.60 |
$75.15 |
$79.75 |
$83.58 |
|
118.52% |
<-Total Growth |
10 |
Graham Price AEPS |
|
|
| Price/GP Ratio Med |
1.42 |
1.46 |
1.63 |
1.90 |
1.82 |
1.79 |
1.97 |
1.91 |
1.97 |
2.12 |
2.25 |
2.13 |
2.18 |
2.23 |
|
|
|
1.97 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Price/GP Ratio High |
1.57 |
1.61 |
1.88 |
2.27 |
2.02 |
2.05 |
2.14 |
2.16 |
2.22 |
2.56 |
2.57 |
2.37 |
2.35 |
2.25 |
|
|
|
2.24 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Price/GP Ratio Low |
1.28 |
1.31 |
1.38 |
1.54 |
1.63 |
1.54 |
1.79 |
1.66 |
1.72 |
1.67 |
1.93 |
1.90 |
2.01 |
2.20 |
|
|
|
1.69 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Price/GP Ratio Close |
1.56 |
1.58 |
1.85 |
2.13 |
1.78 |
2.01 |
2.07 |
1.84 |
2.04 |
2.43 |
2.08 |
2.20 |
2.33 |
2.22 |
2.09 |
1.99 |
|
2.07 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Prem/Disc Close |
56.27% |
58.40% |
84.82% |
113.26% |
77.58% |
101.48% |
106.55% |
84.30% |
104.33% |
143.41% |
107.56% |
119.91% |
132.60% |
121.74% |
108.97% |
99.38% |
|
107.06% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Graham No. EPS |
$27.11 |
$29.76 |
$32.93 |
$37.97 |
$43.31 |
$45.24 |
$60.45 |
$56.68 |
$57.64 |
$55.79 |
$70.93 |
$73.04 |
$77.51 |
$75.05 |
$79.55 |
$0.00 |
|
135.39% |
<-Total Growth |
10 |
Graham Price EPS |
|
|
| Price/GP Ratio Med |
1.35 |
1.40 |
1.62 |
1.88 |
1.83 |
1.78 |
1.63 |
1.85 |
1.96 |
2.18 |
2.07 |
2.14 |
2.02 |
2.23 |
|
|
|
1.92 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Price/GP Ratio High |
1.48 |
1.54 |
1.87 |
2.24 |
2.03 |
2.03 |
1.78 |
2.09 |
2.21 |
2.64 |
2.36 |
2.37 |
2.17 |
2.26 |
|
|
|
2.19 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Price/GP Ratio Low |
1.21 |
1.26 |
1.38 |
1.52 |
1.63 |
1.53 |
1.48 |
1.61 |
1.71 |
1.72 |
1.77 |
1.90 |
1.86 |
2.21 |
|
|
|
1.67 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Price/GP Ratio Close |
1.48 |
1.52 |
1.84 |
2.11 |
1.79 |
2.00 |
1.71 |
1.78 |
2.04 |
2.51 |
1.91 |
2.20 |
2.15 |
2.22 |
2.09 |
#DIV/0! |
|
2.02 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
| Prem/Disc Close |
47.80% |
51.79% |
83.92% |
110.75% |
78.59% |
99.74% |
71.48% |
78.39% |
103.80% |
150.84% |
90.93% |
120.21% |
114.88% |
122.05% |
109.50% |
#DIV/0! |
|
101.77% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
$80.15 |
$90.33 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Close |
$40.08 |
$45.17 |
$60.56 |
$80.02 |
$77.35 |
$90.36 |
$103.65 |
$101.11 |
$117.47 |
$139.94 |
$135.42 |
$160.84 |
$166.55 |
$166.65 |
$166.65 |
$166.65 |
|
175.02% |
<-Total Growth |
10 |
Stock Price |
|
|
| Increase |
20.80% |
12.70% |
34.09% |
32.13% |
-3.34% |
16.82% |
14.71% |
-2.45% |
16.18% |
19.13% |
-3.23% |
18.77% |
3.55% |
0.06% |
0.00% |
0.00% |
|
17.17 |
<-Median-> |
10 |
CAPE (10 Yr P/E) |
|
|
| P/E |
14.82 |
14.76 |
19.60 |
20.78 |
17.62 |
19.35 |
14.32 |
17.22 |
20.15 |
27.99 |
19.65 |
21.62 |
19.53 |
20.84 |
18.55 |
#DIV/0! |
|
10.50% |
<-IRR #YR-> |
5 |
Stock Price |
64.72% |
|
| Trailing P/E |
17.89 |
16.70 |
19.79 |
25.90 |
20.09 |
20.58 |
22.19 |
13.97 |
20.01 |
24.00 |
27.08 |
23.34 |
22.39 |
19.54 |
20.84 |
18.55 |
|
10.65% |
<-IRR #YR-> |
10 |
Stock Price |
175.02% |
|
| CAPE (10 Yr P/E) |
14.07 |
14.11 |
14.84 |
15.68 |
15.93 |
16.67 |
16.53 |
16.89 |
17.44 |
18.72 |
19.06 |
19.66 |
19.64 |
19.72 |
19.70 |
#DIV/0! |
|
12.58% |
<-IRR #YR-> |
5 |
Price & Dividend |
79.38% |
|
| Median 10, 5 Yrs |
|
D. per yr |
2.00% |
2.08% |
% Tot Ret |
15.79% |
16.57% |
T P/E |
22.29 |
23.34 |
P/E: |
19.59 |
20.15 |
|
|
|
|
12.64% |
<-IRR #YR-> |
10 |
Price & Dividend |
209.82% |
|
| Price 15 |
|
D. per yr |
2.33% |
|
% Tot Ret |
14.00% |
|
|
|
|
|
CAPE Diff |
21.38% |
|
|
|
|
14.31% |
<-IRR #YR-> |
15 |
Stock Price |
643.86% |
|
| Price 20 |
|
D. per yr |
2.07% |
|
% Tot Ret |
13.44% |
|
|
|
|
|
|
|
|
|
|
|
13.36% |
<-IRR #YR-> |
20 |
Stock Price |
1128.09% |
|
| Price 25 |
|
D. per yr |
2.00% |
|
% Tot Ret |
12.69% |
|
|
|
|
|
|
|
|
|
|
|
13.74% |
<-IRR #YR-> |
25 |
Stock Price |
2401.41% |
|
| Price 30 |
|
D. per yr |
2.09% |
|
% Tot Ret |
12.75% |
|
|
|
|
|
|
|
|
|
|
|
14.32% |
<-IRR #YR-> |
27 |
Stock Price |
|
|
| Price & Dividend 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16.65% |
<-IRR #YR-> |
15 |
Price & Dividend |
750.98% |
|
| Price & Dividend 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15.43% |
<-IRR #YR-> |
20 |
Price & Dividend |
1314.95% |
|
| Price & Dividend 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15.74% |
<-IRR #YR-> |
25 |
Price & Dividend |
3079.06% |
|
| Price & Dividend 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16.41% |
<-IRR #YR-> |
27 |
Price & Dividend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price 10 |
|
|
|
|
|
|
|
-$101.11 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$166.55 |
|
|
|
|
|
|
|
Price 10 |
|
|
| Price 5 |
|
|
-$60.56 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$166.55 |
|
|
|
|
|
|
|
Price 5 |
|
|
| Price & Dividend 10 |
|
|
|
|
|
|
|
-$101.11 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$169.71 |
|
|
|
|
|
|
|
Price & Dividend 10 |
|
|
| Price & Dividend 5 |
|
|
-$60.56 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$169.71 |
|
|
|
|
|
|
|
Price & Dividend 5 |
|
|
| 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 |
$166.55 |
|
|
|
|
|
|
|
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 |
$166.55 |
|
|
|
|
|
|
|
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 |
$166.55 |
|
|
|
|
|
|
|
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 |
$166.55 |
|
|
|
|
|
|
|
Price 30 |
|
|
| Price & Dividend 15 |
$0.65 |
$0.75 |
$0.86 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$169.71 |
|
|
|
|
|
|
|
Price & Dividend 15 |
|
|
| Price & Dividend 20 |
$0.65 |
$0.75 |
$0.86 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$169.71 |
|
|
|
|
|
|
|
Price & Dividend 20 |
|
|
| Price & Dividend 25 |
$0.65 |
$0.75 |
$0.86 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$169.71 |
|
|
|
|
|
|
|
Price & Dividend 25 |
|
|
| Price & Dividend 30 |
$0.65 |
$0.75 |
$0.86 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$169.71 |
|
|
|
|
|
|
|
Price & Dividend 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price H/L Median |
$36.48 |
$41.67 |
$53.40 |
$71.39 |
$79.45 |
$80.44 |
$98.67 |
$104.67 |
$113.07 |
$121.66 |
$146.65 |
$155.98 |
$156.20 |
$167.58 |
|
|
|
192.50% |
<-Total Growth |
10 |
Stock Price |
|
|
| Increase |
19.59% |
14.21% |
28.16% |
33.69% |
11.29% |
1.25% |
22.66% |
6.08% |
8.03% |
7.60% |
20.54% |
6.36% |
0.14% |
7.29% |
|
|
|
11.33% |
<-IRR #YR-> |
10 |
Stock Price |
192.50% |
|
| P/E |
13.49 |
13.62 |
17.28 |
18.54 |
18.10 |
17.22 |
13.63 |
17.83 |
19.39 |
24.33 |
21.28 |
20.97 |
18.31 |
20.95 |
|
|
|
8.34% |
<-IRR #YR-> |
5 |
Stock Price |
49.23% |
|
| Trailing P/E |
16.29 |
15.40 |
17.45 |
23.10 |
20.64 |
18.32 |
21.13 |
14.46 |
19.26 |
20.87 |
29.33 |
22.64 |
20.99 |
19.65 |
|
|
|
13.53% |
<-IRR #YR-> |
10 |
Price & Dividend |
231.98% |
|
| P/E on Running 5 yr
Aveage |
16.58 |
17.45 |
20.45 |
23.88 |
23.24 |
21.10 |
21.23 |
20.11 |
20.19 |
21.26 |
23.78 |
25.13 |
23.18 |
23.37 |
|
|
|
10.43% |
<-IRR #YR-> |
5 |
Price & Dividend |
63.39% |
|
| P/E on Running 10 yr
Aveage |
21.51 |
21.52 |
24.75 |
29.32 |
29.05 |
26.76 |
28.05 |
26.79 |
26.33 |
26.62 |
29.39 |
28.74 |
26.16 |
26.24 |
|
|
|
14.67 |
P/E Ratio |
|
Historical Median |
|
|
| Median 10, 5 Yrs |
|
D. per yr |
2.20% |
2.09% |
% Tot Ret |
16.27% |
20.08% |
T P/E |
20.93 |
20.99 |
P/E: |
18.43 |
20.97 |
|
|
|
|
|
Count |
27 |
Years of data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$53.40 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$156.20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$104.67 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$156.20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$53.40 |
$1.00 |
$1.25 |
$1.50 |
$1.65 |
$1.82 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$159.36 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$104.67 |
$2.15 |
$2.30 |
$2.46 |
$2.93 |
$159.36 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| High Months |
Dec |
Aug |
Dec |
Nov |
Feb |
Dec |
Jun |
Oct |
May |
Oct |
Oct |
Dec |
Apr |
Jan |
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
$80.28 |
$91.72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price High |
$40.14 |
$45.86 |
$61.48 |
$85.00 |
$88.10 |
$91.84 |
$107.63 |
$118.30 |
$127.38 |
$147.42 |
$167.50 |
$173.02 |
$168.27 |
$169.44 |
|
|
|
173.70% |
<-Total Growth |
10 |
Stock Price |
|
|
| Increase |
16.57% |
14.25% |
34.06% |
38.26% |
3.65% |
4.25% |
17.19% |
9.91% |
7.68% |
15.73% |
13.62% |
3.30% |
-2.75% |
0.70% |
|
|
|
10.59% |
<-IRR #YR-> |
10 |
Stock Price |
173.70% |
|
| P/E |
14.84 |
14.99 |
19.90 |
22.08 |
20.07 |
19.67 |
14.87 |
20.15 |
21.85 |
29.48 |
24.31 |
23.26 |
19.73 |
21.19 |
|
|
|
7.30% |
<-IRR #YR-> |
5 |
Stock Price |
42.24% |
|
| Trailing P/E |
17.92 |
16.95 |
20.09 |
27.51 |
22.88 |
20.92 |
23.05 |
16.34 |
21.70 |
25.29 |
33.50 |
25.11 |
22.62 |
19.86 |
|
|
|
17.16 |
P/E Ratio |
|
Historical Median |
|
|
| Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
22.97 |
25.11 |
P/E: |
21.00 |
23.26 |
|
|
|
|
21.94 |
P/E Ratio |
|
Historical High |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$61.48 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$168.27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$118.30 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$168.27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Low Months |
Sep |
Mar |
Jan |
Jan |
Sep |
Jan |
Feb |
Mar |
Jan |
Mar |
May |
Jun |
Oct |
Jan |
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
$65.65 |
$74.95 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Low |
$32.83 |
$37.48 |
$45.32 |
$57.78 |
$70.80 |
$69.04 |
$89.70 |
$91.03 |
$98.76 |
$95.90 |
$125.80 |
$138.94 |
$144.12 |
$165.71 |
|
|
|
218.01% |
<-Total Growth |
10 |
Stock Price |
|
|
| Increase |
23.50% |
14.17% |
20.93% |
27.49% |
22.53% |
-2.49% |
29.92% |
1.48% |
8.49% |
-2.90% |
31.18% |
10.45% |
3.73% |
14.98% |
|
|
|
12.26% |
<-IRR #YR-> |
10 |
Stock Price |
218.01% |
|
| P/E |
12.13 |
12.25 |
14.67 |
15.01 |
16.13 |
14.78 |
12.39 |
15.51 |
16.94 |
19.18 |
18.26 |
18.67 |
16.90 |
20.72 |
|
|
|
9.62% |
<-IRR #YR-> |
5 |
Stock Price |
58.32% |
|
| Trailing P/E |
14.65 |
13.85 |
14.81 |
18.70 |
18.39 |
15.73 |
19.21 |
12.57 |
16.82 |
16.45 |
25.16 |
20.17 |
19.37 |
19.43 |
|
|
|
12.25 |
P/E Ratio |
|
Historical Median |
|
|
| Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
18.54 |
19.37 |
P/E: |
16.51 |
18.26 |
|
|
|
|
10.19 |
P/E Ratio |
|
Historical Low |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$45.32 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$144.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$91.03 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$144.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Free Cash Flow MS |
$1,000 |
$1,000 |
$2,000 |
$2,084 |
$2,434 |
$2,507 |
$2,843 |
$2,387 |
$2,058 |
$3,302 |
$4,080 |
$3,917 |
$2,299 |
$3,812 |
$4,120 |
|
|
14.95% |
<-Total Growth |
10 |
Free Cash Flow |
|
|
| Change |
|
0.00% |
100.00% |
4.20% |
16.79% |
3.00% |
13.40% |
-16.04% |
-13.78% |
60.45% |
23.56% |
-4.00% |
-41.31% |
65.81% |
8.08% |
|
|
-0.75% |
<-IRR #YR-> |
5 |
Free Cash Flow MS |
-3.69% |
|
| FCF/CF from Op Ratio |
0.34 |
0.33 |
0.56 |
0.43 |
0.47 |
0.48 |
0.52 |
0.40 |
0.35 |
0.54 |
0.59 |
0.59 |
0.33 |
0.50 |
0.49 |
|
|
1.40% |
<-IRR #YR-> |
10 |
Free Cash Flow MS |
14.95% |
|
| Dividends paid |
$585 |
$652 |
$724 |
$818 |
$996 |
$1,159 |
$1,239 |
$1,333 |
$1,544 |
$1,634 |
$1,740 |
$2,004 |
$2,071 |
$2,172 |
$2,172 |
|
|
186.05% |
<-Total Growth |
10 |
Dividends paid |
|
|
| Percentage paid |
|
|
|
39.25% |
40.92% |
46.23% |
43.58% |
55.84% |
75.02% |
49.49% |
42.65% |
51.16% |
90.08% |
56.99% |
52.73% |
|
|
$0.48 |
<-Median-> |
10 |
Percentage paid |
|
|
| 5 Year Coverage |
|
|
|
|
|
|
|
45.25% |
51.28% |
52.75% |
51.06% |
52.43% |
57.44% |
55.26% |
55.74% |
|
|
|
|
|
5 Year Coverage |
|
|
| Dividend
Coverage Ratio |
1.71 |
1.53 |
2.76 |
2.55 |
2.44 |
2.16 |
2.29 |
1.79 |
1.33 |
2.02 |
2.34 |
1.95 |
1.11 |
1.75 |
1.90 |
|
|
2.09 |
<-Median-> |
10 |
Dividend Coverage Ratio |
|
|
| 5 Year of Coverage |
|
|
|
1.85 |
2.26 |
2.31 |
2.40 |
2.21 |
1.95 |
1.90 |
1.96 |
1.91 |
1.74 |
1.81 |
1.79 |
|
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,387 |
$0 |
$0 |
$0 |
$0 |
$2,299 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,000 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$2,299 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Free Cash Flow Company |
$1,175 |
$1,006 |
$1,623 |
$2,220 |
$2,373 |
$2,520 |
$2,778 |
$2,514 |
$1,992 |
$3,227 |
$3,296 |
$4,259 |
$3,887 |
$3,812 |
$4,120 |
|
|
139.49% |
<-Total Growth |
10 |
Free Cash Flow |
Mkt Scn |
|
| Change |
4.72% |
-14.38% |
61.33% |
36.78% |
6.89% |
6.19% |
10.24% |
-9.50% |
-20.76% |
62.00% |
2.14% |
29.22% |
-8.73% |
-1.93% |
8.08% |
|
|
9.11% |
<-IRR #YR-> |
5 |
Free Cash Flow MS |
54.61% |
|
| FCF/CF from Op Ratio |
0.40 |
0.32 |
0.48 |
0.57 |
0.55 |
0.54 |
0.55 |
0.46 |
0.35 |
0.56 |
0.55 |
0.68 |
0.61 |
0.57 |
0.57 |
|
|
9.13% |
<-IRR #YR-> |
10 |
Free Cash Flow MS |
139.49% |
|
| Dividends paid |
$585 |
$652 |
$724 |
$818 |
$996 |
$1,159 |
$1,239 |
$1,333 |
$1,544 |
$1,634 |
$1,740 |
$2,004 |
$2,071 |
$2,172 |
$2,172 |
|
|
186.05% |
<-Total Growth |
10 |
Dividends paid |
|
|
| Percentage paid |
49.79% |
64.81% |
44.61% |
36.85% |
41.97% |
45.99% |
44.60% |
53.02% |
77.51% |
50.64% |
52.79% |
47.05% |
53.28% |
56.99% |
52.73% |
|
|
$0.49 |
<-Median-> |
10 |
Percentage paid |
|
|
| 5 Year Coverage |
|
54.28% |
51.43% |
45.93% |
44.96% |
44.64% |
42.87% |
44.70% |
51.50% |
53.02% |
54.25% |
54.00% |
53.98% |
52.06% |
52.44% |
|
|
|
|
|
5 Year Coverage |
|
|
| Dividend
Coverage Ratio |
2.01 |
1.54 |
2.24 |
2.71 |
2.38 |
2.17 |
2.24 |
1.89 |
1.29 |
1.97 |
1.89 |
2.13 |
1.88 |
1.75 |
1.90 |
|
|
2.05 |
<-Median-> |
10 |
Dividend Coverage Ratio |
|
|
| 5 Year of Coverage |
|
1.84 |
1.94 |
2.18 |
2.22 |
2.24 |
2.33 |
2.24 |
1.94 |
1.89 |
1.84 |
1.85 |
1.85 |
1.92 |
1.91 |
|
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,514 |
$0 |
$0 |
$0 |
$0 |
$3,887 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,623 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$3,887 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Market Cap |
$35,434 |
$38,697 |
$50,301 |
$64,768 |
$60,890 |
$68,854 |
$76,970 |
$73,335 |
$83,674 |
$99,399 |
$94,916 |
$107,924 |
$107,042 |
$107,106 |
$107,106 |
$107,106 |
|
112.80% |
<-Total Growth |
10 |
Market Cap |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '04 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
454.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Diluted # of Share in
Million |
908.80 |
875.4 |
846.1 |
823.5 |
805.1 |
779.2 |
757.3 |
737.7 |
722.6 |
713.0 |
710.3 |
688.3 |
659.1 |
659.1 |
659.1 |
659.1 |
|
-22.10% |
<-Total Growth |
10 |
Diluted |
|
|
| Change |
-3.34% |
-3.68% |
-3.35% |
-2.67% |
-2.23% |
-3.22% |
-2.81% |
-2.59% |
-2.05% |
-1.33% |
-0.38% |
-3.10% |
-4.24% |
0.00% |
0.00% |
0.00% |
|
-2.47% |
<-IRR #YR-> |
10 |
Diluted |
|
|
| Difference
Diluted/Basic |
-0.7% |
-0.5% |
-0.4% |
-0.4% |
-0.5% |
-0.4% |
-0.6% |
-0.4% |
-0.3% |
-0.2% |
-0.3% |
-0.3% |
-0.2% |
-0.2% |
-100.0% |
-100.0% |
|
-2.23% |
<-IRR #YR-> |
5 |
Diluted |
|
|
| Change in Diluted
Shares per Year |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-846.1 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
659.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-737.7 |
0.0 |
0.0 |
0.0 |
0.0 |
659.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Average # of Sh in
Million |
902.20 |
871.20 |
843.10 |
819.9 |
800.7 |
776.0 |
752.6 |
734.5 |
720.1 |
711.3 |
708.5 |
686.4 |
657.7 |
657.7 |
|
|
|
-21.99% |
<-Total Growth |
10 |
Average |
|
|
| Change |
-3.26% |
-3.44% |
-3.23% |
-2.75% |
-2.34% |
-3.08% |
-3.02% |
-2.40% |
-1.96% |
-1.22% |
-0.39% |
-3.12% |
-4.18% |
0.00% |
|
|
|
-2.58% |
<-Median-> |
10 |
Change |
|
|
| Difference
Basic/Outstanding |
-2.0% |
-1.7% |
-1.5% |
-1.3% |
-1.7% |
-1.8% |
-1.3% |
-1.3% |
-1.1% |
-0.1% |
-1.1% |
-2.2% |
-2.3% |
-2.3% |
|
|
|
-1.30% |
<-Median-> |
10 |
Difference Basic/Outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$6,667 |
<-12 mths |
0.00% |
|
|
|
|
|
|
|
|
| pre-split '94 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '04 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| pre-split '13 |
442.1 |
428.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| # of Share in Millions |
884.2 |
856.8 |
830.6 |
809.4 |
787.2 |
762.0 |
742.6 |
725.3 |
712.3 |
710.3 |
700.9 |
671.0 |
642.7 |
642.7 |
642.7 |
642.7 |
|
-2.53% |
<-IRR #YR-> |
10 |
Shares |
-22.62% |
|
| Change |
-3.77% |
-3.10% |
-3.06% |
-2.55% |
-2.74% |
-3.20% |
-2.55% |
-2.33% |
-1.79% |
-0.28% |
-1.32% |
-4.27% |
-4.22% |
0.00% |
0.00% |
0.00% |
|
-2.39% |
<-IRR #YR-> |
5 |
Shares |
-11.39% |
|
| Cash Flow from
Operations $M |
$2,976 |
$3,060 |
$3,548 |
$4,831 |
$5,140 |
$5,202 |
$5,516 |
$5,918 |
$5,923 |
$6,165 |
$6,971 |
$6,667 |
$6,965 |
$7,584 |
$8,484 |
|
|
96.31% |
<-Total Growth |
10 |
Cash Flow |
|
|
| Increase |
-0.77% |
2.82% |
15.95% |
36.16% |
6.40% |
1.21% |
6.04% |
7.29% |
0.08% |
4.09% |
13.07% |
-4.36% |
4.47% |
8.89% |
11.86% |
|
|
SO |
Buy Backs |
|
|
|
|
| 5 year Running Average |
$2,540 |
$2,669 |
$2,972 |
$3,483 |
$3,911 |
$4,356 |
$4,847 |
$5,321 |
$5,540 |
$5,745 |
$6,099 |
$6,329 |
$6,538 |
$6,870 |
$7,334 |
|
|
119.96% |
<-Total Growth |
10 |
CF 5 Yr Running |
|
|
| CFPS |
$3.37 |
$3.57 |
$4.27 |
$5.97 |
$6.53 |
$6.83 |
$7.43 |
$8.16 |
$8.32 |
$8.68 |
$9.95 |
$9.94 |
$10.84 |
$11.80 |
$13.20 |
|
|
153.70% |
<-Total Growth |
10 |
Cash Flow per Share |
|
|
| Increase |
3.12% |
6.11% |
19.61% |
39.73% |
9.40% |
4.55% |
8.81% |
9.85% |
1.91% |
4.38% |
14.59% |
-0.10% |
9.07% |
8.89% |
11.86% |
|
|
6.98% |
<-IRR #YR-> |
10 |
Cash Flow |
96.31% |
|
| 5 year Running Average |
$2.74 |
$2.95 |
$3.38 |
$4.09 |
$4.74 |
$5.43 |
$6.20 |
$6.98 |
$7.45 |
$7.88 |
$8.51 |
$9.01 |
$9.54 |
$10.24 |
$11.14 |
|
|
3.31% |
<-IRR #YR-> |
5 |
Cash Flow |
17.69% |
|
| P/CF on Med Price |
10.84 |
11.67 |
12.50 |
11.96 |
12.17 |
11.78 |
13.28 |
12.83 |
13.60 |
14.02 |
14.74 |
15.70 |
14.41 |
14.20 |
0.00 |
|
|
9.76% |
<-IRR #YR-> |
10 |
Cash Flow per Share |
153.70% |
|
| P/CF on Closing Price |
11.91 |
12.65 |
14.18 |
13.41 |
11.85 |
13.24 |
13.95 |
12.39 |
14.13 |
16.12 |
13.62 |
16.19 |
15.37 |
14.12 |
12.63 |
|
|
5.84% |
<-IRR #YR-> |
5 |
Cash Flow per Share |
32.82% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.08% |
Diff M/C |
|
10.94% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
182.46% |
|
| Excl.Working Capital CF |
$548 |
$714 |
$306 |
$172 |
$156 |
$291 |
$54 |
-$72 |
$136 |
-$275 |
-$315 |
$197 |
-$358 |
$0 |
$0 |
|
|
6.45% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
36.67% |
|
| CF fr Op $M WC |
$3,524 |
$3,774 |
$3,854 |
$5,003 |
$5,296 |
$5,493 |
$5,570 |
$5,846 |
$6,059 |
$5,890 |
$6,656 |
$6,864 |
$6,607 |
$7,584 |
$8,484 |
|
|
71.43% |
<-Total Growth |
10 |
Cash Flow less WC |
|
|
| Increase |
9.99% |
7.09% |
2.12% |
29.81% |
5.86% |
3.72% |
1.40% |
4.96% |
3.64% |
-2.79% |
13.01% |
3.13% |
-3.74% |
14.79% |
11.86% |
|
|
5.54% |
<-IRR #YR-> |
10 |
Cash Flow less WC |
71.43% |
|
| 5 year Running Average |
$2,941 |
$3,176 |
$3,378 |
$3,872 |
$4,290 |
$4,684 |
$5,043 |
$5,442 |
$5,653 |
$5,772 |
$6,004 |
$6,263 |
$6,415 |
$6,720 |
$7,239 |
|
|
2.48% |
<-IRR #YR-> |
5 |
Cash Flow less WC |
13.02% |
|
| CFPS Excl. WC |
$3.99 |
$4.40 |
$4.64 |
$6.18 |
$6.73 |
$7.21 |
$7.50 |
$8.06 |
$8.51 |
$8.29 |
$9.50 |
$10.23 |
$10.28 |
$11.80 |
$13.20 |
|
|
6.62% |
<-IRR #YR-> |
10 |
CF less WC 5 Yr Run |
89.89% |
|
| Increase |
14.29% |
10.52% |
5.34% |
33.21% |
8.84% |
7.15% |
4.05% |
7.46% |
5.54% |
-2.52% |
14.52% |
7.72% |
0.49% |
14.79% |
11.86% |
|
|
3.35% |
<-IRR #YR-> |
5 |
CF less WC 5 Yr Run |
17.89% |
|
| 5 year Running Average |
$3.17 |
$3.51 |
$3.84 |
$4.54 |
$5.19 |
$5.83 |
$6.45 |
$7.14 |
$7.60 |
$7.91 |
$8.37 |
$8.92 |
$9.36 |
$10.02 |
$11.00 |
|
|
8.28% |
<-IRR #YR-> |
10 |
CFPS - Less WC |
121.55% |
|
| P/CF on Med Price |
9.15 |
9.46 |
11.51 |
11.55 |
11.81 |
11.16 |
13.15 |
12.99 |
13.29 |
14.67 |
15.44 |
15.25 |
15.19 |
14.20 |
0.00 |
|
|
4.99% |
<-IRR #YR-> |
5 |
CFPS - Less WC |
27.54% |
|
| P/CF on Closing Price |
10.06 |
10.25 |
13.05 |
12.95 |
11.50 |
12.53 |
13.82 |
12.54 |
13.81 |
16.88 |
14.26 |
15.72 |
16.20 |
14.12 |
12.63 |
|
|
9.31% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
143.65% |
|
| *Operational Cash Flow
per share |
|
|
CF/-WC |
P/CF Med |
10 yr |
13.44 |
5 yr |
14.41 |
P/CF Med |
10 yr |
13.22 |
5 yr |
15.19 |
|
6.80% |
Diff M/C |
|
5.58% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
31.18% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-830.6 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
642.7 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
|
|
|
|
|
-725.3 |
0.0 |
0.0 |
0.0 |
0.0 |
642.7 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
-$3,548 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$6,965 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
|
|
|
|
|
-$5,918 |
$0 |
$0 |
$0 |
$0 |
$6,965 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
-$4.27 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$10.84 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
|
|
|
|
|
-$8.16 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$10.84 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
-$3.38 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.54 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$6.98 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.54 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
-$3,854 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$6,607 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
|
|
|
|
|
-$5,846 |
$0 |
$0 |
$0 |
$0 |
$6,607 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
-$3,378 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$6,415 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
|
|
|
|
|
-$5,442 |
$0 |
$0 |
$0 |
$0 |
$6,415 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
-$4.64 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$10.28 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
|
|
|
|
|
-$8.06 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$10.28 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
-$3.84 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.36 |
|
|
|
|
|
|
|
5 yr Running Average |
|
|
|
|
|
|
|
|
|
|
-$7.14 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.36 |
|
|
|
|
|
|
|
5 yr Running Average |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chge in Operating Assets & Liab. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts receivable |
-$51 |
-$20 |
$32 |
-$59 |
$188 |
-$3 |
-$125 |
-$91 |
-$7 |
$158 |
-$22 |
-$290 |
$71 |
|
|
|
|
|
|
|
|
|
|
| Material and supplies |
$11 |
-$30 |
-$38 |
-$51 |
$4 |
-$2 |
-$70 |
-$120 |
-$60 |
$20 |
-$7 |
-$82 |
-$18 |
|
|
|
|
|
|
|
|
|
|
| Accounts payable and other |
$34 |
$129 |
-$245 |
|
-$282 |
-$51 |
$418 |
$379 |
-$498 |
-$49 |
$141 |
-$9 |
-$191 |
|
|
|
|
|
|
|
|
|
|
| Other current assets |
-$2 |
-$13 |
$13 |
$5 |
$46 |
$21 |
-$80 |
$14 |
$5 |
$0 |
$35 |
-$30 |
$85 |
|
|
|
|
|
|
|
|
|
|
| Pensions and other, net |
-$540 |
-$780 |
-$68 |
-$67 |
-$112 |
-$256 |
-$197 |
-$110 |
$424 |
$146 |
$168 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Othere Operating Activities, Net |
|
|
|
|
|
|
|
|
|
|
|
$214 |
$411 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sum |
-$548 |
-$714 |
-$306 |
-$172 |
-$156 |
-$291 |
-$54 |
$72 |
-$136 |
$275 |
$315 |
-$197 |
$358 |
|
|
|
|
|
|
|
|
|
|
| Google --> TD |
|
-$714 |
-$306 |
-$172 |
-$156 |
-$291 |
-$54 |
$72 |
-$136 |
$275 |
$315 |
-$197 |
$358 |
|
|
|
|
|
|
|
|
|
|
| Difference |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
| TD |
|
|
|
-$172 |
-$156 |
-$291 |
-$54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Difference |
|
|
|
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| OPM |
32.96% |
30.85% |
33.55% |
39.81% |
40.76% |
43.22% |
42.30% |
41.32% |
39.71% |
44.61% |
48.15% |
38.97% |
41.39% |
42.77% |
|
|
|
23.36% |
<-Total Growth |
10 |
OPM |
|
|
| Increase |
-8.80% |
-6.42% |
8.77% |
18.67% |
2.37% |
6.03% |
-2.13% |
-2.30% |
-3.91% |
12.36% |
7.93% |
-19.06% |
6.20% |
3.33% |
|
|
|
|
Should increase |
|
or be stable. |
|
|
| Diff from Ave |
-19.7% |
-24.8% |
-18.3% |
-3.0% |
-0.7% |
5.3% |
3.1% |
0.7% |
-3.3% |
8.7% |
17.3% |
-5.0% |
0.8% |
4.2% |
|
|
|
0.01 |
<-Median-> |
10 |
OPM |
|
|
| *Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
|
|
OPM |
10 Yrs |
41.04% |
5 Yrs |
41.32% |
|
|
|
|
|
should be |
zero, it is a |
|
check on
calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$8,510 |
<-12 mths |
-0.62% |
|
|
|
|
|
|
|
| Adjusted EBITDA |
|
$4,638 |
$4,881 |
$5,702 |
$6,453 |
$6,561 |
$6,861 |
$7,040 |
$7,326 |
$6,995 |
$7,351 |
$8,733 |
$8,563 |
$9,069 |
$9,775 |
|
|
75.44% |
<-Total Growth |
10 |
Adjusted EBITDA |
|
|
| Change |
|
|
5.24% |
16.82% |
13.17% |
1.67% |
4.57% |
2.61% |
4.06% |
-4.52% |
5.09% |
18.80% |
-1.95% |
5.91% |
7.78% |
|
|
4.32% |
<-Median-> |
10 |
Change |
|
|
| Margin |
|
46.75% |
46.16% |
46.99% |
51.17% |
54.51% |
52.61% |
49.16% |
49.11% |
50.62% |
50.78% |
51.05% |
50.89% |
51.14% |
52.18% |
|
|
50.83% |
<-Median-> |
10 |
Margin |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long Term Debt |
$6,323 |
$6,441 |
$6,819 |
$7,865 |
$8,985 |
$9,448 |
$8,748 |
$11,385 |
$11,866 |
$11,996 |
$11,977 |
$14,372 |
$16,133 |
$16,133 |
|
|
|
136.59% |
<-Total Growth |
10 |
Debt |
Type |
|
| Change |
|
1.87% |
5.87% |
15.34% |
14.24% |
5.15% |
-7.41% |
30.14% |
4.22% |
1.10% |
-0.16% |
20.00% |
12.25% |
0.00% |
|
|
|
0.09 |
<-Median-> |
10 |
Change |
Lg Term R |
|
| Debt/Market Cap Ratio |
0.18 |
0.17 |
0.14 |
0.12 |
0.15 |
0.14 |
0.11 |
0.16 |
0.14 |
0.12 |
0.13 |
0.13 |
0.15 |
0.15 |
|
|
|
0.14 |
<-Median-> |
10 |
Debt/Market Cap Ratio |
Intang/GW |
|
| Assets/Current
Liabilities Ratio |
15.18 |
12.10 |
12.07 |
14.44 |
12.14 |
12.32 |
9.45 |
11.78 |
10.21 |
13.68 |
15.56 |
13.19 |
10.46 |
10.46 |
|
|
|
12.23 |
<-Median-> |
10 |
Assets/Current Liab Ratio |
Liquidity |
|
| Current
Liabilities/Asset Ratio |
0.07 |
0.08 |
0.08 |
0.07 |
0.08 |
0.08 |
0.11 |
0.08 |
0.10 |
0.07 |
0.06 |
0.08 |
0.10 |
0.10 |
|
|
|
0.08 |
<-Median-> |
10 |
Current Liab/Asset Ratio |
Liq. + CF |
|
| Debt to Cash Flow
(Years) |
2.12 |
2.10 |
1.92 |
1.63 |
1.75 |
1.82 |
1.59 |
1.92 |
2.00 |
1.95 |
1.72 |
2.16 |
2.32 |
2.13 |
|
|
|
1.87 |
<-Median-> |
10 |
Debt to Cash Flow (Years) |
Debt Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Leverage |
|
| Intangibles |
$54 |
$57 |
$59 |
$62 |
$71 |
$67 |
$62 |
$73 |
$152 |
$145 |
$139 |
$335 |
$644 |
|
|
|
|
991.53% |
<-Total Growth |
10 |
Intangibles |
D/E Ratio |
|
| Goodwill |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$77 |
$70 |
$70 |
$70 |
$70 |
|
|
|
|
#DIV/0! |
<-Total Growth |
10 |
Goodwill |
|
|
| Total |
$54 |
$57 |
$59 |
$62 |
$71 |
$67 |
$62 |
$73 |
$229 |
$215 |
$209 |
$405 |
$714 |
$714 |
|
|
|
1110.17% |
<-Total Growth |
10 |
Total |
|
|
| Change |
|
5.56% |
3.51% |
5.08% |
14.52% |
-5.63% |
-7.46% |
$0 |
213.70% |
-6.11% |
-2.79% |
93.78% |
76.30% |
0.00% |
|
|
|
|
|
|
Change |
|
|
| Intangible/Market Cap
Ratio |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
$73 |
0.00 |
0.00 |
0.00 |
0.00 |
0.01 |
0.01 |
|
|
|
0.00 |
<-Median-> |
10 |
Intangible/Market Cap Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
$1,848 |
$1,869 |
$1,977 |
$2,066 |
$2,153 |
$2,107 |
$2,190 |
$2,728 |
$2,830 |
$3,102 |
$3,426 |
$3,217 |
$3,089 |
$3,089 |
|
|
|
Net ratio of 1.5 and up |
|
Assets |
|
|
| Current Liabilities |
$1,715 |
$2,203 |
$2,498 |
$2,201 |
$2,998 |
$3,008 |
$3,983 |
$3,500 |
$4,287 |
$3,274 |
$3,120 |
$3,842 |
$5,035 |
$5,035 |
|
|
|
0.75 |
<-Median-> |
10 |
Ratio |
|
|
| Liquidity |
1.08 |
0.85 |
0.79 |
0.94 |
0.72 |
0.70 |
0.55 |
0.78 |
0.66 |
0.95 |
1.10 |
0.84 |
0.61 |
0.61 |
|
|
|
0.84 |
<-Median-> |
5 |
Ratio |
|
|
| Liq. with CF aft div |
2.48 |
1.95 |
1.93 |
2.77 |
2.10 |
2.05 |
1.63 |
2.09 |
1.68 |
2.33 |
2.78 |
2.06 |
1.59 |
1.59 |
|
|
|
2.06 |
<-Median-> |
5 |
Ratio |
|
|
| Liq. CF re Inv+Div |
1.23 |
1.18 |
1.11 |
1.39 |
1.08 |
1.09 |
0.96 |
1.06 |
0.85 |
1.23 |
1.45 |
1.25 |
0.94 |
0.94 |
|
|
|
1.23 |
<-Median-> |
5 |
Ratio |
|
|
| CF to Cur. Debt |
1.74 |
1.39 |
1.42 |
2.19 |
1.71 |
1.73 |
1.38 |
1.69 |
1.38 |
1.88 |
2.23 |
1.74 |
1.38 |
1.38 |
|
|
|
1.74 |
<-Median-> |
5 |
Ratio |
|
|
| Curr Long Term Debt |
$135 |
$577 |
$1,021 |
$544 |
$1,442 |
$1,489 |
$1,489 |
$1,489 |
$1,930 |
$910 |
$508 |
$1,057 |
$2,340 |
$2,340 |
|
|
|
|
|
|
|
|
|
| Liquidity Less CLTD |
1.17 |
1.15 |
1.34 |
1.25 |
1.38 |
1.39 |
0.88 |
1.36 |
1.20 |
1.31 |
1.31 |
1.16 |
1.15 |
1.15 |
|
|
|
1.20 |
<-Median-> |
5 |
Ratio |
|
|
| Liq. with CF aft div |
2.69 |
2.64 |
3.26 |
3.67 |
4.05 |
4.06 |
2.60 |
3.64 |
3.06 |
3.23 |
3.32 |
2.84 |
2.98 |
3.15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Assets |
$26,026 |
$26,659 |
$30,163 |
$31,792 |
$36,402 |
$37,057 |
$37,629 |
$41,214 |
$43,784 |
$44,804 |
$48,538 |
$50,662 |
$52,666 |
$52,666 |
|
|
|
Debt Ratio of 1.5 and up, best |
|
|
|
|
| Liabilities |
$15,346 |
$15,641 |
$17,210 |
$18,322 |
$21,452 |
$22,216 |
$20,973 |
$23,573 |
$25,743 |
$25,153 |
$25,794 |
$29,278 |
$32,549 |
$32,549 |
|
|
|
1.73 |
<-Median-> |
10 |
Ratio |
|
|
| Debt Ratio |
1.70 |
1.70 |
1.75 |
1.74 |
1.70 |
1.67 |
1.79 |
1.75 |
1.70 |
1.78 |
1.88 |
1.73 |
1.62 |
1.62 |
|
|
|
1.73 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Estimates BVPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
$29.30 |
$29.90 |
|
|
|
Estimates |
|
Estimates BVPS |
|
|
| Estimate Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
$18,831.1 |
$19,216.7 |
|
|
|
Estimates |
|
Estimate Book Value |
|
|
| P/B Ratio (Close) |
|
|
|
|
|
|
|
|
|
|
|
|
|
5.69 |
5.57 |
|
|
|
Estimates |
|
P/B Ratio (Close) |
|
|
| Difference from 10 year
median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
29.32% |
Diff M/C |
|
|
Estimates |
|
Difference from 10 yr med. |
|
|
| Book Value |
$10,680 |
$11,018 |
$12,953 |
$13,470 |
$14,950 |
$14,841 |
$16,656 |
$17,641 |
$18,041 |
$19,651 |
$22,744 |
$21,384 |
$20,117 |
$20,117 |
$20,117 |
$20,117 |
|
55.31% |
<-Total Growth |
10 |
Book Value |
|
|
| Book Value per Share |
$12.08 |
$12.86 |
$15.59 |
$16.64 |
$18.99 |
$19.48 |
$22.43 |
$24.32 |
$25.33 |
$27.67 |
$32.45 |
$31.87 |
$31.30 |
$31.30 |
$31.30 |
$31.30 |
|
100.71% |
<-Total Growth |
10 |
Book Value per Share |
|
|
| Change |
-1.48% |
6.46% |
21.27% |
6.72% |
14.12% |
2.55% |
15.16% |
8.44% |
4.13% |
9.23% |
17.29% |
-1.79% |
-1.78% |
0.00% |
0.00% |
0.00% |
|
110.17% |
P/B Ratio |
|
Current/Historical Median |
|
|
| P/B Ratio (Median) |
3.02 |
3.24 |
3.42 |
4.29 |
4.18 |
4.13 |
4.40 |
4.30 |
4.46 |
4.40 |
4.52 |
4.89 |
4.99 |
5.35 |
0.00 |
0.00 |
|
2.53 |
P/B Ratio |
|
Historical Median |
|
|
| P/B Ratio (Close) |
3.32 |
3.51 |
3.88 |
4.81 |
4.07 |
4.64 |
4.62 |
4.16 |
4.64 |
5.06 |
4.17 |
5.05 |
5.32 |
5.32 |
5.32 |
5.32 |
|
7.22% |
<-IRR #YR-> |
10 |
Book Value per Share |
100.71% |
|
| Change |
22.62% |
5.86% |
10.57% |
23.82% |
-15.29% |
13.91% |
-0.39% |
-10.04% |
11.57% |
9.06% |
-17.50% |
20.94% |
5.43% |
0.06% |
0.00% |
0.00% |
|
5.17% |
<-IRR #YR-> |
5 |
Book Value per Share |
28.69% |
|
| Leverage (A/BK) Ratio |
2.44 |
2.42 |
2.33 |
2.36 |
2.43 |
2.50 |
2.26 |
2.34 |
2.43 |
2.28 |
2.13 |
2.37 |
2.62 |
2.62 |
|
|
|
2.36 |
<-Median-> |
10 |
A/BV |
|
|
| Debt/Equity Ratio |
1.44 |
1.42 |
1.33 |
1.36 |
1.43 |
1.50 |
1.26 |
1.34 |
1.43 |
1.28 |
1.13 |
1.37 |
1.62 |
1.62 |
|
|
|
1.36 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
|
| Sharerholders
Equity (Assets less liabilities) |
|
|
|
|
|
|
|
P/BV |
10 yr Med |
4.40 |
5 yr Med |
4.52 |
|
21.05% |
Diff M/C |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$15.59 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$31.30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$24.32 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$31.30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Comprehensive Income |
$1,327 |
$2,262 |
$4,019 |
$2,590 |
$4,198 |
$3,049 |
$5,058 |
$4,263 |
$3,582 |
$3,573 |
$6,369 |
$5,390 |
$5,315 |
|
|
|
|
32.25% |
<-Total Growth |
10 |
Comprehensive Income |
|
|
| Increase |
-1.19% |
70.46% |
77.67% |
-35.56% |
62.08% |
-27.37% |
65.89% |
-15.72% |
-15.97% |
-0.25% |
78.25% |
-15.37% |
-1.39% |
|
|
|
|
-1.39% |
<-Median-> |
5 |
Comprehensive Income |
|
|
| 5 Yr Running Average |
$1,535 |
$1,553 |
$2,002 |
$2,308 |
$2,879 |
$3,224 |
$3,783 |
$3,832 |
$4,030 |
$3,905 |
$4,569 |
$4,635 |
$4,846 |
|
|
|
|
2.83% |
<-IRR #YR-> |
10 |
Comprehensive Income |
32.25% |
|
| ROE |
12.43% |
20.53% |
31.03% |
19.23% |
28.08% |
20.54% |
30.37% |
24.17% |
19.85% |
18.18% |
28.00% |
25.21% |
26.42% |
|
|
|
|
4.51% |
<-IRR #YR-> |
5 |
Comprehensive Income |
24.68% |
|
| 5Yr Median |
12.43% |
12.43% |
12.43% |
19.23% |
20.53% |
20.54% |
28.08% |
24.17% |
24.17% |
20.54% |
24.17% |
24.17% |
25.21% |
|
|
|
|
9.24% |
<-IRR #YR-> |
10 |
5 Yr Running Average |
142.00% |
|
| % Difference from NI |
-46.0% |
-15.6% |
53.9% |
-18.2% |
18.7% |
-16.2% |
-7.8% |
-1.5% |
-15.0% |
0.3% |
30.2% |
5.3% |
-5.5% |
|
|
|
|
4.81% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
26.47% |
|
| Median Values |
|
|
|
|
|
|
|
|
|
Diff |
5, 10 yr |
-3.5% |
0.3% |
|
|
|
|
25.2% |
<-Median-> |
5 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,019 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$5,315 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,263 |
$0 |
$0 |
$0 |
$0 |
$5,315 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,002 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$4,846 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3,832 |
$0 |
$0 |
$0 |
$0 |
$4,846 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liability
Coverage Ratio |
2.05 |
1.71 |
1.54 |
2.27 |
1.77 |
1.83 |
1.40 |
1.67 |
1.41 |
1.80 |
2.13 |
1.79 |
1.31 |
1.51 |
|
|
|
|
|
|
CFO / Current Liabilities |
|
|
| 5 year Median |
1.68 |
1.71 |
1.71 |
1.71 |
1.77 |
1.77 |
1.77 |
1.77 |
1.67 |
1.67 |
1.67 |
1.79 |
1.79 |
1.79 |
|
|
|
177.7% |
<-Median-> |
10 |
Current Liability Cov Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Asset Efficiency Ratio |
13.54% |
14.16% |
12.78% |
15.74% |
14.55% |
14.82% |
14.80% |
14.18% |
13.84% |
13.15% |
13.71% |
13.55% |
12.55% |
14.40% |
|
|
|
|
|
|
CFO / Total Assets |
|
|
| 5 year Median |
11.09% |
12.71% |
12.78% |
13.54% |
14.16% |
14.55% |
14.80% |
14.80% |
14.55% |
14.18% |
13.84% |
13.71% |
13.55% |
13.55% |
|
|
|
14.0% |
<-Median-> |
10 |
Return on Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Return on Assets ROA |
9.44% |
10.05% |
8.66% |
9.96% |
9.72% |
9.82% |
14.57% |
10.50% |
9.63% |
7.95% |
10.08% |
10.10% |
10.68% |
9.59% |
|
|
|
Net |
Income/Assets |
|
Return on Assets |
|
|
| 5Yr Median |
8.35% |
8.35% |
8.66% |
9.44% |
9.72% |
9.82% |
9.82% |
9.96% |
9.82% |
9.82% |
10.08% |
10.08% |
10.08% |
10.08% |
|
|
|
10.0% |
<-Median-> |
10 |
Asset Efficiency Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Return on Equity ROE |
23.01% |
24.32% |
20.17% |
23.51% |
23.67% |
24.53% |
32.93% |
24.53% |
23.37% |
18.13% |
21.51% |
23.93% |
27.96% |
25.10% |
|
|
|
Net Inc/ |
Shareholders' equity |
|
Return on Equity |
|
|
| 5Yr Median |
18.68% |
18.68% |
20.17% |
23.01% |
23.51% |
23.67% |
23.67% |
24.53% |
24.53% |
24.53% |
23.37% |
23.37% |
23.37% |
23.93% |
|
|
|
23.8% |
<-Median-> |
10 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$5,513 |
<-12 mths |
-1.99% |
|
|
|
|
|
|
|
| Net Income |
$2,457 |
$2,680 |
$2,612 |
$3,167 |
$3,538 |
$3,640 |
$5,484 |
$4,328 |
$4,216 |
$3,562 |
$4,892 |
$5,118 |
$5,625 |
$5,049 |
$5,489 |
|
|
115.35% |
<-Total Growth |
10 |
Net Income |
+ Alpha Sp |
|
| Increase |
16.78% |
9.08% |
-2.54% |
21.25% |
11.71% |
2.88% |
50.66% |
-21.08% |
-2.59% |
-15.51% |
37.34% |
4.62% |
9.91% |
-10.24% |
8.71% |
|
|
EPS/CF Ratio should not be higher than 1.00 |
|
|
| 5 Yr Running Average |
$2,079 |
$2,198 |
$2,341 |
$2,604 |
$2,891 |
$3,127 |
$3,688 |
$4,031 |
$4,241 |
$4,246 |
$4,496 |
$4,423 |
$4,683 |
$4,849 |
$5,235 |
|
|
7.97% |
<-IRR #YR-> |
10 |
Net Income |
115.35% |
|
| Operating Cash Flow |
$2,976 |
$3,060 |
$3,548 |
$4,831 |
$5,140 |
$5,202 |
$5,516 |
$5,918 |
$5,923 |
$6,165 |
$6,971 |
$6,667 |
$6,965 |
|
|
|
|
5.38% |
<-IRR #YR-> |
5 |
Net Income |
29.97% |
|
| Investment Cash Flow |
-$1,729 |
-$1,421 |
-$1,852 |
-$2,176 |
-$2,827 |
-$2,655 |
-$2,738 |
-$3,404 |
-$4,190 |
-$2,946 |
-$2,873 |
-$2,510 |
-$3,468 |
|
|
|
|
7.18% |
<-IRR #YR-> |
10 |
5 Yr Running Ave. |
99.99% |
|
| Total Accruals |
$1,210 |
$1,041 |
$916 |
$512 |
$1,225 |
$1,093 |
$2,706 |
$1,814 |
$2,483 |
$343 |
$794 |
$961 |
$2,128 |
|
|
|
|
3.04% |
<-IRR #YR-> |
5 |
5 Yr Running Ave. |
16.15% |
|
| Total Assets |
$26,026 |
$26,659 |
$30,163 |
$31,792 |
$36,402 |
$37,057 |
$37,629 |
$41,214 |
$43,784 |
$44,804 |
$48,538 |
$50,662 |
$52,666 |
|
|
|
|
|
Balance Sheet |
|
Assets |
|
|
| Accruals Ratio |
4.65% |
3.90% |
3.04% |
1.61% |
3.37% |
2.95% |
7.19% |
4.40% |
5.67% |
0.77% |
1.64% |
1.90% |
4.04% |
|
|
|
|
1.90% |
<-Median-> |
5 |
Ratio |
|
|
| EPS/CF Ratio |
0.68 |
0.69 |
0.67 |
0.62 |
0.65 |
0.65 |
0.97 |
0.73 |
0.69 |
0.60 |
0.73 |
0.73 |
0.83 |
|
|
|
|
0.71 |
<-Median-> |
10 |
EPS/CF Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,612 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$5,625 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,328 |
$0 |
$0 |
$0 |
$0 |
$5,625 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,341 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$4,683 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,031 |
$0 |
$0 |
$0 |
$0 |
$4,683 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Change in Close |
20.80% |
12.70% |
34.09% |
32.13% |
-3.34% |
16.82% |
14.71% |
-2.45% |
16.18% |
19.13% |
-3.23% |
18.77% |
3.55% |
0.06% |
0.00% |
0.00% |
|
|
Count |
28 |
Years of data |
|
|
| up/down |
|
|
|
|
|
|
|
down |
|
down |
|
|
|
|
|
|
|
|
Count |
6 |
21.43% |
|
|
| Meet Prediction? |
|
|
|
|
|
|
|
Yes |
|
|
|
|
|
|
|
|
|
% right |
Count |
2 |
33.33% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Financial Cash Flow |
-$1,650 |
-$1,582 |
-$1,656 |
-$2,370 |
-$2,223 |
-$2,539 |
-$2,895 |
-$2,308 |
$1,903 |
-$2,707 |
-$3,857 |
-$4,667 |
-$4,667 |
|
|
|
|
|
C F Statement |
|
Financial Cash Flow |
|
|
| Total Accruals |
$2,860 |
$2,623 |
$2,572 |
$2,882 |
$3,448 |
$3,632 |
$5,601 |
$4,122 |
$580 |
$3,050 |
$4,651 |
$5,628 |
$6,795 |
|
|
|
|
|
|
|
Accruals |
|
|
| Accruals Ratio |
10.99% |
9.84% |
8.53% |
9.07% |
9.47% |
9.80% |
14.88% |
10.00% |
1.32% |
6.81% |
9.58% |
11.11% |
12.90% |
|
|
|
|
9.58% |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
$101 |
$155 |
$214 |
$515 |
$676 |
$672 |
$553 |
$759 |
$588 |
$1,100 |
$1,341 |
$834 |
$924 |
$924 |
|
|
|
|
|
|
Cash |
|
|
| Cash per Share |
$0.11 |
$0.18 |
$0.26 |
$0.64 |
$0.86 |
$0.88 |
$0.74 |
$1.05 |
$0.83 |
$1.55 |
$1.91 |
$1.24 |
$1.44 |
$1.44 |
|
|
|
$1.44 |
<-Median-> |
5 |
Cash per Share |
|
|
| Percentage of Stock
Price |
0.29% |
0.40% |
0.43% |
0.80% |
1.11% |
0.98% |
0.72% |
1.03% |
0.70% |
1.11% |
1.41% |
0.77% |
0.86% |
0.86% |
|
|
|
0.86% |
<-Median-> |
5 |
% of Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Notes: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| January 27,
2024. Last estimates were for 2023,
2024 and 2025 $175750M, $18368M, $19190M for Revenue, $7.81, $8.57 and $8.98
for AEPS, $7.86, $8.66 and $9.35 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
| $3.14, $3.32
and $3.65 for Dividends, $4402M, $4737M and $5023M for FCF, $11.20, $12.30
and $13.20 for CFPS, $5187M, $5559M and $5881M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| January 28,
2022. Last estimates were for 2022,
2023 and 2024 of $15578M, $16644M and $17511M for Revenue, $7.11, $7.98 and
$8.48 for EPS, $2.77, $2.92 amd $3.30 for Dividends, |
|
|
|
|
|
|
|
|
|
|
|
| $4052M,
$4457M and $4678M for FCF, $10.10, $11.50 and $12.30 for CFPS, $30.10, $30.60
and $34.90 for BVPS, and $4884M, $5298M and $5583M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
| January 25,
2022. Last estimates were for 2021,
2022 and 2023 of 14,711M, $15775M and $16735M for Revenue, $5.92, $6.66 and
$7.43 for EPS, $2.44, $2.50 and $2.70 for Dividends, |
|
|
|
|
|
|
|
|
|
|
|
| $3206M,
$3756M and $4036M for FCF, $8.83, $9.68 and $10.80 for CFPS and $4177M,
$4603M and $5028M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Januayr 30,
2021. Last estimates were for 2020,
2021 and 2022 of $15589M, $16548M and $17403M for Revenue, $6.21, $6.87 and
$7.56 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $8.96, $10.00
and $10.40 for CPFS and $4397M, $4765M and $5100M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| January 1,
2020. Last estimates were for 2019.
2020 and 2021 of $15571M, $16455M and $17197M for Revenue, $6.26, $6.86 and
$7.42 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $8.94, $9.69
and $10.40 for CFPS, $4499M, $4825M and $5093M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| February 3,
2018. Last estimates were for 2017,
2018 and 2019 of $12999M, $13370M and $13992M for Revenue, $4.93, $5.34 and
$5.84 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $7.62, $7.59
and $8.10 for CFPS and $3752M, $3955M and $4171M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| February 5,
2017. Last estimates were for 2016,
2017 and 2018 of $12218M, $12911M and $13213M for Revenue, $4.51, $4.94 and
$5.34 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $6.98, $7.40 and $7.52 for CFPS and $3506M,
$3705M and $3894M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| December 10,
2016. Last estimes were for 2016, 2017
and 2018 of $13069M, 13632M and 14465M for Revenue, $4.61, $5.00 and $5.60
for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $6.75, $6.89
and $7.80 for CFPS and $36312M, $3864M and $4109M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| February 6,
2016. Last estimates were for 2015,
2016 and 2017 of $12893M, $13805M and $14723M for Revenue, $4.23, $4.76, and
$5.20 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $5.87, $6.35
and $7.14 for CFPS, $3371M, $3731M and $4002M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| February 7,
2015. Last estimates were for 2014,
2015 and 2016 of $11504M, $12244M and $13015M for Revenue, $3.51 and $3.93
and $4.30 for EPS, $4.79 and $5.35 for 2014 and 2015 for CFPS. |
|
|
|
|
|
|
|
|
|
|
| February 8,
2014/ Last estimates were for 2013 and
2014 of $10,612M and $11,322M for Revenue and $6.16 and $6.88 for EPS and
f$7.68 for CFPS for 2013. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| February 3,
2013. Last Estimates were for 2012 and
2013 of $9686M and $10339M for Revenues, R5.31 and $5.94 for EPS and $7.75
and f$7.68 for CFPS. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Feb 11,
2012. Last I looked I got estimates
for 2011 and 2012 of $4.70 and $5.34 for EPS and $6.85 and 7.65 for CF. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Feb 21,
2011. Using Unaudited statements for
2010 update. When I last looked I got estimates for 2010 and 2011 of $3.70
and $4.32 for earnings and $5.79 and $6.50 for CF. |
|
|
|
|
|
|
|
|
|
|
|
|
| There seems
to be financial facilities in place to take care of portion of long term debt
for 2010. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Feb 27,
2010. In May 2009, I got figures for
2009 and 2010 of $3.73 and $4.30 for earnings and $5.75 and $6.32 for cash
flow. Earnings at $3.92 higher, CF at $4.84 lower. |
|
|
|
|
|
|
|
|
|
|
|
|
| May 7, 2009.
Earnings for 2009 and 2010 have been revised down from $4 and $4.50 to $3.73
and $4.30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| April 2009 AP
2008. Revenue growth is getting better.
Most indicators are neutral or good except for the Liquidity Ratio
which is low at .93. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AP 2007.
Only 2% of what I hold. TD rates as a
buy and expects it to go to $55. Has not had a bad year, however, increase in
revenue is much lower than profit. WATCH REVENUE, NEEDS TO BE HIGHER |
|
|
|
|
|
|
|
|
|
|
| AR 2006.
Revenue is increase at less than 1/2 rate of EPS for last 5 yrs. Div increase
nicely. TD rates as a hold, but expects a decent return for the year. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2005. This stock is still doing well and is doing
what I expected. Dividend yield is low, but they increase nicely. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2004.
Dividends have only increased Total Growth about 1.5% a year. Not
significate. However, they do increase nicely. Probably more important. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2004.They do
seem to know how to make money for shareholders. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Stopped being
Crown Corp in July 13, 1995 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sector: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Services, Industrial |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| What should
this stock accomplish? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| You should
buy this stock for diversification purposes.
You would expect this stock to be more volatile than a utility, but provide long term gains and increasing dividends. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Would I buy
this company and Why. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| I own this
stock. Yes, I would buy it again. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Why am I following this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| I am
following this stock because I own it. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Why I bought this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| In 2005 I was look for good companies to buy
at a reasonable price. This stock met by criteria. This is a dividend growth
company with a good record of dividend increases. |
|
|
|
|
|
|
|
|
|
|
|
|
| I brought some more in
2009. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| In my RRSP
account, I bought this stock in 2011 and sold in 2013. Reason for sale was to raise money in my
RRSP account for future withdrawals. I
was looking for something to sell with a low dividend yield. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends are
paid quarterly, in cylce 3, which is in March, June, September
and December. The
dividends are paid at the end of the month. Dividends are shareholders of a
month are paid in that month. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| For example,
the March 2014 dividend declared on January 30, 2014 is payable on March 31, 2014 to shareholders of record of March
10, 2014. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Misson
Statement or closes thing I can find. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| What I am
looking for is a statement that the company wants to do well by their
customers, employees, and community and and
thereby earn shareholders a reasonable return. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Creading value for
customers and delivering operational and service
excellence |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| People are the
foundation on which all the other principles are
built. It's about making sure people know what is expected of them and have
the tools and training to do the job. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Playing our role as a
backbone of the ecomony and delivering
responsibly. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Creating value for
Shareholders |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| How they make their
money. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Canadian
National's railway spans Canada from coast to coast and extends through
Chicago to the Gulf of Mexico. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
2016 |
Feb 05 |
2017 |
Feb 03 |
2018 |
Feb 05 |
2019 |
Feb 01 |
2020 |
Jan 30 |
2021 |
Jan 27 |
2022 |
Jan 28 |
2023 |
|
|
Jan 27 |
2024 |
|
|
|
|
| Robinson, Tracy |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.003 |
0.00% |
|
|
0.004 |
0.00% |
|
Appointed Feb 2022 |
14.06% |
|
| CEO - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.550 |
|
|
|
$0.627 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.186 |
0.03% |
|
|
0.531 |
0.08% |
|
|
184.71% |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$31.045 |
|
|
|
$88.441 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Ruest, Jean-Jacques |
|
|
|
|
|
0.124 |
0.02% |
0.147 |
0.02% |
0.167 |
0.02% |
0.000 |
0.00% |
|
|
|
|
|
|
|
|
#DIV/0! |
|
| CEO - Shares - Amount |
|
|
|
|
|
|
$14.580 |
|
$20.613 |
|
$22.623 |
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
|
|
|
|
|
0.903 |
0.13% |
1.134 |
0.16% |
1.460 |
0.21% |
0.000 |
0.00% |
|
|
|
|
|
|
|
|
#DIV/0! |
|
| Options - amount |
|
|
|
|
|
|
$106.068 |
|
$158.668 |
|
$197.761 |
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Houle, Ghislain |
|
0.063 |
0.01% |
-0.066 |
-0.01% |
0.070 |
0.01% |
0.079 |
0.01% |
0.093 |
0.01% |
0.188 |
0.03% |
0.124 |
0.02% |
|
|
0.138 |
0.02% |
|
|
11.24% |
|
| CFO - Shares - Amount |
|
|
$6.564 |
|
-$6.695 |
|
$8.231 |
|
$11.004 |
|
$12.597 |
|
$30.291 |
|
$20.657 |
|
|
|
$22.992 |
|
|
|
|
| Options - percentage |
|
0.208 |
0.03% |
0.284 |
0.04% |
0.282 |
0.04% |
0.000 |
0.00% |
0.469 |
0.07% |
1.325 |
0.20% |
0.469 |
0.07% |
|
|
0.551 |
0.09% |
|
|
17.38% |
|
| Options - amount |
|
|
$21.611 |
|
$28.753 |
|
$33.112 |
|
$0.000 |
|
$63.480 |
|
$213.170 |
|
$78.134 |
|
|
|
$91.766 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| MacDonald, Douglas
Allen |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.015 |
0.00% |
|
|
0.017 |
0.00% |
|
|
16.93% |
|
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.434 |
|
|
|
$2.848 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.103 |
0.02% |
|
|
0.102 |
0.02% |
|
|
-1.24% |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$17.130 |
|
|
|
$16.928 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chouc, Olivier
Pierre-Alix |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.024 |
0.00% |
|
|
0.026 |
0.00% |
|
|
4.96% |
|
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$4.074 |
|
|
|
$4.279 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.078 |
0.01% |
|
|
0.100 |
0.02% |
|
|
28.37% |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$12.990 |
|
|
|
$16.685 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cairns, James Berry |
|
|
|
|
|
|
|
0.000 |
0.00% |
0.000 |
0.00% |
0.111 |
0.02% |
0.002 |
0.00% |
|
|
|
|
|
last report March 2022 |
-100.00% |
|
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
$0.038 |
|
$0.067 |
|
$17.877 |
|
$0.339 |
|
|
|
|
|
No longer on INK |
|
|
| Options - percentage |
|
|
|
|
|
|
|
0.056 |
0.01% |
0.064 |
0.01% |
0.433 |
0.06% |
0.062 |
0.01% |
|
|
|
|
|
|
-100.00% |
|
| Options - amount |
|
|
|
|
|
|
|
|
$7.867 |
|
$8.652 |
|
$69.670 |
|
$10.381 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lalonde, Remi G. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.000 |
0.00% |
|
|
#DIV/0! |
|
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.031 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.033 |
0.01% |
|
|
#DIV/0! |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$5.478 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| McKenzie, Margaret Anne |
|
|
|
|
|
|
|
|
|
0.000 |
0.00% |
0.005 |
0.00% |
0.008 |
0.00% |
|
|
0.005 |
0.00% |
|
|
-39.32% |
|
| Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
$0.064 |
|
$0.752 |
|
$1.381 |
|
|
|
$0.838 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
0.001 |
0.00% |
0.004 |
0.00% |
0.006 |
0.00% |
|
|
0.009 |
0.00% |
|
|
47.13% |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
$0.093 |
|
$0.569 |
|
$1.021 |
|
|
|
$1.504 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jones, Susan C. |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.003 |
0.00% |
|
|
0.003 |
0.00% |
|
|
0.00% |
|
| Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.458 |
|
|
|
$0.458 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.001 |
0.00% |
|
|
0.004 |
0.00% |
|
|
174.93% |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.240 |
|
|
|
$0.660 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Freeman, David |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.001 |
0.00% |
|
|
0.002 |
0.00% |
|
|
103.80% |
|
| Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.167 |
|
|
|
$0.340 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.001 |
0.00% |
|
|
0.004 |
0.00% |
|
|
175.00% |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.240 |
|
|
|
$0.660 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ceased insider May 2022 |
|
|
| Bruder, Shauneen |
|
|
|
|
|
|
|
|
|
0.000 |
0.00% |
0.000 |
0.00% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
#DIV/0! |
|
| Chairman - Shares - Amt |
|
|
|
|
|
|
|
|
|
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
0.013 |
0.00% |
0.017 |
0.00% |
0.021 |
0.00% |
|
|
0.003 |
0.00% |
|
|
-87.33% |
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
$1.753 |
|
$2.658 |
|
$3.425 |
|
|
|
$0.434 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Pace, Robert |
0.03% |
0.201 |
0.03% |
0.205 |
0.03% |
0.205 |
0.03% |
0.205 |
0.03% |
0.209 |
0.03% |
0.259 |
0.04% |
|
|
|
|
|
|
|
|
|
|
| Chairman - Shares - Amt |
$18.122 |
|
$20.788 |
|
$20.774 |
|
$24.135 |
|
$28.752 |
|
$28.320 |
|
$41.678 |
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
0.04% |
0.294 |
0.04% |
0.301 |
0.04% |
0.301 |
0.04% |
0.307 |
0.04% |
0.320 |
0.05% |
0.276 |
0.04% |
|
|
|
|
|
|
|
|
|
|
| Options - amount |
$26.107 |
|
$30.502 |
|
$30.431 |
|
$35.356 |
|
$43.006 |
|
$43.363 |
|
$44.397 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Increase in O/S Shares |
0.32% |
1.600 |
0.21% |
1.200 |
0.16% |
2.100 |
0.29% |
1.150 |
0.16% |
1.400 |
0.20% |
1.100 |
0.16% |
1.000 |
0.15% |
|
|
1.000 |
0.16% |
|
|
|
|
| due to SO |
$193.375 |
|
$144.576 |
|
$124.380 |
|
$212.331 |
|
$135.091 |
|
$195.916 |
|
$148.962 |
|
$160.840 |
|
|
|
$166.550 |
|
|
|
|
| Book Value |
$1.280 |
|
$73.000 |
|
$68.000 |
|
$120.310 |
|
$138.000 |
|
$121.000 |
|
$98.000 |
|
$136.000 |
|
|
|
$110.000 |
|
|
|
|
| Insider Buying |
-$3.219 |
|
-$1.692 |
|
-$2.486 |
|
-$0.137 |
|
-$1.398 |
|
-$2.114 |
|
-$10.238 |
|
-$1.988 |
|
|
|
-$1.675 |
|
|
|
|
| Insider Selling |
$61.819 |
|
$33.324 |
|
$25.884 |
|
$18.080 |
|
$29.196 |
|
$27.030 |
|
$7.036 |
|
$14.449 |
|
|
|
$14.382 |
|
|
|
|
| Net Insider Selling |
$58.600 |
|
$31.632 |
|
$23.399 |
|
$17.943 |
|
$27.799 |
|
$24.917 |
|
-$3.202 |
|
$12.460 |
|
|
|
$12.707 |
|
|
|
|
| % of Market Cap |
0.09% |
|
0.04% |
|
0.03% |
|
0.02% |
|
0.03% |
|
0.03% |
|
0.00% |
|
0.01% |
|
|
|
0.01% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Directors |
|
11 |
|
13 |
|
13 |
|
13 |
|
14 |
|
11 |
|
11 |
|
|
|
11 |
|
|
|
|
|
| Women |
27% |
3 |
27% |
5 |
38% |
5 |
38% |
5 |
38% |
6 |
43% |
5 |
45% |
6 |
55% |
|
|
6 |
55% |
|
|
|
|
| Minorities |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
1 |
9% |
1 |
9% |
|
|
1 |
9% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Institutions/Holdings |
57.10% |
553 |
55.64% |
612 |
53.89% |
|
|
20 |
43.84% |
20 |
45.11% |
20 |
56.48% |
20 |
53.90% |
|
|
20 |
50.82% |
|
|
|
|
| Total Shares Held |
57.20% |
423.047 |
56.97% |
399.174 |
55.04% |
|
|
314.845 |
44.33% |
321.026 |
45.80% |
398.847 |
59.44% |
361.666 |
56.27% |
|
|
326.652 |
50.82% |
|
|
|
|
| Increase/Decrease |
0.68% |
-7.903 |
-1.83% |
-6.677 |
-1.65% |
|
|
0.758 |
0.24% |
0.623 |
0.19% |
-10.596 |
-2.59% |
-2.783 |
-0.76% |
|
|
0.216 |
0.07% |
|
|
|
|
| Starting No. of Shares |
NASDAQ |
430.950 |
NASDAQ |
405.851 |
NASDAQ |
|
|
314.088 |
Top 20 MS |
320.402 |
Top 20 MS |
409.443 |
Top 20 MS |
364.449 |
Top 20 MS |
|
|
326.436 |
Top 20 MS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Copyright ©
2008 Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| My Stock |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|