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.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ Q1 2023
Waste Connections Inc TSX: WCN NYSE: WCN https://investors.wasteconnections.com/ Fiscal Yr: Dec 31
Year 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/30/24 12/30/25 Value Description #Y Item
Accounting Rules US GAAP US GAAP US GAAP US GAAP US 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$ 0.9970 1.0213 0.9983 1.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2732 1.2678 1.3544 1.3341 1.3341 1.3341 35.67% <-Total Growth 10 USD - CDN$ USD - CDN$
Currency Dividends <--CDN$ US$--> Currency
Mths in Accting Yr. <--BIN WCN --> 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
$7,466.1 <-12 mths 3.53%
Revenue* US$ $1,429.8 $1,840.1 $1,896.7 $2,026.0 $2,009.0 $1,925.6 $3,375.9 $4,630.5 $4,922.9 $5,388.7 $5,446.0 $6,151.4 $7,211.9 $8,079 $8,676 $9,396 280.22% <-Total Growth 10 Revenue US$
Increase 41.78% 28.70% 3.08% 6.82% -0.84% -4.15% 75.32% 37.16% 6.32% 9.46% 1.06% 12.95% 17.24% 12.02% 7.39% 8.30% 14.29% <-IRR #YR-> 10 Revenue 280.22% US$
5 year Running Average $988.2 $1,223.8 $1,417.4 $1,640.2 $1,840.3 $1,939.5 $2,246.6 $2,793.4 $3,372.8 $4,048.7 $4,752.8 $5,307.9 $5,824.2 $6,455.4 $7,112.8 $7,902.8 9.27% <-IRR #YR-> 5 Revenue 55.75% US$
Revenue per Share $24.45 $32.37 $34.26 $36.64 $37.22 $24.50 $12.85 $17.57 $18.71 $20.44 $20.72 $23.64 $28.05 $31.42 $33.74 $36.54 15.18% <-IRR #YR-> 10 5 yr Running Average 310.89% US$
Increase -3.86% 32.39% 5.81% 6.95% 1.59% -34.16% -47.57% 36.80% 6.46% 9.26% 1.37% 14.09% 18.64% 12.02% 7.39% 8.30% 15.83% <-IRR #YR-> 5 5 yr Running Average 108.50% US$
5 year Running Average $28.40 $29.73 $29.89 $30.63 $32.99 $33.00 $29.09 $25.75 $22.17 $18.81 $18.06 $20.22 $22.31 $24.85 $27.51 $30.68 -1.98% <-IRR #YR-> 10 Revenue per Share -18.13% US$
P/S (Price/Sales) Med 1.14 0.95 0.82 0.89 0.99 1.46 3.31 3.55 3.91 4.13 3.53 4.99 4.86 4.39 4.09 3.78 9.80% <-IRR #YR-> 5 Revenue per Share 59.59% US$
P/S (Price/Sales) Close 1.38 0.84 0.87 0.94 1.12 1.33 4.08 4.04 3.97 4.44 4.95 5.76 4.73 4.32 4.03 3.72 -2.88% <-IRR #YR-> 10 5 yr Running Average -25.34% US$
*Revenue in M CDN $  P/S Med 20 yr  1.29 15 yr  1.46 10 yr  3.54 5 yr  4.13 22.22% Diff M/C -2.83% <-IRR #YR-> 5 5 yr Running Average -13.37% US$
$9,960.5 <-12 mths 1.97%
Revenue* CDN $1,425.5 $1,879.3 $1,893.5 $2,154.9 $2,330.6 $2,666.5 $4,532.8 $5,808.9 $6,715.9 $6,998.8 $6,933.8 $7,798.7 $9,767.7 $10,778 $11,575 $12,535 415.85% <-Total Growth 10 Revenue CDN$
Increase 34.61% 31.84% 0.76% 13.80% 8.16% 14.41% 69.99% 28.15% 15.61% 4.21% -0.93% 12.47% 25.25% 10.34% 7.39% 8.30% 17.83% <-IRR #YR-> 10 Revenue 415.85% CDN$
5 year Running Average $1,058.1 $1,279.6 $1,474.9 $1,682.4 $1,936.8 $2,185.0 $2,715.7 $3,498.7 $4,410.9 $5,344.6 $6,198.0 $6,851.2 $7,643.0 $8,455.5 $9,370.6 $10,490.9 10.95% <-IRR #YR-> 5 Revenue 68.15% CDN$
Revenue per Share $24.38 $33.07 $34.20 $38.97 $43.18 $33.93 $17.25 $22.05 $25.52 $26.55 $26.38 $29.97 $37.99 $41.91 $45.01 $48.75 17.88% <-IRR #YR-> 10 5 yr Running Average 418.21% CDN$
Increase -8.73% 35.62% 3.42% 13.94% 10.80% -21.41% -49.17% 27.82% 15.77% 4.02% -0.63% 13.60% 26.74% 10.34% 7.39% 8.30% 16.92% <-IRR #YR-> 5 5 yr Running Average 118.45% CDN$
5 year Running Average $30.89 $31.51 $31.73 $31.46 $34.76 $36.67 $33.50 $31.07 $28.38 $25.06 $23.55 $26.09 $29.28 $32.56 $36.25 $40.73 1.06% <-IRR #YR-> 10 Revenue per Share 11.08% CDN$
P/S (Price/Sales) Med 1.20 0.92 0.83 0.87 0.97 1.38 3.42 3.67 3.71 4.28 4.56 4.98 4.53 4.38 0.00 0.00 11.50% <-IRR #YR-> 5 Revenue per Share 72.30% CDN$
P/S (Price/Sales) Close 1.37 0.83 0.87 0.93 1.12 1.33 4.07 4.04 3.97 4.44 4.95 5.75 4.72 4.32 4.03 3.72 -0.80% <-IRR #YR-> 10 5 yr Running Average -7.72% CDN$
*Revenue in M CDN $  P/S Med 10 yr  3.69 5 yr  4.53 17.24% Diff M/C -1.18% <-IRR #YR-> 5 5 yr Running Average -5.76% CDN$
-$1,893.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $9,767.7
-$5,808.9 $0.0 $0.0 $0.0 $0.0 $9,767.7
-$1,474.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $7,643.0
-$3,498.7 $0.0 $0.0 $0.0 $0.0 $7,643.0
$3.89 <-12 mths 1.83%
Adjusted Net Income $667.3 $719.6 $695.8 $846.6 $985.3
Calculated EPS $2.52 $2.72 $2.64 $3.23 $3.82
Adj EPS* US$ $1.32 $1.55 $1.34 $1.53 $1.85 -$0.09 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.22 $4.77 $5.38 184.44% <-Total Growth 10 Earnings per Share US$
Increase 35.71% 17.89% -13.39% 13.82% 20.75% -104.68% -2088.04% 26.13% 16.44% 7.94% -2.94% 22.35% 18.27% 10.47% 13.03% 12.79% 9 1 10 Years of Data, EPS P or N 90.00% US$
Earnings Yield 3.9% 5.7% 4.5% 4.5% 4.4% -0.3% 3.3% 3.1% 3.4% 3.0% 2.6% 2.4% 2.9% 3.1% 3.5% 4.0% 11.02% <-IRR #YR-> 10 Earnings per Share 184.44% US$
5 year Running Average $1.00 $1.17 $1.24 $1.34 $1.52 $1.24 $1.27 $1.43 $1.63 $1.81 $2.35 $2.65 $2.99 $3.33 $3.74 $4.28 12.03% <-IRR #YR-> 5 Earnings per Share 76.51% US$
Payout Ratio 25.42% 22.94% 27.85% 23.37% 18.99% -368.16% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 24.17% 21.38% 18.96% 9.16% <-IRR #YR-> 10 5 yr Running Average 122.61% US$
5 year Running Average 82.44% 59.73% 42.40% 29.87% 23.37% 28.39% 30.01% 28.33% 27.62% 28.43% 25.60% 25.24% 25.42% 25.47% 24.57% 22.64% 15.81% <-IRR #YR-> 5 5 yr Running Average 108.28% US$
Price/AFFO Median 21.13 19.75 20.89 21.33 19.99 -415.56 24.79 28.81 29.00 31.06 27.68 36.50 35.71 32.72 28.95 25.66 28.25 <-Median-> 10 Price/AEPS Median US$
Price/AFFO High 25.58 23.01 23.56 24.42 23.23 -489.92 30.61 33.35 31.98 34.90 39.65 42.81 38.08 34.38 30.42 26.97 32.66 <-Median-> 10 Price/AEPS High US$
Price/AFFO Low 16.67 16.49 18.22 18.23 16.74 -341.21 18.97 24.28 26.03 27.21 15.71 30.20 33.34 31.05 27.47 24.36 21.62 <-Median-> 10 Price/AEPS Low US$
Price/AFFO Close 25.58 17.49 22.27 22.42 22.56 -377.78 30.54 32.78 29.46 33.38 38.85 42.19 34.70 32.19 28.48 25.25 31.66 <-Median-> 10 Price/AEPS Close US$
Trailing P/AFFO Close 34.71 20.62 19.29 25.52 27.25 17.66 -607.05 41.34 34.31 36.03 37.71 51.62 41.04 35.56 32.19 28.48 35.17 <-Median-> 10 Trailing P/AEPSClose US$
* ESP per share (US$) DPR 10 Yrs 23.91% 5 Yrs   24.74% P/CF 5 Yrs   in order 31.06 38.08 27.21 34.70 3.64% Diff M/C 13.95% Diff M/C 10 DPR 75% to 95% best US$
$5.19 <-12 mths 0.31%
Adj EPS* CDN$ $1.31 $1.58 $1.34 $1.63 $2.14 -$0.12 $2.30 $2.72 $3.44 $3.53 $3.36 $4.09 $5.17 $5.63 $6.36 $7.18 285.90% <-Total Growth 10 Earnings per Share CDN$
Increase 28.85% 20.77% -15.34% 21.26% 31.71% -105.58% -2027.68% 17.85% 26.62% 2.76% -4.85% 21.83% 26.34% 8.82% 13.03% 12.79% 9 1 10 Years of Data, EPS P or N 90.00% CDN$
Earnings Yield 3.9% 5.7% 4.5% 4.5% 4.4% -0.3% 3.3% 3.0% 3.4% 3.0% 2.6% 2.4% 2.9% 3.1% 3.5% 4.0% 14.46% <-IRR #YR-> 10 Earnings per Share 285.90% CDN$
5 year Running Average $1.08 $1.23 $1.31 $1.38 $1.60 $1.31 $1.46 $1.73 $2.10 $2.37 $3.07 $3.43 $3.92 $4.36 $4.92 $5.69 13.76% <-IRR #YR-> 5 Earnings per Share 90.56% CDN$
Payout Ratio 25.42% 22.94% 27.85% 23.37% 18.99% -368.16% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 24.17% 21.38% 18.96% 11.63% <-IRR #YR-> 10 5 yr Running Average 184.92% CDN$
5 year Running Average 83.97% 60.78% 44.34% 29.96% 23.20% 29.87% 31.25% 29.22% 28.09% 28.65% 25.59% 25.21% 25.38% 25.44% 24.53% 22.62% 17.73% <-IRR #YR-> 5 5 yr Running Average 126.17% CDN$
Price/FFO Median 22.23 19.31 21.25 20.86 19.52 -390.46 25.64 29.78 27.52 32.18 35.78 36.44 33.29 32.63 0.00 0.00 28.65 <-Median-> 10 Price/AEPS Median CDN$
Price/FFO High 26.66 21.87 23.75 24.09 22.91 -442.54 30.95 34.18 30.95 36.36 41.29 42.74 37.84 34.88 0.00 0.00 32.57 <-Median-> 10 Price/AEPS High CDN$
Price/FFO Low 17.81 16.74 18.74 17.63 16.13 -338.39 20.33 25.37 24.09 28.00 30.28 30.14 28.74 30.38 0.00 0.00 24.73 <-Median-> 10 Price/AEPS Low CDN$
Price/FFO Close 25.54 17.42 22.18 22.37 22.59 -377.66 30.48 32.84 29.48 33.39 38.83 42.10 34.69 32.18 28.47 25.24 31.66 <-Median-> 10 Price/AEPS Close CDN$
Trailing P/FFO Close 32.91 21.04 18.78 27.13 29.75 21.08 -587.60 38.70 37.32 34.31 36.95 51.29 43.83 35.02 32.18 28.47 35.63 <-Median-> 10 Trailing P/AEPSClose CDN$
* ESP per share  DPR 10 Yrs 23.91% 5 Yrs   24.74% P/CF 5 Yrs   in order 33.29 37.84 28.74 34.69 -3.34% Diff M/C 12.34% Diff M/C 10 DPR 75% to 95% best CDN$
-$1.34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.17
-$2.72 $0.00 $0.00 $0.00 $0.00 $5.17
-$1.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.92
-$1.73 $0.00 $0.00 $0.00 $0.00 $3.92
$3.32 <-12 mths 2.47%
Pre-Split 2016 $0.77 -$1.63 $0.81 $1.02 $1.10 $1.12
Pre-Split 2017 $1.60 -$3.39 $1.68 $2.12 $2.28 $2.33 $1.61
EPS Basic US$ $1.07 -$2.26 $1.12 $1.41 $1.52 $1.55 $1.07 $2.19 $2.07 $2.15 $0.78 $2.37 $3.25 189.80% <-Total Growth 10 EPS Basic US$
Pre-Split 2016 $0.76 -$1.63 $0.81 $1.02 $1.10 $1.12
Pre-Split 2017 $2.21 -$4.69 $2.33 $2.93 $3.16 $3.22 $1.60
EPS Diluted* $1.48 -$3.12 $1.55 $1.96 $2.11 $2.15 $1.07 $2.18 $2.07 $2.14 $0.78 $2.36 $3.24 $3.74 $4.30 $4.73 108.67% <-Total Growth 10 EPS Diluted US$
Increase 69.22% -311.69% -149.69% 25.93% 7.84% 1.82% -50.32% 104.38% -5.05% 3.38% -63.55% 202.56% 37.29% 15.43% 14.97% 10.00% 10 0 10 Years of Data, EPS P or N 100.00% US$
Earnings Yield 4.4% -11.3% 5.2% 5.4% 4.4% 4.8% 1.5% 2.4% 2.0% 1.8% 0.6% 1.4% 1.8% 2.1% 2.4% 2.6% 7.63% <-IRR #YR-> 10 Earnings per Share 108.67% US$
5 year Running Average $1.20 $0.35 $0.43 $0.55 $0.79 $0.93 $1.77 $1.89 $1.91 $1.92 $1.65 $1.91 $2.12 $2.45 $2.88 $3.67 8.25% <-IRR #YR-> 5 Earnings per Share 48.62% US$
10 year Running Average $0.56 $0.69 $0.81 $0.89 $1.06 $1.06 $1.16 $1.23 $1.36 $1.29 $1.84 $2.00 $2.18 $2.40 $2.66 17.29% <-IRR #YR-> 10 5 yr Running Average 392.54% US$
* Diluted ESP per share  E/P 10 Yrs 1.93% 5Yrs 1.81% 2.29% <-IRR #YR-> 5 5 yr Running Average 11.97% US$
$4.43 <-12 mths 0.93%
EPS Basic CDN$ $1.06 -$2.30 $1.12 $1.50 $1.77 $2.15 $1.44 $2.75 $2.82 $2.79 $0.99 $3.00 $4.40 293.17% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* $1.47 -$3.19 $1.55 $2.08 $2.45 $2.97 $1.43 $2.73 $2.82 $2.78 $0.99 $2.99 $4.39 $4.99 $5.74 $6.31 183.10% <-Total Growth 10 EPS Diluted CDN$
Increase 60.66% -316.85% -148.57% 34.16% 17.63% 21.53% -51.83% 90.95% 3.26% -1.57% -64.27% 201.28% 46.67% 13.70% 14.97% 10.00% 10 0 10 Years of Data, EPS P or N 100.00% CDN$
Earnings Yield 4.4% -11.6% 5.2% 5.7% 5.1% 6.6% 2.0% 3.1% 2.8% 2.4% 0.8% 1.7% 2.4% 2.8% 3.2% 3.5% 10.97% <-IRR #YR-> 10 Earnings 183.10% CDN$
5 year Running Average $1.30 $0.41 $0.49 $0.57 $0.87 $1.17 $2.10 $2.33 $2.48 $2.55 $2.15 $2.46 $2.80 $3.23 $3.82 $4.88 9.92% <-IRR #YR-> 5 Earnings 60.46% CDN$
10 year Running Average $0.68 $0.79 $0.90 $0.98 $1.24 $1.25 $1.41 $1.52 $1.71 $1.66 $2.28 $2.56 $2.86 $3.18 $3.52 19.13% <-IRR #YR-> 10 5 yr Running Average 475.49% CDN$
* Diluted ESP per share  E/P 10 Yrs 2.62% 5Yrs 2.36% 3.68% <-IRR #YR-> 5 5 yr Running Average 19.81% CDN$
-$1.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.39
-$2.73 $0.00 $0.00 $0.00 $0.00 $4.39
-$0.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.80
-$2.33 $0.00 $0.00 $0.00 $0.00 $2.80
Dividend US$, Pd US$ from 2017 $1.06 $1.15 $1.28 Estimates Dividend US$, Pd US$ fr 2017
Increase 12.17% 8.49% 11.30% Estimates Increase
Payout Ratio EPS 28.34% 26.74% 27.06% Estimates Payout Ratio EPS
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 $0.00 <-Median-> 10 Special Dividends US$
Pre-split 2017 $0.12
Dividend US$, Pd US$ from 2017 $0.33 $0.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.02 $1.02 $1.02 152.70% <-Total Growth 10 Dividends US$
Increase -42.55% 6.40% 5.12% -4.46% -1.88% -9.36% 59.06% -1.07% 16.00% 14.66% 14.29% 11.18% 11.83% 7.94% 0.00% 0.00% 13 7 20 Years of data, Count P, N 65.00% US$
Average Increases 5 Year Running -14.76% -14.83% -18.31% -15.34% -7.47% -0.84% 9.69% 8.46% 12.55% 15.86% 20.59% 11.01% 13.59% 11.98% 9.05% 6.19% 10.35% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $0.83 $0.70 $0.53 $0.40 $0.35 $0.35 $0.38 $0.41 $0.45 $0.51 $0.60 $0.67 $0.76 $0.85 $0.92 $0.97 43.99% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 1.20% 1.16% 1.33% 1.10% 0.95% 0.89% 1.19% 0.80% 0.79% 0.79% 1.04% 0.72% 0.69% 0.74% 0.84% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 0.99% 1.00% 1.18% 0.96% 0.82% 0.75% 0.96% 0.69% 0.72% 0.70% 0.73% 0.61% 0.65% 0.70% 0.72% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 1.52% 1.39% 1.53% 1.28% 1.13% 1.08% 1.55% 0.95% 0.88% 0.90% 1.83% 0.87% 0.74% 0.78% 1.02% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 0.99% 1.31% 1.25% 1.04% 0.84% 0.97% 0.96% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.75% 0.75% 0.75% 0.76% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 22.65% -11.39% 24.08% 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 27.27% 23.72% 21.56% 28.59% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 69.06% 196.59% 122.59% 73.33% 44.65% 37.84% 21.57% 21.47% 23.54% 26.74% 36.55% 35.15% 35.84% 34.54% 31.83% 26.40% 35.49% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 6.65% 5.11% 6.15% 4.38% 4.20% 6.02% 16.70% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.20% 11.27% 10.55% 11.24% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 12.76% 10.52% 8.42% 6.13% 5.13% 5.04% 6.17% 6.93% 8.50% 10.69% 12.49% 12.14% 12.26% 12.47% 12.35% 11.69% 7.71% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 6.22% 4.72% 5.02% 4.46% 3.97% 6.25% 15.99% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.20% 11.27% 10.55% 11.32% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 12.43% 10.24% 7.84% 5.83% 4.76% 4.76% 5.86% 6.80% 8.32% 10.70% 12.35% 12.11% 12.46% 12.61% 12.44% 11.80% 7.56% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median values 10 Yr Med 10 Yr Cl 0.84% 0.76% 5 Yr Med 5 Yr Cl 0.79% 0.73% 5 Yr Med Payout 31.07% 12.02% 12.46% 13.58% <-IRR #YR-> 5 Dividends 89.00% US$
* Dividends per share  10 Yr Med and Cur. -11.01% -1.33% 5 Yr Med and Cur. -4.61% 2.52% Last Div Inc ---> $0.230 $0.255 10.87% 9.71% <-IRR #YR-> 10 Dividends 152.70% US$
Dividends Growth 15 -1.72% <-IRR #YR-> 15 Dividends -22.96% US$
Dividends Growth 20 5.15% <-IRR #YR-> 20 Dividends US$
Dividends Growth 5 -$0.50 $0.00 $0.00 $0.00 $0.00 $0.95 Dividends Growth 5
Dividends Growth 10 -$0.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.95 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.95 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.95 Dividends Growth 20
Historical Dividends Historical High Div 6.26% Low Div 0.65% 10 Yr High 1.80% 10 Yr Low 0.61% Med Div 1.17% Close Div 1.02% Historical Dividends Div Yd Years
High/Ave/Median Values Curr diff Exp. -88.00% Exp 15.53% Exp. -58.28% 23.10% Exp. -35.82% Exp. -26.25% High/Ave/Median  1.26% 5
2.11% 10
Future Dividend Yield Div Yield 1.26% earning in 5 Years at IRR of 10.87% Div Inc. 67.52% Future Dividend Yield 3.53% 15
Future Dividend Yield Div Yield 2.11% earning in 10 Years at IRR of 10.87% Div Inc. 180.63% Future Dividend Yield
Future Dividend Yield Div Yield 3.53% earning in 15 Years at IRR of 10.87% Div Inc. 370.12% Future Dividend Yield
Future Dividend Paid Div Paid $1.93 earning in 5 Years at IRR of 13.58% Div Inc. 89.00% Future Dividend Paid Item Cur
Future Dividend Paid Div Paid $3.64 earning in 10 Years at IRR of 13.58% Div Inc. 257.21% Future Dividend Paid EPS 29.17%
Future Dividend Paid Div Paid $6.89 earning in 15 Years at IRR of 13.58% Div Inc. 575.13% Future Dividend Paid AEPS 24.74%
CFPS 12.46%
Dividend Covering Cost Total Div $6.69 over 5 Years at IRR of 13.58% Div Cov. 4.92% Dividend Covering Cost FCF  18.01%
Dividend Covering Cost Total Div $17.39 over 10 Years at IRR of 13.58% Div Cov. 12.81% Dividend Covering Cost
Dividend Covering Cost Total Div $37.63 over 15 Years at IRR of 13.58% Div Cov. 27.71% Dividend Covering Cost
Yield if held 5 years 1.01% 1.08% 1.03% 3.02% 1.58% 0.94% 1.86% 1.67% 1.69% 1.60% 2.33% 1.61% 1.33% 1.37% 1.12% 0.99% 1.64% <-Median-> 10 Paid Median Price US$
Yield if held 10 years 2.50% 1.80% 1.15% 0.84% 1.38% 1.32% 2.42% 3.84% 2.61% 2.76% 3.32% 3.01% 2.44% 2.19% 2.11% <-Median-> 10 Paid Median Price US$
Yield if held 15 years 3.35% 2.92% 2.19% 2.02% 2.30% 2.49% 4.26% 5.89% 3.50% 2.39% <-Median-> 6 Paid Median Price US$
Yield if held 20 years 6.32% 5.13% 3.36% 2.70% 6.32% <-Median-> 1 Paid Median Price US$
Cost covered if held 5 years 10.96% 9.49% 6.94% 8.37% 10.23% 6.02% 6.23% 7.13% 6.65% 6.14% 6.45% 5.67% 4.69% 4.48% 4.04% 4.03% 6.34% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 47.99% 34.71% 21.43% 15.61% 14.68% 12.29% 17.78% 25.05% 16.34% 17.19% 20.45% 19.13% 17.13% 16.84% 17.48% <-Median-> 10 Paid Median Price US$
Cost covered if held 15 years 61.58% 46.05% 29.89% 23.60% 23.80% 22.28% 35.47% 51.54% 32.98% 26.84% <-Median-> 6 Paid Median Price US$
Cost covered if held 20 years 86.97% 67.37% 45.00% 36.46% 86.97% <-Median-> 1 Paid Median Price US$
Yr  Item Tot. Growth Per Year
Dividend CDN$ Paid in US$ from 2017 $1.41 $1.53 $1.71 Estimates Div CDN$ Paid in US$ fr2017
Increase 10.49% 8.49% 11.30% Estimates Increase
Payout Ratio EPS 28.34% 26.74% 27.06% Estimates Payout Ratio EPS
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 $0.00 <-Median-> 10 Special Dividends CDN$
Pre-Split 2016 $0.50 $0.55 $0.56 $0.57 $0.61 $0.66 $1.02
Pre-split 2017 $1.04 $1.13 $1.16 $1.18 $1.27 $1.37 $1.02
Dividend CDN$ Paid in US$ from 2017 $0.33 $0.36 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.36 $1.36 $1.36 242.83% <-Total Growth 10 Dividends CDN$
Increase -45.45% 9.00% 2.75% 1.79% 7.02% 8.20% 54.23% -7.57% 26.14% 9.16% 12.03% 10.71% 19.47% 6.32% 0.00% 0.00% 16 3 20 Years of data, Count P, N 80.00% CDN$
Average Increases 5 Year Running -16.89% -16.43% -16.66% -16.30% -4.98% 5.75% 14.80% 12.73% 17.60% 18.03% 18.80% 10.10% 15.50% 11.54% 9.71% 7.30% 13.76% <-Median-> 10 Average Incr 5 Year Running CDN$
Dividends 5 Yr Running $0.91 $0.75 $0.58 $0.41 $0.37 $0.39 $0.46 $0.51 $0.59 $0.68 $0.79 $0.86 $0.99 $1.11 $1.21 $1.29 71.92% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 1.14% 1.19% 1.31% 1.12% 0.97% 0.94% 1.15% 0.78% 0.84% 0.76% 0.80% 0.72% 0.74% 0.74% 0.82% <-Median-> 10 Yield H/L Price CDN$
Yield on High  Price 0.95% 1.05% 1.17% 0.97% 0.83% 0.83% 0.95% 0.68% 0.74% 0.67% 0.70% 0.61% 0.65% 0.69% 0.72% <-Median-> 10 Yield on High  Price CDN$
Yield on Low Price 1.43% 1.37% 1.49% 1.33% 1.18% 1.09% 1.45% 0.91% 0.96% 0.87% 0.95% 0.87% 0.86% 0.80% 0.95% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 1.00% 1.32% 1.26% 1.04% 0.84% 0.97% 0.97% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.75% 0.75% 0.75% 0.76% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 22.65% -11.39% 24.08% 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 27.27% 23.72% 21.56% 28.59% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 69.77% 182.79% 119.12% 72.93% 42.62% 33.52% 21.74% 21.71% 23.72% 26.69% 36.50% 35.06% 35.59% 34.34% 31.63% 26.35% 34.29% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 6.65% 5.11% 6.15% 4.38% 4.20% 6.02% 16.70% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.20% 11.27% 10.55% 11.24% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 12.90% 10.65% 8.69% 6.13% 5.08% 5.05% 6.36% 7.16% 8.65% 10.65% 12.49% 12.12% 12.23% 12.46% 12.33% 11.69% 7.90% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 6.22% 4.72% 5.02% 4.46% 3.97% 6.25% 15.99% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.20% 11.27% 10.55% 11.32% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 12.53% 10.35% 8.10% 5.84% 4.73% 4.80% 6.08% 7.03% 8.50% 10.67% 12.36% 12.10% 12.44% 12.60% 12.42% 11.79% 7.76% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median values 10 Yr Med 10 Yr Cl 0.82% 0.76% 5 Yr Med 5 Yr Cl 0.76% 0.73% 5 Yr Med Payout 31.07% 12.02% 12.46% 15.33% <-IRR #YR-> 5 Dividends 104.05% CDN$
* Dividends per share  10 Yr Med and Cur. -8.46% -1.32% 5 Yr Med and Cur. -1.14% 2.57% Last Div Inc ---> $0.185 $0.205 10.81% 13.11% <-IRR #YR-> 10 Dividends 242.83% CDN$
Dividends Growth 15 0.36% <-IRR #YR-> 15 Dividends 5.60% CDN$
Dividends Growth 20 4.35% <-IRR #YR-> 20 Dividends CDN$
Dividends Growth 5 -$0.63 $0.00 $0.00 $0.00 $0.00 $1.28 Dividends Growth 5
Dividends Growth 10 -$0.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.28 Dividends Growth 10
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.28 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.28 Dividends Growth 20
Historical Dividends Historical High Div 5.38% Low Div 0.66% 10 Yr High 1.44% 10 Yr Low 0.62% Med Div 1.15% Close Div 1.04% Historical Dividends
High/Ave/Median Values Curr diff Exp. -86.04% Exp 13.80% Exp. -47.84% 21.14% Exp. -34.69% Exp. -28.11% High/Ave/Median 
Future Dividend Yield Div Yield 1.53% earning in 5 Years at IRR of 15.33% Div Inc. 104.05% Future Dividend Yield
Future Dividend Yield Div Yield 3.13% earning in 10 Years at IRR of 15.33% Div Inc. 316.37% Future Dividend Yield
Future Dividend Yield Div Yield 6.38% earning in 15 Years at IRR of 15.33% Div Inc. 749.60% Future Dividend Yield
Future Dividend Paid Div Paid $2.78 earning in 5 Years at IRR of 15.33% Div Inc. 104.05% Future Dividend Paid
Future Dividend Paid Div Paid $5.67 earning in 10 Years at IRR of 15.33% Div Inc. 316.37% Future Dividend Paid
Future Dividend Paid Div Paid $11.56 earning in 15 Years at IRR of 15.33% Div Inc. 749.60% Future Dividend Paid
Dividend Covering Cost Total Div $9.24 over 5 Years at IRR of 15.33% Div Cov. 5.10% Dividend Covering Cost
Dividend Covering Cost Total Div $25.30 over 10 Years at IRR of 15.33% Div Cov. 13.97% Dividend Covering Cost
Dividend Covering Cost Total Div $58.09 over 15 Years at IRR of 15.33% Div Cov. 32.06% Dividend Covering Cost
Yield if held 5 years 0.88% 0.99% 0.98% 1.59% 2.35% 1.51% 2.22% 2.20% 2.33% 2.07% 2.07% 1.81% 1.58% 1.44% 1.20% 1.13% 2.07% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 years 2.50% 1.91% 1.34% 1.17% 1.85% 1.65% 3.31% 4.98% 3.32% 3.50% 4.49% 4.01% 3.26% 2.92% 2.61% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 years 4.20% 3.98% 2.84% 2.57% 2.92% 3.37% 5.68% 7.85% 4.67% 3.14% <-Median-> 6 Paid Median Price CDN$
Yield if held 20 years 8.56% 6.85% 4.48% 3.61% 8.56% <-Median-> 1 Paid Median Price CDN$
Cost covered if held 5 years 12.02% 10.16% 7.62% 8.61% 10.72% 6.73% 7.45% 8.89% 8.68% 8.14% 8.42% 7.32% 6.15% 5.86% 5.31% 5.35% 8.28% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 54.01% 38.41% 23.55% 17.23% 16.36% 14.29% 20.91% 30.34% 20.21% 21.58% 26.35% 25.03% 22.59% 22.20% 21.25% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 70.95% 53.23% 34.75% 27.65% 28.12% 27.38% 44.06% 65.20% 42.27% 31.43% <-Median-> 6 Paid Median Price CDN$
Cost covered if held 20 years 104.23% 81.13% 54.64% 44.71% 104.23% <-Median-> 1 Paid Median Price CDN$
Yr  Item Tot. Growth Per Year
Revenue Growth US$ $4,630.5 $4,922.9 $5,388.7 $5,446.0 $6,151.4 $7,211.9 $33,751.3 55.75% <-Total Growth 5 Revenue Growth US$ 55.75% 9.27%
AEPS Growth $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $17.09 76.51% <-Total Growth 5 AEPS Growth 76.51% 12.03%
Net Income Growth $723.6 $746.0 $736.2 $260.6 $783.6 $1,131.8 $4,381.8 56.41% <-Total Growth 5 Net Income Growth 56.41% 9.36%
Cash Flow Growth $1,187.3 $1,411.2 $1,540.5 $1,408.5 $1,698.2 $2,022.5 $9,268.3 70.35% <-Total Growth 5 Cash Flow Growth 70.35% 11.24%
Dividend Growth $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $4.30 89.00% <-Total Growth 5 Dividend Growth 89.00% 13.58%
Stock Price Growth $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 86.86% <-Total Growth 5 Stock Price Growth 86.86% 13.32%
Revenue Growth US$ $1,896.7 $2,026.0 $2,009.0 $1,925.6 $3,375.9 $4,630.5 $4,922.9 $5,388.7 $5,446.0 $6,151.4 $7,211.9 $44,984.6 280.22% <-Total Growth 10 Revenue Growth US$ 280.22% 14.29%
AEPS Growth $1.34 $1.53 $1.85 -$0.09 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $23.44 184.44% <-Total Growth 10 AEPS Growth 184.44% 11.02%
Net Income Growth $94.2 $125.5 $146.8 $171.5 $330.0 $723.6 $746.0 $736.2 $260.6 $783.6 $1,131.8 $5,249.8 1101.54% <-Total Growth 10 Net Income Growth 1101.54% 28.23%
Cash Flow Growth $336.8 $450.7 $450.7 $415.0 $795.3 $1,187.3 $1,411.2 $1,540.5 $1,408.5 $1,698.2 $2,022.5 $11,716.8 500.57% <-Total Growth 10 Cash Flow Growth 500.57% 19.63%
Dividend Growth $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 152.70% <-Total Growth 10 Dividend Growth 152.70% 9.71%
Stock Price Growth $29.91 $34.27 $41.65 $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 343.26% <-Total Growth 10 Stock Price Growth 343.26% 16.06%
Dividends on Shares CDN$ $12.92 $13.83 $14.96 $23.07 $21.33 $26.90 $29.37 $32.90 $36.42 $43.52 $46.27 $46.27 $46.27 $255.21 No of Years 10 Total Dividends CDN$ 12/31/12
Paid  $1,011.15 $1,236.64 $1,644.30 $1,534.62 $2,387.71 $3,031.44 $3,445.22 $4,010.30 $4,437.68 $5,861.60 $6,102.32 $6,160.12 $6,160.12 $6,160.12 $6,102.32 No of Years 10 Worth $29.74 33.63
Total $6,357.53 Total
Dividends on Shares CDN$ $9.49 $10.36 $11.61 $12.86 $15.36 $16.33 $16.33 $16.33 $59.69 No of Years 5 Total Dividends CDN$ 12/31/17
Paid  $1,069.92 $1,215.96 $1,415.40 $1,566.24 $2,068.80 $2,153.76 $2,174.16 $2,174.16 $2,174.16 $2,153.76 No of Years 5 Worth $89.16 11.22
Total $2,213.45 Total
Dividends on Shares US$ $12.15 $11.92 $10.80 $17.18 $17.00 $19.72 $22.61 $25.84 $28.73 $32.13 $34.68 $34.68 $34.68 $198.08 No of Years 10 Total Dividends CDN$ 12/31/12
Paid  $1,016.80 $1,165.08 $1,415.99 $1,108.60 $1,781.37 $2,411.96 $2,524.50 $3,086.86 $3,487.38 $4,633.18 $4,507.04 $4,618.22 $4,618.22 $4,618.22 $4,507.04 No of Years 10 Worth $29.91 33.44
Total $4,705.12 Total
Graham Price AEPS $28.78 $28.78 $26.31 $30.12 $35.67 $30.96 $38.67 $42.70 $50.88 $52.11 $50.13 $56.01 $66.02 $68.95 $73.31 $77.85 150.95% <-Total Growth 10 Graham Price AEPS CDN$
Price/GP Ratio Med 1.01 1.06 1.08 1.13 1.17 1.51 1.53 1.89 1.86 2.18 2.40 2.66 2.61 2.66 1.88 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.21 1.20 1.21 1.30 1.38 1.71 1.84 2.17 2.09 2.47 2.77 3.12 2.97 2.85 2.13 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.81 0.92 0.96 0.95 0.97 1.31 1.21 1.61 1.63 1.90 2.03 2.20 2.25 2.48 1.62 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 1.16 0.96 1.13 1.21 1.36 1.46 1.82 2.09 1.99 2.26 2.60 3.08 2.72 2.63 2.47 2.33 2.04 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 16.36% -4.11% 13.04% 20.75% 35.58% 45.80% 81.59% 108.81% 99.17% 126.36% 160.36% 207.79% 171.86% 162.77% 147.16% 132.72% 103.99% <-Median-> 10 Graham Price
Graham Price EPS $30.49 $27.74 $28.29 $34.07 $38.12 $36.48 $30.49 $42.85 $46.11 $46.22 $27.25 $47.88 $60.80 $64.91 $69.60 $73.00 114.94% <-Total Growth 10 Graham Price EPS CDN$
Price/GP Ratio Med 0.96 1.10 1.01 1.00 1.10 1.28 1.94 1.89 2.05 2.46 4.41 3.12 2.83 2.83 1.99 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.15 1.25 1.13 1.15 1.29 1.45 2.34 2.17 2.31 2.78 5.09 3.66 3.22 3.03 2.32 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.77 0.96 0.89 0.84 0.91 1.11 1.54 1.61 1.80 2.14 3.73 2.58 2.45 2.63 1.70 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 1.10 0.99 1.05 1.07 1.27 1.24 2.30 2.08 2.20 2.55 4.79 3.60 2.95 2.79 2.60 2.48 2.25 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 9.84% -0.52% 5.13% 6.77% 26.85% 23.74% 130.31% 108.05% 119.76% 155.19% 379.00% 260.08% 195.19% 179.12% 160.31% 148.20% 125.03% <-Median-> 10 Graham Price
Pre-Split 2016 $24.19 $19.93 $21.48 $26.27 $34.93 $32.60
Pre-Split 2017 $50.24 $41.39 $44.61 $54.56 $72.54 $67.70 $105.34
Price Close CDN$ $33.49 $27.59 $29.74 $36.37 $48.36 $45.14 $70.23 $89.16 $101.33 $117.95 $130.52 $172.40 $179.48 $181.18 $181.18 $181.18 503.50% <-Total Growth 10 Stock Price CDN$ CDN$
Increase 43.31% -17.61% 7.78% 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 0.95% 0.00% 0.00% 34.10 <-Median-> 10 CAPE (10 Yr P/E)
P/E 22.76 -8.65 19.19 17.49 19.77 15.18 49.03 32.60 35.88 42.44 131.43 57.62 40.90 36.31 31.58 28.71 15.02% <-IRR #YR-> 5 Stock Price 101.30% CDN$
Trailing P/E 36.56 18.75 -9.32 23.46 23.26 18.45 23.62 62.25 37.05 41.77 46.96 173.60 59.99 41.29 36.31 31.58 19.69% <-IRR #YR-> 10 Stock Price 503.50% CDN$
CAPE (10 Yr P/E) 41.97 37.86 34.94 33.25 26.99 29.21 29.66 33.13 35.05 41.90 36.89 38.64 39.78 39.84 39.93 15.85% <-IRR #YR-> 5 Price & Dividend 106.88% CDN$
Median 10, 5 Yrs D.  per yr 1.05% 0.83% % Tot Ret 5.08% 5.25% T P/E 39.41 46.96 P/E:  38.39 42.44 20.75% <-IRR #YR-> 10 Price & Dividend 528.74% CDN$
Price 15 D.  per yr 0.93% % Tot Ret 7.76% CAPE Diff 6.50% 11.11% <-IRR #YR-> 15 Stock Price 385.70% CDN$
Price  20 D.  per yr 2.20% % Tot Ret 14.74% 12.71% <-IRR #YR-> 20 Stock Price 994.87% CDN$
Price  25 D.  per yr 2.39% % Tot Ret 15.56% 12.98% <-IRR #YR-> 21 Stock Price #DIV/0! CDN$
Price & Dividend 15 12.05% <-IRR #YR-> 15 Price & Dividend 413.84% CDN$
Price & Dividend 20 14.91% <-IRR #YR-> 20 Price & Dividend 1089.90% CDN$
Price & Dividend 25 15.37% <-IRR #YR-> 21 Price & Dividend #DIV/0! CDN$
Price  5 -$89.16 $0.00 $0.00 $0.00 $0.00 $179.48 Price  5
Price 10 -$29.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $179.48 Price 10
Price & Dividend 5 -$89.16 $0.79 $0.86 $0.97 $1.07 $180.76 Price & Dividend 5
Price & Dividend 10 -$29.74 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $180.76 Price & Dividend 10
Price 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $179.48 Price 15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $179.48 Price  20
Price  25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $179.48 Price  25
Price & Dividend 15 $0.33 $0.36 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $180.76 Price & Dividend 15
Price & Dividend 20 $0.33 $0.36 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $180.76 Price & Dividend 20
Price & Dividend 25 $0.33 $0.36 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $180.76 Price & Dividend 25
Price H/L Median $29.16 $30.58 $28.49 $33.91 $41.80 $46.67 $59.07 $80.85 $94.60 $113.69 $120.27 $149.22 $172.25 $183.69 504.67% <-Total Growth 10 Stock Price CDN$
Increase 68.28% 4.87% -6.84% 19.05% 23.25% 11.64% 26.57% 36.87% 17.01% 20.18% 5.79% 24.07% 15.43% 6.64% 19.72% <-IRR #YR-> 10 Stock Price 504.67% CDN$
P/E 19.81 -9.58 18.38 16.31 17.09 15.70 41.24 29.56 33.50 40.90 121.11 49.87 39.25 36.81 16.33% <-IRR #YR-> 5 Stock Price 113.06% CDN$
Trailing P/E 31.83 20.78 -8.93 21.88 20.10 19.08 19.87 56.45 34.59 40.26 43.27 150.26 57.57 41.86 20.82% <-IRR #YR-> 10 Price & Dividend 531.02% CDN$
P/E on Running 5 yr Average 22.43 74.89 58.65 60.00 47.98 39.83 28.18 34.65 38.11 44.61 55.87 60.54 61.62 56.90 17.23% <-IRR #YR-> 5 Price & Dividend 119.21% CDN$
P/E on Running 10 yr Average 44.85 36.01 37.88 42.47 37.76 47.17 57.36 62.09 66.49 72.36 65.43 67.17 64.33 29.00 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D.  per yr 1.10% 0.90% % Tot Ret 5.29% 5.21% T P/E 37.43 43.27 P/E:  36.38 40.90 Count 20 Years of data
-$28.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $172.25
-$80.85 $0.00 $0.00 $0.00 $0.00 $172.25
-$28.49 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $173.53
-$80.85 $0.79 $0.86 $0.97 $1.07 $173.53
High Months Aug Apr Feb Dec Dec Apr Dec Oct Sep May Feb Nov Dec Apr
Pre-Split 2016 $25.25 $25.02 $23.00 $28.29 $35.44 $38.20
Pre-Split 2017 $52.44 $51.96 $47.77 $58.75 $73.60 $79.33 $106.96
Price High $34.96 $34.64 $31.84 $39.17 $49.07 $52.89 $71.31 $92.80 $106.40 $128.46 $138.77 $175.03 $195.80 $196.36 514.87% <-Total Growth 10 Stock Price CDN$
Increase 49.23% -0.91% -8.07% 23.00% 25.27% 7.79% 34.82% 30.14% 14.66% 20.73% 8.03% 26.13% 11.87% 0.29% 19.92% <-IRR #YR-> 10 Stock Price 514.87% CDN$
P/E 23.76 -10.86 20.54 18.83 20.06 17.79 49.79 33.93 37.68 46.22 139.73 58.50 44.62 39.35 16.11% <-IRR #YR-> 5 Stock Price 110.99% CDN$
Trailing P/E 38.17 23.54 -9.98 25.27 23.59 21.62 23.98 64.79 38.91 45.49 49.93 176.25 65.44 44.75 32.84 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 42.20 49.93 P/E:  41.15 46.22 48.36 P/E Ratio Historical High CDN$
-$31.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $195.80
-$92.80 $0.00 $0.00 $0.00 $0.00 $195.80
Low Months Jan Aug Jun Feb Jan Dec Jan Jan Feb Jan Mar Feb Jun Jan
Price Low $23.36 $26.51 $25.13 $28.66 $34.53 $40.44 $46.83 $68.89 $82.80 $98.92 $101.77 $123.41 $148.70 $171.01 491.74% <-Total Growth 10 Stock Price CDN$
Increase 108.01% 13.52% -5.22% 14.05% 20.48% 17.12% 15.79% 47.12% 20.19% 19.47% 2.88% 21.26% 20.49% 15.00% 19.46% <-IRR #YR-> 10 Stock Price 491.74% CDN$
P/E 15.87 -8.31 16.21 13.78 14.12 13.60 32.70 25.19 29.32 35.59 102.48 41.25 33.89 34.27 16.64% <-IRR #YR-> 5 Stock Price 115.85% CDN$
Trailing P/E 25.50 18.02 -7.87 18.49 16.60 16.53 15.75 48.10 30.28 35.03 36.62 124.27 49.70 38.97 25.16 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 32.65 36.62 P/E:  31.01 35.59 34.91 P/E Ratio Historical High CDN$
-$25.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $148.70
US$ Price based on CDN$ Price, Exch $33.59 $27.02 $29.79 $34.20 $41.69 $32.60 $52.30 $71.07 $74.28 $90.81 $102.51 $135.98 $132.52 $135.81 $135.81 $135.81
Price Close US$ $33.64 $27.12 $29.91 $34.27 $41.65 $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $135.83 $135.83 $135.83 343.26% <-Total Growth 10 Stock Price US$ US$
Increase 51.69% -19.38% 10.26% 14.58% 21.54% -21.71% 60.69% 35.40% 4.67% 22.28% 12.97% 32.86% -2.72% 2.47% 0.00% 0.00% 35.01 <-Median-> 10 CAPE (10 Yr P/E)
P/E 22.79 -8.68 19.26 17.53 19.75 15.19 49.12 32.54 35.87 42.43 131.50 57.74 40.91 36.32 31.59 28.72 13.32% <-IRR #YR-> 5 Stock Price 86.86% US$
Trailing P/E 38.57 18.38 -9.57 22.07 21.30 15.46 24.40 66.51 34.06 43.86 47.93 174.71 56.17 41.92 36.32 31.59 16.06% <-IRR #YR-> 10 Stock Price 343.26% US$
CAPE (10 Yr P/E) 44.61 38.92 35.86 34.16 28.47 30.36 30.72 34.05 35.93 43.22 36.25 38.32 39.84 40.13 40.11 14.14% <-IRR #YR-> 5 Price & Dividend 92.21% US$
Median 10, 5 Yrs D.  per yr 0.94% 0.82% % Tot Ret 5.55% 5.81% T P/E 38.96 47.93 P/E:  38.39 42.43 17.00% <-IRR #YR-> 10 Price & Dividend 362.74% US$
Price 15 D.  per yr 0.89% % Tot Ret 8.95% 9.01% <-IRR #YR-> 15 Stock Price 264.60% US$
Price  20 D.  per yr 2.46% % Tot Ret 16.59% 12.37% <-IRR #YR-> 20 Stock Price 929.50% US$
Price  25 D.  per yr 3.97% % Tot Ret 20.59% 15.30% <-IRR #YR-> 21 Stock Price US$
Price & Dividend 15 9.89% <-IRR #YR-> 15 Price & Dividend 265.14% US$
Price & Dividend 20 14.82% <-IRR #YR-> 20 Price & Dividend 931.04% US$
Price & Dividend 25 19.27% <-IRR #YR-> 21 Price & Dividend US$
Price  5 -$70.94 $0.00 $0.00 $0.00 $0.00 $132.56 Price  5
Price 10 -$29.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $132.56 Price 10
Price & Dividend 5 -$70.94 $0.58 $0.67 $0.76 $0.85 $133.51 Price & Dividend 5
Price & Dividend 10 -$29.91 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $133.51 Price & Dividend 10
Price  15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $132.56 Price  15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $132.56 Price  20
Price  25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $132.56 Price  25
Price & Dividend 15 $0.33 $0.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $133.51 Price & Dividend 15
Price & Dividend 20 $0.33 $0.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $133.51 Price & Dividend 20
Price & Dividend 25 $0.33 $0.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $133.51 Price & Dividend 25
Price H/L Median US$ $27.79 $30.63 $28.05 $32.60 $36.89 $35.87 $42.54 $62.36 $73.09 $84.48 $73.07 $117.91 $136.40 $138.07 $138.07 $138.07 386.26% <-Total Growth 10 Stock Price US$
Increase 76.52% 10.21% -8.41% 16.21% 13.17% -2.78% 18.60% 46.60% 17.21% 15.58% -13.50% 61.36% 15.69% 1.22% 17.14% <-IRR #YR-> 10 Stock Price 386.26% US$
P/E 18.83 -9.80 18.07 16.67 17.50 16.71 39.88 28.61 35.31 39.47 93.68 49.96 42.10 36.92 16.94% <-IRR #YR-> 5 Stock Price 118.73% US$
Trailing P/E 31.86 20.75 -8.98 20.99 18.87 17.01 19.81 58.46 33.53 40.81 34.14 151.16 57.80 42.61 18.10% <-IRR #YR-> 10 Price & Dividend 407.03% US$
P/E on Running 5 yr Average 23.21 86.30 65.23 59.67 46.48 38.66 24.09 32.97 38.18 43.98 44.36 61.86 64.40 56.31 17.82% <-IRR #YR-> 5 Price & Dividend 124.82% US$
P/E on Running 10 yr Average 54.30 40.63 40.47 41.59 33.76 40.11 53.72 59.40 62.24 56.75 64.22 68.04 63.24 23.72 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 0.97% 0.88% % Tot Ret 5.34% 4.93% T P/E 33.84 40.81 P/E:  37.39 42.10
-$28.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $136.40
-$62.36 $0.00 $0.00 $0.00 $0.00 $136.40
-$28.05 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $137.35
-$62.36 $0.58 $0.67 $0.76 $0.85 $137.35
High Months US$ Dec Apr Apr Oct Dec Apr Dec Oct Sep May Feb Nov Nov Apr
Pre-Split 2016 $24.30 $25.77 $22.85 $26.96 $30.97 $30.54
Pre-Split 2017 $50.47 $53.52 $47.45 $55.99 $64.32 $63.43 $78.78
Price High $33.64 $35.68 $31.64 $37.33 $42.88 $42.28 $52.52 $72.18 $80.58 $94.93 $104.67 $138.27 $145.45 $145.10 $145.10 $145.10 359.75% <-Total Growth 10 Stock Price US$
Increase 50.56% 6.05% -11.33% 17.99% 14.87% -1.39% 24.21% 37.43% 11.64% 17.81% 10.26% 32.10% 5.19% -0.24% 16.48% <-IRR #YR-> 10 Stock Price 359.75% US$
P/E 22.79 -11.42 20.38 19.09 20.34 19.69 49.24 33.11 38.93 44.36 134.19 58.59 44.89 38.80 15.04% <-IRR #YR-> 5 Stock Price 101.51% US$
Trailing P/E 38.57 24.17 -10.13 24.04 21.93 20.05 24.46 67.67 36.96 45.86 48.91 177.27 61.63 44.78 30.26 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 41.41 48.91 P/E:  41.64 44.89 48.37 P/E Ratio Historical High US$
-$31.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $145.45
-$72.18 $0.00 $0.00 $0.00 $0.00 $145.45
Low Months US$ Jan Dec Jun Feb Jan Dec Jan Jan Feb Jan Mar Feb Feb Mar
Price Low $21.93 $25.57 $24.46 $27.87 $30.90 $29.45 $32.55 $52.54 $65.60 $74.02 $41.47 $97.54 $127.35 $131.04 $131.04 $131.04 420.55% <-Total Growth 10 Stock Price US$
Increase 140.00% 16.60% -4.33% 13.92% 10.88% -4.70% 10.54% 61.40% 24.86% 12.84% -43.97% 135.21% 30.56% 2.90% 17.94% <-IRR #YR-> 10 Stock Price 420.55% US$
P/E 14.86 -8.18 15.76 14.25 14.66 13.72 30.52 24.10 31.69 34.59 53.17 41.33 39.31 35.04 19.37% <-IRR #YR-> 5 Stock Price 142.39% US$
Trailing P/E 25.14 17.32 -7.83 17.95 15.80 13.97 15.16 49.26 30.09 35.76 19.38 125.05 53.96 40.44 19.93 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 24.74 35.76 P/E:  31.10 39.31 38.36 P/E Ratio Historical High US$
-$24.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $127.35
$1,088 <-12 mths -1.98%
Free Cash Flow $197.35 $246.25 $262.81 $274.19 $303.80 $338.17 $450.59 $707.97 $865.09 $874.46 $744 $954 $1,110 $1,224 $1,372 $1,533 322.36% <-Total Growth 10 Free Cash Flow US$
Change 33.24% 57.12% 22.19% 1.08% -14.92% 28.23% 16.35% 10.27% 7.19% 7.19% 9.41% <-IRR #YR-> 5 Free Cash Flow MS 56.79% US$
FCF/CF from Op Ratio 0.67 0.62 0.78 0.61 0.67 0.81 0.57 0.60 0.61 0.57 0.53 0.56 0.55 0.57 0.74 0.74 15.50% <-IRR #YR-> 10 Free Cash Flow MS 322.36% US$
Dividends paid $19.55 $20.22 $20.71 $19.76 $18.92 $56.00 $93.00 $131.98 $152.55 $175.07 $199.88 $199.88 $199.88 $262.29 $239.40 $239.40 865.30% <-Total Growth 10 Dividends paid US$
Percentage paid 16.56% 20.64% 18.64% 17.63% 20.02% 26.87% 20.95% 18.01% 21.43% 18.89% 18.89% $0.19 <-Median-> 8 Percentage paid US$
5 Year Covrage 18.81% 20.66% 20.73% 20.39% 21.14% 20.98% 20.98% 5 Year Coverage US$
Dividend Coverage Ratio 6.04 4.85 5.36 5.67 5.00 3.72 4.77 5.55 4.67 5.29 5.29 5.18 <-Median-> 8 Dividend Coverage Ratio US$
5 Year of Coverage 5.32 4.84 4.82 4.90 4.73 4.77 4.77 5 Year of Coverage US$
Market Cap US$ $1,967 $1,542 $1,656 $1,895 $2,248 $2,562 $13,769 $18,692 $19,538 $23,934 $26,958 $35,459 $34,087 $34,928 $34,928 $34,928 1958.52% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $1,958 $1,568 $1,647 $2,011 $2,611 $3,547 $18,456 $23,493 $26,664 $31,094 $34,304 $44,861 $46,153 $46,590 $46,590 $46,590 2702.70% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 77.63 87.17 84.35 83.18 82.93 79.80 231.08 264.30 264.40 264.53 263.69 261.73 258.04 259.56 205.93% <-Total Growth 10 Diluted
Change 26.42% 12.29% -3.23% -1.38% -0.30% -3.78% 189.59% 14.38% 0.04% 0.05% -0.32% -0.74% -1.41% 0.59% -0.31% <-Median-> 10 Change
Difference Diluted/Basic -10.3% 0.0% 0.0% 0.0% 0.0% 0.0% -0.3% -0.2% -0.3% -0.3% -0.2% -0.2% -0.3% -0.2%
Basic # of Shares in Millions 69.66 87.17 84.35 83.18 82.93 79.80 230.33 263.68 263.65 263.79 263.19 261.17 257.38 258.95 205.15% <-Total Growth 10 Basic
Change 30.53% 25.12% -3.23% -1.38% -0.30% -3.78% 188.64% 14.48% -0.01% 0.05% -0.23% -0.77% -1.45% 0.61% -0.27% <-Median-> 10 Change
Difference Basic/Outstanding -16.1% -34.8% -34.4% -33.5% -34.9% -1.5% 14.1% -0.1% -0.2% -0.1% -0.1% -0.4% -0.1% -0.7% -0.17% <-Median-> 10 Difference
$2,023.95 <-12 mths 0.07%
# of Shares in Millions 58.47 56.84 55.37 55.30 53.98 78.59 262.80 263.49 263.14 263.62 262.825 260.212 257.146 257.146 257.146 257.146 16.60% <-IRR #YR-> 10 Shares 364.41%
Change 47.48% -2.79% -2.58% -0.12% -2.39% 45.58% 234.41% 0.26% -0.13% 0.18% -0.30% -0.99% -1.18% 0.00% 0.00% 0.00% -0.49% <-IRR #YR-> 5 Shares -2.41%
CF fr Op $M US$ $293.9 $395.7 $336.8 $450.7 $450.7 $415.0 $795.3 $1,187.3 $1,411.2 $1,540.5 $1,408.5 $1,698.2 $2,022.5 $2,149.7 $2,327.2 $2,486.6 500.57% <-Total Growth 10 Cash Flow US$
Increase 14.67% 34.66% -14.90% 33.84% 0.00% -7.92% 91.63% 49.28% 18.86% 9.16% -8.57% 20.57% 19.09% 6.29% 8.25% 6.85% SO Buy Backs S Iss.
5 year Running Average $223.5 $270.7 $294.1 $346.7 $385.6 $409.8 $489.7 $659.8 $851.9 $1,069.9 $1,268.6 $1,449.2 $1,616.2 $1,763.9 $1,921.2 $2,136.8 449.60% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $5.03 $6.96 $6.08 $8.15 $8.35 $5.28 $3.03 $4.51 $5.36 $5.84 $5.36 $6.53 $7.87 $8.36 $9.05 $9.67 29.32% <-Total Growth 10 Cash Flow per Share US$
Increase -22.25% 38.52% -12.64% 34.01% 2.45% -36.75% -42.69% 48.89% 19.02% 8.97% -8.29% 21.78% 20.51% 6.29% 8.25% 6.85% 19.63% <-IRR #YR-> 10 Cash Flow 500.57% US$
5 year Running Average $6.48 $6.63 $6.26 $6.54 $6.91 $6.97 $6.18 $5.86 $5.31 $4.80 $4.82 $5.52 $6.19 $6.79 $7.43 $8.29 11.24% <-IRR #YR-> 5 Cash Flow 70.35% US$
P/CFPS on Median 5.53 4.40 4.61 4.00 4.42 6.79 14.06 13.84 13.63 14.46 13.63 18.07 17.34 16.52 15.26 14.28 2.60% <-IRR #YR-> 10 Cash Flow per Share 29.32% US$
P/CFPS on Close 6.69 3.90 4.92 4.20 4.99 6.17 17.31 15.74 13.84 15.54 19.14 20.88 16.85 16.25 15.01 14.05 11.79% <-IRR #YR-> 5 Cash Flow per Share 74.56% US$
18.27% Diff M/C -0.11% <-IRR #YR-> 10 CFPS 5 yr Running -1.12% US$
$1,982 <-12 mths 1.69%
Excl.Working Capital CF $20.36 $33.01 $75.39 -$7.25 $25.37 -$15.69 $35.22 $71.00 -$32.00 -$27.00 $24.00 -$19.00 -$73.00 $0.00 $0.00 $0.00 1.10% <-IRR #YR-> 5 CFPS 5 yr Running 5.61% US$
CF fr Op $M WC $314.2 $428.7 $412.2 $443.5 $476.1 $399.3 $830.5 $1,258.3 $1,379.2 $1,513.5 $1,432.5 $1,679.2 $1,949.5 $2,149.7 $2,327.2 $2,486.6 373.00% <-Total Growth 10 Cash Flow less WC US$
Increase 33.08% 36.44% -3.86% 7.60% 7.36% -16.13% 107.98% 51.50% 9.61% 9.74% -5.35% 17.22% 16.09% 10.27% 8.25% 6.85% 16.81% <-IRR #YR-> 10 Cash Flow less WC 373.00% US$
5 year Running Average $229 $280 $319 $367 $415 $432 $512 $682 $869 $1,076 $1,283 $1,453 $1,591 $1,745 $1,908 $2,118 9.15% <-IRR #YR-> 5 Cash Flow less WC 54.94% US$
CFPS Excl. WC $5.37 $7.54 $7.44 $8.02 $8.82 $5.08 $3.16 $4.78 $5.24 $5.74 $5.45 $6.45 $7.58 $8.36 $9.05 $9.67 17.44% <-IRR #YR-> 10 CF less WC 5 Yr Run 399.04% US$
Increase -9.76% 40.35% -1.32% 7.73% 9.99% -42.39% -37.81% 51.10% 9.76% 9.54% -5.07% 18.40% 17.48% 10.27% 8.25% 6.85% 18.47% <-IRR #YR-> 5 CF less WC 5 Yr Run 133.41% US$
5 year Running Average $6.65 $6.81 $6.73 $6.87 $7.44 $7.38 $6.50 $5.97 $5.42 $4.80 $4.87 $5.53 $6.09 $6.72 $7.38 $8.22 0.18% <-IRR #YR-> 10 CFPS - Less WC 1.85% US$
P/CFPS on Median 5.17 4.06 3.77 4.07 4.18 7.06 13.46 13.06 13.94 14.71 13.41 18.27 17.99 16.52 15.26 14.28 9.69% <-IRR #YR-> 5 CFPS - Less WC 58.76% US$
P/CFPS on Close 6.26 3.60 4.02 4.27 4.72 6.42 16.58 14.86 14.17 15.81 18.82 21.12 17.49 16.25 15.01 14.05 -0.98% <-IRR #YR-> 5 CFPS 5 yr Running -9.40% US$
CF/-WC P/CF Med 10 yr 13.74 5 yr  14.46 P/CF Med 10 yr 13.43 5 yr  14.71 20.95% Diff M/C 0.41% <-IRR #YR-> 5 CFPS 5 yr Running 2.05% US$
$2,700.16 <-12 mths 2.26%
CF fr Op $M CDN$ $293.0 $404.1 $336.2 $479.4 $522.9 $574.7 $1,067.9 $1,489.4 $1,925.2 $2,000.9 $1,793.3 $2,153.0 $2,739.3 $2,868.0 $3,104.7 $3,317.4 714.79% <-Total Growth 10 Cash Flow CDN$
Increase 8.87% 37.94% -16.81% 42.60% 9.07% 9.90% 85.82% 39.48% 29.26% 3.93% -10.37% 20.06% 27.23% 4.70% 8.25% 6.85% SO Buy Backs S Iss.
5 year Running Average $239 $283 $306 $356 $407 $463 $596 $827 $1,116 $1,412 $1,655 $1,872 $2,122 $2,311 $2,532 $2,836 592.51% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $5.01 $7.11 $6.07 $8.67 $9.69 $7.31 $4.06 $5.65 $7.32 $7.59 $6.82 $8.27 $10.65 $11.15 $12.07 $12.90 75.45% <-Total Growth 10 Cash Flow per Share CDN$
Increase -26.18% 41.90% -14.61% 42.77% 11.74% -24.51% -44.43% 39.11% 29.43% 3.74% -10.10% 21.26% 28.75% 4.70% 8.25% 6.85% 23.34% <-IRR #YR-> 10 Cash Flow 714.79% CDN$
5 year Running Average $7.03 $7.01 $6.66 $6.73 $7.31 $7.77 $7.16 $7.08 $6.81 $6.39 $6.29 $7.13 $8.13 $8.90 $9.80 $11.01 12.96% <-IRR #YR-> 5 Cash Flow 83.92% CDN$
P/CFPS on Median 5.82 4.30 4.69 3.91 4.32 6.38 14.54 14.30 12.93 14.98 17.63 18.03 16.17 16.47 0.00 0.00 5.78% <-IRR #YR-> 10 Cash Flow per Share 75.45% CDN$
P/CFPS on Close 6.68 3.88 4.90 4.20 4.99 6.17 17.28 15.77 13.85 15.54 19.13 20.84 16.85 16.24 15.01 14.04 13.51% <-IRR #YR-> 5 Cash Flow per Share 88.46% CDN$
12.66% Diff M/C 2.02% <-IRR #YR-> 10 CFPS 5 yr Running 22.18% CDN$
$2,645 <-12 mths 0.16%
Excl.Working Capital CF $20.30 $33.71 $75.27 -$7.72 $29.44 -$21.73 $47.29 $89.07 -$43.65 -$35.07 $30.56 -$24.09 -$98.87 $0.00 $0.00 $0.00 2.82% <-IRR #YR-> 5 CFPS 5 yr Running 14.90% CDN$
CF fr Op $M WC $313.3 $437.9 $411.5 $471.7 $552.3 $553.0 $1,115.2 $1,578.5 $1,881.6 $1,965.8 $1,823.9 $2,128.9 $2,640.4 $2,868.0 $3,104.7 $3,317.4 541.72% <-Total Growth 10 Cash Flow less WC CDN$
Increase 26.35% 39.77% -6.03% 14.64% 17.10% 0.11% 101.67% 41.55% 19.20% 4.48% -7.22% 16.72% 24.02% 8.62% 8.25% 6.85% 20.43% <-IRR #YR-> 10 Cash Flow less WC 541.72% CDN$
5 year Running Average $245 $293 $332 $376 $437 $485 $621 $854 $1,136 $1,419 $1,673 $1,876 $2,088 $2,285 $2,513 $2,812 10.84% <-IRR #YR-> 5 Cash Flow less WC 67.27% CDN$
CFPS Excl. WC $5.36 $7.70 $7.43 $8.53 $10.23 $7.04 $4.24 $5.99 $7.15 $7.46 $6.94 $8.18 $10.27 $11.15 $12.07 $12.90 20.20% <-IRR #YR-> 10 CF less WC 5 Yr Run 529.43% CDN$
Increase -14.33% 43.78% -3.54% 14.78% 19.97% -31.23% -39.69% 41.18% 19.36% 4.29% -6.94% 17.90% 25.50% 8.62% 8.25% 6.85% 19.58% <-IRR #YR-> 5 CF less WC 5 Yr Run 144.47% CDN$
5 year Running Average $7.24 $7.21 $7.14 $7.06 $7.85 $8.19 $7.49 $7.21 $6.93 $6.38 $6.36 $7.14 $8.00 $8.80 $9.72 $10.92 3.29% <-IRR #YR-> 10 CFPS - Less WC 38.18% CDN$
P/CFPS on Median 5.44 3.97 3.83 3.98 4.09 6.63 13.92 13.50 13.23 15.25 17.33 18.24 16.78 16.47 0.00 0.00 11.38% <-IRR #YR-> 5 CFPS - Less WC 71.40% CDN$
P/CFPS on Close 6.25 3.58 4.00 4.26 4.73 6.41 16.55 14.88 14.17 15.82 18.81 21.07 17.48 16.24 15.01 14.04 1.14% <-IRR #YR-> 10 CFPS 5 yr Running 12.03% CDN$
*Operational cash flow Per Share (OPS) CF/-WC P/CF Med 10 yr 14.42 5 yr  16.17 P/CF Med 10 yr 13.71 5 yr  16.78 18.51% Diff M/C 2.11% <-IRR #YR-> 5 CFPS 5 yr Running 11.00% CDN$
-$6.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.65 Cash Flow per Share CDN$
-$5.65 $0.00 $0.00 $0.00 $0.00 $10.65 Cash Flow per Share CDN$
-$6.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.13 CFPS 5 yr Running CDN$
-$7.08 $0.00 $0.00 $0.00 $0.00 $8.13 CFPS 5 yr Running CDN$
-$411 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,640 Cash Flow less WC CDN$
-$1,578 $0 $0 $0 $0 $2,640 Cash Flow less WC CDN$
-$332 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,088 CF less WC 5 Yr Run CDN$
-$854 $0 $0 $0 $0 $2,088 CF less WC 5 Yr Run CDN$
-$7.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.27 CFPS - Less WC CDN$
-$5.99 $0.00 $0.00 $0.00 $0.00 $10.27 CFPS - Less WC CDN$
OPM 20.55% 21.50% 17.75% 22.25% 22.44% 21.55% 23.56% 25.64% 28.67% 28.59% 25.86% 27.61% 28.04% 26.61% 57.95% <-Total Growth 10 OPM CDN$
Increase -19.12% 4.63% -17.44% 25.30% 0.85% -3.94% 9.31% 8.83% 11.80% -0.27% -9.53% 6.74% 1.58% -5.12% Should increase  or be stable. CDN$
Diff from Median -16.4% -12.6% -27.8% -9.6% -8.8% -12.4% -4.2% 4.2% 16.5% 16.2% 5.1% 12.2% 14.0% 8.2% 0.05 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 24.60% 5 Yrs 27.61% should be zero,  it is a check  on calculations CDN$
Long Term Debt US$ $2,149 $3,618 $3,931 $4,196 $4,397 $4,737 $5,041 $6,890 $6,922 Debt US$
Change 68.36% 8.64% 6.75% 4.77% 7.74% 6.40% 36.70% 0.46% 7.74% <-Median-> 7 Change US$
Ratio to Market Cap 0.84 0.26 0.21 0.21 0.18 0.18 0.14 0.20 0.20 0.21 <-Median-> 7 Ratio to Market Cap US$
Assets/Current Liabilities Ratio 10.81 16.17 14.97 14.67 13.64 13.60 11.92 11.33 12.45 13.62 <-Median-> 7 Assets/Current Liabilities Ratio US$
Debt to Cash Flow (Years) 5.18 4.55 3.31 2.97 2.85 3.36 2.97 3.41 3.22 3.34 <-Median-> 7 Debt to Cash Flow (Years) US$
Long Term Debt CDN$ $2,976 $4,858 $4,932 $5,725 $5,710 $6,031 $6,390 $9,332 $9,234 Debt CDN$
Change 63.24% 1.50% 16.09% -0.25% 5.62% 5.95% 46.03% -1.05% 5.95% <-Median-> 7 Change CDN$
Ratio to Market Cap 0.84 0.26 0.21 0.21 0.18 0.18 0.14 0.20 0.20 0.21 <-Median-> 7 Ratio to Market Cap CDN$
Assets/Current Liabilities Ratio 10.81 16.17 14.97 14.67 13.64 13.60 11.92 11.33 12.45 13.62 <-Median-> 7 Assets/Current Liabilities Ratio CDN$
Debt to Cash Flow (Years) 5.18 4.55 3.31 2.97 2.85 3.36 2.97 3.41 3.22 3.34 <-Median-> 7 Debt to Cash Flow (Years) CDN$
Intangibles US$ $1,082 $774 $929 $905 $937 $887 $1,067 $1,087 $1,129 $1,163 $1,155 $1,351 $1,674 $1,697 80.16% <-Total Growth 10 Intangibles US$
Goodwill $272 $258 $288 $220 $166 $177 $4,390 $4,682 $5,032 $5,516 $5,727 $6,188 $6,902 $6,941 2297.90% <-Total Growth 10 Goodwill US$
Goodwill and Intangibles US$ $1,354 $1,032 $1,217 $1,125 $1,103 $1,064 $5,457 $5,769 $6,160 $6,679 $6,882 $7,538 $8,576 $8,638 604.72% <-Total Growth 10 Total US$
Change -23.77% 17.91% -7.52% -1.97% -3.57% 412.97% 5.71% 6.78% 8.43% 3.03% 9.54% 13.77% 0.72% 6.25% <-Median-> 10 Change US$
Intangible/Market Cap Ratio 0.69 0.67 0.73 0.59 0.49 0.42 0.40 0.31 0.32 0.28 0.26 0.21 0.25 0.25 Intangible/Market Cap Ratio US$
Intangibles CDN$ $1,079 $791 $928 $963 $1,087 $1,228 $1,433 $1,364 $1,540 $1,511 $1,471 $1,712 $2,267 $2,264 144.43% <-Total Growth 10 Intangibles CDN$
Goodwill $271 $263 $287 $234 $192 $245 $5,895 $5,873 $6,864 $7,165 $7,291 $7,845 $9,348 $9,259 3153.22% <-Total Growth 10 Goodwill CDN$
Goodwill and Intangibles CDN$ $1,350 $1,054 $1,215 $1,197 $1,280 $1,473 $7,328 $7,237 $8,404 $8,675 $8,762 $9,557 $11,616 $11,524 856.09% <-Total Growth 10 Total CDN$
Change -21.91% 15.25% -1.47% 6.92% 15.11% 397.40% -1.23% 16.12% 3.23% 1.00% 9.08% 21.54% -0.79% 8.00% <-Median-> 10 Change CDN$
Intangible/Market Cap Ratio 0.69 0.67 0.74 0.60 0.49 0.42 0.40 0.31 0.32 0.28 0.26 0.21 0.25 0.25 0.31 <-Median-> 10 Intangible/Market Cap Ratio CDN$
Current Assets US$ $250.59 $260.56 $313.08 $301.66 $295.64 $275.24 $832.57 $1,176.87 $1,092.90 $1,130.60 $1,408.27 $1,032.78 $1,117.65 $1,134.26 256.99% <-Total Growth 10 Current Assets US$
Current Liabilities $302.73 $297.12 $307.37 $301.96 $330.43 $300.15 $692.18 $802.60 $860.71 $1,007.23 $1,028.65 $1,232.75 $1,512.64 $1,383.18 392.13% <-Total Growth 10 Current Liabilities US$
Liquidity 0.83 0.88 1.02 1.00 0.89 0.92 1.20 1.47 1.27 1.12 1.37 0.84 0.74 0.82 1.06 <-Median-> 10 Ratio US$
Curr Long Term Debt $6.907 $5.969 $5.428 $0.494 $1.650 $11.659 $1.786 $0.465 $8.268 $6.020 $6.759 $10.513
Liquidity Less CLTD 1.04 1.02 0.91 0.92 1.21 1.49 1.27 1.12 1.38 0.84 0.74 0.83 1.12 <-Median-> 5 Liquidity Less CLTD
Assets US$ $3,390 $3,078 $3,476 $3,393 $3,376 $3,245 $11,193 $12,015 $12,627 $13,738 $13,992 $14,700 $17,135 $17,227 393.00% <-Total Growth 10 Assets US$
Liabilities $1,744 $1,784 $2,203 $2,103 $2,148 $2,116 $5,538 $5,741 $6,167 $6,799 $7,129 $7,706 $10,021 $9,988 354.88% <-Total Growth 10 Liabilities US$
Debt Ratio 1.94 1.72 1.58 1.61 1.57 1.53 2.02 2.09 2.05 2.02 1.96 1.91 1.71 1.72 1.94 <-Median-> 10 Ratio US$
Estimates BVPS $29.70 $31.30 $32.40 Estimates Estimates BVPS
Estimate Book Value $7,637.2 $8,048.7 $8,331.5 Estimates Estimate Book Value
P/B Ratio (Close) 4.57 4.34 4.19 Estimates P/B Ratio (Close)
Difference from 10 year median 68.73% Diff M/C Estimates Difference from 10 yr med.
Total Book Value $1,646.6 $1,293.1 $1,272.6 $1,289.6 $1,228.8 $1,128.9 $5,654.9 $6,274.1 $6,460.2 $6,938.4 $6,863.4 $6,993.5 $7,113.6 $7,239.0 458.99% <-Total Growth 10 Book Value US$
Non-Con Int US$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.36 $5.40 $5.58 $4.85 $4.17 $4.61 $4.95 $4.97 Non-Con Int US$ US$
Book Value US$ $1,646.6 $1,293.1 $1,272.6 $1,289.6 $1,228.8 $1,128.9 $5,647.5 $6,268.7 $6,454.6 $6,933.5 $6,859.3 $6,988.9 $7,108.7 $7,234.0 $7,234.0 $7,234.0 458.60% <-Total Growth 10 Book Value US$
Book Value per Share $28.16 $22.75 $22.98 $23.32 $22.76 $14.36 $21.49 $23.79 $24.53 $26.30 $26.10 $26.86 $27.64 $28.13 $28.13 $28.13 20.28% <-Total Growth 10 Book Value per Share US$
Increase 42.13% -19.21% 1.02% 1.46% -2.38% -36.90% 49.60% 10.71% 3.10% 7.23% -0.77% 2.91% 2.93% 1.76% 0.00% 0.00% 78.13% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 0.99 1.35 1.22 1.40 1.62 2.50 1.98 2.62 2.98 3.21 2.80 4.39 4.93 4.91 4.91 4.91 1.58 P/B Ratio Historical Median US$
P/B Ratio (Close) 1.19 1.19 1.30 1.47 1.83 2.27 2.44 2.98 3.03 3.45 3.93 5.07 4.80 4.83 4.83 4.83 1.79% <-IRR #YR-> 10 Book Value per Share US$
Change 6.72% -0.21% 9.15% 12.94% 24.50% 24.07% 7.41% 22.30% 1.51% 14.04% 13.85% 29.09% -5.49% 0.69% 0.00% 0.00% 3.05% <-IRR #YR-> 5 Book Value per Share US$
Leverage (A/BK) 2.06 2.38 2.73 2.63 2.75 2.87 1.98 1.91 1.95 1.98 2.04 2.10 2.41 2.38 2.07 <-Median-> 10 A/BV US$
Debt/Equity Ratio 1.06 1.38 1.73 1.63 1.75 1.87 0.98 0.91 0.95 0.98 1.04 1.10 1.41 1.38 1.07 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.71 5 yr Med 3.21 78.13% Diff M/C
-$22.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $27.64
-$23.79 $0.00 $0.00 $0.00 $0.00 $27.64
Current Assets CDN$ $249.84 $266.12 $312.55 $320.85 $342.97 $381.14 $1,117.89 $1,476.38 $1,490.94 $1,468.42 $1,793.01 $1,309.35 $1,513.74 $1,513.21 384.32% <-Total Growth 10 Current Assets CDN$
Current Liabilities $301.82 $303.46 $306.85 $321.16 $383.34 $415.63 $929.39 $1,006.86 $1,174.18 $1,308.19 $1,309.68 $1,562.88 $2,048.72 $1,845.31 567.67% <-Total Growth 10 Current Liabilities CDN$
Liquidity 0.83 0.88 1.02 1.00 0.89 0.92 1.20 1.47 1.27 1.12 1.37 0.84 0.74 0.82 1.06 <-Median-> 10 Ratio CDN$
Liq. with CF aft div 1.73 2.14 2.05 2.43 2.20 2.22 2.16 2.78 2.73 2.48 2.54 2.04 1.92 2.18 2.48 <-Median-> 5 Ratio CDN$
Liq. CF re  Inv+Div  0.73 1.05 0.75 1.30 1.17 1.09 1.51 1.26 1.05 1.03 1.26 0.86 0.63 2.18 1.03 <-Median-> 5 Ratio CDN$
Curr Long Term Debt $6.90 $6.35 $6.30 $0.68 $2.22 $14.63 $2.44 $0.60 $10.53 $7.63 $9.15 $14.03
Liquidity Less CLTD 1.04 1.02 0.91 0.92 1.21 1.49 1.27 1.12 1.38 0.84 0.74 0.83 1.12 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.09 2.48 2.24 2.22 2.17 2.82 2.74 2.48 2.56 2.05 1.92 2.20 2.48 <-Median-> 5 Ratio CDN$
Assets CDN$ $3,380 $3,143 $3,470 $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 $22,983 568.85% <-Total Growth 10 Assets CDN$
Liabilities $1,739 $1,823 $2,199 $2,237 $2,491 $2,930 $7,436 $7,202 $8,413 $8,831 $9,077 $9,770 $13,572 $13,325 517.14% <-Total Growth 10 Liabilities CDN$
Debt Ratio 1.94 1.72 1.58 1.61 1.57 1.53 2.02 2.09 2.05 2.02 1.96 1.91 1.71 1.72 1.94 <-Median-> 10 Ratio CDN$
Estimates BVPS $39.62 $41.76 $43.22 Estimates Estimates BVPS
Estimate Book Value $10,188.8 $10,737.7 $11,115.1 Estimates Estimate Book Value
P/B Ratio (Close) 4.57 4.34 4.19 Estimates P/B Ratio (Close)
Difference from 10 year median 65.20% Diff M/C Estimates Difference from 10 yr med.
Check $1,371.6 $1,425.5 $1,563.2 $7,592.8 $7,870.8 $8,813.0 $9,011.5 $8,738.5 $8,866.4 $9,634.7 $9,657.5
Total Book Value $1,641.7 $1,320.7 $1,270.4 $1,371.6 $1,425.5 $1,563.2 $7,592.8 $7,870.8 $8,813.0 $9,011.5 $8,738.5 $8,866.4 $9,634.7 $9,657.5 658.38% <-Total Growth 10 Book Value CDN$
Non-Con Int CDN$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.88 $6.77 $7.61 $6.30 $5.30 $5.84 $6.70 $6.63 CDN$
Book Value CDN$ $1,641.7 $1,320.7 $1,270.4 $1,371.6 $1,425.5 $1,563.2 $7,582.9 $7,864.0 $8,805.4 $9,005.2 $8,733.2 $8,860.6 $9,628.0 $9,650.9 $9,650.9 $9,650.9 657.86% <-Total Growth 10 Book Value CDN$
Book Value per Share $28.08 $23.24 $22.94 $24.80 $26.41 $19.89 $28.85 $29.85 $33.46 $34.16 $33.23 $34.05 $37.44 $37.53 $37.53 $37.53 63.19% <-Total Growth 10 Book Value per Share CDN$
Increase 34.94% -17.24% -1.26% 8.09% 6.48% -24.68% 45.06% 3.44% 12.12% 2.08% -2.73% 2.48% 9.96% 0.24% 0.00% 0.00% 74.41% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 1.04 1.32 1.24 1.37 1.58 2.35 2.05 2.71 2.83 3.33 3.62 4.38 4.60 4.89 0.00 0.00 1.58 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 1.19 1.19 1.30 1.47 1.83 2.27 2.43 2.99 3.03 3.45 3.93 5.06 4.79 4.83 4.83 4.83 4.43% <-IRR #YR-> 10 Book Value per Share 63.19% CDN$
Change 6.20% -0.45% 9.15% 13.14% 24.88% 23.90% 7.26% 22.74% 1.36% 14.02% 13.76% 28.89% -5.32% 0.71% 0.00% 0.00% 4.64% <-IRR #YR-> 5 Book Value per Share 25.45% CDN$
Leverage (A/BK) 2.06 2.38 2.73 2.63 2.75 2.87 1.98 1.91 1.95 1.98 2.04 2.10 2.41 2.38 2.07 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.06 1.38 1.73 1.63 1.75 1.87 0.98 0.91 0.95 0.98 1.04 1.10 1.41 1.38 1.07 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.77 5 yr Med 3.62 74.41% Diff M/C
-$23.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $37.44
-$29.85 $0.00 $0.00 $0.00 $0.00 $37.44
$682.22 <-12 mths -7.71%
Comprehensive Income US$ $121.31 -$213.25 $107.99 $84.20 $85.16 $50.45 $216.49 $728.83 $363.96 $630.50 $214.30 $658.72 $739.59 584.85% <-Total Growth 10 Comprehensive Income US$
NCI 11.133 $0.00 $0.00 $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 #DIV/0! <-Total Growth 10 Comprehensive Income US$
Shareholders $110.17 -$213.25 $107.99 $84.20 $85.16 $50.45 $215.71 $728.23 $363.67 $630.66 $214.99 $658.28 $739.25 584.54% <-Total Growth 10 Comprehensive Income US$
Increase 54.97% -293.55% 150.64% -22.04% 1.15% -40.76% 327.57% 237.60% -50.06% 73.42% -65.91% 206.19% 12.30% 12.3% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $60.10 $11.90 $46.49 $32.04 $34.86 $22.91 $108.70 $232.75 $288.64 $397.75 $430.65 $519.17 $521.37 21.21% <-IRR #YR-> 10 Comprehensive Income 584.54% US$
ROE US$ 6.7% -16.5% 8.5% 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 0.30% <-IRR #YR-> 5 Comprehensive Income 1.51% US$
5Yr Median 6.7% 6.7% 7.0% 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 27.34% <-IRR #YR-> 10 5 Yr Running Average 1021.54% US$
% Difference from NI 48.67% -8.72% 14.45% -28.63% -32.69% -59.27% -12.34% 26.14% -33.56% 11.18% 4.97% 6.44% -11.60% 17.50% <-IRR #YR-> 5 5 Yr Running Average 124.01% US$
Median Values Diff 5, 10 yr -12.0% 5.0% 9.1% <-Median-> 5 Return on Equity US$
-$108.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $739.2
-$728.2 $0.0 $0.0 $0.0 $0.0 $739.2
-$46.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $521.4
-$232.7 $0.0 $0.0 $0.0 $0.0 $521.4
Current Liability Coverage Ratio US$ 1.04 1.44 1.34 1.47 1.44 1.33 1.20 1.57 1.60 1.50 1.39 1.36 1.29 1.55   CFO / Current Liabilities US$
5 year Median 1.34 1.44 1.44 1.34 1.44 1.44 1.50 1.50 1.50 1.39 1.39 1.39 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 9.27% 13.93% 11.86% 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 12.48% CFO / Total Assets US$
5 year Median 10.95% 10.95% 11.82% 11.86% 13.07% 13.07% 12.31% 12.31% 10.92% 10.92% 10.47% 10.92% 11.02% 11.38% 11.0% <-Median-> 5 Return on Assets  US$
Return on Assets ROA US$ 2.2% -6.4% 2.7% 3.5% 3.7% 3.8% 2.2% 4.8% 4.3% 4.1% 1.5% 4.2% 4.9% 5.5% Net  Income/Assets Return on Assets US$
5Yr Median 2.0% 2.0% 2.2% 2.4% 2.7% 3.5% 3.5% 3.7% 3.8% 4.1% 4.1% 4.2% 4.2% 4.2% 4.2% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ 4.5% -15.2% 7.4% 9.1% 10.3% 11.0% 4.4% 9.2% 8.5% 8.2% 3.0% 8.8% 11.8% 13.2% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 5.0% 5.0% 6.0% 6.0% 7.4% 9.1% 9.1% 9.2% 9.2% 8.5% 8.2% 8.5% 8.5% 8.8% 8.5% <-Median-> 5 Return on Equity US$
Adjusted Net Income $102.44 $135.00 $113.19 $127.15 $153.08 -$6.89 $395.20 $570.67 $667.3 $719.56 $695.79 $846.60 $985.27 72.65% <-Total Growth 7 Net Income US$
$853.15 <-12 mths 2.09%
Net Income US$ $82.17 -$196.14 $94.36 $117.97 $126.52 $123.88 $246.54 $577.42 $547.15 $566.68 $203.99 $618.49 $836.00 786.00% <-Total Growth 10 Net Income US$ US$
NCI $8.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 #DIV/0! <-Total Growth 10 NCI US$
Shareholders $74.11 -$196.14 $94.36 $117.97 $126.52 $123.88 $245.76 $576.82 $546.87 $566.84 $204.68 $618.05 $835.66 $956 $1,088 $1,160 785.64% <-Total Growth 10 Net Income US$
Increase 57.46% -364.67% -148.11% 25.03% 7.24% -2.09% 98.39% 134.71% -5.19% 3.65% -63.89% 201.96% 35.21% 14.40% 13.81% 6.62% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $43.9 -$1.0 $11.5 $27.5 $43.4 $53.3 $141.7 $238.2 $324.0 $412.0 $428.2 $502.7 $554.4 $636.2 $740.5 $931.5 24.37% <-IRR #YR-> 10 Net Income 785.64% US$
Operating Cash Flow $293.86 $395.71 $336.76 $450.74 $450.74 $415.02 $795.31 $1,187.26 $1,411.24 $1,540.55 $1,408.52 $1,698.23 $2,022.49 7.70% <-IRR #YR-> 5 Net Income 44.87% US$
Investment Cash Flow -$419.68 -$311.30 -$530.53 -$261.77 -$289.46 -$311.13 -$296.40 -$966.23 -$1,371.82 -$1,426.01 -$1,046.04 -$1,693.48 -$3,087.17 47.35% <-IRR #YR-> 10 5 Yr Running Average 4724.91% US$
Accruals   $199.93 -$280.54 $288.13 -$71.00 -$34.76 $19.99 -$253.16 $355.79 $507.46 $452.30 -$157.80 $613.30 $1,900.34 18.41% <-IRR #YR-> 5 5 Yr Running Average 132.77% US$
Total Assets $3,390 $3,078 $3,476 $3,393 $3,376 $3,245 $11,193 $12,015 $12,627 $13,738 $13,992 $14,700 $17,135 Balance Sheet Assets US$
Accruals Ratio 5.90% -9.12% 8.29% -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 4.02% <-Median-> 5 Ratio US$
-$94.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $835.7
-$576.8 $0.0 $0.0 $0.0 $0.0 $835.7
-$11.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $554.4
-$238.2 $0.0 $0.0 $0.0 $0.0 $554.4
Financial Cash Flow US$ $134.23 -$84.80 $209.59 -$183.51 -$94.75 -$98.75 -$354.87 $56.76 -$187.58 -$95.89 -$78.22 -$499.50 $1,028.46 C F Statement  Financial Cash Flow US$
Accruals   $65.70 -$195.75 $78.54 $112.51 $59.98 $118.74 $101.71 $299.03 $695.03 $548.19 -$79.58 $1,112.80 $871.88 Accruals US$
Accruals Ratio 1.94% -6.36% 2.26% 3.32% 1.78% 3.66% 0.91% 2.49% 5.50% 3.99% -0.57% 7.57% 5.09% 5.09% <-Median-> 5 Ratio US$
$910.15 <-12 mths -9.10%
Comprehensive Inc CDN$ $120.94 -$217.79 $107.81 $89.55 $98.80 $69.86 $290.68 $914.32 $496.51 $818.90 $272.85 $835.13 $1,001.70 829.14% <-Total Growth 10 Comprehensive Income CDN$
NCI $11.10 $0.00 $0.00 $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46 #DIV/0! <-Total Growth 10 NCI CDN$
Shareholders $109.84 -$217.79 $107.81 $89.55 $98.80 $69.86 $289.63 $913.57 $496.12 $819.11 $273.72 $834.57 $1,001.24 828.71% <-Total Growth 10 Comprehensive Income CDN$
Increase 47.13% -298.28% 149.50% -16.94% 10.32% -29.29% 314.59% 215.42% -45.69% 65.10% -66.58% 204.89% 19.97% 19.97% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $68.84 $18.82 $53.21 $32.81 $37.64 $29.64 $131.13 $292.28 $373.60 $517.66 $558.43 $667.42 $684.95 24.96% <-IRR #YR-> 10 Comprehensive Income 828.71% CDN$
ROE CDN$ 6.7% -16.5% 8.5% 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 1.85% <-IRR #YR-> 5 Comprehensive Income 9.60% CDN$
5Yr Median 6.7% 6.7% 7.0% 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 29.11% <-IRR #YR-> 10 5 Yr Running Average 1187.16% CDN$
% Difference from NI 48.7% 8.7% 14.5% -28.6% -32.7% -59.3% -12.3% 26.1% -33.6% 11.2% 5.0% 6.4% -11.6% 18.57% <-IRR #YR-> 5 5 Yr Running Average 134.35% CDN$
Median Values Diff 5, 10 yr -12.0% 5.0% 9.09% <-Median-> 5 Return on Equity CDN$
-$107.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,001.24
-$913.57 $0.00 $0.00 $0.00 $0.00 $1,001.24
-$53.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $684.95
-$292.28 $0.00 $0.00 $0.00 $0.00 $684.95
Current Liability Coverage Ratio CDN$ 1.04 1.44 1.34 1.47 1.44 1.33 1.20 1.57 1.60 1.50 1.39 1.36 1.29 1.55   CFO / Current Liabilities CDN$
5 year Median 1.27 1.27 1.32 1.34 1.44 1.44 1.34 1.44 1.44 1.50 1.50 1.50 1.39 1.39 1.39 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 9.27% 13.93% 11.86% 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 12.48% CFO / Total Assets CDN$
5 year Median 10.95% 10.95% 11.82% 11.86% 13.07% 13.07% 12.31% 12.31% 10.92% 10.92% 10.47% 10.92% 11.02% 11.38% 11.0% <-Median-> 5 Return on Assets  CDN$
Comments ROE -14.9%
Comments -196.136
Return on Assets ROA CDN$ 2.2% -6.4% 2.7% 3.5% 3.7% 3.8% 2.2% 4.8% 4.3% 4.1% 1.5% 4.2% 4.9% 5.5% Net  Income/Assets Return on Assets CDN$
5Yr Median 2.0% 2.0% 2.2% 2.4% 2.7% 3.5% 3.5% 3.7% 3.8% 4.1% 4.1% 4.2% 4.2% 4.2% 4.2% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 4.5% -15.2% 7.4% 9.1% 10.3% 11.0% 4.4% 9.2% 8.5% 8.2% 3.0% 8.8% 11.8% 13.2% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 5.0% 5.0% 6.0% 6.0% 7.4% 9.1% 9.1% 9.2% 9.2% 8.5% 8.2% 8.5% 8.5% 8.8% 8.5% <-Median-> 5 Return on Equity CDN$
$1,138.19 <-12 mths 0.56%
Net Income CDN$ $81.92 -$200.32 $94.20 $125.47 $146.77 $171.54 $331.03 $724.37 $746.43 $736.01 $259.72 $784.12 $1,132.28
NCI $8.04 $0.00 $0.00 $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46
Shareholders $73.88 -$200.32 $94.20 $125.47 $146.77 $171.54 $329.98 $723.62 $746.04 $736.21 $260.59 $783.56 $1,131.82 $1,275 $1,452 $1,548 1101.54% <-Total Growth 10 Net Income CDN$
Increase 49.49% -371.13% -147.02% 33.20% 16.97% 16.87% 92.37% 119.29% 3.10% -1.32% -64.60% 200.68% 44.45% 12.69% 13.81% 6.62% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $46.9 $0.3 $12.8 $28.5 $48.0 $67.5 $173.6 $299.5 $423.6 $541.5 $559.3 $650.0 $731.6 $837.5 $980.6 $1,238.0 28.23% <-IRR #YR-> 10 Net Income 1101.54% CDN$
Operating Cash Flow $292.98 $404.15 $336.19 $479.40 $522.90 $574.69 $1,067.87 $1,489.42 $1,925.21 $2,000.86 $1,793.33 $2,153.01 $2,739.26 9.36% <-IRR #YR-> 5 Net Income 56.41% CDN$
Investment Cash Flow -$418.43 -$317.94 -$529.64 -$278.41 -$335.80 -$430.83 -$397.97 -$1,212.14 -$1,871.44 -$1,852.10 -$1,331.82 -$2,147.00 -$4,181.26 49.92% <-IRR #YR-> 10 5 Yr Running Average 5634.18% CDN$
Accruals   $199.33 -$286.53 $287.64 -$75.51 -$40.33 $27.68 -$339.92 $446.34 $692.27 $587.45 -$200.91 $777.54 $2,573.82 19.56% <-IRR #YR-> 5 5 Yr Running Average 144.31% CDN$
Total Assets $3,380 $3,143 $3,470 $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 Balance Sheet Assets CDN$
Accruals Ratio 5.90% -9.12% 8.29% -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 4.02% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.27 -0.41 0.21 0.24 0.24 0.42 0.34 0.46 0.39 0.37 0.14 0.37 0.43 0.37 <-Median-> 10 EPS/CF Ratio CDN$
-$94.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,131.8
-$723.6 $0.0 $0.0 $0.0 $0.0 $1,131.8
-$12.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $731.6
-$299.5 $0.0 $0.0 $0.0 $0.0 $731.6
Change in Close 43.31% -17.61% 7.78% 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 0.95% 0.00% 0.00% Count 22 Years of data CDN$
up/down down down Up down Count 8 36.36% CDN$
Meet Prediction? % right Count 1 12.50% CDN$
Financial Cash Flow CDN$ $133.83 -$86.60 $209.24 -$195.18 -$109.92 -$136.74 -$476.48 $71.21 -$255.89 -$124.55 -$99.59 -$633.26 $1,392.95 C F Statement  Financial CF CDN$
Accruals   $65.50 -$199.92 $78.40 $119.67 $69.59 $164.42 $136.57 $375.13 $948.17 $711.99 -$101.32 $1,410.80 $1,180.87 Accruals CDN$
Accruals Ratio 1.94% -6.36% 2.26% 3.32% 1.78% 3.66% 0.91% 2.49% 5.50% 3.99% -0.57% 7.57% 5.09% 5.09% <-Median-> 5 Ratio CDN$
Cash US$ $13.41 $14.14 $29.94 $31.98 $41.64 $35.78 $154.38 $433.82 $403.97 $423.22 $423.22 $219.62 $181.36 $240.49 Cash US$
Cash CDN$ $13.37 $14.44 $29.89 $34.01 $48.30 $49.55 $207.29 $544.22 $551.09 $549.68 $538.84 $278.43 $245.64 $320.83 Cash CDN$
Cash per Share CDN$ $0.23 $0.25 $0.54 $0.62 $0.89 $0.63 $0.79 $2.07 $2.09 $2.09 $2.05 $1.07 $0.96 $1.25 $2.05 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 0.68% 0.92% 1.82% 1.69% 1.85% 1.40% 1.12% 2.32% 2.07% 1.77% 1.57% 0.62% 0.53% 0.69% 1.57% <-Median-> 5 % of Stock Price CDN$
Inf on Waste Connection before 2016.
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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends US$
Pre-split 2017 $0.08 $0.32 $0.37 -$0.19 $0.48 $0.18 $0.62
Split in June 2017 $0.12
Dividend US$ $0.05 $0.21 $0.25 -$0.12 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.02 $1.02 283.11% <-Total Growth 10 Dividends US$
Increase 320.00% 17.46% -150.00% -356.76% -61.26% 234.24% 21.95% 16.00% 14.66% 14.29% 11.18% 11.83% 7.94% 0.00% Count 13 Years of data US$
Dividends 5 Yr Running $0.14 $0.15 $0.19 $0.25 $0.39 $0.46 $0.58 $0.67 $0.76 $0.85 $0.92 442.14% <-Total Growth 8 Dividends 5 Yr Running US$
Yield H/L Price 0.18% 0.69% 0.88% -0.38% 0.86% 0.34% 0.96% 0.80% 0.79% 0.79% 1.04% 0.72% 0.69% 0.79% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 0.15% 0.59% 0.78% -0.33% 0.74% 0.29% 0.78% 0.69% 0.72% 0.70% 0.73% 0.61% 0.65% 0.70% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 0.23% 0.82% 1.01% -0.44% 1.02% 0.42% 1.26% 0.95% 0.88% 0.90% 1.83% 0.87% 0.74% 0.89% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 0.15% 0.77% 0.82% -0.36% 0.76% 0.38% 0.78% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.75% 0.75% 0.72% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 3.39% -6.72% 15.89% -6.31% 15.02% 5.71% 38.44% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 28.59% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 4.18% 59.18% 57.36% -22.57% 39.90% 13.22% 23.22% 26.43% 30.30% 34.62% 46.14% 44.33% 44.62% 32.46% <-Median-> 9 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 0.99% 3.02% 4.06% -1.51% 3.79% 2.32% 13.55% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 11.24% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 0.77% 3.17% 3.94% -1.89% 4.58% 1.76% 6.64% 8.53% 10.93% 13.84% 15.77% 15.31% 15.26% 9.73% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 0.93% 2.78% 3.31% -1.54% 3.59% 2.41% 12.97% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 11.32% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 0.75% 3.08% 3.67% -1.80% 4.26% 1.66% 6.30% 8.37% 10.71% 13.85% 15.59% 15.27% 15.51% 9.54% <-Median-> 9 DPR CF WC 5 Yr Running US$
Median values 10 Yr Med 10 Yr Cl 0.79% 0.72% 5 Yr Med 5 Yr Cl 0.79% 0.73% 5 Yr Med Payout 31.07% 12.02% 12.46% 13.58% <-IRR #YR-> 5 Dividends US$
* Dividends per share  10 Yr Med and Cur. -4.99% 3.91% 5 Yr Med and Cur. -4.61% 2.52% Last Div Inc ---> $0.185 $0.205 10.81% 14.38% <-IRR #YR-> 10 Dividends US$
Dividends Growth 15 15.16% <-IRR #YR-> 11 Dividends
Dividends Growth 5 -$0.50 $0.00 $0.00 $0.00 $0.00 $0.95
Dividends Growth 10 -$0.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.95
Dividends Growth 15 -$0.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.95
P/E 5.67% <-IRR #YR-> 10 Stock Price 488.46% US$
Trailing P/E 14.14% <-IRR #YR-> 5 Price & Dividend US$
Median 10, 5 Yrs D.  per yr 0.64% 0.82% % Tot Ret 10.19% 5.81% T P/E #NUM! P/E:  #NUM! #NUM! 6.31% <-IRR #YR-> 10 Price & Dividend US$
Price  15 13.21% <-IRR #YR-> 15 Stock Price
Price & Dividend 15 16.93% <-IRR #YR-> 15 Price & Dividend
Price 5 -$70.94 $0.00 $0.00 $0.00 $0.00 $132.56
Price 10 -$22.53 $0.00 $0.00 $0.00 $0.00 -$70.94 $0.00 $0.00 $0.00 $0.00 $132.56
Price & Dividend 5 -$70.94 $0.58 $0.67 $0.76 $0.85 $133.51
Price & Dividend 10 -$22.53 -$0.12 $0.32 $0.12 $0.41 -$70.94 $0.58 $0.67 $0.76 $0.85 $133.51
Price  15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $132.56
Price & Dividend 15 $0.05 $0.21 $0.25 -$0.12 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $133.51
Other Info
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
Prem/Disc
Notes:
June 11, 2023.  Last estimates were for 2022, 2023 and 2024 of 7056M, $7575M and $8090M US$ for Revenue, $3.76, $4.32 and $5.03 US$ for AEPS, $3.27, $3.86 and $4.32 USS$ for EPS, 
$0.96, $1.05 and $1.19 US$ for Dividends, 1.182M, $1267M and $1344M US$ for FCF, $7.81, $7.90 and $8.53 US$ for CFPS, $27.20, $28.30 and $28.50 US$ for BVPS, and $845M, $981M and $1057M US$ for Net Income.
June 12, 2022.  Last estimates were for $5966M, $6375M and $6799M US$ for Revenue, $2.71, $3.09 and $3.65 US$ for EPS, $0.87, $0.99 and $1.12 US$ for Dividend, 
$995M, $1085M and $1130M US$ for FCF, $5.76, $6.41 and $6.56 US$ for CFPS and $714M, $808M and $911M US$ for Net Income.
June 13, 2021. Last estimates were for 5312M, $5699M and $6108M IS$ for Revenue, $1.92, $2.43 and $2.75 US$ for EPS, $0.76, $0.85 and $1.01 US$ for Dividends, 
$831M, $980M and $1033M US$ for FCF, $5.29, $5.68 and $5.65 US$ for CFPS, and $503M, $638M and $678MUS$ for Net Income.
Jun 13, 2020.  Last estimates were for 2019, 2020 and 2021 of $5375M, $5724M and |$6252M US$ for Revenue, 
$2.35, $2.78 and $3.28 US$ for EPS, $4.17, $5.50 and $7.35 US$ for CFPS and $627M, $723M and $796M US$ for Net Income.
June 14, 2019.  Last estimates were for 4904M, $5206M and $5688M for Revenue US$, $2.21, $2.55 and $2.97 EPS US$, $5.17, $5.92 and $6.77 for CFPS US$, $583M, $666M and $737M for Net Income US$.
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. 
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 
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 2, 2011.  Company changes name from IESI-BFC to Progressive Waste Solutions Ltd.  
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.
Aug 18, 2008.  Company annouced change from an Income Fund BFI 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.
Why I bought this stock
I do not own this stock of Waste Connections Inc. (TSX-WCN, NYSE-WCN), but I used to.  I first bought this stock in 2007 because TD Securities had a very favorable report on this stock and 
had it on their action buy list.  I had money because I had recently sold RIM.  At that time it was BFI Canada Income Fund.  In 2010, I needed to buy something for Pension Account. I have this
 already and it is on TD Action Buy List.  I sold when it because the target of a reverse takeover by an American company.
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.
How they make their money.
Waste Connections is the third-largest integrated provider of traditional solid waste and recycling services in the North America. The firm serves residential, 
commercial, industrial, and energy end markets. Waste Connections entered the Canadian market with its 2016 merger with Progressive Waste. In 2020, 
13% of consolidated revenue was generated from the firm's Canadian segment.   
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 %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2015 May 10 2016 Jun 02 2016 Jun 11 2018 Jun 14 2019 Jun 13 2020 Jun 13 2021 Jun 12 2022 Jun 12 2022
Jackman, Worthing F. 0.051 0.02% 0.108 0.04% 0.117 0.04% 0.113 0.04% 0.123 0.05% 0.129 0.05% was CFO until 2019 -100.00%
CEO - Shares - Amount $4.568 $10.913 $13.795 $14.780 $21.189 $23.112 President in 2019
Options - percentage 0.069 0.03% 0.047 0.02% 0.048 0.02% 0.000 0.00% 0.079 0.03% 0.092 0.04% Mittelstraedt Chair, CEO '22 -100.00%
Options - amount $6.109 $4.714 $5.685 $0.000 $13.640 $16.430
Whitney, Mary Anne 0.039 0.01% 0.044 0.02% 0.047 0.02% 0.050 0.02% 0.056 0.02% 12.65%
CFO - Shares - Amount $4.595 $5.716 $8.156 $8.980 $10.212
Options - percentage 0.018 0.01% 0.020 0.01% 0.027 0.01% 0.030 0.01% 0.030 0.01% -0.52%
Options - amount $2.096 $2.565 $4.606 $5.381 $5.404
Chambkiss, Darrell W. 0.099 0.04% 0.097 0.04% -2.71%
Officer - Shares - Amount $17.825 $17.505
Options - percentage 0.034 0.01% 0.032 0.01% -6.59%
Options - amount $6.112 $5.763
Black, Matthew Stephen 0.015 0.01% 0.023 0.01% 0.027 0.01% 0.030 0.01% 0.032 0.01% 0.035 0.01% 0.032 0.01% -9.19%
Officer - Shares - Amount $1.335 $2.291 $3.192 $3.933 $5.578 $6.249 $5.729
Options - percentage 0.012 0.00% 0.018 0.01% 0.018 0.01% 0.016 0.01% 0.018 0.01% 0.018 0.01% 0.018 0.01% 1.26%
Options - amount $1.101 $1.843 $2.098 $2.124 $3.131 $3.271 $3.343
Chambiss. Darrell
Officer - Shares - Amount
Options - percentage
Options - amount
Guillet, Edward E.  0.061 0.02% 0.042 0.02% 0.032 0.01% 0.033 0.01% 0.033 0.01% 1.26%
Director - Shares - Amount $7.218 $5.451 $5.576 $5.895 $6.026
Options - percentage 0.003 0.00% 0.003 0.00% 0.004 0.00% 0.004 0.00% 0.004 0.00% 11.74%
Options - amount $0.318 $0.391 $0.606 $0.674 $0.760
Davis, Robert H.  0.009 0.00% 0.013 0.01% Ceased insider Apr 2019
Director - Shares - Amount $0.790 $1.366
Options - percentage 0.001 0.00% 0.002 0.00%
Options - amount $0.105 $0.233
Mittelstaedt, Ronald J.  0.134 0.05% 0.100 0.04% 0.139 0.05% 0.192 0.07% 0.190 0.07% 0.205 0.08% 0.220 0.09% Was Chair & CEO in 2019 7.23%
Chair & CEO - Shares - Amount $11.930 $10.180 $16.409 $25.011 $32.791 $36.883 $39.923
Options - percentage 0.199 0.08% 0.415 0.16% 0.274 0.10% 0.176 0.07% 0.096 0.04% 0.060 0.02% 0.052 0.02% -14.30%
Options - amount $17.762 $42.061 $32.335 $23.009 $16.597 $10.799 $9.342
Increase in O/S Shares 0.02% 0.050 0.06% 0.567 0.22% 0.691 0.26% 0.642 0.24% 0.613 0.23% 0.682 0.26% 0.517 0.20% 0.396 0.15%
due to SO 2013 $0.580 $2.257 $39.785 $61.645 $65.097 $72.342 $89.021 $89.172 $71.081
Book Value $0.265 $0.265 $36.249 $23.701 $2.667 $39.000 $39.762 $48.710 $62.952
Insider Buying -$0.530 -$0.489 -$0.150 -$0.206 $0.000 $0.000 $0.000 $0.000 -$0.020
Insider Selling $0.421 $0.160 $3.039 $17.895 $4.023 $15.515 $22.133 $4.704 $6.658
Net Insider Selling 2013 -$0.109 -$0.329 $2.889 $17.689 $4.023 $15.515 $22.133 $4.704 $6.639
% of Market Cap 0.00% 0.00% 0.01% 0.07% 0.01% 0.05% 0.05% 0.01% 0.01%
On May 28 2014
Increase in O/S Shares 0.30% 0.058 0.07%
due to RS 2013 $6.110 $2.618
Book Value
Increase in O/S Shares 0.33% 0.108 0.14%
Total Increase 2013 $6.547 $4.875
Book Value
Directors  7 7 7 6 8 8 8 8
Women 13% 1 14% 1 14% 1 14% 1 17% 2 25% 2 25% 2 25% 3 38% Company says they have
Minorities 13% 1 14% 0 0% 0 0% 0 0% 0 0% 0 0% 1 13% 1 13% a visible minority on the board
I cannot find one.
Institutions/Holdings 71.15% 229 78.70% 214 89.83% 590 90.93% 669 93.04% 20 76.12% 20 76.12% 20 52.67%
Total Shares Held 101.40% 86.020 32.73% 157.882 59.92% 239.574 91.04% 245.328 93.06% 199.183 76.55% 199.183 76.55% 135.660 52.13%
Increase/Decrease -4.83% -0.743 -0.86% -1.129 -0.71% 1.023 0.43% 1.602 0.66% 8.664 4.55% 8.664 4.55% -5.385 -3.82%
Starting No. of Shares 86.763 159.011 238.550 243.726 190.519 190.519 141.046
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock