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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimates |
Estimates |
Estimates |
|
|
|
|
|
|
|
While I try to
be accurate, I assume no responsibility for any figure in this spreadsheet. |
|
|
|
|
|
|
|
|
|
Q2 2024 |
|
|
|
|
|
|
|
|
|
See my website
on stocks or see my blog at the following sites. |
|
|
|
https://spbrunner.com/stocks.html |
|
https://spbrunner.blogspot.com/ |
|
|
|
|
|
|
|
|
|
|
Telus Corp |
|
|
|
|
TSX: |
T |
NYSE: |
TU |
https://www.telus.com/en/ |
|
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 |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
|
|
|
|
Accounting Rules |
|
|
Split Date |
|
|
4/17/13 |
|
|
|
|
|
|
17-Mar-20 |
|
|
|
|
|
|
|
|
|
|
Split Date |
|
|
Split |
|
|
2 |
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
Split |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$20,001 |
<-12 mths |
-0.02% |
|
|
|
|
|
|
|
Revenue* |
$10,397 |
$10,921 |
$11,404 |
$12,002 |
$12,502 |
$12,799 |
$13,304 |
$14,368 |
$14,658 |
$15,463 |
$16,838 |
$18,292 |
$20,005 |
|
|
|
|
75.42% |
<-Total Growth |
10 |
Revenue |
|
|
Other Revenue |
|
|
|
|
|
|
|
|
|
|
$420 |
$120 |
$111 |
|
|
|
|
|
|
|
|
|
|
Revenue* |
$10,397 |
$10,921 |
$11,404 |
$12,002 |
$12,502 |
$12,799 |
$13,304 |
$14,368 |
$14,658 |
$15,463 |
$17,258 |
$18,412 |
$20,116 |
$20,240 |
$20,927 |
$22,058 |
|
76.39% |
<-Total Growth |
10 |
Revenue |
|
|
Increase |
6.32% |
5.04% |
4.42% |
5.24% |
4.17% |
2.38% |
3.95% |
8.00% |
2.02% |
5.49% |
11.61% |
6.69% |
9.25% |
0.62% |
3.39% |
5.40% |
|
5.84% |
<-IRR #YR-> |
10 |
Revenue |
76.39% |
|
5 year Running Average |
$9,702 |
$10,071 |
$10,421 |
$10,901 |
$11,445 |
$11,926 |
$12,402 |
$12,995 |
$13,526 |
$14,118 |
$15,010 |
$16,032 |
$17,181 |
$18,298 |
$19,391 |
$20,351 |
|
6.96% |
<-IRR #YR-> |
5 |
Revenue |
40.01% |
|
Revenue per Share |
$8.00 |
$8.38 |
$9.15 |
$9.85 |
$10.52 |
$10.85 |
$11.16 |
$11.99 |
$12.11 |
$11.98 |
$12.60 |
$12.87 |
$13.70 |
$13.66 |
$14.12 |
$14.88 |
|
5.13% |
<-IRR #YR-> |
10 |
5 yr Running Average |
64.87% |
|
Increase |
5.51% |
4.68% |
9.20% |
7.73% |
6.75% |
3.12% |
2.90% |
7.46% |
1.01% |
-1.13% |
5.17% |
2.14% |
6.50% |
-0.33% |
3.39% |
5.40% |
|
5.74% |
<-IRR #YR-> |
5 |
5 yr Running Average |
32.22% |
|
5 year Running Average |
$7.51 |
$7.82 |
$8.13 |
$8.59 |
$9.18 |
$9.75 |
$10.31 |
$10.87 |
$11.33 |
$11.62 |
$11.97 |
$12.31 |
$12.65 |
$12.96 |
$13.39 |
$13.85 |
|
4.13% |
<-IRR #YR-> |
10 |
Revenue per Share |
49.82% |
|
P/S (Price/Sales) Med |
1.61 |
1.82 |
1.84 |
2.03 |
2.04 |
1.85 |
2.04 |
1.95 |
2.00 |
1.99 |
2.18 |
2.35 |
1.84 |
1.59 |
0.00 |
0.00 |
|
2.70% |
<-IRR #YR-> |
5 |
Revenue per Share |
14.26% |
|
P/S (Price/Sales) Close |
1.80 |
1.94 |
2.00 |
2.13 |
1.82 |
1.97 |
2.13 |
1.89 |
2.08 |
2.10 |
2.36 |
2.03 |
1.72 |
1.64 |
1.59 |
1.51 |
|
4.52% |
<-IRR #YR-> |
10 |
5 yr Running Average |
55.55% |
|
*Revenue in M CDN $ |
|
|
|
|
P/S Med |
20 yr |
1.90 |
15 yr |
1.95 |
10 yr |
2.02 |
5 yr |
2.00 |
|
-18.51% |
Diff M/C |
|
3.07% |
<-IRR #YR-> |
5 |
5 yr Running Average |
16.34% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11,404 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$20,116 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$14,368 |
$0 |
$0 |
$0 |
$0 |
$20,116 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$10,421 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$17,181 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$12,995 |
$0 |
$0 |
$0 |
$0 |
$17,181 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9.15 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$13.70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11.99 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$13.70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$8.13 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$12.65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$10.87 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$12.65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1,470 |
<-12 mths |
7.06% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.00 |
<-12 mths |
5.26% |
|
|
|
|
|
|
|
Adjusted Net Income |
|
|
|
|
|
|
|
|
|
|
|
$1,647 |
$1,373 |
|
|
|
|
|
|
|
|
|
|
Pre-split 2013 |
$3.66 |
$3.99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
$1.83 |
$2.00 |
$2.16 |
$2.41 |
$2.58 |
$2.58 |
$2.63 |
$2.85 |
$2.86 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AEPS* Basic |
$0.92 |
$1.00 |
$1.08 |
$1.21 |
$1.29 |
$1.29 |
$1.32 |
$1.43 |
$1.43 |
$1.06 |
$1.07 |
$1.17 |
$0.95 |
$0.99 |
$1.08 |
$1.25 |
|
-12.04% |
<-Total Growth |
10 |
AEPS |
|
|
Increase |
12.27% |
9.02% |
8.27% |
11.57% |
7.05% |
0.00% |
1.94% |
8.37% |
0.35% |
-25.87% |
0.94% |
9.35% |
-18.80% |
4.21% |
9.09% |
15.74% |
|
10 |
0 |
10 |
Years of Data, EPS P or N |
100.00% |
|
5 year Running Average |
$0.85 |
$0.86 |
$0.90 |
$1.00 |
$1.10 |
$1.17 |
$1.24 |
$1.31 |
$1.35 |
$1.30 |
$1.26 |
$1.23 |
$1.14 |
$1.05 |
$1.05 |
$1.09 |
|
-1.27% |
<-IRR #YR-> |
10 |
AEPS |
-12.04% |
|
AEPS Yield |
6.35% |
6.13% |
5.91% |
5.75% |
6.74% |
6.04% |
5.52% |
6.30% |
5.69% |
4.20% |
3.59% |
4.48% |
4.03% |
4.41% |
4.81% |
5.57% |
|
-7.79% |
<-IRR #YR-> |
5 |
AEPS |
-33.33% |
|
Payout Ratio |
58.74% |
59.65% |
61.11% |
61.41% |
63.57% |
69.77% |
73.95% |
72.28% |
77.45% |
109.91% |
117.27% |
113.85% |
150.46% |
154.59% |
144.11% |
124.51% |
|
2.32% |
<-IRR #YR-> |
10 |
5 yr Running Average |
25.73% |
|
5 year Running Average |
55.63% |
59.64% |
61.24% |
60.15% |
60.90% |
63.10% |
65.96% |
68.20% |
71.40% |
80.67% |
90.17% |
98.15% |
113.79% |
129.21% |
136.06% |
137.50% |
|
-2.74% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-12.95% |
|
Price/AEPS Median |
14.09 |
15.27 |
15.60 |
16.61 |
16.62 |
15.57 |
17.32 |
16.38 |
16.98 |
22.46 |
25.69 |
25.88 |
26.48 |
21.94 |
0.00 |
0.00 |
|
17.15 |
<-Median-> |
10 |
Price/AEPS Median |
|
|
Price/AEPS High |
15.75 |
16.53 |
17.39 |
18.17 |
17.43 |
17.06 |
18.55 |
17.23 |
17.96 |
26.11 |
27.98 |
29.42 |
30.46 |
23.27 |
0.00 |
0.00 |
|
18.36 |
<-Median-> |
10 |
Price/AEPS High |
|
|
Price/AEPS Low |
12.43 |
14.01 |
13.81 |
15.05 |
15.80 |
14.09 |
16.08 |
15.53 |
16.01 |
18.80 |
23.39 |
22.33 |
22.49 |
20.62 |
0.00 |
0.00 |
|
16.05 |
<-Median-> |
10 |
Price/AEPS Low |
|
|
Price/AEPS Close |
15.75 |
16.32 |
16.93 |
17.38 |
14.83 |
16.57 |
18.11 |
15.88 |
17.58 |
23.78 |
27.84 |
22.33 |
24.82 |
22.69 |
20.80 |
17.97 |
|
17.84 |
<-Median-> |
10 |
Price/AEPS Close |
|
|
Trailing P/AEPS Close |
17.68 |
17.79 |
18.33 |
19.39 |
15.88 |
16.57 |
18.46 |
17.21 |
17.64 |
17.63 |
28.10 |
24.42 |
20.15 |
23.64 |
22.69 |
20.80 |
|
18.05 |
<-Median-> |
10 |
Trailing P/AEPS Close |
|
|
Median Values |
|
DPR |
10 Yrs |
75.70% |
5 Yrs |
113.85% |
P/CF |
5 Yrs |
in order |
25.69 |
27.98 |
22.33 |
23.78 |
|
-11.68% |
Diff M/C |
|
|
|
|
DPR 75% to 95% best |
|
|
* Adjusted Earnings per
Share |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.08 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.95 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.43 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.95 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.90 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.31 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.53 |
<-12 mths |
-8.62% |
|
|
|
|
|
|
|
Pre-split 2013 |
|
$4.06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
$1.88 |
$2.03 |
$2.02 |
$2.31 |
$2.29 |
$2.06 |
$2.46 |
$2.68 |
$2.90 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EPS Basic |
$0.94 |
$1.02 |
$1.01 |
$1.16 |
$1.15 |
$1.03 |
$1.23 |
$1.34 |
$1.45 |
$0.95 |
$1.23 |
$1.16 |
$0.58 |
|
|
|
|
-42.57% |
<-Total Growth |
10 |
EPS Basic |
|
|
Pre-split 2013 |
$3.74 |
$4.03 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
$1.87 |
$2.02 |
$2.01 |
$2.31 |
$2.29 |
$2.06 |
$2.46 |
$2.68 |
$2.90 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EPS* |
$0.94 |
$1.01 |
$1.01 |
$1.16 |
$1.15 |
$1.03 |
$1.23 |
$1.34 |
$1.45 |
$0.94 |
$1.22 |
$1.15 |
$0.58 |
$0.70 |
$0.99 |
$1.21 |
|
-42.29% |
<-Total Growth |
10 |
EPS Diluted |
|
|
Increase |
16.15% |
7.75% |
-0.25% |
14.93% |
-0.87% |
-10.04% |
19.42% |
8.94% |
8.21% |
-35.17% |
29.79% |
-5.74% |
-49.57% |
21.02% |
41.10% |
21.77% |
|
10 |
0 |
10 |
Years of Data, EPS P or N |
|
|
Earnings Yield |
6.5% |
6.2% |
5.5% |
5.5% |
6.0% |
4.8% |
5.2% |
5.9% |
5.8% |
3.7% |
4.1% |
4.4% |
2.5% |
3.1% |
4.4% |
5.4% |
|
-5.35% |
<-IRR #YR-> |
10 |
Earnings per Share |
-42.29% |
|
5 year Running Average |
$0.87 |
$0.88 |
$0.91 |
$0.98 |
$1.05 |
$1.07 |
$1.11 |
$1.18 |
$1.24 |
$1.20 |
$1.24 |
$1.22 |
$1.07 |
$0.92 |
$0.93 |
$0.93 |
|
-15.42% |
<-IRR #YR-> |
5 |
Earnings per Share |
-56.72% |
|
10 year Running Average |
$0.61 |
$0.73 |
$0.80 |
$0.88 |
$0.95 |
$0.97 |
$1.00 |
$1.04 |
$1.11 |
$1.12 |
$1.15 |
$1.17 |
$1.12 |
$1.08 |
$1.06 |
$1.08 |
|
1.64% |
<-IRR #YR-> |
10 |
5 yr Running Average |
17.69% |
|
* ESP per share (Cdn
GAAP) |
|
|
|
|
|
|
|
|
E/P |
10 Yrs |
4.99% |
5Yrs |
4.10% |
|
|
|
|
-1.97% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-9.49% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.01 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.34 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.91 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.18 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend* |
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.55 |
$1.65 |
$1.77 |
|
|
Estimates |
|
Dividend* |
|
|
Increase |
|
|
|
|
|
|
|
|
|
|
|
|
|
8.58% |
6.57% |
7.19% |
|
|
Estimates |
|
Increase |
|
|
Payout Ratio EPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
221.11% |
167.00% |
147.01% |
|
|
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 2013 |
$2.21 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
$1.08 |
$1.19 |
$1.32 |
$1.48 |
$1.64 |
$1.80 |
$1.95 |
$2.06 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend* |
$0.5375 |
$0.5950 |
$0.6600 |
$0.7400 |
$0.8200 |
$0.9000 |
$0.9725 |
$1.0300 |
$1.1075 |
$1.1650 |
$1.2548 |
$1.3320 |
$1.4294 |
$1.5304 |
$1.5564 |
$1.5564 |
|
116.58% |
<-Total Growth |
10 |
Dividends |
|
|
Increase |
10.26% |
10.70% |
10.92% |
12.12% |
10.81% |
9.76% |
8.06% |
5.91% |
7.52% |
5.19% |
7.71% |
6.15% |
7.31% |
7.07% |
1.70% |
0.00% |
|
28 |
2 |
33 |
Years of data, Count P, N |
|
|
Average Increases 5
Year Running |
14.96% |
9.83% |
8.01% |
9.33% |
10.96% |
10.86% |
10.33% |
9.33% |
8.41% |
7.29% |
6.88% |
6.50% |
6.78% |
6.69% |
5.99% |
4.45% |
|
8.87% |
<-Median-> |
10 |
Average Incr 5 Year Running |
|
|
Dividends 5 Yr Running |
$0.47 |
$0.51 |
$0.55 |
$0.60 |
$0.67 |
$0.74 |
$0.82 |
$0.89 |
$0.97 |
$1.04 |
$1.11 |
$1.18 |
$1.26 |
$1.34 |
$1.42 |
$1.48 |
|
128.26% |
<-Total Growth |
10 |
Dividends 5 Yr Running |
|
|
Yield H/L Price |
4.17% |
3.91% |
3.92% |
3.70% |
3.83% |
4.48% |
4.27% |
4.41% |
4.56% |
4.89% |
4.57% |
4.40% |
5.68% |
7.04% |
|
|
|
4.45% |
<-Median-> |
10 |
Yield H/L Price |
Item |
|
Yield on High Price |
3.73% |
3.61% |
3.51% |
3.38% |
3.65% |
4.09% |
3.99% |
4.20% |
4.31% |
4.21% |
4.19% |
3.87% |
4.94% |
6.64% |
|
|
|
4.14% |
<-Median-> |
10 |
Yield on High
Price |
EPS |
|
Yield on Low Price |
4.73% |
4.26% |
4.43% |
4.08% |
4.02% |
4.95% |
4.60% |
4.65% |
4.84% |
5.85% |
5.01% |
5.10% |
6.69% |
7.50% |
|
|
|
4.90% |
<-Median-> |
10 |
Yield on Low Price |
AEPS |
|
Yield on Close Price |
3.73% |
3.66% |
3.61% |
3.53% |
4.29% |
4.21% |
4.08% |
4.55% |
4.41% |
4.62% |
4.21% |
5.10% |
6.06% |
6.81% |
6.93% |
6.93% |
|
4.35% |
<-Median-> |
10 |
Yield on Close Price |
CFPS |
|
Payout Ratio EPS |
57.49% |
59.06% |
65.67% |
64.07% |
71.62% |
87.38% |
79.07% |
76.87% |
76.38% |
123.94% |
102.85% |
115.83% |
246.45% |
218.04% |
157.15% |
129.05% |
|
83.22% |
<-Median-> |
10 |
DPR EPS |
FCF |
|
DPR EPS 5 Yr Running |
53.54% |
57.71% |
60.72% |
61.54% |
63.89% |
69.54% |
73.54% |
75.64% |
77.97% |
86.39% |
89.48% |
96.55% |
117.77% |
146.16% |
153.01% |
159.99% |
|
76.80% |
<-Median-> |
10 |
DPR EPS 5 Yr Running |
|
|
Payout Ratio CFPS |
27.39% |
24.10% |
25.35% |
26.46% |
27.52% |
32.99% |
29.37% |
30.41% |
34.12% |
32.88% |
39.18% |
39.62% |
46.64% |
39.04% |
43.20% |
#DIV/0! |
|
32.94% |
<-Median-> |
10 |
DPR CF |
|
|
DPR CF 5 Yr Running |
21.50% |
23.33% |
24.39% |
25.58% |
26.17% |
27.36% |
28.38% |
29.35% |
30.86% |
31.91% |
33.13% |
35.18% |
38.30% |
39.27% |
41.41% |
#DIV/0! |
|
30.11% |
<-Median-> |
10 |
DPR CF 5 Yr Running |
|
|
Payout Ratio CFPS WC |
24.78% |
23.62% |
26.96% |
27.26% |
27.61% |
33.59% |
28.99% |
32.46% |
31.46% |
34.94% |
38.46% |
38.09% |
42.31% |
39.04% |
43.20% |
#DIV/0! |
|
33.02% |
<-Median-> |
10 |
DPR CF WC |
|
|
DPR CF WC 5 Yr Running |
21.22% |
22.85% |
24.67% |
25.51% |
26.15% |
27.87% |
28.89% |
29.97% |
30.77% |
32.22% |
33.22% |
35.08% |
37.01% |
38.59% |
40.22% |
#DIV/0! |
|
30.37% |
<-Median-> |
10 |
DPR CF WC 5 Yr Running |
|
|
Median Values |
10 Yr Med |
10 Yr Cl |
4.45% |
4.35% |
5 Yr Med |
5 Yr Cl |
4.57% |
4.62% |
5 Yr Med |
Payout |
115.83% |
39.18% |
38.09% |
|
|
|
|
6.77% |
<-IRR #YR-> |
5 |
Dividends |
38.78% |
|
* Dividends per
share |
10 Yr Med |
and Cur. |
55.86% |
59.45% |
5 Yr Med |
and Cur. |
51.79% |
49.95% |
Last Div Inc ---> |
$0.3761 |
$0.3891 |
3.46% |
|
|
|
|
8.03% |
<-IRR #YR-> |
10 |
Dividends |
116.58% |
|
Dividends Growth 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8.01% |
<-IRR #YR-> |
15 |
Dividends |
217.64% |
|
Dividends Growth 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11.93% |
<-IRR #YR-> |
20 |
Dividends |
852.93% |
|
Dividends Growth 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6.14% |
<-IRR #YR-> |
25 |
Dividends |
343.22% |
|
Dividends Growth 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.98% |
<-IRR #YR-> |
30 |
Dividends |
|
|
Dividends Growth 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.38% |
<-IRR #YR-> |
33 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
|
|
|
|
|
-$1.03 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.43 |
|
|
|
|
|
|
|
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.43 |
|
|
|
|
|
|
|
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.43 |
|
|
|
|
|
|
|
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.43 |
|
|
|
|
|
|
|
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.43 |
|
|
|
|
|
|
|
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.43 |
|
|
|
|
|
|
|
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.43 |
|
|
|
|
|
|
|
Dividends Growth 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Historical Dividends |
Historical |
High Div |
6.84% |
Low Div |
1.67% |
10 Yr High |
6.60% |
10 Yr Low |
3.71% |
Med Div |
4.22% |
Close Div |
4.03% |
|
|
|
|
|
|
|
Historical Dividends |
|
|
High/Ave/Median Values |
Curr diff |
Cheap |
1.31% |
|
314.95% |
Cheap |
4.99% |
|
86.78% |
Cheap |
64.21% |
Cheap |
71.80% |
|
|
|
|
|
|
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
9.62% |
earning in |
5 |
Years |
at IRR of |
6.77% |
Div Inc. |
38.78% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
13.35% |
earning in |
10 |
Years |
at IRR of |
6.77% |
Div Inc. |
92.59% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
18.52% |
earning in |
15 |
Years |
at IRR of |
6.77% |
Div Inc. |
167.27% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$2.16 |
earning in |
5 |
Years |
at IRR of |
6.77% |
Div Inc. |
38.78% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$3.00 |
earning in |
10 |
Years |
at IRR of |
6.77% |
Div Inc. |
92.59% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$4.16 |
earning in |
15 |
Years |
at IRR of |
6.77% |
Div Inc. |
167.27% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$8.91 |
over |
5 |
Years |
at IRR of |
6.77% |
Div Cov. |
39.67% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$19.12 |
over |
10 |
Years |
at IRR of |
6.77% |
Div Cov. |
85.11% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$33.28 |
over |
15 |
Years |
at IRR of |
6.77% |
Div Cov. |
148.16% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yield if held 5 years |
3.98% |
4.05% |
6.48% |
9.11% |
8.18% |
6.98% |
6.39% |
6.11% |
5.53% |
5.44% |
6.25% |
5.85% |
6.12% |
6.30% |
6.54% |
5.66% |
|
6.18% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 10 years |
7.07% |
15.73% |
12.54% |
10.17% |
7.69% |
6.67% |
6.62% |
10.12% |
13.64% |
11.62% |
9.73% |
8.75% |
8.48% |
7.65% |
7.26% |
7.75% |
|
8.62% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 15 years |
7.67% |
6.46% |
5.83% |
8.33% |
8.18% |
11.83% |
25.70% |
19.57% |
15.22% |
10.93% |
9.30% |
9.06% |
14.04% |
18.84% |
15.52% |
12.07% |
|
12.94% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 20 years |
15.02% |
16.20% |
11.90% |
11.98% |
13.74% |
12.85% |
10.56% |
9.09% |
12.46% |
11.63% |
16.50% |
35.20% |
27.16% |
21.03% |
14.60% |
11.53% |
|
13.29% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 25 years |
|
|
|
|
25.85% |
25.15% |
26.48% |
18.58% |
17.94% |
19.51% |
17.92% |
14.47% |
12.62% |
17.22% |
15.53% |
20.46% |
|
18.26% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 30 years |
|
|
|
|
|
|
|
|
|
36.72% |
35.06% |
36.27% |
25.78% |
24.78% |
26.07% |
22.22% |
|
35.06% |
<-Median-> |
5 |
Paid Median Price |
|
|
Yield if held 35 years |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
49.06% |
43.49% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cost covered if held 5
years |
17.23% |
17.31% |
27.07% |
37.19% |
33.43% |
28.82% |
26.87% |
26.49% |
24.13% |
24.14% |
27.53% |
25.86% |
26.94% |
27.64% |
29.84% |
26.94% |
|
26.91% |
<-Median-> |
10 |
Paid Median Price |
|
|
Cost covered if held 10
years |
42.73% |
97.65% |
79.90% |
65.90% |
50.80% |
44.76% |
45.15% |
70.91% |
96.66% |
85.04% |
71.71% |
65.54% |
63.81% |
57.66% |
57.28% |
64.38% |
|
65.72% |
<-Median-> |
10 |
Paid Median Price |
|
|
Cost covered if held 15
years |
69.82% |
56.13% |
48.61% |
66.33% |
63.53% |
91.57% |
205.81% |
164.70% |
132.28% |
99.35% |
85.74% |
85.22% |
132.69% |
179.30% |
155.88% |
129.14% |
|
95.46% |
<-Median-> |
10 |
Paid Median Price |
|
|
Cost covered if held 20
years |
175.83% |
181.28% |
127.46% |
121.54% |
134.30% |
122.86% |
100.58% |
88.01% |
120.68% |
115.18% |
164.27% |
361.46% |
284.20% |
224.52% |
166.00% |
140.62% |
|
122.20% |
<-Median-> |
10 |
Paid Median Price |
|
|
Cost covered if held 25
years |
|
|
|
|
294.09% |
279.64% |
292.72% |
207.94% |
199.76% |
220.98% |
201.82% |
164.55% |
143.54% |
196.19% |
186.08% |
261.62% |
|
207.94% |
<-Median-> |
9 |
Paid Median Price |
|
|
Cost covered if held 30
years |
|
|
|
|
|
|
|
|
|
457.21% |
434.15% |
453.08% |
321.35% |
308.45% |
339.96% |
307.54% |
|
434.15% |
<-Median-> |
5 |
Paid Median Price |
|
|
Cost covered if held 35
years |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
681.10% |
641.06% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yr |
Item |
Tot. Growth |
Revenue Growth |
|
|
|
|
|
|
|
$14,368 |
$14,658 |
$15,463 |
$17,258 |
$18,412 |
$20,116 |
$20,001 |
<-12 mths |
-0.57% |
|
40.01% |
<-Total Growth |
5 |
Revenue Growth |
40.01% |
|
AEPS Growth |
|
|
|
|
|
|
|
$1.43 |
$1.43 |
$1.06 |
$1.07 |
$1.17 |
$0.95 |
$1.00 |
<-12 mths |
5.26% |
|
-33.33% |
<-Total Growth |
5 |
AEPS Growth |
-33.33% |
|
Net Income Growth |
|
|
|
|
|
|
|
$1,600 |
$1,746 |
$1,207 |
$1,655 |
$1,615 |
$841 |
$779 |
<-12 mths |
-7.37% |
|
-47.44% |
<-Total Growth |
5 |
Net Income Growth |
-47.44% |
|
Cash Flow Growth |
|
|
|
|
|
|
|
$4,058 |
$3,927 |
$4,574 |
$4,388 |
$4,811 |
$4,499 |
$4,959 |
<-12 mths |
10.22% |
|
10.87% |
<-Total Growth |
5 |
Cash Flow Growth |
10.87% |
|
Dividend Growth |
|
|
|
|
|
|
|
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$1.43 |
$1.53 |
<-12 mths |
7.07% |
|
38.78% |
<-Total Growth |
5 |
Dividend Growth |
38.78% |
|
Stock Price Growth |
|
|
|
|
|
|
|
$22.63 |
$25.14 |
$25.21 |
$29.79 |
$26.13 |
$23.58 |
$22.46 |
<-12 mths |
-4.75% |
|
4.22% |
<-Total Growth |
5 |
Stock Price Growth |
4.22% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenue Growth |
|
|
$11,404 |
$12,002 |
$12,502 |
$12,799 |
$13,304 |
$14,368 |
$14,658 |
$15,463 |
$17,258 |
$18,412 |
$20,116 |
$0 |
<-this year |
-100.00% |
|
76.39% |
<-Total Growth |
10 |
Revenue Growth |
76.39% |
|
AEPS Growth |
|
|
$1.08 |
$1.21 |
$1.29 |
$1.29 |
$1.32 |
$1.43 |
$1.43 |
$1.06 |
$1.07 |
$1.17 |
$0.95 |
$0.99 |
<-this year |
4.21% |
|
-12.04% |
<-Total Growth |
10 |
AEPS Growth |
-12.04% |
|
Net Income Growth |
|
|
$1,294 |
$1,425 |
$1,382 |
$1,223 |
$1,460 |
$1,600 |
$1,746 |
$1,207 |
$1,655 |
$1,615 |
$841 |
$1,038 |
<-this year |
23.42% |
|
-35.01% |
<-Total Growth |
10 |
Net Income Growth |
-35.01% |
|
Cash Flow Growth |
|
|
$3,246 |
$3,407 |
$3,542 |
$3,219 |
$3,947 |
$4,058 |
$3,927 |
$4,574 |
$4,388 |
$4,811 |
$4,499 |
$5,809 |
<-this year |
29.13% |
|
38.60% |
<-Total Growth |
10 |
Cash Flow Growth |
38.60% |
|
Dividend Growth |
|
|
$0.66 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$1.43 |
$1.55 |
<-this year |
8.58% |
|
116.58% |
<-Total Growth |
10 |
Dividend Growth |
116.58% |
|
Stock Price Growth |
|
|
$18.28 |
$20.95 |
$19.13 |
$21.38 |
$23.81 |
$22.63 |
$25.14 |
$25.21 |
$29.79 |
$26.13 |
$23.58 |
$24.79 |
<-this year |
5.13% |
|
28.99% |
<-Total Growth |
10 |
Stock Price Growth |
28.99% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends on Shares |
|
|
|
$40.70 |
$45.10 |
$49.50 |
$53.49 |
$56.65 |
$60.91 |
$64.08 |
$69.01 |
$73.26 |
$78.62 |
$84.17 |
$85.60 |
$85.60 |
|
$591.32 |
No of Years |
10 |
Total Divs |
12/31/13 |
|
Paid |
|
|
$1,005.40 |
$1,151.98 |
$1,052.15 |
$1,175.63 |
$1,309.55 |
$1,244.38 |
$1,382.70 |
$1,386.55 |
$1,638.45 |
$1,437.15 |
$1,296.90 |
$1,235.30 |
$1,235.30 |
$1,235.30 |
|
$1,296.90 |
No of Years |
10 |
Worth |
$18.28 |
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1,888.22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. AESP |
$10.91 |
$11.50 |
$12.50 |
$12.88 |
$13.69 |
$13.95 |
$14.28 |
$16.57 |
$16.75 |
$14.94 |
$16.30 |
$17.46 |
$15.32 |
$15.41 |
$16.10 |
$17.32 |
|
22.55% |
<-Total Growth |
10 |
Graham Price AEPS |
|
|
Price/GP Ratio Med |
1.18 |
1.32 |
1.35 |
1.55 |
1.57 |
1.44 |
1.59 |
1.41 |
1.45 |
1.59 |
1.69 |
1.73 |
1.64 |
1.41 |
0.00 |
0.00 |
|
1.58 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio High |
1.32 |
1.43 |
1.50 |
1.70 |
1.64 |
1.58 |
1.71 |
1.48 |
1.53 |
1.85 |
1.84 |
1.97 |
1.89 |
1.49 |
0.00 |
0.00 |
|
1.70 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Low |
1.04 |
1.21 |
1.19 |
1.41 |
1.49 |
1.30 |
1.48 |
1.34 |
1.37 |
1.33 |
1.54 |
1.50 |
1.40 |
1.32 |
0.00 |
0.00 |
|
1.40 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Close |
1.32 |
1.41 |
1.46 |
1.63 |
1.40 |
1.53 |
1.67 |
1.37 |
1.50 |
1.69 |
1.83 |
1.50 |
1.54 |
1.46 |
1.40 |
1.30 |
|
1.54 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Prem/Disc Close |
31.73% |
41.29% |
47.96% |
63.95% |
42.21% |
59.51% |
68.94% |
37.68% |
49.76% |
73.06% |
77.52% |
50.10% |
69.05% |
54.28% |
41.25% |
30.21% |
|
61.73% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. EPS |
$11.03 |
$11.56 |
$12.06 |
$12.61 |
$12.90 |
$12.47 |
$13.82 |
$16.07 |
$16.86 |
$14.06 |
$17.40 |
$17.31 |
$11.97 |
$12.98 |
$15.42 |
$17.01 |
|
-0.73% |
<-Total Growth |
10 |
Graham Price EPS |
|
|
Price/GP Ratio Med |
1.17 |
1.32 |
1.40 |
1.59 |
1.66 |
1.61 |
1.65 |
1.45 |
1.44 |
1.69 |
1.58 |
1.75 |
2.10 |
1.67 |
|
|
|
1.63 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio High |
1.31 |
1.43 |
1.56 |
1.74 |
1.74 |
1.76 |
1.77 |
1.53 |
1.52 |
1.97 |
1.72 |
1.99 |
2.42 |
1.78 |
|
|
|
1.75 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Low |
1.03 |
1.21 |
1.24 |
1.44 |
1.58 |
1.46 |
1.53 |
1.38 |
1.36 |
1.42 |
1.44 |
1.51 |
1.79 |
1.57 |
|
|
|
1.45 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Close |
1.31 |
1.41 |
1.52 |
1.66 |
1.48 |
1.71 |
1.72 |
1.41 |
1.49 |
1.79 |
1.71 |
1.51 |
1.97 |
1.73 |
1.46 |
1.32 |
|
1.69 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Prem/Disc Close |
30.66% |
40.79% |
51.62% |
66.09% |
48.35% |
71.42% |
72.34% |
40.81% |
49.07% |
79.25% |
71.18% |
50.96% |
97.03% |
73.04% |
45.68% |
32.01% |
|
68.63% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2013 |
$57.64 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
$28.82 |
$32.55 |
$36.56 |
$41.89 |
$38.26 |
$42.75 |
$47.62 |
$45.25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price Close |
$14.41 |
$16.28 |
$18.28 |
$20.95 |
$19.13 |
$21.38 |
$23.81 |
$22.63 |
$25.14 |
$25.21 |
$29.79 |
$26.13 |
$23.58 |
$22.46 |
$22.46 |
$22.46 |
|
28.99% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
26.74% |
12.94% |
12.32% |
14.58% |
-8.67% |
11.74% |
11.39% |
-4.98% |
11.12% |
0.28% |
18.17% |
-12.29% |
-9.76% |
-4.75% |
0.00% |
0.00% |
|
17.17 |
<-Median-> |
10 |
CAPE (10 Yr P/E) |
|
|
P/E |
15.41 |
16.15 |
18.19 |
18.13 |
16.71 |
20.75 |
19.36 |
16.88 |
17.34 |
26.82 |
24.42 |
22.72 |
40.66 |
32.00 |
22.68 |
18.62 |
|
0.83% |
<-IRR #YR-> |
5 |
Stock Price |
4.22% |
|
Trailing P/E |
17.90 |
17.41 |
18.14 |
20.84 |
16.56 |
18.67 |
23.12 |
18.39 |
18.76 |
17.39 |
31.69 |
21.42 |
20.50 |
38.72 |
32.00 |
22.68 |
|
2.58% |
<-IRR #YR-> |
10 |
Stock Price |
28.99% |
|
CAPE (10 Yr P/E) |
16.68 |
15.58 |
15.54 |
15.54 |
15.21 |
15.69 |
16.38 |
16.93 |
17.42 |
18.44 |
19.32 |
19.93 |
21.15 |
22.18 |
22.82 |
22.54 |
|
6.26% |
<-IRR #YR-> |
5 |
Price & Dividend |
32.02% |
|
Median 10, 5 Yrs |
|
D. per yr |
5.09% |
5.43% |
% Tot Ret |
66.38% |
86.74% |
T P/E |
19.63 |
20.50 |
P/E: |
20.06 |
24.42 |
|
|
|
|
7.67% |
<-IRR #YR-> |
10 |
Price & Dividend |
87.81% |
|
Price 15 |
|
D. per yr |
5.81% |
|
% Tot Ret |
47.56% |
|
|
|
|
|
CAPE Diff |
86.31% |
|
|
|
|
6.40% |
<-IRR #YR-> |
15 |
Stock Price |
153.75% |
|
Price 20 |
|
D. per yr |
5.18% |
|
% Tot Ret |
43.74% |
|
|
|
|
|
|
|
|
|
|
|
6.67% |
<-IRR #YR-> |
20 |
Stock Price |
263.47% |
|
Price 25 |
|
D. per yr |
3.46% |
|
% Tot Ret |
51.09% |
|
|
|
|
|
|
|
|
|
|
|
3.31% |
<-IRR #YR-> |
25 |
Stock Price |
125.65% |
|
Price 30 |
|
D. per yr |
4.08% |
|
% Tot Ret |
47.71% |
|
|
|
|
|
|
|
|
|
|
|
4.48% |
<-IRR #YR-> |
30 |
Stock Price |
|
|
Price 35 |
|
D. per yr |
4.44% |
|
% Tot Ret |
47.34% |
|
|
|
|
|
|
|
|
|
|
|
4.94% |
<-IRR #YR-> |
33 |
Stock Price |
|
|
Price & Dividend 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12.21% |
<-IRR #YR-> |
15 |
Price & Dividend |
299.10% |
|
Price & Dividend 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11.85% |
<-IRR #YR-> |
20 |
Price & Dividend |
494.01% |
|
Price & Dividend 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6.77% |
<-IRR #YR-> |
25 |
Price & Dividend |
281.21% |
|
Price & Dividend 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8.56% |
<-IRR #YR-> |
30 |
Price & Dividend |
|
|
Price & Dividend 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9.37% |
<-IRR #YR-> |
33 |
Price & Dividend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price 5 |
|
|
|
|
|
|
|
-$22.63 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$23.58 |
|
|
|
|
|
|
|
Price 5 |
|
|
Price 10 |
|
|
-$18.28 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$23.58 |
|
|
|
|
|
|
|
Price 10 |
|
|
Price & Dividend 5 |
|
|
|
|
|
|
|
-$22.63 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$25.01 |
|
|
|
|
|
|
|
Price & Dividend 5 |
|
|
Price & Dividend 10 |
|
|
-$18.28 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$25.01 |
|
|
|
|
|
|
|
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 |
$23.58 |
|
|
|
|
|
|
|
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 |
$23.58 |
|
|
|
|
|
|
|
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 |
$23.58 |
|
|
|
|
|
|
|
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 |
$23.58 |
|
|
|
|
|
|
|
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 |
$23.58 |
|
|
|
|
|
|
|
Price 35 |
|
|
Price & Dividend 15 |
$0.54 |
$0.60 |
$0.66 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$25.01 |
|
|
|
|
|
|
|
Price & Dividend 15 |
|
|
Price & Dividend 20 |
$0.54 |
$0.60 |
$0.66 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$25.01 |
|
|
|
|
|
|
|
Price & Dividend 20 |
|
|
Price & Dividend 25 |
$0.54 |
$0.60 |
$0.66 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$25.01 |
|
|
|
|
|
|
|
Price & Dividend 25 |
|
|
Price & Dividend 30 |
$0.54 |
$0.60 |
$0.66 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$25.01 |
|
|
|
|
|
|
|
Price & Dividend 30 |
|
|
Price & Dividend 35 |
$0.54 |
$0.60 |
$0.66 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$25.01 |
|
|
|
|
|
|
|
Price & Dividend 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price H/L Median |
$12.89 |
$15.23 |
$16.85 |
$20.02 |
$21.44 |
$20.09 |
$22.77 |
$23.34 |
$24.29 |
$23.81 |
$27.49 |
$30.28 |
$25.16 |
$21.73 |
|
|
|
49.31% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
28.57% |
18.13% |
10.62% |
18.80% |
7.09% |
-6.27% |
13.35% |
2.50% |
4.04% |
-1.98% |
15.46% |
10.15% |
-16.91% |
-13.64% |
|
|
|
4.09% |
<-IRR #YR-> |
10 |
Stock Price |
49.31% |
|
P/E |
13.79 |
15.12 |
16.76 |
17.33 |
18.72 |
19.50 |
18.51 |
17.42 |
16.75 |
25.32 |
22.53 |
26.33 |
43.37 |
30.95 |
|
|
|
1.51% |
<-IRR #YR-> |
5 |
Stock Price |
7.76% |
|
Trailing P/E |
16.02 |
16.29 |
16.72 |
19.92 |
18.56 |
17.55 |
22.11 |
18.98 |
18.12 |
16.42 |
29.24 |
24.82 |
21.87 |
37.46 |
|
|
|
9.27% |
<-IRR #YR-> |
10 |
Price & Dividend |
|
|
P/E on Run. 5 yr Ave |
14.84 |
17.27 |
18.56 |
20.39 |
20.42 |
18.80 |
20.46 |
19.78 |
19.60 |
19.87 |
22.24 |
24.82 |
23.55 |
23.66 |
|
|
|
6.70% |
<-IRR #YR-> |
5 |
Price & Dividend |
|
|
P/E on Run. 10 yr Ave |
21.25 |
20.97 |
20.95 |
22.74 |
22.65 |
20.74 |
22.83 |
22.36 |
21.87 |
21.18 |
23.85 |
25.95 |
22.38 |
20.14 |
|
|
|
17.33 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
D. per yr |
5.18% |
5.19% |
% Tot Ret |
55.88% |
77.52% |
T P/E |
19.45 |
21.87 |
P/E: |
19.11 |
25.32 |
|
|
|
|
|
Count |
33 |
Years of data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$16.85 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$25.16 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$23.34 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$25.16 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$16.85 |
$0.74 |
$0.82 |
$0.90 |
$0.97 |
$1.03 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$26.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$23.34 |
$1.11 |
$1.17 |
$1.25 |
$1.33 |
$26.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
High Months |
Dec |
Dec |
May |
Nov |
Jul |
Jul |
Nov |
Sep |
Dec |
Feb |
Sep |
Apr |
Feb |
Aug |
|
|
|
|
|
|
|
|
|
Pre-split 2013 |
$57.64 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
$28.82 |
$32.97 |
$37.57 |
$43.78 |
$44.97 |
$44.01 |
$48.79 |
$49.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price High |
$14.41 |
$16.49 |
$18.79 |
$21.89 |
$22.49 |
$22.01 |
$24.40 |
$24.55 |
$25.68 |
$27.68 |
$29.94 |
$34.42 |
$28.94 |
$23.04 |
|
|
|
54.06% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
20.86% |
14.40% |
13.95% |
16.53% |
2.72% |
-2.13% |
10.86% |
0.64% |
4.60% |
7.79% |
8.16% |
14.96% |
-15.92% |
-20.39% |
|
|
|
4.42% |
<-IRR #YR-> |
10 |
Stock Price |
54.06% |
|
P/E |
15.41 |
16.36 |
18.69 |
18.95 |
19.64 |
21.36 |
19.83 |
18.32 |
17.71 |
29.45 |
24.54 |
29.93 |
49.90 |
32.83 |
|
|
|
3.34% |
<-IRR #YR-> |
5 |
Stock Price |
17.88% |
|
Trailing P/E |
17.90 |
17.63 |
18.65 |
21.78 |
19.47 |
19.22 |
23.68 |
19.96 |
19.16 |
19.09 |
31.85 |
28.21 |
25.17 |
39.72 |
|
|
|
19.29 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
20.87 |
25.17 |
P/E: |
20.60 |
29.45 |
|
|
|
|
29.45 |
P/E Ratio |
|
Historical High |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$18.79 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$28.94 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$24.55 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$28.94 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Low Months |
Jan |
Feb |
Jun |
Jan |
Jun |
Jan |
Mar |
Oct |
Oct |
Mar |
Mar |
Dec |
Oct |
Jul |
|
|
|
|
|
|
|
|
|
Pre-split 2013 |
$45.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
$22.75 |
$27.95 |
$29.82 |
$36.28 |
$40.77 |
$36.35 |
$42.30 |
$44.27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price Low |
$11.38 |
$13.98 |
$14.91 |
$18.14 |
$20.39 |
$18.18 |
$21.15 |
$22.14 |
$22.89 |
$19.93 |
$25.03 |
$26.13 |
$21.37 |
$20.41 |
|
|
|
43.33% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
39.87% |
22.86% |
6.69% |
21.66% |
12.38% |
-10.84% |
16.37% |
4.66% |
3.41% |
-12.93% |
25.59% |
4.39% |
-18.22% |
-4.49% |
|
|
|
3.67% |
<-IRR #YR-> |
10 |
Stock Price |
43.33% |
|
P/E |
12.17 |
13.87 |
14.84 |
15.71 |
17.80 |
17.65 |
17.20 |
16.52 |
15.79 |
21.20 |
20.52 |
22.72 |
36.84 |
29.08 |
|
|
|
-0.70% |
<-IRR #YR-> |
5 |
Stock Price |
-3.46% |
|
Trailing P/E |
14.13 |
14.95 |
14.80 |
18.05 |
17.65 |
15.87 |
20.53 |
18.00 |
17.08 |
13.74 |
26.63 |
21.42 |
18.58 |
35.19 |
|
|
|
15.27 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
18.02 |
18.58 |
P/E: |
17.72 |
21.20 |
|
|
|
|
11.75 |
P/E Ratio |
|
Historical Low |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$14.91 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$21.37 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$22.14 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$21.37 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2,348 |
<-12 mths |
82.30% |
|
|
|
|
|
|
|
|
|
|
|
-$700 |
-$1,240 |
$390 |
$1,010 |
$930 |
$370 |
$1,480 |
-$850 |
$1,360 |
$1,610 |
|
|
|
|
|
|
|
|
|
|
Free Cash Flow MS, WSJ |
$683 |
$1,269 |
$1,144 |
-$137 |
-$1,014 |
$322 |
$856 |
$1,183 |
$33 |
$1,752 |
-$928 |
$1,164 |
$1,288 |
$2,532 |
$2,923 |
|
|
12.59% |
<-Total Growth |
10 |
Free Cash Flow |
WSJ agree |
|
Change |
-28.03% |
85.80% |
-9.85% |
-111.98% |
-640.15% |
131.76% |
165.84% |
38.20% |
-97.21% |
5209.09% |
-152.97% |
225.43% |
10.65% |
96.58% |
15.44% |
|
|
1.72% |
<-IRR #YR-> |
5 |
Free Cash Flow MS |
8.88% |
|
FCF/CF from Op Ratio |
0.27 |
0.39 |
0.35 |
-0.04 |
-0.29 |
0.10 |
0.22 |
0.29 |
0.01 |
0.38 |
-0.21 |
0.24 |
0.29 |
0.44 |
0.55 |
|
|
1.19% |
<-IRR #YR-> |
10 |
Free Cash Flow MS |
12.59% |
|
Dividends paid in Cash |
$698 |
$776 |
$823 |
$901 |
$992 |
$1,070 |
$1,082 |
$1,141 |
$1,149 |
$930 |
$1,719 |
$1,188 |
$1,315 |
$2,268 |
$2,307 |
|
|
59.79% |
<-Total Growth |
10 |
Dividends paid |
|
|
Percentage paid |
|
|
|
|
-97.83% |
332.30% |
126.40% |
96.45% |
3481.82% |
53.08% |
-185.25% |
102.06% |
102.10% |
89.58% |
78.91% |
|
|
102.06% |
<-Median-> |
9 |
Percentage paid |
|
|
5 Year Coverage |
|
|
|
|
|
|
|
|
393.77% |
129.57% |
207.91% |
191.23% |
190.42% |
127.76% |
126.05% |
|
|
191.23% |
<-Median-> |
5 |
5 Year Coverage |
|
|
Dividend
Coverage Ratio |
|
|
|
|
-1.02 |
0.30 |
0.79 |
1.04 |
0.03 |
1.88 |
-0.54 |
0.98 |
0.98 |
1.12 |
1.27 |
|
|
0.79 |
<-Median-> |
9 |
Dividend Coverage Ratio |
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
0.25 |
0.77 |
0.48 |
0.52 |
0.53 |
0.78 |
0.79 |
|
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,183 |
$0 |
$0 |
$0 |
$0 |
$1,288 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,144 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$1,288 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Free Cash Flow Markt Sc |
|
|
|
|
|
|
$866 |
$1,197 |
$932 |
$1,435 |
$777 |
$1,274 |
$1,759 |
$2,072 |
$2,449 |
$2,929 |
|
103.12% |
<-Total Growth |
6 |
Free Cash Flow Markt Sc |
|
|
Change |
|
|
|
|
|
|
|
38.22% |
-22.14% |
53.97% |
-45.85% |
63.96% |
38.07% |
17.79% |
18.19% |
19.60% |
|
8.00% |
<-IRR #YR-> |
5 |
Free Cash Flow MS |
|
|
FCF/CF from Op Ratio |
|
|
|
|
|
|
0.22 |
0.29 |
0.24 |
0.31 |
0.18 |
0.26 |
0.39 |
0.36 |
0.46 |
#DIV/0! |
|
12.54% |
<-IRR #YR-> |
6 |
Free Cash Flow MS |
|
|
Dividends paid in Cash |
|
|
|
|
|
|
$1,082 |
$1,141 |
$1,149 |
$930 |
$1,719 |
$1,188 |
$1,315 |
$2,268 |
$2,307 |
$0 |
|
21.53% |
<-Total Growth |
6 |
Dividends paid |
|
|
Dividends Percentage
paid |
|
|
|
|
|
|
124.94% |
95.32% |
123.28% |
64.81% |
221.25% |
93.25% |
74.76% |
109.46% |
94.18% |
0.00% |
|
95.32% |
<-Median-> |
7 |
Percentage paid |
|
|
5 Year Coverage |
|
|
|
|
|
|
|
|
|
|
115.63% |
109.12% |
102.01% |
101.41% |
105.59% |
67.52% |
|
109.12% |
<-Median-> |
3 |
5 Year Coverage |
|
|
Dividend
Coverage Ratio |
|
|
|
|
|
|
0.80 |
1.05 |
0.81 |
1.54 |
0.45 |
1.07 |
1.34 |
0.91 |
1.06 |
0.00 |
|
1.05 |
<-Median-> |
7 |
Dividend Coverage Ratio |
|
|
5 Year of Coverage |
|
|
|
|
|
|
0.80 |
0.93 |
0.89 |
1.03 |
0.86 |
0.92 |
0.98 |
0.99 |
0.95 |
1.48 |
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,197 |
$0 |
$0 |
$0 |
$0 |
$1,759 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$866 |
$0 |
$0 |
$0 |
$0 |
$0 |
$1,759 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Market Cap |
$18,724 |
$21,220 |
$22,793 |
$25,512 |
$22,738 |
$25,223 |
$28,382 |
$27,105 |
$30,419 |
$32,546 |
$40,812 |
$37,392 |
$34,615 |
$33,286 |
$33,286 |
$33,286 |
|
51.87% |
<-Total Growth |
10 |
Market Cap |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2013 |
326 |
327 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
652.0 |
654.0 |
643 |
618 |
604 |
593 |
593 |
597 |
602 |
602 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Diluted # of Shares in
Million |
1304.0 |
1308.0 |
1286 |
1236 |
1208 |
1186 |
1186 |
1194 |
1204 |
1278 |
1351 |
1403 |
1457 |
1483 |
1483 |
1483 |
|
13.30% |
<-Total Growth |
10 |
Diluted |
|
|
Change |
1.56% |
0.31% |
-1.68% |
-3.89% |
-2.27% |
-1.82% |
0.00% |
0.67% |
0.84% |
6.15% |
5.71% |
3.85% |
3.85% |
1.78% |
0.00% |
0.00% |
|
0.76% |
<-Median-> |
10 |
Change |
|
|
Difference
Diluted/Basic |
-0.6% |
-0.3% |
-0.5% |
-0.3% |
-0.2% |
-0.2% |
0.0% |
0.0% |
0.0% |
-0.2% |
-0.4% |
-0.5% |
-0.4% |
-0.3% |
-100.0% |
-100.0% |
|
-0.20% |
<-Median-> |
10 |
Difference Diluted/Basic |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2013 |
324 |
326 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
648.00 |
652.00 |
640 |
616 |
603 |
592 |
593 |
597 |
602 |
602 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Basic # of Shares in
Millions |
1,296.00 |
1,304.00 |
1280 |
1232 |
1206 |
1184 |
1186 |
1194 |
1204 |
1275 |
1346 |
1396 |
1451 |
1479 |
|
|
|
13.36% |
<-Total Growth |
10 |
Basic |
|
|
Change |
1.25% |
0.62% |
-1.84% |
-3.75% |
-2.11% |
-1.82% |
0.17% |
0.67% |
0.84% |
5.90% |
5.57% |
3.71% |
3.94% |
1.93% |
|
|
|
0.76% |
<-Median-> |
10 |
Change |
|
|
Difference
Basic/Outstanding |
0.3% |
0.0% |
-2.6% |
-1.1% |
-1.4% |
-0.3% |
0.5% |
0.3% |
0.5% |
1.3% |
1.8% |
2.5% |
1.2% |
0.2% |
|
|
|
0.50% |
<-Median-> |
10 |
Difference Basic/Outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$4,959 |
<-12 mths |
10.22% |
|
|
|
|
|
|
|
BC Tel 1-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Telus 1-.7773 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Common Shares |
174.92 |
174.91 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Non-Voting Shares |
149.93 |
151.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-slip 2013 |
324.85 |
325.96 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Common Shares |
349.83 |
349.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Non-Voting Shares |
299.87 |
302.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2020 |
649.70 |
651.93 |
623.43 |
609.02 |
594.30 |
590 |
596 |
599 |
605 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# of Share in Millions |
1,299.39 |
1,303.85 |
1,246.86 |
1,218.05 |
1,188.60 |
1,180 |
1,192 |
1,198 |
1,210 |
1,291 |
1,370 |
1,431 |
1,468 |
1,482 |
1,482 |
1,482 |
|
1.65% |
<-IRR #YR-> |
10 |
Shares |
17.74% |
|
Change |
0.77% |
0.34% |
-4.37% |
-2.31% |
-2.42% |
-0.72% |
1.02% |
0.50% |
1.00% |
6.69% |
6.12% |
4.45% |
2.59% |
0.95% |
0.00% |
0.00% |
|
4.15% |
<-IRR #YR-> |
5 |
Shares |
22.54% |
|
Cash Flow from
Operations $M |
$2,550.0 |
$3,219 |
$3,246 |
$3,407 |
$3,542 |
$3,219 |
$3,947 |
$4,058 |
$3,927 |
$4,574 |
$4,388 |
$4,811 |
$4,499 |
$5,809 |
$5,340 |
|
|
38.60% |
<-Total Growth |
10 |
Cash Flow |
|
|
Increase |
0.16% |
26.24% |
0.84% |
4.96% |
3.96% |
-9.12% |
22.62% |
2.81% |
-3.23% |
16.48% |
-4.07% |
9.64% |
-6.49% |
29.13% |
-8.09% |
|
|
|
SO, Buy Backs |
|
|
|
|
5 year Running Average |
$2,798 |
$2,808 |
$2,893 |
$2,994 |
$3,193 |
$3,327 |
$3,472 |
$3,635 |
$3,739 |
$3,945 |
$4,179 |
$4,352 |
$4,440 |
$4,816 |
$4,969 |
|
|
53.47% |
<-Total Growth |
10 |
CF 5 Yr Running |
|
|
CFPS |
$1.96 |
$2.47 |
$2.60 |
$2.80 |
$2.98 |
$2.73 |
$3.31 |
$3.39 |
$3.25 |
$3.54 |
$3.20 |
$3.36 |
$3.06 |
$3.92 |
$3.60 |
|
|
17.72% |
<-Total Growth |
10 |
Cash Flow per Share |
|
|
Increase |
-0.61% |
25.80% |
5.45% |
7.44% |
6.54% |
-8.46% |
21.38% |
2.30% |
-4.19% |
9.17% |
-9.60% |
4.97% |
-8.84% |
27.91% |
-8.09% |
|
|
3.32% |
<-IRR #YR-> |
10 |
Cash Flow |
38.60% |
|
5 year Running Average |
$2.16 |
$2.18 |
$2.26 |
$2.36 |
$2.56 |
$2.72 |
$2.88 |
$3.04 |
$3.13 |
$3.24 |
$3.34 |
$3.35 |
$3.28 |
$3.42 |
$3.43 |
|
|
2.08% |
<-IRR #YR-> |
5 |
Cash Flow |
10.87% |
|
P/CF on Med Price |
6.57 |
6.17 |
6.47 |
7.16 |
7.19 |
7.36 |
6.88 |
6.89 |
7.48 |
6.72 |
8.58 |
9.01 |
8.21 |
5.54 |
0.00 |
|
|
1.65% |
<-IRR #YR-> |
10 |
Cash Flow per Share |
17.72% |
|
P/CF on Closing Price |
7.34 |
6.59 |
7.02 |
7.49 |
6.42 |
7.84 |
7.19 |
6.68 |
7.75 |
7.12 |
9.30 |
7.77 |
7.69 |
5.73 |
6.23 |
|
|
-1.98% |
<-IRR #YR-> |
5 |
Cash Flow per Share |
-9.52% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-21.28% |
Diff M/C |
|
3.81% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
45.37% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$4,777 |
<-12 mths |
-3.69% |
|
|
|
|
|
|
|
Excl.Working Capital CF |
$268.00 |
$66.00 |
-$194.00 |
-$101.00 |
-$12.00 |
-$57 |
$52 |
-$256 |
$332 |
-$270 |
$82 |
$193 |
$461 |
$0 |
$0 |
|
|
1.55% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
7.99% |
|
CF fr Op $M WC |
$2,818.0 |
$3,285 |
$3,052 |
$3,306 |
$3,530 |
$3,162 |
$3,999 |
$3,802 |
$4,259 |
$4,304 |
$4,470 |
$5,004 |
$4,960 |
$5,809 |
$5,340 |
|
|
62.52% |
<-Total Growth |
10 |
Cash Flow less WC |
|
|
Increase |
9.82% |
16.57% |
-7.09% |
8.32% |
6.78% |
-10.42% |
26.47% |
-4.93% |
12.02% |
1.06% |
3.86% |
11.95% |
-0.88% |
17.13% |
-8.09% |
|
|
4.98% |
<-IRR #YR-> |
10 |
Cash Flow less WC |
62.52% |
|
5 year Running Average |
$2,835 |
$2,867 |
$2,863 |
$3,005 |
$3,198 |
$3,267 |
$3,410 |
$3,560 |
$3,750 |
$3,905 |
$4,167 |
$4,368 |
$4,599 |
$4,909 |
$5,117 |
|
|
5.46% |
<-IRR #YR-> |
5 |
Cash Flow less WC |
30.46% |
|
CFPS Excl. WC |
$2.17 |
$2.52 |
$2.45 |
$2.71 |
$2.97 |
$2.68 |
$3.35 |
$3.17 |
$3.52 |
$3.33 |
$3.26 |
$3.50 |
$3.38 |
$3.92 |
$3.60 |
|
|
4.86% |
<-IRR #YR-> |
10 |
CF less WC 5 Yr Run |
60.66% |
|
Increase |
8.98% |
16.17% |
-2.85% |
10.89% |
9.42% |
-9.77% |
25.20% |
-5.40% |
10.91% |
-5.28% |
-2.13% |
7.17% |
-3.38% |
16.02% |
-8.09% |
|
|
5.26% |
<-IRR #YR-> |
5 |
CF less WC 5 Yr Run |
29.20% |
|
5 year Running Average |
$2.19 |
$2.23 |
$2.23 |
$2.37 |
$2.56 |
$2.67 |
$2.83 |
$2.98 |
$3.14 |
$3.21 |
$3.33 |
$3.36 |
$3.40 |
$3.48 |
$3.53 |
|
|
3.28% |
<-IRR #YR-> |
10 |
CFPS - Less WC |
38.04% |
|
P/CF on Med Price |
6.57 |
6.17 |
6.47 |
7.37 |
7.22 |
7.50 |
6.79 |
7.36 |
6.90 |
7.14 |
8.42 |
8.66 |
7.45 |
5.54 |
0.00 |
|
|
1.26% |
<-IRR #YR-> |
5 |
CFPS - Less WC |
6.46% |
|
P/CF on Closing Price |
7.34 |
6.59 |
7.02 |
7.72 |
6.44 |
7.98 |
7.10 |
7.13 |
7.14 |
7.56 |
9.13 |
7.47 |
6.98 |
5.73 |
6.23 |
|
|
4.29% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
52.17% |
|
*Operational Cash Flow
per share |
|
|
CF/-WC |
P/CF Med |
10 yr |
7.28 |
5 yr |
8.21 |
P/CF Med |
10 yr |
7.36 |
5 yr |
7.45 |
|
-22.20% |
Diff M/C |
|
2.67% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
14.10% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-1,246.9 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
1,468.0 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
|
|
|
|
|
-1,198.0 |
0.0 |
0.0 |
0.0 |
0.0 |
1,468.0 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
-$3,246.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$4,499.0 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
|
|
|
|
|
-$4,058.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$4,499.0 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
-$2.60 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.06 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
|
|
|
|
|
-$3.39 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.06 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
-$2.26 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.28 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$3.04 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.28 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
-$3,052.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$4,960.0 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
|
|
|
|
|
-$3,802.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$4,960.0 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
-$2,862.8 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$4,599.4 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
|
|
|
|
|
-$3,559.8 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$4,599.4 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
-$2.45 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.38 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
|
|
|
|
|
-$3.17 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.38 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
-$2.23 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.40 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$2.98 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.40 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net change in non-cash operating working capital |
-$255.0 |
$52.0 |
$187.0 |
-$64.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable |
|
|
|
|
$55 |
-$45 |
-$70 |
$74 |
-$329 |
-$231 |
-$290 |
-$312 |
-$184 |
|
|
|
|
|
|
|
|
|
|
Inventories |
|
|
|
|
-$40 |
$42 |
-$60 |
$4 |
-$61 |
$30 |
-$41 |
-$89 |
$53 |
|
|
|
|
|
|
|
|
|
|
Contract Assets |
|
|
|
|
|
|
|
-$103 |
$123 |
$298 |
-$4 |
$9 |
-$4 |
|
|
|
|
|
|
|
|
|
|
Prepaid Expenses |
|
|
|
|
-$22 |
-$20 |
-$27 |
-$46 |
$0 |
$79 |
-$44 |
-$56 |
-$60 |
|
|
|
|
|
|
|
|
|
|
Accounts Payable and Accrued Liab. |
|
|
|
|
-$60 |
$126 |
$126 |
-$11 |
$73 |
$189 |
$289 |
$173 |
-$268 |
|
|
|
|
|
|
|
|
|
|
Income & other taxes rec & pay Net |
|
|
|
|
|
|
|
$277 |
-$287 |
-$49 |
-$77 |
$50 |
-$72 |
|
|
|
|
|
|
|
|
|
|
Advance Billings, customer Deposits |
|
|
|
|
$7 |
-$28 |
$38 |
$12 |
-$10 |
$54 |
$62 |
-$12 |
$74 |
|
|
|
|
|
|
|
|
|
|
Provisions |
|
|
|
|
$72 |
-$18 |
-$59 |
$49 |
$159 |
-$100 |
$23 |
$44 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Non-current contract Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Income and other taxes receivable |
-$13.0 |
-$118.0 |
$7.0 |
$165.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
and payable, net |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net. |
-$268.0 |
-$66.0 |
$194.0 |
$101.0 |
$12.0 |
$57.0 |
-$52.0 |
$256 |
-$332 |
$270 |
-$82 |
-$193 |
-$461 |
|
|
|
|
|
|
|
|
|
|
Google --> TD 2017 |
|
-$66.0 |
$194.0 |
$101.0 |
$12.0 |
$57.0 |
-$52 |
$194 |
-$332 |
$270 |
-$82 |
-$237 |
-$461 |
|
|
|
|
|
|
|
|
|
|
Difference |
|
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0 |
$62 |
$0 |
$0 |
$0 |
$44 |
$0 |
|
|
|
|
|
|
|
|
|
|
TD |
|
|
$194 |
$101 |
$12 |
$57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Changes found in Sep 2019 |
|
|
|
-$64 |
$214 |
-$71 |
-$263 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Changes found in Sep 2020 |
|
|
|
|
|
-$71 |
-$219 |
$256 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPM |
24.53% |
29.48% |
28.46% |
28.39% |
28.33% |
25.15% |
29.67% |
28.24% |
26.79% |
29.58% |
25.43% |
26.13% |
22.37% |
28.70% |
|
|
|
-21.43% |
<-Total Growth |
10 |
OPM |
|
|
Increase |
-5.80% |
20.18% |
-3.43% |
-0.27% |
-0.20% |
-11.23% |
17.96% |
-4.80% |
-5.14% |
10.41% |
-14.04% |
2.77% |
-14.41% |
28.34% |
|
|
|
|
Should increase |
|
or be stable. |
|
|
Diff from Ave |
-13.30% |
4.20% |
0.62% |
0.35% |
0.16% |
-11.09% |
4.88% |
-0.16% |
-5.29% |
4.57% |
-10.12% |
-7.63% |
-20.94% |
1.47% |
|
|
|
-0.03 |
<-Median-> |
10 |
OPM |
|
|
*Operational Profit
Margin (CF/Revenue) Ratio/td>
| |
|
|
|
|
|
|
|
OPM |
10 Yrs |
28.29% |
5 Yrs |
26.13% |
|
|
|
|
should be |
zero, it is a |
|
check on
calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$7,220 |
<-12 mths |
0.99% |
|
|
|
|
|
|
|
Adjusted EBITDA |
|
|
|
|
|
|
|
$5,250 |
$5,693 |
$5,701 |
$6,069 |
$6,643 |
$7,149 |
$7,371 |
$7,748 |
$8,168 |
|
|
|
|
Adjusted EBITDA |
|
|
Change |
|
|
|
|
|
|
|
|
8.44% |
0.14% |
6.46% |
9.46% |
7.62% |
3.11% |
5.11% |
5.42% |
|
|
|
|
Change |
|
|
Margin |
|
|
|
|
|
|
|
36.54% |
38.84% |
36.87% |
35.17% |
36.08% |
35.54% |
36.42% |
37.02% |
37.03% |
|
|
|
|
Margin |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long Term Debt |
$5,508 |
$5,711 |
$7,493 |
$9,321 |
$12,038 |
$12,931 |
$12,256 |
$13,265 |
$17,142 |
$18,856 |
$17,925 |
$22,496 |
$23,355 |
$24,817 |
|
|
|
211.69% |
<-Total Growth |
10 |
Debt |
Type |
|
Change |
3.67% |
3.69% |
31.20% |
24.40% |
29.15% |
7.42% |
-5.22% |
8.23% |
29.23% |
10.00% |
-4.94% |
25.50% |
3.82% |
6.26% |
|
|
|
9.12% |
<-Median-> |
10 |
Change |
Lg Term R |
|
Debt/Market Cap Ratio |
0.29 |
0.27 |
0.33 |
0.37 |
0.53 |
0.51 |
0.43 |
0.49 |
0.56 |
0.58 |
0.44 |
0.60 |
0.67 |
0.75 |
|
|
|
0.52 |
<-Median-> |
10 |
% of Market C. |
Intang/GW |
|
Assets/Current
Liabilities Ratio |
5.18 |
5.81 |
6.54 |
6.64 |
6.18 |
5.60 |
5.69 |
6.83 |
6.81 |
7.33 |
5.80 |
6.53 |
5.92 |
5.92 |
|
|
|
6.35 |
<-Median-> |
10 |
Assets/Current Liab Ratio |
Liquidity |
|
Debt to Cash Flow
(Years) |
2.16 |
1.77 |
2.31 |
2.74 |
3.40 |
4.02 |
3.11 |
3.27 |
4.37 |
4.12 |
4.09 |
4.68 |
5.19 |
4.27 |
|
|
|
4.05 |
<-Median-> |
10 |
Debt to Cash Flow (Years) |
Liq. + CF |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Liq, CF DB |
Intangibles |
$6,153 |
$6,181 |
$6,531 |
$7,797 |
$7,797 |
$10,364 |
$10,668 |
$10,956 |
$12,812 |
$15,026 |
$17,485 |
$19,178 |
$19,721 |
$20,598 |
|
|
|
201.96% |
<-Total Growth |
10 |
Intangibles |
Debt Ratio |
|
Goodwill |
$3,661 |
$3,702 |
$3,737 |
$3,757 |
$3,757 |
$3,787 |
$4,217 |
$4,733 |
$8,331 |
$7,235 |
$7,281 |
$9,169 |
$10,058 |
$10,273 |
|
|
|
169.15% |
<-Total Growth |
10 |
Goodwill |
Leverage |
|
Total |
$9,814 |
$9,883 |
$10,268 |
$11,554 |
$11,554 |
$14,151 |
$14,885 |
$15,689 |
$21,143 |
$22,261 |
$24,766 |
$28,347 |
$29,779 |
$30,871 |
|
|
|
190.02% |
<-Total Growth |
10 |
Total |
D/E Ratio |
|
Change |
12.73% |
0.70% |
3.90% |
12.52% |
0.00% |
22.48% |
5.19% |
5.40% |
34.76% |
5.29% |
11.25% |
14.46% |
5.05% |
3.67% |
|
|
|
8.33% |
<-Median-> |
10 |
Change |
|
|
Intangible/Market Cap
Ratio |
0.52 |
0.47 |
0.45 |
0.45 |
0.51 |
0.56 |
0.52 |
0.58 |
0.70 |
0.68 |
0.61 |
0.76 |
0.86 |
0.93 |
|
|
|
0.59 |
<-Median-> |
10 |
% of Market C. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Assets |
$2,051 |
$2,210 |
$2,329 |
$2,186 |
$2,331 |
$2,474 |
$2,884 |
$3,841 |
$4,353 |
$4,683 |
$5,032 |
$6,092 |
$6,313 |
$6,416 |
|
|
|
Liquidity ratio of 1.5 and up, best |
|
|
|
Current Liabilities |
$3,845 |
$3,520 |
$3,299 |
$3,499 |
$4,276 |
$4,951 |
$5,190 |
$4,841 |
$5,574 |
$5,909 |
$8,273 |
$8,281 |
$9,478 |
$9,684 |
|
|
|
0.65 |
<-Median-> |
10 |
Ratio |
|
|
Liquidity |
0.53 |
0.63 |
0.71 |
0.62 |
0.55 |
0.50 |
0.56 |
0.79 |
0.78 |
0.79 |
0.61 |
0.74 |
0.67 |
0.66 |
|
|
|
0.74 |
<-Median-> |
5 |
Ratio |
|
|
Liq. with CF aft div |
1.01 |
1.32 |
1.44 |
1.34 |
1.15 |
0.94 |
1.09 |
1.38 |
1.25 |
1.31 |
0.93 |
1.09 |
0.92 |
1.03 |
|
|
|
1.09 |
<-Median-> |
5 |
Ratio |
|
|
Liq. CF re Inv+Div |
0.67 |
0.83 |
0.84 |
0.65 |
0.56 |
0.59 |
0.64 |
0.85 |
0.65 |
0.64 |
0.56 |
0.66 |
0.61 |
1.03 |
|
|
|
0.64 |
<-Median-> |
5 |
Ratio |
|
|
Curr Long Term Debt |
$1,066 |
$545 |
$21 |
$255 |
$856 |
$1,327 |
$1,404 |
$836 |
$1,332 |
$1,432 |
$2,927 |
$2,541 |
$2,541 |
$3,334 |
|
|
|
|
|
|
|
|
|
Liquidity Less CLTD |
0.74 |
0.74 |
0.71 |
0.67 |
0.68 |
0.68 |
0.76 |
0.96 |
1.03 |
1.05 |
0.94 |
1.06 |
0.91 |
1.01 |
|
|
|
1.03 |
<-Median-> |
5 |
Ratio |
|
|
Liq. with CF aft div |
1.40 |
1.56 |
1.45 |
1.45 |
1.43 |
1.28 |
1.50 |
1.66 |
1.64 |
1.73 |
1.44 |
1.57 |
1.26 |
1.57 |
|
|
|
1.57 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Assets |
$19,931 |
$20,445 |
$21,566 |
$23,217 |
$26,406 |
$27,729 |
$29,548 |
$33,065 |
$37,975 |
$43,332 |
$47,994 |
$54,046 |
$56,136 |
$57,311 |
|
|
|
Debt Ratio of 1.5 and up, best |
|
|
|
|
Liabilities |
$12,418 |
$12,759 |
$13,551 |
$15,763 |
$18,734 |
$19,793 |
$21,285 |
$22,724 |
$27,316 |
$30,730 |
$31,935 |
$36,388 |
$38,834 |
$40,266 |
|
|
|
1.43 |
<-Median-> |
10 |
Ratio |
|
|
Debt Ratio |
1.61 |
1.60 |
1.59 |
1.47 |
1.41 |
1.40 |
1.39 |
1.46 |
1.39 |
1.41 |
1.50 |
1.49 |
1.45 |
1.42 |
|
|
|
1.45 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimates BVPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
$10.57 |
$9.92 |
$9.38 |
|
|
Estimates |
|
Estimates BVPS |
|
|
Estimate Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
$15,664.7 |
$14,698.5 |
$13,905.6 |
|
|
Estimates |
|
Estimate Book Value |
|
|
P/B Ratio (Close) |
|
|
|
|
|
|
|
|
|
|
|
|
|
2.12 |
2.26 |
2.39 |
|
|
Estimates |
|
P/B Ratio (Close) |
|
|
Difference from 10 year
median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-22.89% |
Diff M/C |
|
|
Estimates |
|
Difference from 10 yr med. |
|
|
Total Book Value |
$7,513 |
$7,686 |
$8,015 |
$7,454 |
$7,672 |
$7,936 |
$8,263 |
$10,341 |
$10,659 |
$12,602 |
$16,059 |
$17,658 |
$17,302 |
$17,045 |
|
|
|
115.87% |
<-Total Growth |
10 |
Book Value |
|
|
NCI |
$0 |
$0 |
$0 |
$0 |
$0 |
$19 |
$42 |
$82 |
$111 |
$528 |
$943 |
$1,089 |
$1,190 |
$1,236 |
|
|
|
|
|
|
NCI |
|
|
Preferred Shares |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
Preferred Shares |
|
|
Book Value |
$7,513 |
$7,686 |
$8,015 |
$7,454 |
$7,672 |
$7,917 |
$8,221 |
$10,259 |
$10,548 |
$12,074 |
$15,116 |
$16,569 |
$16,112 |
$15,809 |
$15,809 |
$15,809 |
|
101.02% |
<-Total Growth |
10 |
Book Value |
|
|
Book Value per Share |
$5.78 |
$5.89 |
$6.43 |
$6.12 |
$6.45 |
$6.71 |
$6.90 |
$8.56 |
$8.72 |
$9.35 |
$11.03 |
$11.58 |
$10.98 |
$10.67 |
$10.67 |
$10.67 |
|
70.74% |
<-Total Growth |
10 |
Book Value per Share |
|
|
Change |
-8.85% |
1.95% |
9.05% |
-4.80% |
5.47% |
3.95% |
2.79% |
24.17% |
1.80% |
7.29% |
17.98% |
4.94% |
-5.21% |
-2.81% |
0.00% |
0.00% |
|
-8.13% |
P/B Ratio |
|
Current/Historical Median |
|
|
P/B Ratio (Median) |
2.23 |
2.58 |
2.62 |
3.27 |
3.32 |
2.99 |
3.30 |
2.73 |
2.79 |
2.55 |
2.49 |
2.61 |
2.29 |
2.04 |
|
|
|
2.29 |
P/B Ratio |
|
Historical Median |
|
|
P/B Ratio (Close) |
2.49 |
2.76 |
2.84 |
3.42 |
2.96 |
3.19 |
3.45 |
2.64 |
2.88 |
2.70 |
2.70 |
2.26 |
2.15 |
2.11 |
2.11 |
2.11 |
|
5.50% |
<-IRR #YR-> |
10 |
Book Value per Share |
70.74% |
|
Change |
39.04% |
10.78% |
3.00% |
20.35% |
-13.41% |
7.49% |
8.36% |
-23.47% |
9.15% |
-6.53% |
0.16% |
-16.41% |
-4.80% |
-2.00% |
0.00% |
0.00% |
|
5.09% |
<-IRR #YR-> |
5 |
Book Value per Share |
28.17% |
|
Leverage (A/BK) |
2.65 |
2.66 |
2.69 |
3.11 |
3.44 |
3.49 |
3.58 |
3.20 |
3.56 |
3.44 |
2.99 |
3.06 |
3.24 |
3.36 |
|
|
|
3.34 |
<-Median-> |
10 |
A/BV |
|
|
Debt/Equity Ratio |
1.65 |
1.66 |
1.69 |
2.11 |
2.44 |
2.49 |
2.58 |
2.20 |
2.56 |
2.44 |
1.99 |
2.06 |
2.24 |
2.36 |
|
|
|
2.34 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
|
Sharerholders
Equity (Assets less liabilities) |
|
|
|
|
|
|
|
P/BV |
10 yr Med |
2.76 |
5 yr Med |
2.55 |
|
-23.60% |
Diff M/C |
|
2.66 |
Historical |
|
A/BV |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6.43 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$10.98 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$8.56 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$10.98 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$779 |
<-12 mths |
13.23% |
|
|
|
|
|
|
|
Total Comprehensive
Income |
$374 |
$947 |
$2,283 |
$987 |
$1,846 |
$1,221 |
$1,320 |
$1,908 |
$1,554 |
$964 |
$2,349 |
$1,797 |
$689 |
|
|
|
|
-69.82% |
<-Total Growth |
10 |
Total Comprehensive Income |
|
NCI |
$0 |
$0 |
$0 |
$0 |
$0 |
$15 |
$23 |
$10 |
$38 |
$71 |
$8 |
$143 |
$1 |
|
|
|
|
|
|
|
NCI |
|
|
Shareholders |
$374 |
$947 |
$2,283 |
$987 |
$1,846 |
$1,206 |
$1,297 |
$1,898 |
$1,516 |
$893 |
$2,341 |
$1,654 |
$688 |
|
|
|
|
-69.86% |
<-Total Growth |
10 |
Shareholders |
|
|
Increase |
-65.75% |
153.21% |
141.08% |
-56.77% |
87.03% |
-34.67% |
7.55% |
46.34% |
-20.13% |
-41.09% |
162.15% |
-29.35% |
-58.40% |
|
|
|
|
-29.35% |
<-Median-> |
5 |
Comprehensive Income |
|
|
5 Yr Running Average |
$992 |
$915 |
$1,151 |
$1,137 |
$1,287 |
$1,454 |
$1,524 |
$1,447 |
$1,553 |
$1,362 |
$1,589 |
$1,660 |
$1,418 |
|
|
|
|
-11.30% |
<-IRR #YR-> |
10 |
Comprehensive Income |
-69.86% |
|
ROE |
5.0% |
12.3% |
28.5% |
13.2% |
24.1% |
15.2% |
15.8% |
18.5% |
14.4% |
7.4% |
15.5% |
10.0% |
4.3% |
|
|
|
|
-18.37% |
<-IRR #YR-> |
5 |
Comprehensive Income |
-63.75% |
|
5Yr Median |
14.0% |
13.4% |
13.4% |
13.2% |
13.2% |
15.2% |
15.8% |
15.8% |
15.8% |
15.2% |
15.5% |
14.4% |
10.0% |
|
|
|
|
2.11% |
<-IRR #YR-> |
10 |
5 Yr Running Average |
23.21% |
|
% Difference from NI |
-69.2% |
-28.1% |
76.4% |
-30.7% |
33.6% |
-1.4% |
-11.2% |
18.6% |
-13.2% |
-26.0% |
41.5% |
2.4% |
-18.2% |
|
|
|
|
-0.40% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
-1.96% |
|
Median Values |
|
|
|
|
|
|
|
|
|
Diff |
5, 10 yr |
-6.3% |
-13.2% |
|
|
|
|
10.0% |
<-Median-> |
5 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,283 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$688 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,898 |
$0 |
$0 |
$0 |
$0 |
$688 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,151 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$1,418 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,447 |
$0 |
$0 |
$0 |
$0 |
$1,418 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Liability
Coverage Ratio |
0.73 |
0.93 |
0.93 |
0.94 |
0.83 |
0.64 |
0.77 |
0.79 |
0.76 |
0.73 |
0.54 |
0.60 |
0.52 |
0.60 |
|
|
|
|
|
|
CFO / Current Liabilities |
|
|
5 year Median |
0.87 |
0.87 |
0.87 |
0.93 |
0.93 |
0.93 |
0.83 |
0.79 |
0.77 |
0.76 |
0.76 |
0.73 |
0.60 |
0.60 |
|
|
|
0.60 |
<-Median-> |
5 |
Current Liability Cov Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Asset Efficiency Ratio |
14.14% |
16.07% |
14.15% |
14.24% |
13.37% |
11.40% |
13.53% |
11.50% |
11.22% |
9.93% |
9.31% |
9.26% |
8.84% |
10.14% |
|
|
|
|
|
|
CFO / Total Assets |
|
|
5 year Median |
14.14% |
14.14% |
14.14% |
14.15% |
14.15% |
14.15% |
13.53% |
13.37% |
11.50% |
11.40% |
11.22% |
9.93% |
9.31% |
9.31% |
|
|
|
9.3% |
<-Median-> |
5 |
Return on Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Assets ROA |
6.10% |
6.45% |
6.00% |
6.14% |
5.23% |
4.41% |
4.94% |
4.84% |
4.60% |
2.79% |
3.45% |
2.99% |
1.50% |
1.81% |
|
|
|
Net |
Income/Assets |
|
Return on Assets |
|
|
5Yr Median |
5.89% |
5.89% |
6.00% |
6.10% |
6.10% |
6.00% |
5.23% |
4.94% |
4.84% |
4.60% |
4.60% |
3.45% |
2.99% |
2.79% |
|
|
|
4.5% |
<-Median-> |
10 |
Asset Efficiency Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Equity ROE |
16.17% |
17.15% |
16.14% |
19.12% |
18.01% |
15.45% |
17.76% |
15.60% |
16.55% |
10.00% |
10.95% |
9.75% |
5.22% |
6.57% |
|
|
|
Net Inc/ |
Shareholders' equity |
|
Return on Equity |
|
|
5Yr Median |
15.71% |
15.71% |
16.14% |
16.17% |
17.15% |
17.15% |
17.76% |
17.76% |
16.55% |
15.60% |
15.60% |
10.95% |
10.00% |
9.75% |
|
|
|
15.5% |
<-Median-> |
10 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$779 |
<-12 mths |
-7.37% |
|
|
|
|
|
|
|
Total Net Income |
$1,215 |
$1,318 |
$1,294 |
$1,425 |
$1,382 |
$1,236 |
$1,479 |
$1,624 |
$1,776 |
$1,260 |
$1,698 |
$1,718 |
$867 |
|
|
|
|
-33.00% |
<-Total Growth |
10 |
Total Net Income |
|
|
NCI |
$0 |
$0 |
$0 |
$0 |
$0 |
$13 |
$19 |
$24 |
$30 |
$53 |
$43 |
$103 |
$26 |
|
|
|
|
|
|
|
NCI |
|
|
Shareholders |
$1,215 |
$1,318 |
$1,294 |
$1,425 |
$1,382 |
$1,223 |
$1,460 |
$1,600 |
$1,746 |
$1,207 |
$1,655 |
$1,615 |
$841 |
$1,038 |
$1,534 |
$1,815 |
|
-35.01% |
<-Total Growth |
10 |
Shareholders |
|
|
Increase |
17.05% |
8.48% |
-1.82% |
10.12% |
-3.02% |
-11.51% |
19.38% |
9.59% |
9.13% |
-30.87% |
37.12% |
-2.42% |
-47.93% |
23.42% |
47.78% |
18.32% |
|
EPS/CF Ratio should not be higher than 1.00 |
|
|
5 Yr Running Average |
$1,127 |
$1,139 |
$1,173 |
$1,258 |
$1,327 |
$1,328 |
$1,357 |
$1,418 |
$1,482 |
$1,447 |
$1,534 |
$1,565 |
$1,413 |
$1,271 |
$1,337 |
$1,369 |
|
-4.22% |
<-IRR #YR-> |
10 |
Net Income |
-35.01% |
|
Operating Cash Flow |
$2,550 |
$3,219 |
$3,246 |
$3,407 |
$3,542 |
$3,219 |
$3,947 |
$4,058 |
$3,927 |
$4,574 |
$4,388 |
$4,811 |
$4,499 |
|
|
|
|
-12.07% |
<-IRR #YR-> |
5 |
Net Income |
-47.44% |
|
Investment Cash Flow |
-$1,968 |
-$2,058 |
-$2,389 |
-$3,668 |
-$4,477 |
-$2,923 |
-$3,643 |
-$2,977 |
-$5,044 |
-$6,165 |
-$5,466 |
-$5,408 |
-$4,748 |
|
|
|
|
1.88% |
<-IRR #YR-> |
10 |
5 Yr Running Ave. |
20.48% |
|
Total Accruals |
$633 |
$157 |
$437 |
$1,686 |
$2,317 |
$927 |
$1,156 |
$519 |
$2,863 |
$2,798 |
$2,733 |
$2,212 |
$1,090 |
|
|
|
|
-0.07% |
<-IRR #YR-> |
5 |
5 Yr Running Ave. |
-0.37% |
|
Total Assets |
$19,931 |
$20,445 |
$21,566 |
$23,217 |
$26,406 |
$27,729 |
$29,548 |
$33,065 |
$37,975 |
$43,332 |
$47,994 |
$54,046 |
$56,136 |
|
|
|
|
|
Balance Sheet |
|
Assets |
|
|
Accruals Ratio |
3.18% |
0.77% |
2.03% |
7.26% |
8.77% |
3.34% |
3.91% |
1.57% |
7.54% |
6.46% |
5.69% |
4.09% |
1.94% |
|
|
|
|
5.69% |
<-Median-> |
5 |
Ratio |
|
|
EPS/CF Ratio |
0.43 |
0.40 |
0.41 |
0.43 |
0.39 |
0.38 |
0.37 |
0.42 |
0.41 |
0.28 |
0.37 |
0.33 |
0.17 |
|
|
|
|
0.38 |
<-Median-> |
10 |
EPS/CF Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,294 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$841 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,600 |
$0 |
$0 |
$0 |
$0 |
$841 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,173 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$1,413 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,418 |
$0 |
$0 |
$0 |
$0 |
$1,413 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change in Close |
26.74% |
12.94% |
12.32% |
14.58% |
-8.67% |
11.74% |
11.39% |
-4.98% |
11.12% |
0.28% |
18.17% |
-12.29% |
-9.76% |
-4.75% |
0.00% |
0.00% |
|
|
Count |
28 |
Years of data |
|
|
up/down |
|
|
|
|
down |
down |
|
|
|
down |
down |
down |
|
|
|
|
|
|
Count |
8 |
28.57% |
|
|
Meet Prediction? |
|
|
|
|
Yes |
|
|
|
|
|
|
Yes |
|
|
|
|
|
% right |
Count |
4 |
50.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financial Cash Flow |
-$553 |
-$1,100 |
-$628 |
-$15 |
$1,098 |
-$87 |
-$227 |
-$1,176 |
$1,238 |
$1,904 |
$953 |
$848 |
$139 |
|
|
|
|
|
C F Statement |
|
Financial Cash Flow |
|
|
Total Accruals |
$1,186 |
$1,257 |
$1,065 |
$1,701 |
$1,219 |
$1,014 |
$1,383 |
$1,695 |
$1,625 |
$894 |
$1,780 |
$1,364 |
$951 |
|
|
|
|
|
|
|
Accruals |
|
|
Accruals Ratio |
5.95% |
6.15% |
4.94% |
7.33% |
4.62% |
3.66% |
4.68% |
5.13% |
4.28% |
2.06% |
3.71% |
2.52% |
1.69% |
|
|
|
|
2.52% |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash |
$46 |
$107 |
$336 |
$60 |
$223 |
$432 |
$509 |
$414 |
$535 |
$848 |
$723 |
$974 |
$864 |
$927 |
|
|
|
|
|
|
Cash |
|
|
Cash per Share |
$0.04 |
$0.08 |
$0.27 |
$0.05 |
$0.19 |
$0.37 |
$0.43 |
$0.35 |
$0.44 |
$0.66 |
$0.53 |
$0.68 |
$0.59 |
$0.63 |
|
|
|
$0.59 |
<-Median-> |
5 |
Cash per Share |
|
|
Percentage of Stock
Price |
0.25% |
0.50% |
1.47% |
0.24% |
0.98% |
1.71% |
1.79% |
1.53% |
1.76% |
2.61% |
1.77% |
2.60% |
2.50% |
2.78% |
|
|
|
2.50% |
<-Median-> |
5 |
% of Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Notes: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 2,
2024 Last estimates were for 2023,
2024, 2025 of $20369M, $21414M, $22570M Revenue, $0.95, $1.20, $1.39 AEPS,
$0.54, $1.12, $1.36 EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.45,
$1.56, $1.67 Dividends, $1504, $2532M, $2923M FCF, $2.80, $4.10, $4.72 CFPS,
$10.80, $10.20, $9.82 BVPS, $1.879M, $2,173M 2023/4 for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
September 8,
2023. Last estimates were 2022, 2023
and 2024 of $18286M, $19962M and $21142M for Revenue, $1.27, $1.44 and $1.71
for AEPS, $1.21, $1.33 and $1.56 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
$1.36. $1.45
and $1.56 for Dividends, $1226M, $2735M and $3291M for FCF, $3.41, $3.93 and
$4.69 for CFPS, $14.40, $11.00 and $11.10 for BVPS, $1705M, $1879M and $2173M
for Net Income. |
|
|
|
|
|
|
|
|
|
|
September
10, 2022. Last estimates were for
2021, 2022 and 2023 of $16901M, $18044M and $18805M for Revenue, $1.03, $1.17
and $1.37 for EPS, $1.28, $1.37 and $1.46 for Dividends, |
|
|
|
|
|
|
|
|
|
|
$937M, $1448M
and $2693M for FCF, $3.31, $3.72 and $4.26 for CFPS, and $1418M, $1631M and
$1876M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 4,
2021. Last estimates were for 2020,
2021, and $2022 of $15247M, $16063M and $16632M for Revenue, $1.07, $1.26 and
$1.32 for EPS, $1.19, $1.28 and $1.36 for Div, |
|
|
|
|
|
|
|
|
|
|
|
$1479M,
$1904M and $2281M for FCF, $3.48 and $3.57 for CFPS for 2020-21, and $1389M,
$1666M and $1769M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September
12, 2020. Last estimates were for
2019, 2020 and 2021 of $14784, $15276 and $15712 for Revenue, $1.47, $1.48
and 1.57 for EPS, $6.85 and $7.36 for CFPS for 2020 and 2021 and $1794, $1798
and $1929 for Net Income. |
|
|
|
|
|
|
|
September 8,
2019. Last estimates were for 2018,
2019 and 2020 of $14111M, $14667M and $15217M for Revenue, $2.68, $2.85 and
$3.08 for EPS, $7.02, $7.16 and $7.35 for CFPS and $1595M, $1714M and $1845M
for Net Income. |
|
|
|
|
|
|
|
September
16, 2018. Last estimates were for
2017, 2018 and 2019 of $13288M, $13734M and $14019M for Revenue, $2.57, $2.80
and $3.09 for EPS, $6.54, $6.74 and $7.02 for CFPS, $1504M, $1635M and $1742M
for Net Income. |
|
|
|
|
|
|
|
September
17, 2017. Last estimates were for
2016 and 2017 of $13007M and $13373M
for Revenue, $2.78 and $2.94 for EPS, $5.49 and $6.11 for CFPSand $1708M and
$1843M for Net Income. |
|
|
|
|
|
|
|
|
|
|
September
18, 2016. Last estimates were for
2015, 2016 and 2017 of $12524M, $13007M and $13373M for Revenue, $2.52, $2.78
and $2.94 for EPS, $5.49, $5.89 and $6.11 for CFPS and $1519M, $1708M and
$1843M for Net Income. |
|
|
|
|
|
|
|
September
23, 2015. Last estimates were for
2014, 2015 and 2016 of $11901M, $12357M and $13669M for Revenue, $2.35, $2.60
and $2.79 for EPS, $4.90, $5.36 and $6.00 for CFPS and $1472M, $1602M and
$1677M for Net Income. |
|
|
|
|
|
|
|
September
15, 2014. Last estimates were for
2013, 2014 and 2015 of $11421M, $11852M and $12224M for Revenue, $2.09, $2.30
and $2.62 for EPS, $4.86, $4.86, $4.86 |
|
|
|
|
|
|
|
|
|
|
|
|
In 2013 they
got rid of non-voting shares and now only have common shares. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
August 18,
2013. Last estimates were for 2012 and
2013 of $10.383 (2012 only) Revenue, $4.05 and $4.44 EPS and $9.09 (2012
only) for CFPS. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 2013, all
the non-voting shares were changed into common shares, so now there is only
one type of shares. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
February 4
2013. Non-voting shares of Telus, with the ticker symbol T.A were converted
one-for-one into voting shares, with the ticker symbol T. On February 11 all
the shares began trading under the one ticker symbol. |
|
|
|
|
|
|
|
|
Feb 6,
2012. Last estimates I got were for
2010 and 2011 of $3.25 and $3.65 for EPS and $7.65 and $8.80 for CF |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Telus
non-voting shares are TSX-T.A and US shares on NYSE of TU. I am following TSX-T, which are the voting
shares. Both shares get the same
dividend amount per share. |
|
|
|
|
|
|
|
|
|
|
|
|
BC Telecom
and Telus joined 31 Jan1999 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If federal
foreign ownership restrictions were removed, non-voting shares may convert on
a one-for-one basis to common shares. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sector: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Telecom Service,
Utilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What should
this stock accomplish? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Would I buy
this company and Why. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If I was
looking for a telecom stock, I would consider this one. It is a dividend
growth stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Why am I following this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I started to
follow this stock because of a list of stock John Sartz talked about in
2008. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
At the
Toronto Money Shows in 2009 and 2010 Aaron Dunn from KeyStone Financial
Publishing Corp talked about having recommended this stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Aaron Dunn
says he likes companies with resilient business models, which are profitable
and are growing their earnings. He
also like companies with strong management teams, health balance sheets and
compelling valuations. |
|
|
|
|
|
|
|
|
They look at
the P/E and the Price/Cash Flow ratios.
Telus Corp (TSX-T) was one of three stocks he recommended in
2009. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends
are paid in Cycle 1, that is January, April, July and October. Dividends are declared for shareholders of
record of one month and paid in the following month. |
|
|
|
|
|
|
|
|
|
|
|
|
For example,
the dividend declared for the shareholders of record of September 10, 2013
was paid on October 1, 2013. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
How they make their
money. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Telus is one
of the Big Three wireless service providers in Canada. It is the incumbent local exchange carrier
in the western Canadian provinces of British Columbia |
|
|
|
|
|
|
|
|
|
|
|
|
|
and Alberta,
where it provides internet, television, and landline phone services. It also
has a small wireline presence in eastern Quebec. Mostly because of
recent |
|
|
|
|
|
|
|
|
|
|
|
|
|
acquisitions,
more than 20% of Telus' sales now come from non-telecom businesses, most
notably in the international business services, health, security, and
agriculture |
|
|
|
|
|
|
|
|
|
|
|
|
industries.
The firm has a 55% economic stake in Telus International. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
http://www.cantechletter.com/2014/01/europacific-canadas-rob-goff-reveals-top-tech-picks-2014/ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Updated for |
Split |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
%, 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 |
|
On Sep 16 2014 |
2016 |
Sep 17 |
2017 |
Sep 16 |
2018 |
Sep 8 |
2019 |
Sep 12 |
2020 |
Sep 4 |
2021 |
Sep 10 |
2022 |
Sep 8 |
2023 |
|
|
Sep 2 |
2024 |
|
|
|
|
Entwistle, Darren |
0.04% |
0.370 |
0.03% |
0.394 |
0.03% |
0.367 |
0.03% |
0.758 |
0.06% |
0.385 |
0.03% |
0.392 |
0.03% |
0.773 |
0.05% |
|
|
0.799 |
0.05% |
|
|
3.36% |
|
CEO - Shares - Amount |
$10.480 |
|
$8.798 |
|
$8.905 |
|
$9.222 |
|
$19.111 |
|
$11.454 |
|
$10.248 |
|
$18.233 |
|
|
|
$17.950 |
|
|
|
|
Options - percentage |
0.05% |
1.220 |
0.10% |
1.205 |
0.10% |
1.285 |
0.11% |
2.350 |
0.18% |
1.255 |
0.09% |
1.281 |
0.09% |
1.475 |
0.10% |
|
|
1.647 |
0.11% |
|
|
11.68% |
|
Options - amount |
$12.100 |
|
$29.049 |
|
$27.257 |
|
$32.305 |
|
$59.243 |
|
$37.382 |
|
$33.486 |
|
$34.779 |
|
|
|
$36.994 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Natale, Joe |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CEO - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
French, Douglas |
0.00% |
0.009 |
0.00% |
0.020 |
0.00% |
0.039 |
0.00% |
0.069 |
0.01% |
0.086 |
0.01% |
0.093 |
0.01% |
0.121 |
0.01% |
|
|
0.122 |
0.01% |
|
|
0.89% |
|
CFO - Shares - Amount |
$0.102 |
|
$0.225 |
|
$0.448 |
|
$0.983 |
|
$1.747 |
|
$2.574 |
|
$2.418 |
|
$2.846 |
|
|
|
$2.735 |
|
|
|
|
Options - percentage |
0.01% |
0.151 |
0.01% |
0.240 |
0.02% |
-0.298 |
-0.02% |
0.621 |
0.05% |
0.328 |
0.02% |
0.334 |
0.02% |
0.359 |
0.02% |
|
|
0.400 |
0.03% |
|
|
11.27% |
|
Options - amount |
$1.747 |
|
$3.595 |
|
$5.425 |
|
-$7.494 |
|
$15.649 |
|
$9.759 |
|
$8.726 |
|
$8.468 |
|
|
|
$8.974 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gossling, John Richard |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CFO - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Arora, Navin |
|
|
|
|
|
0.025 |
0.00% |
0.079 |
0.01% |
0.079 |
0.01% |
0.114 |
0.01% |
0.161 |
0.01% |
|
|
0.194 |
0.01% |
|
|
20.45% |
|
Officer - Shares -
Amount |
|
|
|
|
|
|
$0.628 |
|
$1.999 |
|
$2.351 |
|
$2.992 |
|
$3.807 |
|
|
|
$4.367 |
|
|
|
|
Options - percentage |
|
|
|
|
|
0.097 |
0.01% |
0.304 |
0.02% |
0.236 |
0.02% |
0.290 |
0.02% |
0.369 |
0.03% |
|
|
0.541 |
0.04% |
|
|
46.46% |
|
Options - amount |
|
|
|
|
|
|
$2.447 |
|
$7.652 |
|
$7.036 |
|
$7.568 |
|
$8.706 |
|
|
|
$12.146 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mawji, Zainul |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.095 |
0.01% |
|
|
0.153 |
0.01% |
|
|
61.41% |
|
Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.230 |
|
|
|
$3.429 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.317 |
0.02% |
|
|
0.489 |
0.03% |
|
|
53.97% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$7.486 |
|
|
|
$10.979 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
McIntosh, Sandy |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.101 |
0.01% |
|
|
0.149 |
0.01% |
|
|
47.73% |
|
Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.381 |
|
|
|
$3.350 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.246 |
0.02% |
|
|
0.359 |
0.02% |
|
|
45.91% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$5.803 |
|
|
|
$8.065 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chan, Raymond Tatsun |
|
0.040 |
0.00% |
0.040 |
0.00% |
0.040 |
0.00% |
0.080 |
0.01% |
0.080 |
0.01% |
0.080 |
0.01% |
0.092 |
0.01% |
|
|
0.092 |
0.01% |
|
|
0.00% |
|
Director - Shares -
Amount |
|
|
$0.952 |
|
$0.905 |
|
$1.006 |
|
$2.017 |
|
$2.383 |
|
$2.090 |
|
$2.169 |
|
|
|
$2.066 |
|
|
|
|
Options - percentage |
|
0.329 |
0.03% |
0.040 |
0.00% |
0.048 |
0.00% |
0.057 |
0.00% |
0.066 |
0.00% |
0.075 |
0.01% |
0.085 |
0.01% |
|
|
0.100 |
0.01% |
|
|
17.06% |
|
Options - amount |
|
|
$7.828 |
|
$0.916 |
|
$1.209 |
|
$1.439 |
|
$1.978 |
|
$1.952 |
|
$2.009 |
|
|
|
$2.240 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Claxton, Hazel Cynthia |
|
|
|
|
|
|
|
|
|
|
|
0.003 |
0.00% |
0.003 |
0.00% |
|
|
0.003 |
0.00% |
|
|
0.00% |
|
Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.078 |
|
$0.071 |
|
|
|
$0.067 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
0.012 |
0.00% |
0.021 |
0.00% |
|
|
0.033 |
0.00% |
|
|
56.11% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.324 |
|
$0.491 |
|
|
|
$0.730 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Flynn, Tomas Earl |
|
|
|
|
|
|
|
|
|
|
|
0.010 |
0.00% |
0.012 |
0.00% |
|
|
0.012 |
0.00% |
|
|
0.00% |
|
Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.261 |
|
$0.273 |
|
|
|
$0.260 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
0.025 |
0.00% |
0.036 |
0.00% |
|
|
0.051 |
0.00% |
|
|
42.36% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.643 |
|
$0.841 |
|
|
|
$1.140 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Manley, John Paul |
|
|
|
|
|
|
|
|
|
|
|
0.003 |
0.00% |
0.005 |
0.00% |
|
|
0.007 |
0.00% |
|
|
41.90% |
|
Chairman. - Shares - Amt |
|
|
|
|
|
|
|
|
|
|
|
|
$0.080 |
|
$0.114 |
|
|
|
$0.154 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
0.129 |
0.01% |
0.147 |
0.01% |
|
|
0.176 |
0.01% |
|
|
19.89% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
$3.366 |
|
$3.468 |
|
|
|
$3.960 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Auchinleck, Richard H.
(Dick) |
0.01% |
0.040 |
0.00% |
0.046 |
0.00% |
0.053 |
0.00% |
0.058 |
0.00% |
0.062 |
0.00% |
0.069 |
0.00% |
|
|
|
|
|
|
|
Ceased insider May 2023 |
|
|
Chairman. - Shares - Amt |
$1.571 |
|
$0.944 |
|
$1.05 |
|
$1.332 |
|
$1.467 |
|
$1.845 |
|
$1.803 |
|
|
|
|
|
|
|
|
|
|
Options - percentage |
0.03% |
0.337 |
0.03% |
0.365 |
0.03% |
0.395 |
0.03% |
0.428 |
0.03% |
0.462 |
0.03% |
0.493 |
0.03% |
|
|
|
|
|
|
|
|
|
|
Options - amount |
$6.543 |
|
$8.020 |
|
$8.27 |
|
$9.932 |
|
$10.795 |
|
$13.772 |
|
$12.893 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Increase in O/S Shares |
0.15% |
0.000 |
0.00% |
2.000 |
0.17% |
3.867 |
0.32% |
4.101 |
0.34% |
3.698 |
0.29% |
4.000 |
0.29% |
4.000 |
0.28% |
|
|
4.000 |
0.27% |
|
Share-based compensation |
|
|
due to SO |
$33.890 |
|
$0.000 |
|
$47.620 |
|
$87.493 |
|
$103.092 |
|
$93.229 |
|
$119.160 |
|
$104.520 |
|
|
|
$94.320 |
|
settled in cash |
|
|
Book Value |
$7.000 |
|
$2.000 |
|
$2.000 |
|
$86.000 |
|
$33.000 |
|
$97.000 |
|
$141.000 |
|
$133.000 |
|
|
|
$99.000 |
|
Equity Accounted Share-based |
|
Insider Buying |
-$4.298 |
|
-$1.637 |
|
-$1.820 |
|
-$3.075 |
|
-$3.324 |
|
-$1.725 |
|
-$0.262 |
|
-$10.280 |
|
|
|
-$1.065 |
|
Compensation |
|
|
Insider Selling |
$9.091 |
|
$0.416 |
|
$0.051 |
|
$1.425 |
|
$0.729 |
|
$2.648 |
|
$27.071 |
|
$32.933 |
|
|
|
$2.166 |
|
|
|
|
Net Insider Selling |
$4.793 |
|
-$1.221 |
|
-$1.769 |
|
-$1.651 |
|
-$2.595 |
|
$0.923 |
|
$26.809 |
|
$22.652 |
|
|
|
$1.101 |
|
|
|
|
% of Market Cap |
0.02% |
|
0.00% |
|
-0.01% |
|
-0.01% |
|
-0.01% |
|
0.00% |
|
0.07% |
|
0.07% |
|
|
|
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Directors 2013 |
|
13 |
|
14 |
|
12 |
|
12 |
|
14 |
|
15 |
|
14 |
|
|
|
14 |
|
|
|
|
|
Women |
25% |
3 |
23% |
4 |
29% |
5 |
42% |
5 |
42% |
5 |
36% |
6 |
40% |
6 |
43% |
|
|
6 |
43% |
|
|
|
|
Minorities |
8% |
2 |
15% |
2 |
14% |
1 |
8% |
1 |
8% |
1 |
7% |
1 |
7% |
1 |
7% |
|
|
1 |
7% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Asian male |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Institutions/Holdings |
53.59% |
594 |
51.09% |
596 |
51.09% |
282 |
51.92% |
20 |
45.27% |
20 |
57.98% |
20 |
43.40% |
20 |
80.27% |
|
|
20 |
47.62% |
|
|
|
|
Total Shares Held |
26.87% |
303.492 |
25.46% |
328.075 |
27.52% |
312.581 |
25.83% |
581.257 |
45.02% |
789.089 |
61.12% |
602.009 |
42.07% |
1,161.577 |
79.13% |
|
|
705.674 |
47.62% |
|
|
|
|
Increase/Decrease 3 Mths |
-0.59% |
-11.239 |
-3.57% |
6.236 |
0.52% |
3.280 |
0.27% |
31.143 |
2.60% |
54.485 |
4.55% |
-6.102 |
-0.51% |
34.444 |
2.88% |
|
|
16.191 |
1.35% |
|
|
|
|
Starting No. of Shares |
Nasdaq |
314.732 |
Nasdaq |
321.840 |
Nasdaq |
309.301 |
Nasdaq |
550.113 |
MS Top 20 |
734.605 |
MS Top 20 |
608.111 |
MS Top 20 |
1,127.133 |
MS Top 20 |
|
|
689.484 |
MS Top 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright ©
2008 Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|