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/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 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$ 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.3226 1.3723 1.3723 1.3723 24.35% <-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
$8,194.1 <-12 mths 2.15%
Revenue* US$ $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,022.0 $8,811 $9,462 $10,186 295.94% <-Total Growth 10 Revenue US$
Increase 28.70% 3.08% 6.82% -0.84% -4.15% 75.32% 37.16% 6.32% 9.46% 1.06% 12.95% 17.24% 11.23% 9.84% 7.39% 7.65% 14.75% <-IRR #YR-> 10 Revenue 295.94% US$
5 year Running Average $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,444.0 $7,128.4 $7,931.6 $8,738.6 10.26% <-IRR #YR-> 5 Revenue 62.95% US$
Revenue per Share $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.14 $34.16 $36.68 $39.49 14.66% <-IRR #YR-> 10 5 yr Running Average 292.87% US$
Increase 32.39% 5.81% 6.95% 1.59% -34.16% -47.57% 36.80% 6.46% 9.26% 1.37% 14.09% 18.64% 11.04% 9.68% 7.39% 7.65% 13.82% <-IRR #YR-> 5 5 yr Running Average 91.06% US$
5 year Running Average $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.80 $27.54 $30.73 $33.90 -1.61% <-IRR #YR-> 10 Revenue per Share -15.00% US$
P/S (Price/Sales) Med 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.44 4.67 4.35 4.04 10.73% <-IRR #YR-> 5 Revenue per Share 66.46% US$
P/S (Price/Sales) Close 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.79 5.07 4.72 4.38 -2.09% <-IRR #YR-> 10 5 yr Running Average -19.04% US$
*Revenue in M CDN $  P/S Med 20 yr  1.36 15 yr  3.31 10 yr  3.73 5 yr  4.44 35.91% Diff M/C 2.27% <-IRR #YR-> 5 5 yr Running Average 11.86% US$
$11,244.8 <-12 mths 5.98%
Revenue* CDN $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,609.8 $12,091 $12,985 $13,978 392.36% <-Total Growth 10 Revenue CDN$
Increase 31.84% 0.76% 13.80% 8.16% 14.41% 69.99% 28.15% 15.61% 4.21% -0.93% 12.47% 25.25% 8.62% 13.96% 7.39% 7.65% 17.28% <-IRR #YR-> 10 Revenue 392.36% CDN$
5 year Running Average $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,421.8 $9,440.3 $10,650.5 $11,886.4 9.58% <-IRR #YR-> 5 Revenue 57.98% CDN$
Revenue per Share $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.19 $46.87 $50.34 $54.19 17.48% <-IRR #YR-> 10 5 yr Running Average 400.57% CDN$
Increase 35.62% 3.42% 13.94% 10.80% -21.41% -49.17% 27.82% 15.77% 4.02% -0.63% 13.60% 26.74% 8.43% 13.80% 7.39% 7.65% 13.81% <-IRR #YR-> 5 5 yr Running Average 90.93% CDN$
5 year Running Average $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.41 $36.48 $41.27 $46.11 0.56% <-IRR #YR-> 10 Revenue per Share 5.70% CDN$
P/S (Price/Sales) Med 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.51 4.58 0.00 0.00 10.04% <-IRR #YR-> 5 Revenue per Share 61.38% CDN$
P/S (Price/Sales) Close 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.80 5.07 4.72 4.38 0.30% <-IRR #YR-> 10 5 yr Running Average 3.02% CDN$
*Revenue in M CDN $  P/S Med 10 yr  3.99 5 yr  4.53 26.82% Diff M/C 2.69% <-IRR #YR-> 5 5 yr Running Average 14.20% CDN$
-$2,154.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $10,609.8
-$6,715.9 $0.0 $0.0 $0.0 $0.0 $10,609.8
-$1,682.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $8,421.8
-$4,410.9 $0.0 $0.0 $0.0 $0.0 $8,421.8
$1,119.5 <-12 mths 3.54%
$5.14 <-12 mths 22.70%
Adjusted Net Income $221.7 $254.2 $244.9 $395.2 $570.7 $667.3 $719.6 $695.8 $846.6 $985.3 $1,081.3 387.76% <-Total Growth 10 Earnings per Share
Adjusted Net Income per Share* US$$ $1.55 $1.34 $1.79 $2.04 $1.98 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $4.77 $5.42 $6.30 134.08% <-Total Growth 10 Earnings per Share US$
Increase 17.89% -13.39% 33.28% 13.97% -2.94% -13.34% 26.13% 16.44% 7.94% -2.94% 22.35% 18.27% 9.69% 13.84% 13.63% 16.24% 10 0 10 Years of Data, EPS P or N 100.00% US$
Earnings Yield 5.7% 4.5% 5.2% 4.9% 6.1% 3.3% 3.1% 3.4% 3.0% 2.6% 2.4% 2.9% 2.8% 2.8% 3.1% 3.6% 8.88% <-IRR #YR-> 10 Earnings per Share 134.08% US$
5 year Running Average $1.17 $1.24 $1.39 $1.61 $1.74 $1.77 $1.94 $2.08 $2.22 $2.35 $2.65 $2.99 $3.32 $3.73 $4.29 $4.90 10.70% <-IRR #YR-> 5 Earnings per Share 66.27% US$
Payout Ratio 22.94% 27.85% 19.96% 17.18% 16.05% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 25.06% 23.90% 21.03% 18.10% 9.07% <-IRR #YR-> 10 5 yr Running Average 106.49% US$
5 year Running Average 59.73% 42.40% 28.75% 22.04% 20.17% 21.48% 20.96% 21.63% 23.14% 25.60% 25.24% 25.42% 25.69% 25.42% 23.89% 22.10% 9.76% <-IRR #YR-> 5 5 yr Running Average 59.31% US$
Price/AFFO Median 19.75 20.89 18.21 18.08 18.11 24.79 28.81 29.00 31.06 27.68 36.50 35.71 33.01 33.42 29.41 25.31 28.91 <-Median-> 10 Price/AEPS Median US$
Price/AFFO High 23.01 23.56 20.85 21.02 21.36 30.61 33.35 31.98 34.90 39.65 42.81 38.08 35.63 36.09 31.76 27.32 34.13 <-Median-> 10 Price/AEPS High US$
Price/AFFO Low 16.49 18.22 15.57 15.15 14.87 18.97 24.28 26.03 27.21 15.71 30.20 33.34 30.39 30.76 27.07 23.29 25.15 <-Median-> 10 Price/AEPS Low US$
Price/AFFO Close 17.49 22.27 19.14 20.42 16.47 30.54 32.78 29.46 33.38 38.85 42.19 34.70 35.63 36.28 31.93 27.47 33.08 <-Median-> 10 Price/AEPS Close US$
Trailing P/AFFO Close 20.62 19.29 25.52 23.27 15.98 26.46 41.34 34.31 36.03 37.71 51.62 41.04 39.08 41.30 36.28 31.93 36.87 <-Median-> 10 Trailing P/AEPSClose US$
* ESP per share (US$) DPR 10 Yrs 24.59% 5 Yrs   25.06% P/CF 5 Yrs   in order 33.01 38.08 30.20 35.63 9.90% Diff M/C 25.49% Diff M/C 10 DPR 75% to 95% best US$
For 2018 in report on 4th Q results.
$1,536.3 <-12 mths 7.43%
$7.05 <-12 mths 27.31%
Adjusted Net Income $235.8 $294.9 $339.1 $530.6 $715.9 $910.3 $934.6 $885.9 $1,073.3 $1,334.5 $1,430.1 506.54% <-Total Growth 10 Earnings per Share
Adjusted Net Income per Share* CDN$ $1.58 $1.34 $1.90 $2.37 $2.74 $2.30 $2.72 $3.44 $3.53 $3.36 $4.09 $5.17 $5.54 $6.55 $7.44 $8.65 191.08% <-Total Growth 10 Earnings per Share CDN$
Increase 20.77% -15.34% 42.00% 24.31% 15.85% -15.97% 17.85% 26.62% 2.76% -4.85% 21.83% 26.34% 7.11% 18.12% 13.63% 16.24% 10 0 10 Years of Data, EPS P or N 100.00% CDN$
Earnings Yield 5.7% 4.5% 5.2% 4.9% 6.1% 3.3% 3.0% 3.4% 3.0% 2.6% 2.4% 2.9% 2.8% 2.8% 3.1% 3.6% 11.28% <-IRR #YR-> 10 Earnings per Share 191.08% CDN$
5 year Running Average $1.23 $1.31 $1.43 $1.70 $1.99 $2.13 $2.41 $2.71 $2.95 $3.07 $3.43 $3.92 $4.34 $4.94 $5.76 $6.67 10.02% <-IRR #YR-> 5 Earnings per Share 61.20% CDN$
Payout Ratio 22.94% 27.85% 19.96% 17.18% 16.05% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 25.06% 23.90% 21.03% 18.10% 11.73% <-IRR #YR-> 10 5 yr Running Average 155.16% CDN$
5 year Running Average 60.78% 44.34% 28.80% 21.83% 19.76% 21.38% 21.05% 21.70% 23.09% 25.59% 25.21% 25.38% 25.67% 25.37% 23.85% 22.08% 9.86% <-IRR #YR-> 5 5 yr Running Average 60.00% CDN$
Price/FFO Median 19.31 21.25 17.81 17.66 17.02 25.64 29.78 27.52 32.18 35.78 36.44 33.29 33.53 32.78 0.00 0.00 30.98 <-Median-> 10 Price/AEPS Median CDN$
Price/FFO High 21.87 23.75 20.57 20.73 19.29 30.95 34.18 30.95 36.36 41.29 42.74 37.84 36.21 35.67 0.00 0.00 35.19 <-Median-> 10 Price/AEPS High CDN$
Price/FFO Low 16.74 18.74 15.05 14.59 14.75 20.33 25.37 24.09 28.00 30.28 30.14 28.74 30.86 29.90 0.00 0.00 26.69 <-Median-> 10 Price/AEPS Low CDN$
Price/FFO Close 17.42 22.18 19.10 20.44 16.46 30.48 32.84 29.48 33.39 38.83 42.10 34.69 35.70 36.27 31.92 27.46 33.11 <-Median-> 10 Price/AEPS Close CDN$
Trailing P/FFO Close 21.04 18.78 27.13 25.40 19.07 25.61 38.70 37.32 34.31 36.95 51.29 43.83 38.24 42.85 36.27 31.92 37.13 <-Median-> 10 Trailing P/AEPSClose CDN$
* ESP per share  DPR 10 Yrs 24.59% 5 Yrs   25.06% P/CF 5 Yrs   in order 33.53 37.84 30.14 35.70 8.17% Diff M/C 17.09% Diff M/C 10 DPR 75% to 95% best CDN$
-$1.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.54
-$3.44 $0.00 $0.00 $0.00 $0.00 $5.54
-$1.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.34
-$2.71 $0.00 $0.00 $0.00 $0.00 $4.34
$2.27 <-12 mths -23.08%
Pre-Split 2016 -$1.63 $0.81 $1.02 $1.10 $1.12
Pre-Split 2017 -$3.39 $1.68 $2.12 $2.28 $2.33 $1.61
EPS Basic US$ -$2.26 $1.12 $1.41 $1.52 $1.55 $1.07 $2.19 $2.07 $2.15 $0.78 $2.37 $3.25 $2.96 109.60% <-Total Growth 10 EPS Basic US$
Pre-Split 2016 -$1.63 $0.81 $1.02 $1.10 $1.12
Pre-Split 2017 -$4.69 $2.33 $2.93 $3.16 $3.22 $1.60
EPS Diluted* -$3.12 $1.55 $1.96 $2.11 $2.15 $1.07 $2.18 $2.07 $2.14 $0.78 $2.36 $3.24 $2.95 $4.22 $4.86 $5.65 50.87% <-Total Growth 10 EPS Diluted US$
Increase -311.69% -149.69% 25.93% 7.84% 1.82% -50.32% 104.38% -5.05% 3.38% -63.55% 202.56% 37.29% -8.95% 42.92% 15.32% 16.27% 10 0 10 Years of Data, EPS P or N 100.00% US$
Earnings Yield -11.3% 5.2% 5.4% 4.4% 4.8% 1.5% 2.4% 2.0% 1.8% 0.6% 1.4% 1.8% 1.5% 1.8% 2.0% 2.4% 4.20% <-IRR #YR-> 10 Earnings per Share 50.87% US$
5 year Running Average $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.29 $2.71 $3.53 $4.18 7.34% <-IRR #YR-> 5 Earnings per Share 42.51% 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.10 $2.31 $2.59 $3.05 15.43% <-IRR #YR-> 10 5 yr Running Average 319.89% US$
* Diluted ESP per share  E/P 10 Yrs 1.81% 5Yrs 1.49% 3.68% <-IRR #YR-> 5 5 yr Running Average 19.83% US$
$3.11 <-12 mths -20.19%
EPS Basic CDN$ -$2.30 $1.12 $1.50 $1.77 $2.15 $1.44 $2.75 $2.82 $2.79 $0.99 $3.00 $4.40 $3.91 160.64% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* -$3.19 $1.55 $2.08 $2.45 $2.97 $1.43 $2.73 $2.82 $2.78 $0.99 $2.99 $4.39 $3.90 $5.79 $6.67 $7.76 87.61% <-Total Growth 10 EPS Diluted CDN$
Increase -316.85% -148.57% 34.16% 17.63% 21.53% -51.83% 90.95% 3.26% -1.57% -64.27% 201.28% 46.67% -11.09% 48.29% 15.32% 16.27% 10 0 10 Years of Data, EPS P or N 100.00% CDN$
Earnings Yield -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.0% 2.4% 2.8% 3.3% 6.49% <-IRR #YR-> 10 Earnings 87.61% CDN$
5 year Running Average $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.01 $3.61 $4.75 $5.70 6.68% <-IRR #YR-> 5 Earnings 38.17% 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.75 $3.08 $3.45 $4.08 18.21% <-IRR #YR-> 10 5 yr Running Average 432.70% CDN$
* Diluted ESP per share  E/P 10 Yrs 2.40% 5Yrs 1.97% 3.94% <-IRR #YR-> 5 5 yr Running Average 21.31% CDN$
-$2.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.90
-$2.82 $0.00 $0.00 $0.00 $0.00 $3.90
-$0.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.01
-$2.48 $0.00 $0.00 $0.00 $0.00 $3.01
Dividend US$, Pd US$ from 2017 $1.16 $1.22 $1.30 Estimates Dividend US$, Pd US$ fr 2017
Increase 10.48% 4.74% 6.75% Estimates Increase
Payout Ratio EPS 27.51% 24.99% 22.94% 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.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.14 $1.14 $1.14 193.89% <-Total Growth 10 Dividends US$
Increase 6.40% 5.12% -4.46% -1.88% -9.36% 59.06% -1.07% 16.00% 14.66% 14.29% 11.18% 11.83% 11.11% 8.57% 0.00% 0.00% 14 7 21 Years of data, Count P, N 66.67% US$
Average Increases 5 Year Running -14.83% -18.31% -15.34% -7.47% -0.84% 9.69% 8.46% 12.55% 15.86% 20.59% 11.01% 13.59% 12.61% 11.40% 8.54% 6.30% 11.78% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $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.95 $1.02 $1.08 112.90% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 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.76% 0.72% 0.80% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 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.66% 0.71% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 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.82% 0.78% 0.93% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 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.70% 0.66% 0.66% 0.66% 0.74% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS -11.39% 24.08% 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 27.04% 23.45% 20.17% 30.12% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 196.59% 122.59% 73.33% 44.65% 37.84% 21.57% 21.47% 23.54% 26.74% 36.55% 35.15% 35.84% 37.18% 34.99% 29.04% 25.88% 35.49% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 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.72% 12.39% 11.07% 10.18% 11.70% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 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.60% 12.74% 12.15% 11.57% 9.59% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 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.80% 12.39% 11.07% 10.18% 12.02% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 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.76% 12.85% 12.27% 11.65% 9.51% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median values 10 Yr Med 10 Yr Cl 0.80% 0.74% 5 Yr Med 5 Yr Cl 0.76% 0.71% 5 Yr Med Payout 35.59% 12.72% 12.80% 12.60% <-IRR #YR-> 5 Dividends 81.03% US$
* Dividends per share  10 Yr Med and Cur. -17.41% -10.58% 5 Yr Med and Cur. -13.22% -7.59% Last Div Inc ---> $0.255 $0.285 11.76% 11.38% <-IRR #YR-> 10 Dividends 193.89% US$
Dividends Growth 15 0.39% <-IRR #YR-> 15 Dividends 6.09% US$
Dividends Growth 20 2.55% <-IRR #YR-> 20 Dividends US$
Dividends Growth 25 5.43% <-IRR #YR-> 21 Dividends
Dividends Growth 5 -$0.58 $0.00 $0.00 $0.00 $0.00 $1.05 Dividends Growth 5
Dividends Growth 10 -$0.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.05 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.05 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.05 Dividends Growth 20
Dividends Growth 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 $1.05 Dividends Growth 25
Historical Dividends Historical High Div 6.14% Low Div 0.66% 10 Yr High 1.80% 10 Yr Low 0.61% Med Div 1.16% Close Div 0.99% Historical Dividends Div Yd Years
High/Ave/Median Values Curr diff Exp. -89.27% Exp -0.19% Exp. -63.40% 7.99% Exp. -43.21% Exp. -33.71% High/Ave/Median  1.10% 5
1.85% 10
Future Dividend Yield Div Yield 1.10% earning in 5 Years at IRR of 10.87% Div Inc. 67.52% Future Dividend Yield 3.10% 15
Future Dividend Yield Div Yield 1.85% earning in 10 Years at IRR of 10.87% Div Inc. 180.63% Future Dividend Yield
Future Dividend Yield Div Yield 3.10% earning in 15 Years at IRR of 10.87% Div Inc. 370.12% Future Dividend Yield
Future Dividend Paid Div Paid $2.06 earning in 5 Years at IRR of 12.60% Div Inc. 81.03% Future Dividend Paid
Future Dividend Paid Div Paid $3.74 earning in 10 Years at IRR of 12.60% Div Inc. 227.73% Future Dividend Paid
Future Dividend Paid Div Paid $6.76 earning in 15 Years at IRR of 12.60% Div Inc. 493.31% Future Dividend Paid
Dividend Covering Cost Total Div $7.33 over 5 Years at IRR of 12.60% Div Cov. 4.24% Dividend Covering Cost
Dividend Covering Cost Total Div $18.53 over 10 Years at IRR of 12.60% Div Cov. 10.71% Dividend Covering Cost
Dividend Covering Cost Total Div $38.82 over 15 Years at IRR of 12.60% Div Cov. 22.43% Dividend Covering Cost
Yield if held 5 years 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.41% 1.26% 1.11% 0.84% 1.60% <-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.10% 2.73% 2.44% 1.93% 2.51% <-Median-> 10 Paid Median Price US$
Yield if held 15 years 3.35% 2.92% 2.19% 2.02% 2.30% 2.49% 4.39% 6.58% 3.91% 3.73% 2.49% <-Median-> 7 Paid Median Price US$
Yield if held 20 years 6.32% 5.28% 3.75% 3.02% 3.10% 5.80% <-Median-> 2 Paid Median Price US$
Cost covered if held 5 years 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.51% 4.17% 4.26% 3.63% 6.19% <-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.22% 17.48% 17.42% 14.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.60% 52.40% 33.90% 34.89% 29.89% <-Median-> 7 Paid Median Price US$
Cost covered if held 20 years 86.97% 67.52% 45.50% 37.17% 38.54% 77.24% <-Median-> 2 Paid Median Price US$
Yr  Item Tot. Growth Per Year
Dividend CDN$ Paid in US$ from 2017 $1.59 $1.67 $1.78 Estimates Div CDN$ Paid in US$ fr2017
Increase 14.63% 4.74% 6.75% Estimates Increase
Payout Ratio EPS 27.51% 24.99% 22.94% 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.55 $0.56 $0.57 $0.61 $0.66 $1.02
Pre-split 2017 $1.13 $1.16 $1.18 $1.27 $1.37 $1.02
Dividend CDN$ Paid in US$ from 2017 $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.39 $1.56 $1.56 $1.56 265.46% <-Total Growth 10 Dividends CDN$
Increase 9.00% 2.75% 1.79% 7.02% 8.20% 54.23% -7.57% 26.14% 9.16% 12.03% 10.71% 19.47% 8.50% 12.65% 0.00% 0.00% 17 3 21 Years of data, Count P, N 80.95% CDN$
Average Increases 5 Year Running -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.98% 12.67% 10.27% 8.13% 13.76% <-Median-> 10 Average Incr 5 Year Running CDN$
Dividends 5 Yr Running $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.25 $1.37 $1.47 170.31% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 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.75% 0.73% 0.79% <-Median-> 10 Yield H/L Price CDN$
Yield on High  Price 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.67% 0.69% <-Median-> 10 Yield on High  Price CDN$
Yield on Low Price 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.81% 0.80% 0.93% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 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.70% 0.66% 0.66% 0.66% 0.74% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS -11.39% 24.08% 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 27.04% 23.45% 20.17% 30.12% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 182.79% 119.12% 72.93% 42.62% 33.52% 21.74% 21.71% 23.72% 26.69% 36.50% 35.06% 35.59% 37.01% 34.73% 28.93% 25.83% 34.29% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 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.72% 12.39% 11.07% 10.18% 11.70% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 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.59% 12.72% 12.13% 11.56% 9.65% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 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.80% 12.39% 11.07% 10.18% 12.02% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 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.75% 12.83% 12.25% 11.64% 9.58% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median values 10 Yr Med 10 Yr Cl 0.79% 0.74% 5 Yr Med 5 Yr Cl 0.75% 0.71% 5 Yr Med Payout 35.59% 12.72% 12.80% 11.91% <-IRR #YR-> 5 Dividends 75.51% CDN$
* Dividends per share  10 Yr Med and Cur. -16.62% -10.58% 5 Yr Med and Cur. -11.84% -7.61% Last Div Inc ---> $0.185 $0.205 10.81% 13.84% <-IRR #YR-> 10 Dividends 265.46% CDN$
Dividends Growth 15 0.91% <-IRR #YR-> 15 Dividends 14.58% CDN$
Dividends Growth 20 2.67% <-IRR #YR-> 20 Dividends CDN$
Dividends Growth 25 4.54% <-IRR #YR-> 21 Dividends
Dividends Growth 5 -$0.79 $0.00 $0.00 $0.00 $0.00 $1.39 Dividends Growth 5
Dividends Growth 10 -$0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.39 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.39 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.39 Dividends Growth 20
Dividends Growth 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 $1.39 Dividends Growth 25
Historical Dividends Historical High Div 5.35% Low Div 0.66% 10 Yr High 1.42% 10 Yr Low 0.62% Med Div 1.15% Close Div 1.02% Historical Dividends
High/Ave/Median Values Curr diff Exp. -87.68% Exp -0.17% Exp. -53.60% 6.27% Exp. -42.71% Exp. -35.41% High/Ave/Median 
Future Dividend Yield Div Yield 1.16% earning in 5 Years at IRR of 11.91% Div Inc. 75.51% Future Dividend Yield
Future Dividend Yield Div Yield 2.03% earning in 10 Years at IRR of 11.91% Div Inc. 208.05% Future Dividend Yield
Future Dividend Yield Div Yield 3.56% earning in 15 Years at IRR of 11.91% Div Inc. 440.67% Future Dividend Yield
Future Dividend Paid Div Paid $2.75 earning in 5 Years at IRR of 11.91% Div Inc. 75.51% Future Dividend Paid
Future Dividend Paid Div Paid $4.82 earning in 10 Years at IRR of 11.91% Div Inc. 208.05% Future Dividend Paid
Future Dividend Paid Div Paid $8.46 earning in 15 Years at IRR of 11.91% Div Inc. 440.67% Future Dividend Paid
Dividend Covering Cost Total Div $9.92 over 5 Years at IRR of 11.91% Div Cov. 4.18% Dividend Covering Cost
Dividend Covering Cost Total Div $24.59 over 10 Years at IRR of 11.91% Div Cov. 10.35% Dividend Covering Cost
Dividend Covering Cost Total Div $50.33 over 15 Years at IRR of 11.91% Div Cov. 21.20% Dividend Covering Cost
Yield if held 5 years 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.47% 1.38% 1.30% 1.05% 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.09% 3.74% 3.35% 2.65% 3.31% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 years 4.20% 3.98% 2.84% 2.57% 2.92% 3.37% 5.80% 9.03% 5.37% 5.12% 3.37% <-Median-> 7 Paid Median Price CDN$
Yield if held 20 years 8.56% 6.99% 5.15% 4.15% 4.26% 7.78% <-Median-> 2 Paid Median Price CDN$
Cost covered if held 5 years 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.89% 5.52% 5.71% 4.93% 7.79% <-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.11% 23.14% 23.14% 19.78% 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.18% 66.54% 43.76% 45.66% 34.75% <-Median-> 7 Paid Median Price CDN$
Cost covered if held 20 years 104.23% 81.27% 55.40% 45.86% 48.16% 92.75% <-Median-> 2 Paid Median Price CDN$
Yr  Item Tot. Growth Per Year
Revenue Growth US$ $4,922.9 $5,388.7 $5,446.0 $6,151.4 $7,211.9 $8,022.0 $8,194 <-12 mths 2.15% 62.95% <-Total Growth 5 Revenue Growth US$ 62.95% 10.26%
AEPS Growth $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $5.14 <-12 mths 22.70% 66.27% <-Total Growth 5 AEPS Growth 66.27% 10.70%
Net Income Growth $546.9 $566.8 $204.7 $618.0 $835.7 $762.8 $795 <-12 mths 4.23% 39.48% <-Total Growth 5 Net Income Growth 39.48% 6.88%
Cash Flow Growth $1,411.2 $1,540.5 $1,408.5 $1,698.2 $2,022.5 $2,126.8 $2,175 <-12 mths 2.25% 50.71% <-Total Growth 5 Cash Flow Growth 50.71% 8.55%
Dividend Growth $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.14 <-12 mths 8.57% 81.03% <-Total Growth 5 Dividend Growth 81.03% 12.60%
Stock Price Growth $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $173.05 <-12 mths 15.93% 101.04% <-Total Growth 5 Stock Price Growth 101.04% 14.99%
Revenue Growth US$ $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,022.0 $8,811 <-this year 9.84% 295.94% <-Total Growth 10 Revenue Growth US$ 295.94% 14.75%
AEPS Growth $1.79 $2.04 $1.98 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $4.77 <-this year 13.84% 134.08% <-Total Growth 10 AEPS Growth 134.08% 8.88%
Net Income Growth $118.0 $126.5 $123.9 $245.8 $576.8 $546.9 $566.8 $204.7 $618.0 $835.7 $762.8 $1,088 <-this year 42.63% 546.61% <-Total Growth 10 Net Income Growth 546.61% 20.52%
Cash Flow Growth $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,126.8 $2,373 <-this year 11.59% 371.86% <-Total Growth 10 Cash Flow Growth 371.86% 16.78%
Dividend Growth $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.16 <-this year 10.48% 193.89% <-Total Growth 10 Dividend Growth 193.89% 11.38%
Stock Price Growth $34.27 $41.65 $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $173.05 <-this year 15.93% 335.61% <-Total Growth 10 Stock Price Growth 335.61% 15.85%
Dividends on Shares CDN$ $11.39 $12.32 $19.00 $17.56 $22.15 $24.18 $27.09 $30.00 $35.84 $38.88 $43.80 $43.80 $43.80 $238.42 No of Years 10 Total Dividends CDN$ 12/31/13
Paid  $1,018.41 $1,354.13 $1,263.80 $1,966.35 $2,496.48 $2,837.24 $3,302.60 $3,654.56 $4,827.20 $5,025.44 $5,540.08 $6,648.32 $6,648.32 $6,648.32 $5,540.08 No of Years 10 Worth $36.37 27.49
Total $5,778.50 Total
Dividends on Shares CDN$ $8.64 $9.68 $10.71 $12.80 $13.89 $15.64 $15.64 $15.64 $55.71 No of Years 5 Total Dividends CDN$ 12/31/18
Paid  $1,013.30 $1,179.50 $1,305.20 $1,724.00 $1,794.80 $1,978.60 $2,374.40 $2,374.40 $2,374.40 $1,978.60 No of Years 5 Worth $101.33 9.87
Total $2,034.31 Total
Dividends on Shares US$ $10.52 $9.53 $15.16 $15.00 $17.40 $19.95 $22.80 $25.35 $28.35 $31.50 $34.20 $34.20 $34.20 $195.56 No of Years 10 Total Dividends US$ 12/31/13
Paid  $1,028.02 $1,249.40 $978.17 $1,571.80 $2,128.20 $2,227.50 $2,723.70 $3,077.10 $4,088.10 $3,976.80 $4,478.10 $5,191.50 $5,191.50 $5,191.50 $4,478.10 No of Years 10 Worth $34.27 29.18
Total $4,673.66 Total
Graham Price AEPS $28.78 $26.31 $32.59 $37.50 $32.55 $38.67 $42.70 $50.88 $52.11 $50.13 $56.01 $66.02 $70.18 $78.11 $83.26 $89.77 139.64% <-Total Growth 11 Graham Price AEPS CDN$
Price/GP Ratio Med 1.06 1.08 1.04 1.11 1.43 1.53 1.89 1.86 2.18 2.40 2.66 2.61 2.65 2.75 2.18 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio High 1.20 1.21 1.20 1.31 1.63 1.84 2.17 2.09 2.47 2.77 3.12 2.97 2.86 2.99 2.47 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Low 0.92 0.96 0.88 0.92 1.24 1.21 1.61 1.63 1.90 2.03 2.20 2.25 2.44 2.51 1.90 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Close 0.96 1.13 1.12 1.29 1.39 1.82 2.09 1.99 2.26 2.60 3.08 2.72 2.82 3.04 2.85 2.65 2.26 <-Median-> 11 Price/GP Ratio CDN$
Prem/Disc Close -4.11% 13.04% 11.59% 28.97% 38.69% 81.59% 108.81% 99.17% 126.36% 160.36% 207.79% 171.86% 181.94% 203.98% 185.17% 164.51% 126.36% <-Median-> 11 Graham Price
Graham Price EPS $27.74 $28.29 $34.07 $38.12 $36.48 $30.49 $42.85 $46.11 $46.22 $27.25 $47.88 $60.80 $58.88 $73.43 $78.86 $85.03 115.56% <-Total Growth 11 Graham Price EPS CDN$
Price/GP Ratio Med 1.10 1.01 1.00 1.10 1.28 1.94 1.89 2.05 2.46 4.41 3.12 2.83 3.16 2.92 2.46 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio High 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.41 3.18 2.78 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Low 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.90 2.66 2.14 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Close 0.99 1.05 1.07 1.27 1.24 2.30 2.08 2.20 2.55 4.79 3.60 2.95 3.36 3.23 3.01 2.79 2.55 <-Median-> 11 Price/GP Ratio CDN$
Prem/Disc Close -0.52% 5.13% 6.77% 26.85% 23.74% 130.31% 108.05% 119.76% 155.19% 379.00% 260.08% 195.19% 236.01% 223.34% 201.09% 179.23% 155.19% <-Median-> 11 Graham Price
Pre-Split 2016 $19.93 $21.48 $26.27 $34.93 $32.60
Pre-Split 2017 $41.39 $44.61 $54.56 $72.54 $67.70 $105.34
Price Close CDN$ $27.59 $29.74 $36.37 $48.36 $45.14 $70.23 $89.16 $101.33 $117.95 $130.52 $172.40 $179.48 $197.86 $237.44 $237.44 $237.44 443.99% <-Total Growth 10 Stock Price CDN$ CDN$
Increase -17.61% 7.78% 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 10.24% 20.00% 0.00% 0.00% 34.15 <-Median-> 10 CAPE (10 Yr P/E)
P/E -8.65 19.19 17.49 19.77 15.18 49.03 32.60 35.88 42.44 131.43 57.62 40.90 50.71 41.04 35.59 30.61 14.32% <-IRR #YR-> 5 Stock Price 95.26% CDN$
Trailing P/E 18.75 -9.32 23.46 23.26 18.45 23.62 62.25 37.05 41.77 46.96 173.60 59.99 45.09 60.86 41.04 35.59 18.46% <-IRR #YR-> 10 Stock Price 443.99% 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 41.96 43.55 44.45 41.66 15.15% <-IRR #YR-> 5 Price & Dividend 100.76% CDN$
Median 10, 5 Yrs D.  per yr 1.03% 0.83% % Tot Ret 5.26% 5.47% T P/E 43.43 46.96 P/E:  41.67 50.71 19.48% <-IRR #YR-> 10 Price & Dividend 467.41% CDN$
Price 15 D.  per yr 1.45% % Tot Ret 7.07% CAPE Diff 20.17% 19.01% <-IRR #YR-> 15 Stock Price 1261.02% CDN$
Price  20 D.  per yr 1.64% % Tot Ret 12.65% 11.35% <-IRR #YR-> 20 Stock Price 758.30% CDN$
Price  25 D.  per yr 2.34% % Tot Ret 15.41% 12.85% <-IRR #YR-> 22 Stock Price #DIV/0! CDN$
Price & Dividend 15 20.46% <-IRR #YR-> 15 Price & Dividend 1333.77% CDN$
Price & Dividend 20 12.99% <-IRR #YR-> 20 Price & Dividend 828.35% CDN$
Price & Dividend 25 15.19% <-IRR #YR-> 22 Price & Dividend #DIV/0! CDN$
Price  5 -$101.33 $0.00 $0.00 $0.00 $0.00 $197.86 Price  5
Price 10 -$36.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $197.86 Price 10
Price & Dividend 5 -$101.33 $0.86 $0.97 $1.07 $1.28 $199.25 Price & Dividend 5
Price & Dividend 10 -$36.37 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $199.25 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 $197.86 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 $197.86 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 $197.86 Price  25
Price & Dividend 15 $0.36 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $199.25 Price & Dividend 15
Price & Dividend 20 $0.36 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $199.25 Price & Dividend 20
Price & Dividend 25 $0.36 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $199.25 Price & Dividend 25
Price H/L Median $30.58 $28.49 $33.91 $41.80 $46.67 $59.07 $80.85 $94.60 $113.69 $120.27 $149.22 $172.25 $185.83 $214.58 447.93% <-Total Growth 10 Stock Price CDN$
Increase 4.87% -6.84% 19.05% 23.25% 11.64% 26.57% 36.87% 17.01% 20.18% 5.79% 24.07% 15.43% 7.88% 15.47% 18.54% <-IRR #YR-> 10 Stock Price 447.93% CDN$
P/E -9.58 18.38 16.31 17.09 15.70 41.24 29.56 33.50 40.90 121.11 49.87 39.25 47.63 37.09 14.46% <-IRR #YR-> 5 Stock Price 96.43% CDN$
Trailing P/E 20.78 -8.93 21.88 20.10 19.08 19.87 56.45 34.59 40.26 43.27 150.26 57.57 42.35 55.00 19.64% <-IRR #YR-> 10 Price & Dividend 473.04% CDN$
P/E on Running 5 yr Average 74.89 58.65 60.00 47.98 39.83 28.18 34.65 38.11 44.61 55.87 60.54 61.62 61.72 59.41 15.34% <-IRR #YR-> 5 Price & Dividend 102.32% 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 67.66 69.66 29.28 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D.  per yr 1.10% 0.89% % Tot Ret 5.59% 5.77% T P/E 41.30 43.27 P/E:  40.08 47.63 Count 21 Years of data
-$33.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $185.83
-$94.60 $0.00 $0.00 $0.00 $0.00 $185.83
-$33.91 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $187.21
-$94.60 $0.86 $0.97 $1.07 $1.28 $187.21
High Months Apr Feb Dec Dec Apr Dec Oct Sep May Feb Nov Dec Dec Mar
Pre-Split 2016 $25.02 $23.00 $28.29 $35.44 $38.20
Pre-Split 2017 $51.96 $47.77 $58.75 $73.60 $79.33 $106.96
Price High $34.64 $31.84 $39.17 $49.07 $52.89 $71.31 $92.80 $106.40 $128.46 $138.77 $175.03 $195.80 $200.64 $233.46 412.25% <-Total Growth 10 Stock Price CDN$
Increase -0.91% -8.07% 23.00% 25.27% 7.79% 34.82% 30.14% 14.66% 20.73% 8.03% 26.13% 11.87% 2.47% 16.36% 17.75% <-IRR #YR-> 10 Stock Price 412.25% CDN$
P/E -10.86 20.54 18.83 20.06 17.79 49.79 33.93 37.68 46.22 139.73 58.50 44.62 51.42 40.35 13.53% <-IRR #YR-> 5 Stock Price 88.57% CDN$
Trailing P/E 23.54 -9.98 25.27 23.59 21.62 23.98 64.79 38.91 45.49 49.93 176.25 65.44 45.72 59.84 33.39 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 45.61 49.93 P/E:  45.42 51.42 50.44 P/E Ratio Historical High CDN$
-$39.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200.64
-$106.40 $0.00 $0.00 $0.00 $0.00 $200.64
Low Months Aug Jun Feb Jan Dec Jan Jan Feb Jan Mar Feb Jun Jan Jan
Price Low $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 $195.70 496.69% <-Total Growth 10 Stock Price CDN$
Increase 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% 14.44% 19.56% <-IRR #YR-> 10 Stock Price 496.69% CDN$
P/E -8.31 16.21 13.78 14.12 13.60 32.70 25.19 29.32 35.59 102.48 41.25 33.89 43.83 33.83 15.61% <-IRR #YR-> 5 Stock Price 106.53% CDN$
Trailing P/E 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 50.16 25.17 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 35.82 38.97 P/E:  33.29 41.25 37.85 P/E Ratio Historical High CDN$
-$28.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $171.01
US$ Price based on CDN$ Price, Exch $27.02 $29.79 $34.20 $41.69 $32.60 $52.30 $71.07 $74.28 $90.81 $102.51 $135.98 $132.52 $149.60 $173.02 $173.02 $173.02
Price Close US$ $27.12 $29.91 $34.27 $41.65 $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $173.05 $173.05 $173.05 335.61% <-Total Growth 10 Stock Price US$ US$
Increase -19.38% 10.26% 14.58% 21.54% -21.71% 60.69% 35.40% 4.67% 22.28% 12.97% 32.86% -2.72% 12.61% 15.93% 0.00% 0.00% 35.04 <-Median-> 10 CAPE (10 Yr P/E)
P/E -8.68 19.26 17.53 19.75 15.19 49.12 32.54 35.87 42.43 131.50 57.74 40.91 50.60 41.05 35.59 30.61 14.99% <-IRR #YR-> 5 Stock Price 101.04% US$
Trailing P/E 18.38 -9.57 22.07 21.30 15.46 24.40 66.51 34.06 43.86 47.93 174.71 56.17 46.07 58.66 41.05 35.59 15.85% <-IRR #YR-> 10 Stock Price 335.61% 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 41.98 43.83 44.66 41.90 15.85% <-IRR #YR-> 5 Price & Dividend 106.78% US$
Median 10, 5 Yrs D.  per yr 0.92% 0.86% % Tot Ret 5.49% 5.42% T P/E 44.97 47.93 P/E:  41.67 50.60 16.77% <-IRR #YR-> 10 Price & Dividend 354.63% US$
Price 15 D.  per yr 1.60% % Tot Ret 7.99% 18.41% <-IRR #YR-> 15 Stock Price 1160.96% US$
Price  20 D.  per yr 2.27% % Tot Ret 15.34% 12.55% <-IRR #YR-> 20 Stock Price 963.24% US$
Price  25 D.  per yr 3.88% % Tot Ret 20.34% 15.17% <-IRR #YR-> 22 Stock Price US$
Price & Dividend 15 20.01% <-IRR #YR-> 15 Price & Dividend 1163.13% US$
Price & Dividend 20 14.82% <-IRR #YR-> 20 Price & Dividend 965.07% US$
Price & Dividend 25 19.05% <-IRR #YR-> 22 Price & Dividend US$
Price  5 -$74.25 $0.00 $0.00 $0.00 $0.00 $149.27 Price  5
Price 10 -$34.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $149.27 Price 10
Price & Dividend 5 -$74.25 $0.67 $0.76 $0.85 $0.95 $150.32 Price & Dividend 5
Price & Dividend 10 -$34.27 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $150.32 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 $149.27 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 $149.27 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 $149.27 Price  25
Price & Dividend 15 $0.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $150.32 Price & Dividend 15
Price & Dividend 20 $0.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $150.32 Price & Dividend 20
Price & Dividend 25 $0.36 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $150.32 Price & Dividend 25
Price H/L Median US$ $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.31 $159.43 $159.43 $159.43 324.28% <-Total Growth 10 Stock Price US$
Increase 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.40% 15.27% 15.55% <-IRR #YR-> 10 Stock Price 324.28% US$
P/E -9.80 18.07 16.67 17.50 16.71 39.88 28.61 35.31 39.47 93.68 49.96 42.10 46.88 37.81 13.61% <-IRR #YR-> 5 Stock Price 89.23% US$
Trailing P/E 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.69 54.04 16.53% <-IRR #YR-> 10 Price & Dividend 344.28% US$
P/E on Running 5 yr Average 86.30 65.23 59.67 46.48 38.66 24.09 32.97 38.18 43.98 44.36 61.86 64.40 60.29 58.85 14.50% <-IRR #YR-> 5 Price & Dividend 95.07% 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 65.73 68.87 28.61 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 0.98% 0.89% % Tot Ret 5.92% 6.16% T P/E 37.48 42.69 P/E:  39.68 46.88
-$32.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $138.31
-$73.09 $0.00 $0.00 $0.00 $0.00 $138.31
-$32.60 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $139.36
-$73.09 $0.67 $0.76 $0.85 $0.95 $139.36
High Months US$ Apr Apr Oct Dec Apr Dec Oct Sep May Feb Nov Nov Dec Mar
Pre-Split 2016 $25.77 $22.85 $26.96 $30.97 $30.54
Pre-Split 2017 $53.52 $47.45 $55.99 $64.32 $63.43 $78.78
Price High $35.68 $31.64 $37.33 $42.88 $42.28 $52.52 $72.18 $80.58 $94.93 $104.67 $138.27 $145.45 $149.27 $172.13 $172.13 $172.13 299.90% <-Total Growth 10 Stock Price US$
Increase 6.05% -11.33% 17.99% 14.87% -1.39% 24.21% 37.43% 11.64% 17.81% 10.26% 32.10% 5.19% 2.63% 15.31% 14.87% <-IRR #YR-> 10 Stock Price 299.90% US$
P/E -11.42 20.38 19.09 20.34 19.69 49.24 33.11 38.93 44.36 134.19 58.59 44.89 50.60 40.83 13.12% <-IRR #YR-> 5 Stock Price 85.24% US$
Trailing P/E 24.17 -10.13 24.04 21.93 20.05 24.46 67.67 36.96 45.86 48.91 177.27 61.63 46.07 58.35 33.11 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 45.97 48.91 P/E:  44.63 50.60 50.06 P/E Ratio Historical High US$
-$37.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $149.27
-$80.58 $0.00 $0.00 $0.00 $0.00 $149.27
Low Months US$ Dec Jun Feb Jan Dec Jan Jan Feb Jan Mar Feb Feb Jan Jan
Price Low $25.57 $24.46 $27.87 $30.90 $29.45 $32.55 $52.54 $65.60 $74.02 $41.47 $97.54 $127.35 $127.35 $146.72 $146.72 $146.72 356.93% <-Total Growth 10 Stock Price US$
Increase 16.60% -4.33% 13.92% 10.88% -4.70% 10.54% 61.40% 24.86% 12.84% -43.97% 135.21% 30.56% 0.00% 15.21% 16.41% <-IRR #YR-> 10 Stock Price 356.93% US$
P/E -8.18 15.76 14.25 14.66 13.72 30.52 24.10 31.69 34.59 53.17 41.33 39.31 43.17 34.80 14.19% <-IRR #YR-> 5 Stock Price 94.13% US$
Trailing P/E 17.32 -7.83 17.95 15.80 13.97 15.16 49.26 30.09 35.76 19.38 125.05 53.96 39.31 49.74 24.10 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 32.93 39.31 P/E:  33.14 41.33 40.52 P/E Ratio Historical High US$
-$27.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $127.35
$1,246 <-12 mths 4.44%
Free Cash Flow $246.25 $262.81 $274.19 $303.80 $338.17 $450.59 $707.97 $865.09 $874.46 $744 $954 $1,110 $1,193 $1,214 $1,510 $1,804 335.10% <-Total Growth 10 Free Cash Flow US$
Change 33.24% 57.12% 22.19% 1.08% -14.92% 28.23% 16.35% 7.48% 7.19% 7.19% 7.19% 6.64% <-IRR #YR-> 5 Free Cash Flow MS 37.90% US$
FCF/CF from Op Ratio 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.56 0.74 0.74 0.74 15.84% <-IRR #YR-> 10 Free Cash Flow MS 335.10% US$
Dividends paid $20.22 $20.71 $19.76 $18.92 $56.00 $93.00 $131.98 $152.55 $175.07 $199.88 $220.20 $243.01 $270.60 $239.40 $239.40 $239.40 1269.56% <-Total Growth 10 Dividends paid US$
Percentage paid 16.56% 20.64% 18.64% 17.63% 20.02% 26.87% 23.08% 21.89% 22.68% 18.89% 18.89% 18.89% $0.21 <-Median-> 9 Percentage paid US$
5 Year Covrage 18.81% 20.66% 21.22% 21.79% 22.74% 20.98% 20.98% 20.98% 5 Year Coverage US$
Dividend Coverage Ratio 6.04 4.85 5.36 5.67 5.00 3.72 4.33 4.57 4.41 5.29 5.29 5.29 4.85 <-Median-> 9 Dividend Coverage Ratio US$
5 Year of Coverage 5.32 4.84 4.71 4.59 4.40 4.77 4.77 4.77 5 Year of Coverage US$
Market Cap US$ $1,542 $1,656 $1,895 $2,248 $2,562 $13,769 $18,692 $19,538 $23,934 $26,958 $35,459 $34,087 $38,452 $44,640 $44,640 $44,640 1929.05% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $1,568 $1,647 $2,011 $2,611 $3,547 $18,456 $23,493 $26,664 $31,094 $34,304 $44,861 $46,153 $50,969 $61,250 $61,250 $61,250 2433.92% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 87.17 84.35 83.18 82.93 79.80 231.08 264.30 264.40 264.53 263.69 261.73 258.04 258.15 259.56 210.34% <-Total Growth 10 Diluted
Change 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.04% 0.55% -0.13% <-Median-> 10 Change
Difference Diluted/Basic 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% -0.2%
Basic # of Shares in Millions 87.17 84.35 83.18 82.93 79.80 230.33 263.68 263.65 263.79 263.19 261.17 257.38 257.55 258.95 209.62% <-Total Growth 10 Basic
Change 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.07% 0.54% -0.12% <-Median-> 10 Change
Difference Basic/Outstanding -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.0% -0.4% -0.12% <-Median-> 10 Difference
$2,174.77 <-12 mths 2.25%
# of Shares in Millions 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.600 257.962 257.962 257.962 16.63% <-IRR #YR-> 10 Shares 365.80%
Change -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.18% 0.14% 0.00% 0.00% -0.42% <-IRR #YR-> 5 Shares -2.11%
CF fr Op $M US$ $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,126.8 $2,373.2 $2,657.0 $2,889.2 371.86% <-Total Growth 10 Cash Flow US$
Increase 34.66% -14.90% 33.84% 0.00% -7.92% 91.63% 49.28% 18.86% 9.16% -8.57% 20.57% 19.09% 5.16% 11.59% 11.96% 8.74% SO Buy Backs S Iss.
5 year Running Average $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,759.3 $1,925.9 $2,175.6 $2,413.7 407.50% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $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.26 $9.20 $10.30 $11.20 1.30% <-Total Growth 10 Cash Flow per Share US$
Increase 38.52% -12.64% 34.01% 2.45% -36.75% -42.69% 48.89% 19.02% 8.97% -8.29% 21.78% 20.51% 4.97% 11.43% 11.96% 8.74% 16.78% <-IRR #YR-> 10 Cash Flow 371.86% US$
5 year Running Average $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.77 $7.44 $8.43 $9.36 8.55% <-IRR #YR-> 5 Cash Flow 50.71% US$
P/CFPS on Median 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.75 17.33 15.48 14.23 0.13% <-IRR #YR-> 10 Cash Flow per Share 1.30% US$
P/CFPS on Close 3.90 4.92 4.20 4.99 6.17 17.31 15.74 13.84 15.54 19.14 20.88 16.85 18.08 18.81 16.80 15.45 9.01% <-IRR #YR-> 5 Cash Flow per Share 53.95% US$
34.86% Diff M/C 0.35% <-IRR #YR-> 10 CFPS 5 yr Running 3.57% US$
$2,185 <-12 mths 3.36%
Excl.Working Capital CF $33.01 $75.39 -$7.25 $25.37 -$15.69 $35.22 $71.00 -$32.00 -$27.00 $24.00 -$19.00 -$73.00 -$13.00 $0.00 $0.00 $0.00 5.00% <-IRR #YR-> 5 CFPS 5 yr Running 27.61% US$
CF fr Op $M WC $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,113.8 $2,373.2 $2,657.0 $2,889.2 376.64% <-Total Growth 10 Cash Flow less WC US$
Increase 36.44% -3.86% 7.60% 7.36% -16.13% 107.98% 51.50% 9.61% 9.74% -5.35% 17.22% 16.09% 8.43% 12.27% 11.96% 8.74% 16.90% <-IRR #YR-> 10 Cash Flow less WC 376.64% US$
5 year Running Average $280 $319 $367 $415 $432 $512 $682 $869 $1,076 $1,283 $1,453 $1,591 $1,738 $1,910 $2,155 $2,397 8.91% <-IRR #YR-> 5 Cash Flow less WC 53.26% US$
CFPS Excl. WC $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.21 $9.20 $10.30 $11.20 16.83% <-IRR #YR-> 10 CF less WC 5 Yr Run 373.58% US$
Increase 40.35% -1.32% 7.73% 9.99% -42.39% -37.81% 51.10% 9.76% 9.54% -5.07% 18.40% 17.48% 8.24% 12.12% 11.96% 8.74% 14.87% <-IRR #YR-> 5 CF less WC 5 Yr Run 100.04% US$
5 year Running Average $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.69 $7.38 $8.35 $9.30 0.23% <-IRR #YR-> 10 CFPS - Less WC 2.33% US$
P/CFPS on Median 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.86 17.33 15.48 14.23 9.38% <-IRR #YR-> 5 CFPS - Less WC 56.56% US$
P/CFPS on Close 3.60 4.02 4.27 4.72 6.42 16.58 14.86 14.17 15.81 18.82 21.12 17.49 18.19 18.81 16.80 15.45 -0.27% <-IRR #YR-> 5 CFPS 5 yr Running -2.63% US$
CF/-WC P/CF Med 10 yr 13.95 5 yr  16.75 P/CF Med 10 yr 13.70 5 yr  16.86 37.28% Diff M/C 4.31% <-IRR #YR-> 5 CFPS 5 yr Running 23.47% US$
$2,984.43 <-12 mths 6.75%
CF fr Op $M CDN$ $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,812.9 $3,256.8 $3,646.2 $3,964.8 486.76% <-Total Growth 10 Cash Flow CDN$
Increase 37.94% -16.81% 42.60% 9.07% 9.90% 85.82% 39.48% 29.26% 3.93% -10.37% 20.06% 27.23% 2.69% 15.78% 11.96% 8.74% SO Buy Backs S Iss.
5 year Running Average $283 $306 $356 $407 $463 $596 $827 $1,116 $1,412 $1,655 $1,872 $2,122 $2,300 $2,551 $2,922 $3,284 545.37% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $7.11 $6.07 $8.67 $9.69 $7.31 $4.06 $5.65 $7.32 $7.59 $6.82 $8.27 $10.65 $10.92 $12.63 $14.13 $15.37 25.97% <-Total Growth 10 Cash Flow per Share CDN$
Increase 41.90% -14.61% 42.77% 11.74% -24.51% -44.43% 39.11% 29.43% 3.74% -10.10% 21.26% 28.75% 2.51% 15.62% 11.96% 8.74% 19.36% <-IRR #YR-> 10 Cash Flow 486.76% CDN$
5 year Running Average $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.85 $9.86 $11.32 $12.74 7.88% <-IRR #YR-> 5 Cash Flow 46.11% CDN$
P/CFPS on Median 4.30 4.69 3.91 4.32 6.38 14.54 14.30 12.93 14.98 17.63 18.03 16.17 17.02 17.00 0.00 0.00 2.34% <-IRR #YR-> 10 Cash Flow per Share 25.97% CDN$
P/CFPS on Close 3.88 4.90 4.20 4.99 6.17 17.28 15.77 13.85 15.54 19.13 20.84 16.85 18.12 18.81 16.80 15.45 8.34% <-IRR #YR-> 5 Cash Flow per Share 49.25% CDN$
27.44% Diff M/C 2.78% <-IRR #YR-> 10 CFPS 5 yr Running 31.53% CDN$
$2,998 <-12 mths 7.25%
Excl.Working Capital CF $33.71 $75.27 -$7.72 $29.44 -$21.73 $47.29 $89.07 -$43.65 -$35.07 $30.56 -$24.09 -$98.87 -$17.19 $0.00 $0.00 $0.00 5.40% <-IRR #YR-> 5 CFPS 5 yr Running 30.05% CDN$
CF fr Op $M WC $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,795.7 $3,256.8 $3,646.2 $3,964.8 492.71% <-Total Growth 10 Cash Flow less WC CDN$
Increase 39.77% -6.03% 14.64% 17.10% 0.11% 101.67% 41.55% 19.20% 4.48% -7.22% 16.72% 24.02% 5.88% 16.49% 11.96% 8.74% 19.48% <-IRR #YR-> 10 Cash Flow less WC 492.71% CDN$
5 year Running Average $293 $332 $376 $437 $485 $621 $854 $1,136 $1,419 $1,673 $1,876 $2,088 $2,271 $2,529 $2,894 $3,261 8.24% <-IRR #YR-> 5 Cash Flow less WC 48.59% CDN$
CFPS Excl. WC $7.70 $7.43 $8.53 $10.23 $7.04 $4.24 $5.99 $7.15 $7.46 $6.94 $8.18 $10.27 $10.85 $12.63 $14.13 $15.37 19.69% <-IRR #YR-> 10 CF less WC 5 Yr Run 503.26% CDN$
Increase 43.78% -3.54% 14.78% 19.97% -31.23% -39.69% 41.18% 19.36% 4.29% -6.94% 17.90% 25.50% 5.70% 16.33% 11.96% 8.74% 14.86% <-IRR #YR-> 5 CF less WC 5 Yr Run 99.89% CDN$
5 year Running Average $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.74 $9.77 $11.21 $12.65 2.44% <-IRR #YR-> 10 CFPS - Less WC 27.25% CDN$
P/CFPS on Median 3.97 3.83 3.98 4.09 6.63 13.92 13.50 13.23 15.25 17.33 18.24 16.78 17.12 17.00 0.00 0.00 8.70% <-IRR #YR-> 5 CFPS - Less WC 51.78% CDN$
P/CFPS on Close 3.58 4.00 4.26 4.73 6.41 16.55 14.88 14.17 15.82 18.81 21.07 17.48 18.23 18.81 16.80 15.45 2.16% <-IRR #YR-> 10 CFPS 5 yr Running 23.88% CDN$
*Operational cash flow Per Share (OPS) CF/-WC P/CF Med 10 yr 14.76 5 yr  17.02 P/CF Med 10 yr 14.58 5 yr  17.12 28.96% Diff M/C 4.75% <-IRR #YR-> 5 CFPS 5 yr Running 26.11% CDN$
-$8.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.92 Cash Flow per Share CDN$
-$7.32 $0.00 $0.00 $0.00 $0.00 $10.92 Cash Flow per Share CDN$
-$6.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.85 CFPS 5 yr Running CDN$
-$6.81 $0.00 $0.00 $0.00 $0.00 $8.85 CFPS 5 yr Running CDN$
-$472 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,796 Cash Flow less WC CDN$
-$1,882 $0 $0 $0 $0 $2,796 Cash Flow less WC CDN$
-$376 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,271 CF less WC 5 Yr Run CDN$
-$1,136 $0 $0 $0 $0 $2,271 CF less WC 5 Yr Run CDN$
-$8.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.85 CFPS - Less WC CDN$
-$7.15 $0.00 $0.00 $0.00 $0.00 $10.85 CFPS - Less WC CDN$
OPM 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.51% 26.94% 19.17% <-Total Growth 10 OPM CDN$
Increase 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.46% 1.59% Should increase  or be stable. CDN$
Diff from Median -17.9% -32.2% -15.0% -14.3% -17.7% -10.0% -2.1% 9.5% 9.2% -1.2% 5.4% 7.1% 1.2% 2.9% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 26.19% 5 Yrs 27.61% should be zero,  it is a check  on calculations CDN$
Revenue, WCN $1,929 $2,079 $2,117 $3,376 $2,607 <-12 mths 3.32%
Adjusted EBITDA (All WCN) $657 $717 $711 $1,461 $1,460 $1,674 $1,566 $1,919 $1,662 $2,221 $2,523 $2,888 $3,149 $3,439 284.02% <-Total Growth 10
Change 9.14% -0.90% 105.53% 0.00% 14.59% -6.40% 22.52% -13.40% 33.64% 13.60% 14.47% 9.04% 9.21%
Margin 34.06% 34.49% 33.56% 43.26% 31.54% 34.00% 29.07% 35.24% 27.02% 30.80% 31.45% 32.78% 33.28% 33.76%
Long Term Debt US$ $2,149 $3,618 $3,931 $4,196 $4,397 $4,737 $5,041 $6,890 $6,725 $7,795 Debt US$
Change 68.36% 8.64% 6.75% 4.77% 7.74% 6.40% 36.70% -2.40% 15.92% 7.25% <-Median-> 8 Change US$
Ratio to Market Cap 0.84 0.26 0.21 0.21 0.18 0.18 0.14 0.20 0.17 0.17 0.20 <-Median-> 8 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 10.61 11.70 13.60 <-Median-> 8 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.16 3.28 3.31 <-Median-> 8 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 $8,894 $10,697 Debt CDN$
Change 63.24% 1.50% 16.09% -0.25% 5.62% 5.95% 46.03% -4.69% 20.27% 5.79% <-Median-> 8 Change CDN$
Ratio to Market Cap 0.84 0.26 0.21 0.21 0.18 0.18 0.14 0.20 0.17 0.17 0.20 <-Median-> 8 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 10.61 11.70 13.60 <-Median-> 8 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.16 3.28 3.31 <-Median-> 8 Debt to Cash Flow (Years) CDN$
Intangibles US$ $774 $929 $905 $937 $887 $1,067 $1,087 $1,129 $1,163 $1,155 $1,351 $1,674 $1,604 $1,877 77.12% <-Total Growth 10 Intangibles US$
Goodwill $258 $288 $220 $166 $177 $4,390 $4,682 $5,032 $5,516 $5,727 $6,188 $6,902 $7,404 $7,597 3264.44% <-Total Growth 10 Goodwill US$
Goodwill and Intangibles US$ $1,032 $1,217 $1,125 $1,103 $1,064 $5,457 $5,769 $6,160 $6,679 $6,882 $7,538 $8,576 $9,008 $9,474 700.40% <-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% 5.03% 5.18% 6.25% <-Median-> 10 Change US$
Intangible/Market Cap Ratio 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.23 0.21 Intangible/Market Cap Ratio US$
Intangibles CDN$ $791 $928 $963 $1,087 $1,228 $1,433 $1,364 $1,540 $1,511 $1,471 $1,712 $2,267 $2,121 $2,576 120.25% <-Total Growth 10 Intangibles CDN$
Goodwill $263 $287 $234 $192 $245 $5,895 $5,873 $6,864 $7,165 $7,291 $7,845 $9,348 $9,793 $10,426 4083.73% <-Total Growth 10 Goodwill CDN$
Goodwill and Intangibles CDN$ $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,914 $13,002 895.31% <-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% 2.57% 9.13% 8.00% <-Median-> 10 Change CDN$
Intangible/Market Cap Ratio 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.23 0.21 0.29 <-Median-> 10 Intangible/Market Cap Ratio CDN$
Current Assets US$ $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,141.79 $1,217.05 278.50% <-Total Growth 10 Current Assets US$
Current Liabilities $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,687.93 $1,631.54 459.00% <-Total Growth 10 Current Liabilities US$
Liquidity 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.68 0.75 1.02 <-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 $26.462 $16.096
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.69 0.75 0.84 <-Median-> 5 Liquidity Less CLTD
Assets US$ $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,916 $19,083 428.09% <-Total Growth 10 Assets US$
Liabilities $1,784 $2,203 $2,103 $2,148 $2,116 $5,538 $5,741 $6,167 $6,799 $7,129 $7,706 $10,021 $10,218 $11,292 385.88% <-Total Growth 10 Liabilities US$
Debt Ratio 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.75 1.69 1.94 <-Median-> 10 Ratio US$
Estimates BVPS $32.00 $34.10 $35.50 Estimates Estimates BVPS
Estimate Book Value $8,254.8 $8,796.5 $9,157.6 Estimates Estimate Book Value
P/B Ratio (Close) 5.41 5.07 4.87 Estimates P/B Ratio (Close)
Difference from 10 year median 87.14% Diff M/C Estimates Difference from 10 yr med.
Total Book Value $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,697.8 $7,791.0 496.93% <-Total Growth 10 Book Value US$
Non-Con Int US$ $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 $4.05 Non-Con Int US$ US$
Book Value US$ $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,692.8 $7,786.9 $7,786.9 $7,786.9 496.54% <-Total Growth 10 Book Value US$
Book Value per Share $22.75 $22.98 $23.32 $22.76 $14.36 $21.49 $23.79 $24.53 $26.30 $26.10 $26.86 $27.64 $29.86 $30.19 $30.19 $30.19 28.07% <-Total Growth 10 Book Value per Share US$
Increase -19.21% 1.02% 1.46% -2.38% -36.90% 49.60% 10.71% 3.10% 7.23% -0.77% 2.91% 2.93% 8.03% 1.08% 0.00% 0.00% 98.38% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 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.63 5.28 5.28 5.28 1.62 P/B Ratio Historical Median US$
P/B Ratio (Close) 1.19 1.30 1.47 1.83 2.27 2.44 2.98 3.03 3.45 3.93 5.07 4.80 5.00 5.73 5.73 5.73 2.41% <-IRR #YR-> 10 Book Value per Share US$
Change -0.21% 9.15% 12.94% 24.50% 24.07% 7.41% 22.30% 1.51% 14.04% 13.85% 29.09% -5.49% 4.24% 14.69% 0.00% 0.00% 4.01% <-IRR #YR-> 5 Book Value per Share US$
Leverage (A/BK) 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.33 2.45 2.07 <-Median-> 10 A/BV US$
Debt/Equity Ratio 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.33 1.45 1.07 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 2.89 5 yr Med 4.39 98.38% Diff M/C
-$22.98 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.86
-$24.53 $0.00 $0.00 $0.00 $0.00 $29.86
Current Assets CDN$ $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,510.12 $1,670.16 370.67% <-Total Growth 10 Current Assets CDN$
Current Liabilities $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 $2,232.46 $2,238.96 595.12% <-Total Growth 10 Current Liabilities CDN$
Liquidity 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.68 0.75 1.02 <-Median-> 10 Ratio CDN$
Liq. with CF aft div 2.14 2.05 2.43 2.20 2.22 2.16 2.78 2.73 2.48 2.54 2.04 1.92 1.78 2.02 2.04 <-Median-> 5 Ratio CDN$
Liq. CF re  Inv+Div  1.05 0.75 1.30 1.17 1.09 1.51 1.26 1.05 1.03 1.26 0.86 0.63 0.92 2.02 0.92 <-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 $35.00 $22.09
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.69 0.75 0.84 <-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 1.80 2.04 2.05 <-Median-> 5 Ratio CDN$
Assets CDN$ $3,143 $3,470 $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 $23,696 $26,187 556.69% <-Total Growth 10 Assets CDN$
Liabilities $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,514 $15,496 504.20% <-Total Growth 10 Liabilities CDN$
Debt Ratio 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.75 1.69 1.94 <-Median-> 10 Ratio CDN$
Estimates BVPS $43.91 $46.80 $48.72 Estimates Estimates BVPS
Estimate Book Value $11,328.0 $12,071.4 $12,567.0 Estimates Estimate Book Value
P/B Ratio (Close) 5.41 5.07 4.87 Estimates P/B Ratio (Close)
Difference from 10 year median 75.69% 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 $10,181.1 $10,691.5
Total Book Value $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 $10,181.1 $10,691.5 642.28% <-Total Growth 10 Book Value CDN$
Non-Con Int CDN$ $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.58 $5.55 CDN$
Book Value CDN$ $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 $10,174.5 $10,686.0 $10,686.0 $10,686.0 641.81% <-Total Growth 10 Book Value CDN$
Book Value per Share $23.24 $22.94 $24.80 $26.41 $19.89 $28.85 $29.85 $33.46 $34.16 $33.23 $34.05 $37.44 $39.50 $41.42 $41.42 $41.42 59.25% <-Total Growth 10 Book Value per Share CDN$
Increase -17.24% -1.26% 8.09% 6.48% -24.68% 45.06% 3.44% 12.12% 2.08% -2.73% 2.48% 9.96% 5.49% 4.88% 0.00% 0.00% 86.24% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 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.70 5.18 0.00 0.00 1.63 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 1.19 1.30 1.47 1.83 2.27 2.43 2.99 3.03 3.45 3.93 5.06 4.79 5.01 5.73 5.73 5.73 5.06% <-IRR #YR-> 10 Book Value per Share 59.25% CDN$
Change -0.45% 9.15% 13.14% 24.88% 23.90% 7.26% 22.74% 1.36% 14.02% 13.76% 28.89% -5.32% 4.50% 14.42% 0.00% 0.00% 3.37% <-IRR #YR-> 5 Book Value per Share 18.03% CDN$
Leverage (A/BK) 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.33 2.45 2.07 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 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.33 1.45 1.07 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.08 5 yr Med 4.38 86.24% Diff M/C
-$22.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $39.50
-$33.46 $0.00 $0.00 $0.00 $0.00 $39.50
$792.78 <-12 mths -2.10%
Comprehensive Income US$ -$213.25 $107.99 $84.20 $85.16 $50.45 $216.49 $728.83 $363.96 $630.50 $214.30 $658.72 $739.59 $809.83 861.85% <-Total Growth 10 Comprehensive Income US$
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 $0.03 #DIV/0! <-Total Growth 10 Comprehensive Income US$
Shareholders -$213.25 $107.99 $84.20 $85.16 $50.45 $215.71 $728.23 $363.67 $630.66 $214.99 $658.28 $739.25 $809.80 861.82% <-Total Growth 10 Comprehensive Income US$
Increase -293.55% 150.64% -22.04% 1.15% -40.76% 327.57% 237.60% -50.06% 73.42% -65.91% 206.19% 12.30% 9.54% 12.3% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $11.90 $46.49 $32.04 $34.86 $22.91 $108.70 $232.75 $288.64 $397.75 $430.65 $519.17 $521.37 $610.60 25.40% <-IRR #YR-> 10 Comprehensive Income 861.82% US$
ROE US$ -16.5% 8.5% 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 10.5% 17.36% <-IRR #YR-> 5 Comprehensive Income 122.67% US$
5Yr Median 6.7% 7.0% 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 9.4% 34.28% <-IRR #YR-> 10 5 Yr Running Average 1805.65% US$
% Difference from NI -8.72% 14.45% -28.63% -32.69% -59.27% -12.34% 26.14% -33.56% 11.18% 4.97% 6.44% -11.60% 6.09% 16.17% <-IRR #YR-> 5 5 Yr Running Average 111.54% US$
Median Values Diff 5, 10 yr -3.3% 6.1% 9.4% <-Median-> 5 Return on Equity US$
-$84.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $809.8
-$363.7 $0.0 $0.0 $0.0 $0.0 $809.8
-$32.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $610.6
-$288.6 $0.0 $0.0 $0.0 $0.0 $610.6
Current Liability Coverage Ratio US$ 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.25 1.45   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.36 1.36 1.36 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 13.93% 11.86% 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 11.80% 12.44% CFO / Total Assets US$
5 year Median 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.42% 11.4% <-Median-> 5 Return on Assets  US$
Return on Assets ROA US$ -6.37% 2.71% 3.48% 3.75% 3.82% 2.20% 4.80% 4.33% 4.13% 1.46% 4.20% 4.88% 4.26% 5.70% Net  Income/Assets Return on Assets US$
5Yr Median 1.99% 2.19% 2.36% 2.71% 3.48% 3.48% 3.75% 3.82% 4.13% 4.13% 4.20% 4.20% 4.20% 4.26% 4.2% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ -15.17% 7.41% 9.15% 10.30% 10.97% 4.35% 9.20% 8.47% 8.18% 2.98% 8.84% 11.76% 9.92% 13.97% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 5.04% 5.99% 5.99% 7.41% 9.15% 9.15% 9.20% 9.20% 8.47% 8.18% 8.47% 8.47% 8.84% 9.92% 8.8% <-Median-> 5 Return on Equity US$
Adjusted Net Income $135.00 $113.19 $127.15 $153.08 -$6.89 $395.20 $570.67 $667.3 $719.56 $695.79 $846.60 $985.27 $1,081.25 62.03% <-Total Growth 7 Net Income US$
$795.04 <-12 mths 4.23%
Net Income US$ -$196.14 $94.36 $117.97 $126.52 $123.88 $246.54 $577.42 $547.15 $566.68 $203.99 $618.49 $836.00 $762.83 546.63% <-Total Growth 10 Net Income US$ US$
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 $0.03 #DIV/0! <-Total Growth 10 NCI US$
Shareholders -$196.14 $94.36 $117.97 $126.52 $123.88 $245.76 $576.82 $546.87 $566.84 $204.68 $618.05 $835.66 $762.80 $1,088 $1,239 $1,410 546.61% <-Total Growth 10 Net Income US$
Increase -364.67% -148.11% 25.03% 7.24% -2.09% 98.39% 134.71% -5.19% 3.65% -63.89% 201.96% 35.21% -8.72% 42.63% 13.88% 13.80% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average -$1.0 $11.5 $27.5 $43.4 $53.3 $141.7 $238.2 $324.0 $412.0 $428.2 $502.7 $554.4 $597.6 $701.8 $908.7 $1,067.1 20.52% <-IRR #YR-> 10 Net Income 546.61% US$
Operating Cash Flow $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 $2,126.82 6.88% <-IRR #YR-> 5 Net Income 39.48% US$
Investment Cash Flow -$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 -$1,581.08 36.07% <-IRR #YR-> 10 5 Yr Running Average 2075.33% US$
Accruals   -$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 $217.06 13.03% <-IRR #YR-> 5 5 Yr Running Average 84.46% US$
Total Assets $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,916 Balance Sheet Assets US$
Accruals Ratio -9.12% 8.29% -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 1.21% 3.29% <-Median-> 5 Ratio US$
-$118.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $762.8
-$546.9 $0.0 $0.0 $0.0 $0.0 $762.8
-$27.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $597.6
-$324.0 $0.0 $0.0 $0.0 $0.0 $597.6
Financial Cash Flow US$ -$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 -$544.41 C F Statement  Financial Cash Flow US$
Accruals   -$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 $761.47 Accruals US$
Accruals Ratio -6.36% 2.26% 3.32% 1.78% 3.66% 0.91% 2.49% 5.50% 3.99% -0.57% 7.57% 5.09% 4.25% 4.25% <-Median-> 5 Ratio US$
$1,087.93 <-12 mths 1.58%
Comprehensive Inc CDN$ -$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 $1,071.08 1096.07% <-Total Growth 10 Comprehensive Income CDN$
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46 $0.03 #DIV/0! <-Total Growth 10 NCI CDN$
Shareholders -$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 $1,071.05 1096.03% <-Total Growth 10 Comprehensive Income CDN$
Increase -298.28% 149.50% -16.94% 10.32% -29.29% 314.59% 215.42% -45.69% 65.10% -66.58% 204.89% 19.97% 6.97% 19.97% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $18.82 $53.21 $32.81 $37.64 $29.64 $131.13 $292.28 $373.60 $517.66 $558.43 $667.42 $684.95 $799.94 28.17% <-IRR #YR-> 10 Comprehensive Income 1096.03% CDN$
ROE CDN$ -16.5% 8.5% 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 10.5% 16.64% <-IRR #YR-> 5 Comprehensive Income 115.88% CDN$
5Yr Median 6.7% 7.0% 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 9.4% 37.63% <-IRR #YR-> 10 5 Yr Running Average 2337.88% CDN$
% Difference from NI 8.7% 14.5% -28.6% -32.7% -59.3% -12.3% 26.1% -33.6% 11.2% 5.0% 6.4% -11.6% 6.1% 16.45% <-IRR #YR-> 5 5 Yr Running Average 114.12% CDN$
Median Values Diff 5, 10 yr -3.3% 6.1% 9.41% <-Median-> 5 Return on Equity CDN$
-$89.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,071.05
-$496.12 $0.00 $0.00 $0.00 $0.00 $1,071.05
-$32.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $799.94
-$373.60 $0.00 $0.00 $0.00 $0.00 $799.94
Current Liability Coverage Ratio CDN$ 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.25 1.45   CFO / Current Liabilities CDN$
5 year Median 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.36 1.36 1.36 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 13.93% 11.86% 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 11.80% 12.44% CFO / Total Assets CDN$
5 year Median 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.42% 11.4% <-Median-> 5 Return on Assets  CDN$
Comments -14.9%
Comments -196.136
Return on Assets ROA CDN$ -6.4% 2.7% 3.5% 3.7% 3.8% 2.2% 4.8% 4.3% 4.1% 1.5% 4.2% 4.9% 4.3% 5.7% Net  Income/Assets Return on Assets CDN$
5Yr Median 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.3% 4.2% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ -15.2% 7.4% 9.1% 10.3% 11.0% 4.4% 9.2% 8.5% 8.2% 3.0% 8.8% 11.8% 9.9% 14.0% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 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% 9.9% 8.8% <-Median-> 5 Return on Equity CDN$
$1,091.03 <-12 mths 8.14%
Net Income CDN$ -$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 $1,008.91
NCI $0.00 $0.00 $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46 $0.03
Shareholders -$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,008.88 $1,493 $1,700 $1,935 704.06% <-Total Growth 10 Net Income CDN$
Increase -371.13% -147.02% 33.20% 16.97% 16.87% 92.37% 119.29% 3.10% -1.32% -64.60% 200.68% 44.45% -10.86% 47.99% 13.88% 13.80% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $0.3 $12.8 $28.5 $48.0 $67.5 $173.6 $299.5 $423.6 $541.5 $559.3 $650.0 $731.6 $784.2 $935.6 $1,223.5 $1,453.8 23.18% <-IRR #YR-> 10 Net Income 704.06% CDN$
Operating Cash Flow $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 $2,812.93 6.22% <-IRR #YR-> 5 Net Income 35.23% CDN$
Investment Cash Flow -$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 -$2,091.14 39.29% <-IRR #YR-> 10 5 Yr Running Average 2648.60% CDN$
Accruals   -$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 $287.09 13.11% <-IRR #YR-> 5 5 Yr Running Average 85.14% CDN$
Total Assets $3,143 $3,470 $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 $23,696 Balance Sheet Assets CDN$
Accruals Ratio -9.12% 8.29% -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 1.21% 3.29% <-Median-> 5 Ratio CDN$
EPS/CF Ratio -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.36 0.37 <-Median-> 10 EPS/CF Ratio CDN$
-$125.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,008.9
-$746.0 $0.0 $0.0 $0.0 $0.0 $1,008.9
-$28.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $784.2
-$423.6 $0.0 $0.0 $0.0 $0.0 $784.2
Change in Close -17.61% 7.78% 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 10.24% 20.00% 0.00% 0.00% Count 23 Years of data CDN$
up/down down Up down down Count 9 39.13% CDN$
Meet Prediction? % right Count 1 11.11% CDN$
Financial Cash Flow CDN$ -$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 -$720.03 C F Statement  Financial CF CDN$
Accruals   -$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 $1,007.12 Accruals CDN$
Accruals Ratio -6.36% 2.26% 3.32% 1.78% 3.66% 0.91% 2.49% 5.50% 3.99% -0.57% 7.57% 5.09% 4.25% 4.25% <-Median-> 5 Ratio CDN$
Cash US$ $14.14 $29.94 $31.98 $41.64 $35.78 $154.38 $433.82 $403.97 $423.22 $423.22 $219.62 $181.36 $184.04 $217.67 Cash US$
Cash CDN$ $14.44 $29.89 $34.01 $48.30 $49.55 $207.29 $544.22 $551.09 $549.68 $538.84 $278.43 $245.64 $243.41 $298.71 Cash CDN$
Cash per Share CDN$ $0.25 $0.54 $0.62 $0.89 $0.63 $0.79 $2.07 $2.09 $2.09 $2.05 $1.07 $0.96 $0.94 $1.16 $1.07 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 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.48% 0.49% 0.62% <-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 <-Median-> 10 Special Dividends US$
Pre-split 2017 $0.32 $0.37 $0.42 $0.48 $0.18 $0.62
Split in June 2017 $0.12
Dividend US$ $0.21 $0.25 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.14 279.52% <-Total Growth 10 Dividends US$
Increase 320.00% 17.46% 12.16% 14.46% -61.26% 234.24% 21.95% 16.00% 14.66% 14.29% 11.18% 11.83% 11.11% 8.57% Count 16 Years of data US$
Dividends 5 Yr Running $0.08 $0.12 $0.17 $0.22 $0.23 $0.27 $0.33 $0.39 $0.46 $0.58 $0.67 $0.76 $0.85 $0.95 263.70% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 0.69% 0.88% 0.85% 0.86% 0.34% 0.96% 0.80% 0.79% 0.79% 1.04% 0.72% 0.69% 0.76% 0.79% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 0.59% 0.78% 0.74% 0.74% 0.29% 0.78% 0.69% 0.72% 0.70% 0.73% 0.61% 0.65% 0.70% 0.70% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 0.82% 1.01% 0.99% 1.02% 0.42% 1.26% 0.95% 0.88% 0.90% 1.83% 0.87% 0.74% 0.82% 0.89% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 0.77% 0.82% 0.81% 0.76% 0.38% 0.78% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.70% 0.66% 0.72% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS -6.72% 15.89% 14.15% 15.02% 5.71% 38.44% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 30.12% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 59.18% 57.36% 50.64% 39.90% 13.22% 23.22% 26.43% 30.30% 34.62% 46.14% 44.33% 44.62% 45.77% 37.26% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 3.02% 4.06% 3.39% 3.79% 2.32% 13.55% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.72% 11.70% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 3.17% 3.94% 4.23% 4.58% 1.76% 6.64% 8.53% 10.93% 13.84% 15.77% 15.31% 15.26% 15.51% 12.39% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 2.78% 3.31% 3.45% 3.59% 2.41% 12.97% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.80% 12.02% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 3.08% 3.67% 4.03% 4.26% 1.66% 6.30% 8.37% 10.71% 13.85% 15.59% 15.27% 15.51% 15.70% 12.28% <-Median-> 10 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.76% 0.71% 5 Yr Med Payout 35.59% 12.72% 12.80% 12.60% <-IRR #YR-> 5 Dividends US$
* Dividends per share  10 Yr Med and Cur. -100.00% -100.00% 5 Yr Med and Cur. -100.00% -100.00% Last Div Inc ---> $0.185 $0.205 10.81% 14.27% <-IRR #YR-> 10 Dividends US$
Dividends Growth 15 13.60% <-IRR #YR-> 13 Dividends
Dividends Growth 5 -$0.58 $0.00 $0.00 $0.00 $0.00 $1.05
Dividends Growth 10 -$0.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.05
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.05
P/E 5.77% <-IRR #YR-> 10 Stock Price 413.19% US$
Trailing P/E 15.85% <-IRR #YR-> 5 Price & Dividend US$
Median 10, 5 Yrs D.  per yr 0.71% 0.86% % Tot Ret 11.01% 5.42% T P/E #NUM! P/E:  #NUM! #NUM! 6.49% <-IRR #YR-> 10 Price & Dividend US$
Price  15 17.07% <-IRR #YR-> 15 Stock Price
Price  20 16.07% <-IRR #YR-> 18 Stock Price
Price & Dividend 15 17.92% <-IRR #YR-> 15 Price & Dividend
Price & Dividend 20 16.80% <-IRR #YR-> 18 Price & Dividend
Price 5 -$74.25 $0.00 $0.00 $0.00 $0.00 $149.27
Price 10 -$29.09 $0.00 $0.00 $0.00 $0.00 -$74.25 $0.00 $0.00 $0.00 $0.00 $149.27
Price & Dividend 5 -$74.25 $0.67 $0.76 $0.85 $0.95 $150.32
Price & Dividend 10 -$29.09 $0.32 $0.12 $0.41 $0.50 -$74.25 $0.67 $0.76 $0.85 $0.95 $150.32
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 $149.27
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 $149.27
Price & Dividend 15 $0.21 $0.25 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $150.32
Price & Dividend 20 $0.21 $0.25 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $150.32
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 14, 2024.  Last estimates were for 2023, 2024 and 2025 of $8079, $8676M, $9396M US$ Revenue, $4.22, $4.77, $5.38 US$ AEPS, $3.74, $4.30, $4.73 US$ EPS, 
$1.06, $1.15 and $1.28 US$ Dividends, $1224M, $1372M, $1533M US$ FCF, $8.36, $9.05, $9.67 CFPS, $29.70, $31.30, $32.40 US$ BVPS, $956M, $1088M, $1160M US$ Net Income.
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 an integrated solid waste services company that provides non-hazardous waste collection, transfer, disposal and recycling services across 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 %, 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 2016 Jun 02 2016 Jun 11 2018 Jun 14 2019 Jun 13 2020 Jun 13 2021 Jun 12 2022 Jun 12 2023 Jun 14 2024
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%
CEO - Shares - Amount $4.568 $10.913 $13.795 $14.780 $21.189 $23.112
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%
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% 0.065 0.03% 15.67%
CFO - Shares - Amount $4.595 $5.716 $8.156 $8.980 $11.152 $15.481
Options - percentage 0.018 0.01% 0.020 0.01% 0.027 0.01% 0.030 0.01% 0.030 0.01% 0.026 0.01% -13.84%
Options - amount $2.096 $2.565 $4.606 $5.381 $5.902 $6.102
Chambkiss, Darrell W. 0.099 0.04% 0.097 0.04% 0.099 0.04% 2.53%
Officer - Shares - Amount $17.825 $19.117 $23.521
Options - percentage 0.034 0.01% 0.032 0.01% 0.035 0.01% 11.20%
Options - amount $6.112 $6.294 $8.398
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% 0.033 0.01% 5.66%
Officer - Shares - Amount $1.335 $2.291 $3.192 $3.933 $5.578 $6.249 $6.256 $7.932
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% 0.021 0.01% 15.31%
Options - amount $1.101 $1.843 $2.098 $2.124 $3.131 $3.271 $3.651 $5.052
Little, James M. 0.029 0.01% 0.028 0.01% -4.06%
Officer - Shares - Amount $5.819 $6.699
Options - percentage 0.162 0.06% 0.028 0.01% -82.50%
Options - amount $31.983 $6.717
Guillet, Edward E.  0.061 0.02% 0.042 0.02% 0.032 0.01% 0.033 0.01% 0.033 0.01% 0.000 0.00% -100.00%
Director - Shares - Amount $7.218 $5.451 $5.576 $5.895 $6.580 $0.000
Options - percentage 0.003 0.00% 0.003 0.00% 0.004 0.00% 0.004 0.00% 0.004 0.00% 0.000 0.00% -100.00%
Options - amount $0.318 $0.391 $0.606 $0.674 $0.830 $0.000
Harlan, Michael W. 0.009 0.00% 0.008 0.00% -10.27%
Director - Shares - Amount $1.763 $1.899
Options - percentage 0.004 0.00% 0.005 0.00% 8.17%
Options - amount $0.830 $1.078
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% 0.223 0.09% Was Chair & CEO in 2019 1.08%
Chair & CEO - Shares - Amount $11.930 $10.180 $16.409 $25.011 $32.791 $36.883 $43.598 $52.887 President in 2019
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% 0.073 0.03% Mittelstraedt Chair, CEO '22 40.64%
Options - amount $17.762 $42.061 $32.335 $23.009 $16.597 $10.799 $10.202 $17.220 CEO again in 2023
Increase in O/S Shares 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% 0.606 0.24%
due to SO 2013 $2.257 $39.785 $61.645 $65.097 $72.342 $89.021 $89.172 $71.081 $119.905
Book Value $0.265 $36.249 $23.701 $2.667 $39.000 $39.762 $48.710 $62.952 $71.217
Insider Buying -$0.489 -$0.150 -$0.206 $0.000 $0.000 $0.000 $0.000 -$0.020 $0.004
Insider Selling $0.160 $3.039 $17.895 $4.023 $15.515 $22.133 $4.704 $6.658 $6.928
Net Insider Selling 2013 -$0.329 $2.889 $17.689 $4.023 $15.515 $22.133 $4.704 $6.639 $6.932
% of Market Cap 0.00% 0.01% 0.07% 0.01% 0.05% 0.05% 0.01% 0.01% 0.01%
On May 28 2014
Increase in O/S Shares 0.07%
due to RS 2013 $2.618
Book Value
Increase in O/S Shares 0.14%
Total Increase 2013 $4.875
Book Value
Directors  7 7 6 8 8 8 8 8
Women 14% 1 14% 1 14% 1 17% 2 25% 2 25% 2 25% 3 38% 3 38% Company says they have
Minorities 14% 0 0% 0 0% 0 0% 0 0% 0 0% 1 13% 1 13% 1 13% a visible minority on the board
I cannot find one.
Institutions/Holdings 78.70% 214 89.83% 590 90.93% 669 93.04% 20 76.12% 20 76.12% 20 52.67% 20 64.30%
Total Shares Held 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% 165.872 63.74%
Increase/Decrease -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% -3.935 -2.32%
Starting No. of Shares 159.011 238.550 243.726 190.519 190.519 141.046 169.807
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock