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 2016
IBI Group Inc. TSX: IBG OTC: IBIBF www.ibigroup.com Fiscal Yr: Dec 31
Year 12/31/04 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 Value Description #Y Item
Accounting Rules fr Aug '04 C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$352.2 <-12 mths 7.68%
Revenue* $92.0 $98.3 $151.9 $166.9 $248.0 $273.7 $290.4 $332.3 $337.7 $288.0 $298.3 $327.1 $353 $364 $376 232.65% <-Total Growth 10 Revenue
Increase 6.83% 54.49% 9.85% 48.62% 10.35% 6.11% 14.43% 1.63% -14.73% 3.58% 9.66% 7.92% 3.12% 3.30% 12.77% <-IRR #YR-> 10 Revenue
5 year Running Average $151.4 $187.8 $226.2 $262.3 $296.4 $304.4 $309.3 $316.7 $320.8 $326.1 $343.7 2.41% <-IRR #YR-> 5 Revenue
Revenue per Share $18.31 $19.56 $17.73 $15.67 $21.96 $21.48 $22.47 $25.52 $20.05 $16.42 $16.75 $13.10 $14.14 $14.58 $15.06 9.10% <-IRR #YR-> 6 5 yr Running Average
Increase 6.83% -9.38% -11.63% 40.17% -2.17% 4.58% 13.57% -21.43% -18.08% 1.98% -21.78% 7.92% 3.12% 3.30% 6.96% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $18.65 $19.28 $19.86 $21.42 $22.30 $21.19 $20.24 $18.37 $16.09 $15.00 $14.73 -3.93% <-IRR #YR-> 10 Revenue per Share -2.24%
P/S (Price/Sales) Med 0.58 0.52 0.66 1.19 0.77 0.68 0.67 0.52 0.54 0.25 0.12 0.15 -10.23% <-IRR #YR-> 5 Revenue per Share -11.14%
P/S (Price/Sales) Close 0.61 0.51 0.68 1.53 0.55 0.79 0.60 0.52 0.32 0.05 0.11 0.17 0.44 0.42 0.41 -0.81% <-IRR #YR-> 6 5 yr Running Average
*Revenue in M CDN $ P/S Med 10 yr 0.60 5 yr 0.25 -27.14% Diff M/C -1.55% <-IRR #YR-> 5 5 yr Running Average
-$98.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $327.1
-$290.4 $0.0 $0.0 $0.0 $0.0 $327.1
-$187.8 $0.0 $0.0 $0.0 $0.0 $0.0 $316.7
-$226.2 $0.0 $0.0 $0.0 $0.0 $316.7
-$19.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13.10
-$22.47 $0.00 $0.00 $0.00 $0.00 $13.10
-$19.28 $0.00 $0.00 $0.00 $0.00 $0.00 $18.37
-$19.86 $0.00 $0.00 $0.00 $0.00 $18.37
-$0.11 <-12 mths -126.83%
EPS Basic -$0.05 $0.75 $1.32 $1.86 $1.67 $0.76 $1.11 $0.70 -$0.70 -$10.05 -$0.14 $0.41 -45.57% <-Total Growth 10 EPS Basic
EPS Diluted* -$0.05 $0.75 $1.32 $1.86 $1.67 $0.76 $1.11 $0.70 -$0.70 -$10.05 -$0.14 $0.41 $0.29 $0.52 $0.54 -45.57% <-Total Growth 10 EPS Diluted
Increase 1624.90% 75.34% 40.96% -10.06% -54.80% 46.64% -36.62% -199.52% -1335.71% 98.61% 392.86% -29.27% 79.31% 3.85% 5.90% <-IRR #YR-> 10 Earnings per Share -45.57% 14.07%
Earnings Yield -0.4% 7.6% 10.9% 7.8% 13.9% 4.5% 8.2% 5.3% -10.9% -1142.0% -7.4% 18.6% 4.7% 8.4% 8.7% -18.06% <-IRR #YR-> 5 Earnings per Share -63.06% -16.24%
5 year Running Average $1.11 $1.27 $1.34 $1.22 $0.71 -$1.64 -$1.82 -$1.96 -$2.04 -$1.79 $0.32 #NUM! <-IRR #YR-> 7 5 yr Running Average -275.81%
10 year Running Average -$0.26 -$0.27 -$0.31 -$0.41 -$0.54 -$0.66 #NUM! <-IRR #YR-> 5 5 yr Running Average -245.41%
* ESP per share (Cdn GAAP) E/P 10 Yrs 6.55% 5Yrs -7.45%
-$0.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.41
-$1.11 $0.00 $0.00 $0.00 $0.00 $0.41
-$1.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.96
-$1.34 $0.00 $0.00 $0.00 $0.00 -$1.96
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* $1.13 $1.13 $1.21 $1.37 $1.55 $1.60 $1.60 $1.15 $1.10 $0.14 $0.00 $0.00 $0.00 $0.00 $0.00 -100.00% <-Total Growth 10 Dividends
Increase 0.00% 7.89% 13.15% 13.04% 3.04% 0.00% -28.40% -3.61% -87.55% -100.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0! Count 12 Years of data
Dividends 5 Yr Running $1.28 $1.37 $1.47 $1.45 $1.40 $1.12 $0.80 $0.48 $0.25 $0.03 $0.00 #DIV/0! <-Total Growth 7 Dividends 5 Yr Running
Yield H/L Price 10.54% 10.98% 10.31% 7.39% 9.17% 10.97% 10.59% 8.70% 10.24% 3.41% 0.00% 0.00% 0.00% 8.93% <-Median-> 10 Yield H/L Price
Yield on High Price 9.78% 8.93% 8.43% 5.49% 6.47% 9.11% 9.04% 7.24% 7.21% 1.86% 0.00% 0.00% 0.00% 6.84% <-Median-> 10 Yield on High Price
Yield on Low Price 11.43% 14.24% 13.27% 11.30% 15.76% 13.78% 12.80% 10.88% 17.69% 20.52% 0.00% 0.00% 0.00% 13.03% <-Median-> 10 Yield on Low Price
Yield on Close Price 10.00% 11.31% 10.03% 5.74% 12.93% 9.41% 11.84% 8.68% 17.12% 15.63% 0.00% 0.00% 0.00% 0.00% 0.00% 9.72% <-Median-> 10 Yield on Close Price
Payout Ratio EPS -2277.33% 149.34% 91.90% 73.76% 92.70% 211.36% 144.13% 162.82% -157.71% -1.37% 0.00% 0.00% 0.00% 0.00% 0.00% 82.83% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 114.90% 107.80% 109.15% 119.06% 197.51% -68.29% -43.92% -24.41% -12.18% -1.53% 0.00% 108.47% <-Median-> 8 DPR EPS 5 Yr Running
Payout Ratio CFPS -28.61% 55.22% 411.68% 116.94% 3895.60% -215.53% 149.68% -239.83% -533.79% 25.48% 0.00% 0.00% 0.00% 0.00% #DIV/0! 12.74% <-Median-> 10 DPR CF
DPR CF 5 Yr Running -1653.50% 244.78% 399.81% 683.85% -2201.29% 3072.84% 163.57% 91.69% 33.73% 3.08% #DIV/0! 204.17% <-Median-> 8 DPR CF 5 Yr Running
Payout Ratio CFPS WC 134.88% 41.24% 43.64% 53.07% 44.90% 73.59% 72.61% 37.20% 83.28% -7.54% 0.00% 0.00% 0.00% 0.00% #DIV/0! 44.27% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 51.58% 50.00% 55.59% 53.86% 57.21% 80.28% 67.70% 48.17% 50.13% 7.94% #DIV/0! 54.72% <-Median-> 8 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 3.41% 8.68% 5 Yr Med Payout 0.00% 0.00% 0.00% #NUM! <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. -100.00% -100.00% Last Div Inc ---> $0.14 $0.00 -100.00% #NUM! <-IRR #YR-> 5 Dividends
-$1.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
-$1.60 $0.00 $0.00 $0.00 $0.00 $0.00
Historical Dividends Historical High Div 19.67% Low Div 0.00% Ave Div 9.84% Med Div 9.71% Close Div 10.02% Historical Dividends
High/Ave/Median Values Curr diff Exp. -100.00% #DIV/0! #DIV/0! Exp. -100.00% Exp. -100.00% Exp. -100.00% High/Ave/Median
Future Dividend Yield Div Yd 0.00% earning in 5 Years at IRR of 0.00% Div Inc. #DIV/0! Future Dividend Yield
Future Dividend Yield Div Yd 0.00% earning in 10 Years at IRR of 0.00% Div Inc. #DIV/0! Future Dividend Yield
Future Dividend Yield Div Yd 0.00% earning in 15 Years at IRR of 0.00% Div Inc. #DIV/0! Future Dividend Yield
Yield if held 5 yrs 14.99% 15.61% 9.73% 5.94% 0.81% 0.00% 0.00% 0.00% 0.00% 0.00% 5.94% <-Median-> 7 Paid Median Price
Yield if held 10 yrs 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% <-Median-> 2 Paid Median Price
Cost covered if held 5 years 64.33% 71.60% 61.74% 37.69% 33.00% 27.34% 15.81% 9.43% 1.28% 0.00% 37.69% <-Median-> 7 Paid Median Price
Cost covered if held 10 years 101.69% 94.88% 72.29% 38.43% 33.00% 98.29% <-Median-> 2 Paid Median Price
Graham No. $11.71 $16.48 $22.53 $21.55 $13.91 $16.39 $11.25 #NUM! $3.98 $2.66 #NUM! #NUM! #NUM! #NUM! #NUM! <-Total Growth 8 Graham Number
Price/GP Ratio Med 0.88 0.71 0.82 0.79 1.05 0.92 1.17 #NUM! 1.01 0.73 #NUM! #NUM! #NUM! <-Median-> 8 Price/GP Ratio
Price/GP Ratio High 1.08 0.87 1.11 1.11 1.26 1.08 1.41 #NUM! 1.86 1.08 #NUM! #NUM! #NUM! <-Median-> 8 Price/GP Ratio
Price/GP Ratio Low 0.67 0.56 0.54 0.46 0.83 0.76 0.94 #NUM! 0.17 0.37 #NUM! #NUM! #NUM! <-Median-> 8 Price/GP Ratio
Price/GP Ratio Close 0.85 0.73 1.06 0.56 1.22 0.82 1.17 #NUM! 0.22 0.71 #NUM! #NUM! #NUM! #NUM! #NUM! <-Median-> 8 Price/GP Ratio
Prem/Disc Close -15.03% -26.60% 6.24% -44.26% 22.13% -17.55% 17.34% #NUM! -77.90% -29.28% #NUM! #NUM! #NUM! #NUM! #NUM! <-Median-> 8 Graham Price
Price Close $11.25 $9.95 $12.10 $23.94 $12.01 $16.99 $13.51 $13.20 $6.45 $0.88 $1.88 $2.21 $6.19 $6.19 $6.19 -77.79% <-Total Growth 10 Stock Price
Increase -11.56% 21.61% 97.85% -49.83% 41.47% -20.48% -2.29% -51.14% -86.36% 113.64% 17.55% 180.09% 0.00% 0.00% -13.97% 10 Stock Price -6.48%
P/E -227.73 13.21 9.16 12.86 7.17 22.45 12.17 18.77 -9.21 -0.09 -13.43 5.39 21.34 11.90 11.46 -30.38% 5 Stock Price -14.05%
Trailing P/E -201.42 16.06 18.13 6.45 10.15 17.85 11.89 9.17 -1.26 -0.19 -15.79 15.10 21.34 11.90 3.75% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 17.72% 4.85% % Tot Ret 472% -18.99% Price Inc -2.29% P/E: 8.17 -0.09 -25.53% <-IRR #YR-> 5 Price & Dividend
-$9.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.21
-$13.51 $0.00 $0.00 $0.00 $0.00 $2.21
-$9.95 $1.21 $1.37 $1.55 $1.60 $1.60 $1.15 $1.10 $0.14 $0.00 $2.21
-$13.51 $1.15 $1.10 $0.14 $0.00 $2.21
Price H/L Median $10.67 $10.25 $11.78 $18.58 $16.93 $14.58 $15.10 $13.17 $10.78 $4.03 $1.93 $1.99 $4.36 -80.63% <-Total Growth 10 Stock Price
Increase -3.94% 14.88% 57.75% -8.88% -13.86% 3.57% -12.78% -18.15% -62.62% -52.11% 2.85% 119.40% -15.14% <-IRR #YR-> 10 Stock Price
P/E -215.99 13.61 8.92 9.98 10.11 19.27 13.61 18.72 -15.40 -0.40 -13.79 4.84 15.02 -33.36% <-IRR #YR-> 5 Stock Price
Trailing P/E -207.49 15.63 14.06 9.09 8.71 19.95 11.87 15.33 -5.76 -0.19 -14.18 10.62 2.76% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 15.22 11.45 11.23 10.78 15.21 -2.46 -1.06 -1.02 -2.14 -28.90% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave -15.39 -7.12 -6.50 -10.66 9.45 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 17.90% 4.46% % Tot Ret 648.37% -15% Price Inc -18.15% P/E: 9.45 -0.40 Count 12 Years of data
-$10.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.99
-$15.10 $0.00 $0.00 $0.00 $0.00 $1.99
-$10.25 $1.21 $1.37 $1.55 $1.60 $1.60 $1.15 $1.10 $0.14 $0.00 $1.99
-$15.10 $1.15 $1.10 $0.14 $0.00 $1.99
High Months Dec Feb Sep Dec Apr Dec Jan Mar Mar Mar Nov Nov Oct
Price High $11.50 $12.60 $14.40 $25.00 $24.00 $17.55 $17.70 $15.81 $15.32 $7.39 $2.88 $2.64 $6.64 -79.05% <-Total Growth 10 Stock Price
Increase 9.57% 14.29% 73.61% -4.00% -26.88% 0.85% -10.68% -3.10% -51.76% -61.03% -8.33% 151.52% -14.47% <-IRR #YR-> 10 Stock Price
P/E -232.79 16.73 10.90 13.43 14.33 23.19 15.95 22.48 -21.89 -0.74 -20.57 6.44 22.90 -31.65% <-IRR #YR-> 5 Stock Price
Trailing P/E -255.06 19.12 18.93 12.89 10.48 23.39 14.25 21.78 -10.56 -0.29 -18.86 16.20 12.17 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -10.68% P/E: 12.17 -0.74 19.03 P/E Ratio Historical High
-$12.60 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.64
-$17.70 $0.00 $0.00 $0.00 $0.00 $2.64
Low Months Oct Oct Jan Jan Dec Mar May Oct Nov Dec Jan Apr Jan
Price Low $9.84 $7.90 $9.15 $12.15 $9.85 $11.61 $12.50 $10.53 $6.24 $0.67 $0.98 $1.33 $2.07 -83.16% <-Total Growth 10 Stock Price
Increase -19.72% 15.82% 32.79% -18.93% 17.87% 7.67% -15.76% -40.74% -89.26% 46.27% 35.71% 55.64% -16.32% <-IRR #YR-> 10 Stock Price
P/E -199.19 10.49 6.93 6.53 5.88 15.34 11.26 14.97 -8.91 -0.07 -7.00 3.24 7.14 -36.12% <-IRR #YR-> 5 Stock Price
Trailing P/E -159.92 12.15 9.20 5.29 6.93 16.52 9.49 8.87 -0.96 -0.10 -9.50 5.05 6.20 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -15.76% P/E: 6.20 -0.07 -7.77 P/E Ratio Historical Low
-$7.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.33
Debt $63.42 $72.28 $35.89 Debt
Change 13.96% -50.35%
Debt/Market Cap Ratio 1.89 1.31 0.23 <------ 1.60 <-Median-> 2 Debt/Market Cap Ratio
Change
Goodwill & Intangibles $183.2 $195.0 $201.9 $188.2 $4.7 $5.3 $6.9 $7.6 Intangibles Goodwill
Intangible/Market Cap Ratio 0.85 1.12 1.17 1.73 0.30 0.16 0.12 0.05 0.85 <-Median-> 7 Intangible/Market Cap Ratio
Market Cap $56.5 $50.0 $103.7 $255.0 $135.6 $216.4 $174.6 $171.9 $108.7 $15.4 $33.5 $55.2 $154.5 $154.5 $154.5 10.34% <-Total Growth 10 Stock Price
Change -11.56% 107.31% 145.96% -46.81% 59.57% -19.32% -1.55% -36.79% -85.80% 116.99% 64.80% 180.09% 0.00% 0.00%
Diluted 5.026 5.030 7.930 8.630 10.710 12.120 12.849 12.971 15.549 17.201 17.642 23.059 358.43% <-Total Growth 10 Diluted
Change 0.08% 57.65% 8.83% 24.10% 13.17% 6.02% 0.95% 19.88% 10.62% 2.56% 30.71% 11.89% <-Median-> 10 Change
Average # of Sh in M 5.026 5.030 7.930 8.630 10.710 12.120 12.849 12.971 15.549 17.201 22.668 17.985 257.55% <-Total Growth 10 Average
Change 0.08% 57.65% 8.83% 24.10% 13.17% 6.02% 0.95% 19.88% 10.62% 31.78% -20.66% 11.89% <-Median-> 10 Change
Difference 0.0% -0.1% 8.0% 23.4% 5.4% 5.1% 0.6% 0.4% 8.3% 1.9% -21.4% 38.8% 5.27% <-Median-> 10 Difference
Class B Parnership Shares 0.000 5.026 5.074 16.89% Class B Partnership 20.32%
$27.85 <-12 mths -9.66%
# of Share in Millions 5.026 5.026 8.568 10.651 11.293 12.738 12.924 13.023 16.845 17.533 17.808 24.967 24.967 24.967 24.967 17.39% <-IRR #YR-> 10 Shares
Change 0.00% 70.48% 24.32% 6.02% 12.80% 1.46% 0.76% 29.35% 4.08% 1.57% 40.20% 0.00% 0.00% 0.00% 14.07% <-IRR #YR-> 5 Shares
CF fr Op $M -$19.8 $10.2 $2.5 $12.5 $0.5 -$9.5 $13.8 -$6.2 -$3.5 $9.5 $26.9 $30.8 $15.0 $14.5 201.06% <-Total Growth 10 Cash Flow
Increase -151.80% -75.33% 395.17% -96.40% -2201% -246.10% -145.03% -43.98% -371.58% 184.80% 14.39% -51.40% -3.33% S. Issue Conv CL B shares DRIP, Conv of Debentures
5 year Running Average $1.2 $3.3 $4.0 $2.2 -$1.0 $0.8 $8.1 $11.5 $15.7 $19.3 253.64% <-Total Growth 7 CF 5 Yr Running
CFPS -$3.93 $2.04 $0.29 $1.17 $0.04 -$0.74 $1.07 -$0.48 -$0.21 $0.54 $1.51 $1.23 $0.60 $0.58 -39.40% <-Total Growth 10 Cash Flow per Share
Increase -152% -85.53% 298.32% -96.61% -1963% -244% -145% -57% -361% 180% -18% -51% -3% 11.65% <-IRR #YR-> 10 Cash Flow 201.06%
5 year Running Average -$0.08 $0.56 $0.37 $0.21 -$0.06 $0.04 $0.49 $0.52 $0.74 $0.89 17.42% <-IRR #YR-> 5 Cash Flow 123.18%
P/CF on Med Price -2.71 5.03 39.94 15.82 424.74 -19.64 14.13 -27.58 -52.12 7.47 1.28 1.61 7.26 -4.88% <-IRR #YR-> 10 Cash Flow per Share -39.40% 7.36%
P/CF on Close -2.86 4.88 41.04 20.39 301.39 -22.89 12.64 -27.64 -31.19 1.63 1.24 1.79 10.32 2.93% <-IRR #YR-> 5 Cash Flow per Share 15.53% 225.64%
127.36% Diff M/C #NUM! <-IRR #YR-> 10 CFPS 5 yr Running 773.67%
Excl.Working Capital CF $24.0 $3.5 $21.3 $15.1 $38.6 $37.1 $14.7 $46.3 $25.8 -$41.4 -$7.3 $0.9 $0.0 $0.0 7.24% <-IRR #YR-> 5 CFPS 5 yr Running 41.82%
CF fr Op $M WC $4.2 $13.7 $23.8 $27.6 $39.0 $27.7 $28.5 $40.1 $22.3 -$32.0 $19.7 $31.7 $15.0 $14.5 131.15% <-Total Growth 10 Cash Flow less WC
Increase 227.03% 73.82% 15.66% 41.65% -29.08% 2.83% 40.81% -44.30% -243% -162% 61% -52.73% -3.33% 8.74% <-IRR #YR-> 10 Cash Flow less WC 131.15%
5 year Running Average $21.7 $26.4 $29.3 $32.6 $31.5 $17.3 $15.7 $16.4 $11.3 $9.8 2.16% <-IRR #YR-> 5 Cash Flow less WC 11.30%
CFPS Excl. WC $0.83 $2.73 $2.78 $2.59 $3.46 $2.17 $2.20 $3.08 $1.33 -$1.82 $1.10 $1.27 $0.60 $0.58 -7.64% <-IRR #YR-> 6 CF less WC 5 Yr Run -24.47%
Increase 227.03% 1.96% -6.96% 33.60% -37.13% 1.35% 39.75% -56.94% -237% -161% 15% -52.73% -3.33% -11.01% <-IRR #YR-> 5 CF less WC 5 Yr Run -44.18%
5 year Running Average $2.48 $2.75 $2.64 $2.70 $2.45 $1.39 $1.18 $0.99 $0.50 $0.35 -7.37% <-IRR #YR-> 10 CFPS - Less WC -53.47% -14.22%
P/CF on Med Price 12.79 3.76 4.23 7.18 4.90 6.71 6.85 4.28 8.13 -2.21 1.75 1.56 -10.44% <-IRR #YR-> 5 CFPS - Less WC -42.38% -27.90%
P/CF on Close 13.49 3.65 4.35 9.25 3.47 7.82 6.13 4.29 4.87 -0.48 1.70 1.74 10.32 10.67 -15.62% <-IRR #YR-> 6 CFPS 5 yr Running -60.00%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 4.54 5 yr 1.28 P/CF Med 10 yr 4.59 5 yr 1.75 124.91% Diff M/C -17.80% <-IRR #YR-> 5 CFPS 5 yr Running -62.47%
-$2.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.23 Cash Flow per Share
-$1.07 $0.00 $0.00 $0.00 $0.00 $1.23 Cash Flow per Share
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.52 CFPS 5 yr Running
-$0.37 $0.00 $0.00 $0.00 $0.00 $0.52 CFPS 5 yr Running
-$13.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $31.7 Cash Flow less WC
-$28.5 $0.0 $0.0 $0.0 $0.0 $31.7 Cash Flow less WC
-$26.4 $0.0 $0.0 $0.0 $0.0 $0.0 $16.4 CF less WC 5 Yr Run
-$29.3 $0.0 $0.0 $0.0 $0.0 $16.4 CF less WC 5 Yr Run
-$2.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.27 CFPS - Less WC
-$2.20 $0.00 $0.00 $0.00 $0.00 $1.27 CFPS - Less WC
-$2.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.99 CFPS 5 yr Running
-$2.64 $0.00 $0.00 $0.00 $0.00 $0.99 CFPS 5 yr Running
OPM 4.55% 13.94% 15.69% 16.51% 15.74% 10.12% 9.80% 12.06% 6.61% -11.10% 6.59% 9.69% -30.51% <-Total Growth 10 OPM
Increase 206.11% 12.51% 5.28% -4.69% -35.73% -3.09% 23.05% -45.20% -268% -159% 47% Should increase or be stable.
Diff from Median -54.3% 40.0% 57.5% 65.8% 58.0% 1.6% -1.6% 21.1% -33.6% -211.4% -33.8% -2.7% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 9.96% 5 Yrs 6.61% should be zero, it is a check on calculations
Current Assets $30.71 $50.46 $75.19 $127.11 $184.09 $220.67 $235.00 $268.06 $266.29 $216.81 $212.43 $217.22 $222.00 Liquidity ratio of 1.5 and up, best
Current Liabilities $21.82 $45.89 $52.20 $47.39 $120.88 $120.27 $142.11 $111.23 $77.50 $108.21 $113.24 $103.12 $180.35 1.94 <-Median-> 10 Ratio
Liquidity 1.41 1.10 1.44 2.68 1.52 1.83 1.65 2.41 3.44 2.00 1.88 2.11 1.23 2.11 <-Median-> 5 Ratio
Liq. with CF aft div 1.12 1.20 1.29 2.64 1.38 1.57 1.61 2.13 2.77 2.07 2.11 2.41 1.31 2.13 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.49 1.05 0.94 2.20 1.00 1.52 1.41 1.94 2.59 2.03 2.03 2.15 1.31 2.03 <-Median-> 5 Ratio
Assets $145.95 $133.87 $188.07 $249.67 $378.13 $416.56 $444.71 $481.86 $467.04 $242.26 $252.06 $255.24 $271.93 Debt Ratio of 1.5 and up, best
Liabilities $55.25 $46.95 $62.91 $82.22 $190.07 $227.00 $263.43 $314.18 $283.89 $277.63 $290.71 $270.12 $289.43 1.67 <-Median-> 10 Ratio
Debt Ratio 2.64 2.85 2.99 3.04 1.99 1.84 1.69 1.53 1.65 0.87 0.87 0.94 0.94 0.94 <-Median-> 5 Ratio
Total Book Value $90.70 $86.92 $125.16 $167.45 $188.06 $189.56 $181.28 $167.68 $183.16 -$35.37 -$38.65 -$14.88 -$17.50 -117.12% <-Total Growth 10 Book Value
NCI $48.13 $46.26 $46.82 $38.35 $48.92 $44.79 $42.33 $63.55 $52.92 $52.92 $1.31 $1.31 $1.31 -97.18% <-Total Growth 10 NCI
Book Value $42.57 $40.66 $78.34 $129.10 $139.14 $144.76 $138.96 $104.14 $130.24 -$88.29 -$39.95 -$16.19 -$18.81 -$18.81 -$18.81 -139.81% <-Total Growth 10 Book Value
Book Value per share $8.47 $8.09 $9.14 $12.12 $12.32 $11.36 $10.75 $8.00 $7.73 -$5.04 -$2.24 -$0.65 -$0.75 -$0.75 -$0.75 -108.01% <-Total Growth 10 Book Value per Share
Change -4.50% 13.02% 32.56% 1.65% -7.77% -5.39% -25.62% -3.32% -165.13% -55.45% -71.10% 16.19% 0.00% 0.00% -717.53% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.26 1.27 1.29 1.53 1.37 1.28 1.40 1.65 1.39 -0.80 -0.86 -3.06 -5.78 1.29 P/B Ratio Historical Median
P/B Ratio (Close) 1.33 1.23 1.32 1.98 0.97 1.50 1.26 1.65 0.83 -0.17 -0.84 -3.41 -8.22 -8.22 -8.22 #NUM! <-IRR #YR-> 10 Book Value -108.01%
Change -7.39% 7.60% 49.25% -50.65% 53.38% -15.95% 31.37% -49.46% -120.95% 379.55% 306.77% 141.06% 0% 0% #NUM! <-IRR #YR-> 5 Book Value -106.03%
Leverage (A/BK) 1.61 1.54 1.50 1.49 2.01 2.20 2.45 2.87 2.55 -6.85 -6.52 -17.15 -15.54 1.76 <-Median-> 10 A/BV
Debt/Equity Ratio 0.61 0.54 0.50 0.49 1.01 1.20 1.45 1.87 1.55 -7.85 -7.52 -18.15 -16.54 0.76 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.33 5 yr Med -0.80 -717.53% Diff M/C 1.57 Historical Leverage (A/BK)
-$8.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.65
-$10.75 $0.00 $0.00 $0.00 $0.00 -$0.65
-$2.59 <-12 mths -139.49%
Comprehensive Income $13.207 -$16.034 -$221.312 -$3.526 $8.409 -36.33% <-Total Growth 4 Comprehensive Income
NCI $3.685 -$3.925 -$50.161 -$0.784 $1.850
Shareholders $16.080 $17.317 $4.098 $10.302 $9.522 -$12.109 -$171.151 -$2.742 $6.559 -59.21% <-Total Growth 8 Comprehensive Income
Increase 7.69% -76.34% 151.39% -7.57% -227.17% -1313.42% 98.40% 339.20% -7.57% <-Median-> 5 Comprehensive Income
5 Yr Running Average $11 $6 -$32 -$33 -$34 -10.60% <-IRR #YR-> 8 Comprehensive Income -59.21%
ROE 9.6% 9.2% 2.2% 5.7% 5.7% -6.6% 483.9% 7.1% -44.1% -8.63% <-IRR #YR-> 5 Comprehensive Income -36.33%
5Yr Median 7.4% 5.7% 5.7% 5.7% 5.7% 5.7% #NUM! <-IRR #YR-> 4 5 Yr Running Average -396.45%
% Difference from NI 0.1% -3.4% -55.3% -27.8% 4.4% 11.3% -1.0% 11.6% -42.1% #NUM! <-IRR #YR-> 4 5 Yr Running Average -396.45%
Diff 5, 10 yr -1.0% 4.4% 5.7% <-Median-> 5 Return on Equity
-$16.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $6.6
-$10.3 $0.0 $0.0 $0.0 $0.0 $6.6
-$11.5 $0.0 $0.0 $0.0 -$34.0
-$11.5 $0.0 $0.0 $0.0 -$34.0
Current Liability Coverage Ratio 0.19 0.30 0.46 0.58 0.32 0.23 0.20 0.36 0.29 -0.30 0.17 0.31 CFO / Current Liabilities
5 year Median 0.32 0.32 0.32 0.32 0.29 0.23 0.20 0.29 0.29 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 2.87% 10.24% 12.67% 11.04% 10.32% 6.65% 6.40% 8.32% 4.78% -13.19% 7.80% 12.41% CFO / Total Assets
5 year Median 10.32% 10.32% 10.32% 8.32% 6.65% 6.40% 6.40% 7.80% 7.8% <-Median-> 5 Return on Assets
Return on Assets ROA -0.2% 2.8% 5.6% 6.4% 4.7% 2.2% 3.2% 1.9% -2.3% -71.3% -1.0% 4.4% Net Income/Assets Return on Assets
5Yr Median 4.7% 4.7% 4.7% 3.2% 2.2% 1.9% -1.0% -1.0% -1.0% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE -0.3% 4.4% 8.4% 9.6% 9.5% 4.8% 7.9% 5.4% -5.9% 488.6% 6.4% -76.2% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 8.4% 8.4% 7.9% 5.4% 5.4% 6.4% 5.4% 5.4% <-Median-> 5 Return on Equity
$1.09 <-12 mths -90.37%
Net Income $13.09 $19.83 $12.66 -$14.412 -$223.468 -$3.160 $9.463
NCI $3.92 $5.57 $3.531 -$3.528 -$50.649 -$0.702 -$1.873
Shareholders -$0.25 $3.79 $10.48 $16.07 $17.93 $9.17 $14.26 $9.124 -$10.884 -$172.819 -$2.458 $11.336 $4.67 $14.50 $16.80 199.42% <-Total Growth 10 Net Income
Increase -1627% 176.76% 53.34% 11.57% -48.85% 55.52% -36.02% -219.29% 1487.83% -98.58% -561.19% -58.80% 210.49% 15.86% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $9.6 $11.5 $13.6 $13.3 $7.9 -$30.2 -$32.6 -$33.1 -$34.0 -$29.0 $9.0 11.59% <-IRR #YR-> 10 Net Income 199.42%
Oper C. F. non-cash $4.19 $13.71 $23.83 $27.56 $39.04 $27.69 $28.47 $40.09 $22.33 -$31.96 $19.66 $31.69 -4.49% <-IRR #YR-> 5 Net Income -20.50%
Investment Cash Flow -$35.66 -$6.30 -$19.17 -$9.49 -$46.25 -$4.25 -$19.34 -$12.04 -$6.90 -$1.93 -$4.48 -$12.12 #NUM! <-IRR #YR-> 7 5 Yr Running Average -445.15%
Total Accruals $31.22 -$3.62 $5.82 -$2.00 $25.13 -$14.27 $5.13 -$18.93 -$26.32 -$138.93 -$17.64 -$8.23 #NUM! <-IRR #YR-> 5 5 Yr Running Average -344.04%
Total Assets $145.95 $133.87 $188.07 $249.67 $378.13 $416.56 $444.71 $481.86 $467.04 $242.26 $252.06 $255.24 Balance Sheet Assets
Accruals Ratio 21.39% -2.70% 3.10% -0.80% 6.65% -3.42% 1.15% -3.93% -5.64% -57.35% -7.00% -3.23% -5.64% <-Median-> 5 Ratio
EPS/CF Ratio -0.06 0.28 0.47 0.72 0.48 0.35 0.50 0.23 -0.53 5.51 -0.13 0.32 0.41 <-Median-> 10 EPS/CF Ratio
-$3.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $11.3
-$14.3 $0.0 $0.0 $0.0 $0.0 $11.3
-$9.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$33.1
-$13.6 $0.0 $0.0 $0.0 $0.0 -$33.1
Chge in Close 0.00% -11.56% 21.61% 97.85% -49.83% 41.47% -20.48% -2.29% -51.14% -86.36% 113.64% 17.55% 180.09% 0.00% 0.00% Count 12 Years of data
up/down/neutral Down down up up Count 4 33.33%
Any Predictions? Yes Yes Yes % right Count 3 75.00%
Financial Cash Flow $55.43 -$10.53 $26.22 $25.27 $31.91 $15.06 $5.49 $16.77 $8.29 $0.87 -$18.31 -$22.12 C F Statement Financial Cash Flow
Total Accruals -$24.21 $6.91 -$20.40 -$27.27 -$6.77 -$29.33 -$0.36 -$35.70 -$34.61 -$139.80 $0.67 $13.89 Accruals
Accruals Ratio -16.58% 5.16% -10.85% -10.92% -1.79% -7.04% -0.08% -7.41% -7.41% -57.71% 0.27% 5.44% -7.41% <-Median-> 5 Ratio
Cash -$14.03 -$4.64 $23.70 $8.88 $6.94 $3.66 $2.36 $0.00 $8.07 $10.34 $7.97 $7.44 Cash
Cash Per share -$2.79 -$0.54 $2.23 $0.79 $0.54 $0.28 $0.18 $0.00 $0.46 $0.58 $0.32 $0.30 $0.32 <-Median-> 5 Cash per Share
Percentage of Stock Price -28.05% -4.48% 9.29% 6.55% 3.21% 2.09% 1.37% 0.00% 52.28% 30.89% 14.44% 4.81% 14.44% <-Median-> 5 % of Stock Price
Notes
November 20, 2016. Last estimates were for 2015, 2016 and 2017 of $323M, $334M and $348M for Revenue, $0.35, $0.34 and $0.46 for EPS, $0.79, $0.49 and $0.73 for CFPS, $4.42M, $8.98M and $14M for Net Income.
November 22, 2015. Last estimates were for 2014, 2015 and 2016 of $331M, $319M and $534M Revenue, $0.19, $0.40 and $0.39 for EPS, $0.73, $0.75 and $0.66 CFPS, $4.5M, $7.5M and $10M for Net Income.
November 15, 2014. Last Estimates were for 2013, 2014 and 2015 of $334M, 351.1M and $354M for Revenue, -$3.16, $0.50 and $0.52 for EPS, $0.62, $0.86 and $0.96 for CFPS.
October 27, 2013. Last estimates were for 2012 and 2013 of $360M and $397M for revenue, $0.98 and $1.22 for EPS.
Sept 9, 2012. Last estimates were for 2011 and 2012 at $329M and $360M for Revenue and $1.14 and $1.47 for EPS
First half of 2012 issued shares to be used to reduce debt.
May 15, 2011. In setting up this spreadsheet, I am using Cash Flow excluding working capital.
January 3, 2011, change from a partnership of IBI Income Fund (TSX-IBG.UN) to a corporation (TSX-IBG)
Prior to Jan 2011, this company had a partnership set up.
2009. Some 63% of shares issued were for acquitions.
2007. Shares issued 1/2 to (19%) acquisitions and debt repayment.
Firm started 1 Nov 1974. IPO 31 Aug 2004.
Sector
Services, Industrial
What should this stock accomplish?
This stock is more suited for people building a portfolio than people living off their portfolio. Because it is an industrial, dividends are more likely to fluctuate.
Would I buy this company and Why.
Not at the moment as the BV is negative. I would take a look at this stock once the book value became positive.
I think it is a viable company, but it may take some time to recover.
Dividends
As an income trust they had monthly dividends. They were changing to a quarterly dividend in 2013 in a Cycle 3 mode. Cycle 3 is March, June, September and December. They only paid one dividend in 2013.
Why am I following this stock.
I have had this stock on my list to investigate for some time before I finally did in 2011. What finally prompted me set up a spreadsheet on this stock was an investment report I read in March of 2011.
How they make their money.
IBI Group Inc. is an international, multi-disciplinary provider of a range of professional services focused on the physical development of cities.
The Company through IBI Group provides professional services, including planning, design, implementation, analysis of operations and other consulting services in relation to four main areas of development
(urban land, building facilities, transportation networks and systems technology.)
Mainly an engineering infrastructure company.
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.
Copyright 2008 Website of SPBrunner. All rights reserved.
IBI Group Inc. is a TSX listed company, which pays monthly dividends and trades under the symbol "IBG". IBI Group Inc. holds an indirect 72% interest in IBI Group, a partnership (of a subsidiary of
IBI Group Inc. and IBI Group Management Partnership). The remaining 28% of IBI Group is owned by IBI Group Management Partnership. On a partially diluted basis, assuming the exchange of its
partnership units of IBI Group for common shares of IBI Group Inc., IBI Group Management Partnership together with affiliated entities holds a combined 46% interest in IBI Group Inc.
Shares
IBI Group Management Partnership 0.32 1.28%
IBI Group Investment Partnership 3.64 14.60%
IBI Group L.P. 8.57 34.32%
50.19%
IBI Group Management Partnership
Class B Partnership units, exchangeable for common shares 1 for 1 5.03
Subordinate Voting Shares Non-Participating 5.26
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Sep 16 2012 Oct 27 2013 Nov 15 2014 Nov 22 2015 Nov 20 2016
Stewart, Scott 0.053 0.30% 0.083 0.47% 0.110 0.44% 0.256 1.02%
CEO - Shares - Amount $0.046 $0.156 $0.243 $1.584
Options - percentage 0.000 0.00% 0.000 0.00% 0.062 0.25% 0.224 0.90%
Options - amount $0.000 $0.000 $0.137 $1.388
Beinhaker, Philip 0.067 0.40% not avail. not available
CEO - Shares - Amount $0.432
Options - percentage
Options - amount
Taylor, Stephen 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
CFO - Shares - Amount $0.000 $0.000 $0.000 $0.000
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.035 0.14%
Options - amount $0.000 $0.000 $0.000 $0.217
Kresak, Steven Ivan 0.000 0.00%
Officer - Shares - Amount $0.000
Options - percentage 0.010 0.04%
Options - amount $0.062
Kamnitzer, David 0.000 0.00% 0.002 0.01%
Officer - Shares - Amount $0.000 $0.004
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Chow, David 0.049 0.20%
Subsidiary Executives $0.302
Options - percentage 0.010 0.04%
Options - amount $0.062
Baillie, Alistair William 0.020 0.11% 0.000 0.00%
Subsidiary Executives $0.017 $0.000
Options - percentage 0.000 0.00% 0.010 0.04%
Options - amount $0.000 $0.021
Bell, Lorraine Diane 0.010 0.04% 0.014 0.06%
Director - Shares - Amount $0.022 $0.085
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Beinhaker, Philip 0.139 0.79% 0.161 0.90%
Director - Shares - Amount $0.122 $0.302
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Richmond, Dale Elson 0.000 0.00% 0.000 0.00% 0.000 0.00%
Chairman - Shares - Amt $0.000 $0.000 $0.000
Options - percentage 0.071 0.40% 0.197 0.79% 0.231 0.92%
Options - amount $0.134 $0.435 $1.428
IBI Group Management Partnership 5.026 28.66%
Shares - Amt
IBI Group Investment Partnership 5.026 28.66% 3.530 19.82% 3.540 14.18%
Shares - Amt $4.423 $6.637 $7.824
Subsidiary Executives 0.049 0.28% 0.000 0.00%
recent buys Apr to Jun & Sep $0.043 $0.000
Increase in O/S Shares 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Yes 0
due to SO $0.000 $0.000 $0.000 $0.000
Book Value $0.000 $0.000 $0.000 $0.000
Insider Buying -$0.061 -$0.077
Insider Selling $0.000 $0.050
Net Insider Selling $0.082 -$0.061 -$0.027
% of Market Cap 0.25% -0.11% -0.05%
Directors 7 6 7 7
Women 1 14% 2 33% 3 43% 3 43%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 9 5.66% 6 7.04% 1 2.43% 6 3.00%
Total Shares Held 0.938 5.57% 1.211 6.91% 0.433 2.43% 0.934 3.74%
Increase/Decrease 0.052 5.88% -0.076 -5.89% 0.000 0.00% 0.261 38.87%
Starting No. of Shares 0.886 1.287 0.433 0.673