This report is for educational purposes only, and not to provide investment advice. Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Waste Connections Inc. TSX: WCN NYSE: WCN www.wasteconnections.com Fiscal Yr: Dec 31 Q1 2017
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item
Accounting Rules C GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP Accounting Rules
USD - CDN$ 1.1656 1.1652 0.9881 1.2246 1.0501 0.9970 1.0213 0.9983 1.0636 1.1601 1.3847 1.3427 1.3504 1.3504 1.3504 15.23% <-Total Growth 10 USD - CDN$
Currency <--CDN$ US$--> Currency
Mths in Accting Yr. Mths in Accting Yr.
Merger/Split Date 1-Jun-16 19-Jun-17 Merger/Split Date
Merger/Split 2.0768 1.5 Merger/Split
Merger/Split 0.4815 3:2 Shares for old BIN shares
$3,995.7 <-12 mths 18.36%
Revenue* US$ $581.18 $662.39 $928.41 $912.16 $1,008.4 $1,429.8 $1,840.1 $1,896.7 $2,026.0 $2,009.0 $1,925.6 $3,375.9 $4,518 $4,747 $4,964 409.65% <-Total Growth 10 Revenue
Increase 264.35% 13.97% 40.16% -1.75% 10.56% 41.78% 28.70% 3.08% 6.82% -0.84% -4.15% 75.32% 33.83% 5.07% 4.57% 17.69% <-IRR #YR-> 10 Revenue
5 year Running Average $209.2 $325.6 $492.2 $648.7 $818.5 $988.2 $1,223.8 $1,417.4 $1,640.2 $1,840.3 $1,939.5 $2,246.6 $2,770.9 $3,315.1 $3,906.1 12.90% <-IRR #YR-> 5 Revenue
Revenue per Share $25.45 $25.71 $33.49 $32.91 $25.44 $24.45 $32.37 $34.26 $36.64 $37.22 $36.75 $19.27 $25.74 $27.04 $28.28 21.31% <-IRR #YR-> 10 5 yr Running Average
Increase 103.56% 1.04% 30.27% -1.75% -22.70% -3.86% 32.39% 5.81% 6.95% 1.59% -1.24% -47.57% 33.56% 5.07% 4.57% 12.92% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $12.38 $16.26 $21.46 $26.01 $28.60 $28.40 $29.73 $29.89 $30.63 $32.99 $35.45 $32.83 $31.12 $29.20 $27.41 -2.84% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 1.89 1.88 1.58 1.06 0.93 1.70 1.42 1.23 1.33 1.49 1.46 3.31 -9.86% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 1.96 1.92 1.63 0.54 1.31 2.06 1.26 1.31 1.40 1.68 1.33 4.08 3.77 3.58 3.41 7.28% <-IRR #YR-> 10 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 1.44 5 yr 1.46 161.28% Diff M/C 2.00% <-IRR #YR-> 5 5 yr Running Average
$5,395.8 <-12 mths 19.04%
Revenue* CDN $677.4 $771.8 $917.4 $1,117.0 $1,059.0 $1,425.5 $1,879.3 $1,893.5 $2,154.9 $2,330.6 $2,666.5 $4,532.8 $6,101 $6,410 $6,703 487.28% <-Total Growth 10 Revenue
Increase 252.91% 13.93% 18.86% 21.77% -5.20% 34.61% 31.84% 0.76% 13.80% 8.16% 14.41% 69.99% 34.60% 5.07% 4.57% 19.37% <-IRR #YR-> 10 Revenue
5 year Running Average $263.1 $391.9 $545.2 $735.1 $908.5 $1,058.1 $1,279.6 $1,474.9 $1,682.4 $1,936.8 $2,185.0 $2,715.7 $3,557.2 $4,408.3 $5,282.8 19.25% <-IRR #YR-> 5 Revenue
Revenue per Share $29.66 $29.96 $33.09 $40.30 $26.71 $24.38 $33.07 $34.20 $38.97 $43.18 $50.89 $25.87 $34.75 $36.51 $38.18 21.36% <-IRR #YR-> 10 5 yr Running Average
Increase 97.16% 1.00% 10.47% 21.77% -33.72% -8.73% 35.62% 3.42% 13.94% 10.80% 17.88% -49.17% 34.33% 5.07% 4.57% 16.24% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $15.94 $19.92 $24.18 $29.61 $31.94 $30.89 $31.51 $31.73 $31.46 $34.76 $40.06 $38.62 $38.73 $38.24 $37.24 -1.46% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 1.91 1.84 1.72 0.89 0.97 1.79 1.39 1.25 1.31 1.45 1.38 3.42 -4.79% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 1.97 1.90 1.67 0.54 1.31 2.06 1.25 1.30 1.40 1.68 1.33 4.07 3.76 3.58 3.43 6.84% <-IRR #YR-> 10 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 1.38 5 yr 1.38 172.49% Diff M/C 4.15% <-IRR #YR-> 5 5 yr Running Average
-$771.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $4,532.8
-$1,879.3 $0.0 $0.0 $0.0 $0.0 $4,532.8
-$391.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,715.7
-$1,279.6 $0.0 $0.0 $0.0 $0.0 $2,715.7
Adj EPS* US$ $0.39 $1.09 $1.45 $1.56 $1.45 $1.97 $2.33 $2.01 $2.29 $2.77 -$0.13 $2.57 136.72% <-Total Growth 10 Earnings per Share
Increase -69.72% 177.37% 33.39% 7.40% -6.67% 35.71% 17.89% -13.39% 13.82% 20.75% -104.68% -2088.04% 9.00% <-IRR #YR-> 10 Earnings per Share
Earnings Yield 0.8% 2.2% 2.7% 8.8% 4.4% 3.9% 5.7% 4.5% 4.5% 4.4% -0.3% 3.3% 2.04% <-IRR #YR-> 5 Earnings per Share
5 year Running Average $0.80 $1.01 $1.16 $1.19 $1.50 $1.75 $1.86 $2.01 $2.28 $1.85 $1.90 9.03% <-IRR #YR-> 10 5 yr Running Average
Payout Ratio 745.45% 286.89% 263.48% 197.94% 124.70% 52.79% 47.64% 57.83% 48.54% 39.44% -764.59% 29.45% 1.68% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average 284.00% 281.15% 263.62% 248.42% 171.21% 124.04% 88.05% 62.03% 48.52% 58.97% 53.76% 106.05% <-Median-> 10 Payout 5 yr Running Average
Price/AFFO Median 122.92 44.40 36.49 22.35 16.24 21.13 19.75 20.89 21.33 19.99 -415.56 24.79 21.01 <-Median-> 10 Price/AEPS Median
Price/AFFO High 141.30 51.12 42.29 36.27 23.06 25.58 23.01 23.56 24.42 23.23 -489.92 30.61 23.99 <-Median-> 10 Price/AEPS High
Price/AFFO Low 104.53 37.69 30.69 8.43 9.43 16.67 16.49 18.22 18.23 16.74 -341.21 18.97 16.71 <-Median-> 10 Price/AEPS Low
Price/AFFO Close 127.05 45.37 37.61 11.40 22.89 25.58 17.49 22.27 22.42 22.56 -377.78 30.54 22.49 <-Median-> 10 Price/AEPS Close
Trailing P/AFFO Close 38.48 125.83 50.16 12.24 21.36 34.71 20.62 19.29 25.52 27.25 17.66 -607.05 20.99 <-Median-> 10 Trailing P/AEPSClose
* ESP per share (US$) DPR 10 Yrs 50.67% 5 Yrs 39.44% P/CF 5 Yrs in order 20.89 23.56 18.22 22.42 -100.00% Diff M/C -100.00% Diff M/C 10 DPR 75% to 95% best
Adj EPS* CDN$ $0.46 $1.27 $1.43 $1.91 $1.53 $1.97 $2.38 $2.01 $2.44 $3.21 -$0.18 $3.46 172.79% <-Total Growth 10 Earnings per Share
Increase -70.67% 177.27% 13.11% 33.11% -19.96% 28.85% 20.77% -15.34% 21.26% 31.71% -105.58% -2027.68% 10.56% <-IRR #YR-> 10 Earnings per Share
Earnings Yield 0.8% 2.2% 2.6% 8.7% 4.4% 3.9% 5.7% 4.5% 4.5% 4.4% -0.3% 3.3% 7.78% <-IRR #YR-> 5 Earnings per Share
5 year Running Average $1.00 $1.15 $1.32 $1.32 $1.62 $1.84 $1.96 $2.06 $2.40 $1.97 $2.19 8.13% <-IRR #YR-> 10 5 yr Running Average
Payout Ratio 745.45% 286.89% 263.48% 197.94% 124.70% 52.79% 47.64% 57.83% 48.54% 39.44% -764.59% 29.45% 3.50% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average 280.91% 280.43% 262.07% 250.28% 174.40% 126.23% 92.08% 62.22% 48.18% 62.04% 54.87% 109.15% <-Median-> 10 Payout 5 yr Running Average
Price/FFO Median 123.82 43.50 39.75 18.83 17.03 22.23 19.31 21.25 20.86 19.52 -390.46 25.64 20.19 <-Median-> 10 Price/AEPS Median
Price/FFO High 136.77 49.26 42.61 29.18 23.02 26.66 21.87 23.75 24.09 22.91 -442.54 30.95 23.92 <-Median-> 10 Price/AEPS High
Price/FFO Low 110.86 37.74 36.90 8.47 11.03 17.81 16.74 18.74 17.63 16.13 -338.39 20.33 17.18 <-Median-> 10 Price/AEPS Low
Price/FFO Close 127.68 44.92 38.68 11.43 22.96 25.54 17.42 22.18 22.37 22.59 -377.66 30.48 22.48 <-Median-> 10 Price/AEPS Close
Trailing P/FFO Close 37.45 124.55 43.75 15.22 18.38 32.91 21.04 18.78 27.13 29.75 21.08 -587.60 21.06 <-Median-> 10 Trailing P/AEPSClose
* ESP per share DPR 10 Yrs 50.67% 5 Yrs 39.44% P/CF 5 Yrs in order 20.86 23.75 17.63 22.37 -100.00% Diff M/C -100.00% Diff M/C 10 DPR 75% to 95% best
-$1.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.46
-$2.38 $0.00 $0.00 $0.00 $0.00 $3.46
-$1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.19
-$1.84 $0.00 $0.00 $0.00 $0.00 $2.19
$1.70 <-12 mths 6.25%
Pre-Split 2016 $0.64 $0.77 -$1.63 $0.81 $1.02 $1.10 $1.12
EPS Basic US$ $0.39 $1.09 $1.18 $1.37 $1.33 $1.60 -$3.39 $1.68 $2.12 $2.28 $2.33 $1.61 48.08% <-Total Growth 10 EPS Basic
Pre-Split 2016 $0.63 $0.76 -$1.63 $0.81 $1.02 $1.10 $1.12 $1.42 $1.52
EPS Diluted* $0.39 $1.09 $1.18 $1.37 $1.31 $1.58 -$3.39 $1.68 $2.12 $2.28 $2.33 $1.60 $2.30 $3.20 $3.52 47.16% <-Total Growth 10 EPS Diluted
Increase -69.72% 177.37% 8.26% 16.71% -4.75% 20.63% -314.47% -149.69% 25.93% 7.84% $1.12 $1.12 43.75% 39.13% 10.00% 3.94% <-IRR #YR-> 10 Earnings per Share
Earnings Yield 0.7% 1.9% 2.1% 6.3% 3.7% 3.1% -8.2% 3.8% 3.9% 3.1% 3.4% 1.5% 1.8% 2.4% 2.7% #NUM! <-IRR #YR-> 5 Earnings per Share
5 year Running Average $0.77 $0.95 $1.06 $1.07 $1.30 $0.41 $0.51 $0.66 $0.86 $1.01 $2.00 $2.13 $2.34 $2.59 9.98% <-IRR #YR-> 10 5 yr Running Average
10 year Running Average $0.59 $0.73 $0.86 $0.96 $1.16 $1.21 $1.32 $1.50 $1.72 37.29% <-IRR #YR-> 5 5 yr Running Average
* Diluted ESP per share E/P 10 Yrs 3.29% 5Yrs 3.44%
$2.30 <-12 mths 6.86%
EPS Basic CDN$ $0.46 $1.27 $1.16 $1.68 $1.40 $1.59 -$3.46 $1.68 $2.25 $2.65 $3.22 $2.16 70.64% <-Total Growth 10 EPS Basic
EPS Diluted* $0.46 $1.27 $1.16 $1.68 $1.37 $1.57 -$3.46 $1.68 $2.25 $2.65 $3.22 $2.15 $3.11 $4.32 $4.75 69.58% <-Total Growth 10 EPS Diluted
Increase -70.67% 177.27% -8.20% 44.64% -18.32% 14.53% -319.71% -148.57% 34.16% 17.63% 21.53% -33.30% 44.57% 39.13% 10.00% 5.42% <-IRR #YR-> 10 Earnings
Earnings Yield 0.8% 2.2% 2.1% 7.7% 3.9% 3.1% -8.4% 3.8% 4.1% 3.7% 4.8% 2.0% 2.4% 3.3% 3.6% #NUM! <-IRR #YR-> 5 Earnings
5 year Running Average $0.96 $1.10 $1.23 $1.19 $1.41 $0.47 $0.57 $0.68 $0.94 $1.27 $2.39 $2.68 $3.09 $3.51 9.61% <-IRR #YR-> 10 5 yr Running Average
10 year Running Average $0.71 $0.83 $0.95 $1.06 $1.34 $1.43 $1.62 $1.89 $2.22 38.62% <-IRR #YR-> 5 5 yr Running Average
* Diluted ESP per share E/P 10 Yrs 3.71% 5Yrs 3.76%
-$1.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.15
$3.46 $0.00 $0.00 $0.00 $0.00 $2.15
-$0.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.39
-$0.47 $0.00 $0.00 $0.00 $0.00 $2.39
Special Dividends Waste Con. US$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 7 Special Dividends
Dividend US$ $0.08 $0.32 $0.37 -$0.19 $0.48 $0.18 $0.62 $0.72 $0.72 $0.72 #DIV/0! <-Total Growth 6 Dividends
Increase 320.00% 17.46% -150.00% -356.76% -61.26% 234.24% 17.07% 0.00% 0.00% Count 7 Years of data
Dividends 5 Yr Running $0.21 $0.23 $0.29 $0.36 $0.54 $0.59 #DIV/0! <-Total Growth 2 Dividends 5 Yr Running
Yield H/L Price #NUM! <-Median-> 0 Yield H/L Price
Yield on High Price #NUM! <-Median-> 0 Yield on High Price
Yield on Low Price #NUM! <-Median-> 0 Yield on Low Price
Yield on Close Price 0.27% 0.95% 1.09% -0.42% 1.08% 0.33% 0.78% 0.74% 0.74% 0.74% 0.78% <-Median-> 7 Yield on Close Price
Payout Ratio EPS #NUM! <-Median-> 0 DPR EPS
DPR EPS 5 Yr Running #NUM! <-Median-> 0 DPR EPS 5 Yr Running
Payout Ratio CFPS #NUM! <-Median-> 0 DPR CF
DPR CF 5 Yr Running #NUM! <-Median-> 0 DPR CF 5 Yr Running
Payout Ratio CFPS WC #NUM! <-Median-> 0 DPR CF WC
DPR CF WC 5 Yr Running #NUM! <-Median-> 0 DPR CF WC 5 Yr Running
Median values 12.71% <-IRR #YR-> 6 Dividends
* Dividends per share 14.32% <-IRR #YR-> 5 Dividends
-$0.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.62
-$0.32 $0.00 $0.00 $0.00 $0.00 $0.62
Special Dividends US$ $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
Dividend US$ $2.92 $3.12 $3.82 $3.08 $1.81 $1.04 $1.11 $1.16 $1.11 $1.09 $0.99 $0.76 $0.72 $0.72 $0.72 -75.70% <-Total Growth 10 Dividends
Increase 27.31% 6.74% 22.51% -19.31% -41.20% -42.55% 6.40% 5.12% -4.46% -1.88% -9.36% -23.41% -5.03% 0.00% 0.00% Count 15 Years of data
Dividends 5 Yr Running $2.28 $2.83 $3.05 $2.95 $2.58 $2.17 $1.64 $1.25 $1.10 $1.09 $1.02 $0.93 $0.86 $0.78 -55.07% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 6.06% 6.46% 7.22% 8.86% 7.68% 2.50% 2.41% 2.77% 2.28% 1.97% 1.84% 1.19% 0.82% 2.46% <-Median-> 10 Yield H/L Price
Yield on High Price 5.28% 5.61% 6.23% 5.46% 5.41% 2.06% 2.07% 2.45% 1.99% 1.70% 1.56% 0.96% 0.74% 2.07% <-Median-> 10 Yield on High Price
Yield on Low Price 7.13% 7.61% 8.59% 23.49% 13.23% 3.17% 2.89% 3.17% 2.66% 2.36% 2.24% 1.55% 0.91% 3.03% <-Median-> 10 Yield on Low Price
Yield on Close Price 5.87% 6.32% 7.01% 17.36% 5.45% 2.06% 2.72% 2.60% 2.17% 1.75% 2.02% 0.96% 0.74% 0.74% 0.75% 2.38% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 745.45% 286.89% 324.64% 224.44% 138.56% 65.99% -32.74% 69.25% 52.54% 47.80% 42.56% 47.38% 31.30% 22.50% 20.45% 59.26% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 294.63% 297.31% 286.25% 276.46% 197.37% 529.50% 321.05% 188.99% 129.02% 108.80% 51.12% 43.96% 36.55% 30.19% 236.91% <-Median-> 7 DPR EPS 5 Yr Running
Payout Ratio CFPS 62.40% 50.42% 48.14% 45.52% 28.05% 20.72% 15.92% 19.15% 13.66% 13.08% 12.50% 16.70% 10.99% 9.50% 8.91% 17.93% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 59.28% 55.43% 51.84% 46.06% 39.76% 32.77% 26.23% 19.09% 15.97% 14.59% 14.60% 13.16% 12.25% 11.27% 29.50% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 55.39% 46.30% 48.50% 42.17% 30.44% 19.38% 14.69% 15.65% 13.88% 12.38% 12.99% 15.99% 10.99% 9.50% 8.91% 15.82% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 55.09% 52.51% 49.03% 44.51% 38.72% 31.90% 24.42% 18.18% 14.84% 13.86% 13.97% 13.07% 12.12% 11.30% 28.16% <-Median-> 7 DPR CF WC 5 Yr Running
Median values 5 Yr Med 5 Yr Cl 1.97% 2.02% 5 Yr Med Payout 47.80% 13.66% 13.88% -13.19% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. -62.36% -63.29% Last Div Inc ---> $0.150 $0.160 6.7% -7.31% <-IRR #YR-> 5 Dividends
-$3.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.76
-$1.11 $0.00 $0.00 $0.00 $0.00 $0.76
Historical Dividends Historical High Div 18.36% Low Div 1.26% Ave Div 9.81% Med Div 4.42% Close Div 4.09% Historical Dividends
High/Ave/Median Values Curr diff Exp. -95.95% Exp -41.04% Exp. -92.43% Exp. -83.19% Exp. -81.82% High/Ave/Median
Special Dividends CDN$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends
Pre-Split 2016 $1.64 $1.75 $1.82 $1.82 $0.92 $0.50 $0.55 $0.56 $0.57 $0.61 $0.66 $1.02
Dividend CDN$ Paid in $3.41 $3.63 $3.78 $3.78 $1.90 $1.04 $1.13 $1.16 $1.18 $1.27 $1.37 $1.02 $0.97 $0.97 $0.97 -71.99% <-Total Growth 10 Dividends
Increase 23.31% 6.71% 3.89% 0.00% -49.58% -45.45% 9.00% 2.75% 1.79% 7.02% 8.20% -25.74% -4.48% 0.00% 0.00% Count 15 Years of data
Dividends 5 Yr Running $2.81 $3.23 $3.47 $3.30 $2.83 $2.33 $1.80 $1.28 $1.16 $1.22 $1.20 $1.16 $1.12 $1.06 -57.31% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 6.02% 6.60% 6.63% 10.51% 7.32% 2.37% 2.47% 2.72% 2.33% 2.02% 1.96% 1.15% 0.83% 2.42% <-Median-> 10 Yield H/L Price
Yield on High Price 5.45% 5.82% 6.18% 6.78% 5.42% 1.98% 2.18% 2.43% 2.01% 1.72% 1.73% 0.95% 0.74% 2.10% <-Median-> 10 Yield on High Price
Yield on Low Price 6.72% 7.60% 7.14% 23.37% 11.30% 2.96% 2.85% 3.09% 2.75% 2.45% 2.26% 1.45% 0.94% 2.90% <-Median-> 10 Yield on Low Price
Yield on Close Price 5.84% 6.39% 6.81% 17.31% 5.43% 2.07% 2.73% 2.61% 2.17% 1.75% 2.02% 0.97% 0.74% 0.74% 0.74% 2.39% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 745.45% 286.89% 324.64% 224.44% 138.56% 65.99% -32.74% 69.25% 52.54% 47.80% 42.56% 47.38% 31.30% 22.50% 20.45% 59.26% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 294.35% 294.24% 283.25% 277.56% 200.12% 497.78% 316.03% 187.60% 123.09% 96.38% 50.22% 43.44% 36.25% 30.23% 238.84% <-Median-> 7 DPR EPS 5 Yr Running
Payout Ratio CFPS 62.40% 50.42% 48.14% 45.52% 28.05% 20.72% 15.92% 19.15% 13.66% 13.08% 12.50% 16.70% 10.99% 9.50% 8.91% 17.93% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 59.61% 55.98% 51.96% 46.35% 40.20% 33.17% 27.08% 19.08% 15.83% 14.39% 14.47% 13.13% 12.22% 11.27% 30.13% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 55.39% 46.30% 48.50% 42.17% 30.44% 19.38% 14.69% 15.65% 13.88% 12.38% 12.99% 15.99% 10.99% 9.50% 8.91% 15.82% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 55.53% 52.86% 49.01% 44.59% 39.03% 32.24% 25.25% 18.20% 14.73% 13.76% 13.92% 13.05% 12.11% 11.31% 28.74% <-Median-> 7 DPR CF WC 5 Yr Running
Median values 5 Yr Med 5 Yr Cl 2.02% 2.02% 5 Yr Med Payout 47.80% 13.66% 13.88% -11.95% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. -63.21% -63.28% Last Div Inc ---> $1.370 $0.970 -29.2% -2.10% <-IRR #YR-> 5 Dividends
-$3.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.02
-$1.13 $0.00 $0.00 $0.00 $0.00 $1.02
Historical Dividends Historical High Div 16.13% Low Div 1.41% Ave Div 8.77% Med Div 6.02% Close Div 5.43% Historical Dividends
High/Ave/Median Values Curr diff Exp. -95.39% Exp -47.28% Exp. -91.52% Exp. -87.65% Exp. -86.31% High/Ave/Median
Future Div Yield Div Yd 0.90% earning in 5.00 Years at IRR of 4.00% Div Inc. 21.67% Future Div Yield
Future Div Yield Div Yd 1.10% earning in 10.00 Years at IRR of 4.00% Div Inc. 48.02% Future Div Yield
Future Div Yield Div Yd 1.34% earning in 15.00 Years at IRR of 4.00% Div Inc. 80.09% Future Div Yield
Yield if held 5 yrs 16.84% 12.67% 4.18% 1.84% 2.05% 2.04% 3.30% 4.87% 3.13% 2.22% 2.28% 1.91% 1.55% 3.22% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 5.19% 3.97% 2.78% 2.42% 1.85% 1.71% 2.71% 3.74% 2.78% <-Median-> 5 Paid Median Price
Yield if held 15 yrs 4.34% 3.26% 2.13% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 71.96% 58.23% 36.21% 24.97% 21.10% 15.82% 17.88% 22.25% 13.98% 13.09% 13.60% 11.01% 8.46% 21.67% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 112.16% 79.77% 48.91% 35.78% 31.99% 26.02% 33.48% 42.67% 48.91% <-Median-> 5 Paid Median Price
Cost covered if held 15 years 138.08% 98.57% 60.55% #NUM! <-Median-> 0 Paid Median Price
Graham Price $18.32 $27.85 $24.37 $31.34 $25.36 $31.53 $28.68 $29.44 $35.46 $39.68 $46.50 $45.74 $55.09 $64.98 $68.15 64.21% <-Total Growth 10 Graham Price
Price/GP Ratio Med 3.09 1.98 2.34 1.15 1.02 1.39 1.60 1.45 1.43 1.58 1.51 1.94 2.13 1.48 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 3.41 2.24 2.51 1.78 1.39 1.66 1.81 1.62 1.66 1.85 1.71 2.34 2.38 1.74 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 2.77 1.72 2.17 0.52 0.66 1.11 1.39 1.28 1.21 1.31 1.30 1.54 1.88 1.29 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 3.18 2.04 2.27 0.70 1.38 1.59 1.44 1.52 1.54 1.83 1.46 2.30 2.37 2.01 1.92 1.53 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 218.46% 104.29% 127.44% -30.41% 38.23% 59.33% 44.30% 51.51% 53.86% 82.81% 45.60% 130.31% 137.43% 101.29% 91.93% 52.69% <-Median-> 10 Graham Price
Pre-Split 2016 $28.09 $27.40 $26.69 $10.50 $16.88 $24.19 $19.93 $21.48 $26.27 $34.93 $32.60
Price Close $58.34 $56.90 $55.43 $21.81 $35.06 $50.24 $41.39 $44.61 $54.56 $72.54 $67.70 $105.34 $130.80 $130.80 $130.80 85.12% <-Total Growth 10 Stock Price
Increase 14.65% -2.46% -2.59% -60.66% 60.76% 43.31% -17.61% 7.78% 22.30% 32.97% -6.67% 55.59% 24.17% 0.00% 0.00% 6.35% <-IRR #YR-> 10 Stock Price
P/E 127.68 44.92 47.66 12.96 25.51 31.92 -11.97 26.56 24.21 27.37 21.02 49.03 42.11 30.27 27.52 20.54% <-IRR #YR-> 5 Stock Price
Trailing P/E 37.45 124.55 43.75 18.75 20.84 36.56 26.30 -12.90 32.49 32.20 25.55 32.70 60.88 42.11 30.27 9.05% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 2.70% 2.08% % Tot Ret 29.80% 9.20% T P/E 32.20 P/E: 26.04 26.56 22.62% <-IRR #YR-> 5 Price & Dividend
-$56.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $105.34
-$41.39 $0.00 $0.00 $0.00 $0.00 $105.34
-$56.90 $3.78 $3.78 $1.90 $1.04 $1.13 $1.16 $1.18 $1.27 $1.37 $106.36
-$41.39 $1.16 $1.18 $1.27 $1.37 $106.36
Price H/L Median $56.57 $55.11 $56.97 $35.91 $25.99 $43.74 $45.87 $42.73 $50.87 $62.70 $70.00 $88.60 $117.33 60.78% <-Total Growth 10 Stock Price
Increase 24.19% -2.59% 3.37% -36.97% -27.62% 68.28% 4.87% -6.84% 19.05% 23.25% 11.64% 26.57% 32.43% 4.86% <-IRR #YR-> 10 Stock Price
P/E 123.82 43.50 48.98 21.35 18.92 27.79 -13.27 25.44 22.58 23.66 21.73 41.24 37.78 14.07% <-IRR #YR-> 5 Stock Price
Trailing P/E 36.32 120.61 44.97 30.88 15.45 31.83 29.15 -12.36 30.29 27.83 26.41 27.51 54.61 7.76% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 57.68 51.95 29.31 21.87 30.98 98.20 74.92 74.32 66.72 55.15 37.07 43.85 16.13% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 64.49 51.27 53.27 58.92 52.21 62.01 72.29 27.79 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 2.90% 2.06% % Tot Ret 37.34% 12.76% T P/E 27.51 P/E: 23.12 23.66
-$55.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $88.60
-$45.87 $0.00 $0.00 $0.00 $0.00 $88.60
-$55.11 $3.78 $3.78 $1.90 $1.04 $1.13 $1.16 $1.18 $1.27 $1.37 $89.62
-$45.87 $1.16 $1.18 $1.27 $1.37 $89.62
High Months Sep Oct May Feb Dec Aug Apr Feb Dec Dec Apr Dec Jun
Pre-Split 2016 $30.09 $30.05 $29.40 $26.80 $16.92 $25.25 $25.02 $23.00 $28.29 $35.44 $38.20
Price High $62.49 $62.41 $61.06 $55.66 $35.14 $52.44 $51.96 $47.77 $58.75 $73.60 $79.33 $106.96 $131.32 71.39% <-Total Growth 10 Stock Price
Increase 3.83% -0.13% -2.16% -8.84% -36.87% 49.23% -0.91% -8.07% 23.00% 25.27% 7.79% 34.82% 22.77% 5.54% <-IRR #YR-> 10 Stock Price
P/E 136.77 49.26 52.50 33.09 25.58 33.32 -15.03 28.44 26.08 27.77 24.63 49.79 42.28 15.53% <-IRR #YR-> 5 Stock Price
Trailing P/E 40.12 136.59 48.20 47.86 20.89 38.17 33.02 -13.82 34.99 32.67 29.93 33.21 61.13 33.32 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 32.67 P/E: 28.11 27.77 51.96 P/E Ratio Historical High
-$62.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $106.96
-$51.96 $0.00 $0.00 $0.00 $0.00 $106.96
Low Months Mar/Oct Nov Apr Dec Feb Jan Aug Jun Feb Jan Dec Jan Jan
Price Low $50.65 $47.81 $52.88 $16.16 $16.84 $35.04 $39.77 $37.69 $42.99 $51.80 $60.66 $70.24 $103.34 46.92% <-Total Growth 10 Stock Price
Increase 63.80% -5.62% 10.60% -69.44% 4.24% 108.01% 13.52% -5.22% 14.05% 20.48% 17.12% 15.79% 47.12% 3.92% <-IRR #YR-> 10 Stock Price
P/E 110.86 37.74 45.46 9.60 12.26 22.26 -11.50 22.45 19.08 19.54 18.83 32.70 33.27 12.05% <-IRR #YR-> 5 Stock Price
Trailing P/E 32.52 104.64 41.74 13.89 10.01 25.50 25.27 -10.90 25.60 22.99 22.89 21.81 48.10 22.26 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 22.89 P/E: 19.31 19.54 42.78 P/E Ratio Historical High
-$47.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $70.24
Price Close US$ $49.80 $49.32 $54.54 $17.76 $33.27 $50.47 $40.68 $44.86 $51.40 $62.47 $48.91 $78.59 $96.92 $96.92 $96.50 59.33% <-Total Growth 10 Stock Price
Increase 20.68% -0.96% 10.57% -67.44% 87.37% 51.69% -19.38% 10.26% 14.58% 21.54% -21.71% 60.69% 23.32% 0.00% -0.43% 4.77% <-IRR #YR-> 10 Stock Price
P/E 127.05 45.37 46.33 12.93 25.43 31.97 -12.02 26.67 24.26 27.35 21.03 49.12 42.14 30.29 27.41 14.07% <-IRR #YR-> 5 Stock Price
Trailing P/E 38.48 125.83 50.16 15.09 24.22 38.57 25.78 -13.25 30.56 29.49 21.41 33.79 60.58 42.14 30.16 7.75% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 2.98% 2.03% % Tot Ret 38.45% 12.59% T P/E 29.49 P/E: 26.05 26.67 16.10% <-IRR #YR-> 5 Price & Dividend
-$49.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $78.59
-$40.68 $0.00 $0.00 $0.00 $0.00 $78.59
-$49.32 $3.82 $3.08 $1.81 $1.04 $1.11 $1.16 $1.11 $1.09 $0.99 $79.35
-$40.68 $1.16 $1.11 $1.09 $0.99 $79.35
Price H/L Median US$ $48.18 $48.28 $52.92 $34.81 $23.61 $41.68 $45.94 $42.08 $48.90 $55.34 $53.80 $63.81 $87.97 -0.43% 32.17% <-Total Growth 10 Stock Price
Increase 40.61% 0.19% 9.61% -34.22% -32.16% 76.52% 10.21% -8.41% 16.21% 13.17% -2.78% 18.60% 37.87% 0.74% 2.83% <-IRR #YR-> 10 Stock Price
P/E 122.92 44.40 44.96 25.34 18.05 26.41 -13.57 25.01 23.08 24.22 23.13 39.88 38.25 0.31% 6.79% <-IRR #YR-> 5 Stock Price
Trailing P/E 37.23 123.16 48.67 29.57 17.19 31.86 29.11 -12.43 29.07 26.12 23.55 27.43 54.98 6.04% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 62.43 55.65 32.69 22.12 31.94 111.92 82.26 74.04 64.67 53.52 31.87 41.38 8.79% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 77.62 57.55 56.68 57.54 46.58 52.89 66.71 25.18 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 3.21% 2.00% % Tot Ret 53.13% 22.72% T P/E 26.12 P/E: 24.62 24.22
-$48.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $63.81
-$45.94 $0.00 $0.00 $0.00 $0.00 $63.81
-$48.28 $3.82 $3.08 $1.81 $1.04 $1.11 $1.16 $1.11 $1.09 $0.99 $64.56
-$45.94 $1.16 $1.11 $1.09 $0.99 $64.56
High Months US$ Sep Oct Nov Feb Dec Dec Apr Apr Oct Dec Apr Dec Jun
Pre-Split 2016 $26.67 $26.76 $29.53 $27.20 $16.14 $24.30 $25.77 $22.85 $26.96 $30.97 $30.54
Price High $55.39 $55.58 $61.33 $56.49 $33.52 $50.47 $53.52 $47.45 $55.99 $64.32 $63.43 $78.78 $97.13 41.75% <-Total Growth 10 Stock Price
Increase 16.67% 0.34% 10.35% -7.89% -40.66% 50.56% 6.05% -11.33% 17.99% 14.87% -1.39% 24.21% 23.29% 3.55% <-IRR #YR-> 10 Stock Price
P/E 141.30 51.12 52.10 41.12 25.62 31.97 -15.81 28.21 26.43 28.15 27.27 49.24 42.23 8.04% <-IRR #YR-> 5 Stock Price
Trailing P/E 42.79 141.78 56.41 47.99 24.40 38.57 33.91 -14.02 33.28 30.36 27.76 33.87 60.71 30.09 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 30.36 P/E: 28.18 28.15 51.12 P/E Ratio Historical High
-$55.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $78.78
-$53.52 $0.00 $0.00 $0.00 $0.00 $78.78
Low Months US$ Oct Nov Jan Dec Feb Jan Dec Jun Feb Jan Dec Jan Jan
Price Low $40.98 $40.98 $44.51 $13.13 $13.71 $32.90 $38.36 $36.70 $41.81 $46.35 $44.17 $48.83 $78.81 19.17% <-Total Growth 10 Stock Price
Increase 94.58% 0.00% 8.62% -70.51% 4.43% 140.00% 16.60% -4.33% 13.92% 10.88% -4.70% 10.54% 61.40% 1.77% <-IRR #YR-> 10 Stock Price
P/E 104.53 37.69 37.81 9.55 10.48 20.84 -11.33 21.81 19.74 20.29 18.99 30.52 34.27 4.95% <-IRR #YR-> 5 Stock Price
Trailing P/E 31.66 104.53 40.93 11.15 9.98 25.14 24.30 -10.84 24.85 21.88 19.34 20.99 49.26 20.57 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 20.99 P/E: 20.01 20.29 37.69 P/E Ratio Historical High
-$40.98 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $48.83
Price Close US$ Waste Connection $15.32 $18.47 $20.60 $21.05 $22.23 $27.53 $33.14 $33.79 $43.63 $43.99 $56.32 $78.59 $96.92 $96.92 $96.92 325.50% <-Total Growth 10 Stock Price
Increase 20.56% 11.53% 2.18% 5.61% 23.84% 20.38% 1.96% 29.12% 0.83% 28.03% 39.54% 23.32% 0.00% 0.00% 6.22% <-IRR #YR-> 10 Stock Price
P/E 18.85% <-IRR #YR-> 5 Stock Price
Trailing P/E 6.54% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 0.32% 0.58% % Tot Ret 4.90% 3.01% T P/E #NUM! P/E: #NUM! #NUM! 19.44% <-IRR #YR-> 5 Price & Dividend
-$18.47 $0.00 $0.00 $0.00 $0.00 -$33.14 $0.00 $0.00 $0.00 $0.00 $78.59
-$33.14 $0.00 $0.00 $0.00 $0.00 $78.59
-$18.47 $0.00 $0.00 $0.00 $0.08 -$33.14 $0.37 -$0.19 $0.48 $0.18 $79.21
-$33.14 $0.37 -$0.19 $0.48 $0.18 $79.21
Long Term Debt US$ $2,149 $3,618 Debt
Change 68.36% 68.36% <-Median-> 1 Change
Long Term Debt CDN$ $2,976 $4,858 Debt
Change 63.24% 63.24% <-Median-> 1 Change
Ratio to Market Cap 0.84 0.26 0.55 <-Median-> 1 Debt/Market Cap Ratio
Goodwill and Intangibles US$ $1,354 $1,032 $1,217 $1,125 $1,103 $1,064 $5,457 Intangibles Goodwill
Change -23.77% 17.91% -7.52% -1.97% -3.57% 412.97% -2.77% <-Median-> 6 Change
Goodwill and Intangibles CDN$ $1,350 $1,054 $1,215 $1,197 $1,280 $1,473 $7,328 Intangibles Goodwill
Change -21.91% 15.25% -1.47% 6.92% 15.11% 397.40% 11.01% <-Median-> 6 Change
Ratio to Market Cap 0.46 0.45 0.49 0.40 0.33 0.42 0.40 0.42 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap US$ $1,137 $1,271 $1,512 $492 $1,319 $2,951 $2,312 $2,484 $2,843 $3,372 $2,562 $13,769 $17,015 $17,015 $16,941 983.53% <-Total Growth 10 Market Cap
Market Cap CDN$ $1,332 $1,466 $1,536 $604 $1,390 $2,937 $2,353 $2,470 $3,017 $3,916 $3,547 $18,456 $22,963 $22,963 $22,963 1158.86% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 30.46 31.49 32.65 33.15 40.94 51.75 58.11 56.23 55.46 55.29 53.20 154.05 175.94 389.27% <-Total Growth 10 Diluted
Change 138.72% 3.37% 3.69% 1.53% 23.50% 26.42% 12.29% -3.23% -1.38% -0.30% -3.78% 189.59% 14.20% 2.61% <-Median-> 10 Change
Basic # of Shares in Millions 22.84 25.77 27.23 27.79 35.58 46.44 58.11 56.23 55.46 55.29 53.20 153.55 175.37 495.95% <-Total Growth 10 Basic
Change 78.98% 12.82% 5.70% 2.03% 28.04% 30.53% 25.12% -3.23% -1.38% -0.30% -3.78% 188.64% 14.21% 3.87% <-Median-> 10 Change
Difference 0.0% 0.0% 1.8% -0.2% 11.4% 25.9% -2.2% -1.5% -0.3% -2.4% -1.5% 14.1% 0.1% -0.26% <-Median-> 10 Difference
$1,009.72 <-12 mths 26.96%
# of Shares in Millions 22.84 25.76 27.72 27.72 39.65 58.47 56.84 55.37 55.30 53.98 52.39 175.20 175.557 175.557 175.557 21.13% <-IRR #YR-> 10 Shares
Change 78.99% 12.80% 7.59% 0.00% 43.03% 47.48% -2.79% -2.58% -0.12% -2.39% -2.94% 234.41% 0.20% 0.00% 0.00% 25.25% <-IRR #YR-> 5 Shares
CF fr Op $M US$ $106.9 $159.4 $220.0 $187.8 $256.3 $293.9 $395.7 $336.8 $450.7 $450.7 $415.0 $795.3 $1,149.9 $1,330.7 $1,418.5 399.03% <-Total Growth 10 Cash Flow
Increase 119.46% 49.02% 38.06% -14.67% 36.49% 14.67% 34.66% -14.90% 33.84% 0.00% -7.92% 91.63% 44.58% 15.73% 6.60% SO Buy Backs S Iss.
5 year Running Average $74.6 $114.3 $144.6 $186.1 $223.5 $270.7 $294.1 $346.7 $385.6 $409.8 $489.7 $652.3 $828.3 $1,021.9 556.78% <-Total Growth 10 CF 5 Yr Running
CFPS US$ $4.68 $6.19 $7.94 $6.77 $6.46 $5.03 $6.96 $6.08 $8.15 $8.35 $7.92 $4.54 $6.55 $7.58 $8.08 -26.62% <-Total Growth 10 Cash Flow per Share
Increase 22.61% 32.11% 28.32% -14.67% -4.57% -22.25% 38.52% -12.64% 34.01% 2.45% -5.13% -42.69% 44.29% 15.73% 6.60% 17.44% <-IRR #YR-> 10 Cash Flow
5 year Running Average $3.84 $5.10 $5.88 $6.41 $6.48 $6.63 $6.26 $6.54 $6.91 $7.49 $7.01 $7.10 $6.99 $6.93 14.98% <-IRR #YR-> 5 Cash Flow
P/CFPS on Median 10.29 7.80 6.67 5.14 3.65 8.29 6.60 6.92 6.00 6.63 6.79 14.06 13.43 -3.05% <-IRR #YR-> 10 Cash Flow per Share
P/CFPS on Close 10.64 7.97 6.87 2.62 5.15 10.04 5.84 7.38 6.31 7.48 6.17 17.31 14.80 -8.20% <-IRR #YR-> 5 Cash Flow per Share
122.62% Diff M/C 2.22% <-IRR #YR-> 8 CFPS 5 yr Running
Excl.Working Capital CF $13.54 $14.20 -$1.66 $14.92 -$20.16 $20.36 $33.01 $75.39 -$7.25 $25.37 -$15.69 $35.22 $0.00 $0.00 $0.00 1.11% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $120.5 $173.6 $218.4 $202.7 $236.1 $314.2 $428.7 $412.2 $443.5 $476.1 $399.3 $830.5 $1,149.9 $1,330.7 $1,418.5 378.50% <-Total Growth 10 Cash Flow less WC
Increase 143.11% 44.06% 25.82% -7.19% 16.50% 33.08% 36.44% -3.86% 7.60% 7.36% -16.13% 107.98% 38.45% 15.73% 6.60% 16.95% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $81 $120 $153 $190 $229 $280 $319 $367 $415 $432 $512 $660 $837 $1,026 14.14% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $5.28 $6.74 $7.88 $7.31 $5.96 $5.37 $7.54 $7.44 $8.02 $8.82 $7.62 $4.74 $6.55 $7.58 $8.08 16.31% <-IRR #YR-> 8 CF less WC 5 Yr Run
Increase 35.82% 27.71% 16.94% -7.19% -18.55% -9.76% 40.35% -1.32% 7.73% 9.99% -13.58% -37.81% 38.17% 15.73% 6.60% 12.84% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $4.14 $5.38 $6.22 $6.63 $6.65 $6.81 $6.73 $6.87 $7.44 $7.89 $7.33 $7.15 $7.06 $6.91 -3.45% <-IRR #YR-> 10 CFPS - Less WC
P/CFPS on Median 9.13 7.17 6.72 4.76 3.96 7.76 6.09 5.65 6.10 6.27 7.06 13.46 13.43 14.14% <-IRR #YR-> 5 CFPS - Less WC
P/CFPS on Close 9.44 7.32 6.92 2.43 5.59 9.39 5.39 6.03 6.41 7.08 6.42 16.58 14.80 12.79 11.94 16.31% <-IRR #YR-> 5 CFPS 5 yr Running
CF/-WC P/CF Med 10 yr 6.65 5 yr 6.79 P/CF Med 10 yr 6.19 5 yr 6.27 139.21% Diff M/C 1.47% <-IRR #YR-> 5 CFPS 5 yr Running
$1,363.52 <-12 mths 22.27%
CF fr Op $M CDN$ $124.7 $185.7 $217.4 $229.9 $269.1 $293.0 $404.1 $336.2 $479.4 $522.9 $574.7 $1,067.9 $1,552.8 $1,797.0 $1,915.5 475.05% <-Total Growth 10 Cash Flow
Increase 112.57% 48.97% 17.08% 5.75% 17.05% 8.87% 37.94% -16.81% 42.60% 9.07% 9.90% 85.82% 45.41% 15.73% 6.60% SO Buy Backs S Iss.
5 year Running Average $90 $127 $163 $205 $239 $283 $306 $356 $407 $463 $596 $840 $1,103 $1,382 562.87% <-Total Growth 10 CF 5 Yr Running
CFPS CDN$ $5.46 $7.21 $7.84 $8.29 $6.79 $5.01 $7.11 $6.07 $8.67 $9.69 $10.97 $6.10 $8.85 $10.24 $10.91 -15.44% <-Total Growth 10 Cash Flow per Share
Increase 18.76% 32.06% 8.82% 5.75% -18.16% -26.18% 41.90% -14.61% 42.77% 11.74% 13.24% -44.43% 45.12% 15.73% 6.60% 19.12% <-IRR #YR-> 10 Cash Flow
5 year Running Average $4.72 $5.76 $6.68 $7.12 $7.03 $7.01 $6.66 $6.73 $7.31 $8.50 $8.30 $8.85 $9.17 $9.41 21.45% <-IRR #YR-> 5 Cash Flow
P/CFPS on Median 10.37 7.65 7.26 4.33 3.83 8.73 6.45 7.04 5.87 6.47 6.38 14.54 13.26 -1.66% <-IRR #YR-> 10 Cash Flow per Share
P/CFPS on Close 10.69 7.89 7.07 2.63 5.16 10.03 5.82 7.35 6.29 7.49 6.17 17.28 14.79 -3.03% <-IRR #YR-> 5 Cash Flow per Share
128.86% Diff M/C 2.75% <-IRR #YR-> 8 CFPS 5 yr Running
Excl.Working Capital CF $15.78 $16.55 -$1.64 $18.27 -$21.17 $20.30 $33.71 $75.27 -$7.72 $29.44 -$21.73 $47.29 $0.00 $0.00 $0.00 3.43% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $140.4 $202.2 $215.8 $248.2 $247.9 $313.3 $437.9 $411.5 $471.7 $552.3 $553.0 $1,115.2 $1,552.8 $1,797.0 $1,915.5 451.39% <-Total Growth 10 Cash Flow less WC
Increase 135.48% 44.01% 6.69% 15.02% -0.10% 26.35% 39.77% -6.03% 14.64% 17.10% 0.11% 101.67% 39.25% 15.73% 6.60% 18.62% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $97 $134 $173 $211 $245 $293 $332 $376 $437 $485 $621 $849 $1,114 $1,387 20.56% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $6.15 $7.85 $7.78 $8.95 $6.25 $5.36 $7.70 $7.43 $8.53 $10.23 $10.55 $6.36 $8.85 $10.24 $10.91 17.29% <-IRR #YR-> 8 CF less WC 5 Yr Run
Increase 31.56% 27.66% -0.84% 15.02% -30.15% -14.33% 43.78% -3.54% 14.78% 19.97% 3.15% -39.69% 38.97% 15.73% 6.60% 16.23% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $5.06 $6.10 $7.08 $7.40 $7.24 $7.21 $7.14 $7.06 $7.85 $8.89 $8.62 $8.91 $9.25 $9.38 -2.08% <-IRR #YR-> 10 CFPS - Less WC
P/CFPS on Median 9.20 7.02 7.32 4.01 4.16 8.16 5.95 5.75 5.96 6.13 6.63 13.92 13.26 -3.75% <-IRR #YR-> 5 CFPS - Less WC
P/CFPS on Close 9.49 7.25 7.12 2.44 5.61 9.38 5.37 6.00 6.40 7.09 6.41 16.55 14.79 12.78 11.99 2.49% <-IRR #YR-> 8 CFPS 5 yr Running
*Operational cash flow Per Share (OPS) CF/-WC P/CF Med 10 yr 6.46 5 yr 6.47 P/CF Med 10 yr 6.05 5 yr 6.13 144.59% Diff M/C 3.64% <-IRR #YR-> 5 CFPS 5 yr Running
-$7.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.10 Cash Flow per Share
-$7.11 $0.00 $0.00 $0.00 $0.00 $6.10 Cash Flow per Share
-$6.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.30 CFPS 5 yr Running
-$7.01 $0.00 $0.00 $0.00 $0.00 $8.30 CFPS 5 yr Running
-$202 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,115 Cash Flow less WC
-$438 $0 $0 $0 $0 $1,115 Cash Flow less WC
-$173 $0 $0 $0 $0 $0 $0 $0 $621 CF less WC 5 Yr Run
-$293 $0 $0 $0 $0 $621 CF less WC 5 Yr Run
-$7.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.36 CFPS - Less WC
-$7.70 $0.00 $0.00 $0.00 $0.00 $6.36 CFPS - Less WC
OPM 18.40% 24.06% 23.70% 20.58% 25.41% 20.55% 21.50% 17.75% 22.25% 22.44% 21.55% 23.56% -2.08% <-Total Growth 10 OPM
Increase -39.77% 30.75% -1.49% -13.15% 23.46% -19.12% 4.63% -17.44% 25.30% 0.85% -3.94% 9.31% Should increase or be stable.
Diff from Median -16.0% 9.9% 8.2% -6.0% 16.0% -6.1% -1.8% -18.9% 1.6% 2.4% -1.6% 7.6% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 21.90% 5 Yrs 22.25% should be zero, it is a check on calculations
Current Assets US$ $136.80 $250.59 $260.56 $313.08 $301.66 $295.64 $275.24 $832.57 $877.34 Liquidity ratio of 1.5 and up, best
Current Liabilities $178.85 $302.73 $297.12 $307.37 $301.96 $330.43 $300.15 $692.18 $725.12 0.91 <-Median-> 8 Ratio
Liquidity 0.76 0.83 0.88 1.02 1.00 0.89 0.92 1.20 1.21 1.00 <-Median-> 5 Ratio
Curr Long Term Debt $6.907 $5.969 $5.428 $0.494 $0.494 $0.494
Liquidity Less CLTD 1.04 1.02 0.91 0.92 1.20 1.21
Current Assets CDN$ $108.41 $131.67 $144.67 $170.70 $143.66 $249.84 $266.12 $312.55 $320.85 $342.97 $381.14 $1,117.89 $1,184.76 Liquidity ratio of 1.5 and up, best
Current Liabilities $161.33 $148.88 $170.01 $207.68 $187.82 $301.82 $303.46 $306.85 $321.16 $383.34 $415.63 $929.39 $979.20 0.89 <-Median-> 10 Ratio
Liquidity 0.67 0.88 0.85 0.82 0.76 0.83 0.88 1.02 1.00 0.89 0.92 1.20 1.21 1.00 <-Median-> 5 Ratio
Liq. with CF aft div 0.96 1.50 1.51 1.43 1.80 1.60 2.00 1.90 2.29 2.08 2.13 2.16 2.62 2.13 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.38 0.71 0.37 0.71 0.54 0.67 0.98 0.70 1.23 1.11 1.04 1.51 2.62 1.11 <-Median-> 5 Ratio
Curr Long Term Debt $6.90 $6.35 $6.30 $0.68 $0.66 $0.67
Liquidity Less CLTD 1.04 1.02 0.91 0.92 1.20 1.21 1.02 <-Median-> 5 Ratio
Liq. with CF aft div 1.95 2.33 2.12 2.13 2.16 2.62 2.13 <-Median-> 5 Ratio
Assets US$ $1,474 $1,516 $1,995 $1,912 $1,998 $3,390 $3,078 $3,476 $3,393 $3,376 $3,245 $11,193 $11,469 Debt Ratio of 1.5 and up, best
Liabilities $982 $1,744 $1,784 $2,203 $2,103 $2,148 $2,116 $5,538 $5,816 1.67 <-Median-> 8 Ratio
Debt Ratio 2.03 1.94 1.72 1.58 1.61 1.57 1.53 2.02 1.97 1.58 <-Median-> 5 Ratio
Assets CDN$ $1,717.7 $1,766.7 $1,971 $2,341 $2,098 $3,380 $3,143 $3,470 $3,608 $3,917 $4,493 $15,029 $15,488 Debt Ratio of 1.5 and up, best
Liabilities $659.6 $783.3 $1,091 $1,381 $1,031 $1,739 $1,823 $2,199 $2,237 $2,491 $2,930 $7,436 $7,854 1.71 <-Median-> 10 Ratio
Debt Ratio 2.60 2.26 1.81 1.70 2.03 1.94 1.72 1.58 1.61 1.57 1.53 2.02 1.97 1.58 <-Median-> 5 Ratio
Total Book Value $907.8 $843.9 $891.2 $784.3 $1,015.5 $1,646.6 $1,293.1 $1,272.6 $1,289.6 $1,228.8 $1,128.9 $5,654.9 $5,653.2 570.09% <-Total Growth 10 Book Value
Non-Con Int US$ $268.20 $242.04 $254.40 $197.08 $230.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.36 $7.51
Book Value US$ $639.62 $601.86 $636.77 $587.23 $785.53 $1,646.6 $1,293.1 $1,272.6 $1,289.6 $1,228.8 $1,128.9 $5,647.5 $5,645.7 838.34% <-Total Growth 10 Book Value
Check $1,371.6 $1,425.5 $1,563.2 $7,592.8 $7,634.1
Total Book Value $1,058.2 $983.3 $880.6 $960.5 $1,066.4 $1,641.7 $1,320.7 $1,270.4 $1,371.6 $1,425.5 $1,563.2 $7,592.8 $7,634.1 672.16% <-Total Growth 10 Book Value
Non-Con Int CDN$ $312.61 $282.03 $251.37 $241.34 $241.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.88 $10.14
Book Value CDN$ $745.54 $701.29 $629.19 $719.12 $824.90 $1,641.7 $1,320.7 $1,270.4 $1,371.6 $1,425.5 $1,563.2 $7,582.9 $7,624.0 $7,624.0 $7,624.0 981.28% <-Total Growth 10 Book Value
BV per share $32.64 $27.22 $22.70 $25.94 $20.81 $28.08 $23.24 $22.94 $24.80 $26.41 $29.84 $43.28 $43.43 $43.43 $43.43 59.00% <-Total Growth 10 Book Value per Share
Change 99.20% -16.61% -16.61% 14.29% -19.80% 34.94% -17.24% -1.26% 8.09% 6.48% 12.99% 45.06% 0.34% 0.00% 0.00% 49.81% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.73 2.02 2.51 1.38 1.25 1.56 1.97 1.86 2.05 2.37 2.35 2.05 2.70 1.97 P/B Ratio Historical Median
P/B Ratio (Close) 1.79 2.09 2.44 0.84 1.68 1.79 1.78 1.94 2.20 2.75 2.27 2.43 3.01 3.01 3.01 2.60% <-IRR #YR-> 10 Book Value
Change -42.44% 16.97% 16.81% -65.58% 100.45% 6.20% -0.45% 9.15% 13.14% 24.88% -17.40% 7.26% 23.75% 0.00% 0.00% 13.25% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 1.62 1.80 2.24 2.44 1.97 2.06 2.38 2.73 2.63 2.75 2.87 1.98 2.03 2.41 <-Median-> 10 A/BV
Debt/Equity Ratio 0.62 0.80 1.24 1.44 0.97 1.06 1.38 1.73 1.63 1.75 1.87 0.98 1.03 1.41 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.01 5 yr Med 2.05 49.81% Diff M/C
-$32.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $43.28
-$23.24 $0.00 $0.00 $0.00 $0.00 $43.28
$227.10 <-12 mths 4.90%
Comprehensive Income US$ $81.16 $121.31 -$213.25 $107.99 $84.20 $85.16 $50.45 $215.71 165.78% <-Total Growth 7 Comprehensive Income
NCI 10.07 11.133 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.78 -107.76% <-Total Growth 7 Comprehensive Income
Shareholders $27.74 -$64.94 $156.42 $71.09 $110.17 -$213.25 $107.99 $84.20 $85.16 $50.45 $216.49 680.44% <-Total Growth 10 Comprehensive Income
Increase -334% 340.86% -54.55% 54.97% -293.55% 150.64% -22.04% 1.15% -40.76% 329.12% 1.1% <-Median-> 5 Comprehensive Income
5 Yr Running Average $60.10 $11.90 $46.49 $32.04 $34.86 $22.91 $108.86 22.81% <-IRR #YR-> 10 Comprehensive Income
ROE US$ 3.3% -7.3% 19.9% 7.0% 6.7% -16.5% 8.5% 6.5% 6.9% 4.5% 3.8% #NUM! <-IRR #YR-> 5 Comprehensive Income
5Yr Median 6.7% 6.7% 7.0% 6.7% 6.7% 6.5% 6.5% 10.41% <-IRR #YR-> 6 5 Yr Running Average
% Difference from NI -29.60% -244.71% 207.69% 16.84% 48.67% -8.72% 14.45% -28.63% -32.69% -59.27% -12.58% 55.69% <-IRR #YR-> 5 5 Yr Running Average
Median Values Diff 5, 10 yr -10.7% -28.6% 6.5% <-Median-> 5 Return on Equity
-$27.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $216.5
$213.2 $0.0 $0.0 $0.0 $0.0 $216.5
-$60.1 $0.0 $0.0 $0.0 $0.0 $0.0 $108.9
-$11.9 $0.0 $0.0 $0.0 $0.0 $108.9
Current Liability Coverage Ratio US$ 1.32 1.04 1.44 1.34 1.47 1.44 1.33 1.20 CFO / Current Liabilities
5 year Median 1.34 1.44 1.44 1.34 1.34 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio US$ 8.18% 11.45% 10.95% 10.60% 11.82% 9.27% 13.93% 11.86% 13.07% 14.10% 12.31% 7.42% CFO / Total Assets
5 year Median 11.45% 11.45% 10.95% 10.95% 10.95% 10.95% 11.82% 11.86% 13.07% 13.07% 12.31% 12.3% <-Median-> 5 Return on Assets
Return on Assets ROA US$ 0.6% 1.9% 1.6% 2.0% 2.4% 2.2% -6.4% 2.7% 3.5% 3.7% 3.8% 2.2% Net Income/Assets Return on Assets
5Yr Median 1.9% 1.9% 1.9% 1.9% 2.0% 2.0% 2.2% 2.4% 2.7% 3.5% 3.5% 3.5% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE US$ 1.4% 4.7% 5.0% 6.5% 6.0% 4.5% -15.2% 7.4% 9.1% 10.3% 11.0% 4.4% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 4.7% 5.0% 5.0% 5.0% 5.0% 5.0% 6.0% 6.0% 7.4% 9.1% 9.1% 9.1% <-Median-> 5 Return on Equity
Adjusted Net Income $51.34 $60.09 $102.44 $135.00 $113.19 $127.15 $153.08 -$6.89 395.2 192.73% <-Total Growth 7 Net Income
$264.21 <-12 mths 6.83%
Net Income US$ $11.76 $34.27 $38.46 $45.43 $53.73 $82.17 -$196.14 $94.36 $117.97 $126.52 $123.88 $246.54 619.36% <-Total Growth 10 Net Income US$
NCI $2.63 $6.17 $6.40 $7.36 $6.67 $8.06 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.78 -112.66% <-Total Growth 10 NCI
Shareholders $9.13 $28.10 $32.07 $38.06 $47.06 $74.11 -$196.14 $94.36 $117.97 $126.52 $123.88 $247.32 $414 $556 780.12% <-Total Growth 10 Net Income
Increase -44.95% 207.75% 14.12% 18.70% 23.64% 57.46% -364.67% -148.11% 25.03% 7.24% -2.09% 99.65% 67.39% 34.30% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $7.3 $13.4 $19.2 $24.8 $30.9 $43.9 -$1.0 $11.5 $27.5 $43.4 $53.3 $142.0 $205.9 $293.5 24.30% <-IRR #YR-> 10 Net Income
Operating Cash Flow $256.27 $293.86 $395.71 $336.76 $450.74 $450.74 $415.02 $795.31 #NUM! <-IRR #YR-> 5 Net Income
Investment Cash Flow -$419.68 -$419.68 -$311.30 -$530.53 -$261.77 -$289.46 -$311.13 -$296.40 26.64% <-IRR #YR-> 10 5 Yr Running Average
Accruals $210.48 $199.93 -$280.54 $288.13 -$71.00 -$34.76 $19.99 -$251.60 #NUM! <-IRR #YR-> 5 5 Yr Running Average
Total Assets $1,998 $3,390 $3,078 $3,476 $3,393 $3,376 $3,245 $11,193 Balance Sheet Assets
Accruals Ratio 10.54% 5.90% -9.12% 8.29% -2.09% -1.03% 0.62% -2.25% -1.03% <-Median-> 5 Ratio
-$28.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $247.3
$196.1 $0.0 $0.0 $0.0 $0.0 $247.3
-$13.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $142.0
$1.0 $0.0 $0.0 $0.0 $0.0 $142.0
Financial Cash Flow US$ -$116.57 $134.23 -$84.80 $209.59 -$183.51 -$94.75 -$98.75 -$354.87 C F Statement Financial Cash Flow
Accruals $327.05 $65.70 -$195.75 $78.54 $112.51 $59.98 $118.74 $103.27 Accruals
Accruals Ratio 16.37% 1.94% -6.36% 2.26% 3.32% 1.78% 3.66% 0.92% 2.26% <-Median-> 5 Ratio
$306.67 <-12 mths 5.50%
Comprehensive Inc CDN$ $85.23 $120.94 -$217.79 $107.81 $89.55 $98.80 $69.86 $290.68 241.06% <-Total Growth 7 Comprehensive Income
NCI $10.57 $11.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -100.00% <-Total Growth 7 NCI
Shareholders $32.32 -$64.17 $191.56 $74.66 $109.84 -$217.79 $107.81 $89.55 $98.80 $69.86 $290.68 799.33% <-Total Growth 10 Comprehensive Income
Increase -299% 398.51% -61.03% 47.13% -298.28% 149.50% -16.94% 10.32% -29.29% 316.09% 10.3% <-Median-> 5 Comprehensive Income
5 Yr Running Average $68.84 $18.82 $53.21 $32.81 $37.64 $29.64 $131.34 24.56% <-IRR #YR-> 10 Comprehensive Income
ROE CDN$ 3.3% -7.3% 19.9% 7.0% 6.7% -16.5% 8.5% 6.5% 6.9% 4.5% 3.8% #NUM! <-IRR #YR-> 5 Comprehensive Income
5Yr Median 6.7% 6.7% 7.0% 6.7% 6.7% 6.5% 6.5% 11.37% <-IRR #YR-> 6 5 Yr Running Average
% Difference from NI -29.6% -244.7% 207.7% 16.8% 48.7% 8.7% 14.5% -28.6% -32.7% -59.3% -12.6% 47.49% <-IRR #YR-> 5 5 Yr Running Average
Median Values Diff 5, 10 yr -1.9% -28.6% 6.5% <-Median-> 5 Return on Equity
-$32.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $290.68
$217.79 $0.00 $0.00 $0.00 $0.00 $290.68
-$68.84 $0.00 $0.00 $0.00 $0.00 $0.00 $131.34
-$18.82 $0.00 $0.00 $0.00 $0.00 $131.34
Current Liability Coverage Ratio CDN$ 0.87 1.36 1.27 1.20 1.32 1.04 1.44 1.34 1.47 1.44 1.33 1.20 CFO / Current Liabilities
5 year Median 1.10 1.27 1.20 1.27 1.27 1.27 1.32 1.34 1.44 1.44 1.34 1.34 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio CDN$ 8.18% 11.45% 10.95% 10.60% 11.82% 9.27% 13.93% 11.86% 13.07% 14.10% 12.31% 7.42% CFO / Total Assets
5 year Median 11.45% 11.45% 10.95% 10.95% 10.95% 10.95% 11.82% 11.86% 13.07% 13.07% 12.31% 12.3% <-Median-> 5 Return on Assets
Comments ROE -14.9%
Comments -196.136
Return on Assets ROA CDN$ 0.6% 1.9% 1.6% 2.0% 2.4% 2.2% -6.4% 2.7% 3.5% 3.7% 3.8% 2.2% Net Income/Assets Return on Assets
5Yr Median 2.5% 1.9% 1.9% 1.9% 1.9% 2.0% 2.0% 2.2% 2.4% 2.7% 3.5% 3.5% 3.5% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE CDN$ 1.4% 4.7% 5.0% 6.5% 6.0% 4.5% -15.2% 7.4% 9.1% 10.3% 11.0% 4.4% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 4.7% 5.0% 5.0% 5.0% 5.0% 5.0% 6.0% 6.0% 7.4% 9.1% 9.1% 9.1% <-Median-> 5 Return on Equity
$356.78 <-12 mths 7.44%
Net Income CDN$ $13.71 $39.93 $38.01 $55.63 $56.42 $81.92 -$200.32 $94.20 $125.47 $146.77 $171.54 $331.03
NCI $3.06 $7.19 $6.32 $9.02 $7.00 $8.04 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.05
Shareholders $10.64 $32.74 $31.69 $46.61 $49.42 $73.88 -$200.32 $94.20 $125.47 $146.77 $171.54 $332.08 $559 $751 914.20% <-Total Growth 10 Net Income
Increase -46.68% 207.65% -3.23% 47.10% 6.03% 49.49% -371.13% -147.02% 33.20% 16.97% 16.87% 93.59% 68.35% 34.30% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $9.0 $16.2 $21.6 $28.3 $34.2 $46.9 $0.3 $12.8 $28.5 $48.0 $67.5 $174.0 $267.0 $392.1 26.07% <-IRR #YR-> 10 Net Income
Operating Cash Flow $124.66 $185.70 $217.42 $229.92 $269.11 $292.98 $404.15 $336.19 $479.40 $522.90 $574.69 $1,067.87 #NUM! <-IRR #YR-> 5 Net Income
Investment Cash Flow -$245.64 -$166.68 -$522.99 -$211.22 -$440.72 -$418.43 -$317.94 -$529.64 -$278.41 -$335.80 -$430.83 -$397.97 26.77% <-IRR #YR-> 10 5 Yr Running Average
Accruals $131.63 $13.72 $337.26 $27.91 $221.03 $199.33 -$286.53 $287.64 -$75.51 -$40.33 $27.68 -$337.82 268.16% <-IRR #YR-> 5 5 Yr Running Average
Total Assets $1,718 $1,767 $1,971 $2,341 $2,098 $3,380 $3,143 $3,470 $3,608 $3,917 $4,493 $15,029 Balance Sheet Assets
Accruals Ratio 7.66% 0.78% 17.11% 1.19% 10.54% 5.90% -9.12% 8.29% -2.09% -1.03% 0.62% -2.25% -1.03% <-Median-> 5 Ratio
EPS/CF Ratio 0.07 0.16 0.15 0.19 0.22 0.29 -0.45 0.23 0.26 0.26 0.31 0.34 0.24 <-Median-> 10 EPS/CF Ratio
-$32.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $332.1
$200.3 $0.0 $0.0 $0.0 $0.0 $332.1
-$16.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $174.0
-$0.3 $0.0 $0.0 $0.0 $0.0 $174.0
Change in Close 14.65% -2.46% -2.59% -60.66% 60.76% 43.31% -17.61% 7.78% 22.30% 32.97% -6.67% 55.59% 24.17% 0.00% 0.00% Count 16 Years of data
up/down down down down down down Up down Count 8 50.00%
Meet Prediction? Yes % right Count 1 12.50%
Financial Cash Flow CDN$ $122.10 -$23.95 $308.51 -$15.38 -$122.42 $133.83 -$86.60 $209.24 -$195.18 -$109.92 -$136.74 -$476.48 C F Statement Financial CF
Accruals $9.53 $37.68 $28.75 $43.29 $343.44 $65.50 -$199.92 $78.40 $119.67 $69.59 $164.42 $138.66 Accruals
Accruals Ratio 0.55% 2.13% 1.46% 1.85% 16.37% 1.94% -6.36% 2.26% 3.32% 1.78% 3.66% 0.92% 2.26% <-Median-> 5 Ratio
Cash US$ $14.72 $4.99 $13.41 $14.14 $29.94 $31.98 $41.64 $35.78 $154.38 $268.47 Cash
Cash CDN$ $14.14 $9.28 $13.36 $18.03 $5.24 $13.37 $14.44 $29.89 $34.01 $48.30 $49.55 $207.29 $362.54 Cash
Cash per Share CDN$ $0.62 $0.36 $0.48 $0.65 $0.13 $0.23 $0.25 $0.54 $0.62 $0.89 $0.95 $1.18 $2.07 $0.89 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.06% 0.63% 0.87% 2.98% 0.38% 0.46% 0.61% 1.21% 1.13% 1.23% 1.40% 1.12% 1.58% 1.21% <-Median-> 5 % of Stock Price
Canada Revenues $769.08 $745.80
US Revenue $1,256.96 $1,263.20
Total $2,026.04 $2,009.00
Canada Percentage 37.96% 37.12%
US Percentage 62.04% 62.88%
Saved this information, but since this is now a corporation, I will look at Cash Flow, not Distributable Income.
Graham Pr Distr $37.45 $36.46 $35.59 $41.50
Prem/Disc 55.8% 56.1% 55.8% -47.4%
Notes:
June 2, 2017. Last estimates were for 2016, 2017 and 2018 of $1956M, $2025M and $2080M US$ for Revenue, $1.09, $1.42 and $1.52 US$ for EPS,
$3.38, $3.91 and $4.08 US$ for CFPS and $127M and $158M US$ for 2016 and 2017.
June 2016. Name was changed to Waste Connections Inc. from Progressive Waste Solutions Ltd. This was called a reverse merger where Waste Connections Inc took over
Progressive Waste Solutions but the results will be that the company will be domiciled in Canada.
July 2016. BIN on US exchange is $31.61. There is now WCN on both TSX and NYSE. Old web site is below. It seems to have changed also.
www.progressivewaste.com
2016. Waste Connections Inc. (NTSE-WCN) has amalgamated with Progressive Waste Solutions with Progressive Waste Solutions getting .4815 of a share of the new company and Waste Connections getting 2.076843 shares of Waste Connections.
May 10, 2016. Last estimates were for 2015, 2016 and 2017 of $1951M, $2028M and $2097M US$ for Revenue, $1.23, $1.52 and $1.66 US$ for EPS, $3.25, $3.13 and $4.35 US$ for CFPS and $137M, $167M and $183M US$ for Net Income.
May 23, 2015. Last estimates were for 2014, 2015 and 2016 of $2020.4M, $2087.9M and $2151.0M for Revenue US$, $1.10 and $1.24 US$ for EPS, $3.40, $3.52 and $3.86 for CFPS US$, $124M and $142M for 2014 and 2015 for Net Income US$.
May 14, 2014. Last estimates were at $2017M and $2089M US$ for Revenue, $1.12 and $1.21 US$ for EPS, $2.82 and $3.17 US for CFPS.
April 28, 2013. Last Estimates were for 2012 and 2013 at $1890M and $1962M US$ for Revenue, $1.12, $1.29 (and $1.41) for Adj EPS, $1.10, $1.31 and $1.43 for EPS and $1.58, $2.25 for CFPS
Feb 14, 2013, unaudited 2012 results in news release.
May 5, 2012. Last estimates were for 2011 and 2012 at $1844M and $2000M US$ for Revenue, $1.15 and $1.32 for EPS US$ and $3.07 and $3.48 CF US$.
Analysts are using a adjusted EPS. Biggest adjust this year, 2011 was for non-cash good will impairment charge.
The most significant adjustment to adjusted net income (A) in the year was a non-cash goodwill impairment U.S. northeast operations.charge of $360.6 million related to our
Shares were sold in 2010 and 2009 to pay down debt and to buy assets (about half and half).
July 2011. KEEP EYE ON, MAYBE SELL IF NO DIVIDEND INCREASES. Increased dividends in 2012.
July 1, 2011. Last I looked, I got estimates for 2010 and 2011 of $.89 and $1.15 for Earnings and $2.45 and $2.90 for Cash Flow.
May 2, 2011. Company changes name from IESI-BFC to Progressive Waste Solutions Ltd.
Jul 21, 2010. I got estimates for 2010 and 2011 last at $.85 and $1.02 for earnings and $2.40 and $2.52 for cash flow.
May 8, 2010. I last got estimates for 2009 and 2010 of $.80 and $.84 for earnings and $2.88 and $3.00 for cash flow.
July 31, 2009. There is still a big range in estimates for earnings. However, I am going with the lower ones. With change to corp. $.50 per share were considered special dividends.
May 27, 2009 BFI Canada Ltd. completed an amalgamation with its wholly-owned subsidiary, IESI-BFC Ltd. The name of the newly amalgamated Company is IESI-BFC Ltd. The Company. Symbol change
from BFC to BIN will continue to operate as "BFI Canada" in Canada and "IESI" in the United States.
April 2009 AR 2008. In July 2008, I picked up estimates of earnings at $.97, Distributible Cash at $2.95, Revenue at $1069.8 and Cash Flow of $3.09 per share.
The estimates for 2009 and 2010 have a huge variance ranging from $.64 and $.69 to $1.77 and $1.95 and various amounts in between. I do not know why this should be?
However, all my sources seem to agree that this stock is a Buy.
Aug 18, 2008. Company annouced change from an Income Fund BFI to a Corporation and dividend decrease from $1.82 to $0.50 per year. On October 2, 2008 company started trading on
TSX as a non-income Trust. Income Trust was wound up effective 30 June 2009.
AP 2007. Stock price not doing well. However, TD still has it as an action buy. G&M says strong buy. They seem to be making money? But could we all be wrong on this?
Always wrong to go against the market. TD expects the stock price in one year to be $34 from $23.92 March 10, 2008 for an 49.7% return??????
AP 2006. Last 3 years stock price has been treading water only. I think stock got too high, but that I paid a reasonable price in 2007 for this stock.
On TD Bank's Action Buy list still on 1 July 2008
The company changed from BFI Canada Income Fund (TSX-BFC.UN) Oct 2008 To BFI Canada (TSX-BFC). This was a change from an Income Trust to a corporation.
In June 2009, the company changed to IESI-BFC Ltd (TSX-BIN). The company was known as IESI in US and BFC in Canada. In May 2011 the company changed to Progressive Waste Solutions Ltd (TSX-BIN).
April 15, 2002. BFI Canada Income Fund was started and it holds the common Shares and notes of BFI Canada Inc.
Adjusted net income and EPS exclude such things as restructuring expenses, goodwill impairment, amortization and net gain or loss on sale of capital assets.
Sector:
Services, Industrial
What should this stock accomplish?
Would I buy this company and Why.
Restricted Shares
Restricted Shares are share based compensation.
Dividends
Dividends are paid now in cycle 2 of February, May, August and November.
Dividends are paid in Cycle 1, that is January, April, July and October. Dividends are declared in one month and payable in the following month.
For example, the dividend for shareholder of record on September 30, 2014 is payable on October 15, 2014.
Why I bought this stock
I first bought this stock in 2007 because TD Securities had a very favourable report on this stock and had it on it action buy lists. I had money because I had recently sold RIM.
At that time it was an income fund.
In 2010, I needed to buy something for Pension Account. I have this already and it is on TD Action Buy List. Of 13 analysts, 11 say strong buy and 2 hold.
Purchased some for $27.73 in 2007 and this time it is cheaper.
How they make their money.
Waste Connections is an integrated solid waste services company that provides waste collection, transfer, disposal and recycling services in mostly exclusive and secondary markets in the U.S. and Canada.
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.
Also, for the Operational Profit Margin, a higher percentage is better. With the OPM, you should only compare companies in similar industries.
Need to buy something for Pension Acct. I have this already and it is on TD Action Buy List. Of 13 analysts, 11 say strong buy and 2 hold.
Purchased some for $27.73 in 2007 and this time it is cheaper. Spreadsheet measures
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Apr 14 2013 May 18 2014 May 24 2015 May 10 2016 Jun 02 2016
Mittelstaedt, Ronald J. 0.134 0.08%
Chair & CEO - Shares - Amount $17.502
Options - percentage 0.199 0.11%
Options - amount $26.057
Bouck, Steven 0.208 0.12%
President - Shares - Amount $27.145
Options - percentage 0.042 0.02%
Options - amount $5.445
Pio, Domenic Dan 0.076 0.14% 0.000 0.00% 0.000 0.00% Used to be a
CEO - Shares - Amount $5.118 $0.000 $0.000 Subsidiary Executivem then
Options - percentage 0.042 0.08% 0.142 0.08% 0.069 0.04% CEO, now officer
Options - amount $2.867 $14.943 $8.970 files last May 2016
Quarin, Joseph 0.178 0.32% 0.175 0.32% 0.355 0.68%
CEO - Shares - Amount $9.698 $12.726 $24.058
Options - percentage 0.765 1.38% 0.822 1.52% 0.597 1.14%
Options - amount $41.725 $59.641 $40.429
Jackman, Worthing F. 0.051 0.03%
CFO - Shares - Amount $6.701
Options - percentage 0.069 0.04%
Options - amount $8.963
Herman, William P. M. 0.018 0.01%
CFO - Shares - Amount $1.940
Options - percentage 0.043 0.02%
Options - amount $4.519
Kidson, Ian 0.011 0.02% 0.026 0.05% 0.027 0.05%
CFO - Shares - Amount $0.581 $1.863 $1.831
Options - percentage 0.017 0.03% 0.040 0.07% 0.040 0.08%
Options - amount $0.945 $2.883 $2.691
Reuters Options Value 0.000 $0
Black, Matthew Stephen 0.015 0.01%
Officer - Shares - Amount $1.958
Options - percentage 0.012 0.01%
Options - amount $1.614
Grimaldi, Loreto 0.007 0.01% 0.000 0.00%
Officer - Shares - Amount $0.478 $0.000
Options - percentage 0.004 0.01% 0.029 0.02%
Options - amount $0.304 $3.021
Cairns, Ivan Robert 0.058 0.11% 0.000 0.00%
Officer - Shares - Amount $4.212 $0.000
Options - percentage 0.039 0.07% 0.000 0.00%
Options - amount $2.852 $0.000
Hulligan, William 0.088 0.16%
COO $4.823
Options - percentage 0.026 0.05%
Options - amount $1.409
Start of Year percentage 0.240 0.43%
Amount $10.706
Davis, Robert H. 0.009 0.01%
Director - Shares - Amount $1.160
Options - percentage 0.001 0.00%
Options - amount $0.154
Dillon, John T. 0.017 0.03% 0.023 0.04% 0.024 0.01%
Director - Shares - Amount $1.214 $1.533 $2.539
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
DeGroote, Michael H. 0.015 0.03%
Director - Shares - Amount $0.794
Options - percentage 0.000 0.00%
Options - amount $0.000
Carrigan, Keith 0.430 0.78%
Director 2012 $23.463
0.000 0.00%
Director 2013 $0.000
Forese, James John 0.065 0.12% 0.069 0.13% 0.071 0.04%
Chairman - Shares - Amt $4.726 $4.700 $7.530
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
Smith, Phillip Lee 0.034 0.06%
Subsidiary Executive $1.840
Options - percentage 0.000 0.00%
Options - amount $0.000
IESI Corporation 11.138 20.14% 11.138 20.63% 11.138 21.26%
10% Holder $607.648 $807.961 $754.066
Progressive Waste Solutions Ltd. 5.827 10.79% 6.215 11.86%
10% Holder $422.684 $420.774
Increase in O/S Shares 0.028 0.05% 0.009 0.02% 0.012 0.02% 0.050 0.10% 0.567 0.32%
due to SO 2013 $1.249 $0.491 $0.871 $3.385 $59.678
Book Value $0.673 $0.218 $0.265 $0.265 $0.000
Insider Buying -$0.530 -$0.489 -$0.150
Insider Selling $0.421 $0.160 $3.039
Net Insider Selling 2013 $0.571 -$0.109 -$0.329 $2.889
% of Market Cap 0.01% 0.00% 0.00% 0.01%
On May 28 2014
Increase in O/S Shares 0.218 0.39% 0.168 0.30% 0.058 0.11%
due to RS 2013 $11.894 $9.166 $3.927
Book Value $130,000
Increase in O/S Shares 0.227 0.41% 0.180 0.33% 0.108 0.21%
Total Increase 2013 $12.385 $9.820 $7.312
Book Value $130,000
Directors 6 8 8 7 7
Women 0 0% 1 13% 1 13% 1 14% 1 14%
Minorities 0 0% 0 0% 1 13% 1 14% 0 0%
Institutions/Holdings 162 75.82% 177 81.20% 203 71.15% 229 78.70% 214 89.83%
Total Shares Held 88.657 160.31% 93.526 173.26% 79.689 152.10% 86.020 49.10% 157.882 89.93%
Increase/Decrease 0.734 0.84% 1.653 1.80% -4.043 -4.83% -0.743 -0.86% -1.129 -0.71%
Starting No. of Shares 87.922 91.873 83.733 86.763 159.011
Copyright 2008 Website of SPBrunner. All rights reserved.