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/ Q1 2018
Just Energy Group Inc. TSX: JE NYSE: JE http://justenergygroup.com Fiscal Yr: Mar 31
Year 3/31/06 3/31/07 3/31/08 3/31/09 3/31/10 3/31/11 3/31/12 3/31/13 3/31/14 3/31/15 3/31/16 3/31/17 3/31/18 3/31/19 3/31/20 Value Description #Y Item Total G
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Split
$3,706.4 <-12 mths -1.35%
Revenue* $1,212.3 $1,532.3 $1,738.7 $1,899.2 $2,299.2 $2,953.2 $2,785.3 $2,882.0 $3,611.1 $3,895.9 $4,105.9 $3,757.1 $3,881 $4,054 $4,319 145.19% <-Total Growth 10 Revenue
Increase 31.64% 26.40% 13.47% 9.23% 21.06% 28.44% -5.69% 3.47% 25.30% 7.89% 5.39% -8.50% 3.30% 4.46% 6.54% 9.38% <-IRR #YR-> 10 Revenue 145.19%
5 year Running Average $717.8 $987.5 $1,227.5 $1,460.7 $1,736.4 $2,084.5 $2,335.1 $2,563.8 $2,906.1 $3,225.5 $3,456.0 $3,650.4 $3,850.2 $3,938.8 $4,023.4 6.17% <-IRR #YR-> 5 Revenue 34.89%
Revenue per Share $11.38 $14.35 $15.97 $17.05 $17.12 $21.56 $20.43 $20.29 $25.12 $26.58 $27.90 $25.56 $26.43 $27.60 $29.41 13.97% <-IRR #YR-> 10 5 yr Running Average 269.67%
Increase 30.56% 26.13% 11.31% 6.74% 0.44% 25.92% -5.26% -0.67% 23.80% 5.82% 4.94% -8.39% 3.40% 4.46% 6.54% 9.35% <-IRR #YR-> 5 5 yr Running Average 56.33%
5 year Running Average $6.96 $9.40 $11.51 $13.49 $15.17 $17.21 $18.43 $19.29 $20.90 $22.80 $24.06 $25.09 $26.32 $26.81 $27.38 5.94% <-IRR #YR-> 10 Revenue per Share 78.10%
P/S (Price/Sales) Med 1.58 1.09 0.93 0.63 0.72 0.64 0.62 0.47 0.30 0.26 0.28 0.29 4.58% <-IRR #YR-> 5 Revenue per Share 25.11%
P/S (Price/Sales) Close 1.59 0.90 0.82 0.62 0.84 0.72 0.68 0.33 0.35 0.22 0.28 0.33 0.27 0.26 0.24 10.32% <-IRR #YR-> 10 5 yr Running Average 166.97%
*Sales in M CDN $  P/S 10 yr  0.49 5 yr  0.33 -45.00% Diff M/C 6.37% <-IRR #YR-> 5 5 yr Running Average 36.16%
-$1,532.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $3,757.1
-$2,785.3 $0.0 $0.0 $0.0 $0.0 $3,757.1
-$987.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $3,650.4
-$2,335.1 $0.0 $0.0 $0.0 $0.0 $3,650.4
-$14.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $25.6
-$20.4 $0.0 $0.0 $0.0 $0.0 $25.6
-$9.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.09
-$18.43 $0.00 $0.00 $0.00 $0.00 $25.09
$173.94 <-12 mths 36.14%
AFFO (Base) $96.90 $109.88 $92.47 $138.20 $127.76
Distributions $178.40 $123.43 $86.72 $74.73 $76.71 not same as Div CF State
Payout Ratio 184.1% 112.3% 93.8% 54.1% 60.0%
AFFO* $1.65 $1.59 $1.77 $0.69 $0.77 $0.64 $0.94 $0.87 -47.54% <-Total Growth 7 AFFO
Increase -3.64% 11.32% -60.91% 11.02% -17.17% 47.88% -8.01% -8.80% <-IRR #YR-> 7 AFFO #DIV/0!
AFFO Yield 11.5% 10.3% 12.8% 10.4% 8.6% 10.7% 12.2% 10.4% -13.33% <-IRR #YR-> 5 AFFO -51.09%
5 year Running Average $1.29 $1.09 $0.96 $0.78 -15.51% <-IRR #YR-> 3 5 yr Running Average #DIV/0!
Payout Ratio 75.15% 77.98% 70.05% 179.20% 109.35% 91.94% 53.14% 57.76% -15.51% <-IRR #YR-> 3 5 yr Running Average #DIV/0!
5 year Running Average 92.89% 94.29% 91.63% 93.90% 93.39% <-Median-> 4 Payout 5 yr Running Average
Price/AFFO Median 7.51 8.65 7.14 13.92 9.88 10.92 8.44 8.69 8.67 <-Median-> 8 P/AFFO Med
Price/AFFO High 8.74 9.92 8.88 18.92 11.76 14.14 10.68 9.95 10.31 <-Median-> 8 P/AFFO High
Price/AFFO Low 6.27 7.39 5.39 8.93 8.01 7.70 6.20 7.44 7.41 <-Median-> 8 P/AFFO Low
Price/AFFO Close 8.67 9.74 7.80 9.64 11.57 9.30 8.20 9.65 9.47 <-Median-> 8 P/AFFO Close
Trailing P/AFFO Close 3.77 12.85 7.71 12.13 8.87 8.87 <-Median-> 5 Trailing P/AFFO Close
Median Values DPR 10 Yrs 76.57% 5 Yrs   91.94% P/CF 5 Yrs   in order 9.88 11.76 7.70 9.64 -100.00% Diff M/C -100.00% Diff M/C 10 DPR 75% to 95% best
* Adjusted Funds From Operations
-$1.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.87
-$1.77 $0.00 $0.00 $0.00 $0.00 $0.87
-$1.29 $0.00 $0.00 $0.78
-$1.29 $0.00 $0.00 $0.78
$136.54 <-12 mths -3.47%
Funds from Opertions $103.82 $124.01 $110.57 $151.20 $141.45 Base
Distributions $178.40 $123.43 $86.72 $74.73 $76.71 not same as Div CF State
Payout Ratio 171.8% 99.5% 78.4% 49.4% 54.2%
Distributable Cash $0.95 $1.21 $1.41 $1.52 $1.52 $1.40 $1.24 $0.74 $0.87 $0.76 $1.03 $0.96 $0.91 $1.05 -20.79% <-Total Growth 10 FFO
Increase 20.25% 27.37% 16.53% 7.80% 0.00% -7.89% -11.43% -40.22% 16.95% -12.24% 35.31% -6.90% -5.05% 15.38% -2.30% <-IRR #YR-> 10 FFO -20.79%
FFO Yield 5.2% 9.4% 10.8% 14.3% 10.6% 9.0% 9.0% 11.1% 9.8% 12.9% 13.3% 11.5% 12.8% 14.8% -5.02% <-IRR #YR-> 5 FFO -22.71%
5 year Running Average $0.73 $0.90 $1.04 $1.18 $1.32 $1.41 $1.42 $1.28 $1.15 $1.00 $0.93 $0.87 $0.91 $0.94 -0.37% <-IRR #YR-> 10 5 yr Running Average -3.60%
Payout Ratio 94.7% 82.6% 83.6% 81.1% 81.6% 88.6% 100.0% 167.3% 96.9% 76.9% 48.6% 52.2% 54.9% 47.6% -9.28% <-IRR #YR-> 5 5 yr Running Average -38.55%
5 year Running Average 90.16% 88.50% 97.47% 97.38% 95.86% 94.56% 97.55% 102.27% 104.19% 102.71% 94.96% 84.12% 64.63% 54.90% 97.43% <-Median-> 10 Payout 5 yr Running Average
Price/FFO Median 18.98 12.94 10.55 7.08 8.15 9.83 10.19 13.00 8.75 9.13 7.71 7.85 8.20 0.00 8.94 <-Median-> 10 P/FFO Med
Price/FFO High 21.87 15.99 12.23 9.95 9.49 11.26 12.68 17.66 10.42 11.83 9.76 8.98 9.43 0.00 10.84 <-Median-> 10 P/FFO High
Price/FFO Low 16.09 9.88 8.87 4.21 6.81 8.39 7.69 8.34 7.09 6.44 5.66 6.72 6.97 0.00 6.95 <-Median-> 10 P/FFO Low
Price/FFO Close 19.07 10.62 9.26 6.97 9.41 11.06 11.13 9.00 10.25 7.78 7.50 8.71 7.79 6.75 9.13 <-Median-> 10 P/FFO Close
Trailing P/FFO Close 22.94 13.53 10.79 7.52 9.41 10.18 9.86 5.38 11.99 6.83 10.15 8.11 7.40 7.79 9.63 <-Median-> 10 Trailing P/FFO Close
Median Values DPR 10 Yrs 82.59% 5 Yrs   76.89% P/CF 5 Yrs   in order 8.75 10.42 6.72 8.71 -11.00% Diff M/C -12.90% Diff M/C 10 DPR 75% to 95% best Median Values
* Funds From Operations
-$1.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.96
-$1.24 $0.00 $0.00 $0.00 $0.00 $0.96
-$0.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.87
-$1.42 $0.00 $0.00 $0.00 $0.00 $0.87
$0.47 <-12 mths -84.44%
Pre-split
EPS Basic $0.49 $0.88 $1.42 -$10.03 $1.81 $3.81 -$0.93 $4.30 $1.16 -$4.01 $0.44 $3.02 243.18% <-Total Growth 10 EPS Basic
Pre-split
EPS Diluted* $0.48 $0.88 $1.41 -$10.03 $1.79 $3.73 -$0.93 $3.68 $1.12 -$4.01 $0.43 $2.42 $1.00 $0.61 $0.66 175.00% <-Total Growth 10 EPS Diluted
Increase 37.14% 83.33% 60.23% -811.35% 117.85% 108.38% -124.93% 495.70% -69.57% -458.04% 110.72% 462.79% -58.68% -39.00% 8.20% 10.65% <-IRR #YR-> 10 Earnings per Share 175.00%
Earnings Yield 2.6% 6.8% 10.8% -94.6% 12.5% 24.1% -6.7% 55.2% 12.6% -67.7% 5.6% 29.0% 14.1% 8.6% 9.3% #NUM! <-IRR #YR-> 5 Earnings per Share 360.22%
5 year Running Average $0.26 $0.42 $0.66 -$1.38 -$1.09 -$0.44 -$0.81 -$0.35 $1.88 $0.72 $0.06 $0.73 $0.19 $0.09 $1.02 5.55% <-IRR #YR-> 10 5 yr Running Average 71.70%
10 year Running Average -$0.09 -$0.19 $0.16 $0.25 -$0.19 -$0.19 -$0.04 -$0.08 $0.98 $0.87 #NUM! <-IRR #YR-> 5 5 yr Running Average 190.32%
* Diluted ESP per share (Earnings/loss from continuing Operations) E/P 10 Yrs 11.66% 5Yrs 12.60%
-$0.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.42
$0.93 $0.00 $0.00 $0.00 $0.00 $2.42
-$0.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.73
$0.81 $0.00 $0.00 $0.00 $0.00 $0.73
Special Dividends $0.00 $0.00 $0.41 $0.165 $0.21 $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
Dividend* $0.900 $1.000 $1.18 $1.232 $1.240 $1.240 $1.240 $1.240 $0.840 $0.585 $0.50 $0.50 $0.50 $0.50 $0.50 -50.00% <-Total Growth 10 Dividends
Increase 7.14% 11.11% 17.87% 4.56% 0.61% 0.00% 0.00% 0.00% -32.26% -30.36% -14.53% 0.00% 0.00% 0.00% 0.00% Count 16 Years of data
Dividends 5 Yr Running $0.66 $0.80 $1.01 $1.15 $1.27 $1.34 $1.38 $1.31 $1.20 $1.03 $0.88 $0.73 $0.59 $0.52 $0.50 -8.38% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 4.99% 6.39% 7.92% 11.45% 10.01% 9.01% 9.82% 12.87% 11.07% 8.42% 6.30% 6.64% 6.70% 9.41% <-Median-> 10 Yield H/L Price
Yield on High  Price 4.33% 5.17% 6.83% 8.15% 8.60% 7.86% 7.89% 9.47% 9.30% 6.50% 4.98% 5.81% 5.83% 7.88% <-Median-> 10 Yield on High  Price
Yield on Low Price 5.89% 8.36% 9.43% 19.26% 11.98% 10.55% 13.00% 20.06% 13.66% 11.94% 8.58% 7.76% 7.89% 11.96% <-Median-> 10 Yield on Low Price
Yield on Close Price 4.97% 7.78% 9.03% 11.63% 8.67% 8.01% 8.99% 18.59% 9.45% 9.88% 6.48% 5.99% 7.05% 7.05% 7.05% 9.01% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 187.50% 113.64% 112.68% -13.93% 81.01% 33.24% -133.33% 33.69% 75.00% -14.59% 116.28% 20.66% 50.00% 81.97% 75.76% 33.47% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 347.49% 235.85% 239.99% -101.12% -132.54% -279.27% -153.84% -352.26% 44.73% 143.31% 1518.94% 100.69% 260.42% 555.56% 48.83% -28.20% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 137.83% 108.58% 127.16% 90.11% 123.02% 110.74% 117.09% 179.42% 73.01% 89.11% 39.33% 48.86% 51.02% 49.02% 100.42% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 119.23% 116.87% 120.55% 114.31% 114.11% 110.91% 112.32% 117.29% 115.60% 110.01% 91.23% 76.47% 57.56% 52.21% 113.21% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 98.00% 84.31% 116.95% 93.45% 100.47% 88.65% 96.07% 158.43% 94.50% 57.25% 43.63% 39.79% 51.02% 49.02% 93.98% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 99.38% 94.47% 101.95% 100.07% 98.98% 97.01% 98.99% 102.44% 103.54% 95.58% 85.86% 71.92% 55.26% 47.66% 98.98% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 8.42% 9.45% 5 Yr Med Payout 33.69% 73.01% 57.25% -6.70% <-IRR #YR-> 10 Dividends -50.00%
* Dividends per share  5 Yr Med and Cur. -16.22% -25.36% Last Div Inc ---> $0.125 $0.125 0.0% -16.61% <-IRR #YR-> 5 Dividends -59.68%
-$1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.50
-$1.24 $0.00 $0.00 $0.00 $0.00 $0.50
Historical Dividends Historical High Div 19.50% Low Div 4.45% Ave Div 11.98% Med Div 8.17% Close Div 7.90% med since IT 9.01% Historical Dividends
High/Ave/Median Values Curr diff Exp. -63.83%     58.48% Exp. -41.11% Exp. -13.68% Exp. -10.69% Exp. -21.73% High/Ave/Median 
Future Dividend Yield Div Yd 8.18% earning in 5 Years at IRR of 3.00% Div Inc. 15.93% Future Dividend Yield
Future Dividend Yield Div Yd 9.48% earning in 10 Years at IRR of 3.00% Div Inc. 34.39% Future Dividend Yield
Future Dividend Yield Div Yd 10.99% earning in 15 Years at IRR of 3.00% Div Inc. 55.80% Future Dividend Yield
Yield if held 5 yrs 23.10% 16.59% 16.20% 7.40% 6.88% 7.92% 8.34% 7.80% 4.72% 3.63% 3.96% 5.19% 6.59% 7.19% 7.60% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 28.65% 17.45% 11.04% 3.49% 2.77% 3.19% 3.36% 4.64% 4.04% 7.27% <-Median-> 6 Paid Median Price
Yield if held 15 yrs 11.55% 7.04% 6.57% 2.99% 11.55% <-Median-> 1 Paid Median Price
Cost covered if held 5 years 92.41% 71.04% 75.28% 37.84% 37.03% 44.18% 44.15% 55.83% 41.54% 32.01% 29.02% 30.36% 34.06% 35.97% 42.85% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 252.19% 163.45% 154.29% 68.56% 61.46% 67.59% 63.81% 79.84% 61.73% 111.43% <-Median-> 6 Paid Median Price
Cost covered if held 15 years 336.86% 204.60% 188.27% 83.49% 336.86% <-Median-> 1 Paid Median Price
Graham No. $3.86 $5.10 $7.61 $7.61 $8.58 $12.39 $12.30 $12.30 $6.79 $6.79 $4.21 $9.98 $6.41 #NUM! #NUM! 95.69% <-Total Growth 10 Graham Price
Price/GP Ratio Med 4.67 3.07 1.95 1.41 1.44 1.11 1.03 0.78 1.12 1.02 1.89 0.75 1.16 1.11 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 5.39 3.80 2.27 1.99 1.68 1.27 1.28 1.06 1.33 1.33 2.39 0.86 1.34 1.33 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 3.96 2.35 1.64 0.84 1.21 0.95 0.78 0.50 0.91 0.72 1.39 0.65 0.99 0.87 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 4.70 2.52 1.72 1.39 1.67 1.25 1.12 0.54 1.31 0.87 1.84 0.84 1.11 #NUM! #NUM! 1.28 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 369.64% 152.07% 71.51% 39.20% 66.67% 24.99% 12.18% -45.78% 30.99% -12.77% 83.58% -16.30% 10.56% #NUM! #NUM! 27.99% <-Median-> 10 Graham Price
Month, Year Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19
Price Close $18.67 $13.29 $18.30 $5.52 $14.31 $14.97 $11.46 $9.49 $7.60 $6.08 $9.88 $7.34 $7.09 $7.09 $7.09 -44.77% <-Total Growth 10 Stock Price D.  per yr 7.62% 6.92%
Increase -0.05% -28.82% 37.70% -69.84% 159.24% 4.61% -23.45% -17.19% -19.92% -20.00% 62.50% -25.71% -3.41% 0.00% 0.00% -5.76% <-IRR #YR-> 10 Stock Price -44.77% -9.05%
P/E 38.90 15.10 12.98 -0.55 7.99 4.01 -12.32 2.58 6.79 -1.52 22.98 3.03 7.09 11.62 10.74 -8.53% <-IRR #YR-> 5 Stock Price -35.95% -5.66%
Trailing P/E 53.34 27.69 20.80 3.91 -1.43 8.36 3.07 -10.20 2.07 5.43 -2.46 17.07 2.93 7.09 11.62 4.73% <-IRR #YR-> 10 Price & Dividend -1.42%
Median 10, 5 Yrs D.  per yr 10.49% 7.56% % Tot Ret 222% -783.46% Price Inc -19.92% P/E:  3.52 3.03 -0.96% <-IRR #YR-> 5 Price & Dividend 1.25%
-$13.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.34
-$11.46 $0.00 $0.00 $0.00 $0.00 $7.34
-$13.29 $1.59 $1.40 $1.45 $1.24 $1.24 $1.24 $0.84 $0.59 $0.50 $7.84
-$11.46 $1.24 $0.84 $0.59 $0.50 $7.84
Month, Year Mar-06 Mar-07 Mar-08 Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
Price Close $18.12 $12.85 $13.06 $10.60 $14.30 $15.48 $13.80 $6.67 $8.89 $5.92 $7.72 $8.35 $7.09 $7.09 $7.09 -35.02% <-Total Growth 10 Stock Price
Increase 11.51% -29.08% 1.63% -18.84% 34.91% 8.25% -10.85% -51.67% 33.28% -33.41% 30.41% 8.16% -15.09% 0.00% 0.00% -4.22% <-IRR #YR-> 10 Stock Price -35.02%
P/E 37.75 14.60 9.26 -1.06 7.99 4.15 -14.84 1.81 7.94 -1.48 17.95 3.45 7.09 11.62 10.74 -9.56% <-IRR #YR-> 5 Stock Price -39.49%
Trailing P/E 51.77 26.77 14.84 7.52 -1.43 8.65 3.70 -7.17 2.42 5.29 -1.93 19.42 2.93 7.09 11.62 6.07% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.  per yr 10.29% 6.37% % Tot Ret 169.46% -199.45% Price Inc 8.16% P/E:  3.80 3.45 -3.19% <-IRR #YR-> 5 Price & Dividend
-$12.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.35
-$13.80 $0.00 $0.00 $0.00 $0.00 $8.35
-$12.85 $1.59 $1.40 $1.45 $1.24 $1.24 $1.24 $0.84 $0.59 $0.50 $8.85
-$13.80 $1.24 $0.84 $0.59 $0.50 $8.85
Price H/L Median $18.03 $15.66 $14.88 $10.77 $12.39 $13.76 $12.63 $9.64 $7.59 $6.95 $7.94 $7.53 $7.46 -51.93% <-Total Growth 10 Stock Price
Increase 7.67% -13.17% -4.98% -27.63% 15.05% 11.10% -8.21% -23.71% -21.22% -8.43% 14.24% -5.23% -0.86% -7.06% <-IRR #YR-> 10 Stock Price -51.93%
P/E 37.56 17.79 10.55 -1.07 6.92 3.69 -13.58 2.62 6.78 -1.73 18.47 3.11 7.46 -9.84% <-IRR #YR-> 5 Stock Price -40.42%
Trailing P/E 51.52 32.61 16.90 7.63 -1.23 7.69 3.39 -10.36 2.06 6.21 -1.98 17.50 3.08 2.21% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 69.62 36.92 22.47 -7.79 -11.32 -30.99 -15.67 -27.37 4.04 9.68 136.90 10.34 38.85 -2.83% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave -148.76 -66.13 62.16 30.60 -36.97 -41.14 -192.95 -93.25 8.73 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 9.28% 7.00% % Tot Ret 419.30% -247% Price Inc -8.43% P/E:  3.40 3.11 Count 16 Years of data
-$15.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.53
-$12.63 $0.00 $0.00 $0.00 $0.00 $7.53
-$15.66 $1.59 $1.40 $1.45 $1.24 $1.24 $1.24 $0.84 $0.59 $0.50 $8.03
-$12.63 $1.24 $0.84 $0.59 $0.50 $8.03
High Months Sep 05 Aug 06 Nov 07 Jun 08 Dec 09 Feb 11 Apr 11 May 12 Mar 14 Apr 14 Dec 15 Jun 16 May 17
Price High $20.78 $19.35 $17.25 $15.13 $14.42 $15.77 $15.72 $13.09 $9.03 $9.00 $10.05 $8.61 $8.58 -55.50% <-Total Growth 10 Stock Price
Increase 11.21% -6.87% -10.85% -12.29% -4.69% 9.36% -0.32% -16.73% -31.02% -0.33% 11.67% -14.33% -0.35% -7.78% <-IRR #YR-> 10 Stock Price -55.50%
P/E 43.29 21.99 12.23 -1.51 8.06 4.23 -16.90 3.56 8.06 -2.24 23.37 3.56 8.58 -11.34% <-IRR #YR-> 5 Stock Price -45.23%
Trailing P/E 59.36 40.31 19.60 10.73 -1.44 8.81 4.21 -14.08 2.45 8.04 -2.51 20.02 3.55 10.15 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -14.33% P/E:  3.89 3.56 41.36 P/E Ratio Historical High
-$19.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.61
-$15.72 $0.00 $0.00 $0.00 $0.00 $8.61
Low Months Apr 05 Mar 07 Mar 08 Nov 08 Jun 09 May 10 Oct 11 Mar 13 Jul 13 Oct 14 Apr 15 Oct 16 Jul 17
Price Low $15.28 $11.96 $12.50 $6.40 $10.35 $11.75 $9.54 $6.18 $6.15 $4.90 $5.83 $6.44 $6.34 -46.15% <-Total Growth 10 Stock Price
Increase 3.21% -21.75% 4.52% -48.80% 61.72% 13.53% -18.81% -35.22% -0.49% -20.33% 18.98% 10.46% -1.55% -6.00% <-IRR #YR-> 10 Stock Price -46.15%
P/E 31.84 13.59 8.87 -0.64 5.78 3.15 -10.26 1.68 5.49 -1.22 13.56 2.66 6.34 -7.56% <-IRR #YR-> 5 Stock Price -32.49%
Trailing P/E 43.67 24.92 14.20 4.54 -1.03 6.56 2.56 -6.65 1.67 4.38 -1.45 14.98 2.62 7.32 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -0.49% P/E:  2.91 2.66 0.29 P/E Ratio Historical Low
-$11.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.44
Long Term Debt $676.50 $660.54 $498.09 $520.56 Debt
Change -2.36% -24.59% 4.51% -13.48% <-Median-> 2 Change
Debt/Market Cap Ratio 0.78 0.58 0.41 0.50 0.58 <-Median-> 3 % of Market C.
Goodwill & Intangibles $447.30 $404.90 $348.51 $345.87 $357.99 $368.45 Intangibles Goodwill scan for 
Change -9.48% -13.93% -0.76% 3.50% 2.92% -5.12% <-Median-> 4 Change this
Intangible/Market Cap Ratio 0.47 0.32 0.40 0.30 0.29 0.35 0.32 <-Median-> 5 % of Market C.
Market Cap $1,931 $1,372 $1,422 $1,181 $1,920 $2,120 $1,882 $947 $1,278 $868 $1,136 $1,228 $1,041 $1,041 $1,041 -10.54% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 129.43 138.1093 138.23 171.30 128.35 188.489 190.094 189.420 46.35% <-Total Growth 7 Diluted
Change 6.71% 0.09% 23.92% -25.07% 46.86% 0.85% -0.35% 0.85% <-Median-> 7 Change
Basic # of Shares in Millions 106.00 106.72 107.53 104.84 127.97 135.28 138.23 140.042 143.040 145.327 146.867 147.589 38.30% <-Total Growth 10 Basic
Change 1.22% 0.68% 0.76% -2.50% 22.06% 5.71% 2.18% 1.31% 2.14% 1.60% 1.06% 0.49% 1.46% <-Median-> 10 Change
Difference 0.5% 0.1% 1.2% 6.3% 4.9% 1.2% -1.4% 1.4% 0.5% 0.8% 0.2% -0.4% 1.04% <-Median-> 10 Difference
$152.01 <-12 mths 1.04%
# of Share in Millions 106.561 106.789 108.858 111.402 134.277 136.964 136.349 142.029 143.751 146.559 147.184 147.014 146.863 146.863 146.863 3.25% <-IRR #YR-> 10 Shares 37.67%
Change 0.83% 0.21% 1.94% 2.34% 20.53% 2.00% -0.45% 4.17% 1.21% 1.95% 0.43% -0.12% -0.10% 0.00% 0.00% 1.52% <-IRR #YR-> 5 Shares 7.82%
Cash Flow from Operations $M $69.6 $98.4 $136.0 $172.8 $158.3 $153.4 $144.4 $98.2 $165.4 $96.2 $187.1 $150.5 $143.9 $149.8 52.97% <-Total Growth 10 Cash Flow
Increase 3.63% 41.35% 38.28% 27.03% -8.39% -3.10% -5.85% -32.02% 68.51% -41.83% 94.47% -19.59% -4.34% 4.08% DRIP Buy Backs SO, S Issued
5 year Running Average $56.5 $71.6 $89.2 $108.8 $127.0 $143.8 $153.0 $145.4 $143.9 $131.5 $138.3 $139.5 $148.6 $145.5 94.70% <-Total Growth 10 CF 5 Yr Running
CFPS $0.65 $0.92 $1.25 $1.55 $1.18 $1.12 $1.06 $0.69 $1.15 $0.66 $1.27 $1.02 $0.98 $1.02 11.11% <-Total Growth 10 Cash Flow per Share
Increase 2.78% 41.05% 35.65% 24.13% -24.00% -5.00% -5.42% -34.74% 66.49% -42.94% 93.65% -19.50% -4.24% 4.08% 4.34% <-IRR #YR-> 10 Cash Flow 52.97%
5 year Running Average $0.55 $0.68 $0.84 $1.00 $1.11 $1.20 $1.23 $1.12 $1.04 $0.94 $0.97 $0.96 $1.02 $0.99 0.83% <-IRR #YR-> 5 Cash Flow 4.20%
P/CF on Med Price 27.61 17.00 11.91 6.94 10.51 12.29 11.93 13.94 6.60 10.59 6.25 7.35 7.61 0.00 1.06% <-IRR #YR-> 10 Cash Flow per Share 11.11%
P/CF on Closing Price 27.75 13.95 10.45 6.84 12.13 13.82 13.03 9.65 7.73 9.02 6.07 8.16 7.23 6.95 -0.68% <-IRR #YR-> 5 Cash Flow per Share -3.36%
-31.41% Diff M/C 3.42% <-IRR #YR-> 10 CFPS 5 yr Running 40.03%
Excl.Working Capital CF $28.3 $28.3 $11.9 -$6.2 $35.5 $38.2 $31.6 $13.0 -$37.6 $53.6 -$18.4 $34.3 $0.0 $0.0 -4.89% <-IRR #YR-> 5 CFPS 5 yr Running -22.17%
CF fr Op $M WC $97.9 $126.7 $147.9 $166.6 $193.8 $191.6 $176.0 $111.2 $127.8 $149.8 $168.7 $184.7 $143.9 $149.8 45.84% <-Total Growth 10 Cash Flow less WC
Increase 21.22% 29.44% 16.75% 12.64% 16.33% -1.15% -8.13% -36.84% 14.95% 17.21% 12.62% 9.52% -22.09% 4.08% 3.85% <-IRR #YR-> 10 Cash Flow less WC 45.84%
5 year Running Average $68.0 $88.7 $105.5 $123.9 $146.6 $165.3 $175.2 $167.8 $160.1 $151.3 $146.7 $148.4 $155.0 $159.4 0.97% <-IRR #YR-> 5 Cash Flow less WC 4.96%
CFPS Excl. WC $0.92 $1.19 $1.36 $1.50 $1.44 $1.40 $1.29 $0.78 $0.89 $1.02 $1.15 $1.26 $0.98 $1.02 5.28% <-IRR #YR-> 10 CF less WC 5 Yr Run 67.33%
Increase 20.22% 29.16% 14.53% 10.07% -3.48% -3.09% -7.72% -39.36% 13.57% 14.96% 12.14% 9.65% -22.01% 4.08% -3.26% <-IRR #YR-> 5 CF less WC 5 Yr Run -15.27%
5 year Running Average $0.66 $0.85 $0.99 $1.14 $1.28 $1.38 $1.40 $1.28 $1.16 $1.08 $1.03 $1.02 $1.06 $1.08 0.58% <-IRR #YR-> 10 CFPS - Less WC 5.93%
P/CF on Med Price 19.63 13.20 10.95 7.20 8.58 9.84 9.79 12.31 8.54 6.80 6.93 5.99 7.61 0.00 -0.54% <-IRR #YR-> 5 CFPS - Less WC -2.65%
P/CF on Closing Price 19.73 10.83 9.61 7.09 9.91 11.07 10.69 8.52 10.00 5.79 6.74 6.65 7.23 6.95 1.87% <-IRR #YR-> 10 CFPS 5 yr Running 20.36%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 10.55 5 yr  7.35 P/CF Med 10 yr 8.56 5 yr  6.93 -15.48% Diff M/C -6.12% <-IRR #YR-> 5 CFPS 5 yr Running -27.06%
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.02 Cash Flow per Share
-$1.06 $0.00 $0.00 $0.00 $0.00 $1.02 Cash Flow per Share
-$0.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.96 CFPS 5 yr Running
-$1.23 $0.00 $0.00 $0.00 $0.00 $0.96 CFPS 5 yr Running
-$126.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $184.7 Cash Flow less WC
-$176.0 $0.0 $0.0 $0.0 $0.0 $184.7 Cash Flow less WC
-$88.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $148.4 CF less WC 5 Yr Run
-$175.2 $0.0 $0.0 $0.0 $0.0 $148.4 CF less WC 5 Yr Run
OPM 5.74% 6.42% 7.82% 9.10% 6.88% 5.19% 5.18% 3.41% 4.58% 2.47% 4.56% 4.00% -37.61% <-Total Growth 10 OPM
Increase -21.28% 11.83% 21.87% 16.29% -24.33% -24.56% -0.17% -34.30% 34.49% -46.08% 84.53% -12.13% Should increase  or be stable.
Diff from Ave 17.6% 31.5% 60.2% 86.3% 41.0% 6.4% 6.2% -30.2% -6.2% -49.4% -6.7% -18.0% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 4.88% 5 Yrs 4.00% should be  zero, it is a   check on calculations
Current Assets $213.1 $247.3 $489.8 $388.5 $158.1 $603.8 $563.8 $689.0 $931.5 $868.3 $825.1 $816.7 $835.8 Liquidity ratio of 1.5 and up, best
Current Liabilities $181.9 $197.6 $263.9 $747.4 $1,037.1 $907.0 $999.6 $751.3 $710.5 $955.3 $943.9 $707.6 $721.4 0.89 <-Median-> 10 Ratio
Liquidity Ratio 1.17 1.25 1.86 0.52 0.15 0.67 0.56 0.92 1.31 0.91 0.87 1.15 1.16 0.92 <-Median-> 5 Ratio
Liq. with CF aft div 1.03 1.21 1.72 0.54 0.12 0.65 0.54 0.81 1.37 0.92 0.99 1.26 1.26 0.99 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.97 1.19 1.48 0.54 0.11 0.48 0.41 0.67 1.19 0.92 0.99 1.17 1.26 0.99 <-Median-> 5 Ratio
Assets $350.2 $357.2 $709.1 $535.8 $1,353.1 $1,588.6 $1,543.0 $1,528.9 $1,642.7 $1,297.2 $1,247.4 $1,238.0 $1,271.0 Debt Ratio of 1.5 and up, best
Liabilities $203.3 $217.1 $510.2 $1,228.0 $1,856.3 $1,774.2 $2,044.5 $1,668.0 $1,734.3 $1,936.0 $1,898.5 $1,387.3 $1,340.9 0.82 <-Median-> 10 Ratio
Debt Ratio 1.72 1.65 1.39 0.44 0.73 0.90 0.75 0.92 0.95 0.67 0.66 0.89 0.95 0.89 <-Median-> 5 Ratio
Book Value -$503.2 -$185.5 -$501.4 -$139.1 -$91.6 -$638.8 -$651.1 -$149.3 -$69.8 -$69.8 -$69.8 #DIV/0! <-Total Growth 7 Book Value
NCI $0.0 $0.0 -$0.6 -$0.7 $6.4 $0.0 $0.0 $0.0 $0.0
Equity Convertible Debentures $0.0 $33.9 $25.8 $25.8 $25.8 $25.8 $25.8 $25.8 $13.5
Preferred Shares $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $128.4 $132.3
Book Value $146.9 $140.2 $199.0 -$692.3 -$503.2 -$219.4 -$526.6 -$164.2 -$123.9 -$664.6 -$676.9 -$303.5 -$215.6 -$215.6 -$215.6 -316.53% <-Total Growth 10 Book Value
Book Value per share $1.38 $1.31 $1.83 -$6.21 -$3.75 -$1.60 -$3.86 -$1.16 -$0.86 -$4.53 -$4.60 -$2.06 -$1.47 -$1.47 -$1.47 -257.28% <-Total Growth 10 Book Value per Share
Change -18.16% -4.78% 39.26% -440% -39.70% -57.25% 141.06% -70.07% -25.45% 426.29% 1.41% -55.11% -28.89% 0.00% 0.00% 46.90% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 13.08 11.93 8.14 -1.73 -3.31 -8.59 -3.27 -8.34 -8.81 -1.53 -1.73 -3.65 -5.08 0.00 0.00 -1.63 P/B Ratio Historical Median
P/B Ratio (Close) 13.15 9.79 7.15 -1.71 -3.82 -9.66 -3.57 -5.77 -10.32 -1.31 -1.68 -4.04 -4.83 -4.83 -4.83 #NUM! <-IRR #YR-> 8 Book Value per Share -316.53%
Change 36.24% -25.52% -27.02% -124% 123.72% 153.21% -63.02% 61.50% 78.77% -87.35% 28.59% 140.96% 19.40% 0.00% 0.00% -11.77% <-IRR #YR-> 5 Book Value per Share 42.37%
Leverage (A/BK) 2.38 2.55 3.56 -0.77 -2.69 -7.24 -2.93 -9.31 -13.26 -1.95 -1.84 -4.08 -5.90 -2.81 <-Median-> 10 A/BV
Debt/Equity Ratio 1.38 1.55 2.56 -1.77 -3.69 -8.09 -3.88 -10.16 -14.00 -2.91 -2.80 -4.57 -6.22 -3.79 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med -3.29 5 yr Med -3.65 46.90% Diff M/C -1.31 Historical A/BV
-$1.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$2.06
$3.86 $0.00 $0.00 $0.00 $0.00 -$2.06
$797.65 <-12 mths 78.45%
Total Comprehensive Income $79.8 -$783.7 $88.9 $417.2 -$180.3 $506.5 $161.8 -$459.3 $75.0 $471.5 491.01% <-Total Growth 9 Comprehensive Income
NCI $0.0 $0.0 $0.0 -$0.1 -$0.7 $1.0 $3.1 $17.9 $24.5
Shareholders $88.9 $88.9 $88.9 $417.2 -$180.1 $507.2 $160.7 -$462.4 $57.1 $447.0 402.80% <-Total Growth 9 Comprehensive Income
Increase 0.00% 0.00% 369.28% -143.18% 381.53% -68.30% -387.65% 112.35% 682.55% 112.35% <-Median-> 5 Comprehensive Income
5 Yr Running Average $100.7 $184.4 $198.8 $88.5 $16.5 $141.9 19.66% <-IRR #YR-> 9 Comprehensive Income 402.80%
ROE 44.7% -12.8% -17.7% -190.1% 34.2% -309.0% -129.8% 69.6% -8.4% -147.3% #NUM! <-IRR #YR-> 5 Comprehensive Income 361.53%
5Yr Median -15.3% -12.8% -17.7% -129.8% -129.8% -8.4% -129.8% 7.09% <-IRR #YR-> 5 5 Yr Running Average #DIV/0!
% Difference from NI -41.8% -108.0% -61.6% -19.0% 42.4% -4.4% 18.3% 3.5% -11.6% 0.1% 7.09% <-IRR #YR-> 5 5 Yr Running Average 40.88%
Median Values Diff 5, 10 yr -8.0% 0.1% -129.8% <-Median-> 5 Return on Equity
-$88.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $447.0
$180.1 $0.0 $0.0 $0.0 $0.0 $447.0
-$100.7 $0.0 $0.0 $0.0 $0.0 $141.9
-$100.7 $0.0 $0.0 $0.0 $0.0 $141.9
Cash Flow/Debt 0.34 0.45 0.27 0.14 0.09 0.09 0.07 0.06 0.10 0.05 0.10 0.11 0.09 <-Median-> 10 CF/Debt
Debt/Cash Flow 2.92 2.21 3.75 7.11 11.73 11.57 14.16 16.99 10.49 20.12 10.15 9.22 11.03 <-Median-> 10 CF/Debt
Current Liability Coverage Ratio 0.54 0.64 0.56 0.22 0.19 0.21 0.18 0.15 0.18 0.16 0.18 0.26   CFO / Current Liabilities
5 year Median 1.17 0.64 0.57 0.56 0.54 0.22 0.21 0.19 0.18 0.18 0.18 0.18 0.18 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 27.94% 35.46% 20.86% 31.09% 14.32% 12.06% 11.41% 7.27% 7.78% 11.55% 13.52% 14.92% CFO / Total Assets
5 year Median 23.67% 24.71% 24.71% 27.94% 27.94% 20.86% 14.32% 12.06% 11.41% 11.41% 11.41% 11.55% 11.5% <-Median-> 5 Return on Assets 
Return on Assets ROA 14.7% 26.3% 21.5% -206.7% 17.1% 32.4% -8.2% 34.7% 8.3% -34.4% 5.2% 36.1% Net  Income/Assets Return on Assets
5Yr Median 5.8% 10.9% 14.7% 14.7% 17.1% 21.5% 17.1% 17.1% 17.1% 8.3% 5.2% 8.3% 12.7% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 35.1% 67.0% 76.8% 160.0% -46.0% -234.9% 24.0% -323.1% -109.7% 67.2% -9.5% -147.1% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 8.2% 20.9% 35.1% 67.0% 67.0% 67.0% 24.0% -46.0% -109.7% -109.7% -9.5% -109.7% -27.8% <-Median-> 10 Return on Equity
$72.49 <-12 mths -83.76%
Net Income $235.1 $517.3 -$126.6 $529.7 $136.9 -$443.7 $82.5 $470.9
NCI $3.6 $2.0 -$0.1 -$0.7 $1.0 $3.1 $17.9 $24.5
Shareholders $51.56 $93.91 $152.76 -$1,107.5 $231.5 $515.3 -$126.5 $530.3 $135.9 -$446.8 $64.6 $446.4 $164 $106 $124 375.35% <-Total Growth 10 Net Income
Increase 38.59% 82.13% 62.66% -824.97% -120.90% 122.62% -124.55% -519.14% -74.37% -428.74% -114.46% 591.00% -63.26% -35.37% 16.98% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $25.6 $43.6 $70.6 -$154.4 -$115.5 -$22.8 -$66.9 $8.6 $257.3 $121.7 $31.5 $146.1 $72.8 $66.8 $181.0 16.87% <-IRR #YR-> 10 Net Income 375.35%
Operating Cash Flow $69.58 $98.35 $136.01 $172.8 $158.3 $153.4 $144.4 $98.2 $165.4 $96.2 $187.1 $150.5 #NUM! <-IRR #YR-> 5 Net Income 452.83%
Investment Cash Flow -$10.07 -$3.73 -$41.24 -$8.2 -$37.5 -$318.8 -$318.8 -$162.8 -$113.2 $133.6 -$6.4 -$58.2 12.86% <-IRR #YR-> 10 5 Yr Running Ave. 235.17%
Total Accruals -$7.95 -$0.72 $58.00 -$1,272.1 $110.7 $680.8 $47.9 $595.0 $83.8 -$676.6 -$116.1 $354.1 #NUM! <-IRR #YR-> 5 5 Yr Running Ave. 318.44%
Total Assets $350.23 $357.23 $709.12 $535.8 $1,353.1 $1,588.6 $1,543.0 $1,528.9 $1,642.7 $1,297.2 $1,247.4 $1,238.0 Balance Sheet Assets
Accruals Ratio -2.27% -0.20% 8.18% -237% 8.18% 42.86% 3.11% 38.92% 5.10% -52.16% -9.31% 28.61% 5.10% <-Median-> 5 Ratio
EPS/CF Ratio 0.52 0.74 1.04 -6.71 1.24 2.67 -0.72 4.70 1.26 -3.92 0.38 1.93 1.14 <-Median-> 10 EPS/CF Ratio
-$93.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $446.4
$126.5 $0.0 $0.0 $0.0 $0.0 $446.4
-$43.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $146.1
$66.9 $0.0 $0.0 $0.0 $0.0 $146.1
Chge in Close 11.51% -29.08% 1.63% -18.84% 34.91% 8.25% -10.85% -51.67% 33.28% -33.41% 30.41% 8.16% -15.09% 0.00% 0.00% Count 17 Years of data
up/down/neutral down up down down down down up up down Count 12 70.59%
Any Predictions? Yes Yes yes % right Count 3 25.00%
Financial Cash Flow -$63.45 -$89.59 -$84.95 -$135.5 -$115.9 $203.9 $203.9 $52.8 -$66.4 -$176.4 -$128.2 -$160.8 C F Statement  Financial CF
Total Accruals $55.50 $88.87 $142.94 -$1,136.6 $226.6 $477.0 -$155.9 $542.2 $150.1 -$500.1 $12.1 $514.9 Accruals
Accruals Ratio 15.85% 24.88% 20.16% -212% 16.75% 30.02% -10.11% 35.46% 9.14% -38.55% 0.97% 41.59% 9.14% <-Median-> 5 Ratio
Cash $97.63 $53.22 $38.50 $20.40 $78.81 $127.60 $57.38 $55.12 Cash
Cash per Share $0.71 $0.39 $0.27 $0.14 $0.54 $0.87 $0.39 $0.38 $0.39 <-Median-> 5 Cash per Share
Percentage of Stock Price 4.60% 2.83% 4.06% 1.60% 9.08% 11.23% 4.67% 5.29% 4.67% <-Median-> 5 % of Stock Price
Notes:
September 13, 2017,  Last estimates were for 2017, 2018 and 2019 of $4190M, $4277M and $4801M for Revenue, $0.92 and $1.00 for FFO for 2017 and 2018, 
$2.86, $0.28and $0.37 for EPS, $0.85 and $0.98 for CFPS for 2017 and 2018 anf $556M for net income for 2017
September 15, 2016.  Last estimates were for 2016 and 2017 of $4177M and $4376M for Revenue, $0.90 and $0.91 for FFO, $1.11 for EPS for 2016, $0.81 for CFPS for 2016 and $40M for Net Income for 2016.
September 20, 2015.  Last estimates were for 2015 and 2016 of $3559M and $3474M for Revenue, $0.77 and $0.70 for FFO, $0.13 for EPS for 2015, $0.81 for CFPS for 2015.
September 13, 2014.  Last estiamtes were for 2014 and 2015 of $3165M and $3434M for revenue, $0.10 for EPS for 2014 and $0.93 for CFPS for 2014.
July 28, 2013.  Last estimates were for 2012 and 2013 of $2901M and $3058M for Revenue, $1.72 for Distributable Cash, $0.74 and $.030 for EPS and $1.40 and $1.59 for CFPS.
Jan 22, 2012.  Last I got Estimates for 2010 and 2011 they were $1.64 and $1.72 for DC, $.79 and $.081 for earnings, $1.65 and $1.64 for cash flow.
Effective January 1, 2011 company became Just Energy (TSX-JE) converting from Just Energy Income Fund (TSX-JE.UN).  Also the exchangeable shares of Just Energy, i.e. Just Energy Exchange Corp (JEEC) were converted.
2009.  Net income loss includes the impact of unrealized gains (losses) which represents the mark to market of future commodity supply acquired to cover future customer demand. The supply has been sold 
to customers at fixed prices greatly diminishing the realization of year-end mark to market gains and losses. The hit the company took was because of changes in fair value of derivative instruments.
The company feels that an adjusted net income (of $169.926 and $1.52 a share) is a more appropriate measure of the performance of the Fund since the underlying supply is held to its maturity, and therefore,
mark to market gains and losses do not impact the long-term financial performance of the Fund.  
They had units splits on 31 Jul 2002 and 20 Jan 2004.  Both were 2 to 1 splits.  Both showed in 2003 statements.
May 29 2009 - June Energy Incone Fund (TSX-JE.UN)
2001. Energy Savings Income Fund has symbol of TSX-SIF.UN. Company started the business in 1997.
Note: Number of shares includes preferred shares and exchangeable shares.
Sector:
Power, Utility
What should this stock accomplish?
Would I buy this company and Why.
I would never buy a stock with a negative book value or Shareholders value.
Why am I following this stock. 
I started to follow this is July 2010.  It was one of the high yield income trusts that people were talking about, so I decided to check it out.
Dividends
For September 2014, dividends are switching to quarterly payments with dividends paid in June, September, December and March
Dividends were paid monthly.  Dividends are declared for one month and paid in the same month.
For example, the January payment was declared on January 2, 2014 for shareholders of record of January 15, 2014 and paid on January 31, 2014.
How they make their money.
Just Energy’s business involves the sale of natural gas and/or electricity to residential and commercial customers under long-term fixed-price and price-protected contracts. Just Energy derives its margin 
or gross profit from the difference between the fixed price at which it is able to sell the commodities to its customers and the fixed price at which it purchases the associated volumes from its suppliers.  The company
also offers “green” products through its Just Green program. Through its subsidiary Terra Grain Fuels, the Fund produces and sells wheat-based ethanol.
This company makes its money as an electricity and gas reseller.  You have probably met one of the representatives of these sorts of companies.  They come to your door and ask if you want protection from future 
electrical rate increases.  They do not really make clear what it is they are selling.
As far as I can see, people from this company go door to door to sell their products.  There has been lots of complaints about their tactics and prices.  
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 Jan 22 2013 Jul 29 2013 Sep 14 2014 Sep 20 2015 Sep 15 2016 Sep 13 2017
Lewis, James 0.178 0.12% 0.276 0.19% 0.358 0.24% 0.510 0.35%
Co-CEO - Shares - Amount $1.054 $2.133 $2.989 $3.62
Options - percentage 0.482 0.33% 0.563 0.38% 0.586 0.40% 0.502 0.34%
Options - amount $2.855 $4.349 $4.891 $3.56
Merril, Deborah 0.128 0.09% 0.221 0.15% 0.298 0.20% 0.442 0.30%
Co-CEO - Shares - Amount $0.759 $1.709 $2.492 $3.14
Options - percentage 0.465 0.32% 0.551 0.37% 0.580 0.39% 0.497 0.34%
Options - amount $2.752 $4.257 $4.840 $3.53
Hartwick, Kenneth 0.039 0.03%
CEO - Shares - Amount $0.349
Options - percentage 1.079 0.75%
Options - amount $9.595
Mccullough, Patrick 0.000 0.00% 0.017 0.01% 0.037 0.03% 0.152 0.10%
CFO - Shares - Amount $0.000 $0.129 $0.312 $1.08
Options - percentage 0.150 0.10% 0.195 0.13% 0.266 0.18% 0.361 0.25%
Options - amount $0.888 $1.504 $2.224 $2.56
Summers, Elizabeth 0.009 0.01%
CFO - Shares - Amount $0.084
Options - percentage 0.228 0.16%
Options - amount $2.026
Davids, Jonah 0.007 0.00% 0.010 0.01% 0.025 0.02% 0.051 0.03%
Officer - Shares - Amount $0.043 $0.074 $0.205 $0.36
Options - percentage 0.047 0.03% 0.042 0.03% 0.044 0.03% 0.045 0.03%
Options - amount $0.281 $0.321 $0.371 $0.32
Bird, Stephanie 0.023 0.02%
Officer - Shares - Amount $0.200
Options - percentage 0.012 0.01%
Options - amount $0.110
Gahn, Robert Scott 0.268 0.19%
Officer - Shares - Amount $2.384
Options - percentage 0.384 0.27%
Options - amount $3.410
Brussa, John Albert 0.082 0.06% 0.082 0.06% 0.082 0.06% 0.082 0.06% 0.082 0.06%
Director - Shares - Amount $0.729 $0.485 $0.633 $0.685 $0.58
Options - percentage 0.017 0.01% 0.020 0.01% 0.025 0.02% 0.030 0.02% 0.038 0.03%
Options - amount $0.149 $0.117 $0.195 $0.254 $0.27
MacDonald, Rebecca 5.846 4.07% 5.947 4.06% 5.974 4.06% 6.041 4.11% 6.170 4.20%
Chairman - Shares - Amt $51.972 $35.207 $46.120 $50.441 $43.74
Options - percentage 0.629 0.44% 0.932 0.64% 1.071 0.73% 1.081 0.74% 0.912 0.62%
Options - amount $5.588 $5.516 $8.266 $9.024 $6.47
Joyce, Ron 17.208 11.74% 18.355 12.47% 19.000 12.92% 19.942 13.58%
10% Holder - Shares - Amt $101.872 $141.698 $158.650 $141.39
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.00
Pattison, James A. 17.000 11.60% 24.313 16.52% 24.313 16.54% 24.313 16.55%
10% Holder - Shares - Amt $100.640 $187.695 $203.012 $172.38
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.00
Increase in O/S Shares 0.236 0.17% 0.550 0.38% 2.204 1.50% 0.625 0.43% 0.680 0.46%
due to SO $1.571 $4.893 $13.047 $3.698 $5.676
Book Value $3.320 $7.240 $26.272 $6.011 $7.191
Insider Buying -$0.223 -$0.079 $0.000
Insider Selling $0.358 $0.000 $0.235
Net Insider Selling $0.105 $0.134 -$0.079 $0.235
% of Market Cap 0.01% 0.01% -0.01% 0.02%
Directors 9 9 11 10 9
Women 1 11% 1 11% 2 18% 2 20% 2 22%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 116 31.29% 120 28.13% 135 33.00% 139 33.00%
Total Shares Held 31.396 44.669 31.07% 40.506 27.64% 48.578 33.04% 52.640 35.84%
Increase/Decrease 3 Mths 0.760 2.48% 0.426 0.96% -0.110 -0.27% 3.363 7.44% 0.585 1.12%
Starting No. of Shares 30.636 44.243 40.616 45.215 52.055
Copyright © 2008 Website of SPBrunner. All rights reserved.