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/ Q1 2017
AGT Food and Ingredients Inc. TSX: AGT OTC: AGXXF www.agtfoods.com 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
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$2,052.7 <-12 mths 4.03%
Revenue* $8.2 $12.1 $79.1 $328.7 $387.9 $642.1 $760.0 $855.3 $1,138.8 $1,356.7 $1,704.5 $1,973.2 $2,124 $2,334 $2,437 16196.70% <-Total Growth 10 Revenue
Increase 47.08% 553.62% 315.30% 18.02% 65.55% 18.35% 12.55% 33.14% 19.14% 25.63% 15.77% 7.64% 9.89% 4.41% 66.42% <-IRR #YR-> 10 Revenue 16196.70%
5 year Running Average $163.2 $290.0 $439.6 $594.8 $756.8 $950.6 $1,163.1 $1,405.7 $1,659.4 $1,898.5 $2,114.5 21.02% <-IRR #YR-> 5 Revenue 159.64%
Revenue per Share $8.23 $9.08 $12.49 $41.16 $22.68 $32.59 $38.53 $43.18 $57.32 $58.83 $71.61 $82.43 $88.73 $97.51 $101.81 36.02% <-IRR #YR-> 7 5 yr Running Average #DIV/0!
Increase 10.31% 37.55% 229.52% -44.90% 43.68% 18.23% 12.08% 32.76% 2.63% 21.73% 15.11% 7.64% 9.89% 4.41% 26.18% <-IRR #YR-> 5 5 yr Running Average 219.80%
5 year Running Average $18.73 $23.60 $29.49 $35.63 $38.86 $46.09 $53.89 $62.68 $71.79 $79.82 $88.42 24.68% <-IRR #YR-> 10 Revenue per Share 807.77%
P/S (Price/Sales) Med 0.61 0.55 0.61 0.30 0.84 0.96 0.65 0.35 0.25 0.39 0.43 0.44 16.43% <-IRR #YR-> 5 Revenue per Share 113.97%
P/S (Price/Sales) Close 0.62 0.55 0.80 0.21 1.32 0.86 0.54 0.30 0.29 0.47 0.47 0.44 0.27 0.24 0.23 18.83% <-IRR #YR-> 7 5 yr Running Average #DIV/0!
*Revenue in M CDN $ P/S 10 yr 0.47 5 yr 0.44 -42.93% Diff M/C 16.28% <-IRR #YR-> 5 5 yr Running Average 112.55%
-$12.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,973.2
-$760.0 $0.0 $0.0 $0.0 $0.0 $1,973.2
-$163.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,405.7
-$439.6 $0.0 $0.0 $0.0 $0.0 $1,405.7
-$9.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $82.4
-$38.5 $0.0 $0.0 $0.0 $0.0 $82.4
-$18.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $62.68
-$29.49 $0.00 $0.00 $0.00 $0.00 $62.68
-$0.52 <-12 mths -159.77%
EPS Basic $0.51 $0.78 $1.07 $3.10 $2.80 $0.98 -$0.43 $0.34 -$0.49 $0.96 $0.69 $0.88 12.82% <-Total Growth 10 EPS Basic
EPS Diluted* $0.51 $0.78 $0.91 $2.91 $2.74 $0.96 -$0.43 $0.34 -$0.49 $0.96 $0.68 $0.87 $1.05 $2.07 $2.87 11.54% <-Total Growth 10 EPS Diluted
Increase 52.94% 16.67% 219.78% -5.84% -64.96% -144.79% -179.07% -244.12% -295.92% -29.17% 27.94% 20.69% 97.14% 38.65% 1.10% <-IRR #YR-> 10 Earnings per Share 11.54%
Earnings Yield 10.0% 15.8% 9.1% 33.8% 9.2% 3.4% -2.1% 2.6% -3.0% 3.5% 2.0% 2.4% 4.4% 8.7% 12.0% #NUM! <-IRR #YR-> 5 Earnings per Share 302.33%
5 year Running Average $1.57 $1.66 $1.42 $1.30 $0.62 $0.27 $0.21 $0.47 $0.61 $1.13 $1.51 -15.78% <-IRR #YR-> 7 5 yr Running Average #DIV/0!
10 year Running Average $0.92 $0.94 $0.95 $0.96 $0.88 $0.89 -19.75% <-IRR #YR-> 5 5 yr Running Average -66.71%
* Diluted ESP per share E/P 10 Yrs 3.01% 5Yrs 2.37%
-$0.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.87
$0.43 $0.00 $0.00 $0.00 $0.00 $0.87
-$1.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.47
-$1.42 $0.00 $0.00 $0.00 $0.00 $0.47
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
Comments original Div? $0.26
Dividend* $0.50 $0.50 $0.51 $0.54 $0.54 $0.54 $0.59 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 21.16% <-Total Growth 10 Dividends
Increase -0.95% 3.11% 6.52% -0.07% -0.65% 8.33% 2.56% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Dividends
Dividends 5 Yr Running $0.52 $0.53 $0.54 $0.56 $0.57 $0.59 $0.60 $0.60 $0.60 $0.60 $0.60 13.93% <-Total Growth 7 Dividends 5 Yr Running
Yield H/L Price 9.89% 9.86% 6.68% 4.40% 2.84% 1.74% 2.33% 3.93% 4.14% 2.63% 1.97% 1.66% 1.98% 2.73% <-Median-> 10 Yield H/L Price
Yield on High Price 9.78% 9.71% 4.86% 3.35% 1.78% 1.54% 1.87% 2.93% 3.48% 2.04% 1.68% 1.47% 1.62% 1.95% <-Median-> 10 Yield on High Price
Yield on Low Price 10.00% 10.00% 10.64% 6.40% 6.91% 1.98% 3.10% 5.97% 5.11% 3.72% 2.36% 1.89% 2.54% 4.41% <-Median-> 10 Yield on Low Price
Yield on Close Price 9.84% 10.00% 5.13% 6.32% 1.82% 1.92% 2.82% 4.59% 3.64% 2.18% 1.77% 1.64% 2.51% 2.51% 2.51% 2.50% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 98.04% 63.49% 56.11% 18.69% 19.84% 56.25% -136.05% 176.47% -122.45% 62.50% 88.24% 68.97% 57.14% 28.99% 20.91% 56.18% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 33.04% 31.73% 38.41% 43.14% 91.94% 218.28% 281.60% 127.12% 97.72% 53.29% 39.79% 67.54% <-Median-> 8 DPR EPS 5 Yr Running
Payout Ratio CFPS 43.40% 92.77% -60.18% -128.81% 37.96% -23.62% -15.56% 26.52% -1729% -45.37% -123.97% 47.85% 23.08% 17.44% 16.67% -34.50% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 140.42% -165.52% -46.28% -101.41% -120.24% -56.91% -89.42% 179.04% 149.04% 54.67% 28.82% -73.17% <-Median-> 8 DPR CF 5 Yr Running
Payout Ratio CFPS WC 43.40% 92.77% 40.03% 15.20% 16.27% 40.54% 25.71% 34.51% 22.75% 14.89% 14.89% 13.17% 23.04% 17.41% 16.64% 19.51% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 26.25% 26.18% 23.07% 22.93% 25.33% 24.35% 20.29% 17.66% 16.80% 16.07% 16.45% 23.71% <-Median-> 8 DPR CF WC 5 Yr Running
Median values 5 Yr Med 5 Yr Cl 2.63% 2.18% 5 Yr Med Payout 68.97% -45.37% 14.89% 1.94% <-IRR #YR-> 10 Dividends 21.16%
* Dividends per share 5 Yr Med and Cur. -4.48% 15.37% Last Div Inc ---> $0.150 $0.150 0.0% 0.51% <-IRR #YR-> 5 Dividends 2.56%
-$0.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.60
-$0.59 $0.00 $0.00 $0.00 $0.00 $0.60
Historical Dividends Historical High Div 10.45% Low Div 1.49% Ave Div 5.97% Med Div 3.38% Close Div 3.23% Historical Dividends
High/Ave/Median Values Curr diff Exp. -75.95% 68.70% Exp. -57.90% Exp. -25.63% Exp. -22.15% High/Ave/Median
Future Dividend Yield Div Yd 2.78% earning in 5.00 Years at IRR of 2.00% Div Inc. 10.41% Future Dividend Yield
Future Dividend Yield Div Yd 3.06% earning in 10 Years at IRR of 2.0% Div Inc. 21.90% Future Dividend Yield
Future Dividend Yield Div Yd 3.38% earning in 15 Years at IRR of 2.0% Div Inc. 34.59% Future Dividend Yield
Yield if held 5 yrs 10.68% 11.64% 7.84% 4.85% 3.13% 1.93% 2.39% 3.93% 4.14% 2.63% 4.85% <-Median-> 7 Paid Median Price
Yield if held 10 yrs 11.87% 11.94% 7.84% 4.85% 3.13% 11.90% <-Median-> 2 Paid Median Price
Yield if held 15 yrs #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 52.09% 54.19% 36.76% 23.18% 15.27% 9.59% 11.96% 19.64% 20.70% 13.16% 23.18% <-Median-> 7 Paid Median Price
Cost covered if held 10 years 111.14% 113.89% 75.98% 47.42% 30.92% 112.52% <-Median-> 2 Paid Median Price
Cost covered if held 15 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham No. $7.27 $9.24 $10.48 $23.70 $28.91 $18.24 $17.23 $10.21 $9.50 $17.37 $15.15 $15.73 $16.94 $23.79 $28.01 70.34% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.70 0.54 0.73 0.52 0.66 1.71 1.46 1.50 1.53 1.31 2.02 2.30 1.79 1.48 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 0.70 0.55 1.00 0.69 1.05 1.92 1.82 2.01 1.81 1.70 2.35 2.59 2.18 1.82 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.69 0.54 0.46 0.36 0.27 1.49 1.09 0.98 1.24 0.93 1.68 2.01 1.39 1.04 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 0.70 0.54 0.95 0.36 1.04 1.54 1.21 1.28 1.73 1.59 2.24 2.33 1.41 1.00 0.85 1.41 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -30.15% -46.40% -5.05% -63.71% 3.55% 54.49% 20.58% 27.93% 73.48% 58.57% 124.40% 132.91% 40.87% 0.33% -14.79% 41.21% <-Median-> 10 Graham Price
Price Close $5.08 $4.95 $9.95 $8.60 $29.94 $28.18 $20.77 $13.06 $16.48 $27.54 $33.99 $36.64 $23.87 $23.87 $23.87 640.20% <-Total Growth 10 Stock Price
Increase 1.60% -2.56% 101.01% -13.57% 248.14% -5.88% -26.30% -37.12% 26.19% 67.11% 23.42% 7.80% -34.85% 0.00% 0.00% 22.16% <-IRR #YR-> 10 Stock Price 640.20%
P/E 9.96 6.35 10.93 2.96 10.93 29.35 -48.30 38.41 -33.63 28.69 49.99 42.11 22.73 11.53 8.32 12.02% <-IRR #YR-> 5 Stock Price 76.41%
Trailing P/E 9.71 12.76 9.45 10.29 10.28 21.64 -30.37 48.47 -56.20 35.41 53.88 27.44 22.73 11.53 27.86% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 5.69% 2.34% % Tot Ret 20.44% 16.31% Price Inc 23.42% P/E: 19.81 38.41 14.36% <-IRR #YR-> 5 Price & Dividend
-$4.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36.64
-$20.77 $0.00 $0.00 $0.00 $0.00 $36.64
-$4.95 $0.51 $0.54 $0.54 $0.54 $0.59 $0.60 $0.60 $0.60 $0.60 $37.24
-$20.77 $0.60 $0.60 $0.60 $0.60 $37.24
Price H/L Median $5.06 $5.03 $7.65 $12.38 $19.16 $31.12 $25.09 $15.28 $14.49 $22.80 $30.53 $36.19 $30.30 620.20% <-Total Growth 10 Stock Price
Increase -0.59% 52.24% 61.76% 54.83% 62.42% -19.38% -39.12% -5.14% 57.35% 33.88% 18.56% -16.28% 21.83% <-IRR #YR-> 10 Stock Price 620.20%
P/E 9.91 6.44 8.41 4.25 6.99 32.42 -58.35 44.93 -29.57 23.75 44.89 41.60 28.86 7.60% <-IRR #YR-> 5 Stock Price 44.24%
Trailing P/E 9.85 9.81 13.60 6.58 11.36 26.14 -35.52 42.62 -46.53 31.80 53.22 34.83 27.48% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 12.20 18.75 17.69 11.71 23.22 85.07 143.99 76.67 49.35 9.68% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 24.81 32.61 38.30 31.60 9.16 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 5.65% 2.08% % Tot Ret 20.56% 21.50% Price Inc 18.56% P/E: 16.08 41.60 Count 12 Years of data
-$5.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36.19
-$25.09 $0.00 $0.00 $0.00 $0.00 $36.19
-$5.03 $0.51 $0.54 $0.54 $0.54 $0.59 $0.60 $0.60 $0.60 $0.60 $36.79
-$25.09 $0.60 $0.60 $0.60 $0.60 $36.79
High Months Aug May Sep Jun Dec Feb Feb Jan Aug Oct Dec May Jan
Price High $5.11 $5.10 $10.50 $16.25 $30.45 $35.00 $31.32 $20.50 $17.24 $29.46 $35.66 $40.71 $37.00 698.24% <-Total Growth 10 Stock Price
Increase -0.20% 105.88% 54.76% 87.38% 14.94% -10.51% -34.55% -15.90% 70.88% 21.05% 14.16% -9.11% 23.09% <-IRR #YR-> 10 Stock Price 698.24%
P/E 10.02 6.54 11.54 5.58 11.11 36.46 -72.84 60.29 -35.18 30.69 52.44 46.79 35.24 5.38% <-IRR #YR-> 5 Stock Price 29.98%
Trailing P/E 10.00 13.46 17.86 10.46 12.77 32.63 -47.67 50.71 -60.12 37.15 59.87 42.53 11.33 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 14.16% P/E: 21.11 46.79 49.05 P/E Ratio Historical High
-$5.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.71
-$31.32 $0.00 $0.00 $0.00 $0.00 $40.71
Low Months Apr Dec May Jan Mar Sep Dec May Apr Jan Sep Jul Jun
Price Low $5.00 $4.95 $4.80 $8.50 $7.87 $27.24 $18.86 $10.05 $11.74 $16.14 $25.39 $31.67 $23.60 539.80% <-Total Growth 10 Stock Price
Increase -1.00% -3.03% 77.08% -7.41% 246.12% -30.76% -46.71% 16.82% 37.48% 57.31% 24.73% -25.48% 20.39% <-IRR #YR-> 10 Stock Price 539.80%
P/E 9.80 6.35 5.27 2.92 2.87 28.38 -43.86 29.56 -23.96 16.81 37.34 36.40 22.48 10.92% <-IRR #YR-> 5 Stock Price 67.92%
Trailing P/E 9.71 6.15 9.34 2.70 9.94 19.65 -23.37 34.53 -32.94 26.45 46.57 27.13 8.08 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 24.73% P/E: 11.04 29.56 -7.86 P/E Ratio Historical Low
-$4.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31.67
Long Term Debt $245.24 $344.34 $548.00 $468.89 Debt
Change 40.41% 59.14% -14.44% 49.78% <-Median-> 2 Change
Debt/Market Cap Ratio 0.39 0.43 0.62 0.82 0.43 <-Median-> 3 Debt/Market Cap Ratio
Goodwill & Intangibles $59.55 $60.78 $65.47 $70.90 $81.42 $72.92 $71.70 Intangibles Goodwill
Change 2.06% 7.72% 8.29% 14.84% -10.45% -1.67% 7.72% <-Median-> 5 Change
Intangible/Market Cap Ratio 0.15 0.23 0.20 0.11 0.10 0.08 0.13 0.13 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $5.08 $6.60 $63.04 $68.67 $512.07 $555.32 $409.71 $258.70 $327.38 $635.13 $809.01 $877.03 $571.37 $571.37 $571.37 13188.42% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 10.945 19.171 19.725 19.974 19.851 20.687 23.425 24.092 24.092 24.092 24.092 #DIV/0! <-Total Growth 7 Diluted
Change 75.16% 2.89% 1.26% -0.62% 4.22% 13.23% 2.85% 0.00% 0.00% 0.00% 2.89% <-Median-> 7 Change
Basic # of Shares in Millions 1.000 1.330 3.440 6.990 10.686 18.867 19.725 19.788 19.851 20.504 23.196 23.896 23.896 23.896 23.896 1696.70% <-Total Growth 10 Basic
Change 33.00% 158.65% 103.20% 52.88% 76.55% 4.55% 0.32% 0.32% 3.29% 13.13% 3.02% 0.00% 0.00% 0.00% 8.84% <-Median-> 10 Change
Difference 0.0% 0.3% 84.2% 14.2% 60.0% 4.4% 0.0% 0.1% 0.1% 12.5% 2.6% 0.2% 3.53% <-Median-> 10 Difference
$36.06 <-12 mths 20.33%
# of Share in Millions 1.000 1.333 6.336 7.985 17.103 19.706 19.726 19.809 19.866 23.062 23.801 23.937 23.937 23.937 23.937 33.48% <-IRR #YR-> 10 Shares 1695.24%
Change 33.33% 375.19% 26.03% 114.18% 15.22% 0.10% 0.42% 0.29% 16.09% 3.21% 0.57% 0.00% 0.00% 0.00% 3.95% <-IRR #YR-> 5 Shares 21.34%
Cash Flow from Operations $M $1.15 $0.71 -$2.92 -$2.95 $15.30 -$43.13 -$74.16 $44.78 -$0.69 -$27.12 -$11.23 $29.97 $62.23 $82.34 $86.17 4120.56% <-Total Growth 10 Cash Flow
Increase -38.37% -511.13% -1.12% 618.39% -381.85% -71.96% 160.38% -101.54% -3835% 59% 367% 107.69% 32.31% 4.65% S. Issued S.O.
5 year Running Average $2.3 -$6.6 -$21.6 -$12.0 -$11.6 -$20.1 -$13.7 $7.1 $10.6 $27.2 $49.9 133.11% <-Total Growth 7 CF 5 Yr Running
CFPS $1.15 $0.53 -$0.85 -$0.42 $1.43 -$2.29 -$3.76 $2.26 -$0.03 -$1.32 -$0.48 $1.25 $2.60 $3.44 $3.60 134.91% <-Total Growth 10 Cash Flow per Share
Increase -53.66% -258.95% 50.24% 439.08% -259.64% -64.48% 160.18% -101.53% -3710% 63% 359% 107.33% 32.31% 4.65% 45.39% <-IRR #YR-> 10 Cash Flow 4120.56%
5 year Running Average $0.37 -$0.32 -$1.18 -$0.55 -$0.48 -$1.03 -$0.67 $0.34 $0.40 $1.10 $2.08 #NUM! <-IRR #YR-> 5 Cash Flow 140.41%
P/CF on Med Price 4.39 9.41 -9.02 -29.31 13.38 -13.61 -6.67 6.75 -417.47 -17.24 -63.07 28.86 8.92% <-IRR #YR-> 10 Cash Flow per Share 134.91%
P/CF on Closing Price 4.41 9.27 -11.73 -20.37 20.91 -12.33 -5.52 5.77 -474.80 -20.83 -70.23 29.22 9.18 6.94 6.63 #NUM! <-IRR #YR-> 5 Cash Flow per Share 133.35%
181.14% Diff M/C -1.38% <-IRR #YR-> 7 CFPS 5 yr Running -9.27%
Excl.Working Capital CF $7.31 $27.97 $20.39 $68.26 $119.05 -$10.37 $53.05 $109.72 $104.70 $78.91 $0.00 $0.00 $0.00 #NUM! <-IRR #YR-> 5 CFPS 5 yr Running 128.48%
CF fr Op $M WC $1.2 $0.7 $4.4 $25.0 $35.7 $25.1 $44.9 $34.4 $52.4 $82.6 $93.5 $108.9 $62.2 $82.3 $86.2 15234.65% <-Total Growth 10 Cash Flow less WC
Increase -38.37% 518.11% 470.00% 42.67% -29.58% 78.61% -23.36% 52.18% 57.77% 13.16% 16.47% -42.84% 32.31% 4.65% 65.41% <-IRR #YR-> 10 Cash Flow less WC 15234.65%
5 year Running Average $13.4 $18.2 $27.0 $33.0 $38.5 $47.9 $61.5 $74.3 $79.9 $85.9 $86.6 19.39% <-IRR #YR-> 5 Cash Flow less WC 142.54%
CFPS Excl. WC $1.15 $0.53 $1.28 $3.58 $3.34 $1.33 $2.28 $1.74 $2.64 $4.03 $4.03 $4.56 $2.60 $3.45 $3.61 27.75% <-IRR #YR-> 7 CF less WC 5 Yr Run 455.20%
Increase -53.66% 138.98% 180.51% -6.68% -60.11% 70.84% -23.60% 51.71% 52.75% 0.02% 13.06% -42.84% 32.31% 4.65% 22.43% <-IRR #YR-> 5 CF less WC 5 Yr Run 175.12%
5 year Running Average $1.98 $2.01 $2.36 $2.45 $2.26 $2.40 $2.94 $3.40 $3.57 $3.73 $3.65 23.91% <-IRR #YR-> 10 CFPS - Less WC 753.49%
P/CF on Med Price 4.39 9.41 6.00 3.46 5.74 23.36 11.02 8.79 5.49 5.66 7.57 7.94 14.89% <-IRR #YR-> 5 CFPS - Less WC 100.20%
P/CF on Closing Price 4.41 9.27 7.80 2.40 8.97 21.15 9.13 7.51 6.25 6.84 8.43 8.04 9.17 6.93 6.62 8.05% <-IRR #YR-> 7 CFPS 5 yr Running 71.98%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr -11.31 5 yr -17.24 P/CF Med 10 yr 6.79 5 yr 7.57 35.07% Diff M/C 7.56% <-IRR #YR-> 5 CFPS 5 yr Running 43.97%
-$0.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.25 Cash Flow per Share
$3.76 $0.00 $0.00 $0.00 $0.00 $1.25 Cash Flow per Share
-$0.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.34 CFPS 5 yr Running
$1.18 $0.00 $0.00 $0.00 $0.00 $0.34 CFPS 5 yr Running
-$0.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $108.9 Cash Flow less WC
-$44.9 $0.0 $0.0 $0.0 $0.0 $108.9 Cash Flow less WC
-$13.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $74.3 CF less WC 5 Yr Run
-$27.0 $0.0 $0.0 $0.0 $0.0 $74.3 CF less WC 5 Yr Run
-$0.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.56 CFPS - Less WC
-$2.28 $0.00 $0.00 $0.00 $0.00 $4.56 CFPS - Less WC
-$1.98 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.40 CFPS 5 yr Running
-$2.36 $0.00 $0.00 $0.00 $0.00 $3.40 CFPS 5 yr Running
OPM 13.99% 5.86% -3.69% -0.90% 3.94% -6.72% -9.76% 5.23% -0.06% -2.00% -0.66% 1.52% -74.10% <-Total Growth 10 OPM
Increase -58.10% -162.90% -75.65% -539% -270% 45.30% -153.65% -101.16% 3203.16% -67.04% -330.58% Should increase or be stable.
Diff from Ave -1898.0% -853.4% 373.9% 15.4% -606.8% 762.9% 1153.7% -772.6% -92.2% 156.8% -15.4% -295.1% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs -0.78% 5 Yrs -0.06% should be zero, it is a check on calculations
Current Assets $2.00 $3.29 $39.22 $87.93 $196.81 $280.04 $419.19 $417.94 $464.30 $603.95 $793.68 $752.47 $663.38 Liquidity ratio of 1.5 and up, best
Current Liabilities $2.18 $3.02 $30.51 $61.13 $121.11 $188.27 $331.82 $351.35 $303.06 $350.91 $565.98 $549.75 $437.34 1.42 <-Median-> 10 Ratio
Liquidity 0.92 1.09 1.29 1.44 1.63 1.49 1.26 1.19 1.53 1.72 1.40 1.37 1.52 1.40 <-Median-> 5 Ratio
Liq. with CF aft div 1.22 1.11 1.16 1.34 1.70 1.41 1.22 1.28 1.47 1.66 1.37 1.40 1.63 1.40 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.28 0.81 0.83 0.92 0.95 1.12 1.06 1.17 1.31 1.51 1.18 1.22 1.63 1.22 <-Median-> 5 Ratio
Excluding Long Term 13.16 5.75 6.06 5.93 5.93 5.93 5.93
Adj Liquidity 1.32 1.21 1.56 1.75 1.42 1.38 1.54 1.42 <-Median-> 5 Ratio
Assets $11.86 $13.11 $74.07 $148.38 $404.42 $527.91 $689.51 $712.49 $773.79 $928.85 $1,296.57 $1,292.30 $1,211.87 Debt Ratio of 1.5 and up, best
Liabilities $7.25 $6.63 $40.09 $79.88 $172.51 $224.38 $418.55 $442.64 $539.45 $606.78 $939.65 $989.68 $920.96 1.63 <-Median-> 10 Ratio
Debt Ratio 1.64 1.98 1.85 1.86 2.34 2.35 1.65 1.61 1.43 1.53 1.38 1.31 1.32 1.43 <-Median-> 5 Ratio
Book Value $4.61 $6.48 $33.98 $68.50 $231.91 $303.54 $270.97 $269.85 $234.34 $322.07 $356.92 $302.62 $290.92 $290.92 $290.92 4570.09% <-Total Growth 10 Book Value
Book Value per share $4.61 $4.86 $5.36 $8.58 $13.56 $15.40 $13.74 $13.62 $11.80 $13.97 $15.00 $12.64 $12.15 $12.15 $12.15 160.14% <-Total Growth 10 Book Value per Share
Change 5.42% 10.35% 59.95% 58.08% 13.60% -10.82% -0.83% -13.41% 18.39% 7.38% -15.69% -3.87% 0.00% 0.00% 27.73% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.10 1.03 1.43 1.44 1.41 2.02 1.83 1.12 1.23 1.63 2.04 2.86 2.49 1.43 P/B Ratio Historical Median
P/B Ratio (Close) 1.10 1.02 1.86 1.00 2.21 1.83 1.51 0.96 1.40 1.97 2.27 2.90 1.96 1.96 1.96 10.03% <-IRR #YR-> 10 Book Value per Share 160.14%
Change -7.57% 82.16% -45.96% 120.23% -17.14% -17.35% -36.60% 45.72% 41.16% 14.94% 27.86% -32.23% 0.00% 0.00% -1.65% <-IRR #YR-> 5 Book Value per Share -7.96%
Leverage (A/BK) 2.57 2.02 2.18 2.17 1.74 1.74 2.54 2.64 3.30 2.88 3.63 4.27 4.17 2.59 <-Median-> 10 A/BV
Debt/Equity Ratio 1.57 1.02 1.18 1.17 0.74 0.74 1.54 1.64 2.30 1.88 2.63 3.27 3.17 1.59 <-Median-> 10 Debt/Eq Ratio
Shareholders' Equity (Assets less Liabilities) P/BV 10 yr Med 1.54 5 yr Med 1.63 27.73% Diff M/C 2.56 Historical 12 Leverage (A/BK)
*Book Value in M CDN $
-$4.86 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.64
-$13.74 $0.00 $0.00 $0.00 $0.00 $12.64
-$66.37 <-12 mths 56.09%
Comprehensive Income $3.70 $22.66 $30.42 $2.05 -$20.97 $8.94 -$24.47 $19.54 $26.92 -$42.52 -1250.70% <-Total Growth 9 Comprehensive Income
Increase 513.28% 34.22% -93.27% -1123.73% 142.62% -373.79% 179.87% 37.75% -257.95% 37.75% <-Median-> 5 Comprehensive Income
5 Yr Running Average $7.57 $8.62 -$0.81 -$2.98 $1.99 -$2.32 #NUM! <-IRR #YR-> 9 Comprehensive Income #DIV/0!
ROE 10.9% 33.1% 13.1% 0.7% -7.7% 3.3% -10.4% 6.1% 7.5% -14.1% 15.19% <-IRR #YR-> 5 Comprehensive Income -102.80%
5Yr Median 10.9% 3.3% 0.7% 0.7% 3.3% 3.3% #NUM! <-IRR #YR-> 5 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% 0.0% 1.6% -88.9% 147.8% 31.2% 151.8% -1.1% 67.8% -302.0% #NUM! <-IRR #YR-> 5 5 Yr Running Average -130.61%
Median Values Diff 5, 10 yr 0.8% 31.2% 3.3% <-Median-> 5 Return on Equity
-$3.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$42.5
$21.0 $0.0 $0.0 $0.0 $0.0 -$42.5
-$7.6 $0.0 $0.0 $0.0 $0.0 -$2.3
-$7.6 $0.0 $0.0 $0.0 $0.0 -$2.3
Current Liability Coverage Ratio 0.53 0.24 0.14 0.41 0.29 0.13 0.14 0.10 0.17 0.24 0.17 0.20 CFO less WC CFO / Current Liabilities
5 year Median 0.29 0.24 0.14 0.14 0.14 0.14 0.17 0.17 0.17 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 9.71% 5.42% 5.92% 16.86% 8.82% 4.76% 6.51% 4.83% 6.77% 8.89% 7.21% 8.42% CFO less WC CFO / Total Assets
5 year Median 8.82% 5.92% 6.51% 6.51% 6.51% 6.51% 6.77% 7.21% 7.2% <-Median-> 5 Return on Assets
Return on Assets ROA 4.0% 7.0% 5.0% 15.3% 7.4% 3.5% -1.2% 1.0% -1.3% 2.1% 1.2% 1.6% Net Income/Assets Return on Assets
5Yr Median 7.0% 7.0% 5.0% 3.5% 1.0% 1.0% 1.0% 1.2% 1.9% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 10.4% 14.1% 10.9% 33.1% 12.9% 6.1% -3.1% 2.5% -4.1% 6.1% 4.5% 7.0% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 10.4% 12.2% 10.9% 12.5% 12.9% 12.9% 10.9% 6.1% 2.5% 2.5% 2.5% 4.5% 6.1% <-Median-> 10 Return on Equity
-$11.40 <-12 mths -154.14%
Net Income $0.48 $0.91 $3.70 $22.66 $29.94 $18.40 -$8.46 $6.81 -$9.72 $19.76 $16.05 $21.05 $31.1 $56.2 2208.44% <-Total Growth 10 Net Income
Increase 90.00% 305.17% 513.28% 32.12% -38.54% -145.98% 180.51% -242.62% 303.39% -18.80% 31.21% 47.72% 80.71% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $11.5 $15.1 $13.2 $13.9 $7.4 $5.4 $4.9 $10.8 $15.6 $28.8 36.88% <-IRR #YR-> 10 Net Income 2208.44%
Operating Cash Flow $1.15 $0.71 -$2.92 -$2.95 $15.30 -$43.13 -$74.16 $44.78 -$0.69 -$27.12 -$11.23 $29.97 #NUM! <-IRR #YR-> 5 Net Income 348.84%
Investment Cash Flow -$7.25 -$1.13 -$13.50 -$30.33 -$97.02 -$50.93 -$51.31 -$34.57 -$38.77 -$34.08 -$95.11 -$79.34 -0.95% <-IRR #YR-> 7 5 Yr Running Average #DIV/0!
Total Accruals $6.58 $1.33 $20.11 $55.95 $111.66 $112.45 $117.01 -$3.39 $29.75 $80.96 $122.39 $70.42 -4.02% <-IRR #YR-> 5 5 Yr Running Average -18.55%
Total Assets $11.86 $13.11 $74.07 $148.38 $404.42 $527.91 $689.51 $712.49 $773.79 $928.85 $1,296.57 $1,292.30 Balance Sheet Assets
Accruals Ratio 55.45% 10.16% 27.15% 37.70% 27.61% 21.30% 16.97% -0.48% 3.84% 8.72% 9.44% 5.45% 5.45% <-Median-> 5 Ratio
EPS/CF Ratio 0.44 1.46 0.71 0.81 0.82 0.72 -0.19 0.20 -0.19 0.24 0.17 0.19 0.22 <-Median-> 10 EPS/CF Ratio
-$0.91 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21.05
$8.46 $0.00 $0.00 $0.00 $0.00 $21.05
-$11.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.79
-$13.25 $0.00 $0.00 $0.00 $0.00 $10.79
Chge in Close 1.60% -2.56% 101.01% -13.57% 248.14% -5.88% -26.30% -37.12% 26.19% 67.11% 23.42% 7.80% -34.85% 0.00% 0.00% Count 13 Years of data
up/down/neutral Down Down Down Down Down Down Down Down Down Down Count 10 76.92%
Any Predictions? yes yes yes yes yes % right Count 5 50.00%
Financial Cash Flow $5.09 $0.42 $16.42 $33.28 $81.72 $108.80 $161.12 -$33.69 $29.10 $67.89 $95.12 $56.78 C F Statement Financial CF
Total Accruals $1.49 $0.91 $3.70 $22.66 $29.94 $3.65 -$44.11 $30.30 $0.65 $13.07 $27.26 $13.64 Accruals
Accruals Ratio 12.53% 6.96% 4.99% 15.27% 7.40% 0.69% -6.40% 4.25% 0.08% 1.41% 2.10% 1.06% 1.41% <-Median-> 5 Ratio
Cash $10.12 $23.63 $52.22 $33.11 $22.89 $29.32 $22.31 $29.03 $19.11 Cash
Cash per Share $0.59 $1.20 $2.65 $1.67 $1.15 $1.27 $0.94 $1.21 $0.80 $1.21 <-Median-> 5 Cash per Share
Percentage of Stock Price 1.98% 4.25% 12.75% 12.80% 6.99% 4.62% 2.76% 3.31% 3.34% 4.62% <-Median-> 5 % of Stock Price
Notes:
June 25, 2017. Last estimates were for 2016 and 2017 of $1810M and $1948M for Revenue, $2.70 and $2.75 for EPS, $3.53 and $4.03 for CFPS and $70.8M and $65.3M for Net Income.
June 19, 2016. Last estimates were for 2015 and 2016 of $1507M and $1642M for Revenue, $1.42 and $2.26 for EPS, $2.43 and $3.11 for CFPS and $30.4M and $51.3M for Net Income.
July 1, 2015. Last estimates were for $2014, 2015 and 2016 of $1248.5M, $1348.4M and $1469M for Revenue, $1.24 and $1.61 for 2014 and 2015 for EPS,
$2.00 and $2.49 for CFPS for 2014 and 2015 and $28.6M and $31.3M for Net Income.
October 2014. Name has changed from Alliance Grain Traders Inc. to AGT Food and Ingredients Inc. Symbol remains AGT.
June 27, 2014. Last esttimates were for 2013, 2014 and 2015 of $1201M, 1072M and 1245M for Revenue, $1.05 and $1.39 for 2013 and 2014 EPS, $2.02, $2.33 and $2.77 for CFPS
July 5, 2013. Last estimates were for 2012 and 2013 of $862.3M and $911.3M for Revenues, $0.68 and $1.55 for EPS.
October 27, 2012. Last estimates were for 2011 and 2012 of $734M and $804M for revenue, $1.71 and $2.42 for EPS.
Sept 7, 2011. Last I looked I got EPS of $3.00 and $3.30 for 2010 and 2011.
When I last looked at got 2010 and 2011 estimates for earnings of $3.12 and $3.75. One analysts does not think that this company can grow dividends.
May 14, 2010. I last got estimates for 2009 and 2010 of $2.44 and $2.86.
Dec 3, 2009. I have annualized the figures for 2005. This site only has financials for a limited period, so I also used Google Financial.
Sep 2009. It was Alliance Grain Traders Income Fund (TSX-AGT.UN). It was converted to a corporation on September 15, 2009.
This company was formerly, the Agtech Income Fund. The Fund was a limited purpose open-ended trust established on June 25, 2004.
A lot of the increase in shares was because of selling of more shares or units (2006-2009). Some as for purchase of Arbel Group and other acquisitions.
I got the name of this stock from the Money Show in 2009.
Some of the information on financials is from G&M financials.
Sector:
Consumer Staple, Consumer Sector
What should this stock accomplish?
I would think you could expect low to moderate dividends and some capital gains.
Would I buy this company and Why.
Not until it shows signs about being a dividend growth company.
Why am I following this stock.
I wanted to review all the income trust stocks touted in the 2009 Money Show. There was a lot of talk at this show about some of the Unit Trust being currently good buys with very good yield.
This stock converted to a corporation in 2009.
Dividends
Dividends are paid in Cycle 1, which is January, April, July and September. Dividends are declared in one month and paid in the next month.
For example, The dividend declared for shareholders of record of June 30, 2014 is payable on July 15, 2014 and covers the period of April 1, 2014 to June 30, 2014.
Why am I following this stock.
I wanted to review all the income trust stocks touted in the 2009 Money Show. There was a lot of talk at this show about some of the Unit Trust being currently good buys with very good yield.
This stock converted to a corporation in 2009.
How they make their money.
AGT Food and Ingredients is one of the largest suppliers of value-added pulses, staple foods and food ingredients in the world. They buy lentils, peas, beans and chickpeas from farmers
around their 34 facilities located in the best pulse growing regions in Canada, the United States, Turkey, Australia, China and South Africa and ship their products to over 100 countries around the globe.
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.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Oct 27 2012 Jul 07 2013 Jun 27 2014 Jul 4 2015 Jun 19 2016 Jun 25 2017
Al-Katib, Murad 0.40 2.00% 5.49 27.62% 3.737 16.21% 3.744 15.73% 3.847 16.07% 4.054 16.94% Seens to have bought
CEO - Shares - Amount $5.176 $90.429 $102.931 $127.244 $140.954 $96.775 shares in June when
Options - percentage 0.20 1.01% 0.100 0.43% 0.100 0.42% 0.100 0.42% 0.000 0.00% Arslan sold his.
Options - amount $3.296 $2.754 $3.399 $3.664 $0.000
Ireland, Lori Ann 0.02 0.10% 0.053 0.23% 0.021 0.09% 0.044 0.19% 0.062 0.26%
CFO - Shares - Amount $0.314 $1.469 $0.701 $1.628 $1.477
Options - percentage 0.08 0.42% 0.050 0.22% 0.050 0.21% 0.017 0.07% 0.000 0.00%
Options - amount $1.376 $1.377 $1.700 $0.611 $0.000
Bourassa, Gaetan Michael 0.04 0.20% 0.092 0.40% 0.045 0.19% 0.047 0.20% 0.049 0.21% Only one
Officer - Shares - Amount $0.647 $2.525 $1.515 $1.739 $1.180
Options - percentage 0.13 0.63% 0.075 0.33% 0.070 0.29% 0.025 0.10% 0.000 0.00%
Options - amount $2.060 $2.066 $2.379 $0.916 $0.000
Franklin, Drew 0.000 0.00% 0.007 0.03% 0.015 0.06% 0.024 0.10%
Director - Shares - Amount $0.000 $0.238 $0.562 $0.565
Options - percentage 0.025 0.11% 0.017 0.07% 0.008 0.03% 0.000 0.00%
Options - amount $0.689 $0.567 $0.305 $0.000
Gardner, John Michael 0.00 0.01% 0.003 0.01% 0.020 0.08% 0.028 0.12%
Director - Shares - Amount $0.016 $0.100 $0.719 $0.667
Options - percentage 0.03 0.13% 0.025 0.11% 0.008 0.03% 0.000 0.00%
Options - amount $0.412 $0.850 $0.305 $0.000
Arsenault, Denis 0.01 0.04%
Director - Shares - Amount $0.132
Options - percentage 0.00 0.00%
Options - amount $0.000
Arslan, Huseyin 2.43 12.29% 0.00 0.00% 0.100 0.43% 0.100 0.42% 0.000 0.00% 0.000 0.00% has no shares or stock '17
Chairman - Shares - Amt $31.798 $0.000 $2.754 $3.399 $0.000 $0.000
Options - percentage 0.20 1.01% 0.100 0.43% 0.100 0.42% 0.100 0.42% 0.000 0.00%
Options - amount $3.296 $2.754 $3.399 $3.664 $0.000
Mahmut Arslan 1.99 10.02%
10% owner $32.789
Sold in June 2013
The Carme Trust 3.31 16.72% 5.18 26.09% 3.313 13.92% 3.313 13.92% Mr. Murad Al-Katib, the
10% owner $43.263 $85.409 $112.595 $112.595 is the sole trustee of the
Bought in June 2013 Dated 2014 Trust and therefore has
voting control over the
Shares owned by Trust.
Increase in O/S Shares 0.000 0.00% 0.057 0.29% 0.339 1.47% 0.017 0.07% 0.103 0.43%
due to SO 2013 $0 $0.934 $9.322 $0.566 $3.786
Book Value $0 $0.564 $3.384 $0.267 $1.658
Insider Buying -$0.281 -$0.266 -$0.722
Insider Selling $3.293 $2.086 $0.752
Net Insider Selling $0.000 $3.013 $1.820 $0.030
% of Market Cap 0.00% 0.37% 0.21% 0.01%
Directors 5 5 5 7 7
Women 0 0% 0 0% 0 0% 1 14% 1 14%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 36 24.16% 35 21.95% 52 34.25% 57 35.79%
Total Shares Held 11.694 58.87% 4.881 24.57% 5.065 21.28% 8.196 34.24% 8.570 35.80%
Increase/Decrease 0.456 4.05% 0.429 9.63% -0.018 -0.36% -0.537 -6.15% -0.196 -2.24%
Starting No. of Shares 11.238 4.452 5.083 8.733 8.766
Copyright 2008 Website of SPBrunner. All rights reserved.