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/ Q1 2018
Medtronic PLC NYSE: MDT http://www.medtronic.com Fiscal Yr: Apr 31
Year 4/30/06 4/30/07 4/30/08 4/30/09 4/30/10 4/30/11 4/30/12 4/30/13 4/30/14 4/30/15 4/29/16 4/30/17 4/30/18 4/30/19 4/29/20 Value Description #Y Item Total G Currency
Accounting Rules US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP
USD - CDN$ 1.1203 1.1068 1.0163 1.1892 1.0044 0.9442 0.9886 1.0073 1.0957 1.2119 1.2549 1.2549 1.2601 1.2601 1.2601
split
$29,934.0 <-12 mths 0.75%
Revenue* $11,292 $12,299 $13,515 $14,599 $15,817 $15,933 $16,184 $16,590 $17,005 $20,261 $28,833 $29,710 $29,262 $30,287 $31,804 141.56% <-Total Growth 10 Revenue US$
Increase 12.31% 8.92% 9.89% 8.02% 8.34% 0.73% 1.58% 2.51% 2.50% 19.15% 42.31% 3.04% -1.51% 3.50% 5.01% 9.22% <-IRR #YR-> 10 Revenue 141.56% US$
5 year Running Average $8,902 $10,080 $11,250 $12,352 $13,504 $14,433 $15,210 $15,825 $16,306 $17,195 $19,775 $22,480 $25,014 $27,671 $29,979 12.92% <-IRR #YR-> 5 Revenue 83.58% US$
Revenue per Share $9.78 $10.76 $12.01 $13.04 $14.41 $14.89 $15.60 $16.33 $17.02 $14.25 $20.61 $21.70 $21.37 $22.12 $23.23 8.35% <-IRR #YR-> 10 5 yr Running Average 123.02% US$
Increase 17.67% 10.06% 11.65% 8.57% 10.51% 3.29% 4.80% 4.65% 4.25% -16.27% 44.61% 5.30% -1.51% 3.50% 5.01% 8.13% <-IRR #YR-> 5 5 yr Running Average 47.80% US$
5 year Running Average $7.43 $8.53 $9.67 $10.78 $12.00 $13.02 $13.99 $14.86 $15.65 $15.62 $16.76 $17.98 $18.99 $20.01 $21.81 7.27% <-IRR #YR-> 10 Revenue per Share 101.69% US$
P/S (Price/Sales) Med 5.55 4.52 4.31 3.10 2.70 2.45 2.28 2.56 3.20 4.84 3.50 3.86 6.82% <-IRR #YR-> 5 Revenue per Share 39.08% US$
P/S (Price/Sales) Close 5.10 4.92 4.11 2.45 3.03 2.81 2.45 2.86 3.46 5.22 3.84 3.83 3.71 3.58 3.41 7.74% <-IRR #YR-> 10 5 yr Running Average 110.81% US$
*Net Sales in M US$ P/S Med 10 yr 3.15 5 yr 3.50 17.68% Diff M/C 5.15% <-IRR #YR-> 5 5 yr Running Average 28.52% US$
-$12,299 $0 $0 $0 $0 $0 $0 $0 $0 $0 $29,710
-$16,184 $0 $0 $0 $0 $29,710
-$10,080 $0 $0 $0 $0 $0 $0 $0 $0 $0 $22,480
-$15,210 $0 $0 $0 $0 $22,480
-$10.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21.70
-$15.60 $0.00 $0.00 $0.00 $0.00 $21.70
-$8.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.98
-$13.99 $0.00 $0.00 $0.00 $0.00 $17.98
$2.97 <-12 mths 2.77%
EPS Basic $2.11 $2.44 $1.97 $1.94 $2.80 $2.87 $3.43 $3.40 $3.06 $2.44 $2.51 $2.92 19.67% <-Total Growth 10 EPS Basic US$
EPS Diluted* $2.09 $2.41 $1.95 $1.93 $2.79 $2.86 $3.41 $3.37 $3.02 $2.41 $2.48 $2.89 $3.28 $3.86 $4.49 19.92% <-Total Growth 10 EPS Diluted US$
Increase 41.22% 15.31% -19.09% -1.03% 44.56% 2.51% 19.23% -1.17% -10.39% -20.20% 2.90% 16.53% 13.49% 17.68% 16.32% 1.83% <-IRR #YR-> 10 Earnings per Share 19.92% US$
Earnings Yield 4.2% 4.6% 3.9% 6.0% 6.4% 6.8% 8.9% 7.2% 5.1% 3.2% 3.1% 3.5% 4.1% 4.9% 5.7% -3.25% <-IRR #YR-> 5 Earnings per Share -15.25% US$
5 year Running Average $1.45 $1.78 $1.91 $1.97 $2.23 $2.39 $2.59 $2.87 $3.09 $3.01 $2.94 $2.83 $2.82 $2.98 $3.40 4.78% <-IRR #YR-> 10 5 yr Running Average 59.57% US$
10 year Running Average $1.04 $1.23 $1.38 $1.53 $1.72 $1.92 $2.18 $2.39 $2.53 $2.62 $2.66 $2.71 $2.84 $3.04 $3.21 1.83% <-IRR #YR-> 5 5 yr Running Average 9.51% US$
* Diluted ESP per share P/S 10 yr 0.06 5 yr 0.03
-$2.09 -$2.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.89
-$3.41 $0.00 $0.00 $0.00 $0.00 $2.89
-$1.45 -$1.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.83
-$2.59 $0.00 $0.00 $0.00 $0.00 $2.83
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$
Split ' 99 US$
Dividend* $0.39 $0.44 $0.50 $0.75 $0.82 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $1.84 $1.84 290.91% <-Total Growth 10 Dividends US$
Increase 14.71% 12.82% 13.64% 50.00% 9.33% 9.76% 7.78% 7.22% 7.69% 8.93% 24.59% 13.16% 6.98% 0.00% 0.00% Count 28 Years of data US$
Dividends 5 Yr Running $0.30 $0.34 $0.39 $0.48 $0.58 $0.68 $0.79 $0.90 $0.97 $1.05 $1.17 $1.32 $1.48 $1.63 $1.75 287.13% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 0.72% 0.91% 0.96% 1.85% 2.11% 2.46% 2.73% 2.49% 2.06% 1.77% 2.11% 2.05% 2.22% 2.08% <-Median-> 10 Yield H/L Price US$
Yield on High Price 0.66% 0.81% 0.86% 1.33% 1.78% 2.15% 2.39% 2.18% 1.80% 1.54% 1.91% 1.93% 2.06% 1.85% <-Median-> 10 Yield on High Price US$
Yield on Low Price 0.80% 1.03% 1.09% 3.08% 2.58% 2.88% 3.19% 2.90% 2.40% 2.08% 2.36% 2.18% 2.39% 2.49% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 0.78% 0.83% 1.01% 2.34% 1.88% 2.15% 2.54% 2.23% 1.90% 1.64% 1.92% 2.07% 2.32% 2.32% 2.32% 2.00% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 18.66% 18.26% 25.64% 38.86% 29.39% 31.47% 28.45% 30.86% 37.09% 50.62% 61.29% 59.52% 56.10% 47.67% 40.98% 34.28% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 20.63% 19.26% 20.57% 24.54% 25.96% 28.56% 30.45% 31.20% 31.39% 34.84% 39.96% 46.72% 52.70% 54.56% 51.53% 30.82% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 20.41% 16.88% 16.12% 21.65% 21.78% 25.75% 22.51% 21.64% 22.56% 35.38% 40.75% 34.23% 38.49% 31.08% 24.44% 22.53% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 15.62% 15.68% 15.93% 18.04% 19.53% 20.75% 21.72% 22.58% 22.73% 24.97% 27.61% 30.13% 33.81% 35.54% 32.46% 22.15% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 12.18% 14.68% 16.09% 23.26% 23.14% 20.26% 22.60% 23.06% 23.60% 51.96% 33.72% 34.93% 38.49% 31.08% 24.44% 23.20% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 13.44% 13.57% 14.20% 16.27% 18.04% 19.69% 21.17% 22.39% 22.52% 25.81% 28.77% 31.47% 34.83% 36.21% 31.67% 21.78% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 5 Yr Med 5 Yr Cl 2.06% 1.92% 5 Yr Med Payout 50.62% 34.23% 33.72% 14.61% <-IRR #YR-> 10 Dividends 290.91% US$
* Dividends per share 5 Yr Med and Cur. 12.94% 20.90% Last Div Inc ---> $0.380 $0.430 13.2% 12.14% <-IRR #YR-> 5 Dividends 77.32% US$
17.42% <-IRR #YR-> 28 Dividends
20.27% <-IRR #YR-> 20 Dividends to 2009 0.66% Med Div
-$0.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.72
-$0.97 $0.00 $0.00 $0.00 $0.00 $1.72
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.72
$0.00 $0.00 $0.00 $0.75
Historical Dividends Historical High Div 2.95% Low Div 0.32% Ave Div 1.64% Med Div 0.73% Close Div 0.80% Historical Dividends US$
High/Ave/Median Values Curr diff Exp. -21.30% 625.55% Cheap 42.00% Cheap 218.05% Cheap 189.83% High/Ave/Median US$
Future Dividend Yield Div Yd 3.41% earning in 5 Years at IRR of 8.0% Div Inc. 46.93% Future Dividend Yield US$
Future Dividend Yield Div Yd 5.01% earning in 10 Years at IRR of 8.0% Div Inc. 115.89% Future Dividend Yield US$
Future Dividend Yield Div Yd 7.37% earning in 15 Years at IRR of 8.0% Div Inc. 217.22% Future Dividend Yield US$
Yield if held 5 years 0.76% 0.98% 1.21% 1.55% 1.61% 1.66% 2.00% 2.01% 2.77% 3.14% 4.16% 4.84% 4.40% 3.38% 2.67% 2.00% <-Median-> 10 Paid Median Price US$
Yield if held 10 years 3.24% 2.98% 2.29% 2.21% 1.83% 1.75% 2.15% 2.52% 2.32% 2.40% 2.80% 3.54% 3.55% 4.55% 4.73% 2.30% <-Median-> 10 Paid Median Price US$
Yield if held 15 years 8.72% 9.98% 10.28% 16.70% 11.84% 7.47% 6.56% 4.76% 3.30% 2.72% 2.95% 3.81% 4.45% 3.81% 3.62% 5.66% <-Median-> 10 Paid Median Price US$
Yield if held 20 years 44.81% 20.13% 22.00% 21.38% 24.94% 17.62% 12.61% 11.63% 8.42% 5.43% 4.11% 20.76% <-Median-> 8 Paid Median Price US$
Yield if held 25 years 66.67% 34.00% 39.00% 37.82% 40.98% 26.57% 39.00% <-Median-> 3 Paid Median Price US$
Yield if held 30 years 100.55% #NUM! <-Median-> 0 Paid Median Price US$
Cost covered if held 5 years 2.92% 3.79% 4.74% 5.01% 5.71% 6.28% 8.11% 8.65% 11.99% 13.50% 16.07% 18.63% 17.75% 14.94% 12.69% 8.38% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 18.22% 17.18% 13.41% 10.47% 9.40% 9.54% 12.52% 15.58% 15.04% 16.03% 17.09% 21.74% 22.97% 32.12% 36.02% 14.23% <-Median-> 10 Paid Median Price US$
Cost covered if held 15 years 54.12% 64.15% 67.71% 89.12% 68.88% 46.51% 43.83% 33.92% 24.77% 21.12% 20.95% 27.20% 33.52% 31.88% 33.27% 38.87% <-Median-> 10 Paid Median Price US$
Cost covered if held 20 years 270.79% 130.40% 153.49% 159.79% 197.14% 144.69% 95.23% 88.60% 67.89% 48.78% 40.68% 149.09% <-Median-> 8 Paid Median Price US$
Cost covered if held 25 years 557.68% 261.72% 303.61% 312.31% 378.43% 271.19% 303.61% <-Median-> 3 Paid Median Price US$
Cost covered if held 30 years 1036.37% #NUM! <-Median-> 0 Paid Median Price US$
Special Dividends 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$
Dividends CDN$ $0.44 $0.49 $0.51 $0.89 $0.82 $0.85 $0.96 $1.05 $1.23 $1.48 $1.91 $2.16 $2.32 $2.32 $2.32 343.22% <-Total Growth 10 Dividends CDN$
Increase 2.25% 11.46% 4.34% 75.51% -7.65% 3.18% 12.85% 9.24% 17.15% 20.48% 29.01% 13.16% 7.42% 0.00% 0.00% 16.05% <-IRR #YR-> 10 Dividends CDN$
Dividend Yield 0.78% 0.83% 1.01% 2.34% 1.88% 2.15% 2.54% 2.23% 1.90% 1.64% 1.92% 2.07% 2.32% 2.32% 0.01% 17.62% <-IRR #YR-> 5 Dividends CDN$
Dividends per share in CDN$ funds Yield 5yr Med. 1.92% Curr diff 7.79%
-$0.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.16
-$0.96 $0.00 $0.00 $0.00 $0.00 $2.16
Future Dividend Yield Div Yd 3.41% earning in 5 Years at IRR of 8.0% Div Inc. 46.93% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 5.01% earning in 10 Years at IRR of 8.0% Div Inc. 115.89% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 7.37% earning in 15 Years at IRR of 8.0% Div Inc. 217.22% Future Dividend Yield CDN$
Close CDN$ $55.89 $58.58 $50.23 $38.05 $43.88 $39.52 $37.77 $47.02 $64.45 $90.23 $99.33 $104.27 $99.86 $99.86 $99.86 5.93% <-IRR #YR-> 10 Stock Price CDN$
5 yr Period ending 04/30/06 04/30/07 04/30/08 04/30/09 04/30/10 04/30/11 04/30/12 04/30/13 04/30/14 04/30/15 04/29/16 04/30/17 04/30/18 04/30/19 04/29/20 22.52% <-IRR #YR-> 5 Stock Price CDN$
5 year IRR Tot. Ret, -2.58% -2.70% -5.57% -10.13% -6.75% -5.21% -6.73% 0.56% 13.18% 17.37% 22.49% 25.19% 7.40% <-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 1.47% 2.66% % Tot Ret 20% 10.58% 25.19% <-IRR #YR-> 5 Price & Dividend CDN$
-$58.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $104.27 Dates 04/30/17 Price & Dividend CDN$
-$37.77 $0.00 $0.00 $0.00 $0.00 $104.27 04/30/17 Price & Dividend CDN$
-$58.58 $0.51 $0.89 $0.82 $0.85 $0.96 $1.05 $1.23 $1.48 $1.91 $106.43 Cut & paste 04/30/17 Price & Dividend CDN$
-$37.77 $1.05 $1.23 $1.48 $1.91 $106.43 dates, do 04/30/17 Price & Dividend CDN$
-$39.52 $0.96 $1.05 $1.23 $1.48 $101.23 04/29/16 Price & Dividend
-$43.88 $0.85 $0.96 $1.05 $1.23 $91.70 04/30/15 Price & Dividend CDN$
-$38.05 $0.82 $0.85 $0.96 $1.05 $65.68 04/30/14 Price & Dividend CDN$
-$50.23 $0.89 $0.82 $0.85 $0.96 $48.07 04/30/13 Price & Dividend CDN$
-$58.58 $0.51 $0.89 $0.82 $0.85 $38.72 04/30/12 Price & Dividend CDN$
-$55.89 $0.49 $0.51 $0.89 $0.82 $40.37 not copy 04/30/11 Price & Dividend CDN$
$0.44 $0.49 $0.51 $0.89 $44.70 04/30/10 Price & Dividend CDN$
$0.44 $0.49 $0.51 $38.94 04/30/09 Price & Dividend CDN$
$0.44 $0.49 $50.73 04/30/08 Price & Dividend CDN$
$0.44 $59.07 04/30/07 Price & Dividend CDN$
$56.33 04/30/06 Price & Dividend CDN$
04/30/05 Price & Dividend CDN$
04/30/04 Price & Dividend CDN$
04/30/03 Price & Dividend CDN$
04/30/02 Price & Dividend CDN$
04/30/01 Price & Dividend CDN$
04/30/00 Price & Dividend CDN$
04/30/99 Price & Dividend CDN$
04/30/98 Price & Dividend CDN$
04/30/97 Price & Dividend CDN$
04/30/96 Price & Dividend CDN$
01/00/00 Price & Dividend CDN$
Graham No. $19.54 $22.82 $21.25 $22.43 $28.93 $30.99 $35.58 $37.33 $36.37 $45.06 $45.57 $48.88 $52.26 $56.70 $61.15 114.18% <-Total Growth 10 Graham Price US$
Price/GP Ratio Med 2.78 2.13 2.44 1.80 1.34 1.18 1.00 1.12 1.50 1.53 1.58 1.72 1.59 1.51 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 3.05 2.38 2.72 2.52 1.59 1.35 1.14 1.28 1.71 1.76 1.75 1.82 1.71 1.73 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 2.51 1.88 2.15 1.09 1.10 1.01 0.85 0.96 1.28 1.30 1.42 1.61 1.47 1.19 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 2.55 2.32 2.33 1.43 1.51 1.35 1.07 1.25 1.62 1.65 1.74 1.70 1.52 1.40 1.30 1.56 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close 155.26% 131.94% 132.59% 42.64% 51.03% 35.09% 7.36% 25.05% 61.75% 65.23% 73.69% 70.00% 51.63% 39.78% 29.60% 56.39% <-Median-> 10 Graham Price US$
Month, Year 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 Month, Year
Price Close $57.57 $53.15 $50.27 $31.42 $43.98 $37.09 $38.25 $41.02 $57.39 $72.20 $76.92 $71.23 $79.25 $79.25 $79.25 34.02% <-Total Growth 10 Stock Price US$
Increase 15.90% -7.68% -5.42% -37.50% 39.97% -15.67% 3.13% 7.24% 39.91% 25.81% 6.54% -7.40% 11.26% 0.00% 0.00% 2.97% <-IRR #YR-> 10 Stock Price 34.02% US$
P/E 27.55 22.05 25.78 16.28 15.76 12.97 11.22 14.35 19.00 29.96 31.02 24.65 24.16 20.53 17.65 13.24% <-IRR #YR-> 5 Stock Price 86.22% US$
Trailing P/E 38.90 25.43 20.86 16.11 22.79 13.29 13.37 12.03 17.03 23.91 31.92 28.72 27.42 24.16 20.53 4.65% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 1.68% 2.65% % Tot Ret 36.16% 16.68% Price Inc 7.24% P/E: 17.64 24.65 15.89% <-IRR #YR-> 5 Price & Dividend US$
-$53.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $71.23
-$38.25 $0.00 $0.00 $0.00 $0.00 $71.23
-$53.15 $0.50 $0.75 $0.82 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $72.95
-$38.25 $1.04 $1.12 $1.22 $1.52 $72.95
Month, Year Apr-06 Apr-07 Apr-08 Apr-09 Apr-10 Apr-11 Apr-12 Apr-13 Apr-14 Apr-15 Apr-16 Apr-17 Apr-18 Apr-19 Apr-20 Month, Year
Price Close $49.89 $52.93 $49.42 $32.00 $43.69 $41.86 $38.20 $46.68 $58.82 $74.45 $79.15 $83.09 $79.25 $79.25 $79.25 56.98% <-Total Growth 10 Stock Price US$
Increase -5.33% 6.09% -6.63% -35.25% 36.53% -4.19% -8.74% 22.20% 26.01% 26.57% 6.31% 4.98% -4.62% 0.00% 0.00% 4.61% <-IRR #YR-> 10 Stock Price 56.98% US$
P/E 23.87 21.96 25.34 16.58 15.66 14.64 11.20 13.85 19.48 30.89 31.92 28.75 24.16 20.53 17.65 16.81% <-IRR #YR-> 5 Stock Price 117.51% US$
Trailing P/E 33.71 25.33 20.51 16.41 22.64 15.00 13.36 13.69 17.45 24.65 32.84 33.50 27.42 24.16 20.53 6.18% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 1.56% 2.50% % Tot Ret 25.31% 12.94% Price Inc 22.20% P/E: 18.03 28.75 19.31% <-IRR #YR-> 5 Price & Dividend US$
-$52.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $83.09
-$38.20 $0.00 $0.00 $0.00 $0.00 $83.09
-$52.93 $0.50 $0.75 $0.82 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $84.81
-$38.20 $1.04 $1.12 $1.22 $1.52 $84.81
Price Median H/L $54.30 $48.59 $51.82 $40.44 $38.90 $36.54 $35.53 $41.81 $54.48 $69.01 $72.15 $83.87 $83.07 72.63% <-Total Growth 10 Stock Price US$
Increase 6.82% -10.52% 6.65% -21.95% -3.82% -6.07% -2.75% 17.66% 30.32% 26.67% 4.55% 16.24% -0.96% 5.61% <-IRR #YR-> 10 Stock Price 72.63% US$
P/E 25.98 20.16 26.57 20.95 13.94 12.77 10.42 12.41 18.04 28.63 29.09 29.02 25.32 18.74% <-IRR #YR-> 5 Stock Price 136.05% US$
Trailing P/E 36.69 23.25 21.50 20.74 20.15 13.09 12.42 12.26 16.17 22.85 29.94 33.82 28.74 7.24% <-IRR #YR-> 10 Price & Dividend US$
P/E on Run. 5 yr Ave 37.34 27.36 27.19 20.51 17.41 15.30 13.73 14.56 17.63 22.90 24.56 29.59 29.50 21.35% <-IRR #YR-> 5 Price & Dividend US$
P/E on Run. 10 yr Ave 52.03 39.50 37.63 26.41 22.61 19.02 16.28 17.50 21.53 26.30 27.09 30.94 29.21 26.28 P/E Ratio Historical Median US$
Median 10, 5 Yrs D. per yr 1.63% 2.61% % Tot Ret 22.46% 12.21% Price Inc 17.66% P/E: 19.50 28.63
-$48.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $83.87
-$35.53 $0.00 $0.00 $0.00 $0.00 $83.87
-$48.59 $0.50 $0.75 $0.82 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $85.59
-$35.53 $1.04 $1.12 $1.22 $1.52 $85.59
High Months Jan 06 Jan 07 Oct 07 Aug 08 Jan 10 Apr 11 Feb 12 Apr 13 Apr 14 Feb 15 Apr 16 Jul 16 Jun 17
Price Hi $59.54 $54.30 $57.86 $56.50 $46.03 $41.86 $40.65 $47.72 $62.31 $79.25 $79.78 $88.92 $89.20 63.76% <-Total Growth 10 Stock Price US$
Increase 9.17% -8.80% 6.56% -2.35% -18.53% -9.06% -2.89% 17.39% 30.57% 27.19% 0.67% 11.46% 0.31% 5.06% <-IRR #YR-> 10 Stock Price 63.76% US$
P/E 28.49 22.53 29.67 29.27 16.50 14.64 11.92 14.16 20.63 32.88 32.17 30.77 27.20 16.95% <-IRR #YR-> 5 Stock Price 118.75% US$
Trailing P/E 40.23 25.98 24.01 28.97 23.85 15.00 14.21 13.99 18.49 26.24 33.10 35.85 30.87 31.28 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc 17.39% P/E: 24.95 30.77 49.57 P/E Ratio Historical High US$
-$54.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $88.92
-$40.65 $0.00 $0.00 $0.00 $0.00 $88.92
Low Months Apr 06 Aug 06 Nov 07 Mar 09 May 09 Aug 10 Aug 11 Jun 12 May 13 May 14 Sep 15 May 16 Oct 17
Price Low $49.05 $42.87 $45.77 $24.38 $31.76 $31.21 $30.41 $35.89 $46.65 $58.77 $64.52 $78.82 $76.93 83.86% <-Total Growth 10 Stock Price US$
Increase 4.10% -12.60% 6.76% -46.73% 30.27% -1.73% -2.56% 18.02% 29.98% 25.98% 9.78% 22.16% -2.40% 6.28% <-IRR #YR-> 10 Stock Price 83.86% US$
P/E 23.47 17.79 23.47 12.63 11.38 10.91 8.92 10.65 15.45 24.39 26.02 27.27 23.45 20.98% <-IRR #YR-> 5 Stock Price 159.19% US$
Trailing P/E 33.14 20.51 18.99 12.50 16.46 11.19 10.63 10.52 13.84 19.46 26.77 31.78 26.62 20.98 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc 22.16% P/E: 14.04 24.39 12.62 P/E Ratio Historical Low US$
-$42.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $78.82
Long Term Debt $33,752 $30,247 $25,921 $25,953 Debt US$
Change -10.38% -14.30% 0.12% -12.34% <-Median-> 2 Change US$
Debt/Market Cap Ratio 0.32 0.27 0.23 0.24 0.27 <-Median-> 3 % of Market C. US$
Goodwill & Intangibles $13,002 $12,879 $68,631 $68,399 $61,922 $62,148 Intangibles Goodwill US$
Change -0.95% 432.89% -0.34% -9.47% 0.36% -0.64% <-Median-> 4 Change US$
Intangible/Market Cap Ratio 0.27 0.22 0.65 0.62 0.54 0.57 0.54 <-Median-> 5 % of Market C. US$
Market Cap $57,623 $60,499 $55,598 $35,817 $47,943 $44,797 $39,621 $47,428 $58,761 $105,842 $110,732 $113,750 $108,493 $108,493 $108,493 88.02% <-Total Growth 10 Market Cap US$
Diluted # of Shares in Million 1,217.3 1,161.8 1,143.8 1,126.3 1,109.4 1,081.7 1,059.9 1,027.5 1,013.6 1,109.0 1,425.9 1,391.4 1,375.6 19.76% <-Total Growth 10 Diluted US$
Change -0.29% -4.56% -1.55% -1.53% -1.50% -2.50% -2.02% -3.06% -1.35% 9.41% 28.58% -2.42% -1.14% -1.54% <-Median-> 10 Change US$
Basic # of Shares in Millions 1,204.5 1,149.7 1,130.7 1,117.8 1,106.3 1,077.4 1,053.9 1,019.3 1,002.1 1,095.5 1,409.6 1,378.9 1,361.9 19.94% <-Total Growth 10 Average US$
Change -0.44% -4.55% -1.65% -1.14% -1.03% -2.61% -2.18% -3.28% -1.69% 9.32% 28.67% -2.18% -1.23% -1.67% <-Median-> 10 Change US$
Difference -4.1% -0.6% -0.5% 0.1% -0.8% -0.7% -1.6% -0.3% -0.3% 29.8% -0.8% -0.7% 0.5% -0.59% <-Median-> 10 Difference US$
$6,067 <-12 mths -11.82%
# of Share in Millions 1,155 1,143 1,125 1,119 1,097 1,070 1,037 1,016 999 1,422 1,399 1,369 1,369 1,369 1,369 1.82% <-IRR #YR-> 10 Shares 19.77% US$
Change -4.56% -1.04% -1.57% -0.51% -1.96% -2.48% -3.08% -2.04% -1.67% 42.31% -1.59% -2.15% 0.00% 0.00% 0.00% 5.71% <-IRR #YR-> 5 Shares 31.99% US$
CF fr Op $M $2,207 $2,979 $3,489 $3,878 $4,131 $3,741 $4,470 $4,883 $4,959 $4,902 $5,218 $6,880 $6,544 $8,104 $10,309 130.95% <-Total Growth 10 Cash Flow US$
Increase -21.71% 34.96% 17.12% 11.15% 6.52% -9.44% 19.49% 9.24% 1.56% -1.15% 6.45% 31.85% -4.89% 23.85% 27.20% SO Buy Backs Share Issue US$
5 year Running Average $2,308 $2,586 $2,868 $3,075 $3,337 $3,644 $3,942 $4,221 $4,437 $4,591 $4,886 $5,368 $5,701 $6,330 $7,411 107.60% <-Total Growth 10 CF 5 Yr Running US$
CFPS $1.91 $2.61 $3.10 $3.46 $3.76 $3.50 $4.31 $4.81 $4.96 $3.45 $3.73 $5.03 $4.78 $5.92 $7.53 92.82% <-Total Growth 10 Cash Flow per Share US$
Increase -17.96% 36.37% 18.99% 11.72% 8.65% -7.14% 23.28% 11.52% 3.29% -30.54% 8.17% 34.74% -4.89% 23.85% 27.20% 8.73% <-IRR #YR-> 10 Cash Flow 130.95% US$
5 year Running Average $1.92 $2.18 $2.46 $2.68 $2.97 $3.29 $3.63 $3.97 $4.27 $4.20 $4.25 $4.39 $4.39 $4.58 $5.40 9.01% <-IRR #YR-> 5 Cash Flow 53.91% US$
P/CF on Med Price 28.41 18.64 16.71 11.67 10.33 10.45 8.24 8.70 10.98 20.01 19.34 16.69 17.38 6.79% <-IRR #YR-> 10 Cash Flow per Share 92.82% US$
P/CF on Closing Price 26.10 20.31 15.94 9.24 11.61 11.97 8.86 9.71 11.85 21.59 21.22 16.53 16.58 13.39 10.52 3.12% <-IRR #YR-> 5 Cash Flow per Share 16.61% US$
46.42% Diff M/C 7.26% <-IRR #YR-> 10 CFPS 5 yr Running 101.47% US$
Excl.Working Capital CF $1,489.6 $448.0 $6.0 -$269.0 -$242.0 $1,012.0 -$18.0 -$301.0 -$218.0 -$1,564.0 $1,089.0 -$139.0 $0.0 $0.0 $0.0 3.91% <-IRR #YR-> 5 CFPS 5 yr Running 21.16% US$
CF fr Op $M WC $3,697 $3,427 $3,495 $3,609 $3,889 $4,753 $4,452 $4,582 $4,741 $3,338 $6,307 $6,741 $6,544 $8,104 $10,309 96.70% <-Total Growth 10 Cash Flow less WC US$
Increase 30.18% -7.30% 1.98% 3.26% 7.76% 22.22% -6.33% 2.92% 3.47% -29.59% 88.95% 6.88% -2.93% 23.85% 27.20% 7.00% <-IRR #YR-> 10 Cash Flow less WC 96.70% US$
5 year Running Average $2,671 $2,977 $3,213 $3,414 $3,623 $3,835 $4,040 $4,257 $4,483 $4,373 $4,684 $5,142 $5,534 $6,207 $7,601 8.65% <-IRR #YR-> 5 Cash Flow less WC 51.42% US$
CFPS Excl. WC $3.20 $3.00 $3.11 $3.22 $3.54 $4.44 $4.29 $4.51 $4.75 $2.35 $4.51 $4.92 $4.78 $5.92 $7.53 5.62% <-IRR #YR-> 10 CF less WC 5 Yr Run 72.74% US$
Increase 36.40% -6.33% 3.62% 3.79% 9.91% 25.32% -3.36% 5.07% 5.23% -50.52% 92.00% 9.22% -2.93% 23.85% 27.20% 4.94% <-IRR #YR-> 5 CF less WC 5 Yr Run 27.28% US$
5 year Running Average $2.23 $2.52 $2.76 $2.98 $3.21 $3.46 $3.72 $4.00 $4.31 $4.07 $4.08 $4.21 $4.26 $4.50 $5.53 5.09% <-IRR #YR-> 10 CFPS - Less WC 64.23% US$
P/CF on Med Price 16.96 16.20 16.68 12.54 10.97 8.23 8.28 9.27 11.48 29.39 16.00 17.03 17.38 2.78% <-IRR #YR-> 5 CFPS - Less WC 14.72% US$
P/CF on Closing Price 15.59 17.65 15.91 9.92 12.33 9.42 8.90 10.35 12.39 31.71 17.56 16.87 16.58 13.39 10.52 5.26% <-IRR #YR-> 10 CFPS 5 yr Running 66.96% US$
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 11.32 5 yr 16.69 P/CF Med 10 yr 12.01 5 yr 16.00 38.04% Diff M/C 2.48% <-IRR #YR-> 5 CFPS 5 yr Running 13.04% US$
-$2.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.03 Cash Flow per Share
-$4.31 $0.00 $0.00 $0.00 $0.00 $5.03 Cash Flow per Share
-$2.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.39 CFPS 5 yr Running
-$3.63 $0.00 $0.00 $0.00 $0.00 $4.39 CFPS 5 yr Running
-$3,427 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,741 Cash Flow less WC
-$4,452 $0 $0 $0 $0 $6,741 Cash Flow less WC
-$2,977 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,142 CF less WC 5 Yr Run
-$4,040 $0 $0 $0 $0 $5,142 CF less WC 5 Yr Run
-$3.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.92 CFPS - Less WC
-$4.29 $0.00 $0.00 $0.00 $0.00 $4.92 CFPS - Less WC
-$2.52 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.21 CFPS 5 yr Running
-$3.72 $0.00 $0.00 $0.00 $0.00 $4.21 CFPS 5 yr Running
OPM 19.55% 24.22% 25.82% 26.56% 26.12% 23.48% 27.62% 29.43% 29.16% 24.19% 18.10% 23.16% -4.39% <-Total Growth 10 OPM US$
Increase -30.29% 23.91% 6.58% 2.90% -1.68% -10.10% 17.63% 6.57% -0.92% -17.03% -25.20% 27.96% Should increase or be stable. US$
Diff from Ave -24.7% -6.7% -0.6% 2.3% 0.6% -9.6% 6.4% 13.4% 12.3% -6.8% -30.3% -10.8% 0.00 <-Median-> 10 OPM US$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 25.97% 5 Yrs 24.19% should be zero, it is a check on calculations US$
Current Assets $10,377 $7,918 $7,322 $7,404 $9,839 $9,117 $9,151 $17,793 $21,210 $30,844 $23,600 $24,873 $24,779 Liquidity ratio of 1.5 and up, best Assets US$
Current Liabilities $4,406 $2,563 $3,535 $2,969 $5,121 $4,714 $5,857 $3,891 $5,559 $9,173 $7,165 $14,220 $15,148 2.28 <-Median-> 10 Liabilities US$
Liquidity 2.36 3.09 2.07 2.49 1.92 1.93 1.56 4.57 3.82 3.36 3.29 1.75 1.64 3.36 <-Median-> 5 Ratio US$
Liq. with CF aft div 2.75 4.06 2.90 3.52 2.55 2.52 2.15 5.56 4.51 3.71 3.73 2.07 1.90 3.73 <-Median-> 5 Ratio US$
Liq. CF re Inv+Div 2.75 2.44 1.62 1.83 1.32 1.82 1.48 3.09 2.74 1.30 3.73 1.86 1.90 2.74 <-Median-> 5 Ratio US$
Assets $19,665 $19,512 $22,198 $23,605 $28,090 $30,424 $33,083 $34,841 $37,943 $106,685 $99,782 $99,816 $100,167 Debt Ratio of 1.5 and up, best Assets US$
Liabilities $10,282 $8,535 $10,622 $10,632 $13,461 $14,456 $15,970 $16,170 $18,500 $53,455 $47,719 $49,400 $49,380 2.09 <-Median-> 10 Liabilities US$
Debt Ratio 1.91 2.29 2.09 2.22 2.09 2.10 2.07 2.15 2.05 2.00 2.09 2.02 2.03 2.05 <-Median-> 5 Ratio US$
Book Value $50,416 $50,787
NCI $122 $115
Net Book Value $9,383 $10,977 $11,576 $12,973 $14,629 $15,968 $17,113 $18,671 $19,443 $53,230 $52,063 $50,294 $50,672 $50,672 $50,672 358.18% <-Total Growth 10 Book Value US$
Book Value per Share $8.12 $9.60 $10.29 $11.59 $13.33 $14.92 $16.50 $18.38 $19.46 $37.44 $37.21 $36.74 $37.01 $37.01 $37.01 282.54% <-Total Growth 10 Book Value per Share US$
Change -5.92% 18.22% 7.14% 12.64% 15.02% 11.93% 10.58% 11.38% 5.91% 92.38% -0.61% -1.28% 0.75% 0.00% 0.00% -9.50% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 6.68 5.06 5.04 3.49 2.92 2.45 2.15 2.27 2.80 1.84 1.94 2.28 2.24 5.06 P/B Ratio Historical Median US$
P/B Ratio (Close) 6.14 5.51 4.80 2.76 3.28 2.81 2.32 2.54 3.02 1.99 2.13 2.26 2.14 2.14 2.14 14.36% <-IRR #YR-> 10 Book Value per Share 282.54% US$
Change 0.62% -10.26% -12.86% -42.52% 18.70% -14.40% -17.47% 9.71% 18.98% -34.21% 6.97% 6.34% -5.33% 0.00% 0.00% 17.36% <-IRR #YR-> 5 Book Value per Share 122.66% US$
Leverage (A/BK) 2.10 1.78 1.92 1.82 1.92 1.91 1.93 1.87 1.95 2.00 1.92 1.98 1.98 1.92 <-Median-> 10 A/BV US$
Debt/Equity Ratio 1.10 0.78 0.92 0.82 0.92 0.91 0.93 0.87 0.95 1.00 0.92 0.98 0.97 0.92 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.37 5 yr Med 2.27 -9.50% Diff M/C 1.78 Historical Leverage (A/BK) US$
-$9.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36.74
-$16.50 $0.00 $0.00 $0.00 $0.00 $36.74
Comprehensive Income $3,283
NCI $3
Shareholders $3,368 $3,179 $3,448 $2,960 $2,088 $2,854 $3,280 3.18% <-Total Growth 6 Comprehensive Income US$
Increase -5.61% 8.46% -14.15% -29.46% 36.69% 14.93% 8.46% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $3,009 $2,906 $2,926 -0.44% <-IRR #YR-> 6 Comprehensive Income #DIV/0! US$
ROE 21.1% 18.6% 18.5% 15.2% 3.9% 5.5% 6.5% 0.63% <-IRR #YR-> 5 Comprehensive Income 3.18% US$
5Yr Median 18.5% 18.5% 15.2% 6.5% -1.38% <-IRR #YR-> 2 5 Yr Running Average #DIV/0! US$
% Difference from NI 8.8% -12.1% -0.5% -3.4% -21.9% -19.3% -18.5% -1.38% <-IRR #YR-> 2 5 Yr Running Average #DIV/0! US$
Median Values Diff 5, 10 yr -12.1% -18.5% 6.5% <-Median-> 5 Return on Equity US$
-$3,368 $0 $0 $0 $0 $0 $3,280
-$3,179 $0 $0 $0 $0 $3,280
-$3,009 $0 $2,926
-$3,009 $0 $2,926
Current Liability Coverage Ratio 0.84 1.34 0.99 1.22 0.76 1.01 0.76 1.18 0.85 0.36 0.88 0.47 CFO / Current Liabilities US$
5 year Median 0.84 0.84 0.84 0.99 0.99 1.01 0.99 1.01 0.85 0.85 0.85 0.85 0.85 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio 18.80% 17.56% 15.74% 15.29% 13.84% 15.62% 13.46% 13.15% 12.50% 3.13% 6.32% 6.75% CFO / Total Assets US$
5 year Median 18.45% 18.45% 17.56% 17.09% 15.74% 15.62% 15.29% 13.84% 13.46% 13.15% 12.50% 6.75% 6.8% <-Median-> 5 Return on Assets US$
Return on Assets ROA 13.0% 14.4% 10.1% 9.2% 11.0% 10.2% 10.9% 10.0% 8.1% 2.5% 3.5% 4.0% Net Income/Assets Return on Assets US$
5Yr Median 13.0% 13.0% 13.0% 10.9% 11.0% 10.2% 10.2% 10.2% 10.2% 10.0% 8.1% 4.0% 4.0% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE 27.1% 25.5% 19.3% 16.7% 21.2% 19.4% 21.1% 18.6% 15.8% 5.0% 6.8% 8.0% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 20.2% 21.6% 21.6% 19.3% 21.2% 19.4% 19.4% 19.4% 19.4% 18.6% 15.8% 8.0% 8.0% <-Median-> 5 Return on Equity US$
$4,111 <-12 mths 2.16%
Net Income $4,028
NCI $4
Shareholders $2,547 $2,802 $2,231 $2,169 $3,099 $3,096 $3,617 $3,467 $3,065 $2,675 $3,538 $4,024 $4,607 $5,365 $6,120 43.61% <-Total Growth 10 Net Income US$
Increase 41.18% 10.02% -20.38% -2.78% 42.88% -0.10% 16.83% -4.15% -11.60% -12.72% 32.26% 13.74% 14.49% 16.45% 14.07% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $1,779 $2,142 $2,269 $2,311 $2,570 $2,679 $2,842 $3,090 $3,269 $3,184 $3,272 $3,354 $3,582 $4,042 $4,731 3.69% <-IRR #YR-> 10 Net Income 43.61% US$
Operating Cash Flow $2,207 $2,979 $3,489 $3,878 $4,131 $3,741 $4,470 $4,883 $4,959 $4,902 $5,218 $6,880 2.16% <-IRR #YR-> 5 Net Income 11.25% US$
Investment Cash Flow $2,867 -$1,701 -$2,790 -$2,740 -$4,759 -$1,815 -$2,651 -$3,101 -$3,594 -$17,058 $2,245 -$1,571 4.58% <-IRR #YR-> 10 5 Yr Running Average 56.55% US$
Total Accruals -$2,527 $1,524 $1,532 $1,031 $3,727 $1,170 $1,798 $1,685 $1,700 $14,831 -$3,925 -$1,285 3.36% <-IRR #YR-> 5 5 Yr Running Average 17.99% US$
Total Assets $19,665 $19,512 $22,198 $23,605 $28,090 $30,424 $33,083 $34,841 $37,943 $106,685 $99,782 $99,816 Balance Sheet Assets US$
Accruals Ratio -12.85% 7.81% 6.90% 4.37% 13.27% 3.85% 5.43% 4.84% 4.48% 13.90% -3.93% -1.29% 4.48% <-Median-> 5 Ratio US$
EPS/CF Ratio 1.09 0.92 0.63 0.56 0.74 0.82 0.79 0.70 0.61 0.70 0.66 0.58 0.68 <-Median-> 10 EPS/CF Ratio US$
-$2,802 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,024
-$3,617 $0 $0 $0 $0 $4,024
-$2,142 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,354
-$2,842 $0 $0 $0 $0 $3,354
Chge in Close -5.33% 6.09% -6.63% -35.25% 36.53% -4.19% -8.74% 22.20% 26.01% 26.57% 6.31% 4.98% -4.62% 0.00% 0.00% Count 23 Years of data
up/down/neutral up up down down down down down Count 13
Any Predictions? yes yes yes yes % right Count 6 46.15%
Financial Cash Flow $1,316 -$3,011 -$835 -$845 $764 -$2,006 -$1,882 -$2,101 -$918 $16 -$9,543 -$3,283 C F Statement Financial Cash Flow US$
Total Accruals -$3,844 $4,535 $2,367 $1,876 $2,963 $3,176 $3,680 $3,786 $2,618 $14,815 $5,618 $1,998 Accruals US$
Accruals Ratio -19.55% 23.24% 10.66% 7.95% 10.55% 10.44% 11.12% 10.87% 6.90% 13.89% 5.63% 2.00% 6.90% <-Median-> 5 Ratio US$
Cash $1,256 $1,060 $1,271 $1,400 $1,382 $1,248 $860 $1,403 $4,843 $2,876 $4,967 $4,691 Cash US$
Cash per Share $1.10 $0.94 $1.14 $1.28 $1.29 $1.20 $0.85 $1.40 $3.41 $2.06 $3.63 $3.43 $2.06 <-Median-> 5 Cash per Share US$
Percentage of Stock Price 2.08% 1.91% 3.55% 2.92% 3.09% 3.15% 1.81% 2.39% 4.58% 2.60% 4.37% 4.32% 2.60% <-Median-> 5 % of Stock Price US$
Notes:
October 22, 2017. Last estimates were for 2017, 2018 and 2019 of 30137M, 31751M, and $33551M, $3.37, $4.07 and $4.52 for EPS,
$5.67, $6.53 and $5.36 for CFPS, $5049M, $5923M and $6,316M for Net Income.
Found information on this stock at following site in 2017
http://phx.corporate-ir.net/phoenix.zhtml?c=76126&p=irol-reportsannual
October 22, 2016. Last estimates were for 2016, 2017 and 2018 of 28952M, $30071M and $31492M, $3.23, $3.90 and $4.38, $5.01, $5.01, $5.94 and $6.90 and $4.860, $5892 and $6.264 for Net Income.
October 22, 2015. Last estimates were for 2015, 2016 and 2017 of $17754M, $18494M and $19576M for Revenue, $3.98, $4.34 and $4.68 for EPS, $4.53, $5.20 and $5.65 CFPS
and $3794M, $4354M and $4623M for Net Income.
October 3, 2014. Last estimates were for 2014, 2015 and 2016 of $16315M, 16938M and $17488M for Revenue, $3.69, 3.82 and $4.10 for EPS, $4.43, $4.98 and $4.72 for CFPS.
September 27, 2013. Last estimates were for 2013 and 2014 of $16439M and $16943M for Revenue, $3.65 and $3.85 (and $4.12 2015) for EPS.
August 4, 2012. Last estimates were for 2011 and 2012 at $3.40 and $3.63 US$ for EPS.
Feb 18, 2011. When I last looked at this stock I got 2010 and 2011 estimates of $3.18 and $3.42 for earnings.
Jun 5, 2009 AR 2008. I would not have made any money if I had invested in this stock, from 2005 to the present. I do not think American's would have either. Dividend is very low
and this stock is way above the Graham Price. Not a stock I want.
Company was foundin in Minneapolis in 1949.
Name was changed from Medtronic Inc to Medtronic PLC in January 2015.
Company announed in June 2014 it was moving its head office to Ireland.
Sector:
Health Care, Consumer
What should this stock accomplish?
Would I buy this company and Why.
This is a dividend growth stock. If I was looking for a US stock, especially one in health care I would consider this stock.
Why am I following this stock.
In 2009 I was looking for a good US stock for my US$ account. I had heard good things about this stock and also it is in Health Care sector which is a weak sector in Canada.
This is one of the few US stocks that I follow.
Dividends
Dividends are paid quarterly using cycle July, October, January and April. Dividends are declared for shareholders of record in on month and paid in that month.
For example, the dividend declared for shareholders of record of April 5, 2013 was paid on April 26, 2013.
How they make their money.
Medtronic is the world's leading medical technology company, pioneering device-based therapies that restore health, extend life and alleviate pain. Primary products include those for bradycardia pacing,
tachyarrhythmia management, atrial fibrillation management, among others. Medtronic operates its business in one reportable segment, that of manufacturing and selling device-based medical therapies.
The company does business in more than 120 countries. The company's product lines include cardiac rhythm management, neurological and spinal, vascular and cardiac surgery.
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.
Also, for the Operational Profit Margin, a higher percentage is better. With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Aug 13 2012 Sep 13 2013 Oct 3 2014 Oct 22 2015 Oct 22 2016 Oct 21 2017
Ishrak Omar 0.648 0.05% 0.527 0.04% 0.566 0.04% 0.540 0.04%
Chairman & CEO - Shares - Amount $46.806 $40.523 $40.310 $42.818
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000
Parkhill, Karen L. 0.064 0.00% 0.072 0.01%
CFO - Shares - Amount $4.544 $5.669
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Ellis, Gary Lee 0.209 0.01% 0.187 0.01% 0.203 0.01% Was CFO
Officer - Shares - Amount $15.122 $14.373 $14.484
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
Coyle, Michael J 0.098 0.01% 0.093 0.01% 0.150 0.01% 0.161 0.01%
Officer - Shares - Amount $7.045 $7.155 $10.672 $12.745
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000
Anderson Richard H 0.053 0.00% 0.060 0.00% 0.072 0.01% 0.079 0.01%
Director - Shares - Amount $3.800 $4.642 $5.096 $6.278
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000
Chairman - See above CEO
Increase in O/S Shares 4.000 0.40% 10.000 1.00% 31.000 3.10% 17.000 1.20% 15.000 1.07% 13.000 0.95% Stock and EPSS
due to SO $153 $410 $1,779.090 $1,227.400 $1,153.800 $925.990
Book Value $96 $267 $1,304.000 $1,088.000 $491.000 $428.000
Insider Buying $0.000 $0.000 -$1.644
Insider Selling $8.732 $17.429 $25.303
Net Insider Selling $0.000 $0.000 $1.182 $8.732 $17.429 $23.659
% of Market Cap 0.00% 0.00% 0.001% 0.008% 0.02% 0.02%
Directors 10 13 13 12
Women 3 30% 4 31% 4 31% 3 25%
Minorities 2 20% 2 15% 2 15% 2 17% black women, South Asian man
# Institutions/Holdings 2,015 78.45% 1,446 0.00% 1,360 83.05% 1,382 85.10% 1,370 82.88%
Total Shares Held 804.110 79.14% 1,268.194 89.21% 1,174.974 83.99% 1,176.006 85.90% 1,122.705 82.01%
Increase/Decrease -8.523 -1.0% 6.978 0.6% -0.478 0.0% 9.977 0.9% -18.978 -1.7%
Starting No. of Shares 812.633 1,261.216 1,175.452 Nasdaq 1,166.029 Nasdaq 1,141.683 Nasdaq
Copyright 2008 Website of SPBrunner. All rights reserved.