This report is for educational purposes only, and not to provide
investment advice. Before making any
investment decision, you should always do your own research or consult a
investment professional. |
Estimates |
Estimates |
Estimates |
|
|
|
|
|
|
|
While I try
to be accurate, I assume no responsibility for any figure in this
spreadsheet. |
|
|
|
|
|
|
|
|
|
Q1 2024 |
<-Estimates |
|
|
|
https://www.annualreports.com/Company/enbridge-inc |
|
See my website
on stocks or see my blog at the following sites. |
|
|
|
|
https://spbrunner.com/stocks.html |
|
https://spbrunner.blogspot.com/ |
3/31/24 |
<-Estimates |
|
|
|
|
|
|
|
|
Enbridge Inc |
|
|
|
|
|
TSX |
ENB |
NYSE |
ENB |
https://www.enbridge.com/ |
Fiscal Yr: |
Dec 31 |
|
|
|
|
|
|
|
|
|
|
Year |
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/31/20 |
12/31/21 |
12/31/22 |
12/31/23 |
12/31/24 |
12/31/25 |
12/31/26 |
|
Value |
Description |
#Y |
Item |
Total G |
|
Accounting Rules |
C GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
US GAAP |
|
|
|
|
Accounting Rules |
|
|
EDG yr end (gas) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Split Date |
May 11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Split Date |
|
|
Split |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Split |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$45,008 |
<-12 mths |
3.11% |
|
|
|
|
Estimates |
|
|
Revenue* |
$19,402 |
$25,306 |
$32,918 |
$37,641 |
$33,794 |
$34,560 |
$44,378 |
$46,378 |
$50,069 |
$39,087 |
$47,071 |
$53,309 |
$43,649 |
$45,397 |
$48,324 |
$49,862 |
|
32.60% |
<-Total Growth |
10 |
Revenue |
|
|
Increase |
28.26% |
30.43% |
30.08% |
14.35% |
-10.22% |
2.27% |
28.41% |
4.51% |
7.96% |
-21.93% |
20.43% |
13.25% |
-18.12% |
4.00% |
6.45% |
3.18% |
|
2.86% |
<-IRR #YR-> |
10 |
Revenue |
32.60% |
|
5 year Running Average |
$15,009 |
$17,686 |
$21,044 |
$26,079 |
$29,812 |
$32,844 |
$36,658 |
$39,350 |
$41,836 |
$42,894 |
$45,397 |
$47,183 |
$46,637 |
$45,703 |
$47,550 |
$48,108 |
|
-1.21% |
<-IRR #YR-> |
5 |
Revenue |
-5.88% |
|
Revenue per Share |
$24.84 |
$31.44 |
$39.61 |
$44.18 |
$38.93 |
$36.65 |
$26.18 |
$22.94 |
$24.73 |
$19.29 |
$23.23 |
$26.33 |
$20.54 |
$21.36 |
$22.74 |
$23.46 |
|
8.28% |
<-IRR #YR-> |
10 |
5 yr Running Average |
121.62% |
|
Increase |
26.45% |
26.54% |
26.01% |
11.53% |
-11.88% |
-5.87% |
-28.56% |
-12.39% |
7.80% |
-21.97% |
20.43% |
13.31% |
-21.97% |
4.00% |
6.45% |
3.18% |
|
3.46% |
<-IRR #YR-> |
5 |
5 yr Running Average |
18.52% |
|
5 year Running Average |
$20.03 |
$22.97 |
$26.41 |
$31.94 |
$35.80 |
$38.16 |
$37.11 |
$33.78 |
$29.89 |
$25.96 |
$23.27 |
$23.30 |
$22.82 |
$22.15 |
$22.84 |
$22.89 |
|
-6.36% |
<-IRR #YR-> |
10 |
Revenue per Share |
-48.15% |
|
P/S (Price/Sales) Med |
1.32 |
1.26 |
1.14 |
1.20 |
1.37 |
1.37 |
1.95 |
2.09 |
1.91 |
2.36 |
2.06 |
2.07 |
2.41 |
2.22 |
0.00 |
0.00 |
|
-2.18% |
<-IRR #YR-> |
5 |
Revenue per Share |
-10.45% |
|
P/S (Price/Sales) Close |
1.53 |
1.37 |
1.17 |
1.35 |
1.18 |
1.54 |
1.88 |
1.85 |
2.09 |
2.11 |
2.13 |
2.01 |
2.32 |
2.27 |
2.13 |
2.07 |
|
-1.45% |
<-IRR #YR-> |
10 |
5 yr Running Average |
-13.56% |
|
*Revenue in M CDN
$ |
|
|
|
|
|
|
|
|
P/S |
10 yr |
1.94 |
5 yr |
2.11 |
|
16.91% |
Diff M/C |
|
-7.54% |
<-IRR #YR-> |
5 |
5 yr Running Average |
-32.43% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$32,918 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$43,649 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$46,378 |
$0 |
$0 |
$0 |
$0 |
$43,649 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$21,044 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$46,637 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$39,350 |
$0 |
$0 |
$0 |
$0 |
$46,637 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$39.61 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$20.54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$22.94 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$20.54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$26.41 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$33.78 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$22.82 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ACFFO ->Distributed
CF (DCF) |
|
|
$2,527 |
$2,506 |
$3,154 |
$3,713 |
$5,614 |
$7,618 |
$9,224 |
$9,440 |
$10,041 |
$10,986 |
$11,267 |
|
|
|
|
345.86% |
<-Total Growth |
10 |
ACFFO ->Distr.CF (DCF) |
|
|
DCF per Diluted Share |
|
|
2.01% |
$2.61 |
$3.68 |
$4.04 |
$3.66 |
$4.41 |
$4.57 |
$4.67 |
$4.93 |
$5.42 |
$5.48 |
|
|
|
|
27163.68% |
<-Total Growth |
10 |
DCF per Diluted Share |
|
|
DCF* |
$2.59 |
$2.30 |
$2.01 |
$2.61 |
$3.68 |
$4.08 |
$3.68 |
$4.42 |
$4.57 |
$4.67 |
$4.96 |
$5.42 |
$5.48 |
$5.46 |
$5.75 |
|
|
172.64% |
<-Total Growth |
10 |
DCF |
|
|
Increase |
|
-11.20% |
-12.61% |
29.85% |
41.00% |
10.75% |
-9.68% |
20.03% |
3.42% |
2.19% |
6.21% |
9.27% |
1.11% |
-0.36% |
5.31% |
|
|
10 |
0 |
10 |
Years of Data, AFFP, P or N |
100.00% |
|
AFFO Yield |
6.80% |
5.35% |
4.33% |
4.37% |
8.00% |
7.21% |
7.49% |
10.42% |
8.85% |
11.47% |
10.04% |
10.24% |
11.49% |
11.25% |
11.84% |
|
|
8.59% |
<-IRR #YR-> |
9 |
DCF |
172.64% |
|
5 year Running Average |
|
|
|
|
$2.64 |
$2.94 |
$3.21 |
$3.69 |
$4.09 |
$4.28 |
$4.46 |
$4.81 |
$5.02 |
$5.20 |
$5.41 |
|
|
4.40% |
<-IRR #YR-> |
5 |
DCF |
24.02% |
|
Payout Ratio AFFO |
37.84% |
49.13% |
62.69% |
53.64% |
50.54% |
52.02% |
65.55% |
60.74% |
64.60% |
69.38% |
67.34% |
63.47% |
64.78% |
67.0% |
63.7% |
|
|
8.37% |
<-IRR #YR-> |
8 |
5 yr Running |
#DIV/0! |
|
5 year Running Average |
|
|
|
|
50.27% |
52.94% |
56.38% |
56.74% |
58.89% |
62.61% |
65.60% |
65.13% |
65.82% |
66.3% |
65.2% |
|
|
6.33% |
<-IRR #YR-> |
5 |
5 yr Running |
35.93% |
|
Price/AFFO Median |
12.62 |
17.20 |
22.52 |
20.29 |
14.53 |
12.31 |
13.87 |
10.83 |
10.34 |
9.77 |
9.64 |
10.04 |
9.05 |
8.68 |
0.00 |
|
|
10.19 |
<-Median-> |
10 |
P/AFFO Med |
|
|
Price/AFFO High |
14.71 |
18.70 |
24.20 |
23.00 |
17.89 |
14.50 |
15.78 |
13.15 |
11.40 |
12.23 |
10.86 |
10.99 |
10.23 |
9.10 |
0.00 |
|
|
11.81 |
<-Median-> |
10 |
P/AFFO High |
|
|
Price/AFFO Low |
10.53 |
15.70 |
20.83 |
17.57 |
11.17 |
10.12 |
11.95 |
8.51 |
9.28 |
7.30 |
8.42 |
9.09 |
7.87 |
8.27 |
0.00 |
|
|
8.80 |
<-Median-> |
10 |
P/AFFO Low |
|
|
Price/AFFO Close |
14.71 |
18.70 |
23.09 |
22.89 |
12.50 |
13.86 |
13.35 |
9.60 |
11.30 |
8.72 |
9.96 |
9.76 |
8.70 |
8.89 |
8.44 |
|
|
9.86 |
<-Median-> |
10 |
P/AFFO Close |
|
|
Trailing P/FFO Close |
|
16.61 |
20.18 |
29.72 |
17.62 |
15.35 |
12.06 |
11.52 |
11.68 |
8.91 |
10.58 |
10.67 |
8.80 |
8.86 |
8.89 |
|
|
11.60 |
<-Median-> |
10 |
Trailing P/AFFO Close |
|
|
Median Values |
|
DPR |
10 Yrs |
64.03% |
5 Yrs |
64.78% |
P/CF |
5 Yrs |
in order |
9.77 |
10.99 |
8.42 |
9.76 |
|
-8.96% |
Diff M/C |
|
-12.72% |
Diff M/C |
10 |
DPR 75% to 95% best |
|
|
*Distributed Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*ACFFO Available Cash Flow from Operations |
|
|
-$2.61 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$4.42 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.48 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.64 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3.69 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.02 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
131.14% |
128.87% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.74 |
<-12 mths |
-1.79% |
|
|
|
|
|
|
|
Diff EPS/AEPS |
-13.85% |
-107.69% |
-223.64% |
-36.50% |
5600.00% |
-18.13% |
-18.79% |
-81.51% |
-0.76% |
-63.51% |
4.53% |
-119.53% |
1.76% |
|
|
|
|
-18.46% |
<-Median-> |
10 |
Diff EPS/Adj |
|
|
Adjusted Earnings |
$1,081 |
$1,241 |
$1,434 |
$1,574 |
$1,866 |
$2,982 |
$2,078 |
$1,724 |
$5,341 |
$4,894 |
$5,551 |
$5,692 |
$5,743 |
|
|
|
|
300.49% |
<-Total Growth |
10 |
Adjusted Earnings |
|
|
Return on Equity ROE |
12.23% |
11.82% |
9.86% |
8.27% |
8.87% |
12.03% |
3.34% |
2.48% |
8.09% |
7.97% |
9.13% |
9.50% |
9.35% |
|
|
|
|
-5.19% |
<-Total Growth |
10 |
Adjusted Profit CDN$ |
|
|
5Yr Median |
|
|
|
|
9.86% |
9.86% |
8.87% |
8.27% |
8.09% |
7.97% |
7.97% |
8.09% |
9.13% |
|
|
|
|
8.27% |
<-Median-> |
9 |
Return on Equity ROE |
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
Adjusted EPS* |
$1.48 |
$1.62 |
$1.78 |
$1.87 |
$2.20 |
$2.28 |
$1.96 |
$2.65 |
$2.65 |
$2.42 |
$2.74 |
$2.81 |
$2.79 |
$2.80 |
$2.93 |
$3.27 |
|
56.74% |
<-Total Growth |
10 |
Adjusted EPS |
|
|
Increase |
11.28% |
9.46% |
9.88% |
5.06% |
17.65% |
3.64% |
-14.04% |
35.20% |
0.00% |
-8.68% |
13.22% |
2.55% |
-0.71% |
0.36% |
4.64% |
11.60% |
|
10 |
0 |
10 |
Years of Data, AFFP, P or N |
100.00% |
|
Adjusted EPS Yield |
3.89% |
3.77% |
3.84% |
3.13% |
4.78% |
4.04% |
3.99% |
6.25% |
5.13% |
5.94% |
5.55% |
5.31% |
5.85% |
5.77% |
6.04% |
6.74% |
|
4.60% |
<-IRR #YR-> |
10 |
Adjusted EPS |
56.74% |
|
5 year Running Average |
$1.16 |
$1.31 |
$1.48 |
$1.62 |
$1.79 |
$1.95 |
$2.02 |
$2.19 |
$2.35 |
$2.39 |
$2.48 |
$2.65 |
$2.68 |
$2.71 |
$2.81 |
$2.92 |
|
1.03% |
<-IRR #YR-> |
5 |
Adjusted EPS |
5.28% |
|
Payout Ratio |
66.22% |
69.75% |
70.79% |
74.87% |
84.55% |
92.98% |
123.11% |
101.28% |
111.40% |
133.88% |
121.90% |
122.42% |
127.24% |
130.71% |
124.91% |
111.93% |
|
6.15% |
<-IRR #YR-> |
10 |
5 yr Running Average |
81.58% |
|
5 year Running Average |
66.07% |
66.62% |
67.16% |
69.55% |
74.08% |
79.69% |
89.72% |
95.59% |
102.46% |
112.12% |
117.79% |
117.98% |
123.21% |
127.06% |
125.44% |
123.08% |
|
4.12% |
<-IRR #YR-> |
5 |
5 yr Running Average |
22.35% |
|
P/E Ratio Median |
22.08 |
24.42 |
25.43 |
28.31 |
24.30 |
22.00 |
26.05 |
18.05 |
17.83 |
18.85 |
17.45 |
19.36 |
17.77 |
16.93 |
0.00 |
0.00 |
|
19.10 |
<-Median-> |
10 |
Price/AEPS Median |
|
|
P/E Ratio High |
25.74 |
26.56 |
27.33 |
32.11 |
29.93 |
25.92 |
29.64 |
21.92 |
19.65 |
23.61 |
19.66 |
21.19 |
20.09 |
17.74 |
0.00 |
0.00 |
|
22.76 |
<-Median-> |
10 |
Price/AEPS High |
|
|
P/E Ratio Low |
18.43 |
22.28 |
23.52 |
24.52 |
18.68 |
18.08 |
22.45 |
14.18 |
16.00 |
14.09 |
15.24 |
17.53 |
15.46 |
16.12 |
0.00 |
0.00 |
|
16.77 |
<-Median-> |
10 |
Price/AEPS Low |
|
|
P/E Ratio Close |
25.74 |
26.56 |
26.07 |
31.95 |
20.91 |
24.78 |
25.08 |
16.00 |
19.48 |
16.82 |
18.03 |
18.83 |
17.10 |
17.34 |
16.57 |
14.85 |
|
19.16 |
<-Median-> |
10 |
Price/AEPS Close |
|
|
Trailing P/E Close |
28.64 |
29.07 |
28.65 |
33.56 |
24.60 |
25.68 |
21.56 |
21.64 |
19.48 |
15.36 |
20.42 |
19.31 |
16.98 |
17.40 |
17.34 |
16.57 |
|
20.99 |
<-Median-> |
10 |
Trailing P/AEPSClose |
|
|
* Adjusted
Earnings or ESP (see notes below) |
DPR |
10 Yrs |
116.65% |
5 Yrs |
122.42% |
P/CF |
5 Yrs |
in order |
17.83 |
20.09 |
15.46 |
18.03 |
|
|
|
|
-13.69% |
Diff Med/Curr |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.78 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.65 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.48 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2.19 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.79 |
<-12 mths |
-1.64% |
|
|
|
|
|
|
|
|
1.52% |
1.27% |
0.00% |
1.44% |
0.00% |
0.00% |
0.60% |
0.00% |
0.38% |
0.00% |
0.00% |
0.00% |
0.00% |
|
|
|
|
0.00 |
<-Median-> |
10 |
Difference Basic and Diluted |
|
|
EPS Basic |
$1.32 |
$0.79 |
$0.55 |
$1.39 |
-$0.04 |
$1.93 |
$1.66 |
$1.46 |
$2.64 |
$1.48 |
$2.87 |
$1.28 |
$2.84 |
|
|
|
|
416.36% |
<-Total Growth |
10 |
EPS Basic |
|
|
Pre-split '99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EPS Diluted* |
$1.30 |
$0.78 |
$0.55 |
$1.37 |
-$0.04 |
$1.93 |
$1.65 |
$1.46 |
$2.63 |
$1.48 |
$2.87 |
$1.28 |
$2.84 |
$2.84 |
$2.99 |
$3.64 |
|
416.36% |
<-Total Growth |
10 |
EPS Diluted |
|
|
Increase |
1.17% |
-40.00% |
-29.49% |
149.09% |
-102.92% |
4925.00% |
-14.51% |
-11.52% |
80.14% |
-43.73% |
93.92% |
-55.40% |
121.88% |
-0.07% |
5.21% |
21.90% |
|
9 |
1 |
10 |
Years of Data, EPS P or N |
90.00% |
|
Earnings Yield |
3.4% |
1.8% |
1.2% |
2.3% |
-0.1% |
3.4% |
3.4% |
3.4% |
5.1% |
3.6% |
5.8% |
2.4% |
6.0% |
5.8% |
6.2% |
7.5% |
|
17.84% |
<-IRR #YR-> |
10 |
Earnings per Share |
416.36% |
|
5 year Running Average |
$1.50 |
$1.46 |
$1.21 |
$1.06 |
$0.79 |
$0.92 |
$1.09 |
$1.27 |
$1.53 |
$1.83 |
$2.02 |
$1.94 |
$2.22 |
$2.26 |
$2.56 |
$2.72 |
|
14.23% |
<-IRR #YR-> |
5 |
Earnings per Share |
94.52% |
|
10 year Running Average |
$1.21 |
$1.20 |
$1.15 |
$1.19 |
$1.11 |
$1.21 |
$1.28 |
$1.24 |
$1.29 |
$1.31 |
$1.47 |
$1.52 |
$1.75 |
$1.89 |
$2.20 |
$2.37 |
|
6.27% |
<-IRR #YR-> |
10 |
5 yr Running Average |
83.77% |
|
* Diluted ESP per
share |
|
|
|
|
|
|
|
|
E/P |
10 Yrs |
3.43% |
5Yrs |
5.09% |
|
|
|
|
11.75% |
<-IRR #YR-> |
5 |
5 yr Running Average |
74.25% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$0.55 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.84 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.46 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.84 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.21 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1.27 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$2.22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend coverage by
Net Income |
53.48% |
97.87% |
167.94% |
82.32% |
-3108.11% |
81.25% |
121.79% |
138.37% |
112.23% |
219.91% |
116.33% |
269.14% |
124.61% |
127.33% |
|
|
|
119.06% |
<-Median-> |
10 |
Dividend coverage by Net Inc |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend* |
|
|
|
|
|
|
|
|
|
|
|
|
|
$3.67 |
$3.78 |
$3.86 |
|
|
Estimates |
|
Dividend* |
|
|
Increase |
|
|
|
|
|
|
|
|
|
|
|
|
|
3.44% |
2.83% |
2.15% |
|
|
Estimates |
|
Increase |
|
|
Payout Ratio EPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
129.39% |
126.46% |
105.96% |
|
|
Estimates |
|
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 |
|
|
Pre-split '99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend* |
$0.98 |
$1.13 |
$1.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$3.55 |
$3.66 |
$3.66 |
$3.66 |
|
181.75% |
<-Total Growth |
10 |
Dividends |
|
|
Increase |
15.29% |
15.31% |
11.50% |
11.11% |
32.86% |
13.98% |
13.82% |
11.23% |
9.99% |
9.76% |
3.09% |
2.99% |
3.20% |
3.10% |
0.00% |
0.00% |
|
28 |
0 |
33 |
Years of data, Count P, N |
84.85% |
|
Average Increases 5
Year Running |
11.31% |
12.98% |
13.82% |
13.62% |
17.21% |
16.95% |
16.65% |
16.60% |
16.37% |
11.75% |
9.58% |
7.41% |
5.80% |
4.43% |
2.48% |
1.86% |
|
15.00% |
<-Median-> |
10 |
Average Incr 5 Year Running |
|
|
Dividends 5 Yr Running |
$0.77 |
$0.87 |
$0.99 |
$1.12 |
$1.33 |
$1.55 |
$1.81 |
$2.10 |
$2.41 |
$2.68 |
$2.93 |
$3.13 |
$3.30 |
$3.45 |
$3.53 |
$3.59 |
|
233.10% |
<-Total Growth |
10 |
Dividends 5 Yr Running |
|
|
Yield H/L Price |
3.00% |
2.86% |
2.78% |
2.64% |
3.48% |
4.23% |
4.73% |
5.61% |
6.25% |
7.10% |
6.98% |
6.32% |
7.16% |
7.72% |
|
|
|
5.93% |
<-Median-> |
10 |
Yield H/L Price |
Item |
|
Yield on High Price |
2.57% |
2.63% |
2.59% |
2.33% |
2.82% |
3.59% |
4.15% |
4.62% |
5.67% |
5.67% |
6.20% |
5.78% |
6.33% |
7.37% |
|
|
|
5.14% |
<-Median-> |
10 |
Yield on High
Price |
EPS |
|
Yield on Low Price |
3.59% |
3.13% |
3.01% |
3.05% |
4.53% |
5.14% |
5.48% |
7.14% |
6.96% |
9.50% |
8.00% |
6.98% |
8.23% |
8.11% |
|
|
|
6.97% |
<-Median-> |
10 |
Yield on Low Price |
AEPS |
|
Yield on Close Price |
2.57% |
2.63% |
2.71% |
2.34% |
4.04% |
3.75% |
4.91% |
6.33% |
5.72% |
7.96% |
6.76% |
6.50% |
7.44% |
7.54% |
7.54% |
7.54% |
|
6.02% |
<-Median-> |
10 |
Yield on Close Price |
CFPS |
|
Payout Ratio EPS |
75.38% |
144.87% |
229.09% |
102.19% |
-4650.00% |
109.84% |
146.24% |
183.84% |
112.24% |
218.92% |
116.38% |
268.75% |
125.00% |
128.96% |
122.57% |
100.55% |
|
120.69% |
<-Median-> |
10 |
DPR EPS |
FCF 1 |
|
DPR EPS 5 Yr Running |
51.23% |
59.64% |
82.12% |
106.34% |
167.42% |
169.28% |
165.81% |
164.47% |
157.65% |
146.55% |
144.99% |
161.07% |
148.85% |
152.37% |
137.74% |
132.29% |
|
159.36% |
<-Median-> |
10 |
DPR EPS 5 Yr Running |
FCF 2 |
|
Payout Ratio CFPS |
28.32% |
31.65% |
31.34% |
46.83% |
35.32% |
38.36% |
62.12% |
51.68% |
63.81% |
67.11% |
73.11% |
62.03% |
53.12% |
64.55% |
62.03% |
59.51% |
|
57.58% |
<-Median-> |
10 |
DPR CF |
|
|
DPR CF 5 Yr Running |
31.00% |
31.07% |
30.76% |
34.17% |
34.34% |
36.36% |
41.75% |
45.83% |
49.10% |
55.74% |
63.33% |
63.23% |
62.94% |
63.13% |
62.22% |
60.00% |
|
47.47% |
<-Median-> |
10 |
DPR CF 5 Yr Running |
|
|
Payout Ratio CFPS WC |
32.24% |
25.87% |
28.98% |
27.59% |
30.70% |
35.87% |
70.74% |
67.43% |
76.41% |
79.13% |
73.22% |
73.99% |
76.26% |
64.55% |
62.03% |
59.51% |
|
71.98% |
<-Median-> |
10 |
DPR CF WC |
|
|
DPR CF WC 5 Yr Running |
32.08% |
30.19% |
29.44% |
28.71% |
28.97% |
30.16% |
36.50% |
42.88% |
51.80% |
63.07% |
73.47% |
74.03% |
75.71% |
72.91% |
69.39% |
66.50% |
|
47.34% |
<-Median-> |
10 |
DPR CF WC 5 Yr Running |
|
|
Median Values |
10 Yr Med |
10 Yr Cl |
5.93% |
6.02% |
5 Yr Med |
5 Yr Cl |
6.98% |
6.76% |
5 Yr Med |
Payout |
125.00% |
63.81% |
76.26% |
|
|
|
|
5.75% |
<-IRR #YR-> |
5 |
Dividends |
32.27% |
|
* Dividends per
share |
10 Yr Med |
and Cur. |
27.14% |
25.16% |
5 Yr Med |
and Cur. |
7.94% |
11.52% |
Last Div Inc ---> |
$0.8875 |
$0.9150 |
3.10% |
|
|
|
|
10.91% |
<-IRR #YR-> |
10 |
Dividends |
181.75% |
|
Dividends Growth 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11.87% |
<-IRR #YR-> |
15 |
Dividends |
437.88% |
|
Dividends Growth 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11.33% |
<-IRR #YR-> |
20 |
Dividends |
755.42% |
|
Dividends Growth 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.69% |
<-IRR #YR-> |
25 |
Dividends |
1167.86% |
|
Dividends Growth 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9.25% |
<-IRR #YR-> |
30 |
Dividends |
1299.01% |
|
Dividends Growth 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8.37% |
<-IRR #YR-> |
33 |
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
|
|
|
|
|
-$2.68 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.55 |
|
|
|
|
|
|
|
Dividends Growth 5 |
|
|
Dividends Growth 10 |
|
|
-$1.26 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.55 |
|
|
|
|
|
|
|
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 |
$3.55 |
|
|
|
|
|
|
|
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 |
$3.55 |
|
|
|
|
|
|
|
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 |
$3.55 |
|
|
|
|
|
|
|
Dividends Growth 25 |
|
|
Dividends Growth 30 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.55 |
|
|
|
|
|
|
|
Dividends Growth 30 |
|
|
Dividends Growth 35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$3.55 |
|
|
|
|
|
|
|
Dividends Growth 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Historical Dividends |
Historical |
High Div |
8.46% |
Low Div |
2.61% |
10 Yr High |
9.38% |
10 Yr Low |
2.38% |
Med Div |
3.67% |
Close Div |
3.66% |
|
|
|
|
|
|
|
Historical Dividends |
|
|
High/Ave/Median Values |
Curr diff |
Exp. |
-10.89% |
|
188.84% |
Exp. |
-19.63% |
|
216.75% |
Cheap |
105.41% |
Cheap |
106.20% |
|
|
|
|
|
|
|
High/Ave/Median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
Div Yd |
9.97% |
earning in |
5 |
Years |
at IRR of |
5.75% |
Div Inc. |
32.27% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yd |
13.19% |
earning in |
10 |
Years |
at IRR of |
5.75% |
Div Inc. |
74.94% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
Future Dividend Yield |
|
|
|
|
Div Yd |
17.44% |
earning in |
15 |
Years |
at IRR of |
5.75% |
Div Inc. |
131.39% |
|
|
|
|
|
|
|
Future Dividend Yield |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$4.84 |
earning in |
5 |
Years |
at IRR of |
5.75% |
Div Inc. |
32.27% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$6.40 |
earning in |
10 |
Years |
at IRR of |
5.75% |
Div Inc. |
74.94% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
Future Dividend Paid |
|
|
|
|
Div Paid |
$8.47 |
earning in |
15 |
Years |
at IRR of |
5.75% |
Div Inc. |
131.39% |
|
|
|
|
|
|
|
Future Dividend Paid |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$20.53 |
over |
5 |
Years |
at IRR of |
5.75% |
Div Cov. |
42.29% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$42.84 |
over |
10 |
Years |
at IRR of |
5.75% |
Div Cov. |
88.24% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
Dividend Covering Cost |
|
|
|
|
Total Div |
$72.36 |
over |
15 |
Years |
at IRR of |
5.75% |
Div Cov. |
149.03% |
|
|
|
|
|
|
|
Dividend Covering Cost |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I am earning GC |
|
|
|
|
Div Gr |
454.55% |
11/14/08 |
# yrs -> |
15 |
2008 |
$20.19 |
Cap Gain |
140.47% |
|
|
|
|
|
|
|
I am earning GC |
|
|
I am earning Div |
|
|
|
|
org yield |
3.27% |
12/31/24 |
Trading |
Div G Yrly |
11.20% |
Div start |
$0.66 |
-3.27% |
18.13% |
|
|
|
|
|
|
I am earning Div |
Item |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenue Growth |
I am earning GC |
|
|
|
|
Div Gr |
632.00% |
7/12/05 |
# yrs -> |
18 |
2005 |
$17.96 |
Cap Gain |
170.32% |
|
|
|
|
|
|
|
I am earning GC |
AEPS Growth |
I am earning Div |
|
|
|
|
org yield |
2.78% |
12/31/24 |
Trading |
Div G Yrly |
10.76% |
Div start |
$0.50 |
-2.78% |
20.38% |
|
|
|
|
|
|
I am earning Div |
Net Income Growth |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Growth |
Yield if held 5 years |
5.36% |
5.98% |
6.27% |
6.62% |
7.14% |
6.49% |
6.10% |
5.93% |
5.58% |
6.06% |
6.66% |
6.74% |
7.42% |
7.75% |
8.02% |
7.65% |
|
6.55% |
<-Median-> |
10 |
Paid Median Price |
Dividend Growth |
Yield if held 10 years |
9.71% |
9.92% |
10.59% |
10.47% |
10.91% |
11.59% |
12.78% |
13.35% |
13.95% |
12.44% |
10.22% |
8.70% |
7.84% |
6.91% |
6.84% |
7.30% |
|
11.25% |
<-Median-> |
10 |
Paid Median Price |
Stock Price Growth |
Yield if held 15 years |
21.51% |
17.36% |
15.69% |
17.46% |
21.20% |
21.00% |
21.18% |
22.57% |
22.08% |
19.01% |
18.25% |
18.22% |
17.65% |
17.30% |
14.05% |
11.20% |
|
20.00% |
<-Median-> |
10 |
Paid Median Price |
|
|
Yield if held 20 years |
19.94% |
37.05% |
36.52% |
36.66% |
49.72% |
46.54% |
37.07% |
33.42% |
36.81% |
36.92% |
33.08% |
30.19% |
29.85% |
27.38% |
21.47% |
20.00% |
|
36.74% |
<-Median-> |
10 |
Paid Median Price |
Revenue Growth |
Yield if held 25 years |
|
|
|
|
31.39% |
43.13% |
79.11% |
77.80% |
77.30% |
86.60% |
73.33% |
52.85% |
44.20% |
45.64% |
41.71% |
36.25% |
|
73.33% |
<-Median-> |
9 |
Paid Median Price |
AEPS Growth |
Yield if held 30 years |
|
|
|
|
|
|
|
|
|
54.68% |
67.96% |
112.79% |
102.90% |
95.84% |
97.83% |
80.35% |
|
85.43% |
<-Median-> |
4 |
Paid Median Price |
Net Income Growth |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow Growth |
Cost covered if held 5
years |
21.01% |
23.09% |
24.66% |
26.56% |
25.45% |
23.77% |
22.88% |
23.15% |
22.72% |
25.08% |
29.16% |
30.67% |
34.54% |
36.47% |
38.70% |
37.57% |
|
25.26% |
<-Median-> |
10 |
Paid Median Price |
Dividend Growth |
Cost covered if held 10
years |
61.32% |
60.92% |
65.47% |
65.29% |
59.08% |
63.48% |
71.02% |
76.76% |
83.42% |
76.92% |
68.53% |
62.46% |
59.65% |
55.26% |
58.09% |
64.98% |
|
66.91% |
<-Median-> |
10 |
Paid Median Price |
Stock Price Growth |
Cost covered if held 15
years |
169.10% |
131.62% |
118.88% |
132.80% |
138.93% |
138.28% |
140.38% |
153.57% |
155.27% |
137.75% |
143.43% |
153.93% |
158.92% |
164.85% |
144.67% |
123.51% |
|
141.90% |
<-Median-> |
10 |
Paid Median Price |
|
|
Cost covered if held 20
years |
182.22% |
322.50% |
314.38% |
314.14% |
363.68% |
339.68% |
270.69% |
249.33% |
282.81% |
291.74% |
283.18% |
277.79% |
292.50% |
284.15% |
241.30% |
241.64% |
|
287.46% |
<-Median-> |
10 |
Paid Median Price |
|
|
Cost covered if held 25
years |
|
|
|
|
250.74% |
340.31% |
619.32% |
618.07% |
629.14% |
722.09% |
660.85% |
511.21% |
455.05% |
497.68% |
492.88% |
461.16% |
|
618.07% |
<-Median-> |
9 |
Paid Median Price |
|
|
Cost covered if held 30
years |
|
|
|
|
|
|
|
|
|
477.05% |
637.95% |
1132.63% |
1096.96% |
1080.33% |
1193.86% |
1055.36% |
|
867.46% |
<-Median-> |
4 |
Paid Median Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yr |
Item |
Tot. Growth |
Revenue Growth |
|
|
|
|
|
|
|
$46,378 |
$50,069 |
$39,087 |
$47,071 |
$53,309 |
$43,649 |
$45,008 |
<-12 mths |
3.11% |
|
-5.88% |
<-Total Growth |
5 |
Revenue Growth |
-5.88% |
|
AEPS Growth |
|
|
|
|
|
|
|
$2.65 |
$2.65 |
$2.42 |
$2.74 |
$2.81 |
$2.79 |
$2.74 |
<-12 mths |
-1.79% |
|
5.28% |
<-Total Growth |
5 |
AEPS Growth |
5.28% |
|
Net Income Growth |
|
|
|
|
|
|
|
$2,515 |
$5,322 |
$2,983 |
$5,816 |
$2,589 |
$5,839 |
$5,810 |
<-12 mths |
-0.50% |
|
132.17% |
<-Total Growth |
5 |
Net Income Growth |
132.17% |
|
Cash Flow Growth |
|
|
|
|
|
|
|
$10,502 |
$9,368 |
$9,781 |
$9,256 |
$11,230 |
$14,201 |
|
|
|
|
35.22% |
<-Total Growth |
5 |
Cash Flow Growth |
35.22% |
|
Dividend Growth |
|
|
|
|
|
|
|
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$3.55 |
$3.66 |
<-12 mths |
3.10% |
|
32.27% |
<-Total Growth |
5 |
Dividend Growth |
32.27% |
|
Stock Price Growth |
|
|
|
|
|
|
|
$42.41 |
$51.63 |
$40.71 |
$49.41 |
$52.92 |
$47.70 |
$48.55 |
<-12 mths |
1.78% |
|
12.47% |
<-Total Growth |
5 |
Stock Price Growth |
12.47% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenue Growth |
|
|
$32,918 |
$37,641 |
$33,794 |
$34,560 |
$44,378 |
$46,378 |
$50,069 |
$39,087 |
$47,071 |
$53,309 |
$43,649 |
$45,397 |
<-this year |
4.00% |
|
32.60% |
<-Total Growth |
10 |
Revenue Growth |
32.60% |
|
AEPS Growth |
|
|
$1.78 |
$1.87 |
$2.20 |
$2.28 |
$1.96 |
$2.65 |
$2.65 |
$2.42 |
$2.74 |
$2.81 |
$2.79 |
$2.80 |
<-this year |
0.36% |
|
56.74% |
<-Total Growth |
10 |
AEPS Growth |
56.74% |
|
Net Income Growth |
|
|
$446 |
$1,154 |
-$37 |
$1,776 |
$2,529 |
$2,515 |
$5,322 |
$2,983 |
$5,816 |
$2,589 |
$5,839 |
$6,108 |
<-this year |
4.61% |
|
1209.19% |
<-Total Growth |
10 |
Net Income Growth |
1209.19% |
|
Cash Flow Growth |
|
|
$3,341 |
$2,547 |
$4,571 |
$5,211 |
$6,584 |
$10,502 |
$9,368 |
$9,781 |
$9,256 |
$11,230 |
$14,201 |
$12,049 |
<-this year |
-15.16% |
|
325.05% |
<-Total Growth |
10 |
Cash Flow Growth |
325.05% |
|
Dividend Growth |
|
|
$1.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$3.55 |
$3.67 |
<-this year |
3.44% |
|
181.75% |
<-Total Growth |
10 |
Dividend Growth |
181.75% |
|
Stock Price Growth |
|
|
$46.41 |
$59.74 |
$46.00 |
$56.50 |
$49.16 |
$42.41 |
$51.63 |
$40.71 |
$49.41 |
$52.92 |
$47.70 |
$52.13 |
<-this year |
9.29% |
|
2.78% |
<-Total Growth |
10 |
Stock Price Growth |
2.78% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends on Shares |
|
|
|
$30.80 |
$40.92 |
$46.64 |
$53.09 |
$59.05 |
$64.94 |
$71.28 |
$73.48 |
$75.68 |
$78.10 |
$80.52 |
$80.52 |
$80.52 |
|
$593.98 |
No of Years |
10 |
Total Dividends |
12/31/13 |
|
Paid |
|
|
$1,021.02 |
$1,314.28 |
$1,012.00 |
$1,243.00 |
$1,081.52 |
$933.02 |
$1,135.86 |
$895.62 |
$1,087.02 |
$1,164.24 |
$1,049.40 |
$1,068.10 |
$1,068.10 |
$1,068.10 |
|
$1,049.40 |
No of Years |
10 |
Worth |
$46.41 |
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1,643.38 |
|
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. AEPS |
$18.22 |
$17.54 |
$21.29 |
$24.87 |
$28.78 |
$31.52 |
$37.64 |
$42.66 |
$41.43 |
$37.96 |
$40.19 |
$40.35 |
$40.17 |
$39.90 |
$40.82 |
$43.12 |
|
88.67% |
<-Total Growth |
10 |
Graham Price AEPS |
|
|
Increase |
7.14% |
-3.74% |
21.41% |
16.77% |
15.74% |
9.52% |
19.42% |
13.34% |
-2.89% |
-8.37% |
5.87% |
0.39% |
-0.43% |
-0.68% |
2.30% |
5.64% |
|
7.70% |
<-Median-> |
10 |
Increase |
|
|
Price/GP Ratio Med |
1.79 |
2.26 |
2.13 |
2.13 |
1.86 |
1.59 |
1.36 |
1.12 |
1.14 |
1.20 |
1.19 |
1.35 |
1.23 |
1.19 |
0.00 |
0.00 |
|
1.29 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio High |
2.09 |
2.45 |
2.28 |
2.41 |
2.29 |
1.87 |
1.54 |
1.36 |
1.26 |
1.50 |
1.34 |
1.48 |
1.40 |
1.25 |
0.00 |
0.00 |
|
1.49 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Low |
1.50 |
2.06 |
1.97 |
1.84 |
1.43 |
1.31 |
1.17 |
0.88 |
1.02 |
0.90 |
1.04 |
1.22 |
1.07 |
1.13 |
0.00 |
0.00 |
|
1.12 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Close |
2.09 |
2.45 |
2.18 |
2.40 |
1.60 |
1.79 |
1.31 |
0.99 |
1.25 |
1.07 |
1.23 |
1.31 |
1.19 |
1.22 |
1.19 |
1.13 |
|
1.28 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Prem/Disc Close |
109.07% |
145.30% |
117.95% |
140.25% |
59.84% |
79.25% |
30.60% |
-0.59% |
24.62% |
7.24% |
22.94% |
31.16% |
18.73% |
21.67% |
18.94% |
12.59% |
|
27.61% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Graham No. EPS |
$17.08 |
$12.17 |
$11.84 |
$21.28 |
$22.71 |
$29.00 |
$34.54 |
$31.67 |
$41.27 |
$29.69 |
$41.13 |
$27.23 |
$40.53 |
$40.17 |
$41.21 |
$45.50 |
|
242.44% |
<-Total Growth |
10 |
Graham Price EPS |
|
|
Increase |
2.16% |
-28.73% |
-2.74% |
79.81% |
6.71% |
27.69% |
19.09% |
-8.31% |
30.34% |
-28.07% |
38.55% |
-33.79% |
48.85% |
-0.89% |
2.57% |
10.41% |
|
23.39% |
<-Median-> |
10 |
Increase |
|
|
Price/GP Ratio Med |
1.91 |
3.25 |
3.82 |
2.49 |
2.35 |
1.73 |
1.48 |
1.51 |
1.14 |
1.54 |
1.16 |
2.00 |
1.22 |
1.18 |
|
|
|
1.52 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio High |
2.23 |
3.54 |
4.11 |
2.82 |
2.90 |
2.04 |
1.68 |
1.83 |
1.26 |
1.92 |
1.31 |
2.19 |
1.38 |
1.24 |
|
|
|
1.88 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Low |
1.60 |
2.97 |
3.54 |
2.15 |
1.81 |
1.42 |
1.27 |
1.19 |
1.03 |
1.15 |
1.02 |
1.81 |
1.06 |
1.12 |
|
|
|
1.23 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Price/GP Ratio Close |
2.23 |
3.54 |
3.92 |
2.81 |
2.03 |
1.95 |
1.42 |
1.34 |
1.25 |
1.37 |
1.20 |
1.94 |
1.18 |
1.21 |
1.18 |
1.07 |
|
1.40 |
<-Median-> |
10 |
Price/GP Ratio |
|
|
Prem/Disc Close |
123.07% |
253.51% |
292.09% |
180.69% |
102.55% |
94.83% |
42.35% |
33.93% |
25.09% |
37.13% |
20.13% |
94.33% |
17.68% |
20.85% |
17.82% |
6.71% |
|
39.74% |
<-Median-> |
10 |
Graham Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price Close |
$38.09 |
$43.02 |
$46.41 |
$59.74 |
$46.00 |
$56.50 |
$49.16 |
$42.41 |
$51.63 |
$40.71 |
$49.41 |
$52.92 |
$47.70 |
$48.55 |
$48.55 |
$48.55 |
|
2.78% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
35.38% |
12.94% |
7.88% |
28.72% |
-23.00% |
22.83% |
-12.99% |
-13.73% |
21.74% |
-21.15% |
21.37% |
7.10% |
-9.86% |
1.78% |
0.00% |
0.00% |
|
32.40 |
<-Median-> |
10 |
CAPE (10 Yr P/E) |
|
|
P/E |
29.30 |
55.15 |
84.38 |
43.61 |
-1150.00 |
29.27 |
29.79 |
29.05 |
19.63 |
27.51 |
17.22 |
41.34 |
16.80 |
17.11 |
16.26 |
13.34 |
|
2.38% |
<-IRR #YR-> |
5 |
Stock Price |
12.47% |
|
Trailing P/E |
29.64 |
33.09 |
59.50 |
108.62 |
33.58 |
-1412.50 |
25.47 |
25.70 |
35.36 |
15.48 |
33.39 |
18.44 |
37.27 |
17.10 |
17.11 |
16.26 |
|
0.27% |
<-IRR #YR-> |
10 |
Stock Price |
2.78% |
|
CAPE (10 Yr P/E) |
17.22 |
20.08 |
23.73 |
26.67 |
31.25 |
31.58 |
32.20 |
34.95 |
35.70 |
36.13 |
33.04 |
32.60 |
28.40 |
25.61 |
22.20 |
20.26 |
|
9.78% |
<-IRR #YR-> |
5 |
Price & Dividend |
51.43% |
|
Median 10, 5 Yrs |
|
D. per yr |
5.52% |
7.40% |
% Tot Ret |
95.26% |
75.68% |
T P/E |
$29.54 |
$33.39 |
P/E: |
$28.28 |
$19.63 |
|
|
|
|
5.79% |
<-IRR #YR-> |
10 |
Price & Dividend |
60.95% |
|
Price 15 |
|
D. per yr |
6.13% |
|
% Tot Ret |
50.35% |
|
|
|
|
|
CAPE Diff |
-47.20% |
|
|
|
|
6.04% |
<-IRR #YR-> |
15 |
Stock Price |
141.15% |
|
Price 20 |
|
D. per yr |
5.45% |
|
% Tot Ret |
45.45% |
|
|
|
|
|
|
|
|
|
|
|
6.54% |
<-IRR #YR-> |
20 |
Stock Price |
254.78% |
|
Price 25 |
|
D. per yr |
5.10% |
|
% Tot Ret |
41.86% |
|
|
|
|
|
|
|
|
|
|
|
7.08% |
<-IRR #YR-> |
25 |
Stock Price |
453.04% |
|
Price 30 |
|
D. per yr |
5.89% |
|
% Tot Ret |
40.75% |
|
|
|
|
|
|
|
|
|
|
|
8.56% |
<-IRR #YR-> |
30 |
Stock Price |
886.05% |
|
Price 35 |
|
D. per yr |
4.33% |
|
% Tot Ret |
40.03% |
|
|
|
|
|
|
|
|
|
|
|
6.48% |
<-IRR #YR-> |
33 |
Stock Price |
|
|
Price & Dividend 15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12.17% |
<-IRR #YR-> |
15 |
Price & Dividend |
306.06% |
|
Price & Dividend 20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11.98% |
<-IRR #YR-> |
20 |
Price & Dividend |
516.59% |
|
Price & Dividend 25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12.18% |
<-IRR #YR-> |
25 |
Price & Dividend |
880.02% |
|
Price & Dividend 30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14.45% |
<-IRR #YR-> |
30 |
Price & Dividend |
1658.04% |
|
Price & Dividend 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10.81% |
<-IRR #YR-> |
33 |
Price & Dividend |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price 5 |
|
|
|
|
|
|
|
-$42.41 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$47.70 |
|
|
|
|
|
|
|
Price 5 |
|
|
Price 10 |
|
|
-$46.41 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$47.70 |
|
|
|
|
|
|
|
Price 10 |
|
|
Price & Dividend 5 |
|
|
|
|
|
|
|
-$42.41 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$51.25 |
|
|
|
|
|
|
|
Price & Dividend 5 |
|
|
Price & Dividend 10 |
|
|
-$46.41 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$51.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 |
$47.70 |
|
|
|
|
|
|
|
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 |
$47.70 |
|
|
|
|
|
|
|
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 |
$47.70 |
|
|
|
|
|
|
|
Price 25 |
|
|
Price 30 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$47.70 |
|
|
|
|
|
|
|
Price 30 |
|
|
Price 35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$47.70 |
|
|
|
|
|
|
|
Price 35 |
|
|
Price & Dividend 15 |
$0.98 |
$1.13 |
$1.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$51.25 |
|
|
|
|
|
|
|
Price & Dividend 15 |
|
|
Price & Dividend 20 |
$0.98 |
$1.13 |
$1.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$51.25 |
|
|
|
|
|
|
|
Price & Dividend 20 |
|
|
Price & Dividend 25 |
$0.98 |
$1.13 |
$1.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$51.25 |
|
|
|
|
|
|
|
Price & Dividend 25 |
|
|
Price & Dividend 30 |
$0.98 |
$1.13 |
$1.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$51.25 |
|
|
|
|
|
|
|
Price & Dividend 30 |
|
|
Price & Dividend 35 |
$0.98 |
$1.13 |
$1.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$51.25 |
|
|
|
|
|
|
|
Price & Dividend 35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price H/L Median |
$32.69 |
$39.56 |
$45.26 |
$52.95 |
$53.47 |
$50.17 |
$51.05 |
$47.84 |
$47.25 |
$45.61 |
$47.83 |
$54.41 |
$49.59 |
$47.41 |
|
|
|
9.56% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
25.46% |
21.03% |
14.41% |
16.98% |
0.99% |
-6.18% |
1.76% |
-6.29% |
-1.24% |
-3.46% |
4.86% |
13.76% |
-8.86% |
-4.39% |
|
|
|
0.92% |
<-IRR #YR-> |
10 |
Stock Price |
9.56% |
|
P/E |
25.14 |
50.72 |
82.29 |
38.65 |
-1336.75 |
25.99 |
30.94 |
32.77 |
17.96 |
30.82 |
16.66 |
42.50 |
17.46 |
16.71 |
|
|
|
0.72% |
<-IRR #YR-> |
5 |
Stock Price |
3.65% |
|
Trailing P/E |
25.44 |
30.43 |
58.03 |
96.26 |
39.03 |
-1254.13 |
26.45 |
28.99 |
32.36 |
17.34 |
32.31 |
18.96 |
38.74 |
16.69 |
|
|
|
6.41% |
<-IRR #YR-> |
10 |
Price & Dividend |
71.99% |
|
P/E on Running 5 yr
Average |
21.78 |
27.06 |
37.47 |
50.09 |
67.51 |
54.65 |
46.75 |
37.55 |
30.96 |
24.92 |
23.70 |
27.99 |
22.34 |
20.96 |
|
|
|
7.49% |
<-IRR #YR-> |
5 |
Price & Dividend |
43.79% |
|
P/E on Running 10 yr
Average |
27.10 |
33.10 |
39.35 |
44.44 |
48.35 |
41.48 |
39.98 |
38.55 |
36.58 |
34.79 |
32.58 |
35.84 |
28.38 |
25.03 |
|
|
|
18.66 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
D. per yr |
5.49% |
6.77% |
% Tot Ret |
85.69% |
90.40% |
T P/E |
30.65 |
32.31 |
P/E: |
28.40 |
17.96 |
|
|
|
|
|
Count |
34 |
Years of data |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$45.26 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$49.59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$47.84 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$49.59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$45.26 |
$1.40 |
$1.86 |
$2.12 |
$2.41 |
$2.68 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$53.14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$47.84 |
$2.95 |
$3.24 |
$3.34 |
$3.44 |
$53.14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
High Month |
Dec |
Dec |
May |
Dec |
Apr |
Sep |
Jan |
Jan |
Dec |
Feb |
Nov |
Jun |
Jan |
Jan |
|
|
|
|
|
|
|
|
|
Pre-split'05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price High |
$38.09 |
$43.02 |
$48.65 |
$60.04 |
$65.85 |
$59.10 |
$58.09 |
$58.09 |
$52.08 |
$57.13 |
$53.88 |
$59.55 |
$56.05 |
$49.68 |
|
|
|
15.21% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
31.75% |
12.94% |
13.09% |
23.41% |
9.68% |
-10.25% |
-1.71% |
0.00% |
-10.35% |
9.70% |
-5.69% |
10.52% |
-5.88% |
-11.36% |
|
|
|
1.43% |
<-IRR #YR-> |
10 |
Stock Price |
15.21% |
|
P/E |
29.30 |
55.15 |
88.45 |
43.82 |
-1646.25 |
30.62 |
35.21 |
39.79 |
19.80 |
38.60 |
18.77 |
46.52 |
19.74 |
17.51 |
|
|
|
-0.71% |
<-IRR #YR-> |
5 |
Stock Price |
-3.51% |
|
Trailing P/E |
29.64 |
33.09 |
62.37 |
109.16 |
48.07 |
-1477.50 |
30.10 |
35.21 |
35.67 |
21.72 |
36.41 |
20.75 |
43.79 |
17.49 |
|
|
|
23.04 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
35.44 |
35.67 |
P/E: |
32.91 |
19.80 |
|
|
|
|
37.92 |
P/E Ratio |
|
Historical High |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$48.65 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$56.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$58.09 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$56.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Low Month |
Jan |
Jan |
Oct |
Feb |
Dec |
Jan |
Nov |
Apr |
Jan |
Mar |
Jan |
Oct |
Oct |
Feb |
|
|
|
|
|
|
|
|
|
Pre-split'05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price Low |
$27.28 |
$36.10 |
$41.87 |
$45.85 |
$41.09 |
$41.23 |
$44.01 |
$37.59 |
$42.41 |
$34.09 |
$41.77 |
$49.26 |
$43.12 |
$45.14 |
|
|
|
2.99% |
<-Total Growth |
10 |
Stock Price |
|
|
Increase |
17.61% |
32.33% |
15.98% |
9.51% |
-10.38% |
0.34% |
6.74% |
-14.59% |
12.82% |
-19.62% |
22.53% |
17.93% |
-12.46% |
4.68% |
|
|
|
0.29% |
<-IRR #YR-> |
10 |
Stock Price |
2.99% |
|
P/E |
20.98 |
46.28 |
76.13 |
33.47 |
-1027.25 |
21.36 |
26.67 |
25.75 |
16.13 |
23.03 |
14.55 |
38.48 |
15.18 |
15.91 |
|
|
|
2.78% |
<-IRR #YR-> |
5 |
Stock Price |
14.71% |
|
Trailing P/E |
21.23 |
27.77 |
53.68 |
83.36 |
29.99 |
-1030.75 |
22.80 |
22.78 |
29.05 |
12.96 |
28.22 |
17.16 |
33.69 |
15.89 |
|
|
|
18.01 |
P/E Ratio |
|
Historical Median |
|
|
Median 10, 5 Yrs |
|
|
|
|
|
|
|
T P/E |
25.51 |
28.22 |
P/E: |
22.20 |
16.13 |
|
|
|
|
11.34 |
P/E Ratio |
|
Historical Low |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$41.87 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$37.59 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$43.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Free Cash Flow MS |
-$310 |
$2,483 |
-$5,106 |
-$8,185 |
-$2,803 |
-$44 |
-$2,280 |
$3,156 |
$3,706 |
$4,161 |
$1,163 |
$6,409 |
$9,325 |
$6,738 |
$6,884 |
$8,467 |
|
282.63% |
<-Total Growth |
10 |
Free Cash Flow MS |
|
|
Change |
|
|
|
|
|
98.43% |
-5081.82% |
238.42% |
17.43% |
12.28% |
-72.05% |
451.07% |
45.50% |
-27.74% |
2.17% |
23.00% |
|
24.19% |
<-IRR #YR-> |
5 |
Free Cash Flow MS |
195.47% |
|
FCF/CF from Op Ratio |
|
|
|
|
-0.61 |
-0.01 |
-0.35 |
0.30 |
0.40 |
0.43 |
0.13 |
0.57 |
0.66 |
0.56 |
0.55 |
0.65 |
|
#NUM! |
<-IRR #YR-> |
10 |
Free Cash Flow MS |
282.63% |
|
Dividends paid |
$530 |
$597 |
$749 |
$950 |
$1,150 |
$1,443 |
$3,080 |
$3,480 |
$5,973 |
$6,560 |
$6,766 |
$6,968 |
$7,276 |
$7,778 |
$7,778 |
$7,778 |
|
871.43% |
<-Total Growth |
10 |
Dividends paid |
|
|
Percentage paid |
-170.97% |
24.04% |
-14.67% |
-11.61% |
-41.03% |
-3279.55% |
-135.09% |
110.27% |
161.17% |
157.65% |
581.77% |
108.72% |
78.03% |
115.43% |
112.98% |
91.86% |
|
$0.93 |
<-Median-> |
10 |
Percentage paid |
|
|
5 Year Coverage |
|
|
|
|
-28.56% |
-35.80% |
-40.03% |
-99.48% |
871.82% |
236.07% |
261.04% |
159.97% |
135.45% |
127.17% |
119.81% |
99.35% |
|
|
|
|
5 Year Coverage |
|
|
Dividend
Coverage Ratio |
-0.58 |
4.16 |
-6.82 |
-8.62 |
-2.44 |
-0.03 |
-0.74 |
0.91 |
0.62 |
0.63 |
0.17 |
0.92 |
1.28 |
0.87 |
0.89 |
1.09 |
|
0.40 |
<-Median-> |
10 |
Dividend Coverage Ratio |
|
|
5 Year of Coverage |
|
|
|
|
-3.50 |
-2.79 |
-2.50 |
-1.01 |
0.11 |
0.42 |
0.38 |
0.63 |
0.74 |
0.79 |
0.83 |
1.01 |
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3,156 |
$0 |
$0 |
$0 |
$0 |
$9,325 |
|
|
|
|
|
|
|
|
|
|
|
|
|
$5,106 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$9,325 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Free Cash Flow WSJ |
|
|
|
|
-$2,702 |
$83 |
-$1,718 |
$3,696 |
$3,906 |
$4,376 |
$1,971 |
$7,346 |
$9,325 |
$6,738 |
$6,884 |
$8,467 |
|
445.11% |
<-Total Growth |
8 |
Free Cash Flow WSJ |
|
|
Change |
|
|
|
|
|
103.07% |
-2169.88% |
315.13% |
5.68% |
12.03% |
-54.96% |
272.70% |
26.94% |
-27.74% |
2.17% |
23.00% |
|
20.33% |
<-IRR #YR-> |
5 |
Free Cash Flow WSJ |
152.30% |
|
FCF/CF from Op Ratio |
|
|
|
|
-0.59 |
0.02 |
-0.26 |
0.35 |
0.42 |
0.45 |
0.21 |
0.65 |
1.04 |
0.69 |
0.65 |
0.74 |
|
276.58% |
<-Total Growth |
8 |
Free Cash Flow WSJ |
#DIV/0! |
|
Dividends paid |
|
|
|
|
$1,150 |
$1,443 |
$3,080 |
$3,480 |
$5,973 |
$6,560 |
$6,766 |
$6,968 |
$7,276 |
$7,778 |
$7,778 |
$7,778 |
|
404.23% |
<-Total Growth |
8 |
Dividends paid |
|
|
Percentage paid |
|
|
|
|
-42.56% |
1738.55% |
-179.28% |
94.16% |
152.92% |
149.91% |
343.28% |
94.85% |
78.03% |
115.43% |
112.98% |
91.86% |
|
$0.95 |
<-Median-> |
9 |
Percentage paid |
|
|
5 Year Coverage |
|
|
|
|
|
|
|
|
463.28% |
198.55% |
211.42% |
139.69% |
124.58% |
118.79% |
113.33% |
96.95% |
|
|
|
|
5 Year Coverage |
|
|
Dividend
Coverage Ratio |
|
|
|
|
-2.35 |
0.06 |
-0.56 |
1.06 |
0.65 |
0.67 |
0.29 |
1.05 |
1.28 |
0.87 |
0.89 |
1.09 |
|
0.65 |
<-Median-> |
9 |
Dividend Coverage Ratio |
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
0.22 |
0.50 |
0.47 |
0.72 |
0.80 |
0.84 |
0.88 |
1.03 |
|
|
|
|
5 Year of Coverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$3,696 |
$0 |
$0 |
$0 |
$0 |
$9,325 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$2,702 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$9,325 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Market Cap |
$29,748 |
$34,631 |
$38,567 |
$50,898 |
$39,928 |
$53,280 |
$83,326 |
$85,753 |
$104,551 |
$82,478 |
$100,105 |
$107,163 |
$101,363 |
$103,169 |
$103,169 |
$103,169 |
|
162.82% |
<-Total Growth |
10 |
Market Cap |
|
|
Market Cap/Assets |
0.87 |
0.73 |
0.67 |
0.70 |
0.47 |
0.62 |
0.51 |
0.51 |
0.64 |
0.51 |
0.59 |
0.60 |
0.56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Diluted # of Shares in
Million |
761 |
785 |
817 |
840 |
858 |
918 |
1,532 |
1,727 |
2,020 |
2,020 |
2,025 |
2,029 |
2,058 |
2,058 |
|
|
|
151.90% |
<-Total Growth |
10 |
Diluted |
|
|
Change |
1.74% |
3.15% |
4.08% |
2.82% |
2.14% |
6.99% |
66.88% |
12.73% |
16.97% |
0.00% |
0.25% |
0.20% |
1.43% |
0.00% |
|
|
|
2.48% |
<-Median-> |
10 |
Change |
|
|
Difference
Diluted/Basic |
-2.6% |
-1.7% |
-1.3% |
-1.3% |
-1.3% |
-0.8% |
-0.5% |
-0.2% |
-0.1% |
0.0% |
-0.1% |
-0.2% |
-0.1% |
-0.1% |
|
|
|
-0.19% |
<-Median-> |
10 |
Difference Diluted/Basic |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split '99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Basic # of Shares in
Millions |
741 |
772 |
806 |
829 |
847 |
911 |
1,525 |
1,724 |
2,017 |
2,021 |
2,023 |
2,025 |
2,056 |
2,056 |
|
|
|
155.09% |
<-Total Growth |
10 |
Basic |
|
|
Change |
-1.33% |
4.18% |
4.40% |
2.85% |
2.17% |
7.56% |
67.40% |
13.05% |
17.00% |
0.20% |
0.10% |
0.10% |
1.53% |
0.00% |
|
|
|
2.51% |
<-Median-> |
10 |
Change |
|
|
Difference
Basic/Outstanding |
5.4% |
4.3% |
3.1% |
2.8% |
2.5% |
3.5% |
11.1% |
17.3% |
0.4% |
0.2% |
0.1% |
0.0% |
3.4% |
3.4% |
|
|
|
2.63% |
<-Median-> |
10 |
Difference Basic/Outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-split'11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# of Share in Millions |
781 |
805 |
831 |
852 |
868 |
943 |
1,695 |
2,022 |
2,025 |
2,026 |
2,026 |
2,025 |
2,125 |
2,125 |
2,125 |
2,125 |
|
9.84% |
<-IRR #YR-> |
10 |
Shares |
155.72% |
|
Change |
1.43% |
3.07% |
3.23% |
2.53% |
1.88% |
8.64% |
79.75% |
19.29% |
0.15% |
0.05% |
0.00% |
-0.05% |
4.94% |
0.00% |
0.00% |
0.00% |
|
1.00% |
<-IRR #YR-> |
5 |
Shares |
5.09% |
|
CF fr Op $Millon |
$2,703 |
$2,874 |
$3,341 |
$2,547 |
$4,571 |
$5,211 |
$6,584 |
$10,502 |
$9,368 |
$9,781 |
$9,256 |
$11,230 |
$14,201 |
$12,049 |
$12,538 |
$13,069 |
|
325.05% |
<-Total Growth |
10 |
Cash Flow |
|
|
Increase |
46.03% |
6.33% |
16.25% |
-23.77% |
79.47% |
14.00% |
26.35% |
59.51% |
-10.80% |
4.41% |
-5.37% |
21.33% |
26.46% |
-15.16% |
4.06% |
4.24% |
|
Shr Issue |
SO, DRIP |
|
|
|
|
5 year Running Average |
$1,867 |
$2,167 |
$2,557 |
$2,663 |
$3,207 |
$3,709 |
$4,451 |
$5,883 |
$7,247 |
$8,289 |
$9,098 |
$10,027 |
$10,767 |
$11,303 |
$11,855 |
$12,617 |
|
321.05% |
<-Total Growth |
10 |
CF 5 Yr Running |
|
|
CFPS |
$3.46 |
$3.57 |
$4.02 |
$2.99 |
$5.27 |
$5.53 |
$3.88 |
$5.19 |
$4.63 |
$4.83 |
$4.57 |
$5.55 |
$6.68 |
$5.67 |
$5.90 |
$6.15 |
|
66.22% |
<-Total Growth |
10 |
Cash Flow per Share |
|
|
Increase |
43.97% |
3.16% |
12.61% |
-25.64% |
76.16% |
4.93% |
-29.71% |
33.71% |
-10.93% |
4.36% |
-5.37% |
21.39% |
20.51% |
-15.16% |
4.06% |
4.24% |
|
15.57% |
<-IRR #YR-> |
10 |
Cash Flow |
325.05% |
|
5 year Running Average |
$2.48 |
$2.81 |
$3.22 |
$3.29 |
$3.86 |
$4.27 |
$4.34 |
$4.57 |
$4.90 |
$4.81 |
$4.62 |
$4.95 |
$5.25 |
$5.46 |
$5.67 |
$5.99 |
|
6.22% |
<-IRR #YR-> |
5 |
Cash Flow |
35.22% |
|
P/CF on Med Price |
9.44 |
11.08 |
11.26 |
17.71 |
10.15 |
9.08 |
13.14 |
9.21 |
10.21 |
9.45 |
10.47 |
9.81 |
7.42 |
8.36 |
0.00 |
0.00 |
|
5.21% |
<-IRR #YR-> |
10 |
Cash Flow per Share |
66.22% |
|
P/CF on Closing Price |
11.01 |
12.05 |
11.54 |
19.98 |
8.74 |
10.22 |
12.66 |
8.17 |
11.16 |
8.43 |
10.82 |
9.54 |
7.14 |
8.56 |
8.23 |
7.89 |
|
5.17% |
<-IRR #YR-> |
5 |
Cash Flow per Share |
28.67% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-14.22% |
Diff M/C |
|
5.00% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
62.81% |
|
Excl.Working Capital CF |
-$329 |
$642 |
$272 |
$1,777 |
$688 |
$362 |
-$802 |
-$2,454 |
-$1,545 |
-$1,485 |
-$14 |
-$1,815 |
-$4,309 |
$0 |
$0 |
|
|
2.81% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
14.83% |
|
CF fr Op $M WC |
$2,374 |
$3,516 |
$3,613 |
$4,324 |
$5,259 |
$5,573 |
$5,782 |
$8,048 |
$7,823 |
$8,296 |
$9,242 |
$9,415 |
$9,892 |
$12,049 |
$12,538 |
$13,069 |
|
173.79% |
<-Total Growth |
10 |
Cash Flow less WC |
|
|
Increase |
12.30% |
48.10% |
2.76% |
19.68% |
21.62% |
5.97% |
3.75% |
39.19% |
-2.80% |
6.05% |
11.40% |
1.87% |
5.07% |
21.80% |
4.06% |
4.24% |
|
10.60% |
<-IRR #YR-> |
10 |
Cash Flow less WC |
173.79% |
|
5 year Running Average |
$1,804 |
$2,235 |
$2,678 |
$3,188 |
$3,817 |
$4,457 |
$4,910 |
$5,797 |
$6,497 |
$7,104 |
$7,838 |
$8,565 |
$8,934 |
$9,779 |
$10,627 |
$11,392 |
|
4.21% |
<-IRR #YR-> |
5 |
Cash Flow less WC |
22.91% |
|
CFPS Excl. WC |
$3.04 |
$4.37 |
$4.35 |
$5.08 |
$6.06 |
$5.91 |
$3.41 |
$3.98 |
$3.86 |
$4.09 |
$4.56 |
$4.65 |
$4.66 |
$5.67 |
$5.90 |
$6.15 |
|
12.80% |
<-IRR #YR-> |
10 |
CF less WC 5 Yr Run |
233.57% |
|
Increase |
10.72% |
43.69% |
-0.46% |
16.73% |
19.38% |
-2.46% |
-42.28% |
16.68% |
-2.94% |
5.99% |
11.40% |
1.92% |
0.12% |
21.80% |
4.06% |
4.24% |
|
9.03% |
<-IRR #YR-> |
5 |
CF less WC 5 Yr Run |
54.10% |
|
5 year Running Average |
$2.40 |
$2.89 |
$3.37 |
$3.92 |
$4.58 |
$5.15 |
$4.96 |
$4.89 |
$4.64 |
$4.25 |
$3.98 |
$4.23 |
$4.36 |
$4.73 |
$5.09 |
$5.40 |
|
0.69% |
<-IRR #YR-> |
10 |
CFPS - Less WC |
7.07% |
|
P/CF on Med Price |
10.75 |
9.06 |
10.41 |
10.43 |
8.83 |
8.49 |
14.97 |
12.02 |
12.23 |
11.14 |
10.48 |
11.70 |
10.65 |
8.36 |
0.00 |
0.00 |
|
3.18% |
<-IRR #YR-> |
5 |
CFPS - Less WC |
16.95% |
|
P/CF on Closing Price |
12.53 |
9.85 |
10.67 |
11.77 |
7.59 |
9.56 |
14.41 |
10.66 |
13.36 |
9.94 |
10.83 |
11.38 |
10.25 |
8.56 |
8.23 |
7.89 |
|
2.62% |
<-IRR #YR-> |
10 |
CFPS 5 yr Running |
29.54% |
|
*Operational Cash Flow
per share |
|
|
CF/-WC |
P/CF Med |
10 yr |
9.98 |
5 yr |
9.81 |
P/CF Med |
10 yr |
10.90 |
5 yr |
11.14 |
|
-21.41% |
Diff M/C |
|
-2.23% |
<-IRR #YR-> |
5 |
CFPS 5 yr Running |
-10.69% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-831.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
2125.0 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
|
|
|
|
|
-2022.0 |
0.0 |
0.0 |
0.0 |
0.0 |
2125.0 |
|
|
|
|
|
|
|
Shares |
|
|
|
|
|
-$3,341 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$14,201 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
|
|
|
|
|
-$10,502 |
$0 |
$0 |
$0 |
$0 |
$14,201 |
|
|
|
|
|
|
|
Cash Flow |
|
|
|
|
|
-$4.02 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.68 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
|
|
|
|
|
-$5.19 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$6.68 |
|
|
|
|
|
|
|
Cash Flow per Share |
|
|
|
|
|
-$3.22 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.25 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$4.57 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$5.25 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
-$3,613 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$9,892 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
|
|
|
|
|
-$8,048 |
$0 |
$0 |
$0 |
$0 |
$9,892 |
|
|
|
|
|
|
|
Cash Flow less WC |
|
|
|
|
|
-$2,678 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$8,934 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
|
|
|
|
|
-$5,797 |
$0 |
$0 |
$0 |
$0 |
$8,934 |
|
|
|
|
|
|
|
CF less WC 5 Yr Run |
|
|
|
|
|
-$4.35 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.66 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
|
|
|
|
|
-$3.98 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.66 |
|
|
|
|
|
|
|
CFPS - Less WC |
|
|
|
|
|
-$3.37 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.36 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
-$4.89 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$4.36 |
|
|
|
|
|
|
|
CFPS 5 yr Running |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Changes in operating assets and liabilities
(Note 29) |
|
-$1,721 |
-$686 |
-$358 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accts Rec & other |
|
|
|
|
|
|
-$783 |
$857 |
-$659 |
$1,546 |
-$1,228 |
-$967 |
$1,125 |
|
|
|
|
|
|
|
|
|
|
Other Assetrs |
|
|
|
|
|
|
|
|
|
|
|
|
$1,278 |
|
|
|
|
|
|
|
|
|
|
Accts Rec from Affiliates |
|
|
|
|
|
|
$24 |
$54 |
$6 |
$8 |
-$38 |
$17 |
$18 |
|
|
|
|
|
|
|
|
|
|
Inventory |
|
|
|
|
|
|
-$289 |
$164 |
-$24 |
-$254 |
-$118 |
-$599 |
$763 |
|
|
|
|
|
|
|
|
|
|
Deferred Amts & other asets |
|
|
|
|
|
|
-$138 |
$226 |
$133 |
-$586 |
-$195 |
$1 |
$23 |
|
|
|
|
|
|
|
|
|
|
Accts Pay & other |
|
|
|
|
|
|
$277 |
-$151 |
$175 |
-$770 |
-$63 |
$1,100 |
-$1,542 |
|
|
|
|
|
|
|
|
|
|
Other current Liab. |
|
|
|
|
|
|
|
|
|
|
|
|
$339 |
|
|
|
|
|
|
|
|
|
|
Accts payable to Affiliates |
|
|
|
|
|
|
-$62 |
-$122 |
-$24 |
$1 |
$52 |
$16 |
-$66 |
|
|
|
|
|
|
|
|
|
|
Interest Payable |
|
|
|
|
|
|
|
$25 |
-$41 |
$31 |
$43 |
$58 |
$199 |
|
|
|
|
|
|
|
|
|
|
Other Long-Term Liab |
|
|
|
|
|
|
$509 |
-$138 |
$175 |
$117 |
-$69 |
$362 |
$174 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Deferred Income tax |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chge in unrealized gain/loss |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Earnings from equ investments |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Distributions from equ investments |
|
|
|
|
|
|
$1,264 |
$1,539 |
$1,804 |
$1,392 |
$1,630 |
$1,827 |
$1,998 |
|
|
|
|
|
|
|
|
|
|
Impairement of long-lived assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Impairement of good will |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
gain/oss on dispositions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
other |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Changes in regulatory assets and liabilities |
|
|
$22 |
$41 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Changes in environmental liabilities, net of
recoveries |
|
-$78 |
-$43 |
-$4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sum |
|
|
|
-$1,777 |
-$688 |
-$362 |
$802 |
$2,454 |
$1,545 |
$1,485 |
$14 |
$1,815 |
$4,309 |
|
|
|
|
|
|
|
|
|
|
Google - TD |
|
|
|
-$1,777 |
-$688 |
-$362 |
$802 |
$2,429 |
$1,545 |
$1,485 |
$14 |
$1,815 |
$4,309 |
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
|
$0 |
$0 |
$0 |
$0 |
$25 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
TD |
|
|
|
-$1,801 |
-$719 |
$439 |
$802 |
$2,454 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
|
$24 |
$31 |
-$801 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Morningstar |
|
|
|
-$1,777 |
-$688 |
-$362 |
-$412 |
$915 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Difference |
|
|
|
$0 |
$0 |
$0 |
$1,214 |
$1,539 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPM |
13.93% |
11.36% |
10.15% |
6.77% |
13.53% |
15.08% |
14.84% |
22.64% |
18.71% |
25.02% |
19.66% |
21.07% |
32.53% |
26.54% |
|
|
|
220.55% |
<-Total Growth |
10 |
OPM |
|
|
Increase |
13.85% |
-18.48% |
-10.63% |
-33.33% |
99.90% |
11.47% |
-1.60% |
52.63% |
-17.37% |
33.74% |
-21.42% |
7.13% |
54.44% |
-18.42% |
|
|
|
|
Should increase |
|
or be stable. |
|
|
Diff from Ave |
-27.4% |
-40.8% |
-47.1% |
-64.7% |
-29.5% |
-21.4% |
-22.7% |
18.0% |
-2.5% |
30.4% |
2.5% |
9.8% |
69.6% |
38.3% |
|
|
|
0.00 |
<-Median-> |
10 |
OPM |
|
|
*Operational
Profit Margin (CF/Revenue) Ratio |
|
|
|
|
|
|
|
OPM |
10 Yrs |
19.19% |
5 Yrs |
21.07% |
|
|
|
|
should be |
zero, it is a |
|
check on
calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$16,478 |
<-12 mths |
0.15% |
|
|
|
|
|
|
|
EBITDA |
|
$3,318 |
$2,934 |
$4,879 |
$3,659 |
$6,902 |
$10,317 |
$12,317 |
$12,849 |
$13,271 |
$13,273 |
$15,531 |
$16,454 |
$17,455 |
$18,862 |
$19,915 |
|
460.80% |
<-Total Growth |
10 |
EBITDA |
|
|
Change |
|
|
-11.57% |
66.29% |
-25.01% |
88.63% |
49.48% |
19.39% |
4.32% |
3.28% |
0.02% |
17.01% |
5.94% |
6.08% |
8.06% |
5.58% |
|
11.48% |
<-Median-> |
10 |
Change |
|
|
Margin |
|
13.11% |
8.91% |
12.96% |
10.83% |
19.97% |
23.25% |
26.56% |
25.66% |
33.95% |
28.20% |
29.13% |
37.70% |
38.45% |
39.03% |
39.94% |
|
26.11% |
<-Median-> |
10 |
Margin |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long Term Debt |
$19,251 |
$20,203 |
$22,357 |
$33,423 |
$39,391 |
$36,494 |
$60,865 |
$60,327 |
$59,661 |
$62,819 |
$67,961 |
$72,939 |
$74,715 |
$74,715 |
|
|
|
234.19% |
<-Total Growth |
10 |
Debt |
Type |
|
Change |
|
4.95% |
10.66% |
49.50% |
17.86% |
-7.35% |
66.78% |
-0.88% |
-1.10% |
5.29% |
8.19% |
7.32% |
2.43% |
0.00% |
|
|
|
6.31% |
<-Median-> |
10 |
Change |
Lg Term R |
|
Debt/Market Cap Ratio |
0.65 |
0.58 |
0.58 |
0.66 |
0.99 |
0.68 |
0.73 |
0.70 |
0.57 |
0.76 |
0.68 |
0.68 |
0.74 |
0.72 |
|
|
|
0.69 |
<-Median-> |
10 |
Debt/Market Cap Ratio |
Intang/GW |
|
Assets/Current
Liabilities Ratio |
7.07 |
6.67 |
5.37 |
7.67 |
7.83 |
6.62 |
11.08 |
11.41 |
10.20 |
11.47 |
9.26 |
8.85 |
10.34 |
10.34 |
|
|
|
9.73 |
<-Median-> |
10 |
Assets/Current Liab.
Ratio |
Liquidity |
|
Debt to Cash Flow
(Years) |
7.12 |
7.03 |
6.69 |
13.12 |
8.62 |
7.00 |
9.24 |
5.74 |
6.37 |
6.42 |
7.34 |
6.50 |
5.26 |
6.20 |
|
|
|
6.75 |
<-Median-> |
10 |
Debt to Cash Flow (Years) |
Liq. + CF |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Debt Ratio |
|
Intangibles |
$711 |
$817 |
$445 |
$1,166 |
$1,348 |
$1,573 |
$3,267 |
$2,372 |
$2,173 |
$2,080 |
$4,008 |
$4,018 |
$3,537 |
$3,537 |
|
|
|
694.83% |
<-Total Growth |
10 |
Intangibles |
Leverage |
|
Goodwill |
$440 |
$419 |
$1,004 |
$483 |
$80 |
$78 |
$34,457 |
$34,459 |
$33,153 |
$32,688 |
$32,775 |
$32,440 |
$32 |
$32 |
|
|
|
-96.83% |
<-Total Growth |
10 |
Goodwill |
D/E Ratio |
|
Total |
$1,151 |
$1,236 |
$1,449 |
$1,649 |
$1,428 |
$1,651 |
$37,724 |
$36,831 |
$35,326 |
$34,768 |
$36,783 |
$36,458 |
$3,569 |
$3,569 |
|
|
|
|
Intangibles |
|
Total |
|
|
Change |
|
|
17.23% |
13.80% |
-13.40% |
15.62% |
2184.92% |
-2.37% |
-4.09% |
-1.58% |
5.80% |
-0.88% |
-90.21% |
0.00% |
|
|
|
-1.23% |
<-Median-> |
10 |
Change |
|
|
Intangible/Market Cap
Ratio |
0.04 |
0.04 |
0.04 |
0.03 |
0.04 |
0.03 |
0.45 |
0.43 |
0.34 |
0.42 |
0.37 |
0.34 |
0.04 |
0.03 |
|
|
|
0.34 |
<-Median-> |
10 |
Intangible/Market Cap Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Assets |
$4,295 |
$6,600 |
$6,950 |
$8,201 |
$7,597 |
$8,410 |
$9,215 |
$9,215 |
$8,826 |
$7,350 |
$8,959 |
$12,147 |
$14,399 |
$14,399 |
|
|
|
Liq ratio of 1.5 and up, best |
|
|
|
|
Current Liabilities |
$4,860 |
$7,069 |
$10,728 |
$9,501 |
$10,814 |
$12,966 |
$14,624 |
$14,624 |
$16,010 |
$13,979 |
$18,229 |
$20,301 |
$17,435 |
$17,435 |
|
|
|
0.63 |
<-Median-> |
10 |
Ratio |
|
|
Liquidity Ratio |
0.88 |
0.93 |
0.65 |
0.86 |
0.70 |
0.65 |
0.63 |
0.63 |
0.55 |
0.53 |
0.49 |
0.60 |
0.83 |
0.83 |
|
|
|
0.55 |
<-Median-> |
5 |
Ratio |
|
|
Liq. with CF aft div |
1.28 |
1.21 |
0.86 |
1.01 |
0.98 |
0.90 |
0.80 |
0.98 |
0.76 |
0.76 |
0.63 |
0.81 |
1.21 |
1.07 |
|
|
|
0.76 |
<-Median-> |
5 |
Ratio |
|
|
Liq. CF re Inv+Div |
0.70 |
0.65 |
0.46 |
0.45 |
0.56 |
0.64 |
0.46 |
0.81 |
0.59 |
0.55 |
0.40 |
0.64 |
0.90 |
1.07 |
|
|
|
0.59 |
<-Median-> |
5 |
Ratio |
|
|
Curr Long Term Debt |
$374 |
$652 |
$2,811 |
$1,004 |
$1,004 |
$4,100 |
$2,871 |
$3,259 |
$4,404 |
$2,957 |
$6,164 |
$6,045 |
$6,084 |
$6,084 |
|
|
|
|
|
|
|
|
|
Liquidity Less CLTD |
0.96 |
1.03 |
0.88 |
0.97 |
0.77 |
0.95 |
0.78 |
0.81 |
0.76 |
0.67 |
0.74 |
0.85 |
1.27 |
1.27 |
|
|
|
0.76 |
<-Median-> |
5 |
Ratio |
|
|
Liq. with CF aft div |
1.39 |
1.33 |
1.17 |
1.12 |
1.08 |
1.31 |
1.00 |
1.26 |
1.05 |
0.96 |
0.95 |
1.15 |
1.86 |
1.64 |
|
|
|
1.05 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Assets |
$34,343 |
$47,172 |
$57,568 |
$72,857 |
$84,664 |
$85,832 |
$162,093 |
$166,905 |
$163,269 |
$160,276 |
$168,864 |
$179,608 |
$180,317 |
$180,317 |
|
|
|
Debt Ratio of 1.5 and up, best |
|
|
|
|
Liabilities |
$24,656 |
$32,414 |
$39,005 |
$51,807 |
$62,325 |
$60,477 |
$92,294 |
$93,470 |
$93,862 |
$95,913 |
$105,496 |
$116,210 |
$115,834 |
$115,834 |
|
|
|
1.58 |
<-Median-> |
10 |
Ratio |
|
|
Debt Ratio |
1.39 |
1.46 |
1.48 |
1.41 |
1.36 |
1.42 |
1.76 |
1.79 |
1.74 |
1.67 |
1.60 |
1.55 |
1.56 |
1.56 |
|
|
|
1.60 |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimates BVPS |
|
|
|
|
|
|
|
|
|
|
|
|
|
$26.30 |
$25.80 |
$23.80 |
|
|
Estimates |
|
Estimates BVPS |
|
|
Estimate Book Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
$55,888 |
$54,825 |
$50,575 |
|
|
Estimates |
|
Estimate Book Value |
|
|
P/B Ratio (Close) |
|
|
|
|
|
|
|
|
|
|
|
|
|
1.85 |
1.88 |
2.04 |
|
|
Estimates |
|
P/B Ratio (Close) |
|
|
Difference from 10 year
median |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11.62% |
Diff M/C |
|
|
Estimates |
|
Difference from 10 yr med. |
|
|
Check on Total Enbridge
Inc Equity |
|
$6,793 |
$13,496 |
$16,786 |
$18,898 |
$21,386 |
$58,135 |
$69,470 |
$66,043 |
$61,367 |
$60,826 |
$59,887 |
$61,454 |
$61,454 |
|
|
|
|
|
|
|
|
|
Total Book Value |
$9,687 |
$14,758 |
$18,563 |
$21,050 |
$22,339 |
$25,355 |
$69,799 |
$73,435 |
$69,407 |
$64,363 |
$63,368 |
$63,398 |
$64,483 |
$64,483 |
|
|
|
247.37% |
<-Total Growth |
10 |
Total Book Value |
|
|
Commitments etc |
|
|
$1,053 |
$2,249 |
$2,141 |
$3,392 |
$4,067 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
NCI |
$846 |
$4,258 |
$4,014 |
$2,015 |
$1,300 |
$577 |
$7,597 |
$3,965 |
$3,364 |
$2,996 |
$2,542 |
$3,511 |
$3,029 |
$3,029 |
|
|
|
-24.54% |
<-Total Growth |
10 |
Non-Control. Int |
|
|
Book Value |
$8,841 |
$10,500 |
$14,549 |
$19,035 |
$21,039 |
$24,778 |
$62,202 |
$69,470 |
$66,043 |
$61,367 |
$60,826 |
$59,887 |
$61,454 |
$61,454 |
|
|
|
322.39% |
<-Total Growth |
10 |
Book Value |
|
|
Book Value per Share |
$11.32 |
$13.04 |
$17.51 |
$22.34 |
$24.24 |
$26.28 |
$36.70 |
$34.36 |
$32.61 |
$30.29 |
$30.02 |
$29.57 |
$28.92 |
$28.92 |
|
|
|
65.18% |
<-Total Growth |
10 |
Book Value per Share |
|
|
P/B Ratio (Median) |
2.89 |
3.03 |
2.59 |
2.37 |
2.21 |
1.91 |
1.39 |
1.39 |
1.45 |
1.51 |
1.59 |
1.84 |
1.71 |
1.64 |
|
|
|
1.65 |
10 Year Med. |
|
P/B Ratio (Median) |
|
|
Preferred Shares |
$1,056 |
$3,707 |
$5,141 |
$6,515 |
$6,515 |
$6,515 |
$7,747 |
$7,747 |
$7,747 |
$7,747 |
$7,747 |
$7,747 |
$6,818 |
$7,747 |
|
|
|
32.62% |
<-Total Growth |
10 |
Preferred Shares |
|
|
Net Book Value |
$7,785 |
$6,793 |
$9,408 |
$12,520 |
$14,524 |
$18,263 |
$54,455 |
$61,723 |
$58,296 |
$53,620 |
$53,079 |
$52,140 |
$54,636 |
$53,707 |
$53,707 |
$53,707 |
|
480.74% |
<-Total Growth |
10 |
Book Value |
|
|
Book Value per Share |
$9.97 |
$8.44 |
$11.32 |
$14.69 |
$16.73 |
$19.37 |
$32.13 |
$30.53 |
$28.79 |
$26.47 |
$26.20 |
$25.75 |
$25.71 |
$25.27 |
$25.27 |
$25.27 |
|
127.10% |
<-Total Growth |
10 |
Book Value per Share |
|
|
Change |
3.16% |
-15.34% |
34.16% |
29.80% |
13.87% |
15.74% |
65.89% |
-4.98% |
-5.69% |
-8.07% |
-1.01% |
-1.72% |
-0.14% |
-1.70% |
0.00% |
0.00% |
|
-19.75% |
P/B Ratio |
|
Current/10 Year Median |
|
|
P/B Ratio (Median) |
3.28 |
4.69 |
4.00 |
3.60 |
3.20 |
2.59 |
1.59 |
1.57 |
1.64 |
1.72 |
1.83 |
2.11 |
1.93 |
1.88 |
0.00 |
0.00 |
|
2.39 |
P/B Ratio |
|
Historical Median |
|
|
P/B Ratio (Close) |
3.82 |
5.10 |
4.10 |
4.07 |
2.75 |
2.92 |
1.53 |
1.39 |
1.79 |
1.54 |
1.89 |
2.06 |
1.86 |
1.92 |
1.92 |
1.92 |
|
8.55% |
<-IRR #YR-> |
10 |
Book Value per Share |
127.10% |
|
Change |
31.23% |
33.41% |
-19.59% |
-0.83% |
-32.38% |
6.12% |
-47.55% |
-9.21% |
29.09% |
-14.23% |
22.61% |
8.98% |
-9.73% |
3.54% |
0.00% |
0.00% |
|
-3.37% |
<-IRR #YR-> |
5 |
Book Value per Share |
-15.77% |
|
Leverage (A/BK) |
3.55 |
3.20 |
3.10 |
3.46 |
3.79 |
3.39 |
2.32 |
2.27 |
2.35 |
2.49 |
2.66 |
2.83 |
2.80 |
2.80 |
|
|
|
2.73 |
<-Median-> |
10 |
A/BV |
|
|
Debt/Equity Ratio |
2.55 |
2.20 |
2.10 |
2.46 |
2.79 |
2.39 |
1.32 |
1.27 |
1.35 |
1.49 |
1.66 |
1.83 |
1.80 |
1.80 |
|
|
|
1.73 |
<-Median-> |
10 |
Debt/Eq Ratio |
|
|
Sharerholders
Equity (Assets less liabilities) |
|
|
|
|
|
|
|
P/BV |
10 yr Med |
1.88 |
5 yr Med |
1.83 |
|
2.34% |
Diff M/C |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$11.32 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$25.71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$30.53 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$25.71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EPS based on
Comprehensive |
$1.02 |
$0.44 |
$1.97 |
$1.57 |
$2.37 |
$1.31 |
$0.33 |
$3.65 |
$1.15 |
$0.92 |
$3.02 |
$3.55 |
$2.25 |
|
|
|
|
14.04% |
<-Total Growth |
10 |
EPS based on Comprehensive |
|
|
Comprehensive Income |
$835 |
$612 |
$2,068 |
$1,811 |
$2,026 |
$1,724 |
$988 |
$7,471 |
$2,720 |
$2,256 |
$6,589 |
$7,640 |
$4,843 |
|
|
|
|
134.19% |
<-Total Growth |
10 |
Comprehensive Inc |
|
|
NCI |
$43 |
$164 |
$276 |
$242 |
-$292 |
$229 |
$160 |
$801 |
$7 |
$22 |
$95 |
$21 |
-$131 |
|
|
|
|
-147.46% |
<-Total Growth |
10 |
NCI |
|
|
Preferred Shareholders |
$13 |
$105 |
$183 |
$251 |
$288 |
$293 |
$330 |
$367 |
$383 |
$380 |
$373 |
$414 |
$352 |
|
|
|
|
92.35% |
<-Total Growth |
10 |
Preferred Shareholders |
|
|
Shareholders |
$779 |
$343 |
$1,609 |
$1,318 |
$2,030 |
$1,202 |
$498 |
$6,303 |
$2,330 |
$1,854 |
$6,121 |
$7,205 |
$4,622 |
|
|
|
|
187.26% |
<-Total Growth |
10 |
Comprehensive Income |
|
|
Increase |
24.84% |
-55.97% |
369.10% |
-18.09% |
54.02% |
-40.79% |
-58.57% |
1165.66% |
-63.03% |
-20.43% |
230.15% |
17.71% |
-35.85% |
|
|
|
|
-20.43% |
<-Median-> |
5 |
Comprehensive Income |
|
|
5 Yr Running Average |
$908 |
$874 |
$867 |
$935 |
$1,216 |
$1,300 |
$1,331 |
$2,270 |
$2,473 |
$2,437 |
$3,421 |
$4,763 |
$4,426 |
|
|
|
|
11.13% |
<-IRR #YR-> |
10 |
Comprehensive Income |
187.26% |
|
ROE |
10.0% |
5.0% |
17.1% |
10.5% |
14.0% |
6.6% |
0.9% |
10.2% |
4.0% |
3.5% |
11.5% |
13.8% |
8.5% |
|
|
|
|
-6.02% |
<-IRR #YR-> |
5 |
Comprehensive Income |
-26.67% |
|
5Yr Median |
10.0% |
10.0% |
10.0% |
10.0% |
10.5% |
10.5% |
10.5% |
10.2% |
6.6% |
4.0% |
4.0% |
10.2% |
8.5% |
|
|
|
|
17.71% |
<-IRR #YR-> |
10 |
5 Yr Running Average |
410.66% |
|
% Difference from NI |
-21.4% |
-43.8% |
260.8% |
14.2% |
-5586.5% |
-32.3% |
-80.3% |
150.6% |
-56.2% |
-37.8% |
5.2% |
178.3% |
-20.8% |
|
|
|
|
14.29% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
94.98% |
|
Median Values |
|
|
|
|
|
|
|
|
|
Diff |
5, 10 yr |
-26.6% |
-20.8% |
|
|
|
|
8.5% |
<-Median-> |
5 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,609 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$4,622 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$6,303 |
$0 |
$0 |
$0 |
$0 |
$4,622 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$867 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$4,426 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,270 |
$0 |
$0 |
$0 |
$0 |
$4,426 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current Liability
Coverage Ratio |
0.49 |
0.50 |
0.34 |
0.46 |
0.49 |
0.43 |
0.40 |
0.55 |
0.49 |
0.59 |
0.51 |
0.46 |
0.57 |
0.69 |
|
|
|
|
|
|
CFO / Current Liabilities |
|
|
5 year Median |
0.47 |
0.49 |
0.49 |
0.49 |
0.49 |
0.46 |
0.43 |
0.46 |
0.49 |
0.49 |
0.51 |
0.51 |
0.51 |
0.57 |
|
|
|
48.7% |
<-Median-> |
10 |
Current Liability Cov Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Asset Efficiency Ratio |
6.91% |
7.45% |
6.28% |
5.93% |
6.21% |
6.49% |
3.57% |
4.82% |
4.79% |
5.18% |
5.47% |
5.24% |
5.49% |
6.68% |
|
|
|
|
|
|
CFO / Total Assets |
|
|
5 year Median |
6.82% |
6.91% |
6.91% |
6.91% |
6.28% |
6.28% |
6.21% |
5.93% |
4.82% |
4.82% |
4.82% |
5.18% |
5.24% |
5.47% |
|
|
|
5.4% |
<-Median-> |
10 |
Return on Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Assets ROA |
2.89% |
1.29% |
0.77% |
1.58% |
-0.04% |
2.07% |
1.56% |
1.51% |
3.26% |
1.86% |
3.44% |
1.44% |
3.24% |
3.39% |
|
|
|
Net |
Income/Assets |
|
Return on Assets |
|
|
5Yr Median |
3.52% |
3.20% |
2.89% |
1.58% |
1.29% |
1.29% |
1.56% |
1.56% |
1.56% |
1.86% |
1.86% |
1.86% |
3.24% |
3.24% |
|
|
|
1.7% |
<-Median-> |
10 |
Asset Efficiency Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Return on Equity ROE |
12.73% |
8.98% |
4.74% |
9.22% |
-0.25% |
9.72% |
4.64% |
4.07% |
9.13% |
5.56% |
10.96% |
4.97% |
10.69% |
11.37% |
|
|
|
Net Inc/ |
Shareholders' equity |
|
Return on Equity |
|
|
5Yr Median |
13.60% |
12.94% |
12.73% |
9.22% |
8.98% |
8.98% |
4.74% |
4.64% |
4.64% |
5.56% |
5.56% |
5.56% |
9.13% |
10.69% |
|
|
|
7.3% |
<-Median-> |
10 |
Return on Equity |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$5,810 |
<-12 mths |
-0.50% |
|
|
|
|
|
|
|
Net Income |
$1,060.0 |
$943.0 |
$494.0 |
$1,608 |
-$159 |
$2,309 |
$3,266 |
$3,333 |
$5,827 |
$3,416 |
$6,314 |
$2,938 |
$6,058 |
|
|
|
|
1126.32% |
<-Total Growth |
10 |
Net Income |
|
|
NCI |
$56.0 |
$228.0 |
-$135.0 |
$203 |
-$410 |
$240 |
$407 |
$451 |
$122 |
$53 |
$125 |
-$65 |
-$133 |
|
|
|
|
1.48% |
<-Total Growth |
10 |
NCI |
|
|
Preferred Shareholders |
$13.0 |
$105.0 |
$183.0 |
$251 |
$288 |
$293 |
$330 |
$367 |
$383 |
$380 |
$373 |
$414 |
$352 |
|
|
|
|
92.35% |
<-Total Growth |
10 |
Preferred Shareholders |
|
|
Shareholders |
$991.0 |
$610.0 |
$446.0 |
$1,154 |
-$37 |
$1,776 |
$2,529 |
$2,515 |
$5,322 |
$2,983 |
$5,816 |
$2,589 |
$5,839 |
$6,108 |
$6,411 |
$7,602 |
|
1209.19% |
<-Total Growth |
10 |
Net Income |
|
|
Increase |
2.91% |
-38.45% |
-26.89% |
158.74% |
-103.21% |
4900.00% |
42.40% |
-0.55% |
111.61% |
-43.95% |
94.97% |
-55.48% |
125.53% |
4.61% |
4.96% |
18.58% |
|
EPS/CF Ratio should not be higher than 1.00 |
|
|
5 Yr Running Average |
$1,106.0 |
$1,088.0 |
$913.0 |
$832.8 |
$632.8 |
$789.8 |
$1,173.6 |
$1,587.4 |
$2,421.0 |
$3,025.0 |
$3,833.0 |
$3,845.0 |
$4,509.8 |
$4,667.0 |
$5,352.6 |
$5,709.8 |
|
29.33% |
<-IRR #YR-> |
10 |
Net Income |
1209.19% |
|
Operating Cash Flow |
$2,703.0 |
$2,874.0 |
$3,341.0 |
$2,547 |
$4,571 |
$5,211 |
$6,584 |
$10,502 |
$9,368 |
$9,781 |
$9,256 |
$11,230 |
$14,201 |
|
|
|
|
18.35% |
<-IRR #YR-> |
5 |
Net Income |
132.17% |
|
Investment Cash Flow |
-$4,017 |
-$6,204 |
-$9,431 |
-$11,891 |
-$7,933 |
-$5,192 |
-$11,002 |
-$3,017 |
-$4,658 |
-$5,177 |
-$10,657 |
-$5,270 |
-$6,043 |
|
|
|
|
17.32% |
<-IRR #YR-> |
10 |
5 Yr Running Average |
393.95% |
|
Total Accruals |
$2,305.0 |
$3,940.0 |
$6,536.0 |
$10,498 |
$3,325 |
$1,757 |
$6,947 |
-$4,970 |
$612 |
-$1,621 |
$7,217 |
-$3,371 |
-$2,319 |
|
|
|
|
23.22% |
<-IRR #YR-> |
5 |
5 Yr Running Average |
184.10% |
|
Total Assets |
$34,343 |
$47,172 |
$57,568 |
$72,857 |
$84,664 |
$85,832 |
$162,093 |
$166,905 |
$163,269 |
$160,276 |
$168,864 |
$179,608 |
$180,317 |
|
|
|
|
|
Balance Sheet |
|
Assets |
|
|
Accruals Ratio |
6.71% |
8.35% |
11.35% |
14.41% |
3.93% |
2.05% |
4.29% |
-2.98% |
0.37% |
-1.01% |
4.27% |
-1.88% |
-1.29% |
|
|
|
|
-1.01% |
<-Median-> |
5 |
Ratio |
|
|
EPS/CF Ratio |
0.43 |
0.18 |
0.13 |
0.27 |
-0.01 |
0.33 |
0.48 |
0.37 |
0.68 |
0.36 |
0.63 |
0.28 |
0.61 |
|
|
|
|
0.36 |
<-Median-> |
10 |
EPS/CF Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$446 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$5,839 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$2,515 |
$0 |
$0 |
$0 |
$0 |
$5,839 |
|
|
|
|
|
|
|
|
|
|
|
|
|
-$913 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$4,510 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-$1,587 |
$0 |
$0 |
$0 |
$0 |
$4,510 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change in Close |
35.38% |
12.94% |
7.88% |
28.72% |
-23.00% |
22.83% |
-12.99% |
-13.73% |
21.74% |
-21.15% |
21.37% |
7.10% |
-9.86% |
1.78% |
0.00% |
0.00% |
|
|
Count |
34 |
Years of data |
|
|
up/down |
Down |
Down |
Down |
Down |
Down |
|
|
|
|
|
|
|
|
|
|
|
|
|
Count |
15 |
44.12% |
|
|
Meet Prediction? |
|
|
|
|
Yes |
|
|
|
|
|
|
|
|
|
|
|
|
% right |
Count |
4 |
26.67% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financial Cash Flow |
$1,380.0 |
$1,776.0 |
$5,070.0 |
$9,770 |
$2,973 |
$1,102 |
$3,476 |
-$7,503 |
$4,745 |
-$4,770 |
$1,236 |
-$5,428 |
-$2,864 |
|
|
|
|
|
C F Statement |
|
Financial CF |
|
|
Total Accruals |
$925 |
$2,164 |
$1,466 |
$728 |
$352 |
$655 |
$3,471 |
$2,533 |
-$4,133 |
$3,149 |
$5,981 |
$2,057 |
$545 |
|
|
|
|
|
|
|
Accruals |
|
|
Accruals Ratio |
2.69% |
4.59% |
2.55% |
1.00% |
0.42% |
0.76% |
2.14% |
1.52% |
-2.53% |
1.96% |
3.54% |
1.15% |
0.30% |
|
|
|
|
1.15% |
<-Median-> |
5 |
Ratio |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change in Close |
35.38% |
12.94% |
7.88% |
28.72% |
-23.00% |
22.83% |
-12.99% |
-13.73% |
21.74% |
-21.15% |
21.37% |
7.10% |
-9.86% |
1.78% |
0.00% |
0.00% |
|
|
Count |
20 |
Years of data |
|
|
up/down |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Count |
1 |
5.00% |
|
|
Meet Prediction? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% right |
Count |
0 |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash |
$420 |
$1,776 |
$776 |
$1,261 |
$1,015 |
$2,117 |
$480 |
$637 |
$676 |
$490 |
$320 |
$907 |
$5,985 |
$5,985 |
|
|
|
|
|
|
Cash |
|
|
Cash per Share |
$0.54 |
$2.21 |
$0.93 |
$1.48 |
$1.17 |
$2.24 |
$0.28 |
$0.32 |
$0.33 |
$0.24 |
$0.16 |
$0.45 |
$2.82 |
$2.82 |
|
|
|
$0.33 |
<-Median-> |
5 |
Cash per Share |
|
|
Percentage of Stock
Price |
1.41% |
5.13% |
2.01% |
2.48% |
2.54% |
3.97% |
0.58% |
0.74% |
0.65% |
0.59% |
0.32% |
0.85% |
5.90% |
5.80% |
|
|
|
0.65% |
<-Median-> |
5 |
% of Stock Price |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Notes: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
March 16,
2024. Last estimates were for 2023,
2024 and 2025 of $52567M, $51208M and $49859M for Revenue, $5.49, $5.55 for
DCF, R301, $3.02 and $3.18 for AEPS, |
|
|
|
|
|
|
|
|
|
|
|
|
$3.03, $2.98
and $3.26 for EPS, $3.57, $3.68 and $3.78 for Dividends, $8730M, $9136M and
$8460M for FCF, $5.78, $5.82 and $6.08 for CFPS, $28.20, $26.20 and $25.30
for BVPS, $6016M, $6074M and $6787M for Net Income. |
|
|
|
|
|
|
|
March 15,
2023. Last estimates were for 2022,
2023 and 2024 of $49852M, $44057M and $55582M for Revenue, $5.26 and $5.40
for AFFO 2022/3, $2.89 and $2.98 for AEPS for 2022/3, |
|
|
|
|
|
|
|
|
|
|
$2.99, $3.14
and $3.40 for EPS, $3.45 and $3.57 and $3.66 for Dividends, $8592M, $9255M
and $10181 for FCF, $5.88, $5.96 and $6.02 for CFPS, and $6004M, $6438M and
$7162M for Net Income. |
|
|
|
|
|
|
|
|
|
March 19,
2022. Last estimates were for 2021,
2022 and 2023 of $44311M, $45554M and $58450M for Revenue, $481 and 5.22 for
AFFO for 2021-22, $2.65 and $2.87 for Adj EPS 2021-22, |
|
|
|
|
|
|
|
|
|
|
$2.64, $295
and $3.13 for EPS, $3.34, $3.48 and $3.60 for Dividends, $3170M, $8818M and
$9287M for FCF, $5.32, $5.83 and $5.47 for CFPS and $5406M, $6090M and $6175M
for Net Income. |
|
|
|
|
|
|
|
|
|
|
March 13,
2021. Last estimates were for 50124M,
$51963M and $54114M for Revenue, $4.72 and $4.96 2020 and 2021 for AFFO, $2.81 and $3.15
2020 and 2021 for Adj EPS, |
|
|
|
|
|
|
|
|
|
|
|
$2.59, $2.83
and $2.99 for EPS, $3.24, $3.43 and $3.60 for Dividends, $5745M, $9641M and
$11452M for FCF, $5.20, $5.63 and $6.02 for CFPS and $5302M, $5738M and
$5972M for Net Income. |
|
|
|
|
|
|
|
|
|
|
March 13,
2020, Last estimates were for 2019,
2020 and 2021 of $48716M, $50758M and $58697M for Revenue, $4.37 and $4.86
for ACFFO for 2019 and 2020, |
|
|
|
|
|
|
|
|
|
|
|
|
$2.53m $2.81
and $3.15 for Adjusted EPS, $2.42, $2.66 and $2.76 for EPS, $4.57, $4.87 and
$5.43 for CFPS, $4802M, $5333M and $6300M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
March 17,
2019. Last estimates were for 2018,
2019 and 2020 of $47300M, $48161M and $55006M for Revenue, $4.35 and $4.50
for 2018 and 2019 for ACFFO, |
|
|
|
|
|
|
|
|
|
|
|
|
$$2.49 and
$2.49 for Adj EPS for 2018 and 2019, $2.37, $2.57 and $2.85 for EPS, $4.97m
$5.19 and $5.70 for CFPS and $4070M, $4434M and $5121M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
March 11,
2018. Last estimates were for 2017,
2018 and 2019 of $45674M, $47658M and $56891M for Revenue, $4.09 and $4.57
for AFFo for 2017 and 2018, |
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.50 and
2.74 for 2017 and 2018 for Adjusted EPS, $2.37 and $2.63 and $2.92 for EPS,
$4.99, $5.44 and $6.03 for CFPS and $3208M, $4051M and $4807M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
March 11,
2017. Last estimates were for 2016,
2017 and 2018 of $38676M, $40696M and $43955M for Revenue, $3.93, $4.34 for
AFFO for 2016 and 2017, |
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.44 for
Adjusted EPS for 2016, $2.34, $2.51 and $2.90 for EPS, $5.05, $5.32 and $5.03
for CFPS and $1758M, $2382M and $2682M for Net Income. |
|
|
|
|
|
|
|
|
|
|
|
|
|
March 15,
2016. Last estimates were for 2015 and
2016 of 32681M and $32681M for Revenue, $2.75 and $3.23 for AFFO, $2.16 and
2.44 for Adj EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
|
$2.24, $2.66
and $3.10 for EPS for 2015, 2016 and 2017, $5.34 for 2015 for CFPS and $1889M
for 2015 for Net Income |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
March 22,
2015. Last estimates were for 2014 and
2015 of $31234M and $32681M for Revenue, $2.47 and 3.07 for AFFO, $1.89
and $2.24 for EPS, $4.72 and $5.34 for CFPS, $1534M and $1889M for Net
Income. |
|
|
|
|
|
|
|
|
February 22,
2014. Last estimates were for 2013,
2014 and 2014 of $25909M, 28014M and $29689M for Revenue, $2.33 and $2.79 for
AFFO, $1.74 and $2.07 Adjusted EPS, |
|
|
|
|
|
|
|
|
|
|
|
|
$1.81 and
$2.14 and $2.44 EPS and $4.26, 4.83 and $4.70 CFPS. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
April 9,
2013. Last estimates were for 2012,
2013 and 2014 of $19840M and $20711M for revenue, $1.62 and $1.89 Adj. EPS,
$1.65, 1.85 and $2.04 for EPS andf $3.42 and $3.78 for CFPS. |
|
|
|
|
|
|
|
|
|
|
Non-adjusted
EPS also included $105 million asset impairment to Stingray and Garden Banks
assets. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Feb 25,
2012. Last estimates I got were for
2011 and 2012 of $1.46 and $1.57 for Adj EPS, $1.43 and $1.56 for EPS and
$2.73 and 3.06 for CF. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Apr 10,
2011. Last estimates I got for 2010 and 2011 were $4.25 and $4.25 for
earnings $2.61 and $2.85 for Adj EPS and $4.80 and $5.57 for cash flow. |
|
|
|
|
|
|
|
|
|
|
|
|
|
Mar
2010. In June 2, 2009 I picked up 2009
and 2010 earnings of $2.21 and $2.46 and cash flow of $4.48 and $4.75. I made 14.5% per year return to end of
2009. |
|
|
|
|
|
|
|
|
|
|
|
|
AP
2008. April 2009. In Nov 2008 I picked up an earnings
estimate of 2.06 for Dec 2008 and $2.21 for 2009. Earnings for 2008 came in at $3.67 and
$3.64 diluted. |
|
|
|
|
|
|
|
|
|
|
|
|
This higher
than expected earnings for 2008 do not seem to have any effect on what is
expected in 2009. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AP 2007. I
have done ok on this stock. Div
increase nicely. It is on TD's Action Buy List |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AP
2006. TD has hold on this and
competitors except TransCdn Pipelines, which they have an action buy on. IRR
since purchase is 6%. Lost 18% this
year. Stock seems volitile. |
|
|
|
|
|
|
|
|
|
|
|
Dividend is
increasing nicely, but revenue is increasing much faster than EPS, which last
5 years is IRR of 4.5. 5 and 10 year stock price increase is good. Hold for now. Mike says yield is low for
current price. |
|
|
|
|
|
|
|
|
|
AP 2005. TD NewCrest has a hold rating on this
stock. I have only just bought it and
have not earned anything on it yet. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends
have been paid on this stock since 1952. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 1998, IPL
Energy became Enbridge Inc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 1992,
Interprovincial Pipe Line Inc. was acquired by Interprovincial Pipe Line
System Inc., which changed its name to IPL Energy Inc. in 1994, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
after the
acquisition of Consumers' Gas (now Enbridge Gas Distribution Inc.) and
diversification into the gas distribution business. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 1991, name
was changed to Interprovincial Pipe Line Inc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 1988,
names was changed to Interhome Energy Inc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 1953, IPL
Energy Inc was listed on the Toronto and Montreal stock exchanges |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
On April 30,
1949, the Company was stared as Interprovincial Pipe Line Company (IPL). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Shares are
diluted by company's interest in own shares at 20M, 25M and 22M from 2012-
2010. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In 2015,
Enbridge said it has been paying dividends for over 62 years. They have increased their dividends since
1996. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Comments April 19, 2013 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calgary
pipeline operator Enbridge is the only one out of 57 Canadian companies rated
by Morningstar that has both a wide moat and a positive |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
“moat
trend.” A key part of its competitive edge is its scale: it has pipeline
presences in the oil sands, the Bakken fields in the Midwest U.S., and |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
in Cushing,
Okla., as well as growth opportunities in natural gas and electricity. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Analyst
David McColl says Enbridge is just one of a handful of pipeline companies
“with the expertise, scale, access to capital, and geographic compared to recent prices around $45 |
|
|
|
|
|
|
|
|
|
|
|
reach to
successfully grow its pipeline transportation business.” He raised his
fair-value estimate for Enbridge shares this week to $54 (U.S.), |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sector: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Infrastructure, Utility |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What should
this stock accomplish? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
You should
expect moderte to good dividend yield and moderate dividend growth. Utilities should be a stable part of your portfolio. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Would I buy
this company and Why. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I like this
stock. It is a dividend growth
company. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Why am I following this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I am following this
stock as I own it. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Why I bought this
stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I first
bought this stock in 2005 and then bought more in 2008 and 2009. This stock was on the Dividend Achievers,
the Dividend Aristocrats list and also on Mike Higgs’ list of Canadian
Dividend Growth stocks. Enbridge is
considered to be a low risk stock. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dividends
are paid quarterly in Cycle 3, which is March, June, September and
December. Dividends are declared for
shareholders of record of one month and
paid near the first of the following month. |
|
|
|
|
|
|
|
|
|
|
For example,
the Dividend payable on December 1, 2013 was declared for shareholders of
record of November 15, 2013. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Misson
Statement or closes thing I can find. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What I am
looking for is a statement that the company wants to do well by their customers, employees, and community and and
thereby earn shareholders a reasonable return. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For customers Over the
past 65 years, Enbridge has become a leader in the
safe and reliable delivery of energy in North America |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For employees Enbridge
believes in sharing the success of our company
with the people who make it happen – our employees |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For community Our
perspective is holistic, and over the past decade
we've invested across a diverse spectrum of initiatives aimed at
strengthening our communities |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For investors There’s
an urgent need for more energy infrastructure in
North America, and Enbridge is playing a critical role in providing it. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Our
shareholders expect us to generate strong financial performance and returns on the capital they’ve invested in our business. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
How they make their
money |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enbridge owns
extensive midstream assets that transport hydrocarbons across the U.S. and
Canada. Its pipeline network consists of the Canadian Mainline system,
regional oil sands |
|
|
|
|
|
|
|
|
|
|
|
pipelines,
and natural gas pipelines. The company also owns and operates a regulated
natural gas utility and Canada's largest natural gas distribution company.
The firm has a small |
|
|
|
|
|
|
|
|
|
|
|
renewables
portfolio primarily focused on onshore and offshore wind projects |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Adjusted
earnings/(loss) represent earnings or loss applicable to common shareholders
adjusted for non-recurring or non-operating factors on both a consolidated
and segmented basis. Management believes that |
|
|
|
|
|
|
|
|
|
the
presentation of adjusted earnings/(loss) provides useful information to
investors and shareholders as it provides increased transparency and
predictive value. Management uses adjusted earnings/(loss) to set |
|
|
|
|
|
|
|
|
|
targets,
assess performance of the Company and set the Company’s dividend payout
target. This measure cannot be compared to what other companies use. |
|
|
|
|
|
|
|
|
|
|
|
|
|
A lot of
earnings quotes use "Adjusted Earnings" which is usually lower than
EPS. Values before 2005, from 2005
annual report. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
2016 |
Mar 11 |
2017 |
Mar 12 |
2018 |
Mar 17 |
2019 |
Mar 13 |
2020 |
Mar 13 |
2021 |
Mar 19 |
2022 |
Mar 15 |
2023 |
|
|
Mar 16 |
2024 |
|
|
|
|
Ebel, Gregory Lorne |
|
0.461 |
0.03% |
0.628 |
0.03% |
0.652 |
0.03% |
0.652 |
0.03% |
0.652 |
0.03% |
0.652 |
0.03% |
0.652 |
0.03% |
|
|
0.669 |
0.03% |
|
Chair, then CEO 2023 |
2.66% |
|
Director - Shares -
Amount |
|
|
$22.685 |
|
$26.646 |
|
$33.655 |
|
$26.537 |
|
$32.208 |
|
$34.496 |
|
$31.093 |
|
|
|
$32.490 |
|
|
|
|
Options - percentage |
|
0.729 |
0.04% |
0.411 |
0.02% |
0.419 |
0.02% |
0.428 |
0.02% |
0.437 |
0.02% |
0.650 |
0.03% |
0.968 |
0.05% |
|
|
1.867 |
0.09% |
|
|
92.97% |
|
Options - amount |
|
|
$35.849 |
|
$17.419 |
|
$21.650 |
|
$17.406 |
|
$21.594 |
|
$34.374 |
|
$46.158 |
|
|
|
$90.658 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monaco, Albert |
0.04% |
0.395 |
0.02% |
0.483 |
0.02% |
0.813 |
0.04% |
0.878 |
0.04% |
0.926 |
0.05% |
0.957 |
0.05% |
|
|
|
|
|
|
|
Ceased insider Jan 2023 |
|
|
CEO - Shares - Amount |
$21.175 |
|
$19.416 |
|
$20.472 |
|
$41.980 |
|
$35.749 |
|
$45.769 |
|
$50.661 |
|
|
|
|
|
|
|
|
|
|
Options - percentage |
0.43% |
4.945 |
0.29% |
4.547 |
0.22% |
5.045 |
0.25% |
5.920 |
0.29% |
5.775 |
0.29% |
6.131 |
0.30% |
|
|
|
|
|
|
|
|
|
|
Options - amount |
$230.076 |
|
$243.104 |
|
$192.855 |
|
$260.471 |
|
$240.985 |
|
$285.339 |
|
$324.429 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Murray, Patrick |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.026 |
0.00% |
|
|
#DIV/0! |
|
CFO - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$1.250 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.672 |
0.03% |
|
|
#DIV/0! |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$32.609 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yu, Vernon Dai-Chung |
|
|
|
|
|
|
|
|
|
0.165 |
0.01% |
0.175 |
0.01% |
0.181 |
0.01% |
|
|
|
|
|
Ceased insdier Jun 30,2024 |
-100.00% |
|
CFO - Shares - Amount |
|
|
|
|
|
|
|
|
|
|
$8.144 |
|
$9.259 |
|
$8.637 |
|
|
|
|
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
1.470 |
0.07% |
1.451 |
0.07% |
1.887 |
0.09% |
|
|
|
|
|
|
-100.00% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
$72.638 |
|
$76.791 |
|
$89.989 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gruending, Colin
Kenneth |
|
|
|
|
|
|
|
0.048 |
0.00% |
0.059 |
0.00% |
|
|
0.087 |
0.00% |
|
|
0.096 |
0.00% |
|
Was CFO, Officer 2022 |
10.13% |
|
Officer - Shares -
Amount |
|
|
|
|
|
|
|
|
$1.946 |
|
$2.939 |
|
|
|
$4.170 |
|
|
|
$4.674 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
1.310 |
0.06% |
1.443 |
0.07% |
|
|
1.453 |
0.07% |
|
|
1.658 |
0.08% |
|
|
14.08% |
|
Options - amount |
|
|
|
|
|
|
|
|
$53.324 |
|
$71.287 |
|
|
|
$69.317 |
|
|
|
$80.483 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Whelen, John Kendall |
0.01% |
0.080 |
0.00% |
0.123 |
0.01% |
0.203 |
0.01% |
0.204 |
0.01% |
|
|
|
|
|
|
|
|
|
|
|
Chief Dev Officer 2020 |
|
|
CFO - Shares - Amount |
$3.427 |
|
$3.952 |
|
$5.207 |
|
$10.503 |
|
$8.296 |
|
|
|
|
|
|
|
|
|
|
|
Ceased insider Nov 2020 |
|
|
Options - percentage |
0.17% |
1.492 |
0.09% |
1.548 |
0.08% |
2.267 |
0.11% |
1.897 |
0.09% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Options - amount |
$91.982 |
|
$73.355 |
|
$65.667 |
|
$117.054 |
|
$77.242 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Hansen, Cynthia Lynn |
|
|
|
0.059 |
0.00% |
0.114 |
0.01% |
0.114 |
0.01% |
0.184 |
0.01% |
0.215 |
0.01% |
0.220 |
0.01% |
|
|
0.229 |
0.01% |
|
|
4.11% |
|
Officer - Shares -
Amount |
|
|
|
|
$2.493 |
|
$5.898 |
|
$4.639 |
|
$9.095 |
|
$11.373 |
|
$10.498 |
|
|
|
$11.125 |
|
|
|
|
Options - percentage |
|
|
|
1.046 |
0.05% |
1.074 |
0.05% |
1.059 |
0.05% |
1.772 |
0.09% |
1.131 |
0.06% |
1.583 |
0.07% |
|
|
1.445 |
0.07% |
|
|
-8.69% |
|
Options - amount |
|
|
|
|
$44.362 |
|
$55.438 |
|
$43.114 |
|
$87.536 |
|
$59.840 |
|
$75.507 |
|
|
|
$70.176 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Banister, Gaurdie,
Edward |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.016 |
0.00% |
|
|
0.024 |
0.00% |
|
|
47.39% |
|
Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.785 |
|
|
|
$1.177 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
|
|
0.008 |
0.00% |
|
|
0.012 |
0.00% |
|
|
45.49% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$0.380 |
|
|
|
$0.563 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ashar, Mayank Mulraj |
|
|
|
|
|
|
|
|
|
|
|
0.064 |
0.00% |
0.064 |
0.00% |
|
|
0.064 |
0.00% |
|
|
0.00% |
|
Director - Shares -
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
$3.387 |
|
$3.053 |
|
|
|
$3.107 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
|
|
|
|
0.003 |
0.00% |
0.010 |
0.00% |
|
|
0.019 |
0.00% |
|
|
93.31% |
|
Options - amount |
|
|
|
|
|
|
|
|
|
|
|
|
$0.164 |
|
$0.480 |
|
|
|
$0.945 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Carter, Pamela L. |
|
|
|
|
|
|
|
0.043 |
0.00% |
0.045 |
0.00% |
0.046 |
0.00% |
0.048 |
0.00% |
|
|
0.054 |
0.00% |
|
Was dir, chair in 2023 |
11.56% |
|
Chairman - Shares - Amt |
|
|
|
|
|
|
|
|
$1.733 |
|
$2.206 |
|
$2.458 |
|
$2.294 |
|
|
|
$2.605 |
|
|
|
|
Options - percentage |
|
|
|
|
|
|
|
0.008 |
0.00% |
0.012 |
0.00% |
0.015 |
0.00% |
0.019 |
0.00% |
|
|
0.026 |
0.00% |
|
|
38.21% |
|
Options - amount |
|
|
|
|
|
|
|
|
$0.323 |
|
$0.569 |
|
$0.799 |
|
$0.886 |
|
|
|
$1.246 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Increase in O/S Shares |
0.46% |
3.000 |
0.32% |
3.000 |
0.18% |
2.000 |
0.10% |
3.000 |
0.15% |
1.000 |
0.05% |
4.072 |
0.20% |
2.000 |
0.10% |
|
|
1.401 |
0.07% |
|
|
|
|
due to SO 2013 |
$184.000 |
|
$169.500 |
|
$147.480 |
|
$84.820 |
|
$154.890 |
|
$40.710 |
|
$201.198 |
|
$105.840 |
|
|
|
$66.828 |
|
|
|
|
Book Value |
$76.000 |
|
$65.000 |
|
$90.000 |
|
$32.000 |
|
$69.000 |
|
$22.000 |
|
$31.000 |
|
$53.000 |
|
|
|
$77.000 |
|
|
|
|
Insider Buying |
-$0.909 |
|
-$0.136 |
|
-$1.791 |
|
-$0.728 |
|
-$1.247 |
|
-$0.908 |
|
-$0.309 |
|
-$0.546 |
|
|
|
-$0.237 |
|
|
|
|
Insider Selling |
$36.153 |
|
$8.811 |
|
$31.156 |
|
$4.020 |
|
$8.723 |
|
$2.120 |
|
$9.865 |
|
$4.387 |
|
|
|
$1.063 |
|
|
|
|
Net Insider Selling |
$35.244 |
|
$8.676 |
|
$29.365 |
|
$3.292 |
|
$7.476 |
|
$1.212 |
|
$9.556 |
|
$3.840 |
|
|
|
$0.826 |
|
|
|
|
% of Market Cap |
0.07% |
|
0.01% |
|
0.03% |
|
0.00% |
|
0.01% |
|
0.00% |
|
0.01% |
|
0.00% |
|
|
|
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Directors |
|
13 |
|
13 |
|
13 |
|
12 |
|
11 |
|
11 |
|
11 |
|
|
|
12 |
|
|
|
|
|
Women |
25% |
3 |
23% |
4 |
31% |
5 |
38% |
5 |
42% |
4 |
36% |
4 |
36% |
4 |
36% |
|
|
4 |
33% |
|
|
|
|
Minorities |
0% |
1 |
8% |
1 |
8% |
1 |
8% |
1 |
8% |
1 |
9% |
2 |
18% |
3 |
27% |
|
|
4 |
33% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Institutions/Holdings |
0.00% |
|
|
904 |
65.26% |
1,075 |
57.04% |
20 |
57.04% |
|
|
20 |
29.79% |
20 |
38.96% |
|
|
20 |
36.75% |
|
|
|
|
Total Shares Held |
0.00% |
|
|
1,106.324 |
54.71% |
1,153.809 |
57.06% |
1,153.809 |
57.06% |
|
|
603.580 |
29.81% |
788.952 |
37.13% |
|
|
781.233 |
36.76% |
|
|
|
|
Increase/Decrease |
#DIV/0! |
|
|
62.612 |
6.00% |
-5.398 |
-0.47% |
-5.398 |
-0.47% |
|
|
-36.500 |
-5.70% |
12.836 |
1.65% |
|
|
2.449 |
0.31% |
|
|
|
|
Starting No. of Shares |
Nasdaq |
|
|
1,043.711 |
Nasdaq |
1,159.207 |
Nasdaq |
1,159.207 |
TOP 2 MS |
|
|
640.079 |
TOP 2 MS |
776.116 |
TOP 2 MS |
|
|
778.784 |
TOP 2 MS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright ©
2008 Website of SPBrunner. All rights reserved. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
My stock |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|