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. Estimates Estimates Estimates
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Q1 2026 <-Estimates https://www.annualreports.com/Company/Canadian-Natural-Resources
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ 3/31/26 <-Estimates
Canadian Natural Resources TSX CNQ NYSE CNQ https://www.cnrl.com/ Fiscal Yr: Dec 31
Year 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 12/31/26 12/31/27 12/31/28 Value Description #Y Item Total G
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Split Dates 6/11/24 Alpha
Split 2 Split Spread
$37,989 <-12 mths -1.99% Estimates last 12 months from Qtr.
Revenue less Royalities $16,145 $18,863 $12,363 $10,523 $16,651 $21,027 $22,871 $16,893 $30,057 $42,298 $35,968 $35,656 $38,762 $41,511 $39,952 $39,428 213.53% <-Total Growth 10 Revenue less Royalities
Increase 10.67% 16.83% -34.46% -14.88% 58.23% 26.28% 8.77% -26.14% 77.93% 40.73% -14.97% -0.87% 8.71% 7.09% -3.76% -1.31% 8.74% <-Median-> 10 Increase
Royalities $1,800 $2,438 $804 $575 $1,018 $1,255 $1,523 $598 $2,797 $7,232 $4,867 $5,853 $5,405 $5,405 $5,405 $5,405 572.26% <-Total Growth 10 Royalities
% Roylities to Rev less Royalities 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% 3.54% 3.54% 3.54% 3.54% <-Median-> 10 % Roylities to Rev less Royalities
Revenue* $17,945 $21,301 $13,167 $11,098 $17,669 $22,282 $24,394 $17,491 $32,854 $49,530 $40,835 $41,509 $44,167 $46,916 $45,357 $44,833 235.44% <-Total Growth 10 Revenue
Increase 10.81% 18.70% -38.19% -15.71% 59.21% 26.11% 9.48% -28.30% 87.83% 50.76% -17.56% 1.65% 6.40% 6.22% -3.32% -1.16% 12.87% <-IRR #YR-> 10 Revenue 235.44%
5 year Running Average $15,009 $17,054 $16,823 $15,941 $16,236 $17,103 $17,722 $18,587 $22,938 $29,310 $33,021 $36,444 $41,779 $44,591 $43,757 $44,556 20.35% <-IRR #YR-> 5 Revenue 152.51%
Revenue per Share $8.25 $9.75 $6.01 $4.99 $7.22 $9.27 $10.28 $7.39 $14.06 $22.46 $19.04 $19.74 $21.22 $22.54 $21.79 $21.54 9.52% <-IRR #YR-> 10 5 yr Running Average 148.34%
Increase 11.29% 18.21% -38.35% -16.95% 44.65% 28.30% 10.86% -28.12% 90.33% 59.75% -15.23% 3.67% 7.50% 6.22% -3.32% -1.16% 17.58% <-IRR #YR-> 5 5 yr Running Average 124.78%
5 year Running Average $6.88 $7.81 $7.70 $7.29 $7.25 $7.45 $7.56 $7.83 $9.64 $12.69 $14.64 $16.54 $19.30 $21.00 $20.86 $21.36 13.44% <-IRR #YR-> 10 Revenue per Share 252.80%
P/S (Price/Sales) Med 1.96 2.08 2.81 3.44 2.87 2.14 1.76 1.80 1.46 1.66 2.13 2.45 1.96 2.48 0.00 0.00 23.49% <-IRR #YR-> 5 Revenue per Share 187.23%
P/S (Price/Sales) Close 2.18 1.84 2.51 4.28 3.11 1.78 2.04 2.07 1.90 1.67 2.13 2.25 2.19 2.78 2.87 2.90 9.62% <-IRR #YR-> 10 5 yr Running Average 150.64%
*Product sales before Royalties in M CDN $  P/S Med 20 yr  2.34 15 yr  2.13 10 yr  2.04 5 yr  1.96 35.87% Diff M/C 19.77% <-IRR #YR-> 5 5 yr Running Average 146.50%
-$13,167 $0 $0 $0 $0 $0 $0 $0 $0 $0 $44,167
-$17,491 $0 $0 $0 $0 $44,167
-$16,823 $0 $0 $0 $0 $0 $0 $0 $0 $0 $41,779
-$18,587 $0 $0 $0 $0 $41,779
-$6.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21.22
-$7.39 $0.00 $0.00 $0.00 $0.00 $21.22
$15,309.0 <-12 mths -0.98%
$7.33 <-12 mths -0.54% Estimates Last 12 months from Qtr
32.56% 32.64% Estimates Payout Ratio EPS
Adjusted Cash Flow $7,477 $9,587 $5,785 $4,293 $7,347 $9,088 $10,267 $5,200 $13,733 $19,791 $15,274 $14,859 $15,460 $15,827 $16,104 167.24% <-Total Growth 10 Adjusted Cash Flow
AFFO basic $3.44 $4.39 $2.65 $1.95 $3.13 $3.73 $4.31 $2.20 $5.82 $8.72 $7.00 $6.99 $7.39 179.40% <-Total Growth 10 AFFO basic
AFFO Diluted $3.43 $4.37 $2.64 $1.95 $3.11 $3.72 $4.31 $2.20 $5.79 $8.61 $6.93 $6.94 $7.37 $7.67 $7.91 179.17% <-Total Growth 10 AFFO Diluted
Increase 25.41% 27.41% -39.59% -26.33% 59.64% 19.65% 15.88% -48.90% 162.95% 48.83% -19.51% 0.14% 6.20% 4.07% 3.13% 10 0 10 Years of Data, EPS P or N 100.00%
Earnings Yield 19.1% 24.3% 17.5% 9.1% 13.8% 22.6% 20.5% 14.4% 21.6% 22.9% 17.1% 15.6% 15.9% 12.3% 12.6% 10.81% <-IRR #YR-> 10 Earnings per Share 179.17%
5 year Running Average $2.97 $3.28 $3.23 $3.02 $3.10 $3.16 $3.14 $3.05 $3.82 $4.92 $5.57 $6.09 $7.13 $7.50 $7.36 27.35% <-IRR #YR-> 5 Earnings per Share 235.00%
Payout Ratio 7.00% 10.01% 17.33% 23.65% 17.71% 18.03% 16.96% 37.50% 15.86% 16.48% 25.61% 29.90% 31.55% 32.11% 31.61% 8.24% <-IRR #YR-> 10 5 yr Running Average 120.72%
5 year Running Average 7.05% 21.97% -35.99% 22.24% 377.15% 1.41% 36.33% -35.41% 482.98% 9.62% -3.87% -3.89% 11.37% -0.28% -0.87% 18.47% <-IRR #YR-> 5 5 yr Running Average 133.37%
P/AFFO Med 4.71 4.64 6.41 8.84 6.69 5.33 4.20 6.05 3.56 4.34 5.84 6.96 5.64 7.29 0.00 5.74 <-Median-> 10 P/AFFO Med
P/AFFO High 5.24 5.63 7.95 11.79 7.53 6.59 4.90 9.55 4.62 5.05 6.73 8.11 6.41 9.06 0.00 6.66 <-Median-> 10 P/AFFO High
P/AFFO Low 4.19 3.64 4.86 5.89 5.85 4.07 3.50 2.55 2.50 3.62 4.95 5.81 4.86 5.53 0.00 4.47 <-Median-> 10 P/AFFO Low
P/AFFO Close 5.24 4.11 5.72 11.00 7.23 4.43 4.88 6.95 4.62 4.37 5.84 6.39 6.31 8.16 7.91 6.08 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 6.57 5.24 3.46 8.10 11.55 5.30 5.65 3.55 12.15 6.50 4.70 6.40 6.70 8.49 8.16 6.45 <-Median-> 10 Trailing P/AFFO Close
5 Year Median Values Historical   in order 6.05 7.40 4.72 5.84 P/CF 5 Yrs   in order 5.64 6.41 4.86 5.84 44.62% Diff M/C 42.06% Diff M/C 10
$3.43 <-12 mths -3.38% Estimates Last 12 months from Qtr
56.49% 62.37% Estimates Payout Ratio EPS
Adjusted net earnings from operations $2,435 $3,811 $263 -$669 $1,403 $3,263 $3,795 -$756 $7,420 $12,863 $8,533 $7,414 $7,444 2730.42% <-Total Growth 10 Adjusted net earnings from operations
Adjusted Profit CDN$ 9.45% 13.19% 0.96% -2.55% 4.43% 10.21% 10.85% -2.33% 20.08% 33.69% 21.42% 18.78% 16.78% 13.81% <-Median-> 10 Return on Equity ROE
Return on Equity ROE 11.09% 11.09% 9.45% 6.66% 4.43% 4.43% 4.43% 4.43% 10.21% 10.85% 20.08% 20.08% 20.08% 8.43% <-Median-> 10 5 Yr Median
Adjusted EPS Basic $1.12 $1.75 $0.12 -$0.31 $0.60 $1.34 $1.60 -$0.32 $3.14 $5.67 $3.91 $3.49 $3.56 2866.67% <-Total Growth 10 Adjusted EPS Basic TD Web
Adjusted EPS Diluted $1.12 $1.74 $0.12 -$0.31 $0.60 $1.34 $1.59 -$0.32 $3.13 $5.60 $3.87 $3.46 $3.55 $4.42 $4.14 $4.38 2858.33% <-Total Growth 10 Adjusted EPS Diluted
Increase 51.70% 55.61% -93.08% -354.17% 295.08% 124.37% 19.10% -120.13% 1076.56% 79.04% -30.83% -10.59% 2.60% 24.51% -6.33% 5.80% 8 2 10 Years of Data, EPS P or N 80.00%
Earnings Yield 6.20% 9.66% 0.79% -1.43% 2.65% 8.11% 7.57% -2.09% 11.69% 14.88% 9.56% 7.80% 7.64% 7.07% 6.62% 7.00% 40.32% <-IRR #YR-> 10 Earnings per Share 2858.33%
5 year Running Average $1.08 $1.18 $0.97 $0.68 $0.65 $0.70 $0.67 $0.58 $1.27 $2.27 $2.77 $3.15 $3.92 $4.18 $3.89 $3.99 #NUM! <-IRR #YR-> 5 Earnings per Share 1209.38%
Payout Ratio 21.52% 25.22% 381.25% -150.82% 92.44% 50.19% 45.91% -257.81% 29.36% 25.36% 45.87% 59.97% 65.49% 55.71% 60.39% 57.08% 14.98% <-IRR #YR-> 10 5 yr Running Average 303.71%
5 year Running Average 15.82% 20.14% 31.10% 52.87% 65.80% 73.99% 85.98% 111.74% 58.38% 53.52% 51.70% 54.11% 51.08% 55.31% 57.29% 59.46% 46.60% <-IRR #YR-> 5 5 yr Running Average 577.03%
Price/AEPS Median 14.50 11.68 140.98 -56.35 34.90 14.83 11.37 -41.56 6.59 6.67 10.46 13.96 11.71 12.66 0.00 0.00 10.91 <-Median-> 10 Price/AEPS Median
Price/AEPS High 16.12 14.18 175.00 -75.16 39.28 18.34 13.26 -65.63 8.55 7.78 12.05 16.27 13.32 15.72 0.00 0.00 12.66 <-Median-> 10 Price/AEPS High
Price/AEPS Low 12.89 9.18 106.96 -37.54 30.53 11.33 9.47 -17.50 4.62 5.57 8.87 11.65 10.10 9.59 0.00 0.00 9.17 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 16.12 10.35 125.92 -70.15 37.75 12.34 13.21 -47.80 8.55 6.72 10.46 12.83 13.10 14.15 15.11 14.28 11.40 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 12.84 10.36 149.67 -49.54 35.96 16.82 10.36 -65.63 4.89 4.78 9.71 11.70 12.50 10.52 15.11 14.28 10.04 <-Median-> 10 Trailing P/AEPS Close
5 Year Median Values Historical   in order 11.68 15.82 9.47 12.83 P/CF 5 Yrs   in order 10.46 12.05 8.87 10.46 35.28% Diff M/C 29.67% Diff M/C 10
Adjusted net earnings from operations
$5.08 <-12 mths -1.55% Estimates Last 12 months from Qtr
Difference Basic and Diluted 0.00% 0.56% 0.00% 0.00% 0.49% 0.47% 0.22% 0.00% 0.46% 1.24% 0.93% 0.70% 0.19% 0.47% <-Median-> 10 Difference Basic and Diluted
EPS Basic $1.04 $1.80 -$0.29 -$0.10 $1.02 $1.07 $2.28 -$0.19 $3.25 $4.82 $3.77 $2.87 $5.17 -1882.76% <-Total Growth 10 EPS Basic
EPS Diluted* $1.04 $1.79 -$0.29 -$0.10 $1.02 $1.06 $2.27 -$0.19 $3.23 $4.76 $3.74 $2.85 $5.16 $5.05 $4.73 $4.08 1879.31% <-Total Growth 10 EPS Diluted
Increase 20.93% 72.12% -116.20% 67.24% 1168.42% 4.43% 114.15% -108.15% 1845.95% 47.37% -21.53% -23.69% 81.05% -2.13% -6.40% -13.67% 8 2 10 Years of Data, EPS P or N 80.00%
Earnings Yield 5.8% 10.0% -1.9% -0.4% 4.5% 6.4% 10.8% -1.2% 12.1% 12.7% 9.2% 6.4% 11.1% 8.1% 7.6% 6.5% #NUM! <-IRR #YR-> 10 Earnings per Share 1879.31%
5 year Running Average $0.92 $1.13 $0.92 $0.66 $0.69 $0.70 $0.79 $0.81 $1.48 $2.23 $2.76 $2.88 $3.95 $4.31 $4.30 $4.37 #NUM! <-IRR #YR-> 5 Earnings per Share 2889.19%
10 year Running Average $1.04 $1.16 $1.08 $0.95 $0.93 $0.81 $0.96 $0.87 $1.07 $1.46 $1.73 $1.84 $2.38 $2.89 $3.27 $3.57 15.68% <-IRR #YR-> 10 5 yr Running Average 329.02%
* ESP per share and Earnings from Operations E/P 10 Yrs 7.83% 5Yrs 11.10% 37.16% <-IRR #YR-> 5 5 yr Running Average 385.49%
$0.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.16
$0.19 $0.00 $0.00 $0.00 $0.00 $5.16
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.95
-$0.81 $0.00 $0.00 $0.00 $0.00 $3.95
Comment
Dividend* $2.50 $2.58 $2.64 Estimates Dividend*
Increase 7.40% 3.40% 2.36% Estimates Increase
Payout Ratio EPS 49.45% 54.62% 64.76% Estimates Payout Ratio EPS
Special Dividends $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 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Pre-split 2024 $0.48 $0.88 $0.92 $0.92 $1.10 $1.34 $1.46 $1.65 $1.84 $2.84 $3.55
Dividend* $0.24 $0.44 $0.46 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $1.42 $1.78 $2.08 $2.33 $2.46 $2.50 $2.50 408.20% <-Total Growth 10 Dividends
Increase 18.52% 82.29% 4.57% 0.55% 19.57% 21.82% 8.96% 13.01% 11.21% 54.63% 25.11% 16.90% 12.05% 5.91% 1.52% 0.00% 24 0 24 Years of data, Count P, N
Average Increases 5 Year Running 20.35% 35.25% 29.42% 24.66% 25.10% 25.76% 11.09% 12.78% 14.91% 21.93% 22.58% 24.17% 23.98% 22.92% 12.30% 7.28% 23.28% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.17 $0.24 $0.30 $0.36 $0.43 $0.52 $0.57 $0.65 $0.74 $1.21 $1.43 $1.70 $2.00 $2.31 $2.23 $2.37 563.00% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.48% 2.16% 2.70% 2.68% 2.65% 3.38% 4.04% 6.20% 4.46% 3.80% 4.38% 4.30% 5.59% 4.40% 4.17% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 1.34% 1.78% 2.18% 2.01% 2.35% 2.74% 3.46% 3.93% 3.43% 3.26% 3.81% 3.69% 4.92% 3.54% 3.45% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 1.67% 2.75% 3.56% 4.02% 3.03% 4.43% 4.85% 14.73% 6.35% 4.55% 5.17% 5.15% 6.49% 5.81% 5.00% <-Median-> 10 Yield on Low Price AEPS
Yield on Close Price 1.34% 2.44% 3.03% 2.15% 2.45% 4.07% 3.48% 5.39% 3.43% 3.77% 4.38% 4.68% 5.00% 3.94% 4.00% 4.00% 3.92% <-Median-> 10 Yield on Close Price CFPS
Payout Ratio EPS 23.08% 24.44% -157.76% -484.21% 54.19% 63.21% 32.16% -445.95% 28.41% 29.81% 47.52% 72.81% 45.06% 48.76% 52.89% 61.26% 38.61% <-Median-> 10 DPR EPS FCF 
DPR EPS 5 Yr Running 18.60% 21.01% 32.83% 54.39% 61.99% 73.99% 72.41% 79.58% 49.97% 54.43% 51.89% 59.15% 50.73% 53.61% 51.75% 54.25% 56.79% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 7.23% 11.29% 17.78% 29.61% 18.52% 15.91% 19.63% 41.44% 14.81% 16.13% 30.82% 32.60% 32.04% 25.75% 26.88% 29.53% 24.62% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 5.89% 7.56% 9.77% 12.69% 15.01% 16.96% 19.08% 22.40% 19.35% 24.33% 27.08% 29.24% 29.13% 30.62% 29.12% 28.97% 20.87% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 7.20% 10.38% 18.57% 25.59% 19.32% 18.35% 17.57% 40.03% 15.86% 16.20% 25.78% 30.88% 33.53% 25.75% 26.88% 29.53% 22.45% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 5.94% 7.51% 9.73% 12.44% 14.63% 17.20% 19.23% 22.29% 19.96% 24.83% 25.92% 28.18% 28.54% 29.74% 28.26% 28.94% 21.13% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 4.17% 3.92% 5 Yr Med 5 Yr Cl 4.38% 4.38% 5 Yr Med Payout 45.06% 30.82% 25.78% 23.03% <-IRR #YR-> 5 Dividends
* Dividends per share  10 Yr Med and Cur. -4.10% 1.94% 5 Yr Med and Cur. -8.84% -8.82% Last Div Inc ---> $0.5875 $0.6250 6.38% 17.65% <-IRR #YR-> 10 Dividends
Dividends Growth 15 20.67% <-IRR #YR-> 15 Dividends
Dividends Growth 20 20.42% <-IRR #YR-> 20 Dividends
Dividends Growth 25 21.92% <-IRR #YR-> 24 Dividends
Dividends Growth 5 -$0.83 $0.00 $0.00 $0.00 $0.00 $2.33 Dividends Growth 5
Dividends Growth 10 -$0.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.33 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.33 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.33 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.33 Dividends Growth 25
Historical Dividends Historical High Div 6.41% Low Div 0.39% 10 Yr High 13.91% 10 Yr Low 2.04% Med Div 1.48% Close Div 1.41% Historical Dividends
High/Ave/Median Values Curr diff Exp. -37.65%     924.82% Exp. -71.27% 95.92% Cheap 170.05% Cheap 182.64% High/Ave/Median 
Future Div Yield Div Yd 11.26% earning in 5 Years at IRR of 23.03% Div Inc. 181.82% Future Div Yield
Future Div Yield Div Yd 31.74% earning in 10 Years at IRR of 23.03% Div Inc. 694.21% Future Div Yield
Div Yield 89.46% earning in 15 Years at IRR of 23.03% Div Inc. 2138.24% Future Dividend Yield
Div Paid $7.05 earning in 5 Years at IRR of 23.03% Div Inc. 181.82% Future Dividend Paid
Div Paid $19.86 earning in 10 Years at IRR of 23.03% Div Inc. 694.21% Future Dividend Paid
Div Paid $55.96 earning in 15 Years at IRR of 23.03% Div Inc. 2138.24% Future Dividend Paid
Total Div $19.74 over 5 Years at IRR of 23.03% Div Cov. 31.56% Dividend Covering Cost
Total Div $68.33 over 10 Years at IRR of 23.03% Div Cov. 109.24% Dividend Covering Cost
Total Div $205.26 over 15 Years at IRR of 23.03% Div Cov. 328.16% Dividend Covering Cost
I am earning GC Div Gr 495.24% 9/21/12 # yrs -> 13 2012 $31.82 Cap Gain 96.57% I am earning GC
I am earning Div org yield 1.32% 12/31/15 Traading Div G Yrly 72.35% Div start $0.42 -1.32% 7.86% I am earning Div
Yield if held 5 years 1.29% 3.04% 2.36% 2.34% 3.32% 4.14% 3.60% 4.88% 5.34% 6.83% 8.96% 11.48% 17.48% 11.96% 6.70% 6.18% 5.11% <-Median-> 10 Paid Median Price Years 
Yield if held 10 years 6.50% 8.04% 4.34% 3.09% 3.35% 3.60% 5.08% 4.25% 4.67% 8.56% 10.98% 10.24% 13.74% 14.33% 12.04% 12.62% 4.87% <-Median-> 10 Paid Median Price 5
Yield if held 15 years 15.44% 23.97% 17.02% 16.68% 19.10% 18.14% 13.42% 7.83% 6.16% 8.65% 9.53% 14.43% 11.98% 12.53% 15.08% 15.46% 12.70% <-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% 38.13% 22.06% 16.52% 15.24% 13.42% 35.70% <-Median-> 10 Paid Median Price 15
Yield if held 25 years 59.75% 64.66% 85.16% 50.06% 63.81% 114.17% 113.70% 86.51% 89.29% 86.82% 67.67% 74.91% <-Median-> 8 Paid Median Price 20
Yield if held 30 years 158.31% 183.78% 240.00% 134.36% 112.44% 160.80% 183.78% <-Median-> 3 Paid Median Price 25
Yield if held 35 years 222.97% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 4.60% 8.29% 7.78% 9.15% 12.94% 15.92% 14.15% 19.12% 21.48% 29.19% 36.19% 47.10% 75.27% 56.14% 29.83% 29.30% 20.30% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 32.78% 29.43% 19.00% 16.04% 17.43% 18.43% 28.23% 24.44% 27.94% 49.49% 60.24% 56.16% 78.30% 88.72% 82.82% 96.09% 28.08% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 83.40% 95.02% 81.55% 95.42% 109.46% 102.48% 82.13% 49.70% 40.82% 54.37% 56.89% 87.43% 76.00% 86.75% 116.67% 133.60% 79.07% <-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% 319.97% 296.46% 238.55% 144.69% 118.36% 122.26% 120.57% 233.93% <-Median-> 10 Paid Median Price
Cost covered if held 25 years 345.29% 407.56% 560.16% 346.14% 416.60% 709.97% 718.51% 574.43% 648.35% 706.77% 617.55% 488.38% <-Median-> 8 Paid Median Price
Cost covered if held 30 years 984.42% 1161.39% 1593.58% 976.66% 917.51% 1472.98% 1161.39% <-Median-> 3 Paid Median Price
Cost covered if held 35 years 2042.39% #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $17,491 $32,854 $49,530 $40,835 $41,509 $44,167 $37,989 <-12 mths -13.99% 152.51% <-Total Growth 5 Revenue Growth  152.51%
AEPS Growth -$0.32 $3.13 $5.60 $3.87 $3.46 $3.55 $3.43 <-12 mths -3.38% 1209.38% <-Total Growth 5 AEPS Growth 1209.38%
Net Income Growth -$435 $7,664 $10,937 $8,233 $6,106 $10,820 $10,442 <-12 mths -3.49% 2587.36% <-Total Growth 5 Net Income Growth 2587.36%
Cash Flow Growth $4,714 $14,478 $19,391 $12,353 $13,386 $15,106 220.45% <-Total Growth 5 Cash Flow Growth 220.45%
Dividend Growth $0.83 $0.92 $1.42 $1.78 $2.08 $2.33 $5.05 <-12 mths 117.20% 181.82% <-Total Growth 5 Dividend Growth 181.82%
Stock Price Growth $15.30 $26.73 $37.60 $40.50 $44.38 $46.49 $62.55 <-12 mths 34.55% 203.96% <-Total Growth 5 Stock Price Growth 203.96%
Revenue Growth  $13,167 $11,098 $17,669 $22,282 $24,394 $17,491 $32,854 $49,530 $40,835 $41,509 $44,167 $41,511 <-this year -6.01% 235.44% <-Total Growth 10 Revenue Growth  235.44%
AEPS Growth $0.12 -$0.31 $0.60 $1.34 $1.59 -$0.32 $3.13 $5.60 $3.87 $3.46 $3.55 $4.42 <-this year 24.51% 2858.33% <-Total Growth 10 AEPS Growth 2858.33%
Net Income Growth -$637 -$204 $2,397 $2,591 $5,416 -$435 $7,664 $10,937 $8,233 $6,106 $10,820 $100,057 <-this year 83.99% 1798.59% <-Total Growth 10 Net Income Growth 1798.59%
Cash Flow Growth $5,632 $3,452 $7,262 $10,121 $8,829 $4,714 $14,478 $19,391 $12,353 $13,386 $15,106 $19,908 <-this year -99.98% 168.22% <-Total Growth 10 Cash Flow Growth 168.22%
Dividend Growth $0.46 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $1.42 $1.78 $2.08 $2.33 $2.50 <-this year 7.40% 408.20% <-Total Growth 10 Dividend Growth 408.20%
Stock Price Growth $15.11 $21.40 $22.46 $16.47 $21.00 $15.30 $26.73 $37.60 $40.50 $44.38 $46.49 $62.55 <-this year 34.55% 207.68% <-Total Growth 10 Stock Price Growth 207.68%
Dividends on Shares $30.82 $36.85 $44.89 $48.91 $55.28 $61.47 $195.56 $118.93 $139.03 $155.78 $164.99 $167.50 $167.50 $887.50 No of Years 10 Total Divs 12/31/15
Paid  $1,012.37 $1,433.47 $1,504.82 $1,103.49 $1,407.00 $1,024.77 $1,790.58 $2,518.87 $2,713.17 $2,973.46 $3,114.83 $4,190.85 $4,190.85 $4,190.85 $3,114.83 No of Years 10 Worth $15.11
Total $4,002.33
Graham No. AEPS $17.24 $22.73 $5.80 $5.65 $13.16 $19.99 $22.96 $22.12 $33.34 $46.68 $40.21 $38.22 $41.26 $46.04 $44.56 $45.83 611.21% <-Total Growth 10 Graham Price AEPS
Price/GP Ratio Med 0.94 0.89 2.92 3.04 1.58 0.99 0.79 0.60 0.62 0.80 1.01 1.26 1.01 1.22 1.00 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.04 1.08 3.62 4.06 1.78 1.22 0.92 0.95 0.80 0.93 1.16 1.47 1.15 1.51 1.15 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.83 0.70 2.21 2.03 1.38 0.76 0.66 0.25 0.43 0.67 0.85 1.05 0.87 0.92 0.81 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.04 0.79 2.60 3.79 1.71 0.82 0.91 0.69 0.80 0.81 1.01 1.16 1.13 1.36 1.40 1.36 0.96 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 4.22% -20.97% 160.45% 278.69% 70.62% -17.60% -8.55% -30.85% -19.85% -19.47% 0.70% 16.11% 12.67% 35.86% 40.38% 36.48% -3.93% <-Median-> 10 Graham Price
Graham No. EPS $16.65 $23.08 $16.87 $16.43 $17.19 $17.81 $27.44 $31.53 $33.90 $43.06 $39.51 $34.69 $49.74 $49.21 $47.61 $44.24 194.83% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 0.97 0.88 1.00 1.05 1.21 1.11 0.66 0.42 0.61 0.87 1.02 1.39 0.84 1.14 0.95 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.08 1.07 1.24 1.40 1.36 1.37 0.77 0.67 0.79 1.01 1.18 1.62 0.95 1.41 1.10 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.86 0.69 0.76 0.70 1.06 0.85 0.55 0.18 0.43 0.72 0.87 1.16 0.72 0.86 0.72 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.08 0.78 0.90 1.30 1.31 0.92 0.77 0.49 0.79 0.87 1.03 1.28 0.93 1.27 1.31 1.41 0.93 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 7.91% -22.20% -10.45% 30.21% 30.64% -7.53% -23.47% -51.48% -21.16% -12.69% 2.50% 27.93% -6.54% 27.10% 31.38% 41.39% -7.04% <-Median-> 10 Graham Price
presplit '04
presplit '05
presplit '10
presplit '24 $35.94 $35.92 $30.22 $42.79 $44.92 $32.94 $42.00 $30.59 $53.45 $75.19 $80.99
Price Close $17.97 $17.96 $15.11 $21.40 $22.46 $16.47 $21.00 $15.30 $26.73 $37.60 $40.50 $44.38 $46.49 $62.55 $62.55 $62.55 207.68% <-Total Growth 10 Stock Price
Increase 25.49% -0.06% -15.87% 41.59% 4.98% -26.67% 27.50% -27.17% 74.73% 40.67% 7.71% 9.59% 4.75% 34.55% 0.00% 0.00% 18.13 <-Median-> 10 CAPE (10 Yr P/E)
P/E 17.28 10.03 -52.10 -225.21 22.13 15.54 9.25 -82.68 8.27 7.90 10.84 15.57 9.01 12.39 13.23 15.33 24.90% <-IRR #YR-> 5 Stock Price 203.96%
Trailing P/E 20.90 17.27 8.44 -73.78 -236.42 16.23 19.81 6.74 -144.46 11.64 8.51 11.88 16.31 12.12 12.39 13.23 11.89% <-IRR #YR-> 10 Stock Price 207.68%
CAPE (10 Yr P/E) 15.88 14.76 15.88 18.61 19.46 22.98 19.52 20.89 17.64 14.52 13.56 14.22 12.28 11.52 11.44 11.76 33.38% <-IRR #YR-> 5 Price & Dividend 274.80%
Median 10, 5 Yrs D.  per yr 4.53% 8.48% % Tot Ret 27.56% 25.41% T P/E $10.07 $11.64 P/E:  $9.13 $9.01 16.42% <-IRR #YR-> 10 Price & Dividend 298.37%
Price 15 D.  per yr 2.57% % Tot Ret 33.71% CAPE Diff -31.67% 5.06% <-IRR #YR-> 15 Stock Price 109.65%
Price  20 D.  per yr 2.12% % Tot Ret 26.17% 5.98% <-IRR #YR-> 20 Stock Price 219.52%
Price  25 D.  per yr 2.14% % Tot Ret 18.95% 9.17% <-IRR #YR-> 25 Stock Price 796.19%
Price 30 D.  per yr 1.88% % Tot Ret 15.54% 10.23% <-IRR #YR-> 30 Stock Price
Price 35 D.  per yr 2.61% % Tot Ret 13.62% 16.53% <-IRR #YR-> 35 Stock Price
Price & Dividend 15 7.63% <-IRR #YR-> 15 Price & Dividend 176.82%
Price & Dividend 20 8.10% <-IRR #YR-> 20 Price & Dividend 324.71%
Price & Dividend 25 11.31% <-IRR #YR-> 25 Price & Dividend 1093.79%
Price & Dividend 30 12.12% <-IRR #YR-> 30 Price & Dividend
Price & Dividend 35 19.13% <-IRR #YR-> 35 Stock Price
Price  5 -$15.30 $0.00 $0.00 $0.00 $0.00 $46.49 Price  5
Price 10 -$15.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.49 Price 10
Price & Dividend 5 -$15.30 $0.92 $2.92 $1.78 $2.08 $48.82 Price & Dividend 5
Price & Dividend 10 -$15.11 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $2.92 $1.78 $2.08 $48.82 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 $46.49 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 $46.49 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 $46.49 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 $46.49 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 $46.49 Price 35
Price & Dividend 15 $0.24 $0.44 $0.46 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $2.92 $1.78 $2.08 $48.82 Price & Dividend 15
Price & Dividend 20 $0.24 $0.44 $0.46 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $2.92 $1.78 $2.08 $48.82 Price & Dividend 20
Price & Dividend 25 $0.24 $0.44 $0.46 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $2.92 $1.78 $2.08 $48.82 Price & Dividend 25
Price & Dividend 30 $0.24 $0.44 $0.46 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $2.92 $1.78 $2.08 $48.82 Price & Dividend 30
Price & Dividend 35 $0.24 $0.44 $0.46 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $2.92 $1.78 $2.08 $48.82 Price & Dividend 35
Price H/L Med. $16.17 $20.26 $16.92 $17.19 $20.77 $19.80 $18.07 $13.30 $20.59 $37.34 $40.49 $48.30 $41.56 $55.94 145.66% <-Total Growth 10 Stock Price
Increase -2.47% 25.29% -16.50% 1.60% 20.83% -4.65% -8.74% -26.41% 54.77% 81.37% 8.44% 19.30% -13.95% 34.60% 9.40% <-IRR #YR-> 10 Stock Price 145.66%
P/E 15.55 11.32 -58.34 -180.92 20.46 18.68 7.96 -71.89 6.37 7.84 10.84 16.95 8.05 11.08 25.59% <-IRR #YR-> 5 Stock Price 212.48%
Trailing P/E 18.80 19.48 9.45 -59.27 -218.61 19.51 17.05 5.86 -111.27 11.56 8.51 12.93 14.58 10.84 13.93% <-IRR #YR-> 10 Price & Dividend 226.67%
Forward P/E  9.03 -69.86 -178.08 16.93 19.59 8.72 -97.69 4.12 4.32 10.00 14.21 9.36 8.23 11.83 35.27% <-IRR #YR-> 5 Price & Dividend 293.96%
P/E on Running 5 yr Average 17.54 17.87 18.39 26.00 30.01 28.45 22.82 16.36 13.93 16.76 14.66 16.78 10.53 12.98 9.04 <-Median-> 10 Forward P/E 
P/E on Running 10 yr Average 15.49 17.50 15.66 18.04 22.25 24.48 18.77 15.35 19.25 25.58 23.42 26.32 17.46 19.33 13.56 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 4.52% 9.68% % Tot Ret 32.47% 27.44% T P/E 10.03 11.56 P/E:  8.01 8.05 Count 31 Years of data
-$16.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41.56
-$13.30 $0.00 $0.00 $0.00 $0.00 $41.56
-$16.92 $0.46 $0.55 $0.67 $0.73 $0.83 $0.92 $2.92 $1.78 $2.08 $43.89
-$13.30 $0.92 $2.92 $1.78 $2.08 $43.89
High Months Dec Jul Apr Dec Nov Jul Apr Jan Dec May Nov Apr Jan Mar
presplit '04
presplit '05
pre-split '10
pre-split '24 $35.94 $49.19 $42.00 $45.85 $46.74 $48.97 $42.17 $42.00 $53.45 $87.04 $93.29
Price High $17.97 $24.60 $21.00 $22.93 $23.37 $24.49 $21.09 $21.00 $26.73 $43.52 $46.65 $56.30 $47.27 $69.50 125.10% <-Total Growth 10 Stock Price
Increase -11.22% 36.87% -14.62% 9.17% 1.94% 4.77% -13.89% -0.40% 27.26% 62.84% 7.18% 20.70% -16.04% 47.03% 8.45% <-IRR #YR-> 10 Stock Price 125.10%
P/E 17.28 13.74 -72.41 -241.32 23.02 23.10 9.29 -113.51 8.27 9.14 12.49 19.75 9.16 13.76 17.62% <-IRR #YR-> 5 Stock Price 125.10%
Trailing P/E 20.90 23.65 11.73 -79.05 -246.00 24.12 19.89 9.25 -144.46 13.47 9.80 15.07 16.59 13.47 15.70 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 11.64 13.47 P/E:  9.22 9.16 27.59 P/E Ratio Historical High
-$21.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $47.27
-$21.00 $0.00 $0.00 $0.00 $0.00 $47.27
Low Months Jan Dec Oct Jan Jul Dec Aug Mar Jan Jan Mar Feb Apr Jan
presplit '04
presplit '05
pre-split '10
pre-split '24 $28.74 $31.85 $25.67 $22.90 $36.33 $30.24 $30.12 $11.20 $28.89 $62.30 $68.65
Price Low $14.37 $15.93 $12.84 $11.45 $18.17 $15.12 $15.06 $5.60 $14.45 $31.15 $34.33 $40.30 $35.85 $42.38 179.31% <-Total Growth 10 Stock Price
Increase 11.22% 10.82% -19.40% -10.79% 58.65% -16.76% -0.40% -62.82% 157.95% 115.65% 10.19% 17.41% -11.04% 18.21% 10.82% <-IRR #YR-> 10 Stock Price 179.31%
P/E 13.82 8.90 -44.26 -120.53 17.90 14.26 6.63 -30.27 4.47 6.54 9.19 14.14 6.95 8.39 44.96% <-IRR #YR-> 5 Stock Price 540.18%
Trailing P/E 16.71 15.31 7.17 -39.48 -191.21 14.90 14.21 2.47 -78.08 9.64 7.21 10.79 12.58 8.21 10.23 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 8.43 9.64 P/E:  6.79 6.95 4.47 P/E Ratio Historical Low
-$12.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $35.85
Free Cash Flow Mkt Sc $514 -$700 $2,688 $5,946 $5,294 $2,320 $9,985 $14,655 $10,409 $9,568 $8,784 $10,471 $10,631 $10,657 1608.95% <-Total Growth 10 Free Cash Flow Mkt Sc
Change -236.19% 484.00% 121.21% -10.97% -56.18% 330.39% 46.77% -28.97% -8.08% -8.19% 19.21% 1.53% 0.24% 30.51% <-IRR #YR-> 5 Free Cash Flow MS
FCF/CF from Op Ratio 0.09 -0.20 0.37 0.59 0.60 0.49 0.69 0.76 0.84 0.71 0.58 32.82% <-IRR #YR-> 9 Free Cash Flow MS
Dividends paid $1,251 $758 $1,252 $1,562 $1,743 $1,950 $2,170 $4,926 $3,891 $4,429 $4,871 289.37% <-Total Growth 10 Dividends paid
Percentage paid 243.39% -108.29% 46.58% 26.27% 32.92% 84.05% 21.73% 33.61% 37.38% 46.29% 55.45% 35.50% <-Median-> 10 Percentage paid
5 Year Coverage 47.78% 46.73% 33.08% 32.33% 34.41% 37.00% 37.99% 5 Year Coverage
Dividend Coverage Ratio 0.41 -0.92 2.15 3.81 3.04 1.19 4.60 2.98 2.68 2.16 1.80 2.42 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 2.09 2.14 3.02 3.09 2.91 2.70 2.63 5 Year of Coverage
Free Cash Flow WSJ $514 -$700 $2,688 $5,946 $5,294 $2,159 $9,986 $14,288 $7,488 $8,095 $8,430 1540.08% <-Total Growth 10 Free Cash Flow WSJ WSJ, Mkt Scn
Change -236.19% 484.00% 121.21% -10.97% -59.22% 362.53% 43.08% -47.59% 8.11% 4.14% $0.06 <-Median-> 10 Change MS
Free Cash Flow old $1,164 -$345 $2,564 $5,680 $5,221 $2,154 $9,985 $14,290 $7,440 Free Cash Flow old
Change -129.64% 843.19% 121.53% -8.08% -58.74% 363.56% 43.11% -47.94% Change
Free Cash Flow MS $151 -$2,939 $690 $190 $2,270 $4,330 $6,250 $2,320 $9,020 $14,180 $9,860 $8,750 $7,640 $10,471 $10,631 $10,657 1007.25% <-Total Growth 10 Free Cash Flow MS Disagree
Change 43.81% -2046% 123.48% -72.46% 1094.74% 90.75% 44.34% -62.88% 288.79% 57.21% -30.47% -11.26% -12.69% 37.05% 1.53% 0.24% 26.92% <-IRR #YR-> 5 Free Cash Flow MS 229.31%
FCF/CF from Op Ratio 0.02 -0.35 0.12 0.06 0.31 0.43 0.71 0.49 0.62 0.73 0.80 0.65 0.51 0.53 0.55 0.60 27.18% <-IRR #YR-> 10 Free Cash Flow MS 1007.25%
Dividends paid $523 $955 $1,251 $758 $1,252 $1,562 $1,743 $1,950 $2,170 $4,926 $3,891 $4,429 $4,871 $5,126 $5,204 $5,204 289.37% <-Total Growth 10 Dividends paid
Percentage paid 181.30% 398.95% 55.15% 36.07% 27.89% 84.05% 24.06% 34.74% 39.46% 50.62% 63.76% 48.95% 48.95% 48.83% 45.04% <-Median-> 10 Percentage paid
5 Year Coverage 47.82% 47.30% 35.87% 34.21% 35.26% 39.35% 41.03% 45.66% 49.67% 51.58% 5 Year Coverage
Dividend Coverage Ratio 0.55 0.25 1.81 2.77 3.59 1.19 4.16 2.88 2.53 1.98 1.57 2.04 2.04 2.05 2.25 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 2.09 2.11 2.79 2.92 2.84 2.54 2.44 2.19 2.01 1.94 5 Year of Coverage
Market Cap $M $39,078 $39,219 $33,081 $47,538 $54,927 $39,590 $49,848 $36,214 $62,449 $82,907 $86,854 $93,331 $96,773 $130,203 $130,203 $130,203 192.53% <-Total Growth 10 Market Cap 192.53%
Pre-split 2024 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,102.12
Diluted # of Shares in Million 2,181.08 2,193.64 2,187.72 2,200.94 2,365.65 2,447.52 2,386.21 2,363.54 2,373.11 2,298.36 2,204.25 2,140.43 2,097.91 2,097.91 -4.11% <-Total Growth 10 Diluted
Change -0.82% 0.58% -0.27% 0.60% 7.48% 3.46% -2.50% -0.95% 0.41% -3.15% -4.09% -2.90% -1.99% 0.00% -1.47% <-Median-> 10 Change
Difference Diluted/Basic -0.2% -0.5% 0.0% 0.0% -0.7% -0.4% -0.2% 0.0% -0.4% -1.2% -1.0% -0.7% -0.3% -0.3% -0.43% <-Median-> 10 Difference Diluted/Basic
Pre-split 2024 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,091.31
Basic # of Shares in Millions 2,177.36 2,183.51 2,187.72 2,200.94 2,350.19 2,437.60 2,381.95 2,363.54 2,362.50 2,269.92 2,182.62 2,125.80 2,091.13 2,091.13 -4.42% <-Total Growth 10 Basic
Change -0.77% 0.28% 0.19% 0.60% 6.78% 3.72% -2.28% -0.77% -0.04% -3.92% -3.85% -2.60% -1.63% 0.00% -1.20% <-Median-> 10 Change
Difference Basic/Outstanding -0.1% 0.0% 0.1% 1.0% 4.1% -1.4% -0.3% 0.2% -1.1% -2.8% -1.7% -1.1% -0.5% -0.5% -0.76% <-Median-> 10 Difference Basic/Outstanding
# of Share in Millions 2,174.64 2,183.67 2,189.34 2,221.90 2,445.54 2,403.77 2,373.71 2,367.73 2,336.74 2,205.27 2,144.82 2,103.00 2,081.58 2,081.58 2,081.58 2,081.58 -0.50% <-IRR #YR-> 10 Shares -4.92%
Change -0.43% 0.42% 0.26% 1.49% 10.06% -1.71% -1.25% -0.25% -1.31% -5.63% -2.74% -1.95% -1.02% 0.00% 0.00% 0.00% -2.54% <-IRR #YR-> 5 Shares -12.09%
CF from Operations $Million $7,218 $8,459 $5,632 $3,452 $7,262 $10,121 $8,829 $4,714 $14,478 $19,391 $12,353 $13,386 $15,106 $19,908 $19,363 $17,621 168.22% <-Total Growth 10 Cash Flow
Increase 16.25% 17.19% -33.42% -38.71% 110.37% 39.37% -12.77% -46.61% 207.13% 33.93% -36.30% 8.36% 12.85% 31.79% -2.74% -9.00% SO  Buy Backs S. Issues (Purchases)
5 year Running Average $6,353 $6,883 $6,752 $6,194 $6,405 $6,985 $7,059 $6,876 $9,081 $11,507 $11,953 $12,864 $14,943 $16,029 $16,023 $17,077 121.30% <-Total Growth 10 CF 5 Yr Running
CFPS $3.32 $3.87 $2.57 $1.55 $2.97 $4.21 $3.72 $1.99 $6.20 $8.79 $5.76 $6.37 $7.26 $9.56 $9.30 $8.47 182.10% <-Total Growth 10 Cash Flow per Share
Increase 16.76% 16.71% -33.59% -39.61% 91.13% 41.79% -11.66% -46.47% 211.20% 41.92% -34.50% 10.52% 14.01% 31.79% -2.74% -9.00% 10.37% <-IRR #YR-> 10 Cash Flow 168.22%
5 year Running Average $2.91 $3.15 $3.09 $2.83 $2.86 $3.04 $3.01 $2.89 $3.82 $4.98 $5.29 $5.82 $6.87 $7.55 $7.65 $8.19 26.23% <-IRR #YR-> 5 Cash Flow 220.45%
P/CF on Med Price 4.87 5.23 6.58 11.06 6.99 4.70 4.86 6.68 3.32 4.25 7.03 7.59 5.73 5.85 0.00 0.00 10.93% <-IRR #YR-> 10 Cash Flow per Share 182.10%
P/CF on Closing Price 5.41 4.64 5.87 13.77 7.56 3.91 5.65 7.68 4.31 4.28 7.03 6.97 6.41 6.54 6.72 7.39 29.52% <-IRR #YR-> 5 Cash Flow per Share 264.50%
5.43% Diff M/C 8.32% <-IRR #YR-> 10 CFPS 5 yr Running 122.39%
Excl.Working Capital CF $33.0 $744.0 -$239.0 $542.0 -$299 -$1,346 $1,033 $166 -$964 -$79 $2,417 $743 -$672 0.00% 0.00% 0.00% 18.93% <-IRR #YR-> 5 CFPS 5 yr Running 137.96%
CF fr Op $M WC $7,251 $9,203 $5,393 $3,994 $6,963 $8,775 $9,862 $4,880 $13,514 $19,312 $14,770 $14,129 $14,434 $19,908 $19,363 $17,621 167.64% <-Total Growth 10 Cash Flow less WC
Increase 25.84% 26.92% -41.40% -25.94% 74.34% 26.02% 12.39% -50.52% 176.93% 42.90% -23.52% -4.34% 2.16% 37.93% -2.74% -9.00% 10.35% <-IRR #YR-> 10 Cash Flow less WC 167.64%
5 year Running Average $6,295 $6,926 $6,778 $6,321 $6,561 $6,866 $6,997 $6,895 $8,799 $11,269 $12,468 $13,321 $15,232 $16,511 $16,521 $17,091 24.22% <-IRR #YR-> 5 Cash Flow less WC 195.78%
CFPS Excl. WC $3.33 $4.21 $2.46 $1.80 $2.85 $3.65 $4.15 $2.06 $5.78 $8.76 $6.89 $6.72 $6.93 $9.56 $9.30 $8.47 8.43% <-IRR #YR-> 10 CF less WC 5 Yr Run 124.74%
Increase 26.39% 26.40% -41.55% -27.03% 58.39% 28.21% 13.81% -50.39% 180.60% 51.42% -21.36% -2.44% 3.21% 37.93% -2.74% -9.00% 17.18% <-IRR #YR-> 5 CF less WC 5 Yr Run 120.92%
5 year Running Average $2.89 $3.17 $3.10 $2.89 $2.93 $2.99 $2.98 $2.90 $3.70 $4.88 $5.53 $6.04 $7.02 $7.77 $7.88 $8.20 10.90% <-IRR #YR-> 10 CFPS - Less WC 181.50%
P/CF on Med Price 4.85 4.81 6.87 9.56 7.29 5.42 4.35 6.45 3.56 4.26 5.88 7.19 5.99 5.85 0.00 0.00 27.46% <-IRR #YR-> 5 CFPS - Less WC 236.44%
P/CF on Closing Price 5.39 4.26 6.13 11.90 7.89 4.51 5.05 7.42 4.62 4.29 5.88 6.61 6.70 6.54 6.72 7.39 8.50% <-IRR #YR-> 10 CFPS 5 yr Running 126.12%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 6.20 5 yr  5.73 P/CF Med 10 yr 5.94 5 yr  5.88 10.17% Diff M/C 19.31% <-IRR #YR-> 5 CFPS 5 yr Running 141.74%
-$2.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.26 Cash Flow per Share
-$1.99 $0.00 $0.00 $0.00 $0.00 $7.26 Cash Flow per Share
-$3.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.87 CFPS 5 yr Running
-$2.89 $0.00 $0.00 $0.00 $0.00 $6.87 CFPS 5 yr Running
-$5,393 $0 $0 $0 $0 $0 $0 $0 $0 $0 $14,434 Cash Flow less WC
-$4,880 $0 $0 $0 $0 $14,434 Cash Flow less WC
-$6,778 $0 $0 $0 $0 $0 $0 $0 $0 $0 $15,232 CF less WC 5 Yr Run
-$6,895 $0 $0 $0 $0 $15,232 CF less WC 5 Yr Run
OPM 40.22% 39.71% 42.77% 31.10% 41.10% 45.42% 36.19% 26.95% 44.07% 39.15% 30.25% 32.25% 34.20% 42.43% -20.04% <-Total Growth 10 OPM
Increase 4.91% -1.27% 7.71% -27.28% 32.14% 10.52% -20.32% -25.54% 63.51% -11.16% -22.73% 6.60% 6.06% 24.07% Should increase  or be stable.
Diff from Median 14.28% 12.82% 21.52% -11.63% 16.77% 29.05% 2.83% -23.43% 25.20% 11.23% -14.05% -8.38% -2.83% 20.56% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 35.20% 5 Yrs 34.20% should be  zero, it is a   check on calculations
$17,582 <-12 mths -0.16%
EBITDA $11,361 $5,519 $15,750 $22,113 $16,877 $16,408 $17,610 $23,069 $21,472 $18,625 <-Total Growth 6 EBITDA From
Change -51.42% 185.38% 40.40% -23.68% -2.78% 7.33% 31.00% -6.92% -13.26% 2.27% <-Median-> 6 Change Mkt Sc
Margin 49.67% 32.67% 52.40% 52.28% 46.92% 46.02% 45.43% 55.57% 53.74% 47.24% 46.92% <-Median-> 7 Margin
$8,465 <-12 mths 2.91%
EBIT $10,026 $14,760 $10,464 $9,727 $8,226 $15,396 $13,225 $11,160 <-Total Growth 4 EBIT From
Change 47.22% -29.11% -7.04% -15.43% 87.16% -14.10% -15.61% -11.24% <-Median-> 4 Change Mkt Sc
Margin 33.36% 34.90% 29.09% 27.28% 21.22% 37.09% 33.10% 28.30% 29.09% <-Median-> 5 Margin
Long Term Debt $8,217 $13,022 $15,065 $14,993 $20,581 $19,482 $18,591 $20,110 $13,694 $11,041 $9,819 $16,419 $16,176 $16,176 7.37% <-Total Growth 10 Debt Type
Change 3.51% 58.48% 15.69% -0.48% 37.27% -5.34% -4.57% 8.17% -31.90% -19.37% -11.07% 67.22% -1.48% 0.00% -3.03% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.21 0.33 0.46 0.32 0.37 0.49 0.37 0.56 0.22 0.13 0.11 0.18 0.17 0.12 0.27 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 9.89 11.71 12.90 11.52 11.80 15.03 11.77 14.82 10.33 8.80 10.22 8.86 11.39 11.39 11.45 <-Median-> 10 Assets/Current Liab. Ratio Liquidity
Debt to Cash Flow (Years) 1.14 1.54 2.67 4.34 2.83 1.92 2.11 4.27 0.95 0.57 0.79 1.23 1.07 0.81 1.58 <-Median-> 10 Debt to Cash Flow (Years) Liq. + CF
Debt Ratio
Intangibles $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.00% <-Total Growth 10 Intangibles Leverage
Goodwill $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.00% <-Total Growth 10 Goodwill D/E Ratio
Total $0 $0 $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% 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 0.00 0.00 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $2,216 $3,489 $4,059 $4,336 $4,897 $3,020 $4,487 $4,361 $5,942 $7,057 $7,167 $7,405 $7,664 $7,664 Liquidity ratio of 1.5 and up, best
Current Liabilities $5,234 $5,142 $4,595 $5,092 $6,261 $4,762 $6,637 $5,078 $7,422 $8,651 $7,435 $9,631 $8,063 $8,063 0.81 <-Median-> 10 Ratio
Liquidity 0.42 0.68 0.88 0.85 0.78 0.63 0.68 0.86 0.80 0.82 0.96 0.77 0.95 0.95 0.82 <-Median-> 5 Ratio
Liq. with CF aft div 1.70 2.14 1.89 1.33 1.73 2.42 1.75 1.40 2.46 2.70 2.11 1.71 2.22 2.78 2.22 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.73 0.67 0.86 0.76 0.56 1.20 0.83 0.90 1.64 1.71 1.28 0.69 1.22 2.78 1.28 <-Median-> 5 Ratio
Current portion L T D. $1,719 $980 $1,729 $1,812 $1,877 $1,141 $2,391 $1,343 $1,000 $404 $980 $980 $441 $441
Liquidity 0.63 0.84 1.42 1.32 1.12 0.83 1.06 1.17 0.93 0.86 1.11 0.86 1.01 1.01 0.93 <-Median-> 5 Ratio
Liq. with CF aft div 2.54 2.64 3.03 2.06 2.47 3.18 2.73 1.91 2.85 2.83 2.43 1.90 2.35 2.94 2.43 <-Median-> 5 Ratio
Assets $51,754 $60,200 $59,275 $58,648 $73,867 $71,559 $78,121 $75,276 $76,665 $76,142 $75,955 $85,359 $91,830 $91,830 Debt Ratio of 1.5 and up, best
Liabilities $25,982 $31,309 $31,984 $32,381 $42,214 $39,585 $43,130 $42,896 $39,720 $37,967 $36,123 $45,891 $47,464 $47,464 1.84 <-Median-> 10 Ratio
Debt Ratio 1.99 1.92 1.85 1.81 1.75 1.81 1.81 1.75 1.93 2.01 2.10 1.86 1.93 1.93 1.93 <-Median-> 5 Ratio
Estimates BVPS $23.42 $24.77 $24.89 Estimates Estimates BVPS
Estimate Book Value $48,750.6 $51,560.7 $51,810.5 Estimates Estimate Book Value
P/B Ratio (Close) 2.67 2.53 2.51 Estimates P/B Ratio (Close)
Difference from 10 year median 72.69% Diff M/C Estimates Difference from 10 yr med.
Book Value $25,772 $28,891 $27,291 $26,267 $31,653 $31,974 $34,991 $32,380 $36,945 $38,175 $39,832 $39,468 $44,366 $44,366 $44,366 $44,366 62.57% <-Total Growth 10 Book Value
Book Value per share $11.85 $13.23 $12.47 $11.82 $12.94 $13.30 $14.74 $13.68 $15.81 $17.31 $18.57 $18.77 $21.31 $21.31 $21.31 $21.31 70.98% <-Total Growth 10 Book Value per Share
Change 6.60% 11.64% -5.78% -5.16% 9.49% 2.77% 10.82% -7.23% 15.61% 9.49% 7.28% 1.06% 13.57% 0.00% 0.00% 0.00% 81.16% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.36 1.53 1.36 1.45 1.60 1.49 1.23 0.97 1.30 2.16 2.18 2.57 1.95 2.62 0.00 0.00 1.62 P/B Ratio Historical Median
P/B Ratio (Close) 1.52 1.36 1.21 1.81 1.74 1.24 1.42 1.12 1.69 2.17 2.18 2.36 2.18 2.93 2.93 2.93 5.51% <-IRR #YR-> 10 Book Value per Share 70.98%
Change 17.72% -10.48% -10.71% 49.30% -4.12% -28.65% 15.05% -21.49% 51.14% 28.48% 0.40% 8.45% -7.76% 34.55% 0.00% 0.00% 9.28% <-IRR #YR-> 5 Book Value per Share 55.85%
Median 10 year P/B Ratio 1.95 1.95 1.74 1.57 1.57 1.51 1.49 1.47 1.41 1.41 1.47 1.47 1.55 1.78 1.47 <-Median-> 5 Median 10 year P/B Ratio
Leverage (A/BK) 2.01 2.08 2.17 2.23 2.33 2.24 2.23 2.32 2.08 1.99 1.91 2.16 2.07 2.07 2.20 <-Median-> 10 A/BV
Debt/Equity Ratio 1.01 1.08 1.17 1.23 1.33 1.24 1.23 1.32 1.08 0.99 0.91 1.16 1.07 1.07 1.20 <-Median-> 10 Debt/Eq Ratio
Sharerholders' Equity P/BV 10 yr Med 1.55 5 yr Med 2.16 89.75% Diff M/C 2.24 Historical 30 A/BV
-$12.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21.31
-$13.68 $0.00 $0.00 $0.00 $0.00 $21.31
Comprehensive Income $2,254 $3,938 -$613 -$209 $2,259 $2,781 $5,328 -$461 $7,655 $11,147 $8,196 $6,235 $10,738 1851.71% <-Total Growth 10 Comprehensive Income
Increase 17.15% 74.71% -115.57% 65.91% 1180.86% 23.11% 91.59% -108.65% 1760.52% 45.62% -26.47% -23.93% 72.22% 45.62% <-Median-> 5 Comprehensive Income
5 Yr Running Average $1,937 $2,482 $2,033 $1,459 $1,526 $1,631 $1,909 $1,940 $3,512 $5,290 $6,373 $6,554 $8,794 #NUM! <-IRR #YR-> 10 Comprehensive Income 1851.71%
ROE 8.7% 13.6% -2.2% -0.8% 7.1% 8.7% 15.2% -1.4% 20.7% 29.2% 20.6% 15.8% 24.2% #NUM! <-IRR #YR-> 5 Comprehensive Income 2429.28%
5Yr Median 7.9% 8.7% 8.7% 7.9% 7.1% 7.1% 7.1% 7.1% 8.7% 15.2% 20.6% 20.6% 20.7% 15.77% <-IRR #YR-> 10 5 Yr Running Average 332.66%
% Difference from NI -0.7% 0.2% -3.8% 2.5% -5.8% 7.3% -1.6% 6.0% -0.1% 1.9% -0.4% 2.1% -0.8% 35.30% <-IRR #YR-> 5 5 Yr Running Average 353.40%
Median Values Diff 5, 10 yr 0.9% -0.1% 20.7% <-Median-> 5 Return on Equity
$613 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,738
$461 $0 $0 $0 $0 $10,738
-$2,033 $0 $0 $0 $0 $0 $0 $0 $0 $0 $8,794
-$1,940 $0 $0 $0 $0 $8,794
Current Liability Coverage Ratio 1.39 1.79 1.17 0.78 1.11 1.84 1.49 0.96 1.82 2.23 1.99 1.47 1.79 2.47   CFO / Current Liabilities
5 year Median 1.56 1.56 1.45 1.39 1.17 1.17 1.17 1.11 1.49 1.82 1.82 1.82 1.82 1.99 163.8% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 14.01% 15.29% 9.10% 6.81% 9.43% 12.26% 12.62% 6.48% 17.63% 25.36% 19.45% 16.55% 15.72% 21.68% CFO / Total Assets
5 year Median 14.01% 14.01% 13.28% 11.76% 9.43% 9.43% 9.43% 9.43% 12.26% 12.62% 17.63% 17.63% 17.63% 19.45% 14.2% <-Median-> 10 Return on Assets 
Return on Assets ROA 4.39% 6.53% -1.07% -0.35% 3.25% 3.62% 6.93% -0.58% 10.00% 14.36% 10.84% 7.15% 11.78% 108.96% Net  Income/Assets Return on Assets ROA
5Yr Median 3.98% 4.39% 4.39% 3.86% 3.25% 3.25% 3.25% 3.25% 3.62% 6.93% 10.00% 10.00% 10.84% 11.78% 7.0% <-Median-> 10 Asset Efficiency Ratio ROA
Return on Equity ROE 8.81% 13.60% -2.33% -0.78% 7.57% 8.10% 15.48% -1.34% 20.74% 28.65% 20.67% 15.47% 24.39% 225.53% Net Inc/ Shareholders' equity Return on Equity ROE
5Yr Median 8.13% 8.81% 8.81% 7.79% 7.57% 7.57% 7.57% 7.57% 8.10% 15.48% 20.67% 20.67% 20.74% 24.39% 15.5% <-Median-> 10 Return on Equity ROE
$10,442 <-12 mths -3.49% Estimates Last 12 months from Qtr
Net Income $2,270 $3,929 -$637 -$204 $2,397 $2,591 $5,416 -$435 $7,664 $10,937 $8,233 $6,106 $10,820 $100,057 $9,657 $7,987 1798.59% <-Total Growth 10 Net Income
Increase 19.98% 73.08% -116.21% 67.97% 1275.00% 8.09% 109.03% -108.03% 1861.84% 42.71% -24.72% -25.84% 77.20% 824.74% -90.35% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $2,016 $2,486 $2,019 $1,450 $1,551 $1,615 $1,913 $1,953 $3,527 $5,235 $6,363 $6,501 $8,752 $27,231 $26,975 #NUM! <-IRR #YR-> 10 Net Income 1798.59%
Operating Cash Flow $7,218 $8,459 $5,632 $3,452 $7,262 $10,121 $8,829 $4,714 $14,478 $19,391 $12,353 $13,386 $15,106 #NUM! <-IRR #YR-> 5 Net Income 2587.36%
Investment Cash Flow -$7,006 -$11,177 -$5,465 -$3,811 -$13,102 -$4,814 -$7,255 -$2,819 -$3,703 -$4,987 -$4,858 -$14,095 -$6,687 15.79% <-IRR #YR-> 10 5 Yr Running Average 333.40%
Total Accruals $2,058 $6,647 -$804 $155 $8,237 -$2,716 $3,842 -$2,330 -$3,111 -$3,467 $738 $6,815 $2,401 34.98% <-IRR #YR-> 5 5 Yr Running Average 348.13%
Total Assets $51,754 $60,200 $59,275 $58,648 $73,867 $71,559 $78,121 $75,276 $76,665 $76,142 $75,955 $85,359 $91,830 Balance Sheet Assets
Accruals Ratio 3.98% 11.04% -1.36% 0.26% 11.15% -3.80% 4.92% -3.10% -4.06% -4.55% 0.97% 7.98% 2.61% 0.97% <-Median-> 5 Ratio
EPS/CF Ratio 0.31 0.42 -0.12 -0.05 0.36 0.29 0.55 -0.09 0.56 0.54 0.54 0.42 0.74 0.48 <-Median-> 10 EPS/CF Ratio
$637 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,820
$435 $0 $0 $0 $0 $10,820
-$2,019 $0 $0 $0 $0 $0 $0 $0 $0 $0 $8,752
-$1,953 $0 $0 $0 $0 $8,752
Change in Close 25.49% -0.06% -15.87% 41.59% 4.98% -26.67% 27.50% -27.17% 74.73% 40.67% 7.71% 9.59% 4.75% 34.55% 0.00% 0.00% Count 31 Years of data
up/down down down down down Count 17 54.84%
Meet Prediction? Yes Yes % right Count 6 35.29%
Financial Cash Flow -$233 $2,727 -$123 $307 $5,960 -$5,343 -$1,536 -$1,850 -$10,215 -$14,228 -$7,538 -$37 -$7,877 C F Statement  Financial Cash Flow
Total Accruals $2,291 $3,920 -$681 -$152 $2,277 $2,627 $5,378 -$480 $7,104 $10,761 $8,276 $6,852 $10,278 Accruals
Accruals Ratio 4.43% 6.51% -1.15% -0.26% 3.08% 3.67% 6.88% -0.64% 9.27% 14.13% 10.90% 8.03% 11.19% 10.90% <-Median-> 5 Ratio
Cash $16 $25 $69 $17 $137 $101 $139 $184 $744 $920 $877 $131 $673 $673 Cash
Cash per Share $0.01 $0.01 $0.03 $0.01 $0.06 $0.04 $0.06 $0.08 $0.32 $0.42 $0.41 $0.06 $0.32 $0.32 $0.32 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.04% 0.06% 0.21% 0.04% 0.25% 0.26% 0.28% 0.51% 1.19% 1.11% 1.01% 0.14% 0.70% 0.52% 1.01% <-Median-> 5 % of Stock Price
Notes:
April 27, 2026.  Last estimates were for 2025, 2026, 2027 of $38073M, $37112M, $39461M Revenue, $6.83 2025ACF, $3.44, $3.48, $4.96 AEPS, $2.33, $2.42, $2.52 dividends, 
$9491M, $9065M, $8280M FCF, $7.30, $7.44, $8.87 CFPS, $18118M, $18518M, $18417M EBITDA, $19.27, $19.50, $1974 BVPS,  $7489M, $8260M, $8373M Net Income.
April 1, 2025.  Last estimates were for 2024, 2025 and 2026 of $36209M, $37812M, $38137M Revenue, $14808M, $14513M 2024/5 AFFO, $7.63, $9.50, $9.82 AEPS, 
$7.60, $8.64, $8.34 EPS, $4.19, $4.34, $4.74 dividends, $13.80, $15.50, $15.20 CFPS, $38.20, $40.00, $41.30 BVPS, $8483M, $9380M, 8729M Net Income.
April 17, 2024.  Last estimates were for 35915M, $35773M, $32827M for Revenue, $14.05 $13.98 2024/5 for AFFO, $7.75, $8.81 and $9.43 for AEPS, $6.82, $87.50 and $8.56 for EPS, 
$3.65, $3.68 and $4.29 for Dividends, $11085m, $11817M and $9024M for FCF, R14.20, $16.00 and $16.70 for CFPS, $36.50, $38.50 and $40.40 for BVPS, $8629M, $6299M 2023/4 for net Income.
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 is the largest producer of oil and the second-largest producer of natural gas in Canada.  The company also has smaller 
offshore production operations in the North Sea and 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 2018 April 14 2019 April 11 2020 April 17 2021 April 17 2022 April 17 2023 April 17 2024 April 19 2025 Apr 27 2026
Stauth, Scott Gerald 0.170 0.01% 0.172 0.01% 0.353 0.02% 0.380 0.02% 7.48%
President - Shares - Amount $6.892 $7.649 $16.422 $23.748
Options - percentage 0.836 0.04% 0.930 0.04% 2.014 0.10% 1.977 0.09% -1.83%
Options - amount $33.859 $41.260 $93.615 $123.644
Darel, Victor Clinton 0.017 0.00% 0.035 0.00% 0.038 0.00% Announcement 2025 7.32%
CFO - Shares - Amount $0.736 $1.629 $2.352
Options - percentage 0.103 0.00% 0.443 0.02% 0.662 0.03% 49.51%
Options - amount $4.566 $20.591 $41.420
Stainthrope, Mark Allen 0.025 0.00% 0.027 0.00% 0.393 0.02% 0.032 0.00% 0.033 0.00% 0.035 0.00% Filed last April 2019
CFO - Shares - Amount $0.516 $0.413 $10.504 $1.197 $1.345 $1.541 cannot find 2025
Options - percentage 0.075 0.00% 0.000 0.00% 0.414 0.02% 0.491 0.02% 0.544 0.03% 0.609 0.03%
Options - amount $1.571 $0.000 $11.053 $18.449 $22.045 $27.022
Zabek, Robin Sean 0.156 0.01% 0.171 0.01% 9.21%
Officer - Shares - Amount $7.270 $10.682
Options - percentage 0.535 0.03% 0.447 0.02% -16.43%
Options - amount $24.859 $27.951
Andersen, Troy John Peter 0.015 0.00% 0.017 0.00% 0.017 0.00% 0.023 0.00% 0.026 0.00% 0.028 0.00% 0.063 0.00% Ceased insider Mar2026
Officer - Shares - Amount $0.305 $0.259 $0.453 $0.870 $1.043 $1.246 $2.909
Options - percentage 0.305 0.01% 0.378 0.02% 0.462 0.02% 0.313 0.01% 0.297 0.01% 0.271 0.01% 0.628 0.03%
Options - amount $6.401 $5.789 $12.356 $11.759 $12.032 $12.027 $29.184
Balog, Brenda Gayle 0.028 0.00% 0.025 0.00% 0.053 0.00% 0.053 0.00% 0.76%
Officer - Shares - Amount $1.148 $1.117 $2.468 $3.346
Options - percentage 0.027 0.00% 0.042 0.00% 0.120 0.01% 0.151 0.01% 25.74%
Options - amount $1.093 $1.849 $5.572 $9.426
Bast, Calvin John 0.037 0.00% 0.030 0.00% 0.063 0.00% Executive vice-chairman 2019
Officer - Shares - Amount $1.484 $1.315 $2.948 Director 2021
Options - percentage 0.100 0.00% 0.144 0.01% 0.382 0.02% Ceased insider Mar 2026
Options - amount $4.064 $6.378 $17.740
Froc, Jay Ellery 0.057 0.00% 0.062 0.00% 9.39%
Officer - Shares - Amount $2.656 $3.909
Options - percentage 0.750 0.04% 0.704 0.03% -6.09%
Options - amount $34.871 $44.062
Laut, Stephen W. 0.10% 2.376 0.10% 2.393 0.10% 2.554 0.11% 1.839 0.08% 1.430 0.07% 0.457 0.02% 0.903 0.04% 0.879 0.04% Last updated April 2025 -2.60%
Director - Shares - Amount $39.140 $49.906 $36.595 $68.245 $69.142 $57.911 $20.270 $41.974 $55.007
Options - percentage 0.07% 1.642 0.07% 0.000 0.00% 0.621 0.03% 3.048 0.14% 3.137 0.15% 3.137 0.15% 6.274 0.30% 6.274 0.30% 0.00%
Options - amount $29.636 $34.491 $0.000 $16.590 $114.607 $127.029 $139.216 $291.669 $392.426
Best, Catherine May 0.00% 0.044 0.00% 0.048 0.00% 0.053 0.00% 0.056 0.00% 0.059 0.00% 0.061 0.00% 0.181 0.01% 0.185 0.01% 2.07%
Director - Shares - Amt $0.667 $0.934 $0.742 $1.415 $2.114 $2.377 $2.694 $8.414 $11.555
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 0.92% 21.954 0.92% 21.938 0.93% 21.939 0.94% 21.502 0.98% 21.259 0.99% 21.318 1.01% 85.272 4.10% 42.936 2.06% -49.65%
Chairman - Shares - Amt $362.571 $461.034 $335.535 $586.325 $808.356 $860.897 $946.095 $3,964.302 $2,685.652
Options - percentage 0.07% 2.348 0.10% 2.528 0.11% 3.020 0.13% 2.840 0.13% 2.505 0.12% 1.690 0.08% 3.751 0.18% 3.645 0.18% -2.81%
Options - amount $29.616 $49.317 $38.669 $80.701 $106.753 $101.429 $74.988 $174.383 $228.026
Increase in O/S Shares 0.58% 9.975 0.41% 10.871 0.46% 3.979 0.17% 18.147 0.78% 11.605 0.53% 9.882 0.46% 13.531 0.64% 12.062 0.58% Average 0.60%
due to SO 2013 $320.190 $164.288 $228.291 $60.859 $484.979 $436.290 $400.172 $600.506 $560.762 seems to be not accepting
Book Value $466.000 $332.000 $360.000 $108.000 $707.000 $442.000 $372.000 $280.000 $537.000 Options
Previous Lia. for SO $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Insider Buying -$3.966 -$4.805 -$2.443 -$2.093 -$1.691 -$0.164 $285.321 -$0.234 -$0.231
Insider Selling $83.132 $52.309 $60.697 $32.583 $172.877 $145.077 $0.000 $33.043 $86.559
Net Insider Selling $79.166 $47.504 $58.254 $30.490 $171.185 $144.913 $285.321 $32.810 $86.328
% of Market Cap 0.20% 0.10% 0.16% 0.05% 0.21% 0.17% 0.31% 0.03% 0.07%
Directors 11 12 11 12 11 12 12 13
Women 17% 2 18% 2 17% 2 18% 4 33% 3 27% 4 33% 4 33% 5 38%
Minorities 8% 1 9% 1 8% 1 9% 1 8% 1 9% 1 8% 1 8% 1 8%
Institutions/Holdings 431 67.01% 20 68.60% 20 52.66% 20 59.77% 20 59.77% 20 57.25% 20 57.92%
Total Shares Held 803.661 33.86% 754.250 31.86% 612.150 27.76% 657.098 30.64% 988.181 46.99% 1,201.907 57.74% 1,208.588 58.06%
Increase/Decrease 3 Mths -7.979 -0.98% 28.375 3.91% 13.064 2.18% 21.762 3.43% -32.858 -3.22% 3.335 0.28% 33.645 2.86%
Starting No. of Shares 811.640 Nasdaq 725.874 MS Top 599.085 MS Top 635.336 MS Top 1,021.038 MS Top 1,198.572 MS Top 1,174.944 MS Top
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock