This report should not be construed as providing investment advice. It is for educational purposes only.  Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Q1 2024
Medtronic PLC NYSE: MDT https://www.medtronic.com/us-en/index.html Fiscal Yr: Apr 30
Year 4/30/11 4/30/12 4/30/13 5/1/14 5/1/15 4/30/16 4/30/17 4/30/18 5/1/19 4/30/20 4/30/21 4/30/22 4/30/23 4/30/24 4/30/25 4/30/26 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 US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP
USD - CDN$ 0.9442 0.9886 1.0073 1.0957 1.2119 1.2549 1.2549 1.2545 1.3423 1.3910 1.2732 1.2285 1.3578 1.3711 1.3711 1.3711
split
$31,558 <-12 mths 1.06%
Revenue* $15,933 $16,184 $16,590 $17,005 $20,261 $28,833 $29,710 $29,953 $30,557 $28,913 $30,117 $31,686 $31,227 $32,176 $33,640 $35,294 88.23% <-Total Growth 10 Revenue US$
Increase 0.73% 1.58% 2.51% 2.50% 19.15% 42.31% 3.04% 0.82% 2.02% -5.38% 4.16% 5.21% -1.45% 3.04% 4.55% 4.92% 6.53% <-IRR #YR-> 10 Revenue 88.23% US$
5 year Running Average $14,433 $15,210 $15,825 $16,306 $17,195 $19,775 $22,480 $25,152 $27,863 $29,593 $29,850 $30,245 $30,500 $30,824 $31,769 $32,805 0.84% <-IRR #YR-> 5 Revenue 4.25% US$
Revenue per Share $14.89 $15.60 $16.33 $17.02 $14.25 $20.61 $21.70 $22.12 $22.79 $21.56 $22.46 $23.55 $23.47 $24.18 $25.28 $26.52 6.78% <-IRR #YR-> 10 5 yr Running Average 92.74% US$
Increase 3.29% 4.80% 4.65% 4.25% -16.27% 44.61% 5.27% 1.95% 3.05% -5.41% 4.16% 4.87% -0.36% 3.04% 4.55% 4.92% 3.93% <-IRR #YR-> 5 5 yr Running Average 21.26% US$
5 year Running Average $13.02 $13.99 $14.86 $15.65 $15.62 $16.76 $17.98 $19.14 $20.29 $21.75 $22.12 $22.50 $22.77 $23.04 $23.79 $24.60 3.69% <-IRR #YR-> 10 Revenue per Share 43.71% US$
P/S (Price/Sales) Med 2.45 2.28 2.56 3.20 4.84 3.50 3.87 3.74 3.94 4.50 4.90 5.46 3.89 3.46 0.00 0.00 1.19% <-IRR #YR-> 5 Revenue per Share 6.09% US$
P/S (Price/Sales) Close 2.81 2.45 2.86 3.46 5.22 3.84 3.83 3.62 3.90 4.53 5.83 4.43 3.88 3.10 2.96 2.82 4.36% <-IRR #YR-> 10 5 yr Running Average 53.24% US$
*Net Sales in M US$  P/S Med 20 yr  3.91 15 yr  3.74 10 yr  3.91 5 yr  4.50 -20.80% Diff M/C 3.53% <-IRR #YR-> 5 5 yr Running Average 18.94% US$
-$16,590 $0 $0 $0 $0 $0 $0 $0 $0 $0 $31,227
-$29,953 $0 $0 $0 $0 $31,227
-$15,825 $0 $0 $0 $0 $0 $0 $0 $0 $0 $30,500
-$25,152 $0 $0 $0 $0 $30,500
-$16.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.47
-$22.12 $0.00 $0.00 $0.00 $0.00 $23.47
-$14.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.77
-$19.14 $0.00 $0.00 $0.00 $0.00 $22.77
$4.23 <-12 mths -20.04%
Non-GAAP Profit US$ $3,096 $3,617 $3,467 $4,098 $4,744 $6,228 $6,395 $6,530 $6,206 $6,206 $6,005 $7,505 $7,045
Basic $2.87 $3.43 $3.40 $4.09 $4.33 $4.42 $4.64 $4.81 $4.61 $4.63 $4.47 $5.59 $5.30 55.82% <-Total Growth 10 AEPS
AEPS* Dilued $2.86 $3.41 $3.37 $4.04 $4.28 $4.37 $4.60 $4.77 $4.59 $4.59 $4.44 $5.55 $5.29 $5.12 $5.45 $5.93 56.97% <-Total Growth 10 AEPS
Increase 2.51% 19.23% -1.17% 19.97% 5.81% 2.10% 5.32% 3.70% -3.77% 0.00% -3.27% 25.00% -4.68% -3.21% 6.45% 8.81% 10 0 10 Years of Data, EPS P or N 100.00%
5 year Running Average $2.39 $2.59 $2.87 $3.29 $3.59 $3.89 $4.13 $4.41 $4.52 $4.58 $4.60 $4.79 $4.89 $5.00 $5.17 $5.47 4.61% <-IRR #YR-> 10 AEPS 56.97%
AEPS Yield 6.83% 8.93% 7.22% 6.87% 5.75% 5.52% 5.54% 5.95% 5.17% 4.70% 3.39% 5.32% 5.82% 6.84% 7.28% 7.92% 2.09% <-IRR #YR-> 5 AEPS 10.90%
Payout Ratio 31.47% 28.45% 30.86% 27.70% 28.52% 34.80% 37.39% 38.57% 43.57% 47.06% 52.25% 45.41% 51.42% 53.91% 50.64% 46.54% 5.47% <-IRR #YR-> 10 5 yr Running Average 70.33%
5 year Running Average 28.72% 30.76% 31.81% 29.57% 29.40% 30.07% 31.85% 33.40% 36.57% 40.28% 43.77% 45.37% 47.94% 50.01% 50.72% 49.58% 2.09% <-IRR #YR-> 5 5 yr Running Average 10.89%
Price/AEPS Median 12.77 10.42 12.41 13.48 16.13 16.52 18.23 17.35 19.54 21.16 24.78 23.15 17.24 16.33 0.00 0.00 17.79 <-Median-> 10 Price/AEPS Median
Price/AEPS High 14.64 11.92 14.16 15.41 18.53 18.27 19.33 18.70 21.68 26.43 29.55 24.35 20.09 17.71 0.00 0.00 19.71 <-Median-> 10 Price/AEPS High
Price/AEPS Low 10.91 8.92 10.65 11.54 13.74 14.77 17.13 16.01 17.41 15.89 20.01 21.95 14.39 14.95 0.00 0.00 15.95 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 14.64 11.20 13.85 14.55 17.40 18.12 18.06 16.80 19.35 21.27 29.49 18.80 17.19 14.63 13.74 12.63 18.09 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 15.00 13.36 13.69 17.45 18.41 18.50 19.02 17.42 18.62 21.27 28.52 23.50 16.39 14.16 14.63 13.74 18.56 <-Median-> 10 Trailing P/AEPS Close
Median Values DPR 10 Yrs 41.07% 5 Yrs   47.06% P/CF 5 Yrs   in order 21.16 24.35 17.41 19.35 -30.86% Diff M/C DPR 75% to 95% best
* Non-GAAP Earnings per Share
-$3.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.29
-$4.77 $0.00 $0.00 $0.00 $0.00 $5.29
-$2.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.89
-$4.41 $0.00 $0.00 $0.00 $0.00 $4.89
$2.71 <-12 mths -3.90%
EPS Basic $2.87 $3.43 $3.40 $3.06 $2.44 $2.51 $2.92 $2.29 $3.44 $3.57 $2.68 $3.75 $2.83 -16.76% <-Total Growth 10 EPS Basic US$
Split ' 97
Split ' 99
EPS Diluted* $2.86 $3.41 $3.37 $3.02 $2.41 $2.48 $2.89 $2.27 $3.41 $3.54 $2.66 $3.73 $2.82 $3.40 $3.93 $4.24 -16.32% <-Total Growth 10 EPS Diluted US$
Increase 2.51% 19.23% -1.17% -10.39% -20.20% 2.90% 16.53% -21.45% 50.22% 3.81% -24.86% 40.23% -24.40% 20.57% 15.59% 7.89% 10 0 10 Years of Data, EPS P or N US$
Earnings Yield 6.8% 8.9% 7.2% 5.1% 3.2% 3.1% 3.5% 2.8% 3.8% 3.6% 2.0% 3.6% 3.1% 4.5% 5.2% 5.7% -1.77% <-IRR #YR-> 10 Earnings per Share -16.32% US$
5 year Running Average $2.39 $2.59 $2.87 $3.09 $3.01 $2.94 $2.83 $2.61 $2.69 $2.92 $2.95 $3.12 $3.23 $3.23 $3.31 $3.62 4.43% <-IRR #YR-> 5 Earnings per Share 24.23% US$
10 year Running Average $1.92 $2.18 $2.39 $2.53 $2.62 $2.66 $2.71 $2.74 $2.89 $2.97 $2.95 $2.98 $2.92 $2.96 $3.11 $3.29 1.19% <-IRR #YR-> 10 5 yr Running Average 12.53% US$
* Diluted ESP per share  P/S 10 yr  0.03 5 yr  0.04 4.34% <-IRR #YR-> 5 5 yr Running Average 23.64% US$
-$3.41 -$3.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.82
-$2.27 $0.00 $0.00 $0.00 $0.00 $2.82
-$2.59 -$2.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.23
-$2.61 $0.00 $0.00 $0.00 $0.00 $3.23
Dividend* $2.78 $2.84 $2.96 Estimates Dividend* US$
Increase 2.21% 2.16% 4.23% Estimates Increase US$
Payout Ratio EPS 81.76% 72.26% 69.81% Estimates Payout Ratio EPS US$
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 <-Total Growth 10 Special Dividends US$ US$
Split ' 99 US$
Dividend* $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $2.76 $2.76 $2.76 161.54% <-Total Growth 10 Dividends US$
Increase 9.76% 7.78% 7.22% 7.69% 8.93% 24.59% 13.16% 6.98% 8.70% 8.00% 7.41% 8.62% 7.94% 1.47% 0.00% 0.00% 33 0 33 Years of data, Count P, N 100.00% US$
Average Increases 5 Year Running 19.11% 18.10% 16.82% 8.36% 8.27% 11.24% 12.32% 12.27% 12.47% 12.28% 8.85% 7.94% 8.13% 6.69% 5.09% 3.61% 10.04% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $0.68 $0.79 $0.90 $0.97 $1.05 $1.17 $1.32 $1.48 $1.66 $1.85 $2.01 $2.17 $2.34 $2.50 $2.62 $2.70 161.61% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 2.46% 2.73% 2.49% 2.06% 1.77% 2.11% 2.05% 2.22% 2.23% 2.22% 2.11% 1.96% 2.98% 3.30% 2.11% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 2.15% 2.39% 2.18% 1.80% 1.54% 1.91% 1.93% 2.06% 2.01% 1.78% 1.77% 1.86% 2.56% 3.04% 1.88% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 2.88% 3.19% 2.90% 2.40% 2.08% 2.36% 2.18% 2.41% 2.50% 2.96% 2.61% 2.07% 3.57% 3.61% 2.41% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 2.15% 2.54% 2.23% 1.90% 1.64% 1.92% 2.07% 2.30% 2.25% 2.21% 1.77% 2.41% 2.99% 3.68% 3.68% 3.68% 2.14% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 31.47% 28.45% 30.86% 37.09% 50.62% 61.29% 59.52% 81.06% 58.65% 61.02% 87.22% 67.56% 96.45% 81.18% 70.23% 65.09% 61.15% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 28.56% 30.45% 31.20% 31.39% 34.84% 39.96% 46.72% 56.77% 61.66% 63.33% 67.98% 69.44% 72.52% 77.28% 79.08% 74.61% 59.22% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 25.75% 22.51% 21.64% 22.56% 35.38% 40.75% 34.24% 53.20% 38.27% 40.04% 49.86% 46.15% 59.94% 48.85% 44.59% 40.29% 40.40% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 20.75% 21.72% 22.58% 22.73% 24.97% 27.61% 30.13% 35.98% 39.74% 40.47% 42.26% 44.81% 46.38% 38.52% 40.37% 41.73% 37.86% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 20.26% 22.60% 23.06% 23.60% 51.96% 33.72% 34.94% 51.30% 33.16% 40.38% 44.82% 41.17% 51.66% 48.85% 44.59% 40.29% 40.78% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 19.69% 21.17% 22.39% 22.52% 25.81% 28.77% 31.47% 36.90% 38.79% 37.87% 40.06% 41.27% 41.94% 45.28% 46.05% 44.95% 37.38% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 10 Yr Med 10 Yr Cl 2.11% 2.14% 5 Yr Med 5 Yr Cl 2.22% 2.25% 5 Yr Med Payout 67.56% 46.15% 41.17% 8.13% <-IRR #YR-> 5 Dividends 47.83% US$
* Dividends per share  10 Yr Med and Cur. 74.84% 72.09% 5 Yr Med and Cur. 65.67% 63.63% Last Div Inc ---> $0.680 $0.690 1.47% 10.09% <-IRR #YR-> 10 Dividends 161.54% US$
Dividends Growth 15 11.95% <-IRR #YR-> 15 Dividends 444.00% US$
Dividends Growth 20 12.68% <-IRR #YR-> 20 Dividends 988.00% US$
Dividends Growth 25 13.69% <-IRR #YR-> 25 Dividends 2372.73% US$
Dividends Growth 30 15.62% <-IRR #YR-> 30 Dividends 7671.43% US$
Dividends Growth 35 15.64% <-IRR #YR-> 33 Dividends
Dividends Growth 5 -$1.84 $0.00 $0.00 $0.00 $0.00 $2.72 Dividends Growth 5
Dividends Growth 10 -$1.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.72 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.72 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.72 Dividends Growth 20
Dividends Growth 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.72 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 $2.72 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 $2.72 Dividends Growth 35
Historical Dividends Historical High Div 3.04% Low Div 0.35% 10 Yr High 3.51% 10 Yr Low 1.56% Med Div 0.96% Close Div 0.93% 2.11% 74.64% Historical Dividends US$
High/Ave/Median Values Curr diff Cheap 21.21%     952.83% Cheap 4.98% 136.21% Cheap 283.85% Cheap 294.64% Since 2009 High/Ave/Median  US$
Future Dividend Yield Div Yield 5.45% earning in 5 Years at IRR of 8.13% Div Inc. 47.83% Future Dividend Yield US$
Future Dividend Yield Div Yield 8.05% earning in 10 Years at IRR of 8.13% Div Inc. 118.53% Future Dividend Yield US$
Future Dividend Yield Div Yield 11.90% earning in 15 Years at IRR of 8.13% Div Inc. 223.04% Future Dividend Yield US$
Future Dividend Paid Div Paid $4.08 earning in 5 Years at IRR of 8.13% Div Inc. 47.83% Future Dividend Paid
Future Dividend Paid Div Paid $6.03 earning in 10 Years at IRR of 8.13% Div Inc. 118.53% Future Dividend Paid
Future Dividend Paid Div Paid $8.92 earning in 15 Years at IRR of 8.13% Div Inc. 223.04% Future Dividend Paid
Dividend Covering Cost Total Div $16.23 over 5 Years at IRR of 8.13% Div Cov. 21.67% Dividend Covering Cost
Dividend Covering Cost Total Div $36.15 over 10 Years at IRR of 8.13% Div Cov. 48.27% Dividend Covering Cost
Dividend Covering Cost Total Div $65.60 over 15 Years at IRR of 8.13% Div Cov. 87.58% Dividend Covering Cost
Yield if held 5 years 1.66% 2.00% 2.01% 2.77% 3.14% 4.16% 4.84% 4.40% 3.67% 3.13% 3.22% 3.00% 3.29% 3.08% 2.84% 2.51% 3.25% <-Median-> 10 Paid Median Price US$
Yield if held 10 years 1.75% 2.15% 2.52% 2.32% 2.40% 2.80% 3.54% 3.55% 4.95% 5.55% 6.35% 7.09% 6.51% 5.07% 4.00% 3.83% 4.25% <-Median-> 10 Paid Median Price US$
Yield if held 15 years 7.47% 6.56% 4.76% 3.30% 2.72% 2.95% 3.81% 4.45% 4.14% 4.25% 4.27% 5.19% 5.25% 6.82% 7.10% 7.55% 4.19% <-Median-> 10 Paid Median Price US$
Yield if held 20 years 20.13% 22.00% 21.38% 24.94% 17.62% 12.61% 11.63% 8.42% 5.90% 4.82% 4.51% 5.59% 6.58% 5.71% 5.43% 5.08% 7.50% <-Median-> 10 Paid Median Price US$
Yield if held 25 years 66.67% 34.00% 39.00% 37.82% 44.54% 31.19% 19.25% 17.04% 12.45% 8.14% 6.16% 5.36% 34.00% <-Median-> 9 Paid Median Price US$
Yield if held 30 years 118.03% 51.90% 57.14% 55.91% 61.47% 39.86% 22.90% 56.53% <-Median-> 4 Paid Median Price US$
Yield if held 35 years 150.82% 61.74% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 6.28% 8.11% 8.65% 11.99% 13.50% 16.07% 18.63% 17.75% 15.23% 13.39% 13.92% 12.92% 14.16% 13.91% 13.47% 12.29% 14.04% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 9.54% 12.52% 15.58% 15.04% 16.03% 17.09% 21.74% 22.97% 32.52% 37.25% 43.55% 49.14% 45.78% 38.14% 32.34% 32.65% 27.74% <-Median-> 10 Paid Median Price US$
Cost covered if held 15 years 46.51% 43.83% 33.92% 24.77% 21.12% 20.95% 27.20% 33.52% 32.21% 34.21% 35.58% 44.05% 45.59% 63.38% 70.88% 80.55% 32.87% <-Median-> 10 Paid Median Price US$
Cost covered if held 20 years 130.40% 153.49% 159.79% 197.14% 144.69% 95.23% 88.60% 67.89% 49.25% 41.76% 40.47% 51.22% 61.87% 58.03% 59.94% 60.48% 64.88% <-Median-> 10 Paid Median Price US$
Cost covered if held 25 years 557.68% 261.72% 303.61% 312.31% 381.99% 278.12% 178.55% 161.92% 121.54% 86.05% 70.96% 66.75% 278.12% <-Median-> 9 Paid Median Price US$
Cost covered if held 30 years 1062.60% 486.33% 549.41% 553.22% 659.94% 467.00% 290.75% 551.31% <-Median-> 4 Paid Median Price US$
Cost covered if held 35 years 1777.35% 788.79% #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 $0.00 <-Median-> 10 Special Dividends CDN$
Dividends CDN$ $0.85 $0.96 $1.05 $1.23 $1.48 $1.91 $2.16 $2.31 $2.68 $3.00 $2.95 $3.10 $3.69 $3.78 $3.78 $3.78 252.55% <-Total Growth 10 Dividends CDN$
Increase 3.18% 12.85% 9.24% 17.15% 20.48% 29.01% 13.16% 6.94% 16.30% 11.92% -1.69% 4.81% 19.30% 2.46% 0.00% 0.00% 13.43% <-IRR #YR-> 10 Dividends CDN$
Dividend Yield 2.15% 2.54% 2.23% 1.90% 1.64% 1.92% 2.07% 2.30% 2.25% 2.21% 1.77% 2.41% 2.99% 3.68% 3.68% 3.68% 9.86% <-IRR #YR-> 5 Dividends CDN$
Dividends per share in CDN$ funds Yield  5yr Med. 2.25% Curr diff 32.80%
-$1.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.69
-$2.31 $0.00 $0.00 $0.00 $0.00 $3.69
Future Dividend Yield Div Yd 5.45% earning in 5 Years at IRR of 8.13% Div Inc. 47.83% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 8.05% earning in 10 Years at IRR of 8.13% Div Inc. 118.53% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 11.90% earning in 15 Years at IRR of 8.13% Div Inc. 223.04% Future Dividend Yield CDN$
Close CDN$ Dec Dec-10 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 33.00 <Count Years> Month, Year
Price Close $35.02 $37.82 $41.32 $62.88 $87.50 $96.53 $89.39 $101.30 $122.10 $157.81 $149.14 $127.09 $105.53 $102.70 $102.70 $102.70
Close CDN$ April $39.52 $37.77 $47.02 $64.45 $90.23 $99.33 $104.27 $100.52 $119.21 $135.80 $166.69 $128.21 $123.49 $102.70 $102.70 $102.70 10.14% <-IRR #YR-> 10 Stock Price CDN$
5 yr Period ending 04/30/11 04/30/12 04/30/13 05/01/14 05/01/15 04/30/16 04/30/17 04/30/18 05/01/19 04/30/20 04/30/21 04/30/22 04/30/23 04/30/24 04/30/25 04/30/26 4.20% <-IRR #YR-> 5 Stock Price CDN$
5 year IRR Tot. Ret, -5.21% -6.73% 0.56% 13.18% 17.37% 22.49% 25.19% 19.19% 15.60% 10.76% 13.04% -51.55% 7.01% 13.35% <-IRR #YR-> 10 Price & Dividend CDN$
Median Div Yield Beg. of period 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.30% 7.01% <-IRR #YR-> 4 Price & Dividend CDN$
P/S Beginning of period 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.62 9 <-Count-> Neg years
P/E Beginning of Period 27.55 22.05 25.78 16.28 15.76 12.97 11.22 14.35 19.00 29.96 31.02 24.65 35.57 12 <-Count-> Total Return under 8% CDN$
29 <-Count-> Total numbe of years
Median Dividend Yield end of period 2.15% 2.54% 2.23% 1.90% 1.64% 1.92% 2.07% 2.30% 2.25% 2.21% 1.77% 2.41% 2.99% CDN$
P/S End of period 2.81 2.45 2.86 3.46 5.22 3.84 3.83 3.62 3.90 4.53 5.83 4.43 3.88 CDN$
P/E End of Period 12.97 11.22 14.35 19.00 29.96 31.02 24.65 35.57 26.67 32.05 44.04 27.73 27.56 CDN$
As a Canadian, would I have made money on this stock? Looking at 5 year periods to, including Dividends D.  per yr 3.21% 2.81% % Tot Ret 24.05% 40.10% CDN$
-$47.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $123.49 Dates 04/30/22 Price & Dividend CDN$
-$100.52 $0.00 $0.00 $0.00 $0.00 $123.49 04/30/22 Price & Dividend CDN$
-$47.02 $1.23 $1.48 $1.91 $2.16 $2.31 $2.68 $3.00 $2.95 $3.10 $127.19 Copy here 04/30/22 Price & Dividend CDN$
-$100.52 $2.68 $3.00 $2.95 $3.10 $127.19 04/30/22 Price & Dividend CDN$
-$104.27 $2.31 $2.68 $3.00 $2.95 $131.30 04/30/22 Price & Dividend CDN$
-$99.33 $2.16 $2.31 $2.68 $3.00 $169.64 04/30/21 Price & Dividend CDN$
-$90.23 $1.91 $2.16 $2.31 $2.68 $138.81 04/30/20 Price & Dividend CDN$
-$64.45 $1.48 $1.91 $2.16 $2.31 $121.89 05/01/19 Price & Dividend CDN$
-$47.02 $1.23 $1.48 $1.91 $2.16 $102.83 Cut & paste 04/30/18 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 not copy 04/30/16 Price & Dividend CDN$
$0.85 $0.96 $1.05 $1.23 $91.70 05/01/15 Price & Dividend CDN$
$0.85 $0.96 $1.05 $65.68 05/01/14 Price & Dividend CDN$
$0.85 $0.96 $48.07 04/30/13 Price & Dividend CDN$
$0.85 $38.72 04/30/12 Price & Dividend CDN$
$40.37 04/30/11 Price & Dividend CDN$
04/30/10 Price & Dividend CDN$
04/30/09 Price & Dividend CDN$
04/30/08 Price & Dividend CDN$
04/30/07 Price & Dividend CDN$
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$
04/30/95 Price & Dividend CDN$
Dividends on Shares CDN$ $30.68 $36.96 $47.69 $53.96 $57.71 $67.12 $75.11 $73.85 $77.40 $92.33 $94.61 $94.61 $94.61 $612.80 No of Years 10 Total Divs 12/31/12
Paid  $1,032.95 $1,572.06 $2,187.48 $2,413.17 $2,234.66 $2,532.52 $3,052.39 $3,945.22 $3,728.57 $3,177.21 $2,638.21 $2,567.38 $2,567.38 $2,567.38 $2,638.21 No of Years 10 Worth $41.32 24.20
Total $3,251.00
Dividends on Shares US$ $28.00 $30.50 $38.00 $43.00 $46.00 $50.00 $54.00 $58.00 $63.00 $68.00 $69.00 $69.00 $69.00 $478.50 No of Years 10 Total Divs 12/31/12
Paid  $1,025.50 $1,434.75 $1,805.00 $1,923.00 $1,780.75 $2,018.75 $2,274.00 $2,836.25 $2,928.50 $2,586.25 $1,943.00 $1,872.50 $1,872.50 $1,872.50 $1,943.00 No of Years 10 Worth $41.02 24.38
Total $2,421.50
Graham No. US$ $30.99 $35.58 $37.33 $36.37 $45.06 $45.57 $48.87 $43.74 $53.54 $54.89 $47.91 $57.25 $49.55 $55.03 $59.16 $61.45 32.73% <-Total Growth 10 Graham Price US$
Price/GP Ratio Med 1.18 1.00 1.12 1.50 1.53 1.58 1.72 1.89 1.68 1.77 2.30 2.24 1.84 1.52 1.74 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 1.35 1.14 1.28 1.71 1.76 1.75 1.82 2.04 1.86 2.21 2.74 2.36 2.14 1.65 1.95 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 1.01 0.85 0.96 1.28 1.30 1.42 1.61 1.75 1.49 1.33 1.85 2.13 1.54 1.39 1.51 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 1.35 1.07 1.25 1.62 1.65 1.74 1.70 1.83 1.66 1.78 2.73 1.82 1.84 1.36 1.27 1.22 1.76 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close 35.09% 7.36% 25.05% 61.75% 65.23% 73.69% 70.03% 83.21% 65.87% 77.85% 173.28% 82.28% 83.57% 36.11% 26.60% 21.89% 75.77% <-Median-> 10 Graham Price US$
Month, Year US$ Dec-10 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 Jan-26 33.00 <Count Years> Month, Year US$
Price Close $37.09 $38.25 $41.02 $57.39 $72.20 $76.92 $71.23 $80.75 $90.96 $113.45 $117.14 $103.45 $77.72 $74.90 $74.90 $74.90 89.47% <-Total Growth 10 Stock Price US$
Increase -15.67% 3.13% 7.24% 39.91% 25.81% 6.54% -7.40% 13.37% 12.64% 24.73% 3.25% -11.69% -24.87% -3.63% 0.00% 0.00% 29.16 <-Median-> 10 CAPE (10 Yr P/E) US$
P/E 12.97 11.22 14.35 19.00 29.96 31.02 24.65 35.57 26.67 32.05 44.04 27.73 27.56 22.03 19.06 17.67 -0.76% <-IRR #YR-> 5 Stock Price -3.75% US$
Trailing P/E 13.29 13.37 12.03 17.03 23.91 31.92 28.72 27.94 40.07 33.27 33.09 38.89 20.84 26.56 22.03 19.06 6.60% <-IRR #YR-> 10 Stock Price 89.47% US$
CAPE (10 Yr P/E) $19.31 $17.53 $17.17 $22.67 $27.52 $28.88 $26.27 $29.44 $31.46 $38.25 $39.76 $34.74 $26.59 $25.30 $24.06 $22.77 2.17% <-IRR #YR-> 5 Price & Dividend 10.76% US$
Median 10, 5 Yrs D.  per yr 3.36% 2.94% % Tot Ret 33.74% 135.04% T P/E 30.32 33.27 P/E:  28.85 27.73 9.96% <-IRR #YR-> 10 Price & Dividend 136.13% US$
Price 15 D.  per yr 2.38% % Tot Ret 44.68% CAPE Diff -24.46% 2.95% <-IRR #YR-> 15 Stock Price 54.61% US$
Price  20 D.  per yr 1.91% % Tot Ret 41.44% 2.70% <-IRR #YR-> 20 Stock Price 70.44% US$
Price  25 D.  per yr 1.85% % Tot Ret 29.28% 4.48% <-IRR #YR-> 25 Stock Price 198.92% US$
Price  30 D.  per yr 2.78% % Tot Ret 21.94% 9.91% <-IRR #YR-> 30 Stock Price US$
Price  35 D.  per yr 3.70% % Tot Ret 22.54% 12.71% <-IRR #YR-> 33 Stock Price
Price & Dividend 15 5.33% <-IRR #YR-> 15 Price & Dividend 101.59% US$
Price & Dividend 20 4.61% <-IRR #YR-> 20 Price & Dividend 126.54% US$
Price & Dividend 25 6.33% <-IRR #YR-> 25 Price & Dividend 301.04% US$
Price & Dividend 30 12.69% <-IRR #YR-> 30 Price & Dividend US$
Price & Dividend 35 16.41% <-IRR #YR-> 33 Stock Price US$
Price  5 -$80.75 $0.00 $0.00 $0.00 $0.00 $77.72 Price  5
Price 10 -$41.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $77.72 Price 10
Price & Dividend 5 -$80.75 $2.00 $2.16 $2.32 $2.52 $80.44 Price & Dividend 5
Price & Dividend 10 -$41.02 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $80.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 $77.72 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 $77.72 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 $77.72 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 $77.72 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 $77.72 Price  35
Price & Dividend 15 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $80.44 Price & Dividend 15
Price & Dividend 20 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $80.44 Price & Dividend 20
Price & Dividend 25 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $80.44 Price & Dividend 25
Price & Dividend 30 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $80.44 Price & Dividend 30
Price & Dividend 35 $0.90 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $80.44 Price & Dividend 35
Month, Year Apr-11 Apr-12 Apr-13 Apr-14 Apr-15 Apr-16 Apr-17 Apr-18 Apr-19 Apr-20 30-Apr-21 Apr-22 Apr-23 Apr-24 Apr-25 Apr-26 33.00 <Count Years> Month, Year
Price Close $41.86 $38.20 $46.68 $58.82 $74.45 $79.15 $83.09 $80.13 $88.81 $97.63 $130.92 $104.36 $90.95 $74.90 $74.90 $74.90 94.84% <-Total Growth 10 Stock Price US$
Increase -4.19% -8.74% 22.20% 26.01% 26.57% 6.31% 4.98% -3.56% 10.83% 9.93% 34.10% -20.29% -12.85% -17.65% 0.00% 0.00% 6.90% <-IRR #YR-> 10 Stock Price 94.84% US$
P/E 14.64 11.20 13.85 19.48 30.89 31.92 28.75 35.30 26.04 27.58 49.22 27.98 32.25 22.03 19.06 17.67 2.57% <-IRR #YR-> 5 Stock Price 13.50% US$
Trailing P/E 15.00 13.36 13.69 17.45 24.65 32.84 33.50 27.73 39.12 28.63 36.98 39.23 24.38 26.56 22.03 19.06 9.82% <-IRR #YR-> 10 Price & Dividend 28.13% US$
Median 10, 5 Yrs D.  per yr 2.92% 2.76% % Tot Ret 42.32% 107.74% T P/E 0.08 0.10 P/E:  85.95 97.63 5.33% <-IRR #YR-> 5 Price & Dividend 135.84% US$
Close US$ $41.86 $38.20 $46.68 $58.82 $74.45 $79.15 $83.09 $80.13 $88.81 $97.63 $130.92 $104.36 $90.95 $74.90 $74.90 $74.90 4 <-Count-> Neg years US$
5 yr Period ending 04/30/11 04/30/12 04/30/13 05/01/14 05/01/15 04/30/16 04/30/17 04/30/18 05/01/19 04/30/20 04/30/21 04/30/22 04/30/23 04/30/24 04/30/25 04/30/26 13 <-Count-> Total Return under 8% US$
5 year IRR Tot. Ret, -1.97% -4.59% 0.72% 15.32% 13.18% 15.74% 19.31% 13.93% 10.95% 7.78% 12.65% 6.54% 5.33% 29 <-Count-> Total numbe of years US$
-$46.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $90.95 04/30/23 US$
-$80.13 $0.00 $0.00 $0.00 $0.00 $90.95 04/30/23 US$
-$46.68 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $93.67 04/30/23 US$
-$80.13 $2.00 $2.16 $2.32 $2.52 $93.67 04/30/23 US$
-$83.09 $1.84 $2.00 $2.16 $2.32 $104.36 04/30/22 Price & Dividend US$
-$79.15 $1.72 $1.84 $2.00 $2.16 $133.24 04/30/21 Price & Dividend US$
-$74.45 $1.52 $1.72 $1.84 $2.00 $99.79 04/30/20 Price & Dividend US$
-$58.82 $1.22 $1.52 $1.72 $1.84 $90.81 05/01/19 Price & Dividend US$
-$46.68 $1.12 $1.22 $1.52 $1.72 $81.97 Cut & paste 04/30/18 Price & Dividend US$
-$38.20 $1.04 $1.12 $1.22 $1.52 $84.81 dates, do  04/30/17 Price & Dividend US$
-$41.86 $0.97 $1.04 $1.12 $1.22 $80.67 not copy 04/30/16 Price & Dividend US$
$0.90 $0.97 $1.04 $1.12 $75.67 05/01/15 Price & Dividend US$
$0.90 $0.97 $1.04 $59.94 05/01/14 Price & Dividend US$
$0.90 $0.97 $47.72 04/30/13 Price & Dividend US$
$0.90 $39.17 04/30/12 Price & Dividend US$
$42.76 04/30/11 Price & Dividend US$
04/30/10 Price & Dividend US$
04/30/09 Price & Dividend US$
01/00/00 Price & Dividend US$
04/30/07 Price & Dividend US$
04/30/06 Price & Dividend US$
04/30/05 Price & Dividend US$
04/30/04 Price & Dividend US$
04/30/03 Price & Dividend US$
04/30/02 Price & Dividend US$
04/30/01 Price & Dividend US$
04/30/00 Price & Dividend US$
04/30/99 Price & Dividend US$
04/30/98 Price & Dividend US$
04/30/97 Price & Dividend US$
04/30/96 Price & Dividend US$
04/30/95 Price & Dividend US$
Price Median H/L $36.54 $35.53 $41.81 $54.48 $69.01 $72.15 $83.87 $82.78 $89.71 $97.11 $110.03 $128.49 $91.20 $83.61 118.14% <-Total Growth 10 Stock Price US$
Increase -6.07% -2.75% 17.66% 30.32% 26.67% 4.55% 16.24% -1.31% 8.37% 8.25% 13.30% 16.77% -29.02% -8.32% 8.11% <-IRR #YR-> 10 Stock Price 118.14% US$
P/E 12.77 10.42 12.41 18.04 28.63 29.09 29.02 36.46 26.31 27.43 41.36 34.45 32.34 24.59 1.96% <-IRR #YR-> 5 Stock Price 10.17% US$
Trailing P/E 13.09 12.42 12.26 16.17 22.85 29.94 33.82 28.64 39.52 28.48 31.08 48.30 24.45 29.65 11.21% <-IRR #YR-> 10 Price & Dividend 24.33% US$
P/E on Run. 5 yr Ave 15.30 13.73 14.56 17.63 22.90 24.56 29.59 31.67 33.32 33.28 37.25 41.15 28.22 25.89 4.67% <-IRR #YR-> 5 Price & Dividend 163.93% US$
P/E on Run. 10 yr Ave 19.02 16.28 17.50 21.53 26.30 27.09 30.94 30.18 31.03 32.74 37.35 43.14 31.20 28.24 27.28 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 3.10% 2.71% % Tot Ret 27.64% 58.07% T P/E 29.29 31.08 P/E:  29.06 32.34
-$41.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $91.20
-$82.78 $0.00 $0.00 $0.00 $0.00 $91.20
-$41.81 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $93.92
-$82.78 $2.00 $2.16 $2.32 $2.52 $93.92
High Months Apr 11 Feb 12 Apr 13 Apr 14 Feb 15 Apr 16 Jul 16 Jun 17 Oct 18 Feb 20 Apr 21 Sep 21 May 22 May 23
Price Hi $41.86 $40.65 $47.72 $62.31 $79.25 $79.78 $88.92 $89.20 $99.49 $121.30 $131.20 $135.17 $106.26 $90.68 122.67% <-Total Growth 10 Stock Price US$
Increase -9.06% -2.89% 17.39% 30.57% 27.19% 0.67% 11.46% 0.31% 11.54% 21.92% 8.16% 3.03% -21.39% -14.66% 8.33% <-IRR #YR-> 10 Stock Price 122.67% US$
P/E 14.64 11.92 14.16 20.63 32.88 32.17 30.77 39.30 29.18 34.27 49.32 36.24 37.68 26.67 3.56% <-IRR #YR-> 5 Stock Price 19.13% US$
Trailing P/E 15.00 14.21 13.99 18.49 26.24 33.10 35.85 30.87 43.83 35.57 37.06 50.82 28.49 32.16 32.00 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 34.34 37.06 P/E:  33.57 36.24 47.93 P/E Ratio Historical High US$
-$47.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $106.26
-$89.20 $0.00 $0.00 $0.00 $0.00 $106.26
Low Months Aug 10 Aug 11 Jun 12 May 13 May 14 Sep 15 May 16 Mar 18 May 18 Mar 20 Jun 20 Jun 21 Jnov 22 Sep 23
Price Low $31.21 $30.41 $35.89 $46.65 $58.77 $64.52 $78.82 $76.35 $79.92 $72.92 $88.86 $121.80 $76.13 $76.54 112.12% <-Total Growth 10 Stock Price US$
Increase -1.73% -2.56% 18.02% 29.98% 25.98% 9.78% 22.16% -3.13% 4.68% -8.76% 21.86% 37.07% -37.50% 0.54% 7.81% <-IRR #YR-> 10 Stock Price 112.12% US$
P/E 10.91 8.92 10.65 15.45 24.39 26.02 27.27 33.63 23.44 20.60 33.41 32.65 27.00 22.51 -0.06% <-IRR #YR-> 5 Stock Price -0.29% US$
Trailing P/E 11.19 10.63 10.52 13.84 19.46 26.77 31.78 26.42 35.21 21.38 25.10 45.79 20.41 27.14 23.45 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 25.76 25.10 P/E:  26.51 27.00 14.56 P/E Ratio Historical Low US$
-$35.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $76.13
-$76.35 $0.00 $0.00 $0.00 $0.00 $76.13
$4,444 <-12 mths -2.97%
Free Cash Flow MDT $5,978 $4,580 Free Cash Flow MDT
Change -23.39% Change
Free Cash Flow MS WSJ Mkt S $3,240 $3,986 $4,495 $4,563 $4,331 $4,172 $5,626 $3,616 $5,873 $6,021 $4,885 $5,978 $4,580 $6,206 $6,083 $6,218 1.89% <-Total Growth 10 Free Cash Flow US$
Change 23.02% 12.77% 1.51% -5.08% -3.67% 34.85% -35.73% 62.42% 2.52% -18.87% 22.37% -23.39% 35.50% -1.98% 2.22% 4.84% <-IRR #YR-> 5 Free Cash Flow MS 26.66% US$
FCF/CF from Op Ratio 0.87 0.89 0.92 0.92 0.88 0.80 0.82 0.77 0.84 0.83 0.78 0.81 0.76 0.83 0.74 0.68 0.19% <-IRR #YR-> 10 Free Cash Flow MS 1.89% US$
Dividends paid $1,057 $1,119 $1,734 $2,139 $2,376 $2,494 $2,693 $2,894 $3,120 $3,383 $3,616 $3,673 $3,673 $3,673 242.21% <-Total Growth 10 Dividends paid US$
Percentage paid 51.27% 42.23% 68.97% 45.85% 48.07% 63.87% 56.59% 78.95% 59.18% 60.38% 59.07% $0.54 <-Median-> 8 Percentage paid US$
5 Year Coverage 49.77% 52.18% 55.30% 57.45% 60.30% 62.98% 61.99% 5 Year Coverage US$
Dividend Coverage Ratio 1.95 2.37 1.45 2.18 2.08 1.57 1.77 1.27 1.69 1.66 1.69 1.86 <-Median-> 8 Dividend Coverage Ratio US$
5 Year of Coverage 2.01 1.92 1.81 1.74 1.66 1.59 1.61 5 Year of Coverage US$
-$3,616 $0 $0 $0 $0 $4,580
-$4,495 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,580
Market Cap $44,797 $39,621 $47,428 $58,761 $105,842 $110,732 $113,786 $108,514 $119,067 $130,929 $175,574 $140,406 $121,031 $99,673 $99,673 $99,673 155.19% <-Total Growth 10 Market Cap US$
Diluted # of Shares in Million 1,081.7 1,059.9 1,027.5 1,013.6 1,109.0 1,425.9 1,391.4 1,368.2 1,357.5 1,351.1 1,354.0 1,351.4 1,332.8 1,333.8 29.71% <-Total Growth 10 Diluted US$
Change -2.50% -2.02% -3.06% -1.35% 9.41% 28.58% -2.42% -1.67% -0.78% -0.47% 0.21% -0.19% -1.38% 0.08% -0.63% <-Median-> 10 Change US$
Difference Diluted/Basic -0.4% -0.6% -0.8% -1.1% -1.2% -1.1% -0.9% -0.8% -0.8% -0.8% -0.7% -0.7% -0.2% -0.2% -0.83% <-Median-> 10 Difference Diluted/Basic US$
Basic # of Shares in Millions 1,077.4 1,053.9 1,019.3 1,002.1 1,095.5 1,409.6 1,378.9 1,356.7 1,346.4 1,340.7 1,344.9 1,342.4 1,329.8 1,330.5 30.46% <-Total Growth 10 Average US$
Change -2.61% -2.18% -3.28% -1.69% 9.32% 28.67% -2.18% -1.61% -0.76% -0.42% 0.31% -0.19% -0.94% 0.05% -0.59% <-Median-> 10 Change US$
Difference Basic/Outstanding -0.7% -1.6% -0.3% -0.3% 29.8% -0.8% -0.7% -0.2% -0.4% 0.0% -0.3% 0.2% 0.1% 0.0% -0.23% <-Median-> 10 Difference Basic/Outstanding US$
$5,831 <-12 mths -3.44%
Split ' 97
Split ' 99
# of Share in Millions 1,070 1,037 1,016 999 1,422 1,399 1,369 1,354 1,341 1,341 1,341 1,345 1,331 1,331 1,331 1,331 2.74% <-IRR #YR-> 10 Shares 30.98% US$
Change -2.48% -3.08% -2.04% -1.67% 42.31% -1.59% -2.12% -1.11% -1.00% 0.03% 0.00% 0.32% -1.09% 0.00% 0.00% 0.00% -0.35% <-IRR #YR-> 5 Shares -1.73% US$
CF fr Op $M $3,741 $4,470 $4,883 $4,959 $4,902 $5,218 $6,880 $4,684 $7,007 $7,234 $6,240 $7,346 $6,039 $7,519 $8,237 $9,116 23.67% <-Total Growth 10 Cash Flow US$
Increase -9.44% 19.49% 9.24% 1.56% -1.15% 6.45% 31.85% -31.92% 49.59% 3.24% -13.74% 17.72% -17.79% 24.50% 9.56% 10.66% SO Buy Backs Share Issue US$
5 year Running Average $3,644 $3,942 $4,221 $4,437 $4,591 $4,886 $5,368 $5,329 $5,738 $6,205 $6,409 $6,502 $6,773 $6,876 $7,076 $7,651 60.48% <-Total Growth 10 CF 5 Yr Running US$
CFPS $3.50 $4.31 $4.81 $4.96 $3.45 $3.73 $5.02 $3.46 $5.23 $5.39 $4.65 $5.46 $4.54 $5.65 $6.19 $6.85 -5.58% <-Total Growth 10 Cash Flow per Share US$
Increase -7.14% 23.28% 11.52% 3.29% -30.54% 8.17% 34.70% -31.15% 51.10% 3.21% -13.74% 17.35% -16.89% 24.50% 9.56% 10.66% 2.15% <-IRR #YR-> 10 Cash Flow 23.67% US$
5 year Running Average $3.29 $3.63 $3.97 $4.27 $4.20 $4.25 $4.39 $4.12 $4.18 $4.57 $4.75 $4.84 $5.05 $6.48 $6.48 $6.48 5.21% <-IRR #YR-> 5 Cash Flow 28.93% US$
P/CF on Med Price 10.45 8.24 8.70 10.98 20.01 19.34 16.69 23.93 17.16 18.00 23.65 23.53 20.10 14.80 0.00 0.00 -0.57% <-IRR #YR-> 10 Cash Flow per Share -5.58% US$
P/CF on Closing Price 11.97 8.86 9.71 11.85 21.59 21.22 16.54 23.17 16.99 18.10 28.14 19.11 20.04 13.26 12.10 10.93 5.58% <-IRR #YR-> 5 Cash Flow per Share 31.20% US$
-32.64% Diff M/C 2.45% <-IRR #YR-> 10 CFPS 5 yr Running 27.37% US$
$6,872 <-12 mths -1.91%
Excl.Working Capital CF $1,012.0 -$18.0 -$301.0 -$218.0 -$1,564.0 $1,089.0 -$139.0 $173.0 $1,080.0 -$61.0 $701.0 $889.0 $967.0 $0.0 $0.0 $0.0 4.15% <-IRR #YR-> 5 CFPS 5 yr Running 22.53% US$
CF fr Op $M WC $4,753 $4,452 $4,582 $4,741 $3,338 $6,307 $6,741 $4,857 $8,087 $7,173 $6,941 $8,235 $7,006 $7,519 $8,237 $9,116 52.90% <-Total Growth 10 Cash Flow less WC US$
Increase 22.22% -6.33% 2.92% 3.47% -29.59% 88.95% 6.88% -27.95% 66.50% -11.30% -3.23% 18.64% -14.92% 7.32% 9.56% 10.66% 4.34% <-IRR #YR-> 10 Cash Flow less WC 52.90% US$
5 year Running Average $3,835 $4,040 $4,257 $4,483 $4,373 $4,684 $5,142 $5,197 $5,866 $6,633 $6,760 $7,059 $7,488 $7,375 $7,588 $8,023 7.60% <-IRR #YR-> 5 Cash Flow less WC 44.25% US$
CFPS Excl. WC $4.44 $4.29 $4.51 $4.75 $2.35 $4.51 $4.92 $3.59 $6.03 $5.35 $5.18 $6.12 $5.26 $5.65 $6.19 $6.85 5.81% <-IRR #YR-> 10 CF less WC 5 Yr Run 75.91% US$
Increase 25.32% -3.36% 5.07% 5.23% -50.52% 92.00% 9.19% -27.14% 68.18% -11.33% -3.23% 18.26% -13.99% 7.32% 9.56% 10.66% 7.58% <-IRR #YR-> 5 CF less WC 5 Yr Run 44.10% US$
5 year Running Average $3.46 $3.72 $4.00 $4.31 $4.07 $4.08 $4.21 $4.02 $4.28 $4.88 $5.01 $5.25 $5.59 $5.51 $5.68 $6.02 1.56% <-IRR #YR-> 10 CFPS - Less WC 16.74% US$
P/CF on Med Price 8.23 8.28 9.27 11.48 29.39 16.00 17.04 23.08 14.87 18.16 21.26 20.99 17.32 14.80 0.00 0.00 7.98% <-IRR #YR-> 5 CFPS - Less WC 46.79% US$
P/CF on Closing Price 9.42 8.90 10.35 12.39 31.71 17.56 16.88 22.34 14.72 18.25 25.30 17.05 17.28 13.26 12.10 10.93 3.39% <-IRR #YR-> 10 CFPS 5 yr Running 39.63% US$
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 19.68 5 yr  20.10 P/CF Med 10 yr 17.74 5 yr  18.16 -25.27% Diff M/C 6.80% <-IRR #YR-> 5 CFPS 5 yr Running 38.94% US$
-1,016.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1,330.7 Shares
-1,354.2 0.0 0.0 0.0 0.0 1,330.7 Shares
-$4,883 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,039 Cash Flow
-$4,684 $0 $0 $0 $0 $6,039 Cash Flow
-$4.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.54 Cash Flow per Share
-$3.46 $0.00 $0.00 $0.00 $0.00 $4.54 Cash Flow per Share
-$3.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.05 CFPS 5 yr Running
-$4.12 $0.00 $0.00 $0.00 $0.00 $5.05 CFPS 5 yr Running
-$4,582 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,006 Cash Flow less WC
-$4,857 $0 $0 $0 $0 $7,006 Cash Flow less WC
-$4,257 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,488 CF less WC 5 Yr Run
-$5,197 $0 $0 $0 $0 $7,488 CF less WC 5 Yr Run
-$4.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.26 CFPS - Less WC
-$3.59 $0.00 $0.00 $0.00 $0.00 $5.26 CFPS - Less WC
-$4.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.59 CFPS 5 yr Running
-$4.02 $0.00 $0.00 $0.00 $0.00 $5.59 CFPS 5 yr Running
Accounts receivable, net -$70 -$413 -$435 -$75 -$275 -$581 $1,291 -$761 -$477 -$576
Inventories -$39 -$282 -$186 -$227 -$192 -$274 -$577 $78 -$560 -$939
Accounts payable and accrued liabilities -$117 $1,616 -$65 $356 $65 $399 -$44 $531 $213 $696
Other operating assets and liabilities $444 $643 -$403 $85 $229 -$624 -$609 -$549 -$65 -$148
                   
