| 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/ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TransCanada Corp |
|
|
|
TRP-T |
www.transcanada.com |
Fiscal Yr: |
Dec 31 |
|
TRP-N |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
GAAP |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| From 1996 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| From 1999 |
$11,917 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Revenue |
$11,856 |
$21,156 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gas Maketing |
$7,630 |
$16,760 |
|
|
|
|
|
|
|
|
Last 12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Revenue* |
$4,239 |
$4,384 |
$5,275 |
$5,214 |
$5,357 |
$5,107 |
$6,124 |
$7,520 |
$8,828 |
$8,619 |
$8,966 |
$8,064 |
|
|
|
83.94% |
<-Total Growth |
10 |
Revenue |
|
|
|
|
|
|
|
|
| Increase |
-22.08% |
3.42% |
20.32% |
-1.16% |
2.74% |
-4.67% |
19.91% |
22.80% |
17.39% |
-2.37% |
4.03% |
-10.06% |
|
|
|
6.28% |
<-IRR #YR-> |
10 |
Revenue |
|
|
|
|
|
|
|
|
| Rev per Share |
$8.93 |
$9.23 |
$11.07 |
$10.87 |
$11.09 |
$10.53 |
$12.57 |
$15.38 |
$16.36 |
$13.98 |
$13.10 |
$11.58 |
|
|
|
5.66% |
<-IRR #YR-> |
5 |
Revenue |
|
|
|
|
|
|
|
|
| Increase |
-23.85% |
3.34% |
19.89% |
-1.75% |
1.96% |
-5.00% |
19.34% |
22.36% |
6.35% |
-14.52% |
-6.29% |
-11.59% |
|
|
|
2.29% |
<-IRR #YR-> |
10 |
Rev per share |
|
|
|
|
|
|
|
|
| P/S (Price/Sales) |
1.43 |
1.77 |
1.79 |
2.11 |
2.51 |
2.83 |
2.92 |
2.64 |
2.48 |
2.37 |
2.76 |
3.28 |
|
|
|
-1.62% |
<-IRR #YR-> |
5 |
Rev per share |
|
|
|
|
|
|
|
|
| Averages |
|
|
|
|
|
|
|
P/S |
10 Yrs |
2.57 |
5 Yrs |
2.71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| *Revenue in
M CDN $ (2001 got out of Gas Marketing, restated to '99) (revenue from
different statements are different) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4,384 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$8,064 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6,124 |
$0 |
$0 |
$0 |
$0 |
$8,064 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9.23 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$11.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$12.57 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$11.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| From 1996 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| EPS* |
-$0.17 |
$1.45 |
$1.30 |
$1.55 |
$1.76 |
$2.12 |
$2.47 |
$2.20 |
$2.30 |
$2.52 |
$2.11 |
$1.78 |
$2.27 |
$2.44 |
D |
62.31% |
<-Total Growth |
10 |
Earnings |
|
|
|
|
|
|
|
|
| Increase |
-121.79% |
-952.94% |
-10.34% |
19.23% |
13.55% |
20.45% |
16.51% |
-10.93% |
4.55% |
9.57% |
-16.27% |
-15.64% |
27.53% |
7.49% |
|
2.07% |
<-IRR #YR-> |
10 |
Earnings |
|
|
|
|
|
|
|
|
| Earnings Yield |
-1.3% |
8.9% |
6.6% |
6.8% |
6.3% |
7.1% |
6.7% |
5.4% |
5.7% |
7.6% |
5.8% |
4.7% |
|
|
|
-6.34% |
<-IRR #YR-> |
5 |
Earnings |
|
|
|
|
|
|
|
|
| * ESP per
share (Cdn GAAP) |
|
|
|
|
|
|
E/P |
10 Yrs |
6.44% |
5Yrs |
5.67% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.45 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.47 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1996 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Div* |
$1.12 |
$0.80 |
$0.90 |
$1.00 |
$1.08 |
$1.16 |
$1.22 |
$1.28 |
$1.36 |
$1.44 |
$1.50 |
$1.58 |
$1.66 |
$1.68 |
|
97.50% |
<-Total Growth |
10 |
Dividends |
|
|
|
|
|
|
|
|
| Yearly Increase |
-5.08% |
-28.57% |
12.50% |
11.11% |
8.00% |
7.41% |
5.17% |
4.92% |
6.25% |
5.88% |
4.17% |
5.33% |
5.06% |
1.20% |
|
7.07% |
<-Average |
10 |
Dividends |
|
|
|
|
|
|
|
|
| Act. Increase |
-9.68% |
-28.57% |
12.50% |
11.11% |
8.00% |
7.41% |
5.17% |
4.92% |
6.25% |
5.88% |
1.39% |
5.56% |
5.26% |
5.26% |
|
6.07% |
<-Median-> |
10 |
|
|
|
|
|
|
|
|
|
| Aver H/L Yield |
6.61% |
5.91% |
5.00% |
4.66% |
4.36% |
4.16% |
3.65% |
3.57% |
3.53% |
4.03% |
4.58% |
4.32% |
|
|
|
4.24% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
| Yield on High |
5.09% |
4.64% |
4.26% |
4.18% |
3.83% |
3.83% |
3.25% |
3.13% |
3.27% |
3.57% |
4.13% |
4.04% |
|
|
|
3.83% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
| Yield on Low |
9.41% |
8.16% |
6.06% |
5.25% |
5.07% |
4.55% |
4.18% |
4.16% |
3.84% |
4.65% |
5.15% |
4.65% |
|
|
|
4.65% |
<-Median-> |
5 |
Dividends |
|
|
|
|
|
|
|
|
| Yield on Cl |
8.78% |
4.91% |
4.54% |
4.36% |
3.87% |
3.89% |
3.33% |
3.15% |
3.35% |
4.34% |
4.14% |
4.16% |
4.11% |
4.16% |
|
4.02% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
| Payout Ratio |
-658.82% |
55.17% |
69.23% |
64.52% |
61.36% |
54.72% |
49.39% |
58.18% |
59.13% |
57.14% |
71.09% |
88.76% |
73.13% |
68.85% |
|
60.25% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
| Payout Ratio CF |
41.01% |
22.09% |
37.79% |
24.99% |
27.39% |
33.05% |
31.25% |
30.16% |
25.88% |
31.26% |
34.33% |
35.69% |
33.20% |
33.60% |
|
31.26% |
<-Median-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
Div Yd |
5.30% |
in 5 yrs |
6.77% |
in 10 yrs |
Yield |
4.03% |
4.14% |
Payout |
59.13% |
31.26% |
|
|
|
7.04% |
<-IRR #YR-> |
10 |
Dividends |
|
|
|
|
|
|
|
|
| * Dividends per
share |
|
|
5.0% |
5 |
5.0% |
10 |
|
|
Last Div Inc ---> |
$0.40 |
$0.42 |
5.0% |
|
|
5.31% |
<-IRR #YR-> |
5 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.80 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.22 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| I am earning |
|
|
Trading |
$23.81 |
2000 |
7.06% |
RRSP |
$32.99 |
2006 |
5.09% |
Pension |
$33.15 |
2006 |
5.07% |
|
|
|
|
|
|
|
|
|
|
|
|
|
| H/LYield held 5 yrs |
5.97% |
4.51% |
4.18% |
3.51% |
3.84% |
6.84% |
9.02% |
7.12% |
6.33% |
5.81% |
5.38% |
4.73% |
4.63% |
|
|
5.84% |
Ave Yield on your |
|
Dividends |
|
|
|
|
|
|
|
|
| H/LYield held 10 yrs |
|
|
|
5.69% |
5.57% |
6.19% |
6.87% |
5.94% |
4.78% |
5.12% |
8.85% |
11.68% |
9.23% |
|
|
6.74% |
original money |
|
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Graham Price |
$18.42 |
$18.95 |
$18.25 |
$20.44 |
$22.34 |
$25.41 |
$30.19 |
$29.26 |
$30.63 |
$34.44 |
$33.06 |
$31.02 |
$35.03 |
$36.32 |
|
Cl Pr higher/lower by? |
|
Graham Price |
|
|
|
|
|
|
|
|
| Prem/Disc - High |
19.4% |
-9.0% |
15.8% |
16.9% |
26.3% |
19.3% |
24.4% |
39.8% |
35.7% |
17.2% |
9.8% |
26.0% |
|
|
|
25.71% |
<-Average |
5 |
Graham Price |
|
|
|
|
|
|
|
|
| Prem/Disc - Average |
-8.0% |
-28.6% |
-1.4% |
5.1% |
10.8% |
9.7% |
10.6% |
22.5% |
25.7% |
3.6% |
-1.0% |
17.8% |
|
|
|
13.71% |
<-Average |
5 |
Graham Price |
|
|
|
|
|
|
|
|
| Prem/Disc - Low |
-35.4% |
-48.3% |
-18.6% |
-6.8% |
-4.6% |
0.2% |
-3.3% |
5.2% |
15.7% |
-10.0% |
-11.9% |
9.6% |
|
|
|
1.72% |
<-Average |
5 |
Graham Price |
|
|
|
|
|
|
|
|
| Prem/Disc - Close |
-30.8% |
-14.0% |
8.6% |
12.1% |
24.8% |
17.3% |
21.4% |
38.8% |
32.4% |
-3.7% |
9.5% |
22.5% |
15.4% |
11.3% |
|
19.88% |
<-Average |
5 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Cl |
$12.75 |
$16.30 |
$19.82 |
$22.92 |
$27.88 |
$29.80 |
$36.65 |
$40.61 |
$40.54 |
$33.17 |
$36.19 |
$37.99 |
$40.42 |
$40.42 |
|
133.07% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| Increase |
-44.08% |
27.84% |
21.60% |
15.64% |
21.64% |
6.89% |
22.99% |
10.80% |
-0.17% |
-18.18% |
9.10% |
4.97% |
6.40% |
0.00% |
|
8.83% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| P/E |
-75.00 |
11.24 |
15.25 |
14.79 |
15.84 |
14.06 |
14.84 |
18.46 |
17.63 |
13.16 |
17.15 |
21.34 |
17.81 |
16.57 |
|
0.72% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
| Trailing P/E |
16.35 |
-95.88 |
13.67 |
17.63 |
17.99 |
16.93 |
17.29 |
16.44 |
18.43 |
14.42 |
14.36 |
18.00 |
22.71 |
17.81 |
|
14.06% |
<-IRR #YR-> |
10 |
Price & Div |
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
3.84% |
5.23% |
Div % Gth |
5, 10 yrs |
|
Price Inc |
4.97% |
P/E: Y-T |
17.63 |
16.44 |
|
|
|
4.56% |
<-IRR #YR-> |
5 |
Price & Div |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$16.30 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$37.99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$36.65 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$37.99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$16.30 |
$0.90 |
$1.00 |
$1.08 |
$1.16 |
$1.22 |
$1.28 |
$1.36 |
$1.44 |
$1.50 |
$39.57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$36.65 |
$1.28 |
$1.36 |
$1.44 |
$1.50 |
$39.57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price H/L Average |
$16.95 |
$13.53 |
$17.99 |
$21.48 |
$24.77 |
$27.89 |
$33.38 |
$35.84 |
$38.49 |
$35.69 |
$32.73 |
$36.55 |
|
|
|
170.24% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| Increase |
-39.79% |
-20.21% |
33.01% |
19.40% |
15.29% |
12.62% |
19.68% |
7.35% |
7.41% |
-7.27% |
-8.31% |
11.69% |
|
|
|
10.45% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| P/E |
-99.71 |
9.33 |
13.84 |
13.86 |
14.07 |
13.16 |
13.51 |
16.29 |
16.73 |
14.16 |
15.51 |
20.53 |
|
|
|
1.83% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
| Trailing P/E |
21.73 |
-79.56 |
12.41 |
16.52 |
15.98 |
15.85 |
15.75 |
14.51 |
17.50 |
15.52 |
12.99 |
17.32 |
|
|
|
16.42% |
<-IRR #YR-> |
10 |
Price & Div |
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
4.12% |
5.97% |
Div % Gth |
5, 10 yrs |
|
Price Inc |
7.35% |
P/E: Y-T |
16.29 |
15.52 |
|
|
|
5.95% |
<-IRR #YR-> |
5 |
Price & Div |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$13.53 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$36.55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$33.38 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$36.55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$13.53 |
$0.90 |
$1.00 |
$1.08 |
$1.16 |
$1.22 |
$1.28 |
$1.36 |
$1.44 |
$1.50 |
$38.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$33.38 |
$1.28 |
$1.36 |
$1.44 |
$1.50 |
$38.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dec |
Dec |
Oct-Dec |
Nov |
Aug |
Dec |
Oct |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Hi |
$22.00 |
$17.25 |
$21.13 |
$23.91 |
$28.21 |
$30.31 |
$37.56 |
$40.90 |
$41.55 |
$40.38 |
$36.31 |
$39.10 |
|
|
|
126.67% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| Increase |
-35.48% |
-21.59% |
22.49% |
13.16% |
17.98% |
7.44% |
23.92% |
8.89% |
1.59% |
-2.82% |
-10.08% |
7.68% |
|
|
|
8.53% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| P/E |
-129.41 |
11.90 |
16.25 |
15.43 |
16.03 |
14.30 |
15.21 |
18.59 |
18.07 |
16.02 |
17.21 |
21.97 |
|
|
|
0.81% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
| Trailing P/E |
28.21 |
-101.47 |
14.57 |
18.39 |
18.20 |
17.22 |
17.72 |
16.56 |
18.89 |
17.56 |
14.41 |
18.53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
1.59% |
P/E: Y-T |
18.07 |
17.56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$17.25 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$39.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$37.56 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$39.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Jul |
Mar |
Apr - Jun |
Aug |
Oct |
Mar |
Feb |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Low |
$11.90 |
$9.80 |
$14.85 |
$19.05 |
$21.32 |
$25.47 |
$29.20 |
$30.77 |
$35.43 |
$31.00 |
$29.14 |
$34.00 |
|
|
|
246.94% |
<-Total Growth |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| Increase |
-46.40% |
-17.65% |
51.53% |
28.28% |
11.92% |
19.47% |
14.64% |
5.38% |
15.14% |
-12.50% |
-6.00% |
16.68% |
|
|
|
13.25% |
<-IRR #YR-> |
10 |
Stock Price |
|
|
|
|
|
|
|
|
| P/E |
-70.00 |
6.76 |
11.42 |
12.29 |
12.11 |
12.01 |
11.82 |
13.99 |
15.40 |
12.30 |
13.81 |
19.10 |
|
|
|
3.09% |
<-IRR #YR-> |
5 |
Stock Price |
|
|
|
|
|
|
|
|
| Trailing P/E |
15.26 |
-57.65 |
10.24 |
14.65 |
13.75 |
14.47 |
13.77 |
12.46 |
16.10 |
13.48 |
11.56 |
16.11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Median 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
5.38% |
P/E: Y-T |
13.99 |
13.48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9.80 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$34.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$29.20 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$34.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Market Cap |
$6,050 |
$7,741 |
$9,447 |
$10,990 |
$13,472 |
$14,450 |
$17,857 |
$19,857 |
$21,882 |
$20,448 |
$24,767 |
$26,450 |
$28,142 |
|
|
$25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| excluding Nova |
|
|
|
|
|
|
|
|
Acquistion |
Public Offer |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| # of Shares (incl.Nova) |
474.53 |
474.91 |
476.63 |
479.50 |
483.20 |
484.91 |
487.24 |
488.98 |
539.77 |
616.47 |
684.36 |
696.23 |
696.23 |
696.23 |
|
|
Common Shares |
Shares |
|
|
|
|
|
|
|
|
| Increase |
2.33% |
0.08% |
0.36% |
0.60% |
0.77% |
0.35% |
0.48% |
0.36% |
10.39% |
14.21% |
11.01% |
1.73% |
0.00% |
0.00% |
|
4.03% |
<-Average |
10 |
Shares |
|
|
|
|
|
|
|
|
| CF fr Op $M |
$1,296 |
$1,720 |
$1,135 |
$1,919 |
$1,905 |
$1,702 |
$1,902 |
$2,075 |
$2,836 |
$2,840 |
$2,990 |
$3,082 |
$3,481 |
$3,481 |
|
79.19% |
<-Total Growth |
10 |
Cash Flow |
|
|
|
|
|
|
|
|
| OPS |
$2.73 |
$3.62 |
$2.38 |
$4.00 |
$3.94 |
$3.51 |
$3.90 |
$4.24 |
$5.25 |
$4.61 |
$4.37 |
$4.43 |
$5.00 |
$5.00 |
|
22.23% |
<-Total Growth |
10 |
Cash Flow |
|
|
|
|
|
|
|
|
| P/OCF on Cl |
4.67 |
4.50 |
8.32 |
5.73 |
7.07 |
8.49 |
9.39 |
9.57 |
7.72 |
7.20 |
8.28 |
8.58 |
8.08 |
8.08 |
|
2.03% |
<-IRR #YR-> |
10 |
Cash Flow |
|
|
|
|
|
|
|
|
| Non-Cash CF |
-$190.0 |
$416.0 |
-$170.0 |
-$33.0 |
-$112.0 |
-$34.0 |
$49.0 |
$303.0 |
-$215.0 |
$181.0 |
$90.0 |
$0.2 |
|
|
|
2.55% |
<-IRR #YR-> |
5 |
Cash Flow |
|
|
|
|
|
|
|
|
| OPS non-cash |
$2.33 |
$4.50 |
$2.02 |
$3.93 |
$3.71 |
$3.44 |
$4.00 |
$4.86 |
$4.86 |
$4.90 |
$4.50 |
$4.43 |
$5.00 |
$5.00 |
|
-0.16% |
<-IRR #YR-> |
10 |
CF - non cash |
|
|
|
|
|
|
|
|
| Increase |
-10.09% |
92.97% |
-54.98% |
94.27% |
-5.66% |
-7.30% |
16.41% |
21.45% |
-0.15% |
0.92% |
-8.16% |
-1.63% |
12.94% |
0.00% |
|
5.18% |
<-IRR #YR-> |
5 |
CF - non cash |
|
|
|
|
|
|
|
|
| Averages |
|
|
|
|
|
|
|
P/CF |
10 Yrs |
8.04 |
5 Yrs |
8.27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| *Operational
Cash Flow per share |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.62 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.43 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.90 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.43 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4.50 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.43 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.44 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.43 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| OPM |
30.57% |
39.23% |
21.52% |
36.80% |
35.56% |
33.33% |
31.06% |
27.59% |
32.13% |
32.95% |
33.35% |
38.22% |
|
|
|
should be zero, it is a check
on calculations |
|
|
|
|
|
|
|
|
|
|
|
| Diff from Ave |
-5.2% |
21.7% |
-33.3% |
14.1% |
10.3% |
3.3% |
-3.7% |
-14.4% |
-0.4% |
2.2% |
3.4% |
18.5% |
|
|
|
0.00% |
<-Average |
10 |
OPM |
|
|
|
|
|
|
|
|
| *Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
OPM |
10 Yrs |
32.25% |
5 Yrs |
32.85% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Curr Assets |
$2,873 |
$5,383 |
$1,174 |
$1,183 |
$1,196 |
$1,109 |
$1,566 |
$2,092 |
$2,305 |
$3,600 |
$3,175 |
$3,237 |
|
|
|
Liq ratio of 1.5 and up, best |
|
Assets |
|
|
|
|
|
|
|
|
| Curr Liab. |
$6,251 |
$3,775 |
$2,153 |
$2,252 |
$2,231 |
$2,744 |
$3,112 |
$2,989 |
$3,035 |
$4,930 |
$4,949 |
$5,661 |
|
|
|
0.59 |
<-Average |
10 |
Liabilities |
|
|
|
|
|
|
|
|
| Liquidity |
0.46 |
1.43 |
0.55 |
0.53 |
0.54 |
0.40 |
0.50 |
0.70 |
0.76 |
0.73 |
0.64 |
0.57 |
|
|
|
0.68 |
<-Average |
5 |
Ratio |
|
|
|
|
|
|
|
|
| Liq. with CF aft div |
0.58 |
1.78 |
0.87 |
1.16 |
1.16 |
0.82 |
0.92 |
1.18 |
1.45 |
1.13 |
1.04 |
0.92 |
|
|
|
1.14 |
<-Average |
5 |
|
|
|
|
|
|
|
|
|
| Excl.Long Term Port. |
|
|
|
|
|
|
|
|
|
|
$690 |
$959 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.75 |
0.69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Assets |
$24,969 |
$25,548 |
$19,904 |
$19,916 |
$20,544 |
$22,130 |
$24,113 |
$25,909 |
$30,330 |
$39,141 |
$43,841 |
$46,589 |
|
|
|
A/L ratio of 1.5 and up, best |
Assets |
|
|
|
|
|
|
|
|
| Liab. |
$20,034 |
$20,318 |
$14,478 |
$13,156 |
$13,310 |
$15,157 |
$16,124 |
$17,453 |
$19,546 |
$25,322 |
$26,908 |
$28,705 |
|
|
|
1.52 |
<-Average |
10 |
Liabilities |
|
|
|
|
|
|
|
|
| Asset/Liability Ratio |
1.25 |
1.26 |
1.37 |
1.51 |
1.54 |
1.46 |
1.50 |
1.48 |
1.55 |
1.55 |
1.63 |
1.62 |
|
|
|
1.57 |
<-Average |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Non-Control Int. |
|
|
|
|
|
|
|
|
|
|
$1,174 |
$1,157 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Book Value |
$4,935 |
$5,230 |
$5,426 |
$5,747 |
$6,091 |
$6,565 |
$7,989 |
$8,456 |
$9,785 |
$12,898 |
$15,759 |
$16,727 |
$16,727 |
$16,727 |
|
219.83% |
<-Total Growth |
10 |
Book Value |
|
|
|
|
|
|
|
|
| BV per share |
$10.40 |
$11.01 |
$11.38 |
$11.99 |
$12.61 |
$13.54 |
$16.40 |
$17.29 |
$18.13 |
$20.92 |
$23.03 |
$24.03 |
$24.03 |
$24.03 |
|
118.16% |
<-Total Growth |
10 |
Book Value |
|
|
|
|
|
|
|
|
| Change |
-9.84% |
5.89% |
3.37% |
5.28% |
5.17% |
7.40% |
21.11% |
5.47% |
4.83% |
15.41% |
10.06% |
4.33% |
0.00% |
0.00% |
|
85.73% |
Current/Historical |
|
Book Value |
|
|
|
|
|
|
|
|
| P/BV (CL) |
1.23 |
1.48 |
1.74 |
1.91 |
2.21 |
2.20 |
2.24 |
2.35 |
2.24 |
1.59 |
1.57 |
1.58 |
1.68 |
1.68 |
|
8.11% |
<-IRR #YR-> |
10 |
Book Value |
|
|
|
|
|
|
|
|
| Change |
-37.97% |
20.73% |
17.63% |
9.84% |
15.66% |
-0.48% |
1.55% |
5.06% |
-4.77% |
-29.11% |
-0.87% |
0.61% |
6.40% |
0.00% |
|
7.94% |
<-IRR #YR-> |
5 |
Book Value |
|
|
|
|
|
|
|
|
| Leverage (A/BK) |
5.06 |
4.88 |
3.67 |
3.47 |
3.37 |
3.37 |
3.02 |
3.06 |
3.10 |
3.03 |
2.78 |
2.79 |
0.00 |
0.00 |
|
3.17 |
<-Average |
10 |
A/BV |
|
|
|
|
|
|
|
|
| Debt/Equity Ratio |
4.06 |
3.88 |
2.67 |
2.29 |
2.19 |
2.31 |
2.02 |
2.06 |
2.00 |
1.96 |
1.71 |
1.72 |
|
|
|
2.09 |
<-Average |
10 |
Debt/Eq Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
P/BV |
10 Yrs |
1.96 |
5 Yrs |
1.86 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11.01 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$24.03 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$16.40 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$24.03 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ROE |
|
|
|
|
|
|
|
12.8% |
10.6% |
10.4% |
7.7% |
6.1% |
|
|
|
10.4% |
<-Median-> |
5 |
Compreh. Inc |
|
|
|
|
|
|
|
|
| Comprehensive Inc |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$1,079 |
$1,036 |
$1,341 |
$1,220 |
$1,027 |
|
|
|
|
|
|
Compreh. Inc |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ROE |
9.2% |
13.2% |
11.4% |
13.0% |
14.0% |
13.0% |
15.1% |
12.8% |
12.6% |
11.2% |
8.7% |
7.3% |
|
|
|
Net Income/Shareholders'
equity |
|
|
|
|
|
|
|
|
|
|
|
| 5 year Median |
|
8.0% |
9.2% |
11.4% |
13.0% |
13.0% |
13.0% |
13.0% |
13.0% |
12.8% |
12.6% |
11.2% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Income |
$452 |
$689 |
$619 |
$747 |
$851 |
$851 |
$1,209 |
$1,079 |
$1,233 |
$1,440 |
$1,374 |
$1,227 |
|
|
|
78.08% |
<-Total Growth |
10 |
Net Income |
|
|
|
|
|
|
|
|
| Oper C. F. |
$1,296 |
$1,720 |
$1,135 |
$1,919 |
$1,905 |
$1,702 |
$1,902 |
$2,075 |
$2,836 |
$2,840 |
$2,990 |
$3,082 |
|
|
|
Cash Flow Statement |
|
|
|
|
|
|
|
|
|
|
| Invest. C. F |
-$1,180 |
$1,279 |
$123 |
-$942 |
-$1,151 |
-$1,606 |
-$1,336 |
-$2,116 |
-$6,207 |
-$6,503 |
-$6,913 |
-$5,420 |
|
|
|
Cash Flow Statement |
|
|
|
|
|
|
|
|
|
|
| Total Accurals |
$336 |
-$2,310 |
-$639 |
-$230 |
$97 |
$755 |
$643 |
$1,120 |
$4,604 |
$5,103 |
$5,297 |
$3,565 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Assets |
$24,969 |
$25,548 |
$19,904 |
$19,916 |
$20,544 |
$22,130 |
$24,113 |
$25,909 |
$30,330 |
$39,141 |
$43,841 |
$46,589 |
|
|
|
Balance Sheet |
|
|
|
|
|
|
|
|
|
|
| Accruals Ratio |
1.35% |
-9.04% |
-3.21% |
-1.15% |
0.47% |
3.41% |
2.67% |
4.32% |
15.18% |
13.04% |
12.08% |
7.65% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chge in Cl |
-44.08% |
27.84% |
21.60% |
15.64% |
21.64% |
6.89% |
22.99% |
10.80% |
-0.17% |
-18.18% |
9.10% |
4.97% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Fin. C. F |
-$60 |
-$2,901 |
-$1,468 |
-$1,064 |
-$628 |
$159 |
-$556 |
$219 |
$3,526 |
$4,369 |
$3,722 |
$2,113 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Accurals |
$396 |
$591 |
$829 |
$834 |
$725 |
$596 |
$1,199 |
$901 |
$1,078 |
$734 |
$1,575 |
$1,452 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accruals Ratio |
1.59% |
2.31% |
4.16% |
4.19% |
3.53% |
2.69% |
4.97% |
3.48% |
3.55% |
1.88% |
3.59% |
3.12% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| CF net |
|
|
|
|
|
|
|
|
$155 |
$706 |
-$201 |
-$225 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Foreign cur etc |
|
|
|
|
|
|
|
|
-$50 |
$98 |
-$110 |
-$8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Inc/Dec in Cash |
|
|
|
|
|
|
|
|
$105 |
$804 |
-$311 |
-$233 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
|
|
|
|
|
|
|
$399 |
$504 |
$1,308 |
$997 |
$764 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Used the
Investment Reporter figures to fill in missing ones, but they certainly did
not agree with company statements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| * D =
Decrease, I = Increase, U = Unchanged |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mar 23,
2011. Last I looked I got estimates
for 2010 and 2011 of $2.03 and $2.44 for earnings and $3.90 and $5.00 for
Cash Flow. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jul 9,
2010. When I last looked I got 2010
and 2011 earnings of $2.12 and 2.44 and CF of $4.58 and $5.12. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Apr 10,
2010. When I last looked at this
stock, I got 2009 and 2010 earnings of $2.00 and $2.20 and cash Flow of $3.60
and $4.65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dec 9,
2009. when I last looked at this stock
in April 2009, I got earnings for 2009 and 2010 of $2.28 and $2.55. I also got CF for $4.69 and $5.14. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AP
2008. In July 2008 EPS estimate was
$2.25. In Annual report Basic is $2.53
and Diluted $2.52. They erred on the
downside. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AP2007. This stock has not done badly over last 5
years. A number of people like
it. Keep for now. TD rates it as a
buy, with low risk. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AP
2006. I have only made money on this
stock. This is because I bought it at
a great time when it had decreased it's dividend. It is on TD's action buy
list. Keep for now. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2005. This stock is doing ok and I will keep at
present. Some think this is a long
term stock to keep. I will keep an eye
on it. Earnings are up and Dividends
are higher than when they first cut them. |
|
|
|
|
|
|
|
|
|
|
| 2004. My IRR
since Feb 2000 is 25%, but then I bought at an opportune time. Doing fine
since problems of 2000. TD has it at
buy rating. Keep eye on. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2003. 8%
return is not bad. Has good
dividend. Should see if I want to keep
through. 2003 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2000. Bought because stock was depressed after
the dividend cut. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| How they make
their money |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TransCanada
is a leader in energy infrastructure. Their network of pipeline taps into
virtually all major gas supply basins in North America. TransCanada is one of
the continent’s largest providers of gas storage |
|
|
|
|
|
|
|
|
|
| and related
services. It is a growing independent
power producer. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| May 29,
2008 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TransCanada
announced in March that it would be acquiring a substantial generating
station in Queens, New York for $2.8 billion. Analysts believe, given the
size of the deal, TransCanada will not be increasing |
|
|
|
|
|
|
|
|
|
|
| its dividend
any time soon (time will tell). But is this really so bad if, in the
long-term, the integration of this generation station will mean more free
cash flow to increase dividends aggressively in the future? |
|
|
|
|
|
|
|
|
|
|
| Pipelines
are heavily regulated industries with prices set by governments. The result
is that profit margins get squeezed over time (after all, the government
needs to be perceived as keeping energy prices low) |
|
|
|
|
|
|
|
|
|
|
| and, as a
shareholder, I would rather have TransCanada use some cash now to expand the
business than let its business decline over time (and, yes, I added to my
position in the bought deal at $36.50/share). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|