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
Dorel Industries Inc. TSX: DII.B OTC: DIIBF www.dorel.com Fiscal Yr: Dec-30
12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G Currency
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Reporting Currency Reporting Currency
split split
USD - CDN$ 1.1630 1.1652 0.9881 1.2246 1.0466 0.9946 1.0170 0.9949 1.0636 1.1601 1.3847 1.3427 1.2505 1.2505 1.2505 USD - CDN$
$2,604.0 <-12 mths 0.03%
Sales US$* $1,761 $1,748 $1,814 $2,182 $2,140 $2,313 $2,364 $2,491 $2,435 $2,678 $2,683 $2,603 $2,632 $2,697 $2,715 48.92% <-Total Growth 10 Revenue US$
Increase US$ 4.5% -0.7% 3.8% 20.3% -1.9% 8.1% 2.2% 5.3% -2.2% 9.9% 0.2% -3.0% 1.1% 2.5% 0.7% 4.06% <-IRR #YR-> 10 Revenue 48.92% US$
5 year Running Average $1,303.7 $1,469.9 $1,634.2 $1,837.9 $1,928.9 $2,039.3 $2,162.6 $2,298.0 $2,348.7 $2,456.2 $2,530.3 $2,578.1 $2,606.3 $2,658.6 $2,666.1 1.94% <-IRR #YR-> 5 Revenue 10.11% US$
Revenue per Share $53.63 $53.19 $54.31 $65.32 $64.92 $70.81 $73.99 $78.74 $76.31 $82.85 $82.99 $80.34 $81.22 $83.23 $83.79 5.78% <-IRR #YR-> 10 5 yr Running Average 75.39% US$
Increase 4.4% -0.8% 2.1% 20.3% -0.6% 9.1% 4.5% 6.4% -3.1% 8.6% 0.2% -3.2% 1.1% 2.5% 0.7% 3.58% <-IRR #YR-> 5 5 yr Running Average 19.21% US$
5 year Running Average $40.98 $45.11 $49.64 $55.56 $58.27 $61.71 $65.87 $70.76 $72.95 $76.54 $78.98 $80.25 $80.74 $82.13 $82.31 4.21% <-IRR #YR-> 10 Revenue Per share 51.02% US$
P/S (Price/Sales) Med 0.56 0.47 0.64 0.35 0.34 0.46 0.37 0.40 0.50 0.41 0.34 0.31 1.66% <-IRR #YR-> 5 Revenue Per share 8.58% US$
P/S (Price/Sales) Close 0.44 0.51 0.56 0.36 0.48 0.50 0.34 0.45 0.50 0.42 0.42 0.36 0.32 0.32 0.31 5.93% <-IRR #YR-> 10 5 yr Running Average 77.88% US$
*Revenue in M US$ P/S Med 10 yr 0.39 5 yr 0.40 -16.03% Diff M/C 4.03% <-IRR #YR-> 5 5 yr Running Average 21.83% US$
-$1,748 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,603
-$2,364 $0 $0 $0 $0 $2,603
-$1,470 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,578
-$2,163 $0 $0 $0 $0 $2,578
-$53.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $80.34
-$73.99 $0.00 $0.00 $0.00 $0.00 $80.34
-$45.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $80.25
-$65.87 $0.00 $0.00 $0.00 $0.00 $80.25
$3,256.3 <-12 mths -6.84%
Sales CDN$ * $2,048 $2,037 $1,792 $2,672 $2,240 $2,300 $2,404 $2,478 $2,590 $3,106 $3,716 $3,495 $3,291 $3,373 $3,395 71.61% <-Total Growth 10 Revenue CDN$
Increase 1.3% -0.5% -12.0% 49.1% -16.2% 2.7% 4.5% 3.1% 4.5% 19.9% 19.6% -5.9% -5.8% 2.5% 0.7% 5.55% <-IRR #YR-> 10 Revenue 71.61% CDN$
5 year Running Average $1,712 $1,827 $1,883 $2,114 $2,158 $2,208 $2,282 $2,419 $2,403 $2,576 $2,859 $3,077 $3,240 $3,396 $3,454 7.77% <-IRR #YR-> 5 Revenue 45.37% CDN$
Revenue per Share $62.37 $61.98 $53.66 $79.99 $67.94 $70.43 $75.25 $78.34 $81.17 $96.11 $114.92 $107.87 $101.57 $104.08 $104.77 5.35% <-IRR #YR-> 10 5 yr Running Average 68.47% CDN$
Increase 1.19% -0.63% -13.43% 49.07% -15.06% 3.66% 6.84% 4.11% 3.61% 18.41% 19.57% -6.14% -5.84% 2.47% 0.67% 6.16% <-IRR #YR-> 5 5 yr Running Average 34.86% CDN$
5 year Running Average $54.13 $56.14 $57.23 $63.93 $65.19 $66.80 $69.45 $74.39 $74.63 $80.26 $89.16 $95.68 $100.33 $104.91 $106.64 5.70% <-IRR #YR-> 10 Revenue Per share 74.03% CDN$
P/S (Price/Sales) Med 0.58 0.47 0.64 0.35 0.36 0.48 0.37 0.40 0.48 0.38 0.31 0.31 7.47% <-IRR #YR-> 5 Revenue Per share 43.35% CDN$
P/S (Price/Sales) Close 0.44 0.51 0.56 0.35 0.48 0.49 0.34 0.46 0.50 0.42 0.27 0.36 0.32 0.32 0.32 5.48% <-IRR #YR-> 10 5 yr Running Average 70.43% CDN$
*Revenue in M CDN $ P/S Med 10 yr 0.38 5 yr 0.38 -14.19% Diff M/C 6.62% <-IRR #YR-> 5 5 yr Running Average 37.76% CDN$
-$2,037 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,495
-$2,404 $0 $0 $0 $0 $3,495
-$1,827 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,077
-$2,282 $0 $0 $0 $0 $3,077
-$61.98 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $107.87
-$75.25 $0.00 $0.00 $0.00 $0.00 $107.87
-$56.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $95.68
-$69.45 $0.00 $0.00 $0.00 $0.00 $95.68
-$0.60 <-12 mths -66.67%
EPS Basic US$ $2.78 $2.70 $2.63 $3.38 $3.23 $3.89 $3.22 $3.42 $1.81 -$0.66 $0.80 -$0.36 -113.33% <-Total Growth 10 EPS Basic US$
EPS Diluted* $2.77 $2.70 $2.63 $3.38 $3.21 $3.85 $3.21 $3.39 $1.79 -$0.66 $0.79 -$0.36 $2.05 $2.83 $3.62 -113.33% <-Total Growth 10 EPS Diluted US$
Increase -8.9% -2.5% -2.6% 28.5% -5.0% 19.9% -16.6% 5.6% -47.2% -136.9% -219.7% -145.6% -669.4% 38.0% 27.9% #NUM! <-IRR #YR-> 10 Earnings per Share -113.33% US$
Earnings Yield 11.6% 10.0% 8.7% 14.6% 10.2% 11.0% 12.8% 9.5% 4.7% -1.9% 2.3% -1.2% 7.8% 10.7% 13.7% #NUM! <-IRR #YR-> 5 Earnings per Share -111.21% US$
5 year Running Average $2.20 $2.56 $2.69 $2.90 $2.94 $3.15 $3.26 $3.41 $3.09 $2.32 $1.70 $0.99 $0.72 $0.93 $1.79 -9.06% <-IRR #YR-> 10 5 yr Running Average -61.33% US$
10 year Running Average $1.47 $1.69 $1.88 $2.16 $2.35 $2.68 $2.91 $3.05 $3.00 $2.63 $2.43 $2.12 $2.07 $2.01 $2.05 -21.19% <-IRR #YR-> 5 5 yr Running Average -69.59% US$
#Per share in US $ (based on exc rate to 1999, 2000 & 01 are net income from continuing operations) E/P 10 Yrs 9.09% 5Yrs 2.28%
-$2.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.36
-$3.21 $0.00 $0.00 $0.00 $0.00 -$0.36
-$2.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.99
-$3.26 $0.00 $0.00 $0.00 $0.00 $0.99
-$0.75 <-12 mths -55.22%
EPS Basic CDN$ $3.23 $3.15 $2.60 $4.14 $3.38 $3.87 $3.27 $3.40 $1.93 -$0.77 $1.11 -$0.48 -115.36% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* $3.22 $3.15 $2.60 $4.14 $3.36 $3.83 $3.26 $3.37 $1.90 -$0.77 $1.09 -$0.48 $2.56 $3.54 $4.53 -115.36% <-Total Growth 10 EPS Diluted CDN$
Increase -11.7% -2.3% -17.4% 59.3% -18.8% 14.0% -14.7% 3.3% -43.6% -140.2% -242.9% -144.2% -630.3% 38.0% 27.9% #NUM! <-IRR #YR-> 10 Earnings per Share -115.36% CDN$
Earnings Yield 11.7% 10.0% 8.7% 14.8% 10.3% 11.1% 12.8% 9.4% 4.7% -1.9% 3.5% -1.2% 7.8% 10.7% 13.7% #NUM! <-IRR #YR-> 5 Earnings per Share -114.81% CDN$
5 year Running Average $2.86 $3.21 $3.12 $3.35 $3.29 $3.41 $3.44 $3.59 $3.15 $2.32 $1.77 $1.02 $0.86 $1.19 $2.25 -10.79% <-IRR #YR-> 10 5 yr Running Average -68.08% CDN$
10 year Running Average $1.97 $2.23 $2.39 $2.70 $2.85 $3.14 $3.32 $3.36 $3.25 $2.81 $2.59 $2.23 $2.23 $2.17 $2.28 -21.51% <-IRR #YR-> 5 5 yr Running Average -70.21% CDN$
Per Share In CDN$ (from 2000 based on exchange rate) E/P 10 Yrs 9.02% 5Yrs 3.49%
-$3.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.48
-$3.26 $0.00 $0.00 $0.00 $0.00 -$0.48
-$3.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.02
-$3.44 $0.00 $0.00 $0.00 $0.00 $1.02
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 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends US$
$0.38
Dividend US$ $0.50 $0.50 $0.50 $0.58 $0.60 $0.90 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 140.00% <-Total Growth 9 Dividends US$
Increase 0.0% 0.0% 15.0% 4.3% 50.0% 33.3% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.00% <-Median-> 9 Increase US$
Dividends 5 Yr Running $0.54 $0.62 $0.76 $0.90 $1.02 $1.14 $1.20 $1.20 $1.20 113.08% <-Total Growth 5 Dividends 5 Yr Running US$
Yield H/L Price 1.44% 2.19% 2.26% 1.75% 2.17% 2.86% 3.15% 3.57% 4.27% 4.84% 4.74% 2.56% <-Median-> 10 Yield H/L Price US$
Yield on High Price 1.23% 1.71% 1.53% 1.56% 1.75% 2.35% 2.72% 3.12% 3.40% 3.90% 4.29% 2.05% <-Median-> 10 Yield on High Price US$
Yield on Low Price 1.73% 3.05% 4.30% 2.00% 2.87% 3.64% 3.72% 4.17% 5.76% 6.40% 5.28% 3.68% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 1.65% 2.16% 1.60% 1.64% 2.40% 2.53% 3.15% 3.47% 3.47% 4.15% 4.55% 4.55% 4.55% 2.46% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 19.01% 14.79% 15.58% 14.94% 18.69% 26.55% 67.04% -181.82% 151.90% -333.33% 58.54% 42.40% 33.15% 17.13% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 16.43% 18.05% 24.43% 38.64% 59.86% 115.15% 166.20% 129.03% 67.19% 31.54% <-Median-> 6 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 9.98% 20.91% 8.06% 24.07% 11.80% 26.55% 26.54% 38.15% 49.29% 22.63% 26.85% 25.42% #DIV/0! 23.35% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 12.69% 15.80% 17.49% 24.15% 27.46% 30.33% 30.19% 29.89% #DIV/0! 20.82% <-Median-> 6 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 11.69% 10.54% 10.51% 10.42% 10.68% 14.09% 24.45% 21.75% 23.12% 27.25% 26.85% 25.42% #DIV/0! 12.89% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 10.74% 11.38% 13.88% 16.01% 18.46% 21.58% 24.50% 24.69% #DIV/0! 14.95% <-Median-> 6 DPR CF WC 5 Yr Running US$
Median Values 5 Yr Med 5 Yr Cl 3.57% 3.47% 5 Yr Med Payout 26.55% 26.55% 23.12% 10.22% <-IRR #YR-> 9 Dividends #DIV/0! US$
* Dividends per share 5 Yr Med and Cur. 27.51% 31.25% Last Div Inc ---> $0.15 $0.30 100.0% 14.87% <-IRR #YR-> 5 Dividends 100.00% US$
-$0.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20
-$0.60 $0.00 $0.00 $0.00 $0.00 $1.20
Historical Dividends Historical High Div 6.33% Low Div 1.26% Ave Div 3.80% Med Div 2.56% Close Div 2.46% Historical Dividends
High/Ave/Median Values Curr diff Exp. -28.11% 261.16% Cheap 19.91% Cheap 77.76% Cheap 84.71% High/Ave/Median
Yield if held 5 yrs 2.30% 1.85% 1.62% 1.91% 2.43% 2.58% 5.25% 5.42% 3.66% 4.34% 3.81% 3.15% 3.57% 2.51% <-Median-> 10 Paid Median Price US$
Yield if held 10 yrs 5.31% 3.68% 2.66% 3.37% 3.76% 4.14% 4.44% 3.89% 3.99% 4.85% 3.45% 5.25% 5.42% 3.94% <-Median-> 10 Paid Median Price US$
Yield if held 15 yrs 18.37% 10.86% 13.89% 17.99% 11.57% 9.55% 8.84% 6.38% 7.03% 7.51% 5.53% 4.44% 3.89% 10.21% <-Median-> 10 Paid Median Price US$
Yield if held 20 yrs 33.06% 26.07% 33.34% 37.55% 23.13% 12.74% 8.84% 6.38% 33.06% <-Median-> 5 Paid Median Price US$
Yield if held 25 yrs 44.08% 26.07% 33.34% #NUM! <-Median-> 0 Paid Median Price US$
Cost covered if held 5 years 2.30% 3.70% 4.87% 6.90% 10.81% 8.83% 16.53% 20.22% 15.54% 20.63% 19.06% 15.73% 17.84% 9.82% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 5.31% 7.36% 7.97% 12.16% 16.74% 16.46% 17.65% 19.39% 23.85% 33.85% 26.06% 42.80% 47.32% 16.60% <-Median-> 10 Paid Median Price US$
Cost covered if held 15 years 18.37% 21.72% 41.67% 64.93% 51.56% 37.95% 35.17% 31.75% 42.05% 52.42% 44.09% 39.83% 38.87% 39.81% <-Median-> 10 Paid Median Price US$
Cost covered if held 20 years 131.33% 103.72% 165.99% 224.53% 161.43% 101.64% 79.36% 63.63% 161.43% <-Median-> 5 Paid Median Price US$
Cost covered if held 25 years 351.75% 234.06% 332.67% #NUM! <-Median-> 0 Paid Median Price US$
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 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends CDN$
Dividend CDN$ $0.49 $0.61 $0.52 $0.57 $0.61 $0.90 $1.28 $1.39 $1.66 $1.61 $1.50 $1.50 $1.50 226.13% <-Total Growth 9 Dividends CDN$
Increase 23.9% -14.5% 9.3% 6.7% 46.7% 42.5% 9.1% 19.4% -3.0% -6.9% 0.0% 0.0% 9.29% <-Median-> 9 Increase CDN$
Dividends 5 Yr Running $0.56 $0.64 $0.78 $0.95 $1.17 $1.37 $1.49 $1.53 $1.55 143.15% <-Total Growth 5 Dividends 5 Yr Running CDN$
Yield H/L Price 1.63% 2.64% 1.67% 1.63% 2.44% 2.51% 3.35% 4.02% 4.80% 5.57% 5.69% 2.58% <-Median-> 10 Yield H/L Price CDN$
Yield on High Price 1.23% 1.71% 1.52% 1.50% 1.76% 2.33% 2.87% 3.34% 3.96% 4.02% 4.15% 2.05% <-Median-> 10 Yield on High Price CDN$
Yield on Low Price 1.73% 3.05% 3.43% 1.90% 2.81% 3.61% 3.87% 4.35% 5.81% 6.09% 4.92% 3.52% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 1.65% 2.19% 1.61% 1.66% 2.39% 2.49% 3.15% 3.48% 5.30% 4.15% 4.55% 4.55% 4.55% 2.44% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 19.01% 14.79% 15.58% 14.94% 18.69% 26.55% 67.04% -181.82% 151.90% -333.33% 58.54% 42.40% 33.15% 17.13% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 16.36% 17.89% 24.65% 40.90% 65.80% 133.49% 172.58% 128.90% 69.17% 32.77% <-Median-> 6 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 9.98% 20.91% 8.06% 24.07% 11.80% 26.55% 26.54% 38.15% 49.29% 22.63% 26.85% 25.42% #DIV/0! 23.35% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 12.83% 15.80% 17.45% 24.49% 28.65% 30.63% 30.33% 29.91% #DIV/0! 20.97% <-Median-> 6 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 11.69% 10.54% 10.51% 10.42% 10.68% 14.09% 24.45% 21.75% 23.12% 27.25% 26.85% 25.42% #DIV/0! 12.89% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 10.72% 11.33% 13.97% 16.26% 18.90% 22.00% 24.55% 24.73% #DIV/0! 15.12% <-Median-> 6 DPR CF WC 5 Yr Running CDN$
Median Values 5 Yr Med 5 Yr Cl 4.02% 3.48% 5 Yr Med Payout 26.55% 26.55% 23.12% 14.04% <-IRR #YR-> 9 Dividends #DIV/0! CDN$
* Dividends per share 5 Yr Med and Cur. 13.02% 30.68% Last Div Inc ---> $0.15 $0.30 100.0% 21.43% <-IRR #YR-> 5 Dividends 164.05% CDN$
-$0.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.61
-$0.61 $0.00 $0.00 $0.00 $0.00 $1.61
Historical Dividends Historical High Div 6.06% Low Div 1.26% Ave Div 3.66% Med Div 2.58% Close Div 2.44% Historical Dividends
High/Ave/Median Values Curr diff Exp. -24.99% 260.79% Cheap 24.20% Cheap 76.20% Cheap 86.35% High/Ave/Median
Future Div Yield Div Yd 28.15% earning in 10.00 Years at IRR of 20.00% Div Inc. 519.17% Future Div Yield
Future Div Yield Div Yd 70.04% earning in 15.00 Years at IRR of 20.00% Div Inc. 1440.70% Future Div Yield
Div Gr, Cap Gain # yrs -> 7 Div Gr Cap Gain -7.65% 2006 <-SOLD Today Div Gr, Cap Gain
I am earning Div start $0.00 0.00% RRSP $27.31 1999 $25.22 20.87% I am earning
Yield if held 5 yrs 1.50% 1.58% 1.27% 1.57% 2.12% 2.60% 4.56% 5.61% 4.87% 5.72% 4.75% 3.88% 4.07% 2.36% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 yrs 3.68% 2.92% 1.89% 2.20% 2.39% 2.71% 3.29% 3.38% 4.56% 5.59% 4.36% 5.37% 6.05% 3.11% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 yrs 10.54% 10.00% 10.47% 13.07% 8.64% 6.66% 6.10% 5.02% 6.40% 6.32% 4.54% 3.87% 3.64% 7.65% <-Median-> 10 Paid Median Price CDN$
Yield if held 20 yrs 19.10% 20.84% 27.84% 37.98% 22.81% 11.17% 7.17% 5.41% 22.81% <-Median-> 5 Paid Median Price CDN$
Yield if held 25 yrs 32.01% 24.50% 30.01% #NUM! <-Median-> 0 Paid Median Price CDN$
Cost covered if held 5 years 1.50% 2.85% 3.96% 6.03% 9.75% 9.34% 13.86% 19.14% 17.11% 24.28% 23.57% 19.80% 21.11% 9.55% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 3.68% 5.28% 5.88% 8.48% 11.03% 11.22% 12.85% 15.47% 22.03% 33.47% 30.97% 41.27% 50.50% 11.12% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 10.54% 18.06% 32.59% 50.32% 39.80% 27.58% 23.80% 23.00% 30.94% 37.84% 33.74% 32.62% 34.35% 29.26% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 20 years 79.09% 81.36% 127.51% 183.71% 136.57% 82.95% 60.41% 51.04% 127.51% <-Median-> 5 Paid Median Price CDN$
Cost covered if held 25 years 237.85% 206.53% 283.01% #NUM! <-Median-> 0 Paid Median Price CDN$
Based on EPS 3 yrs trailing $38.85 $42.59 $46.01 $45.23 $49.94 $52.37 $57.33 $57.12 $57.78 $49.09 $34.15 $23.54 #NUM! $12.40 #NUM! -44.73% <-Total Growth 10 Graham Price CDN$
Graham Price CDN$ $41.55 $44.80 $40.28 $58.86 $51.59 $55.65 $53.62 $55.87 $43.85 $43.08 $34.09 $32.82 $48.66 $57.17 $64.66 -26.74% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 0.88 0.64 0.85 0.48 0.48 0.61 0.53 0.57 0.88 0.86 1.04 1.01 0.68 0.73 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.11 0.75 1.00 0.61 0.67 0.68 0.65 0.69 1.01 0.97 1.23 1.22 0.74 0.83 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.64 0.53 0.71 0.34 0.30 0.54 0.41 0.44 0.75 0.74 0.84 0.81 0.63 0.63 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 0.66 0.70 0.74 0.48 0.63 0.62 0.48 0.64 0.92 0.93 0.92 1.18 0.68 0.58 0.51 0.69 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close -33.50% -29.59% -25.54% -52.43% -36.93% -38.00% -52.35% -35.65% -7.73% -7.10% -8.09% 18.22% -32.16% -42.26% -48.95% -30.60% <-Median-> 10 Graham Price CDN$
Price Close CDN $27.63 $31.54 $29.99 $28.00 $32.54 $34.50 $25.55 $35.95 $40.46 $40.02 $31.33 $38.80 $33.01 $33.01 $33.01 23.02% <-Total Growth 10 Stock Price CDN$
Increase -33.15% 14.15% -4.91% -6.64% 16.21% 6.02% -25.94% 40.70% 12.55% -1.09% -21.71% 23.84% -14.92% 0.00% 0.00% 2.09% <-IRR #YR-> 10 Stock Price 23.02% CDN$
P/E 8.58 10.03 11.54 6.76 9.69 9.01 7.83 10.66 21.25 -52.27 28.64 -80.27 12.88 9.33 7.29 8.71% <-IRR #YR-> 5 Stock Price 51.86% CDN$
Trailing P/E 7.57 9.79 9.53 10.77 7.86 10.27 6.67 11.01 12.00 21.02 -40.92 35.47 -68.29 12.88 9.33 4.74% <-IRR #YR-> 10 Price & Dividend CDN$
Median 10, 5 Yrs D. per yr 2.64% 4.44% % Tot Ret 55.82% 33.74% Price Inc 12.55% P/E: 9.35 10.66 13.15% <-IRR #YR-> 5 Price & Dividend CDN$
-$31.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38.80
-$25.55 $0.00 $0.00 $0.00 $0.00 $38.80
-$31.54 $0.49 $0.61 $0.52 $0.57 $0.61 $0.90 $1.28 $1.39 $1.66 $40.41
-$25.55 $0.90 $1.28 $1.39 $1.66 $40.41
Price Median H/L $36.48 $28.83 $34.41 $27.97 $24.80 $34.10 $28.16 $31.58 $38.73 $36.84 $35.29 $33.29 $33.32 15.49% <-Total Growth 10 Stock Price CDN$
Increase -11.46% -20.98% 19.36% -18.70% -11.35% 37.53% -17.42% 12.13% 22.64% -4.88% -4.21% -5.65% 0.08% 1.45% <-IRR #YR-> 10 Stock Price 15.49% CDN$
P/E 11.32 9.16 13.24 6.76 7.38 8.91 8.63 9.36 20.34 -48.11 32.25 -68.87 13.00 3.40% <-IRR #YR-> 5 Stock Price 18.22% CDN$
Trailing P/E 10.00 8.95 10.94 10.76 5.99 10.15 7.35 9.67 11.48 19.35 -46.08 30.43 -68.92 4.43% <-IRR #YR-> 10 Price & Dividend CDN$
P/E on Run. 5 yr Ave 12.74 8.98 11.03 8.35 7.53 9.99 8.19 8.79 12.31 15.87 19.89 32.50 38.63 7.87% <-IRR #YR-> 5 Price & Dividend CDN$
P/E on Run. 10 yr Ave 12.74 8.98 11.03 8.35 7.53 9.99 8.19 8.79 12.31 15.87 19.89 32.50 38.63 11.32 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 2.98% 4.47% % Tot Ret 67.28% 56.75% Price Inc -4.21% P/E: 8.77 9.36 Count 25 Years of data
-$28.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $33.29
-$28.16 $0.00 $0.00 $0.00 $0.00 $33.29
-$28.83 $0.49 $0.61 $0.52 $0.57 $0.61 $0.90 $1.28 $1.39 $1.66 $34.90
-$28.16 $0.90 $1.28 $1.39 $1.66 $34.90
High Months Feb Dec Jul Sep Nov May Jan Nov May Jun Jan Dec May
Price High CDN $ $46.30 $33.80 $40.25 $35.84 $34.34 $38.05 $34.60 $38.37 $44.45 $41.69 $41.97 $40.12 $36.16 18.70% <-Total Growth 10 Stock Price CDN$
Increase -1.38% -27.00% 19.08% -10.96% -4.19% 10.80% -9.07% 10.90% 15.85% -6.21% 0.67% -4.41% -9.87% 1.73% <-IRR #YR-> 10 Stock Price 18.70% CDN$
P/E 14.37 10.74 15.49 8.66 10.22 9.94 10.60 11.38 23.35 -54.45 38.37 -83.00 14.11 3.00% <-IRR #YR-> 5 Stock Price 15.95% CDN$
Trailing P/E 12.69 10.49 12.79 13.79 8.30 11.33 9.04 11.75 13.18 21.90 -54.82 36.67 -74.81 14.52 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 0.67% P/E: 10.41 11.38 23.19 P/E Ratio Historical High CDN$
-$33.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.12
-$34.60 $0.00 $0.00 $0.00 $0.00 $40.12
Low Months Dec Aug Sep Dec Mar Feb Sep Jan Aug Sep Dec Jan Mar
Price Low CDN $26.66 $23.85 $28.56 $20.10 $15.25 $30.15 $21.72 $24.78 $33.00 $31.98 $28.60 $26.46 $30.47 10.94% <-Total Growth 10 Stock Price CDN$
Increase -24.80% -10.54% 19.75% -29.62% -24.13% 97.70% -27.96% 14.09% 33.17% -3.09% -10.57% -7.48% 15.15% 1.04% <-IRR #YR-> 10 Stock Price 10.94% CDN$
P/E 8.28 7.58 10.99 4.86 4.54 7.87 6.65 7.35 17.33 -41.77 26.14 -54.74 11.89 4.03% <-IRR #YR-> 5 Stock Price 21.82% CDN$
Trailing P/E 7.31 7.40 9.08 7.73 3.68 8.97 5.67 7.59 9.78 16.80 -37.35 24.19 -63.04 8.91 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc -3.09% P/E: 7.00 7.35 6.79 P/E Ratio Historical Low CDN$
-$23.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.46
-$21.72 $0.00 $0.00 $0.00 $0.00 $26.46
Graham Price US$ $35.73 $38.45 $40.76 $48.07 $49.30 $55.95 $52.72 $56.15 $41.23 $38.78 $24.62 $24.07 $38.91 $45.72 $51.71 -37.39% <-Total Growth 10 Graham Price US$
Price/GP Ratio Med 0.84 0.64 0.85 0.48 0.45 0.59 0.52 0.56 0.93 0.87 1.14 1.03 0.65 0.72 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 1.04 0.75 1.00 0.61 0.66 0.66 0.65 0.68 1.07 0.99 1.44 1.28 0.72 0.84 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 0.65 0.53 0.71 0.34 0.24 0.51 0.40 0.44 0.78 0.74 0.85 0.78 0.58 0.61 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 0.67 0.70 0.74 0.48 0.64 0.63 0.47 0.63 0.92 0.89 1.41 1.20 0.68 0.58 0.51 0.69 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close -33.39% -29.59% -25.54% -51.73% -36.43% -37.34% -52.58% -36.59% -7.63% -10.76% 40.59% 20.28% -32.23% -42.32% -49.00% -30.98% <-Median-> 10 Graham Price US$
Price Close US$ $23.80 $27.07 $30.35 $23.20 $31.34 $35.06 $25.00 $35.61 $38.08 $34.61 $34.61 $28.95 $26.37 $26.37 $26.37 6.95% <-Total Growth 10 Stock Price US$
Increase -30.99% 13.73% 12.13% -23.56% 35.09% 11.87% -28.69% 42.44% 6.94% -9.11% 0.00% -16.35% -8.91% 0.00% 0.00% 0.67% <-IRR #YR-> 10 Stock Price 6.95% US$
P/E 7.39 8.60 11.68 5.61 9.33 9.16 7.66 10.56 20.00 -45.20 31.64 -59.89 10.29 7.45 5.83 2.98% <-IRR #YR-> 5 Stock Price 15.80% US$
Trailing P/E 6.52 8.40 9.65 8.93 7.57 10.44 6.53 10.91 11.29 18.18 -45.20 26.46 -54.55 10.29 7.45 3.58% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 2.90% 4.28% % Tot Ret 81.14% 58.98% Price Inc 0.00% P/E: 9.24 10.56 7.26% <-IRR #YR-> 5 Price & Dividend US$
-$27.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28.95
-$25.00 $0.00 $0.00 $0.00 $0.00 $28.95
-$27.07 $0.50 $0.50 $0.50 $0.58 $0.60 $0.90 $1.20 $1.20 $1.20 $30.15
-$25.00 $0.90 $1.20 $1.20 $1.20 $30.15
Price H/L Median US$ $30.09 $24.74 $34.82 $22.84 $22.14 $32.82 $27.63 $31.48 $38.15 $33.63 $28.08 $24.78 $25.34 0.17% <-Total Growth 10 Stock Price US$
Increase -2.34% -17.79% 40.75% -34.40% -3.09% 48.25% -15.80% 13.93% 21.19% -11.86% -16.49% -11.75% 2.26% 0.02% <-IRR #YR-> 10 Stock Price 0.17% US$
P/E 9.34 7.86 13.40 5.52 6.59 8.57 8.46 9.33 20.04 -43.92 25.67 -51.26 9.88 -2.15% <-IRR #YR-> 5 Stock Price -10.31% US$
Trailing P/E 8.25 7.68 11.07 8.79 5.35 9.77 7.22 9.64 11.31 17.66 -36.67 22.65 -52.42 3.29% <-IRR #YR-> 10 Price & Dividend US$
P/E on Run. 5 yr Ave 13.69 9.66 12.96 7.87 7.53 10.40 8.49 9.24 12.35 14.52 16.48 25.03 35.10 2.14% <-IRR #YR-> 5 Price & Dividend US$
P/E on Run. 10 yr Ave 20.50 14.62 18.48 10.58 9.42 12.26 9.50 10.33 12.73 12.80 11.56 11.67 12.27 9.33 P/E Ratio Historical Median US$
Median 10, 5 Yrs D. per yr 3.27% 4.29% % Tot Ret 99.49% 200.64% Price Inc -11.75% P/E: 8.52 9.33 Count 25 Years of data
High Months Nov May Jan Nov May Jun Jan Dec Jul
Price High US$ $37.06 $29.01 $40.73 $29.27 $32.65 $36.90 $34.36 $38.25 $44.05 $38.49 $35.34 $30.80 $27.95 6.18% <-Total Growth 10 Stock Price US$
Increase 4.36% -21.73% 40.43% -28.15% 11.56% 13.02% -6.88% 11.32% 15.16% -12.62% -8.18% -12.85% -9.25% 0.60% <-IRR #YR-> 10 Stock Price 6.18% US$
P/E 11.50 9.22 15.68 7.07 9.72 9.64 10.53 11.34 23.14 -50.27 32.31 -63.72 10.90 -2.16% <-IRR #YR-> 5 Stock Price -10.36% US$
Trailing P/E 10.16 9.00 12.95 11.26 7.89 10.98 8.97 11.72 13.06 20.22 -46.16 28.15 -57.82 11.34 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 13.06 P/E: 10.12 11.34 16.71 P/E Ratio Historical High US$
-$29.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $30.80
-$34.36 $0.00 $0.00 $0.00 $0.00 $30.80
Low Months Mar Feb Sep Jan Aug Oct Dec Jan Mar
Price Low US$ $23.12 $20.47 $28.90 $16.41 $11.62 $28.73 $20.90 $24.71 $32.25 $28.76 $20.82 $18.76 $22.73 -8.35% <-Total Growth 10 Stock Price US$
Increase -11.45% -11.47% 41.21% -43.21% -29.20% 147.25% -27.25% 18.23% 30.51% -10.82% -27.61% -9.89% 21.16% -0.87% <-IRR #YR-> 10 Stock Price -8.35% US$
P/E 7.18 6.51 11.12 3.97 3.46 7.50 6.40 7.33 16.94 -37.56 19.03 -38.81 8.87 -2.14% <-IRR #YR-> 5 Stock Price -10.24% US$
Trailing P/E 6.34 6.35 9.19 6.32 2.81 8.55 5.46 7.57 9.56 15.11 -27.19 17.15 -47.02 7.33 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 9.56 P/E: 6.86 7.33 5.48 P/E Ratio Historical Low US$
-$20.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.76
-$20.90 $0.00 $0.00 $0.00 $0.00 $18.76
Long Term Debt US$ $552.74 $498.59 $406.26 $449.65 Debt US$
Change -9.80% -18.52% 10.68% -14.16% <-Median-> 2 Change US$
Ratio to Market Cap 0.57 0.62 0.58 0.66 0.58 <-Median-> 3 % of Market C. US$
Long Term Debt CDN$ $641.24 $690.42 $545.48 $562.28 Debt CDN$
Change 7.67% -20.99% 3.08% -6.66% <-Median-> 2 Change CDN$
Ratio to Market Cap 0.50 0.68 0.43 0.53 0.50 <-Median-> 3 % of Market C. CDN$
Goodwill & Intangibles US$ $980 $1,001 $1,137 $1,065 $942 $863 $868 Intangibles Goodwill US$
Change 2.18% 13.59% -6.41% -11.54% -8.32% 0.57% -6.41% <-Median-> 5 Change US$
% of Market Cap 1.25 0.88 1.00 1.10 1.17 1.24 1.27 <--- 1.13 <-Median-> 6 % of Market C. US$
Goodwill & Intangibles CDN$ $997 $996 $1,210 $1,235 $1,304 $1,159 $1,086 Intangibles Goodwill CDN$
Change -0.04% 21.43% 2.08% 5.60% -11.11% -6.33% 2.08% <-Median-> 5 Change CDN$
% of Market Cap 1.22 0.88 0.94 0.95 1.29 0.92 1.02 0.95 <-Median-> 6 % of Market C. CDN$
Market Cap US$ $781 $890 $1,014 $775 $1,033 $1,145 $799 $1,126 $1,215 $1,119 $1,119 $938 $854 $854 $854 5.46% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $907 $1,036 $1,002 $935 $1,073 $1,127 $816 $1,137 $1,291 $1,293 $1,013 $1,257 $1,070 $1,070 $1,070 21.31% <-Total Growth 10 Market Cap CDN$
Diluted 33.40 33.22 32.62 32.04 32.19 32.21 32.53 32.35 32.65 -3.14% <-Total Growth 7 Diluted
Change -0.55% -1.80% -1.78% 0.47% 0.07% 0.97% -0.54% 0.93% -0.01 <-Median-> 7 Change
Average # of Sh in M 32.84 32.86 33.29 33.40 33.23 32.86 32.46 31.69 31.83 32.21 32.32 32.35 32.40 -1.54% <-Total Growth 10 Average
Change 0.34% 0.06% 1.31% 0.33% -0.50% -1.14% -1.21% -2.36% 0.43% 1.21% 0.34% 0.09% 0.16% 0.00 <-Median-> 10 Change
Difference 0.0% 0.0% 0.3% 0.0% -0.8% -0.6% -1.5% -0.2% 0.3% 0.3% 0.0% 0.2% 0.0% 0.00 <-Median-> 10 Difference
$160.29 <-12 mths -6.74%
Class A Muliple Voting Class A Muliple Voting
Class B Sub Voting Class B Sub Voting
pre '98 split
Class A Multiple Voting 4.473 4.441 4.428 4.230 4.230 4.230 4.230 4.221 4.195 4.195 4.195 4.193 4.192 4.192 4.192 Class A, 10 votes
Class B Sub Voting 28.359 28.421 28.969 29.172 28.737 28.436 27.724 27.410 27.718 28.124 28.138 28.211 28.212 28.212 28.212 Class B, 1 vote
# of Share in Millions 32.832 32.861 33.397 33.402 32.966 32.665 31.954 31.631 31.913 32.319 32.333 32.404 32.404 32.404 32.404 -0.14% <-IRR #YR-> 10 Shares -1.39%
Increase 0.10% 0.09% 1.63% 0.01% -1.30% -0.91% -2.18% -1.01% 0.89% 1.27% 0.04% 0.22% 0.00% 0.00% 0.00% 0.28% <-IRR #YR-> 5 Shares 1.41%
CF fr Op $M US$ $98.87 $106.72 $167.34 $79.88 $204.52 $78.02 $162.48 $107.22 $144.28 $101.65 $78.72 $171.87 $144.85 $152.95 61.04% <-Total Growth 10 Cash Flow US$
Increase -14.43% 7.94% 56.80% -52.26% 156.02% -61.85% 108.26% -34.01% 34.57% -29.55% -22.56% 118.34% -15.72% 5.59% S.O., Buy Backs Conv A to B.
5 year Running Average $100 $112 $120 $114 $131 $127 $138 $126 $139 $119 $119 $121 $128 $130 8.09% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $3.01 $3.25 $5.01 $2.39 $6.20 $2.39 $5.08 $3.39 $4.52 $3.15 $2.43 $5.30 $4.47 $4.72 63.31% <-Total Growth 10 Cash Flow per Share US$
Increase -14.51% 7.85% 54.29% -52.27% 159.40% -61.50% 112.89% -33.34% 33.38% -30.43% -22.59% 117.86% -15.72% 5.59% 4.88% <-IRR #YR-> 10 Cash Flow 61.04% US$
5 year Running Average $3.13 $3.44 $3.64 $3.44 $3.97 $3.85 $4.22 $3.89 $4.32 $3.71 $3.71 $3.76 $3.97 $4.01 1.13% <-IRR #YR-> 5 Cash Flow 5.78% US$
P/CF on Med Price 9.99 7.62 6.95 9.55 3.57 13.74 5.43 9.29 8.44 10.69 11.53 4.67 5.67 0.00 5.03% <-IRR #YR-> 10 Cash Flow per Share 63.31% US$
P/CF on Closing Price 7.90 8.33 6.06 9.70 5.05 14.68 4.92 10.51 8.42 11.00 14.22 5.46 5.90 5.59 0.85% <-IRR #YR-> 5 Cash Flow per Share 4.31% US$
-33.44% Diff M/C 0.78% <-IRR #YR-> 10 CFPS 5 yr Running 9.13% US$
Excl.Working Capital CF $44.35 $29.40 -$24.48 $78.51 -$47.66 $102.31 $17.04 $94.88 $12.32 $76.66 $89.14 -$29.16 $0.00 $0.00 -2.70% <-IRR #YR-> 5 CFPS 5 yr Running -10.84% US$
CF fr Op $M WC US$ $143.2 $136.1 $142.9 $158.4 $156.9 $180.3 $179.5 $202.1 $156.6 $178.3 $167.9 $142.7 $144.8 $152.9 4.84% <-Total Growth 10 Cash Flow less WC US$
Increase 8.01% -4.95% 4.95% 10.87% -0.97% 14.96% -0.45% 12.58% -22.51% 13.86% -5.86% -14.98% 1.50% 5.59% 0.47% <-IRR #YR-> 10 Cash Flow less WC 4.84% US$
5 year Running Average $106 $121 $134 $143 $147 $155 $164 $175 $175 $179 $177 $170 $158 $157 -4.49% <-IRR #YR-> 5 Cash Flow less WC -20.50% US$
CFPS Excl. WC US$ $4.36 $4.14 $4.28 $4.74 $4.76 $5.52 $5.62 $6.39 $4.91 $5.52 $5.19 $4.40 $4.47 $4.72 3.42% <-IRR #YR-> 10 CF less WC 5 Yr Run 39.96% US$
Increase 7.90% -5.04% 3.26% 10.86% 0.34% 16.02% 1.77% 13.73% -23.20% 12.43% -5.90% -15.17% 1.50% 5.59% 0.71% <-IRR #YR-> 5 CF less WC 5 Yr Run 3.62% US$
5 year Running Average $3.32 $3.72 $4.06 $4.31 $4.46 $4.69 $4.98 $5.41 $5.44 $5.59 $5.52 $5.28 $4.90 $4.86 0.61% <-IRR #YR-> 10 CFPS - Less WC 6.32% US$
P/CF on Med Price 6.90 5.97 8.14 4.82 4.65 5.94 4.92 4.93 7.77 6.09 5.41 5.63 5.67 0.00 -4.75% <-IRR #YR-> 5 CFPS - Less WC -21.61% US$
P/CF on Closing Price 5.46 6.53 7.10 4.89 6.59 6.35 4.45 5.57 7.76 6.27 6.67 6.57 5.90 5.59 3.57% <-IRR #YR-> 10 CFPS 5 yr Running 42.08% US$
CF/-WC P/CF Med 10 yr 8.86 5 yr 9.29 P/CF Med 10 yr 5.52 5 yr 5.63 6.91% Diff M/C 1.17% <-IRR #YR-> 5 CFPS 5 yr Running 5.99% US$
$200.44 <-12 mths -13.14%
CF fr Op $M CDN$ $114.98 $124.35 $165.35 $97.82 $214.05 $77.60 $165.24 $106.67 $153.46 $117.92 $109.00 $230.76 $181.13 $191.26 85.57% <-Total Growth 10 Cash Flow CDN$
Increase -17.07% 8.15% 32.97% -40.84% 118.81% -63.75% 112.95% -35.44% 43.86% -23.16% -7.56% 111.71% -21.51% 5.59% S.O., Buy Backs
5 year Running Average $133 $143 $137 $128 $143 $136 $144 $132 $143 $124 $130 $144 $158 $166 0.38% <-Total Growth 10 Cash Flow CDN$
CFPS CDN$ $3.50 $3.78 $4.95 $2.93 $6.49 $2.38 $5.17 $3.37 $4.81 $3.65 $3.37 $7.12 $5.59 $5.90 88.19% <-Total Growth 10 Cash Flow CDN$
Increase -17.15% 8.05% 30.84% -40.85% 121.70% -63.41% 117.69% -34.79% 42.59% -24.12% -7.60% 111.24% -21.51% 5.59% 6.38% <-IRR #YR-> 10 Cash Flow 85.57% CDN$
5 year Running Average $4.20 $4.42 $4.18 $3.88 $4.33 $4.11 $4.38 $4.07 $4.44 $3.88 $4.07 $4.46 $4.91 $5.13 6.91% <-IRR #YR-> 5 Cash Flow 39.65% CDN$
P/CF on Med Price 10.42 7.62 6.95 9.55 3.82 14.35 5.45 9.36 8.05 10.10 10.47 4.67 5.96 0.00 6.53% <-IRR #YR-> 10 Cash Flow per Share 88.19% CDN$
P/CF on Closing Price 7.89 8.33 6.06 9.56 5.01 14.52 4.94 10.66 8.41 10.97 9.29 5.45 5.91 5.59 6.61% <-IRR #YR-> 5 Cash Flow per Share 37.71% CDN$
-32.19% Diff M/C 0.04% <-IRR #YR-> 10 CFPS 5 yr Running 1.02% CDN$
Excl.Working Capital CF $51.57 $34.26 -$24.19 $96.14 -$49.88 $101.76 $17.33 $94.40 $13.11 $88.93 $123.43 -$39.15 $0.00 $0.00 -0.06% <-IRR #YR-> 5 CFPS 5 yr Running 1.84% CDN$
CF fr Op $M WC CDN$ $166.6 $158.6 $141.2 $194.0 $164.2 $179.4 $182.6 $201.1 $166.6 $206.9 $232.4 $191.6 $181.1 $191.3 20.81% <-Total Growth 10 Cash Flow less WC CDN$
Increase 4.68% -4.77% -11.00% 37.41% -15.36% 9.25% 1.79% 10.13% -17.16% 24.19% 12.37% -17.56% -5.47% 5.59% 1.91% <-IRR #YR-> 10 Cash Flow less WC 20.81% CDN$
5 year Running Average $139 $151 $155 $164 $165 $167 $172 $184 $179 $187 $198 $200 $196 $201 0.97% <-IRR #YR-> 5 Cash Flow less WC 4.95% CDN$
CFPS Excl. WC CDN$ $5.07 $4.83 $4.23 $5.81 $4.98 $5.49 $5.71 $6.36 $5.22 $6.40 $7.19 $5.91 $5.59 $5.90 2.85% <-IRR #YR-> 10 CF less WC 5 Yr Run 32.38% CDN$
Increase 4.6% -4.9% -12.4% 37.4% -14.2% 10.3% 4.1% 11.3% -17.9% 22.6% 12.3% -17.7% -5.5% 5.6% 3.00% <-IRR #YR-> 5 CF less WC 5 Yr Run 15.95% CDN$
5 year Running Average $4.37 $4.64 $4.70 $4.96 $4.98 $5.07 $5.24 $5.67 $5.55 $5.84 $6.18 $6.22 $6.06 $6.20 2.05% <-IRR #YR-> 10 CFPS - Less WC 22.51% CDN$
P/CF on Med Price 7.19 5.97 8.14 4.82 4.98 6.21 4.93 4.97 7.42 5.76 4.91 5.63 5.96 0.00 0.69% <-IRR #YR-> 5 CFPS - Less WC 3.50% CDN$
P/CF on Closing Price 5.45 6.53 7.10 4.82 6.53 6.28 4.47 5.66 7.75 6.25 4.36 6.56 5.91 5.59 2.97% <-IRR #YR-> 10 CFPS 5 yr Running 34.04% CDN$
*Operational Cash Flow per share (Classes A & B) CF/-WC P/CF Med 10 yr 8.71 5 yr 9.36 P/CF Med 10 yr 5.30 5 yr 5.63 11.33% Diff M/C 3.46% <-IRR #YR-> 1 CFPS 5 yr Running 18.54% CDN$
-32.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 32.4 Shares
-32.0 0.0 0.0 0.0 0.0 32.4 Shares
-$107 $0 $0 $0 $0 $0 $0 $0 $0 $0 $172 Cash Flow US$
-$162 $0 $0 $0 $0 $172 Cash Flow US$
-$3.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.30 Cash Flow per Share US$
-$5.08 $0.00 $0.00 $0.00 $0.00 $5.30 Cash Flow per Share US$
-$111.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $120.75 CFPS 5 yr Running US$
-$138.45 $0.00 $0.00 $0.00 $0.00 $120.75 CFPS 5 yr Running US$
-$136 $0 $0 $0 $0 $0 $0 $0 $0 $0 $143 Cash Flow less WC US$
-$180 $0 $0 $0 $0 $143 Cash Flow less WC US$
-$121 $0 $0 $0 $0 $0 $0 $0 $0 $0 $170 CF less WC 5 Yr Run US$
-$164 $0 $0 $0 $0 $170 CF less WC 5 Yr Run US$
-$4.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.40 CFPS - Less WC US$
-$5.62 $0.00 $0.00 $0.00 $0.00 $4.40 CFPS - Less WC US$
-$3.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.28 CFPS 5 yr Running US$
-$4.98 $0.00 $0.00 $0.00 $0.00 $5.28 CFPS 5 yr Running US$
-$124 $0 $0 $0 $0 $0 $0 $0 $0 $0 $231 Cash Flow CDN$
-$165 $0 $0 $0 $0 $231 Cash Flow CDN$
-$3.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.12 Cash Flow per Share CDN$
-$5.17 $0.00 $0.00 $0.00 $0.00 $7.12 Cash Flow per Share CDN$
-$143.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $143.56 CFPS 5 yr Running CDN$
-$144.01 $0.00 $0.00 $0.00 $0.00 $143.56 CFPS 5 yr Running CDN$
-$159 $0 $0 $0 $0 $0 $0 $0 $0 $0 $192 Cash Flow less WC CDN$
-$183 $0 $0 $0 $0 $192 Cash Flow less WC CDN$
-$151 $0 $0 $0 $0 $0 $0 $0 $0 $0 $200 CF less WC 5 Yr Run CDN$
-$172 $0 $0 $0 $0 $200 CF less WC 5 Yr Run CDN$
-$4.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.91 CFPS - Less WC CDN$
-$5.71 $0.00 $0.00 $0.00 $0.00 $5.91 CFPS - Less WC CDN$
-$4.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.22 CFPS 5 yr Running CDN$
-$5.24 $0.00 $0.00 $0.00 $0.00 $6.22 CFPS 5 yr Running CDN$
Trade and other receivables $7.35
Inventories $31.82
Other financial assets $0.69
Prepaid expenses -$1.06
Other assets -$0.16
Trade and other payables $3.24
Net pension and post-retirement defined benefit liabilities -$3.90
Provisions, other financial liabilities, deferred revenue and $37.27
Net changes in balances related to operations $22.54 -$76.72 $10.52 -$33.16 -$46.33
Income taxes paid -$28.18 -$19.27 -$17.17 -$25.06 -$15.68 -$20.26
Income taxes received $7.14 $16.54 $12.79 $7.01 $7.20 $9.91
Interest paid -$18.54 -$16.66 -$18.94 -$26.15 -$34.68 -$36.20
Interest received   $1.23 $0.47 $0.69 $0.35 $0.45
-$17.04 -$94.88 -$12.32 -$76.66 -$89.14 $29.16
Google -$94.88 -$12.32 -$76.66 -$89.14 $29.16
Difference $0.00 $0.00 $0.00 $0.00 $0.00
OPM 5.6% 6.1% 9.2% 3.7% 9.6% 3.4% 6.9% 4.3% 5.9% 3.8% 2.9% 6.6% 8.14% <-Total Growth 10 OPM CDN$
Increase -18.12% 8.74% 51.13% -60.32% 161.01% -64.70% 103.74% -37.36% 37.62% -35.92% -22.73% 125.06% Should increase or be stable. CDN$
Diff from Ave 9.8% 19.4% 80.4% -28.4% 86.9% -34.0% 34.4% -15.8% 15.8% -25.8% -42.6% 29.1% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 5.11% 5 Yrs 4.30% should be zero, it is a check on calculations CDN$
Current Assets US$ $633.65 $694.16 $684.05 $916.08 $841.37 $959.24 $925.37 $1,020.4 $1,090.2 $1,201.5 $1,114.5 $1,072.5 $1,116.1 Liq ratio of 1.5 and up, best US$
Current Liabilities $342.20 $349.83 $420.35 $427.07 $490.84 $425.41 $413.44 $403.3 $851.1 $638.6 $576.4 $630.5 $589.4 1.91 <-Median-> 10 Ratio US$
Liquidity Ratios 1.85 1.98 1.63 2.15 1.71 2.25 2.24 2.53 1.28 1.88 1.93 1.70 1.89 1.88 <-Median-> 5 Ratio US$
Assets US$ $1,542.7 $1,627.4 $1,657.4 $2,030.5 $2,002.2 $2,096.0 $2,096.6 $2,204.1 $2,440.0 $2,530.0 $2,304.9 $2,172.6 $2,220.0 Debt Ratio of 1.5 and up, best US$
Liabilities $760.6 $827.9 $719.7 $1,015.7 $893.0 $915.5 $866.9 $896.4 $1,093.2 $1,323.0 $1,202.5 $1,116.5 $1,156.3 2.24 <-Median-> 10 Ratio US$
Debt Ratio 2.03 1.97 2.30 2.00 2.24 2.29 2.42 2.46 2.23 1.91 1.92 1.95 1.92 1.95 <-Median-> 5 Ratio US$
Book Value US $ $672.4 $799.5 $937.7 $1,014.7 $1,109.2 $1,180.5 $1,229.7 $1,307.7 $1,346.8 $1,207.0 $1,102.4 $1,056.1 $1,063.7 $1,063.7 $1,063.7 32.09% <-Total Growth 10 Book Value US$
Book Value per Share $20.48 $24.33 $28.08 $30.38 $33.65 $36.14 $38.48 $41.34 $42.20 $37.35 $34.09 $32.59 $32.83 $32.83 $32.83 33.96% <-Total Growth 10 Book Value per Share
Change -0.10% 18.79% 15.41% 8.19% 10.75% 7.41% 6.48% 7.43% 2.08% -11.51% -8.70% -4.41% 0.72% 0.00% 0.00% 1.36% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.47 1.02 1.24 0.75 0.66 0.91 0.72 0.76 0.90 0.90 0.82 0.76 0.77 1.13 P/B Ratio Historical Median
P/B Ratio (Close) 1.16 1.11 1.08 0.76 0.93 0.97 0.65 0.86 0.90 0.93 1.02 0.89 0.80 2.97% <-IRR #YR-> 10 Book Value per Share
Change -30.93% -4.26% -2.84% -29.35% 21.97% 4.15% -33.04% 32.59% 4.76% 2.70% 9.53% -12.50% -9.56% -3.27% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 2.29 2.04 1.77 2.00 1.81 1.78 1.71 1.69 1.81 2.10 2.09 2.06 2.09 1.81 <-Median-> 10 A/BV
Debt/Equity Ratio 1.13 1.04 0.77 1.00 0.81 0.78 0.71 0.69 0.81 1.10 1.09 1.06 1.09 0.81 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 0.79 5 yr Med 0.82 1.36% Diff M/C 2.04 Historical 17 A/BV
Current Assets CDN$ $736.93 $808.83 $675.9 $1,121.8 $880.6 $954.1 $941.1 $1,015.2 $1,159.5 $1,393.9 $1,543.2 $1,440.0 $1,395.7 Liquidity ratio of 1.5 and up, best
Current Liabilities $397.98 $407.62 $415.3 $523.0 $513.7 $423.1 $420.5 $401.3 $905.2 $740.8 $798.1 $846.6 $737.0 1.91 <-Median-> 10 Ratio CDN$
Liquidity Ratio 1.85 1.98 1.63 2.15 1.71 2.25 2.24 2.53 1.28 1.88 1.93 1.70 1.89 1.88 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.14 2.29 1.99 2.29 2.10 2.39 2.58 2.73 1.41 1.98 2.00 1.91 2.07 1.98 <-Median-> 5 Ratio CDN$
Liq. CF re Inv+Div 1.95 2.12 1.81 1.40 1.86 2.12 2.15 2.37 1.21 1.46 1.83 1.84 2.07 1.83 <-Median-> 5 Ratio CDN$
Assets CDN$ $1,794.1 $1,896.3 $1,637.7 $2,486.5 $2,095.5 $2,084.6 $2,132.2 $2,192.8 $2,595.1 $2,935.0 $3,191.8 $2,917.2 $2,776.1 Debt Ratio of 1.5 and up, best
Liabilities $884.6 $964.7 $711.1 $1,243.9 $934.6 $910.5 $881.7 $891.8 $1,162.7 $1,534.8 $1,665.2 $1,499.2 $1,445.9 2.24 <-Median-> 10 Ratio CDN$
Debt Ratio 2.03 1.97 2.30 2.00 2.24 2.29 2.42 2.46 2.23 1.91 1.92 1.95 1.92 1.95 <-Median-> 5 Ratio CDN$
Book Value CDN $ $782.1 $931.6 $926.6 $1,242.7 $1,160.9 $1,174.1 $1,250.6 $1,301.0 $1,432.4 $1,400.2 $1,526.5 $1,418.0 $1,330.1 $1,330.1 $1,330.1 52.21% <-Total Growth 10 Book Value CDN$
Book Value per Share $23.82 $28.35 $27.74 $37.20 $35.21 $35.94 $39.14 $41.13 $44.88 $43.32 $47.21 $43.76 $41.05 $41.05 $41.05 54.36% <-Total Growth 10 Book Value per Share CDN$
Change -3.18% 19.02% -2.13% 34.09% -5.34% 2.07% 8.88% 5.10% 9.13% -3.48% 8.97% -7.31% -6.20% 0.00% 0.00% 5.23% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 1.53 1.02 1.24 0.75 0.70 0.95 0.72 0.77 0.86 0.85 0.75 0.76 0.81 1.13 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 1.16 1.11 1.08 0.75 0.92 0.96 0.65 0.87 0.90 0.92 0.66 0.89 0.80 4.44% <-IRR #YR-> 10 Book Value per Share 54.36% CDN$
Change -30.95% -4.09% -2.84% -30.37% 22.78% 3.87% -31.98% 33.88% 3.13% 2.47% -28.16% 33.61% -9.30% 2.26% <-IRR #YR-> 5 Book Value per Share 11.82% CDN$
Leverage (A/BK) 2.29 2.04 1.77 2.00 1.81 1.78 1.71 1.69 1.81 2.10 2.09 2.06 2.09 1.81 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.13 1.04 0.77 1.00 0.81 0.78 0.71 0.69 0.81 1.10 1.09 1.06 1.09 0.81 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 0.76 5 yr Med 0.77 5.23% Diff M/C 2.02 Historical 20 A/BV CDN$
-$36.49 <-12 mths -217.42%
Comprehensive Income US$ $124.61 $130.48 $89.12 $119.46 $96.89 $91.57 $113.39 $68.87 -$109.67 -$67.67 -$11.50 -109.23% <-Total Growth 10 Comprehensive Income US$
Increase 4.71% -31.69% 34.04% -18.90% -5.49% 23.83% -39.26% -259.24% 38.30% 83.01% 23.83% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $112.11 $105.50 $102.09 $98.04 $52.21 $19.30 -$1.32 #NUM! <-IRR #YR-> 10 Comprehensive Income -109.23% US$
ROE US$ 15.6% 13.9% 8.8% 10.8% 8.2% 7.4% 8.7% 5.1% -9.1% -6.1% -1.1% #NUM! <-IRR #YR-> 5 Comprehensive Income -112.55% US$
5Yr Median 10.8% 8.8% 8.7% 8.2% 7.4% 5.1% -1.1% #NUM! <-IRR #YR-> 6 5 Yr Running Average #DIV/0! US$
% Difference from NI 40.22% 49.13% -21.03% 11.40% -24.22% -12.45% 4.40% 19.43% -415.64% -363.28% 1.00% #NUM! <-IRR #YR-> 5 5 Yr Running Average -101.25% US$
Median Values Diff 5, 10 yr -5.7% 1.0% -1.1% <-Median-> 5 Return on Equity
Current Liability Coverage Ratio 0.29 0.31 0.40 0.19 0.42 0.18 0.39 0.27 0.17 0.16 0.14 0.27 CFO / Current Liabilities US$
5 year Median 0.41 0.31 0.31 0.30 0.31 0.31 0.39 0.27 0.27 0.18 0.17 0.17 0.17 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio 6.41% 6.56% 10.10% 3.93% 10.21% 3.72% 7.75% 4.86% 5.91% 4.02% 3.42% 7.91% CFO / Total Assets US$
5 year Median 8.29% 7.15% 7.15% 6.56% 6.56% 6.56% 7.75% 4.86% 5.91% 4.86% 4.86% 4.86% 4.9% <-Median-> 5 Return on Assets US$
Return on Assets ROA 5.9% 5.5% 5.3% 5.6% 5.4% 6.1% 5.0% 4.9% 2.4% -0.8% 1.1% -0.5% Net Income/Assets Return on Assets US$
5Yr Median 6.2% 6.2% 5.9% 5.6% 5.5% 5.5% 5.4% 5.4% 5.0% 4.9% 2.4% 1.1% 1.1% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE 13.6% 11.1% 9.3% 11.1% 9.7% 10.8% 8.5% 8.3% 4.3% -1.8% 2.3% -1.1% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 14.9% 14.9% 13.6% 11.1% 11.1% 10.8% 9.7% 9.7% 8.5% 8.3% 4.3% 2.3% 2.3% <-Median-> 5 Return on Equity US$
-$19.50 <-12 mths -67.98%
Net Income US$ $91.32 $88.87 $87.49 $112.86 $107.23 $127.85 $104.59 $108.61 $57.67 -$21.27 $25.70 -$11.61 $70.80 $94.20 -113.07% <-Total Growth 10 Net Income US$
Increase -8.75% -2.69% -1.55% 28.99% -4.98% 19.23% -18.19% 3.84% -46.90% -136.88% -220.85% -145.17% -709.77% 33.05% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $70.7 $83.4 $88.6 $96.1 $97.6 $104.9 $108.0 $112.2 $101.2 $75.5 $55.1 $31.8 $24.3 $31.6 #NUM! <-IRR #YR-> 10 Net Income -113.07% US$
Operating Cash Flow $98.87 $106.72 $167.34 $79.88 $204.52 $78.02 $162.48 $107.22 $144.28 $101.65 $78.72 $171.87 #NUM! <-IRR #YR-> 5 Net Income -111.10% US$
Investment Cash Flow -$34.18 -$28.30 -$41.40 -$273.37 -$62.31 -$55.20 -$84.48 -$61.16 -$133.80 -$227.50 -$53.41 -$23.26 -9.18% <-IRR #YR-> 10 5 Yr Running Ave. -61.83% US$
Total Accrual $26.64 $10.44 -$38.45 $306.34 -$34.98 $105.03 $26.59 $62.56 $47.19 $104.59 $0.39 -$160.22 -21.68% <-IRR #YR-> 5 5 Yr Running Ave. -70.54% US$
Total Assets $1,542.7 $1,627.4 $1,657.4 $2,030.5 $2,002.2 $2,096.0 $2,096.6 $2,204.1 $2,440.0 $2,530.0 $2,304.9 $2,172.6 Balance Sheet Assets US$
Accruals Ratio 1.73% 0.64% -2.32% 15.09% -1.75% 5.01% 1.27% 2.84% 1.93% 4.13% 0.02% -7.37% 1.93% <-Median-> 5 Ratio US$
EPS/CF Ratio 0.64 0.65 0.61 0.71 0.67 0.70 0.57 0.53 0.36 -0.12 0.15 -0.08 0.55 <-Median-> 10 EPS/CF Ratio US$
Financial Cash Flow -$61.24 -$65.22 -$132.29 $186.29 -$141.03 -$22.44 -$63.54 -$38.07 -$9.93 $140.87 -$31.95 -$31.95 C F Statement Financial CF US$
Total Accruals $87.87 $75.66 $93.83 $120.05 $106.06 $127.47 $90.13 $100.63 $57.12 -$36.29 $32.34 -$128.27 Accruals US$
Accruals Ratio 5.70% 4.65% 5.66% 5.91% 5.30% 6.08% 4.30% 4.57% 2.34% -1.43% 1.40% -5.90% 1.40% <-Median-> 5 Ratio US$
-$45.63 <-12 mths -195.63%
Comprehensive Income CDN$ $145.19 $128.92 $109.14 $125.03 $96.36 $93.13 $112.81 $73.25 -$127.23 -$93.71 -$15.43 -112.34% <-Total Growth 10 Comprehensive Income CDN$
Increase -11.20% -15.35% 14.56% -22.92% -3.36% 21.13% -35.07% -273.68% 26.35% 83.53% 21.13% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $120.93 $110.52 $107.29 $100.12 $49.67 $11.65 -$10.06 #NUM! <-IRR #YR-> 9 Comprehensive Income -112.34%
ROE CDN$ 15.6% 13.9% 8.8% 10.8% 8.2% 7.4% 8.7% 5.1% -9.1% -6.1% -1.1% #DIV/0! <-IRR #YR-> 5 Comprehensive Income -116.57% CDN$
5Yr Median 10.8% 8.8% 8.7% 8.2% 7.4% 5.1% -1.1% #NUM! <-IRR #YR-> 6 5 Yr Running Average #DIV/0! CDN$
% Difference from NI 40.22% 49.13% -21.03% 11.40% -24.22% -12.45% 4.40% 19.43% -415.64% -363.28% 1.00% #NUM! <-IRR #YR-> 5 5 Yr Running Average -109.10% CDN$
Median Values Diff 5, 10 yr -5.7% 1.0% -1.1% <-Median-> 5 Return on Equity
Current Liability Coverage Ratio 0.29 0.31 0.40 0.19 0.42 0.18 0.39 0.27 0.17 0.16 0.14 0.27 CFO / Current Liabilities CDN$
5 year Median 0.41 0.31 0.31 0.30 0.31 0.31 0.39 0.27 0.27 0.18 0.17 0.17 0.17 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio 6.41% 6.56% 10.10% 3.93% 10.21% 3.72% 7.75% 4.86% 5.91% 4.02% 3.42% 7.91% CFO / Total Assets CDN$
5 year Median 8.29% 7.15% 7.15% 6.56% 6.56% 6.56% 7.75% 4.86% 5.91% 4.86% 4.86% 4.86% 4.9% <-Median-> 5 Return on Assets CDN$
Return on Assets ROA 5.9% 5.5% 5.3% 5.6% 5.4% 6.1% 5.0% 4.9% 2.4% -0.8% 1.1% -0.5% Net Income/Assets Return on Assets CDN$
5Yr Median 6.2% 6.2% 5.9% 5.6% 5.5% 5.5% 5.4% 5.4% 5.0% 4.9% 2.4% 1.1% 5.0% <-Median-> 10 Asset Efficiency Ratio CDN$
Return on Equity ROE 13.6% 11.1% 9.3% 11.1% 9.7% 10.8% 8.5% 8.3% 4.3% -1.8% 2.3% -1.1% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 14.9% 14.9% 13.6% 11.1% 11.1% 10.8% 9.7% 9.7% 8.5% 8.3% 4.3% 2.3% 8.4% <-Median-> 10 Return on Equity CDN$
-$24.39 <-12 mths -56.44%
Net Income CDN$ $106.21 $103.55 $86.45 $138.20 $112.23 $127.16 $106.37 $108.06 $61.34 -$24.67 $35.59 -$15.59 $88.54 $117.80 -115.06% <-Total Growth 10 Net Income CDN$
Increase -11.56% -2.51% -16.51% 59.86% -18.79% 13.30% -16.35% 1.59% -43.24% -140.23% -244.25% -143.80% -667.90% 33.05% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $91.7 $104.3 $102.8 $110.9 $109.3 $113.5 $114.1 $118.4 $103.0 $75.7 $57.3 $32.9 $29.0 $40.3 #NUM! <-IRR #YR-> 10 Net Income -115.06% CDN$
Operating Cash Flow $114.98 $124.35 $165.35 $97.82 $214.05 $77.60 $165.24 $106.67 $153.46 $117.92 $109.00 $230.76 #NUM! <-IRR #YR-> 5 Net Income -114.66% CDN$
Investment Cash Flow -$39.76 -$32.97 -$40.90 -$334.77 -$65.21 -$54.90 -$85.91 -$60.85 -$142.31 -$263.93 -$73.95 -$31.23 -10.88% <-IRR #YR-> 10 5 Yr Running Ave. -68.40% CDN$
Total Accrual $30.98 $12.16 -$37.99 $375.14 -$36.60 $104.46 $27.04 $62.24 $50.19 $121.33 $0.54 -$215.13 -22.00% <-IRR #YR-> 5 5 Yr Running Ave. -71.12% CDN$
Total Assets $1,794.1 $1,896.3 $1,637.7 $2,486.5 $2,095.5 $2,084.6 $2,132.2 $2,192.8 $2,595.1 $2,935.0 $3,191.8 $2,917.2 Balance Sheet Assets CDN$
Accruals Ratio 1.73% 0.64% -2.32% 15.09% -1.75% 5.01% 1.27% 2.84% 1.93% 4.13% 0.02% -7.37% 1.93% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.64 0.65 0.61 0.71 0.67 0.70 0.57 0.53 0.36 -0.12 0.15 -0.08 0.55 <-Median-> 10 EPS/CF Ratio CDN$
Change in Close -33.15% 14.15% -4.91% -6.64% 16.21% 6.02% -25.94% 40.70% 12.55% -1.09% -21.71% 23.84% -14.92% 0.00% 0.00% Count 25 Years of data
up/down down down down up Count 9 36.00%
Meet Prediction? yes yes % right Count 4 44.44%
Financial Cash Flow -$71.22 -$76.00 -$130.71 $228.13 -$147.60 -$22.31 -$64.62 -$37.87 -$10.56 $163.43 -$44.24 -$42.90 C F Statement Financial Cash Flow CDN$
Total Accruals $102.20 $88.16 $92.72 $147.01 $111.00 $126.78 $91.66 $100.11 $60.75 -$42.10 $44.78 -$172.23 Accruals CDN$
Accruals Ratio 5.70% 4.65% 5.66% 5.91% 5.30% 6.08% 4.30% 4.57% 2.34% -1.43% 1.40% -5.90% 1.40% <-Median-> 5 Ratio CDN$
Cash US$ $29.76 $38.31 $40.07 $47.10 $33.18 $31.88 $35.14 Cash US$
Cash per Share US$ $0.93 $1.21 $1.26 $1.46 $1.03 $0.98 $1.08
Percentage of Stock Price 3.73% 3.40% 3.30% 4.21% 2.97% 3.40% 4.11%
Cash CDN$ $30.27 $38.12 $42.62 $54.64 $45.95 $42.81 $43.94 Cash CDN$
Cash per Share CDN$ $0.95 $1.20 $1.34 $1.69 $1.42 $1.32 $1.36 $1.34 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 3.71% 3.35% 3.30% 4.22% 4.54% 3.40% 4.11% 3.40% <-Median-> 5 % of Stock Price CDN$
Notes:
July 26, 2017. Last estimates were for 206, 2017 and 2018 of $2715M, $2819M and $2863M US$ for Revenue, $2.23, $2.76 and $3.57 US$ for EPS,
$3.92 and $4.79 for CFPS for 2016 and 2017 US$, $71.7M and $83.8M for 2016 and 2017 for Net Income.
July 24, 2016. Last estimates were for 2015, 2016 and 2017 of $2777M, $2891M and $3.135M US$ for Revenue, $1.94, $2.57 and $4.08 US$ for EPS,
$4.28 and $4.45 US$ for CFPS for 2015 and 2016, $62.40M and $78.40M US$ for Net Income.
August 2, 2015. Last estimates were for 2014 and 2015 of $2641M and $2798M US$ for Sales, $3.17 and $3.65 US$ for EPS,
$5.08 and $5.53 US$ for CFPS and $111.27M and $127.64M US$ for Net Income.
July 30, 2014. Last estimates were for 2013 and 2014 of $2513M and $2463M US$ for Revenue, $3.46, $4.14 and $5.42 (2015) US$ for EPS, $5.42 and $6.03 US$ for CFPS.
July 7, 2013. Last Estimates I got were for 2011 and 2012 of $2515.4M and $2496.5M US$ for Revenue, $2.97 and $3.48 US$ for EPS and $4.53 and $5.09 US$ for CF.
Jan 14, 2012. Last Estimates I got for 2010 and 2011 were $3.75 US and $4.00 US for EPS and $4.60 US and $4.90 US for CF.
Sep 26, 2010. When I last looked, this company had estimates for 2009 and 2010 of $3.00 and $3.50 for earnings and $4.40 and $4.90 for cash flow.
Nov 25, 2009. In August 2009, I picked up earnings of $2.87 and $3.28 US for 2009 and 2010. I also got cash flow of $4.15 and $4.55 US
Aug 23, 2009. I picked up new estimates when I updated spreadsheet for 2008 annual report. I would not be interested in this stock again until dividedends are increasing.
In Feb 2009, I picked up 2008 and 2009 earnings of 3.57 and $3.35 and cash flow of $5.04 and $4.63/ Earnings came in 2008 at 3.38 and CF at $2.39, a lot lower.
2006. Sold. Stock price is not going anywhere and they pay no dividend.
2005. Stock is not performing badly. I think it is a keeper. They do know how to make a profit.
2003. I still think that this stock is a keeper. It is a solid performer and this is why I brought it in the first place.
2004. Does not have a dividend, but so far it is a solid producing stock.
Since 1999 I have had 7.25 IRR. Not great. Keep eye on. TD has a BUY rating on this stock from Nov 2004. AR 2004
US -old 'DIIB.PK OTC
Results seem to be released in March of each year.
Sector:
Consumer Discretionary
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock.
I am following this stock because I used to own it. I am always curious about what happens to stocks after I no longer hold them.
Dividends
Dividends are paid quarterly in cycle 3, that is March, June, September and December. Generally dividends are declare for shareholders of record of one month for payment in the next month.
For example, the dividend paid on December 6, 2012 was for shareholders of record for November 22, 2012. However, Dorel has paid dividends in other months, like April and has declared in one month for payment in that month.
Why I bought this stock.
This was a stock recommended by Investment Reporter as a conservative investment.
I sold the stock in 2006 because I had it for 7 years from 1999 and it was going nowhere. I bought this stock before I stopped working and at that time I did not mind buying stocks with no dividends.
How they make their money.
Dorel Industries Inc. is a world class juvenile products and bicycle company.
Dorel's Home Furnishings segment markets a wide assortment of both domestically produced and imported furniture products, principally within North America.
Dorel has facilities in seventeen countries, and sales worldwide.
There concentrated ownership of this company by the Schwartz family (66%) and Segel family (17%). There are two classes of shares, Class A with multiple voting (10) and Class B, with subordinate voting rates (1).
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 Jul 7 2013 Aug 03 2014 Aug 02 2015 Jul 23 2016 Jul 26 2017
Schwartz, Martin 0.766 18.25% 0.766 18.25% 0.766 18.25% 0.766 18.26% 0.000 0.00% A
CEO Class A $30.976 $30.639 $23.986 $29.705 $0.000 A
Class B - percentage 0.435 1.57% 0.520 1.85% 0.520 1.85% 0.520 1.84% 0.527 1.87% B
Class B - amount $17.607 $20.817 $16.297 $20.183 $17.391 B
Options - percentage 0.085 0.27% 0.049 0.15% 0.108 0.33% 0.109 0.34% 0.168 0.52%
Options - amount $3.439 $1.967 $3.387 $4.222 $5.550
Schwartz, Jeffrey 0.766 18.25% 0.766 18.25% 0.766 18.25% 0.766 18.26% 0.762 18.17% A
CFO $30.976 $30.639 $23.986 $29.705 $25.140 A
Class B - percentage 0.435 1.57% 0.520 1.85% 0.520 1.85% 0.520 1.84% 0.527 1.87% B
Class B - amount $17.607 $20.815 $16.296 $20.181 $17.389 B
Options - percentage 0.091 0.28% 0.055 0.17% 0.170 0.53% 0.122 0.38% 0.186 0.57%
Options - amount $3.672 $2.206 $5.332 $4.749 $6.125
Schwartz, Alan 0.766 18.25% 0.772 18.39% 0.772 18.39% 0.772 18.40% 0.772 18.41% A
Officer $30.976 $30.879 $24.174 $29.938 $25.471 A
Class B - percentage 0.336 1.21% 0.421 1.50% 0.421 1.50% 0.421 1.49% 0.428 1.52% B
Class B - amount $13.591 $16.845 $13.188 $16.332 $14.115
Options - percentage 0.085 0.31% 0.049 0.15% 0.108 0.33% 0.109 0.34% 0.171 0.53%
Options - amount $3.439 $1.967 $3.387 $4.222 $5.656
Segel, Jeffrey 0.766 18.25% 0.766 18.25% 0.766 18.26% 0.766 18.27% 0.766 18.27% A
Officer $30.976 $30.639 $23.999 $29.721 $25.286 A
Class B - percentage 0.421 1.52% 0.506 1.80% 0.508 1.81% 0.527 1.87% 0.527 1.87% B
Class B - amount $17.028 $20.244 $15.923 $20.453 $17.401 B
Options - percentage 0.091 0.33% 0.055 0.17% 0.114 0.35% 0.119 0.37% 0.182 0.56%
Options - amount $3.672 $2.206 $3.582 $4.612 $6.003
Benedetti, Alain 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% B
Director - Shares - Amount $0.000 $0.000 $0.000 $0.000 $0.000 B
Options - percentage 0.022 0.08% -0.026 -0.09% 0.029 0.09% 0.030 0.09% 0.038 0.12%
Options - amount $0.906 -$1.050 $0.904 $1.176 $1.245
Tousson, Maurice 0.001 0.03% 0.001 0.03% 0.001 0.03% 0.001 0.03% A
Lead Independent Director $0.052 $0.041 $0.050 $0.043 A
Class B - percentage 0.000 0.00% 0.000 0.00% 0.038 0.14% 0.000 0.00% B yes 0 B
Class B - amount $0.000 $0.000 $1.483 $0.000 B
Options - percentage 0.034 0.11% 0.036 0.11% 0.000 0.00% 0.078 0.24%
Options - amount $1.361 $1.140 $0.000 $2.575
Schwartz, Laura 0.669 15.95% 0.669 15.95% 0.669 15.96% 0.669 15.97% A
10% owner $26.783 $20.967 $25.967 $22.092 A
Class B - percentage 0.269 0.96% 0.269 0.96% 0.269 0.95% 0.289 1.03% B
Class B - amount $10.775 $8.435 $10.447 $9.548 B
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000
Class A total 89.13% 89.14% 89.17% 70.85% A
Increase in O/S Shares 0.354 1.13% 0.292 0.92% 0.406 1.27% 0.014 0.33% 0.000 0.00%
due to SO 2013 $14.313 $11.806 $16.259 $0.434 $0.000
Book Value $8.524 $7.832 $7.545 $0.280 $0.000
Insider Buying $0.000 -$0.659 $0.000 Yes 0 in 2017
Insider Selling $0.000 $0.656 $0.000
Net Insider Selling $0.626 $0.000 -$0.004 $0.000
% of Market Cap 0.06% 0.00% 0.00% 0.00%
Directors 8 9 9 9
Women 0 0% 1 11% 2 22% 2 22%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 6 9.49% 52 54.25% 86 $513.88
Value $582.00
Total Shares Held 10.555 33.07% 0.398 1.42% 15.260 54.23% 15.000 53.17% B
Increase/Decrease 0.166 1.55% 0.000 0.00% 1.523 11.09% -0.386 -2.51%
Starting No. of Shares 10.721 0.398 13.737 15.386 Morningstar
Copyright 2008 Website of SPBrunner. All rights reserved.
My stock