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/
Rogers Sugar Inc. TSX: RSI OTC: RSGUF www.rogerssugar.com Fiscal Yr: Sep 30
Year 9/30/05 9/30/06 9/30/07 9/30/08 9/30/09 9/30/10 9/30/11 9/30/12 9/30/13 9/30/14 9/30/15 9/30/16 9/30/17 9/30/18 9/30/19 Value Description #Y Item
Accounting Rules C GAAP C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
Revenue* $441.3 $532.7 $485.9 $463.1 $543.3 $606.9 $612.6 $618.1 $558.4 $532.3 $541.5 $564.4 $670 $709 5.95% <-Total Growth 10 Revenue
Increase 3.07% 20.73% -8.79% -4.69% 17.32% 11.70% 0.95% 0.89% -9.65% -4.68% 1.74% 4.22% 18.71% 5.82% 0.58% <-IRR #YR-> 10 Revenue
5 year Running Average $357 $426 $461 $470 $493 $526 $542 $569 $588 $586 $573 $563 $573 $603 -1.63% <-IRR #YR-> 5 Revenue
Revenue per Share $4.97 $6.00 $5.55 $5.29 $6.22 $6.93 $6.90 $6.57 $5.93 $5.66 $5.76 $6.01 $7.14 $7.55 2.83% <-IRR #YR-> 10 5 yr Running
Increase 3.07% 20.71% -7.54% -4.66% 17.62% 11.43% -0.54% -4.73% -9.67% -4.59% 1.74% 4.42% 18.71% 5.82% 0.75% <-IRR #YR-> 5 5 yr Running
5 year Running Average $4.60 $4.90 $5.21 $5.33 $5.61 $6.00 $6.18 $6.38 $6.51 $6.40 $6.16 $5.99 $6.10 $6.43 0.02% <-IRR #YR-> 10 Revenue Per share
P/S (Price/Sales) Med 0.90 0.67 0.74 0.91 0.58 0.65 0.76 0.89 1.03 0.89 0.77 0.89 -2.70% <-IRR #YR-> 5 Revenue Per share
P/S (Price/Sales) Close 0.80 0.73 0.84 0.76 0.67 0.70 0.74 0.99 0.97 0.83 0.71 1.11 0.95 0.89 2.02% <-IRR #YR-> 10 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 0.83 5 yr 0.89 14.30% Diff M/C -0.62% <-IRR #YR-> 5 5 yr Running Average
-$532.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $564.4
-$612.6 $0.0 $0.0 $0.0 $0.0 $564.4
-$426 $0 $0 $0 $0 $0 $0 $0 $0 $0 $563
-$542 $0 $0 $0 $0 $563
-$6.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.01
-$6.90 $0.00 $0.00 $0.00 $0.00 $6.01
-$4.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.99
-$6.18 $0.00 $0.00 $0.00 $0.00 $5.99
EPS Basic -$0.72 $0.43 $0.51 $0.55 $0.49 $0.52 $0.50 $0.33 $0.40 $0.31 $0.26 $0.70 62.79% <-Total Growth 10 EPS Basic
EPS Diluted* -$0.72 $0.41 $0.47 $0.50 $0.45 $0.48 $0.45 $0.32 $0.39 $0.31 $0.26 $0.64 $0.45 $0.57 56.10% <-Total Growth 10 EPS Diluted
Increase -276% -157% 14.63% 6.38% -10.00% 6.67% -6.25% -28.89% 21.88% -20.51% -16.13% 146.15% -29.69% 26.67% 4.55% <-IRR #YR-> 10 Earnings per Share 56.10%
Earnings Yield -18.0% 9.3% 10.1% 12.4% 10.9% 9.9% 8.8% 4.9% 6.8% 6.6% 6.4% 9.6% 6.7% 8.4% 7.30% <-IRR #YR-> 5 Earnings per Share 42.22%
5 year Running Average $0.06 $0.15 $0.15 $0.21 $0.22 $0.46 $0.47 $0.44 $0.42 $0.39 $0.35 $0.38 $0.41 $0.45 9.71% <-IRR #YR-> 10 5 yr Running Average 152.63%
10 year Running Average $0.20 $0.21 $0.24 $0.26 $0.31 $0.30 $0.32 $0.31 $0.40 $0.43 $0.43 $0.43 -3.96% <-IRR #YR-> 5 5 yr Running Average -18.30%
* Diluted ESP per share E/P 10 Yrs 9.20% 5Yrs 6.60%
-$0.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.64
-$0.45 $0.00 $0.00 $0.00 $0.00 $0.64
-$0.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.38
-$0.47 $0.00 $0.00 $0.00 $0.00 $0.38
Special Dividend $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Dividend* $0.40 $0.40 $0.43 $0.46 $0.46 $0.46 $0.32 $0.35 $0.36 $0.36 $0.36 $0.36 $0.36 $0.36 $0.36 -10.54% <-Total Growth 10 Dividends
Increase -17.77% 0.40% 6.06% 6.62% 1.07% 0.00% -29.71% 6.71% 4.35% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Count 19 Years of data
Dividends 5 Yr Running $0.47 $0.44 $0.44 $0.43 $0.43 $0.44 $0.43 $0.41 $0.46 $0.44 $0.42 $0.43 $0.43 $0.36 $0.36 -1.86% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 9.01% 10.01% 10.41% 9.47% 12.69% 10.18% 6.18% 5.93% 5.91% 7.16% 8.13% 6.70% 5.63% 7.65% <-Median-> 10 Dividends
Yield on High Price 7.91% 8.88% 9.12% 8.16% 10.55% 9.22% 5.69% 5.17% 5.51% 6.27% 7.39% 5.37% 5.29% 6.83% <-Median-> 10 Dividends
Yield on Low Price 10.46% 11.46% 12.13% 11.29% 15.92% 11.36% 6.76% 6.96% 6.37% 8.35% 9.02% 8.91% 6.02% 8.97% <-Median-> 10 Dividends
Yield on Close Price 10.02% 9.17% 9.18% 11.29% 11.11% 9.44% 6.34% 5.31% 6.24% 7.66% 8.85% 5.39% 5.33% 5.33% 5.33% 8.25% <-Median-> 10 Dividends
Payout Ratio EPS -55.67% 98.15% 90.81% 91.01% 102.21% 95.83% 71.85% 107.81% 184.62% 116.13% 138.46% 56.25% 80.00% 63.16% #DIV/0! 99.02% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 738.50% 287.58% 285.38% 203.03% 193.25% 95.42% 90.43% 92.88% 110.44% 113.25% 121.87% 111.72% 105.37% 80.72% #DIV/0! 112.48% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 100.26% 115.88% 42.19% 173.21% 57.55% 48.39% 127.58% 67.92% 179.97% 89.90% 61.01% 50.68% 48.00% 44.44% #DIV/0! 64.46% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 87.25% 88.28% 69.55% 73.30% 76.05% 65.38% 64.84% 73.66% 79.29% 87.89% 97.97% 82.22% 75.76% 55.20% #DIV/0! 74.86% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 67.43% 66.75% 58.46% 72.88% 54.91% 64.04% 57.60% 55.01% 106.55% 54.50% 53.11% 30.11% 48.00% 44.44% #DIV/0! 56.30% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 88.41% 78.46% 70.41% 67.61% 63.29% 62.74% 61.21% 60.65% 67.49% 68.10% 65.83% 55.91% 54.55% 43.97% #DIV/0! 64.56% <-Median-> 10 DPR CF WC 5 Yr Running
Median 5 Yrs 5 Yr Med 5 Yr Cl 6.70% 6.24% 5 Yr Med Payout 116.13% 67.92% 54.50% -1.11% <-IRR #YR-> 10 Dividends
* Dividends Declared per share 5 Yr Med and Cur. -20.44% -14.52% Last Div Inc ---> $0.90 $0.90 0.0% 2.17% <-IRR #YR-> 5 Dividends
-$0.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.36
-$0.32 $0.00 $0.00 $0.00 $0.00 $0.36
Historical Dividends Historical High Div 15.95% Low Div 5.35% Ave Div 10.65% Med Div 9.74% Close Div 9.31% Historical Dividends
High/Ave/Median Values Curr diff Exp. -66.56% Exp -0.31% Exp. -49.92% Exp. -45.24% Exp. -42.72% High/Ave/Median
Div Yd 6.99% earning in 4 Years at IRR of 7.0% Div Inc. 31.08% Future Dividend Yield
Future Dividend Yield Div Yd 10.49% earning in 10 Years at IRR of 7.0% Div Inc. 96.72% Future Dividend Yield
Future Dividend Yield Div Yd 14.71% earning in 15 Years at IRR of 7.0% Div Inc. 175.90% Future Dividend Yield
Yield if held 5 yrs 6.98% 9.09% 9.43% 10.39% 12.23% 10.34% 8.04% 8.41% 7.49% 9.93% 7.96% 6.88% 6.19% 5.91% 7.16% 8.92% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 6.07% 8.01% 7.31% 7.62% 8.22% 9.57% 8.09% 8.96% 8.78% 7.49% 9.93% 8.05% <-Median-> 8 Paid Median Price
Yield if held 15 yrs 4.75% 6.27% 8.14% 7.96% 8.22% 9.57% 6.27% <-Median-> 3 Paid Median Price
Yield if held 20 yrs 4.75% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 41.13% 49.39% 48.56% 49.60% 57.05% 49.53% 52.86% 49.84% 48.04% 60.92% 46.64% 41.01% 37.15% 29.56% 35.82% 49.57% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 64.59% 79.50% 97.42% 93.72% 102.30% 115.78% 96.91% 106.22% 102.52% 85.50% 110.57% 97.16% <-Median-> 8 Paid Median Price
Cost covered if held 15 years 93.74% 116.20% 145.89% 141.45% 143.40% 163.65% 116.20% <-Median-> 3 Paid Median Price
Cost covered if held 20 years 117.50% #NUM! <-Median-> 0 Paid Median Price
Graham No. $5.13 $5.13 $5.56 $5.82 $5.56 $5.80 $5.76 $4.60 $4.86 $4.30 $3.86 $6.37 $5.34 $6.01 $0.00 24.25% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.87 0.78 0.74 0.83 0.65 0.78 0.91 1.26 1.25 1.17 1.15 0.84 1.20 0.88 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Hi 0.99 0.88 0.84 0.96 0.78 0.86 0.99 1.45 1.34 1.34 1.26 1.05 1.28 1.02 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.75 0.68 0.63 0.69 0.52 0.70 0.83 1.08 1.16 1.00 1.04 0.63 1.12 0.76 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 0.78 0.86 0.84 0.69 0.74 0.84 0.89 1.41 1.19 1.09 1.06 1.05 1.26 1.12 #DIV/0! 0.97 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -22.06% -14.36% -16.31% -30.72% -25.58% -16.06% -11.43% 41.40% 18.64% 9.38% 5.58% 4.88% 26.39% 12.30% #DIV/0! -3.27% <-Median-> 10 Graham Price
Month Year Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19
Price Close Dec $3.70 $3.68 $4.70 $3.80 $4.87 $5.34 $5.26 $5.99 $5.39 $4.75 $4.24 $6.81 $6.75 $6.75 $6.75 85.05% <-Total Growth 10 Stock Price
Increase -17.78% -0.54% 27.72% -19.15% 28.16% 9.65% -1.50% 13.88% -10.02% -11.87% -10.74% 60.61% -0.88% 0.00% 0.00% 6.35% <-IRR #YR-> 10 Stock Price
P/E -5.14 8.98 10.00 7.60 10.82 11.13 11.69 18.72 13.82 15.32 16.31 10.64 15.00 11.84 #DIV/0! 5.30% <-IRR #YR-> 5 Stock Price
Trailing P/E 9.02 -5.11 11.46 8.09 9.74 11.87 10.96 13.31 16.84 12.18 13.68 26.19 10.55 15.00 11.84 15.79% <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs D. per yr 9.44% 7.55% % Tot Ret 59.79% 58.76% Price Inc -10.02% P/E: 11.41 15.32 12.86% <-IRR #YR-> 5 Price & Div
-$3.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.81
-$5.26 $0.00 $0.00 $0.00 $0.00 $6.81
-$3.68 $0.43 $0.46 $0.46 $0.46 $0.32 $0.35 $0.72 $0.36 $0.36 $7.17
-$5.26 $0.35 $0.72 $0.36 $0.36 $7.17
Month Year Sep-05 Sep-06 Sep-07 Sep-08 Sep-09 Sep-10 Sep-11 Sep-12 Sep-13 Sep-14 Sep-15 Sep-16 Sep-17 Sep-18 Sep-19
Price Close Sept $4.00 $4.39 $4.65 $4.03 $4.14 $4.87 $5.10 $6.50 $5.77 $4.70 $4.07 $6.68 $6.75 $6.75 $6.75 52.16% <-Total Growth 10 Stock Price
Increase 1.78% 9.75% 5.92% -13.33% 2.73% 17.63% 4.72% 27.45% -11.23% -18.54% -13.40% 64.13% 1.05% 0.00% 0.00% 4.29% <-IRR #YR-> 10 Stock Price
P/E -5.56 10.71 9.89 8.06 9.20 10.15 11.33 20.31 14.79 15.16 15.65 10.44 15.00 11.84 #DIV/0! 5.55% <-IRR #YR-> 5 Stock Price
Trailing P/E 9.76 -6.10 11.34 8.57 8.28 10.82 10.63 14.44 18.03 12.05 13.13 25.69 10.55 15.00 11.84 12.71% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 8.42% 7.76% % Tot Ret 66.26% 58.34% Price Inc -11.23% P/E: 10.89 15.16 13.31% <-IRR #YR-> 5 Price & Dividend
-$4.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.68
-$5.10 $0.00 $0.00 $0.00 $0.00 $6.68
-$4.39 $0.43 $0.46 $0.46 $0.46 $0.32 $0.35 $0.72 $0.36 $0.36 $7.04
-$5.10 $0.35 $0.72 $0.36 $0.36 $7.04
Price H/L Median $4.45 $4.02 $4.10 $4.81 $3.63 $4.52 $5.23 $5.82 $6.09 $5.03 $4.43 $5.37 $6.40 33.58% <-Total Growth 10 Stock Price
Increase 18.35% -9.66% 1.99% 17.20% -24.56% 24.69% 15.71% 11.19% 4.73% -17.49% -11.84% 21.22% 19.09% 2.94% <-IRR #YR-> 10 Stock Price
P/E -6.18 9.80 8.72 9.61 8.06 9.42 11.62 18.17 15.62 16.21 17.04 8.39 14.21 0.53% <-IRR #YR-> 5 Stock Price
Trailing P/E 10.85 -5.58 10.00 10.22 7.25 10.04 10.90 12.92 19.03 12.88 14.29 20.65 9.99 12.36% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 69.53 26.45 26.62 22.45 16.33 9.78 11.13 13.22 14.57 12.88 12.80 13.98 15.60 8.14% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 20.40 22.77 14.98 17.19 16.82 19.58 19.27 16.42 10.97 12.58 15.05 9.82 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 9.42% 7.61% % Tot Ret 76.22% 93.49% Price Inc 4.73% P/E: 10.62 16.21 Count 18 Years of data
-$4.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.37
-$5.23 $0.00 $0.00 $0.00 $0.00 $5.37
-$4.02 $0.43 $0.46 $0.46 $0.46 $0.32 $0.35 $0.72 $0.36 $0.36 $5.54
-$5.23 $0.35 $0.72 $0.36 $0.36 $5.54
High Months Feb 05 Mar 06 Sep 07 Mar 08 Jan 09 Jan 10 Feb 11 Sep12 Mar 13 Oct 13 Nov 14 Sep 16 Dec 16
Price High $5.07 $4.53 $4.68 $5.58 $4.36 $4.99 $5.68 $6.67 $6.53 $5.74 $4.87 $6.70 $6.81 47.90% <-Total Growth 10 Stock Price
Increase 17.63% -10.65% 3.31% 19.23% -21.86% 14.45% 13.83% 17.43% -2.10% -12.10% -15.16% 37.58% 1.64% 3.99% <-IRR #YR-> 10 Stock Price
P/E -7.04 11.05 9.96 11.16 9.69 10.40 12.62 20.84 16.74 18.52 18.73 10.47 15.13 3.36% <-IRR #YR-> 5 Stock Price
Trailing P/E 12.37 -6.29 11.41 11.87 8.72 11.09 11.83 14.82 20.41 14.72 15.71 25.77 10.64 11.10 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -2.10% P/E: 11.89 18.52 21.60 P/E Ratio Historical High
-$4.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.70
-$5.68 $0.00 $0.00 $0.00 $0.00 $6.70
Low Months Oct 04 Oct 05 Nov 06 Sep 08 Mar 09 Nov 09 Aug 11 Oct 11 Aug 13 Feb 14 Sep 15 Jan 16 Nov 16
Price Low $3.83 $3.51 $3.52 $4.03 $2.89 $4.05 $4.78 $4.96 $5.65 $4.31 $3.99 $4.04 $5.98 15.10% <-Total Growth 10 Stock Price
Increase 19.31% -8.36% 0.28% 14.49% -28.29% 40.14% 18.02% 3.77% 13.91% -23.72% -7.42% 1.25% 48.02% 1.42% <-IRR #YR-> 10 Stock Price
P/E -5.32 8.56 7.49 8.06 6.42 8.44 10.62 15.50 14.49 13.90 15.35 6.31 13.29 -3.31% <-IRR #YR-> 5 Stock Price
Trailing P/E 9.34 -4.88 8.59 8.57 5.78 9.00 9.96 11.02 17.66 11.05 12.87 15.54 9.34 8.79 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 1.25% P/E: 9.53 14.49 6.40 P/E Ratio Historical Low
-$3.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.04
Long Term Debt $70.00 $60.00 Debt
Debt/Market Cap Ratio 0.18 0.10 0.14 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $230.0 $230.0 $230.0 $232.1 $231.9 $231.7 $231.8 Intangibles Goodwill
Intangible/Market Cap Ratio 0.54 0.51 0.38 0.43 0.52 0.61 0.37 0.51 <-Median-> 7 Intangible/Market Cap Ratio
Market Cap $355.1 $389.8 $407.3 $352.8 $361.5 $426.3 $453.1 $611.6 $543.0 $441.9 $382.7 $626.9 $633.5 $633.5 $633.5 60.84% <-Total Growth 10 Market Cap
Diluted # of Sh in Million 88.780 107.762 114.239 113.797 113.381 114.644 111.595 100.658 110.128 101.752 94.045 93.886 -12.88% <-Total Growth 10 Diluted
Change 21.38% 6.01% -0.39% -0.37% 1.11% -2.66% -9.80% 9.41% -7.61% -7.57% -0.17% -0.38% <-Median-> 10 Change
Average # of Sh in M 88.78 88.79 83.14 87.77 87.43 87.364 88.291 92.970 97.103 94.060 94.045 93.886 93.886 5.74% <-Total Growth 10 Average
Increase 0.00% 0.01% -6.36% 5.57% -0.39% -0.08% 1.06% 5.30% 4.45% -3.13% -0.02% -0.17% -0.05% <-Median-> 10 Change
Difference 0.0% 0.0% 5.3% -0.2% -0.1% 0.2% 0.6% 1.2% -3.1% 0.0% 0.0% 0.0% -0.03% <-Median-> 10 Difference
# of Share in M 88.780 88.788 87.583 87.553 87.328 87.534 88.842 94.091 94.114 94.029 94.029 93.850 93.850 93.850 93.850 0.56% <-IRR #YR-> 10 Shares
Increase 0.00% 0.01% -1.36% -0.03% -0.26% 0.24% 1.49% 5.91% 0.02% -0.09% 0.00% -0.19% 0.00% 0.00% 0.00% 1.10% <-IRR #YR-> 5 Shares
CF fr Op $Millon $35.5 $30.8 $88.6 $23.0 $69.8 $83.2 $22.5 $47.8 $37.7 $37.7 $55.5 $66.7 $70.4 $76.0 116.24% <-Total Growth 10 Cash Flow
Increase -57.58% -13.12% 187.38% -74.04% 203.41% 19.22% -72.94% 112.27% -21.22% 0.00% 47.36% 20.16% 5.57% 8.00% SO Conv of Deb. Buy Backs
5 year Running Average $41.8 $43.2 $55.9 $52.3 $49.5 $59.1 $57.4 $49.3 $52.2 $45.8 $40.2 $49.1 $53.6 $61.2 13.57% <-Total Growth 10 CF 5 Yr Running
CFPS $0.40 $0.35 $1.01 $0.26 $0.80 $0.95 $0.25 $0.51 $0.40 $0.40 $0.59 $0.71 $0.75 $0.81 104.57% <-Total Growth 10 Cash Flow per Share
Increase -57.58% -13.13% 191.33% -74.03% 204.19% 18.94% -73.34% 100.43% -21.24% 0.09% 47.36% 20.39% 5.57% 8.00% 8.02% <-IRR #YR-> 10 Cash Flow
5 year Running Average $0.54 $0.50 $0.63 $0.59 $0.56 $0.67 $0.66 $0.55 $0.58 $0.50 $0.43 $0.52 $0.57 $0.65 24.25% <-IRR #YR-> 5 Cash Flow
P/CF on Med Price 11.13 11.58 4.05 18.29 4.54 4.76 20.64 11.45 15.22 12.55 7.51 7.56 8.53 0.00 7.42% <-IRR #YR-> 10 Cash Flow per Share
P/CF on Closing Price 10.01 12.64 4.60 15.34 5.18 5.12 20.12 12.80 14.42 11.74 6.90 9.40 9.00 8.33 22.89% <-IRR #YR-> 5 Cash Flow per Share
82.10% Diff M/C 0.53% <-IRR #YR-> 10 CFPS 5 yr Running
Excl.Working Capital CF $17.3 $22.7 -$24.7 $31.7 $3.4 -$20.3 $27.4 $11.2 $25.9 $24.5 $8.3 $45.5 $0.0 $0.0 -4.46% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $52.8 $53.5 $63.9 $54.7 $73.2 $62.9 $49.9 $59.0 $63.6 $62.1 $63.7 $112.2 $70.4 $76.0 109.61% <-Total Growth 10 Cash Flow less WC
Increase -10.15% 1.44% 19.45% -14.49% 33.80% -14.06% -20.67% 18.32% 7.77% -2.34% 2.62% 76.04% -37.26% 8.00% 7.68% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $41.9 $48.5 $55.2 $56.7 $59.6 $61.6 $60.9 $59.9 $61.7 $59.5 $59.7 $72.1 $74.4 $76.9 17.60% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $0.59 $0.60 $0.73 $0.62 $0.84 $0.72 $0.56 $0.63 $0.68 $0.66 $0.68 $1.20 $0.75 $0.81 4.04% <-IRR #YR-> 10 CF less WC 5 Yr Run
Increase -10.15% 1.43% 21.09% -14.46% 34.15% -14.26% -21.84% 11.72% 7.74% -2.25% 2.62% 76.37% -37.26% 8.00% 3.44% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $0.53 $0.56 $0.62 $0.64 $0.68 $0.70 $0.69 $0.67 $0.68 $0.65 $0.64 $0.77 $0.79 $0.82 7.09% <-IRR #YR-> 10 CFPS - Less WC
P/CF on Med Price 7.49 6.67 5.62 7.69 4.33 6.29 9.32 9.27 9.01 7.61 6.54 4.49 8.53 0.00 16.32% <-IRR #YR-> 5 CFPS - Less WC
P/CF on Closing Price 6.73 7.28 6.37 6.45 4.94 6.78 9.08 10.36 8.54 7.12 6.00 5.59 9.00 8.33 3.25% <-IRR #YR-> 10 CFPS 5 yr Running
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 9.50 5 yr 11.45 P/CF Med 10 yr 7.07 5 yr 7.61 27.27% Diff M/C 2.02% <-IRR #YR-> 5 CFPS 5 yr Running
-$0.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.71 Cash Flow per Share
-$0.25 $0.00 $0.00 $0.00 $0.00 $0.71 Cash Flow per Share
-$0.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.52 CFPS 5 yr Running
-$0.66 $0.00 $0.00 $0.00 $0.00 $0.52 CFPS 5 yr Running
-$53.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $112.2 Cash Flow less WC
-$49.9 $0.0 $0.0 $0.0 $0.0 $112.2 Cash Flow less WC
-$48.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $72.1 CF less WC 5 Yr Run
-$60.9 $0.0 $0.0 $0.0 $0.0 $72.1 CF less WC 5 Yr Run
-$0.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20 CFPS - Less WC
-$0.56 $0.00 $0.00 $0.00 $0.00 $1.20 CFPS - Less WC
-$0.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.77 5 yr Running Average
-$0.69 $0.00 $0.00 $0.00 $0.00 $0.77 5 yr Running Average
OPM 8.04% 5.79% 18.24% 4.97% 12.85% 13.71% 3.68% 7.73% 6.74% 7.07% 10.25% 11.81% -35.22% <-Total Growth 10 OPM
Increase -58.85% -28.04% 215.08% -72.76% 158.62% 6.73% -73.19% 110.39% -12.80% 4.91% 44.84% 15.29% should be zero, it is a check on calculations
Diff from Median -10.5% -35.6% 102.9% -44.7% 42.9% 52.5% -59.1% -14.0% -25.0% -21.3% 14.0% 31.4% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 8.99% 5 Yrs 7.73% Should increase or be stable.
Current Assets $130.20 $142.91 $148.14 $134.30 $137.35 $151.31 $181.06 $159.70 $128.54 $143.17 $125.19 $154.28 Liquidity ratio of 1.5 and up, best
Current Liabilities $51.95 $62.47 $159.91 $135.01 $118.50 $121.79 $137.43 $118.97 $68.82 $88.76 $81.68 $104.96 1.33 <-Median-> 10 Ratio
Liquidity 2.51 2.29 0.93 0.99 1.16 1.24 1.32 1.34 1.87 1.61 1.53 1.47 1.53 <-Median-> 5 Ratio
Liq. with CF aft div 2.50 2.21 1.25 0.87 1.41 1.59 1.27 1.47 1.43 1.66 1.80 1.78 1.66 <-Median-> 5 Ratio
Liq. CF re Inv+Div 2.19 1.93 1.19 0.83 1.34 1.50 1.20 1.37 1.26 1.46 1.58 1.56 1.46 <-Median-> 5 Ratio
Assets $568.07 $585.46 $592.10 $577.11 $574.37 $584.81 $613.24 $594.07 $553.60 $568.33 $551.93 $585.20 Debt Ratio of 1.5 and up, best
Liabilities $245.37 $332.57 $336.41 $313.76 $307.44 $312.00 $322.33 $316.72 $298.73 $318.25 $311.87 $319.65 1.85 <-Median-> 10 Ratio
Debt Ratio 2.32 1.76 1.76 1.84 1.87 1.87 1.90 1.88 1.85 1.79 1.77 1.83 1.83 <-Median-> 5 Ratio
Total Book Value $322.70 $252.88 $255.69 $263.35 $266.93 $272.81 $290.91 $277.35 $254.87 $250.08 $240.06 $265.55
Equity of Conv. Deb $69.21 $1.19 $1.19 $1.19 $1.19 $1.19
Book Value $253.49 $252.88 $255.69 $263.35 $266.93 $272.81 $290.91 $276.16 $253.69 $248.89 $238.87 $264.37 $264.37 $264.37 $264.37 4.54% <-Total Growth 10 Book Value
BV per share $2.86 $2.85 $2.92 $3.01 $3.06 $3.12 $3.27 $2.94 $2.70 $2.65 $2.54 $2.82 $2.82 $2.82 $2.82 -1.10% <-Total Growth 10 Book Value
Change -28.13% -0.25% 2.50% 3.03% 1.62% 1.96% 5.06% -10.37% -8.16% -1.80% -4.03% 10.88% 0.00% 0.00% 0.00% 43.43% Current/Historical Book Value
P/BV Median 1.56 1.41 1.40 1.60 1.19 1.45 1.60 1.98 2.26 1.90 1.74 1.91 1.45 P/BV Ratio Historical Median
P/BV Close 1.40 1.54 1.59 1.34 1.35 1.56 1.56 2.21 2.14 1.78 1.60 2.37 2.40 2.40 2.40 -0.11% <-IRR #YR-> 10 Book Value
Change 42% 10.02% 3.34% -15.88% 1.09% 15.37% -0.33% 42.19% -3.34% -17.05% -9.77% 48.02% 1.05% 0.00% 0.00% -2.97% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 1.76 2.32 2.32 2.19 2.15 2.14 2.11 2.14 2.17 2.27 2.30 2.20 2.18 <-Median-> 10 A/BV
Debt/Equity Ratio 0.97 1.32 1.32 1.19 1.15 1.14 1.11 1.15 1.18 1.28 1.31 1.21 1.18 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.67 5 yr Med 1.91 43.43% Diff M/C
-$2.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.82
-$3.27 $0.00 $0.00 $0.00 $0.00 $2.82
Comprehensive Income $40.92 $48.41 $47.82 $42.54 $45.21 $44.22 $25.04 $45.19 $29.42 $24.03 $59.99 46.58% <-Total Growth 10 Comprehensive Income
18.30% -1.23% -11.04% 6.29% -2.20% -43.36% 80.45% -34.89% -18.32% 149.59% -18.32% <-Median-> 5 Comprehensive Income
$45 $46 $41 $40 $38 $34 $37 3.90% <-IRR #YR-> 10 Comprehensive Income 46.58%
ROE 16.2% 18.9% 18.2% 15.9% 16.6% 15.2% 9.0% 17.7% 11.8% 10.0% 22.6% 6.29% <-IRR #YR-> 5 Comprehensive Income 35.65%
5Yr Median 16.6% 16.6% 15.9% 15.9% 15.2% 11.8% 11.8% -3.32% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% 7.3% 0.0% 0.0% 0.0% 0.0% -17.2% 21.3% 0.7% 0.9% -8.5% -4.25% <-IRR #YR-> 5 5 Yr Running Average -19.51%
Median Values Diff 5, 10 yr 0.0% 0.7% 11.8% <-Median-> 5 Return on Equity
-$40.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $60.0
-$44.2 $0.0 $0.0 $0.0 $0.0 $60.0
-$45.0 $0.0 $0.0 $0.0 $0.0 $0.0 $36.7
-$45.6 $0.0 $0.0 $0.0 $0.0 $36.7
Current Liability Coverage Ratio 1.02 0.86 0.40 0.40 0.62 0.52 0.36 0.50 0.92 0.70 0.78 1.07 CFO / Current Liabilities
5 year Median 1.02 0.96 0.86 0.40 0.62 0.52 0.40 0.50 0.52 0.52 0.70 0.78 0.78 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 9.29% 9.14% 10.80% 9.47% 12.74% 10.75% 8.13% 9.93% 11.49% 10.93% 11.55% 19.17% CFO / Total Assets
5 year Median 7.18% 8.86% 9.14% 9.29% 9.47% 10.75% 10.75% 9.93% 10.75% 10.75% 10.93% 11.49% 11.5% <-Median-> 5 Return on Assets
Return on Assets ROA -10.1% 7.0% 7.6% 8.3% 7.4% 7.7% 7.2% 5.1% 6.7% 5.1% 4.3% 11.2% Net Income/Assets Return on Assets
5Yr Median 3.4% 6.0% 6.5% 7.0% 7.4% 7.6% 7.6% 7.4% 7.2% 6.7% 5.1% 5.1% 5.1% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE -17.7% 16.2% 17.6% 18.2% 15.9% 16.6% 15.2% 10.9% 14.6% 11.7% 9.9% 24.7% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 6.2% 6.9% 10.4% 16.2% 16.2% 16.6% 16.6% 15.9% 15.2% 14.6% 11.7% 11.7% 11.7% <-Median-> 5 Return on Equity
Net Income -$57.25 $40.92 $45.13 $47.82 $42.54 $45.21 $44.22 $30.26 $37.27 $29.23 $23.82 $65.58 60.25% <-Total Growth 10 Net Income
Increase -232.69% -171% 10.28% 5.96% -11.04% 6.29% -2.20% -31.57% 23.15% -21.56% -18.50% 175.28% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $7.76 $16.18 $18.84 $23.95 $23.83 $44.32 $44.98 $42.01 $39.90 $37.24 $32.96 $37.23 4.83% <-IRR #YR-> 10 Net Income Net Income
Operating Cash Flow $35.49 $30.83 $88.61 $23.00 $69.79 $83.20 $22.52 $47.79 $37.65 $37.65 $55.49 $66.67 8.20% <-IRR #YR-> 5 Net Income Net Income
Investment Cash Flow -$7.51 -$9.00 -$6.95 -$7.25 -$6.29 -$8.08 -$7.73 -$9.18 -$9.18 -$11.57 -$11.44 -$15.16 8.69% <-IRR #YR-> 10 5 Yr Running Ave. 5 Yr Running Ave.
Total Accruals -$85.23 $19.09 -$36.54 $32.07 -$20.97 -$29.91 $29.43 -$8.35 $8.80 $3.15 -$20.22 $14.06 -3.71% <-IRR #YR-> 5 5 Yr Running Ave. 5 Yr Running Ave.
Total Assets $568.07 $585.46 $592.10 $577.11 $574.37 $584.81 $613.24 $594.07 $553.60 $568.33 $551.93 $585.20 Balance Sheet Assets Assets
Accruals Ratio -15.00% 3.26% -6.17% 5.56% -3.65% -5.11% 4.80% -1.41% 1.59% 0.55% -3.66% 2.40% 0.55% <-Median-> 5 Ratio Ratio
EPS/CF Ratio (WC) -1.21 0.68 0.64 0.80 0.54 0.67 0.80 0.51 0.58 0.47 0.38 0.54 0.56 <-Median-> 10 EPS/CF Ratio EPS/CF Ratio
-$41 $0 $0 $0 $0 $0 $0 $0 $0 $0 $66
-$44 $0 $0 $0 $0 $66
-$16 $0 $0 $0 $0 $0 $0 $0 $0 $0 $37
-$45 $0 $0 $0 $0 $37
Change in Close 1.78% 9.75% 5.92% -13.33% 2.73% 17.63% 4.72% 27.45% -11.23% -18.54% -13.40% 64.13% 1.05% 0.00% 0.00% Count 20 Years of data
up/down up up down up Count 9 45.00%
Meet Prediction? yes yes % right Count 5 55.56%
Financial Cash Flow -$45.36 -$42.57 -$42.39 -$63.81 -$63.90 -$41.71 -$28.24 -$36.04 -$9.12 -$23.49 -$42.79 -$51.63 C F Statement Financial CF
Total Accruals -$39.87 $61.66 $5.86 $95.88 $42.93 $11.80 $57.68 $27.69 $17.91 $26.64 $22.57 $65.69 Accruals
Accruals Ratio -7.02% 10.53% 0.99% 16.61% 7.47% 2.02% 9.41% 4.66% 3.24% 4.69% 4.09% 11.23% 4.66% <-Median-> 5 Ratio
Cash $14.55 $53.82 $5.76 $5.37 $38.78 $25.33 $27.90 $3.20 $0.11 $1.36 $1.25 Cash
Cash per Share $0.16 $0.61 $0.07 $0.06 $0.44 $0.29 $0.30 $0.03 $0.00 $0.01 $0.01 $0.01 <-Median-> 5 Cash per Share
Percentage of Stock Price 4.45% 13.07% 1.73% 1.26% 8.30% 5.42% 4.95% 0.63% 0.02% 0.34% 0.19% 0.34% <-Median-> 5 % of Stock Price
Notes:
January 5, 2017. Last estimates were for 2016 and 2017 of $550M, $572M for Revenue, $0.35, $0.34 and $0.31 for EPS for 2016, 2017 and 2018, $0.53 and $0.65 for CFPS.
Big difference in basic and diluted earnings in 2016 due to impact of convertible unsecured subordinated debentures and share options
January 24, 2016. Last estimates were for 2015 and 2016 of $537M, $560M for Revenue, $0.33 and $0.33 for EPS, $0.54 and $0.52 for CFPS and $31.04 and $31.04 for Net Income.
January 24, 2015. Last estimates I got were for 2014 and 2015 of $596.3M and $580.2M for Revenue, $0.37 and $0.37 for EPS, $0.49 and $0.53 for CFPS.
January 25, 2014. The last estimates I got were for 2013 and 2014 of $585.2M and $589.8M for Revenue, $0.42 and $0.44 for EPS.
January 12, 2013. The last estimates were for 2012 and 2013 and were $608M and $585.1M for Revenue, $0.51 and $0.46 for EPS and $.061 for CFPS for 2012.
August 23, 2012. Estimates were last from 2011 to 2013 of $0.42, $0.51 and $0.46 for earnings and Revenue for 2011 and 2012 of $617.6M and $611.5M.
Jun 26, 2011. The company has decided to lower share capital by the amount of the deficit. Therefore the new deficit is a lot lower. This move does not affect the BV overall.
Jun 25, 2011. This company is carrying a big deficit under Unitholders Equity. Deficit started in 2002/3 when they had to write down investments in Rogers Sugar and Lantic Sugar.
Whenever you payout more in distributions that you earn, it adds to the deficit. This company has done this. Payout more than you earn also lowers BV.
This stock was a unit trust until January 2011. Old Symbol was RSI.UN and new one is RSI.
In 2002 company invested in Lantic Sugar and issued some 35.5M shares for this reason.
1997. Rogers Sugar Income Fund is the income trust that was established in October 1997 to act as a holding company for Lantic Sugar Limited that operates in Eastern Canada and Rogers Sugar
Ltd. that is based in Western Canada.
Sector:
Consumer Staple
What should this stock accomplish?
You would expect this stock to provide a nice dividend yield and little in the way of capital gains. The dividends would be good, but dividend growth would be expected at the rate of inflation.
This sort of dividend and dividend growth is similar to Real Estate. You would buy for diversification purposes.
Would I buy this company and Why.
I would consider this to replace real estate stock coverage.
Dividends
Dividends are paid in cycle 1, which is January, April, July, Octoboer. Dividends are declared for shareholders of one month and payable in the following month.
For example, on November 14, 2013 the company declared a dividend payable on January 20, 2014 for shareholders of record of December 31, 2013.
Prior to 2011, dividends were paid monthly. Diviends were paid quarterly from 1998 to 2004.
Misson Statement or closes thing I can find.
What I am looking for is a statement that the company wants to do well by their customers, employees, and community and and thereby earn shareholders a reasonable return.
Lantic is actively involved in supporting local community initiatives where it has operations and offices.
Conduct its daily operations in ways that contribute to the health and well-being of its employees, as well as the community;
Conduct its business activities in the most environmentally sound manner possible;
Why am I following this stock.
This stock was brought to my attention by <a href="http://www.dividendninja.com/" target="_top">Dividend Ninja</a>. This company used to be a Income Trust (TSX-RSI.UN) but it has been converted to a corporation.
On its change to a corporation, it lowered its dividend.
How they make their money.
Rogers Sugar Inc. was established to hold all of the common shares and notes of Lantic Inc. Lantic Inc. is a refiner, processor, distributor and marketer of sugar products in Canada.
Interesting item since last publishing date.
http://www.fool.ca/2014/02/03/is-rogers-sugar-a-sweet-deal/
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 Jan 19 2013 Jan 25 2014 Jan 24 2015 Jan 24 2016 Jan 05 2017
Holliday, John 0.015 0.02% 0.035 0.04%
CEO - Shares - Amount $0.100 $0.236
Options - percentage 0.850 0.91% 0.980 1.04%
Options - amount $5.678 $6.615
Makin, Edward 0.112 0.12% 0.112 0.12% 0.117 0.12% was CEO in 2015
CEO - Shares - Amount $0.647 $0.527 $0.477
Options - percentage 0.050 0.05% 0.030 0.03% 0.030 0.03%
Options - amount $0.289 $0.141 $0.122
Discepola, Diana R. 0.038 0.04% cannot find info
CFO - Shares - Amount $0.255
Options - percentage 0.000 0.00%
Options - amount $0.000
Copeland, Robert Mair 0.006 0.01% 0.008 0.01% 0.008 0.01% 0.008 0.01%
Officer - Shares - Amount $0.027 $0.032 $0.053 $0.054
Options - percentage 0.000 0.00% 0.000 0.00% 0.077 0.08% -0.017 -0.02%
Options - amount $0.000 $0.000 $0.511 -$0.111
Dussault, Jacques 0.004 0.00% 0.010 0.01% 0.010 0.01%
Officer - Shares - Amount $0.020 $0.041 $0.068
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
Lafrance, Daniel 0.032 0.03% 0.033 0.03% 0.035 0.04% 0.038 0.04% 0.046 0.05% was CFO in 2015
Director - Shares - Amount $0.185 $0.153 $0.144 $0.255 $0.309 Now a Director
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Still listed as CFO
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000
Bergmame, Dean 0.149 0.16% 0.030 0.03% 0.038 0.04%
Director - Shares - Amount $0.701 $0.121 $0.253
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
Ross, Dallas H. 0.041 0.04%
Chairman - Shares - Amt $0.277
Options - percentage 0.000 0.00%
Options - amount $0.000
Belkin, Alton Stuart 0.145 0.15% 0.149 0.16% 0.155 0.16% 0.161 0.17%
Chairman - Shares - Amt $0.835 $0.701 $0.630 $1.075
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000
Belkin Enterprises Ltd. 11.208 11.91% 11.215 11.93% 11.215 11.93% 11.215 11.95% Last updated 2013
Shares - amount $64.671 $52.711 $45.646 $74.918
Increase in O/S Shares 0.100 0.11% 0.024 0.02% 0.000 0.00% 0.030 0.03% 0.000 0.00% Yes, 0 in 2015
due to SO $0.577 $0.136 $0.000 $0.122 $0.000 Look on comments
Book Value $0.376 $0.096 $0.000 $0.113 $0.000 to find shares
Insider Buying -$0.254 -$0.359 -$0.163 re SO.
Insider Selling $0.000 $0.000 $0.400
Net Insider Selling -$0.254 -$0.359 $0.237
% of Market Cap -0.07% -0.06% 0.04%
Directors 5 5 7 7
Women 0 0% 0 0% 0 0% 0 0%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 11 24.46% 11 24.26% 14 27.15% 16 17.49% 25 17.79%
Total Shares Held 24.894 26.45% 22.832 24.28% 25.526 29.15% 16.427 17.50% 16.700 17.79%
Increase/Decrease -0.842 -3.27% -0.924 -3.89% 0.235 0.93% -0.018 -0.11% 11.382 214.02%
Starting No. of Shares 25.737 23.756 25.291 16.445 5.318
Copyright 2008 Website of SPBrunner. All rights reserved.