This report should not be construed as providing investment advice. It is for educational purposes only.Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ Q1 2017
Shaw Communications Inc. TSX: SJR.B NYSE: SJR www.shaw.ca Fiscal Yr: Aug 31 11/30/16
Year 8/31/05 8/31/06 8/31/07 8/31/08 8/31/09 8/31/10 8/31/11 8/31/12 8/31/13 8/31/14 8/31/15 8/31/16 8/31/17 8/31/18 8/31/19 Value Description #Y Item
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
Split Date 26-Jul-07
Split 2
$4,778 <-12 mths -2.17%
Revenue* $2,210 $2,459 $2,774 $3,105 $3,390 $3,718 $4,741 $4,998 $5,142 $5,241 $5,488 $4,884 $5,312 $5,514 $5,684 98.59% <-Total Growth 10 Revenue
Increase 6.25% 11.29% 12.82% 11.91% 9.19% 9.66% 27.53% 5.42% 2.88% 1.93% 4.71% -11.01% 8.76% 3.80% 3.08% 7.10% <-IRR #YR-> 10 Revenue
5 year Running Average $1,955 $2,132 $2,304 $2,526 $2,788 $3,089 $3,546 $3,990 $4,398 $4,768 $5,122 $5,151 $5,213 $5,288 $5,376 0.60% <-IRR #YR-> 5 Revenue
Revenue per Share $5.02 $5.72 $6.43 $7.25 $7.88 $8.58 $10.83 $11.26 $11.36 $11.34 $11.58 $10.04 $10.92 $11.34 $11.69 9.22% <-IRR #YR-> 10 5 yr Running Average
Increase 11.80% 13.91% 12.43% 12.67% 8.73% 8.92% 26.19% 4.00% 0.81% -0.10% 2.09% -13.27% 8.76% 3.80% 3.08% 7.75% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $4.27 $4.73 $5.20 $5.78 $6.46 $7.17 $8.19 $9.16 $9.98 $10.68 $11.27 $11.12 $11.05 $11.05 $11.12 5.79% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 2.33 2.50 3.31 3.02 2.60 2.37 1.97 1.80 2.03 2.29 2.40 2.52 -1.50% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 2.50 2.92 3.81 3.16 2.38 2.55 2.07 1.79 2.24 2.41 2.28 2.61 2.57 2.48 2.40 8.91% <-IRR #YR-> 10 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 2.38 5 yr 2.29 7.80% Diff M/C 6.29% <-IRR #YR-> 5 5 yr Running Average
-$2,459 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,884
-$4,741 $0 $0 $0 $0 $4,884
-$2,132 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,151
-$3,546 $0 $0 $0 $0 $5,151
-$5.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.04
-$10.83 $0.00 $0.00 $0.00 $0.00 $10.04
-$4.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.12
-$8.19 $0.00 $0.00 $0.00 $0.00 $11.12
$2.26 <-12 mths -9.96%
pre-split '07
EPS Basic $0.34 $1.05 $0.90 $1.56 $1.24 $1.23 $1.03 $1.62 $1.64 $1.84 $1.80 $2.51 139.05% <-Total Growth 10 EPS Basic
pre-split '00
pre-split '07 $0.67 $2.09
EPS Diluted* $0.34 $1.05 $0.89 $1.55 $1.24 $1.23 $1.03 $1.61 $1.63 $1.84 $1.79 $2.51 $1.16 $1.43 $1.53 140.19% <-Total Growth 10 EPS Diluted
Increase 204.55% 211.94% -14.83% 74.16% -20.00% -0.81% -16.26% 56.31% 1.24% 12.88% -2.72% 40.22% -53.78% 23.28% 6.99% 9.16% <-IRR #YR-> 10 Earnings per Share 140.19%
Earnings Yield 2.7% 6.3% 3.6% 6.8% 6.6% 5.6% 4.6% 8.0% 6.4% 6.7% 6.8% 9.6% 4.1% 5.1% 5.5% 19.50% <-IRR #YR-> 5 Earnings per Share 143.69%
5 year Running Average -$0.18 $0.12 $0.44 $0.79 $1.01 $1.19 $1.19 $1.33 $1.35 $1.47 $1.58 $1.88 $1.79 $1.75 $1.68 31.87% <-IRR #YR-> 10 5 yr Running Average 1489.83%
10 year Running Average -$0.03 $0.05 $0.13 $0.29 $0.41 $0.51 $0.65 $0.89 $1.07 $1.24 $1.39 $1.53 $1.56 $1.55 $1.58 9.57% <-IRR #YR-> 5 5 yr Running Average 57.91%
* Diluted ESP per share E/P 10 Yrs 6.66% 5Yrs 6.77%
-$1.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.51
-$1.03 $0.00 $0.00 $0.00 $0.00 $2.51
-$0.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.88
-$1.19 $0.00 $0.00 $0.00 $0.00 $1.88
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-split '00
pre-split '07 $0.28 $0.48 $0.99
Dividend* $0.14 $0.24 $0.49 $0.71 $0.82 $0.86 $0.90 $0.95 $0.99 $1.06 $1.14 $1.185 $1.185 $1.185 $1.185 398.93% <-Total Growth 10 Dividends
Increase 74.99% 69.66% 108.41% 42.43% 16.31% 4.88% 4.65% 5.00% 5.29% 6.53% 7.78% 3.72% 0.00% 0.00% 0.00% Count 23 Years of data
Dividends 5 Yr Running $0.06 $0.10 $0.20 $0.33 $0.48 $0.62 $0.76 $0.85 $0.90 $0.95 $1.01 $1.07 $1.11 $1.15 $1.18 949.75% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.20% 1.66% 2.32% 3.22% 4.00% 4.23% 4.22% 4.65% 4.32% 4.09% 4.11% 4.68% 4.38% 4.17% <-Median-> 10 Dividends
Yield on HighPrice 1.05% 1.41% 1.87% 2.67% 3.48% 3.91% 3.84% 4.38% 3.82% 3.79% 3.61% 4.21% 4.18% 3.81% <-Median-> 10 Dividends
Yield on Low Price 1.40% 2.02% 3.07% 4.05% 4.70% 4.62% 4.70% 4.96% 4.96% 4.43% 4.78% 5.25% 4.59% 4.70% <-Median-> 10 Dividends
Yield on Close Price 1.12% 1.42% 2.02% 3.08% 4.36% 3.93% 4.02% 4.69% 3.92% 3.87% 4.32% 4.52% 4.22% 4.22% 4.22% 3.98% <-Median-> 10 Dividends
Payout Ratio EPS 41.79% 22.73% 55.62% 45.48% 66.13% 69.92% 87.38% 58.70% 61.04% 57.61% 63.83% 47.21% 102.16% 82.87% 77.45% 59.87% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 17.61% 9.71% 21.97% 21.39% 38.67% 50.69% 73.40% 52.55% 55.46% 51.74% 56.34% 42.45% 95.99% 80.52% 76.90% 51.21% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 8.46% 12.06% 21.35% 24.32% 25.51% 25.56% 31.73% 31.84% 32.91% 28.15% 35.16% 34.65% 34.25% 33.10% 31.43% 29.94% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 3.56% 5.15% 8.43% 11.43% 14.92% 18.53% 26.65% 28.50% 29.90% 25.28% 31.03% 31.15% 32.18% 32.16% 31.21% 25.97% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 8.45% 12.05% 20.76% 24.70% 26.65% 27.08% 27.30% 32.28% 32.65% 32.14% 33.07% 36.22% 34.25% 33.10% 31.43% 29.72% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 5.36% 7.23% 11.25% 15.99% 20.08% 23.16% 25.56% 27.59% 29.12% 30.23% 31.47% 33.30% 33.68% 33.74% 33.54% 26.58% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 4.32% 4.32% 5 Yr Med Payout 58.70% 32.91% 32.65% 17.44% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. -2.20% -2.34% Last Div Inc ---> $0.0917 $0.0988 7.7% 5.66% <-IRR #YR-> 5 Dividends
-$0.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.19
-$0.90 $0.00 $0.00 $0.00 $0.00 $1.19
Historical Dividends Historical High Div 4.96% Low Div 0.14% Ave Div 2.55% Med Div 1.20% Close Div 1.12% Historical Dividends
High/Ave/Median Values Curr diff Exp. -14.89% ††† 2915% Cheap 65.55% Cheap 251.80% Cheap 278.46% High/Ave/Median Values
Future Dividend Yield Div Yd 5.54% earning in 5 Years at IRR of 5.60% Div Inc. 31.32% Future Dividend Yield
Future Dividend Yield Div Yd 7.28% earning in 10 Years at IRR of 5.60% Div Inc. 72.44% Future Dividend Yield
Future Dividend Yield Div Yd 9.56% earning in 15 Years at IRR of 5.60% Div Inc. 126.44% Future Dividend Yield
Yield if held 5 yrs 0.91% 1.48% 4.19% 9.28% 8.13% 7.36% 6.29% 4.44% 4.54% 5.17% 5.62% 5.56% 5.83% 5.14% 4.57% 5.59% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 6.26% 11.26% 19.90% 11.94% 8.45% 5.57% 5.59% 8.00% 13.10% 10.51% 9.78% 8.28% 5.56% 5.41% 5.78% 9.11% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 26.50% 38.48% 42.65% 37.99% 16.85% 10.92% 7.40% 7.36% 10.03% 15.60% 11.75% 21.68% <-Median-> 8 Paid Median Price
Yield if held 20 yrs 34.26% 51.12% 56.16% 47.64% 20.06% 12.21% 51.12% <-Median-> 3 Paid Median Price
Yield if held 25 yrs 38.30% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 1.91% 3.15% 8.28% 21.82% 23.77% 26.68% 26.41% 19.85% 20.64% 23.20% 24.82% 25.01% 27.39% 24.98% 22.68% 23.48% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 17.56% 29.03% 43.82% 30.09% 26.56% 22.11% 26.65% 44.08% 81.31% 70.95% 69.83% 63.63% 45.99% 46.93% 51.88% 43.95% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 86.22% 157.05% 208.17% 213.87% 106.62% 75.61% 54.77% 59.76% 91.22% 157.09% 129.27% 96.42% <-Median-> 8 Paid Median Price
Cost covered if held 20 years 240.08% 382.66% 460.66% 437.69% 204.11% 136.22% 382.66% <-Median-> 3 Paid Median Price
Cost covered if held 25 years 430.22% #NUM! <-Median-> 0 Paid Median Price
Graham Price $5.23 $9.95 $9.62 $13.55 $12.73 $13.30 $12.44 $16.81 $17.75 $19.88 $20.85 $26.40 $17.09 $18.97 $19.62 165.35% <-Total Growth 10 Graham Price
Price/GP Ratio Med 2.23 1.44 2.21 1.62 1.61 1.53 1.71 1.21 1.30 1.30 1.33 0.96 1.59 1.43 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 2.55 1.70 2.75 1.95 1.85 1.66 1.88 1.28 1.47 1.41 1.52 1.07 1.66 1.59 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.92 1.18 1.67 1.29 1.37 1.40 1.54 1.13 1.13 1.20 1.15 0.85 1.51 1.24 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 2.40 1.68 2.55 1.69 1.48 1.64 1.80 1.20 1.43 1.38 1.27 0.99 1.64 1.48 1.43 1.45 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 139.89% 68.05% 154.84% 69.02% 47.63% 64.38% 80.04% 19.93% 43.01% 37.80% 26.75% -0.65% 64.27% 47.95% 43.03% 45.32% <-Median-> 10 Graham Price
Month, Year Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Month, Year
Price Close $12.62 $18.46 $23.64 $21.61 $21.67 $21.35 $20.25 $22.84 $25.85 $31.35 $23.80 $26.94 $28.07 $28.07 $28.07 45.94% <-Total Growth 10 Stock Price
Increase 15.04% 46.28% 28.06% -8.59% 0.28% -1.48% -5.15% 12.79% 13.18% 21.28% -24.08% 13.19% 4.19% 0.00% 0.00% 3.85% <-IRR #YR-> 10 Stock Price
P/E 37.67 17.67 26.56 13.94 17.48 17.36 19.66 14.19 15.86 17.04 13.30 10.73 24.20 19.63 18.35 5.88% <-IRR #YR-> 5 Stock Price
Trailing P/E 114.73 55.10 22.62 24.28 13.98 17.22 16.46 22.17 16.06 19.23 12.93 15.05 11.18 24.20 19.63 7.89% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.per yr 4.04% 4.68% % Tot Ret 51.20% 44.32% Price Inc 13.18% P/E: 16.45 14.19 10.55% <-IRR #YR-> 5 Price & Dividend
-$18.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.94
-$20.25 $0.00 $0.00 $0.00 $0.00 $26.94
-$18.46 $0.49 $0.71 $0.82 $0.86 $0.90 $0.95 $0.99 $1.06 $1.14 $28.13
-$20.25 $0.95 $0.99 $1.06 $1.14 $28.13
Month, Year Aug-05 Aug-06 Aug-07 Aug-08 Aug-09 Aug-10 Aug-11 Aug-12 Aug-13 Aug-14 Aug-15 Aug-16 Aug-17 Aug-18 Aug-19 Month, Year
pre-split '07
Price Close $12.55 $16.72 $24.52 $22.90 $18.79 $21.87 $22.40 $20.16 $25.38 $27.39 $26.43 $26.23 $28.07 $28.07 $28.07 56.88% <-Total Growth 10 Stock Price
Increase 23.83% 33.23% 46.65% -6.61% -17.95% 16.39% 2.42% -10.00% 25.89% 7.92% -3.50% -0.76% 7.01% 0.00% 0.00% 4.61% <-IRR #YR-> 10 Stock Price
P/E 37.46 16.00 27.55 14.77 15.15 17.78 21.75 12.52 15.57 14.89 14.77 10.45 24.20 19.63 18.35 3.21% <-IRR #YR-> 5 Stock Price
Trailing P/E 114.09 49.91 23.46 25.73 12.12 17.64 18.21 19.57 15.76 16.80 14.36 14.65 11.18 24.20 19.63 8.92% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.per yr 4.32% 4.44% % Tot Ret 48.39% 58% Price Inc -0.76% P/E: 15.02 14.77 7.65% <-IRR #YR-> 5 Price & Dividend
-$16.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.23
-$22.40 $0.00 $0.00 $0.00 $0.00 $26.23
-$16.72 $0.49 $0.71 $0.82 $0.86 $0.90 $0.95 $0.99 $1.06 $1.14 $27.42
-$22.40 $0.95 $0.99 $1.06 $1.14 $27.42
Price H/L Median $11.69 $14.31 $21.31 $21.90 $20.52 $20.32 $21.31 $20.33 $23.05 $25.94 $27.80 $25.34 $27.09 77.05% <-Total Growth 10 Stock Price
Increase 15.84% 22.49% 48.86% 2.79% -6.32% -0.97% 4.87% -4.58% 13.38% 12.52% 7.17% -8.83% 6.89% 5.88% <-IRR #YR-> 10 Stock Price
P/E 34.88 13.70 23.94 14.13 16.54 16.52 20.68 12.63 14.14 14.10 15.53 10.10 23.35 3.53% <-IRR #YR-> 5 Stock Price
Trailing P/E 106.23 42.72 20.39 24.61 13.24 16.38 17.32 19.74 14.32 15.91 15.11 14.16 10.79 10.66% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Aveage -66.39 121.29 48.64 27.86 20.27 17.06 17.93 15.26 17.10 17.67 17.59 13.51 15.17 8.17% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Aveage -373.92 283.42 159.59 75.84 50.41 40.03 32.63 22.97 21.60 20.92 20.06 16.54 17.37 15.53 P/E Ratio Historical Median
Median 10, 5 Yrs D.per yr 4.78% 4.64% % Tot Ret 44.85% 56.81% Price Inc 7.17% P/E: 14.83 14.10 Count 23 Years of data
-$14.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.34
-$21.31 $0.00 $0.00 $0.00 $0.00 $25.34
-$14.31 $0.49 $0.71 $0.82 $0.86 $0.90 $0.95 $0.99 $1.06 $1.14 $26.53
-$21.31 $0.95 $0.99 $1.06 $1.14 $26.53
High Months Jun Aug Oct-Dec Oct 07 Sep 08 Dec 09 Oct 10 Sep 11 Jul 13 Jul 14 Jan 15 Dec 15 Jan 17
pre-split '00
pre-split '07
Price High $13.35 $16.88 $26.50 $26.38 $23.59 $22.02 $23.45 $21.59 $26.04 $27.95 $31.67 $28.12 $28.37 66.64% <-Total Growth 10 Stock Price
Increase 11.02% 26.40% 57.04% -0.45% -10.58% -6.66% 6.49% -7.93% 20.61% 7.33% 13.31% -11.21% 0.89% 5.24% <-IRR #YR-> 10 Stock Price
P/E 39.85 16.15 29.78 17.02 19.02 17.90 22.77 13.41 15.98 15.19 17.69 11.20 24.46 3.70% <-IRR #YR-> 5 Stock Price
Trailing P/E 121.36 50.37 25.36 29.64 15.22 17.76 19.07 20.96 16.17 17.15 17.21 15.71 11.30 17.69 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 7.33% P/E: 17.36 15.19 42.21 P/E Ratio Historical High
-$13.35 -$16.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28.12
-$23.45 $0.00 $0.00 $0.00 $0.00 $28.12
Low Months Sep Oct Jan-Mar Mar 08 Mar 09 May 10 Apr 11 May 12 Sep 12 Sep 13 Sep 13 Feb 16 Nov 16
pre-split '00
pre-split '07
Price Low $10.02 $11.75 $16.11 $17.42 $17.44 $18.61 $19.16 $19.07 $20.06 $23.92 $23.92 $22.56 $25.80 92.00% <-Total Growth 10 Stock Price
Increase 22.94% 17.27% 37.11% 8.13% 0.11% 6.71% 2.96% -0.47% 5.19% 19.24% 0.00% -5.69% 14.36% 6.74% <-IRR #YR-> 10 Stock Price
P/E 29.91 11.24 18.10 11.24 14.06 15.13 18.60 11.84 12.31 13.00 13.36 8.99 22.24 3.32% <-IRR #YR-> 5 Stock Price
Trailing P/E 91.09 35.07 15.42 19.57 11.25 15.01 15.58 18.51 12.46 14.67 13.00 12.60 10.28 13.36 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 0.00% P/E: 13.18 12.31 3.52 P/E Ratio Historical Low
-$11.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.56
-$19.16 $0.00 $0.00 $0.00 $0.00 $22.56
Long Term Debt $5,061 $5,200 Debt
Debt/Market Cap Ratio 0.40 0.41 0.41 <-Median-> 2 Debt/Market Cap Ratio
Goodwill $712 $715 $698 $698 $1,506 $1,172 Broadcast rights and licenses, trademark, brands and wireless spectrum licenses
Goodwill & Intangibles $8,004 $8,070 $7,851 $7,896 $8,965 $8,622 Intangibles Goodwill
Intangible/Market Cap Ratio 0.82 0.90 0.68 0.62 0.72 0.68 0.70 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $M $5,521 $7,187 $10,576 $9,811 $8,084 $9,473 $9,805 $8,945 $11,493 $12,655 $12,525 $12,754 $13,649 $13,649 $13,649 77.46% <-Total Growth 10 Market Cap $M
Diluted # of Shares in Million 456.42 435.33 435.74 433.87 430.78 433.88 435.95 442 450 459 471 481 10.49% <-Total Growth 10 Diluted
Change -1.47% -4.62% 0.09% -0.43% -0.71% 0.72% 0.48% 1.39% 1.81% 2.00% 2.61% 2.12% 1.05% <-Median-> 10 Change
Average # of Sh in M 456.42 435.33 432.49 431.07 429.15 432.68 434.88 441 448 457 468 480 10.26% <-Total Growth 10 Average
Change -1.47% -4.62% -0.65% -0.33% -0.45% 0.82% 0.51% 1.41% 1.59% 2.01% 2.41% 2.56% 1.11% <-Median-> 10 Change
Difference -3.6% -1.3% -0.3% -0.6% 0.3% 0.1% 0.7% 0.6% 1.1% 1.1% 1.3% 1.3% 0.64% <-Median-> 10 Difference
$1,622 <-12 mths -2.47%
Class A 22.69 22.58 22.56 22.55 22.52 22.52 22.52 22.52 22.52 22.42 22.42 22.42 22.42 22.42 22.42
Class B 417.27 407.27 408.77 405.88 407.72 410.62 415.22 421.19 430.31 439.61 451.47 463.83 463.83 463.83 463.83
# of Share in Millions 439.96 429.85 431.33 428.43 430.24 433.14 437.74 443.71 452.83 462.03 473.89 486.25 486.25 486.25 486.25 1.24% <-IRR #YR-> 10 Shares
Change -4.96% -2.30% 0.34% -0.67% 0.42% 0.68% 1.06% 1.36% 2.05% 2.03% 2.57% 2.61% 0.00% 0.00% 0.00% 2.12% <-IRR #YR-> 5 Shares
CF fr Op $Millon $728.4 $846.9 $1,000.0 $1,242.2 $1,382.9 $1,457.2 $1,241.7 $1,317 $1,369 $1,740 $1,540 $1,663 $1,682 $1,741 $1,833 96.37% <-Total Growth 10 Cash Flow
Increase -0.34% 16.26% 18.08% 24.22% 11.33% 5.37% -14.79% 6.07% 3.95% 27.10% -11.49% 7.99% 1.17% 3.47% 5.31% S0, DRIP Buy Backs S. Issues
5 year Running Average $525 $636 $769 $910 $1,040 $1,186 $1,265 $1,328 $1,354 $1,425 $1,442 $1,526 $1,599 $1,673 $1,692 139.90% <-Total Growth 10 CF 5 Yr Running
CFPS $1.66 $1.97 $2.32 $2.90 $3.21 $3.36 $2.84 $2.97 $3.02 $3.77 $3.25 $3.42 $3.46 $3.58 $3.77 73.59% <-Total Growth 10 Cash Flow per Share
Increase 4.86% 18.99% 17.68% 25.06% 10.86% 4.66% -15.68% 4.64% 1.86% 24.57% -13.71% 5.24% 1.17% 3.47% 5.31% 6.98% <-IRR #YR-> 10 Cash Flow 96.37%
5 year Running Average $1.15 $1.42 $1.74 $2.08 $2.41 $2.75 $2.93 $3.06 $3.08 $3.19 $3.17 $3.29 $3.38 $3.50 $3.50 6.02% <-IRR #YR-> 5 Cash Flow 33.93%
P/CF on Med Price 7.06 7.26 9.19 7.55 6.38 6.04 7.51 6.85 7.62 6.89 8.55 7.41 7.83 5.67% <-IRR #YR-> 10 Cash Flow per Share 73.59%
P/CF on Closing Price 7.58 8.49 10.58 7.90 5.85 6.50 7.90 6.79 8.39 7.27 8.13 7.67 8.11 3.81% <-IRR #YR-> 5 Cash Flow per Share 20.57%
8.75% Diff M/C 8.77% <-IRR #YR-> 10 CFPS 5 yr Running 131.72%
Excl.Working Capital CF $0.1 $0.3 $28.4 -$19.3 -$59.1 -$81.8 $201.5 -$18.0 $11.0 -$216.0 $97.0 -$72.0 $0.0 $0.0 $0.0 2.34% <-IRR #YR-> 5 CFPS 5 yr Running 12.26%
CF fr Op $M WC $729 $847 $1,028 $1,223 $1,324 $1,375 $1,443 $1,299 $1,380 $1,524 $1,637 $1,591 $1,682 $1,741 $1,833 87.80% <-Total Growth 10 Cash Flow less WC
Increase 4.86% 16.29% 21.39% 18.92% 8.25% 3.89% 4.93% -9.99% 6.24% 10.43% 7.41% -2.81% 5.75% 3.47% 5.31% 6.50% <-IRR #YR-> 10 Cash Flow less WC 87.80%
5 year Running Average $502 $629 $769 $904 $1,030 $1,160 $1,279 $1,333 $1,364 $1,404 $1,457 $1,486 $1,563 $1,635 $1,697 1.97% <-IRR #YR-> 5 Cash Flow less WC 10.24%
CFPS Excl. WC $1.66 $1.97 $2.38 $2.85 $3.08 $3.18 $3.30 $2.93 $3.05 $3.30 $3.45 $3.27 $3.46 $3.58 $3.77 8.97% <-IRR #YR-> 10 CF less WC 5 Yr Run 136.15%
Increase 10.34% 19.02% 20.97% 19.72% 7.80% 3.20% 3.83% -11.20% 4.10% 8.24% 4.73% -5.28% 5.75% 3.47% 5.31% 3.05% <-IRR #YR-> 5 CF less WC 5 Yr Run 16.22%
5 year Running Average $1.10 $1.40 $1.74 $2.07 $2.39 $2.69 $2.96 $3.07 $3.10 $3.15 $3.20 $3.20 $3.31 $3.41 $3.51 5.20% <-IRR #YR-> 10 CFPS - Less WC 66.02%
P/CF on Med Price 7.06 7.26 8.94 7.67 6.67 6.40 6.46 6.94 7.56 7.86 8.05 7.74 7.83 0.00 0.00 -0.15% <-IRR #YR-> 5 CFPS - Less WC -0.76%
P/CF on Closing Price 7.58 8.48 10.28 8.02 6.11 6.89 6.79 6.89 8.33 8.30 7.65 8.02 8.11 7.84 7.45 8.59% <-IRR #YR-> 10 CFPS 5 yr Running 128.01%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 7.46 5 yr 7.41 P/CF Med 10 yr 7.62 5 yr 7.74 6.49% Diff M/C 1.59% <-IRR #YR-> 5 CFPS 5 yr Running 8.20%
-$2.84 $0.00 $0.00 $0.00 $0.00 $3.42 Cash Flow per Share
-$1.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.29 CFPS 5 yr Running
-$2.93 $0.00 $0.00 $0.00 $0.00 $3.29 CFPS 5 yr Running
-$847 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,591 Cash Flow less WC
-$1,443 $0 $0 $0 $0 $1,591 Cash Flow less WC
-$629 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,486 CF less WC 5 Yr Run
-$1,279 $0 $0 $0 $0 $1,486 CF less WC 5 Yr Run
-$1.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.27 CFPS - Less WC
-$3.30 $0.00 $0.00 $0.00 $0.00 $3.27 CFPS - Less WC
-$1.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.20 5 yr Running Average
-$2.96 $0.00 $0.00 $0.00 $0.00 $3.20 5 yr Running Average
Net change in non-cash balances -11 216 -97 72
Sum -11 216 -97 72
Google -11 216 -97 72
Difference 0 0 0 0
OPM 32.96% 34.44% 36.04% 40.01% 40.79% 39.20% 26.19% 26.35% 26.62% 33.20% 28.06% 34.05% -1.12% <-Total Growth 10 OPM
Increase -6.21% 4.46% 4.67% 11.00% 1.96% -3.91% -33.18% 0.61% 1.04% 24.70% -15.48% 21.34% Should increase or be stable.
Diff from Ave -1.97% 2.41% 7.19% 18.98% 21.32% 16.57% -22.11% -21.63% -20.82% -1.26% -16.55% 1.26% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 33.62% 5 Yrs 28.06% should be zero, it is a check on calculations
Current Assets $180.72 $213.01 $590.24 $404.47 $757.67 $595.5 $1,262.3 $1,051 $1,195 $1,333 $1,009 $876 $769 Liquidity ratio of 1.5 and up, best
Current Liabilities $564.10 $593.35 $861.90 $828.65 $1,377.02 $1,019.4 $1,131.3 $1,595 $2,205 $1,396 $1,938 $1,819 $1,769 0.57 <-Median-> 10 Ratio
Liquidity Ratio 0.32 0.36 0.68 0.49 0.55 0.58 1.12 0.66 0.54 0.95 0.52 0.48 0.43 0.54 <-Median-> 5 Ratio
Liq. with CF aft div 1.50 1.61 1.60 1.62 1.30 1.65 1.87 1.22 0.96 1.85 1.04 1.08 1.06 1.08 <-Median-> 5 Ratio
Liq. CF reInv+Div 0.90 0.88 0.87 0.86 0.76 0.61 0.85 0.76 0.74 1.07 0.52 0.64 1.06 0.74 <-Median-> 5 Ratio
Current Portion of Debt $451 $950 $0 $608 $412 $412
Liquidity Ratio 0.92 0.95 0.95 0.76 0.62 0.57 0.92 <-Median-> 5 Ratio
Liq. with CF aft div 1.70 1.68 1.85 1.51 1.40 1.38 1.68 <-Median-> 5 Ratio
Assets $7,430.2 $7,522.5 $8,163.7 $8,357.8 $8,938.1 $10,154.0 $12,525.9 $12,722 $12,732 $13,250 $14,564 $15,239 $15,391 Debt Ratio of 1.5 and up, best
Liabilities $5,832.6 $5,712.8 $6,169.7 $6,102.6 $6,440.1 $7,383.4 $9,068.0 $8,687 $8,319 $8,313 $8,918 $8,944 $9,657 1.43 <-Median-> 10 Ratio
Debt Ratio 1.27 1.32 1.32 1.37 1.39 1.38 1.38 1.46 1.53 1.59 1.63 1.70 1.59 1.59 <-Median-> 5 Ratio
Total Book Value $1,597.5 $1,809.7 $1,994.0 $2,255.2 $2,498.0 $2,770.5 $3,457.8 $4,035 $4,413 $4,937 $5,646 $6,295 $5,734 247.85% <-Total Growth 10 Total Book Value
NCI $0.0 $241.0 $281 $231 $235 $237 $1 $1 NCI
Preferred Shares $0.0 $293.2 $293 $293 $293 $293 $293 $293 Preferred Shares
Book Value $1,597.5 $1,809.7 $1,994.0 $2,255.2 $2,498.0 $2,770.5 $2,923.7 $3,461 $3,889 $4,409 $5,116 $6,001 $5,440 $5,440.0 $5,440.0 231.60% <-Total Growth 10 Book Value
Book Value per Share $3.63 $4.21 $4.62 $5.26 $5.81 $6.40 $6.68 $7.80 $8.59 $9.54 $10.80 $12.34 $11.19 $11.19 $11.19 193.14% <-Total Growth 10 Book Value per Share
Change -32.54% 15.94% 9.81% 13.86% 10.30% 10.17% 4.42% 16.78% 10.10% 11.11% 13.13% 14.32% -9.35% 0.00% 0.00% -3.33% P/B Ratio Current/Historical
P/B Ratio (Median) 3.22 3.40 4.61 4.16 3.53 3.18 3.19 2.61 2.68 2.72 2.57 2.05 2.42 2.60 P/B Ratio Historical Median
P/B Ratio (Close) 3.46 3.97 5.30 4.35 3.24 3.42 3.35 2.58 2.96 2.87 2.45 2.13 2.51 2.51 2.51 11.35% <-IRR #YR-> 10 Book Value per Share 193.14%
Change 83.57% 14.91% 33.55% -17.98% -25.61% 5.65% -1.91% -22.93% 14.34% -2.87% -14.70% -13.19% 18.05% 0.00% 0.00% 13.07% <-IRR #YR-> 5 Book Value per Share 84.78%
Leverage (A/BK) 4.65 4.16 4.09 3.71 3.58 3.66 3.62 3.15 2.89 2.68 2.58 2.42 2.68 3.37 <-Median-> 10 A/BV
Debt/Equity Ratio 3.65 3.16 3.09 2.71 2.58 2.66 2.62 2.15 1.89 1.68 1.58 1.42 1.68 2.37 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.95 5 yr Med 2.61 -14.86% Diff M/C 3.06 Historical Leverage (A/BK)
-$4.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.34
-$6.68 $0.00 $0.00 $0.00 $0.00 $12.34
$1,063 <-12 mths -8.36%
Comprehensive Income $580.34 $465.28 $697 $790 $841 $994 $1,193 105.57% <-Total Growth 6 Comprehensive Income
NCI $0 $19.1 $33 $38 $30 $24 $20 NCI
Preferred Dividends $13 $13 $13 $13 $13 Preferred
Shareholders $388.46 $670.80 $554.28 $580.34 $446.19 $651 $739 $798 $957 $1,160 198.61% <-Total Growth 9 Comprehensive Income
Increase 72.68% -17.37% 4.70% -23.12% 45.90% 13.52% 7.98% 19.92% 21.21% 19.92% <-Median-> 5 Comprehensive Income
5 Yr Running Average $528 $581 $594 $643 $718 $861 7.09% <-IRR #YR-> 8 Comprehensive Income #DIV/0!
ROE 19.5% 29.7% 22.2% 20.9% 12.9% 16.1% 16.7% 16.2% 17.0% 18.4% 21.06% <-IRR #YR-> 5 Comprehensive Income 159.98%
5Yr Median 20.9% 20.9% 16.7% 16.2% 16.2% 16.7% 10.27% <-IRR #YR-> 5 5 Yr Running Average #DIV/0!
Difference from NI 0.0% 0.0% 0.8% 1.7% -0.2% -1.6% 0.1% -0.9% 2.0% -0.7% 10.27% <-IRR #YR-> 5 5 Yr Running Average 63.06%
Median Values Diff 5, 10 yr 0.0% -0.7% 16.7% <-Median-> 5 Return on Equity
-$670.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,160.0
-$446.2 $0.0 $0.0 $0.0 $0.0 $1,160.0
-$528.0 $0.0 $0.0 $0.0 $0.0 $861.0
-$528.0 $0.0 $0.0 $0.0 $0.0 $861.0
Current Liability Coverage Ratio 1.29 1.43 1.19 1.48 0.96 1.35 1.28 0.81 0.63 1.09 0.84 0.87 CFO / Current Liabilities
5 year Median 0.68 0.81 1.19 1.29 1.29 1.35 1.28 1.28 0.96 1.09 0.84 0.84 0.84 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 9.81% 11.26% 12.60% 14.63% 14.81% 13.55% 11.52% 10.21% 10.84% 11.50% 11.24% 10.44% CFO / Total Assets
5 year Median 7.16% 9.19% 9.81% 11.26% 12.60% 13.55% 13.55% 13.55% 11.52% 11.50% 11.24% 10.84% 10.8% <-Median-> 5 Return on Assets
Return on Assets ROA 2.1% 6.1% 4.8% 8.0% 6.0% 5.2% 3.6% 5.6% 5.8% 6.4% 5.8% 7.9% Net Income/Assets Return on Assets ROA
5Yr Median -0.6% 1.2% 2.1% 4.8% 6.0% 6.0% 5.2% 5.6% 5.6% 5.6% 5.8% 5.8% 5.8% <-Median-> 5 Asset Efficiency Ratio ROA
Return on Equity ROE 9.6% 25.3% 19.5% 29.8% 21.4% 19.2% 13.1% 17.7% 16.6% 17.1% 14.9% 19.2% Net Inc/ Shareholders' equity Return on Equity ROE
5Yr Median -1.9% 3.6% 9.6% 19.5% 21.4% 21.4% 19.5% 19.2% 17.7% 17.1% 16.6% 17.1% 17.1% <-Median-> 5 Return on Equity ROE
$1,086 <-12 mths -10.02%
Net Income $532.73 $472.79 $761 $784 $887 $880 $1,240
NCI $0.0 $19.1 $33 $38 $30 $24 $20
Preferred Dividends $13 $13 $13 $13 $13 Preferred Dividends
Shareholders $153.22 $458.25 $388.48 $671.56 $535.24 $532.73 $453.70 $715 $733 $844 $843 $1,207 $537 $700 $747 163.39% <-Total Growth 10 Net Income
Increase 68.54% 199.08% -15.23% 72.87% -20.30% -0.47% -14.84% 57.59% 2.52% 15.14% -0.12% 43.18% -55.51% 30.35% 6.71% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average -$47.5 $73.6 $208.6 $352.5 $441.4 $517.3 $516.3 $582 $594 $656 $718 $868 $833 $826 $807 10.17% <-IRR #YR-> 10 Net Income 163.39%
Operating Cash Flow $728.44 $846.87 $1,000.01 $1,242.2 $1,382.9 $1,457.2 $1,241.7 $1,317 $1,369 $1,740 $1,540 $1,663 21.62% <-IRR #YR-> 5 Net Income 166.03%
Investment Cash Flow -$380.08 -$489.10 -$719.78 -$734.14 -$966.72 -$1,744.0 -$1,349.9 -$983 -$642 -$1,029 -$1,904 -$1,227 27.98% <-IRR #YR-> 10 5 Yr Running Average 1079.16%
Total Accruals -$195.14 $100.48 $108.24 $163.50 $119.03 $819.55 $561.92 $381 $6 $133 $1,207 $771 10.96% <-IRR #YR-> 5 5 Yr Running Average 68.18%
Total Assets $7,430.2 $7,522.5 $8,163.7 $8,357.8 $8,938.1 $10,154.0 $12,525.9 $12,722 $12,732 $13,250 $14,564 $15,239 Balance Sheet Assets
Accruals Ratio -2.63% 1.34% 1.33% 1.96% 1.33% 8.07% 4.49% 2.99% 0.05% 1.00% 8.29% 5.06% 2.99% <-Median-> 5 Ratio
EPS/CF Ratio 0.20 0.53 0.37 0.54 0.40 0.39 0.31 0.55 0.53 0.56 0.52 0.77 0.53 <-Median-> 10 EPS/CF Ratio
-$458 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,207
-$454 $0 $0 $0 $0 $1,207
-$74 $0 $0 $0 $0 $0 $0 $0 $0 $0 $868
-$516 $0 $0 $0 $0 $868
Change in Close 23.83% 33.23% 46.65% -6.61% -17.95% 16.39% 2.42% -10.00% 25.89% 7.92% -3.50% -0.76% 7.01% 0.00% 0.00% count 24 Change in Close
up/down down down down count 9
Meet Prediction? Yes % right count 5 55.56%
Financial Cash Flow -$346.68 -$359.47 -$114.90 -$673.38 $36.97 $50.32 $482.9 -$347 -$732 -$496 $124 -$429 C F Statement Financial Cash Flow
Total Accruals $151.54 $459.94 $223.15 $836.88 $82.06 $769.23 $79.1 $728 $738 $629 $1,083 $1,200 Accruals
Accruals Ratio -4.67% -4.78% -1.41% -8.06% 0.41% 0.50% 3.85% -2.73% -5.75% -3.74% 0.85% -2.82% -2.82% <-Median-> 5 Ratio
Cash $0.00 $453.24 $216.74 $443.4 $427 $422 $637 $398 $405 $289 Cash
Cash per Share $1.05 $0.50 $1.01 $0.96 $0.93 $1.38 $0.84 $0.83 $0.59 $0.93 <-Median-> 5 Cash per Share
Percentage of Stock Price 5.61% 2.29% 4.52% 4.77% 3.67% 5.03% 3.18% 3.18% 2.12% 3.67% <-Median-> 5 % of Stock Price
Notes:
January 31, 2017.Last estimates were for 2016, 2017 and 2018 of $5616M, $5673M and $6260M for Revenue, $1.78, $1.60 and $1.68 for EPS,
$3.02, $3.67 and $3.85 for CFPS and $891M and 816M for 2016 and 2017 for Net Income.
January 31, 2016.Last estimates were for 2015, 2016 and 2017 of $5516M, $5617M and $5713M for Revenue, $1.81, $1.88 and $1.96 for EPS,
$11.50, $10.10 and $12.50 for CFPS and $862M and $894M and $949M for net income.
January 30, 2015.Last estimates were for 2014, 2015 and 2016 of $5286M, $5365M and $5508M for Revenue, $1.75, $1.78 and $1.89 for EPS, $7.56, $3.58
and $3.93 for CFPS and $775M and $815M for Net Income for 2014 and 2015.
January 28, 2014.Last estimates were for 2013 and 2014 of $5116M and $5207M for Revenue, $1.62 and $1.67 for EPS and $3.60 for CFPS for 2013.
January 20, 2013.Last Estiamtes were for 2012 and 2013 at $5049M and $5178M for Revenue, $1.64 and $1.74 for EPS and $3.44 and $3.60 for CPFS.
Feb 5, 2012.Last Estiamtes were for 2010 and 2011 at $1.39 and $1.52 for EPS and $2.68 and $3.12 for CF.
Jan 12, 2010.Earnings were right on at $1.24 for 2009.For 2010 I got earnings of $41.38.
Sep 19, 2009 AR 2008.They seemed to revised very strong upward cash flow from operations for 2006 and 2007.I did not change my figures.
A couple of sites show the 2008 EPS as 1.06.I do not know why, but there seems to be included in the $1.55 a one time item. I cannot find this in the statements.
AR2004 I guess there is more to this stock than meets the eye.Cash Flow ok, but hasn't made much of a profit, but P/E is very high.
You would have to look at this stock from a different angle than revenues and earnings.Also Debt is very high.Do I really want a stock I do not understand? AP2004
Got stock off Investment Reporter list (MPL Communitications Publication.
Sector:
Telecom Services, Utility
What should this stock accomplish?
You should expect a good dividend but some volatility in the growth of dividends.
Would I buy this company and Why.
You would buy for diversification.You should expect volatility in growth.
Dividends
Dividends are paid monthly.They are declared for shareholders of record mid-month and payable at the end of the month.
For example, the dividend for shareholders of record for March 15, 2013 was payble on March 27, 2013.
Unti December 2004, dividends used to be paid quarterly in Cycle 3.Also, until April 2002, dividends were paid semi-annually in October and April.
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 Shaw says it is committed to providing unsurpassed customer service and exceptional customer experiences.††
For employees Shaw says its culture at Shaw is founded on creating workplaces where our employees want to build their careers.††
For Community, Shaw says it is proud to partner with a number of Canadian organizations focused on protecting and nurturing todayís children and youth for a bright, prosperous tomorrow.††
For investors:
Why am I following this stock.
I am following this stock because it was a stock on Investment Reporterís list, a MPL Communications Publication.
How they make their money
Shaw Communications Inc. is a diversified communications company whose core business is providing broadband cable television, Internet, digital phone and satellite direct-to-home services.
Industry: Communications & Media (Cable).
J.R. Shaw owns 79%.†† SJR.B shares are non-voting and the SJR.A shares are voting shares.
Class A shares are voting shares and Class B shares are non-voting shares.
For most ratios, lower is better when looking for a good stock price.However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.††
Also, for the Operational Profit Margin, a higher percentage is better.With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Jan 01 2013 Jan 28 2014 Jan 30 2015 Jan 31 2016 Jan 31 2017
Shaw, Bradley 4.426 19.74% 4.426 19.74% 0.046 0.21% 0.046 0.21% A
CEO - Shares - Amount A $121.239 $116.990 $1.217 $1.302 A
CEO - Shares -B 12.630 2.79% 8.610 1.86% 8.870 1.87% 8.802 1.81% 8.813 1.81% B
Class B - amount $320.546 $235.835 $234.444 $230.883 $247.391 B
Options - percentage 0.796 0.18% 0.756 0.16% 0.756 0.16% 0.817 0.17% 0.924 0.19%
Options - amount $20.191 $20.71 $19.991 $21.421 $25.940
Culmone, Vito 0.002 0.00% 0.003 0.00%
CFO - Shares - Amount $0.052 $0.082
Options - percentage 0.140 0.03% 0.197 0.04%
Options - amount $3.672 $5.536
Wilson, Stephen 0.070 0.02% 0.076 0.02% 0.081 0.02% was CFO in 2015
CFO - Shares - Amount $1.779 $2.072 $2.128
Options - percentage 0.118 0.03% 0.950 0.21% 0.850 0.18%
Options - amount $3.006 $26.02 $22.466
English, Trevor 0.015 0.00%
Officer - Shares - Amount $0.421
Options - percentage 0.284 0.06%
Options - amount $7.965
Avis, Deb 0.026 0.01% 0.023 0.00%
Officer - Shares - Amount $0.647 $0.618
Options - percentage 0.189 0.04% 0.185 0.04%
Options - amount $4.787 $5.07
Bissonnette, Peter 0.040 0.18% 0.040 0.18% 0.040 0.18% A left in August 2015
Officer Class A $1.096 $1.057 $1.123 A
Class B Shares 0.173 0.04% 0.185 0.04% 0.375 0.08% B
Class B - amount $4.742 $4.880 $10.524 B
Options - percentage 1.050 0.23% 1.050 0.22% 0.000 0.00%
Options - amount $28.76 $27.752 $0.000
Shaw, Julie 4.426 19.74% 4.426 19.74% 0.032 0.14% 0.032 0.14% A
Officer Class A $121.239 $116.990 $0.850 $0.909 A
Class B Shares 12.699 2.80% 8.273 1.79% 8.268 1.74% 8.278 1.70% 8.295 1.71% B
Class B - amount $322.306 $226.593 $218.519 $217.134 $232.845 B
Options - percentage 0.362 0.08% 0.355 0.08% 0.385 0.08% 0.395 0.08% 0.395 0.08%
Options - amount $9.185 $9.72 $10.176 $10.361 $11.088
Burns, Adrian 0.003 0.01% 0.003 0.01% 0.003 0.01% 0.003 0.01% A
Director Class A $0.071 $0.069 $0.068 $0.073 A
Class B Shares 0.009 0.00% 0.006 0.00% 0.006 0.00% 0.006 0.00% 0.006 0.00% B
Class B - amount $0.218 $0.164 $0.159 $0.157 $0.168 B
Options - percentage 0.084 0.02% 0.086 0.02% 0.094 0.02% 0.101 0.02% 0.101 0.02%
Options - amount $2.137 $2.35 $2.490 $2.636 $2.821
Shaw, Jim 13.411 2.96% 4.426 19.74% 4.426 19.74% 0.032 0.14% 0.032 0.14% A
Director Class A $340.369 $121.239 $116.990 $0.839 $0.898 A
Class B Shares 1.050 0.23% 8.986 1.94% 8.989 1.90% 8.946 1.84% 8.951 1.84% B
Class B - amount $26.649 $246.127 $237.588 $234.661 $251.242 B
Options - percentage 1.050 0.23% 1.050 0.22% 0.000 0.00% 0.000 0.00%
Options - amount $28.76 $27.752 $0.000 $0.000
Shaw, J. R. 14.175 62.95% 4.503 20.09% 4.503 20.09% 17.672 78.82% 17.639 78.68% A
Chairman Class A $359.772 $123.348 $119.025 $463.531 $495.138 A
Class B Shares 0.000 0.00% 10.022 2.17% 10.048 2.12% 10.105 2.08% 2.621 0.54% B
Class B - amount $0.000 $274.512 $265.574 $265.067 $73.584 B
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.00 $0.000 $0.000 $0.000
Class A 79.51% 79.33% 79.36%
Increase in O/S Shares 3.565 0.79% 3.432 0.74% 5.872 1.24% 1.827 0.38%
due to SO 2013 $90.476 $93.990 $155.187 $47.925
Book Value $79.000 $81.000 $152.000 $43.000
Insider Buying $0.000 -$2.639 -$2.941 -$13.932
Insider Selling $0.000 $21.102 $56.631 $23.844
Net Insider Selling $0.000 $18.462 $53.690 $9.912
% of Market Cap 0.00% 0.15% 0.42% 0.07%
Directors 16 16 16 16
Women 2 13% 2 13% 2 13% 2 13%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 510 55.53% 208 0.00% 408 60.85% 206 52.54%
Total Shares Held 237.300 53.48% 221.444 47.93% 275.477 56.65% 244.413 50.27%
Increase/Decrease 6.221 2.55% -3.842 -1.71% 1.136 0.41% 4.088 1.70%
Starting No. of Shares 243.521 225.286 274.341 240.325 Nasdaq
Copyright © 2008 Website of SPBrunner. All rights reserved.