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 2023 |
|
|
|
|
|
|
|
|
|
Just Energy Group Inc. |
|
|
|
|
TSX: |
JE.H |
OTC: |
JENGQ |
https://investors.justenergy.com/ |
|
|
Fiscal Yr: |
Mar 31 |
|
|
|
|
|
|
|
|
|
|
Year |
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 |
3/31/21 |
3/31/22 |
3/31/23 |
3/30/24 |
3/30/25 |
|
Value |
Description |
#Y |
Item |
Total G |
|
Accounting Rules |
|
C GAAP |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
|
|
|
|
Accounting Rules |
|
|
Split/Consolidation |
|
|
|
|
|
|
|
|
|
|
|
33 |
|
|
|
|
|
|
|
|
|
|
|
Split/Consolidation
Dated |
|
|
|
|
|
|
|
|
|
|
|
17-Sep-20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2,116.5 |
<-12 mths |
-1.77% |
|
|
|
|
|
|
|
Revenue* |
$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,626.6 |
$3,812.5 |
$2,773 |
$2,740 |
$2,155 |
$2,117 |
<-12 mths |
|
|
-22.64% |
<-Total Growth |
10 |
Revenue |
|
|
Increase |
21.06% |
28.44% |
-5.69% |
3.47% |
25.30% |
7.89% |
5.39% |
-8.50% |
-3.47% |
5.13% |
-27.27% |
-1.18% |
-21.37% |
-1.77% |
<-12 mths |
|
|
-2.53% |
<-IRR #YR-> |
10 |
Revenue |
-22.64% |
|
5 year Running Average |
$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,799.3 |
$3,839.6 |
$3,615.0 |
$3,341.8 |
$3,021.3 |
$2,719.3 |
<-12 mths |
|
|
-10.52% |
<-IRR #YR-> |
5 |
Revenue |
-42.65% |
|
Revenue per Share |
$565.06 |
$711.54 |
$674.11 |
$669.61 |
$828.96 |
$877.23 |
$920.57 |
$843.34 |
$806.48 |
$841.01 |
$603.52 |
$56.99 |
$44.81 |
$44.02 |
<-12 mths |
|
|
2.61% |
<-IRR #YR-> |
10 |
5 yr Running Average |
29.39% |
|
Increase |
0.44% |
25.92% |
-5.26% |
-0.67% |
23.80% |
5.82% |
4.94% |
-8.39% |
-4.37% |
4.28% |
-28.24% |
-90.56% |
-21.37% |
-1.77% |
<-12 mths |
|
|
-3.71% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-17.23% |
|
5 year Running Average |
$500.74 |
$567.96 |
$608.08 |
$636.58 |
$689.86 |
$752.29 |
$794.10 |
$827.94 |
$855.32 |
$857.73 |
$802.99 |
$630.27 |
$470.56 |
$318.07 |
<-12 mths |
|
|
-23.74% |
<-IRR #YR-> |
10 |
Revenue per Share |
-93.35% |
|
P/S (Price/Sales) Med |
0.72 |
0.64 |
0.62 |
0.47 |
0.30 |
0.26 |
0.28 |
0.29 |
0.28 |
0.18 |
0.17 |
0.38 |
0.03 |
0.02 |
<-12 mths |
|
|
-44.40% |
<-IRR #YR-> |
5 |
Revenue per Share |
-94.69% |
|
P/S (Price/Sales) Close |
0.84 |
0.72 |
0.68 |
0.33 |
0.35 |
0.22 |
0.28 |
0.33 |
0.23 |
0.18 |
0.04 |
0.04 |
0.03 |
0.005 |
<-12 mths |
|
|
-2.53% |
<-IRR #YR-> |
10 |
5 yr Running Average |
-22.61% |
|
*Sales in M CDN $ |
|
|
|
|
P/S Med |
20 yr |
0.55 |
15 yr |
0.30 |
10 yr |
0.23 |
5 yr |
0.04 |
|
-97.91% |
Diff M/C |
|
-10.69% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-43.16% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,785.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$2,154.6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3,757.1 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$2,154.6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,335.1 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$3,021.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3,650.4 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$3,021.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$674.1 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$44.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$843.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$44.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$608.08 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$470.56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$827.94 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$470.56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$20.78 |
<-12 mths |
-578.94% |
|
|
|
|
|
|
|
|
|
|
AFFO (Base) |
|
|
|
$96.90 |
$109.88 |
$92.47 |
$138.20 |
$127.76 |
$91.20 |
-$4.34 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Distributions |
|
|
|
$178.40 |
$123.43 |
$86.72 |
$74.73 |
$76.71 |
$86.26 |
$87.96 |
|
|
|
|
|
|
|
|
|
|
not same as Div CF State |
|
|
Payout Ratio |
|
|
|
184.1% |
112.3% |
93.8% |
54.1% |
60.0% |
94.6% |
-2027.2% |
|
|
|
|
|
|
|
|
|
|
|
|
|
AFFO* |
$1.65 |
$1.59 |
$1.77 |
$22.83 |
$25.35 |
$21.00 |
$31.05 |
$28.57 |
$20.47 |
-$0.96 |
|
|
|
|
|
|
|
-100.00% |
<-Total Growth |
7 |
AFFO |
|
|
Increase |
|
-3.64% |
11.32% |
1190.04% |
11.02% |
-17.17% |
47.88% |
-8.01% |
-28.35% |
-104.69% |
|
|
|
|
|
|
|
#NUM! |
<-IRR #YR-> |
7 |
AFFO |
-100.00% |
|
AFFO Yield |
0.3% |
0.3% |
0.4% |
10.4% |
8.6% |
10.7% |
12.2% |
10.4% |
10.9% |
-0.6% |
|
|
|
|
|
|
|
#NUM! |
<-IRR #YR-> |
2 |
AFFO |
-100.00% |
|
5 year Running Average |
|
|
|
|
$10.64 |
$14.51 |
$20.40 |
$25.76 |
$25.29 |
$20.02 |
|
|
|
|
|
|
|
13.48% |
<-IRR #YR-> |
5 |
5 yr Running Average |
#DIV/0! |
|
Payout Ratio |
2479.92% |
2573.50% |
2311.79% |
179.20% |
109.35% |
91.94% |
53.14% |
57.76% |
80.61% |
-1718.58% |
|
|
|
|
|
|
|
#NUM! |
<-IRR #YR-> |
2 |
5 yr Running Average |
-100.00% |
|
5 year Running Average |
|
|
|
|
372.83% |
234.05% |
142.51% |
93.90% |
76.34% |
85.20% |
|
|
|
|
|
|
|
118.20% |
<-Median-> |
6 |
Payout 5 yr Running Average |
|
Price/AFFO Median |
247.70 |
285.58 |
235.47 |
13.92 |
9.88 |
10.92 |
8.44 |
8.69 |
11.16 |
-160.52 |
|
|
|
|
|
|
|
9.88 |
<-Median-> |
7 |
P/AFFO Med |
|
|
Price/AFFO High |
288.40 |
327.30 |
293.08 |
18.92 |
11.76 |
14.14 |
10.68 |
9.95 |
13.83 |
-194.89 |
|
|
|
|
|
|
|
11.76 |
<-Median-> |
7 |
P/AFFO High |
|
|
Price/AFFO Low |
207.00 |
243.87 |
177.86 |
8.93 |
8.01 |
7.70 |
6.20 |
7.44 |
8.50 |
-126.14 |
|
|
|
|
|
|
|
7.70 |
<-Median-> |
7 |
P/AFFO Low |
|
|
Price/AFFO Close |
286.00 |
321.28 |
257.29 |
9.64 |
11.57 |
9.30 |
8.20 |
9.65 |
9.17 |
-155.70 |
|
|
|
|
|
|
|
9.30 |
<-Median-> |
7 |
P/AFFO Close |
|
|
Trailing P/AFFO Close |
|
|
|
124.36 |
12.85 |
7.71 |
12.13 |
8.87 |
6.57 |
7.30 |
|
|
|
|
|
|
|
8.87 |
<-Median-> |
7 |
Trailing P/AFFO Close |
|
|
Median Values |
100.64% |
5 Yrs |
57.76% |
P/CF |
5 Yrs |
in order |
8.69 |
10.68 |
7.44 |
9.17 |
|
-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.00 |
$0.00 |
-$0.96 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$25.35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$0.96 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$10.64 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$20.02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$10.64 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$20.02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.20 |
<-12 mths |
-127.43% |
|
|
|
|
|
|
|
Funds from Operations
(FFO) |
|
|
|
$103.82 |
$124.01 |
$110.57 |
$151.20 |
$141.45 |
$107.91 |
$3.21 |
-$9.68 |
$0.96 |
-$0.73 |
|
|
|
|
|
|
|
Base |
|
|
Distributions |
|
|
|
$178.40 |
$123.43 |
$86.72 |
$74.73 |
$76.71 |
$86.26 |
$87.96 |
$18.45 |
$0.00 |
$0.00 |
|
|
|
|
|
|
|
not same as Div CF State |
|
|
Payout Ratio |
|
|
|
171.8% |
99.5% |
78.4% |
49.4% |
54.2% |
79.9% |
2741.2% |
-190.7% |
0.0% |
0.0% |
|
|
|
|
|
|
|
|
|
|
Distributable Cash |
$1.52 |
$1.40 |
$1.24 |
$24.46 |
$28.61 |
$25.11 |
$33.97 |
$31.63 |
$24.22 |
$0.71 |
-$9.68 |
$0.96 |
-$0.73 |
$0.20 |
<-12 mths |
|
|
-158.89% |
<-Total Growth |
10 |
FFO |
|
|
Increase |
0.00% |
-7.89% |
-11.43% |
1872.87% |
16.95% |
-12.24% |
35.31% |
-6.90% |
-23.43% |
-97.07% |
-1462.81% |
109.95% |
-175.83% |
127.43% |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
10 |
FFO |
-158.89% |
|
FFO Yield |
0.3% |
0.3% |
0.3% |
11.1% |
9.8% |
12.9% |
13.3% |
11.5% |
12.9% |
0.5% |
-41.3% |
47.0% |
-64.6% |
95.4% |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
5 |
FFO |
-102.31% |
|
5 year Running Average |
$1.32 |
$1.41 |
$1.42 |
$6.03 |
$11.45 |
$16.16 |
$22.68 |
$28.76 |
$28.71 |
$23.13 |
$16.17 |
$9.57 |
$3.10 |
-$1.71 |
<-12 mths |
|
|
8.13% |
<-IRR #YR-> |
10 |
5 yr Running Average |
118.41% |
|
Payout Ratio |
2692.02% |
2922.76% |
3299.89% |
167.26% |
96.89% |
76.89% |
48.57% |
52.17% |
68.13% |
2323.94% |
-42.63% |
207.68% |
0.00% |
0.00% |
<-12 mths |
|
|
-35.96% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-89.23% |
|
5 year Running Average |
3163.28% |
3120.56% |
3219.05% |
718.96% |
346.52% |
210.07% |
128.19% |
84.12% |
67.25% |
73.77% |
86.73% |
116.26% |
252.66% |
-265.15% |
<-12 mths |
|
|
122.23% |
<-Median-> |
10 |
Payout 5 yr Running Average |
|
Price/FFO Median |
268.88 |
324.34 |
336.12 |
13.00 |
8.75 |
9.13 |
7.71 |
7.85 |
9.44 |
217.06 |
-10.71 |
22.43 |
-2.07 |
3.54 |
<-12 mths |
|
|
8.94 |
<-Median-> |
10 |
P/FFO Med |
|
|
Price/FFO High |
313.07 |
371.72 |
418.35 |
17.66 |
10.42 |
11.83 |
9.76 |
8.98 |
11.69 |
263.54 |
-19.61 |
39.75 |
-2.83 |
5.84 |
<-12 mths |
|
|
11.05 |
<-Median-> |
10 |
P/FFO High |
|
|
Price/FFO Low |
224.70 |
276.96 |
253.89 |
8.34 |
7.09 |
6.44 |
5.66 |
6.72 |
7.18 |
170.58 |
-1.81 |
5.11 |
-1.31 |
1.25 |
<-12 mths |
|
|
6.58 |
<-Median-> |
10 |
P/FFO Low |
|
|
Price/FFO Close |
310.46 |
364.89 |
367.26 |
9.00 |
10.25 |
7.78 |
7.50 |
8.71 |
7.75 |
210.55 |
-2.42 |
2.13 |
-1.55 |
1.05 |
<-12 mths |
|
|
7.77 |
<-Median-> |
10 |
P/FFO Close |
|
|
Trailing P/FFO Close |
310.46 |
336.08 |
325.29 |
177.51 |
11.99 |
6.83 |
10.15 |
8.11 |
5.94 |
6.17 |
33.00 |
-0.21 |
1.17 |
-0.29 |
<-12 mths |
|
|
7.47 |
<-Median-> |
10 |
Trailing P/FFO Close |
|
|
Median Values |
|
DPR |
10 Yrs |
72.51% |
5 Yrs |
68.13% |
P/CF |
5 Yrs |
in order |
9.44 |
11.69 |
5.11 |
2.13 |
|
-88.89% |
Diff M/C |
|
-88.28% |
Diff M/C |
10 |
DPR 75% to 95% best |
Median Values |
* Funds From Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.24 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$0.73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$31.63 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$0.73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.42 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$28.76 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$11.52 |
<-12 mths |
-18.36% |
|
|
|
|
|
|
|
Pre-split |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-Consolidation 2020 |
$1.81 |
$3.81 |
-$0.93 |
$4.30 |
$1.16 |
-$4.01 |
$0.44 |
$3.02 |
$3.41 |
-$1.68 |
-$2.12 |
|
|
|
|
|
|
|
|
|
|
|
|
EPS Basic |
$59.73 |
$125.73 |
-$30.69 |
$141.90 |
$38.28 |
-$132.33 |
$14.52 |
$99.66 |
$112.53 |
-$55.44 |
-$69.96 |
-$11.79 |
$14.11 |
|
|
|
|
145.98% |
<-Total Growth |
10 |
EPS Basic |
|
|
Pre-split |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-Consolidation 2020 |
$1.79 |
$3.73 |
-$0.93 |
$3.68 |
$1.12 |
-$4.01 |
$0.43 |
$2.42 |
$2.62 |
-$1.68 |
-$2.12 |
-$2.12 |
-$2.12 |
$0.04 |
|
|
|
|
|
|
|
|
|
EPS Diluted* |
$59.07 |
$123.09 |
-$30.69 |
$121.44 |
$36.96 |
-$132.33 |
$14.19 |
$79.86 |
$86.46 |
-$55.44 |
-$69.96 |
-$11.79 |
$13.87 |
-$6.48 |
$1.02 |
|
|
145.19% |
<-Total Growth |
10 |
EPS Diluted |
|
|
Increase |
117.85% |
108.38% |
-124.93% |
495.70% |
-69.57% |
-458.04% |
110.72% |
462.79% |
8.26% |
-164.12% |
-26.19% |
83.15% |
217.64% |
-146.72% |
115.74% |
|
|
6 |
4 |
10 |
Years of Data, EPS P or N |
|
|
Earnings Yield |
12.5% |
24.1% |
-6.7% |
55.2% |
12.6% |
-67.7% |
5.6% |
29.0% |
46.0% |
-37.1% |
-298.6% |
-575.1% |
1227.4% |
-3085.7% |
485.7% |
|
|
#NUM! |
<-IRR #YR-> |
10 |
Earnings per Share |
145.19% |
|
5 year Running Average |
-$36.10 |
-$14.65 |
-$26.60 |
-$11.62 |
$61.97 |
$23.69 |
$1.91 |
$24.02 |
$17.03 |
-$1.45 |
$11.02 |
$5.83 |
-$7.37 |
-$25.96 |
-$14.67 |
|
|
-29.54% |
<-IRR #YR-> |
5 |
Earnings per Share |
-82.63% |
|
10 year Running Average |
|
-$3.05 |
-$6.30 |
$5.12 |
$8.18 |
-$6.20 |
-$6.37 |
-$1.29 |
$2.71 |
$30.26 |
$17.36 |
$3.87 |
$8.33 |
-$4.47 |
-$8.06 |
|
|
-12.04% |
<-IRR #YR-> |
10 |
5 yr Running Average |
72.28% |
|
* Diluted ESP
per share (Earnings/loss from continuing Operations) |
|
|
|
|
|
E/P |
10 Yrs |
9.08% |
5Yrs |
-37.09% |
|
|
|
|
28.22% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-130.69% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$30.69 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$13.87 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$79.86 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$13.87 |
|
|
|
|
|
|
|
|
|
|
|
|
|
$26.60 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$7.37 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$24.02 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$7.37 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend* |
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.00 |
|
|
|
|
|
|
Dividend* |
|
|
Increase |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.00% |
|
|
|
|
|
|
Increase |
|
|
Pre-Consolidation 2020 |
$0.21 |
$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 |
|
|
|
|
|
|
|
Special Dividends |
$6.93 |
$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-Consolidation 2020 |
$1.240 |
$1.240 |
$1.240 |
$1.240 |
$0.840 |
$0.585 |
$0.50 |
$0.50 |
$0.50 |
$0.50 |
$0.13 |
$0.06 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
|
|
|
Dividend* |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$27.72 |
$19.31 |
$16.50 |
$16.50 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
-100.00% |
<-Total Growth |
10 |
Dividends |
|
|
Increase |
0.61% |
0.00% |
0.00% |
0.00% |
-32.26% |
-30.36% |
-14.53% |
0.00% |
0.00% |
0.00% |
-75.00% |
-51.52% |
-100.00% |
0.00% |
0.00% |
0.00% |
|
8 |
6 |
20 |
Years of data, Count P, N |
|
|
Average Increases 5
Year Running |
8.26% |
6.83% |
4.61% |
1.03% |
-6.33% |
-12.52% |
-15.43% |
-15.43% |
-15.43% |
-8.98% |
-17.91% |
-25.30% |
-45.30% |
-45.30% |
-45.30% |
-30.30% |
|
-15.43% |
<-Median-> |
10 |
Average Incr 5 Year Running |
|
Dividends 5 Yr Running |
$41.82 |
$44.06 |
$45.65 |
$43.34 |
$39.66 |
$33.96 |
$29.07 |
$24.19 |
$19.31 |
$17.06 |
$14.03 |
$11.12 |
$7.82 |
$4.52 |
$1.22 |
$0.40 |
|
-82.86% |
<-Total Growth |
10 |
Dividends 5 Yr Running |
|
|
Yield H/L Price |
10.01% |
9.01% |
9.82% |
12.87% |
11.07% |
8.42% |
6.30% |
6.64% |
7.22% |
10.71% |
3.98% |
9.26% |
0.00% |
0.00% |
|
|
|
7.82% |
<-Median-> |
10 |
Yield H/L Price |
|
|
Yield on High Price |
8.60% |
7.86% |
7.89% |
9.47% |
9.30% |
6.50% |
4.98% |
5.81% |
5.83% |
8.82% |
2.17% |
5.22% |
0.00% |
0.00% |
|
|
|
5.82% |
<-Median-> |
10 |
Yield on High
Price |
|
|
Yield on Low Price |
11.98% |
10.55% |
13.00% |
20.06% |
13.66% |
11.94% |
8.58% |
7.76% |
9.49% |
13.62% |
23.58% |
40.65% |
0.00% |
0.00% |
|
|
|
12.78% |
<-Median-> |
10 |
Yield on Low Price |
|
|
Yield on Close Price |
8.67% |
8.01% |
8.99% |
18.59% |
9.45% |
9.88% |
6.48% |
5.99% |
8.79% |
11.04% |
17.61% |
97.56% |
0.00% |
0.00% |
0.00% |
0.00% |
|
9.67% |
<-Median-> |
10 |
Yield on Close Price |
|
|
Payout Ratio EPS |
81.00% |
33.24% |
0.00% |
33.69% |
75.00% |
0.00% |
116.28% |
20.66% |
19.08% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
#DIV/0! |
|
9.54% |
<-Median-> |
10 |
DPR EPS |
|
|
DPR EPS 5 Yr Running |
0.00% |
0.00% |
0.00% |
0.00% |
64.00% |
143.31% |
1518.94% |
100.69% |
113.37% |
0.00% |
127.25% |
190.95% |
0.00% |
0.00% |
0.00% |
#DIV/0! |
|
107.03% |
<-Median-> |
10 |
DPR EPS 5 Yr Running |
|
|
Payout Ratio CFPS |
123.01% |
110.74% |
117.09% |
179.42% |
73.01% |
89.11% |
39.33% |
48.86% |
119.63% |
0.00% |
0.00% |
207.68% |
0.00% |
0.00% |
|
|
|
60.93% |
<-Median-> |
10 |
DPR CF |
|
|
DPR CF 5 Yr Running |
114.10% |
110.91% |
112.32% |
117.29% |
115.59% |
110.01% |
91.23% |
76.47% |
64.72% |
84.15% |
100.13% |
191.52% |
-716.94% |
-126.51% |
|
|
|
95.68% |
<-Median-> |
10 |
DPR CF 5 Yr Running |
|
|
Payout Ratio CFPS WC |
100.46% |
88.65% |
96.07% |
158.43% |
94.50% |
57.25% |
43.63% |
39.79% |
35.16% |
79.96% |
-21.04% |
-14.25% |
0.00% |
#DIV/0! |
|
|
|
41.71% |
<-Median-> |
10 |
DPR CF WC |
|
|
DPR CF WC 5 Yr Running |
98.98% |
97.01% |
98.99% |
102.44% |
103.54% |
95.58% |
85.86% |
71.92% |
51.00% |
47.24% |
55.11% |
73.78% |
116.42% |
#DIV/0! |
|
|
|
79.82% |
<-Median-> |
10 |
DPR CF WC 5 Yr Running |
|
|
Median Values |
10 Yr Med |
10 Yr Cl |
7.82% |
9.67% |
5 Yr Med |
5 Yr Cl |
7.22% |
11.04% |
5 Yr Med |
Payout |
0.00% |
0.00% |
0.00% |
|
|
|
|
#NUM! |
<-IRR #YR-> |
5 |
Dividends |
|
|
* Dividends per
share |
10 Yr Med |
and Cur. |
-100.00% |
-100.00% |
5 Yr Med |
and Cur. |
-100.00% |
-100.00% |
Last Div Inc ---> |
$0.125 |
$0.125 |
0.0% |
|
|
|
|
#NUM! |
<-IRR #YR-> |
10 |
Dividends |
|
|
Dividends Growth 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#NUM! |
<-IRR #YR-> |
15 |
Dividends |
|
|
Dividends Growth 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#NUM! |
<-IRR #YR-> |
20 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
|
|
|
|
|
-$16.50 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
Dividends Growth 10 |
|
|
-$40.92 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
|
|
|
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 |
$0.00 |
|
|
|
|
|
|
|
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 |
$0.00 |
|
|
|
|
|
|
|
Dividends Growth 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Historical Dividends |
Historical |
High Div |
22.88% |
Low Div |
2.61% |
10 Yr High |
38.94% |
10 Yr Low |
0.22% |
Med Div |
7.92% |
Close Div |
8.67% |
|
|
|
|
med since IT |
8.71% |
|
Historical Dividends |
|
|
High/Ave/Median Values |
Curr diff |
Exp. |
-100.00% |
Exp |
-100.00% |
Exp. |
-100.00% |
|
-100.00% |
Exp. |
-100.00% |
Exp. |
-100.00% |
|
|
|
|
Exp. |
-100.00% |
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
#NUM! |
earning in |
5 |
Years |
at IRR of |
#NUM! |
Div Inc. |
#NUM! |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
#NUM! |
earning in |
10 |
Years |
at IRR of |
#NUM! |
Div Inc. |
#NUM! |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yield |
#NUM! |
earning in |
15 |
Years |
at IRR of |
#NUM! |
Div Inc. |
#NUM! |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
#NUM! |
earning in |
5 |
Years |
at IRR of |
#NUM! |
Div Inc. |
#NUM! |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
#NUM! |
earning in |
10 |
Years |
at IRR of |
#NUM! |
Div Inc. |
#NUM! |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
#NUM! |
earning in |
15 |
Years |
at IRR of |
#NUM! |
Div Inc. |
#NUM! |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
#NUM! |
over |
5 |
Years |
at IRR of |
#NUM! |
Div Cov. |
#NUM! |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
#NUM! |
over |
10 |
Years |
at IRR of |
#NUM! |
Div Cov. |
#NUM! |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
#NUM! |
over |
15 |
Years |
at IRR of |
#NUM! |
Div Cov. |
#NUM! |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yield if held 5 years |
7.40% |
6.88% |
7.92% |
8.34% |
7.80% |
4.72% |
3.63% |
3.96% |
5.19% |
6.59% |
1.80% |
0.76% |
0.00% |
0.00% |
0.00% |
0.00% |
|
4.34% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 10 years |
|
|
28.65% |
17.45% |
11.04% |
3.49% |
2.77% |
3.19% |
3.36% |
4.64% |
1.01% |
0.44% |
0.00% |
0.00% |
0.00% |
0.00% |
|
3.28% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 15 years |
|
|
|
|
|
|
|
11.55% |
7.04% |
6.57% |
0.75% |
0.34% |
0.00% |
0.00% |
0.00% |
0.00% |
|
3.66% |
<-Median-> |
6 |
Paid Median Price |
|
|
Yield if held 20 years |
|
|
|
|
|
|
|
|
|
|
|
|
0.00% |
0.00% |
0.00% |
0.00% |
|
0.00% |
<-Median-> |
1 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cost covered if held 5
years |
37.84% |
37.03% |
44.18% |
44.15% |
55.83% |
41.54% |
32.01% |
29.02% |
30.36% |
34.06% |
30.58% |
21.23% |
15.76% |
9.90% |
3.97% |
1.93% |
|
31.29% |
<-Median-> |
10 |
Paid Median Price |
|
|
Cost covered if held 10
years |
|
|
252.19% |
163.44% |
154.29% |
68.56% |
61.46% |
67.59% |
63.81% |
79.84% |
58.70% |
44.26% |
38.41% |
37.47% |
36.50% |
31.45% |
|
65.70% |
<-Median-> |
10 |
Paid Median Price |
Cost |
|
Cost covered if held 15
years |
|
|
|
|
|
|
|
336.86% |
204.60% |
188.27% |
81.25% |
70.81% |
75.16% |
68.42% |
81.56% |
59.19% |
|
134.76% |
<-Median-> |
6 |
Paid Median Price |
$378.18 |
|
Cost covered if held 20
years |
|
|
|
|
|
|
|
|
|
|
|
|
364.25% |
214.25% |
190.71% |
81.61% |
|
364.25% |
<-Median-> |
1 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends on Shares |
|
|
|
$122.76 |
$83.16 |
$57.92 |
$49.50 |
$49.50 |
$49.50 |
$49.50 |
$12.38 |
$6.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
$480.21 |
No of Years |
10 |
Total Divs |
12/31/11 |
|
Paid |
|
|
$1,134.54 |
$939.51 |
$752.40 |
$601.92 |
$978.12 |
$726.66 |
$534.60 |
$446.49 |
$215.82 |
$17.91 |
$3.27 |
$0.63 |
$0.63 |
$0.63 |
|
$3.27 |
No of Years |
10 |
Worth |
$378.18 |
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$483.48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. |
$24.88 |
$23.87 |
$22.47 |
$99.80 |
$107.92 |
$101.10 |
$117.61 |
$113.47 |
$99.30 |
$8.04 |
$8.04 |
$9.36 |
$4.27 |
$5.79 |
|
|
|
-80.99% |
<-Total Growth |
10 |
Graham Price |
|
|
Price/GP Ratio Med |
16.43 |
19.02 |
18.55 |
3.19 |
2.32 |
2.27 |
2.23 |
2.19 |
2.30 |
19.17 |
12.89 |
2.31 |
0.35 |
0.12 |
|
|
|
2.30 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio High |
19.13 |
21.80 |
23.09 |
4.33 |
2.76 |
2.94 |
2.82 |
2.50 |
2.85 |
23.27 |
23.60 |
4.09 |
0.48 |
0.20 |
|
|
|
2.89 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Low |
13.73 |
16.24 |
14.01 |
2.04 |
1.88 |
1.60 |
1.64 |
1.87 |
1.75 |
15.06 |
2.18 |
0.53 |
0.22 |
0.04 |
|
|
|
1.81 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Close |
18.97 |
21.40 |
20.27 |
2.21 |
2.72 |
1.93 |
2.17 |
2.43 |
1.89 |
18.59 |
2.91 |
0.22 |
0.26 |
0.04 |
|
|
|
2.19 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Prem/Disc Close |
1797.01% |
2039.75% |
1926.86% |
120.56% |
171.83% |
93.23% |
116.62% |
142.83% |
89.10% |
1759.11% |
191.38% |
-78.11% |
-73.54% |
-96.37% |
|
|
|
118.59% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. |
$283.13 |
$408.71 |
$405.96 |
$405.96 |
$223.96 |
$223.96 |
$138.77 |
$329.21 |
$187.61 |
$35.54 |
$35.54 |
$57.27 |
$35.54 |
$13.07 |
|
|
|
-91.25% |
<-Total Growth |
10 |
Graham Price |
|
|
Price/GP Ratio Med |
1.44 |
1.11 |
1.03 |
0.78 |
1.12 |
1.02 |
1.89 |
0.75 |
1.22 |
4.34 |
2.92 |
0.38 |
0.04 |
0.05 |
|
|
|
1.07 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio High |
1.68 |
1.27 |
1.28 |
1.06 |
1.33 |
1.33 |
2.39 |
0.86 |
1.51 |
5.26 |
5.34 |
0.67 |
0.06 |
0.09 |
|
|
|
1.33 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Low |
1.21 |
0.95 |
0.78 |
0.50 |
0.91 |
0.72 |
1.39 |
0.65 |
0.93 |
3.41 |
0.49 |
0.09 |
0.03 |
0.02 |
|
|
|
0.68 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Close |
1.67 |
1.25 |
1.12 |
0.54 |
1.31 |
0.87 |
1.84 |
0.84 |
1.00 |
4.21 |
0.66 |
0.04 |
0.03 |
0.02 |
|
|
|
0.85 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Prem/Disc Close |
66.67% |
24.99% |
12.18% |
-45.78% |
30.99% |
-12.77% |
83.58% |
-16.30% |
0.08% |
320.63% |
-34.07% |
-96.42% |
-96.82% |
-98.39% |
|
|
|
-14.53% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month, Year |
Dec-09 |
Dec-10 |
Dec-11 |
Dec-12 |
Dec-13 |
Dec-14 |
Dec-15 |
Dec-16 |
Dec-17 |
Dec-18 |
Dec-19 |
Dec-20 |
Dec-21 |
Dec-22 |
Dec-23 |
Dec-24 |
|
20.00 |
<Count Years> |
|
Month, Year |
|
|
Pre-Consolidation 2020 |
$14.31 |
$14.97 |
$11.46 |
$9.49 |
$7.60 |
$6.08 |
$9.88 |
$7.34 |
$5.40 |
$4.51 |
$2.18 |
|
|
|
|
|
|
|
|
|
|
|
|
Price Close |
$472.23 |
$494.01 |
$378.18 |
$313.17 |
$250.80 |
$200.64 |
$326.04 |
$242.22 |
$178.20 |
$148.83 |
$71.94 |
$5.97 |
$1.09 |
$0.21 |
$0.21 |
$0.21 |
|
-99.71% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
159.24% |
4.61% |
-23.45% |
-17.19% |
-19.92% |
-20.00% |
62.50% |
-25.71% |
-26.43% |
-16.48% |
-51.66% |
-91.70% |
-81.74% |
-80.73% |
0.00% |
0.00% |
|
17.94 |
<-Median-> |
10 |
CAPE (10 Yr P/E) |
|
|
P/E |
7.99 |
4.01 |
-12.32 |
2.58 |
6.79 |
-1.52 |
22.98 |
3.03 |
2.06 |
-2.68 |
-1.03 |
-0.51 |
0.08 |
-0.03 |
0.21 |
#DIV/0! |
|
-66.07% |
<-IRR #YR-> |
5 |
Stock Price |
-99.55% |
|
Trailing P/E |
-1.43 |
8.36 |
3.07 |
-10.20 |
2.07 |
5.43 |
-2.46 |
17.07 |
2.23 |
1.72 |
-1.30 |
-0.09 |
-0.09 |
0.02 |
-0.03 |
0.21 |
|
-44.28% |
<-IRR #YR-> |
10 |
Stock Price |
-99.71% |
|
CAPE (10 Yr P/E) |
|
-139.45 |
-71.12 |
89.44 |
53.34 |
-63.66 |
-57.46 |
-269.10 |
112.26 |
9.93 |
15.00 |
54.68 |
20.89 |
-31.93 |
-14.58 |
#DIV/0! |
|
-53.27% |
<-IRR #YR-> |
5 |
Price & Dividend |
-55.69% |
|
Median 10, 5 Yrs |
|
D. per yr |
25.80% |
12.79% |
% Tot Ret |
0.00% |
0.00% |
T P/E |
0.82 |
-0.09 |
P/E: |
1.07 |
-0.51 |
|
|
|
|
-18.49% |
<-IRR #YR-> |
10 |
Price & Dividend |
-47.95% |
|
Price 15 |
|
D. per yr |
30.77% |
|
% Tot Ret |
-1404.43% |
|
|
|
|
|
CAPE Diff |
-100.18% |
|
|
|
|
-32.96% |
<-IRR #YR-> |
15 |
Stock Price |
-99.75% |
|
Price 20 |
|
D. per yr |
40.98% |
|
% Tot Ret |
214.54% |
|
|
|
|
|
|
|
|
|
|
|
-21.88% |
<-IRR #YR-> |
20 |
Stock Price |
-99.28% |
|
Price & Dividend 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-2.19% |
<-IRR #YR-> |
15 |
Price & Dividend |
-20.95% |
|
Price & Dividend 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19.10% |
<-IRR #YR-> |
20 |
Price & Dividend |
225.17% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price 5 |
|
|
|
|
|
|
|
-$242.22 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.09 |
|
|
|
|
|
|
|
Price 5 |
|
|
Price 10 |
|
|
-$378.18 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.09 |
|
|
|
|
|
|
|
Price 10 |
|
|
Price & Dividend 5 |
|
|
|
|
|
|
|
-$242.22 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.09 |
|
|
|
|
|
|
|
Price & Dividend 5 |
|
|
Price & Dividend 10 |
|
|
-$378.18 |
$40.92 |
$27.72 |
$19.31 |
$16.50 |
$16.50 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.09 |
|
|
|
|
|
|
|
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 |
$1.09 |
|
|
|
|
|
|
|
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 |
$1.09 |
|
|
|
|
|
|
|
Price 20 |
|
|
Price & Dividend 15 |
$47.85 |
$40.92 |
$40.92 |
$40.92 |
$27.72 |
$19.31 |
$16.50 |
$16.50 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.09 |
|
|
|
|
|
|
|
Price & Dividend 15 |
|
|
Price & Dividend 20 |
$47.85 |
$40.92 |
$40.92 |
$40.92 |
$27.72 |
$19.31 |
$16.50 |
$16.50 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.09 |
|
|
|
|
|
|
|
Price & Dividend 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month, Year |
Mar-10 |
Mar-11 |
Mar-12 |
Mar-13 |
Mar-14 |
Mar-15 |
Mar-16 |
Mar-17 |
Mar-18 |
Mar-19 |
Mar-20 |
Mar-21 |
Mar-22 |
Mar-23 |
Mar-24 |
Apr-25 |
|
21.00 |
<Count Years> |
|
Month, Year |
|
|
Pre-Consolidation 2020 |
$14.30 |
$15.48 |
$13.80 |
$6.67 |
$8.89 |
$5.92 |
$7.72 |
$8.35 |
$5.69 |
$4.53 |
$0.71 |
|
|
|
|
|
|
|
|
|
|
|
|
Price Close |
$471.90 |
$510.84 |
$455.40 |
$220.11 |
$293.37 |
$195.36 |
$254.76 |
$275.55 |
$187.77 |
$149.49 |
$23.43 |
$2.05 |
$1.13 |
$0.21 |
$0.21 |
$0.21 |
|
-99.75% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
34.91% |
8.25% |
-10.85% |
-51.67% |
33.28% |
-33.41% |
30.41% |
8.16% |
-31.86% |
-20.39% |
-84.33% |
-91.25% |
-44.88% |
-81.42% |
0.00% |
0.00% |
|
-45.11% |
<-IRR #YR-> |
10 |
Stock Price |
-99.75% |
|
P/E |
7.99 |
4.15 |
-14.84 |
1.81 |
7.94 |
-1.48 |
17.95 |
3.45 |
2.17 |
-2.70 |
-0.33 |
-0.17 |
0.08 |
-0.03 |
0.21 |
#DIV/0! |
|
-66.69% |
<-IRR #YR-> |
5 |
Stock Price |
-99.59% |
|
Trailing P/E |
-1.43 |
8.65 |
3.70 |
-7.17 |
2.42 |
5.29 |
-1.93 |
19.42 |
2.35 |
1.73 |
-0.42 |
-0.03 |
-0.10 |
0.02 |
-0.03 |
0.21 |
|
-21.51% |
<-IRR #YR-> |
10 |
Price & Dividend |
|
|
Median 10, 5 Yrs |
|
D. per yr |
23.60% |
11.58% |
% Tot Ret |
-109.74% |
-21.00% |
T P/E |
0.85 |
-0.03 |
P/E: |
0.95 |
-0.17 |
|
|
|
|
-55.11% |
<-IRR #YR-> |
5 |
Price & Dividend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$455.40 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$275.55 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$455.40 |
$40.92 |
$27.72 |
$19.31 |
$16.50 |
$16.50 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$275.55 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price H/L Median |
$408.71 |
$454.08 |
$416.79 |
$317.96 |
$250.47 |
$229.35 |
$262.02 |
$248.33 |
$228.53 |
$154.11 |
$103.62 |
$21.60 |
$1.52 |
$0.71 |
|
|
|
-99.64% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
15.05% |
11.10% |
-8.21% |
-23.71% |
-21.22% |
-8.43% |
14.24% |
-5.23% |
-7.97% |
-32.56% |
-32.76% |
-79.15% |
-92.99% |
-53.14% |
|
|
|
-42.98% |
<-IRR #YR-> |
10 |
Stock Price |
-99.64% |
|
P/E |
6.92 |
3.69 |
-13.58 |
2.62 |
6.78 |
-1.73 |
18.47 |
3.11 |
2.64 |
-2.78 |
-1.48 |
-1.83 |
0.11 |
-0.11 |
|
|
|
-63.94% |
<-IRR #YR-> |
5 |
Stock Price |
-99.39% |
|
Trailing P/E |
-1.23 |
7.69 |
3.39 |
-10.36 |
2.06 |
6.21 |
-1.98 |
17.50 |
2.86 |
1.78 |
-1.87 |
-0.31 |
-0.13 |
0.05 |
|
|
|
-19.95% |
<-IRR #YR-> |
10 |
Price & Dividend |
|
|
P/E on Run. 5 yr Ave |
-11.32 |
-30.99 |
-15.67 |
-27.37 |
4.04 |
9.68 |
136.90 |
10.34 |
13.42 |
-106.14 |
9.40 |
3.71 |
-0.21 |
-0.03 |
|
|
|
-52.50% |
<-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 |
84.45 |
5.09 |
5.97 |
5.58 |
0.18 |
-0.16 |
|
|
|
3.69 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
D. per yr |
23.02% |
11.43% |
% Tot Ret |
-115.40% |
-22% |
T P/E |
0.83 |
-0.13 |
P/E: |
1.36 |
-1.48 |
|
|
|
|
|
Count |
20 |
Years of data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$416.79 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$248.33 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$416.79 |
$40.92 |
$27.72 |
$19.31 |
$16.50 |
$16.50 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$248.33 |
$16.50 |
$16.50 |
$4.13 |
$2.00 |
$1.52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
High Months |
Dec 09 |
Feb 11 |
Apr 11 |
May 12 |
Mar 14 |
Apr 14 |
Dec 15 |
Jun 16 |
May 17 |
Nov 18 |
Jul 19 |
Jun 20 |
Jun 21 |
Apr 22 |
|
|
|
|
|
|
|
|
|
Pre-Consolidation 2020 |
$14.42 |
$15.77 |
$15.72 |
$13.09 |
$9.03 |
$9.00 |
$10.05 |
$8.61 |
$8.58 |
$5.67 |
$5.75 |
|
|
|
|
|
|
|
|
|
|
|
|
Price High |
$475.86 |
$520.41 |
$518.76 |
$431.97 |
$297.99 |
$297.00 |
$331.65 |
$284.13 |
$283.14 |
$187.11 |
$189.75 |
$38.28 |
$2.07 |
$1.17 |
|
|
|
-99.60% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
-4.69% |
9.36% |
-0.32% |
-16.73% |
-31.02% |
-0.33% |
11.67% |
-14.33% |
-0.35% |
-33.92% |
1.41% |
-79.83% |
-94.59% |
-43.48% |
|
|
|
-42.44% |
<-IRR #YR-> |
10 |
Stock Price |
-99.60% |
|
P/E |
8.06 |
4.23 |
-16.90 |
3.56 |
8.06 |
-2.24 |
23.37 |
3.56 |
3.27 |
-3.38 |
-2.71 |
-3.25 |
0.15 |
-0.18 |
|
|
|
-62.63% |
<-IRR #YR-> |
5 |
Stock Price |
-99.27% |
|
Trailing P/E |
-1.44 |
8.81 |
4.21 |
-14.08 |
2.45 |
8.04 |
-2.51 |
20.02 |
3.55 |
2.16 |
-3.42 |
-0.55 |
-0.18 |
0.08 |
|
|
|
4.23 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
0.99 |
-0.18 |
P/E: |
1.71 |
-2.71 |
|
|
|
|
38.08 |
P/E Ratio |
|
Historical High |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$518.76 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$284.13 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Low Months |
Jun 09 |
May 10 |
Oct 11 |
Mar 13 |
Jul 13 |
Oct 14 |
Apr 15 |
Oct 16 |
Dec 17 |
Aug 18 |
Mar 20 |
Mar 20 |
Oct 21 |
Aug 22 |
|
|
|
|
|
|
|
|
|
Pre-Consolidation 2020 |
$10.35 |
$11.75 |
$9.54 |
$6.18 |
$6.15 |
$4.90 |
$5.83 |
$6.44 |
$5.27 |
$3.67 |
$0.53 |
|
|
|
|
|
|
|
|
|
|
|
|
Price Low |
$341.55 |
$387.75 |
$314.82 |
$203.94 |
$202.95 |
$161.70 |
$192.39 |
$212.52 |
$173.91 |
$121.11 |
$17.49 |
$4.92 |
$0.96 |
$0.25 |
|
|
|
-99.70% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
61.72% |
13.53% |
-18.81% |
-35.22% |
-0.49% |
-20.33% |
18.98% |
10.46% |
-18.17% |
-30.36% |
-85.56% |
-71.87% |
-80.49% |
-73.96% |
|
|
|
-43.97% |
<-IRR #YR-> |
10 |
Stock Price |
-99.70% |
|
P/E |
5.78 |
3.15 |
-10.26 |
1.68 |
5.49 |
-1.22 |
13.56 |
2.66 |
2.01 |
-2.18 |
-0.25 |
-0.42 |
0.07 |
-0.04 |
|
|
|
-66.04% |
<-IRR #YR-> |
5 |
Stock Price |
-99.55% |
|
Trailing P/E |
-1.03 |
6.56 |
2.56 |
-6.65 |
1.67 |
4.38 |
-1.45 |
14.98 |
2.18 |
1.40 |
-0.32 |
-0.07 |
-0.08 |
0.02 |
|
|
|
3.15 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
0.67 |
-0.07 |
P/E: |
0.87 |
-0.25 |
|
|
|
|
-0.55 |
P/E Ratio |
|
Historical Low |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$314.82 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.96 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$212.52 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.96 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$82 |
<-12 mths |
-80.28% |
|
|
|
|
|
|
|
Free Cash Flow WSJ
Market Watch |
|
|
|
|
|
|
$180.21 |
$142.14 |
$57.18 |
-$49.65 |
$38.98 |
$46 |
$45 |
-$82 |
<-12 mths |
|
|
-21.03% |
<-Total Growth |
6 |
Dividends paid |
|
|
Change |
|
|
|
|
|
|
|
-21.13% |
-59.77% |
-186.83% |
178.50% |
17.70% |
-1.57% |
-282.09% |
<-12 mths |
|
|
-$0.11 |
<-Median-> |
6 |
Chnange |
|
|
Free Cash Flow MS &
Co. |
$111 |
$106 |
$64 |
$40 |
$151 |
$83 |
$170 |
$124 |
$26 |
-$88.04 |
$24.60 |
-$3.12 |
-$45.61 |
-$82.22 |
<-12 mths |
|
|
-171.26% |
<-Total Growth |
10 |
Free Cash Flow |
|
|
Change |
|
|
-39.62% |
-37.50% |
277.50% |
-45.03% |
104.82% |
-27.06% |
-79.03% |
-438.60% |
127.94% |
-112.68% |
-1361.76% |
-80.28% |
<-12 mths |
|
|
-18.29% |
<-IRR #YR-> |
5 |
Free Cash Flow MS |
-136.78% |
|
FCF/CF from Op Ratio |
0.70 |
0.69 |
0.44 |
0.41 |
0.91 |
0.86 |
0.91 |
0.82 |
0.42 |
1.98 |
-0.55 |
-0.07 |
1.30 |
-1.25 |
<-12 mths |
|
|
-3.43% |
<-IRR #YR-> |
10 |
Free Cash Flow MS |
-171.26% |
|
Dividends paid |
|
|
|
|
|
|
$74.73 |
$76.71 |
$86.26 |
$87.96 |
$26.17 |
$26.17 |
$26.17 |
$26.17 |
<-12 mths |
|
|
-69.66% |
<-Total Growth |
6 |
Dividends paid |
|
|
Percentage paid |
|
|
|
|
|
|
43.96% |
61.86% |
331.77% |
-99.91% |
106.41% |
-838.85% |
-57.39% |
-31.83% |
<-12 mths |
|
|
$0.44 |
<-Median-> |
7 |
Percentage paid |
|
|
5 Year Coverage |
|
|
|
|
|
|
|
|
|
|
137.14% |
363.47% |
-293.31% |
-99.10% |
<-12 mths |
|
|
|
|
|
5 Year Coverage |
|
|
Dividend
Coverage Ratio |
|
|
|
|
|
|
2.27 |
1.62 |
0.30 |
-1.00 |
0.94 |
-0.12 |
-1.74 |
-3.14 |
<-12 mths |
|
|
0.30 |
<-Median-> |
7 |
Dividend Coverage Ratio |
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
0.73 |
0.28 |
-0.34 |
-1.01 |
<-12 mths |
|
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$124.00 |
0.00 |
0.00 |
0.00 |
0.00 |
45.16 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$64.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
45.16 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Market Cap |
$1,920 |
$2,120 |
$1,882 |
$947 |
$1,278 |
$868 |
$1,136 |
$1,228 |
$844 |
$678 |
$108 |
$99 |
$54 |
$10 |
$10 |
$10 |
|
-97.11% |
<-Total Growth |
10 |
Market Cap |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split 2004 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-Consolidation 2020 |
129.43 |
138.109285 |
138.23 |
171.30 |
3.68 |
188.489 |
190.094 |
189.420 |
200.039 |
191.267 |
193.566 |
|
|
|
|
|
|
|
|
|
|
|
|
Diluted # of Shares in
Million |
3.922 |
4.185 |
4.189 |
5.191 |
3.677 |
5.712 |
5.760 |
5.740 |
6.062 |
5.796 |
5.866 |
34.568 |
48.079 |
48.920 |
|
|
|
1047.82% |
<-Total Growth |
10 |
Diluted |
|
|
Change |
|
6.71% |
0.09% |
23.92% |
-29.16% |
55.33% |
0.85% |
-0.35% |
5.61% |
-4.39% |
1.20% |
489.33% |
39.08% |
1.75% |
|
|
|
3.40% |
<-Median-> |
10 |
Change |
|
|
Difference
Diluted/Basic |
-1.1% |
-2.0% |
0.0% |
-18.2% |
17.9% |
-22.9% |
-22.7% |
-22.1% |
-26.5% |
-22.0% |
-22.0% |
-1.3% |
1.7% |
-1.7% |
|
|
|
-22.00% |
<-Median-> |
10 |
Difference Diluted/Basic |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EPS=NI/Shares |
|
125.71 |
|
124.96 |
31.35 |
-101.45 |
14.52 |
99.81 |
114.30 |
-53.60 |
-67.64 |
-11.78 |
13.87 |
|
|
|
|
|
|
|
|
|
|
Shares=NI/EPS |
|
4.099 |
|
4.244 |
4.335 |
4.404 |
4.451 |
4.472 |
4.456 |
4.519 |
4.577 |
34.125 |
48.920 |
|
|
|
|
|
|
|
|
|
|
Pre-Consolidation 2020 |
127.97 |
135.28 |
138.23 |
140.042 |
143.040 |
145.327 |
146.867 |
147.589 |
147.040 |
149.139 |
151.034 |
|
|
|
|
|
|
|
|
|
|
|
|
Basic # of Shares in
Millions |
3.878 |
4.099 |
4.189 |
4.244 |
4.335 |
4.404 |
4.451 |
4.472 |
4.456 |
4.519 |
4.577 |
34.125 |
48.920 |
48.079 |
|
|
|
1067.89% |
<-Total Growth |
10 |
Basic |
|
|
Change |
22.06% |
5.71% |
2.18% |
1.31% |
2.14% |
1.60% |
1.06% |
0.49% |
-0.37% |
1.43% |
1.27% |
645.62% |
43.35% |
-1.72% |
|
|
|
1.37% |
<-Median-> |
10 |
Change |
|
|
Difference
Basic/Outstanding |
4.9% |
1.2% |
-1.4% |
1.4% |
0.5% |
0.8% |
0.2% |
-0.4% |
0.9% |
0.3% |
0.4% |
40.9% |
-1.7% |
0.0% |
|
|
|
0.44% |
<-Median-> |
10 |
Difference Basic/Outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$65.65 |
<-12 mths |
-286.98% |
|
|
|
|
|
|
|
Pre-split |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-Consolidation 2020 |
134.277 |
136.964 |
136.349 |
142.029 |
143.751 |
146.559 |
147.184 |
147.014 |
148.394 |
149.596 |
151.614 |
|
|
|
|
|
|
|
|
|
|
|
|
# of Share in Millions |
4.069 |
4.150 |
4.132 |
4.304 |
4.356 |
4.441 |
4.460 |
4.455 |
4.497 |
4.533 |
4.594 |
48.079 |
48.079 |
48.079 |
48.079 |
48.079 |
|
27.81% |
<-IRR #YR-> |
10 |
Shares |
1063.63% |
|
Change |
20.53% |
2.00% |
-0.45% |
4.17% |
1.21% |
1.95% |
0.43% |
-0.12% |
0.94% |
0.81% |
1.35% |
946.47% |
0.00% |
0.00% |
0.00% |
0.00% |
|
60.92% |
<-IRR #YR-> |
5 |
Shares |
979.22% |
|
Cash Flow from
Operations $M |
$158.3 |
$153.4 |
$144.4 |
$98.2 |
$165.4 |
$96.2 |
$187.1 |
$150.5 |
$62.0 |
-$44.5 |
-$44.5 |
$46.3 |
-$35.1 |
$65.6 |
<-12 mths |
|
|
-124.32% |
<-Total Growth |
10 |
Cash Flow |
|
|
Increase |
-8.39% |
-3.10% |
-5.85% |
-32.02% |
68.51% |
-41.83% |
94.47% |
-19.59% |
-58.78% |
-171.68% |
0.00% |
-204.15% |
-175.83% |
286.98% |
<-12 mths |
|
|
DRIP |
Buy Backs |
|
SO, S Issued |
|
|
5 year Running Average |
$127.0 |
$143.8 |
$153.0 |
$145.4 |
$143.9 |
$131.5 |
$138.3 |
$139.5 |
$132.2 |
$90.3 |
$62.1 |
$34.0 |
-$3.1 |
-$2.4 |
<-12 mths |
|
|
-102.05% |
<-Total Growth |
10 |
CF 5 Yr Running |
|
|
CFPS |
$38.90 |
$36.95 |
$34.95 |
$22.81 |
$37.97 |
$21.66 |
$41.95 |
$33.77 |
$13.79 |
-$9.81 |
-$9.68 |
$0.96 |
-$0.73 |
$1.37 |
<-12 mths |
|
|
-102.09% |
<-Total Growth |
10 |
Cash Flow per Share |
|
|
Increase |
-24.00% |
-5.00% |
-5.42% |
-34.74% |
66.49% |
-42.94% |
93.65% |
-19.50% |
-59.16% |
-171.10% |
-1.33% |
-109.95% |
-175.83% |
-286.98% |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
10 |
Cash Flow |
-124.32% |
|
5 year Running Average |
$36.65 |
$39.73 |
$40.64 |
$36.96 |
$34.31 |
$30.87 |
$31.87 |
$31.63 |
$29.83 |
$20.27 |
$14.01 |
$5.81 |
-$1.09 |
-$3.58 |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
5 |
Cash Flow |
-123.34% |
|
P/CF on Med Price |
10.51 |
12.29 |
11.93 |
13.94 |
6.60 |
10.59 |
6.25 |
7.35 |
16.57 |
-15.72 |
-10.71 |
22.43 |
-2.07 |
0.52 |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
10 |
Cash Flow per Share |
-102.09% |
|
P/CF on Closing Price |
12.13 |
13.82 |
13.03 |
9.65 |
7.73 |
9.02 |
6.07 |
8.16 |
13.61 |
-15.24 |
-2.42 |
2.13 |
-1.55 |
0.15 |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
5 |
Cash Flow per Share |
-102.16% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-97.79% |
Diff M/C |
|
#NUM! |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
-102.69% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$174.36 |
<-12 mths |
1243.79% |
|
|
|
|
|
|
|
Excl.Working Capital CF |
$35.5 |
$38.2 |
$31.6 |
$13.0 |
-$37.6 |
$53.6 |
-$18.4 |
$34.3 |
$149.0 |
$138.0 |
-$45.6 |
-$721.0 |
$19.9 |
|
|
|
|
#NUM! |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
-103.45% |
|
CF fr Op $M WC |
$193.8 |
$191.6 |
$176.0 |
$111.2 |
$127.8 |
$149.8 |
$168.7 |
$184.7 |
$211.0 |
$93.5 |
-$90.1 |
-$674.7 |
-$15.2 |
|
|
|
|
-108.66% |
<-Total Growth |
10 |
Cash Flow less WC |
|
|
Increase |
16.33% |
-1.15% |
-8.13% |
-36.84% |
14.95% |
17.21% |
12.62% |
9.52% |
14.24% |
-55.67% |
-196.29% |
649.02% |
-97.74% |
|
|
|
|
#NUM! |
<-IRR #YR-> |
10 |
Cash Flow less WC |
-108.66% |
|
5 year Running Average |
$146.6 |
$165.3 |
$175.2 |
$167.8 |
$160.1 |
$151.3 |
$146.7 |
$148.4 |
$168.4 |
$161.5 |
$113.6 |
-$55.1 |
-$95.1 |
|
|
|
|
#NUM! |
<-IRR #YR-> |
5 |
Cash Flow less WC |
-108.25% |
|
CFPS Excl. WC |
$47.63 |
$46.16 |
$42.59 |
$25.83 |
$29.33 |
$33.72 |
$37.82 |
$41.46 |
$46.93 |
$20.64 |
-$19.61 |
-$14.03 |
-$0.32 |
|
|
|
|
#NUM! |
<-IRR #YR-> |
10 |
CF less WC 5 Yr Run |
-154.29% |
|
Increase |
-3.48% |
-3.09% |
-7.72% |
-39.36% |
13.57% |
14.96% |
12.14% |
9.65% |
13.17% |
-56.03% |
-195.01% |
-28.42% |
-97.74% |
|
|
|
|
#NUM! |
<-IRR #YR-> |
5 |
CF less WC 5 Yr Run |
-164.07% |
|
5 year Running Average |
$42.25 |
$45.42 |
$46.11 |
$42.31 |
$38.31 |
$35.53 |
$33.86 |
$33.63 |
$37.85 |
$36.11 |
$25.45 |
$15.08 |
$6.72 |
|
|
|
|
#NUM! |
<-IRR #YR-> |
10 |
CFPS - Less WC |
-100.74% |
|
P/CF on Med Price |
8.58 |
9.84 |
9.79 |
12.31 |
8.54 |
6.80 |
6.93 |
5.99 |
4.87 |
7.47 |
-5.29 |
-1.54 |
-4.78 |
|
|
|
|
#NUM! |
<-IRR #YR-> |
5 |
CFPS - Less WC |
-100.76% |
|
P/CF on Closing Price |
9.91 |
11.07 |
10.69 |
8.52 |
10.00 |
5.79 |
6.74 |
6.65 |
4.00 |
7.24 |
-1.20 |
-0.15 |
-3.56 |
|
|
|
|
-17.52% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
-85.42% |
|
*Operational Cash Flow
per share |
|
|
CF/-WC |
P/CF Med |
10 yr |
6.97 |
5 yr |
-2.07 |
P/CF Med |
10 yr |
6.39 |
5 yr |
-1.54 |
|
-100.00% |
Diff M/C |
|
-27.53% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
-80.02% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-4.1 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
48.1 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
|
|
|
|
|
-4.5 |
0.0 |
0.0 |
0.0 |
0.0 |
48.1 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
-$144.4 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
-$35.1 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
|
|
|
|
|
-$150.5 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
-$35.1 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
-$34.95 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$0.73 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
|
|
|
|
|
-$33.77 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$0.73 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
-$40.64 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$1.09 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$31.63 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$1.09 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
-$176.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
-$15.2 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
|
|
|
|
|
-$184.7 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
-$15.2 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
-$175.2 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
-$95.1 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
|
|
|
|
|
-$148.4 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
-$95.1 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
-$42.59 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$0.32 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
|
|
|
|
|
-$41.46 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$0.32 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
-$46.11 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.72 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$33.63 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.72 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Changes in non-cash working capital |
|
|
-$27.03 |
-$2.22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receiable and unbilled revenue |
|
|
|
|
-$143.81 |
-$95.66 |
$109.14 |
$18.069 |
-$108.900 |
$18.242 |
$33.839 |
$120.870 |
-$37.652 |
|
|
|
|
|
|
|
|
|
|
Gas in storge |
|
|
|
|
$6.43 |
-$2.33 |
$2.22 |
-$9.282 |
$0.538 |
-$0.601 |
-$3.234 |
$3.185 |
-$0.934 |
|
|
|
|
|
|
|
|
|
|
Prepaid expenses and deposits |
|
|
|
|
-$5.20 |
-$27.06 |
-$39.85 |
$3.361 |
-$15.534 |
-$88.184 |
-$89.087 |
$56.585 |
-$12.358 |
|
|
|
|
|
|
|
|
|
|
Inventory |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Provisions |
|
|
|
|
|
|
-$1.22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade and other Payables |
|
|
|
|
$188.34 |
$80.59 |
-$51.58 |
-$25.130 |
$90.972 |
$53.261 |
$106.271 |
-$289.543 |
$32.024 |
|
|
|
|
|
|
|
|
|
|
Adj req for net cash receipts from gas |
|
|
|
|
|
|
|
|
|
|
|
|
-$0.946 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Income taxes recovered/paid |
|
|
-$4.62 |
-$3.24 |
$1.46 |
-$6.01 |
-$14.60 |
-$19.840 |
-$21.319 |
-$12.435 |
-$0.461 |
-$9.744 |
|
|
|
|
|
|
|
|
|
|
|
Adjustment required to reflect net cash receipts from gas sales |
|
|
|
-$4.54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accrued gas
receivables |
|
|
|
|
-$16.49 |
$2.71 |
$31.59 |
-$2.735 |
$0.439 |
$2.256 |
-$12.972 |
|
|
|
|
|
|
|
|
|
|
|
|
Gas delivered in
excess of consumption |
|
|
|
-$6.46 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accrued gas
payable |
|
|
|
|
$6.89 |
-$5.80 |
-$17.26 |
$1.284 |
-$0.276 |
$0.676 |
$11.266 |
|
|
|
|
|
|
|
|
|
|
|
|
Deferred revenue |
|
|
|
$6.34 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sum |
|
|
-$31.65 |
-$10.12 |
$37.62 |
-$53.56 |
$18.44 |
-$34.273 |
-$54.080 |
-$26.785 |
$45.622 |
-$118.647 |
-$19.866 |
|
|
|
|
|
|
|
|
|
|
Google -->
Morningstar |
|
|
|
-$13.01 |
$37.62 |
-$53.56 |
$18.44 |
-$34.27 |
-$39 |
-$138 |
$46 |
$721 |
-$30 |
<-WSJ |
|
|
|
|
|
|
|
|
|
Difference |
|
|
|
$2.90 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
-$15 |
$111 |
$0 |
-$840 |
$10 |
|
|
|
|
|
|
|
|
|
|
Morningstar |
|
|
|
|
$39 |
-$44 |
$19 |
-$23 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
|
|
-$1 |
-$10 |
-$1 |
-$11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TD |
|
|
|
|
$54 |
-$54 |
$18 |
-$34 |
-$149 |
$1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
|
|
-$16 |
$0 |
$0 |
$0 |
$95 |
Chge '20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPM |
6.88% |
5.19% |
5.18% |
3.41% |
4.58% |
2.47% |
4.56% |
4.00% |
1.71% |
-1.17% |
-1.60% |
1.69% |
-1.63% |
3.10% |
|
|
|
-131.43% |
<-Total Growth |
10 |
OPM |
|
|
Increase |
-24.33% |
-24.56% |
-0.17% |
-34.30% |
34.49% |
-46.08% |
84.53% |
-12.13% |
-57.29% |
-168.18% |
-37.49% |
205.40% |
-196.43% |
290.34% |
|
|
|
|
Should increase |
|
or be stable. |
|
|
Diff from Ave |
229.4% |
148.5% |
148.1% |
63.0% |
119.2% |
18.2% |
118.1% |
91.6% |
-18.2% |
-155.8% |
-176.7% |
-19.1% |
-178.0% |
48.4% |
|
|
|
0.00 |
<-Median-> |
10 |
OPM |
|
|
*Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
|
|
|
OPM |
10 Yrs |
2.09% |
5 Yrs |
-1.17% |
|
|
|
|
should be |
zero, it is a |
|
check on
calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long Term Debt |
|
|
|
|
$930.03 |
$676.50 |
$660.54 |
$498.09 |
$422.05 |
$687.94 |
$528.52 |
$1.56 |
$0.13 |
$0.04 |
|
|
|
#DIV/0! |
<-Total Growth |
8 |
Debt |
|
|
Change |
|
|
|
|
|
-27.26% |
-2.36% |
-24.59% |
-15.27% |
63.00% |
-23.17% |
-99.70% |
-91.67% |
-70.00% |
|
|
|
-23.88% |
<-Median-> |
8 |
Change |
|
|
Debt/Market Cap Ratio |
|
|
|
|
0.73 |
0.78 |
0.58 |
0.41 |
0.50 |
1.02 |
4.91 |
0.02 |
0.00 |
0.00 |
|
|
|
0.58 |
<-Median-> |
9 |
% of Market C. |
|
|
Assets/Current
Liabilities Ratio |
|
|
|
|
2.31 |
1.36 |
1.32 |
1.75 |
1.88 |
1.82 |
1.15 |
0.68 |
1.92 |
3.63 |
|
|
|
1.75 |
<-Median-> |
9 |
Assets/Current Liabilities |
|
|
Debt to Cash Flow
(Years) |
|
|
|
|
5.62 |
7.03 |
3.53 |
3.31 |
6.80 |
-15.48 |
-11.89 |
0.03 |
0.00 |
0.00 |
|
|
|
3.31 |
<-Median-> |
9 |
Debt to Cash Flow (Years) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intangibles |
|
|
|
$190.92 |
$140.86 |
$70.74 |
$65.36 |
$68.79 |
$101.25 |
$132.74 |
$98.27 |
$70.72 |
$43.82 |
$44.43 |
|
|
|
#DIV/0! |
<-Total Growth |
9 |
Intangibles |
|
|
Goodwill |
|
|
|
$256.38 |
$264.04 |
$277.77 |
$280.51 |
$289.20 |
$300.67 |
$339.92 |
$272.69 |
$163.77 |
$130.95 |
$127.52 |
|
|
|
#DIV/0! |
<-Total Growth |
9 |
Goodwill |
|
|
Total |
|
|
|
$447.30 |
$404.90 |
$348.51 |
$345.87 |
$357.99 |
$401.93 |
$472.66 |
$370.96 |
$234.49 |
$234.49 |
$171.96 |
|
|
|
#DIV/0! |
<-Total Growth |
9 |
Total |
scan for |
|
Change |
|
|
|
|
-9.48% |
-13.93% |
-0.76% |
3.50% |
12.27% |
17.60% |
-21.52% |
-36.79% |
0.00% |
-26.67% |
|
|
|
-0.76% |
<-Median-> |
9 |
Change |
this |
|
Intangible/Market Cap
Ratio |
|
|
|
0.47 |
0.32 |
0.40 |
0.30 |
0.29 |
0.48 |
0.70 |
3.45 |
2.38 |
4.32 |
17.03 |
|
|
|
0.47 |
<-Median-> |
10 |
% of Market C. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Assets |
$158.1 |
$603.8 |
$563.8 |
$689.0 |
$931.5 |
$868.3 |
$825.1 |
$816.7 |
$1,095.6 |
$1,022.3 |
$686.8 |
$757.0 |
$1,270.3 |
$1,516.7 |
|
|
|
Liquidity ratio of 1.5 and up, best |
|
|
|
Current Liabilities |
$1,037.1 |
$907.0 |
$999.6 |
$751.3 |
$710.5 |
$955.3 |
$943.9 |
$707.6 |
$877.9 |
$893.3 |
$1,060.8 |
$1,602.1 |
$845.9 |
$526.9 |
|
|
|
1.03 |
<-Median-> |
10 |
Ratio |
|
|
Liquidity Ratio |
0.15 |
0.67 |
0.56 |
0.92 |
1.31 |
0.91 |
0.87 |
1.15 |
1.25 |
1.14 |
0.65 |
0.47 |
1.50 |
2.88 |
|
|
|
1.14 |
<-Median-> |
5 |
Ratio |
|
|
Liq. with CF aft div |
0.12 |
0.65 |
0.54 |
0.81 |
1.37 |
0.92 |
0.99 |
1.26 |
1.23 |
1.06 |
0.64 |
0.44 |
1.46 |
3.00 |
|
|
|
1.06 |
<-Median-> |
5 |
Ratio |
|
|
Liq. CF re Inv+Div |
0.11 |
0.48 |
0.41 |
0.67 |
1.19 |
0.92 |
0.99 |
1.17 |
1.21 |
1.01 |
0.62 |
0.44 |
1.46 |
2.96 |
|
|
|
1.01 |
<-Median-> |
5 |
Ratio |
|
|
Curr Long Term Debt |
|
|
|
|
|
14.90 |
13.57 |
0.00 |
$121.5 |
$121.5 |
$253.5 |
$654.2 |
$126.3 |
$125.9 |
|
|
|
|
|
|
|
|
|
Liquidity Less CLTD |
|
|
|
|
|
0.92 |
0.89 |
1.15 |
1.45 |
1.32 |
0.85 |
0.80 |
1.77 |
3.78 |
|
|
|
1.32 |
<-Median-> |
5 |
Ratio |
|
|
Liq. with CF aft div |
|
|
|
|
|
0.93 |
1.01 |
1.26 |
1.43 |
1.21 |
0.83 |
0.75 |
1.72 |
3.95 |
|
|
|
1.21 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Assets |
$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,646.8 |
$1,626.5 |
$1,215.8 |
$1,091.8 |
$1,623.8 |
$1,911.4 |
|
|
|
Debt Ratio of 1.5 and up, best |
|
|
|
|
Liabilities |
$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,416.1 |
$1,715.5 |
$1,711.1 |
$1,686.6 |
$1,429.6 |
$1,554.0 |
|
|
|
0.90 |
<-Median-> |
10 |
Ratio |
|
|
Debt Ratio |
0.73 |
0.90 |
0.75 |
0.92 |
0.95 |
0.67 |
0.66 |
0.89 |
1.16 |
0.95 |
0.71 |
0.65 |
1.14 |
1.23 |
|
|
|
0.95 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Book Value |
-$503.2 |
-$185.5 |
-$501.4 |
-$139.1 |
-$91.6 |
-$638.8 |
-$651.1 |
-$149.3 |
$230.7 |
-$89.0 |
-$495.3 |
-$594.8 |
$194.2 |
$357.4 |
|
|
|
138.73% |
<-Total Growth |
10 |
Book Value |
|
|
NCI |
$0.0 |
$0.0 |
-$0.6 |
-$0.7 |
$6.4 |
$0.0 |
$0.0 |
$0.0 |
-$0.4 |
-$0.4 |
-$0.4 |
-$0.4 |
-$0.4 |
-$0.3 |
|
|
|
|
|
|
NCI |
|
|
Equity Convertible
Debentures |
$0.0 |
$33.9 |
$25.8 |
$25.8 |
$25.8 |
$25.8 |
$25.8 |
$13.5 |
$13.0 |
$13.0 |
$13.0 |
$0.0 |
$0.0 |
$0.0 |
|
|
|
|
|
|
Equity Convertible Debentures |
|
Preferred Shares |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$128.4 |
$136.8 |
$147.0 |
$147.0 |
$0.0 |
$0.0 |
$0.0 |
|
|
|
|
|
|
Preferred Shares |
|
|
Book Value |
-$503.2 |
-$219.4 |
-$526.6 |
-$164.2 |
-$123.9 |
-$664.6 |
-$676.9 |
-$291.2 |
$81.4 |
-$248.6 |
-$654.9 |
-$594.4 |
$194.6 |
$357.7 |
$357.7 |
$357.7 |
|
136.96% |
<-Total Growth |
10 |
Book Value |
|
|
Book Value per share |
-$123.66 |
-$52.87 |
-$127.44 |
-$38.14 |
-$28.43 |
-$149.65 |
-$151.76 |
-$65.36 |
$18.09 |
-$54.84 |
-$142.54 |
-$12.36 |
$4.05 |
$7.44 |
$7.44 |
$7.44 |
|
103.18% |
<-Total Growth |
10 |
Book Value per Share |
|
|
Change |
39.70% |
57.25% |
-141.06% |
70.07% |
25.45% |
-426.29% |
-1.41% |
56.93% |
127.68% |
-403.09% |
-159.91% |
91.33% |
132.74% |
83.81% |
0.00% |
0.00% |
|
#DIV/0! |
P/B Ratio |
|
Current/10 Year Median |
|
|
P/B Ratio (Median) |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
12.63 |
0.00 |
0.00 |
0.00 |
0.37 |
0.10 |
0.00 |
0.00 |
|
0.00 |
P/B Ratio |
|
Historical Median |
|
|
P/B Ratio (Close) |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
10.38 |
0.00 |
0.00 |
0.00 |
0.28 |
0.03 |
0.03 |
0.03 |
|
#NUM! |
<-IRR #YR-> |
10 |
Book Value per Share |
218.55% |
|
Change |
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% |
-89.89% |
0.00% |
0.00% |
|
#NUM! |
<-IRR #YR-> |
5 |
Book Value per Share |
106.19% |
|
Leverage (A/BK) |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
20.24 |
0.00 |
0.00 |
0.00 |
8.34 |
5.34 |
0.00 |
0.00 |
|
0.00 |
<-Median-> |
10 |
A/BV |
|
|
Debt/Equity Ratio |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
17.40 |
0.00 |
0.00 |
0.00 |
7.35 |
4.34 |
0.00 |
0.00 |
|
0.00 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
|
Sharerholders
Equity (Assets less liabilities) |
|
|
|
|
|
|
|
P/BV |
10 yr Med |
0.00 |
5 yr Med |
0.00 |
|
0.00% |
Diff M/C |
|
0.00 |
Historical |
|
A/BV |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$38.14 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$65.36 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$552.75 |
<-12 mths |
-17.79% |
|
|
|
|
|
|
|
Total Comprehensive
Income |
$88.9 |
$417.2 |
-$180.3 |
$506.5 |
$161.8 |
-$459.3 |
$75.0 |
$471.5 |
$540.1 |
-$237.4 |
-$304.1 |
-$395.9 |
$672.3 |
|
|
|
|
472.92% |
<-Total Growth |
10 |
Comprehensive Income |
|
|
NCI |
$0.0 |
$0.0 |
-$0.1 |
-$0.7 |
$1.0 |
$3.1 |
$17.9 |
$24.5 |
$24.5 |
-$0.2 |
-$0.1 |
-$0.1 |
-$0.1 |
|
|
|
|
|
|
|
NCI |
|
|
Shareholders |
$88.9 |
$417.2 |
-$180.1 |
$507.2 |
$160.7 |
-$462.4 |
$57.1 |
$447.0 |
$515.7 |
-$237.2 |
-$304.0 |
-$395.7 |
$672.4 |
|
|
|
|
473.25% |
<-Total Growth |
10 |
Comprehensive Income |
|
|
Increase |
0.00% |
369.28% |
-143.18% |
381.53% |
-68.30% |
-387.65% |
112.35% |
682.55% |
15.37% |
-146.00% |
-28.16% |
-30.16% |
269.91% |
|
|
|
|
-28.16% |
<-Median-> |
5 |
Comprehensive Income |
|
|
5 Yr Running Average |
|
|
$100.7 |
$184.4 |
$198.8 |
$88.5 |
$16.5 |
$141.9 |
$143.6 |
$64.0 |
$95.7 |
$5.1 |
$50.2 |
|
|
|
|
#NUM! |
<-IRR #YR-> |
10 |
Comprehensive Income |
473.25% |
|
ROE |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
633.8% |
0.0% |
0.0% |
0.0% |
345.5% |
|
|
|
|
8.51% |
<-IRR #YR-> |
5 |
Comprehensive Income |
42.59% |
|
5Yr Median |
|
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
|
|
|
|
-6.73% |
<-IRR #YR-> |
10 |
5 Yr Running Average |
-100.00% |
|
% Difference from NI |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
1.3% |
0.0% |
0.0% |
0.0% |
-0.9% |
|
|
|
|
-18.76% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
-64.62% |
|
Median Values |
|
|
|
|
|
|
|
|
|
Diff |
5, 10 yr |
0.0% |
0.0% |
|
|
|
|
0.0% |
<-Median-> |
5 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$180.1 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$672.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$447.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$672.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$100.7 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$50.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$141.9 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$50.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow/Debt |
0.09 |
0.09 |
0.07 |
0.06 |
0.10 |
0.05 |
0.10 |
0.11 |
0.04 |
-0.03 |
-0.03 |
0.03 |
-0.02 |
0.04 |
|
|
|
0.05 |
<-Median-> |
10 |
CF/Debt |
|
|
Debt/Cash Flow |
11.73 |
11.57 |
14.16 |
16.99 |
10.49 |
20.12 |
10.15 |
9.22 |
22.83 |
-38.59 |
-38.49 |
36.43 |
-40.72 |
23.67 |
|
|
|
10.32 |
<-Median-> |
10 |
CF/Debt |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Liability
Coverage Ratio |
0.19 |
0.21 |
0.18 |
0.15 |
0.18 |
0.16 |
0.18 |
0.26 |
0.24 |
0.10 |
-0.08 |
-0.42 |
-0.02 |
0.00 |
|
|
|
|
|
|
CFO / Current Liabilities |
|
|
5 year Median |
0.54 |
0.22 |
0.21 |
0.19 |
0.18 |
0.18 |
0.18 |
0.18 |
0.18 |
0.18 |
0.18 |
0.10 |
-0.02 |
-0.02 |
|
|
|
-0.02 |
<-Median-> |
5 |
Current Liability Cov Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Asset Efficiency Ratio |
14.32% |
12.06% |
11.41% |
7.27% |
7.78% |
11.55% |
13.52% |
14.92% |
12.81% |
5.75% |
-7.41% |
-61.80% |
-0.94% |
0.00% |
|
|
|
|
|
|
CFO / Total Assets |
|
|
5 year Median |
27.94% |
20.86% |
14.32% |
12.06% |
11.41% |
11.41% |
11.41% |
11.55% |
12.81% |
12.81% |
12.81% |
5.75% |
-0.94% |
-0.94% |
|
|
|
-0.9% |
<-Median-> |
5 |
Return on Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Assets ROA |
17.1% |
32.4% |
-8.2% |
34.7% |
8.3% |
-34.4% |
5.2% |
36.1% |
30.9% |
-14.9% |
-25.5% |
-36.8% |
41.8% |
29.5% |
|
|
|
Net |
Income/Assets |
|
Return on Assets |
|
|
5Yr Median |
17.1% |
21.5% |
17.1% |
17.1% |
17.1% |
8.3% |
5.2% |
8.3% |
8.3% |
5.2% |
5.2% |
-14.9% |
-14.9% |
-14.9% |
|
|
|
6.7% |
<-Median-> |
10 |
Asset Efficiency Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Equity ROE |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
625.92% |
0.00% |
0.00% |
0.00% |
348.69% |
0.00% |
|
|
|
Net Inc/ |
Shareholders' equity |
|
Return on Equity |
|
|
5Yr Median |
35.11% |
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.0% |
<-Median-> |
10 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$563.79 |
<-12 mths |
-16.91% |
|
|
|
|
|
|
|
Basic EPS |
|
|
|
|
|
|
|
|
|
-$53.60 |
-$67.64 |
-$11.78 |
$13.87 |
|
|
|
|
|
|
|
|
|
|
Diluted EPS |
|
|
|
|
|
|
|
|
|
-$41.80 |
-$52.78 |
-$11.63 |
$14.11 |
|
|
|
|
|
|
|
|
|
|
Net Income |
$235.1 |
$517.3 |
-$126.6 |
$529.7 |
$136.9 |
-$443.7 |
$82.5 |
$470.9 |
$518.6 |
-$242.4 |
-$309.7 |
-$402.3 |
$678.5 |
|
|
|
|
|
|
|
|
|
|
NCI |
$3.6 |
$2.0 |
-$0.1 |
-$0.7 |
$1.0 |
$3.1 |
$17.9 |
$24.5 |
$9.3 |
-$0.2 |
-$0.1 |
-$0.1 |
$0.0 |
|
|
|
|
|
|
|
|
|
|
Shareholders |
$231.5 |
$515.3 |
-$126.5 |
$530.3 |
$135.9 |
-$446.8 |
$64.6 |
$446.4 |
$509.3 |
-$242.2 |
-$309.6 |
-$402.1 |
$678.5 |
$563.8 |
<-12 mths |
|
|
636.29% |
<-Total Growth |
10 |
Net Income |
|
|
Increase |
120.90% |
122.62% |
-124.55% |
519.14% |
-74.37% |
-428.74% |
114.46% |
591.00% |
14.08% |
-147.57% |
-27.80% |
-29.90% |
268.73% |
-16.91% |
<-12 mths |
|
|
EPS/CF Ratio should not be higher than 1.00 |
|
|
5 Yr Running Average |
-$115.5 |
-$22.8 |
-$66.9 |
$8.6 |
$257.3 |
$121.7 |
$31.5 |
$146.1 |
$141.9 |
$66.3 |
$93.7 |
$0.3 |
$46.8 |
$57.7 |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
10 |
Net Income |
636.29% |
|
Operating Cash Flow |
$158.3 |
$153.4 |
$144.4 |
$98.2 |
$165.4 |
$96.2 |
$187.1 |
$150.5 |
$62.0 |
-$44.5 |
-$44.5 |
$46.3 |
-$35.1 |
$65.6 |
<-12 mths |
|
|
8.73% |
<-IRR #YR-> |
5 |
Net Income |
52.00% |
|
Investment Cash Flow |
-$37.5 |
-$318.8 |
-$318.8 |
-$162.8 |
-$113.2 |
$133.6 |
-$6.4 |
-$58.2 |
-$21.1 |
-$47.8 |
-$20.9 |
-$6.9 |
$30.2 |
-$6.9 |
<-12 mths |
|
|
#NUM! |
<-IRR #YR-> |
10 |
5 Yr Running Ave. |
169.93% |
|
Total Accruals |
$110.7 |
$680.8 |
$47.9 |
$595.0 |
$83.8 |
-$676.6 |
-$116.1 |
$354.1 |
$468.3 |
-$150.0 |
-$244.2 |
-$441.5 |
$683.4 |
$505.1 |
<-12 mths |
|
|
-20.37% |
<-IRR #YR-> |
5 |
5 Yr Running Ave. |
-67.99% |
|
Total Assets |
$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,646.8 |
$1,626.5 |
$1,215.8 |
$1,091.8 |
$1,623.8 |
$1,911.4 |
<-12 mths |
|
|
|
Balance Sheet |
|
Assets |
|
|
Accruals Ratio |
8.18% |
42.86% |
3.11% |
38.92% |
5.10% |
-52.16% |
-9.31% |
28.61% |
28.44% |
-9.22% |
-20.09% |
-40.44% |
42.09% |
26.43% |
<-12 mths |
|
|
-9.22% |
<-Median-> |
5 |
Ratio |
|
|
EPS/CF Ratio |
1.24 |
2.67 |
-0.72 |
4.70 |
1.26 |
-3.92 |
0.38 |
1.93 |
1.84 |
-2.69 |
3.57 |
0.84 |
-43.75 |
#DIV/0! |
<-12 mths |
|
|
1.05 |
<-Median-> |
10 |
EPS/CF Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$126.5 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$678.5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$446.4 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$678.5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
$66.9 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$46.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$146.1 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$46.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chge in Close |
34.91% |
8.25% |
-10.85% |
-51.67% |
33.28% |
-33.41% |
30.41% |
8.16% |
-31.86% |
-20.39% |
-84.33% |
-91.25% |
-44.88% |
-81.42% |
0.00% |
0.00% |
|
|
Count |
22 |
Years of data |
|
|
up/down/neutral |
up |
down |
down |
|
down |
down |
up |
up |
down |
down |
up |
down |
up |
down |
|
|
|
|
Count |
17 |
77.27% |
|
|
Any Predictions? |
Yes |
|
yes |
|
|
Yes |
Yes |
Yes |
Yes |
Yes |
|
Yes |
|
|
|
|
|
% right |
Count |
9 |
52.94% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financial Cash Flow |
-$115.9 |
$203.9 |
$203.9 |
$52.8 |
-$66.4 |
-$176.4 |
-$128.2 |
-$160.8 |
-$50.9 |
$53.3 |
$53.3 |
$175.1 |
-$39.4 |
|
|
|
|
|
C F Statement |
|
Financial CF |
|
|
Total Accruals |
$226.6 |
$477.0 |
-$155.9 |
$542.2 |
$150.1 |
-$500.1 |
$12.1 |
$514.9 |
$519.2 |
-$203.3 |
-$297.6 |
-$616.6 |
$722.8 |
|
|
|
|
|
|
|
Accruals |
|
|
Accruals Ratio |
16.75% |
30.02% |
-10.11% |
35.46% |
9.14% |
-38.55% |
0.97% |
41.59% |
31.53% |
-12.50% |
-24.48% |
-56.47% |
44.51% |
|
|
|
|
-12.50% |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash |
|
$97.63 |
$53.22 |
$38.50 |
$20.40 |
$78.81 |
$127.60 |
$57.38 |
$48.86 |
$9.93 |
$9.93 |
$215.99 |
$128.49 |
$223.59 |
|
|
|
|
|
|
Cash |
|
|
Cash per Share |
|
$23.52 |
$12.88 |
$8.94 |
$4.68 |
$17.75 |
$28.61 |
$12.88 |
$10.87 |
$2.19 |
$2.16 |
$4.49 |
$2.67 |
$4.65 |
|
|
|
$2.67 |
<-Median-> |
5 |
Cash per Share |
|
|
Percentage of Stock
Price |
|
4.60% |
2.83% |
4.06% |
1.60% |
9.08% |
11.23% |
4.67% |
5.79% |
1.46% |
9.22% |
219.14% |
236.51% |
2214.55% |
|
|
|
9.22% |
<-Median-> |
5 |
% of Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Notes: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 4,
2022. Last estimates were for 2022 and
2023 of -$6.48 and $1.02 fpr EPS. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
June 4,
2021. Just Energy went to the TSX
Venture Exchange as JE.H and From NYSE to OTC as JENGQ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 6,
2020. Last estimates were for 2020,
and 2021 of $3153M, $2880M, $0.42 and $0.62 for EPS, $0.47 for CFPS for 2020. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September 7,
2019. Last estimates were for 2019 and
2020 of $4054M and $4319M, $0.91 for FFO for 2019, $0.61 and $0.66 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.98 for CFPS for 2019 and $106M and $124M
for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September
10, 2018. Last estimates were for
2018, 2019 and 2020 of $3881M, $4054M and $4319M for Revenue, $0.91 and $1.05
for DI for 2018 and 2019, |
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.00, $0.61
andd $0.66 for EPS, $0.98 and $1.02 for CFPS for 2018 and 2019 and $164M,
$106M and $124M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 Income 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
Group Inc is a retail energy provider specializing in electricity and natural
gas commodities and bringing energy-efficient solutions and renewable
energy |
|
|
|
|
|
|
|
|
|
|
|
|
|
options to customers.
Geographically, the company is operating in the
United States and Canada, Just Energy serves residential and commercial
customers. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*all updated re consolidation. |
|
|
|
|
|
|
|
|
|
|
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 |
2014 |
Sep 20 |
2015 |
Sep 15 |
2016 |
Sep 13 |
2017 |
Sep 10 |
2018 |
Sep 7 |
2019 |
Sep 6 |
2020 |
Aug 29 |
2021 |
|
|
Sep 4 |
2022 |
|
|
|
|
Gahn, Robert Scott |
|
|
|
|
|
|
|
0.000 |
0.01% |
0.000 |
0.01% |
0.000 |
0.00% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
Was listed as Director, |
0.00% |
|
CEO - Shares - Amount |
|
|
|
|
|
|
|
|
$0.054 |
|
$0.009 |
|
$0.001 |
|
$0.000 |
|
|
|
$0.000 |
|
now CEO 2019 |
|
|
Options - percentage |
|
|
|
|
|
|
|
0.002 |
0.04% |
0.001 |
0.02% |
0.001 |
0.00% |
0.107 |
0.22% |
|
|
0.107 |
0.22% |
|
|
0.00% |
|
Options - amount |
|
|
|
|
|
|
|
|
$0.240 |
|
$0.017 |
|
$0.002 |
|
$0.120 |
|
|
|
$0.022 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Carter, Michael |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.017 |
0.03% |
|
|
0.017 |
0.03% |
|
|
0.00% |
|
Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.019 |
|
|
|
$0.003 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.080 |
0.17% |
|
|
0.080 |
0.17% |
|
|
0.00% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.090 |
|
|
|
$0.017 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Brown, James |
|
|
|
|
|
|
|
0.001 |
0.03% |
0.007 |
0.15% |
0.007 |
0.01% |
0.027 |
0.06% |
|
|
0.027 |
0.06% |
|
CFO in 2021 |
0.00% |
|
Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
$0.209 |
|
$0.158 |
|
$0.015 |
|
$0.031 |
|
|
|
$0.006 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
0.002 |
0.04% |
0.003 |
0.06% |
0.003 |
0.01% |
0.100 |
0.21% |
|
|
0.100 |
0.21% |
|
|
0.00% |
|
Options - amount |
|
|
|
|
|
|
|
|
$0.251 |
|
$0.068 |
|
$0.006 |
|
$0.113 |
|
|
|
$0.021 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Summers, Elizabeth |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CFO - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Davids, Jonah |
0.00% |
0.000 |
0.01% |
0.001 |
0.02% |
0.002 |
0.03% |
0.002 |
0.04% |
0.003 |
0.07% |
0.004 |
0.01% |
0.007 |
0.01% |
|
|
0.007 |
0.01% |
|
|
0.00% |
|
Officer - Shares -
Amount |
$0.043 |
|
$0.074 |
|
$0.205 |
|
$0.229 |
|
$0.274 |
|
$0.077 |
|
$0.007 |
|
$0.008 |
|
|
|
$0.001 |
|
|
|
|
Options - percentage |
0.03% |
0.001 |
0.03% |
0.001 |
0.03% |
0.001 |
0.03% |
0.002 |
0.05% |
0.003 |
0.06% |
0.003 |
0.01% |
0.100 |
0.21% |
|
|
0.100 |
0.21% |
|
|
0.00% |
|
Options - amount |
$0.281 |
|
$0.321 |
|
$0.371 |
|
$0.203 |
|
$0.335 |
|
$0.065 |
|
$0.006 |
|
$0.113 |
|
|
|
$0.021 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ross, Dallas H. |
|
|
|
|
|
|
|
|
|
|
|
0.003 |
0.01% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
0.00% |
|
Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.006 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
0.001 |
0.00% |
0.032 |
0.07% |
|
|
0.051 |
0.11% |
|
|
57.26% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.003 |
|
$0.036 |
|
|
|
$0.011 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Schaefer, Stephen |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.020 |
0.04% |
|
|
0.020 |
0.04% |
|
I listed him a Chair 2021 |
0.00% |
|
Director - Shares - Amt |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.023 |
|
|
|
$0.004 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.034 |
0.07% |
|
|
0.034 |
0.07% |
|
|
0.00% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.038 |
|
|
|
$0.007 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Horton, Anthony |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.012 |
0.03% |
|
|
0.012 |
0.03% |
|
|
0.00% |
|
Chairman - Shares - Amt |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.014 |
|
|
|
$0.003 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.034 |
0.07% |
|
|
0.034 |
0.07% |
|
|
0.00% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.038 |
|
|
|
$0.007 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Increase in O/S Shares |
0.38% |
0.067 |
1.50% |
0.019 |
0.43% |
0.021 |
0.46% |
0.050 |
1.10% |
0.036 |
0.80% |
0.061 |
1.33% |
0.092 |
2.00% |
|
|
0.000 |
0.00% |
|
Yes 0 in 2022 |
|
|
due to SO |
$4.893 |
|
$13.047 |
|
$3.698 |
|
$5.676 |
|
$7.443 |
|
$5.444 |
|
$1.433 |
|
$2.152 |
|
|
|
$0.000 |
|
|
|
|
Book Value |
$7.240 |
|
$26.272 |
|
$6.011 |
|
$7.191 |
|
$11.954 |
|
$9.483 |
|
$11.326 |
|
$0.929 |
|
|
|
$0.000 |
|
|
|
|
Insider Buying |
|
|
-$0.223 |
|
-$0.079 |
|
$0.000 |
|
-$0.512 |
|
-$0.591 |
|
$0.000 |
|
-$0.237 |
|
|
|
$0.000 |
|
No Buying, Selling 2020 |
|
|
Insider Selling |
|
|
$0.358 |
|
$0.000 |
|
$0.235 |
|
$0.192 |
|
$0.056 |
|
$0.000 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
Net Insider Selling |
$0.105 |
|
$0.134 |
|
-$0.079 |
|
$0.235 |
|
-$0.321 |
|
-$0.535 |
|
$0.000 |
|
-$0.237 |
|
|
|
$0.000 |
|
|
|
|
% of Market Cap |
0.01% |
|
0.01% |
|
-0.01% |
|
0.03% |
|
-0.05% |
|
-0.50% |
|
0.00% |
|
-0.24% |
|
|
|
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Directors |
|
11 |
|
10 |
|
9 |
|
10 |
|
6 |
|
5 |
|
6 |
|
|
|
7 |
|
|
|
|
|
Women |
11% |
2 |
18% |
2 |
20% |
2 |
22% |
2 |
20% |
1 |
17% |
0 |
0% |
1 |
17% |
|
|
1 |
14% |
|
|
|
|
Minorities |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
|
|
0 |
0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Institutions/Holdings |
28.13% |
|
|
135 |
33.00% |
139 |
33.00% |
128 |
29.81% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Shares Held |
912.04% |
|
|
48.578 |
1090.43% |
52.640 |
1170.61% |
44.491 |
981.44% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Increase/Decrease 3
Mths |
-0.27% |
|
|
3.363 |
7.44% |
0.585 |
1.12% |
-4.647 |
-9.46% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Starting No. of Shares |
|
|
|
45.215 |
|
52.055 |
|
49.138 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Institutions/Holdings
Top 20 |
28.13% |
|
|
|
|
|
|
|
|
20 |
|
20 |
27.58% |
20 |
29.30% |
|
|
5 |
90.00% |
|
|
|
|
Total Shares Held |
912.04% |
|
|
|
|
|
|
|
|
1.484 |
32.31% |
1.265 |
27.54% |
16.838 |
35.02% |
|
|
0.434 |
0.90% |
|
|
|
|
Increase/Decrease 3
Mths |
-0.27% |
|
|
|
|
|
|
|
|
0.022 |
1.48% |
-0.069 |
-5.19% |
5.632 |
50.26% |
|
|
-0.109 |
-20.12% |
|
|
|
|
Starting No. of Shares |
|
|
|
|
|
|
|
|
|
1.463 |
|
1.335 |
Top 20 MS |
11.205 |
Top 20 MS |
|
|
0.543 |
Top 20 MS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright ©
2008 Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|