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/
Allied Properties Real Estate Investment Trust TSX: AP.UN OTC: APYRF http://alliedreit.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 Accounting Rules
Revenue* $51.6 $65.2 $106.9 $132.5 $152.8 $184.5 $196.5 $258.4 $302.0 $337.7 $365.4 $389.7 $413 $448 497.38% <-Total Growth 10 Revenue
Increase 184.47% 26.45% 63.87% 23.91% 15.35% 20.72% 6.52% 31.50% 16.89% 11.81% 8.20% 6.66% 5.97% 8.47% 19.57% <-IRR #YR-> 10 Revenue
5 year Running Average $52.0 $74.9 $101.8 $128.4 $154.6 $184.9 $218.8 $256 $292 $331 $361.6 $390.8 14.68% <-IRR #YR-> 5 Revenue
Revenue per Share $3.22 $3.24 $4.26 $4.24 $3.91 $4.38 $3.79 $4.03 $4.41 $4.50 $4.66 $4.60 $4.87 $5.29 22.83% <-IRR #YR-> 9 5 yr Running Average
Increase 84.44% 0.63% 31.37% -0.39% -7.71% 11.87% -13.36% 6.28% 9.30% 2.09% 3.56% -1.28% 5.97% 8.47% 16.42% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average $3.00 $3.34 $3.77 $4.01 $4.12 $4.07 $4.10 $4.22 $4.28 $4.44 $4.61 $4.78 3.56% <-IRR #YR-> 10 Revenue per Share
P/S (Price/Sales) Med 4.91 6.20 5.14 3.83 4.04 4.73 6.14 7.16 7.37 7.81 7.74 7.49 7.13 3.93% <-IRR #YR-> 5 Revenue per Share
P/S (Price/Sales) Close 5.26 7.17 4.87 2.94 4.94 4.92 6.66 8.19 7.43 8.32 6.78 7.82 7.31 4.46% <-IRR #YR-> 9 5 yr Running Average
*Total Revenue in M CDN $ P/S Med 10 yr 6.65 5 yr 7.49 9.98% Diff M/C 1.52% <-IRR #YR-> 5 5 yr Running Average
-$65.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $389.7
-$196.5 $0.0 $0.0 $0.0 $0.0 $389.7
-$52.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $330.7
-$154.6 $0.0 $0.0 $0.0 $0.0 $330.7
-$3.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.60
-$3.79 $0.00 $0.00 $0.00 $0.00 $4.60
-$3.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.44
-$4.12 $0.00 $0.00 $0.00 $0.00 $4.44
AFFO* $1.24 $1.24 $1.49 $1.51 $1.52 $1.21 $1.07 $1.43 $1.66 $1.83 $1.81 $1.76 $1.87 $2.14 42.05% <-Total Growth 10 AFFO
Increase 0.08% 20.02% 1.55% 0.66% -20.39% -11.57% 33.64% 16% 10.24% -1.09% -2.76% 6.25% 14.44% 3.57% <-IRR #YR-> 10 AFFO
AFFO Yield 7.3% 5.3% 7.2% 12.1% 7.9% 5.6% 4.2% 4.3% 5.1% 4.9% 5.7% 4.9% 5.2% 6.0% 10.47% <-IRR #YR-> 5 AFFO
5 year Running Average $1.09 $1.40 $1.39 $1.36 $1.35 $1.38 $1.44 $1.56 $1.70 $1.79 $1.88 5.64% <-IRR #YR-> 8 5 yr Running Average
Payout Ratio 94.50% 97.66% 84.06% 86.42% 86.84% 109.09% 123.36% 95.08% 84.94% 77.05% 80.62% 86.93% 81.82% 71.50% 4.55% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average 109.15% 89.43% 91.95% 95.85% 98.29% 97.67% 94.72% 89.22% 84.44% 82.19% 79.27% 94.72% <-Median-> 9 Payout 5 year Running Average
Price/AFFO Median 12.77 16.22 14.70 10.75 10.39 17.13 21.76 20.20 19.55 19.20 19.92 19.59 18.57 0.04 19.38 <-Median-> 10 P/AFFO Med
Price/AFFO High 14.42 18.77 16.04 14.61 12.99 18.98 23.73 22.60 21.30 20.88 22.77 22.51 19.30 0.00 21.09 <-Median-> 10 P/AFFO High
Price/AFFO Low 11.11 13.68 13.37 6.89 7.79 15.27 19.79 17.79 17.81 17.52 17.07 16.66 17.85 0.00 16.87 <-Median-> 10 P/AFFO Low
Price/AFFO Close 13.69 18.77 13.95 8.25 12.72 17.80 23.63 23.08 19.73 20.46 17.44 20.43 19.06 16.66 18.77 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 18.78 16.74 8.37 12.81 14.17 20.89 30.84 22.91 22.55 17.25 19.86 20.26 19.06 18.56 <-Median-> 10 Trailing P/AFFO Close
* Adjusted Funds From Operations DPR 10 Yrs 86.63% 5 Yrs 84.94% P/CF 5 Yrs in order 19.59 22.51 17.52 20.43 -2.66% Diff M/C -1.61% Diff M/C 10 DPR 75% to 95% best
FFO* $1.36 $1.41 $1.66 $1.68 $1.73 $1.63 $1.39 $1.79 $1.94 $2.10 $2.17 $2.15 $2.22 $2.51 52.05% <-Total Growth 10 FFO
Increase 2.87% 3.74% 17.11% 1.45% 2.98% -5.78% -14.72% 28.78% 8.38% 8.25% 3.33% -0.92% 3.26% 13.06% 4.28% <-IRR #YR-> 10 FFO
FFO Yield 8.0% 6.1% 8.0% 13.5% 8.9% 7.6% 5.5% 5.4% 5.9% 5.6% 6.9% 6.0% 6.2% 7.0% 9.12% <-IRR #YR-> 5 FFO
5 year Running Average $1.38 $1.49 $1.57 $1.62 $1.62 $1.64 $1.70 $1.77 $1.88 $2.03 $2.12 $2.23 4.42% <-IRR #YR-> 9 5 yr Running Average
Payout Ratio 85.84% 85.57% 75.48% 77.68% 76.30% 80.98% 94.96% 75.96% 72.68% 67.14% 67.24% 71.16% 68.92% 60.96% 4.65% <-IRR #YR-> 5 5 yr Running Average
5 year Running Average 79.87% 80.33% 79.75% 78.98% 80.57% 80.59% 79.36% 77.06% 74.11% 70.63% 69.37% 66.90% 79.56% <-Median-> 10 Payout 5 year Running Average
Price/FFO Median 11.60 14.21 13.20 9.66 9.13 12.71 16.75 16.13 16.73 16.73 16.62 16.03 15.65 0.03 16.08 <-Median-> 10 P/FFO Med
Price/FFO High 13.10 16.44 14.40 13.13 11.42 14.09 18.27 18.06 18.22 18.20 18.99 18.43 16.26 0.00 18.13 <-Median-> 10 P/FFO High
Price/FFO Low 10.10 11.99 12.00 6.19 6.84 11.34 15.24 14.21 15.24 15.27 14.24 13.64 15.04 0.00 13.92 <-Median-> 10 P/FFO Low
Price/FFO Close 12.44 16.44 12.52 7.41 11.18 13.21 18.19 18.44 16.89 17.83 14.55 16.72 16.06 14.20 15.63 <-Median-> 10 P/FFO Close
Trailing P/FFO Close 10.38 12.44 14.06 6.28 7.05 10.68 12.99 18.30 16.51 16.53 14.71 13.51 15.53 0.00 13.79 <-Median-> 10 Trailing P/FFO Close
* Funds From Operations DPR 10 Yrs 75.72% 5 Yrs 71.16% P/CF 5 Yrs in order 16.62 18.22 14.24 16.89 -3.35% Diff M/C -0.15% Diff M/C 10 DPR 75% to 95% best
EPS Basic $0.10 $0.46 $0.25 $0.43 $0.50 $0.47 $3.37 $6.55 $3.54 $2.14 $3.28 $4.01 764.22% <-Total Growth 10 EPS Basic
EPS Diluted* $0.10 $0.46 $0.25 $0.42 $0.49 $0.46 $3.33 $6.48 $3.51 $2.13 $3.27 $4.01 $2.33 $2.74 781.32% <-Total Growth 10 EPS Diluted
Increase -88.79% 364.29% -46.15% 71.43% 16.67% -6.12% 623.13% 94.66% -45.79% -39.32% 53.52% 22.63% -41.90% 17.60% 24.31% <-IRR #YR-> 10 Earnings per Share
Earnings Yield 0.58% 1.96% 1.18% 3.37% 2.53% 2.14% 13.16% 19.62% 10.71% 5.69% 10.36% 11.15% 6.54% 7.69% 3.81% <-IRR #YR-> 5 Earnings per Share
5 year Running Average $0.54 $0.42 $0.34 $0.41 $0.99 $2.23 $2.85 $3.18 $3.74 $3.88 $3.05 $2.90 24.41% <-IRR #YR-> 9 5 yr Running Average
10 year Running Average $1.39 $1.64 $1.76 $2.08 $2.43 $2.64 $2.87 31.45% <-IRR #YR-> 5 5 yr Running Average
* Diluted ESP per share E/P 10 Yrs 8.02% 5Yrs 10.71%
-$0.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.01
-$3.33 $0.00 $0.00 $0.00 $0.00 $4.01
-$0.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.88
-$0.99 $0.00 $0.00 $0.00 $0.00 $3.88
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.17 $1.21 $1.25 $1.31 $1.32 $1.32 $1.32 $1.36 $1.41 $1.41 $1.46 $1.53 $1.53 $1.53 $1.53 26.44% <-Total Growth 10 Dividend*
Increase 12.50% 3.42% 3.30% 4.40% 1.15% 0.00% 0.00% 3.00% 3.71% 0.00% 3.49% 4.85% 0.00% 0.00% 0.00% Count 14 Years of data
5 year running Average $1.10 $1.19 $1.25 $1.28 $1.30 $1.32 $1.35 $1.36 $1.39 $1.43 $1.47 $1.49 $1.52 $1.31 <-Median-> 10 5 year running Average
Yield H/L Price 7.40% 6.02% 5.72% 8.04% 8.36% 6.37% 5.67% 4.71% 4.34% 4.01% 4.05% 4.44% 4.40% 5.19% <-Median-> 10 Yield H/L Price
Yield on High Price 6.55% 5.20% 5.24% 5.92% 6.68% 5.75% 5.20% 4.21% 3.99% 3.69% 3.54% 3.86% 4.24% 4.70% <-Median-> 10 Yield on High Price
Yield on Low Price 8.50% 7.14% 6.29% 12.55% 11.15% 7.14% 6.23% 5.34% 4.77% 4.40% 4.72% 5.22% 4.58% 5.79% <-Median-> 10 Yield on Low Price
Yield on Close Price 6.90% 5.20% 6.03% 10.48% 6.83% 6.13% 5.22% 4.12% 4.30% 3.77% 4.62% 4.26% 4.29% 4.29% 3.99% 4.92% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 1193.85% 265.94% 510.21% 310.71% 269.39% 286.96% 39.68% 21.00% 40.17% 66.20% 44.62% 38.15% 65.67% 55.84% #DIV/0! 55.41% <-Median-> 10 Payout Ratio EPS
DPR EPS 5 Yr Running 202.24% 285.61% 366.22% 309.42% 131.85% 59.30% 47.19% 42.89% 37.19% 36.96% 48.13% 51.51% #DIV/0! 95.57% <-Median-> 6 DPR EPS 5 Yr Running
Payout Ratio CFPS 238.47% 93.37% 188.00% 77.80% 81.78% 90.58% 87.32% 77.91% 78.71% 83.84% 60.46% 68.49% 68.49% #VALUE! #DIV/0! 80.25% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 115.61% 109.72% 108.92% 95.46% 94.08% 82.75% 82.88% 83.30% 76.11% 72.66% 74.39% #VALUE! #DIV/0! 88.69% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 155.42% 98.88% 75.72% 78.37% 88.57% 85.20% 97.97% 86.18% 73.42% 71.28% 71.76% 66.85% 66.85% #VALUE! #DIV/0! 77.04% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 94.94% 92.28% 92.22% 84.51% 84.58% 86.83% 85.35% 81.45% 78.57% 73.17% 69.84% #VALUE! #DIV/0! 84.96% <-Median-> 6 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 4.34% 4.26% 5 Yr Med Payout 40.17% 77.91% 71.76% 2.37% <-IRR #YR-> 10 Dividends
* Dividends per share 5 Yr Med and Cur. -1.21% 0.84% Last Div Inc ---> $0.1250 $0.1275 2.0% 3.00% <-IRR #YR-> 5 Dividends
-$1.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.53
-$1.32 $0.00 $0.00 $0.00 $0.00 $1.53
Historical Dividends Historical High Div 11.85% Low Div 3.62% Ave Div 7.74% Med Div 5.87% Close Div 5.62% Historical Dividends
High/Ave/Median Values Curr diff Exp. -63.78% Exp 18.56% Exp. -44.52% Exp. -26.89% Exp. -23.69% High/Ave/Median
Future Dividend Yield Div Yd 4.58% earning in 5 Years at IRR of 1.30% Div Inc. 6.67% Future Dividend Yield
Future Dividend Yield Div Yd 4.88% earning in 10 Years at IRR of 1.30% Div Inc. 13.79% Future Dividend Yield
Future Dividend Yield Div Yd 5.21% earning in 15 Years at IRR of 1.30% Div Inc. 21.38% Future Dividend Yield
Yield if held 5 yrs 11.81% 10.59% 8.35% 6.57% 6.22% 8.69% 8.93% 7.04% 6.57% 5.30% 4.71% 4.35% 8.35% <-Median-> 9 Paid Median Price
Yield if held 10 yrs 12.76% 11.31% 9.23% 7.61% 7.00% 9.43% 9.69% 10.27% <-Median-> 4 Paid Median Price
Yield if held 15 yrs 13.85% 12.27% #NUM! <-Median-> 0 Paid Median Price
Yield if held 20 yrs #DIV/0! #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 54.07% 50.18% 40.53% 32.41% 30.30% 41.46% 43.18% 33.58% 30.79% 25.41% 22.98% 21.57% 40.53% <-Median-> 9 Paid Median Price
Cost covered if held 10 years 114.97% 104.89% 84.55% 68.08% 63.86% 87.42% 91.16% 94.72% <-Median-> 4 Paid Median Price
Cost covered if held 15 years 182.48% 165.69% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham No. FFO $17.33 $18.46 $20.74 $21.60 $21.91 $21.07 $26.25 $33.42 $36.30 $38.30 $40.17 $41.53 $42.20 $44.87 $0.00 124.94% <-Total Growth 10 Graham Price
Price/GP Ratio Med 0.91 1.09 1.05 0.75 0.72 0.98 0.89 0.86 0.89 0.92 0.90 0.83 0.82 0.89 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.03 1.26 1.15 1.02 0.90 1.09 0.97 0.97 0.97 1.00 1.03 0.95 0.86 0.99 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.79 0.92 0.96 0.48 0.54 0.88 0.81 0.76 0.81 0.84 0.77 0.71 0.79 0.79 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 0.98 1.26 1.00 0.58 0.88 1.02 0.96 0.99 0.90 0.98 0.79 0.87 0.84 0.79 #DIV/0! 0.93 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -2.16% 25.92% 0.02% -42.37% -11.73% 2.23% -3.71% -1.27% -9.74% -2.23% -21.40% -13.44% -15.53% -20.56% #DIV/0! -6.73% <-Median-> 10 Graham Price
Graham No. $4.65 $10.47 $7.98 $10.80 $11.66 $11.19 $40.61 $63.57 $48.82 $38.57 $49.31 $56.72 $43.24 $46.89 $0.00 441.54% <-Total Growth 10 Graham Price
Price/GP Ratio Med 3.40 1.92 2.74 1.50 1.35 1.85 0.57 0.45 0.66 0.91 0.73 0.61 0.80 0.82 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 3.84 2.22 2.99 2.04 1.69 2.05 0.63 0.51 0.72 0.99 0.84 0.70 0.83 0.91 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 2.96 1.62 2.49 0.96 1.02 1.65 0.52 0.40 0.61 0.83 0.63 0.52 0.77 0.73 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 3.65 2.22 2.60 1.15 1.66 1.92 0.62 0.52 0.67 0.97 0.64 0.63 0.82 0.76 #DIV/0! 0.82 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 264.86% 121.98% 160.04% 15.26% 65.85% 92.44% -37.76% -48.09% -32.90% -2.93% -35.97% -36.62% -17.54% -23.96% #DIV/0! -17.91% <-Median-> 10 Graham Price
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
Price Close $16.95 $23.25 $20.74 $12.45 $19.34 $21.54 $25.28 $33.00 $32.76 $37.44 $31.57 $35.95 $35.65 $35.65 $38.35 54.62% <-Total Growth 10 Stock Price
Increase 22.83% 37.17% -10.80% -39.97% 55.34% 11.38% 17.36% 30.54% -0.73% 14.29% -15.68% 13.87% -0.83% 0.00% 7.57% 4.45% <-IRR #YR-> 10 Stock Price
P/E Ratio 172.96 51.10 84.65 29.64 39.47 46.83 7.60 5.10 9.33 17.58 9.65 8.97 15.30 13.01 #DIV/0! 7.30% <-IRR #YR-> 5 Stock Price
Trailing P/E Ratio 19.39 237.24 45.58 50.82 46.05 43.96 54.96 9.92 5.06 10.67 14.82 10.99 8.89 15.30 14.00 9.34% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D. per yr 4.89% 4.95% % Tot Ret 52.32% 40.43% T P/E 10.67 P/E: 13.62 9.33 12.25% <-IRR #YR-> 5 Price & Dividend
-$23.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $35.95
-$25.28 $0.00 $0.00 $0.00 $0.00 $35.95
-$23.25 $1.25 $1.31 $1.32 $1.32 $1.32 $1.36 $1.41 $1.41 $1.46 $37.48
-$25.28 $1.36 $1.41 $1.41 $1.46 $37.48
Price H/L Median $15.81 $20.10 $21.87 $16.23 $15.80 $20.73 $23.29 $28.88 $32.46 $35.14 $36.06 $34.47 $34.74 7.57% 71.49% <-Total Growth 10 Stock Price
Increase 26.80% 27.17% 8.78% -25.77% -2.68% 31.21% 12.35% 24.03% 12.38% 8.27% 2.60% -4.40% 0.77% 4.29% 5.54% <-IRR #YR-> 10 Stock Price
P/E Ratio 161.28 44.18 89.24 38.64 32.23 45.05 7.00 4.46 9.25 16.50 11.03 8.60 14.91 11.87% 8.16% <-IRR #YR-> 5 Stock Price
Trailing P/E Ratio 18.08 205.10 48.05 66.24 37.61 42.30 50.62 8.68 5.01 10.01 16.93 10.54 8.66 10.98% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 40.24 38.79 46.24 50.06 23.56 12.93 11.38 11.05 9.63 8.89 11.39 13.46% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 20.79 19.85 19.96 17.35 14.16 13.15 15.38 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 5.44% 5.30% % Tot Ret 49.53% 39.37% T P/E 10.01 P/E: 13.76 9.25 Count 14 Years of data
-$20.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.47
-$23.29 $0.00 $0.00 $0.00 $0.00 $34.47
-$20.10 $1.25 $1.31 $1.32 $1.32 $1.32 $1.36 $1.41 $1.41 $1.46 $36.00
-$23.29 $1.36 $1.41 $1.41 $1.46 $36.00
High Months Sep Dec Feb May Dec Oct Dec Oct Feb Dec Apr Jul Jan
Price High $17.85 $23.25 $23.85 $22.06 $19.75 $22.97 $25.39 $32.32 $35.35 $38.21 $41.21 $39.62 $36.09 70.41% <-Total Growth 10 Stock Price
Increase 28.88% 30.25% 2.58% -7.51% -10.47% 16.30% 10.54% 27.29% 9.38% 8.09% 7.85% -3.86% -8.91% 5.47% <-IRR #YR-> 10 Stock Price
P/E Ratio 182.14 51.10 97.35 52.52 40.31 49.93 7.63 4.99 10.07 17.94 12.60 9.88 15.49 9.31% <-IRR #YR-> 5 Stock Price
Trailing P/E Ratio 20.42 237.24 52.42 90.04 47.02 46.88 55.20 9.72 5.46 10.89 19.35 12.12 9.00 16.89 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 10.89 P/E: 15.27 10.07 52.52 P/E Ratio Historical High
-$23.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $39.62
-$25.39 $0.00 $0.00 $0.00 $0.00 $39.62
Low Months Mar Jan Aug Dec Jan May Aug Mar Jun Jan Dec Jan Jan
Price Low $13.76 $16.95 $19.88 $10.40 $11.84 $18.48 $21.18 $25.44 $29.56 $32.07 $30.90 $29.32 $33.38 72.98% <-Total Growth 10 Stock Price
Increase 24.19% 23.18% 17.29% -47.69% 13.85% 56.08% 14.61% 20.11% 16.19% 8.49% -3.65% -5.11% 13.85% 5.63% <-IRR #YR-> 10 Stock Price
P/E Ratio 140.41 37.25 81.14 24.76 24.16 40.17 6.37 3.93 8.42 15.06 9.45 7.31 14.33 6.72% <-IRR #YR-> 5 Stock Price
Trailing P/E Ratio 15.74 172.96 43.69 42.45 28.19 37.71 46.04 7.65 4.57 9.14 14.51 8.97 8.32 13.87 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 8.97 P/E: 12.25 8.42 7.31 P/E Ratio Historical Low
-$16.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29.32
-$21.18 $0.00 $0.00 $0.00 $0.00 $29.32
Adjusted EBITDA $114.44 $154.58 $176.91 $201.43 $219.21 $232.40 Adjusted EBITDA (Annual State.)
Increase 35.08% 14.44% 13.86% 8.83% 6.02% 13.86% <-Median-> 5 Increase
EBITDA $168.60 $191.10 $203.10 $210.10 $223.80 $255.20 EBITDA (WebBroker values)
Increase 13.35% 6.28% 3.45% 6.52% 14.03% 6.28% <-Median-> 3 Increase
Long Term Debt $140.59 $145.90 Debt
Change 3.78% Change
Debt/Market Cap Ratio 0.06 0.05 0.05 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $0.00 $0.00 $0.00 $0.00 $43.75 $32.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Debt
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -25.75% -100.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Change
Intangible/Market Cap Ratio 0.00 0.00 0.00 0.00 0.06 0.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 <-Median-> 10 Debt/Market Cap Ratio
Market Cap $271.5 $468.0 $520.8 $388.9 $755.1 $907.5 $1,309.4 $2,115.0 $2,245.4 $2,810.6 $2,476.0 $3,046.2 $3,020.8 $3,020.8 $3,249.6 550.86% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 14.25 16.96 23.76 29.60 33.28 40.09 47.70 57.11 67.90 71.32 77.77 80.94 377.12% <-Total Growth 10 Diluted
Change 56.57% 19.05% 40.04% 24.61% 12.43% 20.45% 18.98% 19.74% 18.89% 5.04% 9.05% 4.07% 18.93% <-Median-> 10 Change
Basic # of Shares in Millions 14.00 16.63 23.35 29.21 32.87 39.61 47.10 56.48 67.44 71.05 77.62 80.82 385.92% <-Total Growth 10 Basic
Change 56.18% 18.76% 40.39% 25.12% 12.52% 20.50% 18.92% 19.90% 19.42% 5.35% 9.25% 4.12% 19.17% <-Median-> 10 Change
Difference 14.39% 21.04% 7.54% 6.92% 18.77% 6.37% 9.96% 13.48% 1.63% 5.66% 1.04% 4.85% 6.64% <-Median-> 10 Difference
# of Share in Millions 16.019 20.130 25.110 31.236 39.041 42.129 51.796 64.090 68.542 75.069 78.430 84.734 84.734 84.734 84.734 15.46% <-IRR #YR-> 10 Shares
Change 54.23% 25.67% 24.74% 24.40% 24.99% 7.91% 22.94% 23.74% 6.95% 9.52% 4.48% 8.04% 0.00% 0.00% 0.00% 10.35% <-IRR #YR-> 5 Shares
CF fr Op $Millon $7.9 $26.1 $16.7 $52.4 $63.0 $61.4 $78.3 $111.8 $122.8 $126 $189 $189 $189 <- 12 mths 625.63% <-Total Growth 10 Cash Flow
Increase -42.54% 231.95% -36.01% 213.81% 20.27% -2.57% 27.53% 42.85% 9.79% 2.82% 49.94% 0.00% 0.00% <- 12 mths S.O. DRIP Share Issue Buy Backs
5 year Running Average $5.7 $10.9 $14.3 $23.3 $33.2 $43.9 $54.4 $73.4 $87.5 $100 $126 $148 $148 <- 12 mths 1253.51% <-Total Growth 10 CF 5 Yr Running
CFPS $0.49 $1.30 $0.66 $1.68 $1.61 $1.46 $1.51 $1.75 $1.79 $1.68 $2.41 $2.23 $2.23 <- 12 mths 72.39% <-Total Growth 10 Cash Flow per Share
Increase -62.75% 164.15% -48.70% 152.27% -3.77% -9.72% 3.73% 15.45% 2.65% -6.12% 43.52% -7.44% 0.00% <- 12 mths 21.92% <-IRR #YR-> 10 Cash Flow
5 year Running Average $0.56 $0.82 $0.95 $1.09 $1.15 $1.34 $1.38 $1.60 $1.62 $1.64 $1.83 $1.97 $1.97 <- 12 mths 19.31% <-IRR #YR-> 5 Cash Flow
P/CF on Med Price 32.22 15.51 32.89 9.68 9.79 14.22 15.40 16.55 18.12 20.89 14.94 15.43 15.55 <- 12 mths 5.60% <-IRR #YR-> 10 Cash Flow per Share
P/CF on Closing Price 34.55 17.94 31.19 7.42 11.98 14.78 16.72 18.91 18.29 22.26 13.08 16.09 15.96 <- 12 mths 8.13% <-IRR #YR-> 5 Cash Flow per Share
3.51% Diff M/C 9.21% <-IRR #YR-> 10 CFPS 5 yr Running
Excl.Working Capital CF $4.2 -$1.5 $24.8 -$0.4 -$4.8 $3.9 -$8.5 -$10.7 $8.8 $22.2 -$29.8 $4.6 4.628 <- 12 mths 7.34% <-IRR #YR-> 5 CFPS 5 yr Running
CF fr Op $M WC $12.1 $24.6 $41.5 $52.0 $58.2 $65.3 $69.8 $101.1 $131.6 $148.5 $159.5 $193.9 $193.9 <- 12 mths 687.21% <-Total Growth 10 Cash Flow less WC
Increase -1.78% 104.29% 68.26% 25.49% 11.86% 12.17% 6.92% 44.88% 30.19% 12.81% 7.40% 21.60% 0.00% <- 12 mths 22.92% <-IRR #YR-> 10 Cash Flow less WC
5 year Running Average $6.3 $11.2 $19.5 $28.5 $37.7 $48.3 $57.3 $69.3 $85.2 $103.3 $122.1 $146.9 $165.5 <- 12 mths 22.68% <-IRR #YR-> 5 Cash Flow less WC
CFPS Excl. WC $0.75 $1.22 $1.65 $1.67 $1.49 $1.55 $1.35 $1.58 $1.92 $1.98 $2.03 $2.29 $2.29 <- 12 mths 29.37% <-IRR #YR-> 10 CF less WC 5 Yr Run
Increase -36.32% 62.56% 34.89% 0.88% -10.50% 3.95% -13.03% 17.08% 21.73% 3.00% 2.80% 12.56% 0.00% <- 12 mths 20.71% <-IRR #YR-> 5 CF less WC 5 Yr Run
5 year Running Average $0.58 $0.83 $1.16 $1.29 $1.36 $1.52 $1.54 $1.53 $1.58 $1.67 $1.77 $1.96 $2.10 <- 12 mths 6.46% <-IRR #YR-> 10 CFPS - Less WC
P/CF on Med Price 21.00 16.42 13.25 9.75 10.60 13.38 17.28 18.31 16.90 17.77 17.73 15.06 15.18 11.18% <-IRR #YR-> 5 CFPS - Less WC
P/CF on Closing Price 22.52 19.00 12.56 7.48 12.98 13.90 18.76 20.92 17.06 18.93 15.53 15.71 15.58 <- 12 mths 9.00% <-IRR #YR-> 10 CFPS 5 yr Running
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 15.42 5 yr 16.55 P/CF Med 10 yr 15.98 5 yr 17.73 -2.53% Diff M/C 4.93% <-IRR #YR-> 5 CFPS 5 yr Running
For Excl. WC see Change in other non-cash operating items
-20.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 84.7 Shares
-51.8 0.0 0.0 0.0 0.0 84.7 Shares
-$26.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $189.3 Cash Flow
-$78.3 $0.0 $0.0 $0.0 $0.0 $189.3 Cash Flow
-$1.30 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.23 Cash Flow per Share
-$1.51 $0.00 $0.00 $0.00 $0.00 $2.23 Cash Flow per Share
-$0.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.97 CFPS 5 yr Running
-$1.38 $0.00 $0.00 $0.00 $0.00 $1.97 CFPS 5 yr Running
-$24.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $193.9 Cash Flow less WC
-$69.8 $0.0 $0.0 $0.0 $0.0 $193.9 Cash Flow less WC
-$11.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $146.9 CF less WC 5 Yr Run
-$57.3 $0.0 $0.0 $0.0 $0.0 $146.9 CF less WC 5 Yr Run
-$1.22 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.29 CFPS - Less WC
-$1.35 $0.00 $0.00 $0.00 $0.00 $2.29 CFPS - Less WC
-$0.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.96 5 yr Running Average
-$1.54 $0.00 $0.00 $0.00 $0.00 $1.96 5 yr Running Average
Change in other non-cash operating items $29.82 -$4.63
Sum $29.82 -$4.63
Google $29.82 -$4.63
Difference $0.00 $0.00
OPM Ratio 15.23% 39.99% 15.62% 39.55% 41.24% 33.28% 39.85% 43.29% 40.65% 37.38% 51.81% 48.57% 21.47% <-Total Growth 10 OPM
Increase -79.80% 162.51% -60.95% 153.25% 4.27% -19.30% 19.73% 8.63% -6.08% -8.04% 38.58% -6.24% Should increase or be stable.
Diff from Median -62.2% -0.7% -61.2% -1.7% 2.5% -17.3% -1.0% 7.5% 1.0% -7.1% 28.7% 20.7% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 40.25% 5 Yrs 43.29% should be zero, it is a check on calculations
Current Assets $4.6 $10.9 $17.9 $73.6 $18.7 $19.3 $56.0 $90.3 $3,427.7 $64.9 $58.9 $52.1 Liquidity ratio of 1.5 and up, best
Current Liabilities $11.2 $20.5 $21.3 $37.1 $41.4 $39.6 $160.6 $185.3 $1,191.7 $258.2 $286.7 $284.6 0.47 <-Median-> 10 Ratio
Liquidity Ratio 0.41 0.53 0.84 1.99 0.45 0.49 0.35 0.49 2.88 0.25 0.21 0.18 0.25 <-Median-> 5 Ratio
Liq. with CF aft div -0.56 0.62 0.15 2.30 0.73 0.63 0.41 0.62 2.90 0.33 0.47 0.39 0.47 <-Median-> 5 Ratio
Liq. CF re Inv+Div -0.05 0.10 0.02 0.46 0.11 0.16 0.12 0.21 2.26 0.13 0.19 0.14 0.19 <-Median-> 5 Ratio
Curr Long Term Debt $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $137.5 $140.6 $145.9
Liquidity Less CLTD 0.41 0.53 0.84 1.99 0.45 0.49 0.35 0.49 2.88 0.54 0.40 0.38 0.49 <-Median-> 5 Ratio
Liq. with CF aft div -0.56 0.62 0.15 2.30 0.73 0.63 0.41 0.62 2.90 0.71 0.92 0.81 0.81 <-Median-> 5 Ratio
Assets $384.5 $502.5 $808.6 $949.4 $1,155.2 $1,258.5 $2,154.6 $3,051.6 $3,500.6 $3,932.7 $4,455.9 $5,213.9 Debt Ratio of 1.5 and up, best
Liabilities $227.8 $286.8 $518.9 $563.7 $673.6 $748.5 $1,013.0 $1,273.9 $1,431.9 $1,602.7 $1,864.2 $2,192.5 2.25 <-Median-> 10 Ratio
Debt Ratio 1.69 1.75 1.56 1.68 1.71 1.68 2.13 2.40 2.44 2.45 2.39 2.38 2.40 <-Median-> 5 Ratio
Book Value $156.8 $215.7 $289.8 $385.7 $481.5 $510.0 $1,141.6 $1,777.6 $2,068.7 $2,330.0 $2,591.7 $3,021.3 $3,021.3 $3,021.3 $3,021.3 1300.69% <-Total Growth 10 Book Value
Book Value per share $9.79 $10.72 $11.54 $12.35 $12.33 $12.11 $22.04 $27.74 $30.18 $31.04 $33.05 $35.66 $35.66 $35.66 $35.66 232.76% <-Total Growth 10 Book Value per Share
Change 3.54% 9.48% 7.69% 6.99% -0.10% -1.85% 82.07% 25.85% 8.82% 2.84% 6.46% 7.90% 0.00% 0.00% 0.00% -10.06% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.61 1.88 1.89 1.31 1.28 1.71 1.06 1.04 1.08 1.13 1.09 0.97 1.22 P/B Ratio Historical Median
P/B Ratio (Close) 1.73 2.17 1.80 1.01 1.57 1.78 1.15 1.19 1.09 1.21 0.96 1.01 1.00 1.00 1.08 12.78% <-IRR #YR-> 10 Book Value per Share
Change 18.63% 25.29% -17.17% -43.89% 55.50% 13.48% -35.54% 3.73% -8.77% 11.13% -20.80% 5.53% -0.83% 0.00% 7.57% 10.10% <-IRR #YR-> 5 Book Value per Share
Leverage (A/BK) 2.45 2.33 2.79 2.46 2.40 2.47 1.89 1.72 1.69 1.69 1.72 1.73 1.72 <-Median-> 5 A/BV
Debt/Equity Ratio 1.45 1.33 1.79 1.46 1.40 1.47 0.89 0.72 0.69 0.69 0.72 0.73 0.72 <-Median-> 5 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.11 5 yr Med 1.08 -7.02% Diff M/C 2.32 Historical 14 A/BV
-$10.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $35.66
-$22.04 $0.00 $0.00 $0.00 $0.00 $35.66
Comprehensive Income $7.72 $5.81 $12.51 $16.30 $18.54 $158.71 $370.06 $238.62 $151.78 $254.37 $324.31 4102.48% <-Total Growth 10 Comprehensive Income
Increase -24.71% 115.35% 30.27% 13.75% 756.02% 133.17% -35.52% -36.39% 67.59% 27.49% 27.49% <-Median-> 5 Comprehensive Income
5 Yr Running Average $12.18 $42.37 $115.22 $160.45 $187.54 $234.71 $267.83 45.33% <-IRR #YR-> 10 Comprehensive Income 4102.48%
ROE 3.6% 2.0% 3.2% 3.4% 3.6% 13.9% 20.8% 11.5% 6.5% 9.8% 10.7% 15.36% <-IRR #YR-> 5 Comprehensive Income 104.34%
5Yr Median 3.2% 3.3% 3.4% 3.4% 3.6% 11.5% 11.5% 11.5% 10.7% 67.39% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.00% 0.00% 0.00% 0.00% 0.00% 0.03% 0.07% 0.00% -0.01% 0.00% 0.00% 44.59% <-IRR #YR-> 5 5 Yr Running Average 532.06%
Median Values Diff 5, 10 yr 0.0% 0.0% 10.7% <-Median-> 5 Return on Equity
-$7.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $324.3
-$158.7 $0.0 $0.0 $0.0 $0.0 $324.3
-$12.2 $0.0 $0.0 $0.0 $0.0 $0.0 $267.8
-$42.4 $0.0 $0.0 $0.0 $0.0 $267.8
Current Liability Coverage Ratio 1.07 1.20 1.94 1.40 1.41 1.65 0.43 0.55 0.11 0.58 0.56 0.68 CFO / Current Liabilities
5 year Median 1.28 1.28 1.40 1.41 1.41 1.40 0.55 0.55 0.55 0.56 62.8% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 3.14% 4.90% 5.13% 5.48% 5.04% 5.19% 3.24% 3.31% 3.76% 3.78% 3.58% 3.72% CFO / Total Assets
5 year Median 4.60% 4.90% 5.04% 5.13% 5.13% 5.04% 3.76% 3.76% 3.58% 3.72% 3.8% <-Median-> 10 Return on Assets
Return on Assets ROA 0.4% 1.5% 0.7% 1.3% 1.4% 1.5% 7.4% 12.1% 6.8% 3.9% 5.7% 6.2% Net Income/Assets Return on Assets
5Yr Median 2.9% 2.2% 1.5% 1.3% 1.3% 1.4% 1.4% 1.5% 6.8% 6.8% 6.8% 6.2% 4.8% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 0.9% 3.6% 2.0% 3.2% 3.4% 3.6% 13.9% 20.8% 11.5% 6.5% 9.8% 10.7% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 8.0% 5.8% 3.6% 3.2% 3.2% 3.4% 3.4% 3.6% 11.5% 11.5% 11.5% 10.7% 8.2% <-Median-> 10 Return on Equity
Net Income $1.4 $7.7 $5.8 $12.5 $16.3 $18.5 $158.7 $369.8 $238.6 $151.8 $254.4 $324.31 $0.0 4102.48% <-Total Growth 10 Net Income
Increase -82.31% 454.38% -24.71% 115.35% 30.27% 13.75% 755.77% 133.09% -35.47% -36.39% 67.58% 27.49% -100.00% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $3.1 $4.7 $5.8 $7.1 $8.7 $12.2 $42.4 $115.2 $160.4 $187 $235 $268 $193.8 45.33% <-IRR #YR-> 10 Net Income
Operating Cash Flow $7.9 $26.1 $16.7 $52.4 $63.0 $61.4 $78.3 $111.8 $122.8 $126.2 $189.3 $189.3 15.37% <-IRR #YR-> 5 Net Income
Investment Cash Flow -$103.7 -$108.1 -$163.6 -$148.0 -$229.2 -$119.8 -$380.6 -$373.6 -$337.8 -$402.3 -$417.2 -$529.3 49.88% <-IRR #YR-> 10 5 Yr Running Average
Total Accruals $97.2 $89.7 $152.7 $108.1 $182.5 $77.0 $460.9 $631.5 $453.7 $427.8 $482.2 $664.3 44.60% <-IRR #YR-> 5 5 Yr Running Average
Total Assets $384.5 $502.5 $808.6 $949.4 $1,155.2 $1,258.5 $2,154.6 $3,051.6 $3,500.6 $3,932.7 $4,455.9 $5,213.9 Balance Sheet Assets
Accruals Ratio 25.28% 17.85% 18.88% 11.38% 15.80% 6.12% 21.39% 20.70% 12.96% 10.88% 10.82% 12.74% 12.74% <-Median-> 5 Ratio
EPS/CF Ratio (WC) 0.13 0.37 0.15 0.25 0.33 0.30 2.47 4.10 1.83 1.08 1.61 1.75 1.34 <-Median-> 10 EPS/CF Ratio
-$7.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $324.3
-$158.7 $0.0 $0.0 $0.0 $0.0 $324.3
-$4.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $267.8
-$42.4 $0.0 $0.0 $0.0 $0.0 $267.8
Change in Close 22.83% 37.17% -10.80% -39.97% 55.34% 11.38% 17.36% 30.54% -0.73% 14.29% -15.68% 13.87% -0.83% 0.00% 7.57% Count 14 Years of data
up/down down down down down down down down down down down down down down Count 14 100.00%
Meet Prediction? Yes yes yes Yes % right Count 4 28.57%
Financial Cash Flow $96.3 $83.6 $144.6 $95.2 $166.7 $59.1 $334.6 $290.9 $183.4 $249.5 $226.9 $375.9 C F Statement Financial CF
Total Accruals $0.9 $6.1 $8.0 $12.9 $15.8 $17.9 $126.3 $340.6 $270.3 $178.3 $255.3 $288.4 Accruals
Accruals Ratio 0.23% 1.22% 0.99% 1.36% 1.37% 1.42% 5.86% 11.16% 7.72% 4.53% 5.73% 5.53% 5.73% <-Median-> 5 Ratio
Cash $1.8 $3.4 $1.2 $0.8 $1.3 $1.9 $34.2 $63.4 $34.8 $5.3 $4.3 $12.2 Cash
Cash per Share $0.11 $0.17 $0.05 $0.03 $0.03 $0.04 $0.66 $0.99 $0.51 $0.07 $0.06 $0.14 $0.14 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.67% 0.73% 0.23% 0.20% 0.17% 0.21% 2.61% 3.00% 1.55% 0.19% 0.17% 0.40% 0.40% <-Median-> 5 % of Stock Price
Notes:
March 2, 2017. Last estimates were for 2017 and 2017 of $399 and $385 for Re venue, $2.01 and $2.28 for AFFO, $2.33 and $2.60 for FFO, and $225.40 and $246.80 for EBITDA.
March 2, 2016. Last estimates were for 2015, and 2016 $356M, $356M, $1.98 and $2.33 AFFO, $2.26 and $2.62 for FFO, $2.15 and $2.40 for EPS.
Allied Properties Real Estate Investment Trust went public in February 2003
Sector:
Real Estate
What should this stock accomplish?
REITs should provide good dividends and growth at or above the inflation rate.
Would I buy this company and Why.
Dividends
Dividends are paid monthly. They are declared for shareholders of record of one month and paid in the following month.
For example, the distribution declared for shareholders of record on December 31, 2013 is paid on January 15, 2014.
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.
Since several stocks that I followed last year were deleted from the stock exchange, I was looking for other stocks to follow.
I am sure that I got this from a Canadian Dividend site called Think Dividends, but I cannot find it at present.
How they make their money.
Allied Properties REIT owns a portfolio of predominantly Class I office properties in Toronto, Montreal, Winnipeg, Quebec City,
Ottawa, Victoria, Calgary, Edmonton, Vancouver, and Kitchener-Waterloo.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Feb xx 2013 Feb xx 2014 Mar 07 2015 Mar 03 2016 Mar 02 2017
Emory, Michael R. 0.891 1.14% 0.920 1.09% 1.121 1.32%
CEO - Shares - Amount $28.133 $33.065 $39.954
Options - percentage 0.562 0.72% 0.562 0.66% 0.790 0.93%
Options - amount $17.756 $20.219 $28.178
Williams, Cecilia Catalina 0.003 0.00% 0.003 0.00% 0.008 0.01%
CFO - Shares - Amount $0.093 $0.106 $0.274
Options - percentage 0.034 0.04% 0.034 0.04% 0.126 0.15%
Options - amount $1.079 $1.229 $4.500
Burns, Thomas Gerard 0.032 0.04% 0.036 0.04% 0.048 0.06% COO
Officer - Shares - Amount $1.024 $1.310 $1.716
Options - percentage 0.199 0.25% 0.199 0.24% 0.412 0.49%
Options - amount $6.295 $7.169 $14.675
Connor, Gerald R. 0.476 0.61% 0.418 0.49% 0.417 0.49%
Director - Shares - Amount $15.038 $15.031 $14.849
Options - percentage 0.017 0.02% 0.007 0.01% 0.007 0.01%
Options - amount $0.545 $0.246 $0.244
Cunningham, Gordon R. 0.041 0.05% 0.035 0.04% 0.051 0.06%
Chairman - Shares - Amt $1.295 $1.258 $1.804
Options - percentage 0.067 0.09% 0.013 0.01% 0.008 0.01%
Options - amount $2.127 $0.455 $0.297
Increase in O/S Shares 0.232 0.36% 0.049 0.07% 0.787 1.05% 0.119 0.15% 0.162 0.19%
due to SO $8.673 $1.851 $29.459 $3.752 $5.835
Book Value $8.133 $1.127 $17.185 $3.076 $3.644
Insider Buying -$1.405 -$2.708 -$2.094
Insider Selling $20.498 $4.757 $1.640
Net Insider Selling $19.092 $2.049 -$0.454
% of Market Cap 0.77% 0.07% -0.02%
Directors 7 8 8
Women 0 0% 1 13% 1 13%
Minorities 0 0% 0 0% 0 0%
Institutions/Holdings 106 39.22% 121 45.37% 132 47.51%
Total Shares Held 30.334 38.68% 35.595 45.38% 40.257 47.51%
Increase/Decrease 0.356 1.19% -0.467 -1.30% 1.052 2.68%
Starting No. of Shares 29.978 36.062 39.205
Copyright 2008 Website of SPBrunner. All rights reserved.