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/
Canadian Natural Resources TSX CNQ NYSE CNQ www.cnrl.com Fiscal Yr: Dec 31
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
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Split Dates 5/20/05 5/21/10
Split 2 2 Split
$17,501 <-12 mths -7.22%
Revenue less Royalities $9,764 $10,398 $11,152 $14,156 $10,142 $12,901 $13,792 $14,589 $16,145 $18,863 $12,363 $10,523 $16,520 $20,728 $21,785 1.20% <-Total Growth 10 Revenue less Royalities
Increase 34.53% 6.49% 7.25% 26.94% -28.36% 27.20% 6.91% 5.78% 10.67% 16.83% -34.46% -14.88% 56.99% 25.47% 5.10% 7.08% <-Median-> 10 Increase
Royalities $1,366 $1,245 $1,391 $2,017 $936 $1,421 $1,715 $1,606 $1,800 $2,438 $804 $575 $1,487 $1,866 $1,961 -53.82% <-Total Growth 10 Royalities
% Roylities to Rev less Royalities 13.99% 11.97% 12.47% 14.25% 9.23% 11.01% 12.43% 11.01% 11.15% 12.92% 6.50% 5.46% 9.00% 9.00% 9.00% 11.08% <-Median-> 10 % Roylities to Rev less Royalities
Revenue* $11,130 $11,643 $12,543 $16,173 $11,078 $14,322 $15,507 $16,195 $17,945 $21,301 $13,167 $11,098 $18,007 $22,594 $23,746 -4.68% <-Total Growth 10 Revenue
Increase 47.48% 4.61% 7.73% 28.94% -31.50% 29.28% 8.27% 4.44% 10.81% 18.70% -38.19% -15.71% 62.25% 25.47% 5.10% -0.48% <-IRR #YR-> 10 Revenue -4.68%
5 year Running Average $6,501 $8,112 $9,804 $11,807 $12,513 $13,152 $13,925 $14,655 $15,009 $17,054 $16,823 $15,941 $16,304 $17,233 $17,722 -6.47% <-IRR #YR-> 5 Revenue -28.43%
Revenue per Share $10.38 $10.82 $11.62 $14.95 $10.21 $13.13 $14.14 $14.83 $16.50 $19.51 $12.03 $9.99 $16.21 $20.34 $21.37 6.99% <-IRR #YR-> 10 5 yr Running Average 96.52%
Increase 47.48% 4.31% 7.37% 28.64% -31.67% 28.55% 7.72% 4.86% 11.29% 18.21% -38.35% -16.95% 62.25% 25.47% 5.10% 2.74% <-IRR #YR-> 5 5 yr Running Average 14.48%
5 year Running Average $6.14 $7.56 $9.12 $10.96 $11.60 $12.15 $12.81 $13.45 $13.76 $15.62 $15.40 $14.57 $14.85 $15.61 $15.99 -0.80% <-IRR #YR-> 10 Revenue per Share -7.70%
P/S (Price/Sales) Med 2.03 2.75 2.82 2.49 2.82 2.96 2.78 2.24 1.96 2.08 2.81 3.44 2.56 0.00 0.00 -6.72% <-IRR #YR-> 5 Revenue per Share -29.37%
P/S (Price/Sales) Close 2.80 2.87 3.12 1.63 3.72 3.38 2.70 1.93 2.18 1.84 2.51 4.28 2.74 2.18 2.07 6.78% <-IRR #YR-> 10 5 yr Running Average 92.74%
*Product sales before Royalties in M CDN $ P/S Med 10 yr 2.80 5 yr 2.24 -2.13% Diff M/C 2.61% <-IRR #YR-> 5 5 yr Running Average 13.75%
-$11,643 $0 $0 $0 $0 $0 $0 $0 $0 $0 $11,098
-$15,507 $0 $0 $0 $0 $11,098
-$8,112 $0 $0 $0 $0 $0 $0 $0 $0 $0 $15,941
-$13,925 $0 $0 $0 $0 $15,941
-$10.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.99
-$14.14 $0.00 $0.00 $0.00 $0.00 $9.99
$2.21 <-12 mths -6.76%
Adjusted EPS Basic $3.79 $3.10 $4.46 $3.23 $2.48 $2.36 $2.32 $1.48 $2.24 $3.49 $0.24 -$0.61 -119.68% <-Total Growth 10 EPS Basic
Adjusted EPS Diluted $3.78 $3.10 $4.46 $3.23 $2.48 $2.36 $2.30 $1.47 $2.23 $3.47 $0.24 -$0.61 $1.66 $2.79 $3.29 -119.68% <-Total Growth 10 EPS Diluted
Increase 45.38% -17.99% 43.87% -27.58% -23.22% -4.84% -2.54% -36.09% 51.70% 55.61% -93.08% -354.17% 372.13% 68.07% 17.92% #NUM! <-IRR #YR-> 10 Earnings per Share -119.68%
Earnings Yield 13.0% 10.0% 12.3% 13.3% 6.5% 5.3% 6.0% 5.1% 6.2% 9.7% 0.8% -1.4% 3.7% 6.3% 7.4% #NUM! <-IRR #YR-> 5 Earnings per Share -126.52%
5 year Running Average $3.15 $3.43 $3.41 $3.13 $2.97 $2.37 $2.17 $2.37 $1.94 $1.36 $1.40 $1.51 $1.47 -12.31% <-IRR #YR-> 7 5 yr Running Average #DIV/0!
Payout Ratio 3.0% 4.6% 3.7% 6.0% 8.4% 11.8% 15.0% 27.6% 21.5% 25.2% 381.3% -150.8% 64.8% 39.4% 33.4% -14.44% <-IRR #YR-> 5 5 yr Running Average -54.15%
5 year Running Average 3.72% 4.12% 4.81% 6.30% 8.01% 12.06% 15.82% 20.14% 31.10% 52.87% 61.02% 64.70% 69.34% 10.03% <-Median-> 10 Payout 5 yr Running Average
P/E Ratio Median H/L 5.58 9.62 7.36 11.53 11.59 16.45 17.09 22.56 14.50 11.68 140.98 -56.35 25.04 0.00 0.00 13.09 <-Median-> 10 P/E Ratio Median H/L
P/E Ratio High 7.94 11.50 8.81 16.98 15.82 18.94 21.61 27.54 16.12 14.18 175.00 -75.16 27.36 0.00 0.00 16.55 <-Median-> 10 P/E Ratio High
P/E Ratio Low 3.22 7.73 5.91 6.09 7.37 13.97 12.57 17.58 12.89 9.18 106.96 -37.54 22.73 0.00 0.00 10.87 <-Median-> 10 P/E Ratio Low
P/E Ratio Close 7.70 10.02 8.14 7.55 15.32 18.79 16.59 19.48 16.12 10.35 125.92 -70.15 26.72 15.90 13.48 15.72 <-Median-> 10 P/E Ratio Close
Trailing P/AE' Close 3.39 9.39 6.97 11.24 9.83 16.10 19.28 25.95 12.84 10.36 149.67 -49.54 25.78 15.90 13.48 12.04 <-Median-> 10 Trailing P/AE' Close
5 Year Median Values DPR 10 Yrs 13.38% 5 Yrs 25.22% P/CF 5 Yrs in order 14.50 16.12 12.89 16.12 84.23% Diff M/C 104.11% Diff M/C 10
Adjusted net earnings from operations
$2.78 <-12 mths -22.35%
EPS Basic $0.98 $2.35 $2.42 $4.61 $1.46 $1.56 $2.41 $1.72 $2.08 $3.60 -$0.58 -$0.19 -108.09% <-Total Growth 10 EPS Basic
EPS Diluted* $0.98 $2.35 $2.42 $4.61 $1.46 $1.56 $2.40 $1.72 $2.08 $3.58 -$0.58 -$0.19 $1.49 $2.59 $3.27 -108.09% <-Total Growth 10 EPS Diluted
Increase -25.00% 141.03% 2.98% 90.50% -68.33% 6.85% 53.85% -28.33% 20.93% 72.12% -116.20% 67.24% 884.21% 73.83% 26.25% #NUM! <-IRR #YR-> 10 Earnings per Share -108.09%
Earnings Yield 3.4% 7.6% 6.7% 18.9% 3.8% 3.5% 6.3% 6.0% 5.8% 10.0% -1.9% -0.4% 3.4% 5.8% 7.4% #NUM! <-IRR #YR-> 5 Earnings per Share -107.92%
5 year Running Average $0.95 $1.29 $1.66 $2.33 $2.36 $2.48 $2.49 $2.35 $1.84 $2.27 $1.84 $1.32 $1.28 $1.38 $1.32 0.27% <-IRR #YR-> 10 5 yr Running Average 2.78%
10 year Running Average $0.62 $0.84 $1.07 $1.52 $1.64 $1.71 $1.89 $2.01 $2.09 $2.32 $2.16 $1.91 $1.81 $1.61 $1.79 -11.89% <-IRR #YR-> 5 5 yr Running Average -46.91%
* ESP per share and Earnings from Operations E/P 10 Yrs 5.90% 5Yrs 5.79%
-$2.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.19
-$2.40 $0.00 $0.00 $0.00 $0.00 -$0.19
-$1.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.32
-$2.49 $0.00 $0.00 $0.00 $0.00 $1.32
Comment
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
Dividend* $0.11 $0.14 $0.17 $0.19 $0.21 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $0.92 $1.08 $1.10 $1.10 545.61% <-Total Growth 10 Dividends
Increase 20.67% 25.97% 15.79% 16.67% 7.79% 33.73% 24.32% 17.39% 18.52% 82.29% 4.57% 0.55% 16.85% 2.33% 0.00% 17.03% <-Median-> 10 Increase
Dividends 5 Yr Running $0.08 $0.10 $0.12 $0.14 $0.16 $0.20 $0.24 $0.29 $0.34 $0.48 $0.60 $0.72 $0.85 $0.98 $1.02 647.98% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 0.54% 0.48% 0.50% 0.52% 0.72% 0.71% 0.88% 1.22% 1.48% 2.16% 2.70% 2.68% 2.59% 1.05% <-Median-> 10 Yield H/L Price
Yield on High Price 0.38% 0.40% 0.42% 0.35% 0.53% 0.62% 0.69% 1.00% 1.34% 1.78% 2.18% 2.01% 2.37% 0.85% <-Median-> 10 Yield on High Price
Yield on Low Price 0.93% 0.59% 0.63% 0.98% 1.14% 0.84% 1.19% 1.57% 1.67% 2.75% 3.56% 4.02% 2.85% 1.38% <-Median-> 10 Yield on Low Price
Yield on Close Price 0.39% 0.46% 0.45% 0.79% 0.55% 0.63% 0.90% 1.41% 1.34% 2.44% 3.03% 2.15% 2.42% 2.48% 2.48% 1.12% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 11.60% 6.06% 6.82% 4.18% 14.21% 17.79% 14.38% 23.55% 23.08% 24.44% -157.76% -484.21% 72.15% 42.47% 33.64% 14.29% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 7.95% 7.47% 7.05% 6.06% 6.95% 7.94% 9.54% 12.15% 18.60% 21.01% 32.83% 54.39% 66.85% 70.90% 77.66% 10.84% <-Median-> 8 DPR EPS 5 Yr Running
Payout Ratio CFPS 2.53% 3.67% 3.06% 3.08% 3.87% 4.82% 6.06% 7.12% 7.23% 11.29% 17.78% 29.61% 15.58% 12.61% 11.65% 6.59% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 2.57% 2.90% 2.92% 3.02% 3.24% 3.70% 4.17% 4.96% 5.89% 7.56% 9.77% 12.69% 14.44% 15.45% 15.34% 4.57% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 2.45% 3.16% 2.89% 2.99% 3.72% 4.93% 6.02% 7.68% 7.20% 10.38% 18.57% 25.59% 15.58% 12.61% 11.65% 6.61% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 2.50% 2.74% 2.76% 2.86% 3.06% 3.54% 4.09% 4.99% 5.94% 7.51% 9.73% 12.44% 13.97% 15.00% 15.22% 4.54% <-Median-> 8 DPR CF WC 5 Yr Running Total Grth to 2017
Median Values Yield 2.16% 2.15% Payout 23.08% 11.29% 10.38% 20.50% <-IRR #YR-> 10 Dividends 545.61% 20.61%
* Dividends per share Curr diff 14.86% Last Div Inc ---> $0.250 $0.275 10.0% 21.67% <-IRR #YR-> 5 Dividends 166.67% 21.56%
-$0.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.92
-$0.35 $0.00 $0.00 $0.00 $0.00 $0.92
Historical Dividends Historical High Div 3.70% Low Div 0.37% Ave Div 2.04% Med Div 0.87% Close Div 0.83% Historical Dividends
High/Ave/Median Values Curr diff Exp. -32.97% 570.34% Cheap 21.88% Cheap 185.09% Cheap 197.18% High/Ave/Median
Future Div Yield Div Yd 14.12% earning in 10 Years at IRR of 19.0% Div Inc. 469.47% Future Div Yield
Future Div Yield Div Yd 22.98% earning in 15 Years at IRR of 16.0% Div Inc. 826.55% Future Div Yield
I am earning GC Div Gr 161.90% 9/21/12 # yrs -> 4 2012 $31.82 Cap Gain 39.38% I am earning GC
I am earning Div org yield 1.32% 12/31/15 Traading Div G Yrly 34.16% Div start $0.42 -1.32% 3.46% I am earning Div
Cost covered if held 5 years 6.99% 8.71% 10.18% 9.57% 7.54% 4.67% 3.98% 4.35% 4.60% 8.29% 7.78% 9.15% 12.86% 15.11% 12.61% 7.66% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 19.39% 14.13% 15.36% 28.16% 29.67% 25.31% 30.24% 34.97% 32.78% 29.43% 19.00% 16.04% 17.35% 17.71% 26.06% 28.80% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 39.05% 47.97% 70.23% 46.53% 47.46% 83.32% 94.95% 81.50% 95.42% 109.03% 98.89% 76.39% 70.23% <-Median-> 9 Paid Median Price
Cost covered if held 20 years 115.52% 153.47% 226.10% 144.60% 143.37% 240.42% 234.95% 149.04% <-Median-> 4 Paid Median Price
Cost covered if held 25 years 333.36% 379.77% #NUM! <-Median-> 0 Paid Median Price
H/LYield held 5 yrs 2.10% 2.58% 2.87% 2.61% 1.91% 1.32% 1.16% 1.23% 1.29% 3.04% 2.36% 2.34% 3.24% 3.40% 2.71% 2.12% <-Median-> 10 Paid Median Price
H/LYield held 10 yrs 5.84% 3.89% 3.71% 6.19% 5.68% 5.16% 6.25% 7.03% 6.50% 8.04% 4.34% 3.09% 3.28% 2.95% 3.83% 5.94% <-Median-> 10 Paid Median Price
H/LYield held 15 yrs 8.58% 9.19% 14.32% 9.41% 9.11% 15.44% 23.97% 17.02% 16.68% 18.67% 14.89% 10.11% 14.32% <-Median-> 9 Paid Median Price
H/LYield held 20 yrs 21.40% 38.75% 47.23% 25.10% 24.17% 35.38% 30.14% 31.92% <-Median-> 4 Paid Median Price
Yield if held 25 yrs 49.05% 48.71% #NUM! <-Median-> 0 Paid Median Price
Graham No. $12.98 $22.92 $25.92 $41.97 $24.26 $25.99 $33.58 $29.33 $33.31 $46.17 $28.91 $28.15 $28.15 $37.12 $41.71 22.83% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.62 1.30 1.27 0.89 1.19 1.49 1.17 1.13 0.97 0.88 1.17 1.22 1.48 1.17 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 2.31 1.56 1.52 1.31 1.62 1.72 1.48 1.38 1.08 1.07 1.45 1.63 1.61 1.47 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.94 1.05 1.02 0.47 0.75 1.27 0.86 0.88 0.86 0.69 0.89 0.81 1.34 0.86 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 2.24 1.36 1.40 0.58 1.57 1.71 1.14 0.98 1.08 0.78 1.05 1.52 1.58 1.19 1.06 1.11 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 124.21% 35.57% 40.00% -41.92% 56.66% 70.67% 13.60% -2.37% 7.91% -22.20% 4.53% 51.98% 57.53% 19.48% 6.33% 10.76% <-Median-> 10 Graham Price
presplit '04
presplit '05
presplit '10 $58.20 $62.15 $72.58 $48.75
Price Close $29.10 $31.08 $36.29 $24.38 $38.00 $44.35 $38.15 $28.64 $35.94 $35.92 $30.22 $42.79 $44.35 $44.35 $44.35 37.70% <-Total Growth 10 Stock Price
Increase 127.12% 6.79% 16.78% -32.83% 55.90% 16.71% -13.98% -24.93% 25.49% -0.06% -15.87% 41.59% 3.65% 0.00% 0.00% 3.25% <-IRR #YR-> 10 Stock Price 37.70%
P/E 29.85 13.22 15.00 5.29 26.03 28.43 15.90 16.65 17.28 10.03 -52.10 -225.21 29.77 17.12 13.56 2.32% <-IRR #YR-> 5 Stock Price 12.16%
Trailing P/E 22.38 31.87 15.44 10.07 8.24 30.38 24.46 11.93 20.90 17.27 8.44 -73.78 -233.42 29.77 17.12 4.50% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 1.25% 1.77% % Tot Ret 27.71% 43.29% Price Inc -0.06% P/E: 15.45 10.03 4.09% <-IRR #YR-> 5 Price & Dividend
-$31.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.79
-$38.15 $0.00 $0.00 $0.00 $0.00 $42.79
-$31.08 $0.17 $0.19 $0.21 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $43.71
-$38.15 $0.41 $0.48 $0.88 $0.92 $43.71
Price H/L Med. $21.08 $29.81 $32.81 $37.26 $28.76 $38.83 $39.30 $33.16 $32.34 $40.52 $33.84 $34.38 $41.57 15.32% <-Total Growth 10 Stock Price
Increase 93.68% 41.42% 10.07% 13.56% -22.82% 35.04% 1.21% -15.62% -2.47% 25.29% -16.50% 1.60% 20.93% 1.44% <-IRR #YR-> 10 Stock Price 15.32%
P/E 21.62 12.68 13.56 8.08 19.70 24.89 16.38 19.28 15.55 11.32 -58.34 -180.92 27.90 -2.64% <-IRR #YR-> 5 Stock Price -12.53%
Trailing P/E 16.21 30.57 13.96 15.40 6.24 26.60 25.19 13.82 18.80 19.48 9.45 -59.27 -218.79 2.87% <-IRR #YR-> 10 Price & Dividend
Forward P/E 8.97 12.32 7.12 25.52 18.43 16.18 22.85 15.94 9.03 -69.86 -178.08 23.07 16.05 -0.71% <-IRR #YR-> 5 Price & Dividend
P/E on Running 5 yr Average 22.29 23.17 19.74 15.98 12.17 15.66 15.78 14.11 17.54 17.87 18.39 26.00 32.58 16.06 <-Median-> 10 Forward P/E
P/E on Running 10 yr Average 34.19 35.60 30.81 24.53 17.53 22.67 20.81 16.53 15.49 17.50 15.66 18.04 22.93 15.34 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.44% 1.94% % Tot Ret 50.04% -273.60% Price Inc -2.47% P/E: 14.55 11.32 Count 23 Years of data
-$29.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.38
-$39.30 $0.00 $0.00 $0.00 $0.00 $34.38
-$29.81 $0.17 $0.19 $0.21 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $35.30
-$39.30 $0.41 $0.48 $0.88 $0.92 $35.30
High Months Sep Feb Oct Jun Oct Dec Mar Feb Dec Jul Apr Dec Apr
presplit '04
presplit '05
presplit '10 $59.99 $71.29 $78.56 $109.70
Price High $30.00 $35.65 $39.28 $54.85 $39.24 $44.70 $49.70 $40.48 $35.94 $49.19 $42.00 $45.85 $45.41 28.63% <-Total Growth 10 Stock Price
Increase 117.55% 18.84% 10.20% 39.64% -28.46% 13.91% 11.19% -18.55% -11.22% 36.87% -14.62% 9.17% -0.96% 2.55% <-IRR #YR-> 10 Stock Price 28.63%
P/E 30.76 15.17 16.23 11.90 26.88 28.65 20.71 23.53 17.28 13.74 -72.41 -241.32 30.48 -1.60% <-IRR #YR-> 5 Stock Price -7.75%
Trailing P/E 23.07 36.56 16.71 22.67 8.51 30.62 31.86 16.87 20.90 23.65 11.73 -79.05 -239.00 17.28 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -11.22% P/E: 16.76 13.74 31.25 P/E Ratio Historical High
-$35.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $45.85
-$49.70 $0.00 $0.00 $0.00 $0.00 $45.85
Low Months Jan Oct Jan Dec Feb Aug Oct Jul Jan Dec Oct Jan Feb
presplit '04
presplit '05
presplit '10 $24.32 $47.94 $52.68 $39.33
Price Low $12.16 $23.97 $26.34 $19.67 $18.27 $32.96 $28.90 $25.84 $28.74 $31.85 $25.67 $22.90 $37.73 -4.46% <-Total Growth 10 Stock Price
Increase 52.43% 97.12% 9.89% -25.34% -7.09% 80.41% -12.32% -10.59% 11.22% 10.82% -19.40% -10.79% 64.76% -0.46% <-IRR #YR-> 10 Stock Price -4.46%
P/E 12.47 10.20 10.88 4.27 12.51 21.13 12.04 15.02 13.82 8.90 -44.26 -120.53 25.32 -4.55% <-IRR #YR-> 5 Stock Price -20.76%
Trailing P/E 9.35 24.58 11.21 8.13 3.96 22.58 18.53 10.77 16.71 15.31 7.17 -39.48 -198.58 10.88 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -10.59% P/E: 11.46 8.90 4.46 P/E Ratio Historical Low
-$23.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.90
Long Term Debt $16,794 $16,805 Debt
Change 0.07% Change
Debt/Market Cap Ratio 0.51 0.35 0.43 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $0 $0 $0 $0 $0 Intangibles Goodwill
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! Change
Intangible/Market Cap Ratio 0.00 0.00 0.00 0.00 0.00 0.00 <-Median-> 5 Intangible/Market Cap Ratio
Market Cap $M $31,215 $33,431 $39,174 $26,373 $41,217 $48,379 $41,830 $31,277 $39,078 $39,219 $33,081 $47,538 $49,271 $49,271 $49,271 42.20% <-Total Growth 10 Market Cap 42.20%
Diluted # of Shares in Million 1,076.85 1,074.68 1,078.67 1,081.29 1,083.85 1,095.65 1,102.58 1,099.52 1,090.54 1,096.82 1,093.86 1,100.47 2.40% <-Total Growth 10 Diluted
Change -0.20% 0.37% 0.24% 0.24% 1.09% 0.63% -0.28% -0.82% 0.58% -0.27% 0.60% 0.31% <-Median-> 10 Change
Basic # of Shares in Millions 1,073.30 1,074.68 1,078.67 1,081.29 1,083.52 1,088.10 1,095.58 1,097.08 1,088.68 1,091.75 1,093.86 1,100.47 2.40% <-Total Growth 10 Basic
Change 0.08% 0.13% 0.37% 0.24% 0.21% 0.42% 0.69% 0.14% -0.77% 0.28% 0.19% 0.60% 0.26% <-Median-> 10 Change
Difference -0.1% 0.1% 0.1% 0.1% 0.1% 0.3% 0.1% -0.5% -0.1% 0.0% 0.1% 1.0% 0.07% <-Median-> 10 Difference
$8,381 <-12 mths -8.93%
Purchases
presplit '04
presplit '05
presplit '10 536.35 537.90 539.73 540.99 542.33
# of Share in Millions 1,072.7 1,075.8 1,079.5 1,082.0 1,084.7 1,090.85 1,096.46 1,092.07 1,087.32 1,091.84 1,094.67 1,110.95 1,110.95 1,110.95 1,110.95 0.32% <-IRR #YR-> 10 Shares 3.27%
Change 0.00% 0.29% 0.34% 0.23% 0.25% 0.57% 0.51% -0.40% -0.43% 0.42% 0.26% 1.49% 0.00% 0.00% 0.00% 0.26% <-IRR #YR-> 5 Shares 1.32%
CF from Operations $Million 4,797.0 4,176.0 $5,819 $6,767 $5,812 $6,284 $6,243 $6,209 $7,218 $8,459 $5,632 $3,452 $7,666 $9,688 $10,487 -17.34% <-Total Growth 10 Cash Flow
Increase 30.00% -12.95% 39.34% 16.29% -14.11% 8.12% -0.65% -0.54% 16.25% 17.19% -33.42% -38.71% 122.06% 26.38% 8.26% SO Buy Backs S. Issues (Purchases)
5 year Running Average $3,096 $3,554 $4,313 $5,050 $5,474 $5,772 $6,185 $6,263 $6,353 $6,883 $6,752 $6,194 $6,485 $6,979 $7,385 74.30% <-Total Growth 10 CF 5 Yr Running
CFPS $4.47 $3.88 $5.39 $6.25 $5.36 $5.76 $5.69 $5.69 $6.64 $7.75 $5.14 $3.11 $6.90 $8.72 $9.44 -19.95% <-Total Growth 10 Cash Flow per Share
Increase 30.00% -13.20% 38.87% 16.02% -14.32% 7.51% -1.16% -0.14% 16.76% 16.71% -33.59% -39.61% 122.06% 26.38% 8.26% -1.89% <-IRR #YR-> 10 Cash Flow -17.34%
5 year Running Average $2.93 $3.31 $4.01 $4.69 $5.07 $5.33 $5.69 $5.75 $5.83 $6.31 $6.18 $5.66 $5.91 $6.32 $6.66 -11.17% <-IRR #YR-> 5 Cash Flow -44.71%
P/CF on Med Price 4.71 7.68 6.09 5.96 5.37 6.74 6.90 5.83 4.87 5.23 6.58 11.06 6.02 -2.20% <-IRR #YR-> 10 Cash Flow per Share -19.95%
P/CF on Closing Price 6.51 8.01 6.73 3.90 7.09 7.70 6.70 5.04 5.41 4.64 5.87 13.77 6.43 -11.41% <-IRR #YR-> 5 Cash Flow per Share -45.43%
6.74% Diff M/C 5.51% <-IRR #YR-> 10 CFPS 5 yr Running 70.98%
Excl.Working Capital CF $147.0 $679.0 $346.0 $189.0 $235.0 -$149.0 $36.0 -$447.0 $33.0 $744.0 -$239.0 $542.0 0.00% 0.00% 0.00% -0.09% <-IRR #YR-> 5 CFPS 5 yr Running -0.47%
CF fr Op $M WC $4,944.0 $4,855.0 $6,165 $6,956 $6,047 $6,135 $6,279 $5,762 $7,251 $9,203 $5,393 $3,994 $7,666 $9,688 $10,487 -17.73% <-Total Growth 10 Cash Flow less WC
Increase 33.48% -1.80% 26.98% 12.83% -13.07% 1.46% 2.35% -8.23% 25.84% 26.92% -41.40% -25.94% 91.93% 26.38% 8.26% -1.93% <-IRR #YR-> 10 Cash Flow less WC -17.73%
5 year Running Average $3,178 $3,763 $4,560 $5,325 $5,793 $6,032 $6,316 $6,236 $6,295 $6,926 $6,778 $6,321 $6,701 $7,189 $7,445 -8.65% <-IRR #YR-> 5 Cash Flow less WC -36.39%
CFPS Excl. WC $4.61 $4.51 $5.71 $6.43 $5.58 $5.62 $5.73 $5.28 $6.67 $8.43 $4.93 $3.60 $6.90 $8.72 $9.44 5.32% <-IRR #YR-> 10 CF less WC 5 Yr Run 67.98%
Increase 33.48% -2.08% 26.55% 12.57% -13.28% 0.88% 1.82% -7.87% 26.39% 26.40% -41.55% -27.03% 91.93% 26.38% 8.26% 0.01% <-IRR #YR-> 5 CF less WC 5 Yr Run 0.07%
5 year Running Average $3.00 $3.51 $4.24 $4.94 $5.37 $5.57 $5.81 $5.73 $5.77 $6.34 $6.21 $5.78 $6.10 $6.51 $6.72 -2.25% <-IRR #YR-> 10 CFPS - Less WC -20.34%
P/CF on Med Price 4.57 6.60 5.74 5.80 5.16 6.90 6.86 6.28 4.85 4.81 6.87 9.56 -8.89% <-IRR #YR-> 5 CFPS - Less WC -37.22%
P/CF on Closing Price 6.31 6.89 6.35 3.79 6.82 7.89 6.66 5.43 5.39 4.26 6.13 11.90 6.43 5.09 4.70 5.12% <-IRR #YR-> 10 CFPS 5 yr Running 64.76%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 6.02 5 yr 5.83 P/CF Med 10 yr 6.04 5 yr 6.28 6.42% -0.12% <-IRR #YR-> 5 CFPS 5 yr Running -0.59%
Google also uses net change in Non-cash WC.
-$3.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.11 Cash Flow per Share
-$5.69 $0.00 $0.00 $0.00 $0.00 $3.11 Cash Flow per Share
-$3.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.66 CFPS 5 yr Running
-$5.69 $0.00 $0.00 $0.00 $0.00 $5.66 CFPS 5 yr Running
-$4,855 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,994 Cash Flow less WC
-$6,279 $0 $0 $0 $0 $3,994 Cash Flow less WC
-$3,763 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,321 CF less WC 5 Yr Run
-$6,316 $0 $0 $0 $0 $6,321 CF less WC 5 Yr Run
OPM 43.10% 35.87% 46.39% 41.84% 52.46% 43.88% 40.26% 38.34% 40.22% 39.71% 42.77% 31.10% -13.28% <-Total Growth 10 OPM
Increase -11.85% -16.78% 29.35% -9.81% 25.39% -16.37% -8.24% -4.77% 4.91% -1.27% 7.71% -27.28% Should increase or be stable.
Diff from Median 4.99% -12.63% 13.01% 1.93% 27.81% 6.88% -1.93% -6.60% -2.02% -3.26% 4.20% -24.23% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 41.05% 5 Yrs 39.71% should be zero, it is a check on calculations
Current Assets $2,051 $2,239 $2,181 $3,392 $1,891 $2,172 $2,781 $1,914 $2,216 $3,489 $4,059 $4,336 Liquidity ratio of 1.5 and up, best
Current Liabilities $3,825 $3,071 $3,563 $3,420 $2,405 $3,156 $4,034 $3,976 $5,234 $5,142 $4,595 $5,092 0.69 <-Median-> 10 Ratio
Liquidity 0.54 0.73 0.61 0.99 0.79 0.69 0.69 0.48 0.42 0.68 0.88 0.85 0.68 <-Median-> 5 Ratio
Liq. with CF aft div 1.76 2.04 2.20 2.91 3.11 2.58 2.14 1.93 1.70 2.14 1.89 1.33 1.89 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.82 0.42 0.77 0.94 1.25 0.96 0.86 0.78 0.73 0.67 0.86 0.76 0.76 <-Median-> 5 Ratio
Current portion L T D. $814 $953 $1,719 $980 $1,729 $1,812
Liquidity 0.86 0.63 0.63 0.84 1.42 1.32 0.84 <-Median-> 5 Ratio
Liq. with CF aft div 2.69 2.54 2.54 2.64 3.03 2.06 2.54 <-Median-> 5 Ratio
Assets $21,852 $33,160 $36,114 $42,650 $41,024 $42,669 $47,278 $48,980 $51,754 $60,200 $59,275 $58,648 Debt Ratio of 1.5 and up, best
Liabilities $13,615 $22,470 $22,793 $24,276 $21,598 $21,684 $24,380 $24,697 $25,982 $31,309 $31,984 $32,381 1.91 <-Median-> 10 Ratio
Debt Ratio 1.60 1.48 1.58 1.76 1.90 1.97 1.94 1.98 1.99 1.92 1.85 1.81 1.92 <-Median-> 5 Ratio
Book Value $8,237 $10,690 $13,321 $18,374 $19,426 $20,985 $22,898 $24,283 $25,772 $28,891 $27,291 $26,267 $26,267 $26,267 $26,267 145.72% <-Total Growth 10 Book Value
Book Value per share $7.68 $9.94 $12.34 $16.98 $17.91 $19.24 $20.88 $22.24 $23.70 $26.46 $24.93 $23.64 $23.64 $23.64 $23.64 137.94% <-Total Growth 10 Book Value per Share
Change 12.47% 29.41% 24.19% 37.61% 5.47% 7.41% 8.56% 6.47% 6.60% 11.64% -5.78% -5.16% 0.00% 0.00% 0.00% 19.60% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 2.74 3.00 2.66 2.19 1.61 2.02 1.88 1.49 1.36 1.53 1.36 1.45 1.63 P/B Ratio Historical Median
P/B Ratio (Close) 3.79 3.13 2.94 1.44 2.12 2.31 1.83 1.29 1.52 1.36 1.21 1.81 1.88 1.88 1.88 9.06% <-IRR #YR-> 10 Book Value per Share 137.94%
Change 101.94% -17.48% -5.97% -51.19% 47.82% 8.66% -20.76% -29.49% 17.72% -10.48% -10.71% 49.30% 3.65% 0.00% 0.00% 2.51% <-IRR #YR-> 5 Book Value per Share 13.22%
Leverage (A/BK) 2.65 3.10 2.71 2.32 2.11 2.03 2.06 2.02 2.01 2.08 2.17 2.23 2.10 <-Median-> 10 A/BV
Debt/Equity Ratio 1.65 2.10 1.71 1.32 1.11 1.03 1.06 1.02 1.01 1.08 1.17 1.23 1.10 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity P/BV 10 yr Med 1.57 5 yr Med 1.45 19.60% Diff M/C 2.36 Historical 21 A/BV
-$9.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.64
-$20.88 $0.00 $0.00 $0.00 $0.00 $23.64
$3,047 <-12 mths -22.63%
Comprehensive Income $1,047 $2,520 $2,534 $5,175 $1,214 $1,634 $2,660 $1,924 $2,254 $3,938 -$613 -$209 -108.29% <-Total Growth 10 Comprehensive Income
Increase 140.69% 0.56% 104.22% -76.54% 34.60% 62.79% -27.67% 17.15% 74.71% -115.57% 65.91% 17.15% <-Median-> 5 Comprehensive Income
5 Yr Running Average $2,498 $2,615 $2,643 $2,521 $1,937 $2,482 $2,033 $1,459 #NUM! <-IRR #YR-> 10 Comprehensive Income -108.29%
ROE 12.7% 23.6% 19.0% 28.2% 6.2% 7.8% 11.6% 7.9% 8.7% 13.6% -2.2% -0.8% #NUM! <-IRR #YR-> 5 Comprehensive Income -107.86%
5Yr Median 19.0% 19.0% 11.6% 7.9% 7.9% 8.7% 8.7% 7.9% -7.40% <-IRR #YR-> 7 5 Yr Running Average #DIV/0!
% Difference from NI -0.3% -0.2% -2.8% 3.8% -23.2% -3.7% 0.6% 1.7% -0.7% 0.2% -3.8% 2.5% -11.21% <-IRR #YR-> 5 5 Yr Running Average -44.81%
Diff 5, 10 yr -0.2% 0.2% 7.9% <-Median-> 5 Return on Equity
-$2,520 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$209
-$2,660 $0 $0 $0 $0 -$209
-$2,498.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,458.8
-$2,643.4 $0.0 $0.0 $0.0 $0.0 $1,458.8
Current Liability Coverage Ratio 1.29 1.58 1.73 2.03 2.51 1.94 1.56 1.45 1.39 1.79 1.17 0.78 CFO / Current Liabilities
5 year Median 2.30 1.96 1.73 1.73 1.73 1.94 1.94 1.94 1.56 1.56 1.45 1.39 164.3% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 22.62% 14.64% 17.07% 16.31% 14.74% 14.38% 13.28% 11.76% 14.01% 15.29% 9.10% 6.81% CFO / Total Assets
5 year Median 21.38% 20.12% 20.12% 17.07% 16.31% 14.74% 14.74% 14.38% 14.01% 14.01% 13.28% 11.76% 14.2% <-Median-> 10 Return on Assets
Return on Assets ROA 4.8% 7.6% 7.2% 11.7% 3.9% 4.0% 5.6% 3.9% 4.4% 6.5% -1.1% -0.3% Net Income/Assets Return on Assets ROA
5Yr Median 7.3% 7.6% 7.6% 7.6% 7.2% 7.2% 5.6% 4.0% 4.0% 4.4% 4.4% 3.9% 4.2% <-Median-> 10 Asset Efficiency Ratio ROA
Return on Equity ROE 12.7% 23.6% 19.6% 27.1% 8.1% 8.1% 11.5% 7.8% 8.8% 13.6% -2.3% -0.8% Net Inc/ Shareholders' equity Return on Equity ROE
5Yr Median 17.2% 19.2% 19.6% 19.6% 19.6% 19.6% 11.5% 8.1% 8.1% 8.8% 8.8% 7.8% 8.5% <-Median-> 10 Return on Equity ROE
$3,055 <-12 mths -22.24%
Net Income $1,050 $2,524 $2,608 $4,985 $1,580 $1,697 $2,643 $1,892 $2,270 $3,929 -$637 -$204 $1,904 $3,153 $4,352 -108.08% <-Total Growth 10 Net Income
Increase -25.27% 140.38% 3.33% 91.14% -68.30% 7.41% 55.75% -28.41% 19.98% 73.08% -116.21% -67.97% -1033.33% 65.60% 38.03% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $1,018 $1,391 $1,798 $2,514 $2,549 $2,679 $2,703 $2,559 $2,016 $2,486 $2,019 $1,450 $1,452 $1,629 $1,714 #NUM! <-IRR #YR-> 10 Net Income -108.08%
Operating Cash Flow $4,797 $4,176 $5,819 $6,767 $5,812 $6,284 $6,243 $6,209 $7,218 $8,459 $5,632 $3,452 #NUM! <-IRR #YR-> 5 Net Income -107.72%
Investment Cash Flow -$4,333 -$11,735 -$6,540 -$7,178 -$3,558 -$5,327 -$5,963 -$5,927 -$7,006 -$11,177 -$5,465 -$3,811 0.41% <-IRR #YR-> 10 5 Yr Running Average 4.21%
Total Accruals $586 $10,083 $3,329 $5,396 -$674 $740 $2,363 $1,610 $2,058 $6,647 -$804 $155 -11.71% <-IRR #YR-> 5 5 Yr Running Average -46.35%
Total Assets $21,852 $33,160 $36,114 $42,650 $41,024 $42,669 $47,278 $48,980 $51,754 $60,200 $59,275 $58,648 Balance Sheet Assets
Accruals Ratio 2.68% 30.41% 9.22% 12.65% -1.64% 1.73% 5.00% 3.29% 3.98% 11.04% -1.36% 0.26% 3.29% <-Median-> 5 Ratio
EPS/CF Ratio 0.21 0.52 0.42 0.72 0.26 0.28 0.42 0.33 0.31 0.42 -0.12 -0.05 0.32 <-Median-> 10 EPS/CF Ratio
-$2,524 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$204
-$2,643 $0 $0 $0 $0 -$204
-$1,391 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,450
-$2,703 $0 $0 $0 $0 $1,450
Change in Close 127.12% 6.79% 16.78% -32.83% 55.90% 16.71% -13.98% -24.93% 25.49% -0.06% -15.87% 41.59% 3.65% 0.00% 0.00% Count 22 Years of data
up/down down down down down down down down Count 15 68.18%
Meet Prediction? Yes Yes % right Count 5 33.33%
Financial Cash Flow -$474 $7,564 $719 $417 -$2,268 -$1,077 -$268 -$297 -$233 $2,727 -$123 $307 C F Statement Financial Cash Flow
Total Accruals $1,060 $2,519 $2,610 $4,979 $1,594 $1,817 $2,631 $1,907 $2,291 $3,920 -$681 -$152 Accruals
Accruals Ratio 4.85% 7.60% 7.23% 11.67% 3.89% 4.26% 5.56% 3.89% 4.43% 6.51% -1.15% -0.26% 3.89% <-Median-> 5 Ratio
Cash $23 $21 $27 $13 $22 $34 $37 $16 $25 $69 $17 Cash
Cash per Share $0.02 $0.02 $0.02 $0.01 $0.02 $0.03 $0.03 $0.01 $0.02 $0.06 $0.02 $0.02 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.07% 0.05% 0.10% 0.03% 0.05% 0.08% 0.12% 0.04% 0.06% 0.21% 0.04% 0.06% <-Median-> 5 % of Stock Price
Buy and Sell Advisor dated January 10, 2014.
See article
http://www.theglobeandmail.com/globe-investor/investment-ideas/strategy-lab/dividend-investing/dividend-growth-stocks-to-buy-and-hold/article15747463/?cmpid=rss1&click=dlvr.it#dashboard/follows/hold/article15747463/?cmpid=rss1&click=dlvr.it#dashboard/follows/
Notes:
April 14, 2017. Last estimates were for 2016, 2017 and 2018 of $10273M, $13691M and $15956M for Revenue, -$1.46, $0.22 and $1.57 for Adj EPS, -$1.70, $0.18 and $1.35 for EPS, $3.34, $5.53 and $7.49 for CFPS, -$1668M, $164M and $1080M for Net Income.
April 23, 2016. Last estimates were for 2015, 2016 and 2017 of $14322M, $17221M and $21228M for Revenue, $3.29 and $2.87 for Adjusted EPS for 2015 and 2016, $0.19. 1.69 and $3.07 for EPS,
$5.41, $6.62 and $6.11 for CFPS and $415M, $2019M and $3401M for Net Income.
May 3, 2015. Last estimates were for 2014, 2015 and 2016 of $20058M, $20632M and $21390M for Revenue, $3.37. $3.29 and $2.87 amd Adjusted EPS, $3.37, $3.29 and $2.87 for EPS,
$9.05, $9.36 and $9.65 for CFPS, and $3497M, $3800M and $3361M for Net Income.
May 1, 2014. Last estimates were for 2013 and 2014 of $162420M and $18099M for Revenue, $2.43 amd $3.01 for Adjusted EPS, $2.43 and $3.01 for EPS, $6.20 and $6.77 for CFPS.
April 1, 2013. Last estimates were for 2012 and 2013 and were $14400M and $16200M for Revenue, $3.61 for adjusted EPS for 2012, $1.76 and $2.68 for EPS and $5.14 and $6.57 for CFPS.
I got proxy notice on 28 March 2013, but audited financial statements did not appear on their site until April 1, 2013.
Sept 10, 2012. Last estimates were for 2011 and 2012 and were for Revenue of $13.285M and $16.73M and EPS of $1.65 and 2.60 and Adjusted EPS of $2.22 and $3.61 and CF of$5.84 and $7.48
July 3, 2011. When I last looked at the stock, I got estimates for 2010 and 2011 of $2.56 and $3.19 for EPS and $6.00 and $7.00 for CF
Aug 9. 2010. The last time I looked, I got earnings of for 2009 and 2010 of $5.00 and $6.10 and cash flow of $11 and $12.50
Oct 7, 2009. When I looked at this stock in June 2009, I picked up 2009 and 2010 earnings of $5.00 and $5.40. Estimates for 2009 remain, but for 2010 they have increased.
Jun 21, 2009 AR 2008. When I last looked at the stock in Oct 2008, I got a earnings estimate of $5.98 and Cash Flow of $13.19 for 2008. Earnings was $l9.22 and Cash flow came in at $12.71
Adjusted net earnings from operations is a non-GAAP measure that represents net earnings adjusted for certain items of a non-operational nature. The Company evaluates its performance based on adjusted net earnings from operations.
Sector:
Energy, Resources
What should this stock accomplish?
This stock should give you a window on the oil and gas business. Expect a lot of volitility in the stock and its earnings, cash flow etc.
Since the give a low dividend expect decent dividend increases.
Would I buy this company and Why.
If you want an good oil and gas stock, this would be a good one to look at.
Dividends
Dividends are paid quarterly, in cylce 1, which is in January, April July and October The dividends are paid at the beginning of the month. Dividends are declared for shareholders of one month and paid in following month.
For example, the a dividend was declared on March 6, 2014 for shareholders of record of March 17, 2014 and is payable on April 1, 2014.
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.
For customers
For employees
For community
For investors
Why am I following this stock.
I started to follow this stock in 2008 because it was on the dividend growth lists that I followed.
Why I bought this stock.
I first bought CNQ in September 2012 because the dividend yield was relatively high. The 5 and 10 year median dividend yields were 0.73% and 0.75%. The current one was at 1.31% and I got it with a yield of 1.32%.
I sold some TransAlta to buy this stock. TransAlta is not doing well lately.
In April 2013 I bought more shares of this stock because the yield is now at 1.54%.
How they make their money.
Canadian Natural Resources Ltd. is a senior oil and natural gas exploration, development and production company. The Company's operations are focused in Western Canada, in the U.K.
sector of the North Sea and in offshore West Africa.
Industry: Oil and Gas (Oil and Gas Producers). Widely held.
If you do not want to sign into their site, they publish complete annual statements with the news of their results.
*Adjusted net earnings from operations is a non-GAAP method to evalute the company's performance. And, just to confuse you, a lot of earnings estimates seem to be for the Adjusted EPS, not EPS.
Also, sites are mixing the two EPS methods without quailifing what they are using.
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.
Also, for the Operational Profit Margin, a higher percentage is better. With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Apr 1 2013 May 02 2014 May 03 2015 April 23 2016 April 14 2017
Laut, Stephen W. 2.135 0.20% 2.212 0.20% 2.344 0.21% 2.421 0.22% 2.425 0.22%
CEO - Shares - Amount $76.745 $79.461 $70.845 $103.610 $107.561
Options - percentage 2.000 0.18% 2.000 0.18% 2.100 0.19% 2.100 0.19% 2.079 0.19%
Options - amount $71.880 $71.840 $63.462 $89.859 $92.200
Reuters Options Value 1.255 $41.954
Bieber, Corey B. 0.150 0.01% 0.169 0.02% 0.177 0.02% 0.181 0.02%
CFO - Shares - Amount $5.376 $5.108 $7.578 $8.031
Options - percentage 0.289 0.03% 0.380 0.03% 0.465 0.04% 0.480 0.04%
Options - amount $10.381 $11.484 $19.897 $21.278
Proll, Douglas 0.742 0.07% 0.835 0.08% 0.835 0.08% 0.835 0.08% last filing in Jan 2017
Officer - Shares - Amount $26.653 $25.223 $35.714 $37.016
Options - percentage 0.695 0.06% 0.500 0.05% 0.330 0.03% 0.330 0.03%
Options - amount $24.978 $15.110 $14.121 $14.636
Bergeson, Jeffrey James 0.254 0.02% 0.254 0.02% 0.254 0.02% 0.254 0.02% 0.254 0.02% Last file 2010, but still listed on
Officer - Shares - Amount $9.142 $9.137 $7.687 $10.884 $11.281 CNQ's website under Mgemnt
Options - percentage 0.142 0.01% 0.142 0.01% 0.142 0.01% 0.142 0.01% 0.142 0.01%
Options - amount $5.103 $5.101 $4.291 $6.076 $6.298
Best, Catherine May 0.006 0.00% 0.029 0.00% 0.030 0.00% 0.032 0.00% 0.036 0.00%
Director - Shares - Amt $0.225 $1.041 $0.921 $1.390 $1.618
Options - percentage 0.021 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.745 $0.000 $0.000 $0.000 $0.000
Edwards, Norman Murray 22.801 2.09% 22.585 2.06% 21.920 1.97% 21.522 1.94%
Chairman - Shares - Amt $819.009 $682.513 $937.945 $954.511
Options - percentage 2.050 0.19% 1.950 0.18% 2.050 0.18% 2.298 0.21%
Options - amount $73.636 $58.929 $87.720 $101.927
Increase in O/S Shares 6.625 0.61% 5.415 0.50% 14.610 1.34% 2.831 0.26% 16.284 1.47%
due to SO 2013 $189.740 $194.615 $524.791 $85.553 $696.792
Book Value $194.000 $130.000 $488.000 $91.000 $559.000
Previous Lia. for SO $45.000 $50.000 $129.00 $0.000 $0.000
Insider Buying -$4.904 -$1.173 -$8.018
Insider Selling $52.118 $11.682 $98.356
Net Insider Selling $82.157 $47.214 $10.509 $90.337 seems to be selling off
% of Market Cap 0.21% 0.14% 0.02% 0.18% Options
Directors 13 11 13 11 11
Women 1 8% 1 9% 2 15% 2 18% 2 18%
Minorities 0 0% 0 0% 0 0% 1 9% 1 9% Christopher L. Fong
Institutions/Holdings 357 68.01% 370 69.60%
Total Shares Held 0.000 0.00% 744.510 67.02% 774.913 69.75%
Increase/Decrease 3 Mths 0.000 #DIV/0! -20.958 -2.74% 5.233 0.68%
Starting No. of Shares 0.000 765.468 Nasdaq 769.681 Nasdaq
Copyright 2008 Website of SPBrunner. All rights reserved.
My Stock Div