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 2026
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Jul 2025
Medtronic PLC NYSE: MDT https://www.medtronic.com/us-en/index.html Fiscal Yr: Apr 30
Year 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 4/30/28 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$ 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.4389 1.3953 1.3953 1.3953
split
$34,200 <-12 mths 1.98%
Revenue* $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,537 $35,537 $37,670 $39,556 65.52% <-Total Growth 10 Revenue US$
Increase 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.62% 5.96% 6.00% 5.01% 5.17% <-IRR #YR-> 10 Revenue 65.52% US$
5 year Running Average $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,786 $32,870 $34,067 $35,733 3.01% <-IRR #YR-> 5 Revenue 15.99% US$
Revenue per Share $16.33 $17.02 $14.25 $20.61 $21.70 $22.12 $22.79 $21.56 $22.46 $23.55 $23.47 $24.32 $26.16 $27.72 $29.39 $30.86 6.34% <-IRR #YR-> 10 5 yr Running Average 84.86% US$
Increase 4.65% 4.25% -16.27% 44.61% 5.27% 1.95% 3.05% -5.41% 4.16% 4.87% -0.36% 3.64% 7.58% 5.96% 6.00% 5.01% 1.44% <-IRR #YR-> 5 5 yr Running Average 7.41% US$
5 year Running Average $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.99 $25.04 $26.21 $27.69 6.26% <-IRR #YR-> 10 Revenue per Share 83.56% US$
Net profit Margin-Net Income/Sales 20.90% 18.02% 13.20% 12.27% 13.56% 10.36% 15.16% 16.56% 11.97% 15.91% 12.03% 11.27% 13.90% 14.59% 15.50% 16.00% 3.95% <-IRR #YR-> 5 Revenue per Share 21.34% US$
P/S (Price/Sales) Med 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.28 3.22 0.00 0.00 4.39% <-IRR #YR-> 10 5 yr Running Average 53.60% US$
P/S (Price/Sales) Close 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.24 3.49 3.29 3.13 1.98% <-IRR #YR-> 5 5 yr Running Average 10.28% US$
*Net Sales in M US$  P/S Med 20 yr  3.80 15 yr  3.74 10 yr  3.88 5 yr  3.89 -10.02% Diff M/C
NI/Sales 20 yr  15.53% 13.90% 12.91% 12.03%
-$20,261 $0 $0 $0 $0 $0 $0 $0 $0 $0 $33,537
-$28,913 $0 $0 $0 $0 $33,537
-$17,195 $0 $0 $0 $0 $0 $0 $0 $0 $0 $31,786
-$29,593 $0 $0 $0 $0 $31,786
-$14.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.16
-$21.56 $0.00 $0.00 $0.00 $0.00 $26.16
-$15.62 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.99
-$21.75 $0.00 $0.00 $0.00 $0.00 $23.99
$7,113 <-12 mths 0.48%
$5.52 <-12 mths 0.55%
Non-GAAP Profit US$ $3,467 $4,098 $4,744 $6,228 $6,395 $6,530 $6,206 $6,206 $6,005 $7,505 $7,045 $6,918 $7,079
Basic $3.40 $4.09 $4.33 $4.42 $4.64 $4.81 $4.61 $4.63 $4.47 $5.59 $5.30 $5.21 $5.51 27.16% <-Total Growth 10 AEPS
AEPS* Dilued $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.49 $5.63 $6.08 $6.53 28.34% <-Total Growth 10 AEPS
Increase -1.17% 19.97% 5.81% 2.10% 5.32% 3.70% -3.77% 0.00% -3.27% 25.00% -4.68% -1.70% 5.58% 2.55% 7.99% 7.40% 10 0 10 Years of Data, EPS P or N 100.00%
5 year Running Average $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.43 $5.54 $5.79 2.53% <-IRR #YR-> 10 AEPS 28.34%
AEPS Yield 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.48% 5.82% 6.29% 6.75% 3.65% <-IRR #YR-> 5 AEPS 19.61%
Payout Ratio 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.00% 50.44% 46.71% 43.49% 3.76% <-IRR #YR-> 10 5 yr Running Average 44.59%
5 year Running Average 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.63% 50.27% 50.53% 48.94% 2.53% <-IRR #YR-> 5 5 yr Running Average 13.32%
Price/AEPS Median 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.61 15.84 0.00 0.00 17.79 <-Median-> 10 Price/AEPS Median
Price/AEPS High 14.16 15.41 18.53 18.27 19.33 18.70 21.68 26.43 29.55 24.35 20.09 17.44 17.21 17.35 0.00 0.00 19.71 <-Median-> 10 Price/AEPS High
Price/AEPS Low 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.00 14.33 0.00 0.00 15.95 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 13.85 14.55 17.40 18.12 18.06 16.80 19.35 21.27 29.49 18.80 17.19 15.43 15.44 17.17 15.90 14.81 18.09 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 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.30 17.61 17.17 15.90 18.56 <-Median-> 10 Trailing P/AEPS Close
Median Values Historical   in order 17.24 18.70 14.39 17.19 P/AEPS 5 Yrs   in order 17.24 20.09 14.39 17.19 -0.39% Diff M/C DPR 75% to 95% best
* Non-GAAP Earnings per Share
-$4.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.49
-$4.59 $0.00 $0.00 $0.00 $0.00 $5.49
-$3.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.19
-$4.58 $0.00 $0.00 $0.00 $0.00 $5.19
$3.62 <-12 mths 0.28%
EPS Basic $3.40 $3.06 $2.44 $2.51 $2.92 $2.29 $3.44 $3.57 $2.68 $3.75 $2.83 $2.77 $3.63 48.77% <-Total Growth 10 EPS Basic US$
Split ' 97
Split ' 99
EPS Diluted* $3.37 $3.02 $2.41 $2.48 $2.89 $2.27 $3.41 $3.54 $2.66 $3.73 $2.82 $2.76 $3.61 $4.07 $4.61 $5.06 49.79% <-Total Growth 10 EPS Diluted US$
Increase -1.17% -10.39% -20.20% 2.90% 16.53% -21.45% 50.22% 3.81% -24.86% 40.23% -24.40% -2.13% 30.80% 12.77% 13.31% 9.73% 10 0 10 Years of Data, EPS P or N US$
Earnings Yield 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.3% 4.2% 4.8% 5.2% 4.12% <-IRR #YR-> 10 Earnings per Share 49.79% US$
5 year Running Average $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.12 $3.40 $3.57 $4.02 0.39% <-IRR #YR-> 5 Earnings per Share 1.98% US$
10 year Running Average $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.02 $3.18 $3.35 $3.63 0.33% <-IRR #YR-> 10 5 yr Running Average 3.38% US$
* Diluted ESP per share  P/S 10 yr  0.03 5 yr  0.03 1.32% <-IRR #YR-> 5 5 yr Running Average 6.79% US$
-$3.02 -$2.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.61
-$3.54 $0.00 $0.00 $0.00 $0.00 $3.61
-$3.09 -$3.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.12
-$2.92 $0.00 $0.00 $0.00 $0.00 $3.12
Dividend* $2.85 $2.97 $3.08 Estimates Dividend* US$
Increase 1.89% 4.14% 3.57% Estimates Increase US$
Payout Ratio EPS 70.08% 64.40% 60.79% 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* $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.84 $2.84 $2.84 129.51% <-Total Growth 10 Dividends US$
Increase 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% 1.43% 0.00% 0.00% 35 0 35 Years of data, Count P, N 100.00% US$
Average Increases 5 Year Running 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% 4.18% 2.46% 0.87% 10.04% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $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.73 $2.79 $2.82 149.90% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 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.27% 3.18% 2.22% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 2.18% 1.80% 1.54% 1.91% 1.93% 2.06% 2.01% 1.78% 1.77% 1.86% 2.56% 3.04% 2.96% 2.91% 1.97% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 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% 3.52% 2.56% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 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.30% 2.94% 2.94% 2.94% 2.27% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 30.86% 37.09% 50.62% 61.29% 59.52% 81.06% 58.65% 61.02% 87.22% 67.56% 96.45% 100.00% 77.56% 69.76% 61.57% 56.10% 72.56% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 31.20% 31.39% 34.84% 39.96% 46.72% 56.77% 61.66% 63.33% 67.98% 69.44% 72.52% 80.46% 84.21% 80.28% 78.10% 69.99% 65.65% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 21.64% 22.56% 35.38% 40.75% 34.24% 53.20% 38.27% 40.04% 49.86% 46.15% 59.94% 54.12% 50.96% 40.54% 37.82% 33.92% 48.01% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 22.58% 22.73% 24.97% 27.61% 30.13% 35.98% 39.74% 40.47% 42.26% 44.81% 46.38% 49.63% 51.97% 42.10% 43.09% 43.46% 41.36% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 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.32% 40.54% 37.82% 33.92% 42.75% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 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.29% 45.21% 44.23% 40.61% 39.42% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 10 Yr Med 10 Yr Cl 2.22% 2.27% 5 Yr Med 5 Yr Cl 2.98% 2.99% 5 Yr Med Payout 87.22% 50.96% 44.82% 5.33% <-IRR #YR-> 5 Dividends 29.63% US$
* Dividends per share  10 Yr Med and Cur. 32.11% 29.17% 5 Yr Med and Cur. -1.51% -1.78% Last Div Inc ---> $0.700 $0.710 1.43% 8.66% <-IRR #YR-> 10 Dividends 129.51% US$
Dividends Growth 15 8.53% <-IRR #YR-> 15 Dividends 241.46% US$
Dividends Growth 20 11.12% <-IRR #YR-> 20 Dividends 723.53% US$
Dividends Growth 25 12.13% <-IRR #YR-> 25 Dividends 1650.00% US$
Dividends Growth 30 14.25% <-IRR #YR-> 30 Dividends 5336.89% US$
Dividends Growth 35 14.78% <-IRR #YR-> 35 Dividends
Dividends Growth 5 -$2.16 $0.00 $0.00 $0.00 $0.00 $2.80 Dividends Growth 5
Dividends Growth 10 -$1.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.80 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.80 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.80 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.80 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.80 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.80 Dividends Growth 35
Historical Dividends Historical High Div 3.38% Low Div 0.37% 10 Yr High 3.94% 10 Yr Low 1.77% Med Div 1.10% Close Div 1.05% 2.22% 32.32% Historical Dividends US$
High/Ave/Median Values Curr diff Exp. -13.09%     693.93% Exp. -25.44% 65.96% Cheap 167.05% Cheap 180.64% Since 2009 High/Ave/Median  US$
Future Dividend Yield Div Yield 3.81% earning in 5 Years at IRR of 5.33% Div Inc. 29.63% Future Dividend Yield US$
Future Dividend Yield Div Yield 4.94% earning in 10 Years at IRR of 5.33% Div Inc. 68.04% Future Dividend Yield US$
Future Dividend Yield Div Yield 6.40% earning in 15 Years at IRR of 5.33% Div Inc. 117.83% Future Dividend Yield US$
Future Dividend Paid Div Paid $3.68 earning in 5 Years at IRR of 5.33% Div Inc. 29.63% Future Dividend Paid
Future Dividend Paid Div Paid $4.77 earning in 10 Years at IRR of 5.33% Div Inc. 68.04% Future Dividend Paid
Future Dividend Paid Div Paid $6.19 earning in 15 Years at IRR of 5.33% Div Inc. 117.83% Future Dividend Paid
Dividend Covering Cost Total Div $15.80 over 5 Years at IRR of 5.33% Div Cov. 16.34% Dividend Covering Cost
Dividend Covering Cost Total Div $32.59 over 10 Years at IRR of 5.33% Div Cov. 33.71% Dividend Covering Cost
Dividend Covering Cost Total Div $54.36 over 15 Years at IRR of 5.33% Div Cov. 56.23% Dividend Covering Cost
Yield if held 5 years 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.58% 2.21% 3.11% 3.25% <-Median-> 10 Paid Median Price US$
Yield if held 10 years 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.94% 3.39% 3.43% 5.01% <-Median-> 10 Paid Median Price US$
Yield if held 15 years 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.77% 7.99% 6.79% 4.36% <-Median-> 10 Paid Median Price US$
Yield if held 20 years 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.23% 5.85% 5.48% 5.80% <-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.52% 6.30% 6.87% 25.22% <-Median-> 10 Paid Median Price US$
Yield if held 30 years 118.03% 51.90% 57.14% 55.91% 61.47% 40.43% 23.57% 19.21% 13.00% 56.53% <-Median-> 6 Paid Median Price US$
Yield if held 35 years