This report is for educational purposes only, and not to provide investment advice. Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
BCE Inc. TSX: BCE NYSE BCE www.bce.ca Fiscal Yr: Dec-31
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
11-Jul-06
comments comments
comments comments
Revenue* $19,105 $17,713 $17,866 $17,698 $17,735 $18,069 $19,497 $19,975 $20,400 $21,042 $21,514 $21,719 $22,695 $23,063 $23,187 22.62% <-Total Growth 10 Revenue
Increase -0.46% -7.29% 0.86% -0.94% 0.21% 1.88% 7.90% 2.45% 2.13% 3.15% 2.24% 0.95% 4.49% 1.62% 0.54% 2.06% <-IRR #YR-> 10 Revenue 22.62%
5 year Running Average $18,946 $18,730 $18,523 $18,315 $18,023 $17,816 $18,173 $18,595 $19,135 $19,797 $20,486 $20,930 $21,474 $22,007 $22,436 2.18% <-IRR #YR-> 5 Revenue 11.40%
Revenue per Share $20.60 $21.93 $22.19 $22.04 $22.50 $24.02 $25.14 $25.76 $26.29 $25.04 $24.85 $24.94 $26.07 $26.49 $26.63 1.12% <-IRR #YR-> 10 5 yr Running Average 11.75%
Increase -0.61% 6.45% 1.16% -0.67% 2.08% 6.76% 4.68% 2.46% 2.06% -4.76% -0.74% 0.36% 4.49% 1.62% 0.54% 2.87% <-IRR #YR-> 5 5 yr Running Average 15.17%
5 year Running Average $21.10 $20.84 $21.15 $21.50 $21.85 $22.53 $23.18 $23.89 $24.74 $25.25 $25.42 $25.38 $25.44 $25.48 $25.80 1.30% <-IRR #YR-> 10 Revenue per Share 13.74%
P/S (Price/Sales) Med 1.44 1.02 1.59 1.39 1.16 1.32 1.53 1.64 1.71 1.99 2.23 2.34 -0.16% <-IRR #YR-> 5 Revenue per Share -0.79%
P/S (Price/Sales) Close 1.35 1.10 1.79 1.14 1.29 1.47 1.69 1.65 1.75 2.13 2.15 2.33 2.26 2.22 2.21 1.99% <-IRR #YR-> 10 5 yr Running Average 21.80%
* Operating Revenue in M CDN $ P/S Med 10 yr 1.62 5 yr 1.99 39.77% Diff M/C 1.83% <-IRR #YR-> 5 5 yr Running Average 9.50%
-$17,713 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21,719
-$19,497 $0 $0 $0 $0 $21,719
-$18,730 $0 $0 $0 $0 $0 $0 $0 $0 $0 $20,930
-$18,173 $0 $0 $0 $0 $20,930
-$21.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24.94
-$25.14 $0.00 $0.00 $0.00 $0.00 $24.94
US GAAP
before split
Nortel
With Nortel
EPS Basic $2.04 $2.25 $4.88 $1.02 $2.11 $2.85 $2.88 $3.39 $2.55 $2.98 $2.98 $3.33 48.00% <-Total Growth 10 EPS Basic
EPS Diluted* $2.04 $2.25 $4.87 $1.01 $2.11 $2.85 $2.88 $3.39 $2.54 $2.97 $2.98 $3.33 $3.46 $3.63 $3.86 48.00% <-Total Growth 10 EPS Diluted
Increase 23.64% 10.29% 116.44% -79.26% 108.91% 35.07% 1.05% 17.71% -25.07% 16.93% 0.34% 11.74% 3.90% 4.91% 6.34% 4.00% <-IRR #YR-> 10 Earnings per Share 48.00%
Earnings Yield 7.4% 9.3% 12.3% 4.0% 7.3% 8.1% 6.8% 8.0% 5.5% 5.6% 5.6% 5.7% 5.9% 6.2% 6.6% 2.95% <-IRR #YR-> 5 Earnings per Share 15.63%
5 year Running Average $1.73 $2.09 $2.54 $2.36 $2.46 $2.62 $2.74 $2.45 $2.75 $2.93 $2.95 $3.04 $3.06 $3.27 $3.45 3.82% <-IRR #YR-> 10 5 yr Running Average 45.55%
10 year Running Average $2.49 $2.61 $3.25 $3.14 $2.59 $2.18 $2.42 $2.49 $2.56 $2.69 $2.79 $2.89 $2.75 $3.01 $3.19 2.08% <-IRR #YR-> 5 5 yr Running Average 10.86%
* ESP per share (Cdn GAAP) E/P 10 Yrs 6.26% 5Yrs 5.57%
-$2.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.33
-$2.88 $0.00 $0.00 $0.00 $0.00 $3.33
-$2.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.04
-$2.74 $0.00 $0.00 $0.00 $0.00 $3.04
Act Div '08
Nortel
No Nortel
from state.
$1.46
Div I received
Increase
Split of 1997 $0.00 $0.00 $0.00
Nortel Spin off
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
Dividend* $1.32 $1.32 $1.46 $0.73 $1.58 $1.73 $2.05 $2.20 $2.32 $2.44 $2.57 $2.70 $2.87 $2.87 $2.87 Count 35 Years of data
Increase 10.00% 0.00% 10.61% 0.00% 8.22% 9.65% 18.04% 7.33% 5.47% 5.18% 5.44% 5.06% 6.39% 0.00% 0.00% 6.40% <-Median-> 10 Increase
Dividends 5 Yr Running $1.22 $1.25 $1.30 $1.21 $1.28 $1.36 $1.51 $1.66 $1.97 $2.14 $2.31 $2.44 $2.58 $2.69 $2.78 95.67% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 4.46% 5.89% 4.13% 2.38% 6.04% 5.45% 5.31% 5.19% 5.14% 4.89% 4.63% 4.63% 4.94% 5.02% <-Median-> 10 Yield H/L Price
Yield on High Price 4.03% 5.23% 3.51% 1.81% 5.45% 4.82% 4.82% 4.87% 4.78% 4.49% 4.35% 4.27% 4.87% 4.64% <-Median-> 10 Yield on High Price
Yield on Low Price 4.99% 6.75% 5.01% 3.44% 6.77% 6.27% 5.93% 5.56% 5.57% 5.37% 4.94% 5.05% 5.01% 5.46% <-Median-> 10 Yield on Low Price
Yield on Close Price 4.76% 5.48% 3.68% 2.90% 5.45% 4.90% 4.82% 5.15% 5.03% 4.57% 4.80% 4.65% 4.87% 4.87% 4.87% 4.81% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 64.71% 58.67% 29.98% 72.28% 74.88% 60.79% 71.01% 64.75% 91.14% 81.99% 86.16% 81.01% 82.95% 79.06% 74.35% 73.58% <-Median-> 10 DPR EPS Co. aim is 65% to 75%
DPR EPS 5 Yr Running 70.67% 59.71% 51.18% 51.02% 52.20% 52.12% 55.01% 67.67% 71.66% 73.29% 78.30% 80.28% 84.33% 82.10% 80.39% 61.34% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 22.02% 19.78% 20.61% 9.92% 25.50% 27.59% 32.57% 30.65% 27.74% 14.76% 15.56% 16.35% 34.58% 33.10% 33.22% 23.06% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 21.53% 20.86% 20.17% 18.23% 19.24% 20.31% 22.73% 24.89% 28.80% 24.06% 21.10% 18.78% 19.48% 20.22% 23.67% 20.70% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 23.53% 18.87% 22.14% 10.82% 25.90% 28.76% 31.12% 29.58% 26.22% 31.02% 33.21% 35.09% 34.58% 33.10% 33.22% 29.17% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 22.01% 20.90% 20.97% 18.92% 20.00% 21.02% 23.56% 25.21% 28.24% 29.22% 30.10% 30.90% 31.90% 33.40% 33.82% 24.38% <-Median-> 2 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 4.89% 4.80% 5 Yr Med Payout 81.99% 16.35% 31.02% 7.41% <-IRR #YR-> 10 Dividends 104.36%
* Dividends per share 5 Yr Med and Cur. -0.38% 1.44% Last Div Inc ---> $0.6825 $0.7175 5.1% 5.69% <-IRR #YR-> 5 Dividends 31.91%
-$1.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.70
-$2.05 $0.00 $0.00 $0.00 $0.00 $2.70
Historical Dividends Historical High Div 6.71% Low Div 1.87% Ave Div 4.29% Med Div 4.54% Close Div 5.03% Historical Dividends
High/Ave/Median Values Curr diff Exp. -27.39% 160.53% Cheap 13.56% Cheap 7.31% Exp. -3.19% High/Ave/Median
Future Div Yield Div Yd 11.53% earning in 10 Years at IRR of 9.0% Div Inc. 136.74% Future Div Yield
Future Div Yield Div Yd 17.75% earning in 15 Years at IRR of 9.0% Div Inc. 264.25% Future Div Yield
I am earning GC Div Gr 163.30% 10/15/82 # yrs -> 35 1982 $3.65 Cap Gain 384.68% I am earning GC
I am earning Div org yield 29.86% 12/31/15 Trading Div G Yrly 2.96% Div start $1.09 -29.86% 78.63% I am earning Div
I am earning GC Div Gr 111.03% 5/26/99 # yrs -> 18 1999 $21.65 Cap Gain 172.10% I am earning GC
I am earning Div org yield 6.28% 12/31/15 RRSP Div G Yrly 4.60% Div start $1.36 -6.28% 13.26% I am earning Div
Yield if held 5 yrs 3.34% 3.41% 4.87% 2.47% 5.67% 5.85% 9.13% 6.21% 7.53% 9.30% 8.08% 7.01% 6.79% 6.38% 5.76% 6.61% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 24.26% 18.21% 15.78% 5.62% 7.61% 4.39% 5.28% 7.33% 7.84% 8.74% 8.67% 12.04% 8.12% 9.34% 10.96% 7.73% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 28.88% 13.84% 29.04% 31.85% 28.21% 23.73% 17.81% 11.73% 6.50% 6.97% 9.58% 9.72% 10.30% 20.77% <-Median-> 10 Paid Median Price
Yield if held 20 yrs 43.42% 43.89% 44.76% 47.20% 37.21% 31.03% 22.08% 13.83% 43.89% <-Median-> 5 Paid Median Price
Yield if held 25 yrs 56.78% 54.41% 52.76% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 15.49% 16.12% 21.70% 20.43% 23.00% 23.03% 33.69% 23.43% 32.11% 40.96% 36.36% 31.73% 30.49% 29.86% 27.87% 27.58% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 222.80% 168.83% 135.14% 92.54% 59.81% 32.77% 35.62% 49.36% 53.86% 61.48% 62.04% 88.20% 59.87% 75.85% 93.97% 60.65% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 365.63% 341.81% 338.43% 348.21% 272.93% 224.68% 168.44% 111.48% 62.03% 67.16% 92.38% 99.40% 111.28% 248.81% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 529.48% 528.87% 535.53% 560.67% 441.35% 363.97% 271.83% 178.35% 529.48% <-Median-> 5 Paid Median Price
Cost covered if held 25 years 784.38% 783.66% 790.58% #NUM! <-Median-> 0 Paid Median Price
Graham Price $25.42 $27.08 $44.36 $20.29 $29.25 $35.08 $29.85 $32.11 $29.25 $29.50 $31.76 $34.13 $34.79 $35.63 $36.74 26.04% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.17 0.83 0.80 1.51 0.89 0.91 1.29 1.32 1.54 1.69 1.75 1.71 1.67 1.42 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.29 0.93 0.94 1.98 0.99 1.03 1.42 1.40 1.66 1.84 1.86 1.85 1.70 1.54 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.04 0.72 0.66 1.05 0.80 0.79 1.16 1.23 1.42 1.54 1.64 1.57 1.65 1.19 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.09 0.89 0.89 1.24 0.99 1.01 1.42 1.33 1.57 1.81 1.68 1.70 1.69 1.65 1.60 1.38 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 9.11% -11.03% -10.62% 23.88% -0.85% 0.74% 42.28% 32.77% 57.26% 80.62% 68.35% 70.03% 69.34% 65.32% 60.32% 37.52% <-Median-> 10 Graham Price
Pre-Split 1997
Pre-Nortel Split re Div
Closing Price $27.73 $24.09 $39.65 $25.13 $29.00 $35.34 $42.47 $42.63 $46.00 $53.28 $53.46 $58.03 $58.91 $58.91 $58.91 140.89% <-Total Growth 10 Stock Price
Increase -4.11% -13.13% 64.59% -36.62% 15.40% 21.86% 20.18% 0.38% 7.91% 15.83% 0.34% 8.55% 1.52% 0.00% 0.00% 9.19% <-IRR #YR-> 10 Stock Price
P/E 13.59 10.71 8.14 24.88 13.74 12.40 14.75 12.58 18.11 17.94 17.94 17.43 17.03 16.23 15.26 6.44% <-IRR #YR-> 5 Stock Price
Trailing P/E 16.81 11.81 17.62 5.16 28.71 16.75 14.90 14.80 13.57 20.98 18.00 19.47 17.69 17.03 16.23 14.49% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 9.19% -134.45% % Tot Ret 100.00% -2086.94% T P/E 0.08 P/E: 16.09 17.94 11.51% <-IRR #YR-> 5 Price & Dividend
-$24.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $58.03
-$42.47 $0.00 $0.00 $0.00 $0.00 $58.03
-$24.09 $1.46 $0.73 $1.58 $1.73 $2.05 $2.20 $2.32 $2.44 $2.57 $60.73
-$42.47 $2.20 $2.32 $2.44 $2.57 $60.73
Price H/L Median $29.63 $22.40 $35.36 $30.73 $26.18 $31.79 $38.49 $42.27 $45.01 $49.79 $55.48 $58.32 $58.12 160.33% <-Total Growth 10 Stock Price
Increase 6.32% -24.39% 57.83% -13.08% -14.82% 21.43% 21.08% 9.82% 6.49% 10.62% 11.43% 5.11% -0.34% 10.04% <-IRR #YR-> 10 Stock Price
P/E $14.52 $9.96 $7.26 $30.43 $12.41 $11.15 $13.36 $12.47 $17.72 $16.76 $18.62 $17.51 $16.80 8.67% <-IRR #YR-> 5 Stock Price
Trailing P/E $17.96 $10.98 $15.71 $6.31 $25.92 $15.06 $13.50 $14.68 $13.28 $19.60 $18.68 $19.57 $17.45 15.55% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 17.11 10.72 13.92 13.00 10.66 12.14 14.03 17.27 16.34 17.02 18.79 19.17 14.05% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 11.90 8.57 10.88 9.79 10.09 14.61 15.92 16.95 17.59 18.50 19.92 20.16 15.07 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 10.04% -151.67% % Tot Ret 100.00% -1749.94% T P/E 0.10 P/E: 15.06 17.51 Count 22 Years of data
-$22.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $58.32
-$38.49 $0.00 $0.00 $0.00 $0.00 $58.32
-$22.40 $1.46 $0.73 $1.58 $1.73 $2.05 $2.20 $2.32 $2.44 $2.57 $61.01
-$38.49 $2.20 $2.32 $2.44 $2.57 $61.01
High Months Sep Dec Jul Aug Dec Dec Dec Aug May Nov Feb Aug Feb
Pre-Split 1997
Pre-Nortel Split re Div
Price High $32.79 $25.25 $41.58 $40.23 $29.00 $35.96 $42.47 $45.06 $48.43 $54.21 $58.97 $63.17 $58.99 150.18% <-Total Growth 10 Stock Price
Increase 9.54% -22.99% 64.67% -3.25% -27.91% 24.00% 18.10% 6.10% 7.48% 11.93% 8.78% 7.12% -6.62% 9.60% <-IRR #YR-> 10 Stock Price
P/E $16.07 $11.22 $8.54 $39.83 $13.74 $12.62 $14.75 $13.29 $19.07 $18.25 $19.79 $18.97 $17.05 8.26% <-IRR #YR-> 5 Stock Price
Trailing P/E $19.87 $12.38 $18.48 $8.26 $28.71 $17.04 $14.90 $15.65 $14.29 $21.34 $19.86 $21.20 17.71 16.07 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 7.48% P/E: 16.50 18.97 29.10 P/E Ratio Historical High
-$25.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $63.17
-$42.47 $0.00 $0.00 $0.00 $0.00 $63.17
Low Months Nov Jun Jan Dec Mar Feb Mar Apr Aug Feb Sep Jan Mar
Pre-Split 1997
Pre-Nortel Split re Div
Price Low $26.47 $19.55 $29.13 $21.23 $23.35 $27.61 $34.50 $39.47 $41.59 $45.37 $51.99 $53.46 $57.24 173.45% <-Total Growth 10 Stock Price
Increase 2.59% -26.14% 49.00% -27.12% 9.99% 18.24% 24.95% 14.41% 5.37% 9.09% 14.59% 2.83% 7.07% 10.58% <-IRR #YR-> 10 Stock Price
P/E $12.97 $8.69 $5.98 $21.02 $11.07 $9.69 $11.98 $11.64 $16.37 $15.28 $17.45 $16.05 $16.54 9.15% <-IRR #YR-> 5 Stock Price
Trailing P/E $16.04 $9.58 $12.95 $4.36 $23.12 $13.09 $12.11 $13.70 $12.27 $17.86 $17.51 $17.94 $17.19 12.97 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 9.09% P/E: 13.63 16.05 7.44 P/E Ratio Historical Low
12.97 P/E Ratio Historical Median
-$19.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $53.46 Count 22 Years of data
-$34.50 $0.00 $0.00 $0.00 $0.00 $53.46
Long Term Debt $15,390 $16,572 Debt
Change 7.68% Change
Debt/Market Cap Ratio 0.33 0.33 0.33 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $7,185 $7,185 $17,933 $18,609 $19,553 $20,947 Intangibles Goodwill
Change 0.00% 149.59% 3.77% 5.07% 7.13% Change
Intangible/Market Cap Ratio 21.82% 21.74% 50.25% 41.56% 42.25% 41.46% 0.42 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $25,715 $19,456 $31,929 $20,181 $22,861 $26,585 $32,933 $33,055 $35,691 $44,773 $46,276 $50,527 $51,293 $51,293 $51,293 159.70% <-Total Growth 10 Market Cap
Diluted # of Shares in Millions 927.1 861.6 806.9 807.2 772.9 759.5 771.8 774.6 776.4 794.6 848.3 870.3 1.01% <-Total Growth 10 Diluted
Change 0.21% -7.07% -6.35% 0.04% -4.25% -1.73% 1.62% 0.36% 0.23% 2.34% 6.76% 2.59% 0.30% <-Median-> 10 Change
Average # of Shares in Millions 926.8 861.4 804.8 805.8 772.9 759.0 771.4 774.3 775.8 793.7 847.1 869.1 0.89% <-Total Growth 10 Basic
Change 0.24% -7.06% -6.57% 0.12% -4.08% -1.80% 1.63% 0.38% 0.19% 2.31% 6.73% 2.60% 0.28% <-Median-> 10 Change
Difference 0.1% -6.2% 0.1% -0.3% 2.0% -0.9% 0.5% 0.1% 0.0% 5.9% 2.2% 0.2% 0.16% <-Median-> 10 Difference
# of Share in Millions 927.3 807.6 805.3 803.1 788.3 752.3 775.4 775.4 775.9 840.3 865.6 870.7 870.7 870.7 870.7 0.75% <-IRR #YR-> 10 Shares
Increase 0.15% -12.91% -0.29% -0.27% -1.84% -4.57% 3.08% -0.01% 0.07% 8.30% 3.01% 0.59% 0.00% 0.00% 0.00% 2.34% <-IRR #YR-> 5 Shares
CF fr Op $Millions $5,559 $5,389 $5,704 $5,912 $4,884 $4,724 $4,869 $5,552 $6,476 $6,241 $6,274 $6,643 $7,227 $7,549 $7,523 23.27% <-Total Growth 10 Cash Flow
Increase 0.72% -3.06% 5.85% 3.65% -17.39% -3.28% 3.07% 14.03% 16.64% -3.63% 0.53% 5.88% 8.79% 4.46% -0.35% SO, S Iss decrease
5 year Running Average $5,133 $5,372 $5,637 $5,617 $5,490 $5,323 $5,219 $5,188 $5,301 $5,572 $5,882 $6,237 $6,572 $6,787 $7,043 16.11% <-Total Growth 10 CF 5 Yr Running
CFPS $5.99 $6.67 $7.08 $7.36 $6.20 $6.28 $6.28 $7.16 $8.35 $16.50 $16.50 $16.50 $8.30 $8.67 $8.64 147.28% <-Total Growth 10 Cash Flow per Share
Increase 0.57% 11.31% 6.16% 3.93% -15.84% 1.36% -0.01% 14.04% 16.57% 97.69% 0.00% 0.00% -49.70% 4.46% -0.35% 2.11% <-IRR #YR-> 10 Cash Flow 23.27%
5 year Running Average $5.69 $5.98 $6.44 $6.61 $6.66 $6.72 $6.64 $6.66 $6.85 $8.91 $10.96 $13.00 $13.23 $13.29 $11.72 6.41% <-IRR #YR-> 5 Cash Flow 36.43%
P/CF on Med Price 4.94 3.36 4.99 4.17 4.22 5.06 6.13 5.90 5.39 3.02 3.36 3.53 7.00 9.48% <-IRR #YR-> 10 Cash Flow per Share 147.28%
P/CF on Closing Price 4.63 3.61 5.60 3.41 4.68 5.63 6.76 5.95 5.51 3.23 3.24 3.52 7.10 21.32% <-IRR #YR-> 5 Cash Flow per Share 162.78%
54.03% Diff M/C 8.07% <-IRR #YR-> 10 CFPS 5 yr Running 117.29%
Excl.Working Capital CF -$356.0 $260.0 -$393.0 -$496.0 -$75.0 -$193.0 $226.0 $202 $374 $356 $418 $51 $0 $0 $0 14.38% <-IRR #YR-> 5 CFPS 5 yr Running 95.81%
CF fr Op $M WC $5,203 $5,649 $5,311 $5,416 $4,809 $4,531 $5,095 $5,754 $6,850 $6,597 $6,692 $6,694 $7,227 $7,549 $7,523 18.50% <-Total Growth 10 Cash Flow less WC
Increase -5.31% 8.57% -5.98% 1.98% -11.21% -5.78% 12.45% 12.93% 19.05% -3.69% 1.44% 0.03% 7.96% 4.46% -0.35% 1.71% <-IRR #YR-> 10 Cash Flow less WC 18.50%
5 year Running Average $5,021 $5,353 $5,416 $5,415 $5,278 $5,143 $5,032 $5,121 $5,408 $5,765 $6,198 $6,517 $6,812 $6,952 $7,137 5.61% <-IRR #YR-> 5 Cash Flow less WC 31.38%
CFPS Excl. WC $5.61 $6.99 $6.60 $6.74 $6.10 $6.02 $6.57 $7.42 $8.83 $7.85 $7.73 $7.69 $8.30 $8.67 $8.64 1.99% <-IRR #YR-> 10 CF less WC 5 Yr Run 21.76%
Increase -5.46% 24.66% -5.71% 2.26% -9.55% -1.27% 9.09% 12.94% 18.97% -11.08% -1.52% -0.56% 7.96% 4.46% -0.35% 5.31% <-IRR #YR-> 5 CF less WC 5 Yr Run 29.51%
5 year Running Average $5.56 $5.97 $6.20 $6.38 $6.41 $6.49 $6.41 $6.57 $6.99 $7.34 $7.68 $7.90 $8.08 $8.05 $8.21 0.95% <-IRR #YR-> 10 CFPS - Less WC 9.92%
P/CF on Med Price 5.28 3.20 5.36 4.56 4.29 5.28 5.86 5.70 5.10 6.34 7.18 7.59 7.00 0.00 0.00 3.19% <-IRR #YR-> 5 CFPS - Less WC 17.01%
P/CF on Closing Price 4.94 3.44 6.01 3.73 4.75 5.87 6.46 5.74 5.21 6.79 6.92 7.55 7.10 6.79 6.82 2.84% <-IRR #YR-> 10 CFPS 5 yr Running 32.34%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 4.61 5 yr 3.53 P/CF Med 10 yr 5.53 5 yr 6.34 28.39% Diff M/C 4.29% <-IRR #YR-> 5 CFPS 5 yr Running 23.37%
Income taxes $929 $924 $1,110
Interest paid -$907 -$911 -$882
Income taxes paid (net of refunds) -$743 -$672 -$565
Net change in operating assets and liabilities $365 $241 $286
Sum -$356 -$418 -$51
Google -$356 -$418 -$51
Difference $0 $0 $0
OPM 29.1% 30.4% 31.9% 33.4% 27.5% 26.1% 25.0% 27.8% 31.7% 29.7% 29.2% 30.6% 0.53% <-Total Growth 10 OPM
Increase 1.19% 4.56% 4.94% 4.63% -17.56% -5.06% -4.48% 11.30% 14.21% -6.57% -1.68% 4.88% Should increase or be stable.
Diff from Ave -1.1% 3.4% 8.6% 13.6% -6.4% -11.1% -15.1% -5.5% 7.9% 0.8% -0.8% 4.0% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 29.41% 5 Yrs 29.66% should be zero, it is a check on calculations
Current Assets $3,581.0 $3,684.0 $5,212.0 $5,578 $3,284 $3,531 $4,178 $3,911 $5,070 $4,548 $4,808 $4,855 Liquidity ratio of 1.5 and up, best
Current Liabilities $5,255.0 $4,702.0 $4,492.0 $6,227 $4,786 $5,916 $6,758 $6,745 $7,890 $9,089 $9,992 $10,108 0.61 <-Median-> 10 Ratio
Liquidity Ratio 0.68 0.78 1.16 0.90 0.69 0.60 0.62 0.58 0.64 0.50 0.48 0.48 0.50 <-Median-> 5 Ratio
Liq. with CF aft div 1.51 1.70 2.17 1.75 1.45 1.18 1.10 1.15 1.24 1.09 1.01 1.03 1.09 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.87 0.95 2.14 1.07 0.86 0.78 0.70 0.72 0.68 0.78 0.72 0.71 0.72 <-Median-> 5 Ratio
Curr. Portion on Lg T. $2,106 $2,136 $2,571 $3,743 $4,895 $4,887 $3,743 <-Median-> 5 Ratio
Liquidity Ratio 0.90 0.85 0.95 0.85 0.94 0.93 0.93 <-Median-> 5 Ratio
Liq. with CF aft div 1.60 1.68 1.83 1.85 1.98 1.99 1.85 <-Median-> 5 Ratio
Assets $40,630 $36,957 $37,797 $39,663 $38,050 $39,276 $39,426 $40,968 $45,384 $46,297 $47,993 $50,108 Debt Ratio of 1.5 and up, best
Liabilities $23,011 $21,410 $19,462 $21,272 $20,027 $21,083 $24,667 $26,243 $29,134 $31,058 $30,664 $32,254 1.58 <-Median-> 10 Ratio
Debt Ratio 1.77 1.73 1.94 1.86 1.90 1.86 1.60 1.56 1.56 1.49 1.57 1.55 1.56 <-Median-> 5 Ratio
Check $10,663 $10,480 $16,250 $10,942 $13,019 $13,536
Total Book Value $17,619 $15,547 $18,335 $18,391 $18,023 $18,193 $14,759 $14,725 $16,250 $15,239 $17,329 $17,854 $17,854 $17,854 $17,854 14.84% <-Total Growth 10 Total Book Value
Non-Controlling Int $2,898 $2,180 $1,103 $1,080 $1,049 $986 $981 $850 $1,239 $293 $306 $314 $314 $314 $314 -85.60% <-Total Growth 10 Non-Controlling Int
Preferred Shares $1,670 $1,670 $2,770 $2,770 $2,770 $2,770 $3,115 $3,395 $3,395 $4,004 $4,004 $4,004 $4,004 $4,004 $4,004 139.76% <-Total Growth 10 Preferred Shares
Book Value $13,051 $11,697 $14,462 $14,541 $14,204 $14,437 $10,663 $10,480 $11,616 $10,942 $13,019 $13,536 $13,536 $13,536 $13,536 15.72% <-Total Growth 10 Book Value
BV per share $14.07 $14.48 $17.96 $18.11 $18.02 $19.19 $13.75 $13.52 $14.97 $13.02 $15.04 $15.55 $15.55 $15.55 $15.55 7.34% <-Total Growth 10 Book Value per Share
Change 5.42% 2.91% 24.00% 0.82% -0.49% 6.51% -28.35% -1.71% 10.77% -13.03% 15.51% 3.36% 0.00% 0.00% 0.00% 90.70% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.11 1.55 1.97 1.70 1.45 1.66 2.80 3.13 3.01 3.82 3.69 3.75 1.99 P/B Ratio Historical Median
P/B Ratio (Close) 1.97 1.66 2.21 1.39 1.61 1.84 3.09 3.15 3.07 4.09 3.55 3.73 3.79 3.79 3.79 0.71% <-IRR #YR-> 10 Book Value per Share 7.34%
Change -9.04% -15.58% 32.73% -37.14% 15.97% 14.42% 67.72% 2.12% -2.58% 33.17% -13.13% 5.02% 1.52% 0.00% 0.00% 2.48% <-IRR #YR-> 5 Book Value per Share 13.06%
Leverage (A/BK) 2.31 2.38 2.06 2.16 2.11 2.16 2.67 2.78 2.79 3.04 2.77 2.81 1.72 <-Median-> 10 A/BV
Debt/Equity Ratio 1.31 1.38 1.06 1.16 1.11 1.16 1.67 1.78 1.79 2.04 1.77 1.81 3.30 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.90 5 yr Med 3.69 30.55% Diff M/C Historical
-$14.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.55
-$13.75 $0.00 $0.00 $0.00 $0.00 $15.55
Comprehensive Income $1,816 $1,815 $3,446 $2,125 $3,183 $2,821
NCI $255 $201 $443 $126 $54 $54
Preferred $119 $139 $131 $137 $152 $137
Shareholders $2,078 $4,120 $914 $1,791 $2,155 $1,442 $1,475 $2,872 $1,862 $2,977 $2,630 26.56% <-Total Growth 10 Comprehensive Income
Increase 98.27% -77.82% 95.95% 20.32% -33.09% 2.29% 94.71% -35.17% 59.88% -11.66% 2.29% <-Median-> 5 Comprehensive Income
5 Yr Running Average $2,212 $2,084 $1,555 $1,947 $1,961 $2,126 $2,363 2.38% <-IRR #YR-> 10 Comprehensive Income 26.56%
ROE 13.4% 22.5% 5.0% 9.9% 11.8% 9.8% 10.0% 17.7% 12.2% 17.2% 14.7% 12.77% <-IRR #YR-> 5 Comprehensive Income 82.39%
5Yr Median 11.8% 9.9% 9.9% 10.0% 11.8% 12.2% 14.7% 1.11% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from Net Income -22.1% -19.9% -23.4% -13.5% -21.0% -53.1% -60.0% 3.9% -43.4% -11.5% -30.6% 2.54% <-IRR #YR-> 5 5 Yr Running Average 13.38%
Median Values Diff 5, 10 yr -22.2% -30.6% 14.7% <-Median-> 5 Return on Equity
-$2,078 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,630
-$1,442 $0 $0 $0 $0 $2,630
-$2,212 $0 $0 $0 $0 $0 $2,363
-$2,084 $0 $0 $0 $0 $2,363
Current Liability Coverage Ratio 0.99 1.20 1.18 0.87 1.00 0.77 0.75 0.85 0.87 0.73 0.67 0.66 CFO / Current Liabilities
5 year Median 0.99 1.03 1.05 1.05 1.00 1.00 0.87 0.85 0.85 0.77 0.75 0.73 80.9% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 12.81% 15.29% 14.05% 13.66% 12.64% 11.54% 12.92% 14.05% 15.09% 14.25% 13.94% 13.36% CFO / Total Assets
5 year Median 12.81% 13.79% 14.04% 14.04% 13.66% 13.66% 12.92% 12.92% 12.92% 14.05% 14.05% 14.05% 13.8% <-Median-> 10 Return on Assets
Return on Assets 4.8% 5.4% 10.7% 2.4% 4.3% 5.5% 5.6% 6.4% 4.4% 5.1% 5.3% 5.7% Net Income/Assets Return on Assets
5Yr Median 4.4% 4.8% 4.8% 4.8% 4.8% 5.4% 5.5% 5.5% 5.5% 5.5% 5.3% 5.3% 5.4% <-Median-> 10 Asset Efficiency Ratio
ROE 15.0% 17.2% 28.1% 6.5% 11.5% 15.0% 20.8% 25.0% 17.0% 21.6% 19.4% 21.2% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 14.6% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 17.0% 20.8% 20.8% 21.2% 20.1% <-Median-> 10 Return on Equity
Net Income $2,574 $3,053 $2,388 $2,718 $2,730 $3,067
NCI $234 $290 $282 $218 $52 $56
Preferred $124 $107 $112 $119 $139 $131 $137 $152 $137
Shareholders $1,961.0 $2,007.0 $4,057.0 $943.0 $1,631 $2,165 $2,221 $2,624 $1,975 $2,363 $2,526 $2,874 $3,097 $3,334 $3,456 43.20% <-Total Growth 10 Net Income
Increase 28.76% 2.35% 102.14% -76.76% 72.96% 32.74% 2.59% 18.14% -24.73% 19.65% 6.90% 13.78% 7.76% 7.65% 3.66% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $1,588 $1,915 $2,258 $2,098 $2,120 $2,161 $2,203 $1,917 $2,123 $2,270 $2,342 $2,472 $2,567 $2,839 $3,057 3.66% <-IRR #YR-> 10 Net Income 43.20%
Operating Cash Flow $5,559.0 $5,389.0 $5,704.0 $5,912.0 $4,884 $4,724 $4,869 $5,552 $6,476 $6,241 $6,274 $6,643 5.29% <-IRR #YR-> 5 Net Income 29.40%
Investment Cash Flow -$3,866.0 -$3,701.0 -$69.0 -$3,950.0 -$3,217 -$2,976 -$3,884 -$4,093 -$6,401 -$3,570 -$4,114 -$4,584 2.59% <-IRR #YR-> 10 5 Yr Running Ave. 29.08%
Total Accruals $268.0 $319.0 -$1,578.0 -$1,019.0 -$36 $417 $1,236 $1,165 $1,900 -$308 $366 $815 2.33% <-IRR #YR-> 5 5 Yr Running Ave. 12.21%
Total Assets $40,630 $36,957 $37,797 $39,663 $38,050 $39,276 $39,426 $40,968 $45,384 $46,297 $47,993 $50,108 Balance Sheet Assets
Accruals Ratio 0.66% 0.86% -4.17% -2.57% -0.09% 1.06% 3.13% 2.84% 4.19% -0.67% 0.76% 1.63% 1.63% <-Median-> 5 Ratio
EPS/CF Ratio 0.36 0.32 0.74 0.15 0.35 0.47 0.44 0.46 0.29 0.38 0.39 0.43 0.41 <-Median-> 10 EPS/CF Ratio
-$2,007 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,874
-$2,221 $0 $0 $0 $0 $2,874
-$1,915 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,472
-$2,203 $0 $0 $0 $0 $2,472
Change in Close -4.11% -13.13% 64.59% -36.62% 15.40% 21.86% 20.18% 0.38% 7.91% 15.83% 0.34% 8.55% 1.52% 0.00% 0.00% Count 25 Years of data
up/down Count 7 28.00%
Meet Prediction? % right Count 1 14.29%
Financial Cash Flow -$1,613.0 -$3,639.0 -$3,914.0 -$1,559.0 -$4,044 -$1,662 -$1,581 -$1,507 $131 -$2,440 -$2,113 -$1,819 C F Statement Financial CF
Total Accruals $1,881.0 $3,958.0 $2,336.0 $540.0 $4,008 $2,079 $2,817 $2,672 $1,769 $2,132 $2,479 $2,634 Accruals
Accruals Ratio 4.63% 10.71% 6.18% 1.36% 10.53% 5.29% 7.15% 6.52% 3.90% 4.61% 5.17% 5.26% 5.17% <-Median-> 5 Ratio
Cash $2,658.0 $3,063.0 $688 $774 $45 $117 $115 $142 $100 $250 Cash
Cash Per Share $3.30 $3.81 $0.87 $1.03 $0.06 $0.15 $0.15 $0.17 $0.12 $0.29 $0.15 <-Median-> 5 Cash per Share
Percentage of Stock Price 8.32% 15.18% 3.01% 2.91% 0.14% 0.35% 0.32% 0.32% 0.22% 0.49% 0.32% <-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 $27.73 $24.09 $39.65 $25.13 $29.00 $35.34 $42.47 $42.63 $46.00 $53.28 $53.46 $58.03 $58.91 $58.91 $58.91 140.89% <-Total Growth 10 Stock Price
Median 10, 5 Yrs D. per yr 5.30% 5.07% % Tot Ret 36.56% 44.03% Price Inc 7.91% P/E: 16.09 17.94 11.51% <-IRR #YR-> 5 Price & Dividend
Look at stuff at bottom of page
-$24.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $58.03
-$42.47 $0.00 $0.00 $0.00 $0.00 $58.03
-$24.09 $1.46 $0.73 $1.58 $1.73 $2.05 $2.20 $2.32 $2.44 $2.57 $60.73
-$42.47 $2.20 $2.32 $2.44 $2.57 $60.73
Price H/L Median $29.63 $22.40 $35.36 $30.73 $26.18 $31.79 $38.49 $42.27 $45.01 $49.79 $55.48 $58.32 $58.12 160.33% <-Total Growth 10 Stock Price
Median 10, 5 Yrs D. per yr 5.51% 5.38% % Tot Ret 35.45% 38.30% Price Inc 9.82% P/E: 15.06 17.51 Count 36 Years of data
-$22.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $58.32
-$38.49 $0.00 $0.00 $0.00 $0.00 $58.32
-$22.40 $1.46 $0.73 $1.58 $1.73 $2.05 $2.20 $2.32 $2.44 $2.57 $61.01
-$38.49 $2.20 $2.32 $2.44 $2.57 $61.01
Price high with Nortel
Split 1997
High Months Sep Dec Jul Aug Dec Dec Dec Aug May Nov Feb Aug Feb
Price High $32.79 $25.25 $41.58 $40.23 $29.00 $35.96 $42.47 $45.06 $48.43 $54.21 $58.97 $63.17 $58.99 150.18% <-Total Growth 10 Stock Price
Median 10, 5 Yrs Price Inc 7.48% P/E: 16.50 18.97 18.99 P/E Ratio Historical High
-$25.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $63.17
-$42.47 $0.00 $0.00 $0.00 $0.00 $63.17
No Nortel
Price Low
Low Months Nov Jun Jan Dec Mar Feb Mar Apr Aug Feb Sep Jan Mar
Price Low $26.47 $19.55 $29.13 $21.23 $23.35 $27.61 $34.50 $39.47 $41.59 $45.37 $51.99 $53.46 $57.24 173.45% <-Total Growth 10 Stock Price
Median 10, 5 Yrs Price Inc 9.09% P/E: 13.63 16.05 4.70 P/E Ratio Historical Low
-$19.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $53.46
-$34.50 $0.00 $0.00 $0.00 $0.00 $53.46
http://www.theglobeandmail.com/globe-investor/investment-ideas/strategy-lab/dividend-investing/my-love-hate-relationship-with-bce/article22903331/
Notes:
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. 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.
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
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 is 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.
How they make their money.
BCE is Canada's largest communications company, providing the most comprehensive and innovative suite of communication services to residential and business customers in Canada. Operating under the
Bell and Bell Aliant brands, the Company's services include Bell Home phone local and long distance services, Bell Mobility, Virgin Mobile and Solo Mobile wireless, high-speed Bell Internet,
Bell TV direct-to-home satellite and VDSL television, IP-broadband services and information and communications technology (ICT) services.
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
Date Feb 18 2013 Mar 23 2014 Mar 05 2015 Mar 27 2016 Mar 24 2017
Cope, George 0.146 0.02% 0.049 0.01% 0.058 0.01% 0.062 0.01% 0.065 0.01%
CEO - Shares - Amount $6.700 $2.62 $3.114 $3.572 $3.825
Options - percentage 1.700 0.22% 2.406 0.29% 2.733 0.32% 1.438 0.17% 2.412 0.28%
Options - amount $78.193 $128.17 $146.100 $83.436 $142.107
LeBlanc, Glen 0.001 0.00% 0.002 0.00%
CFO - Shares - Amount $0.086 $0.124
Options - percentage 0.309 0.04% 0.415 0.05%
Options - amount $17.960 $24.430
Vanaselja, Siim A. 0.005 0.00% 0.006 0.00% 0.008 0.00%
CFO - Shares - Amount $0.211 $0.31 $0.433
Options - percentage 0.439 0.06% 0.673 0.08% 0.703 0.08%
Options - amount $20.179 $35.83 $37.582
Le Duc, Bernard 0.007 0.00% 0.008 0.00% 0.010 0.00%
Officer - Shares - Amount $0.363 $0.474 $0.563
Options - percentage 0.295 0.03% 0.296 0.03% 0.321 0.04%
Options - amount $15.783 $17.175 $18.930
Brooks, Karyn A. 0.003 0.00%
Officer - Shares - Amount $0.152
Options - percentage 0.028 0.00%
Options - amount $1.304
Boychuk, Michael T. 0.011 0.00%
Officer - Shares - Amount $0.505
Options - percentage 0.291 0.04%
Options - amount $13.404
Allen, Barry Keith 0.020 0.00% 0.023 0.00% 0.023 0.00% 0.023 0.00% 0.023 0.00%
Director - Shares - Amount $0.920 $1.20 $1.203 $1.306 $1.325
Options - percentage 0.009 0.00% 0.011 0.00% 0.014 0.00% 0.017 0.00% 0.019 0.00%
Options - amount $0.413 $0.61 $0.749 $0.963 $1.124
Nixon, Gordon Melbourne 0.020 0.00%
Chairman - Shares - Amt $1.178
Options - percentage 0.011 0.00%
Options - amount $0.626
O'Neill, Thomas Charles 0.003 0.00% 0.003 0.00% 0.003 0.00%
Chairman - Shares - Amt $0.13 $0.154 $0.167
Options - percentage 0.046 0.01% 0.057 0.01% 0.068 0.01%
Options - amount $2.44 $3.039 $3.917
Increase in O/S Shares 1.297 0.17% 0.421 0.05% 1.372 0.16% 2.290 0.26% 2.237 0.26%
due to SO $55.289 $19.358 $73.100 $122.41 $129.807
Book Value $43.000 $14.000 $53.000 $96.000 $104.000
Insider Buying $0.000 -$0.226 -$0.306
Insider Selling $14.176 $51.284 $30.262
Net Insider Selling $14.176 $51.058 $29.957
% of Market Cap 0.03% 0.10% 0.06%
Directors 14 14% 15 13 13 14
Women 2 2 13% 2 15% 2 15% 3 21%
Minorities 0 0% 0 0% 0 0% 1 8% 1 7%
Institutions/Holdings 434 25.64% 11 25.64% 662 45.18% 470 43.19% 899 43.19%
Total Shares Held 321.717 41.46% 2.051 0.24% 380.158 43.92% 374.926 43.31% 385.540 44.28%
Increase/Decrease 7.053 2.24% 0.033 1.63% -0.254 -0.07% 2.132 0.57% -4.570 -1.17%
Starting No. of Shares 314.664 Nasdaq 2.018 380.412 372.794 390.109 NASDAQ
Institutions/Holdings 6 20.82% 787
Total Shares Held 1.666 0.19% 429.000 49.27%
Increase/Decrease 0.009 0.57% -7.000 -1.61%
Starting No. of Shares 1.657 436.000 Morningstar
My Stock