This report should not be construed as providing investment advice. It is for educational purposes only.  Before making any investment decision, you should always do your own research or consult a investment professional. Estimates Estimates Estimates
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Q1 2026
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ 3/31/26 <estimates
Emera Inc TSX: EMA OTC: EMRAF https://www.emera.com/ Fiscal Yr: Dec 31
Year 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 12/31/27 12/30/28 Value Description #Y Item Total G
Accounting Rules USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP USGAAP Accounting Rules
USD - CDN$ 1.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2732 1.2678 1.3544 1.3226 1.4389 1.3706 1.3718 1.3718 1.3718 USD - CDN$
Comments $8,526 <-12 mths -2.85%
Revenue* $2,230.2 $2,971.9 $2,789.3 $4,277 $6,226 $6,524 $6,111 $5,506 $5,765 $7,588 $7,563 $7,200 $8,776 $8,419 $8,977 $9,911 214.63% <-Total Growth 10 Revenue
Increase 8.34% 33.26% -6.14% 53.34% 45.57% 4.79% -6.33% -9.90% 4.70% 31.62% -0.33% -4.80% 21.89% -4.07% 6.63% 10.40% 12.15% <-IRR #YR-> 10 Revenue 214.63%
5 year Running Average $1,874 $2,176 $2,423 $2,865 $3,699 $4,558 $5,185 $5,729 $6,026 $6,299 $6,507 $6,724 $7,378 $7,909 $8,187 $8,657 9.77% <-IRR #YR-> 5 Revenue 59.39%
Revenue per Share $16.78 $20.67 $18.95 $20.36 $27.22 $27.87 $25.20 $21.90 $22.08 $28.11 $26.62 $24.33 $29.08 $27.90 $29.75 $32.84 11.78% <-IRR #YR-> 10 5 yr Running Average 204.53%
Increase 6.78% 23.16% -8.33% 7.48% 33.64% 2.39% -9.56% -13.11% 0.84% 27.29% -5.30% -8.60% 19.54% -4.07% 6.63% 10.40% 5.19% <-IRR #YR-> 5 5 yr Running Average 28.79%
5 year Running Average $15.17 $16.71 $17.78 $18.50 $20.80 $23.01 $23.92 $24.51 $24.85 $25.03 $24.78 $24.61 $26.04 $27.21 $27.54 $28.78 4.38% <-IRR #YR-> 10 Revenue per Share 53.49%
P/S (Price/Sales) Med 1.97 1.69 2.27 2.25 1.55 1.54 2.01 2.36 2.57 2.18 1.94 1.97 2.08 2.50 0.00 0.00 5.84% <-IRR #YR-> 5 Revenue per Share 32.81%
P/S (Price/Sales) Close 1.82 1.87 2.28 2.23 1.73 1.57 2.21 2.47 2.86 1.84 1.89 2.21 2.33 2.56 2.40 2.17 3.89% <-IRR #YR-> 10 5 yr Running Average 46.44%
*Revenue in M CDN $  P/S Med 20 yr  1.97 15 yr  2.01 10 yr  2.04 5 yr  2.08 25.25% Diff M/C 1.22% <-IRR #YR-> 5 5 yr Running Average 6.26%
-$2,789 $0 $0 $0 $0 $0 $0 $0 $0 $0 $8,776
-$5,506 $0 $0 $0 $0 $8,776
-$2,423 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,378
-$5,729 $0 $0 $0 $0 $7,378
-$18.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.08
-$21.90 $0.00 $0.00 $0.00 $0.00 $29.08
-$17.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.04
-$24.51 $0.00 $0.00 $0.00 $0.00 $26.04
AFFO* $2.72 $3.29 $3.30 $2.43 $2.61 $4.50 $3.45 $2.60 $2.22 $1.35 $5.61 $3.31 $3.96 $4.23 $3.98 20.00% <-Total Growth 10 AFFO
Increase 57.23% 20.96% 0.30% -26.36% 7.41% 72.41% -23.33% -24.64% -14.62% -39.19% 315.56% -41.00% 19.64% 6.82% -5.91% 1.84% <-IRR #YR-> 10 AFFO 20.00%
AFFO Yield 8.9% 8.5% 7.6% 5.4% 5.6% 10.3% 6.2% 4.8% 3.5% 2.6% 11.2% 6.2% 5.9% 5.9% 5.6% 8.78% <-IRR #YR-> 5 AFFO 52.31%
5 year Running Average $2.62 $2.69 $2.87 $3.23 $3.26 $3.12 $3.08 $2.82 $3.05 $3.02 $3.29 $3.69 $4.22 2.30% <-IRR #YR-> 10 5 yr Running Average 25.57%
Payout Ratio 51.93% 44.83% 50.38% 82.10% 81.70% 50.72% 68.84% 95.19% 115.99% 198.33% 49.69% 86.93% 73.42% 69.27% 73.62% 1.08% <-IRR #YR-> 5 5 yr Running Average 5.52%
5 year Running Average 55.15% 58.70% 60.47% 59.19% 64.13% 72.23% 76.98% 87.71% 84.64% 88.75% 84.04% 76.81% 68.43% 74.60% <-Median-> 10 Payout 5 yr Running Average
Price/AFFO Median 12.14 10.63 13.04 18.86 16.14 9.51 14.69 19.84 25.52 45.35 9.21 14.52 15.24 16.50 0.00 15.41 <-Median-> 10 P/AFFO Med
Price/AFFO High 13.63 11.98 14.31 20.40 15.08 10.49 16.94 23.31 28.54 47.95 10.52 15.57 17.47 17.36 0.00 16.26 <-Median-> 10 P/AFFO High
Price/AFFO Low 10.65 9.29 11.77 17.32 17.20 8.54 12.45 16.37 22.50 42.75 7.90 13.46 13.02 15.65 0.00 14.92 <-Median-> 10 P/AFFO Low
Price/AFFO Close 11.24 11.74 13.10 18.68 18.00 9.71 16.17 20.81 28.48 38.33 8.97 16.23 17.08 16.88 17.94 17.12 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 17.67 14.21 13.14 13.75 19.33 16.75 12.40 15.68 24.32 23.31 37.26 9.58 20.44 18.03 16.88 18.04 <-Median-> 10 Trailing P/AFFO Close
Median Values Historical   in order 15.00 16.33 13.46 16.23 P/AFFO 5 Yrs   in order 15.24 17.47 13.46 17.08 10.75% Diff M/C 9.50% Diff M/C 10 DPR 75% to 95% best
$3.36 <-12 mths -3.72%
Adjusted Net Income $259 $319 $330 $475 $524 $671 $621 $665 $723 $850 $809 $849 $1,045 216.67% <-Total Growth 10 Adjusted Net Income
Return on Equity ROE 12.39% 11.87% 9.45% 7.92% 8.21% 9.21% 8.22% 8.11% 8.32% 8.50% 7.59% 7.16% 8.74% 8.22% <-Median-> 10 Return on Equity ROE
5Yr Median 11.87% 9.45% 9.21% 8.22% 8.21% 8.22% 8.32% 8.22% 8.11% 8.32% 8.27% <-Median-> 10 5Yr Median
Adjusted EPS Diluted $1.95 $2.17 $2.25 $2.76 $2.45 $2.88 $2.58 $2.68 $2.81 $3.20 $2.95 $2.94 $3.49 54.69% <-Total Growth 10 Adjusted EPS Diluted
Adjusted EPS basic $1.96 $2.23 $2.26 $2.77 $2.46 $2.88 $2.59 $2.68 $2.81 $3.20 $2.96 $2.94 $3.49 $3.48 $3.60 $3.89 54.54% <-Total Growth 10 Adjusted EPS Excludes
Increase 5.95% 13.78% 1.35% 22.57% -11.19% 17.07% -10.07% 3.47% 4.85% 13.88% -7.50% -0.68% 18.80% -0.36% 3.45% 8.06% 4.45% <-IRR #YR-> 10 Adjusted EPS MTM
Earnings Yield 6.4% 5.8% 5.2% 6.1% 5.2% 6.6% 4.6% 5.0% 4.4% 6.2% 5.9% 5.5% 5.2% 4.9% 5.0% 5.4% 5.44% <-IRR #YR-> 5 Adjusted EPS Special Items
5 year Running Average $1.81 $1.94 $2.06 $2.21 $2.34 $2.52 $2.59 $2.68 $2.68 $2.83 $2.85 $2.92 $3.08 $3.21 $3.29 $3.48 4.12% <-IRR #YR-> 10 5 yr Running Average
Payout Ratio 72.07% 66.14% 73.56% 72.02% 86.69% 79.25% 91.70% 92.35% 91.64% 83.67% 94.17% 97.87% 83.25% 84.20% 81.39% 75.32% 2.86% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average 69.55% 69.33% 70.21% 71.43% 74.29% 75.77% 80.61% 84.16% 88.23% 87.46% 90.52% 91.79% 89.76% 0.00% 0.00% 0.00% 85.81% <-Median-> 10 Payout 5 yr Running Average
Price/Adj EPS Median 16.84 15.69 19.04 16.54 17.12 14.86 19.57 19.25 20.16 19.13 17.45 16.34 17.28 20.06 0.00 0.00 18.24 <-Median-> 10 P/AFFO Med
Price/Adj EPS High 18.91 17.67 20.89 17.89 16.00 16.39 22.56 22.61 22.54 20.23 19.93 17.53 19.80 21.10 0.00 0.00 20.08 <-Median-> 10 P/AFFO High
Price/Adj EPS Low 14.78 13.71 17.19 15.19 18.24 13.34 16.58 15.88 17.78 18.03 14.97 15.15 14.76 19.02 0.00 0.00 16.23 <-Median-> 10 P/AFFO Low
Price/AFFO Close 15.60 17.33 19.13 16.39 19.10 15.18 21.54 20.19 22.50 16.17 16.99 18.28 19.37 20.52 19.83 18.35 18.69 <-Median-> 10 P/AFFO Close
Trailing Price/AFFO Close 16.52 19.71 19.39 20.08 16.96 17.77 19.37 20.89 23.59 18.42 15.72 18.15 23.01 20.44 20.52 19.83 18.89 <-Median-> 10 Trailing P/AFFO Close
Median Values Historical   in order 16.98 19.00 15.06 17.80 P/AEPS 5 Yrs   in order 17.45 19.93 15.15 18.28 17.59% Diff M/C 12.46% Diff M/C 10 DPR 75% to 95% best
$3.41 <-12 mths 0.89%
Difference Basic and Diluted 0.00% 0.70% 0.37% 0.75% 0.80% 0.33% 0.00% 0.00% 0.00% 0.28% 0.00% 0.00% 0.29% 0.00 <-Median-> 10 Difference Basic and Diluted
EPS Basic $1.64 $2.84 $2.72 $1.33 $1.25 $3.05 $2.76 $3.78 $1.98 $3.56 $3.57 $1.71 $3.39 24.63% <-Total Growth 10 Earnings
EPS Diluted* $1.64 $2.82 $2.71 $1.32 $1.24 $3.04 $2.76 $3.78 $1.98 $3.55 $3.57 $1.71 $3.38 $3.56 $3.66 $4.08 24.72% <-Total Growth 10 Earnings
Increase -6.82% 71.95% -3.90% -51.29% -6.06% 145.16% -9.21% 36.96% -47.62% 79.29% 0.56% -52.10% 97.66% 5.24% 2.98% 11.38% 10 0 10 Years of Data, EPS P or N 100.00%
Earnings Yield 5.4% 7.3% 6.3% 2.9% 2.6% 7.0% 4.9% 7.0% 3.1% 6.9% 7.1% 3.2% 5.0% 5.0% 5.1% 5.7% 2.23% <-IRR #YR-> 10 Earnings 24.72%
5 year Running Average $1.71 $1.97 $2.18 $2.05 $1.95 $2.23 $2.21 $2.43 $2.56 $3.02 $3.13 $2.92 $2.84 $3.15 $3.18 $3.28 -2.21% <-IRR #YR-> 5 Earnings -10.58%
10 year Running Average $1.45 $1.62 $1.78 $1.80 $1.79 $1.97 $2.09 $2.30 $2.31 $2.48 $2.68 $2.57 $2.63 $2.86 $3.10 $3.20 2.67% <-IRR #YR-> 10 5 yr Running Average 30.18%
* Diluted ESP per share  E/P 10 Yrs 4.97% 5Yrs 5.00% 3.17% <-IRR #YR-> 5 5 yr Running Average 16.89%
-$2.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.38
-$3.78 $0.00 $0.00 $0.00 $0.00 $3.38
-$2.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.84
-$2.43 $0.00 $0.00 $0.00 $0.00 $2.84
Dividend* $2.94 $2.99 $3.02 Estimates Dividend*
Increase 1.22% 1.43% 1.17% Estimates Increase
Payout Ratio EPS 82.74% 81.49% 74.02% Estimates Payout Ratio EPS
Dividend US$ New Qrtly $0.329 $0.312 $0.280 $0.389 $0.450 $0.431 $0.472 $0.501 $0.523 $0.509 $0.542 $0.504 $0.534 Dividend US$ New Qrtly
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Dividend* $1.41 $1.48 $1.66 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.6775 $2.7875 $2.8775 $2.9075 $2.9300 $2.9300 $2.9300 74.89% <-Total Growth 10 Dividends
Increase 3.67% 4.42% 12.71% 20.00% 6.89% 7.03% 4.05% 4.21% 4.04% 3.98% 4.11% 3.23% 1.04% 0.77% 0.00% 0.00% 30 0 32 Years of data, Count P, N 93.75%
Average Increases 5 Year Running 8.00% 7.53% 7.50% 8.92% 9.54% 10.21% 10.14% 8.44% 5.25% 4.66% 4.08% 3.91% 3.28% 2.63% 1.83% 1.01% 6.84% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $1.26 $1.35 $1.45 $1.58 $1.74 $1.91 $2.09 $2.25 $2.37 $2.48 $2.58 $2.68 $2.77 $2.84 $2.89 $2.92 91.35% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 4.28% 4.22% 3.86% 4.35% 5.06% 5.33% 4.69% 4.80% 4.55% 4.37% 5.40% 5.99% 4.82% 4.20% 4.81% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 3.81% 3.74% 3.52% 4.03% 5.42% 4.84% 4.06% 4.08% 4.06% 4.14% 4.73% 5.58% 4.20% 3.99% 4.17% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 4.88% 4.82% 4.28% 4.74% 4.75% 5.94% 5.53% 5.81% 5.15% 4.64% 6.29% 6.46% 5.64% 4.43% 5.59% <-Median-> 10 Yield on Low Price AEPS
Yield on Close Price 4.62% 3.82% 3.85% 4.40% 4.54% 5.22% 4.26% 4.57% 4.07% 5.17% 5.54% 5.36% 4.30% 4.10% 4.10% 4.10% 4.56% <-Median-> 10 Yield on Close Price AFFO
Payout Ratio EPS 86.13% 52.30% 61.35% 151.14% 171.98% 75.08% 86.05% 65.48% 130.05% 75.42% 78.08% 168.27% 86.02% 82.37% 79.99% 71.81% 86.04% <-Median-> 10 DPR EPS Div Pd Cash
DPR EPS 5 Yr Running 73.54% 68.34% 66.28% 77.15% 89.18% 85.78% 94.38% 92.75% 92.50% 81.97% 82.42% 91.79% 97.43% 89.93% 90.88% 88.93% 90.49% <-Median-> 10 DPR EPS 5 Yr Running CFPS
Payout Ratio CFPS 33.27% 27.81% 36.30% 39.79% 40.89% 44.79% 37.76% 38.01% 56.73% 79.17% 35.34% 32.18% 48.69% 34.83% 33.63% 33.63% 40.34% <-Median-> 10 DPR CF FCF 1
DPR CF 5 Yr Running 37.28% 34.54% 35.39% 35.65% 35.63% 37.88% 39.89% 40.04% 42.82% 47.97% 45.06% 42.84% 45.00% 40.99% 36.15% 35.77% 41.43% <-Median-> 10 DPR CF 5 Yr Running FCF 2
Payout Ratio CFPS WC 32.49% 29.16% 31.55% 45.59% 37.61% 40.82% 36.04% 43.82% 50.28% 63.02% 33.90% 38.81% 34.29% 34.83% 33.63% 9491.75% 39.82% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 37.09% 35.29% 33.77% 35.63% 35.10% 36.77% 38.00% 40.40% 41.37% 45.53% 43.21% 43.69% 41.29% 38.56% 35.00% 44.10% 40.84% <-Median-> 10 DPR CF WC 5 Yr Running
Median 5 Yrs 10 Yr Med 10 Yr Cl 4.81% 4.56% 5 Yr Med 5 Yr Cl 4.82% 5.17% 5 Yr Med Payout 86.02% 48.69% 38.81% 3.27% <-IRR #YR-> 5 Dividends 17.47%
* Dividends per share  10 Yr Med and Cur. -14.64% -9.95% 5 Yr Med and Cur. -14.82% -20.69% Last Div Inc ---> $0.7250 $0.7325 1.03% 5.75% <-IRR #YR-> 10 Dividends 74.89%
Dividends Growth 15 6.30% <-IRR #YR-> 15 Dividends 150.11%
Dividends Growth 20 6.10% <-IRR #YR-> 20 Dividends 226.69%
Dividends Growth 25 5.09% <-IRR #YR-> 25 Dividends 246.13%
Dividends Growth 30 4.48% <-IRR #YR-> 30 Dividends
Dividends Growth 35 4.33% <-IRR #YR-> 32 Dividends
Dividends Growth 5 -$2.48 $0.00 $0.00 $0.00 $0.00 $2.91 Dividends Growth 5
Dividends Growth 10 -$1.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.91 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 $2.91 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 $2.91 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 $2.91 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 $2.91 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 $2.91
Historical Dividends Historical High Div 7.13% Low Div 3.77% 10 Yr High 6.44% 10 Yr Low 4.03% Med Div 4.80% Close Div 4.57% Historical Dividends
High/Ave/Median Values Curr diff Exp. -42.45% Exp 8.85% Exp. -36.28% 1.83% Exp. -14.51% Exp. -10.30% High/Ave/Median 
Future Dividend Yield Div Yd 4.82% earning in 5 Years at IRR of 3.27% Div Inc. 17.47% Future Dividend Yield
Future Dividend Yield Div Yd 5.66% earning in 10 Years at IRR of 3.27% Div Inc. 38.00% Future Dividend Yield
Future Dividend Yield Div Yd 6.65% earning in 15 Years at IRR of 3.27% Div Inc. 62.12% Future Dividend Yield
Future Dividend Paid Div Paid $3.44 earning in 5 Years at IRR of 3.27% Div Inc. 17.47% Future Dividend Paid
Future Dividend Paid Div Paid $4.04 earning in 10 Years at IRR of 3.27% Div Inc. 38.00% Future Dividend Paid
Future Dividend Paid Div Paid $4.75 earning in 15 Years at IRR of 3.27% Div Inc. 62.12% Future Dividend Paid
Dividend Covering Cost Total Div $15.64 over 5 Years at IRR of 3.27% Div Cov. 21.91% Dividend Covering Cost
Dividend Covering Cost Total Div $30.57 over 10 Years at IRR of 3.27% Div Cov. 42.82% Dividend Covering Cost
Dividend Covering Cost Total Div $48.11 over 15 Years at IRR of 3.27% Div Cov. 67.39% Dividend Covering Cost
I am earning GC Div Gr 125.38% 09/08/11 # yrs -> 15 2011 $28.87 Cap Gain 147.32% I am earning GC
I am earning Div org yield 4.50% 1/31/15 Pension Div G Yrly 26.28% Div start $1.30 -4.50% 10.15% I am earning Div
I am earning GC Div Gr 229.21% 15/07/05 # yrs -> 21 2005 $18.65 Cap Gain 282.84% I am earning GC
I am earning Div org yield 4.77% 1/31/15 Pension Div G Yrly 13.28% Div start $0.89 -4.77% 15.71% I am earning Div
Yield if held 5 years 6.74% 6.68% 6.01% 6.46% 6.29% 6.91% 6.79% 5.75% 5.62% 6.36% 6.51% 5.68% 5.64% 5.17% 4.79% 5.67% 6.33% <-Median-> 10 Paid Median Price
Yield if held 10 years 8.37% 8.62% 8.88% 9.84% 10.52% 10.89% 10.75% 8.95% 8.33% 7.90% 8.44% 8.22% 6.76% 6.39% 6.96% 6.84% 8.69% <-Median-> 10 Paid Median Price
Yield if held 15 years 8.22% 8.66% 10.76% 13.34% 12.73% 13.53% 13.88% 13.22% 12.70% 13.21% 13.30% 13.02% 10.51% 9.48% 8.65% 8.87% 13.22% <-Median-> 10 Paid Median Price
Yield if held 20 years 12.02% 12.29% 14.30% 15.20% 14.64% 13.29% 13.95% 16.02% 17.22% 15.99% 16.52% 16.82% 15.53% 14.45% 14.45% 13.98% 15.76% <-Median-> 10 Paid Median Price
Yield if held 25 years 19.43% 19.79% 21.29% 19.62% 18.38% 16.23% 16.90% 18.82% 19.60% 17.49% 17.37% 19.12% <-Median-> 8 Paid Median Price
Yield if held 30 years 23.72% 23.98% 25.01% 22.32% 20.12% 17.06%
Cost covered if held 5 years 29.97% 30.44% 26.12% 25.59% 25.61% 28.92% 29.86% 26.16% 25.84% 29.41% 30.11% 26.42% 26.80% 25.03% 23.57% 28.22% 26.61% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 64.05% 66.63% 65.02% 65.49% 71.58% 75.53% 77.72% 66.82% 63.92% 62.16% 67.96% 68.14% 58.29% 56.79% 63.68% 64.16% 67.39% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 87.60% 92.16% 106.88% 118.11% 113.01% 120.64% 127.69% 125.17% 123.88% 132.68% 137.04% 138.33% 116.79% 109.82% 104.75% 112.11% 124.53% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 161.83% 164.42% 177.31% 166.15% 158.81% 143.19% 153.52% 179.76% 197.31% 186.96% 197.05% 205.96% 199.03% 193.82% 203.89% 206.60% 183.36% <-Median-> 10 Paid Median Price
Cost covered if held 25 years 243.09% 251.48% 274.17% 256.36% 243.84% 218.24% 232.19% 269.24% 292.16% 273.12% 283.45% 247.66% <-Median-> 8 Paid Median Price
Cost covered if held 30 years 352.79% 363.08% 393.10% 364.40% 342.93% 303.10%
Yr  Item Tot. Growth
Revenue Growth  $5,506.0 $5,765.0 $7,588.0 $7,563.0 $7,200.0 $8,776.0 $8,526 <-12 mths -2.85% 59.39% <-Total Growth 5 Revenue Growth  59.39%
AEPS Growth $2.68 $2.81 $3.20 $2.96 $2.94 $3.49 $3.36 <-12 mths -3.72% 30.32% <-Total Growth 5 AEPS Growth 30.32%
Net Income Growth $938.0 $510.0 $945.0 $978.0 $494.0 $1,014.0 $1,023 <-12 mths 0.89% 8.10% <-Total Growth 5 Net Income Growth 8.10%
Cash Flow Growth $1,637.0 $1,185.0 $913.0 $2,241.0 $2,646.0 $1,802.0 10.08% <-Total Growth 5 Cash Flow Growth 10.08%
Dividend Growth $2.48 $2.58 $2.68 $2.79 $2.88 $2.91 $2.93 <-12 mths 0.77% 17.47% <-Total Growth 5 Dividend Growth 17.47%
Stock Price Growth $54.10 $63.22 $51.75 $50.30 $53.73 $67.64 $55.71 <-12 mths -17.64% 25.03% <-Total Growth 5 Stock Price Growth 25.03%
Revenue Growth  $2,789.3 $4,277.0 $6,226.0 $6,524.0 $6,111.0 $5,506.0 $5,765.0 $7,588.0 $7,563.0 $7,200.0 $8,776.0 $8,419 <-this year -4.07% 214.63% <-Total Growth 10 Revenue Growth  214.63%
AEPS Growth $2.26 $2.77 $2.46 $2.88 $2.59 $2.68 $2.81 $3.20 $2.96 $2.94 $3.49 $3.48 <-this year -0.36% 54.54% <-Total Growth 10 AEPS Growth 54.54%
Net Income Growth $397.2 $227.0 $266.0 $710.0 $663.0 $938.0 $510.0 $945.0 $978.0 $494.0 $1,014.0 $1,064 <-this year 4.93% 155.29% <-Total Growth 10 Net Income Growth 155.29%
Cash Flow Growth $674.2 $1,053.0 $1,193.0 $1,193.0 $1,525.0 $1,637.0 $1,185.0 $913.0 $2,241.0 $2,646.0 $1,802.0 $2,538 <-this year 40.87% 167.28% <-Total Growth 10 Cash Flow Growth 167.28%
Dividend Growth $1.66 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $2.91 $2.94 <-this year 1.22% 74.89% <-Total Growth 10 Dividend Growth 74.89%
Stock Price Growth $43.23 $45.39 $46.98 $43.71 $55.79 $54.10 $63.22 $51.75 $50.30 $53.73 $67.64 $56.32 <-this year -16.73% 56.47% <-Total Growth 10 Stock Price Growth 56.47%
Dividends on Shares $47.88 $51.18 $54.78 $57.00 $59.40 $61.80 $64.26 $66.90 $69.06 $69.78 $70.32 $70.32 $70.32 $602.04 No of Years 10 Total Divs 12/31/15
Paid  $1,037.52 $1,089.36 $1,127.52 $1,049.04 $1,338.96 $1,298.40 $1,517.28 $1,242.00 $1,207.20 $1,289.52 $1,623.36 $1,713.60 $1,713.60 $1,713.60 $1,623.36 No of Years 10 Worth $43.23
Total $2,225.40 Total
Graham No. AEPS $26.36 $30.63 $34.72 $42.18 $39.29 $44.90 $42.61 $44.35 $45.89 $51.66 $49.97 $51.48 $55.81 $55.71 $56.66 $58.90 60.72% <-Total Growth 10 Graham Price AEPS
Price/GP Ratio Med 1.25 1.14 1.24 1.09 1.07 0.95 1.19 1.16 1.23 1.19 1.03 0.93 1.08 1.25 1.08 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.41 1.29 1.36 1.17 1.00 1.05 1.37 1.37 1.38 1.25 1.18 1.00 1.24 1.32 1.21 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.10 1.00 1.12 1.00 1.14 0.86 1.01 0.96 1.09 1.12 0.89 0.87 0.92 1.19 0.98 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.16 1.26 1.24 1.08 1.20 0.97 1.31 1.22 1.38 1.00 1.01 1.04 1.21 1.28 1.26 1.21 1.14 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 15.96% 26.13% 24.50% 7.61% 19.58% -2.65% 30.92% 21.99% 37.78% 0.18% 0.66% 4.38% 21.20% 28.17% 26.01% 21.23% 13.59% <-Median-> 10 Graham Price
Graham No. EPS $24.11 $34.45 $38.02 $29.12 $27.89 $46.13 $43.99 $52.67 $38.52 $54.41 $54.88 $39.26 $54.90 $56.32 $57.15 $60.32 44.39% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 1.37 1.02 1.13 1.57 1.51 0.93 1.15 0.98 1.47 1.13 0.94 1.22 1.10 1.24 1.14 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.54 1.14 1.24 1.70 1.41 1.02 1.33 1.15 1.64 1.19 1.07 1.31 1.26 1.30 1.29 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.20 0.89 1.02 1.45 1.61 0.83 0.98 0.81 1.30 1.06 0.81 1.13 0.94 1.18 1.02 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.27 1.12 1.14 1.56 1.68 0.95 1.27 1.03 1.64 0.95 0.92 1.37 1.23 1.27 1.25 1.18 1.25 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 26.77% 12.16% 13.69% 55.89% 68.42% -5.24% 26.82% 2.72% 64.13% -4.89% -8.34% 36.86% 23.20% 26.77% 24.93% 18.37% 25.01% <-Median-> 10 Graham Price
Price Close $30.57 $38.64 $43.23 $45.39 $46.98 $43.71 $55.79 $54.10 $63.22 $51.75 $50.30 $53.73 $67.64 $71.40 $71.40 $71.40 56.47% <-Total Growth 10 Stock Price
Increase -12.00% 26.40% 11.88% 5.00% 3.50% -6.96% 27.64% -3.03% 16.86% -18.14% -2.80% 6.82% 25.89% 5.56% 0.00% 0.00% 19.18 <-Median-> 10 CAPE (10 Yr P/E)
P/E 18.64 13.70 15.95 34.39 37.89 14.38 20.21 14.31 31.93 14.58 14.09 31.42 20.01 20.07 19.49 17.50 4.57% <-IRR #YR-> 5 Stock Price 25.03%
Trailing P/E 17.37 23.56 15.33 16.75 35.59 35.25 18.35 19.60 16.72 26.14 14.17 15.05 39.56 21.12 20.07 19.49 4.58% <-IRR #YR-> 10 Stock Price 56.47%
CAPE (10 Yr P/E) 18.06 17.41 17.07 18.15 19.63 18.95 19.29 18.50 19.80 19.06 18.42 19.81 20.23 19.55 18.81 19.07 9.24% <-IRR #YR-> 5 Price & Dividend 55.16%
Median 10, 5 Yrs D.  per yr 4.72% 4.68% % Tot Ret 50.74% 50.58% T P/E 18.98 16.72 P/E:  20.11 20.01 9.29% <-IRR #YR-> 10 Price & Dividend 118.34%
Price 15 D.  per yr 4.59% % Tot Ret 46.61% CAPE Diff 4.68% 5.26% <-IRR #YR-> 15 Stock Price 115.76%
Price  20 D.  per yr 4.64% % Tot Ret 43.57% 6.01% <-IRR #YR-> 20 Stock Price 221.48%
Price  25 D.  per yr 4.41% % Tot Ret 44.45% 5.51% <-IRR #YR-> 25 Stock Price 282.15%
Price  30 D.  per yr 4.94% % Tot Ret 46.04% 5.79% <-IRR #YR-> 30 Stock Price
Price  35 D.  per yr 5.20% % Tot Ret 47.59% 5.73% <-IRR #YR-> 33 Stock Price
Price & Dividend 15 9.85% <-IRR #YR-> 15 Price & Dividend 222.53%
Price & Dividend 20 10.65% <-IRR #YR-> 20 Price & Dividend 402.79%
Price & Dividend 25 9.92% <-IRR #YR-> 25 Price & Dividend 521.91%
Price & Dividend 30 10.73% <-IRR #YR-> 30 Price & Dividend
Price & Dividend 35 10.94% <-IRR #YR-> 33 Price & Dividend
Price  5 -$54.10 $0.00 $0.00 $0.00 $0.00 $67.64 Price  5
Price 10 -$43.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $67.64 Price 10
Price & Dividend 5 -$54.10 $2.58 $2.68 $2.79 $2.88 $70.55 Price & Dividend 5
Price & Dividend 10 -$43.23 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $70.55 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 $67.64 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 $67.64 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 $67.64 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 $67.64 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 $67.64 Price  35
Price & Dividend 15 $1.41 $1.48 $1.66 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $70.55 Price & Dividend 15
Price & Dividend 20 $1.41 $1.48 $1.66 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $70.55 Price & Dividend 20
Price & Dividend 25 $1.41 $1.48 $1.66 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $70.55 Price & Dividend 25
Price & Dividend 30 $1.41 $1.48 $1.66 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $70.55 Price & Dividend 30
Price & Dividend 35 $1.41 $1.48 $1.66 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $70.55 Price & Dividend 35
Price H/L Median $33.02 $34.99 $43.04 $45.82 $42.12 $42.81 $50.69 $51.59 $56.66 $61.22 $51.65 $48.05 $60.36 $69.81 40.25% <-Total Growth 10 Stock Price
Increase -2.57% 5.97% 23.01% 6.47% -8.09% 1.64% 18.42% 1.77% 9.83% 8.06% -15.64% -6.97% 25.62% 15.67% 3.44% <-IRR #YR-> 10 Stock Price 40.25%
P/E 20.13 12.41 15.88 34.71 33.96 14.08 18.37 13.65 28.61 17.25 14.47 28.10 17.86 19.63 3.19% <-IRR #YR-> 5 Stock Price 17.00%
Trailing P/E 18.76 21.33 15.26 16.91 31.91 34.52 16.67 18.69 14.99 30.92 14.55 13.46 35.30 20.65 8.40% <-IRR #YR-> 10 Price & Dividend 102.40%
P/E on Running 5 yr Aveage 19.33 17.78 19.74 22.35 21.64 19.23 22.90 21.25 22.13 20.26 16.51 16.47 21.27 22.14 8.22% <-IRR #YR-> 5 Price & Dividend 48.60%
P/E on Running 10 yr Aveage 22.78 21.66 24.22 25.50 23.54 21.76 24.24 22.39 24.58 24.65 19.29 18.72 22.92 24.44 15.68 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 4.96% 5.03% % Tot Ret 59.03% 61.19% T P/E 17.80 14.99 P/E:  18.11 17.86 Count 33 Years of data
-$43.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $60.36
-$51.59 $0.00 $0.00 $0.00 $0.00 $60.36
-$43.04 $2.00 $2.13 $2.28 $2.38 $2.48 $2.58 $2.68 $2.79 $2.88 $63.26
-$51.59 $2.58 $2.68 $2.79 $2.88 $63.26
High Months Apr Nov Aug Jul Oct Jan Sep Jan Dec Apr May Jan Oct Mar
Price High $37.06 $39.40 $47.22 $49.56 $39.35 $47.19 $58.44 $60.60 $63.35 $64.73 $58.99 $51.54 $69.17 $73.43 46.48% <-Total Growth 10 Stock Price
Increase 4.93% 6.31% 19.85% 4.96% -20.60% 19.92% 23.84% 3.70% 4.54% 2.18% -8.87% -12.63% 34.21% 6.16% 3.89% <-IRR #YR-> 10 Stock Price 46.48%
P/E 22.60 13.97 17.42 37.55 31.73 15.52 21.17 16.03 31.99 18.23 16.52 30.14 20.46 20.64 2.68% <-IRR #YR-> 5 Stock Price 14.14%
Trailing P/E 21.06 24.02 16.74 18.29 29.81 38.06 19.22 21.96 16.76 32.69 16.62 14.44 40.45 21.72 17.30 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 20.59 16.76 P/E:  20.82 20.46 21.37 P/E Ratio Historical High
-$47.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $69.17
-$60.60 $0.00 $0.00 $0.00 $0.00 $69.17
Low Months Sep Jan Jan Jan Feb  Dec Jan Mar Feb Feb Oct Jul Jan Feb
Price Low $28.97 $30.57 $38.85 $42.08 $44.88 $38.42 $42.94 $42.57 $49.96 $57.71 $44.30 $44.55 $51.54 $66.19 32.66% <-Total Growth 10 Stock Price
Increase -10.72% 5.52% 27.09% 8.31% 6.65% -14.39% 11.76% -0.86% 17.36% 15.51% -23.24% 0.56% 15.69% 28.42% 2.87% <-IRR #YR-> 10 Stock Price 32.66%
P/E 17.66 10.84 14.34 31.88 36.19 12.64 15.56 11.26 25.23 16.26 12.41 26.05 15.25 18.61 3.90% <-IRR #YR-> 5 Stock Price 21.07%
Trailing P/E 16.46 18.64 13.78 15.53 34.00 30.98 14.13 15.42 13.22 29.15 12.48 12.48 30.14 19.58 13.76 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 15.48 13.22 P/E:  15.91 16.26 10.86 P/E Ratio Historical Low
-$38.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $51.54
-$42.57 $0.00 $0.00 $0.00 $0.00 $51.54
Free Cash Flow Mkt Scr -$986 -$1,174 -$1,683 -$696 -$505 -$1,730 -$1,190 -$605 <-Total Growth 5 Free Cash Flow Mkt Scr
Change -19.07% -43.36% 58.65% 27.44% -242.57% 31.21% 49.17% -19.07% <-Median-> 5 Change
Free Cash Flow MS -$110.00 -$230.00 -$360 -$900 -$1,200 -$1,020 -$1,450 -$600 -$960 -$970 <-Total Growth 9 Free Cash Flow MS
Change -109.09% -56.52% -150.00% -33.33% 15.00% -42.16% 58.62% -60.00% -1.04% -42.16% <-Median-> 9 Change
Free Cash Flow WSJ $247 $312 $247 -$27 -$336 -$472 -$970 -$986 -$1,174 -$1,683 -$696 -$505 -$1,730 -$1,190 -$605 -800.40% <-Total Growth 10 Free Cash Flow MS, WSJ
Change 786.11% 26.32% -20.83% -110.93% -1144.44% -40.48% -105.51% -1.65% -19.07% -43.36% 58.65% 27.44% -242.57% 31.21% 49.17% 11.90% <-IRR #YR-> 5 Free Cash Flow MS -75.46%
FCF/CF from Op Ratio 0.44 0.41 0.37 -0.03 -0.28 -0.40 -0.64 -0.60 -0.99 -1.84 -0.31 -0.19 -0.96 -0.47 -0.23 #NUM! <-IRR #YR-> 10 Free Cash Flow MS -800.40%
Dividends paid $186 $210 $240 $221 $287 $346 $378 $409 $443 $472 $488 $538 $576 $884 $884 140.00% <-Total Growth 10 Dividends paid
Percentage paid 97.17% -818.52% -85.42% -73.31% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Percentage paid
5 Year Coverage -94.48% -58.80% -47.31% -38.75% -39.75% -46.59% -43.49% -50.97% -71.32% -46.59% <-Median-> 7 5 Year Coverage
Dividend Coverage Ratio 1.03 -0.12 -1.17 -1.36 -2.57 -2.41 -2.65 -3.57 -1.43 -0.94 -3.00 -1.35 -0.68 -1.92 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage -1.06 -1.70 -2.11 -2.58 -2.52 -2.15 -2.30 -1.96 -1.40 -2.15 <-Median-> 7 5 Year of Coverage
$986 $0 $0 $0 $0 -$1,730
-$247 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$1,730
Free Cash Flow TD $571 $359 $1,535 $956 $1,186 $1,291 $1,241 107.71% <-Total Growth 4 Free Cash Flow
Change -37.13% 327.58% -37.72% 24.06% 8.85% -3.87% 20.05% <-IRR #YR-> 4 Free Cash Flow MS from TD
FCF/CF from Op Ratio 0.48 0.39 0.68 0.36 0.66 0.51 0.47 20.05% <-IRR #YR-> 4 Free Cash Flow MS Morning Action
Dividends paid 443.00 472.00 488.00 538.00 576.00 884.16 884.16 30.02% <-Total Growth 4 Dividends paid Notes
Percentage paid 77.58% 131.48% 31.79% 56.28% 48.57% 68.49% 71.25% 56.28% <-Median-> 5 Percentage paid
5 Year Coverage 77.58% 98.39% 56.92% 56.74% 54.63% 55.53% 54.28% 56.92% <-Median-> 5 5 Year Coverage
Dividend Coverage Ratio 1.29 0.76 3.15 1.78 2.06 1.46 1.40 1.78 <-Median-> 5 Dividend Coverage Ratio
5 Year of Coverage 1.29 1.02 1.76 1.76 1.83 1.80 1.84 1.76 <-Median-> 5 5 Year of Coverage
-$571 0.00 0.00 0.00 $1,186
-$571 0.00 0.00 0.00 $1,186
Dividends paid (Calc) $187.71 $212.08 $244.74 $418.99 $487.85 $534.38 $575.89 $622.29 $672.26 $722.79 $791.98 $851.57 $877.37 $888.08 $900.75 $911.32 258.49% <-Total Growth 10 Dividends paid (Calc)
Change 12.98% 15.40% 71.20% 16.44% 9.54% 7.77% 8.06% 8.03% 7.52% 9.57% 7.52% 3.03% 1.22% 1.43% 1.17% 8.04% <-Median-> 10 Change
Dividend Paid in Cash $185.60 $210.00 $240.00 $221.00 $287.00 $346.00 $378.00 $409.00 $443.00 $472.00 $488.00 $538.00 $576.00 140.00% <-Total Growth 10 Dividend Paid in Cash
Change 13.15% 14.29% -7.92% 29.86% 20.56% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% 9.25% <-Median-> 10 Change
Covered by Net Income 85.33% 51.64% 60.42% 97.36% 107.89% 48.73% 57.01% 43.60% 86.86% 49.95% 49.90% 108.91% 56.80% 56.91% <-Median-> 10 Covered by Net Income
5 year average 74.28% 70.92% 68.82% 57.23% 57.46% 67.84% 70.48% 68.82% <-Median-> 7 5 year average
Dividends Paid in Cash per Share $1.40 $1.46 $1.63 $1.05 $1.25 $1.48 $1.56 $1.63 $1.70 $1.75 $1.72 $1.82 $1.91 17.08% <-Total Growth 10 Div Paid in Cash per Share
Covered by EPS 85.16% 51.79% 60.16% 79.72% 101.17% 48.61% 56.48% 43.03% 85.70% 49.25% 48.11% 106.31% 56.47% 56.48% <-Median-> 10 Covered by EPS
5 year average 69.23% 65.80% 67.00% 56.62% 56.52% 66.48% 69.17% 66.48% <-Median-> 7 5 year average
Market Cap $4,062 $5,556 $6,364 $9,533 $10,748 $10,233 $13,528 $13,602 $16,505 $13,970 $14,291 $15,901 $20,411 $21,546 $21,546 $21,546 220.73% <-Total Growth 10 Market Cap
Market Cap/Assets Ratio 0.46 0.56 0.53 0.33 0.37 0.32 0.42 0.44 0.48 0.35 0.36 0.37 0.46 0.48 0.48 0.48 0.37 <-Median-> 10 MC/Assets Ratio
Diluted # of Shares in Million 132.90 147.00 146.40 172.20 214 233.0 240.5 248.2 257.6 265.9 273.8 289.2 299.7 299.7 104.71% <-Total Growth 10 Diluted
Change 6.07% 10.61% -0.41% 17.62% 24.27% 8.88% 3.22% 3.20% 3.79% 3.22% 2.97% 5.62% 3.63% 0.00% 3.71% <-Median-> 10 Change
Difference Diluted/Basic -0.2% -2.6% -0.4% -0.5% -0.5% 0.2% -0.2% -0.2% -0.2% -0.2% 0.3% 0.0% -0.2% -0.2% -0.16% <-Median-> 10 Difference Diluted/Basic
Average # of Shares in Million 132.60 143.20 145.80 171.40 213 233.5 239.9 247.8 257.2 265.5 274.6 289.1 299.2 299.2 105.21% <-Total Growth 10 Average
Change 6.16% 7.99% 1.82% 17.56% 24.27% 9.62% 2.74% 3.29% 3.79% 3.23% 3.43% 5.28% 3.49% 0.00% 3.64% <-Median-> 10 Change
Difference Basic/Outstanding 0.2% 0.4% 1.0% 22.5% 7.4% 0.3% 1.1% 1.5% 1.5% 1.7% 3.5% 2.4% 0.9% 0.9% 1.59% <-Median-> 10 Difference Basic/Outstanding
# of Share in M 132.89 143.78 147.21 210.02 228.77 234.12 242.48 251.43 261.07 269.95 284.12 295.94 301.76 301.76 301.76 301.76 7.44% <-IRR #YR-> 10 Shares 104.99%
Increase 1.46% 8.19% 2.39% 42.67% 8.93% 2.34% 3.57% 3.69% 3.83% 3.40% 5.25% 4.16% 1.97% 0.00% 0.00% 0.00% 3.72% <-IRR #YR-> 5 Shares 20.02%
CF fr Op $Millon $564.2 $762.5 $674.2 $1,053.0 $1,193.0 $1,193.0 $1,525.0 $1,637.0 $1,185.0 $913.0 $2,241.0 $2,646.0 $1,802.0 $2,538.4 $2,629.2 $9.3 167.28% <-Total Growth 10 Cash Flow
Change 41.90% 35.15% -11.58% 56.19% 13.30% 0.00% 27.83% 7.34% -27.61% -22.95% 145.45% 18.07% -31.90% 40.87% 3.58% -99.65% SO, DRIP E PP, S. Issues
5 year Running Average $416.1 $508.0 $559.6 $690.3 $849.4 $975.1 $1,127.6 $1,320.2 $1,346.6 $1,290.6 $1,500.2 $1,724.4 $1,757.4 $2,028.1 $2,371.3 $1,925.0 214.05% <-Total Growth 10 CF 5 Yr Running
CFPS $4.25 $5.30 $4.58 $5.01 $5.21 $5.10 $6.29 $6.51 $4.54 $3.38 $7.89 $8.94 $5.97 $8.41 $8.71 $8.71 30.39% <-Total Growth 10 Cash Flow per Share
Increase 39.86% 24.91% -13.64% 9.48% 4.01% -2.29% 23.42% 3.52% -30.28% -25.49% 133.21% 13.36% -33.21% 40.87% 3.58% 0.00% 10.33% <-IRR #YR-> 10 Cash Flow 167.28%
5 year Running Average $3.37 $3.89 $4.08 $4.44 $4.87 $5.04 $5.24 $5.62 $5.53 $5.16 $5.72 $6.25 $6.14 $6.92 $7.99 $8.15 1.94% <-IRR #YR-> 5 Cash Flow 10.08%
P/CF on Med Price 7.78 6.60 9.40 9.14 8.08 8.40 8.06 7.92 12.48 18.10 6.55 5.37 10.11 8.30 0.00 0.00 2.69% <-IRR #YR-> 10 Cash Flow per Share 30.39%
P/CF on Closing Price 7.20 7.29 9.44 9.05 9.01 8.58 8.87 8.31 13.93 15.30 6.38 6.01 11.33 8.49 8.19 8.19 -1.71% <-IRR #YR-> 5 Cash Flow per Share -8.28%
3.03% Diff M/C 4.17% <-IRR #YR-> 10 CFPS 5 yr Running 50.47%
Excl.Working Capital CF $13.6 -$35.2 $101.6 -$134.0 $104.0 $116.0 $73.0 -$217.0 $152.0 $234.0 $95.0 -$452.0 $757.0 $0.0 $0.0 $0.0 1.78% <-IRR #YR-> 5 CFPS 5 yr Running 9.23%
CF fr Op $M WC $577.8 $727.3 $775.8 $919.0 $1,297.0 $1,309.0 $1,598.0 $1,420.0 $1,337.0 $1,147.0 $2,336.0 $2,194.0 $2,559.0 $2,538.4 $2,629.2 $9.3 229.85% <-Total Growth 10 Cash Flow less WC
Increase 40.52% 25.87% 6.67% 18.46% 41.13% 0.93% 22.08% -11.14% -5.85% -14.21% 103.66% -6.08% 16.64% -0.80% 3.58% -99.65% 12.68% <-IRR #YR-> 10 Cash Flow less WC 229.85%
5 year Running Average $419.2 $498.4 $586.4 $682.2 $859.4 $1,005.6 $1,179.8 $1,308.6 $1,392.2 $1,362.2 $1,567.6 $1,686.8 $1,914.6 $2,154.9 $2,451.3 $1,986.0 12.50% <-IRR #YR-> 5 Cash Flow less WC 80.21%
CFPS Excl. WC $4.35 $5.06 $5.27 $4.38 $5.67 $5.59 $6.59 $5.65 $5.12 $4.25 $8.22 $7.41 $8.48 $8.41 $8.71 $0.03 12.56% <-IRR #YR-> 10 CF less WC 5 Yr Run 226.51%
Increase 38.50% 16.34% 4.18% -16.97% 29.56% -1.38% 17.87% -14.30% -9.32% -17.03% 93.50% -9.83% 14.39% -0.80% 3.58% -99.65% 7.91% <-IRR #YR-> 5 CF less WC 5 Yr Run 46.31%
5 year Running Average $3.39 $3.81 $4.28 $4.44 $4.94 $5.19 $5.50 $5.57 $5.72 $5.44 $5.97 $6.13 $6.70 $7.36 $8.25 $6.61 4.87% <-IRR #YR-> 10 CFPS - Less WC 60.91%
P/CF on Med Price 7.59 6.92 8.17 10.47 7.43 7.66 7.69 9.13 11.06 14.41 6.28 6.48 7.12 8.30 0.00 0.00 8.47% <-IRR #YR-> 5 CFPS - Less WC 50.15%
P/CF on Closing Price 7.03 7.64 8.20 10.37 8.29 7.82 8.47 9.58 12.34 12.18 6.12 7.25 7.98 8.49 8.19 2313.01 4.58% <-IRR #YR-> 10 CFPS 5 yr Running 56.50%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 8.24 5 yr  10.11 P/CF Med 10 yr 7.67 5 yr  7.12 10.61% Diff M/C 3.74% <-IRR #YR-> 5 CFPS 5 yr Running 20.13%
-147.21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 301.76 Shares
-251.43 0.00 0.00 0.00 0.00 301.76 Shares
-$674.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,802.0 Cash Flow
-$1,637.0 $0.0 $0.0 $0.0 $0.0 $1,802.0 Cash Flow
-$4.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.97 Cash Flow per Share
-$6.51 $0.00 $0.00 $0.00 $0.00 $5.97 Cash Flow per Share
-$4.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.14 CFPS 5 yr Running
-$5.62 $0.00 $0.00 $0.00 $0.00 $6.14 CFPS 5 yr Running
-$775.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,559.0 Cash Flow less WC
-$1,420.0 $0.0 $0.0 $0.0 $0.0 $2,559.0 Cash Flow less WC
-$586.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,914.6 CF less WC 5 Yr Run
-$1,308.6 $0.0 $0.0 $0.0 $0.0 $1,914.6 CF less WC 5 Yr Run
-$5.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.48 CFPS - Less WC
-$5.65 $0.00 $0.00 $0.00 $0.00 $8.48 CFPS - Less WC
-$4.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.70 CFPS 5 yr Running
-$5.57 $0.00 $0.00 $0.00 $0.00 $6.70 CFPS 5 yr Running
Changes in WC
Receivables, net -$109.3 $43.2 -$19.0 -$104.0 -$176.0 -$144.0 $154 $187 -$364 -$636 $653 -$154 -$703
Income taxes receivable $26.1 -$2.9 -$21.6 -$23.0 $8.0
Inventory -$26.9 -$41.8 -$2.1 $88.0 $31.0 -$44.0 -$19 $6 -$84 -$214 -$31 $38 -$63
Prepaid expenses -$6.7 $0.9 $8.4 -$18.0 $14.0
Due from related party -$3.5 $1.9
Other current assets -$4.1 -$0.8 -$1.6 $13.0
Accounts payable $68.9 -$0.1 -$44.9 $162.0 $3.0 $59.0 -$137 $55 $289 $423 -$538 $536 -$40
Income taxes payable $29.4 $0.1 -$31.7 $14.0 -$17.0
Other current liabilities $9.0 $40.1 $9.0 $15.0 $33.0 -$71 -$31 $7 $193 -$179 $32 $49
Othere opteration Activities
                         
