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 2017
Stella-Jones Inc. TSX: SJ OTC: STLJF www.stella-jones.com Fiscal Yr: Dec 31 9/30/17
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G
Accounting Rules C GAAP C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
$1,850.5 <-12 mths 0.66%
Revenue* $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,838.4 $1,863 $1,919 $1,978 721.23% <-Total Growth 10 Revenue
Increase 21.83% 42.46% 20.49% 42.68% 6.83% 36.47% 14.10% 12.08% 35.21% 28.79% 24.80% 17.89% 1.34% 3.01% 3.07% 23.44% <-IRR #YR-> 10 Revenue 721.23%
5 year Running Average $113.4 $140.6 $175.2 $232.9 $289.3 $370.1 $453.4 $542.9 $660.0 $827.7 $1,027.3 $1,267.0 $1,496.1 $1,685.8 $1,831.5 23.49% <-IRR #YR-> 5 Revenue 187.18%
Revenue per Share $3.61 $4.55 $5.46 $7.66 $8.10 $8.81 $10.03 $10.45 $14.12 $18.12 $22.54 $26.53 $26.87 $27.68 $28.53 24.59% <-IRR #YR-> 10 5 yr Running Average 800.92%
Increase 14.60% 26.05% 20.07% 40.13% 5.83% 8.71% 13.87% 4.16% 35.16% 28.32% 24.40% 17.66% 1.29% 3.01% 3.07% 22.82% <-IRR #YR-> 5 5 yr Running Average 179.46%
5 year Running Average $2.85 $3.28 $3.84 $4.89 $5.88 $6.92 $8.01 $9.01 $10.30 $12.31 $15.05 $18.35 $21.64 $24.35 $26.43 19.28% <-IRR #YR-> 10 Revenue per Share 482.92%
P/S (Price/Sales) Med 0.69 1.02 1.82 0.88 0.60 0.83 0.92 1.45 1.67 1.69 1.90 1.69 21.47% <-IRR #YR-> 5 Revenue per Share 164.46%
P/S (Price/Sales) Close 0.97 1.89 1.88 0.54 0.79 0.94 1.01 1.83 1.93 1.81 2.33 1.64 1.85 1.80 1.74 18.80% <-IRR #YR-> 10 5 yr Running Average 459.85%
*Sales in M CDN $ P/S Med 10 yr 1.56 5 yr 1.69 18.28% Diff M/C 18.03% <-IRR #YR-> 5 5 yr Running Average 129.05%
-$223.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,838.4
-$640.1 $0.0 $0.0 $0.0 $0.0 $1,838.4
-$140.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,267.0
-$453.4 $0.0 $0.0 $0.0 $0.0 $1,267.0
-$4.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.53
-$10.03 $0.00 $0.00 $0.00 $0.00 $26.53
-$3.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.35
-$8.01 $0.00 $0.00 $0.00 $0.00 $18.35
$1.94 <-12 mths -12.61%
EPS Basic $0.28 $0.45 $0.52 $0.57 $0.60 $0.57 $0.87 $1.14 $1.35 $1.51 $2.05 $2.22 393.33% <-Total Growth 10 EPS Basic
EPS Diluted* $0.27 $0.44 $0.51 $0.56 $0.59 $0.57 $0.87 $1.13 $1.34 $1.50 $2.04 $2.22 $2.05 $2.39 $2.64 404.55% <-Total Growth 10 EPS Diluted
Increase 54.29% 62.96% 15.34% 10.84% 5.33% -4.64% 53.98% 30.17% 18.32% 11.94% 36.00% 8.82% -7.66% 16.59% 10.46% 17.57% <-IRR #YR-> 10 Earnings per Share 404.55%
Earnings Yield 7.7% 5.1% 5.0% 13.7% 9.2% 6.8% 8.6% 5.9% 4.9% 4.6% 3.9% 5.1% 4.1% 4.8% 5.3% 20.61% <-IRR #YR-> 5 Earnings per Share 155.17%
5 year Running Average $0.13 $0.22 $0.30 $0.39 $0.47 $0.53 $0.62 $0.74 $0.90 $1.08 $1.38 $1.65 $1.83 $2.04 $2.27 22.46% <-IRR #YR-> 10 5 yr Running Average 658.76%
10 year Running Average $0.10 $0.14 $0.19 $0.23 $0.28 $0.33 $0.42 $0.52 $0.65 $0.78 $0.96 $1.13 $1.29 $1.47 $1.67 21.59% <-IRR #YR-> 5 5 yr Running Average 165.78%
* Diluted ESP per share E/P 10 Yrs 5.50% 5Yrs 4.92%
-$0.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.22
-$0.87 $0.00 $0.00 $0.00 $0.00 $2.22
-$0.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.65
-$0.62 $0.00 $0.00 $0.00 $0.00 $1.65
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.10 $0.14 $0.24 $0.34 $0.36 $0.38 $0.50
Dividend* $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.43 $0.44 $0.44 1042.86% <-Total Growth 10 Dividends
Increase 25.00% 40.00% 71.43% 41.67% 5.88% 5.56% 31.58% 24.00% 29.03% 40.00% 14.29% 25.00% 7.50% 2.33% 0.00% Count 16 Years of data
Average Increases 5 Year Running 7.9% 15.9% 30.1% 35.6% 36.8% 32.9% 31.2% 21.7% 19.2% 26.0% 27.8% 26.5% 23.2% 17.8% 9.8% 28.96% <-Median-> 10 Average Incr 5 Year Running
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.33 $0.37 $0.41 130.64% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 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.96% 0.97% <-Median-> 10 Yield H/L Price
Yield on High Price 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.84% 0.79% <-Median-> 10 Yield on High Price
Yield on Low Price 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.12% 1.31% <-Median-> 10 Yield on Low Price
Yield on Close Price 0.71% 0.41% 0.59% 2.07% 1.40% 1.14% 1.23% 0.81% 0.73% 0.86% 0.61% 0.92% 0.87% 0.89% 0.89% 0.89% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 9.26% 7.95% 11.82% 15.11% 15.19% 16.81% 14.37% 13.69% 14.93% 18.67% 15.69% 18.02% 21.0% 18.4% 16.7% 15.15% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 76.05% 54.15% 53.69% 57.54% 62.17% 68.42% 73.45% 57.22% 42.33% 32.09% 22.96% 16.46% 17.81% 18.33% 17.90% 55.46% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 51.70% 16.83% 17.03% -129.61% 11.28% 7.41% 24.33% 37.33% 13.18% 25.10% 395.38% 15.25% 21.7% 15.7% 14.8% 16.14% <-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% 23.55% 22.28% 21.72% 19.38% 71.64% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 6.81% 6.51% 8.86% 10.41% 11.15% 12.08% 7.75% 9.16% 8.56% 10.63% 8.70% 10.31% 21.7% #DIV/0! #DIV/0! 9.73% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 47.64% 39.11% 39.63% 42.21% 46.01% 50.35% 48.39% 37.26% 26.32% 19.14% 13.22% 9.53% 11.23% #DIV/0! #DIV/0! 38.44% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 0.89% 0.81% 5 Yr Med Payout 15.69% 25.10% 9.16% 27.58% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. -0.50% 9.48% Last Div Inc ---> $0.10 $0.11 10.0% 26.19% <-IRR #YR-> 5 Dividends
-$0.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.40
-$0.13 $0.00 $0.00 $0.00 $0.00 $0.40
Historical Dividends Historical High Div 3.85% Low Div 0.57% Ave Div 2.21% Med Div 1.14% Close Div 1.03% Historical Dividends
High/Ave/Median Values Curr diff Exp. -77.00% 55.38% Exp. -59.92% Exp. -22.31% Exp. -13.99% High/Ave/Median
Future Dividend Yield Div Yd 2.70% earning in 5.00 Years at IRR of 25.00% Div Inc. 205.18% Future Dividend Yield
Future Dividend Yield Div Yd 8.25% earning in 10.00 Years at IRR of 25.00% Div Inc. 831.32% Future Dividend Yield
Future Dividend Yield Div Yd 25.17% earning in 15.00 Years at IRR of 25.00% Div Inc. 2742.17% Future Dividend Yield
Yield if held 5 years 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.83% 1.86% 1.43% 4.37% <-Median-> 10 Paid Median Price
Yield if held 10 years 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.33% 6.52% 9.10% 16.01% <-Median-> 10 Paid Median Price
Yield if held 15 years 7.96% 18.31% 29.85% 36.47% 35.96% 52.09% 49.71% 73.56% 72.42% 56.32% 34.48% 36.21% <-Median-> 8 Paid Median Price
Yield if held 20 years 24.75% 61.69% 95.52% 101.18% 79.10% 81.86% 61.69% <-Median-> 3 Paid Median Price
Yield if held 25 years 38.90% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 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.73% 7.92% 6.61% 14.78% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 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.95% 37.56% 59.64% 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% 394.11% 353.28% 249.17% 172.59% <-Median-> 8 Paid Median Price
Cost covered if held 20 years 108.29% 297.83% 464.48% 558.82% 506.07% 605.58% 297.83% <-Median-> 3 Paid Median Price
Cost covered if held 25 years 287.73% #NUM! <-Median-> 0 Paid Median Price
Graham No. $3.01 $4.61 $5.43 $6.37 $6.88 $7.49 $10.09 $13.19 $15.85 $18.41 $24.62 $27.20 $26.61 $28.73 $30.20 489.38% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.83 1.01 1.83 1.06 0.70 0.97 0.91 1.15 1.49 1.67 1.74 1.65 1.69 1.32 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.18 1.27 2.21 1.53 0.94 1.11 1.03 1.53 1.83 1.96 2.17 1.82 1.93 1.68 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.48 0.74 1.45 0.59 0.47 0.83 0.80 0.78 1.15 1.38 1.31 1.48 1.44 0.99 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.16 1.86 1.89 0.64 0.94 1.11 1.00 1.45 1.72 1.78 2.13 1.60 1.87 1.73 1.65 1.53 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 16.37% 86.35% 88.75% -35.65% -6.39% 11.05% 0.35% 45.28% 71.96% 77.86% 113.27% 60.23% 86.71% 72.92% 64.53% 52.75% <-Median-> 10 Graham Price
Pre-2013 split $14.00 $34.40 $41.00 $16.40 $25.75 $33.29 $40.50
Price Close $3.50 $8.60 $10.25 $4.10 $6.44 $8.32 $10.13 $19.16 $27.25 $32.74 $52.51 $43.58 $49.68 $49.68 $49.68 406.74% <-Total Growth 10 Stock Price
Increase 129.51% 145.71% 19.19% -60.00% 57.01% 29.28% 21.66% 89.23% 42.22% 20.15% 60.38% -17.01% 14.00% 0.00% 0.00% 17.62% <-IRR #YR-> 10 Stock Price 406.74%
P/E 12.96 19.55 20.20 7.29 10.86 14.73 11.64 16.92 20.34 21.83 25.74 19.63 24.23 20.79 18.82 33.90% <-IRR #YR-> 5 Stock Price 330.42%
Trailing P/E 20.00 31.85 23.30 8.08 11.44 14.05 17.92 22.02 24.06 24.43 35.01 21.36 22.38 24.23 20.79 18.47% <-IRR #YR-> 10 Price & Dividend 428.20%
Median 10, 5 Yrs D. per yr 0.85% 1.42% % Tot Ret 4.62% 4.02% Price Inc 42.22% P/E: 18.27 20.34 35.32% <-IRR #YR-> 5 Price & Dividend 345.04%
-$8.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $43.58
-$10.13 $0.00 $0.00 $0.00 $0.00 $43.58
-$8.60 $0.06 $0.09 $0.09 $0.10 $0.13 $0.16 $0.20 $0.28 $0.32 $43.98
-$10.13 $0.16 $0.20 $0.28 $0.32 $43.98
Price H/L Median $2.49 $4.65 $9.93 $6.75 $4.84 $7.27 $9.22 $15.20 $23.62 $30.72 $42.81 $44.94 $44.86 866.45% <-Total Growth 10 Stock Price
Increase 95.40% 86.47% 113.58% -32.05% -28.32% 50.26% 26.83% 64.83% 55.41% 30.07% 39.38% 4.98% -0.19% 25.46% <-IRR #YR-> 10 Stock Price 866.45%
P/E 9.24 10.57 19.57 12.00 8.16 12.87 10.60 13.42 17.62 20.48 20.99 20.24 21.88 37.28% <-IRR #YR-> 5 Stock Price 387.48%
Trailing P/E 14.25 17.22 22.57 13.30 8.60 12.27 16.32 17.47 20.85 22.92 28.54 22.03 20.20 26.64% <-IRR #YR-> 10 Price & Dividend 906.13%
P/E on Run. 5 yr Ave 18.96 21.43 33.33 17.26 10.19 13.62 14.88 20.41 26.24 28.40 31.10 27.29 24.51 38.77% <-IRR #YR-> 5 Price & Dividend 403.54%
P/E on Run. 10 yr Ave 25.38 32.75 52.83 28.78 17.00 21.86 22.04 29.15 36.58 39.48 44.83 39.66 34.85 10.60 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.18% 1.49% % Tot Ret 4.41% 3.84% Price Inc 39.38% P/E: 15.52 20.24 Count 23 Years of data
-$4.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.94
-$9.22 $0.00 $0.00 $0.00 $0.00 $44.94
-$4.65 $0.06 $0.09 $0.09 $0.10 $0.13 $0.16 $0.20 $0.28 $0.32 $45.34
-$9.22 $0.16 $0.20 $0.28 $0.32 $45.34
High Months Dec May Jun Jan Dec Dec Mar Dec Oct Nov Dec Mar Dec
Pre-2013 split $14.15 $23.50 $48.00 $39.00 $25.75 $33.29 $41.60
Price High $3.54 $5.88 $12.00 $9.75 $6.44 $8.32 $10.40 $20.14 $28.98 $36.00 $53.46 $49.51 $51.41 742.72% <-Total Growth 10 Stock Price
Increase 121.09% 66.08% 104.26% -18.75% -33.97% 29.28% 24.96% 93.65% 43.89% 24.22% 48.50% -7.39% 3.84% 23.76% <-IRR #YR-> 10 Stock Price 742.72%
P/E 13.10 13.35 23.65 17.33 10.86 14.73 11.95 17.78 21.63 24.00 26.21 22.30 25.08 36.63% <-IRR #YR-> 5 Stock Price 376.06%
Trailing P/E 20.21 21.76 27.27 19.21 11.44 14.05 18.41 23.15 25.59 26.87 35.64 24.27 23.16 13.35 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 43.89% P/E: 19.71 22.30 23.72 P/E Ratio Historical High
-$5.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $49.51
-$10.40 $0.00 $0.00 $0.00 $0.00 $49.51
Low Mths Jan Jan Feb Dec Mar Nov Jan Jan Jan Feb Jan Feb Mar
Price Low $1.45 $3.43 $7.86 $3.75 $3.24 $6.22 $8.04 $10.25 $18.25 $25.43 $32.16 $40.37 $38.30 1078.69% <-Total Growth 10 Stock Price
Increase 52.23% 136.21% 129.56% -52.34% -13.61% 91.97% 29.32% 27.53% 78.05% 39.34% 26.46% 25.53% -5.13% 27.98% <-IRR #YR-> 10 Stock Price 1078.69%
P/E 5.37 7.78 15.49 6.66 5.46 11.00 9.24 9.05 13.62 16.95 15.76 18.18 18.68 38.10% <-IRR #YR-> 5 Stock Price 402.27%
Trailing P/E 8.29 12.69 17.87 7.38 5.76 10.49 14.23 11.78 16.11 18.98 21.44 19.79 17.25 8.14 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 27.53% P/E: 12.31 15.76 5.43 P/E Ratio Historical Low
-$3.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.37
Long Term Debt $444.56 $669.88 $687.47 $449.03 Debt
Change 50.68% 2.63% -34.68% 26.65% <-Median-> 2 Change
Debt/Market Cap Ratio 0.20 0.18 0.23 0.13 0.20 <-Median-> 3 Debt/Market Cap Ratio
Goodwill & Intangibles $91.72 $228.94 $250.20 $305.34 $386.63 $431.86 $395.72 Intangibles Goodwill
Change 149.61% 9.29% 22.04% 26.62% 11.70% -8.37% 22.04% <-Median-> 5 Change
Intangible/Market Cap Ratio 0.14 0.17 0.13 0.14 0.11 0.14 0.11 0.14 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $152 $423 $506 $206 $327 $530 $646 $1,316 $1,872 $2,257 $3,632 $3,020 $3,445 $3,445 $3,445 613.91% <-Total Growth 10 Market Cap
Pre-2013 split 12.704 15.204 16.007
Diluted # of Shares in Million 50.816 60.816 64.028 64.580 69.053 69.027 69.153 69.231 69.329 36.24% <-Total Growth 7 Diluted
Change 19.68% 5.28% 0.86% 6.93% -0.04% 0.18% 0.11% 0.14% 0.86% <-Median-> 7 Change
Basic # of Shares in Millions 41.81 46.17 49.30 49.94 50.552 60.652 63.784 64.312 68.681 68.802 69.018 69.215 69.319 49.91% <-Total Growth 10 Average
Change 3.67% 10.43% 6.78% 1.30% 1.23% 19.98% 5.16% 0.83% 6.79% 0.18% 0.31% 0.29% 0.15% 1.26% <-Median-> 10 Change
Difference 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.0% 0.21% <-Median-> 10 Difference
$281.84 <-12 mths 55.00%
# of Shares in Millions 43.52 49.19 49.36 50.26 50.74 63.69 63.82 68.67 68.70 68.95 69.17 69.30 69.34 69.34 69.34 3.49% <-IRR #YR-> 10 Shares 40.88%
Change 6.31% 13.02% 0.35% 1.82% 0.95% 25.54% 0.20% 7.60% 0.04% 0.37% 0.32% 0.20% 0.05% 0.00% 0.00% 1.66% <-IRR #YR-> 5 Shares 8.59%
CF fr Op $M $2.1 $10.2 $17.4 -$3.3 $40.5 $81.6 $32.8 $28.5 $104.2 $76.9 $5.6 $181.8 $137.3 $194.8 $206.6 1677.36% <-Total Growth 10 Cash Flow
Increase -76.35% 386.11% 70.03% -118.95% 1328.2% 101.60% -59.82% -13.05% 265.47% -26.18% -92.72% 3148.09% -24.50% 41.92% 6.05% S.Issue SO, ESPP
5 year Running Average $6.1 $7.4 $8.7 $7.1 $13.4 $29.3 $33.8 $36.0 $57.5 $64.8 $49.6 $79.4 $101.2 $119.3 $145.2 966.53% <-Total Growth 10 CF 5 Yr Running
CFPS $0.05 $0.21 $0.35 -$0.07 $0.80 $1.28 $0.51 $0.42 $1.52 $1.12 $0.08 $2.62 $1.98 $2.81 $2.98 1161.59% <-Total Growth 10 Cash Flow per Share
Increase -77.75% 330.10% 69.43% -118.61% 1316.7% 60.59% -59.90% -19.19% 265.34% -26.45% -92.75% 3141.71% -24.53% 41.92% 6.05% 33.35% <-IRR #YR-> 10 Cash Flow 1677.36%
5 year Running Average $0.16 $0.18 $0.19 $0.15 $0.27 $0.51 $0.58 $0.59 $0.91 $0.97 $0.73 $1.15 $1.46 $1.72 $2.09 40.86% <-IRR #YR-> 5 Cash Flow 454.46%
P/CF on Med Price 51.57 22.36 28.18 -102.91 6.06 5.67 17.94 36.59 15.57 27.53 528.95 17.13 22.65 28.85% <-IRR #YR-> 10 Cash Flow per Share 1161.59%
P/CF on Closing Price 72.39 41.35 29.09 -62.52 8.07 6.50 19.70 46.14 17.96 29.34 648.80 16.61 25.09 17.68 16.67 38.55% <-IRR #YR-> 5 Cash Flow per Share 410.59%
43.09% Diff M/C 20.35% <-IRR #YR-> 10 CFPS 5 yr Running 537.38%
$247.04 <-12 mths -8.12%
Excl.Working Capital CF $13.9 $16.2 $16.0 $44.4 $0.5 -$31.5 $70.2 $87.7 $56.4 $104.7 $248.7 $87.0 $0.0 14.84% <-IRR #YR-> 5 CFPS 5 yr Running 99.76%
CF fr Op $M WC $16.0 $26.4 $33.4 $41.1 $40.9 $50.1 $103.0 $116.3 $160.6 $181.6 $254.3 $268.9 $137.3 916.87% <-Total Growth 10 Cash Flow less WC
Increase 46.32% 65.52% 26.45% 22.79% -0.29% 22.37% 105.59% 12.89% 38.13% 13.11% 40.02% 5.72% -48.94% 26.10% <-IRR #YR-> 10 Cash Flow less WC 916.87%
5 year Running Average $8.5 $13.2 $18.7 $25.6 $31.6 $38.4 $53.7 $70.3 $94.2 $122.3 $163.2 $196.3 $200.5 21.16% <-IRR #YR-> 5 Cash Flow less WC 161.07%
CFPS Excl. WC $0.37 $0.54 $0.68 $0.82 $0.81 $0.79 $1.61 $1.69 $2.34 $2.63 $3.68 $3.88 $1.98 31.00% <-IRR #YR-> 10 CF less WC 5 Yr Run 1387.99%
Increase 37.64% 46.45% 26.01% 20.60% -1.22% -2.52% 105.18% 4.91% 38.08% 12.70% 39.58% 5.51% -48.96% 29.60% <-IRR #YR-> 5 CF less WC 5 Yr Run 265.61%
5 year Running Average $0.21 $0.30 $0.40 $0.53 $0.64 $0.72 $0.94 $1.14 $1.45 $1.81 $2.39 $2.84 $2.90 21.85% <-IRR #YR-> 10 CFPS - Less WC 621.79%
P/CF on Med Price 6.79 8.65 14.66 8.26 6.00 9.24 5.71 8.98 10.10 11.66 11.64 11.58 22.65 19.18% <-IRR #YR-> 5 CFPS - Less WC 140.42%
P/CF on Closing Price 9.54 16.00 15.13 5.02 7.98 10.58 6.27 11.32 11.66 12.43 14.28 11.23 25.09 25.21% <-IRR #YR-> 10 CFPS 5 yr Running 846.72%
*Operational Cash Flow CF/CF-WC P/CF Med 10 yr 17.53 5 yr 27.53 P/CF Med 10 yr 9.67 5 yr 11.58 159.41% Diff M/C 24.78% <-IRR #YR-> 5 CFPS 5 yr Running 202.51%
-$0.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.62 Cash Flow per Share
-$0.51 $0.00 $0.00 $0.00 $0.00 $2.62 Cash Flow per Share
-$0.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1.2 CFPS 5 yr Running
-$0.6 $0.0 $0.0 $0.0 $0.0 $1.2 CFPS 5 yr Running
-$26.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $268.9 Cash Flow less WC
-$103.0 $0.0 $0.0 $0.0 $0.0 $268.9 Cash Flow less WC
-$13.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $196.3 CF less WC 5 Yr Run
-$53.7 $0.0 $0.0 $0.0 $0.0 $196.3 CF less WC 5 Yr Run
OPM 1.34% 4.57% 6.45% -0.86% 9.85% 14.55% 5.12% 3.97% 10.74% 6.16% 0.36% 9.89% 116.43% <-Total Growth 10 OPM
Increase -80.59% 241.22% 41.12% -113% -1250% 47.72% -64.78% -22.42% 170.29% -42.69% -94.17% 2655.10% Should increase or be stable.
Diff from Ave -78.8% -27.5% 2.3% -113.6% 56.2% 130.8% -18.7% -36.9% 70.4% -2.3% -94.3% 56.9% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 6.30% 5 Yrs 6.16% should be zero, it is a check on calculations
Current Assets $100.54 $152.24 $169.57 $277.11 $254.58 $272.25 $330.52 $534.86 $581.90 $697.50 $1,011.16 $1,050.52 $938.67 Liquidity ratio of 1.5 and up, best
Current Liabilities $45.05 $72.27 $66.33 $120.21 $84.50 $79.85 $57.33 $90.06 $64.85 $82.41 $156.80 $122.65 $170.59 5.85 <-Median-> 10 Ratio
Liquidity Ratio 2.23 2.11 2.56 2.31 3.01 3.41 5.77 5.94 8.97 8.46 6.45 8.57 5.50 8.46 <-Median-> 5 Ratio
Liq. with CF aft div 2.25 2.22 2.77 2.23 3.44 4.36 6.20 6.14 10.37 9.16 6.34 9.82 6.13 9.16 <-Median-> 5 Ratio
Liq. CF re Inv+Div 2.25 1.31 2.05 1.60 3.27 2.06 3.74 2.06 4.60 4.51 3.88 4.04 6.13 4.04 <-Median-> 5 Ratio
Assets $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,961.96 $1,799.89 Debt Ratio of 1.5 and up, best
Liabilities $73.08 $107.85 $117.10 $246.34 $190.82 $240.25 $285.14 $487.11 $499.74 $595.23 $862.72 $935.54 $735.57 2.09 <-Median-> 10 Ratio
Debt Ratio 1.89 1.98 2.09 1.65 1.94 2.17 2.16 1.96 2.14 2.16 2.06 2.10 2.45 2.10 <-Median-> 5 Ratio
Book Value $64.81 $105.82 $127.49 $161.20 $179.98 $281.39 $331.91 $468.75 $572.18 $692.27 $913.50 $1,026.42 $1,064.32 $1,064.32 $1,064.32 869.95% <-Total Growth 10 Book Value
Book Value per share $1.49 $2.15 $2.58 $3.21 $3.55 $4.42 $5.20 $6.83 $8.33 $10.04 $13.21 $14.81 $15.35 $15.35 $15.35 588.48% <-Total Growth 10 Book Value per Share
Change 23.89% 44.47% 20.05% 24.19% 10.60% 24.54% 17.72% 31.25% 22.02% 20.55% 31.54% 12.14% 3.64% 0.00% 0.00% 115.12% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.67 2.16 3.85 2.10 1.36 1.65 1.77 2.23 2.84 3.06 3.24 3.03 2.92 1.50 P/B Ratio Historical Median
P/B Ratio (Close) 2.35 4.00 3.97 1.28 1.81 1.88 1.95 2.81 3.27 3.26 3.98 2.94 3.24 3.24 3.24 21.28% <-IRR #YR-> 10 Book Value per Share 588.48%
Change 85.25% 70.08% -0.72% -67.79% 41.96% 3.81% 3.35% 44.18% 16.56% -0.33% 21.93% -25.99% 9.99% 0.00% 0.00% 23.28% <-IRR #YR-> 5 Book Value per Share 184.78%
Leverage (A/BK) 2.13 2.02 1.92 2.53 2.06 1.85 1.86 2.04 1.87 1.86 1.94 1.91 1.69 1.91 <-Median-> 5 A/BV
Debt/Equity Ratio 1.13 1.02 0.92 1.53 1.06 0.85 0.86 1.04 0.87 0.86 0.94 0.91 0.69 0.91 <-Median-> 5 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.53 5 yr Med 3.03 27.89% Diff M/C 2.01 Historical Leverage (A/BK)
-$2.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.81
-$5.20 $0.00 $0.00 $0.00 $0.00 $14.81
$103.09 <-12 mths -25.41%
Comprehensive Income $20.97 $22.15 $35.85 $22.43 $28.88 $58.77 $67.69 $116.52 $137.06 $241.16 $138.21 558.91% <-Total Growth 10 Comprehensive Income
Increase 5.59% 61.85% -37.43% 28.76% 103.51% 15.16% 72.15% 17.63% 75.95% -42.69% 17.63% <-Median-> 5 Comprehensive Income
5 Yr Running Average $26.05 $33.61 $42.72 $58.86 $81.78 $124.24 $140.12 20.75% <-IRR #YR-> 10 Comprehensive Income 558.91%
ROE 19.8% 17.4% 22.2% 12.5% 10.3% 17.7% 14.4% 20.4% 19.8% 26.4% 13.5% 18.65% <-IRR #YR-> 5 Comprehensive Income 135.15%
5Yr Median 17.4% 17.4% 14.4% 14.4% 17.7% 19.8% 19.8% 32.36% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.6% -13.8% 25.6% -25.4% -16.0% 5.5% -7.4% 25.9% 32.0% 70.6% -10.2% 33.04% <-IRR #YR-> 5 5 Yr Running Average 316.86%
Median Values Diff 5, 10 yr -0.9% 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 $0.0 $138.2
-$58.8 $0.0 $0.0 $0.0 $0.0 $138.2
-$26.1 $0.0 $0.0 $0.0 $0.0 $0.0 $140.1
-$33.6 $0.0 $0.0 $0.0 $0.0 $140.1
Current Liability Coverage Ratio 0.35 0.37 0.50 0.34 0.48 0.63 1.80 1.29 2.48 2.20 1.62 2.19 0.80 CFO / Current Liabilities
5 year Median 0.22 0.35 0.35 0.35 0.37 0.48 0.50 0.63 1.29 1.80 1.80 2.19 2.19 2.19 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 11.58% 12.37% 13.67% 10.07% 11.04% 9.60% 16.69% 12.16% 14.98% 14.11% 14.32% 13.70% 7.63% CFO / Total Assets
5 year Median 8.38% 11.13% 11.58% 11.58% 11.58% 11.04% 11.04% 11.04% 12.16% 14.11% 14.32% 14.11% 14.11% 14.1% <-Median-> 5 Return on Assets
Return on Assets ROA 8.3% 9.8% 10.5% 7.0% 8.1% 6.6% 9.0% 7.6% 8.6% 8.1% 8.0% 7.8% 7.9% Net Income/Assets Return on Assets
5Yr Median 5.4% 7.4% 8.3% 8.3% 8.3% 8.1% 8.1% 7.6% 8.1% 8.1% 8.1% 8.0% 8.0% 8.0% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 17.8% 19.7% 20.2% 17.7% 16.7% 12.2% 16.8% 15.6% 16.2% 15.0% 15.5% 15.0% 13.3% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 10.5% 14.8% 17.8% 17.8% 17.8% 17.7% 16.8% 16.7% 16.2% 15.6% 15.6% 15.5% 15.0% 15.5% <-Median-> 5 Return on Equity
$135.30 <-12 mths -12.09%
Net Income $11.50 $20.85 $25.70 $28.55 $30.07 $34.40 $55.71 $73.07 $92.54 $103.85 $141.38 $153.90 $142 $164 $181 638.26% <-Total Growth 10 Net Income
Increase 57.79% 81.19% 23.29% 11.08% 5.33% 14.39% 61.97% 31.16% 26.64% 12.22% 36.14% 8.86% -7.73% 15.49% 10.37% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $5.4 $9.4 $13.8 $18.8 $23.3 $27.9 $34.9 $44.4 $57.2 $71.9 $93.3 $112.9 $126.7 $141.0 $156.5 22.13% <-IRR #YR-> 10 Net Income 638.26%
Operating Cash Flow $2.10 $10.23 $17.39 -$3.30 $40.48 $81.61 $32.79 $28.52 $104.22 $76.93 $5.60 $181.83 22.54% <-IRR #YR-> 5 Net Income 176.25%
Investment Cash Flow $23.83 -$50.36 -$23.53 -$49.04 -$4.26 -$89.38 -$37.66 -$178.06 -$81.24 -$85.17 -$99.61 -$175.60 28.19% <-IRR #YR-> 10 5 Yr Running Average 1098.58%
Total Accruals -$14.43 $60.98 $31.84 $80.88 -$6.15 $42.17 $60.57 $222.61 $69.56 $112.09 $235.38 $147.67 26.49% <-IRR #YR-> 5 5 Yr Running Average 223.77%
Total Assets $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,961.96 Balance Sheet Assets
Accruals Ratio -10.46% 28.54% 13.02% 19.85% -1.66% 8.08% 9.82% 23.29% 6.49% 8.71% 13.25% 7.53% 8.71% <-Median-> 5 Ratio
EPS/CF Ratio 0.74 0.82 0.75 0.69 0.73 0.72 0.54 0.67 0.57 0.57 0.55 0.57 0.62 <-Median-> 10 EPS/CF Ratio
-$20.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $153.9
-$55.7 $0.0 $0.0 $0.0 $0.0 $153.9
-$9.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $112.9
-$34.9 $0.0 $0.0 $0.0 $0.0 $112.9
Change in Close 129.51% 145.71% 19.19% -60.00% 57.01% 29.28% 21.66% 89.23% 42.22% 20.15% 60.38% -17.01% 14.00% 0.00% 0.00% Count 24 Years of data
up/down up down down down down down down down down down down Count 16 66.67%
Meet Prediction? yes yes yes % right Count 7 43.75%
Financial Cash Flow $21.64 $39.94 $6.14 $52.34 -$36.22 $7.78 $4.86 $163.54 -$33.78 $5.05 $98.30 -$9.48 C F Statement Financial Cash Flow
Total Accruals -$36.07 $21.03 $25.70 $28.55 $30.07 $34.40 $55.71 $59.07 $103.35 $107.04 $137.09 $157.15 Accruals
Accruals Ratio -26.16% 9.84% 10.51% 7.00% 8.11% 6.59% 9.03% 6.18% 9.64% 8.31% 7.72% 8.01% 8.01% <-Median-> 5 Ratio
Cash $0.00 $14.00 $3.19 $0.00 $4.29 $3.72 $15.57 Cash
Cash per Share $0.00 $0.20 $0.05 $0.00 $0.06 $0.05 $0.22 $0.05 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.00% 1.06% 0.17% 0.00% 0.12% 0.12% 0.45% 0.12% <-Median-> 5 % of Stock Price
Yes 0 Yes 0
Notes:
December 11, 2017. Last estimates were for 2016, 2017 and 2018 of $1893M, $1982M and $2040M for Revenue, $2.42, $2.57 and $2.77 for EPS, $1.42 and $276 for CFPS for 2016 and 2017, $168M, $176M and $192M for Net Income.
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.
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.
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.
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 Shares %, Val $M
Date Dec 21 2012 Dec 19 2013 Dec 14 2014 Dec 13 2015 Dec 12 2016 Dec 11 2017
McManus, Brian 0.03 0.05% 0.007 0.01% 0.007 0.01% 0.007 0.01% 0.007 0.01% 0.008 0.01%
CEO - Shares - Amount $0.617 $0.198 $0.240 $0.386 $0.323 $0.392
Options - percentage 0.20 0.29% 0.520 0.76% 1.840 2.67% 0.400 0.58% 0.000 0.00% 0.000 0.00%
Options - amount $3.832 $14.170 $60.242 $21.004 $0.000 $0.000
Vachon, Eric 0.00 0.00% 0.003 0.00% 0.005 0.01% 0.005 0.01% 0.004 0.01% 0.004 0.01%
CFO - Shares - Amount $0.056 $0.089 $0.169 $0.281 $0.170 $0.213
Options - percentage 0.02 0.03% 0.019 0.03% 0.009 0.01% 0.008 0.01% 0.006 0.01% 0.004 0.01%
Options - amount $0.390 $0.510 $0.310 $0.438 $0.282 $0.183
Eichenbaum, Marla 0.008 0.01% 0.004 0.01% 0.009 0.01% 0.010 0.01%
Officer - Shares - Amount $0.251 $0.231 $0.401 $0.480
Options - percentage 0.032 0.05% 0.017 0.03% 0.004 0.01% 0.002 0.00%
Options - amount $1.059 $0.913 $0.177 $0.114
Bunze, George J. 0.07 0.10% 0.071 0.10% 0.079 0.11% 0.079 0.11% 0.044 0.06% 0.044 0.06%
Director - Shares - Amount $1.341 $1.935 $2.570 $4.122 $1.896 $2.161
Options - percentage 0.03 0.04% 0.030 0.04% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.575 $0.818 $0.000 $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% 0.030 0.04%
Chairman - Shares - Amount $0.575 $0.818 $0.982 $1.575 $1.307 $1.490
Options - percentage 0.03 0.04% 0.030 0.04% 0.030 0.04% 0.030 0.04% 0.000 0.00% 0.000 0.00%
Options - amount $0.575 $0.818 $0.982 $1.575 $0.000 $0.000
Stella Jones International S.A. 26.57 38.70% 26.57 38.68% 26.573 38.54% 26.573 38.42%
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. $509.136 $724.110 $869.995 $1,395.340
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% 0.139 0.20% Yes 0 for 2013
due to SO $3.134 $0.000 $7.268 $8.664 $6.058
Book Value $0.837 $0.000 $1.758 $1.629 $1.635
Insider Buying -$0.036 -$0.090 -$0.133 -$0.098
Insider Selling $5.210 $4.734 $6.015 $0.649
Net Insider Selling $5.173 $4.644 $5.882 $0.551
% of Market Cap 0.23% 0.13% 0.19% 0.02%
Directors 9 9 9 9 9
Women 2 22% 2 22% 2 22% 2 22% 2 22%
Minorities 0 0% 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% 84 30.16%
Total Shares Held 6.132 35.72% 23.907 34.80% 28.271 41.00% 24.295 35.12% 21.786 31.44% 20.910 30.16%
Increase/Decrease -0.048 -0.78% 1.097 4.81% 1.701 6.40% -0.975 -3.86% -0.368 -1.66% -0.764 -3.52%
Starting No. of Shares 6.085 22.810 26.570 25.270 22.153 21.674
Copyright 2008 Website of SPBrunner. All rights reserved.