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/ 9/30/17
Methanex Corp TSX: MX NASDAQ: MEOH www.methanex.com Fiscal Yr: Dec 31 Q3 2017
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Split
USD - CDN$ 1.1659 1.1653 0.9881 1.2246 1.0466 0.9946 1.0170 0.9949 1.0636 1.1601 1.3847 1.3427 1.2759 1.2759 1.2759 1.43% <-IRR #YR-> 10 USD - CDN$
-3.13% -0.05% -15.21% 23.93% -14.54% -4.97% 2.25% -2.17% 6.91% 9.07% 19.36% -3.04% -4.98% 0.00% 0.00% 5.71% <-IRR #YR-> 5 USD - CDN$
$2,785 <-12 mths 39.35%
Revenue* US$ $1,658.1 $2,108.3 $2,266.5 $2,314.0 $1,198.0 $1,966.6 $2,608.0 $2,673.0 $3,024.0 $3,223.4 $2,225.6 $1,998.4 $3,061 $2,807 $2,913 -5.21% <-Total Growth 10 Revenue US$
Increase -3.57% 27.15% 7.51% 2.09% -48.23% 64.16% 32.62% 2.49% 13.14% 6.59% -30.95% -10.21% 53.17% -8.30% 3.78% -0.53% <-IRR #YR-> 10 Revenue -5.21% US$
5 year Running Average $1,391.0 $1,582.8 $1,834.4 $2,013.3 $1,909.0 $1,970.7 $2,070.6 $2,151.9 $2,293.9 $2,699.0 $2,750.8 $2,628.9 $2,706 $2,663 $2,601 -5.19% <-IRR #YR-> 5 Revenue -23.37% US$
Revenue per Share $14.59 $19.93 $23.05 $25.14 $13.01 $21.23 $27.97 $28.34 $31.47 $34.91 $24.82 $22.25 $34.08 $31.25 $32.43 5.20% <-IRR #YR-> 10 5 yr Running Average 66.09% US$
Increase 1.84% 36.57% 15.70% 9.06% -48.27% 63.23% 31.74% 1.33% 11.03% 10.95% -28.91% -10.36% 53.17% -8.30% 3.78% 4.89% <-IRR #YR-> 5 5 yr Running Average 26.96% US$
5 year Running Average $11.51 $13.74 $16.75 $19.41 $19.14 $20.47 $22.08 $23.14 $24.40 $28.78 $29.50 $28.36 $29.51 $29.46 $28.97 1.11% <-IRR #YR-> 10 Revenue per Share 11.65% US$
P/S (Price/Sales) Med 1.14 1.12 1.07 0.81 1.03 1.18 0.97 1.03 1.54 1.66 1.87 1.55 -4.47% <-IRR #YR-> 5 Revenue per Share -20.45% US$
P/S (Price/Sales) Close 1.28 1.37 1.09 0.45 1.50 1.42 0.82 1.12 1.88 1.31 1.33 1.97 1.75 1.90 1.83 7.51% <-IRR #YR-> 10 5 yr Running Average 106.39% US$
*Revenue in M US $  P/S 10 yr  1.13 5 yr  1.55 54.94% Diff M/C 5.13% <-IRR #YR-> 5 5 yr Running Average 28.43% US$
$3,553 <-12 mths 32.42%
Revenue* CDN$ $1,933.2 $2,456.7 $2,239.5 $2,833.7 $1,253.8 $1,956.0 $2,652.4 $2,659.3 $3,216.4 $3,739.5 $3,081.9 $2,683.3 $3,905.5 $3,581.5 $3,716.7 9.22% <-Total Growth 10 Revenue CDN$
Increase -6.59% 27.08% -8.84% 26.53% -55.75% 56.00% 35.60% 0.26% 20.95% 16.26% -17.58% -12.93% 45.55% -8.30% 3.78% 0.89% <-IRR #YR-> 10 Revenue 9.22% CDN$
5 year Running Average $1,852.1 $1,977.5 $2,106.7 $2,306.6 $2,143.4 $2,148.0 $2,187.1 $2,271.0 $2,347.6 $2,844.7 $3,069.9 $3,076.1 $3,325 $3,398 $3,394 0.23% <-IRR #YR-> 5 Revenue 1.17% CDN$
Revenue per Share $17.01 $23.22 $22.78 $30.79 $13.61 $21.12 $28.44 $28.20 $33.47 $40.50 $34.37 $29.87 $43.48 $39.87 $41.38 4.52% <-IRR #YR-> 10 5 yr Running Average 55.55% CDN$
Increase -1.35% 36.50% -1.89% 35.16% -55.79% 55.12% 34.71% -0.87% 18.69% 21.02% -15.14% -13.08% 45.55% -8.30% 3.78% 7.06% <-IRR #YR-> 5 5 yr Running Average 40.65% CDN$
5 year Running Average $15.23 $17.09 $19.11 $22.21 $21.48 $22.30 $23.35 $24.43 $24.97 $30.35 $33.00 $33.28 $36.34 $37.62 $37.79 2.55% <-IRR #YR-> 10 Revenue per Share 28.65% CDN$
P/S (Price/Sales) Med 1.19 1.13 1.23 0.71 1.06 1.23 0.94 1.04 1.48 1.61 1.71 1.58 0.98% <-IRR #YR-> 5 Revenue per Share 5.02% CDN$
P/S (Price/Sales) Close 1.29 1.37 1.21 0.44 1.51 1.43 0.82 1.12 1.88 1.32 1.33 1.97 1.74 1.90 1.83 6.89% <-IRR #YR-> 10 5 yr Running Average 94.76% CDN$
*Revenue in M CDN $  P/S Med 10 yr  1.23 5 yr  1.58 41.14% Diff M/C 7.35% <-IRR #YR-> 5 5 yr Running Average 42.54% CDN$
-$2,457 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,683.3
-$2,652 $0.0 $0.0 $0.0 $0.0 $2,683.3
-$1,977 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $3,076.1
-$2,187 $0.0 $0.0 $0.0 $0.0 $3,076.1
-$23.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.87
-$28.44 $0.00 $0.00 $0.00 $0.00 $29.87
-$17.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $33.28
-$23.35 $0.00 $0.00 $0.00 $0.00 $33.28
$3.11 <-12 mths 2321.43%
EPS Basic US$ $1.41 $4.43 $3.69 $1.79 $0.01 $1.10 $2.16 -$0.73 $3.46 $4.79 $2.21 -$0.14 -103.16% <-Total Growth 10 Earnings US$
EPS Diluted US$ $1.40 $4.41 $3.68 $1.78 $0.01 $1.09 $2.06 -$0.73 $3.41 $4.55 $2.01 -$0.14 $3.56 $0.64 $0.63 -103.17% <-Total Growth 10 Earnings US$
Increase -27.1% 215.00% -16.55% -51.63% -99.44% 10800.0% 88.99% -135.44% 567.12% 33.43% -55.82% -106.97% 2642.9% -82.02% -1.56% #NUM! <-IRR #YR-> 10 Earnings -103.17% US$
Earnings Yield 7.5% 16.1% 14.7% 15.8% 0.1% 3.6% 9.0% -2.3% 5.8% 9.9% 6.1% -0.3% 6.0% 1.1% 1.1% #NUM! <-IRR #YR-> 5 Earnings -106.80% US$
5 year Running Average $0.80 $1.59 $2.28 $2.64 $2.26 $2.19 $1.72 $0.84 $1.17 $2.08 $2.26 $1.82 $2.68 $2.12 $1.34 1.36% <-IRR #YR-> 10 5 yr Running Average 14.47% US$
10 year Running Average $0.46 $0.91 $1.17 $1.38 $1.47 $1.50 $1.66 $1.56 $1.90 $2.17 $2.23 $1.77 $1.76 $1.65 $1.71 1.09% <-IRR #YR-> 5 5 yr Running Average 5.57% US$
* ESP per share US$ E/P 10 Yrs 5.92% 5Yrs 5.76%
$3.97 <-12 mths 2210.91%
EPS Basic $1.64 $5.16 $3.65 $2.19 $0.01 $1.09 $2.20 -$0.73 $3.68 $5.56 $3.06 -$0.19 -103.64% <-Total Growth 10 Earnings CDN$
EPS Diluted CDN$$ $1.63 $5.14 $3.64 $2.18 $0.01 $1.08 $2.10 -$0.73 $3.63 $5.28 $2.78 -$0.19 $4.54 $0.82 $0.80 -103.66% <-Total Growth 10 Earnings CDN$
Increase -29.4% 214.8% -29.24% -40.05% -99.52% 10258.4% 93.25% -134.67% 599.38% 45.54% -47.27% -106.75% 2516.3% -82.02% -1.56% #NUM! <-IRR #YR-> 10 Earnings -103.66% CDN$
Earnings Yield 7.5% 16.1% 13.2% 15.9% 0.1% 3.6% 9.0% -2.3% 5.8% 9.9% 6.1% -0.3% 6.0% 1.1% 1.1% #NUM! <-IRR #YR-> 5 Earnings -108.97% CDN$
5 year Running Average $1.00 $1.89 $2.55 $2.98 $2.52 $2.41 $1.80 $0.93 $1.22 $2.27 $2.61 $2.15 $3.21 $2.65 $1.75 1.35% <-IRR #YR-> 10 5 yr Running Average 14.30% CDN$
10 year Running Average $0.59 $1.11 $1.32 $1.60 $1.72 $1.71 $1.84 $1.74 $2.10 $2.40 $2.51 $1.98 $2.07 $1.93 $2.01 3.65% <-IRR #YR-> 5 5 yr Running Average 19.64% CDN$
* ESP per share CDN$ E/P 10 Yrs 5.93% 5Yrs 5.77%
-$5.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.19
-$2.10 $0.00 $0.00 $0.00 $0.00 -$0.19
-$1.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.15
-$1.80 $0.00 $0.00 $0.00 $0.00 $2.15
Special Dividend 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 $0.00 0.00% <-Median-> 10 Special Dividend Paid in US$
Dividend* $0.41 $0.49 $0.55 $0.61 $0.62 $0.62 $0.67 $0.73 $0.79 $0.95 $1.08 $1.10 $1.18 $1.20 $1.20 126.80% <-Total Growth 10 Dividends Paid in US$ US$
Increase 46.43% 18.29% 12.37% 11.01% 2.48% 0.00% 7.26% 9.02% 8.28% 21.02% 13.16% 2.33% 6.82% 2.13% 0.00% Count 15 Years of data US$
Average Increases 5 Year Running 44.9% 23.1% 18.1% 8.8% 6.6% 6.0% 5.4% 9.1% 11.7% 10.8% 10.3% 9.1% 4.9% 9.94% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $0.35 $0.44 $0.47 $0.53 $0.58 $0.61 $0.65 $0.68 $0.75 $0.84 $0.93 $1.02 $1.10 $1.15 165.62% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 2.46% 2.17% 2.20% 2.98% 4.64% 2.47% 2.46% 2.47% 1.62% 1.63% 2.31% 3.19% 2.36% 2.46% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 2.11% 1.86% 1.85% 1.89% 3.01% 2.04% 1.98% 2.05% 1.21% 1.30% 1.77% 2.42% 1.97% 1.94% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 2.93% 2.60% 2.73% 6.95% 10.15% 3.14% 3.24% 3.11% 2.45% 2.20% 3.35% 4.69% 2.93% 3.19% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 2.19% 1.77% 2.17% 5.38% 3.18% 2.05% 2.91% 2.27% 1.33% 2.07% 3.26% 2.51% 1.97% 2.02% 2.02% 2.39% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 29.29% 11.00% 14.81% 33.99% 6200.00% 56.88% 32.28% neg 23.02% 20.88% 53.48% neg 33.0% 187.5% 190.5% 33.14% <-Median-> 8 DPR EPS US$
DPR EPS 5 Yr Running 21.95% 19.18% 17.63% 23.63% 26.21% 35.44% 76.84% 58.48% 36.08% 37.17% 50.93% 37.98% 51.79% 85.82% 35.76% <-Median-> 7 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 12.83% 10.94% 10.16% 17.81% 51.79% 37.57% 12.93% 14.92% 12.88% 10.95% 32.46% 39.53% 15.9% 14.7% 13.5% 16.37% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 11.69% 11.66% 12.13% 15.16% 17.92% 18.24% 19.91% 18.02% 14.17% 14.95% 18.02% 17.99% 18.14% 18.83% 16.54% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 14.35% 8.24% 10.49% 23.88% 35.29% 22.29% 12.38% 13.68% 10.08% 10.63% 23.82% 33.41% 15.9% 14.7% 13.5% 17.99% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 10.52% 11.05% 11.88% 14.62% 15.84% 17.32% 18.23% 14.85% 12.41% 13.16% 15.54% 15.93% 17.03% 17.83% 14.73% <-Median-> 7 DPR CF WC 5 Yr Running US$
Median Values 5 Yr Med 5 Yr Cl 2.31% 2.27% 5 Yr Med Payout 23.02% 14.92% 13.68% 8.53% <-IRR #YR-> 10 Dividends 126.80% US$
* Dividends per share  5 Yr Med and Cur. -12.74% -11.34% Last Div Inc ---> $0.275 $0.300 9.1% 10.59% <-IRR #YR-> 5 Dividends 65.41% US$
-$0.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.10
-$0.67 $0.00 $0.00 $0.00 $0.00 $1.10
Historical Dividends Historical High Div 9.19% Low Div 1.24% Ave Div 5.22% Med Div 2.46% Close Div 2.17%
High/Ave/Median Values Curr diff Exp. -78.05%     62.65% Exp. -61.33% Exp. -18.02% Exp. -7.12%
Future Dividend Yield Div Yd 3.25% earning in 5 Years at IRR of 10.00% Div Inc. 61.05% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 5.23% earning in 10 Years at IRR of 10.00% Div Inc. 159.37% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 8.42% earning in 15 Years at IRR of 10.00% Div Inc. 317.72% Future Dividend Yield CDN$
Yield if held 5 years 3.72% 2.97% 2.93% 3.86% 7.11% 4.29% 4.07% 4.01% 2.48% 2.06% 3.86% <-Median-> 7 Paid Median Price CDN$
Yield if held 10 years 6.44% 4.92% 4.75% 5.90% 8.98% 5.68% <-Median-> 2 Paid Median Price CDN$
Yield if held 15 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price CDN$
Yield if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price CDN$
Cost covered if held 5 years 17.23% 13.66% 13.08% 16.80% 28.02% 16.75% 17.13% 17.34% 11.36% 9.89% 16.80% <-Median-> 7 Paid Median Price CDN$
Cost covered if held 10 years 42.40% 34.38% 33.65% 43.86% 71.04% 38.39% <-Median-> 2 Paid Median Price CDN$
Cost covered if held 15 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price CDN$
Cost covered if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price CDN$
Special Dividend 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 $0.00 0.00% <-Median-> 10 Special Dividend Paid in US$
use amts originally 05 to 09? $0.50 $0.54 $0.59 $0.64 $0.72 Paid in CDN$
Dividend* $0.48 $0.57 $0.54 $0.74 $0.65 $0.62 $0.68 $0.72 $0.83 $1.10 $1.49 $1.48 $1.50 $1.53 $1.53 161.33% <-Total Growth 10 Dividends Paid in US$ CDN$
Increase 41.84% 18.23% -4.72% 37.58% -12.42% -4.97% 9.67% 6.65% 15.75% 32.00% 35.07% -0.78% 1.50% 2.13% 0.00% Count 15 Years of data CDN$
Average Increases 5 Year Running 30.8% 22.3% 16.1% 6.7% 5.0% 7.3% 2.9% 11.8% 19.8% 17.7% 16.7% 14.0% 7.6% 13.96% <-Median-> 10 Average Incr 5 Year Running CDN$
Dividends 5 Yr Running $0.57 $0.77 $0.99 $1.19 $1.12 $1.03 $0.95 $0.84 $0.79 $0.96 $1.12 $1.28 $1.42 $1.51 96.33% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 2.36% 2.15% 1.92% 3.40% 4.50% 2.37% 2.52% 2.45% 1.68% 1.69% 2.54% 3.13% 2.32% 2.49% <-Median-> 10 Yield H/L Price CDN$
Yield on High  Price 2.00% 1.77% 1.54% 2.28% 3.05% 1.98% 2.10% 2.07% 1.23% 1.37% 2.01% 2.41% 1.98% 2.04% <-Median-> 10 Yield on High  Price CDN$
Yield on Low Price 2.89% 2.74% 2.53% 6.69% 8.63% 2.95% 3.14% 3.02% 2.65% 2.19% 3.45% 4.48% 2.81% 3.08% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 2.19% 1.77% 1.95% 5.41% 3.16% 2.04% 2.90% 2.28% 1.33% 2.07% 3.26% 2.51% 1.98% 2.03% 2.03% 2.39% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 29.29% 11.00% 14.81% 33.99% 6200.00% 56.88% 32.28% -99.32% 23.02% 20.88% 53.48% -785.71% 33.0% 187.5% 190.5% 27.65% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 30.39% 30.14% 33.10% 47.33% 46.49% 57.41% 102.54% 69.24% 34.79% 36.94% 52.20% 39.90% 53.64% 85.94% 46.91% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 12.83% 10.94% 10.16% 17.81% 51.79% 37.57% 12.93% 14.92% 12.88% 10.95% 32.46% 39.53% 15.9% 14.7% 13.5% 16.37% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 15.48% 17.91% 22.74% 30.42% 31.98% 29.40% 27.81% 21.69% 13.98% 15.46% 18.93% 18.66% 18.57% 19.05% 22.21% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 14.35% 8.24% 10.49% 23.88% 35.29% 22.29% 12.38% 13.68% 10.08% 10.63% 23.82% 33.41% 15.9% 14.7% 13.5% 17.99% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 13.90% 16.95% 22.25% 29.42% 28.43% 28.25% 25.81% 17.85% 12.29% 13.53% 16.26% 16.52% 17.36% 17.98% 20.05% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median Values 5 Yr Med 5 Yr Cl 2.45% 2.28% 5 Yr Med Payout 20.88% 14.92% 13.68% 10.08% <-IRR #YR-> 10 Dividends 161.33% CDN$
* Dividends per share  5 Yr Med and Cur. -17.48% -11.04% Last Div Inc ---> $0.37 $0.38 3.7% 16.91% <-IRR #YR-> 5 Dividends 118.39% CDN$
-$0.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.48
-$0.68 $0.00 $0.00 $0.00 $0.00 $1.48
Historical Dividends Historical High Div 7.46% Low Div 1.17% Ave Div 4.32% Med Div 2.36% Close Div 2.07% Historical Dividends CDN$
High/Ave/Median Values Curr diff Exp. -72.85%     73.12% Exp. -53.06% Exp. -14.17% Exp. -1.91% High/Ave/Median  CDN$
Future Dividend Yield Div Yd 3.26% earning in 5 Years at IRR of 10.00% Div Inc. 61.05% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 5.25% earning in 10 Years at IRR of 10.00% Div Inc. 159.37% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 8.46% earning in 15 Years at IRR of 10.00% Div Inc. 317.72% Future Dividend Yield CDN$
Yield if held 5 years 7.98% 5.13% 4.60% 5.28% 3.51% 3.05% 2.58% 2.57% 3.83% 7.65% 5.73% 5.50% 5.10% 3.08% 2.34% 4.21% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 years 3.21% 4.74% 4.14% 7.11% 13.31% 10.29% 6.14% 6.16% 5.95% 5.97% 7.36% 5.63% 5.34% 7.02% 10.63% 6.15% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 years 4.15% 5.67% 5.55% 8.01% 22.61% 24.85% 13.41% 12.81% 10.91% 8.29% 8.01% <-Median-> 7 Paid Median Price CDN$
Yield if held 20 years 10.01% 12.38% 11.53% 14.69% 31.41% 11.19% <-Median-> 2 Paid Median Price CDN$
Cost covered if held 5 years 26.38% 19.48% 21.58% 18.95% 16.08% 15.38% 12.27% 12.12% 16.03% 27.42% 18.56% 20.95% 21.79% 14.30% 11.53% 17.32% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 10.62% 17.98% 20.65% 32.85% 83.57% 78.31% 48.72% 50.66% 43.87% 37.47% 39.24% 33.69% 34.91% 48.56% 79.65% 41.55% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 31.53% 44.97% 46.83% 66.41% 164.62% 158.83% 99.78% 105.36% 94.45% 78.21% 66.41% <-Median-> 7 Paid Median Price CDN$
Cost covered if held 20 years 63.96% 92.09% 96.08% 134.49% 319.02% 78.02% <-Median-> 2 Paid Median Price CDN$
Graham No. last 3 EPS $13.93 $19.88 $30.24 $36.58 $33.97 $24.47 $19.40 $18.04 $18.37 $29.00 $40.36 $45.74 $35.74 $34.03 $28.96 130.11% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 1.45 1.32 0.93 0.60 0.42 1.06 1.38 1.63 2.70 2.25 1.45 1.03 1.81 1.22 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.72 1.60 1.15 0.89 0.63 1.27 1.66 1.93 3.69 2.77 1.83 1.34 2.12 1.50 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 1.19 1.04 0.70 0.30 0.22 0.85 1.11 1.33 1.71 1.74 1.07 0.72 1.49 0.96 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 1.57 1.60 0.91 0.37 0.60 1.24 1.20 1.76 3.42 1.84 1.13 1.29 2.11 2.22 2.61 1.22 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 56.94% 60.47% -8.85% -62.55% -39.57% 23.60% 20.23% 75.59% 241.94% 84.04% 13.23% 28.74% 111.50% 122.14% 160.99% 21.91% <-Median-> 10 Graham Price CDN$
Graham No. $18.91 $39.24 $33.14 $29.00 $1.82 $18.29 $26.87 $25.33 $38.69 $51.63 $40.78 $49.39 $47.02 $19.94 $19.78 25.86% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 1.07 0.67 0.85 0.75 7.92 1.42 1.00 1.16 1.28 1.26 1.44 0.95 1.37 1.21 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.26 0.81 1.05 1.12 11.71 1.70 1.20 1.38 1.75 1.55 1.82 1.24 1.61 1.46 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.87 0.53 0.64 0.38 4.13 1.14 0.80 0.94 0.81 0.98 1.06 0.67 1.14 0.88 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 1.16 0.81 0.83 0.47 11.29 1.65 0.87 1.25 1.62 1.03 1.12 1.19 1.61 3.79 3.82 1.16 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 15.57% -18.71% -16.83% -52.75% 1028.86% 65.43% -13.22% 25.09% 62.35% 3.37% 12.06% 19.23% 60.77% 279.17% 282.17% 15.65% <-Median-> 10 Graham Price CDN$
To Date
Price Close CDN$ $21.86 $31.90 $27.56 $13.70 $20.53 $30.25 $23.32 $31.68 $62.82 $53.37 $45.70 $58.89 $75.59 $75.59 $75.59 84.61% <-Total Growth 10 Stock Price CDN$ D.  per yr 2.14% 2.80%
Increase -0.23% 45.93% -13.61% -50.29% 49.85% 47.35% -22.91% 35.85% 98.30% -15.04% -14.37% 28.86% 28.36% 0.00% 0.00% 6.32% <-IRR #YR-> 10 Stock Price 84.61% CDN$ 10.62%
P/E 13.39 6.21 7.58 6.29 1961.59 27.90 11.13 -43.62 17.32 10.11 16.42 -313.28 16.64 92.57 94.04 20.35% <-IRR #YR-> 5 Stock Price 152.53% CDN$ 19.00%
Trailing P/E 9.46 19.54 5.36 3.77 9.42 2890.31 21.51 15.12 -86.50 14.72 8.66 21.16 -402.12 16.64 92.57 8.33% <-IRR #YR-> 10 Price & Dividend 114.11% CDN$ 12.76%
Median 10, 5 Yrs D.  per yr 2.00% 3.20% % Tot Ret 24.07% 13.58% Price Inc 28.86% P/E:  10.62 10.11 23.55% <-IRR #YR-> 5 Price & Dividend 179.55% CDN$ 21.80%
Price & Dividend 15 year 16.68% <-IRR #YR-> 15 Price & Dividend 261.84% CDN$ 14.89%
Price & Dividend 20 year 9.60% <-IRR #YR-> 20 Price & Dividend 246.27% CDN$ 11.56%
-$31.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $58.89
-$23.32 $0.00 $0.00 $0.00 $0.00 $58.89
-$31.90 $0.54 $0.74 $0.65 $0.62 $0.68 $0.72 $0.83 $1.10 $1.49 $60.37
-$23.32 $0.72 $0.83 $1.10 $1.49 $60.37
$0.48 $0.57 $0.54 $0.74 $0.65 $0.62 $0.68 $0.72 $0.83 $1.10 $1.49 $60.37
$0.48 $0.57 $0.54 $0.74 $0.65 $0.62 $0.68 $0.72 $0.83 $1.10 $1.49 $60.37
Price H/L Median CDN$ $20.22 $26.26 $28.09 $21.82 $14.41 $25.99 $26.85 $29.39 $49.63 $65.31 $58.60 $47.13 $64.63 79.49% <-Total Growth 10 Stock Price CDN$
Increase 9.45% 29.85% 6.97% -22.31% -33.96% 80.33% 3.31% 9.46% 68.90% 31.58% -10.27% -19.58% 37.15% 6.02% <-IRR #YR-> 10 Stock Price 79.49% CDN$
P/E 12.39 5.11 7.72 10.01 1376.84 23.97 12.81 -40.46 13.68 12.37 21.05 -250.69 14.23 11.91% <-IRR #YR-> 5 Stock Price 75.54% CDN$
Trailing P/E 8.75 16.09 5.47 6.00 6.61 2482.80 24.76 14.03 -68.33 18.01 11.10 16.93 -343.82 8.49% <-IRR #YR-> 10 Price & Dividend 115.33% CDN$
P/E on Run. 5 yr Ave 20.14 13.93 11.03 7.32 5.72 10.78 14.90 31.64 40.75 28.75 22.44 21.87 20.14 15.14% <-IRR #YR-> 5 Price & Dividend 99.01% CDN$
P/E on Run. 10 yr Ave 34.10 23.60 21.30 13.67 8.36 15.22 14.56 16.91 23.65 27.26 23.34 23.82 31.24 10.40 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D.  per yr 2.46% 3.23% % Tot Ret 29.02% 21.31% Price Inc 9.46% P/E:  12.59 12.37 Count 22 Years of data
-$26.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $47.13
-$26.85 $0.00 $0.00 $0.00 $0.00 $47.13
-$26.26 $0.54 $0.74 $0.65 $0.62 $0.68 $0.72 $0.83 $1.10 $1.49 $48.60
-$26.85 $0.72 $0.83 $1.10 $1.49 $48.60
High Months CDN$ Jun Dec Jan Jun Sep Dec Apr Mar Nov Mar May Dec Dec
Price High $23.90 $31.90 $34.87 $32.56 $21.30 $31.08 $32.16 $34.85 $67.78 $80.19 $74.03 $61.27 $75.83 92.07% <-Total Growth 10 Stock Price CDN$
Increase 5.99% 33.47% 9.31% -6.62% -34.58% 45.92% 3.47% 8.36% 94.49% 18.31% -7.68% -17.24% 23.76% 6.74% <-IRR #YR-> 10 Stock Price 92.07% CDN$
P/E 14.64 6.21 9.59 14.94 2035.16 28.67 15.35 -47.98 18.69 15.19 26.60 -325.94 16.69 13.76% <-IRR #YR-> 5 Stock Price 90.52% CDN$
Trailing P/E 10.34 19.54 6.79 8.95 9.77 2969.62 29.66 16.63 -93.33 22.11 14.02 22.01 -403.40 14.64 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 8.36% P/E:  15.27 15.19 27.43 P/E Ratio Historical High CDN$
-$31.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $61.27
-$32.16 $0.00 $0.00 $0.00 $0.00 $61.27
Low Months CDN$ Oct Jul Aug Nov Feb Jul Sep Jan Jan Dec Sep Feb  Jun
Price Low $16.54 $20.61 $21.30 $11.08 $7.52 $20.89 $21.53 $23.92 $31.48 $50.42 $43.17 $32.98 $53.43 60.02% <-Total Growth 10 Stock Price CDN$
Increase 14.86% 24.61% 3.35% -47.98% -32.13% 177.79% 3.06% 11.10% 31.61% 60.17% -14.38% -23.60% 62.01% 4.81% <-IRR #YR-> 10 Stock Price 60.02% CDN$
P/E 10.13 4.01 5.86 5.08 718.52 19.27 10.28 -32.94 8.68 9.55 15.51 -175.45 11.76 8.90% <-IRR #YR-> 5 Stock Price 53.18% CDN$
Trailing P/E 7.16 12.63 4.14 3.05 3.45 1995.99 19.86 11.42 -43.34 13.90 8.18 11.85 -284.24 7.41 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 11.10% P/E:  9.12 8.68 -6.87 P/E Ratio Historical Low CDN$
-$20.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $32.98
Price Close US$ $18.74 $27.37 $25.10 $11.24 $19.49 $30.24 $22.82 $31.87 $59.24 $45.83 $33.01 $43.80 $59.50 $59.50 $59.50 60.03% <-Total Growth 10 Stock Price US$
Increase 2.63% 46.05% -8.29% -55.22% 73.40% 55.16% -24.54% 39.66% 85.88% -22.64% -27.97% 32.69% 35.84% 0.00% 0.00% 4.81% <-IRR #YR-> 10 Stock Price 60.03% US$
P/E 13.39 6.21 6.82 6.31 1949.00 27.74 11.08 -43.66 17.37 10.07 16.42 -312.86 16.71 92.97 94.44 13.93% <-IRR #YR-> 5 Stock Price 91.94% US$
Trailing P/E 9.76 19.55 5.69 3.05 10.95 3024.00 20.94 15.47 -81.15 13.44 7.25 21.79 -425.00 16.71 92.97 7.02% <-IRR #YR-> 10 Price & Dividend 89.90% US$
Median 10, 5 Yrs D.  per yr 2.21% 3.09% % Tot Ret 31.46% 18.17% Price Inc 32.69% P/E:  10.58 10.07 17.02% <-IRR #YR-> 5 Price & Dividend 115.16% US$
-$27.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $43.80
-$22.82 $0.00 $0.00 $0.00 $0.00 $43.80
-$27.37 $0.55 $0.61 $0.62 $0.62 $0.67 $0.73 $0.79 $0.95 $1.08 $44.90
-$22.82 $0.73 $0.79 $0.95 $1.08 $44.90
Price H/L Median US$ $16.69 $22.37 $24.73 $20.33 $13.37 $25.08 $27.06 $29.33 $48.43 $58.12 $46.51 $34.46 $49.83 69.52% <-Total Growth 10 Stock Price US$
Increase 34.04% 10.55% -17.80% -34.24% 87.65% 7.87% 8.41% 65.12% 20.01% -19.98% -25.92% 44.61% 4.42% <-IRR #YR-> 10 Stock Price 54.06% US$
P/E 11.92 5.07 6.72 11.42 1336.50 23.01 13.13 -40.18 14.20 12.77 23.14 -246.11 14.00 4.95% <-IRR #YR-> 5 Stock Price 27.35% US$
Trailing P/E 8.69 15.98 5.61 5.52 7.51 2508.00 24.82 14.24 -66.34 17.04 10.22 17.14 -355.89 6.95% <-IRR #YR-> 10 Price & Dividend 90.61% US$
P/E on Run. 5 yr Ave 20.86 14.07 10.83 7.70 5.92 11.43 15.69 34.83 41.46 28.00 20.58 18.93 18.61 7.56% <-IRR #YR-> 5 Price & Dividend 46.94% US$
P/E on Run. 10 yr Ave 36.04 24.63 21.20 14.70 9.09 16.75 16.33 18.77 25.45 26.83 20.88 19.44 28.31 12.35 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 2.53% 2.60% % Tot Ret 36.41% 34.45% Price Inc 8.41% P/E:  12.95 12.77 Count 12 Years of data
-$22.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.46
-$27.06 $0.00 $0.00 $0.00 $0.00 $34.46
-$22.37 $0.55 $0.61 $0.62 $0.62 $0.67 $0.73 $0.79 $0.95 $1.08 $34.74
-$27.06 $0.73 $0.79 $0.95 $1.08 $34.74
High Months US$ Jun Dec Jan Jun Sep Dec Apr Mar Nov Mar May Dec Dec
Price High $19.40 $26.07 $29.45 $31.94 $20.62 $30.40 $33.61 $35.36 $64.87 $73.01 $60.90 $45.45 $59.50 42.30% <-Total Growth 10 Stock Price US$
Increase 34.38% 12.97% 8.46% -35.44% 47.43% 10.56% 5.21% 83.46% 12.55% -16.59% -25.37% 30.91% 5.72% <-IRR #YR-> 10 Stock Price 74.34% US$
P/E 13.39 6.21 6.82 6.31 1949.00 27.74 11.08 -43.66 17.37 10.07 16.42 -312.86 16.71 6.22% <-IRR #YR-> 5 Stock Price 35.23% US$
Trailing P/E 9.76 19.55 5.69 3.05 10.95 3024.00 20.94 15.47 -81.15 13.44 7.25 21.79 -425.00 10.58 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc 5.21% P/E:  10.58 10.07 21.52 P/E Ratio Historical High US$
-$26.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $45.45
-$33.61 $0.00 $0.00 $0.00 $0.00 $45.45
Low Months US$ Oct Aug Aug Nov Feb Jul Oct Jan Jan Dec Sep Feb  Jun
Price Low $13.97 $18.66 $20.00 $8.71 $6.11 $19.76 $20.50 $23.30 $31.99 $43.23 $32.12 $23.46 $40.15 169.35% <-Total Growth 10 Stock Price US$
Increase 33.57% 7.18% -56.45% -29.85% 223.40% 3.74% 13.66% 37.30% 35.14% -25.70% -26.96% 71.14% 2.32% <-IRR #YR-> 10 Stock Price 25.72% US$
P/E 13.39 6.21 6.82 6.31 1949.00 27.74 11.08 -43.66 17.37 10.07 16.42 -312.86 16.71 2.73% <-IRR #YR-> 5 Stock Price 14.44% US$
Trailing P/E 9.76 19.55 5.69 3.05 10.95 3024.00 20.94 15.47 -81.15 13.44 7.25 21.79 -425.00 10.58 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc 13.66% P/E:  10.58 10.07 -13.74 P/E Ratio Historical Low US$
-$18.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.46
Debt US$ $1,528 $1,488 $1,502 $1,450 Debt US$
Change -2.63% 0.95% -3.51% -0.84% <-Median-> 2 Change US$
Debt CDN$ $1,773 $2,061 $2,017 $1,849 Debt CDN$
Change 16.23% -2.11% -8.31% 7.06% <-Median-> 2 Change CDN$
Ratio to Market Cap 0.36 0.50 0.38 0.27 0.38 <-Median-> 3 % of Market Cap CDN$
Goodwill and Intangibles $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Intangibles Goodwill US$
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! <-Median-> 0 Change US$
Goodwill and Intangibles $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Intangibles Goodwill CDN$
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! <-Median-> 0 Change CDN$
Ratio to Market Cap 0.00 0.00 0.00 0.00 0.00 0.00 0.00 <-Median-> 5 % of Market Cap CDN$
Market Cap US$ $2,130 $2,896 $2,468 $1,034 $1,795 $2,801 $2,128 $3,006 $5,693 $4,231 $2,960 $3,934 $5,345 $5,345 $5,345 35.86% <-Total Growth 10 Market Cap  US$
Market Cap CDN$ $2,484 $3,375 $2,709 $1,261 $1,891 $2,802 $2,175 $2,988 $6,037 $4,927 $4,098 $5,290 $6,790 $6,790 $6,790 56.73% <-Total Growth 10 Market Cap  CDN$
Diluted # of Shares in Million 118.363 109.441 102.130 94.914 92.689 93.504 94.361 93.756 96.431 96.194 91.346 89.784 -17.96% <-Total Growth 10 Basic
Change -7.54% -6.68% -7.07% -2.34% 0.88% 0.92% -0.64% 2.85% -0.25% -5.04% -1.71% -1.18% <-Median-> 10 Change
Basic # of Shares in Millions 117.766 109.111 101.717 94.521 92.063 92.218 93.026 93.756 95.259 94.996 90.648 89.784 -17.71% <-Total Growth 10 Basic
Change -3.09% -7.35% -6.78% -7.07% -2.60% 0.17% 0.88% 0.78% 1.60% -0.28% -4.58% -0.95% -0.61% <-Median-> 10 Change
Difference -3.5% -3.0% -3.3% -2.6% 0.0% 0.4% 0.2% 0.6% 0.9% -2.8% -1.1% 0.0% 0.05% <-Median-> 10 Difference
$673.7 <-12 mths 169.57%
# of Shares in Millions 113.645 105.801 98.310 92.031 92.108 92.632 93.248 94.310 96.101 92.326 89.671 89.824 89.824 89.824 89.824 -1.62% <-IRR #YR-> 10 Shares -15.10%
Change -5.31% -6.90% -7.08% -6.39% 0.08% 0.57% 0.66% 1.14% 1.90% -3.93% -2.88% 0.17% 0.00% 0.00% 0.00% -0.75% <-IRR #YR-> 5 Shares -3.67%
CF fr Op $M US$ $363.0 $468.8 $527.3 $312.6 $110.3 $152.9 $479.7 $458.3 $585.8 $801.0 $297.0 $249.9 $664.7 $732.1 $799.4 -46.69% <-Total Growth 10 Cash Flow US$
Increase 8.92% 29.14% 12.48% -40.72% -64.73% 38.66% 213.78% -4.47% 27.83% 36.74% -62.93% -15.83% 165.95% 10.14% 9.20% SO Buy Backs
5 year Running Average $325 $343 $411 $401 $356 $314 $317 $303 $357 $496 $524 $478 $520 $549 $549 39.37% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $3.19 $4.43 $5.36 $3.40 $1.20 $1.65 $5.14 $4.86 $6.10 $8.68 $3.31 $2.78 $7.40 $8.15 $8.90 -37.21% <-Total Growth 10 Cash Flow per Share US$
Increase 15.03% 38.71% 21.05% -36.68% -64.76% 37.88% 211.70% -5.54% 25.44% 42.33% -61.83% -15.98% 165.95% 10.14% 9.20% -6.10% <-IRR #YR-> 10 Cash Flow -46.69% US$
5 year Running Average $2.67 $2.98 $3.75 $3.83 $3.52 $3.21 $3.35 $3.25 $3.79 $5.29 $5.62 $5.14 $5.65 $6.06 $6.11 -12.23% <-IRR #YR-> 5 Cash Flow -47.90% US$
P/CF on Med Price 5.22 5.05 4.61 5.98 11.17 15.20 5.26 6.04 7.95 6.70 14.04 12.38 6.73 -4.55% <-IRR #YR-> 10 Cash Flow per Share -37.21% US$
P/CF on Closing Price 5.87 6.18 4.68 3.31 16.28 18.32 4.44 6.56 9.72 5.28 9.97 15.74 8.04 7.30 6.69 -11.57% <-IRR #YR-> 5 Cash Flow per Share -45.91% US$
13.96% Diff M/C 5.60% <-IRR #YR-> 10 CFPS 5 yr Running 72.37% US$
Excl.Working Capital CF -$38.3 $154.1 -$16.572 -$79.431 $51.555 $104.757 $21.246 $41.528 $162.862 $24.020 $107.7 $45.8 $0.0 $0.0 $0.0 8.96% <-IRR #YR-> 5 CFPS 5 yr Running 53.56% US$
CF fr Op $M WC US$ $324.7 $622.9 $510.8 $233.2 $161.8 $257.6 $501.0 $499.8 $748.7 $825.0 $404.6 $295.7 $664.7 $732.1 $799.4 -52.53% <-Total Growth 10 Cash Flow less WC US$
Increase -12.80% 91.83% -18.01% -54.35% -30.60% 59.22% 94.44% -0.23% 49.79% 10.20% -50.96% -26.91% 124.77% 10.14% 9.20% -7.18% <-IRR #YR-> 10 Cash Flow less WC -52.53% US$
5 year Running Average $313 $380 $433 $413 $371 $357 $333 $331 $434 $566 $596 $555 $588 $584 $579 -10.00% <-IRR #YR-> 5 Cash Flow less WC -40.97% US$
CFPS Excl. WC US$ $2.86 $5.89 $5.20 $2.53 $1.76 $2.78 $5.37 $5.30 $7.79 $8.94 $4.51 $3.29 $7.40 $8.15 $8.90 3.86% <-IRR #YR-> 10 CF less WC 5 Yr Run 46.05% US$
Increase -7.91% 106.06% -11.76% -51.24% -30.66% 58.32% 93.16% -1.35% 47.00% 14.71% -49.51% -27.03% 124.77% 10.14% 9.20% 10.76% <-IRR #YR-> 5 CF less WC 5 Yr Run 66.66% US$
5 year Running Average $2.58 $3.32 $3.96 $3.92 $3.65 $3.63 $3.53 $3.55 $4.60 $6.04 $6.38 $5.97 $6.39 $6.46 $6.45 -5.65% <-IRR #YR-> 10 CFPS - Less WC -44.08% US$
P/CF on Med Price 5.84 3.80 4.76 8.02 7.61 9.02 5.04 5.53 6.22 6.50 10.31 10.47 6.73 -9.33% <-IRR #YR-> 5 CFPS - Less WC -38.72% US$
P/CF on Closing Price 6.56 4.65 4.83 4.44 11.09 10.87 4.25 6.01 7.60 5.13 7.32 13.30 8.04 7.30 6.69 6.05% <-IRR #YR-> 10 CFPS 5 yr Running 79.90% US$
CF/-WC P/CF Med 10 yr 7.32 5 yr  7.95 P/CF Med 10 yr 7.06 5 yr  6.50 13.96% Diff M/C 11.08% <-IRR #YR-> 5 CFPS 5 yr Running 69.11% US$
$859.6 <-12 mths 156.16%
CF fr Op $M CDN$ $423.3 $546.3 $521.1 $382.8 $115.4 $152.1 $487.9 $455.9 $623.1 $929.3 $411.2 $335.6 $848.1 $934.0 $1,020.0 -38.58% <-Total Growth 10 Cash Flow CDN$
Increase 5.51% 29.07% -4.63% -26.53% -69.86% 31.77% 220.84% -6.54% 36.65% 49.15% -55.75% -18.39% 152.72% 10.14% 9.20% SO Buy Backs CDN$
5 year Running Average $438.2 $427.5 $471.7 $454.9 $397.8 $343.5 $331.8 $318.8 $366.9 $529.6 $581.5 $551.0 $629.4 $691.6 $709.8 28.89% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $3.72 $5.16 $5.30 $4.16 $1.25 $1.64 $5.23 $4.83 $6.48 $10.06 $4.59 $3.74 $9.44 $10.40 $11.36 -27.65% <-Total Growth 10 Cash Flow per Share CDN$
Increase 11.43% 38.64% 2.64% -21.52% -69.88% 31.03% 218.72% -7.60% 34.11% 55.24% -54.44% -18.53% 152.72% 10.14% 9.20% -4.76% <-IRR #YR-> 10 Cash Flow -38.58% CDN$
5 year Running Average $3.58 $3.70 $4.28 $4.34 $3.92 $3.50 $3.52 $3.42 $3.89 $5.65 $6.24 $5.94 $6.86 $7.65 $7.90 -7.21% <-IRR #YR-> 5 Cash Flow -31.21% CDN$
P/CF on Med Price 5.43 5.08 5.30 5.25 11.50 15.83 5.13 6.08 7.66 6.49 12.78 12.61 6.85 -3.18% <-IRR #YR-> 10 Cash Flow per Share -27.65% CDN$
P/CF on Closing Price 5.87 6.18 5.20 3.29 16.39 18.43 4.46 6.55 9.69 5.30 9.97 15.76 8.01 7.27 6.66 -6.51% <-IRR #YR-> 5 Cash Flow per Share -28.59% CDN$
13.21% Diff M/C 4.84% <-IRR #YR-> 10 CFPS 5 yr Running 60.50% CDN$
Excl.Working Capital CF -$44.7 $179.6 -$16.4 -$97.3 $54.0 $104.2 $21.6 $41.3 $173.2 $27.9 $149.1 $61.5 $0.0 $0.0 $0.0 11.05% <-IRR #YR-> 5 CFPS 5 yr Running 68.91% CDN$
CF fr Op $M WC CDN$ $378.6 $725.9 $504.7 $285.5 $169.4 $256.2 $509.5 $497.3 $796.3 $957.1 $560.3 $397.1 $848.1 $934.0 $1,020.0 -45.30% <-Total Growth 10 Cash Flow less WC CDN$
Increase -15.53% 91.74% -30.47% -43.42% -40.69% 51.31% 98.82% -2.40% 60.13% 20.20% -41.46% -29.13% 113.58% 10.14% 9.20% -5.85% <-IRR #YR-> 10 Cash Flow less WC -45.30% CDN$
5 year Running Average $421 $474 $497 $469 $413 $388 $345 $344 $446 $603 $664 $642 $712 $739 $752 -4.86% <-IRR #YR-> 5 Cash Flow less WC -22.06% CDN$
CFPS Excl. WC $3.33 $6.86 $5.13 $3.10 $1.84 $2.77 $5.46 $5.27 $8.29 $10.37 $6.25 $4.42 $9.44 $10.40 $11.36 3.07% <-IRR #YR-> 10 CF less WC 5 Yr Run 35.24% CDN$
Increase -10.79% 105.95% -25.18% -39.56% -40.74% 50.45% 97.51% -3.50% 57.15% 25.11% -39.73% -29.25% 113.58% 10.14% 9.20% 13.21% <-IRR #YR-> 5 CF less WC 5 Yr Run 85.94% CDN$
5 year Running Average $3.45 $4.12 $4.53 $4.43 $4.05 $3.94 $3.66 $3.69 $4.73 $6.43 $7.13 $6.92 $7.75 $8.18 $8.37 -4.30% <-IRR #YR-> 10 CFPS - Less WC -35.57% CDN$
P/CF on Med Price 6.07 3.83 5.47 7.03 7.84 9.39 4.91 5.57 5.99 6.30 9.38 10.66 6.85 9.83% <-IRR #YR-> 5 CFPS - Less WC -19.09% CDN$
P/CF on Closing Price 6.56 4.65 5.37 4.42 11.17 10.94 4.27 6.01 7.58 5.15 7.31 13.32 8.01 7.27 6.66 5.32% <-IRR #YR-> 10 CFPS 5 yr Running 67.86% CDN$
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 7.07 5 yr  7.66 P/CF Med 10 yr 6.67 5 yr  6.30 20.10% Diff M/C 13.58% <-IRR #YR-> 5 CFPS 5 yr Running 88.99% CDN$
-$5.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.74 Cash Flow per Share CDN$
-$5.23 $0.00 $0.00 $0.00 $0.00 $3.74 Cash Flow per Share CDN$
-$3.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.94 CFPS 5 yr Running CDN$
-$3.52 $0.00 $0.00 $0.00 $0.00 $5.94 CFPS 5 yr Running CDN$
-$726 $0 $0 $0 $0 $0 $0 $0 $0 $0 $397 Cash Flow less WC CDN$
-$509 $0 $0 $0 $0 $397 Cash Flow less WC CDN$
-$474 $0 $0 $0 $0 $0 $0 $0 $0 $0 $642 CF less WC 5 Yr Run CDN$
-$345 $0 $0 $0 $0 $642 CF less WC 5 Yr Run CDN$
-$6.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.42 CFPS - Less WC CDN$
-$2.77 $0.00 $0.00 $0.00 $0.00 $4.42 CFPS - Less WC CDN$
-$4.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.92 CFPS 5 yr Running CDN$
-$3.66 $0.00 $0.00 $0.00 $0.00 $6.92 CFPS 5 yr Running CDN$
OPM 21.90% 22.24% 23.27% 13.51% 9.20% 7.77% 18.39% 17.14% 19.37% 24.85% 13.34% 12.51% -43.76% <-Total Growth 10 OPM CDN$
Increase 12.95% 1.57% 4.62% -41.94% -31.87% -15.53% 136.60% -6.79% 12.99% 28.28% -46.31% -6.27% Should increase  or be stable. CDN$
Diff from Ave 42.9% 45.1% 51.8% -11.9% -40.0% -49.3% 20.0% 11.9% 26.4% 62.1% -12.9% -18.4% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 15.33% 5 Yrs 17.14% should be  zero, it is a   check on calculations
Current Assets US$ $308.94 $990.25 $1,233.10 $736.33 $622.65 $622.65 $1,034.6 $1,456.2 $1,601.2 $1,685.9 $1,032.1 $1,025.7 $1,153.5 Liquidity ratio of 1.5 and up, best US$
Current Liabilities $250.91 $341.03 $498.27 $258.70 $271.60 $271.60 $603.0 $441.0 $745.3 $819.8 $581.9 $606.9 $727.5 2.22 <-Median-> 10 Ratio US$
Liquidity Ratio 1.23 2.90 2.47 2.85 2.29 2.29 1.72 3.30 2.15 2.06 1.77 1.69 1.59 2.06 <-Median-> 5 Ratio US$
Liq. with CF aft div 2.49 4.13 3.43 3.84 2.49 2.64 2.41 4.19 2.83 2.93 2.12 1.94 2.35 2.83 <-Median-> 5 Ratio US$
Liq. CF re  Inv+Div  1.69 3.82 2.19 1.28 1.04 1.84 1.95 2.76 1.66 1.60 1.22 1.69 2.35 1.66 <-Median-> 5 Ratio US$
Assets US$ $2,097.0 $2,453.1 $2,869.9 $2,799.0 $2,923.4 $2,923.4 $3,393.6 $3,544.6 $4,113.5 $4,775.3 $4,494.0 $4,556.7 $4,591.0 Debt Ratio of 1.5 and up, best US$
Liabilities $1,147.5 $1,234.7 $1,493.3 $1,422.0 $1,554.2 $1,500.7 $1,791.6 $2,066.9 $2,208.2 $2,722.1 $2,525.5 $2,751.3 $2,840.4 1.87 <-Median-> 10 Ratio US$
Debt Ratio 1.83 1.99 1.92 1.97 1.88 1.95 1.89 1.71 1.86 1.75 1.78 1.66 1.62 1.75 <-Median-> 5 Ratio US$
Total Book Value US$ $950 $1,218 $1,377 $1,377 $1,369 $1,423 $1,602 $1,478 $1,905 $2,053 $1,969 $1,805 $1,751 48.17% <-Total Growth 10 Total Book Value US$
Non-Control. Int US$ $0 $9 $41 $89 $133 $146 $197 $188 $248 $267 $249 $209 $228 Non-Cont. Int US$
Book Value US$ $950 $1,209 $1,335 $1,288 $1,236 $1,277 $1,405 $1,290 $1,658 $1,786 $1,720 $1,597 $1,523 $1,523 $1,523 32.05% <-Total Growth 10 Book Value US$
Book Value per Share $8.36 $11.43 $13.58 $14.00 $13.42 $13.78 $15.06 $13.68 $17.25 $19.35 $19.18 $17.78 $16.95 $16.95 $16.95 55.54% <-Total Growth 10 Book Value per Share US$
Change 5.64% 36.80% 18.84% 3.07% -4.14% 2.70% 9.31% -9.21% 26.12% 12.17% -0.88% -7.30% -4.63% 0.00% 0.00% 80.21% P/B Ratio Current/Historical Median US$
P/B Ratio (Median) 2.00 1.96 1.82 1.45 1.00 1.82 1.80 2.14 2.81 3.00 2.43 1.94 2.94 1.95 P/B Ratio Historical Median US$
P/B Ratio (Close) 2.24 2.39 1.85 0.80 1.45 2.19 1.51 2.33 3.43 2.37 1.72 2.46 3.51 3.51 3.51 4.52% <-IRR #YR-> 10 Book Value per Share 55.54% US$
Change -2.85% 6.76% -22.83% -56.55% 80.89% 51.08% -30.96% 53.83% 47.38% -31.03% -27.33% 43.14% 42.45% 0.00% 0.00% 3.37% <-IRR #YR-> 5 Book Value per Share 18.01% US$
Leverage (A/BK) 2.21 2.03 2.15 2.17 2.37 2.29 2.42 2.75 2.48 2.67 2.61 2.85 3.01 2.45 <-Median-> 10 A/BV US$
Debt/Equity Ratio 1.21 1.02 1.12 1.10 1.26 1.18 1.28 1.60 1.33 1.52 1.47 1.72 1.87 1.30 <-Median-> 10 Debt/Eq Ratio US$
Book Value is Asset less Liabilities P/BV 10 yr Med 1.88 5 yr Med 2.43 86.76% Diff M/C 2.21 Historical Leverage (A/BK) US$
-$11.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.78
-$15.06 $0.00 $0.00 $0.00 $0.00 $17.78
Current Assets CDN$ $360.19 $1,153.94 $1,218.43 $901.70 $651.67 $619.29 $1,052.2 $1,448.7 $1,703.0 $1,955.8 $1,429.2 $1,377.2 $1,471.8 Liquidity ratio of 1.5 and up, best CDN$
Current Liabilities $292.53 $397.41 $492.34 $316.80 $284.26 $270.14 $613.2 $438.7 $792.7 $951.1 $805.8 $814.9 $928.2 2.22 <-Median-> 10 Ratio CDN$
Liquidity Ratio 1.23 2.90 2.47 2.85 2.29 2.29 1.72 3.30 2.15 2.06 1.77 1.69 1.59 2.06 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.49 4.13 3.43 3.84 2.49 2.64 2.41 4.19 2.83 2.93 2.12 1.94 2.35 2.83 <-Median-> 5 Ratio CDN$
Liq. CF re  Inv+Div  1.69 3.82 2.19 1.28 1.04 1.84 1.95 2.76 1.66 1.60 1.22 1.69 2.35 1.66 <-Median-> 5 Ratio CDN$
Assets CDN$ $2,444.9 $2,858.5 $2,835.7 $3,427.7 $3,059.6 $2,907.6 $3,451.3 $3,526.5 $4,375.1 $5,539.9 $6,223.1 $6,118.2 $5,857.6 Debt Ratio of 1.5 and up, best CDN$
Liabilities $1,337.9 $1,438.7 $1,475.5 $1,741.4 $1,626.6 $1,492.6 $1,822.1 $2,056.3 $2,348.6 $3,157.9 $3,497.1 $3,694.2 $3,624.0 1.87 <-Median-> 10 Ratio CDN$
Debt Ratio 1.83 1.99 1.92 1.97 1.88 1.95 1.89 1.71 1.86 1.75 1.78 1.66 1.62 1.75 <-Median-> 5 Ratio CDN$
B V CDN$ check $1,107 $1,420 $1,360 $1,686 $1,433 $1,415 $1,629 $1,470 $2,027 $2,382 $2,726 $2,424 $2,234 B V CDN$ check CDN$
Total Book Value CDN$ $1,107 $1,420 $1,360 $1,686 $1,433 $1,415 $1,629 $1,470 $2,027 $2,382 $2,726 $2,424 $2,234 70.73% <-Total Growth 10 Book Value CDN$
Non-Control. Int CDN$$ $0 $11 $41 $108 $139 $145 $201 $187 $263 $310 $345 $280 $291 Non-Cont. Int CDN$
Book Value CDN$ $1,107 $1,409 $1,319 $1,578 $1,294 $1,270 $1,429 $1,283 $1,763 $2,072 $2,381 $2,144 $1,943 $1,943 $1,943 52.15% <-Total Growth 10 Book Value CDN$
Book Value per Share $9.74 $13.32 $13.42 $17.14 $14.05 $13.71 $15.32 $13.61 $18.35 $22.45 $26.56 $23.87 $21.63 $21.63 $21.63 79.22% <-Total Growth 10 Book Value per Share CDN$
Change 2.33% 36.73% 0.77% 27.74% -18.07% -2.41% 11.77% -11.18% 34.83% 22.34% 18.31% -10.12% -9.38% 0.00% 0.00% 84.34% P/B Ratio Current/Historical Median CDN$
P/B Ratio (Median) 2.08 1.97 2.09 1.27 1.03 1.90 1.75 2.16 2.71 2.91 2.21 1.97 2.99 0.00 0.00 1.90 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 2.24 2.40 2.05 0.80 1.46 2.21 1.52 2.33 3.42 2.38 1.72 2.47 3.49 3.49 3.49 6.01% <-IRR #YR-> 10 Book Value per Share 79.22% CDN$
Change -2.50% 6.73% -14.27% -61.08% 82.92% 50.98% -31.03% 52.95% 47.07% -30.56% -27.63% 43.37% 41.64% 0.00% 0.00% 9.27% <-IRR #YR-> 5 Book Value per Share 55.80% CDN$
Leverage (A/BK) 2.21 2.03 2.15 2.17 2.37 2.29 2.42 2.75 2.48 2.67 2.61 2.85 3.01 2.45 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.21 1.02 1.12 1.10 1.26 1.18 1.28 1.60 1.33 1.52 1.47 1.72 1.87 1.30 <-Median-> 10 Debt/Eq Ratio CDN$
Book Value is Asset less Liabilities P/BV 10 yr Med 2.03 5 yr Med 2.21 71.86% Diff M/C 2.21 Historical Leverage (A/BK)
-$13.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.87
-$15.32 $0.00 $0.00 $0.00 $0.00 $23.87
$258.57 <-12 mths 1085.39%
Comprehensive Income US$ $234.40 -$30.63 $392.18 $516.74 $175.05 -$41.92
NCI 33.206 $30.69 $51.60 $56.97 $2.85 -$15.68
Shareholders $367.01 $140.94 -$0.11 $86.14 $201.19 -$61.32 $340.58 $459.77 $172.19 -$26.24 -107.15% <-Total Growth 9 Comprehensive Income US$
Increase -61.60% -100.08% 79859.3% 133.57% -130.48% 655.44% 35.00% -62.55% -115.24% -62.55% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $159.03 $73.37 $113.30 $205.27 $222.48 $177.00 #NUM! <-IRR #YR-> 9 Comprehensive Income -107.15% US$
ROE US$ 26.7% 10.2% 0.0% 6.1% 12.6% -4.1% 17.9% 22.4% 8.7% -1.5% #NUM! <-IRR #YR-> 5 Comprehensive Income -113.04% US$
5Yr Median 10.2% 6.1% 6.1% 12.6% 12.6% 8.7% 2.16% <-IRR #YR-> 5 5 Yr Running Average #DIV/0! US$
% Difference from NI -5.23% -21.86% -113.21% -24.02% -12.37% 21.41% -9.98% -12.01% -25.02% -85.01% 2.16% <-IRR #YR-> 5 5 Yr Running Average 11.29% US$
Median Values Diff 5, 10 yr -17.1% -12.0% 8.7% <-Median-> 5 Return on Equity US$
-$367.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$26.2
-$201.2 $0.0 $0.0 $0.0 $0.0 -$26.2
-$159.0 $0.0 $0.0 $0.0 $0.0 $177.0
-$159.0 $0.0 $0.0 $0.0 $0.0 $177.0
Current Liability Coverage Ratio US$ 1.29 1.83 1.03 0.90 0.60 0.95 0.83 1.13 1.00 1.01 0.70 0.49 0.91   CFO / Current Liabilities US$
5 year Median 1.29 1.57 1.29 1.03 1.03 0.95 0.90 0.90 0.95 1.00 1.00 1.00 0.91 1.00 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 15.48% 25.39% 17.80% 8.33% 5.54% 8.81% 14.76% 14.10% 18.20% 17.28% 9.00% 6.49% 14.48% CFO / Total Assets US$
5 year Median 15.97% 15.97% 17.80% 17.80% 15.48% 8.81% 8.81% 8.81% 14.10% 14.76% 14.76% 14.10% 14.48% 14.1% <-Median-> 5 Return on Assets  US$
Return on Assets ROA US$ 7.9% 19.7% 13.1% 6.0% 0.0% 3.5% 5.9% -1.9% 8.0% 9.5% 4.5% -0.3% 7.3% Net  Income/Assets Return on Assets US$
5Yr Median 4.2% 7.9% 13.1% 13.1% 7.9% 6.0% 5.9% 3.5% 3.5% 5.9% 5.9% 4.5% 7.3% 4.5% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ 17.5% 39.9% 28.1% 13.1% 0.1% 8.0% 14.3% -5.3% 19.9% 25.4% 11.7% -0.8% 22.1% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 7.6% 17.5% 24.9% 24.9% 17.5% 13.1% 13.1% 8.0% 8.0% 14.3% 14.3% 11.7% 19.9% 11.7% <-Median-> 5 Return on Equity US$
$272.94 <-12 mths 2275.67%
Net Income US$ $228.00 -$34.58 $377.00 $506.31 $202.35 -$28.23
NCI $26.67 $33.53 $47.83 $51.70 $1.74 -$15.68
Shareholders $165.75 $482.95 $375.67 $168.75 $0.74 $101.73 $201.33 -$68.11 $329.17 $454.61 $200.62 -$12.55 $336 $240 $250 -102.60% <-Total Growth 10 Net Income US$
Increase -29.90% 191.37% -22.21% -55.08% -99.56% 13685% 97.90% -133.83% 583.32% 38.11% -55.87% -106.25% 2778.36% -28.57% 4.17% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $100.29 $182.60 $252.45 $285.91 $238.77 $225.97 $169.64 $80.89 $112.97 $203.75 $223.52 $180.75 $261.57 $243.74 $202.81 #NUM! <-IRR #YR-> 10 Net Income -102.60% US$
Operating Cash Flow $363.05 $468.84 $527.34 $312.60 $110.26 $152.88 $479.71 $458.28 $585.80 $801.02 $296.95 $249.93 #NUM! <-IRR #YR-> 5 Net Income -106.23% US$
Investment Cash Flow -$118.39 -$27.68 -$280.41 -$518.00 -$380.33 -$119.13 -$142.56 -$228.41 -$526.43 -$681.02 -$426.26 -$88.21 -0.10% <-IRR #YR-> 10 5 Yr Running Average -1.01% US$
Total Accruals -$78.90 $41.79 $128.74 $374.16 $270.81 $67.98 -$135.82 -$297.97 $269.80 $334.62 $329.92 -$174.27 1.28% <-IRR #YR-> 5 5 Yr Running Average 6.55% US$
Total Assets $2,097.0 $2,453.1 $2,869.9 $2,799.0 $2,923.4 $2,923.4 $3,393.6 $3,544.6 $4,113.5 $4,775.3 $4,494.0 $4,556.7 Balance Sheet Assets US$
Accruals Ratio -3.76% 1.70% 4.49% 13.37% 9.26% 2.33% -4.00% -8.41% 6.56% 7.01% 7.34% -3.82% 6.56% <-Median-> 5 Ratio US$
EPS/CF Ratio (WC) 0.49 0.75 0.71 0.70 0.01 0.39 0.38 -0.14 0.44 0.51 0.45 -0.04
-$482.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$12.5
-$201.3 $0.0 $0.0 $0.0 $0.0 -$12.5
-$182.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $180.7
-$169.6 $0.0 $0.0 $0.0 $0.0 $180.7
Financial Cash Flow US$ -$295.95 -$244.86 -$113.76 $45.31 $111.43 -$9.74 -$180.23 $165.03 -$54.02 $98.87 -$567.36 -$192.77 C F Statement  Financial Cash Flow US$
Total Accruals $217.05 $286.65 $242.50 $328.85 $159.38 $77.73 $44.41 -$463.00 $323.82 $235.75 $897.28 $18.50 Accruals US$
Accruals Ratio 10.35% 11.69% 8.45% 11.75% 5.45% 2.66% 1.31% -13.06% 7.87% 4.94% 19.97% 0.41% 4.94% <-Median-> 5 Ratio US$
$329.91 <-12 mths 1036.37%
Comprehensive Income CDN$ $238.38 -$30.47 $417.12 $599.47 $242.39 -$56.29
NCI $33.77 $30.53 $54.88 $66.09 $3.95 -$21.05
Shareholders $362.64 $172.59 -$0.11 $85.67 $204.61 -$61.00 $362.24 $533.38 $238.44 -$35.23 -109.72% <-Total Growth 9 Comprehensive Income CDN$
Increase -52.41% -100.07% 75896% 138.83% -129.81% 693.79% 47.25% -55.30% -114.78% -55.30% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $165.08 $80.35 $118.28 $224.98 $255.53 $207.56 #NUM! <-IRR #YR-> 9 Comprehensive Income -109.72% CDN$
ROE CDN$ 26.7% 10.2% 0.0% 6.1% 12.6% -4.1% 17.9% 22.4% 8.7% -1.5% #NUM! <-IRR #YR-> 5 Comprehensive Income -117.22% CDN$
5Yr Median 8.1% 10.2% 6.1% 6.1% 12.6% 12.6% 8.7% 4.69% <-IRR #YR-> 5 5 Yr Running Average #DIV/0! CDN$
% Difference from NI -5.23% -21.86% -113.21% -24.02% -12.37% 21.41% -9.98% -12.01% -25.02% -85.01% 4.69% <-IRR #YR-> 5 5 Yr Running Average 25.73% CDN$
Median Values Diff 5, 10 yr -17.1% -12.0% 8.7% <-Median-> 5 Return on Equity CDN$
-$362.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$35.2
-$204.6 $0.0 $0.0 $0.0 $0.0 -$35.2
-$165.1 $0.0 $0.0 $0.0 $0.0 $207.6
-$165.1 $0.0 $0.0 $0.0 $0.0 $207.6
Current Liability Coverage Ratio CDN$ 1.29 1.83 1.03 0.90 0.60 0.95 0.83 1.13 1.00 1.01 0.70 0.49 0.91   CFO / Current Liabilities CDN$
5 year Median 1.29 1.57 1.29 1.03 1.03 0.95 0.90 0.90 0.95 1.00 1.00 1.00 0.91 1.00 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 15.48% 25.39% 17.80% 8.33% 5.54% 8.81% 14.76% 14.10% 18.20% 17.28% 9.00% 6.49% 14.48% CFO / Total Assets CDN$
5 year Median 15.97% 15.97% 17.80% 17.80% 15.48% 8.81% 8.81% 8.81% 14.10% 14.76% 14.76% 14.10% 14.48% 14.1% <-Median-> 5 Return on Assets  CDN$
Return on Assets ROA CDN$ 7.9% 19.7% 13.1% 6.0% 0.0% 3.5% 5.9% -1.9% 8.0% 9.5% 4.5% -0.3% 7.3% Net  Income/Assets Return on Assets CDN$
5Yr Median 4.2% 7.9% 13.1% 13.1% 7.9% 6.0% 5.9% 3.5% 3.5% 5.9% 5.9% 4.5% 7.3% 4.5% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 17.5% 39.9% 28.1% 13.1% 0.1% 8.0% 14.3% -5.3% 19.9% 25.4% 11.7% -0.8% 22.1% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 7.6% 17.5% 24.9% 24.9% 17.5% 13.1% 13.1% 8.0% 8.0% 14.3% 14.3% 11.7% 19.9% 11.7% <-Median-> 5 Return on Equity CDN$
$348.24 <-12 mths 2167.43%
Net Income CDN$ $231.88 -$34.40 $400.98 $587.37 $280.21 -$37.90
NCI $27.13 $33.36 $50.88 $59.97 $2.40 -$21.05
Shareholders $193.25 $562.78 $371.20 $206.65 $0.77 $101.18 $204.75 -$67.76 $350.10 $527.39 $277.80 -$16.84 $429 $306 $319 -102.99% <-Total Growth 10 Net Income CDN$
Increase -32.09% 191.22% -34.04% -44.33% -99.63% 13000.1% 102.35% -133.09% 616.70% 50.64% -47.33% -106.06% 2645.11% -28.57% 4.17% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $127.0 $216.8 $282.7 $323.7 $266.9 $248.5 $176.9 $89.1 $117.8 $223.1 $258.5 $214.1 $313.4 $304.7 $263.0 #NUM! <-IRR #YR-> 10 Net Income -102.99% CDN$
Operating Cash Flow $423.28 $546.34 $521.06 $382.80 $115.39 $152.06 $487.86 $455.94 $623.05 $929.26 $411.20 $335.58 $848.09 $934.05 $1,020.00 #NUM! <-IRR #YR-> 5 Net Income -108.23% CDN$
Investment Cash Flow -$138.03 -$32.25 -$277.07 -$634.34 -$398.05 -$118.49 -$144.99 -$227.24 -$559.91 -$790.05 -$590.25 -$118.44 -0.12% <-IRR #YR-> 10 5 Yr Running Ave. -1.24% CDN$
Total Accruals -$91.99 $48.70 $127.21 $458.20 $283.43 $67.62 -$138.13 -$296.45 $286.96 $388.19 $456.86 -$233.99 3.89% <-IRR #YR-> 5 5 Yr Running Ave. 21.04% CDN$
Total Assets $2,444.9 $2,858.5 $2,835.7 $3,427.7 $3,059.6 $2,907.6 $3,451.3 $3,526.5 $4,375.1 $5,539.9 $6,223.1 $6,118.2 Balance Sheet Assets CDN$
Accruals Ratio -3.76% 1.70% 4.49% 13.37% 9.26% 2.33% -4.00% -8.41% 6.56% 7.01% 7.34% -3.82% 6.56% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.49 0.75 0.71 0.70 0.01 0.39 0.38 -0.14 0.44 0.51 0.45 -0.04 0.41 <-Median-> 10 EPS/CF Ratio CDN$
-$562.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$16.8
-$204.7 $0.0 $0.0 $0.0 $0.0 -$16.8
-$216.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $214.1
-$176.9 $0.0 $0.0 $0.0 $0.0 $214.1
Change in Close -0.23% 45.93% -13.61% -50.29% 49.85% 47.35% -22.91% 35.85% 98.30% -15.04% -14.37% 28.86% 28.36% 0.00% 0.00% count 20 Change in Close CDN$
up/down down down down up down down down count 8 CDN$
Meet Prediction? yes yes % right count 3 37.50% CDN$
Financial Cash Flow CDN$ -$345.05 -$285.34 -$112.40 $55.49 $116.62 -$9.69 -$183.29 $164.19 -$57.45 $114.70 -$785.65 -$258.83 C F Statement  Financial Cash Flow CDN$
Total Accruals $253.05 $334.03 $239.61 $402.71 $166.81 $77.31 $45.16 -$460.64 $344.41 $273.49 $1,242.51 $24.84 Accruals CDN$
Accruals Ratio 10.35% 11.69% 8.45% 11.75% 5.45% 2.66% 1.31% -13.06% 7.87% 4.94% 19.97% 0.41% 4.94% <-Median-> 5 Ratio CDN$
Cash US$ $169.79 $193.79 $350.71 $745.61 $732.74 $951.60 $254.93 $223.89 $307.46 Cash US$
Cash CDN$ $177.70 $192.75 $356.67 $741.81 $779.34 $1,103.95 $353.02 $300.62 $392.29 Cash CDN$
Cash per Share CDN$ $1.93 $2.08 $3.83 $7.87 $8.11 $11.96 $3.94 $3.35 $4.37 $7.87 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 9.40% 6.88% 16.40% 24.83% 12.91% 22.40% 8.61% 5.68% 5.78% 12.91% <-Median-> 5 % of Stock Price CDN$
Notes:
December 23, 2017.  Last estimates were for 2016, 2017 and 2018 of $1966M, $2419 and $2561 Revnue US$, -$0.29, $0.86 and $2.30 EPS US$, 
$2.30, $4.34 and $6.46 CFPS US$, $33M, $79M and $207M for Net Income US$
December 24, 2016.  Last estimates were for 2015, 2016 and 2017 of $2364M, $2669M and $2938M for Revenue US$, $2.26, $2.49 and $3.89 for EPS US$, 
$4.77, $5.33 and $6.55 for CFPS US$ and $208M, $240M and $344M Net Income US$.
December26, 2015.  Last estimates were for 2014, 2015 and 2016 of $3253M $3335M and $3525M for Revenue US$, $4.35, $4.83 and $5.72 for EPS $US, 
$6.97, $7.45 and $9.58 CFPS US$ and $438M, $536M and $588M for Net Income US$
December 22, 2014.  Last estimates were for 2013, 2014 and 2015 of Revenue $3016.3M, $3379.7M and $3386M US$, $4.59, $5.28 and $5.10 for EPS US$,
and  $6.01, $6.71 and $7.27 for CFPS US$, and net income $338M, $400M and $470M US$.
December 17, 2013.  Last estimates were for 2012 and 2013 of $2592M and $2830M US$ and $2.01 and 2.83 EPS US$ and $4.70 and $6.20 CFPS US$
Petrochemicals giant Methanex Corp. said Friday John Floren has been named to the position of President and Chief Executive Officer.
He succeeds Bruce Aitken, who is retiring after 21 years with Methanex, but will remain a director.
Dec 14, 2012.  Last estimates were for 2011 and 2012 of $2539M and $2532M US$ for Revenue, $1.95 and $3.24 for EPS US$ and $3.88 and $5.00 US$ for CFPS.
Nov 17, 2011.  Estimates I got last were $1.01 and $2.75 US$ 2010 and 2011 EPS and $$2.35 and $4.45 US$ CF 2010 and 2011.
Nov 28, 2010 I started spreadsheet on this stock.  I had seen some good reviews.  It is also on the dividend lists I follow.
Sector:
Materials
What should this stock accomplish?
You would buy this stock for diversification reasons and because it operates internationally.  There may be volatility in this stock, especially concerning Earnings and Cash Flow.
I would expect moderate dividend yield and moderate dividend growth over the longer term, but there might also be volatility in dividends.
Would I buy this company and Why.
This company’s earnings depend on the price of Methanol, which can fluctuate in price.  However, it has been able to make money for its shareholders and it pays a decent dividend.
Yes, I would consider this company to buy.  One main reason would be diversification.
Why am I following this stock. 
I started a spreadsheet in November 2010 as I had read some good reports on the stock at that time.  It is also got a solid “C” grade in a 2009 Money Sense review of stocks.  Money Sense rated the top 100 
Canadian Dividend Paying stocks.  Money Sense was looking for stocks that provided generous income at reasonable prices.
Dividends
Cycle 3, payable in March, June, September and December.  Dividends are declared for shareholder of a month and payable in that month.
On November 27, 2013 the company declared the dividend for Shareholders of  record of December 17, 2013 and payable on December 31, 2013.
Misson Statement or closes thing I can find.
What I am looking for is a statement that the company wants to do well by their customers, employees, and community and and thereby earn shareholders a reasonable return.
They say that their customers trust them to provide methanol through safe, reliable and cost-effective operations.
They say that have a responsible Care program to look after the health and safety of employees and that they strive to be a respected and valued corporate citizen.
How they make their money.
Methanex is the world's largest supplier of methanol to major international markets in North America, Asia Pacific, Europe and Latin America.  Methanol is an important ingredient in many of the essential 
industrial and consumer products. Head Office is in Vancouver, B. C. Canada.
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 Shares %, Val $M
Date Dec 19 2012 Dec 18 2013 Dec 22 2014 Dec 23 2015 Dec 24 2016 Dec 23 2017
Floren, John 0.081 0.08% 0.073 0.08% 0.078 0.09% 0.081 0.09% 0.064 0.07% <----
CEO - Shares - Amount $5.075 $3.875 $3.554 $4.752 $4.819
Options - percentage 0.172 0.18% 0.500 0.54% 0.599 0.67% 0.751 0.84% 0.676 0.75%
Options - amount $10.801 $26.698 $27.372 $44.206 $51.098
Cameron, Ian Peter 0.017 0.02% 0.025 0.03% 0.026 0.03% 0.027 0.03% 0.028 0.03% 0.029 0.03%
CFO - Shares - Amount $0.538 $1.547 $1.376 $1.214 $1.628 $2.211
Options - percentage 0.646 0.69% 0.301 0.31% 0.285 0.31% 0.268 0.30% 0.288 0.32% 0.299 0.33%
Options - amount $20.468 $18.917 $15.193 $12.255 $16.978 $22.608
Bach, Wendy 0.005 0.01% 0.007 0.01% 0.009 0.01% 0.015 0.02% 0.022 0.02% 0.025 0.03%
Officer - Shares - Amount $0.158 $0.433 $0.495 $0.693 $1.300 $1.873
Options - percentage 0.042 0.04% 0.029 0.03% 0.111 0.12% 0.144 0.16% 0.174 0.19% 0.161 0.18%
Options - amount $1.331 $1.826 $5.938 $6.604 $10.218 $12.146
Cook, Phillip Henry 0.020 0.02% 0.020 0.02% 0.025 0.03% 0.025 0.03% 0.025 0.03%
Director - Shares - Amount $1.256 $1.067 $1.143 $1.472 $1.890
Options - percentage 0.007 0.01% 0.003 0.00% 0.005 0.01% 0.004 0.00% 0.004 0.00%
Options - amount $0.424 $0.165 $0.250 $0.232 $0.306
Balloch, Howard 0.002 0.00% 0.002 0.00% 0.002 0.00% 0.002 0.00% 0.002 0.00%
Director - Shares - Amount $0.054 $0.091 $0.078 $0.100 $0.129
Options - percentage 0.037 0.04% 0.044 0.05% 0.045 0.05% 0.046 0.05% 0.047 0.05%
Options - amount $1.163 $2.340 $2.037 $2.694 $3.570
Aitken, Bruce  0.131 0.14% 0.236 0.25% 0.221 0.24% 0.221 0.25% 0.221 0.25% 0.221 0.25% Was CEO 2012
Director - Shares - Amount $4.157 $14.837 $11.804 $10.108 $13.025 $16.719 Was Chairman 2014
Options - percentage 1.602 1.70% 1.097 1.14% 0.852 0.92% 0.784 0.87% 0.782 0.87% 0.713 0.79%
Options - amount $50.767 $68.937 $45.481 $35.809 $46.064 $53.911
Hamilton, Thomas 0.012 0.01% 0.012 0.01% 0.012 0.01%
Chairman - Shares - Amount $0.548 $0.707 $0.907
Options - percentage 0.006 0.01% 0.008 0.01% 0.008 0.01%
Options - amount $0.271 $0.460 $0.581
Abrary, Nojan 0.012 0.01% 0.016 0.02% 0.021 0.02%
Subsidiary Executive $0.393 $0.857 $0.975
Options - percentage 0.027 0.03% 0.034 0.04% 0.042 0.05%
Options - amount $0.871 $1.807 $1.917
Increase in O/S Shares 1.062 1.11% 1.791 1.86% 0.537 0.58% 0.291 0.32% 0.153 0.17%
due to SO $66.728 $112.511 $28.645 $13.290 $9.018
Book Value $18.819 $38.585 $10.657 $5.046 $1.506
Insider Buying -$0.318 -$0.878 -$0.465 -$0.037
Insider Selling $13.832 $9.434 $0.883 $2.787
Net Insider Selling $13.514 $8.555 $0.418 $2.749
% of Market Cap 0.27% 0.21% 0.01% 0.04%
Directors 11 11 12 12 12
Women 2 18% 2 18% 3 25% 3 25% 3 25%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 150 71.89% 0 0.00% 0 80.59% 238 87.99% 189 87.67% 222 84.06%
Total Shares Held 67.678 70.42% 0.000 0.00% 75.507 81.78% 79.108 88.22% 78.737 87.66% 70.556 78.55%
Increase/Decrease 0.445 0.66% 0.000 #DIV/0! 2.805 3.86% 5.121 6.92% -0.660 -0.83% -0.713 -1.00%
Starting No. of Shares 67.233 0.000 72.702 Nasdaq 73.987 Nasdaq 79.397 Nasdaq 71.269 Nasdaq
Copyright © 2008 Website of SPBrunner. All rights reserved.