This report should not be construed as providing investment advice. It is for educational purposes only. Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ Q2 2016
Linamar Corporation TSX: LNR OTC: LIMAF www.linamar.com Fiscal Yr: Dec 31
Year 12/31/04 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 Value Description #Y Item
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
$5,692.1 <-12 mths 10.26%
Sales* $1,844.2 $2,161.4 $2,262.1 $2,313.6 $2,257.0 $1,675.9 $2,229.2 $2,861.4 $3,221.9 $3,595.5 $4,171.6 $5,162.5 $6,148 $6,576 $6,993 138.85% <-Total Growth 10 Revenue
Increase 22.14% 17.20% 4.66% 2.27% -2.44% -25.75% 33.01% 28.36% 12.60% 11.59% 16.02% 23.75% 19.09% 6.96% 6.34% 9.10% <-IRR #YR-> 10 Revenue
5 year Running Average $1,451.7 $1,616.4 $1,827.1 $2,018.2 $2,167.7 $2,134.0 $2,147.6 $2,267.4 $2,449.1 $2,716.8 $3,215.9 $3,802.6 $4,459.9 $5,130.7 $5,810.2 18.29% <-IRR #YR-> 5 Revenue
Revenue per Share $26.11 $29.97 $32.39 $33.13 $34.88 $25.90 $34.45 $44.23 $49.79 $55.52 $64.10 $78.01 $92.91 $99.38 $105.68 8.93% <-IRR #YR-> 10 5 yr Running Average
Increase 22.17% 14.79% 8.06% 2.29% 5.28% -25.75% 33.01% 28.36% 12.59% 11.50% 15.45% 21.71% 19.09% 6.96% 6.34% 12.11% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $20.74 $22.83 $25.82 $28.60 $31.30 $31.26 $32.15 $34.52 $37.85 $41.98 $49.62 $58.33 $68.07 $77.98 $88.01 10.04% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 0.50 0.47 0.43 0.60 0.30 0.34 0.53 0.41 0.38 0.60 0.89 0.98 17.76% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 0.59 0.39 0.43 0.61 0.11 0.54 0.59 0.32 0.47 0.80 1.11 0.96 0.60 9.84% <-IRR #YR-> 10 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 0.48 5 yr 0.60 25.05% Diff M/C 12.65% <-IRR #YR-> 5 5 yr Running Average
-$2,161.4 $0.0 $0.0 $0.0 $0.0 $0 $0 $0 $0 $0 $5,162
-$2,229 $0 $0 $0 $0 $5,162
-$1,616.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $3,802.6
-$2,147.6 $0.0 $0.0 $0.0 $0.0 $3,802.6
-$29.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $78.01
-$34.45 $0.00 $0.00 $0.00 $0.00 $78.01
-$22.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $58.33
-$32.15 $0.00 $0.00 $0.00 $0.00 $58.33
$7.38 <-12 mths 11.31%
EPS Basic $1.31 $1.41 $1.40 $1.57 $1.05 -$0.73 $1.37 $1.57 $2.26 $3.55 $4.95 $6.71 375.89% <-Total Growth 10 EPS Basic
EPS Diluted* $1.31 $1.41 $1.40 $1.57 $1.05 -$0.73 $1.36 $1.56 $2.25 $3.52 $4.90 $6.63 $7.66 $8.18 $8.94 370.21% <-Total Growth 10 EPS Diluted
Increase 129.82% 7.63% -0.71% 12.14% -33.12% -170% -286% 14.71% 44.23% 56.44% 39.20% 35.31% 15.54% 6.79% 9.29% 16.74% <-IRR #YR-> 10 Earnings per Share 370.21%
Earnings Yield 8.5% 12.0% 10.1% 7.8% 28.4% -5.2% 6.7% 11.1% 9.7% 8.0% 6.9% 8.9% 13.7% 14.6% 16.0% 37.28% <-IRR #YR-> 5 Earnings per Share 387.50%
5 year Running Average $0.88 $0.94 $1.10 $1.25 $1.35 $0.94 $0.93 $0.96 $1.10 $1.59 $2.72 $3.77 $4.99 $6.18 $7.26 14.91% <-IRR #YR-> 10 5 yr Running Average
10 year Running Average $0.93 $1.01 $1.06 $1.09 $1.07 $0.91 $0.94 $1.03 $1.18 $1.47 $1.83 $2.35 $2.98 $3.64 $4.43 32.32% <-IRR #YR-> 5 5 yr Running Average
* ESP per share (Cdn GAAP) E/P 10 Yrs 8.42% 5Yrs 8.87%
-$1.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.63
-$1.36 $0.00 $0.00 $0.00 $0.00 $6.63
-$0.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.77
-$0.93 $0.00 $0.00 $0.00 $0.00 $3.77
Comment
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 <-Median-> 10 Special Dividends
Pre-split '98
Dividend* $0.16 $0.24 $0.24 $0.24 $0.24 $0.12 $0.24 $0.32 $0.32 $0.32 $0.40 $0.40 $0.40 $0.40 $0.40 66.67% <-Total Growth 10 Dividends
Increase 0.00% 50.00% 0.00% 0.00% 0.00% -50.00% 100.00% 33.33% 0.00% 0.00% 25.00% 0.00% 0.00% 0.00% 0.00% Count 21 Years of data
Dividends 5 Yr Running $0.16 $0.18 $0.19 $0.21 $0.22 $0.22 $0.22 $0.23 $0.25 $0.26 $0.32 $0.35 $0.37 $0.38 $0.40 100.00% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.22% 1.72% 1.72% 1.20% 2.32% 1.36% 1.31% 1.77% 1.70% 0.96% 0.70% 0.52% 0.69% 1.33% <-Median-> 10 Yield H/L Price
Yield on High Price 1.04% 1.41% 1.48% 0.93% 1.40% 0.77% 1.04% 1.38% 1.38% 0.72% 0.56% 0.45% 0.54% 0.98% <-Median-> 10 Yield on High Price
Yield on Low Price 1.49% 2.19% 2.05% 1.70% 6.88% 5.71% 1.77% 2.47% 2.22% 1.41% 0.96% 0.63% 0.93% 1.91% <-Median-> 10 Yield on Low Price
Yield on Close Price 1.04% 2.04% 1.73% 1.19% 6.49% 0.86% 1.18% 2.29% 1.38% 0.72% 0.56% 0.54% 0.71% 0.71% 0.71% 1.18% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 12.21% 17.02% 17.14% 15.29% 22.86% -16.44% 17.65% 20.51% 14.22% 9.09% 8.16% 6.03% 5.22% 4.89% 4.47% 14.75% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 18.22% 18.72% 17.45% 16.61% 16.62% 22.98% 23.23% 24.12% 22.59% 16.58% 11.77% 9.33% 7.37% 6.22% 5.51% 17.04% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 6.90% 6.78% 6.89% 7.76% 6.00% 2.60% 7.90% 9.13% 5.87% 3.55% 4.76% 3.83% 4.28% #DIV/0! #DIV/0! 5.93% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 7.36% 7.34% 7.27% 7.44% 6.81% 5.77% 5.93% 6.36% 6.02% 5.15% 5.44% 4.78% 4.31% #DIV/0! #DIV/0! 5.97% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 5.40% 7.11% 6.38% 5.84% 5.79% 4.55% 7.09% 6.67% 6.08% 4.37% 4.45% 3.64% 4.28% #DIV/0! #DIV/0! 5.81% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 6.61% 6.73% 6.54% 6.27% 6.10% 5.99% 5.99% 6.08% 6.13% 5.64% 5.38% 4.71% 4.39% #DIV/0! #DIV/0! 6.04% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 0.96% 0.72% 5 Yr Med Payout 9.09% 4.76% 4.45% 5.24% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. -25.39% -1.41% Last Div Inc ---> $0.08 $0.10 25.0% 10.76% <-IRR #YR-> 5 Dividends
-$0.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.40
-$0.24 $0.00 $0.00 $0.00 $0.00 $0.40
Historical Dividends Historical High Div 5.06% Low Div 0.44% Ave Div 2.75% Med Div 1.25% Close Div 1.21% Historical Dividends
High/Ave/Median Values Curr diff Exp. -85.89% 62.25% Exp. -74.04% Exp. -42.89% Exp. -41.10% High/Ave/Median
Future Dividend Yield Div Yd 0.95% earning in 5 Years at IRR of 5.90% Div Inc. 33.19% Future Dividend Yield
Future Dividend Yield Div Yd 1.27% earning in 10 Years at IRR of 5.90% Div Inc. 77.40% Future Dividend Yield
Future Dividend Yield Div Yd 1.69% earning in 15 Years at IRR of 5.90% Div Inc. 136.29% Future Dividend Yield
Cost covered if held 5 years 3.93% 6.44% 7.49% 9.31% 10.34% 8.26% 7.72% 8.29% 6.22% 12.76% 18.13% 9.59% 10.17% 10.21% 5.98% 8.80% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 21.12% 25.95% 15.91% 8.08% 7.28% 9.23% 14.33% 16.53% 20.42% 22.52% 20.50% 20.31% 21.45% 15.86% 32.09% 16.22% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 63.31% 37.08% 43.73% 26.70% 13.60% 12.28% 17.08% 27.20% 30.88% 37.62% 40.98% 26.95% <-Median-> 8 Paid Median Price
Cost covered if held 20 years 98.28% 60.71% 72.70% 43.81% 22.15% 19.87% 72.70% <-Median-> 3 Paid Median Price
Cost covered if held 25 years 151.26% #NUM! <-Median-> 0 Paid Median Price
H/LYield held 5 yrs 0.79% 1.76% 1.87% 2.15% 2.22% 0.92% 1.72% 2.29% 1.61% 3.09% 4.53% 2.18% 2.21% 2.13% 1.20% 2.16% <-Median-> 10 Paid Median Price
H/LYield held 10 yrs 2.36% 3.95% 2.23% 1.07% 0.91% 0.59% 1.76% 2.50% 2.87% 2.95% 3.06% 2.86% 2.86% 2.01% 3.87% 2.36% <-Median-> 10 Paid Median Price
H/LYield held 15 yrs 6.36% 1.77% 3.95% 2.98% 1.42% 1.21% 1.96% 2.93% 3.12% 3.58% 3.69% 2.44% <-Median-> 8 Paid Median Price
H/LYield held 20 yrs 8.48% 5.91% 6.58% 3.72% 1.78% 1.52% 6.58% <-Median-> 3 Paid Median Price
H/LYield held 25 yrs 10.60% #NUM! <-Median-> 0 Paid Median Price
Graham No. $17.00 $18.51 $19.46 $21.23 $17.52 $19.13 $20.11 $22.22 $29.34 $40.67 $53.20 $71.36 $78.86 $81.49 $85.19 285.54% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.77 0.76 0.72 0.94 0.59 0.46 0.91 0.81 0.64 0.82 1.07 1.07 0.74 0.82 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Hi 0.91 0.92 0.84 1.21 0.98 0.81 1.15 1.04 0.79 1.09 1.35 1.24 0.94 1.07 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.63 0.59 0.60 0.66 0.20 0.11 0.67 0.58 0.49 0.56 0.79 0.89 0.54 0.59 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Cl 0.91 0.63 0.71 0.95 0.21 0.73 1.01 0.63 0.79 1.09 1.33 1.05 0.71 0.69 0.66 0.87 <-Median-> 10 Price/GP Ratio
Prem/Disc CL -9.42% -36.51% -28.58% -4.74% -78.88% -27.20% 1.21% -36.99% -20.94% 8.66% 33.37% 4.73% -28.95% -31.24% -34.23% -12.84% <-Median-> 10 Graham Price
Price Close $15.40 $11.75 $13.90 $20.22 $3.70 $13.93 $20.35 $14.00 $23.20 $44.19 $70.95 $74.73 $56.03 $56.03 $56.03 536.00% <-Total Growth 10 Stock Price
Increase 33.45% -23.70% 18.30% 45.47% -81.70% 276.49% 46.09% -31.20% 65.71% 90.47% 60.56% 5.33% -25.02% 0.00% 0.00% 20.32% <-IRR #YR-> 10 Stock Price
P/E 11.76 8.33 9.93 12.88 3.52 -19.08 14.96 8.97 10.31 12.55 14.48 11.27 7.31 6.85 6.27 29.71% <-IRR #YR-> 5 Stock Price
Trailing P/E 27.02 8.97 9.86 14.44 2.36 13.27 -27.88 10.29 14.87 19.64 20.16 15.25 8.45 7.31 6.85 21.42% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 1.10% 1.07% % Tot Ret 5.11% 3.46% Price Inc 60.56% P/E: 10.79 11.27 30.78% <-IRR #YR-> 5 Price & Dividend
-$11.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $74.73
-$20.35 $0.00 $0.00 $0.00 $0.00 $74.73
-$11.75 $0.24 $0.24 $0.24 $0.12 $0.24 $0.32 $0.32 $0.32 $0.40 $75.13
-$20.35 $0.32 $0.32 $0.32 $0.40 $75.13
Price Median H/L $13.07 $13.99 $13.99 $19.93 $10.35 $8.83 $18.36 $18.09 $18.81 $33.45 $56.91 $76.25 $58.35 445.19% <-Total Growth 10 Stock Price
Increase 20.63% 7.00% 0.00% 42.47% -48.08% -14.69% 107.99% -1.47% 4.01% 77.80% 70.15% 33.99% -23.47% 18.48% <-IRR #YR-> 10 Stock Price
P/E 9.98 9.92 9.99 12.69 9.85 -12.09 13.50 11.59 8.36 9.50 11.61 11.50 7.62 32.95% <-IRR #YR-> 5 Stock Price
Trailing P/E 22.93 10.68 9.92 14.23 6.59 8.40 -25.14 13.30 12.06 14.86 16.17 15.56 8.80 19.45% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 14.89 14.88 12.71 15.91 7.67 9.39 19.74 18.80 17.13 21.01 20.94 20.21 11.69 34.09% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 14.06 13.79 13.17 18.30 9.63 9.71 19.63 17.54 16.01 22.75 31.11 32.43 19.60 11.68 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 0.97% 1.14% % Tot Ret 4.99% 3.34% Price Inc 33.99% P/E: 10.74 11.50 Count 23 Years of data
-$13.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $76.25
-$18.36 $0.00 $0.00 $0.00 $0.00 $76.25
-$13.99 $0.24 $0.24 $0.24 $0.12 $0.24 $0.32 $0.32 $0.32 $0.40 $76.65
-$18.36 $0.32 $0.32 $0.32 $0.40 $76.65
High Months Dec Aug Apr Oct May Nov Nov Jan Dec Dec Dec Jun Jan
Price High $15.40 $17.00 $16.27 $25.75 $17.20 $15.55 $23.15 $23.20 $23.22 $44.19 $72.01 $88.73 $73.89 421.94% <-Total Growth 10 Stock Price
Increase 19.38% 10.39% -4.29% 58.27% -33.20% -9.59% 48.87% 0.22% 0.09% 90.31% 62.96% 23.22% -16.72% 17.97% <-IRR #YR-> 10 Stock Price
P/E 11.76 12.06 11.62 16.40 16.38 -21.30 17.02 14.87 10.32 12.55 14.70 13.38 9.65 30.83% <-IRR #YR-> 5 Stock Price
Trailing P/E 27.02 12.98 11.54 18.39 10.96 14.81 -31.71 17.06 14.88 19.64 20.46 18.11 11.14 15.95 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 23.22% P/E: 14.04 13.38 22.84 P/E Ratio Historical High
-$17.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $88.73
-$23.15 $0.00 $0.00 $0.00 $0.00 $88.73
Low Months Jan Dec Jan Jan Dec Mar Jan Sep Jan Apr Jan Aug Jul
Price Low $10.74 $10.97 $11.70 $14.10 $3.49 $2.10 $13.56 $12.97 $14.40 $22.70 $41.80 $63.76 $42.81 481.22% <-Total Growth 10 Stock Price
Increase 22.46% 2.14% 6.65% 20.51% -75.25% -39.83% 545.71% -4.35% 11.03% 57.64% 84.14% 52.54% -32.86% 19.24% <-IRR #YR-> 10 Stock Price
P/E 8.20 7.78 8.36 8.98 3.32 -2.88 9.97 8.31 6.40 6.45 8.53 9.62 5.59 36.29% <-IRR #YR-> 5 Stock Price
Trailing P/E 18.84 8.37 8.30 10.07 2.22 2.00 -18.58 9.54 9.23 10.09 11.88 13.01 6.46 8.98 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 52.54% P/E: 8.34 8.31 7.15 P/E Ratio Historical Low
-$10.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $63.76
Long Term Debt $437.1 $548.2 $1,737.1 Debt
Ratio to Market Cap 0.09 0.11 0.47 0.10 <-Median-> 2 % of Market C.
Goodwill & Intangibles $35.22 $52.67 $51.0 $53.4 $673.5 Intangibles Goodwill
Ratio to Market Cap 0.02 0.02 0.01 0.01 0.18 0.01 <-Median-> 4 % of Market C.
Market Cap $1,088 $847 $971 $1,412 $239 $901 $1,317 $906 $1,501 $2,862 $4,618 $4,945 $3,708 $3,708 $3,708 483.65% <-Total Growth 10 Market Cap
Diluted 70.88 70.80 71.34 69.83 66.81 64.70 64.85 64.82 64.90 65.21 65.42 65.84 -7.00% <-Total Growth 10 Diluted
Change 0.40% -0.12% 0.76% -2.11% -4.32% -3.15% 0.23% -0.04% 0.13% 0.47% 0.33% 0.65% 0.18% <-Median-> 10 Change
Diluted calc 64.28 64.99 65.42 65.86 Diluted calc
Ave Cal NI/EPS 72.91 70.95 71.10 69.64 67.00 64.28 64.51 64.60 64.65 Ave Cal NI/EPS
Average # of Shares in Million 70.61 70.80 71.34 69.83 66.81 64.70 64.70 64.70 64.70 64.72 64.82 65.11 -8.03% <-Total Growth 10 Average
Change 0.00% 0.27% 0.76% -2.11% -4.32% -3.15% 0.00% 0.00% 0.00% 0.03% 0.15% 0.44% 0.00% <-Median-> 10 Change
Difference 0.0% 1.9% -2.1% 0.0% -3.2% 0.0% 0.0% 0.0% 0.0% 0.1% 0.4% 1.6% 0.00% <-Median-> 10 Difference
$778.46 <-12 mths 12.52%
# of Share in Millions 70.63 72.11 69.84 69.82 64.70 64.70 64.70 64.70 64.71 64.76 65.08 66.17 66.17 66.17 66.17 -0.86% <-IRR #YR-> 10 Shares
Change -0.02% 2.10% -3.15% -0.02% -7.34% 0.00% 0.00% 0.00% 0.01% 0.09% 0.49% 1.68% 0.00% 0.00% 0.00% 0.45% <-IRR #YR-> 5 Shares
CF fr Op $M $163.9 $255.4 $243.2 $216.1 $258.9 $298.2 $196.5 $226.8 $352.8 $583.7 $546.5 $691.9 $618.7 170.88% <-Total Growth 10 Cash Flow
Increase 50.51% 55.86% -4.77% -11.17% 19.80% 15.18% -34.10% 15.44% 55.51% 65.48% -6.37% 26.59% -10.57% SO Buy Backs
5 year Running Average $151.9 $169.7 $186.9 $197.5 $227.5 $254.3 $242.6 $239.3 $266.6 $331.6 $381.3 $480.3 $558.7 183.02% <-Total Growth 10 CF 5 Yr Running
CFPS $2.32 $3.54 $3.48 $3.09 $4.00 $4.61 $3.04 $3.51 $5.45 $9.01 $8.40 $10.46 $9.35 195.17% <-Total Growth 10 Cash Flow per Share
Increase 50.55% 52.66% -1.67% -11.15% 29.29% 15.18% -34.10% 15.44% 55.50% 65.33% -6.83% 24.50% -10.57% 10.48% <-IRR #YR-> 10 Cash Flow
5 year Running Average $2.17 $2.40 $2.64 $2.80 $3.29 $3.75 $3.64 $3.65 $4.12 $5.12 $5.88 $7.36 $8.53 28.63% <-IRR #YR-> 5 Cash Flow
P/CF on Med Price 5.63 3.95 4.02 6.44 2.59 1.92 6.04 5.16 3.45 3.71 6.78 7.29 6.24 11.43% <-IRR #YR-> 10 Cash Flow per Share
P/CF on Closing Price 6.64 3.32 3.99 6.53 0.92 3.02 6.70 3.99 4.26 4.90 8.45 7.15 5.99 28.05% <-IRR #YR-> 5 Cash Flow per Share
30.64% Diff M/C 11.88% <-IRR #YR-> 10 CFPS 5 yr Running
Excl.Working Capital CF $45.4 -$12.1 $19.4 $70.9 $9.5 -$127.6 $22.6 $83.6 -$12.1 -$109.4 $38.7 $35.9 $0.0 15.11% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $209.3 $243.3 $262.6 $287.0 $268.3 $170.6 $219.1 $310.4 $340.6 $474.4 $585.2 $727.8 $618.7 199.09% <-Total Growth 10 Cash Flow less WC
Increase 24.58% 16.27% 7.91% 9.29% -6.51% -36.43% 28.46% 41.69% 9.72% 39.27% 23.36% 24.37% -14.99% 11.58% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $169.3 $185.1 $207.7 $234.0 $254.1 $246.4 $241.5 $251.1 $261.8 $303.0 $385.9 $487.7 $549.3 27.14% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $2.96 $3.37 $3.76 $4.11 $4.15 $2.64 $3.39 $4.80 $5.26 $7.32 $8.99 $11.00 $9.35 10.17% <-IRR #YR-> 10 CF less WC 5 Yr Run
Increase 24.60% 13.88% 11.42% 9.31% 0.89% -36.43% 28.46% 41.69% 9.71% 39.15% 22.76% 22.31% -14.99% 15.09% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $2.42 $2.62 $2.93 $3.32 $3.67 $3.61 $3.61 $3.82 $4.05 $4.68 $5.95 $7.48 $8.39 12.54% <-IRR #YR-> 10 CFPS - Less WC
P/CF on Med Price 4.41 4.14 3.72 4.85 2.49 3.35 5.42 3.77 3.57 4.57 6.33 6.93 26.57% <-IRR #YR-> 5 CFPS - Less WC
P/CF on Closing Price 5.20 3.48 3.70 4.92 0.89 5.28 6.01 2.92 4.41 6.03 7.89 6.79 5.99 11.07% <-IRR #YR-> 10 CFPS 5 yr Running
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 4.59 5 yr 5.16 P/CF Med 10 yr 4.17 5 yr 4.57 43.79% Diff M/C 15.69% <-IRR #YR-> 5 CFPS 5 yr Running
-$3.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.46 Cash Flow per Share
-$3.04 $0.00 $0.00 $0.00 $0.00 $10.46 Cash Flow per Share
-$2.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.36 CFPS 5 yr Running
-$3.64 $0.00 $0.00 $0.00 $0.00 $7.36 CFPS 5 yr Running
-$243.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $727.8 Cash Flow less WC
-$219.1 $0.0 $0.0 $0.0 $0.0 $727.8 Cash Flow less WC
-$185.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $487.7 CF less WC 5 Yr Run
-$241.5 $0.0 $0.0 $0.0 $0.0 $487.7 CF less WC 5 Yr Run
-$3.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.00 CFPS - Less WC
-$3.39 $0.00 $0.00 $0.00 $0.00 $11.00 CFPS - Less WC
-$2.62 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.48 CFPS 5 yr Running
-$3.61 $0.00 $0.00 $0.00 $0.00 $7.48 CFPS 5 yr Running
OPM 8.89% 11.82% 10.75% 9.34% 11.47% 17.79% 8.81% 7.93% 10.95% 16.24% 13.10% 13.40% 10.06% 13.41% <-Total Growth 10 OPM
Increase 23.23% 32.99% -9.01% -13.14% 22.80% 55.12% -50.45% -10.06% 38.11% 48.28% -19.30% 2.29% -24.91% Should increase or be stable.
Diff from Ave -20.7% 5.4% -4.1% -16.7% 2.3% 58.7% -21.4% -29.3% -2.3% 44.8% 16.9% 19.6% -10.2% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 11.21% 5 Yrs 13.10% should be zero, it is a check on calculations
Current Assets $599.19 $631.51 $253.27 $809.99 $805.25 $688.94 $815.08 $1,014.9 $1,027.2 $1,135.1 $1,318.9 $1,741.0 $2,298.9 Liquidity ratio of 1.5 and up, best
Current Liabilities $390.77 $504.99 $404.14 $502.90 $610.52 $455.41 $548.68 $599.6 $571.4 $709.6 $768.2 $926.1 $1,145.3 1.61 <-Median-> 10 Ratio
Liquidity 1.53 1.25 0.63 1.61 1.32 1.51 1.49 1.69 1.80 1.60 1.72 1.88 2.01 1.72 <-Median-> 5 Ratio
Liq. with CF aft div 1.92 1.72 1.19 2.01 1.72 2.15 1.82 2.04 2.38 2.39 2.39 2.60 2.52 2.39 <-Median-> 5 Ratio
Liq. CF re Inv+Div 1.25 1.23 0.82 1.27 1.66 1.67 1.19 1.26 1.45 1.73 1.73 1.75 2.52 1.73 <-Median-> 5 Ratio
Assets $1,448.9 $1,541.5 $1,616.1 $1,813.8 $1,841.6 $1,572.4 $1,807.6 $2,221.2 $2,411.8 $2,629.1 $2,948.4 $3,799.9 $5,401.8 Debt Ratio of 1.5 and up, best
Liabilities $756.3 $762.9 $776.4 $923.3 $963.2 $764.8 $952.3 $1,311.3 $1,311.3 $1,276.8 $1,277.8 $1,541.2 $3,014.3 2.01 <-Median-> 10 Ratio
Debt Ratio 1.92 2.02 2.08 1.96 1.91 2.06 1.90 1.69 1.84 2.06 2.31 2.47 1.79 2.06 <-Median-> 5 Ratio
Book Value $692.60 $778.59 $839.74 $890.56 $878.40 $807.61 $855.26 $909.89 $1,100.5 $1,352.3 $1,670.7 $2,258.7 $2,387.5 $2,387.5 $2,387.5 190.10% <-Total Growth 10 Book Value
NCI $0.00 $0.00 $0.00 $0.00 $37.92 $33.50 $0.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Net Book Value $692.60 $778.59 $839.74 $890.56 $840.48 $774.11 $854.76 $909.89 $1,100.5 $1,352.3 $1,670.7 $2,258.7 $2,387.5 $2,387.5 $2,387.5 190.10% <-Total Growth 10 Book Value
Book Value per Share $9.81 $10.80 $12.02 $12.75 $12.99 $11.96 $13.21 $14.06 $17.01 $20.88 $25.67 $34.13 $36.08 $36.08 $36.08 216.11% <-Total Growth 10 Book Value per Share
Change 10.47% 10.11% 11.36% 6.07% 1.85% -7.90% 10.42% 6.45% 20.94% 22.78% 22.93% 32.97% 5.70% 0.00% 0.00% 16.09% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.33 1.30 1.16 1.56 0.80 0.74 1.39 1.29 1.11 1.60 2.22 2.23 1.62 1.59 P/B Ratio Historical Median
P/B Ratio (Close) 1.57 1.09 1.16 1.59 0.28 1.16 1.54 1.00 1.36 2.12 2.76 2.19 1.55 1.55 1.55 12.20% <-IRR #YR-> 10 Book Value per Share
Change 20.80% -30.70% 6.23% 37.14% -82.03% 308.76% 32.30% -35.37% 37.02% 55.14% 30.61% -20.79% -29.07% 20.91% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 2.09 1.98 1.92 2.04 2.10 1.95 2.11 2.44 2.19 1.94 1.76 1.68 2.26 2.07 <-Median-> 10 A/BV
Debt/Equity Ratio 1.09 0.98 0.92 1.04 1.10 0.95 1.11 1.44 1.19 0.94 0.76 0.68 1.26 1.07 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.34 5 yr Med 1.60 16.09% Diff M/C 1.92 Historical A/BV
-$10.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.13
-$13.21 $0.00 $0.00 $0.00 $0.00 $34.13
$462 <-12 mths -24.29%
Comprehensive Inc -$69.28 $55.59
NCI -$4.42 -$5.78
Shareholders Comprehensive Income $109.07 $72.76 $69.12 -$64.86 $61.37 $73.64 $159.04 $319.89 $337.54 $610.25 459.51% <-Total Growth 9 Comprehensive Inc.
ROE 13.0% 8.2% 7.9% -8.0% 7.2% 8.1% 14.5% 23.7% 20.2% 27.0% 20.2% <-Median-> 5 Comprehensive Inc.
5Yr Median 7.9% 7.9% 7.9% 8.1% 14.5% 20.2% 21.08% <-IRR #YR-> 9 Comprehensive Inc.
% Difference from NI 9.6% -33.5% -6.0% 32.5% -30.6% -27.4% 8.9% 39.2% 5.3% 39.7% 58.31% <-IRR #YR-> 5 Comprehensive Inc.
Median Values Diff 5, 10 yr 7.1% 8.9%
-$109.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $610.2
-$61.4 $0.0 $0.0 $0.0 $0.0 $610.2
Current Liability Coverage Ratio 0.54 0.48 0.65 0.57 0.44 0.37 0.40 0.52 0.60 0.67 0.76 0.79 0.54 CFO / Current Liabilities
5 year Median 0.54 0.54 0.54 0.54 0.54 0.48 0.44 0.44 0.44 0.52 0.60 0.67 0.67 0.67 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 14.44% 15.79% 16.25% 15.82% 14.57% 10.85% 12.12% 13.98% 14.12% 18.04% 19.85% 19.15% 11.45% CFO / Total Assets
5 year Median 14.63% 14.63% 14.63% 15.79% 15.79% 15.79% 14.57% 13.98% 13.98% 13.98% 14.12% 18.04% 18.04% 18.0% <-Median-> 5 Return on Assets
Return on Assets ROA 6.6% 6.5% 6.2% 6.0% 3.8% -3.0% 4.9% 4.6% 6.1% 8.7% 10.9% 11.5% 8.4% Net Income/Assets Return on Assets
5Yr Median 5.4% 5.4% 6.2% 6.2% 6.2% 6.0% 4.9% 4.6% 4.6% 4.9% 6.1% 8.7% 8.7% 8.7% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 13.8% 12.8% 11.9% 12.3% 8.4% -6.1% 10.3% 11.1% 13.3% 17.0% 19.2% 19.3% 19.0% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 9.2% 9.2% 11.9% 12.3% 12.3% 11.9% 10.3% 10.3% 10.3% 11.1% 13.3% 17.0% 19.0% 17.0% <-Median-> 5 Return on Equity
$486.66 <-12 mths 11.45%
Net Income -$46.24 $88.91 Net Income
NCI $0.69 $0.53 NCI
Shareholders Net Income $95.51 $100.04 $99.53 $109.33 $70.35 -$46.93 $88.38 $101.42 $146.10 $229.79 $320.56 $436.67 $453 $490 336.49% <-Total Growth 10 Shareholders
Increase 133.29% 4.74% -0.51% 9.84% -35.65% -167% -288.34% 14.75% 44.05% 57.28% 39.50% 36.22% 3.74% 8.17% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $62.5 $67.1 $78.6 $89.1 $95.0 $66.5 $64.1 $64.5 $71.9 $103.8 $177.3 $246.9 $317.2 $386.0 15.88% <-IRR #YR-> 10 Net Income
Operating Cash Flow $163.87 $255.41 $243.24 $216.07 $258.86 $298.15 $196.49 $226.84 $352.76 $583.74 $546.55 $691.86 37.64% <-IRR #YR-> 5 Net Income
Investing Cash Flow -$208.50 -$199.34 -$182.90 -$288.74 -$22.21 -$130.61 -$288.41 -$367.71 -$364.59 -$270.87 -$295.48 -$449.08 13.92% <-IRR #YR-> 10 5 Yr Running Average
Total Accruals $140.15 $43.96 $39.20 $182.00 -$166.29 -$214.47 $180.30 $242.30 $157.93 -$83.08 $69.49 $193.90 30.95% <-IRR #YR-> 5 5 Yr Running Average
Total Assets $1,448.9 $1,541.5 $1,616.1 $1,813.8 $1,841.6 $1,572.4 $1,807.6 $2,221.2 $2,411.8 $2,629.1 $2,948.4 $3,799.9 Balance Sheet Assets
Accruals Ratio 9.67% 2.85% 2.43% 10.03% -9.03% -13.64% 9.97% 10.91% 6.55% -3.16% 2.36% 5.10% 5.10% <-Median-> 5 Ratio
EPS/CF Ratio 0.44 0.42 0.37 0.38 0.25 -0.28 0.40 0.33 0.43 0.48 0.54 0.60 0.39 <-Median-> 10 EPS/CF Ratio
-$100.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $436.7
-$88.4 $0.0 $0.0 $0.0 $0.0 $436.7
-$67.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $246.9
-$64.1 $0.0 $0.0 $0.0 $0.0 $246.9
Change in Close 33.45% -23.70% 18.30% 45.47% -81.70% 276.49% 46.09% -31.20% 65.71% 90.47% 60.56% 5.33% -25.02% 0.00% 0.00% Count 21 Change in Close
up/down down down down up up down down down Count 12
Meet Prediction? yes yes yes yes yes % right Count 7 58.33%
Financial Cash Flow $27.91 -$39.33 -$51.20 $140.26 -$90.38 -$165.96 $95.08 $164.97 -$6.19 -$272.25 -$193.04 -$130.69 C F Statement Financial CF
Total Accruals $112.24 $83.29 $90.40 $41.74 -$75.91 -$48.51 $85.22 $77.33 $164.12 $189.17 $262.53 $324.58 Accruals
Accruals Ratio 7.75% 5.40% 5.59% 2.30% -4.12% -3.09% 4.71% 3.48% 6.80% 7.20% 8.90% 8.54% 7.20% <-Median-> 5 Ratio
Cash $28.01 $38.29 $103.75 $83.50 $81.30 $78.91 $99.13 $81.57 $129.84 $194.05 $339.08 $414.74 Cash
Cash per Share $0.39 $0.55 $1.49 $1.29 $1.26 $1.22 $1.53 $1.26 $2.00 $2.98 $5.12 $6.27 $2.00 <-Median-> 5 Cash per Share
Percentage of Stock Price 3.31% 3.94% 7.35% 34.88% 9.02% 5.99% 10.94% 5.43% 4.54% 4.20% 6.86% 11.19% 5.43% <-Median-> 5 % of Stock Price
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.
Would I buy this company and Why.
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.
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.
How they make their money.
Linamar Corporation is a diversified global manufacturing company of highly engineered products. It is a world-class designer and diversified manufacturer of precision metallic components and systems
for the automotive industry, and mobile industrial markets.
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 Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Jul 31 2012 Sep 15 2013 Oct 05 2014 Oct 11 2015 Oct 08 2016
Hasenfratz, Linda 3.813 5.89% 3.828 5.88% 3.862 5.84% 3.913 5.91%
CEO - Shares - Amount $168.516 $271.628 $288.590 $219.222
Options - percentage 0.447 0.69% 0.447 0.69% 0.447 0.68% 0.447 0.68%
Options - amount $19.742 $31.697 $33.386 $25.031
Schneider, Dale 0.001 0.00% 0.001 0.00% 0.001 0.00% 11.308 17.09%
CFO - Shares - Amount $0.025 $0.081 $0.111 $633.587
Options - percentage 0.020 0.03% 0.020 0.03% 0.020 0.03% 0.008 0.01%
Options - amount $0.884 $1.419 $1.495 $0.448
Adams, John 0.002 0.00% 0.006 0.01% 0.003 0.00% 0.003 0.00%
Officer - Shares - Amount $0.088 $0.426 $0.224 $0.168
Options - percentage 0.023 0.04% 0.012 0.02% 0.008 0.01% 0.004 0.01%
Options - amount $1.016 $0.851 $0.598 $0.224
Havasi, Csaba 0.155 0.24% 0.155 0.24%
Officer - Shares - Amount $6.863 $11.019
Options - percentage 0.013 0.02% 0.013 0.02%
Options - amount $0.574 $0.922
Stoddart, Mark 0.785 1.21% 0.792 1.22% 0.780 1.18% 0.765 1.16%
Director - Shares - Amount $34.695 $56.220 $58.319 $42.874
Options - percentage 0.020 0.03% 0.012 0.02% 0.012 0.02% 0.012 0.02%
Options - amount $0.884 $0.851 $0.897 $0.672
Buehlow, David 0.007 0.01% no longer insider
Director - Shares - Amount $0.309
Options - percentage 0.000 0.00%
Options - amount $0.000
Harrison, William 0.045 0.07% 0.045 0.07% 0.045 0.07%
Director - Shares - Amount $3.204 $3.375 $2.530
Options - percentage 0.015 0.02% 0.015 0.02% 0.015 0.02%
Options - amount $1.064 $1.121 $0.840
Hasenfratz, Frank 15.273 23.58% 15.288 23.49% 15.296 23.11% 15.296 23.11%
Chairman - Shares - Amount $674.918 $1,084.691 $1,143.043 $857.015
Options - percentage 0.447 0.69% 0.447 0.69% 0.447 0.68% 0.447 0.68%
Options - amount $19.742 $31.697 $33.386 $25.031
Increase in O/S Shares 0.004 0.01% 0.056 0.09% 0.320 0.49% 0.091 0.14%
due to SO $0.103 $2.468 $22.708 $6.817
Book Value $0.092 $1.167 $7.227 $1.908
Insider Buying -$3.757 -$4.824
Insider Selling $19.090 $2.441
Net Insider Selling -$0.667 $15.334 -$2.383
% of Market Cap -0.01% 0.31% -0.06%
Directors 6 6 6 6
Women 1 17% 1 17% 1 17% 1 17%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 47 20.34% 88 35.76% 78 20.88% 109 26.28% 142 20.53%
Total Shares Held 13.158 20.34% 23.145 35.74% 13.530 20.79% 17.115 26.30% 13.383 20.22%
Increase/Decrease -0.431 -3.17% 0.872 3.91% -0.088 -0.65% -0.177 -1.02% -0.059 -0.44%
Starting No. of Shares 13.590 22.273 13.619 17.292 13.443
Copyright 2008 Website of SPBrunner. All rights reserved.