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.
See my website on stocks or see my blog at the following sites.    www.spbrunner.com/stocks.html   www.spbrunner.blogspot.com/                                        
McCoy Corp         www.mccoycorporation.ca MCB   Fiscal Yr: Dec 31                                          
Year 12/31/99 12/31/00 12/31/01 12/31/02 12/31/03 12/31/04 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/30/12       #Y                              
Accting Rules GAAP IFRS                                      
Revenue* $64.6 $39.0 $40.2 $27.1 $30.8 $52.1 $104.5 $144.5 $161.1 $168.4 $97.5 $109.7 $142.0 $152.0   181.69% <-Total Growth 10 Revenue                            
Increase -4.65% -39.74% 3.14% -32.54% 13.59% 69.34% 100.52% 38.23% 11.46% 4.55% -42.08% 12.49% 29.41% 7.04%   10.91% <-IRR #YR-> 10 Revenue                            
Rev per Share $6.30 $3.80 $3.92 $1.55 $1.76 $2.95 $5.71 $7.48 $5.78 $6.36 $3.68 $4.14 $5.36 $5.74   0.97% <-IRR #YR-> 5 Revenue                            
P/S (Price/Sales) 0.33 0.63 0.26 0.16 0.19 0.95 1.10 0.82 0.53 0.21 0.39 0.89 0.77 0.72   0.88% <-IRR #YR-> 10 Rev Per share                            
*Revenue in M CDN $              P/S 10 yr  0.46 5 yr  0.53       -6.21% <-IRR #YR-> 5 Rev Per share                            
                                                                   
    -$39.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $109.7                                          
              -$104.5 $0.0 $0.0 $0.0 $0.0 $109.7                                          
    -$3.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.14                                          
              -$5.71 $0.00 $0.00 $0.00 $0.00 $4.14                                          
                               
EPS* -$0.20 -$0.62 $0.01 -$0.17 $0.05 $0.16 $0.33 $0.42 $0.36 -$0.20 -$0.50 $0.18 $0.39 $0.48   -129.03% <-Total Growth 10 Earnings                            
Increase -233% 210.00% -102% -1800% -129% 220.00% 106.25% 27.27% -14.29% -156% 150% -136% 117% 23%   37.87% <-IRR #YR-> 10 Earnings                            
* ESP per share (Cdn GAAP)                             -11.42% <-IRR #YR-> 5 Earnings                            
      -$0.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.18                                          
              -$0.33 $0.00 $0.00 $0.00 $0.00 $0.18                                          
                                                                   
Sp Div                         $0.04                                        
Div*           $0.01 $0.03 $0.04 $0.09 $0.12 $0.03 $0.00 $0.04 $0.04   -100.00% <-Total Growth 4 Dividends                            
Increase             200.00% 33.33% 125.00% 33.33% -75.00% -100.00% #DIV/0! 0.00%   33.33% <-Median-> 5 Dividends                            
Yield H/L             0.56% 0.51% 1.93% 4.31% 2.34% 0.00% #DIV/0! #DIV/0!   1.93% <-Median-> 5 Dividends                            
Yield on Cl           0.36% 0.48% 0.66% 2.95% 8.89% 2.08% 0.00% 0.97% 0.97%   1.37% <-Median-> 6 Dividends                            
Payout Ratio           6.3% 9.1% 9.5% 25.0% -60.0% -6.0% 0.0% 10.3% 8.3%   7.67% <-Median-> 6 Dividends                            
Payout Ratio CF             6.5% 31.5% 17.8% 28.0% 7.7% 0.0% 5.8% #DIV/0!   17.76% <-Median-> 5 Dividends                            
Average 5 Yrs     Div Yd $0.02 in 5 yrs 0.97% Yield  1.93% 2.08% Payout 0.00% 17.76%       #NUM! <-IRR #YR-> 10 Dividends                            
* Dividends per share      10.00% 5 10.00%     Last Div Inc ---> $0.03 $0.01 -66.7%     0.00% <-IRR #YR-> 4 Dividends                            
                                                                   
      $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.04                                        
                -$0.04 $0.00 $0.00 $0.00 $0.00 $0.04                                        
                                                                   
I am earning                     TFSA $4.04 2011 0.99%                                      
H/LYield held 5 yrs 1.55% 2.63% 18.00% 36.92% 1.50% 0.00% 0.51% 0.86%   Ave H/L Yield on your    Dividends                            
H/LYield held 10 yrs #REF! 1.33% 0.00% 2.63% 8.00%   Ave H/L original money   Dividends                            
                                                                   
Graham No. $2.01 $0.36 $0.37 $0.31 $0.75 $1.51 $2.66 $3.84 $4.70 $3.23 $2.83 $2.95 $4.45 $4.93   Cl Pr higher/lower by?                                
Prem /Disc. High 29.09% 555.69% 501.73% 138.10% -33.21% 137.66% 202.33% 155.15% 35.05% 39.37% -38.18% 30.59%       88.51% <-Median-> 10 Graham Price                            
Prem /Disc. Ave 11.71% 434.47% 315.74% 58.73% -56.59% 32.03% 102.81% 105.03% -0.57% -13.74% -54.78% -14.02%       15.73% <-Median-> 10 Graham Price                            
Prem /Disc. Low -5.67% 313.25% 129.75% -20.63% -79.96% -73.59% 3.28% 54.91% -36.20% -66.86% -71.39% -58.62%       -47.41% <-Median-> 10 Graham Price                            
Prem /Disc. Cl 4.26% 555.69% 176.25% -20.63% -55.92% 84.84% 136.61% 58.82% -35.13% -58.19% -49.13% 25.50% -6.93% -16.11%   2.43% <-Median-> 10 Graham Price                            
                                                                   
Price Cl $2.10 $2.38 $1.01 $0.25 $0.33 $2.80 $6.30 $6.10 $3.05 $1.35 $1.44 $3.70 $4.14 $4.14   55.46% <-Total Growth 10 Stock Price                            
Increase 5.00% 13.33% -57.56% -75.25% 32.00% 748.48% 125.00% -3.17% -50.00% -55.74% 6.67% 156.94% 11.89% 0.00%   4.51% <-IRR #YR-> 10 Stock Price                            
P/E -10.50 -3.84 101.00 -1.47 6.60 17.50 19.09 14.52 8.47 -6.75 -2.88 20.56 10.62 8.63   -10.10% <-IRR #YR-> 5 Stock Price                            
Trailing P/E 14.00 -11.90 -1.63 25.00 -1.94 56.00 39.38 18.48 7.26 3.75 -7.20 -7.40 23.00 10.62   5.52% <-IRR #YR-> 10 Price & Div                            
Median 5 Yrs       1.05% 1.01% Div %  5, 10 yrs Price Inc -3.17% P/E: Y-T 8.47 3.75       -9.05% <-IRR #YR-> 5 Price & Div                            
                                                                   
    -$2.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.70                                          
              -$6.30 $0.00 $0.00 $0.00 $0.00 $3.70                                          
    -$2.38 $0.00 $0.00 $0.00 $0.01 $0.03 $0.04 $0.09 $0.12 $0.03 $3.70                                          
              -$6.30 $0.04 $0.09 $0.12 $0.03 $3.70                                          
                                                                   
Price Med H/L $2.25 $1.94 $1.52 $0.50 $0.33 $2.00 $5.40 $7.88 $4.68 $2.79 $1.28 $2.54       30.67% <-Total Growth 10 Stock Price                            
Increase -12.62% -13.78% -21.65% -67.11% -35.00% 515.38% 170.00% 45.83% -40.63% -40.43% -54.04% 98.05%       2.71% <-IRR #YR-> 10 Stock Price                            
P/E -11.25 -3.13 152.00 -2.94 6.50 12.50 16.36 18.75 12.99 -13.93 -2.56 14.08       -14.04% <-IRR #YR-> 5 Stock Price                            
Trailing P/E 15.00 -9.70 -2.45 50.00 -1.91 40.00 33.75 23.86 11.13 7.74 -6.40 -5.07       4.08% <-IRR #YR-> 10 Price & Div                            
Median 5 Yrs       1.32% 1.37% Div %  5, 10 yrs Price Inc -40.43% P/E: Y-T 12.99 7.74       -12.72% <-IRR #YR-> 5 Price & Div                            
                                                                   
    -$1.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.54                                          
              -$5.40 $0.00 $0.00 $0.00 $0.00 $2.54                                          
    -$1.94 $0.00 $0.00 $0.00 $0.01 $0.03 $0.04 $0.09 $0.12 $0.03 $2.54                                          
              -$5.40 $0.04 $0.09 $0.12 $0.03 $2.54                                          
                                                                   
