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
Linamar Corporation TSX: LNR OTC: LIMAF https://www.linamar.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
Split
$7,813.6 <-12 mths 12.55%
$468.1 <-12 mths 5.81%
Cost of Sales $5,467.2 $6,383.6 $6,350.8 $5,027.2 $5,598.9 $6,942.1 $7,813.6 <-12 mths 26.98% <-Total Growth 5 Cost of Sales
Change 16.76% -0.51% -20.84% 11.37% 23.99% 12.55% <-12 mths 11.37% <-Median-> 5 Change
Ratio 0.84 0.84 0.86 0.86 0.86 0.88 0.87 <-12 mths 0.86 <-Median-> 6 Ratio
Selling & Admin , other $332.9 $465.8 $387.6 $343.0 $362.9 $442.4 $468.1 <-12 mths 32.88% <-Total Growth 5 Selling & Admin , other
Change 39.92% -16.80% -11.49% 5.79% 21.91% 5.81% <-12 mths 5.79% <-Median-> 5 Change
Ratio 0.05 0.06 0.05 0.06 0.06 0.06 0.05 <-12 mths 0.06 <-Median-> 6 Ratio
Total $5,800.1 $6,849.4 $6,738.3 $5,370.2 $5,961.8 $7,384.5 $8,281.6 <-12 mths 27.32% <-Total Growth 5 Total
Change 18.09% -1.62% -20.30% 11.02% 23.86% 12.15% <-12 mths 11.02% <-Median-> 5 Change
Ratio 0.89 0.90 0.91 0.92 0.91 0.93 0.92 <-12 mths 0.91 <-Median-> 6 Ratio
$9,003.7 <-12 mths 13.71%
Sales* $2,229.2 $2,861.4 $3,221.9 $3,595.5 $4,171.6 $5,162.5 $6,005.6 $6,546.5 $7,620.6 $7,416.6 $5,815.6 $6,536.6 $7,917.9 $9,523 $10,392 $11,459 145.75% <-Total Growth 10 Revenue
Increase 33.01% 28.36% 12.60% 11.59% 16.02% 23.75% 16.33% 9.01% 16.41% -2.68% -21.59% 12.40% 21.13% 20.27% 9.13% 10.27% 9.41% <-IRR #YR-> 10 Revenue 145.75%
5 year Running Average $2,147.6 $2,267.4 $2,449.1 $2,716.8 $3,215.9 $3,802.6 $4,431.4 $5,096.3 $5,901.3 $6,550.3 $6,681.0 $6,787.2 $7,061.5 $7,441.9 $8,037.0 $9,165.7 3.88% <-IRR #YR-> 5 Revenue 20.95%
Revenue per Share $34.45 $44.23 $49.79 $55.52 $64.10 $79.21 $92.03 $100.17 $116.60 $113.68 $88.85 $99.87 $128.69 $154.77 $168.90 $186.24 11.17% <-IRR #YR-> 10 5 yr Running Average 188.33%
Increase 33.01% 28.36% 12.59% 11.50% 15.45% 23.58% 16.18% 8.85% 16.41% -2.50% -21.84% 12.40% 28.85% 20.27% 9.13% 10.27% 6.74% <-IRR #YR-> 5 5 yr Running Average 38.56%
5 year Running Average $32.15 $34.52 $37.85 $41.98 $49.62 $58.57 $68.13 $78.20 $90.42 $100.34 $102.27 $103.84 $109.54 $117.17 $128.22 $147.69 9.96% <-IRR #YR-> 10 Revenue per Share 158.44%
P/S (Price/Sales) Med 0.53 0.41 0.38 0.60 0.89 0.96 0.63 0.68 0.51 0.40 0.54 0.77 0.50 0.45 0.00 0.00 5.14% <-IRR #YR-> 5 Revenue per Share 28.47%
P/S (Price/Sales) Close 0.59 0.32 0.47 0.80 1.11 0.94 0.63 0.73 0.39 0.43 0.76 0.75 0.48 0.42 0.38 0.35 11.21% <-IRR #YR-> 10 5 yr Running Average 189.40%
P/S (Price/Sales) Close 10 year run. 0.50 0.48 0.45 0.45 0.45 0.48 0.57 0.57 0.57 0.57 0.57 0.62 0.62 0.59 0.53 0.51 6.97% <-IRR #YR-> 5 5 yr Running Average 40.07%
*Revenue in M CDN $  P/S Med 20 yr  0.51 15 yr  0.53 10 yr  0.62 5 yr  0.51 -32.23% Diff M/C
-$3,221.9 $0.0 $0.0 $0.0 $0.0 $0 $0 $0 $0 $0 $7,918
-$6,546 $0 $0 $0 $0 $7,918
-$2,449.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $7,061.5
-$5,096.3 $0.0 $0.0 $0.0 $0.0 $7,061.5
-$49.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $128.69
-$100.17 $0.00 $0.00 $0.00 $0.00 $128.69
-$37.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $109.54
-$78.20 $0.00 $0.00 $0.00 $0.00 $109.54
$8.09 <-12 mths 29.23%
Adjusted Profit CDN$ $88.9 $101.4 $146.1 $229.8 $320.6 $436.7 $522.5 $551.5 $583.8 $464.4 $314.6 $428.4 $400.5
Basic $1.37 $1.57 $2.26 $3.55 $4.95 $6.71 $8.01 $8.45 $8.93 $7.11 $4.82 $6.55 $6.27 177.42% <-Total Growth 10 AEPS
AEPS* Dilued $1.36 $1.56 $2.25 $3.52 $4.90 $6.63 $7.92 $8.35 $8.82 $7.08 $4.81 $6.53 $6.26 $8.59 $9.88 $11.22 178.22% <-Total Growth 10 AEPS
Increase 286.30% 14.71% 44.23% 56.44% 39.20% 35.31% 19.46% 5.43% 5.63% -19.73% -32.06% 35.76% -4.13% 37.22% 15.02% 13.56% 10 0 10 Years of Data, EPS P or N 100.00%
5 year Running Average $0.93 $0.96 $1.10 $1.59 $2.72 $3.77 $5.04 $6.26 $7.32 $7.76 $7.40 $7.12 $6.70 $6.65 $7.21 $8.50 10.77% <-IRR #YR-> 10 AEPS 178.22%
AEPS Yield 6.68% 11.14% 9.70% 7.97% 6.91% 8.87% 13.73% 11.41% 19.47% 14.41% 7.13% 8.71% 10.21% 13.25% 15.24% 17.30% -5.60% <-IRR #YR-> 5 AEPS -25.03%
Payout Ratio 17.65% 20.51% 14.22% 9.09% 8.16% 6.03% 5.05% 5.75% 5.44% 6.78% 7.48% 10.41% 12.78% 10.24% 8.91% 7.84% 19.82% <-IRR #YR-> 10 5 yr Running Average 510.20%
5 year Running Average 11.30% 11.97% 11.76% 9.01% 13.93% 11.60% 8.51% 6.82% 6.09% 5.81% 6.10% 7.17% 8.58% 9.54% 9.97% 10.04% 1.35% <-IRR #YR-> 5 5 yr Running Average 6.96%
Price/AEPS Median 13.50 11.59 8.36 9.50 11.61 11.50 7.37 8.13 6.79 6.35 9.93 11.79 10.21 8.04 0.00 0.00 9.72 <-Median-> 10 Price/AEPS Median
Price/AEPS High 17.02 14.87 10.32 12.55 14.70 13.38 9.33 9.64 8.59 7.51 14.67 13.58 12.96 9.09 0.00 0.00 12.76 <-Median-> 10 Price/AEPS High
Price/AEPS Low 9.97 8.31 6.40 6.45 8.53 9.62 5.41 6.62 4.99 5.19 5.19 10.00 7.46 7.00 0.00 0.00 6.53 <-Median-> 10 Price/AEPS Low
Price/AEPS Close 14.96 8.97 10.31 12.55 14.48 11.27 7.28 8.77 5.14 6.94 14.02 11.47 9.79 7.55 6.56 5.78 10.53 <-Median-> 10 Price/AEPS Close
Trailing P/AEPS Close -27.88 10.29 14.87 19.64 20.16 15.25 8.70 9.24 5.43 5.57 9.52 15.58 9.39 10.36 7.55 6.56 9.46 <-Median-> 10 Trailing P/AEPS Close
Median Values DPR 10 Yrs 7.13% 5 Yrs   7.48% P/CF 5 Yrs   in order 9.93 12.96 5.19 9.79 -23.98% Diff M/C DPR 75% to 95% best
* Normalized Earnings per Share
-$2.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.26
-$8.35 $0.00 $0.00 $0.00 $0.00 $6.26
-$1.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.70
-$6.26 $0.00 $0.00 $0.00 $0.00 $6.70
$7.68 <-12 mths 15.14%
EPS Basic $1.37 $1.57 $2.26 $3.55 $4.95 $6.71 $8.01 $8.41 $9.05 $6.59 $4.27 $6.43 $6.67 195.13% <-Total Growth 10 EPS Basic
Pre-split '93
Pre-split '98
EPS Diluted* $1.36 $1.56 $2.25 $3.52 $4.90 $6.63 $7.92 $8.32 $8.94 $6.56 $4.27 $6.41 $6.67 $8.42 $9.13 $11.22 196.44% <-Total Growth 10 EPS Diluted G&M Est.
Increase -286% 14.71% 44.23% 56.44% 39.20% 35.31% 19.46% 5.05% 7.45% -26.62% -34.91% 50.12% 4.06% 26.24% 8.43% 22.89% 10 0 10 Years of Data, EPS P or N WSJ Est.
Earnings Yield 6.7% 11.1% 9.7% 8.0% 6.9% 8.9% 13.7% 11.4% 19.7% 13.4% 6.3% 8.6% 10.9% 13.0% 14.1% 17.3% 11.48% <-IRR #YR-> 10 Earnings per Share 196.44%
5 year Running Average $0.93 $0.96 $1.10 $1.59 $2.72 $3.77 $5.04 $6.26 $7.34 $7.67 $7.20 $6.90 $6.57 $6.47 $6.98 $8.37 -4.32% <-IRR #YR-> 5 Earnings per Share -19.83%
10 year Running Average $0.94 $1.03 $1.18 $1.47 $1.83 $2.35 $3.00 $3.68 $4.47 $5.20 $5.49 $5.97 $6.41 $6.90 $7.33 $7.79 19.59% <-IRR #YR-> 10 5 yr Running Average 498.36%
* ESP per share (Cdn GAAP) E/P 10 Yrs 9.88% 5Yrs 10.88% 0.98% <-IRR #YR-> 5 5 yr Running Average 4.99%
-$2.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.67
-$8.32 $0.00 $0.00 $0.00 $0.00 $6.67
-$1.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.57
-$6.26 $0.00 $0.00 $0.00 $0.00 $6.57
Comment
Dividend* $1.13 $0.92 $0.92 Estimates Dividend*
Increase 41.25% -18.58% 0.00% Estimates Increase
Payout Ratio EPS 13.42% 10.08% 8.20% Estimates 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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Pre-split '98
Dividend* $0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $0.80 $0.88 $0.88 $0.88 150.00% <-Total Growth 10 Dividends
Increase 100.00% 33.33% 0.00% 0.00% 25.00% 0.00% 0.00% 20.00% 0.00% 0.00% -25.00% 88.89% 17.65% 10.00% 0.00% 0.00% 11 2 27 Years of data, Count P, N 40.74%
Average Increases 5 Year Running 10.00% 16.67% 16.67% 16.67% 31.67% 11.67% 5.00% 9.00% 9.00% 4.00% -1.00% 16.78% 16.31% 18.31% 18.31% 23.31% 10.33% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.22 $0.23 $0.25 $0.26 $0.32 $0.35 $0.37 $0.40 $0.43 $0.45 $0.44 $0.50 $0.56 $0.64 $0.72 $0.82 125.81% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.31% 1.77% 1.70% 0.96% 0.70% 0.52% 0.69% 0.71% 0.80% 1.07% 0.75% 0.88% 1.25% 1.27% 0.78% <-Median-> 10 Yield H/L Price
Yield on High  Price 1.04% 1.38% 1.38% 0.72% 0.56% 0.45% 0.54% 0.60% 0.63% 0.90% 0.51% 0.77% 0.99% 1.13% 0.62% <-Median-> 10 Yield on High  Price
Yield on Low Price 1.77% 2.47% 2.22% 1.41% 0.96% 0.63% 0.93% 0.87% 1.09% 1.31% 1.44% 1.04% 1.71% 1.46% 1.07% <-Median-> 10 Yield on Low Price
Yield on Close Price 1.18% 2.29% 1.38% 0.72% 0.56% 0.54% 0.69% 0.66% 1.06% 0.98% 0.53% 0.91% 1.31% 1.36% 1.36% 1.36% 0.71% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 17.65% 20.51% 14.22% 9.09% 8.16% 6.03% 5.05% 5.77% 5.37% 7.32% 8.43% 10.61% 11.99% 10.45% 9.64% 7.84% 7.74% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 23.23% 24.12% 22.59% 16.58% 11.77% 9.33% 7.30% 6.39% 5.88% 5.84% 6.11% 7.19% 8.52% 9.90% 10.32% 9.84% 7.24% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 7.90% 9.13% 5.87% 3.55% 4.76% 3.77% 2.91% 3.99% 4.54% 2.68% 1.64% 4.90% 10.51% 5.75% 4.63% 4.17% 3.88% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 5.93% 6.36% 6.02% 5.15% 5.44% 4.76% 3.90% 3.72% 3.90% 3.45% 2.89% 3.25% 3.90% 4.18% 4.63% 5.36% 3.90% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 7.09% 6.67% 6.08% 4.37% 4.45% 3.58% 2.91% 3.54% 3.12% 3.49% 3.05% 5.16% 5.69% 7.45% 6.82% 6.82% 3.56% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 5.99% 6.08% 6.13% 5.64% 5.38% 4.69% 3.96% 3.65% 3.44% 3.31% 3.22% 3.67% 4.11% 4.95% 5.65% 6.35% 3.81% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 0.78% 0.71% 5 Yr Med 5 Yr Cl 0.88% 0.98% 5 Yr Med Payout 8.43% 4.54% 3.49% 10.76% <-IRR #YR-> 5 Dividends 66.67%
* Dividends per share  10 Yr Med and Cur. 74.50% 91.46% 5 Yr Med and Cur. 53.59% 38.89% Last Div Inc ---> $0.20 $0.22 10.00% 9.60% <-IRR #YR-> 10 Dividends 150.00%
Dividends Growth 15 8.36% <-IRR #YR-> 15 Dividends 233.33%
Dividends Growth 20 8.38% <-IRR #YR-> 20 Dividends 400.00%
Dividends Growth 25 7.43% <-IRR #YR-> 25 Dividends 500.02%
Dividends Growth 30 8.28% <-IRR #YR-> 27 Dividends
Dividends Growth 5 -$0.48 $0.00 $0.00 $0.00 $0.00 $0.80 Dividends Growth 5
Historical Dividends Historical High Div 2.79% Low Div 0.45% 10 Yr High 1.69% 10 Yr Low 0.46% Med Div 1.19% Close Div 1.12% Historical Dividends
High/Ave/Median Values Curr diff Exp. -51.36%     201.55% Exp. -19.71% 195.00% Cheap 14.03% Cheap 21.21% High/Ave/Median 
Future Dividend Yield Div Yd 2.26% earning in 5 Years at IRR of 10.76% Div Inc. 66.67% Future Dividend Yield
Future Dividend Yield Div Yd 3.77% earning in 10 Years at IRR of 10.76% Div Inc. 177.78% Future Dividend Yield
Future Dividend Yield Div Yd 6.28% earning in 15 Years at IRR of 10.76% Div Inc. 362.96% Future Dividend Yield
Div Paid $1.47 earning in 5 Years at IRR of 10.76% Div Inc. 66.67% Future Dividend Paid Div Pd
Div Paid $2.44 earning in 10 Years at IRR of 10.76% Div Inc. 177.78% Future Dividend Paid $1.47
Div Paid $4.07 earning in 15 Years at IRR of 10.76% Div Inc. 362.96% Future Dividend Paid $2.44
$4.07
Total Div $5.45 over 5 Years at IRR of 10.76% Div Cov. 8.41% Dividend Covering Cost
Total Div $13.08 over 10 Years at IRR of 10.76% Div Cov. 20.17% Dividend Covering Cost
Total Div $25.78 over 15 Years at IRR of 10.76% Div Cov. 39.76% Dividend Covering Cost
Yield if held 5 years 1.72% 2.29% 1.61% 3.09% 4.53% 2.18% 2.21% 2.55% 1.44% 0.84% 0.47% 1.17% 1.18% 1.47% 1.96% 1.84% 1.81% <-Median-> 10 Paid Median Price
Yield if held 10 years 1.76% 2.50% 2.87% 2.95% 3.06% 2.86% 2.86% 2.41% 4.64% 5.44% 1.96% 3.76% 4.25% 2.63% 1.55% 1.15% 3.01% <-Median-> 10 Paid Median Price
Yield if held 15 years 3.95% 2.98% 1.42% 1.21% 1.96% 2.93% 3.12% 4.30% 4.43% 3.67% 2.57% 4.86% 4.02% 8.51% 9.97% 4.79% 3.40% <-Median-> 10 Paid Median Price
Yield if held 20 years 8.48% 5.91% 6.58% 3.72% 2.14% 1.82% 2.36% 2.63% 5.30% 7.17% 8.12% 6.73% 6.29% 4.51% <-Median-> 10 Paid Median Price
Yield if held 25 years 12.72% 7.09% 5.93% 6.33% 3.56% 3.34% 4.32% 6.44% 6.33% <-Median-> 5 Paid Median Price
Yield if held 30 years 23.31% 13.00% 14.49% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 7.72% 8.29% 6.22% 12.76% 18.13% 9.59% 10.17% 10.63% 6.46% 3.94% 2.89% 4.25% 4.13% 5.34% 8.01% 8.63% 8.02% <-Median-> 10 Paid Median Price Item
Cost covered if held 10 years 14.33% 16.53% 20.42% 22.52% 20.50% 20.31% 21.45% 16.26% 33.64% 43.51% 21.57% 23.89% 25.52% 16.03% 10.26% 8.29% 22.05% <-Median-> 10 Paid Median Price EPS
Cost covered if held 15 years 43.73% 26.70% 13.60% 12.28% 17.08% 27.20% 30.88% 38.33% 42.46% 37.64% 36.04% 39.18% 30.31% 64.57% 84.31% 44.02% 33.46% <-Median-> 10 Paid Median Price AEPS
Cost covered if held 20 years 98.28% 60.71% 72.70% 43.81% 22.50% 20.47% 28.07% 43.29% 50.21% 63.41% 71.99% 65.19% 65.50% 47.01% <-Median-> 10 Paid Median Price CFPS
Cost covered if held 25 years 155.50% 93.80% 108.92% 66.88% 34.97% 32.61% 45.74% 73.42% 93.80% <-Median-> 5 Paid Median Price FCF 
Cost covered if held 30 years 240.26% 146.97% 176.74% #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $5,815.6 $6,536.6 $7,917.9 $20,270.1 36.15% <-Total Growth 2 Revenue Growth  36.15%
AEPS Growth $4.81 $6.53 $6.26 $17.60 30.15% <-Total Growth 2 AEPS Growth 30.15%
Net Income Growth $279.1 $420.6 $426.2 $1,125.9 52.68% <-Total Growth 2 Net Income Growth 52.68%
Cash Flow Growth $1,434.1 $908.8 $468.1 $2,811.0 -67.36% <-Total Growth 2 Cash Flow Growth -67.36%
Dividend Growth $0.36 $0.68 $0.80 $1.84 122.22% <-Total Growth 2 Dividend Growth 122.22%
Stock Price Growth $67.42 $74.93 $61.30 -9.08% <-Total Growth 2 Stock Price Growth -9.08%
Revenue Growth  $6,546.5 $7,620.6 $7,416.6 $5,815.6 $6,536.6 $7,917.9 $41,853.7 20.95% <-Total Growth 5 Revenue Growth  20.95%
AEPS Growth $8.35 $8.82 $7.08 $4.81 $6.53 $6.26 $41.85 -25.03% <-Total Growth 5 AEPS Growth -25.03%
Net Income Growth $549.4 $591.5 $430.4 $279.1 $420.6 $426.2 $2,697.2 -22.42% <-Total Growth 5 Net Income Growth -22.42%
Cash Flow Growth $785.9 $691.2 $1,167.7 $1,434.1 $908.8 $468.1 $5,455.8 -40.44% <-Total Growth 5 Cash Flow Growth -40.44%
Dividend Growth $0.48 $0.48 $0.48 $0.36 $0.68 $0.80 $3.28 66.67% <-Total Growth 5 Dividend Growth 66.67%
Stock Price Growth $73.21 $45.30 $49.13 $67.42 $74.93 $61.30 -16.27% <-Total Growth 5 Stock Price Growth -16.27%
Revenue Growth  $3,221.9 $3,595.5 $4,171.6 $5,162.5 $6,005.6 $6,546.5 $7,620.6 $7,416.6 $5,815.6 $6,536.6 $7,917.9 $64,010.7 145.75% <-Total Growth 10 Revenue Growth  145.75%
AEPS Growth $2.25 $3.52 $4.90 $6.63 $7.92 $8.35 $8.82 $7.08 $4.81 $6.53 $6.26 $67.07 178.22% <-Total Growth 10 AEPS Growth 178.22%
Net Income Growth $146.1 $229.8 $320.6 $436.7 $522.1 $549.4 $591.5 $430.4 $279.1 $420.6 $426.2 $4,352.4 191.71% <-Total Growth 10 Net Income Growth 191.71%
Cash Flow Growth $352.8 $583.7 $546.5 $691.9 $896.1 $785.9 $691.2 $1,167.7 $1,434.1 $908.8 $468.1 $8,526.8 32.70% <-Total Growth 10 Cash Flow Growth 32.70%
Dividend Growth $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $0.80 $5.1 150.00% <-Total Growth 10 Dividend Growth 150.00%
Stock Price Growth $23.20 $44.19 $70.95 $74.73 $57.69 $73.21 $45.30 $49.13 $67.42 $74.93 $61.30 164.22% <-Total Growth 10 Stock Price Growth 164.22%
Dividends on Shares $14.08 $17.60 $17.60 $17.60 $21.12 $21.12 $21.12 $15.84 $29.92 $35.20 $38.72 $38.72 $38.72 $211.20 No of Years 10 Total Divs 12/31/12
Paid  $1,020.80 $1,944.36 $3,121.80 $3,288.12 $2,538.36 $3,221.24 $1,993.20 $2,161.72 $2,966.48 $3,296.92 $2,697.20 $2,853.40 $2,853.40 $2,853.40 $2,697.20 No of Years 10 Worth $23.20
Total $2,908.40
Graham No. AEPS $20.11 $22.22 $29.34 $40.67 $53.20 $71.90 $84.10 $94.60 $107.46 $99.20 $84.84 $101.60 $104.95 $120.23 $128.95 $137.41 257.67% <-Total Growth 10 Graham Price AEPS
Price/GP Ratio Med 0.91 0.81 0.64 0.82 1.07 1.06 0.69 0.72 0.56 0.45 0.56 0.76 0.61 0.57 0.71 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Hi 1.15 1.04 0.79 1.09 1.35 1.23 0.88 0.85 0.70 0.54 0.83 0.87 0.77 0.65 0.86 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.67 0.58 0.49 0.56 0.79 0.89 0.51 0.58 0.41 0.37 0.29 0.64 0.44 0.50 0.53 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Cl 1.01 0.63 0.79 1.09 1.33 1.04 0.69 0.77 0.42 0.50 0.79 0.74 0.58 0.54 0.50 0.47 0.76 <-Median-> 10 Price/GP Ratio
Prem/Disc CL 1.21% -36.99% -20.94% 8.66% 33.37% 3.93% -31.40% -22.61% -57.85% -50.47% -20.54% -26.25% -41.59% -46.06% -49.71% -52.81% -24.43% <-Median-> 10 Graham Price
Graham No. EPS $20.11 $22.22 $29.34 $40.67 $53.20 $71.90 $84.10 $94.43 $108.19 $95.48 $79.94 $100.67 $108.33 $119.04 $123.96 $137.41 269.20% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 0.91 0.81 0.64 0.82 1.07 1.06 0.69 0.72 0.55 0.47 0.60 0.76 0.59 0.58 0.71 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Hi 1.15 1.04 0.79 1.09 1.35 1.23 0.88 0.85 0.70 0.56 0.88 0.88 0.75 0.66 0.88 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.67 0.58 0.49 0.56 0.79 0.89 0.51 0.59 0.41 0.38 0.31 0.65 0.43 0.50 0.53 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Cl 1.01 0.63 0.79 1.09 1.33 1.04 0.69 0.78 0.42 0.51 0.84 0.74 0.57 0.54 0.52 0.47 0.76 <-Median-> 10 Price/GP Ratio
Prem/Disc CL 1.21% -36.99% -20.94% 8.66% 33.37% 3.93% -31.40% -22.47% -58.13% -48.55% -15.66% -25.57% -43.42% -45.52% -47.68% -52.81% -24.02% <-Median-> 10 Graham Price
Price Close $20.35 $14.00 $23.20 $44.19 $70.95 $74.73 $57.69 $73.21 $45.30 $49.13 $67.42 $74.93 $61.30 $64.85 $64.85 $64.85 164.22% <-Total Growth 10 Stock Price
Increase 46.09% -31.20% 65.71% 90.47% 60.56% 5.33% -22.80% 26.90% -38.12% 8.45% 37.23% 11.14% -18.19% 5.79% 0.00% 0.00% 10.28 <-Median-> 10 CAPE (10 Yr P/E)
P/E 14.96 8.97 10.31 12.55 14.48 11.27 7.28 8.80 5.07 7.49 15.79 11.69 9.19 7.70 7.10 5.78 -3.49% <-IRR #YR-> 5 Stock Price -16.27%
Trailing P/E -27.88 10.29 14.87 19.64 20.16 15.25 8.70 9.24 5.44 5.50 10.28 17.55 9.56 9.72 7.70 7.10 10.20% <-IRR #YR-> 10 Stock Price 164.22%
CAPE (10 Yr P/E) 14.12 12.97 12.59 12.29 12.91 12.73 11.42 10.77 9.80 9.10 9.47 9.72 9.65 9.26 8.64 8.01 -2.66% <-IRR #YR-> 5 Price & Dividend -12.44%
Median 10, 5 Yrs D.  per yr 1.31% 0.83% % Tot Ret 11.36% 0.00% T P/E 9.92 9.56 P/E:  10.23 9.19 11.51% <-IRR #YR-> 10 Price & Dividend 184.91%
Price 15 D.  per yr 1.11% % Tot Ret 12.63% CAPE Diff -25.08% 7.67% <-IRR #YR-> 15 Stock Price 203.17%
Price  20 D.  per yr 1.49% % Tot Ret 12.83% 10.14% <-IRR #YR-> 20 Stock Price 590.32%
Price  25 D.  per yr 0.70% % Tot Ret 17.89% 3.23% <-IRR #YR-> 25 Stock Price 121.54%
Price  30 D.  per yr 1.69% % Tot Ret 14.06% 10.31% <-IRR #YR-> 30 Stock Price 1797.83%
Price  35 D.  per yr 2.24% % Tot Ret 14.69% 13.00% <-IRR #YR-> 34 Stock Price
Price & Dividend 15 8.78% <-IRR #YR-> 15 Price & Dividend 233.04%
Price & Dividend 20 11.63% <-IRR #YR-> 20 Price & Dividend 670.05%
Price & Dividend 25 3.94% <-IRR #YR-> 25 Price & Dividend 149.93%
Price & Dividend 30 11.99% <-IRR #YR-> 30 Price & Dividend 149.93%
Price & Dividend 35 15.24% <-IRR #YR-> 34 Price & Dividend
Price  5 -$73.21 $0.00 $0.00 $0.00 $0.00 $61.30 Price  5
Price 10 -$23.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $61.30 Price 10
Price & Dividend 5 -$73.21 $0.48 $0.48 $0.36 $0.68 $62.10 Price & Dividend 5
Price & Dividend 10 -$23.20 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $62.10 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 $61.30 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 $61.30 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 $61.30 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 $61.30 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 $61.30 Price  35
Price & Dividend 15 $0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $62.10 Price & Dividend 15
Price & Dividend 20 $0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $62.10 Price & Dividend 20
Price & Dividend 25 $0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $62.10 Price & Dividend 25
Price & Dividend 30 $0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $62.10 Price & Dividend 30
Price & Dividend 35 $0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $62.10 Price & Dividend 35
Price Close $20.35 $14.00 $23.20 $44.19 $70.95 $74.73 $57.69 $73.21 $45.30 $49.13 $67.42 $74.93 $61.30 $64.85 $64.85 $64.85 847.45% <-Total Growth 28 Stock Price
5 yr Period ending 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 9.64% <-IRR #YR-> 29 5 year periods, Price & Div
5 year IRR Price & Dividends 13.13% 1.80% 3.94% 66.95% 39.73% 30.78% 34.30% 26.95% 1.46% -6.35% -1.42% 6.14% -2.66% 8.63% 3.94% <-Median-> 25 5 year IRR, Price & Div
Div Yield Beg. of period 2.04% 1.73% 1.19% 6.49% 0.86% 1.18% 2.29% 1.38% 0.72% 0.56% 0.54% 0.69% 0.66% 1.06%
P/S Beginning of period 0.39 0.43 0.61 0.11 0.54 0.59 0.32 0.47 0.80 1.11 0.94 0.63 0.73 0.39
P/E Beginning of Period 8.33 9.93 12.88 3.52 -19.08 14.96 8.97 10.31 12.55 14.48 11.27 7.28 8.80 5.07
Dividend Yield end of period 1.18% 2.29% 1.38% 0.72% 0.56% 0.54% 0.69% 0.66% 1.06% 0.98% 0.53% 0.91% 1.31% 1.36%
P/S End of period 0.59 0.32 0.47 0.80 1.11 0.94 0.63 0.73 0.39 0.43 0.76 0.75 0.48 0.42
P/E End of Period 14.96 8.97 10.31 12.55 14.48 11.27 7.28 8.80 5.07 7.49 15.79 11.69 9.19 7.70
Dates Price & Dividend
$0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $0.80 $65.73
-$45.30 $0.48 $0.36 $0.68 $0.80 $65.73
-$73.21 $0.48 $0.48 $0.36 $0.68 $62.10 12/31/22 Price & Dividend
-$57.69 $0.48 $0.48 $0.48 $0.36 $75.61 12/31/21 Price & Dividend
-$74.73 $0.40 $0.48 $0.48 $0.48 $67.78 12/31/20 Price & Dividend
-$70.95 $0.40 $0.40 $0.48 $0.48 $49.61 12/31/19 Price & Dividend
-$44.19 $0.40 $0.40 $0.40 $0.48 $45.78 12/31/18 Price & Dividend
-$23.20 $0.32 $0.40 $0.40 $0.40 $73.69 12/31/17 Price & Dividend
-$14.00 $0.32 $0.32 $0.40 $0.40 $58.09 12/31/16 Price & Dividend
-$20.35 $0.32 $0.32 $0.32 $0.40 $75.13 12/31/15 Price & Dividend
$0.24 $0.32 $0.32 $0.32 $71.35 12/31/14 Price & Dividend
$0.24 $0.32 $0.32 $44.51 12/31/13 Price & Dividend
$0.24 $0.32 $23.52 12/31/12 Price & Dividend
$0.24 $14.32 12/31/11 Price & Dividend
$20.59 12/31/10 Price & Dividend
12/31/09 Price & Dividend
12/31/08 Price & Dividend
12/31/07 Price & Dividend
12/31/06 Price & Dividend
12/31/05 Price & Dividend
12/31/04 Price & Dividend
12/31/03 Price & Dividend
12/31/02 Price & Dividend
12/31/01 Price & Dividend
12/31/00 Price & Dividend
12/31/99 Price & Dividend
Price Median H/L $18.36 $18.09 $18.81 $33.45 $56.91 $76.25 $58.35 $67.86 $59.88 $44.96 $47.77 $76.97 $63.92 $69.09 239.82% <-Total Growth 10 Stock Price
Increase 107.99% -1.47% 4.01% 77.80% 70.15% 33.99% -23.47% 16.30% -11.76% -24.92% 6.25% 61.13% -16.95% 8.08% 13.01% <-IRR #YR-> 10 Stock Price 239.82%
P/E 13.50 11.59 8.36 9.50 11.61 11.50 7.37 8.16 6.70 6.85 11.19 12.01 9.58 8.20 -1.19% <-IRR #YR-> 5 Stock Price -5.81%
Trailing P/E -25.14 13.30 12.06 14.86 16.17 15.56 8.80 8.57 7.20 5.03 7.28 18.02 9.97 10.36 14.47% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 19.74 18.80 17.13 21.01 20.94 20.21 11.57 10.84 8.16 5.86 6.63 11.15 9.73 10.68 -0.34% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 19.63 17.54 16.01 22.75 31.11 32.43 19.43 18.45 13.40 8.65 8.71 12.89 9.97 10.01 11.59 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 1.46% 0.85% % Tot Ret 10.06% -246.56% T P/E 9.39 7.28 P/E:  9.54 9.58 Count 35 Years of data
-$18.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $63.92
-$67.86 $0.00 $0.00 $0.00 $0.00 $63.92
-$18.81 $0.32 $0.40 $0.40 $0.40 $0.48 $0.48 $0.48 $0.36 $0.68 $64.72
-$67.86 $0.48 $0.48 $0.36 $0.68 $64.72
High Months Nov Jan Dec Dec Dec Jun Jan Nov Jan Mar Dec Mar Jan Aug
Pre-split 1993
Pre-split 1998
Price High $23.15 $23.20 $23.22 $44.19 $72.01 $88.73 $73.89 $80.46 $75.73 $53.17 $70.55 $88.65 $81.16 $78.07 249.53% <-Total Growth 10 Stock Price
Increase 48.87% 0.22% 0.09% 90.31% 62.96% 23.22% -16.72% 8.89% -5.88% -29.79% 32.69% 25.66% -8.45% -3.81% 13.33% <-IRR #YR-> 10 Stock Price 249.53%
P/E 17.02 14.87 10.32 12.55 14.70 13.38 9.33 9.67 8.47 8.11 16.52 13.83 12.17 9.27 0.17% <-IRR #YR-> 5 Stock Price 0.87%
Trailing P/E -31.71 17.06 14.88 19.64 20.46 18.11 11.14 10.16 9.10 5.95 10.75 20.76 12.66 11.70 15.18 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 11.90 10.75 P/E:  12.36 12.17 19.43 P/E Ratio Historical High
-$23.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $81.16
-$80.46 $0.00 $0.00 $0.00 $0.00 $81.16
Low Months Jan Sep Jan Apr Jan Aug Jul Apr Dec Oct Mar Jan May May
Price Low $13.56 $12.97 $14.40 $22.70 $41.80 $63.76 $42.81 $55.26 $44.03 $36.74 $24.98 $65.28 $46.68 $60.10 224.17% <-Total Growth 10 Stock Price
Increase 545.71% -4.35% 11.03% 57.64% 84.14% 52.54% -32.86% 29.08% -20.32% -16.56% -32.01% 161.33% -28.49% 28.75% 12.48% <-IRR #YR-> 10 Stock Price 224.17%
P/E 9.97 8.31 6.40 6.45 8.53 9.62 5.41 6.64 4.93 5.60 5.85 10.18 7.00 7.14 -3.32% <-IRR #YR-> 5 Stock Price -15.53%
Trailing P/E -18.58 9.54 9.23 10.09 11.88 13.01 6.46 6.98 5.29 4.11 3.81 15.29 7.28 9.01 8.31 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 7.13 5.29 P/E:  6.55 5.85 6.28 P/E Ratio Historical Low
-$14.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.68
-$55.26 $0.00 $0.00 $0.00 $0.00 $46.68
$155 <-12 mths 244.44%
Free Cash Flow WSJ $335.80 $533.89 $367.67 $117.57 $599.93 $1,146.77 $666.40 $37.06 -88.96% <-Total Growth 7 All disagree
Change 58.99% -31.13% -68.02% 410.26% 91.15% -41.89% -94.44% -0.31 <-Median-> 7
Free Cash Flow MS -$55 -$122 -$15 $324 $277 $347 $544 $206 $133 $609 $1,142 $654 $45 $249 $317 $449 400.00% <-Total Growth 10 Free Cash Flow
Change -121.82% 87.70% 2260.00% -14.51% 25.27% 56.77% -62.13% -35.44% 357.89% 87.52% -42.73% -93.12% 453.33% 27.31% 41.64% -26.23% <-IRR #YR-> 5 Free Cash Flow MS -78.16%
FCF/CF from Op Ratio -0.28 -0.54 -0.04 0.56 0.51 0.50 0.61 0.26 0.19 0.52 0.80 0.72 0.10 450.28 3439.69 #DIV/0! #NUM! <-IRR #YR-> 10 Free Cash Flow MS 400.00%
Dividends paid $20.71 $20.71 $20.71 $25.94 $26.05 $26.08 $31.34 $31.37 $31.33 $23.50 $44.51 $44.51 $54.14 $54.14 $54.14 114.95% <-Total Growth 10 Dividends paid
Percentage paid 7.51% 4.79% 15.21% 23.59% 5.14% 2.06% 6.81% 98.90% 21.74% 17.08% 12.06% $0.07 <-Median-> 8 Percentage paid
5 Year Coverage 7.95% 5.45% 5.91% 6.78% 7.34% 9.17% 14.67% 5 Year Coverage
Dividend Coverage Ratio 13.32 20.86 6.57 4.24 19.44 48.60 14.69 1.01 4.60 5.85 8.29 14.01 <-Median-> 8 Dividend Coverage Ratio
5 Year of Coverage 12.58 18.34 16.93 14.74 13.63 10.90 6.82 5 Year of Coverage
-$206.00 0.00 0.00 0.00 0.00 45.00
$15.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 45.00
Market Cap $1,317 $906 $1,501 $2,862 $4,618 $4,870 $3,765 $4,785 $2,961 $3,205 $4,413 $4,904 $3,772 $3,990 $3,990 $3,990 151.25% <-Total Growth 10 Market Cap
Diluted earnings calc $8.94 $6.56 $4.27 $6.41 $6.67 $4.09 Diluted earnings calc
Diluted calc 64.99 65.42 65.86 65.93 66.03 66.16 65.62 65.37 65.61 63.90 61.61 Diluted calc
Diluted # of Shares in Million 64.85 64.82 64.90 65.21 65.42 65.84 65.91 66.06 66.18 65.59 65.33 65.57 63.93 61.61 -1.50% <-Total Growth 10 Diluted
Change 0.23% -0.04% 0.13% 0.47% 0.33% 0.65% 0.10% 0.23% 0.18% -0.89% -0.40% 0.36% -2.49% -3.63% 0.21% <-Median-> 10 Change
Difference Diluted/Basic -0.2% -0.2% -0.3% -0.7% -0.9% -1.1% -1.1% -1.2% -1.3% -0.5% 0.0% -0.2% -0.1% -0.2% -0.83% <-Median-> 10 Difference Diluted/Basic
Ave Cal NI/EPS 64.51 64.60 64.65 Ave Cal NI/EPS
Basic # of Shares in Millions 64.70 64.70 64.70 64.72 64.82 65.11 65.19 65.30 65.35 65.28 65.31 65.45 63.88 61.46 -1.27% <-Total Growth 10 Basic
Change 0.00% 0.00% 0.00% 0.03% 0.15% 0.44% 0.12% 0.16% 0.09% -0.11% 0.04% 0.22% -2.40% -3.78% 0.10% <-Median-> 10 Change
Difference Basic/Outstanding 0.0% 0.0% 0.0% 0.1% 0.4% 0.1% 0.1% 0.1% 0.0% -0.1% 0.2% 0.0% -3.7% 0.1% 0.07% <-Median-> 10 Difference Basic/Outstanding
$781.85 <-12 mths 67.02%
pre-split '98
# of Share in Millions 64.70 64.70 64.71 64.76 65.08 65.17 65.26 65.35 65.35 65.24 65.45 65.45 61.53 61.53 61.53 61.53 -0.50% <-IRR #YR-> 10 Shares -4.91%
Change 0.00% 0.00% 0.01% 0.09% 0.49% 0.14% 0.13% 0.15% 0.00% -0.18% 0.32% 0.00% -5.99% 0.00% 0.00% 0.00% -1.20% <-IRR #YR-> 5 Shares -5.85%
CF fr Op $M $196.5 $226.8 $352.8 $583.7 $546.5 $691.9 $896.1 $785.9 $691.2 $1,167.7 $1,434.1 $908.8 $468.1 $727.0 $794.0 $794.0 32.70% <-Total Growth 10 Cash Flow
Increase -34.10% 15.44% 55.51% 65.48% -6.37% 26.59% 29.52% -12.29% -12.05% 68.93% 22.81% -36.63% -48.49% 55.30% 9.22% 0.00% SO Buy Backs
5 year Running Average $242.6 $239.3 $266.6 $331.6 $381.3 $480.3 $614.2 $700.8 $722.3 $846.6 $995.0 $997.5 $934.0 $941.1 $866.4 $738.4 250.31% <-Total Growth 10 CF 5 Yr Running
CFPS $3.04 $3.51 $5.45 $9.01 $8.40 $10.62 $13.73 $12.03 $10.58 $17.90 $21.91 $13.88 $7.61 $15.30 $19.00 $21.10 39.56% <-Total Growth 10 Cash Flow per Share
Increase -34.10% 15.44% 55.50% 65.33% -6.83% 26.41% 29.35% -12.42% -12.05% 69.22% 22.42% -36.63% -45.20% 101.09% 24.18% 11.05% 2.87% <-IRR #YR-> 10 Cash Flow 32.70%
5 year Running Average $3.64 $3.65 $4.12 $5.12 $5.88 $7.40 $9.44 $10.76 $11.07 $12.97 $15.23 $15.26 $14.38 $15.32 $15.54 $15.38 -9.84% <-IRR #YR-> 5 Cash Flow -40.44%
P/CF on Med Price 6.04 5.16 3.45 3.71 6.78 7.18 4.25 5.64 5.66 2.51 2.18 5.54 8.40 4.52 0.00 0.00 3.39% <-IRR #YR-> 10 Cash Flow per Share 39.56%
P/CF on Closing Price 6.70 3.99 4.26 4.90 8.45 7.04 4.20 6.09 4.28 2.74 3.08 5.40 8.06 4.24 3.41 3.07 -8.75% <-IRR #YR-> 5 Cash Flow per Share -36.73%
-38.98% Diff M/C
$973.7 <-12 mths 12.53% 13.31% <-IRR #YR-> 10 CFPS 5 yr Running 248.87%
Excl.Working Capital CF $22.6 $83.6 -$12.1 -$109.4 $38.7 $35.9 $2.0 $100.0 $313.9 -$270.3 -$662.5 -$46.4 $397.1 $0.0 $0.0 $0.0 5.97% <-IRR #YR-> 5 CFPS 5 yr Running 33.65%
CF fr Op $M WC $219.1 $310.4 $340.6 $474.4 $585.2 $727.8 $898.1 $885.9 $1,005.2 $897.4 $771.6 $862.4 $865.3 $727.0 $794.0 $794.0 154.03% <-Total Growth 10 Cash Flow less WC
Increase 28.46% 41.69% 9.72% 39.27% 23.36% 24.37% 23.40% -1.36% 13.46% -10.72% -14.02% 11.77% 0.34% -15.98% 9.22% 0.00% 9.77% <-IRR #YR-> 10 Cash Flow less WC 154.03%
5 year Running Average $241.5 $251.1 $261.8 $303.0 $385.9 $487.7 $605.2 $714.3 $820.4 $882.9 $891.6 $884.5 $880.4 $824.7 $804.1 $808.5 -0.47% <-IRR #YR-> 5 Cash Flow less WC -2.33%
CFPS Excl. WC $3.39 $4.80 $5.26 $7.32 $8.99 $11.17 $13.76 $13.56 $15.38 $13.76 $11.79 $13.18 $14.06 $11.82 $12.90 $12.90 12.89% <-IRR #YR-> 10 CF less WC 5 Yr Run 236.27%
Increase 28.46% 41.69% 9.71% 39.15% 22.76% 24.19% 23.24% -1.50% 13.46% -10.56% -14.30% 11.77% 6.73% -15.98% 9.22% 0.00% 4.27% <-IRR #YR-> 5 CF less WC 5 Yr Run 23.25%
5 year Running Average $3.61 $3.82 $4.05 $4.68 $5.95 $7.51 $9.30 $10.96 $12.57 $13.52 $13.65 $13.53 $13.63 $12.92 $12.75 $12.97 10.33% <-IRR #YR-> 10 CFPS - Less WC 167.15%
P/CF on Med Price 5.42 3.77 3.57 4.57 6.33 6.83 4.24 5.01 3.89 3.27 4.05 5.84 4.55 5.85 0.00 0.00 0.74% <-IRR #YR-> 5 CFPS - Less WC 3.75%
P/CF on Closing Price 6.01 2.92 4.41 6.03 7.89 6.69 4.19 5.40 2.95 3.57 5.72 5.69 4.36 5.49 5.03 5.03 12.92% <-IRR #YR-> 10 CFPS 5 yr Running 236.92%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 5.59 5 yr  5.54 P/CF Med 10 yr 4.56 5 yr  4.05 20.48% Diff M/C 4.46% <-IRR #YR-> 5 CFPS 5 yr Running 24.38%
-64.7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 61.5 Shares
-65.4 0.0 0.0 0.0 0.0 61.5 Shares
-$352.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $468.1 Cash Flow
-$785.9 $0.0 $0.0 $0.0 $0.0 $468.1 Cash Flow
-$5.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.61 Cash Flow per Share
-$12.03 $0.00 $0.00 $0.00 $0.00 $7.61 Cash Flow per Share
-$4.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.38 CFPS 5 yr Running
-$10.76 $0.00 $0.00 $0.00 $0.00 $14.38 CFPS 5 yr Running
-$340.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $865.3 Cash Flow less WC
-$885.9 $0.0 $0.0 $0.0 $0.0 $865.3 Cash Flow less WC
-$261.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $880.4 CF less WC 5 Yr Run
-$714.3 $0.0 $0.0 $0.0 $0.0 $880.4 CF less WC 5 Yr Run
-$5.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.06 CFPS - Less WC
-$13.56 $0.00 $0.00 $0.00 $0.00 $14.06 CFPS - Less WC
-$4.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.63 CFPS 5 yr Running
-$10.96 $0.00 $0.00 $0.00 $0.00 $13.63 CFPS 5 yr Running
Accts and other receivables -$153.58 -$91.56 $18.76 $1.65 -$15.68 $30.04 -$91.386 -$184.216 -$14.267 $255.909 $95.427 $24.815 -$215.353
Inventories -$36.01 -$88.26 -$37.46 $60.03 -$59.27 -$9.72 -$81.304 -$89.878 -$236.810 $192.148 $139.514 -$227.446 -$351.132
Current assets -$1.44 $0.07 -$1.33 $1.00 -$2.12 -$1.02 -$2.761 -$8.191 -$2.507 -$10.386 $6.490 -$6.853 -$4.777
Long Term Rec -$82.292 -$26.078 $130.237 $110.758 $19.230
Income Taxes $25.06 -$24.87 $23.44 $12.64 $0.28 $8.58 $11.315 -$43.383 $15.478 -$44.206 $89.050 -$19.360 -$82.870
Accounts Paybable and Accrued Lia $143.36 $121.01 $8.73 $34.04 $38.12 -$63.83 $156.753 $225.463 $12.734 -$105.652 $203.964 $166.240 $239.287
Provisions $5.345 $0.237 -$6.253 $8.525 -$2.196 -$1.769 -$1.531
                   
