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. Estimates Estimates Estimates
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Q1 2024 <-Estimates
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ 3/31/24 <-Estimates
BCE Inc TSX: BCE NYSE BCE http://www.bce.ca/ Fiscal Yr: Dec-31
Year 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 Accounting Rules
comments comments
comments comments
$24,732 <-12 mths 0.24% Estimates last 12 months from Qtr.
Revenue* $19,975 $20,400 $21,042 $21,514 $21,719 $22,719 $23,468 $23,964 $22,883 $23,449 $24,174 $24,673 $24,953 $25,433 $26,018 20.95% <-Total Growth 10 Revenue
Increase 2.45% 2.13% 3.15% 2.24% 0.95% 4.60% 3.30% 2.11% -4.51% 2.47% 3.09% 2.06% 1.13% 1.92% 2.30% 1.92% <-IRR #YR-> 10 Revenue 20.95%
5 year Running Average $18,595 $19,135 $19,797 $20,486 $20,930 $21,479 $22,092 $22,677 $22,951 $23,297 $23,588 $23,829 $24,026 $24,536 $25,050 1.01% <-IRR #YR-> 5 Revenue 5.13%
Revenue per Share $25.76 $26.29 $25.04 $24.85 $24.94 $25.22 $26.13 $26.51 $25.30 $25.80 $26.51 $27.05 $27.35 $27.88 $28.52 2.22% <-IRR #YR-> 10 5 yr Running Average 24.53%
Increase 2.46% 2.06% -4.76% -0.74% 0.36% 1.09% 3.62% 1.47% -4.56% 1.95% 2.76% 2.03% 1.13% 1.92% 2.30% 1.52% <-IRR #YR-> 5 5 yr Running Average 7.86%
5 year Running Average $23.89 $24.74 $25.25 $25.42 $25.38 $25.27 $25.24 $25.53 $25.62 $25.79 $26.05 $26.23 $26.40 $26.92 $27.46 0.28% <-IRR #YR-> 10 Revenue per Share 2.87%
P/S (Price/Sales) Med 1.64 1.71 1.99 2.23 2.34 2.38 2.13 2.23 2.29 2.35 2.45 2.13 1.86 0.00 0.00 0.69% <-IRR #YR-> 5 Revenue per Share 3.51%
P/S (Price/Sales) Close 1.65 1.75 2.13 2.15 2.33 2.39 2.06 2.27 2.15 2.57 2.24 1.93 1.67 1.64 1.61 0.59% <-IRR #YR-> 10 5 yr Running Average 6.02%
* Operating Revenue in M CDN $  P/S Med 20 yr  1.85 15 yr  2.13 10 yr  2.26 5 yr  2.29 -26.01% Diff M/C 0.78% <-IRR #YR-> 5 5 yr Running Average 3.95%
-$20,400 $0 $0 $0 $0 $0 $0 $0 $0 $0 $24,673
-$23,468 $0 $0 $0 $0 $24,673
-$19,135 $0 $0 $0 $0 $0 $0 $0 $0 $0 $23,829
-$22,092 $0 $0 $0 $0 $23,829
-$26.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $27.05
-$26.13 $0.00 $0.00 $0.00 $0.00 $27.05
Payout Ratio 130.36% 128.57% 128.67% Payout Ratio
$2.43 <-12 mths -24.17% Estimates Last 12 months from Qtr
Adjusted Earnings $2,294 $2,317 $2,524 $2,845 $3,009 $3,033 $3,151 $3,153 $2,699 $2,895 $3,057 $2,926 26.28% <-Total Growth 10 Adjusted Profit CDN$
Return on Equity ROE 21.89% 19.95% 23.07% 21.85% 22.23% 20.01% 19.26% 18.47% 15.89% 15.54% 16.82% 17.67% 18.87% <-Median-> 10 Return on Equity ROE
5Yr Median 14.68% 19.95% 21.89% 21.89% 21.89% 21.85% 21.85% 20.01% 19.26% 18.47% 16.82% 16.82% 20.93% <-Median-> 10 5 Yr Median
Adjusted EPS Calc Basic $2.96 $2.99 $3.18 $3.36 $3.46 $3.39 $3.51 $3.50 $2.98 $3.19 $3.35 $3.21 7.39% <-Total Growth 10 Adjusted EPS Calc Basic
Adjusted EPS $2.96 $2.99 $3.18 $3.36 $3.46 $3.39 $3.51 $3.50 $3.02 $3.19 $3.35 $3.21 $3.06 $3.21 $3.32 7.36% <-Total Growth 10 AEPS
Increase -5.43% 1.01% 6.35% 5.66% 2.98% -2.02% 3.54% -0.28% -13.71% 5.63% 5.02% -4.18% -4.67% 4.90% 3.43% 10 0 10 Years of Data, EPS P or N
Adj EPS Yield 6.94% 6.50% 5.97% 6.29% 5.96% 5.61% 6.51% 5.82% 5.55% 4.80% 5.63% 6.15% 6.68% 7.01% 7.25% 0.71% <-IRR #YR-> 10 AEPS
5 year Running Average $2.73 $2.87 $3.01 $3.12 $3.19 $3.28 $3.38 $3.44 $3.38 $3.32 $3.31 $3.25 $3.17 $3.20 $3.23 -1.77% <-IRR #YR-> 5 AEPS
Payout Ratio 74.16% 77.42% 76.57% 76.41% 77.96% 83.63% 84.97% 89.50% 108.94% 108.39% 108.51% 119.08% 129.41% 124.30% 120.18% 1.25% <-IRR #YR-> 10 5 yr Running Average
5 year Running Average 59.45% 68.44% 71.12% 73.98% 76.51% 78.40% 79.91% 82.50% 89.00% 95.09% 100.06% 106.88% 114.87% 117.94% 120.30% -0.76% <-IRR #YR-> 5 5 yr Running Average
P/E Ratio Median 14.28 15.05 15.66 16.51 16.85 17.69 15.85 16.92 19.20 19.00 19.42 17.96 16.65 0.00 0.00 17.31 <-Median-> 10 P/E Ratio Median
P/E Ratio High 15.22 16.20 17.05 17.55 18.26 18.50 17.20 18.59 21.59 20.99 22.02 20.39 18.31 0.00 0.00 18.54 <-Median-> 10 P/E Ratio High
P/E Ratio Low 13.33 13.91 14.27 15.47 15.45 16.88 14.50 15.26 16.81 17.00 16.82 15.54 14.99 0.00 0.00 15.51 <-Median-> 10 P/E Ratio Low
P/E Ratio Close 14.40 15.38 16.75 15.91 16.77 17.81 15.36 17.19 18.02 20.82 17.76 16.25 14.97 14.27 13.80 16.98 <-Median-> 10 P/E Ratio Close
Trailing P/E Close 13.62 15.54 17.82 16.81 17.27 17.45 15.91 17.14 15.55 21.99 18.65 15.57 14.27 14.97 14.27 17.21 <-Median-> 10 Trailing P/E Close
Median Values DPR 10 Yrs 87.24% 5 Yrs   108.51% P/CF 5 Yrs   in order 19.00 20.99 16.81 17.76 -21.21% Diff M/C
* Adjusted Net Earnings
-$2.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.21
-$3.51 $0.00 $0.00 $0.00 $0.00 $3.21
-$2.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.25
-$3.38 $0.00 $0.00 $0.00 $0.00 $3.25
US GAAP
before split
Nortel
With Nortel
$2.07 <-12 mths -9.31%
Difference Basic and Diluted 0.00% 0.39% 0.34% 0.00% 0.00% 0.32% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Difference Basic and Diluted
EPS Basic $3.39 $2.55 $2.98 $2.98 $3.33 $3.12 $3.10 $3.37 $2.76 $2.99 $2.98 $2.28 -10.59% <-Total Growth 10 EPS Basic
Pre 1997
With Nortel
EPS Diluted* $3.39 $2.54 $2.97 $2.98 $3.33 $3.11 $3.10 $3.37 $2.76 $2.99 $2.98 $2.28 $2.69 $3.21 $3.28 -10.24% <-Total Growth 10 EPS Diluted
Increase 17.71% -25.07% 16.93% 0.34% 11.74% -6.61% -0.32% 8.71% -18.10% 8.33% -0.33% -23.49% 17.81% 19.55% 2.09% 10 0 10 Years of Data, EPS P or N 100.00%
Earnings Yield 8.0% 5.5% 5.6% 5.6% 5.7% 5.2% 5.7% 5.6% 5.1% 4.5% 5.0% 4.4% 5.9% 7.0% 7.2% -1.07% <-IRR #YR-> 10 Earnings per Share -10.24%
5 year Running Average $2.45 $2.75 $2.93 $2.95 $3.04 $2.99 $3.10 $3.18 $3.13 $3.07 $3.04 $2.88 $2.74 $2.83 $2.89 -5.96% <-IRR #YR-> 5 Earnings per Share -26.45%
10 year Running Average $2.49 $2.56 $2.69 $2.79 $2.89 $2.72 $2.93 $3.05 $3.04 $3.05 $3.01 $2.99 $2.96 $2.98 $2.98 0.43% <-IRR #YR-> 10 5 yr Running Average 4.43%
* ESP per share (Cdn GAAP) E/P 10 Yrs 5.36% 5Yrs 5.01% -1.48% <-IRR #YR-> 5 5 yr Running Average -7.17%
-$2.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.28
-$3.10 $0.00 $0.00 $0.00 $0.00 $2.28
-$2.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.88
-$3.10 $0.00 $0.00 $0.00 $0.00 $2.88
Act Div '08
Nortel
No Nortel
from state.
Div I received
Increase
Split of 1997 $0.00 $0.00 $0.00
Nortel Spin off
Dividend* $3.99 $4.13 $4.27 Estimates Dividend*
Increase 4.36% 3.46% 3.51% Estimates Increase
Payout Ratio EPS 148.51% 128.53% 130.32% 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 <-Median-> 10 Special Dividends
Pre 1997
With Nortel
Dividend* $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $3.82 $3.96 $3.99 $3.99 65.12% <-Total Growth 10 Dividends
Increase 7.33% 5.47% 5.18% 5.44% 5.06% 5.10% 5.20% 5.03% 5.03% 5.09% 5.13% 5.16% 3.60% 0.76% 0.00% 31 1 40 Years of data, Count P, N 77.50%
Average Increases 5 Year Running 20.29% 31.39% 9.13% 8.29% 5.70% 5.25% 5.20% 5.17% 5.08% 5.09% 5.10% 5.09% 4.80% 3.95% 2.93% -83.79% <-Total Growth 10 Dividends 5 Yr Running
Dividends 5 Yr Running $1.66 $1.97 $2.14 $2.31 $2.44 $2.57 $2.70 $2.84 $2.99 $3.14 $3.30 $3.47 $3.63 $3.77 $3.88 75.70% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 5.19% 5.14% 4.89% 4.63% 4.63% 4.73% 5.36% 5.29% 5.67% 5.71% 5.59% 6.63% 7.77% 5.32% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 4.87% 4.78% 4.49% 4.35% 4.27% 4.52% 4.94% 4.81% 5.05% 5.16% 4.93% 5.84% 7.07% 4.87% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 5.56% 5.57% 5.37% 4.94% 5.05% 4.95% 5.86% 5.87% 6.48% 6.37% 6.45% 7.66% 8.63% 5.86% <-Median-> 10 Yield on Low Price AEPS
Yield on Close Price 5.15% 5.03% 4.57% 4.80% 4.65% 4.70% 5.53% 5.21% 6.04% 5.21% 6.11% 7.33% 8.65% 8.71% 8.71% 5.21% <-Median-> 10 Yield on Close Price CFPS
Payout Ratio EPS 64.75% 91.14% 81.99% 86.16% 81.01% 91.16% 96.21% 92.95% 119.20% 115.64% 121.98% 167.65% 147.43% 124.26% 121.72% 94.58% <-Median-> 10 DPR EPS FCF 1
DPR EPS 5 Yr Running 67.67% 71.66% 73.29% 78.30% 80.28% 86.07% 87.27% 89.46% 95.33% 102.40% 108.54% 120.57% 132.63% 133.35% 134.38% 88.36% <-Median-> 10 DPR EPS 5 Yr Running FCF 2
Payout Ratio CFPS 30.65% 27.74% 32.79% 35.42% 35.36% 34.71% 36.28% 37.27% 38.37% 39.25% 39.63% 43.89% 50.25% 46.40% #DIV/0! 36.77% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 24.89% 28.80% 30.21% 31.70% 32.29% 33.10% 34.94% 35.83% 36.44% 37.22% 38.20% 39.70% 42.10% 43.70% #DIV/0! 35.38% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 29.58% 28.38% 34.82% 36.84% 36.95% 29.99% 30.99% 30.27% 32.21% 32.64% 33.46% 33.47% 50.25% 46.40% #DIV/0! 33.05% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 25.21% 28.79% 30.49% 32.01% 33.14% 33.06% 33.51% 32.53% 31.82% 31.25% 31.95% 32.44% 35.64% 38.22% #DIV/0! 32.22% <-Median-> 4 DPR CF WC 5 Yr Running
Median Values 10 Yr Cl 5.32% 5.21% 5 Yr Med 5 Yr Cl 5.67% 6.04% 5 Yr Med Payout 119.20% 39.25% 32.64% 5.09% <-IRR #YR-> 5 Dividends 28.16%
* Dividends per share  and Cur. 63.61% 67.31% 5 Yr Med and Cur. 53.53% 44.13% Last Div Inc ---> $0.9675 $0.9975 3.10% 5.14% <-IRR #YR-> 10 Dividends 65.12%
Dividends Growth 15 11.67% <-IRR #YR-> 15 Dividends 423.63%
Dividends Growth 20 5.96% <-IRR #YR-> 20 Dividends 218.54%
Dividends Growth 25 9.25% <-IRR #YR-> 25 Dividends 812.85%
Dividends Growth 30 7.73% <-IRR #YR-> 30 Dividends 833.44%
Dividends Growth 35 6.84% <-IRR #YR-> 35 Dividends 913.45%
Dividends Growth 40 6.40% <-IRR #YR-> 40 Dividends
Dividends Growth 5 -$2.98 $0.00 $0.00 $0.00 $0.00 $3.82 Dividends Growth 5
Dividends Growth 10 -$2.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.82 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 $3.82 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 $3.82 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 $3.82 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 $3.82 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 $3.82 Dividends Growth 35
Dividends Growth 40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.82 Dividends Growth 40
Historical Dividends High Div 6.56% Low Div 1.26% 10 Yr High 7.55% 10 Yr Low 4.28% Med Div 4.22% Close Div 3.68% Historical Dividends
High/Ave/Median Values Cheap 32.80%     591.41% Cheap 15.39% 103.55% Cheap 106.44% Cheap 136.59% High/Ave/Median 
Future Dividend Yield Div Yd 11.17% earning in 5 Years at IRR of 5.09% Div Inc. 28.16% Future Dividend Yield
Future Dividend Yield Div Yd 14.31% earning in 10 Years at IRR of 5.09% Div Inc. 64.26% Future Dividend Yield
Future Dividend Yield Div Yd 18.34% earning in 15 Years at IRR of 5.09% Div Inc. 110.52% Future Dividend Yield
Future Dividend Paid Div Paid $5.11 earning in 5 Years at IRR of 5.09% Div Inc. 28.16% Future Dividend Paid
Future Dividend Paid Div Paid $6.55 earning in 10 Years at IRR of 5.09% Div Inc. 64.26% Future Dividend Paid
Future Dividend Paid Div Paid $8.40 earning in 15 Years at IRR of 5.09% Div Inc. 110.52% Future Dividend Paid
Dividend Covering Cost Total Div $22.09 over 5 Years at IRR of 5.09% Div Cov. 48.22% Dividend Covering Cost
Dividend Covering Cost Total Div $45.28 over 10 Years at IRR of 5.09% Div Cov. 98.86% Dividend Covering Cost
Dividend Covering Cost Total Div $75.00 over 15 Years at IRR of 5.09% Div Cov. 163.76% Dividend Covering Cost
I am earning GC Div Gr 732.28% 10/15/82 # yrs -> 42 1982 $9.09 Cap Gain -100.00% I am earning GC
I am earning Div org yield 5.23% 12/31/24 Trading Div G Yrly 5.14% Div start $0.48 -5.23% 43.55% I am earning Div
I am earning GC Div Gr 191.18% 5/26/99 # yrs -> 25 1999 $21.65 Cap Gain -100.00% I am earning GC
I am earning Div org yield 6.28% 12/31/24 RRSP Div G Yrly 4.26% Div start $1.36 -6.28% 18.29% I am earning Div
Yield if held 5 years 6.21% 7.53% 9.30% 8.08% 7.01% 6.71% 6.63% 6.29% 5.93% 5.93% 6.06% 6.87% 6.69% 6.88% 6.58% 6.67% <-Median-> 10 Paid Median Price
Yield if held 10 years 7.33% 7.84% 8.74% 8.67% 12.04% 8.02% 9.71% 11.97% 10.35% 8.98% 8.60% 8.49% 7.95% 7.19% 6.84% 8.86% <-Median-> 10 Paid Median Price
Yield if held 15 years 6.26% 4.87% 2.86% 6.50% 6.97% 9.47% 10.11% 11.24% 11.10% 15.44% 10.28% 12.44% 15.13% 12.55% 10.37% 10.19% <-Median-> 10 Paid Median Price
Yield if held 20 years 13.45% 11.96% 11.42% 13.12% 10.55% 8.08% 6.27% 3.68% 8.33% 8.93% 12.14% 12.95% 14.21% 13.47% 17.81% 9.74% <-Median-> 10 Paid Median Price
Yield if held 25 years 17.83% 14.64% 16.93% 17.92% 17.37% 15.41% 14.69% 16.81% 13.52% 10.36% 8.04% 4.66% 10.10% 10.31% 15.05% <-Median-> 10 Paid Median Price
Yield if held 30 years 22.97% 18.84% 21.69% 22.96% 22.27% 19.74% 18.58% 20.38% 15.60%
Yield if held 35 years 29.43% 23.81% 26.31% 26.50%
Cost covered if held 5 years 23.43% 32.11% 40.96% 36.36% 31.73% 30.40% 30.03% 28.55% 26.92% 26.92% 27.51% 31.17% 30.67% 32.54% 32.01% 30.22% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 49.36% 53.86% 61.48% 62.04% 88.20% 59.77% 76.10% 95.27% 83.36% 72.52% 69.44% 68.55% 65.03% 60.93% 60.18% 70.98% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 55.98% 45.28% 27.20% 62.03% 67.16% 92.26% 99.66% 112.50% 112.46% 158.28% 106.43% 132.52% 164.67% 142.71% 122.92% 103.05% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 133.03% 122.02% 120.29% 141.98% 117.58% 92.60% 73.70% 43.92% 99.84% 107.71% 147.35% 158.40% 177.69% 176.13% 244.88% 112.65% <-Median-> 10 Paid Median Price
Cost covered if held 25 years 197.14% 166.30% 196.70% 213.43% 211.75% 191.84% 186.97% 218.28% 178.95% 139.62% 110.15% 65.28% 147.60% 157.82% 189.41% <-Median-> 10 Paid Median Price
Cost covered if held 30 years 301.23% 251.79% 295.19% 317.69% 312.81% 281.39% 272.18% 314.65% 254.80%
Cost covered if held 35 years 434.73% 361.02% 419.58% 446.53%
Dividends on Shares $76.83 $81.03 $85.23 $89.86 $94.41 $99.23 $104.39 $109.64 $115.15 $121.01 $127.23 $133.79 $138.60 $139.65 $139.65 $1,636.34 No of Years 20 Total Divs 12/31/03
Paid  $1,492.05 $1,610.00 $1,864.80 $1,871.10 $2,031.05 $2,113.30 $1,887.55 $2,105.60 $1,905.05 $2,324.00 $2,082.15 $1,825.95 $1,603.00 $1,603.00 $1,603.00 $1,825.95 No of Years 20 Worth $28.90
$3,462.29
Dividends on Shares $53.57 $56.49 $59.35 $62.37 $65.62 $68.92 $72.38 $76.07 $79.97 $84.10 $87.12 $87.78 $87.78 $678.81 No of Years 10 Total Divs 12/31/13
Paid  $1,012.00 $1,172.16 $1,176.12 $1,276.66 $1,328.36 $1,186.46 $1,323.52 $1,197.46 $1,460.80 $1,308.78 $1,147.74 $1,007.60 $1,007.60 $1,007.60 $1,147.74 No of Years 10 Worth $46.00
$1,826.55
Yr  Item Tot. Growth
Revenue Growth  $23,468 $23,964 $22,883 $23,449 $24,174 $24,673 $24,732 <-12 mths 0.24% 5.13% <-Total Growth 5 Revenue Growth  5.13%
AEPS Growth $3.51 $3.50 $3.02 $3.19 $3.35 $3.21 $2.43 <-12 mths -24.17% -8.55% <-Total Growth 5 AEPS Growth -8.55%
Net Income Growth $2,973 $3,253 $2,699 $2,892 $2,926 $2,327 $1,843 <-12 mths -20.82% -21.73% <-Total Growth 5 Net Income Growth -21.73%
Cash Flow Growth $7,384 $7,598 $7,754 $8,008 $8,365 $7,946 7.61% <-Total Growth 5 Cash Flow Growth 7.61%
Dividend Growth $2.98 $3.13 $3.29 $3.46 $3.64 $3.82 $3.96 <-12 mths 3.60% 28.16% <-Total Growth 5 Dividend Growth 28.16%
Stock Price Growth $53.93 $60.16 $54.43 $66.40 $59.49 $52.17 $45.80 <-12 mths -12.21% -3.26% <-Total Growth 5 Stock Price Growth -3.26%
Revenue Growth  $20,400 $21,042 $21,514 $21,719 $22,719 $23,468 $23,964 $22,883 $23,449 $24,174 $24,673 $24,953 <-this year 1.13% 20.95% <-Total Growth 10 Revenue Growth  20.95%
AEPS Growth $2.99 $3.18 $3.36 $3.46 $3.39 $3.51 $3.50 $3.02 $3.19 $3.35 $3.21 $3.06 <-this year -4.67% 7.36% <-Total Growth 10 AEPS Growth 7.36%
Net Income Growth $2,388 $2,718 $2,730 $3,067 $2,970 $2,973 $3,253 $2,699 $2,892 $2,926 $2,327 $2,424 <-this year 4.17% -2.55% <-Total Growth 10 Net Income Growth -2.55%
Cash Flow Growth $6,476 $6,241 $6,274 $6,643 $7,358 $7,384 $7,598 $7,754 $8,008 $8,365 $7,946 $7,189 <-this year -9.53% 22.70% <-Total Growth 10 Cash Flow Growth 22.70%
Dividend Growth $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $3.82 $3.99 <-this year 4.36% 65.12% <-Total Growth 10 Dividend Growth 65.12%
Stock Price Growth $46.00 $53.28 $53.46 $58.03 $60.38 $53.93 $60.16 $54.43 $66.40 $59.49 $52.17 $54.79 <-this year 5.02% 13.41% <-Total Growth 10 Stock Price Growth 13.41%
Graham Price AEPS $30.00 $31.74 $30.52 $33.72 $34.79 $35.82 $37.93 $38.56 $35.72 $38.36 $38.76 $36.21 $35.35 $36.21 $36.83 14.10% <-Total Growth 10 Graham Price AEPS
Price/GP Ratio Med 1.41 1.42 1.63 1.65 1.68 1.67 1.47 1.54 1.62 1.58 1.68 1.59 1.44 1.63 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.50 1.53 1.78 1.75 1.82 1.75 1.59 1.69 1.82 1.75 1.90 1.81 1.58 1.76 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.32 1.31 1.49 1.54 1.54 1.60 1.34 1.38 1.42 1.41 1.45 1.38 1.30 1.44 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.42 1.45 1.75 1.59 1.67 1.69 1.42 1.56 1.52 1.73 1.53 1.44 1.30 1.26 1.24 1.57 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 42.09% 44.95% 74.56% 58.54% 66.81% 68.57% 42.20% 56.00% 52.36% 73.12% 53.49% 44.07% 29.54% 26.48% 24.37% 57.27% <-Median-> 10 Graham Price
Graham Price EPS $32.11 $29.25 $29.50 $31.76 $34.13 $34.31 $35.64 $37.84 $34.15 $37.13 $36.55 $30.52 $33.12 $36.22 $36.59 4.33% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 1.32 1.54 1.69 1.75 1.71 1.75 1.56 1.57 1.70 1.63 1.78 1.89 1.54 1.70 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.40 1.66 1.84 1.86 1.85 1.83 1.69 1.72 1.91 1.80 2.02 2.14 1.69 1.84 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.23 1.42 1.54 1.64 1.57 1.67 1.43 1.41 1.49 1.46 1.54 1.63 1.38 1.54 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.33 1.57 1.81 1.68 1.70 1.76 1.51 1.59 1.59 1.79 1.63 1.71 1.38 1.26 1.25 1.69 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 32.77% 57.26% 80.62% 68.35% 70.03% 75.99% 51.31% 58.98% 59.38% 78.81% 62.74% 70.95% 38.27% 26.46% 25.16% 69.19% <-Median-> 10 Graham Price
Comments
Comments
Pre-Split 1997
Pre-Nortel Split re Div
Closing Price $42.63 $46.00 $53.28 $53.46 $58.03 $60.38 $53.93 $60.16 $54.43 $66.40 $59.49 $52.17 $45.80 $45.80 $45.80 13.41% <-Total Growth 10 Stock Price
Increase 0.38% 7.91% 15.83% 0.34% 8.55% 4.05% -10.68% 11.55% -9.52% 21.99% -10.41% -12.30% -12.21% 0.00% 0.00% 16.49 <-Median-> 10 CAPE (10 Yr P/E)
P/E 12.58 18.11 17.94 17.94 17.43 19.41 17.40 17.85 19.72 22.21 19.96 22.88 17.05 14.26 13.97 -0.66% <-IRR #YR-> 5 Stock Price -3.26%
Trailing P/E 14.80 13.57 20.98 18.00 19.47 18.13 17.34 19.41 16.15 24.06 19.90 17.51 20.09 17.05 14.26 1.27% <-IRR #YR-> 10 Stock Price 13.41%
CAPE (10 Yr P/E) 12.99 13.32 13.58 14.04 14.69 16.40 16.22 16.57 17.25 17.97 19.74 17.47 15.48 15.36 15.39 5.81% <-IRR #YR-> 5 Price & Dividend 34.41%
Median 10, 5 Yrs D.  per yr 6.20% 6.47% % Tot Ret 83.03% 0.00% T P/E $18.77 $19.41 P/E:  $18.68 $19.96 7.46% <-IRR #YR-> 10 Price & Dividend 85.52%
Price 15 D.  per yr 7.37% % Tot Ret 59.62% CAPE Diff 3.42% 4.99% <-IRR #YR-> 15 Stock Price 107.60%
Price  20 D.  per yr 5.46% % Tot Ret 64.57% 3.00% <-IRR #YR-> 20 Stock Price 80.52%
Price  25 D.  per yr 3.63% % Tot Ret 97.66% 0.09% <-IRR #YR-> 25 Stock Price 2.20%
Price  30 D.  per yr 4.40% % Tot Ret 58.03% 3.18% <-IRR #YR-> 30 Stock Price 155.67%
Price  35 D.  per yr 4.02% % Tot Ret 54.47% 3.36% <-IRR #YR-> 35 Stock Price 218.46%
Price  40 D.  per yr 3.83% % Tot Ret 52.00% 3.53% <-IRR #YR-> 40 Stock Price
Price  45 D.  per yr 4.48% % Tot Ret 50.17% 4.45% <-IRR #YR-> 41 Stock Price
Price & Dividend 15 12.36% <-IRR #YR-> 15 Price & Dividend 272.55%
Price & Dividend 20 8.46% <-IRR #YR-> 20 Price & Dividend 246.44%
Price & Dividend 25 3.72% <-IRR #YR-> 25 Price & Dividend 105.65%
Price & Dividend 30 7.57% <-IRR #YR-> 30 Price & Dividend 424.65%
Price & Dividend 35 7.39% <-IRR #YR-> 35 Price & Dividend 565.40%
Price & Dividend 40 7.36% <-IRR #YR-> 40 Price & Dividend
Price & Dividend 45 8.92% <-IRR #YR-> 41 Price & Dividend
Price  5 -$53.93 $0.00 $0.00 $0.00 $0.00 $52.17 Price  5
Price 10 -$46.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.17 Price 10
Price & Dividend 5 -$53.93 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 5
Price & Dividend 10 -$46.00 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 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 $52.17 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 $52.17 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 $52.17 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 $52.17 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 $52.17 Price  35
Price  40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.17 Price  40
Price  45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.17 Price  45
Price & Dividend 15 $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 15
Price & Dividend 20 $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 20
Price & Dividend 25 $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 25
Price & Dividend 30 $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 30
Price & Dividend 35 $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 35
Price & Dividend 40 $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 40
Price & Dividend 45 $2.20 $2.32 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 45
Price H/L Median $42.27 $45.01 $49.79 $55.48 $58.32 $59.97 $55.63 $59.24 $57.98 $60.60 $65.06 $57.67 $50.94 28.12% <-Total Growth 10 Stock Price
Increase 9.82% 6.49% 10.62% 11.43% 5.11% 2.84% -7.24% 6.48% -2.12% 4.51% 7.37% -11.37% -11.66% 2.51% <-IRR #YR-> 10 Stock Price
P/E $12.47 $17.72 $16.76 $18.62 $17.51 $19.28 $17.95 $17.58 $21.01 $20.27 $21.83 $25.29 $18.97 0.72% <-IRR #YR-> 5 Stock Price
Trailing P/E $14.68 $13.28 $19.60 $18.68 $19.57 $18.01 $17.89 $19.11 $17.20 $21.95 $21.76 $19.35 $22.34 8.52% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 17.27 16.34 17.02 18.79 19.17 20.08 17.96 18.64 18.50 19.76 21.40 20.05 18.60 6.83% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 16.95 17.59 18.50 19.92 20.16 22.07 19.01 19.41 19.05 19.84 21.59 19.31 17.22 17.65 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 6.01% 6.11% % Tot Ret 70.57% 89.44% T P/E 19.23 19.35 P/E:  18.95 21.01 Count 35 Years of data
-$45.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $57.67
-$55.63 $0.00 $0.00 $0.00 $0.00 $57.67
-$45.01 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $61.49
-$55.63 $3.13 $3.29 $3.46 $3.64 $61.49
High Months Aug May Nov Feb Aug Apr Jan Oct Feb Sep  Apr May Jan
Pre-Split 1997
Pre-Nortel Split re Div
Price High $45.06 $48.43 $54.21 $58.97 $63.17 $62.70 $60.38 $65.06 $65.19 $66.95 $73.76 $65.45 $56.02 35.14% <-Total Growth 10 Stock Price
Increase 6.10% 7.48% 11.93% 8.78% 7.12% -0.74% -3.70% 7.75% 0.20% 2.70% 10.17% -11.27% -14.41% 3.06% <-IRR #YR-> 10 Stock Price
P/E $13.29 $19.07 $18.25 $19.79 $18.97 $20.16 $19.48 $19.31 $23.62 $22.39 $24.75 $28.71 $20.86 1.63% <-IRR #YR-> 5 Stock Price
Trailing P/E $15.65 $14.29 $21.34 $19.86 $21.20 $18.83 $19.41 $20.99 $19.34 $24.26 $24.67 $21.96 24.57 18.97 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 21.09 21.96 P/E:  19.97 23.62 28.23 P/E Ratio Historical High
-$48.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $65.45
-$60.38 $0.00 $0.00 $0.00 $0.00 $65.45
Low Months Apr Aug Feb Sep Jan Mar Oct Jan Mar Jan Oct Oct Mar
Pre-Split 1997
Pre-Nortel Split re Div
Price Low $39.47 $41.59 $45.37 $51.99 $53.46 $57.24 $50.88 $53.41 $50.77 $54.24 $56.36 $49.88 $45.86 19.93% <-Total Growth 10 Stock Price
Increase 14.41% 5.37% 9.09% 14.59% 2.83% 7.07% -11.11% 4.97% -4.94% 6.83% 3.91% -11.50% -8.06% 4.63% <-IRR #YR-> 10 Stock Price
P/E $11.64 $16.37 $15.28 $17.45 $16.05 $18.41 $16.41 $15.85 $18.39 $18.14 $18.91 $21.88 $17.07 0.29% <-IRR #YR-> 5 Stock Price
Trailing P/E $13.70 $12.27 $17.86 $17.51 $17.94 $17.19 $16.36 $17.23 $15.07 $19.65 $18.85 $16.74 $20.11 15.85 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 17.21 $17.19 P/E:  16.39 18.14 9.14 P/E Ratio Historical Low
16.21 P/E Ratio Historical Median
-$34.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $54.24 Count 36 Years of data
-$53.46 $0.00 $0.00 $0.00 $0.00 $54.24
Free Cash Flow MS $2,050 $2,910 $1,958 $2,113 $2,871 $3,324 $3,357 $3,970 $3,348 $1,089 $3,229 $3,182 $2,928 $3,674 $4,263 9.35% <-Total Growth 10 Free Cash Flow MS
Change 35.87% 15.78% 0.99% 18.26% -15.67% -67.47% 196.51% -1.46% -7.98% 25.48% 16.03% -1.07% <-IRR #YR-> 5 Free Cash Flow MS -5.21%
FCF/CF from Op Ratio 0.34 0.43 0.45 0.45 0.52 0.43 0.14 0.39 0.40 0.41 0.47 #DIV/0! 0.90% <-IRR #YR-> 10 Free Cash Flow MS 9.35%
Dividends paid $1,683 $1,795 $1,893 $2,167 $2,294 $2,511 $2,679 $2,819 $2,975 $2,975 $3,312 $3,486 $3,639 $3,765 $3,897 94.21% <-Total Growth 10 Dividends paid
Percentage paid 102.56% 79.90% 75.54% 79.80% 71.01% 88.86% 273.19% 102.57% 109.55% 124.28% 102.48% 91.42% $0.89 <-Median-> 9 Percentage paid
5 Year Coverage 79.76% 78.71% 92.52% 98.45% 105.05% 118.95% 121.81% 104.77% 5 Year Coverage
Dividend Coverage Ratio 0.98 1.25 1.32 1.25 1.41 1.13 0.37 0.97 0.91 0.80 0.98 1.09 1.13 <-Median-> 9 Dividend Coverage Ratio
5 Year of Coverage 1.25 1.27 1.08 1.02 0.95 0.84 0.82 0.95 5 Year of Coverage
-$3,357 $0 $0 $0 $0 $3,182
-$2,910 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,182
Free Cash Flow Mkt Scr $3,567 $3,818 $3,348 $2,995 $3,067 -100.00% <-Total Growth 4 Free Cash Flow Mkt Scr
Change 7.04% -12.31% -10.54% 2.40% -4.07% <-Median-> 4 Change
Free Cash Flow BCE  $1,670 $2,571 $2,744 $2,999 $3,226 $3,418 $3,567 $3,736 $3,348 $2,980 $3,067 $3,144 $2,928 $3,674 $4,263 22.29% <-Total Growth 10 Free Cash Flow BCE
Change 10.52% 53.95% 6.73% 9.29% 7.57% 5.95% 4.36% 4.74% -10.39% -10.99% 2.92% 2.51% -6.87% 25.48% 16.03% -2.49% <-IRR #YR-> 5 Free Cash Flow BCE -11.86%
FCF/CF from Op Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.48 0.50 0.43 0.37 0.37 0.00 0.00 0.00 #DIV/0! 2.03% <-IRR #YR-> 10 Free Cash Flow BCE 22.29%
Dividends paid $1,683 $1,795 $1,893 $2,167 $2,294 $2,511 $2,679 $2,819 $2,975 $2,975 $3,312 $3,486 $3,639 $3,765 $3,897 94.21% <-Total Growth 10 Dividends paid
Percentage paid 100.78% 69.82% 68.99% 72.26% 71.11% 73.46% 75.11% 75.46% 88.86% 99.83% 107.99% 110.88% 124.28% 102.48% 91.42% $0.75 <-Median-> 10 Percentage paid
5 Year Coverage 100.69% 86.89% 81.11% 78.80% 74.43% 71.27% 72.36% 73.59% 76.77% 81.88% 88.39% 95.65% 105.95% 108.76% 105.99% 5 Year Coverage
Dividend Coverage Ratio 0.99 1.43 1.45 1.38 1.41 1.36 1.33 1.33 1.13 1.00 0.93 0.90 0.80 0.98 1.09 1.33 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 0.99 1.15 1.23 1.27 1.34 1.40 1.38 1.36 1.30 1.22 1.13 1.05 0.94 0.92 0.94 5 Year of Coverage
-$3,567 $0 $0 $0 $0 $3,144
-$2,571 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,144
Free Cash Flow WSJ $2,872 $3,324 $3,413 $3,984 $3,552 $3,171 $3,232 $3,182 $2,928 $3,674 $4,263 10.79% <-Total Growth 7 Free Cash Flow WSJ
Change 15.74% 2.68% 16.73% -10.84% -10.73% 1.92% -1.55% -7.98% 25.48% 16.03% -1.39% <-IRR #YR-> 5 Free Cash Flow MS -6.77%
FCF/CF from Op Ratio 0.43 0.45 0.46 0.52 0.46 0.40 0.39 0.40 0.41 0.47 #DIV/0! 1.48% <-IRR #YR-> 7 Free Cash Flow MS #DIV/0!
Dividends paid $2,294 $2,511 $2,679 $2,819 $2,975 $2,975 $3,312 $3,486 $3,639 $3,765 $3,897 38.83% <-Total Growth 7 Dividends paid
Percentage paid 79.87% 75.54% 78.49% 70.76% 83.76% 93.82% 102.48% 109.55% 124.28% 102.48% 91.42% $0.82 <-Median-> 8 Percentage paid
5 Year Coverage 79.87% 77.55% 77.89% 75.80% 77.45% 80.02% 85.06% 90.92% 102.00% 106.12% 104.75% 5 Year Coverage
Dividend Coverage Ratio 1.25 1.32 1.27 1.41 1.19 1.07 0.98 0.91 0.80 0.98 1.09 1.22 <-Median-> 8 Dividend Coverage Ratio
5 Year of Coverage 1.25 1.29 1.28 1.32 1.29 1.25 1.18 1.10 0.98 0.94 0.95 5 Year of Coverage
-$3,413 $0 $0 $0 $0 $3,182
-$2,872 $0 $0 $0 $0 $0 $0 $3,182
Market Cap  $33,055 $35,691 $44,773 $46,276 $50,527 $54,402 $48,440 $54,379 $49,227 $60,359 $54,254 $47,593 $41,782 $41,782 $41,782 33.35% <-Total Growth 10 Market Cap
Diluted # of Shares in Millions 774.6 776.4 794.6 848.3 870.3 894.9 898.9 901.4 904.3 906.7 911.5 912.3 912.3 17.50% <-Total Growth 10 Diluted
Change 0.36% 0.23% 2.34% 6.76% 2.59% 2.83% 0.45% 0.28% 0.32% 0.27% 0.53% 0.09% 0.00% 0.49% <-Median-> 10 Change
Difference Diluted/Basic 0.0% -0.1% -0.1% -0.1% -0.1% -0.1% 0.0% -0.1% 0.0% 0.0% 0.0% 0.0% 0.0%
Average # of Shares in Millions 774.3 775.8 793.7 847.1 869.1 894.3 898.6 900.8 904.3 906.3 911.5 912.3 912.3 912.3 912.3 17.59% <-Total Growth 10 Basic
Change 0.38% 0.19% 2.31% 6.73% 2.60% 2.90% 0.48% 0.24% 0.39% 0.22% 0.57% 0.09% 0.00% 0.00% 0.00% 0.53% <-Median-> 10 Change
Difference Basic/Outstanding 0.1% 0.0% 5.9% 2.2% 0.2% 0.7% 0.0% 0.3% 0.0% 0.3% 0.1% 0.0% 0.0% 0.0% 0.0% 0.24% <-Median-> 10 Difference
# of Share in Millions 775.4 775.9 840.3 865.6 870.7 901.0 898.2 903.9 904.4 909.0 912.0 912.3 912.3 912.3 912.3 1.63% <-IRR #YR-> 10 Shares 17.58%
Increase -0.01% 0.07% 8.30% 3.01% 0.59% 3.48% -0.31% 0.64% 0.06% 0.51% 0.33% 0.03% 0.00% 0.00% 0.00% 0.31% <-IRR #YR-> 5 Shares 1.57%
CF fr Op $Millions $5,552 $6,476 $6,241 $6,274 $6,643 $7,358 $7,384 $7,598 $7,754 $8,008 $8,365 $7,946 $7,189 $7,846 22.70% <-Total Growth 10 Cash Flow
Increase 14.03% 16.64% -3.63% 0.53% 5.88% 10.76% 0.35% 2.90% 2.05% 3.28% 4.46% -5.01% -9.53% 9.14% SO, S Iss decrease
5 year Running Average $5,188 $5,301 $5,572 $5,882 $6,237 $6,598 $6,780 $7,051 $7,347 $7,620 $7,822 $7,934 $7,852 $7,871 49.67% <-Total Growth 10 CF 5 Yr Running
CFPS $7.16 $8.35 $7.43 $7.25 $7.63 $8.17 $8.22 $8.41 $8.57 $8.81 $9.17 $8.71 $7.88 $8.60 4.36% <-Total Growth 10 Cash Flow per Share
Increase 14.04% 16.57% -11.02% -2.41% 5.26% 7.04% 0.67% 2.25% 2.00% 2.75% 4.12% -5.04% -9.53% 9.14% 2.07% <-IRR #YR-> 10 Cash Flow 22.70%
5 year Running Average $6.66 $6.85 $7.10 $7.29 $7.56 $7.76 $7.74 $7.93 $8.20 $8.44 $8.64 $8.73 $8.63 $8.63 1.48% <-IRR #YR-> 5 Cash Flow 7.61%
P/CF on Med Price 5.90 5.39 6.70 7.65 7.64 7.34 6.77 7.05 6.76 6.88 7.09 6.62 6.46 0.00 0.43% <-IRR #YR-> 10 Cash Flow per Share 4.36%
P/CF on Closing Price 5.95 5.51 7.17 7.38 7.61 7.39 6.56 7.16 6.35 7.54 6.49 5.99 5.81 5.33 1.16% <-IRR #YR-> 5 Cash Flow per Share 5.95%
-16.52% Diff M/C 2.46% <-IRR #YR-> 10 CFPS 5 yr Running 27.47%
Excl.Working Capital CF $202 -$147 -$365 -$241 -$286 $1,160 $1,259 $1,755 $1,485 $1,621 $1,542 $2,472 $0 $0 2.45% <-IRR #YR-> 5 CFPS 5 yr Running 12.87%
CF fr Op $M WC $5,754 $6,329 $5,876 $6,033 $6,357 $8,518 $8,643 $9,353 $9,239 $9,629 $9,907 $10,418 $7,189 $7,846 64.61% <-Total Growth 10 Cash Flow less WC
Increase 12.93% 9.99% -7.16% 2.67% 5.37% 33.99% 1.47% 8.21% -1.22% 4.22% 2.89% 5.16% -31.00% 9.14% 5.11% <-IRR #YR-> 10 Cash Flow less WC 64.61%
5 year Running Average $5,121 $5,304 $5,517 $5,817 $6,070 $6,623 $7,085 $7,781 $8,422 $9,076 $9,354 $9,709 $9,276 $8,998 3.81% <-IRR #YR-> 5 Cash Flow less WC 20.54%
CFPS Excl. WC $7.42 $8.16 $6.99 $6.97 $7.30 $9.45 $9.62 $10.35 $10.22 $10.59 $10.86 $11.42 $7.88 $8.60 6.23% <-IRR #YR-> 10 CF less WC 5 Yr Run 83.07%
Increase 12.94% 9.92% -14.28% -0.33% 4.75% 29.49% 1.78% 7.53% -1.27% 3.69% 2.55% 5.12% -31.00% 9.14% 6.50% <-IRR #YR-> 5 CF less WC 5 Yr Run 37.03%
5 year Running Average $6.57 $6.85 $7.03 $7.22 $7.37 $7.77 $8.07 $8.74 $9.39 $10.05 $10.33 $10.69 $10.19 $9.87 3.42% <-IRR #YR-> 10 CFPS - Less WC 40.00%
P/CF on Med Price 5.70 5.52 7.12 7.96 7.99 6.34 5.78 5.72 5.68 5.72 5.99 5.05 6.46 0.00 3.48% <-IRR #YR-> 5 CFPS - Less WC 18.68%
P/CF on Closing Price 5.74 5.64 7.62 7.67 7.95 6.39 5.60 5.81 5.33 6.27 5.48 4.57 5.81 5.33 4.54% <-IRR #YR-> 10 CFPS 5 yr Running 55.92%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 6.96 5 yr  6.88 P/CF Med 10 yr 5.89 5 yr  5.72 -1.24% Diff M/C 5.79% <-IRR #YR-> 5 CFPS 5 yr Running 32.47%
Severance costs -$178
Acquisition and other costs -$8
Income taxes
Interest paid -$907 -$911 -$882 -$965 -$650 -$1,087 -$1,112 -$1,080 -$1,197 -$1,486
Income taxes paid (net of refunds) -$743 -$672 -$565 -$675 -$990 -$725 -$846 -$913 -$749 -$700
Net change in operating assets and liabilities $365 $241 $286 $480 $381 $57 $473 $372 $404 -$100
Sum -$1,285 -$1,342 -$1,161 -$1,160 -$1,259 -$1,755 -$1,485 -$1,621 -$1,542 -$2,472
Google -->Morningstar 2017 -$356 -$418 -$51 $480 -$1,259 -$1,755 -$1,485 -$1,621 -$1,542 -$2,472
Difference -$929 -$924 -$1,110 -$1,640 $0 $0 $0 $0 $0 $0
TD $1,285 $1,342 -$1,161 -$1,264 -$1,755 -$1,485 -$1,343 -$1,601
Difference -$2,570 -$2,684 $0 $104 $0 $0 -$278 $59
2024 2024 2024 2024
Morningstar says $147 $365 $241 $286 $480
OPM 27.79% 31.75% 29.66% 29.16% 30.59% 32.39% 31.46% 31.71% 33.89% 34.15% 34.60% 32.21% 28.81% 1.45% <-Total Growth 10 OPM
Increase 11.30% 14.21% -6.57% -1.68% 4.88% 5.89% -2.85% 0.77% 6.87% 0.78% 1.33% -6.93% -10.55% Should increase  or be stable.
Diff from Ave -13.0% -0.7% -7.2% -8.7% -4.3% 1.4% -1.5% -0.8% 6.0% 6.9% 8.3% 0.8% -9.8% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 31.96% 5 Yrs 33.89% should be  zero, it is a   check on calculations
$10,494 <-12 mths 0.74%
Adjusted EBITDA $8,089 $8,303 $8,551 $8,788 $9,178 $9,535 $10,106 $9,607 $9,893 $10,199 $10,417 $10,698 $10,999 $11,331 28.78% <-Total Growth 10 Adjusted EBITDA
Change 2.65% 2.99% 2.77% 4.44% 3.89% 5.99% -4.94% 2.98% 3.09% 2.14% 2.70% 2.81% 3.02% 2.98% <-Median-> 10 Change
Margin 39.65% 39.46% 39.75% 40.46% 40.40% 40.63% 42.17% 41.98% 42.19% 42.19% 42.22% 42.87% 43.25% 43.55% 41.31% <-Median-> 10 Margin
Long Term Debt $15,390 $16,572 $18,215 $19,760 $22,415 $23,906 $27,048 $27,783 $31,135 $31,135 Debt Type
Change 7.68% 9.91% 8.48% 13.44% 6.65% 13.14% 2.72% 12.06% 0.00% 9.20% <-Median-> 8 Change Lg Term R
Debt/Market Cap Ratio 0.33 0.33 0.33 0.41 0.41 0.49 0.45 0.51 0.65 0.75 0.41 <-Median-> 9 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 4.80 4.96 5.03 5.48 6.15 7.33 7.33 6.04 5.94 5.94 5.94 <-Median-> 9 Assets/Current Liab. Ratio Liquidity
Debt to Cash Flow (Years) 2.45 2.49 2.48 2.68 2.95 3.08 3.38 3.32 3.92 4.33 2.95 <-Median-> 9 Debt to Cash Flow (Years) Liq. + CF
Liq. + CF + D
Intangibles $8,087 $9,552 $10,224 $11,176 $11,989 $13,305 $13,205 $13,352 $13,102 $15,570 $16,183 $16,609 $16,609 73.88% <-Total Growth 10 Intangibles Debt Ratio
Goodwill $7,185 $8,381 $8,385 $8,377 $8,958 $10,428 $10,658 $10,607 $10,604 $10,572 $10,906 $10,942 $10,942 30.56% <-Total Growth 10 Goodwill Leverage
Total $15,272 $17,933 $18,609 $19,553 $20,947 $23,733 $23,863 $23,959 $23,706 $26,142 $27,089 $27,551 $27,551 53.63% <-Total Growth 10 Total D/E Ratio
Change 0.49% 17.42% 3.77% 5.07% 7.13% 13.30% 0.55% 0.40% -1.06% 10.28% 3.62% 1.71% 0.00% 3.70% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.46 0.50 0.42 0.42 0.41 0.44 0.49 0.44 0.48 0.43 0.50 0.58 0.66 0.44 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $3,911 $5,070 $4,548 $4,808 $4,855 $4,639 $5,793 $5,520 $5,688 $6,198 $6,487 $7,898 $7,898 Liquidity ratio of 1.5 and up, best
Current Liabilities $6,745 $7,890 $9,089 $9,992 $10,108 $10,787 $10,429 $9,777 $8,271 $9,113 $11,469 $12,107 $12,107 0.56 <-Median-> 10 Ratio
Liquidity Ratio 0.58 0.64 0.50 0.48 0.48 0.43 0.56 0.56 0.69 0.68 0.57 0.65 0.65 0.65 <-Median-> 5 Ratio
Liq. with CF aft div 1.15 1.24 0.96 0.89 0.91 0.88 1.01 1.05 1.27 1.21 1.01 1.02 0.95 1.05 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.72 0.68 0.69 0.63 0.62 0.57 0.71 0.74 0.89 0.69 0.68 0.70 0.95 0.70 <-Median-> 5 Ratio
Curr. Portion on Lg T. $2,136 $2,571 $3,743 $4,895 $4,887 $5,178 $4,645 $3,881 $2,417 $2,625 $4,137 $5,042 $5,042 $3,881 <-Median-> 5 Ratio
Liquidity Ratio 0.85 0.95 0.85 0.94 0.93 0.83 1.00 0.94 0.97 0.96 0.88 1.12 1.12 0.96 <-Median-> 5 Ratio
Liq. with CF aft div 1.68 1.83 1.64 1.74 1.75 1.68 1.82 1.74 1.79 1.71 1.57 1.75 1.62 1.74 <-Median-> 5 Ratio
Assets $40,968 $45,384 $46,297 $47,993 $50,108 $54,263 $57,100 $60,146 $60,665 $66,764 $69,329 $71,940 $71,940 Debt Ratio of 1.5 and up, best
Liabilities $26,243 $29,134 $31,058 $30,664 $32,254 $34,780 $36,411 $38,738 $39,336 $43,823 $46,814 $51,383 $51,383 1.55 <-Median-> 10 Ratio
Debt Ratio 1.56 1.56 1.49 1.57 1.55 1.56 1.57 1.55 1.54 1.52 1.48 1.40 1.40 1.52 <-Median-> 5 Ratio
Estimates BVPS $19.20 $22.00 $20.50 Estimates Estimates BVPS
Estimate Book Value $17,515.7 $20,070.0 $18,701.6 Estimates Estimate Book Value
P/B Ratio (Close) 2.39 2.08 2.23 Estimates P/B Ratio (Close)
Difference from 10 year median -9.57% Diff M/C Estimates Difference from 10 yr med.
Check $10,480 $16,250 $10,942 $13,019 $13,536 $15,156 $20,363 $21,074 $20,989 $22,635 $22,178 $20,229
Total Book Value $14,725 $16,250 $15,239 $17,329 $17,854 $19,483 $20,689 $21,408 $21,329 $22,941 $22,515 $20,557 $20,557 $20,557 $20,557 26.50% <-Total Growth 10 Total Book Value
Non-Controlling Int $850 $1,239 $293 $306 $314 $323 $326 $334 $340 $306 $337 $328 $328 $328 $328 -73.53% <-Total Growth 10 Non-Controlling Int
Net Book Value $15,011 $14,946 $17,023 $17,540 $19,160 $20,363 $21,074 $20,989 $22,635 $22,178 $20,229 $20,229 $20,229 $20,229 34.76% <-Total Growth 10 Net Book Value
BV per share $19.35 $17.79 $19.67 $20.14 $21.27 $22.67 $23.31 $23.21 $24.90 $24.32 $22.17 $22.17 $22.17 $22.17 14.61% <-Total Growth 10 BV per share
P/B Ratio (Median) 2.33 2.80 2.82 2.89 2.82 2.45 2.54 2.50 2.43 2.68 2.60 2.30 0.00 0.00 2.64 <-Median-> 10 P/B Ratio (Median)
Preferred Shares $3,395 $3,395 $4,004 $4,004 $4,004 $4,004 $4,004 $4,004 $4,003 $4,003 $4,003 $3,667 $3,667 8.01% <-Total Growth 10 Preferred Shares
Book Value $10,480 $11,616 $10,942 $13,019 $13,536 $15,156 $16,359 $17,070 $16,986 $18,632 $18,175 $16,562 $16,562 $16,562 $16,562 42.58% <-Total Growth 10 Book Value
BV per share $13.52 $14.97 $13.02 $15.04 $15.55 $16.82 $18.21 $18.88 $18.78 $20.50 $19.93 $18.15 $18.15 $18.15 $18.15 21.26% <-Total Growth 10 Book Value per Share
Change -1.71% 10.77% -13.03% 15.51% 3.36% 8.20% 8.27% 3.69% -0.55% 9.13% -2.77% -8.90% 0.00% 0.00% 0.00% -8.31% P/B Ratio Current/Historical Median
P/B Ratio (Median) 3.13 3.01 3.82 3.69 3.75 3.57 3.05 3.14 3.09 2.96 3.26 3.18 2.81 0.00 0.00 2.75 P/B Ratio Historical Median
P/B Ratio (Close) 3.15 3.07 4.09 3.55 3.73 3.59 2.96 3.19 2.90 3.24 2.99 2.87 2.52 2.52 2.52 1.95% <-IRR #YR-> 10 Book Value per Share 21.26%
Change 2.12% -2.58% 33.17% -13.13% 5.02% -3.84% -17.51% 7.58% -9.03% 11.78% -7.85% -3.73% -12.21% 0.00% 0.00% -0.06% <-IRR #YR-> 5 Book Value per Share -0.32%
Leverage (A/BK) 2.78 2.79 3.04 2.77 2.81 2.79 2.76 2.81 2.84 2.91 3.08 3.50 3.50 1.83 <-Median-> 10 A/BV
Debt/Equity Ratio 1.78 1.79 2.04 1.77 1.81 1.79 1.76 1.81 1.84 1.91 2.08 2.50 2.50 3.18 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.22 5 yr Med 3.14 -21.66% Diff M/C Historical
-$14.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.15
-$18.21 $0.00 $0.00 $0.00 $0.00 $18.15
Comprehensive Income $1,815 $3,446 $2,125 $3,183 $2,821 $2,659 $3,150 $3,486 $3,153 $4,763 $3,108 $1,979 -42.57% <-Total Growth 10 Comprehensive Income
NCI $201 $443 $126 $54 $54 $54 $49 $58 $64 $54 $65 $61 <-Total Growth 10 NCI
Preferred $139 $131 $137 $152 $137 $128 $144 $151 $136 $131 $152 $187 <-Total Growth 10 Preferred
Shareholders $1,475 $2,872 $1,862 $2,977 $2,630 $2,477 $2,957 $3,277 $2,953 $4,578 $2,891 $1,731 -39.73% <-Total Growth 10 Shareholders
Increase 2.29% 94.71% -35.17% 59.88% -11.66% -5.82% 19.38% 10.82% -9.89% 55.03% -36.85% -40.12% -9.89% <-Median-> 5 Comprehensive Income
5 Yr Running Average $1,555 $1,947 $1,961 $2,126 $2,363 $2,564 $2,581 $2,864 $2,859 $3,248 $3,331 $3,086 -4.94% <-IRR #YR-> 10 Comprehensive Income -39.73%
ROE 10.0% 17.7% 12.2% 17.2% 14.7% 12.7% 14.3% 15.3% 13.8% 20.0% 12.8% 8.4% -10.16% <-IRR #YR-> 5 Comprehensive Income -41.46%
5Yr Median 9.9% 10.0% 11.8% 12.2% 14.7% 14.7% 14.3% 14.7% 14.3% 14.3% 14.3% 13.8% 4.71% <-IRR #YR-> 10 5 Yr Running Average 58.50%
% Difference from Net Income -60.0% 3.9% -43.4% -11.5% -30.6% -30.8% -16.0% -14.0% -5.9% 37.3% -14.1% -32.8% 3.64% <-IRR #YR-> 5 5 Yr Running Average 19.58%
Median Values Diff 5, 10 yr -15.1% -14.0% 13.8% <-Median-> 5 Return on Equity
-$2,872 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,731
-$2,957 $0 $0 $0 $0 $1,731
-$1,947 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,086
-$2,581 $0 $0 $0 $0 $3,086
Current Liability Coverage Ratio 0.85 0.80 0.65 0.60 0.63 0.79 0.83 0.96 1.12 1.06 0.86 0.86 0.59   CFO / Current Liabilities
5 year Median 0.85 0.80 0.77 0.75 0.65 0.65 0.65 0.79 0.83 0.96 0.96 0.96 0.86 84.5% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 14.05% 13.95% 12.69% 12.57% 12.69% 15.70% 15.14% 15.55% 15.23% 14.42% 14.29% 14.48% 9.99% CFO / Total Assets
5 year Median 12.92% 12.92% 12.92% 12.92% 12.69% 12.69% 12.69% 15.14% 15.23% 15.23% 15.14% 14.48% 14.42% 14.5% <-Median-> 10 Return on Assets 
Return on Assets 6.40% 4.35% 5.10% 5.26% 5.74% 5.13% 4.88% 5.05% 4.12% 4.06% 3.92% 2.89% 3.37% Net  Income/Assets Return on Assets
5Yr Median 5.51% 5.51% 5.51% 5.26% 5.26% 5.13% 5.13% 5.13% 5.05% 4.88% 4.12% 4.06% 3.92% 5.0% <-Median-> 10 Asset Efficiency Ratio
ROE 25.04% 17.00% 21.60% 19.40% 21.23% 18.38% 17.02% 17.81% 14.71% 14.54% 14.94% 12.53% 14.64% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 15.00% 17.00% 20.83% 20.83% 21.23% 19.40% 19.40% 18.38% 17.81% 17.02% 14.94% 14.71% 14.64% 17.4% <-Median-> 10 Return on Equity
$1,843 <-12 mths -11.24% Estimates last 12 months from Qtr.
Net Income $3,053 $2,388 $2,718 $2,730 $3,067 $2,970 $2,973 $3,253 $2,699 $2,892 $2,926 $2,327 -2.55% <-Total Growth 10 Net Income
NCI $290 $282 $218 $52 $56 $56 $44 $62 $65 $52 $58 $64 NCI
Preferred $139 $131 $137 $152 $137 $128 $144 $151 $136 $131 $152 $187 42.75% <-Total Growth 10 Preferred
Shareholders $2,624 $1,975 $2,363 $2,526 $2,874 $2,786 $2,785 $3,040 $2,498 $2,709 $2,716 $2,076 $2,424 $2,902 $2,988 5.11% <-Total Growth 10 Shareholders
Increase 18.14% -24.73% 19.65% 6.90% 13.78% -3.06% -0.04% 9.16% -17.83% 8.45% 0.26% -23.56% 16.76% 19.72% 2.96% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $1,917 $2,123 $2,270 $2,342 $2,472 $2,505 $2,667 $2,802 $2,797 $2,764 $2,750 $2,608 $2,485 $2,565 $2,621 0.50% <-IRR #YR-> 10 Net Income 5.11%
Operating Cash Flow $5,552 $6,476 $6,241 $6,274 $6,643 $7,358 $7,384 $7,598 $7,754 $8,008 $8,365 $7,946 -5.71% <-IRR #YR-> 5 Net Income -25.46%
Investment Cash Flow -$4,093 -$6,401 -$3,570 -$4,114 -$4,584 -$5,737 -$4,386 -$4,036 -$3,540 -$7,003 -$5,517 -$5,517 2.08% <-IRR #YR-> 10 5 Yr Running Ave. 22.82%
Total Accruals $1,165 $1,900 -$308 $366 $815 $1,165 -$213 -$522 -$1,716 $1,704 -$132 -$353 -0.45% <-IRR #YR-> 5 5 Yr Running Ave. -2.21%
Total Assets $40,968 $45,384 $46,297 $47,993 $50,108 $54,263 $57,100 $60,146 $60,665 $66,764 $69,329 $71,940 Balance Sheet Assets
Accruals Ratio 2.84% 4.19% -0.67% 0.76% 1.63% 2.15% -0.37% -0.87% -2.83% 2.55% -0.19% -0.49% -0.49% <-Median-> 5 Ratio
EPS/CF Ratio 0.46 0.31 0.42 0.43 0.46 0.33 0.32 0.33 0.27 0.28 0.27 0.20 0.32 <-Median-> 10 EPS/CF Ratio
-$1,975 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,076
-$2,785 $0 $0 $0 $0 $2,076
-$2,123 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,608
-$2,667 $0 $0 $0 $0 $2,608
Change in Close 0.38% 7.91% 15.83% 0.34% 8.55% 4.05% -10.68% 11.55% -9.52% 21.99% -10.41% -12.30% -12.21% 0.00% 0.00% Count 32 Years of data
up/down Count 7 21.88%
Meet Prediction? % right Count 1 14.29%
Financial Cash Flow -$1,507 $131 -$2,440 -$2,113 -$1,819 -$2,149 -$3,198 -$4,302 -$4,302 -$1,022 -$2,988 -$1,542 C F Statement  Financial CF
Total Accruals $2,672 $1,769 $2,132 $2,479 $2,634 $3,314 $2,985 $3,780 $2,586 $2,726 $2,856 $1,189 Accruals
Accruals Ratio 6.52% 3.90% 4.61% 5.17% 5.26% 6.11% 5.23% 6.28% 4.26% 4.08% 4.12% 1.65% 4.12% <-Median-> 5 Ratio
Cash $117 $115 $142 $100 $250 $442 $425 $141 $141 $207 $99 $225 $225 Cash
Cash Per Share $0.15 $0.15 $0.17 $0.12 $0.29 $0.49 $0.47 $0.16 $0.16 $0.23 $0.11 $0.25 $0.25 $0.16 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.35% 0.32% 0.32% 0.22% 0.49% 0.81% 0.88% 0.26% 0.29% 0.34% 0.18% 0.47% 0.54% 0.29% <-Median-> 5 % of Stock Price
Moved the following from further up and above the current section on stock prices.  I do not think I need this anymore, but I do not like distroying data.
Price Close re TD $42.63 $46.00 $53.28 $53.46 $58.03 $60.38 $53.93 $60.16 $54.43 $66.40 $59.49 $52.17 13.41% <-Total Growth 10 Stock Price
Median 10, 5 Yrs D.  per yr 6.20% 6.47% % Tot Ret 83.03% 111.38% T P/E $18.77 $19.41 P/E:  $18.68 $19.96 $21.09 -100.00% Diff M/C 7.46% <-IRR #YR-> 10 Price & Dividend
Price 15 4.99% <-IRR #YR-> 15 Stock Price
Price  20 3.00% <-IRR #YR-> 20 Stock Price
Price  25 5.25% <-IRR #YR-> 25 Stock Price
Price  30 7.68% <-IRR #YR-> 30 Stock Price
Price  35 7.39% <-IRR #YR-> 35 Stock Price
Price  40 6.85% <-IRR #YR-> 40 Stock Price
Price & Dividend 15 14.34% <-IRR #YR-> 15 Price & Dividend
Price & Dividend 20 10.08% <-IRR #YR-> 20 Price & Dividend
Price & Dividend 25 18.72% <-IRR #YR-> 25 Price & Dividend
Price & Dividend 30 29.96% <-IRR #YR-> 30 Price & Dividend
Price & Dividend 35 19.08% <-IRR #YR-> 35 Price & Dividend
Price & Dividend 40 14.69% <-IRR #YR-> 40 Price & Dividend
Price  5 -$53.93 $0.00 $0.00 $0.00 $0.00 $52.17 Price  5
Price 10 -$46.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.17 Price 10
Price & Dividend 5 -$53.93 $3.13 $3.29 $3.46 $3.64 $55.99 Price & Dividend 5
Price & Dividend 10 -$46.00 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $55.99 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 $52.17 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 $52.17 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 $52.17 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 $52.17 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 $52.17 Price  35
Price  40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.17 Price  40
Price & Dividend 15 $3.18 $3.05 $4.42 $3.42 $3.78 $3.55 $2.79 $3.26 $2.81 $3.36 $2.91 $55.01 Price & Dividend 15
Price & Dividend 20 $3.18 $3.05 $4.42 $3.42 $3.78 $3.55 $2.79 $3.26 $2.81 $3.36 $2.91 $55.01 Price & Dividend 20
Price & Dividend 25 $3.18 $3.05 $4.42 $3.42 $3.78 $3.55 $2.79 $3.26 $2.81 $3.36 $2.91 $55.01 Price & Dividend 25
Price & Dividend 30 $3.18 $3.05 $4.42 $3.42 $3.78 $3.55 $2.79 $3.26 $2.81 $3.36 $2.91 $55.01 Price & Dividend 30
Price & Dividend 35 $3.18 $3.05 $4.42 $3.42 $3.78 $3.55 $2.79 $3.26 $2.81 $3.36 $2.91 $55.01 Price & Dividend 35
Price & Dividend 40 $3.18 $3.05 $4.42 $3.42 $3.78 $3.55 $2.79 $3.26 $2.81 $3.36 $2.91 $55.01 Price & Dividend 40
Price H/L Median $42.27 $45.01 $49.79 $55.48 $58.32 $59.97 $55.63 $59.24 $57.98 $60.60 $65.06 $57.67 $50.94 28.12% <-Total Growth 10 Stock Price
Median 10, 5 Yrs D.  per yr 6.01% 6.11% % Tot Ret 70.57% 89.44% T P/E 19.23 19.35 P/E:  18.95 21.01 Count 43 Years of data
-$45.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $57.67
-$55.63 $0.00 $0.00 $0.00 $0.00 $57.67
-$45.01 $2.44 $2.57 $2.70 $2.84 $2.98 $3.13 $3.29 $3.46 $3.64 $61.49
-$55.63 $3.13 $3.29 $3.46 $3.64 $61.49
Price high with Nortel
Split 1997
High Months Aug May Nov Feb Aug Mar Oct Jan Mar Jan Oct Oct Mar
Price High $45.06 $48.43 $54.21 $58.97 $63.17 $62.70 $60.38 $65.06 $65.19 $66.95 $73.76 $65.45 $56.02 35.14% <-Total Growth 10 Stock Price
Median 10, 5 Yrs Price Inc 2.70% P/E:  19.97 23.62 21.95 P/E Ratio Historical High
-$48.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $65.45
-$60.38 $0.00 $0.00 $0.00 $0.00 $65.45
No Nortel
Price Low
Low Months Apr Aug Feb Sep Jan Mar Oct Jan Mar Jan Oct Oct Mar
Price Low $39.47 $41.59 $45.37 $51.99 $53.46 $57.24 $50.88 $53.41 $50.77 $54.24 $56.36 $49.88 $45.86 19.93% <-Total Growth 10 Stock Price
Median 10, 5 Yrs Price Inc 3.91% P/E:  17.79 18.39 5.94 P/E Ratio Historical Low
-$41.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $49.88
-$50.88 $0.00 $0.00 $0.00 $0.00 $49.88
Notes:
March 24, 2024.  Last estimates were for 2023, 2024 and 2025 of $24792M, $25400M and $26215M for Revenue, $3.20, $3.45 and $3.82 for AEPS, $3.25, $3.61 and $3.91 for EPS, 
$3.85, $4.03 and $4.18 for Dividends, $3271M, $3734M and $4568M for FCF, $9.20 and $9.24 2023/4 for CFPS, $21.60, $22.00 and $20.50 for BVPS, $2951M, $3173M and $3532M for Net Income.
March 26, 2023.  Last estimates were for 2022, 2023 and 2024 of $24211M, $24822M and $25481M for Revenue, $3.37, $3.58, $3.68 for AEPS, $3.27, $3.49 and $3.79 for EPS, 
$3.68 $3.86 and $4.06 for Dividends, $3143M, $3903M and $4700M for FCR, $9.11, $9.24 and $9.72 for CFPS, $22.20, $22.90 and $23.70 for BVPS, and $2951M, $3144M and $3450M for Net Income.
March 26, 2022.  Last estimates were for 2021, 2022 and 2023 of $23651M, $24349M and $24948M for Revenue, $3.10, $3.68 and $3.86 for EPS, 
$3.50, $3.68 and $3.86 for Dividends, $3164M, $3715M and $4409M for FCF, $8.70, $8.95 and $9.19 for CFPS and $2789M, $2955M and $3078M for Net Income.
March 26, 2021.  Last estimates were for 2020, 2021 and 2022 of $24372M, $24810M and $25346M for Revenue, $3.47, $3.65 and $3.72 for EPS, 
$3.33, $3.48 an $3.65 for Dividends, $4097M $4281M and $5409M for FCF, $9.04 and $9.15 for CFPS for 2020 and 2021 and $3094M, $3228M and $3366M for Net Income.
March 21, 2020.  Last estimates were for 2019, 2020 and 2021 of $23956M, $24430M and $24969M for Revenue, 
$3.34, $3.60 and $3.94 for EPS, $8.69, $8.96 and $9.17 for CFPS, $2988M and $3075M for 2019 and 2020 for Net Income.
March 26, 2019.  Last estimates were for 2018, 2019 and 2020 of $23371M, $23819M, and $24552M, $3.46, $3.66 and $3.72 for EPS, 
$8.39, $8.48 and $8.95 for CFPS and $3081M, $3237M and $3330M for Net Income.
Maybe check Total Return against my Total Return to see if I have this spreadsheet updated correctly.
March 24, 2018. Last estimates were for 2017, 2018 and 2019 of $22695M, $23063M and $23187M for Revenue, 
$3.46, $3.63 and $3.86 for EPS, $8.30, $8.67 and $8.64 for CFPS, $3097M, $3334M and $3456M for Net Income.
March 24, 2017.  Last estimates were for 2016, 2017 amd 2018 of $21951M, $22265M and $22594M for Revenue, 
$3.40, $3.50 and $3.82 for EPS, $7.91, $7.99 and $8.24 for CFPS and $2906M, $3022M and $3477M for Net Income.
March 27, 2015.  Last estimates were for 2015, 2016 and 2017 of $21483M, $21887M and $22336M for Revenue, 
$3.22, $3.51 and $3.64 for EPS, $7.49, $7.89 and $7.95 for CFPS and $2697M and $3006M and $3114M for Net Income.
March 23, 2014.  Last estimates were for 2013 and 2014 for $20201M and $20337M for Revenue, $3.10 and $3.22 EPS.
Febr 18, 2013.  Last estimates were for 2012 and 2013 of $20193M and $20756M for Revenue and $3.16, $3.25 and $3.43 (2014) for EPS and $7.79 and $8.13 for CFPS.
Mar 25, 2012.  Last estimates were for 2011 and 2012 and wer $2.96 and $3.07 for EPS and $7.59 and $7.66 for CF.
Apr 10, 2011.  I last got estimates for 2010 and 2011 of $2.68 and $2.71 for earnings and $7.13 and $7.39 for cash flow. The problem is that company keeps restating their financials.
Feb 2010 Unadited Report. When I looked at this in July 2009, I got for 2009 and 2010 earnings of $2.40 & $2.42, and cash flow of $6.37 and $7.03. Earnings for 2009 were $2.11 or $2.50 if other 
charges are included. Cash Flow came in as $6.20.
Jul 17, 2009.  when I looked at this in Feb 2009, I got earnings estimates for 2009 and 2010 of $2.35 and $2.36. New estimates up a bit.  I got OCF of $6.37 and $7.03 for these years. Keeping current Estimates.
Finally got the annual report and I have updated my spreadsheet.
2009 Feb.  Analysts still have a buy rating on this stock.
2008 AP.  They have put out statements for the end of 2008, but they are not typical statements.  It is hard to get the figures I need.  For example, they have no proper cash flow statement.
2008.  Stock is not being bought.
2007 AP. Stock is being bought out. Not done yet.
2005 AP.  NEED TO SELL?
I have had BCE for a long time.  Since the early 1980's.  Considering all, I think that I have had an IRR of almost 15% since 1987.
I will hold on to this stock for now.  I am hoping it will sort itself out again.
AP  2004. Not doing great. However BCE Earnings estimates for 2005 and 2006 are 2.15 and 2.32.  I have sold 1/2 of my stock and hold $15,000 still.  Keep eye on. 
May 2003. When looking for stock to buy, this stocks P/E at 12.7 is too high historically.  Stock has other problems too. 
Sector:
Telecom Service, Utility
What should this stock accomplish?
Would I buy this company and Why.
It is a dividend growth company and therefore should be considered for buying if one is looking for a Telecom.   I currently not too keen on Telecom Services companies because their might be a big fall at at some point in 
Canada.  Our rates are very high for cable, interenet and phone. Certainly cable and internet should not be separate service even now.
Why am I following this stock. 
I bought this stock in 1982 and have held it ever since.  Since I bought it both Nortel and Bell Aliant were spin off.  
The problem with BCE's spinning off part of the company was that I ended up with an odd number of shares.  It is annoying.
Why I bought this stock.
This is one of first stocks I bought, which was in 1982.  At that time, it was called an orphan and widow stock.
It is not easy to figure out what I have earned on this stock because it has spun off shares for Nortel and Bell Aliant.  
The annoying thing with their spin offs is you always end up with an odd number of shares.
In 2016 I sold Manitoba Telecom.  To keep the same in Telecom category, I bought some more BCE with the proceeds.
Dividends
Dividends are paid quarterly in cycle 1.  Payments are therefore made in January, April, July and October. Dfividends are declared in one month for shareholders of the following month and paid in the next month.
For example, the dividend declared onNovember 06, 2013 for shareholders of record of December 16, 2013 was payable on January 15, 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.
For customers 
For employees 
For community 
For investors 
How they make their money.
BCE provides wireless, broadband, television, and landline phone services in Canada. It is one of the big three national wireless carriers, 
with over 10 million customers constituting about 30% of the market.
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.
Copyright © 2008 Website of SPBrunner. All rights reserved.
Shares; '%, Value $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 Mar 24 2017 Mar 24 2018 Mar 26 2019 Mar 21 2020 Mar 26 2021 Mar 26 2022 Mar 26 2023 Mar 24 2024
Bibic, Mirko 0.001 0.00% 0.004 0.00% 0.022 0.00% 0.019 0.00% 0.042 0.00% 0.086 0.01% Was officer before CEO '20 103.88%
CEO - Shares - Amount $0.080 $0.210 $1.173 $1.126 $2.197 $0.000
Options - percentage 0.761 0.08% 1.166 0.13% 1.249 0.14% 1.186 0.13% 1.291 0.14% 1.374 0.15% 6.45%
Options - amount $45.781 $63.472 $67.966 $70.549 $67.338 $0.000
Millen, Curtis 0.009 0.00% #DIV/0!
CFO - Shares - Amount $0.000
Options - percentage 0.129 0.01% #DIV/0!
Options - amount $0.000
LeBlanc, Glen 0.002 0.00% 0.010 0.00% 0.004 0.00% 0.005 0.00% 0.004 0.00% 0.003 0.00% 0.008 0.00% 0.004 0.00% -47.62%
CFO - Shares - Amount $0.127 $0.546 $0.254 $0.277 $0.235 $0.182 $0.411 $0.000
Options - percentage 0.415 0.05% 0.537 0.06% 0.625 0.07% 0.624 0.07% 0.657 0.07% 0.590 0.06% 0.638 0.07% 0.638 0.07% 0.00%
Options - amount $25.040 $28.983 $37.591 $33.980 $35.736 $35.125 $33.284 $0.000
Gillies, Claire 0.002 0.00% 0.010 0.00% Ceased insider Aug 2023
Officer - Shares - Amount $0.148 $0.515
Options - percentage 0.162 0.02% 0.182 0.02%
Options - amount $9.633 $9.519
Kirby, Blaik 0.039 0.00% 0.060 0.01% 53.63%
Officer - Shares - Amount $2.033 $0.000
Options - percentage 0.534 0.06% 0.557 0.06% 4.38%
Options - amount $27.839 $0.000
Howe, Stephen Guy 0.090 0.01% 0.103 0.01% Subsidiary Executive 14.29%
Officer - Shares - Amount $4.686 $0.000
Options - percentage 0.520 0.06% 0.563 0.06% 8.21%
Options - amount $27.139 $0.000
Denison, David Francis 0.001 0.00% 0.001 0.00% 0.001 0.00% 0.001 0.00% 6.51%
Director - Shares - Amount $0.068 $0.078 $0.072 $0.000
Options - percentage 0.039 0.00% 0.047 0.01% 0.058 0.01% 0.063 0.01% 9.26%
Options - amount $2.141 $2.797 $3.027 $0.000
Dexter, Robert P. 0.008 0.00% 0.008 0.00% 0.00%
Director - Shares - Amount $0.393 $0.000
Options - percentage 0.066 0.01% 0.072 0.01% 8.68%
Options - amount $3.433 $0.000
Nixon, Gordon Melbourne 0.020 0.00% 0.020 0.00% 0.020 0.00% 0.020 0.00% 0.020 0.00% 0.020 0.00% 0.020 0.00% 0.020 0.00% 0.00%
Chairman - Shares - Amt $1.208 $1.079 $1.203 $1.089 $1.089 $1.190 $1.043 $0.000
Options - percentage 0.011 0.00% 0.018 0.00% 0.028 0.00% 0.036 0.00% 0.044 0.00% 0.057 0.01% 0.075 0.01% 0.083 0.01% 10.26%
Options - amount $0.642 $0.992 $1.669 $1.970 $2.418 $3.376 $3.906 $0.000
Increase in O/S Shares 2.237 0.26% 2.556 0.28% 0.267 0.03% 4.476 0.50% 0.507 0.06% 4.604 0.51% 2.964 0.33% 0.307 0.03%
due to SO  $129.807 $154.323 $14.396 $269.293 $27.587 $250.588 $176.328 $16.016
Book Value $104.000 $122.000 $1.300 $252.000 $27.000 $272.000 $178.000 $19.000
Insider Buying -$0.306 -$0.178 -$0.266 -$0.101 -$0.059 -$0.144 -$1.089 -$2.105
Insider Selling $30.262 $3.055 $8.879 $83.495 $2.938 $37.665 $5.845 $0.344
Net Insider Selling $29.957 $2.877 $8.612 $83.395 $2.879 $37.521 $4.756 -$1.761
% of Market Cap 0.06% 0.01% 0.02% 0.17% 0.00% 0.07% 0.01% 0.00%
Directors 14 14 14 14 16 13 13 15
Women 3 21% 4 29% 4 29% 4 29% 4 25% 5 38% 5 38% 5 33%
Minorities 1 7% 1 7% 1 7% 1 7% 1 6% 2 15% 2 15% 2 13%
Institutions/Holdings 43.19% 520 45.80% 538 44.75% 20 36.05% 20 44.85% 20 40.06% 20 35.39% 20 34.51%
Total Shares Held 385.540 42.79% 411.703 45.84% 402.108 44.77% 324.442 35.87% 405.605 44.62% 364.181 39.93% 322.756 35.38% 314.839 34.51%
Increase/Decrease -4.570 -1.17% 6.464 1.60% 12.179 3.12% 17.486 5.70% 3.827 0.95% -4.692 -1.27% -15.943 -4.71% 0.758 0.24%
Starting No. of Shares 390.109 NASDAQ 405.239 NASDAQ 389.928 NASDAQ 306.956 Top 20 MS 401.778 Top 20 MS 368.873 Top 20 MS 338.699 Top 20 MS 314.082 Top 20 MS
Institutions/Holdings 787 721 0.00% 1,119 337.82%
Value $166,299.2
Total Shares Held 429.000 47.61% 443.000 49.32% 619.000 68.92%
Value $23,891.0 $37,239.0
Increase/Decrease -7.000 -1.61% 14.000 3.26% 22.000 3.69%
Starting No. of Shares 436.000 Morningstar 429.000 Morningstar 597.000 Morningstar
My Stock