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.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Q2 2023
CCL Industries Inc TSX: CCL.B OTC: CCDBF http://www.cclind.com/ Fiscal Yr: Dec 31
Year 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 Value Description #Y Item Total G
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Split Date 5-Jun-17
Split   5
$6,541.9 <-12 mths 2.50%
Revenue* $1,192.3 $1,268.5 $1,308.6 $1,889.4 $2,585.6 $3,039.1 $3,974.7 $4,755.7 $5,161.5 $5,321.3 $5,242.3 $5,732.8 $6,382.2 $6,716 $7,022 $7,276 387.73% <-Total Growth 10 Revenue
Increase -0.56% 6.39% 3.16% 44.39% 36.85% 17.54% 30.79% 19.65% 8.53% 3.10% -1.48% 9.36% 11.33% 5.23% 4.56% 3.62% 17.17% <-IRR #YR-> 10 Revenue 387.73%
5 year Running Average $1,187.4 $1,198.6 $1,231.5 $1,371.6 $1,648.9 $2,018.2 $2,559.5 $3,248.9 $3,903.3 $4,450.5 $4,891.1 $5,242.7 $5,568.0 $5,878.9 $6,219.1 $6,625.8 6.06% <-IRR #YR-> 5 Revenue 34.20%
Revenue per Share $7.16 $7.53 $7.74 $10.99 $14.91 $17.32 $22.59 $26.89 $29.04 $29.79 $29.35 $31.81 $36.06 $37.79 $39.52 $40.95 16.29% <-IRR #YR-> 10 5 yr Running Average 352.13%
Increase -1.27% 5.11% 2.76% 42.00% 35.65% 16.19% 30.44% 19.05% 7.98% 2.60% -1.48% 8.37% 13.35% 4.82% 4.56% 3.62% 11.38% <-IRR #YR-> 5 5 yr Running Average 71.38%
5 year Running Average $7.22 $7.24 $7.40 $8.14 $9.67 $11.70 $14.71 $18.54 $22.15 $25.13 $27.53 $29.38 $31.21 $32.96 $34.91 $37.22 16.64% <-IRR #YR-> 10 Revenue per Share 365.96%
P/S (Price/Sales) Med 0.79 0.85 0.96 1.19 1.37 2.00 1.98 2.21 1.99 1.97 1.63 2.06 1.71 1.68 0.00 0.00 6.04% <-IRR #YR-> 5 Revenue per Share 34.08%
P/S (Price/Sales) Close 0.83 0.82 1.11 1.44 1.69 2.59 2.34 2.16 1.72 1.86 1.97 2.13 1.60 1.46 1.39 1.35 15.48% <-IRR #YR-> 10 5 yr Running Average 321.84%
*Revenue in M CDN $  P/S Med 20 yr  1.28 15 yr  1.68 10 yr  1.97 5 yr  1.97 -26.17% Diff M/C 10.98% <-IRR #YR-> 5 5 yr Running Average 68.35%
-$1,309 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,382
-$4,756 $0 $0 $0 $0 $6,382
-$1,232 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,568
-$3,249 $0 $0 $0 $0 $5,568
-$7.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36.06
-$26.89 $0.00 $0.00 $0.00 $0.00 $36.06
-$7.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31.21
-$18.54 $0.00 $0.00 $0.00 $0.00 $31.21
$641.01 <-12 mths 0.95%
$3.62 <-12 mths 1.40%
Adjusted Earnings Class B  $71.3 $84.9 $97.5 $151.0 $224.1 $298.8 $399.2 $471.7 $482.5 $496.9 $550.5 $606.0 $635.0
Pre-split 2017 $2.18 $2.57 $2.91 $4.43 $6.53 $8.61
AEPS* Basic $0.44 $0.51 $0.58 $0.89 $1.31 $1.72 $2.28 $2.69 $2.73 $2.79 $3.08 $3.37 $3.57 $3.74 $3.93 $4.18 513.40% <-Total Growth 10 AEPS
Increase 86.32% 17.89% 13.23% 52.23% 47.40% 31.85% 32.40% 17.98% 1.49% 2.20% 10.39% 9.42% 5.93% 4.76% 5.08% 6.36% 10 0 10 Years of Data, EPS P or N 100.00%
5 year Running Average $0.41 $0.44 $0.45 $0.53 $0.74 $1.00 $1.36 $1.78 $2.15 $2.44 $2.71 $2.93 $3.11 $3.31 $3.54 $3.76 19.89% <-IRR #YR-> 10 AEPS 513.40%
AEPS Yield 7.36% 8.34% 6.77% 5.59% 5.19% 3.84% 4.32% 4.63% 5.45% 5.04% 5.33% 4.97% 6.17% 6.79% 7.13% 7.59% 5.82% <-IRR #YR-> 5 AEPS 32.71%
Payout Ratio 29.36% 27.24% 26.80% 19.41% 16.85% 17.42% 17.54% 17.10% 19.05% 24.37% 23.38% 24.93% 26.89% 28.34% 26.97% 25.36% 21.19% <-IRR #YR-> 10 5 yr Running Average 583.38%
5 year Running Average 28.75% 29.86% 31.35% 30.82% 23.93% 21.54% 19.61% 17.66% 17.59% 19.10% 20.29% 21.76% 23.72% 25.58% 26.10% 26.50% 11.83% <-IRR #YR-> 5 5 yr Running Average 74.92%
Price/AEPS Median 12.92 12.40 12.82 14.74 15.67 20.10 19.65 22.13 21.19 20.99 15.57 19.48 17.25 16.99 0.00 0.00 19.57 <-Median-> 10 Price/AEPS Median
Price/AEPS High 14.42 14.11 14.77 19.63 19.42 26.53 24.07 25.23 24.73 24.45 19.79 21.82 19.34 19.01 0.00 0.00 22.95 <-Median-> 10 Price/AEPS High
Price/AEPS Low 11.42 10.70 10.88 9.84 11.93 13.66 15.23 19.03 17.65 17.53 11.36 17.15 15.16 14.97 0.00 0.00 15.20 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 13.59 11.98 14.77 17.88 19.28 26.06 23.14 21.59 18.34 19.83 18.76 20.13 16.20 14.73 14.02 13.18 19.55 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close 25.32 14.13 16.73 27.22 28.41 34.36 30.64 25.47 18.61 20.26 20.71 22.02 17.16 15.43 14.73 14.02 23.75 <-Median-> 10 Trailing P/AEPS Close
Median Values DPR 10 Yrs 19.23% 5 Yrs   24.37% P/CF 5 Yrs   in order 19.48 21.82 17.15 18.76 -24.38% Diff M/C DPR 75% to 95% best
* Adjusted Basic Earnings per Share
-$0.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.57
-$2.69 $0.00 $0.00 $0.00 $0.00 $3.57
-$0.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.11
-$1.78 $0.00 $0.00 $0.00 $0.00 $3.11
$3.55 <-12 mths 2.01%
Pre-split 2017 $2.17 $2.54 $2.91 $3.04 $6.31 $8.50 $9.90
EPS Basic Class B Shares $0.43 $0.51 $0.58 $0.61 $1.26 $1.70 $1.98 $2.70 $2.64 $2.68 $2.96 $3.33 $3.50 501.37% <-Total Growth 10 EPS Basic Est. Plus
Pre-split 2017 $2.13 $2.50 $2.86 $2.99 $6.19 $8.38 $9.77
EPS Diluted $0.43 $0.50 $0.57 $0.60 $1.24 $1.68 $1.95 $2.66 $2.61 $2.66 $2.94 $3.31 $3.48 $3.77 $4.17 $4.18 508.39% <-Total Growth 10 EPS Diluted Webbroker
Increase 65.12% 17.37% 14.40% 4.55% 107.02% 35.38% 16.59% 36.13% -1.88% 1.92% 10.53% 12.59% 5.14% 8.33% 10.61% 0.24% 10 0 10 Years of Data, EPS P or N
Earnings Yield 7.2% 8.1% 6.7% 3.8% 4.9% 3.7% 3.7% 4.6% 5.2% 4.8% 5.1% 4.9% 6.0% 6.8% 7.6% 7.6% 19.79% <-IRR #YR-> 10 Earnings per Share 508.39%
5 year Running Average $0.47 $0.47 $0.41 $0.47 $0.67 $0.92 $1.21 $1.63 $2.03 $2.31 $2.56 $2.84 $3.00 $3.23 $3.53 $3.78 5.52% <-IRR #YR-> 5 Earnings per Share 30.83%
10 year Running Average $0.43 $0.46 $0.51 $0.54 $0.62 $0.69 $0.84 $1.02 $1.25 $1.49 $1.74 $2.02 $2.31 $2.63 $2.92 $3.17 22.03% <-IRR #YR-> 10 5 yr Running Average 632.42%
* ESP per share (Cdn GAAP) E/P 10 Yrs 4.84% 5Yrs 5.09% 13.04% <-IRR #YR-> 5 5 yr Running Average 84.59%
-$0.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.48
-$2.66 $0.00 $0.00 $0.00 $0.00 $3.48
-$0.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.00
-$1.63 $0.00 $0.00 $0.00 $0.00 $3.00
Dividend* $1.06 $1.19 Estimates Dividend*
Increase 10.42% 12.26% Estimates Increase
Payout Ratio EPS 28.12% 28.54% Estimates Payout Ratio EPS
Special Dividends Class B $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 $0.00 <-Median-> 10 Special Dividends
Pre-split 2017 $0.64 $0.70 $0.78 $0.86 $1.10 $1.50 $2.00
Dividend* $0.13 $0.14 $0.16 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $0.96 $1.06 $1.06 $1.06 515.38% <-Total Growth 10 Dividends
Increase 6.67% 9.37% 11.43% 10.26% 27.91% 36.36% 33.33% 15.00% 13.04% 30.77% 5.88% 16.67% 14.29% 10.42% 0.00% 0.00% 26 0 34 Years of data, Count P, N 76.47%
Average Increases 5 Year Running 9.92% 10.30% 10.26% 8.97% 13.13% 19.07% 23.86% 24.57% 25.13% 25.70% 19.61% 16.27% 16.13% 15.60% 9.45% 8.27% 19.34% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.11 $0.12 $0.13 $0.14 $0.16 $0.20 $0.25 $0.31 $0.38 $0.47 $0.56 $0.64 $0.74 $0.85 $0.93 $1.00 467.07% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 2.27% 2.20% 2.09% 1.32% 1.07% 0.87% 0.89% 0.77% 0.90% 1.16% 1.50% 1.28% 1.56% 1.12% <-Median-> 10 Yield H/L Price
Yield on High  Price 2.04% 1.93% 1.81% 0.99% 0.87% 0.66% 0.73% 0.68% 0.77% 1.00% 1.18% 1.14% 1.39% 0.93% <-Median-> 10 Yield on High  Price
Yield on Low Price 2.57% 2.55% 2.46% 1.97% 1.41% 1.28% 1.15% 0.90% 1.08% 1.39% 2.06% 1.45% 1.77% 1.40% <-Median-> 10 Yield on Low Price
Yield on Close Price 2.16% 2.27% 1.81% 1.09% 0.87% 0.67% 0.76% 0.79% 1.04% 1.23% 1.25% 1.24% 1.66% 1.92% 1.92% 1.92% 1.06% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 30.05% 28.00% 27.27% 28.76% 17.77% 17.90% 20.47% 17.29% 19.92% 25.56% 24.49% 25.38% 27.59% 28.12% 25.42% 25.36% 22.48% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 23.30% 25.25% 32.03% 30.42% 24.48% 21.55% 20.67% 19.10% 18.74% 20.42% 21.68% 22.71% 24.80% 26.36% 26.26% 26.34% 21.62% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 12.65% 13.76% 13.23% 8.86% 9.46% 11.08% 12.48% 11.44% 11.96% 15.58% 14.56% 18.05% 17.12% 14.02% 13.77% #DIV/0! 12.22% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 10.36% 11.34% 12.04% 11.82% 10.92% 10.77% 10.99% 10.93% 11.44% 12.66% 13.31% 14.42% 15.55% 15.70% 15.23% #DIV/0! 11.63% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 12.65% 9.75% 9.91% 9.81% 7.91% 8.62% 9.50% 8.53% 9.25% 11.37% 11.58% 12.64% 13.62% 14.02% 13.77% #DIV/0! 9.65% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 10.75% 10.80% 10.92% 10.70% 9.54% 8.96% 9.04% 8.81% 8.84% 9.56% 10.14% 10.78% 11.80% 12.73% 13.19% #DIV/0! 9.55% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 1.12% 1.06% 5 Yr Med 5 Yr Cl 1.28% 1.24% 5 Yr Med Payout 25.38% 15.58% 11.58% 15.85% <-IRR #YR-> 5 Dividends 108.70%
* Dividends per share  10 Yr Med and Cur. 72.09% 81.12% 5 Yr Med and Cur. 50.36% 55.34% Last Div Inc ---> $0.240 $0.265 10.42% 19.93% <-IRR #YR-> 10 Dividends 515.38%
Dividends Growth 15 16.59% <-IRR #YR-> 15 Dividends 900.00%
Dividends Growth 20 14.15% <-IRR #YR-> 20 Dividends 1311.76%
Dividends Growth 25 12.04% <-IRR #YR-> 25 Dividends 1614.29%
Dividends Growth 30 9.94% <-IRR #YR-> 30 Dividends
Dividends Growth 35 9.21% <-IRR #YR-> 34 Dividends
Dividends Growth 5 -$0.46 $0.00 $0.00 $0.00 $0.00 $0.96 Dividends Growth 5
Dividends Growth 10 -$0.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.96 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.96 Dividends Growth 15
Dividends Growth 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 $0.96 Dividends Growth 20
Dividends Growth 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 $0.96 Dividends Growth 25
Dividends Growth 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 $0.96 Dividends Growth 30
Dividends Growth 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 $0.96 Dividends Growth 35
Historical Dividends Historical High Div 3.52% Low Div 0.75% 10 Yr High 2.05% 10 Yr Low 0.66% Med Div 2.00% Close Div 1.87% Historical Dividends
High/Ave/Median Values Curr diff Exp. -45.35%     156.50% Exp. -6.16% 191.48% Exp. -3.81% Cheap 3.06% High/Ave/Median 
Future Dividend Yield Div Yield 4.01% earning in 5 Years at IRR of 15.85% Div Inc. 108.70% Future Dividend Yield
Future Dividend Yield Div Yield 8.38% earning in 10 Years at IRR of 15.85% Div Inc. 335.54% Future Dividend Yield
Future Dividend Yield Div Yield 17.49% earning in 15 Years at IRR of 15.85% Div Inc. 808.95% Future Dividend Yield
Future Dividend Paid Div Paid $2.21 earning in 5 Years at IRR of 15.85% Div Inc. 108.70% Future Dividend Paid
Future Dividend Paid Div Paid $4.62 earning in 10 Years at IRR of 15.85% Div Inc. 335.54% Future Dividend Paid
Future Dividend Paid Div Paid $9.63 earning in 15 Years at IRR of 15.85% Div Inc. 808.95% Future Dividend Paid
Dividend Covering Cost Total Div $7.27 over 5 Years at IRR of 15.85% Div Cov. #DIV/0! Dividend Covering Cost
Dividend Covering Cost Total Div $20.23 over 10 Years at IRR of 15.85% Div Cov. #DIV/0! Dividend Covering Cost
Dividend Covering Cost Total Div $47.27 over 15 Years at IRR of 15.85% Div Cov. #DIV/0! Dividend Covering Cost
Yield if held 5 years 2.57% 2.27% 2.38% 2.90% 4.58% 5.33% 6.28% 6.16% 3.98% 3.32% 2.08% 1.87% 1.61% 1.83% 1.81% 2.21% 3.65% <-Median-> 10 Paid Median Price
Yield if held 10 years 6.27% 6.41% 4.44% 4.77% 5.84% 6.03% 6.48% 7.02% 8.78% 14.17% 12.78% 13.18% 12.86% 8.12% 5.18% 3.06% 7.90% <-Median-> 10 Paid Median Price
Yield if held 15 years 5.36% 5.26% 4.68% 5.05% 7.64% 14.71% 18.31% 13.11% 14.42% 18.06% 14.48% 13.61% 14.65% 17.90% 22.09% 18.82% 14.45% <-Median-> 10 Paid Median Price
Yield if held 20 years 7.58% 6.95% 8.26% 9.05% 11.28% 12.56% 15.02% 13.79% 15.27% 23.61% 35.29% 38.44% 27.35% 29.39% 28.15% 21.32% 15.15% <-Median-> 10 Paid Median Price
Yield if held 25 years 6.93% 9.49% 9.36% 17.77% 19.87% 24.36% 27.37% 34.87% 30.15% 31.54% 28.79% 31.13% 36.81% 51.96% 25.87% <-Median-> 10 Paid Median Price
Yield if held 30 years 20.44% 28.68% 28.92% 42.65% 41.73% 50.85% 55.79% 54.36% 44.39% 35.33% <-Median-> 6 Paid Median Price
Yield if held 35 years 42.67% 58.47% 45.09% 62.80% 42.67% <-Median-> 1 Paid Median Price
Cost covered if held 5 years 10.90% 9.66% 10.01% 12.09% 17.00% 17.54% 19.58% 20.79% 14.55% 11.53% 8.03% 7.19% 6.25% 7.36% 7.92% 10.38% 13.32% <-Median-> 10 Paid Median Price Item
Cost covered if held 10 years 44.31% 44.85% 30.43% 32.38% 34.79% 30.77% 29.89% 33.69% 44.18% 66.18% 66.89% 70.10% 70.63% 47.17% 34.20% 22.43% 39.49% <-Median-> 10 Paid Median Price EPS
Cost covered if held 15 years 50.17% 48.14% 41.44% 43.99% 57.50% 92.75% 101.97% 74.64% 85.06% 97.48% 86.69% 82.07% 90.45% 116.13% 162.87% 155.30% 85.87% <-Median-> 10 Paid Median Price AEPS
Cost covered if held 20 years 87.56% 77.60% 88.03% 93.58% 99.59% 91.54% 95.01% 87.98% 99.79% 139.44% 229.02% 249.34% 180.63% 203.16% 220.72% 186.85% 99.69% <-Median-> 10 Paid Median Price CFPS
Cost covered if held 25 years 85.69% 113.18% 94.47% 146.09% 139.59% 170.23% 193.58% 220.62% 207.96% 215.92% 199.52% 224.90% 300.56% 473.14% 181.91% <-Median-> 10 Paid Median Price FCF 
Cost covered if held 30 years 154.67% 217.98% 194.85% 310.78% 299.55% 367.27% 417.79% 458.56% 416.50% 258.77% <-Median-> 6 Paid Median Price
Cost covered if held 35 years 320.00% 452.95% 392.22% 605.81% 320.00% <-Median-> 1 Paid Median Price
Special Dividends Class A $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 $0.00 <-Median-> 10 Special Dividends
Pre-split 2017
Dividend* $0.12 $0.13 $0.15 $0.16 $0.21 $0.29 $0.39 $0.45 $0.51 $0.67 $0.71 $0.83 $0.95 $1.05 $1.05 $1.05 549.79% <-Total Growth 10 Dividends
Increase 9.96% 7.41% 12.12% 11.08% 29.56% 38.02% 34.44% 15.78% 12.83% 31.37% 5.97% 16.90% 14.46% 10.53% 0.00% 0.00% 22 1 26 Years of data, Count P, N 84.62%
Average Increases 5 Year Running 11.58% 11.36% 11.16% 9.68% 14.03% 19.64% 25.04% 25.77% 26.13% 26.49% 20.08% 16.57% 16.31% 15.85% 9.57% 8.38% 19.86% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.10 $0.11 $0.12 $0.13 $0.15 $0.19 $0.24 $0.30 $0.37 $0.46 $0.55 $0.63 $0.73 $0.84 $0.92 $0.99 500.85% <-Total Growth 10 Dividends 5 Yr Running
Yr  Item Tot. Growth
Revenue Growth  $4,755.7 $5,161.5 $5,321.3 $5,242.3 $5,732.8 $6,382.2 $6,541.9 <-12 mths 2.50% 34.20% <-Total Growth 5 Revenue Growth  34.20%
AEPS Growth $2.69 $2.73 $2.79 $3.08 $3.37 $3.57 $3.62 <-12 mths 1.40% 32.71% <-Total Growth 5 AEPS Growth 32.71%
Net Income Growth $474.1 $466.8 $477.1 $529.7 $591.1 $622.7 $644.2 <-12 mths 3.45% 31.34% <-Total Growth 5 Net Income Growth 31.34%
Cash Flow Growth $711.2 $772.7 $779.5 $882.9 $838.7 $992.8 $1,004.5 <-12 mths 1.18% 39.60% <-Total Growth 5 Cash Flow Growth 39.60%
Dividend Growth $0.46 $0.52 $0.68 $0.72 $0.84 $0.96 $1.06 <-12 mths 10.42% 108.70% <-Total Growth 5 Dividend Growth 108.70%
Stock Price Growth $58.08 $50.06 $55.32 $57.79 $67.83 $57.84 $55.10 <-12 mths -4.74% -0.41% <-Total Growth 5 Stock Price Growth -0.41%
Revenue Growth  $1,308.6 $1,889.4 $2,585.6 $3,039.1 $3,974.7 $4,755.7 $5,161.5 $5,321.3 $5,242.3 $5,732.8 $6,382.2 $6,541.9 <-12 mths 2.50% 387.73% <-Total Growth 10 Revenue Growth  387.73%
AEPS Growth $0.58 $0.89 $1.31 $1.72 $2.28 $2.69 $2.73 $2.79 $3.08 $3.37 $3.57 $3.62 <-12 mths 1.40% 513.40% <-Total Growth 10 AEPS Growth 513.40%
Net Income Growth $97.5 $103.6 $216.6 $295.1 $346.8 $474.1 $466.8 $477.1 $529.7 $591.1 $622.7 $644.2 <-12 mths 3.45% 538.73% <-Total Growth 10 Net Income Growth 538.73%
Cash Flow Growth $199.3 $333.7 $403.5 $475.3 $564.0 $711.2 $772.7 $779.5 $882.9 $838.7 $992.8 $1,004.5 <-12 mths 1.18% 398.09% <-Total Growth 10 Cash Flow Growth 398.09%
Dividend Growth $0.16 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $0.96 $1.1 <-12 mths 10.42% 515.38% <-Total Growth 10 Dividend Growth 515.38%
Stock Price Growth $8.60 $15.84 $25.17 $44.87 $52.76 $58.08 $50.06 $55.32 $57.79 $67.83 $57.84 $55.10 <-12 mths -4.74% 572.71% <-Total Growth 10 Stock Price Growth 572.71%
Dividends on Shares Class B $9.36 $12.24 $12.96 $15.12 $17.28 $19.08 $19.08 $19.08 $66.96 No of Years 5 Total Divs 12/31/17
Paid  $1,045.44 $901.08 $995.76 $1,040.22 $1,220.94 $1,041.12 $991.80 $991.80 $991.80 $1,041.12 No of Years 5 Worth $58.08
Total $1,108.08
Dividends on Shares Class B $20.12 $25.74 $35.10 $46.80 $53.82 $60.84 $79.56 $84.24 $98.28 $112.32 $124.02 $124.02 $124.02 $616.82 No of Years 10 Total Divs 12/31/12
Paid  $1,005.97 $1,853.75 $2,945.36 $5,250.26 $6,172.92 $6,795.36 $5,857.02 $6,472.44 $6,761.43 $7,936.11 $6,767.28 $6,446.70 $6,446.70 $6,446.70 $6,767.28 No of Years 10 Worth $8.60
Total $7,384.10
Graham No. Class B EPS $6.74 $7.39 $8.22 $8.93 $13.97 $18.67 $21.06 $27.02 $29.72 $31.16 $34.87 $39.35 $43.44 $46.21 $48.60 $48.66 428.61% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 0.84 0.86 0.91 1.46 1.46 1.85 2.13 2.20 1.95 1.88 1.38 1.67 1.42 1.38 1.76 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 0.93 0.98 1.05 1.95 1.81 2.45 2.61 2.51 2.27 2.19 1.75 1.87 1.59 1.54 2.07 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.74 0.74 0.77 0.98 1.11 1.26 1.65 1.89 1.62 1.57 1.00 1.47 1.25 1.21 1.36 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 0.88 0.83 1.05 1.78 1.80 2.40 2.51 2.15 1.68 1.78 1.66 1.72 1.33 1.19 1.13 1.13 1.78 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -12.12% -16.60% 4.63% 77.51% 80.14% 140.37% 150.50% 114.91% 68.45% 77.53% 65.75% 72.38% 33.16% 19.24% 13.38% 13.24% 77.52% <-Median-> 10 Graham Price
Pre-split 2017 $29.62 $30.80 $42.99 $79.22 $125.87 $224.37 $263.80
Price Close Class B $5.92 $6.16 $8.60 $15.84 $25.17 $44.87 $52.76 $58.08 $50.06 $55.32 $57.79 $67.83 $57.84 $55.10 $55.10 $55.10 572.71% <-Total Growth 10 Stock Price
Increase 4.85% 3.98% 39.58% 84.28% 58.89% 78.26% 17.57% 10.08% -13.81% 10.51% 4.46% 17.37% -14.73% -4.74% 0.00% 0.00% 38.61 <-Median-> 10 CAPE (10 Yr P/E)
P/E 13.91 12.32 15.03 26.49 20.33 26.77 27.00 21.83 19.18 20.80 19.66 20.49 16.62 14.62 13.21 13.18 -0.08% <-IRR #YR-> 5 Stock Price -0.41%
Trailing P/E 22.96 14.46 17.20 27.70 42.10 36.25 31.48 29.72 18.82 21.20 21.73 23.07 17.47 15.83 14.62 13.21 21.00% <-IRR #YR-> 10 Stock Price 572.71%
CAPE (10 Yr P/E) 13.87 13.30 16.94 29.60 40.42 64.94 62.82 57.09 40.07 37.14 33.20 33.55 25.01 20.95 18.85 17.36 1.20% <-IRR #YR-> 5 Price & Dividend 5.99%
Median 10, 5 Yrs D.  per yr 2.28% 1.28% % Tot Ret 9.80% 106.92% T P/E 25.39 21.20 P/E:  20.64 19.66 23.28% <-IRR #YR-> 10 Price & Dividend 634.03%
Price 15 D.  per yr 1.57% % Tot Ret 9.70% CAPE Diff -62.14% 14.65% <-IRR #YR-> 15 Stock Price 677.63%
Price  20 D.  per yr 1.57% % Tot Ret 9.81% 14.45% <-IRR #YR-> 20 Stock Price 1386.13%
Price  25 D.  per yr 1.32% % Tot Ret 9.87% 12.07% <-IRR #YR-> 25 Stock Price 1626.57%
Price  30 D.  per yr 1.50% % Tot Ret 11.17% 11.96% <-IRR #YR-> 30 Stock Price 2866.15%
Price  35 D.  per yr 1.59% % Tot Ret 12.59% 11.05% <-IRR #YR-> 35 Stock Price
Price & Dividend 15 16.23% <-IRR #YR-> 15 Price & Dividend 757.33%
Price & Dividend 20 16.02% <-IRR #YR-> 20 Price & Dividend 1549.02%
Price & Dividend 25 13.39% <-IRR #YR-> 25 Price & Dividend 1825.19%
Price & Dividend 30 13.47% <-IRR #YR-> 30 Price & Dividend 3224.62%
Price & Dividend 35 12.64% <-IRR #YR-> 35 Price & Dividend
Price  5 -$58.08 $0.00 $0.00 $0.00 $0.00 $57.84 Price  5
Price 10 -$8.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $57.84 Price 10
Price & Dividend 5 -$58.08 $0.52 $0.68 $0.72 $0.84 $58.80 Price & Dividend 5
Price & Dividend 10 -$8.60 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $58.80 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 $57.84 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 $57.84 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 $57.84 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 $57.84 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 $57.84 Price  35
Price & Dividend 15 $0.13 $0.14 $0.16 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $58.80 Price & Dividend 15
Price & Dividend 20 $0.13 $0.14 $0.16 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $58.80 Price & Dividend 20
Price & Dividend 25 $0.13 $0.14 $0.16 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $58.80 Price & Dividend 25
Price & Dividend 30 $0.13 $0.14 $0.16 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $58.80 Price & Dividend 30
Price & Dividend 35 $0.13 $0.14 $0.16 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $58.80 Price & Dividend 35
Price H/L Median $5.63 $6.37 $7.46 $13.06 $20.47 $34.60 $44.81 $59.53 $57.85 $58.57 $47.97 $65.66 $61.59 $63.55 725.09% <-Total Growth 10 Stock Price
Increase 17.38% 13.15% 17.10% 74.95% 56.75% 69.06% 29.48% 32.86% -2.83% 1.25% -18.11% 36.88% -6.20% 3.18% 23.50% <-IRR #YR-> 10 Stock Price 725.09%
P/E 13.22 12.75 13.05 21.84 16.53 20.65 22.93 22.38 22.16 22.02 16.31 19.84 17.70 16.86 0.68% <-IRR #YR-> 5 Stock Price 3.45%
Trailing P/E 21.83 14.96 14.93 22.83 34.23 27.95 26.73 30.47 21.75 22.44 18.03 22.33 18.61 18.26 25.91% <-IRR #YR-> 10 Price & Dividend 795.73%
P/E on Run. 5 yr Ave 12.11 13.50 18.22 27.74 30.70 37.74 37.10 36.63 28.53 25.33 18.70 23.15 20.53 19.66 1.91% <-IRR #YR-> 5 Price & Dividend 9.70%
P/E on Run. 10 yr Ave 13.19 13.76 14.70 24.40 32.87 50.08 53.35 58.51 46.31 39.32 27.55 32.47 26.63 24.16 15.09 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 2.41% 1.23% % Tot Ret 9.30% 64.30% T P/E 22.63 21.75 P/E:  21.24 19.84 Count 35 Years of data
-$7.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $61.59
-$59.53 $0.00 $0.00 $0.00 $0.00 $61.59
-$7.46 $0.17 $0.22 $0.30 $0.40 $0.46 $0.52 $0.68 $0.72 $0.84 $62.55
-$59.53 $0.52 $0.68 $0.72 $0.84 $62.55
High Months Apr Jul Dec Dec Dec Dec Dec Jun Mar Jul Dec Aug Sep May
Pre-split 2017 $31.43 $36.25 $42.99 $86.97 $126.81 $228.44 $274.45
Price High $6.29 $7.25 $8.60 $17.39 $25.36 $45.69 $54.89 $67.88 $67.50 $68.22 $60.94 $73.52 $69.04 $71.11 702.98% <-Total Growth 10 Stock Price
Increase 10.40% 15.34% 18.59% 102.30% 45.81% 80.14% 20.14% 23.67% -0.56% 1.07% -10.67% 20.64% -6.09% 3.00% 23.16% <-IRR #YR-> 10 Stock Price 702.98%
P/E 14.76 14.50 15.03 29.09 20.49 27.26 28.09 25.52 25.86 25.65 20.73 22.21 19.84 18.86 0.34% <-IRR #YR-> 5 Stock Price 1.71%
Trailing P/E 24.36 17.02 17.20 30.41 42.41 36.90 32.75 34.74 25.38 26.14 22.91 25.01 20.86 20.43 20.61 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 28.27 25.01 P/E:  25.58 22.21 26.14 P/E Ratio Historical High
-$8.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $69.04
-$67.88 $0.00 $0.00 $0.00 $0.00 $69.04
Low Months Feb Sep Jan Jan Jan Jan Feb Jan Dec Jan Mar Jan May Oct
Price Low $4.98 $5.50 $6.33 $8.72 $15.58 $23.52 $34.72 $51.18 $48.19 $48.92 $34.99 $57.79 $54.13 $55.98 755.13% <-Total Growth 10 Stock Price
Increase 27.56% 10.40% 15.13% 37.79% 78.58% 51.00% 47.62% 47.41% -5.84% 1.51% -28.48% 65.16% -6.33% 3.42% 23.94% <-IRR #YR-> 10 Stock Price 755.13%
P/E 11.69 11.00 11.07 14.59 12.58 14.03 17.77 19.24 18.46 18.39 11.90 17.46 15.55 14.85 1.13% <-IRR #YR-> 5 Stock Price 5.76%
Trailing P/E 19.30 12.91 12.66 15.25 26.05 19.00 20.72 26.19 18.12 18.74 13.15 19.66 16.35 16.09 12.07 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 18.87 18.12 P/E:  16.51 17.46 9.72 P/E Ratio Historical Low
-$6.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $54.13
-$51.18 $0.00 $0.00 $0.00 $0.00 $54.13
$491 <-12 mths -10.07%
Free Cash Flow $83.00 $90.00 $106.00 $218.00 $250.00 $303.05 $329.37 $425.50 $419.90 $433.90 $600 $515 $546 $527 $654 415.09% <-Total Growth 10 Free Cash Flow 3 sites agree
Change 8.43% 17.78% 105.66% 14.68% 21.22% 8.69% 29.18% -1.32% 3.33% 38.28% -14.17% 6.02% -3.48% 24.10% 5.11% <-IRR #YR-> 5 Free Cash Flow MS 28.32%
FCF/CF from Op Ratio 0.49 0.53 0.53 0.65 0.62 0.64 0.58 0.60 0.54 0.56 0.68 0.61 0.55 0.39 0.48 17.81% <-IRR #YR-> 10 Free Cash Flow MS 415.09%
Dividends paid $20.73 $23.34 $32.09 $29.41 $37.94 $52.30 $70.17 $81.20 $92.20 $121.10 $128.70 $151 $151 $188.36 $211.46 370.58% <-Total Growth 10 Dividends paid
Percentage paid 24.98% 25.94% 30.27% 13.49% 15.18% 17.26% 21.31% 19.08% 21.96% 27.91% 21.45% 29.32% 27.66% 35.74% 32.33% 21.38% <-Median-> 10 Percentage paid
5 Year Coverage 19.21% 18.10% 18.39% 17.76% 19.32% 21.81% 22.34% 23.98% 25.61% 28.23% 29.22% 19.32% <-Median-> 9 5 Year Coverage
Dividend Coverage Ratio 4.00 3.86 3.30 7.41 6.59 5.79 4.69 5.24 4.55 3.58 4.66 3.41 3.62 2.80 3.09 4.68 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 5.21 5.52 5.44 5.63 5.18 4.58 4.48 4.17 3.90 3.54 3.42 5.18 <-Median-> 9 5 Year of Coverage
-$426 $0 $0 $0 $0 $546
-$106 $0 $0 $0 $0 $0 $0 $0 $0 $0 $546
$524 <-12 mths -8.65%
Free Cash Flow Annual Report $87.0 $92.2 $107.2 $219.7 $264.1 $320.7 $338.6 $438.3 $442.5 $443.8 $616.3 $531.2 $573.4 434.89% <-Total Growth 10 Free Cash Flow Annual 
Change 5.98% 16.27% 104.94% 20.21% 21.43% 5.58% 29.44% 0.96% 0.29% 38.87% -13.81% 7.94% 5.52% <-IRR #YR-> 5 Free Cash Flow MS Report
FCF/CF from Op Ratio 0.52 0.54 0.54 0.66 0.65 0.67 0.60 0.62 0.57 0.57 0.70 0.63 0.58 18.26% <-IRR #YR-> 10 Free Cash Flow MS
Dividends paid $20.73 $23.34 $32.09 $29.41 $37.94 $52.30 $70.17 $81.20 $92.20 $121.10 $128.70 $151 $151 370.58% <-Total Growth 10 Dividends paid
Percentage paid 23.83% 25.32% 29.93% 13.39% 14.37% 16.31% 20.72% 18.53% 20.84% 27.29% 20.88% 28.43% 26.33% 20.78% <-Median-> 10 Percentage paid
5 Year Coverage 18.63% 17.44% 17.75% 17.14% 18.50% 21.02% 21.64% 23.23% 24.70% 18.63% <-Median-> 9 5 Year Coverage
Dividend Coverage Ratio 4.20 3.95 3.34 7.47 6.96 6.13 4.83 5.40 4.80 3.66 4.79 3.52 3.80 4.81 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 5.37 5.73 5.63 5.83 5.40 4.76 4.62 4.31 4.05 5.37 <-Median-> 9 5 Year of Coverage
-$438 $0 $0 $0 $0 $573
-$107 $0 $0 $0 $0 $0 $0 $0 $0 $0 $573
Market Cap $986 $1,038 $1,454 $2,724 $4,367 $7,875 $9,283 $10,271 $8,897 $9,880 $10,321 $12,224 $10,238 $9,791 $9,791 $9,791 604.14% <-Total Growth 10 Market Cap
Pre-split 2017 33.414 33.658 34.097 34.718 35.016 35.210 35.493
Diluted # of Shares in Million 167.070 168.290 170.483 173.590 175.081 176.049 177.463 178.2 178.8 179.1 179.8 180.9 179.2 178.5 5.11% <-Total Growth 10 Diluted
Change 1.71% 0.73% 1.30% 1.82% 0.86% 0.55% 0.80% 0.42% 0.34% 0.17% 0.39% 0.61% -0.94% -0.39% 0.48% <-Median-> 10 Change
Difference Diluted/Basic -1.7% -1.6% -1.8% -1.6% -1.9% -1.4% -1.3% -1.3% -0.6% -0.6% -0.6% -0.7% -0.7% -0.6% -0.98% <-Median-> 10 Difference Diluted/Basic
Pre-split 2017 32.832 33.111 33.484 34.150 34.365 34.716 35.032
Basic # of Shares in Millions 164.160 165.553 167.418 170.749 171.824 173.580 175.162 175.8 177.7 178.0 178.7 179.7 178.0 177.4 6.32% <-Total Growth 10 Basic
Change 1.52% 0.85% 1.13% 1.99% 0.63% 1.02% 0.91% 0.36% 1.08% 0.17% 0.39% 0.56% -0.95% -0.34% 0.59% <-Median-> 10 Change
Difference Basic/Outstanding 1.4% 1.8% 1.0% 0.7% 1.0% 1.1% 0.4% 0.6% 0.0% 0.3% -0.1% 0.3% -0.6% 0.2% 0.39% <-Median-> 10 Difference Basic/Outstanding
$1,004.5 <-12 mths 1.18%
Pre-split 2017 Class B 30.91 31.32 31.45 32.02 32.33 32.73 32.82 Class B.
Pre-split 2017 Class A 2.38 2.38 2.37 2.37 2.37 2.37 2.37 Class A 
# of Share in Millions 33.29 33.69 33.82 34.39 34.69 35.10 35.19
Class B. 154.560 156.575 157.255 160.105 161.625 163.645 164.110 165.0 165.9 166.8 166.8 168.4 165.2 165.9 165.9 165.9 5.05% <-Total Growth 10 Class B. Est Alpha S
Class A  11.875 11.875 11.845 11.840 11.840 11.840 11.835 11.8 11.8 11.8 11.8 11.8 11.8 11.8 11.8 11.8 -0.38% <-Total Growth 10 Class A 
Pre-split 2017
# of Share in Millions 166.44 168.45 169.10 171.95 173.47 175.49 175.95 176.8 177.7 178.6 178.6 180.2 177.0 177.7 177.7 177.7 0.46% <-IRR #YR-> 10 Shares 4.67%
Change 0.72% 1.21% 0.39% 1.68% 0.88% 1.16% 0.26% 0.51% 0.51% 0.49% 0.00% 0.91% -1.79% 0.40% 0.00% 0.00% 0.02% <-IRR #YR-> 5 Shares 0.09%
Cash Flow from Operations $M $168.4 $171.4 $199.3 $333.7 $403.5 $475.3 $564.0 $711.2 $772.7 $779.5 $882.9 $838.7 $992.8 $1,343.4 $1,368.3 398.09% <-Total Growth 10 Cash Flow
Increase 12.06% 1.77% 16.31% 67.44% 20.91% 17.78% 18.68% 26.09% 8.65% 0.88% 13.26% -5.01% 18.37% 35.32% 1.85% Conv A-B SO, S. Issued Buy Backs
5 year Running Average $171.9 $173.7 $181.1 $204.6 $255.3 $316.6 $395.2 $497.6 $585.3 $660.5 $742.1 $797.0 $853.3 $967.5 $1,085.2 371.07% <-Total Growth 10 CF 5 Yr Running
CFPS $1.01 $1.02 $1.18 $1.94 $2.33 $2.71 $3.21 $4.02 $4.35 $4.36 $4.94 $4.65 $5.61 $7.56 $7.70 375.86% <-Total Growth 10 Cash Flow per Share
Increase 11.26% 0.55% 15.86% 64.67% 19.85% 16.42% 18.37% 25.46% 8.10% 0.39% 13.26% -5.86% 20.53% 34.78% 1.85% 17.42% <-IRR #YR-> 10 Cash Flow 398.09%
5 year Running Average $1.05 $1.05 $1.09 $1.21 $1.50 $1.83 $2.27 $2.84 $3.32 $3.73 $4.18 $4.47 $4.78 $5.43 $6.09 6.90% <-IRR #YR-> 5 Cash Flow 39.60%
P/CF on Med Price 5.57 6.27 6.33 6.73 8.80 12.78 13.98 14.80 13.31 13.42 9.70 14.11 10.98 8.41 0.00 16.88% <-IRR #YR-> 10 Cash Flow per Share 375.86%
P/CF on Closing Price 5.85 6.05 7.29 8.16 10.82 16.57 16.46 14.44 11.51 12.67 11.69 14.58 10.31 7.29 7.16 6.88% <-IRR #YR-> 5 Cash Flow per Share 39.46%
-44.11% Diff M/C 15.95% <-IRR #YR-> 10 CFPS 5 yr Running 339.15%
$1,288.1 <-12 mths 3.26%
Excl.Working Capital CF $0.1 $70.4 $67.0 -$32.3 $78.7 $135.6 $176.8 $242.8 $226.6 $288.7 $227.9 $358.6 $254.6 $0.0 $0.0 10.99% <-IRR #YR-> 5 CFPS 5 yr Running 68.40%
CF fr Op $M WC $168.5 $241.8 $266.3 $301.5 $482.3 $610.8 $740.9 $954.0 $999.3 $1,068.2 $1,110.8 $1,197.3 $1,247.4 $1,343.4 $1,368.3 368.37% <-Total Growth 10 Cash Flow less WC
Increase 11.14% 43.55% 10.14% 13.20% 59.97% 26.65% 21.29% 28.77% 4.75% 6.89% 3.99% 7.79% 4.18% 7.70% 1.85% 16.70% <-IRR #YR-> 10 Cash Flow less WC 368.37%
5 year Running Average $165.8 $182.9 $200.3 $225.9 $292.1 $380.5 $480.4 $617.9 $757.5 $874.6 $974.6 $1,065.9 $1,124.6 $1,193.4 $1,253.4 5.51% <-IRR #YR-> 5 Cash Flow less WC 30.75%
CFPS Excl. WC $1.01 $1.44 $1.57 $1.75 $2.78 $3.48 $4.21 $5.39 $5.62 $5.98 $6.22 $6.64 $7.05 $7.56 $7.70 18.83% <-IRR #YR-> 10 CF less WC 5 Yr Run 461.34%
Increase 10.34% 41.83% 9.71% 11.33% 58.57% 25.19% 20.98% 28.12% 4.22% 6.38% 3.99% 6.82% 6.08% 7.27% 1.85% 12.72% <-IRR #YR-> 5 CF less WC 5 Yr Run 82.01%
5 year Running Average $1.01 $1.10 $1.20 $1.34 $1.71 $2.20 $2.76 $3.52 $4.30 $4.94 $5.49 $5.97 $6.30 $6.69 $7.03 16.17% <-IRR #YR-> 10 CFPS - Less WC 347.47%
P/CF on Med Price 5.57 4.44 4.74 7.45 7.36 9.94 10.64 11.03 10.29 9.79 7.71 9.88 8.74 8.41 0.00 5.49% <-IRR #YR-> 5 CFPS - Less WC 30.63%
P/CF on Closing Price 5.85 4.29 5.46 9.04 9.05 12.89 12.53 10.77 8.90 9.25 9.29 10.21 8.21 7.29 7.16 18.03% <-IRR #YR-> 10 CFPS 5 yr Running 424.70%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 13.04 5 yr  13.31 P/CF Med 10 yr 9.84 5 yr  9.79 -25.91% Diff M/C 12.33% <-IRR #YR-> 5 CFPS 5 yr Running 78.85%
-169.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 177.0 Shares
-176.8 0.0 0.0 0.0 0.0 177.0 Shares
-$199.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $992.8 Cash Flow
-$711.2 $0.0 $0.0 $0.0 $0.0 $992.8 Cash Flow
-$1.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.61 Cash Flow per Share
-$4.02 $0.00 $0.00 $0.00 $0.00 $5.61 Cash Flow per Share
-$1.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.78 CFPS 5 yr Running
-$2.84 $0.00 $0.00 $0.00 $0.00 $4.78 CFPS 5 yr Running
-$266.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,247.4 Cash Flow less WC
-$954.0 $0.0 $0.0 $0.0 $0.0 $1,247.4 Cash Flow less WC
-$200.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,124.6 CF less WC 5 Yr Run
-$617.9 $0.0 $0.0 $0.0 $0.0 $1,124.6 CF less WC 5 Yr Run
-$1.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.05 CFPS - Less WC
-$5.39 $0.00 $0.00 $0.00 $0.00 $7.05 CFPS - Less WC
-$1.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.30 CFPS 5 yr Running
-$3.52 $0.00 $0.00 $0.00 $0.0 $6.3 CFPS 5 yr Running
Change in inventories $2.934 -$38.268 $61.380 $8.1 -$62.1 $44.5 -$38.5 -$125.9 -$69.6
Change in trade and other receivables $5.758 -$83.103 $22.834 -$36.1 -$58.5 $90.8 -$43.2 -$129.5 $23.6
Change in prepaid expenses -$0.847 -$0.225 -$4.346 -$7.5 -$1.1 -$1.8 $2.2 -$9.0 -$0.6
Change in trade and other payables $15.446 $129.445 -$100.148 $3.6 $149.4 -$197.1 $48.7 $164.0 $41.9
Change in income taxes receivable and payable -$1.534 -$6.608 -$2.471 $8.4 -$8.6 -$1.7 $9.7 -$2.5 -$4.0
Change in employee benefits $29.526 -$3.378 $16.633 $10.7 -$13.6 $44.9 $20.2 -$20.4 -$12.7
Change in other assets and liabilities -$19.363 $2.827 -$9.895 -$8.1 $1.4 -$63.9 -$29.0 $9.6 $30.4
Chge in assets -$19.029 -$7.231 $112.160 Chge in assets
Interest -$21.930 -$24.235 -$25.405 -$24.163 -$23.909 -$35.991 -$67.3 -$76.8 -$72.3 -$59.4 -$48.1 -$56.7 Interest
Income -$29.481 -$35.538 -$54.503 -$86.505 -$112.332 -$124.829 -$154.6 -$156.7 -$132.1 -$138.6 -$196.8 -$206.9 Income
Sum -$70.440 -$67.004 $32.252 -$78.748 -$135.551 -$176.833 -$242.8 -$226.6 -$288.7 -$227.9 -$358.6 -$254.6 Sum
Google --> TD Bank $32.25 -$78.75 -$135.55 -$176.83 -$243 -$227 -$289 -$228 -$359 -$255
Difference $0.00 $0.00 $0.00 $0.00 $0 $0 $0 $0 $0 $0
TD Bank $32 -$79 -$136 -$177
Difference $0 $0 $0 $0
OPM 14.12% 13.51% 15.23% 17.66% 15.61% 15.64% 14.19% 14.95% 14.97% 14.65% 16.84% 14.63% 15.56% 20.00% 2.12% <-Total Growth 10 OPM
Increase 12.68% -4.34% 12.74% 15.96% -11.64% 0.20% -9.26% 5.39% 0.11% -2.15% 14.97% -13.13% 6.33% 28.59% Should increase  or be stable.
Diff from Ave -7.5% -11.5% -0.2% 15.7% 2.3% 2.5% -7.0% -2.0% -1.9% -4.0% 10.3% -4.1% 1.9% 31.1% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 15.26% 5 Yrs 14.97% should be  zero, it is a   check on calculations
$1,261 <-12 mths 2.38%
Adjusted EBITDA $608.4 $792.0 $959.2 $995.3 $1,067.2 $1,123.2 $1,173.1 $1,231.4 $1,331 $1,396 $1,472 #DIV/0! <-Total Growth 7
Change 30.18% 21.11% 3.76% 7.22% 5.25% 4.44% 4.97%
Margin 20.02% 19.93% 20.17% 19.28% 20.06% 21.43% 20.46% 19.29%
Long Term Debt $345.77 $334.22 $244.33 $664.98 $600.01 $838.42 $1,597.08 $2,100.8 $2,419.8 $2,234.8 $1,889.4 $1,691.4 $2,175.6 $2,106.6 Debt Type
Change -20.54% -3.34% -26.89% 172.16% -9.77% 39.73% 90.49% 31.54% 15.18% -7.65% -15.46% -10.48% 28.63% -3.17% 21.91% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.35 0.32 0.17 0.24 0.14 0.11 0.17 0.20 0.27 0.23 0.18 0.14 0.21 0.22 0.19 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 5.24 6.30 5.13 4.41 4.36 3.92 5.16 4.73 5.22 6.13 5.81 5.38 5.77 6.53 5.19 <-Median-> 10 Assets/Current Liab Ratio Liquidity
Debt to Cash Flow (Years) 2.05 1.95 1.23 1.99 1.49 1.76 2.83 2.95 3.13 2.87 2.14 2.02 2.19 1.57 2.17 <-Median-> 10 Debt to Cash Flow (Years) Liq. + CF
Debt Ratio
Intangibles $38.1 $34.9 $29.6 $207.6 $226.6 $285.3 $549.6 $1,082.7 $1,138.9 $1,028.7 $1,007.6 $991.1 $1,018.3 $984.4 3337.88% <-Total Growth 10 Intangibles Leverage
Goodwill $350.5 $355.8 $353.4 $494.2 $563.7 $876.4 $1,131.8 $1,580.7 $1,830.3 $1,794.4 $1,918.5 $1,975.1 $2,193.5 $2,215.7 520.77% <-Total Growth 10 Goodwill D/E Ratio
Total $388.6 $390.6 $383.0 $701.8 $790.3 $1,161.7 $1,681.4 $2,663.4 $2,969.2 $2,823.1 $2,926.1 $2,966.2 $3,211.8 $3,200.1 738.66% <-Total Growth 10 Total
Change -3.81% 0.53% -1.96% 83.25% 12.61% 47.00% 44.73% 58.40% 11.48% -4.92% 3.65% 1.37% 8.28% -0.36% 12.05% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.39 0.38 0.26 0.26 0.18 0.15 0.18 0.26 0.33 0.29 0.28 0.24 0.31 0.33 0.26 <-Median-> 10 Intangible/Market Cap Ratio
Assets/Current Liabilities Ratio 5.24 6.30 5.13 4.41 4.36 3.92 5.16 4.73 5.22 6.13 5.81 5.38 5.77 6.53 5.19 <-Median-> 10 Assets/Current Liab Ratio
Debt to Cash Flow (Years) 2.31 2.28 1.92 2.10 1.96 2.44 2.98 3.74 3.84 3.62 3.31 3.54 3.24 2.38 3.27 <-Median-> 10 Debt to Cash Flow (Years)
Current Assets $432.57 $426.56 $476.91 $770.19 $821.88 $1,229.86 $1,660.87 $1,851.6 $2,125.2 $2,105.0 $2,224.7 $2,447.6 $2,819.7 $2,707.4 491.24% <-Total Growth 10 Current Assets
Current Liabilities $309.72 $256.24 $322.16 $544.55 $600.20 $912.85 $907.02 $1,299.7 $1,346.9 $1,148.0 $1,262.0 $1,418.0 $1,501.4 $1,321.5 366.05% <-Total Growth 10 Current Liabilities
Liquidity 1.40 1.66 1.48 1.41 1.37 1.35 1.83 1.42 1.58 1.83 1.76 1.73 1.88 2.05 1.65 <-Median-> 10 Ratio
Liq. with CF aft div 1.87 2.24 2.02 1.97 1.98 1.81 2.38 1.91 2.08 2.41 2.36 2.21 2.43 2.92 2.36 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  1.48 1.59 1.53 0.91 1.39 1.16 1.26 0.90 1.37 1.81 1.76 1.60 1.65 2.92 1.65 <-Median-> 5 Ratio
Curr Long Term Debt $0.000 $47.070 $59.058 $167.103 $4.213 $230.6 $71.8 $38.8 $51.8 $15.3 $6.6 $19.8
Liquidity Less CLTD 1.48 1.55 1.52 1.65 1.84 1.73 1.67 1.90 1.84 1.74 1.89 2.08 1.84 <-Median-> 5 Ratio
Liq. with CF aft div 2.02 2.16 2.19 2.22 2.39 2.32 2.20 2.49 2.46 2.23 2.44 2.97 2.44 <-Median-> 5 Ratio
Assets $1,622.4 $1,613.5 $1,654.1 $2,401.6 $2,618.4 $3,582.3 $4,678.8 $6,144.0 $7,027.6 $7,038.0 $7,336.7 $7,627.8 $8,664.4 $8,635.2 423.82% <-Total Growth 10 Assets
Liabilities $833.4 $796.6 $766.9 $1,383.5 $1,402.2 $1,960.4 $2,903.6 $3,986.1 $4,354.5 $4,140.3 $4,054.5 $3,880.8 $4,399.2 $4,162.2 473.64% <-Total Growth 10 Liabilities
Debt Ratio 1.95 2.03 2.16 1.74 1.87 1.83 1.61 1.54 1.61 1.70 1.81 1.97 1.97 2.07 1.77 <-Median-> 10 Ratio
Estimates BVPS $26.60 $29.50 Estimates Estimates BVPS
Estimate Book Value $4,726.8 $5,242.2 Estimates Estimate Book Value
P/B Ratio (Close) 2.07 1.87 Estimates P/B Ratio (Close)
Difference from 10 year median -38.79% Diff M/C Estimates Difference from 10 yr med.
Book Value $789.0 $816.9 $887.2 $1,018.1 $1,216.2 $1,621.9 $1,775.2 $2,157.9 $2,673.1 $2,897.7 $3,282.2 $3,747.0 $4,265.2 $4,473.0 $4,473.0 $4,473.0 380.76% <-Total Growth 10 Book Value
BV per share $4.74 $4.85 $5.25 $5.92 $7.01 $9.24 $10.09 $12.20 $15.04 $16.22 $18.38 $20.79 $24.10 $25.17 $25.17 $25.17 359.30% <-Total Growth 10 Book Value per Share
Change 4.06% 2.30% 8.19% 12.86% 18.41% 31.82% 9.17% 20.95% 23.25% 7.88% 13.27% 13.13% 15.90% 4.46% 0.00% 0.00% -35.31% P/B Ratio Current/10 Year Median
5 Yr Running Average $4.46 $4.62 $4.80 $5.06 $5.55 $6.45 $7.50 $8.89 $10.72 $12.56 $14.39 $16.53 $18.91 $20.93 $22.72 $24.08 $9.81 <-Median-> 10 5 Yr Running Average
P/B Ratio (Median) 1.19 1.31 1.42 2.21 2.92 3.74 4.44 4.88 3.85 3.61 2.61 3.16 2.56 2.52 0.00 0.00 1.34 P/B Ratio Historical Median
P/B Ratio (Close) 1.25 1.27 1.64 2.68 3.59 4.86 5.23 4.76 3.33 3.41 3.14 3.26 2.40 2.19 2.19 2.19 16.47% <-IRR #YR-> 10 Book Value 359.30%
Change 0.75% 1.65% 29.01% 63.28% 34.18% 35.23% 7.70% -8.98% -30.07% 2.44% -7.77% 3.75% -26.43% -8.80% 0.00% 0.00% 14.58% <-IRR #YR-> 5 Book Value 97.47%
Leverage (A/BK) 2.06 1.98 1.86 2.36 2.15 2.21 2.64 2.85 2.63 2.43 2.24 2.04 2.03 1.93 0.00 0.00 2.30 <-Median-> 10 A/BV
Debt/Equity Ratio 1.06 0.98 0.86 1.36 1.15 1.21 1.64 1.85 1.63 1.43 1.24 1.04 1.03 0.93 0.00 0.00 1.30 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.38 5 yr Med 3.16 -35.31% Diff M/C 2.35 Historical Leverage (A/BK)
-$5.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24.10
-$12.20 $0.00 $0.00 $0.00 $0.00 $24.10
$766.90 <-12 mths -9.19%
Comprehensive Income $47.40 $58.92 $88.14 $150.14 $210.59 $404.60 $224.73 $431.70 $565.50 $297.70 $473.30 $537.0 $844.5
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.44 $0.00 $0.00 $0.00 $0.00 $0.0 $0.0
Comprehensive Income $47.40 $58.92 $88.14 $150.14 $210.59 $404.60 $225.18 $431.70 $565.50 $297.70 $473.30 $537.0 $844.5 858.11% <-Total Growth 10 Comprehensive Income
Increase 302.31% 24.30% 49.60% 70.34% 40.26% 92.12% -44.35% 91.72% 30.99% -47.36% 58.99% 13.46% 57.26% 30.99% <-Median-> 5 Comprehensive Income
5 Yr Running Average $60.04 $52.46 $54.44 $71.28 $111.04 $182.48 $215.73 $284.44 $367.51 $384.94 $398.68 $461.0 $543.6 25.36% <-IRR #YR-> 10 Comprehensive Income 858.11%
ROE 6.0% 7.2% 9.9% 14.7% 17.3% 24.9% 12.7% 20.0% 21.2% 10.3% 14.4% 14.3% 19.8% 14.36% <-IRR #YR-> 5 Comprehensive Income 95.62%
5Yr Median 8.8% 7.2% 7.2% 7.2% 9.9% 14.7% 14.7% 17.3% 20.0% 20.0% 14.4% 14.4% 14.4% 25.87% <-IRR #YR-> 10 5 Yr Running Average 898.58%
% Difference from NI -33.4% -30.0% -9.6% 44.9% -2.8% 37.1% -35.1% -8.9% 21.1% -37.6% -10.6% -9.2% 35.6% 13.83% <-IRR #YR-> 5 5 Yr Running Average 91.11%
Median Values Diff 5, 10 yr -5.9% -9.2% 14.4% <-Median-> 5 Return on Equity
-$88.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $844.5
-$431.7 $0.0 $0.0 $0.0 $0.0 $844.5
-$54.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $543.6
-$284.4 $0.0 $0.0 $0.0 $0.0 $543.6
Current Liability Coverage Ratio 0.54 0.94 0.83 0.55 0.80 0.67 0.82 0.73 0.74 0.93 0.88 0.84 0.83 1.02   CFO / Current Liabilities
5 year Median 0.57 0.63 0.63 0.57 0.80 0.80 0.80 0.73 0.74 0.74 0.82 0.84 0.84 0.88 0.84 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 10.38% 14.99% 16.10% 12.55% 18.42% 17.05% 15.83% 15.53% 14.22% 15.18% 15.14% 15.70% 14.40% 15.56% CFO / Total Assets
5 year Median 10.12% 10.38% 10.38% 12.55% 14.99% 16.10% 16.10% 15.83% 15.83% 15.53% 15.18% 15.18% 15.14% 15.18% 15.1% <-Median-> 5 Return on Assets 
Return on Assets ROA 4.4% 5.2% 5.9% 4.3% 8.3% 8.2% 7.4% 7.7% 6.6% 6.8% 7.2% 7.7% 7.2% 7.8% Net  Income/Assets Return on Assets
5Yr Median 4.4% 4.4% 4.4% 4.4% 5.2% 5.9% 7.4% 7.7% 7.7% 7.4% 7.2% 7.2% 7.2% 7.2% 7.2% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 9.0% 10.3% 11.0% 10.2% 17.8% 18.2% 19.5% 22.0% 17.5% 16.5% 16.1% 15.8% 14.6% 15.1% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 9.0% 9.0% 9.0% 10.2% 10.3% 11.0% 17.8% 18.2% 18.2% 18.2% 17.5% 16.5% 16.1% 15.8% 16.1% <-Median-> 5 Return on Equity
$644.2 <-12 mths 3.45%
EPS by o/s Shares $0.43 $0.50 $0.58 $0.60 $1.25 $1.68 $1.97 $2.68 $2.63 $2.67 $2.97 $3.28 $3.52 510.22% <-Total Growth 10 By o/s Shares
Net Income $71.14 $84.13 $97.49 $103.59 $216.57 $295.08 $346.31 $474.10 $466.80 $477.1 $529.7 $591.1 $622.7 538.73% <-Total Growth 10 Net Income
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.44 $0.00 $0.00 $0.0 $0.0 $0.0 $0.0
Net Income $71.14 $84.13 $97.49 $103.59 $216.57 $295.08 $346.75 $474.10 $466.80 $477.1 $529.7 $591.1 $622.7 $674 $746 538.73% <-Total Growth 10 Net Income Est Alpha S
Increase 68.68% 18.26% 15.89% 6.26% 109.06% 36.25% 17.51% 36.73% -1.54% 2.21% 11.02% 11.59% 5.35% 8.24% 10.68% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $77.3 $78.7 $68.6 $79.7 $114.6 $159.4 $211.9 $287.2 $359.9 $412.0 $458.9 $507.8 $537.5 $578.9 $632.7 20.37% <-IRR #YR-> 10 Net Income 538.73%
Operating Cash Flow $168.40 $171.38 $199.32 $333.74 $403.53 $475.26 $564.04 $711.20 $772.70 $779.5 $882.9 $838.7 $992.8 5.60% <-IRR #YR-> 5 Net Income 31.34%
Investment Cash Flow -$82.60 -$104.43 -$103.65 -$642.31 -$255.22 -$511.32 -$796.81 -$1,464.30 -$696.10 -$376.1 -$428.0 -$541.3 -$706.6 22.86% <-IRR #YR-> 10 5 Yr Running Average 683.70%
Total Accruals -$14.66 $17.18 $1.81 $412.16 $68.26 $331.14 $579.53 $1,227.20 $390.20 $73.7 $74.8 $293.7 $336.5 13.35% <-IRR #YR-> 5 5 Yr Running Average 87.13%
Total Assets $1,622.4 $1,613.5 $1,654.1 $2,401.6 $2,618.4 $3,582.3 $4,678.8 $6,144.0 $7,027.6 $7,038.0 $7,336.7 $7,627.8 $8,664.4 Balance Sheet Assets
Accruals Ratio -0.90% 1.06% 0.11% 17.16% 2.61% 9.24% 12.39% 19.97% 5.55% 1.05% 1.02% 3.85% 3.88% 3.85% <-Median-> 5 Ratio
EPS/CF Ratio 0.42 0.35 0.36 0.34 0.45 0.48 0.46 0.49 0.46 0.44 0.47 0.50 0.49 0.47 <-Median-> 10 EPS/CF Ratio
-$97.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $622.7
-$474.1 $0.0 $0.0 $0.0 $0.0 $622.7
-$68.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $537.5
-$287.2 $0.0 $0.0 $0.0 $0.0 $537.5
Chge in Close 4.85% 3.98% 39.58% 84.28% 58.89% 78.26% 17.57% 10.08% -13.81% 10.51% 4.46% 17.37% -14.73% -4.74% 0.00% 0.00% Count 28 Years of data
up/down down down down down down down Count 14 50.00%
Meet Prediction? Yes % right Count 4 28.57%
Financial Cash Flow -$53.31 -$99.13 -$46.25 $314.55 -$138.21 $190.79 $439.58 $733.00 $67.3 -$256.2 -$461.3 -$370.0 -$72.6 C F Statement  Financial Cash Flow
Total Accruals $38.65 $116.32 $48.07 $97.61 $206.46 $140.36 $139.95 $494.20 $322.9 $329.9 $536.1 $663.7 $409.1 Accruals
Accruals Ratio 2.38% 7.21% 2.91% 4.06% 7.89% 3.92% 2.99% 8.04% 4.59% 4.69% 7.31% 8.70% 4.72% 4.72% <-Median-> 5 Ratio
Cash $173.20 $140.70 $188.97 $209.10 $221.87 $405.69 $585.08 $557.50 $589.10 $703.6 $703.7 $602.1 $839.5 $737.8 Cash
Change 15.01% -18.76% 34.31% 10.65% 6.11% 82.85% 44.22% -4.71% 5.67% 19.44% 0.01% -14.44% 39.43% -12.11%
Cash per Share $1.04 $0.84 $1.12 $1.22 $1.28 $2.31 $3.33 $3.15 $3.31 $3.94 $3.94 $3.34 $4.74 $4.15 $3.94 <-Median-> 5 Cash per Share
Percentage of Stock Price 17.57% 13.56% 13.00% 7.68% 5.08% 5.15% 6.30% 5.43% 6.62% 7.12% 6.82% 4.93% 8.20% 7.54% 6.82% <-Median-> 5 % of Stock Price
http://business.financialpost.com/2013/03/25/the-canadian-stock-that-flew-under-the-radar-to-the-top-return-on-the-tsx/
postive view of CCL
Notes:
October 15, 2023.  Last estimates were for 2022, 2023 and 2024 of $6382M, $6676M and $6811M for Revenue, $3.64, $3.88 and $4.09 for AEPS, $3.59, $3.89 and $4.09 for EPS, 
$0.96, $1.07 and $1.16 for Dividends, $579M, $671M and $790M for FCF, $6.05, $6.37 and $6.10 for CFPS, $22.60, $25.10 and $27.60 for BVPS, $642M, $692M and $745M for Net Income.
October 18, 2022.  Last estimates were for 2021, 2022 and 2023 of $5575M, $5793M and $6141M for Revenue, $3.35, $3.55 and $3.70 for EPS, 
$0.84, $0.93 and $0.96 for Dividends, $558M, $621M and $660M for FCF, $5.84, $6.06 for 2021/2 for CFPS, $615M and $638M for 2021/2 for Net Income.
October 16, 2021.  Last estimates were for 2020, 2021 and 2022 of $5157M, $5388M and $5625M for Revenue, $2.56, $2.78 and $3.05 for EPS, 
$0.72, $0.81 and $0.92 for Dividends,$478M, $490m and $527M for FCF, $4.75, $5.15 and $6.19 and $450M, $502M for 2020 and 2021 for Net Income.
October 25, 2020.  Last estimates were for 2019, 2020 and 2021 of $544M, $6537M and $6537M for Revenue, $2.77, $3.14, $3.42 for EPS, 
$6.06 and $5.10 for CFPS for 2019 and 2020 and $509M, $580M and $611M for Net Income.
October 27, 2019.  Last estimates were for 2018, 2019 and 2020 of $5134M, $5480M and $5659M for Revenue, $2.87, $3.25 and $3.52 for EPS, 
$5.19, $5.46 and $5.05 for CFPS and $520M, $581M and $623M for Net Income.
October 30, 2018.  Last estimates were for 2017, 2018 and 2019 of $4326M, $5143M and $5295M for Revenue, $2.51. $3.01 and $3.31 for EPS, 
$3.07, $3.70 and $4.14 for CFPS and $438M, $535M and $571M for Net Income.
November 5, 2017.  Last estimates were for 2016, 2017 and 2018 of $$4013M, $4430M and $4553M for Revenue, $10.10, $12.00 and $13.00 for EPS, 
$18.60, $20.20 and $19.20 for CFPS, $345M, $425M and $418M for Net Income.
November 6, 2016.  Last estimates were for 2015, 2016 and 2017 of $2976M, $3222M and $3343M for Revenue, $7.43, $9.02 and $10.10 for EPS, 
$14.90, $15.60 and $16.40 for CFPS, and $284M, $315M and $353M for Net Income.
November 15, 2015.  Last estimates were for 2014, 2015 and 2016 and $2591M, $2707M and $2816M of Revenue, $6.51, $7.37 and $8.07 for EPS, 
$12.20, $11.60 and $12.40 for CFPS, $228M, $258M and $282M for Net Income.
November 8, 2014.  Last estimates were for 2013, 2014 and 2015 of M1859M, $2302M and $2354M for Revenue, $3.37, $5.42 and $6.36 for EPS, $8.79, $9.76 and $10.10 for CFPS.
November 22, 2013.  Last estimates were for 2012 and 2013 of $1321.3M and $1369.3M for Revenue and $2.85 and $3.06 for EPS.
On July 1, 2013, CCL completed the acquisition of businesses from Avery Dennison. The acquisition of Avery Dennison's businesses will transform CCL industries. 
Nov 20, 2012.  Last estimates I got were for 2011 and 2012 at $1247M and $1304M for Revenue, $2.54 and $2.79 for EPS and $5.53 and $5.81 for EPS.
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.
1999.  It went public on the Toronto Stock Exchange in 1999? Says on Wikipedia, but I have data back to 1987.
In 1979, the name was changed to CCL Industries.
1951.  CCL was founded in 1951 as Connecticut Chemicals (Canada) Limited. 
Sector
Materials
The basic materials sector is a category of stocks that accounts for companies involved with the discovery, development and processing of raw materials.
Basic Materials,  Industry: Containers & Packaging
What should this stock accomplish?
You would buy this company for diversification.  I would expect moderate dividend yield and moderate dividend growth.  
Would I buy this company and Why.
I would consider this company when the dividend yield gets above 1%.  At the moment, it is not really a dividend company as the dividend is too low. 
Why am I following this stock. 
In 2009 I read a favorable report on this stock of which I had also heard before.   This is also a dividend paying stock and in 2009 it was on Dividend Achievers list.
Dividends
Dividends are paid in cycle 3, which is March, June, September and December.  Dividends are declared for shareholders of record in one month and paid in that month.
For example, dividends for December 2013 were declared in November for payment to shareholders of record of December 3 and payable on December 20, 2013.
How they make their money.
CCL Industries Inc manufactures and sells packaging and packaging-related products. The company operates through various segments, which include the CCL segment, 
the Avery segment, and the Checkpoint segment. Its geographical segments include Canada; USA and Puerto Rico; Mexico, Brazil, Chile, and Argentina; Europe; and Asia, Australia, Africa, and New Zealand.   
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.
(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
The shares of 1281228 are owned as to one half each by Donald G. Lang and Stuart W. Lang.
Shares; '%, Value $M %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2015 Nov 6 2016 Nov 5 2017 Oct 30 2018 Oct 27 2019 Oct 25 2020 Oct 16 2021 Oct 18 2022 Oct 15 2023
Martin, Geoffrey 0.82% 1.656 0.94% 1.509 0.85% 6.009 3.38% 1.646 0.92% 1.646 0.92% 1.651 0.92% 1.660 0.94% 1.673 0.94% B 0.81%
CEO - Shares - Amount $64.95 $87.35 $87.668 $300.832 $91.049 $95.114 $111.990 $96.006 $92.197 B
Options - percentage 0.67% 0.813 0.46% 1.838 1.04% 1.746 0.98% 0.843 0.47% 0.920 0.52% 0.524 0.29% 0.542 0.31% 0.478 0.27% -11.83%
Options - amount $52.59 $42.87 $106.722 $87.417 $46.640 $53.191 $35.573 $31.341 $26.326
Washchuk, Sean 0.02% 0.037 0.02% 0.037 0.02% 0.037 0.02% 0.052 0.03% 0.052 0.03% 0.052 0.03% 0.053 0.03% 0.052 0.03% B -2.74%
CFO - Shares - Amount $1.67 $1.96 $2.155 $1.857 $2.880 $3.008 $3.531 $3.066 $2.841 B
Options - percentage 0.11% 0.295 0.17% 0.212 0.12% 0.340 0.19% 0.384 0.22% 1.009 0.57% 0.236 0.13% 0.231 0.13% 0.187 0.10% -19.17%
Options - amount $8.69 $15.56 $12.290 $17.038 $21.257 $58.338 $16.011 $13.346 $10.277
Birkner, Gunther 0.166 0.09% 0.247 0.14% 0.070 0.04% 0.070 0.04% 0.090 0.05% 0.087 0.05% 0.117 0.07% B 34.95%
Officer - Shares - Amount $9.635 $12.372 $3.887 $4.060 $6.107 $5.006 $6.436 B
Options - percentage 0.328 0.19% 0.312 0.18% 0.443 0.25% 0.486 0.27% 0.336 0.19% 0.293 0.17% 0.277 0.16% -5.53%
Options - amount $19.064 $15.618 $24.524 $28.081 $22.792 $16.959 $15.262
Cooper, Mark 0.011 0.01% 0.015 0.01% B 37.74%
Officer - Shares - Amount $0.644 $0.845 B
Options - percentage 0.160 0.09% 0.163 0.09% 1.99%
Options - amount $9.246 $8.984
Horn, Alan Douglas 0.002 0.02% 0.010 0.08% 0.010 0.08% 0.010 0.08% 0.010 0.08% A ceased insider Jan 2023 -100.00%
Director - Shares - Amount $0.11 $0.553 $0.578 $0.678 $0.578 A
Shares - percentage 0.19% 0.293 0.17% 0.240 0.13% 0.240 0.13% 0.240 0.13% 0.100 0.06% B -100.00%
Shares - amount $14.70 $15.43 $13.277 $13.870 $16.279 $5.784 B
Options - percentage 0.05% 0.097 0.06% 0.001 0.00% 0.002 0.00% 0.002 0.00% 0.003 0.00% -100.00%
Options - amount $4.29 $5.13 $0.035 $0.088 $0.143 $0.160
Galifi, Vincent Joseph 0.001 0.00% 0.001 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% 0.003 0.00% B 0.00%
Director - Shares - Amount $0.060 $0.066 $0.173 $0.203 $0.174 $0.165 B
Options - percentage 0.005 0.00% 0.006 0.00% 0.007 0.00% 0.007 0.00% 0.008 0.00% 0.009 0.00% 8.54%
Options - amount $0.237 $0.318 $0.389 $0.500 $0.469 $0.484
Lang, Erin Melissa 0.876 0.49% 0.876 0.49% B 0.00%
Director - Shares - Amount $50.666 $48.266 B
Options - percentage 0.009 0.01% 0.010 0.01% 7.58%
Options - amount $0.544 $0.557
Lang, Donald G. 0.00% 0.000 0.00% 0.001 0.01% 0.005 0.04% 0.005 0.04% 0.005 0.04% 0.005 0.04% 0.000 0.00% 0.000 0.00% A
Chairman - Shares - Amt $0.01 $0.01 $0.044 $0.225 $0.249 $0.260 $0.305 $0.000 $0.000 A
Shares - percentage 0.33% 0.579 0.33% 0.659 0.37% 0.978 0.55% 0.978 0.55% 1.855 1.04% 1.928 1.07% 1.379 0.78% 4.495 2.53% B 225.93%
Shares - amount $25.98 $30.54 $38.262 $48.982 $54.129 $107.226 $130.806 $79.777 $247.699 B
Options - percentage 0.38% 0.784 0.45% 0.659 0.37% 0.534 0.30% 0.346 0.19% 0.121 0.07% 0.000 0.00% 0.036 0.02% 0.037 0.02% 3.25%
Options - amount $29.73 $41.35 $38.257 $26.717 $19.152 $7.004 $0.000 $2.085 $2.051
1281228 Ontario Inc. 6.39% 56.047 473.57% 56.047 474.97% 56.047 474.09% 0.056 0.47% 0.056 0.47% A Shares of 1281228 are  0.00%
Shares - Amt $503.01 $3,255.21 $3,238.956 $3,801.668 $3.242 $3.088 A owned as to one half each 
Class B 13.90% 26.426 14.94% 23.798 13.32% 23.798 13.20% 23.798 13.44% 20.681 11.64% B by Donald G. Lang and  -13.09%
Shares - Amt $1,094.93 ######## $1,375.264 $1,614.192 $1,376.454 $1,139.546 B Stuart W. Lang.
Increase in O/S Shares 0.88% 2.020 1.15% 0.500 0.28% 0.900 0.51% 0.900 0.51% 0.900 0.50% 0.600 0.34% 1.000 0.55% 0.200 0.11%
due to SO $38.264 $50.851 $26.380 $52.272 $45.054 $49.788 $34.674 $67.830 $11.568
Book Value $10.678 $22.286 $6.817 $18.000 $27.200 $29.200 $31.300 $62.100 $11.900
Insider Buying -$0.209 -$0.362 -$0.102 -$0.058 $0.000 -$0.089 -$2.212 -$0.149 $0.000
Insider Selling $73.078 $40.431 $55.184 $34.957 $30.804 $28.256 $66.279 $10.685 $19.181
Net Insider Selling $72.869 $40.069 $55.083 $34.899 $30.804 $28.166 $64.067 $10.537 $19.181
% of Market Cap 0.93% 0.43% 0.54% 0.39% 0.31% 0.27% 0.52% 0.10% 0.20%
Directors 9 11 10 10 10 11 11 10
Women 20% 2 22% 3 27% 3 30% 3 30% 3 30% 4 36% 4 36% 4 40%
Minorities 0% 0 0% 0 0% 0 0% 0 0% 0 0% 1 9% 1 9% 1 10%
Institutions/Holdings 35.90% 180 33.72% 180 33.72% 20 28.16% 20 33.35% 20 30.63% 20 26.48%
Total Shares Held 33.39% 11.069 31.45% 11.069 31.45% 50.297 28.16% 59.855 33.21% 54.192 30.62% 47.040 26.47%
Increase/Decrease -1.68% -0.084 -0.75% -0.084 -0.75% -10.840 -17.73% -3.585 -5.65% -3.585 -6.20% 2.206 4.92%
Starting No. of Shares 11.152 11.152 Reuters 61.137 Top 20 MS 63.439 Top 20 MS 57.777 Top 20 MS 44.835 Top 20 MS
Institutions/Holdings 277 45.57%
Percentage $4,502.010
Total Shares Held 56.000 31.51%
Percentage $2,803.360
Increase/Decrease 3 Mths 0.160 0.29%
Starting No. of Shares 55.840 Moringstar
Pre-split dates uses pre-split values.
Above change and using split AE8
Copyright © 2008 Website of SPBrunner. All rights reserved.