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. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
TransCanada Corp TSX: TRP NYSE TRP www.transcanada.com Fiscal Yr: Dec 31
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item
Accounting Rules C GAAP C GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP Accounting Rules
Revenue* $6,124 $7,520 $8,828 $8,619 $8,966 $8,064 $9,139 $8,007 $8,797 $10,185 $11,300 $12,505 $12,357 $14,132 $13,253 66.29% <-Total Growth 10 Revenue
Increase 19.91% 22.80% 17.39% -2.37% 4.03% -10.06% 13.33% -12.39% 9.87% 15.78% 10.95% 10.66% -1.18% 14.36% -6.22% 5.22% <-IRR #YR-> 10 Revenue 66.29%
5 year Running Average $5,415 $5,864 $6,587 $7,240 $8,011 $8,399 $8,723 $8,559 $8,595 $8,838 $9,486 $10,159 $11,029 $12,096 $12,709 6.47% <-IRR #YR-> 5 Revenue 36.83%
Revenue per Share $12.57 $15.38 $16.36 $13.98 $13.10 $11.58 $12.98 $11.35 $12.43 $14.37 $16.08 $14.48 $14.31 $16.36 $15.34 5.65% <-IRR #YR-> 10 5 yr Running Average 73.23%
Increase 19.34% 22.36% 6.35% -14.52% -6.29% -11.59% 12.10% -12.59% 9.56% 15.58% 11.90% -9.98% -1.18% 14.36% -6.22% 3.09% <-IRR #YR-> 5 5 yr Running Average 16.46%
5 year Running Average $11.23 $12.09 $13.18 $13.76 $14.28 $14.08 $13.60 $12.60 $12.29 $12.54 $13.44 $13.74 $14.33 $15.12 $15.31 -0.60% <-IRR #YR-> 10 Revenue per Share -5.86%
P/S (Price/Sales) Med 2.66 2.33 2.35 2.55 2.50 3.16 3.11 3.89 3.81 3.78 3.10 3.64 2.20% <-IRR #YR-> 5 Revenue per Share 11.50%
P/S (Price/Sales) Close 2.92 2.64 2.48 2.37 2.76 3.28 3.43 4.14 3.90 3.97 2.81 4.18 4.19 3.67 3.91 1.29% <-IRR #YR-> 10 5 yr Running Average 13.70%
*Revenue in M CDN $ (2001 got out of Gas Marketing, restated to '99) (revenue from different statements are different) P/S Med 10 yr 3.13 5 yr 3.78 33.82% Diff M/C 0.21% <-IRR #YR-> 5 5 yr Running Average 1.05%
-$7,520 $0 $0 $0 $0 $0 $0 $0 $0 $0 $12,505
-$9,139 $0 $0 $0 $0 $12,505
-$5,864 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,159
-$8,723 $0 $0 $0 $0 $10,159
-$15.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.48
-$12.98 $0.00 $0.00 $0.00 $0.00 $14.48
-$12.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.74
-$13.60 $0.00 $0.00 $0.00 $0.00 $13.74
Income Generated by Operations $1,951 $2,378 $2,621 $3,021 $3,080 $3,161 $3,451 $3,284
Per Share $4.01 $4.85 $4.92 $5.29 $4.72 $4.57 $4.91 $4.65
AFFO* $4.60 $4.01 $4.82 $5.18 $5.00 $4.83 $4.18 $5.08 5.00% <-Total Growth 5 AFFO From TD TRP=DI
Increase -12.83% 20.20% 7.47% -3.47% -3.40% -13.46% 21.53% 0.98% <-IRR #YR-> 5 AFFO #DIV/0!
AFFO Yield 10.3% 8.5% 9.9% 9.1% 11.1% 8.0% 7.0% 8.5% 0.98% <-IRR #YR-> 5 AFFO 5.00%
5 year Running Average $4.72 $4.77 $4.80 $4.85 0.97% <-IRR #YR-> 1 5 yr Running Average #DIV/0!
Payout Ratio 36.09% 43.39% 37.76% 36.68% 40.80% 46.79% 58.37% 49.21% 0.97% <-IRR #YR-> 1 5 yr Running Average #DIV/0!
5 year Running Average 38.80% 40.94% 43.57% 45.90% 0.40 <-Median-> 2 PR 5 year Running Average
Price/AFFO Median 8.78 11.01 9.83 10.50 9.97 10.92 14.95 10.23 <-Median-> 6 P/AFFO Med
Price/AFFO High 9.66 11.75 10.54 11.85 11.73 13.07 15.42 11.74 <-Median-> 6 P/AFFO High
Price/AFFO Low 7.90 10.27 9.13 9.14 8.20 8.77 14.47 8.95 <-Median-> 6 P/AFFO Low
Price/AFFO Close 9.68 11.73 10.07 11.02 9.04 12.53 14.35 10.55 <-Median-> 6 P/AFFO Close
Trailing P/AFFO Close 10.22 12.10 11.85 8.72 12.11 12.42 11.85 <-Median-> 5 Trailing P/AFFO Close
Median Values DPR 10 Yrs 39.28% 5 Yrs†† 40.80% P/CF 5 Yrs†† in order 10.50 11.75 9.13 11.02 36.71% Diff M/C 40.23% Diff M/C 10 DPR 75% to 95% best
* Adjusted Funds From Operations
-$4.60 $0.00 $0.00 $0.00 $0.00 $4.83
-$4.60 $0.00 $0.00 $0.00 $0.00 $4.83
-$4.72 $4.77
-$4.72 $4.77
Adjusted EPS From 2015 $2.47 $2.20 $2.30 $2.52 $2.11 $1.77 $2.17 $1.84 $2.42 $2.46 $2.48 $2.78 $2.86 $3.08 $3.21 26.36% <-Total Growth 10 Adjusted EPS 2015 From TD
Increase -10.93% 4.55% 9.57% -16.27% -16.11% 22.60% -15.21% 31.52% 1.65% 0.81% 12.10% 2.88% 7.69% 4.22% 2.37% <-IRR #YR-> 10 Adjusted EPS 26.36%
Adjusted EPS Yield 6.74% 5.42% 5.67% 7.60% 5.83% 4.66% 4.87% 3.91% 4.99% 4.31% 5.49% 4.59% 4.77% 5.14% 5.35% 5.08% <-IRR #YR-> 5 Adjusted EPS 28.11%
5 year Running Average $2.32 $2.18 $2.17 $2.08 $2.06 $2.13 $2.27 $2.40 $2.60 $2.73 $2.88 1.59% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
Payout Ratio 49.39% 58.18% 59.13% 57.14% 71.09% 89.27% 76.50% 94.57% 75.21% 77.24% 82.26% 81.29% 85.31% 81.17% 77.88% 1.96% <-IRR #YR-> 5 5 yr Running Average 10.21%
5 year Running Average 58.62% 65.69% 69.37% 76.08% 80.50% 81.61% 80.56% 81.47% 80.46% 81.55% 81.47% 78.29% <-Median-> 8 Payout 5 yr Running Average
Price/AEPS Median 13.51 16.29 16.73 14.16 15.51 20.65 18.61 23.99 19.58 22.10 20.10 18.97 21.85 19.28 <-Median-> 10 Price/AEPS Median
Price/AEPS High 15.21 18.59 18.07 16.02 17.21 22.09 20.48 25.60 20.99 24.95 23.66 22.71 22.54 21.54 <-Median-> 10 Price/AEPS High
Price/AEPS Low 11.82 13.99 15.40 12.30 13.81 19.21 16.74 22.39 18.18 19.25 16.54 15.24 21.15 16.64 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 14.84 18.46 17.63 13.16 17.15 21.46 20.52 25.55 20.06 23.21 18.22 21.78 20.97 19.47 18.69 20.29 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 16.44 18.43 14.42 14.36 18.00 25.16 21.67 26.38 23.60 18.37 24.41 21.58 20.97 19.47 20.05 <-Median-> 10 Trailing P/AEPS Close
Median Values DPR 10 Yrs 76.87% 5 Yrs†† 81.29% P/CF 5 Yrs†† in order 20.10 23.66 18.18 21.78 4.34% Diff M/C 8.78% Diff M/C 10 DPR 75% to 95% best
-$2.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.78
-$2.17 $0.00 $0.00 $0.00 $0.00 $2.78
-$2.18 $0.00 $0.00 $0.00 $0.00 $0.00 $2.40
-$2.17 $0.00 $0.00 $0.00 $0.00 $2.40
EPS Basic $2.49 $2.21 $2.31 $2.53 $2.11 $1.78 $2.17 $1.84 $2.42 $2.46 -$1.75 $0.16 -92.76% <-Total Growth 10 EPS Basic
From 1996
EPS Diluted* $2.47 $2.20 $2.30 $2.52 $2.11 $1.77 $2.17 $1.84 $2.42 $2.46 -$1.75 $0.16 $3.00 $3.20 $3.09 -92.73% <-Total Growth 10 EPS Diluted
Increase 16.51% -10.93% 4.55% 9.57% -16.27% -16.11% 22.60% -15.21% 31.52% 1.65% -171.14% -109.14% 1775.00% 6.67% -3.44% -23.06% <-IRR #YR-> 10 Earnings per Share -92.73%
Earnings Yield 6.7% 5.4% 5.7% 7.6% 5.8% 4.7% 4.9% 3.9% 5.0% 4.3% -3.9% 0.3% 5.0% 5.3% 5.2% -40.63% <-IRR #YR-> 5 Earnings per Share -92.63%
5 year Running Average $1.84 $2.02 $2.17 $2.32 $2.32 $2.18 $2.17 $2.08 $2.06 $2.13 $1.43 $1.03 $1.26 $1.41 $1.54 -6.55% <-IRR #YR-> 10 5 yr Running Average -49.21%
10 year Running Average $1.46 $1.50 $1.58 $1.75 $1.98 $2.01 $2.10 $2.13 $2.19 $2.23 $1.80 $1.60 $1.67 $1.74 $1.84 -13.94% <-IRR #YR-> 5 5 yr Running Average -52.81%
* Diluted ESP per share E/P 10 Yrs 4.77% 5Yrs 3.91%
-$2.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16
-$2.17 $0.00 $0.00 $0.00 $0.00 $0.16
-$2.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.03
-$2.17 $0.00 $0.00 $0.00 $0.00 $1.03
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
From 1996 From 1996
Dividend* $1.22 $1.28 $1.36 $1.44 $1.50 $1.58 $1.66 $1.74 $1.82 $1.90 $2.04 $2.26 $2.44 $2.50 $2.50 76.56% <-Total Growth 10 Dividends
Increase 5.17% 4.92% 6.25% 5.88% 4.17% 5.33% 5.06% 4.82% 4.60% 4.40% 7.37% 10.78% 7.96% 2.46% 0.00% Count 27 Years of data
Dividends 5 Yr Running $1.07 $1.15 $1.22 $1.29 $1.36 $1.43 $1.51 $1.58 $1.66 $1.74 $1.83 $1.95 $2.09 $2.23 $2.35 70.03% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 3.65% 3.57% 3.53% 4.03% 4.58% 4.32% 4.11% 3.94% 3.84% 3.49% 4.09% 4.28% 3.90% 4.06% <-Median-> 10 Yield H/L Price
Yield on HighPrice 3.25% 3.13% 3.27% 3.57% 4.13% 4.04% 3.73% 3.69% 3.58% 3.10% 3.48% 3.58% 3.78% 3.58% <-Median-> 10 Yield on HighPrice
Yield on Low Price 4.18% 4.16% 3.84% 4.65% 5.15% 4.65% 4.57% 4.22% 4.14% 4.01% 4.97% 5.34% 4.03% 4.61% <-Median-> 10 Yield on Low Price
Yield on Close Price 3.33% 3.15% 3.35% 4.34% 4.14% 4.16% 3.73% 3.70% 3.75% 3.33% 4.51% 3.73% 4.07% 4.17% 4.17% 3.74% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 49.39% 58.18% 59.13% 57.14% 71.09% 89.27% 76.50% 94.57% 75.21% 77.24% -116.57% 1412.50% 81.33% 78.13% 80.91% 75.85% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 58.26% 56.83% 56.22% 55.64% 58.62% 65.69% 69.37% 76.08% 80.50% 81.61% 128.29% 190.25% 166.30% 157.57% 152.47% 72.72% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 31.25% 30.16% 25.88% 31.26% 34.33% 35.69% 29.41% 34.37% 35.04% 33.01% 34.83% 38.51% 44.04% 42.09% 34.82% 34.35% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 30.22% 29.28% 29.25% 30.02% 30.39% 31.27% 31.03% 32.85% 33.61% 33.36% 33.29% 35.19% 37.07% 38.47% 38.64% 32.06% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 30.47% 26.32% 28.01% 29.38% 33.33% 35.69% 31.90% 37.38% 32.19% 31.55% 31.76% 40.49% 44.04% 42.09% 34.82% 32.04% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 31.32% 28.77% 29.22% 29.28% 29.41% 30.41% 31.56% 33.44% 33.96% 33.51% 32.76% 34.44% 35.80% 37.75% 38.29% 32.16% <-Median-> 10 DPR CF WC 5 Yr Running
Median 5 Yrs 5 Yr Med 5 Yr Cl 3.94% 3.73% 5 Yr Med Payout 77.24% 34.83% 32.19% 5.85% <-IRR #YR-> 10 Dividends 76.56%
* Dividends per share 5 Yr Med and Cur. 5.75% 11.65% Last Div Inc ---> $0.57 $0.63 10.6% 6.37% <-IRR #YR-> 5 Dividends 36.14%
-$1.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.26
-$1.66 $0.00 $0.00 $0.00 $0.00 $2.26
Historical Dividends Historical High Div 6.50% Low Div 3.22% Ave Div 4.86% Med Div 4.28% Close Div 4.16% Historical Dividends
High/Ave/Median Values Curr diff Exp. -35.88% ††† 29.44% Exp. -14.24% Exp. -2.62% Cheap 0.22% High/Ave/Median
Future Dividend Yield Div Yd 5.37% earning in 5 Years at IRR of 5.20% Div Inc. 28.85% Future Dividend Yield
Future Dividend Yield Div Yd 6.92% earning in 10 Years at IRR of 5.20% Div Inc. 66.02% Future Dividend Yield
Future Dividend Yield Div Yd 8.92% earning in 15 Years at IRR of 5.20% Div Inc. 113.91% Future Dividend Yield
Future Dividend Yield Div Yd 6.33% earning in 5 Years at IRR of 8.70% Div Inc. 51.76% Future Dividend Yield
Future Dividend Yield Div Yd 9.60% earning in 10 Years at IRR of 8.70% Div Inc. 130.30% Future Dividend Yield
Future Dividend Yield Div Yd 14.57% earning in 15 Years at IRR of 8.70% Div Inc. 249.50% Future Dividend Yield
I am earning GC Div Gr 205.00% 2/3/00 # yrs -> 16 2000 $12.01 Cap Gain 399.42% I am earning GC
I am earning Div org yield 6.66% 12/31/14 Trading Div G Yrly 7.76% Div start $0.80 -6.66% 20.32% I am earning Div
I am earning GC Div Gr 90.63% 6/12/06 # yrs -> 10 2006 $33.15 Cap Gain 80.94% I am earning GC
I am earning Div org yield 3.86% 12/31/14 Pension Div G Yrly 7.83% Div start $1.28 -3.86% 7.36% I am earning Div
I am earning GC Div Gr 90.63% 6/12/06 # yrs -> 10 2006 $32.99 Cap Gain 81.81% I am earning GC
I am earning Div org yield 3.88% 12/31/14 RRSP Div G Yrly 7.83% Div start $1.28 -3.88% 7.40% I am earning Div
Yield if held 5 yrs 9.02% 7.12% 6.33% 5.81% 5.38% 4.73% 4.63% 4.52% 5.10% 5.81% 5.58% 5.60% 5.53% 5.27% 4.60% 5.48% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 6.87% 5.94% 4.78% 5.12% 8.85% 11.68% 9.23% 8.10% 7.35% 6.81% 6.11% 6.31% 6.34% 7.00% 7.64% 7.08% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 7.63% 7.50% 7.74% 7.43% 8.00% 8.90% 7.71% 6.11% 6.47% 11.21% 15.08% 12.56% 11.36% 10.09% 8.96% 7.87% <-Median-> 10 Paid Median Price
Yield if held 20 yrs 9.88% 9.73% 9.91% 9.39% 10.13% 11.49% 10.49% 8.57% 8.88% 14.75% 9.91% <-Median-> 7 Paid Median Price
Yield if held 25 yrs 12.75% 13.24% 13.89% 12.90% 13.33% 13.00% <-Median-> 2 Paid Median Price
Cost covered if held 5 years 39.63% 31.91% 28.40% 26.09% 24.38% 21.45% 21.04% 20.58% 23.26% 26.59% 25.06% 24.17% 23.69% 23.50% 21.59% 24.27% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 60.51% 50.70% 38.98% 40.36% 69.26% 92.57% 73.82% 65.27% 59.60% 55.58% 48.89% 48.28% 47.75% 54.47% 62.46% 57.59% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 94.19% 91.53% 92.24% 86.61% 92.48% 100.85% 85.70% 66.80% 69.84% 120.59% 160.30% 128.07% 113.97% 104.58% 97.67% 92.36% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 138.94% 135.72% 137.34% 129.45% 138.88% 152.45% 131.01% 103.53% 109.41% 189.85% 137.34% <-Median-> 7 Paid Median Price
Cost covered if held 25 years 196.19% 192.91% 196.90% 186.94% 201.49% 194.55% <-Median-> 2 Paid Median Price
Graham Price $30.19 $29.26 $30.63 $33.72 $31.75 $29.78 $33.42 $30.34 $35.86 $36.24 $33.14 $9.19 $39.81 $41.11 $40.40 -68.58% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.11 1.22 1.26 1.06 1.03 1.23 1.21 1.45 1.32 1.50 1.50 5.74 1.57 1.29 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.24 1.40 1.36 1.20 1.14 1.31 1.33 1.55 1.42 1.69 1.77 6.87 1.62 1.39 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.97 1.05 1.16 0.92 0.92 1.14 1.09 1.36 1.23 1.31 1.24 4.61 1.52 1.19 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.21 1.39 1.32 0.98 1.14 1.28 1.33 1.55 1.35 1.58 1.36 6.59 1.51 1.46 1.48 1.34 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 21.41% 38.80% 32.36% -1.62% 13.97% 27.57% 33.25% 54.97% 35.34% 57.56% 36.37% 558.55% 50.68% 45.89% 48.47% 34.30% <-Median-> 10 Graham Price
Price Close $36.65 $40.61 $40.54 $33.17 $36.19 $37.99 $44.53 $47.02 $48.54 $57.10 $45.19 $60.54 $59.98 $59.98 $59.98 49.08% <-Total Growth 10 Stock Price
Increase 22.99% 10.80% -0.17% -18.18% 9.10% 4.97% 17.22% 5.59% 3.23% 17.63% -20.86% 33.97% -0.93% 0.00% 0.00% 4.07% <-IRR #YR-> 10 Stock Price
P/E 14.84 18.46 17.63 13.16 17.15 21.46 20.52 25.55 20.06 23.21 -25.82 378.38 19.99 18.74 19.41 6.34% <-IRR #YR-> 5 Stock Price
Trailing P/E 17.29 16.44 18.43 14.42 14.36 18.00 25.16 21.67 26.38 23.60 18.37 -34.59 374.88 19.99 18.74 7.58% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.per yr 3.51% 3.86% % Tot Ret 46.28% 37.86% Price Inc 5.59% P/E: 20.29 23.21 10.20% <-IRR #YR-> 5 Price & Dividend
-$40.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $60.54
-$44.53 $0.00 $0.00 $0.00 $0.00 $60.54
-$40.61 $1.36 $1.44 $1.50 $1.58 $1.66 $1.74 $1.82 $1.90 $2.04 $62.80
-$44.53 $1.74 $1.82 $1.90 $2.04 $62.80
Price H/L Median $33.38 $35.84 $38.49 $35.69 $32.73 $36.55 $40.39 $44.15 $47.40 $54.37 $49.85 $52.75 $62.49 47.20% <-Total Growth 10 Stock Price
Increase 19.68% 7.35% 7.41% -7.27% -8.31% 11.69% 10.49% 9.31% 7.36% 14.72% -8.32% 5.83% 18.45% 3.94% <-IRR #YR-> 10 Stock Price
P/E 13.51 16.29 16.73 14.16 15.51 20.65 18.61 23.99 19.58 22.10 -28.48 329.69 20.83 5.49% <-IRR #YR-> 5 Stock Price
Trailing P/E 15.75 14.51 17.50 15.52 12.99 17.32 22.82 20.34 25.76 22.47 20.26 -30.14 390.53 7.94% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 18.14 17.74 17.74 15.37 14.11 16.77 18.58 21.20 22.98 25.50 34.91 51.41 49.67 9.81% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 22.93 23.94 24.42 20.39 16.54 18.18 19.26 20.76 21.62 24.42 27.63 32.97 37.42 14.04 P/E Ratio Historical Median
Median 10, 5 Yrs D.per yr 4.00% 4.32% % Tot Ret 50.34% 44.06% Price Inc 7.36% P/E: 19.10 22.10 Count 27 Years of data
-$35.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.75
-$40.39 $0.00 $0.00 $0.00 $0.00 $52.75
-$35.84 $1.36 $1.44 $1.50 $1.58 $1.66 $1.74 $1.82 $1.90 $2.04 $55.01
-$40.39 $1.74 $1.82 $1.90 $2.04 $55.01
Dec Oct-Dec Nov Aug Dec Oct Dec Dec May Sep May Sep Jan
Price High $37.56 $40.90 $41.55 $40.38 $36.31 $39.10 $44.45 $47.10 $50.79 $61.38 $58.67 $63.14 $64.47 54.38% <-Total Growth 10 Stock Price
Increase 23.92% 8.89% 1.59% -2.82% -10.08% 7.68% 13.68% 5.96% 7.83% 20.85% -4.42% 7.62% 2.11% 4.44% <-IRR #YR-> 10 Stock Price
P/E 15.21 18.59 18.07 16.02 17.21 22.09 20.48 25.60 20.99 24.95 -33.53 394.63 21.49 7.27% <-IRR #YR-> 5 Stock Price
Trailing P/E 17.72 16.56 18.89 17.56 14.41 18.53 25.11 21.71 27.60 25.36 23.85 -36.08 402.94 16.02 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 7.62% P/E: 20.74 24.95 21.51 P/E Ratio Historical High
-$40.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $63.14
-$44.45 $0.00 $0.00 $0.00 $0.00 $63.14
Mar Apr - Jun Aug Oct Mar Feb Feb Jan Oct Jan Dec Jan Feb
Price Low $29.20 $30.77 $35.43 $31.00 $29.14 $34.00 $36.32 $41.19 $44.00 $47.36 $41.02 $42.36 $60.50 37.67% <-Total Growth 10 Stock Price
Increase 14.64% 5.38% 15.14% -12.50% -6.00% 16.68% 6.82% 13.41% 6.82% 7.64% -13.39% 3.27% 42.82% 3.25% <-IRR #YR-> 10 Stock Price
P/E 11.82 13.99 15.40 12.30 13.81 19.21 16.74 22.39 18.18 19.25 -23.44 264.75 20.17 3.12% <-IRR #YR-> 5 Stock Price
Trailing P/E 13.77 12.46 16.10 13.48 11.56 16.11 20.52 18.98 23.91 19.57 16.67 -24.21 378.13 12.30 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 6.82% P/E: 17.46 19.25 10.95 P/E Ratio Historical Low
-$30.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.36
-$36.32 $0.00 $0.00 $0.00 $0.00 $42.36
Long Term Debt 30,169 39,495 Liabilities, Debt Debt
Change 30.91% Change
Debt/Market Cap Ratio 0.95 0.76 0.85 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $3,650 $3,458 $5,651 6,738.0 8,003.0 8,003 Intangibles Goodwill
Change -5.26% 63.42% 19.24% 18.77% 0.00% Change
% of Market Cap 0.12 0.10 0.16 0.17 0.25 0.15 0.16 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $17,857 $19,857 $21,882 $20,448 $24,767 $26,450 $31,343 $33,171 $34,339 $40,465 $31,751 $52,292 $51,808 $51,808 $51,808 163.34% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 486.2 490.6 532.5 571.5 652.8 692 703 706 708 710 709 760 54.91% <-Total Growth 10 Diluted
Change -0.10% 0.90% 8.54% 7.32% 14.23% 6.00% 1.59% 0.43% 0.28% 0.28% -0.14% 7.19% 3.80% <-Median-> 10 Change
Basic # of Shares in Millions 486.2 488.0 529.9 569.6 651.8 690.5 701.6 705.0 706.7 708.0 709 759 55.53% <-Total Growth 10 Basic
Change 0.43% 0.37% 8.59% 7.49% 14.43% 5.94% 1.61% 0.48% 0.24% 0.18% 0.14% 7.05% 3.77% <-Median-> 10 Change
Difference 0.2% 0.2% 1.9% 8.2% 5.0% 0.8% 0.3% 0.1% 0.1% 0.1% -0.9% 13.8% 0.58% <-Median-> 10 Difference
excluding Nova Acquistion Public Offer
# of Shares (incl.Nova) 487.24 488.98 539.77 616.47 684.36 696.23 703.86 705.46 707.44 708.66 702.61 863.76 863.76 863.76 863.76 5.85% <-IRR #YR-> 10 Shares
Change 0.48% 0.36% 10.39% 14.21% 11.01% 1.73% 1.10% 0.23% 0.28% 0.17% -0.85% 22.94% 0.00% 0.00% 0.00% 4.18% <-IRR #YR-> 5 Shares
CF fr Op $M $1,902 $2,075 $2,836 $2,840 $2,990 $3,082 $3,973 $3,571 $3,674 $4,079 $4,115 $5,069 $4,785 $5,131 $6,202 144.29% <-Total Growth 10 Cash Flow
Increase 11.75% 9.10% 36.67% 0.14% 5.28% 3.08% 28.91% -10.12% 2.88% 11.02% 0.88% 23.18% -5.60% 7.22% 20.88% DRIP SO
5 year Running Average $1,713 $1,901 $2,084 $2,271 $2,529 $2,765 $3,144 $3,291 $3,458 $3,676 $3,882 $4,102 $4,344 $4,636 $5,060 115.81% <-Total Growth 10 CF 5 Yr Running
CFPS $3.90 $4.24 $5.25 $4.61 $4.37 $4.43 $5.64 $5.06 $5.19 $5.76 $5.86 $5.87 $5.54 $5.94 $7.18 38.29% <-Total Growth 10 Cash Flow per Share
Increase 11.22% 8.71% 23.81% -12.32% -5.16% 1.32% 27.51% -10.32% 2.60% 10.83% 1.75% 0.20% -5.60% 7.22% 20.88% 9.34% <-IRR #YR-> 10 Cash Flow 144.29%
5 year Running Average $3.55 $3.92 $4.17 $4.30 $4.48 $4.58 $4.86 $4.82 $4.94 $5.22 $5.50 $5.55 $5.64 $5.79 $6.08 4.99% <-IRR #YR-> 5 Cash Flow 27.59%
P/CF on Med Price 8.55 8.44 7.33 7.75 7.49 8.26 7.15 8.72 9.13 9.45 8.51 8.99 11.28 3.30% <-IRR #YR-> 10 Cash Flow per Share 38.29%
P/CF on Closing Price 9.39 9.57 7.72 7.20 8.28 8.58 7.89 9.29 9.35 9.92 7.72 10.32 10.83 0.78% <-IRR #YR-> 5 Cash Flow per Share 3.97%
29.14% Diff M/C 3.53% <-IRR #YR-> 10 CFPS 5 yr Running 41.50%
Excl.Working Capital CF $49.0 $303.0 -$215.0 $181.0 $90.0 $0.2 -$310.0 -$287.0 $326.0 $189.0 $398.0 -$248 $0.0 $0.0 $0.0 2.68% <-IRR #YR-> 5 CFPS 5 yr Running 14.14%
CF fr Op $M WC $1,951 $2,378 $2,621 $3,021 $3,080 $3,082 $3,663 $3,284 $4,000 $4,268 $4,513 $4,821 $4,785 $5,131 $6,202 102.73% <-Total Growth 10 Cash Flow less WC
Increase 16.97% 21.89% 10.22% 15.26% 1.95% 0.07% 18.84% -10.35% 21.80% 6.70% 5.74% 6.82% -0.74% 7.22% 20.88% 7.32% <-IRR #YR-> 10 Cash Flow less WC 102.73%
5 year Running Average $1,653 $1,935 $2,082 $2,328 $2,610 $2,836 $3,093 $3,226 $3,422 $3,659 $3,946 $4,177 $4,477 $4,704 $5,090 5.65% <-IRR #YR-> 5 Cash Flow less WC 31.61%
CFPS Excl. WC $4.00 $4.86 $4.86 $4.90 $4.50 $4.43 $5.20 $4.66 $5.65 $6.02 $6.42 $5.58 $5.54 $5.94 $7.18 8.00% <-IRR #YR-> 10 CF less WC 5 Yr Run 115.85%
Increase 16.41% 21.45% -0.15% 0.92% -8.16% -1.63% 17.55% -10.55% 21.46% 6.52% 6.65% -13.10% -0.74% 7.22% 20.88% 6.19% <-IRR #YR-> 5 CF less WC 5 Yr Run 35.03%
5 year Running Average $3.42 $3.99 $4.17 $4.41 $4.62 $4.71 $4.78 $4.74 $4.89 $5.19 $5.59 $5.67 $5.84 $5.90 $6.13 1.39% <-IRR #YR-> 10 CFPS - Less WC 14.77%
P/CF on Med Price 8.34 7.37 7.93 7.28 7.27 8.26 7.76 9.48 8.38 9.03 7.76 9.45 4.74% <-IRR #YR-> 5 CFPS - Less WC 7.25%
P/CF on Closing Price 9.15 8.35 8.35 6.77 8.04 8.58 8.56 10.10 8.58 9.48 7.04 10.85 10.83 10.10 8.35 3.57% <-IRR #YR-> 10 CFPS 5 yr Running 42.03%
Median Values CF/-WC P/CF Med 10 yr 8.38 5 yr 8.99 P/CF Med 10 yr 8.09 5 yr 9.03 33.81% Diff M/C 3.47% <-IRR #YR-> 5 CFPS 5 yr Running 18.62%
*Operational Cash Flow per share
-$4.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.87 Cash Flow per Share
-$5.64 $0.00 $0.00 $0.00 $0.00 $5.87 Cash Flow per Share
-$3.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.55 CFPS 5 yr Running
-$4.86 $0.00 $0.00 $0.00 $0.00 $5.55 CFPS 5 yr Running
-$2,378 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,821 Cash Flow less WC
-$3,663 $0 $0 $0 $0 $4,821 Cash Flow less WC
-$1,935 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,177 CF less WC 5 Yr Run
-$3,093 $0 $0 $0 $0 $4,177 CF less WC 5 Yr Run
-$4.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.58 CFPS - Less WC
-$4.43 $0.00 $0.00 $0.00 $0.00 $5.58 CFPS - Less WC
-$3.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.67 CFPS 5 yr Running
-$4.78 $0.00 $0.00 $0.00 $0.00 $5.67 CFPS 5 yr Running
Decrease/(increase) in operating working capital -326.00 -189.00 -398.00 248
Sum -326.00 -189.00 -398.00 248
Google -326.00 -189.00 -398.00 248
Difference 0.00 0.00 0.00 0
OPM 31.06% 27.59% 32.13% 32.95% 33.35% 38.22% 43.47% 44.60% 41.76% 40.05% 36.42% 40.54% 46.91% <-Total Growth 10 OPM
Increase -6.81% -11.16% 16.42% 2.57% 1.21% 14.61% 13.75% 2.59% -6.36% -4.11% -9.07% 11.31% should be zero, it is a check on calculations
Diff from Ave -19.0% -28.0% -16.2% -14.1% -13.0% -0.3% 13.4% 16.3% 8.9% 4.4% -5.0% 5.7% 0.02 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 38.35% 5 Yrs 40.67% Should increase or be stable.
Current Assets $1,566 $2,092 $2,305 $3,600 $3,175 $3,237 $3,640 $2,824 $3,147 $3,540 $3,914 $8,084 Liquidity ratio of 1.5 and up, best
Current Liabilities $3,112 $2,989 $3,035 $4,930 $4,949 $5,661 $5,880 $5,881 $5,358 $7,584 $7,306 $7,680 0.60 <-Median-> 10 Ratio
Liquidity Ratio 0.50 0.70 0.76 0.73 0.64 0.57 0.62 0.48 0.59 0.47 0.54 1.05 0.54 <-Median-> 5 Ratio
Liq. with CF aft div 0.92 1.18 1.45 1.13 1.04 0.92 1.10 0.88 1.03 0.83 0.90 1.46 0.90 <-Median-> 5 Ratio
Liq. CF reInv+Div 0.65 0.69 0.48 0.49 0.43 0.47 0.70 0.57 0.53 0.53 0.55 0.42 0.53 <-Median-> 5 Ratio
Excl.debt handled $3,051 $2,848 $894 $973 $1,797 $2,547 $2,547
Liquidity Ratio 1.24 1.20 0.57 0.72 0.61 0.82 1.57 0.72 <-Median-> 5 Ratio
Liq. with CF aft div 2.00 2.13 1.04 1.26 1.08 1.39 2.18
Assets $24,113 $25,909 $30,330 $39,141 $43,841 $46,589 $48,995 $48,333 $53,898 $58,947 $64,483 $88,051 Debt Ratio of 1.5 and up, best
Liability $16,124 $17,453 $19,546 $25,322 $26,908 $28,705 $30,206 $29,997 $33,762 $38,294 $46,328 $62,068 1.57 <-Median-> 10 Ratio
Debt Ratio 1.50 1.48 1.55 1.55 1.63 1.62 1.62 1.61 1.60 1.54 1.39 1.42 1.54 <-Median-> 5 Ratio
Total Book Value $7,989 $8,456 $9,785 $12,898 $16,933 $17,884 $18,789 $18,336 $20,136 $20,653 $18,155 $25,983 207.27% <-Total Growth 10 Book Value
Non-Control Int. $1,174 $1,157 $1,465 $1,425 $1,611 $1,583 $1,717 $1,726
Book Value $7,989 $8,456 $9,785 $12,898 $15,759 $16,727 $17,324 $16,911 $18,525 $19,070 $16,438 $24,257 $24,257 $24,257 $24,257 186.86% <-Total Growth 10 Book Value
Preferred Shares $0 $0 $0 $539 $1,224 $1,224 $1,224 $1,224 $1,813 $2,255 $2,499 $3,980 $3,980 $3,980 $3,980
Net Book Value $7,989 $8,456 $9,785 $12,359 $14,535 $15,503 $16,100 $15,687 $16,712 $16,815 $13,939 $20,277 $20,277 $20,277 $20,277 139.79% <-Total Growth 10 Book Value
BV per share $16.40 $17.29 $18.13 $20.05 $21.24 $22.27 $22.87 $22.24 $23.62 $23.73 $19.84 $23.48 $23.48 $23.48 $23.48 35.75% <-Total Growth 10 Book Value per Share
Change 21.11% 5.47% 4.83% 10.59% 5.94% 4.84% 2.72% -2.79% 6.24% 0.44% -16.39% 18.33% 0.00% 0.00% 0.00% 27.35% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.04 2.07 2.12 1.78 1.54 1.64 1.77 1.99 2.01 2.29 2.51 2.25 2.01 P/B Ratio Historical Median
P/B Ratio (Close) 2.24 2.35 2.24 1.65 1.70 1.71 1.95 2.11 2.05 2.41 2.28 2.58 2.56 2.56 2.56 3.10% <-IRR #YR-> 10 Book Value per Share 35.75%
Change 1.55% 5.06% -4.77% -26.01% 2.99% 0.13% 14.11% 8.62% -2.83% 17.12% -5.34% 13.21% 0.52% <-IRR #YR-> 5 Book Value per Share 2.63%
Leverage (A/BK) 3.02 3.06 3.10 3.03 2.59 2.61 2.61 2.64 2.68 2.85 3.55 3.39 2.77 <-Median-> 10 A/BV
Debt/Equity Ratio 2.02 2.06 2.00 1.96 1.59 1.61 1.61 1.64 1.68 1.85 2.55 2.39 1.77 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.00 5 yr Med 2.25 28.02% Diff M/C
-$17.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.48
-$22.87 $0.00 $0.00 $0.00 $0.00 $23.48
Comprehensive Income $1,323 $1,148 $1,675 $1,452 $2,491 $1,822 -$538 $453
NCI $103 $121 $140 $97 $191 $283 $312 $241
Preferred Shares $6 $45 $55 $55 $74 $97 $94 $109
Shareholders $1,079 $1,036 $1,341 $1,214 $982 $1,480 $1,300 $2,226 $1,442 -$944 $103 -90.45% <-Total Growth 10 Comprehensive Income
Increase -3.99% 29.44% -9.47% -19.11% 50.71% -12.16% 71.23% -35.22% -165.46% 110.91% -12.16% <-Median-> 5 Comprehensive Income
5 Yr Running Average $1,130 $1,211 $1,263 $1,440 $1,486 $1,101 $825 -20.94% <-IRR #YR-> 10 Comprehensive Income -90.45%
ROE 12.8% 10.6% 10.4% 7.7% 5.9% 8.5% 7.7% 12.0% 7.6% -5.7% 0.4% -41.32% <-IRR #YR-> 5 Comprehensive Income -93.04%
5 year Median 10.4% 8.5% 7.7% 7.7% 7.7% 7.7% 7.6% -5.11% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% -16.0% -6.9% -5.1% -14.4% 5.1% 8.5% 41.3% -10.4% -15.9% -11.0% -7.37% <-IRR #YR-> 5 5 Yr Running Average -31.82%
Median Values Diff 5, 10 yr -8.6% -10.4% 7.6% <-Median-> 5 Return on Equity
-$1,079 $0 $0 $0 $0 $0 $0 $0 $0 $0 $103
-$1,480 $0 $0 $0 $0 $103
-$1,130 $0 $0 $0 $0 $0 $825
-$1,211 $0 $0 $0 $0 $825
Current Liability Coverage Ratio 0.63 0.80 0.86 0.61 0.62 0.54 0.62 0.56 0.75 0.56 0.62 0.63 CFO / Current Liabilities
5 year Median 0.63 0.80 0.80 0.63 0.63 0.62 0.62 0.61 0.62 0.56 0.62 0.62 62.0% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 8.09% 9.18% 8.64% 7.72% 7.03% 6.62% 7.48% 6.79% 7.42% 7.24% 7.00% 5.48% CFO / Total Assets
5 year Median 8.09% 8.73% 8.64% 8.09% 8.09% 7.72% 7.48% 7.03% 7.03% 7.24% 7.24% 7.00% 7.1% <-Median-> 10 Return on Assets
Return on Assets ROA 5.0% 4.2% 4.1% 3.7% 3.1% 2.6% 3.1% 2.7% 3.2% 3.0% -1.9% 0.1% Net Income/Assets Return on Assets
5Yr Median 3.8% 4.1% 4.1% 4.1% 4.1% 3.7% 3.1% 3.1% 3.1% 3.0% 3.0% 2.7% 3.0% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 15.1% 12.8% 12.6% 11.2% 8.1% 6.9% 8.1% 7.1% 8.5% 8.4% -6.8% 0.5% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 13.0% 13.0% 13.0% 12.8% 12.6% 11.2% 8.1% 8.1% 8.1% 8.1% 8.1% 7.1% 8.1% <-Median-> 10 Return on Equity
Net Income $1,476 $1,387 $1,711 $1,472 $1,911 $1,993 -$1,140 $485
NCI $96 $115 $129 $118 $125 $153 $6 $252
Preferred Shares $6 $45 $55 $55 $74 $97 $94 $109
Shareholders $1,209 $1,079 $1,233 $1,440 $1,374 $1,227 $1,527 $1,299 $1,712 $1,743 -$1,240 $124 $2,597 $2,817 $2,778 -88.51% <-Total Growth 10 Net Income
Increase 42.07% -10.75% 14.27% 16.79% -4.58% -10.70% 24.45% -14.93% 31.79% 1.81% -171.14% -110.00% 1994.35% 8.47% -1.38% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $855 $947 $1,045 $1,162 $1,267 $1,271 $1,360 $1,373 $1,428 $1,502 $1,008 $728 $987 $1,208 $1,415 -19.45% <-IRR #YR-> 10 Net Income -88.51%
Operating Cash Flow $1,902 $2,075 $2,836 $2,840 $2,990 $3,082 $3,973 $3,571 $3,674 $4,079 $4,115 $5,069 -39.48% <-IRR #YR-> 5 Net Income -91.88%
Investment Cash Flow -$1,336 -$2,116 -$6,207 -$6,503 -$6,913 -$5,420 -$3,288 -$3,256 -$5,120 -$4,144 -$4,610 -$18,783 -2.61% <-IRR #YR-> 10 5 Yr Running Average -23.20%
Total Accruals $643 $1,120 $4,604 $5,103 $5,297 $3,565 $842 $984 $3,158 $1,808 -$745 $13,838 -11.76% <-IRR #YR-> 5 5 Yr Running Average -46.51%
Total Assets $24,113 $25,909 $30,330 $39,141 $43,841 $46,589 $48,995 $48,333 $53,898 $58,947 $64,483 $88,051 Balance Sheet Assets
Accruals Ratio 2.67% 4.32% 15.18% 13.04% 12.08% 7.65% 1.72% 2.04% 5.86% 3.07% -1.16% 15.72% 3.07% <-Median-> 5 Ratio
EPS/CF Ratio 0.62 0.45 0.47 0.51 0.47 0.40 0.42 0.40 0.43 0.41 -0.27 0.03 0.41 <-Median-> 10 EPS/CF Ratio
-$1,079 $0 $0 $0 $0 $0 $0 $0 $0 $0 $124
-$1,527 $0 $0 $0 $0 $124
-$947 $0 $0 $0 $0 $0 $0 $0 $0 $0 $728
-$1,360 $0 $0 $0 $0 $728
Change in Close 22.99% 10.80% -0.17% -18.18% 9.10% 4.97% 17.22% 5.59% 3.23% 17.63% -20.86% 33.97% -0.93% 0.00% 0.00% Count 23 Years of data
up/down down down down down down down Count 11 47.83%
Meet Prediction? yes % right Count 3 27.27%
Financial Cash Flow -$556 $219 $3,526 $4,369 $3,722 $2,113 -$690 -$403 $1,794 -$373 $744 $14,007 C F Statement Financial CF
Total Accurals $1,199 $901 $1,078 $734 $1,575 $1,452 $1,532 $1,387 $1,364 $2,181 -$1,489 -$169 Accruals
Accruals Ratio 4.97% 3.48% 3.55% 1.88% 3.59% 3.12% 3.13% 2.87% 2.53% 3.70% -2.31% -0.19% 2.53% <-Median-> 5 Ratio
CF net $155 $706 -$201 -$225 -$5 -$88 $348 -$438 $249 $293
Foreign curetc -$50 $98 -$110 -$8 $6 -$15 $28 $0 $112 -$127
Inc/Dec in Cash $105 $804 -$311 -$233 $1 -$103 $376 -$438 $361 $166
Cash $399 $504 $1,308 $997 $764 $765 $551 $927 $489 $850 $1,016 Cash
Cash per Share $0.82 $0.93 $2.12 $1.46 $1.10 $1.09 $0.78 $1.31 $0.69 $1.21 $1.18 $1.18 <-Median-> 5 Cash per Share
Percentage of Stock Price 2.01% 2.30% 6.40% 4.03% 2.89% 2.44% 1.66% 2.70% 1.21% 2.68% 1.94% 1.94% <-Median-> 5 % of Stock Price
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
Notes:
March 12, 2017.Last estimates were for 2016, 2017 and 2018 of $11774M, $12367M and $12021M for Revenue, $4.73 and 5.51 for AFFO for 2016 and 2017,
$2.54, $2.85 and $2.61 for EPS, $5.48, $6.05 and $6.09 for CFPS and $1776M, $2003M and $1813M for Net Income.
March 20, 2016.Last estimates were for 2015, 2016 and 2017 with $10705M, $11218M and $12728M for Revenue, $5.18 and $5.52 for AFFO for 2015 and 2016,
$2.39, $2.56 and $3.31 for EPS, $5.84, $6.10 and $6.98 for CFPS and $1698M, $1866M and $2316M for Net Income.
March 28, 2015.Last estimates were for 2014 and 2015 of $9721M and $10013M for Revenue, $5.12 and $5.29 AFFO, $2.48 and $2.58 for EPS, $5.60 and $5.73 for EPS, $1741M and $1777M for Net Income.
March 23, 2014.Last estimates were for 2013 and 2014 of $9495M and $10193M for Revenue, $4.72 for AFFO 2013, $2.29, 2.51 and (2.97 (2015) for EPS, and $5.37 and $5.91 for CFPS.
Feb 17, 2013.Last estimates were for 2012 and 2013 of $9476M and $10021M for revenue and $2.37, $2.55 and $2.67 for 2014 and $5.17 and $5.30 for CFPS.
I started AFFO section to build up info.
Mar 10, 2012.Last estimates were for 2011 and 2012 with EPS of $2.27 and $2.44 and CF or $5.00 and $5.00
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.
Most of the increase each year is because of DRIP plans and stock options.But they do issue new shares occasionally.
Sector:
Infrastructure. Utility
What should this stock accomplish?
Would I buy this company and Why.
They are a dividend growth utility so I think they are a good stock to buy.
Dividends
Dividends are paid in cycle 1,so they are paid in January, April, July and October.Payments are made near the end of the month. Dividends are declared for shareholders at the end of one month and are paid at the end of the following month.
For example, the dividend declared for shareholders of record on December 31, 2013 was payable on January 31, 2014.
Why am I following this stock.
When I bought this stock it was on Mike Higgs' Canadian Dividend Growth Stock list and the other dividend lists that I followed.
Why I bought this stock.
I bought the stock in 2000 at an opportune time.The company had been cutting their dividend payments in order to re-organize and get the company into shape for long term profitability.This
companyís stock fell hard because of this.People who depend on dividends for their income can be an unforgiving lot and can get really upset at company when a trusted company cuts dividends.††
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.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Options are mostly priced
Date Mar 10 2012 Feb 17 2013 Mar 03 2014 Mar 29 2015 Mar 20 2016 Mar 17 2017
Girling, Russell 0.093 0.01% 0.134 0.02% 0.146 0.02% 0.148 0.02% 0.246 0.03%
CEO - Shares - Amount $4.527 $7.635 $6.594 $8.987 $14.751
Options - percentage 1.618 0.23% 2.302 0.32% 2.639 0.38% 2.641 0.31% 3.276 0.38%
Options - amount $78.523 $131.451 $119.256 $159.878 $196.473
Marchand, Donald R. 0.011 0.00% 0.013 0.00% 0.015 0.00% 0.009 0.00% 0.022 0.00%
CFO - Shares - Amount $0.536 $0.730 $0.662 $0.545 $1.300
Options - percentage 0.300 0.04% 0.566 0.08% 0.681 0.10% 0.685 0.08% 1.213 0.14%
Options - amount $14.574 $32.298 $30.792 $41.487 $72.735
Delkus, Kristine L. 0.021 0.00%
Officer - Shares - Amount $1.235
Options - percentage 0.485 0.06%
Options - amount $29.076
Baggs, James M. 0.005 0.00% 0.006 0.00% 0.007 0.00% ceased to be insider
Officer - Shares - Amount $0.247 $0.315 $0.309 on March 1, 2016
Options - percentage 0.142 0.02% 0.227 0.03% 0.307 0.04%
Options - amount $6.886 $12.977 $13.864
Anderson, Brandon M. 0.000 0.00% 0.001 0.00% 0.002 0.00% 0.009 0.00%
Subsidiary Executive $0.009 $0.065 $0.133 $0.547
Options - percentage 0.079 0.01% 0.128 0.02% 0.128 0.01% 0.157 0.02%
Options - amount $3.857 $5.786 $7.752 $9.424
Benson, Kevin E. 0.013 0.00% 0.013 0.00% 0.013 0.00% 0.013 0.00% 0.013 0.00%
Director - Shares - Amount $0.631 $0.742 $0.587 $0.787 $0.780
Options - percentage 0.040 0.01% 0.053 0.01% 0.057 0.01% 0.061 0.01% 0.068 0.01%
Options - amount $1.945 $3.012 $2.557 $3.706 $4.065
Jackson, Steven Barry 0.039 0.01% 0.039 0.01% 0.039 0.00% 0.039 0.00%
Chairman - Shares - Amt $2.227 $1.762 $2.361 $2.339
Options - percentage 0.106 0.01% 0.119 0.02% 0.134 0.02% 0.148 0.02%
Options - amount $6.056 $5.391 $8.140 $8.905
Increase in O/S Shares 2.260 0.32% 1.600 0.23% 1.980 0.28% 1.221 0.17% 0.737 0.10% 1.683 0.19%
due to SO 2013 $100.638 $75.232 $96.109 $69.719 $33.305 $101.889
Book Value $64.000 $58.000 $80.000 $53.000 $30.000 $74.000
Insider Buying -$1.839 -$2.769 -$0.104
Insider Selling $22.618 $9.284 $35.057
Net Insider Selling $20.778 $6.515 $34.954
% of Market Cap 0.07% 0.01% 0.07%
Directors 11 27% 11 11 12 13
Women 3 2 18% 3 27% 3 25% 3 23%
Minorities 0 0% 0 0% 0 0% 0 0% 1 8%
Institutions/Holdings 300 45.49% 21 24.08% 585 57.70% 602 60.02% 409 58.63%
Total Shares Held 320.917 45.28% 3.371 0.48% 408.869 58.19% 421.516 48.80% 508.333 58.85%
Increase/Decrease -10.729 -3.5% 0.472 16.28% 10.128 2.54% -23.801 -5.34% 57.062 12.64%
Starting No. of Shares 310.188 Nasdaq 2.899 398.741 445.318 451.271 Nasdaq
Copyright © 2008 Website of SPBrunner. All rights reserved.
My stock