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. Q3 2024
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ 29-Sep-24
Johnson and Johnson NE: JNJ NYSE: JNJ-N https://www.jnj.com/ Fiscal Yr: Dec 31
Year 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 12/31/26 Value Description #Y Item Total G Currency
Reporting Date 28-Dec-14 3-Jan-16 1-Jan-17 31-Dec-17 30-Dec-18 29-Dec-19 3-Jan-21 2-Jan-22 31-Dec-22 31-Dec-23 31-Dec-24 31-Dec-24 31-Dec-24
Accounting Rules US GAAP IFRS IFRS IFRS IFRS IFRS IFRS US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP
Split
USD - CDN$ 1.0213 0.9968 1.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2988 1.2678 1.3544 1.3226 1.3872 1.3872 1.3872 2.20% <-IRR #YR-> 10 USD - CDN$ 1.38%
Change 2.44% -2.40% 6.70% 9.07% 19.36% -3.04% -6.57% 8.74% -4.79% 0.00% -2.39% 6.83% -2.35% 4.88% 0.00% 0.00% -0.62% <-IRR #YR-> 5 USD - CDN$ 5.99%
$87,696 <-12 mths 2.98%
Kenvue IPO (excluding Kenvue) $78,740 $79,990 $85,159
Increase 1.59% 6.46%
Sales* $65,030 $67,224 $71,312 $74,331 $70,074 $71,890 $76,450 $81,581 $82,059 $82,584 $93,775 $94,943 $85,159 $88,786 $91,229 $94,615 19.42% <-Total Growth 10 Revenue US$
Increase 5.59% 3.37% 6.08% 4.23% -5.73% 2.59% 6.34% 6.71% 0.59% 0.64% 13.55% 1.25% -10.31% 4.26% 2.75% 3.71% 1.79% <-IRR #YR-> 10 Revenue 19.42% US$
5 year Running Average $62,671 $63,897 $65,410 $67,897 $69,594 $70,966 $72,811 $74,865 $76,411 $78,913 $83,290 $86,988 $87,704 $89,049 $90,778 $90,946 0.86% <-IRR #YR-> 5 Revenue 4.39% US$
Revenue per Share $23.87 $24.19 $25.28 $26.71 $25.43 $26.56 $28.50 $30.64 $31.17 $31.37 $35.67 $36.33 $35.38 $36.89 $37.90 $39.31 2.98% <-IRR #YR-> 10 5 yr Running Average 34.08% US$
Increase 6.13% 1.35% 4.50% 5.63% -4.77% 4.44% 7.29% 7.52% 1.73% 0.64% 13.70% 1.84% -2.61% 4.26% 2.75% 3.71% 3.22% <-IRR #YR-> 5 5 yr Running Average 17.15% US$
5 year Running Average $22.62 $23.19 $23.66 $24.51 $25.10 $25.64 $26.50 $27.57 $28.46 $29.65 $31.47 $33.04 $33.98 $35.13 $36.43 $37.16 3.42% <-IRR #YR-> 10 Revenue per Share 39.93% US$
P/S (Price/Sales) Med 2.63 2.78 3.28 3.66 3.88 4.16 4.48 4.36 4.37 4.28 4.66 4.74 4.61 4.09 0.00 0.00 2.92% <-IRR #YR-> 5 Revenue per Share 15.45% US$
P/S (Price/Sales) 2.75 2.90 3.62 3.92 4.04 4.34 4.90 4.21 4.68 5.02 4.80 4.86 4.43 4.35 4.24 4.43 3.69% <-IRR #YR-> 10 5 yr Running Average 43.66% US$
*Sales to Customers in M US $  P/S Med 20 yr  3.77 15 yr  4.16 10 yr  4.36 5 yr  4.61 -0.20% Diff M/C 4.27% <-IRR #YR-> 5 5 yr Running Average 23.27% US$
-$71,312 $0 $0 $0 $0 $0 $0 $0 $0 $0 $85,159
-$81,581 $0 $0 $0 $0 $85,159
-$65,410 $0 $0 $0 $0 $0 $0 $0 $0 $0 $87,704
-$74,865 $0 $0 $0 $0 $87,704
-$25.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $35.38
-$30.64 $0.00 $0.00 $0.00 $0.00 $35.38
-$23.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $33.98
-$27.57 $0.00 $0.00 $0.00 $0.00 $33.98
$24,858 <-12 mths -2.17%
$10.24 <-12 mths 3.23%
Adjusted Earnings $13,877 $14,345 $15,876 $18,318 $17,445 $18,764 $20,040 $22,315 $23,310 $21,433 $26,195 $27,038 $25,409 60.05% <-Total Growth 10 Adjusted EPS US$
Adjusted Earnings Basic $5.07 $5.21 $5.65 $6.51 $6.29 $6.85 $7.44 $8.32 $8.81 $8.14 $9.96 $10.30 $10.03 77.46% <-Total Growth 10 Adjusted Earnings Basic US$
Adjusted Earnings Diluted $5.00 $5.10 $5.52 $6.39 $6.20 $6.76 $7.30 $8.18 $8.68 $8.03 $9.80 $10.15 $9.92 $9.95 $10.63 $11.28 79.71% <-Total Growth 10 Adjusted Earnings Diluted US$
Increase 5.04% 2.00% 8.24% 15.76% -2.97% 9.03% 7.99% 12.05% 6.11% -7.49% 22.04% 3.57% -2.27% 0.30% 6.83% 6.11% 10 0 10 Years of Data, EPS P or N 100.00% US$
5 year Running Average $4.62 $4.81 $5.00 $5.35 $5.64 $5.99 $6.43 $6.97 $7.42 $7.79 $8.40 $8.97 $9.32 $9.57 $10.09 $10.39 6.04% <-IRR #YR-> 10 AEPS 79.71% US$
AEPS Yield 7.62% 7.28% 6.03% 6.11% 6.04% 5.87% 5.22% 6.34% 5.95% 5.10% 5.73% 5.75% 6.33% 6.20% 6.62% 6.47% 3.93% <-IRR #YR-> 5 AEPS 21.27% US$
Payout Ratio 45.00% 47.06% 46.92% 43.19% 47.58% 46.60% 45.48% 43.28% 43.20% 49.56% 42.76% 43.84% 47.38% 49.35% 46.66% 43.97% -1.97% <-IRR #YR-> 10 5 yr Running Average 5.01% US$
5 year Running Average 41.90% 43.50% 45.00% 45.30% 45.95% 46.27% 45.95% 45.23% 45.23% 45.62% 44.86% 44.53% 45.35% 46.58% 46.00% 46.24% 5.99% <-IRR #YR-> 5 5 yr Running Average -0.15% US$
Price/AEPS Median 12.56 13.21 15.04 15.31 15.90 16.36 17.50 16.33 15.68 16.72 16.97 16.95 16.42 15.17 0.01 0.00 16.39 <-Median-> 5 Price/AEPS Median US$
Price/AEPS High 13.58 14.22 17.26 17.07 17.16 18.55 19.67 18.07 16.87 19.60 18.31 18.33 18.17 16.82 0.00 0.00 18.24 <-Median-> 5 Price/AEPS High US$
Price/AEPS Low 11.53 12.20 12.83 13.56 14.63 14.16 15.32 14.60 14.48 13.84 15.62 15.58 14.68 13.52 0.00 0.00 14.62 <-Median-> 5 Price/AEPS Low US$
Price/AEPS Close 13.12 13.75 16.59 16.36 16.57 17.04 19.14 15.78 16.81 19.60 17.46 17.40 15.80 16.14 15.11 15.45 16.92 <-Median-> 5 Price/AEPS Close US$
Trailing P/AEPS Close 13.78 14.02 17.96 18.94 16.08 18.58 20.67 17.68 17.83 18.13 21.30 18.03 15.44 16.19 16.14 16.40 18.08 <-Median-> 5 Trailing P/AEPS Close US$
Adjusted Net Earnings DPR 10 Yrs 44.66% 5 Yrs   43.84% P/CF 5 Yrs   in order 16.72 18.31 14.68 17.40 -11.86% Diff M/C -11.86% Diff Med/Curr
$6.15 <-12 mths -55.17%
EPS Basic $3.49 $3.86 $4.92 $5.80 $5.56 $6.04 $0.48 $5.70 $5.72 $5.59 $7.93 $6.83 $13.88 182.11% <-Total Growth 10 EPS Basic US$
EPS Diluted* $3.49 $3.86 $4.81 $5.70 $5.48 $5.93 $0.47 $5.61 $5.63 $5.51 $7.81 $6.73 $13.72 $7.20 $8.64 $9.27 185.24% <-Total Growth 10 EPS Diluted US$
Increase -26.99% 10.60% 24.61% 18.50% -3.86% 8.21% -92.07% 1093.62% 0.36% -2.13% 41.74% -13.83% 103.86% -47.49% 19.91% 7.28% 10 0 10 Years of Data, EPS P or N US$
Earnings Yield 5.3% 5.5% 5.3% 5.5% 5.3% 5.1% 0.3% 4.3% 3.9% 3.5% 4.6% 3.8% 8.8% 4.5% 5.4% 5.3% 11.05% <-IRR #YR-> 10 Earnings per Share 185.24% US$
5 year Running Average $4.17 $4.22 $4.27 $4.53 $4.67 $5.16 $4.48 $4.64 $4.62 $4.63 $5.01 $6.26 $7.88 $8.19 $8.82 $9.11 19.59% <-IRR #YR-> 5 Earnings per Share 144.56% US$
10 year Running Average $3.55 $3.72 $3.96 $4.24 $4.45 $4.67 $4.35 $4.45 $4.58 $4.65 $5.08 $5.37 $6.26 $6.41 $6.73 $7.06 6.32% <-IRR #YR-> 10 5 yr Running Average 84.63% US$
* Diluted ESP per share  E/P 10 Yrs 4.46% 5Yrs 3.86% 11.18% <-IRR #YR-> 5 5 yr Running Average 69.90% US$
-$4.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.72
-$5.61 $0.00 $0.00 $0.00 $0.00 $13.72
-$4.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.88
-$4.64 $0.00 $0.00 $0.00 $0.00 $7.88
Dividend* $4.88 $5.09 $5.30 Estimates Dividend*
Increase 3.83% 4.39% 4.08% Estimates Increase
Payout Ratio EPS 67.74% 58.97% 57.21% Estimates Payout Ratio EPS
Special Dividends US$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends US$
pre-split 1997 US$
pre-split 2001 US$
Dividend* $2.25 $2.40 $2.59 $2.76 $2.95 $3.15 $3.32 $3.54 $3.75 $3.98 $4.19 $4.45 $4.70 $4.91 $4.96 $4.96 81.47% <-Total Growth 10 Dividends US$
Increase 6.64% 6.67% 7.92% 6.56% 6.88% 6.78% 5.40% 6.63% 5.93% 6.13% 5.28% 6.21% 5.62% 4.47% 1.02% 0.00% 35 0 35 Years of data, Count P, N 100.00% US$
Average Increases 5 Year Running 9.13% 8.19% 7.61% 7.42% 6.93% 6.96% 6.71% 6.45% 6.32% 6.17% 5.87% 6.03% 5.83% 5.54% 4.52% 3.46% 6.39% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $1.94 $2.10 $2.26 $2.42 $2.59 $2.77 $2.95 $3.14 $3.34 $3.55 $3.76 $3.98 $4.21 $4.45 $4.64 $4.80 86.79% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 3.58% 3.56% 3.12% 2.82% 2.99% 2.85% 2.60% 2.65% 2.76% 2.96% 2.52% 2.59% 2.88% 3.25% 2.79% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 3.31% 3.31% 2.72% 2.53% 2.77% 2.51% 2.31% 2.39% 2.56% 2.53% 2.33% 2.39% 2.61% 2.93% 2.52% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 3.90% 3.86% 3.66% 3.19% 3.25% 3.29% 2.97% 2.96% 2.98% 3.58% 2.74% 2.81% 3.23% 3.65% 3.08% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 3.43% 3.42% 2.83% 2.64% 2.87% 2.73% 2.38% 2.74% 2.57% 2.53% 2.45% 2.52% 3.00% 3.06% 3.09% 2.85% 2.61% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 64.47% 62.18% 53.85% 48.42% 53.83% 53.12% 706.38% 63.10% 66.61% 72.23% 53.65% 66.12% 34.26% 68.16% 57.42% 53.52% 39.14% <-Median-> 36 DPR EPS US$
DPR EPS 5 Yr Running 46.50% 49.69% 52.86% 53.49% 55.48% 53.72% 65.97% 67.79% 72.28% 76.63% 75.03% 63.63% 53.48% 54.25% 52.63% 52.64% 39.97% <-Median-> 32 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 42.87% 43.31% 41.95% 41.59% 42.16% 44.22% 42.30% 42.45% 42.16% 44.52% 47.05% 54.88% 49.64% 48.14% 48.20% 38.21% 32.13% <-Median-> 33 DPR CF US$
DPR CF 5 Yr Running 34.71% 37.21% 38.96% 40.93% 42.32% 42.65% 42.47% 42.55% 42.62% 43.11% 43.75% 46.10% 47.54% 41.94% 43.79% 45.25% 31.73% <-Median-> 29 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 48.46% 38.40% 39.80% 39.32% 45.31% 40.50% 90.74% 42.46% 50.49% 50.26% 39.84% 46.14% 55.77% 48.14% 48.20% 38.21% 34.96% <-Median-> 27 DPR CF WC US$
DPR CF WC 5 Yr Running 35.67% 36.61% 38.60% 39.42% 41.87% 40.66% 46.93% 47.20% 49.57% 50.51% 49.61% 45.41% 47.96% 47.60% 47.29% 46.53% 36.61% <-Median-> 23 DPR CF WC 5 Yr Running US$
Median Values 10 Yr Med 10 Yr Cl 2.79% 2.61% 5 Yr Med 5 Yr Cl 2.76% 2.53% 5 Yr Med Payout 66.12% 47.05% 50.26% 5.83% <-IRR #YR-> 5 Dividends 32.77% US$
* Dividends per share  10 Yr Med and Cur. 10.76% 18.55% 5 Yr Med and Cur. 12.07% 22.12% Last Div Inc ---> $1.19 $1.24 4.20% 6.14% <-IRR #YR-> 10 Dividends 81.47% US$
Dividends Growth 15 6.63% <-IRR #YR-> 15 Dividends 161.84% US$
Dividends Growth 20 8.47% <-IRR #YR-> 20 Dividends 408.11% US$
Dividends Growth 25 9.51% <-IRR #YR-> 25 Dividends 869.07% US$
Dividends Growth 30 10.24% <-IRR #YR-> 30 Dividends 1563.72% US$
Dividends Growth 35 11.05% <-IRR #YR-> 35 Dividends
Dividends Growth 5 -$3.54 $0.00 $0.00 $0.00 $0.00 $4.70 Dividends Growth 5
Dividends Growth 10 -$2.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.70 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 $4.70 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 $4.70 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 $4.70 Dividends Growth 25
Dividends Growth 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 $4.70 Dividends Growth 30
Dividends Growth 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 $4.70 Dividends Growth 35
Historical Dividends Historical High Div 3.75% Low Div 1.16% 10 Yr High 3.55% 10 Yr Low 2.32% Med Div 2.46% Close Div 2.25% Historical Dividends US$
High/Ave/Median Values Curr diff Exp. -17.65%     166.23% Exp. -13.01% Cheap 33.11% Cheap 25.54% Cheap 37.06% High/Ave/Median  US$
Future Dividend Yield Div Yd 4.10% earning in 5 Years at IRR of 5.83% Div Inc. 32.77% Future Dividend Yield US$
Future Dividend Yield Div Yd 5.44% earning in 10 Years at IRR of 5.83% Div Inc. 76.27% Future Dividend Yield US$
Future Dividend Yield Div Yd 7.23% earning in 15 Years at IRR of 5.83% Div Inc. 134.04% Future Dividend Yield US$
Future Dividend Paid Div Paid $6.59 earning in 5 Years at IRR of 5.83% Div Inc. 32.77% Future Dividend Paid US$
Future Dividend Paid Div Paid $8.74 earning in 10 Years at IRR of 5.83% Div Inc. 76.27% Future Dividend Paid US$
Future Dividend Paid Div Paid $11.61 earning in 15 Years at IRR of 5.83% Div Inc. 134.04% Future Dividend Paid US$
Dividend Covering Cost Total Div $27.87 over 5 Years at IRR of 5.83% Div Cov. 17.35% Dividend Covering Cost US$
Dividend Covering Cost Total Div $58.28 over 10 Years at IRR of 5.83% Div Cov. 36.29% Dividend Covering Cost US$
Dividend Covering Cost Total Div $98.66 over 15 Years at IRR of 5.83% Div Cov. 61.43% Dividend Covering Cost US$
Yield if held 5 years 3.56% 3.74% 4.08% 4.95% 4.79% 5.02% 4.93% 4.26% 3.83% 4.04% 3.79% 3.48% 3.52% 3.61% 3.69% 2.98% 4.15% <-Median-> 10 Dividends US$
Yield if held 10 years 4.45% 4.49% 4.84% 4.86% 4.55% 4.99% 5.17% 5.57% 6.72% 6.47% 6.67% 6.61% 5.66% 5.02% 5.03% 4.49% 5.62% <-Median-> 10 Dividends US$
Yield if held 15 years 9.41% 8.28% 6.77% 5.97% 6.86% 6.22% 6.21% 6.61% 6.61% 6.14% 6.63% 6.93% 7.40% 8.80% 8.06% 7.90% 6.61% <-Median-> 10 Dividends US$
Yield if held 20 years 19.88% 18.87% 23.35% 23.87% 16.16% 13.18% 11.45% 9.25% 8.12% 9.25% 8.28% 8.32% 8.77% 8.65% 7.66% 7.85% 9.25% <-Median-> 10 Dividends US$
Yield if held 25 years 53.30% 43.77% 38.18% 27.83% 26.10% 31.91% 32.43% 21.81% 17.53% 15.35% 12.28% 10.63% 11.53% 9.80% 26.97% <-Median-> 10 Dividends US$
Yield if held 30 years 72.85% 59.48% 51.51% 37.01% 34.99% 42.37% 42.46% 27.18% 20.75% 46.94% <-Median-> 6 Dividends
Yield if held 35 years 96.72% 77.87% 64.20% 43.82% 96.72% <-Median-> 1 Dividends US$
Cost covered if held 5 years 15.36% 16.32% 17.76% 21.71% 21.05% 22.06% 21.93% 18.93% 17.08% 18.00% 16.98% 15.59% 15.77% 16.34% 17.29% 14.42% 18.46% <-Median-> 10 Dividends US$
Cost covered if held 10 years 30.13% 31.53% 34.57% 35.57% 33.75% 37.28% 39.32% 42.51% 51.67% 49.88% 51.97% 51.48% 44.30% 39.80% 41.55% 38.67% 43.41% <-Median-> 10 Dividends US$
Cost covered if held 15 years 75.40% 69.00% 57.74% 52.63% 61.95% 57.50% 59.16% 63.92% 65.01% 61.13% 67.01% 70.31% 75.68% 91.52% 87.61% 90.16% 62.94% <-Median-> 10 Dividends US$
Cost covered if held 20 years 171.99% 170.20% 216.20% 228.86% 159.41% 133.33% 119.96% 98.81% 88.80% 103.18% 94.61% 96.41% 103.26% 104.19% 96.97% 104.96% 103.22% <-Median-> 10 Dividends US$
Cost covered if held 25 years 513.58% 437.38% 392.97% 294.34% 286.33% 357.90% 373.38% 256.61% 211.89% 188.65% 153.85% 136.91% 157.14% 141.99% 290.33% <-Median-> 10 Dividends US$
Cost covered if held 30 years 837.08% 702.41% 622.58% 460.24% 442.87% 547.83% 565.64% 383.79% 312.20% 585.20% <-Median-> 6 Dividends US$
Cost covered if held 35 years 1270.68% 1054.99% 922.98% 672.08% 1270.68% <-Median-> 1 Dividends US$
Yr  Item Tot. Growth Per Year
Revenue Growth  $81,581 $82,059 $82,584 $93,775 $94,943 $85,159 $87,696 <-12 mths 2.98% 4.39% <-Total Growth 5 Revenue Growth  4.39% 0.86%
AEPS Growth $8.18 $8.68 $8.03 $9.80 $10.15 $9.92 $10.24 <-12 mths 3.23% 21.27% <-Total Growth 5 AEPS Growth 21.27% 3.93%
Net Income Growth $15,297 $15,119 $14,714 $20,878 $17,941 $35,153 $14,684 <-12 mths -58.23% 129.80% <-Total Growth 5 Net Income Growth 129.80% 18.11%
Cash Flow Growth $22,201 $23,416 $23,536 $23,410 $21,194 $22,791 $25,146 <-12 mths 10.33% 2.66% <-Total Growth 5 Cash Flow Growth 2.66% 0.53%
Dividend Growth $3.54 $3.75 $3.98 $4.19 $4.45 $4.70 $4.91 <-12 mths 4.47% 32.77% <-Total Growth 5 Dividend Growth 32.77% 5.83%
Stock Price Growth $129.05 $145.87 $157.38 $171.07 $176.65 $156.74 $160.61 <-12 mths 2.47% 21.46% <-Total Growth 5 Stock Price Growth 21.46% 3.96%
Revenue Growth  $71,312 $74,331 $70,074 $71,890 $76,450 $81,581 $82,059 $82,584 $93,775 $94,943 $85,159 $87,696 <-12 mths 2.98% 19.42% <-Total Growth 10 Revenue Growth  19.42% 1.79%
AEPS Growth $5.52 $6.39 $6.20 $6.76 $7.30 $8.18 $8.68 $8.03 $9.80 $10.15 $9.92 $10.24 <-12 mths 3.23% 79.71% <-Total Growth 10 AEPS Growth 79.71% 6.04%
Net Income Growth $13,831 $16,323 $15,409 $16,540 $1,300 $15,297 $15,119 $14,714 $20,878 $17,941 $35,153 $14,684 <-12 mths -58.23% 154.16% <-Total Growth 10 Net Income Growth 154.16% 9.78%
Cash Flow Growth $17,414 $18,471 $19,279 $19,279 $21,056 $22,201 $23,416 $23,536 $23,410 $21,194 $22,791 $25,146 <-12 mths 10.33% 30.88% <-Total Growth 10 Cash Flow Growth 30.88% 2.73%
Dividend Growth $2.59 $2.76 $2.95 $3.15 $3.32 $3.54 $3.75 $3.98 $4.19 $4.45 $4.70 $4.9 <-12 mths 4.47% 81.47% <-Total Growth 10 Dividend Growth 81.47% 6.14%
Stock Price Growth $91.59 $104.57 $102.72 $115.21 $139.72 $129.05 $145.87 $157.38 $171.07 $176.65 $156.74 $160.61 <-12 mths 2.47% 71.13% <-Total Growth 10 Stock Price Growth 71.13% 5.52%
Dividends on Shares US$ $30.36 $32.45 $34.65 $36.52 $38.94 $41.25 $43.78 $46.09 $48.95 $51.70 $54.01 $54.56 $54.56 $404.69 No of Years 10 Total Divs 12/31/13
Paid  $1,007.49 $1,150.27 $1,129.92 $1,267.31 $1,536.92 $1,419.55 $1,604.57 $1,731.18 $1,881.77 $1,943.15 $1,724.14 $1,766.71 $1,766.71 $1,917.08 $1,724.14 No of Years 10 Worth $91.59 10.92
Total $2,128.83
Graham No. AEPS $48.55 $51.74 $57.10 $60.03 $60.02 $62.91 $60.69 $64.27 $66.42 $65.90 $78.79 $81.92 $79.86 $80.78 $83.49 $86.01 39.85% <-Total Growth 10 Graham Number AEPS US$
Price/GP Ratio Med 1.29 1.30 1.45 1.63 1.64 1.76 2.10 2.08 2.05 2.04 2.11 2.10 2.04 1.87 2.04 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 1.40 1.40 1.67 1.82 1.77 1.99 2.37 2.30 2.20 2.39 2.28 2.27 2.26 2.07 2.26 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 1.19 1.20 1.24 1.44 1.51 1.52 1.84 1.86 1.89 1.69 1.94 1.93 1.82 1.66 1.83 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 1.35 1.35 1.60 1.74 1.71 1.83 2.30 2.01 2.20 2.39 2.17 2.16 1.96 1.99 1.92 2.03 2.08 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close 35.07% 35.48% 60.39% 74.21% 71.14% 83.14% 130.21% 100.79% 119.61% 138.81% 117.11% 115.63% 96.28% 98.83% 92.36% 102.63% 108.21% <-Median-> 10 Graham Price
Graham No. EPS $40.56 $45.01 $53.30 $56.69 $56.43 $58.92 $15.40 $53.23 $53.50 $54.59 $70.34 $66.71 $93.92 $68.73 $75.26 $77.96 76.19% <-Total Growth 10 Graham Number EPS US$
Price/GP Ratio Med 1.55 1.50 1.56 1.73 1.75 1.88 8.29 2.51 2.54 2.46 2.36 2.58 1.73 2.20 2.41 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 1.67 1.61 1.79 1.92 1.89 2.13 9.33 2.78 2.74 2.88 2.55 2.79 1.92 2.44 2.64 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 1.42 1.38 1.33 1.53 1.61 1.63 7.26 2.24 2.35 2.04 2.18 2.37 1.55 1.96 2.11 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 1.62 1.56 1.72 1.84 1.82 1.96 9.07 2.42 2.73 2.88 2.43 2.65 1.67 2.34 2.13 2.24 2.43 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close 61.67% 55.73% 71.82% 84.45% 82.04% 95.54% 807.27% 142.46% 172.68% 188.30% 143.20% 164.81% 66.90% 133.67% 113.39% 123.56% 142.83% <-Median-> 10 Graham Price
Dividend Cdn$ * $6.77 $7.07 $7.35 Estimates Dividend Cdn$ *
Increase 8.90% 4.39% 4.08% Estimates Increase
Payout Ratio EPS 67.74% 58.97% 57.21% Estimates Payout Ratio EPS
Special Dividend Cdn$ * $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00% <-Median-> 10 Special Dividends CDN$
Dividend Cdn$ * $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 $6.22 $6.81 $6.88 $6.88 125.66% <-Total Growth 10 Dividends CDN$
Increase 9.24% 4.11% 15.15% 16.23% 27.58% 3.54% -1.53% 15.95% 0.85% 6.13% 2.76% 13.46% 3.14% 9.57% 1.02% 0.00% 4.84% <-Median-> 10 Dividends CDN$
Yield  3.43% 3.42% 2.83% 2.64% 2.87% 2.73% 2.38% 2.74% 2.57% 2.53% 2.45% 2.52% 3.00% 3.06% 3.09% 2.85% 5.18% <-IRR #YR-> 5 Dividends 28.72% CDN$
Median Values 10 Yr Med 10 Yr Cl 2.61% 5 Yr M Yield  2.53% 8.48% <-IRR #YR-> 10 Dividends 125.66% CDN$
* Dividends per share  10 Yr Med and Cur. -60.91% 5 Yr Med and Cur. -59.73% $1.19 124.0% 4.2% 7.18% <-IRR #YR-> 14 Dividends 236.07% CDN$
Dividends Growth 20 8.59% <-IRR #YR-> 20 Dividends 419.98% CDN$
Dividends Growth 25 10.61% <-IRR #YR-> 25 Dividends 731.08% CDN$
Dividends Growth 30 10.22% <-IRR #YR-> 30 Dividends CDN$
Dividends Growth 35 11.47% <-IRR #YR-> 35 Dividends CDN$
Dividends Growth 5 -$4.83 $0.00 $0.00 $0.00 $0.00 $6.22 Dividends Growth 5 CDN$
Dividends Growth 10 -$2.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.22 Dividends Growth 10 CDN$
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 $6.22 Dividends Growth 15 CDN$
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 $6.22 Dividends Growth 20 CDN$
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 $6.22 Dividends Growth 25 CDN$
Close Cdn$ $66.98 $69.88 $97.42 $121.31 $142.24 $154.69 $175.28 $176.05 $189.46 $204.41 $216.88 $239.25 $207.30 $222.80 $222.80 $241.76 3.32% <-IRR #YR-> 5 Stock Price 17.75% CDN$
5 yr Period ending 12/31/11 12/31/12 01/11/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 7.84% <-IRR #YR-> 10 Stock Price 112.81% CDN$
5 year IRR 0.07% 4.45% 8.67% 15.35% 21.52% 21.71% 23.84% 15.88% 12.39% 10.35% 9.74% 9.06% 6.25% 12.39% <-Median-> 31 5 year IRR CDN$
6.24% <-IRR #YR-> 5 Price & Dividend 34.53% CDN$
As a Canadian, would I have made money on this stock? Looking at 5 year periods to, including Dividends D.  per yr 3.47% 2.92% % Tot Ret 30.68% 46.80% 11.32% <-IRR #YR-> 10 Price & Dividend 165.89% CDN$
Price 15 D.  per yr 3.11% % Tot Ret 30.25% 7.18% <-IRR #YR-> 15 Stock Price 182.94% CDN$
Price  20 D.  per yr 2.66% % Tot Ret 30.92% 5.94% <-IRR #YR-> 20 Stock Price 216.88% CDN$
Price  25 D.  per yr 2.17% % Tot Ret 31.22% 4.77% <-IRR #YR-> 25 Stock Price 220.72% CDN$
Price  30 D.  per yr 3.54% % Tot Ret 27.84% 9.17% <-IRR #YR-> 30 Stock Price 1288.83% CDN$
Price  35 D.  per yr 4.18% % Tot Ret 28.36% 10.57% <-IRR #YR-> 35 Stock Price
Price & Dividend 15 10.29% <-IRR #YR-> 15 Price & Dividend 264.39% CDN$
Price & Dividend 20 8.59% <-IRR #YR-> 20 Price & Dividend 320.78% CDN$
Price & Dividend 25 6.94% <-IRR #YR-> 25 Price & Dividend 334.10% CDN$
Price & Dividend 30 12.70% <-IRR #YR-> 30 Price & Dividend 1800.07% CDN$
Price & Dividend 35 14.75% <-IRR #YR-> 35 Price & Dividend
Price  5 -$176.05 $0.00 $0.00 $0.00 $0.00 $207.30 Price  5
Price 10 -$97.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $207.30 Price 10
Price & Dividend 5 -$176.05 $4.87 $5.17 $5.31 $6.03 $213.52 Price & Dividend 5
Price & Dividend 10 -$97.42 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 $213.52 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 $207.30 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 $207.30 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 $207.30 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 $207.30 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 $207.30 Price  35
Price & Dividend 15 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 $213.52 Price & Dividend 15
Price & Dividend 20 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 $213.52 Price & Dividend 20
Price & Dividend 25 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 $213.52 Price & Dividend 25
Price & Dividend 30 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 $213.52 Price & Dividend 30
Price & Dividend 35 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 $213.52 Price & Dividend 35
5 year IRR -$76.97 -$65.91 -$73.27 -$67.64 -$61.75 -$66.98 -$69.88 -$97.42 -$121.31 -$142.24 -$154.69 -$175.28 -$176.05 5 year IRR
5 year IRR $1.60 $2.20 $2.03 $2.10 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 5 year IRR
5 year IRR $2.20 $2.03 $2.10 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 5 year IRR
5 year IRR $2.03 $2.10 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 5 year IRR
5 year IRR $2.10 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.16 $4.83 $4.87 $5.17 $5.31 $6.03 5 year IRR
5 year IRR $69.31 $72.30 $100.20 $124.54 $146.35 $158.95 $179.47 $180.91 $194.35 $209.60 $222.22 $245.31 $213.55 5 year IRR
Close US$
5 yr Period ending 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 Date 5 yr Period ending US$
5 year IRR 2.79% 4.07% 12.04% 13.27% 14.06% 15.30% 18.01% 10.08% 9.67% 11.82% 11.01% 7.39% 6.97% 11.41% <-Median-> 10 5 year IRR US$
Median Div Yield Beg. of period 2.20% 2.43% 3.00% 3.00% 3.41% 3.43% 3.42% 2.83% 2.64% 2.87% 2.73% 2.38% 2.74% 2.85% <-Median-> 10 Median Div Yield Beg. of period US$
P/S Beginning of period 3.59 3.12 2.61 2.87 2.75 2.75 2.90 3.62 3.92 4.04 4.34 4.90 4.21 3.77 <-Median-> 10 P/S Beginning of period US$
P/E Beginning of Period 17.71 18.37 13.10 14.64 12.96 18.79 18.16 19.04 18.35 18.74 19.43 297.28 23.00 18.77 <-Median-> 10 P/E Beginning of Period US$
Month, Year Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25 Dec-26 35.00 <Count Years> Month, Year US$
pre-split 1989
pre-split 1992
pre-split 1996
pre-split 2001
Price Close US$ $65.58 $70.10 $91.59 $104.57 $102.72 $115.21 $139.72 $129.05 $145.87 $157.38 $171.07 $176.65 $156.74 $160.61 $160.61 $174.28 71.13% <-Total Growth 10 Stock Price US$
Increase 5.88% 6.89% 30.66% 14.17% -1.77% 12.16% 21.27% -7.64% 13.03% 7.89% 8.70% 3.26% -11.27% 2.47% 0.00% 8.51% 21.79 <-Median-> 10 CAPE (10 Yr P/E) US$
P/E 18.79 18.16 19.04 18.35 18.74 19.43 297.28 23.00 25.91 28.56 21.90 26.25 11.42 22.29 18.59 18.81 3.96% <-IRR #YR-> 5 Stock Price 21.46% US$
Trailing P/E 13.72 20.09 23.73 21.74 18.02 21.02 23.56 274.57 26.00 27.95 31.05 22.62 23.29 11.71 22.29 20.18 5.52% <-IRR #YR-> 10 Stock Price 71.13% US$
CAPE (10 Yr P/E) 17.25 16.92 16.93 16.75 16.95 17.21 20.14 21.22 22.43 24.13 24.15 24.85 22.35 22.70 22.50 22.27 6.97% <-IRR #YR-> 5 Price & Dividend 21.60% US$
Median 10, 5 Yrs D.  per yr 3.11% 3.01% % Tot Ret 36.01% 43.15% T P/E 23.43 26.00 P/E:  22.45 25.91 8.63% <-IRR #YR-> 10 Price & Dividend 71.60% US$
Price 15 D.  per yr 3.30% % Tot Ret 33.23% Year Start.P/E Tot Ret CAPE Diff 2.34% 6.63% <-IRR #YR-> 15 Stock Price 161.84% US$
Price  20 D.  per yr 2.92% % Tot Ret 33.41% 5.81% <-IRR #YR-> 20 Stock Price 209.64% US$
Price  25 D.  per yr 2.49% % Tot Ret 31.46% 5.42% <-IRR #YR-> 25 Stock Price 273.97% US$
Price  30 D.  per yr 3.67% % Tot Ret 28.56% 9.19% <-IRR #YR-> 30 Stock Price 1297.13% US$
Price  35 D.  per yr 3.97% % Tot Ret 28.11% 10.15% <-IRR #YR-> 35 Stock Price US$
Price & Dividend 15 9.93% <-IRR #YR-> 15 Price & Dividend 242.15% US$
Price & Dividend 20 8.73% <-IRR #YR-> 20 Price & Dividend 318.91% US$
Price & Dividend 25 7.90% <-IRR #YR-> 25 Price & Dividend 414.49% US$
Price & Dividend 30 12.86% <-IRR #YR-> 30 Price & Dividend 1841.10% US$
Price & Dividend 35 14.12% <-IRR #YR-> 35 Price & Dividend US$
Price  5 -$129.05 $0.00 $0.00 $0.00 $0.00 $156.74 Price  5
Price 10 -$91.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $156.74 Price 10
Price & Dividend 5 -$129.05 $3.75 $3.98 $4.19 $4.45 $161.44 Price & Dividend 5
Price & Dividend 10 -$91.59 $2.76 $2.95 $3.15 $3.32 $3.54 $3.75 $3.98 $4.19 $4.45 $161.44 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 $156.74 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 $156.74 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 $156.74 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 $156.74 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 $156.74 Price  35
Price & Dividend 15 $2.25 $2.40 $2.59 $2.76 $2.95 $3.15 $3.32 $3.54 $3.75 $3.98 $4.19 $4.45 $161.44 Price & Dividend 15
Price & Dividend 20 $2.25 $2.40 $2.59 $2.76 $2.95 $3.15 $3.32 $3.54 $3.75 $3.98 $4.19 $4.45 $161.44 Price & Dividend 20
Price & Dividend 25 $2.25 $2.40 $2.59 $2.76 $2.95 $3.15 $3.32 $3.54 $3.75 $3.98 $4.19 $4.45 $161.44 Price & Dividend 25
Price Med H/L $62.79 $67.37 $83.05 $97.85 $98.56 $110.58 $127.73 $133.62 $136.08 $134.26 $166.27 $172.08 $162.93 $150.93 8.51% 96.19% <-Total Growth 10 Stock Price US$
Increase 2.06% 7.29% 23.28% 17.82% 0.73% 12.19% 15.51% 4.61% 1.84% -1.34% 23.84% 3.49% -5.32% -7.36% 3.09% 6.97% <-IRR #YR-> 10 Stock Price 96.19% US$
P/E 17.99 17.45 17.27 17.17 17.99 18.65 271.77 23.82 24.17 24.37 21.29 25.57 11.88 20.95 11.60% 4.05% <-IRR #YR-> 5 Stock Price 21.93% US$
Trailing P/E 13.14 19.30 21.51 20.34 17.29 20.18 21.54 284.30 24.26 23.85 30.18 22.03 24.21 11.00 10.20% <-IRR #YR-> 10 Price & Dividend US$
P/E on Run. 5 yr Ave 15.04 15.96 19.46 21.61 21.11 21.45 28.52 28.81 29.43 29.00 33.21 27.50 20.68 18.42 6.95% <-IRR #YR-> 5 Price & Dividend US$
P/E on Run. 10 yr Ave 17.71 18.13 20.99 23.06 22.17 23.70 29.37 30.01 29.74 28.88 32.72 32.06 26.03 23.55 19.17 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 3.23% 2.90% % Tot Ret 31.68% 41.77% T P/E 22.94 24.21 P/E:  22.55 24.17
-$83.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $162.93
-$133.62 $0.00 $0.00 $0.00 $0.00 $162.93
-$83.05 $2.76 $2.95 $3.15 $3.32 $3.54 $3.75 $3.98 $4.19 $4.45 $167.63
-$133.62 $3.75 $3.98 $4.19 $4.45 $167.63
High Months Jul Oct Aug Nov Jan Aug Oct Dec Dec Dec Aug Apr Jan Sep
pre-split 1989
pre-split 1992
pre-split 1996
pre-split 2001
Price High $67.92 $72.52 $95.25 $109.07 $106.39 $125.40 $143.62 $147.84 $146.44 $157.38 $179.47 $186.01 $180.25 $167.38 89.24% <-Total Growth 10 Stock Price US$
Increase 2.86% 6.77% 31.34% 14.51% -2.46% 17.87% 14.53% 2.94% -0.95% 7.47% 14.04% 3.64% -3.10% -7.14% 6.59% <-IRR #YR-> 10 Stock Price 89.24% US$
P/E 19.46 18.79 19.80 19.14 19.41 21.15 305.57 26.35 26.01 28.56 22.98 27.64 13.14 23.23 4.04% <-IRR #YR-> 5 Stock Price 21.92% US$
Trailing P/E 14.21 20.78 24.68 22.68 18.66 22.88 24.22 314.55 26.10 27.95 32.57 23.82 26.78 12.20 21.97 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 25.16 26.78 P/E:  24.50 26.01 29.81 P/E Ratio Historical High US$
-$95.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $180.25
-$147.84 $0.00 $0.00 $0.00 $0.00 $180.25
Low Months Mar Jun Jan Feb Aug Jan Jan May Jan Mar Mar Feb Oct May
Price Low $57.66 $62.21 $70.84 $86.62 $90.73 $95.75 $111.84 $119.40 $125.72 $111.14 $153.07 $158.14 $145.60 $134.48 105.53% <-Total Growth 10 Stock Price US$
Increase 1.12% 7.89% 13.87% 22.28% 4.74% 5.53% 16.80% 6.76% 5.29% -11.60% 37.73% 3.31% -7.93% -7.64% 7.47% <-IRR #YR-> 10 Stock Price 105.53% US$
P/E 16.52 16.12 14.73 15.20 16.56 16.15 237.96 21.28 22.33 20.17 19.60 23.50 10.61 18.67 4.05% <-IRR #YR-> 5 Stock Price 21.94% US$
Trailing P/E 12.06 17.83 18.35 18.01 15.92 17.47 18.86 254.04 22.41 19.74 27.78 20.25 21.63 9.80 16.55 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 19.99 21.63 P/E:  19.88 20.17 13.38 P/E Ratio Historical Low US$
-$70.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $145.60
$24,629 <-12 mths 34.97%
Free Cash Flow WSJ $11,000 $12,000 $14,000 $14,757 $15,816 $15,541 $17,777 $18,531 $19,918 $20,189 $19,758 $17,185 $18,248 $17,573 $22,449 $22,201 30.34% <-Total Growth 10 Free Cash Flow US$
Change -21.43% 9.09% 16.67% 5.41% 7.18% -1.74% 14.39% 4.24% 7.48% 1.36% -2.13% -13.02% 6.19% -3.70% 27.75% -1.10% -0.31% <-IRR #YR-> 5 Free Cash Flow MS -1.53% US$
FCF/CF from Op Ratio 0.77 0.78 0.80 0.80 0.82 0.81 0.84 0.83 0.85 0.86 0.84 0.81 0.80 0.72 0.91 0.71 2.69% <-IRR #YR-> 10 Free Cash Flow MS 30.34% US$
Dividends paid $6,129 $6,668 $7,305 $7,768 $8,173 $8,621 $8,943 $9,494 $9,917 $10,481 $11,032 $11,682 $11,770 $11,819 $11,939 $11,939 61.11% <-Total Growth 10 Dividends paid US$
Percentage paid 51.68% 55.47% 50.31% 51.23% 49.79% 51.91% 55.84% 67.98% 64.50% 67.26% 53.18% 53.78% $0.52 <-Median-> 9 Percentage paid US$
5 Year Coverage 51.55% 51.61% 51.85% 55.04% 57.59% 61.09% 61.17% 60.57% 5 Year Coverage US$
Dividend Coverage Ratio 1.94 1.80 1.99 1.95 2.01 1.93 1.79 1.47 1.55 1.49 1.88 1.86 1.93 <-Median-> 9 Dividend Coverage Ratio US$
5 Year of Coverage 1.94 1.94 1.93 1.82 1.74 1.64 1.63 1.65 5 Year of Coverage US$
Market Cap US$ $178,640 $194,772 $258,341 $291,042 $283,010 $311,817 $374,802 $343,573 $384,004 $414,304 $449,737 $461,692 $377,285 $386,601 $386,601 $419,506 46.04% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $182,450 $194,155 $274,772 $337,637 $391,896 $418,677 $470,190 $468,702 $498,744 $538,098 $570,177 $625,316 $498,998 $536,293 $536,293 $581,938 81.60% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 2,775.3 2,812.6 2,877.0 2,863.9 2,112.9 2,788.9 2,745.3 2,728.7 2,684.3 2,670.7 2,667.5 2,663.9 2,560.4 2,661.3 -11.00% <-Total Growth 10 Diluted
Change -0.48% 1.34% 2.29% -0.46% -26.22% 31.99% -1.56% -0.60% -1.63% -0.51% -0.12% -0.13% -3.89% 3.94% -0.56% <-Median-> 10 Change
Difference Diluted/Basic -1.4% -2.1% -2.4% -1.7% 31.2% -1.9% -1.9% -1.7% -1.5% -1.4% -1.4% -1.5% -1.1% -1.1% -1.46% <-Median-> 10 Difference Diluted/Basic
Basic # of Shares in Millions 2,736.0 2,753.3 2,809.2 2,815.2 2,771.8 2,737.3 2,692.0 2,681.5 2,645.1 2,632.8 2,628.9 2,625.2 2,533.5 2,633.0 -9.81% <-Total Growth 10 Basic
Change -0.56% 0.63% 2.03% 0.21% -1.54% -1.24% -1.65% -0.39% -1.36% -0.47% -0.15% -0.14% -3.49% 3.93% -0.85% <-Median-> 10 Change
Difference Basic/Outstanding -0.4% 0.9% 0.4% -1.1% -0.6% -1.1% -0.4% -0.7% -0.5% 0.0% 0.0% -0.4% -5.0% -8.6% -0.54% <-Median-> 10 Difference Basic/Outstanding
Shares 3,119.8 3,119.8 3,119.8 3,119.8 3,119.8 3,119.8 3,119.8 3,119.8 3,119.8 $25,146 <-12 mths 10.33%
Shares less Treasury shares 2,755.2 2,706.5 2,682.5 2,662.3 2,632.5 2,632.5 2,629.0 2,613.6 2,407.1
# of Share in Millions 2,724.0 2,778.5 2,820.6 2,783.2 2,755.2 2,706.5 2,682.5 2,662.3 2,632.5 2,632.5 2,629.0 2,613.6 2,407.1 2,407.1 2,407.1 2,407.1 -1.57% <-IRR #YR-> 10 Shares -14.66% Issued less
Change -0.51% 2.00% 1.52% -1.33% -1.01% -1.77% -0.89% -0.75% -1.12% 0.00% -0.13% -0.58% -7.90% 0.00% 0.00% 0.00% -2.00% <-IRR #YR-> 5 Shares -9.59% See TD
CF fr Op $M $14,298 $15,396 $17,414 $18,471 $19,279 $19,279 $21,056 $22,201 $23,416 $23,536 $23,410 $21,194 $22,791 $24,552 $24,769 $31,244 30.88% <-Total Growth 10 Cash Flow US$
Increase -12.74% 7.68% 13.11% 6.07% 4.37% 0.00% 9.22% 5.44% 5.47% 0.51% -0.54% -9.47% 7.54% 7.73% 0.88% 26.14% SO, S. Iss Buy Backs US$
5 year Running Average $15,495 $15,524 $16,013 $16,393 $16,972 $17,968 $19,100 $20,057 $21,046 $21,898 $22,724 $22,751 $22,869 $23,097 $23,343 $24,910 42.82% <-Total Growth 10 CF 5 Yr Running US$
CFPS $5.25 $5.54 $6.17 $6.64 $7.00 $7.12 $7.85 $8.34 $8.89 $8.94 $8.90 $8.11 $9.47 $10.20 $10.29 $12.98 53.36% <-Total Growth 10 Cash Flow per Share US$
Increase -12.29% 5.57% 11.42% 7.50% 5.44% 1.80% 10.19% 6.24% 6.67% 0.51% -0.40% -8.93% 16.76% 7.73% 0.88% 26.14% 2.73% <-IRR #YR-> 10 Cash Flow 30.88% US$
5 year Running Average $5.59 $5.64 $5.79 $5.92 $6.12 $6.49 $6.96 $7.39 $7.84 $8.23 $8.59 $8.64 $8.86 $10.60 $10.60 $10.60 0.53% <-IRR #YR-> 5 Cash Flow 2.66% US$
P/CF on Med Price 11.96 12.16 13.45 14.74 14.09 15.52 16.27 16.02 15.30 15.02 18.67 21.22 17.21 14.80 0.01 0.00 4.37% <-IRR #YR-> 10 Cash Flow per Share 53.36% US$
P/CF on Closing Price 12.49 12.65 14.84 15.76 14.68 16.17 17.80 15.48 16.40 17.60 19.21 21.78 16.55 15.75 15.61 13.43 2.57% <-IRR #YR-> 5 Cash Flow per Share 13.54% US$
-0.17% Diff M/C 4.35% <-IRR #YR-> 10 CFPS 5 yr Running 53.06% US$
Excl.Working Capital CF -$1,651 $1,969 $941 $1,066 -$1,339 $1,773 -$11,241 -$3 -$3,865 -$2,690 $4,238 $4,011 -$2,507 $0 $0 $0 3.71% <-IRR #YR-> 5 CFPS 5 yr Running 19.95% US$
CF fr Op $M WC $12,647 $17,365 $18,355 $19,537 $17,940 $21,052 $9,815 $22,198 $19,551 $20,846 $27,648 $25,205 $20,284 $24,552 $24,769 $31,244 10.51% <-Total Growth 10 Cash Flow less WC US$
Increase -26.71% 37.31% 5.70% 6.44% -8.17% 17.35% -53.38% 126.16% -11.92% 6.62% 32.63% -8.84% -19.52% 21.04% 0.88% 26.14% 1.00% <-IRR #YR-> 10 Cash Flow less WC 10.51% US$
5 year Running Average $15,071 $15,786 $16,171 $17,032 $17,169 $18,850 $17,340 $18,108 $18,111 $18,692 $20,012 $23,090 $22,707 $23,707 $24,492 $25,211 -1.79% <-IRR #YR-> 5 Cash Flow less WC -8.62% US$
CFPS Excl. WC $4.64 $6.25 $6.51 $7.02 $6.51 $7.78 $3.66 $8.34 $7.43 $7.92 $10.52 $9.64 $8.43 $10.20 $10.29 $12.98 3.45% <-IRR #YR-> 10 CF less WC 5 Yr Run 40.42% US$
Increase -26.33% 34.61% 4.12% 7.87% -7.24% 19.46% -52.96% 127.88% -10.93% 6.62% 32.81% -8.30% -12.62% 21.04% 0.88% 26.14% 4.63% <-IRR #YR-> 5 CF less WC 5 Yr Run 25.39% US$
5 year Running Average $5.44 $5.73 $5.84 $6.14 $6.19 $6.81 $6.30 $6.66 $6.74 $7.02 $7.57 $8.77 $8.79 $9.34 $9.82 $10.31 2.62% <-IRR #YR-> 10 CFPS - Less WC 29.50% US$
P/CF on Med Price 13.52 10.78 12.76 13.94 15.14 14.22 34.91 16.03 18.32 16.95 15.81 17.84 19.33 14.80 0.01 0.00 0.21% <-IRR #YR-> 5 CFPS - Less WC 1.07% US$
P/CF on Closing Price 14.13 11.22 14.07 14.90 15.78 14.81 38.19 15.48 19.64 19.87 16.27 18.32 18.60 15.75 15.61 13.43 4.16% <-IRR #YR-> 10 CFPS 5 yr Running 50.34% US$
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 15.77 5 yr  17.21 P/CF Med 10 yr 16.49 5 yr  17.84 -4.51% Diff M/C 5.69% <-IRR #YR-> 5 CFPS 5 yr Running 31.91% US$
-$6.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.47 Cash Flow per Share US$
-$8.34 $0.00 $0.00 $0.00 $0.00 $9.47 Cash Flow per Share US$
-$5.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.86 CFPS 5 yr Running US$
-$7.39 $0.00 $0.00 $0.00 $0.00 $8.86 CFPS 5 yr Running US$
-$18,355 $0 $0 $0 $0 $0 $0 $0 $0 $0 $20,284 Cash Flow less WC US$
-$22,198 $0 $0 $0 $0 $20,284 Cash Flow less WC US$
-$16,171 $0 $0 $0 $0 $0 $0 $0 $0 $0 $22,707 CF less WC 5 Yr Run US$
-$18,108 $0 $0 $0 $0 $22,707 CF less WC 5 Yr Run US$
-$6.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.43 CFPS - Less WC US$
-$8.34 $0.00 $0.00 $0.00 $0.00 $8.43 CFPS - Less WC US$
-$5.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.79 CFPS 5 yr Running US$
-$6.66 $0.00 $0.00 $0.00 $0.00 $8.79 CFPS 5 yr Running US$
OPM 21.99% 22.90% 24.42% 24.85% 27.51% 26.82% 27.54% 27.21% 28.54% 28.50% 24.96% 22.32% 26.76% 27.65% 9.60% <-Total Growth 10 OPM US$
Increase -17.36% 4.17% 6.62% 1.76% 10.72% -2.53% 2.70% -1.19% 4.86% -0.13% -12.41% -10.58% 19.89% 3.33% Should increase  or be stable. US$
Diff from Median -18.6% -15.2% -9.6% -8.0% 1.8% -0.7% 1.9% 0.7% 5.6% 5.5% -7.6% -17.4% -0.9% 2.4% 0.00 <-Median-> 10 OPM US$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 27.02% 5 Yrs 26.76% should be  zero, it is a   check on calculations US$
EBITDA $27,979 $27,145 $36,634 $32,630 $30,414 $29,972 $32,575 $34,756 EBITDA US$
Change -2.98% 34.96% -10.93% -6.79% -1.45% 8.68% 6.70% -4.89% <-Median-> 4 Change US$
Margin 34.10% 32.87% 39.07% 34.37% 35.71% 33.76% 35.71% 36.73% 34.37% <-Median-> 5 Margin US$
Long Term Debt $15,122 $12,857 $22,442 $30,675 $27,684 $26,494 $32,635 $29,985 $26,886 $25,881 $31,289 Debt US$
Change -14.98% 74.55% 36.69% -9.75% -4.30% 23.18% -8.12% -10.34% -3.74% 20.90% -4.30% <-Median-> 9 Change US$
Long Term Debt/ Market Cap Ratio 0.05 0.05 0.07 0.08 0.08 0.07 0.08 0.07 0.06 0.07 0.08 0.07 <-Median-> 10 % of Market C. US$
Assets/Current Liabilities Ratio 5.23 4.81 5.37 5.15 4.90 4.39 4.12 4.02 3.36 3.62 3.44 4.60 <-Median-> 10 Assets/Current Liab Ratio US$
Current Liabilities/Asset Ratio 0.19 0.21 0.19 0.19 0.20 0.23 0.24 0.25 0.30 0.28 0.29 0.22 <-Median-> 10 Current Liab/Asset Ratio US$
Debt to Cash Flow (Years) 0.82 0.67 1.16 1.46 1.25 1.13 1.39 1.28 1.27 1.14 1.27 1.21 <-Median-> 10 Debt to Cash Flow (Years) US$
Intangible $28,752 $27,947 $27,222 $25,764 $26,876 $53,228 $47,611 $47,643 $53,402 $46,392 $38,489 $34,175 $39,490 22.29% <-Total Growth 10 Intangibles US$
Goodwill   $22,424 $22,798 $21,832 $21,629 $22,805 $31,906 $30,453 $33,639 $36,393 $35,246 $36,047 $36,558 $44,799 60.36% <-Total Growth 10 Goodwill US$
Total $51,176 $50,745 $49,054 $47,393 $49,681 $85,134 $78,064 $81,282 $89,795 $81,638 $74,536 $70,733 $84,289 39.39% <-Total Growth 10 Total US$
Change -0.84% -3.33% -3.39% 4.83% 71.36% -8.30% 4.12% 10.47% -9.08% -8.70% -5.10% 19.17% -3.36% <-Median-> 10 Change US$
Intangibles/ Market Cap Ratio 0.26 0.20 0.17 0.17 0.16 0.23 0.23 0.21 0.22 0.18 0.16 0.19 0.22 0.19 <-Median-> 10 % of Market C. US$
Current Assets $54,316 $46,116 $56,407 $59,311 $60,210 $65,032 $43,088 $46,933 $45,274 $51,237 $60,979 $55,294 $53,495 $53,249 Liquidity ratio of 1.5 and up, best US$
Current Liabilities $22,811 $24,262 $25,675 $25,085 $27,747 $26,287 $30,537 $31,230 $35,964 $42,493 $45,226 $55,802 $46,282 $51,759 1.38 <-Median-> 10 Ratio US$
Liquidity 2.38 1.90 2.20 2.36 2.17 2.47 1.41 1.50 1.26 1.21 1.35 0.99 1.16 1.03 1.21 <-Median-> 5 Ratio US$
Liq. with CF aft div 2.74 2.26 2.59 2.79 2.57 2.88 1.81 1.91 1.64 1.51 1.62 1.16 1.40 1.27 1.51 <-Median-> 5 Ratio US$
Liq. CF re  Inv+Div  2.28 1.91 2.16 1.87 2.01 2.44 1.22 1.74 1.40 1.02 1.36 0.95 1.43 1.27 1.36 <-Median-> 5 Ratio US$
Assets $113,644 $121,347 $132,683 $131,119 $133,411 $141,208 $157,303 $152,954 $157,728 $174,894 $182,018 $187,378 $167,558 $178,287 Debt Ratio of 1.5 and up, best US$
Liabilities $56,564 $56,521 $58,630 $61,367 $62,261 $70,790 $97,143 $93,202 $98,257 $111,616 $107,995 $110,574 $98,784 $108,129 1.69 <-Median-> 10 Ratio US$
Debt Ratio 2.01 2.15 2.26 2.14 2.14 1.99 1.62 1.64 1.61 1.57 1.69 1.69 1.70 1.65 1.69 <-Median-> 5 Ratio US$
Estimates BVPS $30.08 $32.95 $36.25 Estimates Estimates BVPS
Estimate Book Value $72,405 $79,313 $87,257 Estimates Estimate Book Value
P/B Ratio (Close) 5.34 4.87 4.81 Estimates P/B Ratio (Close)
Difference from 10 year median -6.31% Diff M/C Estimates Difference from 10 yr med.
Book Value $57,080 $64,826 $74,053 $69,752 $71,150 $70,418 $60,160 $59,752 $59,471 $63,278 $74,023 $76,804 $68,774 $70,158 $70,158 $70,158 -7.13% <-Total Growth 10 Book Value US$
pre-split 2001
Book Value per Share $20.95 $23.33 $26.25 $25.06 $25.82 $26.02 $22.43 $22.44 $22.59 $24.04 $28.16 $29.39 $28.57 $29.15 $29.15 $29.15 8.83% <-Total Growth 10 Book Value per Share US$
Change 1.40% 11.34% 12.53% -4.54% 3.04% 0.75% -13.80% 0.08% 0.66% 6.40% 17.14% 4.37% -2.77% 2.01% 0.00% 0.00% -3.31% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 3.00 2.89 3.16 3.90 3.82 4.25 5.70 5.95 6.02 5.59 5.91 5.86 5.70 5.18 5.59 P/B Ratio Historical Median
P/B Ratio (Close) 3.13 3.00 3.49 4.17 3.98 4.43 6.23 5.75 6.46 6.55 6.08 6.01 5.49 5.51 5.51 5.98 0.85% <-IRR #YR-> 10 Book Value 8.83% US$
Change 4.41% -4.00% 16.11% 19.60% -4.67% 11.32% 40.69% -7.71% 12.30% 1.40% -7.20% -1.06% -8.74% 0.45% 0.00% 8.51% 4.95% <-IRR #YR-> 5 Book Value 27.30% US$
Leverage (A/BV) 1.99 1.87 1.79 1.88 1.88 2.01 2.61 2.56 2.65 2.76 2.46 2.44 2.44 2.54 2.46 <-Median-> 5 A/BV US$
Debt/Equity Ratio 0.99 0.87 0.79 0.88 0.88 1.01 1.61 1.56 1.65 1.76 1.46 1.44 1.44 1.54 1.46 <-Median-> 5 Debt/Eq R. US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 5.70 5 yr Med 5.86 -3.31% Diff M/C 1.88 Historical Leverage (A/BK)
-$26.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28.57
-$22.44 $0.00 $0.00 $0.00 $0.00 $28.57
$10,942 <-12 mths -64.02%
Comprehensive Income $7,571 $10,675 $16,781 $8,461 $12,966 $14,804 $3,002 $13,506 $14,450 $15,363 $23,062 $18,032 $30,412 81.23% <-Total Growth 10 Comprehensive Income US$
Increase -41.13% 41.00% 57.20% -49.58% 53.24% 14.18% -79.72% 349.90% 6.99% 6.32% 50.11% -21.81% 68.66% 6.99% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $11,050 $10,786 $12,410 $11,270 $11,291 $12,737 $11,203 $10,548 $11,746 $12,225 $13,877 $16,883 $20,264 6.13% <-IRR #YR-> 10 Comprehensive Income 81.23% US$
ROE 13.3% 16.5% 22.7% 12.1% 18.2% 21.0% 5.0% 22.6% 24.3% 24.3% 31.2% 23.5% 44.2% 17.63% <-IRR #YR-> 5 Comprehensive Income 125.17% US$
5Yr Median 22.7% 20.4% 22.7% 16.5% 16.5% 18.2% 18.2% 18.2% 21.0% 22.6% 24.3% 24.3% 24.3% 5.03% <-IRR #YR-> 10 5 Yr Running Average 63.28% US$
% Difference from NI -21.7% 1.5% 21.3% -48.2% -15.9% -10.5% 130.9% -11.7% -4.4% 4.4% 10.5% 0.5% -13.5% 13.95% <-IRR #YR-> 5 5 Yr Running Average 92.11% US$
Median Values Diff 5, 10 yr -7.5% 0.5% 24.3% <-Median-> 5 Return on Equity US$
-$16,781 $0 $0 $0 $0 $0 $0 $0 $0 $0 $30,412
-$13,506 $0 $0 $0 $0 $30,412
-$12,410 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $20,264
-$10,548 $0.0 $0.0 $0.0 $0.0 $20,264
Current Liability Coverage Ratio 0.55 0.72 0.71 0.78 0.65 0.80 0.32 0.71 0.54 0.49 0.61 0.45 0.44 0.47   CFO / Current Liabilities US$
5 year Median 0.70 0.72 0.71 0.72 0.71 0.72 0.71 0.71 0.65 0.54 0.54 0.54 0.49 0.47 0.58 <-Median-> 10 Current Liability Cov Ratio US$
Asset Efficiency Ratio 11.13% 14.31% 13.83% 14.90% 13.45% 14.91% 6.24% 14.51% 12.40% 11.92% 15.19% 13.45% 12.11% 13.77% CFO / Total Assets US$
5 year Median 16.77% 16.09% 14.31% 14.31% 13.83% 14.31% 13.83% 14.51% 13.45% 12.40% 12.40% 13.45% 12.40% 13.45% 13.4% <-Median-> 10 Return on Assets  US$
Return on Assets ROA 8.51% 8.66% 10.42% 12.45% 11.55% 11.71% 0.83% 10.00% 9.59% 8.41% 11.47% 9.57% 20.98% 10.79% Net  Income/Assets Return on Assets US$
5Yr Median 12.96% 12.95% 10.42% 10.42% 10.42% 11.55% 11.55% 11.55% 10.00% 9.59% 9.59% 9.59% 9.59% 10.79% 10.7% <-Median-> 10 Asset Efficiency Ratio US$
Return on Equity ROE 16.94% 16.22% 18.68% 23.40% 21.66% 23.49% 2.16% 25.60% 25.42% 23.25% 28.20% 23.36% 51.11% 27.42% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 24.25% 23.57% 18.68% 18.68% 18.68% 21.66% 21.66% 23.40% 23.49% 23.49% 25.42% 25.42% 25.42% 27.42% 23.4% <-Median-> 10 Return on Equity US$
$14,684 <-12 mths -58.23%
Net Income $9,672 $10,514 $13,831 $16,323 $15,409 $16,540 $1,300 $15,297 $15,119 $14,714 $20,878 $17,941 $35,153 $19,236 $20,383 $21,751 154.16% <-Total Growth 10 Net Income US$
Increase -27.46% 8.71% 31.55% 18.02% -5.60% 7.34% -92.14% 1076.69% -1.16% -2.68% 41.89% -14.07% 95.94% -45.28% 5.96% 6.71% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $11,759 $11,747 $11,923 $12,735 $13,150 $14,523 $12,681 $12,974 $12,733 $12,594 $13,462 $16,790 $20,761 $21,584 $22,718 $22,893 9.78% <-IRR #YR-> 10 Net Income 154.16% US$
Operating Cash Flow $14,298 $15,396 $17,414 $18,471 $19,279 $19,279 $21,056 $22,201 $23,416 $23,536 $23,410 $21,194 $22,791 18.11% <-IRR #YR-> 5 Net Income 129.80% US$
Investment Cash Flow -$4,612 -$4,510 -$5,163 -$12,305 -$7,735 -$4,761 -$14,868 -$3,167 -$6,194 -$20,825 -$8,683 -$12,371 $878 5.70% <-IRR #YR-> 10 5 Yr Running Average 74.12% US$
Total Accruals -$14 -$372 $1,580 $10,157 $3,865 $2,022 -$4,888 -$3,737 -$2,103 $12,003 $6,151 $9,118 $11,484 9.86% <-IRR #YR-> 5 5 Yr Running Average 60.02% US$
Total Assets $113,644 $121,347 $132,683 $131,119 $133,411 $141,208 $157,303 $152,954 $157,728 $174,894 $182,018 $187,378 $167,558 Balance Sheet Assets US$
Accruals Ratio -0.01% -0.31% 1.19% 7.75% 2.90% 1.43% -3.11% -2.44% -1.33% 6.86% 3.38% 4.87% 6.85% 4.87% <-Median-> 5 Ratio US$
EPS/CF Ratio 0.75 0.62 0.74 0.81 0.84 0.76 0.13 0.67 0.76 0.70 0.74 0.70 1.63 0.75 <-Median-> 10 EPS/CF Ratio US$
-$13,831 $0 $0 $0 $0 $0 $0 $0 $0 $0 $35,153
-$15,297 $0 $0 $0 $0 $35,153
-$11,923 $0 $0 $0 $0 $0 $0 $0 $0 $0 $20,761
-$12,974 $0 $0 $0 $0 $20,761
Change in Close 5.88% 6.89% 30.66% 14.17% -1.77% 12.16% 21.27% -7.64% 13.03% 7.89% 8.70% 3.26% -11.27% 2.47% 0.00% 8.51% Count 32 Years of data
up/down Down down down Count 7 21.88%
Meet Prediction? % right Count 1 14.29%
Financial Cash Flow -$4,452 -$20,562 -$6,091 -$12,260 -$10,846 -$8,551 -$7,673 -$18,510 -$18,015 -$6,120 -$14,047 -$8,871 -$15,825 C F Statement  Financial Cash Flow US$
Total Accruals $4,438 $20,190 $7,671 $22,417 $14,711 $10,573 $2,785 $14,773 $15,912 $18,123 $20,198 $17,989 $27,309 Accruals US$
Accruals Ratio 3.91% 16.64% 5.78% 17.10% 11.03% 7.49% 1.77% 9.66% 10.09% 10.36% 11.10% 9.60% 16.30% 10.36% <-Median-> 5 Ratio US$
Cash $24,542 $14,911 $20,927 $14,523 $13,732 $18,972 $17,824 $18,197 $17,305 $13,985 $14,487 $14,127 $21,859 $19,980 Cash US$
Cash per Share $9.01 $5.37 $7.42 $5.22 $4.98 $7.01 $6.64 $6.84 $6.57 $5.31 $5.51 $5.41 $9.08 $8.30 $5.51 <-Median-> 5 Cash per Share US$
Percentage of Stock Price 13.74% 7.66% 8.10% 4.99% 4.85% 6.08% 4.76% 5.30% 4.51% 3.38% 3.22% 3.06% 5.79% 5.17% 3.38% <-Median-> 5 % of Stock Price US$
Notes
October 26, 2024.  Last estimates were for 2023, 2024 and 2025 of $84752M, $87704M, $90100M Revenue, $10.09, $10.80, $11.22 AEPS, $6.73, $8.63, $9.63 EPS, $4.73, $4.89, $4.96 Dividend, $19,751M< $11676M, $23228M FCF, $10.20, $10.40, $11.20 CFPS, $30.70, $34.20, $37.30 BVPS, $15.525m, $21150M, $22151M Net Income.
October 27, 2023.  Last estimates were for 2022, 2023 and 2024 of $95038M, $97686M, $100178M for Revenue, $10.05, $10.36 and $10.75 for AEPS, $7.94, 
$8.78 and $9.32 for EPS $4.37, $4.61 and $4.84 for Dividends, $19850M, $25850M and $25665M for FCF, $10.60, $11.40 and $12.20 for CFPS, and $20.677M, $22440M and $23719M for Net Income.
October 30, 2022.  Last estimates were for $94279M, $97743M and $101520M for Revenue, $9.80, $10.33 and $10.94 for AEPS, $8.29, $9.30 and $9.79 for EPS, 
$4.16, $4.44 and $4.65 for Dividends, $19898M, $25729M and $26777M for FCF, $9.16, $11.30 and $12.10 for CFPS, and $22540M, $23391M and $25049M for Net Income.
Decided not to do this stock in Feb as it was only in Oct I had done it before.
February 6, 2021.  Last estimates were for 
October 28, 2021.  Last estimates were for 2020, 2021 and 2022 of $81814M, $88324M and $92567M for Revenue, $8.01, $9.00 and $9.80 for Adj EPS, $6.08, $7.52 and $7.74 for EPS,
 $3.98, $4.25 and $4.47 for Dividends, $15832, $21821M and $24533M for FCF, $7.69, $9.88 and $11.60 for CFPS, $15967M, $18332M and $19741M for Net Income.
