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. Q2 2026 Q3 2024 release November 13.
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ 6/30/26 https://www.annualreports.com/Company/Northland-Power
Northland Power Inc TSX: NPI OTC: NPIFF https://northlandpower.com/ Fiscal Yr: Dec 31
Year 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27 12/30/28 Value Description #Y Item Total G
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
Cost of Sales $202.5 $290.7 $225.7 $193.2 $139.5 $114.2 $116.3 $202.3 $213.5 $270.4 $620.6 $649.9 $740.1 $768.1 <-12 mths 3.78% 227.93% <-Total Growth 10 Cost of Sales Reclassified 2024
Change 53.99% 43.57% -22.36% -14.38% -27.79% -18.14% 1.81% 73.99% 5.52% 26.67% 129.47% 4.73% 13.87% 3.78% <-12 mths 5.13% <-Median-> 10 Change
Ratio 0.36 0.38 0.31 0.18 0.10 0.07 0.07 0.10 0.10 0.11 0.28 0.28 0.30 837.42 <-12 mths 0.11 <-Median-> 10 Ratio
Other Expenses $187.2 $240.2 $244.9 $412.6 $618.0 $721.7 $743.8 $973.4 $1,109.3 $1,138.9 $1,045.1 $893.8 $1,550.1 $1,628.6 <-12 mths 5.06% 532.98% <-Total Growth 10 Other Expenses
Change 43.48% 28.25% 1.97% 68.49% 49.76% 16.78% 3.07% 30.87% 13.96% 2.67% -8.23% -14.48% 73.43% 5.06% <-12 mths 15.37% <-Median-> 10 Change
Ratio 0.34 0.32 0.34 0.38 0.45 0.46 0.45 0.47 0.53 0.47 0.47 0.38 0.64 0.62 <-12 mths 0.46 <-Median-> 10 Ratio
Total $389.7 $530.8 $470.6 $605.9 $757.5 $835.9 $860.1 $1,175.7 $1,322.8 $1,409.3 $1,665.7 $1,543.8 $2,290.2 $2,396.6 <-12 mths 4.65% 386.68% <-Total Growth 10 Total
Change 48.75% 36.21% -11.35% 28.75% 25.03% 10.35% 2.90% 36.70% 12.51% 6.54% 18.19% -7.32% 48.35% 4.65% <-12 mths 15.35% <-Median-> 10 Change
Ratio 0.70 0.70 0.65 0.55 0.55 0.54 0.52 0.57 0.63 0.58 0.75 0.66 0.94 0.92 <-12 mths 0.57 <-Median-> 10 Ratio
$2,473.1 <-12 mths 5.40%
Total Income $2,243.7 $2,356.6 $2,444.9
Revenue* $557.2 $760.1 $728.1 $1,099.0 $1,376.3 $1,555.6 $1,659.0 $2,060.6 $2,093.3 $2,448.8 $2,232.8 $2,346.3 $2,435.0 $2,613 $2,721 $3,150 234.41% <-Total Growth 10 Revenue
Increase 53.80% 36.40% -4.20% 50.93% 25.23% 13.03% 6.65% 24.21% 1.58% 16.99% -8.82% 5.08% 3.78% 7.31% 4.13% 15.77% 12.83% <-IRR #YR-> 10 Revenue 234.41%
5 year Running Average $354.7 $468.0 $552.8 $701.4 $904.1 $1,103.8 $1,283.6 $1,550.1 $1,748.9 $1,963.5 $2,098.9 $2,236.3 $2,311.2 $2,415.2 $2,469.6 $2,653.0 3.39% <-IRR #YR-> 5 Revenue 18.17%
Revenue per Share $4.19 $5.05 $4.27 $6.35 $7.84 $8.63 $9.19 $10.19 $9.23 $9.79 $8.76 $9.03 $9.31 $9.99 $10.41 $12.05 15.38% <-IRR #YR-> 10 5 yr Running Average 318.10%
Increase 39.01% 20.59% -15.56% 48.90% 23.47% 10.04% 6.50% 10.86% -9.48% 6.16% -10.58% 3.06% 3.16% 7.31% 4.13% 15.77% 8.32% <-IRR #YR-> 5 5 yr Running Average 49.10%
5 year Running Average $3.14 $3.64 $3.90 $4.58 $5.54 $6.43 $7.26 $8.44 $9.02 $9.41 $9.43 $9.40 $9.22 $9.38 $9.50 $10.16 8.12% <-IRR #YR-> 10 Revenue per Share 118.22%
P/S (Price/Sales) Med 4.04 3.28 3.97 3.31 3.03 2.65 2.72 3.29 4.74 4.13 3.32 2.39 2.26 2.11 0.00 0.00 -1.79% <-IRR #YR-> 5 Revenue per Share -8.64%
P/S (Price/Sales) Close 3.69 3.03 4.37 3.67 2.98 2.51 2.96 4.48 4.11 3.79 2.75 1.98 1.92 2.27 2.18 1.88 9.00% <-IRR #YR-> 10 5 yr Running Average 136.64%
*Revenue in M CDN $  P/S Med 20 yr  3.85 15 yr  3.31 10 yr  3.16 5 yr  3.32 -28.29% Diff M/C 1.78% <-IRR #YR-> 5 5 yr Running Average 9.24%
-$728.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,435.0
-$2,060.6 $0.0 $0.0 $0.0 $0.0 $2,435.0
-$552.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,311.2
-$1,550.1 $0.0 $0.0 $0.0 $0.0 $2,311.2
-$4.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.31
-$10.19 $0.00 $0.00 $0.00 $0.00 $9.31
-$3.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.22
-$8.44 $0.00 $0.00 $0.00 $0.00 $9.22
Distributable Cash #DIV/0! <-Total Growth 0 Distributable Cash
* Distributable cash per share, Diluted (cannot find for 2011)
$299.4 <-12 mths -24.67%
$1.41 <-12 mths -3.42% Per Share values in Press Release
Adjusted Free Cash Flow (AFCF - TD) $130.12 $164.87 $182.16 $242.32 $256.10 $337.62 $362.5 $415.4 $386.4 $460.9 $498.0 $397.4 $382.1 $300 $368 $410 109.76% <-Total Growth 10 AFCF This was discontinued in 2025
Adjusted FCF Basic $1.05 $1.12 $1.09 $1.40 $1.46 $1.90 $2.01 $2.09 $1.77 $1.95 $1.97 $1.53 $1.46 $1.15 $1.41 $1.57 33.94% <-Total Growth 10 AFCF
Increase 84.21% 6.98% -2.97% 28.44% 4.29% 30.14% 5.79% 3.98% -15.31% 10.17% 1.03% -22.34% -4.58% -21.53% 22.96% 11.29% 10 0 10 Years of Data, EPS P or N
5 year Running Average $0.87 $0.88 $0.92 $1.05 $1.22 $1.39 $1.57 $1.77 $1.85 $1.94 $1.96 $1.86 $1.74 $1.61 $1.50 $1.42 2.97% <-IRR #YR-> 10 AFCF
AFCF Yield 6.78% 7.35% 5.84% 6.01% 6.25% 8.76% 7.39% 4.58% 4.66% 5.25% 8.18% 8.55% 8.18% 5.06% 6.22% 6.93% -6.92% <-IRR #YR-> 5 AFCF
Payout Ratio 102.86% 96.14% 99.08% 77.14% 73.97% 63.16% 59.70% 57.42% 67.80% 61.54% 60.91% 78.43% 82.19% 62.84% 51.11% 45.92% 6.52% <-IRR #YR-> 10 5 yr Running Average
5 year Running Average 130.52% 129.93% 125.20% 112.94% 89.84% 81.90% 74.61% 66.28% 64.41% 61.92% 61.47% 65.22% 70.17% 69.18% 67.10% 64.10% -0.41% <-IRR #YR-> 5 5 yr Running Average
Price/AFCF Median 16.10 14.75 15.56 15.04 16.30 12.03 12.43 16.02 24.71 20.75 14.78 14.08 14.39 18.42 0.00 0.00 14.91 <-Median-> 10 Price/AFCF Median
Price/AFCF High 18.78 16.48 17.57 17.90 17.03 13.54 13.93 22.16 28.73 23.46 19.67 16.46 17.66 21.12 0.00 0.00 17.78 <-Median-> 10 Price/AFCF High
Price/AFCF Low 13.43 13.02 13.54 12.19 15.57 10.52 10.94 9.89 20.69 18.05 9.89 11.70 11.12 15.72 0.00 0.00 11.41 <-Median-> 10 Price/AFCF Low
Price/AFCF Close 14.74 13.61 17.12 16.64 15.99 11.42 13.53 21.85 21.44 19.04 12.22 11.70 12.23 19.76 16.07 14.44 14.76 <-Median-> 10 Price/AFCF Close
Trailing P/AFCF Close 27.16 14.56 16.61 21.38 16.68 14.86 14.32 22.72 18.16 20.98 12.34 9.09 11.67 15.51 19.76 16.07 15.77 <-Median-> 10 Trailing P/AFCF Close
Median Values Historical   in order 15.30 17.78 12.60 15.37 P/AFCF 5 Yrs   in order 14.78 19.67 11.70 12.23 33.69% Diff M/C DPR 75% to 95% best
Adjusted Free Cash Flow
to Free Cash Flow -$1.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.46
-$2.09 $0.00 $0.00 $0.00 $0.00 $1.46
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.74
-$1.77 $0.00 $0.00 $0.00 $0.00 $1.74
$371.0 <-12 mths -2.91%
$1.41 <-12 mths -3.42%
Distributable Cash to Free Cash Flow  $130.1 $164.9 $182.2 $242.3 $256.1 $337.6 $318.5 $343.6 $307.4 $380.5 $423.7 $327.6 $382.1 $300 $368 $410 109.76% <-Total Growth 10 FCF
Basic $1.05 $1.12 $1.09 $1.40 $1.46 $1.90 $1.77 $1.73 $1.40 $1.61 $1.68 $1.27 $1.46 $1.15 $1.41 $1.57 33.94% <-Total Growth 10 FCF
Increase 84.21% 6.98% -2.97% 28.44% 4.29% 30.14% -6.84% -2.26% -19.08% 15.00% 4.35% -24.40% 14.96% -21.53% 22.96% 11.29% 10 0 10 Years of Data, EPS P or N 100.00%
5 year Running Average $0.87 $0.88 $0.92 $1.05 $1.22 $1.39 $1.52 $1.65 $1.65 $1.68 $1.64 $1.54 $1.48 $1.43 $1.39 $1.37 2.97% <-IRR #YR-> 10 FCF 33.94%
FCF Yield 6.78% 7.35% 5.84% 6.01% 6.25% 8.76% 6.51% 3.79% 3.69% 4.34% 6.98% 7.09% 8.18% 5.06% 6.22% 6.93% -3.34% <-IRR #YR-> 5 FCF -15.61%
Payout Ratio 102.86% 96.14% 99.08% 77.14% 73.97% 63.16% 67.80% 69.36% 85.71% 74.53% 71.43% 94.49% 82.19% 62.84% 51.11% 45.92% 4.87% <-IRR #YR-> 10 5 yr Running Average 60.84%
5 year Running Average 130.52% 129.93% 125.20% 112.94% 89.84% 81.90% 76.23% 70.29% 72.00% 72.11% 73.77% 79.11% 81.67% 77.10% 72.41% 67.31% -2.12% <-IRR #YR-> 5 5 yr Running Average -10.17%
Price/FCF Median 16.10 14.75 15.56 15.04 16.30 12.03 14.12 19.36 31.24 25.14 17.33 16.96 14.39 18.42 0.00 0.00 16.63 <-Median-> 10 Price/FCF Median
Price/FCF High 18.78 16.48 17.57 17.90 17.03 13.54 15.82 26.77 36.32 28.42 23.07 19.83 17.66 21.12 0.00 0.00 18.86 <-Median-> 10 Price/FCF High
Price/FCF Low 13.43 13.02 13.54 12.19 15.57 10.52 12.42 11.95 26.16 21.86 11.60 14.09 11.12 15.72 0.00 0.00 12.30 <-Median-> 10 Price/FCF Low
Price/FCF Close 14.74 13.61 17.12 16.64 15.99 11.42 15.37 26.40 27.11 23.06 14.33 14.09 12.23 19.76 16.07 14.44 15.68 <-Median-> 10 Price/FCF Close
Trailing P/FCF Close 27.16 14.56 16.61 21.38 16.68 14.86 14.32 25.80 21.94 26.52 14.95 10.65 14.06 15.51 19.76 16.07 15.81 <-Median-> 10 Trailing P/FCF Close
Median Values Historical   in order 14.39 16.48 11.60 13.61 P/FCF 5 Yrs   in order 17.33 23.07 14.09 14.33 14.01% Diff M/C DPR 75% to 95% best
Free Cash Flow
-$1.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.46
-$1.73 $0.00 $0.00 $0.00 $0.00 $1.46
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.48
-$1.65 $0.00 $0.00 $0.00 $0.00 $1.48
-$0.56 <-12 mths 13.85%
EPS Basic $1.08 -$0.82 -$0.07 $0.64 $0.85 $1.50 $1.71 $1.76 $0.82 $3.46 -$0.72 $1.03 -$0.65 -828.57% <-Total Growth 10 EPS Basic
EPS Diluted* $1.03 -$0.82 -$0.07 $0.64 $0.85 $1.46 $1.68 $1.75 $0.82 $3.46 -$0.72 $1.03 -$0.65 $0.84 $1.49 $1.79 -828.57% <-Total Growth 10 EPS Diluted
Increase -672.22% -179.61% -91.46% -1014.29% 32.81% 71.76% 15.07% 4.17% -53.14% 321.95% -120.81% -243.06% -163.11% -228.65% 78.19% 20.13% 11 17 29 Years of Data, EPS P or N 37.93%
Earnings Yield 6.65% -5.36% -0.38% 2.75% 3.64% 6.73% 6.18% 3.83% 2.16% 9.32% -2.99% 5.75% -3.64% 3.69% 6.58% 7.91% 24.96% <-IRR #YR-> 10 Earnings per Share -828.57%
5 year Running Average $0.15 -$0.11 -$0.13 $0.12 $0.33 $0.41 $0.91 $1.28 $1.31 $1.83 $1.40 $1.27 $0.79 $0.79 $0.40 $0.90 -18.85% <-IRR #YR-> 5 Earnings per Share -137.14%
10 year Running Average $0.33 $0.20 $0.10 $0.11 $0.24 $0.28 $0.40 $0.57 $0.72 $1.08 $0.91 $1.09 $1.03 $1.05 $1.12 $1.15 #NUM! <-IRR #YR-> 10 5 yr Running Average 706.15%
* Diluted ESP per share  E/P 10 Yrs 3.74% 5Yrs 2.16% -9.19% <-IRR #YR-> 5 5 yr Running Average -38.24%
$0.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.65
-$1.75 $0.00 $0.00 $0.00 $0.00 -$0.65
$0.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.79
-$1.28 $0.00 $0.00 $0.00 $0.00 $0.79
Dividend* $0.72 $0.72 $0.72 Estimates Dividend*
Increase -40.00% 0.00% 0.00% Estimates Increase
Payout Ratio EPS 86.10% 48.32% 40.22% 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.08 $1.08 $1.08 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $0.72 $0.72 $0.72 11.11% <-Total Growth 10 Dividends
Increase 0.00% 0.00% 0.00% 0.00% 0.00% 11.11% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -40.00% 0.00% 0.00% 8 2 28 Years of data, Count P, N 28.57%
Average Increases 5 Year Running 0.0% 0.0% 0.0% 0.0% 0.0% 2.2% 2.2% 2.2% 2.2% 2.2% 0.0% 0.0% 0.0% -8.0% -8.0% -8.0% 1.11% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $1.08 $1.08 $1.08 $1.08 $1.08 $1.10 $1.13 $1.15 $1.18 $1.20 $1.20 $1.20 $1.20 $1.10 $1.01 $0.91 11.11% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 6.39% 6.52% 6.37% 5.13% 4.54% 5.25% 4.80% 3.58% 2.74% 2.97% 4.12% 5.57% 5.71% 3.41% 4.67% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 5.48% 5.83% 5.64% 4.31% 4.34% 4.67% 4.29% 2.59% 2.36% 2.62% 3.10% 4.77% 4.65% 2.98% 4.30% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 7.66% 7.38% 7.32% 6.33% 4.75% 6.01% 5.46% 5.81% 3.28% 3.41% 6.16% 6.70% 7.39% 4.00% 5.91% <-Median-> 10 Yield on Low Price FCF Co.
Yield on Close Price 6.98% 7.06% 5.79% 4.64% 4.63% 5.53% 4.41% 2.63% 3.16% 3.23% 4.99% 6.70% 6.72% 3.18% 3.18% 3.18% 4.63% <-Median-> 10 Yield on Close Price AFCF
Payout Ratio EPS 104.85% 0.00% 0.00% 168.75% 127.06% 82.19% 71.43% 68.57% 146.34% 34.68% 0.00% 116.50% 0.00% 86.10% 48.32% 40.22% 76.81% <-Median-> 10 DPR EPS CFPS
DPR EPS 5 Yr Running 710.53% 0.00% 0.00% 900.00% 331.29% 267.96% 123.68% 90.28% 89.63% 65.43% 85.84% 94.64% 152.28% 139.53% 253.75% 101.42% 109.16% <-Median-> 10 DPR EPS 5 Yr Running FCF 
Payout Ratio CFPS 55.87% 45.00% 46.22% 25.95% 22.32% 19.07% 17.68% 18.36% 16.92% 16.37% 38.96% 30.32% 22.00% 17.10% 14.39% 12.54% 20.54% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 88.95% 70.90% 59.50% 44.35% 34.46% 27.56% 23.10% 20.13% 18.64% 17.63% 19.46% 21.43% 22.29% 22.97% 23.22% 18.71% 21.86% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 54.19% 45.71% 46.82% 25.66% 20.17% 19.38% 17.93% 17.92% 20.68% 19.44% 24.44% 23.38% 22.45% 17.10% 14.39% 12.54% 20.42% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 82.50% 68.62% 58.05% 43.81% 33.28% 27.02% 22.78% 19.76% 19.13% 19.01% 19.82% 20.90% 21.93% 21.42% 20.49% 17.93% 21.41% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 4.67% 4.63% 5 Yr Med 5 Yr Cl 4.12% 4.99% 5 Yr Med Payout 34.68% 22.00% 22.45% 0.00% <-IRR #YR-> 5 Dividends 0.00%
* Dividends per share  10 Yr Med and Cur. -31.91% -31.32% 5 Yr Med and Cur. -22.83% -36.21% Last Div Inc ---> $0.10 $0.06 -39.40% 1.06% <-IRR #YR-> 10 Dividends 11.11%
Dividends Growth 15 0.70% <-IRR #YR-> 15 Dividends 11.11%
Dividends Growth 20 0.78% <-IRR #YR-> 20 Dividends 16.78%
Dividends Growth 25 0.90% <-IRR #YR-> 25 Dividends 25.00%
Dividends Growth 30 2.51% <-IRR #YR-> 28 Dividends
Dividends Growth 5 -$1.20 $0.00 $0.00 $0.00 $0.00 $1.20 Dividends Growth 5
Dividends Growth 10 -$1.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20 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 $1.20 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20 Dividends Growth 20
Dividends Growth 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20 Dividends Growth 25
Dividends Growth 30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20 Dividends Growth 30
Historical Dividends Historical High Div 11.42% Low Div 2.62% 10 Yr High 7.32% 10 Yr Low 2.38% Med Div 6.52% Close Div 6.89% 5.57% Med since 2009 Historical Dividends
High/Ave/Median Values Curr diff Exp. -72.15%     21.38% Exp. -56.55% 33.62% Exp. -51.22% Exp. -53.86% -42.90% Exp. High/Ave/Median 
Adjusted Historical Dividends Historical High Div 9.11% Low Div 2.54% 10 Yr High 7.32% 10 Yr Low 2.43% Med Div 5.57% Close Div 5.78% In 2009 Change from  Adjusted Historical Dividends
High/Ave/Median Values Curr diff Exp. -65.09%     25.21% Exp. -56.55% 30.87% Exp. -42.90% Exp. -45.02% Income Trust High/Ave/Median 
Future Dividend Yield Div Yield 3.18% earning in 5 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yield 3.18% earning in 10 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yield 3.18% earning in 15 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Paid Div Paid $0.72 earning in 5 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Future Dividend Paid Div Paid $0.72 earning in 10 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Future Dividend Paid Div Paid $0.72 earning in 15 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Dividend Covering Cost Total Div $3.60 over 5 Years at IRR of 0.00% Div Cov. 15.90% Dividend Covering Cost
Dividend Covering Cost Total Div $6.48 over 10 Years at IRR of 0.00% Div Cov. 28.62% Dividend Covering Cost
Dividend Covering Cost Total Div $9.36 over 15 Years at IRR of 0.00% Div Cov. 41.34% Dividend Covering Cost
Yield if held 5 years 9.39% 10.09% 7.52% 6.54% 5.98% 7.10% 7.24% 7.08% 5.70% 5.04% 5.25% 4.80% 3.58% 1.65% 1.78% 2.47% 5.84% <-Median-> 10 Paid Median Price
Yield if held 10 years 9.77% 8.84% 8.12% 7.63% 8.48% 10.43% 11.21% 8.35% 7.27% 6.65% 7.10% 7.24% 7.08% 3.42% 3.03% 3.15% 7.45% <-Median-> 10 Paid Median Price
Yield if held 15 years 10.29% 11.77% 14.07% 10.51% 9.86% 10.86% 9.82% 9.03% 8.48% 9.43% 10.43% 11.21% 8.35% 4.36% 3.99% 4.26% 9.84% <-Median-> 10 Paid Median Price
Yield if held 20 years 10.80% 11.43% 13.08% 15.64% 11.68% 10.96% 10.86% 9.82% 9.03% 5.09% 5.66% 6.26% 10.96% <-Median-> 9 Paid Median Price
Yield if held 25 years 12.00% 11.43% 13.08% 15.64% 7.01% 6.58% 6.52% 12.54% <-Median-> 4 Paid Median Price
7.20% 6.86%
Cost covered if held 5 years 46.94% 50.47% 37.59% 32.70% 29.92% 32.64% 34.04% 33.97% 27.92% 25.22% 26.26% 24.01% 17.92% 12.62% 12.45% 15.66% 28.92% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 99.33% 88.16% 81.42% 76.45% 84.84% 94.92% 103.18% 77.69% 68.30% 63.16% 68.13% 70.25% 69.36% 54.13% 46.40% 46.21% 73.35% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 150.53% 173.90% 209.45% 157.43% 148.64% 149.28% 134.31% 124.75% 118.00% 131.97% 147.07% 159.25% 119.46% 101.73% 91.08% 95.09% 140.69% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 210.06% 203.10% 235.37% 284.50% 214.65% 203.43% 203.58% 183.41% 169.88% 157.01% 171.56% 186.70% 203.58% <-Median-> 9 Paid Median Price
Cost covered if held 25 years 270.06% 260.24% 300.77% 362.68% 268.38% 249.46% 244.85% 285.41% <-Median-> 4 Paid Median Price
320.46% 303.67%
Yr Item Tot. Grth
Revenue Growth  $2,060.63 $2,093.26 $2,448.82 $2,232.78 $2,346.26 $2,434.97 $2,473.1 <-12 mths 1.56% 18.17% <-Total Growth 5 Revenue Growth  18.17%
FCF Growth $1.73 $1.40 $1.61 $1.68 $1.27 $1.46 $1.41 <-12 mths -3.42% -15.61% <-Total Growth 5 FCF Growth -15.61%
Net Income Growth $360.94 $189.56 $827.73 -$175.19 $271.83 -$163.25 -$140.6 <-12 mths -13.90% -145.23% <-Total Growth 5 Net Income Growth -145.23%
Cash Flow Growth $1,321.60 $1,609.30 $1,832.98 $785.21 $1,028.97 $1,426.16 $1,293.5 <-12 mths -9.30% 7.91% <-Total Growth 5 Cash Flow Growth 7.91%
Dividend Growth $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $0.72 <-12 mths -40.00% 0.00% <-Total Growth 5 Dividend Growth 0.00%
Stock Price Growth $45.67 $37.95 $37.13 $24.07 $17.90 $17.85 $22.64 <-12 mths 26.83% -60.92% <-Total Growth 5 Stock Price Growth -60.92%
Revenue Growth  $728.14 $1,099.00 $1,376.26 $1,555.59 $1,658.98 $2,060.63 $2,093.26 $2,448.82 $2,232.78 $2,346.26 $2,434.97 $2,613.0 <-this year 7.31% 234.41% <-Total Growth 10 Revenue Growth  234.41%
FCF Growth $1.09 $1.40 $1.46 $1.90 $1.77 $1.73 $1.40 $1.61 $1.68 $1.27 $1.46 $1.15 <-this year -21.53% 33.94% <-Total Growth 10 FCF Growth 33.94%
Net Income Growth $1.14 $121.46 $161.12 $278.13 $320.76 $360.94 $189.56 $827.73 -$175.19 $271.83 -$163.25 $213.2 <-this year -230.60% -14382.41% <-Total Growth 10 Net Income Growth -14382.41%
Cash Flow Growth $398.74 $719.81 $849.01 $1,133.88 $1,224.42 $1,321.60 $1,609.30 $1,832.98 $785.21 $1,028.97 $1,426.16 $1,100.9 <-this year -22.81% 257.66% <-Total Growth 10 Cash Flow Growth 257.66%
Dividend Growth $1.08 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $0.72 <-this year -40.00% 11.11% <-Total Growth 10 Dividend Growth 11.11%
Stock Price Growth $18.66 $23.30 $23.35 $21.70 $27.20 $45.67 $37.95 $37.13 $24.07 $17.90 $17.85 $26.71 <-12 mths 17.98% -4.34% <-Total Growth 10 Stock Price Growth -4.34%
Dividends on Shares $58.32 $58.32 $64.80 $64.80 $64.80 $64.80 $64.80 $64.80 $64.80 $64.80 $38.88 $38.88 $38.88 $635.04 No of Years 10 Total Divs 12/31/15
Paid  $1,007.64 $1,258.20 $1,260.90 $1,171.80 $1,468.80 $2,466.18 $2,049.30 $2,005.02 $1,299.78 $966.60 $963.90 $1,222.56 $1,222.56 $1,222.56 $963.90 No of Years 10 Worth $18.66
Total $1,598.94
Graham No. $10.38 $7.38 $7.86 $7.49 $8.64 $12.16 $12.97 $17.27 $14.25 $36.89 $19.16 $19.15 $18.79 $16.98 $22.67 $24.85 139.01% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.63 2.24 2.16 2.81 2.75 1.88 1.93 1.94 3.07 1.10 1.52 1.12 1.12 1.24 1.90 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.90 2.51 2.44 3.35 2.88 2.12 2.16 2.68 3.57 1.24 2.02 1.31 1.37 1.43 2.14 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.36 1.98 1.88 2.28 2.63 1.64 1.69 1.20 2.57 0.95 1.02 0.93 0.86 1.06 1.42 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.49 2.07 2.37 3.11 2.70 1.78 2.10 2.64 2.66 1.01 1.26 0.93 0.95 1.33 1.00 0.91 1.94 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 49.19% 107.06% 137.41% 211.15% 170.22% 78.49% 109.75% 164.39% 166.37% 0.65% 25.60% -6.53% -4.98% 33.32% -0.12% -8.88% 94.12% <-Median-> 10 Graham Price
Price Close $15.48 $15.29 $18.66 $23.30 $23.35 $21.70 $27.20 $45.67 $37.95 $37.13 $24.07 $17.90 $17.85 $22.64 $22.64 $22.64 -4.34% <-Total Growth 10 Stock Price
Increase -17.09% -1.23% 22.04% 24.87% 0.21% -7.07% 25.35% 67.90% -16.90% -2.16% -35.17% -25.63% -0.28% 26.83% 0.00% 0.00% 37.10 <-Median-> 10 CAPE (10 Yr P/E)
P/E 15.03 -18.65 -266.57 36.41 27.47 14.86 16.19 26.10 46.28 10.73 -33.43 17.38 -27.46 27.07 15.19 12.65 -17.13% <-IRR #YR-> 5 Stock Price -60.92%
Trailing P/E -86.00 14.84 -22.76 -332.86 36.48 25.53 18.63 27.18 21.69 45.28 6.96 -24.86 17.33 -34.83 27.07 15.19 -0.44% <-IRR #YR-> 10 Stock Price -4.34%
CAPE (10 Yr P/E) 43.60 74.51 146.16 147.50 72.22 64.53 48.94 39.66 34.53 24.60 30.31 25.41 26.76 26.19 24.63 24.00 -13.23% <-IRR #YR-> 5 Price & Dividend -47.78%
Median 10, 5 Yrs D.  per yr 6.38% 3.90% % Tot Ret 107.45% 0.00% T P/E 20.16 17.33 P/E:  16.78 10.73 5.94% <-IRR #YR-> 10 Price & Dividend 58.68%
Price 15 D.  per yr 6.85% % Tot Ret 88.66% CAPE Diff -27.02% 0.88% <-IRR #YR-> 15 Stock Price 13.98%
Price  20 D.  per yr 6.98% % Tot Ret 88.53% 0.90% <-IRR #YR-> 20 Stock Price 36.57%
Price  25 D.  per yr 9.95% % Tot Ret 77.76% 2.85% <-IRR #YR-> 25 Stock Price 101.69%
Price  30 D.  per yr 8.75% % Tot Ret 80.71% 2.09% <-IRR #YR-> 28 Stock Price
Price & Dividend 15 7.73% <-IRR #YR-> 15 Price & Dividend 123.56%
Price & Dividend 20 7.88% <-IRR #YR-> 20 Price & Dividend 209.37%
Price & Dividend 25 12.80% <-IRR #YR-> 25 Price & Dividend 148.74%
Price & Dividend 30 10.84% <-IRR #YR-> 28 Price & Dividend
Price  5 -$45.67 $0.00 $0.00 $0.00 $0.00 $17.85 Price  5
Price 10 -$18.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.85 Price 10
Price & Dividend 5 -$45.67 $1.20 $1.20 $1.20 $1.20 $19.05 Price & Dividend 5
Price & Dividend 10 -$18.66 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $19.05 Price & Dividend 10
Price 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.85 Price 15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.85 Price  20
Price  25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.85 Price  25
Price  30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.85 Price  30
Price & Dividend 15 $1.08 $1.08 $1.08 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $19.05 Price & Dividend 15
Price & Dividend 20 $1.08 $1.08 $1.08 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $19.05 Price & Dividend 20
Price & Dividend 25 $1.08 $1.08 $1.08 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $19.05 Price & Dividend 25
Price & Dividend 30 $1.08 $1.08 $1.08 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $19.05 Price & Dividend 30
Price H/L Median $16.91 $16.57 $16.96 $21.06 $23.80 $22.85 $24.99 $33.49 $43.74 $40.47 $29.12 $21.54 $21.01 $21.11 23.92% <-Total Growth 10 Stock Price
Increase -6.32% -2.01% 2.32% 24.21% 12.99% -3.97% 9.37% 34.01% 30.59% -7.47% -28.05% -26.03% -2.46% 0.45% 2.17% <-IRR #YR-> 10 Stock Price 23.92%
P/E 16.42 -20.21 -242.21 32.91 27.99 15.65 14.88 19.14 53.34 11.70 -40.44 20.91 -32.32 25.24 -8.90% <-IRR #YR-> 5 Stock Price -37.26%
Trailing P/E -93.94 16.09 -20.68 -300.86 37.18 26.88 17.12 19.93 24.99 49.35 8.42 -29.92 20.40 -32.47 8.50% <-IRR #YR-> 10 Price & Dividend -19.35%
P/E on Run. 5 yr Ave 111.25 -156.32 -130.42 175.50 72.99 55.46 27.40 26.25 33.33 22.07 20.83 16.99 26.66 26.67 -4.59% <-IRR #YR-> 5 Price & Dividend 93.28%
P/E on Run. 10 yr Ave 50.63 84.11 164.61 193.21 99.98 81.03 62.01 58.45 61.08 37.47 32.18 19.76 20.36 20.07 15.49 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 6.33% 4.32% % Tot Ret 74.50% -94.17% T P/E 20.17 20.40 P/E:  17.39 11.70 Count 28 Years of data
-$16.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21.01
-$33.49 $0.00 $0.00 $0.00 $0.00 $21.01
-$16.96 $1.08 $1.08 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $22.21
-$33.49 $1.20 $1.20 $1.20 $1.20 $22.21
High Months Jan Jul Dec Aug Apr Jul Dec Nov Feb Aug Jan Jan Nov Apr Stock Price
Price High $19.72 $18.51 $19.15 $25.06 $24.86 $25.72 $28.00 $46.31 $50.85 $45.75 $38.75 $25.18 $25.78 $24.20 34.62% <-Total Growth 10 Stock Price
Increase 1.81% -6.14% 3.46% 30.86% -0.80% 3.46% 8.86% 65.39% 9.80% -10.03% -15.30% -35.02% 2.38% -6.13% 3.02% <-IRR #YR-> 10 Stock Price 34.62%
P/E 19.15 -22.57 -273.57 39.16 29.25 17.62 16.67 26.46 62.01 13.22 -53.82 24.45 -39.66 28.94 -11.05% <-IRR #YR-> 5 Stock Price -44.33%
Trailing P/E -109.56 17.97 -23.35 -358.00 38.84 30.26 19.18 27.57 29.06 55.79 11.20 -34.97 25.03 -37.23 17.86 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 26.30 25.03 P/E:  21.03 13.22 26.89 P/E Ratio Historical High
-$19.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.78
-$46.31 $0.00 $0.00 $0.00 $0.00 $25.78
Low Months Sep Dec Aug Jan Jun Nov Jan Mar Dec Jan Oct Dec Nov Jan Stock Price
Price Low $14.10 $14.63 $14.76 $17.06 $22.73 $19.98 $21.98 $20.67 $36.62 $35.19 $19.49 $17.90 $16.24 $18.01 10.03% <-Total Growth 10 Stock Price
Increase -15.72% 3.76% 0.89% 15.58% 33.24% -12.10% 10.01% -5.96% 77.16% -3.90% -44.61% -8.16% -9.27% 10.90% 0.96% <-IRR #YR-> 10 Stock Price 10.03%
P/E 13.69 -17.84 -210.86 26.66 26.74 13.68 13.08 11.81 44.66 10.17 -27.07 17.38 -24.98 21.54 -4.71% <-IRR #YR-> 5 Stock Price -21.43%
Trailing P/E -78.33 14.20 -18.00 -243.71 35.52 23.51 15.05 12.30 20.93 42.91 5.63 -24.86 15.77 -27.71 13.11 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 15.41 15.77 P/E:  13.38 10.17 -24.80 P/E Ratio Historical Low
-$14.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16.24
Free Cash Flow Mkt Sc $1,127.0 $307.4 $380.5 $423.7 $327.6 $382.1 $299.6 $386.4 $410.0 <-Total Growth 5 Free Cash Flow Mkt Sc
Change -72.72% 23.78% 11.35% -22.68% 16.64% -21.59% 28.97% 6.11% 11.35% <-Median-> 5 Change
$1,157 <-12 mths 21.97%
Free Cash Flow MS old -$1,494 -$1,611 -$905 $33 $737 $458 $1,095 $719 $1,310
Change -7.83% 43.82% 103.65% 2133.33% -37.86% 139.08% -34.34% 82.20%
Free Cash Flow MS -$163 $1,614.00 $1,753.00 $1,106.00 -$147.63 $401.44 $148.95 $812.99 $565.52 $683.63 $483.53 $436.05 $948.43 $300 $386 -45.90% <-Total Growth 10 Free Cash Flow Mkt Scr
Change 19.31% 1090.18% 8.61% -36.91% -113.35% 371.92% -62.90% 445.81% -30.44% 20.89% -29.27% -9.82% 117.50% -68.41% 28.97% 3.13% <-IRR #YR-> 5 Free Cash Flow MS 16.66%
FCF/CF from Op Ratio -0.63 4.47 4.40 1.54 -0.17 0.35 0.12 0.62 0.35 0.37 0.62 0.42 0.67 0.27 0.30 -5.96% <-IRR #YR-> 10 Free Cash Flow MS -45.90%
Dividends paid $101.97 $115.32 $137.85 $139.89 $134.31 $163.61 $216.37 $220.26 $172.76 $196.85 $205.07 $200.49 $286.01 $188.28 $188.28 107.47% <-Total Growth 10 Dividends paid
Percentage paid 7.86% 12.65% -90.98% 40.75% 145.27% 27.09% 30.55% 28.79% 42.41% 45.98% 30.16% 62.84% 48.73% 30.35% <-Median-> 10 Percentage paid
5 Year Coverage 19.59% 14.29% 15.12% 14.62% 24.28% 37.66% 50.94% 37.12% 37.53% 33.38% 34.04% 37.76% 41.82% 33.71% <-Median-> 10 5 Year Covrage
Dividend Coverage Ratio -1.60 14.00 12.72 7.91 -1.10 2.45 0.69 3.69 3.27 3.47 2.36 2.17 3.32 1.59 2.05 2.86 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 5.10 7.00 6.61 6.84 4.12 2.66 1.96 2.69 2.66 3.00 2.94 2.65 2.39 2.97 <-Median-> 10 5 Year of Coverage
Dividend Calculated $143.62 $162.44 $184.30 $186.81 $189.48 $216.24 $216.53 $242.61 $272.26 $300.02 $305.93 $311.94 $313.80 They have DRIP
Difference from actually paid 29.00% 25.20% 25.30% 25.20% 24.50% 0.12% 9.20% 36.50% 27.80% 27.80% 27.80% 27.80%
Difference from actually paid $115.33 $137.85 $139.55 $141.73 $163.26 $216.27 $220.29 $172.88 $216.62 $220.88 $225.22 $226.57
$1,460 <-12 mths 49.42%
Free Cash Flow WSJ $1,559.41 -$1,666.97 -$1,094.42 -$239.03 $422.87 $169.66 $786 $862 $1,044 $18 $131 $977 $300 $386 -158.61% <-Total Growth 10 Free Cash Flow Sites disag
Change -206.90% 34.35% 78.16% 276.91% -59.88% 363.29% 9.67% 21.11% -98.28% 627.78% 645.80% -69.33% 28.97% 4.45% <-IRR #YR-> 5 Free Cash Flow MS 24.30%
FCF/CF from Op Ratio 4.32 -4.18 -1.52 -0.28 0.37 0.14 0.59 0.54 0.57 0.02 0.13 0.69 0.27 0.30 #NUM! <-IRR #YR-> 10 Free Cash Flow MS 158.61%
Dividends paid $115.32 $137.85 $139.89 $134.31 $163.61 $216.37 $220.26 $172.76 $196.85 $205.07 $200.49 $286.01 $188.28 $188.28 107.47% <-Total Growth 10 Dividends paid
Percentage paid 7.40% -8.27% -12.78% -56.19% 38.69% 127.54% 28.02% 20.04% 18.85% 1139.29% 153.04% 29.27% 62.84% 48.73% 28.65% <-Median-> 10 Percentage paid
5 Year Coverage 0.00% 0.00% 1939.96% 45.33% 29.53% 35.12% 35.04% 35.00% 43.60% 58.95% 35.02% <-Median-> 8 5 Year Covrage
Dividend Coverage Ratio -12.09 -7.82 -1.78 2.58 0.78 3.57 4.99 5.30 0.09 0.65 3.42 1.59 2.05 1.68 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage -3.04 0.05 2.21 3.39 2.85 2.85 2.86 2.29 1.70 5 Year of Coverage
Market Cap $2,059 $2,300 $3,184 $4,030 $4,097 $3,910 $4,908 $9,233 $8,610 $9,283 $6,136 $4,653 $4,668 $5,920 $5,920 $5,920 46.59% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 133.478 146.765 167.555 172.910 175.383 189.593 187.625 201.169 218.861 $236.16 $252.71 $257.30 $261.30 261.502 261.502 261.502 55.95% <-Total Growth 10 Diluted
Change 10.74% 9.95% 14.17% 3.20% 1.43% 8.10% -1.04% 7.22% 8.79% 7.90% 7.01% 1.82% 1.56% 0.08% 0.00% 0.00% 5.10% <-Median-> 10 Change
Difference Diluted/Basic -5.1% 0.0% 0.0% -0.6% 0.0% -6.2% -3.9% -1.2% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.00% <-Median-> 10 Difference Diluted/Basic
Basic # of Shares in Millions 126.719 146.765 167.555 171.910 175.383 177.757 180.322 198.774 218.861 $236.16 $252.71 $257.30 $261.30 261.502 261.502 261.502 55.95% <-Total Growth 10 Basic
Change 5.13% 15.82% 14.17% 2.60% 2.02% 1.35% 1.44% 10.23% 10.11% 7.90% 7.01% 1.82% 1.56% 0.08% 0.00% 0.00% 2.31% <-Median-> 10 Change
Difference Basic/Outstanding 4.9% 2.5% 1.8% 0.6% 0.0% 1.4% 0.1% 1.7% 3.7% 5.9% 0.9% 1.0% 0.1% 0.0% 0.0% -100.0% 0.96% <-Median-> 10 Difference Basic/Outstanding
Weighted Average Shares 125.719 145.765 170.120 172.910 174.383 176.757 179.332 197.774 $218.86 $236.16 $252.71 $257.30 $261.30 261.502 261.502 53.60% <-Total Growth 10 Weighted Average Shares
Change 15.95% 16.71% 1.64% 0.85% 1.36% 1.46% 10.28% 10.66% 7.90% 7.01% 1.82% 1.56% 0.08% 0.00% 1.73% <-Median-> 10 Change
Difference Basic/Outstanding 5.8% 3.2% 0.3% 0.0% 0.6% 1.9% 0.6% 2.2% 3.7% 5.9% 0.9% 1.0% 0.1% 0.0% -100.0% 0.96% <-Median-> 10 Difference Basic/Outstanding
$1,293.5 <-12 mths -9.30%
# of Share in Millions 132.979 150.410 170.645 172.973 175.440 180.202 180.441 202.171 226.883 250.017 254.940 259.947 261.502 261.502 261.502 261.502 4.36% <-IRR #YR-> 10 Shares 53.24%
Change 10.65% 13.11% 13.45% 1.36% 1.43% 2.71% 0.13% 12.04% 12.22% 10.20% 1.97% 1.96% 0.60% 0.00% 0.00% 0.00% 5.28% <-IRR #YR-> 5 Shares 29.35%
Cash Flow from Operations $M $257.1 $361.0 $398.7 $719.8 $849.0 $1,133.9 $1,224.4 $1,321.6 $1,609.3 $1,833.0 $785.2 $1,029.0 $1,426.2 $1,100.9 $1,308.0 $1,501.8 257.66% <-Total Growth 10 Cash Flow
Increase 59.01% 40.42% 10.46% 80.52% 17.95% 33.55% 7.98% 7.94% 21.77% 13.90% -57.16% 31.04% 38.60% -22.81% 18.81% 14.81% Deb Conv. S. Issued, DRIP SO Ex. Replacement R.
5 year Running Average $140.1 $199.4 $261.2 $379.7 $517.1 $692.5 $865.2 $1,049.7 $1,227.6 $1,424.4 $1,354.7 $1,315.6 $1,336.5 $1,234.9 $1,129.9 $1,273.2 411.70% <-Total Growth 10 CF 5 Yr Running
CFPS $1.93 $2.40 $2.34 $4.16 $4.84 $6.29 $6.79 $6.54 $7.09 $7.33 $3.08 $3.96 $5.45 $4.21 $5.00 $5.74 133.40% <-Total Growth 10 Cash Flow per Share
Increase 43.71% 24.14% -2.64% 78.09% 16.29% 30.03% 7.84% -3.66% 8.51% 3.36% -57.99% 28.52% 37.78% -22.81% 18.81% 14.81% 13.59% <-IRR #YR-> 10 Cash Flow 257.66%
5 year Running Average $1.21 $1.52 $1.82 $2.44 $3.13 $4.01 $4.88 $5.72 $6.31 $6.81 $6.17 $5.60 $5.38 $4.81 $4.34 $4.87 1.53% <-IRR #YR-> 5 Cash Flow 7.91%
P/CF on Med Price 8.75 6.90 7.26 5.06 4.92 3.63 3.68 5.12 6.17 5.52 9.45 5.44 3.85 5.01 0.00 0.00 8.85% <-IRR #YR-> 10 Cash Flow per Share 133.40%
P/CF on Closing Price 8.01 6.37 7.99 5.60 4.83 3.45 4.01 6.99 5.35 5.06 7.81 4.52 3.27 5.38 4.53 3.94 -3.56% <-IRR #YR-> 5 Cash Flow per Share -16.57%
5.61% Diff M/C 11.48% <-IRR #YR-> 10 CFPS 5 yr Running 196.59%
$1,449.2 <-12 mths 3.66%
Excl.Working Capital CF $8.0 -$5.6 -$5.1 $8.2 $90.4 -$18.0 -$17.1 $32.2 -$292.5 -$289.9 $466.3 $305.1 -$28.1 $0.0 $0.0 $0.0 -1.22% <-IRR #YR-> 5 CFPS 5 yr Running -5.94%
Cash Flow from Operations $M WC $265.0 $355.4 $393.7 $728.0 $939.4 $1,115.9 $1,207.3 $1,353.8 $1,316.8 $1,543.1 $1,251.5 $1,334.1 $1,398.1 $1,100.9 $1,308.0 $1,501.8 255.15% <-Total Growth 10 Cash Flow less WC
Increase 51.64% 34.09% 10.77% 84.94% 29.04% 18.78% 8.19% 12.14% -2.74% 17.19% -18.90% 6.59% 4.80% -21.25% 18.81% 14.81% 13.51% <-IRR #YR-> 10 Cash Flow less WC 255.15%
5 year Running Average $150.0 $205.4 $266.3 $383.4 $536.3 $706.5 $876.9 $1,068.9 $1,186.7 $1,307.4 $1,334.5 $1,359.9 $1,368.7 $1,325.5 $1,278.5 $1,328.6 0.64% <-IRR #YR-> 5 Cash Flow less WC 3.27%
CFPS Excl. WC $1.99 $2.36 $2.31 $4.21 $5.35 $6.19 $6.69 $6.70 $5.80 $6.17 $4.91 $5.13 $5.35 $4.21 $5.00 $5.74 17.79% <-IRR #YR-> 10 CF less WC 5 Yr Run 414.01%
Increase 37.05% 18.55% -2.36% 82.45% 27.23% 15.64% 8.05% 0.08% -13.33% 6.34% -20.46% 4.54% 4.17% -21.25% 18.81% 14.81% 5.07% <-IRR #YR-> 5 CF less WC 5 Yr Run 28.05%
5 year Running Average $1.31 $1.57 $1.86 $2.47 $3.25 $4.09 $4.95 $5.83 $6.15 $6.31 $6.05 $5.74 $5.47 $5.15 $4.92 $5.09 8.77% <-IRR #YR-> 10 CFPS - Less WC 131.76%
P/CF on Med Price 8.48 7.01 7.35 5.00 4.44 3.69 3.73 5.00 7.54 6.56 5.93 4.20 3.93 5.01 0.00 0.00 -4.40% <-IRR #YR-> 5 CFPS - Less WC -20.16%
P/CF on Closing Price 7.77 6.47 8.09 5.54 4.36 3.50 4.07 6.82 6.54 6.02 4.90 3.49 3.34 5.38 4.53 3.94 11.39% <-IRR #YR-> 10 CFPS 5 yr Running 194.15%
*Operational Cash Flow CF/CF-WC P/CF Med 10 yr 5.09 5 yr  5.52 P/CF Med 10 yr 4.72 5 yr  5.93 13.88% Diff M/C -1.25% <-IRR #YR-> 5 CFPS 5 yr Running -6.11%
-$2.34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.45 Cash Flow per Share
-$6.54 $0.00 $0.00 $0.00 $0.00 $5.45 Cash Flow per Share
-$1.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $5.4 CFPS 5 yr Running
-$5.7 $0.0 $0.0 $0.0 $0.0 $5.4 CFPS 5 yr Running
-$393.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,398.1 Cash Flow less WC
-$1,353.8 $0.0 $0.0 $0.0 $0.0 $1,398.1 Cash Flow less WC
-$266.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,368.7 CF less WC 5 Yr Run
-$1,068.9 $0.0 $0.0 $0.0 $0.0 $1,368.7 CF less WC 5 Yr Run
-$2.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.35 CFPS - Less WC
-$6.70 $0.00 $0.00 $0.00 $0.00 $5.35 CFPS - Less WC
OPM 46.13% 47.49% 54.76% 65.50% 61.69% 72.89% 73.81% 64.14% 76.88% 74.85% 35.17% 43.86% 58.57% 42.13% 6.95% <-Total Growth 10 OPM
Increase 3.38% 2.95% 15.30% 19.60% -5.81% 18.16% 1.25% -13.10% 19.87% -2.64% -53.02% 24.70% 33.55% -28.06% Should increase  or be stable.
Diff from Median -28.8% -26.7% -15.5% 1.0% -4.8% 12.5% 13.9% -1.0% 18.6% 15.5% -45.7% -32.3% -9.6% -35.0% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 64.82% 5 Yrs 58.57% should be  zero, it is a   check on calculations
$1,333 <-12 mths 6.37%
Adjusted EBITDA $263.30 $363.50 $402.11 $626.90 $765.18 $891.48 $984.74 $1,170.10 $1,137.00 $1,398.18 $1,239.87 $1,261.95 $1,252.99 $1,485 $1,713 $1,784 211.61% <-Total Growth 10 Adjusted EBITDA
Change 47.41% 38.06% 10.62% 55.90% 22.06% 16.51% 10.46% 18.82% -2.83% 22.97% -11.32% 1.78% -0.71% 18.52% 15.35% 4.14% 12.04% <-IRR #YR-> 10 Adjusted EBITDA Change
Margin  47.25% 47.82% 55.22% 57.04% 55.60% 57.31% 59.36% 56.78% 54.32% 57.10% 55.53% 53.79% 51.46% 56.83% 62.95% 56.63% 1.38% <-IRR #YR-> 5 Adjusted EBITDA Margin 
Leverage with EBITDA (D/EBITDA) 7.93 10.63 14.82 11.63 11.53 9.87 9.11 8.03 8.72 6.79 7.37 7.17 7.03 8.37 <-Median-> 10 Leverage with EBITDA  (Should not be over 3, but it depends on industry).
-$402.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,252.99
-$1,170.10 $0.00 $0.00 $0.00 $0.00 $1,252.99
$330 <-12 mths 18.06%
EBIT (using Operating Income.) $248.78 $274.09 $508.64 $632.13 $732.85 $813.70 $900.20 $808.60 $1,051.00 $741.20 $812.90 $279.39 $919 $1,016 $1,177 1.93% <-Total Growth 10 EBIT
Change 10.17% 85.57% 24.28% 15.93% 11.03% 10.63% -10.18% 29.98% -29.48% 9.67% -65.63% 228.78% 10.60% 15.85% 10.83% <-Median-> 10 Change
Margin  32.73% 37.64% 46.28% 45.93% 47.11% 49.05% 43.69% 38.63% 42.92% 33.20% 34.65% 11.47% 35.15% 37.34% 37.37% 43.30% <-Median-> 10 Margin 
Leverage with EBIT (D/EBIT) 15.53 21.74 14.33 13.96 12.00 11.02 10.44 12.26 9.04 12.34 11.13 31.55 9.40 0.00 0.00 12.13 <-Median-> 10 Leverage with EBIT (D/EBIT)
Long Term Debt $2,553.96 $4,507.98 $5,621.54 $6,271.27 $6,583.00 $6,496.68 $6,980.16 $6,956.66 $6,177.84 $6,436.38 $6,071.30 $5,798.32 137.72% <-Total Growth 10 Debt
Change 76.51% 24.70% 11.56% 4.97% -1.31% 7.44% 7.44% -0.34% -11.20% 4.18% -5.67% 6.21% <-Median-> 10 Change
Property, Plant and Equipment $8,879.10 $8,173.94 $8,052.76 Property, Plant and Equipment
Debt/Asset Cap Ratio 0.72 0.74 0.72 0.73 <-Median-> 2 Debt/Asset Cap Ratio
Long Term Debt $2,553.96 $4,507.98 $5,621.54 $6,271.27 $6,583.00 $6,496.68 $6,980.16 $6,956.66 $6,177.84 $6,436.38 $6,071.30 $5,798.32 137.72% <-Total Growth 10 Debt Type
Change 76.51% 24.70% 11.56% 4.97% -1.31% 7.44% 7.44% -0.34% -11.20% 4.18% -5.67% 6.21% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.80 1.12 1.37 1.60 1.34 0.70 0.81 0.75 1.01 1.38 1.30 0.98 1.21 <-Median-> 10 Debt/Market Cap Ratio Lg Term A
Assets/Current Liabilities Ratio 10.25 17.69 17.99 11.57 13.22 7.50 10.76 9.17 10.68 10.22 11.58 11.60 11.16 <-Median-> 10 Assets/Current Liab Ratio Intang/GW
Debt to Cash Flow (Years) 0.00 6.41 6.26 6.62 5.53 5.38 4.92 4.34 3.80 7.87 6.26 4.26 5.27 5.45 <-Median-> 10 Debt to Cash Flow (Years) Liquidity
Liq. + CF
Intangibles $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $521.05 $533.17 $497.64 $515.62 $446.87 $393.89 $392.62 $375.44 Intangibles Debt Ratio
Goodwill $220.17 $219.24 $206.53 $206.53 $204.94 $204.94 $204.72 $708.71 $753.37 $712.62 $639.35 $617.61 $669.21 $738.27 224.02% <-Total Growth 10 Goodwill Leverage
Total $220.17 $219.24 $206.53 $206.53 $204.94 $204.94 $725.77 $1,241.88 $1,251.01 $1,228.24 $1,086.22 $1,011.49 $1,061.82 $1,113.71 414.13% <-Total Growth 10 Total D/E Ratio
Change -1.08% -0.42% -5.80% 0.00% -0.77% 0.00% 254.14% 71.11% 0.74% -1.82% -11.56% -6.88% 4.98% 4.89% 0.00% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.11 0.10 0.06 0.05 0.05 0.05 0.15 0.13 0.15 0.13 0.18 0.22 0.23 0.19 0.14 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $363.45 $353.51 $593.29 $672.09 $1,011.91 $1,051.79 $1,278.79 $1,076.68 $1,414.69 $2,348.96 $1,446.69 $1,392.06 $1,227.08 $1,185.18 Liquidity ratio of 1.5 and up, best
Current Liabilities $159.59 $484.60 $416.34 $481.65 $888.42 $781.58 $1,398.00 $1,059.86 $1,404.55 $1,908.85 $1,276.02 $1,331.10 $1,143.38 $1,135.56 1.10 <-Median-> 10 Ratio
Liquidity 2.28 0.73 1.43 1.40 1.14 1.35 0.91 1.02 1.01 1.23 1.13 1.05 1.07 1.04 1.07 <-Median-> 5 Ratio
Liq. with CF aft div 2.99 1.14 1.94 2.50 1.88 2.52 1.64 2.03 1.96 2.03 1.51 1.58 2.05 1.85 1.96 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.79 0.24 1.94 0.60 0.80 1.44 1.06 1.14 1.13 1.53 0.79 1.18 1.88 1.85 1.18 <-Median-> 5 Ratio
Assets $3,040 $4,966 $7,366 $8,663 $10,281 $10,336 $10,479 $11,399 $12,877 $14,223 $13,626 $13,604 $13,238 $13,177 Debt Ratio of 1.5 and up, best
Liabilities $2,087 $3,863 $5,959 $7,288 $8,823 $8,795 $8,968 $9,397 $9,912 $9,498 $9,144 $9,048 $8,814 $8,637 1.26 <-Median-> 10 Ratio
Debt Ratio 1.46 1.29 1.24 1.19 1.17 1.18 1.17 1.21 1.30 1.50 1.49 1.50 1.50 1.53 1.50 <-Median-> 5 Ratio
Estimates BVPS $15.76 $17.05 $18.55 Estimates Estimates BVPS
Estimate Book Value $4,121.3 $4,458.6 $4,850.9 Estimates Estimate Book Value
P/B Ratio (Close) 1.44 1.33 1.22 Estimates P/B Ratio (Close)
Difference from 10 year median -65.78% Diff M/C Estimates Difference from 10 yr med.
check on Shareholder Book Value $952.7 $1,102.2 $1,407.1 $1,375.1 $1,457.9 $1,540.6 $1,510.8 $2,002.77 $2,965.71 $4,724.27 $4,482.72 $4,556.41 $4,424.54 $4,540.08 check on Sharehldr BV
common shares common shares
Comm. Per share Comm. Per share
check total assets $3,040 $4,966 $7,366 $8,663 $10,281 $10,336 $10,479 $11,399.47 $12,877.33 $14,222.61 $13,626.30 $13,604.34 $13,238.36 $13,176.95 check total assets
Total Book Value $952.7 $1,102.2 $1,407.1 $1,375.1 $1,457.9 $1,540.6 $1,510.8 $2,002.77 $2,965.71 $4,724.27 $4,482.72 $4,556.41 $4,424.54 $4,540.08 $4,540.1 $4,540.1 214.45% <-Total Growth 10 Total Book Value
NCI $73.3 $271.4 $413.9 $440.6 $512.1 $468.9 $447.1 $209.88 $208.83 $208.83 $297.55 $297.55 $297.55 $387.18 $387.2 $387.2 NCI
Preferred Shares $261.7 $261.3 $261.1 $260.9 $260.9 $260.9 $260.9 $260.88 $260.88 $144.84 $144.84 $144.84 $144.84 $144.84 $144.8 $144.8 Preferred Shares
Book Value $617.7 $569.5 $732.1 $673.6 $684.9 $810.8 $802.7 $1,532.01 $2,496.00 $4,370.60 $4,040.33 $4,114.02 $3,982.15 $4,008.06 $4,008.06 $4,008.06 443.94% <-Total Growth 10 Book Value
Book Value per Share $4.65 $3.79 $4.29 $3.89 $3.90 $4.50 $4.45 $7.58 $11.00 $17.48 $15.85 $15.83 $15.23 $15.33 $15.33 $15.33 254.96% <-Total Growth 10 Book Value per Share
Change 27.20% -18.49% 13.30% -9.23% 0.25% 15.25% -1.13% 70.34% 45.18% 58.90% -9.34% -0.14% -3.78% 0.65% 0.00% 0.00% -19.61% P/B Ratio Current/Historical Median
P/B Ratio (Median) 3.64 4.38 3.95 5.41 6.09 5.08 5.62 4.42 3.98 2.32 1.84 1.36 1.38 1.38 1.84 P/B Ratio Historical Median
P/B Ratio (Close) 3.33 4.04 4.35 5.98 5.98 4.82 6.11 6.03 3.45 2.12 1.52 1.13 1.17 1.48 1.48 1.48 13.51% <-IRR #YR-> 10 Book Value per Share 254.96%
Change -34.82% 21.18% 7.72% 37.56% -0.04% -19.36% 26.78% -1.43% -42.76% -38.43% -28.49% -25.53% 3.64% 26.02% 0.00% 0.00% 14.98% <-IRR #YR-> 5 Book Value per Share 100.96%
Leverage (A/BK) 3.19 4.51 5.24 6.30 7.05 6.71 6.94 5.69 4.34 3.01 3.04 2.99 2.99 2.90 5.02 <-Median-> 10 A/BV
Debt/Equity Ratio 2.19 3.51 4.24 5.30 6.05 5.71 5.94 4.69 3.34 2.01 2.04 1.99 1.99 1.90 4.02 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 4.20 5 yr Med 1.84 -64.81% Diff M/C 2.78 Historical Leverage (A/BK)
-$4.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.23
-$7.58 $0.00 $0.00 $0.00 $0.00 $15.23
$93.0 <-12 mths -40.64%
Comprehensive Income $166.21 -$234.26 $108.47 $130.42 $295.58 $344.54 $292.48 $368.28 $280.62 $1,316.95 $1.84 $308.56 $240.20 121.45% <-Total Growth 10 Comprehensive Income
NCI $15.89 -$22.86 $57.52 $45.50 $134.34 $114.71 $77.66 $115.95 $97.34 $213.30 $65.34 $100.76 $83.46 45.10% <-Total Growth 10 NCI
Shareholders $150.32 -$211.40 $50.95 $84.92 $161.24 $229.83 $214.83 $252.34 $183.27 $1,103.66 -$63.50 $207.79 $156.75 207.62% <-Total Growth 10 Shareholders
Increase 1658.20% -240.63% 124.10% 66.66% 89.87% 42.54% -6.53% 17.46% -27.37% 502.19% -105.75% 427.23% -24.57% -24.6% <-Median-> 5 Comprehensive Income
5 Yr Running Average $22.66 -$26.55 -$16.62 $13.03 $47.21 $63.11 $148.35 $188.63 $208.30 $396.78 $338.12 $336.71 $317.59 11.89% <-IRR #YR-> 10 Comprehensive Income 207.62%
ROE 15.8% -19.2% 3.6% 6.2% 11.1% 14.9% 14.2% 12.6% 6.2% 23.4% -1.4% 4.6% 3.5% -9.08% <-IRR #YR-> 5 Comprehensive Income -37.88%
5Yr Median 0.2% -1.4% -1.4% 3.6% 6.2% 6.2% 11.1% 12.6% 12.6% 14.2% 12.6% 6.2% 4.6% #NUM! <-IRR #YR-> 10 5 Yr Running Average 2010.59%
% Difference from NI -0.6% 98.4% 4357.9% -30.1% 0.1% -17.4% -33.0% -30.1% -3.3% 33.3% -63.8% -23.6% -196.0% 10.98% <-IRR #YR-> 5 5 Yr Running Average 68.37%
Median Values Diff 5, 10 yr -26.8% -23.6% 4.6% <-Median-> 5 Return on Equity
-$51.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $156.7
-$252.3 $0.0 $0.0 $0.0 $0.0 $156.7
$16.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $317.6
-$188.6 $0.0 $0.0 $0.0 $0.0 $317.6
Current Liability Coverage Ratio 1.66 0.73 0.95 1.51 1.06 1.43 0.86 1.28 0.94 0.81 0.98 1.00 1.22 0.97   CFO / Current Liabilities
5 year Median 0.75 0.74 0.95 1.21 1.06 1.06 1.06 1.28 1.06 0.94 0.94 0.98 0.98 0.98 1.03 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 8.72% 7.16% 5.34% 8.40% 9.14% 10.80% 11.52% 11.88% 10.23% 10.85% 9.18% 9.81% 10.56% 8.35% CFO / Total Assets
5 year Median 6.33% 6.94% 6.94% 7.16% 8.40% 8.40% 9.14% 10.80% 10.80% 10.85% 10.85% 10.23% 10.23% 9.81% 10.4% <-Median-> 10 Return on Assets 
Return on Assets ROA 4.97% -2.15% 0.02% 1.40% 1.57% 2.69% 3.06% 3.17% 1.47% 5.82% -1.29% 2.00% -1.23% 1.62% Net  Income/Assets Return on Assets
5Yr Median 0.07% -0.39% -0.39% 0.02% 1.40% 1.40% 1.57% 2.69% 2.69% 3.06% 3.06% 2.00% 1.47% 1.62% 1.8% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 15.87% -9.67% 0.08% 8.83% 11.05% 18.05% 21.23% 18.02% 6.39% 17.52% -3.91% 5.97% -3.69% 4.70% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 0.17% -1.41% -1.41% 0.08% 8.83% 8.83% 11.05% 18.02% 18.02% 18.02% 17.52% 6.39% 5.97% 4.70% 9.9% <-Median-> 10 Return on Equity
-$140.6 <-12 mths 13.90%
Net Income $167.02 -$177.5 $27.53 $190.56 $275.84 $405.51 $451.75 $485.06 $269.88 $955.46 -$96.13 $371.39 -$108.36 -493.59% <-Total Growth 10 Net Income
NCI $15.86 -$70.88 $26.39 $69.10 $114.71 $127.38 $130.99 $124.12 $80.32 $127.72 $79.06 $99.56 $54.89 108.01% <-Total Growth 10 NCI
Shareholders $151.16 -$106.6 $1.14 $121.46 $161.12 $278.13 $320.76 $360.94 $189.56 $827.73 -$175.19 $271.83 -$163.25 $213.2 $352.7 $371.3 -14382.41% <-Total Growth 10 Shareholders
Increase -1624.91% -170.50% -101.07% 10526.77% 32.65% 72.62% 15.33% 12.52% -47.48% 336.66% -121.17% -255.16% -160.06% -230.60% 65.43% 5.27% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $22.96 -$5.40 -$5.46 $31.46 $65.66 $91.06 $176.52 $248.48 $262.10 $395.42 $304.76 $294.97 $190.14 $194.86 $99.86 $209.16 #NUM! <-IRR #YR-> 10 Net Income -14382.41%
Operating Cash Flow $257.08 $361.0 $398.7 $719.8 $849.0 $1,133.9 $1,224.4 $1,321.6 $1,609.3 $1,833.0 $785.2 $1,029.0 $1,426.2 #NUM! <-IRR #YR-> 5 Net Income -145.23%
Investment Cash Flow -$444.16 -$1,808.9 $73.5 -$1,536.3 -$1,189.2 -$586.0 -$758.0 -$839.3 -$1,030.9 -$629.7 -$1,170.1 -$448.8 -$99.4 #NUM! <-IRR #YR-> 10 5 Yr Running Ave. 3584.11%
Total Accruals $338.24 $1,341.3 -$471.1 $937.9 $501.3 -$269.8 -$145.7 -$121.4 -$388.9 -$375.6 $209.6 -$308.3 -$1,490.0 -5.21% <-IRR #YR-> 5 5 Yr Running Ave. -23.48%
Total Assets $3,040 $4,966 $7,366 $8,663 $10,281 $10,336 $10,479 $11,399 $12,877 $14,223 $13,626 $13,604 $13,238 Balance Sheet Assets
Accruals Ratio 11.13% 27.01% -6.40% 10.83% 4.88% -2.61% -1.39% -1.06% -3.02% -2.64% 1.54% -2.27% -11.26% -2.64% <-Median-> 5 Ratio
EPS/CF Ratio 0.52 -0.35 -0.03 0.15 0.16 0.24 0.25 0.26 0.14 0.56 -0.15 0.20 -0.12 0.18 <-Median-> 10 EPS/CF Ratio
-$1.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$163.25
-$360.94 $0.00 $0.00 $0.00 $0.00 -$163.25
$5.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $190.14
-$248.48 $0.00 $0.00 $0.00 $0.00 $190.14
Chge in Close -17.09% -1.23% 22.04% 24.87% 0.21% -7.07% 25.35% 67.90% -16.90% -2.16% -35.17% -25.63% -0.28% 26.83% 0.00% 0.00% Count 29 Years of data
up/down/neutral down down down up down up Count 15 51.72%
Any Predictions? Yes Yes % right Count 3 20.00%
Financial Cash Flow $293.68 $1,524.02 $1,793.43 $971.07 $408.15 -$681.45 -$471.10 -$389.53 -$255.68 -$604.84 -$262.04 -$720.25 -$1,323.21 C F Statement  Financial CF
Total Accruals $44.56 -$182.72 -$2,264.54 -$33.14 $93.13 $411.65 $325.45 $268.14 -$133.19 $229.27 $471.69 $411.92 -$166.84 Accruals
Accruals Ratio 1.47% -3.68% -30.74% -0.38% 0.91% 3.98% 3.11% 2.35% -1.03% 1.61% 3.46% 3.03% -1.26% 1.61% <-Median-> 5 Ratio
Cash $138.46 $193.41 $151.93 $307.52 $400.57 $278.40 $268.19 $434.99 $673.69 $1,299.83 $642.48 $613.32 $643.29 $645.90 Cash
Cash per Share $1.04 $1.29 $0.89 $1.78 $2.28 $1.54 $1.49 $2.15 $2.97 $5.20 $2.52 $2.36 $2.46 $2.47 $2.52 <-Median-> 5 Cash per Share
Percentage of Stock Price 6.73% 8.41% 4.77% 7.63% 9.78% 7.12% 5.46% 4.71% 7.82% 14.00% 10.47% 13.18% 13.78% 10.91% 13.18% <-Median-> 5 % of Stock Price
Notes:
November 1, 2026.  Last estimates were for 2025, 2026, 2027 of $2353M, $2.572M, $2753M Revenue, $1.27, 1.56, $407M 2025/6 AFCF, $1.30 2025 FCF, $0.56, $1.65 $1.67 EPS, $1.20, $1.20, $1.20 Dividends, 
$323M, $354.8M, $573.5M FCF, $4.66, $5.45, $6.56 CFPS, $1225M, $1533M, $1745M EBITDS, $647.5, $895.5, $1000M EBIT, $15.70, $16.20, $16.46 BVPS, $148.4M, $425.6M, $492.1M Net Income.
November 8, 2025.  Last estimates were for 2024, 2025, 2026 of $2379M, $2401M, $2723M for Revenue, $386M, $381M 2024/5 AFCF, $328M, $328M 2024/5 FCF,$1.65, $1.28, $1.84 EPS, 
$1.20, $1.20, $1.20 Dividends, $370M, $319M 2024/5 FCF, $3.98, $3.98, $5.70 CFPS, $1302M, $1327M, $1513M EBITDA, $16.44, $16.78, $18.01 BVPS, $424.2m, $310.9m, $338M Net Income.
November 10, 2024.  Last estimates were for 2023, 2024 and 2024 of $2214M, $2312M, $2344M for Revenue, $1.68, $1.76, $1.80 A FCF, $1.30, $1.43 and $1.54 FCF, $0.92, $1.30, $1.14 EPS, 
$$1.20, $1.20, $1.20 Dividends, $349, $370M, $319M FCF, $4.05, $3.64, $3.74 CFPS, $1204<. $1287M, $1331M Adj EBITDA, $10.50, $11.10, $12.10 BVPS, $237M, $345M, $356M Net Income.  
November 11, 2023.  Last estimates were for 2022, 2023 and 2024 of $2424M, $2281M and $2315M for Revenue, $1.57, $1.66 and $1.71 for AEPS, $2.80, $1.65 and $1.70 for EPS, 
$1.20, $1.20 and $1.20 for dividends, $425M, $466M and $4.65m for FCF, $5.78, $4.72 and $4.62 for CFPS, $10.90, $10.70 and 11.10 for BVPS, and $671M, $416M and $451M for Net Income.
November 13, 2022.  Last estimates were for 2021, 2022 and 2023 of $2019M, $2301M, 2242M for Revenue, $0.83, $1.52 and $1.59 for EPS, $1.20, $1.20 and $1.21 for Dividends, 
$293M, $335M and $510M, $5.03, $5.12 and $5.34 for CFPS, $168M, $342M and $372M for Net Income.
November 14, 2021.  Last estimates were for 2020, 2021 and 2022 of $2082M, $2125M and $2130M for Revenue, $2.01, 1.75 and $1.81 for EPS, 
$1.20, $1.21 and $1.21 for Dividends, $465M, $477M and $497M for FCF, $5.92, $5.69 and $5.00 for CFPS, and $448M, $422M and $417M for Net Income.
November 27, 2020.  Last estimates were for 2019, 2020 and 2021 of1660M, $2161M and 2377M, $1.78, $1.92 and $2.19 for EPS, 
$1.20, $1.24 and $1.26 for Dividends, $4.32, $4.70 and $4.68 for CFPS and $353M, $411M and $443M for Net Income.
November 29, 2019.  Last estimates were for 2018, 2019 and 2020 of $1560M, $1618Mand $1859M for Revenue, $1.57, $1.44 and $2.14 for EPS, 
$4.31, $4.18 and $4.98 for CFPS and $294M, $273M and $389M for Net Income.
December 2, 2018.  Last estimates were for 2017, 2018 and 2019 of $1322M, $1521M and $1574M for Revenue, $1.01, $1.46 and $1.51 for EPS, 
$2.49, $2.78 and $2.68 for CFPS and $199M, 279M and $272M for Net Income.
December 3, 2017.  Last estimates were for 2016, 2017 and 2018 of $999M, $1167M and $1535M for Revenue, $0.41, $0.61 and $1.26 for EPS, 
$2.15, $2.13 and $3.05 for CFPS and $25M, $112M and $230M for Net Income.
December 3, 2016.  Last estiamtes were for 2015, 2016 and 2017 of $86.6M, $102M and $114M for Revenue, $1.06, $1.22 and $1.44 for EPS 
and $20.8M, $22.4M and $25.3M for Net Income.
For 2015, there is a small Net Income, but a EPS loss because of Preferred dividends taken off of Net Income to get Income for EPS calculations.
December 8, 2015.  Last estimates were for 2014, 2015 and 2016 for $739M, $711M and $732M for Revenue, $0.34, $0.40 and $0.55 for EPS, 
$1.55, $1.73 and $1.86 for CFPS, $59M, $66.3M and $91.2M for Net Income.
November 23, 2014.  Last estimates were for 2013, 2014 and 2015 of $504.3M, $637.2M and $658M for Revenue, $0.93, $0.53 and $0.79 for EPS, $1.41, $1.85 and $2.01 for CFPS.
November 10, 2013.  Last Estimates were for 2012 and 2013 of $369M and $502M for Revenue, $.14 and $.35 for EPS.
Class B Exchangeable shares were reclassified as a liability on December 31, 2012.
Sep 28, 2012.  Estimates for 2011 and 2012 were $331M and $410M for Revenue, $0.78 and $0.57 for DI and $0.36 and $0.30 for EPS and $1.05 and $1.07 for CF,
There seems to be some controversy about outstanding shares. I have included exchangeable shares in number of shares and a book value.
Class A Exchangeable Units or Replacement Rights are not entitled to any cash distributions until January 2012.
Ex-chairman James Temerty seems to own all or mostly all of the outstanding convertible shares.
In 2011 Northland Power Inc. (NPI) merged with Northland Power Income Fund. Class A shares and regular replacement rights became exchangeable into common shares.
Jul 2011. Management expects distributions to exceed 100% of Free Cash Flow until 2013.
Jan 2011.  Company changed from an Income Trust (NPI.UN) to a Corporation 1 January 2011.  Have a tax pool that should last until 2019.
I am looking at this stock as eventually, I want to get away from pipelines and into energy, especially renewable enery.
An initial instalment of $6 per Trust Unit was paid on April 15, 1997 and the final instalment of $4 per Trust Unit is due no later than April 15, 1998.
Sector:
Power, Utility
What should this stock accomplish?
As a Utility it should add stability to you portfolio.
Would I buy this company and Why.
In the past it could not afford its dividends and could not increase them.  Now after some 10 years, DPR is getting under control and they have raised their dividends.
Why am I following this stock. 
This company is into generating electric power.  I have a lot invested in pipelines and I would like to have more invested in electric power as part of my utility’s investments.  I read a report on this stock that said it was a good 
defensive stock to buy.  That is, it is a good stock to hold in a stock market correction.  I can certainly see the logic of using utility stocks as defensive stocks.  
Dividends
Dividends are paid monthly.  Dividends are declared in one month for payment to shareholders of records of that month and then paid in the following month.
For example, Dividends declared in January 2013 for shareholders of records of January 31, 2013 and paid on February 15, 2013.
How they make their money.
Northland Power develops, constructs, and operates sustainable infrastructure assets across a range of clean and green technologies, such as wind (offshore and onshore), 
solar, and supplying energy through a regulated utility. Offshore wind is expected to remain the company's largest segment over the long term. Northland's growth 
opportunities are global and span North America, Europe, Latin America, and Asia.
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.  
Also, for the Operational Profit Margin, a higher percentage is better.  With the OPM, you should only compare companies in similar industries.
Shares; '%, Value $M %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M From Proxy Change
Date 2018 Nov 29 2019 Nov 27 2020 Nov 14 2021 Nov 13 2022 Nov 11 2023 Nov 10 2024 Nov 8 2025 Nov 1 2026
Healy, Christine 0.000 0.00% 0.057 0.02% New CEO 2025 #DIV/0!
CEO - Shares - Amount $0.000 $1.282
Options - percentage 0.285 0.11% 0.000 0.00% -100.00%
Options - amount $5.088 $0.000
Crawley, Mike 0.04% 0.071 0.04% 0.074 0.04% 0.076 0.03% 0.076 0.03% 0.096 0.04% Ceased insider Sep 2024
CEO - Shares - Amount $1.452 $1.932 $3.381 $2.892 $2.829 $2.315 John Brace is interium CEO
Options - percentage 0.02% 0.082 0.05% 0.130 0.06% 0.140 0.06% 0.124 0.05% 0.268 0.11% See Chairman
Options - amount $0.749 $2.240 $5.940 $5.324 $4.593 $6.445
Hart, Jeff 0.000 0.00% 0.010 0.00% 2632.24%
CFO - Shares - Amount $0.007 $0.226
Options - percentage 0.010 0.00% 0.042 0.02% 332.18%
Options - amount $0.174 $0.953
Beaumont, Adam David Michael 0.002 0.00% 0.006 0.00% Interium CFO
CFO - Shares - Amount $0.044 $0.105 Last report July 3025
Options - percentage 0.043 0.02% 0.046 0.02%
Options - amount $0.772 $0.819
Alimchandani. Pauline 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Ceased insider Apr 2020
CFO - Shares - Amount $0.000 $0.000 $0.000 $0.000
Options - percentage 0.045 0.02% 0.047 0.02% 0.065 0.03% 0.088 0.03%
Options - amount $2.055 $1.776 $2.429 $2.126
Stephenson, Rachel 0.000 0.00% 0.003 0.00% 0.005 0.00% 66.85%
Officer - Shares - Amount $0.000 $0.052 $0.110
Options - percentage 0.061 0.02% 0.049 0.02% 0.032 0.01% -34.61%
Options - amount $1.087 $0.875 $0.726
Edmonds, Tobias Charles 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Officer - Shares - Amount $0.000 $0.000 $0.002
Options - percentage 0.043 0.02% 0.041 0.02% 0.044 0.02% 7.52%
Options - amount $0.764 $0.736 $1.004
Chislett, Michelle 0.000 0.00% 0.000 0.00% ceased insider Sep 2025
Officer - Shares - Amount $0.000 $0.000
Options - percentage 0.005 0.00% 0.035 0.01%
Options - amount $0.116 $0.625
Fushman, Yonni David 0.002 0.00% 0.002 0.00% Ceased insider July 2025
Officer - Shares - Amount $0.048 $0.036
Options - percentage 0.054 0.02% 0.105 0.04%
Options - amount $1.291 $1.878
Povall, David Edward  0.007 0.00% 0.007 0.00%
Officer - Shares - Amount $0.277 $0.180
Options - percentage 0.031 0.01% 0.034 0.01%
Options - amount $1.168 $0.813
Frot, Pierre-Emmanuel 0.000 0.00% 0.028 0.01% 0.034 0.01% 19.21%
Officer - Shares - Amount $0.000 $0.504 $0.763
Options - percentage 0.067 0.03% 0.056 0.02% 0.048 0.02% -14.62%
Options - amount $1.204 $1.003 $1.086
Bertoldi, Linda Louise 0.01% 0.013 0.01% 0.013 0.01% 0.013 0.01% 0.013 0.01% 0.013 0.01% Ceased insider Oct 2024 #DIV/0!
Director - Shares - Amount $0.282 $0.354 $0.594 $0.493 $0.483 $0.313
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Colnett, Lisa 0.002 0.00% 0.002 0.00% 0.004 0.00% 0.006 0.00% 36.44%
Director - Shares - Amount $0.037 $0.028 $0.073 $0.127
Options - percentage 0.010 0.00% 0.017 0.01% 0.024 0.01% 0.029 0.01% 18.57%
Options - amount $0.233 $0.305 $0.430 $0.647
Halbert, Keith 0.006 0.00% 0.006 0.00% 0.006 0.00% 0.006 0.00% 0.00%
Director - Shares - Amount $0.132 $0.098 $0.098 $0.125
Options - percentage 0.008 0.00% 0.014 0.01% 0.019 0.01% 0.023 0.01% 21.65%
Options - amount $0.191 $0.253 $0.344 $0.532
Pearce, Ian 0.000 0.00% 0.000 0.00% 0.018 0.01% New Chairman 2025 #DIV/0!
Chairman - Shares - Amt $0.000 $0.000 $0.398
Options - percentage 0.019 0.01% 0.029 0.01% 0.036 0.01% 23.22%
Options - amount $0.344 $0.525 $0.821
Brace, John Wycliffe 0.502 0.28% 0.226 0.11% 0.226 0.10% 0.226 0.09% 0.226 0.09% 0.226 0.09%
Chairman - Shares - Amt $13.655 $10.323 $8.578 $8.392 $5.440 $4.046
Options - percentage 0.153 0.09% 0.153 0.08% 0.067 0.03% 0.073 0.03% 0.000 0.00% 0.073 0.03%
Options - amount $4.174 $7.008 $2.551 $2.712 $0.000 $1.307
Temerty, James C. 31.98% 46.396 25.71% 6.139 3.04% Says he has Class C Shares
Chairman - Shares - Amt $1,250.482 $1,261.984 $280.380 But annual statements says
Class A - percentage 100.00% 1.000 100.00% 0.000 0.00% A no Class C Shares
Class A - amount $21.700 $27.200 $0.000 A Also some 25.645598 cl a
Options - percentage 0.00% 0.000 0.00% 0.000 0.00% But only a 1M o/s
Options - amount $0.00 $0.00 $0.000 Last file Sep 2020
Increase in O/S Shares 0.01% 0.023 0.01% 0.000 0.00% 0.000 0.00% 0.022 0.01% 0.015 0.01% 0.040 0.02% 0.000 0.00% 0.000 0.00% LTIP
due to SO $0.520 $0.509 $0.000 $0.000 $0.834 $0.556 $0.970 $0.000 $0.000 0 in 2025
Book Value $0.519 $0.583 $0.400 $4.000 $0.911 $0.591 $0.279 $0.000 $0.000
Insider Buying -$9.984 -$1.503 -$0.145 -$0.154 -$0.017 -$0.531 -$0.059 -$0.195 $0.000
Insider Selling $1.302 $21.176 $8.711 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Net Insider Selling -$8.682 $19.673 $8.566 -$0.154 -$0.017 -$0.531 -$0.059 -$0.195 $0.000
% of Market Cap -0.22% 0.40% 0.09% 0.00% 0.00% -0.01% 0.00% 0.00% 0.00%
Annual Stement
says mge ownership
Directors 7 9 9 9 9 9 10 11
Women 29% 2 29% 3 33% 4 44% 3 33% 3 33% 3 33% 4 40% 4 36%
Minorities 0% 0 0% 0 0% 0 0% 0 0% 0 0% 1 11% 1 10% 2 18%
Institutions/Holdings 24.73% 20 24.93% 20 24.58% 20 27.37% 20 28.22% 20 28.95% 20 29.32%
Total Shares Held 24.22% 56.400 24.86% 60.021 24.01% 69.472 27.25% 72.715 27.97% 75.718 28.95% 76.663 29.32%
Increase/Decrease -10.13% -0.648 -1.14% -4.675 -7.23% 3.153 4.75% -3.958 -5.16% -4.535 -5.65% -0.558 -0.72%
Starting No. of Shares reuters 57.048 Top 20 MS 64.696 Top 20 MS 66.319 Top 20 MS 76.673 Top 20 MS 80.253 Top 20 MS 77.221 Top 20 MS
Institutions/Holdings 47.12%
Value $1,842.65
Total Shares Held
Value
Increase/Decrease 3 Mths
Starting No. of Shares Morningstar
Copyright © 2008 Website of SPBrunner. All rights reserved.