This report should not be construed as providing investment advice. It is for educational purposes only.  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. Q2 2024
See my website on stocks or see my blog at the following sites.  https://spbrunner.com/stocks.html https://spbrunner.blogspot.com/
Aecon Group Inc TSX ARE OTC AEGXF https://www.aecon.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 Value Description #Y Item Total G
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Split Date
Aplit
USD - CDN$ 0.9949 1.0636 1.1601 1.3847 1.3427 1.2545 1.3642 1.2988 1.2732 1.2678 1.3544 1.3226 1.3732 1.3732 1.3732 0.17% <-IRR #YR-> 5 USD - CDN$
Change -2.17% 6.91% 9.07% 19.36% -3.04% -6.57% 8.74% -4.79% -1.97% -0.42% 6.83% -2.35% 3.83% 0.00% 0.00% 3.13% <-IRR #YR-> 10 USD - CDN$
$4,809 <-12 mths 3.55%
Revenue* $2,946.8 $3,068.6 $2,614.1 $2,918.1 $3,213.1 $2,805.7 $3,266.3 $3,460.4 $3,643.6 $3,977.3 $4,696.5 $4,643.8 $4,162 $4,598 $4,631 51.33% <-Total Growth 10 Revenue
Increase 1.75% 4.13% -14.81% 11.63% 10.11% -12.68% 16.42% 5.94% 5.29% 9.16% 18.08% -1.12% -10.38% 10.48% 0.72% 4.23% <-IRR #YR-> 10 Revenue 51.33%
5 year Running Average $2,546.1 $2,784.5 $2,855.1 $2,888.7 $2,952.1 $2,923.9 $2,963.5 $3,133 $3,278 $3,431 $3,809 $4,084 $4,224.6 $4,415.5 $4,546.3 7.29% <-IRR #YR-> 5 Revenue 42.17%
Revenue per Share $55.59 $58.04 $46.57 $51.36 $55.53 $47.32 $54.01 $56.99 $60.51 $65.39 $76.32 $74.58 $66.84 $73.84 $74.37 3.91% <-IRR #YR-> 10 5 yr Running Average 46.68%
Increase 2.30% 4.42% -19.77% 10.28% 8.12% -14.79% 14.14% 5.53% 6.16% 8.08% 16.71% -2.28% -10.38% 10.48% 0.72% 6.63% <-IRR #YR-> 5 5 yr Running Average 37.82%
5 year Running Average $47.72 $51.86 $52.96 $53.18 $53.42 $51.76 $50.96 $53.04 $54.87 $56.84 $62.64 $66.76 $68.73 $71.40 $73.19 2.54% <-IRR #YR-> 10 Revenue per Share 28.49%
P/S (Price/Sales) Med 0.21 0.23 0.31 0.25 0.29 0.36 0.32 0.34 0.24 0.29 0.17 0.16 0.23 0.00 0.00 6.67% <-IRR #YR-> 5 Revenue per Share 38.09%
P/S (Price/Sales) Close 0.19 0.28 0.23 0.30 0.27 0.42 0.33 0.31 0.27 0.26 0.12 0.18 0.27 0.24 0.27 2.56% <-IRR #YR-> 10 5 yr Running Average 28.74%
P/S 10 Year Median  0.21 0.22 0.24 0.25 0.27 0.27 0.27 0.27 0.27 0.29 0.29 0.29 0.27 0.27 0.24 5.55% <-IRR #YR-> 5 5 yr Running Average 31.01%
*Revenue in M CDN $  P/S Med 20 yr  0.25 15 yr  0.25 10 yr  0.29 5 yr  0.24 -7.78% Diff M/C
-$3,068.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $4,643.8
-$3,266.3 $0.0 $0.0 $0.0 $0.0 $4,643.8
-$2,784.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $4,084.3
-$2,963.5 $0.0 $0.0 $0.0 $0.0 $4,084.3
-$58.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $74.58
-$54.01 $0.00 $0.00 $0.00 $0.00 $74.58
-$0.27 <-12 mths -112.86%
Convertible Debentures 4.05% 5.28% 9.96% 3.77% 4.92% 16.12% Convertible Debentures See Earnings
Stock Options Plan 1.00% 1.38% 2.29% 1.11% 1.00% 3.72% Stock Options Plan per Share
Difference 19.73% 6.49% 7.27% 15.57% 6.10% 4.17% 5.05% 6.67% 12.24% 4.88% 6.00% 19.85% Difference In Notes
EPS Basic $1.47 $0.77 $0.55 $1.22 $0.82 $0.48 $0.99 $1.20 $1.47 $0.82 $0.50 $2.62 240.26% <-Total Growth 10 EPS Basic 2024 TDWB
EPS Diluted* $1.18 $0.72 $0.51 $1.03 $0.77 $0.46 $0.94 $1.12 $1.29 $0.78 $0.47 $2.10 -$0.86 $1.36 $2.51 191.67% <-Total Growth 10 EPS Diluted
Increase 40.48% -38.98% -29.17% 101.96% -25.24% -40.26% 104.35% 19.15% 15.18% -39.53% -39.74% 346.81% -141.10% 257.21% 84.97% 10 0 10 Years of Data, EPS P or N
Earnings Yield 11.08% 4.47% 4.76% 6.69% 5.05% 2.31% 5.34% 6.39% 7.89% 4.62% 5.16% 16.07% -4.84% 7.61% 12.66% 11.30% <-IRR #YR-> 10 Earnings per Share 191.67%
5 year Running Average $0.92 $0.82 $0.76 $0.86 $0.84 $0.70 $0.74 $0.86 $0.92 $0.92 $0.92 $1.15 $0.76 $0.77 $1.11 17.44% <-IRR #YR-> 5 Earnings per Share 123.40%
10 year Running Average $0.39 $0.52 $0.73 $0.83 $0.88 $0.81 $0.78 $0.81 $0.89 $0.88 $0.81 $0.95 $0.81 $0.84 $1.02 3.43% <-IRR #YR-> 10 5 yr Running Average 40.15%
* Diluted ESP per share  E/P 10 Yrs 5.25% 5Yrs 6.39% 9.20% <-IRR #YR-> 5 5 yr Running Average 55.26%
-$0.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.10
-$0.94 $0.00 $0.00 $0.00 $0.00 $2.10
-$0.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.15
-$0.74 $0.00 $0.00 $0.00 $0.00 $1.15
Dividend* $0.75 $0.78 $0.88 Estimates Dividend*
Increase 1.51% 3.17% 13.55% Estimates Increase
Payout Ratio EPS -87.03% 57.11% 35.06% Estimates Payout Ratio EPS
Special Dividends $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
Dividend* $0.26 $0.31 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $0.74 $0.76 $0.76 $0.76 138.71% <-Total Growth 10 Dividends
Increase 30.00% 19.23% 12.90% 11.43% 14.10% 10.11% 2.04% 12.00% 11.61% 9.60% 6.57% 1.37% 2.03% 0.66% 0.00% 14 2 23 Years of data, Count P, N
Average Increases 5 Year Running 43.14% 9.85% 12.43% 14.71% 17.53% 13.56% 10.12% 9.94% 9.97% 9.07% 8.36% 8.23% 6.23% 4.05% 2.13% 10.05% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.21 $0.23 $0.26 $0.30 $0.35 $0.40 $0.44 $0.48 $0.52 $0.57 $0.62 $0.67 $0.71 $0.73 $0.75 185.47% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 2.20% 2.31% 2.46% 2.99% 2.78% 2.85% 2.91% 2.91% 4.23% 3.61% 5.54% 6.37% 4.90% 2.95% <-Median-> 10 Yield H/L Price Item
Yield on High  Price 1.89% 1.93% 1.87% 2.47% 2.34% 2.46% 2.50% 2.59% 3.45% 3.12% 4.06% 5.30% 4.27% 2.55% <-Median-> 10 Yield on High  Price EPS
Yield on Low Price 2.63% 2.87% 3.58% 3.79% 3.42% 3.40% 3.49% 3.32% 5.48% 4.28% 8.72% 7.99% 5.74% 3.69% <-Median-> 10 Yield on Low Price CFPS
Yield on Close Price 2.44% 1.93% 3.27% 2.53% 2.92% 2.46% 2.84% 3.20% 3.82% 4.06% 8.01% 5.66% 4.23% 4.26% 3.83% 3.23% <-Median-> 10 Yield on Close Price FCF 1
Payout Ratio EPS 22.03% 43.06% 68.63% 37.86% 57.79% 106.52% 53.19% 50.00% 48.45% 87.82% 155.32% 35.24% 0.00% 56.01% 30.28% $0.35 <-Median-> 24 DPR EPS FCF 2
DPR EPS 5 Yr Running 23.09% 28.47% 34.55% 35.28% 41.69% 56.88% 58.63% 55.21% 57.21% 62.31% 67.39% 57.99% 93.60% 95.48% 67.19% $0.32 <-Median-> 20 DPR EPS 5 Yr Running
Payout Ratio CFPS 20.01% 12.23% 26.26% 38.14% 95.77% 14.72% 8.20% 17.13% 13.79% 0.00% 0.00% 90.22% 0.00% 43.18% #DIV/0! $0.04 <-Median-> 24 DPR CF
DPR CF 5 Yr Running 38.48% 21.62% 18.66% 15.26% 26.37% 22.86% 17.76% 16.82% 14.81% 17.12% 26.85% 53.26% 139.04% 0.00% #DIV/0! $0.22 <-Median-> 20 DPR CF 5 Yr Running
Payout Ratio CFPS WC 10.18% 17.51% 28.07% 19.45% 17.84% 20.96% 16.01% 17.52% 17.68% 24.17% 35.39% 71.14% 1437.65% 1447.17% #DIV/0! $0.17 <-Median-> 24 DPR CF WC
DPR CF WC 5 Yr Running 18.57% 14.15% 16.26% 15.74% 17.43% 20.14% 19.41% 18.13% 17.84% 19.03% 21.02% 26.37% 37.12% 60.74% #DIV/0! $0.18 <-Median-> 20 DPR CF WC 5 Yr Running
Median Values 10 Yr Cl 2.95% 3.23% 5 Yr Med 5 Yr Cl 4.23% 4.06% 5 Yr Med Payout 50.00% 13.79% 24.17% 8.16% <-IRR #YR-> 5 Dividends 48.00%
* Dividends per share  and Cur. 44.32% 31.88% 5 Yr Med and Cur. 0.73% 5.04% Last Div Inc ---> $0.185 $0.190 2.70% 9.09% <-IRR #YR-> 10 Dividends 138.71%
Dividends Growth 15 9.11% <-IRR #YR-> 15 Dividends 270.00%
Dividends Growth 20 #NUM! <-IRR #YR-> 20 Dividends #DIV/0!
Dividends Growth 25 9.09% <-IRR #YR-> 23 Dividends #DIV/0!
Dividends Growth 5 -$0.50 $0.00 $0.00 $0.00 $0.00 $0.74 Dividends Growth 5
Dividends Growth 10 -$0.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.74 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.74 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.74 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.74 Dividends Growth 25
Historical Dividends High Div 6.74% Low Div 0.00% 10 Yr High 8.65% 10 Yr Low 1.92% Med Div 2.38% Close Div 2.45% Historical Dividends
High/Ave/Median Values Exp. -36.76% Cheap   Exp. -50.72% 122.00% Cheap 79.10% Cheap 74.03% High/Ave/Median 
Historical Dividends High Div 8.14% Low Div 0.78% 10 Yr High 8.65% 10 Yr Low 1.88% Med Div 2.78% Close Div 2.53% From 2007 When dividends Historical Dividends
High/Ave/Median Values Exp. -47.64% Cheap 446.47% Exp. -50.72% 126.73% Cheap 53.33% Cheap 68.20% were restated High/Ave/Median 
Future Dividend Yield Div Yield 6.31% earning in 5 Years at IRR of 8.16% Div Inc. 48.00% Future Dividend Yield
Future Dividend Yield Div Yield 9.34% earning in 10 Years at IRR of 8.16% Div Inc. 119.04% Future Dividend Yield
Future Dividend Yield Div Yield 13.82% earning in 15 Years at IRR of 8.16% Div Inc. 224.18% Future Dividend Yield
Future Dividend Paid Div Paid $1.12 earning in 5 Years at IRR of 8.16% Div Inc. 48.00% Future Dividend Paid
Future Dividend Paid Div Paid $1.66 earning in 10 Years at IRR of 8.16% Div Inc. 119.04% Future Dividend Paid
Future Dividend Paid Div Paid $2.46 earning in 15 Years at IRR of 8.16% Div Inc. 224.18% Future Dividend Paid
Dividend Covering Cost Total Div $4.47 over 5 Years at IRR of 8.16% Div Cov. 25.08% Dividend Covering Cost
Dividend Covering Cost Total Div $9.97 over 10 Years at IRR of 8.16% Div Cov. 55.90% Dividend Covering Cost
Dividend Covering Cost Total Div $18.10 over 15 Years at IRR of 8.16% Div Cov. 101.51% Dividend Covering Cost
Yield if held 5 years 1.76% 2.22% 3.01% 3.16% 5.06% 4.15% 3.72% 3.94% 4.80% 4.28% 4.25% 4.31% 3.93% 5.15% 4.01% 4.20% <-Median-> 10 Paid Median Price
Yield if held 10 years 4.78% 6.65% 6.03% 6.52% 7.31% 3.32% 3.58% 4.82% 5.07% 7.79% 6.18% 5.50% 5.31% 5.83% 4.75% 5.77% <-Median-> 10 Paid Median Price
Yield if held 15 years 7.82% 10.02% 11.11% 12.64% 10.79% 9.01% 10.72% 9.66% 10.45% 11.26% 4.94% 5.30% 6.49% 6.16% 8.64% 10.58% <-Median-> 10 Paid Median Price
Yield if held 20 years 16.30% 14.74% 16.16% 17.78% 20.26% 16.61% 13.42% 15.86% 13.02% 12.71% 12.49% 16.23% <-Median-> 8 Paid Median Price
Yield if held 25 years 25.09% 21.95% 23.91% 23.97% 24.64% 18.42% 23.91% <-Median-> 3 Paid Median Price
27.84% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 7.18% 8.38% 11.35% 12.24% 19.95% 16.81% 16.18% 16.76% 20.11% 17.86% 18.06% 19.46% 18.39% 24.85% 19.74% 17.33% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 20.77% 30.87% 30.86% 36.45% 43.14% 20.62% 23.95% 31.86% 33.48% 52.47% 43.06% 41.02% 41.60% 48.27% 41.24% 34.97% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 41.50% 54.60% 64.76% 75.53% 64.36% 57.26% 77.49% 71.98% 80.27% 90.14% 41.62% 47.87% 62.25% 63.23% 95.05% 68.37% <-Median-> 10 Paid Median Price
Cost covered if held 20 years 105.31% 101.20% 124.88% 140.48% 160.45% 133.70% 114.25% 149.09% 132.93% 141.64% 151.68% 129.29% <-Median-> 8 Paid Median Price
Cost covered if held 25 years 210.07% 194.44% 232.79% 252.70% 279.42% 224.48% 210.07% <-Median-> 3 Paid Median Price
339.19% #NUM! <-Median-> 0 Paid Median Price
Yr  Item Tot. Growth
Revenue Growth  $3,266.3 $3,460.4 $3,643.6 $3,977.3 $4,696.5 $4,643.8 $4,809 <-12 mths 3.55% 42.17% <-Total Growth 5 Revenue Growth  42.17%
EPS Growth $0.94 $1.12 $1.29 $0.78 $0.47 $2.10 -$0.27 <-12 mths -112.86% 123.40% <-Total Growth 5 EPS Growth 123.40%
Net Income Growth $59.0 $72.9 $88.0 $49.7 $30.4 $161.9 $13 <-12 mths -91.90% 174.32% <-Total Growth 5 Net Income Growth 174.32%
Cash Flow Growth $368.7 $198.5 $273.0 -$31.4 -$112.9 $51.1 $199 <-12 mths 289.58% -86.15% <-Total Growth 5 Cash Flow Growth -86.15%
Cash Flow Less WC Growth $188.9 $194.1 $212.9 $172.4 $126.9 $64.8 -$90 <-12 mths -238.49% -65.70% <-Total Growth 5 Cash Flow Less WC Growth -65.70%
Dividend Growth $0.50 $0.56 $0.63 $0.69 $0.73 $0.74 $0.76 <-12 mths 2.03% 48.00% <-Total Growth 5 Dividend Growth 48.00%
Stock Price Growth $17.61 $17.52 $16.36 $16.88 $9.11 $13.07 $17.83 <-12 mths 36.42% -25.78% <-Total Growth 5 Stock Price Growth -25.78%
Revenue Growth  $3,068.6 $2,614.1 $2,918.1 $3,213.1 $2,805.7 $3,266.3 $3,460.4 $3,643.6 $3,977.3 $4,696.5 $4,643.8 $4,162 <-this year -10.38% 51.33% <-Total Growth 10 Revenue Growth  51.33%
EPS Growth $0.72 $0.51 $1.03 $0.77 $0.46 $0.94 $1.12 $1.29 $0.78 $0.47 $2.10 -$0.86 <-this year -141.10% 191.67% <-Total Growth 10 EPS Growth 191.67%
Net Income Growth $40.6 $30.0 $68.7 $46.8 $28.2 $59.0 $72.9 $88.0 $49.7 $30.4 $161.9 -$59 <-this year -136.61% 298.76% <-Total Growth 10 Net Income Growth 298.76%
Cash Flow Growth $134.0 $74.8 $58.1 $26.9 $197.4 $368.7 $198.5 $273.0 -$31.4 -$112.9 $51.1 $3 <-this year -93.60% -61.89% <-Total Growth 10 Cash Flow Growth -61.89%
Cash Flow Less WC Growth $93.6 $70.0 $113.9 $144.3 $138.6 $188.9 $194.1 $212.9 $172.4 $126.9 $64.8 $3 <-this year -94.95% -30.79% <-Total Growth 10 Cash Flow Less WC Growth -30.79%
Dividend Growth $0.31 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $0.74 $0.75 <-this year 1.51% 138.71% <-Total Growth 10 Dividend Growth 138.71%
Stock Price Growth $16.09 $10.71 $15.39 $15.25 $19.94 $17.61 $17.52 $16.36 $16.88 $9.11 $13.07 $17.83 <-this year 36.42% -18.77% <-Total Growth 10 Stock Price Growth -18.77%
Dividends on Shares $22.05 $24.57 $28.04 $30.87 $31.50 $35.28 $39.38 $43.16 $45.99 $46.62 $47.57 $47.88 $47.88 $347.45 No of Years 10 Total Divs 12/31/13
Paid  $1,013.67 $674.73 $969.57 $960.75 $1,256.22 $1,109.43 $1,103.76 $1,030.68 $1,063.44 $573.93 $823.41 $1,123.29 $1,123.29 $1,248.66 $823.41 No of Years 10 Worth $16.09
Total $1,170.86
Graham Number $16.49 $13.41 $11.58 $17.11 $15.02 $11.60 $16.99 $18.87 $20.53 $16.24 $12.80 $28.42 $21.23 $21.23 $28.87 111.97% <-Total Growth 10 Graham Number
Increase 25.60% -18.71% -13.63% 47.79% -12.23% -22.75% 46.38% 11.10% 8.77% -20.90% -21.14% 121.95% -25.30% 0.00% 36.00% -1.73% <-Median-> 10 Graham Price
Price/GP Ratio Med 0.72 1.00 1.23 0.76 1.07 1.48 1.01 1.02 0.72 1.17 1.03 0.41 0.73 1.02 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 0.83 1.20 1.61 0.92 1.27 1.72 1.18 1.14 0.88 1.35 1.40 0.49 0.83 1.22 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 0.60 0.80 0.84 0.60 0.87 1.24 0.84 0.89 0.56 0.99 0.65 0.33 0.62 0.84 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 0.65 1.20 0.92 0.90 1.02 1.72 1.04 0.93 0.80 1.04 0.71 0.46 0.84 0.84 0.69 0.93 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close -35.43% 20.01% -7.51% -10.07% 1.52% 71.84% 3.67% -7.16% -20.30% 3.97% -28.85% -54.01% -16.01% -16.01% -31.35% -7.34% <-Median-> 10 Graham Price
Based on EPS 3 yrs trailing $13.03 $14.68 $15.50 $15.11 $14.86 $15.01 $15.21 $15.17 $16.56 $19.43 $19.26 $18.05 $19.26 $13.75 $16.95 22.91% <-Total Growth 10 Graham Number EPS 3 yrs trailing
Increase -1.73% 12.66% 5.55% -2.47% -1.69% 1.05% 1.29% -0.27% 9.22% 17.29% -0.86% -6.30% 6.72% -28.62% 23.28% 0.39% <-Median-> 10 Graham Price
Price/GP Ratio Med 0.91 0.92 0.92 0.86 1.08 1.14 1.13 1.27 0.89 0.98 0.68 0.64 0.80 0.01 0.00 0.95 <-Median-> 10 Price/GP Ratio Med
Price/GP Ratio High 1.06 1.10 1.21 1.04 1.28 1.33 1.31 1.42 1.10 1.13 0.93 0.77 0.92 0.00 0.00 1.17 <-Median-> 10 Price/GP Ratio High
Price/GP Ratio Low 0.76 0.73 0.63 0.68 0.88 0.96 0.94 1.11 0.69 0.82 0.43 0.51 0.68 0.00 0.00 0.76 <-Median-> 10 Price/GP Ratio Low
Price/GP Ratio Close 0.82 1.10 0.69 1.02 1.03 1.33 1.16 1.16 0.99 0.87 0.47 0.72 0.93 1.30 1.17 1.00 <-Median-> 10 Price/GP Ratio Close
Prem/Disc Close -18.28% 9.60% -30.89% 1.83% 2.64% 32.82% 15.81% 15.53% -1.23% -13.11% -52.70% -27.57% -7.41% 29.71% 16.96% 0.30% <-Median-> 10 Graham Price
Month, Year Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25 Dec-26 27.00 <Count Years> Month, Year
Price Close $10.65 $16.09 $10.71 $15.39 $15.25 $19.94 $17.61 $17.52 $16.36 $16.88 $9.11 $13.07 $17.83 $17.83 $19.82 -18.77% <-Total Growth 10 Stock Price
Increase 1.82% 51.08% -33.44% 43.70% -0.91% 30.75% -11.69% -0.51% -6.62% 3.18% -46.03% 43.47% 36.42% 0.00% 11.16% 16.80 <-Median-> 10 CAPE (10 Yr P/E)
P/E Ratio 9.03 22.35 21.00 14.94 19.81 43.35 18.73 15.64 12.68 21.64 19.38 6.22 -20.66 13.14 7.90 -5.79% <-IRR #YR-> 5 Stock Price -25.78%
Trailing P/E Ratio 12.68 13.64 14.88 30.18 14.81 25.90 38.28 18.64 14.61 13.09 11.68 27.81 8.49 -20.66 14.61 -2.06% <-IRR #YR-> 10 Stock Price -18.77%
CAPE (10 Yr P/E) 26.34 21.95 16.41 15.51 15.70 16.67 18.07 17.67 16.93 17.77 19.14 16.03 19.63 19.16 16.33 -1.51% <-IRR #YR-> 5 Price & Dividend -6.81%
Median 10, 5 Yrs D.  per yr 3.70% 4.28% % Tot Ret 224.89% 0.00% T P/E $16.76 $14.61 P/E:  $19.06 $15.64 1.65% <-IRR #YR-> 10 Price & Dividend 15.51%
Price 15 D.  per yr 3.47% % Tot Ret 75.00% CAPE Diff -222.95% 1.16% <-IRR #YR-> 15 Stock Price 18.82%
Price  20 D.  per yr 3.51% % Tot Ret 39.30% 5.42% <-IRR #YR-> 20 Stock Price 187.25%
Price  25 D.  per yr 3.15% % Tot Ret 34.21% 6.06% <-IRR #YR-> 25 Stock Price 335.67%
Price  30 D.  per yr 2.61% % Tot Ret 34.54% 4.95% <-IRR #YR-> 27 Stock Price
Price & Dividend 15 4.62% <-IRR #YR-> 15 Price & Dividend 79.59%
Price & Dividend 20 8.93% <-IRR #YR-> 20 Price & Dividend 340.11%
Price & Dividend 25 9.22% <-IRR #YR-> 25 Price & Dividend 575.83%
Price & Dividend 30 7.55% <-IRR #YR-> 27 Price & Dividend
Price  5 -$17.61 $0.00 $0.00 $0.00 $0.00 $13.07 Price  5
Price 10 -$16.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.07 Price 10
Price & Dividend 5 -$17.61 $0.56 $0.63 $0.69 $0.73 $13.81 Price & Dividend 5
Price & Dividend 10 -$16.09 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $13.81 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 $13.07 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 $13.07 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 $13.07 Price  25
Price  30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.07 Price  30
Price & Dividend 15 $0.26 $0.31 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $13.81 Price & Dividend 15
Price & Dividend 20 $0.26 $0.31 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $13.81 Price & Dividend 20
Price & Dividend 25 $0.26 $0.31 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $13.81 Price & Dividend 25
Price & Dividend 30 $0.26 $0.31 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $13.81 Price & Dividend 30
Price H/L Median $11.81 $13.45 $14.23 $13.03 $16.02 $17.17 $17.16 $19.23 $14.77 $18.97 $13.18 $11.62 $15.42 11.16% -13.61% <-Total Growth 10 Stock Price
Increase 34.28% 13.84% 5.84% -8.43% 22.91% 7.18% -0.03% 12.03% -23.17% 28.44% -30.55% -11.84% 32.72% 4.26% -7.51% <-IRR #YR-> 5 Stock Price -32.31%
P/E Ratio 10.01 18.67 27.90 12.65 20.80 37.32 18.26 17.17 11.45 24.32 28.03 5.53 -17.86 15.42% -1.45% <-IRR #YR-> 10 Stock Price -13.61%
Trailing P/E Ratio 14.06 11.39 19.76 25.55 15.55 22.29 37.30 20.45 13.19 14.71 16.89 24.71 7.34 -2.95% <-IRR #YR-> 5 Price & Dividend -12.85%
P/E on Running 5 yr Average 12.86 16.36 18.63 15.22 19.02 24.59 23.13 22.25 16.12 20.66 14.32 10.08 20.41 2.83% <-IRR #YR-> 10 Price & Dividend 27.41%
P/E on Running 10 yr Average 30.13 25.71 19.63 15.66 18.24 21.24 21.94 23.62 16.67 21.56 16.29 12.27 19.04 12.65 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 4.56% 4.28% % Tot Ret -154.89% 151.38% T P/E 20.11 16.89 P/E:  19.53 17.17 Count 27 Years of data
-$17.16 $0.00 $0.00 $0.00 $0.00 $11.62
-$13.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.62
-$17.16 $0.56 $0.63 $0.69 $0.73 $12.36
-$13.45 $0.35 $0.39 $0.45 $0.49 $0.50 $0.56 $0.63 $0.69 $0.73 $12.36
High Months Mar Dec Feb Dec Aug Dec Jan Jul Feb Sep Feb Apr Aug
Price High $13.75 $16.10 $18.69 $15.77 $19.02 $19.91 $19.98 $21.59 $18.14 $21.94 $17.98 $13.97 $17.67 -13.23% <-Total Growth 10 Stock Price
Increase 30.46% 17.09% 16.09% -15.62% 20.61% 4.68% 0.35% 8.06% -15.98% 20.95% -18.05% -22.30% 26.49% -6.91% <-IRR #YR-> 5 Stock Price -30.08%
P/E Ratio 11.65 22.36 36.65 15.31 24.70 43.28 21.26 19.28 14.06 28.13 38.26 6.65 -20.47 -1.41% <-IRR #YR-> 10 Stock Price -13.23%
Trailing P/E Ratio 16.37 13.64 25.96 30.92 18.47 25.86 43.43 22.97 16.20 17.01 23.05 29.72 8.41 18.51 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 24.45 22.97 P/E:  22.98 19.28 39.26 P/E Ratio Historical High
-$19.98 $0.00 $0.00 $0.00 $0.00 $13.97
-$16.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.97
Low Months Nov Jan Dec Jul Jan Aug Jun Apr Mar Dec Dec Oct Jan
Price Low $9.87 $10.79 $9.77 $10.29 $13.01 $14.42 $14.34 $16.86 $11.40 $16.00 $8.37 $9.26 $13.16 -14.18% <-Total Growth 10 Stock Price
Increase 40.00% 9.32% -9.45% 5.32% 26.43% 10.84% -0.55% 17.57% -32.38% 40.35% -47.69% 10.63% 42.12% -8.38% <-IRR #YR-> 5 Stock Price -35.43%
P/E Ratio 8.36 14.99 19.16 9.99 16.90 31.35 15.26 15.05 8.84 20.51 17.81 4.41 -15.25 -1.52% <-IRR #YR-> 10 Stock Price -14.18%
Trailing P/E Ratio 11.75 9.14 13.57 20.18 12.63 18.73 31.17 17.94 10.18 12.40 10.73 19.70 6.27 8.84 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 15.75 12.40 P/E:  16.08 15.05 -3.68 P/E Ratio Historical Low
-$10.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.26
-$36 <-12 mths #DIV/0!
Free Cash Flow -$1.00 $75.00 $15.64 $5.35 -$13.10 $27.65 $154.11 -$9.37 $133.68 -$73.03 -$154.17 $0.0 -$124.3 $87.2 $284.7 -100.00% <-Total Growth 10 Free Cash Flow MS Close
Change -102.13% 7600.00% -79.15% -65.79% -344.86% 311.07% 457.36% -106.08% 1526.68% -154.63% -111.11% 100.00% #DIV/0! 170.13% 226.60% #NUM! <-IRR #YR-> 5 Free Cash Flow MS -100.00%
FCF/CF from Op Ratio -0.01 0.56 0.21 0.09 -0.49 0.14 0.42 -0.05 0.49 2.33 1.37 0.00 -38.01 26.66 #DIV/0! #NUM! <-IRR #YR-> 10 Free Cash Flow MS -100.00%
Dividends paid $14.51 $17.32 $19.74 $22.06 $25.57 $28.67 $29.83 $33.98 $37.54 $41.30 $44.47 $45.61 $47.01 $47.32 $47.32 163.37% <-Total Growth 10 Dividends paid
Percentage paid -1451.10% 23.09% 126.18% 412.34% -195.18% 103.68% 19.36% -362.60% 28.08% -56.55% -28.84% #DIV/0! -37.82% 54.29% 16.62% #DIV/0! <-Median-> 9 Percentage paid
5 Year Coverage 85.10% 53.11% 73.51% 365.32% -197.20% -99.13% -85.39% 248.11% 5 Year Coverage
Dividend Coverage Ratio 0.24 -0.51 0.96 5.17 -0.28 3.56 -1.77 -3.47 0.00 -2.64 1.84 6.02 0.00 <-Median-> 9 Dividend Coverage Ratio
5 Year of Coverage 1.18 1.88 1.36 0.27 -0.51 -1.01 -1.17 0.40 5 Year of Coverage
Free Cash Flow WSJ (Using these) $40.49 $4.12 $166.33 $321.53 $161.51 $237.21 -$63.65 -$142.39 $46.41 -$124.30 $87.17 $284.70 14.64% <-Total Growth 8 Free Cash Flow WSJ WSJ &
Change -89.83% 3941.08% 93.30% -49.77% 46.87% -126.83% -123.69% 132.60% -367.82% 170.13% 226.60% -32.10% <-IRR #YR-> 5 Free Cash Flow MS Mark Sc
FCF/CF from Op Ratio 64.51 15.43 -4225.53 887.54 5869.49 2450.32 334.98 539.73 -94.79 130.91 #DIV/0! #DIV/0! 1.72% <-IRR #YR-> 8 Free Cash Flow MS
Dividends paid $22.06 $25.57 $28.67 $29.83 $33.98 $37.54 $41.30 $44.47 $45.61 $47.01 $47.32 $47.32 106.76% <-Total Growth 8 Dividends paid
Percentage paid 54.49% 621.19% 17.23% 9.28% 21.04% 15.83% -64.88% -31.23% 98.27% -37.82% 54.29% 16.62% $0.17 <-Median-> 9 Percentage paid
5 Year Coverage 20.19% 17.47% 20.82% 36.39% 84.86% -462.23% -114.72% 152.86% 5 Year Coverage
Dividend Coverage Ratio 1.84 0.16 5.80 10.78 4.75 6.32 -1.54 -3.20 1.02 -2.64 1.84 6.02 1.84 <-Median-> 9 Dividend Coverage Ratio
5 Year of Coverage 4.95 5.72 4.80 2.75 1.18 -0.22 -0.87 0.65 5 Year of Coverage
Market Cap in $M $564.6 $850.6 $601.2 $874.4 $882.4 $1,182.4 $1,065.0 $1,063.7 $985.2 $1,026.7 $560.6 $813.8 $1,110.2 $1,110.2 $1,234.1 -0.04 <-Total Growth 10 Market Cap -4.33%
Diluted # of Shares in Million 78.97 78.86 84.34 80.71 72.35 72.23 73.93 73.85 75.87 73.85 79.27 81.93 81.98 81.98 81.98 3.89% <-Total Growth 10 Diluted # of Shares in Million
Change -8.53% -0.13% 6.95% -4.31% -10.36% -0.16% 2.34% -0.10% 2.74% -2.67% 7.35% 3.35% 0.07% 0.00% 0.00% 0.38% <-IRR #YR-> 10 Change
Difference Diluted/Basic -32.9% -33.2% -35.8% -30.2% -20.7% -19.2% -19.1% -17.8% -20.9% -18.3% -23.1% -24.7% -24.9% -24.9% -24.9% 2.08% <-IRR #YR-> 5 Difference Diluted/Basic
Basic # of Shares in Millions 52.98 52.67 54.13 56.36 57.36 58.37 59.80 60.71 60.04 60.35 60.98 61.71 61.58 61.58 61.58 17.17% <-Total Growth 10 Basic
Change -1.72% -0.58% 2.78% 4.11% 1.78% 1.75% 2.46% 1.52% -1.10% 0.51% 1.05% 1.21% -0.21% 0.00% 0.00% 1.64% <-Median-> 10 Change
Difference Basic/Outstanding 0.07% 0.38% 3.69% 0.81% 0.87% 1.60% 1.13% 0.01% 0.30% 0.79% 0.92% 0.89% 1.11% 1.11% 1.11% 0.88% <-Median-> 10 Difference Basic/Outstanding
$199 <-12 mths 289.58%
# of Share in Millions 53.011 52.868 56.132 56.817 57.863 59.299 60.479 60.716 60.220 60.823 61.536 62.266 62.266 62.266 62.266 1.65% <-IRR #YR-> 10 Shares 17.78%
Change -0.54% -0.27% 6.17% 1.22% 1.84% 2.48% 1.99% 0.39% -0.82% 1.00% 1.17% 1.19% 0.00% 0.00% 0.00% 0.58% <-IRR #YR-> 5 Shares 2.96%
Cash Flow from Operations $M $68.9 $134.0 $74.8 $58.1 $26.9 $197.4 $368.7 $198.5 $273.0 -$31.4 -$112.9 $51.1 $3.3 $3.3 -61.89% <-Total Growth 10 Cash Flow
Increase -65.12% 94.58% -44.19% -22.32% -53.73% 634.27% 86.75% -46.17% 37.54% -111.51% -259.32% 145.25% -93.60% 0.00% Conv. Deb SO, BuyBacks S. Issued Capital Stock
5 year Running Average $28.7 $56.8 $75.4 $106.7 $72.5 $98.2 $145.2 $169.9 $212.9 $201.2 $139.2 $75.6 $36.6 -$17.3 33.24% <-Total Growth 10 CF 5 Yr Running
CFPS $1.30 $2.54 $1.33 $1.02 $0.46 $3.33 $6.10 $3.27 $4.53 -$0.52 -$1.83 $0.82 -$0.46 $1.76 -67.64% <-Total Growth 10 Cash Flow per Share
Increase -64.93% 95.11% -47.43% -23.26% -54.56% 616.49% 83.11% -46.38% 38.67% -111.39% -255.15% 144.72% -156.08% 482.61% -9.20% <-IRR #YR-> 10 Cash Flow -61.89%
5 year Running Average $0.55 $1.08 $1.42 $1.98 $1.33 $1.74 $2.45 $2.84 $3.54 $3.34 $2.31 $1.25 $0.51 -$0.05 -32.65% <-IRR #YR-> 5 Cash Flow -86.15%
P/CF on Med Price 9.09 5.30 10.68 12.74 34.47 5.16 2.81 5.88 3.26 -36.73 -7.18 14.16 -33.51 0.06 -10.67% <-IRR #YR-> 10 Cash Flow per Share -67.64%
P/CF on Closing Price 8.20 6.35 8.04 15.05 32.82 5.99 2.89 5.36 3.61 -32.69 -4.97 15.93 -38.76 10.13 -33.05% <-IRR #YR-> 5 Cash Flow per Share -86.55%
83.57% Diff M/C 1.49% <-IRR #YR-> 10 CFPS 5 yr Running 15.89%
-$89.71 <-12 mths -238.49%
Excl.Working Capital CF $66.5 -$40.4 -$4.8 $55.8 $117.4 -$58.8 -$179.8 -$4.4 -$60.1 $203.8 $239.8 $13.7 $0.0 $0.0 -12.53% <-IRR #YR-> 5 CFPS 5 yr Running -48.79%
Cash Flow from Operations $M WC $135.4 $93.6 $70.0 $113.9 $144.3 $138.6 $188.9 $194.1 $212.9 $172.4 $126.9 $64.8 $3.3 $3.3 -30.79% <-Total Growth 10 Cash Flow less WC
Increase 26.09% -30.89% -25.21% 62.76% 26.68% -3.94% 36.23% 2.75% 9.68% -19.00% -26.38% -48.97% -94.95% 0.00% -3.61% <-IRR #YR-> 10 Cash Flow less WC -30.79%
5 year Running Average $61.9 $88.5 $87.1 $104.1 $111.5 $112.1 $131.2 $156.0 $175.7 $181.4 $179.0 $154.2 $116.0 $74.1 -19.27% <-IRR #YR-> 5 Cash Flow less WC -65.70%
CFPS Excl. WC $2.55 $1.77 $1.25 $2.01 $2.49 $2.34 $3.12 $3.20 $3.53 $2.83 $2.06 $1.04 $0.05 $0.05 5.71% <-IRR #YR-> 10 CF less WC 5 Yr Run 74.24%
Increase 26.77% -30.70% -29.56% 60.80% 24.39% -6.26% 33.57% 2.35% 10.58% -19.81% -27.23% -49.56% -94.95% 0.00% 3.29% <-IRR #YR-> 5 CF less WC 5 Yr Run 17.58%
5 year Running Average $1.14 $1.65 $1.62 $1.92 $2.01 $1.97 $2.24 $2.63 $2.94 $3.01 $2.95 $2.53 $1.90 $1.21 -5.18% <-IRR #YR-> 10 CFPS - Less WC -41.23%
P/CF on Median Price 4.62 7.60 11.41 6.50 6.42 7.34 5.49 6.01 4.18 6.69 6.39 11.17 293.53 2.13 -19.74% <-IRR #YR-> 5 CFPS - Less WC -66.69%
P/CF on Closing Price 4.17 9.09 8.59 7.68 6.11 8.53 5.64 5.48 4.63 5.96 4.42 12.56 339.51 339.51 4.36% <-IRR #YR-> 10 CFPS 5 yr Running 53.20%
*Operational Cash Flow. CF/-WC P/CF Med 10 yr 5.52 5 yr  3.26 P/CF Med 10 yr 6.46 5 yr  6.39 5155.96% Diff M/C 2.48% <-IRR #YR-> 5 CFPS 5 yr Running 13.04%
-$2.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.82 Cash Flow per Share
-$6.10 $0.00 $0.00 $0.00 $0.00 $0.82 Cash Flow per Share
-$1.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.25 CFPS 5 yr Running
-$2.45 $0.00 $0.00 $0.00 $0.00 $1.25 CFPS 5 yr Running
-$93.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $64.8 Cash Flow less WC
-$188.9 $0.0 $0.0 $0.0 $0.0 $64.8 Cash Flow less WC
-$88.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $154.2 CF less WC 5 Yr Run
-$131.2 $0.0 $0.0 $0.0 $0.0 $154.2 CF less WC 5 Yr Run
-$1.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.04 CFPS - Less WC
-$3.12 $0.00 $0.00 $0.00 $0.00 $1.04 CFPS - Less WC
For banks, use Net Income, not CF
OPM Ratio 2.34% 4.37% 2.86% 1.99% 0.84% 7.04% 11.29% 5.74% 7.49% -0.79% -2.40% 1.10% 0.08% -74.82% <-Total Growth 10 OPM
Increase -65.72% 86.86% -34.48% -30.41% -57.98% 740.89% 60.42% -49.19% 30.62% -110.54% -204.30% 145.76% -92.86% Should increase  or be stable.
Diff from Median -3.7% 80.0% 17.9% -17.9% -65.5% 190.0% 365.2% 136.4% 208.8% -132.5% -199.0% -54.7% -96.8% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 2.43% 5 Yrs 1.10% should be  zero, it is a   check on calculations
-$18.60 <-12 mths -112.97%
Adjusted EBITDA $170.2 $169.8 $110.3 $146.8 $158.3 $156.5 $207.0 $221.9 $264.5 $238.9 $219.2 $143.4 $88 $301 $381 -18.41% <-Total Growth 10 Adjusted EBITDA
Change -7.50% -0.24% -35.04% 33.09% 7.83% -1.14% 32.27% 7.20% 19.20% -9.68% -8.25% -34.58% -38.40% 240.88% 26.50% 0.03 <-Median-> 10 Change
EBITDA Margin 5.78% 5.53% 4.22% 5.03% 4.93% 5.58% 6.34% 6.41% 7.26% 6.01% 4.67% 3.09% 2.12% 6.55% 8.23% 0.05 <-Median-> 10 Margin
Long Term Debt $302.09 $123.13 $113.61 $105.36 $86.40 $444.10 $453.45 $511.58 $502.41 $520.91 $173.64 $106.77 $98.43 -15.32% <-Total Growth 10 Debt Type
Change 8.02% -59.24% -7.73% -7.27% -17.99% 413.99% 2.11% 12.82% -1.79% 3.68% -66.67% -38.51% -7.81% -4.53% <-Median-> 10 Change Lg Term R
Debt/Market Cap Ratio 0.54 0.14 0.19 0.12 0.10 0.38 0.43 0.48 0.51 0.51 0.31 0.13 0.09 0.34 <-Median-> 10 Debt/Market Cap Ratio Intang/GW
Assets/Current Liabilities Ratio 2.44 2.12 2.22 2.43 2.32 2.35 2.32 2.29 2.15 2.24 1.94 1.84 1.41 2.27 <-Median-> 10 Assets/Current Liabilities Liquidity
Debt to Cash Flow (Years) 4.39 0.92 1.52 1.81 3.21 2.25 1.23 2.58 1.84 -16.58 -1.54 2.09 30.10 1.83 <-Median-> 10 Debt to Cash Flow (Years) Liq. + CF
Debt Ratio
Intangibles $7.54 $17.98 $45.92 $62.62 $111.66 $297.75 $397.80 $632.76 $565.62 $542.09 $554.25 $17.45 $13.51 -3.01% <-Total Growth 10 Intangibles Leverage
Goodwill $53.78 $53.78 $52.57 $49.37 $47.37 $49.37 $47.85 $52.89 $83.83 $104.86 $108.10 $105.56 $105.58 96.27% <-Total Growth 10 Goodwill D/E Ratio
Total $61.32 $71.76 $98.49 $112.00 $159.03 $347.13 $445.64 $685.66 $649.45 $646.95 $662.35 $123.01 $119.09 71.42% <-Total Growth 10 Total
Change -83.47% 17.03% 37.25% 13.71% 42.00% 118.28% 28.38% 53.86% -5.28% -0.39% 2.38% -81.43% -3.19% 21.04% <-Median-> 10 Change
Intangible/Market Cap Ratio 0.11 0.08 0.16 0.13 0.18 0.29 0.42 0.64 0.66 0.63 1.18 0.15 0.11 0.36 <-Median-> 10 Intangible/Market Cap Ratio
Current Assets $1,128.6 $1,129.6 $963.1 $1,242.2 $1,389.3 $1,722.7 $2,146.8 $2,129.4 $2,201.0 $2,145.7 $2,323.3 $2,473.3 $3,140.1 118.95% <-Total Growth 10 Current Assets
Current Liabilities $874.0 $940.4 $824.0 $772.0 $864.8 $1,074.5 $1,263.9 $1,357.8 $1,529.6 $1,469.5 $1,834.5 $1,737.9 $2,221.0 84.81% <-Total Growth 10 Current Liabilities
Liquidity Ratio 1.29 1.20 1.17 1.61 1.61 1.60 1.70 1.57 1.44 1.46 1.27 1.42 1.41 1.51 <-Median-> 10 Ratio
Liq. with CF aft div 1.27 1.18 1.14 1.56 1.56 1.56 1.66 1.67 1.58 1.40 1.18 1.42 1.39 1.42 <-Median-> 5 Ratio
Liq. with CF aft div (WC) 1.42 1.28 1.23 1.71 1.72 1.69 1.81 1.67 1.54 1.53 1.30 1.42 1.39
Liq. CF re  Inv+Div  1.21 1.23 1.18 1.66 1.58 1.13 1.84 1.57 1.36 1.42 1.28 1.44 1.38 1.42 <-Median-> 5 Ratio
Curr Long Term Debt $61.899 $67.890 $83.226 $56.033 $51.568 $44.472 $32.505 $60.071 $56.568 $61.525 $56.564 $42.608 $39.046 $56.6 <-Median-> 5 Ratio
Liquidity Less CLTD 1.39 1.29 1.30 1.74 1.71 1.67 1.74 1.64 1.49 1.52 1.31 1.46 1.44 1.49 <-Median-> 5 Ratio
Liq. with CF aft div 1.45 1.42 1.36 1.76 1.69 1.81 1.99 1.75 1.64 1.46 1.21 1.45 1.41 1.46 <-Median-> 5 Ratio
Assets $2,129.3 $1,993.6 $1,830.1 $1,874.4 $2,005.5 $2,526.8 $2,932.7 $3,114.6 $3,287.4 $3,286.8 $3,567.0 $3,195.6 $3,140.1 60.30% <-Total Growth 10 Assets
Liabilities $1,579.7 $1,407.0 $1,174.2 $1,156.3 $1,251.9 $1,755.3 $2,107.6 $2,256.6 $2,413.3 $2,373.3 $2,613.0 $2,131.3 $2,221.0 51.48% <-Total Growth 10 Liabilities
Debt Ratio 1.35 1.42 1.56 1.62 1.60 1.44 1.39 1.38 1.36 1.38 1.37 1.50 1.41 1.42 <-Median-> 10 Ratio
Book Value 549.57 586.61 655.95 718.05 753.60 771.48 825.06 858.00 874.11 913.57 954.00 1064.33 919.10 81.44% <-Total Growth 10 Book Value
NCI 6.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 NCI
Book Value 543.16 586.61 655.95 718.05 753.60 771.48 825.06 858.00 874.11 913.57 954.00 1064.33 919.10 919.10 919.10 81.44% <-Total Growth 10 Book Value
Book Value per share $10.25 $11.10 $11.69 $12.64 $13.02 $13.01 $13.64 $14.13 $14.52 $15.02 $15.50 $17.09 $14.76 $14.76 $14.76 54.05% <-Total Growth 10 Book Value per Share
Increase 12.29% 8.29% 5.32% 8.15% 3.05% -0.11% 4.86% 3.59% 2.72% 3.48% 3.22% 10.26% -13.64% 0.00% 0.00% -0.31% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.15 1.21 1.22 1.03 1.23 1.32 1.26 1.36 1.02 1.26 0.85 0.68 1.04 0.01 0.00 1.21 P/B Ratio Historical Median
P/B Ratio (Close) 1.04 1.45 0.92 1.22 1.17 1.53 1.29 1.24 1.13 1.12 0.59 0.76 1.21 1.21 1.34 4.42% <-IRR #YR-> 10 Book Value per Share 54.05%
Change -9.33% 39.51% -36.80% 32.87% -3.85% 30.89% -15.78% -3.95% -9.09% -0.29% -47.71% 30.12% 57.97% 0.00% 11.16% 4.61% <-IRR #YR-> 5 Book Value per Share 25.30%
Median 10 year P/B Ratio 1.50 1.50 1.45 1.31 1.22 1.22 1.22 1.22 1.21 1.22 1.22 1.22 1.14 1.14 1.03
Leverage (A/BK) 3.92 3.40 2.79 2.61 2.66 3.28 3.55 3.63 3.76 3.60 3.74 3.00 3.42 3.63 <-Median-> 5 A/BV
Debt/Equity Ratio 2.91 2.40 1.79 1.61 1.66 2.28 2.55 2.63 2.76 2.60 2.74 2.00 2.42 2.63 <-Median-> 5 Debt/Eq Ratio
Shareholders' Equity (Assets less Liabilities) P/B Ratios 10 yr Med 1.22 5 yr Med 1.02 -1.29% Diff M/C 3.75 Historical Leverage (A/BK)
-$11.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.09
-$13.64 $0.00 $0.00 $0.00 $0.00 $17.09
$6.06 <-12 mths -95.68%
Compreshensive Income $78.15 $54.29 $49.43 $40.70 $45.99 $29.92 $68.78 $61.78 $57.52 $65.63 $69.94 $140.22 158.31% <-Total Growth 10 Compreshensive Income
NCI $2.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NCI
Shareholders $75.28 $54.29 $49.43 $40.70 $45.99 $29.92 $68.78 $61.78 $57.52 $65.63 $69.94 $140.22 158.31% <-Total Growth 10 Shareholders
Increase 33.98% -27.89% -8.95% -17.65% 12.98% -34.93% 129.85% -10.18% -6.90% 14.11% 6.57% 100.49% 6.57% <-Median-> 5 Comprehensive Income
5 Yr Running Average $49 $46 $49 $55 $53 $44 $47 $49 $53 $57 $65 $79 9.95% <-IRR #YR-> 10 Comprehensive Income 158.31%
ROE 13.9% 9.3% 7.5% 5.7% 6.1% 3.9% 8.3% 7.2% 6.6% 7.2% 7.3% 13.2% 15.31% <-IRR #YR-> 5 Comprehensive Income 103.87%
5Yr Median 11.6% 9.3% 9.3% 9.3% 7.5% 6.1% 6.1% 6.1% 6.6% 7.2% 7.2% 7.2% 5.58% <-IRR #YR-> 10 5 Yr Running Average 72.07%
% Difference from Net Income -3.5% 33.7% 64.5% -40.7% -1.6% 6.2% 16.5% -15.2% -34.7% 32.1% 130.2% -13.4% 10.97% <-IRR #YR-> 5 5 Yr Running Average 68.25%
Median Values Diff 5, 10 yr 2.3% -13.4% 7.2% <-Median-> 5 Return on Equity
-$54.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $140.2
-$68.8 $0.0 $0.0 $0.0 $0.0 $140.2
-$45.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $79.0
-$47.0 $0.0 $0.0 $0.0 $0.0 $79.0
Current Liability Coverage Ratio 0.15 0.10 0.08 0.15 0.17 0.13 0.15 0.14 0.14 0.12 0.07 0.04 0.00   CFO / Current Liabilities
5 year Median 0.09 0.10 0.10 0.14 0.15 0.13 0.15 0.15 0.14 0.14 0.14 0.12 0.07 0.13 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 6.36% 4.69% 3.82% 6.08% 7.20% 5.49% 6.44% 6.23% 6.47% 5.25% 3.56% 2.03% 0.10% CFO / Total Assets
5 year Median 4.6% 4.7% 4.7% 5.4% 6.1% 5.5% 6.1% 6.23% 6.44% 6.23% 6.23% 5.25% 3.56% 5.8% <-Median-> 10 Return on Assets 
Return on Assets ROA 3.66% 2.04% 1.64% 3.66% 2.33% 1.12% 2.01% 2.34% 2.68% 1.51% 0.85% 5.07% -1.89% Net  Income/Assets Return on Assets
5Yr Median 2.90% 2.63% 2.04% 2.90% 2.33% 2.04% 2.01% 2.33% 2.33% 2.01% 2.01% 2.34% 1.51% 2.2% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 14.36% 6.92% 4.58% 9.56% 6.20% 3.65% 7.15% 8.49% 10.07% 5.44% 3.18% 15.21% 0.00% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 11.83% 9.70% 9.27% 9.56% 6.92% 6.20% 6.20% 7.15% 7.15% 7.15% 7.15% 8.49% 5.44% 6.7% <-Median-> 10 Return on Equity
$13 <-12 mths -91.90%
Net Income $80.94 $40.6 $30.0 $68.7 $46.8 $28.2 $59.0 $72.9 $88.0 $49.7 $30.4 $161.9 298.76% <-Total Growth 10 Net Income
NCI $2.96 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 NCI
Shareholder $77.98 $40.6 $30.0 $68.7 $46.8 $28.2 $59.0 $72.9 $88.0 $49.7 $30.4 $161.9 -$59.3 $91.9 $170.2 298.76% <-Total Growth 10 Shareholder
Increase 35.49% -47.94% -26.00% 128.60% -31.92% -39.74% 109.45% 23.45% 20.83% -43.56% -38.85% 432.87% -136.61% 255.10% 85.18% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $56.2 $52.5 $49.6 $55.0 $52.8 $42.9 $46.5 $55.1 $59.0 $59.6 $60.0 $80.6 $54.1 $54.9 $79.0 14.83% <-IRR #YR-> 10 Net Income 298.76%
Operating Cash Flow $68.9 $134.0 $74.8 $58.1 $26.9 $197.4 $368.7 $198.5 $273.0 -$31.4 -$112.9 $51.1 22.36% <-IRR #YR-> 5 Net Income 174.32%
Investment Cash Flow -$105.4 -$43.1 -$9.8 $249.0 -$20.5 -$443.0 $39.0 -$66.1 -$189.4 -$39.6 -$35.9 $360.8 4.38% <-IRR #YR-> 10 5 Yr Running Average 53.54%
Total Accruals $114.5 -$50.3 -$35.0 -$238.4 $40.3 $273.7 -$348.7 -$59.5 $4.4 $120.7 $179.1 -$250.0 11.60% <-IRR #YR-> 5 5 Yr Running Average 73.14%
Total Assets $2,129.3 $1,993.6 $1,830.1 $1,874.4 $2,005.5 $2,526.8 $2,932.7 $3,114.6 $3,287.4 $3,286.8 $3,567.0 $3,195.6 Balance Sheet Assets
Accruals Ratio 5.38% -2.52% -1.91% -12.72% 2.01% 10.83% -11.89% -1.91% 0.13% 3.67% 5.02% -7.82% 0.13% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.46 0.41 0.41 0.51 0.31 0.20 0.30 0.35 0.36 0.28 0.23 2.02 0.33 <-Median-> 10 EPS/CF Ratio
-$40.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $161.9
-$59.0 $0.0 $0.0 $0.0 $0.0 $161.9
-$52.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $80.6
-$46.5 $0.0 $0.0 $0.0 $0.0 $80.6
Change in Close 1.82% 51.08% -33.44% 43.70% -0.91% 30.75% -11.69% -0.51% -6.62% 3.18% -46.03% 43.47% 36.42% 0.00% 11.16% Count 28 Years of data
up/down up down up down up down up Count 15 53.57%
Meet Prediction? Yes yes % right Count 5 33.33%
Financial Cash Flow $71.6 -$86.3 -$166.8 -$163.2 -$57.0 $317.8 -$85.1 -$78.1 -$107.3 -$52.3 -$11.9 -$141.9 C F Statement  Financial Cash Flow
Total Accruals $42.9 $36.0 $131.8 -$75.3 $97.3 -$44.1 -$263.6 $18.6 $111.7 $173.0 $191.0 -$108.0 Accruals
Accruals Ratio 2.01% 1.80% 7.20% -4.02% 4.85% -1.74% -8.99% 0.60% 3.40% 5.26% 5.35% -3.38% 3.40% <-Median-> 5 Ratio
Cash $66.9 $240.6 $138.9 $282.7 $213.9 $304.9 $631.0 $682.3 $658.3 $532.7 $377.2 $645.8 $499.4 Cash
Cash per Share $1.26 $4.55 $2.47 $4.98 $3.70 $5.14 $10.43 $11.24 $10.93 $8.76 $6.13 $10.37 $8.02 $10.37 <-Median-> 5 Cash per Share
Percentage of Stock Price 11.85% 28.28% 23.11% 32.33% 24.24% 25.78% 59.25% 64.14% 66.82% 51.88% 67.29% 79.35% 44.98% 66.82% <-Median-> 5 % of Stock Price
Notes:
August 11, 2024.  Last estimates were for 2023, 2024, 2025 of $4770M, $4795M 2023/4 Revenue, $1.05, $1.17, $1.45 EPS, $0.74, $0.76, $0.78 Dividend, 
$11.2M, $114M, $153M for FCF, $1.19, $2.16, $3.63 CFPS, $195M, $247M, $298M EBITDA, $79.9M, $89.8M, $118.9M Net Income.
August 10, 2023.  Last estimates were for 2022, 2023 and 2024 of $4473M, $4583M and $4509M for Revenue, $0.33, $0.73 and $1.11 for EPS, 
$0.74, $0.77 and $0.82 for Dividends, -$30.9M, $84.8M and $81M for FCF, $1.98, $1.86 and $1.86 for CFPS, $18.1M and $43M 2022/3 for Net Income.
August 9, 2022.  Last estimates were for 2021, 2022 and 2023 of $4038M, $4214M and $4224M for Revenue, $0.97, $1.24 and $2.38 for EPS, 
$0.70, $0.73 and $0.76 for Dividends, $61.9M, $128M and $120M for FCF, $2.50, $3.38 and $3.33 for CFPS, and $65.4M, $87.2M an $76.3M for Net Income.
August 8, 2020.  Last estimates were for 2020, 2021 and 2022 of $3448M, $3774M and $3967M for Revenue, $0.49 and $1.02 for EPS for 2020, 21, 
$0.63 and $0.67 for Dividend 2020,21, $70.7M, $124M and $139M for FCF and $37M and $73.7M for Net Income 
August 10, 2020. Spreadsheet started. 
John M. Beck, Founder and Chairman, Aecon Group Inc
In November 2018, Aecon announced the closing of a definitive asset purchase agreement to sell substantially all of the assets related to its 
Contract Mining business to North American Construction Group for $199.1 million in cash.
In 2010, Aecon acquired over 500 physical pieces of mining equipment and assets previously owned by Cow Harbour Construction, a large mining and 
land reclamation contractor located in Alberta's oil sands.
Aecon's origins go back to 1957 to Prefac Concrete of Montreal, a company started by John M. Beck and his parents.
Sector:
Construction, Inudustrial
What should this stock accomplish?
Would I buy this company and Why.
Why am I following this stock. 
This stock has been coming up on Canada Stock Channel Weekly email in 2020.   Site is <a href=" https://www.canadastockchannel.com/" target="_top">Canada Stock Channel</a>. 
Why I bought this stock.
Dividends
Dividends are paid quarterly in Cycle 1 of January, April, July and october.  Dividends are declared in one month for shareholders of record of the following month and paid in the next month.
For example, the dividends declared on December 24, 2019 for shareholder of record of December 24, 2019 was paid on January 3, 2020.
Misson Statement or closes thing I can find.
What I am looking for is a statement that the company wants to do well by their customers, employees, and community and and thereby earn shareholders a reasonable return.
For customers 
For employees 
For community 
For investors 
How they make their money.
Aecon Group Inc is a Canada-based company that operates in two segments: Construction and Concessions. The company generates the 
majority of its revenue from the Construction segment.   
Shares; '%, Value $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 2017 2018 2019 Aug 9 2020 Aug 8 2021 Aug 9 2022 Aug 10 2023 Aug 11 2024
Servranckx, Jean-Louis 0.006 0.01% 0.008 0.01% 0.018 0.03% 0.038 0.06% 0.006 0.01% 0.006 0.01% 0.00%
CEO - Shares - Amount $0.096 $0.124 $0.304 $0.344 $0.072 $0.098
Options - percentage 0.027 0.04% 0.128 0.21% 0.221 0.36% 0.416 0.68% 0.584 0.94% 0.604 0.97% 3.44%
Options - amount $0.470 $2.094 $3.727 $3.792 $7.628 $10.764
Julier, Jerome 0.018 0.03%
CFO - Shares - Amount $0.326
Options - percentage 0.023 0.04%
Options - amount $0.417
Smales, David Andrew 0.023 0.04% 0.023 0.04% 0.023 0.04% 0.023 0.04% 0.023 0.04% Ceased insider Jan 2024 -100.00%
CFO - Shares - Amount $0.409 $0.382 $0.394 $0.213 $0.305
Options - percentage 0.211 0.35% 0.224 0.37% 0.237 0.39% 0.277 0.45% 0.330 0.53% -100.00%
Options - amount $3.700 $3.671 $3.995 $2.527 $4.316
Chan, Ernie 0.011 0.02% 0.011 0.02% 0.00%
Officer - Shares - Amount $0.138 $0.188
Options - percentage 0.038 0.06% 0.044 0.07% 16.89%
Options - amount $0.490 $0.782
Borgatti, Adam 0.001 0.00% 0.002 0.00% 0.006 0.01% 0.006 0.01% 0.014 0.02% 0.009 0.02% Last filed Jul 2024 -31.74%
Officer - Shares - Amount $0.018 $0.037 $0.109 $0.055 $0.179 $0.167
Options - percentage 0.013 0.02% 0.023 0.04% 0.031 0.05% 0.040 0.07% 0.055 0.09% 0.062 0.10% 11.15%
Options - amount $0.236 $0.374 $0.527 $0.368 $0.724 $1.098
Hole, James Douglas 0.050 0.08% 0.050 0.08% Ceased insider Jun 2024 -100.00%
Director - Shares - Amount $0.456 $0.654
Options - percentage 0.077 0.12% 0.114 0.18% -100.00%
Options - amount $0.698 $1.486
Franceschini, Anthony P. 0.090 0.15% 0.090 0.15% 0.090 0.15% 0.090 0.15% 0.090 0.14%   -100.00%
Lead Director - Shares - Amt $1.577 $1.472 $1.519 $0.820 $1.176
Options - percentage 0.045 0.07% 0.055 0.09% 0.064 0.11% 0.077 0.13% 0.113 0.18% -100.00%
Options - amount $0.795 $0.897 $1.083 $0.705 $1.470
Rosenfield, Eric Stuart 0.264 0.42% 0.294 0.47% 11.36%
Director - Shares - Amount $3.453 $5.246
Options - percentage 0.069 0.11% 0.080 0.13% 15.16%
Options - amount $0.903 $1.419
Sloan, Monica 0.008 0.01% 0.008 0.01% 0.00%
Director - Shares - Amt $0.105 $0.143
Options - percentage 0.108 0.17% 0.119 0.19% 9.59%
Options - amount $1.415 $2.115
Beck, John Michael 0.054 0.09% 0.000 0.00% 0.054 0.09% 0.054 0.09% 0.054 0.09% 0.064 0.10% 18.55%
Chairman - Shares - Amt $0.944 $0.000 $0.910 $0.491 $0.705 $1.139
Options - percentage 0.457 0.75% 0.000 0.00% 0.336 0.55% 0.358 0.58% 0.054 0.09% 0.450 0.72% 734.00%
Options - amount $7.999 $0.000 $5.677 $3.259 $0.705 $8.016
Increase in O/S Shares 1.016 1.71% 0.636 1.06% 0.442 0.73% 0.603 0.99% 0.713 1.16% 0.730 1.17%
Due to Stock Options $17.893 $11.147 $7.233 $10.180 $6.496 $9.546
Book Value $15.462 $10.404 $7.533 $10.074 $13.550 $11.350
Insider Buying $0.000 -$0.102 -$0.050 -$1.118 $0.000 -$1.242
Insider Selling $3.296 $0.000 $0.000 $0.000 $1.796 $0.299
Net Insider Selling $3.296 -$0.102 -$0.050 -$1.118 $1.796 -$0.943
Net Selling % of Market Cap 0.33% -0.01% 0.00% -0.20% 0.22% -0.08%
Directors 10 10 10 10 11
Women 3 30% 3 30% 3 30% 3 30% 4 36%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 20 15.81% 20 22.75% 20 28.32% 20 23.87% 20 23.33%
Total Shares Held 9.606 15.95% 13.724 22.56% 17.263 28.05% 14.718 23.64% 14.561 23.39%
Increase/Decrease 3 Mths 0.316 3.41% -0.782 -5.39% 0.187 1.10% 2.464 20.10% 0.359 2.52%
Starting No. of Shares 9.289 14.506 17.076 12.255 14.203