November 7, 2020.  Last estimates were for 2019, 2020 and 2021 of $82218M, $85294M and $89527M for Revenue, $8.37, $8.37 for Adj EPS for 2019 and 2020, 
$6.47, $7.41 and $8.85 for EPS, $9.00, $10.90 and $10.90 for CFPS and $16943M, $19579M and $21585M for Net Income
November 10, 2019.  Last estimates were for 2018, 2019 and 2020 of  $81366M, $82870M and $86759M for Revenue, $7.86, $8.37 and $8.37 for EPS, 
$8.53, $10.50 and $10.90 for CFPS and $18277M, $20787M and $13633 for Net Income.
November 11, 2018.  Last estimates were for 2017, 2018 and 2019 of $76361M, $80672M and $84058M for Revenue, $7.28, $7.86 and $8.57 for Adj EPS, 
$5.96, $7.25 and $8.00 for EPS, $7.03, $9.07 and $9.65 for CFPS, $16391M, $19573M and $21612M for Net Income.
November 18, 2017.  Last estimates were for 2016, 2017 and 2018 of 72080M, $75592M and $78247M for Revenue, $6.72, $7.15 and $7.66 for Adjusted EPS, 
$5.98, $6.52 andf $6.52 for EPS, $6.54 and $8.16 for CFPS for 2016 and 2017 and $16117M and $17427M for 2016 and 2017 for Net Income.
November 19, 2016.  Last estimtes were for 2015, 2016 and 2017 of $70173M, $72312M and $75389M for Revenue, $6.12, $6.69 for 2015 and 2016 of Adjusted EPS, 
$5.63, $5.989 and $6.52 for EPS, $6.54, $7.52 and $8.16 for CFPS, $15985M, $16117M and $17417M for Net Income.
November 22, 2015.  Last estimates were for 2014, 2015 and 2016 of $74796, $75748 and $78493 for Revenue, $5.80, $6.08 and $6.64 for EPS, 
$6.88, $7.64 and $8.28 for CFPS and $16608M, $17424M and $19021M for Net Income.
November 25, 2014.  Last estimates were for 70898M, 73921M and $77198M for revenue, $5.48, $5.84 and $6.24 for Adjusted Earnings, $3.96 for EPS for 2013, $5.55,  $6.89 and $7.10 for CFPS.
November 2, 2013.  Last estimates were for 2012 and 2013 and were $67,166M and $72,120M for revenue, Adjusted earnings of $5.06 and $5.47, EPS of $3.52 and $3.96.
Sep 11, 2012.  Last estimates were for 2011 and 2012 of EPS $4.84 and $5.12 USD
Feb 19, 2011.  I noticed that my number of shares were off and corrected them.  The further back I went the closer where the share No. I had.  I obvious do not know how to get No. of shares 
from JNJ annual statements.  The current share number times stock price is now close to market cap of a number of sites. Dec 2010 figures are from unaudited statements.
However, so far JNJ has only put out income statement.
2006. Stock is going no where, so I am selling.
AP 2005.  I sometimes wonder if I did the right thing to buy this stock.  Looking at reports Srandard and Poor rating it a buy as do Vickers.  I will hold for now.  Dividends are good.
JNJ traces its roots back 128 years, to 1886, when it was founded by three brothers: Robert Wood Johnson, James Wood Johnson and Edward Mead Johnson, in New Brunswick, New Jersey.
Johnson & Johnson began trading publicly in 1944. 
Increased it dividends for 54 years in 2016.
Sector
Health Care, Consumers
What should this stock accomplish?
Would I buy this company and Why.
If I were looking for a US stock to buy I would consider this stock.  
Why am I following this stock. 
As Canadians, we are told we should be buying US stocks for our portfolio.  It is often recommended that we have at least 25% of our portfolio in US stocks.  I have never followed this, 
although I have tried dipping into the US market, but I have never made any money there.  I bought some of this stock in June 2005 and realized a year later, in June of 2006 that it was going nowhere for 
me and sold.  I lost almost 17% of my investment.  When I bought in 2005, all the analysts were saying that it was a good buy at that time.
Dividends
It is in cycle 3.  Dividends are declared in the prior month.  Dividends are paid in March,  June, September and December.
For example, the dividend declared for shareholders of record of February 26, 2013 was paid on March 12, 2013.
How they make their money.
Johnson & Johnson's biggest strength is its diversified business model. It operates through pharmaceuticals, and medical devices divisions.  They sold off their consumer products divisions.   
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.
Copyright © 2008 Website of SPBrunner. All rights reserved.
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 2016 Nov 18 2017 Nov 11 2018 Nov 10 2019 Nov 7 2020 Oct 28 2021 Oct 30 2022 Oct 27 2023 Oct 26 2024
Duato, Joaquin 0.094 0.004% 0.115 0.004% 0.177 0.007% 0.197 0.007% 0.247 0.009% 0.305 0.013% 0.000 0.000% Now also Chair -100.00%
Chair & CEO - Shares - Amount $12.157 $16.827 $27.882 $33.665 $43.590 $47.862 $0.000
Options - percentage 0.000 0.000% 0.211 0.008% 0.016 0.001% 0.011 0.000% 0.008 0.000% 0.000 0.000% 0.000 0.000% #DIV/0!
Options - amount $0.000 $30.751 $2.507 $1.822 $1.393 $0.000 $0.000
Wolk, Joseph J. 0.011 0.000% 0.016 0.001% 0.021 0.001% 0.025 0.001% 0.038 0.001% 0.052 0.002% 0.071 0.003% 35.22%
CFO - Shares - Amount $1.465 $2.292 $3.327 $4.268 $6.677 $8.222 $11.392
Options - percentage 0.000 0.000% 3.249 0.123% 0.007 0.000% 0.007 0.000% 0.006 0.000% 0.000 0.000% 0.000 0.000% #DIV/0!
Options - amount $0.000 $473.932 $1.054 $1.186 $1.008 $0.000 $0.000
Caruso Dominic J 0.004% 0.144 0.005%
CFO - Shares - Amount $13.478 $20.179
Options - percentage 0.000% 0.000 0.000%
Options - amount $0.000 $0.000
Broadhurst, Vanessa 0.016 0.001% 0.019 0.001% 0.020 0.001% 3.29%
Officer - Shares - Amount $2.768 $3.010 $3.186
Options - percentage 0.002 0.000% 0.003 0.000% 0.000 0.000% -100.00%
Options - amount $0.367 $0.479 $0.000
Fasolo, Peter 0.180 0.007% 0.103 0.004% -100.00%
Officer - Shares - Amount $31.779 $16.089
Options - percentage 0.000 0.000% 0.000 0.000% #DIV/0!
Options - amount $0.000 $0.000
Beckerte, Mary C. 0.000% 0.000 0.000% 0.000 0.000% 0.000 0.000% 0.000 0.000% 0.000 0.000% 0.000 0.000% 0.000 0.000% 0.000 0.000% #DIV/0!
Director - Shares - Amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Options - percentage 0.000% 0.002 0.000% 0.005 0.000% 0.006 0.000% 0.008 0.000% 0.009 0.000% 0.001 0.000% 0.012 0.000% 0.014 0.001% 14.68%
Options - amount $0.188 $0.228 $0.606 $0.908 $1.199 $1.531 $0.183 $1.865 $2.191
Davis, D. Scott 0.000 0.000% 0.000 0.000% 0.000 0.000% 0.000 0.000% Ceased insider Oct 2024 #DIV/0!
Director - Shares - Amount $0.000 $0.000 $0.000 $0.000
Options - percentage 0.009 0.000% 0.011 0.000% 0.012 0.000% 0.014 0.001% -100.00%
Options - amount $1.474 $1.838 $2.155 $2.163
Adamczyk, Darius 0.000 0.000%
Director - Shares - Amount $0.000
Options - percentage 0.004 0.000%
Options - amount $0.596
Mulchay, Anne M. 0.000 0.000% 0.000 0.000% 0.000 0.000% #DIV/0!
Lead Director - Shares - Amount $0.000 $0.000 $0.000
Options - percentage 0.018 0.001% 0.019 0.001% 0.021 0.001% 10.14%
Options - amount $3.128 $3.055 $3.448
Gorsky, Alex  0.007% 0.261 0.010% 0.338 0.013% 0.391 0.015% 0.453 0.017% 0.478 0.018% 0.587 0.022%
Chairman - Shares - Amount $20.543 $36.534 $43.631 $57.040 $71.234 $81.752 $103.721
Options - percentage 0.007% 0.095 0.004% 0.073 0.003% 0.055 0.002% 0.034 0.001% 0.022 0.001% 0.017 0.001%
Options - amount $20.826 $13.207 $9.469 $8.012 $5.285 $3.797 $2.978
Increase in O/S Shares 0.89% 30.839 1.14% 25.508 0.95% 22.082 0.83% 20.053 0.76% 21.765 0.827% 20.946 0.797% 20.007 0.761% 15.521 0.645% Search for Stock Option
due to SO $2,507.703 $3,552.961 $3,563.978 $2,849.682 $2,925.131 $3,425.376 $3,583.232 $3,422.597 $2,432.762 Plans
Book Value $2,497.000 $3,311.000 $3,156.000 $3,060.000 $2,691.000 $3,148.000 $3,456.000 $3,440.000 $2,529.000 Repurchase of Common 
Insider Buying -$0.100 $0.000 $0.000 -$0.922 -$0.770 $0.000 $0.000 $0.000 $0.000 Stock
Insider Selling $35.518 $36.179 $29.856 $67.414 $17.994 $8.359 $32.997 $32.997 $1.442
Net Insider Selling $35.418 $36.179 $29.856 $66.492 $17.223 $8.359 $32.997 $32.997 $1.442
% of Market Cap 0.01% 0.01% 0.01% 0.02% 0.00% 0.00% 0.01% 0.01% 0.00%
Directors 10 11 12 13 14 14 12 12
Women 20% 2 20% 3 27% 4 33% 4 31% 5 36% 5 36% 6 50% 6 50%
Minorities 20% 2 20% 2 18% 2 17% 2 15% 3 21% 2 14% 2 17% 1 8%
Institutions/Holdings 20 31.88% 20 42.68% 20 43.36%
Total Shares Held 838.080 31.88% 1,027.822 42.700% 1,043.691 43.359%
Increase/Decrease 9.247 1.12% -6.443 -0.62% 25.922 2.55%
Starting No. of Shares 828.834 MS 1,034.264 MS 1,017.769 MS
Institutions/Holdings 65.19% 3,065 67.84% 3,318 67.84% 20 3,054 69.12% 3,741 70.05% 3,741 74.86% 3,741 74.86%
Total Shares Held 65.52% 1,822.459 67.938% 1,828.572 68.683% 995.990 37.411% 1,819.724 69.13% 1,831.436 69.66% 1,802.637 74.89% 0.000 0.000%
Increase/Decrease -2.66% -0.467 -0.03% -2.962 -0.16% -7.622 -0.76% 112.983 6.62% 1.793 0.10% 9.603 0.54% 9.603 -100.00%
Starting No. of Shares 1,822.926 reuters 1,831.533 reuters 1,003.612 Top 20 1,706.740 Nasdaq 1,829.643 Nasdaq 1,793.034 Nasdaq -9.603 Nasdaq
My Stock
% paid by div