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 2022
Waterloo Brewing Ltd TSX WBR OTC BIBLF https://waterloobrewing.com/ Fiscal Yr: Jan 31
Year 1/31/10 1/31/11 1/31/12 1/31/13 1/31/14 1/31/15 1/31/16 1/31/17 1/31/18 1/31/19 1/31/20 1/31/21 1/31/22 1/31/23 1/31/24 1/30/25 Value Description #Y Item Total G
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
USD - CDN$ 1.0466 0.9946 1.0170 0.9949 1.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2732 1.2719 1.3338 1.3338 1.3338 -1.08% <-IRR #YR-> 5 USD - CDN$
Change -14.54% -4.97% 2.25% -2.17% 6.91% 9.07% 19.36% -3.04% -6.57% 8.74% -4.79% -1.97% -0.10% 4.87% 0.00% 0.00% 2.26% <-IRR #YR-> 10 USD - CDN$
-1.3427 0.0000 0.0000 0.0000 0.0000 1.2719
-1.0170 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 1.2719
$106 <-12 mths -5.32%
Gross Revenue $63.277 $64.733
Net Revenue* $29.916 $30.106 $34.078 $35.770 $37.674 $36.333 $37.610 $45.176 $49.790 $50.084 $60.333 $86.699 $111.765 $112 $124 227.97% <-Total Growth 10 Revenue
Increase 0.10% 0.63% 13.19% 4.97% 5.32% -3.56% 3.51% 20.12% 10.21% 0.59% 20.46% 43.70% 28.91% 0.21% 10.71% 12.61% <-IRR #YR-> 10 Revenue 227.97%
5 year Running Average $25.0 $31.0 $30.9 $32.0 $33.5 $34.8 $36.3 $38.5 $41.3 $43.8 $49 $58 $72 $84.2 $99.0 19.86% <-IRR #YR-> 5 Revenue 147.40%
Revenue per Share $1.06 $1.07 $1.21 $1.19 $1.10 $1.04 $1.08 $1.29 $1.41 $1.41 $1.71 $2.45 $3.11 $3.12 $3.46 8.80% <-IRR #YR-> 10 5 yr Running Average 132.46%
Increase -0.13% 0.52% 12.94% -1.73% -7.71% -5.00% 3.42% 19.65% 9.58% 0.14% 21.19% 42.94% 27.24% 0.21% 10.71% 13.25% <-IRR #YR-> 5 5 yr Running Average 86.26%
5 year Running Average $1.24 $1.16 $1.12 $1.12 $1.12 $1.12 $1.14 $1.18 $1.25 $1.38 $1.65 $2.02 $2.36 $2.77 9.94% <-IRR #YR-> 10 Revenue per Share 157.89%
P/S (Price/Sales) Med 0.54 0.80 0.86 1.15 1.41 1.17 1.39 2.07 2.37 2.58 2.08 1.62 2.10 1.42 0.00 19.32% <-IRR #YR-> 5 Revenue per Share 141.87%
P/S (Price/Sales) Close 0.62 0.88 0.93 1.24 1.25 1.06 1.84 2.34 2.77 1.98 2.04 2.21 1.87 1.00 0.90 5.71% <-IRR #YR-> 10 5 yr Running Average 74.32%
P/S 10 Year Median  0.83 1.01 1.16 1.28 1.40 1.52 1.85 1.85 1.85 12.17% <-IRR #YR-> 5 5 yr Running Average 77.59%
*Revenue in M CDN $  P/S Med 20 yr  1.28 15 yr  1.39 10 yr  1.85 5 yr  2.10 -45.84% Diff M/C
-$34.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $111.8
-$45.2 $0.0 $0.0 $0.0 $0.0 $111.8
-$30.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $71.7
-$38.5 $0.0 $0.0 $0.0 $0.0 $71.7
-$1.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.11
-$1.29 $0.00 $0.00 $0.00 $0.00 $3.11
$0.04 <-12 mths -75.00%
EPS Basic $0.05 $0.10 $0.02 $0.03 $0.02 $0.04 $0.05 $0.11 $0.07 $0.04 $0.01 $0.09 $0.16 700.00% <-Total Growth 10 EPS Basic
EPS Diluted* $0.05 $0.10 $0.02 $0.02 $0.02 $0.04 $0.05 $0.11 $0.07 $0.04 $0.01 $0.08 $0.16 $0.08 $0.17 $0.16 700.00% <-Total Growth 10 EPS Diluted
Increase 116.13% 100.00% -80.00% 0.00% 0.00% 100.00% 25.00% 120.00% -36.36% -42.86% -75.00% 700.00% 100.00% -50.00% 112.50% -6.56% 10 0 10 Years of Data, EPS P or N 100.00%
Earnings Yield 7.58% 10.64% 1.79% 1.36% 1.46% 3.64% 2.53% 3.65% 1.79% 1.43% 0.29% 1.48% 2.75% 2.56% 5.45% 5.09% 23.11% <-IRR #YR-> 10 Earnings per Share 700.00%
5 year Running Average -$0.05 -$0.05 -$0.05 -$0.02 $0.04 $0.04 $0.03 $0.05 $0.06 $0.06 $0.06 $0.06 $0.07 $0.07 $0.10 $0.13 7.78% <-IRR #YR-> 5 Earnings per Share 45.45%
10 year Running Average $0.01 $0.00 -$0.01 $0.00 $0.02 $0.05 $0.05 $0.05 $0.06 $0.07 $0.08 $0.09 #NUM! <-IRR #YR-> 10 5 yr Running Average 238.46%
* Diluted ESP per share  E/P 10 Yrs 1.64% 5Yrs 1.48% 8.45% <-IRR #YR-> 5 5 yr Running Average 50.00%
-$0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16
-$0.11 $0.00 $0.00 $0.00 $0.00 $0.16
$0.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.07
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.07
Dividend* $0.12 Estimate Dividend*
Increase 7.42% Estimate Increase
Payout Ratio EPS 152.00% Estimate Payout Ratio EPS
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 7 Special Dividends
Dividend* $0.048 $0.052 $0.068 $0.085 $0.101 $0.107 $0.1132 $0.1216 $0.1216 $0.1216 117.69% <-Total Growth 6 Dividends
Increase 0.00% 8.33% 30.77% 25.00% 18.82% 5.45% 6.29% 7.42% 0.00% 0.00% 6 0 6 Years of data, Count P, N 100.00%
Average Increases 5 Year Running 0.00% 1.67% 7.82% 12.82% 16.59% 17.67% 17.27% 12.60% 7.60% 3.83% 12.82% <-Median-> 7 Average Incr 5 Year Running
Dividends 5 Yr Running $0.07 $0.08 $0.09 $0.11 $0.11 $0.12 14.84% <-Total Growth 2 Dividends 5 Yr Running
Yield H/L Price 3.21% 1.95% 2.03% 2.33% 2.83% 2.68% 1.73% 2.75% 2.33% <-Median-> 7 Yield H/L Price
Yield on High  Price 2.40% 1.53% 1.66% 1.81% 2.46% 1.84% 1.42% 2.08% 1.81% <-Median-> 7 Yield on High  Price
Yield on Low Price 4.85% 2.68% 2.62% 3.28% 3.33% 4.95% 2.22% 4.05% 3.28% <-Median-> 7 Yield on Low Price
Yield on Close Price 2.42% 1.73% 1.74% 3.04% 2.89% 1.97% 1.95% 3.90% 3.90% 3.90% 1.97% <-Median-> 7 Yield on Close Price
Payout Ratio EPS 96.00% 47.27% 97.14% 212.50% 1010.00% 133.13% 70.75% 152.00% 71.53% 76.55% $0.97 <-Median-> 7 DPR EPS
DPR EPS 5 Yr Running 0.00% 0.00% 0.00% 0.00% 126.43% 133.06% 131.58% 142.51% 112.78% 90.08% $0.00 <-Median-> 7 DPR EPS 5 Yr Running
Payout Ratio CFPS 28.52% 18.68% 105.19% 39.44% 26.53% 29.29% 90.75% 30.40% 25.33% #DIV/0! $0.29 <-Median-> 7 DPR CF
DPR CF 5 Yr Running 0.00% 0.00% 0.00% 0.00% 31.96% 31.66% 41.22% 35.52% 32.24% #DIV/0! $0.00 <-Median-> 7 DPR CF 5 Yr Running
Payout Ratio CFPS WC 29.77% 20.63% 29.31% 39.86% 36.50% 24.85% 19.07% 30.40% 25.33% #DIV/0! $0.29 <-Median-> 7 DPR CF WC
DPR CF WC 5 Yr Running 0.00% 0.00% 0.00% 0.00% 31.18% 29.41% 27.16% 27.58% 25.88% #DIV/0! $0.00 <-Median-> 7 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 2.33% 1.97% 5 Yr Med 5 Yr Cl 2.33% 1.97% 5 Yr Med Payout 133.13% 39.44% 29.31% 18.72% <-IRR #YR-> 5 Dividends 117.69%
* Dividends per share  10 Yr Med and Cur. 67.13% 97.62% 5 Yr Med and Cur. 67.13% 97.62% Last Div Inc ---> $0.0276 $0.0304 10.14% 15.37% <-IRR #YR-> 6 Dividends #DIV/0!
Dividends Growth 15 #NUM! <-IRR #YR-> 15 Dividends #DIV/0!
Dividends Growth 5 -$0.05 $0.00 $0.00 $0.00 $0.00 $0.11 Dividends Growth 5
Dividends Growth 10 -$0.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.11 Dividends Growth 10
Dividends Growth 15 $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.11 Dividends Growth 15
Historical Dividends Historical High Div 4.89% Low Div 1.49% 10 Yr High 4.89% 10 Yr Low 1.49% Med Div 2.33% Close Div 1.97% Historical Dividends
High/Ave/Median Values Curr diff Exp. -20.30% Cheap 161.57% Exp. -20.30% 161.57% Cheap 67.27% Cheap 97.62% High/Ave/Median 
Future Dividend Yield Div Yield 9.19% earning in 5 Years at IRR of 18.72% Div Inc. 135.83% Future Dividend Yield
Future Dividend Yield Div Yield 21.68% earning in 10 Years at IRR of 18.72% Div Inc. 456.17% Future Dividend Yield
Future Dividend Yield Div Yield 51.12% earning in 15 Years at IRR of 18.72% Div Inc. 1211.64% Future Dividend Yield
Future Dividend Paid Div Paid $0.29 earning in 5 Years at IRR of 18.72% Div Inc. 135.83% Future Dividend Paid
Future Dividend Paid Div Paid $0.68 earning in 10 Years at IRR of 18.72% Div Inc. 456.17% Future Dividend Paid
Future Dividend Paid Div Paid $1.59 earning in 15 Years at IRR of 18.72% Div Inc. 1211.64% Future Dividend Paid
Dividend Covering Cost Total Div $0.88 over 5 Years at IRR of 18.72% Div Cov. 28.28% Dividend Covering Cost
Dividend Covering Cost Total Div $2.68 over 10 Years at IRR of 18.72% Div Cov. 85.79% Dividend Covering Cost
Dividend Covering Cost Total Div $6.91 over 15 Years at IRR of 18.72% Div Cov. 221.40% Dividend Covering Cost
Yield if held 5 years 5.58% 5.00% 4.98% 5.50% 8.28% 7.12% 4.25% 3.63% 3.34% 3.41% 5.50% <-Median-> 7 Paid Median Price
Yield if held 10 years 17.72% 12.38% 10.88% 8.91% 7.87% 9.97% 12.38% <-Median-> 3 Paid Median Price
Yield if held 15 years 21.33% #NUM! <-Median-> 0 Paid Median Price
Yield if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Yield if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 5.58% 9.62% 12.31% 16.38% 29.02% 27.59% 17.77% 15.74% 15.47% 16.40% 16.38% <-Median-> 7 Paid Median Price
Cost covered if held 10 years 62.11% 53.55% 55.16% 50.94% 52.87% 76.93% 55.16% <-Median-> 3 Paid Median Price
Cost covered if held 15 years 164.65% #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
Earnings less Dividends -$0.27 -$0.26 -$0.12 $0.21 $0.20 $0.10 $0.14 $0.12 $0.06 -$0.07 -$0.10 -$0.11 $1 Test WJX
Change in MV per Share -$1.28 -$0.67 $0.65 $1.05 $0.44 $1.04 $1.89 $2.44 $1.43 $2.40 $3.42 $2.80 $1 Test
Ratio 4.74 2.58 -5.42 5.00 2.20 10.20 13.50 20.00 25.09 -32.43 -33.37 -24.63 $1 Test
Increase in Earnings 5 years -$0.04 $0.01 $0.14 $0.33 -$0.01 -$0.05 $0.09 $0.05 $0.02 -$0.03 $0.03 $0.05 Increase in Earnings 5 years KBL
Rate profits have increased 14.81% -3.85% -116.67% 157.14% -5.00% -49.02% 64.29% 40.98% 35.09% 40.54% -29.27% -43.98% Rate profits have increased
Revenue Growth  $45.18 $49.79 $50.08 $60.33 $86.70 $111.77 $403.85 147.40% <-Total Growth 5 Revenue Growth 
EPS Growth $0.11 $0.07 $0.04 $0.01 $0.09 $0.16 $0.48 45.45% <-Total Growth 5 EPS Growth
Net Income Growth $1.59 $4.00 $2.60 $1.29 $0.50 $3.00 $12.98 88.19% <-Total Growth 5 Net Income Growth
Cash Flow Growth $9.77 $2.28 $7.64 $13.41 $12.88 $4.48 $50.45 -118.23% <-Total Growth 5 Cash Flow Growth
Dividend Growth $0.05 $0.07 $0.09 $0.10 $0.11 $0.11 $0.53 117.69% <-Total Growth 5 Dividend Growth
Stock Price Growth $3.01 $3.91 $2.80 $3.50 $5.40 $5.81 93.02% <-Total Growth 5 Stock Price Growth
Revenue Growth  $34.08 $35.77 $37.67 $36.33 $37.61 $45.18 $49.79 $50.08 $60.33 $86.70 $111.77 $585.31 227.97% <-Total Growth 10 Revenue Growth 
EPS Growth $0.02 $0.03 $0.02 $0.04 $0.05 $0.11 $0.07 $0.04 $0.01 $0.09 $0.16 $0.64 700.00% <-Total Growth 10 EPS Growth
Net Income Growth $2.95 $0.66 $0.73 $0.53 $1.40 $1.59 $4.00 $2.60 $1.29 $0.50 $3.00 $19.24 1.73% <-Total Growth 10 Net Income Growth
Cash Flow Growth $4.44 $2.53 $3.00 $3.96 $5.88 $9.77 $2.28 $7.64 $13.41 $12.88 $4.48 $70.27 0.74% <-Total Growth 10 Cash Flow Growth
Dividend Growth $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $0.11 135.83% <-Total Growth 6 Dividend Growth
Stock Price Growth $1.12 $1.47 $1.37 $1.10 $1.98 $3.01 $3.91 $2.80 $3.50 $5.40 $5.81 418.75% <-Total Growth 10 Stock Price Growth
Dividends on Shares $0.00 $0.00 $0.00 $42.86 $46.44 $60.72 $75.91 $90.19 $95.10 $101.09 $108.59 $108.59 $108.59 $512.31 No of Years 10 Total Dividends 12/31/11
Paid  $1,000.16 $1,312.71 $1,223.41 $982.30 $1,768.14 $2,687.93 $3,491.63 $2,500.40 $3,125.50 $4,822.20 $5,188.33 $2,786.16 $2,786.16 $2,786.16 $5,188.33 No of Years 10 Worth $1.12
Total $5,700.64
Graham Number $0.94 $1.42 $0.66 $0.66 $0.65 $0.94 $1.07 $1.63 $1.31 $0.97 $0.47 $1.31 $1.92 $1.32 $1.93 $1.86 189.84% <-Total Growth 10 Graham Number $5.89
Increase 2.94% 50.79% -53.51% 0.38% -1.88% 44.34% 13.60% 52.77% -20.05% -25.74% -52.04% 181.29% 46.68% -31.14% 45.77% -3.34% 6.99% <-Median-> 10 Increase P/GP Ratio
Price/GP Ratio Med 0.60 0.60 1.57 2.05 2.37 1.30 1.40 1.63 2.56 3.76 7.66 3.03 3.41 3.35 2.47 <-Median-> 10 Price/GP Ratio Med #DIV/0!
Price/GP Ratio High 0.85 0.75 1.72 2.51 2.96 1.49 1.87 2.07 3.14 4.85 8.81 4.42 4.16 4.43 3.05 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 0.36 0.46 1.42 1.59 1.78 1.10 0.93 1.19 1.99 2.67 6.51 1.64 2.66 2.27 1.71 <-Median-> 10 Price/GP Ratio Low 2001
Price/GP Ratio Close 0.70 0.66 1.69 2.21 2.10 1.17 1.85 1.84 2.99 2.89 7.52 4.13 3.03 2.36 1.62 1.68 2.55 <-Median-> 10 Price/GP Ratio Close $5.95
Prem/Disc Close -30.14% -34.01% 69.13% 121.15% 110.05% 16.84% 85.14% 84.23% 199.33% 188.65% 652.35% 312.66% 202.69% 136.05% 61.93% 67.52% 154.90% <-Median-> 10 Graham Price P/GP Ratio
0.10
GN Based on EPS 3 Yrs EPS $0.30 $0.58 $1.05 $1.12 $1.00 $0.67 $0.78 $0.94 $1.27 $1.34 $1.26 $0.93 $1.00 $1.35 $1.53 $1.73 Based on EPS 3 Yrs EPS 2004
Increase 91.36% 80.04% 6.86% -10.96% -33.18% 17.32% 20.78% 35.14% 5.35% -6.19% -26.55% 7.95% 35.05% 13.14% 13.19% -90.06% <-Total Growth 10 Increase
Price/GP Ratio Med 1.88 1.48 0.99 1.22 1.55 1.83 1.91 2.83 2.63 2.71 2.83 4.29 6.55 3.28 267.10% <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 2.63 1.84 1.09 1.49 1.94 2.10 2.56 3.59 3.22 3.50 3.25 6.26 8.00 4.34 3.24 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 1.12 1.12 0.90 0.95 1.16 1.56 1.27 2.06 2.04 1.93 2.41 2.32 5.11 2.22 1.98 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 2.17 1.62 1.07 1.31 1.38 1.65 2.54 3.19 3.07 2.08 2.78 5.84 5.82 2.31 2.04 1.81 2.66 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close 117.17% 61.63% 6.96% 31.38% 37.51% 65.24% 153.52% 219.10% 206.72% 108.49% 177.82% 483.58% 481.64% 131.28% 104.42% 80.60% 1.66 <-Median-> 10 Graham Price
Month, Year Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 31.00 <Count Years> Month, Year
Price Close $0.66 $0.94 $1.12 $1.47 $1.37 $1.10 $1.98 $3.01 $3.91 $2.80 $3.50 $5.40 $5.81 $3.12 $3.12 $3.12 418.75% <-Total Growth 10 Stock Price
Increase 106.25% 42.42% 19.15% 31.25% -6.80% -19.71% 80.00% 52.02% 29.90% -28.39% 25.00% 54.29% 7.59% -46.30% 0.00% 0.00% 44.17 <-Median-> 10 CAPE (10 Yr P/E)
P/E Ratio 13.20 9.40 56.00 73.50 68.50 27.50 39.60 27.36 55.86 70.00 350.00 67.50 36.31 39.00 18.35 19.64 14.06% <-IRR #YR-> 5 Stock Price 93.02%
Trailing P/E Ratio -2.13 18.80 11.20 73.50 68.50 55.00 49.50 60.20 35.55 40.00 87.50 540.00 72.63 19.50 39.00 18.35 17.90% <-IRR #YR-> 10 Stock Price 418.75%
CAPE (10 Yr P/E) 183.43 -393.67 -96.42 -639.50 93.41 35.31 44.17 55.78 50.58 48.48 41.67 38.51 16.44% <-IRR #YR-> 5 Price & Dividend 108.76%
Median 10, 5 Yrs D.  per yr 1.78% 2.38% % Tot Ret 9.05% 14.50% T P/E $64.35 $72.63 P/E:  $61.68 $67.50 19.67% <-IRR #YR-> 10 Price & Dividend 469.97%
Price 15 D.  per yr 0.84% % Tot Ret 9.34% CAPE Diff -11.70% 8.17% <-IRR #YR-> 15 Stock Price 224.58%
Price  20 D.  per yr 0.76% % Tot Ret 5.21% 13.77% <-IRR #YR-> 20 Stock Price 1220.45%
Price  25 D.  per yr 0.45% % Tot Ret 8.30% 4.97% <-IRR #YR-> 25 Stock Price 235.84%
Price  30 D.  per yr 0.36% % Tot Ret 8.16% 4.08% <-IRR #YR-> 30 Stock Price
Price  35 D.  per yr 0.35% % Tot Ret 8.13% 3.95% <-IRR #YR-> 31 Stock Price
Price & Dividend 15 9.01% <-IRR #YR-> 15 Price & Dividend 256.63%
Price & Dividend 20 14.53% <-IRR #YR-> 20 Price & Dividend 1350.84%
Price & Dividend 25 5.41% <-IRR #YR-> 25 Price & Dividend 269.00%
Price & Dividend 30 4.44% <-IRR #YR-> 30 Price & Dividend
Price & Dividend 35 4.30% <-IRR #YR-> 31 Stock Price
Price  5 -$3.01 $0.00 $0.00 $0.00 $0.00 $5.81 Price  5
Price 10 -$1.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.81 Price 10
Price & Dividend 5 -$3.01 $0.07 $0.09 $0.10 $0.11 $5.92 Price & Dividend 5
Price & Dividend 10 -$1.12 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $5.92 Price & Dividend 10
Price  15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.81 Price  15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.81 Price  20
Price  25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.81 Price  25
Price  30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.81 Price  30
Price  35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.81 Price  35
Price & Dividend 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $5.92 Price & Dividend 15
Price & Dividend 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $5.92 Price & Dividend 20
Price & Dividend 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $5.92 Price & Dividend 25
Price & Dividend 30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $5.92 Price & Dividend 30
Price & Dividend 35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $5.92 Price & Dividend 35
Month, Year Jan-10 Jan-11 Jan-12 Jan-13 Jan-14 Jan-15 Jan-16 Jan-17 Jan-18 Jan-19 Jan-20 Jan-21 Jan-22 Jan-23 Jan-24 Jan-25 31.00 <Count Years> Month, Year
Price Close $0.69 $0.95 $1.08 $1.47 $1.40 $1.08 $1.99 $2.65 $3.90 $3.28 $3.23 $5.27 $5.62 $3.12 $3.12 $3.12 420.37% <-Total Growth 10 Stock Price
Increase 86.49% 37.68% 13.68% 36.11% -4.76% -22.86% 84.26% 33.17% 47.17% -15.90% -1.52% 63.16% 6.64% -44.48% 0.00% 0.00% #DIV/0! <-Median-> 10 CAPE (10 Yr P/E)
P/E Ratio 13.20 9.40 56.00 73.50 68.50 27.50 39.60 27.36 55.86 70.00 350.00 67.50 36.31 39.00 18.35 19.64 16.22% <-IRR #YR-> 5 Stock Price 112.08%
Trailing P/E Ratio -2.13 18.80 11.20 73.50 68.50 55.00 49.50 60.20 35.55 40.00 87.50 16.49 17.75 7.57 8.78 9.68 17.93% <-IRR #YR-> 10 Stock Price 420.37%
CAPE (10 Yr P/E) #DIV/0! #DIV/0! #DIV/0! #DIV/0! 183.43 -393.67 -96.42 -639.50 93.41 35.31 44.17 83.39 29.46 #DIV/0! #DIV/0! #DIV/0! 18.84% <-IRR #YR-> 5 Price & Dividend 114.26%
Median 10, 5 Yrs D.  per yr 1.84% 2.61% % Tot Ret 9.31% 13.87% T P/E $52.25 $35.55 P/E:  $61.68 $67.50 19.77% <-IRR #YR-> 10 Price & Dividend 436.17%
Price  5 -$2.65 $0.00 $0.00 $0.00 $0.00 $5.62 Price  5 TD bank
Price 10 -$1.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.62 Price 10 POW 30
Price & Dividend 5 -$2.65 $0.07 $0.09 $0.10 $0.11 $5.73 Price & Dividend 5
Price & Dividend 10 -$1.08 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $5.73 Price & Dividend 10 to year 35
Price H/L Median $0.57 $0.86 $1.04 $1.37 $1.55 $1.22 $1.50 $2.67 $3.35 $3.65 $3.57 $3.97 $6.55 $4.43 529.33% <-Total Growth 10 Stock Price
Increase 50.88% 20.93% 31.25% 13.19% -21.04% 22.54% 78.26% 25.70% 8.81% -2.19% 11.36% 64.86% -32.39% 19.69% <-IRR #YR-> 5 Stock Price 145.59%
P/E Ratio 11.40 8.60 52.00 68.25 77.25 30.50 29.90 24.23 47.86 91.13 356.50 49.63 40.91 55.31 20.20% <-IRR #YR-> 10 Stock Price 529.33%
Trailing P/E Ratio -1.84 17.20 10.40 68.25 77.25 61.00 37.38 53.30 30.45 52.07 89.13 397.00 81.81 27.66 22.14% <-IRR #YR-> 5 Price & Dividend 163.37%
P/E on Running 5 yr Average -12.39 -15.93 -20.00 -56.88 36.79 30.50 49.83 55.52 57.76 58.79 63.66 64.03 90.90 59.80 21.91% <-IRR #YR-> 10 Price & Dividend 584.49%
P/E on Running 10 yr Average #DIV/0! #DIV/0! #DIV/0! #DIV/0! 220.71 -406.67 -124.58 -1332.50 197.06 70.10 74.27 86.30 109.08 67.05 47.86 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 2.46% 1.71% % Tot Ret 11.10% 7.82% T P/E 64.63 81.81 P/E:  48.74 49.63 Count 12 Years of data
-$2.67 $0.00 $0.00 $0.00 $0.00 $6.55
-$1.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.55
-$2.67 $0.07 $0.09 $0.10 $0.11 $6.66
-$1.04 $0.00 $0.00 $0.00 $0.05 $0.05 $0.07 $0.09 $0.10 $0.11 $6.66
High Months Sep 09 Oct 10 Oct 11 Aug 12 May 13 Feb 14 Dec 15 Oct 16 Jan 18 Mar 18 Mar 19 Jan 21 May 21 Feb 22
Price High $0.80 $1.07 $1.14 $1.67 $1.93 $1.40 $2.00 $3.39 $4.10 $4.70 $4.10 $5.79 $7.99 $5.85 600.88% <-Total Growth 10 Stock Price
Increase 33.75% 6.54% 46.49% 15.57% -27.46% 42.86% 69.50% 20.94% 14.63% -12.77% 41.22% 38.00% -26.78% 18.71% <-IRR #YR-> 5 Stock Price 135.69%
P/E Ratio 16.00 10.70 57.00 83.50 96.50 35.00 40.00 30.82 58.57 117.50 410.00 72.38 49.94 73.13 21.50% <-IRR #YR-> 10 Stock Price 600.88%
Trailing P/E Ratio -2.58 21.40 11.40 83.50 96.50 70.00 50.00 67.80 37.27 67.14 102.50 579.00 99.88 36.56 57.00 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 76.75 99.88 P/E:  65.47 72.38 293.00 P/E Ratio Historical High
-$3.39 $0.00 $0.00 $0.00 $0.00 $7.99
-$1.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.99
Low Months Feb 09 Feb 10 Feb 11 Feb 12 Nov 13 Jan 15 Feb 15 Feb 16 Feb 17 Dec 18 Nov 19 Mar 20 Feb 21 Sep 22
Price Low $0.34 $0.65 $0.94 $1.06 $1.16 $1.04 $0.99 $1.94 $2.60 $2.59 $3.03 $2.15 $5.10 $3.00 442.55% <-Total Growth 10 Stock Price
Increase 91.18% 44.62% 12.77% 9.43% -10.34% -4.81% 95.96% 34.02% -0.38% 16.99% -29.04% 137.21% -41.18% 21.33% <-IRR #YR-> 5 Stock Price 162.89%
P/E Ratio 6.80 6.50 47.00 53.00 58.00 26.00 19.80 17.64 37.14 64.75 303.00 26.88 31.88 37.50 18.43% <-IRR #YR-> 10 Stock Price 442.55%
Trailing P/E Ratio 13.00 9.40 53.00 58.00 52.00 24.75 38.80 23.64 37.00 75.75 215.00 63.75 18.75 31.88 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 52.50 63.75 P/E:  34.51 37.14 6.62 P/E Ratio Historical Low
-$0.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.10
$10 <-12 mths 163.25% WSJ
Free Cash Flow WSJ $7.189 -$5.879 $0.706 $2.397 -$5.53 -$4.83 $10.1 $11.7 0.00% <-Total Growth 5 Free Cash Flow WSJ
Change -181.78% 112.01% 239.39% -330.73% 12.72% 309.26% 15.84% 0.13 <-Median-> 5 Change
Free Cash Flow MS -$0.078 -$2.741 -$4.858 -$0.483 $1.511 $2.794 $7.045 -$6.161 $0.637 $2.260 -$7.51 $3.68 $10.10 $11.70 234.37% <-Total Growth 10 Free Cash Flow
Change -3414% -77.23% 90.06% 412.84% 84.91% 152.15% -187.45% 110.34% 254.79% -432.08% 149.07% 174.23% 15.84% -12.17% <-IRR #YR-> 5 Free Cash Flow MS -47.72%
FCF/CF from Op Ratio -0.02 -0.62 -1.92 -0.16 0.38 0.48 0.72 -2.70 0.08 0.17 -0.58 0.82 0.70 0.68 #NUM! <-IRR #YR-> 10 Free Cash Flow MS 234.37%
Dividends paid $0.42 $1.82 $2.39 $3.01 $3.58 $3.75 $4.05 $4.36 $4.36 863.78% <-Total Growth 6 Dividends paid
Percentage paid 15.03% 25.86% -38.82% 472.66% 158.25% -49.95% 109.88% 43.20% 37.30% $0.26 <-Median-> 7 Percentage paid
5 Year Coverage 170.66% -390.71% -236.73% 204.32% 99.31% 5 Year Coverage
Dividend Coverage Ratio 6.65 3.87 -2.58 0.21 0.63 -2.00 0.91 2.31 2.68 0.63 <-Median-> 7 Dividend Coverage Ratio
5 Year of Coverage 0.59 -0.26 -0.42 0.49 1.01 5 Year of Coverage
Market Cap in $M $18.6 $26.5 $31.6 $44.3 $47.1 $38.4 $69.2 $105.6 $138.0 $99.2 $123.3 $191.3 $208.5 $112.0 $112.0 $112.0 559.73% <-Total Growth 10 Market Cap 559.73%
Diluted # of Shares in Million 28.09 29.21 30.72 30.90 32.81 34.73 35.05 35.29 35.43 35.46 35.42 35.48 36.49 36.49 36.49 36.49 18.77% <-Total Growth 10 Diluted # of Shares in Million
Change 18.68% 4.01% 5.17% 0.56% 6.21% 5.83% 0.92% 0.71% 0.39% 0.09% -0.11% 0.15% 2.86% 0.00% 0.00% 0.00% 1.74% <-IRR #YR-> 10 Change
Difference Diluted/Basic -0.1% -3.7% -8.3% -8.3% -0.9% 0.0% -0.4% -0.8% -0.8% -0.2% -0.2% -0.7% -2.2% -2.2% -2.2% -2.2% 0.67% <-IRR #YR-> 5 Difference Diluted/Basic
Change in Diluted Shares per Year
Basic # of Shares in Millions 28.07 28.12 28.18 28.35 32.50 34.72 34.90 35.02 35.15 35.40 35.34 35.22 35.69 35.69 35.69 35.69 26.65% <-Total Growth 10 Basic
Change 18.60% 0.20% 0.20% 0.58% 14.67% 6.83% 0.52% 0.34% 0.38% 0.70% -0.16% -0.33% 1.33% 0.00% 0.00% 0.00% 0.55% <-Median-> 10 Change
Difference Basic/Outstanding 0.18% 0.10% 0.13% 6.33% 5.82% 0.55% 0.12% 0.17% 0.37% 0.12% -0.32% 0.55% 0.54% 0.54% 0.54% 0.54% 0.46% <-Median-> 10 Difference Basic/Outstanding
$6.070 <-12 mths 35.60%
# of Share in Millions 28.120 28.153 28.216 30.139 34.393 34.914 34.945 35.082 35.285 35.443 35.230 35.418 35.884 35.884 35.884 35.884 2.43% <-IRR #YR-> 10 Shares 27.18%
Change 0.23% 0.11% 0.23% 6.81% 14.11% 1.52% 0.09% 0.39% 0.58% 0.45% -0.60% 0.53% 1.32% 0.00% 0.00% 0.00% 0.45% <-IRR #YR-> 5 Shares 2.29%
Cash Flow from Operations $M $2.0 $3.4 $4.4 $2.5 $3.0 $4.0 $5.9 $9.8 $2.3 $7.6 $13.4 $12.9 $4.5 $14.4 $17.2 0.74% <-Total Growth 10 Cash Flow
Increase -2.02% 74.60% 28.95% -43.13% 18.88% 31.82% 48.55% 66.07% -76.65% 234.83% 75.59% -3.98% -65.24% 220.67% 20.00% Why increase decrease
5 year Running Average $0.3 $1.0 $2.2 $2.9 $3.1 $3.5 $4.0 $5.0 $5.0 $5.9 $7.8 $9.2 $8.1 $10.6 $12.5 268.52% <-Total Growth 10 CF 5 Yr Running
CFPS $0.07 $0.12 $0.16 $0.08 $0.09 $0.11 $0.17 $0.28 $0.06 $0.22 $0.38 $0.36 $0.12 $0.40 $0.48 -20.79% <-Total Growth 10 Cash Flow per Share
Increase -2.24% 74.40% 28.66% -46.76% 4.17% 29.85% 48.41% 65.42% -76.78% 233.34% 76.65% -4.49% -65.69% 220.67% 20.00% 0.07% <-IRR #YR-> 10 Cash Flow 0.74%
5 year Running Average $0.00 $0.03 $0.08 $0.10 $0.10 $0.11 $0.12 $0.15 $0.14 $0.17 $0.22 $0.26 $0.23 $0.30 $0.35 -14.45% <-IRR #YR-> 5 Cash Flow -54.18%
P/CF on Med Price 8.12 7.03 6.60 16.28 17.69 10.76 8.88 9.57 51.82 16.91 9.37 10.92 52.47 11.06 0.00 -2.30% <-IRR #YR-> 10 Cash Flow per Share -20.79%
P/CF on Closing Price 9.40 7.68 7.11 17.53 15.69 9.70 11.76 10.81 60.48 12.99 9.19 14.85 46.58 7.80 6.50 -14.84% <-IRR #YR-> 5 Cash Flow per Share -55.20%
-42.65% Diff M/C 11.60% <-IRR #YR-> 10 CFPS 5 yr Running 199.63%
$16.71 <-12 mths -21.55%
Excl.Working Capital CF $1.0 $0.2 -$0.6 $2.0 $1.6 $1.4 -$0.2 -$0.9 $5.9 -$0.1 -$3.7 $2.3 $16.8 $0.0 $0.0 9.46% <-IRR #YR-> 5 CFPS 5 yr Running 57.12%
Cash Flow from Operations $M WC $3.0 $3.6 $3.9 $4.5 $4.6 $5.4 $5.6 $8.8 $8.2 $7.6 $9.7 $15.2 $21.3 $14.4 $17.2 451.95% <-Total Growth 10 Cash Flow less WC
Increase 485.32% 20.87% 6.06% 16.31% 2.04% 17.70% 4.54% 56.96% -7.42% -7.69% 28.97% 55.73% 40.29% -32.60% 20.00% 18.63% <-IRR #YR-> 10 Cash Flow less WC 451.95%
5 year Running Average $0.7 $1.4 $1.7 $2.8 $3.9 $4.4 $4.8 $5.8 $6.5 $7.1 $8.0 $9.9 $12.4 $13.6 $15.6 19.22% <-IRR #YR-> 5 Cash Flow less WC 140.81%
CFPS Excl. WC $0.11 $0.13 $0.14 $0.15 $0.13 $0.15 $0.16 $0.25 $0.23 $0.21 $0.28 $0.43 $0.59 $0.40 $0.48 21.75% <-IRR #YR-> 10 CF less WC 5 Yr Run 615.54%
Increase 484.45% 20.73% 5.82% 8.89% -10.58% 15.94% 4.44% 56.35% -7.95% -8.10% 29.74% 54.90% 38.47% -32.60% 20.00% 16.45% <-IRR #YR-> 5 CF less WC 5 Yr Run 114.17%
5 year Running Average $0.03 $0.05 $0.06 $0.10 $0.13 $0.14 $0.15 $0.17 $0.19 $0.20 $0.23 $0.28 $0.35 $0.38 $0.44 15.81% <-IRR #YR-> 10 CFPS - Less WC 334.00%
P/CF on Median Price 5.33 6.66 7.61 9.17 11.60 7.90 9.27 10.57 14.44 17.09 12.88 9.26 11.03 11.06 0.00 18.68% <-IRR #YR-> 5 CFPS - Less WC 135.43%
P/CF on Closing Price 6.17 7.27 8.19 9.87 10.29 7.13 12.28 11.94 16.85 13.13 12.65 12.60 9.79 7.80 6.50 19.39% <-IRR #YR-> 10 CFPS 5 yr Running 488.35%
*Operational Cash Flow. CF/-WC P/CF Med 10 yr 13.60 5 yr  16.91 P/CF Med 10 yr 10.80 5 yr  12.88 -27.78% Diff M/C 15.47% <-IRR #YR-> 5 CFPS 5 yr Running 105.25%
-$0.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.12 Cash Flow per Share
-$0.28 $0.00 $0.00 $0.00 $0.00 $0.12 Cash Flow per Share
-$0.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.23 CFPS 5 yr Running
-$0.15 $0.00 $0.00 $0.00 $0.00 $0.23 CFPS 5 yr Running
-$3.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $21.3 Cash Flow less WC
-$8.8 $0.0 $0.0 $0.0 $0.0 $21.3 Cash Flow less WC
-$1.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $12.4 CF less WC 5 Yr Run
-$5.8 $0.0 $0.0 $0.0 $0.0 $12.4 CF less WC 5 Yr Run
-$0.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.59 CFPS - Less WC
-$0.25 $0.00 $0.00 $0.00 $0.00 $0.59 CFPS - Less WC
For banks, use Net Income, not CF
OPM Ratio 6.60% 11.45% 13.04% 7.06% 7.97% 10.90% 15.64% 21.62% 4.58% 15.25% 22.23% 14.85% 4.00% 12.82% -69.28% <-Total Growth 10 OPM
Increase -2.12% 73.50% 13.92% -45.82% 12.87% 36.68% 43.50% 38.25% -78.81% 232.86% 45.76% -33.18% -73.04% 220.00% Should increase  or be stable.
Diff from Median -48.8% -11.1% 1.3% -45.1% -38.1% -15.4% 21.5% 67.9% -64.4% 18.4% 72.6% 15.4% -68.9% -0.5% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 12.88% 5 Yrs 14.85% should be  zero, it is a   check on calculations
Long Term Debt $1.25 $3.03 $5.89 $6.08 $4.27 $2.64 $1.55 $2.50 $6.02 $8.42 $13.34 $1.37 $21.75 $23.04 Debt
Change -39.47% 141.79% 94.61% 3.20% -29.84% -38.04% -41.40% 61.35% 140.91% 39.90% 58.45% -89.75% 1490.12% 5.94% 21.55% <-Median-> 10 Change
Debt/Market Cap Ratio 0.07 0.11 0.19 0.14 0.09 0.07 0.02 0.02 0.04 0.08 0.11 0.01 0.10 0.21 0.08 <-Median-> 5 Debt/Market Cap Ratio
Assets/Current Liabilities Ratio 4.99 5.53 4.44 4.82 4.98 7.09 7.13 5.00 6.20 4.80 4.77 2.12 3.25 3.04 4.77 <-Median-> 5 Assets/Current Liabilities Ratio
Debt to Cash Flow (Years) 0.63 0.88 1.33 2.41 1.42 0.67 0.26 0.26 2.64 1.10 0.99 0.11 4.86 1.61 1.10 <-Median-> 5 Debt to Cash Flow (Years)
Intangibles $5.73 $6.06 $13.83 $14.26 $0.00 $15.11 $15.38 $15.50 $15.38 $15.25 $15.18 $15.00 $14.85 $15.21
Goodwill $0.00 $0.00 $0.00 $0.00 $14.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total $5.73 $6.06 $13.83 $14.26 $14.75 $15.11 $15.38 $15.50 $15.38 $15.25 $15.18 $15.00 $14.85 $15.21 Intangibles Goodwill
Change 6.12% 5.76% 128.12% 3.11% 3.46% 2.45% 1.73% 0.81% -0.76% -0.83% -0.45% -1.20% -1.04% 2.48% 0.18% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.31 0.23 0.44 0.32 0.31 0.39 0.22 0.15 0.11 0.15 0.12 0.08 0.07 0.14 0.15 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $8.587 $10.854 $8.847 $9.497 $13.618 $10.838 $10.216 $16.080 $15.504 $15.731 $16.247 $24.945 $32.122 $35.547 Liquidity ratio of 1.5 and up, best Quick Ratio
Current Liabilities $5.943 $6.277 $9.751 $9.428 $9.302 $6.335 $6.855 $11.141 $9.406 $12.858 $19.509 $54.397 $40.386 $43.748 1.33 <-Median-> 10 Ratio
Liquidity Ratio 1.44 1.73 0.91 1.01 1.46 1.71 1.49 1.44 1.65 1.22 0.83 0.46 0.80 0.81 0.83 <-Median-> 5 Ratio
Liq. with CF aft div 1.78 2.28 1.36 1.28 1.79 2.34 1.20 1.24 1.31 0.99 1.29 0.65 0.82 1.04 0.99 <-Median-> 5 Ratio If Div = 0
Liq. with CF aft div (WC) 1.95 2.31 1.30 1.48 1.96 2.56 1.86 1.92 2.01 1.47 1.13 0.69 1.20 1.04
Liq. CF re  Inv+Div  1.19 1.46 0.79 0.87 1.32 2.18 0.99 1.30 0.96 0.34 -3.34 0.28 0.67 0.64 0.34 <-Median-> 5 Ratio
Curr Long Term Debt $0.816 $0.624 $1.481 $6.079 $1.557 $1.623 $1.232 $0.744 $1.332 $1.860 $2.946 $0.510 $5.328 $6.445 $1.9 <-Median-> 5 Ratio
Liquidity Less CLTD 1.67 1.92 1.07 2.84 1.76 2.30 1.82 1.55 1.92 1.43 0.98 0.46 0.92 0.95 0.98 <-Median-> 5 Ratio
Liq. with CF aft div 2.06 2.53 1.61 3.59 2.15 3.14 2.21 2.12 1.70 1.67 1.47 0.66 0.94 1.20 1.47 <-Median-> 5 Ratio
Assets $29.643 $34.720 $43.321 $45.425 $46.369 $44.934 $48.840 $55.751 $58.329 $61.765 $93.131 $115.464 $131.434 $133.167 Debt Ratio of 1.5 and up, best Current Ratio
Liabilities $7.333 $9.328 $15.823 $15.833 $13.856 $10.552 $13.315 $17.915 $20.102 $24.708 $59.245 $81.769 $94.710 $98.338 2.89 <-Median-> 10 Ratio
Debt Ratio 4.04 3.72 2.74 2.87 3.35 4.26 3.67 3.11 2.90 2.50 1.57 1.41 1.39 1.35 1.57 <-Median-> 5 Ratio
Book Value $22.310 $25.392 $27.498 $29.593 $32.513 $34.382 $35.526 $37.836 $38.226 $37.057 $33.887 $33.694 $36.724 $34.830 $34.830 $34.830 33.55% <-Total Growth 10 Book Value
Book Value per share $0.79 $0.90 $0.97 $0.98 $0.95 $0.98 $1.02 $1.08 $1.08 $1.05 $0.96 $0.95 $1.02 $0.97 $0.97 $0.97 5.01% <-Total Growth 10 Book Value per Share
Increase 5.96% 13.68% 8.05% 0.75% -3.72% 4.17% 3.23% 6.09% 0.45% -3.49% -8.00% -1.09% 7.57% -5.16% 0.00% 0.00% 124.73% P/B Ratio Current/Historical Median
P/B Ratio (Median) 0.72 0.95 1.07 1.39 1.63 1.24 1.47 2.47 3.09 3.49 3.71 4.17 6.40 4.56 0.00 0.00 1.43 P/B Ratio Historical Median
P/B Ratio (Close) 0.83 1.04 1.15 1.50 1.45 1.12 1.95 2.79 3.61 2.68 3.64 5.68 5.68 3.21 3.21 3.21 0.49% <-IRR #YR-> 10 Book Value per Share 5.01%
Change 94.66% 25.28% 10.27% 30.27% -3.20% -22.92% 74.36% 43.30% 29.32% -25.80% 35.87% 55.99% 0.02% -43.38% 0.00% 0.00% -1.04% <-IRR #YR-> 5 Book Value per Share -5.11%
Median 10 year P/B Ratio 0.00 0.00 0.36 0.72 0.84 0.95 1.01 1.15 1.31 1.43 1.55 2.05 2.78 3.29 3.29 3.29
Leverage (A/BK) 1.33 1.37 1.58 1.54 1.43 1.31 1.37 1.47 1.53 1.67 2.75 3.43 3.58 3.82 2.75 <-Median-> 5 A/BV
Debt/Equity Ratio 0.33 0.37 0.58 0.54 0.43 0.31 0.37 0.47 0.53 0.67 1.75 2.43 2.58 2.82 1.75 <-Median-> 5 Debt/Eq Ratio
Shareholders' Equity (Assets less Liabilities) P/B Ratios 10 yr Med 2.78 5 yr Med 3.71 15.56% 1.45 Historical Leverage (A/BK)
-$0.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.02
-$1.08 $0.00 $0.00 $0.00 $0.00 $1.02
$1.49 <-12 mths -74.26%
Comprehensive Income $1.366 $2.949 $0.657 $0.729 $0.525 $1.395 $1.594 $3.997 $2.602 $1.289 $0.498 $3.000 $5.803 783.74% <-Total Growth 10 Comprehensive Income
Increase 118.28% 115.94% -77.74% 11.03% -27.96% 165.63% 14.27% 150.71% -34.89% -50.47% -61.40% 502.89% 93.42% -34.89% <-Median-> 5 Comprehensive Income
5 Yr Running Average -$2 -$1 -$1 $0 $1 $1 $1 $2 $2 $2 $2 $2 $3 24.35% <-IRR #YR-> 10 Comprehensive Income 783.74%
ROE 6.1% 11.6% 2.4% 2.5% 1.6% 4.1% 4.5% 10.6% 6.8% 3.5% 1.5% 8.9% 15.8% 7.74% <-IRR #YR-> 5 Comprehensive Income 45.18%
5Yr Median 0.0% 3.1% 2.4% 2.5% 2.5% 2.5% 2.5% 4.1% 4.5% 4.5% 4.5% 6.8% 6.8% #NUM! <-IRR #YR-> 10 5 Yr Running Average 359.12%
% Difference from Net Income 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 9.87% <-IRR #YR-> 5 5 Yr Running Average 60.09%
Median Values Diff 5, 10 yr 0.0% 0.0% 6.8% <-Median-> 5 Return on Equity
-$0.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $5.8
-$4.0 $0.0 $0.0 $0.0 $0.0 $5.8
$1.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2.6
-$1.6 $0.0 $0.0 $0.0 $0.0 $2.6
Current Liability Coverage Ratio 0.51 0.58 0.40 0.48 0.49 0.85 0.82 0.79 0.87 0.59 0.50 0.28 0.53 0.33   CFO / Current Liabilities
5 year Median 0.16 0.47 0.40 0.48 0.49 0.49 0.49 0.79 0.82 0.82 0.79 0.59 0.53 0.50 0.56 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 10.15% 10.48% 8.91% 9.88% 9.88% 11.99% 11.54% 15.86% 14.04% 12.24% 10.47% 13.15% 16.20% 10.78% CFO / Total Assets
5 year Median 1.79% 6.31% 8.91% 9.88% 9.88% 9.88% 9.88% 11.54% 11.99% 12.24% 12.24% 13.15% 13.15% 12.24% 12.1% <-Median-> 10 Return on Assets 
Return on Assets ROA 4.61% 8.49% 1.52% 1.60% 1.13% 3.10% 3.26% 7.17% 4.46% 2.09% 0.53% 2.60% 4.41% 2.18% Net  Income/Assets Return on Assets
5Yr Median -3.47% 0.34% 1.52% 1.60% 1.60% 1.60% 1.60% 3.10% 3.26% 3.26% 3.26% 2.60% 2.60% 2.18% 2.9% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 6.12% 11.61% 2.39% 2.46% 1.62% 4.06% 4.49% 10.56% 6.81% 3.48% 1.47% 8.90% 15.80% 8.33% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 0.23% 0.45% 2.39% 2.46% 2.46% 2.46% 2.46% 4.06% 4.49% 4.49% 4.49% 6.81% 6.81% 8.33% 4.3% <-Median-> 10 Return on Equity
$1.49 <-12 mths -74.26%
Net Income $1.366 $2.949 $0.657 $0.729 $0.525 $1.395 $1.594 $3.997 $2.602 $1.289 $0.498 $3.000 $5.803 $2.9 $5.1 $5.7 783.74% <-Total Growth 10 Net Income
Increase 118.28% 115.94% -77.74% 11.03% -27.96% 165.63% 14.27% 150.71% -34.89% -50.47% -61.40% 502.89% 93.42% -50.02% 75.86% 11.76% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average -$1.7 -$1.1 -$1.0 -$0.4 $1.2 $1.3 $1.0 $1.6 $2.0 $2.2 $2 $2 $3 $3 $3 $5 24.35% <-IRR #YR-> 10 Net Income 783.74%
Operating Cash Flow $2.0 $3.4 $4.4 $2.5 $3.0 $4.0 $5.9 $9.8 $2.3 $7.6 $13.4 $12.9 $4.5 7.74% <-IRR #YR-> 5 Net Income 45.18%
Investment Cash Flow -$2.9 -$3.5 -$7.1 -$4.4 -$3.3 -$0.5 -$3.7 -$5.2 -$6.7 -$8.0 -$12.2 -$20.4 -$9.8 #NUM! <-IRR #YR-> 10 5 Yr Running Average 359.12%
Total Accruals $2.3 $3.0 $3.4 $2.6 $0.8 -$2.1 -$0.6 -$0.6 $7.1 $1.6 -$0.7 $10.5 $11.1 9.87% <-IRR #YR-> 5 5 Yr Running Average 60.09%
Total Assets $29.6 $34.7 $43.3 $45.4 $46.4 $44.9 $48.8 $55.8 $58.3 $61.8 $93.1 $115.5 $131.4 Balance Sheet Assets
Accruals Ratio 7.86% 8.72% 7.76% 5.68% 1.73% -4.69% -1.22% -1.05% 12.09% 2.60% -0.79% 9.09% 8.45% 8.45% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.47 0.77 0.15 0.13 0.15 0.26 0.31 0.44 0.30 0.19 0.04 0.19 0.27 0.22 <-Median-> 10 EPS/CF Ratio
-$0.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $5.8
-$4.0 $0.0 $0.0 $0.0 $0.0 $5.8
$1.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2.6
-$1.6 $0.0 $0.0 $0.0 $0.0 $2.6
Change in Close 106.25% 42.42% 19.15% 31.25% -6.80% -19.71% 80.00% 52.02% 29.90% -28.39% 25.00% 54.29% 7.59% -46.30% 0.00% 0.00% Count 27 Years of data
up/down Up Down Down Down Down Down Down Down Count 8 29.63%
Meet Prediction? Yes Yes Yes % right Count 3 37.50%
Financial Cash Flow $0.754 $0.078 $2.705 $1.853 $0.276 -$2.909 -$2.391 -$2.144 $1.620 $0.320 -$1.230 $7.495 $5.307 C F Statement  Financial Cash Flow
Total Accruals $1.575 $2.949 $0.657 $0.729 $0.525 $0.800 $1.796 $1.558 $5.434 $1.289 $0.498 $3.000 $5.803 Accruals
Accruals Ratio 5.31% 8.49% 1.52% 1.60% 1.13% 1.78% 3.68% 2.80% 9.32% 2.09% 0.53% 2.60% 4.41% 2.60% <-Median-> 5 Ratio
Cash $0.000 $0.000 $0.000 $0.000 $0.000 $0.595 $0.394 $2.832 $2.832 $0.000 $0.000 $0.000 $0.000 $0.000 Cash
Cash per Share $0.00 $0.00 $0.00 $0.00 $0.00 $0.02 $0.01 $0.08 $0.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.00% 0.00% 0.00% 0.00% 0.00% 1.55% 0.57% 2.68% 2.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% <-Median-> 5 % of Stock Price
Notes:
November 25, 2022.  Last estimates were for 2022 and 2023 of $115M, and 129M for Revenue, $0.21 and $031 for EPS,  $0.11 for dividends 2022, $2.40M for FCF for 2022.
October 27, 2021.  Last estimates were for 2021, and 2023 of $78.9M, $108M and $119M for Revenue 2021-23, $0.09, and $0.26 for EPS and $0.11 and $0.11 for Dividends
June 15,2019.  Formerly Brick Brewing Company
1984.  Established  in 1984 as Brick Brewing Company
Sector:
Conssumer Staple; Consumer
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock. 
This stock has come up on the Dividend All-Star List at <a href="https://dividendgrowthinvestingandretirement.com/canadian-dividend-all-star-list/ " target="_top">
Dividend Growth Investing and Retirement </a> site.  
Why I bought this stock.
Dividends
Dividends are paid quarterly in Cycle 1 of January, May, August and October.  Dividends are declared in one month for shareholders of record of the following month and paid in  that month.
For example, the dividends declared on December 10, 2020 was for shareholders of record of January 15, 2021 paid on January 29, 2021.
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 
How they make their money.
Waterloo Brewing Ltd engages in the production and distribution of alcohol-based products. Its products are 
distributed to end consumers primarily through The Beer Store in Ontario and Provincial Liquor Boards across Canada.
Shares; '%, Value $M From Years Div. Gth Tot Ret Cap Gain Div. check Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M   Change
Date 2015 5 17.28% 24.93% 22.22% 2.70% 24.92% 2019 2020 Oct 27 2021 Nov 26 2022
Croft, George H.  2010 10 20.57% 19.10% 1.47% 20.57% 0.961 2.71% 1.100 3.07% 1.100 3.07% 0.00%
CEO - Shares - Amount 2005 15 6.77% 6.11% 0.66% 6.77% $5.192 $6.391 $3.432
Options - percentage 2000 20 15.30% 14.66% 0.63% 15.30% 0.533 1.51% 0.367 1.02% 0.467 1.30% 27.27%
Options - amount 1995 25 4.87% 4.49% 0.38% 4.87% $2.880 $2.130 $1.456
Zaimi, Enida From Years Div. Gth Tot Ret Cap Gain Div. check 0.000 0.00% 0.000 0.00% #DIV/0!
CFO - Shares - Amount 2016 5 18.72% 16.44% 14.06% 2.38% 16.44% $0.000 $0.000
Options - percentage 2011 10 15.37% 19.67% 17.90% 1.78% 19.67% 0.100 0.28% 0.150 0.42% 50.00%
Options - amount 2006 15 9.01% 8.17% 0.84% 9.01% $0.581 $0.468
2001 20 14.53% 13.77% 0.76% 14.53%
Birch, David 1996 25 5.41% 4.97% 0.45% 5.41% 0.019 0.05% 0.106 0.30% 0.106 0.30% 2022 dated August 2021 0.00%
CFO - Shares - Amount 1991 30 4.44% 4.08% 0.36% 4.44% $0.103 $0.617 $0.331
Options - percentage 1990 31 4.30% 3.95% 0.35% 4.30% 0.340 0.96% 0.133 0.37% 0.133 0.37% 0.00%
Options - amount $1.836 $0.775 $0.416
Tabata, Russell Noboru 0.908 2.56% 0.908 2.53% 0.934 2.60% 2.91%
Officer - Shares - Amount $4.901 $5.273 $2.914
Options - percentage 0.880 2.48% 0.778 2.17% 0.853 2.38% 9.64%
Options - amount $4.752 $4.522 $2.662
Bowey, John Harry 0.021 0.06% 0.021 0.06% 0.021 0.06% 0.00%
Director - Shares - Amount $0.111 $0.119 $0.064
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000
Dunford, Stanley George 6.002 16.73% 6.002 16.73% Named on site 2022 0.00%
Chairman - Shares - Amt $34.872 $18.726
Options - percentage 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000
Schwartz, Peter John 8.964 25.31% 7.483 20.85% 7.483 20.85% last filed Mar 2021 0.00%
Chairman - Shares - Amt $48.408 $43.477 $23.348
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000
Increase in O/S Shares 0.183 0.52% 0.079 0.22% 0.304 0.85% 0.420 1.17%
Due to Stock Options $0.640 $0.275 $1.768 $2.437
Book Value $0.365 $0.365 $0.768 $0.835
Insider Buying $0.000 -$0.127 $0.000 $0.000 no buying,selling 2022
Insider Selling $0.000 $0.000 $0.259 $0.000
Net Insider Selling $0.000 -$0.127 $0.259 $0.000
Net Selling % of Market Cap 0.00% -0.10% 0.12% 0.00%
Directors 6 6
Women 0 0% 0 0%
Minorities 0 0% 0 0%
Institutions/Holdings 20 11.27% 20 7.36%
Total Shares Held 4.303 11.99% 2.642 7.36%
Increase/Decrease 3 Mths -0.133 -2.99% -0.194 -6.83%
Starting No. of Shares 4.436 2.836
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock