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 2025
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/
Waste Connections Inc TSX: WCN NYSE: WCN https://investors.wasteconnections.com/ Fiscal Yr: Dec 31
Year 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 12/31/20 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27 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 IFRS IFRS IFRS IFRS IFRS Accounting Rules
USD - CDN$ 0.9983 1.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2732 1.2678 1.3544 1.3226 1.4389 1.3728 1.3728 1.3728 24.03% <-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,075.1 <-12 mths 1.74%
Revenue* US$ $1,896.7 $2,026.0 $2,009.0 $1,925.6 $3,375.9 $4,630.5 $4,922.9 $5,388.7 $5,446.0 $6,151.4 $7,211.9 $8,022.0 $8,919.6 $9,530 $10,170 $10,878 343.98% <-Total Growth 10 Revenue US$
Increase 3.08% 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.84% 6.72% 6.96% 16.07% <-IRR #YR-> 10 Revenue 343.98% US$
5 year Running Average $1,417.4 $1,640.2 $1,840.3 $1,939.5 $2,246.6 $2,793.4 $3,372.8 $4,048.7 $4,752.8 $5,307.9 $5,824.2 $6,444.0 $7,150.2 $7,967.0 $8,770.7 $9,503.9 10.60% <-IRR #YR-> 5 Revenue 65.52% US$
Revenue per Share $34.26 $36.64 $37.22 $24.50 $12.85 $17.57 $18.71 $20.44 $20.72 $23.64 $28.05 $31.14 $34.57 $36.94 $39.42 $42.16 14.54% <-IRR #YR-> 10 5 yr Running Average 288.53% US$
Increase 5.81% 6.95% 1.59% -34.16% -47.57% 36.80% 6.46% 9.26% 1.37% 14.09% 18.64% 11.04% 11.01% 6.84% 6.72% 6.96% 12.05% <-IRR #YR-> 5 5 yr Running Average 76.60% US$
5 year Running Average $29.89 $30.63 $32.99 $33.00 $29.09 $25.75 $22.17 $18.81 $18.06 $20.22 $22.31 $24.80 $27.62 $30.87 $34.02 $36.84 -0.74% <-IRR #YR-> 10 Revenue per Share -7.11% US$
P/S (Price/Sales) Med 0.82 0.89 0.99 1.46 3.31 3.55 3.91 4.13 3.53 4.99 4.86 4.44 4.91 5.01 4.69 4.39 11.08% <-IRR #YR-> 5 Revenue per Share 69.12% US$
P/S (Price/Sales) Close 0.87 0.94 1.12 1.33 4.08 4.04 3.97 4.44 4.95 5.76 4.73 4.79 4.96 5.11 4.79 4.48 -1.76% <-IRR #YR-> 10 5 yr Running Average -16.26% US$
*Revenue in M CDN $  P/S Med 20 yr  1.36 15 yr  3.53 10 yr  4.02 5 yr  4.86 27.19% Diff M/C 7.98% <-IRR #YR-> 5 5 yr Running Average 46.82% US$
$12,458.3 <-12 mths -2.93%
Revenue* CDN $1,893.5 $2,154.9 $2,330.6 $2,666.5 $4,532.8 $5,808.9 $6,715.9 $6,998.8 $6,933.8 $7,798.7 $9,767.7 $10,609.8 $12,834.4 $13,083 $13,961 $14,933 450.68% <-Total Growth 10 Revenue CDN$
Increase 0.76% 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.94% 6.72% 6.96% 18.60% <-IRR #YR-> 10 Revenue 450.68% CDN$
5 year Running Average $1,474.9 $1,682.4 $1,936.8 $2,185.0 $2,715.7 $3,498.7 $4,410.9 $5,344.6 $6,198.0 $6,851.2 $7,643.0 $8,421.8 $9,588.9 $10,818.7 $12,051.2 $13,084.3 12.89% <-IRR #YR-> 5 Revenue 83.38% CDN$
Revenue per Share $34.20 $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.70 $54.11 $57.88 17.35% <-IRR #YR-> 10 5 yr Running Average 395.10% CDN$
Increase 3.42% 13.94% 10.80% -21.41% -49.17% 27.82% 15.77% 4.02% -0.63% 13.60% 26.74% 8.43% 20.77% 1.94% 6.72% 6.96% 12.40% <-IRR #YR-> 5 5 yr Running Average 79.41% CDN$
5 year Running Average $31.73 $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.92 $46.75 $50.72 1.43% <-IRR #YR-> 10 Revenue per Share 15.21% CDN$
P/S (Price/Sales) Med 0.83 0.87 0.97 1.38 3.42 3.67 3.71 4.28 4.56 4.98 4.53 4.51 4.70 5.19 0.00 0.00 13.38% <-IRR #YR-> 5 Revenue per Share 87.36% CDN$
P/S (Price/Sales) Close 0.87 0.93 1.12 1.33 4.07 4.04 3.97 4.44 4.95 5.75 4.72 4.80 4.96 5.10 4.78 4.47 0.64% <-IRR #YR-> 10 5 yr Running Average 6.61% CDN$
*Revenue in M CDN $  P/S Med 10 yr  4.40 5 yr  4.56 15.95% Diff M/C 8.14% <-IRR #YR-> 5 5 yr Running Average 47.87% CDN$
-$2,330.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $12,834.4
-$6,998.8 $0.0 $0.0 $0.0 $0.0 $12,834.4
-$1,936.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $9,588.9
-$5,344.6 $0.0 $0.0 $0.0 $0.0 $9,588.9
$10,263.7 <-12 mths 728.19%
$4.88 <-12 mths 1.88%
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 387.46% <-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
Adjusted Net Income per Share* US$$ $1.34 $1.79 $2.04 $1.98 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $4.79 $5.22 $5.97 $6.88 134.80% <-Total Growth 10 Earnings per Share US$
Increase -13.39% 33.28% 13.97% -2.94% -13.34% 26.13% 16.44% 7.94% -2.94% 22.35% 18.27% 9.69% 14.32% 8.98% 14.37% 15.24% 10 0 10 Years of Data, EPS P or N 100.00% US$
Earnings Yield 4.5% 5.2% 4.9% 6.1% 3.3% 3.1% 3.4% 3.0% 2.6% 2.4% 2.9% 2.8% 2.8% 2.8% 3.2% 3.6% 8.91% <-IRR #YR-> 10 Earnings per Share 134.80% US$
5 year Running Average $1.24 $1.39 $1.61 $1.74 $1.77 $1.94 $2.08 $2.22 $2.35 $2.65 $2.99 $3.32 $3.73 $4.25 $4.80 $5.41 11.98% <-IRR #YR-> 5 Earnings per Share 76.10% US$
Payout Ratio 27.85% 19.96% 17.18% 16.05% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 25.06% 24.43% 24.14% 21.11% 18.31% 8.79% <-IRR #YR-> 10 5 yr Running Average 114.51% US$
5 year Running Average 42.40% 28.75% 22.04% 20.17% 21.48% 20.96% 21.63% 23.14% 25.60% 25.24% 25.42% 25.69% 25.55% 24.80% 23.70% 22.18% 10.96% <-IRR #YR-> 5 5 yr Running Average 68.20% US$
Price/AFFO Median 20.89 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.43 30.97 26.88 30.03 <-Median-> 10 Price/AEPS Median US$
Price/AFFO High 23.56 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.30 33.49 29.06 35.26 <-Median-> 10 Price/AEPS High US$
Price/AFFO Low 18.22 15.57 15.15 14.87 18.97 24.28 26.03 27.21 15.71 30.20 33.34 30.39 30.63 32.55 28.46 24.69 26.62 <-Median-> 10 Price/AEPS Low US$
Price/AFFO Close 22.27 19.14 20.42 16.47 30.54 32.78 29.46 33.38 38.85 42.19 34.70 35.63 35.82 36.17 31.63 27.45 34.04 <-Median-> 10 Price/AEPS Close US$
Trailing P/AFFO Close 19.29 25.52 23.27 15.98 26.46 41.34 34.31 36.03 37.71 51.62 41.04 39.08 40.95 39.42 36.17 31.63 38.39 <-Median-> 10 Trailing P/AEPSClose US$
* ESP per share (US$) Historical   in order 27.08 34.13 21.30 31.88 P/CF 5 Yrs   in order 35.44 39.65 30.39 35.82 2.07% Diff M/C 20.46% Diff M/C 10 DPR 75% to 95% best US$
For 2018 in report on 4th Q results.
$14,090.1 <-12 mths 690.15%
$6.70 <-12 mths -2.80%
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 504.61% <-Total Growth 10 Earnings per Share
Adjusted Net Income per Share* CDN$ $1.34 $1.90 $2.37 $2.74 $2.30 $2.72 $3.44 $3.53 $3.36 $4.09 $5.17 $5.54 $6.89 $7.17 $8.20 $9.44 191.23% <-Total Growth 10 Earnings per Share CDN$
Increase -15.34% 42.00% 24.31% 15.85% -15.97% 17.85% 26.62% 2.76% -4.85% 21.83% 26.34% 7.11% 24.37% 3.97% 14.37% 15.24% 10 0 10 Years of Data, EPS P or N 100.00% CDN$
Earnings Yield 4.5% 5.2% 4.9% 6.1% 3.3% 3.0% 3.4% 3.0% 2.6% 2.4% 2.9% 2.8% 2.8% 2.8% 3.2% 3.7% 11.28% <-IRR #YR-> 10 Earnings per Share 191.23% CDN$
5 year Running Average $1.31 $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.77 $6.59 $7.45 14.30% <-IRR #YR-> 5 Earnings per Share 95.10% CDN$
Payout Ratio 27.85% 19.96% 17.18% 16.05% 29.45% 23.10% 23.02% 24.45% 28.79% 26.16% 24.74% 25.06% 24.43% 24.14% 21.11% 18.31% 11.41% <-IRR #YR-> 10 5 yr Running Average 152.24% CDN$
5 year Running Average 44.34% 28.80% 21.83% 19.76% 21.38% 21.05% 21.70% 23.09% 25.59% 25.21% 25.38% 25.67% 25.50% 24.78% 23.69% 22.18% 11.21% <-IRR #YR-> 5 5 yr Running Average 70.14% CDN$
Price/FFO Median 21.25 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.72 0.00 0.00 32.74 <-Median-> 10 Price/AEPS Median CDN$
Price/FFO High 23.75 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.29 0.00 0.00 36.28 <-Median-> 10 Price/AEPS High CDN$
Price/FFO Low 18.74 15.05 14.59 14.75 20.33 25.37 24.09 28.00 30.28 30.14 28.74 30.86 28.39 34.16 0.00 0.00 28.20 <-Median-> 10 Price/AEPS Low CDN$
Price/FFO Close 22.18 19.10 20.44 16.46 30.48 32.84 29.48 33.39 38.83 42.10 34.69 35.70 35.78 36.07 31.54 27.37 34.04 <-Median-> 10 Price/AEPS Close CDN$
Trailing P/FFO Close 18.78 27.13 25.40 19.07 25.61 38.70 37.32 34.31 36.95 51.29 43.83 38.24 44.50 37.51 36.07 31.54 37.78 <-Median-> 10 Trailing P/AEPSClose CDN$
* ESP per share  Historical   in order 29.25 34.40 24.09 30.48 P/CF 5 Yrs   in order 33.92 39.45 30.14 35.78 6.34% Diff M/C 10.19% Diff M/C 10 DPR 75% to 95% best CDN$
-$2.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.89
-$3.53 $0.00 $0.00 $0.00 $0.00 $6.89
-$1.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.01
-$2.95 $0.00 $0.00 $0.00 $0.00 $5.01
$3.23 <-12 mths 35.19%
Difference Basic and Diluted -38.45% -38.45% -38.45% -38.45% 0.62% 0.46% 0.00% 0.47% 0.00% 0.42% 0.31% 0.34% 0.00% 0.32% <-Median-> 1 Difference Basic and Diluted
Pre-Split 2016 $0.81 $1.02 $1.10 $1.12
Pre-Split 2017 $1.68 $2.12 $2.28 $2.33 $1.61
EPS Basic US$ $1.12 $1.41 $1.52 $1.55 $1.07 $2.19 $2.07 $2.15 $0.78 $2.37 $3.25 $2.96 $2.39 56.93% <-Total Growth 10 EPS Basic US$
Pre-Split 2016 $0.81 $1.02 $1.10 $1.12
Pre-Split 2017 $2.33 $2.93 $3.16 $3.22 $1.60
EPS Diluted* $1.55 $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.64 $5.48 $6.35 13.34% <-Total Growth 10 EPS Diluted US$
Increase -149.69% 25.93% 7.84% 1.82% -50.32% 104.38% -5.05% 3.38% -63.55% 202.56% 37.29% -8.95% -18.98% 94.06% 18.09% 15.99% 10 0 10 Years of Data, EPS P or N 100.00% US$
Earnings Yield 5.2% 5.4% 4.4% 4.8% 1.5% 2.4% 2.0% 1.8% 0.6% 1.4% 1.8% 1.5% 1.0% 1.8% 2.1% 2.5% 1.26% <-IRR #YR-> 10 Earnings per Share 13.34% US$
5 year Running Average $0.43 $0.55 $0.79 $0.93 $1.77 $1.89 $1.91 $1.92 $1.65 $1.91 $2.12 $2.29 $2.34 $3.12 $3.74 $4.36 2.23% <-IRR #YR-> 5 Earnings per Share 11.68% US$
10 year Running Average $0.69 $0.81 $0.89 $1.06 $1.06 $1.16 $1.23 $1.36 $1.29 $1.84 $2.00 $2.10 $2.13 $2.38 $2.82 $3.24 11.44% <-IRR #YR-> 10 5 yr Running Average 195.36% US$
* Diluted ESP per share  E/P 10 Yrs 1.66% 5Yrs 1.37% 4.06% <-IRR #YR-> 5 5 yr Running Average 22.04% US$
$4.44 <-12 mths 28.98%
Difference Basic and Diluted -38.45% -38.45% -38.45% -38.45% 0.62% 0.46% 0.00% 0.47% 0.00% 0.42% 0.31% 0.34% 0.00% 0.32% <-Median-> 0 Difference Basic and Diluted
EPS Basic CDN$ $1.12 $1.50 $1.77 $2.15 $1.44 $2.75 $2.82 $2.79 $0.99 $3.00 $4.40 $3.91 $3.44 94.64% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* $1.55 $2.08 $2.45 $2.97 $1.43 $2.73 $2.82 $2.78 $0.99 $2.99 $4.39 $3.90 $3.44 $6.37 $7.52 $8.72 40.58% <-Total Growth 10 EPS Diluted CDN$
Increase -148.57% 34.16% 17.63% 21.53% -51.83% 90.95% 3.26% -1.57% -64.27% 201.28% 46.67% -11.09% -11.86% 85.14% 18.09% 15.99% 10 0 10 Years of Data, EPS P or N 100.00% CDN$
Earnings Yield 5.2% 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.5% 2.9% 3.4% 3.46% <-IRR #YR-> 10 Earnings 40.58% CDN$
5 year Running Average $0.49 $0.57 $0.87 $1.17 $2.10 $2.33 $2.48 $2.55 $2.15 $2.46 $2.80 $3.01 $3.14 $4.22 $5.12 $5.99 4.35% <-IRR #YR-> 5 Earnings 23.73% CDN$
10 year Running Average $0.79 $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.19 $3.79 $4.39 13.69% <-IRR #YR-> 10 5 yr Running Average 260.72% CDN$
* Diluted ESP per share  E/P 10 Yrs 2.20% 5Yrs 1.74% 4.28% <-IRR #YR-> 5 5 yr Running Average 23.31% CDN$
-$2.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.44
-$2.78 $0.00 $0.00 $0.00 $0.00 $3.44
-$0.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.14
-$2.55 $0.00 $0.00 $0.00 $0.00 $3.14
Dividend US$, Pd US$ from 2017 $1.28 $1.38 $1.51 Estimates Dividend US$, Pd US$ fr 2017
Increase 9.32% 8.13% 9.04% Estimates Increase
Payout Ratio EPS 27.58% 25.25% 23.74% 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.37 $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.26 $1.26 $1.26 233.77% <-Total Growth 10 Dividends US$
Increase 5.12% -4.46% -1.88% -9.36% 59.06% -1.07% 16.00% 14.66% 14.29% 11.18% 11.83% 11.11% 11.43% 7.69% 0.00% 0.00% 15 7 22 Years of data, Count P, N 68.18% US$
Average Increases 5 Year Running -18.31% -15.34% -7.47% -0.84% 9.69% 8.46% 12.55% 15.86% 20.59% 11.01% 13.59% 12.61% 11.97% 10.65% 8.41% 6.05% 12.26% <-Median-> 10 Average Incr 5 Year Running US$
Dividends 5 Yr Running $0.53 $0.40 $0.35 $0.35 $0.38 $0.41 $0.45 $0.51 $0.60 $0.67 $0.76 $0.85 $0.95 $1.05 $1.14 $1.20 169.21% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 1.33% 1.10% 0.95% 0.89% 1.19% 0.80% 0.79% 0.79% 1.04% 0.72% 0.69% 0.76% 0.69% 0.68% 0.79% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 1.18% 0.96% 0.82% 0.75% 0.96% 0.69% 0.72% 0.70% 0.73% 0.61% 0.65% 0.70% 0.61% 0.63% 0.70% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 1.53% 1.28% 1.13% 1.08% 1.55% 0.95% 0.88% 0.90% 1.83% 0.87% 0.74% 0.82% 0.80% 0.74% 0.89% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 1.25% 1.04% 0.84% 0.97% 0.96% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.70% 0.68% 0.67% 0.67% 0.67% 0.72% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 24.08% 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 48.95% 27.17% 23.01% 19.83% 33.33% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 122.59% 73.33% 44.65% 37.84% 21.57% 21.47% 23.54% 26.74% 36.55% 35.15% 35.84% 37.18% 40.70% 33.83% 30.41% 27.51% 35.49% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 6.15% 4.38% 4.20% 6.02% 16.70% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.72% 13.54% 12.74% 11.35% #DIV/0! 12.37% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 8.42% 6.13% 5.13% 5.04% 6.17% 6.93% 8.50% 10.69% 12.49% 12.14% 12.26% 12.60% 13.02% 12.80% 12.43% #DIV/0! 11.42% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 5.02% 4.46% 3.97% 6.25% 15.99% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.80% 12.38% 12.74% 11.35% #DIV/0! 12.42% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 7.84% 5.83% 4.76% 4.76% 5.86% 6.80% 8.32% 10.70% 12.35% 12.11% 12.46% 12.76% 12.84% 12.67% 12.30% #DIV/0! 11.41% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median values 10 Yr Med 10 Yr Cl 0.79% 0.72% 5 Yr Med 5 Yr Cl 0.72% 0.70% 5 Yr Med Payout 35.81% 12.95% 12.80% 11.96% <-IRR #YR-> 5 Dividends 75.94% US$
* Dividends per share  10 Yr Med and Cur. -15.58% -7.67% 5 Yr Med and Cur. -6.89% -5.14% Last Div Inc ---> $0.285 $0.315 10.53% 12.81% <-IRR #YR-> 10 Dividends 233.77% US$
Dividends Growth 15 4.77% <-IRR #YR-> 15 Dividends 101.05% US$
Dividends Growth 20 2.34% <-IRR #YR-> 20 Dividends US$
Dividends Growth 25 5.69% <-IRR #YR-> 22 Dividends
Dividends Growth 5 -$0.67 $0.00 $0.00 $0.00 $0.00 $1.17 Dividends Growth 5
Dividends Growth 10 -$0.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.17 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.17 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.17 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.17 Dividends Growth 25
Historical Dividends Historical High Div 6.03% Low Div 0.62% 10 Yr High 1.80% 10 Yr Low 0.61% Med Div 1.13% Close Div 0.98% Historical Dividends Div Yd Years
High/Ave/Median Values Curr diff Exp. -88.93% Exp 7.62% Exp. -62.93% 9.39% Exp. -40.95% Exp. -32.20% High/Ave/Median  1.12% 5
1.87% 10
Future Dividend Yield Div Yield 1.12% earning in 5 Years at IRR of 10.87% Div Inc. 67.52% Future Dividend Yield 3.14% 15
Future Dividend Yield Div Yield 1.87% earning in 10 Years at IRR of 10.87% Div Inc. 180.63% Future Dividend Yield
Future Dividend Yield Div Yield 3.14% earning in 15 Years at IRR of 10.87% Div Inc. 370.12% Future Dividend Yield
Future Dividend Paid Div Paid $2.22 earning in 5 Years at IRR of 11.96% Div Inc. 75.94% Future Dividend Paid
Future Dividend Paid Div Paid $3.90 earning in 10 Years at IRR of 11.96% Div Inc. 209.55% Future Dividend Paid
Future Dividend Paid Div Paid $6.86 earning in 15 Years at IRR of 11.96% Div Inc. 444.62% Future Dividend Paid
Dividend Covering Cost Total Div $8.00 over 5 Years at IRR of 11.96% Div Cov. 4.24% Dividend Covering Cost
Dividend Covering Cost Total Div $19.85 over 10 Years at IRR of 11.96% Div Cov. 10.51% Dividend Covering Cost
Dividend Covering Cost Total Div $40.71 over 15 Years at IRR of 11.96% Div Cov. 21.56% Dividend Covering Cost
Yield if held 5 years 1.03% 3.02% 1.58% 0.94% 1.86% 1.67% 1.69% 1.60% 2.33% 1.61% 1.33% 1.41% 1.29% 1.23% 0.92% 0.95% 1.60% <-Median-> 10 Paid Median Price US$
Yield if held 10 years 2.50% 1.80% 1.15% 0.84% 1.38% 1.32% 2.42% 3.84% 2.61% 2.76% 3.32% 3.10% 2.80% 2.70% 2.13% 1.56% 2.68% <-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.32% 4.12% 4.42% 2.70% <-Median-> 8 Paid Median Price US$
Yield if held 20 years 6.32% 5.28% 3.85% 3.34% 3.43% 3.32% 5.28% <-Median-> 3 Paid Median Price US$
Yield if held 25 years 8.43%
Cost covered if held 5 years 6.94% 8.37% 10.23% 6.02% 6.23% 7.13% 6.65% 6.14% 6.45% 5.67% 4.69% 4.51% 4.20% 4.38% 3.81% 3.48% 6.08% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 47.99% 34.71% 21.43% 15.61% 14.68% 12.29% 17.78% 25.05% 16.34% 17.19% 20.45% 19.22% 17.56% 17.74% 15.30% 12.12% 17.37% <-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.42% 35.78% 41.51% 32.74% <-Median-> 8 Paid Median Price US$
Cost covered if held 20 years 86.97% 67.52% 45.60% 37.57% 39.27% 38.08% 67.52% <-Median-> 3 Paid Median Price US$
Cost covered if held 25 years 127.12%
Yr  Item Tot. Growth Per Year
Dividend CDN$ Paid in US$ from 2017 $1.76 $1.90 $2.07 Estimates Div CDN$ Paid in US$ fr2017
Increase 4.29% 8.13% 9.04% Estimates Increase
Payout Ratio EPS 27.58% 25.25% 23.74% 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.56 $0.57 $0.61 $0.66 $1.02
Pre-split 2017 $1.16 $1.18 $1.27 $1.37 $1.02
Dividend CDN$ Paid in US$ from 2017 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $1.68 $1.73 $1.73 $1.73 313.98% <-Total Growth 10 Dividends CDN$
Increase 2.75% 1.79% 7.02% 8.20% 54.23% -7.57% 26.14% 9.16% 12.03% 10.71% 19.47% 8.50% 21.23% 2.75% 0.00% 0.00% 18 3 22 Years of data, Count P, N 81.82% CDN$
Average Increases 5 Year Running -16.66% -16.30% -4.98% 5.75% 14.80% 12.73% 17.60% 18.03% 18.80% 10.10% 15.50% 11.98% 14.39% 12.53% 10.39% 6.49% 14.59% <-Median-> 10 Average Incr 5 Year Running CDN$
Dividends 5 Yr Running $0.58 $0.41 $0.37 $0.39 $0.46 $0.51 $0.59 $0.68 $0.79 $0.86 $0.99 $1.11 $1.28 $1.43 $1.56 $1.65 244.22% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 1.31% 1.12% 0.97% 0.94% 1.15% 0.78% 0.84% 0.76% 0.80% 0.72% 0.74% 0.75% 0.72% 0.66% 0.77% <-Median-> 10 Yield H/L Price CDN$
Yield on High  Price 1.17% 0.97% 0.83% 0.83% 0.95% 0.68% 0.74% 0.67% 0.70% 0.61% 0.65% 0.69% 0.62% 0.61% 0.68% <-Median-> 10 Yield on High  Price CDN$
Yield on Low Price 1.49% 1.33% 1.18% 1.09% 1.45% 0.91% 0.96% 0.87% 0.95% 0.87% 0.86% 0.81% 0.86% 0.71% 0.89% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 1.26% 1.04% 0.84% 0.97% 0.97% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.70% 0.68% 0.67% 0.67% 0.67% 0.72% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 24.08% 18.27% 16.62% 14.80% 47.38% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 48.95% 27.17% 23.01% 19.83% 33.33% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 119.12% 72.93% 42.62% 33.52% 21.74% 21.71% 23.72% 26.69% 36.50% 35.06% 35.59% 37.01% 40.67% 33.92% 30.50% 27.59% 34.29% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 6.15% 4.38% 4.20% 6.02% 16.70% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.72% 13.54% 12.74% 11.35% #DIV/0! 12.37% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 8.69% 6.13% 5.08% 5.05% 6.36% 7.16% 8.65% 10.65% 12.49% 12.12% 12.23% 12.59% 13.02% 12.81% 12.43% #DIV/0! 11.38% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 5.02% 4.46% 3.97% 6.25% 15.99% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.80% 12.38% 12.74% 11.35% #DIV/0! 12.42% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 8.10% 5.84% 4.73% 4.80% 6.08% 7.03% 8.50% 10.67% 12.36% 12.10% 12.44% 12.75% 12.82% 12.67% 12.29% #DIV/0! 11.38% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median values 10 Yr Med 10 Yr Cl 0.77% 0.72% 5 Yr Med 5 Yr Cl 0.74% 0.70% 5 Yr Med Payout 35.81% 12.95% 12.80% 14.28% <-IRR #YR-> 5 Dividends 94.92% CDN$
* Dividends per share  10 Yr Med and Cur. -12.85% -7.41% 5 Yr Med and Cur. -9.95% -4.66% Last Div Inc ---> $0.185 $0.205 10.81% 15.27% <-IRR #YR-> 10 Dividends 313.98% CDN$
Dividends Growth 15 6.99% <-IRR #YR-> 15 Dividends 175.49% CDN$
Dividends Growth 20 3.26% <-IRR #YR-> 20 Dividends CDN$
Dividends Growth 25 5.25% <-IRR #YR-> 22 Dividends
Dividends Growth 5 -$0.86 $0.00 $0.00 $0.00 $0.00 $1.68 Dividends Growth 5
Dividends Growth 10 -$0.41 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.68 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.68 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.68 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.68 Dividends Growth 25
Historical Dividends Historical High Div 5.33% Low Div 0.63% 10 Yr High 1.41% 10 Yr Low 0.61% Med Div 1.14% Close Div 1.00% Historical Dividends
High/Ave/Median Values Curr diff Exp. -87.45% Exp 6.21% Exp. -52.54% 9.70% Exp. -41.30% Exp. -32.77% High/Ave/Median 
Future Dividend Yield Div Yield 1.30% earning in 5 Years at IRR of 14.28% Div Inc. 94.92% Future Dividend Yield
Future Dividend Yield Div Yield 2.54% earning in 10 Years at IRR of 14.28% Div Inc. 279.93% Future Dividend Yield
Future Dividend Yield Div Yield 4.96% earning in 15 Years at IRR of 14.28% Div Inc. 640.56% Future Dividend Yield
Future Dividend Paid Div Paid $3.37 earning in 5 Years at IRR of 14.28% Div Inc. 94.92% Future Dividend Paid
Future Dividend Paid Div Paid $6.57 earning in 10 Years at IRR of 14.28% Div Inc. 279.93% Future Dividend Paid
Future Dividend Paid Div Paid $12.81 earning in 15 Years at IRR of 14.28% Div Inc. 640.56% Future Dividend Paid
Dividend Covering Cost Total Div $11.50 over 5 Years at IRR of 14.28% Div Cov. 4.45% Dividend Covering Cost
Dividend Covering Cost Total Div $30.54 over 10 Years at IRR of 14.28% Div Cov. 11.81% Dividend Covering Cost
Dividend Covering Cost Total Div $67.65 over 15 Years at IRR of 14.28% Div Cov. 26.17% Dividend Covering Cost
Yield if held 5 years 0.98% 1.59% 2.35% 1.51% 2.22% 2.20% 2.33% 2.07% 2.07% 1.81% 1.58% 1.47% 1.48% 1.44% 1.16% 1.00% 1.94% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 years 2.50% 1.91% 1.34% 1.17% 1.85% 1.65% 3.31% 4.98% 3.32% 3.50% 4.49% 4.09% 4.03% 3.71% 2.93% 2.14% 3.41% <-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% 5.93% 5.66% 6.07% 3.68% <-Median-> 8 Paid Median Price CDN$
Yield if held 20 years 8.56% 6.99% 5.54% 4.59% 4.71% 4.55% 6.99% <-Median-> 3 Paid Median Price CDN$
Yield if held 25 years 11.57%
Cost covered if held 5 years 7.62% 8.61% 10.72% 6.73% 7.45% 8.89% 8.68% 8.14% 8.42% 7.32% 6.15% 5.89% 5.62% 5.95% 5.23% 4.80% 7.38% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 54.01% 38.41% 23.55% 17.23% 16.36% 14.29% 20.91% 30.34% 20.21% 21.58% 26.35% 25.11% 23.43% 23.75% 20.54% 16.37% 21.25% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 70.95% 53.23% 34.75% 27.65% 28.12% 27.38% 44.18% 67.23% 44.74% 47.13% 55.35% 39.46% <-Median-> 8 Paid Median Price CDN$
Cost covered if held 20 years 104.23% 81.27% 55.79% 46.61% 49.38% 49.14% 81.27% <-Median-> 3 Paid Median Price CDN$
Cost covered if held 25 years 159.50%
Yr  Item Tot. Growth Per Year
Revenue Growth US$ $5,388.7 $5,446.0 $6,151.4 $7,211.9 $8,022.0 $8,919.6 $9,075 <-12 mths 1.74% 65.52% <-Total Growth 5 Revenue Growth US$ 65.52% 10.60%
AEPS Growth $2.72 $2.64 $3.23 $3.82 $4.19 $4.79 $4.88 <-12 mths 1.88% 76.10% <-Total Growth 5 AEPS Growth 76.10% 11.98%
Net Income Growth $566.8 $204.7 $618.0 $835.7 $762.8 $616.6 $628 <-12 mths 1.86% 8.77% <-Total Growth 5 Net Income Growth 8.77% 1.70%
Cash Flow Growth $1,540.5 $1,408.5 $1,698.2 $2,022.5 $2,126.8 $2,228.9 $2,280 <-12 mths 2.30% 44.68% <-Total Growth 5 Cash Flow Growth 44.68% 7.67%
Dividend Growth $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $1.26 <-12 mths 7.69% 75.94% <-Total Growth 5 Dividend Growth 75.94% 11.96%
Stock Price Growth $90.79 $102.57 $136.27 $132.56 $149.27 $171.58 $188.83 <-12 mths 10.05% 88.99% <-Total Growth 5 Stock Price Growth 88.99% 13.58%
Revenue Growth US$ $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,530 <-this year 6.84% 343.98% <-Total Growth 10 Revenue Growth US$ 343.98% 16.07%
AEPS Growth $2.04 $1.98 $1.72 $2.16 $2.52 $2.72 $2.64 $3.23 $3.82 $4.19 $4.79 $5.22 <-this year 8.98% 134.80% <-Total Growth 10 AEPS Growth 134.80% 8.91%
Net Income Growth $126.5 $123.9 $245.8 $576.8 $546.9 $566.8 $204.7 $618.0 $835.7 $762.8 $616.6 $1,196 <-this year 93.98% 387.35% <-Total Growth 10 Net Income Growth 387.35% 17.16%
Cash Flow Growth $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,553 <-this year 14.52% 394.51% <-Total Growth 10 Cash Flow Growth 394.51% 17.33%
Dividend Growth $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 $1.28 <-this year 9.32% 233.77% <-Total Growth 10 Dividend Growth 233.77% 12.81%
Stock Price Growth $41.65 $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $171.58 $188.83 <-this year 10.05% 311.99% <-Total Growth 10 Stock Price Growth 311.99% 15.21%
Dividends on Shares CDN$ $9.24 $14.25 $13.17 $16.62 $18.14 $20.32 $22.50 $26.88 $29.16 $35.35 $36.32 $36.32 $36.32 $205.63 No of Years 10 Total Dividends CDN$ 12/31/14
Paid  $1,015.60 $947.85 $1,474.76 $1,872.36 $2,127.93 $2,476.95 $2,740.92 $3,620.40 $3,769.08 $4,155.06 $5,178.60 $5,428.50 $5,428.50 $5,428.50 $5,178.60 No of Years 10 Worth $48.36 20.68
Total $5,384.23 Total
Dividends on Shares CDN$ $8.71 $9.64 $11.52 $12.50 $15.15 $15.57 $15.57 $15.57 $57.52 No of Years 5 Total Dividends CDN$ 12/31/19
Paid  $1,061.55 $1,174.68 $1,551.60 $1,615.32 $1,780.74 $2,219.40 $2,326.50 $2,326.50 $2,326.50 $2,219.40 No of Years 5 Worth $117.95 8.48
Total $2,276.92 Total
Dividends on Shares US$ $7.94 $12.63 $12.50 $14.50 $16.63 $19.00 $21.13 $23.63 $26.25 $29.25 $31.50 $31.50 $31.50 $183.45 No of Years 10 Total Dividends US$ 12/31/14
Paid  $1,041.17 $815.14 $1,309.83 $1,773.50 $1,856.25 $2,269.75 $2,564.25 $3,406.75 $3,314.00 $3,731.75 $4,289.50 $4,720.75 $4,720.75 $4,720.75 $4,289.50 No of Years 10 Worth $41.65 24.01
Total $4,472.95 Total
Graham Price AEPS $26.31 $32.59 $37.50 $32.55 $38.67 $42.70 $50.88 $52.11 $50.13 $56.01 $66.02 $70.18 $82.45 $82.92 $88.67 $95.19 121.11% <-Total Growth 11 Graham Price AEPS CDN$
Price/GP Ratio Med 1.08 1.04 1.11 1.43 1.53 1.89 1.86 2.18 2.40 2.66 2.61 2.65 2.84 3.17 2.40 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio High 1.21 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.40 2.77 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Low 0.96 0.88 0.92 1.24 1.21 1.61 1.63 1.90 2.03 2.20 2.25 2.44 2.37 2.95 2.03 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Close 1.13 1.12 1.29 1.39 1.82 2.09 1.99 2.26 2.60 3.08 2.72 2.82 2.99 3.12 2.92 2.72 2.60 <-Median-> 11 Price/GP Ratio CDN$
Prem/Disc Close 13.04% 11.59% 28.97% 38.69% 81.59% 108.81% 99.17% 126.36% 160.36% 207.79% 171.86% 181.94% 199.09% 211.76% 191.52% 171.56% 160.36% <-Median-> 11 Graham Price
Graham Price EPS $28.29 $34.07 $38.12 $36.48 $30.49 $42.85 $46.11 $46.22 $27.25 $47.88 $60.80 $58.88 $58.24 $78.16 $84.93 $91.47 105.00% <-Total Growth 11 Graham Price EPS CDN$
Price/GP Ratio Med 1.01 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.37 2.83 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio High 1.13 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.60 3.22 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Low 0.89 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.13 2.45 <-Median-> 11 Price/GP Ratio CDN$
Price/GP Ratio Close 1.05 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.31 3.04 2.83 2.95 <-Median-> 11 Price/GP Ratio CDN$
Prem/Disc Close 5.13% 6.77% 26.85% 23.74% 130.31% 108.05% 119.76% 155.19% 379.00% 260.08% 195.19% 236.01% 323.43% 230.74% 204.36% 182.60% 195.19% <-Median-> 11 Graham Price
Pre-Split 2016 $21.48 $26.27 $34.93 $32.60
Pre-Split 2017 $44.61 $54.56 $72.54 $67.70 $105.34
Price Close CDN$ $29.74 $36.37 $48.36 $45.14 $70.23 $89.16 $101.33 $117.95 $130.52 $172.40 $179.48 $197.86 $246.60 $258.50 $258.50 $258.50 409.91% <-Total Growth 10 Stock Price CDN$ CDN$
Increase 7.78% 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 10.24% 24.63% 4.83% 0.00% 0.00% 35.97 <-Median-> 10 CAPE (10 Yr P/E)
P/E 19.19 17.49 19.77 15.18 49.03 32.60 35.88 42.44 131.43 57.62 40.90 50.71 71.71 40.60 34.38 29.64 15.89% <-IRR #YR-> 5 Stock Price 109.07% CDN$
Trailing P/E -9.32 23.46 23.26 18.45 23.62 62.25 37.05 41.77 46.96 173.60 59.99 45.09 63.20 75.17 40.60 34.38 17.69% <-IRR #YR-> 10 Stock Price 409.91% CDN$
CAPE (10 Yr P/E) 37.86 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.10 46.19 43.75 16.69% <-IRR #YR-> 5 Price & Dividend 114.49% CDN$
Median 10, 5 Yrs D.  per yr 0.91% 0.79% % Tot Ret 4.91% 4.75% T P/E 46.02 59.99 P/E:  45.74 57.62 18.61% <-IRR #YR-> 10 Price & Dividend 430.15% CDN$
Price 15 D.  per yr 0.99% % Tot Ret 5.47% CAPE Diff 12.87% 17.01% <-IRR #YR-> 15 Stock Price 955.16% CDN$
Price  20 D.  per yr 1.16% % Tot Ret 9.97% 10.43% <-IRR #YR-> 20 Stock Price 626.98% CDN$
Price  25 D.  per yr 2.23% % Tot Ret 14.30% 13.34% <-IRR #YR-> 23 Stock Price #DIV/0! CDN$
Price & Dividend 15 17.99% <-IRR #YR-> 15 Price & Dividend 1005.00% CDN$
Price & Dividend 20 11.58% <-IRR #YR-> 20 Price & Dividend 676.93% CDN$
Price & Dividend 25 15.56% <-IRR #YR-> 23 Price & Dividend #DIV/0! CDN$
Price  5 -$117.95 $0.00 $0.00 $0.00 $0.00 $246.60 Price  5
Price 10 -$48.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $246.60 Price 10
Price & Dividend 5 -$117.95 $0.97 $1.07 $1.28 $1.39 $248.28 Price & Dividend 5
Price & Dividend 10 -$48.36 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $248.28 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 $246.60 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 $246.60 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 $246.60 Price  25
Price & Dividend 15 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $248.28 Price & Dividend 15
Price & Dividend 20 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $248.28 Price & Dividend 20
Price & Dividend 25 $0.37 $0.38 $0.41 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $248.28 Price & Dividend 25
Price H/L Median $28.49 $33.91 $41.80 $46.67 $59.07 $80.85 $94.60 $113.69 $120.27 $149.22 $172.25 $185.83 $233.81 $263.15 459.37% <-Total Growth 10 Stock Price CDN$
Increase -6.84% 19.05% 23.25% 11.64% 26.57% 36.87% 17.01% 20.18% 5.79% 24.07% 15.43% 7.88% 25.82% 12.55% 18.79% <-IRR #YR-> 10 Stock Price 459.37% CDN$
P/E 18.38 16.31 17.09 15.70 41.24 29.56 33.50 40.90 121.11 49.87 39.25 47.63 67.99 41.33 15.51% <-IRR #YR-> 5 Stock Price 105.66% CDN$
Trailing P/E -8.93 21.88 20.10 19.08 19.87 56.45 34.59 40.26 43.27 150.26 57.57 42.35 59.93 76.52 19.81% <-IRR #YR-> 10 Price & Dividend 482.79% CDN$
P/E on Running 5 yr Average 58.65 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.39 16.34% <-IRR #YR-> 5 Price & Dividend 111.28% CDN$
P/E on Running 10 yr Average 36.01 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.62 29.56 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs D.  per yr 1.02% 0.83% % Tot Ret 5.14% 5.06% T P/E 42.81 57.57 P/E:  41.07 49.87 Count 22 Years of data
-$41.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $233.81
-$113.69 $0.00 $0.00 $0.00 $0.00 $233.81
-$41.80 $0.44 $0.68 $0.63 $0.79 $0.86 $0.97 $1.07 $1.28 $1.39 $235.49
-$113.69 $0.97 $1.07 $1.28 $1.39 $235.49
High Months Feb Dec Dec Apr Dec Oct Sep May Feb Nov Dec Dec Nov Apr
Pre-Split 2016 $23.00 $28.29 $35.44 $38.20
Pre-Split 2017 $47.77 $58.75 $73.60 $79.33 $106.96
Price High $31.84 $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.53 454.17% <-Total Growth 10 Stock Price CDN$
Increase -8.07% 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.53% 18.68% <-IRR #YR-> 10 Stock Price 454.17% CDN$
P/E 20.54 18.83 20.06 17.79 49.79 33.93 37.68 46.22 139.73 58.50 44.62 51.42 79.07 44.22 16.18% <-IRR #YR-> 5 Stock Price 111.68% CDN$
Trailing P/E -9.98 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.86 33.93 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 47.82 65.44 P/E:  48.00 58.50 52.84 P/E Ratio Historical High CDN$
-$49.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $271.92
-$128.46 $0.00 $0.00 $0.00 $0.00 $271.92
Low Months Jun Feb Jan Dec Jan Jan Feb Jan Mar Feb Jun Jan Jan Jan
Price Low $25.13 $28.66 $34.53 $40.44 $46.83 $68.89 $82.80 $98.92 $101.77 $123.41 $148.70 $171.01 $195.70 $244.76 466.75% <-Total Growth 10 Stock Price CDN$
Increase -5.22% 14.05% 20.48% 17.12% 15.79% 47.12% 20.19% 19.47% 2.88% 21.26% 20.49% 15.00% 14.44% 25.07% 18.94% <-IRR #YR-> 10 Stock Price 466.75% CDN$
P/E 16.21 13.78 14.12 13.60 32.70 25.19 29.32 35.59 102.48 41.25 33.89 43.83 56.91 38.44 14.62% <-IRR #YR-> 5 Stock Price 97.84% CDN$
Trailing P/E -7.87 18.49 16.60 16.53 15.75 48.10 30.28 35.03 36.62 124.27 49.70 38.97 50.16 71.17 25.19 P/E Ratio Historical Median CDN$
Median 10, 5 Yrs T P/E 37.79 49.70 P/E:  34.74 43.83 41.76 P/E Ratio Historical High CDN$
-$34.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $195.70
US$ Price based on CDN$ Price, Exch $29.79 $34.20 $41.69 $32.60 $52.30 $71.07 $74.28 $90.81 $102.51 $135.98 $132.52 $149.60 $171.38 $188.30 $188.30 $188.30
Price Close US$ $29.91 $34.27 $41.65 $32.61 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $171.58 $188.83 $188.83 $188.83 311.99% <-Total Growth 10 Stock Price US$ US$
Increase 10.26% 14.58% 21.54% -21.71% 60.69% 35.40% 4.67% 22.28% 12.97% 32.86% -2.72% 12.61% 14.95% 10.05% 0.00% 0.00% 36.09 <-Median-> 10 CAPE (10 Yr P/E)
P/E 19.26 17.53 19.75 15.19 49.12 32.54 35.87 42.43 131.50 57.74 40.91 50.60 71.79 40.71 34.48 29.72 13.58% <-IRR #YR-> 5 Stock Price 88.99% US$
Trailing P/E -9.57 22.07 21.30 15.46 24.40 66.51 34.06 43.86 47.93 174.71 56.17 46.07 58.16 79.01 40.71 34.48 15.21% <-IRR #YR-> 10 Stock Price 311.99% US$
CAPE (10 Yr P/E) 38.92 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.11 46.27 43.95 14.38% <-IRR #YR-> 5 Price & Dividend 94.24% US$
Median 10, 5 Yrs D.  per yr 0.88% 0.81% % Tot Ret 5.44% 5.60% T P/E 47.00 56.17 P/E:  45.77 57.74 16.08% <-IRR #YR-> 10 Price & Dividend 329.61% US$
Price 15 D.  per yr 0.98% % Tot Ret 6.31% 14.61% <-IRR #YR-> 15 Stock Price 673.57% US$
Price  20 D.  per yr 1.29% % Tot Ret 11.86% 9.58% <-IRR #YR-> 20 Stock Price 523.69% US$
Price  25 D.  per yr 3.77% % Tot Ret 19.91% 15.16% <-IRR #YR-> 23 Stock Price US$
Price & Dividend 15 15.60% <-IRR #YR-> 15 Price & Dividend 675.17% US$
Price & Dividend 20 10.87% <-IRR #YR-> 20 Price & Dividend 524.97% US$
Price & Dividend 25 18.93% <-IRR #YR-> 23 Price & Dividend US$
Price  5 -$90.79 $0.00 $0.00 $0.00 $0.00 $171.58 Price  5
Price 10 -$41.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $171.58 Price 10
Price & Dividend 5 -$90.79 $0.76 $0.85 $0.95 $1.05 $172.75 Price & Dividend 5
Price & Dividend 10 -$41.65 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $172.75 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 $171.58 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 $171.58 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 $171.58 Price  25
Price & Dividend 15 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $172.75 Price & Dividend 15
Price & Dividend 20 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $172.75 Price & Dividend 20
Price & Dividend 25 $0.37 $0.36 $0.35 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $172.75 Price & Dividend 25
Price H/L Median US$ $28.05 $32.60 $36.89 $35.87 $42.54 $62.36 $73.09 $84.48 $73.07 $117.91 $136.40 $138.31 $169.77 $184.92 $184.92 $184.92 360.18% <-Total Growth 10 Stock Price US$
Increase -8.41% 16.21% 13.17% -2.78% 18.60% 46.60% 17.21% 15.58% -13.50% 61.36% 15.69% 1.40% 22.74% 8.93% 16.49% <-IRR #YR-> 10 Stock Price 360.18% US$
P/E 18.07 16.67 17.50 16.71 39.88 28.61 35.31 39.47 93.68 49.96 42.10 46.88 71.03 39.87 14.98% <-IRR #YR-> 5 Stock Price 100.96% US$
Trailing P/E -8.98 20.99 18.87 17.01 19.81 58.46 33.53 40.81 34.14 151.16 57.80 42.69 57.55 77.37 17.43% <-IRR #YR-> 10 Price & Dividend 380.07% US$
P/E on Running 5 yr Average 65.23 59.67 46.48 38.66 24.09 32.97 38.18 43.98 44.36 61.86 64.40 60.29 72.43 59.35 15.83% <-IRR #YR-> 5 Price & Dividend 106.61% US$
P/E on Running 10 yr Average 40.63 40.47 41.59 33.76 40.11 53.72 59.40 62.24 56.75 64.22 68.04 65.73 79.61 77.65 29.10 P/E Ratio Historical Median US$
Median 10, 5 Yrs D.  per yr 0.94% 0.85% % Tot Ret 5.41% 5.34% T P/E 41.75 57.55 P/E:  40.99 49.96
-$36.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $169.77
-$84.48 $0.00 $0.00 $0.00 $0.00 $169.77
-$36.89 $0.32 $0.51 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $170.94
-$84.48 $0.76 $0.85 $0.95 $1.05 $170.94
High Months US$ Apr Oct Dec Apr Dec Oct Sep May Feb Nov Nov Dec Nov Apr
Pre-Split 2016 $22.85 $26.96 $30.97 $30.54
Pre-Split 2017 $47.45 $55.99 $64.32 $63.43 $78.78
Price High $31.64 $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 $199.95 $199.95 349.66% <-Total Growth 10 Stock Price US$
Increase -11.33% 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% 16.22% <-IRR #YR-> 10 Stock Price 349.66% US$
P/E 20.38 19.09 20.34 19.69 49.24 33.11 38.93 44.36 134.19 58.59 44.89 50.60 80.67 43.11 15.22% <-IRR #YR-> 5 Stock Price 103.11% US$
Trailing P/E -10.13 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 33.59 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 47.49 61.63 P/E:  47.06 58.59 53.80 P/E Ratio Historical High US$
-$42.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $192.81
-$94.93 $0.00 $0.00 $0.00 $0.00 $192.81
Low Months US$ Jun Feb Jan Dec Jan Jan Feb Jan Mar Feb Feb Jan Jan Jan
Price Low $24.46 $27.87 $30.90 $29.45 $32.55 $52.54 $65.60 $74.02 $41.47 $97.54 $127.35 $127.35 $146.72 $169.89 $169.89 $169.89 374.78% <-Total Growth 10 Stock Price US$
Increase -4.33% 13.92% 10.88% -4.70% 10.54% 61.40% 24.86% 12.84% -43.97% 135.21% 30.56% 0.00% 15.21% 15.79% 16.86% <-IRR #YR-> 10 Stock Price 374.78% US$
P/E 15.76 14.25 14.66 13.72 30.52 24.10 31.69 34.59 53.17 41.33 39.31 43.17 61.39 36.63 14.66% <-IRR #YR-> 5 Stock Price 98.22% US$
Trailing P/E -7.83 17.95 15.80 13.97 15.16 49.26 30.09 35.76 19.38 125.05 53.96 39.31 49.74 71.08 24.61 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 37.53 49.74 P/E:  36.95 43.17 42.07 P/E Ratio Historical High US$
-$30.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $146.72
$1,225 <-12 mths 0.60%
Free Cash Flow Mkt Sc $842 $954 $1,110 $1,224 $1,218 $1,329 $1,640 $1,909
Change 13.30% 16.36% 10.27% -0.49% 9.11% 23.40% 16.40%
Free Cash Flow Company $1,224 $1,218 Free Cash Flow Company
Change -0.54%
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
$1,233 <-12 mths 4.49%
Free Cash Flow MS $262.81 $274.19 $303.80 $330.00 $490.00 $780.00 $830.00 $850.00 $770 $930 $1,040 $1,180 $1,380 $1,329 $1,640 $1,909 354.25% <-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.19% 7.19% 7.19% 10.18% <-IRR #YR-> 5 Free Cash Flow MS 62.35% US$
FCF/CF from Op Ratio 0.78 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.74 0.74 0.74 16.34% <-IRR #YR-> 10 Free Cash Flow MS 354.25% US$
Dividends paid $20.71 $19.76 $18.92 $56.00 $93.00 $131.98 $152.55 $175.07 $199.88 $220.20 $243.01 $270.60 $302.26 $239.40 $239.40 $239.40 1497.34% <-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% 18.89% 18.89% 18.89% 21.25% <-Median-> 10 Percentage paid US$
5 Year Covrage 18.55% 20.23% 21.15% 22.41% 23.24% 23.32% 20.98% 20.98% 20.98% 21.78% <-Median-> 6 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 5.29 5.29 5.29 4.71 <-Median-> 10 Dividend Coverage Ratio US$
5 Year of Coverage 5.39 4.94 4.73 4.46 4.30 4.29 4.77 4.77 4.77 4.60 <-Median-> 6 5 Year of Coverage US$
Market Cap US$ $1,656 $1,895 $2,248 $2,562 $13,769 $18,692 $19,538 $23,934 $26,958 $35,459 $34,087 $38,452 $44,271 $48,722 $48,722 $48,722 1869.24% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $1,647 $2,011 $2,611 $3,547 $18,456 $23,493 $26,664 $31,094 $34,304 $44,861 $46,153 $50,969 $63,628 $66,698 $66,698 $66,698 2337.28% <-Total Growth 10 Market Cap CDN$
Diluted # of Shares in Million 84.35 83.18 82.93 79.80 231.08 264.30 264.40 264.53 263.69 261.73 258.04 258.15 258.66 258.90 211.90% <-Total Growth 10 Diluted
Change -3.23% -1.38% -0.30% -3.78% 189.59% 14.38% 0.04% 0.05% -0.32% -0.74% -1.41% 0.04% 0.20% 0.09% 0.04% <-Median-> 10 Change
Difference Diluted/Basic 0.0% 0.0% 0.0% 0.0% -0.3% -0.2% -0.3% -0.3% -0.2% -0.2% -0.3% -0.2% -0.3% -0.3%
Basic # of Shares in Millions 84.35 83.18 82.93 79.80 230.33 263.68 263.65 263.79 263.19 261.17 257.38 257.55 257.97 258.19 211.06% <-Total Growth 10 Basic
Change -3.23% -1.38% -0.30% -3.78% 188.64% 14.48% -0.01% 0.05% -0.23% -0.77% -1.45% 0.07% 0.16% 0.09% 0.02% <-Median-> 10 Change
Difference Basic/Outstanding -34.4% -33.5% -34.9% -1.5% 14.1% -0.1% -0.2% -0.1% -0.1% -0.4% -0.1% 0.0% 0.0% -0.1% -0.08% <-Median-> 10 Difference
$2,280.16 <-12 mths 2.30%
# of Shares in Millions 55.37 55.30 53.98 78.59 262.80 263.49 263.14 263.62 262.825 260.212 257.146 257.600 258.019 258.019 258.019 258.019 16.93% <-IRR #YR-> 10 Shares 377.99% SHAREHOLDERS’ EQUITY
Change -2.58% -0.12% -2.39% 45.58% 234.41% 0.26% -0.13% 0.18% -0.30% -0.99% -1.18% 0.18% 0.16% 0.00% 0.00% 0.00% -0.43% <-IRR #YR-> 5 Shares -2.12%
CF fr Op $M US$ $336.8 $450.7 $450.7 $415.0 $795.3 $1,187.3 $1,411.2 $1,540.5 $1,408.5 $1,698.2 $2,022.5 $2,126.8 $2,228.9 $2,552.6 $2,864.0 $0.0 394.51% <-Total Growth 10 Cash Flow US$
Increase -14.90% 33.84% 0.00% -7.92% 91.63% 49.28% 18.86% 9.16% -8.57% 20.57% 19.09% 5.16% 4.80% 14.52% 12.20% -100.00% SO Buy Backs S Iss.
5 year Running Average $294.1 $346.7 $385.6 $409.8 $489.7 $659.8 $851.9 $1,069.9 $1,268.6 $1,449.2 $1,616.2 $1,759.3 $1,897.0 $2,125.8 $2,359.0 $1,954.5 392.01% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $6.08 $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.89 $11.10 3.46% <-Total Growth 10 Cash Flow per Share US$
Increase -12.64% 34.01% 2.45% -36.75% -42.69% 48.89% 19.02% 8.97% -8.29% 21.78% 20.51% 4.97% 4.63% 14.52% 12.20% 17.33% <-IRR #YR-> 10 Cash Flow 394.51% US$
5 year Running Average $6.26 $6.54 $6.91 $6.97 $6.18 $5.86 $5.31 $4.80 $4.82 $5.52 $6.19 $6.77 $7.33 $8.24 $9.15 7.67% <-IRR #YR-> 5 Cash Flow 44.68% US$
P/CFPS on Median 4.61 4.00 4.42 6.79 14.06 13.84 13.63 14.46 13.63 18.07 17.34 16.75 19.65 18.69 16.66 0.34% <-IRR #YR-> 10 Cash Flow per Share 3.46% US$
P/CFPS on Close 4.92 4.20 4.99 6.17 17.31 15.74 13.84 15.54 19.14 20.88 16.85 18.08 19.86 19.09 17.01 8.13% <-IRR #YR-> 5 Cash Flow per Share 47.82% US$
33.89% Diff M/C 0.58% <-IRR #YR-> 10 CFPS 5 yr Running 6.00% US$
$2,485 <-12 mths 1.95%
Excl.Working Capital CF $75.39 -$7.25 $25.37 -$15.69 $35.22 $71.00 -$32.00 -$27.00 $24.00 -$19.00 -$73.00 -$13.00 $209.00 $0.00 $0.00 8.82% <-IRR #YR-> 5 CFPS 5 yr Running 52.56% US$
CF fr Op $M WC $412.2 $443.5 $476.1 $399.3 $830.5 $1,258.3 $1,379.2 $1,513.5 $1,432.5 $1,679.2 $1,949.5 $2,113.8 $2,437.9 $2,552.6 $2,864.0 412.05% <-Total Growth 10 Cash Flow less WC US$
Increase -3.86% 7.60% 7.36% -16.13% 107.98% 51.50% 9.61% 9.74% -5.35% 17.22% 16.09% 8.43% 15.33% 4.70% 12.20% 17.74% <-IRR #YR-> 10 Cash Flow less WC 412.05% US$
5 year Running Average $319 $367 $415 $432 $512 $682 $869 $1,076 $1,283 $1,453 $1,591 $1,738 $1,923 $2,147 $2,384 10.00% <-IRR #YR-> 5 Cash Flow less WC 61.07% US$
CFPS Excl. WC $7.44 $8.02 $8.82 $5.08 $3.16 $4.78 $5.24 $5.74 $5.45 $6.45 $7.58 $8.21 $9.45 $9.89 $11.10 16.57% <-IRR #YR-> 10 CF less WC 5 Yr Run 363.35% US$
Increase -1.32% 7.73% 9.99% -42.39% -37.81% 51.10% 9.76% 9.54% -5.07% 18.40% 17.48% 8.24% 15.15% 4.70% 12.20% 12.31% <-IRR #YR-> 5 CF less WC 5 Yr Run 78.65% US$
5 year Running Average $6.73 $6.87 $7.44 $7.38 $6.50 $5.97 $5.42 $4.80 $4.87 $5.53 $6.09 $6.69 $7.43 $8.32 $9.25 0.69% <-IRR #YR-> 10 CFPS - Less WC 7.13% US$
P/CFPS on Median 3.77 4.07 4.18 7.06 13.46 13.06 13.94 14.71 13.41 18.27 17.99 16.86 17.97 18.69 16.66 10.48% <-IRR #YR-> 5 CFPS - Less WC 64.57% US$
P/CFPS on Close 4.02 4.27 4.72 6.42 16.58 14.86 14.17 15.81 18.82 21.12 17.49 18.19 18.16 19.09 17.01 -0.02% <-IRR #YR-> 5 CFPS 5 yr Running -0.16% US$
CF/-WC P/CF Med 10 yr 14.26 5 yr  17.34 P/CF Med 10 yr 14.33 5 yr  17.97 33.21% Diff M/C 9.13% <-IRR #YR-> 5 CFPS 5 yr Running 54.75% US$
$3,130.20 <-12 mths -10.77%
CF fr Op $M CDN$ $336.2 $479.4 $522.9 $574.7 $1,067.9 $1,489.4 $1,925.2 $2,000.9 $1,793.3 $2,153.0 $2,739.3 $2,812.9 $3,207.2 $3,504.2 $3,931.7 513.35% <-Total Growth 10 Cash Flow CDN$
Increase -16.81% 42.60% 9.07% 9.90% 85.82% 39.48% 29.26% 3.93% -10.37% 20.06% 27.23% 2.69% 14.02% 9.26% 12.20% SO Buy Backs S Iss.
5 year Running Average $306 $356 $407 $463 $596 $827 $1,116 $1,412 $1,655 $1,872 $2,122 $2,300 $2,541 $2,883 $3,239 524.17% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $6.07 $8.67 $9.69 $7.31 $4.06 $5.65 $7.32 $7.59 $6.82 $8.27 $10.65 $10.92 $12.43 $13.58 $15.24 28.32% <-Total Growth 10 Cash Flow per Share CDN$
Increase -14.61% 42.77% 11.74% -24.51% -44.43% 39.11% 29.43% 3.74% -10.10% 21.26% 28.75% 2.51% 13.83% 9.26% 12.20% 19.89% <-IRR #YR-> 10 Cash Flow 513.35% CDN$
5 year Running Average $6.66 $6.73 $7.31 $7.77 $7.16 $7.08 $6.81 $6.39 $6.29 $7.13 $8.13 $8.85 $9.82 $11.17 $12.56 9.90% <-IRR #YR-> 5 Cash Flow 60.29% CDN$
P/CFPS on Median 4.69 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.38 0.00 2.52% <-IRR #YR-> 10 Cash Flow per Share 28.32% CDN$
P/CFPS on Close 4.90 4.20 4.99 6.17 17.28 15.77 13.85 15.54 19.13 20.84 16.85 18.12 19.84 19.03 16.96 10.37% <-IRR #YR-> 5 Cash Flow per Share 63.77% CDN$
22.21% Diff M/C 3.00% <-IRR #YR-> 10 CFPS 5 yr Running 34.34% CDN$
$3,412 <-12 mths -2.73%
Excl.Working Capital CF $75.27 -$7.72 $29.44 -$21.73 $47.29 $89.07 -$43.65 -$35.07 $30.56 -$24.09 -$98.87 -$17.19 $300.73 $0.00 $0.00 8.98% <-IRR #YR-> 5 CFPS 5 yr Running 53.75% CDN$
CF fr Op $M WC $411.5 $471.7 $552.3 $553.0 $1,115.2 $1,578.5 $1,881.6 $1,965.8 $1,823.9 $2,128.9 $2,640.4 $2,795.7 $3,507.9 $3,504.2 $3,931.7 535.11% <-Total Growth 10 Cash Flow less WC CDN$
Increase -6.03% 14.64% 17.10% 0.11% 101.67% 41.55% 19.20% 4.48% -7.22% 16.72% 24.02% 5.88% 25.47% -0.11% 12.20% 20.31% <-IRR #YR-> 10 Cash Flow less WC 535.11% CDN$
5 year Running Average $332 $376 $437 $485 $621 $854 $1,136 $1,419 $1,673 $1,876 $2,088 $2,271 $2,579 $2,915 $3,276 12.28% <-IRR #YR-> 5 Cash Flow less WC 78.45% CDN$
CFPS Excl. WC $7.43 $8.53 $10.23 $7.04 $4.24 $5.99 $7.15 $7.46 $6.94 $8.18 $10.27 $10.85 $13.60 $13.58 $15.24 19.42% <-IRR #YR-> 10 CF less WC 5 Yr Run 489.81% CDN$
Increase -3.54% 14.78% 19.97% -31.23% -39.69% 41.18% 19.36% 4.29% -6.94% 17.90% 25.50% 5.70% 25.27% -0.11% 12.20% 12.70% <-IRR #YR-> 5 CF less WC 5 Yr Run 81.80% CDN$
5 year Running Average $7.14 $7.06 $7.85 $8.19 $7.49 $7.21 $6.93 $6.38 $6.36 $7.14 $8.00 $8.74 $9.97 $11.30 $12.71 2.88% <-IRR #YR-> 10 CFPS - Less WC 32.87% CDN$
P/CFPS on Median 3.83 3.98 4.09 6.63 13.92 13.50 13.23 15.25 17.33 18.24 16.78 17.12 17.20 19.38 0.00 12.76% <-IRR #YR-> 5 CFPS - Less WC 82.32% CDN$
P/CFPS on Close 4.00 4.26 4.73 6.41 16.55 14.88 14.17 15.82 18.81 21.07 17.48 18.23 18.14 19.03 16.96 2.42% <-IRR #YR-> 10 CFPS 5 yr Running 26.96% CDN$
*Operational cash flow Per Share (OPS) CF/-WC P/CF Med 10 yr 15.57 5 yr  17.63 P/CF Med 10 yr 16.01 5 yr  17.20 18.88% Diff M/C 9.35% <-IRR #YR-> 5 CFPS 5 yr Running 56.34% CDN$
-$9.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.43 Cash Flow per Share CDN$
-$7.59 $0.00 $0.00 $0.00 $0.00 $12.43 Cash Flow per Share CDN$
-$7.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.82 CFPS 5 yr Running CDN$
-$6.39 $0.00 $0.00 $0.00 $0.00 $9.82 CFPS 5 yr Running CDN$
-$552 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,508 Cash Flow less WC CDN$
-$1,966 $0 $0 $0 $0 $3,508 Cash Flow less WC CDN$
-$437 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,579 CF less WC 5 Yr Run CDN$
-$1,419 $0 $0 $0 $0 $2,579 CF less WC 5 Yr Run CDN$
-$10.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.60 CFPS - Less WC CDN$
-$7.46 $0.00 $0.00 $0.00 $0.00 $13.60 CFPS - Less WC CDN$
OPM 17.75% 22.25% 22.44% 21.55% 23.56% 25.64% 28.67% 28.59% 25.86% 27.61% 28.04% 26.51% 24.99% 26.78% 11.38% <-Total Growth 10 OPM CDN$
Increase -17.44% 25.30% 0.85% -3.94% 9.31% 8.83% 11.80% -0.27% -9.53% 6.74% 1.58% -5.46% -5.75% 7.19% Should increase  or be stable. CDN$
Diff from Median -32.2% -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.3% 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 $2,963 <-12 mths 2.12%
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,163 $3,435 $3,737 304.68% <-Total Growth 10 Adjusted EBITDA (All WCN)
Change 9.14% -0.90% 105.53% 0.00% 14.59% -6.40% 22.52% -13.40% 33.64% 13.60% 15.02% 9.00% 8.60% 8.79% 14.09% <-Median-> 10 Change
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.19% 33.78% 34.35% 32.04% <-Median-> 10 Margin
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,388 Debt US$
Change 68.36% 8.64% 6.75% 4.77% 7.74% 6.40% 36.70% -2.40% 20.05% 3.91% 7.74% <-Median-> 9 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.17 0.19 <-Median-> 9 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 11.07 12.76 <-Median-> 9 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.29 3.34 <-Median-> 9 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 $11,516 Debt CDN$
Change 63.24% 1.50% 16.09% -0.25% 5.62% 5.95% 46.03% -4.69% 30.60% -0.87% 5.95% <-Median-> 9 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.17 0.19 <-Median-> 9 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 11.07 12.76 <-Median-> 9 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.29 3.34 <-Median-> 9 Debt to Cash Flow (Years) CDN$
Intangibles US$ $929 $905 $937 $887 $1,067 $1,087 $1,129 $1,163 $1,155 $1,351 $1,674 $1,604 $1,992 $2,067 112.49% <-Total Growth 10 Intangibles US$
Goodwill $288 $220 $166 $177 $4,390 $4,682 $5,032 $5,516 $5,727 $6,188 $6,902 $7,404 $7,950 $8,056 4691.45% <-Total Growth 10 Goodwill US$
Goodwill and Intangibles US$ $1,217 $1,125 $1,103 $1,064 $5,457 $5,769 $6,160 $6,679 $6,882 $7,538 $8,576 $9,008 $9,942 $10,123 801.18% <-Total Growth 10 Total US$
Change 17.91% -7.52% -1.97% -3.57% 412.97% 5.71% 6.78% 8.43% 3.03% 9.54% 13.77% 5.03% 10.37% 1.82% 7.60% <-Median-> 10 Change US$
Intangible/Market Cap Ratio 0.73 0.59 0.49 0.42 0.40 0.31 0.32 0.28 0.26 0.21 0.25 0.23 0.22 0.21 Intangible/Market Cap Ratio US$
Intangibles CDN$ $928 $963 $1,087 $1,228 $1,433 $1,364 $1,540 $1,511 $1,471 $1,712 $2,267 $2,121 $2,866 $2,838 163.55% <-Total Growth 10 Intangibles CDN$
Goodwill $287 $234 $192 $245 $5,895 $5,873 $6,864 $7,165 $7,291 $7,845 $9,348 $9,793 $11,440 $11,059 5842.95% <-Total Growth 10 Goodwill CDN$
Goodwill and Intangibles CDN$ $1,215 $1,197 $1,280 $1,473 $7,328 $7,237 $8,404 $8,675 $8,762 $9,557 $11,616 $11,914 $14,306 $13,897 1017.76% <-Total Growth 10 Total CDN$
Change 15.25% -1.47% 6.92% 15.11% 397.40% -1.23% 16.12% 3.23% 1.00% 9.08% 21.54% 2.57% 20.07% -2.85% 12.09% <-Median-> 10 Change CDN$
Intangible/Market Cap Ratio 0.74 0.60 0.49 0.42 0.40 0.31 0.32 0.28 0.26 0.21 0.25 0.23 0.22 0.21 0.27 <-Median-> 10 Intangible/Market Cap Ratio CDN$
Current Assets US$ $313.08 $301.66 $295.64 $275.24 $832.57 $1,176.87 $1,092.90 $1,130.60 $1,408.27 $1,032.78 $1,117.65 $1,141.79 $1,226.91 $1,281.04 315.00% <-Total Growth 10 Current Assets US$
Current Liabilities $307.37 $301.96 $330.43 $300.15 $692.18 $802.60 $860.71 $1,007.23 $1,028.65 $1,232.75 $1,512.64 $1,687.93 $1,878.83 $1,829.48 468.60% <-Total Growth 10 Current Liabilities US$
Liquidity 1.02 1.00 0.89 0.92 1.20 1.47 1.27 1.12 1.37 0.84 0.74 0.68 0.65 0.70 1.02 <-Median-> 10 Ratio US$
Curr Long Term Debt $6.907 $5.969 $5.428 $0.494 $1.650 $11.659 $1.786 $0.465 $8.268 $6.020 $6.759 $26.462 $7.851 $16.096
Liquidity Less CLTD 1.04 1.02 0.91 0.92 1.21 1.49 1.27 1.12 1.38 0.84 0.74 0.69 0.66 0.71 0.74 <-Median-> 5 Liquidity Less CLTD
Assets US$ $3,476 $3,393 $3,376 $3,245 $11,193 $12,015 $12,627 $13,738 $13,992 $14,700 $17,135 $17,916 $19,818 $20,254 486.94% <-Total Growth 10 Assets US$
Liabilities $2,203 $2,103 $2,148 $2,116 $5,538 $5,741 $6,167 $6,799 $7,129 $7,706 $10,021 $10,218 $11,957 $12,240 456.77% <-Total Growth 10 Liabilities US$
Debt Ratio 1.58 1.61 1.57 1.53 2.02 2.09 2.05 2.02 1.96 1.91 1.71 1.75 1.66 1.65 1.94 <-Median-> 10 Ratio US$
Estimates BVPS $32.68 $34.96 $37.87 Estimates Estimates BVPS
Estimate Book Value $8,432.1 $9,020.4 $9,771.2 Estimates Estimate Book Value
P/B Ratio (Close) 5.78 5.40 4.99 Estimates P/B Ratio (Close)
Difference from 10 year median 86.65% Diff M/C Estimates Difference from 10 yr med.
Total Book Value $1,272.6 $1,289.6 $1,228.8 $1,128.9 $5,654.9 $6,274.1 $6,460.2 $6,938.4 $6,863.4 $6,993.5 $7,113.6 $7,697.8 $7,860.4 $8,014.2 539.68% <-Total Growth 10 Book Value US$
Non-Con Int US$ $0.00 $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 Non-Con Int US$ US$
Book Value US$ $1,272.6 $1,289.6 $1,228.8 $1,128.9 $5,647.5 $6,268.7 $6,454.6 $6,933.5 $6,859.3 $6,988.9 $7,108.7 $7,692.8 $7,860.4 $8,014.2 $8,014.2 $8,014.2 539.68% <-Total Growth 10 Book Value US$
Book Value per Share $22.98 $23.32 $22.76 $14.36 $21.49 $23.79 $24.53 $26.30 $26.10 $26.86 $27.64 $29.86 $30.46 $31.06 $31.06 $31.06 33.83% <-Total Growth 10 Book Value per Share US$
Increase 1.02% 1.46% -2.38% -36.90% 49.60% 10.71% 3.10% 7.23% -0.77% 2.91% 2.93% 8.03% 2.01% 1.96% 0.00% 0.00% 96.38% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 1.22 1.40 1.62 2.50 1.98 2.62 2.98 3.21 2.80 4.39 4.93 4.63 5.57 5.95 5.95 5.95 1.65 P/B Ratio Historical Median US$
P/B Ratio (Close) 1.30 1.47 1.83 2.27 2.44 2.98 3.03 3.45 3.93 5.07 4.80 5.00 5.63 6.08 6.08 6.08 2.46% <-IRR #YR-> 10 Book Value per Share US$
Change 9.15% 12.94% 24.50% 24.07% 7.41% 22.30% 1.51% 14.04% 13.85% 29.09% -5.49% 4.24% 12.68% 7.94% 0.00% 0.00% 2.98% <-IRR #YR-> 5 Book Value per Share US$
Leverage (A/BK) 2.73 2.63 2.75 2.87 1.98 1.91 1.95 1.98 2.04 2.10 2.41 2.33 2.52 2.53 2.07 <-Median-> 10 A/BV US$
Debt/Equity Ratio 1.73 1.63 1.75 1.87 0.98 0.91 0.95 0.98 1.04 1.10 1.41 1.33 1.52 1.53 1.07 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.10 5 yr Med 4.63 96.38% Diff M/C
-$23.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $30.46
-$26.30 $0.00 $0.00 $0.00 $0.00 $30.46
Current Assets CDN$ $312.55 $320.85 $342.97 $381.14 $1,117.89 $1,476.38 $1,490.94 $1,468.42 $1,793.01 $1,309.35 $1,513.74 $1,510.12 $1,765.40 $1,758.61 414.74% <-Total Growth 10 Current Assets CDN$
Current Liabilities $306.85 $321.16 $383.34 $415.63 $929.39 $1,006.86 $1,174.18 $1,308.19 $1,309.68 $1,562.88 $2,048.72 $2,232.46 $2,703.45 $2,511.51 605.24% <-Total Growth 10 Current Liabilities CDN$
Liquidity 1.02 1.00 0.89 0.92 1.20 1.47 1.27 1.12 1.37 0.84 0.74 0.68 0.65 0.70 1.02 <-Median-> 10 Ratio CDN$
Liq. with CF aft div 2.05 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.92 1.92 <-Median-> 5 Ratio CDN$
Liq. CF re  Inv+Div  0.75 1.30 1.17 1.09 1.51 1.26 1.05 1.03 1.26 0.86 0.63 0.92 0.63 1.92 0.86 <-Median-> 5 Ratio CDN$
Curr Long Term Debt $6.90 $6.35 $6.30 $0.68 $2.22 $14.63 $2.44 $0.60 $10.53 $7.63 $9.15 $35.00 $11.30 $22.10
Liquidity Less CLTD 1.04 1.02 0.91 0.92 1.21 1.49 1.27 1.12 1.38 0.84 0.74 0.69 0.66 0.71 0.74 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.09 2.48 2.24 2.22 2.17 2.82 2.74 2.48 2.56 2.05 1.92 1.80 1.69 1.93 1.92 <-Median-> 5 Ratio CDN$
Assets CDN$ $3,470 $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 $23,696 $28,516 $27,805 628.00% <-Total Growth 10 Assets CDN$
Liabilities $2,199 $2,237 $2,491 $2,930 $7,436 $7,202 $8,413 $8,831 $9,077 $9,770 $13,572 $13,514 $17,206 $16,804 590.58% <-Total Growth 10 Liabilities CDN$
Debt Ratio 1.58 1.61 1.57 1.53 2.02 2.09 2.05 2.02 1.96 1.91 1.71 1.75 1.66 1.65 1.94 <-Median-> 10 Ratio CDN$
Estimates BVPS $44.86 $47.99 $51.99 Estimates Estimates BVPS
Estimate Book Value $11,575.6 $12,383.1 $13,413.9 Estimates Estimate Book Value
P/B Ratio (Close) 5.76 5.39 4.97 Estimates P/B Ratio (Close)
Difference from 10 year median 65.87% 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,001.9
Total Book Value $1,270.4 $1,371.6 $1,425.5 $1,563.2 $7,592.8 $7,870.8 $8,813.0 $9,011.5 $8,738.5 $8,866.4 $9,634.7 $10,181.1 $11,310.3 $11,001.9 693.41% <-Total Growth 10 Book Value CDN$
Non-Con Int CDN$ $0.00 $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 CDN$
Book Value CDN$ $1,270.4 $1,371.6 $1,425.5 $1,563.2 $7,582.9 $7,864.0 $8,805.4 $9,005.2 $8,733.2 $8,860.6 $9,628.0 $10,174.5 $11,310.3 $11,001.9 $11,001.9 $11,001.9 693.41% <-Total Growth 10 Book Value CDN$
Book Value per Share $22.94 $24.80 $26.41 $19.89 $28.85 $29.85 $33.46 $34.16 $33.23 $34.05 $37.44 $39.50 $43.83 $42.64 $42.64 $42.64 65.99% <-Total Growth 10 Book Value per Share CDN$
Increase -1.26% 8.09% 6.48% -24.68% 45.06% 3.44% 12.12% 2.08% -2.73% 2.48% 9.96% 5.49% 10.98% -2.73% 0.00% 0.00% 74.52% P/B Ratio Current/10 Year Median CDN$
P/B Ratio (Median) 1.24 1.37 1.58 2.35 2.05 2.71 2.83 3.33 3.62 4.38 4.60 4.70 5.33 6.17 0.00 0.00 1.67 P/B Ratio Historical Median CDN$
P/B Ratio (Close) 1.30 1.47 1.83 2.27 2.43 2.99 3.03 3.45 3.93 5.06 4.79 5.01 5.63 6.06 6.06 6.06 5.31% <-IRR #YR-> 10 Book Value per Share 65.99% CDN$
Change 9.15% 13.14% 24.88% 23.90% 7.26% 22.74% 1.36% 14.02% 13.76% 28.89% -5.32% 4.50% 12.30% 7.76% 0.00% 0.00% 5.11% <-IRR #YR-> 5 Book Value per Share 28.32% CDN$
Leverage (A/BK) 2.73 2.63 2.75 2.87 1.98 1.91 1.95 1.98 2.04 2.10 2.41 2.33 2.52 2.53 2.07 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.73 1.63 1.75 1.87 0.98 0.91 0.95 0.98 1.04 1.10 1.41 1.33 1.52 1.53 1.07 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 3.47 5 yr Med 4.60 74.52% Diff M/C
-$24.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $43.83
-$34.16 $0.00 $0.00 $0.00 $0.00 $43.83
$484.55 <-12 mths 14.92%
Comprehensive Income US$ $107.99 $84.20 $85.16 $50.45 $216.49 $728.83 $363.96 $630.50 $214.30 $658.72 $739.59 $809.83 $421.66 395.13% <-Total Growth 10 Comprehensive Income US$
NCI $0.00 $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 $0.03 $0.03 #DIV/0! <-Total Growth 10 Comprehensive Income US$
Shareholders $107.99 $84.20 $85.16 $50.45 $215.71 $728.23 $363.67 $630.66 $214.99 $658.28 $739.25 $809.80 $421.63 395.10% <-Total Growth 10 Comprehensive Income US$
Increase 150.64% -22.04% 1.15% -40.76% 327.57% 237.60% -50.06% 73.42% -65.91% 206.19% 12.30% 9.54% -47.93% 9.5% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $46.49 $32.04 $34.86 $22.91 $108.70 $232.75 $288.64 $397.75 $430.65 $519.17 $521.37 $610.60 $568.79 17.35% <-IRR #YR-> 10 Comprehensive Income 395.10% US$
ROE US$ 8.5% 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 10.5% 5.4% -7.74% <-IRR #YR-> 5 Comprehensive Income -33.14% US$
5Yr Median 7.0% 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 9.4% 9.4% 32.21% <-IRR #YR-> 10 5 Yr Running Average 1531.87% US$
% Difference from NI 14.45% -28.63% -32.69% -59.27% -12.34% 26.14% -33.56% 11.18% 4.97% 6.44% -11.60% 6.09% -31.62% 7.42% <-IRR #YR-> 5 5 Yr Running Average 43.00% US$
Median Values Diff 5, 10 yr -3.3% 5.0% 9.4% <-Median-> 5 Return on Equity US$
-$85.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $421.6
-$630.7 $0.0 $0.0 $0.0 $0.0 $421.6
-$34.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $568.8
-$397.7 $0.0 $0.0 $0.0 $0.0 $568.8
Current Liability Coverage Ratio US$ 1.34 1.47 1.44 1.33 1.20 1.57 1.60 1.50 1.39 1.36 1.29 1.25 1.30 1.40   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.30 1.30 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 11.86% 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 11.80% 12.30% 12.60% CFO / Total Assets US$
5 year Median 11.82% 11.86% 13.07% 13.07% 12.31% 12.31% 10.92% 10.92% 10.47% 10.92% 11.02% 11.38% 11.42% 11.80% 11.4% <-Median-> 5 Return on Assets  US$
Return on Assets ROA US$ 2.71% 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.90% Net  Income/Assets Return on Assets US$
5Yr Median 2.19% 2.36% 2.71% 3.48% 3.48% 3.75% 3.82% 4.13% 4.13% 4.20% 4.20% 4.20% 4.20% 4.26% 4.2% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ 7.41% 9.15% 10.30% 10.97% 4.35% 9.20% 8.47% 8.18% 2.98% 8.84% 11.76% 9.92% 7.84% 14.92% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 5.99% 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% 8.8% <-Median-> 5 Return on Equity US$
Adjusted Net Income $113.19 $127.15 $153.08 -$6.89 $395.20 $570.67 $667.3 $719.56 $695.79 $846.60 $985.27 $1,081.25 $1,239.29 72.23% <-Total Growth 7 Net Income US$
$628.03 <-12 mths 1.86%
Net Income US$ $94.36 $117.97 $126.52 $123.88 $246.54 $577.42 $547.15 $566.68 $203.99 $618.49 $836.00 $762.83 $617.57 388.14% <-Total Growth 10 Net Income US$ US$
NCI $0.00 $0.00 $0.00 $0.00 $0.78 $0.60 $0.28 -$0.16 -$0.69 $0.44 $0.34 $0.03 $1.00 #DIV/0! <-Total Growth 10 NCI US$
Shareholders $94.36 $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,196 $1,390 $1,599 387.35% <-Total Growth 10 Net Income US$
Increase -148.11% 25.03% 7.24% -2.09% 98.39% 134.71% -5.19% 3.65% -63.89% 201.96% 35.21% -8.72% -19.17% 93.98% 16.22% 15.04% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $11.5 $27.5 $43.4 $53.3 $141.7 $238.2 $324.0 $412.0 $428.2 $502.7 $554.4 $597.6 $607.6 $805.8 $960.2 $1,112.9 17.16% <-IRR #YR-> 10 Net Income 387.35% US$
Operating Cash Flow $336.76 $450.74 $450.74 $415.02 $795.31 $1,187.26 $1,411.24 $1,540.55 $1,408.52 $1,698.23 $2,022.49 $2,126.82 $2,228.93 1.70% <-IRR #YR-> 5 Net Income 8.77% US$
Investment Cash Flow -$530.53 -$261.77 -$289.46 -$311.13 -$296.40 -$966.23 -$1,371.82 -$1,426.01 -$1,046.04 -$1,693.48 -$3,087.17 -$1,581.08 -$3,159.18 30.21% <-IRR #YR-> 10 5 Yr Running Average 1301.10% US$
Accruals   $288.13 -$71.00 -$34.76 $19.99 -$253.16 $355.79 $507.46 $452.30 -$157.80 $613.30 $1,900.34 $217.06 $1,546.82 8.08% <-IRR #YR-> 5 5 Yr Running Average 47.45% US$
Total Assets $3,476 $3,393 $3,376 $3,245 $11,193 $12,015 $12,627 $13,738 $13,992 $14,700 $17,135 $17,916 $19,818 Balance Sheet Assets US$
Accruals Ratio 8.29% -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 1.21% 7.81% 4.17% <-Median-> 5 Ratio US$
-$126.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $616.6
-$566.8 $0.0 $0.0 $0.0 $0.0 $616.6
-$43.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $607.6
-$412.0 $0.0 $0.0 $0.0 $0.0 $607.6
Financial Cash Flow US$ $209.59 -$183.51 -$94.75 -$98.75 -$354.87 $56.76 -$187.58 -$95.89 -$78.22 -$499.50 $1,028.46 -$544.41 $944.95 C F Statement  Financial Cash Flow US$
Accruals   $78.54 $112.51 $59.98 $118.74 $101.71 $299.03 $695.03 $548.19 -$79.58 $1,112.80 $871.88 $761.47 $601.87 Accruals US$
Accruals Ratio 2.26% 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.25% <-Median-> 5 Ratio US$
$665.19 <-12 mths 9.64%
Comprehensive Inc CDN$ $107.81 $89.55 $98.80 $69.86 $290.68 $914.32 $496.51 $818.90 $272.85 $835.13 $1,001.70 $1,071.08 $606.73 514.12% <-Total Growth 10 Comprehensive Income CDN$
NCI $0.00 $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46 $0.03 $0.04 #DIV/0! <-Total Growth 10 NCI CDN$
Shareholders $107.81 $89.55 $98.80 $69.86 $289.63 $913.57 $496.12 $819.11 $273.72 $834.57 $1,001.24 $1,071.05 $606.69 514.09% <-Total Growth 10 Comprehensive Income CDN$
Increase 149.50% -16.94% 10.32% -29.29% 314.59% 215.42% -45.69% 65.10% -66.58% 204.89% 19.97% 6.97% -43.36% 6.97% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $53.21 $32.81 $37.64 $29.64 $131.13 $292.28 $373.60 $517.66 $558.43 $667.42 $684.95 $799.94 $757.45 19.90% <-IRR #YR-> 10 Comprehensive Income 514.09% CDN$
ROE CDN$ 8.5% 6.5% 6.9% 4.5% 3.8% 11.6% 5.6% 9.1% 3.1% 9.4% 10.4% 10.5% 5.4% -5.83% <-IRR #YR-> 5 Comprehensive Income -25.93% CDN$
5Yr Median 7.0% 6.7% 6.7% 6.5% 6.5% 6.5% 5.6% 5.6% 5.6% 9.1% 9.1% 9.4% 9.4% 35.01% <-IRR #YR-> 10 5 Yr Running Average 1912.32% CDN$
% Difference from NI 14.5% -28.6% -32.7% -59.3% -12.3% 26.1% -33.6% 11.2% 5.0% 6.4% -11.6% 6.1% -31.6% 7.91% <-IRR #YR-> 5 5 Yr Running Average 46.32% CDN$
Median Values Diff 5, 10 yr -3.3% 5.0% 9.41% <-Median-> 5 Return on Equity CDN$
-$98.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $606.69
-$819.11 $0.00 $0.00 $0.00 $0.00 $606.69
-$37.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $757.45
-$517.66 $0.00 $0.00 $0.00 $0.00 $757.45
Current Liability Coverage Ratio CDN$ 1.34 1.47 1.44 1.33 1.20 1.57 1.60 1.50 1.39 1.36 1.29 1.25 1.30 1.40   CFO / Current Liabilities CDN$
5 year Median 1.32 1.34 1.44 1.44 1.34 1.44 1.44 1.50 1.50 1.50 1.39 1.36 1.30 1.30 1.30 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 11.86% 13.07% 14.10% 12.31% 7.42% 10.47% 10.92% 11.02% 10.24% 11.42% 11.38% 11.80% 12.30% 12.60% CFO / Total Assets CDN$
5 year Median 11.82% 11.86% 13.07% 13.07% 12.31% 12.31% 10.92% 10.92% 10.47% 10.92% 11.02% 11.38% 11.42% 11.80% 11.4% <-Median-> 5 Return on Assets  CDN$
Comments
Comments
Return on Assets ROA CDN$ 2.7% 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.9% Net  Income/Assets Return on Assets CDN$
5Yr Median 2.2% 2.4% 2.7% 3.5% 3.5% 3.7% 3.8% 4.1% 4.1% 4.2% 4.2% 4.2% 4.2% 4.3% 4.2% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 7.4% 9.1% 10.3% 11.0% 4.4% 9.2% 8.5% 8.2% 3.0% 8.8% 11.8% 9.9% 7.8% 14.9% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 6.0% 6.0% 7.4% 9.1% 9.1% 9.2% 9.2% 8.5% 8.2% 8.5% 8.5% 8.8% 8.8% 9.9% 8.8% <-Median-> 5 Return on Equity CDN$
$862.15 <-12 mths -2.82%
Net Income CDN$ $94.20 $125.47 $146.77 $171.54 $331.03 $724.37 $746.43 $736.01 $259.72 $784.12 $1,132.28 $1,008.91 $888.63
NCI $0.00 $0.00 $0.00 $0.00 $1.05 $0.76 $0.39 -$0.21 -$0.87 $0.56 $0.46 $0.03 $1.44
Shareholders $94.20 $125.47 $146.77 $171.54 $329.98 $723.62 $746.04 $736.21 $260.59 $783.56 $1,131.82 $1,008.88 $887.18 $1,642 $1,908 $2,195 504.47% <-Total Growth 10 Net Income CDN$
Increase -147.02% 33.20% 16.97% 16.87% 92.37% 119.29% 3.10% -1.32% -64.60% 200.68% 44.45% -10.86% -12.06% 85.07% 16.22% 15.04% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $12.8 $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,090.7 $1,315.6 $1,528.2 19.71% <-IRR #YR-> 10 Net Income 504.47% CDN$
Operating Cash Flow $336.19 $479.40 $522.90 $574.69 $1,067.87 $1,489.42 $1,925.21 $2,000.86 $1,793.33 $2,153.01 $2,739.26 $2,812.93 $3,207.20 3.80% <-IRR #YR-> 5 Net Income 20.51% CDN$
Investment Cash Flow -$529.64 -$278.41 -$335.80 -$430.83 -$397.97 -$1,212.14 -$1,871.44 -$1,852.10 -$1,331.82 -$2,147.00 -$4,181.26 -$2,091.14 -$4,545.74 32.73% <-IRR #YR-> 10 5 Yr Running Average 1596.65% CDN$
Accruals   $287.64 -$75.51 -$40.33 $27.68 -$339.92 $446.34 $692.27 $587.45 -$200.91 $777.54 $2,573.82 $287.09 $2,225.72 8.51% <-IRR #YR-> 5 5 Yr Running Average 50.40% CDN$
Total Assets $3,470 $3,608 $3,917 $4,493 $15,029 $15,072 $17,226 $17,843 $17,815 $18,637 $23,207 $23,696 $28,516 Balance Sheet Assets CDN$
Accruals Ratio 8.29% -2.09% -1.03% 0.62% -2.26% 2.96% 4.02% 3.29% -1.13% 4.17% 11.09% 1.21% 7.81% 4.17% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.21 0.24 0.24 0.42 0.34 0.46 0.39 0.37 0.14 0.37 0.43 0.36 0.25 0.37 <-Median-> 10 EPS/CF Ratio CDN$
-$146.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $887.2
-$736.2 $0.0 $0.0 $0.0 $0.0 $887.2
-$48.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $814.4
-$541.5 $0.0 $0.0 $0.0 $0.0 $814.4
Change in Close 7.78% 22.30% 32.97% -6.67% 55.59% 26.96% 13.65% 16.40% 10.66% 32.09% 4.11% 10.24% 24.63% 4.83% 0.00% 0.00% Count 24 Years of data CDN$
up/down Up down down down Count 10 41.67% CDN$
Meet Prediction? % right Count 1 10.00% CDN$
Financial Cash Flow CDN$ $209.24 -$195.18 -$109.92 -$136.74 -$476.48 $71.21 -$255.89 -$124.55 -$99.59 -$633.26 $1,392.95 -$720.03 $1,359.68 C F Statement  Financial CF CDN$
Accruals   $78.40 $119.67 $69.59 $164.42 $136.57 $375.13 $948.17 $711.99 -$101.32 $1,410.80 $1,180.87 $1,007.12 $866.04 Accruals CDN$
Accruals Ratio 2.26% 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.25% <-Median-> 5 Ratio CDN$
Cash US$ $29.94 $31.98 $41.64 $35.78 $154.38 $433.82 $403.97 $423.22 $423.22 $219.62 $181.36 $184.04 $198.17 $109.39 Cash US$
Cash CDN$ $29.89 $34.01 $48.30 $49.55 $207.29 $544.22 $551.09 $549.68 $538.84 $278.43 $245.64 $243.41 $285.15 $150.18 Cash CDN$
Cash per Share CDN$ $0.54 $0.62 $0.89 $0.63 $0.79 $2.07 $2.09 $2.09 $2.05 $1.07 $0.96 $0.94 $1.11 $0.58 $1.07 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 1.82% 1.69% 1.85% 1.40% 1.12% 2.32% 2.07% 1.77% 1.57% 0.62% 0.53% 0.48% 0.45% 0.23% 0.53% <-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.37 $0.42 $0.48 $0.18 $0.62
Split in June 2017 $0.12
Dividend US$ $0.25 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $1.17 269.47% <-Total Growth 10 Dividends US$
Increase 17.46% 12.16% 14.46% -61.26% 234.24% 21.95% 16.00% 14.66% 14.29% 11.18% 11.83% 11.11% 11.43% Count 16 Years of data US$
Dividends 5 Yr Running $0.12 $0.17 $0.22 $0.23 $0.27 $0.33 $0.39 $0.46 $0.58 $0.67 $0.76 $0.85 $0.95 247.50% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 0.88% 0.85% 0.86% 0.34% 0.96% 0.80% 0.79% 0.79% 1.04% 0.72% 0.69% 0.76% 0.69% 0.77% <-Median-> 10 Yield H/L Price US$
Yield on High  Price 0.78% 0.74% 0.74% 0.29% 0.78% 0.69% 0.72% 0.70% 0.73% 0.61% 0.65% 0.70% 0.61% 0.70% <-Median-> 10 Yield on High  Price US$
Yield on Low Price 1.01% 0.99% 1.02% 0.42% 1.26% 0.95% 0.88% 0.90% 1.83% 0.87% 0.74% 0.82% 0.80% 0.88% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 0.82% 0.81% 0.76% 0.38% 0.78% 0.70% 0.78% 0.73% 0.74% 0.62% 0.71% 0.70% 0.68% 0.71% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 15.89% 14.15% 15.02% 5.71% 38.44% 22.94% 28.02% 31.07% 97.44% 35.81% 29.17% 35.59% 48.95% 33.33% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 57.36% 50.64% 39.90% 13.22% 23.22% 26.43% 30.30% 34.62% 46.14% 44.33% 44.62% 45.77% 49.91% 39.48% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 4.06% 3.39% 3.79% 2.32% 13.55% 11.10% 10.81% 11.38% 14.18% 12.95% 12.02% 12.72% 13.54% 12.37% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 3.94% 4.23% 4.58% 1.76% 6.64% 8.53% 10.93% 13.84% 15.77% 15.31% 15.26% 15.51% 15.96% 14.55% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 3.31% 3.45% 3.59% 2.41% 12.97% 10.47% 11.07% 11.58% 13.94% 13.09% 12.46% 12.80% 12.38% 12.42% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 3.67% 4.03% 4.26% 1.66% 6.30% 8.37% 10.71% 13.85% 15.59% 15.27% 15.51% 15.70% 15.75% 14.56% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median values 10 Yr Med 10 Yr Cl 0.77% 0.71% 5 Yr Med 5 Yr Cl 0.72% 0.70% 5 Yr Med Payout 35.81% 12.95% 12.80% 11.96% <-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% 13.96% <-IRR #YR-> 10 Dividends US$
Dividends Growth 15 14.55% <-IRR #YR-> 13 Dividends
Dividends Growth 5 -$0.67 $0.00 $0.00 $0.00 $0.00 $1.17
Dividends Growth 10 -$0.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.17
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.17
Price Close US$ Waste Connection $22.53 $29.09 $29.33 $37.55 $52.39 $70.94 $74.25 $90.79 $102.57 $136.27 $132.56 $149.27 $171.58 $188.83 $188.83 $188.83 485.06% <-Total Growth 10 Stock Price US$
Increase 1.96% 29.12% 0.83% 28.03% 39.54% 35.40% 4.67% 22.28% 12.97% 32.86% -2.72% 12.61% 14.95% 10.05% 0.00% 0.00% 13.58% <-IRR #YR-> 5 Stock Price 88.99% US$
P/E 5.77% <-IRR #YR-> 10 Stock Price 485.06% US$
Trailing P/E 14.38% <-IRR #YR-> 5 Price & Dividend US$
Median 10, 5 Yrs D.  per yr 0.73% 0.81% % Tot Ret 11.25% 5.60% T P/E #NUM! P/E:  #NUM! #NUM! 6.50% <-IRR #YR-> 10 Price & Dividend US$
Price  15 17.74% <-IRR #YR-> 15 Stock Price
Price  20 16.01% <-IRR #YR-> 19 Stock Price
Price & Dividend 15 18.67% <-IRR #YR-> 15 Price & Dividend
Price & Dividend 20 16.75% <-IRR #YR-> 19 Price & Dividend
Price 5 -$90.79 $0.00 $0.00 $0.00 $0.00 $171.58
Price 10 -$29.33 $0.00 $0.00 $0.00 $0.00 -$90.79 $0.00 $0.00 $0.00 $0.00 $171.58
Price & Dividend 5 -$90.79 $0.76 $0.85 $0.95 $1.05 $172.75
Price & Dividend 10 -$29.33 $0.12 $0.41 $0.50 $0.58 -$90.79 $0.76 $0.85 $0.95 $1.05 $172.75
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 $171.58
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 $171.58
Price & Dividend 15 $0.25 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $172.75
Price & Dividend 20 $0.25 $0.28 $0.32 $0.12 $0.41 $0.50 $0.58 $0.67 $0.76 $0.85 $0.95 $1.05 $172.75
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.
Distri Inc
Increase
Funds From operations FFO
Graham Pr Distr
Prem/Disc
Notes:
June 14, 2024.  Last estimates were for 2023, 2024 and 2025 of $8079, $8676M, $9396M US$ Revenue, $4.22, $4.77, $5.38 US$ AEPS, $3.74, $4.30, $4.73 US$ EPS, 
$1.06, $1.15 and $1.28 US$ Dividends, $1224M, $1372M, $1533M US$ FCF, $8.36, $9.05, $9.67 CFPS, $29.70, $31.30, $32.40 US$ BVPS, $956M, $1088M, $1160M US$ Net Income.
June 11, 2023.  Last estimates were for 2022, 2023 and 2024 of 7056M, $7575M and $8090M US$ for Revenue, $3.76, $4.32 and $5.03 US$ for AEPS, $3.27, $3.86 and $4.32 USS$ for EPS, 
$0.96, $1.05 and $1.19 US$ for Dividends, 1.182M, $1267M and $1344M US$ for FCF, $7.81, $7.90 and $8.53 US$ for CFPS, $27.20, $28.30 and $28.50 US$ for BVPS, and $845M, $981M and $1057M US$ for Net Income.
June 12, 2022.  Last estimates were for $5966M, $6375M and $6799M US$ for Revenue, $2.71, $3.09 and $3.65 US$ for EPS, $0.87, $0.99 and $1.12 US$ for Dividend, 
$995M, $1085M and $1130M US$ for FCF, $5.76, $6.41 and $6.56 US$ for CFPS and $714M, $808M and $911M US$ for Net Income.
June 13, 2021. Last estimates were for 5312M, $5699M and $6108M IS$ for Revenue, $1.92, $2.43 and $2.75 US$ for EPS, $0.76, $0.85 and $1.01 US$ for Dividends, 
$831M, $980M and $1033M US$ for FCF, $5.29, $5.68 and $5.65 US$ for CFPS, and $503M, $638M and $678MUS$ for Net Income.
Jun 13, 2020.  Last estimates were for 2019, 2020 and 2021 of $5375M, $5724M and |$6252M US$ for Revenue, 
$2.35, $2.78 and $3.28 US$ for EPS, $4.17, $5.50 and $7.35 US$ for CFPS and $627M, $723M and $796M US$ for Net Income.
June 14, 2019.  Last estimates were for 4904M, $5206M and $5688M for Revenue US$, $2.21, $2.55 and $2.97 EPS US$, $5.17, $5.92 and $6.77 for CFPS US$, $583M, $666M and $737M for Net Income US$.
June 2, 2017.  Last estimates were for 2016, 2017 and 2018 of $1956M, $2025M and $2080M US$ for Revenue, $1.09, $1.42 and $1.52 US$ for EPS,
 $3.38, $3.91 and $4.08 US$ for CFPS and $127M and $158M US$ for 2016 and 2017.
June 2016.  Name was changed to Waste Connections Inc. from Progressive Waste Solutions Ltd.  This was called a reverse merger where Waste Connections Inc took over 
Progressive Waste Solutions but the results will be that the company will be domiciled in Canada.
July 2016.  BIN on US exchange is $31.61.  There is now WCN on both TSX and NYSE. Old web site is below.  It seems to have changed also.  
www.progressivewaste.com
2016.  Waste Connections Inc. (NTSE-WCN) has amalgamated with Progressive Waste Solutions with Progressive Waste Solutions getting .4815 of a share of the new company and Waste Connections getting 2.076843 shares of Waste Connections.
May 10, 2016.  Last estimates were for 2015, 2016 and 2017 of $1951M, $2028M and $2097M US$ for Revenue, $1.23, $1.52 and $1.66 US$ for EPS, $3.25, $3.13 and $4.35 US$ for CFPS and $137M, $167M and $183M US$ for Net Income.
May 23, 2015.  Last estimates were for 2014, 2015 and 2016 of $2020.4M, $2087.9M and $2151.0M for Revenue US$, $1.10 and $1.24 US$ for EPS, $3.40, $3.52 and $3.86 for CFPS US$, $124M and $142M for 2014 and 2015 for Net Income US$.
May 14, 2014.  Last estimates were at $2017M and $2089M US$ for Revenue, $1.12 and $1.21 US$ for EPS, $2.82 and   $3.17 US for CFPS.
April 28, 2013.  Last Estimates were for 2012 and 2013 at $1890M and $1962M US$ for Revenue, $1.12, $1.29 (and $1.41) for Adj EPS, $1.10, $1.31 and $1.43 for EPS and $1.58, $2.25 for CFPS
Feb 14, 2013, unaudited 2012 results in news release.
May 5, 2012.  Last estimates were for 2011 and 2012 at $1844M and $2000M US$ for Revenue, $1.15 and $1.32 for EPS US$ and $3.07 and $3.48 CF US$.
Analysts are using a adjusted EPS.  Biggest adjust this year, 2011 was for non-cash good will impairment charge. 
The most significant adjustment to adjusted net income (A) in the year was a non-cash goodwill impairment U.S. northeast operations.charge of $360.6 million related to our
Shares were sold in 2010 and 2009 to pay down debt and to buy assets (about half and half).
July 2011. KEEP EYE ON, MAYBE SELL IF NO DIVIDEND INCREASES.  Increased dividends in 2012.
July 1, 2011.  Last I looked, I got estimates for 2010 and 2011 of $.89 and $1.15 for Earnings and $2.45 and $2.90 for Cash Flow.
May 2, 2011.  Company changes name from IESI-BFC to Progressive Waste Solutions Ltd.  
Jul 21, 2010.  I got estimates for 2010 and 2011 last at $.85 and $1.02 for earnings and $2.40 and $2.52 for cash flow.
May 8, 2010.  I last got estimates for 2009 and 2010 of $.80 and $.84 for earnings and $2.88 and $3.00 for cash flow.
July 31, 2009.  There is still a big range in estimates for earnings.  However, I am going with the lower ones. With change to corp. $.50 per share were considered special dividends.
May 27, 2009  BFI Canada Ltd. completed an amalgamation with its wholly-owned subsidiary, IESI-BFC Ltd. The name of the newly amalgamated Company is IESI-BFC Ltd. The Company.  Symbol change 
from BFC to BIN will continue to operate as "BFI Canada" in Canada and "IESI" in the United States.
April 2009 AR 2008.  In July 2008, I picked up estimates of earnings at $.97, Distributible Cash at $2.95, Revenue at $1069.8 and Cash Flow of $3.09 per share.
The estimates for 2009 and 2010 have a huge variance ranging from $.64 and $.69 to $1.77 and $1.95 and various amounts in between.  I do not know why this should be?
However, all my sources seem to agree that this stock is a Buy.
Aug 18, 2008.  Company annouced change from an Income Fund BFI to a Corporation and dividend decrease from $1.82 to $0.50 per year. On October 2, 2008 company started trading on 
TSX as a  non-income Trust.  Income Trust was wound up effective 30 June 2009.
AP 2007.  Stock price not doing well.  However, TD still has it as an action buy.  G&M says strong buy.  They seem to be making money? But could we all be wrong on this?  
Always wrong to go against the market. TD expects the stock price in one year to be $34 from $23.92 March 10, 2008 for an 49.7% return??????
AP 2006. Last 3 years stock price has been treading water only. I think stock got too high, but that I paid a reasonable price in 2007 for this stock.
On TD Bank's Action Buy list still on 1 July 2008
The company changed from BFI Canada Income Fund (TSX-BFC.UN) Oct 2008 To BFI Canada (TSX-BFC). This was a change from an Income Trust to a corporation.  
In June 2009, the company changed to IESI-BFC Ltd (TSX-BIN). The company was known as IESI in US and BFC in Canada.  In May 2011 the company changed to Progressive Waste Solutions Ltd (TSX-BIN).
April 15, 2002.  BFI Canada Income Fund was started and it holds the common Shares and notes of BFI Canada Inc. 
June 2016.  Name was changed to Waste Connections Inc. from Progressive Waste Solutions Ltd.  This was called a reverse merger where Waste Connections Inc took over 
2016.  Waste Connections Inc. (NTSE-WCN) has amalgamated with Progressive Waste Solutions with Progressive Waste Solutions getting .4815 of a share of the new company and Waste Connections getting 2.076843 shares of Waste Connections.
May 2, 2011.  Company changes name from IESI-BFC to Progressive Waste Solutions Ltd.  
May 27, 2009  BFI Canada Ltd. completed an amalgamation with its wholly-owned subsidiary, IESI-BFC Ltd. The name of the newly amalgamated Company is IESI-BFC Ltd. The Company.  Symbol change 
from BFC to BIN will continue to operate as "BFI Canada" in Canada and "IESI" in the United States.
Aug 18, 2008.  Company annouced change from an Income Fund BFI to a Corporation 
In June 2009, the company changed to IESI-BFC Ltd (TSX-BIN). The company was known as IESI in US and BFC in Canada.  In May 2011 the company changed to Progressive Waste Solutions Ltd (TSX-BIN).
April 15, 2002.  BFI Canada Income Fund was started and it holds the common Shares and notes of BFI Canada Inc. 
Adjusted net income and EPS exclude such things as restructuring expenses, goodwill impairment, amortization and net gain or loss on sale of capital assets.
Sector:
Services, Industrial
What should this stock accomplish?
Would I buy this company and Why.
Restricted Shares 
Restricted Shares are share based compensation.
Why I bought this stock
I do not own this stock of Waste Connections Inc. (TSX-WCN, NYSE-WCN), but I used to.  I first bought this stock in 2007 because TD Securities had a very favorable report on this stock and 
had it on their action buy list.  I had money because I had recently sold RIM.  At that time it was BFI Canada Income Fund.  In 2010, I needed to buy something for Pension Account. I have this
 already and it is on TD Action Buy List.  I sold when it because the target of a reverse takeover by an American company.
