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 2025 <-Estimates https://www.annualreports.com/Company/altagas-ltd
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ 3/31/25 <-Estimates
AltaGas Ltd TSX:  ALA OTC: ATGFF https://www.altagas.ca/ Fiscal Yr: Dec 31
Year 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 12/31/27 Value Description #Y Item Total G
Accoumting Rules 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 US GAAP Accoumting Rules
Revenue from Utilities $438 $894 $1,077 $1,077 $1,065.8 $1,128 $1,765.6 $2,590.8 $3,817 $3,936 $3,936 $4,827 $4,444 312.67% <-Total Growth 10 Revenue from Utilites
Cost of Sales $225.8 $502.5 $651.6 $595.8 $557.1 $610.1 $838.3 $1,117.9 $2,156 $2,273 $2,273 $2,988 $2,584 296.56% <-Total Growth 10 Cost of Sales
Change 184.34% 122.54% 29.67% -8.56% -6.50% 9.51% 37.40% 33.35% 92.86% 5.43% 0.00% 31.46% -13.52% 7.47% <-Median-> 10 Change
Ratio 0.25 0.49 0.55 0.70 0.69 0.61 0.58 0.71 1.32 0.35 0.35 0.37 0.33 0.59 <-Median-> 10 Ratio
Revenue from Midstream $908.0 $1,019.9 $1,178.8 $845.5 $804.1 $1,008.0 $1,435.0 $1,581.2 $1,636 $6,535 $6,533 $8,069 $7,918 571.70% <-Total Growth 10 Revenue from Midstream
Cost of Sales $586.4 $658.1 $789.6 $503.2 $496.1 $647.0 $976.4 $1,057.7 $994 $5,412 $5,412 $7,098 $6,586 734.09% <-Total Growth 10 Cost of Sales
Change -21.57% 12.23% 19.98% -36.27% -1.41% 30.42% 50.91% 8.33% -6.02% 444.47% 0.00% 31.15% -7.21% 4.16% <-Median-> 10 Change
Ratio 0.69 0.53 0.54 0.46 0.49 0.48 0.40 0.33 0.31 0.70 0.49 0.70 0.72 0.48 <-Median-> 10 Ratio
Cost of Sales $852.3 $1,236.2 $1,450.9 $1,104.9 $1,016.9 $1,357.1 $2,455.3 $3,227.1 $3,178 $7,708 $11,138 $10,112 $9,201 534.16% <-Total Growth 10 Cost of Sales
Change 2.34% 45.04% 17.37% -23.85% -7.96% 33.45% 80.92% 31.43% -1.52% 142.54% 44.50% -9.21% -9.01% 14.96% <-Median-> 10 Change
Ratio 0.59 0.61 0.60 0.50 0.46 0.53 0.58 0.59 0.57 0.73 0.79 0.78 0.74 0.58 <-Median-> 10 Ratio
Operating and Admin $572 $1,129 $1,579 $1,796 Operating and Admin
Change 97.31% 13.74% Change
Ratio 0.22 0.27 0.12 0.14 Ratio
Total $1,929 $3,584 $11,691 $10,997 Total
Change 85.78% -5.94% Change
Ratio 0.75 0.84 0.90 0.88 Ratio
$12,141 <-12 mths -2.47%
Revenue* $1,450.3 $2,042.9 $2,405.9 $2,192.8 $2,189.7 $2,556.2 $4,256.7 $5,495.0 $5,587 $10,573 $14,087 $12,997 $12,448 $14,248 $14,747 $16,512 417.39% <-Total Growth 10 Revenue
Increase -7.26% 40.87% 17.77% -8.86% -0.14% 16.74% 66.52% 29.09% 1.67% 89.24% 33.24% -7.74% -4.22% 14.46% 3.50% 11.97% 17.86% <-IRR #YR-> 10 Revenue 417.39%
5 year Running Average $1,490.7 $1,535.9 $1,763.4 $1,931.1 $2,056.3 $2,277.5 $2,720.3 $3,338.1 $4,016.9 $5,693.6 $7,999.7 $9,747.8 $11,138.4 $12,871 $13,705 $14,190 17.77% <-IRR #YR-> 5 Revenue 126.53%
Revenue per Share $13.77 $16.70 $17.96 $14.99 $13.12 $14.58 $15.47 $19.69 $19.99 $37.72 $50.04 $44.07 $41.78 $47.82 $49.50 $55.42 20.24% <-IRR #YR-> 10 5 yr Running Average 531.64%
Increase -21.43% 21.33% 7.54% -16.55% -12.48% 11.16% 6.05% 27.31% 1.52% 88.72% 32.64% -11.92% -5.20% 14.46% 3.50% 11.97% 27.25% <-IRR #YR-> 5 5 yr Running Average 233.68%
5 year Running Average $17.75 $16.04 $16.47 $16.19 $15.31 $15.47 $15.22 $15.57 $16.57 $21.49 $28.58 $34.30 $38.72 $44.29 $46.64 $47.72 8.81% <-IRR #YR-> 10 Revenue per Share 132.61%
P/S (Price/Sales) Med 2.26 2.21 2.50 2.56 2.40 2.13 1.34 0.87 0.80 0.61 0.53 0.53 0.75 0.75 0.00 0.00 16.24% <-IRR #YR-> 5 Revenue per Share 112.20%
P/S (Price/Sales) Close 2.44 2.44 2.41 2.06 2.58 1.96 0.90 1.00 0.94 0.72 0.47 0.63 0.80 0.81 0.78 0.70 8.92% <-IRR #YR-> 10 5 yr Running Average 135.06%
P/S 10 Year Median  1.08 1.13 1.13 1.35 1.87 2.17 2.17 2.17 2.17 2.17 1.73 1.10 0.84 0.78 0.75 0.68 19.99% <-IRR #YR-> 5 5 yr Running Average 148.69%
*Revenue in M CDN $  P/S Med 20 yr  1.08 15 yr  1.34 10 yr  0.84 5 yr  0.61 -3.56% Diff M/C
$4.02 <-12 mths 9.24% Estimates Last 12 months from Qtr
AFFO* Amount $626 $835
Calc per Share $2.81 $3.02
AFFO* per Share $2.46 $2.99 $3.20 $2.97 $2.96 $3.68 $2.81 $3.01 $3.14 $3.75 $3.63 $3.68 $3.97 $4.28 24.06% <-Total Growth 10 AFFO
Increase 3.36% 21.54% 7.02% -7.19% -0.34% 24.32% -23.58% 7.03% 4.32% 19.43% -3.20% 1.38% 7.88% 7.81% 10 0 10 Years of Data, EPS P or N 100.00%
AFFO Yield 7.33% 7.33% 7.38% 9.61% 8.73% 12.86% 20.23% 15.22% 16.77% 13.73% 15.53% 13.23% 11.86% 11.10% 2.18% <-IRR #YR-> 10 AFFO 24.06%
5 year Running Average $2.80 $2.92 $3.16 $3.12 $3.09 $3.12 $3.28 $3.27 $3.44 $3.63 $3.86 5.69% <-IRR #YR-> 5 AFFO 31.89%
Payout Ratio AFFO 56.50% 49.83% 52.19% 62.88% 68.24% 57.27% 77.87% 31.89% 30.57% 26.66% 29.20% 30.43% 29.97% 29.44% 2.94% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
5 year Running Average 55.34% 57.87% 57.94% 63.08% 59.26% 52.80% 44.54% 38.26% 30.12% 29.79% 29.59% 3.32% <-IRR #YR-> 5 5 yr Running Average 17.74%
Price/AFFO Median 12.63 12.37 14.04 12.91 10.65 8.45 7.34 5.67 5.12 6.17 7.34 6.33 7.91 8.42 7.34 <-Median-> 10 P/AFFO Med
Price/AFFO High 13.91 13.64 16.53 15.94 11.82 9.48 10.40 6.88 7.19 7.27 8.53 6.83 8.99 9.01 8.76 <-Median-> 10 P/AFFO High
Price/AFFO Low 11.34 11.10 11.55 9.88 9.47 7.43 4.28 4.47 3.05 5.06 6.15 5.83 6.83 7.82 5.99 <-Median-> 10 P/AFFO Low
Price/AFFO Close 13.65 13.64 13.54 10.40 11.45 7.78 4.94 6.57 5.96 7.28 6.44 7.56 8.43 9.01 7.42 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 14.11 16.57 14.49 9.66 11.41 9.67 3.78 7.03 6.22 8.70 6.23 7.66 9.10 9.71 8.18 <-Median-> 10 Trailing P/AFFO Close
Median Values DPR 10 Yrs 31.23% 5 Yrs   29.97% P/CF 5 Yrs   in order 6.33 7.27 5.83 7.28 42.29% Diff M/C 22.68% Diff M/C 10 DPR 75% to 95% best
Normalized Funds from Op $1,003 $1,198 $1,204 $1,128 $1,192 Normalized Funds from Op
Distributional. Inccome $2.96 $3.47 $3.72 $3.41 $3.52 $3.60 $2.95 $3.23 $3.59 $4.28 $4.28 $4.00 $4.01 $4.01 <-12 mths 7.80% <-Total Growth 10 FFO
Increase 10.04% 17.23% 7.20% -8.33% 3.23% 2.27% -18.06% 9.49% 11.15% 19.22% 0.11% -6.64% 0.25% 0.00% <-12 mths 10 0 10 Years of Data, EPS P or N 100.00%
FFO Yield 8.82% 8.51% 8.58% 11.04% 10.38% 12.58% 21.22% 16.33% 19.18% 15.67% 18.33% 14.38% 11.98% 10.40% <-12 mths 0.75% <-IRR #YR-> 10 FFO 7.80%
5 year Running Average $2.76 $2.82 $3.05 $3.25 $3.42 $3.54 $3.44 $3.34 $3.38 $3.53 $3.67 $3.88 $4.03 $4.12 <-12 mths 4.42% <-IRR #YR-> 5 FFO 24.15%
Payout Ratio 46.96% 42.94% 44.89% 54.77% 57.39% 58.54% 74.24% 29.72% 26.74% 23.35% 24.74% 28.00% 29.68% 31.42% <-12 mths 2.85% <-IRR #YR-> 10 5 yr Running Average 32.40%
5 year Running Average 63.47% 57.06% 49.57% 47.68% 49.40% 51.66% 57.30% 54.73% 48.77% 41.36% 34.10% 26.74% 26.84% 27.75% <-12 mths 3.83% <-IRR #YR-> 5 5 yr Running Average 20.68%
Price/FFO Median 10.49 10.66 12.08 11.24 8.95 8.64 7.00 5.29 4.48 5.40 6.22 5.82 7.83 8.99 <-12 mths 6.61 <-Median-> 10 P/FFO Med
Price/FFO High 11.56 11.75 14.22 13.88 9.94 9.69 9.92 6.41 6.29 6.37 7.23 6.29 8.90 9.62 <-12 mths 8.07 <-Median-> 10 P/FFO High
Price/FFO Low 9.43 9.56 9.94 8.60 7.97 7.59 4.08 4.16 2.67 4.44 5.21 5.36 6.76 8.35 <-12 mths 5.28 <-Median-> 10 P/FFO Low
Price/FFO Close 11.34 11.75 11.65 9.06 9.63 7.95 4.71 6.12 5.21 6.38 5.46 6.96 8.35 9.61 <-12 mths 6.67 <-Median-> 10 P/FFO Close
Trailing P/FFO Close 12.48 13.77 12.49 8.31 9.94 8.13 3.86 6.71 5.80 7.61 5.46 6.49 8.37 9.61 <-12 mths 7.16 <-Median-> 10 Trailing P/FFO Close
Median Values Historical   in order 7.83 9.69 6.76 7.95 P/CF 5 Yrs   in order 5.82 6.37 5.21 6.38 65.07% Diff M/C 65.07% Diff M/C 10 DPR 75% to 95% best
* Normalized Funds From Operations
Last 12 months from Qtr $2.16 <-12 mths -0.46% Estimates Last 12 months from Qtr
Normalized Net Income AEPS $110.0 $176 $165 $140 $153 $204 $195 $324 $396 $497 $530 $536 $648 292.73% <-Total Growth 10 Normalized Earnings
Return on Equity ROE 7.03% 7.99% 5.99% 4.40% 4.26% 6.19% 3.42% 5.46% 6.64% 8.46% 7.71% 7.32% 7.75% 6.41% <-Median-> 10 Return on Equity ROE
5Yr Median 7.76% 7.87% 7.76% 7.03% 5.99% 5.99% 4.40% 4.40% 5.46% 6.19% 6.64% 7.32% 7.71% 6.09% <-Median-> 10 5Yr Median
Normalized Earnings Basic $1.15 $1.51 $1.30 $1.02 $0.98 $1.19 $0.88 $1.17 $1.42 $1.78 $1.89 $1.90 $2.18 67.69% <-Total Growth 10 AEPS
Normalized Earnings Diluted $1.14 $1.47 $1.28 $1.01 $0.97 $1.19 $0.88 $1.17 $1.42 $1.76 $1.87 $1.89 $2.17 $2.23 $2.41 $2.73 69.13% <-Total Growth 10 AEPS
Increase 7.89% 28.94% -12.88% -21.39% -3.75% 22.67% -26.47% 33.39% 21.22% 24.61% 6.04% 1.03% 14.81% 2.76% 8.07% 13.28% 10 0 10 Years of Data, EPS P or N 100.00%
NEPSYield 3.40% 3.61% 2.96% 3.26% 2.86% 4.16% 6.30% 5.90% 7.56% 6.46% 8.00% 6.79% 6.48% 5.78% 6.25% 7.08% 5.40% <-IRR #YR-> 10 AEPS 69.13%
5 year Running Average $1.51 $1.34 $1.26 $1.19 $1.18 $1.19 $1.07 $1.04 $1.12 $1.28 $1.42 $1.62 $1.82 $1.99 $2.11 $2.29 13.19% <-IRR #YR-> 5 AEPS 85.79%
Payout Ratio 121.70% 101.18% 130.16% 185.15% 208.07% 176.97% 250.11% 82.19% 67.81% 56.66% 56.66% 59.26% 54.84% 56.50% 52.28% 46.15% 3.77% <-IRR #YR-> 10 5 yr Running Average 44.76%
5 year Running Average 116.18% 119.99% 119.96% 129.88% 143.56% 154.49% 184.93% 175.39% 146.55% 113.81% 88.14% 63.92% 59.41% 57.56% 55.72% 53.28% 11.81% <-IRR #YR-> 5 5 yr Running Average 74.74%
Price/NEPS Median 27.20 25.11 35.02 38.01 32.46 26.12 23.58 14.62 11.35 13.11 14.24 12.33 14.47 16.16 0.00 0.00 14.55 <-Median-> 10 P/NEPS Med
Price/NEPS High 29.97 27.68 41.23 46.93 36.03 29.30 33.41 17.73 15.94 15.45 16.56 13.31 16.45 17.30 0.00 0.00 17.15 <-Median-> 10 P/NEPS High
Price/NEPS Low 24.43 22.53 28.81 29.08 28.88 22.95 13.76 11.52 6.77 10.76 11.93 11.34 12.49 15.01 0.00 0.00 12.21 <-Median-> 10 P/NEPS Low
Price/NEPS Close 29.39 27.68 33.78 30.64 34.92 24.03 15.87 16.94 13.22 15.48 12.50 14.72 15.43 17.29 16.00 14.12 15.68 <-Median-> 10 P/NEPS Close
Trailing P/NEPS Close 31.71 35.70 29.43 24.08 33.61 29.48 11.67 22.59 16.03 19.29 13.25 14.87 17.71 17.76 17.29 16.00 18.50 <-Median-> 10 Trailing P/NEPS Close
Median Values Historical   in order 23.58 27.68 13.76 16.94 P/CF 5 Yrs   in order 13.11 15.94 11.34 14.72 31.89% Diff M/C 35.54% Diff M/C 10 DPR 75% to 95% best
$1.93 <-12 mths -0.52% Estimates Last 12 months from Qtr
Difference Basic and Diluted 0.93% 2.56% 1.33% 0.00% 0.00% 0.00% 0.00% 0.36% 0.00% 0.00% 0.70% 0.44% 0.51% 0.00% <-Median-> 10 Difference Basic and Diluted
EPS Basic $1.07 $1.56 $0.75 $0.07 $0.99 $0.18 -$2.25 $2.78 $1.74 $0.82 $1.42 $2.27 $1.95 160.00% <-Total Growth 10 EPS Basic
EPS Diluted* $1.06 $1.52 $0.74 $0.07 $0.99 $0.18 -$2.25 $2.77 $1.74 $0.82 $1.41 $2.26 $1.94 $2.24 $2.42 $2.69 162.16% <-Total Growth 10 EPS Diluted
Increase 9.28% 43.40% -51.32% -90.54% 1314.29% -81.82% -1350.00% -223.11% -37.18% -52.87% 71.95% 60.28% -14.16% 15.36% 8.13% 11.03% 9 1 10 Years of Data, EPS P or N 90.00%
Earnings Yield 3.2% 3.7% 1.7% 0.2% 2.9% 0.6% -16.2% 14.0% 9.3% 3.0% 6.0% 8.1% 5.8% 5.8% 6.3% 7.0% 10.12% <-IRR #YR-> 10 Earnings per Share 162.16%
5 year Running Average $1.47 $1.31 $1.10 $0.87 $0.88 $0.70 -$0.05 $0.35 $0.69 $0.65 $0.90 $1.80 $1.63 $1.73 $2.05 $2.31 -6.88% <-IRR #YR-> 5 Earnings per Share -29.96%
10 year Running Average $1.51 $1.58 $1.53 $1.37 $1.26 $1.09 $0.63 $0.72 $0.78 $0.76 $0.80 $0.87 $0.99 $1.21 $1.35 $1.60 4.07% <-IRR #YR-> 10 5 yr Running Average 49.09%
* Diluted ESP per share  E/P 10 Yrs 4.40% 5Yrs 6.03% 35.94% <-IRR #YR-> 5 5 yr Running Average 364.20%
Dividend estimates $1.26 $1.33 $1.38 Estimates Dividend estimates
Increase 5.97% 5.23% 4.14% Estimates Increase
Payout Ratio EPS 56.34% 54.83% 51.43% 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.0833 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Dividend* $1.3900 $1.4900 $1.6700 $1.8675 $2.0200 $2.1075 $2.1900 $0.9600 $0.9600 $0.9996 $1.0600 $1.1200 $1.1900 $1.2600 $1.2600 $1.2600 -28.74% <-Total Growth 10 Dividends
Increase 4.51% 7.19% 12.08% 11.83% 8.17% 4.33% 3.91% -56.16% 0.00% 4.13% 6.04% 5.66% 6.25% 5.88% 0.00% 0.00% 18 3 23 Years of data, Count P, N 78.26%
Average Increases 5 Year Running -6.75% -5.89% -3.85% 3.05% 8.76% 8.72% 8.06% -5.59% -7.95% -8.76% -8.42% -8.07% 4.42% 5.59% 4.77% 3.56% -1.27% <-Median-> 10 Average Incr 5 Year Running
5 Year Running Average $1.75 $1.61 $1.51 $1.55 $1.69 $1.83 $1.97 $1.83 $1.65 $1.46 $1.25 $1.04 $1.08 $1.14 $1.18 $1.22 -28.31% <-Total Growth 10 5 Year Running Average
Yield H/L Price 4.47% 4.03% 3.72% 4.87% 6.41% 6.77% 10.61% 5.62% 5.97% 4.32% 3.98% 4.81% 3.79% 3.50% 5.25% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 4.06% 3.65% 3.16% 3.94% 5.77% 6.04% 7.49% 4.64% 4.25% 3.67% 3.42% 4.45% 3.33% 3.27% 4.35% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 4.98% 4.49% 4.52% 6.37% 7.20% 7.71% 18.17% 7.14% 10.02% 5.26% 4.75% 5.22% 4.39% 3.76% 6.75% <-Median-> 10 Yield on Low Price AEPS
Yield on Close Price 4.14% 3.65% 3.85% 6.04% 5.96% 7.36% 15.76% 4.85% 5.13% 3.66% 4.53% 4.03% 3.55% 3.27% 3.27% 3.27% 4.99% <-Median-> 10 Yield on Close Price CFPS
Payout Ratio EPS 131.13% 98.03% 225.68% 2667.86% 204.04% 1170.83% -97.33% 34.66% 55.17% 132.06% 75.18% 49.56% 61.34% 56.30% 52.07% 46.89% 68.26% <-Median-> 10 Payout Ratio EPS FCF 
DPR EPS 5 Yr Running 118.67% 123.12% 137.77% 177.69% 192.64% 261.57% -3650.00% 519.60% 240.16% 223.94% 139.26% 57.59% 66.25% 65.91% 57.36% 52.75% 185.17% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 100.04% 49.74% 48.87% 54.51% 73.90% 67.76% -766.85% 43.53% 34.71% 41.13% 55.37% 29.46% 23.05% 30.84% 29.44% 27.33% 42.33% <-Median-> 10 Payout Ratio CFPS
DPR CF 5 Yr Running 77.92% 70.76% 60.46% 57.05% 60.43% 58.38% 79.47% 81.73% 78.23% 70.00% 67.72% 38.91% 33.26% 32.47% 30.61% 27.76% 64.08% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 57.68% 45.74% 47.73% 59.13% 63.17% 68.50% 147.77% 31.63% 27.49% 26.44% 25.10% 32.35% 32.00% 30.84% 29.44% #DIV/0! 32.17% <-Median-> 10 Payout Ratio CFPS WC
DPR CF WC 5 Yr Running 68.63% 61.88% 54.01% 52.42% 54.36% 56.55% 68.37% 65.56% 57.67% 48.09% 38.29% 28.31% 28.50% 29.17% 29.79% #DIV/0! 53.39% <-Median-> 10 DPR CF WC 5 Yr Running
Median 5 Yrs 10 Yr Med 10 Yr Cl 5.25% 4.99% 5 Yr Med 5 Yr Cl 4.32% 4.03% 5 Yr Med Payout 61.34% 34.71% 27.49% 4.39% <-IRR #YR-> 5 Dividends 23.96%
* Dividends per share  10 Yr Med and Cur. -37.70% -34.51% 5 Yr Med and Cur. -24.39% -18.81% Last Div Inc ---> $0.2975 $0.3150 5.88% -3.33% <-IRR #YR-> 10 Dividends -28.74%
Dividends Growth 15 -3.90% <-IRR #YR-> 15 Dividends -44.91%
Dividends Growth 20 -0.03% <-IRR #YR-> 20 Dividends
Dividends Growth 25 9.42% <-IRR #YR-> 23 Dividends
Historical Dividends Historical High Div 16.41% Low Div 2.17% 10 Yr High 17.36% 10 Yr Low 3.34% Med Div 5.29% Close Div 4.99% Historical Dividends
High/Ave/Median Values Curr diff Exp. -80.08%     50.62% Exp. -81.17% -2.14% Exp. -38.21% Exp. -34.51% High/Ave/Median 
Future Dividend Yield Div Yd 4.05% earning in 5 Years at IRR of 4.39% Div Inc. 23.96% Future Dividend Yield
Future Dividend Yield Div Yd 5.02% earning in 10 Years at IRR of 4.39% Div Inc. 53.66% Future Dividend Yield
Future Dividend Yield Div Yd 6.23% earning in 15 Years at IRR of 4.39% Div Inc. 90.47% Future Dividend Yield
Future Dividend Paid Div Paid $1.56 earning in 5 Years at IRR of 4.39% Div Inc. 23.96% Future Dividend Paid
Future Dividend Paid Div Paid $1.94 earning in 10 Years at IRR of 4.39% Div Inc. 53.66% Future Dividend Paid
Future Dividend Paid Div Paid $2.40 earning in 15 Years at IRR of 4.39% Div Inc. 90.47% Future Dividend Paid
Dividend Covering Cost Total Div $6.88 over 5 Years at IRR of 4.39% Div Cov. 17.84% Dividend Covering Cost
Dividend Covering Cost Total Div $13.84 over 10 Years at IRR of 4.39% Div Cov. 35.91% Dividend Covering Cost
Dividend Covering Cost Total Div $22.47 over 15 Years at IRR of 4.39% Div Cov. 58.30% Dividend Covering Cost
I am earning GC Div Gr -41.67% 5/22/09 # yrs -> 15 2009 $16.02 Cap Gain 140.64% I am earning GC
I am earning Div org yield 13.48% 12/31/25 Trading Div G Yrly -3.19% Div start $2.16 -13.48% 7.87% I am earning Div
I am earning GC Div Gr -4.55% 6/8/10 # yrs -> 14 2010 $18.13 Cap Gain 112.63% I am earning GC
I am earning Div org yield 7.28% 12/31/25 Pension Div G Yrly -0.30% Div start $1.32 -7.28% 6.95% I am earning Div
I am earning GC Div Gr -8.70% 8/9/12 # yrs -> 12 2012 $30.48 Cap Gain 26.48% I am earning GC
I am earning Div org yield 4.53% 12/31/25 RRSP Div G Yrly -0.68% Div start $1.38 -4.53% 4.13% I am earning Div
Yield if held 5 years 5.26% 7.27% 10.58% 9.66% 7.53% 6.78% 5.92% 2.14% 2.50% 3.17% 3.41% 5.42% 6.97% 7.84% 5.45% 4.73% 5.67% <-Median-> 10 Paid Median Price
Yield if held 10 years 13.30% 11.95% 8.67% 6.97% 7.66% 7.98% 10.68% 6.08% 4.97% 3.73% 3.41% 3.03% 2.65% 3.29% 4.00% 4.05% 5.52% <-Median-> 10 Paid Median Price
Yield if held 15 years 20.81% 33.35% 31.84% 20.16% 17.57% 4.98% 3.58% 3.79% 4.01% 5.46% 7.54% 6.52% 4.70% 4.06% 6.50% <-Median-> 10 Paid Median Price
Yield if held 20 years 11.96% 17.14% 15.75% 10.14% 8.99% 6.18% 4.70% 4.78% 4.77% 11.05% <-Median-> 6 Paid Median Price
Yield if held 25 years 14.83% 22.50% 19.86% 12.05% 14.83% <-Median-> 1 Paid Median Price
Cost covered if held 5 years 33.12% 39.22% 47.85% 40.07% 31.47% 29.47% 26.65% 20.35% 21.49% 23.17% 20.10% 25.10% 31.69% 35.54% 25.47% 22.86% 25.88% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 158.70% 142.08% 94.36% 65.93% 67.73% 67.78% 87.29% 105.80% 82.67% 58.69% 49.60% 40.67% 32.40% 36.39% 41.86% 39.68% 66.83% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 251.43% 393.66% 376.91% 246.27% 221.14% 141.82% 96.66% 95.42% 91.46% 112.58% 140.10% 112.22% 80.66% 69.20% 140.96% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 365.39% 540.76% 491.97% 306.08% 262.72% 169.91% 117.98% 117.77% 114.52% 335.73% <-Median-> 6 Paid Median Price
Cost covered if held 25 years 432.84% 642.77% 584.79% 364.33% 432.84% <-Median-> 1 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $5,495 $5,587 $10,573 $14,087 $12,997 $12,448 $12,141 <-12 mths -2.47% 126.53% <-Total Growth 5 Revenue Growth  126.53%
AEPS Growth $1.17 $1.42 $1.76 $1.87 $1.89 $2.17 $2.16 <-12 mths -0.46% 85.79% <-Total Growth 5 AEPS Growth 85.79%
Net Income Growth $765 $486 $230 $399 $641 $578 $513 <-12 mths -11.33% -24.44% <-Total Growth 5 Net Income Growth -24.44%
Cash Flow Growth $616 $773 $738 $539 $1,121 $1,538 149.88% <-Total Growth 5 Cash Flow Growth 149.88%
Dividend Growth $0.96 $0.96 $1.00 $1.06 $1.12 $1.19 $1.26 <-12 mths 5.88% 23.96% <-Total Growth 5 Dividend Growth 23.96%
Stock Price Growth $19.78 $18.72 $27.31 $23.38 $27.82 $33.48 $38.55 <-12 mths 15.14% 69.26% <-Total Growth 5 Stock Price Growth 69.26%
Revenue Growth  $2,406 $2,193 $2,190 $2,556 $4,257 $5,495 $5,587 $10,573 $14,087 $12,997 $12,448 $14,248 <-this year 14.46% 417.39% <-Total Growth 10 Revenue Growth  417.39%
AEPS Growth $1.28 $1.01 $0.97 $1.19 $0.88 $1.17 $1.42 $1.76 $1.87 $1.89 $2.17 $2.23 <-this year 2.76% 69.13% <-Total Growth 10 AEPS Growth 69.13%
Net Income Growth $96 $10 $155 $30 -$502 $765 $486 $230 $399 $641 $578 $676 <-this year 17.02% 504.60% <-Total Growth 10 Net Income Growth 504.60%
Cash Flow Growth $458 $501 $456 $545 -$79 $616 $773 $738 $539 $1,121 $1,538 $1,217 <-this year -20.87% 236.03% <-Total Growth 10 Cash Flow Growth 236.03%
Dividend Growth $1.67 $1.87 $2.02 $2.11 $2.19 $0.96 $0.96 $1.00 $1.06 $1.12 $1.19 $1.26 <-this year 5.97% -28.74% <-Total Growth 10 Dividend Growth -28.74%
Stock Price Growth $43.34 $30.90 $33.90 $28.62 $13.90 $19.78 $18.72 $27.31 $23.38 $27.82 $33.48 $38.55 <-this year 15.14% -22.75% <-Total Growth 10 Stock Price Growth -22.75%
Dividends on Shares $44.82 $48.48 $50.58 $52.56 $23.04 $23.04 $25.99 $25.44 $26.88 $28.56 $30.24 $30.24 $30.24 $349.39 No of Years 10 Total Divs 12/31/14
Paid  $1,040.16 $741.60 $813.60 $686.88 $333.60 $474.72 $449.28 $655.44 $561.12 $667.68 $803.52 $925.20 $925.20 $925.20 $803.52 No of Years 10 Worth $43.34
$1,152.91
Dividends on Shares $48.96 $55.23 $54.06 $57.12 $60.69 $64.26 $64.26 $64.26 $276.06 No of Years 5 Total Divs 12/31/19
Paid  $1,008.78 $954.72 $1,392.81 $1,192.38 $1,418.82 $1,707.48 $1,966.05 $1,966.05 $1,966.05 $1,707.48 No of Years 5 Worth $19.78
$1,983.54
Graham Price AEPS $19.54 $24.43 $24.36 $22.22 $21.69 $22.45 $20.20 $23.65 $26.07 $28.84 $32.05 $32.49 $37.02 $37.52 $39.01 $41.52 51.97% <-Total Growth 10 Graham Price AEPS
Price/GP Ratio Med 1.59 1.51 1.84 1.73 1.45 1.39 1.02 0.72 0.62 0.80 0.83 0.72 0.85 0.96 0.84 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 1.75 1.67 2.17 2.13 1.61 1.55 1.45 0.88 0.87 0.95 0.97 0.77 0.96 1.03 0.97 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 1.43 1.36 1.52 1.32 1.29 1.22 0.60 0.57 0.37 0.66 0.70 0.66 0.73 0.89 0.68 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 1.72 1.67 1.78 1.39 1.56 1.28 0.69 0.84 0.72 0.95 0.73 0.86 0.90 1.03 0.99 0.93 0.88 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 71.80% 66.92% 77.93% 39.05% 56.28% 27.51% -31.19% -16.35% -28.20% -5.31% -27.05% -14.38% -9.55% 2.73% -1.18% -7.15% -11.97% <-Median-> 10 Prem/Disc Close
Graham Price EPS $18.82 $24.81 $18.50 $5.85 $21.91 $8.73 $9.16 $36.42 $28.90 $19.66 $27.82 $35.53 $35.00 $37.59 $39.09 $41.19 89.21% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 1.65 1.49 2.43 6.55 1.44 3.57 2.25 0.47 0.56 1.18 0.96 0.66 0.90 0.96 1.07 <-Median-> 10 Price/GP Ratio Med 0.90
Price/GP Ratio High 1.82 1.64 2.86 8.09 1.60 4.00 3.19 0.57 0.78 1.39 1.11 0.71 1.02 1.03 1.25 <-Median-> 10 Price/GP Ratio High 1.02
Price/GP Ratio Low 1.48 1.34 2.00 5.01 1.28 3.13 1.32 0.37 0.33 0.97 0.80 0.60 0.77 0.89 0.88 <-Median-> 10 Price/GP Ratio Low 0.77
Price/GP Ratio Close 1.78 1.64 2.34 5.28 1.55 3.28 1.52 0.54 0.65 1.39 0.84 0.78 0.96 1.03 0.99 0.94 1.17 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 78.33% 64.30% 134.29% 427.84% 54.76% 227.97% 51.76% -45.68% -35.23% 38.89% -15.97% -21.70% -4.34% 2.55% -1.38% -6.41% 17.28% <-Median-> 10 Prem/Disc Close
Price Close $33.57 $40.77 $43.34 $30.90 $33.90 $28.62 $13.90 $19.78 $18.72 $27.31 $23.38 $27.82 $33.48 $38.55 $38.55 $38.55 -22.75% <-Total Growth 10 Stock Price
Increase 5.43% 21.45% 6.30% -28.70% 9.71% -15.58% -51.43% 42.30% -5.36% 45.89% -14.39% 18.99% 20.35% 15.14% 0.00% 0.00% 32.89 <-Median-> 10 CAPE (10 Yr P/E)
P/E 31.67 26.82 58.57 441.43 34.24 159.00 -6.18 7.14 10.76 33.30 16.58 12.31 17.26 17.23 15.93 14.35 11.10% <-IRR #YR-> 5 Stock Price 69.26%
Trailing P/E 34.61 38.46 28.51 41.76 484.29 28.91 77.22 -8.79 6.76 15.70 28.51 19.73 14.81 19.87 17.23 15.93 -2.55% <-IRR #YR-> 10 Stock Price -22.75%
CAPE (10 Yr P/E) 15.99 16.92 18.87 21.30 23.72 27.66 47.50 41.20 37.91 38.06 35.12 30.66 25.96 21.94 19.97 17.46 15.56% <-IRR #YR-> 5 Price & Dividend 101.48%
Median 10, 5 Yrs D.  per yr 3.79% 4.46% % Tot Ret 305.89% 28.67% T P/E 24.12 15.70 P/E:  16.92 16.58 1.81% Diff M/C 1.24% <-IRR #YR-> 10 Price & Dividend 14.69%
Price 15 D.  per yr 6.60% % Tot Ret 62.72% CAPE Diff -47.63% 3.92% <-IRR #YR-> 15 Stock Price 78.09%
Price  20 D.  per yr 6.73% % Tot Ret 78.34% 1.86% <-IRR #YR-> 20 Stock Price 44.62%
Price  25 D.  per yr 10.79% % Tot Ret 60.25% 7.12% <-IRR #YR-> 25 Stock Price
Price & Dividend 15 10.52% <-IRR #YR-> 15 Price & Dividend 207.17%
Price & Dividend 20 8.59% <-IRR #YR-> 20 Price & Dividend 191.22%
Price & Dividend 25 17.91% <-IRR #YR-> 25 Price & Dividend
Price H/L Median $31.07 $36.98 $44.93 $38.34 $31.51 $31.11 $20.65 $17.08 $16.08 $23.13 $26.65 $23.30 $31.40 $36.03 -30.11% <-Total Growth 10 Stock Price
Increase 15.85% 19.02% 21.51% -14.68% -17.80% -1.27% -33.62% -17.29% -5.88% 43.86% 15.22% -12.57% 34.79% 14.75% -3.52% <-IRR #YR-> 10 Stock Price -30.11%
P/E 29.31 24.33 60.72 547.64 31.83 172.83 -9.18 6.17 9.24 28.20 18.90 10.31 16.19 16.10 12.95% <-IRR #YR-> 5 Stock Price 83.84%
Trailing P/E 32.03 34.88 29.56 51.80 450.14 31.42 114.72 -7.59 5.80 13.29 32.49 16.52 13.89 18.57 0.27% <-IRR #YR-> 10 Price & Dividend 6.00%
P/E on Running 5 yr Average 21.08 28.31 40.99 43.96 35.97 44.44 -382.41 48.52 23.43 35.47 29.67 12.94 19.22 20.78 17.97% <-IRR #YR-> 5 Price & Dividend 121.15%
P/E on Running 10 yr Average 20.52 23.37 29.46 28.08 25.05 28.62 32.99 23.59 20.64 30.27 33.35 26.68 31.62 29.78 15.83 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 3.79% 5.02% % Tot Ret 1395.08% 27.93% T P/E 23.97 13.89 P/E:  17.54 16.19 Count 25 Years of data
High Months Dec Dec Aug Feb Oct Jan Jan Jul Jul Dec Apr Feb Oct Mar
Price High $34.23 $40.77 $52.90 $47.34 $34.98 $34.89 $29.25 $20.71 $22.57 $27.26 $30.98 $25.15 $35.70 $38.58 -32.51% <-Total Growth 10 Stock Price
Increase 6.50% 19.11% 29.75% -10.51% -26.11% -0.26% -16.17% -29.20% 8.98% 20.78% 13.65% -18.82% 41.95% 8.07% -3.86% <-IRR #YR-> 10 Stock Price -32.51%
P/E 32.29 26.82 71.49 676.29 35.33 193.83 -13.00 7.48 12.97 33.24 21.97 11.13 18.40 17.24 11.51% <-IRR #YR-> 5 Stock Price 72.38%
Trailing P/E 35.29 38.46 34.80 63.97 499.71 35.24 162.50 -9.20 8.15 15.67 37.78 17.84 15.80 19.89 18.51 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 26.54 15.80 P/E:  20.19 18.40 33.20 P/E Ratio Historical High
Low Months Jun Jan Dec Dec Jan Aug Dec Jan Mar Jan Nov Mar Feb Jan
Price Low $27.90 $33.18 $36.96 $29.33 $28.04 $27.33 $12.05 $13.45 $9.58 $18.99 $22.31 $21.44 $27.10 $33.48 -26.68% <-Total Growth 10 Stock Price
Increase 29.83% 18.92% 11.39% -20.64% -4.40% -2.53% -55.91% 11.62% -28.77% 98.23% 17.48% -3.90% 26.40% 23.54% -3.06% <-IRR #YR-> 10 Stock Price -26.68%
P/E 26.32 21.83 49.95 419.00 28.32 151.83 -5.36 4.86 5.51 23.16 15.82 9.49 13.97 14.96 15.04% <-IRR #YR-> 5 Stock Price 101.49%
Trailing P/E 28.76 31.30 24.32 39.64 400.57 27.61 66.94 -5.98 3.46 10.91 27.21 15.21 11.99 17.26 13.02 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 21.21 11.99 P/E:  14.90 13.97 8.02 P/E Ratio Historical Low
Free Cash Flow Market Screener $776 $1,015 $489 $1,161 $160 $183 $612 $990 -79.38% <-Total Growth 4 Free Cash Flow WSJ
Change 30.80% -51.82% 137.42% -86.22% 14.56% 234.04% 61.69% -10.51% <-Median-> 4 Change
Free Cash Flow WSJ -$1,069 -$681 -$52 -$67 -$405 $187 $160 114.97% <-Total Growth 6 Free Cash Flow WSJ
Change 36.30% 92.36% -28.85% -504.48% 146.17% -14.44% 10.93% <-Median-> 6 Change
Free Cash Flow MS old -$150 -$75 $48 -$1,107 -$718 -$70 -$76 -$419 $178
Change #DIV/0! 50.00% 164.00% -2406.25% 35.14% 90.25% -8.57% -451.32% 142.48%
Free Cash Flow MS -$675 -$181 -$91 -$190 $0 $50 -$620 -$490 $130 $330 $230 $80 -$280 $183 $612 -207.69% <-Total Growth 10 Free Cash Flow CF-CapEx
Change -172.18% 73.19% 49.72% -108.79% 100.00% #DIV/0! -1340.00% 20.97% 126.53% 153.85% -30.30% -65.22% -450.00% 165.46% 234.04% -10.59% <-IRR #YR-> 5 Free Cash Flow MS 42.86%
FCF/CF from Op Ratio -4.61 -0.49 -0.20 -0.38 0.00 0.09 7.89 -0.80 0.17 0.45 0.43 0.07 -0.18 0.15 0.48 11.90% <-IRR #YR-> 10 Free Cash Flow MS -207.69%
Dividends paid $130.4 $170.7 $210.3 $255 $248 $235 $473 $266 $268 $303 $298 $316 $353 $375 $375 67.86% <-Total Growth 10 Dividends paid
Percentage paid -19.32% -94.31% -231.10% -134.11% #DIV/0! 469.40% -76.27% 0.00% 206.15% 91.82% 129.57% 395.00% 0.00% 204.79% 61.31% #DIV/0! <-Median-> 9 Percentage paid
5 Year Coverage -65.00% -63.40% -89.19% -271.46% -166.93% -118.08% -160.13% -257.38% -382.76% 518.11% 313.88% 302.85% 208.06% 5 Year Coverage
Dividend Coverage Ratio -5.18 -1.06 -0.43 -0.75 0.00 0.21 -1.31 -1.84 0.49 1.09 0.77 0.25 -0.79 0.49 1.63 0.11 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage -1.54 -1.58 -1.12 -0.37 -0.60 -0.85 -0.62 -0.39 -0.26 0.19 0.32 0.33 0.48 5 Year of Coverage
Market Cap $3,536 $4,986 $5,805 $4,520 $5,658 $5,016 $3,826 $5,520 $5,232 $7,654 $6,582 $8,204 $9,975 $11,485 $11,485 $11,485 71.83% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 96.311 119.509 128.6 138.8 157.6 171.3 222.7 277.4 279.7 281.7 283.3 283.7 298.3 298.3 131.96% <-Total Growth 10 Diluted
Change 13.03% 24.09% 7.61% 7.93% 13.54% 8.69% 30.01% 24.56% 0.83% 0.72% 0.57% 0.14% 5.15% 0.00% 6.54% <-Median-> 10 Change
Difference Diluted/Basic -1.4% -2.9% -1.5% -0.8% -0.3% -0.2% 0.0% -0.2% -0.1% -0.6% -0.8% -0.6% -0.5% -0.5% -0.38% <-Median-> 10 Difference Diluted/Basic
Basic # of Shares in Millions 94.986 116.068 126.7 137.7 157.2 171.0 222.6 276.9 279.4 279.9 281.0 282.1 296.8 296.8 296.8 296.8 134.25% <-Total Growth 10 Basic
Change 13.02% 22.19% 9.16% 8.68% 14.16% 8.78% 30.18% 24.39% 0.90% 0.18% 0.39% 0.39% 5.21% 0.00% 0.00% 0.00% 6.95% <-Median-> 10 Change
Difference Basic/Outstanding 10.9% 5.4% 5.7% 6.2% 6.2% 2.5% 23.6% 0.8% 0.0% 0.1% 0.2% 4.5% 0.4% 0.4% 0.4% 0.4% 1.64% <-Median-> 10 Difference Basic/Outstanding
# of Share in Millons 105.340 122.305 133.942 146.281 166.907 175.279 275.224 279.075 279.494 280.269 281.532 294.904 297.925 297.925 297.925 297.925 8.32% <-IRR #YR-> 10 Shares 122.43%
Increase 18.03% 16.11% 9.51% 9.21% 14.10% 5.02% 57.02% 1.40% 0.15% 0.28% 0.45% 4.75% 1.02% 0.00% 0.00% 0.00% 1.32% <-IRR #YR-> 5 Shares 6.75%
CF fr Op $M $146.4 $366.3 $457.7 $501.2 $456.2 $545.2 -$78.6 $615.5 $773 $738 $539 $1,121 $1,538 $1,217 $1,275 $1,373 236.03% <-Total Growth 10 Cash Flow
Increase -30.27% 150.31% 24.94% 9.50% -8.98% 19.51% -114.42% -883.08% 25.59% -4.53% -26.96% 107.98% 37.20% -20.87% 4.77% 7.71% SO, S. Issue DRIP
5 year Running Average $187.67 $219.86 $274.58 $336.30 $385.56 $465.33 $376.34 $407.90 $462.26 $518.62 $517.38 $757.30 $941.80 $1,030.60 $1,138.03 $1,304.92 243.00% <-Total Growth 10 CF 5 Yr Running
CFPS $1.39 $3.00 $3.42 $3.43 $2.73 $3.11 -$0.29 $2.21 $2.77 $2.63 $1.91 $3.80 $5.16 $4.09 $4.28 $4.61 51.07% <-Total Growth 10 Cash Flow per Share
Increase -40.92% 115.59% 14.08% 0.27% -20.23% 13.80% -109.18% -872.27% 25.40% -4.79% -27.29% 98.55% 35.81% -20.87% 4.77% 7.71% 12.89% <-IRR #YR-> 10 Cash Flow 236.03%
5 year Running Average $2.24 $2.27 $2.50 $2.72 $2.79 $3.14 $2.48 $2.24 $2.11 $2.09 $1.85 $2.66 $3.26 $3.52 $3.85 $4.39 20.10% <-IRR #YR-> 5 Cash Flow 149.88%
P/CF on Med Price 22.36 12.34 13.15 11.19 11.53 10.00 -72.31 7.74 5.81 8.78 13.92 6.13 6.08 8.82 0.00 0.00 4.21% <-IRR #YR-> 10 Cash Flow per Share 51.07%
P/CF on Closing Price 24.16 13.61 12.68 9.02 12.40 9.20 -48.67 8.97 6.77 10.37 12.21 7.32 6.49 9.44 9.01 8.36 18.54% <-IRR #YR-> 5 Cash Flow per Share 134.07%
14.20% Diff M/C 2.69% <-IRR #YR-> 10 CFPS 5 yr Running 30.35%
Excl.Working Capital CF $107.49 $32.07 $10.90 -$39.20 $77.50 -$5.90 $486.50 $231.50 $203 $410 $650 -$100 -$430 $0 $0 7.78% <-IRR #YR-> 5 CFPS 5 yr Running 45.46%
CF fr Op $M WC $253.84 $398.41 $468.60 $462.00 $533.70 $539.30 $407.90 $847.00 $976 $1,148 $1,189 $1,021 $1,108 $1,217 $1,275 136.45% <-Total Growth 10 Cash Flow less WC
Increase 15.82% 56.95% 17.62% -1.41% 15.52% 1.05% -24.36% 107.65% 15.23% 17.62% 3.57% -14.13% 8.52% 9.84% 4.77% 8.99% <-IRR #YR-> 10 Cash Flow less WC 136.45%
5 year Running Average $217.13 $253.56 $306.91 $360.41 $423.31 $480.40 $482.30 $557.98 $661 $784 $914 $1,036 $1,088 $1,137 $1,162 5.52% <-IRR #YR-> 5 Cash Flow less WC 30.81%
CFPS Excl. WC $2.41 $3.26 $3.50 $3.16 $3.20 $3.08 $1.48 $3.04 $3.49 $4.10 $4.22 $3.46 $3.72 $4.09 $4.28 13.50% <-IRR #YR-> 10 CF less WC 5 Yr Run 254.63%
Increase -1.87% 35.18% 7.40% -9.73% 1.24% -3.78% -51.83% 104.78% 15.06% 17.30% 3.11% -18.02% 7.42% 9.84% 4.77% 14.30% <-IRR #YR-> 5 CF less WC 5 Yr Run 95.06%
5 year Running Average $2.55 $2.60 $2.80 $2.96 $3.10 $3.24 $2.88 $2.79 $2.86 $3.04 $3.27 $3.66 $3.80 $3.92 $3.95 0.61% <-IRR #YR-> 10 CFPS - Less WC 6.30%
P/CF on Med Price 12.89 11.35 12.84 12.14 9.85 10.11 13.93 5.63 4.60 5.65 6.31 6.73 8.44 8.82 0.00 4.15% <-IRR #YR-> 5 CFPS - Less WC 22.54%
P/CF on Closing Price 13.93 12.52 12.39 9.78 10.60 9.30 9.38 6.52 5.36 6.67 5.54 8.04 9.00 9.44 9.01 3.11% <-IRR #YR-> 10 CFPS 5 yr Running 35.87%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 8.26 5 yr  6.13 P/CF Med 10 yr 7.59 5 yr  6.31 24.40% Diff M/C 6.37% <-IRR #YR-> 5 CFPS 5 yr Running 36.15%
OPM 10.09% 17.93% 19.02% 22.86% 20.83% 21.33% -1.85% 11.20% 13.84% 6.98% 3.83% 8.63% 12.36% 8.54% -45.94% <-Total Growth 10 OPM
Increase -24.81% 77.69% 6.09% 20.15% -8.85% 2.37% -108.66% 706.61% 23.52% -49.55% -45.18% 125.42% 43.25% -30.87% should be zero, it is a check on calculations
Diff from Median -14.32% 52.25% 61.52% 94.06% 76.88% 81.08% -115.68% -4.90% 17.47% -40.74% -67.51% -26.77% 4.90% -27.48% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 11.78% 5 Yrs 8.63% Should increase or be stable.
$1,793 <-12 mths 1.35%
Normalized EBITDA $326 $509 $546 $582 $701 $797 $1,009 $1,271 $1,310 $1,490 $1,537 $1,575 $1,769 $1,846 $1,933 $2,079 223.99% <-Total Growth 10 Normalized EBITDA
Normalized EBITDA per share $3.43 $4.38 $4.31 $4.23 $4.46 $4.66 $4.53 $4.59 $4.69 $5.32 $5.47 $5.58 $5.96 $6.22 $6.51 $7.00 38.31% <-Total Growth 10 Normalized EBITDA per share
EBITDA per Share $3.09 $4.16 $4.31 $4.22 $4.46 $4.66 $4.53 $4.59 $4.69 $5.32 $5.47 $5.58 $5.96 $6.22 $6.51 $7.00 38.29% <-Total Growth 10 EBITDA per Share
Change 7.47% 34.45% 3.58% -2.09% 5.67% 4.52% -2.75% 1.26% 2.15% 13.54% 2.75% 2.07% 6.75% 4.35% 4.71% 7.55% 2.45% <-Median-> 10 Change
Price/EBITDA 10.85 9.80 10.06 7.32 7.60 6.14 3.07 4.31 3.99 5.13 4.27 4.98 5.62 6.20 5.92 5.50 5.06 <-Median-> 10 Price/EBITDA
Margin 22.48% 24.91% 22.69% 26.54% 32.01% 31.18% 23.70% 23.13% 23.45% 14.09% 10.91% 12.12% 14.21% 0.23 <-Median-> 10 Margin
EBIT $896 $1,068 $1,098 $1,134 $1,294 $1,346 $1,444 $1,540 EBIT Fr Mkt Sc
Change 19.20% 2.81% 3.28% 14.11% 4.02% 7.28% 6.65% Change
Covering Assets $4,243 $5,219 $5,672 $6,967 $7,074 $7,026 $13,876 $10,909 $11,577 $11,986 $12,484 $13,385 $15,402 $15,402 171.53% <-Total Growth 10 Covering Assets
change 61.13% 23.01% 8.69% 22.83% 1.53% -0.68% 97.49% -21.38% 6.13% 3.53% 4.15% 7.22% 15.07% 0.00% 5.14% <-Median-> 10 Change
Debt/Covering Assets 0.62 0.57 0.54 0.54 0.48 0.49 0.58 0.54 0.66 0.64 0.70 0.89 0.89 0.59 0.61 <-Median-> 10 Debt/Covering Assets Type
Long Term Debt $2,626.1 $2,952.7 $3,049.6 $3,732.4 $3,366.9 $3,436.5 $8,066.9 $5,927.8 $7,626 $7,684 $8,694 $8,270 $9,014 $9,014 195.58% <-Total Growth 10 Debt Lg Term R
Change 116.26% 12.44% 3.28% 22.39% -9.79% 2.07% 134.74% -26.52% 28.65% 0.76% 13.14% -4.88% 9.00% 0.00% 5.53% <-Median-> 10 Change Lg Term R+A
Debt/Market Cap Ratio 0.74 0.59 0.53 0.83 0.60 0.69 2.11 1.07 1.46 1.00 1.32 1.01 0.90 0.78 1.01 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 10.51 10.05 11.00 10.66 10.24 12.31 5.73 6.33 8.26 8.13 7.03 6.88 7.45 7.45 7.79 <-Median-> 10 Assets/Current Liab. Ratio Liquidity
Debt to Cash Flow (Years) 17.94 8.06 6.66 7.45 7.38 6.30 -102.63 9.63 9.87 10.41 16.13 7.38 5.86 7.41 7.41 <-Median-> 10 Debt to Cash Flow (Years) Liq. + CF
Liq. + CF + D
Intangibles $189.79 $195.26 $356.9 $735.1 $694.3 $588.8 $711.9 $585.6 $539 $171 $120 $122 $107 $107 -70.02% <-Total Growth 10 Intangibles Debt Ratio
Goodwill $714.90 $743.10 $785.1 $877.3 $856.0 $817.3 $4,068.2 $3,942.1 $5,039 $5,153 $5,250 $5,270 $5,691 $5,691 624.88% <-Total Growth 10 Goodwill Leverage
Total $904.69 $938.36 $1,142.0 $1,612.4 $1,550.3 $1,406.1 $4,780.1 $4,527.7 $5,578 $5,324 $5,370 $5,392 $5,798 $5,798 407.71% <-Total Growth 10 Total D/E Ratio
Change 3.72% 21.70% 41.19% -3.85% -9.30% 239.95% -5.28% 23.20% -4.55% 0.86% 0.41% 7.53% 0.00% 0.64% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.26 0.19 0.20 0.36 0.27 0.28 1.25 0.82 1.07 0.70 0.82 0.66 0.58 0.50 0.68 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $591.36 $618.41 $1,058.4 $1,037.8 $738.6 $701.9 $4,033.0 $2,196.2 $2,497 $2,624 $4,638 $3,045 $2,819 $2,819 166.35% <-Total Growth 10 Current Assets
Current Liabilities $562.65 $724.45 $765.1 $947.7 $996.1 $815.2 $4,102.0 $3,126.1 $2,607 $2,657 $3,407 $3,413 $3,500 $3,500 357.46% <-Total Growth 10 Current Liabilities
Liquidity Ratio 1.05 0.85 1.38 1.10 0.74 0.86 0.98 0.70 0.96 0.99 1.36 0.89 0.81 0.81 0.92 <-Median-> 10 Ratio
Liq. with CF NC aft div 1.05 1.11 1.69 1.34 0.86 1.08 0.86 0.81 1.15 1.15 1.43 1.12 1.14 1.05 1.15 <-Median-> 5 Liq. with CF NC aft div
Liq. CF re  Inv+Div  0.27 0.40 0.95 0.51 0.49 0.67 0.38 0.81 0.79 0.97 1.11 1.06 0.82 1.05 0.97 <-Median-> 5 Liq. CF re  Inv+Div 
Cur. Lg Term Debt $0.00 $209.07 $214.4 $387.5 $383.4 $188.9 $890.2 $922.9 $360 $511 $334 $999 $858 $858 $511.0 <-Median-> 5 Cur. Lg Term Debt
Liquidity Ratio 1.05 1.20 1.92 1.85 1.21 1.12 1.26 1.00 1.11 1.22 1.51 1.26 1.07 1.07 1.22 <-Median-> 5 Liquidity Ratio
Liq. with CF aft div 1.05 1.56 2.35 2.26 1.40 1.40 1.06 1.15 1.34 1.43 1.59 1.59 1.51 1.39 1.51 <-Median-> 5 Liq. with CF aft div
Assets $5,911.9 $7,281.3 $8,413.4 $10,099.5 $10,200.6 $10,032.2 $23,487.7 $19,794.5 $21,532 $21,593 $23,965 $23,471 $26,092 $26,092 Debt Ratio of 1.5 and up, best
Liabilities $3,912.1 $4,451.8 $4,839.2 $5,896.6 $5,585.2 $5,393.0 $15,847.5 $12,425.7 $13,871 $13,992 $16,347 $15,608 $17,046 $17,046 1.55 <-Median-> 10 Ratio
Debt Ratio 1.51 1.64 1.74 1.71 1.83 1.86 1.48 1.59 1.55 1.54 1.47 1.50 1.53 1.53 1.53 <-Median-> 5 Ratio
Estimates BVPS $26.68 $28.02 Estimates Estimates BVPS
Estimate Book Value $7,948.6 $8,347.9 Estimates Estimate Book Value
Change -12.13% 5.02%
P/B Ratio (Close) 1.44 1.38 Estimates P/B Ratio (Close)
Difference from 10 year median 49.05% Diff M/C Estimates Difference from 10 yr med.
Check on BV $1,565 $2,753 $3,183 $3,596
Total Book Value $2,000 $2,829 $3,574 $4,203 $4,615 $4,639 $7,640.2 $7,368.8 $7,661 $7,601 $7,618 $7,863 $9,046 $9,046 153.09% <-Total Growth 10 Total Book Value
Non-Cont. Int. $40 $38 $33 $35 $35 $66 $620.6 $153.9 $620 $652 $162 $150 $294 $294 Non-Cont. Int.
Net Book Value $1,960 $2,792 $3,541 $4,168 $4,581 $4,573 $7,019.6 $7,214.9 $7,041 $6,949 $7,456 $7,713 $8,752 $8,752 147.15% <-Total Growth 10 Book Value & Pref
Net Book Value per Share $18.60 $22.83 $26.44 $28.49 $27.44 $26.09 $25.51 $25.85 $25.19 $24.79 $26.48 $26.15 $29.38 $29.38 11.12% <-Total Growth 10 Book Value per Share
P/B Ratio (Median) 1.67 1.62 1.70 1.35 1.15 1.19 0.81 0.66 0.64 0.93 1.01 0.89 1.07 1.23 0.97 P/B Ratio 10 yr Med
Preferred Shares $395 $590 $788 $985.1 $985.1 $1,277.7 $1,318.8 $1,277.1 $1,077 $1,076 $586 $391 $391 $391 -50.41% <-Total Growth 10 Preferred Shares
Book Value $1,565 $2,202 $2,753 $3,183 $3,596 $3,296 $5,700.8 $5,937.8 $5,964 $5,873 $6,870 $7,322 $8,361 $8,361 $8,361 $8,361 203.74% <-Total Growth 10 Book Value
BV per share $14.86 $18.00 $20.55 $21.76 $21.54 $18.80 $20.71 $21.28 $21.34 $20.95 $24.40 $24.83 $28.06 $28.06 $28.06 $28.06 36.56% <-Total Growth 10 Book Value per Share
Change 14.01% 21.18% 14.14% 5.87% -1.00% -12.72% 10.16% 2.72% 0.29% -1.80% 16.45% 1.75% 13.03% 0.00% 0.00% 0.00% -11.62% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.09 2.05 2.19 1.76 1.46 1.65 1.00 0.80 0.75 1.10 1.09 0.94 1.12 1.28 0.00 0.00 1.55 P/B Ratio Historical Median
P/B Ratio (Close) 2.26 2.26 2.11 1.42 1.57 1.52 0.67 0.93 0.88 1.30 0.96 1.12 1.19 1.37 1.37 1.37 3.16% <-IRR #YR-> 10 Book Value 36.56%
Change -7.52% 0.22% -6.87% -32.66% 10.81% -3.28% -55.91% 38.53% -5.63% 48.56% -26.48% 16.95% 6.47% 15.14% 0.00% 0.00% 5.69% <-IRR #YR-> 5 Book Value 31.90%
Leverage (A/BK) 2.96 2.57 2.35 2.40 2.21 2.16 3.07 2.69 2.81 2.84 3.15 2.98 2.88 2.88 2.83 <-Median-> 10 A/BV
Debt/Equity Ratio 1.96 1.57 1.35 1.40 1.21 1.16 2.07 1.69 1.81 1.84 2.15 1.98 1.88 1.88 1.83 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.10 5 yr Med 1.09 25.13% Diff M/C
Comprehensive Income $116.65 $263.35 $261.9 $330.1 $185.0 -$106.1 -$73.8 $506.2 $377 $283 $1,204 $458 $1,368 422.34% <-Total Growth 10 Comprehensive Income
NCI $3.49 $7.33 $8.1 $8.6 $9.9 -$114.4 -$18.6 $6.8 $20 $20 $53 $16 $12 NCI
Shareholders $113.16 $256.02 $253.8 $321.5 $175.1 $8.3 -$55.2 $499.4 $357 $263 $1,151 $442 $1,356 434.28% <-Total Growth 10 Shareholders
Increase 31.84% 126.24% -0.87% 26.67% -45.54% -95.26% -765.06% 1004.71% -28.51% -26.33% 337.64% -61.60% 206.79% -26.33% <-Median-> 5 Comprehensive Income
5 Yr Running Average $115 $133 $157 $206 $224 $203 $141 $190 $197 $215 $443 $542 $714 18.24% <-IRR #YR-> 10 Comprehensive Income 434.28%
ROE 7.2% 11.6% 9.2% 10.1% 4.9% 0.3% -1.0% 8.4% 6.0% 4.5% 16.8% 6.0% 16.2% 22.11% <-IRR #YR-> 5 Comprehensive Income 171.53%
5Yr Median 7.6% 7.6% 7.6% 9.2% 9.2% 9.2% 4.9% 4.9% 4.9% 4.5% 6.0% 6.0% 6.0% 16.33% <-IRR #YR-> 10 5 Yr Running Average 354.01%
% Difference from NI 11.1% 41.1% 165.5% 3147.5% 12.7% -72.6% -89.0% -34.7% -26.5% 14.3% 188.5% -31.0% 134.6% 30.33% <-IRR #YR-> 5 5 Yr Running Average 276.04%
Median Values Diff 5, 10 yr -6.9% 14.3% 6.0% <-Median-> 5 Return on Equity
Current Liability Coverage Ratio 0.45 0.55 0.61 0.49 0.54 0.66 0.10 0.27 0.37 0.43 0.35 0.30 0.32 0.35   CFO / Current Liabilities
5 year Median 0.45 0.45 0.55 0.49 0.54 0.55 0.54 0.49 0.37 0.37 0.35 0.35 0.35 0.35 36.2% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 4.29% 5.47% 5.57% 4.57% 5.23% 5.38% 1.74% 4.28% 4.53% 5.32% 4.96% 4.35% 4.25% 4.66% CFO / Total Assets
5 year Median 7.07% 6.19% 5.57% 5.47% 5.23% 5.38% 5.23% 4.57% 4.53% 4.53% 4.53% 4.53% 4.53% 4.66% 4.6% <-Median-> 10 Return on Assets 
Return on Assets ROA 1.72% 2.49% 1.14% 0.10% 1.52% 0.30% -2.14% 3.86% 2.26% 1.07% 1.66% 2.73% 2.22% 2.59% Net  Income/Assets Return on Assets
5Yr Median 3.53% 2.49% 2.36% 1.72% 1.52% 1.14% 0.30% 0.30% 1.52% 1.07% 1.66% 2.26% 2.22% 2.22% 1.6% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 6.51% 8.24% 3.47% 0.31% 4.32% 0.92% -8.80% 12.88% 8.15% 3.92% 5.81% 8.75% 6.91% 8.09% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 9.56% 8.24% 7.19% 6.51% 4.32% 3.47% 0.92% 0.92% 4.32% 3.92% 5.81% 8.15% 6.91% 6.91% 5.1% <-Median-> 10 Return on Equity
$512.50 <-12 mths -11.33%
Net Income $120.26 $208.43 $138.2 $59.7 $213.4 $99.9 -$453.7 $840.3 $572 $340 $573 $689 $608 339.94% <-Total Growth 10 Net Income
NCI $3.49 $7.33 $8.1 $8.6 $9.9 $8.3 -$18.6 $6.8 $20 $57 $50 $16 $12 NCI
Preferred Shareholders $14.92 $19.63 $34.5 $41.2 $48.1 $61.3 $66.6 $68.5 $66 $53 $124 $32 $18 -47.83% <-Total Growth 10 Preferred Shareholders
Shareholders $101.85 $181.47 $95.6 $9.9 $155.4 $30.3 -$501.7 $765.0 $486 $230 $399 $641 $578 $676 $726 $813 504.60% <-Total Growth 10 Shareholders
Increase 21.83% 78.18% -47.32% -89.64% 1469.70% -80.50% -1755.78% 252.48% -36.47% -52.67% 73.48% 60.65% -9.83% 17.02% 7.30% 11.97% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $117.5 $121.1 $111.9 $94.5 $108.8 $94.5 -$42.1 $91.8 $187 $202 $276 $504 $467 $504.9 $604.0 $686.8 19.71% <-IRR #YR-> 10 Net Income 504.60%
Operating Cash Flow $146.4 $366.3 $457.7 $501.2 $456.2 $545.2 -$78.6 $615.5 $773 $738 $539 $1,121 $1,538 -5.45% <-IRR #YR-> 5 Net Income -24.44%
Investment Cash Flow -$1,624.5 -$1,264.8 -$591.1 -$1,515.6 -$752.2 -$499.3 -$5,834.4 $2,183.7 -$1,211 -$483 -$997 -$199 -$1,375 15.35% <-IRR #YR-> 10 5 Yr Running Ave. 316.98%
Total Accruals $1,580.0 $1,079.9 $229.0 $1,024.3 $451.4 -$15.6 $5,411.3 -$2,034.2 $924.0 -$25.0 $857.0 -$281.0 $415.0 38.44% <-IRR #YR-> 5 5 Yr Running Ave. 408.61%
Total Assets $5,911.9 $7,281.3 $8,413.4 $10,099.5 $10,200.6 $10,032.2 $23,487.7 $19,794.5 $21,532 $21,593 $23,965 $23,471 $26,092 Balance Sheet Assets
Accruals Ratio 26.72% 14.83% 2.72% 10.14% 4.43% -0.16% 23.04% -10.28% 4.29% -0.12% 3.58% -1.20% 1.59% 1.59% <-Median-> 5 Ratio
EPS/CF Ratio 0.44 0.47 0.21 0.02 0.31 0.06 -1.52 0.91 0.50 0.20 0.33 0.65 0.52 0.32 <-Median-> 10 EPS/CF Ratio
Change in Close 5.43% 21.45% 6.30% -28.70% 9.71% -15.58% -51.43% 42.30% -5.36% 45.89% -14.39% 18.99% 20.35% 15.14% 0.00% 0.00% Count 26 Years of data
up/down down down down down down up Count 14 53.85%
Meet Prediction? % right Count 1 7.14%
Financial Cash Flow $1,487.14 $930.82 $455.7 $929.6 $21.4 -$38.0 $5,987.0 -$2,873.7 $392 -$245 $435 -$882 -$175 C F Statement  Financial CF
Total Accruals $92.81 $149.08 -$226.7 $94.7 $430.0 $22.4 -$575.7 $839.5 $532 $220 $422 $601 $590 Accruals
Accruals Ratio 1.57% 2.05% -2.69% 0.94% 4.22% 0.22% -2.45% 4.24% 2.47% 1.02% 1.76% 2.56% 2.26% 2.26% <-Median-> 5 Ratio
Cash $11.83 $44.81 $371.0 $293.4 $19.0 $27.3 $201.1 $122.4 $74 $84 $64 $104 $92 $92 Cash
Cash per Share $0.11 $0.37 $2.77 $2.01 $0.11 $0.16 $0.73 $0.44 $0 $0 $0 $0 $0 $0.31 $0.30 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.33% 0.90% 6.39% 6.49% 0.34% 0.54% 5.26% 2.22% 1.41% 1.10% 0.97% 1.27% 0.92% 0.80% 1.10% <-Median-> 5 % of Stock Price
Taxable Income
Capital Gain
Dividend Income
Ret. Of Capital
Notes:
March 15, 2025.  Last estimates were for 2024, 2025, 2026 of $13659M, $14481M, $15144M Revenue, $3.97, $4.30 2024/5 AFFO, $2.15, 2.35, $2.61 AEPS, $2.14, $2.34 and $2.49 EPS, 
$1.19, $1.25, $1.29 Dividends, $495M, $771M, $733M FCF, $1734M, $1816M, $1906M EBITDA, $25.08, $27.10, $28.20 BVPS, $642M, $703M, $616M Net Income.
March 22, 2024.  Last estimates were for 2023, 2024 and 2025 of $13443M, $14143M and $5780M for Revenue, $3.97, $4.14 2023/ for AFFO, $1.94, $2.12 and 2.27 for AEPS, 1.94, $2.11 2023/4 for EPS,
 $1.12, $1.18 and $1.20 for Dividends, $7.89M, $716M and $788M for FCF, $4.10, $4.16 and $4.23 for CFPS, $25.20, $26.60 and $27.10 for BVPS, $563M and $616M 2022/4 for Net Income.
