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/ Q2 2016
Superior Plus Corp TSX: SPB OTC: SUUIF www.superiorplus.com Fiscal Yr: Dec 31
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/30/16 12/30/17 12/30/18 Value Description #Y Item
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
$3,075 <-12 mths -7.22%
Revenue* $1,552.8 $2,059.2 $2,264.3 $2,350.5 $2,487.3 $2,246.7 $3,529.2 $3,926 $3,624 $3,753 $3,976 $3,315 $2,756 $2,450 $2,469 60.97% <-Total Growth 10 Revenue
Increase 25.80% 32.61% 9.96% 3.81% 5.82% -9.67% 57.08% 11.23% -7.68% 3.55% 5.94% -16.63% -16.85% -11.10% 0.78% 4.88% <-IRR #YR-> 10 Revenue
5 year Running Average $1,022 $1,300 $1,596 $1,892 $2,143 $2,282 $2,576 $2,908 $3,163 $3,416 $3,762 $3,719 $3,485 $3,250 $2,993 -1.25% <-IRR #YR-> 5 Revenue
Revenue per Share $20.46 $24.08 $26.48 $26.86 $28.17 $22.49 $32.77 $35.43 $32.13 $29.74 $31.50 $23.57 $19.60 $17.43 $17.56 11.08% <-IRR #YR-> 10 5 yr Running Average
Increase 15.03% 17.72% 9.96% 1.43% 4.86% -20.16% 45.71% 8.12% -9.31% -7.45% 5.94% -25.17% -16.85% -11.10% 0.78% 7.62% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $17.64 $19.53 $21.39 $23.13 $25.21 $25.62 $27.35 $29.14 $30.20 $30.51 $32.31 $30.48 $27.31 $24.37 $21.93 -0.21% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 1.29 1.10 0.65 0.51 0.41 0.52 0.39 0.25 0.25 0.39 0.42 0.52 -6.37% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 1.47 0.98 0.40 0.44 0.39 0.65 0.34 0.16 0.32 0.42 0.38 0.46 0.61 0.68 0.68 4.55% <-IRR #YR-> 10 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 0.42 5 yr 0.39 45.80% Diff M/C 2.18% <-IRR #YR-> 5 5 yr Running Average
-$2,059 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,315
-$3,529 $0 $0 $0 $0 $3,315
-$1,300 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,719
-$2,576 $0 $0 $0 $0 $3,719
-$24.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.57
-$32.77 $0.00 $0.00 $0.00 $0.00 $23.57
-$19.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $30.48
-$27.35 $0.00 $0.00 $0.00 $0.00 $30.48
$0.61 <-12 mths 205.00%
EPS Basic $1.53 $1.31 -$0.94 $1.38 $0.77 $0.75 -$0.45 -$2.77 $0.83 $0.43 $0.45 $0.20 -84.73% <-Total Growth 10 EPS Basic
EPS Diluted* $1.51 $1.30 -$0.94 $1.38 $0.77 $0.75 -$0.45 -$2.77 $0.83 $0.40 $0.41 $0.20 $0.70 $0.72 $0.79 -84.62% <-Total Growth 10 EPS Diluted
Increase -557.58% -13.91% -172% -247% -44.20% -2.60% -160.00% 515.56% -129.96% -51.81% 2.50% -51.22% 250.00% 2.86% 9.72% -17.07% <-IRR #YR-> 10 Earnings per Share -84.62%
Earnings Yield 5.0% 5.5% -8.8% 11.8% 7.0% 5.1% -4.1% -48.2% 8.1% 3.2% 3.4% 1.9% 5.9% 6.1% 6.6% #NUM! <-IRR #YR-> 5 Earnings per Share 144.44% 9.35%
5 year Running Average $0.75 $0.89 $0.57 $0.58 $0.80 $0.65 $0.30 -$0.06 -$0.17 -$0.25 -$0.32 -$0.19 $0.51 $0.49 $0.56 #NUM! <-IRR #YR-> 10 5 yr Running Average -120.95%
10 year Running Average $0.72 $0.56 $0.64 $0.65 $0.70 $0.60 $0.25 $0.21 $0.28 $0.17 $0.06 $0.22 $0.16 $0.16 #NUM! <-IRR #YR-> 5 5 yr Running Average -161.59%
* Diluted ESP per share E/P 10 Yrs 3.33% 5Yrs 3.24%
-$1.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.20
$0.45 $0.00 $0.00 $0.00 $0.00 $0.20
-$0.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.19
-$0.30 $0.00 $0.00 $0.00 $0.00 -$0.19
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
for 3 mths
Dividend* $2.46 $2.41 $1.82 $1.57 $1.62 $1.62 $1.62 $1.26 $0.60 $0.60 $0.61 $0.72 $0.72 $0.72 $0.72 -70.12% <-Total Growth 10 Dividends
Increase 7.72% -1.87% -24.48% -13.74% 3.18% 0.00% 0.00% -22.53% -52.19% 0.00% 1.67% 18.03% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Increase
Dividends 5 Yr Running $1.95 $2.16 $2.19 $2.11 $1.98 $1.81 $1.65 $1.54 $1.34 $1.14 $0.94 $0.76 $0.65 $0.67 $0.70 -64.97% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 9.32% 9.11% 10.65% 11.41% 14.12% 13.73% 12.83% 14.14% 7.34% 5.15% 4.56% 5.91% 7.01% 11.03% <-Median-> 10 Yield H/L Price
Yield on HighPrice 8.12% 7.33% 7.53% 9.81% 11.57% 11.06% 10.95% 10.13% 5.77% 4.59% 4.09% 4.87% 5.99% 8.67% <-Median-> 10 Yield on HighPrice
Yield on Low Price 10.94% 12.05% 18.20% 13.62% 18.10% 18.10% 15.49% 23.41% 10.07% 5.85% 5.15% 7.52% 8.45% 14.55% <-Median-> 10 Yield on Low Price
Yield on Close Price 8.18% 10.26% 16.99% 13.42% 14.81% 11.06% 14.65% 21.83% 5.86% 4.86% 5.09% 6.69% 6.06% 6.06% 6.06% 12.24% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 162.65% 185.38% -193.62% 113.77% 210.39% 216.00% -360.00% -45.31% 72.29% 150.00% 148.78% 360.00% 102.86% 100.00% 91.14% 131.27% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 262.04% 243.33% 387.07% 360.82% 245.67% 277.30% 546.36% -2401.56% -771.84% -459.27% -296.52% -406.99% 127.95% 138.68% 123.76% -25.42% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 111.22% 142.99% 102.58% 102.29% 68.90% 84.60% 1430.11% 65.59% 24.76% 40.86% 32.37% 38.73% 51.43% 49.66% 43.37% 67.25% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 129.91% 135.39% 141.11% 143.47% 103.37% 97.62% 107.30% 98.18% 77.05% 72.71% 60.05% 39.64% 35.97% 41.80% 42.29% 97.90% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 95.25% 101.61% 120.53% 81.29% 76.50% 97.73% 124.98% 53.26% 25.41% 30.29% 27.94% 40.17% 51.43% 49.66% 43.37% 64.88% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 116.13% 119.28% 127.04% 122.61% 93.97% 94.28% 96.91% 82.11% 68.60% 59.00% 46.03% 35.46% 33.45% 38.27% 41.13% 88.04% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 5.91% 5.86% 5 Yr Med Payout 148.78% 38.73% 30.29% -11.38% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. 2.40% 3.35% Last Div Inc ---> $0.050 $0.060 20.0% -14.97% <-IRR #YR-> 5 Dividends
6.27% <-IRR #YR-> 3 Dividends
-$2.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.72
-$1.62 $0.00 $0.00 $0.00 $0.00 $0.72
-$0.60 $0.00 $0.00 $0.72
Historical Dividends Historical High Div 18.19% Low Div 4.62% Ave Div 11.41% Med Div 10.35% Close Div 9.37% Historical Dividends
High/Ave/Median Values Curr diff Exp. -66.71% ††† 31.07% Exp. -46.90% Exp. -41.49% Exp. -35.39% High/Ave/Median
Future Div Yield Div Yd 8.14% earning in 10.00 Years at IRR of 3.00% Div Inc. 34.39% Future Div Yield
Future Div Yield Div Yd 9.43% earning in 15.00 Years at IRR of 3.00% Div Inc. 55.80% Future Div Yield
Cost cover if held 5 years 67.18% 82.79% 70.88% 57.50% 44.39% 34.32% 31.20% 44.97% 48.78% 49.63% 39.70% 29.98% 36.62% 41.22% 29.93% 44.68% <-Median-> 10 Paid Median Price
Cost cover if held 10 years 132.89% 145.01% 136.60% 129.31% 146.01% 120.60% 94.14% 69.98% 52.11% 45.52% 63.98% 73.27% 80.04% 124.95% <-Median-> 10 Paid Median Price
Cost cover if held 15 years 190.03% 198.09% 178.17% 161.51% 175.01% 141.63% 112.53% 85.67% 178.17% <-Median-> 5 Paid Median Price
Cost cover if held 20 years 214.19% 224.74% 203.64% #NUM! <-Median-> 0 Paid Median Price
H/LYield held 5 yrs 16.88% 18.47% 11.78% 8.57% 7.28% 6.15% 6.13% 7.34% 4.36% 5.23% 5.17% 5.70% 8.11% 8.81% 6.17% 6.14% <-Median-> 10 Paid Median Price
H/LYield held 10 yrs 13.53% 12.41% 11.82% 11.13% 12.41% 8.12% 3.27% 2.70% 2.32% 2.72% 4.21% 5.23% 6.27% 9.63% <-Median-> 10 Paid Median Price
H/LYield held 15 yrs 9.33% 4.74% 4.38% 4.19% 5.52% 4.66% 3.93% 3.24% 4.74% <-Median-> 5 Paid Median Price
H/LYield held 20 yrs 5.35% 5.69% 5.26% #NUM! <-Median-> 0 Paid Median Price
Graham No. $17.32 $16.84 $14.27 $14.79 $10.61 $9.94 $8.40 $7.68 $7.96 $6.21 $6.34 $4.78 $9.08 $9.21 $9.64 -71.62% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.52 1.57 1.20 0.93 1.08 1.19 1.50 1.16 1.03 1.88 2.11 2.55 1.13 1.19 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.75 1.95 1.69 1.08 1.32 1.47 1.76 1.61 1.30 2.11 2.35 3.09 1.32 1.65 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.30 1.19 0.70 0.78 0.84 0.90 1.25 0.70 0.75 1.65 1.87 2.00 0.94 0.87 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.73 1.40 0.75 0.79 1.03 1.47 1.32 0.75 1.29 1.99 1.89 2.25 1.31 1.29 1.23 1.30 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 73.36% 39.56% -24.97% -20.91% 3.07% 47.44% 31.70% -25.09% 28.61% 98.97% 89.03% 125.13% 30.98% 29.15% 23.30% 30.16% <-Median-> 10 Graham Price
Price Close $30.02 $23.50 $10.71 $11.70 $10.94 $14.65 $11.06 $5.75 $10.24 $12.35 $11.99 $10.76 $11.89 $11.89 $11.89 -54.21% <-Total Growth 10 Stock Price
Increase 16.99% -21.72% -54.43% 9.24% -6.50% 33.91% -24.51% -48.01% 78.09% 20.61% -2.91% -10.26% 10.50% 0.00% 0.00% -7.51% <-IRR #YR-> 10 Stock Price
P/E 19.88 18.08 -11.39 8.48 14.21 19.53 -24.58 -2.08 12.34 30.88 29.24 53.80 16.99 16.51 15.05 -0.55% <-IRR #YR-> 5 Stock Price
Trailing P/E -90.97 15.56 8.24 -12.45 7.93 19.03 14.75 -12.78 -3.70 14.88 29.98 26.24 59.45 16.99 16.51 -0.43% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.per yr 7.09% 7.04% % Tot Ret -1654.59% 108.45% Price Inc -2.91% P/E: 13.27 29.24 6.49% <-IRR #YR-> 5 Price & Dividend
-$23.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.76
-$11.06 $0.00 $0.00 $0.00 $0.00 $10.76
-$23.50 $1.82 $1.57 $1.62 $1.62 $1.62 $1.26 $0.60 $0.60 $0.61 $11.48
-$11.06 $1.26 $0.60 $0.60 $0.61 $11.48
Price H/L Median $26.34 $26.44 $17.09 $13.77 $11.48 $11.80 $12.63 $8.88 $8.18 $11.66 $13.38 $12.18 $10.27 -53.95% <-Total Growth 10 Stock Price
Increase 18.38% 0.38% -35.36% -19.46% -16.64% 2.83% 6.99% -29.70% -7.89% 42.63% 14.75% -9.01% -15.65% -7.46% <-IRR #YR-> 10 Stock Price
P/E 17.44 20.34 -18.18 9.97 14.90 15.73 -28.06 -3.20 9.85 29.15 32.63 60.88 14.67 -0.72% <-IRR #YR-> 5 Stock Price
Trailing P/E -79.82 17.51 13.15 -14.64 8.32 15.32 16.83 -19.72 -2.95 14.05 33.45 29.70 51.35 -1.20% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 35.31 29.77 30.19 23.57 14.27 18.10 41.80 -138.67 -46.98 -47.02 -42.34 -65.46 20.22 5.45% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 36.62 30.52 21.61 17.68 16.88 21.22 35.36 39.88 41.94 79.64 209.91 46.26 18.61 P/E Ratio Historical Median
Median 10, 5 Yrs D.per yr 6.26% 6.17% % Tot Ret -522.83% 113% Price Inc -7.89% P/E: 12.44 29.15 Count 20 Years of data
-$26.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.18
-$12.63 $0.00 $0.00 $0.00 $0.00 $12.18
-$26.44 $1.82 $1.57 $1.62 $1.62 $1.62 $1.26 $0.60 $0.60 $0.61 $12.90
-$12.63 $1.26 $0.60 $0.60 $0.61 $12.90
High Months Mar/Dec Jul Jan Jul Jan Dec Jan Feb Dec Apr Aug Apr Aug
Price High $30.23 $32.88 $24.18 $16.00 $14.00 $14.65 $14.79 $12.39 $10.39 $13.07 $14.92 $14.78 $12.02 -55.05% <-Total Growth 10 Stock Price
Increase 16.27% 8.77% -26.46% -33.83% -12.50% 4.64% 0.96% -16.23% -16.14% 25.79% 14.15% -0.94% -18.67% -7.68% <-IRR #YR-> 10 Stock Price
P/E 20.02 25.29 -25.72 11.59 18.18 19.53 -32.87 -4.47 12.52 32.68 36.39 73.90 17.17 -0.01% <-IRR #YR-> 5 Stock Price
Trailing P/E -91.61 21.77 18.60 -17.02 10.14 19.03 19.72 -27.53 -3.75 15.75 37.30 36.05 60.10 20.75 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -0.94% P/E: 15.35 32.68 31.55 P/E Ratio Historical High
-$32.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.78
-$14.79 $0.00 $0.00 $0.00 $0.00 $14.78
Low Months May Nov Nov Nov Oct Mar Nov Nov Jan Jan Nov Dec Feb
Price Low $22.45 $20.00 $10.00 $11.53 $8.95 $8.95 $10.46 $5.36 $5.96 $10.25 $11.84 $9.57 $8.52 -52.15% <-Total Growth 10 Stock Price
Increase 21.35% -10.91% -50.00% 15.30% -22.38% 0.00% 16.87% -48.76% 11.19% 71.98% 15.51% -19.17% -10.97% -7.11% <-IRR #YR-> 10 Stock Price
P/E 14.87 15.38 -10.64 8.36 11.62 11.93 -23.24 -1.94 7.18 25.63 28.88 47.85 12.17 -1.76% <-IRR #YR-> 5 Stock Price
Trailing P/E -68.03 13.25 7.69 -12.27 6.49 11.62 13.95 -11.91 -2.15 12.35 29.60 23.34 42.60 15.13 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 11.19% P/E: 9.99 25.63 -0.11 P/E Ratio Historical Low
-$20.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.57
Long Term Debt $933.30 $816.22 $816.50 Debt
Ratio to Market Cap 0.62 0.54 0.49 0.58 <-Median-> 2 % of Market C.
Goodwill & Intangibles $471.70 $186.10 $228.71 $212.70 $212.90 $217.30 $218.20 Intangibles Goodwill
Ratio to Market Cap 0.40 0.29 0.20 0.14 0.14 0.14 0.13 0.17 <-Median-> 6 % of Market C.
Market Cap $2,279 $2,009 $916 $1,024 $966 $1,464 $1,191 $637 $1,155 $1,559 $1,513 $1,513 $1,672 $1,672 $1,672 -24.71% <-Total Growth 10 Market Cap
Diluted 82.80 79.70 85.50 86.50 88.30 91.00 105.60 109.20 111.90 128.90 132.80 129.00 129.00 129.00 61.86% <-Total Growth 10 Diluted
Change 7.81% -3.74% 7.28% 1.17% 2.08% 3.06% 16.04% 3.41% 2.47% 15.19% 3.03% -2.86% 0.00% 0.00% 3.04% <-Median-> 10 Change
Average # of Sh in M 72.70 79.70 85.50 86.50 88.30 91.00 105.60 109.20 111.90 123.10 126.20 129.00 129.00 129.00 61.86% <-Total Growth 10 Average
Change 22.39% 9.63% 7.28% 1.17% 2.08% 3.06% 16.04% 3.41% 2.47% 10.01% 2.52% 2.22% 0.00% 0.00% 2.79% <-Median-> 10 Change
Difference 4.40% 7.28% 0.00% 1.16% 0.00% 9.78% 1.99% 1.47% 0.80% 2.52% 0.00% 8.99% 8.99% 8.99% 1.31% <-Median-> 10 Difference
conv $212.60 <-12 mths -18.67%
# of Share in Millions 75.90 85.50 85.50 87.50 88.30 99.90 107.70 110.80 112.80 126.20 126.20 140.60 140.60 140.60 140.60 5.10% <-IRR #YR-> 10 Shares
Increase 9.37% 12.65% 0.00% 2.34% 0.91% 13.14% 7.81% 2.88% 1.81% 11.88% 0.00% 11.41% 0.00% 0.00% 0.00% 5.48% <-IRR #YR-> 5 Shares
CF fr Op $M $167.6 $144.1 $151.7 $134.3 $207.6 $191.3 $12.2 $212.0 $273.3 $185.3 $237.8 $261.4 $196.8 $203.9 $233.4 81.40% <-Total Growth 10 Cash Flow
Increase 1610.20% -14.02% 5.27% -11.47% 54.58% -7.85% -93.62% 1638% 28.92% -32.20% 28.33% 9.92% -24.70% 3.57% 14.48% DRIP S. Issues SO, Deb Conv.
5 year Running Average $83.7 $101.2 $113.3 $121.5 $161.1 $165.8 $139.4 $151.5 $179.3 $174.8 $184.1 $234.0 $230.9 $217.0 $226.7 131.07% <-Total Growth 10 CF 5 Yr Running
CFPS $2.21 $1.69 $1.77 $1.53 $2.35 $1.91 $0.11 $1.91 $2.42 $1.47 $1.88 $1.86 $1.40 $1.45 $1.66 10.31% <-Total Growth 10 Cash Flow per Share
Increase 1464% -23.68% 5.27% -13.49% 53.18% -18.55% -94.08% 1589% 26.63% -39.40% 28.33% -1.33% -24.70% 3.57% 14.48% 6.14% <-IRR #YR-> 10 Cash Flow
5 year Running Average $1.50 $1.60 $1.55 $1.47 $1.91 $1.85 $1.54 $1.57 $1.74 $1.57 $1.56 $1.91 $1.81 $1.61 $1.65 84.58% <-IRR #YR-> 5 Cash Flow
P/CF on Med Price 11.93 15.69 9.63 8.97 4.88 6.16 111.45 4.64 3.37 7.94 7.10 6.55 7.34 0.99% <-IRR #YR-> 10 Cash Flow per Share
P/CF on Closing Price 13.59 13.94 6.04 7.62 4.65 7.65 97.64 3.01 4.23 8.41 6.36 5.79 8.49 8.20 7.16 75.00% <-IRR #YR-> 5 Cash Flow per Share
24.44% Diff M/C 1.81% <-IRR #YR-> 10 CFPS 5 yr Running
Excl.Working Capital CF $28.1 $58.7 -$22.6 $34.7 -$20.6 -$25.7 $127.4 $49.1 -$7.0 $64.7 $37.7 -$9.4 $0.0 $0.0 $0.0 4.43% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $195.7 $202.8 $129.1 $169.0 $187.0 $165.6 $139.6 $261.1 $266.3 $250.0 $275.5 $252.0 $196.8 $203.9 $233.4 24.26% <-Total Growth 10 Cash Flow less WC
Increase 1297.86% 3.63% -36.34% 30.91% 10.65% -11.44% -15.70% 87.03% 1.99% -6.12% 10.20% -8.53% -21.89% 3.57% 14.48% 2.20% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $94.4 $119.1 $127.1 $142.1 $176.7 $170.7 $158.1 $184.5 $203.9 $216.5 $238.5 $261.0 $248.1 $235.6 $232.3 12.54% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $2.58 $2.37 $1.51 $1.93 $2.12 $1.66 $1.30 $2.36 $2.36 $1.98 $2.18 $1.79 $1.40 $1.45 $1.66 8.16% <-IRR #YR-> 10 CF less WC 5 Yr Run
Increase 1178.15% -8.01% -36.34% 27.91% 9.65% -21.73% -21.81% 81.80% 0.18% -16.09% 10.20% -17.90% -21.89% 3.57% 14.48% 10.55% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $1.68 $1.81 $1.72 $1.72 $2.10 $1.92 $1.70 $1.87 $1.96 $1.93 $2.04 $2.13 $1.94 $1.76 $1.70 -2.76% <-IRR #YR-> 10 CFPS - Less WC
P/CF on Med Price 10.22 11.15 11.32 7.13 5.42 7.12 9.74 3.77 3.46 5.89 6.13 6.79 7.34 6.70% <-IRR #YR-> 5 CFPS - Less WC
P/CF on Closing Price 11.64 9.91 7.09 6.06 5.17 8.84 8.53 2.44 4.34 6.23 5.49 6.00 8.49 8.20 7.16 1.66% <-IRR #YR-> 10 CFPS 5 yr Running
Debt/CF 7.62 7.29 5.48 7.77 10.20 14.32 7.06 6.21 6.40 5.68 5.67 6.68 4.63% <-IRR #YR-> 5 CFPS 5 yr Running
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 6.82 5 yr 6.55 P/CF Med 10 yr 6.46 5 yr 5.89 31.45% Diff M/C
-$1.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.86 Cash Flow per Share
-$0.11 $0.00 $0.00 $0.00 $0.00 $1.86 Cash Flow per Share
-$1.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.91 CFPS 5 yr Running
-$1.54 $0.00 $0.00 $0.00 $0.00 $1.91 CFPS 5 yr Running
-$202.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $252.0 Cash Flow less WC
-$139.6 $0.0 $0.0 $0.0 $0.0 $252.0 Cash Flow less WC
-$119.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $261.0 CF less WC 5 Yr Run
-$158.1 $0.0 $0.0 $0.0 $0.0 $261.0 CF less WC 5 Yr Run
OPM 10.79% 7.00% 6.70% 5.71% 8.35% 8.51% 0.35% 5.40% 7.54% 4.94% 5.98% 7.89% 12.70% <-Total Growth 10 OPM
Increase 1259.42% -35.17% -4.26% -14.72% 46.08% 2.02% -95.94% 1462% 39.63% -34.52% 21.13% 31.86% Should increase or be stable.
Diff from Ave 70.23% 10.37% 5.67% -9.88% 31.64% 34.29% -94.55% -14.82% 18.93% -22.12% -5.67% 24.38% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 6.34% 5 Yrs 5.98% should be zero, it is a check on calculations
Current Assets $258.6 $549.4 $422.5 $433.1 $507.3 $565.0 $734.0 $715.2 $651.6 $743.4 $675.2 $613.9 $571.7 Liquidity ratio of 1.5 and up, best
Current Liabilities $177.7 $307.3 $272.3 $297.2 $395.3 $408.1 $455.0 $484.7 $485.8 $520.4 $525.7 $480.3 $394.9 1.41 <-Median-> 10 Ratio
Liquidity Ratio 1.46 1.79 1.55 1.46 1.28 1.38 1.61 1.48 1.34 1.43 1.28 1.28 1.45 1.34 <-Median-> 5 Ratio
Liq. with CF aft div 1.35 1.59 1.54 1.45 1.45 1.46 1.26 1.63 1.76 1.64 1.59 1.61 1.69 1.63 <-Median-> 5 Ratio
Liq. CF reInv+Div 0.75 1.08 1.01 1.35 1.06 0.71 0.85 1.47 1.62 1.41 1.37 1.35 1.69 1.41 <-Median-> 5 Ratio
Assets $1,549.0 $2,373.6 $1,536.9 $1,542.8 $2,026.9 $2,274.0 $2,449.6 $2,193.4 $2,036.3 $2,141.1 $2,114.9 $2,142.9 $2,050.6 Debt Ratio of 1.5 and up, best
Liabilities $879.1 $1,544.8 $941.3 $926.1 $1,452.7 $1,689.5 $1,999.5 $1,843.8 $1,653.4 $1,600.9 $1,564.5 $1,429.2 $1,315.0 1.35 <-Median-> 10 Ratio
Debt Ratio 1.76 1.54 1.63 1.67 1.40 1.35 1.23 1.19 1.23 1.34 1.35 1.50 1.56 1.34 <-Median-> 5 Ratio
Book Value $669.90 $828.80 $595.60 $616.70 $574.20 $584.50 $450.10 $349.6 $382.9 $540.2 $550.4 $713.7 $735.6 $735.6 $735.6 -13.89% <-Total Growth 10 Book Value
Book Value per share $8.83 $9.69 $6.97 $7.05 $6.50 $5.85 $4.18 $3.16 $3.39 $4.28 $4.36 $5.08 $5.23 $5.23 $5.23 -47.63% <-Total Growth 10 Book Value per Share
Change 0.27% 9.83% -28.14% 1.18% -7.74% -10.03% -28.57% -24.50% 7.58% 26.10% 1.89% 16.39% 3.07% 0.00% 0.00% -6.51% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 2.98 2.73 2.45 1.95 1.76 2.02 3.02 2.81 2.41 2.72 3.07 2.40 1.96 2.40 P/B Ratio Historical Median
P/B Ratio (Close) 3.40 2.42 1.54 1.66 1.68 2.50 2.65 1.82 3.02 2.89 2.75 2.12 2.27 2.27 2.27 -6.26% <-IRR #YR-> 10 Book Value per Share
Change 16.68% -28.72% -36.58% 7.97% 1.34% 48.83% 5.69% -31.14% 65.53% -4.36% -4.71% -22.90% 7.21% 3.97% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 2.31 2.86 2.58 2.50 3.53 3.89 5.44 6.27 5.32 3.96 3.84 3.00 2.79 3.87 <-Median-> 10 A/BV
Debt/Equity Ratio 1.31 1.86 1.58 1.50 2.53 2.89 4.44 5.27 4.32 2.96 2.84 2.00 1.79 2.87 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.43 5 yr Med 2.72 -6.51% Diff M/C 2.72 Historical 20 A/BV
-$9.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.08
-$4.18 $0.00 $0.00 $0.00 $0.00 $5.08
$109.80 <-12 mths -4.10%
Comprehensive Inc -$80.00 $117.50 $89.60 $72.20 -$62.80 -$303.80 $87.10 $98.70 $88.10 $114.50 243.13% <-Total Growth 9 Comprehensive Income
Increase 246.88% -23.74% -19.42% -186.98% -383.76% 128.67% 13.32% -10.74% 29.97% 13.3% <-Median-> 5 Comprehensive Income
ROE -13.4% 19.1% 15.6% 12.4% -14.0% -86.9% 22.7% 18.3% 16.0% 16.0% 16.0% <-Median-> 5 Comprehensive Income
5Yr Median 12.4% 12.4% 12.4% 12.4% 16.0% 16.0% #NUM! <-IRR #YR-> 9 Comprehensive Income 243.13%
% Difference from NI -1.0% -1.9% 32.3% 5.7% 33.6% 0.4% -6.4% 87.3% 54.8% 332.1% #NUM! <-IRR #YR-> 5 Comprehensive Income 282.32%
Median Values Diff 5, 10 yr 19.0% 54.8%
$80.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $114.5
$62.8 $0.0 $0.0 $0.0 $0.0 $114.5
Current Liability Coverage Ratio 1.10 0.66 0.47 0.57 0.47 0.41 0.31 0.54 0.55 0.48 0.52 0.52 0.50 CFO / Current Liabilities
5 year Median 0.31 0.62 0.47 0.57 0.57 0.47 0.47 0.47 0.47 0.48 0.52 0.52 0.52 0.52 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 12.63% 8.54% 8.40% 10.95% 9.23% 7.28% 5.70% 11.90% 13.08% 11.68% 13.03% 11.76% 9.60% CFO / Total Assets
5 year Median 9.35% 8.54% 8.40% 8.54% 9.23% 8.54% 8.40% 9.23% 9.23% 11.68% 11.90% 11.90% 11.76% 11.9% <-Median-> 5 Return on Assets
Return on Assets 7.2% 4.4% -5.3% 7.8% 3.3% 3.0% -1.9% -13.8% 4.6% 2.5% 2.7% 1.2% 2.0% Net Income/Assets ROA
5Yr Median 4.3% 4.4% 4.3% 4.4% 4.4% 3.3% 3.0% 3.0% 3.0% 2.5% 2.5% 2.5% 2.5% 2.5% <-Median-> 5 ROA
ROE 16.6% 12.6% -13.6% 19.4% 11.8% 11.7% -10.4% -86.6% 24.3% 9.8% 10.3% 3.7% 5.7% Net Inc/ Shareholders' equity ROE
5Yr Median 8.3% 12.6% 12.6% 12.6% 12.6% 11.8% 11.7% 11.7% 11.7% 9.8% 9.8% 9.8% 9.8% 9.8% <-Median-> 5 ROE
$93.00 <-12 mths 250.94%
Net Income $111.20 $104.40 -$80.80 $119.80 $67.70 $68.30 -$47.00 -$302.6 $93.1 $52.7 $56.9 $26.5 $42.0 $42.0 -74.62% <-Total Growth 10 Net Income
Increase -667.35% -6.12% -177.39% -248.27% -43.49% 0.89% -168.81% 543.83% -130.77% -43.39% 7.97% -53.43% 58.49% 0.00% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $43.3 $58.8 $35.2 $47.0 $64.5 $55.9 $25.6 -$18.8 -$24.1 -$27.1 -$29.4 -$14.7 $54.2 $44.0 -12.81% <-IRR #YR-> 10 Net Income -74.62%
Operating Cash Flow $167.60 $144.10 $151.70 $134.30 $207.60 $191.30 $12.20 $212.0 $273.3 $185.3 $237.8 $261.4 #NUM! <-IRR #YR-> 5 Net Income 156.38%
Investment Cash Flow -$142.10 -$142.10 -$142.10 -$20.80 -$143.50 -$423.90 -$215.70 -$49.8 -$44.8 -$83.8 -$85.3 -$94.5 #NUM! <-IRR #YR-> 10 5 Yr Running Ave. -124.97%
Total Accruals $85.70 $102.40 -$90.40 $6.30 $3.60 $300.90 $156.50 -$464.8 -$135.4 -$48.8 -$95.6 -$140.4 #NUM! <-IRR #YR-> 5 5 Yr Running Ave. -157.34%
Total Assets $1,549.0 $2,373.6 $1,536.9 $1,542.8 $2,026.9 $2,274.0 $2,449.6 $2,193.4 $2,036.3 $2,141.1 $2,114.9 $2,142.9 Balance Sheet Assets
Accruals Ratio 5.53% 4.31% -5.88% 0.41% 0.18% 13.23% 6.39% -21.19% -6.65% -2.28% -4.52% -6.55% -6.55% <-Median-> 5 Ratio
EPS/CF Ratio 0.59 0.55 -0.62 0.71 0.36 0.45 -0.35 -1.18 0.35 0.20 0.19 0.11 0.19 <-Median-> 10 EPS/CF Ratio
-$104.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $26.5
$47.0 $0.0 $0.0 $0.0 $0.0 $26.5
-$58.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$14.7
-$25.6 $0.0 $0.0 $0.0 $0.0 -$14.7
Change in Close 16.99% -21.72% -54.43% 9.24% -6.50% 33.91% -24.51% -48.01% 78.09% 20.61% -2.91% -10.26% 10.50% 0.00% 0.00% count 21 Change in Close
up/down down down up down down up up up count 13
Meet Prediction? yes yes yes yes yes yes % right count 9 69.23%
Financial Cash Flow -$25.50 $406.60 -$448.90 -$133.00 -$62.10 $240.80 $188.20 -$165.7 -$225.4 -$100.6 -$158.3 -$171.5 C F Statement Financial Cash Flow
Total Accruals $111.20 -$304.20 $358.50 $139.30 $65.70 $60.10 -$31.70 -$299.10 $90.00 $51.80 $62.70 $31.10 Accruals
Accruals Ratio -1.65% 17.13% -29.21% -8.62% -3.06% 10.59% 7.68% -7.55% -11.07% -4.70% -7.48% -8.00% -7.55% <-Median-> 5 Ratio
Cash year end $24.30 $8.90 $5.20 $7.60 $8.30 $3.10 $0.00 $8.90 Cash
Cash per Share $0.24 $0.08 $0.05 $0.07 $0.07 $0.02 $0.00 $0.06 $0.05 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.66% 0.75% 0.82% 0.66% 0.53% 0.20% 0.00% 0.53% 0.53% <-Median-> 5 % of Stock Price
Distri Inc
for 3 mths
Payout R Dis 97.8% 102.6% 96.8%
Div in Tax yr
Dividends $0.72
Cap Gain $0.00
Other Income $1.67
Ret of Cap. $0.07
Total $2.47
Div in Tax yr
Dividends 29.34% 14.84% 14.84% <-Average 1
Cap Gain 0.00% 0.00% 0.00% <-Average 1
Other Income 67.89% 70.40% 70.40% <-Average 1
Ret of Cap. 2.77% 14.77% 14.77% <-Average 1
Total 100.00%
For Tax Cr
August 26, 2016.Last estimates were for 2015, 2016 and 2017 of $3615M, $4000M and $3866M for Revenue, $0.58, $1.10 and $1.12 for EPS, $1.68, $2.02 and $2.28 for CFPS and $77M, $122M and $148.7M for Net Income.
August 21, 2015.Last estimates were for 2014, 2015 and 2016 of $3673M, $3517M and $3591M for Revenue, $0.95, $1.31 and $1.41 of EPS, $1.86, $2.06 and $2.18 of CFPS, $88M, $142M and $160.3M for Net Income.
August 17, 2014.Last estimates were for 2013, 2014 and 2015 of $3633M, $3668M and $3624M for Revenue,$0.99 and $1.05 for EPS (2013 and 2014), $1.72 and $1.87 for CFPS (2013 and 2014).
Feb 6, 2012.Last estimates were for 2010 and 2011 of $1.00 and $1.15 for EPS and $1.90 and $1.95 for CF.Brecause of new accting rules, Book Value is higher.
Under the new rules, Book Value in 3rd quarter would be lower than at the end of last year.
May 12, 2010.The increase in shares is to finance purchase of Griffith.
May 9, 2010.Last time I looked at got estimates for earnings for 2009 - 2011 of $1.40, $1.21, $1.42 and cash flow for 2009 and 2010 of $1.70 and $2.00.
From Jan 1, 2009, all distributions are considered dividends. Changed to a corporation called Superior Plus (TSX-SPB) from Unit trust (TSX-SPF.UN) in 2009. Company was started on Oct 8, 1996 as an income trust.
The Fund commenced operations on October 8, 1996.
Would I buy this company and Why.
Dividends
Dividends are paid monthly.Dividends are announced in one month and payable in the following month.
For example, the July dividend announced on July 10, 2014 is payable to shareholders of record of July 31, 2014 on August 15, 2014.
Why am I following this stock.
I started to follow this stock as it was an income trust company that was talked about in the Money Reporter from MPL Communications. This company changed to a corporation from Unit Trust (TSX-SPF.UN) in 2009.
How they make their money
Superior Plus Corp. is a group of diversified businesses that operate within three primary divisions.
Superiorís Energy Services division provides distribution, wholesale procurement and related services in relation to propane, heating oil and other refined fuels throughout Canada and the North Eastern
United States. Superiorís Specialty Chemicals division is a leading supplier of sodium chlorate and related technology to the pulp and paper sector and a regional Midwest supplier of chloralkali and potassium
based products. Superiorís Construction Products Distribution division is a leading distributor of walls, ceilings and insulation products to the Canadian and United States construction industry.
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 Feb 6 2012 Aug 23 2013 Aug 20 2014 Aug 21 2015 Aug 26 2016
Desjardins, Luc 0.264 0.21% 0.265 0.21% 0.278 0.20% 0.330 0.23% Used to be CFO, 2013
CEO - Shares - Amount $3.262 $3.176 $2.990 $3.918
Options - percentage 0.495 0.39% 0.323 0.26% 0.271 0.19% 0.318 0.23%
Options - amount $6.116 $3.872 $2.918 $3.781
Summers, Beth 0.002 0.00%
CFO - Shares - Amount $0.026
Options - percentage 0.040 0.03%
Options - amount $0.471
Bingham, Wayne Mitchell 0.199 0.16% 0.215 0.17% 0.266 0.19%
CFO - Shares - Amount $2.454 $2.575 $2.864
Options - percentage 0.129 0.10% 0.084 0.07% 0.093 0.07%
Options - amount $1.596 $1.009 $0.998
McCamus, Gregory Lorne 0.044 0.03% 0.044 0.03% 0.044 0.03%
Officer - Shares - Amount $0.523 $0.469 $0.518
Options - percentage 0.071 0.06% 0.088 0.06% 0.115 0.08%
Options - amount $0.848 $0.950 $1.372
Best, Catherine May 0.007 0.01% 0.007 0.00% 0.007 0.00%
Director - Shares - Amount $0.084 $0.075 $0.083
Options - percentage 0.017 0.01% 0.024 0.02% 0.033 0.02%
Options - amount $0.208 $0.254 $0.397
Green, Peter 0.039 0.03%
Director - Shares - Amount $402,637
Options - percentage 0.022 0.02%
Options - amount $225,126
Smith, David Paul 0.029 0.02% 0.068 0.05% used to be CEO, 2013
Chairman - Shares - Amt $0.316 $0.807 Also has convertible debentures
Options - percentage 0.030 0.02% 0.046 0.03%
Options - amount $0.326 $0.551
Billing, Grant Donald 1.500 1.19% 1.000 0.79% used to be CEO, 2013
Chairman - Shares - Amt $18.525 $11.990 Also has convertible debentures
Options - percentage 0.163 0.13% 0.188 0.15%
Options - amount $2.016 $2.250
Increase in O/S Shares 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Yes, 0
due to SO $0 $0.000 $0.000 $0.000
Book Value $0 $0.000 $0.000 $0.000
Insider Buying -$0.619 -$0.515
Insider Selling $0.000 $0.000
Net Insider Selling $6.618 -$0.619 -$0.515
% of Market Cap 0.44% -0.04% -0.03%
Directors 10 10 10 10
Women 1 10% 2 20% 2 20% 2 20%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 48 12.86% 67 27.37% 74 27.97%
Total Shares Held 7.439 6.59% 16.227 12.86% 24.906 19.74% 34.667 24.66% 39.821 28.32%
Increase/Decrease 0.375 4.80% 0.069 0.43% 1.001 4.19% 0.258 0.75% 0.294 0.74%
Starting No. of Shares 7.814 16.158 23.904 34.408 39.527
Copyright © 2008 Website of SPBrunner. All rights reserved.