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. Estimates Estimates Estimates
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Q2 2024
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/
Trican Well Service Ltd TSX: TCW OTC: TOLWF https://www.tricanwellservice.com/ Fiscal Yr:
Stock FRC FRC FRC FRC FRC TCW TCW TCW TCW TCW TCW TCW TCW TCW TCW TCW
Year 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 12/31/25 12/31/26 12/31/27 Value Description #Y Item
Accounting Rules IFRS 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
$970.0 <-12 mths -1.11%
Revenue* $353.1 $299.8 $591.0 $404.0 $239.6 $929.9 $900.6 $636.1 $397.0 $562.5 $866.3 $972.7 $980.8 $1,070 $1,316 $1,346 65.96% <-Total Growth 10 Revenue
Increase -5.10% -15.10% 97.15% -31.64% -40.70% 288.17% -3.15% -29.37% -37.58% 41.68% 54.01% 12.28% 0.84% 9.09% 22.99% 5.20% <-IRR #YR-> 10 Revenue 65.96%
5 year Running Average $212.1 $257.6 $366.4 $404.0 $377.5 $492.9 $613 $622 $621 $685 $672 $687 $756 $890 $1,041 9.05% <-IRR #YR-> 5 Revenue 54.20%
Revenue per Share $3.36 $2.82 $5.07 $3.44 $1.64 $2.75 $2.99 $2.34 $1.55 $2.28 $3.77 $4.65 $5.19 $5.04 $6.20 7.51% <-IRR #YR-> 10 5 yr Running Average 106.30%
Increase -6.41% -16.03% 79.68% -32.16% -52.36% 67.74% 8.73% -21.56% -33.74% 46.71% 65.53% 23.36% 11.63% -2.89% 22.99% 3.97% <-IRR #YR-> 5 5 yr Running Average 21.52%
5 year Running Average $2.31 $2.49 $3.39 $3.65 $3.26 $3.14 $3.18 $2.63 $2.25 $2.38 $2.59 $2.92 $3.49 $4.19 $4.97 0.24% <-IRR #YR-> 10 Revenue per Share 2.45%
P/S (Price/Sales) Med 2.09 2.34 1.59 1.08 1.86 1.58 0.89 0.54 0.68 1.15 0.99 0.88 0.88 0.97 0.00 17.25% <-IRR #YR-> 5 Revenue per Share 121.59%
P/S (Price/Sales) High 2.61 2.66 2.32 1.53 2.59 2.00 1.44 0.73 1.08 1.59 1.27 1.13 1.00 1.19 0.00 1.35 <-Median-> 10 P/S HighPrice
P/S (Price/Sales) Low 1.58 2.01 0.86 0.63 1.12 1.17 0.34 0.36 0.28 0.71 0.71 0.63 0.76 0.76 0.00 0.67 <-Median-> 10 P/S Low Price
P/S (Price/Sales) Closing 1.99 2.51 1.04 0.70 2.53 1.49 0.40 0.49 1.08 1.22 0.97 0.89 0.99 1.14 0.92 0.29% <-IRR #YR-> 10 5 yr Running Average 2.98%
*Revenue in M CDN $  P/S Med 20 yr  0.76 15 yr  0.71 10 yr  0.94 5 yr  0.88 20.83% Diff M/C 5.81% <-IRR #YR-> 5 5 yr Running Average 32.62%
-$591.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $980.8
-$636.1 $0.0 $0.0 $0.0 $0.0 $980.8
-$366.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $755.9
-$622.0 $0.0 $0.0 $0.0 $0.0 $755.9
-$5.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.19
-$2.34 $0.00 $0.00 $0.00 $0.00 $5.19
-$3.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.49
-$2.63 $0.00 $0.00 $0.00 $0.00 $3.49
Amount $133.7 <-12 mths -2.48% Estimates Last 12 months from Qtr
Per Share $0.36 <-12 mths -46.87% Estimates Last 12 months from Qtr
Payout Ratio Adj EPS 28.77% #DIV/0! Estimates Payout Ratio EPS
Free Cash Flow $7.5 $79.4 $157.0 $161.0 $137.1 72.67% <-Total Growth 4 FCF CDN$
Return on Equity ROE 1.52% 16.22% 31.11% 31.14% 28.07% 28.07% <-Median-> 5 Return on Equity ROE
5Yr Median 23.67% 28.07% 25.87% <-Median-> 2 5 Yr Median
Basic $0.03 $0.31 $0.65 $0.74 $0.69 122.58% <-Total Growth 4 FCF
FCF* Dilued $0.03 $0.31 $0.64 $0.73 $0.67 $0.73 116.13% <-Total Growth 4 FCF
Increase 933.33% 106.45% 14.06% -8.22% 8.96% 5 0 5 Years of Data, EPS P or N #VALUE!
5 year Running Average $0.48 $0.62 #NUM! <-IRR #YR-> 10 FCF #DIV/0!
FCF Yield 1.79% 11.19% 17.49% 17.72% 13.06% 12.74% 117.39% <-IRR #YR-> 4 FCF 2333.33%
Payout Ratio 0.00% 0.00% 0.00% 21.92% 26.87% 28.77% #NUM! <-IRR #YR-> 10 5 yr Running Average #DIV/0!
5 year Running Average 37.82% 34.09% #NUM! <-IRR #YR-> 5 5 yr Running Average #DIV/0!
Price/FCF Median 35.33 8.45 5.84 5.60 6.82 6.73 6.82 <-Median-> 5 Price/FCF Median
Price/FCF High 56.00 11.68 7.47 7.18 7.73 8.21 7.73 <-Median-> 5 Price/FCF High
Price/FCF Low 14.67 5.23 4.20 4.01 5.91 5.26 5.23 <-Median-> 5 Price/FCF Low
Price/FCF Close 56.00 8.94 5.72 5.64 7.66 7.85 7.66 <-Median-> 5 Price/FCF Close
Trailing P/FCF Close 92.33 11.81 6.44 7.03 8.55 9.42 <-Median-> 4 Trailing P/FCF Close
Median Values DPR 10 Yrs 0.00% 5 Yrs   0.00% P/CF 5 Yrs   in order 6.82 7.73 5.23 7.66 15.08% Diff M/C DPR 75% to 95% best
* Adjusted Earnings per Share
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.67
-$0.03 $0.00 $0.00 $0.00 $0.67
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.48
$0.00 $0.00 $0.00 $0.00 $0.00 $0.48
$0.57 <-12 mths 3.64%
EPS Basic $0.52 -$0.04 $0.44 -$0.53 -$0.52 $0.05 -$0.73 -$0.26 -$0.89 $0.07 $0.33 $0.56 $0.55 24.67% <-Total Growth 10 EPS Basic
EPS Diluted* $0.51 -$0.04 $0.44 -$0.53 -$0.52 $0.05 -$0.73 -$0.26 -$0.89 $0.07 $0.32 $0.55 $0.54 $0.59 $0.70 $0.80 24.05% <-Total Growth 10 EPS Diluted
Increase -43.14% -108.05% 1157.14% -221.62% 2.22% 109.66% -1560.00% 64.38% -242.31% 107.87% 357.14% 71.88% -1.82% 9.26% 18.64% 14.29% 5 5 10 Years of Data, EPS P or N
Earnings Yield 7.7% -0.6% 8.2% -22.1% -12.5% 1.2% -61.9% -22.8% -53.0% 2.5% 8.7% 13.3% 10.5% 10.3% 12.2% 14.0% 2.18% <-IRR #YR-> 10 Earnings per Share 24.05%
5 year Running Average $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.12 $0.41 $0.54 $0.64 #NUM! <-IRR #YR-> 5 Earnings per Share 307.69%
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.14 -$0.03 $0.09 $0.17 -12.92% <-IRR #YR-> 10 5 yr Running Average 197.85%
* Diluted ESP per share  E/P 10 Yrs -5.65% 5Yrs 8.74% #NUM! <-IRR #YR-> 5 5 yr Running Average 129.69%
-$0.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.54
$0.26 $0.00 $0.00 $0.00 $0.00 $0.54
-$0.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.12
$0.40 $0.00 $0.00 $0.00 $0.00 $0.12
Dividend* for TCW $0.21 $0.22 $0.24 Estimates Dividend*
Increase 16.67% 4.76% 9.09% Estimates Increase
Payout Ratio EPS 28.77% #DIV/0! Estimates Payout Ratio EPS
Special Dividends TCW $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 $0.00 <-Median-> 10 Special Dividends
Canyon to Trican 2017 $0.51 $0.60 $0.60 $0.41 $0.03
Dividend* TCW $0.30 $0.30 $0.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $0.18 $0.21 $0.22 $0.22 -40.00% <-Total Growth 10 Dividends
Increase 200.00% 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 12.50% 16.67% 4.76% 0.00% 3 1 18 Years of data, Count P, N
Average Increases 5 Year Running 40.00% 40.00% 40.00% 20.00% 20.00% -20.00% -20.00% -20.00% 0.00% 0.00% 0.00% 0.00% 2.50% 5.83% 6.79% 6.79% 0.00% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.14 $0.18 $0.22 $0.20 $0.18 $0.12 $0.06 $0.00 $0.00 $0.00 $0.00 $0.03 $0.07 $0.11 $0.15 $0.20 -69.09% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 4.27% 4.55% 3.72% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.92% 3.94% 4.27% 0.00% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 3.42% 4.00% 2.55% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.05% 3.47% 3.51% 0.00% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 5.67% 5.28% 6.87% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 5.46% 4.55% 5.47% 0.00% <-Median-> 10 Yield on Low Price CFPS
Yield on Close Price 4.49% 4.24% 5.67% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.88% 3.51% 3.66% 3.84% 3.84% 0.00% <-Median-> 10 Yield on Close Price FCF Comp.
Payout Ratio EPS 58.62% 0.00% 68.92% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 29.09% 33.33% 35.59% 31.43% 27.50% 0.00% <-Median-> 10 DPR EPS FCF 
DPR EPS 5 Yr Running 42.20% 53.87% 46.75% 78.34% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 57.63% 26.57% 28.52% 31.13% 0.00% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 35.9% 62.0% 42.8% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 13.5% 22.0% 20.1% 17.5% 15.4% 0.00% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 25.62% 30.61% 30.09% 31.43% 42.74% 36.06% 19.80% 0.00% 0.00% 0.00% 0.00% 6.32% 10.47% 13.70% 15.49% 17.25% 8.39% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 29.90% 97.62% 29.36% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 16.53% 15.17% 20.10% 17.53% 15.38% 0.00% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 19.98% 25.05% 23.81% 24.22% 37.40% 32.68% 15.96% 0.00% 0.00% 0.00% 0.00% 6.65% 9.77% 12.40% 14.58% 16.82% 8.21% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 10 Yr Med 10 Yr Cl 0.00% 0.00% 5 Yr Med 5 Yr Cl 0.00% 0.00% 5 Yr Med Payout 0.00% 0.00% 0.00% 0.00% <-IRR #YR-> 5 Dividends -40.00%
* Dividends per share  10 Yr Med and Cur. #DIV/0! #DIV/0! 5 Yr Med and Cur. #DIV/0! #DIV/0! Last Div Inc ---> $0.500 $0.550 10.0% -4.98% <-IRR #YR-> 10 Dividends #DIV/0!
Dividends Growth 15 4.00% <-IRR #YR-> 15 Dividends
Dividends Growth 20 7.38% <-IRR #YR-> 18 Dividends
Dividends Growth 5 $0.00 $0.00 $0.00 $0.00 $0.00 $0.18 Dividends Growth 5
Dividends Growth 10 -$0.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.18 Dividends Growth 10
Dividends Growth 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 $0.18 Dividends Growth 15
Dividends Growth 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 $0.18 Dividends Growth 20
Historical Dividends Historical High Div 7.08% Low Div 0.00% 10 Yr High 5.37% 10 Yr Low 0.00% Med Div 4.10% Close Div 1.57% Historical Dividends
High/Ave/Median Values Curr diff Exp. -45.77% #DIV/0! #DIV/0! Exp. -28.50% #DIV/0! Exp. -6.36% Cheap 145.05% High/Ave/Median 
Dividend* $0.21 $0.22 $0.24 Estimates Dividend*
Increase 16.67% 4.76% 9.09% Estimates Increase
Payout Ratio EPS 35.59% 31.43% 30.00% Estimates Payout Ratio EPS
Special Dividends Canyon to Trican $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.51 $0.60 $0.60 $0.41 $0.03
Dividend* $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.18 $0.21 $0.22 $0.22 -49.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% 12.50% 16.67% 4.76% 0.00% 3 3 13 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% 2.50% 5.83% 6.79% 6.79% -10.00% <-Median-> 10 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.07 $0.11 $0.15 $0.20 #DIV/0! <-Total Growth 9 Dividends 5 Yr Running
Yield H/L Price 4.29% 5.36% 4.38% 6.41% 0.58% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.92% 3.94% 4.27% 0.00% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 3.44% 4.71% 3.00% 4.52% 0.42% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.05% 3.47% 3.51% 0.00% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 5.69% 6.21% 8.09% 11.04% 0.96% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 5.46% 4.55% 5.47% 0.00% <-Median-> 10 Yield on Low Price CFPS
Yield on Close Price 4.52% 4.99% 6.67% 9.95% 0.43% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.88% 3.51% 3.66% 3.84% 3.84% 0.00% <-Median-> 10 Yield on Close Price FCF 
Payout Ratio EPS 58.91% 0.00% 81.08% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 29.09% 33.33% 35.59% 31.43% 27.50% 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% 57.63% 26.57% 28.52% 31.13% 0.00% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 36.1% 72.9% 50.3% 213.7% -64.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 13.5% 22.0% 20.1% 17.5% 15.4% 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.32% 10.47% 13.70% 15.49% 17.25% 19.16% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 30.05% 114.85% 34.54% 97.86% -10.41% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 16.53% 15.17% 20.1% 17.5% 15.4% 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.65% 9.77% 12.40% 14.58% 16.82% 18.08% <-Median-> 10 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 -49.00%
* Dividends per share  10 Yr Med and Cur. #DIV/0! #DIV/0! 5 Yr Med and Cur. -11.36% #DIV/0! Last Div Inc ---> $0.450 $0.500 11.1% -6.51% <-IRR #YR-> 10 Dividends #DIV/0!
Dividends Growth 15 8.98% <-IRR #YR-> 13 Dividends
Dividends Growth 5 $0.00 $0.00 $0.00 $0.00 $0.00 $0.18 Dividends Growth 5
Dividends Growth 10 -$0.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.18 Dividends Growth 10
Dividends Growth 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 $0.18 Dividends Growth 15
Historical Dividends Historical High Div 6.21% Low Div 0.00% 10 Yr High 10.48% 10 Yr Low 0.00% Med Div 0.70% Close Div 0.63% Historical Dividends
High/Ave/Median Values Curr diff Exp. -38.17% #DIV/0! #DIV/0! Exp. -63.36% #DIV/0! Cheap 448.49% Cheap 507.72% High/Ave/Median 
Future Dividend Yield Div Yield 3.84% earning in 5 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yield 3.84% earning in 10 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yield 3.84% earning in 15 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Paid Div Paid $0.22 earning in 5 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Future Dividend Paid Div Paid $0.22 earning in 10 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Future Dividend Paid Div Paid $0.22 earning in 15 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Paid
Dividend Covering Cost Total Div $1.10 over 5 Years at IRR of 0.00% Div Cov. 19.20% Dividend Covering Cost
Dividend Covering Cost Total Div $1.98 over 10 Years at IRR of 0.00% Div Cov. 34.55% Dividend Covering Cost
Dividend Covering Cost Total Div $2.86 over 15 Years at IRR of 0.00% Div Cov. 49.91% Dividend Covering Cost
Yield if held 5 years 13.23% 20.87% 35.29% 5.82% 0.25% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 6.02% 14.12% 19.81% 8.40% 5.89% 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% 2.23% 5.65% 7.23% 5.06% 0.00% <-Median-> 9 Paid Median Price
Yield if held 15 years 0.00% 0.00% 9.46% 18.00% 5.13% 3.07% 3.13% 4.73% <-Median-> 4 Paid Median Price
Yield if held 20 years 3.84% 9.65% #NUM! <-Median-> 0 Paid Median Price
Cost cover if held 5 years 15.81% 42.17% 106.62% 31.86% 17.64% 13.68% 9.24% 3.17% 0.48% 0.00% 0.00% 6.02% 26.67% 51.89% 29.39% 26.51% 7.63% <-Median-> 10 Paid Median Price
Cost cover if held 10 years 23.05% 58.00% 78.17% 132.21% 32.29% 17.64% 13.68% 11.67% 7.39% 15.28% 25.32% 22.76% 23.05% <-Median-> 9 Paid Median Price
Cost cover if held 15 years 23.05% 58.00% 87.63% 166.21% 45.73% 28.39% 27.75% 72.82% <-Median-> 4 Paid Median Price
Cost cover if held 20 years 36.48% 101.43% #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $636.1 $397.0 $562.5 $866.3 $972.7 $980.8 $970 <-12 mths -1.11% 54.20% <-Total Growth 5 Revenue Growth  54.20%
EPS Growth -$0.26 -$0.89 $0.07 $0.32 $0.55 $0.54 $0.57 <-12 mths 5.56% 307.69% <-Total Growth 5 EPS Growth 307.69%
Net Income Growth -$73.5 -$234.7 $17.2 $79.2 $121.0 $109.5 $103 <-12 mths -5.52% 249.04% <-Total Growth 5 Net Income Growth 249.04%
Cash Flow Growth $28.6 $70.8 $74.1 $152.3 $248.5 $154.8 $217 <-12 mths 40.14% 440.89% <-Total Growth 5 Cash Flow Growth 440.89%
Dividend Growth $0.00 $0.00 $0.00 $0.00 $0.16 $0.18 $0.21 <-12 mths 16.67% 0.00% <-Total Growth 5 Dividend Growth 0.00%
Stock Price Growth $1.14 $1.68 $2.77 $3.66 $4.12 $5.13 $5.73 <-12 mths 11.70% 350.00% <-Total Growth 5 Stock Price Growth 350.00%
Revenue Growth  $591.0 $404.0 $239.6 $929.9 $900.6 $636.1 $397.0 $562.5 $866.3 $972.7 $980.8 $1,070 <-this year 9.09% 65.96% <-Total Growth 10 Revenue Growth  65.96%
EPS Growth $0.44 -$0.53 -$0.52 $0.05 -$0.73 -$0.26 -$0.89 $0.07 $0.32 $0.55 $0.54 $0.59 <-this year 9.26% 24.05% <-Total Growth 10 EPS Growth 24.05%
Net Income Growth $49.1 -$62.1 -$72.2 $15.5 -$232.7 -$73.5 -$234.7 $17.2 $79.2 $121.0 $109.5 $117 <-this year 7.14% 123.00% <-Total Growth 10 Net Income Growth 123.00%
Cash Flow Growth $81.8 $13.1 -$4.0 $133.6 $100.9 $28.6 $70.8 $74.1 $152.3 $248.5 $154.8 $222 <-this year 43.23% 89.24% <-Total Growth 10 Cash Flow Growth 89.24%
Dividend Growth $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $0.18 $0.21 <-this year 16.67% -49.00% <-Total Growth 10 Dividend Growth -49.00%
Stock Price Growth $5.29 $2.39 $4.14 $4.08 $1.18 $1.14 $1.68 $2.77 $3.66 $4.12 $5.13 $5.73 <-this year 11.70% -2.99% <-Total Growth 10 Stock Price Growth -2.99%
Dividends on Shares $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $28.80 $32.40 $37.80 $39.60 $39.60 $61.20 No of Years 10 Total Divs 12/31/14
Paid  $1,002.60 $115.20 $828.00 $734.40 $212.40 $205.20 $302.40 $498.60 $658.80 $741.60 $923.40 $1,031.40 $1,031.40 $1,031.40 $923.40 No of Years 10 Worth $5.57
Total $984.60
Graham Number $6.08 $5.71 $5.94 $5.38 $4.80 $1.98 $1.77 $1.75 $1.47 $1.77 $3.98 $5.53 $5.60 $5.46 $5.95 $6.36 -5.69% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.16 1.15 1.36 0.69 0.63 2.20 1.50 0.73 0.72 1.48 0.94 0.74 0.82 0.90 0.78 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.44 1.31 1.98 0.98 0.88 2.78 2.42 0.98 1.14 2.05 1.20 0.95 0.92 1.10 1.06 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.87 0.99 0.73 0.40 0.38 1.62 0.58 0.48 0.30 0.92 0.68 0.53 0.71 0.70 0.56 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.10 1.24 0.89 0.45 0.86 2.06 0.66 0.65 1.14 1.57 0.92 0.74 0.92 1.05 0.96 0.90 0.89 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 9.77% 23.75% -11.01% -55.48% -13.88% 106.37% -33.51% -34.95% 14.16% 56.79% -7.96% -25.52% -8.46% 4.96% -3.64% -9.87% -11.17% <-Median-> 10 Graham Price
Canyon to Trican 2017 $11.35 $12.02 $8.99 $4.07 $7.03
Price Close TCW $13.12 $12.98 $5.57 $0.64 $4.60 $4.08 $1.18 $1.14 $1.68 $2.77 $3.66 $4.12 $5.13 $5.73 $5.73 $5.73 701.56% <-Total Growth 10 Stock Price
Increase -25.24% -1.07% -57.09% -88.51% 618.75% -11.30% -71.08% -3.39% 47.37% 64.88% 32.13% 12.57% 24.51% 11.70% 0.00% 0.00% #DIV/0! <-Median-> 10 CAPE (10 Yr P/E)
P/E #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 81.60 -1.62 -4.38 -1.89 39.57 11.44 7.49 9.50 9.71 8.19 7.16 35.10% <-IRR #YR-> 5 Stock Price 350.00%
Trailing P/E #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -7.88 23.60 -1.56 -6.46 -3.11 52.29 12.88 9.33 10.61 9.71 8.19 -0.82% <-IRR #YR-> 10 Stock Price -7.90%
CAPE (10 Yr P/E) #DIV/0! #DIV/0! #DIV/0! 38.64 31.15 31.16 -15.68 -14.57 -17.49 -27.43 -36.72 16.81 #DIV/0! #DIV/0! 37.14% <-IRR #YR-> 5 Price & Dividend 408.89%
Median 10, 5 Yrs D.  per yr 0.64% 2.04% % Tot Ret 0.00% 5.50% T P/E #DIV/0! 9.33 P/E:  #DIV/0! 9.50 -0.18% <-IRR #YR-> 10 Price & Dividend 4.15%
Price 15 D.  per yr 1.02% % Tot Ret -18.68% CAPE Diff #DIV/0! -6.50% <-IRR #YR-> 15 Stock Price -63.51%
Price 20 D.  per yr 1.11% % Tot Ret -37.22% -4.09% <-IRR #YR-> 20 Stock Price
Price 25 D.  per yr 2.74% % Tot Ret 31.57% 5.95% <-IRR #YR-> 25 Stock Price
Price 30 D.  per yr 3.20% % Tot Ret 27.33% 8.52% <-IRR #YR-> 28 Stock Price
Price & Dividend 15 -5.48% <-IRR #YR-> 15 Price & Dividend -34.26%
Price & Dividend 20 -2.98% <-IRR #YR-> 20 Price & Dividend
Price & Dividend 25 8.69% <-IRR #YR-> 25 Price & Dividend
Price & Dividend 30 11.72% <-IRR #YR-> 28 Price & Dividend
Price  5 -$1.14 $0.00 $0.00 $0.00 $0.00 $5.13 Price  5
Price 10 -$5.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.13 Price 10
Price & Dividend 5 -$1.14 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 5
Price & Dividend 10 -$5.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 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 $5.13 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 $5.13 Price 20
Price 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.13 Price 25
Price 30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.13 Price 30
Price & Dividend 15 $0.30 $0.30 $0.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 15
Price & Dividend 20 $0.30 $0.30 $0.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 20
Price & Dividend 25 $0.30 $0.30 $0.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 25
Price & Dividend 30 $0.30 $0.30 $0.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 30
Price Close FRC to TCW $6.68 $7.07 $5.29 $2.39 $4.14 $4.08 $1.18 $1.14 $1.68 $2.77 $3.66 $4.12 $5.13 $5.73 $5.73 $5.73 114.28% <-Total Growth 10 Stock Price
Increase -5.02% 5.90% -25.21% -54.73% 72.73% -1.34% -71.08% -3.39% 47.37% 64.88% 32.13% 12.57% 24.51% 11.70% 0.00% 0.00% 7.91 <-Median-> 10 CAPE (10 Yr P/E)
P/E 13.05 -171.71 12.15 -4.52 -7.99 81.60 -1.62 -4.38 -1.89 39.57 11.44 7.49 9.50 9.71 8.19 7.16 35.10% <-IRR #YR-> 5 Stock Price 350.00%
Trailing P/E 7.42 13.82 -128.43 5.50 -7.81 -7.88 23.60 -1.56 -6.46 -3.11 52.29 12.88 9.33 10.61 9.71 8.19 -0.30% <-IRR #YR-> 10 Stock Price -2.99%
CAPE (10 Yr P/E) 18.15 30.38 54.70 42.53 120.42 31.16 -15.68 -14.57 -17.49 -27.43 -36.72 -206.38 60.96 33.91 37.14% <-IRR #YR-> 5 Price & Dividend 379.82%
Median 10, 5 Yrs D.  per yr 1.14% 2.04% % Tot Ret 136.31% 5.50% T P/E 1.97 9.33 P/E:  2.94 9.50 0.84% <-IRR #YR-> 10 Price & Dividend 8.28%
Price 15 D.  per yr 6.06% % Tot Ret 39.89% CAPE Diff 22.82% 9.14% <-IRR #YR-> 15 Stock Price 271.11%
Price 20 D.  per yr 2.48% % Tot Ret 43.67% 3.20% <-IRR #YR-> 18 Stock Price
Price & Dividend 15 15.20% <-IRR #YR-> 15 Price & Dividend 391.34%
Price & Dividend 20 5.67% <-IRR #YR-> 18 Price & Dividend
Price  5 -$1.14 $0.00 $0.00 $0.00 $0.00 $5.13 Price  5
Price 10 -$5.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.13 Price 10
Price & Dividend 5 -$1.14 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 5
Price & Dividend 10 -$5.29 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 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 $5.13 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 $5.13 Price 20
Price & Dividend 15 $0.30 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 15
Price & Dividend 20 $0.30 $0.35 $0.35 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $5.31 Price & Dividend 20
Price H/L Median $7.03 $6.59 $8.06 $3.71 $3.04 $4.35 $2.66 $1.28 $1.06 $2.62 $3.74 $4.09 $4.57 $4.92 23.02% <-Total Growth 10 Stock Price
Increase -1.81% -6.32% 22.41% -53.94% -18.13% 43.04% -38.85% -52.07% -16.86% 147.17% 42.56% 9.37% 11.87% 7.55% -5.52% <-IRR #YR-> 10 Stock Price -43.33%
P/E 13.74 -160.00 18.53 -7.02 -5.88 87.00 -3.64 -4.90 -1.19 37.43 11.67 7.43 8.46 8.33 29.09% <-IRR #YR-> 5 Stock Price 258.43%
Trailing P/E 7.81 12.87 -195.86 8.53 -5.74 -8.40 53.20 -1.75 -4.08 -2.94 53.36 12.77 8.31 9.10 -4.53% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 21.20 19.72 17.14 14.55 -107.71 -36.07 -10.30 -3.21 -2.26 -7.44 -12.53 -97.26 38.73 11.87 31.22% <-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.20 -32.71 -177.02 7.43 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 747.26% -31.22% % Tot Ret 100.61% 0.00% T P/E 3.28 8.31 P/E:  3.12 8.46 Count 18 Years of data
-$8.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.57
-$1.28 $0.00 $0.00 $0.00 $0.00 $4.57
-$8.06 $0.24 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.16 $4.75
-$1.28 $0.00 $0.00 $0.00 $0.16 $4.75
High Months Mar Aug Jul Apr Dec Feb Jan Apr Dec Nov Jun Sep Aug Aug
Canyon to Trican 2017 $14.91 $12.74 $20.00 $8.96 $7.21
Price High $8.77 $7.49 $11.76 $5.27 $4.24 $5.49 $4.29 $1.71 $1.68 $3.62 $4.78 $5.24 $5.18 $5.99 -1.72% <-Total Growth 10 Stock Price
Increase -6.23% -14.55% 56.99% -55.20% -19.53% 29.45% -21.86% -60.14% -1.75% 115.48% 32.04% 9.62% -1.15% 15.64% -7.88% <-IRR #YR-> 10 Stock Price -55.97%
P/E 17.14 -182.00 27.03 -9.96 -8.19 109.80 -5.88 -6.58 -1.89 51.71 14.94 9.53 9.59 10.15 24.81% <-IRR #YR-> 5 Stock Price 202.92%
Trailing P/E 9.75 14.64 -285.71 12.11 -8.01 -10.61 85.80 -2.34 -6.46 -4.07 68.29 16.38 9.42 11.09 9.53 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 3.54 9.42 P/E:  3.82 9.59 27.03 P/E Ratio Historical High
-$11.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.18
-$1.71 $0.00 $0.00 $0.00 $0.00 $5.18
Low Months Jul Apr Dec Dec Jan Jun Dec Nov Mar Jan Sep Mar Feb Apr
Price Low $5.29 $5.68 $4.36 $2.16 $1.84 $3.21 $1.03 $0.84 $0.44 $1.62 $2.69 $2.93 $3.96 $3.84 83.43% <-Total Growth 10 Stock Price
Increase 6.51% 7.33% -23.19% -50.54% -14.71% 74.35% -67.91% -18.45% -47.62% 268.18% 66.05% 8.92% 35.15% -3.03% -0.97% <-IRR #YR-> 10 Stock Price -9.27%
P/E 10.34 -138.00 10.03 -4.08 -3.56 64.20 -1.41 -3.23 -0.49 23.14 8.41 5.33 7.33 6.51 36.36% <-IRR #YR-> 5 Stock Price 371.43%
Trailing P/E 5.88 11.10 -106.00 4.96 -3.48 -6.20 20.60 -1.15 -1.69 -1.82 38.43 9.16 7.20 7.11 2.58 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 1.90 7.20 P/E:  2.42 7.33 -4.08 P/E Ratio Historical Low
-$4.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.96
MS etc.
Free Cash Flow Mkr Sc -$258.00 $64.00 -$29.00 $102.70 -$95.38 $103.27 $25.52 -$4.60 $57.98 $20.21 $48.61 $169.20 $137.10 138.5 178.5 137.1
Change 4.44% 124.81% -145.31% 454.12% -192.88% 208.27% -75.28% -118.02% 1360.43% -65.14% 140.52% 248.08% -18.97% 1.02% 28.88% -23.19%
Free Cash Flow Company $7.5 $79.4 $157.0 $161.0 $137.1
Change 958.67% 97.73% 2.55% -14.84%
Free Cash Flow MS chage in 2024 $134.21 -$171.51 -$97.78 $144.67 -$2.78 -$4.43 $7.55 $48.45 $84.66 $120.76 $85.03
Change -227.79% 42.99% 247.95% -101.92% -59.35% 270.43% 541.72% 74.74% 42.64% -29.59% $85.03 <-12 mths 0.00%
$93.10 <-12 mths 16.70%
Free Cash Flow  WSJ -$258.00 $64.00 -$29.00 $102.70 -$95.38 $103.27 $25.52 -$4.60 $57.98 $20.21 $48.61 $169.17 $79.78 $120.8 $120.9 -22.32% <-Total Growth 10 Free Cash Flow
Change 4.44% 124.81% -145.31% 454.12% -192.88% 208.27% -75.28% -118.02% 1360.43% -65.14% 140.53% 248.00% -52.84% 51.43% 0.08% #NUM! <-IRR #YR-> 5 Free Cash Flow MS 1834.24%
FCF/CF from Op Ratio -2.93 1.24 -0.35 7.84 23.64 0.77 0.25 -0.16 0.82 0.27 0.32 0.68 0.52 0.54 0.45 #NUM! <-IRR #YR-> 10 Free Cash Flow MS 375.09%
Dividends paid $31.26 $37.11 $37.52 $22.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.34 $34.34 $39.67 $46.69 53.55% <-Total Growth 10 Dividends paid
Percentage paid 21.78% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 20.30% 43.05% 32.84% 38.62% $0.00 <-Median-> 10 Percentage paid
5 Year Coverage 17.01% 0.00% 0.00% 0.00% 11.79% 18.28% 24.71% 28.75% 5 Year Coverage
Dividend Coverage Ratio 4.59 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.93 2.32 3.04 2.59 0.00 <-Median-> 10 Dividend Coverage Ratio
5 Year of Coverage 5.88 0.00 0.00 0.00 8.48 5.47 4.05 3.48 5 Year of Coverage
Market Cap $702.0 $751.6 $616.7 $281.3 $604.9 $1,381.1 $355.8 $309.5 $429.6 $684.1 $841.0 $861.6 $969.2 $1,216.1 $1,216.1 $1,216.1 244.49% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 103.921 105.966 113.162 117.099 139.407 284.615 322.125 322.125 263.830 257.786 246.655 221.451 221.451 255.366 95.69% <-Total Growth 10 Diluted
Change 0.74% 1.97% 6.79% 3.48% 19.05% 104.16% 13.18% 0.00% -18.10% -2.29% -4.32% -10.22% 0.00% 15.31% 0.00% <-Median-> 10 Change
Difference Diluted/Basic 0.0% 0.0% -1.3% 0.0% 0.0% -1.0% 0.0% 0.0% 0.0% -1.8% -2.1% -2.1% -2.1% 0.0% -0.49% <-Median-> 10 Difference Diluted/Basic
Calc Average # basic 103.927 106.250 111.280 117.230 139.475
Canyon to Trican 2017 61.130 62.333 65.699 68.882 82.004
Basic # of Shares in Millions 103.921 105.966 111.688 117.099 139.407 281.817 322.125 322.125 263.830 253.154 241.410 216.910 216.910 255.366 94.21% <-Total Growth 10 Basic
Change 0.74% 1.97% 5.40% 4.84% 19.05% 102.15% 14.30% 0.00% -18.10% -4.05% -4.64% -10.15% 0.00% 17.73% 0.00% <-Median-> 10 Change
Difference Basic/Outstanding 1.2% 0.3% 4.4% 0.4% 4.9% 20.1% -6.4% -15.7% -3.1% -2.4% -4.8% -3.6% -12.9% -16.9% -3.33% <-Median-> 10 Difference Basic/Outstanding
$216.99 <-12 mths 40.14%
# of Share in Millions 105.138 106.298 116.627 117.511 146.283 338.506 301.505 271.490 255.736 246.965 229.777 209.133 188.924 212.231 212.231 212.231 4.94% <-IRR #YR-> 10 Shares 61.99%
Change 1.40% 1.10% 9.72% 0.76% 24.48% 131.40% -10.93% -9.96% -5.80% -3.43% -6.96% -8.98% -9.66% 12.34% 0.00% 0.00% -6.99% <-IRR #YR-> 5 Shares -30.41%
Cash Flow from Operations $M $87.9 $51.5 $81.8 $13.1 -$4.0 $133.6 $100.9 $28.6 $70.8 $74.1 $152.3 $248.5 $154.8 $221.8 $266.3 $303.5 89.24% <-Total Growth 10 Cash Flow
Increase -19.16% -41.48% 59.03% -83.99% -130.80% -3410.48% -24.43% -71.64% 147.20% 4.71% 105.58% 63.11% -37.68% 43.23% 20.10% 13.94% SO S. Issues
5 year Running Average $53.2 $61.4 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $81.8 $170.3 $208.8 $239.0 0.00% <-Total Growth 10 CF 5 Yr Running
CFPS $0.84 $0.48 $0.70 $0.11 -$0.03 $0.39 $0.33 $0.11 $0.28 $0.30 $0.66 $1.19 $0.82 $1.05 $1.26 $1.43 16.82% <-Total Growth 10 Cash Flow per Share
Increase -20.28% -42.11% 44.95% -84.11% -124.74% -1530.61% -15.16% -68.50% 162.43% 8.42% 120.95% 79.21% -31.01% 27.50% 20.10% 13.94% 6.59% <-IRR #YR-> 10 Cash Flow 89.24%
5 year Running Average $0.55 $0.59 $0.73 $0.64 $0.42 $0.33 $0.30 $0.18 $0.22 $0.28 $0.34 $0.51 $0.65 $0.80 $0.99 $1.15 40.16% <-IRR #YR-> 5 Cash Flow 440.89%
P/CF on Med Price 8.41 13.61 11.50 33.32 -110.25 11.02 7.95 12.09 3.83 8.73 5.63 3.44 5.58 4.70 0.00 0.00 1.57% <-IRR #YR-> 10 Cash Flow per Share 16.82%
P/CF on High Price 10.49 15.48 16.77 47.27 -153.76 13.91 12.81 16.22 6.07 12.07 7.21 4.41 6.32 5.73 0.00 0.00 50.70% <-IRR #YR-> 5 Cash Flow per Share 677.28%
-15.58% Diff M/C -1.18% <-IRR #YR-> 10 CFPS 5 yr Running 114.36%
$263.01 <-12 mths 17.36%
Excl.Working Capital CF $17.6 -$18.8 $37.4 $15.5 -$20.8 $12.9 $5.0 $1.7 -$48.0 $27.1 $37.5 -$46.0 $69.3 $0.0 $0.0 $0.0 28.73% <-IRR #YR-> 5 CFPS 5 yr Running 253.44%
CF fr Op $M WC $105.5 $32.7 $119.2 $28.6 -$24.8 $146.5 $105.9 $30.3 $22.8 $101.2 $189.9 $202.4 $224.1 $221.8 $266.3 $303.5 88.02% <-Total Growth 10 Cash Flow less WC
Increase -34.49% -69.03% 264.86% -76.00% -186.65% -690.89% -27.70% -71.36% -24.93% 344.27% 87.69% 6.62% 10.70% -1.04% 20.10% 13.94% 6.52% <-IRR #YR-> 10 Cash Flow less WC 88.02%
5 year Running Average $69.9 $74.8 $98.7 $89.4 $52.2 $60.4 $75.1 $57.3 $56.1 $81.3 $90.0 $109.3 $148.1 $187.9 $220.9 $243.6 49.18% <-IRR #YR-> 5 Cash Flow less WC 638.78%
CFPS Excl. WC $1.00 $0.31 $1.02 $0.24 -$0.17 $0.43 $0.35 $0.11 $0.09 $0.41 $0.83 $0.97 $1.19 $1.05 $1.26 $1.43 4.13% <-IRR #YR-> 10 CF less WC 5 Yr Run 97.22%
Increase -35.39% -69.37% 232.55% -76.18% -169.61% -355.35% -18.83% -68.19% -20.31% 360.04% 101.73% 17.15% 22.54% -11.90% 20.10% 13.94% 20.91% <-IRR #YR-> 5 CF less WC 5 Yr Run 158.38%
5 year Running Average $0.70 $0.72 $0.92 $0.83 $0.48 $0.37 $0.38 $0.19 $0.16 $0.28 $0.36 $0.48 $0.70 $0.89 $1.06 $1.18 17.16% <-IRR #YR-> 10 CFPS - Less WC 16.07%
P/CF on Med Price 7.01 21.44 7.89 15.26 -17.95 10.05 7.57 11.41 11.90 6.40 4.52 4.22 3.85 4.70 0.00 0.00 60.40% <-IRR #YR-> 5 CFPS - Less WC 961.66%
P/CF on High Price 8.74 24.39 11.51 21.65 -25.03 12.69 12.21 15.30 18.87 8.84 5.78 5.41 4.37 5.73 0.00 0.00 10.53 <-Median-> 10 P/CF on High 
P/CF on Low Price 5.28 18.49 4.27 8.87 -10.87 7.42 2.93 7.52 4.94 3.95 3.26 3.03 3.34 3.67 0.00 0.00 3.65 <-Median-> 10 P/CF on Low 
P/CF on Closing Price 6.66 23.01 5.17 9.83 -24.40 9.43 3.36 10.20 18.87 6.76 4.43 4.26 4.32 5.48 4.57 4.01 -2.80% <-IRR #YR-> 10 CFPS 5 yr Running 85.07%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 6.79 5 yr  5.58 P/CF Med 10 yr 6.98 5 yr  4.52 -17.93% Diff M/C 29.11% <-IRR #YR-> 5 CFPS 5 yr Running 258.80%
-$0.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.82 Cash Flow per Share
-$0.11 $0.00 $0.00 $0.00 $0.00 $0.82 Cash Flow per Share
-$0.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.65 CFPS 5 yr Running
-$0.18 $0.00 $0.00 $0.00 $0.00 $0.65 CFPS 5 yr Running
-$119.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $224.1 Cash Flow less WC
-$30.3 $0.0 $0.0 $0.0 $0.0 $224.1 Cash Flow less WC
-$98.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $148.1 CF less WC 5 Yr Run
-$57.3 $0.0 $0.0 $0.0 $0.0 $148.1 CF less WC 5 Yr Run
-$0.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.19 CFPS - Less WC
-$0.11 $0.00 $0.00 $0.00 $0.00 $1.19 CFPS - Less WC
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.70 CFPS 5 yr Running
-$0.19 $0.00 $0.00 $0.00 $0.00 $0.70 CFPS 5 yr Running
OPM 24.90% 17.16% 13.84% 3.24% -1.68% 14.36% 11.21% 4.50% 17.82% 13.17% 17.58% 25.54% 15.79% 20.73% 14.03% <-Total Growth 10 OPM
Increase -14.82% -31.06% -19.33% -76.57% -151.93% 952.85% -21.97% -59.85% 296.04% -26.09% 33.48% 45.27% -38.20% 31.30% Should increase  or be stable.
Diff from Median 80.8% 24.6% 0.5% -76.4% -112.2% 4.3% -18.6% -67.3% 29.5% -4.3% 27.7% 85.5% 14.7% 50.5% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 13.77% 5 Yrs 17.58% should be  zero, it is a   check on calculations
$169.3 <-12 mths 13.97% Earnings before Interest, Taxes
Adjusted EBIT Mkt Scn $14.22 $110.20 $161.60 $148.50 $161.30 $205.80 $210.40 944.30% <-Total Growth 3 Adjusted EBIT Mkt Scn
Change 674.96% 46.64% -8.11% 8.62% 27.59% 2.24% 46.64% <-Median-> 3 Change
Margin 2.53% 12.72% 16.61% 15.14% 15.07% 15.64% 15.63% 13.93% <-Median-> 4 Margin
$212.9 <-12 mths -5.86%
Adjusted EBITDA Mkt Scn $30.37 $14.62 $101.60 $197.80 $238.80 $226.10 241 306.6 327.8 644.48% <-Total Growth 5 Adjusted EBITDA Mkt Scn
Change -51.86% 594.94% 94.69% 20.73% -5.32% 6.59% 27.22% 6.91% 20.73% <-Median-> 5 Change
Margin 4.77% 3.68% 18.06% 22.83% 24.55% 23.05% 22.52% 23.30% 24.35% 20.45% <-Median-> 6 Margin
$211.9 <-12 mths -3.33%
Adjusted EBITDA -$37.40 $183.30 $89.50 $28.00 $14.60 $101.60 $188.50 $235.60 $219.20 $239.10 $305.20 686.10% <-Total Growth 8 Adjusted EBITDA Depreciation and Amortization
Change 590.11% -51.17% -68.72% -47.86% 595.89% 85.53% 24.99% -6.96% 9.08% 27.65% 9.01% <-Median-> 8 Change 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% 24.22% 22.35% 22.35% 23.19% 18.06% <-Median-> 9 Margin Estimates TD Cowen
$221.2 <-12 mths -4.31%
Adjusted EBITDAS $23.10 $106.10 $197.80 $243.14 $231.20 $248.50 $317.20 900.87% <-Total Growth 4 Adjusted EBITDAS S=And Share- Based Comp.
Change 359.31% 86.43% 22.92% -4.91% 7.48% 27.65% 54.67% <-Median-> 4 Change Estimates TD Cowen
Margin 5.82% 18.86% 22.83% 25.00% 23.57% 23.22% 24.10% 22.83% <-Median-> 5 Margin
Long Term Debt $30.00 $60.00 $25.00 $83.36 $45.91 $46.22 $0.00 $0.00 $29.82 $0.00 $0.00 $0.00 #DIV/0! <-Total Growth 10 Debt
Change 100.00% -58.33% 233.44% -44.93% 0.67% -100.00% 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% <-Median-> 10 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.00 0.00 0.04 <-Median-> 10 % 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 4.92 5.04 6.01 8.26 <-Median-> 10 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.00 0.00 0.10 <-Median-> 10 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 $0.00 $0.00 #DIV/0! <-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 $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 $0.00 $0.00 #DIV/0! <-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% #DIV/0! #DIV/0! #DIV/0! <-Median-> 9 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.00 0.00 0.07 <-Median-> 10 % of Market C. Liq. + CF
Debt Ratio
Current Assets $106.08 $119.05 $169.86 $91.02 $82.31 $292.08 $201.45 $232.74 $122.46 $181.34 $263.26 $297.63 $263.44 $220.52 55.09% <-Total Growth 10 Current Assets Leverage
Current Liabilities $49.83 $77.32 $147.98 $63.44 $54.04 $150.94 $85.83 $92.93 $60.63 $77.58 $93.90 $144.44 $135.48 $106.39 -9.23% <-Total Growth 10 Current Liabilities D/E Ratio
Liquidity 2.13 1.54 1.15 1.43 1.52 1.94 2.35 2.50 2.02 2.34 2.80 2.06 1.94 2.07 2.04 <-Median-> 10 Ratio
Liq. with CF aft div 3.61 1.48 1.68 1.44 1.45 2.91 3.58 2.83 2.40 3.64 4.83 3.23 3.35 3.74 3.35 <-Median-> 5 Ratio CF less WC
Liq. CF re  Inv+Div  1.28 1.44 0.93 1.17 1.17 2.91 3.58 2.83 2.40 2.42 2.52 2.13 2.15 3.74 2.40 <-Median-> 5 Ratio CF less WC
Assets $406.11 $402.71 $638.77 $510.09 $458.03 $1,506.22 $1,037.81 $926.52 $563.21 $577.84 $671.12 $710.44 $683.07 $639.34 6.94% <-Total Growth 10 Assets
Liabilities $68.34 $101.32 $218.24 $163.15 $113.68 $330.17 $193.67 $185.41 $70.94 $88.44 $166.45 $193.38 $194.68 $162.84 -12.10% <-Total Growth 10 Liabilities
Debt Ratio 5.94 3.97 2.93 3.13 4.03 4.56 5.36 5.00 7.94 6.53 4.03 3.67 3.51 3.93 4.30 <-Median-> 10 Ratio
Estimates BVPS $3.49 $3.69 $4.33 Estimates Estimates BVPS
Estimate Book Value $740.7 $783.1 $919.0 Estimates Estimate Book Value
P/B Ratio (Close) 1.64 1.55 1.32 Estimates P/B Ratio (Close)
Difference from 10 year median 28.77% Diff M/C Estimates Difference from 10 yr med.
Total Book Value $337.78 $301.39 $420.53 $346.94 $344.35 $1,176.05 $844.14 $741.11 $492.28 $489.40 $504.67 $517.07 $488.39 $476.50 $476.50 $476.50 16.14% <-Total Growth 10 Book Value
Warrents $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
Book Value $337.78 $301.39 $420.53 $346.94 $344.35 $1,176.05 $844.14 $741.11 $492.28 $489.40 $504.67 $517.07 $488.39 $476.50 $476.50 $476.50 16.14% <-Total Growth 10 Book Value
Book Value per share $3.21 $2.84 $3.61 $2.95 $2.35 $3.47 $2.80 $2.73 $1.92 $1.98 $2.20 $2.47 $2.59 $2.25 $2.25 $2.25 -28.31% <-Total Growth 10 Book Value per Share
Change 6.07% -11.75% 27.17% -18.12% -20.27% 47.59% -19.41% -2.50% -29.48% 2.95% 10.83% 12.57% 4.56% -13.15% 0.00% 0.00% 93.03% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.19 2.32 2.24 1.26 1.29 1.25 0.95 0.47 0.55 1.32 1.70 1.65 1.77 2.19 0.00 0.00 1.32 P/B Ratio Historical Median
P/B Ratio (Close) 2.08 2.49 1.47 0.81 1.76 1.17 0.42 0.42 0.87 1.40 1.67 1.67 1.98 2.55 2.55 2.55 -3.27% <-IRR #YR-> 10 Book Value -28.31%
Change -10.46% 20.00% -41.19% -44.71% 116.63% -33.15% -64.11% -0.91% 108.99% 60.16% 19.21% 0.00% 19.09% 28.61% -1.08% <-IRR #YR-> 5 Book Value -5.30%
Leverage (A/BK) 1.20 1.34 1.52 1.47 1.33 1.28 1.23 1.25 1.14 1.18 1.33 1.37 1.40 1.34 1.31 <-Median-> 10 A/BV
Debt/Equity Ratio 0.20 0.34 0.52 0.47 0.33 0.28 0.23 0.25 0.14 0.18 0.33 0.37 0.40 0.34 0.31 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.28 5 yr Med 1.65 100.16% Diff M/C 1.31 Historical A/BV
-$3.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.59
-$2.73 $0.00 $0.00 $0.00 $0.00 $2.59
$103.43 <-12 mths -5.52%
Comprehensive Income $54.41 -$4.38 $49.09 -$62.06 -$72.20 $11.07 -$233.34 -$72.72 -$233.51 $17.35 $79.22 $121.01 $109.48 123.00% <-Total Growth 10 Comprehensive Income
Increase -42.89% -108.04% 1222.15% -226.42% -16.33% 115.33% -2208.84% 68.83% -221.09% 107.43% 356.60% 52.76% -9.53% 52.76% <-Median-> 5 Comprehensive Income
5 Yr Running Average $38.19 $37.72 $49.75 $26.47 -$7.03 -$15.70 -$61.49 -$85.85 -$120.14 -$102.23 -$88.60 -$17.73 $18.71 8.35% <-IRR #YR-> 10 Comprehensive Income 123.00%
ROE 16.1% -1.5% 11.7% -17.9% -21.0% 0.9% -27.6% -9.8% -47.4% 3.5% 15.7% 23.4% 22.4% #NUM! <-IRR #YR-> 5 Comprehensive Income 250.54%
5Yr Median 16.1% 16.1% 16.1% 11.7% -1.5% -1.5% -17.9% -17.9% -21.0% -9.8% -9.8% 3.5% 15.7% -9.32% <-IRR #YR-> 10 5 Yr Running Average 219.20%
% Difference from NI 0.0% 0.0% 0.0% 0.0% 0.0% -28.6% 0.3% -1.0% -0.5% 0.7% 0.0% 0.0% 0.0% #NUM! <-IRR #YR-> 5 5 Yr Running Average 121.79%
Median Values Diff 5, 10 yr 0.0% 0.0% 15.7% <-Median-> 5 Return on Equity
-$49.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $109.5
$72.7 $0.0 $0.0 $0.0 $0.0 $109.5
\ \ -$49.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $18.7
$85.9 $0.0 $0.0 $0.0 $0.0 $18.7
Current Liability Coverage Ratio 2.12 0.42 0.81 0.45 -0.46 0.97 1.23 0.33 0.38 1.30 2.02 1.40 1.65 2.08   CFO / Current Liabilities
5 year Median 1.60 1.60 1.60 0.81 0.45 0.45 0.81 0.45 0.38 0.97 1.23 1.30 1.40 1.65 1.35 <-Median-> 4 Current Liability Cov Ratio
Asset Efficiency Ratio 25.97% 8.11% 18.66% 5.61% -5.41% 9.72% 10.20% 3.27% 4.04% 17.51% 28.29% 28.50% 32.81% 34.69% CFO / Total Assets
5 year Median 25.97% 25.97% 25.97% 18.66% 8.11% 8.11% 9.72% 5.61% 4.04% 9.72% 10.20% 17.51% 28.29% 28.50% 22.9% <-Median-> 4 Return on Assets 
Return on Assets ROA 13.4% -1.1% 7.7% -12.2% -15.8% 1.0% -22.4% -7.9% -41.7% 3.0% 11.8% 17.0% 16.0% 18.3% Net  Income/Assets Return on Assets
5Yr Median 13.4% 13.4% 13.4% 7.7% -1.1% -1.1% -12.2% -12.2% -15.8% -7.9% -7.9% 3.0% 11.8% 16.0% -3.4% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 16.1% -1.5% 11.7% -17.9% -21.0% 1.3% -27.6% -9.9% -47.7% 3.5% 15.7% 23.4% 22.4% 24.6% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 16.1% 16.1% 16.1% 11.7% -1.5% -1.5% -17.9% -17.9% -21.0% -9.9% -9.9% 3.5% 15.7% 22.4% -4.3% <-Median-> 10 Return on Equity
$103.43 <-12 mths -5.52%
Net Income $54.41 -$4.38 $49.09 -$62.06 -$72.20 $15.50 -$232.66 -$73.46 -$234.69 $17.22 $79.22 $121.01 $109.48 $117.3 $152.5 $158.8 123.00% <-Total Growth 10 Net Income
Increase -42.89% -108.04% 1222.15% -226.42% -16.33% 121.46% -1601.50% 68.43% -219.48% 107.34% 360.02% 52.76% -9.53% 7.14% 30.01% 4.13% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $38.2 $37.7 $49.8 $26.5 -$7.0 -$14.8 -$60.5 -$85.0 -$119.5 -$101.6 -$88.9 -$18.1 $18.4 $88.8 $115.9 $131.8 8.35% <-IRR #YR-> 10 Net Income 123.00%
Operating Cash Flow $87.91 $51.45 $81.82 $13.10 -$4.04 $133.58 $100.94 $28.63 $70.77 $74.10 $152.32 $248.46 $154.84 #NUM! <-IRR #YR-> 5 Net Income 249.04%
Investment Cash Flow -$76.93 -$14.82 -$78.69 -$14.88 -$13.93 $62.17 $51.16 $2.65 $13.26 -$39.35 -$85.80 -$75.09 -$75.92 -9.44% <-IRR #YR-> 10 5 Yr Running Ave. 362.52%
Total Accruals $43.43 -$41.01 $45.97 -$60.29 -$54.23 -$180.25 -$384.76 -$104.74 -$318.72 -$17.52 $12.69 -$52.36 $30.56 #NUM! <-IRR #YR-> 5 5 Yr Running Ave. 121.71%
Total Assets $406.11 $402.71 $638.77 $510.09 $458.03 $1,506.22 $1,037.81 $926.52 $563.21 $577.84 $671.12 $710.44 $683.07 Balance Sheet Assets
Accruals Ratio 10.69% -10.18% 7.20% -11.82% -11.84% -11.97% -37.07% -11.30% -56.59% -3.03% 1.89% -7.37% 4.47% -3.03% <-Median-> 5 Ratio
EPS/CF Ratio 0.51 -0.13 0.43 -2.17 3.05 0.12 -2.08 -2.33 -10.00 0.17 0.39 0.57 0.46 0.14 <-Median-> 10 EPS/CF Ratio
-$49.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $109.5
$73.5 $0.0 $0.0 $0.0 $0.0 $109.5
-$49.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $18.4
$85.0 $0.0 $0.0 $0.0 $0.0 $18.4
Change in Close -5.02% 5.90% -25.21% -54.73% 72.73% -1.34% -71.08% -3.39% 47.37% 64.88% 32.13% 12.57% 24.51% 11.70% 0.00% 0.00% Count 19 Years of data
up/down down down  up down up up up up up up up Count 14 73.68%
Meet Prediction? yes Yes Yes yes yes % right Count 7 50.00%
Financial Cash Flow -$30.88 -$37.91 -$3.82 -$15.78 $17.38 -$202.67 -$155.67 -$32.84 -$68.67 -$27.84 -$37.83 -$142.73 -$141.39 C F Statement  Financial Cash Flow
Total Accruals $74.31 -$3.10 $49.79 -$44.51 -$71.61 $22.42 -$229.09 -$71.90 -$250.05 $10.32 $50.52 $90.37 $171.95 Accruals
Accruals Ratio 18.30% -0.77% 7.79% -8.73% -15.63% 1.49% -22.07% -7.76% -44.40% 1.79% 7.53% 12.72% 25.17% 7.53% <-Median-> 5 Ratio
Cash $22.58 $21.31 $20.63 $3.06 $2.47 $12.74 $8.25 $7.20 $22.61 $29.51 $58.11 $88.75 $26.28 $36.34 Cash
Cash Per share $0.21 $0.20 $0.18 $0.03 $0.02 $0.04 $0.03 $0.03 $0.09 $0.12 $0.25 $0.42 $0.14 $0.17 $0.14 <-Median-> 5 Cash per Share
Percentage of Stock Price 3.22% 2.84% 3.35% 1.09% 0.41% 0.92% 2.32% 2.33% 5.26% 4.31% 6.91% 10.30% 2.71% 2.99% 5.26% <-Median-> 5 % of Stock Price
Notes:
Next year maybe think about going straight Trican Well Services?
September 11, 2025.  Last estimates were for 2024, 2025, 2026 of $960.4M, $1010M, $1053M Revenue, $0.73, $0.73 2024/5 FCF, $0.51, $058, $0.64 EPS, 
$0.18, $0.19, $0.22 Dividends, $77.7M, $120.8M, $120.9M FCF, $0.81, $1.07, $1.29 CFPS, $227.8M, $249.7M, $256.2M EBITDA, $2.52, $2.94, $3.46 BVPS, $107.9M, $122.7M, $123.1M Net Income.
September 7, 2024.  Last estimates were for 2023, 2024, 2025 of $991M, $1050M, $1125M Revenue, $0.58, $0.58, $0.74 EPS, 
$0.16, $0.17 2023/4 Dividends, $119M, $127M, $139M FCF, $1.03, $1.07, $1.18 CFPS, $2.37, $2.93, $3.65 BVPS, $127M, $124M, $149M Net Income.
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.  TSX chart goes back to 2006
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 through its continuing pressure pumping operations in Canada. The company offers these services to 
customers in Canada from operating bases located across the Western Canadian Sedimentary Basin (WCSB).   
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 2017 Sep 22 2018 Sep 14 2019 Sep 13 2020 Sep 5 2021 Sep 11 2022 Sep 10 2023 Sep 8 2024 Sep 811 2025
Fedora, Bradley 1.803 0.66% 0.991 0.39% 0.991 0.40% 0.991 0.43% 0.991 0.47% 0.991 0.52% 0.991 0.47% Was Chairman until 2020 0.00%
CEO - Shares - Amt $2.055 $1.664 $2.744 $3.626 $4.081 $5.082 $5.676
Options - percentage 0.098 0.04% 2.296 0.90% 3.410 1.38% 3.802 1.65% 3.802 1.82% 3.571 1.89% 3.498 1.65% -2.05%
Options - amount $0.112 $3.858 $9.446 $13.915 $15.664 $18.319 $20.042
Dusterhoft, Dale M. 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 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.067 0.04% 0.067 0.03% 0.00%
CFO - Shares - Amount $0.006 $0.016 $0.019 $0.341 $0.381
Options - percentage 0.210 0.09% 0.349 0.15% 0.349 0.17% 0.399 0.21% 0.368 0.17% -7.68%
Options - amount $0.582 $1.277 $1.437 $2.045 $2.109
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 0.340 0.16% 0.340 0.18% 0.340 0.16% 0.00%
Officer - Shares - Amount $1.400 $1.744 $1.948
Options - percentage 1.248 0.60% 0.973 0.52% 0.934 0.44% -4.02%
Options - amount $5.142 $4.993 $5.352
Onwuekwe, Chika Benjamin 0.012 0.00% 0.022 0.01% 0.052 0.02% 0.052 0.02% 0.052 0.02% 0.133 0.07% 0.137 0.06% 2.76%
Officer - Shares - Amount $0.014 $0.038 $0.143 $0.189 $0.213 $0.684 $0.785
Options - percentage 0.395 0.15% 0.640 0.25% 0.669 0.27% 0.638 0.28% 0.638 0.30% 0.227 0.12% 0.212 0.10% -6.90%
Options - amount $0.450 $1.075 $1.854 $2.333 $2.627 $1.167 $1.213
Rukin, Jim 0.025 0.01% 0.025 0.01% 0.025 0.01% 0.00%
Officer - Shares - Amount $0.101 $0.126 $0.141
Options - percentage 0.312 0.15% 0.161 0.09% 0.147 0.07% -8.78%
Options - amount $1.284 $0.826 $0.841
Stein, Deborah Susan 0.025 0.01% 0.030 0.01% 0.030 0.01% 0.030 0.01% 0.030 0.02% 0.030 0.01% 0.00%
Director - Shares - Amount $0.042 $0.083 $0.110 $0.124 $0.154 $0.172
Options - percentage 0.219 0.09% 0.255 0.10% 0.277 0.12% 0.277 0.13% 0.335 0.18% 0.381 0.18% 13.68%
Options - amount $0.367 $0.705 $1.015 $1.142 $1.717 $2.180
Curran, Trudy Marie 0.009 0.00% 0.009 0.00% 0.009 0.00% 0.00%
Director - Shares - Amount $0.035 $0.044 $0.049
Options - percentage 0.070 0.03% 0.083 0.04% 0.109 0.05% 31.28%
Options - amount $0.287 $0.425 $0.623
McNulty, Michael Joseph 0.037 0.02% 0.037 0.02% 0.037 0.02% 0.00%
Lead Director - Shares - Amount $0.152 $0.190 $0.212
Options - percentage 0.088 0.04% 0.102 0.05% 0.129 0.06% 26.20%
Options - amount $0.363 $0.523 $0.737
Alford, Thomas 0.020 0.01% 0.040 0.02% 0.040 0.02% 0.065 0.03% 0.065 0.03% 0.00%
Chairman - Shares - Amt $0.055 $0.146 $0.165 $0.335 $0.374
Options - percentage 0.088 0.04% 0.164 0.07% 0.164 0.08% 0.294 0.16% 0.362 0.17% 23.41%
Options - amount $0.244 $0.601 $0.677 $1.506 $2.076
Increase in O/S Shares 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% 2.059 0.98% 0.637 0.34%
due to SO $0.466 $2.914 $0.719 $0.100 $2.311 $4.232 $9.194 $8.482 $3.266
Book Value $0.284 $1.177 $0.867 $0.104 $1.093 $2.219 $4.439 $3.601 $5.768
Insider Buying -$0.044 -$0.070 -$0.025 -$0.069 -$0.108 -$0.118 -$0.118 -$0.280 -$0.025
Insider Selling $0.930 $0.298 $0.016 $0.106 $0.380 $0.000 $0.000 $0.401 $0.000
Net Insider Selling $0.886 $0.228 -$0.009 $0.037 $0.272 -$0.118 -$0.118 $0.121 -$0.025
% of Market Cap 0.06% 0.06% 0.00% 0.01% 0.04% -0.01% -0.01% 0.01% 0.00%
Directors 7 7 5 5 6 6 6 7
Women 13% 1 14% 1 14% 1 20% 2 40% 2 33% 2 33% 2 33% 2 29%
Minorities 13% 1 14% 1 14% 1 20% 1 20% 1 17% 1 17% 1 17% 1 14%
Institutions/Holdings 34.86% 81 39.62% 20 20 40.36% 20 17.64% 20 32.40% 20 13.92% 20 14.15% 20 23.75%
Total Shares Held 35.67% 128.164 42.51% 101.687 37.45% 106.837 39.35% 45.111 18.27% 79.019 34.39% 29.325 14.02% 28.225 14.94% 42.412 19.98%
Increase/Decrease 3 Mths 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% 1.771 6.70% -2.572 -5.72%
Starting No. of Shares 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 26.453 Top 20 MS 44.985 Top 20 MS
Copyright © 2008 Website of SPBrunner. All rights reserved.