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. Estimates Estimates Estimates
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Q1 2026
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/ 3/31/26
Waste Connections Inc TSX: WCN NYSE: WCN https://investors.wasteconnections.com/ Fiscal Yr: Dec 31
Year 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27 12/31/28 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.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2732 1.2678 1.3544 1.3226 1.4389 1.3706 1.4162 1.4162 1.4162 -1.02% <-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
$9,609.4 <-12 mths 1.50%
Revenue* 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,919.6 $9,466.9 $9,999 $10,601 $11,210 391.64% <-Total Growth 10 Revenue US$
Increase 6.82% -0.84% -4.15% 75.32% 37.16% 6.32% 9.46% 1.06% 12.95% 17.24% 11.23% 11.19% 6.14% 5.62% 6.02% 5.74% 17.26% <-IRR #YR-> 10 Revenue 391.64% US$
5 year Running Average $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,150.2 $7,954.3 $8,723.9 $9,401.7 $10,039.3 11.69% <-IRR #YR-> 5 Revenue 73.83% US$
Revenue per Share $36.64 $37.22 $24.50 $12.85 $17.57 $18.71 $20.44 $20.72 $23.64 $28.05 $31.14 $34.57 $37.04 $39.33 $41.69 $44.09 15.16% <-IRR #YR-> 10 5 yr Running Average 310.12% US$
Increase 6.95% 1.59% -34.16% -47.57% 36.80% 6.46% 9.26% 1.37% 14.09% 18.64% 11.04% 11.01% 7.13% 6.18% 6.02% 5.74% 10.85% <-IRR #YR-> 5 5 yr Running Average 67.36% US$
5 year Running Average $30.63 $32.99 $33.00 $29.09 $25.75 $22.17 $18.81 $18.06 $20.22 $22.31 $24.80 $27.62 $30.89 $34.02 $36.75 $39.34 4.22% <-IRR #YR-> 10 Revenue per Share 51.15% US$
P/S (Price/Sales) Med 0.89 0.99 1.46 3.31 3.55 3.91 4.13 3.53 4.99 4.86 4.44 4.91 4.93 4.11 3.88 3.66 12.32% <-IRR #YR-> 5 Revenue per Share 78.74% US$
P/S (Price/Sales) Close 0.94 1.12 1.33 4.08 4.04 3.97 4.44 4.95 5.76 4.73 4.79 4.96 4.73 4.23 3.99 3.78 -0.66% <-IRR #YR-> 10 5 yr Running Average -6.40% US$
*Revenue in M CDN $  P/S Med 20 yr  2.39 15 yr  3.55 10 yr  4.29 5 yr  4.91 -1.27% Diff M/C 11.33% <-IRR #YR-> 5 5 yr Running Average 71.04% US$
$13,608.8 <-12 mths 4.88%
Revenue* CDN $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,834.4 $12,975.4 $14,161 $15,013 $15,876 386.62% <-Total Growth 10 Revenue CDN$
Increase 13.80% 8.16% 14.41% 69.99% 28.15% 15.61% 4.21% -0.93% 12.47% 25.25% 8.62% 20.97% 1.10% 9.13% 6.02% 5.74% 17.14% <-IRR #YR-> 10 Revenue 386.62% CDN$
5 year Running Average $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,588.9 $10,797.2 $12,069.6 $13,118.7 $14,171.8 13.35% <-IRR #YR-> 5 Revenue 87.13% CDN$
Revenue per Share $38.97 $43.18 $33.93 $17.25 $22.05 $25.52 $26.55 $26.38 $29.97 $37.99 $41.19 $49.74 $50.76 $55.69 $59.05 $62.44 17.32% <-IRR #YR-> 10 5 yr Running Average 394.16% CDN$
Increase 13.94% 10.80% -21.41% -49.17% 27.82% 15.77% 4.02% -0.63% 13.60% 26.74% 8.43% 20.77% 2.05% 9.72% 6.02% 5.74% 11.74% <-IRR #YR-> 5 5 yr Running Average 74.20% CDN$
5 year Running Average $31.46 $34.76 $36.67 $33.50 $31.07 $28.38 $25.06 $23.55 $26.09 $29.28 $32.41 $37.05 $41.93 $47.07 $51.29 $55.54 4.11% <-IRR #YR-> 10 Revenue per Share 49.61% CDN$
P/S (Price/Sales) Med 0.87 0.97 1.38 3.42 3.67 3.71 4.28 4.56 4.98 4.53 4.51 4.70 5.06 4.00 0.00 0.00 13.98% <-IRR #YR-> 5 Revenue per Share 92.41% CDN$
P/S (Price/Sales) Close 0.93 1.12 1.33 4.07 4.04 3.97 4.44 4.95 5.75 4.72 4.80 4.96 4.74 4.25 4.01 3.79 1.35% <-IRR #YR-> 10 5 yr Running Average 14.35% CDN$
*Revenue in M CDN $  P/S Med 10 yr  4.52 5 yr  4.70 -5.97% Diff M/C 12.23% <-IRR #YR-> 5 5 yr Running Average 78.05% CDN$
-$2,666.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $12,975.4
-$6,933.8 $0.0 $0.0 $0.0 $0.0 $12,975.4
-$2,185.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $10,797.2
-$6,198.0 $0.0 $0.0 $0.0 $0.0 $10,797.2
$1,350.1 <-12 mths 1.64%
$5.25 <-12 mths 1.94%
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 $1,239.3 $1,328.3 442.41% <-Total Growth 10 Earnings per Share
Calculated EPS $2.66 $3.07 $3.07 $1.71 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $4.79 $5.15
Adjusted Net Income per Share* US$$ $1.79 $2.04 $1.98 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $4.79 $5.15 $5.50 $6.19 $6.92 160.10% <-Total Growth 10 Earnings per Share US$
Increase 33.28% 13.97% -2.94% -13.34% 26.13% 16.44% 7.94% -2.94% 22.35% 18.27% 9.69% 14.32% 7.52% 6.80% 12.55% 11.79% 10 0 10 Years of Data, EPS P or N 100.00% US$
Earnings Yield 5.2% 4.9% 6.1% 3.3% 3.1% 3.4% 3.0% 2.6% 2.4% 2.9% 2.8% 2.8% 2.9% 3.3% 3.7% 4.2% 10.03% <-IRR #YR-> 10 Earnings per Share 160.10% US$
5 year Running Average $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.24 $4.69 $5.16 $5.71 14.30% <-IRR #YR-> 5 Earnings per Share 95.08% US$
Payout Ratio 19.96% 17.18% 16.05% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 25.06% 24.43% 25.15% 25.45% 22.62% 20.23% 9.30% <-IRR #YR-> 10 5 yr Running Average 138.81% US$
5 year Running Average 28.75% 22.04% 20.17% 21.48% 20.96% 21.63% 23.14% 25.60% 25.24% 25.42% 25.69% 25.55% 25.05% 24.99% 24.46% 23.35% 12.49% <-IRR #YR-> 5 5 yr Running Average 80.10% US$
Price/AFFO Median 18.21 18.08 18.11 24.79 28.81 29.00 31.06 27.68 36.50 35.71 33.01 35.44 35.46 29.38 26.10 23.35 32.03 <-Median-> 10 Price/AEPS Median US$
Price/AFFO High 20.85 21.02 21.36 30.61 33.35 31.98 34.90 39.65 42.81 38.08 35.63 40.25 38.83 31.66 28.13 25.16 36.85 <-Median-> 10 Price/AEPS High US$
Price/AFFO Low 15.57 15.15 14.87 18.97 24.28 26.03 27.21 15.71 30.20 33.34 30.39 30.63 32.10 27.09 24.07 21.53 28.71 <-Median-> 10 Price/AEPS Low US$
Price/AFFO Close 19.14 20.42 16.47 30.54 32.78 29.46 33.38 38.85 42.19 34.70 35.63 35.82 34.05 30.26 26.89 24.05 34.38 <-Median-> 10 Price/AEPS Close US$
Trailing P/AFFO Close 25.52 23.27 15.98 26.46 41.34 34.31 36.03 37.71 51.62 41.04 39.08 40.95 36.61 32.32 30.26 26.89 38.39 <-Median-> 10 Trailing P/AEPSClose US$
* ESP per share (US$) Historical   in order 27.68 34.90 23.62 32.33 P/CF 5 Yrs   in order 35.46 38.83 30.63 35.63 -14.66% Diff M/C -5.52% Diff M/C 10 DPR 75% to 95% best US$
$1,912.0 <-12 mths 5.02%
$7.44 <-12 mths 5.33%
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 $1,783.2 $1,820.6 436.87% <-Total Growth 10 Earnings per Share
Adjusted Net Income per Share* CDN$ $1.90 $2.37 $2.74 $2.30 $2.72 $3.44 $3.53 $3.36 $4.09 $5.17 $5.54 $6.89 $7.06 $7.79 $8.77 $9.80 157.44% <-Total Growth 10 Earnings per Share CDN$
Increase 42.00% 24.31% 15.85% -15.97% 17.85% 26.62% 2.76% -4.85% 21.83% 26.34% 7.11% 24.37% 2.41% 10.35% 12.55% 11.79% 10 0 10 Years of Data, EPS P or N 100.00% CDN$
Earnings Yield 5.2% 4.9% 6.1% 3.3% 3.0% 3.4% 3.0% 2.6% 2.4% 2.9% 2.8% 2.8% 2.9% 3.3% 3.7% 4.1% 9.92% <-IRR #YR-> 10 Earnings per Share 157.44% CDN$
5 year Running Average $1.43 $1.70 $1.99 $2.13 $2.41 $2.71 $2.95 $3.07 $3.43 $3.92 $4.34 $5.01 $5.75 $6.49 $7.21 $8.06 16.00% <-IRR #YR-> 5 Earnings per Share 110.00% CDN$
Payout Ratio 19.96% 17.18% 16.05% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 25.06% 24.43% 25.15% 25.45% 22.62% 20.23% 11.21% <-IRR #YR-> 10 5 yr Running Average 169.89% CDN$
5 year Running Average 28.80% 21.83% 19.76% 21.38% 21.05% 21.70% 23.09% 25.59% 25.21% 25.38% 25.67% 25.50% 25.03% 24.99% 24.45% 23.34% 13.38% <-IRR #YR-> 5 5 yr Running Average 87.36% CDN$
Price/FFO Median 17.81 17.66 17.02 25.64 29.78 27.52 32.18 35.78 36.44 33.29 33.53 33.92 36.37 28.57 0.00 0.00 33.41 <-Median-> 10 Price/AEPS Median CDN$
Price/FFO High 20.57 20.73 19.29 30.95 34.18 30.95 36.36 41.29 42.74 37.84 36.21 39.45 39.89 30.73 0.00 0.00 37.10 <-Median-> 10 Price/AEPS High CDN$
Price/FFO Low 15.05 14.59 14.75 20.33 25.37 24.09 28.00 30.28 30.14 28.74 30.86 28.39 32.85 26.41 0.00 0.00 28.57 <-Median-> 10 Price/AEPS Low CDN$
Price/FFO Close 19.10 20.44 16.46 30.48 32.84 29.48 33.39 38.83 42.10 34.69 35.70 35.78 34.10 30.41 27.02 24.17 34.40 <-Median-> 10 Price/AEPS Close CDN$
Trailing P/FFO Close 27.13 25.40 19.07 25.61 38.70 37.32 34.31 36.95 51.29 43.83 38.24 44.50 34.93 33.56 30.41 27.02 37.78 <-Median-> 10 Trailing P/AEPSClose CDN$
* ESP per share  Historical   in order 29.51 35.23 24.73 31.66 P/CF 5 Yrs   in order 33.92 39.45 30.14 35.70 -10.35% Diff M/C -8.98% Diff M/C 10 DPR 75% to 95% best CDN$
-$2.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.06
-$3.36 $0.00 $0.00 $0.00 $0.00 $7.06
-$1.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.75
-$3.07 $0.00 $0.00 $0.00 $0.00 $5.75
$4.10 <-12 mths -1.68%
Difference Basic and Diluted -38.45% -38.45% -38.45% 0.62% 0.46% 0.00% 0.47% 0.00% 0.42% 0.31% 0.34% 0.00% -253.39% 0.32% <-Median-> 0 Difference Basic and Diluted
Pre-Split 2016 $1.02 $1.10 $1.12
Pre-Split 2017 $2.12 $2.28 $2.33 $1.61
EPS Basic US$ $1.41 $1.52 $1.55 $1.07 $2.19 $2.07 $2.15 $0.78 $2.37 $3.25 $2.96 $2.39 $1.18 -23.90% <-Total Growth 10 EPS Basic US$
Pre-Split 2016 $1.02 $1.10 $1.12
Pre-Split 2017 $2.93 $3.16 $3.22 $1.60
EPS Diluted* $1.96 $2.11 $2.15 $1.07 $2.18 $2.07 $2.14 $0.78 $2.36 $3.24 $2.95 $2.39 $4.17 $4.64 $5.44 $6.10 94.23% <-Total Growth 10 EPS Diluted US$
Increase 25.93% 7.84% 1.82% -50.32% 104.38% -5.05% 3.38% -63.55% 202.56% 37.29% -8.95% -18.98% 74.48% 11.18% 17.34% 12.06% 10 0 10 Years of Data, EPS P or N 100.00% US$
Earnings Yield 5.4% 4.4% 4.8% 1.5% 2.4% 2.0% 1.8% 0.6% 1.4% 1.8% 1.5% 1.0% 1.7% 2.0% 2.3% 2.6% 6.86% <-IRR #YR-> 10 Earnings per Share 94.23% US$
5 year Running Average $0.55 $0.79 $0.93 $1.77 $1.89 $1.91 $1.92 $1.65 $1.91 $2.12 $2.29 $2.34 $3.02 $3.48 $3.92 $4.55 39.83% <-IRR #YR-> 5 Earnings per Share 434.62% US$
10 year Running Average $0.81 $0.89 $1.06 $1.06 $1.16 $1.23 $1.36 $1.29 $1.84 $2.00 $2.10 $2.13 $2.33 $2.69 $3.02 $3.42 12.53% <-IRR #YR-> 10 5 yr Running Average 225.72% US$
* Diluted ESP per share  E/P 10 Yrs 1.63% 5Yrs 1.49% 12.90% <-IRR #YR-> 5 5 yr Running Average 83.45% US$
$5.81 <-12 mths 1.59%
Difference Basic and Diluted -38.45% -38.45% -38.45% 0.62% 0.46% 0.00% 0.47% 0.00% 0.42% 0.31% 0.34% 0.00% -253.39% 0.32% <-Median-> 0 Difference Basic and Diluted
EPS Basic CDN$ $1.50 $1.77 $2.15 $1.44 $2.75 $2.82 $2.79 $0.99 $3.00 $4.40 $3.91 $3.44 $1.62 -24.68% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* $2.08 $2.45 $2.97 $1.43 $2.73 $2.82 $2.78 $0.99 $2.99 $4.39 $3.90 $3.44 $5.72 $6.57 $7.70 $8.63 92.24% <-Total Growth 10 EPS Diluted CDN$
Increase 34.16% 17.63% 21.53% -51.83% 90.95% 3.26% -1.57% -64.27% 201.28% 46.67% -11.09% -11.86% 66.20% 14.87% 17.34% 12.06% 10 0 10 Years of Data, EPS P or N 100.00% CDN$
Earnings Yield 5.7% 5.1% 6.6% 2.0% 3.1% 2.8% 2.4% 0.8% 1.7% 2.4% 2.0% 1.4% 2.4% 2.8% 3.3% 3.6% 6.75% <-IRR #YR-> 10 Earnings 92.24% CDN$
5 year Running Average $0.57 $0.87 $1.17 $2.10 $2.33 $2.48 $2.55 $2.15 $2.46 $2.80 $3.01 $3.14 $4.09 $4.80 $5.47 $6.41 41.91% <-IRR #YR-> 5 Earnings 475.51% CDN$
10 year Running Average $0.90 $0.98 $1.24 $1.25 $1.41 $1.52 $1.71 $1.66 $2.28 $2.56 $2.75 $2.85 $3.12 $3.63 $4.13 $4.71 13.31% <-IRR #YR-> 10 5 yr Running Average 248.88% CDN$
* Diluted ESP per share  E/P 10 Yrs 2.20% 5Yrs 1.97% 13.68% <-IRR #YR-> 5 5 yr Running Average 89.87% CDN$
-$2.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.72
-$0.99 $0.00 $0.00 $0.00 $0.00 $5.72
-$1.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.09
-$2.15 $0.00 $0.00 $0.00 $0.00 $4.09
Dividend US$, Pd US$ from 2017 $1.39 $1.55 $1.70 Estimates Dividend US$, Pd US$ fr 2017
Increase 7.64% 11.26% 9.67% Estimates Increase
Payout Ratio EPS 30.07% 28.51% 27.90% 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.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $1.30 $1.40 $1.40 $1.40 307.56% <-Total Growth 10 Dividends US$
Increase -4.46% -1.88% -9.36% 59.06% -1.07% 16.00% 14.66% 14.29% 11.18% 11.83% 11.11% 11.43% 10.68% 8.11% 0.00% 0.00% 16 7 23 Years of data, Count P, N 69.57% US$
Average Increases 5 Year Running -15.34% -7.47% -0.84% 9.69% 8.46% 12.55% 15.86% 20.59% 11.01% 13.59% 12.61% 11.97% 11.25% 10.63% 8.27% 6.04% 12.26% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $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.06 $1.17 $1.26 $1.33 202.23% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 1.10% 0.95% 0.89% 1.19% 0.80% 0.79% 0.79% 1.04% 0.72% 0.69% 0.76% 0.69% 0.71% 0.87% 0.77% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 0.96% 0.82% 0.75% 0.96% 0.69% 0.72% 0.70% 0.73% 0.61% 0.65% 0.70% 0.61% 0.65% 0.80% 0.70% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 1.28% 1.13% 1.08% 1.55% 0.95% 0.88% 0.90% 1.83% 0.87% 0.74% 0.82% 0.80% 0.78% 0.94% 0.88% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 1.04% 0.84% 0.97% 0.96% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.70% 0.68% 0.74% 0.84% 0.84% 0.84% 0.72% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 48.95% 31.06% 30.20% 25.74% 22.97% 33.33% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 73.33% 44.65% 37.84% 21.57% 21.47% 23.54% 26.74% 36.55% 35.15% 35.84% 37.18% 40.70% 35.11% 33.71% 32.24% 29.32% 35.13% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 4.38% 4.20% 6.02% 16.70% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.72% 13.54% 13.71% 13.27% 11.99% 11.16% 12.83% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 6.13% 5.13% 5.04% 6.17% 6.93% 8.50% 10.69% 12.49% 12.14% 12.26% 12.60% 13.02% 13.02% 13.09% 13.00% 12.61% 12.20% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 4.46% 3.97% 6.25% 15.99% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.80% 12.38% 12.36% 13.27% 11.99% 11.16% 12.42% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 5.83% 4.76% 4.76% 5.86% 6.80% 8.32% 10.70% 12.35% 12.11% 12.46% 12.76% 12.84% 12.58% 12.67% 12.54% 12.19% 12.23% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median values 10 Yr Med 10 Yr Cl 0.77% 0.72% 5 Yr Med 5 Yr Cl 0.71% 0.70% 5 Yr Med Payout 35.59% 12.95% 12.46% 11.25% <-IRR #YR-> 5 Dividends 70.39% US$
* Dividends per share  10 Yr Med and Cur. 8.78% 16.39% 5 Yr Med and Cur. 18.62% 19.57% Last Div Inc ---> $0.315 $0.350 11.11% 15.08% <-IRR #YR-> 10 Dividends 307.56% US$
Dividends Growth 15 9.45% <-IRR #YR-> 15 Dividends 287.34% US$
Dividends Growth 20 1.63% <-IRR #YR-> 20 Dividends US$
Dividends Growth 25 5.91% <-IRR #YR-> 23 Dividends
Dividends Growth 5 -$0.76 $0.00 $0.00 $0.00 $0.00 $1.30 Dividends Growth 5
Dividends Growth 10 -$0.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.30 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.30 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.30 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.30 Dividends Growth 25
Historical Dividends Historical High Div 5.92% Low Div 0.63% 10 Yr High 1.80% 10 Yr Low 0.61% Med Div 1.10% Close Div 0.97% Historical Dividends Div Yd Years
High/Ave/Median Values Curr diff Exp. -85.79%     33.51% Exp. -53.27% 37.88% Exp. -23.54% Exp. -13.69% High/Ave/Median  1.41% 5
2.36% 10
Future Dividend Yield Div Yield 1.41% earning in 5 Years at IRR of 10.87% Div Inc. 67.52% Future Dividend Yield 3.95% 15
Future Dividend Yield Div Yield 2.36% earning in 10 Years at IRR of 10.87% Div Inc. 180.63% Future Dividend Yield
Future Dividend Yield Div Yield 3.95% earning in 15 Years at IRR of 10.87% Div Inc. 370.12% Future Dividend Yield
Future Dividend Paid Div Paid $2.39 earning in 5 Years at IRR of 11.25% Div Inc. 70.39% Future Dividend Paid Div Pd Div Yield
Future Dividend Paid Div Paid $4.06 earning in 10 Years at IRR of 11.25% Div Inc. 190.34% Future Dividend Paid $2.39 1.41%
Future Dividend Paid Div Paid $6.93 earning in 15 Years at IRR of 11.25% Div Inc. 394.73% Future Dividend Paid $4.06 2.36%
$6.93 3.95%
Dividend Covering Cost Total Div $8.76 over 5 Years at IRR of 11.25% Div Cov. 5.26% Dividend Covering Cost
Dividend Covering Cost Total Div $21.31 over 10 Years at IRR of 11.25% Div Cov. 12.80% Dividend Covering Cost
Dividend Covering Cost Total Div $42.68 over 15 Years at IRR of 11.25% Div Cov. 25.64% Dividend Covering Cost
Yield if held 5 years 3.02% 1.58% 0.94% 1.86% 1.67% 1.69% 1.60% 2.33% 1.61% 1.33% 1.41% 1.29% 1.26% 1.03% 1.06% 0.94% 1.60% <-Median-> 10 Paid Median Price US$
Yield if held 10 years 1.80% 1.15% 0.84% 1.38% 1.32% 2.42% 3.84% 2.61% 2.76% 3.32% 3.10% 2.80% 2.78% 2.37% 1.73% 1.48% 2.77% <-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.75% 4.44% 4.58% 4.91% 4.13% 2.92% <-Median-> 9 Paid Median Price US$
Yield if held 20 years 6.32% 5.28% 3.85% 3.43% 3.81% 3.69% 5.85% 4.57% <-Median-> 4 Paid Median Price US$
Yield if held 25 years 9.37% 7.05%
Cost covered if held 5 years 8.37% 10.23% 6.02% 6.23% 7.13% 6.65% 6.14% 6.45% 5.67% 4.69% 4.51% 4.20% 4.41% 3.93% 3.67% 3.59% 5.91% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 34.71% 21.43% 15.61% 14.68% 12.29% 17.78% 25.05% 16.34% 17.19% 20.45% 19.22% 17.56% 17.82% 15.59% 12.51% 11.55% 17.67% <-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.58% 34.54% 36.35% 42.62% 38.87% 34.54% <-Median-> 9 Paid Median Price US$
Cost covered if held 20 years 86.97% 67.52% 45.60% 37.66% 39.75% 38.91% 63.44% 56.56% <-Median-> 4 Paid Median Price US$
Cost covered if held 25 years 129.22% 101.06%
Yr  Item Tot. Growth Per Year
Dividend CDN$ Paid in US$ from 2017 $1.97 $2.20 $2.41 Estimates Div CDN$ Paid in US$ fr2017
Increase 11.23% 11.26% 9.67% Estimates Increase
Payout Ratio EPS 30.07% 28.51% 27.90% 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.57 $0.61 $0.66 $1.02
Pre-split 2017 $1.18 $1.27 $1.37 $1.02
Dividend CDN$ Paid in US$ from 2017 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $1.68 $1.77 $1.98 $1.98 $1.98 303.39% <-Total Growth 10 Dividends CDN$
Increase 1.79% 7.02% 8.20% 54.23% -7.57% 26.14% 9.16% 12.03% 10.71% 19.47% 8.50% 21.23% 5.43% 11.70% 0.00% 0.00% 19 3 23 Years of data, Count P, N 82.61% CDN$
Average Increases 5 Year Running -16.30% -4.98% 5.75% 14.80% 12.73% 17.60% 18.03% 18.80% 10.10% 15.50% 11.98% 14.39% 13.07% 13.27% 9.37% 7.67% 14.59% <-Median-> 10 Average Incr 5 Year Running CDN$
Dividends 5 Yr Running $0.41 $0.37 $0.39 $0.46 $0.51 $0.59 $0.68 $0.79 $0.86 $0.99 $1.11 $1.28 $1.44 $1.62 $1.76 $1.88 266.64% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 1.12% 0.97% 0.94% 1.15% 0.78% 0.84% 0.76% 0.80% 0.72% 0.74% 0.75% 0.72% 0.69% 0.89% 0.75% <-Median-> 10 Yield H/L Price CDN$
Yield on High  Price 0.97% 0.83% 0.83% 0.95% 0.68% 0.74% 0.67% 0.70% 0.61% 0.65% 0.69% 0.62% 0.63% 0.83% 0.67% <-Median-> 10 Yield on High  Price CDN$
Yield on Low Price 1.33% 1.18% 1.09% 1.45% 0.91% 0.96% 0.87% 0.95% 0.87% 0.86% 0.81% 0.86% 0.77% 0.96% 0.87% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 1.04% 0.84% 0.97% 0.97% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.70% 0.68% 0.74% 0.84% 0.84% 0.84% 0.72% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 48.95% 31.06% 30.20% 25.74% 22.97% 33.33% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 72.93% 42.62% 33.52% 21.74% 21.71% 23.72% 26.69% 36.50% 35.06% 35.59% 37.01% 40.67% 35.22% 33.78% 32.25% 29.34% 35.14% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 4.38% 4.20% 6.02% 16.70% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.72% 13.54% 13.71% 13.27% 11.99% 11.16% 12.83% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 6.13% 5.08% 5.05% 6.36% 7.16% 8.65% 10.65% 12.49% 12.12% 12.23% 12.59% 13.02% 13.04% 13.10% 13.00% 12.61% 12.18% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 4.46% 3.97% 6.25% 15.99% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.80% 12.38% 12.36% 13.27% 11.99% 11.16% 12.42% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 5.84% 4.73% 4.80% 6.08% 7.03% 8.50% 10.67% 12.36% 12.10% 12.44% 12.75% 12.82% 12.57% 12.67% 12.54% 12.19% 12.23% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median values 10 Yr Med 10 Yr Cl 0.75% 0.72% 5 Yr Med 5 Yr Cl 0.72% 0.70% 5 Yr Med Payout 35.59% 12.95% 12.46% 12.90% <-IRR #YR-> 5 Dividends 83.43% CDN$
* Dividends per share  10 Yr Med and Cur. 11.08% 15.82% 5 Yr Med and Cur. 16.24% 19.25% Last Div Inc ---> $0.185 $0.205 10.81% 14.97% <-IRR #YR-> 10 Dividends 303.39% CDN$
Dividends Growth 15 11.79% <-IRR #YR-> 15 Dividends 432.48% CDN$
Dividends Growth 20 2.45% <-IRR #YR-> 20 Dividends CDN$
Dividends Growth 25 5.25% <-IRR #YR-> 23 Dividends
Dividends Growth 5 -$0.97 $0.00 $0.00 $0.00 $0.00 $1.77 Dividends Growth 5
Dividends Growth 10 -$0.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.77 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.77 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.77 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.77 Dividends Growth 25
Historical Dividends Historical High Div 5.30% Low Div 0.62% 10 Yr High 1.40% 10 Yr Low 0.61% Med Div 1.13% Close Div 0.99% Historical Dividends
High/Ave/Median Values Curr diff Exp. -84.21%     35.00% Exp. -40.21% 37.21% Exp. -25.93% Exp. -15.03% High/Ave/Median 
Future Dividend Yield Div Yield 1.54% earning in 5 Years at IRR of 12.90% Div Inc. 83.43% Future Dividend Yield
Future Dividend Yield Div Yield 2.82% earning in 10 Years at IRR of 12.90% Div Inc. 236.47% Future Dividend Yield
Future Dividend Yield Div Yield 5.17% earning in 15 Years at IRR of 12.90% Div Inc. 517.18% Future Dividend Yield
Future Dividend Paid Div Paid $3.64 earning in 5 Years at IRR of 12.90% Div Inc. 83.43% Future Dividend Paid Div Pd Div Yield
Future Dividend Paid Div Paid $6.67 earning in 10 Years at IRR of 12.90% Div Inc. 236.47% Future Dividend Paid $3.64 1.54%
Future Dividend Paid Div Paid $12.24 earning in 15 Years at IRR of 12.90% Div Inc. 517.18% Future Dividend Paid $6.67 2.82%
$12.24 5.17%
Dividend Covering Cost Total Div $12.82 over 5 Years at IRR of 12.90% Div Cov. 5.41% Dividend Covering Cost
Dividend Covering Cost Total Div $32.71 over 10 Years at IRR of 12.90% Div Cov. 13.81% Dividend Covering Cost
Dividend Covering Cost Total Div $69.18 over 15 Years at IRR of 12.90% Div Cov. 29.20% Dividend Covering Cost
Yield if held 5 years 1.59% 2.35% 1.51% 2.22% 2.20% 2.33% 2.07% 2.07% 1.81% 1.58% 1.47% 1.48% 1.48% 1.33% 1.15% 1.07% 1.94% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 years 1.91% 1.34% 1.17% 1.85% 1.65% 3.31% 4.98% 3.32% 3.50% 4.49% 4.09% 4.03% 3.80% 3.36% 2.45% 2.10% 3.65% <-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.72% 6.09% 6.48% 6.96% 5.85% 3.98% <-Median-> 9 Paid Median Price CDN$
Yield if held 20 years 8.56% 6.99% 5.54% 4.71% 5.40% 5.22% 8.28% 6.27% <-Median-> 4 Paid Median Price CDN$
Yield if held 25 years 13.27% 9.98%
Cost covered if held 5 years 8.61% 10.72% 6.73% 7.45% 8.89% 8.68% 8.14% 8.42% 7.32% 6.15% 5.89% 5.62% 5.99% 5.43% 5.12% 5.06% 7.38% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 38.41% 23.55% 17.23% 16.36% 14.29% 20.91% 30.34% 20.21% 21.58% 26.35% 25.11% 23.43% 23.84% 21.05% 17.05% 15.83% 22.50% <-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% 67.23% 44.89% 48.11% 57.29% 52.84% 44.18% <-Median-> 9 Paid Median Price CDN$
Cost covered if held 20 years 104.23% 81.27% 55.79% 46.73% 50.20% 50.59% 83.47% 68.53% <-Median-> 4 Paid Median Price CDN$
Cost covered if held 25 years 163.19% 128.61%
Yr  Item Tot. Growth Per Year
Revenue Growth US$ $5,446.0 $6,151.4 $7,211.9 $8,022.0 $8,919.6 $9,466.9 $9,609 <-12 mths 1.50% 73.83% <-Total Growth 5 Revenue Growth US$ 73.83% 11.69%
AEPS Growth $2.64 $3.23 $3.82 $4.19 $4.79 $5.15 $5.25 <-12 mths 1.94% 95.08% <-Total Growth 5 AEPS Growth 95.08% 14.30%
Net Income Growth $204.7 $618.0 $835.7 $762.8 $616.6 $1,076.6 $1,054 <-12 mths -2.06% 425.98% <-Total Growth 5 Net Income Growth 425.98% 39.38%
Cash Flow Growth $1,408.5 $1,698.2 $2,022.5 $2,126.8 $2,228.9 $2,414.1 $2,418 <-12 mths 0.17% 71.39% <-Total Growth 5 Cash Flow Growth 71.39% 11.38%
Dividend Growth $0.76 $0.85 $0.95 $1.05 $1.17 $1.30 $1.40 <-12 mths 8.11% 70.39% <-Total Growth 5 Dividend Growth 70.39% 11.25%
Stock Price Growth $102.57 $136.27 $132.56 $149.27 $171.58 $175.36 $166.45 <-12 mths -5.08% 70.97% <-Total Growth 5 Stock Price Growth 70.97% 11.32%
Revenue Growth US$ $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,919.6 $9,466.9 $9,999 <-this year 5.62% 391.64% <-Total Growth 10 Revenue Growth US$ 391.64% 17.26%
AEPS Growth $1.98 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $4.79 $5.15 $5.50 <-this year 6.80% 160.10% <-Total Growth 10 AEPS Growth 160.10% 10.03%
Net Income Growth $123.9 $245.8 $576.8 $546.9 $566.8 $204.7 $618.0 $835.7 $762.8 $616.6 $1,076.6 $1,179 <-this year 9.52% 769.06% <-Total Growth 10 Net Income Growth 769.06% 24.14%
Cash Flow Growth $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,228.9 $2,414.1 $2,682 <-this year 11.12% 481.68% <-Total Growth 10 Cash Flow Growth 481.68% 19.25%
Dividend Growth $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $1.30 $1.39 <-this year 7.64% 307.56% <-Total Growth 10 Dividend Growth 307.56% 15.08%
Stock Price Growth $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $171.58 $175.36 $203.92 <-this year 16.29% 437.82% <-Total Growth 10 Stock Price Growth 437.82% 18.32%
Dividends on Shares CDN$ $15.61 $14.43 $18.20 $19.87 $22.26 $24.64 $29.44 $31.94 $38.72 $40.82 $45.60 $45.60 $45.60 $255.92 No of Years 10 Total Dividends CDN$ 12/31/15
Paid  $1,038.12 $1,615.21 $2,050.68 $2,330.59 $2,712.85 $3,001.96 $3,965.20 $4,128.04 $4,550.78 $5,671.80 $5,536.56 $5,448.24 $5,448.24 $5,448.24 $5,536.56 No of Years 10 Worth $45.14 22.16
Total $5,792.48 Total
Dividends on Shares CDN$ $8.57 $10.24 $11.11 $13.47 $14.20 $15.86 $15.86 $15.86 $57.59 No of Years 5 Total Dividends CDN$ 12/31/20
Paid  $1,044.16 $1,379.20 $1,435.84 $1,582.88 $1,972.80 $1,925.76 $1,895.04 $1,895.04 $1,895.04 $1,925.76 No of Years 5 Worth $130.52 7.66
Total $1,983.35 Total
Dividends on Shares US$ $15.67 $15.50 $17.98 $20.62 $23.56 $26.20 $29.30 $32.55 $36.27 $40.15 $43.40 $43.40 $43.40 $257.78 No of Years 10 Total Dividends US$ 12/31/15
Paid  $1,010.78 $1,624.19 $2,199.14 $2,301.75 $2,814.49 $3,179.67 $4,224.37 $4,109.36 $4,627.37 $5,318.98 $5,436.16 $5,159.95 $5,159.95 $5,159.95 $5,436.16 No of Years 10 Worth $32.61 30.67
Total $5,693.94 Total
Graham Price AEPS $32.59 $37.50 $32.55 $38.67 $42.70 $50.88 $52.11 $50.13 $56.01 $66.02 $70.18 $82.45 $83.79 $88.69 $94.09 $99.48 172.50% <-Total Growth 11 Graham Price AEPS CDN$
Price/GP Ratio Med 1.04 1.11 1.43 1.53 1.89 1.86 2.18 2.40 2.66 2.61 2.65 2.84 3.06 2.51 2.51 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio High 1.20 1.31 1.63 1.84 2.17 2.09 2.47 2.77 3.12 2.97 2.86 3.30 3.36 2.70 2.77 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Low 0.88 0.92 1.24 1.21 1.61 1.63 1.90 2.03 2.20 2.25 2.44 2.37 2.77 2.32 2.20 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Close 1.12 1.29 1.39 1.82 2.09 1.99 2.26 2.60 3.08 2.72 2.82 2.99 2.87 2.67 2.52 2.38 2.67 <-Median-> 11 Price/GP Ratio CDN$
Prem/Disc Close 11.59% 28.97% 38.69% 81.59% 108.81% 99.17% 126.36% 160.36% 207.79% 171.86% 181.94% 199.09% 187.27% 167.10% 151.77% 138.12% 167.10% <-Median-> 11 Graham Price
Graham Price EPS $34.07 $38.12 $36.48 $30.49 $42.85 $46.11 $46.22 $27.25 $47.88 $60.80 $58.88 $58.24 $75.40 $81.42 $88.20 $93.37 123.22% <-Total Growth 11 Graham Price EPS CDN$
Price/GP Ratio Med 1.00 1.10 1.28 1.94 1.89 2.05 2.46 4.41 3.12 2.83 3.16 4.01 3.40 2.73 2.83 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio High 1.15 1.29 1.45 2.34 2.17 2.31 2.78 5.09 3.66 3.22 3.41 4.67 3.73 2.94 3.22 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Low 0.84 0.91 1.11 1.54 1.61 1.80 2.14 3.73 2.58 2.45 2.90 3.36 3.07 2.53 2.53 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Close 1.07 1.27 1.24 2.30 2.08 2.20 2.55 4.79 3.60 2.95 3.36 4.23 3.19 2.91 2.69 2.54 2.95 <-Median-> 11 Price/GP Ratio CDN$
Prem/Disc Close 6.77% 26.85% 23.74% 130.31% 108.05% 119.76% 155.19% 379.00% 260.08% 195.19% 236.01% 323.43% 219.25% 190.92% 168.56% 153.70% 195.19% <-Median-> 11 Graham Price
Pre-Split 2016 $26.27 $34.93 $32.60
Pre-Split 2017 $54.56 $72.54 $67.70 $105.34
Price Close CDN$ $36.37 $48.36 $45.14 $70.23 $89.16 $101.33 $117.95 $130.52 $172.40 $179.48 $197.86 $246.60 $240.72 $236.88 $236.88 $236.88 433.32% <-Total Growth 10 Stock Price CDN$ CDN$
Increase 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 10.24% 24.63% -2.38% -1.60% 0.00% 0.00% 37.77 <-Median-> 10 CAPE (10 Yr P/E)
P/E 17.49 19.77 15.18 49.03 32.60 35.88 42.44 131.43 57.62 40.90 50.71 71.71 42.12 36.08 30.75 27.44 13.02% <-IRR #YR-> 5 Stock Price 84.43% CDN$
Trailing P/E 23.46 23.26 18.45 23.62 62.25 37.05 41.77 46.96 173.60 59.99 45.09 63.20 70.00 41.45 36.08 30.75 18.22% <-IRR #YR-> 10 Stock Price 433.32% CDN$
CAPE (10 Yr P/E) 34.94 33.25 26.99 29.21 29.66 33.13 35.05 41.90 36.89 38.64 41.96 47.46 49.56 47.14 45.05 42.37 13.87% <-IRR #YR-> 5 Price & Dividend 89.95% CDN$
Median 10, 5 Yrs D.  per yr 1.11% 0.85% % Tot Ret 5.74% 6.12% T P/E 53.47 63.20 P/E:  45.74 50.71 19.33% <-IRR #YR-> 10 Price & Dividend 457.98% CDN$
Price 15 D.  per yr 0.90% % Tot Ret 6.03% CAPE Diff -4.47% 14.05% <-IRR #YR-> 15 Stock Price 618.74% CDN$
Price  20 D.  per yr 1.03% % Tot Ret 9.75% 9.54% <-IRR #YR-> 20 Stock Price 518.95% CDN$
Price  25 D.  per yr 2.26% % Tot Ret 15.17% 12.64% <-IRR #YR-> 24 Stock Price 1610.90% CDN$
Price & Dividend 15 14.95% <-IRR #YR-> 15 Price & Dividend 657.83% CDN$
Price & Dividend 20 10.57% <-IRR #YR-> 20 Price & Dividend 564.27% CDN$
Price & Dividend 25 14.89% <-IRR #YR-> 24 Price & Dividend #DIV/0! CDN$
Price  5 -$130.52 $0.00 $0.00 $0.00 $0.00 $240.72 Price  5
Price 10 -$45.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $240.72 Price 10
Price & Dividend 5 -$130.52 $1.07 $1.28 $1.39 $1.68 $242.49 Price & Dividend 5
Price & Dividend 10 -$45.14 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $1.68 $242.49 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 $240.72 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 $240.72 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 $240.72 Price  25
Price & Dividend 15 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $1.68 $242.49 Price & Dividend 15
Price & Dividend 20 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $1.68 $242.49 Price & Dividend 20
Price & Dividend 25 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $1.68 $242.49 Price & Dividend 25
Price H/L Median $33.91 $41.80 $46.67 $59.07 $80.85 $94.60 $113.69 $120.27 $149.22 $172.25 $185.83 $233.81 $256.70 $222.56 450.08% <-Total Growth 10 Stock Price CDN$
Increase 19.05% 23.25% 11.64% 26.57% 36.87% 17.01% 20.18% 5.79% 24.07% 15.43% 7.88% 25.82% 9.79% -13.30% 18.59% <-IRR #YR-> 10 Stock Price 450.08% CDN$
P/E 16.31 17.09 15.70 41.24 29.56 33.50 40.90 121.11 49.87 39.25 47.63 67.99 44.91 33.90 16.37% <-IRR #YR-> 5 Stock Price 113.44% CDN$
Trailing P/E 21.88 20.10 19.08 19.87 56.45 34.59 40.26 43.27 150.26 57.57 42.35 59.93 74.64 38.94 19.65% <-IRR #YR-> 10 Price & Dividend 473.93% CDN$
P/E on Running 5 yr Average 60.00 47.98 39.83 28.18 34.65 38.11 44.61 55.87 60.54 61.62 61.72 74.40 62.80 46.35 17.24% <-IRR #YR-> 5 Price & Dividend 119.42% CDN$
P/E on Running 10 yr Average 37.88 42.47 37.76 47.17 57.36 62.09 66.49 72.36 65.43 67.17 67.66 82.16 82.28 61.25 31.11 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D.  per yr 1.06% 0.87% % Tot Ret 5.40% 5.05% T P/E 49.86 59.93 P/E:  43.08 47.63 Count 23 Years of data
-$46.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $256.70
-$120.27 $0.00 $0.00 $0.00 $0.00 $256.70
-$46.67 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $1.68 $258.47
-$120.27 $1.07 $1.28 $1.39 $1.68 $258.47
High Months Dec Dec Apr Dec Oct Sep May Feb Nov Dec Dec Nov Apr Jan
Pre-Split 2016 $28.29 $35.44 $38.20
Pre-Split 2017 $58.75 $73.60 $79.33 $106.96
Price High $39.17 $49.07 $52.89 $71.31 $92.80 $106.40 $128.46 $138.77 $175.03 $195.80 $200.64 $271.92 $281.55 $239.37 432.34% <-Total Growth 10 Stock Price CDN$
Increase 23.00% 25.27% 7.79% 34.82% 30.14% 14.66% 20.73% 8.03% 26.13% 11.87% 2.47% 35.53% 3.54% -14.98% 18.20% <-IRR #YR-> 10 Stock Price 432.34% CDN$
P/E 18.83 20.06 17.79 49.79 33.93 37.68 46.22 139.73 58.50 44.62 51.42 79.07 49.26 36.46 15.20% <-IRR #YR-> 5 Stock Price 102.89% CDN$
Trailing P/E 25.27 23.59 21.62 23.98 64.79 38.91 45.49 49.93 176.25 65.44 45.72 69.69 81.87 41.88 34.47 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 57.36 69.69 P/E:  49.52 51.42 51.42 P/E Ratio Historical High CDN$
-$52.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $281.55
-$138.77 $0.00 $0.00 $0.00 $0.00 $281.55
Low Months Feb Jan Dec Jan Jan Feb Jan Mar Feb Jun Jan Jan Dec May
Price Low $28.66 $34.53 $40.44 $46.83 $68.89 $82.80 $98.92 $101.77 $123.41 $148.70 $171.01 $195.70 $231.85 $205.74 473.29% <-Total Growth 10 Stock Price CDN$
Increase 14.05% 20.48% 17.12% 15.79% 47.12% 20.19% 19.47% 2.88% 21.26% 20.49% 15.00% 14.44% 18.47% -11.26% 19.08% <-IRR #YR-> 10 Stock Price 473.29% CDN$
P/E 13.78 14.12 13.60 32.70 25.19 29.32 35.59 102.48 41.25 33.89 43.83 56.91 40.57 31.34 17.90% <-IRR #YR-> 5 Stock Price 127.82% CDN$
Trailing P/E 18.49 16.60 16.53 15.75 48.10 30.28 35.03 36.62 124.27 49.70 38.97 50.16 67.42 36.00 27.26 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 43.54 50.16 P/E:  38.08 41.25 41.25 P/E Ratio Historical High CDN$
-$40.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $231.85
US$ Price based on CDN$ Price, Exch $34.20 $41.69 $32.60 $52.30 $71.07 $74.28 $90.81 $102.51 $135.98 $132.52 $149.60 $171.38 $175.63 $167.26 $167.26 $167.26
Price Close US$ $34.27 $41.65 $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $171.58 $175.36 $166.45 $166.45 $166.45 437.82% <-Total Growth 10 Stock Price US$ US$
Increase 14.58% 21.54% -21.71% 60.69% 35.40% 4.67% 22.28% 12.97% 32.86% -2.72% 12.61% 14.95% 2.20% -5.08% 0.00% 0.00% 37.29 <-Median-> 10 CAPE (10 Yr P/E)
P/E 17.53 19.75 15.19 49.12 32.54 35.87 42.43 131.50 57.74 40.91 50.60 71.79 42.05 35.90 30.60 27.30 11.32% <-IRR #YR-> 5 Stock Price 70.97% US$
Trailing P/E 22.07 21.30 15.46 24.40 66.51 34.06 43.86 47.93 174.71 56.17 46.07 58.16 73.37 39.92 35.90 30.60 18.32% <-IRR #YR-> 10 Stock Price 437.82% US$
CAPE (10 Yr P/E) 35.86 34.16 28.47 30.36 30.72 34.05 35.93 43.22 36.25 38.32 41.98 47.52 49.51 47.19 45.25 42.62 12.15% <-IRR #YR-> 5 Price & Dividend 76.14% US$
Median 10, 5 Yrs D.  per yr 1.16% 0.83% % Tot Ret 5.94% 6.79% T P/E 52.05 58.16 P/E:  45.77 50.60 19.48% <-IRR #YR-> 10 Price & Dividend 463.32% US$
Price 15 D.  per yr 0.84% % Tot Ret 6.70% 11.64% <-IRR #YR-> 15 Stock Price 421.22% US$
Price  20 D.  per yr 1.09% % Tot Ret 11.15% 8.68% <-IRR #YR-> 20 Stock Price 428.18% US$
Price  25 D.  per yr 3.78% % Tot Ret 20.58% 14.59% <-IRR #YR-> 24 Stock Price US$
Price & Dividend 15 12.47% <-IRR #YR-> 15 Price & Dividend 422.45% US$
Price & Dividend 20 9.77% <-IRR #YR-> 20 Price & Dividend 429.42% US$
Price & Dividend 25 18.38% <-IRR #YR-> 24 Price & Dividend US$
Price  5 -$102.57 $0.00 $0.00 $0.00 $0.00 $175.36 Price  5
Price 10 -$32.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $175.36 Price 10
Price & Dividend 5 -$102.57 $0.85 $0.95 $1.05 $1.17 $176.66 Price & Dividend 5
Price & Dividend 10 -$32.61 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $176.66 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 $175.36 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 $175.36 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 $175.36 Price  25
Price & Dividend 15 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $176.66 Price & Dividend 15
Price & Dividend 20 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $176.66 Price & Dividend 20
Price & Dividend 25 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $176.66 Price & Dividend 25
Price H/L Median US$ $32.60 $36.89 $35.87 $42.54 $62.36 $73.09 $84.48 $73.07 $117.91 $136.40 $138.31 $169.77 $182.63 $161.57 $161.57 $161.57 409.20% <-Total Growth 10 Stock Price US$
Increase 16.21% 13.17% -2.78% 18.60% 46.60% 17.21% 15.58% -13.50% 61.36% 15.69% 1.40% 22.74% 7.58% -11.53% 17.68% <-IRR #YR-> 10 Stock Price 409.20% US$
P/E 16.67 17.50 16.71 39.88 28.61 35.31 39.47 93.68 49.96 42.10 46.88 71.03 43.80 34.85 20.11% <-IRR #YR-> 5 Stock Price 149.94% US$
Trailing P/E 20.99 18.87 17.01 19.81 58.46 33.53 40.81 34.14 151.16 57.80 42.69 57.55 76.41 38.75 18.75% <-IRR #YR-> 10 Price & Dividend 432.38% US$
P/E on Running 5 yr Average 59.67 46.48 38.66 24.09 32.97 38.18 43.98 44.36 61.86 64.40 60.29 72.43 60.43 46.47 21.11% <-IRR #YR-> 5 Price & Dividend 157.20% US$
P/E on Running 10 yr Average 40.47 41.59 33.76 40.11 53.72 59.40 62.24 56.75 64.22 68.04 65.73 79.61 78.23 60.03 29.60 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 1.07% 1.00% % Tot Ret 5.73% 4.75% T P/E 50.12 57.80 P/E:  42.95 46.88
-$35.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $182.63
-$73.07 $0.00 $0.00 $0.00 $0.00 $182.63
-$35.87 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $183.93
-$73.07 $0.85 $0.95 $1.05 $1.17 $183.93
High Months US$ Oct Dec Apr Dec Oct Sep May Feb Nov Nov Dec Nov Apr Jan
Pre-Split 2016 $26.96 $30.97 $30.54
Pre-Split 2017 $55.99 $64.32 $63.43 $78.78
Price High $37.33 $42.88 $42.28 $52.52 $72.18 $80.58 $94.93 $104.67 $138.27 $145.45 $149.27 $192.81 $199.95 $174.12 $174.12 $174.12 372.88% <-Total Growth 10 Stock Price US$
Increase 17.99% 14.87% -1.39% 24.21% 37.43% 11.64% 17.81% 10.26% 32.10% 5.19% 2.63% 29.17% 3.70% -12.92% 16.81% <-IRR #YR-> 10 Stock Price 372.88% US$
P/E 19.09 20.34 19.69 49.24 33.11 38.93 44.36 134.19 58.59 44.89 50.60 80.67 47.95 37.56 13.82% <-IRR #YR-> 5 Stock Price 91.03% US$
Trailing P/E 24.04 21.93 20.05 24.46 67.67 36.96 45.86 48.91 177.27 61.63 46.07 65.36 83.66 41.76 34.08 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 55.27 65.36 P/E:  48.59 50.60 52.20 P/E Ratio Historical High US$
-$42.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $199.95
-$104.67 $0.00 $0.00 $0.00 $0.00 $199.95
Low Months US$ Feb Jan Dec Jan Jan Feb Jan Mar Feb Feb Jan Jan Nov May
Price Low $27.87 $30.90 $29.45 $32.55 $52.54 $65.60 $74.02 $41.47 $97.54 $127.35 $127.35 $146.72 $165.31 $149.02 $149.02 $149.02 461.34% <-Total Growth 10 Stock Price US$
Increase 13.92% 10.88% -4.70% 10.54% 61.40% 24.86% 12.84% -43.97% 135.21% 30.56% 0.00% 15.21% 12.67% -9.85% 18.83% <-IRR #YR-> 10 Stock Price 461.34% US$
P/E 14.25 14.66 13.72 30.52 24.10 31.69 34.59 53.17 41.33 39.31 43.17 61.39 39.64 32.14 31.86% <-IRR #YR-> 5 Stock Price 298.63% US$
Trailing P/E 17.95 15.80 13.97 15.16 49.26 30.09 35.76 19.38 125.05 53.96 39.31 49.74 69.17 35.74 25.13 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 44.28 53.96 P/E:  39.47 41.33 41.70 P/E Ratio Historical High US$
-$29.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $165.31
Free Cash Flow Mkt Sc $842 $954 $1,110 $1,224 $1,218 $1,259 $1,429 $1,706 $1,914 <-Total Growth 5 Free Cash Flow Mkt Sc
Change 13.30% 16.36% 10.27% -0.49% 3.37% 13.50% 19.38% 12.19% 10.27% <-Median-> 5 Change
$1,131 <-12 mths -7.08%
Free Cash Flow Company $1,224 $1,259 $1,218 $1,429 $1,706 $1,914 <-Total Growth 2 Free Cash Flow Company
Change 2.87% -3.32% 17.37% 19.38% 12.19% -0.22% <-Median-> 2 Change
$2,630 <-12 mths 77.70%
Free Cash Flow MS Old $338.17 $450.59 $707.97 $865.09 $874.46 $744 $954 $1,110 $1,193 Free Cash Flow MS Old
Change 33.24% 57.12% 22.19% 1.08% -14.92% 28.23% 16.35% 7.48% Change
Free Cash Flow MS $274.19 $303.80 $330.00 $490.00 $780.00 $830.00 $850.00 $770 $930 $1,040 $1,180 $1,380 $1,480 $1,429 $1,706 $1,914 348.48% <-Total Growth 10 Free Cash Flow MS US$
Change 48.48% 59.18% 6.41% 2.41% -9.41% 20.78% 11.83% 13.46% 16.95% 7.25% 7.19% 7.19% 7.19% 13.96% <-IRR #YR-> 5 Free Cash Flow MS 92.21% US$
FCF/CF from Op Ratio 0.61 0.67 0.80 0.62 0.66 0.59 0.55 0.55 0.55 0.51 0.55 0.62 0.61 0.74 0.74 0.74 16.19% <-IRR #YR-> 10 Free Cash Flow MS 348.48% US$
Dividends paid $19.76 $18.92 $56.00 $93.00 $131.98 $152.55 $175.07 $199.88 $220.20 $243.01 $270.60 $302.26 $333.81 $239.40 $239.40 $239.40 496.08% <-Total Growth 10 Dividends paid US$
Percentage paid 16.97% 18.98% 16.92% 18.38% 20.60% 25.96% 23.68% 23.37% 22.93% 21.90% 22.55% 18.89% 18.89% 18.89% 22.23% <-Median-> 10 Percentage paid US$
5 Year Covrage 18.55% 20.23% 21.15% 22.41% 23.24% 23.32% 22.79% 20.98% 20.98% 20.98% 22.41% <-Median-> 7 5 Year Coverage US$
Dividend Coverage Ratio 5.89 5.27 5.91 5.44 4.86 3.85 4.22 4.28 4.36 4.57 4.43 5.29 5.29 5.29 4.50 <-Median-> 10 Dividend Coverage Ratio US$
5 Year of Coverage 5.39 4.94 4.73 4.46 4.30 4.29 4.39 4.77 4.77 4.77 4.46 <-Median-> 7 5 Year of Coverage US$
Market Cap US$ $1,895 $2,248 $2,562 $13,769 $18,692 $19,538 $23,934 $26,958 $35,459 $34,087 $38,452 $44,271 $44,825 $42,322 $42,322 $42,322 1649.32% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $2,011 $2,611 $3,547 $18,456 $23,493 $26,664 $31,094 $34,304 $44,861 $46,153 $50,969 $63,628 $61,532 $60,229 $60,229 $60,229 1634.70% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 83.18 82.93 79.80 231.08 264.30 264.40 264.53 263.69 261.73 258.04 258.15 258.66 257.98 255.87 223.30% <-Total Growth 10 Diluted
Change -1.38% -0.30% -3.78% 189.59% 14.38% 0.04% 0.05% -0.32% -0.74% -1.41% 0.04% 0.20% -0.26% -0.82% 0.04% <-Median-> 10 Change
Difference Diluted/Basic 0.0% 0.0% 0.0% -0.3% -0.2% -0.3% -0.3% -0.2% -0.2% -0.3% -0.2% -0.3% -0.3% 0.0%
Basic # of Shares in Millions 83.18 82.93 79.80 230.33 263.68 263.65 263.79 263.19 261.17 257.38 257.55 257.97 257.32 255.87 222.48% <-Total Growth 10 Basic
Change -1.38% -0.30% -3.78% 188.64% 14.48% -0.01% 0.05% -0.23% -0.77% -1.45% 0.07% 0.16% -0.25% -0.56% 0.02% <-Median-> 10 Change
Difference Basic/Outstanding -33.5% -34.9% -1.5% 14.1% -0.1% -0.2% -0.1% -0.1% -0.4% -0.1% 0.0% 0.0% -0.7% -0.6% -0.08% <-Median-> 10 Difference
$2,418.13 <-12 mths 0.17%
# of Shares in Millions 55.30 53.98 78.59 262.80 263.49 263.14 263.62 262.825 260.212 257.146 257.600 258.019 255.615 254.260 254.260 254.260 12.52% <-IRR #YR-> 10 Shares 225.26% SHAREHOLDERS’ EQUITY
Change -0.12% -2.39% 45.58% 234.41% 0.26% -0.13% 0.18% -0.30% -0.99% -1.18% 0.18% 0.16% -0.93% -0.53% 0.00% 0.00% -0.55% <-IRR #YR-> 5 Shares -2.74%
CF fr Op $M US$ $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,228.9 $2,414.1 $2,682.4 $2,969.8 $3,188.4 481.68% <-Total Growth 10 Cash Flow US$
Increase 33.84% 0.00% -7.92% 91.63% 49.28% 18.86% 9.16% -8.57% 20.57% 19.09% 5.16% 4.80% 8.31% 11.12% 10.71% 7.36% SO Buy Backs S Iss.
5 year Running Average $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,897.0 $2,098.1 $2,295.0 $2,484.4 $2,696.7 412.00% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $8.15 $8.35 $5.28 $3.03 $4.51 $5.36 $5.84 $5.36 $6.53 $7.87 $8.26 $8.64 $9.44 $10.55 $11.68 $12.54 78.84% <-Total Growth 10 Cash Flow per Share US$
Increase 34.01% 2.45% -36.75% -42.69% 48.89% 19.02% 8.97% -8.29% 21.78% 20.51% 4.97% 4.63% 9.33% 11.71% 10.71% 7.36% 19.25% <-IRR #YR-> 10 Cash Flow 481.68% US$
5 year Running Average $6.54 $6.91 $6.97 $6.18 $5.86 $5.31 $4.80 $4.82 $5.52 $6.19 $6.77 $7.33 $8.15 $8.95 $9.71 $10.57 11.38% <-IRR #YR-> 5 Cash Flow 71.39% US$
P/CFPS on Median 4.00 4.42 6.79 14.06 13.84 13.63 14.46 13.63 18.07 17.34 16.75 19.65 19.34 15.31 13.83 12.88 5.99% <-IRR #YR-> 10 Cash Flow per Share 78.84% US$
P/CFPS on Close 4.20 4.99 6.17 17.31 15.74 13.84 15.54 19.14 20.88 16.85 18.08 19.86 18.57 15.78 14.25 13.27 12.00% <-IRR #YR-> 5 Cash Flow per Share 76.22% US$
1.11% Diff M/C 1.58% <-IRR #YR-> 10 CFPS 5 yr Running 16.96% US$
$2,750 <-12 mths 2.67%
Excl.Working Capital CF -$7.25 $25.37 -$15.69 $35.22 $71.00 -$32.00 -$27.00 $24.00 -$19.00 -$73.00 -$13.00 $209.00 $264.00 $0.00 $0.00 $0.00 11.07% <-IRR #YR-> 5 CFPS 5 yr Running 69.02% US$
CF fr Op $M WC $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,437.9 $2,678.1 $2,682.4 $2,969.8 $3,188.4 570.65% <-Total Growth 10 Cash Flow less WC US$
Increase 7.60% 7.36% -16.13% 107.98% 51.50% 9.61% 9.74% -5.35% 17.22% 16.09% 8.43% 15.33% 9.85% 0.16% 10.71% 7.36% 20.96% <-IRR #YR-> 10 Cash Flow less WC 570.65% US$
5 year Running Average $367 $415 $432 $512 $682 $869 $1,076 $1,283 $1,453 $1,591 $1,738 $1,923 $2,172 $2,372 $2,576 $2,791 13.33% <-IRR #YR-> 5 Cash Flow less WC 86.95% US$
CFPS Excl. WC $8.02 $8.82 $5.08 $3.16 $4.78 $5.24 $5.74 $5.45 $6.45 $7.58 $8.21 $9.45 $10.48 $10.55 $11.68 $12.54 17.53% <-IRR #YR-> 10 CF less WC 5 Yr Run 402.76% US$
Increase 7.73% 9.99% -42.39% -37.81% 51.10% 9.76% 9.54% -5.07% 18.40% 17.48% 8.24% 15.15% 10.88% 0.70% 10.71% 7.36% 11.10% <-IRR #YR-> 5 CF less WC 5 Yr Run 69.29% US$
5 year Running Average $6.87 $7.44 $7.38 $6.50 $5.97 $5.42 $4.80 $4.87 $5.53 $6.09 $6.69 $7.43 $8.43 $9.25 $10.07 $10.94 7.50% <-IRR #YR-> 10 CFPS - Less WC 106.19% US$
P/CFPS on Median 4.07 4.18 7.06 13.46 13.06 13.94 14.71 13.41 18.27 17.99 16.86 17.97 17.43 15.31 13.83 12.88 13.96% <-IRR #YR-> 5 CFPS - Less WC 92.22% US$
P/CFPS on Close 4.27 4.72 6.42 16.58 14.86 14.17 15.81 18.82 21.12 17.49 18.19 18.16 16.74 15.78 14.25 13.27 1.34% <-IRR #YR-> 5 CFPS 5 yr Running 14.25% US$
CF/-WC P/CF Med 10 yr 15.60 5 yr  18.07 P/CF Med 10 yr 15.78 5 yr  17.97 -0.04% Diff M/C 11.59% <-IRR #YR-> 5 CFPS 5 yr Running 73.03% US$
$3,424.55 <-12 mths -6.70%
CF fr Op $M CDN$ $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,207.2 $3,308.7 $3,798.9 $4,205.8 $4,515.4 475.74% <-Total Growth 10 Cash Flow CDN$
Increase 42.60% 9.07% 9.90% 85.82% 39.48% 29.26% 3.93% -10.37% 20.06% 27.23% 2.69% 14.02% 3.17% 14.81% 10.71% 7.36% SO Buy Backs S Iss.
5 year Running Average $356 $407 $463 $596 $827 $1,116 $1,412 $1,655 $1,872 $2,122 $2,300 $2,541 $2,844 $3,173 $3,467 $3,807 513.69% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $8.67 $9.69 $7.31 $4.06 $5.65 $7.32 $7.59 $6.82 $8.27 $10.65 $10.92 $12.43 $12.94 $14.94 $16.54 $17.76 77.01% <-Total Growth 10 Cash Flow per Share CDN$
Increase 42.77% 11.74% -24.51% -44.43% 39.11% 29.43% 3.74% -10.10% 21.26% 28.75% 2.51% 13.83% 4.14% 15.43% 10.71% 7.36% 19.13% <-IRR #YR-> 10 Cash Flow 475.74% CDN$
5 year Running Average $6.73 $7.31 $7.77 $7.16 $7.08 $6.81 $6.39 $6.29 $7.13 $8.13 $8.85 $9.82 $11.04 $12.38 $13.56 $14.92 13.03% <-IRR #YR-> 5 Cash Flow 84.50% CDN$
P/CFPS on Median 3.91 4.32 6.38 14.54 14.30 12.93 14.98 17.63 18.03 16.17 17.02 18.81 19.83 14.90 0.00 0.00 5.88% <-IRR #YR-> 10 Cash Flow per Share 77.01% CDN$
P/CFPS on Close 4.20 4.99 6.17 17.28 15.77 13.85 15.54 19.13 20.84 16.85 18.12 19.84 18.60 15.85 14.32 13.34 13.66% <-IRR #YR-> 5 Cash Flow per Share 89.71% CDN$
-4.45% Diff M/C 3.58% <-IRR #YR-> 10 CFPS 5 yr Running 42.14% CDN$
$3,894 <-12 mths 6.09%
Excl.Working Capital CF -$7.72 $29.44 -$21.73 $47.29 $89.07 -$43.65 -$35.07 $30.56 -$24.09 -$98.87 -$17.19 $300.73 $361.84 $0.00 $0.00 $0.00 11.92% <-IRR #YR-> 5 CFPS 5 yr Running 75.61% CDN$
CF fr Op $M WC $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,507.9 $3,670.6 $3,798.9 $4,205.8 $4,515.4 563.80% <-Total Growth 10 Cash Flow less WC CDN$
Increase 14.64% 17.10% 0.11% 101.67% 41.55% 19.20% 4.48% -7.22% 16.72% 24.02% 5.88% 25.47% 4.64% 3.50% 10.71% 7.36% 20.84% <-IRR #YR-> 10 Cash Flow less WC 563.80% CDN$
5 year Running Average $376 $437 $485 $621 $854 $1,136 $1,419 $1,673 $1,876 $2,088 $2,271 $2,579 $2,949 $3,283 $3,596 $3,940 15.01% <-IRR #YR-> 5 Cash Flow less WC 101.25% CDN$
CFPS Excl. WC $8.53 $10.23 $7.04 $4.24 $5.99 $7.15 $7.46 $6.94 $8.18 $10.27 $10.85 $13.60 $14.36 $14.94 $16.54 $17.76 19.77% <-IRR #YR-> 10 CF less WC 5 Yr Run 507.66% CDN$
Increase 14.78% 19.97% -31.23% -39.69% 41.18% 19.36% 4.29% -6.94% 17.90% 25.50% 5.70% 25.27% 5.62% 4.05% 10.71% 7.36% 12.00% <-IRR #YR-> 5 CF less WC 5 Yr Run 76.26% CDN$
5 year Running Average $7.06 $7.85 $8.19 $7.49 $7.21 $6.93 $6.38 $6.36 $7.14 $8.00 $8.74 $9.97 $11.45 $12.80 $14.06 $15.44 7.39% <-IRR #YR-> 10 CFPS - Less WC 104.08% CDN$
P/CFPS on Median 3.98 4.09 6.63 13.92 13.50 13.23 15.25 17.33 18.24 16.78 17.12 17.20 17.88 14.90 0.00 0.00 15.65% <-IRR #YR-> 5 CFPS - Less WC 106.93% CDN$
P/CFPS on Close 4.26 4.73 6.41 16.55 14.88 14.17 15.82 18.81 21.07 17.48 18.23 18.14 16.76 15.85 14.32 13.34 3.41% <-IRR #YR-> 10 CFPS 5 yr Running 39.89% CDN$
*Operational cash flow Per Share (OPS) CF/-WC P/CF Med 10 yr 16.59 5 yr  18.03 P/CF Med 10 yr 16.95 5 yr  17.20 -6.46% Diff M/C 12.50% <-IRR #YR-> 5 CFPS 5 yr Running 80.17% CDN$
-$7.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.94 Cash Flow per Share CDN$
-$6.82 $0.00 $0.00 $0.00 $0.00 $12.94 Cash Flow per Share CDN$
-$7.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.04 CFPS 5 yr Running CDN$
-$6.29 $0.00 $0.00 $0.00 $0.00 $11.04 CFPS 5 yr Running CDN$
-$553 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,671 Cash Flow less WC CDN$
-$1,824 $0 $0 $0 $0 $3,671 Cash Flow less WC CDN$
-$485 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,949 CF less WC 5 Yr Run CDN$
-$1,673 $0 $0 $0 $0 $2,949 CF less WC 5 Yr Run CDN$
-$7.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.36 CFPS - Less WC CDN$
-$6.94 $0.00 $0.00 $0.00 $0.00 $14.36 CFPS - Less WC CDN$
OPM 22.25% 22.44% 21.55% 23.56% 25.64% 28.67% 28.59% 25.86% 27.61% 28.04% 26.51% 24.99% 25.50% 26.83% 18.32% <-Total Growth 10 OPM CDN$
Increase 25.30% 0.85% -3.94% 9.31% 8.83% 11.80% -0.27% -9.53% 6.74% 1.58% -5.46% -5.75% 2.04% 5.20% Should increase  or be stable. CDN$
Diff from Median -15.0% -14.3% -17.7% -10.0% -2.1% 9.5% 9.2% -1.2% 5.4% 7.1% 1.2% -4.6% -2.6% 2.4% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 26.19% 5 Yrs 26.51% should be zero,  it is a check  on calculations CDN$
Revenue, WCN $1,929 $2,079 $2,117 $3,376 $3,182 <-12 mths 1.83%
Adjusted EBITDA (All WCN) $657 $717 $711 $1,461 $1,460 $1,674 $1,566 $1,919 $1,662 $2,221 $2,523 $2,902 $3,125 $3,329 $3,589 $3,839 339.70% <-Total Growth 10 Adjusted EBITDA (All WCN) US$
Change 9.14% -0.90% 105.53% 0.00% 14.59% -6.40% 22.52% -13.40% 33.64% 13.60% 15.02% 7.67% 6.54% 7.81% 6.97% 14.09% <-Median-> 10 Change US$
Margin 34.06% 34.49% 33.56% 43.26% 31.54% 34.00% 29.07% 35.24% 27.02% 30.80% 31.45% 32.53% 33.00% 33.29% 33.86% 34.25% 32.04% <-Median-> 10 Margin US$
$1,684 <-12 mths -1.53%
EBIT $1,040 $1,242 $1,236 $1,068 $1,710 $1,994 $2,227 $2,437 <-Total Growth 4 EBIT US$
Change 19.42% -0.48% -13.59% 60.11% 16.61% 11.69% 9.43% 9.47% <-Median-> 4 Change US$
Margin 16.91% 17.22% 15.41% 11.97% 18.06% 19.94% 21.01% 21.74% 16.91% <-Median-> 4 Margin US$
Long Term Debt US$ $2,149 $3,618 $3,931 $4,196 $4,397 $4,737 $5,041 $6,890 $6,725 $8,073 $8,811 $9,094 Debt
Change 68.36% 8.64% 6.75% 4.77% 7.74% 6.40% 36.70% -2.40% 20.05% 9.14% 3.21% 8.19% <-Median-> 10 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.18 0.20 0.21 0.19 <-Median-> 10 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 10.55 9.95 10.55 12.76 <-Median-> 10 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.62 3.65 3.39 3.34 <-Median-> 10 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 $11,616 $12,076 $12,879 Debt CDN$
Change 63.24% 1.50% 16.09% -0.25% 5.62% 5.95% 46.03% -4.69% 30.60% 3.96% 6.64% 5.79% <-Median-> 10 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.18 0.20 0.21 0.19 <-Median-> 10 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 10.55 9.95 10.55 12.76 <-Median-> 10 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.62 3.65 3.39 3.34 <-Median-> 10 Debt to Cash Flow (Years) CDN$
Intangibles US$ $905 $937 $887 $1,067 $1,087 $1,129 $1,163 $1,155 $1,351 $1,674 $1,604 $1,992 $2,006 $1,596 126.20% <-Total Growth 10 Intangibles US$
Goodwill $220 $166 $177 $4,390 $4,682 $5,032 $5,516 $5,727 $6,188 $6,902 $7,404 $7,950 $8,392 $8,142 4642.11% <-Total Growth 10 Goodwill US$
Goodwill and Intangibles US$ $1,125 $1,103 $1,064 $5,457 $5,769 $6,160 $6,679 $6,882 $7,538 $8,576 $9,008 $9,942 $10,398 $9,738 877.40% <-Total Growth 10 Total US$
Change -7.52% -1.97% -3.57% 412.97% 5.71% 6.78% 8.43% 3.03% 9.54% 13.77% 5.03% 10.37% 4.59% -6.36% 7.60% <-Median-> 10 Change US$
Intangible/Market Cap Ratio 0.59 0.49 0.42 0.40 0.31 0.32 0.28 0.26 0.21 0.25 0.23 0.22 0.23 0.23 Intangible/Market Cap Ratio US$
Intangibles CDN$ $963 $1,087 $1,228 $1,433 $1,364 $1,540 $1,511 $1,471 $1,712 $2,267 $2,121 $2,866 $2,750 $2,260 123.89% <-Total Growth 10 Intangibles CDN$
Goodwill $234 $192 $245 $5,895 $5,873 $6,864 $7,165 $7,291 $7,845 $9,348 $9,793 $11,440 $11,502 $11,530 4593.67% <-Total Growth 10 Goodwill CDN$
Goodwill and Intangibles CDN$ $1,197 $1,280 $1,473 $7,328 $7,237 $8,404 $8,675 $8,762 $9,557 $11,616 $11,914 $14,306 $14,252 $13,790 867.42% <-Total Growth 10 Total CDN$
Change -1.47% 6.92% 15.11% 397.40% -1.23% 16.12% 3.23% 1.00% 9.08% 21.54% 2.57% 20.07% -0.37% -3.24% 6.15% <-Median-> 10 Change CDN$
Intangible/Market Cap Ratio 0.60 0.49 0.42 0.40 0.31 0.32 0.28 0.26 0.21 0.25 0.23 0.22 0.23 0.23 0.25 <-Median-> 10 Intangible/Market Cap Ratio CDN$
Current Assets US$ $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,226.91 $1,311.56 $1,376.32 376.52% <-Total Growth 10 Current Assets US$
Current Liabilities $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,878.83 $2,124.26 $2,007.47 607.74% <-Total Growth 10 Current Liabilities US$
Liquidity 1.00 0.89 0.92 1.20 1.47 1.27 1.12 1.37 0.84 0.74 0.68 0.65 0.62 0.69 0.98 <-Median-> 10 Ratio US$
Curr Long Term Debt $5.969 $5.428 $0.494 $1.650 $11.659 $1.786 $0.465 $8.268 $6.020 $6.759 $26.462 $7.851 $8.667 $8.355
Liquidity Less CLTD 1.02 0.91 0.92 1.21 1.49 1.27 1.12 1.38 0.84 0.74 0.69 0.66 0.62 0.69 0.69 <-Median-> 5 Liquidity Less CLTD
Assets US$ $3,393 $3,376 $3,245 $11,193 $12,015 $12,627 $13,738 $13,992 $14,700 $17,135 $17,916 $19,818 $21,129 $21,186 551.15% <-Total Growth 10 Assets US$
Liabilities $2,103 $2,148 $2,116 $5,538 $5,741 $6,167 $6,799 $7,129 $7,706 $10,021 $10,218 $11,957 $12,884 $13,129 508.88% <-Total Growth 10 Liabilities US$
Debt Ratio 1.61 1.57 1.53 2.02 2.09 2.05 2.02 1.96 1.91 1.71 1.75 1.66 1.64 1.61 1.94 <-Median-> 10 Ratio US$
Estimates BVPS $33.38 $36.19 $39.74 Estimates Estimates BVPS
Estimate Book Value $8,487.2 $9,201.7 $10,104.3 Estimates Estimate Book Value
P/B Ratio (Close) 4.99 4.60 4.19 Estimates P/B Ratio (Close)
Difference from 10 year median 31.20% Diff M/C Estimates Difference from 10 yr med.
Total Book Value $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,860.4 $8,245.4 $8,057.6 630.39% <-Total Growth 10 Book Value US$
Non-Con Int US$ $0.00 $0.00 $0.00 $7.36 $5.40 $5.58 $4.85 $4.17 $4.61 $4.95 $4.97 $0.00 $0.00 $0.00 Non-Con Int US$ US$
Book Value US$ $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,860.4 $8,245.4 $8,057.6 $8,057.6 $8,057.6 630.39% <-Total Growth 10 Book Value US$
Book Value per Share $23.32 $22.76 $14.36 $21.49 $23.79 $24.53 $26.30 $26.10 $26.86 $27.64 $29.86 $30.46 $32.26 $31.69 $31.69 $31.69 124.56% <-Total Growth 10 Book Value per Share US$
Increase 1.46% -2.38% -36.90% 49.60% 10.71% 3.10% 7.23% -0.77% 2.91% 2.93% 8.03% 2.01% 5.89% -1.76% 0.00% 0.00% 38.19% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 1.40 1.62 2.50 1.98 2.62 2.98 3.21 2.80 4.39 4.93 4.63 5.57 5.66 5.10 5.10 5.10 1.68 P/B Ratio Historical Median US$
P/B Ratio (Close) 1.47 1.83 2.27 2.44 2.98 3.03 3.45 3.93 5.07 4.80 5.00 5.63 5.44 5.25 5.25 5.25 3.22% <-IRR #YR-> 10 Book Value per Share US$
Change 12.94% 24.50% 24.07% 7.41% 22.30% 1.51% 14.04% 13.85% 29.09% -5.49% 4.24% 12.68% -3.48% -3.38% 0.00% 0.00% 4.33% <-IRR #YR-> 5 Book Value per Share US$
Leverage (A/BK) 2.63 2.75 2.87 1.98 1.91 1.95 1.98 2.04 2.10 2.41 2.33 2.52 2.56 2.63 2.07 <-Median-> 10 A/BV US$
Debt/Equity Ratio 1.63 1.75 1.87 0.98 0.91 0.95 0.98 1.04 1.10 1.41 1.33 1.52 1.56 1.63 1.07 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.80 5 yr Med 4.93 38.19% Diff M/C
-$22.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $32.26
-$26.10 $0.00 $0.00 $0.00 $0.00 $32.26
Current Assets CDN$ $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,765.40 $1,797.63 $1,949.14 371.65% <-Total Growth 10 Current Assets CDN$
Current Liabilities $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,703.45 $2,911.51 $2,842.97 600.51% <-Total Growth 10 Current Liabilities CDN$
Liquidity 1.00 0.89 0.92 1.20 1.47 1.27 1.12 1.37 0.84 0.74 0.68 0.65 0.62 0.69 0.98 <-Median-> 10 Ratio CDN$
Liq. with CF aft div 2.43 2.20 2.22 2.16 2.78 2.73 2.48 2.54 2.04 1.92 1.78 1.68 1.60 1.84 1.78 <-Median-> 5 Ratio CDN$
Liq. CF re  Inv+Div  1.30 1.17 1.09 1.51 1.26 1.05 1.03 1.26 0.86 0.63 0.92 0.63 0.82 1.84 0.82 <-Median-> 5 Ratio CDN$
Curr Long Term Debt $6.35 $6.30 $0.68 $2.22 $14.63 $2.44 $0.60 $10.53 $7.63 $9.15 $35.00 $11.30 $11.88 $11.83
Liquidity Less CLTD 1.02 0.91 0.92 1.21 1.49 1.27 1.12 1.38 0.84 0.74 0.69 0.66 0.62 0.69 0.69 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.48 2.24 2.22 2.17 2.82 2.74 2.48 2.56 2.05 1.92 1.80 1.69 1.60 1.85 1.80 <-Median-> 5 Ratio CDN$
Assets CDN$ $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 $23,696 $28,516 $28,960 $30,004 544.50% <-Total Growth 10 Assets CDN$
Liabilities $2,237 $2,491 $2,930 $7,436 $7,202 $8,413 $8,831 $9,077 $9,770 $13,572 $13,514 $17,206 $17,659 $18,593 502.66% <-Total Growth 10 Liabilities CDN$
Debt Ratio 1.61 1.57 1.53 2.02 2.09 2.05 2.02 1.96 1.91 1.71 1.75 1.66 1.64 1.61 1.94 <-Median-> 10 Ratio CDN$
Estimates BVPS $47.27 $51.25 $56.28 Estimates Estimates BVPS
Estimate Book Value $12,019.6 $13,031.4 $14,309.7 Estimates Estimate Book Value
P/B Ratio (Close) 5.01 4.62 4.21 Estimates P/B Ratio (Close)
Difference from 10 year median 25.25% 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 $11,310.3 $11,301.1 $11,411.2
Total Book Value $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 $11,310.3 $11,301.1 $11,411.2 622.93% <-Total Growth 10 Book Value CDN$
Non-Con Int CDN$ $0.00 $0.00 $0.00 $9.88 $6.77 $7.61 $6.30 $5.30 $5.84 $6.70 $6.58 $0.00 $0.00 $0.00 CDN$
Book Value CDN$ $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 $11,310.3 $11,301.1 $11,411.2 $11,411.2 $11,411.2 622.93% <-Total Growth 10 Book Value CDN$
Book Value per Share $24.80 $26.41 $19.89 $28.85 $29.85 $33.46 $34.16 $33.23 $34.05 $37.44 $39.50 $43.83 $44.21 $44.88 $44.88 $44.88 122.26% <-Total Growth 10 Book Value per Share CDN$
Increase 8.09% 6.48% -24.68% 45.06% 3.44% 12.12% 2.08% -2.73% 2.48% 9.96% 5.49% 10.98% 0.86% 1.51% 0.00% 0.00% 31.92% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 1.37 1.58 2.35 2.05 2.71 2.83 3.33 3.62 4.38 4.60 4.70 5.33 5.81 4.96 0.00 0.00 1.76 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 1.47 1.83 2.27 2.43 2.99 3.03 3.45 3.93 5.06 4.79 5.01 5.63 5.44 5.28 5.28 5.28 4.80% <-IRR #YR-> 10 Book Value per Share 122.26% CDN$
Change 13.14% 24.88% 23.90% 7.26% 22.74% 1.36% 14.02% 13.76% 28.89% -5.32% 4.50% 12.30% -3.22% -3.06% 0.00% 0.00% 5.88% <-IRR #YR-> 5 Book Value per Share 33.05% CDN$
Leverage (A/BK) 2.63 2.75 2.87 1.98 1.91 1.95 1.98 2.04 2.10 2.41 2.33 2.52 2.56 2.63 2.07 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.63 1.75 1.87 0.98 0.91 0.95 0.98 1.04 1.10 1.41 1.33 1.52 1.56 1.63 1.07 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 4.00 5 yr Med 4.70 31.92% Diff M/C
-$26.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $44.21
-$33.23 $0.00 $0.00 $0.00 $0.00 $44.21
$1,119.89 <-12 mths -4.38%
Comprehensive Income US$ $84.20 $85.16 $50.45 $216.49 $728.83 $363.96 $630.50 $214.30 $658.72 $739.59 $809.83 $421.66 $1,171.25 2221.61% <-Total Growth 10 Comprehensive Income US$
NCI $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 $0.03 $0.03 $0.00 #DIV/0! <-Total Growth 10 Comprehensive Income US$
Shareholders $84.20 $85.16 $50.45 $215.71 $728.23 $363.67 $630.66 $214.99 $658.28 $739.25 $809.80 $421.63 $1,171.25 2221.61% <-Total Growth 10 Comprehensive Income US$
Increase -22.04% 1.15% -40.76% 327.57% 237.60% -50.06% 73.42% -65.91% 206.19% 12.30% 9.54% -47.93% 177.79% 12.3% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $32.04 $34.86 $22.91 $108.70 $232.75 $288.64 $397.75 $430.65 $519.17 $521.37 $610.60 $568.79 $760.04 36.96% <-IRR #YR-> 10 Comprehensive Income 2221.61% US$
ROE US$ 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 10.5% 5.4% 14.2% 40.36% <-IRR #YR-> 5 Comprehensive Income 444.80% US$
5Yr Median 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 9.4% 9.4% 10.4% 41.93% <-IRR #YR-> 10 5 Yr Running Average 3217.43% US$
% Difference from NI -28.63% -32.69% -59.27% -12.34% 26.14% -33.56% 11.18% 4.97% 6.44% -11.60% 6.09% -31.62% 8.80% 12.03% <-IRR #YR-> 5 5 Yr Running Average 76.49% US$
Median Values Diff 5, 10 yr 5.5% 6.1% 10.4% <-Median-> 5 Return on Equity US$
-$50.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,171.3
-$215.0 $0.0 $0.0 $0.0 $0.0 $1,171.3
-$22.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $760.0
-$430.7 $0.0 $0.0 $0.0 $0.0 $760.0
Current Liability Coverage Ratio US$ 1.47 1.44 1.33 1.20 1.57 1.60 1.50 1.39 1.36 1.29 1.25 1.30 1.26 1.34   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.30 1.29 1.29 1.29 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 11.80% 12.30% 12.67% 12.66% CFO / Total Assets US$
5 year Median 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.80% 12.30% 11.8% <-Median-> 5 Return on Assets  US$
Return on Assets ROA US$ 3.48% 3.75% 3.82% 2.20% 4.80% 4.33% 4.13% 1.46% 4.20% 4.88% 4.26% 3.11% 5.10% 5.56% Net  Income/Assets Return on Assets US$
5Yr Median 2.36% 2.71% 3.48% 3.48% 3.75% 3.82% 4.13% 4.13% 4.20% 4.20% 4.20% 4.20% 4.26% 4.88% 4.3% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ 9.15% 10.30% 10.97% 4.35% 9.20% 8.47% 8.18% 2.98% 8.84% 11.76% 9.92% 7.84% 13.06% 14.63% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 5.99% 7.41% 9.15% 9.15% 9.20% 9.20% 8.47% 8.18% 8.47% 8.47% 8.84% 8.84% 9.92% 11.76% 9.9% <-Median-> 5 Return on Equity US$
Adjusted Net Income $127.15 $153.08 -$6.89 $395.20 $570.67 $667.3 $719.56 $695.79 $846.60 $985.27 $1,081.25 $1,239.29 $1,328.33 90.91% <-Total Growth 7 Net Income US$
$1,054.39 <-12 mths -2.06%
Net Income US$ $117.97 $126.52 $123.88 $246.54 $577.42 $547.15 $566.68 $203.99 $618.49 $836.00 $762.83 $617.57 $1,076.56 769.06% <-Total Growth 10 Net Income US$ US$
NCI $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 $0.03 $1.00 $0.00 #DIV/0! <-Total Growth 10 NCI US$
Shareholders $117.97 $126.52 $123.88 $245.76 $576.82 $546.87 $566.84 $204.68 $618.05 $835.66 $762.80 $616.57 $1,076.56 $1,179 $1,378 $1,536 769.06% <-Total Growth 10 Net Income US$
Increase 25.03% 7.24% -2.09% 98.39% 134.71% -5.19% 3.65% -63.89% 201.96% 35.21% -8.72% -19.17% 74.60% 9.52% 16.88% 11.47% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $27.5 $43.4 $53.3 $141.7 $238.2 $324.0 $412.0 $428.2 $502.7 $554.4 $597.6 $607.6 $781.9 $894.1 $1,002.6 $1,157.2 24.14% <-IRR #YR-> 10 Net Income 769.06% US$
Operating Cash Flow $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 $2,228.93 $2,414.07 39.38% <-IRR #YR-> 5 Net Income 425.98% US$
Investment Cash Flow -$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 -$3,159.18 -$2,023.24 30.81% <-IRR #YR-> 10 5 Yr Running Average 1366.57% US$
Accruals   -$71.00 -$34.76 $19.99 -$253.16 $355.79 $507.46 $452.30 -$157.80 $613.30 $1,900.34 $217.06 $1,546.82 $685.73 12.80% <-IRR #YR-> 5 5 Yr Running Average 82.61% US$
Total Assets $3,393 $3,376 $3,245 $11,193 $12,015 $12,627 $13,738 $13,992 $14,700 $17,135 $17,916 $19,818 $21,129 Balance Sheet Assets US$
Accruals Ratio -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 1.21% 7.81% 3.25% 4.17% <-Median-> 5 Ratio US$
-$123.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,076.6
-$204.7 $0.0 $0.0 $0.0 $0.0 $1,076.6
-$53.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $781.9
-$428.2 $0.0 $0.0 $0.0 $0.0 $781.9
Financial Cash Flow US$ -$183.51 -$94.75 -$98.75 -$354.87 $56.76 -$187.58 -$95.89 -$78.22 -$499.50 $1,028.46 -$544.41 $944.95 -$360.04 C F Statement  Financial Cash Flow US$
Accruals   $112.51 $59.98 $118.74 $101.71 $299.03 $695.03 $548.19 -$79.58 $1,112.80 $871.88 $761.47 $601.87 $1,045.77 Accruals US$
Accruals Ratio 3.32% 1.78% 3.66% 0.91% 2.49% 5.50% 3.99% -0.57% 7.57% 5.09% 4.25% 3.04% 4.95% 4.95% <-Median-> 5 Ratio US$
$1,585.99 <-12 mths -1.20%
Comprehensive Inc CDN$ $89.55 $98.80 $69.86 $290.68 $914.32 $496.51 $818.90 $272.85 $835.13 $1,001.70 $1,071.08 $606.73 $1,605.32 2197.90% <-Total Growth 10 Comprehensive Income CDN$
NCI $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46 $0.03 $0.04 $0.00 #DIV/0! <-Total Growth 10 NCI CDN$
Shareholders $89.55 $98.80 $69.86 $289.63 $913.57 $496.12 $819.11 $273.72 $834.57 $1,001.24 $1,071.05 $606.69 $1,605.32 2197.90% <-Total Growth 10 Comprehensive Income CDN$
Increase -16.94% 10.32% -29.29% 314.59% 215.42% -45.69% 65.10% -66.58% 204.89% 19.97% 6.97% -43.36% 164.60% 19.97% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $32.81 $37.64 $29.64 $131.13 $292.28 $373.60 $517.66 $558.43 $667.42 $684.95 $799.94 $757.45 $1,023.77 36.81% <-IRR #YR-> 10 Comprehensive Income 2197.90% CDN$
ROE CDN$ 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 10.5% 5.4% 14.2% 42.45% <-IRR #YR-> 5 Comprehensive Income 486.47% CDN$
5Yr Median 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 9.4% 9.4% 10.4% 42.50% <-IRR #YR-> 10 5 Yr Running Average 3353.53% CDN$
% Difference from NI -28.6% -32.7% -59.3% -12.3% 26.1% -33.6% 11.2% 5.0% 6.4% -11.6% 6.1% -31.6% 8.8% 12.89% <-IRR #YR-> 5 5 Yr Running Average 83.33% CDN$
Median Values Diff 5, 10 yr 5.5% 6.1% 10.39% <-Median-> 5 Return on Equity CDN$
-$69.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,605.32
-$273.72 $0.00 $0.00 $0.00 $0.00 $1,605.32
-$29.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,023.77
-$558.43 $0.00 $0.00 $0.00 $0.00 $1,023.77
Current Liability Coverage Ratio CDN$ 1.47 1.44 1.33 1.20 1.57 1.60 1.50 1.39 1.36 1.29 1.25 1.30 1.26 1.34   CFO / Current Liabilities CDN$
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.30 1.29 1.29 1.29 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 11.80% 12.30% 12.67% 12.66% CFO / Total Assets CDN$
5 year Median 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.80% 12.30% 11.8% <-Median-> 5 Return on Assets  CDN$
Comments
Comments
Return on Assets ROA CDN$ 3.5% 3.7% 3.8% 2.2% 4.8% 4.3% 4.1% 1.5% 4.2% 4.9% 4.3% 3.1% 5.1% 5.6% Net  Income/Assets Return on Assets CDN$
5Yr Median 2.4% 2.7% 3.5% 3.5% 3.7% 3.8% 4.1% 4.1% 4.2% 4.2% 4.2% 4.2% 4.3% 4.9% 4.3% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 9.1% 10.3% 11.0% 4.4% 9.2% 8.5% 8.2% 3.0% 8.8% 11.8% 9.9% 7.8% 13.1% 14.6% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 6.0% 7.4% 9.1% 9.1% 9.2% 9.2% 8.5% 8.2% 8.5% 8.5% 8.8% 8.8% 9.9% 11.8% 9.9% <-Median-> 5 Return on Equity CDN$
$1,493.23 <-12 mths 1.20%
Net Income CDN$ $125.47 $146.77 $171.54 $331.03 $724.37 $746.43 $736.01 $259.72 $784.12 $1,132.28 $1,008.91 $888.63 $1,475.53
NCI $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46 $0.03 $1.44 $0.00
Shareholders $125.47 $146.77 $171.54 $329.98 $723.62 $746.04 $736.21 $260.59 $783.56 $1,131.82 $1,008.88 $887.18 $1,475.53 $1,670 $1,952 $2,175 760.18% <-Total Growth 10 Net Income CDN$
Increase 33.20% 16.97% 16.87% 92.37% 119.29% 3.10% -1.32% -64.60% 200.68% 44.45% -10.86% -12.06% 66.32% 13.16% 16.88% 11.47% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $28.5 $48.0 $67.5 $173.6 $299.5 $423.6 $541.5 $559.3 $650.0 $731.6 $784.2 $814.4 $1,057.4 $1,234.6 $1,398.6 $1,631.8 24.01% <-IRR #YR-> 10 Net Income 760.18% CDN$
Operating Cash Flow $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 $3,207.20 $3,308.72 41.45% <-IRR #YR-> 5 Net Income 466.22% CDN$
Investment Cash Flow -$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 -$4,545.74 -$2,773.06 31.67% <-IRR #YR-> 10 5 Yr Running Average 1465.77% CDN$
Accruals   -$75.51 -$40.33 $27.68 -$339.92 $446.34 $692.27 $587.45 -$200.91 $777.54 $2,573.82 $287.09 $2,225.72 $939.86 13.58% <-IRR #YR-> 5 5 Yr Running Average 89.06% CDN$
Total Assets $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 $23,696 $28,516 $28,960 Balance Sheet Assets CDN$
Accruals Ratio -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 1.21% 7.81% 3.25% 4.17% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.24 0.24 0.42 0.34 0.46 0.39 0.37 0.14 0.37 0.43 0.36 0.25 0.40 0.37 <-Median-> 10 EPS/CF Ratio CDN$
-$171.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,475.5
-$260.6 $0.0 $0.0 $0.0 $0.0 $1,475.5
-$67.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,057.4
-$559.3 $0.0 $0.0 $0.0 $0.0 $1,057.4
Change in Close 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 10.24% 24.63% -2.38% -1.60% 0.00% 0.00% Count 25 Years of data CDN$
up/down down down down Count 10 40.00% CDN$
Meet Prediction? yes % right Count 2 20.00% CDN$
Financial Cash Flow CDN$ -$195.18 -$109.92 -$136.74 -$476.48 $71.21 -$255.89 -$124.55 -$99.59 -$633.26 $1,392.95 -$720.03 $1,359.68 -$493.47 C F Statement  Financial CF CDN$
Accruals   $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 $866.04 $1,433.34 Accruals CDN$
Accruals Ratio 3.32% 1.78% 3.66% 0.91% 2.49% 5.50% 3.99% -0.57% 7.57% 5.09% 4.25% 3.04% 4.95% 4.95% <-Median-> 5 Ratio CDN$
Cash US$ $31.98 $41.64 $35.78 $154.38 $433.82 $403.97 $423.22 $423.22 $219.62 $181.36 $184.04 $198.17 $229.58 $322.65 Cash US$
Cash CDN$ $34.01 $48.30 $49.55 $207.29 $544.22 $551.09 $549.68 $538.84 $278.43 $245.64 $243.41 $285.15 $314.66 $456.93 Cash CDN$
Cash per Share CDN$ $0.62 $0.89 $0.63 $0.79 $2.07 $2.09 $2.09 $2.05 $1.07 $0.96 $0.94 $1.11 $1.23 $1.80 $1.07 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 1.69% 1.85% 1.40% 1.12% 2.32% 2.07% 1.77% 1.57% 0.62% 0.53% 0.48% 0.45% 0.51% 0.76% 0.51% <-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.42 $0.48 $0.18 $0.62
Split in June 2017 $0.12
Dividend US$ $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $1.30 955.71% <-Total Growth 10 Dividends US$
Increase 12.16% 14.46% -61.26% 234.24% 21.95% 16.00% 14.66% 14.29% 11.18% 11.83% 11.11% 11.43% 10.68% Count 17 Years of data US$
Dividends 5 Yr Running $0.17 $0.22 $0.23 $0.27 $0.33 $0.39 $0.46 $0.58 $0.67 $0.76 $0.85 $0.95 $1.06 226.26% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 0.85% 0.86% 0.34% 0.96% 0.80% 0.79% 0.79% 1.04% 0.72% 0.69% 0.76% 0.69% 0.71% 0.77% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 0.74% 0.74% 0.29% 0.78% 0.69% 0.72% 0.70% 0.73% 0.61% 0.65% 0.70% 0.61% 0.65% 0.70% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 0.99% 1.02% 0.42% 1.26% 0.95% 0.88% 0.90% 1.83% 0.87% 0.74% 0.82% 0.80% 0.78% 0.88% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 0.81% 0.76% 0.38% 0.78% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.70% 0.68% 0.74% 0.72% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 14.15% 15.02% 5.71% 38.44% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 48.95% 31.06% 33.33% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 50.64% 39.90% 13.22% 23.22% 26.43% 30.30% 34.62% 46.14% 44.33% 44.62% 45.77% 49.91% 42.85% 43.59% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 3.39% 3.79% 2.32% 13.55% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.72% 13.54% 13.71% 12.83% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 4.23% 4.58% 1.76% 6.64% 8.53% 10.93% 13.84% 15.77% 15.31% 15.26% 15.51% 15.96% 15.90% 15.29% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 3.45% 3.59% 2.41% 12.97% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.80% 12.38% 12.36% 12.42% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 4.03% 4.26% 1.66% 6.30% 8.37% 10.71% 13.85% 15.59% 15.27% 15.51% 15.70% 15.75% 15.36% 15.31% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median values 10 Yr Med 10 Yr Cl 0.77% 0.72% 5 Yr Med 5 Yr Cl 0.71% 0.70% 5 Yr Med Payout 35.59% 12.95% 12.46% 11.25% <-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% 26.58% <-IRR #YR-> 10 Dividends US$
Dividends Growth 15 15.45% <-IRR #YR-> 13 Dividends
Dividends Growth 5 -$0.76 $0.00 $0.00 $0.00 $0.00 $1.30
Dividends Growth 10 -$0.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.30
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.30
Price Close US$ Waste Connection $29.09 $29.33 $37.55 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $171.58 $175.36 $166.45 $166.45 $166.45 367.05% <-Total Growth 10 Stock Price US$
Increase 29.12% 0.83% 28.03% 39.54% 35.40% 4.67% 22.28% 12.97% 32.86% -2.72% 12.61% 14.95% 2.20% -5.08% 0.00% 0.00% 11.32% <-IRR #YR-> 5 Stock Price 70.97% US$
P/E 3.55% <-IRR #YR-> 10 Stock Price 367.05% US$
Trailing P/E 12.15% <-IRR #YR-> 5 Price & Dividend US$
Median 10, 5 Yrs D.  per yr 0.77% 0.83% % Tot Ret 17.76% 6.79% T P/E #NUM! P/E:  #NUM! #NUM! 4.32% <-IRR #YR-> 10 Price & Dividend US$
Price  15 16.24% <-IRR #YR-> 15 Stock Price
Price  20 15.00% <-IRR #YR-> 19 Stock Price
Price & Dividend 15 17.24% <-IRR #YR-> 15 Price & Dividend
Price & Dividend 20 15.79% <-IRR #YR-> 19 Price & Dividend
Price 5 -$102.57 $0.00 $0.00 $0.00 $0.00 $175.36
Price 10 -$37.55 $0.00 $0.00 $0.00 $0.00 -$102.57 $0.00 $0.00 $0.00 $0.00 $175.36
Price & Dividend 5 -$102.57 $0.85 $0.95 $1.05 $1.17 $176.66
Price & Dividend 10 -$37.55 $0.41 $0.50 $0.58 $0.67 -$102.57 $0.85 $0.95 $1.05 $1.17 $176.66
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 $175.36
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 $175.36
Price & Dividend 15 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $176.66
Price & Dividend 20 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $176.66
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 23, 2026.  Last estimates were for 2025, 2026, 2027 in US$ of $9530M, $10170M, $10878M Revenue, $5.22, $5.97, $6.88 AEPS, $4.64, $5.48, $6.35 EPS, 
$1.28, $1.38, $1.51 Dividends, $1329M, $1640M, $1909M FCF, $8.24, $9.15 2025/6 CFPS, $3163M, $3435M, $3757M EBITDA, $32.68, $34.96, $37.87 BVPS, $1196M, $1390M, $1599M Net Income.
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 because it became 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 a North American waste management company focused on integrated waste collection services. Revenue is 
split among six operating segments: Western, Southern, Eastern, Central, Canada, and Midsouth.   
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 2018 Jun 14 2019 Jun 13 2020 Jun 13 2021 Jun 12 2022 Jun 12 2023 Jun 14 2024 Jun 9 2024 Jun 23 2026
Mittelstaedt, Ronald J.  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% 0.236 0.09% 0.301 0.12% 27.57%
CEO - Shares - Amount $10.180 $16.409 $25.011 $32.791 $36.883 $43.598 $54.927 $58.187 $71.305
Options - percentage 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% 0.065 0.03% 0.083 0.03% 28.04%
Options - amount $42.061 $32.335 $23.009 $16.597 $10.799 $10.202 $17.884 $16.056 $19.747
Jackman, Worthing F. 0.04% 0.117 0.04% 0.113 0.04% 0.123 0.05% 0.129 0.05%
CEO - Shares - Amount $10.913 $13.795 $14.780 $21.189 $23.112
Options - percentage 0.02% 0.048 0.02% 0.000 0.00% 0.079 0.03% 0.092 0.04%
Options - amount $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% 0.056 0.02% 0.062 0.02% 11.61%
CFO - Shares - Amount $4.595 $5.716 $8.156 $8.980 $11.152 $16.078 $13.795 $14.790
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% 0.022 0.01% 0.023 0.01% 1.92%
Options - amount $2.096 $2.565 $4.606 $5.381 $5.902 $6.338 $5.535 $5.420
Chambkiss, Darrell W. 0.099 0.04% 0.097 0.04% 0.099 0.04% 0.095 0.04%
Officer - Shares - Amount $17.825 $19.117 $24.428 $23.427
Options - percentage 0.034 0.01% 0.032 0.01% 0.035 0.01% 0.022 0.01%
Options - amount $6.112 $6.294 $8.722 $5.545
Black, Matthew Stephen 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% 0.038 0.01% 0.044 0.02% 13.82%
Officer - Shares - Amount $2.291 $3.192 $3.933 $5.578 $6.249 $6.256 $8.238 $9.428 $10.308
Options - percentage 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% 0.014 0.01% 0.013 0.01% -6.19%
Options - amount $1.843 $2.098 $2.124 $3.131 $3.271 $3.651 $5.247 $3.526 $3.178
Little, James M. 0.029 0.01% 0.028 0.01% 0.043 0.02% 0.048 0.02% 12.43%
Officer - Shares - Amount $5.819 $6.958 $10.624 $11.473
Options - percentage 0.162 0.06% 0.028 0.01% 0.018 0.01% 0.018 0.01% 0.63%
Options - amount $31.983 $6.977 $4.527 $4.376
Craft, Jason Jon 0.033 0.01% #DIV/0!
Officer - Shares - Amount $7.784
Options - percentage 0.015 0.01% #DIV/0!
Options - amount $3.608
Jordan, Elise Lipman 0.003 0.00% 0.003 0.00%
Director - Shares - Amount $0.654 $0.724
Options - percentage 0.003 0.00% 0.003 0.00%
Options - amount $0.748 $0.823
Guillet, Edward E.  0.061 0.02% 0.042 0.02% 0.032 0.01% 0.033 0.01% 0.033 0.01% 0.032 0.01% 0.024 0.01% 0.015 0.01% -36.48%
Director - Shares - Amount $7.218 $5.451 $5.576 $5.895 $6.580 $7.793 $5.890 $3.594
Options - percentage 0.003 0.00% 0.003 0.00% 0.004 0.00% 0.004 0.00% 0.004 0.00% 0.005 0.00% 0.005 0.00% 0.005 0.00% 10.30%
Options - amount $0.318 $0.391 $0.606 $0.674 $0.830 $1.120 $1.194 $1.265
Lee, Susan 0.012 0.00% 0.012 0.00% 2.42%
Director - Shares - Amount $2.938 $2.891
Options - percentage 0.005 0.00% 0.008 0.00% 59.80%
Options - amount $1.291 $1.982
Harlan, Michael W. 0.009 0.00% 0.008 0.00% 0.008 0.00% 0.000 0.00% Was Director, chair 2025 -100.00%
Chariman - Shares - Amount $1.763 $1.972 $2.042 $0.000
Options - percentage 0.004 0.00% 0.005 0.00% 0.005 0.00% 0.000 0.00% -100.00%
Options - amount $0.830 $1.120 $1.194 $0.000
Director - Shares - Amount
Options - percentage
Options - amount
Increase in O/S Shares 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% 0.521 0.20% 0.445 0.17% Waste Connections' Equity
due to SO 2013 $61.645 $65.097 $72.342 $89.021 $89.172 $71.081 $119.905 $128.438 $109.749
Book Value $23.701 $2.667 $39.000 $39.762 $48.710 $62.952 $71.217 $74.603 $79.120
Insider Buying -$0.206 $0.000 $0.000 $0.000 $0.000 -$0.020 $0.004 $0.000 -$10.436
Insider Selling $17.895 $4.023 $15.515 $22.133 $4.704 $6.658 $6.928 $18.788 $9.009
Net Insider Selling 2013 $17.689 $4.023 $15.515 $22.133 $4.704 $6.639 $6.932 $18.788 -$1.427
% of Market Cap 0.07% 0.01% 0.05% 0.05% 0.01% 0.01% 0.01% 0.03% 0.00%
On May 28 2014
Increase in O/S Shares
due to RS 2013
Book Value
Increase in O/S Shares
Total Increase 2013
Book Value
Directors  6 8 8 8 8 8 8 8
Women 14% 1 17% 2 25% 2 25% 2 25% 3 38% 3 38% 4 50% 3 38% Company says they have
Minorities 0% 0 0% 0 0% 0 0% 1 13% 1 13% 1 13% 1 13% 2 25% a visible minority on the board
Institutions/Holdings 90.93% 669 93.04% 20 76.12% 20 76.12% 20 52.67% 20 64.30% 20 51.49% 20 60.51%
Total Shares Held 91.04% 245.328 93.06% 199.183 76.55% 199.183 76.55% 135.660 52.13% 165.872 63.74% 133.057 52.05% 153.745 60.47%
Increase/Decrease 0.43% 1.602 0.66% 8.664 4.55% 8.664 4.55% -5.385 -3.82% -3.935 -2.32% -4.578 -3.33% 29.922 24.16%
Starting No. of Shares 243.726 190.519 190.519 141.046 169.807 137.634 123.823
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock