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.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/
Canadian Natural Resources TSX CNQ NYSE CNQ https://www.cnrl.com/ Fiscal Yr: Dec 31
Year 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 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 Value Description #Y Item Total G
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Split Dates 5/21/10 Alpha
Split 2 Split Spread
Revenue less Royalities $12,901 $13,792 $14,589 $16,145 $18,863 $12,363 $10,523 $16,651 $21,027 $22,871 $16,893 $30,057 $42,298 $35,915 $35,773 $32,827 189.93% <-Total Growth 10 Revenue less Royalities
Increase 27.20% 6.91% 5.78% 10.67% 16.83% -34.46% -14.88% 58.23% 26.28% 8.77% -26.14% 77.93% 40.73% -15.09% -0.40% -8.24% 13.75% <-Median-> 10 Increase
Royalities $1,421 $1,715 $1,606 $1,800 $2,438 $804 $575 $1,018 $1,255 $1,523 $598 $2,797 $7,232 $1,271 $1,266 $1,162 350.31% <-Total Growth 10 Royalities
% Roylities to Rev less Royalities 11.01% 12.43% 11.01% 11.15% 12.92% 6.50% 5.46% 6.11% 5.97% 6.66% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 6.04% <-Median-> 10 % Roylities to Rev less Royalities
Revenue* $14,322 $15,507 $16,195 $17,945 $21,301 $13,167 $11,098 $17,669 $22,282 $24,394 $17,491 $32,854 $49,530 $37,186 $37,039 $33,989 205.84% <-Total Growth 10 Revenue
Increase 29.28% 8.27% 4.44% 10.81% 18.70% -38.19% -15.71% 59.21% 26.11% 9.48% -28.30% 87.83% 50.76% -24.92% -0.40% -8.24% 11.83% <-IRR #YR-> 10 Revenue 205.84%
5 year Running Average $13,152 $13,925 $14,655 $15,009 $17,054 $16,823 $15,941 $16,236 $17,103 $17,722 $18,587 $22,938 $29,310 $32,291 $34,820 $38,120 22.89% <-IRR #YR-> 5 Revenue 180.32%
Revenue per Share $13.13 $14.14 $14.83 $16.50 $19.51 $12.03 $9.99 $14.45 $18.54 $20.55 $14.77 $28.12 $44.92 $33.72 $33.59 $30.83 7.18% <-IRR #YR-> 10 5 yr Running Average 100.00%
Increase 28.55% 7.72% 4.86% 11.29% 18.21% -38.35% -16.95% 44.65% 28.30% 10.86% -28.12% 90.33% 59.75% -24.92% -0.40% -8.24% 12.54% <-IRR #YR-> 5 5 yr Running Average 80.53%
5 year Running Average $12.15 $12.81 $13.45 $13.76 $15.62 $15.40 $14.57 $14.50 $14.90 $15.11 $15.66 $19.29 $25.38 $28.42 $31.03 $34.24 11.72% <-IRR #YR-> 10 Revenue per Share 202.91%
P/S (Price/Sales) Med 2.96 2.78 2.24 1.96 2.08 2.81 3.44 2.87 2.14 1.76 1.80 1.46 1.66 2.25 0.00 0.00 25.46% <-IRR #YR-> 5 Revenue per Share 210.86%
P/S (Price/Sales) Close 3.38 2.70 1.93 2.18 1.84 2.51 4.28 3.11 1.78 2.04 2.07 1.90 1.67 2.40 2.41 2.63 6.55% <-IRR #YR-> 10 5 yr Running Average 88.67%
*Product sales before Royalties in M CDN $  P/S Med 20 yr  2.19 15 yr  2.24 10 yr  2.02 5 yr  1.76 18.99% Diff M/C 11.85% <-IRR #YR-> 5 5 yr Running Average 75.09%
-$16,195 $0 $0 $0 $0 $0 $0 $0 $0 $0 $49,530
-$17,669 $0 $0 $0 $0 $49,530
-$14,655 $0 $0 $0 $0 $0 $0 $0 $0 $0 $29,310
-$16,236 $0 $0 $0 $0 $29,310
-$14.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.92
-$14.45 $0.00 $0.00 $0.00 $0.00 $44.92
Adjusted Cash Flow $9,088 $10,267 $5,200 $13,733 $19,791 $15,492 $15,418
AFFO basic $5.81 $5.98 $5.48 $6.87 $8.78 $5.29 $3.90 $6.25 $7.46 $8.62 $4.40 $11.63 $17.44 218.25% <-Total Growth 10 AFFO basic
AFFO Diluted $5.81 $5.94 $5.47 $6.86 $8.74 $5.28 $3.89 $6.21 $7.43 $8.61 $4.40 $11.57 $17.22 $14.05 $13.98 214.81% <-Total Growth 10 AFFO Diluted
Increase 3.38% 2.24% -7.91% 25.41% 27.41% -39.59% -26.33% 59.64% 19.65% 15.88% -48.90% 162.95% 48.83% -18.41% -0.48% 10 0 10 Years of Data, EPS P or N 100.00%
Earnings Yield 13.1% 15.6% 19.1% 19.1% 24.3% 17.5% 9.1% 13.8% 22.6% 20.5% 14.4% 21.6% 22.9% 17.3% 17.3% 12.15% <-IRR #YR-> 10 Earnings per Share 214.81%
5 year Running Average $5.44 $5.71 $5.66 $5.94 $6.56 $6.46 $6.05 $6.20 $6.31 $6.28 $6.11 $7.64 $9.85 $11.17 $12.24 22.63% <-IRR #YR-> 5 Earnings per Share 177.29%
Payout Ratio 4.78% 5.81% 7.40% 7.00% 10.01% 17.33% 23.65% 17.71% 18.03% 16.96% 37.50% 15.86% 16.48% 25.27% 25.75% 5.70% <-IRR #YR-> 10 5 yr Running Average 74.02%
5 year Running Average 1.26% 9.43% -5.01% 3.52% 10.99% -17.99% 11.12% 188.58% 0.70% 18.17% -17.71% 241.49% 4.81% -2.54% 0.81% 9.71% <-IRR #YR-> 5 5 yr Running Average 58.91%
P/AFFO Med 6.68 6.62 6.06 4.71 4.64 6.41 8.84 6.69 5.33 4.20 6.05 3.56 4.34 5.39 0.00 5.02 <-Median-> 10 P/AFFO Med
P/AFFO High 7.69 8.37 7.40 5.24 5.63 7.95 11.79 7.53 6.59 4.90 9.55 4.62 5.05 5.90 0.00 6.11 <-Median-> 10 P/AFFO High
P/AFFO Low 5.67 4.87 4.72 4.19 3.64 4.86 5.89 5.85 4.07 3.50 2.55 2.50 3.62 4.89 0.00 3.86 <-Median-> 10 P/AFFO Low
P/AFFO Close 7.63 6.42 5.24 5.24 4.11 5.72 11.00 7.23 4.43 4.88 6.95 4.62 4.37 5.76 5.79 5.06 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 7.89 6.57 4.82 6.57 5.24 3.46 8.10 11.55 5.30 5.65 3.55 12.15 6.50 4.70 5.76 6.08 <-Median-> 10 Trailing P/AFFO Close
5 Year Median Values DPR 10 Yrs 17.14% 5 Yrs   16.96% P/CF 5 Yrs   in order 4.34 5.05 3.50 4.62 32.94% Diff M/C 14.78% Diff M/C 10
Funds Flow to Adjusted funds flow from operations
Adjusted net earnings from operations $2,435 $3,811 $263 -$669 $1,403 $3,263 $3,795 -$756 $7,420 $12,863
Adjusted EPS Basic $2.36 $2.32 $1.48 $2.24 $3.49 $0.24 -$0.61 $1.19 $2.68 $3.19 -$0.64 $6.28 $11.33 665.54% <-Total Growth 10 EPS Basic TD Web
Adjusted EPS Diluted $2.36 $2.30 $1.47 $2.23 $3.47 $0.24 -$0.61 $1.19 $2.67 $3.18 -$0.64 $6.25 $11.19 $7.75 $8.81 $9.43 661.22% <-Total Growth 10 EPS Diluted
Increase -4.84% -2.54% -36.09% 51.70% 55.61% -93.08% -354.17% 295.08% 124.37% 19.10% -120.13% 1076.56% 79.04% -30.74% 13.68% 7.04% 8 2 10 Years of Data, EPS P or N 80.00%
Earnings Yield 5.32% 6.03% 5.13% 6.20% 9.66% 0.79% -1.43% 2.65% 8.11% 7.57% -2.09% 11.69% 14.88% 9.57% 10.88% 11.64% 22.50% <-IRR #YR-> 10 Earnings per Share 661.22%
5 year Running Average $3.13 $2.97 $2.37 $2.17 $2.37 $1.94 $1.36 $1.30 $1.39 $1.33 $1.16 $2.53 $4.53 $5.55 $6.67 $8.69 56.55% <-IRR #YR-> 5 Earnings per Share 840.34%
Payout Ratio 11.76% 15.00% 27.55% 21.52% 25.22% 381.25% -150.82% 92.44% 50.19% 45.91% -257.81% 29.36% 25.36% 45.81% 40.86% 38.18% 6.70% <-IRR #YR-> 10 5 yr Running Average 91.30%
5 year Running Average 6.30% 8.01% 12.06% 15.82% 20.14% 31.10% 52.87% 65.80% 73.99% 85.98% 111.74% 58.38% 46.90% 46.28% 44.88% 38.97% 28.28% <-IRR #YR-> 5 5 yr Running Average 247.39%
Price/AEPS Median 16.45 17.09 22.56 14.50 11.68 140.98 -56.35 34.90 14.83 11.37 -41.56 6.59 6.67 9.77 0.00 0.00 11.52 <-Median-> 10 Price/AEPS Median
Price/AEPS High 18.94 21.61 27.54 16.12 14.18 175.00 -75.16 39.28 18.34 13.26 -65.63 8.55 7.78 10.69 0.00 0.00 13.72 <-Median-> 10 Price/AEPS High
Price/AEPS Low 13.97 12.57 17.58 12.89 9.18 106.96 -37.54 30.53 11.33 9.47 -17.50 4.62 5.57 8.86 0.00 0.00 9.33 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 18.79 16.59 19.48 16.12 10.35 125.92 -70.15 37.75 12.34 13.21 -47.80 8.55 6.72 10.45 9.19 8.59 11.34 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 16.10 19.28 25.95 12.84 10.36 149.67 -49.54 35.96 16.82 10.36 -65.63 4.89 4.78 9.70 9.19 8.59 10.36 <-Median-> 10 Trailing P/AEPS Close
5 Year Median Values DPR 10 Yrs 27.36% 5 Yrs   29.36% P/CF 5 Yrs   in order 6.67 8.55 5.57 8.55 56.61% Diff M/C -9.30% Diff M/C 10
EPS Basic $1.56 $2.41 $1.72 $2.08 $3.60 -$0.58 -$0.19 $2.04 $2.13 $4.55 -$0.37 $6.49 $9.64 460.47% <-Total Growth 10 EPS Basic
EPS Diluted* $1.56 $2.40 $1.72 $2.08 $3.58 -$0.58 -$0.19 $2.03 $2.12 $4.54 -$0.37 $6.46 $9.52 $6.82 $7.50 $8.56 453.49% <-Total Growth 10 EPS Diluted
Increase 6.85% 53.85% -28.33% 20.93% 72.12% -116.20% 67.24% 1168.42% 4.43% 114.15% -108.15% 1845.95% 47.37% -28.36% 9.97% 14.13% 7 3 10 Years of Data, EPS P or N 70.00%
Earnings Yield 3.5% 6.3% 6.0% 5.8% 10.0% -1.9% -0.4% 4.5% 6.4% 10.8% -1.2% 12.1% 12.7% 8.4% 9.3% 10.6% 18.66% <-IRR #YR-> 10 Earnings per Share 453.49%
5 year Running Average $2.48 $2.49 $2.35 $1.84 $2.27 $1.84 $1.32 $1.38 $1.39 $1.58 $1.63 $2.96 $4.45 $5.39 $5.99 $7.77 36.22% <-IRR #YR-> 5 Earnings per Share 368.97%
10 year Running Average $1.71 $1.89 $2.01 $2.09 $2.32 $2.16 $1.91 $1.87 $1.62 $1.93 $1.73 $2.14 $2.92 $3.39 $3.79 $4.70 6.60% <-IRR #YR-> 10 5 yr Running Average 89.53%
* ESP per share and Earnings from Operations E/P 10 Yrs 6.11% 5Yrs 10.81% 26.33% <-IRR #YR-> 5 5 yr Running Average 221.82%
-$1.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.52
-$2.03 $0.00 $0.00 $0.00 $0.00 $9.52
-$2.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.45
-$1.38 $0.00 $0.00 $0.00 $0.00 $4.45
Comment
Dividend* $3.65 $3.68 $4.29 Estimates Dividend*
Increase 28.63% 0.82% 16.58% Estimates Increase
Payout Ratio EPS 53.52% 49.07% 50.12% Estimates Payout Ratio EPS
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 $1.50 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Dividend* $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $2.84 $3.55 $3.60 $3.60 600.62% <-Total Growth 10 Dividends
Increase 33.73% 24.32% 17.39% 18.52% 82.29% 4.57% 0.55% 19.57% 21.82% 8.96% 13.01% 11.21% 54.63% 25.11% 1.41% 0.00% 21 0 21 Years of data, Count P, N
Average Increases 5 Year Running 19.99% 19.66% 19.98% 20.35% 35.25% 29.42% 24.66% 25.10% 25.76% 11.09% 12.78% 14.91% 21.93% 22.58% 21.08% 18.47% 23.30% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.20 $0.24 $0.29 $0.34 $0.48 $0.60 $0.72 $0.86 $1.03 $1.15 $1.29 $1.48 $2.12 $2.57 $2.99 $3.38 644.13% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 0.71% 0.88% 1.22% 1.48% 2.16% 2.70% 2.68% 2.65% 3.38% 4.04% 6.20% 4.46% 3.80% 4.69% 3.04% <-Median-> 10 Yield H/L Price
Yield on High  Price 0.62% 0.69% 1.00% 1.34% 1.78% 2.18% 2.01% 2.35% 2.74% 3.46% 3.93% 3.43% 3.26% 4.28% 2.54% <-Median-> 10 Yield on High  Price
Yield on Low Price 0.84% 1.19% 1.57% 1.67% 2.75% 3.56% 4.02% 3.03% 4.43% 4.85% 14.73% 6.35% 4.55% 5.17% 4.22% <-Median-> 10 Yield on Low Price
Yield on Close Price 0.63% 0.90% 1.41% 1.34% 2.44% 3.03% 2.15% 2.45% 4.07% 3.48% 5.39% 3.43% 3.77% 4.38% 4.44% 4.44% 3.23% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 17.79% 14.38% 23.55% 23.08% 24.44% -157.76% -484.21% 54.19% 63.21% 32.16% -445.95% 28.41% 29.81% 52.05% 48.00% 42.06% 26.42% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 7.94% 9.54% 12.15% 18.60% 21.01% 32.83% 54.39% 61.99% 73.99% 72.41% 79.58% 49.97% 47.70% 47.58% 50.03% 43.55% 52.18% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 4.82% 6.06% 7.12% 7.23% 11.29% 17.78% 29.61% 18.52% 15.91% 19.63% 41.44% 14.81% 16.13% 25.00% 22.50% 21.56% 16.96% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 3.70% 4.17% 4.96% 5.89% 7.56% 9.77% 12.69% 15.01% 16.96% 19.08% 22.40% 19.35% 21.32% 23.08% 23.34% 22.01% 15.99% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 4.93% 6.02% 7.68% 7.20% 10.38% 18.57% 25.59% 19.32% 18.35% 17.57% 40.03% 15.86% 16.20% 25.00% 22.50% 21.56% 17.96% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 3.54% 4.09% 4.99% 5.94% 7.51% 9.73% 12.44% 14.63% 17.20% 19.23% 22.29% 19.96% 21.76% 23.03% 23.61% 22.27% 15.92% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 3.04% 3.23% 5 Yr Med 5 Yr Cl 4.04% 3.77% 5 Yr Med Payout 29.81% 16.13% 17.57% 20.87% <-IRR #YR-> 5 Dividends
* Dividends per share  10 Yr Med and Cur. 46.03% 37.60% 5 Yr Med and Cur. 10.04% 17.79% Last Div Inc ---> $0.8500 $0.9000 5.88% 21.49% <-IRR #YR-> 10 Dividends
Dividends Growth 15 20.88% <-IRR #YR-> 15 Dividends
Dividends Growth 20 21.33% <-IRR #YR-> 20 Dividends
Dividends Growth 25 22.50% <-IRR #YR-> 21 Dividends
Dividends Growth 5 -$1.10 $0.00 $0.00 $0.00 $0.00 $2.84 Dividends Growth 5
Dividends Growth 10 -$0.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.84 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.84 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.84 Dividends Growth 20
Dividends Growth 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.84 Dividends Growth 25
Historical Dividends Historical High Div 5.90% Low Div 0.38% 10 Yr High 13.89% 10 Yr Low 1.38% Med Div 1.13% Close Div 1.18% Historical Dividends
High/Ave/Median Values Curr diff Exp. -24.66%     1069.74% Exp. -68.00% 222.10% Cheap 293.36% Cheap 278.21% High/Ave/Median 
Future Div Yield Div Yd 11.47% earning in 5 Years at IRR of 20.87% Div Inc. 157.95% Future Div Yield
Future Div Yield Div Yd 29.58% earning in 10 Years at IRR of 20.87% Div Inc. 565.41% Future Div Yield
Div Yield 76.30% earning in 15 Years at IRR of 20.87% Div Inc. 1616.44% Future Dividend Yield
Div Paid $9.29 earning in 5 Years at IRR of 20.87% Div Inc. 157.95% Future Dividend Paid
Div Paid $23.95 earning in 10 Years at IRR of 20.87% Div Inc. 565.41% Future Dividend Paid
Div Paid $61.79 earning in 15 Years at IRR of 20.87% Div Inc. 1616.44% Future Dividend Paid
Total Div $27.25 over 5 Years at IRR of 20.87% Div Cov. 33.65% Dividend Covering Cost
Total Div $88.26 over 10 Years at IRR of 20.87% Div Cov. 108.97% Dividend Covering Cost
Total Div $245.63 over 15 Years at IRR of 20.87% Div Cov. 303.28% Dividend Covering Cost
I am earning GC Div Gr 757.14% 9/21/12 # yrs -> 10 2012 $31.82 Cap Gain 154.53% I am earning GC
I am earning Div org yield 1.32% 12/31/15 Traading Div G Yrly 92.64% Div start $0.42 -1.32% 11.31% I am earning Div
Yield if held 5 years 1.32% 1.16% 1.23% 1.29% 3.04% 2.36% 2.34% 3.32% 4.14% 3.60% 4.88% 5.34% 6.83% 8.96% 9.96% 13.53% 3.46% <-Median-> 10 Paid Median Price Years 
Yield if held 10 years 5.16% 6.25% 7.03% 6.50% 8.04% 4.34% 3.09% 3.35% 3.60% 5.08% 4.25% 4.67% 8.56% 10.98% 8.88% 10.64% 4.51% <-Median-> 10 Paid Median Price 5
Yield if held 15 years 14.32% 9.41% 9.11% 15.44% 23.97% 17.02% 16.68% 19.10% 18.14% 13.42% 7.83% 6.16% 8.65% 9.53% 12.52% 9.27% 16.06% <-Median-> 10 Paid Median Price 10
Yield if held 20 years 21.40% 38.75% 47.23% 25.10% 24.74% 43.10% 40.00% 30.70% 33.27% 49.27% 48.05% 33.08% 17.08% 36.01% <-Median-> 10 Paid Median Price 15
Yield if held 25 years 59.75% 64.66% 85.16% 50.06% 63.81% 114.17% 98.63% 66.98% 63.81% <-Median-> 5 Paid Median Price 20
Yield if held 30 years 158.31% 159.42% 185.81% #NUM! <-Median-> 0 Paid Median Price 25
Cost covered if held 5 years 4.67% 3.98% 4.35% 4.60% 8.29% 7.78% 9.15% 12.94% 15.92% 14.15% 19.12% 21.48% 25.57% 32.40% 41.42% 63.62% 13.55% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 25.36% 30.24% 34.97% 32.78% 29.43% 19.00% 16.04% 17.43% 18.43% 28.23% 24.44% 27.94% 44.97% 55.60% 51.10% 69.14% 26.19% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 70.35% 46.60% 47.52% 83.40% 95.02% 81.55% 95.42% 109.46% 102.48% 82.13% 49.70% 40.82% 49.80% 52.87% 80.30% 68.02% 82.76% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 115.64% 153.58% 226.23% 144.67% 143.99% 249.03% 252.14% 201.92% 229.31% 293.92% 276.15% 219.72% 129.98% 214.07% <-Median-> 10 Paid Median Price
Cost covered if held 25 years 345.29% 407.56% 560.16% 346.14% 382.87% 661.73% 662.35% 516.76% 382.87% <-Median-> 5 Paid Median Price
Cost covered if held 30 years 917.53% 1070.61% 1433.58% #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $17,669 $22,282 $24,394 $17,491 $32,854 $49,530 $164,220 180.32% <-Total Growth 5 Revenue Growth  180.32%
AEPS Growth $1.19 $2.67 $3.18 -$0.64 $6.25 $11.19 $23.84 840.34% <-Total Growth 5 AEPS Growth 840.34%
Net Income Growth $2,397 $2,591 $5,416 -$435 $7,664 $10,937 $28,570 356.28% <-Total Growth 5 Net Income Growth 356.28%
Cash Flow Growth $7,262 $10,121 $8,829 $4,714 $14,478 $19,391 $64,795 167.02% <-Total Growth 5 Cash Flow Growth 167.02%
Dividend Growth $1.10 $1.34 $1.46 $1.65 $1.84 $2.84 $10.22 157.95% <-Total Growth 5 Dividend Growth 157.95%
Stock Price Growth $44.92 $32.94 $42.00 $30.59 $53.45 $75.19 67.39% <-Total Growth 5 Stock Price Growth 67.39%
Revenue Growth  $16,195 $17,945 $21,301 $13,167 $11,098 $17,669 $22,282 $24,394 $17,491 $32,854 $49,530 $243,926 205.84% <-Total Growth 10 Revenue Growth  205.84%
AEPS Growth $1.47 $2.23 $3.47 $0.24 -$0.61 $1.19 $2.67 $3.18 -$0.64 $6.25 $11.19 $30.64 661.22% <-Total Growth 10 AEPS Growth 661.22%
Net Income Growth $1,892 $2,270 $3,929 -$637 -$204 $2,397 $2,591 $5,416 -$435 $7,664 $10,937 $35,820 478.07% <-Total Growth 10 Net Income Growth 478.07%
Cash Flow Growth $6,209 $7,218 $8,459 $5,632 $3,452 $7,262 $10,121 $8,829 $4,714 $14,478 $19,391 $95,765 212.30% <-Total Growth 10 Cash Flow Growth 212.30%
Dividend Growth $0.41 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $2.84 600.62% <-Total Growth 10 Dividend Growth 600.62%
Stock Price Growth $28.64 $35.94 $35.92 $30.22 $42.79 $44.92 $32.94 $42.00 $30.59 $53.45 $75.19 162.53% <-Total Growth 10 Stock Price Growth 162.53%
Dividends on Shares $16.80 $30.63 $32.03 $32.20 $38.50 $46.90 $51.10 $57.75 $64.23 $151.81 $124.25 $126.00 $126.00 $521.94 No of Years 10 Total Divs 12/31/12
Paid  $1,002.40 $1,257.90 $1,257.20 $1,057.70 $1,497.65 $1,572.20 $1,152.90 $1,470.00 $1,070.65 $1,870.75 $2,631.65 $2,834.65 $2,834.65 $2,834.65 $2,631.65 No of Years 10 Worth $28.64
Total $3,153.59
Graham No. AEPS $31.96 $32.87 $27.12 $34.49 $45.45 $11.60 $11.30 $26.33 $39.98 $45.93 $44.24 $66.68 $93.36 $77.70 $82.84 $85.71 244.27% <-Total Growth 10 Graham Price AEPS
Price/GP Ratio Med 1.21 1.20 1.22 0.94 0.89 2.92 3.04 1.58 0.99 0.79 0.60 0.62 0.80 0.97 0.91 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.40 1.51 1.49 1.04 1.08 3.62 4.06 1.78 1.22 0.92 0.95 0.80 0.93 1.07 1.06 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.03 0.88 0.95 0.83 0.70 2.21 2.03 1.38 0.76 0.66 0.25 0.43 0.67 0.88 0.73 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.39 1.16 1.06 1.04 0.79 2.60 3.79 1.71 0.82 0.91 0.69 0.80 0.81 1.04 0.98 0.94 0.87 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 38.76% 16.05% 5.61% 4.22% -20.97% 160.45% 278.69% 70.62% -17.60% -8.55% -30.85% -19.85% -19.47% 4.24% -2.24% -5.50% -13.08% <-Median-> 10 Graham Price
Graham No. EPS $25.99 $33.58 $29.33 $33.31 $46.17 $33.74 $32.86 $34.39 $35.62 $54.88 $63.05 $67.79 $86.12 $72.89 $76.44 $81.66 193.56% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 1.49 1.17 1.13 0.97 0.88 1.00 1.05 1.21 1.11 0.66 0.42 0.61 0.87 1.04 0.92 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.72 1.48 1.38 1.08 1.07 1.24 1.40 1.36 1.37 0.77 0.67 0.79 1.01 1.14 1.07 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.27 0.86 0.88 0.86 0.69 0.76 0.70 1.06 0.85 0.55 0.18 0.43 0.72 0.94 0.71 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.71 1.14 0.98 1.08 0.78 0.90 1.30 1.31 0.92 0.77 0.49 0.79 0.87 1.11 1.06 0.99 0.88 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 70.67% 13.60% -2.37% 7.91% -22.20% -10.45% 30.21% 30.64% -7.53% -23.47% -51.48% -21.16% -12.69% 11.12% 5.96% -0.82% -11.57% <-Median-> 10 Graham Price
presplit '04
presplit '05
presplit '10
Price Close $44.35 $38.15 $28.64 $35.94 $35.92 $30.22 $42.79 $44.92 $32.94 $42.00 $30.59 $53.45 $75.19 $80.99 $80.99 $80.99 162.53% <-Total Growth 10 Stock Price
Increase 16.71% -13.98% -24.93% 25.49% -0.06% -15.87% 41.59% 4.98% -26.67% 27.50% -27.17% 74.73% 40.67% 7.71% 0.00% 0.00% 18.13 <-Median-> 10 CAPE (10 Yr P/E)
P/E 28.43 15.90 16.65 17.28 10.03 -52.10 -225.21 22.13 15.54 9.25 -82.68 8.27 7.90 11.88 10.80 9.46 10.85% <-IRR #YR-> 5 Stock Price 67.39%
Trailing P/E 30.38 24.46 11.93 20.90 17.27 8.44 -73.78 -236.42 16.23 19.81 6.74 -144.46 11.64 8.51 11.88 10.80 10.13% <-IRR #YR-> 10 Stock Price 162.53%
CAPE (10 Yr P/E) 13.71 14.20 14.50 15.27 14.76 15.88 18.61 19.46 22.98 19.52 20.89 17.64 14.52 13.82 13.58 12.02 14.47% <-IRR #YR-> 5 Price & Dividend 93.48%
Median 10, 5 Yrs D.  per yr 2.95% 3.62% % Tot Ret 22.54% 24.99% T P/E $10.04 $11.64 P/E:  $8.76 $8.27 13.08% <-IRR #YR-> 10 Price & Dividend 216.02%
Price 15 D.  per yr 1.77% % Tot Ret 26.22% CAPE Diff -34.49% 4.98% <-IRR #YR-> 15 Stock Price 107.19%
Price  20 D.  per yr 2.49% % Tot Ret 15.43% 13.62% <-IRR #YR-> 20 Stock Price 1185.30%
Price  25 D.  per yr 1.87% % Tot Ret 12.85% 12.65% <-IRR #YR-> 25 Stock Price 1865.75%
Price 30 D.  per yr 1.50% % Tot Ret 10.75% 12.46% <-IRR #YR-> 30 Stock Price
Price 35 D.  per yr 2.55% % Tot Ret 11.30% 20.00% <-IRR #YR-> 32 Stock Price
Price & Dividend 15 6.75% <-IRR #YR-> 15 Price & Dividend 152.67%
Price & Dividend 20 16.10% <-IRR #YR-> 20 Price & Dividend 1475.65%
Price & Dividend 25 14.52% <-IRR #YR-> 25 Price & Dividend 2310.87%
Price & Dividend 30 13.96% <-IRR #YR-> 30 Price & Dividend
Price & Dividend 35 22.55% <-IRR #YR-> 32 Stock Price
Price  5 -$44.92 $0.00 $0.00 $0.00 $0.00 $75.19 Price  5
Price 10 -$28.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.19 Price 10
Price & Dividend 5 -$44.92 $1.34 $1.46 $1.65 $1.84 $79.53 Price & Dividend 5
Price & Dividend 10 -$28.64 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $79.53 Price & Dividend 10
Price 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.19 Price 15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.19 Price  20
Price  25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.19 Price  25
Price 30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.19 Price 30
Price 35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.19 Price 35
Price & Dividend 15 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $79.53 Price & Dividend 15
Price & Dividend 20 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $79.53 Price & Dividend 20
Price & Dividend 25 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $79.53 Price & Dividend 25
Price & Dividend 30 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $79.53 Price & Dividend 30
Price & Dividend 35 $0.28 $0.35 $0.41 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $79.53 Price & Dividend 35
Price H/L Med. $38.83 $39.30 $33.16 $32.34 $40.52 $33.84 $34.38 $41.54 $39.61 $36.15 $26.60 $41.17 $74.67 $75.75 125.18% <-Total Growth 10 Stock Price
Increase 35.04% 1.21% -15.62% -2.47% 25.29% -16.50% 1.60% 20.83% -4.65% -8.74% -26.41% 54.77% 81.37% 1.45% 8.46% <-IRR #YR-> 10 Stock Price 125.18%
P/E 24.89 16.38 19.28 15.55 11.32 -58.34 -180.92 20.46 18.68 7.96 -71.89 6.37 7.84 11.11 12.45% <-IRR #YR-> 5 Stock Price 79.78%
Trailing P/E 26.60 25.19 13.82 18.80 19.48 9.45 -59.27 -218.61 19.51 17.05 5.86 -111.27 11.56 7.96 11.21% <-IRR #YR-> 10 Price & Dividend 171.37%
Forward P/E  16.18 22.85 15.94 9.03 -69.86 -178.08 16.93 19.59 8.72 -97.69 4.12 4.32 10.95 10.10 16.23% <-IRR #YR-> 5 Price & Dividend 108.00%
P/E on Running 5 yr Average 15.66 15.78 14.11 17.54 17.87 18.39 26.00 30.01 28.45 22.82 16.36 13.93 16.76 14.04 6.52 <-Median-> 10 Forward P/E 
P/E on Running 10 yr Average 22.67 20.81 16.53 15.49 17.50 15.66 18.04 22.25 24.48 18.77 15.35 19.25 25.58 22.33 14.34 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 2.76% 3.78% % Tot Ret 24.59% 23.31% T P/E 10.50 11.56 P/E:  7.90 7.84 Count 28 Years of data
-$33.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $74.67
-$41.54 $0.00 $0.00 $0.00 $0.00 $74.67
-$33.16 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $79.01
-$41.54 $1.34 $1.46 $1.65 $1.84 $79.01
High Months Dec Mar Feb Dec Jul Apr Dec Nov Jul Apr Jan Dec May Apr
presplit '04
presplit '05
presplit '10
Price High $44.70 $49.70 $40.48 $35.94 $49.19 $42.00 $45.85 $46.74 $48.97 $42.17 $42.00 $53.45 $87.04 $82.85 115.02% <-Total Growth 10 Stock Price
Increase 13.91% 11.19% -18.55% -11.22% 36.87% -14.62% 9.17% 1.94% 4.77% -13.89% -0.40% 27.26% 62.84% -4.81% 7.96% <-IRR #YR-> 10 Stock Price 115.02%
P/E 28.65 20.71 23.53 17.28 13.74 -72.41 -241.32 23.02 23.10 9.29 -113.51 8.27 9.14 12.15 13.24% <-IRR #YR-> 5 Stock Price 86.22%
Trailing P/E 30.62 31.86 16.87 20.90 23.65 11.73 -79.05 -246.00 24.12 19.89 9.25 -144.46 13.47 8.70 16.23 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 12.60 13.47 P/E:  9.22 9.14 28.65 P/E Ratio Historical High
-$40.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $87.04
-$46.74 $0.00 $0.00 $0.00 $0.00 $87.04
Low Months Aug Oct Jul Jan Dec Oct Jan Jul Dec Aug Mar Jan Jan Mar
presplit '04
presplit '05
presplit '10
Price Low $32.96 $28.90 $25.84 $28.74 $31.85 $25.67 $22.90 $36.33 $30.24 $30.12 $11.20 $28.89 $62.30 $68.65 141.10% <-Total Growth 10 Stock Price
Increase 80.41% -12.32% -10.59% 11.22% 10.82% -19.40% -10.79% 58.65% -16.76% -0.40% -62.82% 157.95% 115.65% 10.19% 9.20% <-IRR #YR-> 10 Stock Price 141.10%
P/E 21.13 12.04 15.02 13.82 8.90 -44.26 -120.53 17.90 14.26 6.63 -30.27 4.47 6.54 10.07 11.39% <-IRR #YR-> 5 Stock Price 71.48%
Trailing P/E 22.58 18.53 10.77 16.71 15.31 7.17 -39.48 -191.21 14.90 14.21 2.47 -78.08 9.64 7.21 10.26 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 8.41 9.64 P/E:  6.59 6.54 4.46 P/E Ratio Historical Low
-$25.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $62.30
Free Cash Flow WSJ $514 -$700 $2,688 $5,946 $5,294 $2,159 $9,986 $14,288 2679.77% <-Total Growth 7 Free Cash Flow WSJ, Mkt Scn
Change -236.19% 484.00% 121.21% -10.97% -59.22% 362.53% 43.08% $0.43 <-Median-> 7 Change MS
Free Cash Flow MS $947 $42 $105 $151 -$2,939 $1,164 -$345 $2,564 $5,680 $5,221 $2,154 $9,985 $14,290 $11,085 $11,817 $9,024 13509.52% <-Total Growth 10 Free Cash Flow Disagree
Change -95.56% 150.00% 43.81% -2046% 139.61% -129.64% 843.19% 121.53% -8.08% -58.74% 363.56% 43.11% -22.43% 6.60% -23.64% 41.00% <-IRR #YR-> 5 Free Cash Flow MS 457.33%
FCF/CF from Op Ratio 0.15 0.01 0.02 0.02 -0.35 0.21 -0.10 0.35 0.56 0.59 0.46 0.69 0.74 0.71 0.67 0.49 63.45% <-IRR #YR-> 10 Free Cash Flow MS 13509.52%
Dividends paid $302 $378 $444 $523 $955 $1,251 $758 $1,252 $1,562 $1,743 $1,950 $2,170 $4,926 $3,914 $3,969 $3,969 1009.46% <-Total Growth 10 Dividends paid
Percentage paid 107.47% -219.71% 48.83% 27.50% 33.38% 90.53% 21.73% 34.47% 35.31% 33.59% 43.99% $0.34 <-Median-> 8 Percentage paid
5 Year Coverage 45.97% 47.56% 33.89% 33.09% 34.41% 34.32% 33.72% 5 Year Coverage
Dividend Coverage Ratio 0.93 -0.46 2.05 3.64 3.00 1.10 4.60 2.90 2.83 2.98 2.27 2.47 <-Median-> 8 Dividend Coverage Ratio
5 Year of Coverage 2.18 2.10 2.95 3.02 2.91 2.91 2.97 5 Year of Coverage
Market Cap $M $48,379 $41,830 $31,277 $39,078 $39,219 $33,081 $47,538 $54,927 $39,590 $49,848 $36,214 $62,449 $82,907 $89,302 $89,302 $89,302 165.07% <-Total Growth 10 Market Cap 165.07%
Diluted # of Shares in Million 1,095.65 1,102.58 1,099.52 1,090.54 1,096.82 1,093.86 1,100.47 1,182.82 1,223.76 1,193.11 1,181.77 1,186.56 1,149.18 1,149.18 4.52% <-Total Growth 10 Diluted
Change 1.09% 0.63% -0.28% -0.82% 0.58% -0.27% 0.60% 7.48% 3.46% -2.50% -0.95% 0.41% -3.15% 0.00% 0.07% <-Median-> 10 Change
Difference Diluted/Basic -0.7% -0.6% -0.2% -0.2% -0.5% 0.0% 0.0% -0.7% -0.4% -0.2% 0.0% -0.4% -1.2% -1.2% -0.29% <-Median-> 10 Difference Diluted/Basic
Basic # of Shares in Millions 1,088.10 1,095.58 1,097.08 1,088.68 1,091.75 1,093.86 1,100.47 1,175.09 1,218.80 1,190.98 1,181.77 1,181.25 1,134.96 1,134.96 3.45% <-Total Growth 10 Basic
Change 0.42% 0.69% 0.14% -0.77% 0.28% 0.19% 0.60% 6.78% 3.72% -2.28% -0.77% -0.04% -3.92% 0.00% 0.07% <-Median-> 10 Change
Difference Basic/Outstanding 0.3% 0.1% -0.5% -0.1% 0.0% 0.1% 1.0% 4.1% -1.4% -0.3% 0.2% -1.1% -2.8% -2.8% -0.06% <-Median-> 10 Difference Basic/Outstanding
# of Share in Millions 1,090.85 1,096.46 1,092.07 1,087.32 1,091.84 1,094.67 1,110.95 1,222.77 1,201.89 1,186.86 1,183.87 1,168.37 1,102.64 1,102.64 1,102.64 1,102.64 0.10% <-IRR #YR-> 10 Shares 0.97%
Change 0.57% 0.51% -0.40% -0.43% 0.42% 0.26% 1.49% 10.06% -1.71% -1.25% -0.25% -1.31% -5.63% 0.00% 0.00% 0.00% -2.05% <-IRR #YR-> 5 Shares -9.82%
CF from Operations $Million $6,284 $6,243 $6,209 $7,218 $8,459 $5,632 $3,452 $7,262 $10,121 $8,829 $4,714 $14,478 $19,391 $15,657 $17,642 $18,414 212.30% <-Total Growth 10 Cash Flow
Increase 8.12% -0.65% -0.54% 16.25% 17.19% -33.42% -38.71% 110.37% 39.37% -12.77% -46.61% 207.13% 33.93% -19.25% 12.68% 4.38% SO  Buy Backs S. Issues (Purchases)
5 year Running Average $5,772 $6,185 $6,263 $6,353 $6,883 $6,752 $6,194 $6,405 $6,985 $7,059 $6,876 $9,081 $11,507 $12,614 $14,377 $17,117 83.72% <-Total Growth 10 CF 5 Yr Running
CFPS $5.76 $5.69 $5.69 $6.64 $7.75 $5.14 $3.11 $5.94 $8.42 $7.44 $3.98 $12.39 $17.59 $14.20 $16.00 $16.70 209.31% <-Total Growth 10 Cash Flow per Share
Increase 7.51% -1.16% -0.14% 16.76% 16.71% -33.59% -39.61% 91.13% 41.79% -11.66% -46.47% 211.20% 41.92% -19.25% 12.68% 4.38% 12.06% <-IRR #YR-> 10 Cash Flow 212.30%
5 year Running Average $5.33 $5.69 $5.75 $5.83 $6.31 $6.18 $5.66 $5.72 $6.07 $6.01 $5.78 $7.63 $9.96 $11.12 $12.83 $15.38 21.71% <-IRR #YR-> 5 Cash Flow 167.02%
P/CF on Med Price 6.74 6.90 5.83 4.87 5.23 6.58 11.06 6.99 4.70 4.86 6.68 3.32 4.25 5.33 0.00 0.00 11.95% <-IRR #YR-> 10 Cash Flow per Share 209.31%
P/CF on Closing Price 7.70 6.70 5.04 5.41 4.64 5.87 13.77 7.56 3.91 5.65 7.68 4.31 4.28 5.70 5.06 4.85 24.25% <-IRR #YR-> 5 Cash Flow per Share 196.11%
12.92% Diff M/C 5.65% <-IRR #YR-> 10 CFPS 5 yr Running 73.27%
Excl.Working Capital CF -$149.0 $36.0 -$447.0 $33.0 $744.0 -$239.0 $542.0 -$299 -$1,346 $1,033 $166 -$964 -$79 0.00% 0.00% 0.00% 11.76% <-IRR #YR-> 5 CFPS 5 yr Running 74.33%
CF fr Op $M WC $6,135 $6,279 $5,762 $7,251 $9,203 $5,393 $3,994 $6,963 $8,775 $9,862 $4,880 $13,514 $19,312 $15,657 $17,642 $18,414 235.16% <-Total Growth 10 Cash Flow less WC
Increase 1.46% 2.35% -8.23% 25.84% 26.92% -41.40% -25.94% 74.34% 26.02% 12.39% -50.52% 176.93% 42.90% -18.92% 12.68% 4.38% 12.86% <-IRR #YR-> 10 Cash Flow less WC 235.16%
5 year Running Average $6,032 $6,316 $6,236 $6,295 $6,926 $6,778 $6,321 $6,561 $6,866 $6,997 $6,895 $8,799 $11,269 $12,645 $14,201 $16,908 22.63% <-IRR #YR-> 5 Cash Flow less WC 177.35%
CFPS Excl. WC $5.62 $5.73 $5.28 $6.67 $8.43 $4.93 $3.60 $5.69 $7.30 $8.31 $4.12 $11.57 $17.51 $14.20 $16.00 $16.70 6.10% <-IRR #YR-> 10 CF less WC 5 Yr Run 80.71%
Increase 0.88% 1.82% -7.87% 26.39% 26.40% -41.55% -27.03% 58.39% 28.21% 13.81% -50.39% 180.60% 51.42% -18.92% 12.68% 4.38% 11.42% <-IRR #YR-> 5 CF less WC 5 Yr Run 71.76%
5 year Running Average $5.57 $5.81 $5.73 $5.77 $6.34 $6.21 $5.78 $5.86 $5.99 $5.97 $5.80 $7.40 $9.76 $11.14 $12.68 $15.20 12.75% <-IRR #YR-> 10 CFPS - Less WC 231.95%
P/CF on Med Price 6.90 6.86 6.28 4.85 4.81 6.87 9.56 7.29 5.42 4.35 6.45 3.56 4.26 5.33 0.00 0.00 25.20% <-IRR #YR-> 5 CFPS - Less WC 207.57%
P/CF on Closing Price 7.89 6.66 5.43 5.39 4.26 6.13 11.90 7.89 4.51 5.05 7.42 4.62 4.29 5.70 5.06 4.85 5.48% <-IRR #YR-> 10 CFPS 5 yr Running 70.49%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 5.05 5 yr  4.70 P/CF Med 10 yr 5.14 5 yr  4.35 11.03% Diff M/C 10.74% <-IRR #YR-> 5 CFPS 5 yr Running 66.52%
-$5.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.59 Cash Flow per Share
-$5.94 $0.00 $0.00 $0.00 $0.00 $17.59 Cash Flow per Share
-$5.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.96 CFPS 5 yr Running
-$5.72 $0.00 $0.00 $0.00 $0.00 $9.96 CFPS 5 yr Running
-$5,762 $0 $0 $0 $0 $0 $0 $0 $0 $0 $19,312 Cash Flow less WC
-$6,963 $0 $0 $0 $0 $19,312 Cash Flow less WC
-$6,236 $0 $0 $0 $0 $0 $0 $0 $0 $0 $11,269 CF less WC 5 Yr Run
-$6,561 $0 $0 $0 $0 $11,269 CF less WC 5 Yr Run
OPM 43.88% 40.26% 38.34% 40.22% 39.71% 42.77% 31.10% 41.10% 45.42% 36.19% 26.95% 44.07% 39.15% 42.11% 2.12% <-Total Growth 10 OPM
Increase -16.37% -8.24% -4.77% 4.91% -1.27% 7.71% -27.28% 32.14% 10.52% -20.32% -25.54% 63.51% -11.16% 7.55% Should increase  or be stable.
Diff from Median 9.78% 0.73% -4.07% 0.64% -0.64% 7.02% -22.17% 2.83% 13.65% -9.44% -32.57% 10.26% -2.04% 5.35% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 39.97% 5 Yrs 41.10% should be  zero, it is a   check on calculations
Long Term Debt $8,499 $8,212 $7,938 $8,217 $13,022 $15,065 $14,993 $20,581 $19,482 $18,591 $20,110 $13,694 $11,041 $11,041 39.09% <-Total Growth 10 Debt
Change -12.00% -3.38% -3.34% 3.51% 58.48% 15.69% -0.48% 37.27% -5.34% -4.57% 8.17% -31.90% -19.37% 0.00% 1.52% <-Median-> 10 Change
Debt/Market Cap Ratio 0.18 0.20 0.25 0.21 0.33 0.46 0.32 0.37 0.49 0.37 0.56 0.22 0.13 0.12 0.35 <-Median-> 10 Debt/Market Cap Ratio
Assets/Current Liabilities Ratio 13.52 11.72 12.32 9.89 11.71 12.90 11.52 11.80 15.03 11.77 14.82 10.33 8.80 8.80 11.74 <-Median-> 10 Assets/Current Liabilities Ratio
Debt to Cash Flow (Years) 1.35 1.32 1.28 1.14 1.54 2.67 4.34 2.83 1.92 2.11 4.27 0.95 0.57 0.71 2.02 <-Median-> 10 Debt to Cash Flow (Years)
Intangibles $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.00% <-Total Growth 10 Intangibles
Goodwill $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.00% <-Total Growth 10 Goodwill
Total $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.00% <-Total Growth 10 Total
Change 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 Change
Intangible/Market Cap Ratio 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 Intangible/Market Cap Ratio
Current Assets $2,172 $2,781 $1,914 $2,216 $3,489 $4,059 $4,336 $4,897 $3,020 $4,487 $4,361 $5,942 $7,057 $7,057 Liquidity ratio of 1.5 and up, best
Current Liabilities $3,156 $4,034 $3,976 $5,234 $5,142 $4,595 $5,092 $6,261 $4,762 $6,637 $5,078 $7,422 $8,651 $8,651 0.79 <-Median-> 10 Ratio
Liquidity 0.69 0.69 0.48 0.42 0.68 0.88 0.85 0.78 0.63 0.68 0.86 0.80 0.82 0.82 0.80 <-Median-> 5 Ratio
Liq. with CF aft div 2.58 2.14 1.93 1.70 2.14 1.89 1.33 1.73 2.42 1.75 1.40 2.46 2.70 2.17 2.42 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.96 0.86 0.78 0.73 0.67 0.86 0.76 0.56 1.20 0.83 0.90 1.64 1.71 2.17 1.20 <-Median-> 5 Ratio
Current portion L T D. $814 $953 $1,719 $980 $1,729 $1,812 $1,877 $1,141 $2,391 $1,343 $1,000 $404 $404
Liquidity 0.86 0.63 0.63 0.84 1.42 1.32 1.12 0.83 1.06 1.17 0.93 0.86 0.86 0.93 <-Median-> 5 Ratio
Liq. with CF aft div 2.69 2.54 2.54 2.64 3.03 2.06 2.47 3.18 2.73 1.91 2.85 2.83 2.28 2.83 <-Median-> 5 Ratio
Assets $42,669 $47,278 $48,980 $51,754 $60,200 $59,275 $58,648 $73,867 $71,559 $78,121 $75,276 $76,665 $76,142 $76,142 Debt Ratio of 1.5 and up, best
Liabilities $21,684 $24,380 $24,697 $25,982 $31,309 $31,984 $32,381 $42,214 $39,585 $43,130 $42,896 $39,720 $37,967 $37,967 1.83 <-Median-> 10 Ratio
Debt Ratio 1.97 1.94 1.98 1.99 1.92 1.85 1.81 1.75 1.81 1.81 1.75 1.93 2.01 2.01 1.81 <-Median-> 5 Ratio
Estimates BVPS $36.50 $38.50 $40.40 Estimates Estimates BVPS
Estimate Book Value $40,246.2 $42,451.5 $44,546.5 Estimates Estimate Book Value
P/B Ratio (Close) 2.22 2.10 2.00 Estimates P/B Ratio (Close)
Difference from 10 year median 57.46% Diff M/C Estimates Difference from 10 yr med.
Book Value $20,985 $22,898 $24,283 $25,772 $28,891 $27,291 $26,267 $31,653 $31,974 $34,991 $32,380 $36,945 $38,175 $38,175 $38,175 $38,175 57.21% <-Total Growth 10 Book Value
Book Value per share $19.24 $20.88 $22.24 $23.70 $26.46 $24.93 $23.64 $25.89 $26.60 $29.48 $27.35 $31.62 $34.62 $34.62 $34.62 $34.62 55.70% <-Total Growth 10 Book Value per Share
Change 7.41% 8.56% 6.47% 6.60% 11.64% -5.78% -5.16% 9.49% 2.77% 10.82% -7.23% 15.61% 9.49% 0.00% 0.00% 0.00% 45.79% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.02 1.88 1.49 1.36 1.53 1.36 1.45 1.60 1.49 1.23 0.97 1.30 2.16 2.19 0.00 0.00 1.60 P/B Ratio Historical Median
P/B Ratio (Close) 2.31 1.83 1.29 1.52 1.36 1.21 1.81 1.74 1.24 1.42 1.12 1.69 2.17 2.34 2.34 2.34 4.53% <-IRR #YR-> 10 Book Value per Share 55.70%
Change 8.66% -20.76% -29.49% 17.72% -10.48% -10.71% 49.30% -4.12% -28.65% 15.05% -21.49% 51.14% 28.48% 7.71% 0.00% 0.00% 5.99% <-IRR #YR-> 5 Book Value per Share 33.74%
Median 10 year P/B Ratio 1.81 1.95 1.95 1.95 1.95 1.74 1.57 1.57 1.51 1.49 1.47 1.41 1.41 1.47 1.47 <-Median-> 5 Median 10 year P/B Ratio
Leverage (A/BK) 2.03 2.06 2.02 2.01 2.08 2.17 2.23 2.33 2.24 2.23 2.32 2.08 1.99 1.99 2.20 <-Median-> 10 A/BV
Debt/Equity Ratio 1.03 1.06 1.02 1.01 1.08 1.17 1.23 1.33 1.24 1.23 1.32 1.08 0.99 0.99 1.20 <-Median-> 10 Debt/Eq Ratio
Sharerholders' Equity P/BV 10 yr Med 1.41 5 yr Med 1.30 66.01% Diff M/C 2.32 Historical 27 A/BV
-$22.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.62
-$25.89 $0.00 $0.00 $0.00 $0.00 $34.62
Comprehensive Income $1,634 $2,660 $1,924 $2,254 $3,938 -$613 -$209 $2,259 $2,781 $5,328 -$461 $7,655 $11,147 479.37% <-Total Growth 10 Comprehensive Income
Increase 34.60% 62.79% -27.67% 17.15% 74.71% -115.57% 65.91% 1180.86% 23.11% 91.59% -108.65% 1760.52% 45.62% 45.62% <-Median-> 5 Comprehensive Income
5 Yr Running Average $2,615 $2,643 $2,521 $1,937 $2,482 $2,033 $1,459 $1,526 $1,631 $1,909 $1,940 $3,512 $5,290 19.21% <-IRR #YR-> 10 Comprehensive Income 479.37%
ROE 7.8% 11.6% 7.9% 8.7% 13.6% -2.2% -0.8% 7.1% 8.7% 15.2% -1.4% 20.7% 29.2% 37.61% <-IRR #YR-> 5 Comprehensive Income 393.45%
5Yr Median 19.0% 11.6% 7.9% 7.9% 8.7% 8.7% 7.9% 7.1% 7.1% 7.1% 7.1% 8.7% 15.2% 7.69% <-IRR #YR-> 10 5 Yr Running Average 109.80%
% Difference from NI -3.7% 0.6% 1.7% -0.7% 0.2% -3.8% 2.5% -5.8% 7.3% -1.6% 6.0% -0.1% 1.9% 28.23% <-IRR #YR-> 5 5 Yr Running Average 246.70%
Median Values Diff 5, 10 yr 0.1% 1.9% 15.2% <-Median-> 5 Return on Equity
-$1,924 $0 $0 $0 $0 $0 $0 $0 $0 $0 $11,147
-$2,259 $0 $0 $0 $0 $11,147
-$2,521 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,290
-$1,526 $0 $0 $0 $0 $5,290
Current Liability Coverage Ratio 1.94 1.56 1.45 1.39 1.79 1.17 0.78 1.11 1.84 1.49 0.96 1.82 2.23 1.81   CFO / Current Liabilities
5 year Median 1.94 1.94 1.94 1.56 1.56 1.45 1.39 1.17 1.17 1.17 1.11 1.49 1.82 1.81 143.6% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 14.38% 13.28% 11.76% 14.01% 15.29% 9.10% 6.81% 9.43% 12.26% 12.62% 6.48% 17.63% 25.36% 20.56% CFO / Total Assets
5 year Median 14.74% 14.74% 14.38% 14.01% 14.01% 13.28% 11.76% 9.43% 9.43% 9.43% 9.43% 12.26% 12.62% 17.63% 12.4% <-Median-> 10 Return on Assets 
Return on Assets ROA 4.0% 5.6% 3.9% 4.4% 6.5% -1.1% -0.3% 3.2% 3.6% 6.9% -0.6% 10.0% 14.4% 11.3% Net  Income/Assets Return on Assets ROA
5Yr Median 7.2% 5.6% 4.0% 4.0% 4.4% 4.4% 3.9% 3.2% 3.2% 3.2% 3.2% 3.6% 6.9% 10.0% 4.0% <-Median-> 10 Asset Efficiency Ratio ROA
Return on Equity ROE 8.1% 11.5% 7.8% 8.8% 13.6% -2.3% -0.8% 7.6% 8.1% 15.5% -1.3% 20.7% 28.6% 22.6% Net Inc/ Shareholders' equity Return on Equity ROE
5Yr Median 19.6% 11.5% 8.1% 8.1% 8.8% 8.8% 7.8% 7.6% 7.6% 7.6% 7.6% 8.1% 15.5% 20.7% 8.5% <-Median-> 10 Return on Equity ROE
Net Income $1,697 $2,643 $1,892 $2,270 $3,929 -$637 -$204 $2,397 $2,591 $5,416 -$435 $7,664 $10,937 $8,629 $6,299 478.07% <-Total Growth 10 Net Income
Increase 7.41% 55.75% -28.41% 19.98% 73.08% -116.21% 67.97% 1275.00% 8.09% 109.03% -108.03% 1861.84% 42.71% -21.10% -27.00% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $2,679 $2,703 $2,559 $2,016 $2,486 $2,019 $1,450 $1,551 $1,615 $1,913 $1,953 $3,527 $5,235 $6,442 $6,619 19.18% <-IRR #YR-> 10 Net Income 478.07%
Operating Cash Flow $6,284 $6,243 $6,209 $7,218 $8,459 $5,632 $3,452 $7,262 $10,121 $8,829 $4,714 $14,478 $19,391 35.47% <-IRR #YR-> 5 Net Income 356.28%
Investment Cash Flow -$5,327 -$5,963 -$5,927 -$7,006 -$11,177 -$5,465 -$3,811 -$13,102 -$4,814 -$7,255 -$2,819 -$3,703 -$4,987 7.42% <-IRR #YR-> 10 5 Yr Running Average 104.52%
Total Accruals $740 $2,363 $1,610 $2,058 $6,647 -$804 $155 $8,237 -$2,716 $3,842 -$2,330 -$3,111 -$3,467 27.54% <-IRR #YR-> 5 5 Yr Running Average 237.50%
Total Assets $42,669 $47,278 $48,980 $51,754 $60,200 $59,275 $58,648 $73,867 $71,559 $78,121 $75,276 $76,665 $76,142 Balance Sheet Assets
Accruals Ratio 1.73% 5.00% 3.29% 3.98% 11.04% -1.36% 0.26% 11.15% -3.80% 4.92% -3.10% -4.06% -4.55% -3.80% <-Median-> 5 Ratio
EPS/CF Ratio 0.28 0.42 0.33 0.31 0.42 -0.12 -0.05 0.36 0.29 0.55 -0.09 0.56 0.54 0.33 <-Median-> 10 EPS/CF Ratio
-$1,892 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,937
-$2,397 $0 $0 $0 $0 $10,937
-$2,559 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,235
-$1,551 $0 $0 $0 $0 $5,235
Change in Close 16.71% -13.98% -24.93% 25.49% -0.06% -15.87% 41.59% 4.98% -26.67% 27.50% -27.17% 74.73% 40.67% 7.71% 0.00% Count 28 Years of data
up/down down down down down Count 16 57.14%
Meet Prediction? Yes Yes Yes % right Count 6 37.50%
Financial Cash Flow -$1,077 -$268 -$297 -$233 $2,727 -$123 $307 $5,960 -$5,343 -$1,536 -$1,850 -$10,215 -$14,228 C F Statement  Financial Cash Flow
Total Accruals $1,817 $2,631 $1,907 $2,291 $3,920 -$681 -$152 $2,277 $2,627 $5,378 -$480 $7,104 $10,761 Accruals
Accruals Ratio 4.26% 5.56% 3.89% 4.43% 6.51% -1.15% -0.26% 3.08% 3.67% 6.88% -0.64% 9.27% 14.13% 6.88% <-Median-> 5 Ratio
Cash $22 $34 $37 $16 $25 $69 $17 $137 $101 $139 $184 $744 $920 $920 Cash
Cash per Share $0.02 $0.03 $0.03 $0.01 $0.02 $0.06 $0.02 $0.11 $0.08 $0.12 $0.16 $0.64 $0.83 $0.83 $0.16 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.05% 0.08% 0.12% 0.04% 0.06% 0.21% 0.04% 0.25% 0.26% 0.28% 0.51% 1.19% 1.11% 1.03% 0.51% <-Median-> 5 % of Stock Price
Notes:
April 23, 2023.  Last estimates were for 2022, 2023 and 2024 of $37712M, $32877M and $33600M for Revenue, $11.97 and $11.35 for 2022/3 for AFFO, $9.99, $8.10 and $7.39 for AEPS,  $11.30, $8.16 and $6.02 for EPS, 
$2.81, $3.06 and $3.55 for Dividends, $14184M, $12999M and $9043M for FCF, $16.10 and $14.90 for CFPS 2022/3, $34.20 and $37.10 for BVPS 2022/3 and $12365M, $8629M and $6299M for Net Income.
April 17, 2022.  Last estimates were for 2021, 2022 and 2023 of $23862M, $24106M and $22636M for Revenue, $3.20, $3.08 and $2.77 for AEPS, $3.14, $3.00 and $2.69 for EPS, 
$1.84, $1.89 and $1.96 for Dividends, $7441M, $7087M and $5907M for FCF, $9.47, $9.43 and $9.16 for CFPS and $3513M, $3454M and $3178M for Net Income.
April 17, 2021.  Last estimates were for 2020, 2021 and 2022 of $16082M, $18834M, $21447M for Revenue, -$0.75, $0.87 and $2.20 for Adj EPS, -$1.05, $0.85 and $1.85 for EPS,
 $1.68, $1.72 and $1.76 for Dividends, $4.21M, $4628M and $6807M for FCF, $3.42, $5.29 and $8.18 for CFPS.-$2304M, -$129M and $2524M for Net Income.
December 31, 2020.  There was an earnings loss because of much lower Revenue for 2020.
April 11, 2020.  Last estimates were for 2019, 2020 and 2021 of $20707M, $22171M and $22554M for Revenue, $2.55, $3.02 and $2.99 for Adj EPS, 
$2.18, $2.90 and $3.91 for EPS, $7.27, $6.57 and $9.10 for CFPS and $2617M, $3483M and $3554M for Net Income.
April 14, 2019.  Last estimates were for 2018, 2019 and 2020 of $20752M, $21404M and $22612M for Revenue, $2.74, $2.54 and $2.75 for Adj EPS, 
$2.15, $1.99 and $2.53 for EPS, $8.10, $8.14 and $8.94 for CFPS, $3655m, $2319M and $2976M for Net Income.
April 14, 2018.  Last estimates were for 2017, 2018 and 2019 of $16520M, $20728M and $21785M for Revenue, $1.66, $2.79 and $3.29 for Adj EPS, 
$1.49, 2.59 and $3.27 for EPS, $6.90, $8.72 and $9.44 for CFPS and $1904M, $3153M and $4352M.
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
The company was founded on November 7, 1973 as AEX Minerals Corporation and adopted the present name in 1975.
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.
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%.
I bought another 100 shares in 2020 because the yield was 11.63%
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 
How they make their money.
Canadian Natural Resources Ltd is an independent crude oil and natural gas exploration, development, and production company. The Company's exploration and production 
operations are focused in North America, largely in Western Canada; the United Kingdom (UK) portion of the North Sea, and Cote d'Ivoire and South Africa in Offshore 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 %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2015 April 23 2016 April 14 2017 April 14 2018 April 14 2019 April 11 2020 April 17 2021 April 17 2022 April 17 2022
McKay, Timothy Shawn 1.172 0.10% 1.174 0.10% 1.193 0.11% 1.204 0.11% 0.89%
President - Shares - Amount $35.854 $62.754 $89.717 $97.495
Options - percentage 1.747 0.15% 0.498 0.04% 1.960 0.18% 3.072 0.28% 56.76%
Options - amount $53.433 $26.601 $147.361 $248.828
Stainthrope, Mark Allen 0.025 0.00% 0.027 0.00% 0.393 0.03% 0.032 0.00% 0.033 0.00% Site says Mark CFO 4.33%
CFO - Shares - Amount $1.033 $0.825 $21.007 $2.394 $2.690
Options - percentage 0.075 0.01% 0.000 0.00% 0.414 0.04% 0.491 0.04% 0.544 0.05% 10.93%
Options - amount $3.142 $0.000 $22.106 $36.898 $44.089
Bieber, Corey B. 0.02% 0.177 0.02% 0.181 0.01% 0.187 0.02% 0.192 0.02% Filed last April 2019
CFO - Shares - Amount $5.108 $7.578 $8.135 $6.150 $8.075
Options - percentage 0.03% 0.465 0.04% 0.480 0.04% 0.033 0.00% 0.355 0.03%
Options - amount $11.484 $19.897 $21.551 $1.097 $14.907
Andersen, Troy John Peter 0.015 0.00% 0.017 0.00% 0.017 0.00% 0.023 0.00% 0.026 0.00% 11.40%
Officer - Shares - Amount $0.610 $0.519 $0.906 $1.739 $2.087
Options - percentage 0.305 0.03% 0.378 0.03% 0.462 0.04% 0.313 0.03% 0.297 0.03% -5.01%
Options - amount $12.801 $11.577 $24.712 $23.518 $24.063
Balog, Brenda Gayle 0.028 0.00%
Officer - Shares - Amount $2.296
Options - percentage 0.027 0.00%
Options - amount $2.186
Bast, Calvin John 0.037 0.00%
Officer - Shares - Amount $2.967
Options - percentage 0.100 0.01%
Options - amount $8.127
Laut, Stephen W. 0.21% 2.421 0.22% 2.425 0.20% 2.376 0.20% 2.376 0.20% 2.393 0.20% 2.554 0.22% 1.839 0.17% 1.430 0.13% Executive vice-chairman 2019 -22.24%
Director - Shares - Amount $70.845 $103.610 $108.943 $78.281 $99.812 $73.190 $136.490 $138.284 $115.823 Director 2021
Options - percentage 0.19% 2.100 0.19% 2.079 0.17% 1.799 0.15% 1.642 0.14% 0.000 0.00% 0.621 0.05% 3.048 0.28% 3.137 0.28% 2.90%
Options - amount $63.462 $89.859 $93.385 $59.272 $68.982 $0.000 $33.179 $229.214 $254.057
Best, Catherine May 0.00% 0.032 0.00% 0.036 0.00% 0.040 0.00% 0.044 0.00% 0.048 0.00% 0.053 0.00% 0.056 0.01% 0.059 0.01% Last updated April 2022 4.37%
Director - Shares - Amt $0.921 $1.390 $1.639 $1.334 $1.868 $1.483 $2.831 $4.228 $4.753
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Edwards, Norman Murray 2.06% 21.920 1.97% 21.522 1.76% 22.014 1.83% 21.954 1.85% 21.938 1.85% 21.939 1.88% 21.502 1.95% 21.259 1.93% -1.13%
Chairman - Shares - Amt $682.513 $937.945 $966.778 $725.142 $922.069 $671.070 $1,172.650 $1,616.712 $1,721.794
Options - percentage 0.18% 2.050 0.18% 2.298 0.19% 1.798 0.15% 2.348 0.20% 2.528 0.21% 3.020 0.26% 2.840 0.26% 2.505 0.23% -11.79%
Options - amount $58.929 $87.720 $103.237 $59.231 $98.635 $77.338 $161.403 $213.507 $202.857
Increase in O/S Shares 1.34% 2.831 0.26% 16.284 1.47% 14.256 1.17% 9.975 0.83% 10.871 0.92% 3.979 0.34% 18.147 1.55% 11.605 1.05%
due to SO 2013 $524.791 $85.553 $696.792 $640.380 $328.577 $456.582 $121.718 $969.957 $872.580
Book Value $488.000 $91.000 $559.000 $466.000 $332.000 $360.000 $108.000 $707.000 $442.000
Previous Lia. for SO $129.00 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Insider Buying -$4.904 -$1.173 -$8.018 -$3.966 -$4.805 -$2.443 -$2.093 -$1.691 -$0.164
Insider Selling $52.118 $11.682 $98.356 $83.132 $52.309 $60.697 $32.583 $172.877 $145.077
Net Insider Selling $47.214 $10.509 $90.337 $79.166 $47.504 $58.254 $30.490 $171.185 $144.913 seems to be not accepting
% of Market Cap 0.14% 0.02% 0.16% 0.20% 0.10% 0.16% 0.05% 0.21% 0.16% Options
Directors 11 11 12 11 12 11 12 11
Women 15% 2 18% 2 18% 2 17% 2 18% 2 17% 2 18% 4 33% 3 27%
Minorities 0% 1 9% 1 9% 1 8% 1 9% 1 8% 1 9% 1 8% 1 9%
Institutions/Holdings 357 68.01% 370 69.60% 431 67.01% 20 68.60% 20 52.66% 20 59.77%
Total Shares Held 744.510 67.02% 774.913 69.75% 803.661 67.71% 754.250 63.71% 612.150 55.52% 657.098 59.59%
Increase/Decrease 3 Mths -20.958 -2.74% 5.233 0.68% -7.979 -0.98% 28.375 3.91% 13.064 2.18% 21.762 3.43%
Starting No. of Shares 765.468 Nasdaq 769.681 Nasdaq 811.640 Nasdaq 725.874 MS Top 599.085 MS Top 635.336 MS Top
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock