This report should not be construed as providing investment advice. It is for educational purposes only.  Before making any investment decision, you should always do your own research or consult a investment professional. Estimates Estimates Estimates
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Q2 2026
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/
Keyera Corp TSX: KEY OTC: KEYUF http://www.keyera.com Fiscal Yr: Dec 31
Year 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27 12/31/28 Value Description #Y Item Total G
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
Start Date/ Split Date 4/6/15
Split 2
$7,188.8 <-12 mths 4.88%
Revenue* $3,277.2 $3,623.7 $2,521.1 $2,509.0 $3,413.4 $4,465.2 $3,616.9 $3,012.5 $4,984.9 $7,060.2 $7,053.1 $7,138.4 $6,854.0 $9,144 $11,235 $12,031 171.87% <-Total Growth 10 Revenue
Increase 11.38% 10.57% -30.43% -0.48% 36.05% 30.82% -19.00% -16.71% 65.47% 41.63% -0.10% 1.21% -3.98% 33.41% 22.87% 7.09% 10.52% <-IRR #YR-> 10 Revenue 171.87%
5 year Running Average $2,455.2 $2,871.0 $2,986.7 $2,974.6 $3,068.9 $3,306.5 $3,305.1 $3,403.4 $3,898.6 $4,628.0 $5,145.5 $5,849.8 $6,618.1 $7,450 $8,285 $9,280 17.87% <-IRR #YR-> 5 Revenue 127.52%
Revenue per Share $20.69 $21.48 $14.68 $13.51 $16.69 $21.21 $16.60 $13.63 $22.55 $30.81 $30.78 $31.15 $29.89 $39.88 $49.00 $52.47 8.28% <-IRR #YR-> 10 5 yr Running Average 121.59%
Increase 9.24% 3.82% -31.65% -7.97% 23.50% 27.13% -21.76% -17.88% 65.47% 36.61% -0.10% 1.21% -4.04% 33.41% 22.87% 7.09% 14.23% <-IRR #YR-> 5 5 yr Running Average 94.46%
5 year Running Average $16.64 $18.59 $18.75 $17.86 $17.41 $17.52 $16.54 $16.33 $18.14 $20.96 $22.87 $25.78 $29.04 $32.50 $36.14 $40.48 7.37% <-IRR #YR-> 10 Revenue per Share 103.59%
P/S (Price/Sales) Med 1.37 1.90 2.77 2.83 2.33 1.50 1.87 1.71 1.31 1.02 1.02 1.26 1.43 1.28 0.00 0.00 17.01% <-IRR #YR-> 5 Revenue per Share 119.32%
P/S (Price/Sales) Close 1.54 1.89 2.74 2.99 2.12 1.22 2.05 1.66 1.26 0.96 1.04 1.41 1.47 1.40 1.14 1.22 4.47% <-IRR #YR-> 10 5 yr Running Average 54.88%
*Revenue in M CDN $  P/S Med 20 yr  1.29 15 yr  1.43 10 yr  1.47 5 yr  1.26 -4.58% Diff M/C 12.20% <-IRR #YR-> 5 5 yr Running Average 77.84%
-$2,521.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $6,854.0
-$3,012.5 $0.0 $0.0 $0.0 $0.0 $6,854.0
-$2,986.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $6,618.1
-$3,403.4 $0.0 $0.0 $0.0 $0.0 $6,618.1
-$14.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.89
-$13.63 $0.00 $0.00 $0.00 $0.00 $29.89
-$18.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.04
-$16.33 $0.00 $0.00 $0.00 $0.00 $29.04
AFFO from TD
AFFO from TD $4.48 $4.20 $3.72 $4.23 $5.26 $5.38 used to be same as DC
Increase -6.25% -11.43% 13.71% 24.35% 2.28%
$552.5 <-12 mths -24.85%
$2.37 <-12 mths -26.17%
Distributable Cash (AFFO) $288.1 $389.0 $482.1 $459.6 $510.4 $638.1 $593.6 $718.2 $668.6 $653.5 $854.6 $770.9 $735.2 $804 $1,159 $1,214 52.48% <-Total Growth 10 Distributable Cash (AFFO) now Distributable Cash Flow by Cowen
Increase 44.12% 35.03% 23.95% -4.67% 11.06% 25.02% -6.98% 20.99% -6.90% -2.25% 30.77% -9.79% -4.64% -3.45% <-Median-> 10 Increase
Distributable Cash per Share $1.84 $2.37 $2.84 $2.56 $2.70 $3.08 $2.77 $3.26 $3.03 $2.95 $3.73 $3.36 $3.21 $2.99 $3.95 $4.14 13.03% <-Total Growth 10 Distributable Cash
Increase 40.46% 28.53% 20.08% -9.86% 5.47% 14.07% -10.06% 17.69% -7.06% -2.64% 26.44% -9.92% -4.46% -6.85% 32.11% 4.81% 1.23% <-IRR #YR-> 10 Distributable Cash 13.03%
AFFO Yield 5.8% 5.8% 7.1% 6.3% 7.6% 11.9% 8.1% 14.4% 10.6% 10.0% 11.6% 7.6% 7.3% 5.4% 7.1% 6.5% -0.31% <-IRR #YR-> 5 Distributable Cash -1.53%
5 year Running Average $1.63 $1.69 $1.96 $2.18 $2.46 $2.71 $2.79 $2.87 $2.97 $3.02 $3.15 $3.27 $3.26 $3.25 $3.45 $3.53 5.23% <-IRR #YR-> 10 5 yr Running Average 66.46%
Payout Ratio 60.87% 52.96% 49.21% 59.77% 60.83% 55.84% 66.43% 58.90% 63.37% 65.08% 52.55% 60.71% 66.04% 73.75% 56.96% 54.35% 2.53% <-IRR #YR-> 5 5 yr Running Average 13.29%
Payout Ratio 5 year Running 62.90% 61.99% 58.74% 57.95% 56.42% 55.68% 58.28% 60.21% 60.93% 61.76% 60.74% 59.77% 61.18% 63.08% 61.34% 61.56% 59.99% <-Median-> 10 Payout 5 yr Running Average
Price/DC Median 15.38 17.29 14.32 14.94 14.40 10.31 11.19 7.16 9.76 10.62 8.39 11.72 13.36 17.11 0.00 0.00 10.90 <-Median-> 10 Price/DC Median
Price/DC High 17.37 21.07 15.98 16.71 15.63 12.33 12.87 11.10 11.61 11.95 9.16 14.10 14.62 20.30 0.00 0.00 12.60 <-Median-> 10 Price/DC High
Price/DC Low 13.40 13.51 12.67 13.17 13.18 8.30 9.50 3.21 7.91 9.29 7.62 9.35 12.09 13.91 0.00 0.00 9.32 <-Median-> 10 Price/DC Low
Price/DC Close 17.37 17.14 14.18 15.80 13.12 8.38 12.28 6.94 9.42 10.03 8.59 13.08 13.71 18.66 14.12 15.41 11.16 <-Median-> 10 Price/DC Close
Trailing P/DC Close 13.38 13.52 14.27 15.73 14.99 11.50 9.32 10.44 7.47 9.67 7.93 9.53 13.69 14.72 14.12 13.47 10.05 <-Median-> 10 Trailing P/DC Close
Median Values Historical   in order 11.34 13.95 9.35 12.28 P/AFFO 5 Yrs   in order 10.62 11.95 9.29 10.03 75.69% Diff M/C 71.12% Diff M/C 10 DPR 75% to 95% best
* Distributable Cash Flow per share (Cdn GAAP)
-$2.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.21
-$3.26 $0.00 $0.00 $0.00 $0.00 $3.21
-$1.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.26
-$2.87 $0.00 $0.00 $0.00 $0.00 $3.26
$772.4 <-12 mths -9.51%
$3.28 <-12 mths -11.92%
Funds From Operations (FFO) $358.1 $540.1 $582.5 $542.2 $567.6 $696.3 $754.3 $810.4 $765.9 $818.8 $1,027.5 $926.4 $853.6 $1,427.0 $1,471.0 46.55% <-Total Growth 10 Distributable Cash (FFO)
Increase #DIV/0! 50.83% 7.85% -6.92% 4.70% 22.67% 8.32% 7.45% -5.50% 6.92% 25.48% -9.84% -7.86% 5.81% <-Median-> 10 Increase
Distributable Cash per Share $2.27 $3.29 $3.43 $3.02 $3.00 $3.36 $3.52 $3.68 $3.47 $3.70 $4.48 $4.04 $3.72 $4.23 $5.26 $5.38 8.65% <-Total Growth 10 Distributable Cash
Increase 44.49% 4.31% -11.98% -0.46% 11.79% 4.89% 4.40% -5.75% 6.79% 21.17% -9.84% -7.88% 13.58% 24.35% 2.28% 0.83% <-IRR #YR-> 10 Distributable Cash 8.65%
AFFO Yield 7.1% 8.1% 8.5% 7.5% 8.5% 13.0% 10.4% 16.3% 12.1% 12.5% 14.0% 9.2% 8.5% 7.6% 9.4% 8.4% 0.26% <-IRR #YR-> 5 Distributable Cash 1.30%
5 year Running Average $3.00 $3.22 $3.27 $3.32 $3.40 $3.54 $3.77 $3.87 $3.88 $4.04 $4.35 $4.53 2.93% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
Payout Ratio 49.25% 38.12% 40.77% 50.71% 54.69% 51.23% 52.25% 52.22% 55.41% 51.89% 43.71% 50.46% 56.92% 52.13% 42.78% 41.82% 3.21% <-IRR #YR-> 5 5 yr Running Average 17.14%
Payout Ratio 5 year Running 46.26% 46.87% 49.79% 52.20% 53.12% 52.59% 50.72% 50.39% 51.30% 50.76% 48.64% 48.00% 50.72% <-Median-> 9 Payout 5 yr Running Average
Price/DC Median 12.45 12.44 11.87 12.67 12.95 9.46 8.80 6.35 8.54 8.47 6.98 9.74 11.51 12.09 0.00 0.00 9.13 <-Median-> 10 Price/DC Median
Price/DC High 14.06 15.16 13.24 14.18 14.05 11.31 10.12 9.84 10.15 9.53 7.62 11.72 12.60 14.35 0.00 0.00 10.73 <-Median-> 10 Price/DC High
Price/DC Low 10.84 9.73 10.49 11.17 11.85 7.61 7.47 2.85 6.92 7.40 6.34 7.77 10.42 9.83 0.00 0.00 7.54 <-Median-> 10 Price/DC Low
Price/DC Close 14.06 12.33 11.75 13.41 11.79 7.69 9.66 6.15 8.23 8.00 7.14 10.87 11.81 13.19 10.60 11.86 8.95 <-Median-> 10 Price/DC Close
Trailing P/DC Close 10.82 9.73 11.82 13.34 13.47 10.55 7.33 9.25 6.53 7.71 6.60 7.92 11.80 10.40 10.60 10.37 8.59 <-Median-> 10 Trailing P/DC Close
Median Values Historical   in order 9.74 11.72 7.77 10.87 P/FFO 5 Yrs   in order 8.54 10.15 7.40 8.23 54.50% Diff M/C 44.43% Diff M/C 10 DPR 75% to 95% best
Funds From Operations (FFO)
-$3.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.72
-$3.68 $0.00 $0.00 $0.00 $0.00 $3.72
-$3.27 $0.00 $0.00 $0.00 $0.00 $0.00 $3.88
-$3.32 $0.00 $0.00 $0.00 $0.00 $3.88
TD says $1.48 $1.85 $2.14 $2.01 $2.33 $3.18 $3.41 TD says
$1.53 <-12 mths -19.05%
Pre-split 2015 $1.87
EPS Basic $0.94 $1.40 $1.19 $1.21 $1.53 $1.90 $2.07 $0.28 $1.47 $1.48 $1.85 $2.12 $1.89 58.82% <-Total Growth 10 EPS Basic
Actual EPS 2003
Pre-split 2015 $1.87
EPS Diluted* $0.94 $1.40 $1.19 $1.21 $1.53 $1.90 $2.07 $0.28 $1.47 $1.48 $1.85 $2.12 $1.89 $2.21 $3.08 $3.32 58.82% <-Total Growth 10 EPS Diluted
Increase 9.36% 49.73% -15.00% 1.68% 26.45% 24.18% 8.95% -86.47% 425.00% 0.68% 25.00% 14.59% -10.85% 17.14% 39.07% 7.92% 10 0 10 Years of Data, EPS P or N
Earnings Yield 2.9% 3.5% 3.0% 3.0% 4.3% 7.4% 6.1% 1.2% 5.2% 5.0% 5.8% 4.8% 4.3% 4.0% 5.5% 5.2% 4.73% <-IRR #YR-> 10 Earnings per Share 58.82%
5 year Running Average $0.96 $1.01 $1.07 $1.12 $1.25 $1.45 $1.58 $1.40 $1.45 $1.44 $1.43 $1.44 $1.76 $1.91 $2.23 $2.53 46.51% <-IRR #YR-> 5 Earnings per Share 575.00%
10 year Running Average $0.75 $0.87 $0.94 $1.00 $1.14 $1.20 $1.29 $1.23 $1.28 $1.35 $1.44 $1.51 $1.58 $1.68 $1.84 $1.98 5.15% <-IRR #YR-> 10 5 yr Running Average 65.29%
* Diluted ESP per share  E/P 10 Yrs 4.91% 5Yrs 5.00% 4.74% <-IRR #YR-> 5 5 yr Running Average 26.04%
-$1.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.89
-$0.28 $0.00 $0.00 $0.00 $0.00 $1.89
-$1.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.76
-$1.40 $0.00 $0.00 $0.00 $0.00 $1.76
Dividend* $2.21 $2.31 $2.39 Estimates Dividend*
Increase 4.39% 4.20% 3.43% Estimates Increase
Payout Ratio EPS 99.95% 74.89% 71.77% Estimates Payout Ratio EPS
Pre-split 2015 $0.00
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 $0.00 <-Median-> 10 Special Dividends
Pre-split 2015 $2.24 $2.51
Dividend* $1.12 $1.25 $1.40 $1.53 $1.64 $1.72 $1.84 $1.92 $1.92 $1.92 $1.96 $2.04 $2.12 $2.21 $2.25 $2.25 51.70% <-Total Growth 10 Dividends
Increase 9.27% 11.83% 11.58% 9.48% 7.35% 4.72% 6.98% 4.35% 0.00% 0.00% 2.08% 4.08% 3.92% 4.01% 2.04% 0.00% 19 0 22 Years of data, Count P, N 86.36%
Average Increases 5 Year Running 6.23% 6.91% 9.23% 10.01% 9.90% 8.99% 8.02% 6.58% 4.68% 3.21% 2.68% 2.10% 2.02% 2.82% 3.23% 2.81% 5.63% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $1.02 $1.05 $1.15 $1.27 $1.39 $1.51 $1.63 $1.73 $1.81 $1.86 $1.91 $1.95 $1.99 $2.05 $2.12 $2.17 73.37% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 3.96% 3.06% 3.44% 4.00% 4.22% 5.41% 5.94% 8.23% 6.49% 6.13% 6.26% 5.18% 4.94% 4.31% 5.68% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 3.50% 2.51% 3.08% 3.58% 3.89% 4.53% 5.16% 5.31% 5.46% 5.45% 5.74% 4.30% 4.52% 3.63% 4.84% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 4.54% 3.92% 3.89% 4.54% 4.62% 6.73% 6.99% 18.32% 8.01% 7.01% 6.90% 6.50% 5.46% 5.30% 6.82% <-Median-> 10 Yield on Low Price AFFO
Yield on Close Price 3.50% 3.09% 3.47% 3.78% 4.64% 6.66% 5.41% 8.49% 6.73% 6.49% 6.12% 4.64% 4.82% 3.95% 4.03% 3.53% 5.76% <-Median-> 10 Yield on Close Price FFO
Payout Ratio EPS 119.79% 89.46% 117.44% 126.45% 107.35% 90.53% 88.89% 685.71% 130.61% 129.73% 105.95% 96.23% 112.17% 99.59% 73.08% 67.71% 109.76% <-Median-> 10 DPR EPS CFPS
DPR EPS 5 Yr Running 106.89% 104.01% 107.79% 113.15% 110.81% 104.32% 102.91% 123.78% 124.72% 129.44% 133.71% 135.56% 113.05% 107.23% 94.82% 86.05% 118.47% <-Median-> 10 DPR EPS 5 Yr Running FCF 
Payout Ratio CFPS 46.06% 45.87% 37.02% 68.80% 65.40% 59.91% 45.16% 61.67% 72.69% 47.55% 46.04% 36.93% 62.76% 54.14% 40.56% 37.88% 60.79% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 58.94% 58.06% 49.05% 49.83% 50.78% 53.45% 52.60% 58.48% 59.44% 55.68% 52.75% 49.86% 50.21% 48.17% 46.42% 44.42% 52.67% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 49.54% 39.12% 41.19% 52.40% 59.19% 50.95% 53.16% 52.36% 55.41% 53.73% 43.71% 48.57% 56.94% 54.14% 40.56% 37.88% 52.78% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 53.69% 49.24% 46.48% 46.86% 47.71% 48.15% 51.05% 53.41% 54.00% 53.13% 51.26% 50.34% 51.22% 51.09% 48.01% 46.27% 51.14% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 5.68% 5.76% 5 Yr Med 5 Yr Cl 6.13% 6.12% 5 Yr Med Payout 112.17% 47.55% 53.73% 2.00% <-IRR #YR-> 5 Dividends 10.42%
* Dividends per share  10 Yr Med and Cur. -28.94% -30.02% 5 Yr Med and Cur. -34.19% -34.08% Last Div Inc ---> $0.540 $0.563 4.17% 4.26% <-IRR #YR-> 10 Dividends 51.70%
Dividends Growth 15 5.88% <-IRR #YR-> 15 Dividends 135.56%
Dividends Growth 20 6.09% <-IRR #YR-> 20 Dividends
Dividends Growth 25 9.78% <-IRR #YR-> 22 Dividends
Dividends Growth 5 -$1.92 $0.00 $0.00 $0.00 $0.00 $2.12 Dividends Growth 5
Dividends Growth 10 -$1.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.12 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.12 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.12 Dividends Growth 20
Dividends Growth 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.12 Dividends Growth 25
Historical Dividends Historical High Div 12.00% Low Div 3.25% 10 Yr High 17.29% 10 Yr Low 3.61% Med Div 5.94% Close Div 5.41% Historical Dividends
High/Ave/Median Values Curr diff Exp. -66.39%     24.11% Exp. -76.67% 11.74% Exp. -32.09% Exp. -25.42% 5.06% Since 2010 High/Ave/Median 
-20.28% Exp.
Future Dividend Yield Div Yd 4.45% earning in 5 Years at IRR of 2.00% Div Inc. 10.42% Future Dividend Yield
Future Dividend Yield Div Yd 4.92% earning in 10 Years at IRR of 2.00% Div Inc. 21.92% Future Dividend Yield
Future Dividend Yield Div Yd 5.43% earning in 15 Years at IRR of 2.00% Div Inc. 34.62% Future Dividend Yield
Future Dividend Paid Div Paid $2.48 earning in 5 Years at IRR of 2.00% Div Inc. 10.42% Future Dividend Paid Div Pd
Future Dividend Paid Div Paid $2.74 earning in 10 Years at IRR of 2.00% Div Inc. 21.92% Future Dividend Paid $2.48
Future Dividend Paid Div Paid $3.03 earning in 15 Years at IRR of 2.00% Div Inc. 34.62% Future Dividend Paid $2.74
$3.03
Dividend Covering Cost Total Div $11.71 over 5 Years at IRR of 2.00% Div Cov. 20.99% Dividend Covering Cost
Dividend Covering Cost Total Div $22.15 over 10 Years at IRR of 2.00% Div Cov. 39.72% Dividend Covering Cost
Dividend Covering Cost Total Div $33.69 over 15 Years at IRR of 2.00% Div Cov. 60.39% Dividend Covering Cost
Div Yd
Yield if held 5 years 11.61% 12.94% 9.35% 7.26% 7.40% 6.08% 4.50% 4.72% 5.02% 4.94% 6.17% 6.58% 9.09% 7.46% 7.18% 7.19% 6.12% <-Median-> 10 Paid Median Price 7.46%
Yield if held 10 years 19.54% 19.82% 14.75% 15.14% 18.53% 17.83% 19.01% 12.84% 9.11% 8.65% 6.92% 4.99% 5.21% 5.77% 5.79% 7.08% 10.98% <-Median-> 10 Paid Median Price 5.77%
Yield if held 15 years 30.00% 29.11% 20.27% 19.01% 21.66% 20.32% 21.07% 14.18% 10.47% 10.13% 7.95% 20.70% <-Median-> 8 Paid Median Price 10.47%
Yield if held 20 years 34.19% 32.28% 22.38% 21.83% 25.39% 23.33% 32.28% <-Median-> 3 Paid Median Price 21.83%
39.25% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 53.08% 54.21% 38.43% 30.02% 31.26% 26.64% 19.88% 21.27% 23.65% 23.97% 30.10% 31.50% 42.69% 34.64% 33.76% 34.72% 28.33% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 149.91% 147.17% 106.09% 107.55% 132.83% 131.29% 138.20% 96.30% 72.94% 73.23% 60.42% 43.75% 45.75% 50.44% 51.16% 64.30% 84.77% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 281.49% 275.81% 197.43% 197.06% 238.00% 230.40% 239.02% 162.93% 121.56% 120.85% 98.80% 234.20% <-Median-> 8 Paid Median Price
Cost covered if held 20 years 448.25% 430.24% 302.58% 298.47% 357.32% 343.05% 430.24% <-Median-> 3 Paid Median Price
637.79% #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $3,012.5 $4,984.9 $7,060.2 $7,053.1 $7,138.4 $6,854.0 $7,188.8 <-12 mths 4.88% 127.52% <-Total Growth 5 Revenue Growth  127.52%
AFFO Growth $3.26 $3.03 $2.95 $3.73 $3.36 $3.21 $2.37 <-12 mths -26.17% -1.53% <-Total Growth 5 AFFO Growth -1.53%
Net Income Growth $62.0 $324.2 $328.3 $424.0 $486.6 $432.3 $382.1 <-12 mths -11.61% 596.98% <-Total Growth 5 Net Income Growth 596.98%
Cash Flow Growth $688.2 $583.8 $925.3 $975.5 $1,265.8 $774.5 $476.8 <-12 mths -38.45% 12.55% <-Total Growth 5 Cash Flow Growth 12.55%
Dividend Growth $1.92 $1.92 $1.92 $1.96 $2.04 $2.12 $2.21 <-12 mths 4.01% 10.42% <-Total Growth 5 Dividend Growth 10.42%
Stock Price Growth $22.62 $28.53 $29.59 $32.03 $43.96 $44.00 $55.78 <-12 mths 26.77% 94.52% <-Total Growth 5 Stock Price Growth 94.52%
Revenue Growth  $2,521.1 $2,509.0 $3,413.4 $4,465.2 $3,616.9 $3,012.5 $4,984.9 $7,060.2 $7,053.1 $7,138.4 $6,854.0 $9,144.0 <-this year 33.41% 171.87% <-Total Growth 10 Revenue Growth  171.87%
AFFO Growth $2.84 $2.56 $2.70 $3.08 $2.77 $3.26 $3.03 $2.95 $3.73 $3.36 $3.21 $2.99 <-this year -6.85% 13.03% <-Total Growth 10 AFFO Growth 13.03%
Net Income Growth $201.9 $216.9 $289.9 $394.2 $443.6 $62.0 $324.2 $328.3 $424.0 $486.6 $432.3 $600.0 <-this year 38.78% 114.11% <-Total Growth 10 Net Income Growth 114.11%
Cash Flow Growth $648.2 $412.9 $513.7 $604.3 $887.9 $688.2 $583.8 $925.3 $975.5 $1,265.8 $774.5 $933.9 <-this year 20.57% 19.50% <-Total Growth 10 Cash Flow Growth 19.50%
Dividend Growth $1.40 $1.53 $1.64 $1.72 $1.84 $1.92 $1.92 $1.92 $1.96 $2.04 $2.12 $2.21 <-this year 4.39% 51.70% <-Total Growth 10 Dividend Growth 51.70%
Stock Price Growth $40.26 $40.46 $35.42 $25.81 $34.02 $22.62 $28.53 $29.59 $32.03 $43.96 $44.00 $63.80 <-this year 45.00% 9.29% <-Total Growth 10 Stock Price Growth 9.29%
Dividends on Shares $38.25 $41.06 $43.00 $46.00 $48.00 $48.00 $48.00 $49.00 $51.00 $53.00 $55.13 $56.25 $56.25 $465.31 No of Years 10 Total Divs 12/31/15
Paid  $1,006.50 $1,011.50 $885.50 $645.25 $850.50 $565.50 $713.25 $739.75 $800.75 $1,099.00 $1,100.00 $1,394.50 $1,394.50 $1,595.00 $1,100.00 No of Years 10 Worth $40.26
Total $1,565.31
Graham No. EPS $11.08 $15.69 $14.77 $16.43 $20.43 $23.55 $25.55 $8.87 $19.94 $20.24 $22.47 $24.28 $22.64 $33.87 $39.95 $41.50 53.35% <-Total Growth 10 Graham Number EPS
Price/GP Ratio Med 2.56 2.61 2.75 2.33 1.90 1.35 1.21 2.63 1.48 1.55 1.39 1.62 1.89 1.51 1.59 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 2.89 3.18 3.07 2.60 2.07 1.61 1.40 4.08 1.76 1.74 1.52 1.95 2.07 1.79 1.86 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 2.23 2.04 2.44 2.05 1.74 1.09 1.03 1.18 1.20 1.35 1.26 1.29 1.71 1.23 1.28 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 2.89 2.58 2.73 2.46 1.73 1.10 1.33 2.55 1.43 1.46 1.43 1.81 1.94 1.65 1.40 1.54 1.60 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 188.57% 158.32% 172.65% 146.23% 73.40% 9.61% 33.16% 154.97% 43.06% 46.20% 42.55% 81.08% 94.31% 64.67% 39.64% 53.74% 59.80% <-Median-> 10 Graham Price
Pre-split 2015 $63.93
Price Close $31.97 $40.53 $40.26 $40.46 $35.42 $25.81 $34.02 $22.62 $28.53 $29.59 $32.03 $43.96 $44.00 $55.78 $55.78 $63.80 9.29% <-Total Growth 10 Stock Price
Increase 29.86% 26.79% -0.67% 0.50% -12.46% -27.13% 31.81% -33.51% 26.13% 3.72% 8.25% 37.25% 0.09% 26.77% 0.00% 14.38% 24.42 <-Median-> 10 CAPE (10 Yr P/E)
P/E 34.19 28.95 33.83 33.44 23.15 13.58 16.43 80.79 19.41 19.99 17.31 20.74 23.28 25.19 18.12 19.20 14.23% <-IRR #YR-> 5 Stock Price 94.52%
Trailing P/E 37.39 43.35 28.76 34.00 29.27 16.87 17.91 10.93 101.89 20.13 21.64 23.76 20.75 29.51 25.19 20.72 0.89% <-IRR #YR-> 10 Stock Price 9.29%
CAPE (10 Yr P/E) 20.79 21.94 23.42 25.08 24.22 24.45 24.38 26.03 25.25 24.45 22.90 22.03 21.29 20.93 20.28 20.74 21.14% <-IRR #YR-> 5 Price & Dividend 138.55%
Median 10, 5 Yrs D.  per yr 4.40% 6.91% % Tot Ret 83.13% 32.68% T P/E 21.20 21.64 P/E:  20.36 19.99 5.29% <-IRR #YR-> 10 Price & Dividend 55.52%
Price  15 D.  per yr 5.88% % Tot Ret 48.22% CAPE Diff 3.19% 6.31% <-IRR #YR-> 15 Stock Price 150.36%
Price  20 D.  per yr 6.53% % Tot Ret 47.42% 7.24% <-IRR #YR-> 20 Stock Price 304.60%
Price  25 D.  per yr 9.01% % Tot Ret 47.60% 9.92% <-IRR #YR-> 23 Stock Price
Price & Dividend 15 12.18% <-IRR #YR-> 15 Price & Dividend 288.95%
Price & Dividend 20 13.77% <-IRR #YR-> 20 Price & Dividend 5.6815172
Price & Dividend 25 18.92% <-IRR #YR-> 23 Price & Dividend
Price  5 -$22.62 $0.00 $0.00 $0.00 $0.00 $44.00 Price  5
Price 10 -$40.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.00 Price 10
Price & Dividend 5 -$22.62 $1.92 $1.92 $1.96 $2.04 $46.12 Price & Dividend 5
Price & Dividend 10 -$40.26 $1.53 $1.64 $1.72 $1.84 $1.92 $1.92 $1.92 $1.96 $2.04 $46.12 Price & Dividend 10
Price  15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.00 Price  15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.00 Price  20
Price  25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.00 Price  25
Price & Dividend 15 $1.12 $1.25 $1.40 $1.53 $1.64 $1.72 $1.84 $1.92 $1.92 $1.92 $1.96 $2.04 $46.12 Price & Dividend 15
Price & Dividend 20 $1.12 $1.25 $1.40 $1.53 $1.64 $1.72 $1.84 $1.92 $1.92 $1.92 $1.96 $2.04 $46.12 Price & Dividend 20
Price & Dividend 25 $1.12 $1.25 $1.40 $1.53 $1.64 $1.72 $1.84 $1.92 $1.92 $1.92 $1.96 $2.04 $46.12 Price & Dividend 25
Price H/L Median $28.31 $40.89 $40.68 $38.24 $38.89 $31.77 $30.99 $23.33 $29.58 $31.33 $31.29 $39.40 $42.88 $51.15 5.40% <-Total Growth 10 Stock Price
Increase 27.47% 44.45% -0.51% -6.00% 1.70% -18.32% -2.46% -24.71% 26.77% 5.92% -0.11% 25.90% 8.83% 19.29% 0.53% <-IRR #YR-> 10 Stock Price 5.40%
P/E 30.28 29.21 34.18 31.60 25.42 16.72 14.97 83.32 20.12 21.17 16.91 18.58 22.69 23.10 12.94% <-IRR #YR-> 5 Stock Price 83.78%
Trailing P/E 33.11 43.73 29.06 32.13 32.14 20.76 16.31 11.27 105.63 21.31 21.14 21.29 20.22 27.06 4.95% <-IRR #YR-> 10 Price & Dividend 126.47%
P/E on Run. 5 yr Ave 20.69 21.48 14.68 13.51 16.69 21.21 16.60 13.63 22.55 30.81 30.78 31.15 29.89 39.88 19.77% <-IRR #YR-> 5 Price & Dividend 51.15%
P/E on Run. 10 yr Ave 18.33 21.67 14.84 12.77 18.32 26.11 15.12 14.06 23.38 32.62 30.07 27.92 29.13 36.57 21.17 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 4.42% 6.83% % Tot Ret 89.35% 34.54% T P/E 21.22 21.29 P/E:  20.64 20.12 Count 22 Years of data
-$40.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.88
-$23.33 $0.00 $0.00 $0.00 $0.00 $42.88
-$40.68 $1.53 $1.64 $1.72 $1.84 $1.92 $1.92 $1.92 $1.96 $2.04 $45.00
-$23.33 $1.92 $1.92 $1.96 $2.04 $45.00
High Months Dec Sep Apr Sep Jun Aug Jul Feb Jun Jun Nov Nov Oct Jul
Pre-split 2015 $63.93 $99.33
Price High $31.97 $49.82 $45.39 $42.77 $42.19 $37.98 $35.65 $36.18 $35.17 $35.25 $34.17 $47.39 $46.93 $60.71 3.39% <-Total Growth 10 Stock Price
Increase 24.79% 55.86% -8.89% -5.77% -1.36% -9.98% -6.13% 1.49% -2.79% 0.23% -3.06% 38.69% -0.97% 29.36% 0.33% <-IRR #YR-> 10 Stock Price 3.39%
P/E 34.19 35.59 38.14 35.35 27.58 19.99 17.22 129.21 23.93 23.82 18.47 22.35 24.83 27.42 5.34% <-IRR #YR-> 5 Stock Price 29.71%
Trailing P/E 37.39 53.28 32.42 35.94 34.87 24.82 18.76 17.48 125.61 23.98 23.09 25.62 22.14 32.12 24.26 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 24.40 23.98 P/E:  23.87 23.82 35.39 P/E Ratio Historical High
-$45.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.93
-$36.18 $0.00 $0.00 $0.00 $0.00 $46.93
Low Months Jan Jan Oct Feb Sep Dec Jan Mar Jan Jan Mar Feb Apr Jan
Price Low $24.65 $31.96 $35.97 $33.71 $35.59 $25.55 $26.32 $10.48 $23.98 $27.40 $28.41 $31.40 $38.82 $41.58 7.92% <-Total Growth 10 Stock Price
Increase 31.12% 29.66% 12.55% -6.28% 5.58% -28.21% 3.01% -60.18% 128.82% 14.26% 3.69% 10.52% 23.63% 7.11% 0.77% <-IRR #YR-> 10 Stock Price 7.92%
P/E 26.36 22.83 30.23 27.86 23.26 13.45 12.71 37.43 16.31 18.51 15.36 14.81 20.54 18.78 29.94% <-IRR #YR-> 5 Stock Price 270.42%
Trailing P/E 28.83 34.18 25.69 28.33 29.41 16.70 13.85 5.06 85.64 18.64 19.20 16.97 18.31 22.00 18.04 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 18.48 18.64 P/E:  17.41 16.31 13.39 P/E Ratio Historical Low
-$35.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38.82
Free Cash Flow Mkt Scn -$203.3 $155.0 $213.2 $29.0 $639.3 $1,013.0 $279.4 $178.2 $975.6 $1,353.0 #DIV/0! <-Total Growth 6 Free Cash Flow Mkt Scn
Change 176.24% 37.55% -86.40% 2104.48% 58.45% -72.42% -36.22% 447.47% 38.68% 48.00% <-Median-> 6 Change
$144 <-12 mths -74.87%
Free Cash Flow MS $45.58 -$470.00 -$150 -$220 -$190 -$610 -$340 $150 $250 -$80 $320 $710 $571 480.73% <-Total Growth 10 Free Cash Flow MS
Change -1131.15% 68.09% -46.67% 13.64% -221.05% 44.26% 144.12% 66.67% -132.00% 500.00% 121.88% -19.56% 28.95% <-Median-> 10 Change
-$296 <-12 mths -206.19%
Free Cash Flow WSJ $45.58 -$326.20 -$58.10 -$154.12 -$185.30 -$382.99 -$203.27 $94 $67 $29 $273 $1,013 $279 $178 $976 580.21% <-Total Growth 10 Free Cash Flow WSJ
Change -36.69% -815.66% 82.19% -165.27% -20.23% -106.69% 46.93% 146.24% -28.72% -56.72% 841.38% 271.06% -72.46% -36.13% 447.47% 24.31% <-IRR #YR-> 5 Free Cash Flow MS 196.81%
FCF/CF from Op Ratio 0.12 -0.71 -0.09 -0.37 -0.36 -0.63 -0.23 0.14 0.11 0.03 0.28 0.80 0.36 0.19 0.77 #NUM! <-IRR #YR-> 10 Free Cash Flow MS 580.21%
Dividends paid $175.31 $205.00 $237.00 $274.00 $309.00 $356.33 $393.57 $422.99 $422.99 $424.36 $485.81 $467.47 $485.95 $505.57 $515.89 105.04% <-Total Growth 10 Dividends paid
Percentage paid 384.61% -62.84% -407.92% -177.78% -166.76% -93.04% -193.62% 449.99% 631.33% 1463.32% 177.95% 46.15% 174.17% 283.71% 52.88% $1.10 <-Median-> 10 Percentage paid
5 Year Coverage -601.98% -407.27% -248.69% -177.00% -124.81% -159.58% -211.13% -311.99% -509.83% 827.66% 150.65% 137.66% 133.68% 90.51% 5 Year Coverage
Dividend Coverage Ratio 0.26 -1.59 -0.25 -0.56 -0.60 -1.07 -0.52 0.22 0.16 0.07 0.56 2.17 0.57 0.35 1.89 0.11 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage -0.17 -0.25 -0.40 -0.56 -0.80 -0.63 -0.47 -0.32 -0.20 0.12 0.66 0.73 0.75 1.10 5 Year of Coverage
Market Cap $5,062 $6,836 $6,913 $7,513 $7,245 $5,432 $7,413 $5,000 $6,306 $6,781 $7,340 $10,074 $10,088 $12,789 $12,789 $14,628 45.94% <-Total Growth 10 Market Cap See Rev
Long Term Incentive Plan Exp $28.30 $38.51 $32.15 $16.84 $13.91 $14.26 $26.13 -$1.12 $27.03 $33.28 $50.91 $62.45 $43.80 non-operating expense Statement
Increase 176.53% 36.10% -16.53% -47.61% -17.42% 2.55% 83.24% -104.29% -2509.00% 23.14% 52.95% 22.67% -29.87% Affects  EPS & CF Long-term
Percent of Market Cap 0.56% 0.56% 0.47% 0.22% 0.19% 0.26% 0.35% -0.02% 0.43% 0.49% 0.69% 0.62% 0.43% 0.39% <-Median-> 10 Percent of Market Cap Incentive Plan expense
Percent of Income 19.27% 16.75% 15.92% 7.77% 4.80% 3.62% 5.89% -1.81% 8.34% 10.14% 12.01% 12.83% 10.13% 8.05% <-Median-> 10 Percent of Income
Diluted # of Shares in Million 157.456 164.366 169.936 179.688 189.002 207.397 214.186 220.442 221.023 221.290 229.153 229.153 229.205 229.153 229.153 229.153 34.88% <-Total Growth 10 Diluted
Change 2.40% 4.39% 3.39% 5.74% 5.18% 9.73% 3.27% 2.92% 0.26% 0.12% 3.55% 0.00% 0.02% -0.02% 0.00% 0.00% 3.10% <-Median-> 10 Change
Difference Diluted/Basic -0.5% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 12.1% -100.0% -100.0% 0.00% <-Median-> 10 Difference Diluted/Basic
Basic # of Shares in Millions 156.632 164.366 169.936 179.688 189.002 207.397 214.186 220.442 221.023 221.290 229.153 229.153 229.205 256.853 34.88% <-Total Growth 10 Average
Change 2.80% 4.94% 3.39% 5.74% 5.18% 9.73% 3.27% 2.92% 0.26% 0.12% 3.55% 0.00% 0.02% 12.06% 3.10% <-Median-> 10 Change
Difference Basic/Outstanding 1.1% 2.6% 1.0% 3.3% 8.2% 1.5% 1.7% 0.3% 0.0% 3.6% 0.0% 0.0% 0.0% -10.7% 0.87% <-Median-> 10 Difference Basic/Outstanding
$476.76 <-12 mths -38.45%
# of Share in Millions 158.373 168.677 171.702 185.683 204.547 210.479 217.916 221.023 221.023 229.153 229.153 229.153 229.283 229.283 229.283 229.283 2.93% <-IRR #YR-> 10 Shares 33.54%
Change 1.96% 6.51% 1.79% 8.14% 10.16% 2.90% 3.53% 1.43% 0.00% 3.68% 0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.74% <-IRR #YR-> 5 Shares 3.74%
CF fr Op $M $385.1 $460.6 $648.2 $412.9 $513.7 $604.3 $887.9 $688.2 $583.8 $925.3 $975.5 $1,265.8 $774.5 $933.9 $1,271.8 $1,361.9 19.50% <-Total Growth 10 Cash Flow
Increase 61.82% 19.61% 40.72% -36.29% 24.40% 17.64% 46.93% -22.50% -15.16% 58.49% 5.42% 29.76% -38.81% 20.57% 36.19% 7.08% Deb. Conv DRIP, S. Issue
5 year Running Average $253.6 $283.1 $382.0 $428.9 $484.1 $527.9 $613.4 $621.4 $655.6 $737.9 $812.2 $887.7 $905.0 $975.0 $1,044.3 $1,121.6 136.91% <-Total Growth 10 CF 5 Yr Running
CFPS $2.43 $2.73 $3.77 $2.22 $2.51 $2.87 $4.07 $3.11 $2.64 $4.04 $4.26 $5.52 $3.38 $4.07 $5.55 $5.94 51.91% <-Total Growth 10 Cash Flow per Share
Increase 58.70% 12.30% 38.24% -41.09% 12.93% 14.33% 41.91% -23.59% -15.16% 52.87% 5.42% 29.76% -38.84% 20.57% 36.19% 7.08% 1.80% <-IRR #YR-> 10 Cash Flow 19.50%
5 year Running Average $1.74 $1.81 $2.34 $2.54 $2.73 $2.82 $3.09 $2.96 $3.04 $3.35 $3.62 $3.91 $3.97 $4.25 $4.56 $4.89 2.39% <-IRR #YR-> 5 Cash Flow 12.55%
P/CF on Median H/L 11.64 14.97 10.78 17.20 15.49 11.06 7.60 7.49 11.20 7.76 7.35 7.13 12.69 12.56 0.00 0.00 -1.10% <-IRR #YR-> 10 Cash Flow per Share -10.51%
P/CF on Close Price 13.15 14.84 10.67 18.19 14.10 8.99 8.35 7.26 10.80 7.33 7.52 7.96 13.03 13.70 10.06 10.74 1.64% <-IRR #YR-> 5 Cash Flow per Share 8.50%
45.53% Diff M/C 5.41% <-IRR #YR-> 10 CFPS 5 yr Running 69.36%
$772.43 <-12 mths -9.51%
Excl.Working Capital CF -$27.0 $79.5 -$65.7 $129.2 $53.9 $106.2 -$133.7 $122.3 $182.0 -$106.5 $52.0 -$303.4 $79.1 $0.0 $0.0 $0.0 6.04% <-IRR #YR-> 5 CFPS 5 yr Running 34.09%
CF fr Op $M WC $358.1 $540.1 $582.5 $542.2 $567.6 $710.6 $754.3 $810.4 $765.9 $818.8 $1,027.5 $962.4 $853.6 $933.9 $1,271.8 $1,361.9 46.55% <-Total Growth 10 Cash Flow less WC
Increase 33.77% 50.83% 7.85% -6.92% 4.70% 25.18% 6.15% 7.45% -5.50% 6.92% 25.48% -6.33% -11.31% 9.40% 36.19% 7.08% 3.90% <-IRR #YR-> 10 Cash Flow less WC 46.55%
5 year Running Average $278.2 $331.4 $400.7 $458.1 $518.1 $588.6 $631.4 $677.0 $721.8 $772.0 $835.4 $877.0 $885.7 $919.3 $1,009.8 $1,076.7 1.04% <-IRR #YR-> 5 Cash Flow less WC 5.33%
CFPS Excl. WC $2.26 $3.20 $3.39 $2.92 $2.78 $3.38 $3.46 $3.67 $3.47 $3.57 $4.48 $4.20 $3.72 $4.07 $5.55 $5.94 8.26% <-IRR #YR-> 10 CF less WC 5 Yr Run 121.04%
Increase 31.19% 41.62% 5.95% -13.93% -4.95% 21.65% 2.53% 5.94% -5.50% 3.12% 25.48% -6.33% -11.36% 9.40% 36.19% 7.08% 5.52% <-IRR #YR-> 5 CF less WC 5 Yr Run 30.82%
5 year Running Average $1.91 $2.13 $2.47 $2.70 $2.91 $3.13 $3.18 $3.24 $3.35 $3.51 $3.73 $3.88 $3.89 $4.01 $4.41 $4.70 0.93% <-IRR #YR-> 10 CFPS - Less WC 9.74%
P/CF on Median H/L 12.52 12.77 11.99 13.10 14.01 9.41 8.95 6.36 8.54 8.77 6.98 9.38 11.52 12.56 0.00 0.00 0.30% <-IRR #YR-> 5 CFPS - Less WC 1.53%
P/CF on High Price 14.14 15.56 13.38 14.65 15.20 11.25 10.30 9.87 10.15 9.86 7.62 11.28 12.61 14.91 0.00 0.00 10.15 <-Median-> 5 P/CF High Price
P/CF on Low Price 10.90 9.98 10.60 11.55 12.82 7.57 7.60 2.86 6.92 7.67 6.34 7.48 10.43 10.21 0.00 0.00 7.48 <-Median-> 5 P/CF Low Price
P/CF on Close Price 14.14 12.66 11.87 13.86 12.76 7.65 9.83 6.17 8.23 8.28 7.14 10.47 11.82 13.70 10.06 10.74 4.64% <-IRR #YR-> 10 CFPS 5 yr Running 57.33%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 9.41 5 yr  7.76 P/CF Med 10 yr 9.17 5 yr  8.77 49.41% Diff M/C 3.72% <-IRR #YR-> 5 CFPS 5 yr Running 20.04%
-$3.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.38 Cash Flow per Share
-$3.11 $0.00 $0.00 $0.00 $0.00 $3.38 Cash Flow per Share
-$2.34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.97 CFPS 5 yr Running
-$2.96 $0.00 $0.00 $0.00 $0.00 $3.97 CFPS 5 yr Running
-$582.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $853.6 Cash Flow less WC
-$810.4 $0.0 $0.0 $0.0 $0.0 $853.6 Cash Flow less WC
-$400.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $885.7 CF less WC 5 Yr Run
-$677.0 $0.0 $0.0 $0.0 $0.0 $885.7 CF less WC 5 Yr Run
-$3.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.72 CFPS - Less WC
-$3.67 $0.00 $0.00 $0.00 $0.00 $3.72 CFPS - Less WC
-$2.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.89 CFPS 5 yr Running
-$3.24 $0.00 $0.00 $0.00 $0.00 $3.89 CFPS 5 yr Running
OPM 11.75% 12.71% 25.71% 16.46% 15.05% 13.53% 24.55% 22.84% 11.71% 13.11% 13.83% 17.73% 11.30% 10.21% -56.05% <-Total Growth 10 OPM
Increase 45.28% 8.17% 102.27% -35.98% -8.56% -10.07% 81.39% -6.95% -48.73% 11.90% 5.53% 28.21% -36.27% -9.62% Should increase  or be stable.
Diff from Median -18.6% -12.0% 78.0% 14.0% 4.2% -6.3% 70.0% 58.2% -18.9% -9.2% -4.2% 22.8% -21.7% -29.3% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 14.44% 5 Yrs 13.11% should be  zero, it is a   check on calculations
$1,051 <-12 mths -7.09%
$1,160.4
Adjusted EBITDA $379.3 $530.1 $704.6 $605.1 $617.0 $807.4 $944.1 $873.6 $955.8 $1,032.5 $1,211.8 $1,275.3 $1,131.5 $1,518 $2,179 $2,344 60.57% <-Total Growth 10 Adjusted EBITDA
Change 27.72% 39.74% 32.94% -14.12% 1.96% 30.85% 16.94% -7.47% 9.42% 8.02% 17.37% 5.24% -11.28% 34.16% 43.54% 7.57% 6.63% <-Median-> 10 Change
Margin 11.57% 14.63% 27.95% 24.12% 18.08% 18.08% 26.10% 29.00% 19.17% 14.62% 17.18% 17.86% 16.51% 16.60% 19.39% 19.48% 18.08% <-Median-> 10 Margin
$718 <-12 mths -5.14%
EBIT $583.2 $698.2 $774.2 $889.3 $922.9 $756.5 $1,037.0 $1,507.0 $1,683.0 <-Total Growth 5 EBIT from Mkt Sc
Change 19.72% 10.89% 14.87% 3.78% -18.03% 37.08% 45.32% 11.68% 10.89% <-Median-> 5 Change
Margin 19.36% 14.01% 10.97% 12.61% 12.93% 11.04% 11.34% 13.41% 13.99% 12.77% <-Median-> 6 Margin
Long Term Debt $1,152.1 $1,156.5 $1,437.4 $1,795.5 $2,117.3 $2,548.5 $3,220.7 $3,456.4 $3,622.7 $3,897.0 $3,385.6 $5,921.4 $6,957.5 Debt Type
Change 0.38% 24.29% 24.91% 17.92% 20.37% 26.38% 7.32% 4.81% 7.57% -13.12% 74.90% 17.50% 19.14% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.17 0.17 0.19 0.25 0.39 0.34 0.64 0.55 0.53 0.53 0.34 0.59 0.54 0.46 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 6.35 7.12 7.62 9.30 9.77 9.20 9.20 15.15 8.91 8.57 11.04 7.34 4.33 8.47 9.20 <-Median-> 10 Assets/Current Liab Ratio Liquidity
Debt to Cash Flow (Years) 4.07 3.03 3.35 3.71 4.01 4.15 5.18 5.27 4.91 4.80 3.81 6.54 7.14 4.48 <-Median-> 10 Debt to Cash Flow (Years) Liq. + CF
Debt Ratio
Intangibles $1.79 $1.06 $0.58 $0.00 $0.00 $92.41 $80.15 $71.32 $63.29 $59.69 $50.44 $46.52 $36.20 $33.30 6097.95% <-Total Growth 10 Intangibles Leverage
Goodwill $53.62 $53.62 $53.62 $53.62 $53.62 $53.62 $55.76 $55.76 $40.81 $32.02 $32.02 $32.02 $32.02 $1,478.47 -40.30% <-Total Growth 10 Goodwill D/E Ratio
Total $55.41 $54.68 $54.21 $53.62 $53.62 $146.04 $135.91 $127.08 $104.11 $91.71 $82.46 $78.54 $68.21 $1,511.77 25.83% <-Total Growth 10 Total
Change -2.59% -1.31% -0.87% -1.08% 0.00% 172.34% -6.93% -6.50% -18.08% -11.91% -10.08% -4.76% -13.15% 2116.31% -6.72% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.01 0.01 0.01 0.01 0.01 0.03 0.02 0.03 0.02 0.01 0.01 0.01 0.01 0.12 0.01 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $787.12 $621.71 $490.16 $579.05 $938.00 $738.70 $656.28 $646.85 $1,099.13 $1,108.13 $1,068.01 $1,132.17 $5,304.60 $2,642.42 982.21% <-Total Growth 10 Current Assets
Current Liabilities $480.31 $540.98 $563.79 $532.73 $601.49 $737.45 $816.96 $499.03 $912.96 $1,000.00 $795.22 $1,193.10 $3,016.28 $2,169.37 435.00% <-Total Growth 10 Current Liabilities
Liquidity Ratio 1.64 1.15 0.87 1.09 1.56 1.00 0.80 1.30 1.20 1.11 1.34 0.95 1.76 1.22 1.16 <-Median-> 10 Ratio
Liq. with CF aft div 2.07 1.61 1.59 1.33 1.85 1.33 1.40 1.82 1.38 1.59 2.00 1.62 1.85 1.42 1.62 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  1.24 0.58 0.68 0.55 0.89 0.49 0.59 0.73 0.96 0.86 0.99 1.35 1.61 1.42 0.99 <-Median-> 5 Ratio
Curr. Port. Lg T. Db $0.00 $47.40 $104.20 $60.00 $0.00 $126.09 $135.54 $0.00 $60.00 $30.00 $186.02 $321.66 $230.00 $200.00 120.73% <-Total Growth 10 Curr. Port. Lg T. Db
Liquidity 1.64 1.26 1.07 1.22 1.56 1.21 0.96 1.30 1.29 1.14 1.75 1.30 1.90 1.34 1.30 <-Median-> 5 Ratio
Liq. with CF aft div 2.07 1.76 1.95 1.50 1.85 1.60 1.68 1.82 1.48 1.64 2.62 2.22 2.01 1.56 2.01 <-Median-> 5 Ratio
Assets $3,051.1 $3,850.8 $4,296.6 $4,957.0 $5,874.1 $6,782.7 $7,514.2 $7,562.6 $8,130.3 $8,568.2 $8,780.0 $8,755.9 $13,052.9 $18,369.8 203.80% <-Total Growth 10 Assets
Liabilities $2,127.4 $2,532.6 $2,898.3 $3,115.5 $3,394.8 $4,053.0 $4,460.3 $4,801.4 $5,472.7 $5,749.5 $6,000.5 $5,924.5 $10,288.3 $13,088.5 254.98% <-Total Growth 10 Liabilities
Debt Ratio 1.43 1.52 1.48 1.59 1.73 1.67 1.68 1.58 1.49 1.49 1.46 1.48 1.27 1.40 1.53 <-Median-> 10 Ratio
Estimates BVPS $19.67 $18.47 $19.13 Estimates Estimates BVPS none give in 2025
Estimate Book Value $4,510.0 $4,234.9 $4,386.2 Estimates Estimate Book Value
P/B Ratio (Close) 2.84 3.02 3.34 Estimates P/B Ratio (Close)
Difference from 10 year median 10.64% Diff M/C Estimates Difference from 10 yr med.
Total Book Value $923.7 $1,318.2 $1,398.3 $1,841.5 $2,479.3 $2,729.7 $3,053.9 $2,761.2 $2,657.6 $2,818.7 $2,779.5 $2,831.4 $2,764.6 $5,281.3 97.72% <-Total Growth 10 Book Value
Non-Cont Int. $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Non-Cont Int.
Book Value $923.7 $1,318.2 $1,398.3 $1,841.5 $2,479.3 $2,729.7 $3,053.9 $2,761.2 $2,657.6 $2,818.7 $2,779.5 $2,831.4 $2,764.6 $5,281.3 $5,281.3 $5,281.3 97.72% <-Total Growth 10 Book Value
Book Value per Share $5.83 $7.81 $8.14 $9.92 $12.12 $12.97 $14.01 $12.49 $12.02 $12.30 $12.13 $12.36 $12.06 $23.03 $23.03 $23.03 48.06% <-Total Growth 10 Book Value per Share
Change 1.70% 33.99% 4.21% 21.78% 22.22% 7.00% 8.06% -10.85% -3.75% 2.30% -1.39% 1.87% -2.41% 91.03% 0.00% 0.00% -4.91% P/B Ratio Current/Historical Median
P/B Ratio (Median) 4.85 5.23 5.00 3.86 3.21 2.45 2.21 1.87 2.46 2.55 2.58 3.19 3.56 2.22 0.00 0.00 2.55 P/B Ratio Historical Median
P/B Ratio (Close) 5.48 5.19 4.94 4.08 2.92 1.99 2.43 1.81 2.37 2.41 2.64 3.56 3.65 2.42 2.42 2.77 4.00% <-IRR #YR-> 10 Book Value per Share 48.06%
Change 27.69% -5.37% -4.68% -17.48% -28.37% -31.90% 21.98% -25.41% 31.04% 1.39% 9.77% 34.73% 2.57% -33.64% 0.00% 14.38% -0.71% <-IRR #YR-> 5 Book Value per Share -3.48%
Leverage (A/BK) 3.30 2.92 3.07 2.69 2.37 2.48 2.46 2.74 3.06 3.04 3.16 3.09 4.72 3.48 #DIV/0! #DIV/0! 2.89 <-Median-> 10 A/BV
Debt/Equity Ratio 2.30 1.92 2.07 1.69 1.37 1.48 1.46 1.74 2.06 2.04 2.16 2.09 3.72 2.48 #DIV/0! #DIV/0! 1.89 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/B Ratios 10 yr Med 2.56 5 yr Med 2.58 -5.52% Diff M/C 2.69 Historical Leverage (A/BK)
-$8.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.06
-$12.49 $0.00 $0.00 $0.00 $0.00 $12.06
$370.96 <-12 mths -10.32%
Comprehensive Income $146.84 $229.99 $201.92 $216.85 $289.92 $407.00 $422.80 $53.94 $320.79 $364.11 $410.08 $519.40 $413.66 104.86% <-Total Growth 10 Comprehensive Income
Increase 12.43% 56.63% -12.20% 7.39% 33.70% 40.38% 3.88% -87.24% 494.74% 13.51% 12.62% 26.66% -20.36% 13.51% <-Median-> 5 Comprehensive Income
5 Yr Running Average $138 $154 $169 $185 $217 $269 $308 $278 $299 $314 $314 $334 $406 7.44% <-IRR #YR-> 10 Comprehensive Income 104.86%
ROE 15.90% 17.45% 14.44% 11.78% 11.69% 14.91% 13.84% 1.95% 12.07% 12.92% 14.75% 18.34% 14.96% 50.30% <-IRR #YR-> 5 Comprehensive Income 666.91%
5Yr Median 15.93% 15.93% 15.90% 14.66% 14.44% 14.44% 13.84% 11.78% 12.07% 12.92% 12.92% 12.92% 14.75% 9.16% <-IRR #YR-> 10 5 Yr Running Average 140.13%
% Difference from NI 0.00% 0.00% 0.00% 0.00% 0.00% 3.24% -4.69% -13.05% -1.05% 10.91% -3.29% 6.73% -4.32% 7.84% <-IRR #YR-> 5 5 Yr Running Average 45.85%
Median Values Diff 5, 10 yr -0.53% -1.05% 14.8% <-Median-> 5 Return on Equity
-$201.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $413.7
-$53.9 $0.0 $0.0 $0.0 $0.0 $413.7
-$168.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $405.6
-$278.1 $0.0 $0.0 $0.0 $0.0 $405.6
Current Liability Coverage Ratio 0.75 1.00 1.03 1.02 0.94 0.96 0.92 1.62 0.84 0.82 1.29 0.81 0.28 0.43   CFO / Current Liabilities
5 year Median 0.65 0.70 0.75 1.00 1.00 1.00 0.96 0.96 0.94 0.92 0.92 0.84 0.82 0.81 0.82 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 11.74% 14.03% 13.56% 10.94% 9.66% 10.48% 10.04% 10.72% 9.42% 9.56% 11.70% 10.99% 6.54% 5.08% CFO / Total Assets
5 year Median 11.74% 11.74% 11.74% 11.74% 11.74% 10.94% 10.48% 10.48% 10.04% 10.04% 10.04% 10.72% 9.56% 9.56% 9.6% <-Median-> 5 Return on Assets 
Return on Assets ROA 4.81% 5.97% 4.70% 4.37% 4.94% 5.81% 5.90% 0.82% 3.99% 3.83% 4.83% 5.56% 3.31% 3.27% Net  Income/Assets Return on Assets
5Yr Median 6.05% 5.97% 4.88% 4.81% 4.81% 4.94% 4.94% 4.94% 4.94% 3.99% 3.99% 3.99% 3.99% 3.83% 4.0% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 15.90% 17.45% 14.44% 11.78% 11.69% 14.44% 14.53% 2.25% 12.20% 11.65% 15.26% 17.19% 15.64% 11.36% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 15.93% 15.93% 15.90% 14.66% 14.44% 14.44% 14.44% 11.78% 12.20% 12.20% 12.20% 12.20% 15.26% 15.26% 15.3% <-Median-> 5 Return on Equity
$382.15 <-12 mths -11.61%
Net Income $146.84 $229.99 $201.92 $216.85 $289.92 $394.22 $443.61 $62.03 $324.21 $328.29 $424.03 $486.63 $432.34 $600.0 $855.3 $957.3 114.11% <-Total Growth 10 Net Income
Increase 12.43% 56.63% -12.20% 7.39% 33.70% 35.98% 12.53% -86.02% 422.66% 1.26% 29.16% 14.76% -11.16% 38.78% 42.55% 11.93% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $137.6 $153.5 $168.9 $185.2 $217.1 $266.6 $309.3 $281.3 $302.8 $310.5 $316.4 $325.0 $399.1 $454.3 $559.7 $666.3 7.91% <-IRR #YR-> 10 Net Income 114.11%
Operating Cash Flow $385.09 $460.59 $648.16 $412.93 $513.70 $604.33 $887.94 $688.17 $583.84 $925.33 $975.49 $1,265.79 $774.54 47.45% <-IRR #YR-> 5 Net Income 596.98%
Investment Cash Flow -$321.19 -$966.84 -$757.42 -$760.97 -$646.94 -$1,258.97 -$1,125.33 -$748.31 -$397.12 -$843.92 -$819.71 -$235.31 -$465.43 8.98% <-IRR #YR-> 10 5 Yr Running Average 136.28%
Total Accruals $82.93 $736.23 $311.18 $564.90 $423.16 $1,048.86 $681.00 $122.16 $137.49 $246.89 $268.26 -$543.85 $123.22 7.24% <-IRR #YR-> 5 5 Yr Running Average 41.86%
Total Assets $3,051.07 $3,850.83 $4,296.57 $4,956.96 $5,874.13 $6,782.70 $7,514.19 $7,562.59 $8,130.31 $8,568.19 $8,780.01 $8,755.86 $13,052.95 Balance Sheet Assets
Accruals Ratio 2.72% 19.12% 7.24% 11.40% 7.20% 15.46% 9.06% 1.62% 1.69% 2.88% 3.06% -6.21% 0.94% 1.69% <-Median-> 5 Ratio
EPS/CF Ratio 0.41 0.44 0.35 0.41 0.55 0.56 0.60 0.08 0.42 0.41 0.41 0.50 0.51 0.46 <-Median-> 10 EPS/CF Ratio
-$201.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $432.3
-$62.0 $0.0 $0.0 $0.0 $0.0 $432.3
-$168.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $399.1
-$281.3 $0.0 $0.0 $0.0 $0.0 $399.1
Change in Close 29.86% 26.79% -0.67% 0.50% -12.46% -27.13% 31.81% -33.51% 26.13% 3.72% 8.25% 37.25% 0.09% 26.77% 0.00% 14.38% Count 23 Years of data
up/down down down  down down down down down up Count 14 60.87%
Meet Prediction? Yes Yes Yes Yes Yes % right Count 6 42.86%
Financial Cash Flow $121.42 $326.55 $109.69 $350.52 $445.85 $314.91 $259.01 $53.80 -$173.85 -$100.65 -$134.26 -$935.65 $1,911.11 C F Statement  Financial Cash Flow
Total Accruals -$38.49 $409.68 $201.49 $214.38 -$22.69 $733.95 $421.99 $68.36 $311.35 $347.54 $402.52 $391.81 -$1,787.89 Accruals
Accruals Ratio -1.26% 10.64% 4.69% 4.32% -0.39% 10.82% 5.62% 0.90% 3.83% 4.06% 4.58% 4.47% -13.70% 4.06% <-Median-> 5 Ratio
Cash $186.65 $11.31 $13.45 $16.48 $326.38 -$10.86 $9.31 $2.90 $15.94 -$1.80 $20.09 $118.44 $2,331.52 $568.79 Cash
Cash per Share $1.18 $0.07 $0.08 $0.09 $1.60 -$0.05 $0.04 $0.01 $0.07 -$0.01 $0.09 $0.52 $10.17 $2.48 $0.09 <-Median-> 5 Cash per Share
Percentage of Stock Price 3.69% 0.17% 0.19% 0.22% 4.50% -0.20% 0.13% 0.06% 0.25% -0.03% 0.27% 1.18% 23.11% 4.45% 0.27% <-Median-> 5 % of Stock Price
Notes
October 17, 2026.  Last estimates were for 2025, 2026, 2027 of $6279M, $8373M, $8768M Revenue, $4.11, $4.12 2025/6 AFFO, $3.84, $6.23, $6.42 FFO, $2.26, $2.85, $2.91 EPS, 
$2.12, $2.21, $2.30 Dividends, $504.2M, -888.1M, $1032M FCF, $3.77, $5.00, $5.34 CFPS, $1168M, $1864M, $2005M EBITDA, $841M, $1278M, $1410M EBIT, $498M, $697M, $781M Net Income.
October 23, 2025.  Last estimates were for 2024, 2025, 2026 of $6900M, $6960M, $7419M Revenue, $3.53, $3.58 2024/5 AFFO, $4.18, $4.17 2024/5 FFO, $2.20, $2.14, $2.24 EPS, 
$2.05, $2.14, $2.24, $694.8M, $756.7M, $763.8M FCF, $3.65, $3.87, $4.15 CFPS, $1255, $1234, $1274 EBITDA, $12.30, $12.10 2024/5 BVPS, $340.4M, $536M, $552M Net Income
October 19, 2024.  Last estimates were for 2023, 2024 and 2025 of $6752M, $6275M, $6229M for Revenue, $3.59, $3.44, $3.58 AFFO, $2.07, $1.91, $2.15 EPS, 
1.96, $2.04, $2.13 Dividend, $665M, $678M, $750M FCF, $4.16, $3.72, $3.68 CFPS, $1114M, $1109M, $1172M EBITDA, $13.30, $12.30, $12.10 BVPS, $481M, $436M, $494M Net Income.
October 22, 2023.  Last estimates were for 2022, 2023 and 2024 of $6635M, $5363M and $5874M for Revenue. $2.91, $3.08 and $3.35 for FFO, $2.26, $2.06 and $2.02 for EPS, 
$1.92, $2.00 and $2.03 for Dividends, -$25M, $628M and $614M for FCF, $3.73, $3.46 and $3.43 for CPFS, $13.30, $13.30 and $14.30 for BVPS, and $500M, $450M and $461M for Net Income.
October 23, 2022.  Last estimates were for 2021, 2022 and 2023 of $4468M, $4451M and $4931M for Revenue, $3.05, $2.91 and $3.17 for DC, $1.72, $1.76 and $1.85 for EPS, 
$1.92, $1.95 and $1.99 for Dividends, $405M, $429M and $460M for FCF, $3.86, $3.98 and $4.35 for CFPS, and $380M, $390M and $410M for Net Income.
October 24, 2021.  Last estimates were for 2020, 2021 and 2022 of 3343M, $3653M and $4106M for Revenue, $3.35, $2.91 and 2.74 for AFFO, $1.06, $1.57 and 1.68 for EPS, 
$1.92, $1394 and $1.99 for Dividends, $240M, $352M and $388M for FCF, $3.79, $3.13 and $3.50 for CFPS, $246M, $338M and $375M for Net Income.
November 1, 2020.  Last estimates were for 2019, 2020 and 2021 of $3867M, $5426M and $6295M for Revenue, $3.08 and 3.12 for Distributable Cash for 2019 and 2020, 
$2.54, $1.80 and $1.81 for EPS, $3.45, $3.66 and $3.42 for CFPS and $513M, $596M and $439M for Net Income.
November 3, 2019.  Last estimates were for 2018, 2019 and 2020 of $4421M, $4637M and $4629M for Revenue, $2.99 and $3.00 for DC for 2018 and 2019, 
$1.81, $1.93 and $1.86 for EPS, $3.04, $3.39 and $3.39 for CFPS, and $372M, $413M and $410M for Net Income.
November 5, 2018.  Last estimates were for 2017, 2018 and 2019 of $3180M, $3334M and $3408M for Revenue, $2.58, $2.30 and $2.87 for Dis Cash, 
$1.46, $1.79 and $1.91 for EPS, $2.81, $3.32 and $3.53 for CFPS and $292M, $338M and $393M for Net Income.
November 12, 2017.  Last estimates were for 2016, 2017 and 2018 of $2461M, $3070M and $3259M for Revenue, $2.55, $3.22 and $3.43 for DC, $1.47, $1.71and $1.89 for EPS, 
$2.90, $3.36 and $3.53 for CFPS and $265M, $321M and $364M for Net Income.
November 13, 2016.  Last estimates were for 2015, 2016 and 2017 of $2988M, $3957M and $4196M for Revenue, $2.80, $2.86 and $3.08 for DC, $1.50, $1.87 and $1.78 for EPS, 
$3.36, $3.65 and $3.54 for CFPS and $243M, $338M and $324M for Net Income.
Movember 21, 2015.  Last estimates were for 2014, 2015 and 2016 of $3790M,$3986M and $3975M for Revenue, $3.12, $3.62 and $396 for EPS, $5.74, $6.17 and $6.87 for CFPS and $235M $307M and $337M for net income.
November 23, 2014.  Last estimates were for 2013, 2014 and 2015 of $3216M, $3476M and $3387M for Revenue, $3.50 for DC for 2014, $2.04, $2.32 and $2.56 for EPS, $4.30, $4.54 and $5.21 for CFPS.
November 9, 2013.  Last Estimates were for 2012 and 2013 of $2918M asnd $3224M for Revenue, DI of $2.78 and 3.50 and EPS of $1.79 and $2.01.
October 5, 2012.  Most of the new shares issued in the first half of 2012 is an equity offering (for an acquisition), there were some re DRIP and debentures conversion.
Sep 30, 2012.  Estimates for 2011 and 2012 were $2,222M and $2,287M for revenue, $3.13, $3.08 for DI, $2.50 and $2.16 for EPS, $3.30 and $3.42 for CF.
When analysts are quoting earnings, they are sometimes giving EPS and sometimes Distributable Cash or things like AFFO).
Company says that it expects to retain the current dividend payout,as they feel it is sustainable.  However dividends are not guaranteed and can fluctuate.
TD site says there was a 1.01:1 split in 2009, but I cannot find this.
The stock started out as KeySpan Facilities Income Fund (TSX-KEY.UN).  Names change in 2004 to Keyera Facilities Income Fund (TSX-JKEY.UN) and in 2010 to Keyera Corp (TSX-KEY)
KeyeraCorp. owns, directly indirectly, 100% of Keyera Partnership.
The company would founded in 1998.  It began trading on the TSX May 30, 2003 as an Income Trust.
Formerly KeySpan Facilities Income Fund
Keyera Energy Partnership was formerly KeySpan Energy Canada Partnership.
Sector
Infrastructure, Utilitiy
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock. 
I started to review some of the stock recommended by Jennifer Dowty from a column she wrote and I reviewed in February 2010 on Dividends and Special Dividends.  The title of the article in Investor’s 
Digest was Dividend Stocks: Buy, Hold and Collect. Jennifer is now works for the Globe and Mail.
Jennifer worked as a Portfolio Manager for Manulife Asset Management Limited after working for Investor's digest.
Dividends
Dividends are paid quarterly from 2023 in Cycle 3 of Mar, Jun, Sep, and December.  
Generally, dividends are declared in one month for shareholders of record of the next month and paid in the that month.
Dividends are paid in Mar, Jun, Sep and Dec.
For example, Dividend declared on 09 August 2023, was for Shareholders of record for September 15, 2023 and paid September 29, 2023
Dividends are paid monthly.  The dividends are declared for the record date of prior month.  
For example, in May 2013, dividends were declared on May 18, 2013 for shareholders of record of May 23, 2013 for payment June 15, 2013.
How they make their money.
Keyera Corp is a midstream energy business that operates out of Alberta. Its primary lines of business consist of the gathering and processing of natural gas
 in western Canada, the storage, transportation, and liquids blending for natural gas liquids and crude oil, and the marketing of natural gas liquids, iso-octane, and crude oil.
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.
From Proxy
Shares; '%, Value $M %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2018 Nov 3 2019 Nov 1 2020 Oct 24 2021 Oct 23 2022 Oct 22 2023 Oct 19 2024 Oct 23 2025 Oct 17 2026
Setoguchi, Curtis Dean 0.220 0.10% 0.233 0.11% 0.233 0.10% 0.233 0.10% 0.233 0.10% 0.233 0.10% 0.233 0.10% -0.06%
CEO - Shares - Amount $4.969 $6.646 $6.893 $7.461 $10.240 $10.249 $12.993
Options - percentage 0.211 0.10% 0.277 0.13% 0.348 0.15% 0.356 0.16% 0.357 0.16% 0.352 0.15% 0.000 0.00% -1.58%
Options - amount $4.776 $7.900 $10.288 $11.397 $15.702 $15.476 $0.000
Smith, David G. 0.28% 0.604 0.28% 0.647 0.29% was officer until 2014
CEO - Shares - Amount $15.245 $20.557 $14.624 Listed Officer 16-18 INK
Options - percentage 0.14% 0.336 0.15% 0.423 0.19% Last updated Aug 2019
Options - amount $7.803 $11.419 $9.566 Ceased Insider Dec 2020
Marikar, Eileen 0.008 0.00% 0.012 0.01% 0.014 0.01% 0.017 0.01% 0.032 0.01% 0.031 0.01% 0.042 0.02% 0.000 0.00% 36.47%
CFO - Shares - Amount $0.282 $0.277 $0.407 $0.493 $1.040 $1.344 $1.836 $0.000
Options - percentage 0.026 0.01% 0.058 0.03% 0.000 0.00% 0.100 0.04% 0.090 0.04% 0.095 0.04% 0.097 0.04% 0.000 0.00% 2.31%
Options - amount $0.894 $1.320 0 $0.000 $2.950 $2.884 $4.181 $4.284 $0.000
Beztilny, Jarrod 0.061 0.03% 0.079 0.03% 0.079 0.03% 0.106 0.05% 33.99%
Officer - Shares - Amount $1.817 $2.543 $3.490 $4.683
Options - percentage 0.065 0.03% 0.061 0.03% 0.066 0.03% 0.066 0.03% 0.57%
Options - amount $1.913 $1.959 $2.897 $2.917
Brennan, Nancy Louise 0.011 0.00% 0.011 0.00%
Officer - Shares - Amount $0.345 $0.474
Options - percentage 0.074 0.03% 0.074 0.03%
Options - amount $2.371 $3.254
Chan, Bryan Dwayne 0.002 0.00% 0.002 0.00% -0.06%
Officer - Shares - Amount $0.088 $0.088
Options - percentage 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000
Elliott, Christy 0.000 0.00% 0.014 0.01% 0.000 0.00% #DIV/0!
Officer - Shares - Amount $0.000 $0.632 $0.000
Options - percentage 0.066 0.03% 0.071 0.03% 0.000 0.00% 8.24%
Options - amount $2.896 $3.140 $0.000
Urquhart, Kenneth James 0.015 0.01% 0.035 0.02% 0.035 0.02% 0.039 0.02% 0.000 0.00% 12.86%
Officer - Shares - Amount $0.456 $1.116 $1.531 $1.730 $0.000
Options - percentage 0.092 0.04% 0.079 0.03% 0.084 0.04% 0.085 0.04% 0.000 0.00% 0.67%
Options - amount $2.710 $2.540 $3.713 $3.744 $0.000
Crothers, Michael John 0.002 0.00% 0.002 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% -0.06%
Director - Shares - Amount $0.059 $0.064 $0.110 $0.110 $0.167
Options - percentage 0.002 0.00% 0.006 0.00% 0.014 0.01% 0.022 0.01% 0.024 0.01% 53.36%
Options - amount $0.064 $0.203 $0.628 $0.965 $1.311
Haughey, Douglas J. 0.01% 0.011 0.01% 0.011 0.01% 0.011 0.01% 0.011 0.00% 0.011 0.00% 0.011 0.00% Was lead director, now -100.00%
Director - Shares - Amount $0.288 $0.379 $0.252 $0.318 $0.330 $0.357 $0.490 Director 2019
Options - percentage 0.00% 0.011 0.00% 0.015 0.01% 0.022 0.01% 0.032 0.01% 0.043 0.02% 0.060 0.03% -100.00%
Options - amount $0.164 $0.364 $0.335 $0.622 $0.944 $1.375 $2.652
O'Connor, Thomas C 0.009 0.00% 0.009 0.00% -0.06%
Director - Shares - Amount $0.374 $0.374
Options - percentage 0.058 0.03% 0.069 0.03% 17.68%
Options - amount $2.562 $3.020
Brassard, Isabelle 0.000 0.00% #DIV/0!
Director - Shares - Amount $0.000
Options - percentage 0.024 0.01% #DIV/0!
Options - amount $1.313
Goertzen, Blair 0.023 0.01%
Director - Shares - Amount $1.273 #DIV/0!
Options - percentage 0.050 0.02%
Options - amount $2.809 #DIV/0!
Bertram, James Vance 0.44% 0.819 0.38% 0.719 0.33% 0.644 0.29% 0.644 0.28% 0.600 0.26% 0.600 0.26% 0.550 0.24% 0.550 0.24% was CEO to 2014 -8.39%
Chairman - Shares - Amt $23.730 $27.876 $16.273 $18.385 $19.068 $19.218 $26.376 $24.200 $30.679 listed CEO 16-18
Options - percentage 0.09% 0.188 0.09% 0.188 0.09% 0.188 0.09% 0.188 0.08% 0.188 0.08% 0.188 0.08% 0.191 0.08% 0.004 0.00% Last updated Sep 2021 1.49%
Options - amount $4.852 $6.395 $4.252 $5.363 $5.562 $6.021 $8.263 $8.399 $0.218
Salary (salary, share rewards and bonus)
Stock sales
In September 23  2013
 LTIP Awards $13.907 $14.262