Hi Mths Jul Dec Mar May May Nov Jul May Jun Jun Jan Dec                                          
Price Hi $2.60 $2.38 $2.20 $0.75 $0.50 $3.60 $8.05 $9.80 $6.35 $4.50 $1.75 $3.85       61.76% <-Total Growth 10 Stock Price                            
Increase -18.75% -8.46% -7.56% -65.91% -33.33% 620.00% 123.61% 21.74% -35.20% -29.13% -61.11% 120.00%       4.93% <-IRR #YR-> 10 Stock Price                            
P/E -13.00 -3.84 220.00 -4.41 10.00 22.50 24.39 23.33 17.64 -22.50 -3.50 21.39       -13.72% <-IRR #YR-> 5 Stock Price                            
Trailing P/E 17.33 -11.90 -3.55 75.00 -2.94 72.00 50.31 29.70 15.12 12.50 -8.75 -7.70                                          
Median 5 Yrs               Price Inc -29.13% P/E: Y-T 17.64 12.50                                          
                                                                   
    -$2.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.85                                          
              -$8.05 $0.00 $0.00 $0.00 $0.00 $3.85                                          
                                                                   
Low Mths Feb Sep Dec Dec Mar Jan Jan Jan Dec Dec Mar Jun                                          
Price Low $1.90 $1.50 $0.84 $0.25 $0.15 $0.40 $2.75 $5.95 $3.00 $1.07 $0.81 $1.22       -18.67% <-Total Growth 10 Stock Price                            
Increase -2.56% -21.05% -44.00% -70.24% -40.00% 166.67% 587.50% 116.36% -49.58% -64.33% -24.30% 50.62%       -2.04% <-IRR #YR-> 10 Stock Price                            
P/E -9.50 -2.42 84.00 -1.47 3.00 2.50 8.33 14.17 8.33 -5.35 -1.62 6.78       -15.00% <-IRR #YR-> 5 Stock Price                            
Trailing P/E 12.67 -7.50 -1.35 25.00 -0.88 8.00 17.19 18.03 7.14 2.97 -4.05 -2.44                                          
Median 5 Yrs               Price Inc -24.30% P/E: Y-T 6.78 2.97                                          
                                                                   
    -$1.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.22                                          
                                                                   
Market Cap $22 $24 $10 $4 $6 $49 $115 $118 $85 $36 $38 $98 $110 $110                                      
                                                                   
# of Sh in M 10.261 10.261 10.261 17.534 17.534 17.649 18.303 19.320 27.866 26.476 26.476 26.476 26.476 26.476     Share Capital   Shares                            
Increase 7.10% 0.00% 0.00% 70.88% 0.00% 0.66% 3.71% 5.55% 44.23% -4.99% 0.00% 0.00% 0.00% 0.00%   0.33% <-Median-> 10 Shares                            
CF fr Op $M $2.359 $5.224 $3.500 $2.283 $0.800 $3.473 $8.460 $2.455 $14.123 $11.345 $10.381 $15.572 $18.394     198.09% <-Total Growth 10 Cash Flow                            
OPS $0.23 $0.51 $0.34 $0.13 $0.05 $0.20 $0.46 $0.13 $0.51 $0.43 $0.39 $0.59 $0.69     15.53% <-Total Growth 10 Cash Flow                            
Increase -7992% 121.43% -33.00% -61.83% -64.95% 331.24% 134.90% -72.51% 298.83% -15.45% -8.50% 50.01% 18.12% 1.45% <-IRR #YR-> 10 Cash Flow                            
Non-Cash CF -$2.4 -$10.9 -$1.6 -$2.8 $0.8 $0.9 $0.4 $9.8 -$0.9 $1.9 -$8.3 -$5.2 -$7.8 4.94% <-IRR #YR-> 5 Cash Flow                            
OPS non-cash $0.00 -$0.56 $0.19 -$0.03 $0.09 $0.25 $0.49 $0.63 $0.47 $0.50 $0.08 $0.39 $0.40 8.65% <-IRR #YR-> 9 CF - non cash                            
Increase -100% 641442% -133% -116% -398% 179.23% 94.04% 30.32% -25.17% 5.37% -84.25% 400.35% 1.46% -4.14% <-IRR #YR-> 5 CF - non cash                            
P/O on Cl -24184 -4.27 5.43 -8.31 3.69 11.20 12.99 9.65 6.45 2.71 18.34 9.42 10.39                                        
*Operational Cash Flow per share       P/CF 10 yr 7.93 5 yr  9.42                                
-$0.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.59                                        
-$0.46 $0.00 $0.00 $0.00 $0.00 $0.59                                
-$0.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.39                                
-$0.49 $0.00 $0.00 $0.00 $0.00 $0.39                                
                                                                   
