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/ Q1 2018 Fiscal year change 2016
BlackBerry Ltd TSX: BB NASDAQ BBRY www.ca.blackberry.com Fiscal Yr: Feb 28 Mar 1 to Feb 28
Year 03/01/06 03/01/07 03/01/08 02/28/09 02/27/10 02/26/11 03/03/12 03/02/13 03/01/14 02/28/15 02/29/16 02/28/17 02/28/18 02/28/19 02/28/20 Value Description #Y Item Total G Currency
Accounting Rules US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP Accounting Rules
$1,144 <-12 mths -12.61%
Revenue US$* $2,065.8 $3,037.1 $6,009.4 $11,065.2 $14,953.2 $19,907 $18,435 $11,073 $6,813 $3,335 $2,160 $1,309 $1,016 $932 $989 -56.90% <-Total Growth 10 Revenue US$
Increase 52.97% 47.02% 97.87% 84.13% 35.14% 33.13% -7.39% -39.93% -38.47% -51.05% -35.23% -39.40% -22.38% -8.27% 6.12% -8.07% <-IRR #YR-> 10 Revenue -56.90% US$
5 year Running Average $922 $1,471 $2,611 $4,706 $7,426 $10,994 $14,074 $15,087 $14,236 $11,913 $8,363 $4,938 $2,927 $1,750 $1,281 -41.08% <-IRR #YR-> 5 Revenue -92.90% US$
Revenue per Share $3.70 $5.45 $10.68 $19.54 $26.83 $38.00 $35.17 $21.13 $12.94 $6.31 $4.14 $2.47 $1.91 $1.75 $1.86 12.87% <-IRR #YR-> 10 5 yr Running Average 235.70% US$
Increase 55.84% 47.12% 96.09% 82.97% 37.29% 41.63% -7.45% -39.93% -38.75% -51.26% -34.28% -40.46% -22.53% -8.27% 6.12% -18.90% <-IRR #YR-> 5 5 yr Running Average -64.91% US$
5 year Running Average $1.69 $2.65 $4.66 $8.35 $13.24 $20.10 $26.04 $28.13 $26.81 $22.71 $15.94 $9.40 $5.55 $3.32 $2.43 -7.61% <-IRR #YR-> 10 Revenue per Share -54.70% US$
P/S (Price/Sales) Med 6.58 6.30 8.30 4.73 2.26 1.56 1.09 0.57 0.85 1.57 2.06 2.89 -41.22% <-IRR #YR-> 5 Revenue per Share -92.98% US$
P/S (Price/Sales) Close 7.77 8.32 9.72 2.21 2.64 1.74 0.39 0.63 0.77 1.71 1.86 2.79 4.59 5.01 4.72 13.49% <-IRR #YR-> 10 5 yr Running Average 254.36% US$
*Revenue in M US $ P/S 10 yr 1.80 5 yr 1.71 155.72% Diff M/C -18.45% <-IRR #YR-> 5 5 yr Running Average -63.92% US$
-$3,037 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,309
-$18,435 $0 $0 $0 $0 $1,309
-$1,471 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,938
-$14,074 $0 $0 $0 $0 $4,938
-$5.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.47
-$35.17 $0.00 $0.00 $0.00 $0.00 $2.47
-$2.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.40
-$26.04 $0.00 $0.00 $0.00 $0.00 $9.40
$1,289 <-12 mths -25.68%
Revenue CDN$ $2,347.8 $3,556.8 $5,886.8 $14,256.6 $15,772.5 $19,453 $18,243 $11,369 $7,557 $4,171 $2,896 $1,734 $1,289 $1,182 $1,255 -51.24% <-Total Growth 10 Revenue CDN$
Increase 39.92% 51.49% 65.51% 142.18% 10.63% 23.34% -6.22% -37.68% -33.53% -44.80% -30.58% -40.12% -25.68% -8.27% 6.12% -6.93% <-IRR #YR-> 10 Revenue -51.24% CDN$
5 year Running Average $1,170 $1,767 $2,853 $5,545 $8,364 $11,785 $14,722 $15,819 $14,479 $12,159 $8,847 $5,546 $3,529 $2,255 $1,671 -37.54% <-IRR #YR-> 5 Revenue -90.49% CDN$
Revenue per Share $4.21 $6.38 $10.46 $25.18 $28.30 $37.13 $34.80 $21.69 $14.35 $7.89 $5.56 $3.27 $2.42 $2.22 $2.36 12.12% <-IRR #YR-> 10 5 yr Running Average 213.86% CDN$
Increase 42.54% 51.60% 64.03% 140.65% 12.40% 31.21% -6.27% -37.68% -33.83% -45.04% -29.56% -41.17% -25.82% -8.27% 6.12% -17.74% <-IRR #YR-> 5 5 yr Running Average -62.33% CDN$
5 year Running Average $2.16 $3.19 $5.09 $9.84 $14.91 $21.49 $27.18 $29.42 $27.26 $23.17 $16.86 $10.55 $6.70 $4.27 $3.17 -6.47% <-IRR #YR-> 10 Revenue per Share -48.75% CDN$
P/S (Price/Sales) Med 6.81 6.18 8.23 3.88 2.48 1.66 1.14 0.55 0.63 1.45 1.98 2.86 -37.69% <-IRR #YR-> 5 Revenue per Share -90.61% CDN$
P/S (Price/Sales) Close 7.92 8.36 9.80 2.18 2.63 1.74 0.39 0.63 0.77 1.72 1.86 2.82 4.59 5.01 4.72 12.70% <-IRR #YR-> 10 5 yr Running Average 230.62% CDN$
*Revenue in M CDN $ P/S 10 yr 1.80 5 yr 1.72 155.54% Diff M/C -17.24% <-IRR #YR-> 5 5 yr Running Average -61.17% CDN$
$0.21 <-12 mths 109.13%
EPS Basic $US $0.66 $1.14 $2.31 $3.35 $4.35 $6.36 $2.22 -$1.23 -$11.18 -$0.58 -$0.40 -$2.30 -301.75% <-Total Growth 10 EPS Basic US$
Pre-split '07 $1.96 $3.31
EPS Diluted* $0.65 $1.10 $2.26 $3.30 $4.31 $6.34 $2.22 -$1.23 -$11.18 -$0.58 -$0.86 -$2.30 $0.49 $0.03 -$0.39 -308.46% <-Total Growth 10 EPS Diluted US$
Increase 79.82% 68.88% 104.83% 46.02% 30.61% 47.10% -64.98% -155.41% 808.94% -94.81% 48.28% 167.44% -121% -94% -1400% #NUM! <-IRR #YR-> 10 Earnings -308.46% US$
Earnings Yield 2.3% 2.4% 2.2% 7.7% 6.1% 9.6% 16.1% -9.3% -111.8% -5.4% -11.2% -33.4% 5.6% 0.3% -4.4% #NUM! <-IRR #YR-> 5 Earnings -203.60% US$
5 year Running Average $0.15 $0.38 $0.90 $1.54 $2.33 $3.46 $3.69 $2.99 $0.09 -$0.89 -$2.33 -$3.23 -$2.89 -$0.64 -$0.61 #NUM! <-IRR #YR-> 10 5 yr Running Average -948.51% US$
10 year Running Average $0.08 $0.19 $0.41 $0.74 $1.17 $1.81 $2.03 $1.94 $0.81 $0.72 $0.57 $0.23 $0.05 -$0.28 -$0.75 #NUM! <-IRR #YR-> 5 5 yr Running Average -187.63% US$
* Diluted ESP per share E/P 10 Yrs -1.59% 5Yrs -11.18%
-$1.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$2.30
-$2.22 $0.00 $0.00 $0.00 $0.00 -$2.30
-$0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$3.23
-$3.69 $0.00 $0.00 $0.00 $0.00 -$3.23
$0.27 <-12 mths 108.74%
EPS Basic $0.75 $1.34 $2.26 $4.32 $4.59 $6.21 $2.20 -$1.26 -$12.40 -$0.73 -$0.54 -$3.05 -328.23% <-Total Growth 10 EPS Basic CDN$
Pre-split '05 CDN$
Pre-split '07 CDN$
EPS Diluted* $0.74 $1.29 $2.21 $4.25 $4.55 $6.20 $2.20 -$1.26 -$12.40 -$0.73 -$1.15 -$3.05 $0.62 $0.04 -$0.49 -335.82% <-Total Growth 10 EPS Diluted CDN$
Increase 64.48% 74.02% 71.34% 92.05% 6.92% 36.28% -64.54% -157.49% 881.93% -94.15% 58.93% 164.27% -120% -94% -1400% #NUM! <-IRR #YR-> 10 Earnings -335.82% CDN$
Earnings Yield 2.2% 2.4% 2.2% 7.8% 6.1% 9.6% 16.2% -9.3% -112.2% -5.4% -11.2% -33.0% 5.6% 0.3% -4.4% #NUM! <-IRR #YR-> 5 Earnings -238.70% CDN$
5 year Running Average $0.15 $0.43 $0.97 $1.79 $2.61 $3.70 $3.88 $3.19 -$0.15 -$1.20 -$2.67 -$3.72 -$3.34 -$0.85 -$0.81 #NUM! <-IRR #YR-> 10 5 yr Running Average -964.85% CDN$
10 year Running Average $0.08 $0.21 $0.43 $0.85 $1.30 $1.92 $2.16 $2.08 $0.82 $0.70 $0.52 $0.08 -$0.08 -$0.50 -$1.00 #NUM! <-IRR #YR-> 5 5 yr Running Average -195.80% CDN$
* Diluted ESP per share E/P 10 Yrs -1.60% 5Yrs -11.18%
-$1.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$3.05
-$2.20 $0.00 $0.00 $0.00 $0.00 -$3.05
-$0.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$3.72
-$3.88 $0.00 $0.00 $0.00 $0.00 -$3.72
Graham No. $7.74 $11.38 $18.66 $31.50 $37.35 $48.77 $30.86 $30.42 $19.53 $9.46 $9.54 $7.53 $8.49 $2.10 #NUM! -33.86% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 3.71 3.46 4.61 3.10 1.88 1.27 1.29 0.40 0.46 1.21 1.15 1.24 1.44 1.25 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 4.51 4.89 6.62 4.76 2.53 1.59 2.16 0.59 0.61 1.59 1.45 1.39 1.82 1.59 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 2.91 2.04 2.60 1.44 1.23 0.94 0.42 0.21 0.31 0.83 0.85 1.09 1.06 0.89 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 4.31 4.69 5.49 1.74 2.00 1.32 0.44 0.45 0.57 1.43 1.08 1.23 1.31 5.30 #NUM! 1.28 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 330.90% 368.84% 449.42% 73.89% 99.58% 32.48% -55.93% -55.20% -43.42% 43.14% 8.09% 22.65% 31.24% 430.41% #NUM! 27.57% <-Median-> 10 Graham Price CDN$
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
Price Close CDN$ $25.58 $49.67 $112.56 $49.50 $71.03 $58.07 $14.80 $11.80 $7.90 $12.74 $12.84 $9.18 $11.14 $11.14 $11.14 -81.52% <-Total Growth 10 Stock Price CDN$
Increase -22.32% 94.18% 126.62% -56.02% 43.49% -18.25% -74.51% -20.27% -33.05% 61.27% 0.78% -28.50% 21.35% 0.00% 0.00% -15.54% <-IRR #YR-> 10 Stock Price -81.52% CDN$
P/E 34.45 38.44 50.84 11.64 15.62 9.37 6.74 -9.34 -0.64 -17.56 -11.14 -3.01 17.92 292.73 -22.52 -9.11% <-IRR #YR-> 5 Stock Price -37.97% CDN$
Trailing P/E 56.66 66.89 87.11 22.36 16.71 12.77 2.39 5.37 -6.26 -1.03 -17.70 -7.96 -3.66 17.92 292.73
Median 10, 5 Yrs Price Inc -20.27% P/E: 3.05 -9.34
-$49.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.18
-$14.80 $0.00 $0.00 $0.00 $0.00 $9.18
Month, Year Mar-06 Mar-07 Mar-08 Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
pre-split '05
pre-split '07 $100.00 $160.05
Price Close CDN$ $33.33 $53.35 $102.53 $54.78 $74.55 $64.61 $13.60 $13.63 $11.05 $13.54 $10.31 $9.23 $11.14 $11.14 $11.14 -82.70% <-Total Growth 10 Stock Price CDN$
Increase 23.46% 60.05% 92.18% -46.57% 36.09% -13.33% -78.95% 0.22% -18.93% 22.53% -23.86% -10.48% 20.69% 0.00% 0.00% -16.09% <-IRR #YR-> 10 Stock Price -82.70% CDN$
P/E 44.89 41.29 46.31 12.88 16.40 10.43 6.19 -10.79 -0.89 -18.66 -8.94 -3.03 17.92 292.73 -22.52 -7.46% <-IRR #YR-> 5 Stock Price -32.13% CDN$
Trailing P/E 73.84 71.85 79.35 24.74 17.53 14.21 2.20 6.20 -8.75 -1.09 -14.21 -8.01 -3.66 17.92 292.73
Median 10, 5 Yrs Price Inc -10.48% P/E: 2.65 -8.94
-$53.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.23
-$13.60 $0.00 $0.00 $0.00 $0.00 $9.23
Price H/L CDN$ $28.67 $39.40 $86.06 $97.71 $70.21 $61.73 $39.75 $12.03 $9.04 $11.44 $10.99 $9.35 $12.21 -76.27% <-Total Growth 10 Stock Price CDN$
Increase 2.70% 37.41% 118.44% 13.54% -28.14% -12.09% -35.60% -69.75% -24.86% 26.56% -3.94% -14.88% 30.59% -13.40% <-IRR #YR-> 10 Stock Price -76.27% CDN$
P/E 38.61 30.49 38.87 22.98 15.44 9.96 18.09 -9.52 -0.73 -15.76 -9.53 -3.07 19.64 -25.13% <-IRR #YR-> 5 Stock Price -76.48% CDN$
Trailing P/E 63.51 53.06 66.60 44.13 16.51 13.58 6.42 5.47 -7.15 -0.92 -15.14 -8.11 -4.01
P/E on Run. 5 yr Ave 193.68 91.65 88.93 54.58 26.91 16.68 10.24 3.77 -62.29 -9.53 -4.12 -2.51 -3.65
P/E on Run. 10 yr Ave 187.58 199.56 114.77 53.91 32.08 18.44 5.79 10.98 16.22 21.31 114.73 -157.06 18.09 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc -14.88% P/E: 4.62 -9.52 Count 21 Years of data CDN$
-$39.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.35
-$39.75 $0.00 $0.00 $0.00 $0.00 $9.35
CDN Month Nov 07 Jun 08 Jun 09 Mar 10 Mar 11 Jan 13 Jan 14 Jan 15 Mar 15 Sep 16 Jun 17
pre-split '05
pre-split '07 $104.56 $166.83
Price High CDN$ $34.85 $55.61 $123.52 $149.90 $94.36 $77.76 $66.60 $17.80 $11.96 $15.02 $13.87 $10.46 $15.42 -81.19% <-Total Growth 10 Stock Price CDN$
Increase -2.73% 59.55% 122.12% 21.36% -37.05% -17.59% -14.35% -73.27% -32.81% 25.59% -7.66% -24.59% 47.42% -15.39% <-IRR #YR-> 10 Stock Price -81.19% CDN$
P/E 46.94 43.04 55.79 35.26 20.76 12.55 30.32 -14.09 -0.96 -20.70 -12.03 -3.43 24.81 -30.94% <-IRR #YR-> 5 Stock Price -84.29% CDN$
Trailing P/E 77.20 74.89 95.60 67.71 22.19 17.10 10.75 8.10 -9.47 -1.21 -19.12 -9.07 -5.06 30.32 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc -24.59% P/E: 5.79 -12.03 129.28 P/E Ratio Historical High CDN$
-$55.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.46
-$66.60 $0.00 $0.00 $0.00 $0.00 $10.46
CDN Month Mar 07 Dec 08 Mar 09 Sep 10 Dec 11 Sep 12 Dec 13 Apr 14 Oct 15 Jun 16 Mar 17
pre-split '05
pre-split '07 $67.47 $69.56
Price Low CDN$ $22.49 $23.19 $48.60 $45.52 $46.06 $45.69 $12.90 $6.25 $6.11 $7.85 $8.10 $8.24 $9.00 -64.46% <-Total Growth 10 Stock Price CDN$
Increase 12.45% 3.10% 109.60% -6.34% 1.19% -0.80% -71.77% -51.55% -2.24% 28.48% 3.18% 1.73% 9.22% -9.83% <-IRR #YR-> 10 Stock Price -64.46% CDN$
P/E 30.29 17.94 21.95 10.71 10.13 7.37 5.87 -4.95 -0.49 -10.82 -7.03 -2.70 14.48 -8.57% <-IRR #YR-> 5 Stock Price -36.12% CDN$
Trailing P/E 49.82 31.23 37.61 20.56 10.83 10.05 2.08 2.84 -4.84 -0.63 -11.17 -7.15 -2.95 10.13 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 1.73% P/E: 2.69 -4.95 -6.19 P/E Ratio Historical Low CDN$
-$23.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.24
-$12.90 $0.00 $0.00 $0.00 $0.00 $8.24
US Prices Mar-06 Mar-07 Mar-08 Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
pre-split '05
pre-split '07 $86.28 $135.97
Price Close US$ $28.76 $45.32 $103.80 $43.11 $70.88 $65.99 $13.79 $13.26 $10.00 $10.81 $7.69 $6.89 $8.78 $8.78 $8.78 -84.80% <-Total Growth 10 Stock Price US$
Increase 32.74% 57.59% 129.02% -58.47% 64.42% -6.90% -79.10% -3.84% -24.59% 8.10% -28.86% -10.40% 27.43% 0.00% 0.00% -17.17% <-IRR #YR-> 10 Stock Price -84.80% US$
P/E 44.02 41.08 45.93 13.06 16.45 10.41 6.21 -10.78 -0.89 -18.64 -8.94 -3.00 17.92 292.67 -22.51 -12.96% <-IRR #YR-> 5 Stock Price -50.04% US$
Trailing P/E 79.16 69.37 94.08 19.08 21.48 15.31 2.18 5.97 -8.13 -0.97 -13.26 -8.01 -3.82 17.92 292.67
Median 10, 5 Yrs Price Inc -10.40% P/E: 2.66 -8.94
-$45.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.89
-$13.79 $0.00 $0.00 $0.00 $0.00 $6.89
Price H/L US$ $24.35 $34.31 $88.64 $92.38 $60.51 $59.39 $38.31 $12.03 $11.02 $9.88 $8.54 $7.14 $9.04 -79.20% <-Total Growth 10 Stock Price US$
Increase 2.89% 40.89% 158.35% 4.21% -34.50% -1.85% -35.50% -68.61% -8.36% -10.39% -13.57% -16.40% 26.63% -14.53% <-IRR #YR-> 10 Stock Price -79.20% US$
P/E 37.27 31.10 39.22 27.99 14.04 9.37 17.25 -9.78 -0.99 -17.03 -9.92 -3.10 18.44 -28.55% <-IRR #YR-> 5 Stock Price -81.37% US$
Trailing P/E 67.02 52.52 80.34 40.87 18.34 13.78 6.04 5.42 -8.96 -0.88 -14.72 -8.30 -3.93
P/E on Run. 5 yr Ave 164.54 90.13 98.86 60.14 26.02 17.15 10.39 4.02 119.78 -11.15 -3.67 -2.21 -3.13
P/E on Run. 10 yr Ave 309.27 181.47 213.68 124.58 51.72 32.90 18.84 6.19 13.54 13.72 15.02 31.29 177.16 17.25 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -13.57% P/E: 4.19 -9.78 Count 21 Years of data
-$34.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.14
-$38.31 $0.00 $0.00 $0.00 $0.00 $7.14
US Month May Jan 07 Nov 07 Dec 08 Sep 09 Mar 10 Mar 11 Jan 13 Apr13 Jan 15 Mar 15 Sep 16 May 17
pre-split '05
pre-split '07 $88.71 $142.16
Price High US$ $29.57 $47.39 $133.03 $147.55 $85.77 $75.94 $64.09 $17.74 $16.29 $12.60 $11.05 $7.98 $11.39 -83.16% <-Total Growth 10 Stock Price US$
Increase -10.39% 60.25% 180.73% 10.91% -41.87% -11.46% -15.60% -72.32% -8.17% -22.65% -12.30% -27.78% 42.73% -16.32% <-IRR #YR-> 10 Stock Price -83.16% US$
P/E 45.26 42.95 58.86 44.71 19.90 11.98 28.87 -14.42 -1.46 -21.72 -12.85 -3.47 23.24 -34.08% <-IRR #YR-> 5 Stock Price -87.55% US$
Trailing P/E 81.39 72.53 120.57 65.29 25.99 17.62 10.11 7.99 -13.24 -1.13 -19.05 -9.28 -4.95 28.87 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -22.65% P/E: 5.26 -12.85 132.04 P/E Ratio Historical High
-$47.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.98
-$64.09 $0.00 $0.00 $0.00 $0.00 $7.98
US Month Oct Jun 06 Mar 07 Dec 09 Mar 09 Aug 10 Aug 11 Sep12 Dec 13 Apr 14 Sep 15 Jun 16 Mar 17
pre-split '05
pre-split '07 $57.40 $63.70
Price Low US$ $19.13 $21.23 $44.25 $37.20 $35.25 $42.84 $12.52 $6.31 $5.75 $7.15 $6.02 $6.29 $6.68 -70.38% <-Total Growth 10 Stock Price US$
Increase 33.49% 10.98% 108.40% -15.93% -5.24% 21.53% -70.77% -49.60% -8.87% 24.35% -15.80% 4.49% 6.20% -11.46% <-IRR #YR-> 10 Stock Price -70.38% US$
P/E 29.29 19.24 19.58 11.27 8.18 6.76 5.64 -5.13 -0.51 -12.33 -7.00 -2.73 13.63 -12.86% <-IRR #YR-> 5 Stock Price -49.76% US$
Trailing P/E 52.66 32.50 40.11 16.46 10.68 9.94 1.97 2.84 -4.67 -0.64 -10.38 -7.31 -2.90 8.18 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -8.87% P/E: 2.56 -5.13 -6.25 P/E Ratio Historical Low
-$21.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.29
-$12.52 $0.00 $0.00 $0.00 $0.00 $6.29
Long Term Debt US$ $1,707 $1,277 $591 $809 Debt US$
Change -25.19% -53.72% 36.89% -39.46% <-Median-> 2 Change US$
Long Term Debt CDN$ $2,135 $1,712 $783 $1,026 Debt CDN
Change -19.81% -54.27% 31.07% -37.04% <-Median-> 2 Change CDN
Ratio to Market Cap 0.30 0.32 0.16 0.17 0.30 <-Median-> 2 Debt/Market Cap Ratio CDN
Goodwill and Intangibles US$ $304 $3,430 $1,242 $1,451 $1,831 $1,161 $1,132 Intangibles Goodwill US$
Change 1028.29% -63.79% 16.83% 26.19% -36.59% -2.50% 16.83% <-Median-> 5 Change US$
Goodwill and Intangibles CDN$ $301 $3,522 $1,378 $1,815 $2,455 $1,538 $1,436 Intangibles Goodwill CDN
Change 1070.65% -60.88% 31.74% 35.26% -37.34% -6.64% 31.74% <-Median-> 5 Change CDN
Ratio to Market Cap 0.04 0.49 0.24 0.25 0.46 0.31 0.24 0.28 <-Median-> 6 % of Market C. CDN
Market Cap US$ $16,048 $25,273 $58,403 $24,410 $39,503 $34,570 $7,228 $6,950 $5,266 $5,716 $4,008 $3,655 $4,666 $4,666 $4,666 -85.54% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $18,600 $29,749 $57,689 $31,017 $41,549 $33,847 $7,129 $7,144 $5,818 $7,160 $5,373 $4,896 $5,921 $5,921 $5,921 -83.54% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 524.160 525.168 527.684 651.303 525.265 531.096 0.21% <-Total Growth 4 Diluted
Change 0.19% 0.48% 23.43% -19.35% 1.11% 0.00 <-Median-> 4 Change
Basic # of Shares in Millions 566.740 556.060 559.780 565.060 564.490 535.990 524.100 524.160 525.168 525.168 526.303 525.265 544.077 -5.54% <-Total Growth 10 Average
Change 0.67% -1.88% 0.67% 0.94% -0.10% -5.05% -2.22% 0.01% 0.19% 0.00% 0.22% -0.20% 3.58% 0.00 <-Median-> 10 Change
Difference -1.5% 0.3% 0.5% 0.2% -1.3% -2.3% 0.0% 0.0% 0.3% 0.7% -1.0% 1.0% -2.3% 0.00 <-Median-> 10 Difference
$700.00 <-12 mths 31.95%
pre-split '05
pre-split '07 186.002 185.871
# of Share in Millions 558.006 557.613 562.652 566.219 557.328 523.869 524.160 524.160 526.552 528.802 521.172 530.497 531.476 531.476 531.476 -0.50% <-IRR #YR-> 10 Shares -4.86% capital stock
Increase -1.84% -0.07% 0.90% 0.63% -1.57% -6.00% 0.06% 0.00% 0.46% 0.43% -1.44% 1.79% 0.18% 0.00% 0.00% 0.24% <-IRR #YR-> 5 Shares 1.21%
CF fr Op $M US$ $150.09 $735.67 $1,576.6 $1,451.8 $3,034.9 $4,009 $2,912 $2,303 -$159 $813 $257 -$224 $101 $191 $101 -130.45% <-Total Growth 10 Cash Flow US$
Increase -46.01% 390.15% 114.31% -7.91% 109.04% 32.10% -27.36% -20.91% -106.90% -611.32% -68.39% -187.16% -145.08% 89.47% -47.22% SO Buy Backs
5 year Running Average $102 $246 $561 $838 $1,390 $2,162 $2,597 $2,742 $2,420 $1,976 $1,225 $598 $158 $228 $85 143.02% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $0.27 $1.32 $2.80 $2.56 $5.45 $7.65 $5.56 $4.39 -$0.30 $1.54 $0.49 -$0.42 $0.19 $0.36 $0.19 -132.00% <-Total Growth 10 Cash Flow per Share US$
Increase -45.00% 390.49% 112.39% -8.49% 112.37% 40.53% -27.40% -20.91% -106.87% -609.15% -67.93% -185.63% -145.00% 89.47% -47.22% #NUM! <-IRR #YR-> 10 Cash Flow -130.45% US$
5 year Running Average $0.18 $0.44 $1.00 $1.49 $2.48 $3.96 $4.80 $5.12 $4.55 $3.77 $2.34 $1.14 $0.30 $0.43 $0.16 #NUM! <-IRR #YR-> 5 Cash Flow -107.69% US$
P/CF on Med Price 90.53 26.01 31.63 36.03 11.11 7.76 6.89 2.74 -36.49 6.42 17.31 -16.90 47.55 #NUM! <-IRR #YR-> 10 Cash Flow per Share -132.00% US$
P/CF on Closing Price 106.92 34.35 37.04 16.81 13.02 8.62 2.48 3.02 -33.12 7.03 15.59 -16.32 46.21 #NUM! <-IRR #YR-> 5 Cash Flow per Share -107.60% US$
530.62% Diff M/C 10.00% <-IRR #YR-> 10 CFPS 5 yr Running 159.28% US$
Excl.Working Capital CF $390.7 $142.6 -$130.8 $769.1 $161.0 $496.0 $210.0 -$485.0 -$1,259.0 -$59.0 -$113.0 $103.0 $0 $0 $0 -25.00% <-IRR #YR-> 5 CFPS 5 yr Running -76.27% US$
CF fr Op $M WC US$ $540.74 $878.25 $1,445.8 $2,221.0 $3,196 $4,505 $3,122 $1,818 -$1,418 $754 $144 -$121 $101 $191 $101 -113.78% <-Total Growth 10 Cash Flow less WC US$
Increase 296.55% 62.42% 64.62% 53.62% 43.90% 40.96% -30.70% -41.77% -178.00% -153.17% -80.90% -184.03% -183.45% 89.47% -47.22% #NUM! <-IRR #YR-> 10 Cash Flow less WC -113.78% US$
5 year Running Average $135 $315 $622 $1,044 $1,656 $2,449 $2,898 $2,972 $2,245 $1,756 $884 $235 -$108 $214 $83 #NUM! <-IRR #YR-> 5 Cash Flow less WC -103.88% US$
CFPS Excl. WC US$ $0.97 $1.58 $2.57 $3.92 $5.73 $8.60 $5.96 $3.47 -$2.69 $1.43 $0.28 -$0.23 $0.19 $0.36 $0.19 -2.87% <-IRR #YR-> 10 CF less WC 5 Yr Run -25.25% US$
Increase 303.97% 62.53% 63.15% 52.65% 46.19% 49.97% -30.74% -41.77% -177.64% -152.95% -80.62% -182.55% -183.30% 89.47% -47.22% -39.47% <-IRR #YR-> 5 CF less WC 5 Yr Run -91.88% US$
5 year Running Average $0.23 $0.56 $1.11 $1.86 $2.95 $4.48 $5.36 $5.54 $4.21 $3.35 $1.69 $0.45 -$0.21 $0.40 $0.16 #NUM! <-IRR #YR-> 10 CFPS - Less WC -114.48% US$
P/CF on Med Price 25.13 21.78 34.50 23.55 10.55 6.91 6.43 3.47 -4.09 6.93 30.89 -31.28 #NUM! <-IRR #YR-> 5 CFPS - Less WC -103.83% US$
P/CF on Closing Price 29.68 28.78 40.40 10.99 12.36 7.67 2.32 3.82 -3.71 7.58 27.83 -30.21 46.21 -2.12% <-IRR #YR-> 10 CFPS 5 yr Running -19.29% US$
CF/-WC P/CF Med 10 yr 7.33 5 yr 2.74 P/CF Med 10 yr 6.92 5 yr 3.47 568.18% Diff M/C -39.07% <-IRR #YR-> 5 CFPS 5 yr Running -91.60% US$
$887.95 <-12 mths 36.48%
CF fr Op $M CDN$ $170.58 $861.54 $1,544.4 $1,870.6 $3,201.2 $3,918 $2,882 $2,365 -$176 $1,017 $345 -$297 $128 $243 $128 -134.44% <-Total Growth 10 Cash Flow CDN$
Increase -50.61% 405.07% 79.26% 21.12% 71.13% 22.38% -26.44% -17.94% -107.46% -676.60% -66.12% -186.13% -143.16% 89.47% -47.22% SO Buy Backs
5 year Running Average $128 $293 $601 $959 $1,530 $2,279 $2,683 $2,847 $2,438 $2,001 $1,286 $651 $203 $287 $109 121.72% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $0.31 $1.55 $2.74 $3.30 $5.74 $7.48 $5.50 $4.51 -$0.33 $1.92 $0.66 -$0.56 $0.24 $0.46 $0.24 -136.21% <-Total Growth 10 Cash Flow per Share CDN$
Increase -49.69% 405.43% 77.66% 20.36% 73.86% 30.20% -26.48% -17.94% -107.42% -674.14% -65.62% -184.61% -143.09% 89.47% -47.22% #NUM! <-IRR #YR-> 10 Cash Flow -134.44% CDN$
5 year Running Average $0.23 $0.52 $1.07 $1.70 $2.73 $4.16 $4.95 $5.31 $4.58 $3.82 $2.45 $1.24 $0.39 $0.54 $0.21 #NUM! <-IRR #YR-> 5 Cash Flow -110.30% CDN$
P/CF on Med Price 93.79 25.50 31.35 29.58 12.22 8.25 7.23 2.67 -26.98 5.95 16.62 -16.71 50.66 #NUM! <-IRR #YR-> 10 Cash Flow per Share -136.21% CDN$
P/CF on Closing Price 109.04 34.53 37.35 16.58 12.98 8.64 2.47 3.02 -32.99 7.04 15.59 -16.50 46.22 #NUM! <-IRR #YR-> 5 Cash Flow per Share -110.17% CDN$
497.01% Diff M/C 8.99% <-IRR #YR-> 10 CFPS 5 yr Running 136.55% CDN$
Excl.Working Capital CF $444.0 $167.0 -$128.1 $990.9 $169.8 $484.7 $208 -$498 -$1,396 -$74 -$151 $136 $0.0 $0.0 $0.0 -24.19% <-IRR #YR-> 5 CFPS 5 yr Running -74.96% CDN$
CF fr Op $M WC CDN$ $614.6 $1,028.5 $1,416.3 $2,861.5 $3,371.0 $4,402.3 $3,090 $1,867 -$1,573 $943 $193 -$160 $128 $243 $128 -115.59% <-Total Growth 10 Cash Flow less WC CDN$
Increase 262.72% 67.36% 37.70% 102.04% 17.80% 30.59% -29.82% -39.58% -184.26% -159.96% -79.53% -183.03% -179.91% 89.47% -47.22% #NUM! <-IRR #YR-> 10 Cash Flow less WC -115.59% CDN$
5 year Running Average $151 $365 $675 $1,218 $1,858 $2,616 $3,028 $3,118 $2,231 $1,746 $904 $254 -$94 $269 $106 #NUM! <-IRR #YR-> 5 Cash Flow less WC -105.19% CDN$
CFPS Excl. WC CDN$ $1.10 $1.84 $2.52 $5.05 $6.05 $8.40 $5.89 $3.56 -$2.99 $1.78 $0.37 -$0.30 $0.24 $0.46 $0.24 -3.57% <-IRR #YR-> 10 CF less WC 5 Yr Run -30.44% CDN$
Increase 269.51% 67.48% 36.47% 100.77% 19.68% 38.93% -29.86% -39.58% -183.88% -159.71% -79.23% -181.57% -179.76% 89.47% -47.22% -39.09% <-IRR #YR-> 5 CF less WC 5 Yr Run -91.61% CDN$
5 year Running Average $0.26 $0.64 $1.20 $2.16 $3.31 $4.77 $5.58 $5.79 $4.18 $3.33 $1.72 $0.49 -$0.18 $0.51 $0.20 #NUM! <-IRR #YR-> 10 CFPS - Less WC -116.38% CDN$
P/CF on Med Price 26.03 21.36 34.19 19.33 11.61 7.35 6.74 3.38 -3.02 6.41 29.65 -30.94 #NUM! <-IRR #YR-> 5 CFPS - Less WC -105.13% CDN$
P/CF on Closing Price 30.27 28.92 40.73 10.84 12.33 7.69 2.31 3.83 -3.70 7.59 27.83 -30.55 46.22 24.39 46.22 -2.79% <-IRR #YR-> 10 5 yr Running -24.68% CDN$
*Operational Cash Flow per share CDN$ CF/-WC P/CF Med 10 yr 7.74 5 yr 2.67 P/CF Med 10 yr 7.04 5 yr 3.38 556.13% Diff M/C -38.65% <-IRR #YR-> 5 5 yr Running -91.31% CDN$
-$1.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.56 Cash Flow per Share CDN$
-$5.50 $0.00 $0.00 $0.00 $0.00 -$0.56 Cash Flow per Share CDN$
-$0.52 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.24 CFPS 5 yr Running CDN$
-$4.95 $0.00 $0.00 $0.00 $0.00 $1.24 CFPS 5 yr Running CDN$
-$1,029 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$160 Cash Flow less WC CDN$
-$3,090 $0 $0 $0 $0 -$160 Cash Flow less WC CDN$
-$365 $0 $0 $0 $0 $0 $0 $0 $0 $0 $254 CF less WC 5 Yr Run CDN$
-$3,028 $0 $0 $0 $0 $254 CF less WC 5 Yr Run CDN$
-$1.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.30 CFPS - Less WC CDN$
-$5.89 $0.00 $0.00 $0.00 $0.00 -$0.30 CFPS - Less WC CDN$
-$0.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.49 CFPS 5 yr Running CDN$
-$5.58 $0.00 $0.00 $0.00 $0.00 $0.49 CFPS 5 yr Running CDN$
Accounts receivable, net $1,381 $469 $200 $157
Other receivables $124 $55 $47 $17
Inventories $359 $123 -$21 $117
Income tax receivable $224 $204 $166 -$17
Other current assets -$26 $116 $257 $45
Accounts payable -$590 -$240 $14 -$167
Accrued liabilities -$251 -$550 -$304 -$99
Income taxes payable $9 -$9
Deferred revenue $38 -$118 -$255 -$147
$1,259 $59 $113 -$103
Google $1,259 $59 $113 -$103
$0 $0 $0 $0
OPM 7.27% 24.22% 26.24% 13.12% 20.30% 20.14% 15.80% 20.80% -2.33% 24.38% 11.90% -17.11% -170.65% <-Total Growth 10 OPM CDN$
Increase -64.70% 233.40% 8.31% -49.99% 54.68% -0.77% -21.56% 31.67% -111.22% -1144.57% -51.19% -243.82% Should increase or be stable.
Diff from Ave. -59.6% 34.8% 46.0% -27.0% 13.0% 12.1% -12.1% 15.8% -113.0% 35.7% -33.8% -195.2% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 17.97% 5 Yrs 11.90% should be zero, it is a check on calculations
Current Assets US$ $1,256.6 $1,919.3 $3,477.3 $4,842 $5,813 $7,488 $7,056 $7,101 $5,057 $4,167 $3,011 $1,691 $2,464 Liquidity ratio of 1.5 and up, best US$
Current Liabilities $278.7 $546.6 $1,474.4 $2,115 $2,432 $3,630 $3,389 $3,448 $2,268 $1,363 $1,039 $606 $463 2.34 <-Median-> 10 Ratio US$
Liquidity Ratio 4.51 3.51 2.36 2.29 2.39 2.06 2.08 2.06 2.23 3.06 2.90 2.79 5.32 2.90 <-Median-> 5 Ratio US$
Assets US$ $2,312.2 $3,088.9 $5,511.2 $8,101 $10,204 $12,875 $13,731 $13,165 $7,552 $6,549 $5,534 $3,263 $4,019 Debt Ratio of 1.5 and up, best US$
Liabilities $313.4 $605.4 $1,577.6 $2,227 $2,602 $3,937 $3,631 $3,705 $3,927 $3,118 $2,326 $1,206 $1,281 3.20 <-Median-> 10 Ratio US$
Debt Ratio 7.38 5.10 3.49 3.64 3.92 3.27 3.78 3.55 1.92 2.10 2.38 2.71 3.14 2.38 <-Median-> 5 Ratio US$
Book Value US$ $1,999 $2,484 $3,934 $5,874 $7,603 $8,938 $10,100 $9,460 $3,625 $3,431 $3,208 $2,057 $2,738 $2,738 $2,738 -17.17% <-Total Growth 10 Book Value US$
Book Value per Share $3.58 $4.45 $6.99 $10.37 $13.64 $17.06 $19.27 $18.05 $6.88 $6.49 $6.16 $3.88 $5.15 $5.15 $5.15 -12.94% <-Total Growth 10 Book Value per Share US$
Change 2.65% 24.34% 56.97% 48.39% 31.49% 25.07% 12.94% -6.34% -61.85% -5.75% -5.13% -37.01% 32.86% 0.00% 0.00% -10.96% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 6.80 7.70 12.68 8.90 4.44 3.48 1.99 0.67 1.60 1.52 1.39 1.84 1.75 3.48 P/B Ratio Historical Median US$
P/B Ratio (Close) 8.03 10.18 14.85 4.16 5.20 3.87 0.72 0.73 1.45 1.67 1.25 1.78 1.70 1.70 1.70 -1.38% <-IRR #YR-> 10 Book Value per Share -12.94% US$
Change 29.31% 26.74% 45.90% -72.01% 25.04% -25.56% -81.50% 2.66% 97.70% 14.70% -25.01% 42.23% -4.09% 0.00% 0.00% -27.43% <-IRR #YR-> 5 Book Value per Share -79.88% US$
Leverage (A/BK) 1.16 1.24 1.40 1.38 1.34 1.44 1.36 1.39 2.08 1.91 1.73 1.59 1.47 1.42 <-Median-> 10 A/BV US$
Debt/Equity Ratio 0.16 0.24 0.40 0.38 0.34 0.44 0.36 0.39 1.08 0.91 0.73 0.59 0.47 0.42 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.91 5 yr Med 1.52 -10.96% Diff M/C 1.32 Historical 21 A/BV US$
-$4.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.88
-$19.27 $0.00 $0.00 $0.00 $0.00 $3.88
Current Assets CDN$ $1,428.1 $2,247.7 $3,406.4 $6,238 $6,131 $7,317 $6,983 $7,291 $5,609 $5,212 $4,037 $2,240 $3,126 Liquidity ratio of 1.5 and up, best CDN$
Current Liabilities $316.7 $640.1 $1,444.4 $2,725 $2,565 $3,547 $3,354 $3,540 $2,516 $1,705 $1,393 $803 $587 2.34 <-Median-> 10 Ratio CDN$
Liquidity Ratio 4.51 3.51 2.36 2.29 2.39 2.06 2.08 2.06 2.23 3.06 2.90 2.79 5.32 2.90 <-Median-> 5 Ratio CDN$
Assets CDN$ $2,627.8 $3,617.5 $5,398.8 $10,438.0 $10,763.5 $12,581 $13,588 $13,517 $8,377 $8,191 $7,419 $4,323 $5,098 Debt Ratio of 1.5 and up, best CDN$
Liabilities $356.2 $709.0 $1,545.4 $2,869.6 $2,744.3 $3,847.2 $3,593.2 $3,804.1 $4,356 $3,900 $3,118 $1,598 $1,625 3.20 <-Median-> 10 Ratio CDN$
Debt Ratio 7.38 5.10 3.49 3.64 3.92 3.27 3.78 3.55 1.92 2.10 2.38 2.71 3.14 2.38 <-Median-> 5 Ratio CDN$
Book Value CDN$ $2,272 $2,908 $3,853 $7,568 $8,019 $8,734 $9,995 $9,713 $4,021 $4,291 $4,301 $2,725 $3,473 $3,473 $3,473 -6.30% <-Total Growth 10 Book Value CDN$
Book Value per Share $4.07 $5.22 $6.85 $13.37 $14.39 $16.67 $19.07 $18.53 $7.64 $8.12 $8.25 $5.14 $6.53 $6.53 $6.53 -1.51% <-Total Growth 10 Book Value per Share CDN$
Change -6.11% 28.12% 31.30% 95.17% 7.65% 15.87% 14.37% -2.82% -58.79% 6.28% 1.69% -37.75% 27.22% 0.00% 0.00% -12.69% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 7.04 7.55 12.57 7.31 4.88 3.70 2.08 0.65 1.18 1.41 1.33 1.82 1.87 3.70 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 8.19 10.23 14.97 4.10 5.18 3.88 0.71 0.74 1.45 1.67 1.25 1.80 1.70 1.70 1.70 -0.15% <-IRR #YR-> 10 Book Value per Share -1.51% CDN$
Change 31.49% 24.92% 46.37% -72.63% 26.42% -25.21% -81.60% 3.13% 96.74% 15.30% -25.12% 43.82% -5.13% 0.00% 0.00% -23.07% <-IRR #YR-> 5 Book Value per Share -73.06% CDN$
Leverage (A/BK) 1.16 1.24 1.40 1.38 1.34 1.44 1.36 1.39 2.08 1.91 1.73 1.59 1.47 1.42 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 0.16 0.24 0.40 0.38 0.34 0.44 0.36 0.39 1.08 0.91 0.73 0.59 0.47 0.42 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.95 5 yr Med 1.33 -12.69% Diff M/C 1.32 Historical 21 A/BV
-$5.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.14
-$19.07 $0.00 $0.00 $0.00 $0.00 $5.14
$125 <-12 mths 110.29%
Total Comprehensive Income US$ $1,864 $2,507 $3,350 $1,214 -$690 -$5,877 -$319 -$193 -$1,215 -165.18% <-Total Growth 8 Comprehensive Income US$
Increase 34.50% 33.63% -63.76% -156.84% -751.74% 94.57% 39.50% -529.53% -156.8% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $1,649 $101 -$464 -$1,173 -$1,659 #NUM! <-IRR #YR-> 8 Comprehensive Income #DIV/0! US$
ROE US$ 31.7% 33.0% 37.5% 12.0% -7.3% -162.1% -9.3% -6.0% -59.1% #NUM! <-IRR #YR-> 5 Comprehensive Income -200.08% US$
5Yr Median 33.0% 32.4% 31.7% 12.0% -7.3% -7.3% -9.3% #NUM! <-IRR #YR-> 5 5 Yr Running Average #DIV/0! US$
% Difference from NI -1.5% 2.0% -1.8% 4.3% 6.8% 0.1% 4.9% -7.2% 0.7% #NUM! <-IRR #YR-> 5 5 Yr Running Average #DIV/0! US$
Median Values Diff 5, 10 yr 1.0% 4.3% 0.7% -9.3% <-Median-> 5 Return on Equity US$
-$1,864 $0 $0 $0 $0 $0 $0 $0 -$1,215
-$1,214 $0 $0 $0 $0 -$1,215
$0 $0 $0 $0 $0 -$1,659
$0 $0 $0 $0 $0 -$1,659
Current Liability Coverage Ratio 1.94 1.61 0.98 1.05 1.31 1.24 0.92 0.53 -0.63 0.55 0.14 -0.20 CFO / Current Liabilities US$
5 year Median 0.51 0.98 1.05 1.31 1.24 1.05 1.05 0.92 0.55 0.53 0.14 0.14 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio 23.39% 28.43% 26.23% 27.41% 31.32% 34.99% 22.74% 13.81% -18.78% 11.51% 2.60% -3.71% CFO / Total Assets US$
5 year Median 5.20% 5.56% 23.39% 26.23% 27.41% 28.43% 27.41% 27.41% 22.74% 13.81% 11.51% 2.60% 2.6% <-Median-> 5 Return on Assets US$
Return on Assets US$ 16.5% 20.4% 23.5% 23.4% 24.1% 26.5% 8.5% -4.9% -77.8% -4.6% -3.8% -37.0% Net Income/Assets ROA US$
5Yr Median 2.7% 8.1% 16.5% 20.4% 23.4% 23.5% 23.5% 23.4% 8.5% -4.6% -4.6% -4.9% -4.9% <-Median-> 5 ROA US$
ROE US$ 19.1% 25.4% 32.9% 32.2% 32.3% 38.2% 11.5% -6.8% -162.0% -8.9% -6.5% -58.6% Net Inc/ Shareholders' equity ROE US$
5Yr Median 3.0% 10.8% 19.1% 25.4% 32.2% 32.3% 32.3% 32.2% 11.5% -6.8% -6.8% -8.9% -8.9% <-Median-> 5 ROE US$
-$1,944 <-12 mths -61.19%
Net Income US$ $382.08 $632 $1,294 $1,893 $2,457 $3,411 $1,164 -$646 -$5,873 -$304 -$208 -$1,206 $424 -$87 -$219 -290.95% <-Total Growth 10 Net Income US$
Increase 79.05% 65.30% 104.86% 46.28% 29.83% 38.82% -65.88% -155.50% 809.13% -94.82% -31.58% 479.81% -135.16% -120.42% 152.89% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $94.0 $226.0 $514.5 $882.7 $1,331.5 $1,937.2 $2,043.7 $1,655.8 $102.6 -$449.6 -$1,173.4 -$1,647.4 -$1,433.4 -$276.1 -$259.1 #NUM! <-IRR #YR-> 10 Net Income -290.95% US$
Operating Cash Flow $150.09 $735.67 $1,577 $1,452 $3,035 $4,009 $2,912 $2,303 -$159 $813 $257 -$224 #NUM! <-IRR #YR-> 5 Net Income -203.61% US$
Investment Cash Flow $67.32 -$365 -$1,154 -$542 -$1,470 -$1,470 -$3,024 -$2,240 -$1,040 -$1,173 -$439 $724 #NUM! <-IRR #YR-> 10 5 Yr Running Average -828.93% US$
Total Accruals $164.66 $260 $871 $983 $892 $872 $1,276 -$709 -$4,674 $56 -$26 -$1,706 #NUM! <-IRR #YR-> 5 5 Yr Running Average -180.61% US$
Total Assets $2,312.16 $3,089 $5,511 $8,101 $10,204 $12,875 $13,731 $13,165 $7,552 $6,549 $5,534 $3,263 Balance Sheet Assets US$
Accruals Ratio 7.12% 8.43% 15.80% 12.14% 8.75% 6.77% 9.29% -5.39% -61.89% 0.86% -0.47% -52.28% -5.39% <-Median-> 5 Ratio US$
-$632 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$1,206
-$1,164 $0 $0 $0 $0 -$1,206
-$226 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$1,647
-$2,044 $0 $0 $0 $0 -$1,647
EPS/CF Ratio 0.67 0.70 0.88 0.84 0.75 0.74 0.37 -0.35 4.15 -0.41 -3.11 10.08
Financial Cash Flow $53.95 -$153.66 $80.40 -$11.93 -$843 -$843 -$149 -$36 $1,224 $16 -$78 -$722 C F Statement Financial Cash Flow US$
Total Accruals $110.71 $414.14 $790 $995 $1,736 $1,716 $1,425 -$673 -$5,898 $40 $52 -$984 Accruals US$
Accruals Ratio 4.79% 13.41% 14.34% 12.28% 17.01% 13.32% 10.38% -5.11% -78.10% 0.61% 0.94% -30.16% -5.11% <-Median-> 5 Ratio US$
$159 <-12 mths 109.85%
Total Comprehensive Income CDN$ $2,402 $2,644 $3,274 $1,201 -$708 -$6,519 -$399 -$259 -$1,610 -167.02% <-Total Growth 8 Comprehensive Income CDN$
Increase 10.11% 23.80% -63.30% -158.97% -820.14% 93.88% 35.15% -522.07% -159.0% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $1,763 -$22 -$630 -$1,337 -$1,899 #NUM! <-IRR #YR-> 8 Comprehensive Income -167.02% CDN$
ROE CDN$ 31.7% 33.0% 37.5% 12.0% -7.3% -162.1% -9.3% -6.0% -59.1% #NUM! <-IRR #YR-> 5 Comprehensive Income -233.98% CDN$
5Yr Median 33.0% 32.4% 31.7% 12.0% -7.3% -7.3% -9.3% #NUM! <-IRR #YR-> 5 5 Yr Running Average #DIV/0! CDN$
% Difference from NI -1.5% 2.0% -1.8% 4.3% 6.8% 0.1% 4.9% -7.2% 0.7% #NUM! <-IRR #YR-> 5 5 Yr Running Average #DIV/0! CDN$
Median Values Diff 5, 10 yr 0.7% 0.7% -9.3% <-Median-> 5 Return on Equity CDN$
-$2,402 $0 $0 $0 $0 $0 $0 $0 -$1,610
-$1,201 $0 $0 $0 $0 -$1,610
$0 $0 $0 $0 $0 -$1,899
$0 $0 $0 $0 $0 -$1,899
Current Liability Coverage Ratio 1.94 1.61 0.98 1.05 1.31 1.24 0.92 0.53 -0.63 0.55 0.14 -0.20 CFO / Current Liabilities CDN$
5 year Median 0.51 0.98 1.05 1.31 1.24 1.05 1.05 0.92 0.55 0.53 0.14 0.14 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio 23.39% 28.43% 26.23% 27.41% 31.32% 34.99% 22.74% 13.81% -18.78% 11.51% 2.60% -3.71% CFO / Total Assets CDN$
5 year Median 5.20% 5.56% 23.39% 26.23% 27.41% 28.43% 27.41% 27.41% 22.74% 13.81% 11.51% 2.60% 2.6% <-Median-> 5 Return on Assets CDN$
Return on Assets 16.5% 20.4% 23.5% 23.4% 24.1% 26.5% 8.5% -4.9% -77.8% -4.6% -3.8% -37.0% Net Income/Assets ROA CDN$
5Yr Median 2.7% 8.1% 16.5% 20.4% 23.4% 23.5% 23.5% 23.4% 8.5% -4.6% -4.6% -4.9% -4.9% <-Median-> 5 ROA CDN$
ROE CDN$ 19.1% 25.4% 32.9% 32.2% 32.3% 38.2% 11.5% -6.8% -162.0% -8.9% -6.5% -58.6% Net Inc/ Shareholders' equity ROE CDN$
5Yr Median 3.0% 10.8% 19.1% 25.4% 32.2% 32.3% 32.3% 32.2% 11.5% -6.8% -6.8% -8.9% -8.9% <-Median-> 5 ROE CDN$
-$2,466 <-12 mths -54.34%
Net Income CDN$ $434.2 $739.6 $1,267.5 $2,438.5 $2,591.8 $3,333 $1,152 -$663 -$6,514 -$380 -$279 -$1,598 $538 -$110 -$278 -316.01% <-Total Growth 10 Net Income CDN$
Increase 63.78% 70.33% 71.36% 92.39% 6.29% 28.61% -65.44% -157.58% 882.14% -94.16% -26.66% 472.93% -133.66% -120.42% 152.89% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $98 $257 $555 $1,029 $1,494 $2,074 $2,157 $1,770 -$20 -$615 -$1,337 -$1,887 -$1,647 -$366 -$345 #NUM! <-IRR #YR-> 10 Net Income -316.01% CDN$
Operating Cash Flow $170.6 $861.5 $1,544.4 $1,870.6 $3,201.2 $3,917.6 $2,881.7 $2,364.6 -$176.4 $1,016.9 $344.6 -$296.8 #NUM! <-IRR #YR-> 5 Net Income -238.70% CDN$
Investment Cash Flow $76.5 -$427.0 -$1,130.0 -$698.9 -$1,550.7 -$1,437 -$2,993 -$2,300 -$1,154 -$1,467 -$589 $959 #NUM! <-IRR #YR-> 10 5 Yr Running Average -832.81% CDN$
Total Accruals $187.1 $305.0 $853.1 $1,266.8 $941.3 $852.2 $1,262.7 -$728.0 -$5,184.4 $70.0 -$34.9 -$2,260.1 #NUM! <-IRR #YR-> 5 5 Yr Running Average -187.49% CDN$
Total Assets $2,627.8 $3,617.5 $5,398.8 $10,438.0 $10,763.5 $12,581 $13,588 $13,517 $8,377 $8,191 $7,419 $4,323 Balance Sheet Assets CDN$
Accruals Ratio 7.12% 8.43% 15.80% 12.14% 8.75% 6.77% 9.29% -5.39% -61.89% 0.86% -0.47% -52.28% -5.39% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.67 0.70 0.88 0.84 0.75 0.74 0.37 -0.35 4.15 -0.41 -3.11 10.08 0.74 <-Median-> 10 EPS/CF Ratio CDN$
-$740 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$1,598
-$1,152 $0 $0 $0 $0 -$1,598
-$257 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$1,887
-$2,157 $0 $0 $0 $0 -$1,887
Financial Cash Flow $61.3 -$180.0 $78.8 -$15.4 -$889.6 -$824.2 -$147.5 -$37.0 $1,357.7 $20.0 -$104.6 -$956.5 C F Statement Financial Cash Flow CDN$
Total Accruals $125.8 $485.0 $774.3 $1,282.2 $1,830.9 $1,676.4 $1,410.2 -$691.0 -$6,542.1 $50.0 $69.7 -$1,303.6 Accruals CDN$
Accruals Ratio 4.79% 13.41% 14.34% 12.28% 17.01% 13.32% 10.38% -5.11% -78.10% 0.61% 0.94% -30.16% -5.11% <-Median-> 5 Ratio CDN$
Cash US$ $1,184.4 $835.6 $1,551.0 $1,791.0 $1,527 $1,549 $1,579 $1,233 $957 $734 $933 Cash US$
Cash per Share $2.11 $1.48 $2.78 $3.42 $2.91 $2.96 $3.00 $2.33 $1.84 $1.38 $1.76 $2.33 <-Median-> 5 Cash per Share US$
Percentage of Stock Price 2.03% 3.42% 3.93% 5.18% 21.13% 22.29% 29.99% 21.57% 23.88% 20.08% 19.99% 22.29% <-Median-> 5 % of Stock Price US$
Cash CDN$ $1,160.2 $1,076.5 $1,636.0 $1,750.2 $1,511 $1,590 $1,751 $1,542 $1,283 $972 $1,184 Cash CDN$
Cash per Share $2.06 $1.90 $2.94 $3.34 $2.88 $3.03 $3.33 $2.92 $2.46 $1.83 $2.23 $2.92 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 2.01% 3.47% 3.94% 5.17% 21.20% 22.26% 30.10% 21.54% 23.88% 19.86% 19.99% 22.26% <-Median-> 5 % of Stock Price CDN$
Notes:
August 13, 2017. Last estimates were for 2017, 2018 and 2019 of $1681M, $1566M and $1488M US$ for Revenue, -$0.88, -$0.19 and -$0.27 for EPS US$,
$0.36, $0.17 and $0.27 for CFPS, -$617M, -$182M and -$142M for Net Income US$.
August 14, 2016. There is a difference in basic and diluted EPSThe first was a loss of $0.40 and the second was a loss of $0.86. The difference is because the company
used the dilutive effect of the Debentures using the if-converted method, assuming conversion at the beginning of fiscal 2016 for the year ended February 29, 2016.
August 14, 2016. Last estimates were for 2016, 2017 and 2018 of $3027M, $2538M and $1809M for Revenue US$, -$0.05, -$0.07 and -$0.37 for EPS US$,
$1.13, $1.35 and -$0.27 for CFPS US$ and -$103M, -$83M and -$138M for Net Income US$.
August 15, 2015. Last estimates were for 2015 and 2016 of $3420M and $5384M US$ for Revenue, -$0.68 and -$0.10 US$ for EPS, $1.58, and $1.07 US$ for CFPS,
-$373M and -$157M US$ for Net Income.
July 27, 2014. Last estimates were for 2014, 2015 and 2016 of $12.406M, 11080M and $12120M US$ for Revenue, $0.23, -.04 and $0.89 US$ for EPS, $2.65, $2.76 and $1.66 US$ for CFPS.
June 15, 2013. Last estimates for for 2012 and 2013 of 18,879M and $17,877M US$ for Revenue, $4.11 and $2.93 US$ for EPS and $5.77 and $4.70 US$ for CFPS.
Effective the start of trading on Monday, February 4, 2013, the ticker symbol for Research In Motion will change to BB on the Toronto Stock Exchange and BBRY on the NASDAQ.
Old Symbols were RIM for Toronto and RIMM for Nasdaq.
Feb 5, 2012. Last estimates I got were $5.66 and $5.90 US$ for EPS and $7.20 and $7.36US$ for Cash Flow.
With the reports of 2011, you can see net income going down quarter by quarter. Same with Cash Flow.
May 28, 2010. When I last looked at this stock, I got estimates for 1010 and 2010 of $4.24 and $5.20US$ for earnings and $4.35 and $4.23 for CF US$
Nov 11, 2009. When I looked at this stock in Jun 2009, I got earnings for 2010 and 2011 of $4.10 and $4.90 US$ ($4.75 and $5.68 CDN$ at exch of 1.1588)
June 23, 2009. when I looked at this stock in Sep 2008 I got estimates earnings for 2009 of $3.30US$ and 2010 $3.82 US$. Earnings did come in at $3.30US$ for 2009.
AP 2008 - This stock is still doing very well. P/E is still very high. Accrual Ratio is also high, but it has not been predictive of stock movement. This stock is going to continue to go up well it is
highly liked my the market.
AR 2007- It has done much better in US $ than CDN$. However, it is still making money, but P/E is very high.
AR 2005 P/E is really high again. Seems to be doing ok at present.
AR 2004 I know it was a high risk tech stock when I bought it. It might still do fine.
IPO Oct 28, 1997 Fiscal Year in 2002 = March 2, 2002
Sector:
Tech
What should this stock accomplish?
Would I buy this company and Why.
Not now. I think that this is not a stock I could profit from owning at this time.
Why am I following this stock.
I always liked tech stocks and this was a fast rising tech stock when I bought it.
Dividends
No dividends
Why I bought this stock.
I bought this stock for capital gain. I first bought it in 1999 and then some more in 2000. I sold some in 2006 and 2007 to lock in some profit.
I sold the rest of my stock in 2010.
How they make their money
BlackBerry Limited provides mobile communications solutions. The Company is engaged in the sale of smartphones and enterprise software and services
Based in Waterloo, Ontario, BlackBerry operates offices in North America, Europe, Middle East and Africa, Asia-Pacific, and Latin America.
Mike Lazaridis owns almost 6% of the outstanding shares and is selling them off. Part of this sell off goes to Charity. He was co-founder of company with Jim Balsillie. Jim owns almost as much as Mike does.
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 %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
On Jul 27 2014 Feb 5 2012 Jun 16 2013 Jul 27 2014 Aug 16 2015 Aug 14 2016 Aug 13 2017
Chen, John 0.050 0.01% 0.050 0.01% 0.104 0.02% 1.931 0.36%
CEO & Chairman $0.677 $0.516 $0.964 $21.51
Options - percentage 13.000 2.46% 13.116 2.52% 13.317 2.51% 9.750 1.83%
Options - amount $176.020 $135.222 $122.92 $108.61
Heins, Thorsten Gerhard 0.101 0.02%
CEO - Shares - Amount $1.112
Options - percentage 1.549 0.29%
Options - amount $17.121
Capelli, Steven 0.000 0.00%
CFO - Shares - Amount $0.00
Options - percentage 0.472 0.09%
Options - amount $5.26
Yersh, James 0.036 0.01% 0.087 0.02% 0.147 0.03%
CFO - Shares - Amount $0.486 $0.899 $1.35
Options - percentage 0.307 0.06% 0.349 0.07% 0.375 0.07%
Options - amount $4.159 $3.597 $3.46
Bidulka, Brian Joseph 0.017 0.00%
CFO - Shares - Amount $0.186
Options - percentage 0.431 0.08%
Options - amount $4.758
Beard, Martin James 0.015 0.00% 0.068 0.01% 0.123 0.02%
Officer - Shares - Amount $0.160 $0.62 $1.37
Options - percentage 0.383 0.07% 0.398 0.07% 0.346 0.07%
Options - amount $3.950 $3.67 $3.85
Arabia, Carmine 0.000 0.00% 0.000 0.00%
Officer - Shares - Amount $0.000 $0.000
Options - percentage 0.015 0.00% 0.015 0.00%
Options - amount $0.166 $0.203
Dattels, Timothy 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Director - Shares - Amount $0.000 $0.000 $0.000 $0.00 $0.00
Options - percentage 0.036 0.01% 0.098 0.02% 0.115 0.02% 0.135 0.03% 0.154 0.03%
Options - amount $0.397 $1.326 $1.186 $1.25 $1.71
Watsa, V. Prem 0.129 0.02% 0.129 0.02% 0.129 0.02% 0.129 0.02% Watsa is head of
Director - Shares - Amount $1.747 $1.330 $1.19 $1.44 Fairfax
Options - percentage 0.013 0.00% 0.032 0.01% 0.054 0.01% 0.075 0.01%
Options - amount $0.178 $0.330 $0.50 $0.83
Chairman - see above
Fairfax Financial Holdings Limited 46.655 8.82% 46.725 8.97% 46.725 8.81% 48.659 9.16%
10% holder _Watsa $631.705 $481.732 $431.27 $542.06
Convertible Debentures $500.000 $464.88 $464.88 6.00%
Increase in O/S Shares 0.650 0.12% 2.697 0.51% 5.393 1.03% 2.250 0.43% 4.794 0.92% 8.689 1.64%
due to SO $41.997 $36.679 $73.507 $24.863 $49.426 $80.199
Book Value $106.000 $86.000 $71.000 $26.000 $63.000 $59.000 Includes stock based
Insider Buying $0.000 $0.000 -$0.149
Insider Selling $3.638 -$5.845 $30.869
Net Insider Selling $0.934 $3.638 -$5.845 $30.720 compenstion
% of Market Cap 0.01% 0.05% -0.08% 0.43%
RSU - restricted share Units
Directors 11 6 7 8 8
Women 2 18% 2 33% 2 29% 2 25% 2 25%
Minorities 0 0% 1 17% 1 14% 1 13% 1 13%
Institutions/Holdings 492 60.35% 381 56.31% 247 60.29% 531 63.48%
Total Shares Held 316.327 60.08% 296.765 56.12% 315.104 59.40% 337.091 63.54%
Increase/Decrease -11.300 -3.45% -1.841 -0.62% 2.565 0.82% 11.964 3.68%
Starting No. of Shares 327.628 298.606 312.539 Nasdaq 325.127 Nasdaq
Copyright 2008 Website of SPBrunner. All rights reserved.
My stock