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 <-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/26 <-Estimates
AltaGas Ltd TSX:  ALA OTC: ATGFF https://www.altagas.ca/ 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/31/28 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 $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 $5,171 380.35% <-Total Growth 10 Revenue from Utilites
Cost of Sales $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 $3,070 415.27% <-Total Growth 10 Cost of Sales
Change 122.54% 29.67% -8.56% -6.50% 9.51% 37.40% 33.35% 92.86% 5.43% 0.00% 31.46% -13.52% 18.81% 14.16% <-Median-> 10 Change
Ratio 0.41 0.45 0.54 0.55 0.45 0.34 0.35 0.68 0.29 0.20 0.30 0.28 0.34 0.34 <-Median-> 10 Ratio
Revenue from Midstream $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 $7,460 782.32% <-Total Growth 10 Revenue from Midstream
Cost of Sales $658.1 $789.6 $503.2 $496.1 $647.0 $976.4 $1,057.7 $994 $5,412 $5,412 $7,098 $6,586 $5,935 1079.45% <-Total Growth 10 Cost of Sales
Change 12.23% 19.98% -36.27% -1.41% 30.42% 50.91% 8.33% -6.02% 444.47% 0.00% 31.15% -7.21% -9.88% 4.16% <-Median-> 10 Change
Ratio 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.66 0.49 <-Median-> 10 Ratio
Cost of Sales $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 $9,018 716.18% <-Total Growth 10 Cost of Sales
Change 45.04% 17.37% -23.85% -7.96% 33.45% 80.92% 31.43% -1.52% 142.54% 44.50% -9.21% -9.01% -1.99% 14.96% <-Median-> 10 Change
Ratio 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.71 0.65 <-Median-> 10 Ratio
Operating and Admin 450.60 491.90 509.30 $572 $1,129 $1,299 $1,267 $1,476 $1,568 $1,579 $1,796 $1,873 280.77% <-Total Growth 10 Operating and Admin
Change 9.17% 3.54% 12.35% 97.31% 15.06% -2.46% 16.50% 6.23% 0.70% 13.74% 4.29% 9.29% <-Median-> 10 Change
Ratio 0.22 0.23 0.22 0.27 0.24 0.23 0.14 0.11 0.12 0.14 0.15 0.19 <-Median-> 10 Ratio
Total $1,902 $1,597 $1,526 $1,929 $3,584 $4,526 $4,445 $9,184 $12,706 $11,691 $10,997 $10,891 582.05% <-Total Growth 10 Total
Change -16.02% -4.42% 26.41% 85.78% 26.28% -1.79% 106.61% 38.35% -7.99% -5.94% -0.96% 12.66% <-Median-> 10 Change
Ratio 0.73 0.70 0.75 0.84 0.82 0.80 0.87 0.90 0.90 0.88 0.86 0.85 <-Median-> 10 Ratio
$12,618 <-12 mths -0.68%
Revenue* $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 $12,705 $14,234 $15,077 $16,784 479.40% <-Total Growth 10 Revenue
Increase 40.87% 17.77% -8.86% -0.14% 16.74% 66.52% 29.09% 1.67% 89.24% 33.24% -7.74% -4.22% 2.06% 12.03% 5.92% 11.32% 19.21% <-IRR #YR-> 10 Revenue 479.40%
5 year Running Average $1,535.9 $1,763.4 $1,931.1 $2,056.3 $2,277.5 $2,720.3 $3,338.1 $4,017 $5,694 $8,000 $9,748 $11,138 $12,562 $13,294 $13,492 $14,250 17.86% <-IRR #YR-> 5 Revenue 127.40%
Revenue per Share $16.70 $17.96 $14.99 $13.12 $14.58 $15.47 $19.69 $19.99 $37.72 $50.04 $44.07 $41.78 $40.83 $45.74 $48.45 $53.94 20.59% <-IRR #YR-> 10 5 yr Running Average 550.50%
Increase 21.33% 7.54% -16.55% -12.48% 11.16% 6.05% 27.31% 1.52% 88.72% 32.64% -11.92% -5.20% -2.28% 12.03% 5.92% 11.32% 25.61% <-IRR #YR-> 5 5 yr Running Average 212.73%
5 year Running Average $16.04 $16.47 $16.19 $15.31 $15.47 $15.22 $15.57 $16.57 $21.49 $28.58 $34.30 $38.72 $42.89 $44.49 $44.18 $46.15 10.54% <-IRR #YR-> 10 Revenue per Share 172.37%
P/S (Price/Sales) Med 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.95 0.97 0.00 0.00 15.35% <-IRR #YR-> 5 Revenue per Share 104.25%
P/S (Price/Sales) Close 2.44 2.41 2.06 2.58 1.96 0.90 1.00 0.94 0.72 0.47 0.63 0.80 1.03 1.07 1.01 0.91 10.23% <-IRR #YR-> 10 5 yr Running Average 164.92%
P/S 10 Year Median  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.84 0.84 0.78 0.68 20.95% <-IRR #YR-> 5 5 yr Running Average 158.84%
*Revenue in M CDN $  P/S Med 20 yr  1.08 15 yr  1.34 10 yr  0.84 5 yr  0.61 28.58% Diff M/C
$4.02 <-12 mths 9.24% Estimates Last 12 months from Qtr
AFFO* Amount $347 $405 $409 $465 $629 $626 $835 $877 $1,050 $1,020 $1,038 $1,054 $1,222 $1,286 $1,437 198.80% <-Total Growth 10 AFFO
AFFO* per Share $2.99 $3.20 $2.97 $2.96 $3.68 $2.81 $3.01 $3.14 $3.75 $3.63 $3.68 $3.55 $4.06 $4.12 $4.57 36.70% <-Total Growth 10 AFFO
Increase 21.54% 7.02% -7.19% -0.34% 24.32% -23.58% 7.03% 4.32% 19.43% -3.20% 1.38% -3.53% 14.37% 1.48% 10.92% 10 0 10 Years of Data, EPS P or N 100.00%
AFFO Yield 7.33% 7.38% 9.61% 8.73% 12.86% 20.23% 15.22% 16.77% 13.73% 15.53% 13.23% 10.60% 9.70% 8.38% 9.30% 3.18% <-IRR #YR-> 10 AFFO 36.70%
5 year Running Average $2.80 $2.92 $3.16 $3.12 $3.09 $3.12 $3.28 $3.27 $3.44 $3.55 $3.73 $3.81 $4.00 5.27% <-IRR #YR-> 5 AFFO 29.30%
Payout Ratio AFFO 49.83% 52.19% 62.88% 68.24% 57.27% 77.87% 31.89% 30.57% 26.66% 29.20% 30.43% 33.52% 31.03% 32.43% 29.23% 2.92% <-IRR #YR-> 10 5 yr Running Average 33.36%
5 year Running Average 55.34% 57.87% 57.94% 63.08% 59.26% 52.80% 44.54% 38.26% 30.12% 30.50% 30.60% 31.33% 31.24% 3.66% <-IRR #YR-> 5 5 yr Running Average 19.66%
Price/AFFO Median 12.37 14.04 12.91 10.65 8.45 7.34 5.67 5.12 6.17 7.34 6.33 8.85 9.54 10.80 0.00 7.34 <-Median-> 10 P/AFFO Med
Price/AFFO High 13.64 16.53 15.94 11.82 9.48 10.40 6.88 7.19 7.27 8.53 6.83 10.06 10.83 11.78 0.00 9.01 <-Median-> 10 P/AFFO High
Price/AFFO Low 11.10 11.55 9.88 9.47 7.43 4.28 4.47 3.05 5.06 6.15 5.83 7.63 8.25 9.81 0.00 5.99 <-Median-> 10 P/AFFO Low
Price/AFFO Close 13.64 13.54 10.40 11.45 7.78 4.94 6.57 5.96 7.28 6.44 7.56 9.43 10.31 11.93 10.76 7.42 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 16.57 14.49 9.66 11.41 9.67 3.78 7.03 6.22 8.70 6.23 7.66 9.10 11.79 12.11 11.93 8.18 <-Median-> 10 Trailing P/AFFO Close
Median Values Historical   in order 8.85 10.40 7.63 9.43 P/CF 5 Yrs   in order 7.34 8.53 6.15 7.56 62.56% Diff M/C 62.53% Diff M/C 10 DPR 75% to 95% best
Normalized Funds from Op $1,003 $1,198 $1,204 $1,128 $1,192 $1,331 Normalized Funds from Op
Distributional. Inccome $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.42 $4.42 <-12 mths 29.62% <-Total Growth 10 FFO
Increase 17.23% 7.20% -8.33% 3.23% 2.27% -18.06% 9.49% 11.15% 19.22% 0.11% -6.64% 0.25% 10.22% 0.00% <-12 mths 10 0 10 Years of Data, EPS P or N 100.00%
FFO Yield 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.56% 8.99% <-12 mths 2.63% <-IRR #YR-> 10 FFO 29.62%
5 year Running Average $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.20 $4.23 <-12 mths 4.25% <-IRR #YR-> 5 FFO 23.12%
Payout Ratio 42.94% 44.89% 54.77% 57.39% 58.54% 74.24% 29.72% 26.74% 23.35% 24.74% 28.00% 29.68% 28.51% 30.23% <-12 mths 2.59% <-IRR #YR-> 10 5 yr Running Average 29.20%
5 year Running Average 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.21% 28.23% <-12 mths 4.45% <-IRR #YR-> 5 5 yr Running Average 24.30%
Price/FFO Median 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.76 10.06 <-12 mths 6.61 <-Median-> 10 P/FFO Med
Price/FFO High 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.94 10.98 <-12 mths 8.07 <-Median-> 10 P/FFO High
Price/FFO Low 9.56 9.94 8.60 7.97 7.59 4.08 4.16 2.67 4.44 5.21 5.36 6.76 7.57 9.14 <-12 mths 5.28 <-Median-> 10 P/FFO Low
Price/FFO Close 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.47 11.12 <-12 mths 6.67 <-Median-> 10 P/FFO Close
Trailing P/FFO Close 13.77 12.49 8.31 9.94 8.13 3.86 6.71 5.80 7.61 5.46 6.49 8.37 10.44 11.12 <-12 mths 7.16 <-Median-> 10 Trailing P/FFO Close
Median Values Historical   in order 7.83 9.31 6.76 7.95 P/CF 5 Yrs   in order 6.22 7.23 5.36 6.96 78.85% Diff M/C 78.85% Diff M/C 10 DPR 75% to 95% best
* Normalized Funds From Operations
Last 12 months from Qtr $2.31 <-12 mths 4.05% Estimates Last 12 months from Qtr
Normalized Net Income AEPS $176 $165 $140 $153 $204 $195 $324 $396 $497 $530 $536 $648 $670 378.57% <-Total Growth 10 Normalized Earnings
Return on Equity ROE 7.99% 5.99% 4.40% 4.26% 6.19% 3.42% 5.46% 6.64% 8.46% 7.71% 7.32% 7.75% 7.68% 6.98% <-Median-> 10 Return on Equity ROE
5Yr Median 7.87% 7.76% 7.03% 5.99% 5.99% 4.40% 4.40% 5.46% 6.19% 6.64% 7.32% 7.71% 7.71% 6.09% <-Median-> 10 5Yr Median
Normalized Earnings Basic $1.51 $1.30 $1.02 $0.98 $1.19 $0.88 $1.17 $1.42 $1.78 $1.89 $1.90 $2.18 $2.23 118.63% <-Total Growth 10 AEPS
Normalized Earnings Diluted $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.22 $2.33 $2.68 $2.97 120.10% <-Total Growth 10 AEPS
Increase 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.30% 4.95% 15.02% 10.82% 10 0 10 Years of Data, EPS P or N 100.00%
NEPSYield 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.30% 4.74% 5.45% 6.04% 8.21% <-IRR #YR-> 10 AEPS 120.10%
5 year Running Average $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.98 $2.10 $2.26 $2.47 9.41% <-IRR #YR-> 5 AEPS 56.80%
Payout Ratio 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.76% 57.34% 49.85% 44.98% 5.21% <-IRR #YR-> 10 5 yr Running Average 66.22%
5 year Running Average 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.62% 56.92% 55.29% 52.21% 12.02% <-IRR #YR-> 5 5 yr Running Average 76.39%
Price/NEPS Median 25.11 35.02 38.01 32.46 26.12 23.58 14.62 11.35 13.11 14.24 12.33 14.47 17.44 19.09 0.00 0.00 14.55 <-Median-> 10 P/NEPS Med
Price/NEPS High 27.68 41.23 46.93 36.03 29.30 33.41 17.73 15.94 15.45 16.56 13.31 16.45 19.80 20.84 0.00 0.00 17.15 <-Median-> 10 P/NEPS High
Price/NEPS Low 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.08 17.34 0.00 0.00 12.21 <-Median-> 10 P/NEPS Low
Price/NEPS Close 27.68 33.78 30.64 34.92 24.03 15.87 16.94 13.22 15.48 12.50 14.72 15.43 18.85 21.10 18.34 16.55 15.68 <-Median-> 10 P/NEPS Close
Trailing P/NEPS Close 35.70 29.43 24.08 33.61 29.48 11.67 22.59 16.03 19.29 13.25 14.87 17.71 19.29 22.14 21.10 18.34 18.50 <-Median-> 10 Trailing P/NEPS Close
Median Values Historical   in order 14.47 16.57 12.49 15.87 P/CF 5 Yrs   in order 14.24 16.45 11.93 15.43 48.14% Diff M/C 55.48% Diff M/C 10 DPR 75% to 95% best
* Normalized Net Income
$2.59 <-12 mths 4.44% Estimates Last 12 months from Qtr
Difference Basic and Diluted 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% 0.00% <-Median-> 10 Difference Basic and Diluted
EPS Basic $1.56 $0.75 $0.07 $0.99 $0.18 -$2.25 $2.78 $1.74 $0.82 $1.42 $2.27 $1.95 $2.48 3442.86% <-Total Growth 10 EPS Basic
EPS Diluted* $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.48 $2.38 $2.65 $2.97 3442.86% <-Total Growth 10 EPS Diluted
Increase 43.40% -51.32% -90.54% 1314.29% -81.82% -1350.00% -223.11% -37.18% -52.87% 71.95% 60.28% -14.16% 27.84% -3.95% 11.04% 12.29% 9 1 10 Years of Data, EPS P or N 90.00%
Earnings Yield 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.9% 4.8% 5.4% 6.0% 42.87% <-IRR #YR-> 10 Earnings per Share 3442.86%
5 year Running Average $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.78 $2.09 $2.34 $2.48 7.34% <-IRR #YR-> 5 Earnings per Share 42.53%
10 year Running Average $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.23 $1.37 $1.62 $2.14 7.41% <-IRR #YR-> 10 5 yr Running Average 104.36%
* Diluted ESP per share  E/P 10 Yrs 5.86% 5Yrs 5.93% 21.04% <-IRR #YR-> 5 5 yr Running Average 159.77%
Dividend estimates $1.33 $1.40 $1.45 Estimates Dividend estimates
Increase 5.79% 4.88% 3.58% Estimates Increase
Payout Ratio EPS 55.96% 52.85% 48.75% Estimates Payout Ratio EPS
Special Dividends $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 $0.00 <-Median-> 10 Special Dividends
Dividend* $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.3360 $1.3360 $1.3360 -32.53% <-Total Growth 10 Dividends
Increase 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% 6.03% 0.00% 0.00% 19 3 24 Years of data, Count P, N 79.17%
Average Increases 5 Year Running -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% 5.97% 4.76% 3.63% -0.58% <-Median-> 10 Average Incr 5 Year Running
5 Year Running Average $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.19 $1.25 $1.29 -26.26% <-Total Growth 10 5 Year Running Average
Yield H/L Price 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.25% 3.00% 5.21% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 3.65% 3.16% 3.94% 5.77% 6.04% 7.49% 4.64% 4.25% 3.67% 3.42% 4.45% 3.33% 2.87% 2.75% 4.35% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 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% 3.31% 6.20% <-Median-> 10 Yield on Low Price AEPS
Yield on Close Price 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.01% 2.72% 2.72% 2.72% 4.69% <-Median-> 10 Yield on Close Price CFPS
Payout Ratio EPS 98.03% 225.68% 2667.86% 204.04% 1170.83% -97.33% 34.66% 55.17% 132.06% 75.18% 49.56% 61.34% 50.81% 56.09% 50.51% 44.98% 58.26% <-Median-> 10 Payout Ratio EPS FCF 
DPR EPS 5 Yr Running 123.12% 137.77% 177.69% 192.64% 261.57% -3650.00% 519.60% 240.16% 223.94% 139.26% 57.59% 66.25% 64.12% 56.97% 53.32% 52.01% 165.95% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 49.74% 48.87% 54.51% 73.90% 67.76% -766.85% 43.53% 34.71% 41.13% 55.37% 29.46% 23.05% 31.75% 29.66% 28.22% 26.99% 37.92% <-Median-> 10 Payout Ratio CFPS
DPR CF 5 Yr Running 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.68% 30.83% 28.15% 27.69% 64.08% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 45.74% 47.73% 59.13% 63.17% 68.50% 147.77% 31.63% 27.49% 26.44% 25.10% 32.35% 32.00% 31.02% 29.66% 28.22% 26.99% 31.81% <-Median-> 10 Payout Ratio CFPS WC
DPR CF WC 5 Yr Running 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.20% 29.87% 30.47% 29.39% 51.22% <-Median-> 10 DPR CF WC 5 Yr Running
Median 5 Yrs 10 Yr Med 10 Yr Cl 5.21% 4.69% 5 Yr Med 5 Yr Cl 3.98% 3.66% 5 Yr Med Payout 61.34% 31.75% 31.02% 5.59% <-IRR #YR-> 5 Dividends 31.25%
* Dividends per share  10 Yr Med and Cur. -47.88% -42.10% 5 Yr Med and Cur. -31.69% -25.75% Last Div Inc ---> $0.3150 $0.3340 6.03% -3.86% <-IRR #YR-> 10 Dividends -32.53%
Dividends Growth 15 -1.86% <-IRR #YR-> 15 Dividends -24.55%
Dividends Growth 20 -1.88% <-IRR #YR-> 20 Dividends
Dividends Growth 25 9.27% <-IRR #YR-> 24 Dividends
Historical Dividends Historical High Div 16.27% Low Div 2.22% 10 Yr High 17.36% 10 Yr Low 2.91% Med Div 4.96% Close Div 4.85% Historical Dividends
High/Ave/Median Values Curr diff Exp. -83.30%     22.42% Exp. -84.35% -6.61% Exp. -45.21% Exp. -44.00% High/Ave/Median 
Future Dividend Yield Div Yd 3.57% earning in 5 Years at IRR of 5.59% Div Inc. 31.25% Future Dividend Yield
Future Dividend Yield Div Yd 4.68% earning in 10 Years at IRR of 5.59% Div Inc. 72.27% Future Dividend Yield
Future Dividend Yield Div Yd 6.14% earning in 15 Years at IRR of 5.59% Div Inc. 126.10% Future Dividend Yield
Future Dividend Paid Div Paid $1.75 earning in 5 Years at IRR of 5.59% Div Inc. 31.25% Future Dividend Paid
Future Dividend Paid Div Paid $2.30 earning in 10 Years at IRR of 5.59% Div Inc. 72.27% Future Dividend Paid
Future Dividend Paid Div Paid $3.02 earning in 15 Years at IRR of 5.59% Div Inc. 126.10% Future Dividend Paid
Dividend Covering Cost Total Div $7.47 over 5 Years at IRR of 5.59% Div Cov. 15.19% Dividend Covering Cost
Dividend Covering Cost Total Div $15.52 over 10 Years at IRR of 5.59% Div Cov. 31.57% Dividend Covering Cost
Dividend Covering Cost Total Div $26.09 over 15 Years at IRR of 5.59% Div Cov. 53.06% Dividend Covering Cost
I am earning GC Div Gr -38.15% 5/22/09 # yrs -> 16 2009 $16.02 Cap Gain 206.87% I am earning GC
I am earning Div org yield 13.48% 12/31/26 Trading Div G Yrly -2.69% Div start $2.16 -13.48% 8.34% I am earning Div
I am earning GC Div Gr 1.21% 6/8/10 # yrs -> 15 2010 $18.13 Cap Gain 171.15% I am earning GC
I am earning Div org yield 7.28% 12/31/26 Pension Div G Yrly 0.07% Div start $1.32 -7.28% 7.37% I am earning Div
I am earning GC Div Gr -3.19% 8/9/12 # yrs -> 13 2012 $30.48 Cap Gain 61.29% I am earning GC
I am earning Div org yield 4.53% 12/31/26 RRSP Div G Yrly -0.22% Div start $1.38 -4.53% 4.38% I am earning Div
Yield if held 5 years 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.78% 5.01% 5.74% 5.67% <-Median-> 10 Paid Median Price
Yield if held 10 years 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.24% 4.29% 6.47% 4.35% <-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.98% 4.30% 3.61% 5.99% <-Median-> 10 Paid Median Price
Yield if held 20 years 11.96% 17.14% 15.75% 10.14% 8.99% 6.18% 4.70% 5.07% 5.06% 6.52% 10.14% <-Median-> 7 Paid Median Price
Yield if held 25 years 14.83% 22.50% 21.06% 12.78% 10.72% 18.66% <-Median-> 2 Paid Median Price
Cost covered if held 5 years 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.80% 23.43% 27.72% 25.88% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 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% 42.10% 40.16% 56.37% 63.21% <-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.94% 69.69% 58.14% 126.34% <-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% 118.06% 115.09% 144.08% 306.08% <-Median-> 7 Paid Median Price
Cost covered if held 25 years 432.84% 642.77% 585.99% 365.78% 314.53% 537.80% <-Median-> 2 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $5,587 $10,573 $14,087 $12,997 $12,448 $12,705 $12,618 <-12 mths -0.68% 127.40% <-Total Growth 5 Revenue Growth  127.40%
AEPS Growth $1.42 $1.76 $1.87 $1.89 $2.17 $2.22 $2.31 <-12 mths 4.05% 56.80% <-Total Growth 5 AEPS Growth 56.80%
Net Income Growth $486 $230 $399 $641 $578 $747 $731 <-12 mths -2.21% 53.70% <-Total Growth 5 Net Income Growth 53.70%
Cash Flow Growth $773 $738 $539 $1,121 $1,538 $1,235 59.77% <-Total Growth 5 Cash Flow Growth 59.77%
Dividend Growth $0.96 $1.00 $1.06 $1.12 $1.19 $1.26 $1.34 <-12 mths 6.03% 31.25% <-Total Growth 5 Dividend Growth 31.25%
Stock Price Growth $18.72 $27.31 $23.38 $27.82 $33.48 $41.85 $49.16 <-12 mths 17.47% 123.56% <-Total Growth 5 Stock Price Growth 123.56%
Revenue Growth  $2,193 $2,190 $2,556 $4,257 $5,495 $5,587 $10,573 $14,087 $12,997 $12,448 $12,705 $14,234 <-this year 12.03% 479.40% <-Total Growth 10 Revenue Growth  479.40%
AEPS Growth $1.01 $0.97 $1.19 $0.88 $1.17 $1.42 $1.76 $1.87 $1.89 $2.17 $2.22 $2.33 <-this year 4.95% 120.10% <-Total Growth 10 AEPS Growth 120.10%
Net Income Growth $10 $155 $30 -$502 $765 $486 $230 $399 $641 $578 $747 $748 <-this year 0.16% 7445.45% <-Total Growth 10 Net Income Growth 7445.45%
Cash Flow Growth $501 $456 $545 -$79 $616 $773 $738 $539 $1,121 $1,538 $1,235 $1,402 <-this year 13.51% 146.41% <-Total Growth 10 Cash Flow Growth 146.41%
Dividend Growth $1.87 $2.02 $2.11 $2.19 $0.96 $0.96 $1.00 $1.06 $1.12 $1.19 $1.26 $1.33 <-this year 5.79% -32.53% <-Total Growth 10 Dividend Growth -32.53%
Stock Price Growth $30.90 $33.90 $28.62 $13.90 $19.78 $18.72 $27.31 $23.38 $27.82 $33.48 $41.85 $49.16 <-this year 17.47% 35.44% <-Total Growth 10 Stock Price Growth 35.44%
Dividends on Shares $66.66 $69.55 $72.27 $31.68 $31.68 $35.74 $34.98 $36.96 $39.27 $41.58 $44.09 $44.09 $44.09 $460.36 No of Years 10 Total Divs 12/31/15
Paid  $1,019.70 $1,118.70 $944.46 $458.70 $652.74 $617.76 $901.23 $771.54 $918.06 $1,104.84 $1,381.05 $1,622.28 $1,622.28 $1,622.28 $1,381.05 No of Years 10 Worth $30.90
$1,841.41
Dividends on Shares $58.48 $57.24 $60.48 $64.26 $68.04 $72.14 $72.14 $72.14 $308.50 No of Years 5 Total Divs 12/31/20
Paid  $1,010.88 $1,474.74 $1,262.52 $1,502.28 $1,807.92 $2,259.90 $2,654.64 $2,654.64 $2,654.64 $2,259.90 No of Years 5 Worth $18.72
$2,568.40
Graham Price AEPS $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.41 $38.33 $41.11 $43.27 68.36% <-Total Growth 10 Graham Price AEPS
Price/GP Ratio Med 1.51 1.84 1.73 1.45 1.39 1.02 0.72 0.62 0.80 0.83 0.72 0.85 1.03 1.16 0.84 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 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.17 1.27 0.97 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 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 1.05 0.68 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 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.12 1.28 1.20 1.14 0.88 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 66.92% 77.93% 39.05% 56.28% 27.51% -31.19% -16.35% -28.20% -5.31% -27.05% -14.38% -9.55% 11.86% 28.26% 19.59% 13.60% -11.97% <-Median-> 10 Prem/Disc Close
Graham Price EPS $24.81 $18.50 $5.85 $21.91 $8.73 $9.16 $36.42 $28.90 $19.66 $27.82 $35.53 $35.00 $39.54 $38.75 $40.84 $43.27 575.48% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 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.98 1.15 0.97 <-Median-> 10 Price/GP Ratio Med 0.96
Price/GP Ratio High 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.11 1.25 1.11 <-Median-> 10 Price/GP Ratio High 1.11
Price/GP Ratio Low 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.85 1.04 0.82 <-Median-> 10 Price/GP Ratio Low 0.80
Price/GP Ratio Close 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.06 1.27 1.20 1.14 1.01 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 64.30% 134.29% 427.84% 54.76% 227.97% 51.76% -45.68% -35.23% 38.89% -15.97% -21.70% -4.34% 5.83% 26.85% 20.38% 13.60% 0.75% <-Median-> 10 Prem/Disc Close
Price Close $40.77 $43.34 $30.90 $33.90 $28.62 $13.90 $19.78 $18.72 $27.31 $23.38 $27.82 $33.48 $41.85 $49.16 $49.16 $49.16 35.44% <-Total Growth 10 Stock Price
Increase 21.45% 6.30% -28.70% 9.71% -15.58% -51.43% 42.30% -5.36% 45.89% -14.39% 18.99% 20.35% 25.00% 17.47% 0.00% 0.00% 32.89 <-Median-> 10 CAPE (10 Yr P/E)
P/E 26.82 58.57 441.43 34.24 159.00 -6.18 7.14 10.76 33.30 16.58 12.31 17.26 16.88 20.64 18.59 16.55 17.46% <-IRR #YR-> 5 Stock Price 123.56%
Trailing P/E 38.46 28.51 41.76 484.29 28.91 77.22 -8.79 6.76 15.70 28.51 19.73 14.81 21.57 19.82 20.64 18.59 3.08% <-IRR #YR-> 10 Stock Price 35.44%
CAPE (10 Yr P/E) 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.78 20.68 18.80 15.87 21.98% <-IRR #YR-> 5 Price & Dividend 159.20%
Median 10, 5 Yrs D.  per yr 4.19% 4.52% % Tot Ret 57.61% 20.57% T P/E 20.65 19.73 P/E:  16.73 16.88 23.37% Diff M/C 7.27% <-IRR #YR-> 10 Price & Dividend 86.63%
Price 15 D.  per yr 5.41% % Tot Ret 54.73% CAPE Diff -37.25% 4.48% <-IRR #YR-> 15 Stock Price 92.86%
Price  20 D.  per yr 5.18% % Tot Ret 71.76% 2.04% <-IRR #YR-> 20 Stock Price 49.73%
Price  25 D.  per yr 13.30% % Tot Ret 60.57% 8.66% <-IRR #YR-> 25 Stock Price
Price  30 D.  per yr 10.24% % Tot Ret 56.91% 7.76% <-IRR #YR-> 26 Stock Price
Price & Dividend 15 9.89% <-IRR #YR-> 15 Price & Dividend 200.54%
Price & Dividend 20 7.22% <-IRR #YR-> 20 Price & Dividend 171.38%
Price & Dividend 25 21.96% <-IRR #YR-> 25 Price & Dividend
Price & Dividend 30 18.00% <-IRR #YR-> 26 Price & Dividend
Price H/L Median $36.98 $44.93 $38.34 $31.51 $31.11 $20.65 $17.08 $16.08 $23.13 $26.65 $23.30 $31.40 $38.72 $44.48 0.99% <-Total Growth 10 Stock Price
Increase 19.02% 21.51% -14.68% -17.80% -1.27% -33.62% -17.29% -5.88% 43.86% 15.22% -12.57% 34.79% 23.30% 14.89% 0.10% <-IRR #YR-> 10 Stock Price 0.99%
P/E 24.33 60.72 547.64 31.83 172.83 -9.18 6.17 9.24 28.20 18.90 10.31 16.19 15.61 18.67 19.22% <-IRR #YR-> 5 Stock Price 140.84%
Trailing P/E 34.88 29.56 51.80 450.14 31.42 114.72 -7.59 5.80 13.29 32.49 16.52 13.89 19.96 17.94 3.81% <-IRR #YR-> 10 Price & Dividend 42.25%
P/E on Running 5 yr Average 28.31 40.99 43.96 35.97 44.44 -382.41 48.52 23.43 35.47 29.67 12.94 19.22 21.73 21.24 24.36% <-IRR #YR-> 5 Price & Dividend 182.35%
P/E on Running 10 yr Average 23.37 29.46 28.08 25.05 28.62 32.99 23.59 20.64 30.27 33.35 26.68 31.62 31.37 32.39 15.61 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 3.72% 5.14% % Tot Ret 97.41% 21.11% T P/E 18.24 16.52 P/E:  15.90 16.19 Count 26 Years of data
High Months Dec Aug Feb Oct Jan Jan Jul Jul Dec Apr Feb Oct Nov Mar
Price High $40.77 $52.90 $47.34 $34.98 $34.89 $29.25 $20.71 $22.57 $27.26 $30.98 $25.15 $35.70 $43.95 $48.55 -7.16% <-Total Growth 10 Stock Price
Increase 19.11% 29.75% -10.51% -26.11% -0.26% -16.17% -29.20% 8.98% 20.78% 13.65% -18.82% 41.95% 23.11% 10.47% -0.74% <-IRR #YR-> 10 Stock Price -7.16%
P/E 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.72 20.38 14.26% <-IRR #YR-> 5 Stock Price 94.73%
Trailing P/E 38.46 34.80 63.97 499.71 35.24 162.50 -9.20 8.15 15.67 37.78 17.84 15.80 22.65 19.58 18.40 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 20.25 17.84 P/E:  18.06 18.40 33.18 P/E Ratio Historical High
Low Months Jan Dec Dec Jan Aug Dec Jan Mar Jan Nov Mar Feb Jan Jan
Price Low $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 $40.41 14.15% <-Total Growth 10 Stock Price
Increase 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% 20.70% 1.33% <-IRR #YR-> 10 Stock Price 14.15%
P/E 21.83 49.95 419.00 28.32 151.83 -5.36 4.86 5.51 23.16 15.82 9.49 13.97 13.50 16.96 28.44% <-IRR #YR-> 5 Stock Price 249.48%
Trailing P/E 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 16.29 13.31 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 16.23 15.21 P/E:  13.73 13.97 8.51 P/E Ratio Historical Low
Free Cash Flow Market Screener $776 $1,015 $489 $1,161 $160 $183 $122 $742 $743 -76.42% <-Total Growth 5 Free Cash Flow WSJ
Change 30.80% -51.82% 137.42% -86.22% 14.38% -33.61% 510.70% 0.13% 14.38% <-Median-> 5 Change
Free Cash Flow WSJ -$1,069 -$681 -$52 -$67 -$405 $187 $160 -$366 $122 $742 $743 65.76% <-Total Growth 7 Free Cash Flow WSJ
Change 36.30% 92.36% -28.85% -504.48% 146.17% -14.44% -328.75% 133.20% 510.70% 0.13% -14.44% <-Median-> 7 Change
FCF/CF from Op Ratio 13.60 -1.11 -0.07 -0.09 -0.75 0.17 0.10 -0.30 0.09 0.50 0.48 -14.20% <-IRR #YR-> 7 Free Cash Flow MS #DIV/0!
Dividends paid $473 $266 $268 $303 $298 $316 $353 $381 $416 $416 $416 #DIV/0! <-Total Growth 7 Dividends paid
Percentage paid -44.24% 0.00% 0.00% 0.00% 0.00% 168.98% 220.63% 0.00% 342.17% 56.03% 55.95% $0.00 <-Median-> 8 Percentage paid
5 Year Coverage -70.69% -142.50% -868.93% -336.25% -583.05% 222.79% 141.46% 5 Year Coverage
Dividend Coverage Ratio -2.26 -2.56 -0.19 -0.22 -1.36 0.59 0.45 -0.96 0.29 1.78 1.79 -0.59 <-Median-> 8 Dividend Coverage Ratio
5 Year of Coverage -1.41 -0.70 -0.12 -0.30 -0.17 0.45 0.71 5 Year of Coverage
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 -$181 -$91 -$190 $0 $50 -$620 -$490 $130 $330 $230 $80 -$280 -$360 $122 $742 $743 -89.47% <-Total Growth 10 Free Cash Flow CF-CapEx
Change 73.19% 49.72% -108.79% 100.00% #DIV/0! -1340.00% 20.97% 126.53% 153.85% -30.30% -65.22% -450.00% -28.57% 133.75% 510.70% 0.13% #NUM! <-IRR #YR-> 5 Free Cash Flow MS -376.92%
FCF/CF from Op Ratio -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.29 0.09 0.50 0.48 6.60% <-IRR #YR-> 10 Free Cash Flow MS -89.47%
Dividends paid $170.7 $210.3 $255 $248 $235 $473 $266 $268 $303 $298 $316 $353 $381 $416 $416 $416 49.53% <-Total Growth 10 Dividends paid
Percentage paid -94.31% -231.10% -134.11% #DIV/0! 469.40% -76.27% 0.00% 206.15% 91.82% 129.57% 395.00% 0.00% 0.00% 342.17% 56.03% 55.95% #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% #DIV/0! -845.91% 619.92% 204.99% 5 Year Coverage
Dividend Coverage Ratio -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.94 0.29 1.78 1.79 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.00 -0.12 0.16 0.49 5 Year of Coverage
Market Cap $4,986 $5,805 $4,520 $5,658 $5,016 $3,826 $5,520 $5,232 $7,654 $6,582 $8,204 $9,975 $13,023 $15,297 $15,297 $15,297 188.11% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 119.509 128.6 138.8 157.6 171.3 222.7 277.4 279.7 281.7 283.3 283.7 298.3 301.5 301.5 117.22% <-Total Growth 10 Diluted
Change 24.09% 7.61% 7.93% 13.54% 8.69% 30.01% 24.56% 0.83% 0.72% 0.57% 0.14% 5.15% 1.07% 0.00% 3.11% <-Median-> 10 Change
Difference Diluted/Basic -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.2% -0.2% -0.24% <-Median-> 10 Difference Diluted/Basic
Basic # of Shares in Millions 116.068 126.7 137.7 157.2 171.0 222.6 276.9 279.4 279.9 281.0 282.1 296.8 300.8 300.8 300.8 300.8 118.45% <-Total Growth 10 Basic
Change 22.19% 9.16% 8.68% 14.16% 8.78% 30.18% 24.39% 0.90% 0.18% 0.39% 0.39% 5.21% 1.35% 0.00% 0.00% 0.00% 3.28% <-Median-> 10 Change
Difference Basic/Outstanding 5.4% 5.7% 6.2% 6.2% 2.5% 23.6% 0.8% 0.0% 0.1% 0.2% 4.5% 0.4% 3.4% 3.4% 3.4% 3.4% 1.64% <-Median-> 10 Difference Basic/Outstanding
# of Share in Millons 122.305 133.942 146.281 166.907 175.279 275.224 279.075 279.494 280.269 281.532 294.904 297.925 311.177 311.177 311.177 311.177 7.84% <-IRR #YR-> 10 Shares 112.73%
Increase 16.11% 9.51% 9.21% 14.10% 5.02% 57.02% 1.40% 0.15% 0.28% 0.45% 4.75% 1.02% 4.45% 0.00% 0.00% 0.00% 2.17% <-IRR #YR-> 5 Shares 11.34%
CF fr Op $M $366.3 $457.7 $501.2 $456.2 $545.2 -$78.6 $615.5 $773 $738 $539 $1,121 $1,538 $1,235 $1,402 $1,473 $1,540 146.41% <-Total Growth 10 Cash Flow
Increase 150.31% 24.94% 9.50% -8.98% 19.51% -114.42% -883.08% 25.59% -4.53% -26.96% 107.98% 37.20% -19.70% 13.51% 5.11% 4.54% SO, S. Issue DRIP
5 year Running Average $219.86 $274.58 $336.30 $385.56 $465.33 $376.34 $407.90 $462 $519 $517 $757 $942 $1,034 $1,167 $1,354 $1,438 207.52% <-Total Growth 10 CF 5 Yr Running
CFPS $3.00 $3.42 $3.43 $2.73 $3.11 -$0.29 $2.21 $2.77 $2.63 $1.91 $3.80 $5.16 $3.97 $4.51 $4.74 $4.95 15.83% <-Total Growth 10 Cash Flow per Share
Increase 115.59% 14.08% 0.27% -20.23% 13.80% -109.18% -872.27% 25.40% -4.79% -27.29% 98.55% 35.81% -23.12% 13.51% 5.11% 4.54% 9.44% <-IRR #YR-> 10 Cash Flow 146.41%
5 year Running Average $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.50 $3.87 $4.43 $4.66 9.82% <-IRR #YR-> 5 Cash Flow 59.77%
P/CF on Med Price 12.34 13.15 11.19 11.53 10.00 -72.31 7.74 5.81 8.78 13.92 6.13 6.08 9.75 9.87 0.00 0.00 1.48% <-IRR #YR-> 10 Cash Flow per Share 15.83%
P/CF on Closing Price 13.61 12.68 9.02 12.40 9.20 -48.67 8.97 6.77 10.37 12.21 7.32 6.49 10.54 10.91 10.38 9.93 7.49% <-IRR #YR-> 5 Cash Flow per Share 43.50%
32.06% Diff M/C 2.56% <-IRR #YR-> 10 CFPS 5 yr Running 28.72%
Excl.Working Capital CF $32.07 $10.90 -$39.20 $77.50 -$5.90 $486.50 $231.50 $203 $410 $650 -$100 -$430 $29 $0 $0 $0 10.67% <-IRR #YR-> 5 CFPS 5 yr Running 66.01%
CF fr Op $M WC $398.41 $468.60 $462.00 $533.70 $539.30 $407.90 $847.00 $976 $1,148 $1,189 $1,021 $1,108 $1,264 $1,402 $1,473 $1,540 173.59% <-Total Growth 10 Cash Flow less WC
Increase 56.95% 17.62% -1.41% 15.52% 1.05% -24.36% 107.65% 15.23% 17.62% 3.57% -14.13% 8.52% 14.08% 10.91% 5.11% 4.54% 10.59% <-IRR #YR-> 10 Cash Flow less WC 173.59%
5 year Running Average $253.56 $306.91 $360.41 $423.31 $480.40 $482.30 $557.98 $661 $784 $914 $1,036 $1,088 $1,146 $1,197 $1,254 $1,358 5.31% <-IRR #YR-> 5 Cash Flow less WC 29.51%
CFPS Excl. WC $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.06 $4.51 $4.74 $4.95 12.26% <-IRR #YR-> 10 CF less WC 5 Yr Run 217.98%
Increase 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.22% 10.91% 5.11% 4.54% 11.64% <-IRR #YR-> 5 CF less WC 5 Yr Run 73.43%
5 year Running Average $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.91 $3.99 $4.10 $4.39 2.55% <-IRR #YR-> 10 CFPS - Less WC 28.61%
P/CF on Med Price 11.35 12.84 12.14 9.85 10.11 13.93 5.63 4.60 5.65 6.31 6.73 8.44 9.53 9.87 0.00 0.00 3.07% <-IRR #YR-> 5 CFPS - Less WC 16.32%
P/CF on Closing Price 12.52 12.39 9.78 10.60 9.30 9.38 6.52 5.36 6.67 5.54 8.04 9.00 10.30 10.91 10.38 9.93 2.84% <-IRR #YR-> 10 CFPS 5 yr Running 32.36%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 8.26 5 yr  8.78 P/CF Med 10 yr 7.59 5 yr  6.73 43.85% Diff M/C 6.49% <-IRR #YR-> 5 CFPS 5 yr Running 36.96%
OPM 17.93% 19.02% 22.86% 20.83% 21.33% -1.85% 11.20% 13.84% 6.98% 3.83% 8.63% 12.36% 9.72% 9.85% -53.34% <-Total Growth 10 OPM
Increase 77.69% 6.09% 20.15% -8.85% 2.37% -108.66% 706.61% 23.52% -49.55% -45.18% 125.42% 43.25% -21.33% 1.32% should be zero, it is a check on calculations
Diff from Median 71.42% 81.86% 118.50% 99.16% 103.89% -117.65% 7.08% 32.26% -33.27% -63.42% -17.55% 18.11% -7.08% -5.85% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 10.46% 5 Yrs 8.63% Should increase or be stable.
$1,921 <-12 mths 3.10%
Normalized EBITDA $509 $546 $582 $701 $797 $1,009 $1,271 $1,310 $1,490 $1,537 $1,575 $1,769 $1,863 $2,002 $2,199 $2,316 220.10% <-Total Growth 10 Normalized EBITDA
Normalized EBITDA per share $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.19 $6.66 $7.31 $7.70 46.54% <-Total Growth 10 Normalized EBITDA per share
EBITDA per Share $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.19 $6.66 $7.31 $7.70 46.77% <-Total Growth 10 EBITDA per Share
Change 34.45% 3.58% -2.09% 5.67% 4.52% -2.75% 1.26% 2.15% 13.54% 2.75% 2.07% 6.75% 3.91% 7.46% 9.84% 5.32% 3.33% <-Median-> 10 Change
Price/EBITDA 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.76 7.39 6.72 6.38 5.06 <-Median-> 10 Price/EBITDA
Margin 24.91% 22.69% 26.54% 32.01% 31.18% 23.70% 23.13% 23.45% 14.09% 10.91% 12.12% 14.21% 14.66% 14.06% 14.59% 13.80% 0.19 <-Median-> 10 Margin
Leverage with EBITDA (D/EBITDA) 8.75 8.86 10.13 7.97 6.77 15.71 9.78 10.59 9.39 10.64 9.91 9.64 9.24 8.60 0.00 0.00 9.71 <-Median-> 10 Leverage with EBITDA
$1,402 <-12 mths 4.18%
EBIT $896 $1,068 $1,098 $1,134 $1,294 $1,346 $1,466 $1,633 $1,745 <-Total Growth 5 EBIT Fr Mkt Sc
Change 19.20% 2.81% 3.28% 14.11% 4.02% 8.92% 11.39% 6.86% 4.02% <-Median-> 5 Change
Margin 16.04% 10.10% 7.79% 8.73% 10.40% 10.59% 10.30% 10.83% 10.40% 10.25% <-Median-> 6 Margin
Leverage with EBIT (D/EBIT) 15.48 13.10 14.89 13.76 13.17 12.79 11.75 0.00 0.00 13.47 <-Median-> 6 Leverage with EBIT 
Covering Assets $5,219 $5,672 $6,967 $7,074 $7,026 $13,876 $10,909 $11,577 $11,986 $12,484 $13,385 $15,402 $16,173 $16,173 132.13% <-Total Growth 10 Covering Assets
change 23.01% 8.69% 22.83% 1.53% -0.68% 97.49% -21.38% 6.13% 3.53% 4.15% 7.22% 15.07% 5.01% 0.00% 4.58% <-Median-> 10 Change
Debt/Covering Assets 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.89 0.57 0.65 <-Median-> 10 Debt/Covering Assets Type
Long Term Debt $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,169 $9,169 145.66% <-Total Growth 10 Debt Lg Term R
Change 12.44% 3.28% 22.39% -9.79% 2.07% 134.74% -26.52% 28.65% 0.76% 13.14% -4.88% 9.00% 1.72% 0.00% 1.89% <-Median-> 10 Change Lg Term R+A
Debt/Market Cap Ratio 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.70 0.60 1.01 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 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.52 7.52 7.49 <-Median-> 10 Assets/Current Liab. Ratio Liquidity
Debt to Cash Flow (Years) 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.42 6.54 7.40 <-Median-> 10 Debt to Cash Flow (Years) Liq. + CF
Liq. + CF + D
Intangibles $195.26 $356.9 $735.1 $694.3 $588.8 $711.9 $585.6 $539 $171 $120 $122 $107 $110 $110 -85.04% <-Total Growth 10 Intangibles Debt Ratio
Goodwill $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,448 $5,448 521.00% <-Total Growth 10 Goodwill Leverage
Total $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,558 $5,558 244.70% <-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% -4.14% 0.00% -1.72% <-Median-> 10 Change
Intangible/Market Cap Ratio 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.43 0.36 0.68 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $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,907 $2,907 180.11% <-Total Growth 10 Current Assets
Current Liabilities $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,559 $3,559 275.54% <-Total Growth 10 Current Liabilities
Liquidity Ratio 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.82 0.82 0.88 <-Median-> 10 Ratio
Liq. with CF NC aft div 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.09 1.14 <-Median-> 5 Liq. with CF NC aft div
Liq. CF re  Inv+Div  0.40 0.95 0.51 0.49 0.67 0.38 0.81 0.79 0.97 1.11 1.06 0.82 0.72 1.09 0.97 <-Median-> 5 Liq. CF re  Inv+Div 
Cur. Lg Term Debt $209.07 $214.4 $387.5 $383.4 $188.9 $890.2 $922.9 $360 $511 $334 $999 $858 $5 $5 $511.0 <-Median-> 5 Cur. Lg Term Debt
Liquidity Ratio 1.20 1.92 1.85 1.21 1.12 1.26 1.00 1.11 1.22 1.51 1.26 1.07 0.82 0.82 1.22 <-Median-> 5 Liquidity Ratio
Liq. with CF aft div 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.06 1.10 1.51 <-Median-> 5 Liq. with CF aft div
Assets $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,770 $26,770 Debt Ratio of 1.5 and up, best
Liabilities $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,222 $17,222 1.55 <-Median-> 10 Ratio
Debt Ratio 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.55 1.55 1.53 <-Median-> 5 Ratio
Estimates BVPS $28.94 $30.17 $31.65 Estimates Estimates BVPS
Estimate Book Value $9,005.5 $9,388.2 $9,848.8 Estimates Estimate Book Value
Change -5.68% 4.25% 4.91%
P/B Ratio (Close) 1.70 1.63 1.55 Estimates P/B Ratio (Close)
Difference from 10 year median 75.23% Diff M/C Estimates Difference from 10 yr med.
Check on BV $2,753 $3,183 $3,596
Total Book Value $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,548 $9,548 127.18% <-Total Growth 10 Total Book Value
Non-Cont. Int. $38 $33 $35 $35 $66 $620.6 $153.9 $620 $652 $162 $150 $294 $633 $633 Non-Cont. Int.
Net Book Value $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,915 $8,915 113.89% <-Total Growth 10 Book Value & Pref
Net Book Value per Share $22.83 $26.44 $28.49 $27.44 $26.09 $25.51 $25.85 $25.19 $24.79 $26.48 $26.15 $29.38 $28.65 $28.65 0.55% <-Total Growth 10 Book Value per Share
P/B Ratio (Median) 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.35 1.55 0.97 P/B Ratio 10 yr Med
P/BV 10 yr Med 0.97 5 yr Med 1.01
Preferred Shares $590 $788 $985.1 $985.1 $1,277.7 $1,318.8 $1,277.1 $1,077 $1,076 $586 $391 $391 $195 $195 -80.21% <-Total Growth 10 Preferred Shares
Book Value $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,720 $8,720 $8,720 $8,720 173.96% <-Total Growth 10 Book Value
BV per share $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.02 $28.02 $28.02 $28.02 28.79% <-Total Growth 10 Book Value per Share
Change 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.15% 0.00% 0.00% 0.00% 13.95% P/B Ratio Current/Historical Median
P/B Ratio (Median) 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.38 1.59 0.00 0.00 1.54 P/B Ratio Historical Median
P/B Ratio (Close) 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.49 1.75 1.75 1.75 2.56% <-IRR #YR-> 10 Book Value 28.79%
Change 0.22% -6.87% -32.66% 10.81% -3.28% -55.91% 38.53% -5.63% 48.56% -26.48% 16.95% 6.47% 25.19% 17.47% 0.00% 0.00% 5.60% <-IRR #YR-> 5 Book Value 31.32%
Leverage (A/BK) 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.80 2.80 2.83 <-Median-> 10 A/BV
Debt/Equity Ratio 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.80 1.80 1.83 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.10 5 yr Med 1.10 59.81% Diff M/C
Comprehensive Income $263.35 $261.9 $330.1 $185.0 -$106.1 -$73.8 $506.2 $377 $283 $1,204 $458 $1,368 $296 -10.33% <-Total Growth 10 Comprehensive Income
NCI $7.33 $8.1 $8.6 $9.9 -$114.4 -$18.6 $6.8 $20 $20 $53 $16 $12 $11 NCI
Shareholders $256.02 $253.8 $321.5 $175.1 $8.3 -$55.2 $499.4 $357 $263 $1,151 $442 $1,356 $285 -11.35% <-Total Growth 10 Shareholders
Increase 126.24% -0.87% 26.67% -45.54% -95.26% -765.06% 1004.71% -28.51% -26.33% 337.64% -61.60% 206.79% -78.98% -26.33% <-Median-> 5 Comprehensive Income
5 Yr Running Average $133 $157 $206 $224 $203 $141 $190 $197 $215 $443 $542 $714 $699 -1.20% <-IRR #YR-> 10 Comprehensive Income -11.35%
ROE 11.6% 9.2% 10.1% 4.9% 0.3% -1.0% 8.4% 6.0% 4.5% 16.8% 6.0% 16.2% 3.3% -4.40% <-IRR #YR-> 5 Comprehensive Income -20.17%
5Yr Median 7.6% 7.6% 9.2% 9.2% 9.2% 4.9% 4.9% 4.9% 4.5% 6.0% 6.0% 6.0% 6.0% 13.00% <-IRR #YR-> 10 5 Yr Running Average 239.41%
% Difference from NI 41.1% 165.5% 3147.5% 12.7% -72.6% -89.0% -34.7% -26.5% 14.3% 188.5% -31.0% 134.6% -61.8% 28.85% <-IRR #YR-> 5 5 Yr Running Average 255.17%
Median Values Diff 5, 10 yr -28.8% 14.3% 6.0% <-Median-> 5 Return on Equity
Current Liability Coverage Ratio 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.36 0.39   CFO / Current Liabilities
5 year Median 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 0.35 35.2% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 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.72% 5.24% CFO / Total Assets
5 year Median 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.72% 4.72% 4.6% <-Median-> 10 Return on Assets 
Return on Assets ROA 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.79% 2.79% Net  Income/Assets Return on Assets
5Yr Median 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% 2.73% 1.9% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 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.57% 8.58% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 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% 8.57% 6.4% <-Median-> 10 Return on Equity
$730.50 <-12 mths -2.21%
Net Income $208.43 $138.2 $59.7 $213.4 $99.9 -$453.7 $840.3 $572 $340 $573 $689 $608 $779 1204.86% <-Total Growth 10 Net Income
NCI $7.33 $8.1 $8.6 $9.9 $8.3 -$18.6 $6.8 $20 $57 $50 $16 $12 $11 NCI
Preferred Shareholders $19.63 $34.5 $41.2 $48.1 $61.3 $66.6 $68.5 $66 $53 $124 $32 $18 $21 -49.03% <-Total Growth 10 Preferred Shareholders
Shareholders $181.47 $95.6 $9.9 $155.4 $30.3 -$501.7 $765.0 $486 $230 $399 $641 $578 $747 $748.2 $835.2 $932.3 7445.45% <-Total Growth 10 Shareholders
Increase 78.18% -47.32% -89.64% 1469.70% -80.50% -1755.78% 252.48% -36.47% -52.67% 73.48% 60.65% -9.83% 29.24% 0.16% 11.63% 11.63% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $121.1 $111.9 $94.5 $108.8 $94.5 -$42.1 $91.8 $187 $202 $276 $504 $467 $519 $622.6 $709.9 $768.1 54.09% <-IRR #YR-> 10 Net Income 7445.45%
Operating Cash Flow $366.3 $457.7 $501.2 $456.2 $545.2 -$78.6 $615.5 $773 $738 $539 $1,121 $1,538 $1,235 8.98% <-IRR #YR-> 5 Net Income 53.70%
Investment Cash Flow -$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 -$1,634 18.57% <-IRR #YR-> 10 5 Yr Running Ave. 449.31%
Total Accruals $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 $1,146.0 22.65% <-IRR #YR-> 5 5 Yr Running Ave. 177.54%
Total Assets $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,770 Balance Sheet Assets
Accruals Ratio 14.83% 2.72% 10.14% 4.43% -0.16% 23.04% -10.28% 4.29% -0.12% 3.58% -1.20% 1.59% 4.28% 1.59% <-Median-> 5 Ratio
EPS/CF Ratio 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.61 0.42 <-Median-> 10 EPS/CF Ratio
Change in Close 21.45% 6.30% -28.70% 9.71% -15.58% -51.43% 42.30% -5.36% 45.89% -14.39% 18.99% 20.35% 25.00% 17.47% 0.00% 0.00% Count 27 Years of data
up/down down down down down up Count 14 51.85%
Meet Prediction? % right Count 1 7.14%
Financial Cash Flow $930.82 $455.7 $929.6 $21.4 -$38.0 $5,987.0 -$2,873.7 $392 -$245 $435 -$882 -$175 $409 C F Statement  Financial CF
Total Accruals $149.08 -$226.7 $94.7 $430.0 $22.4 -$575.7 $839.5 $532 $220 $422 $601 $590 $737 Accruals
Accruals Ratio 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.75% 2.26% <-Median-> 5 Ratio
Cash $44.81 $371.0 $293.4 $19.0 $27.3 $201.1 $122.4 $74 $84 $64 $104 $92 $102 $102 Cash
Cash per Share $0.37 $2.77 $2.01 $0.11 $0.16 $0.73 $0.44 $0 $0 $0 $0 $0 $0 $0.33 $0.31 <-Median-> 5 Cash per Share
Percentage of Stock Price 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.78% 0.67% 0.97% <-Median-> 5 % of Stock Price
Taxable Income
Capital Gain
Dividend Income
Ret. Of Capital
Notes:
March 28, 2026.  Last estimates were for 2025, 2026, 2027 of $14248M, $14747M, $16512M Revenue, $428 2025 AFFO, $2.23, $2.41, $2.73 AEPS, $2.24, $2.42, $2.69 EPS, 
$1.26, $1.33, $1.38 Dividends, $183M, $612M, $990M FCF, $4.09, $4.28, $4.61 CFPS, $1846, $1933M, $2079M EBITDA, $1346M, $1444M, $1540M EBIT, $26.68, $28.02 2025/6 BVPS, $676M, $726M, $813M Net Income.
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.  
The business generates revenue from customers in both Canada and the United States, with the majority coming from Canadian customers.   
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 2018 Mar 24 2019 Mar 19 2020 Mar 21 2021 Mar 25 2022 Mar 21 2023 Mar 21 2024 Mar 15 2025 Mar 28 2026
Yu, Vernon Dai-Chung 0.091 0.03% 0.126 0.04% 0.178 0.06% 42.10%
CEO - Shares - Amount $3.045 $5.256 $8.773
Options - percentage 0.573 0.19% 0.583 0.19% 0.425 0.14% -27.12%
Options - amount $19.176 $24.392 $20.882
Crawford, Randall Loy 0.000 0.00% 0.019 0.01% 0.069 0.02% 0.069 0.02% 0.069 0.02% Last updated Mar 2023
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
Brown, Sean 0.053 0.02% in 2026 #DIV/0!
CFO - Shares - Amount $2.623
Options - percentage 0.032 0.01% #DIV/0!
Options - amount $1.559
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% was CFO until 2026 -100.00%
Officer - Shares - Amount $0.871 $1.310 $1.147 $1.395 $1.727 $2.213 ceased insider Jan 2026
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% -100.00%
Options - amount $12.675 $23.569 $21.225 $24.949 $31.191 $17.703
Bushfield, Corine Renae Knight 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% 0.028 0.01% 12.42%
Officer - Shares - Amount $0.001 $0.082 $0.140 $0.319 $0.348 $0.495 $0.726 $1.057 $1.396
Options - percentage 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% 0.073 0.02% -70.19%
Options - amount $1.077 $5.020 $10.792 $18.798 $16.894 $18.354 $22.524 $10.288 $3.602
Grant, Bertram 0.013 0.00% 0.013 0.00% 0.018 0.01% 0.018 0.01% Last updated Apr 2025 0.00%
Officer - Shares - Amount $0.368 $0.443 $0.765 $0.899
Options - percentage 0.659 0.22% 0.499 0.17% 0.221 0.07% 0.230 0.07% 3.85%
Options - amount $18.321 $16.712 $9.263 $11.300
Knoll, Phillip R. 0.023 0.01% 0.023 0.01% 0.023 0.01% 0.023 0.01% 0.00%
Director - Shares - Amount $0.634 $0.763 $0.953 $1.120
Options - percentage 0.059 0.02% 0.069 0.02% 0.073 0.02% 0.082 0.03% 11.90%
Options - amount $1.629 $2.306 $3.049 $4.008
Cornhill, David Wallace 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.52% 1.630 0.52% Was Chair and CEO 0.93%
Director Shares - Amount $21.823 $31.357 $29.770 $43.431 $37.181 $44.937 $54.066 $67.582 $80.125 until 2017.
Options - percentage 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.03% 0.119 0.04% 10.67%
Options - amount $13.925 $20.666 $15.620 $16.375 $8.234 $2.921 $3.289 $4.509 $5.861
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.019 0.01% 11.76%
Chair  Shares - Amount $0.262 $0.464 $0.397 $0.473 $0.569 $0.711 $0.934
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% 0.073 0.02% 15.46%
Options - amount $0.220 $0.645 $0.761 $1.217 $1.846 $2.636 $3.576
Increase in O/S Shares 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% 1.637 0.53% Average 0.51%
due to SO 2011-13 $6.872 $0.796 $1.507 $1.649 $21.158 $29.524 $25.191 $101.152 $68.516
Book Value $6.500 $1.300 $1.200 $1.000 $15.000 $28.000 $19.000 $60.000 $36.000
Insider Buying $0.000 -$1.341 -$2.353 -$0.112 -$0.066 -$0.580 -$1.909 -$1.130 $0.000
Insider Selling $1.664 $0.478 $0.784 $0.000 $5.271 $7.288 $11.711 $42.371 $4.095
Net Insider Selling $1.664 -$0.863 -$1.569 -$0.112 $5.205 $6.708 $9.801 $41.241 $4.095
% of Market Cap 0.04% -0.02% -0.03% 0.00% 0.08% 0.08% 0.10% 0.32% 0.03%
Directors 12 12 12 12 10 11 11 11
Women 22% 3 25% 4 33% 4 33% 4 33% 4 40% 5 45% 4 36% 4 36%
Minorities 0% 0 0% 0 0% 1 8% 1 8% 1 10% 2 18% 2 18% 2 18%
Institutions/Holdings 13.60% 4 17.06% 20 29.46% 20 23.01% 20 23.35% 20 20.81% 20 21.26% 20 23.14%
Total Shares Held 0.62% 1.364 0.49% 81.562 29.23% 64.483 22.90% 65.757 22.30% 61.372 20.60% 63.350 20.36% 72.040 23.15%
Increase/Decrease 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% -0.279 -0.39%
Starting No. of Shares 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 72.319 Top 20 MS
Institutions/Holdings 39.06% 262 39.57%
Amount $1,494.320 $2,070.590
Total Shares Held 31.95% 59.000 33.66%
Amount $1,602.720 $1,688.580
Increase/Decrease 40.00% 6.000 11.32%
Starting No. of Shares Morningstar 53.000 Morningstar
Copyright © 2008 Website of SPBrunner. All rights reserved.
My stock