Sum -$13.6 $35.2 -$101.6 $134.0 -$104.0 -$116.0 -$73 $217 -$152 -$234 -$95 $452 -$757
Google --> TD $180.0 -$72.0 -$72 -$38 $217 -$152 -$234 -$95 $452 -$757
Difference -$46.0 -$32.0 -$44 -$35 $0 $0 $0 $0 $0 $0
TD $3 -$120 $134 -$104 -$116 -$73
Difference $32 $18 $0 $0 $0 $0
Now now counting Other Oper Act 2021 2021 2021 2021
OPM 25.30% 25.66% 24.17% 24.62% 19.16% 18.29% 24.95% 29.73% 20.56% 12.03% 29.63% 36.75% 20.53% 30.15% -15.05% <-Total Growth 10 OPM
Increase 30.98% 1.42% -5.79% 1.86% -22.17% -4.57% 36.47% 19.14% -30.86% -41.46% 146.27% 24.03% -44.13% 46.84% Should increase  or be stable.
Diff from Median 12.0% 13.6% 7.0% 9.0% -15.2% -19.0% 10.5% 31.6% -9.0% -46.7% 31.2% 62.7% -9.1% 33.5% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 22.59% 5 Yrs 20.56% should be  zero, it is a   check on calculations
EBITDA $3,147 $2,544 $3,497 EBITDA Statement
Change -19.16% 37.46% Change
Margin 41.61% 35.33% 39.85% Margin
$3,650 <-12 mths 3.81%
Adjusted EBITDA $829.5 $946.5 $1,031 $1,744 $2,295 $2,387 $2,339 $2,343 $2,367 $2,687 $2,910 $3,048 $3,516 $3,653 $3,810 $4,168 241.03% <-Total Growth 10 Adjusted EBITDA Statement
Change 19.66% 14.10% 8.93% 69.16% 31.59% 4.01% -2.01% 0.17% 1.02% 13.52% 8.30% 4.74% 15.35% 3.90% 4.30% 6.52% <-Median-> 10 Change
Margin 37.19% 31.85% 36.96% 40.78% 36.86% 36.59% 38.28% 42.55% 41.06% 35.41% 38.48% 42.33% 40.06% 43.39% 42.44% 39.27% <-Median-> 10 Margin
$2,280 <-12 mths 2.60%
EBIT $930 $1,629 $1,794 $1,886 $2,222 $2,097 $2,256 $2,364
Change 75.16% 10.13% 5.13% 17.82% -5.63% 7.58% 4.79%
Margin 16.13% 21.47% 23.72% 26.19% 25.32% 24.91% 25.13% 23.85%
Long Term Debt $3,692 $3,755 $4,009 $14,744 $13,140 $14,292 $13,679 $12,339 $14,196 $15,744 $17,807 $18,173 $18,453 $18,453 360.29% <-Total Growth 10 Debt Type
Change 1.48% 1.70% 6.77% 267.77% -10.88% 8.77% -4.29% -9.80% 15.05% 10.90% 13.10% 2.06% 1.54% 0.00% 113.49% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.91 0.68 0.63 1.55 1.22 1.40 1.01 0.91 0.86 1.13 1.25 1.14 0.90 0.86 1.13 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 5.80 8.59 5.77 7.85 7.29 7.05 7.64 6.41 7.02 5.45 8.69 8.40 6.76 6.76 17.17% <-Total Growth 10 Assets/Current Liabilities Ratio Liquidity
Current Liabilities/Asset Ratio 0.17 0.12 0.17 0.13 0.14 0.14 0.13 0.16 0.14 0.18 0.12 0.12 0.15 0.15 -14.66% <-Total Growth 10 Current Liabilities/Asset Ratio Liq. + CF
Debt to Cash Flow (Years) 6.54 4.92 5.95 14.00 11.01 11.98 8.97 7.54 11.98 17.24 7.95 6.87 10.24 7.27 72.21% <-Total Growth 10 Debt to Cash Flow (Years) Liq. + CF + D
Debt Ratio
Intangibles $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 #DIV/0! <-Total Growth 10 Intangibles Leverage
Goodwill $324.90 $355.80 $456.00 $6,213 $5,805 $6,313 $5,835 $5,720 $5,696 $6,012 $5,871 $5,858 $5,580 $5,580 1123.68% <-Total Growth 10 Goodwill D/E Ratio
Total $324.90 $355.80 $456.00 $6,213 $5,805 $6,313 $5,835 $5,720 $5,696 $6,012 $5,871 $5,858 $5,580 $5,580 1123.68% <-Total Growth 10 Total
Change 67.91% 9.51% 28.16% 1262.50% -6.57% 8.75% -7.57% -1.97% -0.42% 5.55% -2.35% -0.22% -4.75% 0.00% -1.20% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.08 0.06 0.07 0.65 0.54 0.62 0.43 0.42 0.35 0.43 0.41 0.37 0.27 0.26 0.43 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $1,161.30 $1,458.60 $2,595.6 $2,511 $2,526 $2,832 $2,486 $2,178 $3,136 $4,896 $3,708 $3,688 $4,389 $4,389 Liquidity ratio of 1.5 and up, best
Current Liabilities $1,529.90 $1,146.60 $2,081.3 $3,724 $3,946 $4,583 $4,166 $4,875 $4,878 $7,287 $4,544 $5,115 $6,627 $6,627 0.65 <-Median-> 10 Ratio
Liquidity Ratio 0.76 1.27 1.25 0.67 0.64 0.62 0.60 0.45 0.64 0.67 0.82 0.72 0.66 0.66 0.67 <-Median-> 5 Ratio
Liq. with CF aft div 1.01 1.75 1.45 0.84 0.82 0.76 0.82 0.65 0.75 0.70 1.13 1.07 0.80 0.91 0.80 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.63 1.08 1.37 0.25 0.57 0.52 0.59 0.52 0.51 0.52 0.69 0.75 0.53 0.91 0.53 <-Median-> 5 Ratio
Curr Long Term Debt $328.30 $94.50 $274.0 $476 $476 $1,119 $501 $1,382 $462 $2,726 $1,062 $234 $1,201 $501
Liquidity Less CLTD 0.97 1.39 1.44 0.77 0.73 0.82 0.68 0.62 0.71 1.07 1.06 0.76 0.81 0.72 0.81 <-Median-> 5 Ratio
Liq. with CF aft div 1.28 1.91 1.67 0.97 0.93 1.01 0.94 0.91 0.83 1.12 1.48 1.12 0.98 0.99 1.12 <-Median-> 5 Ratio
Assets $8,876.8 $9,844.4 $12,012.3 $29,221 $28,771 $32,314 $31,842 $31,234 $34,244 $39,742 $39,480 $42,951 $44,817 $44,817 $44,817 $44,817 Debt Ratio of 1.5 and up, best
Liabilities $5,979.6 $6,139.0 $7,678.2 $22,405 $21,590 $23,986 $23,241 $21,996 $24,094 $28,301 $27,392 $29,660 $31,421 $31,421 $31,421 $31,421 1.41 <-Median-> 10 Ratio
Debt Ratio 1.48 1.60 1.56 1.30 1.33 1.35 1.37 1.42 1.42 1.40 1.44 1.45 1.43 1.43 1.43 1.43 1.43 <-Median-> 5 Ratio
Estimates BVPS $40.01 $41.31 $41.55 Estimates Estimates BVPS
Estimate Book Value $12,073.4 $12,465.7 $12,538.1 Estimates Estimate Book Value
P/B Ratio (Close) 1.78 1.73 1.72 Estimates P/B Ratio (Close)
Difference from 10 year median 28.84% Diff M/C Estimates Difference from 10 yr med.
Total Equity $2,897 $3,705 $4,334 $6,816 $7,181 $8,328 $8,601 $9,238 $10,150 $11,441 $12,088 $13,291 $13,396 $13,396 209.08% <-Total Growth 10 Total Equity
NCI $289 $307 $134 $112 $92 $41 $41 $34 $34 $14 $14 $14 $14 $14 -89.55% <-Total Growth 10 Non-Control Int
Emera' Equity $2,608 $3,399 $4,200 $6,704 $7,089 $8,287 $8,560 $9,204 $10,116 $11,427 $12,074 $13,277 $13,382 $13,382 218.61% <-Total Growth 10 Book Value
Book Value per Share $19.63 $23.64 $28.53 $31.92 $30.99 $35.40 $35.30 $36.61 $38.75 $42.33 $42.50 $44.86 $44.35 55.43% <-Total Growth 10 Book Value per Share
P/B Ratio (Median) 1.68 1.48 1.51 1.44 1.36 1.21 1.44 1.41 1.46 1.45 1.22 1.07 1.36 1.39 <-Median-> 10 P/B Ratio (Median)
P/BV 10 yr Med 1.39 5 yr Med 1.36
Preferred Shares $514 $710 $710 $709 $709 $1,004 $1,004 $1,004 $1,422 $1,422 $1,422 $1,422 $1,422 $1,422 100.42% <-Total Growth 10 Preferred Shares
Book Value $2,094 $2,689 $3,491 $5,995 $6,380 $7,283 $7,556 $8,200 $8,694 $10,005 $10,652 $11,855 $11,960 $11,960 $11,960 $11,960 242.63% <-Total Growth 10 Book Value
Book Value per Share $15.76 $18.70 $23.71 $28.54 $27.89 $31.11 $31.16 $32.61 $33.30 $37.06 $37.49 $40.06 $39.63 $39.63 $39.63 $39.63 67.15% <-Total Growth 10 Book Value per Share
Change 24.43% 18.69% 26.77% 20.38% -2.30% 11.55% 0.17% 4.66% 2.11% 11.29% 1.16% 6.85% -1.06% 0.00% 0.00% 0.00% 18.46% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.10 1.87 1.81 1.61 1.51 1.38 1.63 1.58 1.70 1.65 1.38 1.20 1.52 1.76 0.00 0.00 1.52 P/B Ratio Historical Median
P/B Ratio (Close) 1.94 2.07 1.82 1.59 1.68 1.41 1.79 1.66 1.90 1.40 1.34 1.34 1.71 1.80 1.80 1.80 5.27% <-IRR #YR-> 10 Book Value per Share 67.15%
Change -29.28% 6.49% -11.75% -12.78% 5.94% -16.59% 27.42% -7.35% 14.44% -26.45% -3.91% -0.03% 27.24% 5.56% 0.00% 0.00% 3.98% <-IRR #YR-> 5 Book Value per Share 21.53%
Leverage (A/BK) 4.24 3.66 3.44 4.87 4.51 4.44 4.21 3.81 3.94 3.97 3.71 3.62 3.75 3.75 3.96 <-Median-> 10 A/BV
Debt/Equity Ratio 2.86 2.28 2.20 3.74 3.38 3.29 3.08 2.68 2.77 2.83 2.57 2.50 2.63 2.63 2.80 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.55 5 yr Med 1.52 16.06% Diff M/C 3.51 Historical 31 A/BV
-$23.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $39.63
-$32.61 $0.00 $0.00 $0.00 $0.00 $39.63
Comprehensive Income $609.40 $542.8 $964.5 $236 -$6 $1,253 $465 $810 $665 $1,562 $772 $1,524 $702 -27.22% <-Total Growth 10 Comprehensive Income
NCI $26.80 $31.6 $52.8 $8 $0 $4 $1 $1 $1 $1 $1 $1 $1 NCI
Preferred $19.80 $26.2 $30.3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Preferred
Shareholders $562.80 $485.0 $881.4 $228 -$6 $1,249 $464 $809 $664 $1,561 $771 $1,523 $701 -20.47% <-Total Growth 10 Comprehensive Income
Increase 376.14% -13.82% 81.73% -74.13% -102.63% 20916.67% -62.85% 74.35% -17.92% 135.09% -50.61% 97.54% -53.97% -17.92% <-Median-> 5 Comprehensive Income
5 Yr Running Average $217.18 $302.54 $436.20 $455.08 $430.24 $567.48 $563.28 $548.80 $636.00 $949.40 $853.80 $1,065.60 $1,044.00 -2.26% <-IRR #YR-> 10 Comprehensive Income -20.47%
ROE 26.9% 18.0% 25.3% 3.8% -0.1% 17.1% 6.1% 9.9% 7.6% 15.6% 7.2% 12.8% 5.9% -2.83% <-IRR #YR-> 5 Comprehensive Income -13.35%
5Yr Median 9.20% 13.10% 18.03% 18.03% 18.03% 17.15% 6.14% 6.14% 7.64% 9.87% 7.64% 9.87% 7.64% 9.12% <-IRR #YR-> 10 5 Yr Running Average 139.34%
% Difference from NI 158.8% 19.3% 121.9% 0.4% -102.3% 75.9% -30.0% -13.8% 30.2% 65.2% -21.2% 208.3% -30.9% 13.73% <-IRR #YR-> 5 5 Yr Running Average 90.23%
Median Values Diff 5, 10 yr -6.7% 30.2% 7.6% <-Median-> 5 Return on Equity
-$881 $0 $0 $0 $0 $0 $0 $0 $0 $0 $701
-$809 $0 $0 $0 $0 $701
-$436 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,044
-$549 $0 $0 $0 $0 $1,044
Current Liability Coverage Ratio 0.38 0.63 0.37 0.25 0.33 0.29 0.38 0.29 0.27 0.16 0.51 0.43 0.39 0.38   CFO / Current Liabilities
5 year Median 0.41 0.49 0.41 0.38 0.37 0.33 0.33 0.29 0.29 0.29 0.29 0.29 0.39 0.39 31.0% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 6.51% 7.39% 6.46% 3.14% 4.51% 4.05% 5.02% 4.55% 3.90% 2.89% 5.92% 5.11% 5.71% 5.66% CFO / Total Assets
5 year Median 6.26% 6.35% 6.46% 6.46% 6.46% 4.51% 4.51% 4.51% 4.51% 4.05% 4.55% 4.55% 5.11% 5.66% 4.5% <-Median-> 10 Return on Assets 
Return on Assets ROA 2.45% 4.13% 3.31% 0.78% 0.92% 2.20% 2.08% 3.00% 1.49% 2.38% 2.48% 1.15% 2.26% 2.37% Net  Income/Assets Return on Assets
5Yr Median 3.02% 3.02% 3.31% 2.93% 2.45% 2.20% 2.08% 2.08% 2.08% 2.20% 2.38% 2.38% 2.26% 2.37% 2.1% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 10.39% 15.12% 11.38% 3.79% 4.17% 9.75% 8.77% 11.44% 5.87% 9.45% 9.18% 4.17% 8.48% 8.90% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 11.75% 13.31% 13.31% 11.38% 10.39% 9.75% 8.77% 8.77% 8.77% 9.45% 9.18% 9.18% 8.48% 8.90% 8.6% <-Median-> 10 Return on Equity
$1,023.05 <-12 mths 0.89%
Net Income $255.30 $452.8 $452.4 $266 $299 $747 $710 $984 $561 $1,009 $1,045 $568 $1,090
NCI $18.50 $19.9 $24.9 $11 $5 $1 $2 $1 $1 $1 $1 $1 $1
Preferred $19.30 $26.2 $30.3 $28 $28 $36 $45 $45 $50 $63 $66 $73 $75
Shareholders $217.50 $406.7 $397.2 $227 $266 $710 $663 $938 $510 $945 $978 $494 $1,014 $1,064 $1,117 $1,239 155.29% <-Total Growth 10 Net Income
Increase -1.49% 86.99% -2.34% -42.85% 17.18% 166.92% -6.62% 41.48% -45.63% 85.29% 3.49% -49.49% 105.26% 4.93% 4.98% 10.92% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $209.2 $255.4 $296.7 $293.8 $302.9 $401.4 $452.6 $560.8 $617.4 $753.2 $806.8 $773.0 $788.2 $899.0 $933.4 $985.6 9.83% <-IRR #YR-> 10 Net Income 155.29%
Operating Cash Flow $564.20 $762.50 $674.20 $1,053 $1,193 $1,193 $1,525 $1,637 $1,185 $913 $2,241 $2,646 $1,802 1.57% <-IRR #YR-> 5 Net Income 8.10%
Investment Cash Flow -$921.60 -$710.90 -$123.70 -$9,105 -$1,761 -$2,190 -$1,617 -$1,224 -$2,332 -$2,569 -$2,917 -$2,218 -$3,482 10.27% <-IRR #YR-> 10 5 Yr Running Ave. 165.69%
Total Accruals $574.90 $355.10 -$153.30 $8,279 $834 $1,707 $755 $525 $1,657 $2,601 $1,654 $66 $2,694 7.04% <-IRR #YR-> 5 5 Yr Running Ave. 40.55%
Total Assets $8,876.8 $9,844.4 $12,012.3 $29,221 $28,771 $32,314 $31,842 $31,234 $34,244 $39,742 $39,480 $42,951 $44,817 Balance Sheet Assets
Accruals Ratio 6.48% 3.61% -1.28% 28.33% 2.90% 5.28% 2.37% 1.68% 4.84% 6.54% 4.19% 0.15% 6.01% 4.84% <-Median-> 5 Ratio
EPS/CF Ratio 0.38 0.56 0.51 0.30 0.22 0.54 0.42 0.67 0.39 0.84 0.43 0.23 0.40 0.41 <-Median-> 10 EPS/CF Ratio
-$397 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,014
-$938 $0 $0 $0 $0 $1,014
-$297 $0 $0 $0 $0 $0 $0 $0 $0 $0 $788
-$561 $0 $0 $0 $0 $788
Change in Close -12.00% 26.40% 11.88% 5.00% 3.50% -6.96% 27.64% -3.03% 16.86% -18.14% -2.80% 6.82% 25.89% 5.56% 0.00% 0.00% Count 31 Years of data
up/down down down down down down down Count 10 32.26%
Meet Prediction? yes yes % right Count 3 30.00%
Financial Cash Flow $362.1 $58.2 $221.1 $7,448 -$13 $344 $14 -$372 $1,311 $1,555 $939 -$818 $1,841 C F Statement  Financial CF
Total Accruals $212.80 $296.90 -$374.40 $831 $847 $1,363 $741 $897 $346 $1,046 $715 $884 $853 Accruals
Accruals Ratio 2.40% 3.02% -3.12% 2.84% 2.94% 4.22% 2.33% 2.87% 1.01% 2.63% 1.81% 2.06% 1.90% 1.90% <-Median-> 5 Ratio
Cash $100.80 $221.10 $1,073.40 $404 $503 $372 $274 $254 $417 $332 $588 $221 $371 $371 Cash
Cash per Share $0.76 $1.54 $7.29 $1.92 $2.20 $1.59 $1.13 $1.01 $1.60 $1.23 $2.07 $0.75 $1.23 $1.23 $1.23 <-Median-> 5 Cash per Share
Percentage of Stock Price 2.48% 3.98% 16.87% 4.24% 4.68% 3.64% 2.03% 1.87% 2.53% 2.38% 4.11% 1.39% 1.82% 1.72% 2.38% <-Median-> 5 % of Stock Price
Notes:
March 21, 2025.  Last estimates were for 2025, 2026, 2027 of $8225M, $8375M, $8869M Revenue, 4.79 2025 AFFO, $3.25, $3.36, $3.53 AEPS, $3.28, $3.36, $3.62 EPS,
 -$708M, -$1190M FCF, $7.76, $8.44 and $8.42 CFPS, $3481M, $3624M, $3783M EBITDA, $41.08, $39.57, $43.31 BVPS, $965M, $1018M, $1094M Net Income.
