| 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/ |
|
Q2 2017 |
|
|
|
|
|
|
|
|
| EnerCare Inc. |
|
|
TSX: |
ECI |
OTC: |
CSUWF |
http://www.enercare.ca |
|
|
Fiscal Yr: |
Dec 31 |
|
|
|
|
|
|
|
|
|
|
| Year |
12/31/05 |
12/31/06 |
12/31/07 |
12/31/08 |
12/31/09 |
12/31/10 |
12/31/11 |
12/31/12 |
12/31/13 |
12/31/14 |
12/31/15 |
12/31/16 |
12/31/17 |
12/31/18 |
12/31/19 |
|
Value |
Description |
#Y |
Item |
Total G |
| Accounting Rules |
|
|
|
|
|
C GAAP |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
|
|
|
|
Accounting Rules |
|
| Nov/Dec only |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Nov/Dec only |
|
| Nov/Dec 02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Nov/Dec 02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1,229.1 |
<-12 mths |
23.41% |
|
|
|
|
|
|
| Revenue* |
$149.39 |
$156.70 |
$166.7 |
$180.5 |
$188.2 |
$207.4 |
$244.5 |
$256.6 |
$299.1 |
$362.8 |
$563.8 |
$995.9 |
$1,267 |
$1,320 |
$1,384 |
|
535.58% |
<-Total Growth |
10 |
Revenue |
|
| Increase |
4.55% |
4.89% |
6.39% |
8.29% |
4.23% |
10.23% |
17.88% |
4.94% |
16.59% |
21.26% |
55.43% |
76.64% |
27.22% |
4.18% |
4.85% |
|
20.31% |
<-IRR #YR-> |
10 |
Revenue |
535.58% |
| 5 year Running Average |
|
$125.3 |
$150.7 |
$159.2 |
$168.3 |
$179.9 |
$197.5 |
$215.4 |
$239.2 |
$274.1 |
$345.4 |
$495.7 |
$697.7 |
$901.9 |
$1,106.2 |
|
32.43% |
<-IRR #YR-> |
5 |
Revenue |
307.34% |
| Revenue per Share |
$3.02 |
$3.16 |
$3.37 |
$3.65 |
$3.80 |
$3.79 |
$4.35 |
$4.42 |
$5.12 |
$3.95 |
$6.41 |
$9.56 |
$12.16 |
$12.67 |
$13.29 |
|
14.15% |
<-IRR #YR-> |
9 |
5 yr Running Average |
295.71% |
| Increase |
4.55% |
4.89% |
6.39% |
8.29% |
4.23% |
-0.25% |
14.79% |
1.67% |
15.77% |
-22.89% |
62.38% |
49.16% |
27.22% |
4.18% |
4.85% |
|
20.21% |
<-IRR #YR-> |
5 |
5 yr Running Average |
151.01% |
| 5 year Running Average |
|
$2.53 |
$3.04 |
$3.22 |
$3.40 |
$3.55 |
$3.79 |
$4.00 |
$4.30 |
$4.33 |
$4.85 |
$5.89 |
$7.44 |
$8.95 |
$10.82 |
|
11.69% |
<-IRR #YR-> |
10 |
Revenue Per share |
202.21% |
| P/S (Price/Sales) Median |
5.04 |
4.50 |
4.62 |
3.17 |
1.77 |
1.48 |
1.81 |
2.06 |
1.77 |
3.18 |
2.30 |
1.80 |
|
|
|
|
17.06% |
<-IRR #YR-> |
5 |
Revenue Per share |
119.80% |
| P/S (Price/Sales) Close |
5.19 |
4.24 |
4.40 |
2.58 |
1.10 |
1.80 |
2.13 |
1.85 |
1.95 |
3.67 |
2.49 |
1.87 |
1.68 |
1.61 |
1.84 |
|
7.62% |
<-IRR #YR-> |
9 |
5 yr Running Average |
132.99% |
| *Revenue in M CDN $ |
|
|
|
|
|
|
|
P/S |
10 yr |
1.93 |
5 yr |
2.06 |
|
-13.09% |
Diff M/C |
|
9.23% |
<-IRR #YR-> |
5 |
5 yr Running Average |
55.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$156.7 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$995.9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$244.5 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$995.9 |
|
|
|
|
|
|
|
|
|
|
|
|
-$150.7 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$495.7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$197.5 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$495.7 |
|
|
|
|
|
|
|
|
|
|
|
-$3.16 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4.35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.56 |
|
|
|
|
|
|
|
|
|
|
|
|
-$3.04 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.89 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.79 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.89 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$130.0 |
<-12 mths |
4.61% |
|
|
|
|
|
|
| Distributable Cash |
$64.74 |
$67.86 |
$64.13 |
$69.26 |
$50.06 |
$54.65 |
$65.19 |
$61.71 |
$51.05 |
$59.93 |
$109.87 |
$124.29 |
|
|
|
|
83.15% |
<-Total Growth |
10 |
FFO |
Div by |
| Increase |
6.67% |
4.82% |
-5.50% |
7.99% |
-27.71% |
9.17% |
19.28% |
-5.35% |
-17.27% |
17.39% |
83.33% |
13.13% |
|
|
|
|
|
|
|
|
|
| Statements M&A say |
|
|
|
|
|
|
|
|
|
|
|
$1.18 |
|
|
|
|
|
|
|
|
|
| Distributable Cash per
share |
$1.31 |
$1.37 |
$1.30 |
$1.40 |
$1.01 |
$1.04 |
$1.18 |
$1.07 |
$0.88 |
$0.92 |
$1.20 |
$1.27 |
$1.25 |
<-12 mths |
|
|
-7.54% |
<-Total Growth |
10 |
FFO |
basic ave |
| Increase |
6.67% |
4.82% |
-5.50% |
7.99% |
-27.71% |
3.01% |
12.86% |
-8.67% |
-18.27% |
4.97% |
30.67% |
5.29% |
-1.28% |
<-12 mths |
|
|
-0.78% |
<-IRR #YR-> |
10 |
FFO |
-7.54% |
| FFO Yield |
8.35% |
10.21% |
8.75% |
14.88% |
24.13% |
15.27% |
12.69% |
13.12% |
8.80% |
6.35% |
7.54% |
7.10% |
6.12% |
<-12 mths |
|
|
1.52% |
<-IRR #YR-> |
5 |
FFO |
7.81% |
| 5 year Running Average |
|
121.97% |
126.63% |
131.94% |
127.65% |
122.33% |
118.43% |
113.99% |
103.57% |
101.77% |
105.01% |
106.84% |
110.39% |
<-12 mths |
|
|
-1.87% |
<-IRR #YR-> |
9 |
5 yr Running Average |
-12.41% |
| Payout Ratio |
85.90% |
86.91% |
98.84% |
92.24% |
111.72% |
62.22% |
55.13% |
62.32% |
77.97% |
74.28% |
69.80% |
70.16% |
76.03% |
<-12 mths |
|
|
-2.04% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-9.78% |
| 5 year Running Average |
|
77.47% |
90.20% |
90.21% |
94.22% |
90.55% |
84.37% |
76.93% |
72.97% |
65.50% |
67.14% |
70.50% |
73.34% |
<-12 mths |
|
|
80.65% |
<-Median-> |
10 |
Payout 5 yr Running Average |
|
| Price/FFO Median |
11.62 |
10.39 |
12.02 |
8.26 |
6.66 |
5.40 |
6.70 |
8.48 |
10.32 |
13.65 |
12.24 |
13.60 |
15.73 |
<-12 mths |
|
|
9.40 |
<-Median-> |
10 |
P/FFO Med |
|
| Price/FFO High |
13.35 |
12.17 |
13.99 |
11.06 |
9.94 |
6.65 |
8.10 |
9.34 |
11.49 |
16.98 |
13.61 |
15.54 |
17.35 |
<-12 mths |
|
|
11.28 |
<-Median-> |
10 |
P/FFO High |
|
| Price/FFO Low |
9.89 |
8.61 |
10.05 |
5.45 |
3.38 |
4.14 |
5.30 |
7.62 |
9.15 |
10.32 |
10.86 |
11.66 |
14.12 |
<-12 mths |
|
|
8.39 |
<-Median-> |
10 |
P/FFO Low |
|
| P/FFO Close |
11.97 |
9.79 |
11.43 |
6.72 |
4.14 |
6.55 |
7.88 |
7.62 |
11.36 |
15.75 |
13.26 |
14.08 |
16.35 |
<-12 mths |
|
|
9.62 |
<-Median-> |
10 |
P/FFO Close |
|
| Trailing P/FFO Close |
12.77 |
10.26 |
10.80 |
7.26 |
3.00 |
6.75 |
8.89 |
6.96 |
9.29 |
16.53 |
17.33 |
14.83 |
16.14 |
<-12 mths |
|
|
9.09 |
<-Median-> |
10 |
Trailing P/FFO Close |
|
| Median Values |
DPR |
10 Yrs |
72.22% |
5 Yrs |
70.16% |
P/CF |
5 Yrs |
in order |
12.24 |
13.61 |
10.32 |
13.26 |
|
33.61% |
Diff M/C |
|
73.89% |
Diff M/C |
10 |
DPR 75% to 95% best |
|
| * Funds From Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.37 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.18 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.27 |
|
|
|
|
|
|
|
|
|
|
|
|
-$1.27 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.18 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.53 |
<-12 mths |
-14.52% |
|
|
|
|
|
|
| EPS Basic |
$0.44 |
$0.91 |
$0.37 |
$0.39 |
$0.44 |
$0.01 |
$0.07 |
-$0.06 |
$0.15 |
$0.34 |
$0.56 |
$0.62 |
|
|
|
|
-32.17% |
<-Total Growth |
10 |
EPS Basic |
|
| Nov/Dec 02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| EPS Diluted* |
$0.44 |
$0.91 |
$0.37 |
$0.39 |
$0.44 |
$0.01 |
$0.07 |
-$0.06 |
$0.15 |
$0.34 |
$0.56 |
$0.62 |
$0.58 |
$0.78 |
$0.97 |
|
-32.17% |
<-Total Growth |
10 |
EPS Diluted |
|
| Increase |
39.56% |
107.26% |
-59.63% |
6.78% |
11.68% |
-97.73% |
600.00% |
-185.71% |
-350.00% |
126.67% |
64.71% |
10.71% |
-6.45% |
34.48% |
24.36% |
|
-3.81% |
<-IRR #YR-> |
10 |
Earnings per Share |
-32.17% |
| Earnings Yield |
2.8% |
6.8% |
2.5% |
4.2% |
10.5% |
0.1% |
0.8% |
-0.7% |
1.5% |
2.3% |
3.5% |
3.5% |
2.8% |
3.8% |
4.0% |
|
54.69% |
<-IRR #YR-> |
5 |
Earnings per Share |
785.71% |
| 5 year Running Average |
|
$0.20 |
$0.26 |
$0.49 |
$0.51 |
$0.43 |
$0.26 |
$0.17 |
$0.12 |
$0.10 |
$0.21 |
$0.32 |
$0.45 |
$0.58 |
$0.70 |
|
4.95% |
<-IRR #YR-> |
10 |
5 yr Running Average |
62.13% |
| 10 year Running Average |
|
|
|
|
|
|
$0.23 |
$0.21 |
$0.30 |
$0.31 |
$0.32 |
$0.29 |
$0.31 |
$0.35 |
$0.40 |
|
4.65% |
<-IRR #YR-> |
5 |
5 yr Running Average |
25.49% |
| * Diluted ESP per
share |
|
|
|
|
|
|
|
E/P |
10 Yrs |
2.42% |
5Yrs |
2.34% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.91 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.07 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.62 |
|
|
|
|
|
|
|
|
|
|
|
-$0.20 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.32 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.26 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.32 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Special Dividends |
$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 |
|
| Nov/Dec 02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends |
|
| Dividend* |
$1.12 |
$1.19 |
$1.28 |
$1.29 |
$1.13 |
$0.65 |
$0.65 |
$0.67 |
$0.68 |
$0.68 |
$0.84 |
$0.89 |
$0.95 |
$0.96 |
$0.96 |
|
-25.36% |
<-Total Growth |
10 |
Dividends |
|
| Increase |
5.25% |
6.06% |
7.47% |
0.78% |
-12.44% |
-42.63% |
0.00% |
3.24% |
2.24% |
0.00% |
22.81% |
5.83% |
6.97% |
0.95% |
0.00% |
|
|
Count |
15 |
Years of data |
|
| Dividends 5 Yr Running |
|
$0.95 |
$1.14 |
$1.19 |
$1.20 |
$1.11 |
$1.00 |
$0.88 |
$0.76 |
$0.67 |
$0.71 |
$0.75 |
$0.81 |
$0.86 |
$0.92 |
|
-34.06% |
<-Total Growth |
10 |
Dividends 5 Yr Running |
|
| Adjusted Yield H/L Price |
3.71% |
4.20% |
4.13% |
5.61% |
8.42% |
11.53% |
8.23% |
7.35% |
7.55% |
5.44% |
5.70% |
5.16% |
4.83% |
494.51% |
#DIV/0! |
|
|
|
|
|
|
| Yield H/L Price |
7.39% |
8.36% |
8.22% |
11.17% |
16.77% |
11.53% |
8.23% |
7.35% |
7.55% |
5.44% |
5.70% |
5.16% |
4.83% |
|
|
|
7.89% |
<-Median-> |
10 |
Yield H/L Price |
|
| Adjusted Yield on High
Price |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
9.35% |
6.81% |
6.67% |
6.79% |
4.37% |
5.13% |
4.51% |
4.38% |
|
|
|
|
|
|
|
|
| Yield on High Price |
6.44% |
7.14% |
7.06% |
8.34% |
11.24% |
9.35% |
6.81% |
6.67% |
6.79% |
4.37% |
5.13% |
4.51% |
4.38% |
|
|
|
6.80% |
<-Median-> |
10 |
Yield on High
Price |
|
| Adjusted Yield on Low Price |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
15.03% |
10.40% |
8.18% |
8.52% |
7.20% |
6.43% |
6.01% |
5.39% |
|
|
|
|
|
|
|
|
| Yield on Low Price |
8.69% |
10.09% |
9.84% |
16.93% |
33.03% |
15.03% |
10.40% |
8.18% |
8.52% |
7.20% |
6.43% |
6.01% |
5.39% |
|
|
|
9.18% |
<-Median-> |
10 |
Yield on Low Price |
|
| Adjusted Yield on Close Price |
3.60% |
4.46% |
4.34% |
6.89% |
13.54% |
9.50% |
7.00% |
8.18% |
6.86% |
4.72% |
5.26% |
4.98% |
4.65% |
|
|
|
|
|
|
|
|
| Yield on Close Price |
7.18% |
8.87% |
8.65% |
13.72% |
26.96% |
9.50% |
7.00% |
8.18% |
6.86% |
4.72% |
5.26% |
4.98% |
4.65% |
4.69% |
3.93% |
|
7.59% |
<-Median-> |
10 |
Yield on Close Price |
|
| Payout Ratio EPS |
254.65% |
130.31% |
346.88% |
327.41% |
256.70% |
6480.00% |
925.71% |
-1115.00% |
456.00% |
201.18% |
150.00% |
143.39% |
163.97% |
123.08% |
98.97% |
|
292.06% |
<-Median-> |
10 |
DPR EPS |
|
| DPR EPS 5 Yr Running |
|
475.83% |
442.71% |
244.49% |
235.09% |
260.39% |
389.36% |
513.41% |
619.43% |
653.53% |
332.55% |
233.91% |
179.91% |
150.14% |
131.05% |
|
360.95% |
<-Median-> |
10 |
DPR EPS 5 Yr Running |
|
| Payout Ratio CFPS |
49.46% |
49.21% |
50.11% |
49.64% |
44.17% |
29.59% |
28.47% |
40.39% |
34.29% |
43.16% |
45.08% |
56.24% |
46.17% |
38.71% |
#DIV/0! |
|
43.66% |
<-Median-> |
10 |
DPR CF |
|
| DPR CF 5 Yr Running |
|
51.99% |
50.11% |
49.85% |
48.49% |
44.95% |
41.03% |
38.87% |
35.40% |
34.35% |
37.60% |
43.39% |
46.26% |
49.42% |
#DIV/0! |
|
42.21% |
<-Median-> |
10 |
DPR CF 5 Yr Running |
|
| Payout Ratio CFPS WC |
48.96% |
48.75% |
50.47% |
47.52% |
46.79% |
29.56% |
29.91% |
34.78% |
37.08% |
51.94% |
38.98% |
50.80% |
46.17% |
38.71% |
#DIV/0! |
|
42.88% |
<-Median-> |
10 |
DPR CF WC |
|
| DPR CF WC 5 Yr Running |
|
52.08% |
49.63% |
49.05% |
48.49% |
45.03% |
41.55% |
38.42% |
35.85% |
35.29% |
37.47% |
41.89% |
44.35% |
44.29% |
#DIV/0! |
|
41.72% |
<-Median-> |
10 |
DPR CF WC 5 Yr Running |
|
| Median Values |
|
|
|
5 Yr Med |
5 Yr Cl |
5.70% |
5.26% |
5 Yr Med |
Payout |
150.00% |
43.16% |
38.98% |
|
|
|
|
-2.88% |
<-IRR #YR-> |
10 |
Dividends |
-25.36% |
| * Dividends per
share |
|
|
|
5 Yr Med |
and Cur. |
-17.71% |
-10.81% |
Last Div Inc ---> |
$0.077 |
$0.080 |
3.9% |
|
|
|
|
6.53% |
<-IRR #YR-> |
5 |
Dividends |
37.19% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7.37% |
<-IRR #YR-> |
4 |
Dividends |
|
|
|
-$1.19 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.89 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.65 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.89 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.67 |
$0.00 |
$0.00 |
$0.00 |
$0.89 |
|
|
|
|
|
|
|
|
|
| Historical Dividends |
|
Historical |
High Div |
23.37% |
Low Div |
3.80% |
Ave Div |
13.59% |
Med Div |
7.55% |
Close Div |
7.18% |
|
|
|
|
|
|
|
Historical Dividends |
|
| High/Ave/Median Values |
|
Curr diff |
Exp. |
-79.91% |
Cheap |
23.54% |
Exp. |
-65.44% |
Exp. |
-37.82% |
Exp. |
-34.58% |
|
|
|
|
|
|
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Adjusted Historical
Dividends |
|
Historical |
High Div |
12.25% |
Low Div |
0.00% |
Ave Div |
6.13% |
Med Div |
5.44% |
Close Div |
4.98% |
|
|
|
|
Decrease |
49.77% |
|
Adjusted Historical Dividends |
| High/Ave/Median Values |
|
Curr diff |
Exp. |
-51.35% |
Exp |
5.97% |
Exp. |
-33.32% |
Exp. |
-28.11% |
Exp. |
-22.56% |
|
|
|
|
|
50.23% |
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Adjusted Historical
Dividends |
|
Historical |
High Div |
9.65% |
Low Div |
4.43% |
Ave Div |
7.04% |
Med Div |
6.53% |
Close Div |
6.06% |
|
|
|
|
From 2011 |
After Div dec |
|
Adjusted Historical Dividends |
| High/Ave/Median Values |
|
Curr diff |
Exp. |
-51.35% |
Exp |
5.97% |
Exp. |
-33.32% |
Exp. |
-28.11% |
Exp. |
-22.56% |
|
|
|
|
|
|
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Div Yd |
5.99% |
earning in |
5.00 |
Years |
at IRR of |
5.00% |
Div Inc. |
27.63% |
|
|
|
|
|
|
|
|
|
| Future Div Yield |
|
|
|
Div Yd |
7.65% |
earning in |
10.00 |
Years |
at IRR of |
5.00% |
Div Inc. |
62.89% |
|
|
|
|
|
|
|
Future Div Yield |
|
| Future Div Yield |
|
|
|
Div Yd |
9.76% |
earning in |
15.00 |
Years |
at IRR of |
5.00% |
Div Inc. |
107.89% |
|
|
|
|
|
|
|
Future Div Yield |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| H/LYield held 5 yrs |
|
|
12.80% |
10.79% |
7.75% |
4.27% |
4.55% |
4.30% |
5.92% |
10.16% |
14.95% |
11.29% |
10.44% |
10.60% |
7.64% |
|
8.95% |
<-Median-> |
10 |
Paid Median Price |
|
| H/LYield held 10 yrs |
|
|
|
|
|
|
|
6.69% |
5.72% |
4.69% |
5.53% |
6.24% |
6.11% |
8.32% |
14.25% |
|
5.72% |
<-Median-> |
5 |
Paid Median Price |
|
| H/LYield held 15 yrs |
|
|
|
|
|
|
|
|
|
|
|
|
9.51% |
8.03% |
6.58% |
|
#NUM! |
<-Median-> |
0 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cost cover if held 5
years |
|
|
57.11% |
49.80% |
41.24% |
36.46% |
35.08% |
28.17% |
32.73% |
49.49% |
62.72% |
47.82% |
44.46% |
47.75% |
36.60% |
|
44.53% |
<-Median-> |
10 |
Paid Median Price |
|
| Cost cover if held 10
years |
|
|
|
|
|
|
|
100.96% |
81.42% |
64.10% |
59.67% |
61.53% |
54.18% |
70.18% |
117.79% |
|
64.10% |
<-Median-> |
5 |
Paid Median Price |
|
| Cost cover if held 15
years |
|
|
|
|
|
|
|
|
|
|
|
|
141.44% |
117.60% |
95.66% |
|
#NUM! |
<-Median-> |
0 |
Paid Median Price |
|
| Cost cover if held 20
years |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#DIV/0! |
|
#NUM! |
<-Median-> |
0 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Graham No. |
$7.94 |
$11.19 |
$6.55 |
$5.80 |
$5.75 |
$0.81 |
$1.86 |
$1.61 |
$2.03 |
$6.31 |
$7.47 |
$9.09 |
$8.63 |
$10.01 |
$11.16 |
|
-18.77% |
<-Total Growth |
10 |
Graham Price |
|
| Price/GP Ratio Med |
1.91 |
1.27 |
2.38 |
1.99 |
1.17 |
6.92 |
4.23 |
5.65 |
4.46 |
1.99 |
1.97 |
1.90 |
2.28 |
|
|
|
2.18 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Price/GP Ratio High |
2.20 |
1.49 |
2.77 |
2.67 |
1.75 |
8.53 |
5.12 |
6.22 |
4.97 |
2.48 |
2.19 |
2.17 |
2.51 |
|
|
|
2.72 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Price/GP Ratio Low |
1.63 |
1.05 |
1.99 |
1.31 |
0.59 |
5.31 |
3.35 |
5.08 |
3.96 |
1.51 |
1.75 |
1.63 |
2.05 |
|
|
|
1.87 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Price/GP Ratio Close |
1.97 |
1.20 |
2.26 |
1.62 |
0.73 |
8.40 |
4.98 |
5.08 |
4.91 |
2.30 |
2.14 |
1.96 |
2.37 |
2.04 |
2.19 |
|
2.28 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Prem/Disc Close |
96.99% |
19.97% |
125.93% |
62.01% |
-27.11% |
739.56% |
397.94% |
407.64% |
391.28% |
129.87% |
113.57% |
96.33% |
136.99% |
104.36% |
118.83% |
|
127.90% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Close |
$15.65 |
$13.42 |
$14.80 |
$9.40 |
$4.19 |
$6.82 |
$9.26 |
$8.18 |
$9.97 |
$14.50 |
$15.96 |
$17.84 |
$20.45 |
$20.45 |
$24.42 |
|
32.94% |
<-Total Growth |
10 |
Price Close |
|
| Increase |
2.62% |
-14.25% |
10.28% |
-36.49% |
-55.43% |
62.77% |
35.78% |
-11.66% |
21.88% |
45.44% |
10.07% |
11.78% |
14.63% |
0.00% |
19.41% |
|
2.89% |
<-IRR #YR-> |
10 |
Stock Price |
32.94% |
| P/E |
35.49 |
14.68 |
40.11 |
23.86 |
9.52 |
682.00 |
132.29 |
-136.33 |
66.47 |
42.65 |
28.50 |
28.77 |
35.26 |
26.22 |
25.18 |
|
14.01% |
<-IRR #YR-> |
5 |
Stock Price |
92.66% |
| Trailing P/E |
49.53 |
30.43 |
16.19 |
25.47 |
10.63 |
15.50 |
926.00 |
116.86 |
-166.17 |
96.67 |
46.94 |
31.86 |
32.98 |
35.26 |
31.31 |
|
9.01% |
<-IRR #YR-> |
10 |
Price & Dividend |
|
| Median 10, 5 Yrs |
D. per yr |
6.12% |
6.27% |
% Tot Ret |
67.94% |
30.93% |
|
Price Inc |
11.78% |
P/E: |
34.44 |
28.77 |
|
|
|
|
20.29% |
<-IRR #YR-> |
5 |
Price & Dividend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$13.42 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$17.84 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9.26 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$17.84 |
|
|
|
|
|
|
|
|
|
|
|
-$13.42 |
$1.28 |
$1.29 |
$1.13 |
$0.65 |
$0.65 |
$0.67 |
$0.68 |
$0.68 |
$0.84 |
$18.73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9.26 |
$0.67 |
$0.68 |
$0.68 |
$0.84 |
$18.73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price H/L Median |
$15.19 |
$14.24 |
$15.57 |
$11.55 |
$6.74 |
$5.62 |
$7.88 |
$9.11 |
$9.06 |
$12.57 |
$14.73 |
$17.24 |
$19.68 |
19.41% |
|
|
21.03% |
<-Total Growth |
10 |
Stock Price |
|
| Increase |
4.18% |
-6.25% |
9.30% |
-25.83% |
-41.66% |
-16.56% |
40.12% |
15.62% |
-0.55% |
38.82% |
17.14% |
17.05% |
14.19% |
4.69% |
|
|
-2.15% |
<-IRR #YR-> |
10 |
Stock Price |
21.03% |
| P/E |
34.44 |
15.58 |
42.18 |
29.30 |
15.31 |
562.00 |
112.50 |
-151.75 |
60.37 |
36.97 |
26.29 |
27.80 |
33.93 |
24.11% |
|
|
16.96% |
<-IRR #YR-> |
5 |
Stock Price |
118.86% |
| Trailing P/E |
48.07 |
32.29 |
17.03 |
31.29 |
17.09 |
12.77 |
787.50 |
130.07 |
-150.92 |
83.80 |
43.31 |
30.78 |
31.74 |
|
|
|
7.87% |
<-IRR #YR-> |
10 |
Price & Dividend |
|
| P/E on Run. 5 yr Ave |
|
|
60.33 |
23.72 |
13.16 |
13.21 |
30.69 |
53.31 |
74.22 |
123.24 |
69.46 |
53.52 |
43.73 |
|
|
|
24.02% |
<-IRR #YR-> |
5 |
Price & Dividend |
|
| P/E on Run. 10 yr Ave |
|
|
|
|
|
|
|
42.47 |
29.75 |
40.97 |
46.20 |
59.57 |
63.40 |
|
|
|
34.44 |
P/E Ratio |
|
Historical Median |
|
| Median 10, 5 Yrs |
D. per yr |
10.02% |
7.06% |
% Tot Ret |
127.38% |
29.40% |
|
Price Inc |
17.05% |
P/E: |
33.14 |
27.80 |
|
|
|
|
|
Count |
15 |
Years of data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$14.24 |
$0.00 |
$0.00 |
-$6.74 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$17.24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$7.88 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$17.24 |
|
|
|
|
|
|
|
|
|
|
|
-$14.24 |
$1.28 |
$1.29 |
$1.13 |
$0.65 |
$0.65 |
$0.67 |
$0.68 |
$0.68 |
$0.84 |
$18.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$7.88 |
$0.67 |
$0.68 |
$0.68 |
$0.84 |
$18.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| High Months |
Jul |
Jan |
May |
Feb |
Jan |
Dec |
Dec |
May |
Nov |
Nov |
Nov |
Ict |
May |
|
|
|
|
|
|
|
|
| Price High |
$17.45 |
$16.68 |
$18.12 |
$15.47 |
$10.05 |
$6.93 |
$9.52 |
$10.03 |
$10.08 |
$15.64 |
$16.38 |
$19.69 |
$21.70 |
|
|
|
18.05% |
<-Total Growth |
10 |
Stock Price |
|
| Increase |
5.06% |
-4.41% |
8.63% |
-14.62% |
-35.04% |
-31.04% |
37.37% |
5.36% |
0.50% |
55.16% |
4.73% |
20.21% |
10.21% |
|
|
|
1.67% |
<-IRR #YR-> |
10 |
Stock Price |
18.05% |
| P/E |
39.57 |
18.25 |
49.11 |
39.26 |
22.84 |
693.00 |
136.00 |
-167.17 |
67.20 |
46.00 |
29.25 |
31.76 |
37.41 |
|
|
|
15.64% |
<-IRR #YR-> |
5 |
Stock Price |
106.83% |
| Trailing P/E |
55.22 |
37.82 |
19.82 |
41.92 |
25.51 |
15.75 |
952.00 |
143.29 |
-168.00 |
104.27 |
48.18 |
35.16 |
35.00 |
|
|
|
39.57 |
P/E Ratio |
|
Historical Median |
|
| Median 10, 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
5.36% |
P/E: |
42.63 |
31.76 |
|
|
|
|
122.24 |
P/E Ratio |
|
Historical High |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$16.68 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$19.69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9.52 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$19.69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Low Months |
Oct |
Nov |
Jan |
Oct |
Nov |
Jan |
Mar |
Dec |
Jan |
Feb |
Aug |
Jan |
Jan |
|
|
|
|
|
|
|
|
| Price Low |
$12.93 |
$11.80 |
$13.01 |
$7.62 |
$3.42 |
$4.31 |
$6.23 |
$8.18 |
$8.03 |
$9.50 |
$13.07 |
$14.78 |
$17.66 |
|
|
|
25.25% |
<-Total Growth |
10 |
Stock Price |
|
| Increase |
3.03% |
-8.74% |
10.25% |
-41.43% |
-55.12% |
26.02% |
44.55% |
31.30% |
-1.83% |
18.31% |
37.58% |
13.08% |
19.49% |
|
|
|
2.28% |
<-IRR #YR-> |
10 |
Stock Price |
25.25% |
| P/E |
29.32 |
12.91 |
35.26 |
19.34 |
7.77 |
431.00 |
89.00 |
-136.33 |
53.53 |
27.94 |
23.34 |
23.84 |
30.45 |
|
|
|
18.86% |
<-IRR #YR-> |
5 |
Stock Price |
137.24% |
| Trailing P/E |
40.92 |
26.76 |
14.23 |
20.65 |
8.68 |
9.80 |
623.00 |
116.86 |
-133.83 |
63.33 |
38.44 |
26.39 |
28.48 |
|
|
|
27.94 |
P/E Ratio |
|
Historical Median |
|
| Median 10, 5 Yrs |
|
|
|
|
|
|
|
Price Inc |
18.31% |
P/E: |
25.89 |
23.84 |
|
|
|
|
8.80 |
P/E Ratio |
|
Historical Low |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11.80 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$14.78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6.23 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$14.78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long Term Debt |
|
|
|
|
|
|
|
|
|
$684.95 |
$734.53 |
$967.10 |
$1,020.99 |
|
|
|
|
|
|
Debt |
|
| Change |
|
|
|
|
|
|
|
|
|
|
7.24% |
31.66% |
5.57% |
|
|
|
19.45% |
<-Median-> |
2 |
Change |
|
| Debt/Market Cap Ratio |
|
|
|
|
|
|
|
|
|
0.51 |
0.52 |
0.52 |
0.48 |
|
|
|
0.52 |
<-Median-> |
3 |
% of Market C. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Goodwill &
Intangibles |
|
|
|
|
|
$377.94 |
$334.17 |
$287.57 |
$240.99 |
$734.49 |
$734.49 |
$1,075.76 |
$1,038.08 |
|
|
|
|
Intangibles |
|
Goodwill |
|
| Change |
|
|
|
|
|
|
-11.58% |
-13.95% |
-16.20% |
204.78% |
0.00% |
46.46% |
-3.50% |
|
|
|
-5.79% |
<-Median-> |
6 |
Change |
|
| Intangible/Market Cap
Ratio |
|
|
|
|
|
1.01 |
0.64 |
0.61 |
0.41 |
0.55 |
0.52 |
0.58 |
0.49 |
|
|
|
0.58 |
<-Median-> |
7 |
% of Market C. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Market Cap in $M |
$775.1 |
$664.6 |
$733.0 |
$465.5 |
$207.5 |
$373.3 |
$520.4 |
$474.5 |
$582.5 |
$1,332.3 |
$1,403.7 |
$1,858.1 |
$2,130.0 |
$2,130.0 |
$2,543.5 |
|
179.58% |
<-Total Growth |
10 |
Market Cap |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Diluted # of Shares in
Million |
|
|
|
|
|
|
58.326 |
58.613 |
58.929 |
65.909 |
91.998 |
98.749 |
104.243 |
|
|
|
68.48% |
<-Total Growth |
5 |
Diluted |
|
| Change |
|
|
|
|
|
|
|
0.49% |
0.54% |
11.84% |
39.58% |
7.34% |
5.56% |
|
|
|
0.07 |
<-Median-> |
5 |
Change |
|
| Basic # of Shares in
Millions |
49.52 |
49.52 |
49.52 |
49.52 |
49.52 |
52.48 |
55.47 |
57.486 |
58.190 |
65.077 |
91.299 |
98.091 |
103.944 |
|
|
|
98.08% |
<-Total Growth |
10 |
Average |
|
| Change |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
5.98% |
5.70% |
3.63% |
1.22% |
11.84% |
40.29% |
7.44% |
5.97% |
|
|
|
0.05 |
<-Median-> |
10 |
Change |
|
| Difference |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
4.3% |
1.3% |
0.9% |
0.4% |
41.2% |
-3.7% |
6.2% |
0.2% |
|
|
|
0.01 |
<-Median-> |
10 |
Difference |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$216.92 |
<-12 mths |
19.00% |
|
|
|
|
|
|
| Units |
39.669 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Shares |
|
| Class B Units |
9.855 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Shares |
|
| # of Share in Millions |
49.524 |
49.524 |
49.524 |
49.524 |
49.524 |
54.731 |
56.203 |
58.012 |
58.425 |
91.880 |
87.949 |
104.155 |
104.155 |
104.155 |
104.155 |
|
7.72% |
<-IRR #YR-> |
10 |
Shares |
110.31% |
| Increase |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
10.51% |
2.69% |
3.22% |
0.71% |
57.26% |
-4.28% |
18.43% |
0.00% |
0.00% |
0.00% |
|
13.13% |
<-IRR #YR-> |
5 |
Shares |
85.32% |
| CF fr Op $M |
$112.45 |
$119.86 |
$126.50 |
$128.71 |
$126.65 |
$119.87 |
$127.92 |
$96.09 |
$116.56 |
$145.62 |
$163.89 |
$164.64 |
$214.56 |
$258.30 |
|
|
37.36% |
<-Total Growth |
10 |
Cash Flow |
|
| Increase |
8.43% |
6.59% |
5.53% |
1.75% |
-1.60% |
-5.35% |
6.72% |
-24.88% |
21.30% |
24.93% |
12.55% |
0.46% |
30.32% |
20.39% |
|
|
Deb.Conv. |
S. Issue |
|
|
|
| 5 year Running Average |
|
$90.0 |
$112.9 |
$118.2 |
$122.8 |
$124.3 |
$125.9 |
$119.8 |
$117.4 |
$121.2 |
$130.0 |
$137.4 |
$161.1 |
$189.4 |
|
|
52.60% |
<-Total Growth |
10 |
CF 5 Yr Running |
|
| CFPS |
$2.27 |
$2.42 |
$2.55 |
$2.60 |
$2.56 |
$2.19 |
$2.28 |
$1.66 |
$2.00 |
$1.58 |
$1.86 |
$1.58 |
$2.06 |
$2.48 |
|
|
-34.69% |
<-Total Growth |
10 |
Cash Flow per Share |
|
| Increase |
8.43% |
6.59% |
5.53% |
1.75% |
-1.60% |
-14.36% |
3.92% |
-27.22% |
20.44% |
-20.56% |
17.58% |
-15.17% |
30.32% |
20.39% |
|
|
3.23% |
<-IRR #YR-> |
10 |
Cash Flow |
37.36% |
| 5 year Running Average |
|
$1.82 |
$2.28 |
$2.39 |
$2.48 |
$2.46 |
$2.44 |
$2.26 |
$2.13 |
$1.94 |
$1.88 |
$1.74 |
$1.75 |
$1.75 |
|
|
5.18% |
<-IRR #YR-> |
5 |
Cash Flow |
28.71% |
| P/CF on Med Price |
6.69 |
5.88 |
6.09 |
4.44 |
2.63 |
2.57 |
3.46 |
5.50 |
4.54 |
7.93 |
7.90 |
10.90 |
|
|
|
|
-4.17% |
<-IRR #YR-> |
10 |
Cash Flow per Share |
-34.69% |
| P/CF on Closing Price |
6.89 |
5.54 |
5.79 |
3.62 |
1.64 |
3.11 |
4.07 |
4.94 |
5.00 |
9.15 |
8.56 |
11.29 |
9.93 |
8.25 |
|
|
-7.03% |
<-IRR #YR-> |
5 |
Cash Flow per Share |
-30.55% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
97.84% |
Diff M/C |
|
-0.46% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
-4.48% |
| Excl.Working Capital CF |
$1.143 |
$1.129 |
-$0.887 |
$5.74 |
-$7.10 |
$0.10 |
-$6.16 |
$15.49 |
-$8.79 |
-$24.62 |
$25.65 |
$17.64 |
$0.00 |
$0.00 |
|
|
-6.54% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
-28.71% |
| CF fr Op $M WC |
$113.6 |
$121.0 |
$125.6 |
$134.4 |
$119.5 |
$120.0 |
$121.8 |
$111.6 |
$107.8 |
$121.0 |
$189.5 |
$182.3 |
$214.6 |
$258.3 |
|
|
50.65% |
<-Total Growth |
10 |
Cash Flow less WC |
|
| Increase |
6.96% |
6.51% |
3.82% |
7.04% |
-11.08% |
0.35% |
1.50% |
-8.36% |
-3.41% |
12.27% |
56.64% |
-3.83% |
17.71% |
20.39% |
|
|
4.18% |
<-IRR #YR-> |
10 |
Cash Flow less WC |
50.65% |
| 5 year Running Average |
|
$89.9 |
$114.0 |
$120.2 |
$122.8 |
$124.1 |
$124.3 |
$121.5 |
$116.1 |
$116.4 |
$130.3 |
$142.4 |
$163.0 |
$193.1 |
|
|
8.40% |
<-IRR #YR-> |
5 |
Cash Flow less WC |
49.70% |
| CFPS Excl. WC |
$2.29 |
$2.44 |
$2.54 |
$2.71 |
$2.41 |
$2.19 |
$2.17 |
$1.92 |
$1.84 |
$1.32 |
$2.16 |
$1.75 |
$2.06 |
$2.48 |
|
|
4.71% |
<-IRR #YR-> |
10 |
CF less WC 5 Yr Run |
58.52% |
| Increase |
6.96% |
6.51% |
3.82% |
7.04% |
-11.08% |
-9.20% |
-1.16% |
-11.22% |
-4.10% |
-28.61% |
63.64% |
-18.79% |
17.71% |
20.39% |
|
|
2.77% |
<-IRR #YR-> |
5 |
CF less WC 5 Yr Run |
14.62% |
| 5 year Running Average |
|
$1.81 |
$2.30 |
$2.43 |
$2.48 |
$2.46 |
$2.40 |
$2.28 |
$2.11 |
$1.89 |
$1.88 |
$1.80 |
$1.83 |
$1.95 |
|
|
-3.28% |
<-IRR #YR-> |
10 |
CFPS - Less WC |
-28.37% |
| P/CF on Median |
6.62 |
5.83 |
6.14 |
4.25 |
2.79 |
2.56 |
3.63 |
4.73 |
4.91 |
9.54 |
6.83 |
9.85 |
|
|
|
|
-4.18% |
<-IRR #YR-> |
5 |
CFPS - Less WC |
-19.22% |
| P/CF on Close |
6.82 |
5.49 |
5.84 |
3.46 |
1.74 |
3.11 |
4.27 |
4.25 |
5.40 |
11.01 |
7.41 |
10.19 |
9.93 |
8.25 |
|
|
-0.09% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
-0.90% |
| *Operational Cash Flow
per share |
|
CF/-WC |
P/CF Med |
10 yr |
5.02 |
5 yr |
7.90 |
P/CF Med |
10 yr |
4.82 |
5 yr |
6.83 |
|
105.90% |
Diff M/C |
|
-5.65% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
-25.23% |
| Using Net Chgne NC WC |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-49.5 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
104.2 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
|
|
|
-56.2 |
0.0 |
0.0 |
0.0 |
0.0 |
104.2 |
|
|
|
|
|
|
|
Shares |
|
|
|
-$119.9 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$164.6 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
|
|
|
-$127.9 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$164.6 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
-$2.42 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.58 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
|
|
|
-$2.28 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.58 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
-$1.82 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.74 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
-$2.44 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.74 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
-$121.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$182.3 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
|
|
|
-$121.8 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$182.3 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
-$89.9 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$142.4 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
|
|
|
-$124.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$142.4 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
-$2.44 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.75 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
|
|
|
-$2.17 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.75 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
-$1.81 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.80 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
-$2.40 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.80 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts receivable |
|
|
|
|
|
|
|
|
|
|
|
-$8.954 |
|
|
|
|
|
|
|
|
|
| Inventory |
|
|
|
|
|
|
|
|
|
|
|
$0.957 |
|
|
|
|
|
|
|
|
|
| Prepaid expenses |
|
|
|
|
|
|
|
|
|
|
|
-$1.098 |
|
|
|
|
|
|
|
|
|
| Collateral deposits |
|
|
|
|
|
|
|
|
|
|
|
-$0.351 |
|
|
|
|
|
|
|
|
|
| Deferred revenue and service obligation |
|
|
|
|
|
|
|
|
|
|
$6.907 |
|
|
|
|
|
|
|
|
|
| Accounts payable and accrued liabilities |
|
|
|
|
|
|
|
|
|
|
-$14.572 |
|
|
|
|
|
|
|
|
|
| Other provisions |
|
|
|
|
|
|
|
|
|
|
|
-$0.084 |
|
|
|
|
|
|
|
|
|
| Insurance claim provisions |
|
|
|
|
|
|
|
|
|
|
|
-$0.558 |
|
|
|
|
|
|
|
|
|
| Interest payable |
|
|
|
|
|
|
|
|
|
|
|
$0.112 |
|
|
|
|
|
|
|
|
|
| Net change in non-cash working capital |
|
|
|
|
|
$6.265 |
-$3.154 |
$7.919 |
$24.615 |
-$25.648 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sum |
|
|
|
|
|
|
$6.265 |
-$3.154 |
$8.786 |
$24.615 |
-$25.648 |
-$17.641 |
|
|
|
|
|
|
|
|
|
| Google |
|
|
|
|
|
|
$7.290 |
-$14.630 |
$7.430 |
$24.61 |
-$25.65 |
-$17.64 |
|
|
|
|
|
|
|
|
|
| Difference |
|
|
|
|
|
|
-$1.025 |
$11.476 |
$1.356 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
restated '13 |
restated '14 |
restated '17 |
restated '17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Back to |
Original |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| OPM |
75.27% |
76.49% |
75.88% |
71.30% |
67.31% |
57.79% |
52.32% |
37.45% |
38.96% |
40.14% |
29.07% |
16.53% |
|
|
|
|
-78.39% |
<-Total Growth |
10 |
OPM |
|
| Increase |
3.71% |
1.62% |
-0.80% |
-6.04% |
-5.59% |
-14.14% |
-9.47% |
-28.42% |
4.04% |
3.02% |
-27.59% |
-43.13% |
|
|
|
|
|
Should increase |
|
or be stable. |
|
| Diff from Ave |
62.8% |
65.5% |
64.1% |
54.2% |
45.6% |
25.0% |
13.2% |
-19.0% |
-15.7% |
-13.2% |
-37.1% |
-64.2% |
|
|
|
|
0.00 |
<-Median-> |
10 |
OPM |
|
| *Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
|
|
OPM |
10 Yrs |
46.23% |
5 Yrs |
37.45% |
|
|
|
|
should be zero, |
it is a check |
|
on calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
$47.84 |
$56.16 |
$47.09 |
$42.66 |
$46.15 |
$82.48 |
$106.16 |
$52.09 |
$66.55 |
$150.05 |
$138.33 |
$214.98 |
$242.66 |
|
|
|
Liq ratio of 1.5 and up, best |
|
|
|
| Current Liabilities |
$24.59 |
$24.34 |
$332.06 |
$375.56 |
$281.82 |
$36.33 |
$108.68 |
$41.16 |
$51.25 |
$85.45 |
$89.82 |
$499.67 |
$234.64 |
|
|
|
1.12 |
<-Median-> |
10 |
Ratio |
|
| Liquidity |
1.95 |
2.31 |
0.14 |
0.11 |
0.16 |
2.27 |
0.98 |
1.27 |
1.30 |
1.76 |
1.54 |
0.43 |
1.03 |
|
|
|
1.30 |
<-Median-> |
5 |
Ratio |
|
| Liq. with CF aft div |
4.26 |
4.81 |
0.33 |
0.29 |
0.41 |
4.59 |
1.82 |
2.66 |
2.79 |
2.72 |
2.54 |
0.57 |
1.53 |
|
|
|
2.66 |
<-Median-> |
5 |
Ratio |
|
| Liq. CF re Inv+Div |
1.43 |
1.51 |
0.25 |
0.23 |
0.33 |
1.31 |
1.10 |
1.01 |
1.13 |
0.38 |
1.13 |
0.28 |
1.53 |
|
|
|
1.01 |
<-Median-> |
5 |
Ratio |
|
| Curr Long Term Db |
|
|
|
|
|
|
$61.131 |
$1.198 |
$1.198 |
$1.258 |
$1.258 |
$250.615 |
$0.321 |
|
|
|
|
|
|
|
|
| Liquidity Less CLTD |
|
|
|
|
|
|
2.23 |
1.30 |
1.33 |
1.78 |
1.56 |
0.86 |
1.04 |
|
|
|
1.33 |
<-Median-> |
5 |
Ratio |
|
| Liq. with CF aft div |
|
|
|
|
|
|
4.16 |
2.74 |
2.86 |
2.77 |
2.58 |
1.15 |
1.53 |
|
|
|
2.74 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Assets |
$1,088.82 |
$1,044.06 |
$1,027.75 |
$1,018.17 |
$953.86 |
$948.61 |
$906.96 |
$802.05 |
$778.88 |
$1,407.73 |
$1,376.25 |
$1,970.79 |
$1,999.75 |
|
|
|
Debt Ratio of 1.5 and up, best |
|
|
|
| Liabilities |
$773.82 |
$742.75 |
$771.77 |
$830.09 |
$788.55 |
$788.10 |
$783.55 |
$706.41 |
$707.58 |
$929.85 |
$986.45 |
$1,354.33 |
$1,405.45 |
|
|
|
1.22 |
<-Median-> |
10 |
Ratio |
|
| Debt Ratio |
1.41 |
1.41 |
1.33 |
1.23 |
1.21 |
1.20 |
1.16 |
1.14 |
1.10 |
1.51 |
1.40 |
1.46 |
1.42 |
|
|
|
1.40 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Book Value |
$315.00 |
$301.31 |
$255.97 |
$188.07 |
$165.31 |
$160.52 |
$123.41 |
$95.64 |
$71.30 |
$477.89 |
$389.80 |
$616.46 |
$594.30 |
$594.30 |
$594.30 |
|
104.59% |
<-Total Growth |
10 |
Book Value |
|
| Book Value per Share |
$6.36 |
$6.08 |
$5.17 |
$3.80 |
$3.34 |
$2.93 |
$2.20 |
$1.65 |
$1.22 |
$5.20 |
$4.43 |
$5.92 |
$5.71 |
$5.71 |
$5.71 |
|
-2.72% |
<-Total Growth |
10 |
Book Value per Share |
|
| Change |
-9.66% |
-4.35% |
-15.05% |
-26.53% |
-12.10% |
-12.14% |
-25.13% |
-24.92% |
-25.98% |
326.22% |
-14.79% |
33.54% |
-3.59% |
0.00% |
0.00% |
|
18.45% |
P/B Ratio |
|
Current/10 Year Median |
|
| P/B Ratio (Median) |
2.39 |
2.34 |
3.01 |
3.04 |
2.02 |
1.92 |
3.59 |
5.52 |
7.42 |
2.42 |
3.32 |
2.91 |
3.45 |
|
|
|
2.42 |
P/B Ratio |
|
Historical Median |
|
| P/B Ratio (Close) |
2.46 |
2.21 |
2.86 |
2.48 |
1.26 |
2.33 |
4.22 |
4.96 |
8.17 |
2.79 |
3.60 |
3.01 |
3.58 |
3.58 |
4.28 |
|
-0.28% |
<-IRR #YR-> |
10 |
Book Value |
-2.72% |
| Change |
13.60% |
-10.35% |
29.82% |
-13.56% |
-49.29% |
85.26% |
81.36% |
17.66% |
64.66% |
-65.88% |
29.17% |
-16.30% |
18.90% |
0.00% |
19.41% |
|
21.94% |
<-IRR #YR-> |
5 |
Book Value |
169.55% |
| Leverage (A/BK) |
3.46 |
3.47 |
4.02 |
5.41 |
5.77 |
5.91 |
7.35 |
8.39 |
10.92 |
2.95 |
3.53 |
3.20 |
3.36 |
|
|
|
5.59 |
<-Median-> |
10 |
A/BV |
|
| Debt/Equity Ratio |
2.46 |
2.47 |
3.02 |
4.41 |
4.77 |
4.91 |
6.35 |
7.39 |
9.92 |
1.95 |
2.53 |
2.20 |
2.36 |
|
|
|
4.59 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
| Sharerholders
Equity (Assets less liabilities) |
|
|
|
|
|
|
P/BV |
10 yr Med |
3.03 |
5 yr Med |
3.32 |
|
18.45% |
Diff M/C |
|
3.53 |
Historical |
15 |
A/BV |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6.08 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.92 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.20 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.92 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$57.02 |
<-12 mths |
-18.12% |
|
|
|
|
|
|
| Comprehensive Income |
|
|
$18.25 |
-$4.08 |
$30.53 |
$4.05 |
$7.68 |
$0.08 |
$12.84 |
$22.03 |
$51.31 |
$69.65 |
|
|
|
|
281.57% |
<-Total Growth |
9 |
Comprehensive Income |
|
| Increase |
|
|
|
-122.36% |
847.82% |
-86.73% |
89.56% |
-98.92% |
15371.08% |
71.52% |
132.96% |
35.74% |
|
|
|
|
71.52% |
<-Median-> |
5 |
Comprehensive Income |
|
| 5 Yr Running Average |
|
|
|
|
|
|
$11.28 |
$7.65 |
$11.04 |
$9.34 |
$18.79 |
$31.18 |
|
|
|
|
16.04% |
<-IRR #YR-> |
9 |
Comprehensive Income |
#DIV/0! |
| ROE |
|
|
7.13% |
-2.17% |
18.47% |
2.52% |
6.22% |
0.09% |
18.01% |
4.61% |
13.16% |
11.30% |
|
|
|
|
55.43% |
<-IRR #YR-> |
5 |
Comprehensive Income |
807.19% |
| 5Yr Median |
|
|
|
|
|
4.83% |
6.22% |
2.52% |
6.22% |
4.61% |
6.22% |
11.30% |
|
|
|
|
22.54% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
#DIV/0! |
| % Difference from NI |
|
|
0.00% |
-120.92% |
41.30% |
1050.57% |
92.60% |
-102.61% |
45.62% |
-1.13% |
0.69% |
13.93% |
|
|
|
|
22.54% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
176.31% |
| Median Values |
|
|
|
|
|
|
|
|
Diff |
5, 10 yr |
7.3% |
0.7% |
|
|
|
|
11.3% |
<-Median-> |
5 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$18.25 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$69.65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$7.68 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$69.65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$31.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$31.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liability
Coverage Ratio |
4.62 |
4.97 |
0.38 |
0.36 |
0.42 |
3.30 |
1.12 |
2.71 |
2.10 |
1.42 |
2.11 |
0.36 |
0.91 |
|
|
|
|
|
|
CFO / Current Liabilities |
|
| 5 year Median |
|
4.61 |
4.61 |
4.61 |
0.42 |
0.42 |
0.42 |
1.12 |
2.10 |
2.10 |
2.10 |
2.10 |
1.42 |
|
|
|
2.10 |
<-Median-> |
5 |
Current Liability Cov Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Asset Efficiency Ratio |
10.43% |
11.59% |
12.22% |
13.20% |
12.53% |
12.65% |
13.43% |
13.91% |
13.84% |
8.60% |
13.77% |
9.25% |
10.73% |
|
|
|
|
|
|
CFO / Total Assets |
|
| 5 year Median |
|
9.35% |
10.43% |
11.59% |
12.22% |
12.53% |
12.65% |
13.20% |
13.43% |
13.43% |
13.77% |
13.77% |
10.73% |
|
|
|
13.8% |
<-Median-> |
5 |
Return on Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Return on Assets ROA |
2.01% |
4.33% |
1.78% |
1.92% |
2.26% |
0.04% |
0.44% |
-0.40% |
1.13% |
1.58% |
3.70% |
3.10% |
3.03% |
|
|
|
Net |
Income/Assets |
|
Return on Assets |
|
| 5Yr Median |
1.69% |
2.01% |
1.78% |
1.92% |
2.01% |
1.92% |
1.78% |
0.44% |
0.44% |
0.44% |
1.13% |
1.58% |
3.03% |
|
|
|
1.7% |
<-Median-> |
10 |
Asset Efficiency Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Return on Equity ROE |
6.94% |
15.02% |
7.13% |
10.38% |
13.07% |
0.22% |
3.23% |
-3.32% |
12.37% |
4.66% |
13.07% |
9.92% |
10.18% |
|
|
|
Net Inc/ |
Shareholders' equity |
|
Return on Equity |
|
| 5Yr Median |
|
6.94% |
6.94% |
7.13% |
10.38% |
10.38% |
7.13% |
3.23% |
3.23% |
3.23% |
4.66% |
9.92% |
10.18% |
|
|
|
8.5% |
<-Median-> |
10 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$54.96 |
<-12 mths |
-10.10% |
|
|
|
|
|
|
| Net Income |
$21.86 |
$45.25 |
$18.25 |
$19.51 |
$21.60 |
$0.35 |
$3.99 |
-$3.18 |
$8.82 |
$22.28 |
$50.96 |
$61.13 |
$60.50 |
$83.00 |
|
|
35.10% |
<-Total Growth |
10 |
Net Income |
|
| Increase |
39.6% |
107.0% |
-59.7% |
6.9% |
10.7% |
-98.4% |
1032.4% |
-179.65% |
-377.73% |
152.62% |
128.74% |
19.97% |
-1.03% |
37.19% |
|
|
EPS/CF Ratio should not be higher than 1.00 |
|
| 5 Yr Running Average |
|
$126.1 |
$12.8 |
$24.1 |
$25.3 |
$21.0 |
$12.7 |
$8.5 |
$6.3 |
$6.5 |
$16.6 |
$28.0 |
$40.7 |
$55.6 |
|
|
3.05% |
<-IRR #YR-> |
10 |
Net Income |
35.10% |
| Operating Cash Flow |
$112.45 |
$119.86 |
$126.50 |
$128.71 |
$126.65 |
$119.87 |
$127.92 |
$96.09 |
$116.56 |
$145.62 |
$163.89 |
$164.64 |
|
|
|
|
72.64% |
<-IRR #YR-> |
5 |
Net Income |
1433.62% |
| Investment Cash Flow |
-$48.85 |
-$53.13 |
-$103.80 |
-$93.79 |
-$75.10 |
-$91.03 |
-$71.80 |
-$67.39 |
-$75.43 |
-$523.30 |
-$112.16 |
-$518.09 |
|
|
|
|
-13.97% |
<-IRR #YR-> |
10 |
5 Yr Running Average |
-77.80% |
| Total Accruals |
-$41.74 |
-$21.48 |
-$4.44 |
-$15.41 |
-$29.94 |
-$28.48 |
-$52.14 |
-$31.88 |
-$32.31 |
$399.96 |
-$0.77 |
$414.58 |
|
|
|
|
17.06% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
119.76% |
| Total Assets |
$1,089 |
$1,044 |
$1,028 |
$1,018 |
$954 |
$949 |
$907 |
$802 |
$779 |
$1,408 |
$1,376 |
$1,971 |
|
|
|
|
|
Balance Sheet |
|
Assets |
|
| Accruals Ratio |
-3.83% |
-2.06% |
-0.43% |
-1.51% |
-3.14% |
-3.00% |
-5.75% |
-3.97% |
-4.15% |
28.41% |
-0.06% |
21.04% |
|
|
|
|
-0.06% |
<-Median-> |
5 |
Ratio |
|
| EPS/CF Ratio |
0.19 |
0.37 |
0.15 |
0.15 |
0.18 |
0.00 |
0.03 |
-0.03 |
0.08 |
0.26 |
0.26 |
0.35 |
|
|
|
|
0.15 |
<-Median-> |
10 |
EPS/CF Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$45.2 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$61.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$61.1 |
|
|
|
|
|
|
|
|
|
|
|
-$126.1 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$28.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$12.7 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$28.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Change in Close |
2.62% |
-14.25% |
10.28% |
-36.49% |
-55.43% |
62.77% |
35.78% |
-11.66% |
21.88% |
45.44% |
10.07% |
11.78% |
14.63% |
0.00% |
19.41% |
|
|
Count |
16 |
Years of data |
|
| up/down |
|
|
|
|
|
|
|
up |
|
|
down |
|
down |
|
|
|
|
Count |
5 |
31.25% |
|
| Meet Prediction? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% right |
Count |
1 |
20.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Financial Cash Flow |
-$55.30 |
-$58.96 |
-$32.48 |
-$43.72 |
-$46.88 |
-$1.68 |
-$33.33 |
-$91.36 |
-$27.82 |
$419.78 |
-$91.37 |
$361.60 |
|
|
|
|
|
C F Statement |
|
Financial CF |
|
| Total Accruals |
$13.56 |
$37.48 |
$28.04 |
$28.31 |
$16.93 |
-$26.80 |
-$18.81 |
$59.49 |
-$4.50 |
-$19.83 |
$90.60 |
$52.98 |
|
|
|
|
|
|
|
Accruals |
|
| Accruals Ratio |
1.25% |
3.59% |
2.73% |
2.78% |
1.78% |
-2.83% |
-2.07% |
7.42% |
-0.58% |
-1.41% |
6.58% |
2.69% |
|
|
|
|
2.69% |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Change in Cash |
|
|
|
|
$4.67 |
$27.16 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash at year end |
|
|
|
$20.67 |
$25.34 |
$52.50 |
$75.29 |
$12.63 |
$25.94 |
$68.06 |
$28.41 |
$38.42 |
$52.83 |
|
|
|
|
|
|
Cash |
|
| Cash Per Share |
|
|
|
$0.42 |
$0.51 |
$0.96 |
$1.34 |
$0.22 |
$0.44 |
$0.74 |
$0.32 |
$0.37 |
$0.51 |
|
|
|
$0.37 |
<-Median-> |
5 |
Cash per Share |
|
| Percentage of Stock
Price |
|
|
|
4.44% |
12.21% |
14.06% |
14.47% |
2.66% |
4.45% |
5.11% |
2.02% |
2.07% |
2.48% |
|
|
|
2.66% |
<-Median-> |
5 |
% of Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Notes: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| August 10,
2017. Last estimates were for 2016,
2017 and 2018 of $973M, $1225M and $1288M for Revenue, $0.82 and 1.52 for FFO
for 2016 and 2017, |
|
|
|
|
|
|
|
|
|
|
|
| $0.49, $0.66 and $0.79 for EPS, and $1.64.
$2.18 and $2.36 for CFPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| August 13,
2016. Last estimates were for 2015,
2016 and 2017 of $557M, $589M and $625M for Revenue, $1.35, $1.36 and $1.57
for FFO, |
|
|
|
|
|
|
|
|
|
|
|
|
| $0.51, $0.62
and $0.75 for EPS, $2.22 and $2.22 for CFPS for 2015 and 2016 and $32M, $61M
and $67.70M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| August 15,
2015. Last estimates were for 2014,
2015 and 2016 of $325M, $345M and $378M for Revenue, $0.47, $0.55 and $0.64
for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
| $2.13 and 2.22
for CFPS for 2014 and 2015, $27.4M and $32M and $37.2M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| August 5,
2014. Last estimates were for 2013,
2014 and 2015 of $283M, 298M and 364M for Revenue, -$.08, $0.27 and $0.29 for
EPS, $1.92, $2.13 and $2.08 for CFPS. |
|
|
|
|
|
|
|
|
|
|
| Jul 7,
2013. Last estimates were for 2011 and
2012 of $234.5M and $260.7M for Revenue and $.10 and -$.21 for earnings and
$2.24 and $2.18 for CF. |
|
|
|
|
|
|
|
|
|
|
|
| Jan 14,
2012. Last Estimates go were for 2010
revenues at $201.2M, EPS at $.05 and $.20 for 2010 and 2011 and $2.19 CF for
2010. |
|
|
|
|
|
|
|
|
|
|
|
|
| Company
converted from Consumers Water Income Fund (TSX-CWI.UN) to EnerCare (TSX-ECI) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sep 9,
2010. Estimates last gotten for 2009
and 2010 were $1.20 and $.71 FFO, $.21 and .01 Earnings and $2.45 and $2.45
for CF. Company will become a
corporation in 2011. |
|
|
|
|
|
|
|
|
|
| As far as I
can see from the Q2 financials, they had earnings some $.05. Earnings for Q1 was basically 0. I have put in $.05 for earnings for 2010. A lot of sites show $0 for both Q1and
Q2. I do not know why. |
|
|
|
|
|
|
|
| Q2, debt was
rolled over, so a lot of current debt disappeared. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sep 28,
2009. This company has annouced that
the Dividend is to be cut in half, effective with Oct 2009 payment. The company annouced this was due to higher
attrition rates among its customers |
|
|
|
|
|
|
|
|
| and an increase in
interest expenses. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jul 14,
2009. Surprisingly there is insider
buying. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AR 2004. I do
not like the fact that all the income is taxable as Interest (as far as I can
determine, anyway). I am also not sure
that I want this stock. I would like
to see what it does over a few more years. |
|
|
|
|
|
|
|
| Started 17 Dec, 2002 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2012 EnerCare Inc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2011 EnerCare Solutions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2002 was
called The Consumers' Waterheater Income Fund. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| They have a
relationship with Direct Energy.
Direct Energy is a sales channel for EnerCare in Ontario. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Will be
affected by Unit Trust legislation but will not change its corporation
structure in 2011. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Company is an
unincorporated open-ended trust established with an unlimited number of trust
units under the laws of the Province of Ontario. It is widely held. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sector: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Power, Utility |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| What should
this stock accomplish? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Would I buy
this company and Why. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Yes. It seems now to be a dividend growth
company. It would not be my first
chose until it fixed its liquidity ratios. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Why am I following this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| I started to
follow this stock in 2009 when it was an income trust. This was one of a few income trusts that I
followed because it was recommended by MPL communications. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends are
paid monthly. Dividends are declared
for one month and paid in the following month. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| For example,
the June 2014 dividend declared for shareholders of record of June 30, 2014
was paid on July 31, 2014. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| How they make their
money. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| EnerCare Inc
owns a portfolio of waterheaters and other portfolio assets, which they rent
to primarily residential customers. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| They rent out
waterheaters in the GTA and southern Ontario.
EnerCare also owns EnerCare Connections Inc., a leading sub-metering
company, with metering contracts for condominium and apartment suites in |
|
|
|
|
|
|
|
| Ontario,
Alberta and elsewhere in Canada. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 14 |
2012 |
Jul 7 |
2013 |
Aug 08 |
2014 |
Aug 15 |
2015 |
Aug 13 |
2016 |
|
|
Aug 10 |
2017 |
|
|
|
| Macdonald, John |
|
|
|
|
|
|
0.047 |
0.08% |
0.060 |
0.07% |
0.080 |
0.09% |
0.400 |
0.38% |
|
|
0.000 |
0.00% |
|
|
|
| CEO - Shares - Amount |
|
|
|
|
|
|
|
$0.464 |
|
$0.876 |
|
$1.277 |
|
$7.14 |
|
|
|
$0.00 |
|
|
|
| Options - percentage |
|
|
|
|
|
|
0.709 |
1.21% |
0.802 |
0.87% |
0.922 |
1.05% |
0.793 |
0.76% |
|
|
0.000 |
0.00% |
|
|
|
| Options - amount |
|
|
|
|
|
|
|
$7.065 |
|
$11.632 |
|
$14.716 |
|
$14.15 |
|
|
|
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sutherland, Evelyn
Louise |
|
|
|
|
|
|
0.009 |
0.02% |
0.009 |
0.01% |
0.011 |
0.01% |
0.022 |
0.02% |
|
|
0.000 |
0.00% |
|
|
|
| CFO - Shares - Amount |
|
|
|
|
|
|
|
$0.090 |
|
$0.131 |
|
$0.177 |
|
$0.39 |
|
|
|
$0.00 |
|
|
|
| Options - percentage |
|
|
|
|
|
|
0.144 |
0.25% |
0.224 |
0.24% |
0.275 |
0.31% |
0.346 |
0.33% |
|
|
0.000 |
0.00% |
|
|
|
| Options - amount |
|
|
|
|
|
|
|
$1.432 |
|
$3.253 |
|
$4.389 |
|
$6.17 |
|
|
|
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Bailey Moffitt, Colleen
Nancy |
|
|
|
|
|
|
|
|
|
|
0.000 |
0.00% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
|
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
$0.000 |
|
$0.00 |
|
|
|
$0.00 |
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
0.026 |
0.03% |
0.049 |
0.05% |
|
|
0.000 |
0.00% |
|
|
|
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
$0.413 |
|
$0.87 |
|
|
|
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cawston, Christopher
Robert |
|
|
|
|
|
|
0.012 |
0.02% |
0.001 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
$0.118 |
|
$0.017 |
|
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
0.000 |
0.00% |
0.000 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
| Options - amount |
|
|
|
|
|
|
|
$0.000 |
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cers, Laima Rita |
|
|
|
|
|
|
0.023 |
0.04% |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
$0.227 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
|
|
|
|
|
|
0.053 |
0.09% |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - amount |
|
|
|
|
|
|
|
$0.531 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| de Wilde, Lisa |
|
|
|
|
|
|
0.004 |
0.01% |
0.004 |
0.00% |
0.004 |
0.00% |
0.005 |
0.01% |
|
|
0.000 |
0.00% |
|
|
|
| Director - Shares -
Amount |
|
|
|
|
|
|
|
$0.042 |
|
$0.062 |
|
$0.068 |
|
$0.09 |
|
|
|
$0.00 |
|
|
|
| Options - percentage |
|
|
|
|
|
|
0.016 |
0.03% |
0.022 |
0.02% |
0.026 |
0.03% |
0.031 |
0.03% |
|
|
0.000 |
0.00% |
|
|
|
| Options - amount |
|
|
|
|
|
|
|
$0.160 |
|
$0.326 |
|
$0.410 |
|
$0.56 |
|
|
|
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Pantelidis, James |
|
|
|
|
|
|
|
|
0.097 |
0.11% |
0.112 |
0.13% |
0.124 |
0.12% |
|
|
0.000 |
0.00% |
|
|
|
| Chairman - Shares - Amt |
|
|
|
|
|
|
|
|
|
$1.399 |
|
$1.792 |
|
$2.20 |
|
|
|
$0.00 |
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
0.110 |
0.12% |
0.132 |
0.15% |
0.154 |
0.15% |
|
|
0.000 |
0.00% |
|
|
|
| Options - amount |
|
|
|
|
|
|
|
|
|
$1.597 |
|
$2.106 |
|
$2.75 |
|
|
|
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Augustus Advisors |
|
|
|
|
|
|
|
|
6.824 |
7.43% |
|
|
|
|
|
|
|
|
|
|
|
| 10% Holder |
|
|
|
|
|
|
|
|
|
$98.947 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Octavian Advisors, LP |
|
|
|
|
|
|
|
|
6.824 |
7.43% |
|
|
|
|
|
|
|
|
|
last updated 2012 |
|
| New-York-based hedge
fund |
|
|
|
|
|
|
|
|
|
$98.947 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Octavian Special Master
Fund |
|
|
|
|
|
|
|
|
6.824 |
7.43% |
|
|
|
|
|
|
|
|
|
|
|
| 10% Holder |
|
|
|
|
|
|
|
|
|
$98.947 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TPG Group Holdings (SBS)
Advisors |
|
|
|
|
|
|
|
|
6.824 |
7.43% |
|
|
|
|
|
|
|
|
|
|
|
| 10% Holder |
|
|
|
|
|
|
|
|
|
$98.947 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Increase in O/S Shares |
|
|
|
|
|
|
|
|
0.000 |
0.00% |
0.000 |
0.00% |
0.388 |
0.44% |
|
|
0.148 |
0.14% |
|
Yes, 0 |
|
| due to SO |
|
|
|
|
|
|
|
|
|
$0.000 |
|
$0.000 |
|
$6.192 |
|
|
|
$2.640 |
|
|
|
| Book Value |
|
|
|
|
|
|
|
|
|
$0 |
|
$0.000 |
|
$3.057 |
|
|
|
$1.501 |
|
|
|
| Insider Buying |
|
|
|
|
|
|
|
|
|
|
|
-$0.162 |
|
$0.000 |
|
|
|
-$0.480 |
|
|
|
| Insider Selling |
|
|
|
|
|
|
|
|
|
|
|
$0.005 |
|
$0.003 |
|
|
|
$1.273 |
|
|
|
| Net Insider Selling |
|
|
|
|
|
|
|
|
|
-$0.558 |
|
-$0.157 |
|
$0.003 |
|
|
|
$0.792 |
|
|
|
| % of Market Cap |
|
|
|
|
|
|
|
|
|
-0.04% |
|
-0.01% |
|
0.00% |
|
|
|
0.04% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Directors |
|
|
|
|
|
|
8 |
|
8 |
|
9 |
|
8 |
|
|
|
8 |
|
|
|
|
| Women |
|
|
|
|
|
|
2 |
25% |
2 |
25% |
2 |
22% |
2 |
25% |
|
|
2 |
25% |
|
|
|
| Minorities |
|
|
|
|
|
|
1 |
13% |
0 |
0% |
0 |
0% |
0 |
0% |
|
|
0 |
0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Institutions/Holdings |
|
|
|
|
0 |
0.00% |
|
|
18 |
34.50% |
47 |
30.90% |
59 |
34.53% |
|
|
84 |
34.00% |
|
|
|
| Total Shares Held |
|
|
|
|
10.972 |
18.78% |
|
|
20.194 |
21.98% |
28.412 |
32.30% |
35.864 |
34.43% |
|
|
35.701 |
34.28% |
|
|
|
| Increase/Decrease |
|
|
|
|
1.164 |
11.87% |
|
|
0.093 |
0.46% |
1.879 |
7.08% |
5.936 |
19.83% |
|
|
0.800 |
2.29% |
|
|
|
| Starting No. of Shares |
|
|
|
|
9.808 |
|
|
|
20.101 |
|
26.533 |
|
29.928 |
|
|
|
34.901 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Copyright ©
2008 Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|