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 2017
Trican Well Service Ltd TSX: TCW OTC: TOLWF www.trican.ca Fiscal Yr: Dec 31
Stock FRC FRC FRC FRC FRC FRC FRC FRC FRC FRC FRC FRC TCW TCW TCW
Year 12/31/05 12/31/06 12/31/07 12/30/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 12/31/19 Value Description #Y Item
Accounting Rules C GAAP C GAAP C GAAP C GAAP C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
$479.4 <-12 mths 100.12%
Revenue* $27.2 $46.7 $48.1 $72.4 $46.9 $215.9 $372.1 $353.1 $299.8 $591.0 $404.0 $239.6 $911 $1,259 $1,488 413.34% <-Total Growth 10 Revenue
Increase 71.62% 3.00% 50.55% -35.15% 360.01% 72.35% -5.10% -15.10% 97.15% -31.64% -40.70% 280.27% 38.20% 18.19% 17.77% <-IRR #YR-> 10 Revenue 413.34%
5 year Running Average $48.2 $86.0 $151.1 $212.1 $257.6 $366.4 $404.0 $377.5 $489 $681 $860 -8.43% <-IRR #YR-> 5 Revenue -35.62%
Revenue per Share $0.95 $1.26 $1.28 $1.92 $0.59 $2.10 $3.59 $3.36 $2.82 $5.07 $3.44 $1.64 $2.63 $3.64 $4.30 34.16% <-IRR #YR-> 7 5 yr Running Average #DIV/0!
Increase 32.32% 1.55% 50.55% -69.55% 259.37% 70.58% -6.41% -16.03% 79.68% -32.16% -52.36% 60.63% 38.20% 18.19% 20.10% <-IRR #YR-> 5 5 yr Running Average 149.88%
5 year Running Average $1.20 $1.43 $1.90 $2.31 $2.49 $3.39 $3.65 $3.26 $3.12 $3.28 $3.13 2.68% <-IRR #YR-> 10 Revenue per Share 30.26%
P/S (Price/Sales) Med 4.56 1.79 0.88 1.71 1.95 2.00 2.09 2.34 1.59 1.08 1.86 1.65 -14.52% <-IRR #YR-> 5 Revenue per Share -54.36%
P/S (Price/Sales) High 6.78 2.65 1.53 2.51 3.22 2.61 2.61 2.66 2.32 1.53 2.59 2.09 2.60 <-Median-> 10 P/S HighPrice
P/S (Price/Sales) Low 2.34 0.92 0.23 0.90 0.67 1.39 1.58 2.01 0.86 0.63 1.12 1.22 0.91 <-Median-> 10 P/S Low Price
P/S (Price/Sales) Closing 2.32 1.04 0.02 2.36 3.03 1.96 1.99 2.51 1.04 0.70 2.53 1.65 1.20 15.39% <-IRR #YR-> 7 5 yr Running Average #DIV/0!
*Revenue in M CDN $ P/S Med 10 yr 1.82 5 yr 1.86 -9.20% Diff M/C 11.49% <-IRR #YR-> 5 5 yr Running Average 72.24%
-$46.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $239.6
-$372.1 $0.0 $0.0 $0.0 $0.0 $239.6
-$48.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $377.5
-$151.1 $0.0 $0.0 $0.0 $0.0 $377.5
-$1.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.64
-$3.59 $0.00 $0.00 $0.00 $0.00 $1.64
-$1.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.26
-$1.90 $0.00 $0.00 $0.00 $0.00 $3.26
-$0.10 <-12 mths 80.68%
EPS Basic $0.25 $0.06 -$0.24 -$0.05 -$0.25 $0.56 $0.92 $0.52 -$0.04 $0.44 -$0.53 -$0.52 -980.00% <-Total Growth 10 EPS Basic
EPS Diluted* $0.25 $0.06 -$0.24 -$0.05 -$0.25 $0.55 $0.90 $0.51 -$0.04 $0.44 -$0.53 -$0.52 -$0.08 $0.27 $0.43 -980.00% <-Total Growth 10 EPS Diluted
Increase -76.19% -500% -77.50% 366.67% -321% 64.52% -43.14% -108.05% -1157.14% -221.62% -2.22% -84.55% -437.50% 59.26% #NUM! <-IRR #YR-> 10 Earnings per Share -980.00%
Earnings Yield 2.0% -17.8% -118.4% -17.9% 8.6% 12.8% 7.7% -0.6% 8.2% -22.1% -12.5% -1.8% 6.2% 8.0% #NUM! <-IRR #YR-> 5 Earnings per Share -157.52%
5 year Running Average -$0.05 $0.01 $0.18 $0.33 $0.33 $0.47 $0.26 -$0.03 -$0.15 -$0.08 -$0.09 -6.70% <-IRR #YR-> 7 5 yr Running Average 38.46%
10 year Running Average $0.21 $0.13 $0.08 $0.09 $0.12 $0.19 #NUM! <-IRR #YR-> 5 5 yr Running Average -115.48%
* Diluted ESP per share E/P 10 Yrs -6.55% 5Yrs -0.58%
-$0.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.52
-$0.90 $0.00 $0.00 $0.00 $0.00 -$0.52
$0.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.03
-$0.18 $0.00 $0.00 $0.00 $0.00 -$0.03
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 6 Special Dividends
Canyon to Trican 2017 $0.10 $0.51 $0.60 $0.60 $0.41 $0.03 $0.00 $0.00 $0.00
Dividend* $0.06 $0.30 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 -94.15% <-Total Growth 5 Dividends
Increase 156.25% 17.07% 0.00% -32.50% -92.59% -100.00% #DIV/0! #DIV/0! Count 6 Years of data
Dividends 5 Yr Running $0.26 $0.25 $0.19 $0.12 $0.05 #DIV/0! <-Total Growth 1 Dividends 5 Yr Running
Yield H/L Price 0.82% 4.29% 5.36% 4.38% 6.41% 0.58% 0.00% 4.33% <-Median-> 6 Yield H/L Price
Yield on High Price 0.63% 3.44% 4.71% 3.00% 4.52% 0.42% 0.00% 3.22% <-Median-> 6 Yield on High Price
Yield on Low Price 1.18% 5.69% 6.21% 8.09% 11.04% 0.96% 0.00% 5.95% <-Median-> 6 Yield on Low Price
Yield on Close Price 0.84% 4.52% 4.99% 6.67% 9.95% 0.43% 0.00% 0.00% 0.00% 4.75% <-Median-> 6 Yield on Close Price
Payout Ratio EPS 6.5% 58.9% -857.1% 81.1% -45.0% -3.4% 0.0% 0.0% 0.0% 1.56% <-Median-> 6 DPR EPS
DPR EPS 5 Yr Running 102.19% -894.79% -131.22% -144.35% -59.92% -396.30% <-Median-> 2 DPR EPS 5 Yr Running
Payout Ratio CFPS 5.6% 36.1% 72.9% 50.3% 213.7% -64.0% 0.0% 0.0% 0.0% 43.18% <-Median-> 6 DPR CF
DPR CF 5 Yr Running 40.99% 59.99% 57.61% 33.72% 14.84% 50.49% <-Median-> 2 DPR CF 5 Yr Running
Payout Ratio CFPS WC 3.8% 30.1% 114.8% 34.5% 97.9% -10.4% 0.0% 0.0% 0.0% 32.29% <-Median-> 6 DPR CF WC
DPR CF WC 5 Yr Running 31.59% 52.49% 53.33% 42.04% <-Median-> 2 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 4.38% 4.99% 5 Yr Med Payout -3.41% 50.31% 34.54% -38.46% <-IRR #YR-> 5 Dividends #DIV/0!
* Dividends per share 5 Yr Med and Cur. -100.00% -100.00% Last Div Inc ---> $0.15 $0.03 -80.0% -38.46% <-IRR #YR-> 5 Dividends -70.00%
-$0.20 $0.00 $0.00 $0.00 $0.00 $0.02
-$0.20 $0.00 $0.00 $0.00 $0.00 $0.02
Historical Dividends Historical High Div 9.86% Low Div 0.50% Ave Div 5.18% Med Div 4.33% Close Div 4.75% Historical Dividends
High/Ave/Median Values Curr diff Exp. -100.00% Exp -100.00% Exp. -100.00% Exp. -100.00% Exp. -100.00% High/Ave/Median
Future Dividend Yield Div Yd 0.00% earning in 5 Years at IRR of 0.00% Div Inc. #DIV/0! Future Dividend Yield
Future Dividend Yield Div Yd 0.00% earning in 10 Years at IRR of 0.00% Div Inc. #DIV/0! Future Dividend Yield
Future Dividend Yield Div Yd 0.00% earning in 15 Years at IRR of 0.00% Div Inc. #DIV/0! Future Dividend Yield
Cost cover if held 5 years 1.03% 15.81% 42.17% 106.62% 31.86% 17.64% 13.68% 9.24% 3.17% 24.75% <-Median-> 6 Paid Median Price
Cost cover if held 10 years 23.05% 58.00% 78.17% 132.21% 23.05% <-Median-> 1 Paid Median Price
Cost cover if held 15 years #DIV/0! #DIV/0! #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost cover if held 20 years #DIV/0! #DIV/0! #DIV/0! #NUM! <-Median-> 0 Paid Median Price
H/LYield held 5 yrs 1.03% 13.23% 20.87% 35.29% 5.82% 0.25% 0.00% 0.00% 0.00% 9.52% <-Median-> 6 Paid Median Price
H/LYield held 10 yrs 0.31% 0.00% 0.00% 0.00% 0.31% <-Median-> 1 Paid Median Price
H/LYield held 15 yrs #DIV/0! #DIV/0! #DIV/0! #NUM! <-Median-> 0 Paid Median Price
H/LYield held 20 yrs #DIV/0! #DIV/0! #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham Number $2.80 $1.84 $1.76 $1.75 $1.43 $5.17 $7.83 $6.08 $5.71 $5.94 $5.38 $4.80 $4.45 $4.45 $5.62 160.71% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.00 3.11 1.29 0.96 0.70 0.79 0.91 1.16 1.15 1.36 0.69 0.63 0.98 0.94 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Hi 0.00 4.63 1.92 1.68 1.03 1.31 1.19 1.44 1.31 1.98 0.98 0.88 1.23 1.31 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.00 1.60 0.67 0.25 0.37 0.27 0.63 0.87 0.99 0.73 0.40 0.38 0.72 0.52 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Cl 0.00 1.58 0.75 0.03 0.96 1.24 0.90 1.10 1.24 0.89 0.45 0.86 0.98 0.98 0.95 0.89 <-Median-> 10 Price/GP Ratio
Prem/Disc CL -100.00% 58.10% -24.87% -97.45% -3.57% 23.52% -10.24% 9.77% 23.75% -11.01% -55.48% -13.88% -2.31% -2.31% -4.79% -10.63% <-Median-> 10 Graham Price
Canyon to Trican 2017 $4.95 $2.25 $0.08 $2.35 $10.85 $11.95 $11.35 $12.02 $8.99 $4.07 $7.03
Price Close $2.91 $1.32 $0.04 $1.38 $6.38 $7.03 $6.68 $7.07 $5.29 $2.39 $4.14 $4.35 $4.35 $5.35 212.44% <-Total Growth 10 Stock Price
Increase -54.55% -96.62% 2992.11% 361.70% 10.14% -5.02% 5.90% -25.21% -54.73% 72.73% 5.19% 0.00% 22.99% 3.57% <-IRR #YR-> 10 Stock Price 42.02%
P/E 49.50 -5.63 -0.84 -5.60 11.67 7.81 13.05 -171.71 12.15 -4.52 -7.99 -54.38 16.11 12.44 -10.07% <-IRR #YR-> 5 Stock Price -41.17%
Trailing P/E 11.79 22.50 -0.19 -26.11 -25.83 12.85 7.42 13.82 -128.43 5.50 -7.81 -8.40 -54.38 19.81 6.99% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 3.42% 4.30% % Tot Ret 48.91% 0.00% T P/E 5.50 P/E: -2.68 -4.52 -5.76% <-IRR #YR-> 5 Price & Dividend
-$2.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.14
-$7.03 $0.00 $0.00 $0.00 $0.00 $4.14
-$2.91 $0.00 $0.00 $0.00 $0.00 $0.06 $0.30 $0.35 $0.35 $0.24 $4.15
-$7.03 $0.30 $0.35 $0.35 $0.24 $4.15
Price H/L Median $5.74 $2.28 $1.69 $1.00 $4.09 $7.16 $7.03 $6.59 $8.06 $3.71 $3.04 $4.35 22.99% 33.42% <-Total Growth 10 Stock Price
Increase -60.26% -25.81% -40.87% 309.41% 74.93% -1.81% -6.32% 22.41% -53.94% -18.13% 43.04% 0.00% -6.15% <-IRR #YR-> 10 Stock Price -46.97%
P/E 97.50 -9.69 -31.94 -4.05 7.48 7.96 13.74 -160.00 18.53 -7.02 -5.88 -54.38 -15.74% <-IRR #YR-> 5 Stock Price -57.54%
Trailing P/E 23.21 38.75 -7.19 -18.89 -16.57 13.09 7.81 12.87 -195.86 8.53 -5.74 -8.40 -2.92% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave -21.79 290.00 39.27 21.20 19.72 17.14 14.55 -107.71 -29.67 -11.05% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 37.98 27.58 39.47 46.98 -4.05 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr -401.84% 11.05% % Tot Ret 0.00% 0.00% T P/E 37.98 P/E: -4.96 -5.88
-$5.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.04
-$7.16 $0.00 $0.00 $0.00 $0.00 $3.04
-$5.74 $0.00 $0.00 $0.00 $0.00 $0.06 $0.30 $0.35 $0.35 $0.24 $3.06
-$7.16 $0.30 $0.35 $0.35 $0.24 $3.06
High Months May May May Dec Dec July Mar Aug Jul Apr Dec Feb
Canyon to Trican 2017 $14.50 $5.75 $5.00 $2.50 $11.52 $15.90 $14.91 $12.74 $20.00 $8.96 $7.21
Price High $8.53 $3.38 $2.94 $1.47 $6.78 $9.35 $8.77 $7.49 $11.76 $5.27 $4.24 $5.49 25.39% <-Total Growth 10 Stock Price
Increase -60.34% -13.04% -50.00% 360.80% 38.02% -6.23% -14.55% 56.99% -55.20% -19.53% 29.45% -6.75% <-IRR #YR-> 10 Stock Price -50.28%
P/E 145.00 -14.38 -55.56 -5.95 12.39 10.39 17.14 -182.00 27.03 -9.96 -8.19 -68.63 -14.63% <-IRR #YR-> 5 Stock Price -54.65%
Trailing P/E 34.52 57.50 -12.50 -27.78 -27.43 17.10 9.75 14.64 -285.71 12.11 -8.01 -10.61 -5.95 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -14.55% P/E: -7.07 -8.19 23.07 P/E Ratio Historical High
-$8.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.24
-$9.35 $0.00 $0.00 $0.00 $0.00 $4.24
Low Months Dec Nov Dec Jan Jan Oct Jul Apr Dec Dec Jan Jun
Price Low $2.94 $1.18 $0.44 $0.53 $1.41 $4.97 $5.29 $5.68 $4.36 $2.16 $1.84 $3.21 56.50% <-Total Growth 10 Stock Price
Increase -60.00% -62.50% 20.00% 166.67% 252.08% 6.51% 7.33% -23.19% -50.54% -14.71% 74.35% -4.58% <-IRR #YR-> 10 Stock Price -37.40%
P/E 50.00 -5.00 -8.33 -2.14 2.58 5.52 10.34 -138.00 10.03 -4.08 -3.56 -40.13 -18.01% <-IRR #YR-> 5 Stock Price -62.96%
Trailing P/E 11.90 20.00 -1.88 -10.00 -5.71 9.09 5.88 11.10 -106.00 4.96 -3.48 -6.20 -2.14 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -14.71% P/E: -2.85 -3.56 -7.00 P/E Ratio Historical Low
-$2.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.84
Long Term Debt $30.00 $60.00 $25.00 $148.64 Debt
Change 100.00% -58.33% 494.56% 20.83% <-Median-> 2 Change
Debt/Market Cap Ratio 0.05 0.21 0.04 0.10 0.05 <-Median-> 3 % of Market C.
Goodwill & Intangibles $0.32 $0.18 $91.10 $56.67 $50.65 $329.41 Intangibles Goodwill
Change -44.34% 51366.10% -37.79% -10.63% 550.37% -24.21% <-Median-> 4 Change
Intangible/Market Cap Ratio 0.00 0.00 0.15 0.20 0.08 0.22 0.08 <-Median-> 5 % of Market C.
Market Cap $108.1 $49.8 $1.7 $110.8 $655.0 $728.9 $702.0 $751.6 $616.7 $281.3 $604.9 $1,506.5 $1,506.5 $1,852.8 1113.87% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 43.578 98.928 0.000 0.000 105.966 113.162 117.099 139.407 218.070 219.90% <-Total Growth 7 Diluted
Change 127.01% -100.00% #DIV/0! #DIV/0! 6.79% 3.48% 19.05% 56.43% #DIV/0! <-Median-> 5 Change
Basic # of Shares in Millions 24.684 34.289 37.332 37.961 43.578 96.249 103.156 103.921 105.966 111.688 117.099 139.407 218.070 306.56% <-Total Growth 10 Basic
Change 108.62% 38.91% 8.87% 1.68% 14.80% 120.87% 7.18% 0.74% 1.97% 5.40% 4.84% 19.05% 56.43% 6.29% <-Median-> 10 Change
Difference 15.9% 8.3% 0.9% -0.8% 84.0% 6.6% 0.5% 1.2% 0.3% 4.4% 0.4% 4.9% 58.8% 1.01% <-Median-> 10 Difference
-$25.64 <-12 mths -535.32%
# of Share in Millions 28.620 37.120 37.653 37.653 80.175 102.627 103.692 105.138 106.298 116.627 117.511 146.283 346.312 346.312 346.312 14.70% <-IRR #YR-> 10 Shares 294.08% 193.5678 TCW 55.93%
Change 20.00% 29.70% 1.43% 0.00% 112.94% 28.00% 1.04% 1.40% 1.10% 9.72% 0.76% 24.48% 136.74% 0.00% 0.00% 7.12% <-IRR #YR-> 5 Shares 41.08% 152.5496 FRC 44.07%
CF fr Op $Millon $4.4 $7.8 $1.0 $10.4 -$1.1 $60.0 $108.8 $87.9 $51.5 $81.8 $13.1 -$4.0 $138.5 $214.7 $214.7 -151.46% <-Total Growth 10 Cash Flow 346.1174 Total
Increase 78.71% -86.84% 908.18% -110.74% -5475% 81.15% -19.16% -41.48% 59.03% -83.99% -130.80% -3533.08% 55.00% 0.00% SO S. Issues
5 year Running Average $4.5 $15.6 $35.8 $53.2 $61.4 $81.8 $81.8 $81.8 $56.2 $88.8 $115.4 423.22% <-Total Growth 7 CF 5 Yr Running
CFPS $0.15 $0.21 $0.03 $0.28 -$0.01 $0.58 $1.05 $0.84 $0.48 $0.70 $0.11 -$0.03 $0.40 $0.62 $0.62 -113.06% <-Total Growth 10 Cash Flow per Share
Increase 37.79% -87.03% 908.18% -105.04% -4299% 79.29% -20.28% -42.11% 44.95% -84.11% -124.74% -1550.14% 55.00% 0.00% #NUM! <-IRR #YR-> 10 Cash Flow -151.46%
5 year Running Average $0.13 $0.22 $0.38 $0.55 $0.59 $0.73 $0.64 $0.42 $0.33 $0.36 $0.34 #NUM! <-IRR #YR-> 5 Cash Flow -103.71%
P/CF on Med Price 27.15 83.18 6.12 -71.78 7.00 6.83 8.41 13.61 11.50 33.32 -110.25 10.88 0.37 0.00 #NUM! <-IRR #YR-> 10 Cash Flow per Share -113.06%
P/CF on High Price 40.38 123.43 10.65 -105.56 11.58 8.92 10.49 15.48 16.77 47.27 -153.76 13.73 78.14% Diff M/C #NUM! <-IRR #YR-> 5 Cash Flow per Share -102.63%
11.67% <-IRR #YR-> 6 CFPS 5 yr Running 93.90%
Excl.Working Capital CF $6.2 $3.1 -$1.3 -$2.2 $0.7 $15.4 $52.3 $17.6 -$18.8 $37.4 $15.5 -$20.8 $0.0 $0.0 $0.0 1.83% <-IRR #YR-> 5 CFPS 5 yr Running 9.47%
CF fr Op $M WC $10.6 $10.9 -$0.2 $8.2 -$0.4 $75.4 $161.0 $105.5 $32.7 $119.2 $28.6 -$24.8 $138.5 $214.7 $214.7 -326.70% <-Total Growth 10 Cash Flow less WC
Increase 3.44% -102% -3697% -104.73% -19498% 113.55% -34.49% -69.03% 264.86% -76.00% -186.65% -658.82% 55.00% 0.00% #NUM! <-IRR #YR-> 10 Cash Flow less WC -326.70%
5 year Running Average $5.8 $18.8 $48.8 $69.9 $74.8 $98.7 $89.4 $52.2 $58.8 $95.2 $114.4 #NUM! <-IRR #YR-> 5 Cash Flow less WC -115.40%
CFPS Excl. WC $0.37 $0.29 -$0.01 $0.22 $0.00 $0.73 $1.55 $1.00 $0.31 $1.02 $0.24 -$0.17 $0.40 $0.62 $0.62 18.58% <-IRR #YR-> 6 CF less WC 5 Yr Run 178.03%
Increase -20.24% -102% -3697% -102.22% -15255% 111.36% -35.39% -69.37% 232.55% -76.18% -169.61% -336.05% 55.00% 0.00% 1.37% <-IRR #YR-> 5 CF less WC 5 Yr Run 7.03%
5 year Running Average $0.17 $0.25 $0.50 $0.70 $0.72 $0.92 $0.83 $0.48 $0.36 $0.42 $0.34 39.51% <-IRR #YR-> 10 CFPS - Less WC -157.53%
P/CF on Med Price 19.47 -375.68 7.75 -206.28 5.57 4.61 7.01 21.44 7.89 15.26 -17.95 10.88 0.37 0.00 #NUM! <-IRR #YR-> 5 CFPS - Less WC -110.91%
P/CF on High Price 28.96 -557.47 13.48 -303.36 9.22 6.02 8.74 24.39 11.51 21.65 -25.03 13.73 0.00 0.00 8.98 <-Median-> 10 P/CF on High
P/CF on Low Price 9.98 -193.90 2.02 -109.21 1.92 3.20 5.28 18.49 4.27 8.87 -10.87 8.03 0.00 0.00 2.61 <-Median-> 10 P/CF on Low
P/CF on Closing Price 9.88 -218.14 0.20 -285.16 8.69 4.53 6.66 23.01 5.17 9.83 -24.40 10.88 7.02 8.63 11.74% <-IRR #YR-> 6 CFPS 5 yr Running 94.62%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 7.70 5 yr 11.50 P/CF Med 10 yr 6.29 5 yr 7.89 118.16% Diff M/C -0.72% <-IRR #YR-> 5 CFPS 5 yr Running -3.54%
-$0.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.03 Cash Flow per Share
-$1.05 $0.00 $0.00 $0.00 $0.00 -$0.03 Cash Flow per Share
-$0.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.42 CFPS 5 yr Running
-$0.38 $0.00 $0.00 $0.00 $0.00 $0.42 CFPS 5 yr Running
-$10.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$24.8 Cash Flow less WC
-$161.0 $0.0 $0.0 $0.0 $0.0 -$24.8 Cash Flow less WC
-$18.8 $0.0 $0.0 $0.0 $0.0 $0.0 $52.2 CF less WC 5 Yr Run
-$48.8 $0.0 $0.0 $0.0 $0.0 $52.2 CF less WC 5 Yr Run
$0.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.17 CFPS - Less WC
-$1.55 $0.00 $0.00 $0.00 $0.00 -$0.17 CFPS - Less WC
-$0.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.48 CFPS 5 yr Running
-$0.50 $0.00 $0.00 $0.00 $0.00 $0.48 CFPS 5 yr Running
OPM 16.14% 16.80% 2.15% 14.37% -2.38% 27.81% 29.23% 24.90% 17.16% 13.84% 3.24% -1.68% -110.02% <-Total Growth 10 OPM
Increase 4.13% -87.23% 569.64% -116.56% -1268% 5.11% -14.82% -31.06% -19.33% -76.57% -151.93% Should increase or be stable.
Diff from Median 14.4% 19.1% -84.8% 1.9% -116.9% 97.1% 107.2% 76.5% 21.6% -1.9% -77.0% -111.9% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 14.11% 5 Yrs 13.84% should be zero, it is a check on calculations
Current Assets $16.10 $15.95 $17.61 $18.10 $25.63 $97.45 $149.25 $106.08 $119.05 $169.86 $91.02 $82.31 $292.88 Liquidity ratio of 1.5 and up, best
Current Liabilities $10.93 $6.80 $13.06 $13.55 $8.18 $47.09 $82.24 $49.83 $77.32 $147.98 $63.44 $54.04 $162.70 1.53 <-Median-> 10 Ratio
Liquidity 1.47 2.34 1.35 1.34 3.13 2.07 1.81 2.13 1.54 1.15 1.43 1.52 1.80 1.52 <-Median-> 5 Ratio
Liq. with CF aft div 2.44 3.95 1.33 1.94 3.08 3.67 3.70 3.61 1.48 1.68 1.44 1.45 2.65 1.48 <-Median-> 5 Ratio CF less WC
Liq. CF re Inv+Div 0.51 0.34 0.69 1.61 1.06 1.28 1.37 1.28 1.44 0.93 1.17 1.17 2.65 1.17 <-Median-> 5 Ratio CF less WC
Assets $62.73 $117.74 $123.25 $118.10 $133.06 $271.31 $407.33 $406.11 $402.71 $638.77 $510.09 $458.03 $1,523.64 Debt Ratio of 1.5 and up, best
Liabilities $22.24 $22.61 $34.69 $30.40 $8.30 $48.52 $93.26 $68.34 $101.32 $218.24 $163.15 $113.68 $393.33 4.00 <-Median-> 10 Ratio
Debt Ratio 2.82 5.21 3.55 3.88 16.03 5.59 4.37 5.94 3.97 2.93 3.13 4.03 3.87 3.97 <-Median-> 5 Ratio
Total Book Val;ue $40.49 $95.14 $88.55 $87.69 $124.76 $222.79 $314.07 $337.78 $301.39 $420.53 $346.94 $344.35 $1,130.31 $1,130.31 $1,130.31 261.96% <-Total Growth 10 Book Value
Warrents $0.26 $0.26 $0.29 $0.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Book Value $40.49 $95.14 $88.30 $87.44 $124.47 $222.59 $314.07 $337.78 $301.39 $420.53 $346.94 $344.35 $1,130.31 $1,130.31 $1,130.31 261.96% <-Total Growth 10 Book Value
Book Value per share $1.41 $2.56 $2.35 $2.32 $1.55 $2.17 $3.03 $3.21 $2.84 $3.61 $2.95 $2.35 $3.26 $3.26 $3.26 -8.15% <-Total Growth 10 Book Value per Share
Change 81.15% -8.50% -0.97% -33.14% 39.71% 39.65% 6.07% -11.75% 27.17% -18.12% -20.27% 38.65% 0.00% 0.00% -29.39% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.24 0.97 0.73 0.64 1.89 2.36 2.19 2.32 2.24 1.26 1.29 1.33 1.89 P/B Ratio Historical Median
P/B Ratio (Close) 1.14 0.56 0.02 0.89 2.94 2.32 2.08 2.49 1.47 0.81 1.76 1.33 1.33 1.64 -0.85% <-IRR #YR-> 10 Book Value -8.15%
Change #DIV/0! -50.32% -96.59% 4525.03% 230.48% -21.13% -10.46% 20.00% -41.19% -44.71% 116.63% -24.13% -4.92% <-IRR #YR-> 5 Book Value -22.28%
Leverage (A/BK) 1.55 1.24 1.39 1.35 1.07 1.22 1.30 1.20 1.34 1.52 1.47 1.33 1.35 1.33 <-Median-> 10 A/BV
Debt/Equity Ratio 0.55 0.24 0.39 0.35 0.07 0.22 0.30 0.20 0.34 0.52 0.47 0.33 0.35 0.33 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.59 5 yr Med 2.19 -16.16% Diff M/C 1.33 Historical A/BV
-$2.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.35
-$3.03 $0.00 $0.00 $0.00 $0.00 $2.35
$98.14 <-12 mths 235.94%
Comprehensive Income $2.02 -$8.76 -$2.03 -$11.06 $54.35 $95.27 $54.41 -$4.38 $49.09 -$62.06 -$72.20 -3669.46% <-Total Growth 10 Comprehensive Income
Increase -532.93% 76.83% -445.09% 591.47% 75.28% -42.89% -108.04% 1222.15% -226.42% -16.33% -42.89% <-Median-> 5 Comprehensive Income
5 Yr Running Average $6.91 $25.56 $38.19 $37.72 $49.75 $26.47 -$7.03 #NUM! <-IRR #YR-> 10 Comprehensive Income -3669.46%
ROE -8.9% 24.4% 30.3% 16.1% -1.5% 11.7% -17.9% -21.0% #NUM! <-IRR #YR-> 5 Comprehensive Income -175.78%
5Yr Median 20.3% 16.1% 16.1% 11.7% -1.5% #NUM! <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% #NUM! <-IRR #YR-> 5 5 Yr Running Average -127.50%
Median Values Diff 5, 10 yr 0.0% 0.0% -1.5% <-Median-> 5 Return on Equity
-$2.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$72.2
-$95.3 $0.0 $0.0 $0.0 $0.0 -$72.2
\ \ -$6.9 $0.0 $0.0 $0.0 $0.0 $0.0 -$7.0
-$25.6 $0.0 $0.0 $0.0 $0.0 -$7.0
Current Liability Coverage Ratio 0.97 1.61 -0.02 0.61 -0.05 1.60 1.96 2.12 0.42 0.81 0.45 -0.46 0.85 CFO / Current Liabilities
5 year Median 0.61 0.61 0.61 1.60 1.60 1.60 0.81 0.45 0.45 0.63 <-Median-> 4 Current Liability Cov Ratio
Asset Efficiency Ratio 16.85% 9.29% -0.19% 6.96% -0.29% 27.79% 39.53% 25.97% 8.11% 18.66% 5.61% -5.41% 9.09% CFO / Total Assets
5 year Median 6.96% 6.96% 6.96% 25.97% 25.97% 25.97% 18.66% 8.11% 8.11% 13.4% <-Median-> 4 Return on Assets
Return on Assets ROA 10.4% 1.7% -7.1% -1.7% -8.3% 20.0% 23.4% 13.4% -1.1% 7.7% -12.2% -15.8% -0.7% Net Income/Assets Return on Assets
5Yr Median -1.7% -1.7% 13.4% 13.4% 13.4% 7.7% -1.1% -1.1% -1.4% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 16.1% 2.1% -9.9% -2.3% -8.9% 24.4% 30.3% 16.1% -1.5% 11.7% -17.9% -21.0% -1.0% Net Inc/ Shareholders' equity Return on Equity
5Yr Median -2.3% -2.3% -2.3% 16.1% 16.1% 16.1% 11.7% -1.5% -1.5% -1.9% <-Median-> 10 Return on Equity
$30.49 <-12 mths 142.23%
Net Income $6.53 $2.02 -$8.76 -$2.03 -$11.06 $54.35 $95.27 $54.41 -$4.38 $49.09 -$62.06 -$72.20 -$10.90 $5.65 -3669.46% <-Total Growth 10 Net Income
Increase -69.01% -532.93% 76.83% -445.09% 591.47% 75.28% -42.89% -108.04% 1222.15% -226.42% -16.33% 84.90% 151.83% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average -$2.7 $6.9 $25.6 $38.2 $37.7 $49.8 $26.5 -$7.0 -$20.1 -$18.1 #NUM! <-IRR #YR-> 10 Net Income -3669.46%
Operating Cash Flow $4.39 $7.84 $1.03 $10.40 -$1.12 $60.03 $108.75 $87.91 $51.45 $81.82 $13.10 -$4.04 #NUM! <-IRR #YR-> 5 Net Income -175.78%
Investment Cash Flow -$28.94 -$63.86 -$13.90 -$4.12 -$14.97 -$76.41 -$101.03 -$76.93 -$14.82 -$78.69 -$14.88 -$13.93 14.89% <-IRR #YR-> 7 5 Yr Running Ave. -201.75%
Total Accruals $31.08 $58.04 $4.11 -$8.31 $5.02 $70.73 $87.55 $43.43 -$41.01 $45.97 -$60.29 -$54.23 #NUM! <-IRR #YR-> 5 5 Yr Running Ave. -127.50%
Total Assets $62.73 $117.74 $123.25 $118.10 $133.06 $271.31 $407.33 $406.11 $402.71 $638.77 $510.09 $458.03 Balance Sheet Assets
Accruals Ratio 49.54% 49.29% 3.33% -7.04% 3.77% 26.07% 21.49% 10.69% -10.18% 7.20% -11.82% -11.84% -10.18% <-Median-> 5 Ratio
EPS/CF Ratio 0.67 0.20 38.78 -0.24 50.96 0.74 0.58 0.51 -0.13 0.43 -2.17 3.05 0.54 <-Median-> 10 EPS/CF Ratio
-$2.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$72.2
-$95.3 $0.0 $0.0 $0.0 $0.0 -$72.2
$2.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$7.0
-$25.6 $0.0 $0.0 $0.0 $0.0 -$7.0
Change in Close -54.55% -96.62% 2992.11% 361.70% 10.14% -5.02% 5.90% -25.21% -54.73% 72.73% 5.19% 0.00% 22.99% Count 11 Years of data
up/down down up down down down up down up up Count 9 81.82%
Meet Prediction? Yes yes yes Yes Yes % right Count 5 55.56%
Financial Cash Flow $22.79 $55.83 $10.37 -$4.15 $26.34 $44.90 -$6.49 -$30.88 -$37.91 -$3.82 -$15.78 $17.38 C F Statement Financial Cash Flow
Total Accruals $8.29 $2.21 -$6.26 -$4.16 -$21.31 $25.83 $94.04 $74.31 -$3.10 $49.79 -$44.51 -$71.61 Accruals
Accruals Ratio 13.21% 1.88% -5.08% -3.52% -16.02% 9.52% 23.09% 18.30% -0.77% 7.79% -8.73% -15.63% -0.77% <-Median-> 5 Ratio
Cash $3.57 $2.83 $0.34 $2.47 $12.72 $41.25 $42.48 $22.58 $21.31 $20.63 $3.06 $2.47 $21.55 Cash
Cash Per share $0.12 $0.08 $0.01 $0.07 $0.16 $0.40 $0.41 $0.21 $0.20 $0.18 $0.03 $0.02 $0.06 $0.18 <-Median-> 5 Cash per Share
Percentage of Stock Price 2.62% 0.68% 146.73% 11.48% 6.30% 5.83% 3.22% 2.84% 3.35% 1.09% 0.41% 1.43% 2.84% <-Median-> 5 % of Stock Price
Notes:
Trican stopped paying a dividend in 2014.
May 31, 2017. Trican Well Service Ltd. has a plan of arrangement with Canyon Services Group for Canyon Shareholders to receive 1.7 shares of Trican for each share of Caynyon.
Canyon Services Group was TSX-FRC, OTC-CYSVF and site www.canyontech.ca. Trican Well Services TSX-TCW
September 24, 2016. Last estimates was for 2015, 2016 and 2017 of $404M, $468M and $653M for Revenue, -$0.49, -$0.06 and $0.56 for EPS, $0.31, $0.76 and $1.67 for CFPS and -$32.20m $4.13 and $52.30 for Net Income.
September 27, 2015. Last estimates were for 2014 and 2015 of $539M and 720M for Revenue, $0.63 and $1.44 and $1.80 for EPS for 2014 to 2016, $1.41 and $2.43 for CFPS and $43M, $108M and $113.58M for Net Income for 2014 to 2016.
September 20, 2014. Last Estimates were for 2013 and 2014 of $302.3M and $445.7M for Revenue, $0.19 and $1.04 for EPS, $0.81 and $1.68 for CFPS
Sept 22, 2013. Last estimates were for 2012 and 2013 of $435.6 and $528.8M for Revenue and $1.45 and $1.72 for EPS.
In May 2006 Canyon enters the public markets through a $55million initial public offering on the Toronto Stock Exchange, and begins trading under the symbol "FRC".
Canyon is founded in spring 2004 in Red Deer, Alberta with the purpose of providing specialized nitrogen-based fracturing services delivered via coiled tubing for completing
natural-gas-in-coal (NGC) wells, a highly active sector in Alberta at the time.
Sector:
Services, Industrial
What should this stock accomplish?
Would I buy this company and Why.
I would look at this company if I was wanting an Oil and Gas Servicing company. I expect that they will pay dividends again.
Why am I following this stock.
I was following Canyon Services Group Inc. and Trican Well Services Ltd. had a plan of arrangement with Canyon Shareholders.
I get a newsletter weekly from MPL Communications called Advice Hotline. They wrote up this stock on July 19, 2012 and I was impressed with it so I did a spreadsheet.
You can sign up for this newsletter at their <a href="http://www.adviceforinvestors.com/" target="_top" >site</a>.
Dividends
Dividends are paid quarterly in Cycle 1, that is January, April, July and October. Dividends are declared in one month for sharehdolders of record of the next month and paid in that month.
For example, a quarterly dividend was declared on June 26, 2014, for Shareholders of record of July 11, 2014 and was paid on July 25, 2014.
How they make their money.
Trican Well Service Ltd. is a Canada-based oilfield services company. The Company provides an array of specialized products, equipment, services and technology for use in the drilling,
completion, stimulation and reworking of oil and gas wells in Canada, the United States, Kazakhstan, Russia and Norway, as well as limited operations in Saudi Arabia and Colombia.
How they make their money.
Canyon Services Group Inc. is a fast-growing company providing hydraulic fracturing and other well-stimulation services, including coiled tubing, acidizing, cementing, nitrogen
and carbon dioxide, to oil and natural gas producers developing a variety of play types across Western Canada.
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield (dividends and erarnings) 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
Date Sep 21 2017
Dusterhoft, Dale M. 0.498 5.37%
CEO - Shares - Amount $2.061
Options - percentage 1.892 0.55%
Options - amount $7.826
Baldwin, Michael 0.060 0.02%
CFO - Shares - Amount $0.248
Options - percentage 0.950 0.27%
Options - amount $3.930
Cox, Robert John 0.029 0.01%
Officer - Shares - Amount $0.121
Options - percentage 0.799 0.23%
Options - amount $3.304
Bagan, Kenneth Michael 0.024 0.01%
Director - Shares - Amount $0.099
Options - percentage 0.259 0.07%
Options - amount $1.069
Brooks, Gilbert. Allen 0.051 0.01%
Director - Shares - Amount $0.211
Options - percentage 0.234 0.07%
Options - amount $0.968
Cobbe, Murray Lynn 0.869 0.25%
Chairman - Shares - Amt $3.595
Options - percentage 0.288 0.08%
Options - amount $1.192
Increase in O/S Shares 0.195 0.13%
due to SO $0.466
Book Value $0.284
Insider Buying -$0.044
Insider Selling $0.930
Net Insider Selling $0.886
% of Market Cap 0.06%
Directors 8
Women 1 13%
Minorities 1 13%
Institutions/Holdings 67 34.86%
Total Shares Held 120.730 34.86%
Increase/Decrease 3 Mths 35.413 41.51%
Starting No. of Shares 85.317
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Aug 7 2012 Sep 22 2013 Sep 20 2014 Sep 27 2015 Sep 24 2016
Fedora, Bradley P. D. 0.397 0.38% 0.822 0.77% 0.822 0.70% 0.822 0.70% 0.822 0.56%
CEO - Shares - Amount $2.652 $5.813 $4.348 $1.968 $3.400
Options - percentage 0.856 0.81% 0.560 0.48% 0.587 0.50% 0.460 0.31%
Options - amount $6.053 $2.963 $1.405 $1.902
O'Brien, Finbarr (Barry) Joseph 0.085 0.08% 0.105 0.09% 0.105 0.09% 0.105 0.07%
CFO - Shares - Amount $0.601 $0.555 $0.251 $0.434
Options - percentage 0.294 0.28% 0.294 0.25% 0.345 0.29% 0.261 0.18%
Options - amount $2.078 $1.553 $0.826 $1.078
den Engelsen, Todd Anthony 0.001 0.00% 0.008 0.01% 0.008 0.01%
Officer - Shares - Amount $0.005 $0.018 $0.031
Options - percentage 0.129 0.11% 0.181 0.15% 0.164 0.11%
Options - amount $0.684 $0.433 $0.680
Wagner, Kenneth Arnold 0.354 0.30% 0.399 0.34% 0.399 0.27%
Officer - Shares - Amount $1.872 $0.955 $1.650
Options - percentage 0.120 0.10% 0.072 0.06% 0.112 0.08%
Options - amount $0.635 $0.172 $0.464
Matthies, Jeremy Paul 0.006 0.01% 0.012 0.01% 0.012 0.01%
Officer - Shares - Amount $0.045 $0.028 $0.048
Options - percentage 0.060 0.06% 0.168 0.14% 0.146 0.10%
Options - amount $0.424 $0.403 $0.602
Thue, Todd Garth 0.076 0.07% 0.081 0.07% 0.081 0.06%
Officer - Shares - Amount $0.539 $0.194 $0.336
Options - percentage 0.252 0.24% 0.345 0.29% 0.284 0.19%
Options - amount $1.783 $0.826 $1.175
Lich, Miles 0.025 0.02%
Director - Shares - Amount $0.103
Options - percentage 0.041 0.03%
Options - amount $0.169
Grad, Stan 2.676 2.54% 2.646 2.49% 2.471 2.12% 2.271 1.93%
Director - Shares - Amount $17.863 $18.707 $13.065 $5.437
Options - percentage 0.015 0.01% 0.023 0.02% 0.021 0.02%
Options - amount $0.106 $0.119 $0.051
Antony, Raymond Peter 0.040 0.04% 0.040 0.03% 0.045 0.04% 0.053 0.04%
Chairman - Shares - Amt $0.283 $0.212 $0.108 $0.217
Options - percentage 0.033 0.03% 0.035 0.03% 0.044 0.04% 0.061 0.04%
Options - amount $0.230 $0.185 $0.105 $0.252
Increase in O/S Shares 0.426 0.41% 0.682 0.64% 0.676 0.58% 0.320 0.27%
due to SO $2.844 $4.822 $3.575 $0.766
Book Value $2.249 $2.591 $4.648 $0.594
Insider Buying -$0.168 -$0.121
Insider Selling $2.802 $1.259
Net Insider Selling $4.529 $2.634 $1.137
% of Market Cap 0.73% 0.94% 0.19%
Directors 7 8 7 6
Women 0 0% 0 0% 0 0% 0 0%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 50 33.25% 75 34.42% 78 29.40% 68 50.09% 55 77.99%
Total Shares Held 20.330 19.34% 21.508 20.23% 20.165 17.29% 34.591 29.44% 66.883 45.72%
Increase/Decrease 3 Mths 0.220 1.09% -1.272 -5.58% 0.024 0.12% 3.567 11.50% 5.611 9.16%
Starting No. of Shares 20.110 22.781 20.141 31.024 61.273
Copyright 2008 Website of SPBrunner. All rights reserved.