Sum $218 $1,564 -$1,089 $139 -$173 -$1,080 $61 -$701 -$889 -$967
Google --> Morningstar $218 $1,564 -$1,089 $139 -$173 -$1,080 $61 -$701 -$888 -$967
Difference $0 $0 $0 $0 $0 $0 $0 $0 -$1 $0
 Morningstar $218 $1,564 -$1,089 $139
Difference $0 $0 $0 $0
OPM 23.48% 27.62% 29.43% 29.16% 24.19% 18.10% 23.16% 15.64% 22.93% 25.02% 20.72% 23.18% 19.34% 23.37% -34.30% <-Total Growth 10 OPM US$
Increase -10.10% 17.63% 6.57% -0.92% -17.03% -25.20% 27.96% -32.47% 46.64% 9.11% -17.19% 11.89% -16.58% 20.83% Should increase  or be stable. US$
Diff from Ave 1.3% 19.2% 27.0% 25.9% 4.4% -21.9% -0.1% -32.5% -1.0% 8.0% -10.6% 0.1% -16.5% 0.9% -0.01 <-Median-> 10 OPM US$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 23.17% 5 Yrs 22.93% should be  zero, it is a   check on calculations US$
Long Term Debt $8,112 $7,359 $3,891 $10,315 $33,752 $30,247 $25,921 $23,699 $24,486 $22,021 $26,378 $20,372 $24,344 $17,481 Debt US$
Change -9.28% -47.13% 165.10% 227.21% -10.38% -14.30% -8.57% 3.32% -10.07% 19.79% -22.77% 19.50% -28.19% -2.63% <-Median-> 10 Change US$
Debt/Market Cap Ratio 0.18 0.19 0.08 0.18 0.32 0.27 0.23 0.22 0.21 0.17 0.15 0.15 0.20 0.18 0.20 <-Median-> 10 % of Market C. US$
Assets/Current Liabilities Ratio 6.45 5.65 8.95 6.83 11.63 13.93 7.02 9.06 10.59 8.75 10.94 7.34 10.05 6.40 9.56 <-Median-> 10 Assets/Current Liab Ratio US$
Debt to Cash Flow (Years) 2.17 1.65 0.80 2.08 6.89 5.80 3.77 5.06 3.49 3.04 4.23 2.77 4.03 2.33 3.90 <-Median-> 10 Debt to Cash Flow (Years) US$
Intangibles $2,725 $2,647 $2,673 $12,879 $28,101 $26,899 $23,407 $21,723 $20,560 $19,063 $17,740 $15,595 $14,844 $15,775 455.33% <-Total Growth 10 Intangibles
Goodwill $9,520 $9,934 $10,329 $10,593 $40,530 $41,500 $38,515 $39,543 $39,959 $39,841 $41,961 $40,502 $41,425 $40,324 301.06% <-Total Growth 10 Goodwill
Total $12,245 $12,581 $13,002 $23,472 $68,631 $68,399 $61,922 $61,266 $60,519 $58,904 $59,701 $56,097 $56,269 $56,099 332.77% <-Total Growth 10 Total US$
Change 2.74% 3.35% 80.53% 192.40% -0.34% -9.47% -1.06% -1.22% -2.67% 1.35% -6.04% 0.31% -0.30% -0.70% <-Median-> 10 Change US$
Intangible/Market Cap Ratio 0.27 0.32 0.27 0.40 0.65 0.62 0.54 0.56 0.51 0.45 0.34 0.40 0.46 0.56 0.49 <-Median-> 10 % of Market C. US$
Current Assets $9,117 $9,151 $17,793 $21,210 $30,844 $23,600 $24,873 $22,980 $21,967 $22,031 $22,548 $23,059 $21,675 $22,135 Liquidity ratio of 1.5 and up, best Assets US$
Current Liabilities $4,714 $5,857 $3,891 $5,559 $9,173 $7,165 $14,220 $10,084 $8,472 $10,366 $8,509 $12,394 $9,051 $14,049 2.49 <-Median-> 10 Liabilities US$
Liquidity 1.93 1.56 4.57 3.82 3.36 3.29 1.75 2.28 2.59 2.13 2.65 1.86 2.39 1.58 2.39 <-Median-> 5 Ratio US$
Liq. with CF aft div 2.52 2.15 5.56 4.51 3.71 3.73 2.07 2.50 3.10 2.54 3.02 2.18 2.66 1.85 2.66 <-Median-> 5 Ratio US$
Liq. CF re  Inv+Div  1.82 1.48 3.09 2.74 1.30 3.73 1.86 2.50 2.84 1.94 2.26 1.92 1.92 1.85 1.94 <-Median-> 5 Ratio US$
Assets $30,424 $33,083 $34,841 $37,943 $106,685 $99,782 $99,816 $91,393 $89,694 $90,689 $93,083 $90,981 $90,948 $89,914 Debt Ratio of 1.5 and up, best Assets US$
Liabilities $14,456 $15,970 $16,170 $18,500 $53,455 $47,719 $49,400 $40,571 $39,482 $39,817 $41,481 $38,260 $39,283 $37,071 2.25 <-Median-> 10 Liabilities US$
Debt Ratio 2.10 2.07 2.15 2.05 2.00 2.09 2.02 2.25 2.27 2.28 2.24 2.38 2.32 2.43 2.28 <-Median-> 5 Ratio US$
Estimates BVPS $39.20 $40.20 $41.50 Estimates Estimates BVPS
Estimate Book Value $52,165.1 $53,495.9 $55,225.9 Estimates Estimate Book Value
P/B Ratio (Close) 1.91 1.86 1.80 Estimates P/B Ratio (Close)
Difference from 10 year median -19.69% Diff M/C Estimates Difference from 10 yr med.
Book Value $15,968 $17,113 $18,671 $19,443 $53,230 $52,063 $50,416 $50,822 $50,212 $50,872 $51,602 $52,721 $51,665 $52,843
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $122 $102 $121 $135 $174 $171 $182 $170
Net Book Value $15,968 $17,113 $18,671 $19,443 $53,230 $52,063 $50,294 $50,720 $50,091 $50,737 $51,428 $52,550 $51,483 $52,673 $52,673 $52,673 175.74% <-Total Growth 10 Book Value US$
Book Value per Share $14.92 $16.50 $18.38 $19.46 $37.44 $37.21 $36.73 $37.45 $37.36 $37.83 $38.35 $39.06 $38.69 $39.58 $39.58 $39.58 110.52% <-Total Growth 10 Book Value per Share US$
Change 11.93% 10.58% 11.38% 5.91% 92.38% -0.61% -1.31% 1.98% -0.24% 1.26% 1.36% 1.85% -0.95% 2.31% 0.00% 0.00% -20.46% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 2.45 2.15 2.27 2.80 1.84 1.94 2.28 2.21 2.40 2.57 2.87 3.29 2.36 2.11 0.00 0.00 3.49 P/B Ratio Historical Median US$
P/B Ratio (Close) 2.81 2.32 2.54 3.02 1.99 2.13 2.26 2.14 2.38 2.58 3.41 2.67 2.35 1.89 1.89 1.89 7.73% <-IRR #YR-> 10 Book Value per Share 110.52% US$
Change -14.40% -17.47% 9.71% 18.98% -34.21% 6.97% 6.37% -5.43% 11.10% 8.56% 32.30% -21.74% -12.01% -19.51% 0.00% 0.00% 0.65% <-IRR #YR-> 5 Book Value per Share 3.29% US$
Leverage (A/BK) 1.91 1.93 1.87 1.95 2.00 1.92 1.98 1.80 1.79 1.79 1.81 1.73 1.77 1.71 1.81 <-Median-> 10 A/BV US$
Debt/Equity Ratio 0.91 0.93 0.87 0.95 1.00 0.92 0.98 0.80 0.79 0.78 0.81 0.73 0.76 0.70 0.80 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.38 5 yr Med 2.57 -20.46% Diff M/C 1.79 Historical Leverage (A/BK) US$
-$18.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38.69
-$37.45 $0.00 $0.00 $0.00 $0.00 $38.69
$1,859 <-12 mths -25.58%
Comprehensive Income $3,179 $3,179 $3,448 $2,960 $2,088 $2,854 $3,280 $4,125 $3,675 $3,955 $3,713 $6,258 $2,524 Comprehensive Income
NCI $0 $0 $0 $0 $0 $0 -$3 -$9 $16 $15 $32 $32 $26 NCI
Shareholders $3,179 $3,179 $3,448 $2,960 $2,088 $2,854 $3,283 $4,134 $3,659 $3,940 $3,681 $6,226 $2,498 -27.55% <-Total Growth 10 Comprehensive Income US$
Increase 6.07% 0.00% 8.46% -14.15% -29.46% 36.69% 15.03% 25.92% -11.49% 7.68% -6.57% 69.14% -59.88% -6.57% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $2,527 $2,732 $2,991 $3,153 $2,971 $2,906 $2,927 $3,064 $3,204 $3,574 $3,739 $4,328 $4,001 -3.17% <-IRR #YR-> 10 Comprehensive Income -27.55% US$
ROE 19.9% 18.6% 18.5% 15.2% 3.9% 5.5% 6.5% 8.2% 7.3% 7.8% 7.2% 11.8% 4.9% -9.58% <-IRR #YR-> 5 Comprehensive Income -39.57% US$
5Yr Median 19.6% 18.6% 18.6% 18.6% 18.5% 15.2% 6.5% 6.5% 6.5% 7.3% 7.3% 7.8% 7.3% 2.95% <-IRR #YR-> 10 5 Yr Running Average 33.75% US$
% Difference from NI 2.7% -12.1% -0.5% -3.4% -21.9% -19.3% -18.5% 33.2% -21.0% -17.7% 2.1% 23.5% -33.5% 5.48% <-IRR #YR-> 5 5 Yr Running Average 30.58% US$
Median Values Diff 5, 10 yr -18.1% -17.7% 7.3% <-Median-> 5 Return on Equity US$
-$3,448 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,498
-$4,134 $0 $0 $0 $0 $2,498
-$2,991 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,001
-$3,064 $0 $0 $0 $0 $4,001
Current Liability Coverage Ratio 1.01 0.76 1.18 0.85 0.36 0.88 0.47 0.48 0.95 0.69 0.82 0.66 0.77 0.54   CFO / Current Liabilities US$
5 year Median 1.01 0.99 1.01 0.85 0.85 0.85 0.85 0.48 0.48 0.69 0.69 0.69 0.77 0.69 0.77 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio 15.62% 13.46% 13.15% 12.50% 3.13% 6.32% 6.75% 5.31% 9.02% 7.91% 7.46% 9.05% 7.70% 8.36% CFO / Total Assets US$
5 year Median 15.62% 15.29% 13.84% 13.46% 13.15% 12.50% 6.75% 6.32% 6.32% 6.75% 7.46% 7.91% 7.91% 7.91% 7.9% <-Median-> 5 Return on Assets  US$
Return on Assets ROA 10.18% 10.93% 9.95% 8.08% 2.51% 3.55% 4.04% 3.40% 5.16% 5.28% 3.87% 5.54% 4.13% 4.99% Net  Income/Assets Return on Assets US$
5Yr Median 10.18% 10.18% 10.18% 10.18% 9.95% 8.08% 4.04% 3.55% 3.55% 4.04% 4.04% 5.16% 5.16% 4.99% 5.2% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE 19.39% 21.14% 18.57% 15.76% 5.03% 6.80% 8.01% 6.12% 9.25% 9.44% 7.01% 9.59% 7.30% 8.51% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 19.39% 19.39% 19.39% 19.39% 18.57% 15.76% 8.01% 6.80% 6.80% 8.01% 8.01% 9.25% 9.25% 8.51% 9.2% <-Median-> 5 Return on Equity US$
$3,620 <-12 mths -3.67%
Net Income $3,096 $3,617 $3,467 $3,065 $2,675 $3,538 $4,024 $3,095 $4,650 $4,806 $3,630 $5,062 $3,784
NCI $0 $0 $0 $0 $0 $0 -$4 -$9 $19 $17 $24 $22 $26
Shareholders $3,096 $3,617 $3,467 $3,065 $2,675 $3,538 $4,028 $3,104 $4,631 $4,789 $3,606 $5,040 $3,758 $4,483 $5,153 $5,520 8.39% <-Total Growth 10 Net Income US$
Increase -0.10% 16.83% -4.15% -11.60% -12.72% 32.26% 13.85% -22.94% 49.19% 3.41% -24.70% 39.77% -25.44% 19.29% 14.95% 7.12% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $2,679 $2,842 $3,090 $3,269 $3,184 $3,272 $3,355 $3,282 $3,595 $4,018 $4,032 $4,234 $4,365 $4,335 $4,408 $4,791 0.81% <-IRR #YR-> 10 Net Income 8.39% US$
Operating Cash Flow $3,741 $4,470 $4,883 $4,959 $4,902 $5,218 $6,880 $4,684 $7,007 $7,234 $6,240 $7,346 $6,039 3.90% <-IRR #YR-> 5 Net Income 21.07% US$
Investment Cash Flow -$1,815 -$2,651 -$3,101 -$3,594 -$17,058 $2,245 -$1,571 $5,858 -$774 -$3,203 -$2,866 -$1,659 -$3,493 3.52% <-IRR #YR-> 10 5 Yr Running Average 41.27% US$
Total Accruals $1,170 $1,798 $1,685 $1,700 $14,831 -$3,925 -$1,281 -$7,438 -$1,602 $758 $232 -$647 $1,212 5.87% <-IRR #YR-> 5 5 Yr Running Average 32.99% US$
Total Assets $30,424 $33,083 $34,841 $37,943 $106,685 $99,782 $99,816 $91,393 $89,694 $90,689 $93,083 $90,981 $90,948 Balance Sheet Assets US$
Accruals Ratio 3.85% 5.43% 4.84% 4.48% 13.90% -3.93% -1.28% -8.14% -1.79% 0.84% 0.25% -0.71% 1.33% 0.25% <-Median-> 5 Ratio US$
EPS/CF Ratio 0.82 0.79 0.70 0.61 0.70 0.66 0.58 0.66 0.65 0.66 0.57 0.68 0.62 0.65 <-Median-> 10 EPS/CF Ratio US$
-$3,467 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,758
-$3,104 $0 $0 $0 $0 $3,758
-$3,090 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,365
-$3,282 $0 $0 $0 $0 $4,365
Chge in Close -4.19% -8.74% 22.20% 26.01% 26.57% 6.31% 4.98% -3.56% 10.83% 9.93% 34.10% -20.29% -12.85% -17.65% 0.00% 0.00% Count 29 Years of data
up/down/neutral down down down Up Count 14
Any Predictions? yes  Yes % right Count 7 50.00%
Financial Cash Flow -$2,006 -$1,882 -$2,101 -$918 $16 -$9,543 -$3,283 -$11,954 -$5,431 -$4,198 -$4,136 -$5,336 -$4,960 C F Statement  Financial Cash Flow US$
Total Accruals $3,176 $3,680 $3,786 $2,618 $14,815 $5,618 $2,002 $4,516 $3,829 $4,956 $4,368 $4,689 $6,172 Accruals US$
Accruals Ratio 10.44% 11.12% 10.87% 6.90% 13.89% 5.63% 2.01% 4.94% 4.27% 5.46% 4.69% 5.15% 6.79% 5.15% <-Median-> 5 Ratio US$
Cash $1,382 $1,248 $860 $1,403 $4,843 $2,876 $4,967 $7,669 $4,393 $4,140 $3,593 $31,714 $1,543 $2,140 Cash US$
Cash per Share $1.29 $1.20 $0.85 $1.40 $3.41 $2.06 $3.63 $5.66 $3.28 $3.09 $2.68 $23.57 $1.16 $1.61 $3.09 <-Median-> 5 Cash per Share US$
Percentage of Stock Price 3.09% 3.15% 1.81% 2.39% 4.58% 2.60% 4.37% 7.07% 3.69% 3.16% 2.05% 22.59% 1.27% 2.15% 3.16% <-Median-> 5 % of Stock Price US$
Notes:
October 3, 2023.  Last estimates were for 2023, 2024 and 2025 of $31611M, $33063M and $34476M for Revenue, $5.53, $5.86 and $6.19 for AEPS, $4.18, $4.61 and $5.13 for EPS, 
$2.67, $2.70 and $2.74 for dividends, $6025M, $6147M and $5720M for FCF, $5.30, $6.26 and 7.14 for CFPS, $41.20, $41.90 and $42.30 for BVPS, $5572M, $6119M and $6785M for Net Income.
October 7, 2022.  Last estimates were for 2022, 2023 and 2024 of 32992M, $34779M and $36584M for Revenue, $3.97, $4.77 and $5.25 for EPS, 
$2.40, $2.54 and $2.60 for Dividends, $5551< $7512 anf $7982 for FCF, $5.86, $6.62 and $8.11 for CFPS, and $5704M, $6423M and $7045M for Net Income.
October 3, 2021.  Last estimates were for 2021, 2022 and 2023 of $29086M, $32205M and $34455M for Revenue, $2.94, $4.46 and $5.24 for EPS, 
$2.26, $2.37 and $2.50 for Dividends, $3596M, $6582M and $7154M for FCF, $2.90 and $3.09 for CFOS for 2021 and 2022 and $3963M, $5964M and $6944M for Net Income.
September 10, 2020.  The last estimates were for 2020, 2021 and 2022 of $31492M, $32994M and $34727M for Revenue, 
$3.99, $4.54 ad $5.40 for EPS, $5.07, $5.65 and $5.65 for CFPS and $5412, $6087M and $7180M for Net Income.
October 11, 2019.  Last estimates were for 2019, 2020 and 2021 of $30472M, $31868M and $33291M for Revenue, 
$3.79, $4.15 and $4.56 for EPS, $3.85, $4.67 and $5.76 for CFPS and $5223M, $5588M and $5836M for Net Income.
October 14, 2018.  Last estimates were for 2018, 2019 and 2020 of $29262M, $30287M and $31804M US$ for Revenue, $3.28, $3.86 and $4.49 for EPS US$, 
$4.78, $5.92 and $7.53 for CFPS US$ and $4607M, $5365M and $4120M for Net Income US$.
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.
In 2018, lots of sites talk about this company having 41 years of dividend growth.
Dividends paid since 1977 and  increased for 43 years.
How they make their money.
Medtronic, Inc currently generates revenues from four major segments - namely Cardiovascular Portfolio, Medical Surgical Portfolio, Neuroscience Portfolio and Diabetes. 
It offers its products to hospitals, third-party healthcare providers, clinics, institutions including governmental healthcare programs, distributors, and group purchasing 
organizations in Asia Pacific, Europe, the Americas, the Middle East, and Africa. Medtronic is headquartered in Dublin, Ireland.   
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.  
Also, for the Operational Profit Margin, a higher percentage is better.  With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2015 Oct 22 2016 Oct 21 2017 Oct 14 2018 Oct 11 2019 Oct 10 2020 Oct 3 2021 Oct 7 2022 Oct 3 2023
Martha, Geoffrey, S.  0.052 0.00% 0.081 0.01% 0.096 0.01% 0.102 0.01% 0.141 0.01% Shows as CEO 2020 37.71%
CEO & Chair Shares - Amount $5.858 $9.499 $9.914 $7.966 $10.572
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000
Parkhill, Karen L.  0.064 0.00% 0.072 0.01% 0.080 0.01% 0.086 0.01% 0.089 0.01% 0.104 0.01% 0.091 0.01% 0.099 0.01% 8.88%
CFO - Shares - Amount $4.544 $5.776 $7.311 $9.790 $10.447 $10.711 $7.047 $7.394
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.018 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $1.852 $0.000 $0.000
Fong, Ivan K. 0.038 0.00% 0.041 0.00% 8.18%
Officer - Shares - Amount $2.932 $3.056
Options - percentage 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000
Coyle, Michael J 0.01% 0.150 0.01% 0.161 0.01% 0.205 0.02% 0.193 0.01% 0.195 0.01% 0.195 0.01% 0.195 0.01% Reported last Nov 2020
Officer - Shares - Amount $7.155 $10.672 $12.986 $18.604 $21.938 $22.833 $20.146 $15.136
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Arnold, Craig 0.031 0.00% 0.032 0.00% 0.033 0.00% 0.034 0.00% 0.034 0.00% 0.00%
Director - Shares - Amount $3.474 $3.750 $3.409 $2.675 $2.578
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000
Anderson Richard H 0.00% 0.072 0.01% 0.079 0.01% 0.085 0.01% 0.097 0.01% 0.109 0.01% 0.110 0.01% 0.117 0.01% 0.117 0.01% 0.00%
Director - Shares - Amount $4.642 $5.096 $6.397 $7.731 $11.029 $12.763 $11.414 $9.129 $8.798
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Ishrak Omar 0.04% 0.566 0.04% 0.540 0.04% 0.674 0.05% 0.616 0.05% 0.000 0.00% Was Chairman & CEO
Chairman -  Shares - Amount $40.523 $40.310 $43.628 $61.308 $69.922 $0.000 until 2020
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Last Update Aug 2020
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Chairman - See above CEO
Increase in O/S Shares 1.20% 15.000 1.07% 13.000 0.95% 10.000 0.74% 18.000 1.34% 12.000 0.89% 8.000 0.60% 7.000 0.52% 6.000 0.45% Stock and EPSS
due to SO $1,227.400 $1,153.800 $925.990 $807.500 $1,637.280 $1,361.400 $937.120 $724.150 $466.320 Repurchaes same as options
Book Value $1,088.000 $491.000 $428.000 $329.000 $923.000 $1,228.000 $382.000 $688.000 $591.000
Insider Buying $0.000 $0.000 -$1.644 -$0.249 -$2.267 -$2.063 -$0.500 -$0.517 $0.000
Insider Selling $8.732 $17.429 $25.303 $38.918 $20.273 $20.346 $33.223 $1.518 $2.436
Net Insider Selling $8.732 $17.429 $23.659 $38.669 $18.005 $18.282 $32.723 $1.001 $2.436
% of Market Cap 0.008% 0.02% 0.02% 0.03% 0.01% 0.01% 0.02% 0.00% 0.00%
Directors 13 12 12 11 13 12 12 11
Women 31% 4 31% 3 25% 3 25% 3 27% 3 23% 3 25% 4 33% 4 36%
Minorities 15% 2 15% 2 17% 3 25% 2 18% 3 23% 2 17% 2 17% 2 18%
South Asian male 2 black males 2 black males
2 black males
# Institutions/Holdings 83.05% 1,382 85.10% 1,370 82.88% 1,492 82.88% 1,705 82.88% 20 45.74% 20 48.09%
Total Shares Held 83.99% 1,176.006 85.88% 1,122.705 82.90% 1,108.008 82.64% 1,112.295 82.94% 615.613 45.76% 639.852 48.08%
Increase/Decrease 0.0% 9.977 0.9% -18.978 -1.7% -0.656 -0.1% 23.424 2.2% -0.144 0.0% -1.435 -0.2%
Starting No. of Shares Nasdaq 1,166.029 Nasdaq 1,141.683 Nasdaq 1,108.664 Nasdaq 1,088.871 Nasdaq 615.757 MS Top 20 641.287 MS Top 20
Copyright © 2008 Website of SPBrunner. All rights reserved.