This report is for educational purposes only, and not to provide investment advice. Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ Q3 2017
Encana Corp TSX: ECA NYSE: ECA www.encana.com Fiscal Yr: Dec 31 9/30/17
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 Currency
Accounting Rules C GAAP IFRS US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP Accounting Rules
Curr Exch US$-CDN$ 1.1630 1.1652 0.9881 1.2240 1.0501 0.9970 1.0213 0.9968 1.0636 1.1601 1.3847 1.3427 1.2729 1.2729 1.2729
split 2 1.94
AEC to ECA
$4,088 <-12 mths 40.10%
Rev US$ pre 09 $14,266 $16,399 $21,466 $30,064
Revenue US$ $7,354 $8,453 $11,065 $15,497 $11,114 $8,870 $8,467 $5,160 $5,868 $8,019 $4,422 $2,918 $4,146 $4,562 $5,201 -65.48% <-Total Growth 10 Revenue US$
Increase 39.06% 14.95% 30.90% 40.05% -28.28% -20.19% -4.54% -39.06% 13.72% 36.66% -44.86% -34.01% 42.08% 10.03% 14.01% -10.09% <-IRR #YR-> 10 Revenue -65.48% US$
5 year Running Average $4,178 $5,407 $7,081 $9,531 $10,697 $11,000 $11,003 $9,822 $7,896 $7,277 $6,387 $5,277 $5,075 $4,813 $4,250 -19.19% <-IRR #YR-> 5 Revenue -65.54% US$
Revenue per Share $8.69 $10.87 $14.75 $20.65 $14.79 $12.05 $11.50 $7.01 $7.92 $10.82 $5.20 $3.00 $4.26 $4.69 $5.35 -0.24% <-IRR #YR-> 10 5 yr Running Average -2.40% US$
Increase 48.1% 25.0% 35.7% 40.0% -28.4% -18.6% -4.5% -39.1% 13.0% 36.6% -51.9% -42.4% 42.1% 10.0% 14.0% -13.67% <-IRR #YR-> 5 5 yr Running Average -52.03% US$
5 year Running Average $5.09 $6.35 $8.74 $12.17 $13.95 $14.62 $14.75 $13.20 $10.65 $9.86 $8.49 $6.79 $6.24 $5.59 $4.50 -12.08% <-IRR #YR-> 10 Revenue per Share -72.40% US$
10 year Running Average 2.29 2.89 2.33 1.67 1.83 2.65 -23.57% <-IRR #YR-> 5 Revenue per Share -73.92% US$
P/S (Price/Sales) Close 5.19 2.18 2.38 1.16 2.19 2.42 1.61 2.82 2.28 1.28 0.93 3.91 2.96 2.69 2.36 0.67% <-IRR #YR-> 10 5 yr Running Average 6.86% US$
Revenue Net of Royalities in $M US$ P/S Close 10 yr 2.23 5 yr 2.33 32.35% Diff M/C -14.37% <-IRR #YR-> 5 5 yr Running Average -53.96% US$
-$8,453 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,918
-$8,467 $0 $0 $0 $0 $2,918
-$5,407 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,277
-$11,003 $0 $0 $0 $0 $5,277
-$10.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.00
-$11.50 $0.00 $0.00 $0.00 $0.00 $3.00
-$6.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.79
-$14.75 $0.00 $0.00 $0.00 $0.00 $6.79
$5,204 <-12 mths 32.81%
Rev* CDN Pre 09 $16,591 $19,108 $21,211 $36,798 CDN$
Revenue* CDN $8,552 $9,850 $10,933 $18,968 $11,671 $8,843 $8,648 $5,144 $6,241 $9,303 $6,123 $3,918 $5,277 $5,807 $6,620 -60.22% <-Total Growth 10 Revenue CDN$
Increase 34.23% 15.17% 11.00% 73.49% -38.47% -24.23% -2.21% -40.52% 21.34% 49.06% -34.18% -36.02% 34.70% 10.03% 14.01% -8.81% <-IRR #YR-> 10 Revenue -60.22% CDN$
5 year Running Average $5,411 $6,645 $7,980 $10,935 $11,995 $12,053 $11,813 $10,655 $8,109 $7,636 $7,092 $6,146 $6,173 $6,086 $5,549 -14.64% <-IRR #YR-> 5 Revenue -54.69% CDN$
Revenue per Share $10.11 $12.66 $14.57 $25.28 $15.53 $12.01 $11.74 $6.99 $8.42 $12.55 $7.21 $4.03 $5.42 $5.97 $6.80 -0.78% <-IRR #YR-> 10 5 yr Running Average -7.52% CDN$
Increase 42.91% 25.24% 15.10% 73.44% -38.54% -22.68% -2.21% -40.52% 20.58% 48.99% -42.59% -44.12% 34.70% 10.03% 14.01% -12.25% <-IRR #YR-> 5 5 yr Running Average -47.97% CDN$
5 year Running Average $6.68 $7.77 $9.79 $13.94 $15.63 $16.01 $15.83 $14.31 $10.94 $10.34 $9.38 $7.84 $7.53 $7.04 $5.89 -10.82% <-IRR #YR-> 10 Revenue per Share -68.20% CDN$
P/S (Price/Sales) Med 2.60 2.19 2.17 1.42 1.83 2.68 2.23 2.96 2.28 1.60 1.67 2.67 2.64 0.00 0.00 -19.27% <-IRR #YR-> 5 Revenue per Share -65.71% CDN$
P/S (Price/Sales) Close 2.68 2.18 2.39 1.16 2.20 2.42 1.61 2.81 2.28 1.29 0.98 3.91 2.96 2.69 2.36 0.09% <-IRR #YR-> 5 5 yr Running Average 0.89% CDN$
*Revenue CDN $M (ACE to end 2001) P/S Med 10 yr 2.20 5 yr 2.28 34.38% Diff M/C -13.11% <-IRR #YR-> 5 5 yr Running Average -50.48% CDN$
-$9,850 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,918
-$8,648 $0 $0 $0 $0 $3,918
-$6,645 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,146
-$11,813 $0 $0 $0 $0 $6,146
-$12.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.03
-$11.74 $0.00 $0.00 $0.00 $0.00 $4.03
-$7.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.84
-$15.83 $0.00 $0.00 $0.00 $0.00 $7.84
$0.80 <-12 mths 174.77%
pre split 2005
EPS* US$ pre 09 $3.95 $6.89 $5.23 $7.91
EPS Basic $2.04 $3.55 $2.70 $4.08 $2.48 $2.03 $0.17 -$3.79 $0.32 $4.58 -$6.28 -$1.07 -130.13% <-Total Growth 10 EPS Basic US$
pre split 2005
EPS* US$ pre 09 $3.85 $6.76 $5.18 $7.91
EPS Diluted US$ $1.98 $3.48 $2.67 $4.08 $2.48 $2.03 $0.17 -$3.79 $0.32 $4.58 -$6.28 -$1.07 $0.71 $0.64 $0.97 -130.71% <-Total Growth 10 EPS Diluted US$
Increase 2.53% 75.58% -23.37% 52.70% -39.18% -18.15% -91.63% -2329.41% 108.44% 1331.25% -237.12% 82.96% 166.36% -9.86% 51.56% #NUM! <-IRR #YR-> 10 Earnings per Share -130.71% US$
Earnings Yield 4.4% 14.7% 7.6% 17.0% 7.7% 7.0% 0.9% -19.2% 1.8% 33.0% -130.0% -9.1% 5.6% 5.1% 7.7% #NUM! <-IRR #YR-> 5 Earnings per Share -729.41% US$
5 year Running Average $1.29 $1.88 $2.27 $2.83 $2.94 $2.95 $2.29 $0.99 $0.24 $0.66 -$1.00 -$1.25 -$0.35 -$0.28 -$1.01 #NUM! <-IRR #YR-> 10 5 yr Running Average -166.33% US$
10 year Running Average $0.76 $1.10 $1.35 $1.76 $1.99 $2.12 $2.08 $1.63 $1.54 $1.80 $0.97 $0.52 $0.32 -$0.02 -$0.17 #NUM! <-IRR #YR-> 5 5 yr Running Average -154.61% US$
*Fully diluted EPS E/P 10 Yrs 4.37% 5Yrs -9.11%
-$3.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.07
-$0.17 $0.00 $0.00 $0.00 $0.00 -$1.07
-$1.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.25
-$2.29 $0.00 $0.00 $0.00 $0.00 -$1.25
$1.02 <-12 mths 170.88%
pre split 2005
EPS* CDN$ pre 09
EPS Basic CND$ $2.37 $4.14 $2.66 $4.99 $2.60 $2.02 $0.17 -$3.78 $0.34 $5.31 -$8.70 -$1.44 -134.72% <-Total Growth 10 EPS Basic CDN$
pre stock exch 02
pre split 2005
EPS* CDN$ pre 09 $4.48 $7.88 $5.12 $9.68
EPS* CDN$ $2.31 $4.06 $2.64 $4.99 $2.60 $2.02 $0.17 -$3.78 $0.34 $5.31 -$8.70 -$1.44 $0.90 $0.81 $1.23 -135.38% <-Total Growth 10 EPS Diluted CDN$
Increase -1.03% 75.92% -35.02% 89.16% -47.82% -22.29% -91.42% -2275.93% 109.01% 1461.11% -263.67% 83.48% 162.91% -9.86% 51.56% #NUM! <-IRR #YR-> 10 Earnings per Share -135.38% CDN$
Earnings Yield 8.5% 14.7% 7.6% 17.0% 7.6% 7.0% 0.9% -19.2% 1.8% 32.9% -123.7% -9.1% 5.6% 5.1% 7.7% #NUM! <-IRR #YR-> 5 Earnings per Share -927.46% CDN$
5 year Running Average $1.66 $2.30 $2.59 $3.27 $3.32 $3.26 $2.49 $1.20 $0.27 $0.81 -$1.33 -$1.65 -$0.72 -$0.62 -$1.44 #NUM! <-IRR #YR-> 10 5 yr Running Average -171.80% CDN$
10 year Running Average $1.01 $1.40 $1.63 $2.13 $2.37 $2.46 $2.39 $1.90 $1.77 $2.07 $0.97 $0.42 $0.24 -$0.17 -$0.31 #NUM! <-IRR #YR-> 5 5 yr Running Average -166.43% CDN$
*Fully diluted EPS E/P 10 Yrs 4.37% 5Yrs -9.12%
-$4.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.44
-$0.17 $0.00 $0.00 $0.00 $0.00 -$1.44
-$2.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.65
-$2.49 $0.00 $0.00 $0.00 $0.00 -$1.65
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends US$
pre split 2005 US$
Div US$ pre 09 $0.30 $0.40 $0.80 $1.60 Div US$ pre 09 US$
Dividend US$ $0.15 $0.21 $0.41 $0.82 $0.80 $0.80 $0.80 $0.80 $0.67 $0.28 $0.28 $0.06 $0.06 $0.06 $0.06 -70.90% <-Total Growth 10 Dividends US$
Increase 50.00% 33.33% 100.00% 100.00% -3.00% 0.00% 0.00% 0.00% -16.25% -58.21% 0.00% -78.57% 0.00% 0.00% 0.00% Count 25 Years of data US$
Dividends 5 Yr Running $0.11 $0.13 $0.20 $0.34 $0.48 $0.61 $0.73 $0.80 $0.77 $0.67 $0.57 $0.42 $0.27 $0.15 $0.10 211.89% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 3.96% 3.62% 1.55% 2.94% 0.76% 0.55% 2.94% <-Median-> 5 Yield H/L Price US$
Yield on High Price 3.53% 3.29% 1.14% 1.95% 0.47% 0.44% 1.95% <-Median-> 5 Yield on High Price US$
Yield on Low Price 4.50% 4.03% 2.41% 6.00% 1.99% 0.75% 4.03% <-Median-> 5 Yield on Low Price US$
Yield on Close Price 0.34% 0.87% 1.18% 3.44% 2.47% 2.75% 4.32% 4.05% 3.71% 2.02% 5.80% 0.51% 0.48% 0.48% 0.48% 3.09% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 7.79% 5.92% 15.44% 20.23% 32.26% 39.41% 470.59% neg 209.38% 6.11% neg neg 8.45% 9.38% 6.19% 32.26% <-Median-> 7 DPR EPS US$
DPR EPS 5 Yr Running 7.12% 8.64% 12.02% 16.32% 20.64% 31.83% 81.02% 319.83% 101.21% -56.60% -33.49% -77.59% -52.11% -10.34% 18.48% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 3.42% 3.90% 7.12% 13.56% 7.68% 24.91% 14.57% 18.96% 21.69% 7.78% 14.15% 9.34% 4.65% 3.14% 2.49% 13.86% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 4.26% 4.74% 7.00% 7.47% 9.88% 11.73% 13.68% 14.64% 17.08% 15.40% 15.45% 12.74% 7.86% 6.32% 12.70% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 3.52% 6.72% 7.11% 13.16% 7.65% 13.27% 14.11% 16.79% 19.48% 7.63% 16.64% 6.97% 4.65% 3.14% 2.49% 13.21% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 5.12% 5.58% 7.96% 8.00% 9.62% 10.63% 12.13% 12.75% 14.21% 14.72% 14.50% 12.34% 7.86% 6.38% 11.38% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 5 Yr Med 5 Yr Cl 2.94% 3.71% 5 Yr Med Payout 107.74% 14.15% 16.64% -11.61% <-IRR #YR-> 10 Dividends -70.90% US$
* Dividends per share 5 Yr Med and Cur. -83.82% -87.17% Last Div Inc ---> $0.070 $0.015 -78.6% -40.43% <-IRR #YR-> 5 Dividends -92.50% US$
-$0.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.06
-$0.80 $0.00 $0.00 $0.00 $0.00 $0.06
Historical Dividends Historical High Div 5.70% Low Div 0.60% Ave Div 3.15% Med Div 2.94% Close Div 2.02% Historical Dividends US$
High/Ave/Median Values Curr diff Exp. -91.65% Exp -20.63% Exp. -84.88% Exp. -83.80% Exp. -76.41% High/Ave/Median Values US$
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends CDN$
AEC Div CDN$
pre split 2005 CDN$
Dividend CDN$* $0.18 $0.24 $0.41 $1.01 $0.84 $0.80 $0.82 $0.80 $0.71 $0.32 $0.39 $0.08 $0.08 $0.08 $0.08 -66.47% <-Total Growth 10 Dividends CDN$
Increase 44.80% 33.59% 69.60% 147.75% -16.78% -5.06% 2.44% -2.40% -10.64% -54.42% 19.36% -79.22% -5.20% 0.00% 0.00% Count 25 Years of data CDN$
Dividends 5 Yr Running $0.14 $0.17 $0.22 $0.39 $0.54 $0.66 $0.77 $0.85 $0.79 $0.69 $0.61 $0.46 $0.32 $0.19 $0.14 174.07% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 0.68% 0.87% 1.29% 2.81% 2.96% 2.48% 3.12% 3.86% 3.71% 1.62% 3.22% 0.75% 0.53% 2.88% <-Median-> 10 Yield H/L Price CDN$
Yield on High Price 0.50% 0.76% 1.12% 2.04% 2.49% 2.21% 2.42% 3.35% 3.44% 1.22% 2.21% 0.47% 0.43% 2.21% <-Median-> 10 Yield on High Price CDN$
Yield on Low Price 1.07% 1.01% 1.52% 4.50% 3.64% 2.82% 4.40% 4.55% 4.03% 2.40% 5.95% 1.77% 0.71% 3.83% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 0.66% 0.87% 1.17% 3.44% 2.46% 2.74% 4.33% 4.06% 3.72% 2.01% 5.52% 0.51% 0.48% 0.48% 0.48% 3.09% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 7.79% 5.92% 15.44% 20.23% 32.26% 39.41% 470.59% -21.11% 209.38% 6.11% -4.46% -5.61% 8.45% 9.38% 6.19% 17.84% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 8.48% 7.31% 8.37% 12.01% 16.13% 20.19% 31.15% 70.86% 290.63% 84.69% -45.73% -27.89% -44.25% -30.50% -9.71% 18.16% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 3.42% 3.90% 7.12% 13.56% 7.68% 24.91% 14.57% 18.96% 21.69% 7.78% 14.15% 9.34% 4.65% 3.14% 2.49% 13.86% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 4.48% 4.41% 4.63% 7.07% 7.53% 9.84% 11.76% 13.57% 14.55% 16.85% 15.19% 15.08% 12.45% 7.98% 6.49% 12.66% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 3.52% 6.72% 7.11% 13.16% 7.65% 13.27% 14.11% 16.79% 19.48% 7.63% 16.64% 6.97% 4.65% 3.14% 2.49% 13.21% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 4.76% 5.20% 5.48% 8.07% 8.09% 9.70% 10.70% 12.10% 12.71% 14.10% 14.63% 14.26% 12.13% 8.01% 6.56% 11.40% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median Values 5 Yr Med 5 Yr Cl 3.22% 3.72% 5 Yr Med Payout -4.46% 14.15% 16.64% -10.35% <-IRR #YR-> 10 Dividends -66.47% CDN$
* Dividends per share 5 Yr Med and Cur. -85.21% -87.18% Last Div Inc ---> $0.20 $0.07 -65.0% -37.08% <-IRR #YR-> 5 Dividends -90.14% CDN$
Historical Dividends Historical High Div 4.52% Low Div 0.53% Ave Div 2.53% Med Div 1.45% Close Div 1.44% Historical Dividends CDN$
High/Ave/Median Values Curr diff Exp. -89.47% Exp -10.16% Exp. -81.14% Exp. -67.16% Exp. -66.97% High/Ave/Median CDN$
Future Dividend Yield Div Yd 0.77% earning in 5 Years at IRR of 10.00% Div Inc. 61.05% Future Dividend Yield
Future Dividend Yield Div Yd 1.24% earning in 10 Years at IRR of 10.00% Div Inc. 159.37% Future Dividend Yield
Future Dividend Yield Div Yd 1.99% earning in 15 Years at IRR of 10.00% Div Inc. 317.72% Future Dividend Yield
Yield if held 5 years 1.87% 2.15% 3.63% 8.03% 5.33% 3.03% 2.94% 2.52% 1.98% 1.14% 1.20% 0.31% 0.37% 0.40% 0.38% 2.73% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 years 5.20% 4.99% 7.57% 17.81% 12.05% 8.31% 7.30% 7.11% 5.67% 2.06% 1.47% 0.29% 0.24% 0.21% 0.27% 7.20% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 years 17.40% 29.47% 23.84% 23.06% 16.97% 14.81% 12.57% 4.66% 4.04% 0.72% 0.68% 0.61% 0.48% 15.89% <-Median-> 10 Paid Median Price CDN$
Yield if held 20 years 34.05% 20.80% 9.22% 11.21% 1.67% 1.42% 1.35% 1.10% 11.21% <-Median-> 5 Paid Median Price CDN$
Yield if held 25 years 3.26% 2.23% 2.17% #NUM! <-Median-> 0 Paid Median Price CDN$
Cost covered if held 5 years 7.34% 7.51% 9.67% 15.59% 17.00% 12.52% 13.94% 13.45% 11.03% 12.15% 9.44% 8.80% 7.66% 4.92% 3.47% 12.33% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 30.51% 25.45% 29.03% 44.15% 46.93% 41.65% 42.10% 47.66% 47.12% 38.91% 24.08% 22.24% 18.44% 13.66% 14.60% 41.88% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 81.32% 83.27% 102.81% 125.77% 105.86% 108.19% 114.09% 96.40% 73.30% 62.68% 61.77% 54.64% 43.33% 99.61% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 20 years 263.31% 199.01% 200.71% 213.65% 153.70% 137.57% 130.78% 106.40% 200.71% <-Median-> 5 Paid Median Price CDN$
Cost covered if held 25 years 330.86% 226.63% 220.50% #NUM! <-Median-> 0 Paid Median Price CDN$
Graham Price $24.27 $35.10 $28.89 $46.57 $36.89 $32.69 $9.41 $5.29 $7.52 $42.57 $11.89 $11.89 $13.61 $12.92 $15.91 -66.12% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 1.08 0.79 1.10 0.77 0.77 0.99 2.78 3.90 2.55 0.47 1.01 0.91 1.05 1.00 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.48 0.90 1.26 1.06 0.91 1.11 3.59 4.49 2.76 0.63 1.48 1.43 1.32 1.35 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.69 0.68 0.93 0.48 0.63 0.86 1.97 3.31 2.35 0.32 0.55 0.38 0.79 0.75 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 1.12 0.79 1.20 0.63 0.92 0.89 2.01 3.72 2.55 0.38 0.59 1.33 1.18 1.24 1.01 1.06 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 11.62% -21.20% 20.45% -36.96% -7.53% -11.00% 100.85% 271.51% 154.98% -62.02% -40.87% 32.55% 17.84% 24.12% 0.82% 6.46% <-Median-> 10 Graham Price CDN$
AEC to 2001
pre split 2005
Price Close CDN$ $27.09 $27.66 $34.79 $29.36 $34.11 $29.09 $18.89 $19.66 $19.18 $16.17 $7.03 $15.76 $16.04 $16.04 $16.04 -43.02% <-Total Growth 10 Stock Price CDN$
Increase 53.68% 2.09% 25.79% -15.61% 16.18% -14.72% -35.06% 4.08% -2.44% -15.69% -56.52% 124.18% 1.78% 0.00% 0.00% -5.47% <-IRR #YR-> 10 Stock Price -43.02% CDN$
P/E 11.74 6.81 13.19 5.88 13.10 14.37 108.80 -5.20 56.35 3.04 -0.81 -10.97 17.75 19.69 12.99 -3.56% <-IRR #YR-> 5 Stock Price -16.57% CDN$
Trailing P/E 11.62 11.98 8.57 11.13 6.83 11.17 9.33 113.23 -5.08 47.51 1.32 -1.81 -11.16 17.75 19.69 -2.66% <-IRR #YR-> 10 Price & Dividend CDN$
Median 10, 5 Yrs D. per yr 2.81% 2.60% % Tot Ret 0.00% 0.00% Price Inc -2.44% P/E: 9.49 -0.81 -0.96% <-IRR #YR-> 5 Price & Dividend CDN$
Price Med H/L CDN$ $26.31 $27.77 $31.69 $35.94 $28.40 $32.21 $26.16 $20.65 $19.21 $20.10 $12.04 $10.77 $14.34 -61.23% <-Total Growth 10 Stock Price CDN$
Increase 67.07% 5.53% 14.12% 13.43% -20.98% 13.39% -18.77% -21.08% -6.95% 4.61% -40.08% -10.59% 33.21% -9.04% <-IRR #YR-> 10 Stock Price -61.23% CDN$
P/E 11.40 6.84 12.01 7.20 10.91 15.91 150.67 -5.46 56.44 3.78 -1.38 -7.49 15.87 -16.27% <-IRR #YR-> 5 Stock Price -58.85% CDN$
Trailing P/E 11.28 12.03 7.80 13.62 5.69 12.37 12.93 118.90 -5.08 59.04 2.27 -1.24 -9.98 -5.78% <-IRR #YR-> 10 Price & Dividend CDN$
P/E on Run. 5 yr Ave 15.83 12.07 12.21 11.01 8.55 9.87 10.52 17.16 70.41 24.67 -9.06 -6.52 -20.05 -14.00% <-IRR #YR-> 5 Price & Dividend CDN$
P/E on Run. 10 yr Ave 26.15 19.82 19.40 16.88 12.01 13.08 10.93 10.87 10.86 9.72 12.45 25.79 58.79 12.01 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D. per yr 3.26% 2.27% % Tot Ret 0.00% 0.00% Price Inc -10.59% P/E: 9.05 -1.38 Count 25 Years of data CDN$
High Months Sep Aug/Dec Jun May May Jan Mar Oct Mar Jun Feb Dec Jan
AEC
pre split 2005
Price High CDN$ $35.81 $31.65 $36.53 $49.46 $33.72 $36.15 $33.76 $23.78 $20.73 $26.66 $17.56 $16.99 $17.96 -46.32% <-Total Growth 10 Stock Price CDN$
Increase 99.51% -11.63% 15.41% 35.41% -31.82% 7.20% -6.61% -29.56% -12.83% 28.61% -34.13% -3.25% 5.71% -6.03% <-IRR #YR-> 10 Stock Price -46.32% CDN$
P/E 15.52 7.80 13.84 9.91 12.95 17.86 194.44 -6.29 60.91 5.02 -2.02 -11.83 19.87 -12.83% <-IRR #YR-> 5 Stock Price -49.67% CDN$
Trailing P/E 15.36 13.71 9.00 18.75 6.76 13.88 16.68 136.96 -5.49 78.33 3.30 -1.95 -12.50 15.43 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc -12.83% P/E: 11.43 -2.02 34.56 P/E Ratio Historical High CDN$
-$31.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16.99
-$33.76 $0.00 $0.00 $0.00 $0.00 $16.99
Low Months Jan Feb Jan Oct Feb Oct Dec Apr Oct Dec Dec Feb Jun
AEC
pre split 2005
Price Low pre 09 $32.60 $46.33 $52.08 $43.50 $44.78
Price Low CDN$ $16.80 $23.88 $26.85 $22.42 $23.08 $28.26 $18.56 $17.51 $17.69 $13.53 $6.52 $4.54 $10.72 -80.99% <-Total Growth 10 Stock Price CDN$
Increase 24.1% 42.1% 12.4% -16.5% 2.9% 22.4% -34.3% -5.7% 1.0% -23.5% -51.8% -30.4% 136.12% -15.30% <-IRR #YR-> 10 Stock Price -80.99% CDN$
P/E 7.28 5.88 10.18 4.49 8.86 13.96 106.90 -4.63 51.98 2.55 -0.75 -3.16 11.86 -24.54% <-IRR #YR-> 5 Stock Price -75.54% CDN$
Trailing P/E 7.21 10.35 6.61 8.50 4.63 10.85 9.17 100.85 -4.68 39.75 1.23 -0.52 -7.46 10.18 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc -23.52% P/E: 6.68 -0.75 4.76 P/E Ratio Historical Low CDN$
-$23.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.54
-$18.56 $0.00 $0.00 $0.00 $0.00 $4.54
Price Close US$ pre 09 $45.95 $45.95 $67.96 $46.48
Price Close US$ $45.16 $23.69 $35.03 $23.96 $32.39 $29.12 $18.53 $19.76 $18.05 $13.87 $4.83 $11.74 $12.60 $12.60 $12.60 -50.43% <-Total Growth 10 Stock Price US$
Increase 58.29% -47.55% 47.90% -31.61% 35.19% -10.10% -36.37% 6.64% -8.65% -23.16% -65.18% 143.06% 7.33% 0.00% 0.00% -6.78% <-IRR #YR-> 10 Stock Price -50.43% US$
P/E 22.76 6.80 13.12 5.88 13.06 14.34 109.00 -5.21 56.41 3.03 -0.77 -10.97 17.75 19.69 12.99 -8.72% <-IRR #YR-> 5 Stock Price -36.64% US$
Trailing P/E 23.33 11.94 10.05 8.97 7.94 11.74 9.13 116.24 -4.76 43.34 1.05 -1.87 -11.78 17.75 19.69 -3.57% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 3.21% 2.56% % Tot Ret 0.00% 0.00% Price Inc -8.65% P/E: 9.47 -0.77 -6.16% <-IRR #YR-> 5 Price & Dividend US$
Price H/L Med. US$ $26.32 $20.23 $18.49 $18.11 $9.52 $7.95 $10.90 -57.03% <-Total Growth 5 Stock Price US$
Increase #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -23.16% -8.58% -2.06% -47.46% -16.50% 37.13% #NUM! <-IRR #YR-> 10 Stock Price #DIV/0! US$
P/E 0.00 0.00 0.00 0.00 0.00 0.00 154.82 -5.34 57.78 3.95 -1.52 -7.43 15.35 -21.30% <-IRR #YR-> 5 Stock Price -69.81% US$
Trailing P/E 0.00 0.00 0.00 0.00 0.00 0.00 12.97 118.97 -4.88 56.59 2.08 -1.27 -10.18 #NUM! <-IRR #YR-> 10 Price & Dividend US$
P/E on Running 5 yr Average 0.00 0.00 0.00 0.00 0.00 0.00 154.82 -5.34 57.78 3.95 -1.52 -7.43 15.35 -20.79% <-IRR #YR-> 5 Price & Dividend US$
P/E on Running 10 yr Average 0.00 0.00 0.00 0.00 0.00 0.00 154.82 -5.34 57.78 3.95 -1.52 -7.43 15.35 0.00 P/E Ratio Historical Median US$
Median 10, 5 Yrs D. per yr #NUM! 0.51% % Tot Ret #NUM! -2.44% Price Inc -16.50% P/E: 0.00 -1.52 Count 6 Years of data US$
High Month Apr Oct Mar Jun May Dec Jan
Price High US$ $34.60 $22.66 $20.34 $24.60 $14.36 $12.88 $13.74 -36.68% <-Total Growth 5 Stock Price US$
Increase #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -34.51% -10.24% 20.94% -41.63% -10.31% 6.68% #NUM! <-IRR #YR-> 10 Stock Price #DIV/0! US$
P/E 0.00 0.00 0.00 0.00 0.00 0.00 203.53 -5.98 63.56 5.37 -2.29 -12.04 19.35 -17.93% <-IRR #YR-> 5 Stock Price -62.77% US$
Trailing P/E 0.00 0.00 0.00 0.00 0.00 0.00 17.04 133.29 -5.37 76.88 3.14 -2.05 -12.84 0.00 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 3.14 P/E: 0.00 -2.29 28.65 P/E Ratio Historical High US$
Low Month Dec Apr Jul Dec Dec Feb Jun
Price Low US$ $18.04 $17.79 $16.64 $11.62 $4.67 $3.01 $8.05 -81.91% <-Total Growth 5 Stock Price US$
Increase #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -1.39% -6.46% -30.17% -59.81% -35.55% 167.44% #NUM! <-IRR #YR-> 10 Stock Price #DIV/0! US$
P/E 0.00 0.00 0.00 0.00 0.00 0.00 106.12 -4.69 52.00 2.54 -0.74 -2.81 11.34 -30.10% <-IRR #YR-> 5 Stock Price -83.31% US$
Trailing P/E 0.00 0.00 0.00 0.00 0.00 0.00 8.89 104.65 -4.39 36.31 1.02 -0.48 -7.52 0.00 P/E Ratio Historical Median US$
Median 10, 5 Yrs P/E: 0.00 -0.74 -1.57 P/E Ratio Historical Low US$
Debt US$ $7,340 $5,363 $4,198 $4,197 Debt US$
Change -26.93% -21.72% -0.02% -24.33% <-Median-> 2 Change US$
Debt CDN$ $8,515 $7,426 $5,637 $5,342 Debt CDN$
Change -12.79% -24.10% -5.22% -18.44% <-Median-> 2 Change CDN$
Ratio to Market Cap 0.71 1.24 0.37 0.34 0.71 <-Median-> 3 % of Market Cap CDN$
Goodwill and Intangibles $1,616 $1,725 $1,644 $2,917 $2,790 $2,779 $2,613 Intangibles Goodwill US$
Change 6.75% -4.70% 77.43% -4.35% -0.39% -5.97% -0.39% <-Median-> 5 Change US$
Goodwill and Intangibles $1,650 $1,720 $1,749 $3,384 $3,863 $3,731 $3,326 Intangibles Goodwill CDN$
Change 4.18% 1.69% 93.53% 14.17% -3.42% -10.86% 4.18% <-Median-> 5 Change CDN$
Ratio to Market Cap 0.12 0.12 0.12 0.28 0.65 0.24 0.21 0.18 <-Median-> 6 % of Market Cap CDN$
Market Cap US$ $38,201 $18,425 $26,280 $17,979 $24,335 $21,441 $13,644 $14,549 $13,373 $10,280 $4,105 $11,423 $12,260 $12,260 $12,260 -38.00% <-Total Growth 10 Market Cap US$
Market Cap pre 09 $44,461 $41,742 $50,639 $42,743
Market Cap $22,918 $21,517 $26,102 $22,032 $25,627 $21,419 $13,909 $14,476 $14,210 $11,985 $5,974 $15,334 $15,607 $15,607 $15,607 -28.73% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 741.7 737.2 736.3 737.7 741.0 822.1 882.6 19.00% <-Total Growth 6 Diluted
Change -0.61% -0.12% 0.19% 0.45% 10.94% 7.36% 0.32% <-Median-> 6 Change
Basic # of Shares in Millions 739.7 736.3 736.3 737.7 741.0 822.1 882.6 19.32% <-Total Growth 6 Basic
Change -0.46% 0.00% 0.19% 0.45% 10.94% 7.36% 0.32% <-Median-> 6 Change
Difference -0.5% 0.0% 0.0% 0.4% 0.0% 3.4% 10.2% 0.03% <-Median-> 7 Difference
$880 <-12 mths 40.80%
Reasons sh repur
pre-split 2005
# of Share in Millions 845.9 777.9 750.2 750.4 751.3 736.3 736.3 736.3 740.9 741.2 849.8 973.0 973.0 973.0 973.0 2.26% <-IRR #YR-> 10 Shares 25.08%
Change -6.07% -8.04% -3.56% 0.03% 0.12% -2.00% 0.00% 0.00% 0.62% 0.04% 14.65% 14.50% 0.00% 0.00% 0.00% 5.73% <-IRR #YR-> 5 Shares 32.15%
CF fr Op $M US$ pre 09 $7,430.0 $7,973.0 $8,429.0 $8,855.0
CF fr Op $M US$ $3,829.9 $4,109.8 $4,344.8 $4,564.4 $7,831.0 $2,365.0 $4,043.0 $3,107.0 $2,289.0 $2,667 $1,681 $625 $1,255.2 $1,858.4 $2,344.9 -84.79% <-Total Growth 10 Cash Flow US$
Increase 61.84% 7.31% 5.72% 5.05% 71.57% -69.80% 70.95% -23.15% -26.33% 16.51% -36.97% -62.82% 100.83% 48.06% 26.18% S. Iss, SO Buy Backs DRIP
5 year Running Average $2,030 $2,672 $3,375 $3,843 $4,936 $4,643 $4,630 $4,382 $3,927 $2,894 $2,757 $2,074 $1,703 $1,617 $1,553 -22.39% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $4.53 $5.28 $5.79 $6.08 $10.42 $3.21 $5.49 $4.22 $3.09 $3.60 $1.98 $0.64 $1.29 $1.91 $2.41 -87.84% <-Total Growth 10 Cash Flow per Share US$
Increase 72.30% 16.69% 9.62% 5.03% 71.36% -69.18% 70.95% -23.15% -26.79% 16.47% -45.03% -67.53% 100.83% 48.06% 26.18% -17.17% <-IRR #YR-> 10 Cash Flow -84.79% US$
5 year Running Average $2.44 $3.14 $4.13 $4.86 $6.42 $6.16 $6.20 $5.89 $5.29 $3.92 $3.68 $2.71 $2.12 $1.88 $1.65 -31.16% <-IRR #YR-> 5 Cash Flow -84.54% US$
P/CF on Med Price 4.79 4.79 5.98 5.03 4.81 12.37 8.45 -19.00% <-IRR #YR-> 10 Cash Flow per Share -87.84% US$
P/CF on Closing Price 9.97 4.48 6.05 3.94 3.11 9.07 3.37 4.68 5.84 3.85 2.44 18.28 9.77 6.60 5.23 -34.89% <-IRR #YR-> 5 Cash Flow per Share -88.30% US$
126.58% Diff M/C -1.49% <-IRR #YR-> 10 CFPS 5 yr Running -13.94% US$
Non-Cash pre 09 US$ -$216.0 -$3,343.0 $8.0 $269.0
Excl.Working Capital CF -$111.3 -$1,723.2 $4.1 $138.7 $29.0 $2,074.0 $132.0 $401.0 $259.0 $52.0 -$251.0 $213.0 $0.0 $0.0 $0.0 -15.28% <-IRR #YR-> 5 CFPS 5 yr Running -56.36% US$
CF fr Op $M WC US$ $3,719 $2,387 $4,349 $4,703 $7,860 $4,439 $4,175 $3,508 $2,548 $2,719 $1,430 $838 $1,255 $1,858 $2,345 112.36% <-Total Growth 10 Cash Flow less WC US$
Increase 125.30% -35.82% 82.22% 8.14% 67.12% -43.52% -5.95% -15.98% -27.37% 6.71% -47.41% -41.40% 49.78% 48.06% 26.18% -9.94% <-IRR #YR-> 10 Cash Flow less WC -64.89% US$
5 year Running Average $1,960 $2,258 $2,874 $3,362 $4,603 $4,748 $5,105 $4,937 $4,506 $3,478 $2,876 $2,209 $1,758 $1,620 $1,545 -27.47% <-IRR #YR-> 5 Cash Flow less WC -79.93% US$
CFPS Excl. WC US$ $4.40 $3.07 $5.80 $6.27 $10.46 $6.03 $5.67 $4.76 $3.44 $3.67 $1.68 $0.86 $1.29 $1.91 $2.41 -0.22% <-IRR #YR-> 10 CF less WC 5 Yr Run -2.19% US$
Increase 139.87% -30.21% 88.95% 8.11% 66.92% -42.37% -5.95% -15.98% -27.82% 6.67% -54.13% -48.82% 49.78% 48.06% 26.18% -15.43% <-IRR #YR-> 5 CF less WC 5 Yr Run -56.74% US$
5 year Running Average $2.36 $2.62 $3.51 $4.27 $6.00 $6.32 $6.85 $6.64 $6.07 $4.71 $3.84 $2.88 $2.19 $1.88 $1.63 -11.93% <-IRR #YR-> 10 CFPS - Less WC -71.93% US$
P/CF on Med Price 4.25 5.38 4.94 5.65 9.22 8.45 -31.40% <-IRR #YR-> 5 CFPS - Less WC -84.81% US$
P/CF on Closing Price 10.27 7.72 6.04 3.82 3.10 4.83 3.27 4.15 5.25 3.78 2.87 13.63 9.77 6.60 5.23 0.98% <-IRR #YR-> 10 CFPS 5 yr Running 10.20% US$
CF/-WC P/CF Med 10 yr 4.31 5 yr 4.68 P/CF Med 10 yr 3.99 5 yr 4.15 145.10% Diff M/C -15.88% <-IRR #YR-> 5 CFPS 5 yr Running -57.88% US$
$1,120 <-12 mths 33.48%
CF fr Op $M pre 09 CDN$
CF fr Op $M CDN$ $4,454.2 $4,788.7 $4,293.1 $5,586.9 $8,223.5 $2,357.9 $4,129.2 $3,097.2 $2,434.6 $3,094.0 $2,327.8 $839.2 $1,597.7 $2,365.6 $2,984.9 -82.48% <-Total Growth 10 Cash Flow CDN$
Increase 56.22% 7.51% -10.35% 30.13% 47.19% -71.33% 75.12% -24.99% -21.39% 27.09% -24.77% -63.95% 90.39% 48.06% 26.18% S. Iss, SO Buy Backs DRIP
5 year Running Average $2,584 $3,256 $3,852 $4,395 $5,469 $5,050 $4,918 $4,679 $4,048 $3,023 $3,017 $2,359 $2,059 $2,045 $2,023 -27.56% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $5.27 $6.16 $5.72 $7.45 $10.95 $3.20 $5.61 $4.21 $3.29 $4.17 $2.74 $0.86 $1.64 $2.43 $3.07 -85.99% <-Total Growth 10 Cash Flow per Share CDN$
Increase 66.33% 16.91% -7.04% 30.10% 47.02% -70.74% 75.12% -24.99% -21.88% 27.03% -34.38% -68.51% 90.39% 48.06% 26.18% -15.98% <-IRR #YR-> 10 Cash Flow -82.48% CDN$
5 year Running Average $3.15 $3.82 $4.69 $5.55 $7.11 $6.69 $6.58 $6.28 $5.45 $4.10 $4.00 $3.05 $2.54 $2.37 $2.15 -27.29% <-IRR #YR-> 5 Cash Flow -79.68% CDN$
P/CF on Med Price 5.00 4.51 5.54 4.83 2.59 10.06 4.66 4.91 5.85 4.81 4.40 12.48 8.73 -17.84% <-IRR #YR-> 10 Cash Flow per Share -85.99% CDN$
P/CF on Closing Price 5.15 4.49 6.08 3.94 3.12 9.08 3.37 4.67 5.84 3.87 2.57 18.27 9.77 6.60 5.23 -31.23% <-IRR #YR-> 5 Cash Flow per Share -84.62% CDN$
126.71% Diff M/C -2.20% <-IRR #YR-> 10 CFPS 5 yr Running -19.96% CDN$
Non-Cash pre 09 CDN$
Excl.Working Capital CF -$129.5 -$2,007.9 $4.1 $169.7 $30.5 $2,067.8 $134.8 $399.7 $275.5 $60.3 -$347.6 $286.0 $0.0 $0.0 $0.0 -14.25% <-IRR #YR-> 5 CFPS 5 yr Running -53.63% CDN$
CF fr Op $M WC CDN$ $4,324.7 $2,780.9 $4,297.2 $5,756.6 $8,253.9 $4,425.7 $4,264.1 $3,496.9 $2,710.1 $3,154.3 $1,980.2 $1,125.2 $1,597.7 $2,365.6 $2,984.9 114.24% <-Total Growth 10 Cash Flow less WC CDN$
Increase 117.48% -35.70% 54.53% 33.96% 43.38% -46.38% -3.65% -17.99% -22.50% 16.39% -37.22% -43.18% 42.00% 48.06% 26.18% -8.65% <-IRR #YR-> 10 Cash Flow less WC -59.54% CDN$
5 year Running Average $2,476 $2,806 $3,263 $3,830 $5,083 $5,103 $5,400 $5,239 $4,630 $3,610 $3,121 $2,493 $2,113 $2,045 $2,011 -23.39% <-IRR #YR-> 5 Cash Flow less WC -73.61% CDN$
CFPS Excl. WC CDN$ $5.11 $3.57 $5.73 $7.67 $10.99 $6.01 $5.79 $4.75 $3.66 $4.26 $2.33 $1.16 $1.64 $2.43 $3.07 -1.17% <-IRR #YR-> 10 CF less WC 5 Yr Run -11.13% CDN$
Increase 131.54% -30.08% 60.23% 33.93% 43.21% -45.29% -3.65% -17.99% -22.98% 16.35% -45.25% -50.37% 42.00% 48.06% 26.18% -14.32% <-IRR #YR-> 5 CF less WC 5 Yr Run -53.82% CDN$
5 year Running Average $2.96 $3.23 $3.96 $4.86 $6.61 $6.79 $7.24 $7.04 $6.24 $4.89 $4.16 $3.23 $2.61 $2.36 $2.13 -10.67% <-IRR #YR-> 10 CFPS - Less WC -67.65% CDN$
P/CF on Med Price 5.15 7.77 5.53 4.69 2.59 5.36 4.52 4.35 5.25 4.72 5.17 9.31 8.73 -27.54% <-IRR #YR-> 5 CFPS - Less WC -80.03% CDN$
P/CF on Closing Price 5.30 7.74 6.07 3.83 3.10 4.84 3.26 4.14 5.24 3.80 3.02 13.63 9.77 6.60 5.23 -0.01% <-IRR #YR-> 10 5 yr Running -0.11% CDN$
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 4.31 5 yr 4.67 P/CF Med 10 yr 4.94 5 yr 5.17 97.56% Diff M/C -14.90% <-IRR #YR-> 5 5 yr Running -55.37% CDN$
-29.75% <-IRR #YR-> 5 CFPS - Less WC f ';09 CDN$
-777.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 973.0 Shares
-736.3 0.0 0.0 0.0 0.0 973.0 Shares
-$4,110 $0 $0 $0 $0 $0 $0 $0 $0 $0 $625 Cash Flow US$
-$4,043 $0 $0 $0 $0 $625 Cash Flow US$
-$5.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.64 Cash Flow per Share US$
-$5.49 $0.00 $0.00 $0.00 $0.00 $0.64 Cash Flow per Share US$
-$3.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.71 CFPS 5 yr Running US$
-$6.20 $0.00 $0.00 $0.00 $0.00 $2.71 CFPS 5 yr Running US$
-$2,387 $0 $0 $0 $0 $0 $0 $0 $0 $0 $838 Cash Flow less WC US$
-$4,175 $0 $0 $0 $0 $838 Cash Flow less WC US$
-$2,258 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,209 CF less WC 5 Yr Run US$
-$5,105 $0 $0 $0 $0 $2,209 CF less WC 5 Yr Run US$
-$3.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.86 CFPS - Less WC US$
-$5.67 $0.00 $0.00 $0.00 $0.00 $0.86 CFPS - Less WC US$
-$2.62 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.88 CFPS 5 yr Running US$
-$6.85 $0.00 $0.00 $0.00 $0.00 $2.88 CFPS 5 yr Running US$
-$4,789 $0 $0 $0 $0 $0 $0 $0 $0 $0 $839 Cash Flow CDN$
-$4,129 $0 $0 $0 $0 $839 Cash Flow CDN$
-$6.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.86 Cash Flow per Share CDN$
OPM 52.08% 48.62% 39.27% 29.45% 70.46% 26.66% 47.75% 60.21% 39.01% 33.26% 38.01% 21.42% -55.95% <-Total Growth 10 OPM CDN$
Increase 16.38% -6.65% -19.24% -24.99% 139.22% -62.16% 79.09% 26.10% -35.22% -14.74% 14.30% -43.66% Should increase or be stable. CDN$
Diff from Median 35.2% 26.2% 2.0% -23.5% 83.0% -30.8% 24.0% 56.4% 1.3% -13.6% -1.3% -44.4% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 38.51% 5 Yrs 38.01% should be zero, it is a check on calculations
Current Assets US$ $1,858 $1,908 $2,291 $2,888 $5,795 $2,854 $4,927 $5,477 $4,290 $2,861 $1,607 $1,923 $2,210 Liquidity ratio of 1.5 and up, best Assets US$
Current Liabilities US$ $2,511 $1,903 $3,263 $2,007 $4,245 $2,776 $2,820 $2,612 $2,952 $2,406 $1,333 $1,562 $1,370 1.30 <-Median-> 10 Liabilities US$
Liquidity 0.74 1.00 0.70 1.44 1.37 1.03 1.75 2.10 1.45 1.19 1.21 1.23 1.61 1.23 <-Median-> 5 Ratio US$
Liq. with CF aft div 2.21 3.08 1.94 3.40 3.07 1.67 2.97 3.06 2.06 2.21 2.29 1.59 2.49 US$
Liq. CF re Inv+Div 1.15 1.61 0.85 1.16 1.44 0.62 1.28 3.06 1.25 0.75 1.53 1.56 2.49
Assets US$ $17,602 $18,096 $24,213 $24,354 $33,827 $34,020 $33,918 $18,700 $17,648 $24,621 $15,644 $14,653 $15,164 Debt Ratio of 1.5 and up, best US$
Liabilities US$ $9,351 $9,093 $13,541 $12,512 $17,213 $16,693 $17,594 $13,405 $12,501 $14,936 $9,477 $8,527 $8,199 1.75 <-Median-> 10 Ratio US$
Debt Ratio 1.88 1.99 1.79 1.95 1.97 2.04 1.93 1.40 1.41 1.65 1.65 1.72 1.85 1.65 <-Median-> 5 Ratio US$
Book Value US$ $8,251 $9,003 $10,672 $11,842 $16,614 $17,327 $16,324 $5,295 $5,147 $9,685 $6,167 $6,126 $6,965 US$
Book Value US$ $8,251 $9,003 $10,672 $11,842 $16,614 $17,327 $16,324 $5,295 $5,147 $9,685 $6,167 $6,126 $6,965 $6,965 $6,965 -31.96% <-Total Growth 10 Book Value US$
Book Value per Share $9.75 $11.57 $14.23 $15.78 $22.11 $23.53 $22.17 $7.19 $6.95 $13.07 $7.26 $6.30 $7.16 $7.16 $7.16 -45.60% <-Total Growth 10 Book Value per Share US$
Change 19.11% 18.65% 22.92% 10.93% 40.13% 6.42% -5.79% -67.56% -3.40% 88.09% -44.46% -13.24% 13.70% 0.00% 0.00% 27.00% P/B Ratio Current/Historical Median US$
P/B Ratio (Median) 2.81 2.66 1.39 1.31 1.26 1.52 1.39 P/B Ratio Historical Median US$
P/B Ratio (Close) 4.63 2.05 2.46 1.52 1.46 1.24 0.84 2.75 2.60 1.06 0.67 1.86 1.76 1.76 1.76 -5.91% <-IRR #YR-> 10 Book Value per Share US$
Change 32.89% -55.80% 20.33% -38.35% -3.52% -15.52% -32.46% 228.75% -5.44% -59.15% -37.30% 180.17% -5.60% 0.00% 0.00% -22.26% <-IRR #YR-> 5 Book Value per Share US$
Leverage (A/BK) 2.13 2.01 2.27 2.06 2.04 1.96 2.08 3.53 3.43 2.54 2.54 2.39 2.18 2.54 <-Median-> 5 A/BV US$
Debt/Equity Ratio 1.13 1.01 1.27 1.06 1.04 0.96 1.08 2.53 2.43 1.54 1.54 1.39 1.18 1.54 <-Median-> 5 Debt/Eq Ratio US$
Shareholders' Equity (Assets less Liabilities) P/BV 10 yr Med 1.39 5 yr Med 1.39 27.00% Diff M/C 2.23 Historical Leverage (A/BK) US$
Curremt Assets CDN$ $2,160.5 $2,223 $2,263 $3,534 $6,085 $2,845 $5,032 $5,460 $4,563 $3,319 $2,225 $2,582 $2,813 Liquidity ratio of 1.5 and up, best CDN$
Current Liabilities CDN$ $2,920.1 $2,217 $3,224 $2,457 $4,458 $2,768 $2,880 $2,604 $3,140 $2,791 $1,846 $2,097 $1,744 1.30 <-Median-> 10 Ratio CDN$
Liquidity 0.74 1.00 0.70 1.44 1.37 1.03 1.75 2.10 1.45 1.19 1.21 1.23 1.61 1.23 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.21 3.08 1.94 3.40 3.07 1.67 2.97 3.06 2.06 2.21 2.29 1.59 2.49 2.21 <-Median-> 5 Ratio CDN$
Liq. CF re Inv+Div 1.15 1.61 0.85 1.16 1.44 0.62 1.28 3.06 1.25 0.75 1.53 1.56 2.49 1.53 <-Median-> 5 Ratio CDN$
Assets CDN$ $20,471 $21,085 $23,925 $29,809 $35,522 $33,918 $34,641 $18,641 $18,770 $28,563 $21,663 $19,675 $19,302 Debt Ratio of 1.5 and up, best CDN$
Increase 5.6% 3.0% 13.5% 24.6% 19.2% -4.5% 2.1% -46.2% 0.7% 52.2% -24.2% -9.2% -1.9% CDN$
Liabilities CDN$ $10,875 $10,595 $13,380 $15,315 $18,076 $16,643 $17,969 $13,363 $13,296 $17,327 $13,123 $11,449 $10,437 1.75 <-Median-> 10 Ratio CDN$
Debt Ratio 1.88 1.99 1.79 1.95 1.97 2.04 1.93 1.40 1.41 1.65 1.65 1.72 1.85 1.65 <-Median-> 5 Ratio CDN$
BV US$ to CDN$ ck $9,596 $10,490 $10,545 $14,495 $17,447 $17,275 $16,672 $5,278 $5,474 $11,236 $8,540 $8,225 $8,866 CDN$
BV Check $9,596 $10,490 $10,545 $14,495 $17,447 $17,275 $16,672 $5,278 $5,474 $11,236 $8,540 $8,225 $8,866
Book Value CDN$ $9,596 $10,490 $10,545 $14,495 $17,447 $17,275 $16,672 $5,278 $5,474 $11,236 $8,540 $8,225 $8,866 $8,866 $8,866 -21.59% <-Total Growth 10 Book Value CDN$
Book Value per Share $11.34 $13.49 $14.06 $19.32 $23.22 $23.46 $22.64 $7.17 $7.39 $15.16 $10.05 $8.45 $9.11 $9.11 $9.11 -37.31% <-Total Growth 10 Book Value per Share CDN$
Change 14.98% 18.88% 4.23% 37.42% 20.22% 1.03% -3.49% -68.34% 3.07% 105.16% -33.71% -15.88% 7.79% 0.00% 0.00% 16.30% P/B Ratio Current/Historical Median CDN$
P/B Ratio (Median) 2.32 2.06 2.25 1.86 1.22 1.37 1.16 2.88 2.60 1.33 1.20 1.27 1.57 1.51 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 2.39 2.05 2.48 1.52 1.47 1.24 0.83 2.74 2.60 1.07 0.70 1.86 1.76 1.76 1.76 -4.56% <-IRR #YR-> 10 Book Value CDN$
Change 33.67% -14.12% 20.68% -38.59% -3.36% -15.59% -32.72% 228.74% -5.35% -58.91% -34.42% 166.49% -5.57% 0.00% 0.00% -17.89% <-IRR #YR-> 5 Book Value CDN$
Leverage (A/BK) 2.13 2.01 2.27 2.06 2.04 1.96 2.08 3.53 3.43 2.54 2.54 2.39 2.18 2.33 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.13 1.01 1.27 1.06 1.04 0.96 1.08 2.53 2.43 1.54 1.54 1.39 1.18 1.33 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.35 5 yr Med 1.33 30.48% Diff M/C 2.28 Historical Leverage (A/BK) CDN$
$602 <-12 mths 153.56%
Comprehensive Income US$ $3,431 -$4,464 -$1,124 Comprehensive Income US$ US$
Non Controlling Interest NCI $34.00 $0.00 $0.00 NCI US$
Comprehensive Income US$ $1,888 $2,972 $2,911 $1,914 $3,880 $1,795 $73 -$2,700 $250 $3,397 -$4,464 -$1,124 -137.82% <-Total Growth 10 Comprehensive Income US$
Increase 57.43% -2.05% -34.23% 102.67% -53.74% -95.93% -3798.63% 109.26% 1258.80% -231.41% 74.82% 74.8% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $2,713 $2,694 $2,115 $992 $660 $563 -$689 -$928 #NUM! <-IRR #YR-> 10 Comprehensive Income -137.82% US$
ROE 22.9% 33.0% 27.3% 16.2% 23.4% 10.4% 0.4% -51.0% 4.9% 35.1% -72.4% -18.3% #NUM! <-IRR #YR-> 5 Comprehensive Income -1639.73% US$
5Yr Median 23.4% 23.4% 16.2% 10.4% 4.9% 4.9% 0.4% -18.3% #NUM! <-IRR #YR-> 7 5 Yr Running Average #DIV/0! US$
% Difference from NI 6.9% 2.0% 42.6% -37.5% 108.4% 19.7% -43.0% -3.4% 5.9% 0.1% -13.6% 19.1% #NUM! <-IRR #YR-> 5 5 Yr Running Average -143.89% US$
Median Values Diff 5, 10 yr 3.0% 0.1% -18.3% <-Median-> 5 Return on Equity US$
Current Liability Coverage Ratio US$ 1.48 1.25 1.33 2.34 1.85 1.60 1.48 1.34 0.86 1.13 1.07 0.54 CFO / Current Liabilities US$
5 year Median 1.25 1.33 1.33 1.48 1.60 1.60 1.60 1.48 1.34 1.13 1.07 1.07 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 21.13% 13.19% 17.96% 19.31% 23.24% 13.05% 12.31% 18.76% 14.44% 11.04% 9.14% 5.72% CFO / Total Assets US$
5 year Median 18.22% 13.19% 17.96% 17.96% 19.31% 17.96% 17.96% 18.76% 14.44% 13.05% 12.31% 11.04% 11.0% <-Median-> 5 Return on Assets US$
Return on Assets ROA US$ 10.0% 16.1% 8.4% 12.6% 5.5% 4.4% 0.4% -14.9% 1.3% 13.8% -33.0% -6.4% Net Income/Assets Return on Assets US$
5Yr Median 9.8% 9.8% 9.8% 10.0% 10.0% 8.4% 5.5% 4.4% 1.3% 1.3% 0.4% -6.4% -6.4% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ 21.4% 32.4% 19.1% 25.9% 11.2% 8.7% 0.8% -52.8% 4.6% 35.0% -83.8% -15.4% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 20.9% 20.9% 20.9% 21.4% 21.4% 19.1% 11.2% 8.7% 4.6% 4.6% 0.8% -15.4% -15.4% <-Median-> 5 Return on Equity US$
$775 <-12 mths 182.10%
Net Income US$ $3,426 -$5,165 -$944 Net Income US$ US$
NCI $34 $0 $0 NCI US$
Net Income US$ $1,766 $2,913 $2,041 $3,064 $1,862 $1,499 $128 -$2,794 $236 $3,392 -$5,165 -$944 $527 $634 $899 -132.40% <-Total Growth 10 Net Income US$
Increase 19.41% 64.97% -29.95% 50.14% -39.23% -19.50% -91.46% -2282.81% 108.45% 1337.29% -252.27% 81.72% 155.83% 20.30% 41.80% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $1,049 $1,559 $1,883 $2,253 $2,329 $2,276 $1,719 $752 $186 $492 -$841 -$1,055 -$950 -$264 -$131 #NUM! <-IRR #YR-> 10 Net Income -132.40% US$
Operating Cash Flow US$ $3,830 $4,110 $4,345 $4,564 $7,831 $2,365 $4,043 $3,107 $2,289 $2,667 $1,681 $625 #NUM! <-IRR #YR-> 5 Net Income -837.50% US$
Investing Cash Flow US$ -$2,330 -$1,743 -$4,214 -$3,893 -$4,805 -$4,729 -$3,725 $361 -$1,895 -$4,729 -$665 -$29 #NUM! <-IRR #YR-> 10 5 Yr Running Average -167.69% US$
Total Accruals $266 $547 $1,910 $2,393 -$1,164 $3,863 -$190 -$6,262 -$158 $5,454 -$6,181 -$1,540 #NUM! <-IRR #YR-> 5 5 Yr Running Average -161.38% US$
Total Assets $17,602 $18,096 $24,213 $24,354 $33,827 $34,020 $33,918 $18,700 $17,648 $24,621 $15,644 $14,653 Balance Sheet Assets US$
Accruals Ratio 1.51% 3.02% 7.89% 9.82% -3.44% 11.36% -0.56% -33.49% -0.90% 22.15% -39.51% -10.51% -10.51% <-Median-> 5 Ratio US$
EPS/CF Ratio 0.45 1.14 0.46 0.65 0.24 0.34 0.03 -0.80 0.09 1.25 -3.73 -1.24 0.17 <-Median-> 10 EPS/CF Ratio US$
Financial Cash Flow US$ -$1,751 -$2,213 -$61 -$742 $835 -$1,284 -$214 -$1,111 -$909 -$39 -$1,054 -$38 C F Statement Financial Cash Flow US$
Total Accruals $2,016 $2,760 $1,971 $3,135 -$1,999 $5,147 $24 -$5,151 $751 $5,493 -$5,127 -$1,502 Accruals US$
Accruals Ratio 11.46% 15.25% 8.14% 12.87% -5.91% 15.13% 0.07% -27.55% 4.26% 22.31% -32.77% -10.25% Ratio US$
766 <-12 mths 150.77%
Comprehensive Income CDN$ $2,195 $3,463 $2,876 $2,343 $4,074 $1,790 $75 -$2,691 $266 $3,941 -$6,181 -$1,509 -143.59% <-Total Growth 10 Comprehensive Inc. CDN$
Increase 57.73% -16.93% -18.53% 73.88% -56.08% -95.83% -3709.91% 109.88% 1382.08% -256.86% 75.59% 75.6% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $2,990 $2,909 $2,232 $1,118 $703 $676 -$918 -$1,235 #NUM! <-IRR #YR-> 10 Comprehensive Inc. -143.59% CDN$
ROE 16.2% 23.4% 10.4% 0.4% -51.0% 4.9% 35.1% -72.4% -18.3% #NUM! <-IRR #YR-> 5 Comprehensive Inc. -2124.21% CDN$
5Yr Median 13.3% 10.4% 4.9% 4.9% 0.4% -18.3% #NUM! <-IRR #YR-> 5 5 Yr Running Average #DIV/0! CDN$
% Difference from NI -37.5% 108.4% 19.7% -43.0% -3.4% 5.9% 0.1% -13.6% 19.1% #NUM! <-IRR #YR-> 5 5 Yr Running Average -155.34% CDN$
Median Values Diff 5, 10 yr 0.1% 0.1% -18.3% <-Median-> 5 Return on Equity CDN$
Current Liability Coverage Ratio CDN$ 1.48 1.25 1.33 2.34 1.85 1.60 1.48 1.34 0.86 1.13 1.07 0.54 CFO / Current Liabilities CDN$
5 year Median 1.34 1.25 1.33 1.33 1.48 1.60 1.60 1.60 1.48 1.34 1.13 1.07 1.07 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 21.13% 13.19% 17.96% 19.31% 23.24% 13.05% 12.31% 18.76% 14.44% 11.04% 9.14% 5.72% CFO / Total Assets CDN$
5 year Median 18.22% 13.19% 17.96% 17.96% 19.31% 17.96% 17.96% 18.76% 14.44% 13.05% 12.31% 11.04% 11.0% <-Median-> 5 Return on Assets CDN$
Return on Assets ROA CDN$ 10.0% 16.1% 8.4% 12.6% 5.5% 4.4% 0.4% -14.9% 1.3% 13.8% -33.0% -6.4% Net Income/Assets Return on Assets CDN$
5Yr Median 9.2% 9.8% 9.8% 10.0% 10.0% 8.4% 5.5% 4.4% 1.3% 1.3% 0.4% -6.4% -6.4% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 21.4% 32.4% 19.1% 25.9% 11.2% 8.7% 0.8% -52.8% 4.6% 35.0% -83.8% -15.4% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 20.9% 20.9% 20.9% 21.4% 21.4% 19.1% 11.2% 8.7% 4.6% 4.6% 0.8% -15.4% -15.4% <-Median-> 5 Return on Equity CDN$
986 <-12 mths 177.83%
Net Income CDN$ 2,054 3,395 2,016 3,750 1,955 1,495 131 -2,785 251 3,935 -7,152 -1,268 671 807 1,144 -137.34% <-Total Growth 10 Net Income CDN$
Increase 15.27% 65.29% -40.60% 85.98% -47.86% -23.57% -91.25% -2230.45% 109.01% 1467.69% -281.76% 82.28% 152.92% 20.30% 41.80% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $1,302 $1,893 $2,164 $2,599 $2,634 $2,522 $1,869 $909 $209 $605 -$1,124 -$1,404 -$713 -$601 -$1,160 #NUM! <-IRR #YR-> 10 Net Income -137.34% CDN$
Operating Cash Flow CDN$ $4,454 $4,789 $4,293 $5,587 $8,223 $2,358 $4,129 $3,097 $2,435 $3,094 $2,328 $839 #NUM! <-IRR #YR-> 5 Net Income -1069.56% CDN$
Investing Cash Flow CDN$ -2,710 -2,031 -4,164 -4,765 -5,046 -4,715 -3,804 360 -2,016 -5,486 -921 -39 #NUM! <-IRR #YR-> 10 5 Yr Running Ave. -174.17% CDN$
Total Accruals $309 $637 $1,887 $2,929 -$1,222 $3,851 -$194 -$6,242 -$168 $6,327 -$8,559 -$2,068 #NUM! <-IRR #YR-> 5 5 Yr Running Ave. -175.09% CDN$
Total Assets $20,471 $21,085 $23,925 $29,809 $35,522 $33,918 $34,641 $18,641 $18,770 $28,563 $21,663 $19,675 Balance Sheet Assets CDN$
Accruals Ratio 1.51% 3.02% 7.89% 9.82% -3.44% 11.36% -0.56% -33.49% -0.90% 22.15% -39.51% -10.51% -10.51% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.45 1.14 0.46 0.65 0.24 0.34 0.03 -0.80 0.09 1.25 -3.73 -1.24 0.17 <-Median-> 10 EPS/CF Ratio CDN$
Chge In Close CDN$ 53.68% 2.09% 25.79% -15.61% 16.18% -14.72% -35.06% 4.08% -2.44% -15.69% -56.52% 124.18% 1.78% 0.00% 0.00% Count 22 Years of data
Accruals Ratio Is? down down down down up down up up Count 15 68.18%
Predictive? Yes Yes Yes yes yes Count 7 46.67% 68.44%
Financial Cash Flow CDN$ -$2,036 -$2,579 -$61 -$908 $877 -$1,280 -$219 -$1,107 -$967 -$45 -$1,460 -$51 C F Statement Financial CF CDN$
Total Accruals $2,345 $3,216 $1,948 $3,837 -$2,099 $5,132 $25 -$5,135 $799 $6,372 -$7,100 -$2,017 Accruals CDN$
Accruals Ratio 11.46% 15.25% 8.14% 12.87% -5.91% 15.13% 0.07% -27.55% 4.26% 22.31% -32.77% -10.25% -10.25% <-Median-> 5 Ratio CDN$
Accruals Ratio Is? down down down down down up up down down count 13 59.09%
Predictive? Yes yes yes % right count 4 30.77%
Cash US$ $629 $732 $3,179 $2,566 $338 $271 $834 $889 Cash US$
Cash CDN$ $627 $748 $3,169 $2,729 $392 $375 $1,120 $1,132 Cash CDN$
Cash Per Share $0.85 $1.02 $4.30 $3.68 $0.53 $0.44 $1.15 $1.16 $1.15 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 2.93% 5.38% 21.89% 19.21% 3.27% 6.28% 7.30% 7.25% 7.30% <-Median-> 5 % of Stock Price CDN$
Note: should review fin rep and spreadsheet as 2001 (02?) does not match up.
Notes
November 7, 2017. Last estimates were for 2016, 2017 and 2018 of $3254M, $3575M and $4757M for Revenue US$, -$0.98, $0.30 and $0.96 EPS US$, $0.86, $1.34 and $2.07 for CFPS US$, -$766M, $270M and $842M for Net Income U$.
November 12 2016. Last estimates were for 2015, 2016 and 2017 of $4671M, $4793M and $5780M for Revenue US$, -$4.31, $0.14 and $0.91 for EPS US$, $1.80, $1.61 and $2.22 CPFS US$, -$3744M, -$8.97M and $632M for Net Income US$.
November 15, 2015. Last estimates were for 2014, 2015 and 2016 of $6955M, $7610M and 8059M US$ for Revenue, $2.12, $2.10 and 2.15 EPS US$, CFPS of $4.32, $4.70 and 5.76 US$, $1044M, $1586M and $1846M US$ for Net Income US$.
November 14, 2014. Last estimates were for 2013, 2014 and 2015 of $5946M, $6246M and $3721M US$, $1.04, $1.00 and $1.44 EPS US$, $3.33, $3.55 and $4.35 for CFPS US$
Nov 24, 2013. Last estimates were for 2012 and 2013 of $5520M and $6232M US$ for Revenue and $1.21 and $0.75 US$ EPS and $4.85 and $3.77 CFPS US$
Nov 21, 2012. Last estimates were for 2011 and 2012 at $7273M and $7959M for revenue, $0.51 and $0.82 for EPS and $5.36 and $5.83 for CF in US$.
October 9, 2011. Last I looked I got estimates for 2010 and 2011 of $1.22US$ and $1.44US$ for earnings and $6.00 US$ and $6.05 US$ for CF
Different sites (TD, G&M ) say that EnCana made only $.90 in EPS in 2010, but the annual statements clearly show $2.03.
October 2010. NOTE: for changes in 2009, I did not adjust ROE lines to the end of the spreadsheet. ROE is simply net income over book value so it is a relative value. I was not looking for increase in net income
over a period of time. I put the original ECA spreadsheet into Old_Research_portfolio file. (Note I had originally set split for this co. at 1.88 not 1.94, fixed Nov 2010.)
I was reading the split and the company looked at it as a 50/50 split, but the market not quite so simple. However, I am dealing with the split as 50/50.
Oct 10, 2010. When I last looked at this company, I got 2009 and 2010 estimates of $3.80 and $3.00 for earnings and $10 and $9 for CF in US$.
Year 2009. This company split into two companies in the later part of 2009. A a special resolution was approved on the Arrangement to divide the Corporation into two highly focused and independent, publicly traded companies - Encana Corporation and Cenovus Energy Inc.
Om 2009, on November 30, stock worth $56.57. On Dec 2nd, shares worth $56.43. On Dec 3rd, worth 28.81. Stock did not fall until Dec 3rd.
May 13, 2008, since I last looked at this stock, the CDN US currency gap as narrowed. This shows up in the dividend being lower in CDN$.
Apr 11 2009 AR 2008
AP 2007. It has of course done very well as it is in Oil. I have done well and will do so while oil is high.
AP 2006. TD still rates this a buy. I have done well with this stock, but lets face it, I only have 100 shares so it is not going to affect much.
AP 2005. TD Newcrest is still rating this a buy. I have very little into resources. Good to hold for now.
I think I can make money on this stock. They can make a profit.
Called Alberta Energy Co. - to 2001 48.49%
$32.73 $26.00 $58.73 55.73% Encana 1.79 Cenovus 2.26
Split, value of shares $2,360 $2,222 $4,582 51.51% Encana 1.94 Cenovus 2.06
bacically halfed all values and kept shares same value. This should make spreadsheet correct for past values.
751.3 $56.43 $42,396
Sector
Energy
Would I buy this company and Why.
What should this stock accomplish?
Dividends
Dividends are paid in Cycle 3, which is March, June, September and December. Payment for shareholders of record dated December 13, 2013 is payable on December 31, 2013.
Date on most sites show 3 business days before December 13, 2013 date.
Why am I following this stock.
I have owned this stock before as Alberta Energy Co.
Why I bought & sold this stock.
I do not own this stock of EnCana Corp but I used to. I had held this stock previously as Alberta Energy Company from April 2000 until August 2002 and made some 18% total returns per year.
I had EnCana Corp from February 2006 to November 2009 and made a 9.54% per year total return. I sold this stock in 2009 because I only had 100 shares and the stock was going to split into two companies.
I would have ended up with small investment in two companies.
As you can see I do not look on oil companies as a long term buy. Also, please note that my spreadsheet following this company starts with Alberta Energy Company and follows this company into the formation of EnCana in 2002.
It was in 2002 EnCana was formed with the merger of AEC and PanCanadian Energy Corporation. Company split into EnCana Corp and Cenovus Energy Inc. in 2009, Oil with Cenovus and gas with EnCana.
How they make their money
Encana Corporation is an energy producer that is focused on developing its multi-basin portfolio of natural gas, oil and natural gas liquids (NGLs) producing plays. The Company's operations also include the marketing of natural gas, oil and NGLs.
The Company's operations also include the marketing of natural gas, oil and NGLs.
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 Nov 29 2012 Nov 24 2013 Nov 14 2014 Nov 15 2015 Nov 12 2016 Nov 7 2017
Suttles, Douglas James 0.000 0.00% 0.003 0.00% 0.024 0.00% 0.069 0.01% 0.089 0.01%
CEO - Shares - Amount $0.000 $0.044 $0.166 $1.091 $1.433
Options - percentage 1.865 0.25% 2.446 0.33% 3.494 0.41% 6.623 0.68% 6.301 0.65%
Options - amount $35.768 $39.553 $24.559 $104.383 $101.075
Salary 2012 - Total 6.310
Options - percentage 2.976 0.40%
Options - amount $58.509
Brillon, Sherri 0.053 0.01% 0.061 0.01% 0.064 0.01% 0.069 0.01% 0.095 0.01% 0.108 0.01%
CFO - Shares - Amount $1.038 $1.167 $1.033 $0.486 $1.500 $1.740
Options - percentage 0.617 0.08% 0.691 0.09% 0.754 0.10% 0.939 0.11% 1.480 0.15% 1.604 0.16%
Options - amount $12.130 $13.256 $12.199 $6.604 $23.332 $25.728
Hill, David Glen 0.007 0.00% 0.025 0.00% 0.026 0.00% 0.031 0.00%
Officer - Shares - Amount $0.119 $0.176 $0.411 $0.500
Options - percentage 0.254 0.03% 0.483 0.06% 0.986 0.10% 1.071 0.11%
Options - amount $4.106 $3.396 $15.533 $17.183
Options - percentage 0.304 0.04% 0.388 0.05%
Options - amount $5.986 $7.434
Options - percentage 0.310 0.04% 0.306 0.04% 0.418 0.05%
Options - amount $6.087 $4.954 $2.939
Dea, Peter A 0.000 0.00% 0.000 0.00% 0.000 0.00%
Director - Shares - Amount $0.001 $0.002 $0.002
Options - percentage 0.064 0.01% 0.074 0.01% 0.093 0.01%
Options - amount $0.447 $1.168 $1.491
Options - percentage 0.138 0.02%
Options - amount $2.717
Woitas, Clayton 0.103 0.01% 0.163 0.02% 0.263 0.03% 0.289 0.03%
Chairman - Shares - Amt $1.660 $1.144 $4.140 $4.642
Options - percentage 0.074 0.01% 0.095 0.01% 0.114 0.01% 0.147 0.02%
Options - amount $1.202 $0.667 $1.796 $2.366
Institutions/Holdings 431 0.00% 382 0.00% 0 0.00% 347 57.60% 347 68.49%
Total Shares Held 475.9 64.23% 460.491 62.15% 0.000 0.00% 560.452 57.60% 666.463 68.50%
Increase/Decrease 11.4 2.34% 22.052 5.03% 0.000 #DIV/0! 8.464 1.53% -2.320 -0.35%
Starting No. of Shares 487.3 NASDAQ 438.439 NASDAQ 0.000 551.988 NASDAQ 668.783 NASDAQ
Increase in O/S Shares 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% no stock options 2015
due to SO $0.000 $0.000 $0.000 $0.000 to 2017
Book Value $0.000 $0.000 $0.000 $0.000
Insider Buying -$2.013 -$1.309 -$2.546 US$
Insider Selling $0.000 $0.000 $2.037 Yes 0 selling
Net Insider Selling -$0.569 -$2.013 -$1.309 -$0.509
% of Market Cap -0.004% -0.03% -0.03% -0.01%
Directors 10 9 11 11 10
Women 3 30% 2 22% 3 27% 3 27% 2 20%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Copyright 2008 Website of SPBrunner. All rights reserved.
My stock