February 28, 2025.  Last estimates were for 2024, 2025, 2026 of $7774M, $8154M, $8698M for Revenue, $5.78, $4.80 2024/5 AFFO, $3.21, $3.41, $3.61 AEPS, $3.23, $3.40 and $3.70 EPS, 
$2.88, $2.99 and $3.10 dividends, -$304.6M, -$405M, $467M FCF MS, $1671M, $1454M 2024/5 FCF TD, $8.19, $8.17, $8.41 CFPS, $3273M, $3430M, $3626M EBITDA, $38.20, $39.10, $40.80 BVPS, $920M, $1005M, $1106M Net Income.
March 2, 2024.  Last estimates were for 2023, 2024 and 2025 of $7092M, $7394M and $7690M for Revenue, $4.86, $5.35 2023/4 for AFFO, $3.21, $3.34 and $3.57 for AEPS, $$3.19, 
$3.36 and $3.58 for EPS, $2.78, $2.89 and $3.01 for Dividends, -$457 and 35.3 2023/4 for FCF, $7.78, $8.38 and $8.20 for CFPS, $38.90, $37.40 and $41.10 for BVPS, $872M, $940M and $1006M for Net Income.
February 26, 2023.  Last estimates were for 2022, 2023 and 2024 of $6843M, $6718M and $6711M for Revenue, $4.28 and 4.64 for AFFO 2022/23, $3.09 and $3.22 for AEPS 2022/23, 
$3.05, $3.26 and $3.52 for EPS, $2.67, $2.78 and $2.89 for Dividends, -$865M,-$521M and -$516M for FCF, $7.32, $7.50 and $8.00 for CFPS, $34.40, $56.60 and $36.80 for BVPS, $807M, $878M and $960M for Net Income.
March 6, 2022.  Last estimates were for 2021, 2022 and 2023 of $6247M, $6281M and $5996M for Revenue, $3.69 and $4.07 for AFFO for 2021-22, $2.85, $3.11 and $3.40 for EPS, 
$2.58, $2.68 and $2.78 for Dividends, $895M, $474M and $645M for FCF, $6.97 and $7.41 for CFPS for 2021-22 and $729M, $812M and $855M for Net Income.
February 28, 2021.  Last estimates were for 2020, 2021 and 2022 of $6307M, $6379M and $6721M for Revenue, $3.60 and $3.94 for AFFO for 2020 and 2021, 
$2.81, $3.01 and $3.22 for EPS, $2.48, $2.58 and $2.69 for Dividends, $828M, $614M and $667M for FCF and $685M, $750M and $846M for Net Income.
February 22, 2020.  Last estimates were for 2019, 2020 and 2021 of $6710M, $6824M and $7216M for Revenue, 
$3.87 and $3.68 for AFFO for 2019 and 2020, $2.85, $2.93 and $2.97 for EPS and $674M, $729M and $801M for Net Income.
February 16, 2019.  Last estimates were for 2018, 2019 and 2020  of $7254M, $7.89M and $7360M for Revenue, $3.02 and $.46 for AFFO for 2018 and 2019, 
$6.89, $7.15 and $6.67 for CFPS and $626M, $673M and $7.25M for Net Income.
February 16, 2018.  Last estimates were for 2017, 2018 smnf 2019 og $7047M, $7342M and $7657M for Revenue, $2.98, $3.85 FFO for 2017 and 2018, 
$2.77, $3.04 and $3.05 for EPS, $6.12, $6.64 and $7.45 for CFPS and $531M, $599M and $659M for Net Income.
February 14, 2017.  Last estimates were for 2016, 2017 and 2018 of $5411M, $7103M and $5275M for revenue, $2.62 and $3.23 for AFFO for 2016 and 2017, $2.42, $2.80 and $3.10 for EPS, 
$5.89 and $8.08 for CFPS for 2016 and 2017 and $393M and $561M for Net Income for 2016 and 2017.
February 12, 2016.  Last estimaes were for 2015 and 2016 of $2960M and $3123M for Revenue, $2.27 and $2.29 for AFFO, $2.11, $2.20 and $2.40 for EPS fore 2015, 2016 and 2017, $4.18 and $4.35 for CFPS.
Sept 2015.  Emera issues Debentures EMA.IR to pay for the purchase of TECO Energy Inc.  A Florida and New Mexico regulated electric and gas utility holding company.
http://www.marketwired.com/press-release/emera-inc-announces-19-billion-bought-deal-offering-convertible-debentures-represented-tsx-ema-2053243.htm
February 11, 2015. Last estimates were for 2014 and 2015 of $2449M and $2581.7M for Revenue, $2.00 and $1.16 for AFFO, $1.86 and $1.99 for EPS, 
$4.08 and $4.29 for CFPS, $261M and $282M for Net Income.
February 12, 2014.  Last estimates were for 2013 and 2014 of $2078M and $2218M for Revenue, $1.97 and $1.96 for AFFO, $1.77 and $1.90 for EPS and $3.65 (2013) for CFPS.
March 2013.  Good Utility.  Debt Ratios a bit off.
Feb 24, 2013.  Last estimates were fore 2012 and 2013 and were $2538M and $2722M for revenue, $1.67 and $1.80 for EPS and $3.55 and $3.65 for CFPS.
Mar 17, 2012.  Last I looked I got estimates for 2011 and 2012 of $4600 and $1634 for revenue, $1.79 and $1.88 for EPS and $3.11 and $3.38 for CF.
LOOK AT COMMENTS ON EMERA DATED DECEMBER 31, 2011.  TALK ABOUT.  COST OF WIND MILL PRODUCED ELELECTRICY WHICH NS POWER HAS TO PRODUCE.
June 6, 2011.  when I last looked I got 2010 and 2011 earnings of $1.55 amd $1.58 and Cash Flow of $3.13 and $3.17
Mar 9, 2010.  In Aug 2009, I picked up for 2009 and 2010 earnings of $1.43 and $1.45 and cash flow of $3.05 and $3.08.
What you look for in a utilities stock is that you get a total return of about 8% per year, 4% in dividends and 4% in Capital Gains.  My return since Jul 2005 is 10.5%.  Very good.
Aug 17,2009.  In April 2009, I picked up earnings for 2009 and 2010 of $1.39 and $1.45.  Earnings for 2009 has increased slightly to $1.43
April 30, 2009 AR 2008.  In Sep 2008, I picked up an earnings estiamte of $1.35, but it came in at $1.29, Diluted $1.26.  This company is expected to do well over the next couple of years.
The Book Value is not increasing by much, but then this company pays a high dividend.  When taken into consideration the dividend, the full return on this stock is fine.  
None of the values are increasing by much.  I good return on this sort of stock is 8%, including dividends.
AP 2007.  It seems solid, but slow. Recommend keeping  for now, but not buying more.  Dividends have finally started to increase, But revenue is not growing over last 5 yrs.
AR 2006.  Revenus and EPS growth suck.  However, dividend yield is high as is ROE and OPM. For last 5 years, Price plus dividend growth is IRR of 10% which is good.
In April 2007, re Mike, yield is below historical high and average, which means the price is high, therefore price will probably come down.
AR 2005.  I have lost so far 25% on this stock, but only invested some 4,000, so not too bad.  I guess I invested at wrong time in Jan.  Apparently I bought it at the top. TD recommends as a hold since May 2005???
AR 2005  I am also annoyed at this stock as the annual report was hard to find and they seem to have restate values, especially revenues without saying so.
AR 2004.  The dividend is good, and it increases slightly each year.  However, I do not know if that is a good enough reason to buy this sock.  
Half the money made on this stock is from dividends.  Low risk stock.  10 to 11 IRR not bad. AR 2004
Emera was created out of the privatization of the provincial Crown corporation Nova Scotia Power Incorporated (NSPI).
Common shares in NS Power Holdings Inc. began trading on the Toronto Stock Exchange and Montreal Stock Exchange on January 6, 1999. 
The NS Power Holdings Inc. name was changed to Emera Incorporated on July 17, 2000.
Sector:
Power, Utilities (Regulated)
What should this stock accomplish?
You would expect that the stock onver the long term will provide for a good dividend and moderate increases.
Would I buy this company and Why.
Yes I do like this utility.  
Why am I following this stock. 
I found this company in Mike Higg’s site. Mike’s site has a spreadsheet showing Dividend Paying Canadian Growth stocks.  
Why I bought this stock.
I first bought this stock in 2005, as I wanted to buy something for my Locked in RRSP.  I think that this was an appropriate stock and has good value. I was using up excess cash in my account.
I also made additional purchases in 2005, 2011, 2022 and 2023.
Dividends
Dividend are paid quarterly in cycle 2, that is February, May, August and November.  They are paid near the middle of the month.  Dividend are paid to shareholders of record of the first of the month or last of previous month for the current month.
For example, the dividend payable on August 15, 2013 was for shareholders of record for July 31, 2013.  However, the dividend payabale on May 15, 2013 was for shareholders of record of May 1, 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.
Emera says they are working to create cleaner energy and deliver it to market. Our success comes from integrating our diverse investments to get solid results for shareholders, partners and customers. 
They also say they maintain high standards in safety, reliability, customer service and environmental care.
How they make their money
Emera is a geographically diverse energy and services company investing in electricity generation, transmission, and 
distribution as well as gas transmission and utility energy services. Emera has operations throughout North America and the Caribbean countries.
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 2018 Feb 16 2019 Feb 22 2020 Feb 28 2021 Mar 6 2022 Feb 26 2023 Mar 2 2024 Feb 28 2025 Mar 21 2026
Balfour, Scott Carlyle 0.02% 0.045 0.02% 0.051 0.02% 0.058 0.02% 0.060 0.02% 0.069 0.02% 0.107 0.04% 0.108 0.04% 0.115 0.04% 6.82%
COO - Shares - Amount $1.976 $2.523 $2.743 $3.672 $3.125 $3.480 $5.756 $7.307 $8.239
Options - percentage 0.18% 0.624 0.26% 0.813 0.32% 1.385 0.53% 1.540 0.57% 1.540 0.54% 1.729 0.58% 2.479 0.82% 2.673 0.89% Used to be CFO, now COO 7.85%
Options - amount $17.928 $34.815 $44.005 $87.560 $79.688 $77.455 $92.875 $167.665 $190.882 CEO from Mar 2018
Huskilson, Christopher 0.04%
CEO - Shares - Amount $4.046
Options - percentage 0.94%
Options - amount $95.948
Green, Jared 0.006 0.00% from 2026 #DIV/0!
CFO - Shares - Amount $0.463
Options - percentage 0.058 0.02% #DIV/0!
Options - amount $4.116
Blunden, Gregory 0.00% 0.001 0.00% 0.001 0.00% 0.001 0.00% 0.001 0.00% 0.002 0.00% 0.002 0.00% 0.003 0.00% 0.003 0.00% 15.21%
CFO - Shares - Amount $0.019 $0.038 $0.051 $0.072 $0.074 $0.091 $0.123 $0.195 $0.237
Options - percentage 0.05% 0.183 0.08% 0.228 0.09% 0.260 0.10% 0.311 0.12% 0.311 0.11% 0.368 0.12% 0.565 0.19% 0.565 0.19% 0.00%
Options - amount $5.306 $10.227 $12.358 $16.453 $16.084 $15.633 $19.758 $38.191 $40.314
Gregg, Peter Holden 0.002 0.00% 0.006 0.00% 0.007 0.00% 0.007 0.00% 0.007 0.00% 0.007 0.00% 0.82%
Officer - Shares - Amount $0.126 $0.311 $0.336 $0.377 $0.502 $0.534
Options - percentage 0.228 0.09% 0.054 0.02% 0.058 0.02% 0.098 0.03% 0.215 0.07% 0.256 0.08% 19.19%
Options - amount $14.416 $2.779 $2.931 $5.266 $14.547 $18.303
Karen Hutt 0.002 0.00% 0.002 0.00% 0.002 0.00% 11.60%
Officer - Shares - Amount $0.106 $0.149 $0.175
Options - percentage 0.227 0.08% 0.363 0.12% 0.390 0.13% 7.65%
Options - amount $12.173 $24.525 $27.870
Bennett, Robert Ross 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% Updated Mar 2024 -100.00%
Officer - Shares - Amount $0.113 $0.145 $0.140 $0.164 $0.137 $0.137 $0.150 $0.195
Options - percentage 0.08% 0.232 0.10% 0.191 0.08% 0.180 0.07% 0.180 0.07% 0.180 0.06% 0.086 0.03% 0.086 0.03% -100.00%
Options - amount $8.137 $12.953 $10.331 $11.396 $9.328 $9.067 $4.630 $5.829
Collins, Archie 0.012 0.00% 0.013 0.00% 9.29%
Officer - Shares - Amount $0.807 $0.931
Options - percentage 0.259 0.09% 0.288 0.10% 11.18%
Options - amount $17.519 $20.559
Bertram, James Vance 0.000 0.00% 0.006 0.00% 0.014 0.00% 0.014 0.00% 0.014 0.00% 0.014 0.00% 0.00%
Director - Shares - Amount $0.000 $0.335 $0.713 $0.761 $0.958 $1.012
Options - percentage 0.013 0.00% 0.019 0.01% 0.024 0.01% 0.031 0.01% 0.040 0.01% 0.048 0.02% 19.38%
Options - amount $0.809 $0.969 $1.224 $1.691 $2.696 $3.397
Demone, Henry 0.009 0.00% 0.009 0.00% 0.011 0.00% 0.012 0.00% 11.71%
Director - Shares - Amount $0.456 $0.487 $0.735 $0.867
Options - percentage 0.038 0.01% 0.043 0.01% 0.049 0.02% 0.054 0.02% 10.94%
Options - amount $1.908 $2.318 $3.311 $3.878
Sheriff, Karen 0.003 0.00% 0.003 0.00% Chair Feb 2025 0.00%
Chairman - Shares - Amt $0.203 $0.214
Options - percentage 0.023 0.01% 0.033 0.01% 44.49%
Options - amount $1.534 $2.340
Sheppard, Mary Jacqueline 0.01% 0.012 0.00% 0.012 0.00% 0.012 0.00% 0.012 0.00% 0.012 0.00% 0.012 0.00% 0.012 0.00% -100.00%
Chairman - Shares - Amt $0.522 $0.667 $0.646 $0.755 $0.618 $0.601 $0.642 $0.808
Options - percentage 0.02% 0.066 0.03% 0.079 0.03% 0.090 0.03% 0.103 0.04% 0.115 0.04% 0.130 0.04% 0.148 0.05% -100.00%
Options - amount $2.384 $3.699 $4.258 $5.694 $5.315 $5.781 $6.997 $9.997
Increase in O/S Shares 0.04% 0.020 0.01% 2.570 1.06% 0.420 0.17% 0.330 0.13% 0.034 0.01% 0.620 0.22% 0.600 0.20% 0.780 0.26% Average 31.72%
due to SO  $4.698 $0.874 $143.380 $22.722 $20.863 $1.760 $31.186 $32.238 $52.759
Book Value $3.000 $1.000 $104.000 $20.000 $14.000 $2.000 $31.000 $28.000 $42.000
Insider Buying -$1.866 -$0.063 -$0.163 -$0.535 -$0.391 -$0.970 -$3.173 -$1.040 -$0.326
Insider Selling $1.823 $0.329 $34.518 $2.430 $4.297 $2.198 $2.097 $2.327 $4.018
Net Insider Selling -$0.043 $0.267 $34.355 $1.896 $3.906 $1.228 -$1.076 $1.287 $3.692
% of Market Cap 0.00% 0.00% 0.25% 0.01% 0.03% 0.01% -0.01% 0.01% 0.02%
Directors 14 12 12 13 12 11 12 12
Women 31% 4 29% 4 33% 5 42% 5 38% 5 42% 5 45% 5 42% 5 42%
Minorities 0% 0 0% 0 0% 0 0% 1 8% 1 8% 1 9% 1 8% 1 8%
Institutions/Holdings 27.63% 12 36.52%
Total Shares Held 1.18% 1.411 0.60%
Increase/Decrease 2.63% 0.004 0.26%
Starting No. of Shares Rueters 1.408 Rueters
Institutions/Holdings 1.59% 6 0.08% 20 19.37% 20 27.43% 20 22.54% 20 20.85% 20 21.12% 20 21.62% 20 58.19%
Total Shares Held 1.56% 0.179 0.08% 43.211 18.46% 68.973 26.42% 58.868 21.81% 56.293 19.81% 60.374 20.40% 64.374 21.33% 175.578 58.18%
Increase/Decrease 82.85% -0.326 -64.51% -2.660 -5.80% -1.246 -1.77% 0.041 0.07% 0.755 1.36% -2.392 -3.81% -0.192 -0.30% -17.515 -9.07%
Starting No. of Shares NASDAQ 0.505 NASDAQ 45.870 Top 20 MS 70.219 Top 20 MS 58.827 Top 20 MS 55.537 Top 20 MS 62.766 Top 20 MS 64.566 Top 20 MS 193.093 Top 20 MS
Institutions/Holdings 30.26% 288 25.62%
In M$ $3,251.85 $3,484.64
Total Shares Held 30.75% 48.000 20.50%
In M$ $3,382.56 $2,255.04
Increase/Decrease 9.09% -11.000 -18.64%
Starting No. of Shares Morningstar 59.000 Morningstar
Copyright © 2008 Website of SPBrunner. All rights reserved.