| 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 2020 |
|
|
|
|
|
|
|
|
| Inter Pipeline Ltd |
|
|
|
|
TSX: |
IPL.UN |
OTC: |
IPPLF |
http://www.interpipeline.com/ |
Fiscal Yr: |
Dec 31 |
|
|
|
|
|
|
|
|
|
| Year |
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 |
12/30/20 |
12/30/21 |
12/30/22 |
|
Value |
Description |
#Y |
Item |
Total G |
| Accounting Rules |
|
|
|
C GAAP |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
IFRS |
|
|
|
|
Accounting Rules |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2,480.2 |
<-12 mths |
-2.17% |
|
|
|
|
|
|
| Revenue* |
$1,145.0 |
$1,224.6 |
$924.6 |
$997.1 |
$1,151.6 |
$1,187.0 |
$1,362.7 |
$1,556.3 |
$1,676.3 |
$1,824.6 |
$2,260.8 |
$2,592.9 |
$2,535.3 |
$2,238 |
$2,288 |
$3,135 |
|
174.22% |
<-Total Growth |
10 |
Revenue |
|
| Increase |
13.25% |
6.95% |
-24.50% |
7.84% |
15.50% |
3.08% |
14.80% |
14.20% |
7.71% |
8.85% |
23.91% |
14.69% |
-2.22% |
-11.73% |
2.23% |
37.02% |
|
10.61% |
<-IRR #YR-> |
10 |
Revenue |
174.22% |
| 5 year Running Average |
$748.7 |
$958.0 |
$1,046.4 |
$1,060.4 |
$1,088.5 |
$1,097.0 |
$1,124.6 |
$1,250.9 |
$1,386.8 |
$1,521.4 |
$1,736.1 |
$1,982.2 |
$2,178.0 |
$2,290.3 |
$2,383.0 |
$2,557.8 |
|
10.25% |
<-IRR #YR-> |
5 |
Revenue |
62.91% |
| Revenue per Share |
$5.18 |
$5.49 |
$3.63 |
$3.86 |
$4.36 |
$4.31 |
$4.44 |
$4.77 |
$4.98 |
$4.96 |
$5.95 |
$6.42 |
$6.03 |
$5.26 |
$5.38 |
$7.37 |
|
7.61% |
<-IRR #YR-> |
10 |
5 yr Running Average |
108.13% |
| Increase |
3.43% |
5.89% |
-33.85% |
6.42% |
12.82% |
-1.04% |
2.96% |
7.41% |
4.45% |
-0.47% |
20.02% |
7.87% |
-6.15% |
-12.70% |
2.23% |
37.02% |
|
11.73% |
<-IRR #YR-> |
5 |
5 yr Running Average |
74.11% |
| 5 year Running Average |
$3.86 |
$4.68 |
$4.87 |
$4.64 |
$4.51 |
$4.33 |
$4.12 |
$4.35 |
$4.57 |
$4.69 |
$5.02 |
$5.42 |
$5.67 |
$5.72 |
$5.81 |
$6.09 |
|
5.20% |
<-IRR #YR-> |
10 |
Revenue per Share |
65.98% |
| P/S (Price/Sales) Med |
1.80 |
1.48 |
2.43 |
3.37 |
3.83 |
4.80 |
5.43 |
6.77 |
5.61 |
4.95 |
4.37 |
3.45 |
3.74 |
2.70 |
0.00 |
0.00 |
|
4.78% |
<-IRR #YR-> |
5 |
Revenue per Share |
26.32% |
| P/S (Price/Sales) Close |
1.83 |
1.28 |
2.98 |
3.86 |
4.27 |
5.45 |
5.82 |
7.53 |
4.46 |
5.98 |
4.37 |
3.01 |
3.74 |
2.33 |
2.28 |
1.67 |
|
1.54% |
<-IRR #YR-> |
10 |
5 yr Running Average |
16.46% |
| *Revenue in M CDN
$ |
|
|
|
|
P/S Med |
20 yr |
4.10 |
15 yr |
3.74 |
10 yr |
4.59 |
5 yr |
4.37 |
|
-49.10% |
Diff M/C |
|
5.44% |
<-IRR #YR-> |
5 |
5 yr Running Average |
30.31% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$925 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$2,535 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,556 |
$0 |
$0 |
$0 |
$0 |
$2,535 |
|
|
|
|
|
|
|
|
|
|
|
|
-$1,046 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$2,178 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,251 |
$0 |
$0 |
$0 |
$0 |
$2,178 |
|
|
|
|
|
|
|
|
|
|
|
|
-$3.63 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.03 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4.77 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.03 |
|
|
|
|
|
|
|
|
|
|
|
|
-$4.87 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.67 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4.35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.67 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.28 |
<-12 mths |
-2.29% |
|
|
|
|
|
|
| EPS Basic |
-$0.39 |
$1.12 |
$0.66 |
$0.91 |
$0.95 |
$1.14 |
-$0.20 |
$1.05 |
$1.28 |
$1.31 |
$1.41 |
$1.53 |
$1.31 |
|
|
|
|
98.48% |
<-Total Growth |
10 |
EPS Basic |
|
| EPS Diluted* |
-$0.39 |
$1.12 |
$0.66 |
$0.91 |
$0.95 |
$1.14 |
-$0.20 |
$1.02 |
$1.28 |
$1.31 |
$1.41 |
$1.53 |
$1.31 |
$0.66 |
$0.70 |
$0.81 |
|
98.48% |
<-Total Growth |
10 |
EPS Diluted |
|
| Increase |
-160.00% |
387.18% |
-41.07% |
37.88% |
4.40% |
20.00% |
-117.54% |
610.00% |
25.49% |
2.34% |
7.63% |
8.51% |
-14.38% |
-49.62% |
6.06% |
15.71% |
|
7.10% |
<-IRR #YR-> |
10 |
Earnings per Share |
98.48% |
| Earnings Yield |
-4.1% |
15.9% |
6.1% |
6.1% |
5.1% |
4.9% |
-0.8% |
2.8% |
5.8% |
4.4% |
5.4% |
7.9% |
5.8% |
5.4% |
5.7% |
6.6% |
|
5.13% |
<-IRR #YR-> |
5 |
Earnings per Share |
28.43% |
| 5 year Running Average |
$0.28 |
$0.48 |
$0.50 |
$0.59 |
$0.65 |
$0.96 |
$0.69 |
$0.76 |
$0.84 |
$0.91 |
$0.96 |
$1.31 |
$1.37 |
$1.24 |
$1.12 |
$1.00 |
|
10.50% |
<-IRR #YR-> |
10 |
5 yr Running Average |
171.43% |
| 10 year Running Average |
$0.20 |
$0.30 |
$0.37 |
$0.45 |
$0.53 |
$0.62 |
$0.58 |
$0.63 |
$0.71 |
$0.78 |
$0.96 |
$1.00 |
$1.07 |
$1.04 |
$1.02 |
$0.98 |
|
12.36% |
<-IRR #YR-> |
5 |
5 yr Running Average |
79.06% |
| * Diluted ESP per
share |
|
|
|
|
|
|
|
|
E/P |
10 Yrs |
5.26% |
5Yrs |
5.76% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.66 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.02 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.31 |
|
|
|
|
|
|
|
|
|
|
|
|
-$0.50 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.37 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.76 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.37 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$350.9 |
<-12 mths |
1.04% |
|
|
|
|
|
|
| Dividends Paid in Cash |
|
|
|
|
|
$76.26 |
$91.49 |
$158.60 |
$403.60 |
$470.4 |
$302.5 |
$327.8 |
$347.3 |
$350.9 |
<-12 mths |
|
|
$347.30 |
<-Median-> |
5 |
Dividends Paid in Cash |
|
| Percentage of Net
Income |
|
|
|
|
|
24.83% |
-157.49% |
47.37% |
94.43% |
104.60% |
57.43% |
55.32% |
64.43% |
123.56% |
<-12 mths |
|
|
64.43% |
<-Median-> |
5 |
Percentage of Net Income |
|
| Dividends 5 Yr Running |
|
|
|
|
|
|
|
|
|
82.16% |
84.89% |
71.33% |
73.03% |
75.21% |
<-12 mths |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividend* |
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.81 |
$0.49 |
$0.55 |
|
|
|
|
Dividend* |
|
| Increase |
|
|
|
|
|
|
|
|
|
|
|
|
|
-52.63% |
-39.51% |
12.24% |
|
|
|
|
Increase |
|
| Payout Ratio EPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
122.73% |
70.00% |
67.90% |
|
|
|
|
Payout Ratio EPS |
|
| 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 |
|
$0.00 |
<-Median-> |
10 |
Special Dividends |
|
| Dividend* |
$0.84 |
$0.84 |
$0.84 |
$0.90 |
$0.96 |
$1.05 |
$1.16 |
$1.31 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$1.71 |
$0.89 |
$0.48 |
$0.48 |
|
103.57% |
<-Total Growth |
10 |
Dividends |
|
| Increase |
5.00% |
0.00% |
0.00% |
7.14% |
6.67% |
9.37% |
10.00% |
12.99% |
13.22% |
5.92% |
3.83% |
3.54% |
1.63% |
-47.95% |
-46.07% |
0.00% |
|
|
Count |
21 |
Years of data |
|
| Average Increases 5
Year Running |
4.34% |
3.16% |
2.88% |
3.76% |
3.76% |
4.64% |
6.64% |
9.23% |
10.45% |
10.30% |
9.19% |
7.90% |
5.63% |
-6.60% |
-17.00% |
-17.77% |
|
7.27% |
<-Median-> |
10 |
Average Incr 5 Year Running |
| Dividends 5 Yr Running |
$0.77 |
$0.79 |
$0.81 |
$0.84 |
$0.88 |
$0.92 |
$0.98 |
$1.07 |
$1.19 |
$1.31 |
$1.43 |
$1.53 |
$1.61 |
$1.49 |
$1.28 |
$1.05 |
|
98.03% |
<-Total Growth |
10 |
Dividends 5 Yr Running |
|
| Yield H/L Price |
9.02% |
10.33% |
9.52% |
6.92% |
5.75% |
5.07% |
4.78% |
4.04% |
5.28% |
6.38% |
6.24% |
7.60% |
7.60% |
6.26% |
|
|
|
6.00% |
<-Median-> |
10 |
Yield H/L Price |
|
| Yield on High Price |
8.53% |
8.18% |
7.60% |
5.89% |
5.07% |
4.35% |
4.34% |
3.35% |
4.16% |
5.24% |
5.47% |
6.44% |
6.79% |
3.94% |
|
|
|
5.16% |
<-Median-> |
10 |
Yield on High
Price |
|
| Yield on Low Price |
9.57% |
14.00% |
12.75% |
8.36% |
6.64% |
6.09% |
5.33% |
5.09% |
7.24% |
8.15% |
7.27% |
9.25% |
8.63% |
15.24% |
|
|
|
7.26% |
<-Median-> |
10 |
Yield on Low Price |
|
| Yield on Close Price |
8.85% |
11.91% |
7.77% |
6.03% |
5.15% |
4.47% |
4.47% |
3.63% |
6.65% |
5.28% |
6.24% |
8.70% |
7.59% |
7.25% |
3.91% |
3.91% |
|
5.66% |
<-Median-> |
10 |
Yield on Close Price |
|
| Payout Ratio EPS |
-215.38% |
75.00% |
127.27% |
98.90% |
101.05% |
92.11% |
-577.50% |
127.94% |
115.43% |
119.47% |
115.25% |
109.97% |
130.53% |
134.85% |
68.57% |
59.26% |
|
112.61% |
<-Median-> |
10 |
DPR EPS |
|
| DPR EPS 5 Yr Running |
276.26% |
166.39% |
161.51% |
143.05% |
134.77% |
96.03% |
141.76% |
140.58% |
141.95% |
144.01% |
147.87% |
116.87% |
117.84% |
120.14% |
113.86% |
104.64% |
|
141.17% |
<-Median-> |
10 |
DPR EPS 5 Yr Running |
|
| Payout Ratio CFPS |
79.26% |
58.36% |
75.91% |
66.44% |
55.07% |
76.99% |
75.61% |
74.47% |
65.36% |
71.44% |
60.01% |
63.02% |
85.53% |
53.94% |
28.74% |
20.69% |
|
68.94% |
<-Median-> |
10 |
DPR CF |
|
| DPR CF 5 Yr Running |
91.35% |
76.56% |
73.52% |
70.81% |
65.34% |
65.50% |
69.12% |
69.36% |
68.77% |
72.04% |
68.28% |
66.10% |
68.14% |
66.61% |
59.71% |
50.85% |
|
68.53% |
<-Median-> |
10 |
DPR CF 5 Yr Running |
|
| Payout Ratio CFPS WC |
75.14% |
66.82% |
72.72% |
69.60% |
64.33% |
68.37% |
74.99% |
75.48% |
64.21% |
67.83% |
62.30% |
62.40% |
88.89% |
53.94% |
#DIV/0! |
#DIV/0! |
|
68.10% |
<-Median-> |
10 |
DPR CF WC |
|
| DPR CF WC 5 Yr Running |
85.58% |
78.34% |
75.69% |
72.24% |
69.35% |
68.17% |
69.90% |
70.75% |
69.17% |
69.61% |
67.97% |
65.76% |
68.10% |
66.81% |
#DIV/0! |
#DIV/0! |
|
69.26% |
<-Median-> |
10 |
DPR CF WC 5 Yr Running |
|
| Median 5 Yrs |
10 Yr Med |
10 Yr Cl |
6.00% |
5.66% |
5 Yr Med |
5 Yr Cl |
6.38% |
6.65% |
5 Yr Med |
Payout |
115.43% |
65.36% |
64.21% |
|
|
|
|
5.55% |
<-IRR #YR-> |
5 |
Dividends |
31.03% |
| * Dividends per
share |
10 Yr Med |
and Cur. |
-34.83% |
-30.89% |
5 Yr Med |
and Cur. |
-38.75% |
-41.24% |
Last Div Inc ---> |
$0.1425 |
$0.0400 |
-71.93% |
|
|
|
|
7.37% |
<-IRR #YR-> |
10 |
Dividends |
103.57% |
| Dividends Growth 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.84% |
<-IRR #YR-> |
15 |
Dividends |
134.25% |
| Dividends Growth 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.04% |
<-IRR #YR-> |
20 |
Dividends |
167.19% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3.87% |
<-IRR #YR-> |
21 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends Growth 5 |
|
|
|
|
|
|
|
-$1.31 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.71 |
|
|
|
|
|
|
|
Dividends Growth 5 |
|
| Dividends Growth 10 |
|
|
-$0.84 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.71 |
|
|
|
|
|
|
|
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 |
$1.71 |
|
|
|
|
|
|
|
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 |
$1.71 |
|
|
|
|
|
|
|
Dividends Growth 20 |
|
| Dividends Growth 25 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.71 |
|
|
|
|
|
|
|
Dividends Growth 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Historical Dividends |
|
|
Historical |
High Div |
13.96% |
Low Div |
4.21% |
Ave Div |
9.09% |
Med Div |
8.21% |
Close Div |
7.77% |
|
|
|
|
|
|
|
Historical Dividends |
|
| High/Ave/Median Values |
|
|
Curr diff |
Exp. |
-72.00% |
Exp |
-7.15% |
Exp. |
-56.98% |
Exp. |
-52.39% |
Exp. |
-49.70% |
|
|
|
|
|
|
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Future Dividend Yield |
|
|
|
|
Div Yd |
5.74% |
earning in |
5.00 |
Years |
at IRR of |
8.00% |
Div Inc. |
46.93% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
| Future Dividend Yield |
|
|
|
|
Div Yd |
8.44% |
earning in |
10.00 |
Years |
at IRR of |
8.00% |
Div Inc. |
115.89% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
| Future Dividend Yield |
|
|
|
|
Div Yd |
12.40% |
earning in |
15.00 |
Years |
at IRR of |
8.00% |
Div Inc. |
217.22% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Yield if held 5 years |
12.75% |
12.14% |
10.09% |
9.35% |
10.35% |
11.27% |
14.20% |
14.80% |
11.35% |
9.38% |
7.85% |
6.97% |
5.29% |
3.18% |
1.96% |
1.84% |
|
9.87% |
<-Median-> |
10 |
Paid Median Price |
|
| Yield if held 10 years |
|
13.23% |
14.27% |
15.32% |
14.96% |
15.93% |
16.69% |
15.68% |
15.35% |
16.87% |
17.44% |
20.68% |
19.39% |
6.84% |
2.88% |
2.32% |
|
16.31% |
<-Median-> |
10 |
Paid Median Price |
|
| Yield if held 15 years |
|
|
|
|
|
|
18.20% |
22.18% |
25.15% |
24.40% |
24.66% |
24.31% |
20.54% |
9.25% |
5.18% |
5.15% |
|
24.31% |
<-Median-> |
7 |
Paid Median Price |
|
| Yield if held 20 years |
|
|
|
|
|
|
|
|
|
|
|
26.51% |
29.06% |
15.15% |
7.48% |
7.28% |
|
27.78% |
<-Median-> |
2 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cost cover if held 5
years |
58.27% |
57.23% |
48.89% |
43.84% |
47.22% |
49.28% |
60.30% |
60.88% |
45.70% |
39.27% |
34.43% |
31.71% |
24.95% |
26.73% |
26.04% |
20.14% |
|
44.77% |
<-Median-> |
10 |
Paid Median Price |
|
| Cost cover if held 10
years |
|
115.64% |
128.12% |
132.43% |
125.64% |
127.92% |
128.11% |
113.39% |
105.64% |
117.87% |
125.79% |
154.39% |
152.27% |
103.11% |
77.55% |
59.76% |
|
126.86% |
<-Median-> |
10 |
Paid Median Price |
|
| Cost cover if held 15
years |
|
|
|
|
|
|
192.91% |
219.37% |
233.66% |
227.79% |
236.08% |
238.73% |
210.21% |
183.27% |
186.74% |
182.07% |
|
227.79% |
<-Median-> |
7 |
Paid Median Price |
|
| Cost cover if held 20
years |
|
|
|
|
|
|
|
|
|
|
|
313.51% |
356.33% |
360.85% |
327.36% |
315.63% |
|
334.92% |
<-Median-> |
2 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Graham No. |
$8.39 |
$11.30 |
$8.77 |
$10.28 |
$10.72 |
$12.08 |
$13.25 |
$14.74 |
$15.54 |
$15.98 |
$17.01 |
$18.39 |
$16.93 |
$12.03 |
$12.39 |
$0.00 |
|
92.92% |
<-Total Growth |
10 |
Graham Price |
|
| Price/GP Ratio Med |
1.11 |
0.72 |
1.01 |
1.27 |
1.56 |
1.71 |
1.82 |
2.19 |
1.80 |
1.53 |
1.53 |
1.20 |
1.33 |
1.18 |
|
|
|
1.55 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Price/GP Ratio High |
1.17 |
0.91 |
1.26 |
1.48 |
1.77 |
2.00 |
2.01 |
2.64 |
2.29 |
1.87 |
1.75 |
1.42 |
1.49 |
1.88 |
|
|
|
1.82 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Price/GP Ratio Low |
1.05 |
0.53 |
0.75 |
1.05 |
1.35 |
1.43 |
1.63 |
1.74 |
1.31 |
1.20 |
1.31 |
0.99 |
1.17 |
0.49 |
|
|
|
1.31 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Price/GP Ratio Close |
1.13 |
0.62 |
1.23 |
1.45 |
1.74 |
1.94 |
1.95 |
2.44 |
1.43 |
1.85 |
1.53 |
1.05 |
1.33 |
1.02 |
0.99 |
#DIV/0! |
|
1.63 |
<-Median-> |
10 |
Price/GP Ratio |
|
| Prem/Disc Close |
13.05% |
-37.60% |
23.21% |
45.08% |
73.81% |
94.49% |
94.93% |
143.77% |
42.91% |
85.47% |
53.03% |
5.19% |
33.16% |
2.06% |
-0.90% |
#DIV/0! |
|
63.42% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Close |
$9.49 |
$7.05 |
$10.81 |
$14.92 |
$18.63 |
$23.50 |
$25.83 |
$35.94 |
$22.21 |
$29.64 |
$26.03 |
$19.34 |
$22.54 |
$12.28 |
$12.28 |
$12.28 |
|
108.51% |
<-Total Growth |
10 |
Stock Price |
|
| Increase |
4.98% |
-25.71% |
53.33% |
38.02% |
24.87% |
26.14% |
9.91% |
39.14% |
-38.20% |
33.45% |
-12.18% |
-25.70% |
16.55% |
-45.52% |
0.00% |
0.00% |
|
33.10 |
<-Median-> |
10 |
CAPE (10 Yr P/E) |
|
| P/E |
-24.33 |
6.29 |
16.38 |
16.40 |
19.61 |
20.61 |
-129.15 |
35.24 |
17.35 |
22.63 |
18.46 |
12.64 |
17.21 |
18.61 |
17.54 |
15.16 |
|
-8.91% |
<-IRR #YR-> |
5 |
Stock Price |
-37.28% |
| Trailing P/E |
14.60 |
-18.08 |
9.65 |
22.61 |
20.47 |
24.74 |
22.66 |
-179.70 |
21.77 |
23.16 |
19.87 |
13.72 |
14.73 |
9.37 |
18.61 |
17.54 |
|
7.62% |
<-IRR #YR-> |
10 |
Stock Price |
108.51% |
| CAPE (10 Yr P/E) |
47.93 |
23.42 |
29.38 |
33.38 |
35.08 |
38.09 |
44.23 |
56.69 |
31.11 |
38.00 |
27.11 |
19.32 |
21.14 |
11.80 |
12.09 |
12.49 |
|
-3.50% |
<-IRR #YR-> |
5 |
Price & Dividend |
-14.86% |
| Median 5, 10 Yrs |
|
D. per yr |
8.68% |
5.41% |
% Tot Ret |
-247.86% |
33.18% |
T P/E |
17.91 |
17.35 |
P/E: |
0.21 |
-0.12 |
|
|
|
|
16.30% |
<-IRR #YR-> |
10 |
Price & Dividend |
232.75% |
| Price 15 |
|
D. per yr |
7.97% |
|
% Tot Ret |
56.29% |
|
|
|
|
|
CAPE Diff |
-43.78% |
|
|
|
|
6.19% |
<-IRR #YR-> |
15 |
Stock Price |
146.07% |
| Price 20 |
|
D. per yr |
10.64% |
|
% Tot Ret |
57.30% |
|
|
|
|
|
|
|
|
|
|
|
7.93% |
<-IRR #YR-> |
20 |
Stock Price |
360.00% |
| Price 25 |
|
D. per yr |
6.42% |
|
% Tot Ret |
63.03% |
|
|
|
|
|
|
|
|
|
|
|
3.76% |
<-IRR #YR-> |
22 |
Stock Price |
|
| Price & Dividend 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14.15% |
<-IRR #YR-> |
15 |
Price & Dividend |
337.12% |
| Price & Dividend 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18.57% |
<-IRR #YR-> |
20 |
Price & Dividend |
3420.66% |
| Price & Dividend 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.18% |
<-IRR #YR-> |
22 |
Price & Dividend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price 5 |
|
|
|
|
|
|
|
-$35.94 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.54 |
|
|
|
|
|
|
|
Price 5 |
|
| Price 10 |
|
|
-$10.81 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.54 |
|
|
|
|
|
|
|
Price 10 |
|
| Price & Dividend 5 |
|
|
|
|
|
|
|
-$35.94 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$24.25 |
|
|
|
|
|
|
|
Price & Dividend 5 |
|
| Price & Dividend 10 |
|
|
-$10.81 |
$0.90 |
$0.96 |
$1.05 |
$1.16 |
$1.31 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$24.25 |
|
|
|
|
|
|
|
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 |
$22.54 |
|
|
|
|
|
|
|
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 |
$22.54 |
|
|
|
|
|
|
|
Price 20 |
|
| Price 25 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.54 |
|
|
|
|
|
|
|
Price 25 |
|
| Price & Dividend 15 |
$0.84 |
$0.84 |
$0.84 |
$0.90 |
$0.96 |
$1.05 |
$1.16 |
$1.31 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$24.25 |
|
|
|
|
|
|
|
Price & Dividend 15 |
|
| Price & Dividend 20 |
$0.84 |
$0.84 |
$0.84 |
$0.90 |
$0.96 |
$1.05 |
$1.16 |
$1.31 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$24.25 |
|
|
|
|
|
|
|
Price & Dividend 20 |
|
| Price & Dividend 25 |
$0.84 |
$0.84 |
$0.84 |
$0.90 |
$0.96 |
$1.05 |
$1.16 |
$1.31 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$24.25 |
|
|
|
|
|
|
|
Price & Dividend 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price Median H/L |
$9.32 |
$8.14 |
$8.82 |
$13.02 |
$16.69 |
$20.70 |
$24.14 |
$32.31 |
$27.96 |
$24.53 |
$26.04 |
$22.15 |
$22.51 |
$14.21 |
|
|
|
155.22% |
<-Total Growth |
10 |
Stock Price |
|
| Increase |
0.43% |
-12.67% |
8.42% |
47.56% |
28.20% |
24.06% |
16.62% |
33.82% |
-13.45% |
-12.29% |
6.16% |
-14.92% |
1.63% |
-36.87% |
|
|
|
9.82% |
<-IRR #YR-> |
10 |
Stock Price |
155.22% |
| P/E |
-23.88 |
7.26 |
13.36 |
14.30 |
17.56 |
18.16 |
-120.70 |
31.67 |
21.84 |
18.72 |
18.46 |
14.48 |
17.18 |
21.53 |
|
|
|
-6.97% |
<-IRR #YR-> |
5 |
Stock Price |
-30.32% |
| Trailing P/E |
14.33 |
-20.86 |
7.88 |
19.72 |
18.34 |
21.79 |
21.18 |
-161.53 |
27.41 |
19.16 |
19.87 |
15.71 |
14.71 |
10.85 |
|
|
|
19.67% |
<-IRR #YR-> |
10 |
Price & Dividend |
|
| P/E on Run. 5 yr Ave |
33.51 |
17.09 |
17.50 |
22.06 |
25.67 |
21.65 |
34.88 |
42.28 |
33.37 |
26.95 |
27.01 |
16.91 |
16.45 |
11.42 |
|
|
|
-1.22% |
<-IRR #YR-> |
5 |
Price & Dividend |
|
| P/E on Run. 10 yr Ave |
47.05 |
27.03 |
23.97 |
29.12 |
31.42 |
33.55 |
41.34 |
50.95 |
39.16 |
31.44 |
27.12 |
22.13 |
21.12 |
13.65 |
|
|
|
17.86 |
P/E Ratio |
|
Historical Median |
|
| Median 10, 5 Yrs |
|
D. per yr |
9.85% |
5.75% |
% Tot Ret |
50.06% |
-471.61% |
T P/E |
19.44 |
19.16 |
P/E: |
17.86 |
18.46 |
|
|
|
|
|
Count |
22 |
Years of data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$8.82 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$32.31 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.51 |
|
|
|
|
|
|
|
|
|
|
|
|
-$8.82 |
$0.90 |
$0.96 |
$1.05 |
$1.16 |
$1.31 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$24.22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$32.31 |
$1.48 |
$1.57 |
$1.63 |
$1.68 |
$24.22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| High Months |
Nov 07 |
Jun |
Dec |
Dec |
Dec |
Dec |
Oct |
Sep |
Jan |
Dec |
Jan |
Jan |
Sep |
Jan |
|
|
|
|
|
|
|
|
| Price High |
$9.85 |
$10.27 |
$11.05 |
$15.27 |
$18.92 |
$24.15 |
$26.63 |
$38.95 |
$35.52 |
$29.84 |
$29.72 |
$26.11 |
$25.20 |
$22.58 |
|
|
|
128.05% |
<-Total Growth |
10 |
Stock Price |
|
| Increase |
-7.08% |
4.26% |
7.59% |
38.19% |
23.90% |
27.64% |
10.27% |
46.26% |
-8.81% |
-15.99% |
-0.40% |
-12.15% |
-3.49% |
-10.40% |
|
|
|
8.59% |
<-IRR #YR-> |
10 |
Stock Price |
128.05% |
| P/E |
-25.26 |
9.17 |
16.74 |
16.78 |
19.92 |
21.18 |
-133.15 |
38.19 |
27.75 |
22.78 |
21.08 |
17.07 |
19.24 |
34.21 |
|
|
|
-8.34% |
<-IRR #YR-> |
5 |
Stock Price |
-35.30% |
| Trailing P/E |
15.15 |
-26.33 |
9.87 |
23.14 |
20.79 |
25.42 |
23.36 |
-194.75 |
34.82 |
23.31 |
22.69 |
18.52 |
16.47 |
17.24 |
|
|
|
19.92 |
P/E Ratio |
|
Historical Median |
|
| Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
22.91 |
22.69 |
P/E: |
20.50 |
21.08 |
|
|
|
|
34.01 |
P/E Ratio |
|
Historical High |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11.05 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$25.20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$38.95 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$25.20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Low Months |
Jan 07 |
Dec |
Mar |
May |
Aug |
Jan |
Jun |
Jan |
Dec |
Jan |
Aug |
Dec |
Jun |
Mar |
|
|
|
|
|
|
|
|
| Price Low |
$8.78 |
$6.00 |
$6.59 |
$10.76 |
$14.45 |
$17.25 |
$21.65 |
$25.66 |
$20.40 |
$19.21 |
$22.35 |
$18.19 |
$19.82 |
$5.84 |
|
|
|
200.76% |
<-Total Growth |
10 |
Stock Price |
|
| Increase |
10.44% |
-31.66% |
9.83% |
63.28% |
34.29% |
19.38% |
25.51% |
18.52% |
-20.50% |
-5.83% |
16.35% |
-18.61% |
8.96% |
-70.53% |
|
|
|
11.64% |
<-IRR #YR-> |
10 |
Stock Price |
200.76% |
| P/E |
-22.51 |
5.36 |
9.98 |
11.82 |
15.21 |
15.13 |
-108.25 |
25.16 |
15.94 |
14.66 |
15.85 |
11.89 |
15.13 |
8.85 |
|
|
|
-5.03% |
<-IRR #YR-> |
5 |
Stock Price |
-22.76% |
| Trailing P/E |
13.51 |
-15.38 |
5.88 |
16.30 |
15.88 |
18.16 |
18.99 |
-128.30 |
20.00 |
15.01 |
17.06 |
12.90 |
12.95 |
4.46 |
|
|
|
15.13 |
P/E Ratio |
|
Historical Median |
|
| Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
16.09 |
15.01 |
P/E: |
15.13 |
15.13 |
|
|
|
|
7.21 |
P/E Ratio |
|
Historical Low |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6.59 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$19.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$25.66 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$19.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$436 |
<-12 mths |
5.29% |
|
|
|
|
|
|
| Free Cash Flow WSJ |
|
|
|
|
|
|
|
|
$419 |
$620 |
$650 |
$134 |
-$753 |
-$434 |
-$100 |
$1,016 |
|
|
|
|
|
WSJ, MS |
| Change |
|
|
|
|
|
|
|
|
|
47.97% |
4.84% |
-79.38% |
-661.94% |
42.36% |
76.96% |
1116.00% |
|
|
|
|
|
Mkt Sc |
| Free Cash Flow MS |
|
|
|
$257 |
$260 |
$271 |
$286 |
$328 |
$335 |
$344 |
$375 |
$389 |
$414 |
-$434 |
-$100 |
$1,016 |
|
61.09% |
<-Total Growth |
9 |
Free Cash Flow |
Disagree |
| Change |
|
|
|
|
1.17% |
4.23% |
5.54% |
14.69% |
2.13% |
2.69% |
9.01% |
3.73% |
6.43% |
-204.83% |
76.96% |
1116.00% |
|
$0.04 |
<-Median-> |
9 |
Change |
|
| FCF/CF from Op Ratio |
|
|
|
0.74 |
0.56 |
0.72 |
0.61 |
0.57 |
0.44 |
0.43 |
0.36 |
0.36 |
0.49 |
-0.62 |
-0.14 |
1.03 |
|
0.53 |
<-Median-> |
10 |
FCF/CF from Op Ratio |
|
| Dividends paid |
|
|
|
|
|
$76.26 |
$91.49 |
$158.60 |
$403.60 |
$470.40 |
$302.50 |
$327.80 |
$347.30 |
$378.61 |
$204.19 |
$204.19 |
|
355.39% |
<-Total Growth |
7 |
Dividends paid |
|
| Percentage paid |
|
|
|
|
|
28.14% |
31.99% |
48.35% |
120.48% |
136.74% |
80.67% |
84.27% |
83.89% |
-87.24% |
-204.19% |
20.10% |
|
$0.82 |
<-Median-> |
8 |
Percentage paid |
|
| 5 Year Covrage |
|
|
|
|
|
|
|
|
|
|
|
|
99.71% |
167.89% |
242.30% |
113.78% |
|
|
|
|
5 Year Covrage |
|
| Dividend
Coverage Ratio |
|
|
|
|
|
3.55 |
3.13 |
2.07 |
0.83 |
0.73 |
1.24 |
1.19 |
1.19 |
-1.15 |
-0.49 |
4.98 |
|
1.22 |
<-Median-> |
8 |
Dividend Coverage Ratio |
|
| 5 Year of Caogerage |
|
|
|
|
|
|
|
|
2.03 |
1.30 |
1.17 |
1.07 |
1.00 |
0.60 |
0.41 |
0.88 |
|
|
|
|
5 Year of Caogerage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long Term Debt |
|
|
|
|
|
|
|
$3,294 |
$3,422 |
$4,068 |
$3,943 |
$4,397 |
$4,268 |
$4,350 |
|
|
|
|
|
|
Debt |
|
| Change |
|
|
|
|
|
|
|
|
3.88% |
18.88% |
-3.07% |
11.53% |
-2.95% |
1.93% |
|
|
|
3.88% |
<-Median-> |
5 |
Change |
|
| Debt/Market Cap Ratio |
|
|
|
|
|
|
|
0.28 |
0.46 |
0.37 |
0.40 |
0.56 |
0.45 |
0.83 |
|
|
|
0.42 |
<-Median-> |
6 |
Debt/Market Cap Ratio |
|
| Assets/Current
Liabilities Ratio |
|
|
|
|
|
|
|
4.23 |
5.27 |
4.85 |
5.35 |
6.34 |
4.18 |
4.20 |
|
|
|
5.06 |
<-Median-> |
6 |
Assets/Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Goodwill &
Intangibles |
|
|
|
|
$502.01 |
$609.38 |
$617.70 |
$596.66 |
$595.20 |
$684.70 |
$659.30 |
$676.00 |
$528.5 |
$582.3 |
|
|
|
|
Intangibles |
|
Goodwill |
|
| Change |
|
|
|
|
|
21.39% |
1.37% |
-3.41% |
-0.25% |
15.04% |
-3.71% |
2.53% |
-21.82% |
10.18% |
|
|
|
0.56% |
<-Median-> |
8 |
Change |
|
| Intangible/Market Cap
Ratio |
|
|
|
|
0.10 |
0.09 |
0.08 |
0.05 |
0.08 |
0.06 |
0.07 |
0.09 |
0.06 |
0.11 |
|
|
|
0.08 |
<-Median-> |
9 |
Intangible/Market Cap Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Market Cap |
$2,096 |
$1,573 |
$2,753 |
$3,850 |
$4,921 |
$6,466 |
$7,925 |
$11,724 |
$7,471 |
$10,905 |
$9,886 |
$7,809 |
$9,483 |
$5,224 |
$5,224 |
$5,224 |
|
244.48% |
<-Total Growth |
10 |
Market Cap |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Diluted # of Shares in
Million |
|
|
|
257.040 |
260.350 |
270.593 |
285.943 |
327.812 |
334.8 |
344.3 |
374.5 |
389.1 |
413.5 |
424.3 |
|
|
|
60.87% |
<-Total Growth |
9 |
Diluted |
|
| Change |
|
|
|
|
1.29% |
3.93% |
5.67% |
14.64% |
2.13% |
2.84% |
8.77% |
3.90% |
6.27% |
2.61% |
|
|
|
3.93% |
<-Median-> |
9 |
Change |
|
| Difference
Diluted/Basic |
|
|
|
-0.1% |
-0.2% |
-0.3% |
0.0% |
-2.3% |
-0.1% |
-0.3% |
-0.2% |
-0.2% |
-0.3% |
-0.3% |
|
|
|
-0.22% |
<-Median-> |
10 |
Difference Diluted/Basic |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Basic # of Shares in
Millions |
203.360 |
222.040 |
238.800 |
256.880 |
259.940 |
269.900 |
285.943 |
320.210 |
334.6 |
343.4 |
373.7 |
388.2 |
412.4 |
422.9 |
|
|
|
72.70% |
<-Total Growth |
10 |
Basic |
|
| Change |
1.90% |
9.19% |
7.55% |
7.57% |
1.19% |
3.83% |
5.94% |
11.98% |
4.49% |
2.63% |
8.82% |
3.88% |
6.23% |
2.55% |
|
|
|
5.22% |
<-Median-> |
10 |
Change |
|
| Difference
Basic/Outstanding |
8.6% |
0.5% |
6.6% |
0.5% |
1.6% |
1.9% |
7.3% |
1.9% |
0.5% |
7.1% |
1.6% |
4.0% |
2.0% |
0.6% |
|
|
|
1.91% |
<-Median-> |
10 |
Difference Basic/Outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$851.00 |
<-12 mths |
1.18% |
|
|
|
|
|
|
| Class A |
|
|
254.39 |
257.79 |
263.89 |
274.88 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Class B |
|
|
0.25 |
0.26 |
0.26 |
0.28 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| # of Share in Millions |
220.88 |
223.10 |
254.65 |
258.04 |
264.16 |
275.16 |
306.80 |
326.21 |
336.4 |
367.9 |
379.8 |
403.8 |
420.7 |
425.40 |
425.40 |
425.40 |
|
5.15% |
<-IRR #YR-> |
10 |
Shares |
65.21% |
| Increase |
9.49% |
1.01% |
14.14% |
1.33% |
2.37% |
4.16% |
11.50% |
6.33% |
3.12% |
9.36% |
3.23% |
6.32% |
4.19% |
1.12% |
0.00% |
0.00% |
|
5.22% |
<-IRR #YR-> |
5 |
Shares |
28.97% |
| CF fr Op $M |
$234.1 |
$321.1 |
$281.8 |
$349.6 |
$460.5 |
$375.3 |
$468.7 |
$571.7 |
$760.5 |
$805.9 |
$1,028.4 |
$1,078.1 |
$841.1 |
$701.9 |
$710.4 |
$986.9 |
|
198.49% |
<-Total Growth |
10 |
Cash Flow |
|
| Increase |
16.09% |
37.19% |
-12.26% |
24.05% |
31.74% |
-18.51% |
24.90% |
21.98% |
33.03% |
5.97% |
27.61% |
4.83% |
-21.98% |
-16.55% |
1.21% |
38.92% |
|
DRIP, |
S. Issues |
|
Fr Conv. Shares |
|
| 5 year Running Average |
$160.4 |
$212.5 |
$242.1 |
$277.6 |
$329.4 |
$357.6 |
$387.2 |
$445.1 |
$527.3 |
$596.4 |
$727.0 |
$848.9 |
$902.8 |
$891.1 |
$872.0 |
$863.7 |
|
272.91% |
<-Total Growth |
10 |
CF 5 Yr Running |
|
| CFPS |
$1.06 |
$1.44 |
$1.11 |
$1.35 |
$1.74 |
$1.36 |
$1.53 |
$1.75 |
$2.26 |
$2.19 |
$2.71 |
$2.67 |
$2.00 |
$1.65 |
$1.67 |
$2.32 |
|
80.67% |
<-Total Growth |
10 |
Cash Flow per Share |
|
| Increase |
6.02% |
35.83% |
-23.13% |
22.42% |
28.69% |
-21.77% |
12.02% |
14.72% |
29.00% |
-3.10% |
23.61% |
-1.40% |
-25.12% |
-17.47% |
1.21% |
38.92% |
|
11.56% |
<-IRR #YR-> |
10 |
Cash Flow |
198.49% |
| 5 year Running Average |
$0.84 |
$1.03 |
$1.11 |
$1.19 |
$1.34 |
$1.40 |
$1.42 |
$1.55 |
$1.73 |
$1.82 |
$2.09 |
$2.32 |
$2.37 |
$2.24 |
$2.14 |
$2.06 |
|
8.03% |
<-IRR #YR-> |
5 |
Cash Flow |
47.13% |
| P/CF on Med Price |
8.79 |
5.65 |
7.97 |
9.61 |
9.57 |
15.18 |
15.80 |
18.43 |
12.37 |
11.20 |
9.62 |
8.30 |
11.26 |
8.61 |
0.00 |
0.00 |
|
6.09% |
<-IRR #YR-> |
10 |
Cash Flow per Share |
80.67% |
| P/CF on Closing Price |
8.95 |
4.90 |
9.77 |
11.01 |
10.69 |
17.23 |
16.91 |
20.51 |
9.82 |
13.53 |
9.61 |
7.24 |
11.27 |
7.44 |
7.35 |
5.29 |
|
2.67% |
<-IRR #YR-> |
5 |
Cash Flow per Share |
14.08% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-33.71% |
Diff M/C |
|
7.89% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
113.65% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$805.30 |
<-12 mths |
-0.49% |
|
|
|
|
|
|
| Excl.Working Capital CF |
$12.83 |
-$40.67 |
$12.4 |
-$15.9 |
-$66.3 |
$47.3 |
$3.9 |
-$7.7 |
$13.6 |
$42.9 |
-$37.8 |
$10.6 |
-$31.8 |
$0.0 |
|
|
|
8.85% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
52.78% |
| CF fr Op $M WC |
$246.9 |
$280.5 |
$294.2 |
$333.7 |
$394.2 |
$422.6 |
$472.6 |
$564.0 |
$774.1 |
$848.8 |
$990.6 |
$1,088.7 |
$809.3 |
$701.9 |
|
|
|
175.12% |
<-Total Growth |
10 |
Cash Flow less WC |
|
| Increase |
20.20% |
13.59% |
4.88% |
13.43% |
18.15% |
7.20% |
11.82% |
19.36% |
37.25% |
9.65% |
16.71% |
9.90% |
-25.66% |
-13.27% |
|
|
|
10.65% |
<-IRR #YR-> |
10 |
Cash Flow less WC |
175.12% |
| 5 year Running Average |
$168.8 |
$207.2 |
$236.0 |
$272.1 |
$309.9 |
$345.0 |
$383.4 |
$437.4 |
$525.5 |
$616.4 |
$730.0 |
$853.2 |
$902.3 |
$887.9 |
|
|
|
7.49% |
<-IRR #YR-> |
5 |
Cash Flow less WC |
43.49% |
| CFPS Excl. WC |
$1.12 |
$1.26 |
$1.16 |
$1.29 |
$1.49 |
$1.54 |
$1.54 |
$1.73 |
$2.30 |
$2.31 |
$2.61 |
$2.70 |
$1.92 |
$1.65 |
|
|
|
14.35% |
<-IRR #YR-> |
10 |
CF less WC 5 Yr Run |
282.36% |
| Increase |
9.78% |
12.46% |
-8.11% |
11.94% |
15.41% |
2.91% |
0.29% |
12.25% |
33.09% |
0.26% |
13.05% |
3.37% |
-28.65% |
-14.23% |
|
|
|
15.58% |
<-IRR #YR-> |
5 |
CF less WC 5 Yr Run |
106.28% |
| 5 year Running Average |
$0.90 |
$1.01 |
$1.08 |
$1.17 |
$1.26 |
$1.35 |
$1.40 |
$1.52 |
$1.72 |
$1.88 |
$2.10 |
$2.33 |
$2.37 |
$2.24 |
|
|
|
5.23% |
<-IRR #YR-> |
10 |
CFPS - Less WC |
66.53% |
| P/CF on Med Price |
8.33 |
6.47 |
7.64 |
10.07 |
11.18 |
13.48 |
15.67 |
18.68 |
12.15 |
10.63 |
9.98 |
8.22 |
11.70 |
8.61 |
|
|
|
2.16% |
<-IRR #YR-> |
5 |
CFPS - Less WC |
11.26% |
| P/CF on Closing Price |
8.49 |
5.61 |
9.36 |
11.54 |
12.48 |
15.30 |
16.77 |
20.79 |
9.65 |
12.85 |
9.98 |
7.17 |
11.72 |
7.44 |
|
|
|
8.21% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
120.13% |
| *Operational Cash Flow
per share |
|
|
CF/-WC |
P/CF Med |
10 yr |
11.23 |
5 yr |
11.20 |
P/CF Med |
10 yr |
11.44 |
5 yr |
10.63 |
|
-34.95% |
Diff M/C |
|
9.29% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
55.94% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-254.6 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
420.7 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
|
|
|
|
-326.2 |
0.0 |
0.0 |
0.0 |
0.0 |
420.7 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
-$281.8 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$841.1 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
|
|
|
|
-$571.7 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$841.1 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
-$1.11 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.00 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
|
|
|
|
-$1.75 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.00 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
-$1.11 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.37 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
-$1.55 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.37 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
-$294.2 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$809.3 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
|
|
|
|
-$564.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$809.3 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
-$236.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$902.3 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
|
|
|
|
-$437.4 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$902.3 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
-$1.16 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.92 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
|
|
|
|
-$1.73 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$1.92 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
-$1.08 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.37 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
-$1.52 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.37 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Changes in NC Working Capital |
|
|
|
|
|
|
-$3.9 |
$7.7 |
-$13.6 |
-$42.9 |
$37.8 |
-$10.6 |
$31.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sum |
|
|
|
|
|
|
-$3.9 |
$7.7 |
-$13.6 |
-$42.9 |
$37.8 |
-$10.6 |
$31.8 |
|
|
|
|
|
|
|
|
|
| Google -->TD 2017 |
|
|
|
|
|
|
-$3.9 |
$7.7 |
-$13.6 |
-$42.9 |
$38 |
-$11 |
$32 |
|
|
|
|
|
|
|
|
|
| Difference |
|
|
|
|
|
|
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| OPM |
20.44% |
26.22% |
30.48% |
35.06% |
39.99% |
31.61% |
34.39% |
36.73% |
45.37% |
44.17% |
45.49% |
41.58% |
33.18% |
31.36% |
|
|
|
8.85% |
<-Total Growth |
10 |
OPM |
|
| Increase |
2.51% |
28.27% |
16.22% |
15.03% |
14.06% |
-20.95% |
8.79% |
6.81% |
23.50% |
-2.64% |
2.99% |
-8.59% |
-20.21% |
-5.46% |
|
|
|
|
Should increase |
|
or be stable. |
|
| Diff from Median |
-46.7% |
-31.6% |
-20.6% |
-8.6% |
4.2% |
-17.6% |
-10.3% |
-4.2% |
18.3% |
15.1% |
18.6% |
8.4% |
-13.5% |
-18.2% |
|
|
|
0.00 |
<-Median-> |
10 |
OPM |
|
| *Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
|
|
|
OPM |
10 Yrs |
38.36% |
5 Yrs |
44.17% |
|
|
|
|
should be |
zero, it is a |
|
check on
calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
$191.95 |
$231.27 |
$162.00 |
$184.03 |
$175.25 |
$261.32 |
$339.90 |
$256.83 |
$250.30 |
$280.9 |
$307.6 |
$327.7 |
$418.4 |
$350.7 |
|
|
|
Liquidity ratio of 1.5 and up, best |
|
|
| Current Liabilities |
$240.87 |
$269.45 |
$308.61 |
$596.57 |
$1,821.05 |
$1,693.92 |
$2,248.55 |
$2,046.64 |
$1,712.30 |
$2,094.3 |
$1,935.1 |
$1,806.6 |
$3,098.2 |
$3,150.6 |
|
|
|
0.15 |
<-Median-> |
10 |
Ratio |
|
| Liquidity Ratio |
0.80 |
0.86 |
0.52 |
0.31 |
0.10 |
0.15 |
0.15 |
0.13 |
0.15 |
0.13 |
0.16 |
0.18 |
0.14 |
0.11 |
|
|
|
0.15 |
<-Median-> |
5 |
Ratio |
|
| Liq. with CF aft div |
|
|
|
0.51 |
0.21 |
0.21 |
0.20 |
0.20 |
0.30 |
0.24 |
0.37 |
0.40 |
0.17 |
0.21 |
|
|
|
0.30 |
<-Median-> |
5 |
Ratio |
|
| Liq. CF re Inv+Div |
|
|
|
0.32 |
0.19 |
0.14 |
0.12 |
0.12 |
0.22 |
0.13 |
0.31 |
0.25 |
0.12 |
0.21 |
|
|
|
0.22 |
<-Median-> |
5 |
Ratio |
|
| Less LTD, Com Paper |
|
|
|
$386.58 |
$1,555.36 |
$1,351.13 |
$1,597.44 |
$1,427.52 |
$1,384.4 |
$1,738.5 |
$1,492.7 |
$1,262.1 |
$2,369.4 |
$2,462.2 |
|
|
|
$1,492.70 |
<-Median-> |
5 |
Ratio |
|
| Liquidity Ratio |
|
|
|
0.88 |
0.66 |
0.76 |
0.52 |
0.41 |
0.76 |
0.79 |
0.70 |
0.60 |
0.57 |
0.51 |
|
|
|
0.70 |
<-Median-> |
5 |
Ratio |
|
| Less debt plus CF aft
div |
|
|
|
1.44 |
1.44 |
1.01 |
0.70 |
0.65 |
1.57 |
1.44 |
1.62 |
1.33 |
0.74 |
0.98 |
|
|
|
1.44 |
<-Median-> |
5 |
Ratio |
|
| Actual Cash Dividend
Paid |
|
|
|
$194.49 |
$156.60 |
$76.26 |
$91.49 |
$158.60 |
$403.60 |
$470.4 |
$302.5 |
$327.8 |
$347.3 |
$350.9 |
|
|
|
$347.30 |
<-Median-> |
5 |
Ratio |
|
| Change |
|
|
|
|
-19.48% |
-51.30% |
19.97% |
73.34% |
154.48% |
16.55% |
-35.69% |
8.36% |
5.95% |
1.04% |
|
|
|
|
|
|
|
|
| Less debt, plus CF aft
cash D |
|
|
|
1.61 |
1.80 |
1.63 |
1.10 |
1.08 |
1.85 |
1.73 |
2.34 |
1.98 |
1.25 |
1.02 |
|
|
|
1.85 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Assets |
$3,550 |
$4,126 |
$4,473 |
$4,712 |
$4,768 |
$5,590 |
$7,658 |
$8,647 |
$9,029 |
$10,152 |
$10,362 |
$11,462 |
$12,951.4 |
$13,240.0 |
|
|
|
Debt Ratio of 1.5 and up, best |
|
|
|
| Liabilities |
$2,486 |
$2,996 |
$3,153 |
$3,379 |
$3,348 |
$3,931 |
$5,273 |
$5,273 |
$5,873 |
$6,964 |
$6,898 |
$7,496 |
$8,862.1 |
$9,092.6 |
|
|
|
1.46 |
<-Median-> |
10 |
Ratio |
|
| Debt Ratio |
1.43 |
1.38 |
1.42 |
1.39 |
1.42 |
1.42 |
1.45 |
1.64 |
1.54 |
1.46 |
1.50 |
1.53 |
1.46 |
1.46 |
|
|
|
1.50 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Book Value |
$1,064 |
$1,130 |
$1,320 |
$1,333 |
$1,420 |
$1,659 |
$2,384 |
$3,374 |
$3,157 |
$3,188 |
$3,464 |
$3,965 |
$4,089.3 |
$4,147.4 |
$4,147 |
|
|
209.77% |
<-Total Growth |
10 |
Book Value |
|
| NCI |
|
|
|
|
|
$93 |
$284 |
$284 |
$336 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
#DIV/0! |
<-Total Growth |
7 |
NCI |
|
| Net Book Value |
$1,064 |
$1,130 |
$1,320 |
$1,333 |
$1,420 |
$1,566 |
$2,100 |
$3,090 |
$2,821 |
$3,188 |
$3,464 |
$3,965 |
$4,089 |
$4,147 |
$4,147 |
|
|
209.77% |
<-Total Growth |
10 |
Book Value |
|
| Book Value per share |
$4.82 |
$5.07 |
$5.18 |
$5.17 |
$5.37 |
$5.69 |
$6.85 |
$9.47 |
$8.39 |
$8.67 |
$9.12 |
$9.82 |
$9.72 |
$9.75 |
$9.75 |
|
|
87.50% |
<-Total Growth |
10 |
Book Value per Share |
|
| Increase |
-18.90% |
5.14% |
2.34% |
-0.35% |
4.05% |
5.90% |
20.28% |
38.36% |
-11.46% |
3.33% |
5.25% |
7.67% |
-1.02% |
0.30% |
0.00% |
|
|
-26.76% |
P/B Ratio |
|
Current/Historical Median |
|
| P/B Ratio (Median) |
1.93 |
1.61 |
1.70 |
2.52 |
3.10 |
3.64 |
3.53 |
3.41 |
3.33 |
2.83 |
2.85 |
2.26 |
2.32 |
1.46 |
|
|
|
1.72 |
P/B Ratio |
|
Historical Median |
|
| P/B Ratio (Close) |
1.97 |
1.39 |
2.09 |
2.89 |
3.47 |
4.13 |
3.77 |
3.79 |
2.65 |
3.42 |
2.85 |
1.97 |
2.32 |
1.26 |
1.26 |
|
|
6.49% |
<-IRR #YR-> |
10 |
Book Value per Share |
87.50% |
| Change |
29.44% |
-29.34% |
49.83% |
38.51% |
20.01% |
19.12% |
-8.62% |
0.57% |
-30.20% |
29.16% |
-16.56% |
-31.00% |
17.74% |
-45.68% |
0.00% |
|
|
0.52% |
<-IRR #YR-> |
5 |
Book Value per Share |
2.63% |
| Leverage (A/BK) |
3.34 |
3.65 |
3.39 |
3.54 |
3.36 |
3.37 |
3.21 |
2.56 |
2.86 |
3.18 |
2.99 |
2.89 |
3.17 |
3.19 |
|
|
|
3.18 |
<-Median-> |
10 |
A/BV |
|
| Debt/Equity Ratio |
2.34 |
2.65 |
2.39 |
2.54 |
2.36 |
2.37 |
2.21 |
1.56 |
1.86 |
2.18 |
1.99 |
1.89 |
2.17 |
2.19 |
|
|
|
2.18 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
| Sharerholders Equity
(Assets less liabilities) |
|
|
|
|
|
|
|
|
P/BV |
10 yr Med |
2.98 |
5 yr Med |
2.83 |
|
-57.73% |
Diff M/C |
|
2.86 |
Historical |
23 |
A/BV |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$5.18 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$9.47 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$9.72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$557.80 |
<-12 mths |
18.35% |
|
|
|
|
|
|
| Comprehensive Income |
|
|
|
|
|
$325.76 |
$30.81 |
$329.92 |
$542.20 |
$367.10 |
$573.40 |
$635.40 |
$471.3 |
|
|
|
|
44.68% |
<-Total Growth |
7 |
Comprehensive Income |
|
| NCI |
|
|
|
|
|
$9.83 |
$11.10 |
$14.65 |
$35.60 |
$27.90 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
-100.00% |
<-Total Growth |
7 |
NCI |
|
| Shareholders |
-$121.12 |
$236.64 |
$135.22 |
$207.20 |
$248.34 |
$315.93 |
$19.71 |
$315.27 |
$506.60 |
$339.20 |
$573.40 |
$635.40 |
$471.3 |
|
|
|
|
248.55% |
<-Total Growth |
10 |
Comprehensive Income |
|
| Increase |
|
295.37% |
-42.86% |
53.23% |
19.86% |
27.22% |
-93.76% |
1499.94% |
60.69% |
-33.04% |
69.04% |
10.81% |
-25.83% |
|
|
|
|
10.81% |
<-Median-> |
5 |
Comprehensive Income |
|
| 5 Yr Running Average |
|
|
|
|
$141.25 |
$228.66 |
$185.28 |
$221.29 |
$281.17 |
$299.34 |
$350.83 |
$473.97 |
$505.18 |
|
|
|
|
13.30% |
<-IRR #YR-> |
10 |
Comprehensive Income |
248.55% |
| ROE |
-11.4% |
20.9% |
10.2% |
15.5% |
17.5% |
19.0% |
0.8% |
9.3% |
16.0% |
10.6% |
16.6% |
16.0% |
11.5% |
|
|
|
|
8.37% |
<-IRR #YR-> |
5 |
Comprehensive Income |
49.49% |
| 5Yr Median |
|
|
|
12.9% |
15.5% |
17.5% |
15.5% |
15.5% |
16.0% |
10.6% |
10.6% |
16.0% |
16.0% |
|
|
|
|
17.27% |
<-IRR #YR-> |
8 |
5 Yr Running Average |
#DIV/0! |
| % Difference from NI |
51.4% |
-5.2% |
-14.2% |
-11.7% |
0.2% |
2.9% |
-133.9% |
-5.8% |
18.5% |
-24.6% |
8.9% |
7.2% |
-12.6% |
|
|
|
|
17.95% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
128.29% |
| Median Values |
|
|
|
|
|
|
|
|
|
Diff |
5, 10 yr |
-2.8% |
7.2% |
|
|
|
|
16.0% |
<-Median-> |
5 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$135.2 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$471.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$315.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$471.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$141.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$505.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$221.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$505.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liability
Coverage Ratio |
0.97 |
1.19 |
0.91 |
0.59 |
0.25 |
0.22 |
0.21 |
0.28 |
0.44 |
0.38 |
0.53 |
0.60 |
0.27 |
0.22 |
|
|
|
|
|
|
CFO / Current Liabilities |
|
| 5 year Median |
1.26 |
1.19 |
1.16 |
0.97 |
0.91 |
0.59 |
0.25 |
0.25 |
0.25 |
0.28 |
0.38 |
0.44 |
0.44 |
0.38 |
|
|
|
0.44 |
<-Median-> |
5 |
Current Liability Cov Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Asset Efficiency Ratio |
6.59% |
7.78% |
6.30% |
7.42% |
9.66% |
6.71% |
6.12% |
6.61% |
8.42% |
7.94% |
9.93% |
9.41% |
6.49% |
5.30% |
|
|
|
|
|
|
CFO / Total Assets |
|
| 5 year Median |
7.68% |
7.78% |
7.78% |
7.42% |
7.42% |
7.42% |
6.71% |
6.71% |
6.71% |
6.71% |
7.94% |
8.42% |
8.42% |
7.94% |
|
|
|
8.4% |
<-Median-> |
5 |
Return on Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Return on Assets ROA |
-2.3% |
6.1% |
3.5% |
5.0% |
5.2% |
5.5% |
-0.8% |
3.9% |
4.7% |
4.4% |
5.1% |
5.2% |
4.2% |
2.1% |
|
|
|
Net |
Income/Assets |
|
Return on Assets |
|
| 5Yr Median |
4.3% |
4.7% |
4.3% |
5.0% |
5.0% |
5.2% |
5.0% |
5.0% |
4.7% |
4.4% |
4.4% |
4.7% |
4.7% |
4.4% |
|
|
|
4.9% |
<-Median-> |
10 |
Asset Efficiency Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Return on Equity ROE |
-7.5% |
22.1% |
11.9% |
17.6% |
17.5% |
18.5% |
-2.4% |
9.9% |
13.5% |
14.1% |
15.2% |
14.9% |
13.2% |
6.8% |
|
|
|
Net Inc/ |
Shareholders' equity |
|
Return on Equity |
|
| 5Yr Median |
7.6% |
8.6% |
10.9% |
11.9% |
17.5% |
17.6% |
17.5% |
17.5% |
13.5% |
13.5% |
13.5% |
14.1% |
14.1% |
14.1% |
|
|
|
14.5% |
<-Median-> |
10 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$529.800 |
<-12 mths |
-1.71% |
|
|
|
|
|
|
| Net Income |
|
|
|
|
|
$316.98 |
-$47.00 |
$349.48 |
$463.00 |
$477.60 |
$526.70 |
$592.50 |
$539.0 |
|
|
|
|
70.04% |
<-Total Growth |
7 |
Net Income |
|
| NCI |
|
|
|
|
|
$9.83 |
$11.10 |
$14.65 |
$35.60 |
$27.90 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
-100.00% |
<-Total Growth |
7 |
NCI |
|
| Shareholders |
-$80.02 |
$249.70 |
$157.68 |
$234.77 |
$247.93 |
$307.15 |
-$58.10 |
$334.83 |
$427.40 |
$449.70 |
$526.70 |
$592.50 |
$539.0 |
$284 |
$306 |
$353 |
|
241.83% |
<-Total Growth |
10 |
Shareholders |
|
| Increase |
-161.27% |
-412% |
-36.85% |
48.89% |
5.61% |
23.89% |
-118.91% |
-676.36% |
27.65% |
5.22% |
17.12% |
12.49% |
-9.03% |
-47.31% |
7.75% |
15.36% |
|
EPS/CF Ratio should not be higher than 1.00 |
|
| 5 Yr Running Average |
$46.9 |
$94.1 |
$109.4 |
$138.5 |
$162.0 |
$239.4 |
$177.9 |
$213.3 |
$251.8 |
$292.2 |
$336.1 |
$466.2 |
$507.1 |
$478.4 |
$449.6 |
$414.9 |
|
13.08% |
<-IRR #YR-> |
10 |
Net Income |
241.83% |
| Operating Cash Flow |
$234.08 |
$321.14 |
$281.79 |
$349.57 |
$460.50 |
$375.25 |
$468.67 |
$571.67 |
$760.50 |
$805.90 |
$1,028.40 |
$1,078.10 |
$841.10 |
|
|
|
|
9.99% |
<-IRR #YR-> |
5 |
Net Income |
60.98% |
| Investment Cash Flow |
-$652.61 |
-$613.94 |
-$604.13 |
-$331.51 |
-$143.82 |
-$738.59 |
-$1,554.09 |
-$1,347.4 |
-$616.3 |
-$1,869.2 |
-$349.5 |
-$1,145.7 |
-$1,469.4 |
|
|
|
|
16.57% |
<-IRR #YR-> |
10 |
5 Yr Running Ave. |
363.30% |
| Total Accruals |
$338.51 |
$542.49 |
$480.03 |
$216.71 |
-$68.75 |
$670.49 |
$1,027.32 |
$1,110.57 |
$283.20 |
$1,513.00 |
-$152.20 |
$660.10 |
$1,167.30 |
|
|
|
|
18.91% |
<-IRR #YR-> |
5 |
5 Yr Running Ave. |
137.70% |
| Total Assets |
$3,550 |
$4,126 |
$4,473 |
$4,712 |
$4,768 |
$5,590 |
$7,658 |
$8,647 |
$9,029 |
$10,152 |
$10,362 |
$11,462 |
$12,951 |
|
|
|
|
|
Balance Sheet |
|
Assets |
|
| Accruals Ratio |
9.54% |
13.15% |
10.73% |
4.60% |
-1.44% |
11.99% |
13.42% |
12.84% |
3.14% |
14.90% |
-1.47% |
5.76% |
9.01% |
|
|
|
|
5.76% |
<-Median-> |
5 |
Ratio |
|
| EPS/CF Ratio |
-0.35 |
0.89 |
0.57 |
0.70 |
0.64 |
0.74 |
-0.13 |
0.59 |
0.56 |
0.57 |
0.54 |
0.57 |
0.68 |
|
|
|
|
0.58 |
<-Median-> |
10 |
EPS/CF Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$157.7 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$539.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$334.8 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$539.0 |
|
|
|
|
|
|
|
|
|
|
|
|
-$109.4 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$507.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$213.3 |
$0.0 |
$0.0 |
$0.0 |
$0.0 |
$507.1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chge in Close |
4.98% |
-25.71% |
53.33% |
38.02% |
24.87% |
26.14% |
9.91% |
39.14% |
-38.20% |
33.45% |
-12.18% |
-25.70% |
16.55% |
-45.52% |
0.00% |
0.00% |
|
|
Count |
23 |
Years of data |
|
| up/down/neutral |
|
down |
down |
down |
|
|
down |
down |
down |
|
down |
|
down |
down |
|
|
|
|
Count |
16 |
69.57% |
|
| Any Predictions? |
|
yes |
|
|
|
|
|
|
Yes |
|
Yes |
|
|
|
|
|
|
% right |
Count |
7 |
43.75% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Financial Cash Flow |
$416.90 |
$293.70 |
$328.33 |
-$12.95 |
-$289.38 |
$377.63 |
$1,064.30 |
$790.27 |
-$167.30 |
$1,046.50 |
-$672.90 |
$87.50 |
$615.2 |
|
|
|
|
|
C F Statement |
|
Financial Cash Flow |
|
| Total Accruals |
-$78.39 |
$248.80 |
$151.70 |
$229.66 |
$220.63 |
$292.86 |
-$36.98 |
$320.31 |
$450.50 |
$466.50 |
$520.70 |
$572.60 |
$552.1 |
|
|
|
|
|
|
|
Accruals |
|
| Accruals Ratio |
-2.21% |
6.03% |
3.39% |
4.87% |
4.63% |
5.24% |
-0.48% |
3.70% |
4.99% |
4.60% |
5.03% |
5.00% |
4.26% |
|
|
|
|
4.99% |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
|
|
|
$22.51 |
$50.02 |
$63.90 |
$47.24 |
$61.10 |
$40.30 |
$21.40 |
$26.90 |
$46.20 |
$32.6 |
$32.0 |
|
|
|
|
|
|
Cash |
|
| Cash per Share |
|
|
|
$0.09 |
$0.19 |
$0.23 |
$0.15 |
$0.19 |
$0.12 |
$0.06 |
$0.07 |
$0.11 |
$0.08 |
$0.08 |
|
|
|
$0.08 |
<-Median-> |
5 |
Cash per Share |
|
| Percentage of Stock
Price |
|
|
|
0.58% |
1.02% |
0.99% |
0.60% |
0.52% |
0.54% |
0.20% |
0.27% |
0.59% |
0.34% |
0.61% |
|
|
|
0.34% |
<-Median-> |
5 |
% of Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Notes: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| July 5,
2020. Last estimates were for 2019,
2020 and 2021 of $2495M, $5593M and $2705M for Revenue, $1.28, $1.32 and
$1.23 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
| $1.72, $1.75
and $1.79 for Dividends, $2.34 and $2.46 for CFPS for 2019 and 2020 and
$467M, $537M and $489M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| July 13,
2019. Last estimates were for 2382M,
$2318 and $2315 for Revenue, $1.51, $1.42 and $1.33 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| $2.60, $2.42
and $2.43 for CPFS and $577M, $539M and $545M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| July 8,
2018. Last estimates were for 2017,
2018 and 2019 of $2184M. $2199M and $2279M for Revenue, $1.47, $1.55 and
$1.51 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
| $$2.64, $2.65
and $2.61 for CFPS and $506M, $600M and $574M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| July 8,
2017. Last estimates were for 2016,
2017 and 2018 of $1750M, $1794M and $1770M for Revenue, $1.32, $1.40 and
$1.54 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
| $2.21, $2.26
and $2.22 for CFPS and $453M, $478M and $555M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| July 07,
2016. Last estimates were for 2015 and
2016 of $1794M and $1859M for Revenue, $1.47 and $1.66 for EPS, $2.28 and
$2.28 for CFPS and $548 and $547 for Net Income. |
|
|
|
|
|
|
|
|
|
|
| July 18,
2015. Last estimates were for 2014,
2015 and 2016 of $1581M, $1794M and $1859M for Revenue, $1.14, $1.47 and
$1.66 for EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
| $1.64, $2.28
and 2.28 for CFPS and $383M, $548M and $547M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| July 21,
2014. Last estimaes were for 2013,
2014 and 2015 of $1301M, $1280M and $1549M for Revenue, $0.82, $1.11 and
$1.33 for EPS, $1.44, 1.56 and $1.72 for CFPS. |
|
|
|
|
|
|
|
|
|
|
|
| In 2013
Class A and Class B shares were cancelled and exchanged for common
Shares. Some preferred were issued
too, but they seem to have gone also. |
|
|
|
|
|
|
|
|
|
|
|
|
| Loss is due
to non-cash General Partner internalization expense costs of $349M in
connection with the company's reorganziation. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| June 12,
2013. Last estimates were for 2011 and
2012 of EPS $0.99 and $0.97 and CFPS of $1.52 and 1.50. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jan 7,
2012. Last I looked I got estimates
for 2010 and 2011 of $.91 and $.81 for EPS and $1.28 and $1.38 for CF. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jan 7, 2012.
They have credit facilities set up to handle their debt, including the
current portion of the long term debt. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dec 18,
2010. The last time I looked, I got
2009 estimates for earnings of $.65 and Cash Flow of $1.09 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Old name:
Koch Pipelines Canada L. P. started 1997 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Inter
Pipeline was a Limited Partnership. It
became a corporation in 2013. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Pipeline
Assets Corp. was bought with Preferred Shares in IPL. Preferred are worth the same as Class A
Shares. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Probably in
2013, Preferred shares will be converted to Class A Shares. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Annual
statements are released at the end of February. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sector: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Infrastructure,Utility |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| What should this stock
accomplish? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This stock
should produce a good dividend yield and low to moderate dividend growth over
the longer term. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Would I buy this
company and Why. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This is a
dividend growth stock, so I should say yest to Buy. At the moment I probably will not buy it
because I have enough pipeline stocks already. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| It would not
be my favourite utility stock as I would be concerned about the debt ratios. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Why am I following this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| In 2008, a
friend had asked me about this pipeline and I had no information on it, so I
investigated it. It is a utility and I
follow lots of utility stocks. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| They used to
be a Limited Partnership and they changed to a corporation in 2013. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dividends are
paid monthly. Dividends are declared
in one month for payment in the following month. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| For example,
the cash dividend declared for March 2014 was for shareholders of recird if
March 21, 21014 and was paid on April 15, 2014. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| How they make their
money. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Inter
Pipeline operates crude oil pipelines, natural gas liquids extraction, and
bulk liquid storage businesses in Canada and Europe. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Pipeline
Management Inc., the general partner of Inter Pipeline, holds a 0.1%
partnership interest represented by Class B units and public unitholders hold
the remaining |
|
|
|
|
|
|
|
|
|
|
|
| 99.9%
partnership interest, as limited partners, which are represented by Class A
units. Inter Pipeline's Class A units are widely held. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Inter
Pipeline currently makes monthly cash distributions to holders of the Class A
limited liability partnership units (Class A units) and Class B unlimited
liability partnership units (Class B units) |
|
|
|
|
|
|
|
|
|
| (collectively
Partnership units). Class A is what is
sold on TSX. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
%, 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 |
2012 |
Jun 12 |
2013 |
Jul 21 |
2014 |
Jul 18 |
2015 |
Jul 07 |
2016 |
Jul 07 |
2017 |
Jul 08 |
2018 |
Jul 13 |
2019 |
|
|
Jul 5 |
2020 |
|
|
|
| Bayle, Christian |
|
|
|
0.223 |
0.07% |
0.435 |
0.13% |
0.450 |
0.12% |
0.450 |
0.12% |
0.460 |
0.11% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
Ceased insider Sept 2013 |
#DIV/0! |
| CEO - Shares - Amount |
|
|
|
|
$8.027 |
|
$9.662 |
|
$13.338 |
|
$11.714 |
|
$8.896 |
|
$0.000 |
|
|
|
$0.000 |
|
Last filing Feb 2019 |
|
| Options - percentage |
|
|
|
0.448 |
0.14% |
0.574 |
0.17% |
0.611 |
0.17% |
0.615 |
0.16% |
0.630 |
0.16% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
#DIV/0! |
| Options - amount |
|
|
|
|
$16.119 |
|
$12.752 |
|
$18.101 |
|
$16.012 |
|
$12.180 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Heagy, Brent |
|
|
|
0.004 |
0.00% |
0.010 |
0.00% |
0.015 |
0.00% |
0.020 |
0.01% |
0.010 |
1.00% |
0.028 |
0.01% |
|
|
0.033 |
0.01% |
|
|
17.86% |
| CFO - Shares - Amount |
|
|
|
|
$0.144 |
|
$0.222 |
|
$0.430 |
|
$0.521 |
|
$0.193 |
|
$0.631 |
|
|
|
$0.405 |
|
|
|
| Options - percentage |
|
|
|
0.024 |
0.01% |
0.074 |
0.02% |
0.100 |
0.03% |
0.111 |
0.03% |
0.118 |
0.03% |
0.134 |
0.03% |
|
|
0.151 |
0.04% |
|
|
12.83% |
| Options - amount |
|
|
|
|
$0.873 |
|
$1.645 |
|
$2.974 |
|
$2.885 |
|
$2.282 |
|
$3.020 |
|
|
|
$1.857 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chappell, David Micheal |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.018 |
0.00% |
|
|
0.028 |
0.01% |
|
Last filing Feb 2019 |
56.66% |
| Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.398 |
|
|
|
$0.340 |
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.423 |
0.10% |
|
|
0.374 |
0.09% |
|
|
-11.62% |
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$9.543 |
|
|
|
$4.595 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Arsenych, Stephen James |
|
0.000 |
0.00% |
0.010 |
0.00% |
0.010 |
0.00% |
0.015 |
0.00% |
0.015 |
0.00% |
0.015 |
0.00% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
Ceased Inisder Sep 2013 |
|
| Officer - Shares -
Amount |
|
|
$0.000 |
|
$0.359 |
|
$0.222 |
|
$0.445 |
|
$0.390 |
|
$0.290 |
|
$0.000 |
|
|
|
$0.000 |
|
Last filing Feb 2020 |
|
| Options - percentage |
|
0.057 |
0.02% |
0.162 |
0.05% |
0.183 |
0.05% |
0.180 |
0.05% |
0.175 |
0.05% |
0.186 |
0.05% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
|
| Options - amount |
|
|
$1.476 |
|
$5.811 |
|
$4.063 |
|
$5.349 |
|
$4.560 |
|
$3.589 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| van Yzerloo, William
Arnold |
|
0.000 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| CFO - Shares - Amount |
|
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
|
0.185 |
0.06% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - amount |
|
|
$4.768 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Brigstocke, Nicholas |
|
0.000 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Officer - Shares -
Amount |
|
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
|
0.007 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - amount |
|
|
$0.187 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Fesyk, David William |
|
0.667 |
0.20% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
was CFO |
|
| Director - Shares -
Amount |
|
|
$23.974 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
was A to 2013 |
|
| Cl A & B pref -
Common |
|
0.635 |
0.19% |
|
|
1.302 |
0.39% |
1.302 |
0.35% |
1.302 |
0.34% |
1.302 |
0.32% |
|
|
|
|
|
|
|
was B to 2013 |
|
| Amount |
|
|
$22.821 |
|
|
|
$28.918 |
|
$38.592 |
|
$33.892 |
|
$25.181 |
|
|
|
|
|
|
|
Now Director |
|
| Options - percentage |
|
0.359 |
0.11% |
|
|
1.081 |
0.32% |
0.997 |
0.27% |
0.941 |
0.25% |
0.914 |
0.23% |
|
|
|
|
|
|
|
|
|
| Options - amount |
|
|
$12.888 |
|
|
|
$24.012 |
|
$29.539 |
|
$24.498 |
|
$17.676 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cella, Peter Louis |
|
|
|
|
|
|
|
|
|
|
|
0.020 |
0.00% |
0.030 |
0.01% |
|
|
0.045 |
0.01% |
|
|
50.00% |
| Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.387 |
|
$0.676 |
|
|
|
$0.553 |
|
|
|
| Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
0.003 |
0.00% |
0.010 |
0.00% |
|
|
0.015 |
0.00% |
|
|
58.40% |
| Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.066 |
|
$0.216 |
|
|
|
$0.186 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Brown, Lorne Easton |
|
|
|
0.000 |
0.00% |
0.007 |
0.00% |
0.008 |
0.00% |
0.008 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
| Director - Shares -
Amount |
|
|
|
|
$0.000 |
|
$0.145 |
|
$0.231 |
|
$0.216 |
|
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
|
|
|
0.036 |
0.01% |
0.042 |
0.01% |
0.043 |
0.01% |
0.042 |
0.01% |
|
|
|
|
|
|
|
|
|
|
|
| Options - amount |
|
|
|
|
$1.281 |
|
$0.932 |
|
$1.272 |
|
$1.105 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Driscoll, John Fenbar |
|
5.114 |
1.57% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Old Chairman, retired |
|
| Director - Shares -
Amount |
|
|
$183.799 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
was A to 2013 |
|
| Class A & B
preferreds |
|
4.686 |
1.44% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
was B to 2013 |
|
| Percentage |
|
|
$168.423 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Class A Units Amounts |
|
0.008 |
0.00% |
5.122 |
1.67% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Percentage |
|
|
$0.196 |
|
$132.292 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - percentage |
|
0.005 |
0.00% |
0.005 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Options - amount |
|
|
$0.129 |
|
$0.129 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Shaw, Richard A. |
|
|
|
0.021 |
0.01% |
0.022 |
0.01% |
0.024 |
0.01% |
0.024 |
0.01% |
0.028 |
0.01% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
Ceased insider Sep 2013 |
|
| Chairman - Shares - Amt |
|
|
|
|
$0.545 |
|
$0.478 |
|
$0.715 |
|
$0.626 |
|
$0.543 |
|
$0.000 |
|
|
|
$0.000 |
|
Last filing Feb 2020 |
|
| Options - percentage |
|
|
|
0.254 |
0.08% |
0.035 |
0.01% |
0.038 |
0.01% |
0.038 |
0.01% |
0.039 |
0.01% |
0.000 |
0.00% |
|
|
0.000 |
0.00% |
|
|
|
| Options - amount |
|
|
|
|
$6.548 |
|
$0.783 |
|
$1.135 |
|
$0.978 |
|
$0.761 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Rights Exercised |
|
|
|
0.794 |
0.26% |
0.580 |
0.18% |
0.581 |
0.17% |
0.566 |
0.15% |
0.453 |
0.12% |
0.640 |
0.16% |
|
|
0.572 |
0.14% |
|
paid in cash |
|
| Cost at year end |
|
|
|
|
$20.515 |
|
$20.849 |
|
$12.902 |
|
$16.767 |
|
$11.799 |
|
$12.368 |
|
|
|
$12.902 |
|
Search for |
|
| Increased Expenses |
|
|
|
|
$23.800 |
|
$30.300 |
|
$2.400 |
|
$25.100 |
|
$14.800 |
|
$11.100 |
|
|
|
$0.000 |
|
Long-term Incentive Plan |
|
| Insider Buying |
|
|
|
|
|
|
-$1.506 |
|
-$1.526 |
|
-$1.299 |
|
-$1.850 |
|
-$0.971 |
|
|
|
-$1.638 |
|
|
|
| Insider Selling |
|
|
|
|
|
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
$0.000 |
|
|
|
$0.000 |
|
|
|
| Net Insider Selling |
|
|
|
|
-$1.674 |
|
-$1.506 |
|
-$1.526 |
|
-$1.299 |
|
-$1.850 |
|
-$0.971 |
|
|
|
-$1.638 |
|
|
|
| % of Market Cap |
|
|
|
|
-0.01% |
|
-0.02% |
|
-0.01% |
|
-0.01% |
|
-0.02% |
|
-0.01% |
|
|
|
-0.03% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Directors |
|
6 |
|
7 |
|
7 |
|
8 |
|
9 |
|
11 |
|
10 |
|
|
|
11 |
|
|
|
|
| Women |
|
0 |
0% |
1 |
14% |
1 |
14% |
2 |
25% |
2 |
22% |
3 |
27% |
3 |
30% |
|
|
4 |
36% |
|
|
|
| Minorities |
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
|
|
0 |
0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Institutions/Holdings |
|
|
|
87 |
16.76% |
149 |
22.35% |
180 |
28.93% |
196 |
28.93% |
206 |
27.69% |
225 |
30.19% |
|
|
20 |
23.03% |
|
|
|
| Total Shares Held |
|
|
|
54.119 |
16.59% |
74.838 |
22.25% |
97.460 |
26.49% |
103.547 |
27.26% |
106.771 |
26.44% |
124.080 |
29.49% |
|
|
94.961 |
22.32% |
|
|
|
| Increase/Decrease |
3.84% |
|
|
0.799 |
1.50% |
0.286 |
0.38% |
-0.738 |
-0.75% |
-1.216 |
-1.16% |
1.256 |
1.19% |
2.532 |
2.08% |
|
|
6.709 |
7.60% |
|
|
|
| Starting No. of Shares |
|
|
|
53.320 |
|
74.551 |
|
98.198 |
|
104.763 |
|
105.514 |
|
121.547 |
|
|
|
88.252 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Copyright ©
2008 Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|