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
$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 US$
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 US$ 409.65%
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 US$ 83.46%
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 US$ 589.93%
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 US$ 83.58%
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 US$ -25.06%
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 US$ -40.48%
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 US$ 101.89%
*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 US$ 10.40%
$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 CDN$
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 CDN$ 487.28%
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 CDN$ 141.19%
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 CDN$ 592.95%
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 CDN$ 112.22%
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 CDN$ -13.64%
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 CDN$ -21.76%
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 CDN$ 93.87%
*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 CDN$ 22.57%
-$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 US$
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 US$ 136.72%
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 US$ 10.65%
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 US$ 89.37%
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 US$ 8.67%
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
* 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 US$
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 CDN$
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 CDN$ 172.79%
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 CDN$ 45.47%
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 CDN$ 90.14%
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 CDN$ 18.77%
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
* 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 CDN$
-$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 US$
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 US$
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 US$ 47.16%
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 US$ 147.26%
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 US$ 158.93%
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 US$ 387.81%
* 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 CDN$
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 CDN$
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 CDN$ 69.58%
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 CDN$ 162.14%
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 CDN$ 150.22%
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 CDN$ 411.77%
* 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 US$ Waste Con.
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 US$ Waste Con.
Increase 320.00% 17.46% -150.00% -356.76% -61.26% 234.24% 17.07% 0.00% 0.00% Count 7 Years of data US$ Waste Con.
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 US$ Waste Con.
Yield H/L Price #NUM! <-Median-> 0 Yield H/L Price US$ Waste Con.
Yield on High Price #NUM! <-Median-> 0 Yield on High Price US$ Waste Con.
Yield on Low Price #NUM! <-Median-> 0 Yield on Low Price US$ Waste Con.
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 US$ Waste Con.
Payout Ratio EPS #NUM! <-Median-> 0 DPR EPS US$ Waste Con.
DPR EPS 5 Yr Running #NUM! <-Median-> 0 DPR EPS 5 Yr Running US$ Waste Con.
Payout Ratio CFPS #NUM! <-Median-> 0 DPR CF US$ Waste Con.
DPR CF 5 Yr Running #NUM! <-Median-> 0 DPR CF 5 Yr Running US$ Waste Con.
Payout Ratio CFPS WC #NUM! <-Median-> 0 DPR CF WC US$ Waste Con.
DPR CF WC 5 Yr Running #NUM! <-Median-> 0 DPR CF WC 5 Yr Running US$ Waste Con.
Median values 12.71% <-IRR #YR-> 6 Dividends US$ Waste Con.
* Dividends per share 14.32% <-IRR #YR-> 5 Dividends US$ Waste Con.
-$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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$ -75.70%
* 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 US$ -31.59%
-$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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$ -71.99%
* 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 CDN$ -10.07%
CDN$
-$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 CDN$
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 CDN$
Yield if held 15 yrs 4.34% 3.26% 2.13% #NUM! <-Median-> 0 Paid Median Price CDN$
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 CDN$
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 CDN$
Cost covered if held 15 years 138.08% 98.57% 60.55% #NUM! <-Median-> 0 Paid Median Price CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$ 85.12%
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 CDN$ 154.50%
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 CDN$
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 CDN$
-$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 CDN$
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 CDN$ 60.78%
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 CDN$ 93.17%
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$ 71.39%
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 CDN$ 105.84%
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 CDN$
Median 10, 5 Yrs T P/E 32.67 P/E: 28.11 27.77 51.96 P/E Ratio Historical High CDN$
-$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 CDN$
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 CDN$ 46.92%
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 CDN$ 76.61%
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 CDN$
Median 10, 5 Yrs T P/E 22.89 P/E: 19.31 19.54 42.78 P/E Ratio Historical High CDN$
-$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 US$
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 US$ 59.33%
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 US$ 93.17%
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 US$
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 US$
-$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 US$
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 US$ 32.17%
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 US$ 38.89%
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 US$
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 US$
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 US$
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 US$
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 US$ 41.75%
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 US$ 47.20%
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 US$
Median 10, 5 Yrs T P/E 30.36 P/E: 28.18 28.15 51.12 P/E Ratio Historical High US$
-$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 US$
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 US$ 19.17%
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 US$ 27.30%
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 US$
Median 10, 5 Yrs T P/E 20.99 P/E: 20.01 20.29 37.69 P/E Ratio Historical High US$
-$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 US$ Waste Con
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 US$ 325.50% Waste Con
P/E #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 18.85% <-IRR #YR-> 5 Stock Price US$ 137.15% Waste Con
Trailing P/E #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 6.54% <-IRR #YR-> 10 Price & Dividend US$ Waste Con
Median 10, 5 Yrs D. per yr 0.32% 0.58% % Tot Ret 4.90% 3.01% T P/E #REF! P/E: #REF! #REF! 19.44% <-IRR #YR-> 5 Price & Dividend US$ Waste Con
-$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 US$
Change 68.36% 68.36% <-Median-> 1 Change US$
Long Term Debt CDN$ $2,976 $4,858 Debt CDN$
Change 63.24% 63.24% <-Median-> 1 Change CDN$
Ratio to Market Cap 0.84 0.26 0.55 <-Median-> 1 Debt/Market Cap Ratio CDN$
Goodwill and Intangibles US$ $1,354 $1,032 $1,217 $1,125 $1,103 $1,064 $5,457 Intangibles Goodwill US$
Change -23.77% 17.91% -7.52% -1.97% -3.57% 412.97% -2.77% <-Median-> 6 Change US$
Goodwill and Intangibles CDN$ $1,350 $1,054 $1,215 $1,197 $1,280 $1,473 $7,328 Intangibles Goodwill CDN$
Change -21.91% 15.25% -1.47% 6.92% 15.11% 397.40% 11.01% <-Median-> 6 Change CDN$
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 CDN$
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 US$
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 CDN$
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 580.03%
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 208.25%
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 US$
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 US$
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 US$
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 US$ 399.03%
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 US$ 100.99%
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 US$ -26.62%
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 US$ -34.80%
122.62% Diff M/C 2.22% <-IRR #YR-> 8 CFPS 5 yr Running US$ 82.38%
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 US$ 5.67%
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 US$
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 US$ 378.50%
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 US$ 93.73%
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 US$ 533.11%
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 US$ 82.96%
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 US$ -29.64%
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 US$ -37.15%
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 US$ 77.23%
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 US$ 7.58%
$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 CDN$
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 CDN$
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 CDN$
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 CDN$ 475.05%
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 CDN$ 164.23%
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 CDN$ -15.44%
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 CDN$ -14.28%
128.86% Diff M/C 2.75% <-IRR #YR-> 8 CFPS 5 yr Running CDN$ 75.90%
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 CDN$ 18.39%
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 CDN$
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 CDN$ 451.39%
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 CDN$ 154.68%
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 CDN$ 537.09%
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 CDN$ 112.13%
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 CDN$ -18.92%
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 CDN$ -17.38%
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 CDN$ 70.26%
*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 CDN$ 19.58%
-$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 CDN$
-$7.11 $0.00 $0.00 $0.00 $0.00 $6.10 Cash Flow per Share CDN$
-$6.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.30 CFPS 5 yr Running CDN$
-$7.01 $0.00 $0.00 $0.00 $0.00 $8.30 CFPS 5 yr Running CDN$
-$202 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,115 Cash Flow less WC CDN$
-$438 $0 $0 $0 $0 $1,115 Cash Flow less WC CDN$
-$173 $0 $0 $0 $0 $0 $0 $0 $621 CF less WC 5 Yr Run CDN$
-$293 $0 $0 $0 $0 $621 CF less WC 5 Yr Run CDN$
-$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 CDN$
-$7.70 $0.00 $0.00 $0.00 $0.00 $6.36 CFPS - Less WC CDN$
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 CDN$
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. CDN$
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 CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 21.90% 5 Yrs 22.25% should be zero, it is a check on calculations CDN$
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 US$
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 US$
Liquidity 0.76 0.83 0.88 1.02 1.00 0.89 0.92 1.20 1.21 1.00 <-Median-> 5 Ratio US$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
Liq. with CF aft div 1.95 2.33 2.12 2.13 2.16 2.62 2.13 <-Median-> 5 Ratio CDN$
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 US$
Liabilities $982 $1,744 $1,784 $2,203 $2,103 $2,148 $2,116 $5,538 $5,816 1.67 <-Median-> 8 Ratio US$
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 US$
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 CDN$
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 CDN$
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 CDN$
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 US$
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 US$
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 US$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$ 59.00%
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 CDN$ 86.26%
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 CDN$
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 CDN$
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 US$
NCI 10.07 11.133 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.78 -107.76% <-Total Growth 7 Comprehensive Income US$
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 US$
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 US$
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 US$ 680.44%
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 US$ 201.52%
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 US$ #DIV/0!
% 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 US$ 814.78%
Median Values Diff 5, 10 yr -10.7% -28.6% 6.5% <-Median-> 5 Return on Equity US$
-$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 US$
5 year Median 1.34 1.44 1.44 1.34 1.34 <-Median-> 5 Current Liability Cov Ratio US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
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 US$
$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$ 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 US$
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 US$
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 US$
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 US$ 780.12%
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 US$ 226.10%
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 US$ 960.70%
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 US$ 14786.86%
Total Assets $1,998 $3,390 $3,078 $3,476 $3,393 $3,376 $3,245 $11,193 Balance Sheet Assets US$
Accruals Ratio 10.54% 5.90% -9.12% 8.29% -2.09% -1.03% 0.62% -2.25% -1.03% <-Median-> 5 Ratio US$
-$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 US$
Accruals $327.05 $65.70 -$195.75 $78.54 $112.51 $59.98 $118.74 $103.27 Accruals US$
Accruals Ratio 16.37% 1.94% -6.36% 2.26% 3.32% 1.78% 3.66% 0.92% 2.26% <-Median-> 5 Ratio US$
$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 CDN$
NCI $10.57 $11.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -100.00% <-Total Growth 7 NCI CDN$
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 CDN$
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 CDN$
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 CDN$ 799.33%
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 CDN$ 233.47%
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 CDN$ #DIV/0!
% 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 CDN$ 597.95%
Median Values Diff 5, 10 yr -1.9% -28.6% 6.5% <-Median-> 5 Return on Equity CDN$
-$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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
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 CDN$
$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 CDN$
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 CDN$
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 CDN$ 914.20%
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 CDN$ 265.77%
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 CDN$ 972.09%
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 CDN$ 67535.14%
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 CDN$
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 CDN$
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 CDN$
-$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 CDN$
up/down down down down down down Up down Count 8 50.00% CDN$
Meet Prediction? Yes % right Count 1 12.50% CDN$
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 CDN$
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 CDN$
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 CDN$
Cash US$ $14.72 $4.99 $13.41 $14.14 $29.94 $31.98 $41.64 $35.78 $154.38 $268.47 Cash US$
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 CDN$
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 CDN$
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 CDN$
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.
My Stock