Sum -$22.61 -$83.61 $12.14 $109.36 -$38.66 -$35.94 -$2.038 -$99.968 -$313.917 $270.260 $662.486 $46.385 -$397.146
Google-->Morningstar -$15.05 $109.36 -$38.66 -$35.94 -$2.04 -$100 -$314 $270 $662 $46 -$397
Differnce $0.00 $0.00 $0.00 $0.00 $0 $0 $0 $0 $0 $0
in 2017 says including provisions $111.11 -$37.95 -$40.24
>Morningstar - TD same but 2017 $111 -$38 -$40 -$2 -$252
Differnce -$2 -$1 $4 $0
OPM 8.81% 7.93% 10.95% 16.24% 13.10% 13.40% 14.92% 12.01% 9.07% 15.74% 24.66% 13.90% 5.91% 7.63% -46.00% <-Total Growth 10 OPM
Increase -50.45% -10.06% 38.11% 48.28% -19.30% 2.29% 11.33% -19.54% -24.44% 73.57% 56.63% -43.62% -57.47% 29.12% Should increase  or be stable.
Diff from Ave -33.5% -40.2% -17.4% 22.5% -1.1% 1.1% 12.6% -9.4% -31.6% 18.8% 86.1% 4.9% -55.4% -42.4% 0.03 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 13.25% 5 Yrs 14.92% should be  zero, it is a   check on calculations
$1,190 <-12 mths 17.32%
Adjusted EBITDA $1,058.6 $1,176.9 $1,082.3 $919.8 $1,045.4 $1,014.0 -4.21% <-Total Growth 5 Adjusted EBITDA Normalized
Change 11.18% -8.04% -15.01% 13.66% -3.00% $0.0 <-Median-> 5 Change
Margin 16.17% 15.44% 14.59% 15.82% 15.99% 12.81% 15.63% <-Median-> 6 Margin
Long Term Debt $654.8 $717.7 $487.2 $434.5 $537.4 $1,228.0 $1,288.8 $2,462.8 $1,865.9 $725.9 $770.9 $1,281.6 $558.6 78.57% <-Total Growth 10 Debt Type
Change 9.61% -32.11% -10.83% 23.68% 128.51% 4.95% 91.09% -24.23% -61.10% 6.21% 66.24% -56.41% 5.58% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.72 0.48 0.17 0.09 0.11 0.33 0.27 0.83 0.58 0.16 0.16 0.34 0.14 0.22 <-Median-> 10 % of Market C. Intang/GW
Assets/Current Liabilities Ratio 3.70 4.22 3.70 3.84 4.10 4.13 4.51 5.14 5.54 3.44 4.23 3.98 3.07 4.12 <-Median-> 10 Assets/Current Liab Ratio Liquidity
Debt to Cash Flow (Years) 2.74 2.69 1.47 1.14 1.12 2.00 1.84 3.41 2.20 0.73 0.77 1.37 0.59 1.42 <-Median-> 10 Debt to Cash Flow (Years) Liq. + CF
Debt Ratio
Intangibles $11.87 $13.81 $24.56 $24.1 $29.8 $279.6 $287.8 $900.6 $873.6 $864.5 $806.5 $902.9 $911.8 6437.20% <-Total Growth 10 Intangibles Leverage
Goodwill $23.35 $23.35 $28.11 $26.9 $23.6 $456.8 $485.6 $891.8 $858.5 $890.1 $853.3 $948.9 $890.2 3963.89% <-Total Growth 10 Goodwill D/E Ratio
Total $35.2 $37.2 $52.7 $51.0 $53.4 $736.4 $773.4 $1,792.4 $1,732.2 $1,754.6 $1,659.8 $1,851.8 $1,802.0 4883.15% <-Total Growth 10 Total
Change 5.51% 41.74% -3.12% 4.65% 1279.06% 5.03% 131.74% -3.36% 1.29% -5.40% 11.57% -2.69% 4.84% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.04 0.02 0.02 0.01 0.01 0.20 0.16 0.61 0.54 0.40 0.34 0.49 0.45 0.27 <-Median-> 10 % of Market C.
Current Assets $815.08 $1,014.9 $1,027.2 $1,135.1 $1,318.9 $1,741.0 $2,142.9 $2,477.2 $3,180.3 $2,530.8 $2,749.8 $2,982.2 $3,693.3 $3,447.0 Liquidity ratio of 1.5 and up, best
Current Liabilities $548.68 $599.6 $571.4 $709.6 $768.2 $926.1 $1,266.3 $1,296.0 $1,582.5 $1,367.1 $2,197.2 $1,745.1 $2,156.4 $2,618.3 1.71 <-Median-> 10 Ratio
Liquidity 1.49 1.69 1.80 1.60 1.72 1.88 1.69 1.91 2.01 1.85 1.25 1.71 1.71 1.32 1.71 <-Median-> 5 Ratio
Liq. with CF aft div 1.82 2.04 2.38 2.39 2.39 2.60 2.38 2.49 2.43 2.68 1.89 2.20 1.91 1.58 2.20 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  1.19 1.26 1.45 1.73 1.73 1.75 1.06 1.73 1.16 1.92 1.67 1.91 1.43 1.58 1.67 <-Median-> 5 Ratio
Assets $1,807.6 $2,221.2 $2,411.8 $2,629.1 $2,948.4 $3,799.9 $5,227.2 $5,851.2 $8,133.4 $7,578.8 $7,556.7 $7,390.4 $8,576.4 $8,045.4 Debt Ratio of 1.5 and up, best
Liabilities $952.3 $1,311.3 $1,311.3 $1,276.8 $1,277.8 $1,541.2 $2,636.9 $2,738.4 $4,330.3 $3,549.1 $3,203.2 $2,791.6 $3,764.7 $3,443.3 2.21 <-Median-> 10 Ratio
Debt Ratio 1.90 1.69 1.84 2.06 2.31 2.47 1.98 2.14 1.88 2.14 2.36 2.65 2.28 2.34 2.28 <-Median-> 5 Ratio
Book Value $855.26 $909.89 $1,100.5 $1,352.3 $1,670.7 $2,258.7 $2,590.3 $3,112.8 $3,803.1 $4,029.8 $4,353.5 $4,598.8 $4,811.7 $4,602.1 $4,602.1 $4,602.1 337.22% <-Total Growth 10 Book Value
NCI $0.50 $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
Net Book Value $854.76 $909.89 $1,100.5 $1,352.3 $1,670.7 $2,258.7 $2,590.3 $3,112.8 $3,803.1 $4,029.8 $4,353.5 $4,598.8 $4,811.7 $4,602.1 $4,602.1 $4,602.1 337.22% <-Total Growth 10 Book Value
Book Value per Share $13.21 $14.06 $17.01 $20.88 $25.67 $34.66 $39.69 $47.63 $58.19 $61.77 $66.52 $70.26 $78.20 $74.80 $74.80 $74.80 359.81% <-Total Growth 10 Book Value per Share
Change 10.42% 6.45% 20.94% 22.78% 22.93% 35.01% 14.53% 20.00% 22.18% 6.15% 7.69% 5.63% 11.30% -4.36% 0.00% 0.00% -38.38% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.39 1.29 1.11 1.60 2.22 2.20 1.47 1.42 1.03 0.73 0.72 1.10 0.82 0.92 1.41 P/B Ratio Historical Median
P/B Ratio (Close) 1.54 1.00 1.36 2.12 2.76 2.16 1.45 1.54 0.78 0.80 1.01 1.07 0.78 0.87 0.87 0.87 16.48% <-IRR #YR-> 10 Book Value per Share 359.81%
Change 32.30% -35.37% 37.02% 55.14% 30.61% -21.98% -32.60% 5.75% -49.35% 2.18% 27.43% 5.21% -26.50% 10.61% 10.43% <-IRR #YR-> 5 Book Value per Share 64.19%
Leverage (A/BK) 2.11 2.44 2.19 1.94 1.76 1.68 2.02 1.88 2.14 1.88 1.74 1.61 1.78 1.75 1.77 <-Median-> 10 A/BV
Debt/Equity Ratio 1.11 1.44 1.19 0.94 0.76 0.68 1.02 0.88 1.14 0.88 0.74 0.61 0.78 0.75 0.77 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.26 5 yr Med 0.82 -31.19% Diff M/C 1.88 Historical A/BV
-$17.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $78.20
-$47.63 $0.00 $0.00 $0.00 $0.00 $78.20
$676 <-12 mths 34.23%
Comprehensive Income $55.59 $73.64 $159.04 $319.89 $337.54 $610.25 $354.06 $550.22 $723.06 $277.15 $348.14 $286.81 $503.39 216.51% <-Total Growth 10 Comprehensive Income
NCI -$5.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NCI
Shareholders $61.37 $73.64 $159.04 $319.89 $337.54 $610.25 $353.66 $550.22 $723.06 $277.15 $348.14 $286.81 $503.39 216.51% <-Total Growth 10 Comprehensive Inc.
Increase 194.62% 20.00% 115.98% 101.13% 5.52% 80.79% -42.05% 55.58% 31.41% -61.67% 25.61% -17.62% 75.52% 25.61% <-Median-> 5 Comprehensive Income
5 Yr Running Average $49.49 $42.40 $59.66 $109.82 $190.30 $300.07 $356.07 $434.31 $514.94 $502.87 $450.44 $437.07 $427.71 12.21% <-IRR #YR-> 10 Comprehensive Income 216.51%
ROE 7.2% 8.1% 14.5% 23.7% 20.2% 27.0% 13.7% 17.7% 19.0% 6.9% 8.0% 6.2% 10.5% -1.76% <-IRR #YR-> 5 Comprehensive Income -8.51%
5Yr Median 7.9% 7.9% 7.9% 8.1% 14.5% 20.2% 20.2% 20.2% 19.0% 17.7% 13.7% 8.0% 8.0% 21.77% <-IRR #YR-> 10 5 Yr Running Average 616.89%
% Difference from Net Income -30.6% -27.4% 8.9% 39.2% 5.3% 39.7% -32.3% 0.2% 22.2% -35.6% 24.7% -31.8% 18.1% -0.31% <-IRR #YR-> 5 5 Yr Running Average -1.52%
Median Values Diff 5, 10 yr 11.7% 18.1% 8.0% <-Median-> 5 Return on Equity
-$159.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $503.4
-$550.2 $0.0 $0.0 $0.0 $0.0 $503.4
-$59.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $427.7
-$434.3 $0.0 $0.0 $0.0 $0.0 $427.7
Current Liability Coverage Ratio 0.40 0.52 0.60 0.67 0.76 0.79 0.71 0.68 0.64 0.66 0.35 0.49 0.40 0.28   CFO / Current Liabilities
5 year Median 0.44 0.44 0.44 0.52 0.60 0.67 0.71 0.71 0.71 0.68 0.66 0.64 0.49 0.40 0.49 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 12.12% 13.98% 14.12% 18.04% 19.85% 19.15% 17.18% 15.14% 12.36% 11.84% 10.21% 11.67% 10.09% 9.04% CFO / Total Assets
5 year Median 14.57% 13.98% 13.98% 13.98% 14.12% 18.04% 18.04% 18.04% 17.18% 15.14% 12.36% 11.84% 11.67% 10.21% 11.7% <-Median-> 5 Return on Assets 
Return on Assets ROA 4.89% 4.57% 6.06% 8.74% 10.87% 11.49% 9.99% 9.39% 7.27% 5.68% 3.69% 5.69% 4.97% 6.44% Net  Income/Assets Return on Assets
5Yr Median 4.89% 4.57% 4.57% 4.89% 6.06% 8.74% 9.99% 9.99% 9.99% 9.39% 7.27% 5.69% 5.68% 5.68% 5.7% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 10.34% 11.15% 13.28% 16.99% 19.19% 19.33% 20.16% 17.65% 15.55% 10.68% 6.41% 9.14% 8.86% 11.26% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 10.34% 10.34% 10.34% 11.15% 13.28% 16.99% 19.19% 19.19% 19.19% 17.65% 15.55% 10.68% 9.14% 9.14% 9.1% <-Median-> 5 Return on Equity
$477.42 <-12 mths 12.02%
Net Income $88.91 $101.42 $146.10 $229.79 $320.56 $436.67 $522.53 $549.37 $591.48 $430.44 $279.13 $420.56 $426.19 191.71% <-Total Growth 10 Net Income
NCI $0.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NCI
Shareholders Net Income $88.38 $101.42 $146.10 $229.79 $320.56 $436.67 $522.13 $549.37 $591.48 $430.44 $279.13 $420.56 $426.19 $518 $562 $690 191.71% <-Total Growth 10 Shareholders
Increase -288.34% 14.75% 44.05% 57.28% 39.50% 36.22% 19.57% 5.22% 7.67% -27.23% -35.15% 50.67% 1.34% -6.15% -6.15% -6.15% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $64.1 $64.5 $71.9 $103.8 $177.3 $246.9 $331.0 $411.7 $484.0 $506.0 $474.5 $454.2 $429.6 $399.8 $399.8 $399.8 11.30% <-IRR #YR-> 10 Net Income 191.71%
Operating Cash Flow $196.49 $226.84 $352.76 $583.74 $546.55 $691.86 $896.07 $785.93 $691.24 $1,167.68 $1,434.09 $908.76 $468.13 -4.95% <-IRR #YR-> 5 Net Income -22.42%
Investing Cash Flow -$288.41 -$367.71 -$364.59 -$270.87 -$295.48 -$449.08 -$1,574.92 -$576.96 -$1,726.07 -$547.20 -$290.31 -$267.32 -$715.74 19.58% <-IRR #YR-> 10 5 Yr Running Average 497.73%
Total Accruals $180.30 $242.30 $157.93 -$83.08 $69.49 $193.90 $1,200.98 $340.40 $1,626.31 -$190.04 -$864.64 -$220.89 $673.81 0.85% <-IRR #YR-> 5 5 Yr Running Average 4.34%
Total Assets $1,807.6 $2,221.2 $2,411.8 $2,629.1 $2,948.4 $3,799.9 $5,227.2 $5,851.2 $8,133.4 $7,578.8 $7,556.7 $7,390.4 $8,576.4 Balance Sheet Assets
Accruals Ratio 9.97% 10.91% 6.55% -3.16% 2.36% 5.10% 22.98% 5.82% 20.00% -2.51% -11.44% -2.99% 7.86% -2.51% <-Median-> 5 Ratio
EPS/CF Ratio 0.40 0.33 0.43 0.48 0.54 0.59 0.58 0.61 0.58 0.48 0.36 0.49 0.47 0.52 <-Median-> 10 EPS/CF Ratio
-$146.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $426.2
-$549.4 $0.0 $0.0 $0.0 $0.0 $426.2
-$71.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $429.6
-$411.7 $0.0 $0.0 $0.0 $0.0 $429.6
Change in Close 46.09% -31.20% 65.71% 90.47% 60.56% 5.33% -22.80% 26.90% -38.12% 8.45% 37.23% 11.14% -18.19% 5.79% 0.00% 0.00% Count 28 Change in Close
up/down up down down down down down down up down Count 17
Meet Prediction? yes yes Yes Yes Yes % right Count 10 58.82%
Financial Cash Flow $95.08 $164.97 -$6.19 -$272.25 -$193.04 -$130.69 $789.93 -$170.97 $1,053.18 -$724.08 -$616.41 -$572.08 $156.39 C F Statement  Financial CF
Total Accruals $85.22 $77.33 $164.12 $189.17 $262.53 $324.58 $411.05 $511.37 $573.13 $534.04 -$248.23 $351.19 $517.42 Accruals
Accruals Ratio 4.71% 3.48% 6.80% 7.20% 8.90% 8.54% 7.86% 8.74% 7.05% 7.05% -3.28% 4.75% 6.03% 6.03% <-Median-> 5 Ratio
Cash $78.91 $99.13 $81.57 $129.84 $194.05 $339.08 $404.97 $439.06 $471.98 $338.23 $861.00 $928.43 $928.43 $1,375.76 Cash
Cash per Share $1.22 $1.53 $1.26 $2.00 $2.98 $5.20 $6.21 $6.72 $7.22 $5.18 $13.15 $14.19 $15.09 $22.36 $13.15 <-Median-> 5 Cash per Share
Percentage of Stock Price 5.99% 10.94% 5.43% 4.54% 4.20% 6.96% 10.76% 9.18% 15.94% 10.55% 19.51% 18.93% 24.62% 34.48% 18.93% <-Median-> 5 % of Stock Price
Notes:
September 23, 2023.  Last estimates were for 2022 and 2023 of $7830M, $8556M and $9,000M 2022/24 for Revenue, $6.73 and $8.75 for AEPS, 
$6.73 and $8.75 for EPS, $0.81, $0.80 for Dividends, $213M, and $318M for FCF, $8.74, $11.43 and $12.49 2022/4 for CFPS, $400M, $543M and $614M 2022/4 for Net Income.
September 25, 2022.  Last estimate were for 2021 and 2022 of $6792M and $7785M for Revenue, $7.45 and $8.34 for EPS, $0.64 and $0.64 for Dividends, 
$361M and $338M for FCF, $14.90 for CFPS (2021) and $332 for 2021 for Net Income.
September 20, 2021.  Last estimates were for 2020, 2021 and 2022 of $5625M, $6558M and $6990M for Revenue, $2.77, 5.05 and $5.95 for EPS, 
$0.24, $0.36 and $0.48 for Dividends, $362M, $271M for 2020 and 21 for FCF, $14.90 for 2020 for CFPS and $182M and $332M for Net Income 2020-21.
September 27, 2020.  Last estimates were for 2019 and 2020 of $7633M and $7833M for Revenue, $7.75 and $8.12 for EPS, 
$0.48 and $0.48 for Dividends, $15.60 and $14.90 for CFPS and $507M, and $533M for Net Income.
September 27, 2019.  Last estimates were for 2018, 2019 and 2020 of 7671M, $8185M and $8613M for Revenue, $9.17, $10.30 and $11.50 for EPS, 
$14.70, $16.10 and $17.30 for CFPS nd $607M, $678M and $758M for Net Income.
October 6, 2018.  Last estimates were for 2017, 2018 and 2019 of $6443M, $6949M and $7256M for Revenue, $8.32, $8.73 and $9.16 for EPS,
 $13.70, $14.70 and $15.60 for CFPS, $551M, $581M and $604M for Net Income
