This report should not be construed as providing investment advice. It is for educational purposes only.  Before making any investment decision, you should always do your own research or consult a investment professional. Estimates Estimates Estimates
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Q1 2024
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Jul 2024
Medtronic PLC NYSE: MDT https://www.medtronic.com/us-en/index.html Fiscal Yr: Apr 30
Year 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 4/30/27 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.9886 1.0073 1.0957 1.2119 1.2549 1.2549 1.2545 1.3423 1.3910 1.2732 1.2285 1.3578 1.3226 1.3499 1.3499 1.3499
split
$24,767 <-12 mths -23.47%
Revenue* $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,364 $33,582 $35,174 $36,902 90.32% <-Total Growth 10 Revenue US$
Increase 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.64% 3.76% 4.74% 4.91% 6.65% <-IRR #YR-> 10 Revenue 90.32% US$
5 year Running Average $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,861 $31,795 $32,807 $33,850 1.16% <-IRR #YR-> 5 Revenue 5.91% US$
Revenue per Share $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.32 $25.23 $26.43 $27.73 6.59% <-IRR #YR-> 10 5 yr Running Average 89.27% US$
Increase 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.64% 3.76% 4.74% 4.91% 2.07% <-IRR #YR-> 5 5 yr Running Average 10.76% US$
5 year Running Average $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.07 $23.81 $24.60 $25.44 3.63% <-IRR #YR-> 10 Revenue per Share 42.87% US$
Net profit Margin-Net Income/Sales 22.35% 20.90% 18.02% 13.20% 12.27% 13.56% 10.36% 15.16% 16.56% 11.97% 15.91% 12.03% 11.27% 15.31% 16.11% 16.50% 1.31% <-IRR #YR-> 5 Revenue per Share 6.70% US$
P/S (Price/Sales) Med 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.29 3.33 0.00 0.00 3.96% <-IRR #YR-> 10 5 yr Running Average 47.40% US$
P/S (Price/Sales) Close 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.30 3.46 3.31 3.15 2.60% <-IRR #YR-> 5 5 yr Running Average 13.69% US$
*Net Sales in M US$  P/S Med 20 yr  3.88 15 yr  3.74 10 yr  3.91 5 yr  4.50 -11.48% Diff M/C
NI/Sales 20 yr  16.21% 15.16% 12.74% 12.03%
-$17,005 $0 $0 $0 $0 $0 $0 $0 $0 $0 $32,364
-$30,557 $0 $0 $0 $0 $32,364
-$16,306 $0 $0 $0 $0 $0 $0 $0 $0 $0 $30,861
-$27,863 $0 $0 $0 $0 $30,861
-$17.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24.32
-$22.79 $0.00 $0.00 $0.00 $0.00 $24.32
-$15.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.07
-$20.29 $0.00 $0.00 $0.00 $0.00 $23.07
$6,914 <-12 mths -0.06%
$7.63 <-12 mths 46.73%
Non-GAAP Profit US$ $3,617 $3,467 $4,098 $4,744 $6,228 $6,395 $6,530 $6,206 $6,206 $6,005 $7,505 $7,045 $6,918
Basic $3.43 $3.40 $4.09 $4.33 $4.42 $4.64 $4.81 $4.61 $4.63 $4.47 $5.59 $5.30 $5.21 27.41% <-Total Growth 10 AEPS
AEPS* Dilued $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.20 $5.45 $5.85 $6.31 28.62% <-Total Growth 10 AEPS
Increase 19.23% -1.17% 19.97% 5.81% 2.10% 5.32% 3.70% -3.77% 0.00% -3.27% 25.00% -4.68% -1.70% 4.81% 7.34% 7.86% 10 0 10 Years of Data, EPS P or N 100.00%
5 year Running Average $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.01 $5.19 $5.47 $5.62 2.55% <-IRR #YR-> 10 AEPS 28.62%
AEPS Yield 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.48% 6.24% 6.70% 7.22% 2.53% <-IRR #YR-> 5 AEPS 13.29%
Payout Ratio 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.08% 51.38% 47.86% 44.37% 4.29% <-IRR #YR-> 10 5 yr Running Average 52.19%
5 year Running Average 30.76% 31.81% 29.57% 29.40% 30.07% 31.85% 33.40% 36.57% 40.28% 43.77% 45.37% 47.94% 49.84% 50.71% 49.83% 49.62% 2.09% <-IRR #YR-> 5 5 yr Running Average 10.90%
Price/AEPS Median 10.42 12.41 13.48 16.13 16.52 18.23 17.35 19.54 21.16 24.78 23.15 17.24 15.40 15.40 0.00 0.00 17.79 <-Median-> 10 Price/AEPS Median
Price/AEPS High 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.44 16.70 0.00 0.00 19.71 <-Median-> 10 Price/AEPS High
Price/AEPS Low 8.92 10.65 11.54 13.74 14.77 17.13 16.01 17.41 15.89 20.01 21.95 14.39 13.35 14.11 0.00 0.00 15.95 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 11.20 13.85 14.55 17.40 18.12 18.06 16.80 19.35 21.27 29.49 18.80 17.19 15.43 16.03 14.93 13.84 18.09 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 13.36 13.69 17.45 18.41 18.50 19.02 17.42 18.62 21.27 28.52 23.50 16.39 15.17 16.80 16.03 14.93 18.56 <-Median-> 10 Trailing P/AEPS Close
Median Values DPR 10 Yrs 44.49% 5 Yrs   51.42% P/CF 5 Yrs   in order 21.16 24.35 15.89 18.80 -24.24% Diff M/C DPR 75% to 95% best
* Non-GAAP Earnings per Share
-$4.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.20
-$4.59 $0.00 $0.00 $0.00 $0.00 $5.20
-$3.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.01
-$4.52 $0.00 $0.00 $0.00 $0.00 $5.01
$2.97 <-12 mths 7.61%
EPS Basic $3.43 $3.40 $3.06 $2.44 $2.51 $2.92 $2.29 $3.44 $3.57 $2.68 $3.75 $2.83 $2.77 -9.48% <-Total Growth 10 EPS Basic US$
Split ' 97
Split ' 99
EPS Diluted* $3.41 $3.37 $3.02 $2.41 $2.48 $2.89 $2.27 $3.41 $3.54 $2.66 $3.73 $2.82 $2.76 $4.02 $4.43 $4.80 -8.61% <-Total Growth 10 EPS Diluted US$
Increase 19.23% -1.17% -10.39% -20.20% 2.90% 16.53% -21.45% 50.22% 3.81% -24.86% 40.23% -24.40% -2.13% 45.51% 10.21% 8.43% 10 0 10 Years of Data, EPS P or N US$
Earnings Yield 8.9% 7.2% 5.1% 3.2% 3.1% 3.5% 2.8% 3.8% 3.6% 2.0% 3.6% 3.1% 3.4% 4.6% 5.1% 5.5% -0.90% <-IRR #YR-> 10 Earnings per Share -8.61% US$
5 year Running Average $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.10 $3.20 $3.55 $3.76 -4.14% <-IRR #YR-> 5 Earnings per Share -19.06% US$
10 year Running Average $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.90 $3.06 $3.25 $3.44 0.04% <-IRR #YR-> 10 5 yr Running Average 0.39% US$
* Diluted ESP per share  P/S 10 yr  0.03 5 yr  0.03 2.88% <-IRR #YR-> 5 5 yr Running Average 15.23% US$
-$3.37 -$3.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.76
-$3.41 $0.00 $0.00 $0.00 $0.00 $2.76
-$2.87 -$3.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.10
-$2.69 $0.00 $0.00 $0.00 $0.00 $3.10
Dividend* $2.81 $2.91 $3.00 Estimates Dividend* US$
Increase 1.70% 3.78% 2.88% Estimates Increase US$
Payout Ratio EPS 69.90% 65.82% 62.45% 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 <-Total Growth 10 Special Dividends US$ US$
Split ' 99 US$
Dividend* $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.80 $2.80 $2.80 146.43% <-Total Growth 10 Dividends US$
Increase 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% 1.45% 0.00% 0.00% 34 0 34 Years of data, Count P, N 100.00% US$
Average Increases 5 Year Running 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.38% 3.90% 2.17% 10.04% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $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.72 $2.78 157.32% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 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.45% 3.34% 2.17% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 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% 3.08% 1.92% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 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.98% 3.64% 2.46% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 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.44% 3.21% 3.21% 3.21% 2.23% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 28.45% 30.86% 37.09% 50.62% 61.29% 59.52% 81.06% 58.65% 61.02% 87.22% 67.56% 96.45% 100.00% 69.72% 63.26% 58.35% 64.43% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 30.45% 31.20% 31.39% 34.84% 39.96% 46.72% 56.77% 61.66% 63.33% 67.98% 69.44% 72.52% 80.46% 82.07% 76.61% 73.75% 62.50% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 22.51% 21.64% 22.56% 35.38% 40.75% 34.24% 53.20% 38.27% 40.04% 49.86% 46.15% 59.94% 54.12% 44.60% 40.40% 33.98% 43.45% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 21.72% 22.58% 22.73% 24.97% 27.61% 30.13% 35.98% 39.74% 40.47% 42.26% 44.81% 46.38% 49.63% 40.49% 41.98% 42.84% 40.10% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 22.60% 23.06% 23.60% 51.96% 33.72% 34.94% 51.30% 33.16% 40.38% 44.82% 41.17% 51.66% 50.52% 44.60% 40.40% 33.98% 43.00% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 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.59% 46.36% 45.25% 43.14% 38.33% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 10 Yr Med 10 Yr Cl 2.17% 2.23% 5 Yr Med 5 Yr Cl 2.22% 2.41% 5 Yr Med Payout 87.22% 49.86% 44.82% 6.65% <-IRR #YR-> 5 Dividends 38.00% US$
* Dividends per share  10 Yr Med and Cur. 47.99% 43.58% 5 Yr Med and Cur. 44.10% 32.73% Last Div Inc ---> $0.690 $0.700 1.45% 9.44% <-IRR #YR-> 10 Dividends 146.43% US$
Dividends Growth 15 9.07% <-IRR #YR-> 15 Dividends 268.00% US$
Dividends Growth 20 11.92% <-IRR #YR-> 20 Dividends 851.72% US$
Dividends Growth 25 13.00% <-IRR #YR-> 25 Dividends 2023.08% US$
Dividends Growth 30 14.93% <-IRR #YR-> 30 Dividends 6394.12% US$
Dividends Growth 35 15.19% <-IRR #YR-> 34 Dividends
Dividends Growth 5 -$2.00 $0.00 $0.00 $0.00 $0.00 $2.76 Dividends Growth 5
Dividends Growth 10 -$1.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.76 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.76 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.76 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.76 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.76 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.76 Dividends Growth 35
Historical Dividends Historical High Div 3.14% Low Div 0.36% 10 Yr High 3.93% 10 Yr Low 1.56% Med Div 0.96% Close Div 1.01% 2.17% 47.70% Historical Dividends US$
High/Ave/Median Values Curr diff Cheap 2.07%     790.31% Exp. -18.44% 105.46% Cheap 233.87% Cheap 216.79% Since 2009 High/Ave/Median  US$
Future Dividend Yield Div Yield 4.42% earning in 5 Years at IRR of 6.65% Div Inc. 38.00% Future Dividend Yield US$
Future Dividend Yield Div Yield 6.10% earning in 10 Years at IRR of 6.65% Div Inc. 90.44% Future Dividend Yield US$
Future Dividend Yield Div Yield 8.42% earning in 15 Years at IRR of 6.65% Div Inc. 162.81% Future Dividend Yield US$
Future Dividend Paid Div Paid $3.86 earning in 5 Years at IRR of 6.65% Div Inc. 38.00% Future Dividend Paid
Future Dividend Paid Div Paid $5.33 earning in 10 Years at IRR of 6.65% Div Inc. 90.44% Future Dividend Paid
Future Dividend Paid Div Paid $7.36 earning in 15 Years at IRR of 6.65% Div Inc. 162.81% Future Dividend Paid
Dividend Covering Cost Total Div $15.99 over 5 Years at IRR of 6.65% Div Cov. 18.30% Dividend Covering Cost
Dividend Covering Cost Total Div $34.19 over 10 Years at IRR of 6.65% Div Cov. 39.14% Dividend Covering Cost
Dividend Covering Cost Total Div $59.32 over 15 Years at IRR of 6.65% Div Cov. 67.90% Dividend Covering Cost
Yield if held 5 years 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.88% 2.54% 2.18% 3.25% <-Median-> 10 Paid Median Price US$
Yield if held 10 years 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.06% 3.88% 3.34% 5.01% <-Median-> 10 Paid Median Price US$
Yield if held 15 years 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.20% 7.66% 7.88% 4.26% <-Median-> 10 Paid Median Price US$
Yield if held 20 years 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.51% 5.16% 5.76% 6.24% <-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.25% 5.44% 6.21% 32.60% <-Median-> 10 Paid Median Price US$
Yield if held 30 years 118.03% 51.90% 57.14% 55.91% 61.47% 40.43% 23.24% 18.94% 57.14% <-Median-> 5 Paid Median Price US$
Yield if held 35 years 153.01% 62.64% 63.49% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 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.51% 12.36% 10.80% 14.04% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 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.40% 32.77% 29.47% 34.89% <-Median-> 10 Paid Median Price US$
Cost covered if held 15 years 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.99% 80.77% 88.21% 33.87% <-Median-> 10 Paid Median Price US$
Cost covered if held 20 years 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% 60.02% 60.63% 72.62% 59.95% <-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% 71.05% 66.91% 81.99% 269.92% <-Median-> 10 Paid Median Price US$
Cost covered if held 30 years 1062.60% 486.33% 549.41% 553.22% 659.94% 467.58% 291.41% 255.80% 553.22% <-Median-> 5 Paid Median Price US$
Cost covered if held 35 years 1779.54% 790.58% 864.15% #NUM! <-Median-> 0 Paid Median Price US$
Revenue Growth  $30,557 $28,913 $30,117 $31,686 $31,227 $32,364 $24,767 <-12 mths -23.47% 5.91% <-Total Growth 5 Revenue Growth  5.91% 1.16%
AEPS Growth $4.59 $4.59 $4.44 $5.55 $5.29 $5.20 $7.63 <-12 mths 46.73% 13.29% <-Total Growth 5 AEPS Growth 13.29% 2.53%
Net Income Growth $4,631 $4,789 $3,606 $5,040 $3,758 $3,648 $3,899 <-12 mths 6.88% -21.23% <-Total Growth 5 Net Income Growth -21.23% -4.66%
Cash Flow Growth $7,007 $7,234 $6,240 $7,346 $6,039 $6,787 $6,808 <-12 mths 0.31% -3.14% <-Total Growth 5 Cash Flow Growth -3.14% -0.64%
Dividend Growth $2.00 $2.16 $2.32 $2.52 $2.72 $2.76 $2.80 <-12 mths 1.45% 38.00% <-Total Growth 5 Dividend Growth 38.00% 6.65%
Stock Price Growth $88.81 $97.63 $130.92 $104.36 $90.95 $80.24 $87.36 <-12 mths 8.87% -9.65% <-Total Growth 5 Stock Price Growth -9.65% -2.01%
Revenue Growth  $17,005 $20,261 $28,833 $29,710 $29,953 $30,557 $28,913 $30,117 $31,686 $31,227 $32,364 $33,582 <-this year 3.76% 90.32% <-Total Growth 10 Revenue Growth  90.32% 6.65%
AEPS Growth $4.04 $4.28 $4.37 $4.60 $4.77 $4.59 $4.59 $4.44 $5.55 $5.29 $5.20 $5.45 <-this year 4.81% 28.62% <-Total Growth 10 AEPS Growth 28.62% 2.55%
Net Income Growth $3,065 $2,675 $3,538 $4,028 $3,104 $4,631 $4,789 $3,606 $5,040 $3,758 $3,648 $5,143 <-this year 40.98% 19.02% <-Total Growth 10 Net Income Growth 19.02% 1.76%
Cash Flow Growth $4,959 $4,902 $5,218 $6,880 $4,684 $7,007 $7,234 $6,240 $7,346 $6,039 $6,787 $8,355 <-this year 23.10% 36.86% <-Total Growth 10 Cash Flow Growth 36.86% 3.19%
Dividend Growth $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $2.76 $2.81 <-this year 1.70% 146.43% <-Total Growth 10 Dividend Growth 146.43% 9.44%
Stock Price Growth $58.82 $74.45 $79.15 $83.09 $80.13 $88.81 $97.63 $130.92 $104.36 $90.95 $80.24 $95.01 <-this year 18.41% 36.42% <-Total Growth 10 Stock Price Growth 36.42% 3.15%
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.96 $1.05 $1.23 $1.48 $1.91 $2.16 $2.31 $2.68 $3.00 $2.95 $3.10 $3.69 $3.65 $3.78 $3.78 197.46% <-Total Growth 10 Dividends CDN$
Increase 12.85% 9.24% 17.15% 20.48% 29.01% 13.16% 6.94% 16.30% 11.92% -1.69% 4.81% 19.30% -1.16% 3.54% 0.00% 11.52% <-IRR #YR-> 10 Dividends CDN$
Dividend Yield 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.44% 3.21% 3.21% 6.34% <-IRR #YR-> 5 Dividends CDN$
Dividends per share in CDN$ funds Yield  5yr Med. 2.41% Curr diff 42.45%
-$1.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.65
-$2.68 $0.00 $0.00 $0.00 $0.00 $3.65
Future Dividend Yield Div Yd 4.42% earning in 5 Years at IRR of 6.65% Div Inc. 38.00% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 6.10% earning in 10 Years at IRR of 6.65% Div Inc. 90.44% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 8.42% earning in 15 Years at IRR of 6.65% Div Inc. 162.81% Future Dividend Yield CDN$
Close CDN$ Dec Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25 Dec-26 34.00 <Count Years> Month, Year
Price Close $37.82 $41.32 $62.88 $87.50 $96.53 $89.39 $101.30 $122.10 $157.81 $149.14 $127.09 $105.53 $108.96 $117.93 $117.93 $117.93
Close CDN$ April $37.77 $47.02 $64.45 $90.23 $99.33 $104.27 $100.52 $119.21 $135.80 $166.69 $128.21 $123.49 $106.13 $117.93 $117.93 $117.93 5.11% <-IRR #YR-> 10 Stock Price CDN$
5 yr Period ending 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 04/30/27 -2.30% <-IRR #YR-> 5 Stock Price CDN$
5 year IRR Tot. Ret, -6.73% 0.56% 13.18% 17.37% 22.49% 25.19% 19.19% 15.60% 10.76% 13.04% -66.67% -52.31% 0.58% 8.33% <-IRR #YR-> 10 Price & Dividend CDN$
Median Div Yield Beg. of period 0.83% 1.01% 2.34% 1.88% 2.15% 2.54% 2.23% 1.90% 1.64% 1.92% 2.07% 2.30% 2.25% 0.58% <-IRR #YR-> 4 Price & Dividend CDN$
P/S Beginning of period 4.92 4.11 2.45 3.03 2.81 2.45 2.86 3.46 5.22 3.84 3.83 3.62 3.90 10 <-Count-> Neg years
P/E Beginning of Period 22.05 25.78 16.28 15.76 12.97 11.22 14.35 19.00 29.96 31.02 24.65 35.57 26.67 13 <-Count-> Total Return under 8% CDN$
30 <-Count-> Total numbe of years
Median Dividend Yield end of period 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.44% CDN$
P/S End of period 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.30 CDN$
P/E End of Period 11.22 14.35 19.00 29.96 31.02 24.65 35.57 26.67 32.05 44.04 27.73 27.56 29.85 CDN$
As a Canadian, would I have made money on this stock? Looking at 5 year periods to, including Dividends D.  per yr 3.22% 2.88% % Tot Ret 38.62% 496.80% CDN$
-$64.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $106.13 04/30/24 Price & Dividend CDN$
-$119.21 $0.00 $0.00 $0.00 $0.00 $106.13 04/30/24 Price & Dividend CDN$
-$64.45 $1.48 $1.91 $2.16 $2.31 $2.68 $3.00 $2.95 $3.10 $3.69 $109.78 04/30/24 Price & Dividend CDN$
-$119.21 $3.00 $2.95 $3.10 $3.69 $109.78 04/30/24 Price & Dividend CDN$
-$100.52 $2.68 $3.00 $2.95 $3.10 $127.19 04/30/23 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 04/30/18 Price & Dividend CDN$
-$37.77 $1.05 $1.23 $1.48 $1.91 $106.43 04/30/17 Price & Dividend CDN$
$0.96 $1.05 $1.23 $1.48 $101.23 04/30/16 Price & Dividend CDN$
$0.96 $1.05 $1.23 $91.70 05/01/15 Price & Dividend CDN$
$0.96 $1.05 $65.68 05/01/14 Price & Dividend CDN$
$0.96 $48.07 04/30/13 Price & Dividend CDN$
$38.72 04/30/12 Price & Dividend CDN$
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$ $23.66 $30.52 $34.53 $36.93 $42.95 $48.07 $47.26 $49.53 $59.09 $58.41 $60.48 $60.48 $0.00 $430.96 No of Years 10 Total Divs 12/31/13
Paid  $1,006.12 $1,399.99 $1,544.43 $1,430.18 $1,620.81 $1,953.53 $2,524.94 $2,386.28 $2,033.41 $1,688.45 $1,743.29 $1,886.84 $1,886.84 $1,886.84 $1,743.29 No of Years 10 Worth $62.88 15.90
Total $2,174.25
Dividends on Shares US$ $21.96 $27.36 $30.96 $33.12 $36.00 $38.88 $41.76 $45.36 $48.96 $49.68 $50.40 $50.40 $50.40 $374.04 No of Years 10 Total Divs 12/31/13
Paid  $1,033.02 $1,299.60 $1,384.56 $1,282.14 $1,453.50 $1,637.28 $2,042.10 $2,108.52 $1,862.10 $1,398.96 $1,482.84 $1,572.48 $1,572.48 $1,572.48 $1,482.84 No of Years 10 Worth $57.39 17.42
Total $1,856.88
Graham No. US$ AEPS $35.58 $37.33 $42.08 $60.03 $60.47 $61.65 $63.40 $62.12 $62.51 $61.90 $69.84 $67.86 $66.44 $66.47 $68.86 $71.52 57.91% <-Total Growth 10 Graham Price AEPS US$
Price/GP Ratio Med 1.00 1.12 1.29 1.15 1.19 1.36 1.31 1.44 1.55 1.78 1.84 1.34 1.20 1.26 1.35 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 1.14 1.28 1.48 1.32 1.32 1.44 1.41 1.60 1.94 2.12 1.94 1.57 1.36 1.37 1.50 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 0.85 0.96 1.11 0.98 1.07 1.28 1.20 1.29 1.17 1.44 1.74 1.12 1.04 1.16 1.19 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 1.07 1.25 1.40 1.24 1.31 1.35 1.26 1.43 1.56 2.12 1.49 1.34 1.21 1.31 1.27 1.22 1.34 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close 7.36% 25.05% 39.79% 24.02% 30.88% 34.77% 26.39% 42.97% 56.19% 111.52% 49.43% 34.03% 20.77% 31.43% 26.86% 22.15% 34.40% <-Median-> 10 Graham Price US$
Graham No. US$ EPS $35.58 $37.33 $36.37 $45.06 $45.57 $48.87 $43.74 $53.54 $54.89 $47.91 $57.25 $49.55 $48.41 $57.06 $59.90 $62.37 33.11% <-Total Growth 10 Graham Price EPS US$
Price/GP Ratio Med 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.65 1.47 1.74 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio High 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.87 1.59 1.96 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Low 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.43 1.35 1.51 <-Median-> 10 Price/GP Ratio US$
Price/GP Ratio Close 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.66 1.53 1.46 1.40 1.76 <-Median-> 10 Price/GP Ratio US$
Prem/Disc Close 7.36% 25.05% 61.75% 65.23% 73.69% 70.03% 83.21% 65.87% 77.85% 173.28% 82.28% 83.57% 65.76% 53.11% 45.85% 40.06% 75.77% <-Median-> 10 Graham Price US$
Month, Year US$ Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25 Dec-26 34.00 <Count Years> Month, Year US$
Price Close $38.25 $41.02 $57.39 $72.20 $76.92 $71.23 $80.75 $90.96 $113.45 $117.14 $103.45 $77.72 $82.38 $87.36 $87.36 $87.36 43.54% <-Total Growth 10 Stock Price US$
Increase 3.13% 7.24% 39.91% 25.81% 6.54% -7.40% 13.37% 12.64% 24.73% 3.25% -11.69% -24.87% 6.00% 6.05% 0.00% 0.00% 29.16 <-Median-> 10 CAPE (10 Yr P/E) US$
P/E 11.22 14.35 19.00 29.96 31.02 24.65 35.57 26.67 32.05 44.04 27.73 27.56 29.85 21.75 19.74 18.20 -1.96% <-IRR #YR-> 5 Stock Price -9.43% US$
Trailing P/E 13.37 12.03 17.03 23.91 31.92 28.72 27.94 40.07 33.27 33.09 38.89 20.84 29.21 31.65 21.75 19.74 3.68% <-IRR #YR-> 10 Stock Price 43.54% US$
CAPE (10 Yr P/E) $17.53 $17.17 $22.67 $27.52 $28.88 $26.27 $29.44 $31.46 $38.25 $39.76 $34.74 $26.59 $28.44 $28.57 $26.86 $25.37 0.89% <-IRR #YR-> 5 Price & Dividend 4.29% US$
Median 10, 5 Yrs D.  per yr 2.99% 2.85% % Tot Ret 44.78% 321.05% T P/E 30.56 33.09 P/E:  29.90 29.85 6.67% <-IRR #YR-> 10 Price & Dividend 79.75% US$
Price 15 D.  per yr 3.18% % Tot Ret 32.39% CAPE Diff -25.41% 6.64% <-IRR #YR-> 15 Stock Price 162.19% US$
Price  20 D.  per yr 1.98% % Tot Ret 42.62% 2.67% <-IRR #YR-> 20 Stock Price 69.47% US$
Price  25 D.  per yr 1.74% % Tot Ret 34.78% 3.26% <-IRR #YR-> 25 Stock Price 122.98% US$
Price  30 D.  per yr 3.26% % Tot Ret 23.50% 10.60% <-IRR #YR-> 30 Stock Price US$
Price  35 D.  per yr 3.80% % Tot Ret 23.28% 12.50% <-IRR #YR-> 34 Stock Price
Price & Dividend 15 9.82% <-IRR #YR-> 15 Price & Dividend 243.76% US$
Price & Dividend 20 4.66% <-IRR #YR-> 20 Price & Dividend 127.18% US$
Price & Dividend 25 5.00% <-IRR #YR-> 25 Price & Dividend 201.96% US$
Price & Dividend 30 13.86% <-IRR #YR-> 30 Price & Dividend US$
Price & Dividend 35 16.30% <-IRR #YR-> 34 Stock Price US$
Price  5 -$90.96 $0.00 $0.00 $0.00 $0.00 $82.38 Price  5
Price 10 -$57.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $82.38 Price 10
Price & Dividend 5 -$90.96 $2.16 $2.32 $2.52 $2.72 $85.14 Price & Dividend 5
Price & Dividend 10 -$57.39 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $85.14 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 $82.38 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 $82.38 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 $82.38 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 $82.38 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 $82.38 Price  35
Price & Dividend 15 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $85.14 Price & Dividend 15
Price & Dividend 20 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $85.14 Price & Dividend 20
Price & Dividend 25 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $85.14 Price & Dividend 25
Price & Dividend 30 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $85.14 Price & Dividend 30
Price & Dividend 35 $0.97 $1.04 $1.12 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $85.14 Price & Dividend 35
Month, Year 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 Apr-27 34.00 <Count Years> Month, Year
Price Close $38.20 $46.68 $58.82 $74.45 $79.15 $83.09 $80.13 $88.81 $97.63 $130.92 $104.36 $90.95 $80.24 $87.36 $87.36 $87.36 36.42% <-Total Growth 10 Stock Price US$
Increase -8.74% 22.20% 26.01% 26.57% 6.31% 4.98% -3.56% 10.83% 9.93% 34.10% -20.29% -12.85% -11.78% 8.87% 0.00% 0.00% 3.15% <-IRR #YR-> 10 Stock Price 36.42% US$
P/E 11.20 13.85 19.48 30.89 31.92 28.75 35.30 26.04 27.58 49.22 27.98 32.25 29.07 21.75 19.74 18.20 -2.01% <-IRR #YR-> 5 Stock Price -9.65% US$
Trailing P/E 13.36 13.69 17.45 24.65 32.84 33.50 27.73 39.12 28.63 36.98 39.23 24.38 28.45 31.65 21.75 19.74 6.14% <-IRR #YR-> 10 Price & Dividend 4.40% US$
Median 10, 5 Yrs D.  per yr 2.98% 2.92% % Tot Ret 94.57% -145.40% T P/E 0.06 -0.12 P/E:  85.95 97.63 0.91% <-IRR #YR-> 5 Price & Dividend 71.74% US$
Close US$ $38.20 $46.68 $58.82 $74.45 $79.15 $83.09 $80.13 $88.81 $97.63 $130.92 $104.36 $90.95 $80.24 $87.36 $87.36 $87.36 5 <-Count-> Neg years US$
5 yr Period ending 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 04/30/27 14 <-Count-> Total Return under 8% US$
5 year IRR Tot. Ret, -4.59% 0.72% 15.32% 13.18% 15.74% 19.31% 13.93% 10.95% 7.78% 12.65% 6.54% -52.03% 0.91% 30 <-Count-> Total numbe of years US$
-$58.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $80.24 04/30/24 US$
-$88.81 $0.00 $0.00 $0.00 $0.00 $80.24 04/30/24 US$
-$58.82 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $83.00 04/30/24 US$
-$88.81 $2.16 $2.32 $2.52 $2.72 $83.00 04/30/24 US$
-$80.13 $2.00 $2.16 $2.32 $2.52 $90.95 04/30/23 Price & Dividend 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 04/30/18 Price & Dividend US$
-$38.20 $1.04 $1.12 $1.22 $1.52 $84.81 04/30/17 Price & Dividend US$
$0.97 $1.04 $1.12 $1.22 $80.67 04/30/16 Price & Dividend US$
$0.97 $1.04 $1.12 $75.67 05/01/15 Price & Dividend US$
$0.97 $1.04 $59.94 05/01/14 Price & Dividend US$
$0.97 $47.72 04/30/13 Price & Dividend US$
$39.17 04/30/12 Price & Dividend US$
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 $35.53 $41.81 $54.48 $69.01 $72.15 $83.87 $82.78 $89.71 $97.11 $110.03 $128.49 $91.20 $80.06 $83.94 46.94% <-Total Growth 10 Stock Price US$
Increase -2.75% 17.66% 30.32% 26.67% 4.55% 16.24% -1.31% 8.37% 8.25% 13.30% 16.77% -29.02% -12.22% 4.85% 3.92% <-IRR #YR-> 10 Stock Price 46.94% US$
P/E 10.42 12.41 18.04 28.63 29.09 29.02 36.46 26.31 27.43 41.36 34.45 32.34 29.01 20.90 -2.25% <-IRR #YR-> 5 Stock Price -10.76% US$
Trailing P/E 12.42 12.26 16.17 22.85 29.94 33.82 28.64 39.52 28.48 31.08 48.30 24.45 28.39 30.41 7.03% <-IRR #YR-> 10 Price & Dividend 3.15% US$
P/E on Run. 5 yr Ave 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.81 26.25 0.66% <-IRR #YR-> 5 Price & Dividend 85.09% US$
P/E on Run. 10 yr Ave 16.28 17.50 21.53 26.30 27.09 30.94 30.18 31.03 32.74 37.35 43.14 31.20 27.63 27.45 27.43 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 3.11% 2.91% % Tot Ret 44.21% 442.71% T P/E 29.29 28.48 P/E:  29.06 32.34
-$54.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $80.06
-$89.71 $0.00 $0.00 $0.00 $0.00 $80.06
-$54.48 $1.22 $1.52 $1.72 $1.84 $2.00 $2.16 $2.32 $2.52 $2.72 $82.82
-$89.71 $2.16 $2.32 $2.52 $2.72 $82.82
High Months 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 Sep 24
Price Hi $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 $90.99 45.53% <-Total Growth 10 Stock Price US$
Increase -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% 0.34% 3.82% <-IRR #YR-> 10 Stock Price 45.53% US$
P/E 11.92 14.16 20.63 32.88 32.17 30.77 39.30 29.18 34.27 49.32 36.24 37.68 32.86 22.66 -1.84% <-IRR #YR-> 5 Stock Price -8.86% US$
Trailing P/E 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.97 32.17 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 34.34 35.57 P/E:  33.57 36.24 46.20 P/E Ratio Historical High US$
-$62.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $90.68
-$99.49 $0.00 $0.00 $0.00 $0.00 $90.68
Low Months Aug 11 Jun 12 May 13 May 14 Sep 15 May 16 Mar 18 May 18 Mar 20 Jun 20 Jun 21 Nov 22 Oct 23 Jul 24
Price Low $30.41 $35.89 $46.65 $58.77 $64.52 $78.82 $76.35 $79.92 $72.92 $88.86 $121.80 $76.13 $69.43 $76.88 48.83% <-Total Growth 10 Stock Price US$
Increase -2.56% 18.02% 29.98% 25.98% 9.78% 22.16% -3.13% 4.68% -8.76% 21.86% 37.07% -37.50% -8.80% 10.73% 4.06% <-IRR #YR-> 10 Stock Price 48.83% US$
P/E 8.92 10.65 15.45 24.39 26.02 27.27 33.63 23.44 20.60 33.41 32.65 27.00 25.16 19.14 -2.77% <-IRR #YR-> 5 Stock Price -13.13% US$
Trailing P/E 10.63 10.52 13.84 19.46 26.77 31.78 26.42 35.21 21.38 25.10 45.79 20.41 24.62 27.86 23.47 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 25.76 24.62 P/E:  26.51 27.00 14.61 P/E Ratio Historical Low US$
-$46.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $69.43
-$79.92 $0.00 $0.00 $0.00 $0.00 $69.43
$5,145 <-12 mths -1.06%
Free Cash Flow MDT $4,563 $4,331 $4,172 $5,626 $3,616 $5,873 $6,021 $4,885 $5,978 $4,580 $5,200 13.96% <-Total Growth 10 Free Cash Flow MDT US$
Change -5.08% -3.67% 34.85% -35.73% 62.42% 2.52% -18.87% 22.37% -23.39% 13.54% Change US$
Free Cash Flow MS WSJ Mkt S $3,986 $4,495 $4,563 $4,331 $4,172 $5,626 $3,616 $5,873 $6,021 $4,885 $5,978 $4,580 $5,200 $5,736 $6,771 $7,454 13.96% <-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% 13.54% 10.31% 18.04% 10.09% -2.40% <-IRR #YR-> 5 Free Cash Flow MS -11.46% US$
FCF/CF from Op Ratio 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.77 0.69 0.73 0.68 1.32% <-IRR #YR-> 10 Free Cash Flow MS 13.96% 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,666 $3,726 $3,726 $3,726 227.65% <-Total Growth 10 Dividends paid US$
Percentage paid 51.27% 42.23% 68.97% 45.85% 48.07% 63.87% 56.59% 78.95% 70.50% 64.96% 55.03% 49.99% $0.57 <-Median-> 9 Percentage paid US$
5 Year Coverage 49.77% 52.18% 55.30% 57.45% 62.55% 66.38% 64.10% 62.07% 5 Year Coverage US$
Dividend Coverage Ratio 1.95 2.37 1.45 2.18 2.08 1.57 1.77 1.27 1.42 1.54 1.82 2.00 1.77 <-Median-> 9 Dividend Coverage Ratio US$
5 Year of Coverage 2.01 1.92 1.81 1.74 1.60 1.51 1.56 1.61 5 Year of Coverage US$
-$5,873 $0 $0 $0 $0 $5,200
-$4,563 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,200
Market Cap $39,621 $47,428 $58,761 $105,842 $110,732 $113,786 $108,514 $119,067 $130,929 $175,574 $140,406 $121,031 $106,784 $116,259 $116,259 $116,259 81.73% <-Total Growth 10 Market Cap US$
Diluted # of Shares in Million 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,330.2 1,296.5 31.24% <-Total Growth 10 Diluted US$
Change -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.20% -2.53% -0.33% <-Median-> 10 Change US$
Difference Diluted/Basic -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.2% -0.79% <-Median-> 10 Difference Diluted/Basic US$
Basic # of Shares in Millions 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,327.7 1,293.3 32.49% <-Total Growth 10 Average US$
Change -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.16% -2.59% -0.30% <-Median-> 10 Change US$
Difference Basic/Outstanding -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.2% 2.9% -0.08% <-Median-> 10 Difference Basic/Outstanding US$
$6,808 <-12 mths 0.31%
Split ' 97
Split ' 99
# of Share in Millions 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 1,331 2.91% <-IRR #YR-> 10 Shares 33.21% US$
Change -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.00% -0.15% <-IRR #YR-> 5 Shares -0.74% US$
CF fr Op $M $4,470 $4,883 $4,959 $4,902 $5,218 $6,880 $4,684 $7,007 $7,234 $6,240 $7,346 $6,039 $6,787 $8,355 $9,223 $10,966 36.86% <-Total Growth 10 Cash Flow US$
Increase 19.49% 9.24% 1.56% -1.15% 6.45% 31.85% -31.92% 49.59% 3.24% -13.74% 17.72% -17.79% 12.39% 23.10% 10.39% 18.90% SO Buy Backs Share Issue US$
5 year Running Average $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,729 $6,953 $7,550 $8,274 51.67% <-Total Growth 10 CF 5 Yr Running US$
CFPS $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.10 $6.28 $6.93 $8.24 2.74% <-Total Growth 10 Cash Flow per Share US$
Increase 23.28% 11.52% 3.29% -30.54% 8.17% 34.70% -31.15% 51.10% 3.21% -13.74% 17.35% -16.89% 12.38% 23.10% 10.39% 18.90% 3.19% <-IRR #YR-> 10 Cash Flow 36.86% US$
5 year Running Average $3.63 $3.97 $4.27 $4.20 $4.25 $4.39 $4.12 $4.18 $4.57 $4.75 $4.84 $5.05 $5.03 $6.48 $6.48 $6.48 -0.64% <-IRR #YR-> 5 Cash Flow -3.14% US$
P/CF on Med Price 8.24 8.70 10.98 20.01 19.34 16.69 23.93 17.16 18.00 23.65 23.53 20.10 15.70 13.37 0.00 0.00 0.27% <-IRR #YR-> 10 Cash Flow per Share 2.74% US$
P/CF on Closing Price 8.86 9.71 11.85 21.59 21.22 16.54 23.17 16.99 18.10 28.14 19.11 20.04 15.73 13.92 12.61 10.60 -0.49% <-IRR #YR-> 5 Cash Flow per Share -2.42% US$
-29.29% Diff M/C 1.65% <-IRR #YR-> 10 CFPS 5 yr Running 17.83% US$
$7,076 <-12 mths -2.68%
Excl.Working Capital CF -$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 $484.0 $0.0 $0.0 $0.0 3.78% <-IRR #YR-> 5 CFPS 5 yr Running 20.39% US$
CF fr Op $M WC $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,271 $8,355 $9,223 $10,966 53.36% <-Total Growth 10 Cash Flow less WC US$
Increase -6.33% 2.92% 3.47% -29.59% 88.95% 6.88% -27.95% 66.50% -11.30% -3.23% 18.64% -14.92% 3.78% 14.91% 10.39% 18.90% 4.37% <-IRR #YR-> 10 Cash Flow less WC 53.36% US$
5 year Running Average $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,325 $7,562 $8,018 $8,564 -2.10% <-IRR #YR-> 5 Cash Flow less WC -10.09% US$
CFPS Excl. WC $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.46 $6.28 $6.93 $8.24 5.03% <-IRR #YR-> 10 CF less WC 5 Yr Run 63.38% US$
Increase -3.36% 5.07% 5.23% -50.52% 92.00% 9.19% -27.14% 68.18% -11.33% -3.23% 18.26% -13.99% 3.78% 14.91% 10.39% 18.90% 4.54% <-IRR #YR-> 5 CF less WC 5 Yr Run 24.88% US$
5 year Running Average $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.47 $5.66 $6.01 $6.44 1.42% <-IRR #YR-> 10 CFPS - Less WC 15.13% US$
P/CF on Med Price 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.65 13.37 0.00 0.00 -1.96% <-IRR #YR-> 5 CFPS - Less WC -9.42% US$
P/CF on Closing Price 8.90 10.35 12.39 31.71 17.56 16.88 22.34 14.72 18.25 25.30 17.05 17.28 14.69 13.92 12.61 10.60 2.43% <-IRR #YR-> 10 CFPS 5 yr Running 27.12% 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 -21.55% Diff M/C 5.05% <-IRR #YR-> 5 CFPS 5 yr Running 27.93% US$
-999.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1,330.8 Shares
-1,340.7 0.0 0.0 0.0 0.0 1,330.8 Shares
-$4,959 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,787 Cash Flow
-$7,007 $0 $0 $0 $0 $6,787 Cash Flow
-$4.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.10 Cash Flow per Share
-$5.23 $0.00 $0.00 $0.00 $0.00 $5.10 Cash Flow per Share
-$4.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.03 CFPS 5 yr Running
-$4.18 $0.00 $0.00 $0.00 $0.00 $5.03 CFPS 5 yr Running
-$4,741 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,271 Cash Flow less WC
-$8,087 $0 $0 $0 $0 $7,271 Cash Flow less WC
-$4,483 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,325 CF less WC 5 Yr Run
-$5,866 $0 $0 $0 $0 $7,325 CF less WC 5 Yr Run
-$4.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.46 CFPS - Less WC
-$6.03 $0.00 $0.00 $0.00 $0.00 $5.46 CFPS - Less WC
-$4.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.47 CFPS 5 yr Running
-$4.28 $0.00 $0.00 $0.00 $0.00 $5.47 CFPS 5 yr Running
Accounts receivable, net -$70 -$413 -$435 -$75 -$275 -$581 $1,291 -$761 -$477 -$576 -$391
Inventories -$39 -$282 -$186 -$227 -$192 -$274 -$577 $78 -$560 -$939 -$139
Accounts payable and accrued liabilities -$117 $1,616 -$65 $356 $65 $399 -$44 $531 $213 $696 $391
Other operating assets and liabilities $444 $643 -$403 $85 $229 -$624 -$609 -$549 -$65 -$148 -$345
                     