OPM 3.65% 13.41% 8.71% 8.42% 2.60% 6.66% 8.09% 1.70% 8.77% 6.74% 10.64% 14.19%   should be zero, it is a check on calculations                                  
Diff from Ave -55.8% 62.4% 5.5% 2.0% -68.5% -19.3% -2.0% -79.4% 6.2% -18.4% 28.9% 71.9%       0.00 <-Median-> 10 OPM                            
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 8.26% 5 Yrs 8.77%                                          
                                                                   
Curr Assets $31.49 $16.19 $12.21 $9.74 $9.35 $26.10 $29.49 $47.22 $56.20 $54.49 $40.10 $52.39 $51.02     Liq ratio of 1.5 and up, best   Assets                            
Curr Liab. $22.64 $12.46 $9.15 $8.42 $4.44 $19.28 $21.39 $37.38 $23.23 $21.59 $13.27 $18.11 $20.09     1.74 <-Median-> 10 Liabilities                            
Liquidity 1.39 1.30 1.33 1.16 2.11 1.35 1.38 1.26 2.42 2.52 3.02 2.89 2.54     2.52 <-Median-> 5 Ratio                            
                                                                   
Assets $45.33 $30.22 $25.18 $19.72 $16.30 $35.19 $41.94 $82.29 $116.20 $100.59 $73.33 $82.86 $89.69     A/L ratio of 1.5 and up, best   Assets                            
Liab. $33.00 $24.21 $19.08 $11.99 $7.57 $23.94 $24.46 $52.13 $40.14 $32.44 $20.95 $26.03 $29.99     1.93 <-Median-> 10 Liabilities                            
Asset/Liability R. 1.37 1.25 1.32 1.64 2.15 1.47 1.71 1.58 2.90 3.10 3.50 3.18 2.99     3.10 <-Median-> 5 Ratio                            
                                                                   
Book Value $12.33 $6.01 $6.10 $7.73 $8.74 $11.25 $17.48 $30.16 $76.06 $68.15 $52.38 $56.82 $59.70     845.72% <-Total Growth 10 Book Value                            
BV per share $1.20 $0.59 $0.59 $0.44 $0.50 $0.64 $0.95 $1.56 $2.73 $2.57 $1.98 $2.15 $2.25 $2.25   266.52% <-Total Growth 10 Book Value                            
Change -14.77% -51.29% 1.46% -25.77% 12.98% 27.93% 49.81% 63.49% 74.84% -5.69% -23.14% 8.48% 5.06%     1.3033 Current/Historical   Book Value                            
P/BV (CL) 1.75 4.06 1.70 0.57 0.66 4.39 6.60 3.91 1.12 0.52 0.73 1.72 1.84 13.87% <-IRR #YR-> 10 Book Value                            
Change 23.20% 132.65% -58.17% -66.65% 16.83% 563.24% 50.19% -40.78% -71.40% -53.06% 38.78% 136.86% 6.50% 17.58% <-IRR #YR-> 5 Book Value per share                          
Leverage (A/BK) 3.68 5.03 4.13 2.55 1.87 3.13 2.40 2.73 1.53 1.48 1.40 1.46 1.50     2.13 <-Median-> 10 A/BV                            
Debt/Eq Ratio 2.68 4.03 3.13 1.55 0.87 2.13 1.40 1.73 0.53 0.48 0.40 0.46 0.50     1.13 <-Median-> 10 Debt/Eq Ratio                            
Median               P/BV 10 yr Ave 1.41 5 yr Ave 1.12                                          
                                                           
-$0.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.15                                          
            -$0.95 $0.00 $0.00 $0.00 $0.00 $2.15                                          
                                                                 
ROE               -1.7% 7.5% -4.2% -29.2% 7.4% 8.2%     -1.74% <-Median-> 5 Compreh. Inc                            
Comprehensive Inc               -$0.52 $5.74 -$2.86 -$15.31 $4.20 $4.87 <-12 mths         Compreh. Inc                            
                                                                 