March 21, 2023.  Last estimates were for 2022, 2023 and $2024 of $8149M, $8492M and $11929M for Revenue, $3.54 and $4.02 for AFFO, $1.85, $1.97 and $2.28 for AEPS, $1.81, $1.97 and $2.31 for EPS, 
$1.06, $1.11 and $1.15 for Dividends, $695M, $7915M and $7915M for FCF, $3.89, $4.04 and $4.30 for CFPS, $22.60 and $23.50 for 2022/3 for BVPS, $554M, $602M and $692M for Net Income.
March 25, 2022.  Last estimates were for 2021, 2022 and 2023 of $5773M and $5928M for Revenue 2021-22, $3.43 and $3.89 for AFFO for 2021-22, $1.14 and $1.65 for Adj EPS for 2021-22, 
$1.57, $1.79 and $2.84 for EPS, $1.00, $1.03 and $1.04 for Dividends, $789M, $906M and $894M for FCF, $3.72, $3.94 and $4.25 fpr CFPS and $471M, $532M and $498M for Net Income.
March 21, 2021.  Last estimates were for 2020 and 2021 of $6545M and $6313M for Revenue, $3.00 and $3.36 for AFFO, and for 2020, 2021 and 2022 $1.23, $1.38 and $1.43 for normalized earnings, 
$1.25 $1.40 and $1.43 for EPS, $0.96, $0.98 and $0.98 for Dividends, $3.31, $3.47 and $3.50 for CFPS and $345M, $386M and $400M for Net Income.
March 19, 2020.  Last estimates were for 2019, 2020 and 2021 of $4417M, $4826M and $4712M for Revenue, $2.67 and $2.89 for 2019 and 2020 for AFFO, 
$0.97, $1.19 and $1.29 for Normalized EPS, $0.93, $1.14 and 1.14 for EPS, $0.99, $1.14 and $1.14 for Div, $3.01, $3.16 and 3.38 for CFPS and $268M, $249M and $394M for Net Income.
March 24, 2019.  Last estimates were for 2018, 2019 and 2020 with $3908M, $4806M and $4099M for Revenue, $3.17 for AFFO for 2018, $1.02 and 
$1.44 for 2018 and 2019 for Normalized Earnings, $0.89, $1.36 and $1.51 for EPS, $3.21, $3.94 and $4.13 for CFPS, $228M, $395M and $478M for Net Income.
March 18, 2018.  Last estimates were for 2017. 2018 smf 2019 pg %2700M, $3501M and $4533M for Revenue, $3.09 and $3.17 for AFFO for 2017 and 2018, 
$1.01, $0.99 and and $1.49 for Normalized EPS, $1.05, $0.90 and $1.97 for EPS, $3.07, $3.35 and $4.13 for CPFS and $209M, $238M and $615M for Net Income.
March 18, 2017.  Last estimates were for 216 and 2017 of $3134M and $3034M for Revenue, $3.77 and $4.04 for AFFO, $3.75 for 2016 for FFO, 
$1.87 for Normalized Earningfs fo 2016, $1.70 and $2.15 for EPS, $3.75 and $4.40 for CFPS and $214M and $290M for Net Income.
March 26, 2016.  Last estimates were for 2015, 2016 and 2017 of $2983M, $3134M and $3054M for Revenue, $3.66 and $3.96 and $1.69 and $1.87 for AFFO and Normalized EPS for 2015 and 2016,
 $1.63, $1.70 and $2.15 for EPS, $3.75, $4.10 and $4.40 for CFPS, and $225M, $247M and $290M for Net Income.
