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.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/ Q3 2017
Bird Construction Inc. TSX: BDT OTC: BIRDF www.bird.ca Fiscal Yr: Dec 31
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Total G
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$1,471 <-12 mths -7.45%
Revenue* $447.8 $533.4 $756.9 $1,039.4 $882.9 $845.9 $974.5 $1,454.9 $1,331.7 $1,364.5 $1,444.8 $1,589.9 $1,453 $1,546 $1,633 198.08% <-Total Growth 10 Revenue
Increase -0.10% 19.11% 41.91% 37.33% -15.05% -4.20% 15.20% 49.30% -8.47% 2.46% 5.89% 10.04% -8.61% 6.40% 5.63% 11.54% <-IRR #YR-> 10 Revenue 198.08%
5 year Running Average $422.7 $451.1 $514.6 $645.1 $732.1 $811.7 $899.9 $1,039.5 $1,098.0 $1,194 $1,314 $1,437 $1,436.8 $1,479.6 $1,533.3 10.29% <-IRR #YR-> 5 Revenue 63.15%
Revenue per Share $13.22 $12.89 $18.30 $24.66 $20.95 $20.07 $23.12 $34.51 $31.59 $32.09 $33.98 $37.39 $34.17 $36.36 $38.41 12.28% <-IRR #YR-> 10 5 yr Running Average 218.57%
Increase -0.10% -2.48% 41.91% 34.77% -15.05% -4.20% 15.20% 49.30% -8.47% 1.59% 5.89% 10.04% -8.61% 6.40% 5.63% 9.81% <-IRR #YR-> 5 5 yr Running Average 59.70%
5 year Running Average $12.48 $12.75 $13.81 $16.46 $18.00 $19.37 $21.42 $24.66 $26.05 $28.28 $31.06 $33.91 $33.85 $34.80 $36.06 11.24% <-IRR #YR-> 10 Revenue per Share 190.02%
P/S (Price/Sales) Med 0.25 0.37 0.47 0.39 0.41 0.56 0.47 0.40 0.42 0.42 0.35 0.31 10.10% <-IRR #YR-> 5 Revenue per Share 61.76%
P/S (Price/Sales) Close 0.33 0.38 0.69 0.27 0.55 0.62 0.50 0.38 0.42 0.37 0.38 0.24 0.30 0.28 0.29 10.28% <-IRR #YR-> 10 5 yr Running Average 166.01%
*Revenue in M CDN$ Construction Revenue P/S Med 10 yr 0.41 5 yr 0.40 -27.79% Diff M/C 9.63% <-IRR #YR-> 5 5 yr Running Average 58.36%
Construction Revenue $974.47 $1,454.87 $1,331.69 $1,364.46 $1,444.81 $1,589.87 63.15% <-Total Growth 5 Construction Revenue showing only
Increase 49.30% -8.47% 2.46% 5.89% 10.04% 5.89% <-Median-> 5 Increase from 2011
Cost of Constructions $894.18 $1,311.91 $1,260.22 $1,252.85 $1,324.16 $1,498.21 67.55% <-Total Growth 5 Cost of Constructions
Increase 46.72% -3.94% -0.59% 5.69% 13.14% 5.69% <-Median-> 5 Increase
Cost percentage of revenue 91.76% 90.17% 94.63% 91.82% 91.65% 94.23% 91.79% <-Median-> 6 Cost percentage of revenue
$0.30 <-12 mths -49.15%
EPS Basic $0.45 $0.55 $0.81 $1.45 $1.35 $1.12 $0.70 $1.38 $0.28 $0.85 $0.51 $0.59 7.27% <-Total Growth 10 EPS Basic
EPS Diluted* $0.45 $0.55 $0.81 $1.45 $1.35 $1.12 $0.70 $1.38 $0.28 $0.85 $0.51 $0.59 $0.36 $0.60 $0.74 7.27% <-Total Growth 10 EPS Diluted
Increase 4.11% 22.22% 46.67% 79.34% -6.68% -16.79% -37.69% 97.14% -79.71% 203.57% -40.00% 15.69% -38.98% 66.67% 23.33% 0.70% <-IRR #YR-> 10 Earnings per Share 7.27%
Earnings Yield 10.38% 11.30% 6.37% 21.70% 11.77% 9.05% 6.07% 10.44% 2.11% 7.12% 3.92% 6.51% 3.55% 5.92% 6.73% -3.36% <-IRR #YR-> 5 Earnings per Share -15.71%
5 year Running Average $0.32 $0.38 $0.51 $0.74 $0.92 $1.06 $1.09 $1.20 $0.97 $0.87 $0.74 $0.72 $0.52 $0.58 $0.56 6.50% <-IRR #YR-> 10 5 yr Running Average 87.69%
10 year Running Average $0.69 $0.74 $0.85 $0.85 $0.89 $0.90 $0.90 $0.86 $0.77 $0.71 -7.83% <-IRR #YR-> 5 5 yr Running Average -33.48%
* Diluted ESP per share E/P 10 Yrs 6.82% 5Yrs 6.51%
Dividends paid in M$ $15.62 $44.80 $17.50 $21.12 $23.25 $25.29 $27.61 $29.72 $31.85 $32.30 $32.30 $32.30 Dividends paid in M$
Increase 43.10% 186.88% -60.93% 20.68% 10.07% 8.79% 9.17% 7.63% 7.18% 1.39% 0.00% 0.00% Increase
Percentage of Net Income 100.00% 202.04% 74.01% 34.71% 40.85% 53.45% 93.30% 51.02% 263.47% 89.13% 150.34% 129.18% Percentage of Net Income
Analyst changes $0.39 $0.39 $0.39 Analyst changes
Special Dividends $0.00 $0.93 $0.04 $0.02 $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.46 $0.32 $0.39 $0.48 $0.54 $0.60 $0.66 $0.71 $0.75 $0.76 $0.76 $0.76 $0.42 $0.39 $0.39 134.93% <-Total Growth 10 Dividends
Increase 42.27% -29.71% 19.63% 25.03% 12.03% 10.74% 9.17% 7.63% 6.34% 1.32% 0.00% 0.00% -44.60% -7.32% 0.00% Count 16 Years of data
Average Increases 5 Year Running 39.3% 45.3% 14.7% 13.8% 7.5% 15.3% 12.9% 9.2% 7.0% 4.9% 3.1% -7.4% -10.1% -10.4% 11.05% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.72 $0.96 $1.25 $1.58 $1.76 $1.51 $1.39 $1.22 $0.98 $0.69 $0.73 $0.75 $0.69 $0.62 $0.54 -22.29% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 13.80% 6.82% 4.45% 5.01% 6.39% 5.33% 6.01% 5.14% 5.71% 5.69% 6.36% 6.65% 4.58% 5.70% <-Median-> 10 Yield H/L Price
Yield on High Price 10.35% 5.81% 3.05% 3.24% 4.53% 4.69% 5.06% 4.55% 4.97% 4.95% 5.24% 5.40% 3.96% 4.82% <-Median-> 10 Yield on High Price
Yield on Low Price 20.70% 8.26% 8.21% 10.99% 10.84% 6.15% 7.39% 5.90% 6.69% 6.69% 8.10% 8.63% 5.42% 7.75% <-Median-> 10 Yield on Low Price
Yield on Close Price 10.62% 6.64% 3.05% 7.25% 4.73% 4.83% 5.68% 5.33% 5.64% 6.37% 5.84% 8.38% 4.15% 3.85% 3.55% 5.66% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 102.22% 227.47% 52.45% 34.60% 40.13% 53.41% 93.57% 51.09% 267.75% 89.36% 148.94% 128.75% 116.89% 65.00% 52.70% 71.39% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 145.26% 325.25% 83.70% 67.90% 58.85% 56.85% 60.35% 58.75% 77.56% 87.65% 102.10% 105.21% 81.24% 67.01% 69.64% 72.73% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS -381.36% 169.67% 40.80% 27.31% 22.80% 42.72% 173.00% 49.26% 192.71% 37.08% 43.19% 74.37% 26.63% #DIV/0! #DIV/0! 42.96% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 61.44% 46.21% 40.61% 46.59% 47.49% 62.69% 67.20% 63.24% 57.13% 30.95% #DIV/0! #DIV/0! 57.13% <-Median-> 9 DPR CF 5 Yr Running
Payout Ratio CFPS WC 92.91% 294.32% 44.07% 30.90% 36.56% 53.15% 53.73% 27.34% 97.80% 49.76% 42.89% 67.01% 26.63% #DIV/0! #DIV/0! 46.92% <-Median-> 10 DPR CF WC end of 2016 end of 2017
DPR CF WC 5 Yr Running 65.23% 54.38% 53.42% 51.09% 43.91% 52.24% 52.61% 48.31% 48.84% 31.04% #DIV/0! #DIV/0! 52.24% <-Median-> 9 DPR CF WC 5 Yr Running 3.01% -11.17%
Median Values 5 Yr Med 5 Yr Cl 5.71% 5.84% 5 Yr Med Payout 128.75% 49.26% 49.76% 8.92% <-IRR #YR-> 10 Dividends 134.93%
* Dividends per share 5 Yr Med and Cur. -32.52% -34.11% Last Div Inc ---> $0.0633 $0.0325 -48.7% 3.01% <-IRR #YR-> 5 Dividends 15.97%
Historical Dividends Historical High Div 20.74% Low Div 3.19% Ave Div 11.97% Med Div 6.18% Close Div 6.40% Historical Dividends
High/Ave/Median Values Curr diff Exp. -81.44% 20.69% Exp. -67.82% Exp. -37.70% Exp. -39.82% High/Ave/Median
Future Dividend Yield Div Yd $0.05 earning in 5 Years at IRR of 6.00% Div Inc. 33.82% Future Dividend Yield
Future Dividend Yield Div Yd 6.89% earning in 10 Years at IRR of 6.00% Div Inc. 79.08% Future Dividend Yield
Future Dividend Yield Div Yd 9.23% earning in 15 Years at IRR of 6.00% Div Inc. 139.66% Future Dividend Yield
Yield if held 5 yrs 78.03% 15.32% 24.69% 27.20% 24.08% 18.00% 13.81% 8.11% 7.76% 8.95% 6.74% 6.97% 3.07% 2.97% 2.92% 11.38% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 214.89% 205.79% 110.57% 101.78% 31.04% 45.00% 42.17% 33.76% 22.79% 16.02% 4.84% 4.04% 4.60% 43.59% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 391.67% 319.02% 155.02% 128.85% 36.00% 26.86% 21.94% 17.33% 155.02% <-Median-> 5 Paid Median Price
Yield if held 20 yrs 233.78% 165.96% 79.59% #NUM! <-Median-> 0 Paid Median Price
Yield if held 25 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 215.81% 114.32% 174.60% 166.39% 141.18% 99.50% 57.37% 34.55% 33.67% 40.90% 32.21% 34.25% 25.16% 23.51% 20.37% 49.13% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 1673.96% 1495.18% 827.65% 778.42% 243.26% 366.24% 349.29% 295.37% 208.36% 136.11% 74.24% 65.65% 72.96% 357.76% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 3341.93% 2878.79% 1535.67% 1394.01% 420.20% 586.40% 523.08% 416.26% 1535.67% <-Median-> 5 Paid Median Price
Cost covered if held 20 years 5258.20% 4193.52% 2090.77% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham Number $3.17 $3.39 $4.83 $8.86 $9.88 $9.88 $7.79 $11.88 $5.15 $9.04 $6.79 $7.15 $5.49 $7.08 $7.87 110.65% <-Total Growth 10 Graham Number
Price/GP Ratio Med 1.05 1.40 1.80 1.09 0.86 1.14 1.40 1.15 2.55 1.48 1.76 1.60 1.68 1.44 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.40 1.64 2.62 1.68 1.21 1.29 1.66 1.30 2.93 1.70 2.14 1.97 1.94 1.69 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.70 1.15 0.97 0.50 0.51 0.99 1.14 1.01 2.18 1.26 1.38 1.23 1.42 1.07 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.37 1.43 2.62 0.75 1.16 1.26 1.48 1.11 2.58 1.32 1.91 1.27 1.85 1.43 1.40 1.29 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 36.86% 43.45% 162.00% -24.76% 16.11% 25.59% 48.01% 11.29% 158.38% 32.00% 91.42% 26.78% 84.62% 43.01% 39.83% 29.39% <-Median-> 10 Graham Price
Month, Year Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20 To end of 2017.
Price Close $4.87 $12.67 $6.67 $11.47 $12.41 $11.53 $13.22 $13.30 $11.93 $13.00 $9.10 $10.13 $10.13 $10.13 $10.13 -20.03% <-Total Growth 10 Stock Price
Increase 12.31% 160.27% -47.37% 72.00% 8.23% -7.09% 14.66% 0.61% -10.30% 8.97% -30.00% 11.32% 0.00% 0.00% 0.00% -2.21% <-IRR #YR-> 10 Stock Price -20.03%
P/E Ratio 10.81 23.03 8.26 7.93 9.19 10.26 18.89 9.64 42.61 15.29 17.84 17.17 28.14 16.88 13.69 -5.19% <-IRR #YR-> 5 Stock Price -23.37%
Trailing P/E Ratio 11.26 28.15 12.12 14.21 8.58 8.54 11.77 19.00 8.64 46.43 10.71 19.86 17.17 28.14 16.88 4.10% <-IRR #YR-> 10 Price & Dividend 34.25%
Median 10, 5 Yrs D. per yr 6.31% 7.51% % Tot Ret 153.90% 322.73% Price Inc 0.61% P/E: 12.78 17.17 2.33% <-IRR #YR-> 5 Price & Dividend 8.05%
Price & Dividend 15 34.54% <-IRR #YR-> 15 Price & Dividend 993.16%
Price & Dividend 20 49.91% <-IRR #YR-> 20 Price & Dividend 10785.98%
Month, Year Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 To end of 2016.
Price Close $4.33 $4.87 $12.67 $6.67 $11.47 $12.41 $11.53 $13.22 $13.30 $11.93 $13.00 $9.06 $10.13 $10.13 $11.00 86.16% <-Total Growth 10 Stock Price
Increase 85.71% 12.31% 160.27% -47.37% 72.00% 8.23% -7.09% 14.66% 0.61% -10.30% 8.97% -30.31% 11.81% 0.00% 8.59% 6.41% <-IRR #YR-> 10 Stock Price 86.16%
P/E Ratio 9.63 8.85 15.70 4.61 8.49 11.05 16.47 9.58 47.50 14.04 25.49 15.36 28.14 16.88 14.86 -4.71% <-IRR #YR-> 5 Stock Price -21.42%
Trailing P/E Ratio 10.03 10.81 23.03 8.26 7.93 9.19 10.26 18.89 9.64 42.61 15.29 17.76 17.17 28.14 18.33 16.25% <-IRR #YR-> 10 Price & Dividend 244.49%
Median 10, 5 Yrs D. per yr 9.83% 7.09% % Tot Ret 60.53% 297.25% Price Inc 0.61% P/E: 14.70 15.36 2.39% <-IRR #YR-> 5 Price & Dividend 16.64%
Price & Dividend 15 28.06% <-IRR #YR-> 15 Price & Dividend 889.41%
Price & Dividend 20 49.97% <-IRR #YR-> 19 Price & Dividend 9957.76%
Price H/L Median $3.33 $4.74 $8.69 $9.66 $8.48 $11.27 $10.90 $13.71 $13.14 $13.35 $11.95 $11.43 $9.20 8.59% 141.05% <-Total Growth 10 Stock Price
Increase 48.15% 42.25% 83.27% 11.14% -12.17% 32.81% -3.25% 25.78% -4.16% 1.60% -10.52% -4.31% -19.55% 3.85% 9.20% <-IRR #YR-> 10 Stock Price 141.05%
P/E Ratio 7.41 8.62 10.77 6.68 6.28 10.03 15.57 9.93 46.93 15.71 23.42 19.37 25.54 12.44% 0.95% <-IRR #YR-> 5 Stock Price 4.86%
Trailing P/E Ratio 7.71 10.54 15.80 11.97 5.86 8.35 9.70 19.59 9.52 47.68 14.05 22.41 15.58 18.20% <-IRR #YR-> 10 Price & Dividend 303.55%
P/E on Run. 5 yr Ave 10.53 12.33 17.19 13.10 9.21 10.68 10.04 11.43 13.59 15.40 16.06 15.83 17.75 7.67% <-IRR #YR-> 5 Price & Dividend 45.12%
P/E on Run. 10 yr Ave 16.42 14.83 16.08 15.42 14.94 13.28 12.65 10.70 9.98 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 9.00% 6.71% % Tot Ret 49.47% 87.56% T P/E 19.59 P/E: 13.17 19.37 Count 20 Years of data
High Months Dec Apr Dec Jun Oct Oct Mar May Jan Aug Nov Jun Apr
Price High $4.44 $5.57 $12.67 $14.92 $11.97 $12.78 $12.94 $15.48 $15.08 $15.34 $14.51 $14.06 $10.62 152.57% <-Total Growth 10 Stock Price
Increase 70.21% 25.25% 127.54% 17.76% -19.78% 6.82% 1.23% 19.63% -2.58% 1.72% -5.41% -3.10% -24.47% 9.71% <-IRR #YR-> 10 Stock Price 152.57%
P/E Ratio 9.88 10.12 15.70 10.31 8.86 11.38 18.49 11.22 53.86 18.05 28.45 23.83 29.50 1.67% <-IRR #YR-> 5 Stock Price 8.66%
Trailing P/E Ratio 10.28 12.37 23.03 18.49 8.27 9.47 11.52 22.11 10.93 54.79 17.07 27.57 18.00 11.30 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 22.11 P/E: 16.87 23.83 21.69 P/E Ratio Historical High
Low Months Jun Nov Feb Dec Mar Oct Oct Jan Aug Dec Apr Nov Jun
Price Low $2.22 $3.92 $4.71 $4.40 $5.00 $9.75 $8.86 $11.94 $11.20 $11.36 $9.38 $8.80 $7.77 124.68% <-Total Growth 10 Stock Price
Increase 17.65% 76.25% 20.34% -6.65% 13.64% 95.00% -9.13% 34.76% -6.20% 1.43% -17.43% -6.18% -11.70% 8.43% <-IRR #YR-> 10 Stock Price 124.68%
P/E Ratio 4.94 7.12 5.84 3.04 3.70 8.68 12.66 8.65 40.00 13.36 18.39 14.92 21.58 -0.14% <-IRR #YR-> 5 Stock Price -0.68%
Trailing P/E Ratio 5.14 8.70 8.57 5.45 3.46 7.22 7.89 17.06 8.12 40.57 11.04 17.25 13.17 6.91 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 17.06 P/E: 10.67 14.92 4.47 P/E Ratio Historical Low
Accounts Payable. $230.62 $254.46 313.411 369.037 $348.68 345.636 $390.76 $458.67 $382.56 Debt
Change 10.33% 23.17% 17.75% -5.52% -0.87% 13.06% 17.38% -16.59% 13.06% <-Median-> 7 Change
Debt/Market Cap Ratio 0.48 0.49 0.64 0.66 0.62 0.68 0.71 1.19 0.89 0.65 <-Median-> 8 Debt/Market Cap Ratio
Long Term Debt $11.99 $10.67 $8.62 $14.31 Debt
Change -11.01% -19.15% 66.00% -15.08% <-Median-> 2 Change
Debt/Market Cap Ratio 0.02 0.02 0.02 0.03 0.02 <-Median-> 3 Debt/Market Cap Ratio
Goodwill & Intangibles $0.00 $0.00 $0.00 $11.65 $11.63 $12.01 $42.42 $38.21 $43.37 $41.96 $18.47 $18.12 $17.86 Intangibles Goodwill
Change -0.13% 3.27% 253.12% -9.93% 13.51% -3.24% -55.99% -1.85% -1.43% -0.99% <-Median-> 8 Change
Intangible/Market Cap Ratio 0.00 0.00 0.00 0.04 0.02 0.02 0.09 0.07 0.08 0.08 0.03 0.05 0.04 0.04 <-Median-> 10 Intangible/Market Cap Ratio
Market Cap $146.8 $201.3 $524.0 $281.0 $483.4 $523.1 $486.0 $557.3 $560.6 $507.2 $552.7 $385.2 $430.7 $430.7 $467.7 91.34% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 33.868 41.368 41.367 42.087 42.154 42.154 42.154 42.154 42.501 42.517 42.517 42.517 42.517 2.78% <-Total Growth 10 Diluted
Change 0.00% 22.15% 0.00% 1.74% 0.16% 0.00% 0.00% 0.00% 0.82% 0.04% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Change
Basic # of Shares in Millions 33.868 41.368 41.367 42.087 42.154 42.154 42.154 42.154 42.501 42.517 42.517 42.517 42.517 2.78% <-Total Growth 10 Average
Change 0.00% 22.15% 0.00% 1.74% 0.16% 0.00% 0.00% 0.00% 0.82% 0.04% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Change
Difference 0.00% 0.00% 0.00% 0.16% 0.00% 0.00% 0.00% 0.00% -0.82% 0.00% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Difference
Excl.Working Capital CF $31.0 <-12 mths -35.76%
-$72.1 <-12 mths -266.13%
# of Share in Millions 33.868 41.368 41.368 42.154 42.154 42.154 42.154 42.154 42.154 42.517 42.517 42.517 42.517 42.517 42.517 0.27% <-IRR #YR-> 10 Shares 2.78%
Change 0.00% 22.15% 0.00% 1.90% 0.00% 0.00% 0.00% 0.00% 0.00% 0.86% 0.00% 0.00% 0.00% 0.00% 0.00% 0.17% <-IRR #YR-> 5 Shares 0.86%
Cash Flow fr Op $Millon -$4.1 $30.5 $42.9 $77.3 $100.2 $59.2 $16.0 $60.3 $16.4 $87.1 $74.8 $43.4 $67.2 42.36% <-Total Growth 10 Cash Flow
Increase -120.56% 846.71% 40.64% 80.07% 29.65% -40.90% -73.04% 277.98% -72.82% 431.05% -14.14% -41.92% 54.69% Share Issue
5 year Running Average $33.3 $49.3 $62.0 $59.1 $62.6 $50.4 $47.8 $50.9 $56.4 $57.8 -9.03% <-Total Growth 8 CF 5 Yr Running
CFPS -$0.12 $0.74 $1.04 $1.83 $2.38 $1.40 $0.38 $1.43 $0.39 $2.05 $1.76 $1.02 $1.58 38.51% <-Total Growth 10 Cash Flow per Share
Increase -120.56% 711.33% 40.64% 76.71% 29.65% -40.90% -73.04% 277.98% -72.82% 426.52% -14.14% -41.92% 54.69% 3.60% <-IRR #YR-> 10 Cash Flow 42.36%
5 year Running Average $0.81 $1.17 $1.48 $1.41 $1.48 $1.20 $1.13 $1.20 $1.33 $1.36 22.16% <-IRR #YR-> 5 Cash Flow 172.09%
P/CF on Med Price -27.63 6.43 8.38 5.27 3.57 8.02 28.79 9.58 33.78 6.52 6.79 11.19 5.82 3.31% <-IRR #YR-> 10 Cash Flow per Share 38.51%
P/CF on Closing Price -35.93 6.60 12.21 3.64 4.83 8.84 30.45 9.24 34.19 5.82 7.39 8.87 6.41 21.95% <-IRR #YR-> 5 Cash Flow per Share 169.77%
-21.82% Diff M/C 1.81% <-IRR #YR-> 7 CFPS 5 yr Running #DIV/0!
Excl.Working Capital CF $20.9 -$12.9 -$3.2 -$9.0 -$37.7 -$11.6 $35.4 $48.4 $15.9 -$22.2 $0.5 $4.8 $0.0 -1.11% <-IRR #YR-> 5 CFPS 5 yr Running -5.41%
CF fr Op $M WC $16.8 $17.6 $39.7 $68.3 $62.5 $47.6 $51.4 $108.7 $32.3 $64.9 $75.3 $48.2 $67.2 174.06% <-Total Growth 10 Cash Flow less WC
Increase 47.16% 4.87% 125.86% 71.93% -8.53% -23.82% 7.99% 111.52% -70.27% 100.84% 16.01% -35.99% 39.39% 10.61% <-IRR #YR-> 10 Cash Flow less WC 174.06%
5 year Running Average $30.8 $41.0 $47.1 $53.9 $67.7 $60.5 $61.0 $66.5 $65.9 $57.6 -1.28% <-IRR #YR-> 5 Cash Flow less WC -6.22%
CFPS Excl. WC $0.50 $0.43 $0.96 $1.62 $1.48 $1.13 $1.22 $2.58 $0.77 $1.53 $1.77 $1.13 $1.58 7.02% <-IRR #YR-> 7 CF less WC 5 Yr Run #DIV/0!
Increase 47.16% -14.14% 125.86% 68.73% -8.53% -23.82% 7.99% 111.52% -70.27% 99.12% 16.01% -35.99% 39.39% 4.10% <-IRR #YR-> 5 CF less WC 5 Yr Run 22.25%
5 year Running Average $0.77 $1.00 $1.12 $1.28 $1.61 $1.43 $1.44 $1.57 $1.56 $1.36 10.30% <-IRR #YR-> 10 CFPS - Less WC 166.65%
P/CF on Median Price 6.73 11.15 9.05 5.96 5.72 9.98 8.94 5.32 17.14 8.75 6.75 10.08 5.82 -1.45% <-IRR #YR-> 5 CFPS - Less WC -7.02%
P/CF on Closing Price 8.75 11.45 13.19 4.12 7.74 10.99 9.46 5.13 17.35 7.82 7.34 7.99 6.41 6.57% <-IRR #YR-> 7 CFPS 5 yr Running #DIV/0!
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 8.20 5 yr 9.58 P/CF Med 10 yr 8.84 5 yr 8.75 -27.50% Diff M/C 3.94% <-IRR #YR-> 5 CFPS 5 yr Running 21.31%
OPM Ratio -0.91% 5.72% 5.67% 7.43% 11.34% 7.00% 1.64% 4.15% 1.23% 6.38% 5.18% 2.73% -52.24% <-Total Growth 10 OPM
Increase -120.58% 726.88% -0.89% 31.12% 52.63% -38.31% -76.60% 153.17% -70.30% 418.30% -18.91% -47.22% Should increase or be stable.
Diff from Median -116.8% 5.5% 4.5% 37.1% 109.2% 29.1% -69.8% -23.5% -77.3% 17.7% -4.5% -49.6% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 5.42% 5 Yrs 4.15% should be zero, it is a check on calculations
Current Assets $148.0 $194.8 $335.2 $505.9 $415.9 $461.7 $539.0 $618.4 $546.7 $530.5 $652.9 $743.3 $628.8 Liquidity ratio of 1.5 and up, best
Current Liabilities $117.3 $160.2 $285.4 $422.4 $293.7 $319.9 $416.1 $464.0 $426.3 $426.5 $525.5 $625.3 $534.8 1.26 <-Median-> 10 Ratio
Liquidity Ratio 1.26 1.22 1.17 1.20 1.42 1.44 1.30 1.33 1.28 1.24 1.24 1.19 1.18 1.24 <-Median-> 5 Ratio
Liq. with CF aft div 1.11 1.08 1.26 1.33 1.68 1.55 1.27 1.40 1.25 1.37 1.32 1.21 1.27 1.32 <-Median-> 5 Ratio
Liq. CF re Inv+Div 1.11 1.06 1.26 1.31 1.67 1.46 1.11 1.33 1.25 1.32 1.32 1.20 1.27 1.32 <-Median-> 5 Ratio
Curr Long Term Debt $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $14.0 $15.4 $16.2 $8.7 $8.7 $8.7
Liquidity Less CLTD 1.26 1.22 1.17 1.20 1.42 1.44 1.30 1.37 1.33 1.29 1.26 1.21 1.20 1.29 <-Median-> 5 Ratio
Liq. with CF aft div 1.11 1.08 1.26 1.33 1.68 1.55 1.27 1.44 1.29 1.43 1.35 1.22 1.29 1.35 <-Median-> 5 Ratio
Assets $150.9 $198.8 $341.4 $528.2 $438.6 $482.7 $632.5 $718.1 $648.1 $637.3 $734.0 $817.4 $728.7 Debt Ratio of 1.5 and up, best
Liabilities $117.3 $160.3 $288.1 $426.5 $303.3 $319.9 $470.1 $526.6 $470.8 $455.7 $563.1 $653.8 $570.6 1.35 <-Median-> 10 Ratio
Debt Ratio 1.29 1.24 1.18 1.24 1.45 1.51 1.35 1.36 1.38 1.40 1.30 1.25 1.28 1.36 <-Median-> 5 Ratio
Book Value $33.5 $38.474 $53.3 $101.7 $135.3 $162.9 $162.4 $191.6 $177.3 $181.6 $170.9 $163.6 $158.0 $158.0 $158.0 325.13% <-Total Growth 10 Book Value
Book Value per share $0.99 $0.93 $1.29 $2.41 $3.21 $3.86 $3.85 $4.54 $4.21 $4.27 $4.02 $3.85 $3.72 $3.72 $3.72 313.64% <-Total Growth 10 Book Value per Share
Change -1.11% -6.06% 38.46% 87.31% 33.11% 20.32% -0.27% 17.95% -7.45% 1.55% -5.89% -4.29% -3.39% 0.00% 0.00% -8.98% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 3.37 5.10 6.75 4.00 2.64 2.92 2.83 3.02 3.12 3.13 2.97 2.97 2.47 2.99 P/B Ratio Historical Median
P/B Ratio (Close) 4.38 5.23 9.84 2.76 3.57 3.21 2.99 2.91 3.16 2.79 3.23 2.36 2.73 2.73 2.96 15.26% <-IRR #YR-> 10 Book Value per Share 313.64%
Change 87.79% 19.56% 87.97% -71.90% 29.22% -10.05% -6.84% -2.79% 8.70% -11.67% 15.79% -27.19% 15.73% 0.00% 8.59% -0.03% <-IRR #YR-> 5 Book Value per Share -0.15%
Leverage (A/BK) 4.50 5.17 6.41 5.19 3.24 2.96 3.89 3.75 3.66 3.51 4.30 5.00 4.61 3.75 <-Median-> 5 A/BV
Debt/Equity Ratio 3.50 4.17 5.41 4.19 2.24 1.96 2.89 2.75 2.66 2.51 3.30 4.00 3.61 2.75 <-Median-> 5 Debt/Eq Ratio
Shareholders' Equity (Assets less Liabilities) P/BV 10 yr Med 2.99 5 yr Med 3.02 -8.98% Diff M/C 4.30 Historical Leverage (A/BK)
$13 <-12 mths -49.28%
Comprehensive Income $15.62 $22.2 $23.65 $60.86 $56.91 $47.32 $29.60 $58.25 $12.09 $36.24 $21.48 $25.00 12.75% <-Total Growth 10 Comprehensive Income
Increase 6.60% 41.99% 6.66% 157.33% -6.49% -16.86% -37.45% 96.81% -79.24% 199.73% -40.72% 16.39% 16.39% <-Median-> 5 Comprehensive Income
5 Yr Running Average $27.39 $35.84 $42.18 $43.67 $50.59 $40.83 $36.70 $31.53 $30.61 1.21% <-IRR #YR-> 10 Comprehensive Income 12.75%
ROE 46.6% 57.6% 44.4% 59.9% 42.0% 29.1% 18.2% 30.4% 6.8% 20.0% 12.6% 15.3% -3.32% <-IRR #YR-> 5 Comprehensive Income -15.52%
5Yr Median 46.6% 46.6% 44.4% 42.0% 30.4% 29.1% 20.0% 18.2% 15.3% 1.40% <-IRR #YR-> 8 5 Yr Running Average #DIV/0!
% Difference from NI 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -6.86% <-IRR #YR-> 5 5 Yr Running Average -29.90%
Median Values Diff 5, 10 yr 0.0% 0.0% 15.3% <-Median-> 5 Return on Equity
Current Liability Coverage Ratio 0.14 0.11 0.14 0.16 0.21 0.15 0.12 0.23 0.08 0.15 0.14 0.08 0.13 CFO / Current Liabilities
5 year Median 0.14 0.14 0.15 0.15 0.16 0.15 0.15 0.14 0.14 0.13 0.14 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 11.11% 8.84% 11.63% 12.93% 14.24% 9.86% 8.13% 15.14% 4.99% 10.18% 10.26% 5.90% 9.22% CFO / Total Assets
5 year Median 11.11% 11.63% 11.63% 11.63% 12.93% 9.86% 9.86% 10.18% 10.18% 9.22% 10.2% <-Median-> 5 Return on Assets
Return on Assets ROA 10.4% 11.2% 6.9% 11.5% 13.0% 9.8% 4.7% 8.1% 1.9% 5.7% 2.9% 3.1% 2.1% Net Income/Assets Return on Assets
5Yr Median 10.4% 11.2% 11.2% 9.8% 9.8% 8.1% 5.7% 4.7% 3.1% 2.9% 3.1% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 46.6% 57.6% 44.4% 59.9% 42.0% 29.1% 18.2% 30.4% 6.8% 20.0% 12.6% 15.3% 9.6% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 32.4% 43.2% 44.4% 46.6% 46.6% 44.4% 42.0% 30.4% 29.1% 20.0% 18.2% 15.3% 12.6% 15.3% <-Median-> 5 Return on Equity
$13 <-12 mths -49.28%
Net Income $15.6 $22.2 $23.7 $60.86 $56.91 $47.3 $29.6 $58.2 $12.1 $36.2 $21.5 $25.0 $15.1 $25.6 $31.5 12.75% <-Total Growth 10 Net Income
Increase 6.60% 41.99% 6.66% 157.33% -6.49% -16.86% -37.45% 96.81% -79.24% 199.73% -40.72% 16.39% -39.60% 69.54% 23.05% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $10.8 $13.8 $17.2 $27.4 $35.8 $42.2 $43.7 $50.6 $40.8 $37 $32 $31 $22.0 $24.7 $23.7 1.21% <-IRR #YR-> 10 Net Income 12.75%
Operating Cash Flow -$4.1 $30.5 $42.9 $77.3 $100.2 $59.2 $16.0 $60.3 $16.4 $87.1 $74.8 $43.4 -3.32% <-IRR #YR-> 5 Net Income -15.52%
Investment Cash Flow -$0.2 -$2.8 -$1.3 -$7.3 -$1.7 -$20.2 -$60.9 -$24.1 $0.0 -$17.4 $7.7 -$4.0 8.28% <-IRR #YR-> 10 5 Yr Running Average 121.60%
Total Accruals $19.9 -$5.5 -$18.0 -$9.1 -$41.5 $8.3 $74.5 $22.0 -$4.3 -$33.5 -$61.0 -$14.4 -6.86% <-IRR #YR-> 5 5 Yr Running Average -29.90%
Total Assets $150.9 $198.8 $341.4 $528.2 $438.6 $482.7 $632.5 $718.1 $648.1 $637.3 $734.0 $817.4 Balance Sheet Assets
Accruals Ratio 13.21% -2.77% -5.27% -1.71% -9.47% 1.73% 11.78% 3.06% -0.66% -5.26% -8.31% -1.76% -1.76% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.91 1.29 0.84 0.89 0.91 1.00 0.57 0.54 0.37 0.56 0.29 0.52 0.57 <-Median-> 10 EPS/CF Ratio
Change in Close 85.71% 12.31% 160.27% -47.37% 72.00% 8.23% -7.09% 14.66% 0.61% -10.30% 8.97% -30.31% 11.81% 0.00% 8.59% Count 20 Years of data
up/down down up up down up up Count 6 30.00%
Meet Prediction? yes yes yes % right Count 3 50.00%
Financial Cash Flow -$16.4 -$16.1 $15.6 $22.0 -$99.3 -$25.3 $0.9 -$26.6 $0.0 $44.1 -$27.7 $3.5 C F Statement Financial Cash Flow
Total Accruals $36.3 $10.6 -$33.6 -$31.1 $57.8 $33.6 $73.6 $48.6 -$4.3 -$77.6 -$33.2 -$17.9 Accruals
Accruals Ratio 24.07% 5.33% -9.85% -5.88% 13.17% 6.97% 11.64% 6.76% -0.66% -12.17% -4.53% -2.19% -2.19% <-Median-> 5 Ratio
Cash $43.8 $55.5 $112.7 $204.6 $203.6 $217.4 $173.4 $183.1 $138.4 $164.0 $218.8 $261.9 $96.5 Cash
Change -32.02% 26.54% 103.25% 81.54% -0.49% 6.78% -20.25% 5.58% -24.43% 18.56% 33.36% 19.71% -63.15% 18.56% <-Median-> 5 Change
Cash per Share $1.29 $1.34 $2.72 $4.85 $4.83 $5.16 $4.11 $4.34 $3.28 $3.86 $5.15 $6.16 $2.27 434.31% <-Median-> 5 Cash per Share
Change -32.02% 3.60% 103.25% 78.15% -0.49% 6.78% -20.25% 5.58% -24.43% 17.55% 33.36% 19.71% -63.15% 17.55% <-Median-> 5 Change
Percentage of Stock Price 29.86% 27.55% 21.51% 72.82% 42.13% 41.57% 35.68% 32.85% 24.68% 32.34% 39.58% 67.98% 22.41% 32.85% <-Median-> 5 % of Stock Price
Notes
December 24, 2017. Last estimates were for 2016, 2017 and 2018 of $1575M, $1455M and $1473M for Revenue, $0.60, $0.63 and $0.43 for EPS,
$1.58 and $1.62 for CFPS for 2016 and 2017 and $25.6M and $19.1M for Net Income for 2016 and 2017.
January 1, 2017. Last estimates are for 2015, 2016 and 2017 of 1431M, $1641M and $1495M for Revemue, $0.80, $0.78 and $0.74 for EPS, $1.58 and $1.41 for CFPS for 2015 and 2016 and $35.6, $31.7 amd $31 for Net Income.
Bird construction became an income trust in 2006, then changed back to a corporation on January 1, 2011.
Bird Construction was founded in 1920 and incorporated in 1930. It issues stock on the Winnipeg Stock Exchange in 1949.
On January 1, 2011 this stock changed from an income to a corporation.
The conversion from a corporation listed on the TSX Venture Exchange to an income trust listed on the TSX Bird Construction Income Fund (symbol)
BDT.UN) was completed on February 27, 2006.
Sector:
Construction, Industrial
What should this stock accomplish?
You would buy this stock for diversification purposes. Since this is an industrial stock, expect volatility in the short term, but expect to earn both capital gains and rising dividend income in the longer term.
You should expect volatility especially concerning Earnings and Cash Flow.
Would I buy this company and Why.
I did consider this company when looking at something to buy for 2016. However, I preferred the companies I bought instead.
This dones not mean I think it is a poor investment choice, it is just not my choice at the period in time.
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
Why am I following this stock.
This was listed as a top stock in ETF of iShares S&P TSX Canadian Dividend Aristocrats Index.
I had not heard of it before, so I decided to do a spreadsheet on this stock.
Dividends
Dividends are paid monthly. 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 November 9, 2016 was for shareholders of record of January 31, 2016 and paid on February 17, 2017.
How they make their money.
The company operates from 12 offices across Canada serving the heavy industrial market in all provinces as well as serving the industrial, commercial and institutional (ICI) markets
in all provinces with the exception of Quebec. The work of the company is split almost evenly between the heavy industrial market and the ICI sector.
Industrial, commercial, and institutional sector is the ICI sector.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Dec 29 2015 Jan 1 2017 Dec 24 2017
Boyd, Ian Jeffrey 0.055 0.13% 0.070 0.16% 0.070 0.16%
CEO - Shares - Amount $0.710 $0.634 $0.709
Options - percentage 0.169 0.40% 0.198 0.46% 0.259 0.61%
Options - amount $2.191 $1.790 $2.628
Gingrich, Wayne Richard 0.018 0.04% 0.018 0.04%
CFO - Shares - Amount $0.163 $0.182
Options - percentage 0.000 0.00% 0.044 0.10%
Options - amount $0.000 $0.445
Entwistle, Stephen Robert 0.000 0.00% 0.000 0.00% Ink Still listed as CFO
CFO - Shares - Amount $0.000 $0.000 In 2016
Options - percentage 0.004 0.01% 0.000 0.00% Ceased to be insider Apr 2017
Options - amount $0.054 $0.000
Caza, Charles Joseph 0.006 0.01%
Officer - Shares - Amount $0.062
Options - percentage 0.034 0.08%
Options - amount $0.345
Brennan, James Joseph 0.126 0.30% 0.126 0.30% Not found in 2017
Officer - Shares - Amount $1.638 $1.141
Options - percentage 0.042 0.10% 3.016 7.09%
Options - amount $0.549 $27.328
Bird, John Richard 0.821 1.93% 0.821 1.93% 0.821 1.93%
Director - Shares - Amount $10.673 $7.438 $8.317
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
Charette, Paul Alphonse 0.150 0.35% 0.150 0.35% 0.150 0.35%
Chairman - Shares - Amt $1.950 $1.359 $1.520
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000
Increase in O/S Shares 0.000 0.00% 0.000 0.00% 0.000 0.00% Yes 0, but there are
due to SO $0.000 $0.000 $0.000 o/s stock options
Book Value $0.350 $0.119 $0.000 Stock Based expense
Insider Buying -$0.132 -$0.225 -$0.063
Insider Selling $0.158 $0.000 $0.000
Net Insider Selling $0.026 -$0.225 -$0.063
Net Selling % of Market Cap 0.00% -0.06% -0.01%
Directors 8 8 10
Women 1 13% 1 13% 2 20%
Minorities 0 0% 0 0% 0 0%
Institutions/Holdings 41 33.90% 44 21.82% 44.000 35.42%
Total Shares Held 14.413 33.90% 9.275 21.82% 15.058 35.42%
Increase/Decrease 3 Mths -1.240 -7.92% -0.190 -2.00% -0.591 -3.77%
Starting No. of Shares 15.652 9.465 15.649
Copyright 2008 Website of SPBrunner. All rights reserved.