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/ 9/30/16
Finning International Inc. TSX: FTT OTC: FINGF www.finning.com Fiscal Yr: Dec 31 Q3 2016
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 Accounting Rules
Split 2 Split
$5,655 <-12 mths -8.65%
Revenue* $4,162 $4,835 $4,853 $5,662 $5,991 $4,738 $4,641 $5,895 $6,622 $6,756 $6,918 $6,190 $5,524 $5,593 $5,971 28.04% <-Total Growth 10 Revenue
Increase 15.82% 16.16% 0.39% 16.67% 5.81% -20.93% -2.03% 27.01% 12.34% 2.02% 2.40% -10.52% -10.76% 1.25% 6.76% 2.50% <-IRR #YR-> 10 Revenue
5 year Running Average $3,334 $3,809 $4,130 $4,621 $5,101 $5,216 $5,177 $5,385 $5,577 $5,730 $6,166 $6,476 $6,402 $6,196 $6,039 5.93% <-IRR #YR-> 5 Revenue
Revenue per Share $23.54 $27.10 $27.10 $32.15 $35.15 $27.75 $27.07 $34.36 $38.52 $39.28 $40.13 $36.84 $32.85 $33.27 $35.51 5.45% <-IRR #YR-> 10 5 yr Running Average
Increase 1.89% 15.11% 0.00% 18.63% 9.34% -21.07% -2.42% 26.90% 12.12% 1.96% 2.18% -8.21% -10.81% 1.25% 6.76% 4.58% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $20.99 $23.17 $24.30 $26.60 $29.01 $29.85 $29.84 $31.30 $32.57 $33.39 $35.87 $37.83 $37.52 $36.47 $35.72 3.12% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 0.68 0.68 0.77 0.88 0.62 0.52 0.82 0.71 0.67 0.61 0.71 0.59 6.35% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 0.74 0.69 0.88 0.89 0.41 0.60 1.00 0.65 0.64 0.69 0.63 0.51 0.81 0.80 0.75 5.02% <-IRR #YR-> 10 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 0.69 5 yr 0.67 17.64% Diff M/C 4.85% <-IRR #YR-> 5 5 yr Running Average
-$4,835 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,190
-$4,641 $0 $0 $0 $0 $6,190
-$3,809 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,476
-$5,177 $0 $0 $0 $0 $6,476
-$27.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36.84
-$27.07 $0.00 $0.00 $0.00 $0.00 $36.84
-$23.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $37.83
-$29.84 $0.00 $0.00 $0.00 $0.00 $37.83
-$2.13 <-12 mths 126.60%
Pre Split '07
EPS Basic $0.72 $0.92 $1.14 $1.56 $0.56 $0.77 -$0.46 $1.51 $1.96 $1.95 $1.85 -$0.94 -202.17% <-Total Growth 10 Earnings
EPS Diluted* $0.72 $0.92 $1.13 $1.53 $0.55 $0.77 -$0.46 $1.51 $1.96 $1.94 $1.84 -$0.94 $0.68 $1.25 $1.60 -202.73% <-Total Growth 10 Earnings
Increase -14.88% 27.97% 23.50% 35.40% -64.05% 40.00% -159.74% 428.26% 29.80% -1.02% -5.15% -151.09% 172.34% 83.82% 28.00% #NUM! <-IRR #YR-> 10 Earnings per Share -202.73%
Earnings Yield 4.1% 4.9% 4.7% 5.3% 3.9% 4.6% -1.7% 6.8% 8.0% 7.1% 7.3% -5.0% 2.5% 4.7% 6.0% 15.36% <-IRR #YR-> 5 Earnings per Share -104.35%
5 year Running Average $0.71 $0.80 $0.89 $1.03 $0.97 $0.98 $0.70 $0.78 $0.87 $1.14 $1.36 $1.26 $1.10 $0.95 $0.89 4.72% <-IRR #YR-> 10 5 yr Running Average 58.54%
10 year Running Average $0.56 $0.60 $0.66 $0.75 $0.80 $0.84 $0.75 $0.83 $0.95 $1.06 $1.17 $0.98 $0.94 $0.91 $1.02 12.38% <-IRR #YR-> 5 5 yr Running Average 79.26%
* Diluted ESP per share E/P 10 Yrs 5.03% 5Yrs 7.15%
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.94
$0.46 $0.00 $0.00 $0.00 $0.00 -$0.94
-$0.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.26
-$0.70 $0.00 $0.00 $0.00 $0.00 $1.26
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 '07
Dividend* $0.20 $0.22 $0.28 $0.36 $0.43 $0.44 $0.47 $0.51 $0.55 $0.60 $0.69 $0.73 $0.73 $0.73 $0.73 229.55% <-Total Growth 10 Dividends
Increase 11.11% 10.00% 25.00% 30.91% 19.44% 2.33% 6.82% 8.51% 7.84% 8.64% 14.64% 5.84% 0.69% 0.00% 0.00% Count 28 Years of data
Dividends 5 Yr Running $0.15 $0.17 $0.21 $0.25 $0.30 $0.35 $0.40 $0.44 $0.48 $0.51 $0.56 $0.61 $0.66 $0.69 $0.72 260.88% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.24% 1.19% 1.31% 1.27% 1.98% 3.03% 2.13% 2.09% 2.13% 2.49% 2.40% 3.31% 3.36% 2.13% <-Median-> 10 Yield H/L Price
Yield on High Price 1.13% 1.06% 1.15% 1.07% 1.39% 2.32% 1.72% 1.69% 1.85% 2.19% 2.02% 2.82% 2.73% 1.78% <-Median-> 10 Yield on High Price
Yield on Low Price 1.39% 1.36% 1.52% 1.56% 3.45% 4.33% 2.80% 2.75% 2.52% 2.89% 2.94% 4.01% 4.36% 2.85% <-Median-> 10 Yield on Low Price
Yield on Close Price 1.14% 1.18% 1.15% 1.26% 3.02% 2.64% 1.73% 2.30% 2.24% 2.20% 2.72% 3.88% 2.74% 2.74% 2.74% 2.27% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 27.97% 24.04% 24.34% 23.53% 78.18% 57.14% -102.17% 33.77% 28.06% 30.80% 37.23% -77.13% 107.35% 58.40% 45.63% 29.43% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 20.65% 21.36% 23.09% 24.07% 30.68% 35.24% 56.11% 56.67% 55.43% 44.89% 41.42% 48.61% 43.15% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS -29.23% 24.79% 50.69% -111.85% 100.84% 13.36% 24.98% -108.14% 71.08% 19.97% 21.64% 32.14% 34.43% 30.17% 24.25% 23.31% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 19.99% 28.80% 39.26% 101.86% 174.67% 35.73% 33.92% 45.97% 40.65% 30.32% 33.72% 35.20% 29.07% 26.77% 27.75% 37.49% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 7.13% 7.52% 8.22% 10.18% 12.72% 19.31% 22.19% 14.74% 12.35% 10.70% 12.48% 18.24% 34.43% 30.17% 24.25% 12.60% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 8.29% 7.87% 7.69% 7.78% 9.29% 11.15% 13.47% 14.96% 15.30% 14.35% 13.33% 13.36% 15.21% 17.70% 21.16% 13.34% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 2.40% 2.30% 5 Yr Med Payout 30.80% 21.64% 12.48% 11.37% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. 14.28% 19.20% Last Div Inc ---> $0.1775 $0.1825 2.8% 9.06% <-IRR #YR-> 5 Dividends
-$0.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.73
-$0.47 $0.00 $0.00 $0.00 $0.00 $0.73
Historical Dividends Historical High Div 4.04% Low Div 0.98% Ave Div 2.51% Med Div 1.64% Close Div 1.53% Historical Dividends
High/Ave/Median Values Curr diff Exp. -32.25% 179.30% Cheap 9.05% Cheap 66.90% Cheap 79.12% High/Ave/Median
Future Dividend Yield Div Yd 4.21% earning in 5 Years at IRR of 9.00% Div Inc. 53.86% Future Dividend Yield
Future Dividend Yield Div Yd 6.48% earning in 10 Years at IRR of 9.00% Div Inc. 136.74% Future Dividend Yield
Future Dividend Yield Div Yd 9.97% earning in 15 Years at IRR of 9.00% Div Inc. 264.25% Future Dividend Yield
Yield if held 5 yrs 3.28% 3.71% 3.39% 2.97% 3.06% 2.74% 2.55% 2.43% 1.94% 2.75% 4.71% 3.29% 2.99% 2.83% 3.05% 2.86% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 3.76% 4.34% 4.52% 4.12% 5.98% 7.21% 7.93% 6.28% 4.53% 4.25% 4.26% 3.94% 3.48% 2.58% 3.36% 4.53% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 6.21% 6.46% 8.03% 11.52% 10.26% 8.28% 9.28% 8.38% 6.30% 8.31% 11.23% 12.23% 9.00% 6.02% 5.20% 8.83% <-Median-> 10 Paid Median Price
Yield if held 20 yrs 16.27% 13.66% 13.79% 14.89% 17.60% 14.26% 12.89% 14.31% 12.00% 8.36% 10.15% 14.29% <-Median-> 8 Paid Median Price
Yield if held 25 yrs 22.61% 21.27% 21.28% 21.31% 23.36% 17.42% 21.28% <-Median-> 3 Paid Median Price
Yield if held 30 yrs 27.63% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 11.97% 14.33% 12.63% 10.18% 10.57% 10.74% 10.72% 10.54% 8.48% 11.82% 19.34% 13.90% 13.47% 13.44% 15.02% 10.73% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 23.15% 26.65% 25.07% 20.44% 29.42% 40.25% 47.64% 39.86% 29.97% 28.84% 28.24% 27.38% 26.21% 20.73% 28.39% 29.13% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 47.98% 48.42% 54.74% 70.24% 61.58% 55.62% 65.65% 61.41% 47.92% 65.13% 86.35% 99.37% 80.38% 58.55% 54.47% 63.35% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 110.88% 101.55% 106.38% 119.27% 147.04% 122.85% 108.56% 126.21% 115.45% 87.63% 115.19% 115.07% <-Median-> 8 Paid Median Price
Cost covered if held 25 years 208.04% 188.90% 196.40% 215.26% 258.00% 208.77% 196.40% <-Median-> 3 Paid Median Price
Cost covered if held 30 years 344.28% #NUM! <-Median-> 0 Paid Median Price
Graham No. $10.99 $12.77 $15.19 $17.78 $10.67 $12.40 $13.46 $16.32 $20.05 $21.71 $22.62 $13.66 $13.13 $17.80 $20.14 6.99% <-Total Growth 10 Graham Number
Price/GP Ratio Med 1.46 1.44 1.38 1.59 2.04 1.17 1.64 1.50 1.29 1.10 1.26 1.60 1.66 1.44 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.61 1.62 1.57 1.88 2.91 1.53 2.03 1.85 1.49 1.26 1.50 1.88 2.04 1.71 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.31 1.26 1.19 1.30 1.17 0.82 1.24 1.14 1.09 0.95 1.03 1.32 1.27 1.15 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.59 1.45 1.57 1.61 1.34 1.35 2.01 1.36 1.23 1.25 1.12 1.37 2.03 1.50 1.32 1.35 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 59.30% 45.43% 57.35% 61.17% 33.59% 34.50% 101.23% 36.09% 22.56% 25.04% 11.53% 36.73% 103.10% 49.80% 32.40% 35.30% <-Median-> 10 Graham Price
Pre Split '07
Price Close $17.50 $18.57 $23.90 $28.66 $14.25 $16.68 $27.09 $22.21 $24.57 $27.15 $25.23 $18.68 $26.67 $26.67 $26.67 0.59% <-Total Growth 10 Stock Price
Increase 16.67% 6.11% 28.68% 19.94% -50.28% 17.05% 62.41% -18.01% 10.63% 10.50% -7.07% -25.96% 42.77% 0.00% 0.00% 0.06% <-IRR #YR-> 10 Stock Price
P/E 24.48 20.30 21.15 18.73 25.91 21.66 -58.89 14.71 12.54 13.99 13.71 -19.87 39.22 21.34 16.67 -7.16% <-IRR #YR-> 5 Stock Price
Trailing P/E 20.83 25.97 26.11 25.36 9.31 30.33 35.18 -48.28 16.27 13.85 13.01 10.15 -28.37 39.22 21.34 2.71% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 2.65% 2.65% % Tot Ret 97.82% 0.00% Price Inc -7.07% P/E: 14.35 13.71 -4.51% <-IRR #YR-> 5 Price & Dividend
-$18.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.68
-$27.09 $0.00 $0.00 $0.00 $0.00 $18.68
-$18.57 $0.28 $0.36 $0.43 $0.44 $0.47 $0.51 $0.55 $0.60 $0.69 $19.41
-$27.09 $0.51 $0.55 $0.60 $0.69 $19.41
Price H/L Median $16.07 $18.42 $20.98 $28.30 $21.73 $14.55 $22.07 $24.40 $25.81 $23.97 $28.60 $21.88 $21.74 18.79% <-Total Growth 10 Stock Price
Increase 14.34% 14.63% 13.90% 34.92% -23.23% -33.05% 51.74% 10.56% 5.76% -7.11% 19.32% -23.51% -0.62% 1.74% <-IRR #YR-> 10 Stock Price
P/E 22.47 20.13 18.56 18.50 39.50 18.89 -47.98 16.16 13.17 12.36 15.54 -23.27 31.97 -0.18% <-IRR #YR-> 5 Stock Price
Trailing P/E 19.13 25.76 22.92 25.04 14.20 26.45 28.66 -53.04 17.09 12.23 14.74 11.89 -23.13 4.20% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 22.72 23.13 23.62 27.58 22.44 14.86 31.35 31.28 29.80 20.95 21.06 17.33 19.84 2.60% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 28.76 30.64 31.80 37.78 27.09 17.25 29.43 29.26 27.28 22.70 24.48 22.25 23.18 14.99 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 2.47% 2.78% % Tot Ret 58.70% 106.82% Price Inc 5.76% P/E: 15.85 13.17 Count 28 Years of data
-$18.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21.88
-$22.07 $0.00 $0.00 $0.00 $0.00 $21.88
-$18.42 $0.28 $0.36 $0.43 $0.44 $0.47 $0.51 $0.55 $0.60 $0.69 $22.60
-$22.07 $0.51 $0.55 $0.60 $0.69 $22.60
High Months Apr Aug Dec Jul Mar Feb Aug May Nov
Pre Split '07
Price High $17.70 $20.70 $23.90 $33.50 $31.00 $18.94 $27.38 $30.25 $29.80 $27.25 $33.90 $25.67 $26.75 24.01% <-Total Growth 10 Stock Price
Increase 6.63% 16.95% 15.46% 40.17% -7.46% -38.90% 44.56% 10.48% -1.49% -8.56% 24.40% -24.28% 4.21% 2.18% <-IRR #YR-> 10 Stock Price
P/E 24.76 22.62 21.15 21.90 56.36 24.60 -59.52 20.03 15.20 14.05 18.42 -27.31 39.34 -1.28% <-IRR #YR-> 5 Stock Price
Trailing P/E 21.07 28.95 26.12 29.65 20.26 34.44 35.56 -65.76 19.74 13.90 17.47 13.95 -28.46 17.80 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -1.49% P/E: 19.23 15.20 23.41 P/E Ratio Historical High
-$20.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.67
-$27.38 $0.00 $0.00 $0.00 $0.00 $25.67
Low Months Dec Mar Jun Oct Mar Aug Dec Dec Feb
Price Low $14.43 $16.13 $18.05 $23.10 $12.45 $10.15 $16.76 $18.55 $21.81 $20.69 $23.30 $18.08 $16.73 12.09% <-Total Growth 10 Stock Price
Increase 25.48% 11.78% 11.90% 27.98% -46.10% -18.47% 65.12% 10.68% 17.57% -5.14% 12.61% -22.40% -7.47% 1.15% <-IRR #YR-> 10 Stock Price
P/E 20.18 17.63 15.97 15.10 22.64 13.18 -36.43 12.28 11.13 10.66 12.66 -19.23 24.60 1.53% <-IRR #YR-> 5 Stock Price
Trailing P/E 17.18 22.56 19.73 20.44 8.14 18.45 21.77 -40.33 14.44 10.56 12.01 9.83 -17.80 12.03 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 10.68% P/E: 12.47 11.13 9.00 P/E Ratio Historical Low
-$16.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.08
Long Term Debt $1,418 $1,548 $1,474 Debt
Debt/Market Cap Ratio 0.33 0.49 0.33 0.41 <-Median-> 2 Debt/Market Cap Ratio
Goodwill $92.50 $109.48 $114.13 $132.14 $178 $119 Goodwill
Intangibles $52.03 $94.80 $75.88 $55.78 $56 $69 Intangibles
Total $144.53 $204.28 $190.01 $187.93 $234 $188 Total
Intangible/Market Cap Ratio 0.04 0.05 0.04 0.04 0.07 0.04 0.04 <-Median-> 5 Intangible/Market Cap Ratio
Market Cap $M $3,094 $3,313 $4,279 $5,048 $2,429 $2,848 $4,644 $3,811 $4,224 $4,670 $4,349 $3,139 $4,484 $4,484 $4,484 -5.26% <-Total Growth 10 Market Cap
Diluted # of Sh in Million 160.141 179.789 179.799 180.460 173.319 170.993 171.718 172.287 172.391 172.403 172.968 171.285 171.058 -4.73% <-Total Growth 10 Diluted
Change 1.62% 12.27% 0.01% 0.37% -3.96% -1.34% 0.42% 0.33% 0.06% 0.01% 0.33% -0.97% -0.13% 0.03% <-Median-> 10 Change
Average # of Sh in Million 158.040 177.700 178.740 178.840 172.360 170.610 171.030 171.550 171.837 171.981 172.216 171.142 170.933 -3.69% <-Total Growth 10 Average
Change 2.19% 12.44% 0.59% 0.06% -3.62% -1.02% 0.25% 0.30% 0.17% 0.08% 0.14% -0.62% -0.12% 0.11% <-Median-> 10 Change
Difference 11.9% 0.4% 0.2% -1.5% -1.1% 0.1% 0.2% 0.0% 0.0% 0.0% 0.1% -1.8% -1.6% 0.03% <-Median-> 10 Difference
Equity Iss. $679.50 <-12 mths 79.29%
# of Share in Millions 176.78 178.40 179.09 176.13 170.45 170.75 171.43 171.57 171.91 172.01 172.37 168.03 168.13 168.13 168.13 -0.60% <-IRR #YR-> 10 Shares
Change 13.68% 0.92% 0.39% -1.65% -3.23% 0.18% 0.40% 0.08% 0.20% 0.06% 0.21% -2.52% 0.06% 0.00% 0.00% -0.40% <-IRR #YR-> 5 Shares
CF fr Op $M -$120.96 $158.30 $97.16 -$56.69 $72.68 $562.36 $322.54 -$80.92 $133.03 $514.70 $545.63 $379 $356.44 $406.89 $506.08 139.41% <-Total Growth 10 Cash Flow
Increase -198.62% 230.88% -38.63% -158.35% 228.21% 673.73% -42.64% -125.09% 264.40% 286.92% 6.01% -30.54% -5.95% 14.15% 24.38% SO; S. Iss Buy Backs
5 year Running Average $109 $92 $85 $40 $30 $167 $200 $164 $202 $290 $287 $298 $386 $441 $439 223.53% <-Total Growth 10 CF 5 Yr Running
CFPS -$0.68 $0.89 $0.54 -$0.32 $0.43 $3.29 $1.88 -$0.47 $0.77 $2.99 $3.17 $2.26 $2.12 $2.42 $3.01 154.19% <-Total Growth 10 Cash Flow per Share
Increase -186.75% 229.69% -38.86% -159.33% 232.49% 672.37% -42.87% -125.07% 264.08% 286.68% 5.79% -28.75% -6.01% 14.15% 24.38% 9.12% <-IRR #YR-> 10 Cash Flow 139.41%
5 year Running Average $0.73 $0.59 $0.52 $0.24 $0.17 $0.97 $1.16 $0.96 $1.18 $1.69 $1.67 $1.74 $2.26 $2.59 $2.59 3.28% <-IRR #YR-> 5 Cash Flow 17.50%
P/CF on Med Price -23.48 20.75 38.66 -87.93 50.95 4.42 11.73 -51.74 33.35 8.01 9.04 9.70 9.78% <-IRR #YR-> 10 Cash Flow per Share 154.19%
P/CF on Closing Price -25.58 20.93 44.05 -89.04 33.42 5.06 14.40 -47.09 31.75 9.07 7.97 8.28 12.58 3.69% <-IRR #YR-> 5 Cash Flow per Share 19.88%
34.31% Diff M/C 11.43% <-IRR #YR-> 10 CFPS 5 yr Running 195.26%
Excl.Working Capital CF $616.85 $363.39 $502.08 $679.71 $503.37 -$173.27 $40.60 $674.75 $632.50 $445.80 $400.38 $289 $0.00 $0.00 $0.00 8.40% <-IRR #YR-> 5 CFPS 5 yr Running 49.70%
CF fr Op $M WC $495.9 $521.7 $599.2 $623.0 $576.1 $389.1 $363.1 $593.8 $765.5 $960.5 $946.0 $668 $356.4 $406.9 $506.1 28.04% <-Total Growth 10 Cash Flow less WC
Increase -2.01% 5.20% 14.86% 3.97% -7.54% -32.46% -6.67% 63.53% 28.91% 25.47% -1.51% -29.39% -46.64% 14.15% 24.38% 2.50% <-IRR #YR-> 10 Cash Flow less WC 28.04%
5 year Running Average $284 $360 $456 $549 $563 $542 $510 $509 $538 $614 $726 $787 $739 $668 $577 12.96% <-IRR #YR-> 5 Cash Flow less WC 83.95%
CFPS Excl. WC $2.81 $2.92 $3.35 $3.54 $3.38 $2.28 $2.12 $3.46 $4.45 $5.58 $5.49 $3.98 $2.12 $2.42 $3.01 8.12% <-IRR #YR-> 10 CF less WC 5 Yr Run 118.33%
Increase -13.80% 4.25% 14.42% 5.72% -4.45% -32.58% -7.04% 63.39% 28.66% 25.39% -1.71% -27.56% -46.67% 14.15% 24.38% 9.05% <-IRR #YR-> 5 CF less WC 5 Yr Run 54.24%
5 year Running Average $1.76 $2.16 $2.67 $3.17 $3.20 $3.09 $2.93 $2.96 $3.14 $3.58 $4.22 $4.59 $4.32 $3.92 $3.40 3.12% <-IRR #YR-> 10 CFPS - Less WC 35.95%
P/CF on Med Price 5.73 6.30 6.27 8.00 6.43 6.38 10.42 7.05 5.79 4.29 5.21 5.50 13.42% <-IRR #YR-> 5 CFPS - Less WC 87.67%
P/CF on Closing Price 6.24 6.35 7.14 8.10 4.22 7.32 12.79 6.42 5.52 4.86 4.60 4.70 12.6 11.0 8.9 7.84% <-IRR #YR-> 10 CFPS 5 yr Running 112.71%
*Operational Cash Flow. CF-WC P/CF Med 10 yr 9.37 5 yr 9.04 P/CF Med 10 yr 6.33 5 yr 5.50 98.87% Diff M/C 9.39% <-IRR #YR-> 5 CFPS 5 yr Running 56.63%
-$0.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.26 Cash Flow per Share
-$1.88 $0.00 $0.00 $0.00 $0.00 $2.26 Cash Flow per Share
-$0.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1.7 CFPS 5 yr Running
-$1.2 $0.0 $0.0 $0.0 $0.0 $1.7 CFPS 5 yr Running
-$521.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $668.0 Cash Flow less WC
-$363.1 $0.0 $0.0 $0.0 $0.0 $668.0 Cash Flow less WC
-$360.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $786.8 CF less WC 5 Yr Run
-$510.1 $0.0 $0.0 $0.0 $0.0 $786.8 CF less WC 5 Yr Run
-$2.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.98 CFPS - Less WC
-$2.12 $0.00 $0.00 $0.00 $0.00 $3.98 CFPS - Less WC
-$2.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.59 CFPS 5 yr Running
-$2.93 $0.00 $0.00 $0.00 $0.00 $4.59 CFPS 5 yr Running
OPM -2.9% 3.3% 2.0% -1.0% 1.2% 11.9% 6.9% 11.4% 9.6% 6.6% 5.8% 4.7% 42.59% <-Total Growth 10 OPM
Increase -185.14% -212.67% -38.86% -150.01% -221.2% 878.51% -41.46% 64.71% -16.55% -30.92% -12.29% -19.33% Should increase or be stable.
Diff from Ave -146.9% -47.1% -67.7% -116.2% -80.4% 91.7% 12.2% 84.8% 54.2% 6.5% -6.5% -24.6% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 6.19% 5 Yrs 6.60% should be zero, it is a check on calculations
Current Assets $1,759.0 $1,814.8 $2,232.0 $2,248.9 $2,814.8 $2,083.7 $2,378.5 $2,777.5 $3,317.2 $3,248.6 $3,477.7 $3,460 $3,319 Liquidity ratio of 1.5 and up, best
Current Liabilities $1,405.0 $1,324.0 $1,637.7 $1,725.4 $1,516.3 $945.0 $1,308.1 $1,742.5 $2,250.2 $1,549.3 $1,372.3 $1,243 $1,194 1.84 <-Median-> 10 Ratio
Liquidity 1.25 1.37 1.36 1.30 1.86 2.20 1.82 1.59 1.47 2.10 2.53 2.78 2.78 2.10 <-Median-> 5 Ratio
Liq. with CF aft div 1.22 1.46 1.39 1.26 1.86 2.72 2.00 1.52 1.49 2.36 2.85 2.99 2.98 2.36 <-Median-> 5 Ratio
Liq. CF re Inv+Div 1.16 1.41 1.39 1.26 1.86 2.59 2.00 1.41 1.17 2.25 2.69 2.40 2.98 2.25 <-Median-> 5 Ratio
Assets $3,804.0 $3,736.4 $4,200.8 $4,134.2 $4,720.4 $3,671.4 $3,613.6 $4,085.4 $5,118.0 $5,057.6 $5,272.7 $5,108 $4,886 Debt Ratio of 1.5 and up, best
Liabilities $2,477.8 $2,323.4 $2,576.3 $2,516.4 $3,153.3 $2,155.7 $2,227.1 $2,740.4 $3,551.5 $3,199.8 $3,142.0 $3,058 $2,991 1.63 <-Median-> 10 Ratio
Debt Ratio 1.54 1.61 1.63 1.64 1.50 1.70 1.62 1.49 1.44 1.58 1.68 1.67 1.63 1.58 <-Median-> 5 Ratio
down
Book Value $1,326 $1,413 $1,624 $1,618 $1,567 $1,516 $1,387 $1,345 $1,567 $1,858 $2,131 $2,050 $1,895 $1,895 $1,895 45.08% <-Total Growth 10 Book Value
Book Value per Share $7.50 $7.92 $9.07 $9.19 $9.19 $8.88 $8.09 $7.84 $9.11 $10.80 $12.36 $12.20 $11.27 $11.27 $11.27 54.04% <-Total Growth 10 Book Value per Share
Change 21.70% 5.57% 14.52% 1.27% 0.10% -3.45% -8.88% -3.08% 16.25% 18.52% 14.45% -1.30% -7.62% 0.00% 0.00% 1.20% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 2.14 2.33 2.31 3.08 2.36 1.64 2.73 3.11 2.83 2.22 2.31 1.79 1.93 2.22 P/B Ratio Historical Median
P/B Ratio (Close) 2.33 2.34 2.63 3.12 1.55 1.88 3.35 2.83 2.70 2.51 2.04 1.53 2.37 2.37 2.37 4.42% <-IRR #YR-> 10 Book Value per Share
Change -4.14% 0.51% 12.36% 18.44% -50.33% 21.24% 78.24% -15.41% -4.84% -6.76% -18.81% -24.98% 54.55% 0.00% 0.00% 8.57% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 2.87 2.64 2.59 2.56 3.01 2.42 2.61 3.04 3.27 2.72 2.47 2.49 2.58 2.60 <-Median-> 10 A/BV
Debt/Equity Ratio 1.87 1.64 1.59 1.56 2.01 1.42 1.61 2.04 2.27 1.72 1.47 1.49 1.58 1.60 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.34 5 yr Med 2.31 1.20% Diff M/C 2.96 Historical Leverage (A/BK)
-$7.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.20
-$8.09 $0.00 $0.00 $0.00 $0.00 $12.20
-$305.0 <-12 mths -360.66%
Comprehensive Income $250.17 $127.18 $151.78 $13.40 -$58.85 $225.30 $311.25 $387.66 $382.17 $117 -53.23% <-Total Growth 9 Comprehensive Income
Increase -49.16% 19.34% -91.17% -539.24% 482.83% 38.15% 24.55% -1.42% -69.39% 24.55% <-Median-> 5 Comprehensive Income
5 Yr Running Average $96.74 $91.76 $128.57 $175.75 $249.50 $284.67 -8.10% <-IRR #YR-> 9 Comprehensive Income -53.23%
ROE 15.4% 7.9% 9.7% 0.9% -4.2% 16.8% 19.9% 20.9% 17.9% 5.7% #NUM! <-IRR #YR-> 5 Comprehensive Income 298.81%
5Yr Median 7.9% 7.9% 9.7% 16.8% 17.9% 17.9% 24.09% <-IRR #YR-> 5 5 Yr Running Average 194.28%
% Difference from NI 22.6% -54.3% 58.1% -89.8% -134.5% -13.1% -7.8% 15.6% 20.1% -172.7% 24.09% <-IRR #YR-> 5 5 Yr Running Average 194.28%
Median Values Diff 5, 10 yr -10.5% -7.8% 17.9% <-Median-> 5 Return on Equity
-$250.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $117.0
$58.9 $0.0 $0.0 $0.0 $0.0 $117.0
-$96.7 $0.0 $0.0 $0.0 $0.0 $284.7
-$96.7 $0.0 $0.0 $0.0 $0.0 $284.7
Current Liability Coverage Ratio 0.35 0.39 0.37 0.36 0.38 0.41 0.28 0.34 0.34 0.62 0.69 0.54 CFO / Current Liabilities
5 year Median 0.15 0.35 0.37 0.37 0.37 0.38 0.37 0.36 0.34 0.34 0.34 0.54 0.54 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 13.04% 13.96% 14.26% 15.07% 12.20% 10.60% 10.05% 14.54% 14.96% 18.99% 17.94% 13.08% CFO / Total Assets
5 year Median 6.55% 13.04% 13.96% 14.26% 13.96% 13.96% 12.20% 12.20% 12.20% 14.54% 14.96% 14.96% 15.0% <-Median-> 5 Return on Assets
Return on Assets ROA 3.0% 4.4% 4.9% 6.7% 2.0% 3.6% 4.7% 6.3% 6.6% 6.6% 6.0% -3.2% Net Income/Assets Return on Assets
5Yr Median 3.4% 3.8% 4.2% 4.4% 4.4% 4.4% 4.7% 4.7% 4.7% 6.3% 6.3% 6.3% 6.3% <-Median-> 5 Asset Efficiency Ratio
Comments -5.7% <--Real Comments
Return on Equity ROE 8.7% 11.6% 12.6% 17.2% 6.1% 8.6% 12.3% 19.3% 21.6% 18.0% 14.9% -7.9% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 13.4% 13.4% 12.6% 12.6% 11.6% 11.6% 12.3% 12.3% 12.3% 18.0% 18.0% 18.0% 18.0% <-Median-> 5 Return on Equity
-$252.6 <-12 mths 56.88%
Comments -$78.37 <--Real Comments
Comments Real continuing operations --> $1.00 $1.51 $1.96 Comments
Net Income $114.95 $164.03 $204.08 $278.06 $96.00 $130.82 $170.72 $259.37 $337.62 $335.26 $318.24 -$161 $119 $214 $268 -198.15% <-Total Growth 10 Net Income
Increase -12.89% 42.70% 24.41% 36.25% -65.48% 36.28% 30.49% 51.93% 30.17% -0.70% -5.07% -150.59% -173.91% 79.83% 25.23% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $111.3 $129.4 $149.5 $178.6 $171.4 $174.6 $175.9 $187.0 $198.9 $246.8 $284.2 $218 $189.8 $165.1 $151.6 #NUM! <-IRR #YR-> 10 Net Income -198.15%
Operating Cash Flow -$120.96 $158.30 $97.16 -$56.69 $72.68 $562.36 $322.54 -$80.92 $133.03 $514.70 $545.63 $379 #NUM! <-IRR #YR-> 5 Net Income -194.31%
Investment Cash Flow -$76.83 -$44.86 $107.81 $181.34 $43.25 -$48.45 $48.41 -$139.37 -$625.65 -$78.78 -$81.26 -$306 5.35% <-IRR #YR-> 10 5 Yr Running Average 68.36%
Total Accruals $312.73 $50.59 -$0.89 $153.41 -$19.93 -$383.09 -$200.24 $479.65 $830.24 -$100.67 -$146.13 -$234 4.37% <-IRR #YR-> 5 5 Yr Running Average 23.85%
Total Assets $3,804.0 $3,736.4 $4,200.8 $4,134.2 $4,720.4 $3,671.4 $3,613.6 $4,085.4 $5,118.0 $5,057.6 $5,272.7 $5,108 Balance Sheet Assets
Accruals Ratio 8.22% 1.35% -0.02% 3.71% -0.42% -10.43% -5.54% 11.74% 16.22% -1.99% -2.77% -4.58% -1.99% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.25 0.31 0.34 0.43 0.16 0.34 -0.22 0.44 0.44 0.35 0.34 -0.24 0.34 <-Median-> 10 EPS/CF Ratio
-$164.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$161.0
-$170.7 $0.0 $0.0 $0.0 $0.0 -$161.0
-$129.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $217.9
-$175.9 $0.0 $0.0 $0.0 $0.0 $217.9
Change in Close 16.67% 6.11% 28.68% 19.94% -50.28% 17.05% 62.41% -18.01% 10.63% 10.50% -7.07% -25.96% 42.77% 0.00% 0.00% Count 21 Years of data
up/down down down up up down down Count 10 47.62%
Meet Prediction? Yes % right Count 2 20.00%
Financial Cash Flow $137.81 -$97.25 -$157.08 -$129.02 $163.69 -$409.82 -$198.82 -$2.81 $488.83 -$386.96 -$202.84 -$107 C F Statement Financial Cash Flow
Total Accruals $174.93 $147.84 $156.19 $282.43 -$183.62 $26.73 -$1.42 $482.46 $341.41 $286.29 $56.72 -$127 Accruals
Accruals Ratio 4.60% 3.96% 3.72% 6.83% -3.89% 0.73% -0.04% 11.81% 6.67% 5.66% 1.08% -2.49% 5.66% <-Median-> 5 Ratio
Cash $61.86 $109.77 $197.90 $349.86 $122.75 $114.92 $176.27 $450.67 $475 $460 Cash
Cash per Share $0.35 $0.64 $1.16 $2.04 $0.72 $0.67 $1.02 $2.61 $2.83 $2.74 $1.02 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.23% 4.52% 6.95% 7.53% 3.22% 2.72% 3.77% 10.36% 15.13% 10.26% 3.77% <-Median-> 5 % of Stock Price
Notes:
November 29, 2016. Last estimates were for 2015, 2016 and 2017 of $6254M, $6147M and $6448M for Revenue, $1.34, $1.58 and $1.75 for EPS,
$2.12 and $2.60 for 2015 and 2016 for CFPS , $221M, $258M and $294M for Net Income.
December 5, 2015. Last estimates were for 2014, 2015 and 2016 of $6878M, $6995M and $7354M for Revenue, $1.89, $2.12 and $2.30 for EPS, $3.04, $3.28 and $3.33 for CFPS and $317M, $367M and $390M for Net Income.
December 5, 2014. The last estimaytes were for 2013, 2014 and 2014 of $6752M, $6824M and $7013M for Revenue, $1.94, $2.16 and $2.37 for EPS, $3.04, $3.06 and $3.61 for CFPS.
November 27, 2013. Last estimates were for 2012 and 2013 of $6689M and $7172M for Revenue and $1.91 and $2.34 for earnings and $3.30 for CFPS (2012 only)
Nov 28, 2012. Last estimates were fo 2011 and 2012 of $5533M and $6069M for revenue, $1.50 and $2.04 for EPS and $2.26 and $3.30 for CFPS.
Nov 7, 2011. Last I looked I got estimates for 2010 and 2011 of $.95 and $1.40 for earnings and $1.84 and $2.26 for cash flow. Used earnings from continuing operations for Net Income, Graham Price.
Admin expense down in 2009.
Sep 25, 2010. Earning estimates for 2009 and 2010 were $1.40 and $1.53 when I last looked.
AR 2007. This is in the same industry as Toromont. Company does not look bad, but do I want to have 2 companies in this business? Lack of Cash Flow a problem.
***Payout Ratio of Dividends to Cash Flow is using CF excluding Non-Cash Items (i.e. Working Capital changes)
Sector:
Industrial, Industrial
What should this stock accomplish?
Would I buy this company and Why.
Now, the only reason I would not buy this company is because I own Toromont Industries Ltd. They are both involved with Caterpillar equipment, although the companies are often classified in different sectors.
I classify these companies as industrials, but Stock Channel classifies Finning as Construction and Finning as Industrial.
Dividends
Dividends are paid in Cycle 3, that is in March, June, September and December. Dividends declared for shareholders of record in one month are paid in the following month.
For example, the dividend declared November 13 2013 for Shareholders of record of November 28 2013, is payable on December 12, 2013.
Why am I following this stock.
When I was in the market to buy an industrial stock in this area in 2007, I look at this stock was well as Toromont Industries (TSX-TIH). At the time I liked Toromont better, so that is what I bought.
How they make their money.
This company sells, rents and provides customer support services for Caterpillar equipment and engines. They cover Canada, UK, Argentina, Bolivia, Chile and Uruguay.
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 Dec 12 2012 Nov 29 2013 Dec 5 2014 Dec 5 2015 Nov-29 2016
Thomson, Scott 0.042 0.02% 0.088 0.05% 0.106 0.06% 0.112 0.07%
CEO - Shares - Amount $1.127 $2.211 $1.980 $2.995
Options - percentage 0.510 0.30% 0.744 0.43% 1.130 0.67% 1.329 0.79%
Options - amount $13.860 $18.761 $21.110 $35.436
Waites, Michael T. 0.187 0.11%
CEO - Shares - Amount $4.595
Options - percentage 1.003 0.58%
Options - amount $24.633
Nielsen, Steven Mathew 0.000 0.00% 0.003 0.00%
CFO - Shares - Amount $0.000 $0.067
Options - percentage 0.110 0.07% 0.202 0.12%
Options - amount $2.052 $5.387
Smith, David 0.020 0.01% 0.024 0.01% none in 2014
CFO - Shares - Amount $0.493 $0.654
Options - percentage 0.135 0.08% 0.188 0.11%
Options - amount $3.319 $5.108
Amar, Juan Pablo 0.002 0.00% 0.010 0.01% 0.012 0.01% 0.014 0.01%
Officer - Shares - Amount $0.067 $0.256 $0.219 $0.383
Options - percentage 0.068 0.04% 0.058 0.03% 0.059 0.04% 0.071 0.04%
Options - amount $1.834 $1.469 $1.100 $1.890
Primrose, David Francis Neil 0.012 0.01% 0.015 0.01% 0.018 0.01% 0.020 0.01%
Officer - Shares - Amount $0.305 $0.390 $0.334 $0.533
Options - percentage 0.183 0.11% 0.181 0.11% 0.176 0.11% 0.166 0.10%
Options - amount $4.490 $4.568 $3.296 $4.437
Bacarreza, Ricardo 0.025 0.01% 0.021 0.01%
Director - Shares - Amount $0.679 $0.530
Options - percentage 0.047 0.03% 0.051 0.03%
Options - amount $1.277 $1.287
Reid, John McDonald 0.020 0.01% 0.020 0.01% 0.005 0.00% 0.020 0.01%
Director - Shares - Amount $0.491 $0.505 $0.087 $0.533
Options - percentage 0.022 0.01% 0.032 0.02% -0.017 -0.01% 0.041 0.02%
Options - amount $0.549 $0.799 -$0.311 $1.104
Whitehead, Douglas William Geoffrey 0.173 0.10% 0.173 0.10% 0.163 0.10% was chairman to 2016
Director - Shares - Amount $4.360 $3.228 $4.342
Options - percentage 0.056 0.03% 0.063 0.04% 0.071 0.04%
Options - amount $1.418 $1.186 $1.904
Wilson, Michael M 0.010 0.01%
Chairman - Shares - Amt $0.267
Options - percentage 0.031 0.02%
Options - amount $0.829
Increase in O/S Shares 0.096 0.06% 0.354 0.21% 0.356 0.21% 0.044 0.03% repurchase of shares $20.76
due to SO $2.613 $9.619 $8.983 $0.828 4.383 2.54%
Book Value $1.897 $10.258 $10.315 $1.000
Insider Buying -$1.449 -$0.182
Insider Selling $0.918 $1.110
Net Insider Selling $2.316 -$0.531 $0.928
% of Market Cap 0.05% -0.02% 0.02%
Directors 9 13 11 13
Women 1 11% 2 15% 2 18% 3 23%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 153 38.62% 124 33.81% 187 40.81% 168 40.78% 157 39.24%
Total Shares Held 66.394 38.62% 58.156 33.81% 70.336 40.81% 69.019 41.08% 65.981 39.24%
Increase/Decrease 3.420 4.9% 1.614 2.85% 2.230 3.27% 8.139 13.37% 0.122 0.19%
Starting No. of Shares 69.813 56.542 68.106 60.880 65.859 Reuters
Copyright 2008 Website of SPBrunner. All rights reserved.