April 3, 2015.  Last estimates were for 2014 and 2015 of $3068M and $3340M for Revenue, $3.47 and $4.03 for AFFO, $1.72 and $2.26 for EPS, $4.00 and $4.63 for CFPS
March 21, 2014.  Last estimates were for 2013, 2014 and 2015 of $1746M, $2082M and $2657M for Revenue, $3.13 and $3.30 AFFO (2013, 2014), $1.49, 1.63 and $1.68 for EPS, and $3.55, 3.91 and $4.51 for CFPS. 
March 14 2013.  Last estimates were for 2012 and 2013 at $2025 and $2315M for Revenue, $2.80 and 3.50 for FFO, EPS $1.26 and $1.59 (and $1.81 for 2014) and $2.83 and $3.38 for CFPS
Dec 02, 2012 Restored from website file.
April 14, 2012.  Last estimates were for 2011 and 2012 with $2.20 and $2.45 for Distributable income, $1.00 and $1.15 for EPS and $2.46 and $2.70 for Cash Flow.
Apr 6, 2011.  Last I looked I got estimates for 2010 and 2011 for earnings of $1.50 and 1.10 and CF of $2.50 and 2.30 and distributable Inc of $2.68 for 2010.
July 8, 2010 company changed from a Unit Trust to a corporation.  Symbol changed from AltaGas Income Trust (ALA.UN) to AltaGa Ltd. (ALA).  Dividends to be reduced.
Feb 28, 2010.  In Nov 2009, I picked up 2009 and 2010 values for earnings of $1.60 and $1.50, Dis Inc of $2.60 and $2.68 and cash flow of $2.40 and $2.48.
Interesting that no one expects much increase in stock price this year, but there is an awful lot of insider buying. 
Nov 5, 2009 Earnings and cash flow pickup up at the time I updated for 2008 report have not changed.
AR 2008, I picked up earnings of $1.60 and $1.50 and cash flow of $240 and $2.48  for 2009 and 2010.
They changed to an income trust in 2004.  They plan to convert back to a corporate structure before 2011. In the third annual report, they said they expect the dividend to be from $1.10 to $1.40.
2007. In addition, a special distribution of one AltaGas Utility Group Inc. (Utility Group) common share was issued for every 100 Trust units and exchangeable units held on
August 27, 2007. Any Trust unitholder allocated fewer than 50 common shares of Utility Group received cash. The cash value of the distribution was determined to be $0.076 per unit.
2005.  In addition, one share of AltaGas Utility Group Inc. was issued for every 13.9592 trust
units and exchangeable units held on November 14, 2005 distribution of $0.5373 per unit
This company was formed on 1 April 1994 from the ashes of a deliberately dismantled company formed to coordinate Alberta gas exports to California.
Normalized Earnings.
Earnings are normalized for after-tax amounts related to transaction costs related to acquisitions, development costs related to energy export projects,
provisions on assets and on investments accounted for by the equity method, unrealized gain on risk management contracts, and loss on long-term investments.
Sector:
Infrastructure, Utility
What should this stock accomplish?
Would I buy this company and Why.
This is a dividend growth company and I would buy it again.
Why am I following this stock. 
I bought this stock in 2009 and therefore started to follow it.
Why I bought this stock.
When I bought this stock in 2009 it was on many dividend growth stock lists.  In 2009, I saw that this stock also had good growth in Revenues, Earnings, Dividends, and Stock Prices over the last 5 and 10 years.     
The stock had a fairly strong balance sheet.  I took a small position in this stock, and planned to wait and see how things go with this stock before buying more.  I bought more in 2010 and 2012.
Dividends
Dividends are going monthly in 2022.  Cycle 3 of March, June, September and December.
Dividends are monthly.  Dividends are declared one month for the middle of the following month.  For example, the dividend payable on November 15, 2013 was for shareholders of record of October 25, 2013.
The dividewnd had an ex-dividend date of October 23rd and was declared on October 10, 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 
For employees 
For community 
For investors 
How they make their money.
AltaGas Ltd owns and operates a diversified basket of energy infrastructure businesses. Business is conducted through given segments: Midstream, 
Utilities and Corporate/other. Revenue is derived from customers in both Canada and the United States, with Canadian customers contributing the most.   
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.
AltaGas Holding Limited Partnership No. 2
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 2017 Mar 18 2018 Mar 24 2019 Mar 19 2020 Mar 21 2021 Mar 25 2022 Mar 21 2023 Mar 21 2024 Mar 15 2025
Yu, Vernon Dai-Chung 0.091 0.03% 0.126 0.04% 38.08%
CEO - Shares - Amount $3.045 $4.841
Options - percentage 0.573 0.19% 0.583 0.20% 1.76%
Options - amount $19.176 $22.469
Crawford, Randall Loy 0.000 0.00% 0.019 0.01% 0.069 0.02% 0.069 0.02% 0.069 0.02%
CEO - Shares - Amount $0.000 $0.346 $1.871 $1.602 $1.906
Options - percentage 0.663 0.24% 2.180 0.78% 2.960 1.06% 3.143 1.12% 2.690 0.91%
Options - amount $13.114 $40.816 $80.847 $73.483 $74.848
Harbilas, D. James 0.047 0.02% 0.048 0.02% 0.049 0.02% 0.050 0.02% 0.052 0.02% 0.053 0.02% 2.55%
CFO - Shares - Amount $0.871 $1.310 $1.147 $1.395 $1.727 $2.039
Options - percentage 0.677 0.24% 0.863 0.31% 0.908 0.32% 0.897 0.30% 0.932 0.31% 0.423 0.14% -54.59%
Options - amount $12.675 $23.569 $21.225 $24.949 $31.191 $16.307
Bushfield, Corine Renae Knight 0.00% 0.000 0.00% 0.004 0.00% 0.007 0.00% 0.012 0.00% 0.015 0.01% 0.018 0.01% 0.022 0.01% 0.025 0.01% 16.46%
Officer - Shares - Amount $0.002 $0.001 $0.082 $0.140 $0.319 $0.348 $0.495 $0.726 $0.974
Options - percentage 0.04% 0.078 0.03% 0.254 0.09% 0.576 0.21% 0.688 0.25% 0.723 0.26% 0.660 0.22% 0.673 0.23% 0.246 0.08% -63.46%
Options - amount $2.003 $1.077 $5.020 $10.792 $18.798 $16.894 $18.354 $22.524 $9.476
Grant, Bertram 0.013 0.00% 0.013 0.00% 0.018 0.01% 38.19%
Officer - Shares - Amount $0.368 $0.443 $0.705
Options - percentage 0.659 0.22% 0.499 0.17% 0.221 0.07% -55.66%
Options - amount $18.321 $16.712 $8.532
Knoll, Phillip R. 0.023 0.01% 0.023 0.01% 0.023 0.01% 0.00%
Director - Shares - Amount $0.634 $0.763 $0.878
Options - percentage 0.059 0.02% 0.069 0.02% 0.073 0.02% 5.79%
Options - amount $1.629 $2.306 $2.809
Cornhill, David Wallace 0.91% 1.570 0.57% 1.585 0.57% 1.590 0.57% 1.590 0.57% 1.590 0.56% 1.615 0.55% 1.615 0.54% 1.615 0.54% Was Chair and CEO 0.00%
Director Shares - Amount $45.605 $21.823 $31.357 $29.770 $43.431 $37.181 $44.937 $54.066 $62.253 until 2017.
Options - percentage 0.56% 1.002 0.36% 1.045 0.37% 0.834 0.30% 0.600 0.21% 0.352 0.13% 0.105 0.04% 0.098 0.03% 0.108 0.04% 9.65%
Options - amount $28.054 $13.925 $20.666 $15.620 $16.375 $8.234 $2.921 $3.289 $4.153
Karkkainen, Pentti Olavi 0.014 0.01% 0.017 0.01% 0.017 0.01% 0.017 0.01% 0.017 0.01% 0.017 0.01% 0.00%
Chair  Shares - Amount $0.262 $0.464 $0.397 $0.473 $0.569 $0.655
Options - percentage 0.012 0.00% 0.024 0.01% 0.033 0.01% 0.044 0.01% 0.055 0.02% 0.063 0.02% 14.23%
Options - amount $0.220 $0.645 $0.761 $1.217 $1.846 $2.428
Increase in O/S Shares 0.20% 0.240 0.14% 0.057 0.02% 0.076 0.03% 0.088 0.03% 0.775 0.28% 1.263 0.45% 0.905 0.31% 3.021 1.01% Average 0.42%
due to SO 2011-13 $11.450 $6.872 $0.796 $1.507 $1.649 $21.158 $29.524 $25.191 $101.152
Book Value $9.300 $6.500 $1.300 $1.200 $1.000 $15.000 $28.000 $19.000 $60.000
Insider Buying -$0.216 $0.000 -$1.341 -$2.353 -$0.112 -$0.066 -$0.580 -$1.909 -$1.130
Insider Selling $1.878 $1.664 $0.478 $0.784 $0.000 $5.271 $7.288 $11.711 $42.371
Net Insider Selling $1.662 $1.664 -$0.863 -$1.569 -$0.112 $5.205 $6.708 $9.801 $41.241
% of Market Cap 0.03% 0.04% -0.02% -0.03% 0.00% 0.08% 0.08% 0.10% 0.36%
Directors 9 12 12 12 12 10 11 11
Women 22% 2 22% 3 25% 4 33% 4 33% 4 33% 4 40% 5 45% 4 36%
Minorities 0% 0 0% 0 0% 0 0% 1 8% 1 8% 1 10% 2 18% 2 18%
Institutions/Holdings 9.72% 7 13.60% 4 17.06% 20 29.46% 20 23.01% 20 23.35% 20 20.81% 20 21.26%
Total Shares Held 0.44% 1.088 0.62% 1.364 0.49% 81.562 29.23% 64.483 22.90% 65.757 22.30% 61.372 20.60% 63.350 21.26%
Increase/Decrease 0.61% 0.102 10.39% 0.041 3.09% 1.887 2.37% -0.761 -1.17% 1.698 2.65% -1.700 -2.70% -0.293 -0.46%
Starting No. of Shares Reuters 0.986 Reuters 1.324 Reuters 79.675 Top 20 MS 65.244 Top 20 MS 64.059 Top 20 MS 63.072 Top 20 MS 63.643 Top 20 MS
Institutions/Holdings 171 39.06% 262 39.57%
Amount $1,494.320 $2,070.590
Total Shares Held 31.95% 56.000 31.95% 59.000 33.66%
Amount $1,602.720 $1,688.580
Increase/Decrease 3.70% 16.000 40.00% 6.000 11.32%
Starting No. of Shares Morningstar 40.000 Morningstar 53.000 Morningstar
Copyright © 2008 Website of SPBrunner. All rights reserved.
My stock
22/05/09 -$4,806.99 $16.02 300
05/11/09 -$9,124.99 $18.25 500
08/06/10 -$9,064.99 $18.13 500
09/08/12 -$12,180.00
09/08/12 -$9,144.69 $30.46 700
28/02/25 $70,900.00 $22.16 2,000
3.42% XIRR $35.45 2,000
9.73%
6.31% 64.8%
% from $122,317.33 Total Value Gain
$0.00 Less Sale of Stock
  -$70,900.00 Less Stock Value
  -$558.00 2009 div redistributed
-$864.00 2010 div redistributed
65.29% $49,995.33 Dividends Paid 112.80%
$44,321.66 Cost of Stock
$0.00 Sale of Stock
34.71% $26,578.34 Capital Gains/Loss 59.97%
100.00% $76,573.67 Total Return 172.77%
Start Date 22-May-09 Shares 2,000
End date 28-Feb-25 Dividends pd per Share $25.00
Years 15.77 Div less cost $2.84
Cost $22.16
% paid by div 112.81%