October 7, 2017.  Last estimates were for 2016, 2017 and 2018 of $6148M, $6576M and $6993M for Revenue, $7.66, $8.18 and $8.94 for EPS, 
$9.35 for 2016 for CFPS and $453 and $490 for Net Income for 2016 and 2017,
October 7, 2016.  Last estimates were for 2015, 2016 and 2017 of $5132M, $5665M and $5999M for Revenue, $6.51, $6.95 and $7.03 for EPS, 
$9.35 and $10.10 for CFPS for 2015 and 2016 and $420M, $453M and $490M for Net Income.
October 11, 2015.  Last estimates were for 2014, 2015 and 2016 of $4140M, $4366M and $4722M for Revenue, $4.42, $4.70 and $5.07 for EPS, 
$8.40, $9.35 and $10.10 for CFPS, $285M, $307M and $330M for Net Income.
October 5, 2014.  Last estimates were for 2013, 2014 and 2015 of $3457M, $3771M and $4086M for Revenue, $2.99, $3.23 and $3.51 for EPS, $6.40 $6.58 and $7.37 for CFPS. 
Sept 15, 2013.  Last estimates were for 2012 and 2013 of $3200M and $3700M for Revenue, $2.33 and $2.78 for EPS.
July 22, 2012.  Last I got estimates for EPS were for 2010 to 2012 at $1.35, $1.80 and $2.33 for for CF were for 2010 and 2011 of $3.77 and $4.56
Feb 7, 2011.  The last time I looked I got estiamtes for 2009 and 2010 of $-.07 and .75 for earnings and $2.54 and $3.15 for cash flow.
Nov 29, 2009.  When I last looked at this stock I got earnings of $1.33 and $1.28 for 2008 and 2009.
2000.  I started to track this stock in 2000 as it had been recommended by a number of analysts as good value.  However, it did not fit into my concept of a buy and hold stock.
Initial view: Their progress is uneven.  They are sometimes heavily loaded with debt.  The stock was worth more 10 years ago than it is today.
Incorporated in 1966 as Linamar Machine Limited
Sector:
Consumer Discretionary
What should this stock accomplish?
Would I buy this company and Why.
This is a good company, but dividend yield is generally too low.  I would consider it at times when the dividend yield pokes above 1%.
Why am I following this stock. 
I looked at this stock back in 2000 and it was not a stock I thought fit my investment philosophy.  In 2008 I read an article that recommended this company as a dividend stock with good value.  
This stock used to be on the Investment reporter portfolio stock list as an average risk stock.  However, it has now been taken off this list. 
It is on the Money Saving list of Top 100 Canadian Dividend stocks.
Dividends
Dividends are paid quarterly in cycle 3, that is April, June, September and December.  Dividends are declared in one month and payable in the following month.  
For example, the dividend declared for shareholders of record of August 26, 2013 was payable on September13, 2013.
Note first dividends is generally paid in April, not cycle 3's March.
How they make their money.
Linamar Corporation is an advanced manufacturing company. The Company is made up of two operating segments – the Industrial segment and the Mobility segment, both 
global leaders in manufacturing solutions and world-class developers of highly engineered products.
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.
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 Oct 08 2016 Oct 07 2017 Oct 06 2018 Sep 27 2019 Sep 27 2020 Sep 20 2021 Sep 25 2022 Sep 23 2023
Hasenfratz, Linda 5.93% 3.913 6.00% 3.963 6.06% 4.032 6.17% 4.336 6.65% 4.591 7.01% 4.641 7.09% 4.691 7.62% 20.308 33.01% Is Chair in 2022. 332.93%
Chair and CEO - Shares - Amount $288.590 $225.716 $290.100 $182.657 $213.035 $309.518 $347.742 $287.552 $1,316.999
Options - percentage 0.69% 0.447 0.68% 0.449 0.69% 0.447 0.68% 0.197 0.30% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $33.386 $25.773 $32.853 $20.238 $9.666 $0.000 $0.000 $0.000 $0.000
Schneider, Dale 0.00% 0.011 0.02% 0.018 0.03% 0.018 0.03% 0.019 0.03% 0.019 0.03% 0.020 0.03% 0.020 0.03% 0.021 0.03% 2.22%
CFO - Shares - Amount $0.111 $0.652 $1.297 $0.816 $0.914 $1.309 $1.499 $1.255 $1.358
Options - percentage 0.03% 0.008 0.01% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $1.495 $0.462 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Adams, John 0.00% 0.003 0.00% 0.003 0.00% 0.002 0.00%
Officer - Shares - Amount $0.224 $0.173 $0.220 $0.068
Options - percentage 0.01% 0.004 0.01% 0.000 0.00% 0.000 0.00%
Options - amount $0.598 $0.231 $0.000 $0.000
Stoddart, Mark 1.20% 0.765 1.17% 0.761 1.16% 0.732 1.12% 0.685 1.05% 0.820 1.25% 0.709 1.08% 0.610 0.99% 0.571 0.93% -6.34%
Officer - Shares - Amount $58.319 $44.144 $55.695 $33.180 $33.660 $55.256 $53.130 $37.376 $37.033
Options - percentage 0.02% 0.012 0.02% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.897 $0.692 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Reidel, Terry 0.001 0.00% 0.001 0.00% 0.00%
Director - Shares - Amount $0.046 $0.049
Options - percentage 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000
Grimm, Dennis 0.004 0.01% 0.004 0.01% 0.004 0.01% 0.00%
Director - Shares - Amount $0.313 $0.256 $0.271
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000
Forwell, Lisa 0.001 0.00% 0.001 0.00% 0.002 0.00% 0.000 0.00% -100.00%
Director - Shares - Amount $0.034 $0.082 $0.092 $0.000
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% #DIV/0!
Options - amount $0.000 $0.000 $0.000 $0.000
Hasenfratz, Frank 23.47% 15.296 23.44% 15.282 23.38% 15.282 23.38% 15.515 23.78% 15.712 24.01% 15.690 23.97% Ceased insider Jan 2022
Chairman - Shares - Amount $1,143.043 $882.406 $1,118.818 $692.289 $762.258 $1,059.294 $1,175.655
Options - percentage 0.69% 0.447 0.68% 0.000 0.00% 0.447 0.68% 0.197 0.30% 0.000 0.00% 0.000 0.00%
Options - amount $33.386 $25.773 $0.000 $20.238 $9.666 $0.000 $0.000
Increase in O/S Shares 0.49% 0.091 0.14% 0.085 0.13% 0.096 0.15% 0.000 0.00% 0.600 0.92% 0.492 0.75% 0.000 0.00% 0.050 0.08% 0% right for 2019, 2021
due to SO $22.708 $6.817 $4.904 $7.033 $0.000 $29.478 $33.162 $0.000 $3.065
Book Value $7.227 $1.908 $1.776 $2.008 $0.000 $11.382 $14.417 $0.000 $1.595
Insider Buying -$3.757 -$4.824 -$2.835 -$5.591 -$2.686 -$8.989 -$3.562 -$3.877 -$3.467
Insider Selling $19.090 $2.441 $6.020 $3.310 $7.117 $1.407 $9.978 $6.592 $2.623
Net Insider Selling $15.334 -$2.383 $3.185 -$2.281 $4.431 -$7.582 $6.416 $2.715 -$0.844
% of Market Cap 0.31% -0.06% 0.07% -0.08% 0.14% -0.17% 0.13% 0.07% -0.02%
Directors 6 6 6 6 6 6 6 6
Women 17% 1 17% 1 17% 1 17% 1 17% 2 33% 2 33% 2 33% 2 33%
Minorities 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 26.28% 142 20.53% 173 22.24% 205 22.24% 20 20 40.53% 20 41.20% 20 36.40% 20 18.41%
Total Shares Held 26.30% 13.383 20.51% 14.521 22.22% 14.700 22.49% 11.362 17.42% 26.329 40.23% 26.964 41.20% 23.145 37.62% 11.327 18.41%
Increase/Decrease -1.02% -0.059 -0.44% -0.042 -0.29% 0.248 1.72% 1.255 12.42% 0.542 2.10% 0.639 2.43% -0.931 -3.87% 2.388 26.72%
Starting No. of Shares 13.443 14.563 14.452 10.107 Top 20 25.787 Top 20 26.326 Top 20 24.076 Top 20 8.938 Top 20
Copyright © 2008 Website of SPBrunner. All rights reserved.