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/ Q3 2016
Stella-Jones Inc. TSX: SJ OTC: STLJF www.stella-jones.com Fiscal Yr: Dec 31 9/30/16
Year 12/31/04 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 Value Description #Y Item
Accounting Rules C GAAP C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
Split Date 28-Oct-13
Split 4
$1,854.1 <-12 mths 18.90%
Revenue* $129.0 $157.1 $223.9 $269.7 $384.8 $411.1 $561.0 $640.1 $717.5 $970.1 $1,249.5 $1,559.3 $1,893 $1,982 $2,040 892.39% <-Total Growth 10 Revenue
Increase 33.59% 21.83% 42.46% 20.49% 42.68% 6.83% 36.47% 14.10% 12.08% 35.21% 28.79% 24.80% 21.40% 4.70% 2.93% 25.80% <-IRR #YR-> 10 Revenue
5 year Running Average $99.4 $113.4 $140.6 $175.2 $232.9 $289.3 $370.1 $453.4 $542.9 $660.0 $827.7 $1,027.3 $1,277.9 $1,530.8 $1,744.8 22.68% <-IRR #YR-> 5 Revenue
Revenue per Share $3.15 $3.61 $4.55 $5.46 $7.66 $8.10 $8.81 $10.03 $10.45 $14.12 $18.12 $22.54 $27.33 $28.61 $29.45 24.65% <-IRR #YR-> 10 5 yr Running Average
Increase 30.69% 14.60% 26.05% 20.07% 40.13% 5.83% 8.71% 13.87% 4.16% 35.16% 28.32% 24.40% 21.22% 4.70% 2.93% 22.65% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $2.62 $2.85 $3.28 $3.84 $4.89 $5.88 $6.92 $8.01 $9.01 $10.30 $12.31 $15.05 $18.51 $22.15 $25.21 20.10% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 0.41 0.69 1.02 1.82 0.88 0.60 0.83 0.92 1.45 1.67 1.69 1.90 20.68% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 0.48 0.97 1.89 1.88 0.54 0.79 0.94 1.01 1.83 1.93 1.81 2.33 1.56 1.49 1.45 18.09% <-IRR #YR-> 10 5 yr Running Average
*Sales in M CDN $ P/S Med 10 yr 1.24 5 yr 1.67 25.88% Diff M/C 16.83% <-IRR #YR-> 5 5 yr Running Average
-$157.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,559.3
-$561.0 $0.0 $0.0 $0.0 $0.0 $1,559.3
-$113.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,027.3
-$370.1 $0.0 $0.0 $0.0 $0.0 $1,027.3
-$3.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.54
-$8.81 $0.00 $0.00 $0.00 $0.00 $22.54
-$2.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.05
-$6.92 $0.00 $0.00 $0.00 $0.00 $15.05
$2.43 <-12 mths 19.12%
EPS Basic $0.18 $0.28 $0.45 $0.52 $0.57 $0.60 $0.57 $0.87 $1.14 $1.35 $1.51 $2.05 632.14% <-Total Growth 10 EPS Basic
EPS Diluted* $0.18 $0.27 $0.44 $0.51 $0.56 $0.59 $0.57 $0.87 $1.13 $1.34 $1.50 $2.04 $2.42 $2.57 $2.77 655.56% <-Total Growth 10 EPS Diluted
Increase 79.49% 54.29% 62.96% 15.34% 10.84% 5.33% -4.64% 53.98% 30.17% 18.32% 11.94% 36.00% 18.63% 6.20% 7.78% 22.41% <-IRR #YR-> 10 Earnings per Share
Earnings Yield 11.5% 7.7% 5.1% 5.0% 13.7% 9.2% 6.8% 8.6% 5.9% 4.9% 4.6% 3.9% 5.7% 6.0% 6.5% 29.28% <-IRR #YR-> 5 Earnings per Share
5 year Running Average $0.09 $0.13 $0.22 $0.30 $0.39 $0.47 $0.53 $0.62 $0.74 $0.90 $1.08 $1.38 $1.69 $1.97 $2.26 26.47% <-IRR #YR-> 10 5 yr Running Average
10 year Running Average $0.08 $0.10 $0.14 $0.19 $0.23 $0.28 $0.33 $0.42 $0.52 $0.65 $0.78 $0.96 $1.15 $1.36 $1.58 20.87% <-IRR #YR-> 5 5 yr Running Average
* Diluted ESP per share E/P 10 Yrs 5.51% 5Yrs 4.92%
-$0.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.04
-$0.57 $0.00 $0.00 $0.00 $0.00 $2.04
-$0.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.38
-$0.53 $0.00 $0.00 $0.00 $0.00 $1.38
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
Pre-2013 split $0.08 $0.10 $0.14 $0.24 $0.34 $0.36 $0.38 $0.50
Dividend* $0.02 $0.03 $0.04 $0.06 $0.09 $0.09 $0.10 $0.13 $0.16 $0.20 $0.28 $0.32 $0.40 $0.40 $0.40 1180.00% <-Total Growth 10 Dividends
Increase 0.00% 25.00% 40.00% 71.43% 41.67% 5.88% 5.56% 31.58% 24.00% 29.03% 40.00% 14.29% 25.00% 0.00% 0.00% Count 15 Years of data
Dividends 5 Yr Running $0.10 $0.12 $0.16 $0.23 $0.30 $0.37 $0.46 $0.43 $0.38 $0.35 $0.32 $0.27 $0.32 $0.36 216.00% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.57% 1.00% 0.75% 0.60% 1.26% 1.86% 1.31% 1.36% 1.02% 0.85% 0.91% 0.75% 0.89% 0.97% <-Median-> 10 Yield H/L Price
Yield on High Price 1.25% 0.71% 0.60% 0.50% 0.87% 1.40% 1.14% 1.20% 0.77% 0.69% 0.78% 0.60% 0.81% 0.77% <-Median-> 10 Yield on High Price
Yield on Low Price 2.10% 1.72% 1.02% 0.76% 2.27% 2.78% 1.53% 1.56% 1.51% 1.10% 1.10% 1.00% 0.99% 1.31% <-Median-> 10 Yield on Low Price
Yield on Close Price 1.31% 0.71% 0.41% 0.59% 2.07% 1.40% 1.14% 1.23% 0.81% 0.73% 0.86% 0.61% 0.94% 0.94% 0.94% 0.83% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 11.43% 9.26% 7.95% 11.82% 15.11% 15.19% 16.81% 14.37% 13.69% 14.93% 18.67% 15.69% 16.5% 15.6% 14.4% 15.02% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 0.00% 76.05% 54.15% 53.69% 57.54% 62.17% 68.42% 73.45% 57.22% 42.33% 32.09% 22.96% 16.07% 16.21% 15.93% 55.68% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 9.20% 51.70% 16.83% 17.03% -129.61% 11.28% 7.41% 24.33% 37.33% 13.18% 25.10% 395.38% 28.2% 14.5% #DIV/0! 16.93% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 63.46% 65.09% 84.39% 147.94% 109.99% 70.90% 79.00% 72.38% 42.10% 35.82% 43.37% 29.79% 23.21% #DIV/0! 71.64% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 7.50% 6.81% 6.51% 8.86% 10.41% 11.15% 12.08% 7.75% 9.16% 8.56% 10.63% 8.81% 28.2% 14.5% #DIV/0! 9.01% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 0.00% 47.64% 39.11% 39.63% 42.21% 46.01% 50.35% 48.39% 37.26% 26.32% 19.14% 13.26% 11.56% 12.51% #DIV/0! 39.37% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 0.91% 0.81% 5 Yr Med Payout 14.93% 25.10% 8.81% 29.04% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. 3.03% 16.10% Last Div Inc ---> $0.07 $0.08 14.3% 27.49% <-IRR #YR-> 5 Dividends
-$0.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.32
-$0.10 $0.00 $0.00 $0.00 $0.00 $0.32
Historical Dividends Historical High Div 3.87% Low Div 0.56% Ave Div 2.22% Med Div 1.26% Close Div 1.14% Historical Dividends
High/Ave/Median Values Curr diff Exp. -75.73% 67.71% Exp. -57.60% Exp. -25.46% Exp. -17.72% High/Ave/Median
Future Dividend Yield Div Yd 2.87% earning in 5.00 Years at IRR of 25.00% Div Inc. 205.18% Future Dividend Yield
Future Dividend Yield Div Yd 8.75% earning in 10.00 Years at IRR of 25.00% Div Inc. 831.32% Future Dividend Yield
Future Dividend Yield Div Yd 26.69% earning in 15.00 Years at IRR of 25.00% Div Inc. 2742.17% Future Dividend Yield
Yield if held 5 yrs 3.72% 3.88% 6.44% 10.11% 10.88% 7.05% 3.81% 2.69% 1.56% 2.96% 5.79% 4.40% 4.34% 2.63% 1.69% 5.10% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 1.77% 4.82% 8.36% 14.12% 15.28% 16.74% 14.76% 22.99% 26.11% 25.60% 21.94% 12.83% 8.60% 4.03% 5.93% 16.01% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 7.96% 18.31% 29.85% 36.47% 35.96% 52.09% 49.71% 73.56% 67.37% 51.20% 35.96% <-Median-> 7 Paid Median Price
Yield if held 20 yrs 24.75% 61.69% 95.52% 94.12% 71.91% 43.22% <-Median-> 2 Paid Median Price
Cost covered if held 5 years 13.95% 15.53% 21.61% 26.95% 28.80% 23.11% 14.64% 9.78% 5.54% 9.85% 17.67% 14.86% 14.70% 10.53% 7.62% 16.27% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 6.63% 19.28% 32.24% 45.88% 50.34% 68.84% 72.23% 105.29% 119.58% 113.92% 90.11% 57.94% 38.92% 21.65% 36.53% 70.54% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 32.71% 89.64% 140.90% 175.29% 169.89% 227.91% 240.00% 354.48% 389.05% 344.32% 169.89% <-Median-> 7 Paid Median Price
Cost covered if held 20 years 108.29% 297.83% 464.48% 551.76% 493.48% 203.06% <-Median-> 2 Paid Median Price
Graham No. $2.18 $3.01 $4.61 $5.43 $6.37 $6.88 $7.49 $10.09 $13.19 $15.85 $18.41 $24.62 $27.89 $28.74 $29.84 718.63% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.59 0.83 1.01 1.83 1.06 0.70 0.97 0.91 1.15 1.49 1.67 1.74 1.61 1.11 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 0.74 1.18 1.27 2.21 1.53 0.94 1.11 1.03 1.53 1.83 1.96 2.17 1.78 1.53 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.44 0.48 0.74 1.45 0.59 0.47 0.83 0.80 0.78 1.15 1.38 1.31 1.45 0.81 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 0.70 1.16 1.86 1.89 0.64 0.94 1.11 1.00 1.45 1.72 1.78 2.13 1.53 1.48 1.43 1.59 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -29.90% 16.37% 86.35% 88.75% -35.65% -6.39% 11.05% 0.35% 45.28% 71.96% 77.86% 113.27% 52.72% 48.20% 42.75% 58.62% <-Median-> 10 Graham Price
Pre-2013 split $6.10 $14.00 $34.40 $41.00 $16.40 $25.75 $33.29 $40.50
Price Close $1.53 $3.50 $8.60 $10.25 $4.10 $6.44 $8.32 $10.13 $19.16 $27.25 $32.74 $52.51 $42.59 $42.59 $42.59 1400.29% <-Total Growth 10 Stock Price
Increase 67.12% 129.51% 145.71% 19.19% -60.00% 57.01% 29.28% 21.66% 89.23% 42.22% 20.15% 60.38% -18.89% 0.00% 0.00% 31.10% <-IRR #YR-> 10 Stock Price
P/E 8.71 12.96 19.55 20.20 7.29 10.86 14.73 11.64 16.92 20.34 21.83 25.74 17.60 16.57 15.38 44.54% <-IRR #YR-> 5 Stock Price
Trailing P/E 15.64 20.00 31.85 23.30 8.08 11.44 14.05 17.92 22.02 24.06 24.43 35.01 20.88 17.60 16.57 32.12% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 1.02% 1.19% % Tot Ret 3.17% 2.60% Price Inc 42.22% P/E: 18.23 20.34 45.73% <-IRR #YR-> 5 Price & Dividend
-$3.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.51
-$8.32 $0.00 $0.00 $0.00 $0.00 $52.51
-$3.50 $0.04 $0.06 $0.09 $0.09 $0.10 $0.13 $0.16 $0.20 $0.28 $52.83
-$8.32 $0.13 $0.16 $0.20 $0.28 $52.83
Price H/L Median $1.28 $2.49 $4.65 $9.93 $6.75 $4.84 $7.27 $9.22 $15.20 $23.62 $30.72 $42.81 $44.94 1616.69% <-Total Growth 10 Stock Price
Increase 63.36% 95.40% 86.47% 113.58% -32.05% -28.32% 50.26% 26.83% 64.83% 55.41% 30.07% 39.38% 4.98% 32.88% <-IRR #YR-> 10 Stock Price
P/E 7.29 9.24 10.57 19.57 12.00 8.16 12.87 10.60 13.42 17.62 20.48 20.99 18.57 42.57% <-IRR #YR-> 5 Stock Price
Trailing P/E 13.09 14.25 17.22 22.57 13.30 8.60 12.27 16.32 17.47 20.85 22.92 28.54 22.03 34.24% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 13.51 18.96 21.43 33.33 17.26 10.19 13.62 14.88 20.41 26.24 28.40 31.10 26.65 43.96% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 16.66 25.38 32.75 52.83 28.78 17.00 21.86 22.04 29.15 36.58 39.48 44.83 38.98 10.58 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.36% 1.40% % Tot Ret 3.96% 3.17% Price Inc 39.38% P/E: 13.14 17.62 Count 22 Years of data
-$2.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.81
-$7.27 $0.00 $0.00 $0.00 $0.00 $42.81
-$2.49 $0.04 $0.06 $0.09 $0.09 $0.10 $0.13 $0.16 $0.20 $0.28 $43.13
-$7.27 $0.13 $0.16 $0.20 $0.28 $43.13
High Months Nov Dec May Jun Jan Dec Dec Mar Dec Oct Nov Dec Mar
Pre-2013 split $6.40 $14.15 $23.50 $48.00 $39.00 $25.75 $33.29 $41.60
Price High $1.60 $3.54 $5.88 $12.00 $9.75 $6.44 $8.32 $10.40 $20.14 $28.98 $36.00 $53.46 $49.51 1411.24% <-Total Growth 10 Stock Price
Increase 75.34% 121.09% 66.08% 104.26% -18.75% -33.97% 29.28% 24.96% 93.65% 43.89% 24.22% 48.50% -7.39% 31.20% <-IRR #YR-> 10 Stock Price
P/E 9.14 13.10 13.35 23.65 17.33 10.86 14.73 11.95 17.78 21.63 24.00 26.21 20.46 45.06% <-IRR #YR-> 5 Stock Price
Trailing P/E 16.41 20.21 21.76 27.27 19.21 11.44 14.05 18.41 23.15 25.59 26.87 35.64 24.27 13.23 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 43.89% P/E: 17.56 21.63 23.79 P/E Ratio Historical High
-$3.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $53.46
-$8.32 $0.00 $0.00 $0.00 $0.00 $53.46
Low Mths May Jan Jan Feb Dec Mar Nov Jan Jan Jan Feb Jan Feb
Price Low $0.95 $1.45 $3.43 $7.86 $3.75 $3.24 $6.22 $8.04 $10.25 $18.25 $25.43 $32.16 $40.37 2117.93% <-Total Growth 10 Stock Price
Increase 46.54% 52.23% 136.21% 129.56% -52.34% -13.61% 91.97% 29.32% 27.53% 78.05% 39.34% 26.46% 25.53% 36.33% <-IRR #YR-> 10 Stock Price
P/E 5.44 5.37 7.78 15.49 6.66 5.46 11.00 9.24 9.05 13.62 16.95 15.76 16.68 38.92% <-IRR #YR-> 5 Stock Price
Trailing P/E 9.77 8.29 12.69 17.87 7.38 5.76 10.49 14.23 11.78 16.11 18.98 21.44 19.79 7.96 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 29.32% P/E: 10.12 13.62 5.41 P/E Ratio Historical Low
-$1.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $32.16
Long Term Debt $444.56 $669.88 $639.21 Debt
Debt/Market Cap Ratio 0.20 0.18 0.22 0.19 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $91.72 $228.94 $250.20 $305.34 $386.63 $415.84 Intangibles Goodwill
Intangible/Market Cap Ratio 0.14 0.17 0.13 0.14 0.11 0.14 0.14 <-Median-> 5 Intangible/Market Cap Ratio
Market Cap $62 $152 $423 $506 $206 $327 $530 $646 $1,316 $1,872 $2,257 $3,632 $2,950 $2,950 $2,950 2284.21% <-Total Growth 10 Market Cap
Diluted # of Sh in Million 50.816 60.816 64.028 64.580 69.053 69.027 69.153 69.236 36.09% <-Total Growth 6 Diluted
Change 19.68% 5.28% 0.86% 6.93% -0.04% 0.18% 0.12% 3.07% <-Median-> 6 Change
Average # of Sh in M 40.33 41.81 46.17 49.30 49.94 50.552 60.652 63.784 64.312 68.681 68.802 69.018 69.200 65.08% <-Total Growth 10 Average
Change 6.64% 3.67% 10.43% 6.78% 1.30% 1.23% 19.98% 5.16% 0.83% 6.79% 0.18% 0.31% 0.26% 3.23% <-Median-> 10 Change
Difference 1.5% 4.1% 6.5% 0.1% 0.6% 0.4% 5.0% 0.1% 6.8% 0.0% 0.2% 0.2% 0.1% 0.29% <-Median-> 10 Difference
$151.64 <-12 mths 2608.88%
# of Shares in Millions 40.94 43.52 49.19 49.36 50.26 50.74 63.69 63.82 68.67 68.70 68.95 69.17 69.27 69.27 69.27 4.74% <-IRR #YR-> 10 Shares
Change 2.22% 6.31% 13.02% 0.35% 1.82% 0.95% 25.54% 0.20% 7.60% 0.04% 0.37% 0.32% 0.15% 0.00% 0.00% 1.66% <-IRR #YR-> 5 Shares
CF fr Op $M $8.9 $2.1 $10.2 $17.4 -$3.3 $40.5 $81.6 $32.8 $28.5 $104.2 $76.9 $5.6 $98.4 $191.2 166.00% <-Total Growth 10 Cash Flow
Increase 82.18% -76.35% 386.11% 70.03% -118.95% 1328.2% 101.60% -59.82% -13.05% 265.47% -26.18% -92.72% 1657.14% 94.37% S.Issue SO, ESPP
5 year Running Average $5.3 $6.1 $7.4 $8.7 $7.1 $13.4 $29.3 $33.8 $36.0 $57.5 $64.8 $49.6 $62.7 $95.3 716.53% <-Total Growth 10 CF 5 Yr Running
CFPS $0.22 $0.05 $0.21 $0.35 -$0.07 $0.80 $1.28 $0.51 $0.42 $1.52 $1.12 $0.08 $1.42 $2.76 67.38% <-Total Growth 10 Cash Flow per Share
Increase 78.22% -77.75% 330.10% 69.43% -118.61% 1316.7% 60.59% -59.90% -19.19% 265.34% -26.45% -92.75% 1654.50% 94.37% 10.28% <-IRR #YR-> 10 Cash Flow
5 year Running Average $0.14 $0.16 $0.18 $0.19 $0.15 $0.27 $0.51 $0.58 $0.59 $0.91 $0.97 $0.73 $0.91 $1.38 -41.49% <-IRR #YR-> 5 Cash Flow
P/CF on Med Price 5.87 51.57 22.36 28.18 -102.91 6.06 5.67 17.94 36.59 15.57 27.53 528.95 5.29% <-IRR #YR-> 10 Cash Flow per Share
P/CF on Closing Price 7.02 72.39 41.35 29.09 -62.52 8.07 6.50 19.70 46.14 17.96 29.34 648.80 29.99 -42.44% <-IRR #YR-> 5 Cash Flow per Share
48.85% Diff M/C 16.55% <-IRR #YR-> 10 CFPS 5 yr Running
Excl.Working Capital CF $2.0 $13.9 $16.2 $16.0 $44.4 $0.5 -$31.5 $70.2 $87.7 $56.4 $104.7 $245.7 $0.0 $0.0 7.19% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $10.9 $16.0 $26.4 $33.4 $41.1 $40.9 $50.1 $103.0 $116.3 $160.6 $181.6 $251.3 $98.4 $191.2 1473.15% <-Total Growth 10 Cash Flow less WC
Increase 59.99% 46.32% 65.52% 26.45% 22.79% -0.29% 22.37% 105.59% 12.89% 38.13% 13.11% 38.36% -60.86% 94.37% 31.73% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $6.4 $8.5 $13.2 $18.7 $25.6 $31.6 $38.4 $53.7 $70.3 $94.2 $122.3 $162.6 $161.6 $176.6 38.07% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $0.27 $0.37 $0.54 $0.68 $0.82 $0.81 $0.79 $1.61 $1.69 $2.34 $2.63 $3.63 $1.42 $2.76 34.29% <-IRR #YR-> 10 CF less WC 5 Yr Run
Increase 56.52% 37.64% 46.45% 26.01% 20.60% -1.22% -2.52% 105.18% 4.91% 38.08% 12.70% 37.92% -60.92% 94.37% 33.46% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $0.17 $0.21 $0.30 $0.40 $0.53 $0.64 $0.72 $0.94 $1.14 $1.45 $1.81 $2.38 $2.34 $2.56 25.77% <-IRR #YR-> 10 CFPS - Less WC
P/CF on Med Price 4.79 6.79 8.65 14.66 8.26 6.00 9.24 5.71 8.98 10.10 11.66 11.78 35.81% <-IRR #YR-> 5 CFPS - Less WC
P/CF on Closing Price 5.72 9.54 16.00 15.13 5.02 7.98 10.58 6.27 11.32 11.66 12.43 14.45 29.99 15.43 27.50% <-IRR #YR-> 10 CFPS 5 yr Running
*Operational Cash Flow CF/CF-WC P/CF Med 10 yr 20.15 5 yr 27.53 P/CF Med 10 yr 9.11 5 yr 10.10 229.27% Diff M/C 26.86% <-IRR #YR-> 5 CFPS 5 yr Running
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.08 Cash Flow per Share
-$1.28 $0.00 $0.00 $0.00 $0.00 $0.08 Cash Flow per Share
-$0.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.7 CFPS 5 yr Running
-$0.5 $0.0 $0.0 $0.0 $0.0 $0.7 CFPS 5 yr Running
-$16.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $251.3 Cash Flow less WC
-$50.1 $0.0 $0.0 $0.0 $0.0 $251.3 Cash Flow less WC
-$8.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $162.6 CF less WC 5 Yr Run
-$38.4 $0.0 $0.0 $0.0 $0.0 $162.6 CF less WC 5 Yr Run
OPM 6.90% 1.34% 4.57% 6.45% -0.86% 9.85% 14.55% 5.12% 3.97% 10.74% 6.16% 0.36% -73.20% <-Total Growth 10 OPM
Increase 36.37% -80.59% 241.22% 41.12% -113% -1250% 47.72% -64.78% -22.42% 170.29% -42.69% -94.17% Should increase or be stable.
Diff from Ave 22.3% -76.3% -19.0% 14.3% -115.2% 74.6% 157.9% -9.2% -29.5% 90.5% 9.2% -93.6% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 5.64% 5 Yrs 5.12% should be zero, it is a check on calculations
Current Assets $67.36 $100.54 $152.24 $169.57 $277.11 $254.58 $272.25 $330.52 $534.86 $581.90 $697.50 $1,011.16 $1,032.61 Liquidity ratio of 1.5 and up, best
Current Liabilities $30.77 $45.05 $72.27 $66.33 $120.21 $84.50 $79.85 $57.33 $90.06 $64.85 $82.41 $156.80 $142.77 4.59 <-Median-> 10 Ratio
Liquidity Ratio 2.19 2.23 2.11 2.56 2.31 3.01 3.41 5.77 5.94 8.97 8.46 6.45 7.23 6.45 <-Median-> 5 Ratio
Liq. with CF aft div 2.45 2.25 2.22 2.77 2.23 3.44 4.36 6.20 6.14 10.37 9.16 6.34 7.73 6.34 <-Median-> 5 Ratio
Liq. CF re Inv+Div 2.18 2.25 1.31 2.05 1.60 3.27 2.06 3.74 2.06 4.60 4.51 3.88 7.73 3.88 <-Median-> 5 Ratio
Assets $98.12 $137.89 $213.67 $244.59 $407.55 $370.80 $521.63 $617.06 $955.86 $1,071.92 $1,287.50 $1,776.22 $1,881.35 Debt Ratio of 1.5 and up, best
Liabilities $48.91 $73.08 $107.85 $117.10 $246.34 $190.82 $240.25 $285.14 $487.11 $499.74 $595.23 $862.72 $891.95 2.07 <-Median-> 10 Ratio
Debt Ratio 2.01 1.89 1.98 2.09 1.65 1.94 2.17 2.16 1.96 2.14 2.16 2.06 2.11 2.14 <-Median-> 5 Ratio
Book Value $49.21 $64.81 $105.82 $127.49 $161.20 $179.98 $281.39 $331.91 $468.75 $572.18 $692.27 $913.50 $989.40 $989.40 $989.40 1309.55% <-Total Growth 10 Book Value
BV per share $1.20 $1.49 $2.15 $2.58 $3.21 $3.55 $4.42 $5.20 $6.83 $8.33 $10.04 $13.21 $14.28 $14.28 $14.28 786.97% <-Total Growth 10 Book Value per Share
Change 13.84% 23.89% 44.47% 20.05% 24.19% 10.60% 24.54% 17.72% 31.25% 22.02% 20.55% 31.54% 8.15% 0.00% 0.00% 35.92% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.06 1.67 2.16 3.85 2.10 1.36 1.65 1.77 2.23 2.84 3.06 3.24 3.15 1.36 P/B Ratio Historical Median
P/B Ratio (Close) 1.27 2.35 4.00 3.97 1.28 1.81 1.88 1.95 2.81 3.27 3.26 3.98 2.98 2.98 2.98 24.39% <-IRR #YR-> 10 Book Value per Share
Change 46.81% 85.25% 70.08% -0.72% -67.79% 41.96% 3.81% 3.35% 44.18% 16.56% -0.33% 21.93% -25.00% 0.00% 0.00% 24.49% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 1.99 2.13 2.02 1.92 2.53 2.06 1.85 1.86 2.04 1.87 1.86 1.94 1.90 1.87 <-Median-> 5 A/BV
Debt/Equity Ratio 0.99 1.13 1.02 0.92 1.53 1.06 0.85 0.86 1.04 0.87 0.86 0.94 0.90 0.87 <-Median-> 5 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.19 5 yr Med 2.84 35.92% Diff M/C 2.02 Historical Leverage (A/BK)
-$1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.21
-$4.42 $0.00 $0.00 $0.00 $0.00 $13.21
$152.00 <-12 mths -36.97%
Comprehensive Income $20.97 $22.15 $35.85 $22.43 $28.88 $58.77 $67.69 $116.52 $137.06 $241.16 988.88% <-Total Growth 9 Comprehensive Income
Increase 5.59% 61.85% -37.43% 28.76% 103.51% 15.16% 72.15% 17.63% 75.95% 72.15% <-Median-> 5 Comprehensive Income
5 Yr Running Average $26.05 $33.61 $42.72 $58.86 $81.78 $124.24 31.17% <-IRR #YR-> 9 Comprehensive Income
ROE 19.8% 17.4% 22.2% 12.5% 10.3% 17.7% 14.4% 20.4% 19.8% 26.4% 52.88% <-IRR #YR-> 5 Comprehensive Income
5Yr Median 17.4% 17.4% 14.4% 14.4% 17.7% 19.8% 36.67% <-IRR #YR-> 5 5 Yr Running Average
% Difference from NI 0.6% -13.8% 25.6% -25.4% -16.0% 5.5% -7.4% 25.9% 32.0% 70.6% 36.67% <-IRR #YR-> 5 5 Yr Running Average
Median Values Diff 5, 10 yr 3.1% 25.9% 19.8% <-Median-> 5 Return on Equity
-$21.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $241.2
-$28.9 $0.0 $0.0 $0.0 $0.0 $241.2
-$26.1 $0.0 $0.0 $0.0 $0.0 $124.2
-$26.1 $0.0 $0.0 $0.0 $0.0 $124.2
Current Liability Coverage Ratio 0.35 0.35 0.37 0.50 0.34 0.48 0.63 1.80 1.29 2.48 2.20 1.60 CFO / Current Liabilities
5 year Median 0.19 0.22 0.35 0.35 0.35 0.37 0.48 0.50 0.63 1.29 1.80 1.80 1.80 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 11.13% 11.58% 12.37% 13.67% 10.07% 11.04% 9.60% 16.69% 12.16% 14.98% 14.11% 14.15% CFO / Total Assets
5 year Median 7.31% 8.38% 11.13% 11.58% 11.58% 11.58% 11.04% 11.04% 11.04% 12.16% 14.11% 14.15% 14.1% <-Median-> 5 Return on Assets
Return on Assets ROA 7.4% 8.3% 9.8% 10.5% 7.0% 8.1% 6.6% 9.0% 7.6% 8.6% 8.1% 8.0% Net Income/Assets Return on Assets
5Yr Median 4.2% 5.4% 7.4% 8.3% 8.3% 8.3% 8.1% 8.1% 7.6% 8.1% 8.1% 8.1% 8.1% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 14.8% 17.8% 19.7% 20.2% 17.7% 16.7% 12.2% 16.8% 15.6% 16.2% 15.0% 15.5% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 10.0% 10.5% 14.8% 17.8% 17.8% 17.8% 17.7% 16.8% 16.7% 16.2% 15.6% 15.6% 15.6% <-Median-> 5 Return on Equity
$168.37 <-12 mths 19.09%
Net Income $7.29 $11.50 $20.85 $25.70 $28.55 $30.07 $34.40 $55.71 $73.07 $92.54 $103.85 $141.38 $168 $176 $192 1128.85% <-Total Growth 10 Net Income
Increase 94.23% 57.79% 81.19% 23.29% 11.08% 5.33% 14.39% 61.97% 31.16% 26.64% 12.22% 36.14% 18.83% 4.76% 9.09% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $3.7 $5.4 $9.4 $13.8 $18.8 $23.3 $27.9 $34.9 $44.4 $57.2 $71.9 $93.3 $115.8 $136.4 $156.2 28.51% <-IRR #YR-> 10 Net Income
Operating Cash Flow $8.90 $2.10 $10.23 $17.39 -$3.30 $40.48 $81.61 $32.79 $28.52 $104.22 $76.93 $5.60 32.67% <-IRR #YR-> 5 Net Income
Investment Cash Flow -$3.88 $23.83 -$50.36 -$23.53 -$49.04 -$4.26 -$89.38 -$37.66 -$178.06 -$81.24 -$85.17 -$99.61 33.09% <-IRR #YR-> 10 5 Yr Running Ave.
Total Accruals $2.28 -$14.43 $60.98 $31.84 $80.88 -$6.15 $42.17 $60.57 $222.61 $69.56 $112.09 $235.38 27.30% <-IRR #YR-> 5 5 Yr Running Ave.
Total Assets $98.12 $137.89 $213.67 $244.59 $407.55 $370.80 $521.63 $617.06 $955.86 $1,071.92 $1,287.50 $1,776.22 Balance Sheet Assets
Accruals Ratio 2.32% -10.46% 28.54% 13.02% 19.85% -1.66% 8.08% 9.82% 23.29% 6.49% 8.71% 13.25% 9.82% <-Median-> 5 Ratio
EPS/CF Ratio 0.66 0.74 0.82 0.75 0.69 0.73 0.72 0.54 0.67 0.57 0.57 0.56 0.68 <-Median-> 10 EPS/CF Ratio
-$11.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $141.4
-$34.4 $0.0 $0.0 $0.0 $0.0 $141.4
-$5.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $93.3
-$27.9 $0.0 $0.0 $0.0 $0.0 $93.3
Change in Close 67.12% 129.51% 145.71% 19.19% -60.00% 57.01% 29.28% 21.66% 89.23% 42.22% 20.15% 60.38% -18.89% 0.00% 0.00% Count 23 Years of data
up/down down up down down down down down down down down down Count 15 65.22%
Meet Prediction? yes yes % right Count 6 40.00%
Financial Cash Flow -$5.01 $21.64 $39.94 $6.14 $52.34 -$36.22 $7.78 $4.86 $163.54 -$33.78 $5.05 $98.30 C F Statement Financial Cash Flow
Total Accruals $7.29 -$36.07 $21.03 $25.70 $28.55 $30.07 $34.40 $55.71 $59.07 $103.35 $107.04 $137.09 Accruals
Accruals Ratio 7.43% -26.16% 9.84% 10.51% 7.00% 8.11% 6.59% 9.03% 6.18% 9.64% 8.31% 7.72% 8.31% <-Median-> 5 Ratio
Cash $0.00 $14.00 $3.19 $0.00 $4.29 $3.99 Cash
Cash per Share $0.00 $0.20 $0.05 $0.00 $0.06 $0.06 $0.05 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.00% 1.06% 0.17% 0.00% 0.12% 0.14% 0.12% <-Median-> 5 % of Stock Price
Yes 0 Yes 0
Notes:
December 11, 2016. Last estimates were for 2015, 2016 and 2017 of $1560M, $1785M and $1898M for Revenue, $2.01, $2.45 and $2.70 for EPS, $1.42, $2.61 and 2.76 for CFPS and $141M, $171M and $185M for Net Income.
December 13, 2015. Last estimates were for 2014, 2015 and 2016 of $1248M, $1386M and $1469M for Revenue , $1.54, $1.93 and $2.09 for EPS, $1.36, $1.79 and $2.35 for CFPS and $106M, $134M and $149M for Net Income.
December 14, 2014. Last estimates were for 2013, 2014 and 2015 of $344M, $351.1M and $354M for Revenue, -$3.16, $0.50 and $0.52 for EPS, $0.62, $0.86 and $0.96 for CFPS.
December 19, 2013. Last estimates were for 2012 and 2013 of $734M and $1040M for Revenue and $4.45 and $5.38 for EPS.
December 21, 2012. Last estimates were for 2011 and 2012 of $3.34 and $3.82 for EPS and $4.32 and $4.59 for CFPS.
Nov 20, 2011. Last estiamtes for 2009 and 2010 were $2.55 and $2.75 for EPS.
Jun 13, 2009AR 2008. My one concern is that with the Accrual Ratio so high there may be a question on the quality of the reported earnings. This is a small, dividend paying growing company.
As such, this investment would be part speculation and part investment. A lot of the return on this stock will be an increase in stock price.
The thing I worry about is that cash flow was negative in 2008. Cash Flow is usually more accurate than EPS. They have EPS, but not Cash Flow. Also, the high Accrual Ratio points may point to a problem
with the quality of their earnings.
Dividends are paid Semi-annually in May and November. Dividends are usually raised in November.
Sector:
Materials
What should this stock accomplish?
You would buy this stock for diversification. This is currently a fast growing stock, but that will not always be the case. There will be volitiity.
You should expect to earn total returns over the long haul at a minimum of 10% with 1% from dividends and 9% from capital gains.
Dividends
Dividends are paid in the third cycle of March, June, September and December. Dividends are declared in one month and paid to shareholders of records in the next month.
For example, the dividend payable on December 20, 2013 to shareholders of record of December 2, 2013 was announced on November 8, 2013.
Why am I following this stock.
I started a spreadsheet on this stock in mid-2009 because of a favorable report I read on this stock. It was considered to be a dividend growth stock and I am always on the lookout for dividend growth stocks.
How they make their money.
Stella-Jones Inc. is a leading North American producer and marketer of industrial pressure treated wood products, specializing in the production of railway ties and timbers as well as wood poles supplied
to electrical utilities and telecommunications companies. The Company also provides treated consumer lumber products and customized services to lumber retailers and wholesalers for outdoor applications.
Other products include marine and foundation pilings, construction timbers, highway guardrail posts and treated wood for bridges. It has sales in Canada and US.
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
Date Dec 21 2012 Dec 19 2013 Dec 14 2014 Dec 13 2015 Dec 12 2016
McManus, Brian 0.03 0.05% 0.007 0.01% 0.007 0.01% 0.007 0.01% 0.007 0.01%
CEO - Shares - Amount $0.617 $0.198 $0.240 $0.386 $0.316
Options - percentage 0.20 0.29% 0.520 0.76% 1.840 2.67% 0.400 0.58% 0.000 0.00%
Options - amount $3.832 $14.170 $60.242 $21.004 $0.000
Vachon, Eric 0.00 0.00% 0.003 0.00% 0.005 0.01% 0.005 0.01% 0.004 0.01%
CFO - Shares - Amount $0.056 $0.089 $0.169 $0.281 $0.167
Options - percentage 0.02 0.03% 0.019 0.03% 0.009 0.01% 0.008 0.01% 0.006 0.01%
Options - amount $0.390 $0.510 $0.310 $0.438 $0.275
Eichenbaum, Marla 0.008 0.01% 0.004 0.01% 0.009 0.01%
Officer - Shares - Amount $0.251 $0.231 $0.392
Options - percentage 0.032 0.05% 0.017 0.03% 0.004 0.01%
Options - amount $1.059 $0.913 $0.173
Bunze, George J. 0.07 0.10% 0.071 0.10% 0.079 0.11% 0.079 0.11% 0.044 0.06%
Director - Shares - Amount $1.341 $1.935 $2.570 $4.122 $1.853
Options - percentage 0.03 0.04% 0.030 0.04% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.575 $0.818 $0.000 $0.000 $0.000
Bruce Jones, Tom A. 0.03 0.04% 0.030 0.04% 0.030 0.04% 0.030 0.04% 0.030 0.04%
Chairman - Shares - Amount $0.575 $0.818 $0.982 $1.575 $1.278
Options - percentage 0.03 0.04% 0.030 0.04% 0.030 0.04% 0.030 0.04% 0.000 0.00%
Options - amount $0.575 $0.818 $0.982 $1.575 $0.000
Stella Jones International S.A. 26.57 38.70% 26.57 38.68% 26.573 38.54% 26.573 38.42%
$509.136 $724.110 $869.995 $1,395.340
Stella Jones International S.A. is based in Luxembourg. Stella Jones International S.A. is a joint venture between James Jones & Sons Ltd. and Eurocanadian Investments SA.
James Jones & Sons Limited (forest products, UK) and Stella SpA, through the Stella Jones International S.A. joint venture, control a majority of Stella-Jones Inc.
Increase in O/S Shares 0.115 0.17% 0.000 0.00% 0.222 0.32% 0.165 0.24% Yes 0 for 2013
due to SO $3.134 $0.000 $7.268 $8.664
Book Value $0.837 $0.000 $1.758 $1.629
Insider Buying -$0.036 -$0.090 -$0.133
Insider Selling $5.210 $4.734 $6.015
Net Insider Selling $5.173 $4.644 $5.882
% of Market Cap 0.23% 0.13% 0.20%
Directors 9 9 9 9
Women 2 22% 2 22% 2 22% 2 22%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 32 35.79% 38 34.80% 57 41.05% 74 35.17% 87 31.45%
Total Shares Held 6.132 35.72% 23.907 34.80% 28.271 41.00% 24.295 35.12% 21.786 31.45%
Increase/Decrease -0.048 -0.78% 1.097 4.81% 1.701 6.40% -0.975 -3.86% -0.368 -1.66%
Starting No. of Shares 6.085 22.810 26.570 25.270 22.153
Copyright 2008 Website of SPBrunner. All rights reserved.