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/
Hammond Power Solutions Inc. TSX: HPS.A OTC: HMDPF http://www.hammondpowersolutions.com/ Fiscal Yr: Dec 31 Q1 2017
Year 12/31/05 12/31/06 12/31/07 12/30/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
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$278.4 <-12 mths 1.32%
Revenue* $98.9 $132.0 $160.6 $226.4 $195.4 $190.6 $221.3 $257.4 $242.9 $247.8 $274.6 $274.8 $278.4 <-12 mths 108.21% <-Total Growth 10 Revenue
Increase 21.57% 33.45% 21.69% 40.94% -13.66% -2.47% 16.12% 16.29% -5.61% 1.98% 10.85% 0.06% 1.32% <-12 mths 7.61% <-IRR #YR-> 10 Revenue 108.21%
5 year Running Average $83.1 $92.2 $109.2 $139.8 $162.7 $181.0 $198.9 $218.2 $221.5 $232.0 $248.8 $259.5 $263.7 <-12 mths 4.42% <-IRR #YR-> 5 Revenue 24.16%
Revenue per Share $8.76 $11.54 $13.96 $19.31 $16.82 $16.46 $19.10 $22.12 $20.82 $21.18 $23.47 $23.49 $24.03 <-12 mths 10.91% <-IRR #YR-> 10 5 yr Running Average 181.57%
Increase 21.62% 31.70% 20.96% 38.34% -12.90% -2.18% 16.10% 15.78% -5.88% 1.76% 10.80% 0.06% 2.33% <-12 mths 5.47% <-IRR #YR-> 5 5 yr Running Average 30.49%
5 year Running Average $7.36 $8.13 $9.59 $12.16 $14.08 $15.62 $17.13 $18.76 $19.06 $19.94 $21.34 $22.22 $22.60 <-12 mths 7.36% <-IRR #YR-> 10 Revenue per Share 103.50%
P/S (Price/Sales) Med 0.21 0.40 0.84 0.58 0.45 0.64 0.53 0.44 0.42 0.35 0.27 0.27 0.26 <-12 mths 4.22% <-IRR #YR-> 5 Revenue per Share 22.94%
P/S (Price/Sales) Close 0.27 0.60 1.15 0.38 0.55 0.62 0.42 0.37 0.34 0.35 0.27 0.26 0.27 <-12 mths 10.57% <-IRR #YR-> 10 5 yr Running Average 173.13%
*Sales in M CDN $ P/S Med 10 yr 0.44 5 yr 0.35 -39.08% Diff M/C 5.34% <-IRR #YR-> 5 5 yr Running Average 29.68%
-$132.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $274.8
-$221.3 $0.0 $0.0 $0.0 $0.0 $274.8
-$92.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $259.5
-$198.9 $0.0 $0.0 $0.0 $0.0 $259.5
-$11.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.49
-$19.10 $0.00 $0.00 $0.00 $0.00 $23.49
-$8.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.22
-$17.13 $0.00 $0.00 $0.00 $0.00 $22.22
$0.18 <-12 mths 12.50%
EPS Basic $0.34 $0.76 $1.08 $1.95 $0.82 $0.84 $0.52 $1.08 $0.52 $0.22 $0.53 $0.16 -78.95% <-Total Growth 10 EPS Basic
EPS Diluted* $0.34 $0.75 $1.06 $1.93 $0.82 $0.83 $0.51 $1.08 $0.52 $0.22 $0.53 $0.16 $0.18 <-12 mths -78.67% <-Total Growth 10 EPS Diluted
Increase 161.54% 120.59% 41.33% 82.08% -57.51% 1.22% -38.55% 111.76% -51.85% -57.69% 140.91% -69.81% 12.50% <-12 mths -14.31% <-IRR #YR-> 10 Earnings per Share -78.67%
Earnings Yield 14.2% 10.8% 6.6% 26.4% 8.9% 8.1% 6.4% 13.2% 7.4% 3.0% 8.3% 2.6% 2.8% <-12 mths -20.69% <-IRR #YR-> 5 Earnings per Share -68.63%
5 year Running Average $0.06 $0.23 $0.44 $0.84 $0.98 $1.08 $1.03 $1.03 $0.75 $0.63 $0.57 $0.50 $0.32 <-12 mths 8.31% <-IRR #YR-> 10 5 yr Running Average 122.12%
10 year Running Average $0.57 $0.63 $0.74 $0.80 $0.81 $0.83 $0.77 $0.68 <-12 mths -13.39% <-IRR #YR-> 5 5 yr Running Average -51.26%
* ESP per share E/P 10 Yrs 7.76% 5Yrs 7.44%
-$0.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16
-$0.51 $0.00 $0.00 $0.00 $0.00 $0.16
-$0.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.50
-$1.03 $0.00 $0.00 $0.00 $0.00 $0.50
Special Dividend $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00% <-Median-> 10 Sp Dividends
Yield H/L Price 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1.15% 0.00% 0.00% 0.00% 0.00% #DIV/0! #DIV/0! 0.00% <-Median-> 10 Yield H/L Price
Dividend* $0.10 $0.13 $0.15 $0.18 $0.20 $0.24 $0.24 $0.24 $0.24 $0.24 $0.24 140.00% <-Total Growth 7 Dividends
Increase 30.00% 15.38% 20.00% 11.11% 20.00% 0.00% 0.00% 0.00% 0.00% 0.00% 15.38% <-Median-> 7 Increase
Dividends 5 Yr Running $0.15 $0.18 $0.20 $0.22 $0.23 #DIV/0! #DIV/0! #DIV/0! <-Total Growth 3 Dividends 5 Yr Running
Yield H/L Price 1.31% 1.23% 1.48% 1.87% 2.29% 3.20% 3.80% 3.73% 3.81% 2.08% <-Median-> 8 Yield H/L Price
Yield on High Price 1.09% 1.08% 1.20% 1.63% 1.83% 2.61% 3.20% 3.25% 3.66% 1.73% <-Median-> 8 Yield on High Price
Yield on Low Price 1.66% 1.43% 1.94% 2.20% 3.05% 4.14% 4.69% 4.36% 3.97% 2.62% <-Median-> 8 Yield on Low Price
Yield on Close Price 1.09% 1.27% 1.88% 2.20% 2.86% 3.27% 3.77% 3.96% 3.69% 3.69% 3.69% 2.53% <-Median-> 8 Yield on Close Price
Payout Ratio EPS 12.20% 15.66% 29.41% 16.67% 57.69% 109.09% 45.28% 150.00% 133.33% #VALUE! #DIV/0! 37.35% <-Median-> 8 DPR EPS
DPR EPS 5 Yr Running 20.52% 28.84% 35.72% 44.28% 72.76% 32.28% <-Median-> 4 DPR EPS 5 Yr Running
Payout Ratio CFPS 4.57% 10.01% 26.36% 9.80% 457.64% 15.21% 17.48% 18.45% 25.34% 16.35% <-Median-> 8 DPR CF
DPR CF 5 Yr Running 12.95% 17.04% 18.84% 18.06% 22.25% 17.55% <-Median-> 4 DPR CF 5 Yr Running
Payout Ratio CFPS WC 8.17% 9.83% 9.78% 8.81% 20.64% 21.89% 14.28% 15.51% 25.34% 12.05% <-Median-> 8 DPR CF WC
DPR CF WC 5 Yr Running 10.18% 12.24% 13.08% 14.21% 17.42% 12.66% <-Median-> 4 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 3.20% 3.27% 5 Yr Med Payout 57.69% 17.48% 15.51% 13.32% <-IRR #YR-> 7 Dividends #DIV/0!
* Dividends per share 5 Yr Med and Cur. 15.31% 12.92% Last Div Inc ---> $0.050 $0.060 20.0% 9.86% <-IRR #YR-> 5 Dividends 60.00%
-$0.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.24
-$0.15 $0.00 $0.00 $0.00 $0.00 $0.24
Historical Dividends Historical High Div 4.43% Low Div 1.08% Ave Div 2.76% Med Div 2.08% Close Div 2.53% Historical Dividends
High/Ave/Median Values Curr diff Exp. -16.65% 241.88% Cheap 34.02% Cheap 77.51% Cheap 45.97% High/Ave/Median
Future Dividend Yield Div Yd 8.45% earning in 5.00 Years at IRR of 18.00% Div Inc. 128.78% Future Dividend Yield
Future Dividend Yield Div Yd 19.32% earning in 10.00 Years at IRR of 18.00% Div Inc. 423.38% Future Dividend Yield
Future Dividend Yield Div Yd 44.21% earning in 15.00 Years at IRR of 18.00% Div Inc. 1097.37% Future Dividend Yield
I am earning GC Div Gr 33.33% 1/3/13 # yrs -> 3 2013 $8.20 Cap Gain -20.73% I am earning GC
I am earning Div org yield 2.20% 12/31/14 TFSA Div G Yrly 15.54% Div start $0.18 -2.20% 2.93% I am earning Div
Yield if held 5 yrs 12.50% 7.22% 3.22% 1.54% 1.80% 3.15% 2.27% 2.37% 2.49% 2.75% 3.20% 2.76% <-Median-> 8 Paid Median Price
Yield if held 10 yrs 15.00% 24.00% 36.36% 30.00% 13.33% 5.14% 2.06% 2.16% 3.15% 19.50% <-Median-> 6 Paid Median Price
Yield if held 15 yrs 24.00% 32.00% 43.64% 30.00% 24.00% <-Median-> 1 Paid Median Price
Yield if held 20 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 12.50% 12.78% 8.15% 4.80% 7.74% 13.13% 10.48% 11.86% 13.09% 13.75% 16.01% 11.17% <-Median-> 8 Paid Median Price
Cost covered if held 10 years 38.00% 74.67% 156.36% 137.50% 74.44% 33.87% 15.59% 18.53% 28.89% 74.56% <-Median-> 6 Paid Median Price
Cost covered if held 15 years 158.00% 242.67% 374.55% 287.50% 158.00% <-Median-> 1 Paid Median Price
Cost covered if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham No. $3.95 $6.85 $9.60 $16.08 $11.09 $11.88 $9.52 $14.41 $10.36 $6.89 $11.50 $6.09 $6.54 #VALUE! $0.00 -11.11% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.46 0.68 1.22 0.69 0.69 0.89 1.06 0.67 0.84 1.09 0.55 1.06 0.96 0.87 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 0.68 1.01 1.71 1.01 0.83 1.02 1.31 0.77 1.05 1.33 0.65 1.21 1.00 1.04 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.23 0.35 0.72 0.37 0.54 0.77 0.81 0.57 0.63 0.84 0.45 0.90 0.92 0.68 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 0.61 1.01 1.67 0.45 0.83 0.86 0.84 0.57 0.67 1.06 0.55 1.00 0.99 #VALUE! #DIV/0! 0.83 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -39.25% 1.19% 67.04% -54.60% -17.07% -13.55% -15.94% -43.15% -32.52% 6.48% -44.59% -0.45% -0.68% #VALUE! #DIV/0! -16.51% <-Median-> 10 Graham Price
Price Close $2.40 $6.93 $16.04 $7.30 $9.20 $10.27 $8.00 $8.19 $6.99 $7.34 $6.37 $6.06 $6.50 $6.50 $6.50 -12.55% <-Total Growth 10 Stock Price
Increase 118.18% 188.75% 131.46% -54.49% 26.03% 11.63% -22.10% 2.37% -14.65% 5.01% -13.22% -4.87% 7.26% 0.00% 0.00% -1.33% <-IRR #YR-> 10 Stock Price -12.55%
P/E 7.06 9.24 15.13 3.78 11.22 12.37 15.69 7.58 13.44 33.36 12.02 37.88 36.11 #VALUE! #DIV/0! -5.40% <-IRR #YR-> 5 Stock Price -24.25%
Trailing P/E 18.46 20.38 21.39 6.89 4.77 12.52 9.64 16.06 6.47 14.12 28.95 11.43 40.63 36.11 #VALUE! 1.04% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 2.38% 3.35% % Tot Ret 227.62% 0.00% Price Inc -4.87% P/E: 12.91 13.44 -2.05% <-IRR #YR-> 5 Price & Dividend
-$6.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.06
-$8.00 $0.00 $0.00 $0.00 $0.00 $6.06
-$6.93 $0.00 $0.00 $0.10 $0.13 $0.15 $0.18 $0.30 $0.24 $0.24 $6.30
-$8.00 $0.18 $0.30 $0.24 $0.24 $6.30
Price H/L Median $1.80 $4.67 $11.68 $11.12 $7.62 $10.60 $10.12 $9.63 $8.73 $7.50 $6.31 $6.44 $6.30 38.05% <-Total Growth 10 Stock Price
Increase 125.00% 159.17% 150.27% -4.80% -31.49% 39.13% -4.48% -4.89% -9.30% -14.15% -15.81% 2.06% -2.17% 3.28% <-IRR #YR-> 10 Stock Price 38.05%
P/E 5.29 6.22 11.01 5.76 9.29 12.77 19.84 8.91 16.79 34.07 11.91 40.25 35.00 -8.64% <-IRR #YR-> 5 Stock Price -36.36%
Trailing P/E 13.85 13.72 15.57 10.49 3.95 12.92 12.19 18.87 8.08 14.41 28.68 12.15 39.38 5.99% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 7.77 9.83 9.83 9.31 11.61 11.86 11.03 12.83 19.57 -5.79% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 9.30 7.65 8.41 9.29 9.10 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 2.71% 2.86% % Tot Ret 45.29% 0.00% Price Inc -9.30% P/E: 12.34 16.79 Count 16 Years of data
-$4.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.44
-$10.12 $0.00 $0.00 $0.00 $0.00 $6.44
-$4.67 $0.00 $0.00 $0.10 $0.23 $0.15 $0.18 $0.20 $0.24 $0.24 $6.68
-$10.12 $0.18 $0.30 $0.24 $0.24 $6.68
High Months Aug Dec Dec Jan Nov Apr Apr May Mar Jun Aug Aug Masy
Price High $2.70 $6.93 $16.45 $16.24 $9.20 $12.09 $12.49 $11.06 $10.90 $9.19 $7.50 $7.38 $6.55 6.49% <-Total Growth 10 Stock Price
Increase 125.00% 156.67% 137.37% -1.28% -43.35% 31.41% 3.31% -11.45% -1.45% -15.69% -18.39% -1.60% -11.25% 0.63% <-IRR #YR-> 10 Stock Price 6.49%
P/E 7.94 9.24 15.52 8.41 11.22 14.57 24.49 10.24 20.96 41.77 14.15 46.13 36.39 -9.99% <-IRR #YR-> 5 Stock Price -40.91%
Trailing P/E 20.77 20.38 21.93 15.32 4.77 14.74 15.05 21.69 10.09 17.67 34.09 13.92 40.94 10.73 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -11.45% P/E: 15.04 20.96 23.08 P/E Ratio Historical High
-$6.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.38
-$12.49 $0.00 $0.00 $0.00 $0.00 $7.38
Low Months Jan Jan Jan Dec Feb Jan Dec Dec Dec Dec Dec Nov Feb
Price Low $0.90 $2.40 $6.90 $5.99 $6.03 $9.10 $7.75 $8.19 $6.56 $5.80 $5.12 $5.50 $6.05 129.17% <-Total Growth 10 Stock Price
Increase 125.00% 166.67% 187.50% -13.19% 0.67% 50.91% -14.84% 5.68% -19.90% -11.59% -11.72% 7.42% 10.00% 8.65% <-IRR #YR-> 10 Stock Price 129.17%
P/E 2.65 3.20 6.51 3.10 7.35 10.96 15.20 7.58 12.62 26.36 9.66 34.38 33.61 -6.63% <-IRR #YR-> 5 Stock Price -29.03%
Trailing P/E 6.92 7.06 9.20 5.65 3.12 11.10 9.34 16.06 6.07 11.15 23.27 10.38 37.81 6.93 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -11.59% P/E: 10.31 12.62 -1.79 P/E Ratio Historical Low
-$2.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.50
Long-term debt+current port. $4.11 $4.03 $0.00 $0.00 Debt
Change -2.07% -100.00% #DIV/0! -51.03% <-Median-> 2 Change
% of Market Cap 0.05 0.05 0.00 0.00 0.05 <-Median-> 3 Debt/Market Cap Ratio
Intangibles & Goodwill $0.00 $0.00 $7.12 $7.31 $7.09 $12.11 $25.99 $32.85 $32.12 $33.46 $29.50 $29.68 Intangibles Goodwill
Change 2.61% -3.01% 70.85% 114.74% 26.37% -2.23% 4.20% -11.84% 0.62% 3.41% <-Median-> 8 Change
% of Market Cap 0.00 0.00 0.08 0.07 0.06 0.13 0.27 0.40 0.37 0.45 0.42 0.39 0.20 <-Median-> 10 Intangible/Market Cap Ratio
Market Cap $27 $79 $185 $86 $107 $119 $93 $95 $82 $86 $75 $71 $75 $75 $75 -10.53% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 11.795 11.716 11.666 11.689 11.694 11.719 11.702 11.706 -0.09% <-Total Growth 7 Diluted
Change -0.67% -0.42% 0.20% 0.04% 0.21% -0.14% 0.03% 0.03% <-Median-> 7 Change
Basic # of Shares in Millions 11.400 11.440 11.480 11.710 11.703 11.598 11.584 11.628 11.644 11.739 11.697 11.697 2.25% <-Total Growth 10 Basic
Change 1.06% 0.35% 0.35% 2.00% -0.06% -0.90% -0.12% 0.38% 0.14% 0.81% -0.35% 0.00% 0.07% <-Median-> 10 Change
Difference -1.0% 0.0% 0.2% 0.1% -0.7% -0.1% 0.0% 0.1% 0.2% -0.4% 0.0% 0.0% 0.02% <-Median-> 10 Difference
$11 <-12 mths -27.88%
Class A 8.507 8.657 8.726 8.942 8.840 8.805 8.807 8.858 8.892 8.917 8.922 8.922 8.807 8.807 8.807 3.06% <-Total Growth 10 Class A 3.06%
Class B 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 2.778 0.00% <-Total Growth 10 Class B 1.31%
# of Share in Millions 11.285 11.435 11.504 11.720 11.618 11.583 11.585 11.636 11.670 11.695 11.700 11.700 11.585 11.585 11.585 0.23% <-IRR #YR-> 10 Shares 2.31%
Change -0.04% 1.33% 0.60% 1.88% -0.87% -0.30% 0.02% 0.44% 0.29% 0.21% 0.04% 0.00% -0.98% 0.00% 0.00% 0.20% <-IRR #YR-> 5 Shares 0.99%
Cash Flow from Operations $M $4.3 $7.7 $7.6 $6.3 $25.4 $15.0 $6.6 $21.4 $0.8 $18.5 $16.1 $15.2 $10.97 <-12 mths 98.62% <-Total Growth 10 Cash Flow
Increase -15.08% 79.00% -0.65% -17.83% 306.20% -40.77% -56.19% 224.20% -96.42% 2311.76% -12.93% -5.28% -27.88% <-12 mths SO Buy Backs
5 year Running Average $3.6 $4.9 $5.6 $6.2 $10.2 $12.4 $12.2 $14.9 $13.8 $12.4 $12.6 $14.4 $12.3 <-12 mths 196.22% <-Total Growth 10 CF 5 Yr Running
CFPS $0.38 $0.67 $0.66 $0.53 $2.19 $1.30 $0.57 $1.84 $0.07 $1.58 $1.37 $1.30 $0.95 <-12 mths 94.12% <-Total Growth 10 Cash Flow per Share
Increase -15.04% 76.65% -1.25% -19.34% 309.78% -40.59% -56.20% 222.78% -96.43% 2306.61% -12.96% -5.28% -27.16% <-12 mths 7.10% <-IRR #YR-> 10 Cash Flow 98.62%
5 year Running Average $0.32 $0.43 $0.49 $0.54 $0.89 $1.07 $1.05 $1.28 $1.19 $1.07 $1.08 $1.23 $1.05 <-12 mths 18.21% <-IRR #YR-> 5 Cash Flow 130.83%
P/CF on Med Price 4.75 6.96 17.65 20.83 3.48 8.16 17.79 5.24 133.17 4.75 4.60 4.95 6.65 <-12 mths 6.86% <-IRR #YR-> 10 Cash Flow per Share 94.12%
P/CF on Closing Price 6.33 10.34 24.25 13.68 4.21 7.91 14.06 4.46 106.63 4.65 4.64 4.66 6.86 <-12 mths 17.98% <-IRR #YR-> 5 Cash Flow per Share 128.56%
2.45% Diff M/C 11.14% <-IRR #YR-> 10 CFPS 5 yr Running 187.48%
Excl.Working Capital CF $2.3 $2.6 $5.6 $17.1 -$11.2 $0.26 $11.18 $2.40 $16.20 -$5.63 $3.61 $2.89 $0.00 <-12 mths 3.23% <-IRR #YR-> 5 CFPS 5 yr Running 17.21%
Cash Flow from Operations $M WC $6.6 $10.3 $13.2 $23.4 $14.2 $15.3 $17.8 $23.8 $17.0 $12.8 $19.7 $18.1 $11.0 <-12 mths 76.34% <-Total Growth 10 Cash Flow less WC
Increase 50.43% 56.16% 28.92% 76.51% -39.11% 7.65% 16.04% 33.80% -28.64% -24.42% 53.41% -7.97% -39.38% <-12 mths 5.84% <-IRR #YR-> 10 Cash Flow less WC 76.34%
5 year Running Average $3.0 $4.9 $7.2 $11.6 $13.5 $15.3 $16.8 $18.9 $17.6 $17.3 $18.2 $18.3 $15.7 <-12 mths 0.37% <-IRR #YR-> 5 Cash Flow less WC 1.89%
CFPS Excl. WC $0.58 $0.90 $1.15 $1.99 $1.22 $1.32 $1.53 $2.04 $1.45 $1.10 $1.68 $1.55 $0.95 <-12 mths 14.16% <-IRR #YR-> 10 CF less WC 5 Yr Run 276.01%
Increase 50.50% 54.11% 28.15% 73.26% -38.58% 7.98% 16.02% 33.22% -28.85% -24.58% 53.34% -7.97% -38.78% <-12 mths 1.71% <-IRR #YR-> 5 CF less WC 5 Yr Run 8.86%
5 year Running Average $0.26 $0.43 $0.63 $1.00 $1.17 $1.32 $1.44 $1.62 $1.52 $1.49 $1.56 $1.56 $1.35 <-12 mths 5.59% <-IRR #YR-> 10 CF - Less WC 72.35%
P/CF on Med Price 3.09 5.20 10.15 5.58 6.22 8.01 6.60 4.71 6.01 6.84 3.75 4.16 6.65 <-12 mths 0.18% <-IRR #YR-> 5 CF - Less WC 0.88%
P/CF on Closing Price 4.12 7.72 13.94 3.66 7.51 7.77 5.22 4.01 4.81 6.69 3.79 3.92 6.86 <-12 mths 13.84% <-IRR #YR-> 10 5 yr Running 265.47%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 6.70 5 yr 4.95 P/CF Med 10 yr 6.11 5 yr 4.71 12.26% Diff M/C 1.60% <-IRR #YR-> 5 5 yr Running 8.28%
-$0.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.30 Cash Flow per Share
-$0.57 $0.00 $0.00 $0.00 $0.00 $1.30 Cash Flow per Share
-$0.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.23 CFPS 5 yr Running
-$1.05 $0.00 $0.00 $0.00 $0.00 $1.23 CFPS 5 yr Running
-$10.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $18.1 Cash Flow less WC
-$17.8 $0.0 $0.0 $0.0 $0.0 $18.1 Cash Flow less WC
-$4.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $18.3 CF less WC 5 Yr Run
-$16.8 $0.0 $0.0 $0.0 $0.0 $18.3 CF less WC 5 Yr Run
-$0.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.55 CFPS - Less WC
-$1.53 $0.00 $0.00 $0.00 $0.00 $1.55 CFPS - Less WC
-$0.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.56 CFPS 5 yr Running
-$1.44 $0.00 $0.00 $0.00 $0.00 $1.56 CFPS 5 yr Running
OPM 4.33% 5.80% 4.74% 2.76% 13.00% 7.89% 2.98% 8.30% 0.31% 7.45% 5.85% 5.54% -4.61% <-Total Growth 10 OPM
Increase -30.15% 34.13% -18.36% -41.70% 370.47% -39.26% -62.27% 178.78% -96.21% 2264.89% -21.45% -5.34% Should increase or be stable.
Diff from Median -24.0% 2.0% -16.8% -51.5% 128.3% 38.7% -47.7% 45.8% -94.5% 30.8% 2.7% -2.7% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 5.69% 5 Yrs 5.85% should be zero, it is a check on calculations
Current Assets $30.69 $42.02 $53.31 $79.71 $71.43 $81.96 $86.24 $92.52 $105.36 $103.83 $128.34 $119.30 $117.44 Liquidity ratio of 1.5 and up, best
Current Liabilities $18.27 $22.31 $24.41 $39.94 $28.12 $29.86 $40.73 $52.98 $67.61 $60.33 $85.21 $80.39 $77.09 1.87 <-Median-> 10 Ratio
Liquidity Ratio 1.68 1.88 2.18 2.00 2.54 2.74 2.12 1.75 1.56 1.72 1.51 1.48 1.52 1.56 <-Median-> 5 Ratio
Liq. with CF aft div 1.91 2.23 2.50 2.15 3.40 3.20 2.24 2.11 1.52 1.98 1.66 1.64 1.63 1.66 <-Median-> 5 Ratio
Liq. CF re Inv+Div 1.91 2.01 2.21 1.55 2.61 2.78 1.72 1.52 1.25 1.63 1.51 1.45 1.63 1.51 <-Median-> 5 Ratio
Assets $45.26 $57.69 $70.26 $110.89 $106.93 $117.39 $137.52 $160.05 $186.88 $184.29 $222.97 $205.18 $204.37 Debt Ratio of 1.5 and up, best
Liabilities $22.24 $25.91 $25.78 $41.11 $29.42 $29.86 $46.07 $58.40 $77.83 $69.85 $90.67 $84.52 $81.64 2.71 <-Median-> 10 Ratio
Debt Ratio 2.04 2.23 2.73 2.70 3.63 3.93 2.98 2.74 2.40 2.64 2.46 2.43 2.50 2.46 <-Median-> 5 Ratio
Total Equity $23.02 $31.78 $44.48 $69.78 $77.50 $87.53 $91.45 $101.65 $109.05 $114.44 $132.30 $120.65 $122.73
NCI $2.26 $2.04 $2.17 $2.64 $0.21 $0.21
Book Value $23.02 $31.78 $44.48 $69.78 $77.50 $87.53 $91.45 $99.39 $107.01 $112.27 $129.67 $120.44 $122.52 $122.52 $122.52 278.97% <-Total Growth 10 Book Value
BV per share $2.04 $2.78 $3.87 $5.95 $6.67 $7.56 $7.89 $8.54 $9.17 $9.60 $11.08 $10.29 $10.58 $10.58 $10.58 270.40% <-Total Growth 10 Book Value per Share
Change 22.18% 36.24% 39.12% 54.00% 12.04% 13.28% 4.46% 8.21% 7.36% 4.69% 15.44% -7.11% 2.74% 0.00% 0.00% -32.99% P/B Ratio Current/Historical Median
P/B Ratio (Median) 0.88 1.68 3.02 1.87 1.14 1.40 1.28 1.13 0.95 0.78 0.57 0.63 0.60 0.92 P/B Ratio Historical Median
P/B Ratio (Close) 1.18 2.49 4.15 1.23 1.38 1.36 1.01 0.96 0.76 0.76 0.57 0.59 0.61 0.61 0.61 13.99% <-IRR #YR-> 10 Book Value 270.40%
Change 78.57% 111.95% 66.37% -70.45% 12.49% -1.46% -25.43% -5.39% -20.50% 0.30% -24.82% 2.42% 4.40% 0.00% 0.00% 5.45% <-IRR #YR-> 5 Book Value 30.41%
Leverage (A/BK) 1.97 1.82 1.58 1.59 1.38 1.34 1.50 1.57 1.71 1.61 1.69 1.70 1.67 1.58 <-Median-> 10 A/BV
Debt/Equity Ratio 0.97 0.82 0.58 0.59 0.38 0.34 0.50 0.57 0.71 0.61 0.69 0.70 0.67 0.58 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.13 5 yr Med 0.78 -45.81% Diff M/C
-$2.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.29
-$7.89 $0.00 $0.00 $0.00 $0.00 $10.29
$2.19 <-12 mths -139.46%
Comprehensive Income $12.40 $22.83 $9.63 $9.71 $6.33 $9.60 $9.17 $7.79 $20.53 -$5.69 -145.84% <-Total Growth 9 Comprehensive Income
NCI $0.00 $0.00 $0.00 $0.00 $0.00 -$0.15 -$0.22 $0.13 $0.47 -$0.13
Shareholders $12.40 $22.83 $9.63 $9.71 $6.33 $9.75 $9.39 $7.66 $20.06 -$5.55 -144.76% <-Total Growth 9 Comprehensive Income
Increase 84.06% -57.81% 0.82% -34.84% 54.07% -3.64% -18.43% 161.85% -127.67% -3.64% <-Median-> 5 Comprehensive Income
5 Yr Running Average $12.18 $11.65 $8.96 $8.57 $10.64 $8.26 #NUM! <-IRR #YR-> 9 Comprehensive Income #DIV/0!
ROE 27.9% 32.7% 12.4% 11.1% 6.9% 9.6% 8.6% 6.7% 15.2% -4.6% #NUM! <-IRR #YR-> 5 Comprehensive Income -187.75%
5Yr Median 12.4% 11.1% 9.6% 8.6% 8.6% 8.6% -7.47% <-IRR #YR-> 5 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% 0.0% 0.0% 0.0% 5.6% -22.8% 54.4% 202.0% 225.3% -404.6% -7.47% <-IRR #YR-> 5 5 Yr Running Average -32.16%
Median Values Diff 5, 10 yr 0.0% 54.4% 8.6% <-Median-> 5 Return on Equity
-$12.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$5.6
-$6.3 $0.0 $0.0 $0.0 $0.0 -$5.6
-$12.2 $0.0 $0.0 $0.0 $0.0 $8.3
-$12.2 $0.0 $0.0 $0.0 $0.0 $8.3
Current Liability Coverage Ratio 0.36 0.46 0.54 0.58 0.51 0.51 0.44 0.45 0.25 0.21 0.23 0.23 CFO / Current Liabilities
5 year Median 0.08 0.28 0.36 0.46 0.51 0.51 0.51 0.51 0.45 0.44 0.25 0.23 0.44 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 14.52% 17.80% 18.84% 21.07% 13.30% 13.04% 12.92% 14.85% 9.08% 6.96% 8.82% 8.82% CFO / Total Assets
5 year Median 3.97% 10.72% 14.52% 17.80% 17.80% 17.80% 13.30% 13.30% 13.04% 12.92% 9.08% 8.82% 13.0% <-Median-> 10 Return on Assets
Return on Assets ROA 8.5% 15.0% 17.7% 20.6% 9.0% 8.3% 4.4% 7.9% 3.3% 1.4% 2.8% 0.9% Net Income/Assets Return on Assets
5Yr Median -0.4% 3.6% 8.5% 15.0% 15.0% 15.0% 9.0% 8.3% 7.9% 4.4% 3.3% 2.8% 6.1% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 16.8% 27.3% 27.9% 32.7% 12.4% 11.1% 6.6% 12.4% 5.6% 2.2% 4.7% 1.5% Net Inc/ Shareholders' equity Return on Equity
5Yr Median -0.9% 7.7% 16.8% 27.3% 27.3% 27.3% 12.4% 12.4% 11.1% 6.6% 5.6% 4.7% 8.8% <-Median-> 10 Return on Equity
$2.01 <-12 mths 9.98%
Net Income $5.99 $12.61 $6.10 $2.52 $6.32 $1.79
NCI $0.00 -$0.01 $0.02 -$0.02 $0.15 -$0.03
Shareholders $3.86 $8.67 $12.40 $22.83 $9.63 $9.71 $5.99 $12.62 $6.08 $2.54 $6.17 $1.82 -78.98% <-Total Growth 10 Net Income
Increase 166.00% 124.89% 42.99% 84.06% -57.81% 0.82% -38.28% 110.60% -51.80% -58.29% 143.08% -70.44% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $0.69 $2.59 $5.10 $9.84 $11.48 $12.65 $12.11 $12.16 $8.81 $7.39 $6.68 $5.85 -14.44% <-IRR #YR-> 10 Net Income -78.98%
Operating Cash Flow $4.28 $7.66 $7.61 $6.25 $25.40 $15.05 $6.59 $21.37 $0.77 $18.45 $16.07 $15.22 -21.18% <-IRR #YR-> 5 Net Income -69.58%
Investment Cash Flow $0.55 -$2.39 -$3.11 -$15.70 -$8.55 -$4.48 -$12.15 -$20.35 -$14.55 -$13.03 -$8.76 -$10.14 8.50% <-IRR #YR-> 10 5 Yr Running Ave. 126.05%
Total Accruals -$0.97 $3.40 $7.90 $32.27 -$7.22 -$0.86 $11.55 $11.60 $19.87 -$2.89 -$1.13 -$3.25 -13.56% <-IRR #YR-> 5 5 Yr Running Ave. -51.74%
Total Assets $45.26 $57.69 $70.26 $110.89 $106.93 $117.39 $137.52 $160.05 $186.88 $184.29 $222.97 $205.18 Balance Sheet Assets
Accruals Ratio -2.15% 5.90% 11.24% 29.10% -6.76% -0.74% 8.40% 7.25% 10.63% -1.57% -0.51% -1.58% -0.51% <-Median-> 5 Ratio
EPS/CF Ratio 0.58 0.84 0.92 0.97 0.67 0.63 0.33 0.53 0.36 0.20 0.32 0.10 0.44 <-Median-> 10 EPS/CF Ratio
-$8.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.82
-$5.99 $0.00 $0.00 $0.00 $0.00 $1.82
-$2.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.85
-$12.11 $0.00 $0.00 $0.00 $0.00 $5.85
Chge in Close 118.18% 188.75% 131.46% -54.49% 26.03% 11.63% -22.10% 2.37% -14.65% 5.01% -13.22% -4.87% 7.26% 0.00% 0.00% Count 17 Years of data
up/down/neutral up down down down up down down down Count 10 58.82%
Any Predictions? yes yes yes % right Count 5 50.00%
Financial Cash Flow -$4.70 -$1.18 -$0.46 $3.42 -$5.39 -$4.22 -$5.92 $4.94 $10.75 -$10.47 $7.91 -$0.46 C F Statement Financial Cash Flow
Total Accruals $3.72 $4.58 $8.36 $28.85 -$1.83 $3.35 $17.48 $6.66 $9.12 $7.58 -$9.05 -$2.79 Accruals
Accruals Ratio 8.22% 7.94% 11.90% 26.02% -1.72% 2.86% 12.71% 4.16% 4.88% 4.11% -4.06% -1.36% 4.11% <-Median-> 5 Ratio
Cash $0.25 $4.35 $8.39 $2.37 $13.84 $19.54 $7.81 $13.72 $11.22 $6.46 $19.99 $25.19 $11.76 Cash
Cash Per Share $0.02 $0.38 $0.73 $0.20 $1.19 $1.69 $0.67 $1.18 $0.96 $0.55 $1.71 $2.15 $1.01 $1.18 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.93% 5.49% 4.55% 2.77% 12.95% 16.42% 8.43% 14.40% 13.76% 7.52% 26.82% 35.53% 15.61% 14.40% <-Median-> 5 % of Stock Price
Notes:
May 13, 2017. There were no estimates from last year.
May 28, 2016. Last estimates were for 2015 and 2016 of $257M and $267M for Revenue and $0.47 and $0.67 for EPS
June 12, 2015. Last estimates were for 2014 and 2015 of $248.8M and $258.8M for Revenue, $0.56 and $0.81 for EPS.
May 28, 2014. Last estimates were for 2013 and 2014 of $250M and $260M for Revenue, $0.66 and $0.91 for EPS.
May 31, 2013. Last time I looked at this stock I got 2012 and 2013 estimates of $265.6M and $278.9M for Revenue, $0.98 and $1.14 for EPS.
Hammond becomes a public company in 2001. They worked hard from 2002 to 2006 to reduce their bank debt.
Shares
Class A subordinate voting shares.
Class B common shares with four votes per share, convertible into Class A subordinate voting shares on a one-for-one basis.
Annual dividends on the Class B common shares may not exceed the annual dividends on the Class A subordinate voting shares.
Sector:
Manufacturing, Industrial
What should this stock accomplish?
Would I buy this company and Why.
Dividends
Dividends are paid quarterly in Cycle 3, which is March, June, September and December. Dividends are paid near the end of the month.
For example dividends declared on March 7, 2014 for shareholders of record of March 20, 2014 is payable on March 27, 2014.
Dividends were started in 2009 with one dividend per year. In 2012 they paid two dividends per year and 2013 they started to pay 4 dividends per year.
Why I bought this stock.
I bought this stock as my main purchase for the TFSA in 2013 and 2014. I picked Hammond initially in 2013 as my main buy because it has good growth and reasonable dividend.
Also, I think that it important to try out newer smaller companies for investment purposes. Companies on the TSX are always changing and it is good to get into new industries and new companies.
The problem of this, of course, is you do not always know what industries and companies will be long lasting.
How they make their money.
Hammond Power Solutions Inc. is the largest manufacturer of dry-type transformers in North America. They engineer and manufacture a wide range of
custom transformers that are exported globally in electrical equipment and systems. They support solid industries such as oil and gas, mining, steel,
waste and water treatment, and wind power-generation.
Hammond: a good long-term buy according to Ryan Irvine of Keystone in December of 2012.
This is from Keystone's Small-Cap Stock Report
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield (dividends and erarnings) 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 %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
On May 30 2014 May 31 2013 May 30 2014 Jun 12 2015 May 28 2016 May 13 2017
Hammond, William G. (Bill) 1.026 8.80% 1.034 8.84% 1.051 8.98% 1.053 9.00% 1.055 9.11%
CEO & Chairman $7.175 $7.590 $6.694 $6.381 $6.859
Options - percentage 0.130 1.11% 0.160 1.36% 0.175 1.49% 0.205 1.75% 0.205 1.77%
Options - amount $0.905 $1.171 $1.112 $1.239 $1.335
Huether, Christopher R. 0.205 1.76% 0.005 0.05% 0.007 0.06% 0.008 0.07% 0.010 0.09%
CFO - Shares - Amount $1.433 $0.039 $0.042 $0.049 $0.067
Options - percentage 0.122 1.05% 0.152 1.30% 0.167 1.43% 0.192 1.64% 0.193 1.66%
Options - amount $0.853 $1.116 $1.064 $1.164 $1.253
Davis, Jay Alexander 0.000 0.00% 0.000 0.00%
Officer - Shares - Amount $0.000 $0.000
Options - percentage 0.040 0.34% 0.040 0.35%
Options - amount $0.242 $0.260
Baldwin, Douglas V. 0.037 0.32% 0.037 0.32% 0.037 0.32% 0.037 0.32% 0.037 0.32%
Director - Shares - Amount $0.261 $0.274 $0.238 $0.226 $0.242
Options - percentage 0.035 0.30% 0.050 0.43% 0.055 0.47% 0.065 0.56% 0.066 0.57%
Options - amount $0.245 $0.367 $0.350 $0.394 $0.428
Class A and Class B 23.81% 23.81% Class A and Class B
Arathorn Investments Inc. 2.778 100.00% 2.778 100.00% Class B
owned by William G. Hammond $22.754 $22.754
Increase in O/S Shares 0.101 0.87% 0.034 0.29% 0.025 0.21% 0.005 0.04% 0.000 0.00% 0 for 2016
due to SO $0.827 $0.238 $0.184 $0.032 $0.000
Book Value $0.263 $0.204 $0.189 $0.043 $0.000
Insider Buying -$0.149 -$0.018 -$0.031
Insider Selling $0.088 $0.031 $0.025
Net Insider Selling -$0.099 -$0.061 $0.013 -$0.007
% of Market Cap -0.11% -0.08% 0.02% -0.01%
Directors 6 7 8 8 8
Women 1 17% 1 14% 1 13% 1 13% 1 13%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 4 40.05% 7 25.56% 5 20.67% 7 39.67% 8 42.81% Class A
Total Shares Held 3.548 39.90% 2.273 25.49% 1.843 20.66% 3.569 40.01% 3.820 42.81% Class A
Increase/Decrease 0.000 0.00% 0.342 17.68% 0.058 3.26% -0.006 -0.17% -0.006 -0.15%
Starting No. of Shares 3.548 1.931 1.785 3.575 3.826
Copyright 2008 Website of SPBrunner. All rights reserved.
My stock