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. 9/30/11
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
CCL Industries Inc www.cclind.com TSX: CCL.B Fiscal Yr: Dec 31
Year 12/31/99 12/31/00 12/31/01 12/31/02 12/31/03 12/31/04 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/30/12 #Y
Accting Rules C GAAP IFRS
Revenue w/o N A Custom Manufacturing Div. $920.80 $913.90 $1,110.1 $1,212.2 $1,144.3 $1,189.2 $1,199.0 $1,192.3 29.49% <-Total Growth 7 Revenue
-0.75% 21.47% 9.20% -5.61% 3.93% 0.82% -0.56% 3.76% <-IRR #YR-> 5 Revenue
Revenue* $1,568.9 $1,589.1 $1,600.5 $1,684.9 $1,518.4 $1,518.5 $1,110.1 $1,212.2 $1,144.3 $1,189.2 $1,199.0 $1,192.3 $1,247.0 $1,304.0 -24.97% <-Total Growth 10 Revenue
Increase 6.78% 1.29% 0.72% 5.28% -9.88% 0.00% -26.89% 9.20% -5.61% 3.93% 0.82% -0.56% 4.59% 4.57% -2.83% <-IRR #YR-> 10 Revenue
Rev per Share $40.98 $44.55 $46.89 $50.52 $46.92 $46.78 $34.15 $37.19 $34.81 $36.53 $36.28 $35.82 $37.73 $39.46 1.44% <-IRR #YR-> 5 Revenue
P/S (Price/Sales) 0.32 0.16 0.31 0.39 0.40 0.40 0.84 0.76 1.07 0.68 0.78 0.83 0.79 0.75 -2.16% <-IRR #YR-> 10 Rev Per Share
*Revenue in M CDN $  P/S 10 yr  0.72 5 yr  0.78 0.96% <-IRR #YR-> 5 Rev Per Share
-$1,589 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,192
-$1,110 $0 $0 $0 $0 $1,192
-$44.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $35.82
-$34.15 $0.00 $0.00 $0.00 $0.00 $35.82
EPS* $1.36 $0.70 $0.70 $0.64 $1.61 $1.81 $4.97 $2.33 $4.42 $1.46 $1.29 $2.13 $2.54 $2.79 204.29% <-Total Growth 10 Earnings
Increase 11.48% -48.53% 0.00% -8.57% 151.56% 12.42% 174.59% -53.12% 89.70% -66.97% -11.64% 65.12% 19.25% 9.84% 11.77% <-IRR #YR-> 10 Earnings
5 yr running ave. $1.17 $1.03 $0.92 $0.85 $1.00 $1.09 $1.95 $2.27 $3.03 $3.00 $2.89 $2.33 $2.37 $2.04 -15.59% <-IRR #YR-> 5 Earnings
Earnings Yield 10.4% 9.7% 4.8% 3.3% 8.7% 9.6% 17.3% 8.2% 11.9% 5.8% 4.6% 7.2% 8.6% 9.4% 0.00%
* ESP per share (Cdn GAAP) E/P 10 Yrs 7.70% 5Yrs 7.19%
-$0.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.13
-$4.97 $0.00 $0.00 $0.00 $0.00 $2.13
Div* $0.31 $0.32 $0.32 $0.34 $0.36 $0.39 $0.40 $0.43 $0.48 $0.56 $0.60 $0.64 $0.70 $0.70 100.00% <-Total Growth 10 Dividends
Increase 10.71% 3.23% 0.00% 6.25% 5.88% 8.33% 2.56% 7.50% 11.63% 16.67% 7.14% 6.67% 9.37% 0.00% 6.90% <-Median-> 10 Dividends
Yield H/L 2.15% 3.14% 2.93% 1.94% 2.00% 2.07% 1.61% 1.39% 1.46% 1.89% 2.50% 2.27% 1.97% <-Median-> 10 Dividends
Yield on High 1.90% 2.43% 2.19% 1.64% 1.77% 1.88% 1.27% 1.24% 1.30% 1.60% 2.11% 2.04% 1.71% <-Median-> 10 Dividends
Yield on Low 2.48% 4.41% 4.41% 2.37% 2.28% 2.30% 2.19% 1.59% 1.68% 2.32% 3.07% 2.57% 2.31% <-Median-> 10 Dividends
Yield on Cl 2.37% 4.41% 2.19% 1.75% 1.94% 2.07% 1.39% 1.52% 1.29% 2.24% 2.12% 2.16% 2.36% 2.36% 2.01% <-Median-> 10 Dividends
Payout Ratio 22.8% 45.7% 45.7% 53.1% 22.4% 21.5% 8.0% 18.5% 10.9% 38.4% 46.5% 30.0% 27.6% 25.1% 26.20% <-Median-> 10 DPR EPS
Payout Ratio CF 9.5% 8.6% 7.9% 6.6% 9.0% 9.4% 11.6% 8.6% 9.7% 8.4% 13.2% 12.7% 12.7% 12.0% 9.18% <-Median-> 10 DPR CF
Payout Ratio CF NC 8.0% 8.1% 9.0% 8.1% 8.8% 9.4% 9.6% 9.0% 8.8% 10.5% 13.1% 12.6% 12.7% 12.0% 9.21% <-Median-> 10 DPR CF NC
Average 5 Yrs Div Yd 3.31% 5 4.64% 10 Yield  1.89% 2.12% Payout 30.05% 9.73% 7.18% <-IRR #YR-> 10 Dividends
* Dividends per share  7.0% Years 7.0% Years Last Div Inc ---> $0.16 $0.18 9.4% 9.86% <-IRR #YR-> 5 Dividends
-$0.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.64
-$0.40 $0.00 $0.00 $0.00 $0.00 $0.64
H/LYield held 5 yrs 2.11% 2.71% 3.92% 3.94% 2.74% 3.11% 3.19% 2.57% 2.27% 2.14% 2.92% <-Median-> 8 Dividends
H/LYield held 10 yrs 3.29% 4.17% 6.27% 6.41% 3.99% 4.17% <-Median-> 3 Dividends
Graham No. $21.24 $15.70 $16.13 $13.74 $21.65 $23.73 $44.12 $32.40 $46.60 $27.52 $25.71 $33.70 $37.73 $39.54 114.68% <-Total Growth 10 Graham Price
Prem /Disc.Med H/L -32.20% -35.03% -32.26% 27.77% -16.72% -20.68% -43.65% -4.77% -29.68% 7.58% -6.68% -16.43% -16.58% <-Median-> 10 Graham Price
Prem /Disc. High -23.25% -16.24% -9.48% 51.06% -6.30% -12.78% -28.66% 6.96% -20.51% 27.48% 10.73% -6.75% -6.52% <-Median-> 10 Graham Price
Prem /Disc. Low -41.14% -53.82% -55.05% 4.47% -27.13% -28.58% -58.63% -16.50% -38.84% -12.32% -24.08% -26.12% -26.63% <-Median-> 10 Graham Price
Prem /Disc. Cl -38.32% -53.82% -9.48% 41.67% -14.25% -20.78% -34.85% -12.43% -20.19% -9.15% 9.87% -12.12% -21.28% -24.89% -12.27% <-Median-> 10 Graham Price
Price Cl $13.10 $7.25 $14.60 $19.46 $18.57 $18.80 $28.74 $28.37 $37.19 $25.00 $28.25 $29.62 $29.70 $29.70 308.55% <-Total Growth 10 Stock Price
Increase -26.20% -44.66% 101.38% 33.29% -4.57% 1.24% 52.87% -1.29% 31.09% -32.78% 13.00% 4.85% 0.27% 0.00% 15.11% <-IRR #YR-> 10 Stock Price
P/E 9.63 10.36 20.86 30.41 11.53 10.39 5.78 12.18 8.41 17.12 21.90 13.91 11.69 10.65 0.61% <-IRR #YR-> 5 Stock Price
Trailing P/E 10.74 5.33 20.86 27.80 29.02 11.68 15.88 5.71 15.96 5.66 19.35 22.96 13.94 11.69 18.44% <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs 3.32% 1.85% Div %  Ret. Price Inc 4.85% P/E:  13.04 13.91 2.46% <-IRR #YR-> 5 Price & Div
-$7.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.62
-$28.74 $0.00 $0.00 $0.00 $0.00 $29.62
-$7.25 $0.32 $0.34 $0.36 $0.39 $0.40 $0.43 $0.48 $0.56 $0.60 $30.26
-$28.74 $0.43 $0.48 $0.56 $0.60 $30.26
Price H/L Median $14.40 $10.20 $10.93 $17.55 $18.04 $18.83 $24.86 $30.85 $32.77 $29.61 $24.00 $28.17 176.13% <-Total Growth 10 Stock Price
Increase -15.42% -29.17% 7.11% 60.64% 2.76% 4.38% 32.06% 24.09% 6.22% -9.66% -18.95% 17.38% 10.69% <-IRR #YR-> 10 Stock Price
P/E 10.59 14.57 15.61 27.42 11.20 10.40 5.00 13.24 7.41 20.28 18.60 13.22 2.53% <-IRR #YR-> 5 Stock Price
Trailing P/E 11.80 7.50 15.61 25.07 28.18 11.69 13.73 6.21 14.06 6.70 16.43 21.83 13.44% <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs 2.75% 2.06% Div %  Ret. Price Inc 6.22% P/E:  13.23 13.24 4.59% <-IRR #YR-> 5 Price & Div
-$10.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28.17
-$24.86 $0.00 $0.00 $0.00 $0.00 $28.17
-$10.20 $0.32 $0.34 $0.36 $0.39 $0.40 $0.43 $0.48 $0.56 $0.60 $28.81
-$24.86 $0.43 $0.48 $0.56 $0.60 $28.81
Hi Mths May Jan Dec Jun Jul Jul Oct Aug Oct Aug Dec Apr
Price Hi $16.30 $13.15 $14.60 $20.75 $20.29 $20.70 $31.47 $34.65 $37.04 $35.08 $28.47 $31.43 139.01% <-Total Growth 10 Stock Price
Increase -12.37% -19.33% 11.03% 42.12% -2.22% 2.02% 52.03% 10.10% 6.90% -5.29% -18.84% 10.40% 9.10% <-IRR #YR-> 10 Stock Price
P/E 11.99 18.79 20.86 32.42 12.60 11.44 6.33 14.87 8.38 24.03 22.07 14.76 -0.03% <-IRR #YR-> 5 Stock Price
Trailing P/E 13.36 9.67 20.86 29.64 31.70 12.86 17.39 6.97 15.90 7.94 19.50 24.36
Median 10, 5 Yrs Price Inc 6.90% P/E:  14.81 14.87
-$13.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31.43
-$31.47 $0.00 $0.00 $0.00 $0.00 $31.43
Low Mths Dec Dec Jan Jan Feb Aug Jan Sep Jan Dec Aug Feb
Price Low $12.50 $7.25 $7.25 $14.35 $15.78 $16.95 $18.25 $27.05 $28.50 $24.13 $19.52 $24.90 243.45% <-Total Growth 10 Stock Price
Increase -19.09% -42.00% 0.00% 97.93% 9.97% 7.41% 7.67% 48.22% 5.36% -15.33% -19.10% 27.56% 13.13% <-IRR #YR-> 10 Stock Price
P/E 9.19 10.36 10.36 22.42 9.80 9.36 3.67 11.61 6.45 16.53 15.13 11.69 6.41% <-IRR #YR-> 5 Stock Price
Trailing P/E 10.25 5.33 10.36 20.50 24.66 10.53 10.08 5.44 12.23 5.46 13.37 19.30
Median 10, 5 Yrs Price Inc 5.36% P/E:  10.98 11.69
-$7.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24.90
Market Cap $502 $259 $498 $649 $601 $610 $934 $925 $1,223 $814 $934 $986 $982 $982 $8.227 0.84% Insider Selling
# of Sh in M 38.28 35.67 34.13 33.35 32.36 32.46 32.51 32.60 32.88 32.56 33.05 33.29 33.05 33.05 share capital Shares
Increase -1.66% -6.83% -4.31% -2.29% -2.98% 0.31% 0.16% 0.27% 0.85% -0.97% 1.51% 0.72% -0.71% 0.00% -0.67% <-Average 10 Shares
CF fr Op $M $124.7 $133.0 $138.6 $172.1 $129.5 $135.1 $112.1 $162.5 $162.2 $216.3 $150.3 $168.4 $182.8 $192.0 26.65% <-Total Growth 10 Cash Flow
OPS $3.26 $3.73 $4.06 $5.16 $4.00 $4.16 $3.45 $4.98 $4.93 $6.65 $4.55 $5.06 $5.53 $5.81 35.72% <-Total Growth 10 Cash Flow
P/CF on Cl 4.02 1.94 3.60 3.77 4.64 4.52 8.34 5.69 7.54 3.76 6.21 5.85 5.37 5.11 3.10% <-IRR #YR-> 10 Cash Flow
Non-Cash CF $23.2 $8.3 -$16.7 -$32.9 $3.2 -$1.1 $24.0 -$6.3 $16.9 -$42.8 $1.3 $0.1 $0.0 $0.0 7.98% <-IRR #YR-> 5 Cash Flow
OPS non-cash $3.86 $3.96 $3.57 $4.17 $4.10 $4.13 $4.18 $4.79 $5.45 $5.33 $4.59 $5.06 $5.53 $5.81 2.49% <-IRR #YR-> 10 CF non-cash
P/OCF on Close 3.39 1.83 4.09 4.66 4.53 4.56 6.87 5.92 6.83 4.69 6.16 5.85 5.37 5.11 3.88% <-IRR #YR-> 5 CF non-cash
Median P/CF 10 yr 5.27 5 yr  5.92
*Operational Cash Flow per share
-$3.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.06
-$3.45 $0.00 $0.00 $0.00 $0.00 $5.06
-$3.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.06
-$4.18 $0.00 $0.00 $0.00 $0.00 $5.06
OPM 7.95% 8.37% 8.66% 10.21% 8.53% 8.90% 10.09% 13.40% 14.17% 18.19% 12.53% 14.12% 14.66% should be zero, it is a check on calculations
Diff from Ave -30.1% -26.4% -23.9% -10.2% -25.0% -21.8% -11.2% 17.8% 24.6% 60.0% 10.2% 24.2% 28.9% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 11.37% 5 Yrs 14.12%
Q3 2011
Curr Assets $447.40 $434.42 $488.11 $529.32 $392.97 $420.40 $405.21 $424.90 $391.02 $407.95 $399.15 $432.57 $409.72 Liq ratio of 1.5 and up, best Assets
Curr Liab. $298.66 $239.66 $264.52 $292.14 $267.47 $350.11 $290.74 $333.00 $244.97 $276.71 $266.74 $309.72 $259.28 1.47 <-Median-> 10 Liabilities
Liquidity 1.50 1.81 1.85 1.81 1.47 1.20 1.39 1.28 1.60 1.47 1.50 1.40 1.58 1.47 <-Median-> 5 Ratio
Assets $1,422.5 $1,379.7 $1,455.0 $1,342.7 $1,191.9 $1,274.0 $1,398.7 $1,542.6 $1,488.2 $1,766.7 $1,645.5 $1,622.4 $1,636.8 A/L ratio of 1.5 and up, best Assets
Liab. $858.2 $821.5 $891.3 $905.8 $773.0 $825.1 $832.9 $889.99 $770.3 $1,016.2 $892.7 $833.4 $813.6 1.71 <-Median-> 10 Liabilities
Liquidity 1.66 1.68 1.63 1.48 1.54 1.54 1.68 1.73 1.93 1.74 1.84 1.95 2.01 1.84 <-Median-> 5 Ratio
Book Value $564.3 $558.2 $563.7 $437.0 $418.9 $448.9 $565.8 $652.6 $717.9 $750.5 $752.8 $789.0 $823.3 41.35% <-Total Growth 10 Book Value
BV per share $14.74 $15.65 $16.52 $13.10 $12.94 $13.83 $17.40 $20.02 $21.84 $23.05 $22.78 $23.70 $24.91 $24.91 51.46% <-Total Growth 10 Book Value
Change 0.42% 6.17% 5.53% -20.66% -1.20% 6.84% 25.84% 15.03% 9.07% 5.58% -1.20% 4.06% 5.09% 0.9002 Current/Historical Book Value
P/BV (CL) 0.89 0.46 0.88 1.49 1.43 1.36 1.65 1.42 1.70 1.08 1.24 1.25 1.19 4.24% <-IRR #YR-> 10 Book Value
Change -26.50% -47.87% 90.82% 68.01% -3.41% -5.24% 21.48% -14.19% 20.19% -36.33% 14.37% 0.75% -4.59% 6.37% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 2.52 2.47 2.58 3.07 2.85 2.84 2.47 2.36 2.07 2.35 2.19 2.06 1.99 2.42 <-Median-> 10 A/BV
Debt/Equity Ratio 1.52 1.47 1.58 2.07 1.85 1.84 1.47 1.36 1.07 1.35 1.19 1.06 0.99 1.42 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Ave 1.39 5 yr Ave 1.25
-$15.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.70
-$17.40 $0.00 $0.00 $0.00 $0.00 $23.70
ROE 14.8% 10.9% 8.8% 1.6% 6.0% 8.79% <-Median-> 5 Compreh. Inc
Comprehensive Inc $96.82 $78.26 $65.94 $11.78 $47.40 Compreh. Inc
ROE 9.5% 4.8% 4.4% 5.0% 12.7% 13.2% 29.0% 11.9% 20.6% 6.4% 5.6% 9.0% 9.6% <-12 mths Net Income/Shareholders' equity ROE
5Yr Median 9.2% 9.0% 7.8% 5.0% 5.0% 5.0% 12.7% 12.7% 13.2% 13.2% 11.9% 9.0% 9.0% ROE
By o/s Shares $1.40 $0.75 $0.73 $0.65 $1.64 $1.83 $5.04 $2.37 $4.50 $1.47 $1.28 $2.14 $2.39 <-12 mths
Net Income $53.63 $26.65 $24.89 $21.82 $53.03 $59.25 $163.84 $77.42 $147.92 $47.99 $42.17 $71.14 $79.03 <-12 mths 166.89% <-Total Growth 10 Net Income
Oper C. F. $124.71 $132.96 $138.58 $172.05 $129.49 $135.07 $112.06 $162.46 $162.19 $216.35 $150.28 $168.40 C F Statement  Oper C. F.
Invest. C. F -$110.92 $52.39 -$20.31 -$76.82 -$141.96 -$124.07 -$16.85 -$172.26 -$201.81 -$230.42 -$99.73 -$82.60 C F Statement  Invest. C. F
Total Accruals $39.84 -$158.70 -$93.38 -$73.41 $65.50 $48.25 $68.62 $87.22 $187.53 $62.06 -$8.38 -$14.66 Accruals
Total Assets $1,422.5 $1,379.7 $1,455.0 $1,342.7 $1,191.9 $1,274.0 $1,398.7 $1,542.6 $1,488.2 $1,766.7 $1,645.5 $1,622.4 Balance Sheet Assets
Accruals Ratio 2.80% -11.50% -6.42% -5.47% 5.50% 3.79% 4.91% 5.65% 12.60% 3.51% -0.51% -0.90% Ratio
up/down/neutral
Chge in Close -26.20% -44.66% 101.38% 33.29% -4.57% 1.24% 52.87% -1.29% 31.09% -32.78% 13.00% 4.85%
Any Predictions?
Fin. C. F -$26.10 -$80.12 -$38.89 -$52.03 -$45.04 -$17.58 -$38.84 $9.27 $23.62 $39.98 -$20.84 -$53.31 C F Statement  Fin. C. F
Total Accruals $65.94 -$78.58 -$54.49 -$21.38 $110.54 $65.84 $107.46 $77.95 $163.91 $22.08 $12.46 $38.65 Accruals
Accruals Ratio 4.64% -5.69% -3.75% -1.59% 9.27% 5.17% 7.68% 5.05% 11.01% 1.25% 0.76% 2.38% Ratio
Sep 5, 2010. When last I updated this spreadsheet, I got 2009 and 2010 estimates of $2.30 and $2.59 ofr earnings and $2.97 and 3.53 for CF
One problem is that EPS for December 2008 Q was a loss of $.80. Another is massive insider selling and no buying.  If they do not believe in stock, why should I?
2005.  In May 2005, the Company sold its North American Custom Manufacturing Division, for $272.8 million in cash.  This caused a decrease in Sales in 2005.  Sales and other items were restated 
to account for this discontinued business.
How they make their money.
CCL Industries Inc. provides state-of-the-art specialty packaging solutions to some of the world’s largest producers of consumer brands in personal care, cosmetic, healthcare,
 household and specialty food and beverage products. CCL is the world’s largest supplier of innovative and secure labeling solutions to leading global companies in the 
consumer product and healthcare sectors and supplies aluminum containers and plastic tubes for major consumer brands of personal care, household products and 
specialty food and beverages. With headquarters in Toronto, Ontario, Canada, CCL Industries operates production facilities in North America, Europe, Latin America, Asia and Australia.
Stuart Lang and Donald Lang own this stock 94%
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.
(i) Class A
Class A shares carry full voting rights and are convertible at any time into Class B shares. Dividends are currently set at $0.05 per share per annum less than Class B shares.
(ii) Class B
Class B shares rank equally in all material respects with Class A shares, except as follows:
(1) Holders of Class B shares are entitled to receive material and attend, but not to vote at, regular shareholder meetings.
(2) Holders of Class B shares are entitled to voting privileges when consideration for the Class A shares, under a takeover bid
when voting control has been acquired, exceeds 115% of the market price of the Class B shares.
(3) Holders of Class B shares are entitled to receive, or have set aside for payment, dividends declared by the Board of Directors
from time to time