This report is for educational purposes only, and not to provide investment advice.  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/
Canadian Real Estate Investment Trust TSX: REF.UN OTC: CRXIF www.creit.ca Fiscal Yr: Dec 31
Year 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 12/30/20 Value Description #Y Item Total G
Accounting Rules GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Revenue* $269.75 $291.72 $319.72 $329.80 $329.02 $335.27 $374.42 $376.12 $388.30 $394.00 $402.59 $413.59 $481 $450 41.78% <-Total Growth 10 Revenue
Increase 11.58% 8.14% 9.60% 3.15% -0.24% 1.90% 11.68% 0.45% 3.24% 1.47% 2.18% 2.73% 16.30% -6.44% 3.55% <-IRR #YR-> 10 Revenue 41.78%
5 year Running Average $217.3 $243.0 $268.8 $290.6 $308.0 $321.1 $337.6 $348.9 $360.6 $373.6 $387.1 $394.9 $415.9 $428.2 2.01% <-IRR #YR-> 5 Revenue 10.46%
Revenue per Share $4.67 $4.81 $5.23 $4.98 $4.93 $4.97 $5.49 $5.47 $5.35 $5.40 $5.50 $5.64 $6.55 $6.13 4.97% <-IRR #YR-> 10 5 yr Running Average 62.49%
Increase 10.15% 2.89% 8.84% -4.92% -0.90% 0.71% 10.53% -0.42% -2.04% 0.84% 1.83% 2.51% 16.30% -6.44% 3.18% <-IRR #YR-> 5 5 yr Running Average 16.96%
5 year Running Average $3.98 $4.26 $4.58 $4.79 $4.92 $4.98 $5.12 $5.16 $5.24 $5.33 $5.44 $5.47 $5.69 $5.84 1.60% <-IRR #YR-> 10 Revenue per Share 17.21%
P/S (Price/Sales) Med 5.66 6.35 4.87 4.84 6.09 6.78 7.31 8.07 8.54 8.18 8.23 8.02 7.11 0.01 0.53% <-IRR #YR-> 5 Revenue per Share 2.68%
P/S (Price/Sales) Close 6.73 5.99 4.31 5.45 6.30 7.13 7.92 7.94 8.55 7.79 8.42 8.22 7.51 8.03 2.52% <-IRR #YR-> 10 5 yr Running Average 28.29%
*Property Rental Revenue in M CDN $  P/S Med 10 yr  7.66 5 yr  8.18 -1.95% Diff M/C 1.34% <-IRR #YR-> 5 5 yr Running Average 6.87%
chnged to Net Operation Income
-$291.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $413.59
-$374.42 $0.00 $0.00 $0.00 $0.00 $413.59
-$243.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $394.9
-$337.6 $0.0 $0.0 $0.0 $0.0 $394.9
-$4.808 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $5.635
-$5.488 $0.000 $0.000 $0.000 $0.000 $5.635
-$4.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.47
-$5.12 $0.00 $0.00 $0.00 $0.00 $5.47
AFFO $1.46 $1.81 $1.97 $1.98 $2.03 $2.08 $2.37 $2.57 $2.50 $2.42 $2.53 $2.77 $2.89 $2.88 53.04% <-Total Growth 10 AFFO
Increase 0.69% 24.40% 8.84% 0.66% 2.37% 2.46% 13.94% 8.44% -2.72% -3.20% 4.55% 9.49% 4.33% -0.35% 4.35% <-IRR #YR-> 10 AFFO 53.04% Fin Info
AFFO Yield 4.62% 6.28% 8.73% 7.31% 6.54% 5.88% 5.45% 5.93% 5.46% 5.75% 5.46% 5.98% 5.87% 5.85% 3.17% <-IRR #YR-> 5 AFFO 16.88% on Website
5 year Running Average $1.73 $1.85 $1.97 $2.09 $2.21 $2.31 $2.39 $2.48 $2.56 $2.62 $2.70 4.99% <-IRR #YR-> 8 5 yr Running Average #DIV/0!
Payout Ratio FFO 88.66% 72.93% 68.38% 68.73% 68.72% 68.63% 62.00% 61.68% 69.32% 73.34% 71.84% 66.90% 64.69% 64.92% 4.16% <-IRR #YR-> 5 5 yr Running Average 22.59%
5 year Running Average 76.07% 72.61% 69.41% 67.11% 65.62% 65.89% 66.92% 67.63% 68.52% 69.02% 68.08% 67.63% <-Median-> 9 Payout 5 year Running 
Price/AFFO Median 18.18 16.86 12.94 12.14 14.80 16.20 16.92 17.16 18.30 18.25 17.88 16.31 16.13 0.03 16.61 <-Median-> 10 P/AFFO Med
Price/AFFO High 21.93 18.56 15.74 14.62 16.35 17.49 18.43 18.62 19.88 20.10 20.31 18.49 17.47 0.00 18.46 <-Median-> 10 P/AFFO High
Price/AFFO Low 14.43 15.17 10.15 9.66 13.26 14.90 15.41 15.70 16.72 16.40 15.46 14.12 14.79 0.00 15.16 <-Median-> 10 P/AFFO Low
Price/AFFO Close 21.63 15.91 11.46 13.68 15.30 17.02 18.34 16.88 18.32 17.38 18.30 16.71 17.03 17.09 16.95 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 21.78 19.79 12.47 13.77 15.66 17.44 20.89 18.30 17.82 16.82 19.13 18.30 17.77 17.03 17.63 <-Median-> 10 Trailing P/AFFO Close
Median Values DPR 10 Yrs 68.67% 5 Yrs   69.32% P/CF 5 Yrs   in order 17.88 19.88 15.70 17.38 -4.75% Diff M/C 2.54% Diff M/C 10 DPR 75% to 95% best
* Funds From Operations
-$1.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.77
-$2.37 $0.00 $0.00 $0.00 $0.00 $2.77
-$1.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.56
-$2.09 $0.00 $0.00 $0.00 $0.00 $2.56
Distributable Income (DI) $1.93 $2.11 $2.27 $2.31 $2.36 $2.36 $2.63 $2.84 $2.96 $3.03 $3.28 $3.34 $3.28 $3.28 57.99% <-Total Growth 10 FFO
Increase 33.96% 9.59% 7.38% 1.63% 2.21% 0.08% 11.44% 7.98% 4.23% 2.36% 8.25% 1.83% -1.80% 0.00% 4.68% <-IRR #YR-> 10 FFO 57.99%
FFO Yield 6.13% 7.34% 10.06% 8.51% 7.59% 6.67% 6.05% 6.55% 6.46% 7.20% 7.08% 7.21% 6.66% 6.66% 4.90% <-IRR #YR-> 5 FFO 27.00%
5 year Running Average $1.50 $1.65 $1.84 $2.01 $2.20 $2.28 $2.39 $2.50 $2.63 $2.76 $2.95 $3.09 $3.18 $3.24 6.45% <-IRR #YR-> 10 FFO 5 Yr Running 86.75%
Payout Ratio FFO 66.87% 62.44% 59.34% 59.08% 59.16% 60.49% 55.87% 55.82% 58.55% 58.57% 55.41% 55.48% 57.00% 57.00% 5.32% <-IRR #YR-> 5 FFO 5 Yr Running 29.56%
5 year Running Average 83.26% 76.88% 70.53% 65.51% 61.17% 60.06% 58.72% 57.94% 57.88% 57.81% 56.85% 56.72% 56.94% 56.66% 58.33% <-Median-> 10 Payout Ratio 5 Yr Running
P/FFO re Med Price 13.71 14.44 11.23 10.44 12.74 14.28 15.25 15.53 15.45 14.57 13.79 13.52 14.21 0.03 14.03 <-Median-> 10 P/FFO Med
P/FFO re High Price 16.54 15.89 13.66 12.57 14.08 15.42 16.61 16.85 16.79 16.05 15.66 15.34 15.39 0.00 15.54 <-Median-> 10 P/FFO High
P/FFO re Low Price 10.89 12.98 8.81 8.30 11.41 13.14 13.89 14.21 14.12 13.10 11.92 11.71 13.03 0.00 12.51 <-Median-> 10 P/FFO Low
P/FFO re Close price 16.31 13.62 9.94 11.76 13.17 15.00 16.52 15.27 15.47 13.88 14.12 13.86 15.01 15.01 14.00 <-Median-> 10 P/FFO Close
Trailing P/FFO 21.85 14.93 10.68 11.95 13.46 15.01 18.42 16.49 16.12 14.21 15.28 14.12 14.74 15.01 14.61 <-Median-> 10 Trailing P/FFO Close
Median Values DPR 10 Yrs 58.56% 5 Yrs   55.82% P/CF 5 Yrs   in order 14.57 16.05 13.10 14.12 2.98% Diff M/C 6.94% Diff M/C 10 DPR 75% to 95% best
* Adjusted Funds From Operations
EPS Basic $1.12 $0.46 $1.13 $1.81 $2.48 $0.07 $1.18 $1.24 $1.98 $2.73 $1.85 $3.33 623.91% <-Total Growth 10 EPS Basic
EPS Diluted* $1.12 $0.46 $1.13 $1.81 $2.48 $0.68 $1.18 $1.24 $1.98 $2.73 $1.85 $3.33 $3.30 $3.35 623.91% <-Total Growth 10 EPS Diluted
Increase 7.69% -58.93% 145.65% 60.18% 37.02% -72.58% 73.53% 5.08% 59.68% 37.88% -32.23% 80.00% -0.90% 1.52% 21.89% <-IRR #YR-> 10 Earnings per Share 623.91%
Earnings Yield 3.6% 1.6% 5.0% 6.7% 8.0% 1.9% 2.7% 2.9% 4.3% 6.5% 4.0% 7.2% 6.7% 6.8% 23.06% <-IRR #YR-> 5 Earnings per Share 182.20%
5 year Running Average $1.06 $0.92 $0.92 $1.11 $1.40 $1.31 $1.46 $1.48 $1.51 $1.56 $1.80 $2.23 $2.64 $2.91 9.19% <-IRR #YR-> 10 5 yr Running Average 140.91%
10 year Running Average $1.03 $0.98 $1.00 $1.09 $1.22 $1.19 $1.19 $1.20 $1.31 $1.48 $1.55 $1.84 $2.06 $2.21 8.86% <-IRR #YR-> 5 5 yr Running Average 52.88%
* Diluted ESP per share  E/P 10 Yrs 4.67% 5Yrs 4.32%
-$0.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.33
-$1.18 $0.00 $0.00 $0.00 $0.00 $3.33
-$0.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.23
-$1.46 $0.00 $0.00 $0.00 $0.00 $2.23
Special Dividend $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 Dividend
Distributions* $1.29 $1.32 $1.35 $1.36 $1.40 $1.43 $1.47 $1.59 $1.73 $1.77 $1.82 $1.85 $1.87 $1.87 $1.87 40.39% <-Total Growth 10 Distributions*
Increase 1.57% 2.33% 2.05% 1.18% 2.35% 2.33% 2.94% 7.88% 9.32% 2.41% 2.41% 1.96% 0.89% 0.00% 0.00% Count 23 Years of data
Average Increases 5 Year Running 1.97% 2.01% 1.84% 1.75% 1.90% 2.05% 2.17% 3.33% 4.96% 4.98% 4.99% 4.80% 3.40% 1.53% 1.05%
Dividends 5 Yr Running $1.25 $1.27 $1.30 $1.32 $1.34 $1.37 $1.40 $1.45 $1.52 $1.60 $1.68 $1.75 $1.81 $1.84 $1.86 37.79% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 4.88% 4.33% 5.28% 5.66% 4.64% 4.24% 3.66% 3.59% 3.79% 4.02% 4.02% 4.10% 4.01% 4.06% <-Median-> 10 Yield H/L Price
Yield on High  Price 4.04% 3.93% 4.35% 4.70% 4.20% 3.92% 3.36% 3.31% 3.49% 3.65% 3.54% 3.62% 3.70% 3.63% <-Median-> 10 Yield on High  Price
Yield on Low Price 6.14% 4.81% 6.74% 7.12% 5.18% 4.60% 4.02% 3.93% 4.15% 4.47% 4.65% 4.74% 4.37% 4.63% <-Median-> 10 Yield on Low Price
Yield on Close Price 4.10% 4.58% 5.97% 5.03% 4.49% 4.03% 3.38% 3.66% 3.78% 4.22% 3.93% 4.00% 3.80% 3.80% 3.49% 4.02% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 115.18% 286.96% 119.21% 75.30% 56.25% 209.93% 124.53% 127.84% 87.53% 65.01% 98.24% 55.65% 56.65% 55.8% #DIV/0! 92.88% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 117.64% 137.66% 140.50% 118.53% 95.93% 104.46% 96.18% 97.97% 100.66% 102.30% 93.32% 78.74% 68.60% 99.32% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 75.29% 72.13% 67.82% 62.36% 62.72% 67.90% 55.54% 65.86% 71.08% 68.14% 69.64% 65.65% #DIV/0! 66.84% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 88.80% 84.44% 77.49% 72.41% 67.56% 66.35% 62.83% 62.61% 64.40% 65.50% 65.96% 68.03% #DIV/0! 66.15% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 72.15% 65.67% 58.17% 61.71% 63.05% 46.78% 41.77% 45.58% 50.75% 52.39% 52.85% 53.18% #DIV/0! 52.62% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 86.88% 79.89% 71.15% 67.02% 63.74% 58.08% 52.62% 50.04% 48.55% 47.42% 48.61% 50.94% #DIV/0! 51.78% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 4.06% 3.93% 5 Yr Med Payout 87.53% 68.14% 52.39% 3.45% <-IRR #YR-> 10 Dividends 40.39%
* Distributions per share  5 Yr Med and Cur. -6.46% -3.26% Last Div Inc ---> $0.1525 $0.1558 2.2% 4.75% <-IRR #YR-> 5 Dividends 26.11%
Dividends Growth 15 2.97% <-IRR #YR-> 15 Dividends 55.07%
Dividends Growth 20 2.98% <-IRR #YR-> 20 Dividends 79.91%
Dividends Growth 25 5.03% <-IRR #YR-> 23 Dividends
Dividends Growth 10 -$1.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.85 Dividends Growth 10
Dividends Growth 5 -$1.47 $0.00 $0.00 $0.00 $0.00 $1.85 Dividends Growth 5
Dividends Growth 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.85 Dividends Growth 15
Dividends Growth 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.85 Dividends Growth 20
Dividends Growth 25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.85 Dividends Growth 25
Historical Dividends Historical High Div 11.32% Low Div 3.43% Ave Div 7.38% Med Div 6.02% Close Div 5.80% Historical Dividends
High/Ave/Median Values Curr diff Exp. -66.45% Exp 10.72% Exp. -48.51% Exp. -36.92% Exp. -34.55% High/Ave/Median 
Future Dividend Yield Div Yd 4.19% earning in 5 Years at IRR of 2.00% Div Inc. 10.41% Future Dividend Yield
Future Dividend Yield Div Yd 4.63% earning in 10 Years at IRR of 2.00% Div Inc. 21.90% Future Dividend Yield
Future Dividend Yield Div Yd 5.11% earning in 15 Years at IRR of 2.00% Div Inc. 34.59% Future Dividend Yield
I am earning GC Div Gr 43.82% 9/28/06 # yrs -> 12 2006 $26.38 Cap Gain 86.62% I am earning GC
I am earning Div org yield 4.93% 12/31/14 Pension Div G Yrly 4.50% Div start $1.30 -4.93% 7.09% I am earning Div
Yield if held 5 yrs 10.66% 10.09% 9.45% 8.60% 7.01% 5.40% 4.81% 6.22% 7.20% 5.91% 5.39% 4.62% 4.24% 4.09% 4.23% 6.06% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 11.04% 9.67% 11.46% 11.33% 13.58% 11.80% 11.23% 11.12% 10.94% 8.92% 6.87% 6.07% 7.33% 7.77% 6.22% 11.18% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 15.36% 15.83% 12.22% 10.76% 13.49% 14.41% 17.27% 15.02% 14.17% 13.12% 11.80% 9.39% 14.41% <-Median-> 9 Paid Median Price
Yield if held 20 yrs 19.53% 20.14% 15.55% 13.58% 15.91% 15.55% 18.20% 17.54% <-Median-> 4 Paid Median Price
Yield if held 25 yrs 21.07% 21.22% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 51.53% 48.62% 45.45% 41.59% 33.74% 25.90% 22.94% 28.39% 31.61% 26.59% 24.87% 21.85% 20.51% 20.08% 21.01% 27.49% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 101.97% 89.41% 105.63% 104.82% 124.87% 108.16% 102.16% 96.26% 89.62% 73.88% 57.58% 51.66% 63.87% 69.76% 57.47% 99.21% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 199.10% 207.04% 160.61% 140.71% 167.25% 168.11% 202.63% 177.42% 169.16% 159.76% 147.58% 120.49% 169.16% <-Median-> 9 Paid Median Price
Cost covered if held 20 years 284.85% 297.70% 232.33% 204.91% 244.26% 244.49% 292.94% 258.59% <-Median-> 4 Paid Median Price
388.34% 403.00% #NUM! <-Median-> 0 Paid Median Price
Graham Price FFO $21.34 $22.43 $22.98 $24.50 $25.94 $36.53 $38.45 $39.82 $54.49 $55.76 $58.01 $59.48 $58.95 $58.95 $0.00 165.19% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.24 1.36 1.11 0.98 1.16 0.92 1.04 1.11 0.84 0.79 0.78 0.76 0.79 0.95 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.50 1.50 1.35 1.18 1.28 1.00 1.14 1.20 0.91 0.87 0.89 0.86 0.86 1.07 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.98 1.22 0.87 0.78 1.04 0.85 0.95 1.01 0.77 0.71 0.67 0.66 0.73 0.82 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.47 1.28 0.98 1.11 1.20 0.97 1.13 1.09 0.84 0.75 0.80 0.78 0.84 0.84 #DIV/0! 0.98 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -23.80% -53.35% -29.45% -11.42% 2.55% -46.32% -33.02% -33.92% -18.21% -5.08% -24.90% -0.15% 0.30% 1.06% #DIV/0! -21.56% <-Median-> 10 Graham Price
Graham Price EPS $16.26 $10.46 $16.22 $21.70 $26.61 $19.61 $25.75 $26.32 $44.56 $52.93 $43.57 $59.39 $59.13 $59.57 $0.00 467.66% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.63 2.92 1.57 1.11 1.13 1.72 1.56 1.68 1.03 0.83 1.04 0.76 0.79 1.12 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.96 3.21 1.91 1.34 1.25 1.86 1.70 1.82 1.12 0.92 1.18 0.86 0.85 1.29 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.29 2.62 1.23 0.88 1.01 1.58 1.42 1.53 0.94 0.75 0.90 0.66 0.72 0.97 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.94 2.75 1.39 1.25 1.17 1.81 1.69 1.65 1.03 0.79 1.06 0.78 0.83 0.83 #DIV/0! 1.21 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 93.54% 175.25% 39.19% 25.00% 16.70% 80.55% 68.76% 64.81% 2.75% -20.53% 6.27% -22.05% -16.74% -17.36% #DIV/0! 20.85% <-Median-> 10 Graham Price
Price Close $31.47 $28.80 $22.57 $27.12 $31.05 $35.40 $43.46 $43.37 $45.79 $42.06 $46.30 $46.30 $49.23 $49.23 $53.51 60.76% <-Total Growth 10 Stock Price
Increase 39.68% -8.48% -21.63% 20.16% 14.49% 14.01% 22.77% -0.21% 5.58% -8.15% 10.08% 0.00% 6.33% 0.00% 8.69% 4.86% <-IRR #YR-> 10 Stock Price 60.76%
P/E 28.10 62.61 19.97 14.98 12.52 52.06 36.83 34.98 23.13 15.41 25.03 13.90 14.92 14.70 #DIV/0! 1.27% <-IRR #YR-> 5 Stock Price 6.53%
Trailing P/E 30.26 25.71 49.07 24.00 17.15 14.27 63.91 36.75 36.93 21.24 16.96 25.03 14.78 14.92 15.97 9.26% <-IRR #YR-> 10 Price & Dividend 120.09%
Median 10, 5 Yrs D.  per yr 4.40% 3.92% % Tot Ret 47.51% 75.48% Price Inc 0.00% P/E:  21.55 23.13 5.20% <-IRR #YR-> 5 Price & Dividend 30.08%
Price 15 D.  per yr 6.69% % Tot Ret 43.47% 8.70% <-IRR #YR-> 15 Stock Price 249.43%
Price  20 D.  per yr 6.52% % Tot Ret 49.39% 6.68% <-IRR #YR-> 20 Stock Price 264.57%
Price  25 D.  per yr 8.42% % Tot Ret 51.72% 7.86% <-IRR #YR-> 23 Stock Price
Price & Dividend 15 15.39% <-IRR #YR-> 15 Price & Dividend 425.44%
Price & Dividend 20 13.20% <-IRR #YR-> 20 Price & Dividend 492.92%
Price & Dividend 25 16.28% <-IRR #YR-> 23 Price & Dividend
Price 10 -$28.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.30 Price 10
Price  5 -$43.46 $0.00 $0.00 $0.00 $0.00 $46.30 Price  5
Price & Dividend 10 -$28.80 $1.35 $1.36 $1.40 $1.43 $1.47 $1.59 $1.73 $1.77 $1.82 $48.15 Price & Dividend 10
Price & Dividend 5 -$43.46 $1.59 $1.73 $1.77 $1.82 $48.15 Price & Dividend 5
Price 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.30 Price 15
Price  20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.30 Price  20
Price  25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.30 Price  25
Price & Dividend 15 $1.29 $1.32 $1.35 $1.36 $1.40 $1.43 $1.47 $1.59 $1.73 $1.77 $1.82 $48.15 Price & Dividend 15
Price & Dividend 20 $1.29 $1.32 $1.35 $1.36 $1.40 $1.43 $1.47 $1.59 $1.73 $1.77 $1.82 $48.15 Price & Dividend 20
Price & Dividend 25 $1.29 $1.32 $1.35 $1.36 $1.40 $1.43 $1.47 $1.59 $1.73 $1.77 $1.82 $48.15 Price & Dividend 25
Price H/L Median $26.46 $30.52 $25.50 $24.08 $30.05 $33.69 $40.10 $44.11 $45.75 $44.16 $45.25 $45.17 $46.62 8.69% 48.00% <-Total Growth 10 Stock Price
Increase 32.91% 15.37% -16.45% -5.59% 24.82% 12.11% 19.03% 9.99% 3.72% -3.46% 2.46% -0.17% 3.21% 3.80% 4.00% <-IRR #YR-> 10 Stock Price 48.00%
P/E 23.62 66.35 22.57 13.30 12.12 49.54 33.98 35.57 23.10 16.18 24.46 13.56 14.13 12.49% 2.41% <-IRR #YR-> 5 Stock Price 12.64%
Trailing P/E 25.44 27.25 55.43 21.31 16.60 13.58 58.97 37.38 36.89 22.30 16.57 24.42 14.00 8.30% <-IRR #YR-> 10 Price & Dividend 103.98%
P/E on Running 5 yr Average 24.96 33.03 27.66 21.65 21.46 25.68 27.54 29.84 30.25 28.27 25.19 20.29 17.67 6.57% <-IRR #YR-> 5 Price & Dividend 38.16%
P/E on Running 10 yr Average 25.68 31.02 25.58 22.09 24.65 28.41 33.70 36.75 34.87 29.82 29.12 24.54 22.65 16.18 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 4.30% 4.16% % Tot Ret 51.81% 63.31% Price Inc 2.46% P/E:  22.83 23.10 Count 23 Years of data
-$30.52 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $45.17
-$40.10 $0.00 $0.00 $0.00 $0.00 $45.17
-$30.52 $1.35 $1.36 $1.40 $1.43 $1.47 $1.59 $1.73 $1.77 $1.82 $47.02
-$40.10 $1.59 $1.73 $1.77 $1.82 $47.02
High Months Dec Mar Jun Dec Nov Dec Dec May Nov Feb Jul Jul Feb
Price High $31.91 $33.59 $31.00 $29.00 $33.19 $36.38 $43.68 $47.86 $49.69 $48.63 $51.38 $51.23 $50.49 52.52% <-Total Growth 10 Stock Price
Increase 42.39% 5.26% -7.71% -6.45% 14.45% 9.61% 20.07% 9.57% 3.82% -2.13% 5.65% -0.29% -1.44% 4.31% <-IRR #YR-> 10 Stock Price 52.52%
P/E 28.49 73.02 27.43 16.02 13.38 53.50 37.02 38.60 25.10 17.81 27.77 15.38 15.30 3.24% <-IRR #YR-> 5 Stock Price 17.28%
Trailing P/E 30.68 29.99 67.39 25.66 18.34 14.67 64.24 40.56 40.07 24.56 18.82 27.69 15.16 17.81 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 3.82% P/E:  26.26 25.10 30.20 P/E Ratio Historical High
-$33.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $51.23
-$43.68 $0.00 $0.00 $0.00 $0.00 $51.23
Low Months Feb Jul Nov Feb Feb Aug Jan Oct Jan Aug Feb Feb Feb
Price Low $21.00 $27.45 $20.00 $19.15 $26.91 $31.00 $36.52 $40.35 $41.80 $39.69 $39.11 $39.11 $42.75 42.48% <-Total Growth 10 Stock Price
Increase 20.69% 30.71% -27.14% -4.25% 40.52% 15.20% 17.81% 10.49% 3.59% -5.05% -1.46% 0.00% 9.31% 3.60% <-IRR #YR-> 10 Stock Price 42.48%
P/E 18.75 59.67 17.70 10.58 10.85 45.59 30.95 32.54 21.11 14.54 21.14 11.74 12.95 1.38% <-IRR #YR-> 5 Stock Price 7.09%
Trailing P/E 20.19 24.51 43.48 16.95 14.87 12.50 53.71 34.19 33.71 20.05 14.33 21.14 12.84 14.54 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 0.00% P/E:  19.41 21.11 10.83 P/E Ratio Historical Low
-$27.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $39.11
-$36.52 $0.00 $0.00 $0.00 $0.00 $39.11
EBITDA $190.84 $201.45 $216.42 $227.98 $254.80 $278.80 $292.30 $305.40 $319.60 $321.20 $314.30 $320.90 15.21% <-Total Growth 9 EBITDA TDB
Change 5.56% 7.43% 5.34% 11.76% 9.42% 4.84% 4.48% 4.65% 0.50% -2.15% 2.10% 5.34% <-Median-> 9 Change
Debt Lg, Short $1,131.9 $1,199.2 $1,403.9 $1,242.7 $1,216.9 $1,510.9 $1,834.9 $1,917.3 $1,907.59 $1,944.16 $1,993.78 $1,854.19 Debt Lg, Short
Change 20.73% 5.94% 17.07% -11.48% -2.08% 24.16% 21.44% 4.49% -0.51% 1.92% 2.55% -7.00% 2.23% <-Median-> 10 Change
CF/Debt Ratio 8.74% 9.26% 8.64% 11.66% 12.20% 9.40% 9.84% 8.64% 9.27% 9.78% 9.59% 11.17% 9.68% <-Median-> 10 CF/Debt Ratio
Long Term Debt $1,532 $1,494 $1,319 Mortgages Long Term Debt
Change -2.46% -11.72% Change
Debt/Market Cap Ratio 0.50 0.44 0.39 0.44 <-Median-> 3 Debt/Market Cap Ratio
Goodwill $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Intangibles Goodwill
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! <-Median-> 0 Change
Intangible/Market Cap Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.00 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $1,817 $1,747 $1,379 $1,798 $2,072 $2,390 $2,965 $2,985 $3,321 $3,070 $3,391 $3,398 $3,613 $3,613 $3,927 94.47% <-Total Growth 10 Market Cap
Buy Back
Diluted # of Shares in Million 59.19 60.90 64.88 66.50 67.12 67.88 68.49 69.56 72.82 73.15 73.31 23.86% <-Total Growth 10 Diluted
Change 2.90% 6.53% 2.50% 0.93% 1.12% 0.91% 1.56% 4.69% 0.45% 0.22% 1.34% <-Median-> 10 Change
Basic # of Shares in Millions 57.51 59.19 60.90 64.88 66.50 67.12 67.88 68.49 69.56 72.82 73.15 73.31 23.87% <-Total Growth 10 Basic
Change 1.43% 2.91% 2.90% 6.53% 2.50% 0.93% 1.12% 0.91% 1.56% 4.69% 0.45% 0.22% 1.34% <-Median-> 10 Change
Difference 0.4% 2.5% 0.3% 2.2% 0.3% 0.6% 0.5% 0.5% 4.3% 0.2% 0.1% 0.1% 0.41% <-Median-> 10 Difference
# of Share in M 57.73 60.67 61.10 66.29 66.73 67.52 68.22 68.82 72.53 72.98 73.23 73.39 73.39 73.39 73.39 1.92% <-IRR #YR-> 10 Shares 20.96%
Change 1.30% 5.10% 0.70% 8.49% 0.67% 1.18% 1.04% 0.88% 5.39% 0.63% 0.34% 0.22% 0.00% 0.00% 0.00% 1.47% <-IRR #YR-> 5 Shares 7.58%
CF fr Op $Millon $98.91 $111.04 $121.36 $144.88 $148.42 $141.96 $180.49 $165.64 $176.84 $190.11 $191.14 $207.15 86.56% <-Total Growth 10 Cash Flow
Increase 25.24% 12.26% 9.30% 19.38% 2.44% -4.35% 27.14% -8.23% 6.76% 7.50% 0.54% 8.38% S. Issue  DRIP, Buy Backs
5 year Running Average $76.5 $86.1 $98.3 $111.0 $124.9 $133.5 $147.4 $156.3 $162.7 $171.0 $180.8 $186.2 116.26% <-Total Growth 10 CF 5 Yr Running
CFPS $1.71 $1.83 $1.99 $2.19 $2.22 $2.10 $2.65 $2.41 $2.44 $2.60 $2.61 $2.82 54.23% <-Total Growth 10 Cash Flow per Share
Increase 23.63% 6.81% 8.54% 10.03% 1.76% -5.47% 25.83% -9.03% 1.30% 6.84% 0.20% 8.14% 6.43% <-IRR #YR-> 10 Cash Flow 86.56%
5 year Running Average $1.40 $1.51 $1.67 $1.82 $1.99 $2.07 $2.23 $2.31 $2.36 $2.44 $2.54 $2.58 2.79% <-IRR #YR-> 5 Cash Flow 14.77%
P/CF on Med Price 15.44 16.68 12.84 11.01 13.51 16.02 15.16 18.33 18.76 16.95 17.34 16.00 4.43% <-IRR #YR-> 10 Cash Flow per Share 54.23%
P/CF on Closing Price 18.37 15.74 11.36 12.41 13.96 16.84 16.43 18.02 18.78 16.15 17.74 16.40 1.30% <-IRR #YR-> 5 Cash Flow per Share 6.69%
-100.00% Diff M/C 5.51% <-IRR #YR-> 10 CFPS 5 yr Running 71.04%
Excl.Working Capital CF $4.30 $10.92 $20.12 $1.53 -$0.78 $64.08 $59.51 $73.74 $70.85 $57.13 $60.73 $48.61 2.94% <-IRR #YR-> 5 CFPS 5 yr Running 15.60%
CF fr Op $M WC $103.2 $122.0 $141.5 $146.4 $147.6 $206.0 $240.0 $239.4 $247.7 $247.2 $251.9 $255.8 109.72% <-Total Growth 10 Cash Flow less WC
Increase 19.87% 18.16% 16.01% 3.48% 0.84% 39.55% 16.49% -0.26% 3.47% -0.18% 1.87% 1.55% 7.69% <-IRR #YR-> 10 Cash Flow less WC 109.72%
5 year Running Average $78.5 $91.1 $107.2 $119.8 $132.1 $152.7 $176.3 $195.9 $216.1 $236.1 $245.2 $248.4 1.28% <-IRR #YR-> 5 Cash Flow less WC 6.57%
CFPS Excl. WC $1.79 $2.01 $2.32 $2.21 $2.21 $3.05 $3.52 $3.48 $3.41 $3.39 $3.44 $3.48 10.55% <-IRR #YR-> 10 CF less WC 5 Yr Run 172.63%
Increase 18.33% 12.43% 15.21% -4.62% 0.17% 37.92% 15.29% -1.13% -1.82% -0.80% 1.53% 1.33% 7.09% <-IRR #YR-> 5 CF less WC 5 Yr Run 40.88%
5 year Running Average $1.44 $1.59 $1.82 $1.97 $2.11 $2.36 $2.66 $2.89 $3.13 $3.37 $3.45 $3.44 5.66% <-IRR #YR-> 10 CFPS - Less WC 73.37%
P/CF on Med Price 14.80 15.18 11.01 10.90 13.58 11.04 11.40 12.68 13.40 13.04 13.16 12.96 -0.19% <-IRR #YR-> 5 CFPS - Less WC -0.94%
P/CF on Close Price 17.60 14.33 9.75 12.28 14.03 11.60 12.35 12.47 13.41 12.42 13.46 13.29 8.01% <-IRR #YR-> 10 CFPS 5 yr Running 116.11%
*Operational Cash Flow per share  CF/-WC P/CF Med 10 yr 16.01 5 yr  17.34 P/CF Med 10 yr 12.82 5 yr  13.04 -100.00% Diff M/C 5.27% <-IRR #YR-> 5 CFPS 5 yr Running 29.30%
-$1.83 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.82 Cash Flow per Share
-$2.65 $0.00 $0.00 $0.00 $0.00 $2.82 Cash Flow per Share
-$1.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.58 CFPS 5 yr Running
-$2.23 $0.00 $0.00 $0.00 $0.00 $2.58 CFPS 5 yr Running
-$122.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $255.8 Cash Flow less WC
-$240.0 $0.0 $0.0 $0.0 $0.0 $255.8 Cash Flow less WC
-$91.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $248.4 CF less WC 5 Yr Run
-$176.3 $0.0 $0.0 $0.0 $0.0 $248.4 CF less WC 5 Yr Run
-$2.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.48 CFPS - Less WC
-$3.52 $0.00 $0.00 $0.00 $0.00 $3.48 CFPS - Less WC
-$1.59 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.44 CFPS 5 yr Running
-$2.66 $0.00 $0.00 $0.00 $0.00 $3.44 CFPS 5 yr Running
Amortization of straight-line rent receivable (1,937> -$1.4 -$0.3 -$0.262 -$1.937 -$2.258
Income taxes paid -$0.4 -$0.3 -$0.4 -$0.8 -$0.883 -$1.136 -$1.095
Interest paid -$69.9 -$73.0 -$83.0 -$85.9 -$82.094 -$78.268 -$73.709
Interest Income
Interest received $10.6 $11.5 $10.9 $11.5 $19.025 $18.704 $20.395
-$2.9 $1.5 $3.8
-$9.5 -$2.04 -$3.0 $0.7 -$0.1
-$0.9 -$8.1 -$8.9 -$2.1 -$1.9
-$1.4 -$0.2
Changes in other operating working capital items $6.2 $0.6 -$8.1 -$0.1 $2.6 -$4.4 $2.3 $0.1 $4.7 $7.085 $1.907 $8.055
                       
Sum -$4.3 -$10.9 -$20.1 -$1.5 $0.8 -$64.1 -$59.5 -$73.7 -$70.85 -$57.129 -$60.730 -$48.612
Google -$67.3 -$73.7 -$70.85 -$57.13 -$60.73 -$48.61
Difference $7.76 -$0.01 $0.00 $0.00 $0.00 $0.00
OPM 36.7% 38.1% 38.0% 43.9% 45.1% 42.3% 48.2% 44.0% 45.5% 48.3% 47.5% 50.1% 31.58% <-Total Growth 10 OPM
Increase 12.24% 3.81% -0.27% 15.73% 2.69% -6.14% 13.85% -8.64% 3.41% 5.95% -1.60% 5.49% Should increase  or be stable.
Diff from Ave. -19.1% -16.0% -16.3% -3.1% -0.5% -6.6% 6.4% -2.8% 0.5% 6.5% 4.7% 10.5% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 45.33% 5 Yrs 47.48% should be  zero, it is a   check on calculations
Current Assets $125.6 $167.1 $192.0 $204.5 $191.0 $181.5 $195.3 $252.7 $46.7 $40.0 $43.1 $43.0 Liq ratio of 1.5 and up, best From G&M 
Current Liabilities $149.4 $141.3 $260.6 $113.8 $34.8 $164.9 $215.9 $128.4 $134.8 $145.2 $114.0 $109.3 0.82 <-Median-> 10 Ratio
Liquidity 0.84 1.18 0.74 1.80 5.50 1.10 0.90 1.97 0.35 0.28 0.38 0.39 0.38 <-Median-> 5 Ratio
Liq. with CF aft div 1.00 1.40 0.89 2.28 7.09 1.38 1.28 2.41 0.73 0.69 0.89 1.04 0.89 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.47 0.55 0.46 1.55 4.07 0.55 0.60 1.00 0.27 0.37 0.43 1.04 0.43 <-Median-> 5 Ratio
Assets $1,805.4 $1,979.6 $2,195.6 $2,158.9 $2,164.6 $3,301.3 $3,654.1 $3,717.2 $5,275.5 $5,417.8 $5,486.5 $5,451.0 Debt Ratio of 1.5 and up, best
Liabilities $1,199.7 $1,337.8 $1,563.8 $1,392.7 $1,313.7 $1,604.9 $1,949.9 $2,009.1 $2,042.4 $2,089.4 $2,146.9 $1,995.4 1.97 <-Median-> 10 Ratio
Debt Ratio 1.50 1.48 1.40 1.55 1.65 2.06 1.87 1.85 2.58 2.59 2.56 2.73 2.58 <-Median-> 5 Ratio
Total Book Value $605.7 $641.8 $631.9 $766.2 $850.9 $1,696.4 $1,704.1 $1,708.2 $3,233.1 $3,328.4 $3,339.6 $3,455.5 438.44% <-Total Growth 10 Book Value
Minority Int $4.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
Book Value $605.7 $641.8 $631.9 $766.2 $846.7 $1,696 $1,704 $1,708 $3,233 $3,328 $3,340 $3,456 $3,455.5 $3,455.5 $3,455.5 438.44% <-Total Growth 10 Book Value
Book Value per Share $10.49 $10.58 $10.34 $11.56 $12.69 $25.12 $24.98 $24.82 $44.58 $45.60 $45.60 $47.08 $47.08 $47.08 $47.08 345.13% <-Total Growth 10 Book Value per Share
Change -0.81% 0.82% -2.23% 11.78% 9.76% 98.04% -0.58% -0.64% 79.60% 2.31% -0.01% 3.25% 0.00% 0.00% 0.00% -17.19% P/B Ratio Current/Historical Median
P/B Ratio (Median) 2.52 2.89 2.47 2.08 2.37 1.34 1.61 1.78 1.03 0.97 0.99 0.96 1.26 P/B Ratio Historical Median
P/B Ratio (Close) 3.00 2.72 2.18 2.35 2.45 1.41 1.74 1.75 1.03 0.92 1.02 0.98 1.05 1.05 1.14 16.10% <-IRR #YR-> 10 Book Value per Share 345.13% Chge in  Acct Rules
Change 40.82% -9.23% -19.84% 7.50% 4.31% -42.43% 23.48% 0.43% -41.21% -10.22% 10.09% -3.15% 6.33% 0.00% 8.69% 13.52% <-IRR #YR-> 5 Book Value per Share 88.49% Inc BV
Leverage (A/BK) 2.98 3.08 3.47 2.82 2.54 1.95 2.14 2.18 1.63 1.63 1.64 1.58 2.05 <-Median-> 10 A/BV
Debt/Equity Ratio 1.98 2.08 2.47 1.82 1.54 0.95 1.14 1.18 0.63 0.63 0.64 0.58 1.05 <-Median-> 10 Debt/Eq Ratio
Book Value is Asset less Liabilities P/BV 10 yr Med 1.47 5 yr Med 0.99 -29.02% Diff M/C 2.10 Historical Leverage (A/BK)
-$10.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $47.08
-$24.98 $0.00 $0.00 $0.00 $0.00 $47.08
Comprehensive Income $64.18 $27.45 $61.88 $122.10 $161.74 $36.03 $82.00 $96.94 $134.22 $207.58 $136.20 $248.17 804.09% <-Total Growth 10 Comprehensive Income
Increase -57.23% 125.44% 97.30% 32.46% -77.72% 127.57% 18.21% 38.45% 54.66% -34.38% 82.21% 38.45% <-Median-> 5 Comprehensive Income
5 Yr Running Average $87.47 $81.84 $92.75 $99.76 $102.19 $111.35 $131.39 $164.62 24.63% <-IRR #YR-> 10 Comprehensive Income 804.09%
ROE 10.6% 4.3% 9.8% 15.9% 19.1% 2.1% 4.8% 5.7% 4.2% 6.2% 4.1% 7.2% 24.79% <-IRR #YR-> 5 Comprehensive Income 202.64%
5Yr Median 10.60% 9.79% 9.79% 5.67% 4.81% 4.81% 4.81% 5.67% 9.45% <-IRR #YR-> 7 5 Yr Running Average #DIV/0!
% Difference from NI -21.3% 2.4% 14.1% -2.6% 4.5% 0.4% 1.6% 12.16% <-IRR #YR-> 5 5 Yr Running Average 77.49%
Median Values Diff 5, 10 yr 1.6% 1.6% 5.7% <-Median-> 5 Return on Equity
-$27.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $248.2
-$82.0 $0.0 $0.0 $0.0 $0.0 $248.2
-$87.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $164.6
-$92.8 $0.0 $0.0 $0.0 $0.0 $164.6
Current Liability Coverage Ratio 0.69 0.86 0.54 1.29 4.25 1.25 1.11 1.86 1.84 1.70 2.21 2.34   CFO / Current Liabilities
5 year Median 0.58 0.69 0.69 0.71 0.86 1.25 1.25 1.29 1.84 1.70 1.84 1.86 177.0% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 5.72% 6.16% 6.44% 6.78% 6.82% 6.24% 6.57% 6.44% 4.69% 4.56% 4.59% 4.69% CFO / Total Assets
5 year Median 0.05 0.06 0.06 0.06 0.06 0.06 0.07 0.07 0.06 6.24% 4.69% 4.69% 6.3% <-Median-> 10 Return on Assets 
Return on Assets ROA 3.6% 4.2% 3.1% 5.4% 7.6% 1.4% 2.2% 2.3% 2.6% 3.7% 2.5% 4.5% Net  Income/Assets Return on Assets
5Yr Median 3.7% 3.7% 3.6% 3.7% 4.2% 4.2% 3.1% 2.3% 2.3% 2.3% 2.5% 2.6% 2.9% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 10.6% 12.9% 10.9% 15.3% 19.5% 2.7% 4.7% 5.0% 4.3% 6.0% 4.1% 7.1% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 10.1% 10.4% 10.6% 10.9% 12.9% 12.9% 10.9% 5.0% 4.7% 4.7% 4.7% 5.0% 5.5% <-Median-> 10 Return on Equity
Net Income $64.21 $83.03 $68.89 $117.40 $164.93 $45.80 $80.09 $84.95 $137.82 $198.59 $135.60 $244.29 194.22% <-Total Growth 9 Net Income
Increase 8.81% 29.31% -17.03% 70.41% 40.49% -72.23% 74.87% 6.06% 62.24% 44.09% -31.72% 80.16% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $56.2 $62.4 $64.5 $78.5 $99.7 $96.0 $95.4 $98.6 $102.7 $109.4 $127.4 $160.2 11.40% <-IRR #YR-> 10 Net Income 194.22%
Operating Cash Flow $98.9 $111.0 $121.4 $144.9 $148.4 $142.0 $180.5 $165.6 $176.8 $190.1 $191.1 $207.2 24.99% <-IRR #YR-> 5 Net Income 205.00%
Investment Cash Flow -169.90 -221.58 -242.96 -53.50 -25.70 -245.92 -245.92 -181.69 -226.65 -123.32 -121.15 95.48 9.88% <-IRR #YR-> 10 5 Yr Running Average 156.67%
Total Accruals 135.21 193.57 190.48 26.02 42.21 149.76 145.52 101.00 187.64 131.80 65.61 -58.34 10.92% <-IRR #YR-> 5 5 Yr Running Average 67.93%
Total Assets $1,805.4 $1,979.6 $2,195.6 $2,158.9 $2,164.6 $3,301.3 $3,654.1 $3,717.2 $5,275.5 $5,417.8 $5,486.5 $5,451.0 Balance Sheet Assets
Accruals Ratio 7.49% 9.78% 8.68% 1.21% 1.95% 4.54% 3.98% 2.72% 3.56% 2.43% 1.20% -1.07% 2.57% <-Median-> 4 Ratio
EPS/CF Ratio 0.63 0.23 0.49 0.82 1.12 0.22 0.34 0.36 0.58 0.81 0.54 0.96 0.54 <-Median-> 9 EPS/CF Ratio
-$83 $0 $0 $0 $0 $0 $0 $0 $0 $0 $244
-$80 $0 $0 $0 $0 $244
-$62 $0 $0 $0 $0 $0 $0 $0 $0 $0 $160
-$95 $0 $0 $0 $0 $160
Chge in Close 39.68% -8.48% -21.63% 20.16% 14.49% 14.01% 22.77% -0.21% 5.58% -8.15% 10.08% 0.00% 6.33% 0.00% 8.69% Count 24 Years of data
up/down down down down down Count 12 50.00%
Meet Prediction? Yes Yes % right Count 5 41.67%
Financial Cash Flow $56.73 $110.24 $122.39 -$91.56 -$119.55 $107.14 $107.14 $20.53 $56.18 -$75.75 -$69.23 -$299.73 C F Statement  Financial CF
Total Accruals $78.47 $83.33 $68.10 $117.57 $161.75 $42.63 $38.39 $80.47 $131.45 $207.55 $134.83 $241.40 Accruals
Accruals Ratio 4.35% 4.21% 3.10% 5.45% 7.47% 1.29% 1.05% 2.16% 2.49% 3.83% 2.46% 4.43% 2.49% <-Median-> 5 Ratio
Cash $5.45 $5.19 $8.33 $12.54 $12.54 $17.60 $25.34 $17.25 $17.90 $20.72 Cash
Cash per Share $0.09 $0.08 $0.12 $0.19 $0.18 $0.26 $0.35 $0.24 $0.24 $0.28 $0.26 <-Median-> 5 Cash per Share
0.40% 0.29% 0.40% 0.52% 0.42% 0.59% 0.76% 0.56% 0.53% 0.61% 0.59% <-Median-> 5 % of Stock Price
Taxes
Foreign 2.73% 3.39% 2.42% 9.04% 3.67% 3.66% 2.81% 2.36% 2.90% 3.99% 4.44% 3.45% <-Median-> 4 Foreign
Cap Gain 2.89% 16.91% 0.00% 30.02% 0.00% 4.63% 13.30% 11.18% 7.61% 6.91% 1.90% 7.26% <-Median-> 4 Cap Gain
Other Income 60.83% 75.85% 82.09% 60.89% 80.96% 79.04% 80.26% 86.36% 88.91% 88.22% 84.28% 87.29% <-Median-> 4 Other Income
Ret of Cap. 33.56% 3.85% 15.49% 0.05% 15.37% 12.67% 3.63% 0.10% 0.58% 0.88% 9.38% 0.73% <-Median-> 4 Ret of Cap.
Total 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
For Tax Cr 0.07%
Foreign $0.12 $0.05 $0.04
Cap Gain $0.41 $0.07 $0.20
Other Income $0.83 $1.13 $1.18
Ret of Cap. $0.00 $0.18 $0.05
$1.36 $1.43 $1.47
Inflation- see separate spreadsheet.
Notes:
February 17, 2018.  Last estimate were for 2017 and 2019 of $429M, $448M for Revenue, $2.92, $2.95 for AFFO, $3.34 and $3.36 for FFO, $3.13 and $3.53 for EPS.
February 25, 2017.  Last estimates were for 2016 and 2017 of $399M and $413M for Revenue, $2.78 and $2.81 for AFFO, $3.09 and $3.15 for FFO and $3.69 for EPS for 2016 and EBITDA of $307.4M and $309.4M
February 28, 2016.  Last estimates were for 2015 and 2016 of $438M and $451M for Revenue, $2.78 and $2.93 for AFFO, $3.03 and $3.20 for FFO, $3.18 and $3.69 for EPS, $306.3M and $317.7M for EBITDA.
March 5, 2015.  Last estimates were for 2014 and 2015 of $431 and $447M for Revenue, $2.69 and 2.77 for AFFO, $2.96 and $3.05 for FFO, $0.97 and $0.97 for EPS and $287M and $295M for EBITDA.
February 21, 2014.  Last estimates were for 2013 and 2014 of $2.51 and $2.66 AFFO; $2.76 and $2.92 for FFO; $0.89 and $0.97 for EPS.
Feb 23, 2013.  Last Estimates were for 2011 and 2013 of $2.18 and $2.23 AFFO, $2.44 and $2.51 FFO and $0.87, 0.89 and .097 (2014) for EPS and $2.48 and $2.57 CFPS.
Feb 21, 2012.  Statements said under new rules, EPS for 2010 would have been 2.78 and FFO at 2.33. 
Feb 21, 2012.  Last Estimates were for 2011 and 2012 of $2.32 and $2.38 FFO, $1.21 and $1.21 for EPS and $2.29 and $2.31 for CF.
Mar 16, 2011.  When I last looked I got estimates for 2010 and 2011 of $2.30 and $2.41 for FFO, $1.10 and 1.19 for earnings, and $2.19 and $2.21 for Cash Flow.
Mar 2009. InAug 2009, I got estimates for 2009 and 2010 of $1.35 and $1.25 for earnings, $2.32 and $2.25 for FFO and $2.27 and $2.30 for Cash Flow fr O.
In 2009 statements, they now give FFO for 2008 as $2.34.  There is some $.38 earnings on discontinued business included in the $1.81 earnings.
What is liked about this stock?  Long Term stable tenants and conservative management.  Their Cash Flow is likely to remain strong, even in a recession.
May 9, 2009 AR 2008.  When I looked at this stock in Sep 2008, I got a FFO of $2.22 and Earnings of $1.18 for 2008.  The FFO came in as $2.27.
I bought this stock in Sep 2006 and I have not made any money on it.  However, other Real Estate stocks have done no better since Sep 2006.  2006 was a high point for Real Estate stock.
AP 2006. In Fin.Post Card, analyst give a Hold rating at $31.34.  Revenue ok, but ESP is only slowly increasing. P/E is really high. Yield is not bad.  I can see why they do not expect the stock to increase
much this year (re P/E ratio).  I have only lost money on this since I bought it.  Perhaps not a good one to buy.  I will keep a eye on this. In CDN trading acct.
2006.  Does not seem like a bad stock.  Return over last 5 years is good.  OPM is really down in 2005 and this does not look good.
Sector:
Real Estate
What should this stock accomplish?
This stock should provide moderate to good dividends and low dividend growth.  Dividend growth needs to be above the rate of inflation.
Would I buy this company and Why.
You would buy this company for diversification.  It might be considered to be a seaprate asset class from othe stocks.
Why am I following this stock. 
I started to follow some REITs because I wanted to diversify my portfolio into REITs.  I was mainly interested in ones that have commercial properties.
Why I bought this stock.
In September 2009, I wanted to buy another REIT after having to sell Summit.  I already have lots of RioCan.  I looked at H&R and CDN REIT.  I thought that CDN REIT was a better buy at that time.  I was not interested in CAP as it is only Apartments.
Dividends
Dividends are paid monthly near the middle of the month.  Dividends are declared for one month and payable in the following month.
For example, the distribution declared on February 13, 2014 for shareholders of record of February 28, 2014 will be payable on March 14, 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 Our property management focus is on providing outstanding business accommodation to our tenants.
Satisfied tenants lead to lower turnover, translating to higher occupancy.
For employees 90.4% of our employees are also CREIT Unitholders
For community As one way to contribute to the communities in which we operate our business, CREIT has teamed up with Easter SealsTM Canada to support the “Drop Zone Event”. 
For investors Our primary business objective is to accumulate a portfolio of high-quality real estate assets and to deliver the benefits of real estate ownership to our investors.
How they make their money
Canadian Real Estate Investment Trust is a real estate investment trust. The Company owns and operates a portfolio of retail, industrial and office properties.
This stock is rated STA-3M by DBRS.
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.
Info on January 30th, 2011 distribution.
CREIT will complete a reorganization of an existing subsidiary holding trust (the "Reorganization") before December 31, 2010 in order to qualify as a "real estate investment trust" for purposes of the Income Tax 
Act (Canada) (the "Tax Act"). As part of the Reorganization, on December 30, 2010, the assets of the holding trust will be transferred to CREIT Trust B, a subsidiary trust of CREIT created for the purpose of 
the Reorganization and CREIT will make a distribution to its Unitholders in the form of units of CREIT Trust B ("Trust B Units"). Each Unitholder of CREIT will receive one Trust B Unit for every CREIT 
Unit owned. The Trust B Units will then be immediately redeemed by CREIT Trust B and the redemption price will be paid by CREIT Trust B in the form of Units of CREIT. Following the redemption, CREIT 
will consolidate its Units so that, following the Reorganization, each Unitholder of CREIT will own the same number of CREIT Units that such Unitholder owned immediately prior to the Reorganization.
The Reorganization will not have any adverse Canadian income tax consequences for Unitholders of CREIT, except that withholding taxes will be exigible in respect of the distribution of Trust B Units to 
Unitholders that are non-residents of Canada for purposes of the Tax Act. CREIT will fund and remit such withholding taxes to the Canada Revenue Agency on behalf of such non-resident Unitholders 
(estimated to be less than $50,000 in aggregate).
This Reorganization is required as a result of, and to comply with, the definition of a qualifying REIT as set out in the Tax Act, which was introduced as part of the Specified Investment Flow Through ("SIFT")
 legislation.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Feb 21 2012 Feb 27 2013 Feb 21 2014 Mar 05 2015 Feb 28 2016 Feb 25 2017 Feb 17 2018
Johnson, Stephen Edward 0.423 0.61% 0.451 0.62% 0.485 0.66% 0.531 0.73% 0.563 0.77% 0.601 0.82%
CEO - Shares - Amount $18.347 $20.653 $20.386 $24.593 $26.080 $29.592
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Barrafato, Mario 0.025 0.03% 0.032 0.04%
CFO - Shares - Amount $1.158 $1.600
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Diamond, Rael Lee 0.000 0.00% 0.041 0.06% 0.016 0.02% 0.064 0.09% 0.077 0.10% was CFO, now COO 2017
COO - Shares - Amount $0.000 $1.732 $0.750 $2.944 $3.772
Options - percentage 0.030 0.04% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $1.357 $0.000 $0.000 $0.000 $0.000
McSorley, Timothy 0.112 0.16%
CFO - Shares - Amount $4.851
Options - percentage 0.000 0.00%
Options - amount $0.000
Bird, Bill 0.005 0.01% 0.001 0.00%
Officer - Shares - Amount $0.217 $0.023
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Fell, Anthony S. 0.033 0.05%
Director - Shares - Amount $1.632
Options - percentage 0.000 0.00%
Options - amount $0.000
Brough, John A. 0.004 0.01% 0.001 0.00% 0.007 0.01% 0.008 0.01% 0.006 0.01% 0.000 0.00% yes 0 in 2018
Director - Shares - Amount $0.190 $0.024 $0.291 $0.354 $0.297 $0.000
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Mackay, W. Reay 0.035 0.05% 0.035 0.05% Morningstar in 2017 says he
Chairman - Shares - Amt $1.621 $1.723 is chairman
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount $0.000 $0.000
Fisher, James D. 0.009 0.01% 0.010 0.01% Seems to be no longer Chairman
Chairman - Shares - Amt $0.425 $0.416 I do not know who has replaced
Options - percentage 0.000 0.00% 0.000 0.00% him
Options - amount $0.000 $0.000
Arsenault, Rene 0.008 0.01% 0.008 0.01%
Subsidiary Executive $0.338 $0.328
Options 0.017 0.02% 0.017 0.02%
Only one to have options $0.737 $0.715
Increase in O/S Shares 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% Buy Shares on open
due to SO $0.000 $0.000 $0.000 $0.000 $0.000 market for SO
Book Value $0 $0 $2.795 $2.621 $0.000
% of Total Book Value 0.08% 0.08% 0.00%
Insider Buying $0.000 -$2.633 -$3.348 -$3.381 -$3.240
Insider Selling $0.000 $0.295 $0.012 $0.096 $0.338
Net Insider Selling $0.000 -$2.338 -$3.335 -$3.285 -$2.902
% of Market Cap -0.08% -0.10% -0.10% -0.08%
Directors 6 8 7 7 7
Women 0 0% 1 13% 1 14% 1 14% 1 14%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 60.26% 78 38.46% 80 47.06% 83 45.71% 90 54.49% 103 50.54% 109 43.42%
Total Shares Held 41.109 60.26% 26.236 38.12% 32.391 44.66% 33.183 45.47% 39.823 54.38% 37.018 50.55% 31.866 43.42%
Increase/Decrease 1.053 2.63% -0.439 -1.65% 0.186 0.58% -0.064 -0.19% -0.545 -1.35% 0.067 0.18% 0.623 2.00%
Starting No. of Shares 40.056 26.675 32.205 33.247 40.368 36.951 Reuters 31.242 Reuters
Copyright © 2008 Website of SPBrunner. All rights reserved.
13.6524
My stock