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
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
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
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
# 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%
-$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