Sum $218 $1,564 -$1,089 $139 -$173 -$1,080 $61 -$701 -$889 -$967 -$484
Google --> Morningstar $218 $1,564 -$1,089 $139 -$173 -$1,080 $61 -$701 -$888 -$967 -$484
Difference $0 $0 $0 $0 $0 $0 $0 $0 -$1 $0 $0
 Morningstar $218 $1,564 -$1,089 $139
Difference $0 $0 $0 $0
OPM 27.62% 29.43% 29.16% 24.19% 18.10% 23.16% 15.64% 22.93% 25.02% 20.72% 23.18% 19.34% 20.97% 24.88% -28.09% <-Total Growth 10 OPM US$
Increase 17.63% 6.57% -0.92% -17.03% -25.20% 27.96% -32.47% 46.64% 9.11% -17.19% 11.89% -16.58% 8.44% 18.64% Should increase  or be stable. US$
Diff from Ave 25.8% 34.1% 32.9% 10.2% -17.6% 5.5% -28.8% 4.5% 14.0% -5.6% 5.6% -11.9% -4.5% 13.3% 0.00 <-Median-> 10 OPM US$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 21.95% 5 Yrs 20.97% should be  zero, it is a   check on calculations US$
EBITDA $8,472 $8,096 $9,830 $9,294 $9,226 $9,709 $10,384 $11,085 EBITDA US$
Change -4.44% 21.42% -5.45% -0.73% 5.24% 6.95% 6.75% Change US$
Margin 29.30% 26.88% 31.02% 29.76% 28.51% 28.91% 29.52% 30.04% Margin US$
Long Term Debt $7,359 $3,891 $10,315 $33,752 $30,247 $25,921 $23,699 $24,486 $22,021 $26,378 $20,372 $24,344 $23,932 $26,312 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% -1.69% 9.94% -5.13% <-Median-> 10 Change US$
Debt/Market Cap Ratio 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.22 0.23 0.21 <-Median-> 10 % of Market C. US$
Assets/Current Liabilities Ratio 5.65 8.95 6.83 11.63 13.93 7.02 9.06 10.59 8.75 10.94 7.34 10.05 8.34 8.72 9.56 <-Median-> 10 Assets/Current Liab Ratio US$
Debt to Cash Flow (Years) 1.65 0.80 2.08 6.89 5.80 3.77 5.06 3.49 3.04 4.23 2.77 4.03 3.53 3.15 3.90 <-Median-> 10 Debt to Cash Flow (Years) US$
Intangibles $2,647 $2,673 $12,879 $28,101 $26,899 $23,407 $21,723 $20,560 $19,063 $17,740 $15,595 $14,844 $13,225 $12,819 2.69% <-Total Growth 10 Intangibles
Goodwill $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,986 $41,084 286.92% <-Total Growth 10 Goodwill
Total $12,581 $13,002 $23,472 $68,631 $68,399 $61,922 $61,266 $60,519 $58,904 $59,701 $56,097 $56,269 $54,211 $53,903 130.96% <-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% -3.66% -0.57% -1.14% <-Median-> 10 Change US$
Intangible/Market Cap Ratio 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.51 0.46 0.51 <-Median-> 10 % of Market C. US$
Current Assets $9,151 $17,793 $21,210 $30,844 $23,600 $24,873 $22,980 $21,967 $22,031 $22,548 $23,059 $21,675 $21,935 $21,947 Liquidity ratio of 1.5 and up, best Assets US$
Current Liabilities $5,857 $3,891 $5,559 $9,173 $7,165 $14,220 $10,084 $8,472 $10,366 $8,509 $12,394 $9,051 $10,789 $10,287 2.34 <-Median-> 10 Liabilities US$
Liquidity 1.56 4.57 3.82 3.36 3.29 1.75 2.28 2.59 2.13 2.65 1.86 2.39 2.03 2.13 2.13 <-Median-> 5 Ratio US$
Liq. with CF aft div 2.15 5.56 4.51 3.71 3.73 2.07 2.50 3.10 2.54 3.02 2.18 2.66 2.32 2.58 2.54 <-Median-> 5 Ratio US$
Liq. CF re  Inv+Div  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.90 2.58 1.92 <-Median-> 5 Ratio US$
Assets $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,981 $89,749 Debt Ratio of 1.5 and up, best Assets US$
Liabilities $15,970 $16,170 $18,500 $53,455 $47,719 $49,400 $40,571 $39,482 $39,817 $41,481 $38,260 $39,283 $39,561 $41,589 2.26 <-Median-> 10 Liabilities US$
Debt Ratio 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.27 2.16 2.28 <-Median-> 5 Ratio US$
Estimates BVPS $38.64 $40.00 $41.40 Estimates Estimates BVPS
Estimate Book Value $51,422.5 $53,232.4 $55,095.5 Estimates Estimate Book Value
P/B Ratio (Close) 2.26 2.18 2.11 Estimates P/B Ratio (Close)
Difference from 10 year median -2.57% Diff M/C Estimates Difference from 10 yr med.
Book Value $17,113 $18,671 $19,443 $53,230 $52,063 $50,416 $50,822 $50,212 $50,872 $51,602 $52,721 $51,665 $50,420 $48,160
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $122 $102 $121 $135 $174 $171 $182 $206 $213
Net Book Value $17,113 $18,671 $19,443 $53,230 $52,063 $50,294 $50,720 $50,091 $50,737 $51,428 $52,550 $51,483 $50,214 $47,947 $47,947 $47,947 158.26% <-Total Growth 10 Book Value US$
Book Value per Share $16.50 $18.38 $19.46 $37.44 $37.21 $36.73 $37.45 $37.36 $37.83 $38.35 $39.06 $38.69 $37.73 $36.03 $36.03 $36.03 93.87% <-Total Growth 10 Book Value per Share US$
Change 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.47% -4.51% 0.00% 0.00% 4.50% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 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.12 2.33 0.00 0.00 3.39 P/B Ratio Historical Median US$
P/B Ratio (Close) 2.32 2.54 3.02 1.99 2.13 2.26 2.14 2.38 2.58 3.41 2.67 2.35 2.13 2.42 2.42 2.42 6.84% <-IRR #YR-> 10 Book Value per Share 93.87% US$
Change -17.47% 9.71% 18.98% -34.21% 6.97% 6.37% -5.43% 11.10% 8.56% 32.30% -21.74% -12.01% -9.54% 14.02% 0.00% 0.00% 0.20% <-IRR #YR-> 5 Book Value per Share 0.99% US$
Leverage (A/BK) 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.79 1.87 1.80 <-Median-> 10 A/BV US$
Debt/Equity Ratio 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.79 0.87 0.79 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.32 5 yr Med 2.57 4.50% Diff M/C 1.79 Historical Leverage (A/BK) US$
-$19.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $37.73
-$37.36 $0.00 $0.00 $0.00 $0.00 $37.73
$1,859 <-12 mths -25.58%
Comprehensive Income $3,179 $3,448 $2,960 $2,088 $2,854 $3,280 $4,125 $3,675 $3,955 $3,713 $6,258 $2,524 $3,856 Comprehensive Income
NCI $0 $0 $0 $0 $0 -$3 -$9 $16 $15 $32 $32 $26 $26 NCI
Shareholders $3,179 $3,448 $2,960 $2,088 $2,854 $3,283 $4,134 $3,659 $3,940 $3,681 $6,226 $2,498 $3,830 29.39% <-Total Growth 10 Comprehensive Income US$
Increase 0.00% 8.46% -14.15% -29.46% 36.69% 15.03% 25.92% -11.49% 7.68% -6.57% 69.14% -59.88% 53.32% 7.68% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $2,732 $2,991 $3,153 $2,971 $2,906 $2,927 $3,064 $3,204 $3,574 $3,739 $4,328 $4,001 $4,035 2.61% <-IRR #YR-> 10 Comprehensive Income 29.39% US$
ROE 18.6% 18.5% 15.2% 3.9% 5.5% 6.5% 8.2% 7.3% 7.8% 7.2% 11.8% 4.9% 7.6% 0.92% <-IRR #YR-> 5 Comprehensive Income 4.67% US$
5Yr Median 18.6% 18.6% 18.6% 18.5% 15.2% 6.5% 6.5% 6.5% 7.3% 7.3% 7.8% 7.3% 7.6% 2.50% <-IRR #YR-> 10 5 Yr Running Average 27.99% US$
% Difference from NI -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.0% 4.72% <-IRR #YR-> 5 5 Yr Running Average 25.95% US$
Median Values Diff 5, 10 yr -18.1% 2.1% 7.6% <-Median-> 5 Return on Equity US$
-$2,960 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,830
-$3,659 $0 $0 $0 $0 $3,830
-$3,153 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,035
-$3,204 $0 $0 $0 $0 $4,035
Current Liability Coverage Ratio 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.67 0.81   CFO / Current Liabilities US$
5 year Median 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 0.69 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio 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.08% 9.31% CFO / Total Assets US$
5 year Median 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% 8.08% 7.9% <-Median-> 5 Return on Assets  US$
Return on Assets ROA 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.05% 5.73% Net  Income/Assets Return on Assets US$
5Yr Median 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.13% 4.13% 4.1% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE 21.14% 18.57% 15.76% 5.03% 6.80% 8.01% 6.12% 9.25% 9.44% 7.01% 9.59% 7.30% 7.26% 10.73% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 19.39% 19.39% 19.39% 18.57% 15.76% 8.01% 6.80% 6.80% 8.01% 8.01% 9.25% 9.25% 7.30% 7.30% 7.3% <-Median-> 5 Return on Equity US$
$3,899 <-12 mths 6.88%
Net Income $3,617 $3,467 $3,065 $2,675 $3,538 $4,024 $3,095 $4,650 $4,806 $3,630 $5,062 $3,784 $3,676
NCI $0 $0 $0 $0 $0 -$4 -$9 $19 $17 $24 $22 $26 $28
Shareholders $3,617 $3,467 $3,065 $2,675 $3,538 $4,028 $3,104 $4,631 $4,789 $3,606 $5,040 $3,758 $3,648 $5,143 $5,666 $6,089 19.02% <-Total Growth 10 Net Income US$
Increase 16.83% -4.15% -11.60% -12.72% 32.26% 13.85% -22.94% 49.19% 3.41% -24.70% 39.77% -25.44% -2.93% 40.98% 10.17% 7.47% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $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,168 $4,239 $4,651 $4,861 1.76% <-IRR #YR-> 10 Net Income 19.02% US$
Operating Cash Flow $4,470 $4,883 $4,959 $4,902 $5,218 $6,880 $4,684 $7,007 $7,234 $6,240 $7,346 $6,039 $6,787 -4.66% <-IRR #YR-> 5 Net Income -21.23% US$
Investment Cash Flow -$2,651 -$3,101 -$3,594 -$17,058 $2,245 -$1,571 $5,858 -$774 -$3,203 -$2,866 -$1,659 -$3,493 -$2,366 2.46% <-IRR #YR-> 10 5 Yr Running Average 27.51% US$
Total Accruals $1,798 $1,685 $1,700 $14,831 -$3,925 -$1,281 -$7,438 -$1,602 $758 $232 -$647 $1,212 -$773 3.00% <-IRR #YR-> 5 5 Yr Running Average 15.94% US$
Total Assets $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,981 Balance Sheet Assets US$
Accruals Ratio 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.86% 0.25% <-Median-> 5 Ratio US$
EPS/CF Ratio 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.54 0.65 <-Median-> 10 EPS/CF Ratio US$
-$3,065 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,648
-$4,631 $0 $0 $0 $0 $3,648
-$3,269 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,168
-$3,595 $0 $0 $0 $0 $4,168
Chge in Close -8.74% 22.20% 26.01% 26.57% 6.31% 4.98% -3.56% 10.83% 9.93% 34.10% -20.29% -12.85% -11.78% 8.87% 0.00% 0.00% Count 30 Years of data
up/down/neutral down down Up Count 14
Any Predictions? Yes % right Count 7 50.00%
Financial Cash Flow -$1,882 -$2,101 -$918 $16 -$9,543 -$3,283 -$11,954 -$5,431 -$4,198 -$4,136 -$5,336 -$4,960 -$4,450 C F Statement  Financial Cash Flow US$
Total Accruals $3,680 $3,786 $2,618 $14,815 $5,618 $2,002 $4,516 $3,829 $4,956 $4,368 $4,689 $6,172 $3,677 Accruals US$
Accruals Ratio 11.12% 10.87% 6.90% 13.89% 5.63% 2.01% 4.94% 4.27% 5.46% 4.69% 5.15% 6.79% 4.09% 5.15% <-Median-> 5 Ratio US$
Cash $1,248 $860 $1,403 $4,843 $2,876 $4,967 $7,669 $4,393 $4,140 $3,593 $31,714 $1,543 $1,284 $2,140 Cash US$
Cash per Share $1.20 $0.85 $1.40 $3.41 $2.06 $3.63 $5.66 $3.28 $3.09 $2.68 $23.57 $1.16 $0.96 $1.61 $2.68 <-Median-> 5 Cash per Share US$
Percentage of Stock Price 3.15% 1.81% 2.39% 4.58% 2.60% 4.37% 7.07% 3.69% 3.16% 2.05% 22.59% 1.27% 1.20% 1.84% 2.05% <-Median-> 5 % of Stock Price US$
Notes:
September 29, 2024.  Last estimates were for 2024, 2025, 2026 of 32176M, $33640M, $35294M Revenue, $5.12, $5.45, $5.93 AEPS, $3.40, $3.93, $4.24 EPS, 
$2.78, $2.84, $2.96 Div, $6206M, $6083M, $6218M FCF, $5.65, $6.19, $6.85 CFPS, $39.20, $40.20, $41.50 BVPS, $4483M, $5153M, $5520M Net Income.
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. acquired Ireland-based Covidien plc. The acquisition resulted in the formation of a new holding company incorporated in Ireland - Medtronic plc. The company 
currently generates revenues from four major segments - namely Cardiovascular Portfolio, Medical Surgical Portfolio, Neuroscience Portfolio and Diabetes. The Cardiovascular 
Portfolio, formerly reported as the Cardiac and Vascular Group, includes the Cardiac Rhythm & Heart Failure, Structural Heart & Aortic and Coronary & Peripheral Vascular divisions.
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.  
Also, for the Operational Profit Margin, a higher percentage is better.  With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2016 Oct 21 2017 Oct 14 2018 Oct 11 2019 Oct 10 2020 Oct 3 2021 Oct 7 2022 Oct 3 2023 Oct 3 2024
Martha, Geoffrey, S.  0.052 0.00% 0.081 0.01% 0.096 0.01% 0.102 0.01% 0.141 0.01% 0.185 0.01% Shows as CEO 2020 37.70%
CEO & Chair Shares - Amount $5.858 $9.499 $9.914 $7.966 $11.627 $16.154
Options - percentage 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
Parkhill, Karen L.  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% 0.114 0.01% no CFO listed 8.87%
CFO - Shares - Amount $4.544 $5.776 $7.311 $9.790 $10.447 $10.711 $7.047 $8.132 $9.985 Last Update Aug 24
Options - percentage 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% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $1.852 $0.000 $0.000 $0.000
Fong, Ivan K. 0.038 0.00% 0.041 0.00% 0.058 0.00% 8.17%
Officer - Shares - Amount $2.932 $3.362 $5.064
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000
Salmon Sean 0.048 0.00% 0.065 0.00% #DIV/0!
Officer - Shares - Amount $3.932 $5.688
Options - percentage 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $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.038 0.00% 0.00%
Director - Shares - Amount $3.474 $3.750 $3.409 $2.675 $2.835 $3.344
Options - percentage 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
Anderson Richard H 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 $5.096 $6.397 $7.731 $11.029 $12.763 $11.414 $9.129 $9.677
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% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Donnelly, Scott C. 0.017 0.00% 0.020 0.00% #DIV/0!
Director - Shares - Amount $1.366 $1.713
Options - percentage 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000
Chairman - See above CEO
Increase in O/S Shares 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% 6.000 0.45% Stock and EPSS
due to SO $1,153.800 $925.990 $807.500 $1,637.280 $1,361.400 $937.120 $724.150 $466.320 $494.280 Repurchaes same as options
Book Value $491.000 $428.000 $329.000 $923.000 $1,228.000 $382.000 $688.000 $591.000 $231.000
Insider Buying $0.000 -$1.644 -$0.249 -$2.267 -$2.063 -$0.500 -$0.517 $0.000 $0.000
Insider Selling $17.429 $25.303 $38.918 $20.273 $20.346 $33.223 $1.518 $2.436 $4.696
Net Insider Selling $17.429 $23.659 $38.669 $18.005 $18.282 $32.723 $1.001 $2.436 $4.696
% of Market Cap 0.02% 0.02% 0.03% 0.01% 0.01% 0.02% 0.00% 0.00% 0.00%
Directors 12 12 11 13 12 12 11 11
Women 31% 3 25% 3 25% 3 27% 3 23% 3 25% 4 33% 4 36% 4 36%
Minorities 15% 2 17% 3 25% 2 18% 3 23% 2 17% 2 17% 2 18% 2 18%
South Asian male 2 black males
2 black males
# Institutions/Holdings 85.10% 1,370 82.88% 1,492 82.88% 1,705 82.88% 20 45.74% 20 48.09% 20 48.68%
Total Shares Held 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% 624.394 46.92%
Increase/Decrease 0.9% -18.978 -1.7% -0.656 -0.1% 23.424 2.2% -0.144 0.0% -1.435 -0.2% -35.220 -5.3%
Starting No. of Shares Nasdaq 1,141.683 Nasdaq 1,108.664 Nasdaq 1,088.871 Nasdaq 615.757 MS Top 20 641.287 MS Top 20 659.614 MS Top 20
Copyright © 2008 Website of SPBrunner. All rights reserved.