Dividends
Dividends are paid now in cycle 2 of February, May, August and November.
Dividends are paid in Cycle 1, that is January, April, July and October.  Dividends are declared in one month and payable in the following month.
For example, the dividend for shareholder of record on September 30, 2014 is payable on October 15, 2014.
How they make their money.
Waste Connections is the third-largest integrated provider of traditional solid waste and recycling services in the North America.
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.  
Also, for the Operational Profit Margin, a higher percentage is better.  With the OPM, you should only compare companies in similar industries.
Need to buy something for Pension Acct. I have this already and it is on TD Action Buy List.  Of 13 analysts, 11 say strong buy and 2 hold.
Purchased some for $27.73 in 2007 and this time it is cheaper.  Spreadsheet measures
Shares; '%, Value $M %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Change
Date 2016 Jun 11 2018 Jun 14 2019 Jun 13 2020 Jun 13 2021 Jun 12 2022 Jun 12 2023 Jun 14 2024 Jun 9 2024
Mittelstaedt, Ronald J.  0.05% 0.100 0.04% 0.139 0.05% 0.192 0.07% 0.190 0.07% 0.205 0.08% 0.220 0.09% 0.223 0.09% 0.236 0.09% 5.94%
CEO - Shares - Amount $11.930 $10.180 $16.409 $25.011 $32.791 $36.883 $43.598 $54.927 $58.187
Options - percentage 0.08% 0.415 0.16% 0.274 0.10% 0.176 0.07% 0.096 0.04% 0.060 0.02% 0.052 0.02% 0.073 0.03% 0.065 0.03% -10.22%
Options - amount $17.762 $42.061 $32.335 $23.009 $16.597 $10.799 $10.202 $17.884 $16.056
Jackman, Worthing F. 0.02% 0.108 0.04% 0.117 0.04% 0.113 0.04% 0.123 0.05% 0.129 0.05%
CEO - Shares - Amount $4.568 $10.913 $13.795 $14.780 $21.189 $23.112
Options - percentage 0.03% 0.047 0.02% 0.048 0.02% 0.000 0.00% 0.079 0.03% 0.092 0.04%
Options - amount $6.109 $4.714 $5.685 $0.000 $13.640 $16.430
Whitney, Mary Anne 0.039 0.01% 0.044 0.02% 0.047 0.02% 0.050 0.02% 0.056 0.02% 0.065 0.03% 0.056 0.02% -14.20%
CFO - Shares - Amount $4.595 $5.716 $8.156 $8.980 $11.152 $16.078 $13.795
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% -12.66%
Options - amount $2.096 $2.565 $4.606 $5.381 $5.902 $6.338 $5.535
Chambkiss, Darrell W. 0.099 0.04% 0.097 0.04% 0.099 0.04% 0.095 0.04% -4.10%
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% -36.43%
Options - amount $6.112 $6.294 $8.722 $5.545
Black, Matthew Stephen 0.01% 0.023 0.01% 0.027 0.01% 0.030 0.01% 0.032 0.01% 0.035 0.01% 0.032 0.01% 0.033 0.01% 0.038 0.01% 14.45%
Officer - Shares - Amount $1.335 $2.291 $3.192 $3.933 $5.578 $6.249 $6.256 $8.238 $9.428
Options - percentage 0.00% 0.018 0.01% 0.018 0.01% 0.016 0.01% 0.018 0.01% 0.018 0.01% 0.018 0.01% 0.021 0.01% 0.014 0.01% -32.79%
Options - amount $1.101 $1.843 $2.098 $2.124 $3.131 $3.271 $3.651 $5.247 $3.526
Little, James M. 0.029 0.01% 0.028 0.01% 0.043 0.02% 52.69%
Officer - Shares - Amount $5.819 $6.958 $10.624
Options - percentage 0.162 0.06% 0.028 0.01% 0.018 0.01% -35.11%
Options - amount $31.983 $6.977 $4.527
Jordan, Elise Lipman 0.003 0.00% 0.003 0.00% 10.67%
Director - Shares - Amount $0.654 $0.724
Options - percentage 0.003 0.00% 0.003 0.00% 9.99%
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% -24.42%
Director - Shares - Amount $7.218 $5.451 $5.576 $5.895 $6.580 $7.793 $5.890
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% 6.67%
Options - amount $0.318 $0.391 $0.606 $0.674 $0.830 $1.120 $1.194
Harlan, Michael W. 0.009 0.00% 0.008 0.00% 0.008 0.00% Was Director, chair 2025 3.54%
Director - Shares - Amount $1.763 $1.972 $2.042
Options - percentage 0.004 0.00% 0.005 0.00% 0.005 0.00% 6.67%
Options - amount $0.830 $1.120 $1.194
#DIV/0!
Director - Shares - Amount
Options - percentage #DIV/0!
Options - amount
Increase in O/S Shares 0.22% 0.691 0.26% 0.642 0.24% 0.613 0.23% 0.682 0.26% 0.517 0.20% 0.396 0.15% 0.606 0.24% 0.521 0.20%
due to SO 2013 $39.785 $61.645 $65.097 $72.342 $89.021 $89.172 $71.081 $119.905 $128.438
Book Value $36.249 $23.701 $2.667 $39.000 $39.762 $48.710 $62.952 $71.217 $74.603
Insider Buying -$0.150 -$0.206 $0.000 $0.000 $0.000 $0.000 -$0.020 $0.004 $0.000
Insider Selling $3.039 $17.895 $4.023 $15.515 $22.133 $4.704 $6.658 $6.928 $18.788
Net Insider Selling 2013 $2.889 $17.689 $4.023 $15.515 $22.133 $4.704 $6.639 $6.932 $18.788
% of Market Cap 0.01% 0.07% 0.01% 0.05% 0.05% 0.01% 0.01% 0.01% 0.03%
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  7 6 8 8 8 8 8 8
Women 14% 1 14% 1 17% 2 25% 2 25% 2 25% 3 38% 3 38% 4 50% Company says they have
Minorities 0% 0 0% 0 0% 0 0% 0 0% 1 13% 1 13% 1 13% 1 13% a visible minority on the board
Institutions/Holdings 89.83% 590 90.93% 669 93.04% 20 76.12% 20 76.12% 20 52.67% 20 64.30% 20 51.49%
Total Shares Held 59.92% 239.574 91.04% 245.328 93.06% 199.183 76.55% 199.183 76.55% 135.660 52.13% 165.872 63.74% 133.057 51.57%
Increase/Decrease -0.71% 1.023 0.43% 1.602 0.66% 8.664 4.55% 8.664 4.55% -5.385 -3.82% -3.935 -2.32% -4.578 -3.33%
Starting No. of Shares 238.550 243.726 190.519 190.519 141.046 169.807 137.634
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock
13/11/07 -$5,557.99 $27.79 $1.82 200
13/12/10 -$6,879.99 $22.93 $0.50 300
13/05/16 $21,550.01 $24.88 500
8.30% XIRR
10.71% Total Return
2.41% Dividend Ret.
% from $23,889.74 Total Value Gain
$0.00 Less Sale of Stock
-$21,550.01 Less Stock Value
20.43% $2,339.73 Dividends pd per Share 18.81%
$12,437.98 Cost of Stock
$0.00 Sale of Stock
79.57% $9,112.03 Capital Gains/Loss 73.26%
100.00% $11,451.76 Total Return 92.07%
Start Date 13-Nov-07 Shares 500
End date 13-May-16 Dividends pd per Share $4.68
Years 8.50 Div less cost -$20.20
Cost $24.88
% paid by div 18.81%