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.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ Q1 2017
Algonquin Power & Utilities Corp TSX: AQN NYSE AQN http://www.algonquinpower.com/  Fiscal Yr: Dec 31
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 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 Value Description #Y Item Currency Total G
Accting Rules C GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP
USD - CDN$ 1.1659 1.1653 0.9881 1.2246 1.0466 0.9946 1.0170 0.9949 1.0636 1.1601 1.3847 1.3427 1.3453 1.3453 1.3453 15.22% <-Total Growth 10 Currency
Change -3.13% -0.05% -15.21% 23.93% -14.54% -4.97% 2.25% -2.17% 6.91% 9.07% 19.36% -3.04% 0.19% 0.00% 0.00% 1.43% <-IRR #YR-> 10 USD - CDN$
5 year Running Average 1.3668 1.2813 1.1630 1.1495 1.1181 1.0838 1.0542 1.0555 1.0233 1.0460 1.1241 1.1892 1.2593 1.3156 1.3527 5.71% <-IRR #YR-> 5 USD - CDN$
$1,312.2 <-12 mths 19.72%
Revenue* $179.3 $193.2 $186.2 $213.8 $187.3 $182.9 $276.6 $369.9 $675.3 $943.6 $1,027.9 $1,096.0 $2,150 $2,271 $2,174 467.17% <-Total Growth 10 Revenue CDN$
Increase 11.71% 7.76% -3.66% 14.84% -12.41% -2.34% 51.27% 33.71% 82.57% 39.73% 8.93% 6.63% 96.16% 5.63% -4.27% 18.95% <-IRR #YR-> 10 Revenue CDN$ 467.17%
5 year Running Average $126.8 $156.4 $174.7 $186.6 $192.0 $192.7 $209.4 $246.1 $338.4 $489.7 $658.6 $822.5 $1,178.5 $1,497.7 $1,743.8 31.70% <-IRR #YR-> 5 Revenue CDN$ 296.19%
Revenue per Share $2.57 $2.65 $2.53 $2.76 $2.01 $1.92 $2.03 $1.96 $3.27 $3.96 $4.02 $4.00 $5.59 $5.90 $5.65 18.06% <-IRR #YR-> 10 5 yr Running Average CDN$ 425.86%
Increase 11.71% 3.06% -4.67% 9.02% -26.99% -4.75% 6.04% -3.58% 67.01% 21.07% 1.39% -0.46% 39.77% 5.63% -4.27% 31.48% <-IRR #YR-> 5 5 yr Running Average CDN$ 292.89%
5 year Running Average $1.89 $2.24 $2.47 $2.56 $2.50 $2.37 $2.25 $2.14 $2.24 $2.63 $3.05 $3.44 $4.17 $4.69 $5.03 4.19% <-IRR #YR-> 10 Revenue per Share CDN$ 50.80%
P/S (Price/Sales) Med 3.87 4.06 3.33 1.86 1.54 2.30 2.77 3.23 2.20 2.16 2.47 2.85 14.50% <-IRR #YR-> 5 Revenue per Share CDN$ 96.77%
P/S (Price/Sales) Close 4.06 3.74 3.33 0.84 2.03 2.62 3.16 3.49 2.24 2.43 2.72 2.85 2.49 2.36 2.47 4.39% <-IRR #YR-> 10 5 yr Running Average CDN$ 53.72%
P/S (Price/Sales) High 4.17 4.17 3.72 2.98 2.03 2.65 3.21 3.56 2.53 2.55 2.82 3.11 8.88% <-IRR #YR-> 5 5 yr Running Average CDN$ 53.05%
P/S (Price/Sales) Low 3.57 3.96 2.94 0.75 1.05 1.96 2.34 2.90 1.86 1.78 2.12 2.60 2.90 <-Median-> 10 P/S High CDN$
*Revenue in M CDN $  P/S Med 10 Yrs 2.38 5Yrs 2.47 4.65% Diff M/C 2.04 <-Median-> 10 P/S Low CDN$
-$193.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,096.0
-$276.6 $0.0 $0.0 $0.0 $0.0 $1,096.0
-$156.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $822.5
-$209.4 $0.0 $0.0 $0.0 $0.0 $822.5
-$2.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.00
-$2.03 $0.00 $0.00 $0.00 $0.00 $4.00
-$2.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.44
-$2.25 $0.00 $0.00 $0.00 $0.00 $3.44
$0.61 <-12 mths 7.02%
$355.80
AFFO* $0.57 $0.44 $0.54 $0.42 $0.72 $0.92 $1.15 $1.30 127.75% <-Total Growth 7 AFFO CDN$
Adjusted Net Earnings $0.37 $0.24 $0.33 $0.12 $0.27 $0.37 $0.26 $0.57 54.05% <-Total Growth 7 Adjusted EPS CDN$
Increase 37.50% -63.64% 125.00% 37.04% -29.73% 119.23% 6.37% <-IRR #YR-> 7 Adjusted EPS CDN$ #DIV/0!
Adjusted EPS Yield 1.0% 1.0% 0.2% 0.3% 1.2% 1.0% 2.2% 11.55% <-IRR #YR-> 5 Adjusted EPS CDN$ 72.73%
5 year Running Average $0.27 $0.27 $0.27 $0.32 6.13% <-IRR #YR-> 3 5 yr Running Average CDN$ #DIV/0!
Payout Ratio 64.86% 83.33% 78.79% 239.58% 120.37% 96.35% 195.78% 95.26% 6.13% <-IRR #YR-> 3 5 yr Running Average CDN$ #DIV/0!
Price/AEPS Median 8.38 18.38 17.08 52.71 26.61 23.15 38.10 20.02 21.58 <-Median-> 8 Price/AEPS Median CDN$
Price/AEPS High 11.05 21.13 19.76 58.08 30.67 27.27 43.50 21.81 24.54 <-Median-> 8 Price/AEPS High CDN$
Price/AEPS Low 5.70 15.63 14.39 47.33 22.56 19.03 32.69 18.23 18.63 <-Median-> 8 Price/AEPS Low CDN$
Price/AEPS Close 11.05 20.92 19.45 57.00 27.19 26.05 41.96 19.98 23.49 <-Median-> 8 Price/AEPS Close CDN$
Trailing P/AEPSClose 13.57 26.75 20.73 61.17 35.70 29.49 43.81 29.49 <-Median-> 7 Trailing P/AEPSClose CDN$
Median Values DPR 10 Yrs 95.81% 5 Yrs   120.37% P/CF 5 Yrs   in order 26.61 30.67 22.56 27.19 -100.00% Diff M/C -100.00% Diff M/C 10 DPR 75% to 95% best CDN$
* Adjusted Earnings per Share
-$0.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.57
-$0.33 $0.00 $0.00 $0.00 $0.00 $0.57
-$0.27 $0.00 $0.00 $0.32
-$0.27 $0.00 $0.00 $0.32
$0.37 <-12 mths -15.91%
EPS Basic $0.31 $0.39 $0.32 -$0.03 $0.39 $0.21 $0.20 $0.09 $0.07 $0.31 $0.42 $0.44 12.82% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* $0.31 $0.39 $0.31 -$0.25 $0.39 $0.21 $0.20 $0.09 $0.07 $0.31 $0.42 $0.44 $0.63 $0.70 $0.61 12.82% <-Total Growth 10 EPS Diluted CDN$
Increase -6.06% 25.81% -20.51% -180.65% -256.00% -46.15% -4.76% -55.00% -22.22% 342.86% 35.48% 4.76% 43.18% 11.11% -12.86% 1.21% <-IRR #YR-> 10 Earnings per Share CDN$ 12.82%
Earnings Yield 3.0% 3.9% 3.7% -10.8% 9.5% 4.2% 3.1% 1.3% 1.0% 3.2% 3.8% 3.9% 4.5% 5.0% 4.4% 17.08% <-IRR #YR-> 5 Earnings per Share CDN$ 120.00%
5 year Running Average $0.35 $0.39 $0.40 $0.22 $0.23 $0.21 $0.17 $0.13 $0.19 $0.18 $0.22 $0.27 $0.37 $0.50 $0.56 -3.85% <-IRR #YR-> 10 5 yr Running Average CDN$ -32.49%
10 year Running Average $0.30 $0.37 $0.31 $0.31 $0.28 $0.28 $0.26 $0.21 $0.20 $0.21 $0.22 $0.25 $0.35 $0.37 9.11% <-IRR #YR-> 5 5 yr Running Average CDN$ 54.65%
* Diluted ESP per share  E/P 10 Yrs 3.45% 5Yrs 3.22%
-$0.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.44
-$0.20 $0.00 $0.00 $0.00 $0.00 $0.44
-$0.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.27
-$0.17 $0.00 $0.00 $0.00 $0.00 $0.27
DRIP shares issued 2.26 3.23 2.32 DRIP CDN$
DRIP Dividends $7.34 $13.97 $17.40 $29.30 $33.86 DRIP Dividends CDN$
As a % of dividends paid in cash 19.89% 26.69% 30.07% 37.03% 28.66% As a % of dividends paid in cash CDN$
As a % of total dividends 16.59% 21.07% 23.12% 27.03% 22.28% As a % of total dividends CDN$
Actual Dividends Paid in Cash $64.06 $64.33 $67.42 $66.11 $19.04 $18.90 $28.58 $36.92 $52.34 $57.85 $79.12 $118.15 83.65% <-Total Growth 10 Cash Dividends Paid CDN$
Increase 1.09% 0.42% 4.79% -1.94% -71.19% -0.75% 51.22% 29.16% 41.76% 10.53% 36.77% 49.32% 19.85% <-Median-> 10 Increase CDN$
Dividends 5 Yr Running $61.87 $64.32 $65.06 $56.19 $47.16 $40.01 $33.91 $31.16 $38.92 $50.96 $68.87 11.32% <-Total Growth 10 Dividends 5 Yr Running CDN$
Payout Ratio to Net Income 294.02% 230.12% 284.80% -347.24% 60.92% 96.24% 122.24% 254.04% 257.86% 76.42% 73.89% 98.03% 97.13% <-Median-> 10 Payout Ratio to Net Income CDN$
DPR Net Income 5 Yr Running 232.24% 228.52% 421.47% 328.09% 282.45% 253.52% 243.01% 142.78% 126.72% 105.73% 101.84% 235.76% <-Median-> 10 DPR Net Income 5 Yr Running CDN$
Payout Ratio CFPS 115.05% 92.79% 166.76% 85.61% 38.07% 41.83% 41.01% 58.61% 52.90% 30.02% 30.21% 41.13% 41.48% <-Median-> 10 Payout Ratio CFPS CDN$
DPR CF 5 Yr Running 108.10% 110.80% 105.19% 95.99% 83.56% 70.80% 55.57% 47.67% 41.44% 37.13% 38.10% 63.19% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 100.71% 91.53% 94.72% 92.47% 37.10% 42.52% 40.12% 55.21% 35.66% 29.74% 28.98% 41.67% 40.89% <-Median-> 10 Payout Ratio CFPS WC CDN$
DPR CF WC 5 Yr Running 105.79% 99.57% 96.83% 85.69% 76.38% 64.60% 55.52% 40.93% 37.15% 33.87% 35.70% 60.06% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median Values 6.27% <-IRR #YR-> 10 Dividends CDN$ #DIV/0!
* Dividends less DRIP 5 Yr Med Payout 98.03% 41.13% 35.66% 32.82% <-IRR #YR-> 5 Dividends CDN$ #DIV/0!
-$64.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $118.15
-$28.58 $0.00 $0.00 $0.00 $0.00 $118.15
Dividends declared $0.79 $0.79 $0.93 $0.61 $0.23 $0.24 $0.27 $0.30 $0.31 $0.32 $0.38 $0.41
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 <-Median-> 10 Special Dividends US$
Dividends paid* $0.79 $0.79 $0.93 $0.72 $0.23 $0.20 $0.26 $0.29 $0.31 $0.31 $0.37 $0.40 $0.47 $0.47 $0.47 -48.73% <-Total Growth 10 Dividends US$
Increase 3.23% 0.05% 17.93% -22.53% -68.18% -12.31% 27.14% 13.03% 5.74% 0.57% 19.62% 10.01% 15.23% 0.00% 0.00% Count 19 Years of data US$
Dividends 5 Yr Running $0.67 $0.71 $0.80 $0.80 $0.69 $0.57 $0.47 $0.34 $0.26 $0.27 $0.31 $0.33 $0.37 $0.40 $0.43 -52.68% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 9.22% 8.53% 10.92% 17.19% 7.81% 4.65% 4.59% 4.49% 4.38% 4.04% 4.97% 4.80% 4.92% 4.73% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 8.56% 8.31% 9.78% 10.75% 5.94% 3.99% 3.99% 4.12% 3.81% 3.48% 4.49% 4.22% 4.40% 4.17% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 10.00% 8.76% 12.35% 42.84% 11.37% 5.57% 5.38% 4.95% 5.16% 4.81% 5.57% 5.58% 5.58% 5.57% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 8.80% 9.26% 10.93% 31.20% 5.94% 3.99% 4.07% 4.22% 4.47% 3.71% 4.66% 4.77% 4.50% 4.50% 4.50% 4.57% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 296.52% 235.69% 296.52% -353.04% 61.54% 95.24% 130.00% 319.44% 464.29% 115.00% 121.20% 123.41% 99.51% 89.56% 102.77% 122.30% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 209.25% 196.75% 448.49% 314.66% 271.88% 276.37% 263.61% 141.88% 179.10% 193.75% 168.98% 133.15% 108.23% 104.26% 230.18% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 115.05% 94.25% 166.94% 86.03% 38.30% 41.76% 43.54% 72.26% 67.14% 39.58% 49.21% 51.38% 46.10% 41.79% 42.36% 50.30% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 97.63% 94.83% 113.20% 90.98% 78.05% 72.48% 53.96% 52.70% 55.13% 61.86% 58.02% 51.49% 46.24% 45.39% 67.17% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 100.70% 92.98% 94.82% 92.92% 37.33% 42.45% 42.60% 68.06% 45.26% 39.22% 47.20% 52.05% 46.10% 41.79% 42.36% 46.23% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 95.37% 85.62% 104.38% 81.07% 70.98% 65.23% 54.48% 47.54% 50.34% 56.49% 53.88% 48.74% 45.93% 45.18% 60.86% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Dividends paid in US$ from Oct 2014 5 Yr Med 5 Yr Cl 4.49% 4.47% 5 Yr Med Payout 123.41% 51.38% 47.20% -6.46% <-IRR #YR-> 10 Dividends US$ -48.73%
* Dividends per share  5 Yr Med and Cur. 0.09% 0.54% Last Div Inc ---> $0.1059 $0.1165 10.0% 9.61% <-IRR #YR-> 5 Dividends US$ 58.18%
-$0.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.40
-$0.26 $0.00 $0.00 $0.00 $0.00 $0.40
Historical Dividends Historical High Div 27.60% Low Div 3.64% Ave Div 15.62% Med Div 6.39% Close Div 5.35% Historical Dividends
High/Ave/Median Values Curr diff Exp. -83.70%     23.57% Exp. -71.20% Exp. -29.61% Exp. -16.00% High/Ave/Median 
Adjusted Historical Dividends Historical High Div 27.60% Low Div 3.64% Ave Div 15.62% Med Div 6.39% Close Div 5.35% $0.0766 $0.0200 Adjusted Historical Dividends
High/Ave/Median Values Curr diff Cheap -83.70%     23.57% Cheap -71.20% Cheap -29.61% Cheap -16.00% 26.11% -73.89% High/Ave/Median 
Dividends declared $0.92 $0.92 $0.92 $0.75 $0.24 $0.24 $0.27 $0.30 $0.33 $0.37 $0.52 $0.56 -39.53% <-Total Growth 10 Dividends CDN$
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 <-Median-> 10 Special Dividends
Dividends paid* $0.92 $0.92 $0.92 $0.88 $0.24 $0.20 $0.26 $0.29 $0.33 $0.36 $0.51 $0.54 $0.63 $0.63 $0.63 -40.93% <-Total Growth 10 Dividends CDN$
Increase 0.00% 0.00% 0.00% -3.98% -72.81% -16.67% 30.00% 10.58% 13.04% 9.69% 42.78% 6.67% 15.46% 0.00% 0.00% Count 19 Years of data CDN$
Dividends 5 Yr Running $0.89 $0.89 $0.92 $0.91 $0.78 $0.63 $0.50 $0.37 $0.26 $0.29 $0.35 $0.40 $0.47 $0.53 $0.59 -54.52% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 9.22% 8.53% 10.92% 17.19% 7.74% 4.54% 4.61% 4.55% 4.52% 4.16% 5.14% 4.76% 4.93% 4.69% <-Median-> 10 Yield H/L Price CDN$
Yield on High  Price 8.56% 8.31% 9.78% 10.75% 5.87% 3.94% 3.99% 4.12% 3.93% 3.53% 4.50% 4.37% 4.40% 4.25% <-Median-> 10 Yield on High  Price CDN$
Yield on Low Price 10.00% 8.76% 12.35% 42.84% 11.37% 5.33% 5.47% 5.06% 5.34% 5.06% 5.99% 5.23% 5.61% 5.41% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 8.80% 9.26% 10.93% 38.21% 5.87% 3.98% 4.05% 4.20% 4.43% 3.70% 4.67% 4.77% 4.50% 4.50% 4.50% 4.55% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 296.52% 235.69% 296.52% -353.04% 61.54% 95.24% 130.00% 319.44% 464.29% 115.00% 121.20% 123.41% 99.51% 89.56% 102.77% 122.30% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 253.95% 225.55% 229.80% 418.29% 337.41% 301.05% 290.91% 292.20% 136.72% 162.39% 159.45% 151.96% 126.23% 106.49% 104.74% 260.35% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 115.05% 94.25% 166.94% 86.03% 38.30% 41.76% 43.54% 72.26% 67.14% 39.58% 49.21% 51.38% 46.10% 41.79% 42.36% 50.30% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 111.23% 105.24% 110.75% 105.58% 97.56% 86.43% 76.29% 59.81% 50.78% 49.99% 50.91% 52.17% 48.81% 45.50% 45.60% 68.05% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 100.70% 92.98% 94.82% 92.92% 37.33% 42.45% 42.60% 68.06% 45.26% 39.22% 47.20% 52.05% 46.10% 41.79% 42.36% 46.23% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 114.11% 102.80% 100.00% 97.35% 86.93% 78.59% 68.66% 60.39% 45.81% 45.64% 46.49% 48.45% 46.20% 45.20% 45.39% 64.52% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median Values 5 Yr Med 5 Yr Cl 4.55% 4.43% 5 Yr Med Payout 123.41% 51.38% 47.20% -5.13% <-IRR #YR-> 10 Dividends CDN$ -40.93%
* Dividends per share  5 Yr Med and Cur. -1.06% 1.57% Last Div Inc ---> $0.1059 $0.1165 10.0% 15.87% <-IRR #YR-> 5 Dividends CDN$ 108.84%
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.54
-$0.26 $0.00 $0.00 $0.00 $0.00 $0.54
Historical Dividends Historical High Div 14.59% Low Div 3.93% Ave Div 9.26% Med Div 7.87% Close Div 8.26% Historical Dividends CDN$
High/Ave/Median Values Curr diff Exp. -69.18% Exp 14.43% Exp. -51.43% Exp. -42.86% Exp. -45.56% High/Ave/Median  CDN$
Adjusted Historical Dividends Historical High Div 11.19% Low Div 1.92% Ave Div 6.56% Med Div 2.99% Close Div 2.85% $0.0766 $0.0200 Historical Dividends CDN$
High/Ave/Median Values Curr diff Cheap -59.81%     134.23% Cheap -31.39% Cheap 50.41% Cheap 57.59% 26.11% -73.89% High/Ave/Median  CDN$
Future Dividend Yield Div Yd 5.47% earning in 5.00 Years at IRR of 4.00% Div Inc. 21.67% Future Dividend Yield
Future Dividend Yield Div Yd 6.66% earning in 10.00 Years at IRR of 4.00% Div Inc. 48.02% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 8.10% earning in 15.00 Years at IRR of 4.00% Div Inc. 80.09% Future Dividend Yield CDN$
Yield if held 5 yrs 10.85% 9.06% 9.43% 9.12% 2.39% 2.01% 2.41% 3.41% 6.33% 11.50% 11.54% 9.64% 9.91% 8.73% 7.32% 7.73% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 yrs 8.19% 2.39% 2.36% 2.56% 2.95% 3.36% 3.54% 5.11% 5.04% 7.45% 12.21% 20.22% 3.36% <-Median-> 9 Paid Median Price CDN$
Yield if held 15 yrs 3.02% 3.56% 6.01% 5.35% 6.43% 6.48% 6.23% 4.45% <-Median-> 4 Paid Median Price CDN$
Yield if held 20 yrs 5.82% 6.25% #NUM! <-Median-> 0 Paid Median Price CDN$
Cost cover if held 5 years 52.44% 43.80% 47.16% 47.13% 38.57% 31.72% 23.22% 22.21% 25.56% 46.10% 39.41% 35.87% 37.32% 37.05% 34.24% 37.22% <-Median-> 10 Paid Median Price CDN$
Cost cover if held 10 years 83.85% 83.54% 89.74% 68.46% 66.35% 60.69% 52.78% 49.16% 41.98% 50.24% 77.41% 140.70% 66.35% <-Median-> 9 Paid Median Price CDN$
Cost cover if held 15 years 96.03% 97.80% 110.24% 88.38% 90.58% 88.21% 81.93% 96.92% <-Median-> 4 Paid Median Price CDN$
Cost covered if held 20 years 120.74% 127.05% #NUM! <-Median-> 0 Paid Median Price CDN$
Graham No. $6.73 $7.32 $5.88 $5.55 $6.09 $4.16 $4.12 $2.93 $2.53 $5.71 $7.97 $7.86 $10.12 $10.67 $9.96 7.39% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 1.48 1.47 1.43 0.93 0.51 1.06 1.37 2.16 2.84 1.50 1.24 1.45 1.26 1.40 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Hi 1.60 1.51 1.60 1.48 0.67 1.22 1.58 2.38 3.27 1.77 1.42 1.58 1.41 1.58 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 1.37 1.43 1.27 0.37 0.35 0.90 1.15 1.94 2.41 1.23 1.07 1.32 1.10 1.19 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Cl 1.55 1.36 1.43 0.42 0.67 1.21 1.56 2.33 2.90 1.69 1.37 1.45 1.38 1.31 1.40 1.44 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 55.27% 35.70% 43.13% -58.35% -32.87% 20.77% 55.71% 133.38% 190.09% 68.92% 36.83% 44.94% 37.76% 30.69% 40.00% 44.04% <-Median-> 10 Graham Price CDN$
Price Close $10.45 $9.93 $8.41 $2.31 $4.09 $5.02 $6.42 $6.84 $7.34 $9.64 $10.91 $11.39 $13.94 $13.94 $13.94 14.70% <-Total Growth 10 Stock Price CDN$
Increase -1.04% -4.98% -15.31% -72.53% 77.06% 22.74% 27.89% 6.54% 7.31% 31.34% 13.17% 4.40% 22.39% 0.00% 0.00% 1.38% <-IRR #YR-> 10 Stock Price CDN$ 14.70%
P/E 33.71 25.46 27.13 -9.24 10.49 23.90 32.10 76.00 104.86 31.10 25.98 25.89 22.13 19.91 22.85 12.15% <-IRR #YR-> 5 Stock Price CDN$ 77.41%
Trailing P/E 31.67 32.03 21.56 7.45 -16.36 12.87 30.57 34.20 81.56 137.71 35.19 27.12 31.68 22.13 19.91 5.84% <-IRR #YR-> 10 Price & Dividend CDN$
17.00% <-IRR #YR-> 5 Price & Dividend
0.45% <-IRR #YR-> 19 Stock Price
0.61% <-IRR #YR-> 15 Stock Price
7.33% <-IRR #YR-> 19 Price & Dividend
19 and 15 years D.  per yr 6.87% 6.08% 6.69% <-IRR #YR-> 15 Price & Dividend
Median 10, 5 Yrs D.  per yr 4.46% 4.85% % Tot Ret 76.37% 28.53% Price Inc 7.31% P/E:  26.55 31.10 CDN$
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.39
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.39
-$9.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.39
-$6.42 $0.00 $0.00 $0.00 $0.00 $11.39
$0.92 $0.92 $0.92 $0.88 $0.24 $0.20 $0.26 $0.29 $0.33 $0.36 $0.51 $11.93
$0.92 $0.92 $0.92 $0.88 $0.24 $0.20 $0.26 $0.29 $0.33 $0.36 $0.51 $11.93
-$9.93 $0.92 $0.88 $0.24 $0.20 $0.26 $0.29 $0.33 $0.36 $0.51 $11.93
-$6.42 $0.29 $0.33 $0.36 $0.51 $11.93
Price H/L Median $9.97 $10.78 $8.42 $5.14 $3.10 $4.41 $5.64 $6.33 $7.19 $8.57 $9.91 $11.41 $12.71 5.89% <-Total Growth 10 Stock Price CDN$
Increase -0.94% 8.13% -21.86% -39.01% -39.63% 42.26% 27.78% 12.24% 13.60% 19.21% 15.65% 15.19% 11.39% 0.57% <-IRR #YR-> 10 Stock Price CDN$ 5.89%
P/E 32.15 27.63 27.16 -20.54 7.95 21.00 28.18 70.28 102.64 27.63 23.58 25.93 20.17 15.15% <-IRR #YR-> 5 Stock Price CDN$ 102.48%
Trailing P/E 30.20 34.76 21.59 16.56 -12.40 11.31 26.83 31.63 79.83 122.36 31.95 27.17 28.89 4.79% <-IRR #YR-> 10 Price & Dividend CDN$
P/E on Run. 5 yr Ave 28.47 27.35 21.05 23.56 13.48 21.00 32.76 49.41 37.42 48.66 45.44 42.89 33.98 20.39% <-IRR #YR-> 5 Price & Dividend CDN$
P/E on Run. 10 yr Ave 35.44 23.07 16.51 9.90 15.75 19.91 23.96 35.05 42.19 46.29 52.10 50.64 27.63 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D.  per yr 4.22% 5.24% % Tot Ret 88.02% 25.70% Price Inc 15.19% P/E:  26.55 27.63 Count 19 Years of data
-$10.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.41
-$5.64 $0.00 $0.00 $0.00 $0.00 $11.41
-$10.78 $0.92 $0.88 $0.24 $0.20 $0.26 $0.29 $0.33 $0.36 $0.51 $11.95
-$5.64 $0.29 $0.33 $0.36 $0.51 $11.95
High Months Jul Jan Apr Jun Dec Dec Dec Oct May Dec Dec Jul Jun
Price High $10.74 $11.06 $9.40 $8.21 $4.09 $5.07 $6.52 $6.97 $8.28 $10.09 $11.31 $12.43 $14.24 12.39% <-Total Growth 10 Stock Price CDN$
Increase -2.36% 2.98% -15.01% -12.66% -50.18% 23.96% 28.60% 6.90% 18.79% 21.86% 12.09% 9.90% 14.56% 1.17% <-IRR #YR-> 10 Stock Price CDN$ 12.39%
P/E 34.65 28.36 30.32 -32.84 10.49 24.14 32.60 77.44 118.29 32.55 26.93 28.25 22.60 13.77% <-IRR #YR-> 5 Stock Price CDN$ 90.64%
Trailing P/E 32.55 35.68 24.10 26.48 -16.36 13.00 31.05 34.85 92.00 144.14 36.48 29.60 32.36 31.22 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 12.09% P/E:  29.29 32.55 40.17 P/E Ratio Historical High CDN$
-$11.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.43
-$6.52 $0.00 $0.00 $0.00 $0.00 $12.43
Low Months Oct Jun Nov Dec Mar May Jan Apr Oct Jan Mar Jan Jan
Price Low $9.19 $10.49 $7.44 $2.06 $2.11 $3.75 $4.75 $5.68 $6.09 $7.04 $8.50 $10.39 $11.18 -0.95% <-Total Growth 10 Stock Price CDN$
Increase 0.77% 14.15% -29.08% -72.31% 2.43% 77.73% 26.67% 19.58% 7.22% 15.60% 20.74% 22.24% 7.60% -0.10% <-IRR #YR-> 10 Stock Price CDN$ -0.95%
P/E 29.65 26.90 24.00 -8.24 5.41 17.86 23.75 63.11 87.00 22.71 20.24 23.61 17.75 16.95% <-IRR #YR-> 5 Stock Price CDN$ 118.74%
Trailing P/E 27.85 33.84 19.08 6.65 -8.44 9.62 22.62 28.40 67.67 100.57 27.42 24.74 25.41 23.75 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs Price Inc 19.58% P/E:  23.16 23.61 13.08 P/E Ratio Historical Low CDN$
-$10.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.39
Price Close $8.96 $8.52 $8.51 $2.31 $3.86 $5.04 $6.28 $6.85 $6.83 $8.28 $7.88 $8.48 $10.36 $10.36 $10.36 -0.49% <-Total Growth 10 Stock Price US$
Increase 2.16% -4.93% -0.12% -72.86% 67.10% 30.57% 24.60% 9.08% -0.29% 21.23% -4.83% 7.61% 22.17% 0.00% 0.00% -0.05% <-IRR #YR-> 10 Stock Price US$ -0.49%
P/E 33.71 25.46 27.13 -11.32 10.36 23.87 31.93 75.72 103.78 30.99 25.98 25.88 6.19% <-IRR #YR-> 5 Stock Price US$ 35.03%
Trailing P/E 31.67 32.03 21.56 9.13 -16.16 12.85 30.41 34.08 80.72 137.22 35.20 27.11 4.86% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D.  per yr 4.91% 4.68% % Tot Ret 101.00% 43.08% Price Inc 7.61% P/E:  26.55 30.99 10.88% <-IRR #YR-> 5 Price & Dividend US$
-$8.52 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.48
-$6.28 $0.00 $0.00 $0.00 $0.00 $8.48
-$8.52 $0.93 $0.72 $0.23 $0.20 $0.26 $0.29 $0.31 $0.31 $0.37 $8.88
-$6.28 $0.29 $0.31 $0.31 $0.37 $8.88
Price H/L Median $8.55 $9.25 $8.52 $4.19 $2.94 $4.33 $5.58 $6.43 $6.98 $7.61 $7.39 $8.42 $9.48 -8.94% <-Total Growth 10 Stock Price US$
Increase 2.26% 8.18% -7.84% -50.79% -29.93% 47.21% 28.90% 15.34% 8.48% 9.10% -2.89% 13.94% 12.53% -0.93% <-IRR #YR-> 10 Stock Price US$ -8.94%
P/E 32.15 27.63 27.16 -20.54 7.88 20.48 28.35 71.08 105.98 28.48 24.36 25.69 20.23 8.60% <-IRR #YR-> 5 Stock Price US$ 51.03%
Trailing P/E 30.20 34.76 21.59 16.56 -12.30 11.03 27.00 31.99 82.43 126.12 33.01 26.92 28.97 0.22% <-IRR #YR-> 10 Price & Dividend US$
P/E on Run. 5 yr Ave 28.47 27.35 21.05 23.56 13.37 20.48 32.96 49.98 38.64 50.16 46.94 42.50 34.08 10.51% <-IRR #YR-> 5 Price & Dividend US$
P/E on Run. 10 yr Ave 35.44 23.07 16.51 9.82 15.36 20.03 24.23 36.19 43.49 47.82 51.62 50.78 US$
Median 10, 5 Yrs D.  per yr 1.15% 1.91% % Tot Ret 525.96% 18.21% Price Inc 9.10% P/E:  26.43 28.48 Count 14 Years of data
-$9.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.42
-$5.58 $0.00 $0.00 $0.00 $0.00 $8.42
-$9.25 -$0.15 -$0.73 $0.77 $0.23 $0.28 $0.07 $0.07 $0.31 $0.13 $8.46
-$5.58 $0.07 $0.07 $0.31 $0.13 $8.46
High Months Jul Jan Apr Jun Dec Dec Dec Oct May Dec Dec Aug Jun
Price High $9.21 $9.49 $9.51 $6.70 $3.86 $5.04 $6.40 $7.02 $8.03 $8.83 $8.18 $9.59 $10.60 1.04% <-Total Growth 10 Stock Price US$
Increase 0.79% 3.03% 0.23% -29.53% -42.42% 30.57% 26.98% 9.69% 14.39% 9.96% -7.36% 17.24% 10.53% 0.10% <-IRR #YR-> 10 Stock Price US$ 1.04%
P/E 34.65 28.36 30.32 -32.84 10.36 23.87 32.54 77.60 122.01 33.04 26.97 29.26 22.64 8.42% <-IRR #YR-> 5 Stock Price US$ 49.84%
Trailing P/E 37.94 41.57 23.82 32.43 -17.12 12.93 31.58 34.67 97.85 167.22 50.52 39.74 43.54
Median 10, 5 Yrs Price Inc 9.96% P/E:  29.79 33.04
-$9.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.59
-$6.40 $0.00 $0.00 $0.00 $0.00 $9.59
Low Months Oct Jun Nov Dec Mar May Jan Apr Oct Jan Mar Jan Jan
Price Low $7.88 $9.00 $7.53 $1.68 $2.02 $3.61 $4.75 $5.84 $5.92 $6.39 $6.60 $7.25 $8.35 -19.46% <-Total Growth 10 Stock Price US$
Increase 4.03% 14.20% -16.36% -77.66% 19.85% 79.06% 31.58% 22.95% 1.37% 7.94% 3.29% 9.85% 15.17% -2.14% <-IRR #YR-> 10 Stock Price US$ -19.46%
P/E 29.65 26.90 24.00 -8.24 5.41 17.10 24.15 64.56 89.95 23.91 21.76 22.12 17.83 8.83% <-IRR #YR-> 5 Stock Price US$ 52.63%
Trailing P/E 27.85 33.84 19.08 6.65 -8.44 9.21 23.00 29.05 69.96 105.90 29.48 23.18 25.53
Median 10, 5 Yrs Price Inc 7.94% P/E:  23.02 23.91
-$9.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.25
Long Term Debt $1,262.59 $1,477.85 $3,903.34 $4,748.37 Debt CDN$
Change 17.05% 164.12% 21.65% 90.59% <-Median-> 2 Change CDN$
Debt/Market Cap Ratio 0.55 0.53 1.25 0.89 0.55 <-Median-> 3 Debt/Market Cap Ratio CDN$
Goodwill & Intangibles $64.98 $118.24 $139.06 $146.34 $188.46 $371.63 $1,360.49 Intangibles Goodwill CDN$
Change 81.97% 17.61% 5.23% 28.78% 97.20% 266.09% 28.78% <-Median-> 5 Change CDN$
Intangible/Market Cap Ratio 0.07 0.09 0.09 0.06 0.07 0.12 0.25 0.08 <-Median-> 6 Intangible/Market Cap Ratio CDN$
Market Cap $728 $724 $619 $179 $381 $479 $874 $1,291 $1,515 $2,296 $2,792 $3,122 $5,362 $5,362 $5,362 331.41% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 205.833 216.342 256.517 274.077 346.653 33.15% <-Total Growth 3 Diluted
Change 5.11% 18.57% 6.85% 26.48% 6.85% <-Median-> 3 Change
Basic # of Shares in Millions 69.690 71.090 73.420 75.270 79.830 94.340 116.713 158.304 204.351 213.954 253.172 271.832 343.550 343.550 343.550 282.38% <-Total Growth 10 Basic
Change 1.26% 2.01% 3.28% 2.52% 6.06% 18.18% 23.72% 35.64% 29.09% 4.70% 18.33% 7.37% 26.38% 12.77% <-Median-> 10 Change CDN$
Difference 0.0% 2.5% 0.3% 3.1% 16.6% 1.1% 16.6% 19.2% 1.0% 11.3% 1.1% 0.8% 12.0% 2.10% <-Median-> 10 Difference CDN$
$317.65 <-12 mths 10.58%
# of Share in Millions 69.69 72.87 73.64 77.57 93.06 95.42 136.12 188.76 206.35 238.15 255.87 274.09 384.67 384.67 384.67 14.16% <-IRR #YR-> 10 Shares CDN$ 276.11%
Change 0.00% 4.57% 1.06% 5.34% 19.97% 2.53% 42.65% 38.67% 9.32% 15.41% 7.44% 7.12% 40.35% 0.00% 0.00% 15.02% <-IRR #YR-> 5 Shares CDN$ 101.35%
Cash Flow from Operations $M $55.7 $69.3 $40.4 $77.2 $50.0 $45.2 $69.7 $63.0 $98.9 $192.7 $261.9 $287.3 $467.2 $515.3 $508.5 314.32% <-Total Growth 10 Cash Flow CDN$
Increase -16.38% 24.52% -41.69% 91.02% -35.22% -9.68% 54.26% -9.63% 57.06% 94.81% 35.88% 9.69% 62.65% 10.29% -1.33% S. Iss, DRIP Conv. Deb. S.O., ESPP CDN$
5 year Running Average $49.28 $57.23 $58.05 $61.85 $58.54 $56.44 $56.51 $61.02 $65.36 $93.90 $137.24 $180.75 $261.60 $344.88 $408.03 215.81% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS $0.80 $0.98 $0.55 $1.03 $0.63 $0.48 $0.60 $0.40 $0.48 $0.90 $1.03 $1.06 $1.36 $1.50 $1.48 8.35% <-Total Growth 10 Cash Flow per Share CDN$
Increase -17.42% 22.07% -43.54% 86.32% -38.92% -23.57% 24.69% -33.37% 21.67% 86.07% 14.83% 2.16% 28.70% 10.29% -1.33% 15.27% <-IRR #YR-> 10 Cash Flow CDN$ 314.32%
5 year Running Average $0.80 $0.84 $0.83 $0.86 $0.80 $0.73 $0.66 $0.63 $0.52 $0.57 $0.68 $0.77 $0.97 $1.17 $1.29 32.74% <-IRR #YR-> 5 Cash Flow CDN$ 312.16%
P/CF on Med Price 12.47 11.05 15.29 5.01 4.95 9.21 9.44 15.90 14.84 9.51 9.58 10.80 9.35 0.81% <-IRR #YR-> 10 Cash Flow per Share CDN$ 8.35%
P/CF on Closing Price 13.08 10.18 15.27 2.25 6.53 10.48 10.75 17.19 15.16 10.70 10.55 10.78 10.25 12.09% <-IRR #YR-> 5 Cash Flow per Share CDN$ 76.97%
7.41% Diff M/C -0.86% <-IRR #YR-> 10 CFPS 5 yr Running CDN$ -8.25%
Excl.Working Capital CF $7.9 $1.0 $30.7 -$5.7 $1.3 -$0.7 $1.5 $3.9 $47.8 $1.8 $11.1 -$3.7 $0.0 $0.0 $0.0 3.39% <-IRR #YR-> 5 CFPS 5 yr Running CDN$ 18.13%
CF fr Op $M WC $63.6 $70.3 $71.2 $71.5 $51.3 $44.5 $71.2 $66.9 $146.7 $194.5 $273.0 $283.6 $467.2 $515.3 $508.5 303.45% <-Total Growth 10 Cash Flow less WC CDN$
Increase 7.12% 10.49% 1.26% 0.45% -28.21% -13.39% 60.26% -6.13% 119.45% 32.55% 40.37% 3.86% 64.78% 10.29% -1.33% 14.97% <-IRR #YR-> 10 Cash Flow less WC CDN$ 303.45%
5 year Running Average $48.9 $58.5 $64.6 $67.2 $65.6 $61.7 $61.9 $61.1 $76.1 $104.8 $150.5 $192.9 $273.0 $346.7 $409.5 31.82% <-IRR #YR-> 5 Cash Flow less WC CDN$ 298.04%
CFPS Excl. WC $0.91 $0.99 $0.97 $0.95 $0.64 $0.47 $0.61 $0.42 $0.72 $0.91 $1.08 $1.04 $1.36 $1.50 $1.48 12.68% <-IRR #YR-> 10 CF less WC 5 Yr Run CDN$ 229.90%
Increase 5.79% 8.31% -1.95% -2.02% -32.31% -26.71% 29.54% -30.79% 70.00% 26.60% 18.62% -3.27% 30.38% 10.29% -1.33% 25.51% <-IRR #YR-> 5 CF less WC 5 Yr Run CDN$ 211.51%
5 year Running Average $0.78 $0.86 $0.92 $0.94 $0.89 $0.80 $0.73 $0.62 $0.57 $0.63 $0.75 $0.83 $1.02 $1.18 $1.29 0.54% <-IRR #YR-> 10 CFPS - Less WC CDN$ 5.51%
P/CF on Med Price 10.92 10.90 8.69 5.41 4.82 9.36 9.23 14.97 10.01 9.42 9.18 10.94 11.31% <-IRR #YR-> 5 CFPS - Less WC CDN$ 70.90%
P/CF on Closing Price 11.45 10.04 8.68 2.43 6.36 10.65 10.52 16.19 10.22 10.60 10.12 10.92 10.25 9.29 9.42 -0.36% <-IRR #YR-> 10 CFPS 5 yr Running CDN$ -3.50%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 9.54 5 yr  10.80 P/CF Med 10 yr 9.30 5 yr  10.01 10.27% Diff M/C 2.74% <-IRR #YR-> 5 CFPS 5 yr Running CDN$ 14.47%
-$0.98 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.06 Cash Flow per Share
-$0.60 $0.00 $0.00 $0.00 $0.00 $1.06 Cash Flow per Share
-$0.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.77 CFPS 5 yr Running
-$0.66 $0.00 $0.00 $0.00 $0.00 $0.77 CFPS 5 yr Running
-$70.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $283.6 Cash Flow less WC
-$71.2 $0.0 $0.0 $0.0 $0.0 $283.6 Cash Flow less WC
-$58.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $192.9 CF less WC 5 Yr Run
-$61.9 $0.0 $0.0 $0.0 $0.0 $192.9 CF less WC 5 Yr Run
-$0.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.04 CFPS - Less WC
-$0.61 $0.00 $0.00 $0.00 $0.00 $1.04 CFPS - Less WC
-$0.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.83 CFPS 5 yr Running
-$0.73 $0.00 $0.00 $0.00 $0.00 $0.83 CFPS 5 yr Running
OPM 31.05% 35.88% 21.71% 36.12% 26.71% 24.70% 25.19% 17.03% 14.65% 20.42% 25.48% 26.21% -26.95% <-Total Growth 10 OPM CDN$
Increase -25.15% 15.55% -39.48% 66.34% -26.05% -7.52% 1.98% -32.41% -13.97% 39.42% 24.74% 2.87% Should increase  or be stable. CDN$
Diff from Ave 24.5% 43.8% -13.0% 44.8% 7.1% -1.0% 1.0% -31.7% -41.3% -18.1% 2.1% 5.1% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 24.95% 5 Yrs 20.42% should be  zero, it is a   check on calculations CDN$
Current Assets $45.28 $66.08 $48.29 $37.36 $84.19 $54.61 $144.82 $233.24 $303.80 $334.73 $423.73 $491.85 $586.24 Liquidity ratio of 1.5 and up, best Assets CDN$
Current Liabilities $42.35 $89.54 $42.00 $50.07 $56.65 $124.80 $82.96 $173.47 $243.76 $386.27 $391.88 $546.55 $689.94 1.12 <-Median-> 10 Liabilities CDN$
Liquidity Ratio 1.07 0.74 1.15 0.75 1.49 0.44 1.75 1.34 1.25 0.87 1.08 0.90 0.85 1.08 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 0.87 0.78 0.51 0.96 2.03 0.65 2.22 1.45 1.38 1.17 1.42 1.16 1.21 1.38 <-Median-> 5 Ratio CDN$
Liq. CF re  Inv+Div  0.39 0.49 0.30 0.62 0.98 0.48 0.75 0.26 0.55 0.54 0.79 0.18 1.21 0.54 <-Median-> 5 Ratio CDN$
Curr Long Term Debt $71.50 $6.12 $8.34 $9.13 $8.95 $10.08 $10.08
Liquidity Less CLTD 1.02 1.39 1.29 0.89 1.11 0.92 0.86 1.11 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 1.52 1.50 1.43 1.20 1.45 1.18 1.23 1.43 <-Median-> 5 Ratio CDN$
Assets $823.80 $1,048.32 $954.07 $978.52 $1,013.41 $980.92 $1,282.59 $2,778.24 $3,472.56 $4,114.42 $4,991.73 $8,249.46 $10,880.69 Debt Ratio of 1.5 and up, best Assets CDN$
Liabilities $371.24 $603.61 $589.56 $636.41 $619.76 $631.99 $729.89 $1,376.11 $2,006.60 $2,278.03 $2,699.86 $5,763.54 $7,326.90 1.68 <-Median-> 10 Liabilities CDN$
Debt Ratio 2.22 1.74 1.62 1.54 1.64 1.55 1.76 2.02 1.73 1.81 1.85 1.43 1.49 1.81 <-Median-> 5 Ratio CDN$
Total Equity $452.56 $444.72 $364.50 $342.10 $393.65 $348.93 $552.70 $1,402.13 $1,465.96 $1,836.39 $2,291.86 $2,485.92 $3,553.79
NCI $38.50 $484.88 $510.65 $510.65 $356.74 $562.36 $561.39
Net of Equity NCI $452.56 $444.72 $364.50 $342.10 $393.65 $348.93 $514.20 $917.25 $955.31 $1,325.73 $1,935.13 $1,923.56 $2,992.41 332.54% <-Total Growth 10 Book Value CDN$
Preferred Shares $0.00 $116.55 $116.55 $213.81 $213.81 $213.81 $213.81
Book Value $452.56 $444.72 $364.50 $342.10 $393.65 $348.93 $514.20 $800.70 $838.76 $1,111.93 $1,721.32 $1,709.76 $2,778.60 $2,778.60 $2,778.60 284.46% <-Total Growth 10 Book Value CDN$
Book Value per share $6.49 $6.10 $4.95 $4.41 $4.23 $3.66 $3.78 $4.24 $4.06 $4.67 $6.73 $6.24 $7.22 $7.22 $7.22 2.22% <-Total Growth 10 Book Value per Share CDN$
Change -8.62% -6.02% -18.89% -10.90% -4.08% -13.55% 3.30% 12.29% -4.17% 14.87% 44.08% -7.27% 15.79% 0.00% 0.00% 44.07% P/B Ratio Current/Historical Median CDN$
P/B Ratio (Median) 1.53 1.77 1.70 1.16 0.73 1.21 1.49 1.49 1.77 1.83 1.47 1.83 1.76 1.34 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 1.61 1.63 1.70 0.52 0.97 1.37 1.70 1.61 1.81 2.06 1.62 1.83 1.93 1.93 1.93 0.22% <-IRR #YR-> 10 Book Value per Share CDN$ 2.22%
Change 8.30% 1.12% 4.42% -69.17% 84.60% 41.98% 23.80% -5.12% 11.98% 14.34% -21.45% 12.59% 5.69% 0.00% 0.00% 10.55% <-IRR #YR-> 5 Book Value per Share CDN$ 65.14%
Leverage (A/BK) 1.82 2.36 2.62 2.86 2.57 2.81 2.49 3.03 3.64 3.10 2.58 4.29 3.64 3.00 <-Average 10 A/BV CDN$
Debt/Equity Ratio 0.82 1.36 1.62 1.86 1.57 1.81 1.42 1.50 2.10 1.72 1.40 3.00 2.45 1.80 <-Average 10 Debt/Eq Ratio CDN$
Book Value is Asset less Liabilities P/BV 10 yr Med 1.49 5 yr Med 1.77 29.40% Diff M/C 2.43 Historical 20 A/BV
-$6.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.24
-$3.78 $0.00 $0.00 $0.00 $0.00 $6.24
$170.85 <-12 mths 72.38%
Comprehensive Income $125.12 $124.83 $398.20 $53.74
NCI $31.36 $7.08 $28.20 -$45.38
Shareholders -$31.39 $3.41 $3.99 -$31.95 $26.72 $6.17 $93.75 $117.75 $370.00 $99.11 415.79% <-Total Growth 9 Comprehensive Income CDN$
Increase 110.86% 16.92% -901.33% 183.62% -76.89% 1418.51% 25.60% 214.22% -73.21% 25.6% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average -$5.84 $1.67 $19.74 $42.49 $122.88 $137.36 #NUM! <-IRR #YR-> 9 Comprehensive Income CDN$ 415.79%
ROE -8.6% 1.0% 1.0% -9.2% 5.2% 0.7% 9.8% 8.9% 19.1% 5.2% 29.98% <-IRR #YR-> 5 Comprehensive Income CDN$ 270.99%
5Yr Median 1.0% -3.8% 1.0% 1.0% 1.0% 5.2% 8.9% 8.9% #NUM! <-IRR #YR-> 5 5 Yr Running Average CDN$ #DIV/0!
% Difference from NI -232.6% -117.9% -87.2% -262.7% 14.3% -57.5% 361.9% 55.5% 245.5% -17.8% #NUM! <-IRR #YR-> 5 5 Yr Running Average CDN$ 2450.27%
Diff 5, 10 yr -37.6% 55.5% 8.9% <-Median-> 5 Return on Equity CDN$
$31.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $99.1
-$26.7 $0.0 $0.0 $0.0 $0.0 $99.1
$5.8 $0.0 $0.0 $0.0 $0.0 $137.4
$5.8 $0.0 $0.0 $0.0 $0.0 $137.4
Current Liability Coverage Ratio 1.31 0.77 0.96 1.54 0.88 0.36 0.84 0.36 0.41 0.50 0.67 0.53   CFO / Current Liabilities CDN$
5 year Median 1.37 1.37 1.31 1.31 0.96 0.88 0.88 0.84 0.41 0.41 0.50 0.50 0.50 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio 6.76% 6.61% 4.24% 7.89% 4.94% 4.61% 5.43% 2.27% 2.85% 4.68% 5.25% 3.48% CFO / Total Assets CDN$
5 year Median 6.76% 6.76% 6.76% 6.76% 6.61% 4.94% 4.94% 4.94% 4.61% 4.61% 4.68% 3.48% 3.5% <-Median-> 5 Return on Assets  CDN$
Return on Assets ROA CDN$ 2.6% 2.7% 2.5% -1.9% 3.1% 2.0% 1.8% 0.5% 0.6% 1.8% 2.1% 1.5% Net  Income/Assets Return on Assets CDN$
5Yr Median 2.6% 2.7% 2.7% 2.6% 2.6% 2.5% 2.0% 1.8% 1.8% 1.8% 1.8% 1.5% 1.5% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 4.8% 6.3% 6.5% -5.6% 7.9% 5.6% 4.5% 1.6% 2.1% 5.7% 5.5% 6.3% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 4.6% 4.8% 6.3% 4.8% 6.3% 6.3% 5.6% 4.5% 4.5% 4.5% 4.5% 5.5% 5.5% <-Median-> 5 Return on Equity CDN$
$104.45 <-12 mths -13.34%
Net Income  $9.48 $53.52 $85.50 $92.37
NCI -$10.81 -$22.19 -$31.98 -$38.55
Preferred Shareholders $9.50 $10.40 $10.40
Shareholders $21.79 $27.96 $23.67 -$19.04 $31.26 $19.64 $23.38 $14.53 $20.30 $75.70 $107.08 $120.52 $254 $278 $256 331.12% <-Total Growth 10 Net Income CDN$
Increase -4.45% 28.31% -15.33% -180.43% -264.18% -37.17% 19.05% -37.85% 39.66% 272.98% 41.45% 12.56% 110.75% 9.45% -7.91% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $22.42 $26.64 $28.14 $15.44 $17.13 $16.70 $15.78 $13.95 $21.82 $30.71 $48.20 $67.63 $115.52 $167.06 $203.12 15.73% <-IRR #YR-> 10 Net Income CDN$ 331.12%
Operating Cash Flow $55.68 $69.33 $40.43 $77.22 $50.02 $45.18 $69.70 $62.99 $98.93 $192.72 $261.87 $287.26 38.82% <-IRR #YR-> 5 Net Income CDN$ 415.48%
Investment Cash Flow -$51.14 -$53.51 -$27.65 -$27.51 -$60.31 -$45.33 -$162.99 -$785.83 -$369.75 -$453.27 -$310.02 -$2,894.76 9.76% <-IRR #YR-> 10 5 Yr Running Average CDN$ 153.85%
Total Accruals $17.25 $12.14 $10.89 -$68.75 $41.54 $19.79 $116.68 $737.37 $291.12 $336.25 $155.23 $2,728.03 33.78% <-IRR #YR-> 5 5 Yr Running Average CDN$ 328.50%
Total Assets $823.80 $1,048.32 $954.07 $978.52 $1,013 $981 $1,283 $2,778 $3,473 $4,114 $4,992 $8,249 Balance Sheet Assets CDN$
Accruals Ratio 2.09% 1.16% 1.14% -7.03% 4.10% 2.02% 9.10% 26.54% 8.38% 8.17% 3.11% 33.07% 8.38% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.34 0.39 0.32 -0.26 0.61 0.45 0.33 0.21 0.10 0.34 0.39 0.42 0.33 <-Median-> 10 EPS/CF Ratio CDN$
-$27.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $120.52
-$23.38 $0.00 $0.00 $0.00 $0.00 $120.52
-$26.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $67.63
-$15.78 $0.00 $0.00 $0.00 $0.00 $67.63
Change in Close -1.04% -4.98% -15.31% -72.53% 77.06% 22.74% 27.89% 6.54% 7.31% 31.34% 13.17% 4.40% 22.39% 0.00% 0.00% Count 21 Years of data
up/down up Down Down Down Down Down Count 12 57.14%
Meet Prediction? Yes % right Count 3 25.00%
Finasncial Cash Flow -$27.21 -$12.57 -$11.87 -$55.04 $7.37 $2.63 $161.92 $704.04 $230.02 $255.34 $156.30 $2,595.34 C F Statement  Financial CF CDN$
Total Accruals $44.46 $24.71 $22.76 -$13.70 $34.18 $17.16 -$45.24 $33.33 $61.11 $80.91 -$1.07 $132.69 Accruals CDN$
Accruals Ratio 5.40% 2.36% 2.39% -1.40% 3.37% 1.75% -3.53% 1.20% 1.76% 1.97% -0.02% 1.61% 1.61% <-Median-> 5 Ratio CDN$
Cash $13.47 $10.36 $5.91 $2.80 $5.15 $72.89 $53.12 $13.84 $9.27 $124.35 $110.42 $77.74 Cash CDN$
Cash per Share $0.18 $0.14 $0.08 $0.03 $0.05 $0.54 $0.28 $0.07 $0.04 $0.49 $0.40 $0.20 $0.28 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 1.86% 1.67% 3.30% 0.73% 1.07% 8.34% 4.11% 0.91% 0.40% 4.45% 3.54% 1.45% 3.54% <-Median-> 5 % of Stock Price CDN$
Notes:
June 11, 2017.  Last estimates were for 2016m 2017 and 2018 of 1139M, $1794M and $2204M for Revenue, $0.76, $0.73 and $0.96 for AFFO, $0.47, $0.52 and $0.67 for EPS,
 $1.15, $1.43 and $1.75 for CFPS and $81M and $226M for Net Income for 2016 and 2017.
