This report should not be construed as providing investment advice. It is for educational purposes only. Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ Q3 2017
Johnson and Johnson NYSE: JNJ-N www.jnj.com/ Fiscal Yr: Dec 31
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G Currency
Reporting Date 28-Dec-14 3-Jan-16 1-Jan-17
Accounting Rules US GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
USD - CDN$ 1.1630 1.1652 0.9881 1.2240 1.0501 0.9970 1.0213 0.9968 1.0636 1.1601 1.3847 1.3427 1.2783 1.2783 1.2783 1.43% <-IRR #YR-> 10 USD - CDN$ 1.38% To Date
-3.47% 0.19% -15.20% 23.87% -14.21% -5.06% 2.44% -2.40% 6.70% 9.07% 19.36% -3.04% -4.80% 5.62% <-IRR #YR-> 5 USD - CDN$ 5.99% 2015
$74,361 <-12 mths 3.44%
Sales* $50,514 $53,324 $61,095 $63,747 $61,897 $61,587 $65,030 $67,224 $71,312 $74,331 $70,074 $71,890 $76,324 $80,672 $84,058 34.82% <-Total Growth 10 Revenue US$
Increase 6.69% 5.56% 14.57% 4.34% -2.90% -0.50% 5.59% 3.37% 6.08% 4.23% -5.73% 2.59% 6.17% 5.70% 4.20% 3.03% <-IRR #YR-> 10 Revenue 34.82% US$
5 year Running Average $41,805 $45,869 $50,829 $55,206 $58,115 $60,330 $62,671 $63,897 $65,410 $67,897 $69,594 $70,966 $72,786 $74,658 $76,604 2.03% <-IRR #YR-> 5 Revenue 10.55% US$
Revenue per Share $16.19 $18.39 $21.35 $22.98 $22.43 $22.49 $23.87 $24.19 $25.28 $26.71 $25.43 $26.56 $28.20 $29.81 $31.06 4.46% <-IRR #YR-> 10 5 yr Running Average 54.71% US$
Increase 1.49% 13.59% 16.08% 7.62% -2.36% 0.27% 6.13% 1.35% 4.50% 5.63% -4.77% 4.44% 6.17% 5.70% 4.20% 2.52% <-IRR #YR-> 5 5 yr Running Average 13.24% US$
5 year Running Average $13.85 $15.37 $17.20 $18.97 $20.27 $21.53 $22.62 $23.19 $23.66 $24.51 $25.10 $25.64 $26.44 $27.34 $28.21 3.74% <-IRR #YR-> 10 Revenue per Share 44.42% US$
P/S (Price/Sales) Med 4.00 3.44 3.01 2.76 2.49 2.74 2.63 2.78 3.28 3.66 3.88 4.16 4.51 0.00 0.00 2.16% <-IRR #YR-> 5 Revenue per Share 11.26% US$
P/S (Price/Sales) 3.71 3.59 3.12 2.61 2.87 2.75 2.75 2.90 3.62 3.92 4.04 4.34 4.89 4.63 4.44 5.25% <-IRR #YR-> 10 5 yr Running Average 66.77% US$
*Sales to Customers in M US $ P/S Med 10 yr 2.90 5 yr 3.66 68.94% Diff M/C 2.53% <-IRR #YR-> 5 5 yr Running Average 13.31% US$
-$53,324 $0 $0 $0 $0 $0 $0 $0 $0 $0 $71,890
-$65,030 $0 $0 $0 $0 $71,890
-$45,869 $0 $0 $0 $0 $0 $0 $0 $0 $0 $70,966
-$62,671 $0 $0 $0 $0 $70,966
-$18.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.56
-$23.87 $0.00 $0.00 $0.00 $0.00 $26.56
-$15.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.64
-$22.62 $0.00 $0.00 $0.00 $0.00 $25.64
Adjusted Earnings $3.39 $3.76 $4.15 $4.55 $4.63 $4.76 $5.00 $5.10 $5.52 $6.39 $6.20 $6.76 $7.28 $7.86 $8.37 79.79% <-Total Growth 10 Adjusted EPS US$
Increase 9.4% 10.9% 10.4% 9.6% 1.8% 2.8% 5.0% 2.0% 8.2% 15.8% -3.0% 9.0% 7.7% 8.0% 6.5% 6.04% <-IRR #YR-> 10 Earnings 79.79% US$
5 year Running Average $3.04 $3.42 $3.79 $4.10 $4.37 $4.62 $4.81 $5.00 $5.35 $5.64 $5.99 $6.43 $6.90 $7.29 6.22% <-IRR #YR-> 5 Earnings 35.20% US$
Earnings Yield 5.6% 5.7% 6.2% 7.6% 7.2% 7.7% 7.6% 7.3% 6.0% 6.1% 6.0% 5.9% 5.3% 5.7% 6.1% -2.08% <-IRR #YR-> 10 5 yr Running Average 3.09% US$
P/E on Close 17.73 17.57 16.07 13.16 13.91 13.01 13.12 13.75 16.59 16.36 16.57 17.04 18.96 17.56 16.49 5.35% <-IRR #YR-> 5 5 yr Running Average -23.04% US$
P/E on High 20.47 18.27 16.48 15.76 14.03 13.87 13.58 14.22 17.26 17.07 17.16 18.55 19.56 16.12 <-Median-> 5 P/E on High US$
P/E on Low 17.74 15.33 14.47 12.16 10.06 11.98 11.53 12.20 12.83 13.56 14.63 14.16 15.36 12.52 <-Median-> 5 P/E on Low US$
P/E on Med 19.11 16.80 15.48 13.96 12.05 12.93 12.56 13.21 15.04 15.31 15.90 16.36 17.46 14.50 <-Median-> 5 P/E on Med US$
Payout Ratio 37.6% 38.7% 39.0% 39.5% 41.7% 44.3% 45.0% 47.1% 46.9% 43.2% 47.6% 46.6% 45.6% 42.7% 40.1% 44.66% <-Median-> 10 DPR Adj. EPS US$
Earnings before provision for Taxes on income.> Payout 46.92% P/E: M/H/L 10 years 15.31 17.16 13.56 23.80% Diff M/C 23.80% Diff Med/Curr
$5.75 <-12 mths -3.04%
EPS Basic $3.46 $3.73 $3.63 $4.57 $4.40 $4.78 $3.49 $3.86 $4.92 $5.80 $5.56 $6.04 61.93% <-Total Growth 10 EPS Basic US$
EPS Diluted* $3.46 $3.73 $3.63 $4.57 $4.40 $4.78 $3.49 $3.86 $4.81 $5.70 $5.48 $5.93 $5.96 $7.25 $8.00 58.98% <-Total Growth 10 EPS Diluted US$
Increase 21.83% 7.80% -2.68% 25.90% -3.72% 8.64% -26.99% 10.60% 24.61% 18.50% -3.86% 8.21% 0.51% 21.64% 10.34% 4.75% <-IRR #YR-> 10 Earnings per Share 58.98% US$
Earnings Yield 5.8% 5.6% 5.4% 7.6% 6.8% 7.7% 5.3% 5.5% 5.3% 5.5% 5.3% 5.1% 4.3% 5.3% 5.8% 11.18% <-IRR #YR-> 5 Earnings per Share 69.91% US$
5 year Running Average $2.54 $2.92 $3.21 $3.65 $3.96 $4.22 $4.17 $4.22 $4.27 $4.53 $4.67 $5.16 $5.58 $6.06 $6.52 5.86% <-IRR #YR-> 10 5 yr Running Average 76.70% US$
10 year Running Average $1.91 $2.17 $2.42 $2.77 $3.06 $3.38 $3.55 $3.72 $3.96 $4.24 $4.45 $4.67 $4.90 $5.17 $5.53 4.32% <-IRR #YR-> 5 5 yr Running Average 23.53% US$
* Diluted ESP per share E/P 10 Yrs 5.45% 5Yrs 5.33%
-$3.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.93
-$3.49 $0.00 $0.00 $0.00 $0.00 $5.93
-$2.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.16
-$4.17 $0.00 $0.00 $0.00 $0.00 $5.16
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends US$
pre-split 1997 US$
pre-split 2001 US$
Dividend* $1.28 $1.46 $1.62 $1.80 $1.93 $2.11 $2.25 $2.40 $2.59 $2.76 $2.95 $3.15 $3.32 $3.36 $3.36 116.49% <-Total Growth 10 Dividends US$
Increase 16.44% 14.12% 11.34% 10.80% 7.52% 9.33% 6.64% 6.67% 7.92% 6.56% 6.88% 6.78% 5.40% 1.20% 0.00% Count 29 Years of data US$
Dividends 5 Yr Running $0.96 $1.11 $1.27 $1.45 $1.62 $1.78 $1.94 $2.10 $2.26 $2.42 $2.59 $2.77 $2.95 $3.11 $3.23 149.77% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 1.97% 2.30% 2.52% 2.83% 3.46% 3.43% 3.58% 3.56% 3.12% 2.82% 2.99% 2.85% 2.61% 3.06% <-Median-> 10 Yield H/L Price US$
Yield on High Price 1.84% 2.12% 2.37% 2.50% 2.97% 3.20% 3.31% 3.31% 2.72% 2.53% 2.77% 2.51% 2.33% 2.75% <-Median-> 10 Yield on High Price US$
Yield on Low Price 2.12% 2.52% 2.70% 3.24% 4.14% 3.70% 3.90% 3.86% 3.66% 3.19% 3.25% 3.29% 2.97% 3.47% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 2.12% 2.20% 2.43% 3.00% 3.00% 3.41% 3.43% 3.42% 2.83% 2.64% 2.87% 2.73% 2.41% 2.43% 2.43% 2.93% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 36.85% 39.01% 44.63% 39.28% 43.86% 44.14% 64.47% 62.18% 53.85% 48.42% 53.83% 53.12% 55.70% 46.34% 42.00% 50.77% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 37.72% 38.01% 39.66% 39.71% 40.80% 42.21% 46.50% 49.69% 52.86% 53.49% 55.48% 53.72% 52.98% 51.25% 49.48% 48.10% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 33.49% 29.61% 30.40% 33.26% 32.13% 35.26% 42.87% 43.31% 41.95% 41.59% 42.16% 44.22% 47.23% 37.05% 34.82% 41.77% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 28.56% 29.50% 29.81% 31.21% 31.73% 32.25% 34.71% 37.21% 38.96% 40.93% 42.32% 42.65% 43.49% 42.16% 40.48% 35.96% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 31.10% 31.80% 33.62% 30.31% 34.96% 33.48% 48.46% 38.40% 39.80% 39.32% 45.31% 40.50% 47.23% 37.05% 34.82% 38.86% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 30.19% 30.74% 31.79% 31.70% 32.38% 32.83% 35.67% 36.61% 38.60% 39.42% 41.87% 40.66% 42.39% 41.54% 40.31% 36.14% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values Yield 2.99% 2.83% Payout 53.83% 42.16% 39.80% 8.03% <-IRR #YR-> 10 Dividends 116.49% US$
* Dividends per share Curr diff -18.65% Last Div Inc ---> $0.80 $0.84 5.0% 6.96% <-IRR #YR-> 5 Dividends 40.00% US$
10.33% <-IRR #YR-> 15 Dividends 296.23% US$
11.12% <-IRR #YR-> 20 Dividends 641.18% US$
-$1.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.15
-$2.25 $0.00 $0.00 $0.00 $0.00 $3.15
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.15
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.15
Historical Dividends Historical High Div 3.86% Low Div 1.15% Ave Div 2.51% Med Div 2.22% Close Div 2.06% Historical Dividends US$
High/Ave/Median Values Curr diff Exp. -36.92% 111.72% Exp. -2.80% Cheap 9.67% Cheap 17.97% High/Ave/Median US$
Future Dividend Yield Div Yd 3.40% earning in 5 Years at IRR of 6.90% Div Inc. 39.60% Future Dividend Yield US$
Future Dividend Yield Div Yd 4.75% earning in 10 Years at IRR of 6.90% Div Inc. 94.88% Future Dividend Yield US$
Future Dividend Yield Div Yd 6.62% earning in 15 Years at IRR of 6.90% Div Inc. 172.06% Future Dividend Yield US$
Yield if held 5 years 2.96% 2.87% 3.03% 3.35% 3.40% 3.26% 3.56% 3.74% 4.08% 4.95% 4.79% 5.02% 4.93% 4.05% 3.43% 3.65% <-Median-> 10 Dividends US$
Yield if held 10 years 6.99% 6.09% 5.59% 4.69% 4.18% 4.90% 4.45% 4.49% 4.84% 4.86% 4.55% 4.99% 5.17% 5.29% 6.02% 4.76% <-Median-> 10 Dividends US$
Yield if held 15 years 16.50% 12.85% 12.74% 16.18% 16.69% 11.56% 9.41% 8.28% 6.77% 5.97% 6.86% 6.22% 6.21% 6.27% 5.92% 8.85% <-Median-> 10 Dividends US$
Yield if held 20 years 36.94% 30.61% 27.31% 19.88% 18.87% 23.35% 23.87% 16.16% 13.18% 11.45% 8.78% 7.27% 23.35% <-Median-> 9 Dividends US$
Yield if held 25 years 53.30% 43.77% 38.18% 27.83% 26.10% 30.29% 29.06% 40.98% <-Median-> 4 Dividends US$
Yield if held 30 years 69.14% 53.29% #NUM! <-Median-> 0 Dividends
Cost covered if held 5 years 11.13% 10.96% 11.92% 13.52% 14.23% 13.76% 15.36% 16.32% 17.76% 21.71% 21.05% 22.06% 21.93% 18.71% 16.50% 15.84% <-Median-> 10 Dividends US$
Cost covered if held 10 years 39.63% 34.80% 32.83% 28.28% 26.42% 31.85% 30.13% 31.53% 34.57% 35.57% 33.75% 37.28% 39.32% 42.23% 50.65% 32.34% <-Median-> 10 Dividends US$
Cost covered if held 15 years 110.04% 86.26% 87.76% 114.52% 124.13% 88.45% 75.40% 69.00% 57.74% 52.63% 61.95% 57.50% 59.16% 63.59% 64.01% 72.20% <-Median-> 10 Dividends US$
Cost covered if held 20 years 281.46% 245.31% 225.36% 171.99% 170.20% 216.20% 228.86% 159.41% 133.33% 119.96% 98.34% 87.56% 216.20% <-Median-> 9 Dividends US$
Cost covered if held 25 years 513.58% 437.38% 392.97% 294.34% 286.33% 356.28% 368.45% 415.18% <-Median-> 4 Dividends US$
Cost covered if held 30 years 833.38% 693.37% #NUM! <-Median-> 0 Dividends US$
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% <-Median-> 10 Special Dividends CDN$
Dividend Cdn$ * $1.48 $1.70 $1.60 $2.20 $2.03 $2.10 $2.30 $2.39 $2.75 $3.20 $4.08 $4.23 $4.24 $4.30 $4.30 149.47% <-Total Growth 10 Dividends CDN$
Increase 12.40% 14.33% -5.58% 37.26% -7.75% 3.80% 9.24% 4.11% 15.15% 16.23% 27.58% 3.54% 0.34% 1.20% 0.00% 6.67% <-Median-> 10 Dividends CDN$
Yield 2.12% 2.20% 2.43% 3.00% 3.00% 3.41% 3.43% 3.42% 2.83% 2.64% 2.87% 2.73% 2.41% 2.43% 2.43% 9.57% <-IRR #YR-> 10 Dividends 149.47% CDN$
Median Values 5 Yr M Yield 2.83% 12.98% <-IRR #YR-> 5 Dividends 84.05% CDN$
* Dividends per share to C. DY Curr diff -13.90% Last Div Inc ---> $1.07 $1.07 0.0%
-$1.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.23
-$2.30 $0.00 $0.00 $0.00 $0.00 $4.23
Close Cdn$ $69.90 $76.97 $65.91 $73.27 $67.64 $61.75 $66.98 $69.88 $97.42 $121.31 $142.24 $154.69 $176.41 $176.41 $176.41 7.23% <-IRR #YR-> 10 Stock Price 100.97% CDN$
5 yr Period ending 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 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 18.22% <-IRR #YR-> 5 Stock Price 130.96% CDN$
5 year IRR -0.97% -2.59% -2.79% 4.69% 0.06% 0.44% 0.06% 4.44% 8.66% 15.35% 21.51% 21.71% 4.57% <-Median-> 18 5 year IRR CDN$
9.67% <-IRR #YR-> 10 Price & Dividend CDN$
As a Canadian, would I have made money on this stock? Looking at 5 year periods to, including Dividends D. per yr 2.44% 3.48% % Tot Ret 25.27% 16.04% 21.71% <-IRR #YR-> 5 Price & Dividend CDN$
-$76.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $154.69 Stock Price CDN$
-$66.98 $0.00 $0.00 $0.00 $0.00 $154.69 Stock Price CDN$
-$76.97 $1.60 $2.20 $2.03 $2.10 $2.30 $2.39 $2.75 $3.20 $4.08 $158.92 Dates Price & Div CDN$
-$66.98 $2.39 $2.75 $3.20 $4.08 $158.92
-$61.75 $2.30 $2.39 $2.75 $3.20 $146.33 12/31/15 Price & Div CDN$
-$67.64 $2.10 $2.30 $2.39 $2.75 $124.51 12/31/14 Price & Div CDN$
-$73.27 $2.03 $2.10 $2.30 $2.39 $100.17 12/31/13 Price & Div CDN$
-$65.91 $2.20 $2.03 $2.10 $2.30 $72.27 12/31/12 Price & Div CDN$
-$76.97 $1.60 $2.20 $2.03 $2.10 $69.28 12/31/11 Price & Div CDN$
-$69.90 $1.70 $1.60 $2.20 $2.03 $63.86 12/31/10 Price & Div CDN$
$1.48 $1.70 $1.60 $2.20 $69.66 12/31/09 Price & Div CDN$
$1.48 $1.70 $1.60 $75.47 m 12/31/08 Price & Div CDN$
$1.48 $1.70 $67.51 12/31/07 Price & Div CDN$
$1.48 $78.67 12/31/06 Price & Div CDN$
$71.38 12/31/05 Price & Div CDN$
12/31/04 Price & Div CDN$
12/31/03 Price & Div CDN$
12/31/02 Price & Div CDN$
12/31/01 Price & Div CDN$
12/31/00 Price & Div CDN$
12/31/99 Price & Div CDN$
Graham No. $30.74 $33.74 $35.16 $39.69 $42.60 $47.14 $40.56 $45.01 $53.30 $56.69 $56.43 $58.92 $60.54 $66.77 $70.14 74.65% <-Total Growth 10 Graham Number US$
Price/GP Ratio Med 2.11 1.87 1.83 1.60 1.31 1.31 1.55 1.50 1.56 1.73 1.75 1.88 2.10 1.58 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 2.26 2.04 1.95 1.81 1.52 1.40 1.67 1.61 1.79 1.92 1.89 2.13 2.35 1.80 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 1.96 1.71 1.71 1.39 1.09 1.21 1.42 1.38 1.33 1.53 1.61 1.63 1.85 1.41 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 1.95 1.96 1.90 1.51 1.51 1.31 1.62 1.56 1.72 1.84 1.82 1.96 2.28 2.07 1.97 1.67 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close 95.48% 95.82% 89.70% 50.81% 51.18% 31.39% 61.67% 55.73% 71.82% 84.45% 82.04% 95.54% 127.94% 106.67% 96.74% 66.75% <-Median-> 10 Graham Price
Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19
pre-split 1989
pre-split 1992
pre-split 1996
pre-split 2001
Price Close $60.10 $66.06 $66.70 $59.86 $64.41 $61.94 $65.58 $70.10 $91.59 $104.57 $102.72 $115.21 $138.00 $138.00 $138.00 74.40% <-Total Growth 10 Stock Price US$
Increase -5.23% 9.92% 0.97% -10.25% 7.60% -3.83% 5.88% 6.89% 30.66% 14.17% -1.77% 12.16% 19.78% 0.00% 0.00% 5.72% <-IRR #YR-> 10 Stock Price 74.40% US$
P/E 17.37 17.71 18.37 13.10 14.64 12.96 18.79 18.16 19.04 18.35 18.74 19.43 23.15 19.03 17.25 11.93% <-IRR #YR-> 5 Stock Price 75.68% US$
Trailing P/E 21.16 19.09 17.88 16.49 14.09 14.08 13.72 20.09 23.73 21.74 18.02 21.02 23.27 23.15 19.03 8.43% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 2.71% 3.37% % Tot Ret 32.16% 22.04% Price Inc 12.16% P/E: 18.36 18.74 15.30% <-IRR #YR-> 5 Price & Dividend US$
-$66.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $115.21
-$65.58 $0.00 $0.00 $0.00 $0.00 $115.21
-$66.06 $1.62 $1.80 $1.93 $2.11 $2.25 $2.40 $2.59 $2.76 $2.95 $118.36
-$65.58 $2.40 $2.59 $2.76 $2.95 $118.36
Price Med H/L $64.78 $63.18 $64.24 $63.52 $55.78 $61.53 $62.79 $67.37 $83.05 $97.85 $98.56 $110.58 $127.12 75.02% <-Total Growth 10 Stock Price US$
Increase 14.14% -2.46% 1.67% -1.12% -12.18% 10.30% 2.06% 7.29% 23.28% 17.82% 0.73% 12.19% 14.96% 5.76% <-IRR #YR-> 10 Stock Price 75.02% US$
P/E 18.72 16.94 17.70 13.90 12.68 12.87 17.99 17.45 17.27 17.17 17.99 18.65 21.33 11.98% <-IRR #YR-> 5 Stock Price 76.10% US$
Trailing P/E 22.81 18.26 17.22 17.50 12.21 13.98 13.14 19.30 21.51 20.34 17.29 20.18 21.44 8.59% <-IRR #YR-> 10 Price & Dividend US$
P/E on Run. 5 yr Ave 25.50 21.65 20.00 17.42 14.09 14.57 15.04 15.96 19.46 21.61 21.11 21.45 22.80 15.50% <-IRR #YR-> 5 Price & Dividend US$
P/E on Run. 10 yr Ave 33.97 29.06 26.54 22.92 18.20 18.20 17.71 18.13 20.99 23.06 22.17 23.70 25.95 18.18 P/E Ratio Historical Median US$
Median 10, 5 Yrs D. per yr 2.83% 3.52% % Tot Ret 32.96% 22.70% Price Inc 12.19% P/E: 17.36 17.45
-$63.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $110.58
-$62.79 $0.00 $0.00 $0.00 $0.00 $110.58
-$63.18 $1.62 $1.80 $1.93 $2.11 $2.25 $2.40 $2.59 $2.76 $2.95 $113.73
-$62.79 $2.40 $2.59 $2.76 $2.95 $113.73
High Months Apr Nov Nov Aug Dec Apr Jul Oct Aug Nov Jan Aug Oct
pre-split 1989
pre-split 1992
pre-split 1996
pre-split 2001
Price High $69.40 $68.71 $68.40 $71.70 $64.96 $66.03 $67.92 $72.52 $95.25 $109.07 $106.39 $125.40 $142.40 82.51% <-Total Growth 10 Stock Price US$
Increase 8.02% -0.99% -0.45% 4.82% -9.40% 1.65% 2.86% 6.77% 31.34% 14.51% -2.46% 17.87% 13.56% 6.20% <-IRR #YR-> 10 Stock Price 82.51% US$
P/E 20.06 18.42 18.84 15.69 14.76 13.81 19.46 18.79 19.80 19.14 19.41 21.15 23.89 13.05% <-IRR #YR-> 5 Stock Price 84.63% US$
Trailing P/E 24.44 19.86 18.34 19.75 14.21 15.01 14.21 20.78 24.68 22.68 18.66 22.88 24.01 20.06 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc 14.51% P/E: 18.99 19.41 30.50 P/E Ratio Historical High US$
-$68.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $125.40
-$67.92 $0.00 $0.00 $0.00 $0.00 $125.40
Low Months Dec Mar Jul Dec Mar Jul Mar Jun Jan Feb Aug Jan Jan
Price Low $60.15 $57.65 $60.07 $55.33 $46.60 $57.02 $57.66 $62.21 $70.84 $86.62 $90.73 $95.75 $111.84 66.09% <-Total Growth 10 Stock Price US$
Increase 22.13% -4.16% 4.20% -7.89% -15.78% 22.36% 1.12% 7.89% 13.87% 22.28% 4.74% 5.53% 16.80% 5.20% <-IRR #YR-> 10 Stock Price 66.09% US$
P/E 17.38 15.46 16.55 12.11 10.59 11.93 16.52 16.12 14.73 15.20 16.56 16.15 18.77 10.68% <-IRR #YR-> 5 Stock Price 66.06% US$
Trailing P/E 21.18 16.66 16.10 15.24 10.20 12.96 12.06 17.83 18.35 18.01 15.92 17.47 18.86 16.15 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc 7.89% P/E: 15.66 16.12 12.97 P/E Ratio Historical Low US$
-$57.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $95.75
Long Term Debt $15,122 $14,961 $24,146 $26,675 Debt US$
Change -1.06% 61.39% 10.47% 30.16% <-Median-> 2 Change US$
Long Term Debt/ Market Cap Ratio 0.05 0.05 0.08 0.07 0.05 <-Median-> 4 % of Market C. US$
Goodwill & Intangibles $51,176 $50,745 $49,054 $47,393 $49,681 $85,877 Intangibles Goodwill US$
Change -0.84% -3.33% -3.39% 4.83% 72.86% -2.09% <-Median-> 4 Change US$
Intangibles/ Market Cap Ratio 0.26 0.20 0.17 0.17 0.16 0.23 0.17 <-Median-> 6 % of Market C. US$
Market Cap $187,502 $191,531 $190,879 $166,086 $177,714 $169,592 $178,640 $194,772 $258,341 $291,042 $283,010 $311,817 $373,499 $373,499 $373,499 62.80% <-Total Growth 10 Market Cap US$
Diluted # of Shares in Million 3,012.5 2,961.0 2,910.7 2,835.6 2,789.1 2,788.8 2,775.3 2,812.6 2,877.0 2,863.9 2,112.9 2,788.9 2,788.9 -5.81% <-Total Growth 10 Diluted
Change 0.30% -1.71% -1.70% -2.58% -1.64% -0.01% -0.48% 1.34% 2.29% -0.46% -26.22% 31.99% 0.00% -0.47% <-Median-> 10 Change
Basic # of Shares in Millions 3,012.5 2,961.0 2,910.7 2,835.6 2,789.1 2,751.4 2,736.0 2,753.3 2,809.2 2,815.2 2,771.8 2,737.3 2,737.3 -7.55% <-Total Growth 10 Basic
Change 0.30% -1.71% -1.70% -2.58% -1.64% -1.35% -0.56% 0.63% 2.03% 0.21% -1.54% -1.24% 0.00% -1.30% <-Median-> 10 Change
Difference 3.6% -2.1% -1.7% -2.2% -1.1% -0.5% -0.4% 0.9% 0.4% -1.1% -0.6% -1.1% -0.84% <-Median-> 10 Difference
$22,116 <-12 mths 14.72%
# of Share in Millions 3,119.8 2,899.4 2,861.8 2,774.6 2,759.1 2,738.0 2,724.0 2,778.5 2,820.6 2,783.2 2,755.2 2,706.5 2,706.5 2,706.5 2,706.5 -0.69% <-IRR #YR-> 10 Shares -6.65% Issued less Treasury
Change 5.13% -7.07% -1.30% -3.05% -0.56% -0.76% -0.51% 2.00% 1.52% -1.33% -1.01% -1.77% 0.00% 0.00% 0.00% -0.13% <-IRR #YR-> 5 Shares -0.64%
CF fr Op $M $11,877 $14,248 $15,249 $14,972 $16,571 $16,385 $14,298 $15,396 $17,414 $18,471 $19,279 $19,279 $19,027 $24,548 $26,118 35.31% <-Total Growth 10 Cash Flow US$
Increase 6.70% 19.96% 7.03% -1.82% 10.68% -1.12% -12.74% 7.68% 13.11% 6.07% 4.37% 0.00% -1.31% 29.02% 6.39% SO, S. Iss Buy Backs US$
5 year Running Average $10,129 $11,205 $12,620 $13,495 $14,583 $15,485 $15,495 $15,524 $16,013 $16,393 $16,972 $17,968 $18,694 $20,121 $21,650 60.35% <-Total Growth 10 CF 5 Yr Running US$
CFPS $3.81 $4.91 $5.33 $5.40 $6.01 $5.98 $5.25 $5.54 $6.17 $6.64 $7.00 $7.12 $7.03 $9.07 $9.65 44.95% <-Total Growth 10 Cash Flow per Share US$
Increase 1.50% 29.09% 8.43% 1.27% 11.30% -0.36% -12.29% 5.57% 11.42% 7.50% 5.44% 1.80% -1.31% 29.02% 6.39% 3.07% <-IRR #YR-> 10 Cash Flow 35.31% US$
5 year Running Average $3.35 $3.76 $4.27 $4.64 $5.09 $5.53 $5.59 $5.64 $5.79 $5.92 $6.12 $6.49 $6.79 $7.37 $7.97 6.16% <-IRR #YR-> 5 Cash Flow 34.84% US$
P/CF on Med Price 17.02 12.86 12.05 11.77 9.29 10.28 11.96 12.16 13.45 14.74 14.09 15.52 18.08 3.78% <-IRR #YR-> 10 Cash Flow per Share 44.95% US$
P/CF on Closing Price 15.79 13.44 12.52 11.09 10.72 10.35 12.49 12.65 14.84 15.76 14.68 16.17 19.63 15.21 14.30 6.30% <-IRR #YR-> 5 Cash Flow per Share 35.71% US$
5.62% <-IRR #YR-> 10 CFPS 5 yr Running 72.78% US$
Excl.Working Capital CF $912 -$982 -$1,458 $1,458 -$1,339 $870 -$1,651 $1,969 $941 $1,066 -$1,339 $1,773 $0 $0 $0 3.03% <-IRR #YR-> 5 CFPS 5 yr Running 16.12% US$
CF fr Op $M WC $12,789 $13,266 $13,791 $16,430 $15,232 $17,255 $12,647 $17,365 $18,355 $19,537 $17,940 $21,052 $19,027 $24,548 $26,118 58.69% <-Total Growth 10 Cash Flow less WC US$
Increase 25.93% 3.73% 3.96% 19.14% -7.29% 13.28% -26.71% 37.31% 5.70% 6.44% -8.17% 17.35% -9.62% 29.02% 6.39% 4.73% <-IRR #YR-> 10 Cash Flow less WC 58.69% US$
5 year Running Average $9,591 $10,770 $11,854 $13,286 $14,302 $15,195 $15,071 $15,786 $16,171 $17,032 $17,169 $18,850 $19,182 $20,421 $21,737 10.73% <-IRR #YR-> 5 Cash Flow less WC 66.46% US$
CFPS Excl. WC $4.10 $4.58 $4.82 $5.92 $5.52 $6.30 $4.64 $6.25 $6.51 $7.02 $6.51 $7.78 $7.03 $9.07 $9.65 5.76% <-IRR #YR-> 10 CF less WC 5 Yr Run 75.02% US$
Increase 19.79% 11.62% 5.32% 22.88% -6.77% 14.15% -26.33% 34.61% 4.12% 7.87% -7.24% 19.46% -9.62% 29.02% 6.39% 4.58% <-IRR #YR-> 5 CF less WC 5 Yr Run 25.07% US$
5 year Running Average $3.17 $3.61 $4.01 $4.57 $4.99 $5.43 $5.44 $5.73 $5.84 $6.14 $6.19 $6.81 $6.97 $7.48 $8.01 5.45% <-IRR #YR-> 10 CFPS - Less WC 70.00% US$
P/CF on Med Price 15.80 13.81 13.33 10.73 10.10 9.76 13.52 10.78 12.76 13.94 15.14 14.22 18.08 10.87% <-IRR #YR-> 5 CFPS - Less WC 67.53% US$
P/CF on Closing Price 14.66 14.44 13.84 10.11 11.67 9.83 14.13 11.22 14.07 14.90 15.78 14.81 19.63 15.21 14.30 6.57% <-IRR #YR-> 10 CFPS 5 yr Running 88.87% US$
*Operational Cash Flow per share P/CF Med 10 yr 13.05 5 yr 13.94 50.48% Diff M/C 4.60% <-IRR #YR-> 5 CFPS 5 yr Running 25.22% US$
-$4.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.12 Cash Flow per Share US$
-$5.25 $0.00 $0.00 $0.00 $0.00 $7.12 Cash Flow per Share US$
-$3.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.49 CFPS 5 yr Running US$
-$5.59 $0.00 $0.00 $0.00 $0.00 $6.49 CFPS 5 yr Running US$
-$13,266 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21,052 Cash Flow less WC US$
-$12,647 $0 $0 $0 $0 $21,052 Cash Flow less WC US$
-$10,770 $0 $0 $0 $0 $0 $0 $0 $0 $0 $18,850 CF less WC 5 Yr Run US$
-$15,071 $0 $0 $0 $0 $18,850 CF less WC 5 Yr Run US$
-$4.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.78 CFPS - Less WC US$
-$4.64 $0.00 $0.00 $0.00 $0.00 $7.78 CFPS - Less WC US$
-$3.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.81 CFPS 5 yr Running US$
-$5.44 $0.00 $0.00 $0.00 $0.00 $6.81 CFPS 5 yr Running US$
OPM 23.51% 26.72% 24.96% 23.49% 26.77% 26.60% 21.99% 22.90% 24.42% 24.85% 27.51% 26.82% 0.37% <-Total Growth 10 OPM US$
Increase 0.01% 13.64% -6.59% -5.90% 13.99% -0.62% -17.36% 4.17% 6.62% 1.76% 10.72% -2.53% Should increase or be stable. US$
Diff from Median -5.6% 7.3% 0.2% -5.7% 7.5% 6.8% -11.7% -8.0% -1.9% -0.2% 10.5% 7.7% 0.00 <-Median-> 10 OPM US$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 24.90% 5 Yrs 24.85% should be zero, it is a check on calculations US$
Current Assets $31,394 $22,975 $29,945 $34,377 $39,541 $47,307 $54,316 $46,116 $56,407 $59,311 $60,210 $65,032 $41,829 Liquidity ratio of 1.5 and up, best US$
Current Liabilities $12,635 $19,161 $19,837 $20,852 $21,731 $23,072 $22,811 $24,262 $25,675 $25,085 $27,747 $26,287 $31,806 2.11 <-Median-> 10 Ratio US$
Liquidity 2.48 1.20 1.51 1.65 1.82 2.05 2.38 1.90 2.20 2.36 2.17 2.47 1.32 2.20 <-Median-> 5 Ratio US$
Liq. with CF aft div 3.11 1.72 2.04 2.13 2.34 2.51 2.74 2.26 2.59 2.79 2.57 2.88 1.63 2.59 <-Median-> 5 Ratio US$
Liq. CF re Inv+Div 2.29 0.84 1.56 1.77 1.73 1.87 2.28 1.91 2.16 1.87 2.01 2.44 1.63 2.01 <-Median-> 5 Ratio US$
Assets $58,025 $70,556 $80,954 $84,912 $94,682 $102,908 $113,644 $121,347 $132,683 $131,119 $133,411 $141,208 $155,658 Debt Ratio of 1.5 and up, best US$
Liabilities $20,145 $31,238 $37,635 $42,401 $44,094 $46,329 $56,564 $56,521 $58,630 $61,367 $62,261 $70,790 $81,679 2.14 <-Median-> 10 Ratio US$
Debt Ratio 2.88 2.26 2.15 2.00 2.15 2.22 2.01 2.15 2.26 2.14 2.14 1.99 1.91 2.14 <-Median-> 5 Ratio US$
Book Value $37,880 $39,318 $43,319 $42,511 $50,588 $56,579 $57,080 $64,826 $74,053 $69,752 $71,150 $70,418 $73,979 $73,979 $73,979 79.10% <-Total Growth 10 Book Value US$
pre-split 2001
Book Value per Share $12.14 $13.56 $15.14 $15.32 $18.33 $20.66 $20.95 $23.33 $26.25 $25.06 $25.82 $26.02 $27.33 $27.33 $27.33 91.86% <-Total Growth 10 Book Value per Share US$
Change 13.27% 11.69% 11.62% 1.22% 19.67% 12.70% 1.40% 11.34% 12.53% -4.54% 3.04% 0.75% 5.06% 0.00% 0.00% 36.09% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 4.95 4.87 4.41 3.91 3.51 3.00 3.13 3.00 3.49 4.17 3.98 4.43 5.05 4.91 P/B Ratio Historical Median
P/B Ratio (Close) 4.95 4.87 4.41 3.91 3.51 3.00 3.13 3.00 3.49 4.17 3.98 4.43 5.05 5.05 5.05 6.73% <-IRR #YR-> 10 Book Value 91.86% US$
Change -16.33% -1.59% -9.55% -11.34% -10.08% -14.68% 4.41% -4.00% 16.11% 19.60% -4.67% 11.32% 14.02% 0.00% 0.00% 4.42% <-IRR #YR-> 5 Book Value 24.16% US$
Leverage (A/BV) 1.53 1.79 1.87 2.00 1.87 1.82 1.99 1.87 1.79 1.88 1.88 2.01 2.10 1.88 <-Median-> 5 A/BV US$
Debt/Equity Ratio 0.53 0.79 0.87 1.00 0.87 0.82 0.99 0.87 0.79 0.88 0.88 1.01 1.10 0.88 <-Median-> 5 Debt/Eq R. US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.71 5 yr Med 3.98 36.09% Diff M/C 1.86 Historical Leverage (A/BK)
-$13.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.02
-$20.95 $0.00 $0.00 $0.00 $0.00 $26.02
$15,795 <-12 mths 6.69%
Comprehensive Income $11,357 $11,996 $8,660 $14,163 $12,861 $7,571 $10,675 $16,781 $8,461 $12,966 $14,804 30.35% <-Total Growth 10 Comprehensive Income US$
Increase 5.63% -27.81% 63.55% -9.19% -41.13% 41.00% 57.20% -49.58% 53.24% 14.18% 41.00% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $11,807 $11,050 $10,786 $12,410 $11,270 $11,291 $12,737 2.69% <-IRR #YR-> 10 Comprehensive Income 30.35% US$
ROE 28.9% 27.7% 20.4% 28.0% 22.7% 13.3% 16.5% 22.7% 12.1% 18.2% 21.0% 14.35% <-IRR #YR-> 5 Comprehensive Income 95.54% US$
5Yr Median 27.7% 22.7% 20.4% 22.7% 16.5% 16.5% 18.2% 1.27% <-IRR #YR-> 6 5 Yr Running Average #DIV/0! US$
% Difference from NI 2.8% 13.4% -33.1% 15.5% -3.5% -21.7% 1.5% 21.3% -48.2% -15.9% -10.5% 2.88% <-IRR #YR-> 5 5 Yr Running Average 15.27% US$
Median Values Diff 5, 10 yr -1.0% -15.9% 18.2% <-Median-> 5 Return on Equity US$
-$11,357 $0 $0 $0 $0 $0 $0 $0 $0 $0 $14,804
-$7,571 $0 $0 $0 $0 $14,804
-$11,807 $0.0 $0.0 $0.0 $0.0 $0.0 $12,737
-$11,050 $0.0 $0.0 $0.0 $0.0 $12,737
Current Liability Coverage Ratio 1.01 0.69 0.70 0.79 0.70 0.75 0.55 0.72 0.71 0.78 0.65 0.80 0.60 CFO / Current Liabilities US$
5 year Median 0.73 0.73 0.70 0.73 0.70 0.70 0.70 0.72 0.71 0.72 0.71 0.72 0.71 0.72 <-Median-> 10 Current Liability Cov Ratio US$
Asset Efficiency Ratio 22.04% 18.80% 17.04% 19.35% 16.09% 16.77% 11.13% 14.31% 13.83% 14.90% 13.45% 14.91% 12.22% CFO / Total Assets US$
5 year Median 19.21% 19.21% 19.05% 19.05% 18.80% 17.04% 16.77% 16.09% 14.31% 14.31% 13.83% 14.31% 13.83% 14.9% <-Median-> 10 Return on Assets US$
Return on Assets ROA 17.9% 15.7% 13.1% 15.2% 13.0% 13.0% 8.5% 8.7% 10.4% 12.4% 11.6% 11.7% 10.5% Net Income/Assets Return on Assets US$
5Yr Median 16.0% 16.0% 15.7% 15.7% 15.2% 13.1% 13.0% 13.0% 10.4% 10.4% 10.4% 11.6% 11.6% 12.1% <-Median-> 10 Asset Efficiency Ratio US$
Return on Equity ROE 27.5% 28.1% 24.4% 30.5% 24.2% 23.6% 16.9% 16.2% 18.7% 23.4% 21.7% 23.5% 22.2% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 26.8% 27.5% 26.8% 27.5% 27.5% 24.4% 24.2% 23.6% 18.7% 18.7% 18.7% 21.7% 22.2% 23.4% <-Median-> 10 Return on Equity US$
$15,827 <-12 mths -4.31%
Net Income $10,411 $11,053 $10,576 $12,949 $12,266 $13,334 $9,672 $10,514 $13,831 $16,323 $15,409 $16,540 $16,391 $19,573 $21,612 49.64% <-Total Growth 10 Net Income US$
Increase 22.35% 6.17% -4.32% 22.44% -5.27% 8.71% -27.46% 8.71% 31.55% 18.02% -5.60% 7.34% -0.90% 19.41% 10.42% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $7,676 $8,753 $9,549 $10,700 $11,451 $12,036 $11,759 $11,747 $11,923 $12,735 $13,150 $14,523 $15,699 $16,847 $17,905 4.11% <-IRR #YR-> 10 Net Income 49.64% US$
Operating Cash Flow $11,877 $14,248 $15,249 $14,972 $16,571 $16,385 $14,298 $15,396 $17,414 $18,471 $19,279 $19,279 11.33% <-IRR #YR-> 5 Net Income 71.01% US$
Investment Cash Flow -$4,521 -$20,291 -$6,139 -$4,187 -$7,598 -$7,854 -$4,612 -$4,510 -$5,163 -$12,305 -$7,735 -$4,761 5.19% <-IRR #YR-> 10 5 Yr Running Average 65.92% US$
Total Accruals $3,055 $17,096 $1,466 $2,164 $3,293 $4,803 -$14 -$372 $1,580 $10,157 $3,865 $2,022 4.31% <-IRR #YR-> 5 5 Yr Running Average 23.50% US$
Total Assets $58,025 $70,556 $80,954 $84,912 $94,682 $102,908 $113,644 $121,347 $132,683 $131,119 $133,411 $141,208 Balance Sheet Assets US$
Accruals Ratio 5.26% 24.23% 1.81% 2.55% 3.48% 4.67% -0.01% -0.31% 1.19% 7.75% 2.90% 1.43% 1.43% <-Median-> 5 Ratio US$
EPS/CF Ratio 0.84 0.82 0.75 0.77 0.80 0.76 0.75 0.62 0.74 0.81 0.84 0.76 0.76 <-Median-> 10 EPS/CF Ratio US$
-$11,053 $0 $0 $0 $0 $0 $0 $0 $0 $0 $16,540
-$9,672 $0 $0 $0 $0 $16,540
-$8,753 $0 $0 $0 $0 $0 $0 $0 $0 $0 $14,523
-$11,759 $0 $0 $0 $0 $14,523
Financial Cash Flow -$297 -$6,109 -$5,698 -$7,464 -$4,092 -$4,980 -$4,452 -$20,562 -$6,091 -$12,260 -$10,846 -$8,551 C F Statement Financial Cash Flow US$
Total Accruals $3,352 $23,205 $7,164 $9,628 $7,385 $9,783 $4,438 $20,190 $7,671 $22,417 $14,711 $10,573 Accruals US$
Accruals Ratio 5.78% 32.89% 8.85% 11.34% 7.80% 9.51% 3.91% 16.64% 5.78% 17.10% 11.03% 7.49% 11.03% <-Median-> 5 Ratio US$
Cash $19,355 $24,542 $14,911 $20,927 $14,523 $13,732 $18,972 $15,721 Cash US$
Cash per Share $7.07 $9.01 $5.37 $7.42 $5.22 $4.98 $7.01 $5.81 $5.37 <-Median-> 5 Cash per Share US$
Percentage of Stock Price 11.41% 13.74% 7.66% 8.10% 4.99% 4.85% 6.08% 4.21% 6.08% <-Median-> 5 % of Stock Price US$
Notes
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 is engaged in the manufacture and sale of a broad range of products in the health care field in many countries of the world.
The company's worldwide business is divided into three segments: Consumer; Pharmaceutical; and Professional.
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 Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Sep 24 2012 Nov 2 2013 Nov 25 2014 Nov 22 2015 Nov 19 2016 Nov 18 2017
Gorsky, Alex 0.071 0.00% 0.079 0.00% 0.115 0.004% 0.178 0.007% 0.261 0.010% US$
Chair & CEO - Shares - Amount $6.490 $8.257 $11.790 $20.543 $36.084 US$
Options - percentage 0.000 0.00% 0.147 0.01% 0.149 0.01% 0.181 0.007% 0.095 0.003% US$
Options - amount $0.000 $15.364 $15.324 $20.826 $13.044 US$
Weldon, William C 0.410 0.01%
CEO - Shares - Amount $28.741
Caruso Dominic J 0.062 0.00% 0.089 0.00% 0.117 0.004% 0.144 0.005% US$
CFO - Shares - Amount $6.473 $9.142 $13.478 $19.931 US$
Options - percentage 0.013 0.00% 0.000 0.00% 0.000 0.000% 0.000 0.000% US$
Options - amount $1.319 $0.000 $0.000 $0.000 US$
Deyo, Russell C 0.140 0.01%
GC $9.814
Peterson Sandra E 0.010 0.00% 0.000 0.00% 0.036 0.001% 0.059 0.002% US$
Officer - Shares - Amount $0.996 $0.000 $4.107 $8.109 US$
Options - percentage 0.042 0.00% 0.026 0.00% 0.061 0.00% 0.133 0.00% US$
Options - amount $4.370 $2.626 $7.055 $18.298 US$
Goggins, Colleen A 0.110 0.00%
Officer - Shares - Amount $7.711
Options - percentage 9.530 0.34%
Options - amount $668.053
Beckerte, Mary C. 0.000 0.000% 0.000 0.000% US$
Director - Shares - Amount $0.000 $0.000 US$
Options - percentage 0.002 0.000% 0.002 0.000% US$
Options - amount $0.188 $0.225 US$
Coleman Mary Sue 0.014 0.00% 0.013 0.00% 0.012 0.000%
Director - Shares - Amount $1.422 $1.294 $1.377
Options - percentage 0.021 0.00% 0.023 0.00% 0.025 0.001%
Options - amount $2.182 $2.358 $2.913
Increase in O/S Shares 26.007 0.92% 55.170 1.96% 48.555 1.72% 32.302 1.16% 24.413 0.89% 30.839 1.14% US$
due to SO $2,382 $5,053 $4,447 $3,377.820 $2,507.703 $3,552.961 US$
Book Value $1,649 $3,250 $3,367 $2,933.000 $2,497.000 $3,311.000 US$
Insider Buying -0.356 -$24.94 -$0.496 -$0.100 $0.000 US$
Insider Selling 0.345 $24.16 $32.276 $35.518 $36.179 US$
Net Insider Selling -$0.777 $5.883 $31.780 $35.418 $36.179 US$
% of Market Cap 0.00% 0.002% 0.01% 0.01% 0.01% US$
Directors 12 13 13 10 10
Women 3 25% 3 23% 4 31% 2 20% 2 20%
Minorities 2 17% 2 15% 2 15% 2 20% 2 20% 2 black males
Institutions/Holdings 2,356 67.91% 0 0.00% 2,291 65.19% 3,065 67.84% US$
Total Shares Held 1,873.280 67.42% 0.000 0.00% 1,773.413 65.52% 1,822.459 67.336% US$
Increase/Decrease 61.127 3.37% 0.000 #DIV/0! -48.518 -2.66% -0.467 -0.03% US$
Starting No. of Shares 1,812.153 0.000 1,821.932 1,822.926 reuters US$