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/
TransAlta Corp TSX: TA NSYE TAC www.transalta.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 IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Revenue* 2,838.5 2,796.5 2,774.7 3,110.0 2,770.0 2,819.0 2,663.0 2,262.0 2,292.0 2,623.0 2,267.0 2,397 2,468 2,514 2,433 -14.29% <-Total Growth 10 Revenue
Increase 0.01% -1.48% -0.78% 12.08% -10.93% 1.77% -5.53% -15.06% 1.33% 14.44% -13.57% 5.73% 2.96% 1.86% -3.22% -1.53% <-IRR #YR-> 10 Revenue -14.29%
5 year Running Average $2,514.4 $2,561.8 $2,753.8 $2,871.6 $2,857.9 $2,854.0 $2,827.3 $2,724.8 $2,561.2 $2,531.8 $2,421.4 $2,368.2 $2,409.4 $2,453.8 $2,415.8 -2.08% <-IRR #YR-> 5 Revenue -9.99%
Revenue per Share $14.29 $13.82 $13.81 $15.44 $12.71 $12.80 $11.91 $8.88 $8.55 $9.54 $7.98 $8.33 $8.57 $8.73 $8.45 -0.78% <-IRR #YR-> 10 5 yr Running Average -7.56%
Increase -2.31% -3.28% -0.04% 11.82% -17.73% 0.71% -6.93% -25.43% -3.77% 11.61% -16.31% 4.30% 2.96% 1.86% -3.22% -3.48% <-IRR #YR-> 5 5 yr Running Average -16.24%
5 year Running Average $13.60 $13.33 $13.95 $14.40 $14.01 $13.72 $13.33 $12.35 $10.97 $10.33 $9.37 $8.65 $8.59 $8.63 $8.41 -4.94% <-IRR #YR-> 10 Revenue per Share -39.74%
P/S (Price/Sales) Med 1.55 1.76 2.09 1.88 1.71 1.70 1.79 2.00 1.74 1.30 1.03 0.68 0.88 0.00 0.00 -6.91% <-IRR #YR-> 5 Revenue per Share -30.09%
P/S (Price/Sales) Close 1.78 1.93 2.41 1.57 1.85 1.65 1.76 1.70 1.58 1.10 0.62 0.89 0.84 0.82 0.85 -4.22% <-IRR #YR-> 10 5 yr Running Average -35.06%
*Revenue in M CDN $  P/S Med 10 yr  1.72 5 yr  1.30 -51.28% Diff M/C -8.28% <-IRR #YR-> 5 5 yr Running Average -35.09%
-$2,797 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,397
-$2,663 $0 $0 $0 $0 $2,397
-$2,562 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,368
-$2,827 $0 $0 $0 $0 $2,368
-$13.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.33
-$11.91 $0.00 $0.00 $0.00 $0.00 $8.33
-$13.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.65
-$13.33 $0.00 $0.00 $0.00 $0.00 $8.65
AFFO* $1.68 -$0.25 $0.33 $0.94 $0.80 $1.04 $1.19 $1.29 -38.10% <-Total Growth 5 AFFO Fr TD
Increase -114.88% -232.00% 184.85% -14.89% 30.00% 14.42% 8.40% -9.15% <-IRR #YR-> 5 AFFO -38.10%
AFFO Yield 8.0% -1.7% 2.4% 8.9% 16.3% 14.0% 16.5% 17.9% -9.15% <-IRR #YR-> 5 AFFO -38.10%
5 year Running Average $0.70 $0.57 $0.86 $1.05 -18.29% <-IRR #YR-> 1 5 yr Running Average -18.29%
Payout Ratio 69.05% -470.00% 356.06% 88.30% 90.00% 28.85% 13.45% 12.40% -18.29% <-IRR #YR-> 1 5 yr Running Average -18.29%
5 year Running Average 144.57% 146.85% 74.07% 41.25% 145.71% <-Median-> 2 Payout 5 yr Running Average
Price/AFFO Median 12.71 -71.08 45.11 13.16 10.28 5.43 6.32 11.49 <-Median-> 6 P/AFFO Med
Price/AFFO High 13.83 -85.48 51.09 15.89 15.40 7.25 6.72 14.62 <-Median-> 6 P/AFFO High
Price/AFFO Low 11.58 -56.68 39.12 10.44 5.16 3.62 5.92 7.80 <-Median-> 6 P/AFFO Low
Price/AFFO Close 12.51 -60.48 40.85 11.19 6.14 7.14 6.05 5.58 9.17 <-Median-> 6 P/AFFO Close
Trailing P/AFFO Close 9.00 -53.92 31.88 5.22 9.29 6.92 6.05 9.00 <-Median-> 5 Trailing P/AFFO Close
* Adjusted Funds From Operations DPR 10 Yrs 78.67% 5 Yrs   88.30% P/CF 5 Yrs   in order 10.28 15.40 5.16 7.14 -41.15% Diff M/C -47.36% Diff M/C 10 DPR 75% to 95% best
-$1.68 $0.00 $0.00 $0.00 $0.00 $1.04
-$1.68 $0.00 $0.00 $0.00 $0.00 $1.04
-$0.70 $0.57
-$0.70 $0.57
FFO Amount $638.90 $678.80 $781.50 $828.00 $729.00 $783.00
FFO per Share $3.25 $3.38 $3.86 $4.16 $3.63 $3.58
FFO* $3.25 $3.38 $3.86 $4.16 $3.63 $3.58 $3.64 $3.35 $2.76 $2.79 $2.64 $2.65 -21.61% <-Total Growth 10 FFO
Increase 4.13% 14.16% 7.81% -12.83% -1.42% 1.81% -7.97% -17.61% 1.09% -5.38% 0.38% -2.41% <-IRR #YR-> 10 FFO -21.61%
FFO Yield 12.8% 12.7% 11.6% 17.1% 15.4% 16.9% 17.3% 22.2% 20.5% 26.5% 53.8% 35.7% -6.15% <-IRR #YR-> 5 FFO -27.20%
5 year Running Average $3.65 $3.72 $3.77 $3.67 $3.39 $3.22 $3.04 $2.84 -5.05% <-IRR #YR-> 7 5 yr Running Average -22.35%
Payout Ratio 30.80% 29.58% 25.91% 25.96% 31.98% 32.44% 31.87% 35.07% 42.57% 29.75% 27.27% 11.32% -5.53% <-IRR #YR-> 5 5 yr Running Average -24.77%
5 year Running Average 28.67% 29.03% 29.48% 31.25% 34.39% 34.13% 33.33% 29.60% 30.42% <-Median-> 8 Payout 5 yr Running Average
Price/FFO Median 6.83 7.19 7.47 7.00 5.98 6.10 5.86 5.30 5.39 4.44 3.12 2.13 5.63 <-Median-> 10 P/FFO Med
Price/FFO High 8.14 7.90 8.77 8.94 6.96 6.71 6.38 6.38 6.11 5.35 4.67 2.85 6.38 <-Median-> 10 P/FFO High
Price/FFO Low 5.51 6.48 6.16 5.05 4.99 5.48 5.34 4.23 4.68 3.52 1.56 1.42 4.84 <-Median-> 10 P/FFO Low
Price/FFO Close 7.83 7.88 8.64 5.84 6.47 5.92 5.77 4.51 4.88 3.77 1.86 2.80 5.33 <-Median-> 10 P/FFO Close
Trailing P/FFO Close 5.21 6.01 5.97 4.88 4.44 4.48 2.95 2.14 4.68 <-Median-> 8 Trailing P/FFO Close
Median Values DPR 10 Yrs 30.42% 5 Yrs   33.33% P/CF 5 Yrs   in order 4.44 5.35 3.52 3.77 -100.00% Diff M/C -100.00% Diff M/C 10 DPR 75% to 95% best
* Adjusted Funds From Operations
-$3.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.65
-$3.64 $0.00 $0.00 $0.00 $0.00 $2.65
-$3.65 $0.00 $0.00 $0.00 -$0.34 $0.00 $0.00 $2.84
-$3.77 $0.00 $0.00 $0.00 $0.00 $2.84
EPS Basic $1.01 $0.22 $1.53 $1.18 $0.90 $1.00 $1.31 -$2.61 -$0.27 $0.52 -$0.09 $0.41 86.36% <-Total Growth 10 EPS Basic
EPS Diluted* $1.01 $0.22 $1.53 $1.18 $0.90 $1.00 $1.31 -$2.61 -$0.27 $0.52 -$0.09 $0.41 $0.27 $0.22 $0.28 86.36% <-Total Growth 10 EPS Diluted
Increase 14.77% -78.22% 595.45% -22.88% -23.73% 11.11% 31.00% -299.24% 89.66% 292.59% -117.31% 555.56% -34.15% -18.52% 27.27% 6.42% <-IRR #YR-> 10 Earnings per Share 86.36%
Earnings Yield 4.0% 0.8% 4.6% 4.9% 3.8% 4.7% 6.2% -17.3% -2.0% 4.9% -1.8% 5.5% 3.8% 3.1% 3.9% -20.73% <-IRR #YR-> 5 Earnings per Share -68.70%
5 year Running Average $1.10 $0.90 $0.98 $0.96 $0.97 $0.97 $1.18 $0.36 $0.07 -$0.01 -$0.23 -$0.41 $0.17 $0.27 $0.22 #NUM! <-IRR #YR-> 10 5 yr Running Average -145.43%
10 year Running Average $1.17 $1.08 $1.12 $1.11 $1.10 $1.04 $1.04 $0.67 $0.52 $0.48 $0.37 $0.39 $0.26 $0.17 $0.10 #NUM! <-IRR #YR-> 5 5 yr Running Average -134.46%
* ESP per share (Cdn GAAP) E/P 10 Yrs 4.66% 5Yrs -1.83%
-$0.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.41
-$1.31 $0.00 $0.00 $0.00 $0.00 $0.41
-$0.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.41
-$1.18 $0.00 $0.00 $0.00 $0.00 -$0.41
Special Dividend $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 Dividend
Dividend* $1.00 $1.00 $1.00 $1.08 $1.16 $1.16 $1.16 $1.18 $1.18 $0.83 $0.72 $0.30 $0.16 $0.16 $0.16 -70.00% <-Total Growth 10 Dividends
Increase 0.00% 0.00% 0.00% 8.00% 7.41% 0.00% 0.00% 1.29% 0.00% -29.36% -13.25% -58.33% -46.67% 0.00% 0.00% Count 30 Years of data
Dividends 5 Yr Running $1.00 $1.00 $1.00 $1.02 $1.05 $1.08 $1.11 $1.15 $1.17 $1.10 $1.01 $0.84 $0.64 $0.43 $0.30 -16.00% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 4.51% 4.11% 3.47% 3.71% 5.35% 5.32% 5.43% 6.61% 7.89% 6.71% 8.75% 5.31% 2.13% 5.39% <-Median-> 10 Yield H/L Price
Yield on High  Price 3.78% 3.74% 2.95% 2.90% 4.59% 4.84% 4.99% 5.50% 6.97% 5.56% 5.84% 3.98% 2.00% 4.91% <-Median-> 10 Yield on High  Price
Yield on Low Price 5.59% 4.57% 4.21% 5.14% 6.41% 5.92% 5.96% 8.29% 9.10% 8.46% 17.43% 7.98% 2.27% 10.25% <-Average 5 Yield on Low Price
Yield on Close Price 3.94% 3.75% 3.00% 4.44% 4.94% 5.48% 5.52% 7.77% 8.72% 7.89% 14.66% 4.04% 2.22% 2.22% 2.22% 5.50% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 99.01% 454.55% 65.36% 91.53% 128.89% 116.00% 88.55% -45.02% -435.19% 159.62% -800.00% 73.17% 59.26% 72.73% 57.14% 80.86% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 90.58% 111.36% 102.04% 105.39% 108.26% 111.80% 93.92% 322.19% 1767% -11000% -443.86% -205.88% 379.17% 163.16% 137.61% 103.72% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 32.08% 40.59% 23.71% 20.95% 43.60% 31.51% 37.37% 57.55% 41.19% 28.67% 47.33% 11.61% 5.32% 5.23% 5.86% 34.44% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 31.97% 36.10% 31.80% 28.05% 29.75% 29.71% 29.55% 34.46% 40.66% 37.74% 40.76% 35.31% 24.76% 33.13% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 30.49% 29.43% 25.71% 26.27% 34.69% 32.64% 32.06% 52.32% 45.61% 31.57% 30.34% 12.87% 5.32% 5.23% 5.86% 31.82% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 30.99% 32.19% 30.45% 28.68% 29.07% 29.51% 30.02% 33.99% 38.01% 37.61% 37.64% 34.55% 24.65% 16.19% 11.11% 32.22% <-Median-> 10 DPR CF WC 5 Yr Running
Median 5 yrs 5 Yr Med 5 Yr Cl 6.71% 7.89% 5 Yr Med Payout -45.02% 41.19% 31.57% -11.34% <-IRR #YR-> 10 Dividends -70.00%
* Dividends per share  5 Yr Med and Cur. -66.87% -71.83% Last Div Inc ---> $0.180 $0.040 -77.78% -23.70% <-IRR #YR-> 5 Dividends -74.14%
-$1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.30
-$1.16 $0.00 $0.00 $0.00 $0.00 $0.30
Historical Dividends Historical High Div 8.77% Low Div 3.36% Ave Div 6.07% Med Div 5.81% Close Div 5.76% Historical Dividends
High/Ave/Median Values Curr diff Exp. -74.66% Exp -33.86% Exp. -63.36% Exp. -61.75% Exp. -61.44% High/Ave/Median 
Future Dividend Yield Div Yd 2.45% earning in 5 Years at IRR of 2.00% Div Inc. 10.41% Future Dividend Yield
Future Dividend Yield Div Yd 2.71% earning in 10 Years at IRR of 2.00% Div Inc. 21.90% Future Dividend Yield
Future Dividend Yield Div Yd 2.99% earning in 15 Years at IRR of 2.00% Div Inc. 34.59% Future Dividend Yield
I am earning GC Div Gr -82.61% 7/27/87 # yrs -> 29 1987 $14.49 Cap Gain -50.31% I am earning GC
I am earning Div org yield 6.35% 12/31/14 Trading Div G Yrly -6.17% Div start $0.92 -6.35% 1.10% I am earning Div
I am earning GC Div Gr -86.21% 2/11/09 # yrs -> 7 2009 $21.70 Cap Gain -66.82% I am earning GC
I am earning Div org yield 5.35% 12/31/14 Trading Div G Yrly -28.57% Div start $1.16 -5.35% 0.74% I am earning Div
Yield if held 5 yrs 5.59% 4.06% 4.93% 6.17% 6.84% 5.23% 4.77% 4.08% 4.04% 3.83% 3.30% 1.41% 0.90% 1.07% 1.29% 4.43% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 7.17% 6.16% 5.28% 4.95% 6.20% 6.49% 4.71% 5.80% 6.72% 4.90% 3.25% 1.23% 0.56% 0.55% 0.74% 5.12% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 7.84% 7.76% 7.55% 7.68% 7.90% 8.32% 7.15% 6.21% 5.39% 4.44% 4.03% 1.22% 0.79% 0.91% 0.94% 6.68% <-Median-> 10 Paid Median Price
Yield if held 20 yrs 6.97% 7.71% 8.14% 9.09% 9.01% 8.87% 8.35% 5.65% 5.16% 1.85% 0.85% 0.73% 0.86% 7.93% <-Median-> 10 Paid Median Price
Yield if held 25 yrs 8.39% 8.25% 6.51% 5.59% 2.26% 1.14% 1.09% 1.15% 6.51% <-Median-> 5 Paid Median Price
Yield if held 30 yrs 1.12% 1.14% 1.12% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 27.97% 20.29% 24.67% 29.04% 30.91% 24.36% 22.88% 19.91% 20.03% 25.37% 23.22% 19.68% 17.92% 14.58% 12.12% 23.79% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 71.38% 61.45% 52.79% 46.24% 54.76% 58.18% 42.86% 52.96% 62.36% 63.36% 47.19% 40.16% 30.96% 27.49% 32.29% 52.87% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 116.42% 115.45% 112.38% 106.58% 103.27% 110.11% 95.72% 83.09% 72.98% 84.17% 86.49% 59.90% 68.67% 74.76% 72.21% 91.10% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 137.82% 142.07% 140.84% 158.76% 158.62% 155.66% 148.03% 140.71% 146.41% 121.60% 99.92% 82.94% 92.19% 144.24% <-Median-> 10 Paid Median Price
Cost covered if held 25 years 177.80% 183.71% 179.44% 198.43% 191.23% 179.70% 163.46% 150.92% 183.71% <-Median-> 5 Paid Median Price
Cost covered if held 30 years 200.00% 199.21% 189.96% #NUM! <-Median-> 0 Paid Median Price
Graham Price FFO $34.16 $33.11 $32.11 $31.49 $25.68 $22.18 $23.12 $22.49 $17.13 $0.00 $0.00 $0.00 -46.65% <-Total Growth 8 Graham Price
Price/GP Ratio Med 0.85 0.65 0.68 0.68 0.69 0.67 0.54 0.37 0.33 #DIV/0! #DIV/0! #DIV/0! 0.67 <-Median-> 9 Price/GP Ratio
Price/GP Ratio High 1.09 0.76 0.75 0.74 0.83 0.76 0.65 0.55 0.44 #DIV/0! #DIV/0! #DIV/0! 0.75 <-Median-> 9 Price/GP Ratio
Price/GP Ratio Low 0.61 0.55 0.61 0.62 0.55 0.58 0.42 0.18 0.22 #DIV/0! #DIV/0! #DIV/0! 0.55 <-Median-> 9 Price/GP Ratio
Price/GP Ratio Close 0.71 0.71 0.66 0.67 0.59 0.61 0.45 0.22 0.43 #DIV/0! #DIV/0! #DIV/0! 0.61 <-Median-> 9 Price/GP Ratio
Prem/Disc Close -28.86% -29.09% -34.14% -33.25% -41.13% -39.23% -54.50% -78.17% -56.63% #DIV/0! #DIV/0! #DIV/0! -39.23% <-Median-> 9 Graham Price
Graham Price $16.90 $7.71 $19.85 $18.19 $16.49 $16.98 $18.89 $10.12 $9.63 $9.98 $9.98 $6.74 $5.47 $4.94 $5.57 -12.56% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.31 3.15 1.45 1.60 1.31 1.28 1.13 1.76 1.55 1.24 0.82 0.84 1.38 1.30 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.56 3.47 1.71 2.05 1.53 1.41 1.23 2.11 1.75 1.50 1.23 1.12 1.46 1.51 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.06 2.84 1.20 1.15 1.10 1.15 1.03 1.40 1.34 0.98 0.41 0.56 1.29 1.13 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.50 3.46 1.68 1.34 1.42 1.25 1.11 1.49 1.40 1.05 0.49 1.10 1.32 1.46 1.29 1.29 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 50.36% 245.72% 68.05% 33.58% 42.35% 24.54% 11.27% 49.42% 40.01% 5.39% -50.82% 10.27% 31.67% 45.87% 29.30% 29.06% <-Median-> 10 Graham Price
Pre-split 1988
Price Close $25.41 $26.64 $33.35 $24.30 $23.48 $21.15 $21.02 $15.12 $13.48 $10.52 $4.91 $7.43 $7.20 $7.20 $7.20 -72.11% <-Total Growth 10 Stock Price
Increase 40.78% 4.84% 25.19% -27.14% -3.37% -9.92% -0.61% -28.07% -10.85% -21.96% -53.33% 51.32% -3.10% 0.00% 0.00% -11.99% <-IRR #YR-> 10 Stock Price
P/E 25.16 121.09 21.80 20.59 26.09 21.15 16.05 -5.79 -49.93 20.23 -54.56 18.12 26.67 32.73 25.71 -18.78% <-IRR #YR-> 5 Stock Price
Trailing P/E 28.88 26.38 151.59 15.88 19.90 23.50 21.02 11.54 -5.16 -38.96 9.44 -82.56 17.56 26.67 32.73 -5.73% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.  per yr 6.26% 5.69% % Tot Ret -109.18% -43.49% Price Inc -21.96% P/E:  19.18 -5.79 -13.09% <-IRR #YR-> 5 Price & Dividend
-$26.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.43
-$21.02 $0.00 $0.00 $0.00 $0.00 $7.43
-$26.64 $1.00 $1.08 $1.16 $1.16 $1.16 $1.18 $1.18 $0.83 $0.72 $7.73
-$21.02 $1.18 $1.18 $0.83 $0.72 $7.73
Price H/L Median $22.17 $24.31 $28.81 $29.11 $21.68 $21.80 $21.35 $17.77 $14.89 $12.38 $8.23 $5.65 $7.52 -76.75% <-Total Growth 10 Stock Price
Increase 30.77% 9.65% 18.54% 1.02% -25.51% 0.53% -2.06% -16.75% -16.24% -16.86% -33.54% -31.31% 33.10% -13.58% <-IRR #YR-> 10 Stock Price
P/E 21.95 110.48 18.83 24.67 24.09 21.80 16.29 -6.81 -55.13 23.80 -91.39 13.78 27.85 -23.34% <-IRR #YR-> 5 Stock Price
Trailing P/E 25.19 24.06 130.95 19.02 18.37 24.22 21.35 13.56 -5.70 -45.83 15.82 -62.78 18.34 -6.20% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 20.08 27.07 29.40 30.19 22.40 22.56 18.03 49.92 225.53 -1237.50 -36.07 -13.85 44.76 -17.14% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 18.94 22.55 25.79 26.32 19.73 21.06 20.50 26.60 28.90 25.84 22.29 14.56 28.70 16.45 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 7.38% 6.21% % Tot Ret -119.06% -36% Price Inc -16.86% P/E:  17.56 -6.81 Count 30 Years of data
-$24.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.65
-$21.35 $0.00 $0.00 $0.00 $0.00 $5.65
-$24.31 $1.00 $1.08 $1.16 $1.16 $1.16 $1.18 $1.18 $0.83 $0.72 $5.95
-$21.35 $1.18 $1.18 $0.83 $0.72 $5.95
High Month Dec Dec Nov Jun Jan Jan Oct Jan Jan Feb Apr Dec Jan
Price High $26.43 $26.71 $33.86 $37.21 $25.25 $23.98 $23.24 $21.37 $16.86 $14.94 $12.32 $7.54 $8.00 -71.77% <-Total Growth 10 Stock Price
Increase 41.72% 1.06% 26.77% 9.89% -32.14% -5.03% -3.09% -8.05% -21.10% -11.39% -17.54% -38.80% 6.10% -11.88% <-IRR #YR-> 10 Stock Price
P/E 26.17 121.41 22.13 31.53 28.06 23.98 17.74 -8.19 -62.44 28.73 -136.89 18.39 29.63 -20.16% <-IRR #YR-> 5 Stock Price
Trailing P/E 30.03 26.45 153.91 24.32 21.40 26.64 23.24 16.31 -6.46 -55.33 23.69 -83.78 19.51 21.19 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -17.54% P/E:  20.26 -8.19 26.07 P/E Ratio Historical High
-$26.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.54
-$23.24 $0.00 $0.00 $0.00 $0.00 $7.54
Low Month Mar Mar Mar Oct Mar Jun Aug Sep Jun Dec Dec Jan Mar
Price Low $17.90 $21.90 $23.76 $21.00 $18.11 $19.61 $19.45 $14.17 $12.91 $9.81 $4.13 $3.76 $7.04 -82.83% <-Total Growth 10 Stock Price
Increase 17.38% 22.35% 8.49% -11.62% -13.76% 8.28% -0.82% -27.15% -8.89% -24.01% -57.90% -8.96% 87.23% -16.16% <-IRR #YR-> 10 Stock Price
P/E 17.72 99.55 15.53 17.80 20.12 19.61 14.85 -5.43 -47.81 18.87 -45.89 9.17 26.07 -28.01% <-IRR #YR-> 5 Stock Price
Trailing P/E 20.34 21.68 108.00 13.73 15.35 21.79 19.45 10.82 -4.95 -36.33 7.94 -41.78 17.17 14.85 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -24.01% P/E:  15.19 -5.43 9.57 P/E Ratio Historical Low
-$21.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.76
-$19.45 $0.00 $0.00 $0.00 $0.00 $3.76
Long Term Debt $3,721 $3,610 $4,130 $3,305 $4,408 $3,722 Debt
Change -2.98% 14.40% -19.98% 33.37% -15.56% Change
Debt/Market Cap Ratio 0.79 0.94 1.14 1.14 3.16 1.74 1.14 <-Median-> 6 Debt/Market Cap Ratio
Goodwill & Intangibles $723 $731 $783 $793 $834 $819 Intangibles Goodwill
Change 1.11% 7.11% 1.28% 5.17% -1.80% Change
Intangible/Market Cap Ratio 0.15 0.19 0.22 0.27 0.60 0.38 0.25 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $5,049 $5,392 $6,700 $4,893 $5,119 $4,659 $4,700 $3,851 $3,615 $2,893 $1,394 $2,139 $2,073 $2,073 $2,073 -60.33% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 201.2 202.9 199 201 219 222 235 264 273 280 288 43.14% <-Total Growth 10 Diluted
Change 0.84% -1.92% 1.01% 8.96% 1.37% 5.86% 12.34% 3.41% 2.56% 2.86% 2.71% <-Median-> 10 Change
Basic # of Shares in Millions 196.80 200.8 202.5 199 201 219 222 235 264 273 280 288 43.43% <-Total Growth 10 Basic
Change 2.13% 2.03% 0.85% -1.73% 1.01% 8.96% 1.37% 5.86% 12.34% 3.41% 2.56% 2.86% 2.71% <-Median-> 10 Change
Difference 1.0% 0.8% -0.8% 1.2% 8.5% 0.6% 0.7% 8.4% 1.6% 0.7% 1.4% 0.0% 0.96% <-Median-> 10 Difference
# of Share in M 198.7 202.4 200.9 201.4 218.0 220.3 223.6 254.7 268.2 275.0 284.0 287.9 287.9 287.9 287.9 3.59% <-IRR #YR-> 10 Shares
Increase 2.37% 1.86% -0.74% 0.23% 8.26% 1.06% 1.50% 13.91% 5.30% 2.54% 3.27% 1.37% 0.00% 0.00% 0.00% 5.19% <-IRR #YR-> 5 Shares
CF fr Op $M $619.4 $498.6 $847.2 $1,038.0 $580.0 $811.0 $694.0 $520.0 $765.0 $796.0 $432 $744 $866.6 $881.0 $786.0 49.22% <-Total Growth 10 Cash Flow
Increase 0.98% -19.50% 69.92% 22.52% -44.12% 39.83% -14.43% -25.07% 47.12% 4.05% -45.73% 72.22% 16.48% 1.66% -10.78% SO, DRIP Shares Issues
5 year Running Average $574.78 $531.38 $621.10 $723.32 $716.64 $754.96 $794.04 $728.60 $674.00 $717.20 $641 $651 $720.72 $743.91 $741.90 22.59% <-Total Growth 10 CF 5 Yr Running
CFPS $3.12 $2.46 $4.22 $5.15 $2.66 $3.68 $3.10 $2.04 $2.85 $2.89 $1.52 $2.58 $3.01 $3.06 $2.73 4.90% <-Total Growth 10 Cash Flow per Share
Increase -1.36% -20.97% 71.18% 22.24% -48.39% 38.37% -15.69% -34.22% 39.71% 1.48% -47.45% 69.89% 16.48% 1.66% -10.78% 4.08% <-IRR #YR-> 10 Cash Flow
5 year Running Average $3.13 $2.77 $3.14 $3.62 $3.52 $3.64 $3.76 $3.33 $2.87 $2.91 $2.48 $2.38 $2.57 $2.61 $2.58 1.40% <-IRR #YR-> 5 Cash Flow
P/CF on Med Price 7.11 9.87 6.83 5.65 8.15 5.92 6.88 8.70 5.22 4.28 5.41 2.19 2.50 0.00 0.00 0.48% <-IRR #YR-> 10 Cash Flow per Share
P/CF on Closing Price 8.15 10.81 7.91 4.71 8.83 5.75 6.77 7.41 4.73 3.63 3.23 2.88 2.39 2.35 2.64 -3.60% <-IRR #YR-> 5 Cash Flow per Share
-58.64% Diff M/C -1.51% <-IRR #YR-> 10 CFPS 5 yr Running
Excl.Working Capital CF $32.30 $189.20 -$65.70 -$210.00 $149.00 -$28.00 $115.00 $52.00 -$74.00 -$73.00 $242.00 -$73.00 $0.00 $0.00 $0.00 -8.77% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $651.7 $687.8 $781.5 $828.0 $729.0 $783.0 $809.0 $572.0 $691.0 $723.0 $674 $671 $866.6 $881.0 $786.0 -2.44% <-Total Growth 10 Cash Flow less WC
Increase 10.76% 5.54% 13.62% 5.95% -11.96% 7.41% 3.32% -29.30% 20.80% 4.63% -6.78% -0.45% 29.15% 1.66% -10.78% -0.25% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $592.28 $595.12 $649.48 $707.48 $735.60 $761.86 $786.10 $744.20 $716.80 $715.60 $694 $666 $725.12 $763.11 $775.70 -3.67% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $3.28 $3.40 $3.89 $4.11 $3.34 $3.55 $3.62 $2.25 $2.58 $2.63 $2.37 $2.33 $3.01 $3.06 $2.73 1.13% <-IRR #YR-> 10 CF less WC 5 Yr Run
Increase 8.19% 3.61% 14.47% 5.70% -18.67% 6.29% 1.80% -37.93% 14.72% 2.04% -9.73% -1.79% 29.15% 1.66% -10.78% -3.26% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $3.23 $3.11 $3.28 $3.54 $3.60 $3.66 $3.70 $3.37 $3.07 $2.92 $2.69 $2.43 $2.58 $2.68 $2.70 -3.70% <-IRR #YR-> 10 CFPS - Less WC
P/CF on Med Price 6.76 7.15 7.41 7.08 6.48 6.13 5.90 7.91 5.78 4.71 3.47 2.42 -8.42% <-IRR #YR-> 5 CFPS - Less WC
P/CF on Closing Price 7.75 7.84 8.57 5.91 7.02 5.95 5.81 6.73 5.23 4.00 2.07 3.19 2.39 2.35 2.64 -2.42% <-IRR #YR-> 10 CFPS 5 yr Running
*Operational Cash Flow per share  CF/-WC P/CF Med 10 yr 5.78 5 yr  5.22 P/CF Med 10 yr 6.02 5 yr  4.71 -60.24% Diff M/C -8.08% <-IRR #YR-> 5 CFPS 5 yr Running
Chnge in non-Cash WC
-$2.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.58 Cash Flow per Share
-$3.10 $0.00 $0.00 $0.00 $0.00 $2.58 Cash Flow per Share
-$2.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.38 CFPS 5 yr Running
-$3.76 $0.00 $0.00 $0.00 $0.00 $2.38 CFPS 5 yr Running
-$687.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $671.0 Cash Flow less WC
-$809.0 $0.0 $0.0 $0.0 $0.0 $671.0 Cash Flow less WC
-$595.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $666.2 CF less WC 5 Yr Run
-$786.1 $0.0 $0.0 $0.0 $0.0 $666.2 CF less WC 5 Yr Run
-$3.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.33 CFPS - Less WC
-$3.62 $0.00 $0.00 $0.00 $0.00 $2.33 CFPS - Less WC
-$3.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.43 CFPS 5 yr Running
-$3.70 $0.00 $0.00 $0.00 $0.00 $2.43 CFPS 5 yr Running
Chnge in non-Cash WC $74 $73 -$242 $73
Sum $74 $73 -$242 $73
Google $74 $73 -$242 $73
Difference $0 $0 $0 $0
OPM 21.8% 17.8% 30.5% 33.4% 20.9% 28.8% 26.1% 23.0% 33.4% 30.3% 19.1% 31.0% 74.09% <-Total Growth 10 OPM
Increase 0.97% -18.29% 71.25% 9.31% -37.26% 37.40% -9.41% -11.79% 45.19% -9.08% -37.21% 62.88% Should increase  or be stable.
Diff from Ave. -26.2% -39.7% 3.3% 12.9% -29.2% -2.7% -11.8% -22.2% 12.9% 2.7% -35.5% 5.0% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 29.56% 5 Yrs 30.35% should be  zero, it is a   check on calculations
Current Assets $926 $897 $819 $913 $838 $838 $1,124 $938 $747 $854 $1,164 $1,554 Liquidity ratio of 1.5 and up, best
Current Liabilities $1,141 $1,403 $1,503 $1,643 $843 $1,173 $1,191 $1,385 $852 $1,451 $853 $1,217 0.80 <-Median-> 10 Ratio
Liquidity 0.81 0.64 0.54 0.56 0.99 0.71 0.94 0.68 0.88 0.59 1.36 1.28 0.88 <-Median-> 5 Ratio
Liq. with CF aft div 1.18 0.85 0.97 1.06 1.38 1.19 1.31 0.84 1.40 0.98 1.63 1.82 1.40 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.97 0.72 0.77 0.78 0.48 0.74 0.86 0.48 0.77 0.82 0.98 1.43 0.82 <-Median-> 5 Ratio
Current port. Lg T. Db $607 $209 $751 $87 $87
Liquidity 1.21 1.16 1.22 1.52 1.38 1.22 <-Median-> 5 Ratio
Liq. with CF aft div 1.49 1.86 2.03 1.82 1.96 1.86 <-Median-> 5 Ratio
Assets $7,741 $7,460 $7,179 $7,815 $9,762 $9,893 $9,760 $9,451 $9,783 $9,833 $10,947 $10,996 Debt Ratio of 1.5 and up, best
Liabilities $4,685 $4,597 $4,411 $4,836 $6,355 $6,341 $6,133 $6,111 $6,360 $5,955 $6,557 $7,485 1.58 <-Median-> 10 Ratio
Debt Ratio 1.65 1.62 1.63 1.62 1.54 1.56 1.59 1.55 1.54 1.65 1.67 1.47 1.55 <-Median-> 5 Ratio
Check figures $9,760 $9,451 $9,783 $9,833 $10,947 $10,996 Check figures
Total Book Value $3,056 $2,863 $2,768 $2,979 $3,407 $3,552 $3,627 $3,340 $3,423 $3,878 $4,390 $3,511 Total Book Value
Non-controling Int $559 $435 $469 $469 $478 $435 $358 $330 $517 $594 $1,029 $1,152 Non-controling Int
Preferred shares $0 $0 $0 $0 $0 $293 $562 $781 $781 $942 $942 $942 Preferred shares
Book Value $2,497 $2,428 $2,299 $2,510 $2,929 $2,824 $2,707 $2,229 $2,125 $2,342 $2,419 $1,417 $1,417 $1,417 $1,417 -41.64% <-Total Growth 10 Book Value
Book Value per Share $12.57 $12.00 $11.44 $12.46 $13.44 $12.82 $12.11 $8.75 $7.92 $8.52 $8.52 $4.92 $4.92 $4.92 $4.92 -58.97% <-Total Growth 10 Book Value per Share
Change -1.36% -4.54% -4.62% 8.95% 7.79% -4.59% -5.56% -27.71% -9.46% 7.49% 0.01% -42.22% 0.00% 0.00% 0.00% -10.56% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.76 2.03 2.52 2.33 1.61 1.70 1.76 2.03 1.88 1.45 0.97 1.15 1.64 P/B Ratio Historical Median
P/B Ratio (Close) 2.02 2.22 2.91 1.95 1.75 1.65 1.74 1.73 1.70 1.24 0.58 1.51 1.46 1.46 1.46 -8.52% <-IRR #YR-> 10 Book Value per Share -58.97%
Change 42.71% 9.83% 31.26% -33.12% -10.36% -5.59% 5.23% -0.49% -1.53% -27.39% -53.33% 161.88% -3.10% 0.00% 0.00% -16.47% <-IRR #YR-> 5 Book Value per Share -59.35%
Leverage (A/BK) 2.53 2.61 2.59 2.62 2.87 2.79 2.69 2.83 2.86 2.54 2.49 3.13 2.74 <-Median-> 10 Leverage
Debt/Equity Ratio 1.53 1.61 1.59 1.62 1.87 1.79 1.69 1.83 1.86 1.54 1.49 2.13 1.74 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.73 5 yr Med 1.45 -15.52% Diff M/C
-$12.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.92
-$12.11 $0.00 $0.00 $0.00 $0.00 $4.92
Comprehensive Income $36 -$598 $82 $398 $375 $361 Comprehensive Income
NCI $18 $29 $41 $50 $103 $146 NCI
Shareholders $172 $47 $306 $541 $246 $233 $18 -$627 $41 $348 $272 $215 354.55% <-Total Growth 10 Comprehensive Income
Increase -72.42% 546.51% 76.91% -54.53% -5.28% -92.27% -3583.33% 106.54% 748.78% -21.84% -20.96% -20.96% <-Median-> 5 Comprehensive Income
5 Yr Running Average $262 $275 $269 $82 -$18 $3 $10 $50 16.35% <-IRR #YR-> 10 Comprehensive Income 354.55%
ROE 6.9% 1.9% 13.3% 21.6% 8.4% 8.3% 0.7% -28.1% 1.9% 14.9% 11.2% 15.2% 64.22% <-IRR #YR-> 5 Comprehensive Income 1094.44%
5Yr Median 8.4% 8.4% 8.4% 8.3% 1.9% 1.9% 1.9% 11.2% -21.13% <-IRR #YR-> 7 5 Yr Running Average #DIV/0!
% Difference from NI -13.7% 5.3% -1.0% 130.2% 35.9% 6.9% -93.8% 2.1% -157.7% 146.8% -1233.3% 83.8% -28.62% <-IRR #YR-> 5 5 Yr Running Average -81.47%
Median Values Diff 5, 10 yr 4.5% 2.1% 11.2% <-Median-> 5 Return on Equity
-$47 $0 $0 $0 $0 $0 $0 $0 $0 $0 $215
-$18 $0 $0 $0 $0 $215
-$262 $0 $0 $0 $0 $0 $0 $50
-$269 $0 $0 $0 $0 $50
Current Liability Coverage Ratio 0.57 0.49 0.52 0.50 0.86 0.67 0.68 0.41 0.81 0.50 0.79 0.55   CFO / Current Liabilities
5 year Median 0.47 0.49 0.52 0.50 0.52 0.52 0.67 0.67 0.68 0.67 0.68 0.55 60.9% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 8.42% 9.22% 10.89% 10.60% 7.47% 7.91% 8.29% 6.05% 7.06% 7.35% 6.16% 6.10% CFO / Total Assets
5 year Median 7.23% 7.23% 8.42% 9.22% 9.22% 9.22% 8.29% 7.91% 7.47% 7.35% 7.06% 6.16% 7.4% <-Median-> 10 Return on Assets 
Return on Assets ROA 2.6% 0.6% 4.3% 3.0% 1.9% 2.2% 3.0% -6.5% -0.7% 1.4% -0.2% 1.1% Net  Income/Assets Return on Assets
5Yr Median 2.7% 2.6% 2.6% 2.6% 2.6% 2.2% 3.0% 2.2% 1.9% 1.4% -0.2% -0.2% 1.6% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 8.0% 1.8% 13.4% 9.4% 6.2% 7.7% 10.7% -27.5% -3.3% 6.0% -1.0% 8.3% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 9.5% 8.0% 8.0% 8.0% 8.0% 7.7% 9.4% 7.7% 6.2% 6.0% -1.0% -1.0% 6.9% <-Median-> 10 Return on Equity
Net Income $296 $216 $239 $343 -$546 -$4 $232 $116 $276
NCI $61 $35 $20 $38 $37 $29 $50 $94 $107
Preferred Shareholders $0 $0 $1 $15 $31 $38 $41 $46 $52
Shareholders $199 $45 $309 $235 $181 $218 $290 -$614 -$71 $141 -$24 $117 $77 $60 $27 160.58% <-Total Growth 10 Net Income
Increase 16.80% -77.41% 587.75% -23.90% -22.98% 20.44% 33.03% -311.72% 88.44% 298.59% -117.02% 587.50% -34.62% -21.96% -54.77% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $206 $170 $191 $192 $194 $198 $247 $62 $1 -$7 -$56 -$90 $48 $74 $51 10.05% <-IRR #YR-> 10 Net Income 160.58%
Operating Cash Flow $619.4 $498.6 $847.2 $1,038 $580 $811 $694 $520 $765 $796 $432 $744 -16.60% <-IRR #YR-> 5 Net Income -59.66%
Investment Cash Flow -$242.1 -$261.3 -$410.1 -$581 -$1,598 -$720 -$615 -$1,048 -$703 -$292 -$573 -$327 #NUM! <-IRR #YR-> 10 5 Yr Running Ave. -153.20%
Total Accruals -$178.5 -$192.4 -$128.3 -$222 $1,199 $127 $211 -$86 -$133 -$363 $117 -$300 #NUM! <-IRR #YR-> 5 5 Yr Running Ave. -136.58%
Total Assets $7,740.7 $7,460.1 $7,178.7 $7,815 $9,762 $9,893 $9,760 $9,451 $9,783 $9,833 $10,947 $10,996 Balance Sheet Assets
Accruals Ratio -2.31% -2.58% -1.79% -2.84% 12.28% 1.28% 2.16% -0.91% -1.36% -3.69% 1.07% -2.73% -1.36% <-Median-> 5 Ratio
EPS/CF Ratio 0.31 0.06 0.39 0.29 0.27 0.28 0.36 -1.16 -0.10 0.20 -0.04 0.18 0.23 <-Median-> 10 EPS/CF Ratio
-$45 $0 $0 $0 $0 $0 $0 $0 $0 $0 $117
-$290 $0 $0 $0 $0 $117
-$170 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$90
-$247 $0 $0 $0 $0 -$90
Change in Close 40.78% 4.84% 25.19% -27.14% -3.37% -9.92% -0.61% -28.07% -10.85% -21.96% -53.33% 51.32% -3.10% 0.00% 0.00% Count 24 Years of data
up/down down Count 3 12.50%
Meet Prediction? Yes % right Count 2 66.67%
Financial Cash Flow -$396.3 -$243.2 -$443.8 -$467 $1,053 -$113 -$67 $504 -$47 -$503 $149 -$163 C F Statement  Financial CF
Total Accruals $217.8 $50.8 $315.5 $245 $146 $240 $278 -$590 -$86 $140 -$32 -$137 Accruals
Accruals Ratio 2.81% 0.68% 4.39% 3.13% 1.50% 2.43% 2.85% -6.24% -0.88% 1.42% -0.29% -1.25% -0.88% <-Median-> 5 Ratio
Cash $79.3 $65.6 $50.9 $50 $82 $58 $49 $27 $27 $43 $54 $305 Cash
Cash per Share $0.40 $0.32 $0.25 $0.25 $0.38 $0.26 $0.22 $0.11 $0.10 $0.16 $0.19 $1.06 $0.16 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.57% 1.22% 0.76% 1.02% 1.60% 1.24% 1.04% 0.70% 0.75% 1.49% 3.87% 14.26% 1.49% <-Median-> 5 % of Stock Price
Notes:
March 12, 2017.  Last estimates were for 2016 of $2639M for Revenue, $0.95 and $1.16 for AFFO for 2016 and 2017, $0.36 for EPS, $2.34 for CFPS and $79M for Net Income.
March 19, 2016.  Last estimates were for 2015 and 2016 of $2551M and $2639M for Revenue, $0.96 and $0.96 forAFFO, $0.29 and $0.36 for EPS, $2.31 and $2.34 for CFPS and $72M and $79M for Net Income.
March 28, 2015.  Last estimates were for 2014 and 2015 of $2407M and $2555M for Revenue, $1.20 and $1.28 for AFFO, $0.52 and $0.59 for EPS, $2.71 and $2.89 for CFPS and $151M and $143M for Net Income.
March 2, 2014.  Last estimates were for 2013 and 2014 of $2346M and $2448M for Revenue, $.90 and $1.52 for AFFO, Br.82 and $.80 for EPS, $3.27 and $3.46 for CF.
November 5, 2013.  No one seems to be admitting it, but dividends were decreased for October 2013 dividend from $.295 to $.29.  Transalta site state dividends at $.29 continuously, but I got $.295.
However, in April 2013 the declared dividend for July 2013 in press releast was for $.29, not $.295 which I got. 
March 9, 2013.  Last estimates were for 2012 and 2013 (and 2014) of $2589M and $2652M for Revenue and $1.11 and $1.17 and ($1.36) for EPS and $3.65 and $3.69 for CFPS.
Hopefully the financial results have bottomed out as some analysts feel.  Also, it is felt that the dividend is currently safe.
The information on debt can be quite confusing because they are also using hedging.  However, they do have credit facilites to handle the current portion of their long term debt.
March 30, 2012.  Last estimates I got were for 2011 and 2012 at $2681M and $2655M for Revenue, $1.12 and $1.31 for EPS and $3.36 and $3.48 for CF.
Transalta is going through some tough times. Conclusion is until the company works through its maintenance issues and power prices fully recover, we expect the dividend to provide some support for the stock.
Apr 06, 2010.  Last time I looked I got estimates for 2009 and 2010 of $.94 and $1.12 for earnings and $3.62 and $3.60 and $3.93 for cash flow.
Jan 5, 2010.  Last time I looked this estimates for 2010 and 2011 were $1.10 and $1.33.  
Apr 10, 2010, In Jun I got 2009 and 2010 earnings of $1.35 and $1.65 and cash flow of $3.93 and $4.30
Jun 10, 2009.  When I last looked at this stock in Feb 2009, I got an EPS estimate of $1.54.  The estimate has been downgraded because of the move up of the maintainance for Sundance Units 3.  However, earnings for 2010 is up.
Feb 2009 AP 2008.  I have made a reasonable return on this stock.
AP 2007. I have made a reasonable return on this stock at about 9% IRR.  Dividend finally increased in 2008.  Everyone has a hold rating on this stock. Lst 5 yrs Total Growth is 20%IRR.  Keep at present.
This stock gets a D both for value and growth on the Money Sence review.
AP 2006.  TD rates a hold (up from reduced) based on what they expect to happen in 2007 and 2008, but gain only of 2%  Yield is lower than historical low, so you would expect a lower price.
Usually provides a decent rate of return for an company that has electrical producing plants.  EPS could be better.
2006  Feb. TD recommends reduce.
2005.  IRR including all dates, return is 8.34.  Unsteady except for last couple of year, then good.  Keep for now.  Doing what a utility stock should do. Get about 3% from price increase and rest from dividends. 
2004.  What I do not like.  Paid more dividend than earnings; Liquity is not good; IRR's are not good. AP 2004 - IRR from 1987 to Apr 2005 is 7.95%
2003.  However, I might be better off replacing some of this with Pembina.  Not doing well. 
2002.  This is a utility stock.  Usual rate of return and revenue is 8%.  It is pretty stable.  2002 as a bad year.
Increase in shares seems to be mainly due to Dividend reinvestment and share purchase plan.
Sector:
Power, Utility
What should this stock accomplish?
It should provide a moderate dividend yield and moderate dividend growth over the longer term.
Would I buy this company and Why.
Currently I will continue to hold this as I think that they are working out their problems.  I maybe wrong. 
Dividends
Cycle 1 paying in January, April, July and October.  Dividends are paid at the first of the month.  Dividends are declared by the company, usually the end of 3months prior for shareholders of record two months prior.  
That is they are declared at the end of October for policyholders at the end of November  for the following January.
Why am I following this stock. 
I am following this stock because I own it.
Why I bought this stock.
I bought this stock in 1987.  It was a utility stock and utility stocks were considered to be good investments.  I sold some in 2000 as the stock price was below what I had paid for it.
I bought some more in February 2009 because it was relatively cheap and it seemed to be recovering.  I sold more in August 2012 as this company was doing poorly again.
How they make their money
TransAlta Corp. is Canada's largest investor-owned, unregulated power generation and energy-marketing company.
The company owns and operates power plants in North America and Australia.
Daily Buy Sell Adviser  of 27 November 2013.
In a more evenly balanced Canadian Dividend 6-Pak the weak sister remains TransAlta Corp., which we're resolved to stick with through its massive transition from a coal to natural gas-fired electricity generation. 
Under the 6-Pak discipline we’ll be needing to add more: If Mr. Buffett and Berkshire Hathaway favour TransAlta, we should like it too.
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
Date Mar 30 2012 Mar 10 2013 Mar 02 2014 Mar 28 2015 Mar 20 2016 Mar 12 2017
Farrell, Dawn Lorraine 0.090 0.03% 0.090 0.03% 0.134 0.05% 0.134 0.05% 0.000 0.00%
CEO - Shares - Amount $1.208 $0.946 $0.658 $0.995 $0.00
Options - percentage 0.427 0.16% 0.489 0.18% 0.551 0.19% 0.646 0.22% 0.000 0.00%
Options - amount $5.749 $5.143 $2.706 $4.797 $0.00
Tremblay, Donald 0.000 0.00% 0.053 0.02% 0.069 0.02% 0.000 0.00% as of March 31, 2014
CFO - Shares - Amount $0.000 $0.260 $0.513 $0.00
Options - percentage 0.000 0.00% 3.102 1.09% 0.292 0.10% 0.000 0.00%
Options - amount $0.000 $15.230 $2.167 $0.00
Gellner, Brett 0.041 0.02% 0.059 0.02% 0.000 0.00% Used to be CFO
Officer - Shares - Amount $0.554 $0.436 $0.00
Options - percentage 0.118 0.04% 0.352 0.12% 0.000 0.00%
Options - amount $1.589 $2.619 $0.00
Bartel, Michael Henry 0.011 0.00% 0.011 0.00%
Officer - Shares - Amount $0.150 $0.117
Options - percentage 0.002 0.00% 0.002 0.00%
Options - amount $0.020 $0.016
Koch, Sterling Gordon 0.008 0.00% 0.011 0.00%
Officer - Shares - Amount $0.108 $0.052
Options - percentage 0.048 0.02% 0.045 0.02%
Options - amount $0.644 $0.221
Anderson, William D. 0.008 0.00% 0.008 0.00% 0.008 0.00% 0.008 0.00%
Director - Shares - Amount $0.108 $0.084 $0.039 $0.059
Options - percentage 0.032 0.01% 0.038 0.01% 0.050 0.02% 0.066 0.02%
Options - amount $0.435 $0.396 $0.246 $0.492
Jenkins, P. Thomas 0.805 0.28% 0.000 0.00% 0.000 0.00%
Director - Shares - Amount $3.952 $0.000 $0.00
Options - percentage 0.003 0.00% 0.010 0.00% 0.000 0.00%
Options - amount $0.012 $0.076 $0.00
Giffin, Gordon D 0.019 0.01% 0.029 0.01% 0.054 0.02% 0.000 0.00%
Chairman - Shares - Amt $0.197 $0.142 $0.399 $0.00
Options - percentage 0.017 0.01% 0.020 0.01% 0.022 0.01% 0.000 0.00%
Options - amount $0.182 $0.098 $0.160 $0.00
Increase in O/S Shares 0.100 0.04% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Yes, 0
due to SO $1.348 $0.000 $0.000 $0.000 $0.000
Book Value $1.000 $0.000 $0.000 $2.000 $1.000
Insider Buying $0.000 -$1.781 -$0.197 -$0.197
Insider Selling $0.000 $0.002 $6.125 $6.125
Net Insider Selling $0.000 -$1.778 $5.928 $5.928
% of Market Cap 0.00% -0.06% 0.28% 0.29%
Directors 10 30% 11 13 10 9
Women 3 3 27% 4 31% 3 30% 3 33%
Minorities 0 0% 0 0% 0 0% 0 0% 1 11%
Institutions/Holdings 211 52.72% 6 8.15% 207 52.04% 224 50.42% 6 6.14%
Total Shares Held 118.453 46.51% 0.978 0.36% 139.596 50.76% 139.671 49.18% 0.405 0.14%
Increase/Decrease 2.277 1.9% 0.125 11.3% -11.083 -7.36% -8.831 -5.95% -0.003 -0.67%
Starting No. of Shares 120.730 1.103 150.680 148.502 0.408
Copyright © 2008 Website of SPBrunner. All rights reserved.
My stock