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/ Q1 2017
Liquor Stores N.A. TSX LIQ OTC LQSIF www.liquorstoresgp.ca Dec 31
Year 12/31/05 12/31/06 12/31/07 12/30/08 12/31/09 12/31/10 12/31/11 12/30/12 12/31/13 12/31/14 12/31/15 12/30/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G
Accounting Rules IFRS Accounting Rules
$808 <-12 mths -1.18%
Revenue* $157.4 $222.0 $383.1 $482.9 $541.0 $579.7 $591.5 $630.1 $661.0 $694.2 $746.4 $817.7 $819.0 $847.0 $884.0 268.33% <-Total Growth 10 Revenue
Increase 342.97% 41.00% 72.55% 26.07% 12.04% 7.14% 2.04% 6.53% 4.90% 5.02% 7.52% 9.55% 0.16% 3.42% 4.37% 13.93% <-IRR #YR-> 10 Revenue 268.33%
5 year Running Average $256.2 $357.3 $441.7 $515.6 $565.1 $600.7 $631.3 $665 $710 $747.6 $784.8 $822.8 6.69% <-IRR #YR-> 5 Revenue 38.24%
Revenue per Share $25.48 $21.70 $20.94 $26.31 $29.29 $25.68 $26.10 $27.49 $28.60 $25.48 $27.19 $29.56 $29.61 $30.62 $31.95 13.59% <-IRR #YR-> 8 5 yr Running Average #DIV/0!
Increase 208.23% -14.81% -3.53% 25.64% 11.35% -12.35% 1.64% 5.32% 4.04% -10.89% 6.70% 8.70% 0.16% 3.42% 4.37% 6.60% <-IRR #YR-> 5 5 yr Running Average 37.67%
5 year Running Average $20.54 $24.74 $24.78 $25.66 $26.97 $27.43 $26.67 $26.97 $27.66 $28.09 $28.49 $29.79 3.14% <-IRR #YR-> 10 Revenue per Share 36.18%
P/S (Price/Sales) Med 0.66 0.89 1.01 0.64 0.45 0.64 0.56 0.64 0.58 0.49 0.44 0.30 2.52% <-IRR #YR-> 5 Revenue per Share 13.26%
P/S (Price/Sales) Close 0.69 0.89 1.15 0.40 0.53 0.59 0.58 0.68 0.49 0.60 0.31 0.36 0.35 0.34 0.32 3.79% <-IRR #YR-> 8 5 yr Running Average 11.80%
*Revenue in M CDN $ P/S Med 10 yr 0.57 5 yr 0.49 -38.77% Diff M/C 1.51% <-IRR #YR-> 5 5 yr Running Average 7.80%
-$222.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $817.7
-$591.5 $0.0 $0.0 $0.0 $0.0 $817.7
-$256.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $709.9
-$515.6 $0.0 $0.0 $0.0 $0.0 $709.9
-$21.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.56
-$26.10 $0.00 $0.00 $0.00 $0.00 $29.56
-$0.10 <-12 mths -600.00%
EPS Basic $1.05 $1.35 $0.68 $1.05 $1.29 $1.00 $1.08 $0.82 $0.49 $0.54 -$3.64 $0.02 -98.52% <-Total Growth 10 EPS Basic
EPS Diluted* $1.03 $1.32 $0.68 $1.05 $1.27 $1.00 $1.08 $0.82 $0.49 $0.54 -$3.64 $0.02 $0.41 $0.52 $0.57 -98.49% <-Total Growth 10 EPS Diluted
Increase 195.69% 28.38% -48.52% 54.41% 20.95% -21.26% 8.00% -24.07% -40.24% 10.20% -774.07% 100.55% 1950.00% 26.83% 9.62% -34.23% <-IRR #YR-> 10 Earnings per Share -98.49%
Earnings Yield 5.88% 6.86% 2.83% 10.05% 8.12% 6.59% 7.18% 4.42% 3.48% 3.51% -43.49% 0.19% 3.98% 5.05% 5.53% -54.97% <-IRR #YR-> 5 Earnings per Share -98.15%
5 year Running Average $0.89 $1.07 $1.06 $1.02 $1.04 $0.93 $0.79 -$0.14 -$0.35 -$0.44 -$0.43 -$0.42 #NUM! <-IRR #YR-> 7 5 yr Running Average -133.08%
10 year Running Average $0.91 $0.93 $0.46 $0.33 $0.30 $0.25 $0.18 #NUM! <-IRR #YR-> 5 5 yr Running Average -134.84%
* Diluted ESP per share E/P 10 Yrs 3.96% 5Yrs 3.48%
-$1.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.02
-$1.08 $0.00 $0.00 $0.00 $0.00 $0.02
-$1.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.35
-$1.02 $0.00 $0.00 $0.00 $0.00 -$0.35
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
Dividend* $1.04 $1.12 $1.48 $1.62 $1.62 $1.62 $1.13 $1.08 $1.08 $1.08 $1.08 $0.54 $0.36 $0.36 $0.36 -51.94% <-Total Growth 10 Dividends
Increase 7.65% 32.08% 9.16% 0.00% 0.00% -30.56% -4.00% 0.00% 0.00% 0.00% -50.00% -33.33% 0.00% 0.00% Count 12 Years of data
Dividends 5 Yr Running $1.09 $1.38 $1.49 $1.49 $1.41 $1.31 $1.20 $1.09 $0.97 $0.83 $0.68 $0.54 -29.48% <-Total Growth 8 Dividends 5 Yr Running
Yield H/L Price 6.17% 5.80% 7.04% 9.62% 12.39% 9.87% 7.77% 6.09% 6.50% 8.71% 9.12% 6.00% 3.61% 8.24% <-Median-> 10 Yield H/L Price
Yield on High Price 5.35% 5.04% 6.18% 6.57% 10.03% 9.02% 7.04% 5.35% 5.58% 7.40% 6.70% 4.76% 3.31% 6.64% <-Median-> 10 Yield on High Price
Yield on Low Price 7.29% 6.83% 8.18% 17.94% 16.20% 10.90% 8.67% 7.08% 7.76% 10.58% 14.29% 8.11% 3.98% 9.62% <-Median-> 10 Yield on Low Price
Yield on Close Price 5.97% 5.84% 6.18% 15.50% 10.35% 10.67% 7.48% 5.82% 7.68% 7.01% 12.90% 5.13% 3.50% 3.50% 3.50% 7.58% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 101.43% 85.06% 218.24% 154.29% 127.56% 162.00% 104.17% 131.71% 220.41% 200.00% -29.67% 2700.00% 87.80% 69.23% 63.16% 158.14% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 122.99% 128.81% 140.34% 147.03% 135.34% 140.02% 152.29% -766.90% -274.58% -189.91% -159.07% -127.36% 135.34% <-Median-> 9 DPR EPS 5 Yr Running
Payout Ratio CFPS 141.35% 123.06% 173.29% 80.36% 65.57% 92.70% 80.25% 81.91% 49.14% 141.21% 181.07% 31.30% 41.86% 33.33% #DIV/0! 81.14% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 116.42% 98.53% 93.30% 87.95% 78.90% 71.42% 80.54% 86.71% 73.60% 67.38% 68.04% #DIV/0! 86.71% <-Median-> 9 DPR CF 5 Yr Running
Payout Ratio CFPS WC 53.65% 62.67% 82.86% 74.36% 75.21% 105.90% 60.11% 68.09% 82.96% 133.26% 110.21% 50.94% 41.86% 33.33% #DIV/0! 79.04% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 64.16% 69.88% 79.05% 78.42% 75.80% 77.28% 84.30% 83.13% 84.69% 82.60% 71.39% #DIV/0! 78.42% <-Median-> 9 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 6.50% 7.01% 5 Yr Med Payout 200.00% 81.91% 82.96% -7.07% <-IRR #YR-> 10 Dividends -51.94%
* Dividends per share 5 Yr Med and Cur. -46.20% -50.16% Last Div Inc ---> $0.09 $0.03 -66.7% -13.65% <-IRR #YR-> 5 Dividends -52.00%
-$1.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.54
-$1.13 $0.00 $0.00 $0.00 $0.00 $0.54
Historical Dividends Historical High Div 17.42% Low Div 4.84% Ave Div 11.13% Med Div 7.40% Close Div 7.24% Historical Dividends
High/Ave/Median Values Curr diff Exp. -79.94% Exp -27.79% Exp. -68.60% Exp. -52.77% Exp. -51.75% High/Ave/Median
Adjusted Historical Dividends Historical High Div 13.17% Low Div 1.14% Ave Div 7.16% Med Div 4.38% Close Div 4.29% $0.1350 $0.0300 Adjusted Historical Dividends
High/Ave/Median Values Curr diff Cheap -73.46% 206.59% Cheap -51.15% Cheap -20.20% Cheap -18.46% 22.22% -77.78% High/Ave/Median
Future Dividend Yield Div Yd 3.50% earning in 10.00 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yd 3.50% earning in 10.00 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yd 3.50% earning in 15.00 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Yield if held 5 yrs 11.78% 9.58% 5.81% 5.13% 6.42% 8.26% 6.58% 3.73% 2.03% 2.17% 2.90% 6.50% <-Median-> 8 Paid Median Price
Yield if held 10 yrs 7.85% 6.39% 2.79% 1.71% 2.14% 2.75% 6.39% <-Median-> 3 Paid Median Price
Yield if held 15 yrs 2.62% #NUM! <-Median-> 0 Paid Median Price
Yield if held 20 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Yield if held 25 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 50.12% 44.17% 38.55% 33.53% 38.76% 45.77% 33.18% 33.55% 23.36% 20.57% 21.77% 38.65% <-Median-> 8 Paid Median Price
Cost covered if held 10 years 93.65% 76.38% 63.63% 53.18% 59.07% 66.42% 76.38% <-Median-> 3 Paid Median Price
Cost covered if held 15 years 113.28% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham Number $15.88 $20.22 $15.88 $19.50 $21.03 $17.71 $18.44 $15.99 $12.20 $12.75 $10.64 $1.94 $8.63 $9.72 $10.18 -90.42% <-Total Growth 10 Graham Number
Change 90.43% 27.32% -21.45% 22.79% 7.83% -15.80% 4.12% -13.28% -23.72% 4.57% -16.59% -81.78% 345.46% 12.62% 4.70%
Price/GP Ratio Med 1.06 0.96 1.33 0.86 0.62 0.93 0.79 1.11 1.36 0.97 1.11 4.65 1.15 1.04 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.23 1.10 1.51 1.26 0.77 1.01 0.87 1.26 1.59 1.14 1.52 5.86 1.26 1.26 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.90 0.81 1.14 0.46 0.48 0.84 0.70 0.95 1.14 0.80 0.71 3.44 1.05 0.82 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.10 0.95 1.51 0.54 0.74 0.86 0.82 1.16 1.15 1.21 0.79 5.43 1.19 1.06 1.01 1.01 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 10.12% -4.80% 51.10% -46.42% -25.59% -14.28% -18.38% 16.08% 15.37% 20.75% -21.32% 443.35% 19.31% 5.94% 1.19% 0.54% <-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 $17.49 $19.25 $24.00 $10.45 $15.65 $15.18 $15.05 $18.56 $14.07 $15.40 $8.37 $10.53 $10.30 $10.30 $10.30 -45.30% <-Total Growth 10 Stock Price
Increase 20.29% 10.06% 24.68% -56.46% 49.76% -3.00% -0.86% 23.32% -24.19% 9.45% -45.65% 25.81% -2.18% 0.00% 0.00% -5.85% <-IRR #YR-> 10 Stock Price -45.30%
P/E Ratio 17.00 14.57 35.29 9.95 12.32 15.18 13.94 22.63 28.71 28.52 -2.30 526.50 25.12 19.81 18.07 -6.89% <-IRR #YR-> 5 Stock Price -30.03%
Trailing P/E Ratio 50.26 18.71 18.17 15.37 14.90 11.95 15.05 17.19 17.16 31.43 15.50 -2.89 515.00 25.12 19.81 2.46% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 8.31% 7.42% % Tot Ret 338.21% 1421.65% T P/E 17.16 P/E: 18.91 28.52 0.52% <-IRR #YR-> 5 Price & Dividend
-$19.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.53
-$15.05 $0.00 $0.00 $0.00 $0.00 $10.53
-$19.25 $1.48 $1.62 $1.62 $1.62 $1.13 $1.08 $1.08 $1.08 $1.08 $11.07
-$15.05 $1.08 $1.08 $1.08 $1.08 $11.07
Price H/L Median $16.91 $19.38 $21.07 $16.84 $13.08 $16.41 $14.49 $17.73 $16.63 $12.40 $11.84 $9.01 $9.97 -53.52% <-Total Growth 10 Stock Price
Increase 22.95% 14.61% 8.75% -20.10% -22.33% 25.51% -11.73% 22.37% -6.21% -25.41% -4.52% -23.94% 10.72% -7.38% <-IRR #YR-> 10 Stock Price -53.52%
P/E Ratio 16.43 14.67 30.99 16.03 10.30 16.41 13.41 21.62 33.93 22.96 -3.25 450.25 24.32 -9.07% <-IRR #YR-> 5 Stock Price -37.83%
Trailing P/E Ratio 48.58 18.83 15.95 24.76 12.45 12.92 14.49 16.41 20.27 25.31 21.93 -2.47 498.50 1.40% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 19.01 12.22 15.42 14.26 16.98 17.84 15.78 -83.38 -25.44 -22.87 -1.03% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 18.29 13.36 25.68 27.21 32.80 16.43 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 8.77% 8.04% % Tot Ret 627.27% 0.00% T P/E 20.27 P/E: 19.01 22.96 Count 13 Years of data
-$19.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.01
-$14.49 $0.00 $0.00 $0.00 $0.00 $9.01
-$19.38 $1.48 $1.62 $1.62 $1.62 $1.13 $1.08 $1.08 $1.08 $1.08 $9.55
-$14.49 $1.08 $1.08 $1.08 $1.08 $9.55
High Months May Sep Dec Feb Oct Apr Jan Jul Jan Jan Jan Dec May
Price High $19.50 $22.30 $24.00 $24.64 $16.15 $17.96 $15.99 $20.20 $19.34 $14.59 $16.12 $11.35 $10.89 -49.10% <-Total Growth 10 Stock Price
Increase 32.65% 14.36% 7.62% 2.67% -34.46% 11.21% -10.97% 26.33% -4.26% -24.56% 10.49% -29.59% -4.05% -6.53% <-IRR #YR-> 10 Stock Price -49.10%
P/E Ratio 18.95 16.88 35.29 23.47 12.72 17.96 14.81 24.63 39.47 27.02 -4.43 567.50 26.56 -6.63% <-IRR #YR-> 5 Stock Price -29.02%
Trailing P/E Ratio 56.03 21.67 18.17 36.24 15.38 14.14 15.99 18.70 23.59 29.78 29.85 -3.12 544.50 23.47 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 23.59 P/E: 24.05 27.02 40.02 P/E Ratio Historical High
-$22.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.35
-$15.99 $0.00 $0.00 $0.00 $0.00 $11.35
Low Months Jan Nov Feb Dec Feb Jun Oct Jan Dec May Dec Jan Mar
Price Low $14.31 $16.45 $18.14 $9.03 $10.00 $14.86 $12.98 $15.25 $13.91 $10.21 $7.56 $6.66 $9.05 -59.51% <-Total Growth 10 Stock Price
Increase 11.80% 14.95% 10.27% -50.22% 10.74% 48.60% -12.65% 17.49% -8.79% -26.60% -25.95% -11.90% 35.89% -8.65% <-IRR #YR-> 10 Stock Price -59.51%
P/E Ratio 13.91 12.45 26.68 8.60 7.87 14.86 12.02 18.60 28.39 18.91 -2.08 333.00 22.07 -12.49% <-IRR #YR-> 5 Stock Price -48.69%
Trailing P/E Ratio 41.12 15.99 13.73 13.28 9.52 11.70 12.98 14.12 16.96 20.84 14.00 -1.83 452.50 14.86 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 14.12 P/E: 16.73 18.91 8.45 P/E Ratio Historical Low
-$16.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.66
Long Term Debt $26.85 $5.46 $74.01 $79.74 $100.13 $100.42 $102.15 $146.57 $133.82 $92.04 $129.68 $135.84 $157.10 Debt
Change 262.87% -79.68% 1256.71% 7.74% 25.56% 0.29% 1.73% 43.48% -8.70% -31.22% 40.90% 4.75% 15.65% 6.24% <-Median-> 10 Change
Debt/Market Cap Ratio 0.25 0.03 0.17 0.42 0.35 0.29 0.30 0.34 0.41 0.22 0.56 0.47 0.55 0.35 <-Median-> 10 Debt/Market Cap Ratio
Market Cap $229.8 $291.3
Debt (Interest Bearing) $129.7 $135.8
Minority interest $0.1 $4.5
Preferred stock $0.0 $0.0
Less Cash and Near Cash -$3.8 -$7.0
Enterprise Value $355.7 $424.6 Cost to buy company
EV/BV Ratio 1.39 1.84 BV what co. is worth
Goodwill & Intangibles $83.10 $105.76 $297.42 $319.73 $331.06 $328.02 $326.45 $325.68 $318.05 $321.32 $202.30 $205.01 $204.81 Intangibles Goodwill
Change 23.39% 27.27% 181.22% 7.50% 3.54% -0.92% -0.48% -0.24% -2.34% 1.03% -37.04% 1.34% -0.10% 0.40% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.77 0.54 0.68 1.67 1.15 0.96 0.96 0.77 0.98 0.77 0.88 0.70 0.72 0.92 <-Median-> 10 Intangible/Market Cap Ratio
Market Cap $108.1 $196.9 $439.1 $191.8 $289.1 $342.7 $341.1 $425.5 $325.2 $419.5 $229.8 $291.3 $284.9 $284.9 $284.9 47.95% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 10.02 12.00 18.65 18.36 22.53 18.64 22.61 22.87 23.04 23.34 27.38 27.75 131.26% <-Total Growth 10 Diluted
Change 133.12% 19.71% 55.43% -1.58% 22.74% -17.27% 21.32% 1.12% 0.74% 1.33% 17.27% 1.37% 1.35% <-Median-> 10 Change
Basic # of Shares in Millions 5.86 8.52 14.59 18.34 18.45 18.63 22.61 22.82 23.02 23.34 27.33 27.59 223.70% <-Total Growth 10 Basic
Change 36.37% 45.38% 71.16% 25.71% 0.56% 1.00% 21.39% 0.89% 0.92% 1.39% 17.07% 0.97% 1.19% <-Median-> 10 Change
Difference 5.39% 19.98% 25.37% 0.08% 0.13% 21.19% 0.23% 0.48% 0.38% 16.69% 0.44% 0.25% 0.41% <-Median-> 10 Difference
$46.8 <-12 mths -1.91%
# of Share in Millions 6.180 10.228 18.294 18.357 18.470 22.577 22.666 22.925 23.113 27.241 27.450 27.664 27.664 27.664 27.664 10.46% <-IRR #YR-> 10 Shares 170.47%
Change 43.71% 65.52% 78.86% 0.34% 0.62% 22.23% 0.39% 1.14% 0.82% 17.86% 0.77% 0.78% 0.00% 0.00% 0.00% 4.07% <-IRR #YR-> 5 Shares 22.05%
Cash Flow from Operations $M $4.6 $9.3 $15.7 $37.0 $45.6 $39.5 $31.8 $30.2 $50.8 $20.8 $16.4 $47.7 $23.8 $29.9 411.08% <-Total Growth 10 Cash Flow
Increase 588.30% 104.66% 67.76% 136.20% 23.31% -13.53% -19.47% -4.88% 68.08% -58.99% -21.41% 191.51% -50.15% 25.58% DRIP, SO Share Iss. Conv of Debentures
5 year Running Average $13.4 $22.4 $29.4 $33.9 $36.8 $39.6 $34.6 $30.0 $33.2 $31.9 $27.7 47.91% <-Total Growth 8 CF 5 Yr Running
CFPS $0.74 $0.91 $0.86 $2.02 $2.47 $1.75 $1.40 $1.32 $2.20 $0.76 $0.60 $1.73 $0.86 $1.08 88.96% <-Total Growth 10 Cash Flow per Share
Increase 378.94% 23.65% -6.20% 135.40% 22.56% -29.26% -19.78% -5.95% 66.71% -65.20% -22.01% 189.25% -50.15% 25.58% 17.72% <-IRR #YR-> 10 Cash Flow 411.08%
5 year Running Average $0.94 $1.40 $1.60 $1.70 $1.79 $1.83 $1.49 $1.26 $1.32 $1.23 $1.01 8.48% <-IRR #YR-> 5 Cash Flow 50.20%
P/CF on Med Price 22.89 21.22 24.60 8.35 5.29 9.39 10.33 13.44 7.56 16.21 19.85 5.22 11.59 0.00 6.57% <-IRR #YR-> 10 Cash Flow per Share 88.96%
P/CF on Closing Price 23.69 21.08 28.02 5.18 6.33 8.69 10.74 14.08 6.40 20.14 14.03 6.10 11.98 9.54 4.24% <-IRR #YR-> 5 Cash Flow per Share 23.07%
21.46% Diff M/C -0.82% <-IRR #YR-> 7 CFPS 5 yr Running -5.59%
Excl.Working Capital CF $7.5 $9.0 $17.1 $3.0 -$5.8 -$4.9 $10.6 $6.1 -$20.7 $1.2 $10.5 -$18.4 $0.0 $0.0 -4.91% <-IRR #YR-> 5 CFPS 5 yr Running -22.25%
CF fr Op $M WC $12.0 $18.3 $32.8 $40.0 $39.8 $34.5 $42.4 $36.4 $30.1 $22.1 $26.9 $29.3 $23.8 $29.9 59.91% <-Total Growth 10 Cash Flow less WC
Increase 257.89% 52.55% 78.65% 22.07% -0.53% -13.19% 22.83% -14.27% -17.26% -26.63% 21.85% 9.02% -18.87% 25.58% 4.81% <-IRR #YR-> 10 Cash Flow less WC 59.91%
5 year Running Average $21.3 $28.6 $33.1 $37.9 $38.6 $36.6 $33.1 $31.6 $29.0 $26.4 $26.4 -7.12% <-IRR #YR-> 5 Cash Flow less WC -30.87%
CFPS Excl. WC $1.95 $1.79 $1.79 $2.18 $2.15 $1.53 $1.87 $1.59 $1.30 $0.81 $0.98 $1.06 $0.86 $1.08 0.18% <-IRR #YR-> 7 CF less WC 5 Yr Run 1.30%
Increase 149.03% -7.84% -0.11% 21.65% -1.14% -28.98% 22.34% -15.24% -17.93% -37.75% 20.92% 8.17% -18.87% 25.58% -5.24% <-IRR #YR-> 5 CF less WC 5 Yr Run -23.61%
5 year Running Average $1.70 $1.97 $1.89 $1.90 $1.86 $1.69 $1.42 $1.31 $1.15 $1.00 $0.96 -5.12% <-IRR #YR-> 10 CFPS - Less WC -40.87%
P/CF on Median Price 8.69 10.81 11.77 7.73 6.07 10.73 7.74 11.17 12.77 15.30 12.08 8.49 11.59 0.00 -10.75% <-IRR #YR-> 5 CFPS - Less WC -43.36%
P/CF on Closing Price 8.99 10.74 13.40 4.80 7.27 9.92 8.04 11.70 10.81 19.00 8.54 9.93 11.98 9.54 -7.44% <-IRR #YR-> 7 CFPS 5 yr Running -41.81%
*Operational Cash Flow. CF/-WC P/CF Med 10 yr 9.86 5 yr 13.44 P/CF Med 10 yr 10.95 5 yr 12.08 9.37% Diff M/C -9.64% <-IRR #YR-> 5 CFPS 5 yr Running -39.75%
-$0.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.73 Cash Flow per Share
-$1.40 $0.00 $0.00 $0.00 $0.00 $1.73 Cash Flow per Share
-$1.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.32 CFPS 5 yr Running
-$1.70 $0.00 $0.00 $0.00 $0.00 $1.32 CFPS 5 yr Running
-$18.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $29.3 Cash Flow less WC
-$42.4 $0.0 $0.0 $0.0 $0.0 $29.3 Cash Flow less WC
-$28.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $29.0 CF less WC 5 Yr Run
-$37.9 $0.0 $0.0 $0.0 $0.0 $29.0 CF less WC 5 Yr Run
-$1.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.06 CFPS - Less WC
-$1.87 $0.00 $0.00 $0.00 $0.00 $1.06 CFPS - Less WC
OPM Ratio 2.90% 4.21% 4.09% 7.66% 8.43% 6.81% 5.37% 4.80% 7.69% 3.00% 2.19% 5.84% 38.76% <-Total Growth 10 OPM
Increase 55.38% 45.15% -2.78% 87.36% 10.06% -19.30% -21.07% -10.71% 60.23% -60.95% -26.91% 166.10% Should increase or be stable.
Diff from Median -48.3% -24.9% -27.0% 36.7% 50.5% 21.4% -4.1% -14.4% 37.1% -46.5% -60.9% 4.1% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 5.60% 5 Yrs 4.80% should be zero, it is a check on calculations
Current Assets $38.8 $55.8 $109.2 $121.4 $131.7 $127.0 $136.3 $160.2 $145.1 $149.6 $178.0 $176.0 $172.4 Liquidity ratio of 1.5 and up, best Quick Ratio
Current Liabilities $20.4 $12.9 $14.1 $83.2 $68.7 $71.8 $123.0 $46.6 $46.5 $51.1 $64.8 $69.5 $57.6 2.64 <-Median-> 10 Ratio
Liquidity Ratio 1.90 4.33 7.76 1.46 1.92 1.77 1.11 3.43 3.12 2.93 2.75 2.53 2.99 2.93 <-Median-> 5 Ratio
Liq. with CF aft div 1.81 4.16 6.95 1.55 2.15 1.81 1.16 3.55 3.68 2.76 2.54 3.01 3.23 3.01 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.74 1.08 2.88 0.95 1.42 1.71 1.11 2.67 2.91 2.25 1.73 2.00 3.23 2.25 <-Median-> 5 Ratio
Curr Long Term Debt $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $55.681 $0.000 $0.000 $0.000 $0.114 $0.323 $0.370
Liquidity Less CLTD 1.90 4.33 7.76 1.46 1.92 1.77 2.02 3.43 3.12 2.93 2.75 2.55 3.01 2.93 <-Median-> 5 Ratio
Liq. with CF aft div 1.81 4.16 6.95 1.55 2.15 1.81 2.12 3.55 3.68 2.76 2.55 3.02 3.26 3.02 <-Median-> 5 Ratio
Assets $140.8 $187.1 $449.7 $489.5 $509.8 $495.9 $503.1 $533.1 $512.7 $525.9 $455.6 $463.0 $459.9 Debt Ratio of 1.5 and up, best Current Ratio
Liabilities $31.8 $12.9 $148.0 $193.9 $223.6 $181.0 $185.9 $215.3 $200.8 $161.1 $199.8 $227.7 $232.4 2.54 <-Median-> 10 Ratio
Debt Ratio 4.43 14.51 3.04 2.52 2.28 2.74 2.71 2.48 2.55 3.26 2.28 2.03 1.98 2.48 <-Median-> 5 Ratio
Book Value $109.0 $174.2 $301.7 $295.6 $286.2 $315.0 $317.2 $317.8 $311.9 $364.8 $255.7 $235.4 $227.5 35.13% <-Total Growth 10 Book Value
NCI $41.7 $33.5 $0.0 $0.0 $0.3 $0.3 $0.1 $0.1 $0.1 $0.1 $0.1 $4.5 $4.0 -86.55% <-Total Growth 10 NCI
Net Book Value $67.3 $140.7 $301.7 $295.6 $285.9 $314.7 $317.1 $317.7 $311.8 $364.7 $255.7 $230.9 $223.5 $223.5 $223.5 64.09% <-Total Growth 10 Net Book Value
Book Value per share $10.89 $13.76 $16.49 $16.10 $15.48 $13.94 $13.99 $13.86 $13.49 $13.39 $9.31 $8.35 $8.08 $8.08 $8.08 -39.33% <-Total Growth 10 Book Value per Share
Change 22.64% 26.27% 19.87% -2.35% -3.88% -9.95% 0.38% -0.96% -2.64% -0.78% -30.42% -10.39% -3.20% 0.00% 0.00% 3.46% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.55 1.41 1.28 1.05 0.84 1.18 1.04 1.28 1.23 0.93 1.27 1.08 1.23 1.23 P/B Ratio Historical Median
P/B Ratio (Close) 1.61 1.40 1.46 0.65 1.01 1.09 1.08 1.34 1.04 1.15 0.90 1.26 1.27 1.27 1.27 -4.87% <-IRR #YR-> 10 Book Value per Share
Change -1.92% -12.83% 4.01% -55.41% 55.80% 7.72% -1.23% 24.52% -22.14% 10.31% -21.88% 40.39% 1.05% 0.00% 0.00% -9.82% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 1.29 1.07 1.49 1.66 1.78 1.57 1.59 1.68 1.64 1.44 1.78 1.97 2.02 1.68 <-Median-> 5 A/BV
Debt/Equity Ratio 0.29 0.07 0.49 0.66 0.78 0.57 0.59 0.68 0.64 0.44 0.78 0.97 1.02 0.68 <-Median-> 5 Debt/Eq Ratio
Shareholders' Equity (Assets less Liabilities) P/BV 10 yr Med 1.13 5 yr Med 1.23 13.01% Diff M/C 1.59 Historical Leverage (A/BK)
-$13.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.35
-$13.99 $0.00 $0.00 $0.00 $0.00 $8.35
$5.02 <-12 mths 264.00%
Comprehensive Income $10.31 $15.98 $13.12 $20.66 $20.30 $19.87 $25.97 $17.73 $16.33 $20.26 -$82.59 -$0.96 -105.98% <-Total Growth 10 Comprehensive Income
NCI $4.21 $4.46 $3.23 $1.40 -$3.43 $3.59 $0.34 $0.28 $0.21 $0.24 $0.20 $2.11 -52.81% <-Total Growth 10 NCI
Shareholders $6.10 $11.52 $9.89 $19.26 $23.73 $16.28 $25.63 $17.45 $16.12 $20.02 -$82.78 -$3.06 -126.58% <-Total Growth 10 Comprehensive Income
Increase 88.84% -14.16% 94.83% 23.21% -31.38% 57.42% -31.93% -7.61% 24.22% -513.40% 96.30% -7.61% <-Median-> 5 Comprehensive Income
5 Yr Running Average $14.10 $16.13 $18.96 $20.47 $19.84 $19.10 -$0.71 -$6.45 #NUM! <-IRR #YR-> 10 Comprehensive Income -126.58%
ROE 5.6% 6.6% 3.3% 6.5% 8.3% 5.2% 8.1% 5.5% 5.2% 5.5% -32.4% -1.3% #NUM! <-IRR #YR-> 5 Comprehensive Income -111.94%
5Yr Median 6.5% 6.5% 6.5% 6.5% 5.5% 5.5% 5.5% 5.2% #NUM! <-IRR #YR-> 7 5 Yr Running Average #DIV/0!
% Difference from NI -38.25% -19.23% 0.00% 0.00% -0.10% -12.94% 4.75% -7.11% 42.95% 57.46% 16.90% -558.38% #NUM! <-IRR #YR-> 5 5 Yr Running Average -134.02%
Median Values Diff 5, 10 yr 0.0% 16.9% 5.2% <-Median-> 5 Return on Equity
-$11.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$3.1
-$25.6 $0.0 $0.0 $0.0 $0.0 -$3.1
-$14.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$6.5
-$19.0 $0.0 $0.0 $0.0 $0.0 -$6.5
Current Liability Coverage Ratio 0.22 0.72 1.11 0.44 0.66 0.55 0.26 0.65 1.09 0.41 0.25 0.69 CFO / Current Liabilities
5 year Median 0.44 0.66 0.66 0.55 0.55 0.65 0.55 0.41 0.65 0.60 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 3.2% 5.0% 3.5% 7.6% 9.0% 8.0% 6.3% 5.7% 9.9% 4.0% 3.6% 10.3% CFO / Total Assets
5 year Median 3.5% 5.0% 7.6% 7.6% 7.6% 8.0% 6.3% 5.7% 5.7% 6.9% <-Median-> 10 Return on Assets
Return on Assets ROA 4.3% 6.2% 2.2% 3.9% 4.7% 3.8% 4.9% 3.5% 2.2% 2.4% -21.9% 0.1% Net Income/Assets Return on Assets
5Yr Median 3.9% 4.3% 3.9% 3.9% 3.9% 3.8% 3.5% 2.4% 2.2% 3.0% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 9.1% 8.2% 3.3% 6.5% 8.3% 5.9% 7.7% 5.9% 3.6% 3.5% -39.0% 0.3% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 6.5% 8.2% 6.5% 6.5% 6.5% 5.9% 5.9% 3.6% 3.5% 4.8% <-Median-> 10 Return on Equity
-$2.66 <-12 mths -505.95%
Net Income $10.31 $15.98 $13.12 $24.49 $29.05 $22.75 $24.80 $19.06 $11.48 $12.95 -$99.39 $2.95 -81.52% <-Total Growth 10 Net Income
NCI $4.21 $4.46 $3.23 $5.23 $5.32 $4.06 $0.34 $0.28 $0.21 $0.24 $0.20 $2.30 -48.51% <-Total Growth 10 NCI
Shareholders $6.10 $11.52 $9.89 $19.26 $23.73 $18.69 $24.46 $18.78 $11.27 $12.71 -$99.59 $0.66 $11.3 $14.4 -94.31% <-Total Growth 10 Shareholders
Increase 307.70% 88.84% -14.16% 94.83% 23.21% -21.26% 30.92% -23.24% -39.97% 12.77% -883.35% 100.66% 1625.19% 27.43% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $9.7 $14.1 $16.6 $19.2 $21.0 $19.4 $17.2 -$6 -$11 -$12.7 -$12.1 -24.92% <-IRR #YR-> 10 Net Income -94.31%
Operating Cash Flow $4.6 $9.3 $15.7 $37.0 $45.6 $39.5 $31.8 $30.2 $50.8 $20.8 $16.4 $47.7 -51.52% <-IRR #YR-> 5 Net Income -97.32%
Investment Cash Flow -$29.1 -$36.6 -$19.9 -$51.6 -$35.4 -$4.1 -$5.7 -$15.5 -$12.2 -$11.5 -$30.6 -$34.9 #NUM! <-IRR #YR-> 8 5 Yr Running Average -179.69%
Total Accruals $30.6 $38.8 $14.1 $33.9 $13.5 -$16.7 -$1.6 $4.1 -$27.3 $3.4 -$85.4 -$12.1 #NUM! <-IRR #YR-> 5 5 Yr Running Average -158.50%
Total Assets $140.8 $187.1 $449.7 $489.5 $509.8 $495.9 $503.1 $533.1 $512.7 $525.9 $455.6 $463.0 Balance Sheet Assets
Accruals Ratio 21.76% 20.73% 3.14% 6.92% 2.64% -3.36% -0.32% 0.76% -5.32% 0.64% -18.75% -2.62% -2.62% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.53 0.74 0.38 0.48 0.59 0.65 0.58 0.52 0.38 0.67 -3.71 0.02 0.50 <-Median-> 10 EPS/CF Ratio
-$6.1 -$11.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.7
-$24.5 $0.0 $0.0 $0.0 $0.0 $0.7
-$9.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$11.2
-$19.2 $0.0 $0.0 $0.0 $0.0 -$11.2
Change in Close 20.29% 10.06% 24.68% -56.46% 49.76% -3.00% -0.86% 23.32% -24.19% 9.45% -45.65% 25.81% -2.18% 0.00% 0.00% Count 13 Years of data
up/down Down Down Down Down up up Count 6 46.15%
Meet Prediction? Yes Yes % right Count 2 33.33%
Financial Cash Flow $25.6 $28.6 $20.3 -$1.0 -$8.6 $37.2 -$26.1 -$11.4 -$40.1 -$11.2 $14.5 -$9.3 C F Statement Financial Cash Flow
Total Accruals $5.1 $10.2 -$6.2 $34.8 $22.1 -$53.8 $24.5 $15.5 $12.8 $14.6 -$99.9 -$2.9 Accruals
Accruals Ratio 3.59% 5.43% -1.38% 7.12% 4.33% -10.86% 4.87% 2.90% 2.49% 2.77% -21.93% -0.62% 2.49% <-Median-> 5 Ratio
Cash $2.0 $3.4 $19.5 $3.5 $5.3 $2.8 $1.7 $5.1 $4.5 $3.0 $3.8 $7.0 Cash
Cash per Share $0.33 $0.33 $1.07 $0.19 $0.29 $0.12 $0.08 $0.22 $0.20 $0.11 $0.14 $0.25 $0.20 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.89% 1.73% 4.44% 1.84% 1.83% 0.82% 0.50% 1.21% 1.39% 0.72% 1.65% 2.41% 1.39% <-Median-> 5 % of Stock Price
Notes
June 9, 2017. Last estimates were for 2016 and 2017 of $838M and 871M for revenue, $0.62 and $0.77 for EPS and $17.8M and $22.3M for Net Income.
Liquor Stores Income Fund (TSX - LIQ.UN) converted to a corporation on December 31, 2010.
Sector:
Consumer Discretionary, Comsumer
What should this stock accomplish?
Would I buy this company and Why.
Current I would not buy this stock.
For me to consider this stock, I would want to see improvement in Revenue per Shares, ROE and Book Value.
Dividends
Dividends are paid monthly. They are declared for shareholders of record of one month and paid in the following month.
For example, a dividend was declared on March 15, 2016 for shareholders of record of March 31, 2016 and to be paid on April 15, 2016.
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.
For customers
For employees
For community
For investors
Why am I following this stock.
The idea of following this stock came from a reader of my blog.
How they make their money.
Liquor Stores N.A. Ltd. is a Canada-based operator of retail liquor stores. The Company operates over stores in Alberta, British Columbia, New Jersey, Alaska and Kentucky.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date 2013 2014 2015 Jun 07 2016 Jun 9 2017
Bebis, Stephen 0.061 0.22% 0.091 0.33%
CEO - Shares - Amount $0.637 $0.942
Options - percentage 0.293 1.06% 0.356 1.29%
Options - amount $3.086 $3.671
Rudd, Robin Matthew 0.003 0.01%
CFO - Shares - Amount $0.026
Options - percentage 0.018 0.07%
Options - amount $0.190
Gordey, David Nathan 0.023 0.08% 0.026 0.09% Was CFO
COO - Shares - Amount $0.240 $0.266
Options - percentage 0.043 0.16% 0.085 0.31%
Options - amount $0.454 $0.878
Fremstad, Jason Paul 0.002 0.01%
Officer - Shares - Amount $0.016
Options - percentage 0.050 0.18%
Options - amount $0.525
Bereznicki, Henry Andrew 0.460 1.66% 0.460 1.66%
Director - Shares - Amount $4.842 $4.736
Options - percentage 0.005 0.02% 0.006 0.02%
Options - amount $0.053 $0.065
Dinning, James Francis 0.032 0.11% 0.033 0.12%
Chairman - Shares - Amt $0.332 $0.336
Options - percentage 0.023 0.08% 0.028 0.10%
Options - amount $0.245 $0.288
Increase in O/S Shares 0.145 0.63% 0.058 0.21% 0.000 0.00% 0.000 0.00% 0.022 0.08%
Due to SO $2.037 $0.889 $0.000 $0.000 $0.235
Book Value $2.439 $0.990 $0.000 $0.000 $0.315
Insider Buying -$0.750 -$0.015
Insider Selling $0.000 $0.000
Net Insider Selling -$0.750 -$0.015
Net Selling % of Market Cap -0.26% -0.01%
Directors 8 9
Women 1 13% 1 11%
Minorities 0 0% 0 0%
Institutions/Holdings 25 9.65% 25 9.65%
Total Shares Held 2.663 9.62% 0.000 0.00%
Increase/Decrease 3 Mths -0.050 -1.84% -0.050 -100.00%
Starting No. of Shares 2.712 0.050
Copyright 2008 Website of SPBrunner. All rights reserved.