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/ Q3 2016
WiLan Inc. TSX: WIN NASDAQ: WILN www.wi-lan.com Fiscal Yr: Oct 31
Year 10/31/04 10/31/05 10/31/06 10/31/07 10/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 Value Description #Y Item Curr
Accounting Rules C GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP Accounting Rules
$88.707 <-12 mths -13.76%
Revenue* US$ $20.762 $21.453 $1.878 $64.502 $21.012 $33.378 $50.877 $105.809 $87.960 $88.209 $98.311 $102.855 $81.30 $72.20 379.45% <-Total Growth 10 Revenue US$
Increase 2.12% 3.33% -91.25% 3335.29% -67.42% 58.86% 52.43% 107.97% -16.87% 0.28% 11.45% 4.62% -20.96% -11.19% 16.97% <-IRR #YR-> 10 Revenue US$
5 year Running Average $16.431 $18.625 $15.874 $25.785 $25.921 $28.444 $34.329 $55.115 $59.807 $73.247 $86.233 $96.629 $91.727 $88.575 15.12% <-IRR #YR-> 5 Revenue US$
Revenue per Share $0.50 $0.51 $0.03 $0.69 $0.21 $0.33 $0.46 $0.86 $0.72 $0.74 $0.82 $0.85 $0.69 $0.61 17.90% <-IRR #YR-> 10 5 yr Running Average US$
Increase -6.28% 2.32% -93.95% 2145.57% -69.21% 53.96% 41.76% 85.16% -15.71% 1.65% 11.14% 4.11% -19.36% -11.19% 23.00% <-IRR #YR-> 5 5 yr Running Average US$
5 year Running Average $0.500 $0.511 $0.410 $0.451 $0.388 $0.354 $0.345 $0.510 $0.517 $0.622 $0.720 $0.797 $0.763 $0.740 5.30% <-IRR #YR-> 10 Revenue per Share US$
P/S (Price/Sales) Med 12.92% <-IRR #YR-> 5 Revenue per Share US$
P/S (Price/Sales) Close 2.52 1.24 130.16 3.84 5.41 7.52 13.87 6.69 6.27 4.58 3.66 1.55 2.00 4.54% <-IRR #YR-> 10 5 yr Running Average US$
*Revenue in M CDN $ P/S Med 10 yr 5.84 5 yr 4.58 -65.84% Diff M/C 18.25% <-IRR #YR-> 5 5 yr Running Average US$
$117.963 <-12 mths -17.18%
Revenue* $25.336 $25.300 $2.108 $61.270 $25.564 $35.051 $50.725 $108.066 $87.811 $93.819 $114.051 $142.428 $108.11 $96.01 462.96% <-Total Growth 10 Revenue CDN$
Increase -5.50% -0.14% -91.67% 2806.55% -58.28% 37.11% 44.72% 113.04% -18.74% 6.84% 21.56% 24.88% -24.09% -11.19% 18.86% <-IRR #YR-> 10 Revenue CDN$
5 year Running Average $23.256 $25.114 $20.576 $28.165 $27.916 $29.859 $34.944 $56.135 $61.443 $75.094 $90.894 $109.235 $109.244 $110.884 22.93% <-IRR #YR-> 5 Revenue CDN$
Revenue per Share $0.61 $0.60 $0.03 $0.66 $0.26 $0.34 $0.46 $0.88 $0.72 $0.78 $0.95 $1.18 $0.91 $0.81 15.84% <-IRR #YR-> 10 5 yr Running Average CDN$
Increase -13.27% -1.11% -94.24% 1799.94% -60.57% 32.89% 34.59% 89.68% -17.61% 8.30% 21.22% 24.27% -22.56% -11.19% 25.60% <-IRR #YR-> 5 5 yr Running Average CDN$
5 year Running Average $0.72 $0.70 $0.54 $0.52 $0.43 $0.38 $0.35 $0.52 $0.53 $0.64 $0.76 $0.90 $0.91 $0.93 7.00% <-IRR #YR-> 10 Revenue per Share CDN$
P/S (Price/Sales) Med 5.53 1.50 41.88 7.48 10.64 5.53 9.79 8.31 7.25 5.16 3.92 2.23 20.58% <-IRR #YR-> 5 Revenue per Share CDN$
P/S (Price/Sales) Close 2.61 1.37 54.20 4.36 4.87 6.35 13.84 6.69 6.27 4.54 3.67 1.57 1.99 2.25 2.53% <-IRR #YR-> 10 5 yr Running Average CDN$
*Revenue in M CDN $ P/S Med 10 yr 7.37 5 yr 5.16 -72.94% Diff M/C 20.78% <-IRR #YR-> 5 5 yr Running Average CDN$
-$25.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $142.4
-$50.7 $0.0 $0.0 $0.0 $0.0 $142.4
-$25.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $109.2
-$34.9 $0.0 $0.0 $0.0 $0.0 $109.2
-$0.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.18
-$0.46 $0.00 $0.00 $0.00 $0.00 $1.18
-$0.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.90
-$0.35 $0.00 $0.00 $0.00 $0.00 $0.90
$0.04 <-12 mths -50.00%
EPS Basic U$ -$0.14 -$0.52 $0.26 $0.38 -$0.08 -$0.02 -$0.21 $0.26 -$0.12 -$0.15 $0.08 $0.08 115.47% <-Total Growth 10 EPS Basic US$
EPS Diluted* -$0.14 -$0.52 $0.26 $0.36 -$0.08 -$0.02 -$0.21 $0.25 -$0.12 -$0.15 $0.08 $0.08 $0.40 $0.22 115.47% <-Total Growth 10 EPS Diluted US$
Increase 22% 271% -150% 39% -123% -77% 1006% -219% -148% 25% -153% 0% 400% -45% #NUM! <-IRR #YR-> 10 Earnings US$ 115.47%
Earnings Yield -11.1% -82.1% 6.5% 13.5% -7.1% -0.8% -3.3% 4.4% -2.6% -4.5% 2.7% 6.1% 29.2% 16.1% #NUM! <-IRR #YR-> 5 Earnings US$ 137.98%
5 year Running Average -$0.39 -$0.39 -$0.13 -$0.03 -$0.02 $0.00 $0.06 $0.06 -$0.04 -$0.05 -$0.03 $0.03 $0.06 $0.13 #NUM! <-IRR #YR-> 10 5 yr Running US$ 107.25%
10 year Running Average -$0.25 -$0.30 -$0.27 -$0.23 -$0.21 -$0.20 -$0.16 -$0.03 -$0.03 -$0.04 -$0.02 $0.04 $0.06 $0.04 -14.39% <-IRR #YR-> 5 5 yr Running US$ -54.00%
* ESP per share E/P 10 Yrs 0.95% 5Yrs 2.68%
$0.05 <-12 mths -51.98%
EPS Basic CDN$ -$0.17 -$0.61 $0.29 $0.36 -$0.10 -$0.02 -$0.21 $0.27 -$0.12 -$0.16 $0.09 $0.11 118.16% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* -$0.17 -$0.61 $0.29 $0.34 -$0.10 -$0.02 -$0.21 $0.26 -$0.12 -$0.16 $0.09 $0.11 $0.53 $0.29 118.16% <-Total Growth 10 EPS Diluted CDN$
Increase 13.33% 258.82% -147.54% 17.24% -129% -80% 950% -222% -147% 33% -158% 19% 380% -45% #NUM! <-IRR #YR-> 10 Earnings CDN$ 118.16%
Earnings Yield -10.8% -74.4% 15.5% 11.9% -7.9% -0.9% -3.3% 4.3% -2.6% -4.5% 2.7% 6.0% 29.2% 16.1% #NUM! <-IRR #YR-> 5 Earnings CDN$ 152.75%
5 year Running Average -$0.60 -$0.55 -$0.17 -$0.06 -$0.05 -$0.02 $0.06 $0.05 -$0.04 -$0.05 -$0.03 $0.04 $0.09 $0.17 #NUM! <-IRR #YR-> 10 5 yr Running CDN$ 106.48%
10 year Running Average -$0.38 -$0.44 -$0.40 -$0.36 -$0.33 -$0.31 -$0.25 -$0.06 -$0.05 -$0.05 -$0.02 $0.05 $0.07 $0.07 -9.75% <-IRR #YR-> 5 5 yr Running CDN$ -40.14%
* ESP per share (Cdn GAAP) E/P 10 Yrs 0.87% 5Yrs 2.67%
$0.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.11
$0.21 $0.00 $0.00 $0.00 $0.00 $0.11
$0.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.04
-$0.06 $0.00 $0.00 $0.00 $0.00 $0.04
Special Dividends US$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 7 Special Dividends US$
Dividend* $0.02 $0.05 $0.09 $0.12 $0.15 $0.15 $0.15 $0.05 $0.05 $0.05 #DIV/0! <-Total Growth 6 Dividends US$
Increase 100.12% 79.82% 40.31% 21.24% 0.55% 2.26% -66.63% 0.00% 0.00% Count 7 Years of data US$
Dividends 5 Yr Running $0.08 $0.11 $0.13 $0.12 $0.11 $0.09 #DIV/0! <-Total Growth 2 Dividends 5 Yr Running US$
Yield H/L Price #NUM! <-Median-> 0 Yield H/L Price US$
Yield on High Price #NUM! <-Median-> 0 Yield on High Price US$
Yield on Low Price #NUM! <-Median-> 0 Yield on Low Price US$
Yield on Close Price 0.97% 0.74% 1.49% 2.65% 4.32% 4.90% 11.35% 3.65% 3.65% 3.65% 2.65% <-Median-> 7 Yield on Close Price US$
Payout Ratio EPS -125.0% -22.6% 34.3% -100.2% -97.2% 183.2% 187.3% 12.5% 22.7% #DIV/0! -22.62% <-Median-> 7 DPR EPS US$
DPR EPS 5 Yr Running -169.44% -362.34% 462.85% 211.15% 86.05% #DIV/0! -169.44% <-Median-> 3 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 2024.7% 97.7% 18.5% 43.0% -184.4% 30.1% 41.6% 14.8% 41.60% <-Median-> 7 DPR CF US$
DPR CF 5 Yr Running 59.26% 45.47% 42.86% 44.19% 45.47% <-Median-> 3 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC -5797.9% 419.0% 25.6% 32.2% 209.6% 32.6% 33.0% 14.8% 32.56% <-Median-> 7 DPR CF WC US$
DPR CF WC 5 Yr Running 53.60% 44.03% 38.53% 36.36% 44.03% <-Median-> 3 DPR CF WC 5 Yr Running US$
Median Values 5 Yr Med 5 Yr Cl #NUM! 4.32% 5 Yr Med Payout 34.27% 30.06% 32.56% 35.88% <-IRR #YR-> 6 Dividends US$
* Dividends per share 5 Yr Med and Cur. #NUM! -15.60% Last Div Inc ---> $0.053 $0.013 -76.2% 25.76% <-IRR #YR-> 5 Dividends US$
-$0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.15
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.15
Special Dividends CDN$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 7 Special Dividends CDN$
Dividend* $0.03 $0.05 $0.09 $0.12 $0.16 $0.17 $0.21 $0.05 $0.05 $0.05 #DIV/0! <-Total Growth 6 Dividends CDN$
Increase 90.00% 84.21% 37.14% 29.17% 9.68% 22.06% -75.90% 0.00% 0.00% Count 7 Years of data CDN$
Dividends 5 Yr Running $0.09 $0.12 $0.15 $0.14 $0.13 $0.11 #DIV/0! <-Total Growth 2 Dividends 5 Yr Running CDN$
Yield H/L Price 1.32% 1.05% 1.20% 2.29% 3.84% 4.57% 7.89% 1.91% 2.29% <-Median-> 7 Yield H/L Price CDN$
Yield on High Price 1.03% 0.74% 0.93% 2.01% 3.11% 4.02% 5.24% 1.31% 2.01% <-Median-> 7 Yield on High Price CDN$
Yield on Low Price 1.82% 1.79% 1.69% 2.66% 5.00% 5.30% 15.96% 3.52% 2.66% <-Median-> 7 Yield on Low Price CDN$
Yield on Close Price 1.15% 0.74% 1.49% 2.65% 4.37% 4.89% 11.22% 2.75% 2.75% 2.75% 2.65% <-Median-> 7 Yield on Close Price CDN$
Payout Ratio EPS -125.0% -22.6% 34.3% -100.2% -97.2% 183.2% 187.3% 9.4% 17.1% #DIV/0! -22.62% <-Median-> 7 DPR EPS CDN$
DPR EPS 5 Yr Running -171.26% -410.77% 412.07% 154.00% 72.82% #DIV/0! -171.26% <-Median-> 3 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 2024.7% 97.7% 18.5% 43.0% -184.4% 30.1% 41.6% 11.2% 41.60% <-Median-> 7 DPR CF CDN$
DPR CF 5 Yr Running 60.57% 45.22% 42.71% 41.13% 45.22% <-Median-> 3 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC -5797.9% 419.0% 25.6% 32.2% 209.6% 32.6% 33.0% 11.2% 32.56% <-Median-> 7 DPR CF WC CDN$
DPR CF WC 5 Yr Running 54.37% 43.85% 38.15% 34.34% 43.85% <-Median-> 3 DPR CF WC 5 Yr Running CDN$ To Date
Median Values 5 Yr Med 5 Yr Cl 3.84% 4.37% 5 Yr Med Payout 34.27% 30.06% 32.56% 42.29% <-IRR #YR-> 6 Dividends CDN$ 10.41%
* Dividends per share 5 Yr Med and Cur. -28.39% -37.08% Last Div Inc ---> $0.053 $0.013 -76.2% 34.30% <-IRR #YR-> 5 Dividends CDN$ -10.59%
-$0.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.21
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.21
Historical Dividends Historical H/L Div 9.56% 0.86% 5.21% <-Ave D Med/Cl D 2.29% 2.65% Historical Dividends CDN$
High/Ave/Median Values P/Hi P/Ave Exp. Exp. -47.27% Curr diff 19.97% 3.71% High/Ave/Median CDN$
Future Div Yield Div Yd 7.13% earning in 10 Years at IRR of 10.0% Div Inc. 159.37% Future Div Yield CDN$
Future Div Yield Div Yd 11.48% earning in 15 Years at IRR of 10.0% Div Inc. 317.72% Future Div Yield CDN$
Div Gr, Cap Gain 2006 Sold $0.35 -99.44% Div Gr, Cap Gain CDN$
I am earning # yrs -> 6 2000 Bought $62.52 RRSP I am earning CDN$
Yield if held 5 yrs 0.75% 5.28% 6.06% 2.45% 5.64% 8.95% 4.59% 0.69% 0.95% 1.24% 5.28% <-Median-> 7 Paid Median Price CDN$
Yield if held 10 yrs 0.24% 0.09% 0.57% 4.83% 4.78% 5.07% 23.06% 3.46% 1.02% 1.82% 4.78% <-Median-> 7 Paid Median Price CDN$
Yield if held 15 yrs 8.38% 1.65% 0.40% 0.33% 2.01% 1.54% 1.65% <-Median-> 3 Paid Median Price CDN$
Yield if held 20 yrs #DIV/0! 2.70% #NUM! <-Median-> 0 Paid Median Price CDN$
Cost covered if held 5 years 0.75% 8.06% 11.07% 5.71% 15.82% 30.53% 16.35% 9.64% 12.07% 13.06% 11.07% <-Median-> 7 Paid Median Price CDN$
Cost covered if held 10 years 0.24% 0.14% 1.05% 11.27% 13.41% 18.06% 90.28% 59.69% 18.60% 35.00% 11.27% <-Median-> 7 Paid Median Price CDN$
Cost covered if held 15 years 23.51% 5.87% 1.57% 5.64% 36.72% 29.66% 5.87% <-Median-> 3 Paid Median Price CDN$
Cost covered if held 20 years #DIV/0! 0.4932432 #NUM! <-Median-> 0 Paid Median Price CDN$
Graham No. $2.15 $4.37 $3.62 $3.68 $3.54 $3.97 $3.71 $3.59 $2.23 $2.63 $5.81 $4.31 $0.00 -25.79% <-Total Growth 9 Graham Price CDN$
Price/GP Ratio Med 0.67 1.12 0.76 0.52 1.28 1.84 1.41 1.12 1.67 1.00 0.45 1.12 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Hi 1.06 1.77 1.21 0.66 1.81 2.37 1.61 1.39 1.90 1.51 0.66 1.56 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.29 0.47 0.31 0.37 0.75 1.30 1.21 0.86 1.44 0.50 0.24 0.62 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Cl 0.87 0.65 0.35 0.59 1.81 1.48 1.22 0.99 1.56 0.70 0.31 0.42 #DIV/0! 0.93 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc CL -13.02% -34.51% -65.20% -40.83% 80.88% 47.83% 21.98% -1.15% 56.40% -29.54% -68.68% -57.77% #DIV/0!
Price Close $1.58 $0.82 $1.87 $2.86 $1.26 $2.18 $6.40 $5.87 $4.53 $3.55 $3.48 $1.85 $1.82 $1.82 $1.82 125.61% <-Total Growth 10 Stock Price CDN$
Increase -64.65% -48.10% 128.05% 52.94% -55.94% 73.02% 193.58% -8.28% -22.83% -21.63% -1.97% -46.84% -1.62% 0.00% 0.00% 8.48% <-IRR #YR-> 10 Stock Price CDN$
P/E -9.29 -1.34 6.45 8.41 -12.60 -109.00 -30.48 22.99 -37.81 -22.25 37.50 16.70 3.42 6.22 #DIV/0! -21.98% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E -10.53 -4.82 -3.07 9.86 3.71 -21.80 -320.00 -27.95 17.74 -29.63 -21.81 19.93 16.43 3.42 6.22 13.52% <-IRR #YR-> 10 Price & Dividend CDN$
Median 10, 5 Yrs D. per yr 5.04% 4.23% % Tot Ret 37.30% -23.83% Price Inc -21.63% P/E: -3.08 16.70 -17.75% <-IRR #YR-> 5 Price & Dividend CDN$
-$0.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.85
-$6.40 $0.00 $0.00 $0.00 $0.00 $1.85
-$0.82 $0.00 $0.00 $0.00 $0.03 $0.05 $0.09 $0.12 $0.16 $0.17 $2.06
-$6.40 $0.09 $0.12 $0.16 $0.17 $2.06
Price H/L Median $3.35 $0.90 $1.45 $4.91 $2.75 $1.90 $4.53 $7.29 $5.24 $4.04 $3.72 $2.63 $2.62 192.22% <-Total Growth 10 Stock Price CDN$
Increase 3.24% -73.13% 60.56% 239.45% -43.93% -30.91% 138.16% 61.10% -28.12% -22.90% -7.92% -29.30% -0.38% 11.32% <-IRR #YR-> 10 Stock Price CDN$
P/E -19.71 -1.48 4.98 14.43 -27.50 -95.00 -21.55 28.55 -43.74 -25.32 40.08 23.74 4.93 -10.28% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E -22.33 -5.29 -2.37 16.91 8.09 -19.00 -226.25 -34.71 20.52 -33.72 -23.32 28.34 23.65 15.29% <-IRR #YR-> 10 Price & Dividend CDN$
P/E on Run. 5 yr Ave -5.60 -1.62 -8.70 -81.75 -55.00 -95.00 75.42 137.37 -134.73 -79.53 -131.73 73.23 28.72 -6.11% <-IRR #YR-> 5 Price & Dividend CDN$
P/E on Run. 10 yr Ave -13.74 -8.31 -6.15 -18.32 -129.10 -105.97 -80.16 -154.23 54.84 36.31 -16.39 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D. per yr 3.97% 4.17% % Tot Ret 25.96% -68.25% Price Inc -22.90% P/E: -8.28 23.74 Count 18 Years of data
-$0.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.63
-$4.53 $0.00 $0.00 $0.00 $0.00 $2.63
-$0.90 $0.00 $0.00 $0.00 $0.03 $0.05 $0.09 $0.12 $0.16 $0.17 $2.84
-$4.53 $0.09 $0.12 $0.16 $0.17 $2.84
High Months Sep 05 Oct 06 Feb 07 Nov 07 Jun 09 Dec 10 Jul Jan Jul Sep Jan Jun
Price High $5.12 $1.10 $2.27 $7.75 $4.37 $2.43 $6.40 $9.40 $5.97 $4.98 $4.23 $3.96 $3.82 260.00% <-Total Growth 10 Stock Price CDN$
Increase -0.39% -78.52% 106.36% 241.41% -43.61% -44.39% 163.37% 46.88% -36.49% -16.58% -15.06% -6.38% -3.54% 13.67% <-IRR #YR-> 10 Stock Price CDN$
P/E -30.12 -1.80 7.83 22.79 -43.70 -121.50 -30.48 36.81 -49.83 -31.21 45.58 35.75 7.18 -9.15% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E -34.13 -6.47 -3.72 26.72 12.85 -24.30 -320.00 -44.76 23.38 -41.57 -26.51 42.67 34.48 -25.59 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc -15.06% P/E: -11.32 35.75 25.38 P/E Ratio Historical High CDN$
-$1.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.96
-$6.40 $0.00 $0.00 $0.00 $0.00 $3.96
Low Months Aug 05 Feb 06 Nov 06 Oct 08 Mar 09 Jan 10 Dec Dec Oct Feb Nov Jan
Price Low $1.58 $0.70 $0.62 $2.06 $1.13 $1.37 $2.65 $5.18 $4.51 $3.10 $3.21 $1.30 $1.42 85.71% <-Total Growth 10 Stock Price CDN$
Increase 17.04% -55.70% -11.43% 232.26% -45.15% 21.24% 93.43% 95.47% -12.93% -31.26% 3.55% -59.50% 9.23% 6.39% <-IRR #YR-> 10 Stock Price CDN$
P/E -9.29 -1.15 2.14 6.06 -11.30 -68.50 -12.62 20.29 -37.65 -19.43 34.59 11.74 2.67 -13.28% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E -10.53 -4.12 -1.02 7.10 3.32 -13.70 -132.50 -24.67 17.66 -25.88 -20.12 14.01 12.82 -5.43 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc -12.93% P/E: -4.58 11.74 -20.69 P/E Ratio Historical Low CDN$
-$0.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.30
Price Close US$ $1.25 $0.63 $4.00 $2.65 $1.15 $2.46 $6.43 $5.74 $4.54 $3.37 $2.99 $1.32 $1.37 $1.37 $1.37 109.52% <-Total Growth 10 Stock Price US$
Increase -60.57% -49.60% 534.92% -33.75% -56.60% 113.91% 161.38% -10.73% -20.91% -25.77% -11.28% -55.85% 3.79% 0.00% 0.00% 7.68% <-IRR #YR-> 10 Stock Price US$
P/E -8.97 -1.22 15.49 7.40 -13.99 -129.16 -30.53 22.96 -37.83 -22.47 37.38 16.50 3.43 6.23 #DIV/0! -27.14% <-IRR #YR-> 5 Stock Price US$
Trailing P/E -10.99 -4.52 -7.73 10.26 3.21 -29.93 -337.61 -27.25 18.16 -28.08 -19.93 16.50 17.13 3.43 6.23 13.77% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 6.09% 4.27% % Tot Ret 44.23% -18.68% Price Inc -20.91% P/E: -3.29 16.50 -22.87% <-IRR #YR-> 5 Price & Dividend US$
-$0.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.32
-$6.43 $0.00 $0.00 $0.00 $0.00 $1.32
-$0.63 $0.00 $0.00 $0.00 $0.02 $0.05 $0.09 $0.12 $0.15 $0.15 $1.47
-$6.43 $0.09 $0.12 $0.15 $0.15 $1.47
Debt US$ $45 $28 $24 Debt US$
Debt CDN$ $52 $39 $32 Debt CDN$
Ratio to Market Cap 0.12 0.17 0.15 0.15 <-Median-> 2 % of Market Cap CDN$
Goodwill & Intangibles US$ $12.62 $12.62 $12.62 $12.62 $12.62 Intangibles Goodwill US$
Goodwill CDN$ $12.60 $13.43 $14.64 $17.48 $16.79 Intangibles Goodwill CDN$
Ratio to Market Cap 0.02 0.03 0.03 0.08 0.08 0.03 <-Median-> 4 % of Market Cap CDN$
Market Cap US$ $52.27 $26.60 $244.40 $247.70 $113.74 $251.03 $705.52 $707.38 $551.79 $404.09 $359.54 $159.51 $162.27 $162.27 $162.27
Market Cap CDN$ $66.07 $34.63 $114.26 $267.32 $124.61 $222.46 $702.23 $723.40 $550.58 $425.68 $418.46 $223.56 $215.57 $215.57 $215.57 545.60% <-Total Growth 10 Market Cap CDN$
Diluted 48.78 80.09 93.51 97.01 103.29 125.00 121.45 120.86 120.37 120.72 119.50 147.49% <-Total Growth 9 Diluted
Change 64.20% 16.75% 3.75% 6.47% 21.02% -2.84% -0.49% -0.40% 0.29% -1.01% 3.75% <-Median-> 9 Change
Average # of Sh in M 40.30 42.14 48.45 77.78 93.51 97.01 103.29 122.74 121.45 120.86 120.10 120.71 119.50 186.46% <-Total Growth 10 Average
Change 27.13% 4.57% 14.97% 60.54% 20.22% 3.74% 6.47% 18.83% -1.05% -0.49% -0.62% 0.51% -1.01% 5.11% <-Median-> 10 Change
Difference 3.8% 0.2% 26.1% 20.2% 5.8% 5.2% 6.2% 0.4% 0.1% -0.8% 0.1% 0.1% -0.9% 2.80% <-Median-> 10 Difference
$39.94 <-12 mths -8.25%
# of Share in Millions 41.818 42.229 61.099 93.470 98.900 102.044 109.723 123.237 121.541 119.909 120.248 120.842 118.444 118.444 118.444 11.09% <-IRR #YR-> 10 Shares
Increase 8.96% 0.98% 44.68% 52.98% 5.81% 3.18% 7.53% 12.32% -1.38% -1.34% 0.28% 0.49% -1.98% 0.00% 0.00% 1.95% <-IRR #YR-> 5 Shares
CF fr Op $M US$ -$5.20 -$12.50 -$12.43 $12.77 $10.04 $0.12 $5.35 $57.10 $33.99 -$9.48 $58.63 $43.53 $39.94 <-12 mths 448.13% <-Total Growth 10 Cash Flow US$
Change -2535.12% -140.68% 0.60% 202.73% -21.39% -98.80% 4357.19% 967.67% -40.48% -127.88% 718.71% -25.75% -8.25% <-12 mths SO S. Issues Buy Backs
5 year Running Average -$9.19 -$8.47 -$6.68 -$3.51 -$1.46 -$0.40 $3.17 $17.07 $21.32 $17.42 $29.12 $36.75 $33.32 <-12 mths 533.84% <-Total Growth 10 CF 5 Yr Running US$
CFPS -$0.12 -$0.30 -$0.20 $0.14 $0.10 $0.00 $0.05 $0.46 $0.28 -$0.08 $0.49 $0.36 $0.34 <-12 mths 221.66% <-Total Growth 10 Cash Flow per Share US$
Increase -2318.44% -138.34% 31.30% 167.15% -25.70% -98.84% 4045.24% 850.59% -39.65% -128.26% 716.97% -26.12% -6.39% <-12 mths #NUM! <-IRR #YR-> 10 Cash Flow US$ 448.13%
5 year Running Average -$0.33 -$0.25 -$0.15 -$0.10 -$0.08 -$0.05 $0.02 $0.15 $0.18 $0.14 $0.24 $0.30 $0.28 <-12 mths 52.10% <-IRR #YR-> 5 Cash Flow US$ 713.98%
P/CF on Med Price #NUM! <-IRR #YR-> 10 Cash Flow per Share US$ 221.66%
P/CF on Closing Price -10.06 -2.13 -19.66 19.40 11.33 2092.14 131.92 12.39 16.24 -42.64 6.13 3.66 4.06 <-12 mths 49.19% <-IRR #YR-> 5 Cash Flow per Share US$ 639.08%
-65.74% Diff M/C -15.36% <-IRR #YR-> 10 CFPS 5 yr Running US$ 220.05%
Excl.Working Capital CF $1.64 $0.01 $1.10 -$1.16 -$2.54 -$0.16 -$4.10 -$15.79 $11.42 $17.82 -$4.52 $11.30 $0.00 <-12 mths #NUM! <-IRR #YR-> 5 CFPS 5 yr Running US$ 1687.37%
CF fr Op $M WC US$ -$3.6 -$12.5 -$11.3 $11.6 $7.5 $0.0 $1.2 $41.3 $45.4 $8.3 $54.1 $54.8 $39.9 <-12 mths 538.76% <-Total Growth 10 Cash Flow less WC US$
Increase -322.52% -251.36% 9.30% 202.44% -35.42% -100.56% 3077.89% 3210.48% 9.92% -81.63% 548.89% 1.32% -27.15% <-12 mths #NUM! <-IRR #YR-> 10 Cash Flow less WC US$ 538.76%
5 year Running Average -$9.08 -$9.01 -$7.26 -$3.32 -$1.66 -$0.95 $1.80 $12.32 $19.08 $19.25 $30.08 $40.80 $41 <-12 mths 113.10% <-IRR #YR-> 5 Cash Flow less WC US$ 4294.12%
CFPS Excl. WC US$ -$0.09 -$0.30 -$0.19 $0.12 $0.08 $0.00 $0.01 $0.34 $0.37 $0.07 $0.45 $0.45 $0.34 <-12 mths #NUM! <-IRR #YR-> 10 CF less WC 5 Yr Run US$ 552.98%
Increase -287.78% -247.94% 37.31% 166.96% -38.97% -100.54% 2869.48% 2847.46% 11.46% -81.38% 547.06% 0.82% -25.68% <-12 mths 86.75% <-IRR #YR-> 5 CF less WC 5 Yr Run US$ 2171.67%
5 year Running Average -$0.32 -$0.27 -$0.17 -$0.09 -$0.07 -$0.06 $0.01 $0.11 $0.16 $0.16 $0.25 $0.34 $0.34 <-12 mths #NUM! <-IRR #YR-> 10 CFPS - Less WC US$ 253.33%
P/CF on Med Price 109.02% <-IRR #YR-> 5 CFPS - Less WC US$ 3889.79%
P/CF on Closing Price -14.70 -2.13 -21.56 21.34 15.17 -5991.12 565.44 17.13 12.15 48.46 6.64 2.91 4.06 #NUM! <-IRR #YR-> 10 CFPS 5 yr Running US$ 224.23%
CF/-WC P/CF Med 10 yr 11.86 5 yr 6.13 P/CF Med 10 yr 13.66 5 yr 12.15 -70.26% Diff M/C 131.16% <-IRR #YR-> 5 CFPS 5 yr Running US$ 6499.82%
$53.11 <-12 mths -11.89% problem is no positive cash flow until 2007
CF fr Op $M CDN$ -$6.34 -$14.75 -$13.95 $12.13 $12.21 $0.13 $5.33 $58.32 $33.93 -$10.08 $68.02 $60.28 $53.11 <-12 mths -508.77% <-Total Growth 10 Cash Flow CDN$
Increase 2338.46% 132.60% -5.38% -186.91% 0.69% -98.97% 4131.75% 993.72% -41.82% -129.70% -774.85% -11.37% -11.89% <-12 mths SO S. Issues Buy Backs
5 year Running Average -$13.99 -$12.02 -$8.03 -$4.63 -$2.14 -$0.85 $3.17 $17.62 $21.98 $17.53 $31.10 $42.09 $41.05 <-12 mths 450.31% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ -$0.15 -$0.35 -$0.23 $0.13 $0.12 $0.001 $0.05 $0.47 $0.28 -$0.08 $0.57 $0.50 $0.45 <-12 mths 242.85% <-Total Growth 10 Cash Flow per Share CDN$
Increase 2137.95% 130.34% -34.60% -156.81% -4.84% -99.00% 3836% 873.78% -41.01% -130.11% -772.95% -11.81% -10.11% <-12 mths #NUM! <-IRR #YR-> 10 Cash Flow CDN$ 508.77%
5 year Running Average -$0.51 -$0.37 -$0.18 -$0.12 -$0.10 -$0.06 $0.01 $0.16 $0.19 $0.14 $0.26 $0.35 $0.34 <-12 mths 62.43% <-IRR #YR-> 5 Cash Flow CDN$ 1030.54%
P/CF on Med Price -22.10 -2.58 -6.33 37.80 22.27 1538.76 93.12 15.41 18.77 -48.07 6.58 5.27 #NUM! <-IRR #YR-> 10 Cash Flow per Share CDN$ 242.85%
P/CF on Closing Price -10.42 -2.35 -8.19 22.04 10.20 1765.52 131.70 12.40 16.23 -42.24 6.15 3.71 4.06 -76.25% Diff M/C 59.32% <-IRR #YR-> 5 Cash Flow per Share CDN$ 926.52%
#NUM! <-IRR #YR-> 10 CFPS 5 yr Running CDN$ 194.80%
Excl.Working Capital CF $2.00 $0.01 $1.23 -$1.10 -$3.09 -$0.17 -$4.09 -$16.13 $11.40 $18.95 -$5.24 $15.64 $0.00 <-12 mths #NUM! <-IRR #YR-> 5 CFPS 5 yr Running CDN$ 2220.35%
CF fr Op $M WC CDN$ -$4.3 -$14.7 -$12.7 $11.0 $9.1 -$0.04 $1.2 $42.2 $45.3 $8.9 $62.8 $75.9 $53.1 <-12 mths 615.17% <-Total Growth 10 Cash Flow less WC CDN$
Increase 290.99% 239.56% -13.66% -186.67% -17.28% -100.48% -2927% 3291.24% 7.44% -80.43% 607.76% 20.94% -30.04% <-12 mths #NUM! <-IRR #YR-> 10 Cash Flow less WC CDN$ 615.17%
5 year Running Average -$13.9 -$12.9 -$9.1 -$4.4 -$2.3 -$1.5 $1.7 $12.7 $19.6 $19.5 $32.1 $47.0 $49.2 <-12 mths 127.57% <-IRR #YR-> 5 Cash Flow less WC CDN$ 6003.00%
CFPS Excl. WC CDN$ -$0.10 -$0.35 -$0.21 $0.12 $0.09 -$0.0004 $0.01 $0.34 $0.37 $0.07 $0.52 $0.63 $0.45 <-12 mths #NUM! <-IRR #YR-> 10 CF less WC 5 Yr Run CDN$ 463.79%
Increase 258.84% 236.26% -40.32% -156.65% -21.83% -100.47% -2729% 2919.37% 8.94% -80.17% 605.77% 20.35% -28.63% <-12 mths 93.68% <-IRR #YR-> 5 CF less WC 5 Yr Run CDN$ 2625.24%
5 year Running Average -$0.50 -$0.40 -$0.22 -$0.11 -$0.09 -$0.07 $0.00 $0.11 $0.16 $0.16 $0.26 $0.39 $0.41 <-12 mths #NUM! <-IRR #YR-> 10 CFPS - Less WC CDN$ 280.03%
P/CF on Med Price -32.28 -2.58 -6.94 41.57 29.82 -4406.44 399.11 21.30 14.05 54.62 7.13 4.19 123.22% <-IRR #YR-> 5 CFPS - Less WC CDN$ 5441.42%
P/CF on Closing Price -15.22 -2.35 -8.98 24.24 13.66 -5055.81 564.49 17.15 12.15 47.99 6.67 2.94 4.06 <-12 mths #NUM! <-IRR #YR-> 10 CFPS 5 yr Running CDN$ 197.77%
*Operational Cash Flow per share CF-WC P/CF Med 10 yr 17.09 5 yr 6.58 P/CF Med 10 yr 17.67 5 yr 14.05 -77.03% Diff M/C 172.65% <-IRR #YR-> 5 CFPS 5 yr Running CDN$ 14966.14%
$0.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.50 Cash Flow per Share CDN$
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.50 Cash Flow per Share CDN$
-$1.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.12 CFPS 5 yr Running CDN$
-$38.36 $0.00 $0.00 $0.00 $0.00 -$0.12 CFPS 5 yr Running CDN$
$14.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $75.9 Cash Flow less WC CDN$
-$1.2 $0.0 $0.0 $0.0 $0.0 $75.9 Cash Flow less WC CDN$
$12.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $47.0 CF less WC 5 Yr Run CDN$
-$1.7 $0.0 $0.0 $0.0 $0.0 $47.0 CF less WC 5 Yr Run CDN$
$0.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.63 CFPS - Less WC CDN$
-$0.01 $0.00 $0.00 $0.00 $0.00 $0.63 CFPS - Less WC CDN$
$0.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.39 CFPS 5 yr Running CDN$
$0.00 $0.00 $0.00 $0.00 $0.00 $0.39 CFPS 5 yr Running CDN$
OPM -25.02% -58.29% -661.95% 19.79% 47.77% 0.36% 10.51% 53.96% 38.64% -10.74% 59.64% 42.32% 172.61% <-Total Growth 10 OPM CDN$
Increase 2480.42% 132.93% 1035.65% -102.99% 141.33% -99.25% 2824.14% 413.38% -28.40% -127.80% -655.13% -29.03% Should increase or be stable. CDN$
Diff from Ave -185.6% -299.5% -2365.7% -32.2% 63.5% -98.8% -64.0% 84.7% 32.2% -136.8% 104.1% 44.9% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 29.22% 5 Yrs 42.32% should be zero, it is a check on calculations CDN$
Current Assets US$ $437.869 $178.316 $144.443 $130.339 $104.594 $111.211 Liquidity ratio of 1.5 and up, best US$
Current Liabilities $237.435 $24.953 $44.492 $36.333 $31.290 $18.724 3.34 <-Median-> 5 Ratio US$
Liquidity 1.84 7.15 3.25 3.59 3.34 5.94 3.34 <-Median-> 5 Ratio US$
Current Assets CDN$ $24.231 $14.209 $34.814 $98.365 $107.227 $97.610 $111.453 $447.209 $178.015 $153.630 $151.206 $144.836 $147.888 Liquidity ratio of 1.5 and up, best
Current Liabilities $6.899 $13.192 $1.501 $4.889 $6.530 $11.774 $11.740 $242.499 $24.911 $47.322 $42.150 $43.329 $24.899 7.72 <-Median-> 10 Ratio CDN$
Liquidity 3.51 1.08 23.19 20.12 16.42 8.29 9.49 1.84 7.15 3.25 3.59 3.34 5.94 3.34 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.59 -0.04 13.90 22.60 18.29 8.08 9.50 2.04 7.92 2.33 4.72 4.16 7.83 4.16 <-Median-> 5 Ratio CDN$
Liq. CF re Inv+Div 0.69 -0.04 13.90 10.55 1.68 8.08 3.98 2.04 3.81 1.96 2.15 1.48 7.83 2.04 <-Median-> 5 Ratio CDN$
Assets US$ $21.688 $39.882 $276.350 $208.441 $240.824 $251.608 $588.992 $330.785 $337.201 $313.194 $293.218 $271.478 Debt Ratio of 1.5 and up, best
Liabilities $12.394 $1.333 $31.018 $22.963 $11.212 $11.775 $257.836 $38.523 $84.092 $67.437 $51.840 $34.915 4.64 <-Median-> 5 Ratio US$
Debt Ratio 2.28 8.59 4.01 4.64 5.66 7.78 4.64 <-Median-> 5 Ratio US$
US$
Assets CDN$ $54.234 $25.578 $44.775 $262.505 $253.603 $252.894 $250.855 $601.555 $330.226 $358.647 $363.336 $406.032 $361.011 Debt Ratio of 1.5 and up, best
Liabilities $14.739 $14.617 $1.496 $29.464 $27.938 $11.774 $11.740 $263.336 $38.458 $89.440 $78.234 $71.785 $46.430 8.75 <-Median-> 10 Ratio CDN$
Debt Ratio 3.68 1.75 29.93 8.91 9.08 21.48 21.37 2.28 8.59 4.01 4.64 5.66 7.78 4.64 <-Median-> 5 Ratio CDN$
Book Value US$$ $9.294 $38.549 $245.332 $185.478 $229.612 $239.833 $331.156 $292.262 $253.109 $245.757 $241.378 $236.563 $236.563 $236.563 -4.63% <-Total Growth 10 Book Value US$
Book Value per share $0.22 $0.63 $2.62 $1.88 $2.25 $2.19 $2.69 $2.40 $2.11 $2.04 $2.00 $2.00 $2.00 $2.00 807.57% <-Total Growth 10 Book Value per Share US$
Change 186.67% 316.01% -28.55% 19.98% -2.86% 22.94% -10.51% -12.22% -3.18% -2.27% -0.01% 0.00% 0.00% -55.16% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) #NUM! P/B Ratio Historical Median US$
P/B Ratio (Close) 2.86 6.34 1.01 0.61 1.09 2.94 2.14 1.89 1.60 1.46 0.66 0.69 0.69 0.69 24.68% <-IRR #YR-> 10 Book Value US$
Change 121.48% -84.07% -39.26% 78.29% 169.07% -27.39% -11.61% -15.44% -8.36% -54.83% 3.80% 0.00% 0.00% -1.79% <-IRR #YR-> 5 Book Value US$
Leverage (A/BK) 2.33 1.03 1.13 1.12 1.05 1.05 1.78 1.13 1.33 1.27 1.21 1.15 1.13 <-Median-> 10 A/BV US$
Debt/Equity Ratio 1.33 0.03 0.13 0.12 0.05 0.05 0.78 0.13 0.33 0.27 0.21 0.15 0.13 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.53 5 yr Med 1.60 -55.16% Diff M/C 1.13 Historical Leverage (A/BK) US$
0.13 Historical Leverage (A/BK) US$
-$0.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.00
-$2.19 $0.00 $0.00 $0.00 $0.00 $2.00
Check on CDN$ $338.220 $291.768 $269.207 $285.103 $334.246
Book Value CDN$ $39.495 $10.961 $43.279 $233.041 $225.665 $241.120 $239.115 $338.220 $291.768 $269.207 $285.103 $334.246 $334.246 $334.246 $334.246 2949.42% <-Total Growth 10 Book Value CDN$
Book Value per share $0.94 $0.26 $0.71 $2.49 $2.28 $2.36 $2.18 $2.74 $2.40 $2.25 $2.37 $2.77 $2.82 $2.82 $2.82 965.64% <-Total Growth 10 Book Value per Share CDN$
Change 3.92% -72.52% 172.90% 251.98% -8.48% 3.56% -7.77% 25.94% -12.53% -6.48% 5.61% 16.66% 2.03% 0.00% 0.00% -65.76% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 3.55 3.47 2.04 1.97 1.21 0.80 2.08 2.66 2.18 1.80 1.57 0.95 2.42 P/B Ratio Historical Median
P/B Ratio (Close) 1.67 3.16 2.64 1.15 0.55 0.92 2.94 2.14 1.89 1.58 1.47 0.67 0.64 0.64 0.64 26.70% <-IRR #YR-> 10 Book Value CDN$
Change -65.99% 88.84% -16.44% -56.55% -51.86% 67.07% 218.32% -27.17% -11.77% -16.21% -7.18% -54.43% -3.57% 0.00% 0.00% 4.88% <-IRR #YR-> 5 Book Value CDN$
Leverage (A/BK) 1.37 2.33 1.03 1.13 1.12 1.05 1.05 1.78 1.13 1.33 1.27 1.21 1.08 1.13 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 0.37 1.33 0.03 0.13 0.12 0.05 0.05 0.78 0.13 0.33 0.27 0.21 0.14 0.13 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.88 5 yr Med 1.80 -65.76% Diff M/C 1.27 Historical Leverage (A/BK)
-$0.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.77
-$2.18 $0.00 $0.00 $0.00 $0.00 $2.77
$5.43 <-12 mths -45.87%
Comprehensive Income US$ -$9.02 $21.97 -$14.52 -$18.09 $9.71 $10.04 211.30% <-Total Growth 5 Comprehensive Income US$
Increase 343.62% -166.10% -24.61% 153.67% 3.35% 3.3% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average -$1.99 $1.82 #NUM! <-IRR #YR-> 5 Comprehensive Income US$ 211.30%
ROE US$ -3.8% 6.6% -5.0% -7.1% 4.0% 4.2% #NUM! <-IRR #YR-> 5 Comprehensive Income US$ 211.30%
5Yr Median -3.8% 4.0%
% Difference from NI -59.4% -30.9% 0.0% 0.0% 0.0% 0.0%
Median Values Diff 5, 10 yr 0.0% 0.0% 4.0% <-Median-> 5 Comprehensive Income US$
$9 $0 $0 $0 $0 $10
$9 $0 $0 $0 $0 $10
Current Liability Coverage Ratio US$ 0.17 1.82 0.19 1.49 1.75 CFO / Current Liabilities US$
5 year Median 0.84 1.49 1.49 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 0.50% 7.01% 13.73% 2.47% 17.28% 18.70% CFO / Total Assets US$
5 year Median 7.01% 13.73% 13.7% <-Median-> 5 Return on Assets US$
Return on Assets ROA US$ -8.8% 5.4% -4.4% -5.4% 3.1% 3.4% Net Income/Assets Return on Assets US$
5Yr Median -4.4% 3.1% 3.1% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ -9.3% 9.6% -5.0% -7.1% 4.0% 4.2% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median -5.0% 4.0% 4.0% <-Median-> 5 Return on Equity US$
$5.43 <-12 mths -45.87%
Net Income US$ -$5.78 -$21.86 $12.57 $29.07 -$7.55 $9.80 -$22.22 $31.80 -$14.52 -$18.09 $9.71 $10.04 $17.80 $4.22 145.91% <-Total Growth 10 Net Income US$
Increase 65.38% 278.40% -157.49% 131.35% -125.97% -229.73% -326.83% -243.11% -145.66% 24.61% -153.67% 3.35% 77.36% -76.29% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average -$14.2 -$12.8 -$8.0 $2.1 $1.3 $4.4 $4.3 $8.2 -$0.5 -$2.6 -$2.7 $3.8 $1.0 $4.7 #NUM! <-IRR #YR-> 10 Net Income US$ 145.91%
Operating Cash Flow $57.10 $33.99 -$9.48 $58.63 $43.53 #NUM! <-IRR #YR-> 5 Net Income US$ 145.17%
Investing Cash Flow $9.81 -$26.92 -$11.90 -$43.36 -$56.28 #NUM! <-IRR #YR-> 10 5 Yr Running Average US$ 129.65%
Total Accruals -$35.12 -$21.59 $3.28 -$5.56 $22.78 -2.66% <-IRR #YR-> 5 5 Yr Running Average US$ -12.63%
Total Assets $588.99 $330.79 $337.20 $313.19 $293.22 Balance Sheet Assets US$
Accruals Ratio -5.96% -6.53% 0.97% -1.77% 7.77% -1.77% <-Median-> 5 Ratio US$
EPS/CF Ratio 1.64 1.75 -1.39 3.05 -1.08 46.38 -18.52 0.78 -0.32 -2.16 0.18 0.18 -0.07 <-Median-> 10 EPS/CF Ratio
$21.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $10.0
$22.2 $0.0 $0.0 $0.0 $0.0 $10.0
$12.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $3.8
-$4.3 $0.0 $0.0 $0.0 $0.0 $3.8
Financial Cash Flow $289.94 -$260.28 -$24.83 -$18.27 -$19.01 C F Statement Financial Cash Flow US$
Total Accruals -$325.05 $238.70 $28.11 $12.71 $41.79 Accruals US$
Accruals Ratio -55.19% 72.16% 8.34% 4.06% 14.25% 8.34% <-Median-> 5 Ratio US$
$7.22 <-12 mths -48.02%
Comprehensive Income CDN$ -$8.99 $22.44 -$14.50 -$19.24 $11.27 $13.90 254.59% <-Total Growth 5 Comprehensive Income CDN$
Increase 349.56% -164.61% -32.76% 158.54% 23.36% 23.4% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average -$1.81 $2.77 #NUM! <-IRR #YR-> 5 Comprehensive Income CDN$ 254.59%
ROE -3.8% 6.6% -5.0% -7.1% 4.0% 4.2% #NUM! <-IRR #YR-> 5 Comprehensive Income CDN$ 254.59%
5Yr Median 1.4% -3.8% -4.4% -3.8% 4.0%
% Difference from NI -59.4% -30.9% 0.0% 0.0% 0.0% 0.0%
Median Values Diff 5, 10 yr 0.0% 0.0% 4.0% <-Median-> 5 Comprehensive Income CDN$
$9.0 $0.0 $0.0 $0.0 $0.0 $13.9
$9.0 $0.0 $0.0 $0.0 $0.0 $13.9
Current Liability Coverage Ratio CDN$ -0.63 -1.12 -8.48 2.26 1.40 0.00 0.11 0.17 1.82 0.19 1.49 1.75 CFO / Current Liabilities CDN$
5 year Median -0.63 -1.12 -1.12 -0.63 -0.63 0.00 0.11 0.17 0.17 0.17 0.19 1.49 1.49 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ -8.00% -57.62% -28.42% 4.20% 3.60% -0.02% 0.50% 7.01% 13.73% 2.47% 17.28% 18.70% CFO / Total Assets CDN$
5 year Median -14.44% -50.20% -28.42% -8.00% -8.00% -0.02% 0.50% 3.60% 3.60% 2.47% 7.01% 13.73% 13.7% <-Median-> 5 Return on Assets CDN$
Return on Assets ROA CDN$ -13.0% -100.8% 31.5% 10.5% -3.6% 4.1% -8.8% 5.4% -4.4% -5.4% 3.1% 3.4% Net Income/Assets Return on Assets CDN$
5Yr Median -32.5% -34.9% -13.0% -10.3% -3.6% 4.1% 4.1% 4.1% -3.6% -4.4% -4.4% 3.1% 3.1% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ -17.8% -235.2% 32.6% 11.9% -4.1% 4.3% -9.3% 9.6% -5.0% -7.1% 4.0% 4.2% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median -59.2% -115.8% -17.8% -13.2% -4.1% 4.3% 4.3% 4.3% -4.1% -5.0% -5.0% 4.0% 4.0% <-Median-> 5 Return on Equity CDN$
$3.27 <-12 mths -76.48%
Net Income CDN$ -$7.049 -$25.78 $14.11 $27.62 -$9.19 $10.29 -$22.15 $32.48 -$14.50 -$19.24 $11.27 $13.90 $23.67 $5.61 153.91% <-Total Growth 10 Net Income CDN$
Increase 53.04% 265.70% -154.73% 95.74% -133.26% -211.97% -315.36% -246.60% -144.64% 32.76% -158.54% 23.36% 70.32% -76.29% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average -$21.4 -$17.8 -$11.3 $0.9 -$0.1 $3.4 $4.1 $7.8 -$0.6 -$2.6 -$2.4 $4.8 $3.0 $7.0 #NUM! <-IRR #YR-> 10 Net Income CDN$ 153.91%
Operating Cash Flow -$6.34 -$14.75 -$13.95 $12.13 $12.21 $0.13 $5.33 $58.32 $33.93 -$10.08 $68.02 $60.28 #NUM! <-IRR #YR-> 5 Net Income CDN$ 162.74%
Investing Cash Flow -$19.215 $12.50 $11.56 -$5.58 -$64.36 $20.53 -$16.32 $10.02 -$26.88 -$12.65 -$50.31 -$77.93 #NUM! <-IRR #YR-> 10 5 Yr Running Average CDN$ 126.92%
Total Accruals $18.51 -$23.53 $16.51 $21.07 $42.96 -$10.37 -$11.17 -$35.86 -$21.55 $3.49 -$6.44 $31.55 2.94% <-IRR #YR-> 5 5 Yr Running Average CDN$ 15.60%
Total Assets $54.23 $25.58 $44.78 $262.51 $253.60 $252.89 $250.86 $601.56 $330.23 $358.65 $363.34 $406.03 Balance Sheet Assets CDN$
Accruals Ratio 34.12% -92.01% 36.87% 8.03% 16.94% -4.10% -4.45% -5.96% -6.53% 0.97% -1.77% 7.77% -1.77% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 1.64 1.75 -1.39 2.88 -1.08 46.38 -18.52 0.75 -0.32 -2.16 0.18 0.18 -0.07 <-Median-> 10 EPS/CF Ratio CDN$
$25.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $13.9
$22.2 $0.0 $0.0 $0.0 $0.0 $13.9
$17.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $4.8
-$4.1 $0.0 $0.0 $0.0 $0.0 $4.8
Financial Cash Flow $11.77 -$7.83 $15.39 $68.32 -$0.62 $14.13 $20.41 $296.12 -$259.84 -$26.41 -$21.19 -$26.33 C F Statement Fin. C. F CDN$
Total Accruals $6.73 -$15.70 $1.12 -$47.25 $43.59 -$24.50 -$31.58 -$331.98 $238.29 $29.90 $14.75 $57.87 Accruals CDN$
Accruals Ratio 12.41% -61.38% 2.50% -18.00% 17.19% -9.69% -12.59% -55.19% 72.16% 8.34% 4.06% 14.25% 8.34% <-Median-> 5 Ratio CDN$
Cash US$ $432.19 $175.25 $130.39 $126.31 $93.43 $102.03 Cash US$
Cash CDN$ $3.69 $16.68 $91.54 $38.77 $72.76 $82.19 $441.40 $174.95 $138.69 $146.53 $129.38 $135.68 Cash CDN$
Cash per Share $0.09 $0.27 $0.98 $0.39 $0.71 $0.75 $3.58 $1.44 $1.16 $1.22 $1.07 $1.15 $1.22 <-Median-> 5 Cash per Share CDN$
% of share value. 10.66% 14.60% 34.24% 31.11% 32.71% 11.70% 61.02% 31.78% 32.58% 35.02% 57.87% 62.94% 35.02% <-Median-> 5 % of Stock Price CDN$
http://www.cantechletter.com/2013/03/wi-lan-ceo-jim-skippen-keeps-buying-his-own-stock0312/
Notes:
December 3, 2016. Last estimates were for 2015 and 2016 of $98.80M, $91.50M and $60.00M for Revenue US$ for 2015, 2016 and 2017, $0.06 and $0.02 for EPS US$, $0.52 and 0.65 for CFPS US$ and $15.10M for Net Income for 2015 US$.
December 6, 2015. Last estimates were for 2014, 2015 and 2016 of $97.5M, $106M and $142M US$ For Revenue, $0.10 and $0.13 for EPS for 2014 and 2015 US$, $0.45, $0.52 and $0.65 for CFPS US$,
$14.5M and $15.1M for 2014 and 2015 for Net Income US$.
November 1, 2014. Last estimates were for 2013, 2014 and 2015 of $82.58M, 114.99M and $146M US$ for Revenue, $0.11, $0.48 and $0.59 EPS US$, -$0.05 and $0.09 for CFPS for 2013 and 2014.
September 29, 2013. The last estimates were for 2012 and 2013 of $96.35M and $117.8M for Revenue, $.40 and $0.55 ($.077 for 2013).
July 28, 2012. The last estimates I got were for EPS for 2010 to 2012 and were $.08, $.30 and $.57.
Jan 31, 2010. I got the financials for Oct 2009 from the internet annoucement for the 3 andf 12 months ending 31 Oct 2009.
Jul 2009, the company annouced it will be changing its year end to Dec, effect 31 Dec 2009. So the figures for Oct 31, 2009 will not be the final ones for the company.
The CEO and CFO are listed as Officers of the company in the insider trading report. They should be listed as CEO and CFO.
Jim Skippen, Chairman & CEO
Shaun McEwan, CFO
Bill Middleton, Senior VP & General Counsel
Jung Yee, CTO
Sector:
Telecom Service, Utilities
What should this stock accomplish?
Would I buy this company and Why.
I would not buy this company. I do not like its business model. It is a patent troll and I do not like this business.
Dividends
Dividends are payable mostly in Cycle 1, in months of January, April, July and October. Dividends are declared in one month and paid in the following month.
For example, the dividend declared for Shareholders of record on December 13, 2013 was payable on January 6. 2014.
Would I consider buying this company?
No. They seem now to be patent trolls and I do not like this business model.
Why am I following this stock.
I am still following stock because I once owned it.
Why I bought this stock.
I bought this company in 2000, as it was an up and coming company in communications. I sold it in 2006 after losing most of my investment. This stock has never recovered from the bubble that occurred in 2000.
I lost all hope of ever making any money on this stock.
The other thing is that they completely refocused their company, or completely changed it to earn money on their patents.
How they make their money.
Wi-LAN Inc. is an intellectual property licensing company. The Company develops, acquires, licenses and enforces a range of patented technologies which are utilized in
products in the communications and consumer electronics markets.
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 Aug 8 2012 Oct 5 2013 Nov 1 2014 Dec 6 2015 Dec 3 2016
Skippen, James 0.493 0.41% 0.540 0.45% 0.600 0.50% 0.923 0.76% 0.782 0.66%
CEO - Shares - Amount $2.232 $1.918 $2.089 $1.708 $1.423
Options - percentage 2.148 1.79% 2.214 1.84% 2.889 2.39% 3.023 2.55%
Options - amount $7.625 $7.704 $5.345 $5.501
McEwan, Michael Shaun 0.058 0.05% 0.066 0.05% 0.066 0.05% 0.066 0.06%
CFO - Shares - Amount $0.204 $0.230 $0.122 $0.120
Options - percentage 0.845 0.70% 0.837 0.70% 0.714 0.59% 0.801 0.68%
Options - amount $2.999 $2.913 $1.321 $1.457
Vladescu, Michael 0.064 0.05% 0.080 0.07% 0.083 0.07% COO
Officer - Shares - Amount $0.223 $0.149 $0.151
Options - percentage 0.655 0.54% 0.648 0.54% 0.727 0.61%
Options - amount $2.280 $1.198 $1.322
Bramson, Robert S. 0.010 0.01% 0.012 0.01% 0.012 0.01% 0.038 0.03%
Director - Shares - Amount $0.035 $0.042 $0.022 $0.069
Options - percentage 0.139 0.12% 0.139 0.12% 0.129 0.11% 0.158 0.13%
Options - amount $0.494 $0.485 $0.238 $0.288
Fattouche, Michel 2.207 1.82% 2.232 1.86% 2.232 1.86% 2.032 1.68% 1.917 1.62%
Director - Shares - Amount $9.999 $7.925 $7.768 $3.760 $3.489
Options - percentage 0.128 0.11% 0.128 0.11% 0.116 0.10% 0.145 0.12%
Options - amount $0.454 $0.446 $0.215 $0.264
McCarten, W. Paul 0.030 0.02% 0.050 0.04% 0.050 0.04%
Chairman - Shares - Amt $0.104 $0.093 $0.091
Options - percentage 0.109 0.09% 0.127 0.11% 0.127 0.11%
Options - amount $0.378 $0.236 $0.231
Increase in O/S Shares 1.173 0.98% 0.205 0.17% 0.423 0.35% 0.625 0.52%
due to SO $4.165 $0.729 $1.472 $1.157
Book Value $3.078 $0.478 $1.160 $2.056
Insider Buying -$0.117 -$0.118
Insider Selling $2.675 $0.819
Net Insider Selling $0.629 $2.558 $0.700
% of Market Cap 0.15% 1.14% 0.32%
Directors 8 8 8 8
Women 0 0% 0 0% 1 13% 1 13%
Minorities 0 0% 0 0% 0 0% 1 13%
Institutions/Holdings 79 38.46% 83 34.89% 68 32.85% 67 18.15% 59 29.28%
Total Shares Held 46.676 38.40% 42.076 35.09% 39.452 32.81% 21.917 18.14% 34.708 29.30%
Increase/Decrease 1.000 2.19% -0.816 -1.90% 1.052 2.74% -14.969 -40.58% -5.077 -12.76%
Starting No. of Shares 45.676 42.892 38.400 36.886 39.785
Copyright 2008 Website of SPBrunner. All rights reserved.
http://www.cantechletter.com/2014/04/wi-lans-valuation-looks-compelling-going-q1-earnings/