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.
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/ Q3 2017
Keyera Corp TSX: KEY OTC: KEYUF http://www.keyera.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 Total G
Accounting Rules C GAAP C GAAP C GAAP C GAAP C GAAP C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
$2,436.0 <-12 mths -3.37%
Revenue* $1,187.57 $1,368.52 $1,479.14 $2,175.27 $1,545.05 $1,942.47 $2,569.20 $2,942.28 $3,277.2 $3,623.7 $2,521.1 $2,509.0 $3,180 $3,334 $3,408 83.33% <-Total Growth 10 Revenue
Increase 59.43% 15.24% 8.08% 47.06% -28.97% 25.72% 32.26% 14.52% 11.38% 10.57% -30.43% -0.48% 26.75% 4.84% 2.22% 6.25% <-IRR #YR-> 10 Revenue 83.33%
5 year Running Average $1,391.1 $1,551.1 $1,702.1 $1,942.2 $2,234.9 $2,455.2 $2,871.0 $2,986.7 $2,974.6 $3,022 $3,034 $2,990 -0.47% <-IRR #YR-> 5 Revenue -2.34%
Revenue per Share $9.88 $11.23 $12.07 $17.29 $11.74 $13.90 $17.94 $18.94 $20.69 $21.48 $14.68 $13.51 $17.13 $17.96 $18.35 9.97% <-IRR #YR-> 8 5 yr Running Average #DIV/0!
Increase 44.28% 13.71% 7.49% 43.27% -32.13% 18.39% 29.11% 5.58% 9.24% 3.82% -31.65% -7.97% 26.75% 4.84% 2.22% 8.90% <-IRR #YR-> 5 5 yr Running Average 53.16%
5 year Running Average $11.46 $12.44 $13.25 $14.59 $15.96 $16.64 $18.59 $18.75 $17.86 $17.50 $16.95 $16.33 1.87% <-IRR #YR-> 10 Revenue per Share 20.32%
P/S (Price/Sales) Med 0.96 0.90 0.73 0.56 0.82 1.08 1.17 1.17 1.37 1.90 2.77 2.83 2.27 0.00 0.00 -5.51% <-IRR #YR-> 5 Revenue per Share -24.69%
P/S (Price/Sales) Close 1.10 0.74 0.82 0.51 1.04 1.26 1.39 1.30 1.54 1.89 2.74 2.99 2.13 2.04 1.99 5.70% <-IRR #YR-> 8 5 yr Running Average #DIV/0!
*Revenue in M CDN $  P/S Med 10 yr  1.17 5 yr  1.90 81.89% Diff M/C 4.13% <-IRR #YR-> 5 5 yr Running Average 22.44%
-$1,368.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,509.0
-$2,569.2 $0.0 $0.0 $0.0 $0.0 $2,509.0
-$1,391.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,974.6
-$1,942.2 $0.0 $0.0 $0.0 $0.0 $2,974.6
-$11.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.51
-$17.94 $0.00 $0.00 $0.00 $0.00 $13.51
-$11.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.86
-$14.59 $0.00 $0.00 $0.00 $0.00 $17.86
$2.36 <-12 mths -7.81%
Distributable Cash $0.84 $0.83 $1.18 $1.10 $2.04 $1.53 $1.43 $1.31 $1.84 $2.37 $2.84 $2.56 $2.58 $2.50 $2.87 210.30% <-Total Growth 10 Distributable Cash
Increase 11.33% -1.20% 42.42% -6.38% 85.45% -25.25% -6.56% -8.07% 40.46% 28.53% 20.08% -9.86% 0.78% -3.10% 14.80% 11.99% <-IRR #YR-> 10 Distributable Cash 210.30%
AFFO Yield 7.7% 9.9% 11.9% 12.5% 16.7% 8.7% 5.7% 5.3% 5.8% 5.8% 7.1% 6.3% 7.1% 6.8% 7.9% 12.43% <-IRR #YR-> 5 Distributable Cash 79.65%
5 year Running Average $0.80 $0.94 $1.20 $1.33 $1.45 $1.48 $1.63 $1.69 $1.96 $2.18 $2.44 $2.57 $2.67 11.85% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
Payout Ratio 77.83% 86.55% 62.55% 75.45% 44.12% 59.02% 66.67% 78.24% 60.87% 52.96% 49.21% 59.77% 63.66% 67.20% 58.54% 8.48% <-IRR #YR-> 5 5 yr Running Average 50.24%
Payout Ratio 5 year Running 73.18% 74.15% 67.85% 64.58% 62.49% 65.27% 62.90% 61.99% 58.74% 57.95% 56.98% 58.41% 59.40% 63.74% <-Median-> 10 Payout 5 yr Running Average
Price/DC Median 11.34 12.25 7.54 8.77 4.75 9.80 14.79 16.95 15.38 17.29 14.32 14.94 15.09 13.28 <-Median-> 10 Price/DC Median
Price/DC High 13.95 14.64 8.39 10.69 6.00 11.81 17.54 19.55 17.37 21.07 15.98 16.71 16.35 15.31 <-Median-> 10 Price/DC High
Price/DC Low 8.74 9.85 6.70 6.85 3.49 7.80 12.03 14.35 13.40 13.51 12.67 13.17 13.82 10.94 <-Median-> 10 Price/DC Low
Price/DC Close 13.02 10.08 8.39 8.02 6.00 11.52 17.54 18.79 17.37 17.14 14.18 15.80 14.17 14.62 12.74 12.85 <-Median-> 10 Price/DC Close
Trailing P/DC Close 8.62 13.18 7.08 8.96 4.32 8.02 12.33 19.08 13.38 13.52 14.27 15.73 15.68 14.62 12.74 12.86 <-Median-> 10 Trailing P/DC Close
Median Values DPR 10 Yrs 60.32% 5 Yrs   59.77% P/CF 5 Yrs   in order 15.38 17.37 13.40 17.14 -7.92% Diff M/C 6.64% Diff M/C 10 DPR 75% to 95% best
* Distributable Cash Flow per share (Cdn GAAP)
-$0.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.56
-$1.43 $0.00 $0.00 $0.00 $0.00 $2.56
-$0.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.18
-$1.45 $0.00 $0.00 $0.00 $0.00 $2.18
$1.27 <-12 mths 4.96%
Pre-split 2015 $1.03 $1.12 $0.24 $2.68 $2.36 $1.84 $1.91 $1.71 $1.87
EPS Basic $0.52 $0.56 $0.12 $1.34 $1.18 $0.92 $0.96 $0.86 $0.94 $1.40 $1.19 $1.21 116.07% <-Total Growth 10 EPS Basic
Actual EPS 2003
Pre-split 2015 $0.96 $1.10 $0.24 $2.62 $2.29 $1.81 $1.90 $1.71 $1.87
EPS Diluted* $0.48 $0.55 $0.12 $1.31 $1.15 $0.91 $0.95 $0.86 $0.94 $1.40 $1.19 $1.21 $1.46 $1.79 $1.91 120.00% <-Total Growth 10 EPS Diluted
Increase 74.55% 14.58% -78.18% 991.67% -12.60% -20.96% 4.97% -10.00% 9.36% 49.73% -15.00% 1.68% 20.66% 22.60% 6.70% 8.20% <-IRR #YR-> 10 Earnings per Share 120.00%
Earnings Yield 4.4% 6.6% 1.2% 14.9% 9.4% 5.1% 3.8% 3.5% 2.9% 3.5% 3.0% 3.0% 4.0% 4.9% 5.2% 4.96% <-IRR #YR-> 5 Earnings per Share 27.37%
5 year Running Average $0.36 $0.55 $0.72 $0.81 $0.89 $1.03 $0.96 $1.01 $1.07 $1.12 $1.24 $1.41 $1.51 13.38% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
10 year Running Average $0.70 $0.75 $0.87 $0.94 $1.00 $1.14 $1.18 $1.26 4.76% <-IRR #YR-> 5 5 yr Running Average 26.19%
* Diluted ESP per share  E/P 10 Yrs 3.46% 5Yrs 2.99%
-$0.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.21
-$0.95 $0.00 $0.00 $0.00 $0.00 $1.21
-$0.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.12
-$0.89 $0.00 $0.00 $0.00 $0.00 $1.12
Pre-split 2015 $0.00 $0.00 $0.00 $0.00 $0.45 $0.00 $0.00 $0.00 $0.00
Special Dividend $0.00 $0.00 $0.00 $0.00 $0.23 $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 $1.30 $1.43 $1.47 $1.66 $1.80 $1.80 $1.90 $2.05 $2.24 $2.51
Dividend* $0.65 $0.71 $0.74 $0.83 $0.90 $0.90 $0.95 $1.03 $1.12 $1.25 $1.40 $1.53 $1.64 $1.68 $1.68 114.29% <-Total Growth 10 Dividends
Increase 19.29% 9.86% 2.94% 12.93% 8.43% 0.00% 5.56% 7.89% 9.27% 11.83% 11.58% 9.48% 7.35% 2.28% 0.00% Count 14 Years of data
Dividends 5 Yr Running $0.58 $0.69 $0.81 $0.86 $0.91 $0.97 $1.02 $1.05 $1.15 $1.27 $1.39 $1.50 $1.59 82.08% <-Total Growth 9 Dividends 5 Yr Running
Yield H/L Price 6.86% 7.07% 8.29% 8.61% 9.30% 6.02% 4.51% 4.62% 3.96% 3.06% 3.44% 4.00% 4.22% 4.56% <-Median-> 10 Yield H/L Price
Yield on High  Price 5.58% 5.91% 7.46% 7.06% 7.35% 5.00% 3.80% 4.00% 3.50% 2.51% 3.08% 3.58% 3.89% 3.90% <-Median-> 10 Yield on High  Price
Yield on Low Price 8.90% 8.78% 9.34% 11.02% 12.66% 7.57% 5.54% 5.45% 4.54% 3.92% 3.89% 4.54% 4.61% 5.50% <-Median-> 10 Yield on Low Price
Yield on Close Price 5.98% 8.58% 7.46% 9.41% 7.36% 5.12% 3.80% 4.16% 3.50% 3.09% 3.47% 3.78% 4.49% 4.60% 4.60% 3.98% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 135.40% 129.82% 612.50% 63.36% 98.25% 99.45% 100.00% 119.88% 119.79% 89.46% 117.44% 126.45% 112.50% 93.85% 87.96% 108.72% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 161.56% 127.01% 112.45% 106.80% 102.48% 93.51% 106.89% 104.01% 107.79% 113.15% 112.07% 106.42% 104.89% 107.34% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 111.55% 78.63% 75.16% 114.34% 47.28% 81.83% 76.34% 66.90% 46.06% 45.87% 37.02% 68.80% 58.45% 50.60% 47.59% 67.85% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 95.59% 72.73% 70.66% 70.63% 69.18% 58.94% 58.06% 49.05% 49.83% 49.69% 50.49% 50.64% 69.18% <-Median-> 9 DPR CF 5 Yr Running
Payout Ratio CFPS WC 75.15% 83.76% 61.99% 73.92% 54.05% 53.27% 53.35% 59.48% 49.54% 39.12% 41.19% 52.40% 58.45% 50.60% 47.59% 53.31% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 75.88% 66.38% 62.09% 57.76% 57.52% 53.69% 49.24% 46.48% 46.86% 47.60% 47.96% 49.65% 57.52% <-Median-> 9 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 3.96% 3.50% 5 Yr Med Payout 119.79% 46.06% 49.54% 7.92% <-IRR #YR-> 10 Dividends 114.29%
* Dividends per share  5 Yr Med and Cur. 16.17% 31.18% Last Div Inc ---> $0.133 $0.140 5.7% 10.00% <-IRR #YR-> 5 Dividends 61.05%
-$0.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.53
-$0.95 $0.00 $0.00 $0.00 $0.00 $1.53
Historical Dividends Historical High Div 11.84% Low Div 2.80% Ave Div 7.32% Med Div 5.39% Close Div 4.74% Historical Dividends
High/Ave/Median Values Curr diff Exp. -61.18%     64.16% Exp. -37.21% Exp. -14.72% Exp. -3.02% 4.00% Since 2010 High/Ave/Median 
14.91% Cheap
Future Dividend Yield Div Yd 6.75% earning in 5 Years at IRR of 8.00% Div Inc. 46.93% Future Dividend Yield
Future Dividend Yield Div Yd 9.92% earning in 10 Years at IRR of 8.00% Div Inc. 115.89% Future Dividend Yield
Future Dividend Yield Div Yd 14.58% earning in 15 Years at IRR of 8.00% Div Inc. 217.22% Future Dividend Yield
Yield if held 5 years 14.48% 14.24% 9.50% 9.40% 11.57% 11.61% 12.94% 9.35% 7.26% 7.40% 5.93% 4.11% 11.57% <-Median-> 9 Paid Median Price
Yield if held 10 years 19.54% 19.82% 14.75% 15.14% 18.53% 17.42% 17.36% 17.34% <-Median-> 4 Paid Median Price
Yield if held 15 years 29.31% 26.58% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 60.60% 64.14% 45.44% 44.94% 54.50% 53.08% 54.21% 38.43% 30.02% 31.26% 26.50% 19.39% 53.08% <-Median-> 9 Paid Median Price
Cost covered if held 10 years 149.91% 147.17% 106.09% 107.55% 132.83% 130.87% 136.13% 127.36% <-Median-> 4 Paid Median Price
Cost covered if held 15 years 280.79% 272.65% #NUM! <-Median-> 0 Paid Median Price
Graham No. $7.51 $7.92 $3.48 $12.21 $11.69 $10.69 $9.99 $10.50 $11.08 $15.69 $14.77 $16.43 $18.57 $20.56 $21.24 107.40% <-Total Growth 10 Graham Number
Price/GP Ratio Med 1.26 1.28 2.54 0.79 0.83 1.40 2.11 2.11 2.56 2.61 2.75 2.33 2.10 2.22 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.55 1.52 2.83 0.96 1.05 1.68 2.50 2.44 2.89 3.18 3.07 2.60 2.27 2.55 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.97 1.03 2.26 0.62 0.61 1.11 1.72 1.79 2.23 2.04 2.44 2.05 1.92 1.91 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.45 1.05 2.83 0.72 1.05 1.64 2.50 2.34 2.89 2.58 2.73 2.46 1.97 1.78 1.72 2.48 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 44.80% 5.01% 182.96% -27.77% 4.64% 64.35% 150.32% 134.34% 188.57% 158.32% 172.65% 146.23% 96.85% 77.78% 72.10% 148.28% <-Median-> 10 Graham Price
Pre-split 2015 $21.75 $16.64 $19.71 $17.64 $24.47 $35.15 $50.00 $49.23 $63.93
Price Close $10.88 $8.32 $9.86 $8.82 $12.24 $17.58 $25.00 $24.62 $31.97 $40.53 $40.26 $40.46 $36.55 $36.55 $36.55 386.30% <-Total Growth 10 Stock Price
Increase 51.15% -23.49% 18.45% -10.50% 38.72% 43.65% 42.25% -1.54% 29.86% 26.79% -0.67% 0.50% -9.66% 0.00% 0.00% 17.14% <-IRR #YR-> 10 Stock Price 386.30%
P/E 22.66 15.13 82.13 6.73 10.69 19.42 26.32 28.79 34.19 28.95 33.83 33.44 25.03 20.42 19.14 10.11% <-IRR #YR-> 5 Stock Price 61.84%
Trailing P/E 39.55 17.33 17.92 73.50 9.34 15.35 27.62 25.91 37.39 43.35 28.76 34.00 30.21 25.03 20.42 23.90% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.  per yr 6.76% 4.13% % Tot Ret 28.30% 29.00% Price Inc 0.50% P/E:  28.87 33.44 14.24% <-IRR #YR-> 5 Price & Dividend
-$8.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.46
-$25.00 $0.00 $0.00 $0.00 $0.00 $40.46
-$8.32 $0.74 $0.83 $1.13 $0.90 $0.95 $1.03 $1.12 $1.25 $1.40 $41.99
-$25.00 $1.03 $1.12 $1.25 $1.40 $41.99
Price H/L Median $9.47 $10.10 $8.86 $9.65 $9.68 $14.95 $21.07 $22.21 $28.31 $40.89 $40.68 $38.24 $38.92 278.52% <-Total Growth 10 Stock Price
Increase 49.88% 6.65% -12.27% 8.83% 0.36% 54.44% 40.94% 5.40% 27.47% 44.45% -0.51% -6.00% 1.78% 14.24% <-IRR #YR-> 10 Stock Price 278.52%
P/E 19.73 18.37 73.85 7.36 8.45 16.52 22.18 25.97 30.28 29.21 34.18 31.60 26.66 12.66% <-IRR #YR-> 5 Stock Price 81.49%
Trailing P/E 34.45 21.05 16.11 80.38 7.39 13.06 23.28 23.38 33.11 43.73 29.06 32.13 32.17 20.29% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 17.29 11.74 13.90 17.94 18.94 20.69 21.48 14.68 13.51 17.13 17.35% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 18.33 21.67 14.84 12.77 18.24 22.58 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 6.06% 4.69% % Tot Ret 29.84% 27.03% Price Inc 5.40% P/E:  27.59 30.28 Count 14 Years of data
-$10.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38.24
-$21.07 $0.00 $0.00 $0.00 $0.00 $38.24
-$10.10 $0.74 $0.83 $1.13 $0.90 $0.95 $1.03 $1.12 $1.25 $1.40 $39.77
-$21.07 $1.03 $1.12 $1.25 $1.40 $39.77
High Months Dec Feb Dec Aug Dec Dec Dec Jan Dec Sep Apr Sep Apr
Pre-split 2015 $23.29 $24.15 $19.71 $23.51 $24.50 $36.01 $50.00 $51.23 $63.93 $99.33 $99.33 $99.33
Price High $11.65 $12.08 $9.86 $11.76 $12.25 $18.01 $25.00 $25.62 $31.97 $49.82 $45.39 $42.77 $42.19 254.20% <-Total Growth 10 Stock Price
Increase 60.29% 3.69% -18.39% 19.28% 4.21% 46.98% 38.85% 2.46% 24.79% 55.86% -8.89% -5.77% -1.36% 13.48% <-IRR #YR-> 10 Stock Price 254.20%
P/E 24.26 21.95 82.13 8.97 10.70 19.90 26.32 29.96 34.19 35.59 38.14 35.35 28.90 11.34% <-IRR #YR-> 5 Stock Price 71.08%
Trailing P/E 42.35 25.16 17.92 97.96 9.35 15.72 27.62 26.96 37.39 53.28 32.42 35.94 34.87 26.37 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 2.46% P/E:  32.07 35.35 35.59 P/E Ratio Historical High
-$12.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.77
-$25.00 $0.00 $0.00 $0.00 $0.00 $42.77
Low Months Apr Nov Jan Oct Feb Feb Jan Apr Jan Jan Oct Feb Aug
Price Low $7.30 $8.13 $7.87 $7.54 $7.11 $11.90 $17.14 $18.80 $24.65 $31.96 $35.97 $33.71 $35.65 314.64% <-Total Growth 10 Stock Price
Increase 35.81% 11.37% -3.20% -4.26% -5.64% 67.30% 44.09% 9.68% 31.12% 29.66% 12.55% -6.28% 5.75% 15.28% <-IRR #YR-> 10 Stock Price 314.64%
P/E 15.21 14.78 65.58 5.75 6.21 13.14 18.04 21.99 26.36 22.83 30.23 27.86 24.42 14.49% <-IRR #YR-> 5 Stock Price 96.67%
Trailing P/E 26.55 16.94 14.31 62.79 5.43 10.39 18.94 19.79 28.83 34.18 25.69 28.33 29.46 18.79 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 12.55% P/E:  22.41 26.36 13.14 P/E Ratio Historical Low
-$8.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $33.71
Long Term Debt $1,200 $1,261 $1,497 Debt
Change 5.10% 18.78% 11.94% <-Median-> 2 Change
Ratio to Market Cap 0.18 0.18 0.20 0.18 <-Median-> 3 % of Market C.
Goodwill & Intangibles $54 $57 $55 $55 $54 $54 Intangibles Goodwill
Change 6.08% -2.59% -1.31% -0.87% -1.08% -1.08% <-Median-> 5 Change
Ratio to Market Cap 0.01 0.01 0.01 0.01 0.01 0.01 0.01 <-Median-> 6 % of Market C.
Market Cap $1,308 $1,014 $1,208 $1,109 $1,610 $2,457 $3,580 $3,823 $5,062 $6,836 $6,913 $7,513 $6,787 $6,787 $6,787 640.98% <-Total Growth 10 Market Cap
Long Term Incentive Plan Exp $1.95 $1.70 $12.69 $18.23 $26.42 $10.23 $28.30 $38.51 $32.15 $16.84 non-operating expense
Increase -12.85% 644.98% 43.65% 44.98% -61.27% 176.53% 36.10% -16.53% -47.61% Affects  EPS & CF
Percent of Market Cap 0.16% 0.15% 0.79% 0.74% 0.74% 0.27% 0.56% 0.56% 0.47% 0.22% 0.51% <-Median-> 10 Percent of Market Cap
Percent of Income 13.50% 1.03% 8.44% 14.57% 19.54% 7.84% 19.27% 16.75% 15.92% 7.77% 14.04% <-Median-> 10 Percent of Income
Diluted # of Shares in Million 126.150 125.588 122.196 127.098 136.510 142.278 144.050 153.768 157.456 164.366 169.936 179.688 43.08% <-Total Growth 10 Diluted
Change 55.78% -0.45% -2.70% 4.01% 7.41% 4.23% 1.25% 6.75% 2.40% 4.39% 3.39% 5.74% 4.12% <-Median-> 10 Change
Basic # of Shares in Millions 117.894 121.208 122.196 123.388 127.348 136.216 141.688 152.372 156.632 164.366 169.936 179.688 48.25% <-Total Growth 10 Average
Change 62.84% 2.81% 0.82% 0.98% 3.21% 6.96% 4.02% 7.54% 2.80% 4.94% 3.39% 5.74% 3.70% <-Median-> 10 Change
Difference 2.0% 0.5% 0.3% 1.9% 3.4% 2.6% 1.1% 1.9% 1.1% 2.6% 1.0% 3.3% 1.94% <-Median-> 10 Difference
$341.31 <-12 mths -17.34%
# of Share in Millions 120.250 121.862 122.529 125.777 131.627 139.782 143.201 155.325 158.373 168.677 171.702 185.683 185.683 185.683 185.683 4.30% <-IRR #YR-> 10 Shares 52.37%
Change 10.49% 1.34% 0.55% 2.65% 4.65% 6.20% 2.45% 8.47% 1.96% 6.51% 1.79% 8.14% 0.00% 0.00% 0.00% 5.33% <-IRR #YR-> 5 Shares 29.67%
CF fr Op $M $70.1 $110.7 $119.8 $91.3 $313.2 $153.7 $178.2 $238.0 $385.1 $460.6 $648.2 $412.9 $521.8 $616.5 $655.5 273.16% <-Total Growth 10 Cash Flow
Increase 46.49% 57.95% 8.29% -23.80% 243.02% -50.91% 15.92% 33.53% 61.82% 19.61% 40.72% -36.29% 26.36% 18.15% 6.33% Deb. Conv DRIP, S. Issue
5 year Running Average $69.7 $87.9 $141.0 $157.7 $171.3 $194.9 $253.6 $283.1 $382.0 $428.9 $485.7 $532.0 $571.0 515.67% <-Total Growth 9 CF 5 Yr Running
CFPS $0.58 $0.91 $0.98 $0.73 $2.38 $1.10 $1.24 $1.53 $2.43 $2.73 $3.77 $2.22 $2.81 $3.32 $3.53 127.40% <-Total Growth 10 Cash Flow per Share
Increase 32.57% 55.87% 7.70% -25.77% 227.77% -53.78% 13.16% 23.11% 58.70% 12.30% 38.24% -41.09% 26.36% 18.15% 6.33% 14.07% <-IRR #YR-> 10 Cash Flow 273.16%
5 year Running Average $0.73 $1.11 $1.22 $1.29 $1.40 $1.74 $1.81 $2.34 $2.54 $2.79 $2.97 $3.13 18.30% <-IRR #YR-> 5 Cash Flow 131.70%
P/CF on Median H/L 16.26 11.13 9.06 13.29 4.07 13.59 16.93 14.49 11.64 14.97 10.78 17.20 13.85 9.37% <-IRR #YR-> 10 Cash Flow per Share 144.90%
P/CF on Close Price 12.58 9.76 8.31 7.86 5.88 10.40 14.04 14.28 14.14 12.66 11.87 13.86 13.01 12.31% <-IRR #YR-> 5 Cash Flow per Share 78.69%
-3.22% Diff M/C 16.92% <-IRR #YR-> 8 CFPS 5 yr Running #DIV/0!
Excl.Working Capital CF $33.9 -$6.8 $25.5 $49.9 -$39.2 $82.4 $76.8 $29.7 -$27.0 $79.5 -$65.7 $129.2 $0.0 $0.0 $0.0 14.58% <-IRR #YR-> 5 CFPS 5 yr Running 97.48%
CF fr Op $M WC $104.0 $103.9 $145.3 $141.2 $273.9 $236.1 $255.0 $267.7 $358.1 $540.1 $582.5 $542.2 $521.8 $616.5 $655.5 421.89% <-Total Growth 10 Cash Flow less WC
Increase 73.01% -0.10% 39.84% -2.79% 93.98% -13.80% 7.98% 4.98% 33.77% 50.83% 7.85% -6.92% -3.76% 18.15% 6.33% 17.97% <-IRR #YR-> 10 Cash Flow less WC 421.89%
5 year Running Average $82.6 $110.9 $153.7 $180.1 $210.3 $234.8 $278.2 $331.4 $400.7 $458.1 $508.9 $560.6 $583.7 16.28% <-IRR #YR-> 5 Cash Flow less WC 112.61%
CFPS Excl. WC $0.86 $0.85 $1.19 $1.12 $2.08 $1.69 $1.78 $1.72 $2.26 $3.20 $3.39 $2.92 $2.81 $3.32 $3.53 20.96% <-IRR #YR-> 9 CF less WC 5 Yr Run #DIV/0!
Increase 56.58% -1.42% 39.08% -5.30% 85.36% -18.83% 5.40% -3.22% 31.19% 41.62% 5.95% -13.93% -3.76% 18.15% 6.33% 16.85% <-IRR #YR-> 5 CF less WC 5 Yr Run 117.81%
5 year Running Average $0.69 $0.92 $1.22 $1.39 $1.57 $1.68 $1.91 $2.13 $2.47 $2.70 $2.92 $3.13 $3.19 13.10% <-IRR #YR-> 10 CFPS - Less WC 242.51%
P/CF on Median H/L 10.95 11.85 7.47 8.59 4.65 8.85 11.83 12.89 12.52 12.77 11.99 13.10 13.85 10.40% <-IRR #YR-> 5 CFPS - Less WC 63.97%
P/CF on High Price 13.47 14.16 8.31 10.47 5.89 10.66 14.04 14.86 14.14 15.56 13.38 14.65 15.01 14.65 <-Median-> 5 P/CF High Price
P/CF on Low Price 8.44 9.54 6.64 6.71 3.42 7.04 9.63 10.91 10.90 9.98 10.60 11.55 12.69 10.90 <-Median-> 5 P/CF Low Price
P/CF on Close Price 12.58 9.76 8.31 7.86 5.88 10.40 14.04 14.28 14.14 12.66 11.87 13.86 13.01 11.01 16.35% <-IRR #YR-> 9 CFPS 5 yr Running #DIV/0!
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 13.44 5 yr  14.49 P/CF Med 10 yr 11.91 5 yr  12.77 9.19% Diff M/C 11.42% <-IRR #YR-> 5 CFPS 5 yr Running 71.74%
-$0.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.22 Cash Flow per Share
-$1.24 $0.00 $0.00 $0.00 $0.00 $2.22 Cash Flow per Share
-$0.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.54 CFPS 5 yr Running
-$1.29 $0.00 $0.00 $0.00 $0.00 $2.54 CFPS 5 yr Running
-$103.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $542.2 Cash Flow less WC
-$255.0 $0.0 $0.0 $0.0 $0.0 $542.2 Cash Flow less WC
-$82.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $458.1 CF less WC 5 Yr Run
-$210.3 $0.0 $0.0 $0.0 $0.0 $458.1 CF less WC 5 Yr Run
-$0.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.92 CFPS - Less WC
-$1.78 $0.00 $0.00 $0.00 $0.00 $2.92 CFPS - Less WC
-$0.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.70 CFPS 5 yr Running
-$1.57 $0.00 $0.00 $0.00 $0.00 $2.70 CFPS 5 yr Running
OPM 5.90% 8.09% 8.10% 4.20% 20.27% 7.91% 6.94% 8.09% 11.75% 12.71% 25.71% 16.46% 103.54% <-Total Growth 10 OPM
Increase -8.12% 37.07% 0.19% -48.19% 382.94% -60.96% -12.35% 16.60% 45.28% 8.17% 102.27% -35.98% Should increase  or be stable.
Diff from Median -40.6% -18.5% -18.4% -57.7% 104.2% -20.3% -30.1% -18.5% 18.4% 28.1% 159.0% 65.8% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 9.93% 5 Yrs 12.71% should be  zero, it is a   check on calculations
Current Assets $254.14 $222.58 $338.44 $408.87 $326.57 $425.52 $548.62 $611.10 $787.12 $621.71 $490.16 $579.05 $626.06 Liquidity ratio of 1.5 and up, best
Current Liabilities $244.47 $263.65 $262.78 $557.91 $423.53 $499.44 $362.11 $450.26 $480.31 $540.98 $563.79 $532.73 $604.87 1.12 <-Median-> 10 Ratio
Liquidity Ratio 1.04 0.84 1.29 0.73 0.77 0.85 1.52 1.36 1.64 1.15 0.87 1.09 1.04 1.15 <-Median-> 5 Ratio
Liq. with CF aft div 1.01 0.93 1.40 0.71 1.16 0.91 1.63 1.53 2.07 1.61 1.59 1.33 1.39 1.59 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.83 0.73 1.26 0.45 0.93 0.62 1.12 0.77 1.24 0.58 0.68 0.55 1.39 0.68 <-Median-> 5 Ratio
Curr. Port. Lg T. Db $0.00 $20.00 $90.00 $52.50 $2.70 $0.00 $11.08 $0.00 $47.40 $104.20 $60.00 $60.00
Liquidity 0.84 1.39 0.87 0.88 0.86 1.52 1.39 1.64 1.26 1.07 1.22 1.15 1.26 <-Median-> 5 Ratio
Liq. with CF aft div 0.93 1.52 0.85 1.33 0.91 1.63 1.57 2.07 1.76 1.95 1.50 1.55 1.76 <-Median-> 5 Ratio
Assets $1,220.63 $1,223.01 $1,331.00 $1,693.28 $1,657.90 $1,972.00 $2,233.56 $2,678.3 $3,051.1 $3,850.8 $4,296.6 $4,957.0 $5,407.2 Debt Ratio of 1.5 and up, best
Liabilities $590.43 $602.15 $780.52 $1,057.02 $959.46 $1,186.96 $1,565.34 $1,787.5 $2,127.4 $2,532.6 $2,898.3 $3,115.5 $3,458.5 1.56 <-Median-> 10 Ratio
Debt Ratio 2.07 2.03 1.71 1.60 1.73 1.66 1.43 1.50 1.43 1.52 1.48 1.59 1.56 1.50 <-Median-> 5 Ratio
Total Book Value $630.20 $620.86 $550.48 $636.26 $698.44 $785.04 $668.22 $890.8 $923.7 $1,318.2 $1,398.3 $1,841.5 $1,948.7 $1,948.7 $1,948.7 196.60% <-Total Growth 10 Book Value
Non-Cont Int. $2.20 $2.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
Book Value $628.01 $618.12 $550.48 $636.26 $698.44 $785.04 $668.22 $890.8 $923.7 $1,318.2 $1,398.3 $1,841.5 $1,948.7 $1,948.7 $1,948.7 197.92% <-Total Growth 10 Book Value
Book Value per Share $5.22 $5.07 $4.49 $5.06 $5.31 $5.62 $4.67 $5.74 $5.83 $7.81 $8.14 $9.92 $10.49 $10.49 $10.49 95.52% <-Total Growth 10 Book Value per Share
Change -7.23% -2.88% -11.43% 12.60% 4.89% 5.84% -16.91% 22.91% 1.70% 33.99% 4.21% 21.78% 5.82% 0.00% 0.00% 49.67% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.81 1.99 1.97 1.91 1.82 2.66 4.52 3.87 4.85 5.23 5.00 3.86 3.71 2.33 P/B Ratio Historical Median
P/B Ratio (Close) 2.08 1.64 2.19 1.74 2.31 3.13 5.36 4.29 5.48 5.19 4.94 4.08 3.48 3.48 3.48 6.93% <-IRR #YR-> 10 Book Value per Share 95.52%
Change 62.92% -21.23% 33.73% -20.52% 32.25% 35.72% 71.20% -19.89% 27.69% -5.37% -4.68% -17.48% -14.63% 0.00% 0.00% 16.27% <-IRR #YR-> 5 Book Value per Share 112.53%
Leverage (A/BK) 1.94 1.97 2.42 2.66 2.37 2.51 3.34 3.01 3.30 2.92 3.07 2.69 2.77 2.81 <-Median-> 10 A/BV
Debt/Equity Ratio 0.94 0.97 1.42 1.66 1.37 1.51 2.34 2.01 2.30 1.92 2.07 1.69 1.77 1.81 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.86 5 yr Med 4.85 -9.87% Diff M/C 2.59 Historical Leverage (A/BK)
-$5.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.92
-$4.67 $0.00 $0.00 $0.00 $0.00 $9.92
$236.49 <-12 mths 9.06%
Comprehensive Income $68.08 $14.48 $165.49 $150.32 $125.05 $135.22 $130.60 $146.84 $229.99 $201.92 $216.85 218.53% <-Total Growth 10 Comprehensive Income
Increase -78.73% 1042.93% -9.16% -16.82% 8.13% -3.41% 12.43% 56.63% -12.20% 7.39% 7.39% <-Median-> 5 Comprehensive Income
5 Yr Running Average $105 $118 $141 $138 $154 $169 $185 12.28% <-IRR #YR-> 10 Comprehensive Income 218.53%
ROE 11.0% 2.6% 26.0% 21.5% 15.9% 20.2% 14.7% 15.9% 17.4% 14.4% 11.8% 9.91% <-IRR #YR-> 5 Comprehensive Income 60.37%
5Yr Median 15.9% 20.2% 20.2% 15.9% 15.9% 15.9% 14.7% 9.98% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 9.42% <-IRR #YR-> 5 5 Yr Running Average 56.84%
Median Values Diff 5, 10 yr 0.0% 0.0% 14.7% <-Median-> 5 Return on Equity
-$68.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $216.9
-$135.2 $0.0 $0.0 $0.0 $0.0 $216.9
-$104.7 $0.0 $0.0 $0.0 $0.0 $0.0 $185.2
-$118.1 $0.0 $0.0 $0.0 $0.0 $185.2
Current Liability Coverage Ratio 0.43 0.39 0.55 0.25 0.65 0.47 0.70 0.59 0.75 1.00 1.03 1.02 0.86   CFO / Current Liabilities
5 year Median 0.39 0.43 0.47 0.55 0.59 0.65 0.70 0.75 1.00 1.00 1.00 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 8.52% 8.49% 10.91% 8.34% 16.52% 11.98% 11.42% 9.99% 11.74% 14.03% 13.56% 10.94% 9.65% CFO / Total Assets
5 year Median 8.49% 8.52% 10.91% 11.42% 11.42% 11.74% 11.74% 11.74% 11.74% 11.74% 11.7% <-Median-> 5 Return on Assets 
Return on Assets ROA 5.0% 5.6% 1.1% 9.8% 9.1% 6.3% 6.1% 4.9% 4.8% 6.0% 4.7% 4.4% 5.4% Net  Income/Assets Return on Assets
5Yr Median 5.0% 5.0% 5.6% 6.3% 6.3% 6.3% 6.1% 6.0% 4.9% 4.8% 4.8% 4.8% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 9.6% 11.0% 2.6% 26.0% 21.5% 15.9% 20.2% 14.7% 15.9% 17.4% 14.4% 11.8% 15.0% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 5.6% 9.6% 11.0% 15.9% 20.2% 20.2% 15.9% 15.9% 15.9% 14.7% 15.0% 14.7% <-Median-> 5 Return on Equity
$237.01 <-12 mths 9.30%
Net Income $60.68 $68.08 $14.48 $165.49 $150.32 $125.05 $135.22 $130.60 $146.84 $229.99 $201.92 $216.85 $292 $338 $393 218.53% <-Total Growth 10 Net Income
Increase 166.87% 12.19% -78.73% 1042.93% -9.16% -16.82% 8.13% -3.41% 12.43% 56.63% -12.20% 7.39% 34.65% 15.75% 16.27% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $34.9 $66.3 $91.8 $104.7 $118.1 $141.3 $137.6 $153.5 $168.9 $185.2 $217.5 $255.8 $288.4 12.28% <-IRR #YR-> 10 Net Income 218.53%
Operating Cash Flow $70.06 $110.66 $119.83 $91.30 $313.18 $153.73 $178.22 $237.98 $385.09 $460.59 $648.16 $412.93 9.91% <-IRR #YR-> 5 Net Income 60.37%
Investment Cash Flow -$51.96 -$75.63 -$28.44 -$315.42 -$106.46 -$236.20 -$167.74 -$440.20 -$321.19 -$966.84 -$757.42 -$760.97 20.37% <-IRR #YR-> 9 5 Yr Running Average #DIV/0!
Total Accruals $42.59 $33.06 -$76.91 $389.60 -$56.40 $207.51 $124.74 $332.82 $82.93 $736.23 $311.18 $564.90 9.42% <-IRR #YR-> 5 5 Yr Running Average 56.84%
Total Assets $1,220.63 $1,223.01 $1,331.00 $1,693.28 $1,657.90 $1,972.00 $2,233.56 $2,678.34 $3,051.07 $3,850.83 $4,296.57 $4,956.96 Balance Sheet Assets
Accruals Ratio 3.49% 2.70% -5.78% 23.01% -3.40% 10.52% 5.58% 12.43% 2.72% 19.12% 7.24% 11.40% 11.40% <-Median-> 5 Ratio
EPS/CF Ratio 0.56 0.65 0.10 1.17 0.55 0.54 0.53 0.50 0.41 0.44 0.35 0.41 0.47 <-Median-> 10 EPS/CF Ratio
-$68.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $216.9
-$135.2 $0.0 $0.0 $0.0 $0.0 $216.9
-$34.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $185.2
-$118.1 $0.0 $0.0 $0.0 $0.0 $185.2
Change in Close 51.15% -23.49% 18.45% -10.50% 38.72% 43.65% 42.25% -1.54% 29.86% 26.79% -0.67% 0.50% -9.66% 0.00% 0.00% Count 14 Years of data
up/down down up down down down down down  down down Count 10 71.43%
Meet Prediction? Yes Yes % right Count 2 20.00%
Financial Cash Flow -$24.30 -$40.75 -$75.63 -$208.57 -$207.61 $98.22 -$3.45 $181.32 $121.42 $326.55 $109.69 $350.52 C F Statement  Financial Cash Flow
Total Accruals $66.89 $73.81 -$1.27 $598.17 $151.21 $109.29 $128.19 $151.50 -$38.49 $409.68 $201.49 $214.38 Accruals
Accruals Ratio 5.48% 6.03% -0.10% 35.33% 9.12% 5.54% 5.74% 5.66% -1.26% 10.64% 4.69% 4.32% 4.69% <-Median-> 5 Ratio
Cash $15.66 $0.11 -$0.89 -$0.78 $14.98 $21.81 $0.52 $186.65 $11.31 $13.45 $16.48 $29.92 Cash
Cash per Share $0.13 $0.00 -$0.01 -$0.01 $0.11 $0.15 $0.00 $1.18 $0.07 $0.08 $0.09 $0.16 $0.08 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.54% 0.01% -0.08% -0.05% 0.61% 0.61% 0.01% 3.69% 0.17% 0.19% 0.22% 0.44% 0.19% <-Median-> 5 % of Stock Price
Notes
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 a Portfolio Manager for Manulife Asset Management Limited.
Dividends
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 provides essential services and products to oil and gas producers in western Canada, and
markets related natural gas liquids (NGLs) throughout North America.
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 Sep 30 2012 Nov 13 2013 Nov 23 2014 Nov 21 2015 Nov 13 2016 Nov 12 2017
Smith, David G. 0.434 0.27% 0.450 0.27% 0.509 0.30% 0.562 0.30% 0.000 0.00% was officer until 2014
CEO - Shares - Amount $13.874 $18.222 $20.484 $22.718 $0.000 Listed as Office 2016 INK
Options - percentage 0.242 0.15% 0.252 0.15% 0.265 0.15% 0.275 0.15% 0.000 0.00%
Options - amount $7.744 $10.224 $10.682 $11.112 $0.000
Kroeker, Steven Barney 0.050 0.03% 0.062 0.04% 0.079 0.05% 0.079 0.04% 0.000 0.00%
CFO - Shares - Amount $1.597 $2.494 $3.184 $3.200 $0.000
Options - percentage 0.112 0.07% 0.119 0.07% 0.122 0.07% 0.129 0.07% 0.000 0.00%
Options - amount $3.567 $4.839 $4.896 $5.213 $0.000
Setoguchi, Curtis Dean 0.146 0.09%
CFO $3.602
Balzun, Graham Charles 0.034 0.02% 0.037 0.02% 0.037 0.02% 0.036 0.02% 0.000 0.00%
Officer - Shares - Amount $1.098 $1.481 $1.478 $1.468 $0.000
Options - percentage 0.099 0.06% 0.097 0.06% 0.092 0.05% 0.090 0.05% 0.000 0.00%
Options - amount $3.149 $3.93 $3.693 $3.622 $0.000
Haughey, Douglas J. 0.009 0.01% 0.011 0.01% 0.011 0.01% 0.000 0.00%
Lead Director - Shares - Amount $0.357 $0.429 $0.451 $0.000
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.00 $0.000 $0.000 $0.000
Bertram, James Vance 0.657 0.42% 0.703 0.44% 0.749 0.44% 0.798 0.46% 0.854 0.46% 0.000 0.00% was CEO to 2014
Chairman - Shares - Amt $16.169 $22.477 $30.337 $32.121 $34.557 $0.000 listed 2016 as CEO on INK
Options - percentage 0.307 0.19% 0.317 0.19% 0.318 0.18% 0.274 0.15% 0.000 0.00%
Options - amount $9.824 $12.861 $12.785 $11.094 $0.000
Salary (salary, share rewards and bonus) $1.496
Catell, Robert B. 0.063 0.04% 0.062 0.04%
Chairman - Shares - Amt $2.025 $2.530
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Stock sales 0.002 $58.03
In September 23  2013 $139,272
0.004 $58.12
$203,420
Increase in O/S Shares 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Yes 0
due to SO $0.000 $0.000 $0.00 $0.000 $0.000
Book Value $0.000 $0.000 $0.000 $0.000
Insider Buying -$0.151 -$0.376 -$0.066
Insider Selling $0.222 $1.258 $0.686
Net Insider Selling $0.040 $0.071 $0.882 $0.620
% of Market Cap 0.001% 0.001% 0.012% 0.01%
Directors 9 9 9 11
Women 1 11% 1 11% 2 22% 4 36%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 125 52.17% 109 25.31% 178 32.32% 178 32.32% 202 43.76% 206 52.05%
Total Shares Held 80.453 51.80% 39.786 25.12% 57.794 34.26% 70.680 41.90% 80.742 43.48% 98.508 53.05%
Increase/Decrease 10.027 14.24% -4.605 -10.37% 0.749 1.31% -0.925 -1.29% 1.205 1.52% 10.200 11.55%
Starting No. of Shares 70.426 44.390 57.045 71.605 79.537 88.308
Copyright © 2008 Website of SPBrunner. All rights reserved.