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.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Q2 2023
Capital Power Corp TSX CPX OTC CPRHF https://www.capitalpower.com/ Fiscal Yr: Dec 31
Year 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 Value Description #Y Item Total G
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$3,863 <-12 mths 31.89%
Revenue* $1,760 $1,691 $1,291 $1,393 $1,228 $1,251 $1,214 $1,046 $1,249 $1,713 $1,791 $1,757 $2,712 110.07% <-Total Growth 10 Revenue
Other income $100 $145 $250 $146 $233 $217
Total Revenue $1,760 $1,691 $1,291 $1,393 $1,228 $1,251 $1,214 $1,146 $1,394 $1,963 $1,937 $1,990 $2,929 $3,299 $2,450 $2,569 126.88% <-Total Growth 10 Revenue
Increase 74.60% -3.92% -23.65% 7.90% -11.84% 1.87% -2.96% -5.60% 21.64% 40.82% -1.32% 2.74% 47.19% 12.63% -25.74% 4.86% 8.54% <-IRR #YR-> 10 Revenue 126.88%
5 year Running Average $1,429 $1,473 $1,371 $1,275 $1,246 $1,247 $1,394 $1,531 $1,686 $2,043 $2,424 $2,521 $2,647 20.64% <-IRR #YR-> 5 Revenue 155.58%
Revenue per Share $56.81 $28.68 $18.45 $17.22 $14.71 $12.85 $12.63 $10.99 $13.68 $18.63 $18.24 $17.13 $25.06 $28.22 $20.96 $21.98 4.05% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
Increase 22.58% -49.52% -35.64% -6.68% -14.56% -12.69% -1.72% -12.99% 24.56% 36.13% -2.07% -6.12% 46.31% 12.63% -25.74% 4.86% 10.38% <-IRR #YR-> 5 5 yr Running Average 63.88%
5 year Running Average $33.50 $27.17 $18.38 $15.17 $13.68 $12.97 $13.75 $14.83 $15.73 $18.55 $21.46 $21.92 $22.67 3.11% <-IRR #YR-> 10 Revenue per Share 35.78%
P/S (Price/Sales) Med 0.40 0.85 1.26 1.23 1.67 1.65 1.62 2.26 1.91 1.65 1.62 2.28 1.78 1.53 0.00 0.00 17.93% <-IRR #YR-> 5 Revenue per Share 128.09%
P/S (Price/Sales) Close 0.42 0.88 1.23 1.24 1.77 1.38 1.84 2.23 1.94 1.85 1.92 2.30 1.85 1.46 1.97 1.88 -6.36% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
P/S 10 Year Median  0.43 0.45 0.65 0.85 1.04 1.23 1.24 1.26 1.44 1.63 1.63 1.65 1.66 1.66 1.65 1.64 6.28% <-IRR #YR-> 5 5 yr Running Average 35.60%
*Revenue in M CDN $  P/S Med 20 yr  1.63 15 yr  1.63 10 yr  1.66 5 yr  1.78 -11.93% Diff M/C
-$1,291.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,929.0
-$1,146.0 $0.0 $0.0 $0.0 $0.0 $2,929.0
-$1,428.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,042.6
-$1,246.4 $0.0 $0.0 $0.0 $0.0 $2,042.6
-$18.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.06
-$10.99 $0.00 $0.00 $0.00 $0.00 $25.06
$424.0 <-12 mths 0.00%
$5.01 <-12 mths 37.64%
Normalized Earnings $31 $55 $86 $127 $59 $111 $117 $104 $115 $140 $128 $221 $424
AEPS* Dilued $1.40 $1.24 $1.29 $1.74 $0.72 $1.22 $1.15 $1.03 $1.12 $1.34 $1.22 $1.97 $3.64 $5.35 $3.31 $2.59 182.17% <-Total Growth 10 AEPS
Increase 133.33% -11.43% 4.03% 34.88% -58.62% 69.44% -5.74% -10.43% 8.74% 19.64% -8.96% 61.48% 84.77% 46.98% -38.13% -21.75% 10 0 10 Years of Data, EPS P or N 100.00%
AEPS Yield 5.92% 4.94% 5.68% 8.17% 2.77% 6.87% 4.95% 4.21% 4.21% 3.90% 3.49% 4.99% 7.86% 12.95% 8.01% 6.27% 10.93% <-IRR #YR-> 10 AEPS 182.17%
5 year Running Average $1.25 $1.28 $1.24 $1.22 $1.17 $1.05 $1.17 $1.17 $1.34 $1.86 $2.70 $3.10 $3.37 28.72% <-IRR #YR-> 5 AEPS 253.40%
Payout Ratio 90.00% 101.61% 97.67% 72.41% 181.94% 115.57% 131.30% 156.80% 154.46% 138.43% 160.04% 105.84% 61.06% 44.02% 74.32% 94.98% 4.47% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
5 year Running Average 93.34% 108.73% 113.84% 119.78% 131.61% 148.02% 139.31% 148.21% 143.11% 123.97% 101.88% 89.06% 76.04% 9.65% <-IRR #YR-> 5 5 yr Running Average 58.53%
Price/AEPS Median 16.33 19.63 18.02 12.17 34.21 17.34 17.77 24.08 23.29 22.95 24.25 19.85 12.26 8.05 0.00 0.00 21.40 <-Median-> 10 Price/AEPS Median
Price/AEPS High 17.62 21.82 19.91 12.93 39.69 22.02 21.18 25.59 26.46 26.18 31.78 22.57 14.21 8.73 0.00 0.00 24.08 <-Median-> 10 Price/AEPS High
Price/AEPS Low 15.04 17.44 16.14 11.41 28.72 12.66 14.35 22.57 20.13 19.72 16.72 17.13 10.31 7.37 0.00 0.00 16.92 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 16.89 20.26 17.62 12.24 36.11 14.57 20.20 23.78 23.74 25.66 28.67 20.03 12.73 7.72 12.48 15.95 21.97 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 39.42 17.94 18.33 16.51 14.94 24.68 19.04 21.30 25.82 30.71 26.10 32.34 23.52 11.35 7.72 12.48 24.10 <-Median-> 10 Trailing P/AEPS Close
Median Values DPR 10 Yrs 134.87% 5 Yrs   138.43% P/CF 5 Yrs   in order 22.95 26.18 17.13 23.74 -66.34% Diff M/C DPR 75% to 95% best
$829.0 <-12 mths -2.24%
$7.10 <-12 mths -2.47%
Adjusted Funds from Operations $354 $352 $381 $426 $362 $400 $307 $363 $397 $555 $522 $605 $848
AFFO* $11.43 $3.89 $3.89 $5.85 $4.40 $4.15 $3.19 $3.58 $3.85 $5.32 $4.96 $5.40 $7.28 $7.23 $6.71 87.15% <-Total Growth 10 AFFO
Increase 45.34% -65.96% 0.00% 50.39% -24.82% -5.65% -23.11% 12.20% 7.54% 38.18% -6.77% 8.87% 34.81% -0.69% -7.19% 10 0 10 Years of Data, AFFP, P or N 100.00%
AFFO Yield 48.32% 15.49% 17.11% 27.47% 16.92% 23.35% 13.74% 14.62% 14.48% 15.47% 14.18% 13.68% 15.71% 17.50% 16.24% 6.47% <-IRR #YR-> 10 AFFO 87.15%
5 year Running Average $6.58 $5.89 $4.44 $4.30 $4.23 $3.83 $4.02 $4.18 $4.62 $5.36 $6.04 $6.32 15.25% <-IRR #YR-> 5 AFFO 103.35%
Payout Ratio 11.03% 32.39% 32.39% 21.54% 29.79% 33.98% 47.32% 45.11% 44.94% 34.87% 39.36% 38.61% 30.53% 32.57% 36.66% -2.26% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
5 year Running Average 21.07% 25.43% 30.02% 33.00% 35.55% 40.23% 41.24% 42.32% 40.58% 37.66% 35.19% 35.55% 4.84% <-IRR #YR-> 5 5 yr Running Average 26.65%
Price/AFFO Median 2.00 6.26 5.98 3.62 5.60 5.10 6.40 6.93 6.78 5.78 5.96 7.24 6.13 5.96 0.00 6.05 <-Median-> 10 P/AFFO Med
Price/AFFO High 2.16 6.96 6.60 3.85 6.50 6.47 7.63 7.36 7.70 6.59 7.82 8.24 7.10 6.46 0.00 7.23 <-Median-> 10 P/AFFO High
Price/AFFO Low 1.84 5.56 5.35 3.39 4.70 3.72 5.17 6.49 5.85 4.97 4.11 6.25 5.16 5.46 0.00 5.06 <-Median-> 10 P/AFFO Low
Price/AFFO Close 2.07 6.46 5.84 3.64 5.91 4.28 7.28 6.84 6.91 6.46 7.05 7.31 6.36 5.72 6.16 6.65 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 3.01 2.20 5.84 5.48 4.44 4.04 5.60 7.68 7.43 8.93 6.58 7.96 8.58 5.68 5.72 7.00 <-Median-> 10 Trailing P/AFFO Close
Median Values DPR 10 Yrs 36.74% 5 Yrs   38.61% P/CF 5 Yrs   in order 6.13 7.70 5.16 6.91 -6.78% Diff M/C DPR 75% to 95% best
* Adjusted Funds From Operations
$2.32 <-12 mths 176.19%
EPS Basic $0.50 $1.60 $0.84 $2.13 $0.28 $0.70 $0.91 $1.07 $2.25 $0.73 $0.78 $0.39 $0.85 1.19% <-Total Growth 10 EPS Basic
EPS Diluted* $0.50 $1.59 $0.84 $2.08 $0.28 $0.70 $0.91 $1.07 $2.25 $0.72 $0.77 $0.39 $0.84 $5.45 $3.02 $2.17 0.00% <-Total Growth 10 EPS Diluted
Increase -43.82% 218.00% -47.17% 147.62% -86.54% 150.00% 30.00% 17.58% 110.28% -68.00% 6.94% -49.35% 115.38% 548.81% -44.59% -28.15% 10 0 10 Years of Data, EPS P or N
Earnings Yield 2.11% 6.33% 3.70% 9.77% 1.08% 3.94% 3.92% 4.37% 8.46% 2.09% 2.20% 0.99% 1.81% 13.19% 7.31% 5.25% 0.00% <-IRR #YR-> 10 Earnings per Share 0.00%
5 year Running Average $1.18 $1.06 $1.10 $0.96 $1.01 $1.04 $1.13 $1.14 $1.04 $0.99 $1.63 $2.09 $2.37 -4.72% <-IRR #YR-> 5 Earnings per Share -21.50%
10 year Running Average $1.11 $1.09 $1.12 $1.00 $1.00 $1.34 $1.61 $1.76 -1.89% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
* Diluted ESP per share  E/P 10 Yrs 3.06% 5Yrs 2.09% -0.28% <-IRR #YR-> 5 5 yr Running Average -1.39%
-$0.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.84
-$1.07 $0.00 $0.00 $0.00 $0.00 $0.84
-$1.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.99
-$1.01 $0.00 $0.00 $0.00 $0.00 $0.99
Dividend* $2.39 $2.52 $2.65 Estimates Dividend*
Increase 7.54% 5.44% 5.16% Estimates Increase
Payout Ratio EPS 43.85% 83.44% 122.12% Estimates Payout Ratio EPS
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Dividend* $1.2600 $1.2600 $1.2600 $1.2600 $1.3100 $1.4100 $1.5100 $1.615 $1.730 $1.855 $1.953 $2.085 $2.223 $2.355 $2.460 $2.460 76.39% <-Total Growth 10 Dividends
Increase 100.00% 0.00% 0.00% 0.00% 3.97% 7.63% 7.09% 6.95% 7.12% 7.23% 5.26% 6.79% 6.59% 5.96% 4.46% 0.00% 10 0 13 Years of data, Count P, N
Average Increases 5 Year Running 20.79% 2.32% 3.74% 5.13% 6.55% 7.21% 6.73% 6.67% 6.60% 6.36% 5.81% 4.76% 6.60% <-Median-> 9 Average Incr 5 Year Running
Dividends 5 Yr Running $1.13 $1.27 $1.30 $1.35 $1.42 $1.52 $1.62 $1.73 $1.85 $1.97 $2.09 $2.22 $2.32 73.63% <-Total Growth 9 Dividends 5 Yr Running
Yield H/L Price 5.51% 5.18% 5.42% 5.95% 5.32% 6.67% 7.39% 6.51% 6.63% 6.03% 6.60% 5.33% 4.98% 5.47% 6.27% <-Median-> 10 Yield H/L Price
Yield on High  Price 5.11% 4.66% 4.91% 5.60% 4.58% 5.25% 6.20% 6.13% 5.84% 5.29% 5.04% 4.69% 4.30% 5.04% 5.27% <-Median-> 10 Yield on High  Price
Yield on Low Price 5.99% 5.83% 6.05% 6.34% 6.33% 9.13% 9.15% 6.95% 7.68% 7.02% 9.57% 6.18% 5.92% 5.97% 6.98% <-Median-> 10 Yield on Low Price
Yield on Close Price 5.33% 5.02% 5.54% 5.92% 5.04% 7.93% 6.50% 6.59% 6.51% 5.39% 5.58% 5.28% 4.80% 5.70% 5.95% 5.95% 5.75% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 252.00% 79.25% 150.00% 60.58% 467.86% 201.43% 165.93% 150.93% 76.89% 257.64% 253.57% 534.62% 264.58% 43.21% 81.46% 113.36% $1.84 <-Median-> 14 DPR EPS
DPR EPS 5 Yr Running 96.10% 120.04% 118.40% 140.33% 140.97% 145.39% 143.72% 151.44% 177.64% 198.09% 128.15% 105.78% 97.58% $1.42 <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 10.55% 16.12% 36.42% 20.51% 27.96% 32.77% 38.72% 45.29% 39.16% 27.15% 33.93% 27.94% 27.78% 27.29% 29.82% 31.99% $0.28 <-Median-> 14 DPR CF
DPR CF 5 Yr Running 15.17% 18.65% 24.61% 30.01% 31.44% 36.29% 35.28% 35.40% 32.95% 30.33% 28.55% 29.07% 28.93% $0.31 <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 10.58% 14.60% 22.72% 21.19% 25.25% 28.79% 36.48% 36.70% 31.53% 26.10% 27.75% 28.17% 30.00% 27.29% 29.82% 31.99% $0.27 <-Median-> 14 DPR CF WC
DPR CF WC 5 Yr Running 14.33% 17.06% 21.52% 26.25% 28.91% 31.41% 31.19% 30.75% 29.39% 28.59% 27.86% 28.60% 29.41% $0.29 <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 6.27% 5.75% 5 Yr Med 5 Yr Cl 6.03% 5.39% 5 Yr Med Payout 257.64% 27.94% 28.17% 6.59% <-IRR #YR-> 5 Dividends 37.62%
* Dividends per share  10 Yr Med and Cur. -5.07% 3.56% 5 Yr Med and Cur. -1.31% 10.37% Last Div Inc ---> $0.5800 $0.6150 6.03% 5.84% <-IRR #YR-> 10 Dividends 76.39%
Dividends Growth 15 4.46% <-IRR #YR-> 13 Dividends #DIV/0!
Dividends Growth 5 -$1.62 $0.00 $0.00 $0.00 $0.00 $2.22 Dividends Growth 5
Dividends Growth 10 -$1.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.22 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.22 Dividends Growth 15
Historical Dividends Historical High Div 9.36% Low Div 3.54% 10 Yr High 9.53% 10 Yr Low 4.33% Med Div 5.73% Close Div 5.47% Historical Dividends
High/Ave/Median Values Curr diff Exp. -36.39% Cheap 68.18% Exp. -37.53% 37.49% Cheap 3.90% Cheap 8.87% High/Ave/Median 
Future Dividend Yield Div Yd 8.19% earning in 5 Years at IRR of 6.59% Div Inc. 37.62% Future Dividend Yield
Future Dividend Yield Div Yd 11.27% earning in 10 Years at IRR of 6.59% Div Inc. 89.38% Future Dividend Yield
Future Dividend Yield Div Yd 15.52% earning in 15 Years at IRR of 6.59% Div Inc. 160.62% Future Dividend Yield
Div Paid $3.39 earning in 5 Years at IRR of 6.59% Div Inc. 37.62% Future Dividend Paid
Div Paid $4.66 earning in 10 Years at IRR of 6.59% Div Inc. 89.38% Future Dividend Paid
Div Paid $6.41 earning in 15 Years at IRR of 6.59% Div Inc. 160.62% Future Dividend Paid
Total Div $14.03 over 5 Years at IRR of 6.59% Div Cov. 33.96% Dividend Covering Cost
Total Div $29.96 over 10 Years at IRR of 6.59% Div Cov. 72.50% Dividend Covering Cost
Total Div $51.88 over 15 Years at IRR of 6.59% Div Cov. 125.55% Dividend Covering Cost
Yield if held 5 years 6.28% 6.17% 6.20% 6.95% 8.17% 7.53% 9.23% 10.21% 8.96% 9.03% 8.00% 8.32% 7.53% <-Median-> 9 Paid Median Price
Yield if held 10 years 8.89% 8.54% 8.57% 9.56% 11.12% 9.99% 11.63% 8.73% <-Median-> 4 Paid Median Price
Yield if held 15 years 11.79% 10.76% #NUM! <-Median-> 0 Paid Median Price
Yield if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Yield if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Item
Cost covered if held 5 years 30.44% 28.43% 27.73% 30.56% 35.76% 32.97% 40.96% 45.22% 39.69% 40.14% 36.02% 39.15% 32.97% <-Median-> 9 Paid Median Price EPS
Cost covered if held 10 years 69.37% 66.33% 65.68% 72.90% 85.20% 77.93% 95.72% 67.85% <-Median-> 4 Paid Median Price AEPS
Cost covered if held 15 years 122.46% 116.99% #NUM! <-Median-> 0 Paid Median Price AFFO
Cost covered if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price CFPS
Cost covered if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price FCF 
Yr  Item Tot. Growth
Revenue Growth  $1,046 $1,249 $1,713 $1,791 $1,757 $2,712 $10,268 159.27% <-Total Growth 5 Revenue Growth  159.27%
AEPS Growth $1.03 $1.12 $1.34 $1.22 $1.97 $3.64 $10.32 253.40% <-Total Growth 5 AEPS Growth 253.40%
Net Income Growth $144 $274 $125 $136 $98 $138 $915 -4.17% <-Total Growth 5 Net Income Growth -4.17%
Cash Flow Growth $372 $450 $720 $611 $867 $935 $3,955 151.34% <-Total Growth 5 Cash Flow Growth 151.34%
Dividend Growth $1.62 $1.73 $1.86 $1.95 $2.09 $2.22 $11.46 37.62% <-Total Growth 5 Dividend Growth 37.62%
Stock Price Growth $24.49 $26.59 $34.39 $34.98 $39.46 $46.33 89.18% <-Total Growth 5 Stock Price Growth 89.18%
Revenue Growth  $1,291 $1,393 $1,228 $1,251 $1,214 $1,046 $1,249 $1,713 $1,791 $1,757 $2,712 $16,645 110.07% <-Total Growth 10 Revenue Growth  110.07%
AEPS Growth $1.29 $1.74 $0.72 $1.22 $1.15 $1.03 $1.12 $1.34 $1.22 $1.97 $3.64 $16.44 182.17% <-Total Growth 10 AEPS Growth 182.17%
Net Income Growth $62 $175 $46 $90 $111 $144 $274 $125 $136 $98 $138 $1,399 122.58% <-Total Growth 10 Net Income Growth 122.58%
Cash Flow Growth $242 $497 $391 $419 $375 $372 $450 $720 $611 $867 $935 $5,879 286.36% <-Total Growth 10 Cash Flow Growth 286.36%
Dividend Growth $1.26 $1.26 $1.31 $1.41 $1.51 $1.62 $1.73 $1.86 $1.95 $2.09 $2.22 $18.2 76.39% <-Total Growth 10 Dividend Growth 76.39%
Stock Price Growth $22.73 $21.30 $26.00 $17.77 $23.23 $24.49 $26.59 $34.39 $34.98 $39.46 $46.33 103.83% <-Total Growth 10 Stock Price Growth 103.83%
Dividends on Shares $55.44 $57.64 $62.04 $66.44 $71.06 $76.12 $81.62 $85.91 $91.74 $97.79 $103.62 $108.24 $108.24 $745.80 No of Years 10 Total Dividends 12/31/12
Paid  $1,000.12 $937.20 $1,144.00 $781.88 $1,022.12 $1,077.56 $1,169.96 $1,513.16 $1,539.12 $1,736.24 $2,038.52 $1,818.08 $1,818.08 $1,818.08 $2,038.52 No of Years 10 Worth $22.73
Total $2,784.32 Total Value
Graham Number AEPS $26.72 $25.75 $26.20 $30.74 $19.64 $25.37 $24.24 $22.14 $23.69 $24.58 $22.44 $28.22 $34.52 $45.66 $35.91 $31.77 31.75% <-Total Growth 10 Graham Number AEPS
Increase 53.35% -3.63% 1.78% 17.33% -36.12% 29.20% -4.48% -8.64% 6.99% 3.73% -8.71% 25.80% 22.32% 32.25% -21.34% -11.54% 5.36% <-Median-> 10 Graham Price
Price/GP Ratio Med 0.86 0.95 0.89 0.69 1.25 0.83 0.84 1.12 1.10 1.25 1.32 1.39 1.29 0.94 0.00 0.00 1.19 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 0.92 1.05 0.98 0.73 1.46 1.06 1.01 1.19 1.25 1.43 1.73 1.58 1.50 1.02 0.00 0.00 1.34 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 0.79 0.84 0.79 0.65 1.05 0.61 0.68 1.05 0.95 1.08 0.91 1.20 1.09 0.86 0.00 0.00 1.00 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 0.89 0.98 0.87 0.69 1.32 0.70 0.96 1.11 1.12 1.40 1.56 1.40 1.34 0.91 1.15 1.30 1.22 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 48.13% -13.84% 7.49% -36.63% 112.30% -7.54% 7.74% 8.51% -20.81% 90.90% 96.26% 214.24% 179.36% -10.33% 20.46% 42.11% 49.71% <-Median-> 10 Graham Price
Based on EPS 3 yrs trailing $22.99 $23.03 $28.38 $23.73 $22.83 $17.32 $21.16 $25.21 $23.57 $22.45 $14.32 $16.12 $29.45 $34.77 based on EPS 3 yrs trailing
Graham Number EPS $15.97 $29.15 $21.15 $33.61 $12.25 $19.22 $21.56 $22.57 $33.58 $18.01 $17.82 $12.56 $16.58 $46.08 $34.30 $29.08 -21.57% <-Total Growth 10 Graham Number EPS
Increase -24.75% 82.60% -27.47% 58.97% -63.57% 56.94% 12.18% 4.68% 48.78% -46.35% -1.06% -29.55% 32.07% 177.85% -25.56% -15.23% 8.43% <-Median-> 10 Graham Price
Price/GP Ratio Med 1.43 0.83 1.10 0.63 2.01 1.10 0.95 1.10 0.78 1.71 1.66 3.11 2.69 0.93 1.38 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 1.55 0.93 1.21 0.67 2.33 1.40 1.13 1.17 0.88 1.95 2.18 3.54 3.12 1.01 1.67 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 1.32 0.74 0.98 0.59 1.69 0.80 0.77 1.03 0.67 1.47 1.14 2.69 2.26 0.86 1.09 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 1.48 0.86 1.07 0.63 2.12 0.92 1.08 1.09 0.79 1.91 1.96 3.14 2.79 0.90 1.20 1.42 1.50 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 48.13% -13.84% 7.49% -36.63% 112.30% -7.54% 7.74% 8.51% -20.81% 90.90% 96.26% 39.82% 34.20% -10.33% 20.46% 42.11% 21.36% <-Median-> 10 Graham Price
Month, Year 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 31-Dec 13.00 <Count Years> Month, Year
Price Close $23.65 $25.12 $22.73 $21.30 $26.00 $17.77 $23.23 $24.49 $26.59 $34.39 $34.98 $39.46 $46.33 $41.32 $41.32 $41.32 103.83% <-Total Growth 10 Stock Price
Increase 10.67% 6.22% -9.51% -6.29% 22.07% -31.65% 30.73% 5.42% 8.57% 29.33% 1.72% 12.81% 17.41% -10.81% 0.00% 0.00% 22.89 <-Median-> 10 CAPE (10 Yr P/E)
P/E Ratio 47.30 15.80 27.06 10.24 92.86 25.39 25.53 22.89 11.82 47.76 45.43 101.18 55.15 7.58 13.68 19.04 13.60% <-IRR #YR-> 5 Stock Price 89.18%
Trailing P/E Ratio 26.57 50.24 14.30 25.36 12.50 63.46 33.19 26.91 24.85 15.28 48.58 51.25 118.79 49.19 7.58 13.68 7.38% <-IRR #YR-> 10 Stock Price 103.83%
CAPE (10 Yr P/E) 20.90 22.42 22.89 27.07 29.42 23.51 20.46 20.09 19.88% <-IRR #YR-> 5 Price & Dividend 129.38%
Median 10, 5 Yrs D.  per yr 5.34% 6.28% % Tot Ret 41.96% 31.58% T P/E $30.05 $48.58 P/E:  $35.48 $47.76 12.72% <-IRR #YR-> 10 Price & Dividend 178.40%
Price 15 D.  per yr 5.15% % Tot Ret 45.65% CAPE Diff -66.88% 6.13% <-IRR #YR-> 13 Stock Price #DIV/0!
Price & Dividend 15 11.28% <-IRR #YR-> 13 Price & Dividend #DIV/0!
Price  5 -$24.49 $0.00 $0.00 $0.00 $0.00 $46.33 Price  5 TD bank
Price 10 -$22.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.33 Price 10 POW 30
Price & Dividend 5 -$24.49 $1.73 $1.86 $1.95 $2.09 $48.55 Price & Dividend 5
Price & Dividend 10 -$22.73 $1.26 $1.31 $1.41 $1.51 $1.62 $1.73 $1.86 $1.95 $2.09 $48.55 Price & Dividend 10 to year 35
Price  15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.33 Price  15
Price & Dividend 15 $1.26 $1.26 $1.26 $1.26 $1.31 $1.41 $1.51 $1.62 $1.73 $1.86 $1.95 $2.09 $48.55 Price & Dividend 15 Price  35
Price H/L Median $22.86 $24.34 $23.25 $21.18 $24.63 $21.15 $20.43 $24.81 $26.09 $30.75 $29.59 $39.11 $44.63 $43.08 91.96% <-Total Growth 10 Stock Price
Increase 9.59% 6.47% -4.48% -8.90% 16.29% -14.13% -3.40% 21.41% 5.16% 17.88% -3.79% 32.18% 14.13% -3.48% 12.47% <-IRR #YR-> 5 Stock Price 79.92%
P/E Ratio 45.72 15.31 27.68 10.18 87.96 30.21 22.45 23.18 11.59 42.71 38.42 100.27 53.13 7.90 6.74% <-IRR #YR-> 10 Stock Price 91.96%
Trailing P/E Ratio 25.69 48.68 14.62 25.21 11.84 75.54 29.19 27.26 24.38 13.67 41.09 50.79 114.44 51.28 18.77% <-IRR #YR-> 5 Price & Dividend 119.61%
P/E on Running 5 yr Average 17.95 23.28 19.26 21.24 24.61 25.03 27.21 25.86 37.60 44.90 26.36 12.08% <-IRR #YR-> 10 Price & Dividend 164.86%
P/E on Running 10 yr Average 23.48 28.11 26.39 39.07 44.59 32.19 28.95 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 6.31% 5.34% % Tot Ret 33.61% 44.23% T P/E 28.22 41.09 P/E:  34.32 42.71 Count 13 Years of data
-$24.81 $0.00 $0.00 $0.00 $0.00 $44.63
-$23.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.63
-$24.81 $1.73 $1.86 $1.95 $2.09 $46.85
-$23.25 $1.26 $1.31 $1.41 $1.51 $1.62 $1.73 $1.86 $1.95 $2.09 $46.85
High Months Dec Jun Jan May Sep Jan Dec Sep Oct Dec Feb Oct Aug Jan
Price High $24.67 $27.06 $25.68 $22.50 $28.58 $26.86 $24.36 $26.36 $29.63 $35.08 $38.77 $44.47 $51.72 $46.70 101.40% <-Total Growth 10 Stock Price
Increase 8.97% 9.69% -5.10% -12.38% 27.02% -6.02% -9.31% 8.21% 12.41% 18.39% 10.52% 14.70% 16.30% -9.71% 14.43% <-IRR #YR-> 5 Stock Price 96.21%
P/E Ratio 49.34 17.02 30.57 10.82 102.07 38.37 26.77 24.64 13.17 48.72 50.35 114.03 61.57 8.57 7.25% <-IRR #YR-> 10 Stock Price 101.40%
Trailing P/E Ratio 27.72 54.12 16.15 26.79 13.74 95.93 34.80 28.97 27.69 15.59 53.85 57.75 132.62 55.60 34.47 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 31.88 53.85 P/E:  43.55 50.35 108.05 P/E Ratio Historical High
-$26.36 $0.00 $0.00 $0.00 $0.00 $51.72
-$25.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $51.72
Low Months Jan Aug Sep Aug Jan Dec Jan Jan Feb Jan Mar Mar Jan Aug
Price Low $21.05 $21.62 $20.82 $19.86 $20.68 $15.44 $16.50 $23.25 $22.54 $26.42 $20.40 $33.74 $37.54 $39.45 80.31% <-Total Growth 10 Stock Price
Increase 10.32% 2.71% -3.70% -4.61% 4.13% -25.34% 6.87% 40.91% -3.05% 17.21% -22.79% 65.39% 11.26% 5.09% 10.06% <-IRR #YR-> 5 Stock Price 61.46%
P/E Ratio 42.10 13.60 24.79 9.55 73.86 22.06 18.13 21.73 10.02 36.69 26.49 86.51 44.69 7.24 6.07% <-IRR #YR-> 10 Stock Price 80.31%
Trailing P/E Ratio 23.65 43.24 13.09 23.64 9.94 55.14 23.57 25.55 21.07 11.74 28.33 43.82 96.26 46.96 23.42 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 24.60 28.33 P/E:  24.28 36.69 9.78 P/E Ratio Historical Low
-$20.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $37.54
$272 <-12 mths 7.51%
Free Cash Flow $62 -$32 -$356 -$444 $171 $279 $62 $154 $95 $85 $305 $245 $253 $800 $771 $591 171.07% <-Total Growth 10 Free Cash Flow
Change -151.61% -1013% -24.72% 138.51% 63.16% -77.78% 148.39% -38.31% -10.53% 258.82% -19.67% 3.27% 216.21% -3.63% -23.35% 10.44% <-IRR #YR-> 5 Free Cash Flow MS 64.29%
FCF/CF from Op Ratio 0.17 -0.07 -1.47 -0.89 0.44 0.67 0.17 0.41 0.21 0.12 0.50 0.28 0.27 0.79 0.80 0.66 #NUM! <-IRR #YR-> 10 Free Cash Flow MS 171.07%
Dividends paid $30 $51 $62 $62 $68 $106 $166 $194 $217 $238 $242 $219 $219 $275 $288 $288 253.23% <-Total Growth 10 Dividends paid
Percentage paid 48.39% -159.38% -17.42% -13.96% 39.77% 37.99% 267.74% 125.97% 228.42% 280.00% 79.34% 89.39% 86.56% 34.41% 37.29% 48.65% $0.88 <-Median-> 10 Percentage paid
5 Year Coverage -45.58% -91.36% -161.11% 268.47% 98.69% 136.44% 150.78% 125.57% 115.46% 70.69% 52.35% 48.43% 5 Year Coverage
Dividend Coverage Ratio 2.07 -0.63 -5.74 -7.16 2.51 2.63 0.37 0.79 0.44 0.36 1.26 1.12 1.16 2.91 2.68 2.06 0.96 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage -2.19 -1.09 -0.62 0.37 1.01 0.73 0.66 0.80 0.87 1.41 1.91 2.06 5 Year of Coverage
Market Cap in $M $732.7 $1,481.3 $1,590.1 $1,723.0 $2,170.0 $1,730.4 $2,233.6 $2,554.7 $2,708.8 $3,624.1 $3,714.2 $4,585.0 $5,415.4 $4,829.8 $4,829.8 $4,829.8 240.57% <-Total Growth 10 Market Cap 240.57%
Diluted # of Shares in Million 22.19 90.52 66.82 98.87 82.54 96.39 96.28 101.09 103.33 105.01 105.85 112.81 117.22 117.41 117.41 117.41 75.43% <-Total Growth 10 Diluted # of Shares in Million
Change -71.69% 307.95% -26.18% 47.96% -16.51% 16.78% -0.12% 5.00% 2.22% 1.63% 0.80% 6.57% 3.91% 0.16% 0.00% 0.00% 5.78% <-IRR #YR-> 10 Change
Difference Diluted/Basic 0.0% -51.1% 0.0% -26.3% -0.3% 0.0% -0.1% -0.3% -0.3% -0.7% -0.5% -0.7% -0.6% -0.4% -0.4% -0.4% 3.01% <-IRR #YR-> 5 Difference Diluted/Basic
Change in Diluted Shares per Year
Basic # of Shares in Millions 22.19 44.25 66.82 72.82 82.31 96.39 96.21 100.75 102.98 104.30 105.30 112.05 116.54 116.92 116.92 116.92 74.41% <-Total Growth 10 Basic
Change 2.02% 99.45% 50.99% 8.98% 13.03% 17.11% -0.19% 4.71% 2.21% 1.28% 0.96% 6.41% 4.00% 0.32% 0.00% 0.00% 4.36% <-Median-> 10 Change
Difference Basic/Outstanding 39.63% 33.25% 4.69% 11.08% 1.40% 1.02% -0.06% 3.54% -1.07% 1.04% 0.83% 3.69% 0.30% -0.03% -0.03% -0.03% 1.03% <-Median-> 10 Difference Basic/Outstanding
$772 <-12 mths -17.43%
# of Share in Millions 30.98 58.969 69.956 80.890 83.461 97.380 96.152 104.314 101.873 105.382 106.181 116.194 116.887 116.887 116.887 116.887 5.27% <-IRR #YR-> 10 Shares 67.09%
Change 42.44% 90.34% 18.63% 15.63% 3.18% 16.68% -1.26% 8.49% -2.34% 3.44% 0.76% 9.43% 0.60% 0.00% 0.00% 0.00% 2.30% <-IRR #YR-> 5 Shares 12.05%
Cash Flow from Operations $M $370 $461 $242 $497 $391 $419 $375 $372 $450 $720 $611 $867 $935 $1,009 $964 $899 286.36% <-Total Growth 10 Cash Flow
Increase 112.64% 24.59% -47.51% 105.37% -21.33% 7.16% -10.50% -0.80% 20.97% 60.00% -15.14% 41.90% 7.84% 7.89% -4.40% -6.79% SO, BuyBacks Shares Iss Pur of Company.
5 year Running Average $349 $392 $402 $385 $411 $401 $467 $506 $604 $717 $828 $877 $935 #DIV/0! <-Total Growth 9 CF 5 Yr Running
CFPS $11.94 $7.82 $3.46 $6.14 $4.68 $4.30 $3.90 $3.57 $4.42 $6.83 $5.75 $7.46 $8.00 $8.63 $8.25 $7.69 131.24% <-Total Growth 10 Cash Flow per Share
Increase 49.29% -34.54% -55.75% 77.61% -23.75% -8.16% -9.36% -8.56% 23.87% 54.67% -15.78% 29.67% 7.20% 7.89% -4.40% -6.79% 14.47% <-IRR #YR-> 10 Cash Flow 286.36%
5 year Running Average $7.47 $6.81 $5.28 $4.50 $4.52 $4.17 $4.60 $4.89 $5.61 $6.49 $7.34 $7.62 $8.01 20.24% <-IRR #YR-> 5 Cash Flow 151.34%
P/CF on Med Price 1.91 3.11 6.72 3.45 5.26 4.92 5.24 6.96 5.91 4.50 5.14 5.24 5.58 4.99 0.00 0.00 8.74% <-IRR #YR-> 10 Cash Flow per Share 131.24%
P/CF on Closing Price 1.98 3.21 6.57 3.47 5.55 4.13 5.96 6.87 6.02 5.03 6.08 5.29 5.79 4.79 5.01 5.37 17.54% <-IRR #YR-> 5 Cash Flow per Share 124.31%
-8.62% Diff M/C -1.55% <-IRR #YR-> 9 CFPS 5 yr Running #DIV/0!
$1,025 <-12 mths 18.36%
Excl.Working Capital CF -$1 $48 $146 -$16 $42 $58 $23 $87 $109 $29 $136 -$7 -$69 $0 $0 $0 7.51% <-IRR #YR-> 5 CFPS 5 yr Running 43.66%
Cash Flow from Operations $M WC $369 $509 $388 $481 $433 $477 $398 $459 $559 $749 $747 $860 $866 $1,009 $964 $899 123.20% <-Total Growth 10 Cash Flow less WC
Increase 125.00% 37.94% -23.77% 23.97% -9.98% 10.16% -16.56% 15.33% 21.79% 33.99% -0.27% 15.13% 0.70% 16.48% -4.40% -6.79% 8.36% <-IRR #YR-> 10 Cash Flow less WC 123.20%
5 year Running Average $382 $436 $458 $435 $450 $465 $528 $582 $675 $756 $846 $889 $920 13.54% <-IRR #YR-> 5 Cash Flow less WC 88.67%
CFPS Excl. WC $11.91 $8.63 $5.55 $5.95 $5.19 $4.90 $4.14 $4.40 $5.49 $7.11 $7.04 $7.40 $7.41 $8.63 $8.25 $7.69 7.88% <-IRR #YR-> 9 CF less WC 5 Yr Run #DIV/0!
Increase 57.96% -27.53% -35.74% 7.21% -12.75% -5.58% -15.50% 6.30% 24.71% 29.53% -1.02% 5.21% 0.10% 16.48% -4.40% -6.79% 10.96% <-IRR #YR-> 5 CF less WC 5 Yr Run 68.19%
5 year Running Average $7.92 $7.44 $6.04 $5.14 $4.91 $4.82 $5.21 $5.63 $6.29 $6.89 $7.52 $7.75 $7.88 2.94% <-IRR #YR-> 10 CFPS - Less WC 33.58%
P/CF on Median Price 1.92 2.82 4.19 3.56 4.75 4.32 4.94 5.64 4.75 4.33 4.21 5.28 6.02 4.99 0.00 0.00 10.98% <-IRR #YR-> 5 CFPS - Less WC 68.38%
P/CF on Closing Price 1.99 2.91 4.10 3.58 5.01 3.63 5.61 5.57 4.85 4.84 4.97 5.33 6.25 4.79 5.01 5.37 -1.53% <-IRR #YR-> 9 CFPS 5 yr Running #DIV/0!
*Operational Cash Flow. CF/-WC P/CF Med 10 yr 5.24 5 yr  5.24 P/CF Med 10 yr 4.75 5 yr  4.75 0.79% Diff M/C 6.99% <-IRR #YR-> 5 CFPS 5 yr Running 40.16%
-$3.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.00 -$429.00 Cash Flow per Share
-$3.57 $0.00 $0.00 $0.00 $0.00 $8.00 $126.00 Cash Flow per Share
-$7.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.49 $83.00 CFPS 5 yr Running
-$4.52 $0.00 $0.00 $0.00 $0.00 $6.49 $37.00 CFPS 5 yr Running
-$388.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $866.0 -$39.00 Cash Flow less WC
-$459.0 $0.0 $0.0 $0.0 $0.0 $866.0 $37.00 Cash Flow less WC
-$382.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $756.2 CF less WC 5 Yr Run
-$449.6 $0.0 $0.0 $0.0 $0.0 $756.2 CF less WC 5 Yr Run
-$5.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.41 $0.00 CFPS - Less WC
-$4.40 $0.00 $0.00 $0.00 $0.00 $7.41 CFPS - Less WC
OPM Ratio 21.02% 27.26% 18.75% 35.68% 31.84% 33.49% 30.89% 32.46% 32.28% 36.68% 31.54% 43.57% 31.92% 30.58% 70.30% <-Total Growth 10 OPM
Increase 21.79% 29.68% -31.24% 90.33% -10.76% 5.19% -7.77% 5.09% -0.55% 13.62% -14.00% 38.12% -26.73% -4.21% Should increase  or be stable.
Diff from Median -35.1% -15.8% -42.1% 10.2% -1.6% 3.5% -4.6% 0.3% -0.3% 13.3% -2.6% 34.6% -1.4% -5.5% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 32.37% 5 Yrs 32.28% should be  zero, it is a   check on calculations
$1,414 <-12 mths 4.51%
Adjusted EBITDA $485 $441 $509 $423 $482 $520 $551 $646 $1,029 $955 $1,124 $1,353 $1,500 $1,233 206.80% <-Total Growth 10 Debt
Change -9.07% 15.42% -16.90% 13.95% 7.88% 5.96% 17.24% 59.29% -7.19% 17.70% 20.37% 10.88% -17.80% 14.68% <-Median-> 10 Change
Margin 27.56% 26.08% 39.43% 30.37% 39.25% 41.57% 45.39% 61.76% 82.39% 55.75% 62.76% 77.01% 55.32% #DIV/0! 50.57% <-Median-> 10 Margin
Type
Long Term Debt $1,364 $1,452 $1,640 $1,181 $987 $1,276 $1,308 $1,907 $2,191 $2,556 $3,135 $3,586 $4,217 $3,863 157.13% <-Total Growth 10 Debt Lg Term R
Change -7.34% 6.45% 12.95% -27.99% -16.43% 29.28% 2.51% 45.80% 14.89% 16.66% 22.65% 14.39% 17.60% -8.39% 15.78% <-Median-> 10 Change Intang/GW
Debt/Market Cap Ratio 1.86 0.98 1.03 0.69 0.45 0.74 0.59 0.75 0.81 0.71 0.84 0.78 0.78 0.80 0.74 <-Median-> 10 Debt/Market Cap Ratio Liquidity
Assets/Current Liabilities Ratio 7.50 13.14 16.40 8.60 6.19 9.27 11.06 10.85 8.45 6.00 7.75 7.53 4.58 6.13 8.10 <-Median-> 10 Assets/Current Liab Ratio Liq. + CF
Debt to Cash Flow (Years) 3.69 3.15 6.78 2.38 2.52 3.05 3.49 5.13 4.87 3.55 5.13 4.14 4.51 3.83 3.84 <-Median-> 10 Debt to Cash Flow (Years) Debt Ratio
Leverage
Intangibles $203 $296 $316 $310 $350 $341 $299 $401 $473 $760 $738 $749 $782 $709 147.47% <-Total Growth 10 Intangibles D/E Ratio
Goodwill $139 $46 $22 $23 $25 $30 $23 $35 $35 $35 $35 $35 $35 $35 59.09% <-Total Growth 10 Goodwill
Total $342 $342 $338 $333 $375 $371 $322 $436 $508 $795 $773 $784 $817 $744 141.72% <-Total Growth 10 Total
Change 5.56% 0.00% -1.17% -1.48% 12.61% -1.07% -13.21% 35.40% 16.51% 56.50% -2.77% 1.42% 4.21% -8.94% 2.82% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.47 0.23 0.21 0.19 0.17 0.21 0.14 0.17 0.19 0.22 0.21 0.17 0.15 0.15 0.18 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $554 $408 $526 $441 $492 $535 $554 $542 $921 $868 $1,157 $1,186 $1,686 $1,218 220.53% <-Total Growth 10 Current Assets
Current Liabilities $696 $361 $313 $607 $875 $582 $548 $636 $906 $1,439 $1,150 $1,205 $2,212 $1,550 606.71% <-Total Growth 10 Current Liabilities
Liquidity Ratio 0.80 1.13 1.68 0.73 0.56 0.92 1.01 0.85 1.02 0.60 1.01 0.98 0.76 0.79 0.89 <-Median-> 10 Ratio
Liq. with CF aft div 0.75 0.94 1.31 0.62 0.50 0.74 0.80 0.67 0.85 0.97 1.30 1.42 1.06 1.22 1.06 <-Median-> 5 Ratio
Liq. with CF aft div (WC) 1.27 2.20 2.30 1.32 0.94 1.41 1.37 1.25 1.37 0.99 1.40 1.42 1.03 1.22
Liq. CF re  Inv+Div  -0.01 0.37 0.52 0.67 -0.86 0.15 0.38 0.20 0.70 -0.12 0.15 -1.44 0.05 1.16 0.05 <-Median-> 5 Ratio
Curr Long Term Debt $235 $28 $19 $346 $599 $339 $200 $239 $456 $857 $417 $378 $733 $581 $456.0 <-Median-> 5 Ratio
Liquidity Less CLTD 1.20 1.23 1.79 1.69 1.78 2.20 1.59 1.37 2.05 1.49 1.58 1.43 1.14 1.26 1.49 <-Median-> 5 Ratio
Liq. with CF aft div 1.85 2.13 2.01 2.58 2.29 2.51 1.88 1.62 2.19 2.04 1.88 1.92 1.51 1.79 1.92 <-Median-> 5 Ratio
Assets $5,217 $4,743 $5,134 $5,219 $5,420 $5,393 $6,062 $6,898 $7,660 $8,630 $8,911 $9,073 $10,135 $9,499 97.41% <-Total Growth 10 Assets
Liabilities $2,639 $2,148 $2,382 $2,215 $2,417 $2,577 $3,161 $3,836 $4,541 $5,529 $5,982 $6,214 $7,675 $6,722 222.21% <-Total Growth 10 Liabilities
Debt Ratio 1.98 2.21 2.16 2.36 2.24 2.09 1.92 1.80 1.69 1.56 1.49 1.46 1.32 1.41 1.74 <-Median-> 10 Ratio
Estimates BVPS $22.50 $23.20 $22.90 Estimates Estimates BVPS
Estimate Book Value $2,629.9 $2,711.8 $2,676.7 Estimates Estimate Book Value
P/B Ratio (Close) 1.84 1.78 1.80 Estimates P/B Ratio (Close)
Difference from 10 year median 113.12% Diff M/C Estimates Difference from 10 yr med.
Book Value $2,578 $2,595 $2,752 $3,004 $3,003 $2,816 $2,901 $3,062 $3,119 $3,101 $2,929 $2,859 $2,460 $2,777 -10.61% <-Total Growth 10 Book Value
NCI $1,754 $1,072 $829 $587 $552 $68 $58 $48 $43 $37 $29 $18 $6 $0 -99.28% <-Total Growth 10 NCI
Book Value $824 $1,523 $1,923 $2,417 $2,451 $2,748 $2,843 $3,014 $3,076 $3,064 $2,900 $2,841 $2,454 $2,777 27.61% <-Total Growth 10 Book Value
Book Value per share $26.60 $25.83 $27.49 $29.88 $29.37 $28.22 $29.57 $28.89 $30.19 $29.08 $27.31 $24.45 $20.99 $23.76 -23.62% <-Total Growth 10 Book Value per Share
P/B Ratio (Median) 0.86 0.94 0.85 0.71 0.84 0.75 0.69 0.86 0.86 1.06 1.08 1.60 2.13 1.81 0.86 P/B Ratio
Preference Shares $122 $122 $268 $464 $464 $464 $660 $807 $807 $953 $953 $753 $753 $753 180.97% <-Total Growth 10 Preferred Shares
Net Book Value $702 $1,401 $1,655 $1,953 $1,987 $2,284 $2,183 $2,207 $2,269 $2,111 $1,947 $2,088 $1,701 $2,024 $2,024 $2,024 2.78% <-Total Growth 10 Net Book Value
Book Value per share $22.66 $23.76 $23.66 $24.14 $23.81 $23.45 $22.70 $21.16 $22.27 $20.03 $18.34 $17.97 $14.55 $17.32 $17.32 $17.32 -38.49% <-Total Growth 10 Book Value per Share
Increase 0.79% 4.85% -0.42% 2.05% -1.39% -1.48% -3.20% -6.81% 5.27% -10.06% -8.46% -2.00% -19.02% 18.99% 0.00% 0.00% 131.78% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.01 1.02 0.98 0.88 1.03 0.90 0.90 1.17 1.17 1.54 1.61 2.18 3.07 2.49 0.00 0.00 1.03 P/B Ratio Historical Median
P/B Ratio (Close) 1.04 1.06 0.96 0.88 1.09 0.76 1.02 1.16 1.19 1.72 1.91 2.20 3.18 2.39 2.39 2.39 -4.74% <-IRR #YR-> 10 Book Value per Share -38.49%
Change 9.81% 1.30% -9.13% -8.18% 23.79% -30.63% 35.05% 13.13% 3.14% 43.80% 11.12% 15.11% 44.98% -25.05% 0.00% 0.00% -7.21% <-IRR #YR-> 5 Book Value per Share -31.22%
Median 10 year P/B Ratio 0.97 1.01 1.00 0.98 1.00 0.98 0.96 0.98 1.00 1.02 1.03 1.10 1.17 1.35 1.35 1.35
Leverage (A/BK) 7.43 3.39 3.10 2.67 2.73 2.36 2.78 3.13 3.38 4.09 4.58 4.35 5.96 4.69 0.00 0.00 4.35 <-Median-> 5 A/BV
Debt/Equity Ratio 3.76 1.53 1.44 1.13 1.22 1.13 1.45 1.74 2.00 2.62 3.07 2.98 4.51 3.32 0.00 0.00 2.98 <-Median-> 5 Debt/Eq Ratio
Shareholders' Equity (Assets less Liabilities) P/B Ratios 10 yr Med 1.17 5 yr Med 1.61 103.64% Diff M/C 3.38 Historical Leverage (A/BK)
-$23.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.55
-$21.16 $0.00 $0.00 $0.00 $0.00 $14.55
$235.00 <-12 mths 389.58%
Total Comprehensive Income $80 $189 $116 $186 $90 $130 $76 $19 $365 $57 $69 $60 $38
NCI $75 $110 $42 $41 $14 -$2 -$9 -$10 -$7 -$6 -$6 -$11 -$10
Shareholders $5 $79 $74 $145 $76 $132 $85 $29 $372 $63 $75 $71 $48 -35.14% <-Total Growth 10 Comprehensive Income
Increase -79.17% 1480.00% -6.33% 95.95% -47.59% 73.68% -35.61% -65.88% 1182.76% -83.06% 19.05% -5.33% -32.39% -5.33% <-Median-> 5 Comprehensive Income
5 Yr Running Average $65 $76 $101 $102 $93 $139 $136 $125 $122 $126 -4.24% <-IRR #YR-> 10 Comprehensive Income -35.14%
ROE 0.7% 5.6% 4.5% 7.4% 3.8% 5.8% 3.9% 1.3% 16.4% 3.0% 3.9% 3.4% 2.8% 10.60% <-IRR #YR-> 5 Comprehensive Income 65.52%
5Yr Median 4.9% 4.5% 5.6% 4.5% 3.9% 3.9% 3.9% 3.9% 3.4% 3.4% 7.54% <-IRR #YR-> 9 5 Yr Running Average #DIV/0!
% Difference from Net Income -54.5% 2.6% 19.4% -17.1% 65.2% 46.7% -23.4% -79.9% 35.8% -49.6% -44.9% -27.6% -65.2% 6.14% <-IRR #YR-> 5 5 Yr Running Average 34.69%
Median Values Diff 5, 10 yr -25.5% -44.9% 3.4% <-Median-> 5 Return on Equity
-$74.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $48.0
-$29.0 $0.0 $0.0 $0.0 $0.0 $48.0
-$65.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $125.8
-$93.4 $0.0 $0.0 $0.0 $0.0 $125.8
Current Liability Coverage Ratio 0.53 1.41 1.24 0.79 0.49 0.82 0.73 0.72 0.62 0.52 0.65 0.71 0.39 0.65   CFO / Current Liabilities
5 year Median 0.38 0.53 0.88 0.79 0.79 0.82 0.79 0.73 0.72 0.72 0.65 0.65 0.62 0.65 0.68 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 7.07% 10.73% 7.56% 9.22% 7.99% 8.84% 6.57% 6.65% 7.30% 8.68% 8.38% 9.48% 8.54% 10.62% CFO / Total Assets
5 year Median 5.16% 7.07% 7.32% 7.56% 7.99% 8.84% 7.99% 7.99% 7.30% 7.30% 7.30% 8.38% 8.54% 8.68% 8.5% <-Median-> 10 Return on Assets 
Return on Assets ROA 0.21% 1.62% 1.21% 3.35% 0.85% 1.67% 1.83% 2.09% 3.58% 1.45% 1.53% 1.08% 1.36% 6.74% Net  Income/Assets Return on Assets
5Yr Median 0.31% 0.42% 0.81% 1.21% 1.21% 1.62% 1.67% 1.83% 1.83% 1.83% 1.83% 1.53% 1.45% 1.45% 1.6% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 1.57% 5.50% 3.75% 8.96% 2.32% 3.94% 5.08% 6.52% 12.08% 5.92% 6.99% 4.69% 8.11% 31.62% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 2.93% 4.29% 4.02% 4.29% 3.75% 3.94% 3.94% 5.08% 5.08% 5.92% 6.52% 6.52% 6.99% 6.99% 6.2% <-Median-> 10 Return on Equity
$309 <-12 mths 123.91%
Net Income $137 $188 $90 $228 $50 $86 $102 $134 $267 $119 $130 $87 $128
NCI $126 $111 $28 $53 $4 -$4 -$9 -$10 -$7 -$6 -$6 -$11 -$10
Shareholders $11 $77 $62 $175 $46 $90 $111 $144 $274 $125 $136 $98 $138 $640 $358 $214 122.58% <-Total Growth 10 Net Income
Increase -47.62% 600.00% -19.48% 182.26% -73.71% 95.65% 23.33% 29.73% 90.28% -54.38% 8.80% -27.94% 40.82% 363.77% -44.06% -40.22% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $69.2 $74.2 $90.0 $96.8 $113.2 $133.0 $149 $158 $155 $154 $227.4 $274.0 $289.6 8.33% <-IRR #YR-> 10 Net Income 122.58%
Operating Cash Flow $370 $461 $242 $497 $391 $419 $375 $372 $450 $720 $611 $867 $935 -0.85% <-IRR #YR-> 5 Net Income -4.17%
Investment Cash Flow -$503 -$985 -$466 -$348 -$230 -$136 -$253 -$1,114 -$554 -$866 -$349 -$585 -$910 9.31% <-IRR #YR-> 9 5 Yr Running Average #DIV/0!
Total Accruals $144 $601 $286 $26 -$115 -$193 -$11 $886 $378 $271 -$126 -$184 $113 6.38% <-IRR #YR-> 5 5 Yr Running Average 36.22%
Total Assets $5,217 $4,743 $5,134 $5,219 $5,420 $5,393 $6,062 $6,898 $7,660 $8,630 $8,911 $9,073 $10,135 Balance Sheet Assets
Accruals Ratio 2.76% 12.67% 5.57% 0.50% -2.12% -3.58% -0.18% 12.84% 4.93% 3.14% -1.41% -2.03% 1.11% 1.11% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.04 0.18 0.15 0.35 0.05 0.14 0.22 0.24 0.41 0.10 0.11 0.05 0.11 0.13 <-Median-> 10 EPS/CF Ratio
-$62.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $138.0
-$144.0 $0.0 $0.0 $0.0 $0.0 $138.0
-$69.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $154.2
-$113.2 $0.0 $0.0 $0.0 $0.0 $154.2
Change in Close 10.67% 6.22% -9.51% -6.29% 22.07% -31.65% 30.73% 5.42% 8.57% 29.33% 1.72% 12.81% 17.41% -10.81% 0.00% 0.00% Count 14 Years of data
up/down Count 0 0.00%
Meet Prediction? % right Count 0 #DIV/0!
Financial Cash Flow $140 $541 $205 -$101 -$191 -$280 -$102 $697 $2,363 $218 -$146 -$275 -$102 C F Statement  Financial Cash Flow
Total Accruals $4 $60 $81 $127 $76 $87 $91 $189 -$1,985 $53 $20 $91 $215 Accruals
Accruals Ratio 0.08% 1.27% 1.58% 2.43% 1.40% 1.61% 1.50% 2.74% -25.91% 0.61% 0.22% 1.00% 2.12% 0.61% <-Median-> 5 Ratio
Cash $56 $73 $53 $100 $71 $80 $98 $52 $182 $248 $367 $387 $307 $103 Cash
Cash per Share $1.81 $1.24 $0.76 $1.24 $0.85 $0.82 $1.02 $0.50 $1.79 $2.35 $3.46 $3.33 $2.63 $0.88 $2.63 <-Median-> 5 Cash per Share
Percentage of Stock Price 7.64% 4.93% 3.33% 5.80% 3.27% 4.62% 4.39% 2.04% 6.72% 6.84% 9.88% 8.44% 5.67% 2.13% 6.84% <-Median-> 5 % of Stock Price
Notes:
August 19, 2023.  Last estimates were for 2022, 2023 and 2024 of $2167M, $1947M and $2296M for Revenue, $3.16, $2.78 and $3.03 for AEPS, $6.25 and 6.16 for 2022/3 for AFFO, 
$2.96, $2.26 and $3.44 for EPS, $2.25, $2.37 and $2.47 for Dividends, $570M, $530M and $4.85M for FCF, $9.20, $7.71 and $8.45 fpr CFPS, and $358M, $317M for 2022/3 for Net Income.
August 21, 2022.  Last estimates were for 2021, $2022 and 2023 of $1876M, $1865M and $2037M for Revenue, $1.99, $1.89 and $2.71 for EPS, 
$2.11, $2.23 and $2.31 for Dividends, $558M, $446M and $523M for FCF, $6.85, $6.71 and $6.85 for CFPS, $235M and $217M for 2021-22 for Net Income.
August 21, 2021.  Last estimates were for 2020, 2021 and 2022 of $1798M $1712M and $1775M for Revenue, $1.02, $1.38 and $2.68 for EPS, 
$1.98, $2.11 and $2.20 for Div., $456M, $519M and $583M for FCF, $6.10, $6.32 and $6.27 for CFPS and $106M, $147M and $282M for Net Income.
August 2020.  Started Spreadsheet
Capital Power became a company through an Initial Public Offering (IPO), and the power generating assets and business of EPCOR were moved to 
Capital Power as a new, separate, independent, and publicly traded company.  Capital Power commenced trading on the TSX, and its new era as a 
North American wholesale power generator, on July 9, 2009
Edmonton Power Corporation (EPCOR)
Initial Public Offering in 2009, Capital Power 
Sector:
Utilities, Infrastructure
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock. 
Capital power Corp is in John Heinzl's yield Hog model portfolio.  
In Money Sense annual list of the 100 best dividend stocks or 2021, this stock was rated an A.
Why I bought this stock.
Dividends
Dividends are paid quarterly in Cycle 1 of January, April, July and October.  Dividends are declared in one month for shareholders of record of the following month and paid in the next month.
For example, the dividends declared on February 21, 2020 are for shareholders of record of March 31, 2020 and is payble on April 30, 2020.
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.
Capital Power Corp is a North American power producer whose principal activities are developing, acquiring, and operating power plants. Through its subsidiary, 
Capital Power owns and operates a portfolio of natural gas, coal, wind, solar, and solid fuel energy generating facilities. These are located throughout Western and Central Canada and the U.S.
Shares; '%, Value $M Years Div. Gth Tot Ret Cap Gain Div. Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M   Change
Date 5 7.20% 11.31% 5.75% 5.55% 11.30% 2019 Sep 14 2020 Aug 21 2021 Aug 21 2022 Aug 19 2023
Dey, Avik 10 3.94% 10.30% 4.87% 5.42% 10.29% 0.000 0.00% #DIV/0!
CEO - Shares - Amount $0.000
Options - percentage Years Div. Gth Tot Ret Cap Gain Div. 0.116 0.10% #DIV/0!
Options - amount 5 6.73% 22.01% 14.51% 7.51% 22.02% $4.776
10 4.48% 9.28% 3.99% 5.28% 9.28%
Vaasjo, Brian Tellef 11 4.06% 10.09% 4.58% 5.51% 10.09% 0.128 0.12% 0.128 0.12% 0.128 0.11% 0.132 0.11%
CEO - Shares - Amount $4.409 $4.484 $5.058 $6.103
Options - percentage Years Div. Gth Tot Ret Cap Gain Div. check 1.767 1.68% 1.679 1.58% 1.427 1.23% 1.277 1.09%
Options - amount 5 6.67% 17.63% 11.18% 6.45% 17.63% $60.762 $58.724 $56.305 $59.159
10 5.17% 9.71% 4.62% 5.09% 9.71%
Haskins, Sandra Anne 12 4.29% 10.61% 5.24% 5.37% 10.61% 0.000 0.00% 0.003 0.00% 0.005 0.00% 0.009 0.01% 0.008 0.01% -5.27%
CFO - Shares - Amount $0.000 $0.090 $0.182 $0.413 $0.349
Options - percentage Years Div. Gth Tot Ret Cap Gain Div. check 0.000 0.00% 0.038 0.04% 0.060 0.05% 0.087 0.07% 0.119 0.10% 36.19%
Options - amount 5 6.59% 19.88% 13.60% 6.28% 19.88% $0.000 $1.338 $2.370 $4.050 $4.919
10 5.84% 12.72% 7.38% 5.34% 12.72%
DeNeve, Bryan 13 4.46% 11.28% 6.13% 5.15% 11.28% 0.025 0.02% 0.036 0.03% 0.039 0.03% 0.039 0.03% 0.037 0.03% used to be CFO -6.34%
Officer - Shares - Amount $0.857 $1.277 $1.557 $1.828 $1.527
Options - percentage 0.399 0.38% 0.399 0.38% 0.279 0.24% 0.175 0.15% 0.190 0.16% 8.61%
Options - amount $13.710 $13.961 $11.015 $8.118 $7.864
Chisholm, Burness Kathryn 0.019 0.02% 0.022 0.02% 0.025 0.02% 0.027 0.02% 0.027 0.02% Last updated Mar 2023 0.00%
Officer - Shares - Amount $0.640 $0.779 $0.989 $1.262 $1.126
Options - percentage 0.382 0.36% 0.390 0.37% 0.316 0.27% 0.301 0.26% 0.300 0.26% -0.60%
Options - amount $13.144 $13.637 $12.464 $13.964 $12.380
Perry, Barry 0.026 0.02% 0.026 0.02% Added because he owns shares 0.00%
Director - Shares - Amount $1.205 $1.074
Options - percentage 0.002 0.00% 0.004 0.00% 127.77%
Options - amount $0.077 $0.157
Beneby, Doyle Nolan 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Director - Shares - Amount $0.000 $0.000 $0.000 $0.000 $0.000
Options - percentage 0.033 0.03% 0.038 0.04% 0.048 0.04% 0.056 0.05% 0.064 0.06% 14.83%
Options - amount $1.132 $1.342 $1.898 $2.599 $2.662
Graham Carolyn Joan 0.001 0.00%
Chairman - Shares - Amt $0.051
Options - percentage 0.000 0.00%
Options - amount $0.000
Gardiner, Jill 0.007 0.01% 0.007 0.01% 0.007 0.01% 0.006 0.00% -14.91%
Chairman - Shares - Amt $0.235 $0.265 $0.311 $0.236
Options - percentage 0.019 0.02% 0.024 0.02% 0.030 0.03% 0.036 0.03% 21.59%
Options - amount $0.669 $0.952 $1.379 $1.496
Increase in O/S Shares 0.546 0.54% 1.029 0.99% 0.749 0.71% 0.889 0.76% 0.693 0.59%
Due to Stock Options $18.767 $35.399 $26.205 $35.063 $32.105
Book Value $14.000 $25.000 $19.000 $23.000 $17.000
Insider Buying -$0.631 -$0.396 -$0.570 -$0.391 -$1.175
Insider Selling $9.097 $2.402 $26.282 $19.336 $3.268
Net Insider Selling $8.465 $2.007 $25.712 $18.945 $2.094
Net Selling % of Market Cap 0.23% 0.05% 0.56% 0.35% 0.04%
Directors 9 9 10 10
Women 4 44% 4 44% 4 40% 4 40%
Minorities 1 11% 1 11% 1 10% 2 20%
Institutions/Holdings 20 16.10% 20 11.62% 20 16.36%
Total Shares Held 18.458 15.89% 13.539 11.58% 19.137 16.37%
Increase/Decrease 3 Mths -0.606 -3.18% -0.073 -0.54% -1.255 -6.15%
Starting No. of Shares 19.064 13.612 20.392