| This report is for educational purposes only, and not to provide
investment advice. 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/ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Manitoba
Telecom Services Inc |
|
www.mts.ca/ |
|
MBT |
|
Fiscal Yr: |
Dec 31 |
|
|
3/31/11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Year |
12/31/99 |
12/31/00 |
12/31/01 |
12/31/02 |
12/31/03 |
12/31/04 |
12/31/05 |
12/31/06 |
12/31/07 |
12/31/08 |
12/31/09 |
12/31/10 |
12/31/11 |
12/30/12 |
|
|
|
#Y |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accting Rules |
|
|
|
|
|
|
|
|
|
|
|
C GAAP |
IFRS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
restate '06 not done |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Revenue* |
$722.1 |
$822.3 |
$1,003.0 |
$927.3 |
$884.7 |
$1,524.9 |
$2,017.2 |
$1,926.4 |
$1,905.8 |
$1,921.5 |
$1,809.9 |
$1,708.9 |
$1,757.0 |
$1,748.0 |
|
107.83% |
<-Total Growth |
10 |
Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
3.61% |
13.87% |
21.98% |
-7.55% |
-4.59% |
72.36% |
32.28% |
-4.50% |
-1.07% |
0.82% |
-5.81% |
-5.58% |
2.81% |
-0.51% |
|
7.59% |
<-IRR #YR-> |
10 |
Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
| Rev per Share |
$12.19 |
$14.48 |
$17.66 |
$14.88 |
$14.38 |
$24.79 |
$29.85 |
$28.83 |
$29.49 |
$29.73 |
$27.99 |
$26.31 |
$27.05 |
$26.91 |
|
-3.26% |
<-IRR #YR-> |
5 |
Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
| P/S (Price/Sales) |
1.82 |
2.65 |
1.93 |
2.42 |
2.99 |
2.00 |
1.33 |
1.61 |
1.56 |
1.21 |
1.20 |
1.08 |
1.24 |
1.24 |
|
6.15% |
<-IRR #YR-> |
10 |
Rev per share |
|
|
|
|
|
|
|
|
|
|
|
|
| *Revenue in M
CDN $ Operating Revenues |
|
|
|
|
|
P/S |
10 yr |
1.58 |
5 yr |
1.21 |
|
|
|
-2.50% |
<-IRR #YR-> |
5 |
Rev per share |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$822.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$1,708.9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,017.2 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$1,708.9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$14.48 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$26.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$29.85 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$26.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| EPS* |
$1.34 |
$1.54 |
$1.13 |
$2.51 |
$1.35 |
$4.27 |
$3.14 |
$4.39 |
$2.60 |
$2.23 |
$1.57 |
$1.54 |
$2.43 |
$2.53 |
I |
0.00% |
<-Total Growth |
10 |
Earnings |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
-1.47% |
14.93% |
-26.62% |
122.12% |
-46.22% |
216.30% |
-26.46% |
39.81% |
-40.77% |
-14.23% |
-29.60% |
-1.91% |
57.79% |
4.12% |
|
0.00% |
<-IRR #YR-> |
10 |
Earnings |
|
|
|
|
|
|
|
|
|
|
|
|
| * ESP per share
(Cdn GAAP) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-13.28% |
<-IRR #YR-> |
5 |
Earnings |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.54 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.14 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Div* |
$0.70 |
$0.76 |
$0.76 |
$0.82 |
$0.94 |
$1.80 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$2.38 |
$1.70 |
$1.70 |
|
212.50% |
<-Total Growth |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
2.94% |
8.57% |
0.00% |
7.89% |
14.63% |
91.49% |
44.44% |
0.00% |
0.00% |
0.00% |
0.00% |
-8.65% |
-28.42% |
0.00% |
|
0.00% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Yield H/L |
3.58% |
2.48% |
1.88% |
2.52% |
2.43% |
3.81% |
5.91% |
6.04% |
5.47% |
6.90% |
7.63% |
7.90% |
|
|
|
5.69% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Yield on Low |
4.13% |
3.30% |
2.08% |
2.83% |
2.72% |
4.41% |
6.79% |
7.01% |
5.74% |
8.14% |
8.41% |
9.53% |
|
|
|
6.26% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Yield on Cl |
3.16% |
1.98% |
2.23% |
2.28% |
2.19% |
3.63% |
6.57% |
5.60% |
5.66% |
7.23% |
7.76% |
8.33% |
5.09% |
5.09% |
|
5.63% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Payout Ratio |
52.2% |
49.4% |
67.3% |
32.7% |
69.6% |
42.2% |
82.8% |
59.2% |
100.0% |
116.6% |
165.6% |
154.2% |
70.0% |
67.2% |
|
76.22% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Payout Ratio CF |
13.1% |
15.0% |
14.7% |
24.4% |
17.8% |
30.5% |
40.8% |
41.0% |
28.5% |
32.0% |
63.7% |
33.9% |
25.4% |
25.4% |
|
31.25% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Median 5 Yrs |
Div Yd |
5.90% |
in 5 yrs |
6.83% |
in 10 yrs |
|
Yield |
6.90% |
7.23% |
Payout |
116.59% |
33.87% |
|
|
|
12.07% |
<-IRR #YR-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| * Dividends per share |
|
3.0% |
5 |
3.0% |
10 |
|
|
|
Last Div Inc ---> |
$0.65 |
$0.43 |
-34.6% |
|
|
-1.79% |
<-IRR #YR-> |
5 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.76 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.38 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.60 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.38 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| I am earning |
|
|
|
|
|
|
|
|
|
|
RRSP |
$39.00 |
2006 |
4.36% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Yield if held 5 yrs |
|
|
|
4.86% |
4.81% |
9.21% |
8.47% |
6.43% |
8.00% |
6.71% |
5.50% |
5.40% |
3.95% |
3.57% |
|
Ave H/L |
Yield on your |
|
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
| Yield if held
10 yrs |
|
|
|
|
|
|
|
15.41% |
13.30% |
13.30% |
7.74% |
4.20% |
5.23% |
|
Ave H/L |
original money |
|
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Graham No. |
$19.24 |
$21.84 |
$18.95 |
$28.38 |
$20.95 |
$46.50 |
$38.66 |
$47.18 |
$35.65 |
$32.75 |
$26.82 |
$26.20 |
$27.94 |
$28.51 |
|
Cl Pr higher/lower by? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Prem/Disc High |
15.1% |
75.8% |
133.8% |
26.8% |
105.3% |
15.5% |
28.6% |
3.7% |
39.8% |
32.7% |
38.8% |
34.3% |
|
|
|
33.46% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Prem/Disc H/L |
1.6% |
40.6% |
113.4% |
14.5% |
85.0% |
1.7% |
13.8% |
-8.8% |
33.4% |
15.1% |
27.0% |
14.7% |
|
|
|
14.91% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Prem/Disc Low |
-11.9% |
5.3% |
93.1% |
2.1% |
64.7% |
-12.2% |
-1.0% |
-21.4% |
27.1% |
-2.5% |
15.2% |
-4.8% |
|
|
|
0.59% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Prem/Disc Cl |
15.1% |
75.8% |
79.9% |
26.8% |
105.3% |
6.7% |
2.4% |
-1.7% |
29.0% |
9.9% |
24.9% |
8.8% |
19.6% |
17.3% |
|
17.38% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Cl |
$22.15 |
$38.40 |
$34.10 |
$36.00 |
$43.00 |
$49.60 |
$39.58 |
$46.40 |
$45.97 |
$35.98 |
$33.50 |
$28.50 |
$33.43 |
$33.43 |
I |
-25.78% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
11.31% |
73.36% |
-11.20% |
5.57% |
19.44% |
15.35% |
-20.20% |
17.23% |
-0.93% |
-21.73% |
-6.89% |
-14.93% |
17.30% |
0.00% |
|
-2.94% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| P/E |
16.53 |
24.94 |
30.18 |
14.34 |
31.85 |
11.62 |
12.61 |
10.57 |
17.68 |
16.13 |
21.34 |
18.51 |
13.76 |
13.21 |
|
-6.36% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Trailing P/E |
16.29 |
28.66 |
22.14 |
31.86 |
17.13 |
36.74 |
9.27 |
14.78 |
10.47 |
13.84 |
15.02 |
18.15 |
21.71 |
13.76 |
|
2.72% |
<-IRR #YR-> |
10 |
Price & Div |
|
|
|
|
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
7.32% |
5.65% |
Div % |
5, 10 yrs |
|
Price Inc |
-6.89% |
P/E: Y-T |
17.68 |
14.78 |
|
|
|
0.97% |
<-IRR #YR-> |
5 |
Price & Div |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$38.40 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$28.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$39.58 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$28.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$38.40 |
$0.76 |
$0.82 |
$0.94 |
$1.80 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$30.88 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$39.58 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$30.88 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Ave H/L |
$19.55 |
$30.70 |
$40.45 |
$32.50 |
$38.75 |
$47.28 |
$44.02 |
$43.02 |
$47.57 |
$37.70 |
$34.06 |
$30.05 |
|
|
|
-2.12% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
0.00% |
57.03% |
31.76% |
-19.67% |
19.25% |
22.00% |
-6.90% |
-2.27% |
10.59% |
-20.75% |
-9.66% |
-11.77% |
|
|
|
-0.21% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| P/E |
14.59 |
19.94 |
35.80 |
12.95 |
28.70 |
11.07 |
14.02 |
9.80 |
18.30 |
16.91 |
21.69 |
19.51 |
|
|
|
-7.35% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Trailing P/E |
14.38 |
22.91 |
26.27 |
28.76 |
15.44 |
35.02 |
10.31 |
13.70 |
10.84 |
14.50 |
15.27 |
19.14 |
|
|
|
5.89% |
<-IRR #YR-> |
10 |
Price & Div |
|
|
|
|
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
6.73% |
6.11% |
Div % |
5, 10 yrs |
|
Price Inc |
-9.66% |
P/E: Y-T |
18.30 |
14.50 |
|
|
|
-0.62% |
<-IRR #YR-> |
5 |
Price & Div |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$30.70 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$30.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$44.02 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$30.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$30.70 |
$0.76 |
$0.82 |
$0.94 |
$1.80 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$32.43 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$44.02 |
$2.60 |
$2.60 |
$2.60 |
$2.60 |
$32.43 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Hi Mths |
Jan |
Dec |
Aug |
Nov |
Dec |
Mar |
Feb/Sep |
Oct |
May/Sept |
Nov |
Jan |
Jan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Hi |
$22.15 |
$38.40 |
$44.30 |
$36.00 |
$43.00 |
$53.70 |
$49.74 |
$48.94 |
$49.84 |
$43.45 |
$37.22 |
$35.17 |
|
|
|
-8.41% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
-4.53% |
73.36% |
15.36% |
-18.74% |
19.44% |
24.88% |
-7.37% |
-1.61% |
1.84% |
-12.82% |
-14.34% |
-5.51% |
|
|
|
-0.87% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| P/E |
16.53 |
24.94 |
39.20 |
14.34 |
31.85 |
12.58 |
15.84 |
11.15 |
19.17 |
19.48 |
23.71 |
22.84 |
|
|
|
-6.70% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Trailing P/E |
16.29 |
28.66 |
28.77 |
31.86 |
17.13 |
39.78 |
11.65 |
15.59 |
11.35 |
16.71 |
16.69 |
22.40 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
-5.51% |
P/E: Y-T |
19.48 |
16.69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$38.40 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$35.17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$49.74 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$35.17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Low Mths |
Oct-Nov |
Jan |
May |
Mar/Jul |
Feb |
Oct |
Dec |
Feb |
Mar/Aug |
Dec |
Oct |
Aug |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Low |
$16.95 |
$23.00 |
$36.60 |
$28.99 |
$34.50 |
$40.85 |
$38.29 |
$37.09 |
$45.30 |
$31.95 |
$30.90 |
$24.93 |
|
|
|
8.39% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
6.60% |
35.69% |
59.13% |
-20.79% |
19.01% |
18.41% |
-6.27% |
-3.13% |
22.14% |
-29.47% |
-3.29% |
-19.32% |
|
|
|
0.81% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| P/E |
12.65 |
14.94 |
32.39 |
11.55 |
25.56 |
9.57 |
12.19 |
8.45 |
17.42 |
14.33 |
19.68 |
16.19 |
|
|
|
-8.22% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
| Trailing P/E |
12.46 |
17.16 |
23.77 |
25.65 |
13.75 |
30.26 |
8.97 |
11.81 |
10.32 |
12.29 |
13.86 |
15.88 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
-3.29% |
P/E: Y-T |
16.19 |
12.29 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$23.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$24.93 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$38.29 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$24.93 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Market Cap |
$1,312 |
$2,181 |
$1,936 |
$2,243 |
$2,645 |
$3,051 |
$2,674 |
$3,100 |
$2,971 |
$2,326 |
$2,166 |
$1,851 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
YR 2011 |
YR 2012 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| # of Sh in M |
59.214 |
56.789 |
56.789 |
62.312 |
61.520 |
61.520 |
67.570 |
66.818 |
64.632 |
64.638 |
64.668 |
64.960 |
64.960 |
64.960 |
|
|
Share Capital |
|
Shares |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
-15.43% |
-4.10% |
0.00% |
9.73% |
-1.27% |
0.00% |
9.83% |
-1.11% |
-3.27% |
0.01% |
0.05% |
0.45% |
0.00% |
0.00% |
|
0.00 |
<-Median-> |
10 |
Shares |
|
|
|
|
|
|
|
|
|
|
|
|
| CF fr Op $M |
315.8 |
287.3 |
293.4 |
209.8 |
324.2 |
362.5 |
430.2 |
423.6 |
588.7 |
526.0 |
263.8 |
455.5 |
$434.58 |
$434.58 |
|
58.55% |
<-Total Growth |
10 |
Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
| OPS |
$5.33 |
$5.06 |
$5.17 |
$3.37 |
$5.27 |
$5.89 |
$6.37 |
$6.34 |
$9.11 |
$8.14 |
$4.08 |
$7.01 |
$6.69 |
$6.69 |
|
38.61% |
<-Total Growth |
10 |
Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
| Non-Cash CF |
-$27.2 |
$9.3 |
-$76.3 |
$67.9 |
-$22.0 |
$10.5 |
$8.5 |
$18.0 |
-$29.0 |
-$45.9 |
$117.6 |
-$55.7 |
|
|
|
3.32% |
<-IRR #YR-> |
10 |
Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
| OPS non-cash |
$4.87 |
$5.22 |
$3.82 |
$4.46 |
$4.91 |
$6.06 |
$6.49 |
$6.61 |
$8.66 |
$7.43 |
$5.90 |
$6.15 |
$6.40 |
$6.80 |
D |
1.95% |
<-IRR #YR-> |
5 |
Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase |
26.52% |
7.17% |
-26.83% |
16.60% |
10.22% |
23.43% |
7.08% |
1.79% |
31.03% |
-14.23% |
-20.59% |
4.35% |
3.99% |
6.25% |
|
1.65% |
<-IRR #YR-> |
10 |
Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
| P/O on Cl |
4.54 |
7.35 |
8.92 |
8.08 |
8.75 |
8.18 |
6.10 |
7.02 |
5.31 |
4.84 |
5.68 |
4.63 |
5.22 |
4.92 |
|
-1.06% |
<-IRR #YR-> |
5 |
Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
| CF re inv + Div |
|
|
|
|
|
|
|
|
|
0.93 |
0.82 |
1.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| *Operational
Cash Flow per share |
|
|
|
|
|
P/CF |
10 yr |
6.56 |
5 yr |
5.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$5.06 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$7.01 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6.37 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$7.01 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$5.22 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6.49 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| OPM |
43.73% |
34.94% |
29.25% |
22.62% |
36.65% |
23.77% |
21.33% |
21.99% |
30.89% |
27.37% |
14.58% |
26.65% |
|
|
|
should be zero, it is a check
on calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Diff from Ave |
73.5% |
38.6% |
16.0% |
-10.3% |
45.3% |
-5.7% |
-15.4% |
-12.8% |
22.5% |
8.6% |
-42.2% |
5.7% |
|
|
|
0.00 |
<-Median-> |
10 |
OPM |
|
|
|
|
|
|
|
|
|
|
|
|
| *Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
OPM |
10 Yrs |
25.21% |
5 Yrs |
26.65% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Q1 2011 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Curr Assets |
$253.99 |
$289.30 |
$243.08 |
$114.50 |
$514.20 |
$405.20 |
$376.70 |
$485.20 |
$328.70 |
$232.7 |
$432.0 |
$332.0 |
$224.2 |
|
|
Liq ratio of 1.5 and up, best |
|
Assets |
|
|
|
|
|
|
|
|
|
|
|
|
| Curr Liab. |
$226.03 |
$255.10 |
$406.43 |
$225.00 |
$362.20 |
$524.80 |
$590.10 |
$536.80 |
$546.00 |
$721.8 |
$426.7 |
$657.0 |
$614.9 |
|
|
0.62 |
<-Median-> |
10 |
Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
| Liquidity |
1.12 |
1.13 |
0.60 |
0.51 |
1.42 |
0.77 |
0.64 |
0.90 |
0.60 |
0.32 |
1.01 |
0.51 |
0.36 |
|
|
0.60 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
| Liq. with CF aft div |
2.34 |
2.09 |
1.21 |
1.21 |
2.16 |
1.25 |
1.07 |
1.37 |
1.37 |
0.82 |
1.24 |
0.96 |
0.89 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Liq. CF re Inv+Div |
|
|
|
|
|
|
|
|
0.51 |
0.89 |
0.73 |
0.68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Assets |
$1,321.39 |
$1,468.17 |
$1,661.95 |
$1,619.30 |
$1,684.9 |
$2,964.1 |
$2,984.2 |
$2,923.5 |
$2,726.0 |
$2,653.0 |
$2,896.4 |
$2,875.3 |
$2,559.9 |
|
|
A/L ratio of 1.5 and up, best |
|
Assets |
|
|
|
|
|
|
|
|
|
|
|
|
| Liab. |
$594.27 |
$686.30 |
$859.81 |
$730.60 |
$796.2 |
$1,579.5 |
$1,554.4 |
$1,417.6 |
$1,322.0 |
$1,271.0 |
$1,579.5 |
$1,588.8 |
$1,632.3 |
|
|
2.00 |
<-Median-> |
10 |
Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
| Asset/Liability |
2.22 |
2.14 |
1.93 |
2.22 |
2.12 |
1.88 |
1.92 |
2.06 |
2.06 |
2.09 |
1.83 |
1.81 |
1.57 |
|
|
2.06 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Book Value |
$727 |
$782 |
$802 |
$889 |
$889 |
$1,385 |
$1,430 |
$1,506 |
$1,404 |
$1,382 |
$1,317 |
$1,287 |
$928 |
$928 |
|
64.54% |
<-Total Growth |
10 |
Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
| BV per share |
$12.28 |
$13.77 |
$14.12 |
$14.26 |
$14.45 |
$22.51 |
$21.16 |
$22.54 |
$21.72 |
$21.38 |
$20.36 |
$19.80 |
$14.28 |
$14.28 |
|
43.84% |
<-Total Growth |
10 |
Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
| Change |
20.95% |
12.12% |
2.59% |
0.97% |
1.29% |
55.80% |
-5.98% |
6.51% |
-3.61% |
-1.58% |
-4.75% |
-2.75% |
-27.90% |
0.00% |
|
1.1215 |
Current/Historical |
|
Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
| P/BV (CL) |
1.80 |
2.79 |
2.41 |
2.52 |
2.98 |
2.20 |
1.87 |
2.06 |
2.12 |
1.68 |
1.65 |
1.44 |
2.34 |
2.34 |
|
3.70% |
<-IRR #YR-> |
10 |
Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
| Change |
-7.98% |
54.62% |
-13.44% |
4.56% |
17.93% |
-25.96% |
-15.12% |
10.07% |
2.79% |
-20.48% |
-2.24% |
-12.52% |
62.68% |
0.00% |
|
-1.32% |
<-IRR #YR-> |
5 |
Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
| Leverage (A/BK) |
1.82 |
1.88 |
2.07 |
1.82 |
1.90 |
2.14 |
2.09 |
1.94 |
1.94 |
1.92 |
2.20 |
2.23 |
2.76 |
0.00 |
|
2.01 |
<-Median-> |
10 |
A/BV |
|
|
|
|
|
|
|
|
|
|
|
|
| Debt/Equity Ratio |
0.82 |
0.88 |
1.07 |
0.82 |
0.90 |
1.14 |
1.09 |
0.94 |
0.94 |
0.92 |
1.20 |
1.23 |
1.76 |
|
|
1.01 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
|
|
|
|
|
|
|
|
|
|
| Median |
|
|
|
|
|
|
|
P/BV |
10 yr Ave |
2.09 |
5 yr Ave |
1.68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$13.77 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$19.80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$21.16 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$19.80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ROE |
|
|
|
|
|
|
|
19.9% |
11.9% |
10.4% |
7.7% |
7.7% |
21.2% |
<-12 mths |
|
10.42% |
<-Median-> |
5 |
Compreh. Inc |
|
|
|
|
|
|
|
|
|
|
|
|
| Comprehensive Inc |
|
|
|
|
|
|
|
$299.40 |
$167.70 |
$144.00 |
$101.70 |
$99.70 |
$196.40 |
<-12 mths |
|
|
|
|
Compreh. Inc |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ROE |
12.9% |
12.9% |
9.2% |
18.3% |
9.7% |
22.0% |
14.9% |
19.9% |
11.9% |
10.4% |
7.7% |
7.7% |
12.5% |
<-12 mths |
|
|
Net Income/Shareholders' equity |
|
|
|
|
|
|
|
|
|
|
|
|
| 5Yr Median |
12.2% |
12.9% |
12.9% |
12.9% |
12.9% |
12.9% |
14.9% |
18.3% |
14.9% |
14.9% |
11.9% |
10.4% |
10.4% |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Income |
$93.93 |
$100.55 |
$73.69 |
$162.50 |
$85.80 |
$305.10 |
$213.70 |
$299.40 |
$167.70 |
$144.00 |
$101.70 |
$99.70 |
$115.70 |
<-12 mths |
|
-0.84% |
<-Total Growth |
10 |
Net Income |
|
|
|
|
|
|
|
|
|
|
|
|
| Oper C. F. |
$315.80 |
$287.29 |
$293.37 |
$209.80 |
$324.20 |
$362.50 |
$430.20 |
$423.60 |
$588.70 |
$526.00 |
$263.80 |
$455.50 |
$385.30 |
<-12 mths |
|
|
Cash Flow Statement |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Invest. C. F |
-$175.65 |
-$275.99 |
-$407.68 |
-$301.90 |
-$288.00 |
$125.80 |
-$351.20 |
-$222.60 |
-$323.00 |
-$343.50 |
-$297.90 |
-$368.90 |
-$371.40 |
<-12 mths |
|
|
Cash Flow Statement |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Accurals |
-$46.22 |
$89.25 |
$187.99 |
$254.60 |
$49.60 |
-$183.20 |
$134.70 |
$98.40 |
-$98.00 |
-$38.50 |
$135.80 |
$13.10 |
$101.80 |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Assets |
$1,321.39 |
$1,468.17 |
$1,661.95 |
$1,619.30 |
$1,684.90 |
$2,964.1 |
$2,984.2 |
$2,923.5 |
$2,726.0 |
$2,653.0 |
$2,896.4 |
$2,875.3 |
$2,559.9 |
<-12 mths |
|
|
Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accruals Ratio |
-3.50% |
6.08% |
11.31% |
15.72% |
2.94% |
-6.18% |
4.51% |
3.37% |
-3.60% |
-1.45% |
4.69% |
0.46% |
3.98% |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chge in Cl |
11.31% |
73.36% |
-11.20% |
5.57% |
19.44% |
15.35% |
-20.20% |
17.23% |
-0.93% |
-21.73% |
-6.89% |
-14.93% |
17.30% |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Fin C. F. |
|
|
|
|
|
-$452.30 |
-$120.50 |
-$378.60 |
-$382.50 |
-$169.50 |
$137.80 |
-$257.70 |
-$230.60 |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Accurals |
-$46.22 |
$89.25 |
$187.99 |
$254.60 |
$49.60 |
$269.10 |
$255.20 |
$477.00 |
$284.50 |
$131.00 |
-$2.00 |
$270.80 |
$332.40 |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accruals Ratio |
-3.50% |
6.08% |
11.31% |
15.72% |
2.94% |
9.08% |
8.55% |
16.32% |
10.44% |
4.94% |
-0.07% |
9.42% |
12.98% |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| June 9,
2011. The last time I looked I got
2010 and 2011 estimates of $2.01 and $2.10 for earnings and $6.34 and $6.69
for cash flow. Expected earnings were way off. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Under new
accting rules Book Value decreases. If
I had used IFRS accounting rules for 2010, BV would $848 and 5 and 10 year
growth would be -9.21% and -.53% per
year, respectively. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jan 24,
2011. TD Newcrest moved this stock
from a buy to an action buy expecting a return of 32.7% return over the next
12 mths and a stock price of $36 FROM CURRENT $33. CHECK THIS LATER. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jan 5,
2010. When I looked last I got 2010
and 2011 earnings of $2.30 and $2.26 and cash flow of $6.43 and $6.65. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Apr 13,
2010. When I last looked at this stock
I picked up estimates for 2009 and 2010 for earnings of $2.91 and $2.95 and
cash flow of $6.85 and $7.15. Both were much lower. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| I looked at
Cash Flow (excluding non-cash working capital) re relationship to current
liquidity and payment of dividends and investments. CF does not cover div and Investments. An
Analyst remarked |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| that the
company is borrowing to pay dividends.
This is not true as cash flow can cover dividends. However, without borrowing they could not
pay for investments. This is not
necessarily bad. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| June 26,
2009. In reviewing estimates, I find
that I must reduce 2010 from $3.03 to $2.95.
I am holding 2009 at $2.91.
Once recession is over with, rethink this investment. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Apr 2009 AR
2008. Last review was September 2008
and I got estimates for earnings to be $2.60.
It came as $2.23, and way off the mark. However, lots of anaylsts are using the EPS
on continuing |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| operations,
and this came in at $2.98. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AP 2007. They did not do that well last year. Dividends do not increase yearly. I wonder if I should keep this? Became a
trading company Jan 7 1997 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AP 2006. My
stock has done well since I bought it.
Dividend is increasing nicely.
Stock increase moderate. Stock
is doing what I bought it for, that is good dividend and modest price
increases. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TD is no
longer optimistic on this stock.
Cannot go to an income trust, so less valuable. Expected price is 46, where it is now and
6% return for year. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| How they make
their money |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This company
is a full-service communications company.
It serves residential and business customers in Manitoba. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Their
Allstream division serves national business consumers. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|