| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| See
my website on stocks or see my blog at the following sites. |
|
www.spbrunner.com/stocks.html |
www.spbrunner.blogspot.com/ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Medtronic Inc |
|
|
|
http://www.medtronic.com |
MDT |
US Sym. |
|
Fiscal Yr: |
Apr 31 |
|
1/29/11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Year |
4/30/99 |
4/30/00 |
4/30/01 |
4/30/02 |
4/30/03 |
4/30/04 |
4/30/05 |
4/28/06 |
4/27/07 |
4/25/08 |
4/24/09 |
4/30/10 |
4/30/11 |
4/30/12 |
|
|
|
#Y |
|
|
|
|
|
|
|
|
|
| USD - CDN$ |
1.4578 |
1.4818 |
1.536 |
1.5681 |
1.4336 |
1.3711 |
1.2568 |
1.1203 |
1.1068 |
1.0163 |
1.1892 |
1.0044 |
0.9714 |
0.9714 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| split |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Revenue* |
$4,233 |
$5,016 |
$5,552 |
$6,411 |
$7,665 |
$9,087 |
$10,055 |
$11,292 |
$12,299 |
$13,515 |
$14,599 |
$15,817 |
$15,824 |
<-12 mths |
|
215.31% |
<-Total Growth |
10 |
Revenue |
US$ |
|
|
|
|
|
|
|
| Increase |
62.49% |
18.52% |
10.68% |
15.47% |
19.57% |
18.55% |
10.65% |
12.31% |
8.92% |
9.89% |
8.02% |
8.34% |
0.04% |
|
|
12.17% |
<-IRR #YR-> |
10 |
Revenue |
US$ |
|
|
|
|
|
|
|
| Rev per Share |
$3.55 |
$4.19 |
$4.59 |
$5.25 |
$6.29 |
$7.51 |
$8.31 |
$9.78 |
$10.76 |
$12.01 |
$13.04 |
$14.41 |
$14.74 |
|
|
9.48% |
<-IRR #YR-> |
5 |
Revenue |
US$ |
|
|
|
|
|
|
|
| P/S (Price/Sales) |
10.37 |
12.66 |
9.34 |
8.44 |
7.72 |
6.69 |
6.34 |
5.10 |
4.92 |
4.11 |
2.45 |
3.03 |
2.64 |
|
|
13.16% |
<-IRR #YR-> |
10 |
Rev Per share |
US$ |
|
|
|
|
|
|
|
| Averages |
|
|
|
|
|
|
|
P/S |
10 Yrs |
5.81 |
5Yrs |
3.92 |
|
|
|
11.65% |
<-IRR #YR-> |
5 |
Rev Per share |
US$ |
|
|
|
|
|
|
|
| *Net Sales in M US$ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$5,016 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$15,817 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$10,055 |
$0 |
$0 |
$0 |
$0 |
$15,817 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$4.2 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$14.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$8.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$14.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Split ' 97 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Split ' 99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| EPS* |
$0.39 |
$0.90 |
$0.85 |
$0.80 |
$1.30 |
$1.60 |
$1.48 |
$2.09 |
$2.41 |
$1.95 |
$2.05 |
$0.82 |
$3.40 |
$3.63 |
|
-8.89% |
<-Total Growth |
10 |
Earnings |
US$ |
|
|
|
|
|
|
|
| Increase |
-18.75% |
130.77% |
-5.56% |
-5.88% |
62.50% |
23.08% |
-7.50% |
41.22% |
15.31% |
-19.09% |
5.13% |
-60.00% |
314.63% |
6.76% |
|
-0.93% |
<-IRR #YR-> |
10 |
Earnings |
US$ |
|
|
|
|
|
|
|
| * ESP per share
US$ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-11.14% |
<-IRR #YR-> |
5 |
Earnings |
US$ |
|
|
|
|
|
|
|
| |
|
-$0.90 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$1.48 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Split ' 99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Div* |
$0.13 |
$0.16 |
$0.20 |
$0.23 |
$0.25 |
$0.29 |
$0.34 |
$0.39 |
$0.44 |
$0.50 |
$0.75 |
$0.82 |
$0.90 |
$0.90 |
|
412.50% |
<-Total Growth |
10 |
Dividends |
US$ |
|
|
|
|
|
|
|
| Increase |
18.18% |
23.08% |
25.00% |
15.00% |
8.70% |
16.00% |
17.24% |
14.71% |
12.82% |
13.64% |
50.00% |
9.33% |
9.76% |
0.00% |
|
18.24% |
<-Average |
10 |
Dividends |
US$ |
|
|
|
|
|
|
|
| Yield H/L |
0.38% |
0.36% |
0.39% |
0.51% |
0.60% |
0.60% |
0.67% |
0.72% |
0.91% |
0.96% |
1.85% |
2.11% |
|
|
|
0.93% |
<-Average |
10 |
Dividends |
US$ |
|
|
|
|
|
|
|
| Yield on Cl |
0.35% |
0.30% |
0.47% |
0.52% |
0.51% |
0.58% |
0.65% |
0.78% |
0.83% |
1.01% |
2.34% |
1.88% |
2.31% |
2.31% |
|
0.96% |
<-Average |
10 |
Dividends |
US$ |
|
|
|
|
|
|
|
| Payout Ratio |
33.3% |
17.8% |
23.5% |
28.8% |
19.2% |
18.1% |
23.0% |
18.7% |
18.3% |
25.6% |
36.6% |
100.0% |
26.5% |
24.8% |
|
31.18% |
<-Average |
10 |
Dividends |
US$ |
|
|
|
|
|
|
|
| Payout Ratio CF |
33.3% |
18.4% |
13.2% |
17.7% |
14.7% |
12.3% |
14.6% |
20.4% |
16.9% |
16.1% |
21.6% |
21.8% |
#DIV/0! |
#DIV/0! |
|
16.93% |
<-Average |
10 |
Dividends |
US$ |
|
|
|
|
|
|
|
| Average 5 Yrs |
Div Yd |
2.95% |
in 5 yrs |
3.76% |
in 10 yrs |
|
Yield |
1.31% |
1.37% |
Payout |
39.83% |
19.37% |
|
|
|
17.75% |
<-IRR #YR-> |
10 |
Dividends |
US$ |
|
|
|
|
|
|
|
| * Dividends per share US$ |
|
5.00% |
|
5.00% |
|
|
|
|
|
|
|
|
|
|
|
19.25% |
<-IRR #YR-> |
5 |
Dividends |
US$ |
|
|
|
|
|
|
|
| |
|
-$0.16 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$0.34 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| H/LYield held 5 yrs |
2.90% |
2.31% |
1.66% |
1.56% |
1.14% |
0.86% |
0.76% |
0.76% |
0.98% |
1.21% |
1.55% |
1.61% |
1.66% |
|
|
Ave H/L |
Yield on your |
|
|
US$ |
|
|
|
|
|
|
|
| H/LYield held
10 yrs |
|
|
|
|
6.46% |
4.91% |
3.24% |
2.98% |
2.29% |
2.21% |
1.83% |
1.75% |
|
|
Ave H/L |
original money |
|
|
US$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Div CDN$ |
$0.19 |
$0.24 |
$0.31 |
$0.36 |
$0.36 |
$0.40 |
$0.43 |
$0.44 |
$0.49 |
$0.51 |
$0.89 |
$0.82 |
|
|
|
247.38% |
<-Total Growth |
10 |
Dividends |
CDN$ |
|
|
|
|
|
|
|
| Increase |
20.46% |
25.10% |
29.57% |
17.40% |
-0.63% |
10.94% |
7.47% |
2.25% |
11.46% |
4.34% |
75.51% |
-7.65% |
|
|
|
13.26% |
<-IRR #YR-> |
10 |
Dividends |
CDN$ |
|
|
|
|
|
|
|
| Dividends per
share in CDN$ funds |
|
|
|
|
|
|
|
|
|
|
|
|
|
14.02% |
<-IRR #YR-> |
5 |
Dividends |
CDN$ |
|
|
|
|
|
|
|
| |
|
-$0.24 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$0.43 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Close CDN$ |
$53.71 |
$78.54 |
$65.83 |
$69.47 |
$69.60 |
$68.90 |
$66.23 |
$55.89 |
$58.58 |
$50.23 |
$38.05 |
$43.88 |
|
|
|
-5.65% |
<-IRR #YR-> |
10 |
Stock Price |
CDN$ |
|
|
|
|
|
|
|
| 5 yr Period
ending |
|
|
04/30/02 |
04/30/03 |
04/30/04 |
04/30/05 |
04/28/06 |
04/27/07 |
04/25/08 |
04/24/09 |
04/30/10 |
|
|
|
-7.90% |
<-IRR #YR-> |
5 |
Stock Price |
CDN$ |
|
|
|
|
|
|
|
| 5 year IRR |
|
|
|
25.74% |
14.48% |
5.66% |
-2.84% |
-2.58% |
-2.70% |
-5.57% |
-10.13% |
-6.75% |
|
|
|
-4.78% |
<-IRR #YR-> |
10 |
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| As a Canadian,
would I have made money on this stock? Looking at 5 year periods to,
including Dividends |
|
|
|
|
|
-6.75% |
<-IRR #YR-> |
2 |
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
-$78.54 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.88 |
|
|
|
Dates |
04/30/10 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$66.23 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.88 |
|
|
|
|
04/30/10 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
-$78.54 |
$0.31 |
$0.36 |
$0.36 |
$0.40 |
$0.43 |
$0.44 |
$0.49 |
$0.51 |
$0.89 |
$44.70 |
|
|
|
Cut & paste |
04/30/10 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$66.23 |
$0.44 |
$0.49 |
$0.51 |
$0.89 |
$44.70 |
|
|
|
dates, do |
04/30/10 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
-$68.90 |
$0.43 |
$0.44 |
$0.49 |
$0.51 |
$38.94 |
|
|
|
|
not copy |
04/25/08 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
|
|
|
-$69.60 |
$0.40 |
$0.43 |
$0.44 |
$0.49 |
$50.73 |
|
|
|
|
|
|
04/25/08 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
|
|
-$69.47 |
$0.36 |
$0.40 |
$0.43 |
$0.44 |
$59.07 |
|
|
|
|
|
|
|
04/27/07 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
|
-$65.83 |
$0.36 |
$0.36 |
$0.40 |
$0.43 |
$56.33 |
|
|
|
|
|
|
|
|
04/28/06 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
-$78.54 |
$0.31 |
$0.36 |
$0.36 |
$0.40 |
$66.66 |
|
|
|
|
|
|
|
|
|
04/30/05 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
-$53.71 |
$0.24 |
$0.31 |
$0.36 |
$0.36 |
$69.30 |
|
|
|
|
|
|
|
|
|
|
04/30/04 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
$0.19 |
$0.24 |
$0.31 |
$0.36 |
$69.96 |
|
|
|
|
|
|
|
|
|
|
|
04/30/03 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
$0.19 |
$0.24 |
$0.31 |
$69.83 |
|
|
|
|
|
|
|
|
|
|
|
|
04/30/02 |
|
Price & Div |
CDN$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Graham No. |
$5.27 |
$8.71 |
$9.33 |
$9.73 |
$13.78 |
$16.44 |
$16.96 |
$19.54 |
$22.82 |
$21.25 |
$23.12 |
$15.68 |
$33.08 |
$34.18 |
|
Cl Pr higher/lower by? |
|
|
US$ |
|
|
|
|
|
|
|
| Prem /Disc. High |
723.32% |
541.29% |
546.91% |
426.37% |
255.26% |
220.30% |
221.64% |
204.63% |
137.95% |
172.31% |
144.36% |
193.50% |
|
|
|
252.32% |
<-Average |
10 |
Graham Price |
US$ |
|
|
|
|
|
|
|
| Prem /Disc. Ave |
543.59% |
413.97% |
451.18% |
363.45% |
200.06% |
194.08% |
199.76% |
177.80% |
112.90% |
143.86% |
74.90% |
148.00% |
|
|
|
206.60% |
<-Average |
10 |
Graham Price |
US$ |
|
|
|
|
|
|
|
| Prem /Disc. Low |
363.85% |
286.64% |
355.45% |
300.53% |
144.87% |
167.86% |
177.88% |
150.96% |
87.86% |
115.41% |
5.44% |
102.51% |
|
|
|
160.88% |
<-Average |
10 |
Graham Price |
US$ |
|
|
|
|
|
|
|
| Prem /Disc. Cl |
599.20% |
508.24% |
359.20% |
355.08% |
252.35% |
205.70% |
210.79% |
155.26% |
131.94% |
132.59% |
38.40% |
178.58% |
17.77% |
13.97% |
|
201.99% |
<-Average |
10 |
Graham Price |
US$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Cl |
$36.84 |
$53.00 |
$42.86 |
$44.30 |
$48.55 |
$50.25 |
$52.70 |
$49.89 |
$52.93 |
$49.42 |
$32.00 |
$43.69 |
$38.96 |
$38.96 |
|
-17.57% |
<-Total Growth |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Increase |
44.98% |
43.87% |
-19.13% |
3.36% |
9.59% |
3.50% |
4.88% |
-5.33% |
6.09% |
-6.63% |
-35.25% |
36.53% |
-10.83% |
0.00% |
|
-1.91% |
<-IRR #YR-> |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| P/E |
94.46 |
58.89 |
50.42 |
55.38 |
37.35 |
31.41 |
35.61 |
23.87 |
21.96 |
25.34 |
15.61 |
53.28 |
11.46 |
10.73 |
|
-3.68% |
<-IRR #YR-> |
5 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Trailing P/E |
76.75 |
135.90 |
47.62 |
52.12 |
60.69 |
38.65 |
32.94 |
33.71 |
25.33 |
20.51 |
16.41 |
21.31 |
47.51 |
11.46 |
|
-1.03% |
<-IRR #YR-> |
10 |
Price & Div |
US$ |
|
|
|
|
|
|
|
| Average 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
-0.92% |
P/E: Y-T |
28.01 |
23.5 |
|
|
|
-2.48% |
<-IRR #YR-> |
5 |
Price & Div |
US$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$53.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$52.70 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$53.00 |
$0.20 |
$0.23 |
$0.25 |
$0.29 |
$0.34 |
$0.39 |
$0.44 |
$0.50 |
$0.75 |
$44.51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$52.70 |
$0.39 |
$0.44 |
$0.50 |
$0.75 |
$44.51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Ave H/L |
$33.91 |
$44.79 |
$51.45 |
$45.12 |
$41.35 |
$48.34 |
$50.83 |
$54.30 |
$48.59 |
$51.82 |
$40.44 |
$38.90 |
|
|
|
-13.15% |
<-Total Growth |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Increase |
55.23% |
32.07% |
14.87% |
-12.30% |
-8.36% |
16.92% |
5.15% |
6.82% |
-10.52% |
6.65% |
-21.95% |
-3.82% |
|
|
|
-1.40% |
<-IRR #YR-> |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| P/E |
86.95 |
49.76 |
60.52 |
56.39 |
31.80 |
30.21 |
34.34 |
25.98 |
20.16 |
26.57 |
19.73 |
47.43 |
|
|
|
-5.21% |
<-IRR #YR-> |
5 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Trailing P/E |
70.65 |
114.83 |
57.16 |
53.08 |
51.68 |
37.18 |
31.77 |
36.69 |
23.25 |
21.50 |
20.74 |
18.97 |
|
|
|
-0.39% |
<-IRR #YR-> |
10 |
Price & Div |
US$ |
|
|
|
|
|
|
|
| Average 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
-4.57% |
P/E: Y-T |
27.97 |
24.2 |
|
|
|
-3.92% |
<-IRR #YR-> |
5 |
Price & Div |
US$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$44.79 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$38.90 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$50.83 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$38.90 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$44.79 |
$0.20 |
$0.23 |
$0.25 |
$0.29 |
$0.34 |
$0.39 |
$0.44 |
$0.50 |
$0.75 |
$39.72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$50.83 |
$0.39 |
$0.44 |
$0.50 |
$0.75 |
$39.72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Hi Mths |
Feb 99 |
Apr 00 |
Dec 00 |
Dec 01 |
Nov 02 |
Aug 03 |
Mar 05 |
Jan 06 |
Jan 07 |
Oct 07 |
Aug 08 |
Jan 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Hi |
$43.38 |
$55.88 |
$60.38 |
$51.24 |
$48.95 |
$52.65 |
$54.54 |
$59.54 |
$54.30 |
$57.86 |
$56.50 |
$46.03 |
|
|
|
-17.63% |
<-Total Growth |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Increase |
61.02% |
28.82% |
8.05% |
-15.14% |
-4.47% |
7.56% |
3.59% |
9.17% |
-8.80% |
6.56% |
-2.35% |
-18.53% |
|
|
|
-1.92% |
<-IRR #YR-> |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| P/E |
111.23 |
62.09 |
71.04 |
64.05 |
37.65 |
32.91 |
36.85 |
28.49 |
22.53 |
29.67 |
27.56 |
56.13 |
|
|
|
-3.34% |
<-IRR #YR-> |
5 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Trailing P/E |
90.38 |
143.28 |
67.09 |
60.28 |
61.19 |
40.50 |
34.09 |
40.23 |
25.98 |
24.01 |
28.97 |
22.45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Average 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
-2.79% |
P/E: Y-T |
32.88 |
28.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$55.88 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$46.03 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$54.54 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$46.03 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Low Mths |
May 98 |
May 99 |
Apr 01 |
Sep 01 |
Jul 02 |
Nov 04 |
May 04 |
Apr 06 |
Aug 06 |
Nov 07 |
Mar 09 |
May 09 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Low |
$24.44 |
$33.69 |
$42.51 |
$38.99 |
$33.74 |
$44.03 |
$47.12 |
$49.05 |
$42.87 |
$45.77 |
$24.38 |
$31.76 |
|
|
|
-5.73% |
<-Total Growth |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Increase |
45.91% |
37.85% |
26.18% |
-8.28% |
-13.46% |
30.50% |
7.02% |
4.10% |
-12.60% |
6.76% |
-46.73% |
30.27% |
|
|
|
-0.59% |
<-IRR #YR-> |
10 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| P/E |
62.67 |
37.43 |
50.01 |
48.74 |
25.95 |
27.52 |
31.84 |
23.47 |
17.79 |
23.47 |
11.89 |
38.73 |
|
|
|
-7.59% |
<-IRR #YR-> |
5 |
Stock Price |
US$ |
|
|
|
|
|
|
|
| Trailing P/E |
50.92 |
86.38 |
47.23 |
45.87 |
42.18 |
33.87 |
29.45 |
33.14 |
20.51 |
18.99 |
12.50 |
15.49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Average 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
-3.64% |
P/E: Y-T |
23.07 |
20.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
-$33.69 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$31.76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
-$47.12 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$31.76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Market Cap |
$43,909 |
$63,489 |
$51,840 |
$54,117 |
$59,139 |
$60,772 |
$63,778 |
$57,623 |
$60,499 |
$55,598 |
$35,817 |
$47,943 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Split ' 97 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Split ' 99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| # of Sh in M |
1,191.9 |
1,198 |
1,210 |
1,222 |
1,218 |
1,209 |
1,210 |
1,155 |
1,143 |
1,125 |
1,119 |
1,097 |
1,073 |
1,073 |
|
Shareholders' Equity |
|
Shares |
US$ |
|
|
|
|
|
|
|
| Increase |
27.06% |
0.50% |
0.97% |
1.00% |
-0.29% |
-0.71% |
0.07% |
-4.56% |
-1.04% |
-1.57% |
-0.51% |
-1.96% |
-2.17% |
0.00% |
|
-0.86% |
<-Average |
10 |
Shares |
US$ |
|
|
|
|
|
|
|
| CF fr Op $M |
$465 |
$1,042 |
$1,832 |
$1,590 |
$2,078 |
$2,846 |
$2,819 |
$2,207 |
$2,979 |
$3,489 |
$3,878 |
$4,131 |
|
|
|
296.45% |
<-Total Growth |
10 |
Cash Flow |
US$ |
|
|
|
|
|
|
|
| OPS |
$0.39 |
$0.87 |
$1.51 |
$1.30 |
$1.71 |
$2.35 |
$2.33 |
$1.91 |
$2.61 |
$3.10 |
$3.46 |
$3.76 |
|
|
|
332.78% |
<-Total Growth |
10 |
Cash Flow |
US$ |
|
|
|
|
|
|
|
| Increase |
-38.01% |
122.87% |
74.08% |
-14.03% |
31.06% |
37.92% |
-0.99% |
-17.96% |
36.37% |
18.99% |
11.72% |
8.65% |
|
|
|
18.58% |
<-Average |
10 |
Cash Flow |
US$ |
|
|
|
|
|
|
|
| Non-Cash
CF |
$367.6 |
$379.4 |
-$323.3 |
$310.7 |
$236.8 |
-$241.7 |
$20.5 |
$1,489.6 |
$448.0 |
$6.0 |
-$269.0 |
-$242.0 |
|
|
|
15.78% |
<-IRR #YR-> |
10 |
Cash Flow |
US$ |
|
|
|
|
|
|
|
| OPS non-cash |
$0.70 |
$1.19 |
$1.25 |
$1.56 |
$1.90 |
$2.15 |
$2.35 |
$3.20 |
$3.00 |
$3.11 |
$3.22 |
$3.54 |
|
|
|
10.07% |
<-IRR #YR-> |
5 |
Cash Flow |
US$ |
|
|
|
|
|
|
|
| Increase |
10.98% |
69.82% |
5.09% |
24.79% |
22.13% |
13.30% |
8.98% |
36.40% |
-6.33% |
3.62% |
3.79% |
9.91% |
|
|
|
11.56% |
<-IRR #YR-> |
10 |
Cash Flow |
US$ |
|
|
|
|
|
|
|
| P/CF on Cl |
52.73 |
44.67 |
34.37 |
28.47 |
25.55 |
23.34 |
22.46 |
15.59 |
17.65 |
15.91 |
9.92 |
12.33 |
|
|
|
8.60% |
<-IRR #YR-> |
5 |
Cash Flow |
US$ |
|
|
|
|
|
|
|
| Averages |
|
|
|
|
|
|
|
P/CF |
10 Yrs |
20.56 |
5 Yrs |
14.28 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| *Operational
Cash Flow per share |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.87 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.33 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.19 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| OPM |
10.99% |
20.77% |
32.99% |
24.81% |
27.11% |
31.32% |
28.04% |
19.55% |
24.22% |
25.82% |
26.56% |
26.12% |
|
|
|
should be zero, it is a check
on calculations |
|
|
|
US$ |
|
|
|
|
|
|
|
| Diff from Ave |
-58.8% |
-22.1% |
23.8% |
-6.9% |
1.7% |
17.5% |
5.2% |
-26.7% |
-9.1% |
-3.1% |
-0.3% |
-2.0% |
|
|
|
0.00% |
<-Average |
10 |
OPM |
US$ |
|
|
|
|
|
|
|
| *Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
OPM |
10 Yrs |
26.65% |
5 Yrs |
24.45% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Curr Assets |
$2,445 |
$3,013 |
$3,757 |
$3,488 |
$4,606 |
$5,313 |
$7,422 |
$10,377 |
$7,918 |
$7,322 |
$7,404 |
$9,839 |
$9,986 |
|
|
Liq ratio of 1.5 and up, best |
|
Assets |
US$ |
|
|
|
|
|
|
|
| Curr Liab. |
$1,006 |
$992 |
$1,359 |
$3,985 |
$1,813 |
$4,241 |
$3,380 |
$4,406 |
$2,563 |
$3,535 |
$2,969 |
$5,121 |
$6,602 |
|
|
2.16 |
<-Average |
10 |
Liabilities |
US$ |
|
|
|
|
|
|
|
| Liquidity |
2.43 |
3.04 |
2.76 |
0.88 |
2.54 |
1.25 |
2.20 |
2.36 |
3.09 |
2.07 |
2.49 |
1.92 |
1.51 |
|
|
2.39 |
<-Average |
5 |
Ratio |
US$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Assets |
$5,008 |
$5,669 |
$7,039 |
$10,905 |
$12,321 |
$14,111 |
$16,617 |
$19,665 |
$19,512 |
$22,198 |
$23,605 |
$28,090 |
$30,597 |
|
|
A/L ratio of 1.5 and up, best |
|
Assets |
US$ |
|
|
|
|
|
|
|
| Liab. |
$1,238 |
$1,178 |
$1,529 |
$4,473 |
$4,414 |
$5,034 |
$6,168 |
$10,282 |
$8,535 |
$10,622 |
$10,632 |
$13,461 |
$15,239 |
|
|
2.59 |
<-Average |
10 |
Liabilities |
US$ |
|
|
|
|
|
|
|
| Liquidity |
4.05 |
4.81 |
4.60 |
2.44 |
2.79 |
2.80 |
2.69 |
1.91 |
2.29 |
2.09 |
2.22 |
2.09 |
2.01 |
|
|
2.12 |
<-Average |
5 |
Ratio |
US$ |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Book Value |
$3,771 |
$4,492 |
$5,510 |
$6,431 |
$7,906 |
$9,077 |
$10,450 |
$9,383 |
$10,977 |
$11,576 |
$12,973 |
$14,629 |
$15,358 |
$15,358 |
|
225.70% |
<-Total Growth |
10 |
Book Value |
US$ |
|
|
|
|
|
|
|
| BV per share |
$3.16 |
$3.75 |
$4.56 |
$5.26 |
$6.49 |
$7.51 |
$8.63 |
$8.12 |
$9.60 |
$10.29 |
$11.59 |
$13.33 |
$14.31 |
$14.31 |
|
255.55% |
<-Total Growth |
10 |
Book Value |
US$ |
|
|
|
|
|
|
|
| Change |
45.18% |
18.52% |
21.49% |
15.57% |
23.29% |
15.63% |
15.04% |
-5.92% |
18.22% |
7.14% |
12.64% |
15.02% |
7.32% |
0.00% |
|
0.5408 |
Current/Historical |
|
Book Value |
US$ |
|
|
|
|
|
|
|
| P/BV (CL) |
11.64 |
14.14 |
9.41 |
8.41 |
7.48 |
6.70 |
6.10 |
6.14 |
5.51 |
4.80 |
2.76 |
3.28 |
2.72 |
2.72 |
|
13.52% |
<-IRR #YR-> |
10 |
Book Value |
US$ |
|
|
|
|
|
|
|
| Change |
-0.14% |
21.39% |
-33.43% |
-10.57% |
-11.11% |
-10.49% |
-8.84% |
0.62% |
-10.26% |
-12.86% |
-42.52% |
18.70% |
-16.91% |
0.00% |
|
9.08% |
<-IRR #YR-> |
5 |
Book Value |
US$ |
|
|
|
|
|
|
|
| Leverage (A/BK) |
1.33 |
1.26 |
1.28 |
1.70 |
1.56 |
1.55 |
1.59 |
2.10 |
1.78 |
1.92 |
1.82 |
1.92 |
1.99 |
0.00 |
|
1.72 |
<-Average |
10 |
A/BV |
US$ |
|
|
|
|
|
|
|
| Debt/Equity Ratio |
0.33 |
0.26 |
0.28 |
0.70 |
0.56 |
0.55 |
0.59 |
1.10 |
0.78 |
0.92 |
0.82 |
0.92 |
0.99 |
0.00 |
|
0.72 |
<-Average |
10 |
Debt/Equity |
|
|
|
|
|
|
|
|
| Averages |
|
|
|
|
|
|
|
P/BV |
10 Yrs |
6.06 |
5 Yrs |
4.50 |
|
|
|
|
|
|
|
US$ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.75 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$13.33 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$8.63 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$13.33 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ROE |
12.6% |
24.5% |
19.0% |
15.3% |
20.2% |
21.6% |
17.3% |
27.1% |
25.5% |
19.3% |
35.3% |
21.2% |
21.3% |
<---- |
|
Net Income/Shareholders' equity |
|
|
ROE |
US$ |
|
|
|
|
|
|
|
| 5Yr Running Ave |
21.4% |
22.3% |
21.1% |
18.7% |
18.5% |
20.0% |
18.8% |
20.6% |
22.4% |
22.0% |
25.2% |
25.6% |
24.4% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Income |
$476 |
$1,099 |
$1,046 |
$984 |
$1,600 |
$1,959 |
$1,804 |
$2,547 |
$2,802 |
$2,231 |
$4,577 |
$3,099 |
$3,274 |
<-12 mths |
|
182.11% |
<-Total Growth |
10 |
Net Income |
|
|
|
|
|
|
|
|
| Oper C. F. |
$465 |
$1,042 |
$1,832 |
$1,590 |
$2,078 |
$2,846 |
$2,819 |
$2,207 |
$2,979 |
$3,489 |
$3,878 |
$4,131 |
$4,254 |
<-12 mths |
|
|
Cash Flow Statement CF from continuing
operations |
|
|
|
|
|
|
| Invest. C. F |
-$1,341 |
-$376 |
-$1,026 |
-$4,382 |
-$250 |
$1,651 |
$1,603 |
$2,867 |
-$1,701 |
-$2,790 |
-$2,740 |
-$4,759 |
-$5,037 |
<-12 mths |
|
|
Cash Flow Statement |
|
|
|
|
|
|
|
|
| Total Accruals |
$1,352 |
$433 |
$240 |
$3,776 |
-$229 |
-$2,537 |
-$2,618 |
-$2,527 |
$1,524 |
$1,532 |
$3,439 |
$3,727 |
$4,057 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Assets |
$5,008 |
$5,669 |
$7,039 |
$10,905 |
$12,321 |
$14,111 |
$16,617 |
$19,665 |
$19,512 |
$22,198 |
$23,605 |
$28,090 |
$30,597 |
|
|
|
Balance Sheet |
|
|
|
|
|
|
|
|
|
|
| Accruals Ratio |
27.00% |
7.63% |
3.41% |
34.62% |
-1.86% |
-17.98% |
-15.76% |
-12.85% |
7.81% |
6.90% |
14.57% |
13.27% |
13.26% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| up/down/neutral |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Need free cash flow (cash from operations, with
depreciation and amortization added back and capital spending subtracted) to
amply cover the payouts. |
| Chge in Close |
44.98% |
43.87% |
-19.13% |
3.36% |
9.59% |
3.50% |
4.88% |
-5.33% |
6.09% |
-6.63% |
-35.25% |
36.53% |
-10.83% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Any Predictions? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Fin. C. F |
$853 |
-$423 |
-$246 |
$2,166 |
-$744 |
-$1,010 |
-$489 |
$1,316 |
-$3,011 |
-$835 |
-$845 |
$764 |
$624 |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Accruals |
$499 |
$856 |
$486 |
$1,610 |
$515 |
-$1,527 |
-$2,130 |
-$3,844 |
$4,535 |
$2,367 |
$4,284 |
$2,963 |
$3,433 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accruals Ratio |
9.97% |
15.09% |
6.90% |
14.76% |
4.18% |
-10.82% |
-12.82% |
-19.55% |
23.24% |
10.66% |
18.15% |
10.55% |
11.22% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| How they make
their money. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Medtronic
is the world's leading medical technology company, pioneering device-based
therapies that restore health, extend life and alleviate pain. Primary
products include those for bradycardia pacing, |
|
|
|
|
|
|
|
|
|
|
| tachyarrhythmia
management, atrial fibrillation management, among
others. Medtronic operates its business in one reportable segment, that of
manufacturing and selling device-based medical therapies. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The company does business in more than 120 countries. The company's
product lines include cardiac rhythm management, neurological and spinal,
vascular and cardiac surgery. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| For
most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for
yield and asset/liability ratios and here you want a higher ratios to
indicate a good stock price. |
|
|
|
|
|
|
|
|
|
| Also, for the
Operational Profit Margin, a higher percentage is better. With the OPM, you should only compare
companies in similar industries. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Copyright ©
2008 Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|