This report should not be construed as providing investment advice. It is for educational purposes only.  Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Q2 2022
Trican Well Service Ltd TSX: TCW OTC: TOLWF https://www.tricanwellservice.com/ Fiscal Yr:
Stock FRC FRC FRC FRC FRC FRC FRC TCW TCW TCW TCW TCW TCW TCW TCW TCW
Year 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 1/1/26 Value Description #Y Item
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS
Plan of Arrangement Date 31-May-17
Plan of Arrangement  1.7
$960.0 <-12 mths 10.82%
Revenue* $215.9 $372.1 $353.1 $299.8 $591.0 $404.0 $239.6 $929.9 $900.6 $636.1 $397.0 $562.5 $866.3 $991.0 $1,050.0 $1,125.0 145.33% <-Total Growth 10 Revenue
Increase 360.01% 72.35% -5.10% -15.10% 97.15% -31.64% -40.70% 288.17% -3.15% -29.37% -37.58% 41.68% 54.01% 14.40% 5.95% 7.14% 9.39% <-IRR #YR-> 10 Revenue 145.33%
5 year Running Average $86.0 $151.1 $212.1 $257.6 $366.4 $404.0 $377.5 $492.9 $613 $622 $621 $685 $672 $691 $773 $919 -1.41% <-IRR #YR-> 5 Revenue -6.84%
Revenue per Share $2.10 $3.59 $3.36 $2.82 $5.07 $3.44 $1.64 $2.75 $2.99 $2.34 $1.55 $2.28 $3.77 $4.31 $4.57 $4.90 12.23% <-IRR #YR-> 10 5 yr Running Average 217.09%
Increase 259.37% 70.58% -6.41% -16.03% 79.68% -32.16% -52.36% 67.74% 8.73% -21.56% -33.74% 46.71% 65.53% 14.40% 5.95% 7.14% 6.41% <-IRR #YR-> 5 5 yr Running Average 36.45%
5 year Running Average $1.43 $1.90 $2.31 $2.49 $3.39 $3.65 $3.26 $3.14 $3.18 $2.63 $2.25 $2.38 $2.59 $2.85 $3.30 $3.97 1.16% <-IRR #YR-> 10 Revenue per Share 12.25%
P/S (Price/Sales) Med 1.95 2.00 2.09 2.34 1.59 1.08 1.86 1.58 0.89 0.54 0.68 1.15 0.99 0.94 0.00 0.00 6.54% <-IRR #YR-> 5 Revenue per Share 37.24%
P/S (Price/Sales) High 3.22 2.61 2.61 2.66 2.32 1.53 2.59 2.00 1.44 0.73 1.08 1.59 1.27 1.21 0.00 0.00 1.56 <-Median-> 10 P/S HighPrice
P/S (Price/Sales) Low 0.67 1.39 1.58 2.01 0.86 0.63 1.12 1.17 0.34 0.36 0.28 0.71 0.71 0.68 0.00 0.00 0.71 <-Median-> 10 P/S Low Price
P/S (Price/Sales) Closing 3.03 1.96 1.99 2.51 1.04 0.70 2.53 1.49 0.40 0.49 1.08 1.22 0.97 1.11 1.05 0.98 1.13% <-IRR #YR-> 10 5 yr Running Average 11.87%
*Revenue in M CDN $  P/S Med 20 yr  0.86 15 yr  0.71 10 yr  1.12 5 yr  0.89 -0.64% Diff M/C -3.82% <-IRR #YR-> 5 5 yr Running Average -17.70%
-$353.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $866.3
-$929.9 $0.0 $0.0 $0.0 $0.0 $866.3
-$212.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $672.5
-$492.9 $0.0 $0.0 $0.0 $0.0 $672.5
-$3.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.77
-$2.75 $0.00 $0.00 $0.00 $0.00 $3.77
-$2.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.59
-$3.14 $0.00 $0.00 $0.00 $0.00 $2.59
$0.26 <-12 mths 271.43%
EPS Basic $0.56 $0.92 $0.52 -$0.04 $0.44 -$0.53 -$0.52 $0.05 -$0.73 -$0.26 -$0.89 $0.07 $0.33 -36.97% <-Total Growth 10 EPS Basic
EPS Diluted* $0.55 $0.90 $0.51 -$0.04 $0.44 -$0.53 -$0.52 $0.05 -$0.73 -$0.26 -$0.89 $0.07 $0.32 $0.58 $0.58 $0.74 -37.47% <-Total Growth 10 EPS Diluted
Increase 321.43% 64.52% -43.14% -108.05% 1157.14% -221.62% 2.22% 109.66% -1560.00% 64.38% -242.31% 107.87% 357.14% 81.25% 0.00% 27.59% 4 6 10 Years of Data, EPS P or N
Earnings Yield 8.6% 12.8% 7.7% -0.6% 8.2% -22.1% -12.5% 1.2% -61.9% -22.8% -53.0% 2.5% 8.7% 12.1% 12.1% 15.5% -4.59% <-IRR #YR-> 10 Earnings per Share -37.47%
5 year Running Average $0.01 $0.18 $0.33 $0.33 $0.47 $0.26 -$0.03 -$0.12 -$0.26 -$0.40 -$0.47 -$0.35 -$0.30 -$0.04 $0.13 $0.46 44.96% <-IRR #YR-> 5 Earnings per Share 540.00%
10 year Running Average $0.21 $0.13 $0.08 $0.11 $0.04 $0.04 -$0.11 -$0.19 -$0.21 -$0.15 -$0.13 -$0.01 #NUM! <-IRR #YR-> 10 5 yr Running Average -216.73%
* Diluted ESP per share  E/P 10 Yrs -6.55% 5Yrs -22.81% 19.83% <-IRR #YR-> 5 5 yr Running Average -147.12%
-$0.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.32
-$0.05 $0.00 $0.00 $0.00 $0.00 $0.32
-$0.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.30
$0.12 $0.00 $0.00 $0.00 $0.00 -$0.30
Dividend* $0.16 $0.17 Estimates Dividend*
Increase 0.00% 6.25% Estimates Increase
Payout Ratio EPS 27.59% 29.31% Estimates Payout Ratio EPS
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Canyon to Trican 2017 $0.10 $0.51 $0.60 $0.60 $0.41 $0.03 $0.00 $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 $0.00 $0.00 $0.00 $0.16 $0.16 $0.16 -100.00% <-Total Growth 10 Dividends
Increase 412.50% 17.07% 0.00% -32.50% -92.59% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2 3 11 Years of data, Count P, N
Average Increases 5 Year Running 79.41% 60.90% -41.60% -45.02% -45.02% -38.52% -20.00% 0.00% 0.00% 0.00% 0.00% -29.26% <-Median-> 8 Average Incr 5 Year Running
Dividends 5 Yr Running $0.26 $0.25 $0.19 $0.12 $0.05 $0.00 $0.00 $0.00 $0.03 $0.06 $0.10 #DIV/0! <-Total Growth 7 Dividends 5 Yr Running
Yield H/L Price 0.82% 4.29% 5.36% 4.38% 6.41% 0.58% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.93% 0.00% <-Median-> 10 Yield H/L Price
Yield on High  Price 0.63% 3.44% 4.71% 3.00% 4.52% 0.42% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.07% 0.00% <-Median-> 10 Yield on High  Price
Yield on Low Price 1.18% 5.69% 6.21% 8.09% 11.04% 0.96% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 5.46% 0.00% <-Median-> 10 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% 0.00% 0.00% 0.00% 3.35% 3.35% 3.35% 0.00% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 6.54% 58.91% 0.00% 81.08% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 27.59% 27.59% 21.62% 0.00% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 102.19% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 48.48% 20.96% 0.00% <-Median-> 8 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% 0.0% 0.0% 0.0% 15.5% 15.0% 13.6% 0.00% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 40.99% 59.99% 57.79% 40.19% 27.85% 1.63% 0.00% 0.00% 6.74% 9.58% 11.31% 34.02% <-Median-> 8 DPR CF 5 Yr Running
Payout Ratio CFPS WC 3.79% 30.05% 114.85% 34.54% 97.86% -10.41% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 15.5% 15.0% 13.6% 0.00% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 31.59% 52.49% 52.38% 32.39% 26.39% 2.16% 0.00% 0.00% 6.49% 9.34% 10.63% 28.99% <-Median-> 8 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 0.00% 0.00% 5 Yr Med 5 Yr Cl 4.33% 0.00% 5 Yr Med Payout 0.00% 0.00% 0.00% 0.00% <-IRR #YR-> 5 Dividends -100.00%
* Dividends per share  10 Yr Med and Cur. #DIV/0! #DIV/0! 5 Yr Med and Cur. -22.72% #DIV/0! Last Div Inc ---> $0.03 $0.16 433.3% 0.00% <-IRR #YR-> 10 Dividends #DIV/0!
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00
-$0.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Historical Dividends Historical High Div 6.96% Low Div 0.00% 10 Yr High 10.74% 10 Yr Low 0.00% Med Div 0.29% Close Div 0.21% Historical Dividends
High/Ave/Median Values Curr diff Exp. -51.91% #DIV/0! #DIV/0! Exp. -68.83% #DIV/0! Cheap 1054.23% Cheap 1468.76% High/Ave/Median 
Future Dividend Yield Div Yield 3.35% earning in 5 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yield 3.35% earning in 10 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yield 3.35% earning in 15 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Paid Div Paid $0.16 earning in 5 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Future Dividend Paid Div Paid $0.16 earning in 10 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Future Dividend Paid Div Paid $0.16 earning in 15 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Dividend Covering Cost Total Div $0.80 over 5 Years at IRR of 0.00% Div Cov. 16.74% Dividend Covering Cost
Dividend Covering Cost Total Div $1.44 over 10 Years at IRR of 0.00% Div Cov. 30.13% Dividend Covering Cost
Dividend Covering Cost Total Div $2.08 over 15 Years at IRR of 0.00% Div Cov. 43.51% Dividend Covering Cost
Yield if held 5 years 1.03% 13.23% 20.87% 35.29% 5.82% 0.25% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 6.02% 12.55% 15.09% 0.00% <-Median-> 10 Paid Median Price
Yield if held 10 years 0.31% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.43% 1.98% 4.31% 0.00% <-Median-> 7 Paid Median Price
Yield if held 15 years 0.00% 0.00% 9.46% 16.00% 3.91% 0.00% <-Median-> 2 Paid Median Price
Yield if held 20 years #DIV/0! #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Item
Cost cover if held 5 years 1.03% 15.81% 42.17% 106.62% 31.86% 17.64% 13.68% 9.24% 3.17% 0.48% 0.00% 0.00% 6.02% 25.10% 45.28% 11.46% <-Median-> 10 Paid Median Price EPS
Cost cover if held 10 years 23.05% 58.00% 78.17% 132.21% 32.29% 17.64% 13.68% 11.67% 7.14% 13.40% 32.29% <-Median-> 7 Paid Median Price CFPS
Cost cover if held 15 years 23.05% 58.00% 87.63% 164.21% 44.02% 40.53% <-Median-> 2 Paid Median Price FCF 
Cost cover if held 20 years #DIV/0! #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $929.9 $900.6 $636.1 $397.0 $562.5 $866.3 $4,292.4 -6.84% <-Total Growth 5 Revenue Growth  -6.84%
EPS Growth $0.05 -$0.73 -$0.26 -$0.89 $0.07 $0.32 -$1.44 540.00% <-Total Growth 5 EPS Growth 540.00%
Net Income Growth $15.5 -$232.7 -$73.5 -$234.7 $17.2 $79.2 -$428.9 411.23% <-Total Growth 5 Net Income Growth 411.23%
Cash Flow Growth $133.6 $100.9 $28.6 $70.8 $74.1 $152.3 $560.3 14.03% <-Total Growth 5 Cash Flow Growth 14.03%
Dividend Growth $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00% <-Total Growth 5 Dividend Growth 0.00%
Stock Price Growth $4.08 $1.18 $1.14 $1.68 $2.77 $3.66 -10.29% <-Total Growth 5 Stock Price Growth -10.29%
Revenue Growth  $353.1 $299.8 $591.0 $404.0 $239.6 $929.9 $900.6 $636.1 $397.0 $562.5 $866.3 $6,179.9 145.33% <-Total Growth 10 Revenue Growth  145.33%
EPS Growth $0.51 -$0.04 $0.44 -$0.53 -$0.52 $0.05 -$0.73 -$0.26 -$0.89 $0.07 $0.32 -$1.58 -37.47% <-Total Growth 10 EPS Growth -37.47%
Net Income Growth $54.4 -$4.4 $49.1 -$62.1 -$72.2 $15.5 -$232.7 -$73.5 -$234.7 $17.2 $79.2 -$464.0 45.59% <-Total Growth 10 Net Income Growth 45.59%
Cash Flow Growth $87.9 $51.5 $81.8 $13.1 -$4.0 $133.6 $100.9 $28.6 $70.8 $74.1 $152.3 $790.6 73.27% <-Total Growth 10 Cash Flow Growth 73.27%
Dividend Growth $0.30 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.3 -100.00% <-Total Growth 10 Dividend Growth -100.00%
Stock Price Growth $6.68 $7.07 $5.29 $2.39 $4.14 $4.08 $1.18 $1.14 $1.68 $2.77 $3.66 -45.18% <-Total Growth 10 Stock Price Growth -45.18%
Dividends on Shares $52.94 $52.94 $35.74 $2.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24.00 $24.00 $24.00 $144.26 No of Years 10 Total Divs 12/31/12
Paid  $1,001.47 $1,060.59 $793.24 $359.12 $620.29 $612.00 $177.00 $171.00 $252.00 $415.50 $549.00 $717.00 $717.00 $717.00 $549.00 No of Years 10 Worth $6.68
Total $693.26
Graham Number $5.17 $7.83 $6.08 $5.71 $5.94 $5.38 $4.80 $1.98 $1.77 $1.75 $1.47 $1.77 $3.98 $5.26 $5.26 $5.95 -34.62% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.79 0.91 1.16 1.15 1.36 0.69 0.63 2.20 1.50 0.73 0.72 1.48 0.94 0.77 1.05 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.31 1.19 1.44 1.31 1.98 0.98 0.88 2.78 2.42 0.98 1.14 2.05 1.20 0.99 1.26 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.27 0.63 0.87 0.99 0.73 0.40 0.38 1.62 0.58 0.48 0.30 0.92 0.68 0.56 0.63 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.24 0.90 1.10 1.24 0.89 0.45 0.86 2.06 0.66 0.65 1.14 1.57 0.92 0.91 0.91 0.80 0.91 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 23.52% -10.24% 9.77% 23.75% -11.01% -55.48% -13.88% 106.37% -33.51% -34.95% 14.16% 56.79% -7.96% -9.19% -9.19% -19.60% -9.49% <-Median-> 10 Graham Price
Canyon to Trican 2017 $10.85 $11.95 $11.35 $12.02 $8.99 $4.07 $7.03
Price Close $6.38 $7.03 $6.68 $7.07 $5.29 $2.39 $4.14 $4.08 $1.18 $1.14 $1.68 $2.77 $3.66 $4.78 $4.78 $4.78 -48.24% <-Total Growth 10 Stock Price
Increase 361.70% 10.14% -5.02% 5.90% -25.21% -54.73% 72.73% -1.34% -71.08% -3.39% 47.37% 64.88% 32.13% 30.60% 0.00% 0.00% 30.38 <-Median-> 10 CAPE (10 Yr P/E)
P/E 11.67 7.81 13.05 -171.71 12.15 -4.52 -7.99 81.60 -1.62 -4.38 -1.89 39.57 11.44 8.24 8.24 6.46 -2.15% <-IRR #YR-> 5 Stock Price -10.29%
Trailing P/E -25.83 12.85 7.42 13.82 -128.43 5.50 -7.81 -7.88 23.60 -1.56 -6.46 -3.11 52.29 14.94 8.24 8.24 -5.83% <-IRR #YR-> 10 Stock Price -45.18%
CAPE (10 Yr P/E) 18.15 30.38 54.70 42.53 120.42 31.16 -15.68 -14.57 -17.49 -32.48 -36.02 -829.18 -2.15% <-IRR #YR-> 5 Price & Dividend -10.29%
Median 10, 5 Yrs D.  per yr 1.62% 0.00% % Tot Ret 0.00% 0.00% T P/E -2.34 -1.56 P/E:  -1.75 -1.62 -4.22% <-IRR #YR-> 10 Price & Dividend -30.78%
Price 15 D.  per yr 4.94% % Tot Ret 41.32% CAPE Diff -72.88% 7.02% <-IRR #YR-> 15 Stock Price 176.53%
Price 20 D.  per yr 2.65% % Tot Ret 64.83% 1.44% <-IRR #YR-> 16 Stock Price
Price & Dividend 15 11.96% <-IRR #YR-> 15 Price & Dividend 276.42%
Price & Dividend 20 4.09% <-IRR #YR-> 16 Price & Dividend
Price  5 -$4.08 $0.00 $0.00 $0.00 $0.00 $3.66 Price  5
Price 10 -$6.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.66 Price 10
Price & Dividend 5 -$4.08 $0.00 $0.00 $0.00 $0.00 $3.66 Price & Dividend 5
Price & Dividend 10 -$6.68 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $3.66 Price & Dividend 10
Price 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.66 Price 15
Price 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.66 Price 20
Price & Dividend 15 $0.00 $0.06 $0.30 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $3.66 Price & Dividend 15
Price & Dividend 20 $0.00 $0.06 $0.30 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $3.66 Price & Dividend 20
Price H/L Median $4.09 $7.16 $7.03 $6.59 $8.06 $3.71 $3.04 $4.35 $2.66 $1.28 $1.06 $2.62 $3.74 $4.08 -43.31% <-Total Growth 10 Stock Price
Increase 309.41% 74.93% -1.81% -6.32% 22.41% -53.94% -18.13% 43.04% -38.85% -52.07% -16.86% 147.17% 42.56% 9.10% -6.13% <-IRR #YR-> 10 Stock Price -46.89%
P/E 7.48 7.96 13.74 -160.00 18.53 -7.02 -5.88 87.00 -3.64 -4.90 -1.19 37.43 11.67 7.03 -3.00% <-IRR #YR-> 5 Stock Price -14.14%
Trailing P/E -16.57 13.09 7.81 12.87 -195.86 8.53 -5.74 -8.40 53.20 -1.75 -4.08 -2.94 53.36 12.73 -4.60% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 290.00 39.27 21.20 19.72 17.14 14.55 -107.71 -36.07 -10.30 -3.21 -2.26 -7.44 -12.53 -113.19 -3.00% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 37.98 27.58 39.47 41.20 70.22 34.85 -9.90 -13.78 -17.85 -27.69 -1.19 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr -114.51% 3.00% % Tot Ret 0.00% 0.00% T P/E -2.35 -1.75 P/E:  -2.42 -1.19 Count 16 Years of data
-$7.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.74
-$4.35 $0.00 $0.00 $0.00 $0.00 $3.74
-$7.03 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $3.74
-$4.35 $0.00 $0.00 $0.00 $0.00 $3.74
High Months Dec July Mar Aug Jul Apr Dec Feb Jan Apr Dec Nov Jun Oct
Canyon to Trican 2017 $11.52 $15.90 $14.91 $12.74 $20.00 $8.96 $7.21
Price High $6.78 $9.35 $8.77 $7.49 $11.76 $5.27 $4.24 $5.49 $4.29 $1.71 $1.68 $3.62 $4.78 $5.22 -36.22% <-Total Growth 10 Stock Price
Increase 360.80% 38.02% -6.23% -14.55% 56.99% -55.20% -19.53% 29.45% -21.86% -60.14% -1.75% 115.48% 32.04% 9.21% -5.89% <-IRR #YR-> 10 Stock Price -45.50%
P/E 12.39 10.39 17.14 -182.00 27.03 -9.96 -8.19 109.80 -5.88 -6.58 -1.89 51.71 14.94 9.00 -2.73% <-IRR #YR-> 5 Stock Price -12.93%
Trailing P/E -27.43 17.10 9.75 14.64 -285.71 12.11 -8.01 -10.61 85.80 -2.34 -6.46 -4.07 68.29 16.31 -1.89 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E -3.20 -2.34 P/E:  -3.88 -1.89 36.90 P/E Ratio Historical High
-$8.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.78
-$5.49 $0.00 $0.00 $0.00 $0.00 $4.78
Low Months Jan Oct Jul Apr Dec Dec Jan Jun Dec Nov Mar Jan Sep Mar
Price Low $1.41 $4.97 $5.29 $5.68 $4.36 $2.16 $1.84 $3.21 $1.03 $0.84 $0.44 $1.62 $2.69 $2.93 -52.66% <-Total Growth 10 Stock Price
Increase 166.67% 252.08% 6.51% 7.33% -23.19% -50.54% -14.71% 74.35% -67.91% -18.45% -47.62% 268.18% 66.05% 8.92% -6.55% <-IRR #YR-> 10 Stock Price -49.19%
P/E 2.58 5.52 10.34 -138.00 10.03 -4.08 -3.56 64.20 -1.41 -3.23 -0.49 23.14 8.41 5.05 -3.47% <-IRR #YR-> 5 Stock Price -16.20%
Trailing P/E -5.71 9.09 5.88 11.10 -106.00 4.96 -3.48 -6.20 20.60 -1.15 -1.69 -1.82 38.43 9.16 -0.49 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E -1.42 -1.15 P/E:  -0.95 -0.49 -4.45 P/E Ratio Historical Low
-$5.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.69
Company $204.20 <-12 mths 30.06%
MS etc. $132.62 <-12 mths 172.82%
Free Cash Flow Company $7.5 $79.4 $157.0 Free Cash Flow Company
Change 958.67% 97.73% Change
Free Cash Flow MS, WSJ, Mrk Sc -$77.00 -$270.00 -$258.00 $64.00 -$29.00 $102.70 -$95.38 $103.27 $25.52 -$4.60 $57.98 $20.21 $48.61 $119.0 $127.0 $139.0 -24.04% <-Total Growth 10 Free Cash Flow
Change -250.65% 4.44% 124.81% -145.31% 454.12% -192.88% 208.27% -75.28% -118.02% 1360.43% -65.14% 140.53% 144.80% 6.72% 9.45% -13.99% <-IRR #YR-> 5 Free Cash Flow MS -52.93%
FCF/CF from Op Ratio -1.28 -2.48 -2.93 1.24 -0.35 7.84 23.64 0.77 0.25 -0.16 0.82 0.27 0.32 0.50 0.52 0.51 #NUM! <-IRR #YR-> 10 Free Cash Flow MS 118.84%
Dividends paid $6.04 $31.26 $37.11 $37.52 $22.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36.76 $36.76 $36.76 -100.00% <-Total Growth 10 Dividends paid
Percentage paid 21.78% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 30.89% 28.95% 26.45% $0.00 <-Median-> 8 Percentage paid
5 Year Coverage 17.01% 0.00% 0.00% 0.00% 15.24% 19.72% 24.30% 5 Year Coverage
Dividend Coverage Ratio 4.59 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.24 3.45 3.78 0.00 <-Median-> 8 Dividend Coverage Ratio
5 Year of Coverage 5.88 0.00 0.00 0.00 6.56 5.07 4.11 5 Year of Coverage
Market Cap $655.0 $728.9 $702.0 $751.6 $616.7 $281.3 $604.9 $1,381.1 $355.8 $309.5 $429.6 $684.1 $841.0 $1,098.3 $1,098.3 $1,098.3 11.89% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 98.928 103.156 103.921 105.966 113.162 117.099 139.407 284.615 322.125 322.125 263.830 257.786 246.655 255.366 137.35% <-Total Growth 10 Diluted
Change 127.01% 4.27% 0.74% 1.97% 6.79% 3.48% 19.05% 104.16% 13.18% 0.00% -18.10% -2.29% -4.32% 3.53% 2.72% <-Median-> 10 Change
Difference Diluted/Basic -2.7% 0.0% 0.0% 0.0% -1.3% 0.0% 0.0% -1.0% 0.0% 0.0% 0.0% -1.8% -2.1% 0.0% 0.00% <-Median-> 10 Difference Diluted/Basic
Basic # of Shares in Millions 96.249 103.156 103.921 105.966 111.688 117.099 139.407 281.817 322.125 322.125 263.830 253.154 241.410 255.366 132.30% <-Total Growth 10 Basic
Change 120.87% 7.18% 0.74% 1.97% 5.40% 4.84% 19.05% 102.15% 14.30% 0.00% -18.10% -4.05% -4.64% 5.78% 3.41% <-Median-> 10 Change
Difference Basic/Outstanding 6.6% 0.5% 1.2% 0.3% 4.4% 0.4% 4.9% 20.1% -6.4% -15.7% -3.1% -2.4% -4.8% -10.0% -1.07% <-Median-> 10 Difference Basic/Outstanding
$224.43 <-12 mths 47.34%
# of Share in Millions 102.627 103.692 105.138 106.298 116.627 117.511 146.283 338.506 301.505 271.490 255.736 246.965 229.777 229.777 229.777 229.777 8.13% <-IRR #YR-> 10 Shares 118.55%
Change 28.00% 1.04% 1.40% 1.10% 9.72% 0.76% 24.48% 131.40% -10.93% -9.96% -5.80% -3.43% -6.96% 0.00% 0.00% 0.00% -7.46% <-IRR #YR-> 5 Shares -32.12%
Cash Flow from Operations $M $60.0 $108.8 $87.9 $51.5 $81.8 $13.1 -$4.0 $133.6 $100.9 $28.6 $70.8 $74.1 $152.3 $236.7 $245.9 $271.1 73.27% <-Total Growth 10 Cash Flow
Increase -5475% 81.15% -19.16% -41.48% 59.03% -83.99% -130.80% -3410.48% -24.43% -71.64% 147.20% 4.71% 105.58% 55.37% 3.88% 10.28% SO S. Issues
5 year Running Average $15.6 $35.8 $53.2 $61.4 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $112.5 $155.9 $196.0 53.81% <-Total Growth 10 CF 5 Yr Running
CFPS $0.58 $1.05 $0.84 $0.48 $0.70 $0.11 -$0.03 $0.39 $0.33 $0.11 $0.28 $0.30 $0.66 $1.03 $1.07 $1.18 -20.72% <-Total Growth 10 Cash Flow per Share
Increase -4299% 79.29% -20.28% -42.11% 44.95% -84.11% -124.74% -1530.61% -15.16% -68.50% 162.43% 8.42% 120.95% 55.37% 3.88% 10.28% 5.65% <-IRR #YR-> 10 Cash Flow 73.27%
5 year Running Average $0.22 $0.38 $0.55 $0.59 $0.73 $0.64 $0.42 $0.33 $0.30 $0.18 $0.22 $0.28 $0.34 $0.48 $0.67 $0.85 2.66% <-IRR #YR-> 5 Cash Flow 14.03%
P/CF on Med Price 7.00 6.83 8.41 13.61 11.50 33.32 -110.25 11.02 7.95 12.09 3.83 8.73 5.63 3.96 0.00 0.00 -2.29% <-IRR #YR-> 10 Cash Flow per Share -20.72%
P/CF on High Price 11.58 8.92 10.49 15.48 16.77 47.27 -153.76 13.91 12.81 16.22 6.07 12.07 7.21 5.07 0.00 0.00 10.93% <-IRR #YR-> 5 Cash Flow per Share 67.99%
-48.69% Diff M/C -4.75% <-IRR #YR-> 10 CFPS 5 yr Running -20.22%
$227.14 <-12 mths 19.63%
Excl.Working Capital CF $15.4 $52.3 $17.6 -$18.8 $37.4 $15.5 -$20.8 $12.9 $5.0 $1.7 -$48.0 $27.1 $37.5 $0.0 $0.0 $0.0 0.19% <-IRR #YR-> 5 CFPS 5 yr Running 0.95%
CF fr Op $M WC $75.4 $161.0 $105.5 $32.7 $119.2 $28.6 -$24.8 $146.5 $105.9 $30.3 $22.8 $101.2 $189.9 $236.7 $245.9 $271.1 80.01% <-Total Growth 10 Cash Flow less WC
Increase -19498% 113.55% -34.49% -69.03% 264.86% -76.00% -186.65% -690.89% -27.70% -71.36% -24.93% 344.27% 87.69% 24.65% 3.88% 10.28% 6.05% <-IRR #YR-> 10 Cash Flow less WC 80.01%
5 year Running Average $18.8 $48.8 $69.9 $74.8 $98.7 $89.4 $52.2 $60.4 $75.1 $57.3 $56.1 $81.3 $90.0 $116.2 $159.3 $208.9 5.33% <-IRR #YR-> 5 Cash Flow less WC 29.63%
CFPS Excl. WC $0.73 $1.55 $1.00 $0.31 $1.02 $0.24 -$0.17 $0.43 $0.35 $0.11 $0.09 $0.41 $0.83 $1.03 $1.07 $1.18 2.55% <-IRR #YR-> 10 CF less WC 5 Yr Run 72.33%
Increase -15255% 111.36% -35.39% -69.37% 232.55% -76.18% -169.61% -355.35% -18.83% -68.19% -20.31% 360.04% 101.73% 24.65% 3.88% 10.28% 8.29% <-IRR #YR-> 5 CF less WC 5 Yr Run 48.95%
5 year Running Average $0.25 $0.50 $0.70 $0.72 $0.92 $0.83 $0.48 $0.37 $0.38 $0.19 $0.16 $0.28 $0.36 $0.49 $0.69 $0.90 10.40% <-IRR #YR-> 10 CFPS - Less WC -17.63%
P/CF on Med Price 5.57 4.61 7.01 21.44 7.89 15.26 -17.95 10.05 7.57 11.41 11.90 6.40 4.52 3.96 0.00 0.00 13.81% <-IRR #YR-> 5 CFPS - Less WC 90.97%
P/CF on High Price 9.22 6.02 8.74 24.39 11.51 21.65 -25.03 12.69 12.21 15.30 18.87 8.84 5.78 5.07 0.00 0.00 12.45 <-Median-> 10 P/CF on High 
P/CF on Low Price 1.92 3.20 5.28 18.49 4.27 8.87 -10.87 7.42 2.93 7.52 4.94 3.95 3.26 2.84 0.00 0.00 4.61 <-Median-> 10 P/CF on Low 
P/CF on Closing Price 8.69 4.53 6.66 23.01 5.17 9.83 -24.40 9.43 3.36 10.20 18.87 6.76 4.43 4.64 4.47 4.05 -6.51% <-IRR #YR-> 10 CFPS 5 yr Running -25.70%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 9.88 5 yr  7.95 P/CF Med 10 yr 8.97 5 yr  7.57 -43.51% Diff M/C -0.53% <-IRR #YR-> 5 CFPS 5 yr Running -2.61%
-$0.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.66 Cash Flow per Share
-$0.39 $0.00 $0.00 $0.00 $0.00 $0.66 Cash Flow per Share
-$0.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.34 CFPS 5 yr Running
-$0.33 $0.00 $0.00 $0.00 $0.00 $0.34 CFPS 5 yr Running
-$105.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $189.9 Cash Flow less WC
-$146.5 $0.0 $0.0 $0.0 $0.0 $189.9 Cash Flow less WC
-$69.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $90.0 CF less WC 5 Yr Run
-$60.4 $0.0 $0.0 $0.0 $0.0 $90.0 CF less WC 5 Yr Run
-$0.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.83 CFPS - Less WC
-$0.43 $0.00 $0.00 $0.00 $0.00 $0.83 CFPS - Less WC
-$0.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.36 CFPS 5 yr Running
-$0.37 $0.00 $0.00 $0.00 $0.00 $0.36 CFPS 5 yr Running
OPM 27.81% 29.23% 24.90% 17.16% 13.84% 3.24% -1.68% 14.36% 11.21% 4.50% 17.82% 13.17% 17.58% 23.88% -29.37% <-Total Growth 10 OPM
Increase 1268.39% 5.11% -14.82% -31.06% -19.33% -76.57% -151.93% 952.85% -21.97% -59.85% 296.04% -26.09% 33.48% 35.82% Should increase  or be stable.
Diff from Median 105.9% 116.4% 84.3% 27.0% 2.5% -76.0% -112.5% 6.3% -17.0% -66.7% 31.9% -2.5% 30.2% 76.8% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 13.51% 5 Yrs 13.17% should be  zero, it is a   check on calculations
$243.8 <-12 mths 29.34% Earnings before Interest, Taxes
Adjusted EBITDA -$37.40 $183.30 $89.50 $28.00 $14.60 $101.60 $188.50 Depreciation and Amortization
Change 590.11% -51.17% -68.72% -47.86% 595.89% 85.53% The EBITDA margin is a measure of a company's operating profit as a percentage of its revenue. 
Margin -15.61% 19.71% 9.94% 4.40% 3.68% 18.06% 21.76%
$248.0 <-12 mths 25.38%
Adjusted EBITDAS $23.10 $106.10 $197.80 And Stock Based Comp.
Change 359.31% 86.43%
Margin 5.82% 18.86% 22.83%
Long Term Debt $30.00 $60.00 $25.00 $83.36 $45.91 $46.22 $0.00 $0.00 $29.82 $0.00 -50.31% <-Total Growth 8 Debt
Change 100.00% -58.33% 233.44% -44.93% 0.67% -100.00% 0.00% 0.00% -100.00% 0.00% <-Median-> 8 Change
Debt/Market Cap Ratio 0.05 0.21 0.04 0.06 0.13 0.15 0.00 0.00 0.04 0.00 0.05 <-Median-> 9 % of Market C.
Assets/Current Liabilities Ratio 4.32 8.04 8.48 9.98 12.09 9.97 9.29 7.45 7.15 6.47 8.48 <-Median-> 9 Assets/Current Liabilities
Debt to Cash Flow (Years) 0.37 4.58 0.00 0.62 0.45 1.61 0.00 0.00 0.20 0.00 0.37 <-Median-> 9 Debt to Cash Flow (Years)
Intangibles $0.32 $0.18 $41.26 $35.24 $29.22 $557.48 $44.87 $34.42 $23.96 $13.50 $3.04 $0.00 856.92% <-Total Growth 10 Intangibles Type
Goodwill $0.00 $0.00 $49.83 $21.43 $21.43 $261.03 $131.00 $131.00 $0.00 $0.00 $0.00 $0.00 #DIV/0! <-Total Growth 10 Goodwill Lg Term R
Total $0.32 $0.18 $91.10 $56.67 $50.65 $818.51 $175.87 $165.42 $23.96 $13.50 $3.04 $0.00 856.92% <-Total Growth 10 Total Intang/GW
Change -44.34% 51366.10% -37.79% -10.63% 1516.04% -78.51% -5.95% -85.52% -43.65% -77.46% -100.00% -40.72% <-Median-> 10 Change Liquidity
Intangible/Market Cap Ratio 0.00 0.00 0.15 0.20 0.08 0.59 0.49 0.53 0.06 0.02 0.00 0.00 0.12 <-Median-> 10 % of Market C. Liq. + CF
Debt Ratio
Current Assets $97.45 $149.25 $106.08 $119.05 $169.86 $91.02 $82.31 $292.08 $201.45 $232.74 $122.46 $181.34 $263.26 $224.94 148.18% <-Total Growth 10 Current Assets Leverage
Current Liabilities $47.09 $82.24 $49.83 $77.32 $147.98 $63.44 $54.04 $150.94 $85.83 $92.93 $60.63 $77.58 $93.90 $97.09 88.42% <-Total Growth 10 Current Liabilities D/E Ratio
Liquidity 2.07 1.81 2.13 1.54 1.15 1.43 1.52 1.94 2.35 2.50 2.02 2.34 2.80 2.32 1.98 <-Median-> 10 Ratio
Liq. with CF aft div 3.67 3.70 3.61 1.48 1.68 1.44 1.45 2.91 3.58 2.83 2.40 3.64 4.83 4.38 3.58 <-Median-> 5 Ratio CF less WC
Liq. CF re  Inv+Div  1.28 1.37 1.28 1.44 0.93 1.17 1.17 2.91 3.58 2.83 2.40 2.42 2.52 4.38 2.52 <-Median-> 5 Ratio CF less WC
Assets $271.31 $407.33 $406.11 $402.71 $638.77 $510.09 $458.03 $1,506.22 $1,037.81 $926.52 $563.21 $577.84 $671.12 $628.28 65.25% <-Total Growth 10 Assets
Liabilities $48.52 $93.26 $68.34 $101.32 $218.24 $163.15 $113.68 $330.17 $193.67 $185.41 $70.94 $88.44 $166.45 $140.48 143.57% <-Total Growth 10 Liabilities
Debt Ratio 5.59 4.37 5.94 3.97 2.93 3.13 4.03 4.56 5.36 5.00 7.94 6.53 4.03 4.47 4.30 <-Median-> 10 Ratio
Estimates BVPS $2.37 $2.93 $3.65 Estimates Estimates BVPS
Estimate Book Value $544.6 $673.2 $838.7 Estimates Estimate Book Value
P/B Ratio (Close) 2.02 1.63 1.31 Estimates P/B Ratio (Close)
Difference from 10 year median 58.18% Diff M/C Estimates Difference from 10 yr med.
Total Book Value $222.79 $314.07 $337.78 $301.39 $420.53 $346.94 $344.35 $1,176.05 $844.14 $741.11 $492.28 $489.40 $504.67 $487.80 $487.80 $487.80 49.41% <-Total Growth 10 Book Value
Warrents $0.19 $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
Book Value $222.59 $314.07 $337.78 $301.39 $420.53 $346.94 $344.35 $1,176.05 $844.14 $741.11 $492.28 $489.40 $504.67 $487.80 $487.80 $487.80 49.41% <-Total Growth 10 Book Value
Book Value per share $2.17 $3.03 $3.21 $2.84 $3.61 $2.95 $2.35 $3.47 $2.80 $2.73 $1.92 $1.98 $2.20 $2.12 $2.12 $2.12 -31.63% <-Total Growth 10 Book Value per Share
Change 39.71% 39.65% 6.07% -11.75% 27.17% -18.12% -20.27% 47.59% -19.41% -2.50% -29.48% 2.95% 10.83% -3.34% 0.00% 0.00% 74.29% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.89 2.36 2.19 2.32 2.24 1.26 1.29 1.25 0.95 0.47 0.55 1.32 1.70 1.92 0.00 0.00 1.29 P/B Ratio Historical Median
P/B Ratio (Close) 2.94 2.32 2.08 2.49 1.47 0.81 1.76 1.17 0.42 0.42 0.87 1.40 1.67 2.25 2.25 2.25 -3.73% <-IRR #YR-> 10 Book Value -31.63%
Change 230.48% -21.13% -10.46% 20.00% -41.19% -44.71% 116.63% -33.15% -64.11% -0.91% 108.99% 60.16% 19.21% 35.12% -8.76% <-IRR #YR-> 5 Book Value -36.78%
Leverage (A/BK) 1.22 1.30 1.20 1.34 1.52 1.47 1.33 1.28 1.23 1.25 1.14 1.18 1.33 1.29 1.31 <-Median-> 10 A/BV
Debt/Equity Ratio 0.22 0.30 0.20 0.34 0.52 0.47 0.33 0.28 0.23 0.25 0.14 0.18 0.33 0.29 0.31 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.28 5 yr Med 0.95 76.59% Diff M/C 1.29 Historical A/BV
-$3.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.20
-$3.47 $0.00 $0.00 $0.00 $0.00 $2.20
$120.28 <-12 mths 51.84%
Comprehensive Income $54.35 $95.27 $54.41 -$4.38 $49.09 -$62.06 -$72.20 $11.07 -$233.34 -$72.72 -$233.51 $17.35 $79.22 45.59% <-Total Growth 10 Comprehensive Income
Increase 591.47% 75.28% -42.89% -108.04% 1222.15% -226.42% -16.33% 115.33% -2208.84% 68.83% -221.09% 107.43% 356.60% 68.83% <-Median-> 5 Comprehensive Income
5 Yr Running Average $6.91 $25.56 $38.19 $37.72 $49.75 $26.47 -$7.03 -$15.70 -$61.49 -$85.85 -$120.14 -$102.23 -$88.60 3.83% <-IRR #YR-> 10 Comprehensive Income 45.59%
ROE 24.4% 30.3% 16.1% -1.5% 11.7% -17.9% -21.0% 0.9% -27.6% -9.8% -47.4% 3.5% 15.7% 48.24% <-IRR #YR-> 5 Comprehensive Income 615.91%
5Yr Median -2.3% -2.3% 16.1% 16.1% 16.1% 11.7% -1.5% -1.5% -17.9% -17.9% -21.0% -9.8% -9.8% #NUM! <-IRR #YR-> 10 5 Yr Running Average -434.77%
% Difference from NI 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% -28.6% 0.3% -1.0% -0.5% 0.7% 0.0% 41.36% <-IRR #YR-> 5 5 Yr Running Average -464.50%
Median Values Diff 5, 10 yr 0.0% 0.0% -9.8% <-Median-> 5 Return on Equity
-$54.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $79.2
-$11.1 $0.0 $0.0 $0.0 $0.0 $79.2
\ \ -$38.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$88.6
$15.7 $0.0 $0.0 $0.0 $0.0 -$88.6
Current Liability Coverage Ratio 1.60 1.96 2.12 0.42 0.81 0.45 -0.46 0.97 1.23 0.33 0.38 1.30 2.02 2.44   CFO / Current Liabilities
5 year Median 0.61 0.61 1.60 1.60 1.60 0.81 0.45 0.45 0.81 0.45 0.38 0.97 1.23 1.30 0.80 <-Median-> 4 Current Liability Cov Ratio
Asset Efficiency Ratio 27.79% 39.53% 25.97% 8.11% 18.66% 5.61% -5.41% 9.72% 10.20% 3.27% 4.04% 17.51% 28.29% 37.67% CFO / Total Assets
5 year Median 6.96% 6.96% 25.97% 25.97% 25.97% 18.66% 8.11% 8.11% 9.72% 5.61% 4.04% 9.72% 10.20% 17.51% 7.1% <-Median-> 4 Return on Assets 
Return on Assets ROA 20.0% 23.4% 13.4% -1.1% 7.7% -12.2% -15.8% 1.0% -22.4% -7.9% -41.7% 3.0% 11.8% 20.2% Net  Income/Assets Return on Assets
5Yr Median -1.7% -1.7% 13.4% 13.4% 13.4% 7.7% -1.1% -1.1% -12.2% -12.2% -15.8% -7.9% -7.9% 3.0% -4.5% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 24.4% 30.3% 16.1% -1.5% 11.7% -17.9% -21.0% 1.3% -27.6% -9.9% -47.7% 3.5% 15.7% 26.0% Net Inc/ Shareholders' equity Return on Equity
5Yr Median -2.3% -2.3% 16.1% 16.1% 16.1% 11.7% -1.5% -1.5% -17.9% -17.9% -21.0% -9.9% -9.9% 3.5% -5.7% <-Median-> 10 Return on Equity
$120.28 <-12 mths 51.84%
Net Income $54.35 $95.27 $54.41 -$4.38 $49.09 -$62.06 -$72.20 $15.50 -$232.66 -$73.46 -$234.69 $17.22 $79.22 $127.0 $124.0 $149.0 45.59% <-Total Growth 10 Net Income
Increase 591.47% 75.28% -42.89% -108.04% 1222.15% -226.42% -16.33% 121.46% -1601.50% 68.43% -219.48% 107.34% 360.02% 60.32% -2.36% 20.16% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $6.9 $25.6 $38.2 $37.7 $49.8 $26.5 -$7.0 -$14.8 -$60.5 -$85.0 -$119.5 -$101.6 -$88.9 -$16.9 $22.5 $99.3 3.83% <-IRR #YR-> 10 Net Income 45.59%
Operating Cash Flow $60.03 $108.75 $87.91 $51.45 $81.82 $13.10 -$4.04 $133.58 $100.94 $28.63 $70.77 $74.10 $152.32 38.59% <-IRR #YR-> 5 Net Income 411.23%
Investment Cash Flow -$76.41 -$101.03 -$76.93 -$14.82 -$78.69 -$14.88 -$13.93 $62.17 $51.16 $2.65 $13.26 -$39.35 -$85.80 #NUM! <-IRR #YR-> 10 5 Yr Running Ave. -278.64%
Total Accruals $70.73 $87.55 $43.43 -$41.01 $45.97 -$60.29 -$54.23 -$180.25 -$384.76 -$104.74 -$318.72 -$17.52 $12.69 43.10% <-IRR #YR-> 5 5 Yr Running Ave. -500.11%
Total Assets $271.31 $407.33 $406.11 $402.71 $638.77 $510.09 $458.03 $1,506.22 $1,037.81 $926.52 $563.21 $577.84 $671.12 Balance Sheet Assets
Accruals Ratio 26.07% 21.49% 10.69% -10.18% 7.20% -11.82% -11.84% -11.97% -37.07% -11.30% -56.59% -3.03% 1.89% -11.30% <-Median-> 5 Ratio
EPS/CF Ratio 0.74 0.58 0.51 -0.13 0.43 -2.17 3.05 0.12 -2.08 -2.33 -10.00 0.17 0.39 -0.01 <-Median-> 10 EPS/CF Ratio
-$54.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $79.2
-$15.5 $0.0 $0.0 $0.0 $0.0 $79.2
-$38.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$88.9
$14.8 $0.0 $0.0 $0.0 $0.0 -$88.9
Change in Close 361.70% 10.14% -5.02% 5.90% -25.21% -54.73% 72.73% -1.34% -71.08% -3.39% 47.37% 64.88% 32.13% 30.60% 0.00% 0.00% Count 17 Years of data
up/down down down down  up down up up up up up up Count 13 76.47%
Meet Prediction? yes Yes Yes yes yes % right Count 7 53.85%
Financial Cash Flow $44.90 -$6.49 -$30.88 -$37.91 -$3.82 -$15.78 $17.38 -$202.67 -$155.67 -$32.84 -$68.67 -$27.84 -$37.83 C F Statement  Financial Cash Flow
Total Accruals $25.83 $94.04 $74.31 -$3.10 $49.79 -$44.51 -$71.61 $22.42 -$229.09 -$71.90 -$250.05 $10.32 $50.52 Accruals
Accruals Ratio 9.52% 23.09% 18.30% -0.77% 7.79% -8.73% -15.63% 1.49% -22.07% -7.76% -44.40% 1.79% 7.53% -7.76% <-Median-> 5 Ratio
Cash $41.25 $42.48 $22.58 $21.31 $20.63 $3.06 $2.47 $12.74 $8.25 $7.20 $22.61 $29.51 $58.11 $40.43 Cash
Cash Per share $0.40 $0.41 $0.21 $0.20 $0.18 $0.03 $0.02 $0.04 $0.03 $0.03 $0.09 $0.12 $0.25 $0.18 $0.09 <-Median-> 5 Cash per Share
Percentage of Stock Price 6.30% 5.83% 3.22% 2.84% 3.35% 1.09% 0.41% 0.92% 2.32% 2.33% 5.26% 4.31% 6.91% 3.68% 4.31% <-Median-> 5 % of Stock Price
Notes:
September 10, 2023.  Last estimates were for 2022, 2023 and 2024 of $880M, $1028M and $1103M for Revenue, $0.27, $0.38 and $0.50 for EPS, 
$36.6M, $126M and $157M for FCF, $0.67, $0.90 and $1.03 for CFPS, and $68.4M, $95.5M and $123M for Net Income.
September 11, 2022.  Last estimates were for 2021, 2022 and 2023 of $560M, $692M and $710M for Revenue, -$0.01, $0.09 and $0.28 for EPS, 
$42.4M, $90.5M and $131M for FCF, $0.38, $0.56 and $0.65 for CFPS, -$2M, $22.6M and $70.5M for Net Income.
September 4, 2021.  Last estimates were for 2020, 2021 and 2022 of $337M, $361M and $476M for Revenue, -$0.86, -$0.24 and -$0.07 for EPS, 
$60.7M, $7.43M and $22.8M for FCF, $.040, $0.09 and $0.32 for CFPS and -$288M, -$64.1M and -$16.9M for Net Income.
September 12, 2020.  Last estimates were for 2019, 2020 and 2021 of $741M, $845M and $921M for Revenue, 
-$0.23, -$0.14 and $0.02 for EPS, $0.14, $0.24 amd $0.31 for CFPS amd -$662M, -$46M and -$1.3M for Net Income.
September 14, 2019.  Last estmates were for 2018, 2019 and 2020 of $1070M, $1197M and $1197M for Revenue, 
-$0.09, $0.22 and $0.24 for EPS,  $0.43, $0.60 and $0.69 for CFPS and -$31.1M, $69.1M and $66.6M for Net Income.
September 22, 2018.  Last estimates were for 2017, 2018 and 2019 of $911M, $1259M and $1488M for Revenue, 
-$0.08, $0.27 and $0.43 for EPS, $0.40, $0.62 and $0.62 for CFPS, -$10.9M and $5.65M for Net Income for 2017 and 2018.
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 Canyon.
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.
December 2014.  Trican Well Services Ltd stopped dividends.
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.
May 2005.  Trican Well Services annouces first dividend.
December 1996.  Trican Well Services went public.
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 used to 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. 
Dividends
Dividendss reinstated 2023, and paid Quarterly, in Cycle 3, of March, June, September and December.
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 an oilfield services company engaged in providing products, equipment, services and technology used in drilling, completion, 
stimulation and reworking of oil and gas wells in Canada, United States and internationally.
How they make their money.
Trican Well Service Ltd is an equipment services company. It provides products, equipment, services, and technology for use in the drilling, completion, stimulation, 
and reworking of oil and gas wells primarily through its continuing pressure pumping operations in Canada. The company offers services related to coiled tubing, 
pipeline service, cementing, fracturing and reservoir solutions.
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 %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2015 Sep 24 2016 Sep 21 2017 Sep 22 2018 Sep 14 2019 Sep 13 2020 Sep 5 2021 Sep 11 2022 Sep 10 2023
Fedora, Bradley 0.70% 0.822 0.56% 1.803 0.66% 0.991 0.39% 0.991 0.40% 0.991 0.43% 0.991 0.43% Was Chairman until 2020 0.00%
CEO - Shares - Amt $1.968 $3.400 $2.055 $1.664 $2.744 $3.626 $4.735
Options - percentage 0.50% 0.460 0.31% 0.098 0.04% 2.296 0.90% 3.410 1.38% 3.802 1.65% 3.802 1.65% 0.00%
Options - amount $1.405 $1.902 $0.112 $3.858 $9.446 $13.915 $18.173
Dusterhoft, Dale M. 0.498 0.15% 0.557 0.18% 0.580 0.21% Ceased as insider Aug 2020
CEO - Shares - Amount $2.03 $0.658 $0.661
Options - percentage 1.892 0.56% 2.138 0.71% 2.938 1.08%
Options - amount $7.72 $2.523 $3.349
Matson, Scott Eric 0.002 0.00% 0.005 0.00% 0.005 0.00% 0.00%
CFO - Shares - Amount $0.006 $0.016 $0.022
Options - percentage 0.210 0.09% 0.349 0.15% 0.349 0.15% 0.00%
Options - amount $0.582 $1.277 $1.668
Skilnick, Robert 0.101 0.03% 0.101 0.04% 0.101 0.04% Ceased insider Mar 2021
CFO - Shares - Amount $0.119 $0.115 $0.170
Options - percentage 0.338 0.11% 0.656 0.24% 1.078 0.42%
Options - amount $0.399 $0.748 $1.811
Thue, Todd filed Apr 2020
Officer - Shares - Amount as Officer
Options - percentage
Options - amount
Onwuekwe, Chika Benjamin 0.012 0.00% 0.022 0.01% 0.052 0.02% 0.052 0.02% 0.052 0.02% 0.00%
Officer - Shares - Amount $0.014 $0.038 $0.143 $0.189 $0.247
Options - percentage 0.395 0.15% 0.640 0.25% 0.669 0.27% 0.638 0.28% 0.638 0.28% 0.00%
Options - amount $0.450 $1.075 $1.854 $2.333 $3.048
Cox, Robert John 0.029 0.01% 0.029 0.01% 0.029 0.01% Ceased insider Aug 2020
Officer - Shares - Amount $0.12 $0.035 $0.033
Options - percentage 0.799 0.24% 0.891 0.30% 1.125 0.41%
Options - amount $3.26 $1.052 $1.282
Stein, Deborah Susan 0.025 0.01% 0.030 0.01% 0.030 0.01% 0.030 0.01% 0.00%
Director - Shares - Amount $0.042 $0.083 $0.110 $0.143
Options - percentage 0.219 0.09% 0.255 0.10% 0.277 0.12% 0.277 0.12% 0.00%
Options - amount $0.367 $0.705 $1.015 $1.325
Bradley, Fedora
Director - Shares - Amount
Options - percentage
Options - amount
Brooks, Gilbert. Allen 0.051 0.02% 0.051 0.02% 0.051 0.02% 0.101 0.04% Lead Director from 2020
Lead Director - Shares - Amount $0.21 $0.060 $0.058 $0.170 Ceased insider May 2021
Options - percentage 0.234 0.07% 0.257 0.09% 0.305 0.11% 0.433 0.17%
Options - amount $0.95 $0.303 $0.348 $0.728
Alford, Thomas 0.020 0.01% 0.040 0.02% 0.040 0.02% 0.00%
Chairman - Shares - Amt $0.055 $0.146 $0.191
Options - percentage 0.088 0.04% 0.164 0.07% 0.164 0.07% 0.00%
Options - amount $0.244 $0.601 $0.785
Increase in O/S Shares 0.58% 0.320 0.27% 0.195 0.13% 0.714 0.21% 0.610 0.20% 0.088 0.03% 1.376 0.54% 1.528 0.62% 2.512 1.09%
due to SO $3.575 $0.766 $0.466 $2.914 $0.719 $0.100 $2.311 $4.232 $9.194
Book Value $4.648 $0.594 $0.284 $1.177 $0.867 $0.104 $1.093 $2.219 $4.439
Insider Buying -$0.168 -$0.121 -$0.044 -$0.070 -$0.025 -$0.069 -$0.108 -$0.118 -$0.118
Insider Selling $2.802 $1.259 $0.930 $0.298 $0.016 $0.106 $0.380 $0.000 $0.000
Net Insider Selling $2.634 $1.137 $0.886 $0.228 -$0.009 $0.037 $0.272 -$0.118 -$0.118
% of Market Cap 0.94% 0.19% 0.06% 0.06% 0.00% 0.01% 0.04% -0.01% -0.01%
Directors 6 8 7 7 5 5 6 6
Women 0% 0 0% 1 13% 1 14% 1 14% 1 20% 2 40% 2 33% 2 33%
Minorities 0% 0 0% 1 13% 1 14% 1 14% 1 20% 1 20% 1 17% 1 17%
Institutions/Holdings 50.09% 55 77.99% 67 34.86% 81 39.62% 20 20 40.36% 20 17.64% 20 32.40% 20 13.92%
Total Shares Held 29.44% 66.883 45.72% 120.730 35.67% 128.164 42.51% 101.687 37.45% 106.837 39.35% 45.111 18.27% 79.019 34.39% 29.325 12.76%
Increase/Decrease 3 Mths 11.50% 5.611 9.16% 35.413 41.51% 1.779 1.41% -8.872 -8.02% 1.234 1.17% -1.304 -2.81% 0.790 1.01% 3.258 12.50%
Starting No. of Shares 61.273 85.317 126.385 110.559 Top 20 105.603 Top 20 MS 46.415 Top 20 MS 78.229 Top 20 MS 26.067 Top 20 MS
Copyright © 2008 Website of SPBrunner. All rights reserved.