June 11, 2016.  Last estimates were for 2015, 2016 and 2017 of $1072M, $1193M and $1195M for Revenue, $0.64 and 0.68 for AFFO for 2015 and 2016, $0.44, $0.47 and $0.52 for EPS, 
$0.86, $1.14 and $1.31 for CFPS and $107M and $126M for 2015 and 2016 for Net Income.
June 27, 2015.  Last estimates were for 2014 and 2015 of $916M and $990M for Revenue, $0.50 and $0.59 for AFFO, $0.35 and $0.40 for EPS, $0.89 and $1.03 for CFPS and $66.5M and $79.8M for Net Income.
June 24, 2014.  Last estimates were for 2013, 2014 and 2015 of $685M, $808M and $799M for Revenue, $0.39 and $0.45 for AFFO, $0.26, $0.36 and $0.55 for EPS, $0.73, $0.90 and $1.02 for CFPS
For 2013 the EPS for continueing operations was $0.28 and $0.28 for Basic and Diluted and would be more representative of future earnings.
Some $81.597M of comprehensive Income is Foreign Currency Adjustments.
June 2, 2012.  Last Estiamtes were for 2012 and 2013 of $372.5M and $556.7M for Revenue, $.20 and .30 for Earnings per Share and $.29 and $.95 for CFPS
July 8, 2012.  Last estimates were for 2011 and 2012 and were $0.23 and $0.28 for EPS and $0.74 and $0.85 for CFPS.
The increase in shares for Q1 of 2012 was due to conversion of convertible debentures (7.6% or 97% of increase) and shares issuance under DRIP and Company plan (0.21%).
The increase in shares for 2011 was due to conversion of convertible debentures (16%) and shares issuance (26.6%).
The difference between Comprehensive Income and Net Income seems to be becaause of the way they report foreign currency translations.
TD Securities say that they have tax schields (or tax pool) that will last until 2019. 5 July 2012.
Mar 15, 2011.  When I reviewed this stock I got an earnings e stimates of $.08 and $.25 and $.30 for 2010, 2011 and 2012 and CF estimates of $.50 abd $.74 for 2010 and 2011.
On October 27, 2009, Algonquin Power Income Fund (the “Fund”) completed a reverse take-over transaction (the “Transaction”) of Hydrogenics Corporation (“Hydrogenics”) which resulted in the Fund’s Unitholders
becoming shareholders in Hydrogenics which was immediately renamed Algonquin Power & Utilities Corp. As a result, the Fund itself became a wholly owned subsidiary of APUC.
Was an income fund prior to 2009 as APF.UN
Algonquin Power Income Fund was established in September 1997 and first listed its trust units on the Toronto Stock Exchange on December 23, 1997.  
Having raised nearly $75m, Algonquin used $27.5m to purchase 14 hydroelectric generation facilities located in Ontario, Québec, New York and New Hampshire
Emera owns shares in this company.  I own shares in Emera TSX-EMA)
Sector:
Power Utility
What should this stock accomplish?
Would I buy this company and Why.
I have a lot of my utility money in pipelines.  I think that sometime in the future I may have to move this money to other utilities.  I do not think that the new types of power generation is going to go away 
and might at some time be a good investment.
Why am I following this stock. 
This is a dividend paying utility stocks.  I got it off a list of dividend paying utility stocks.
Also, I own Emera Inc. and this company owns shares in Algonquin Power. 
Dividends
Dividends are paid in cycle 1, which if January, April, July, and October.  Dividends are declared for shareholders of record of one month and payble in the following month.
For example, the dividend payable for shareholders of record on  June 30, 2014 for the period from April 1, 2014 to June 30, 2014 was payaable on July 15, 2014.
How they make their money.
APUC owns and operates a diversified portfolio of clean renewable electric generation and sustainable utility distribution businesses in North America. Liberty Water Co., APUC's water utility subsidiary, 
provides regulated water utility services. Through its wholly owned subsidiary Liberty Energy Utilities Co., APUC provides regulated electricity and natural gas distribution services. Algonquin Power Co., 
APUC's electric generation subsidiary, includes renewable energy facilities and thermal energy facilities. 
California-based electricity distribution and related generation assets of NV Energy, Inc. of which Emera and APUC own and operate these assets through a newly formed utility company, 
California Pacific Electric Company, LLC. 
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.  
Also, for the Operational Profit Margin, a higher percentage is better.  With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Jul 13 2012 Jun 02 2013 Jun 22 2014 Jun 22 2015 Jun 11 2016 Jun 11 2017
Robertson, Ian Edward 0.428 0.21% 0.432 0.18% 0.864 0.34% 1.344 0.49% 1.963 0.51%
CEO - Shares - Amount $3.141 $4.167 $9.424 $15.31 $27.37
Options - percentage 1.510 0.73% 1.838 0.77% 1.930 0.75% 1.585 0.58% 2.290 0.60%
Options - amount $11.086 $17.719 $21.058 $18.05 $31.93
Bronicheski, David John 0.042 0.02% 0.043 0.02% 0.053 0.02% 0.470 0.17% 0.668 0.17%
CFO - Shares - Amount $0.306 $0.419 $0.577 $5.35 $9.32
Options - percentage 0.661 0.32% 0.755 0.32% 0.972 0.38% 0.678 0.25% 0.646 0.17%
Options - amount $4.848 $7.278 $10.610 $7.72 $9.01
Beairsto, Linda 0.002 0.00% 0.004 0.00% 0.006 0.00% 0.064 0.02% 0.080 0.02%
Officer - Shares - Amount $0.011 $0.036 $0.063 $0.72 $1.11
Options - percentage 0.242 0.12% 0.312 0.13% 0.425 0.17% 0.424 0.15% 0.539 0.14%
Options - amount $1.775 $3.005 $4.634 $4.82 $7.51
Ball, Christopher James 0.024 0.01% 0.024 0.01% 0.024 0.01% 0.024 0.01% 0.024 0.01%
Director - Shares - Amount $0.178 $0.233 $0.262 $0.28 $0.34
Options - percentage 0.013 0.01% 0.018 0.01% 0.024 0.01% 0.031 0.01% 0.039 0.01%
Options - amount $0.092 $0.175 $0.263 $0.35 $0.55
Moore, Kenneth 0.018 0.01% 0.018 0.01% 0.018 0.01% 0.018 0.00%
Chairman - Shares - Amt $0.174 $0.196 $0.21 $0.25
Options - percentage 0.043 0.02% 0.065 0.03% 0.091 0.03% 0.120 0.03%
Options - amount $0.417 $0.710 $1.04 $1.67
General Motors Holdings LLC 11.364 8.35% Last reported 2009
in 2012 $72.957
Emera Inc 2012 20.523 15.08% 50.127 24.29% 50.127 19.59% Reported 0 in May 2016
10% Holder $131.758 $367.930 $546.883
Options - percentage 12.025 4.70%
Options - amount $131.190
Increase in O/S Shares 0.000 0.00% 0.000 0.00% 0.134 0.05% 2.957 1.08% Yes 0
due to SO 2013 $0.000 $0.000 $1.465 $33.675
Book Value $2.046 $3.248 $1.343 $18.944
Insider Buying -$0.203 -$0.328 $0.000
Insider Selling $0.000 $3.376 -$0.357
Net Insider Selling $0.000 -$0.203 $3.048 -$0.357
% of Market Cap 0.00% -0.01% 0.10% -0.01%
Directors 6 7 8 8 9
Women 0 0% 1 14% 2 25% 2 25% 3 33%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 55 23.88% 58 25.26% 63 25.29% 68 25.97% 78 28.88% 174 46.71%
Total Shares Held 37.993 20.13% 51.787 27.43% 52.464 22.03% 62.208 24.31% 74.972 27.35% 178.637 46.44%
Increase/Decrease 2.317 6.49% 0.078 0.15% -0.048 -0.09% 0.695 1.13% 1.449 1.97% 29.595 19.86%
Starting No. of Shares 35.676 51.709 52.512 61.512 73.524 149.042 Reuters
Institutions/Holdings 185 $3,321
Total Shares Held 238.000 61.87%
Value $3,318
Increase/Decrease 84.000 54.55%
Starting No. of Shares 154.000 Morningstar
Copyright © 2008 Website of SPBrunner. All rights reserved.