ROE -16.1% -106.6% 1.4% -30.6% 11.5% 24.6% 36.1% 27.8% 11.4% -8.1% -25.1% 8.5% 10.5% <-12 mths   Net Income/Shareholders' equity                                  
5Yr Median       -16.1% -16.1% 1.4% 11.5% 24.6% 24.6% 24.6% 11.4% 8.5% 8.5% <-12 mths                                      
                                                                 
Net Income -$1.99 -$6.41 $0.09 -$2.36 $1.00 $2.77 $6.30 $8.38 $8.71 -$5.55 -$13.16 $4.86 $6.24 <-12 mths   -175.83% <-Total Growth 10 Net Income                            
Oper C. F. $2.36 $5.22 $3.50 $2.28 $0.80 $3.47 $8.46 $2.46 $14.12 $11.35 $10.38 $15.57 $18.39 <-12 mths     Cash Flow Statement CF from continuing operations                        
Invest. C. F -$2.14 -$0.32 -$0.75 -$0.42 $4.57 -$11.93 -$4.75 -$17.17 -$29.99 -$5.22 -$4.98 -$2.50 -$4.50       Cash Flow Statement                            
Total Accruals -$2.21 -$11.31 -$2.66 -$4.23 -$4.36 $11.22 $2.59 $23.10 $24.57 -$11.67 -$18.56 -$8.22 -$7.65                                        
Total Assets $45.33 $30.22 $25.18 $19.72 $16.30 $35.19 $41.94 $82.29 $116.20 $100.59 $73.33 $82.86 $89.69       Balance Sheet                                
Accruals Ratio -4.88% -37.43% -10.57% -21.43% -26.77% 31.88% 6.18% 28.07% 21.15% -11.61% -25.31% -9.92% -8.53%                                        
up/down/neutral                                                                  
Chge in Close 5.00% 13.33% -57.56% -75.25% 32.00% 748.48% 125.00% -3.17% -50.00% -55.74% 6.67% 156.94% 11.89%                                        
Any Predictions?                                                                  
                                                                   
Fin. C. F $2.78 -$4.90 -$3.72 -$1.43 -$6.28 $8.33 -$3.31 $15.51 $22.71 -$9.85 -$4.82 -$0.59 -$1.12                                        
Total Accruals -$5.00 -$6.41 $1.06 -$2.80 $1.91 $2.88 $5.90 $7.59 $1.86 -$1.83 -$13.74 -$7.63 -$6.53                                        
Accruals Ratio -11.02% -21.20% 4.22% -14.20% 11.73% 8.19% 14.07% 9.22% 1.60% -1.82% -18.74% -9.21% -7.29%                                        
                                                                   
May 22, 2011.  Did 2010 without receiving Annual Statement.  Earnings Estimates for 2010, 2011 and 2012 were $.22, $.39 and $.48.                                            
There is no change in estimates for 2011 and 2012.  However, there are not many analysts following this stock.                                                
Feb 12, 2010.  When I last looked for estimates, I got 2009 and 2010 earnings of R$.06 and $.21.                                                  
Dividend reduced in 2009 because of turndown in business for McCoy because of the current recession. They do not expect a turnaround before the end of 2009.                                        
When I last looked at this stock in Jan 2009, I got an earnings estimate of $.30 a share for 2008.  This was way off as earnings came in at -$.20 a share.                                        
2007 increase in shares issued for an acquisition and to pay down debt.                                                        
                                                                   
How they make their money.                                                              
McCoy provides innovative products and services to the global energy industry. McCoy's two segments, Energy Products & Services and Mobile Solutions, operate internationally through direct sales                                 
and distributors with its operations based out of the Western Canadian Sedimentary Basin and the US Gulf Coast. McCoy's corporate office is located in Edmonton, Alberta, Canada with offices in Alberta,                                
British Columbia, Louisiana, and Texas.                                                              
                                                                   
Also, considered to be a tech stock by CanTech letter as it provides technologies for the oil and gas sector.                                                
                                                                   
Ownership                                                                  
Foundation Equity Corp.   43.00%                                                            
Northern Plains Capital Ltd.   13.00%                                                            
Directors & Officers    3.00%                                                            
      59.00%                                                            
                                                                   
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.                                
Also, for the Operational Profit Margin, a higher percentage is better.  With the OPM, you should only compare companies in similar industries.                                          
                                                                   
Copyright © 2008 Website of SPBrunner. All rights reserved.