0.19% 0.26%
Increase in O/S Shares 0.17% 0.460 0.22% 0.643 0.30% 0.981 0.44% 0.000 0.00% 0.062 0.03% 0.068 0.03% 0.060 0.03% 0.064 0.03% Yes 0
due to SO $12.013 $11.866 $21.881 $22.183 $0.000 $1.824 $2.177 $2.633 $2.798 See Share-based
Book Value $13.907 $14.262 $26.134 -$1.122 $62.450 $33.284 $50.909 $62.450 $43.796 compensation
Insider Buying $0.000 -$0.079 -$0.881 -$0.001 -$0.045 $0.000 -$0.017 -$0.049 $0.000
Insider Selling $0.138 $3.456 $2.406 $3.268 $0.000 $1.463 $0.075 $2.512 $0.000
Net Insider Selling $0.138 $3.377 $1.525 $3.267 -$0.045 $1.463 $0.058 $2.463 $0.000
% of Market Cap 0.00% 0.05% 0.03% 0.05% 0.00% 0.02% 0.00% 0.02% 0.00%
Directors 10 10 10 11 11 11 11 10
Women 30% 3 30% 3 30% 3 30% 4 36% 4 36% 4 36% 4 36% 4 40%
Minorities 0% 0 0% 0 0% 1 10% 1 9% 1 9% 1 9% 1 9% 1 10%
Institutions/Holdings 52.05% 20 20 34.89% 20 32.89% 20 30.14% 20 28.08% 20 28.19% 20 28.35%
Total Shares Held 54.17% 60.207 28.60% 77.113 34.89% 72.698 31.72% 69.058 30.14% 64.336 28.08% 64.596 28.17% 83.189 36.28%
Increase/Decrease 2.06% -2.353 -3.76% -9.189 -10.65% -1.351 -1.82% -1.340 -1.90% 0.691 1.09% -1.211 -1.84% -1.430 -1.69%
Starting No. of Shares 62.560 Top 20 86.302 Top 20 74.049 Top 20 70.397 Top 20 63.645 Top 20 65.807 Top 20 84.619 Top 20
Copyright © 2008 Website of SPBrunner. All rights reserved.