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.
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Andrew Peller Ltd www.andrewpeller.com TSX: ADW.A Fiscal Yr: Mar 31
Year 3/31/99 3/31/00 3/31/01 3/31/02 3/31/03 3/31/04 3/31/05 3/31/06 3/31/07 3/31/08 3/31/09 3/31/10 3/31/11 3/30/12 3/30/13 #Y
Accting Rules C GAAP IFRS
Revenue* $135.4 $133.6 $134.4 $139.0 $147.9 $155.9 $167.6 $211.8 $228.2 $237.1 $268.2 $263.2 $265.4 $270.4 <-12 mths 97.55% <-Total Growth 10 Revenue
Increase 14.14% -1.33% 0.54% 3.46% 6.37% 5.45% 7.52% 26.33% 7.75% 3.92% 13.11% -1.89% 0.86% 1.86% <-12 mths 7.05% <-IRR #YR-> 10 Revenue
Rev per Share $9.61 $9.40 $9.45 $9.77 $10.39 $10.56 $11.27 $14.22 $15.32 $15.92 $18.01 $17.67 $18.56 $18.91 <-12 mths 4.62% <-IRR #YR-> 5 Revenue
P/S (Price/Sales) 0.49 0.43 0.37 0.57 0.53 0.71 0.80 0.63 0.73 0.58 0.37 0.46 0.50 0.47 <-12 mths 6.98% <-IRR #YR-> 10 Rev per Share
Averages P/S 10 yr  0.57 5 yr  0.50 5.47% <-IRR #YR-> 5 Rev per Share
*Revenue in M CDN $ 
-$134.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $265.4
-$211.8 $0.0 $0.0 $0.0 $0.0 $265.4
EPS* $0.39 $0.76 $0.26 $0.34 $0.50 $0.67 $0.59 $0.42 $0.65 $0.78 -$0.01 $0.66 $0.76 $0.76 <-12 mths 196.10% <-Total Growth 10 Earnings
Increase -15.71% 94.07% -66.38% 31.17% 47.52% 34.90% -12.44% -28.98% 56.00% 20.00% -101.28% -15.38% 15.15% 0.00% <-12 mths 11.47% <-IRR #YR-> 10 Earnings
Earnings Yield 8.3% 19.1% 7.3% 6.0% 9.1% 8.9% 6.5% 4.7% 5.8% 8.5% -0.2% 8.1% 8.2% 8.5% <-12 mths 12.77% <-IRR #YR-> 5 Earnings
* ESP per share (Cdn GAAP) For A shares (which other sites use) E/P 10 Yrs 7.31% 5Yrs 8.10%
-$0.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.76
-$0.42 $0.00 $0.00 $0.00 $0.00 $0.76
Extra Pre-split 07
Extra    
Pre-split 07 $0.64 $0.64 $0.64 $0.64
Div* $0.22 $0.22 $0.22 $0.22 $0.22 $0.22 $0.22 $0.22 $0.25 $0.30 $0.33 $0.33 $0.33 $0.35 $0.36 53.49% <-Total Growth 10 Dividends
Increase 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 17.67% 18.58% 10.00% 0.00% 0.00% 6.82% 2.13% 0.00% <-Median-> 10 Dividends
Yield H/L 3.52% 4.45% 5.44% 4.70% 3.85% 3.19% 2.58% 2.33% 2.39% 2.99% 3.58% 4.29% 3.84% 3.38% <-Median-> 10 Dividends
Yield on High 2.88% 3.92% 4.85% 3.79% 3.48% 2.69% 2.23% 2.18% 2.00% 2.54% 2.87% 3.67% 3.57% 2.78% <-Median-> 10
Yield on Low 4.53% 5.14% 6.18% 6.20% 4.30% 3.91% 3.06% 2.51% 2.98% 3.64% 4.74% 5.17% 4.15% 4.03% <-Median-> 10 Dividends
Yield on Cl 4.53% 5.38% 6.14% 3.85% 3.92% 2.87% 2.39% 2.42% 2.26% 3.26% 4.99% 4.05% 3.57% 3.94% 4.02% 3.41% <-Median-> 10 Dividends
Payout Ratio 54.7% 28.2% 83.8% 63.9% 43.3% 32.1% 36.6% 51.6% 38.9% 38.5% 50.0% 43.4% 43.29% <-Median-> 9 Dividends
Payout Ratio CF 30.9% 24.0% 31.5% 58.1% 21.2% 76.5% 47.2% 16.9% 82.9% 51.0% 35.9% 28.2% 20.5% 41.55% <-Median-> 10 Dividends
Average 5 Yrs Div Yd 4.91% 5 6.12% 10 Yield  3.58% 3.57% Payout 41.17% 35.86% 4.38% <-IRR #YR-> 10 Dividends
* Dividends per share  4.5% Years 4.5% Years Last Div Inc ---> $0.08 $0.09 9.1% 8.95% <-IRR #YR-> 5 Dividends
-$0.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.33
-$0.22 $0.00 $0.00 $0.00 $0.00 $0.33
H/LYield held 5 yrs 5.14% 5.90% 5.55% 4.41% 3.03% 3.52% 4.45% 5.44% 5.54% 5.37% 4.89% 3.97% 3.58% 3.33% 3.59% 4.43% <-Median-> 10 Dividends
H/LYield held 10 yrs 5.14% 5.90% 5.55% 5.19% 4.23% 5.40% 6.83% 8.34% 7.71% 6.45% 5.47% <-Median-> 8 Dividends
Graham No. $5.94 $8.87 $5.18 $6.04 $7.55 $9.11 $8.76 $7.51 $9.69 $11.00 $10.68 $15.80 $11.78 $11.81 127.18% <-Total Growth 10 Graham Price
Prem /Disc.Med H/L 2.82% -45.52% -23.70% -24.35% -25.99% -25.91% -5.06% 22.91% 9.18% -8.87% -13.58% -51.37% -26.97% -18.96% <-Median-> 10 Graham Price
Prem /Disc. High 25.70% -38.18% -14.53% -6.14% -18.24% -12.18% 9.77% 31.57% 30.61% 7.27% 7.68% -43.12% -21.45% 0.56% <-Median-> 10 Graham Price
Prem /Disc. Low -20.07% -52.85% -32.86% -42.56% -33.74% -39.63% -19.90% 14.26% -12.24% -25.00% -34.83% -59.63% -32.49% -33.11% <-Median-> 10 Graham Price
Prem /Disc. Cl -20.07% -54.88% -32.48% -7.63% -27.38% -17.67% 2.70% 18.52% 15.64% -16.37% -38.11% -48.43% -21.45% -24.25% -17.02% <-Median-> 10 Graham Price
Price Cl $4.75 $4.00 $3.50 $5.58 $5.48 $7.50 $9.00 $8.90 $11.20 $9.20 $6.61 $8.15 $9.25 $8.95 $8.95 164.29% <-Total Growth 10 Stock Prices
Increase -39.34% -15.79% -12.50% 59.43% -1.79% 36.86% 20.00% -1.11% 25.84% -17.86% -28.15% 23.30% 13.50% -3.24% 0.00% 10.21% <-IRR #YR-> 10 Stock Prices
P/E 12.08 5.24 13.64 16.57 11.03 11.19 15.34 21.36 17.23 11.79 -661.00 12.35 12.17 11.78 #VALUE! 0.77% <-IRR #YR-> 5 Stock Prices
Trailing P/E 10.18 10.17 4.59 21.74 16.28 15.10 13.43 15.17 26.88 14.15 8.47 -815.00 14.02 11.78 11.78 15.05% <-IRR #YR-> 10 Price & Div
Median 5 Yrs 3.40% 4.84% Div %  5, 10 yrs Price Inc 13.50% P/E: Y-T 12.17 14.02 4.17% <-IRR #YR-> 5 Price & Div
-$3.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.25
-$8.90 $0.00 $0.00 $0.00 $0.00 $9.25
-$3.50 $0.22 $0.22 $0.22 $0.22 $0.22 $0.25 $0.30 $0.33 $0.33 $9.58
-$8.90 $0.25 $0.30 $0.33 $0.33 $9.58
Price H/L Median $6.11 $4.83 $3.96 $4.57 $5.59 $6.75 $8.32 $9.23 $10.58 $10.03 $9.23 $7.69 $8.60 117.45% <-Total Growth 10 Stock Prices
Increase -13.94% -20.95% -18.12% 15.55% 22.21% 20.86% 23.26% 10.94% 14.57% -5.20% -7.93% -16.74% 11.91% 8.08% <-IRR #YR-> 10 Stock Prices
P/E 15.53 6.33 15.41 13.57 11.24 10.07 14.18 22.15 16.27 12.85 -923.00 11.64 11.32 -1.40% <-IRR #YR-> 5 Stock Prices
Trailing P/E 13.09 12.28 5.18 17.81 16.59 13.59 12.42 15.73 25.38 15.42 11.83 -768.50 13.03 12.70% <-IRR #YR-> 10 Price & Div
Median 5 Yrs 3.43% 4.63% Div %  5, 10 yrs Price Inc -5.20% P/E: Y-T 11.64 13.03 2.02% <-IRR #YR-> 5 Price & Div
-$3.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.60
-$9.23 $0.00 $0.00 $0.00 $0.00 $8.60
-$3.96 $0.22 $0.22 $0.22 $0.22 $0.22 $0.25 $0.30 $0.33 $0.33 $8.93
-$9.23 $0.25 $0.30 $0.33 $0.33 $8.93
Hi Mths Apr 98 Jul 99 Oct 00 Mar 02 Jun 02 Feb 04 Mar 05 May 05 Nov 06 Jun 07 Jun 08 Sep 09 Mar 11
Price Hi $7.47 $5.48 $4.43 $5.67 $6.17 $8.00 $9.62 $9.88 $12.65 $11.80 $11.50 $8.99 $9.25 108.80% <-Total Growth 10 Stock Prices
Increase -12.12% -26.64% -19.16% 27.99% 8.82% 29.66% 20.25% 2.70% 28.04% -6.72% -2.54% -21.83% 2.89% 7.64% <-IRR #YR-> 10 Stock Prices
P/E 18.99 7.18 17.26 16.84 12.42 11.94 16.40 23.71 19.46 15.13 -1150.00 13.62 12.17 -1.31% <-IRR #YR-> 5 Stock Prices
Trailing P/E 16.01 13.93 5.80 22.09 18.33 16.11 14.36 16.84 30.36 18.15 14.74 -899.00 14.02
Median 5 Yrs Price Inc -2.54% P/E: Y-T 13.62 14.74
-$4.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.25
-$9.88 $0.00 $0.00 $0.00 $0.00 $9.25
Low Mths Mar 99 May 99 Dec 00 May 01 Oct 02 Apr 03 Sep 04 Sep 05 May 06 Jan 08 Oct 08 Apr 09 Jun 10
Price Low $4.75 $4.18 $3.48 $3.47 $5.00 $5.50 $7.02 $8.58 $8.50 $8.25 $6.96 $6.38 $7.95 128.45% <-Total Growth 10 Stock Prices
Increase -16.67% -12.00% -16.75% -0.29% 44.09% 10.00% 27.64% 22.22% -0.93% -2.94% -15.64% -8.33% 24.61% 8.61% <-IRR #YR-> 10 Stock Prices
P/E 12.08 5.48 13.56 10.31 10.07 8.21 11.97 20.59 13.08 10.58 -696.00 9.67 10.46 -1.51% <-IRR #YR-> 5 Stock Prices
Trailing P/E 10.18 10.63 4.56 13.52 14.85 11.07 10.48 14.63 20.40 12.69 8.92 -638.00 12.05
Median 5 Yrs Price Inc -2.94% P/E: Y-T 10.46 12.05
-$3.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.95
Market Cap 66.97 56.84 49.74 79.41 77.99 110.77 133.81 132.54 166.79 137.01 98.44 121.37 132.28
# of Sh in M 14.100 14.211 14.211 14.231 14.232 14.769 14.868 14.892 14.892 14.892 14.892 14.892 14.300 14.298 14.298 Capital Stock Shares
Increase 0.09% 0.79% 0.00% 0.14% 0.01% 3.77% 0.67% 0.16% 0.00% 0.00% 0.00% 0.00% -3.98% 0.08% <-Average 10 Shares
CF fr Op $M $9.82 $12.71 $9.70 $5.27 $14.41 $4.15 $6.77 $18.98 $4.55 $8.76 $13.70 $17.45 $23.02 $19.06 <-12 mths 137.37% <-Total Growth 10 Cash Flow
OPS $0.70 $0.89 $0.68 $0.37 $1.01 $0.28 $0.46 $1.27 $0.31 $0.59 $0.92 $1.17 $1.61 $1.33 <-12 mths 135.89% <-Total Growth 10 Cash Flow
5 yr running ave $0.60 $0.80 $0.76 $0.66 $0.73 $0.65 $0.56 $0.68 $0.67 $0.58 $0.71 $0.85 $0.92 $1.12 <-12 mths 8.96% <-IRR #YR-> 10 Cash Flow
Diff from 5 yr av 16.0% 12.4% -9.9% -44.0% 38.5% -56.6% -18.7% 87.8% -54.2% 1.2% 29.9% 37.5% 75.2% 18.5% <-12 mths 4.78% <-IRR #YR-> 5 Cash Flow
P/CF on Cl 6.82 4.47 5.13 15.08 5.41 26.68 19.77 6.98 36.70 15.65 7.18 6.96 5.75 6.71 <-12 mths 7.83% <-IRR #YR-> 8 CF ex non-cash
Non-Cash $0.37 -$4.09 -$1.95 $3.18 -$2.59 $9.93 $7.61 -$5.59 $12.87 $9.06 $5.42 -$1.91 -$1.32 $3.81 <-12 mths 11.02% <-IRR #YR-> 5 CF ex non-cash
Non-Cash per sh $0.72 $0.61 $0.55 $0.59 $0.83 $0.95 $0.97 $0.90 $1.17 $1.20 $1.28 $1.04 $1.52 $1.60 <-12 mths 82.79% <-Total Growth 8 CF ex non-cash
P/CF on Cl 6.57 6.60 6.42 9.40 6.60 7.87 9.30 9.89 9.58 7.69 5.15 7.81 6.10 5.60 <-12 mths
Averages P/CF 10 yr 7.84 5 yr  7.69
*Operational Cash Flow per share
-$0.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.61
-$1.27 $0.00 $0.00 $0.00 $0.00 $1.61
-$0.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.52
-$0.90 $0.00 $0.00 $0.00 $0.00 $1.52
OPM 7.25% 9.51% 7.22% 3.79% 9.75% 2.66% 4.04% 8.96% 1.99% 3.69% 5.11% 6.63% 8.67% 7.05% should be zero, it is a check on calculations
Diff from Ave 58.6% 107.9% 57.8% -17.2% 113.1% -41.8% -11.7% 96.0% -56.4% -19.3% 11.7% 45.0% 89.6% 54.2% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 4.57% 5 Yrs 5.11%
Q1 2011
Curr Assets $69.83 $60.99 $59.97 $62.33 $59.05 $68.49 $78.74 $92.33 $107.66 $121.95 $134.82 $116.35 $120.29 $121.90 Liq ratio of 1.5 and up, best Assets
Curr Liab. $46.72 $37.52 $45.22 $37.71 $31.68 $38.61 $49.33 $65.57 $82.34 $95.35 $105.62 $86.38 $92.02 $91.05 1.38 <-Median-> 10 Liabilities
Liquidity 1.49 1.63 1.33 1.65 1.86 1.77 1.60 1.41 1.31 1.28 1.28 1.35 1.31 1.34 1.31 <-Median-> 5 Ratio
Assets $128.06 $126.23 $132.97 $133.30 $132.01 $146.97 $162.16 $222.09 $238.96 $259.74 $293.51 $263.72 $266.69 $268.77 A/L ratio of 1.5 and up, best Assets
Liab. $71.80 $61.21 $66.85 $64.74 $59.49 $65.67 $75.65 $132.51 $143.43 $157.06 $196.72 $150.05 $152.02 $152.05 1.76 <-Median-> 10 Liabilities
Asset/Liab Ratio 1.78 2.06 1.99 2.06 2.22 2.24 2.14 1.68 1.67 1.65 1.49 1.76 1.75 1.77 1.67 <-Median-> 5 Ratio
Book Value $56.27 $65.03 $66.11 $68.56 $72.52 $81.3 $86.5 $89.6 $95.5 $102.7 $96.8 $113.7 $114.7 $116.7 73.44% <-Total Growth 10 Book Value
BV per share $3.99 $4.58 $4.65 $4.82 $5.10 $5.51 $5.82 $6.02 $6.41 $6.89 $6.50 $7.63 $8.02 $8.16 72.37% <-Total Growth 10 Book Value
Change 5.06% 14.67% 1.67% 3.56% 5.77% 8.04% 5.68% 3.39% 6.63% 7.49% -5.74% 17.43% 5.06% 1.80% 0.8797 Current/Historical Book Value
5 yr run. Ave Inc 6.08% 9.87% 7.13% 6.24% 6.15% 6.74% 4.94% 5.29% 5.90% 6.25% 3.49% 5.84% 6.18% 5.21% Book Value
P/BV (CL) 1.19 0.87 0.75 1.16 1.08 1.36 1.55 1.48 1.75 1.33 1.02 1.07 1.15 1.10 5.60% <-IRR #YR-> 10 Book Value
Change -42.26% -26.56% -13.94% 53.96% -7.15% 26.68% 13.55% -4.35% 18.01% -23.58% -23.78% 4.99% 8.03% -4.95% 5.92% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 2.28 1.94 2.01 1.94 1.82 1.81 1.87 2.48 2.50 2.53 3.03 2.32 2.33 2.30 2.32 <-Median-> 10 A/BV
Debt/Equity Ratio 1.28 0.94 1.01 0.94 0.82 0.81 0.87 1.48 1.50 1.53 2.03 1.32 1.33 1.30 1.32 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Ave 1.25 5 yr Ave 1.15
-$4.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.02
-$6.02 $0.00 $0.00 $0.00 $0.00 $8.02
ROE 6.8% 9.9% 11.1% -0.1% 19.1% 9.6% 9.92% <-Median-> 5 Compreh. Inc
Comprehensive Inc $6.05 $9.47 $11.38 -$0.13 $21.66 $10.99 Compreh. Inc
ROE 10.0% 17.4% 6.1% 7.8% 9.6% 11.8% 9.8% 6.8% 9.9% 11.1% -0.1% 19.1% 9.6% 9.3% Net Income/Shareholders' equity
5Yr Median 12.6% 12.6% 10.0% 9.6% 9.6% 9.6% 9.6% 9.8% 9.9% 9.8% 9.9% 9.9% 9.6%
Net Income $5.65 $11.31 $4.05 $5.33 $6.93 $9.57 $8.47 $6.05 $9.47 $11.38 -$0.13 $21.7 $11.0 $10.9 <-12 mths 171.16% <-Total Growth 10 Net Income
Oper C. F. $9.82 $12.71 $9.70 $5.27 $14.41 $4.15 $6.77 $18.98 $4.55 $8.76 $13.70 $17.45 $23.02 $19.06 <-12 mths C F Statement  Oper C. F.
Invest. C. F -$6.72 $2.52 -$11.90 -$0.15 -$5.89 -$10.03 -$8.74 -$45.50 -$9.35 -$14.21 -$24.11 -$5.84 -$7.53 -$8.21 <-12 mths C F Statement  Invest. C. F
Total Accruals $2.55 -$3.92 $6.26 $0.21 -$1.59 $15.45 $10.44 $32.57 $14.27 $16.84 $10.28 $10.05 -$4.50 $0.04 Accruals
Total Assets $128.06 $126.23 $132.97 $133.30 $132.01 $146.97 $162.16 $222.09 $238.96 $259.74 $293.51 $263.72 $266.69 $268.77 Balance Sheet Assets
Accruals Ratio 1.99% -3.11% 4.71% 0.16% -1.21% 10.51% 6.44% 14.67% 5.97% 6.48% 3.50% 3.81% -1.69% 0.02% Ratio
up/down/neutral Need free cash flow (cash from operations, with depreciation and amortization added back and capital spending subtracted) to amply cover the payouts.
Chge in Close -39.34% -15.79% -12.50% 59.43% -1.79% 36.86% 20.00% -1.11% 25.84% -17.86% -28.15% 23.30% 13.50%
Any Predictions?
Fin. C. F -$3.11 -$15.23 $2.21 -$5.12 $8.52 $5.88 $1.97 $25.52 $4.80 $5.46 $10.40 -$33.43 -$15.49 -$10.86 <-12 mths C F Statement  Fin. C. F
Total Accruals $5.65 $11.31 $4.05 $5.33 -$10.12 $9.57 $8.47 $7.05 $9.47 $11.38 -$0.13 $43.48 $10.99 Accruals
Accruals Ratio 4.41% 8.96% 3.05% 3.99% -7.66% 6.51% 5.22% 3.18% 3.96% 4.38% -0.04% 16.49% 4.12% Ratio
Sep 24, 2011.  When I last looked at this stock I got earnings of $.69 for March 2011.  There are not analysts following this stock.
Earnings for March 2011 was $1.49 or $21.7M, but earnings for continuing operations was just $.66 or $9.526  Sites are using that for continuing operations.
Oct 10, 2009, When I look at this stock in Apr 2009, I got 2009 earnings estimates of $.29, but they came in at -$.01
April 2009 AR2008. What concerns me is the lack of progress in Cash Flow.  Cash Flow is all over the place on this company.  It has provided support for the Book Value, but Book Value has only increase
 by just over 6% a year.  Not Great.  If it had been increasing at a higher rate it would be better.  The concern on Cash Flow remains as it does not improve re 5 year averages.
Formerly Andres Wines Ltd
They give earnings separately for A & B shares?
How they make their money.
Andrew Peller Limited (the “Company”) is a leading producer and marketer of quality wines in Canada. With wineries in British Columbia, Ontario and Nova Scotia, the Company markets wines produced
from grapes grown in Ontario’s Niagara Peninsula, British Columbia’s Okanagan and Similkameen Valleys and vineyards around the world.  They also market craft beer under 
the Granville Island brand.  The Company produces and markets consumer-made wine kit products through Winexpert and Vineco International Products. The Company’s 
products are sold predominantly in Canada.  Class A shares are non-voting.
Kernaghan, Edward James - indirectly owns 336,000 of B shares of which there are just over 3M.
Peller, Joseph Andrew - indirectly owns almost 2M Class B shares of which there are just over 3M.
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.
Copyright © 2008 Website of SPBrunner. All rights reserved.
1/10/96 -$3,501
9/30/11 $8,325
5.66%
5.41%
11.07%