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/
H & R Real Estate Trust TSX: HR.UN OTC: HRUFF www.hr-reit.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
Revenue* $488.17 $529.29 $582.14 $611.85 $611.39 $618.16 $656.91 $835.30 $1,137.0 $1,227.8 $1,188.3 $1,196.0 $1,144 $1,177 125.96% <-Total Growth 10 Revenue
Increase 18.91% 8.42% 9.98% 5.10% -0.08% 1.11% 6.27% 27.16% 36.12% 7.98% -3.22% 0.65% -4.35% 2.88% 8.49% <-IRR #YR-> 10 Revenue 125.96%
5 year Running Average $348.4 $411.7 $468.8 $524.4 $564.6 $590.6 $616.1 $666.7 $771.8 $895.0 $1,009.1 $1,116.9 $1,178.6 $1,186.6 12.73% <-IRR #YR-> 5 Revenue 82.07%
Revenue per Share $4.41 $4.50 $4.53 $4.32 $4.25 $4.23 $3.81 $4.29 $4.21 $4.47 $4.25 $4.19 $4.01 $4.13 10.50% <-IRR #YR-> 10 5 yr Running Average 171.31%
Increase 3.52% 1.98% 0.68% -4.63% -1.63% -0.48% -10.01% 12.71% -1.84% 6.10% -4.89% -1.35% -4.35% 2.88% 12.63% <-IRR #YR-> 5 5 yr Running Average 81.29%
5 year Running Average $3.96 $4.25 $4.32 $4.41 $4.40 $4.37 $4.23 $4.18 $4.16 $4.20 $4.21 $4.28 $4.23 $4.21 -0.71% <-IRR #YR-> 10 Revenue per Share -6.84%
P/S (Price/Sales) Med 4.42 5.01 5.03 2.96 2.61 4.28 5.73 5.72 5.41 5.00 5.32 5.00 5.67 0.00 1.95% <-IRR #YR-> 5 Revenue per Share 10.12%
P/S (Price/Sales) Close 4.75 5.35 4.38 1.72 3.63 4.59 6.11 5.62 5.08 4.86 4.72 5.34 5.75 5.59 0.09% <-IRR #YR-> 10 5 yr Running Average 0.86%
*Property Rental Revenue in M CDN $ P/S Med 10 yr 5.02 5 yr 5.32 14.60% Diff M/C 0.26% <-IRR #YR-> 5 5 yr Running Average 1.29%
-$529.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,196.0
-$656.9 $0.0 $0.0 $0.0 $0.0 $1,196.0
-$411.7 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,116.9
-$616.1 $0.0 $0.0 $0.0 $0.0 $1,116.9
-$4.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.19
-$3.81 $0.00 $0.00 $0.00 $0.00 $4.19
-$4.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.28
-$4.23 $0.00 $0.00 $0.00 $0.00 $4.28
AFFO Diluted $1.51 $1.38 $1.14 $1.44 $1.32 $1.46 $1.53 $1.49 $1.54 1.99% <-Total Growth 8 AFFO Diluted
AFFO Basic $1.59 $1.51 $1.19 $1.49 $1.37 $1.47 $1.54 $1.50 $1.56 $1.75 $1.78 -1.70% <-Total Growth 8 AFFO Basic
Increase -4.9% -21.2% 25.2% -8.1% 7.3% 4.8% -2.6% 4.0% 12.2% 1.7% 0.47% <-IRR #YR-> 7 AFFO #DIV/0!
AFFO Yield 21.30% 9.77% 6.12% 6.41% 5.68% 6.87% 7.09% 7.48% 6.97% 7.59% 7.72% 0.92% <-IRR #YR-> 5 AFFO 4.70%
5 year Running Average $1.43 $1.41 $1.41 $1.47 $1.49 $1.56 $1.63 1.01% <-IRR #YR-> 4 5 yr Running Average #DIV/0!
Payout Ratio AFFO 90.74% 47.68% 66.18% 65.16% 85.77% 91.84% 87.66% 90.00% 86.70% 78.9% 77.5% 1.01% <-IRR #YR-> 4 5 yr Running Average #DIV/0!
5 year Running Average 71.27% 71.17% 79.79% 84.07% 88.41% 86.73% 0.00% 79.79% <-Median-> 5 Payout 5 yr Running Average
Price/AFFO Median 8.05 7.35 15.21 14.65 17.92 15.49 14.50 15.08 13.43 12.98 0.00 14.65 <-Median-> 9 P/AFFO Med
Price/AFFO High 13.14 10.56 17.50 15.99 18.98 17.03 15.49 16.80 15.20 13.47 0.00 15.99 <-Median-> 9 P/AFFO High
Price/AFFO Low 2.96 4.15 12.92 13.30 16.85 13.95 13.50 13.37 11.66 12.49 0.00 13.30 <-Median-> 9 P/AFFO Low
Price/AFFO Close 4.69 10.23 16.33 15.61 17.59 14.56 14.11 13.37 14.34 13.17 12.95 14.34 <-Median-> 9 P/AFFO Close
Trailing P/AFFO Close 9.74 12.87 19.55 16.17 15.62 14.78 13.02 14.91 14.78 13.17 14.85 <-Median-> 8 Trailing P/AFFO Close
Median Values DPR 10 Yrs 86.70% 5 Yrs 87.66% P/CF 5 Yrs in order 15.08 16.80 13.50 14.34 -12.68% Diff M/C -10.08% Diff M/C DPR 75% to 95% best
Adjusted Funds From Operations
-$1.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.56
-$1.49 $0.00 $0.00 $0.00 $0.00 $1.56
-$1.43 $0.00 $0.00 $0.00 $1.49
-$1.43 $0.00 $0.00 $0.00 $1.49
Distributable Income
FFO Diluted $1.72 $1.69 $1.72 $1.59 $1.40 $1.28 $1.57 $1.65 $1.79 $1.86 $1.92 $1.93 14.13% <-Total Growth 10 FFO Diluted
FFO* $1.73 $1.70 $1.73 $1.59 $1.52 $1.28 $1.70 $1.74 $1.82 $1.88 $1.95 $1.96 $1.89 $1.92 15.16% <-Total Growth 10 FFO Basic
Increase 20.00% -1.50% 1.70% -8.03% -4.52% -15.79% 32.81% 2.35% 4.60% 3.30% 3.72% 0.51% -3.57% 1.59% 1.42% <-IRR #YR-> 10 FFO 15.16%
FFO Yield 8.25% 7.07% 8.72% 21.37% 9.84% 6.59% 7.31% 7.22% 8.50% 8.65% 9.73% 8.76% 8.20% 8.33% 2.89% <-IRR #YR-> 5 FFO 15.29%
5 year Running Average $1.47 $1.54 $1.61 $1.64 $1.65 $1.57 $1.56 $1.57 $1.61 $1.68 $1.82 $1.87 $1.90 $1.92 1.95% <-IRR #YR-> 10 5 yr Running Average 21.27%
Payout Ratio 75.49% 78.14% 79.15% 90.45% 47.37% 61.52% 57.11% 67.53% 74.18% 71.81% 69.23% 69.01% 73.02% 71.88% 3.63% <-IRR #YR-> 5 5 yr Running Average 19.52%
5 year Running Average 83.50% 81.73% 80.39% 81.64% 74.51% 72.17% 67.60% 65.03% 62.08% 66.90% 68.16% 70.35% 71.39% 0.00% 69.25% <-Median-> 10 Payout 5 yr Running Average
Price/FFO Median 11.30 13.25 13.18 8.02 7.30 14.14 12.84 14.11 12.51 11.88 11.60 10.69 12.02 0.00 12.19 <-Median-> 10 Price/FFO Median
Price/FFO High 12.15 14.81 15.36 13.10 10.49 16.27 14.02 14.94 13.76 12.69 12.92 12.10 12.48 0.00 13.43 <-Median-> 10 Price/FFO High
Price/FFO Low 10.44 11.69 10.99 2.95 4.12 12.01 11.66 13.27 11.27 11.06 10.28 9.28 11.57 0.00 11.03 <-Median-> 10 Price/FFO Low
Price/FFO Close 12.12 14.15 11.46 4.68 10.16 15.18 13.68 13.85 11.76 11.56 10.28 11.41 12.20 12.01 11.51 <-Median-> 10 Price/FFO Close
Trailing P/FFO Close 14.55 13.94 11.66 4.30 9.70 12.78 18.17 14.18 12.30 11.94 10.66 11.47 11.76 12.20 11.80 <-Median-> 10 Trailing P/FFO Close
Median Values DPR 10 Yrs 69.12% 5 Yrs 69.23% P/CF 5 Yrs in order 11.88 12.92 11.06 11.56 2.70% Diff M/C 0.01% Diff M/C 10 DPR 75% to 95% best
Funds from Operations per share (started as Distributable Cash)
-$1.70 $0.00 $0.00 $0.00 $0.00 $1.96
-$1.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.87
-$1.56 $0.00 $0.00 $0.00 $0.00 $1.87
Earnings by O/S Shares $1.55 $1.22 $1.36 Earnings by O/S Shares
EPS Basic $0.91 $0.79 -$0.02 $0.71 $0.61 $1.19 -$0.16 $2.77 $1.31 $1.47 $1.23 $1.38 74.36% <-Total Growth 10 EPS Basic
EPS Diluted $0.90 $0.78 -$0.02 $0.71 $0.56 $1.19 -$0.16 $2.69 $1.25 $1.47 $1.12 $1.25 $1.51 $1.70 60.73% <-Total Growth 10 EPS Diluted
Increase -10.00% -13.33% -103% -8.97% -21.13% 112.50% -113.31% -1801% -53.71% 17.85% -23.80% 11.92% 20.44% 12.58% 4.86% <-IRR #YR-> 10 Earnings per Share 60.73%
Earnings Yield 4.30% 3.24% -0.10% 9.53% 3.62% 6.12% -0.68% 11.18% 5.83% 6.77% 5.59% 5.60% 6.55% 7.38% #NUM! <-IRR #YR-> 5 Earnings per Share 891.64%
5 yr Running Ave. $1.09 $1.01 $0.77 $0.67 $0.59 $0.64 $0.46 $1.00 $1.11 $1.29 $1.27 $1.56 $1.32 $1.41 4.38% <-IRR #YR-> 10 5 yr Running Average 53.57%
10 year Running Average $1.05 $0.96 $0.93 $0.87 $0.87 $0.74 $0.89 $0.89 $0.94 $0.96 $1.01 $1.16 $1.26 27.82% <-IRR #YR-> 5 5 yr Running Average 241.24%
* Net Income per share (Cdn GAAP) E/P 10 Yrs 5.72% 5Yrs 5.83%
-$0.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.25
$0.16 $0.00 $0.00 $0.00 $0.00 $1.25
-$1.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.56
-$0.46 $0.00 $0.00 $0.00 $0.00 $1.56
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.30 $1.33 $1.37 $1.44 $0.72 $0.79 $0.97 $1.18 $1.35 $1.35 $1.35 $1.35 $1.38 $1.38 $1.38 1.69% <-Total Growth 10 Dividends
Increase 4.86% 1.96% 3.01% 5.11% -50.00% 9.38% 23.28% 21.03% 14.89% 0.00% 0.00% 0.19% 2.03% 0.00% 0.00% Count 20 Years of data
5 year running Average $1.23 $1.26 $1.29 $1.34 $1.23 $1.13 $1.06 $1.02 $1.00 $1.13 $1.24 $1.32 $1.36 4.38% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 6.68% 5.90% 6.01% 11.27% 6.49% 4.35% 4.45% 4.79% 5.93% 6.05% 5.97% 6.46% 6.07% 5.99% <-Median 10 Dividends
Yield on High Price 6.21% 5.28% 5.15% 6.91% 4.52% 3.78% 4.07% 4.52% 5.39% 5.66% 5.36% 5.70% 5.85% 5.25% <-Median 10 Dividends
Yield on Low Price 7.23% 6.68% 7.20% 30.64% 11.50% 5.12% 4.90% 5.09% 6.58% 6.49% 6.73% 7.44% 6.31% 6.66% <-Median 10 Dividends
Yield on Close Price 6.23% 5.52% 6.91% 19.33% 4.66% 4.05% 4.17% 4.88% 6.31% 6.21% 6.73% 6.05% 5.99% 5.99% 5.99% 6.13% <-Median 10 Dividends
Payout Ratio EPS 144.93% 170.51% -6850% 202.82% 128.57% 66.18% -613.01% 43.61% 108.23% 91.83% 120.51% 107.88% #DIV/0! #DIV/0! #DIV/0! 99.86% <-Median 10 DPR EPS
DPR EPS 5 Yr Running 112.37% 124.29% 167.68% 198.47% 210.39% 175.39% 231.78% 101.94% 90.42% 87.43% 97.21% 84.48% 102.74% 0.00% #DIV/0! 134.81% <-Median 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 135.65% 92.43% 89.53% 86.72% 36.47% 47.32% 41.39% 41.49% 59.03% 48.43% 48.92% 90.96% 92.81% 48.68% <-Median 10 DPR CF
DPR CF 5 Yr Running 104.93% 101.71% 99.87% 96.07% 81.48% 68.31% 57.64% 48.62% 45.06% 47.27% 47.62% 54.12% 62.76% 55.88% <-Median 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 80.23% 76.14% 75.51% 84.47% 36.03% 47.48% 39.13% 42.16% 49.68% 46.50% 49.21% 50.46% 51.48% 48.35% <-Median 10 DPR CF WC
DPR CF WC 5 Yr Running 85.82% 81.55% 79.89% 78.43% 69.34% 63.29% 54.76% 47.92% 42.97% 44.90% 45.45% 47.56% 49.42% 51.34% <-Median 10 DPR CF WC 5 Yr Running
Median 5 Yr 5 Yr Med 5 Yr Cl 5.97% 6.21% 5 Yr Med Payout 107.88% 48.92% 49.21% 0.17% <-IRR #YR-> 10 Dividends
* Distributions per share 5 Yr Med and Cur. 0.34% -3.63% Last Div Inc ---> $0.1125 $0.1150 2.2% 6.86% <-IRR #YR-> 5 Dividends
-$1.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.35
-$0.97 $0.00 $0.00 $0.00 $0.00 $1.35
Historical Dividends Historical High Div 12.06% Low Div 4.07% Ave Div 8.07% Med Div 6.47% Close Div 6.43% Historical Dividends
High/Ave/Median Values Curr diff Exp. -50.36% 47.10% Exp. -25.77% Exp. -7.47% Exp. -6.88% High/Ave/Median
Future Dividend Yield Div Yd 6.94% earning in 5 Years at IRR of 3.00% Div Inc. 15.93% Future Dividend Yield
Future Dividend Yield Div Yd 8.05% earning in 10 Years at IRR of 3.00% Div Inc. 34.39% Future Dividend Yield
Future Dividend Yield Div Yd 9.33% earning in 15 Years at IRR of 3.00% Div Inc. 55.80% Future Dividend Yield
Yield if held 5 yrs 12.36% 10.31% 9.92% 9.73% 4.24% 4.03% 4.31% 5.15% 10.57% 12.16% 7.46% 6.20% 5.62% 6.06% 6.18% 6.83% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 12.26% 13.62% 6.64% 7.46% 7.53% 8.51% 9.12% 7.96% 6.92% 6.00% 6.05% 10.80% 12.43% 7.74% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 10.51% 12.77% 12.44% 12.80% 10.48% 9.99% 9.32% 8.13% 12.44% <-Median-> 5 Paid Median Price
Yield if held 20 yrs 12.35% 13.05% 12.72% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 58.16% 48.85% 46.87% 45.19% 36.33% 28.93% 23.45% 22.33% 39.17% 50.75% 34.23% 30.14% 27.63% 29.91% 30.65% 35.28% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 108.08% 118.09% 111.56% 111.69% 89.84% 83.75% 79.00% 69.52% 60.67% 52.62% 52.06% 92.49% 112.39% 86.80% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 153.66% 165.41% 163.48% 170.41% 140.83% 132.86% 125.03% 109.84% 163.48% <-Median-> 5 Paid Median Price
Cost covered if held 20 years 214.36% 229.83% 226.55% #NUM! <-Median-> 0 Paid Median Price
Graham No. FFO $21.44 $21.59 $21.01 $20.49 $18.97 $17.80 $22.80 $30.11 $30.85 $31.70 $32.73 $32.69 $32.10 $32.35 $0.00 51.44% <-Total Growth 10 GP using FFO
Price/GP Ratio Med 0.91 1.04 1.09 0.62 0.59 1.02 0.96 0.82 0.74 0.70 0.69 0.64 0.71 0.72 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 0.98 1.17 1.27 1.02 0.84 1.17 1.05 0.86 0.81 0.75 0.77 0.73 0.73 0.85 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.84 0.92 0.91 0.23 0.33 0.86 0.87 0.77 0.66 0.66 0.61 0.56 0.68 0.66 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 0.98 1.12 0.94 0.36 0.81 1.09 1.02 0.80 0.69 0.69 0.61 0.68 0.72 0.71 #DIV/0! 0.75 <-Median-> 10 Price/GP Ratio
Prem/Disc Close -2.28% 11.60% -5.59% -63.64% -18.56% 9.19% 2.00% -19.95% -30.63% -31.45% -38.73% -31.57% -28.19% -28.76% #DIV/0! -25.29% <-Median-> 10 Graham Price
Graham No. $15.47 $14.61 $13.46 $13.68 $11.52 $17.16 $19.08 $37.46 $25.54 $28.03 $24.80 $26.14 $28.69 $30.44 $0.00 78.92% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.26 1.54 1.69 0.93 0.96 1.05 1.14 0.66 0.89 0.80 0.91 0.80 0.79 0.92 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.36 1.72 1.98 1.52 1.38 1.21 1.25 0.69 0.98 0.85 1.02 0.91 0.82 1.11 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.17 1.36 1.41 0.34 0.54 0.90 1.04 0.62 0.80 0.74 0.81 0.70 0.76 0.77 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.35 1.65 1.47 0.54 1.34 1.13 1.22 0.64 0.84 0.78 0.81 0.86 0.80 0.76 #DIV/0! 0.85 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 35.41% 64.86% 47.42% -45.56% 34.17% 13.24% 21.91% -35.67% -16.20% -22.48% -19.16% -14.44% -19.67% -24.29% #DIV/0! -15.32% <-Median-> 10 Graham Price
Price Close $20.95 $24.09 $19.84 $7.45 $15.45 $19.43 $23.26 $24.10 $21.40 $21.73 $20.05 $22.37 $23.05 $23.05 $23.05 -7.14% <-Total Growth 10 Stock Price D. per yr 5.51% 5.72%
Increase 10.32% 14.99% -17.64% -62.45% 107.38% 25.76% 19.71% 3.61% -11.20% 1.54% -7.73% 11.57% 3.04% 0.00% 0.00% -0.74% <-IRR #YR-> 10 Stock Price 1.51%
P/E 23.28 30.88 -992.00 10.49 27.59 16.33 -146.87 8.94 17.16 14.78 17.90 17.84 15.26 13.56 #DIV/0! -0.78% <-IRR #YR-> 5 Stock Price -0.89%
Trailing P/E 20.95 26.77 25.44 -372.50 21.76 34.70 19.55 -152.18 7.94 17.42 13.64 19.97 18.39 15.26 13.56 4.31% <-IRR #YR-> 10 Price & Dividend 7.02%
Median 10, 5 Yrs D. per yr 5.04% 5.72% % Tot Ret 117.14% 115.71% Price Inc 1.54% P/E: 15.55 17.16 4.95% <-IRR #YR-> 5 Price & Dividend 4.84%
-$24.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.37
-$23.26 $0.00 $0.00 $0.00 $0.00 $22.37
-$24.09 $1.37 $1.44 $0.72 $0.79 $0.97 $1.18 $1.35 $1.35 $1.35 $23.72
-$23.26 $1.18 $1.35 $1.35 $1.35 $23.72
Price Median H/L $19.52 $22.55 $22.81 $12.78 $11.10 $18.10 $21.83 $24.55 $22.78 $22.33 $22.63 $20.95 $22.72 -7.10% <-Total Growth 10 Stock Price
Increase 15.03% 15.52% 1.15% -43.99% -13.11% 63.06% 20.58% 12.46% -7.21% -1.98% 1.34% -7.40% 8.45% -0.73% <-IRR #YR-> 10 Stock Price
P/E 21.69 28.91 -1140.50 17.99 19.82 15.21 -137.81 9.11 18.26 15.19 20.20 16.71 15.05 -0.82% <-IRR #YR-> 5 Stock Price
Trailing P/E 266.28 337.45 386.74 212.70 98.47 279.04 501.63 551.79 475.75 376.63 374.15 351.11 351.93 4.65% <-IRR #YR-> 10 Price & Dividend
P/E on Running 5 yr Average 17.88 22.24 29.55 18.95 18.94 28.11 47.83 24.56 20.58 17.32 17.75 13.45 17.21 5.29% <-IRR #YR-> 5 Price & Dividend
P/E on Running 10 yr Average 21.48 23.66 13.80 12.82 20.85 29.69 27.72 25.58 23.82 23.58 20.81 19.59 14.25 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 5.38% 6.10% % Tot Ret 115.77% 115.41% Price Inc -1.98% P/E: 15.96 16.71 Count 20 Years of data
-$22.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20.95
-$21.83 $0.00 $0.00 $0.00 $0.00 $20.95
-$22.55 $1.37 $1.44 $0.72 $0.79 $0.97 $1.18 $1.35 $1.35 $1.35 $22.30
-$21.83 $1.18 $1.35 $1.35 $1.35 $22.30
High Months Sep Dec Feb Feb Dec Oct Dec Aug May Apr Feb Aug Mar
Price High $21.00 $25.20 $26.59 $20.85 $15.94 $20.83 $23.83 $26.00 $25.04 $23.86 $25.20 $23.71 $23.58 -5.91% <-Total Growth 10 Stock Price
Increase 10.58% 20.00% 5.52% -21.59% -23.55% 30.68% 14.40% 9.11% -3.69% -4.71% 5.62% -5.91% -0.55% -0.61% <-IRR #YR-> 10 Stock Price
P/E 23.33 32.31 -1329.50 29.37 28.46 17.50 -150.47 9.65 20.07 16.23 22.50 18.91 15.62 -0.10% <-IRR #YR-> 5 Stock Price
Trailing P/E 21.00 28.00 34.09 -1042.50 22.45 37.20 20.03 -164.17 9.29 19.13 17.14 21.17 18.81 15.35 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -3.69% P/E: 18.21 18.91 23.17 P/E Ratio Historical High
-$25.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.71
-$23.83 $0.00 $0.00 $0.00 $0.00 $23.71
Low Months Mar/Oct Jun Dec Nov Mar Jan Oct Dec Aug Dec Dec Jan Jan
Price Low $18.04 $19.90 $19.03 $4.70 $6.26 $15.37 $19.82 $23.09 $20.51 $20.79 $20.05 $18.19 $21.86 -8.59% <-Total Growth 10 Stock Price
Increase 20.67% 10.31% -4.37% -75.30% 33.19% 145.53% 28.95% 16.50% -11.17% 1.37% -3.56% -9.28% 20.18% -0.89% <-IRR #YR-> 10 Stock Price
P/E 20.04 25.51 -951.50 6.62 11.18 12.92 -125.15 8.57 16.44 14.14 17.90 14.51 14.48 -1.70% <-IRR #YR-> 5 Stock Price
Trailing P/E 18.04 22.11 24.40 -235.00 8.82 27.45 16.66 -145.80 7.61 16.67 13.64 16.24 17.44 11.26 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -3.56% P/E: 12.05 14.51 7.94 P/E Ratio Historical Low
-$19.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.19
-$19.82 $0.00 $0.00 $0.00 $0.00 $18.19
Debt Long Term $2,464.0 $3,107.3 $3,213.5 $3,529.3 $3,532.0 $3,744.6 $4,974.7 $5,463.5 $6,429.9 $5,854.0 $6,088.0 $5,493.04 from G&M Fr TD 2014
CF/Debt Ratio 0.04 0.05 0.06 0.07 0.08 0.06 0.08 0.10 0.10 0.13 0.13 0.08 0.08 <-Median-> 10 CF/Debt Ratio
Long Term Debt $6,088.04 $5,493.04 Debt
Change -9.77% Change
Debt/Market Cap Ratio 1.09 0.86 0.97 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Yes, 0 Intangibles Goodwill
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/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 $2,318 $2,833 $2,549 $1,055 $2,222 $2,839 $4,014 $4,692 $5,777 $5,971 $5,606 $6,382 $6,576 $6,576 $6,576 125.25% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 142.040 164.863 170.294 183.676 210.176 273.450 299.464 303.651 310.072 #DIV/0! <-Total Growth 8 Diluted
Change 16.07% 3.29% 7.86% 14.43% 30.11% 9.51% 1.40% 2.11% 8.69% <-Median-> 8 Change
Basic # of Shares in Millions 141.655 147.946 149.786 159.607 188.847 259.458 288.871 293.026 298.404 #DIV/0! <-Total Growth 8 Basic
Change 4.44% 1.24% 6.56% 18.32% 37.39% 11.34% 1.44% 1.84% 5.50% <-Median-> 8 Change AFFO
Difference AFFO 0.0% -2.8% -2.4% 8.1% 3.1% 4.1% -4.9% -4.6% -4.4% -2.45% <-Median-> 9 Difference
Diluted # of Shares in Million 142.040 164.863 150.422 188.652 214.425 273.450 299.464 303.651 310.072 #DIV/0! <-Total Growth 8 Diluted
Change 16.07% -8.76% 25.42% 13.66% 27.53% 9.51% 1.40% 2.11% 11.59% <-Median-> 8 Change
Basic # of Shares in Millions 141.655 147.946 149.786 159.607 188.847 259.458 288.871 293.026 298.404 #DIV/0! <-Total Growth 8 Basic FFO
Change FFO 4.44% 1.24% 6.56% 18.32% 37.39% 11.34% 1.44% 1.84% 5.50% <-Median-> 8 Change
Difference 0.0% -2.8% -2.4% 8.1% 3.1% 4.1% -4.9% -4.6% -4.4% -2.45% <-Median-> 9 Difference
Diluted # of Shares in Million 103.055 117.146 132.003 142.040 160.262 150.422 299.464 303.651 310.072 164.69% <-Total Growth 7 Diluted none aft '10
Change 14.41% 13.67% 12.68% 7.60% 12.83% -6.14% -100.00% #DIV/0! #DIV/0! #DIV/0! 1.40% 2.11% #DIV/0! <-Median-> 7 Change
Basic # of Shares in Millions 95.430 109.390 124.190 134.995 142.508 144.349 154.170 183.410 247.717 288.871 276.796 282.216 157.99% <-Total Growth 10 Basic
Change 7.90% 14.63% 13.53% 8.70% 5.57% 1.29% 6.80% 18.97% 35.06% 16.61% -4.18% 1.96% 7.75% <-Median-> 10 Change
Difference 15.9% 7.5% 3.5% 4.9% 0.9% 1.2% 11.9% 6.1% 9.0% -4.9% -99.0% -100.2% 2.34% <-Median-> 10 Difference
# of Share in M 110.62 117.61 128.48 141.60 143.83 146.12 172.55 194.68 269.97 274.77 279.61 285.28 285.28 285.28 285.28 9.27% <-IRR #YR-> 10 Shares
Change 14.87% 6.31% 9.24% 10.21% 1.57% 1.60% 18.09% 12.82% 38.68% 1.78% 1.76% 2.03% 0.00% 0.00% 0.00% 10.58% <-IRR #YR-> 5 Shares
CF fr Op $M $106.38 $169.23 $196.59 $235.12 $283.94 $243.18 $404.73 $551.35 $617.39 $765.92 $771.54 $424.20 $424.20 <-12 mths 150.66% <-Total Growth 10 Cash Flow
Increase -19.44% 59.09% 16.17% 19.60% 20.76% -14.36% 66.43% 36.23% 11.98% 24.06% 0.73% -45.02% 0.00% <-12 mths Deb Conv. DRIP, S. Issues SO
5 year Running Average $100.9 $119.5 $141.2 $167.9 $198.3 $225.6 $272.7 $343.7 $420.1 $516.5 $622.2 $626.1 $600.6 <-12 mths 423.88% <-Total Growth 10 CF 5 Yr Running
CFPS $0.96 $1.44 $1.53 $1.66 $1.97 $1.66 $2.35 $2.83 $2.29 $2.79 $2.76 $1.49 $1.49 <-12 mths 3.34% <-Total Growth 10 Cash Flow per Share
Increase -29.86% 49.64% 6.34% 8.52% 18.89% -15.70% 40.94% 20.75% -19.25% 21.89% -1.01% -46.11% 0.00% <-12 mths 9.62% <-IRR #YR-> 10 Cash Flow 150.66%
5 year Running Average $1.17 $1.24 $1.30 $1.39 $1.51 $1.65 $1.83 $2.10 $2.22 $2.38 $2.60 $2.43 $2.16 <-12 mths 0.94% <-IRR #YR-> 5 Cash Flow 4.81%
P/CF on Med Price 20.30 15.67 14.91 7.69 5.62 10.88 9.31 8.67 9.96 8.01 8.20 14.09 15.28 0.33% <-IRR #YR-> 10 Cash Flow per Share 3.34%
P/CF on Closing Price 21.79 16.74 12.97 4.49 7.83 11.68 9.92 8.51 9.36 7.80 7.27 15.04 15.50 -8.71% <-IRR #YR-> 5 Cash Flow per Share -36.60%
72.51% Diff M/C 6.97% <-IRR #YR-> 10 CFPS 5 yr Running 96.16%
Excl.Working Capital CF $73.49 $36.21 $36.50 $6.26 $3.48 -$0.82 $23.39 -$8.83 $116.29 $31.82 -$4.52 $340.48 $340.48 <-12 mths 5.78% <-IRR #YR-> 5 CFPS 5 yr Running 32.46%
CF fr Op $M WC $179.87 $205.44 $233.09 $241.38 $287.42 $242.36 $428.12 $542.52 $733.68 $797.74 $767.02 $764.68 $764.68 <-12 mths 272.21% <-Total Growth 10 Cash Flow less WC
Increase 14.19% 14.22% 13.46% 3.56% 19.07% -15.68% 76.65% 26.72% 35.24% 8.73% -3.85% -0.30% 0.00% <-12 mths 14.05% <-IRR #YR-> 10 Cash Flow less WC 272.21%
5 year Running Average $126.3 $151.0 $177.2 $203.5 $229.4 $241.9 $286.5 $348.4 $446.8 $548.9 $653.8 $721.1 $765.6 <-12 mths 12.30% <-IRR #YR-> 5 Cash Flow less WC 78.61%
CFPS Excl. WC $1.63 $1.75 $1.81 $1.70 $2.00 $1.66 $2.48 $2.79 $2.72 $2.90 $2.74 $2.68 $2.68 <-12 mths 16.92% <-IRR #YR-> 10 CF less WC 5 Yr Run 377.48%
Increase -0.59% 7.44% 3.86% -6.04% 17.23% -17.00% 49.59% 12.32% -2.48% 6.83% -5.51% -2.29% 0.00% <-12 mths 20.28% <-IRR #YR-> 5 CF less WC 5 Yr Run 151.73%
5 year Running Average $1.43 $1.55 $1.62 $1.71 $1.78 $1.78 $1.93 $2.13 $2.33 $2.51 $2.73 $2.77 $2.74 <-12 mths 4.37% <-IRR #YR-> 10 CFPS - Less WC 53.45%
P/CF on Med Price 12.01 12.91 12.57 7.49 5.55 10.91 8.80 8.81 8.38 7.69 8.25 7.82 8.48 1.56% <-IRR #YR-> 5 CFPS - Less WC 8.04%
P/CF on Closing Price 12.89 13.79 10.94 4.37 7.73 11.71 9.37 8.65 7.87 7.48 7.31 8.35 8.60 6.00% <-IRR #YR-> 10 CFPS 5 yr Running 79.01%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 8.99 5 yr 8.67 P/CF Med 10 yr 8.31 5 yr 8.25 3.43% Diff M/C 7.45% <-IRR #YR-> 5 CFPS 5 yr Running 43.22%
-$1.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 Cash Flow per Share
-$2.35 $0.00 $0.00 $0.00 $0.00 $1.49 Cash Flow per Share
-$1.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.43 CFPS 5 yr Running
-$1.83 $0.00 $0.00 $0.00 $0.00 $2.43 CFPS 5 yr Running
-$205.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $764.7 Cash Flow less WC
-$428.1 $0.0 $0.0 $0.0 $0.0 $764.7 Cash Flow less WC
-$151.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $721.1 CF less WC 5 Yr Run
-$286.5 $0.0 $0.0 $0.0 $0.0 $721.1 CF less WC 5 Yr Run
-$1.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.68 CFPS - Less WC
-$2.48 $0.00 $0.00 $0.00 $0.00 $2.68 CFPS - Less WC
-$1.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.77 CFPS 5 yr Running
-$1.93 $0.00 $0.00 $0.00 $0.00 $2.77 CFPS 5 yr Running
Interest paid -$299.53 for 2016?
Change in other non-cash operating items -$116.29 -$31.82 $4.52 -$40.95 and Google
       
Sum -$116.29 -$31.82 $4.52 -$340.48
Google -$116.29 -$31.82 $4.52 -$340.48
Difference $0.00 $0.00 $0.00 $0.00
OPM 21.8% 32.0% 33.8% 38.4% 46.4% 39.3% 61.6% 66.0% 54.3% 62.4% 64.9% 35.5% 10.93% <-Total Growth 10 OPM
Increase -32.25% 46.73% 5.62% 13.79% 20.86% -15.30% 56.62% 7.13% -17.74% 14.88% 4.08% -45.37% Should increase or be stable.
Diff from Ave. -56.7% -36.5% -33.0% -23.7% -7.8% -21.9% 22.3% 31.0% 7.8% 23.8% 28.9% -29.6% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 50.37% 5 Yrs 62.38% should be zero, it is a check on calculations
Current Assets $121.4 $131.2 $231.3 $304.7 $157.6 $226.2 $201.0 $82.5 $35.8 $92.6 $165.3 Liq ratio of 1.5 and up, best From
Current Liabilities $130.4 $400.0 $242.1 $180.3 $259.4 $175.8 $176.5 $168.0 $144.2 $172.8 $212.5 0.69 <-Median-> 10 Ratio G&M
Liquidity 0.93 0.33 0.96 1.69 0.61 1.29 1.14 0.49 0.25 0.54 0.78 0.54 <-Median-> 5 Ratio
Liq. with CF aft div 1.03 0.38 1.08 2.69 1.10 2.64 2.97 2.00 2.99 2.82 0.96 2.82 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.14 0.17 0.56 1.19 0.59 1.15 0.48 0.76 2.99 1.05 0.95 0.95 <-Median-> 5 Ratio
Assets $3,826.8 $4,779.0 $5,050.8 $5,440.0 $5,351.1 $5,531.5 $7,637.8 $10,171.8 $13,583.0 $13,368.4 $13,990.3 $14,155.0 Debt Ratio of 1.5 and up, best
Liabilities $2,519.1 $3,235.2 $3,490.9 $3,704.3 $3,762.3 $3,847.6 $5,291.9 $5,664.8 $7,309.2 $6,840.7 $7,165.4 $7,242.4 1.63 <-Median-> 10 Ratio
Debt Ratio 1.52 1.48 1.45 1.47 1.42 1.44 1.44 1.80 1.86 1.95 1.95 1.95 1.95 <-Median-> 5 Ratio
Total Book Value $1,307.7 $1,430.9 $1,559.8 $1,735.6 $1,588.8 $1,683.9 $2,345.9 $4,507.0 $6,273.8 $6,527.7 $6,824.9 $6,912.7 Total Book Value
Non-Contro. Int. $103.21 $75.80 $75.1 $77.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 NCI
Book Value $1,307.7 $1,430.9 $1,456.6 $1,659.8 $1,513.7 $1,606.7 $2,345.9 $4,507.0 $6,273.8 $6,527.7 $6,824.9 $6,912.7 $6,912.7 $6,912.7 $6,912.7 383.08% <-Total Growth 10 Book Value
Book Value per Share $11.82 $12.17 $11.34 $11.72 $10.52 $11.00 $13.59 $23.15 $23.24 $23.76 $24.41 $24.23 $24.23 $24.23 $24.23 99.16% <-Total Growth 10 Book Value per Share
Change 3.82% 2.92% -6.81% 3.39% -10.22% 4.48% 23.64% 70.29% 0.38% 2.23% 2.75% -0.73% 0.00% 0.00% 0.00% -12.72% P/B Ratio Current/Historical Median
P/B Ratio (Median) 1.65 1.85 2.01 1.09 1.05 1.65 1.61 1.06 0.98 0.94 0.93 0.86 1.09 P/B Ratio Historical Median
P/B Ratio (Close) 1.77 1.98 1.75 0.64 1.47 1.77 1.71 1.04 0.92 0.91 0.82 0.92 0.95 0.95 0.95 7.13% <-IRR #YR-> 10 Book Value per Share 99.16%
Change 6.26% 11.72% -11.62% -63.68% 130.98% 20.37% -3.18% -39.16% -11.54% -0.67% -10.20% 12.39% 3.04% 0.00% 0.00% 12.25% <-IRR #YR-> 5 Book Value per Share 78.24%
Leverage (A/BK) 2.93 3.34 3.24 3.13 3.37 3.28 3.26 2.26 2.17 2.05 2.05 2.05 2.70 <-Median-> 10 A/BV
Debt/Equity Ratio 1.93 2.26 2.24 2.13 2.37 2.28 2.26 1.26 1.17 1.05 1.05 1.05 1.70 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.06 5 yr Med 0.94 1.23% Diff M/C 2.40 Historical Leverage (A/BK)
-$12.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24.23
-$13.59 $0.00 $0.00 $0.00 $0.00 $24.23
Comprehensive Income $90.94 -$58.82 $164.54 $75.35 $165.72 -$22.68 $493.86 $377.10 $515.19 $567.61 $350.38 285.29% <-Total Growth 10 Comprehensive Income
Increase -164.68% 379.75% -54.21% 119.94% -113.69% 2277.42% -23.64% 36.62% 10.17% -38.27% 10.17% <-Median-> 5 Comprehensive Income
5 Yr Running Average $87.55 $64.82 $175.36 $217.87 $305.84 $386.22 $460.83 14.44% <-IRR #YR-> 10 Comprehensive Income 285.29%
ROE 6.4% -3.8% 9.5% 4.7% 9.8% -1.0% 11.0% 6.0% 7.9% 8.3% 5.1% #NUM! <-IRR #YR-> 5 Comprehensive Income 1644.81%
5Yr Median 6.4% 4.7% 9.5% 6.0% 7.9% 7.9% 7.9% 31.89% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 5.2% 2404.5% 59.7% -17.0% -8.3% -10.3% -2.9% 16.5% 21.3% 66.9% -9.9% 48.03% <-IRR #YR-> 5 5 Yr Running Average 610.92%
Median Values Diff 5, 10 yr 6.8% 16.5% 7.9% <-Median-> 5 Return on Equity
-$90.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $350.4
$22.7 $0.0 $0.0 $0.0 $0.0 $350.4
-$87.5 $0.0 $0.0 $0.0 $0.0 $0.0 $460.8
-$64.8 $0.0 $0.0 $0.0 $0.0 $460.8
Current Liability Coverage Ratio 1.58 0.58 1.00 1.59 0.93 2.43 3.07 4.37 5.53 4.44 3.60 CFO / Current Liabilities
5 year Median 1.00 1.00 1.59 2.43 3.07 4.37 4.37 275.4% <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 4.70% 4.30% 4.61% 4.44% 5.37% 4.38% 5.61% 5.33% 5.40% 5.97% 5.48% 5.40% CFO / Total Assets
5 year Median 4.77% 4.70% 4.61% 4.61% 4.61% 4.44% 4.61% 5.33% 5.37% 5.40% 5.48% 5.40% 5.4% <-Median-> 10 Return on Assets
Return on Assets ROA 2.3% 1.8% 0.0% 1.8% 1.6% 3.1% -0.3% 5.0% 2.4% 3.2% 2.4% 2.7% Net Income/Assets Return on Assets
5Yr Median 3.4% 2.7% 2.3% 1.8% 1.8% 1.8% 1.6% 1.8% 2.4% 3.1% 2.4% 2.7% 2.4% <-Median-> 10 Asset Efficiency Ratio
Return on Equity ROE 6.6% 6.0% -0.2% 5.9% 5.7% 10.7% -1.1% 11.3% 5.2% 6.5% 5.0% 5.6% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 9.1% 8.1% 6.6% 6.0% 5.9% 5.9% 5.7% 5.9% 5.7% 6.5% 5.2% 5.6% 5.7% <-Median-> 10 Return on Equity
Net Income $86.7 $86.4 -$2.2 $98.5 $86.5 $172.3 -$25.3 $508.9 $323.6 $424.7 $340.1 $388.7 349.74% <-Total Growth 10 Net Income
Increase -2.40% -0.25% -102.54% -4593% -12.18% 99.19% -114.67% -2113% -36.40% 31.21% -19.90% 14.29% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $83.7 $87.3 $70.0 $71.6 $71.2 $88.3 $66.0 $168.2 $213.2 $280.8 $314.4 $397.2 16.22% <-IRR #YR-> 10 Net Income 349.74%
Operating Cash Flow $106.4 $169.2 $196.6 $235.1 $283.9 $243.2 $404.7 $551.4 $617.4 $765.9 $771.5 $424.2 #NUM! <-IRR #YR-> 5 Net Income 1637.94%
Investment Cash Flow -$367.2 -$817.3 -$519.6 -$228.9 -$227.0 -$227.0 -$227.0 -$907.6 -$271.6 $131.7 -$290.8 -$1.2 16.36% <-IRR #YR-> 10 5 Yr Running Ave. 355.05%
Total Accruals $347.52 $734.46 $320.85 $92.28 $29.60 $156.19 -$202.99 $865.10 -$22.14 -$472.92 -$140.59 -$34.20 43.19% <-IRR #YR-> 5 5 Yr Running Ave. 501.95%
Total Assets $3,826.8 $4,779.0 $5,050.8 $5,440.0 $5,351.1 $5,531.5 $7,637.8 $10,171.8 $13,583.0 $13,368.4 $13,990.3 $14,155.0 Balance Sheet Assets
Accruals Ratio 9.08% 15.37% 6.35% 1.70% 0.55% 2.82% -2.66% 8.50% -0.16% -3.54% -1.00% -0.24% -0.24% <-Median-> 5 Ratio
EPS/CF Ratio 0.55 0.45 -0.01 0.42 0.28 0.72 -0.06 0.97 0.46 0.51 0.41 0.47 0.44 <-Median-> 10 EPS/CF Ratio
-$86.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $388.7
$25.3 $0.0 $0.0 $0.0 $0.0 $388.7
-$87.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $397.2
-$66.0 $0.0 $0.0 $0.0 $0.0 $397.2
Change in Close 10.32% 14.99% -17.64% -62.45% 107.38% 25.76% 19.71% 3.61% -11.20% 1.54% -7.73% 11.57% 3.04% 0.00% 0.00% Count 21 Years of data
up/down down down down down down Count 11 52.38%
Meet Prediction? yes Yes Yes % right Count 5 45.45%
Financial Cash Flow $263.54 $654.54 $331.91 -$8.76 $79.90 $79.90 $79.90 $477.10 -$449.35 -$901.71 -$466.20 -$413.22 C F Statement Financial CF
Total Accruals $83.98 $79.92 -$11.06 $101.04 -$50.30 $76.29 -$282.89 $388.00 $427.21 $428.78 $325.62 $379.01 Accruals
Accruals Ratio 2.19% 1.67% -0.22% 1.86% -0.94% 1.38% -3.70% 3.81% 3.15% 3.21% 2.33% 2.68% 3.15% <-Median-> 5 Ratio
ROE on AFFO 13.8% 14.8% 11.1% 10.1% 5.7% 6.1% 6.8% 6.4% 6.7% AFFO/Shareholders' equity ROE
5Yr Median 11.1% 10.1% 6.8% 6.4% 6.4% 6.4% <-Median-> 5 ROE
ROE on FFO 13.5% 13.8% 15.6% 13.6% 14.9% 11.9% 11.6% 7.3% 7.5% 8.3% 8.4% 8.5% FFO/Shareholders' equity ROE
5Yr Median 12.7% 13.5% 13.6% 13.8% 13.8% 13.6% 11.9% 11.6% 8.3% 8.3% 8.3% 8.3% <-Median-> 5 ROE
Adj Funds from Operations $228.3 $223.4 $178.5 $237.5 $258.6 $382.0 $445.1 $439.4 $464.5 103.44% <-Total Growth 8 AFFO
Increase -2.17% -20.09% 33.03% 8.89% 47.71% 16.52% -1.27% 5.72% 9.28% <-IRR #YR-> 8 Net Income
5 Yr Running Average $225.3 $256.0 $300.3 $352.5 $397.9 14.36% <-IRR #YR-> 5 Net Income
Funds from Operations $176.9 $198.1 $227.1 $225.5 $225.2 $191.9 $271.9 $329.0 $472.8 $543.0 $569.9 $584.3 194.99% <-Total Growth 10 FFO
Increase 36.54% 11.95% 14.64% -0.70% -0.14% -14.76% 41.67% 20.99% 43.72% 14.84% 4.97% 2.52% 11.42% <-IRR #YR-> 10 Net Income
5 Yr Running Average $142.2 $168.0 $191.4 $210.5 $213.5 $228.3 $248.7 $298.1 $361.7 $437.3 $499.8 16.53% <-IRR #YR-> 5 Net Income
-$228.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $464.5
-$237.5 $0.0 $0.0 $0.0 $0.0 $464.5
-$198.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $584.3
-$271.9 $0.0 $0.0 $0.0 $0.0 $584.3
Cash $10.73 $13.61 $134.47 $27.88 $23.76 $38.29 $48.02 Cash
Cash per Share $0.07 $0.08 $0.69 $0.10 $0.09 $0.14 $0.17 $0.14 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.38% 0.34% 2.87% 0.48% 0.40% 0.68% 0.75% 0.68% <-Median-> 5 % of Stock Price
Taxes
Foreign 10.15% 13.12% 12.69% 8.87% 0.00% 0.00% 2.29% 14.79% 11.65% 12.47% 7.34% 17.95% 10.26% <-Median-> 10 Foreign
Dividends 0.00% 0.00% 0.00% 0.00% 0.00% 0.07% 0.07% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% <-Median-> 10 Dividends
Cap Gain 3.93% 5.44% 4.38% 11.00% 22.13% 11.87% 3.85% 0.00% 6.53% 46.52% 13.95% 48.99% 11.44% <-Median-> 10 Cap Gain
Other Income 24.29% 35.66% 38.52% 39.80% 77.78% 54.02% 40.96% 28.37% 31.44% 30.96% 38.12% 25.23% 38.32% <-Median-> 10 Other Income
Ret of Cap. 61.62% 45.78% 44.41% 40.33% 0.09% 34.04% 52.90% 56.84% 50.37% 10.05% 40.58% 7.83% 40.45% <-Median-> 10 Ret of Cap.
Total 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.07% 100.00% 100.00% 100.00% 100.00% 100.00%
Notes:
March 3, 2017. Last estimates were for 2016 and 2017 of $1336M and $1360M for Revenue, $1.71 and $1.75 for AFFO, $1.91 and $1.96 for FFO, $1.50 and $1.96 for EPS
March 6, 2016. Last estimates were for 2015 and 2016 of $1344M and $1356Mfor Revenue, $1.66 and $1.75 for AFFO, $1.85 and $1.95 for FFO, $1.76 and $1.82 for EPS.
March 14, 2015. Last estimates were for 2014, 2015 and 2016 of $1326M, $1344M and $1336M for Revenue, $1.65, $1.66 and $1.75 AFFO, $1.86, $1.85 and $1.95 for FFO, $1.46, $1.76 and $1.82 for EPS.
December 7, 2014. Last estimates were for 2013, 2014 and 2015 of $1181.46M, $1269.44M and $1298M for Revenue, $1.44, $1.57 and $1.59 for AFFO, $1.76, $1.80 and $1.81 for FFO, $2.20 CFPS for 2013.
I got EPS for 2014, 2015 and 2016 from TD Waterhouse Earnings. These are basic rather than diluted earnings.
December 8, 2013. Last estimates were for 2012 and 2013 of $829.56M and $924.7M for Revenue, $1.34 and $1.56 (and $1.73 for 2014) for AFFO, $1.62 and $1.75 for FFO and $.24 and $.24 for EPS.
Dec 2, 2012. Last estimates were for 2011 and 2012 of $646M and $778M for Revenue, $1.51 and $1.56 for FFO, $0.29 and $0.23 for EPS.
Dec 4, 2011. Last estimates I got for 2010 and 2011 were $1.27 and $1.51 for FFO, $.54 and $.58 for EPS. Company lost money in March 2011 and this accts for low EPS for 2011.
Concerning earning estimates. It would appear that a tax write off will increase the earnings for 2010 up to about $1.22, which does not really reflect what they will earn. I have lowered estimate
Nov 29, 2010. When I last looked at this stock, I got 2009 and 2010 estimates of $1.47 for 1.53 for FFO, $.50 and $.52 for earnings $1.21 and $1.08 for Cash Flow.
In 2008, This REIT announced it will reduce its monthly cash distributions to unitholders by half to $0.06 per unit commencing with the January 2009 distribution. The cash flow retained from the reduced
distribution will be used to finance construction of The Bow, an H&R's development project in Calgary. The Bow is a 58 story office tower.
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 a good dividend and growth at or above the rate of inflation.
Would I buy this company and Why.
I would consider this company if I was looking for another REIT or Real Estate Investment.
Dividends
Dividends are paid monthly. Dividend generally are for shareholders of record in mid month to be paid at the end of the month.
For example, the dividend for shareholders of record for November 15, 2013 was paid on November 29, 2013.
Why am I following this stock.
Before I started blogging, I was following a number of REITs and this is one I had followed. It also used to be on a dividend list I followed.
How they make their money.
H&R Real Estate Investment trust is an open-ended real estate investment trust.
They have a portfolio of office properties, single-tenant industrial properties, retail properties and development projects. They operate across Canada and US.
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 Dec 11 2012 Dec 13 2013 Dec 07 2014 Mar 14 2015 Mar 06 2016 Mar 03 2017
Hofstedter, Thomas J. 3.21 1.65% 4.002 1.48% 3.363 1.22% 4.125 1.48% 3.386 1.19% 3.448 1.21%
CEO - Shares - Amount $77.258 $85.638 $73.081 $82.703 $75.734 $79.483
Options - percentage 1.13 0.58% 1.675 0.62% 1.716 0.62% 2.352 0.84% 5.830 2.04% 5.830 2.04%
Options - amount $27.113 $35.845 $37.292 $47.149 $130.426 $134.391
Reuters Options Value 2.240 $16.478
Froom, Larry 0.01 0.01% 0.021 0.01% 0.018 0.01% 0.022 0.01% 0.027 0.01% 0.052 0.02%
CFO - Shares - Amount $0.300 $0.442 $0.401 $0.451 $0.611 $1.188
Options - percentage 0.55 0.28% 0.812 0.30% 0.788 0.29% 1.145 0.41% 2.856 1.00% 2.801 0.98%
Options - amount $13.294 $17.381 $17.117 $22.967 $63.893 $64.567
Fried, Cheryl 0.00 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Officer - Shares - Amount $0.000 $0.000 $0.000 $0.000 $0.000 $0.000
Options - percentage 0.13 0.07% 0.183 0.07% 0.250 0.09% 0.303 0.11% 0.608 0.21% 0.601 0.21%
Options - amount $3.213 $3.923 $5.434 $6.067 $13.606 $13.844
Dickson, Robert Earl 0.031 0.01% 0.024 0.01% 0.024 0.01% 0.026 0.01% 0.026 0.01%
Director - Shares - Amount $0.665 $0.525 $0.485 $0.573 $0.591
Options - percentage 0.154 0.06% 0.159 0.06% 0.163 0.06% 0.152 0.05% 0.157 0.06%
Options - amount $3.302 $3.451 $3.275 $3.404 $3.623
Rutman, Ronald C. 1.21 0.62% 1.236 0.45% 1.391 0.50% 1.272 0.45% 1.292 0.45% G&M said he is Chairman
Chairman - Shares - Amt $29.096 $26.865 $27.881 $28.450 $29.776 H&R does not mention a
Options - percentage 0.89 0.46% 0.159 0.06% 0.009 0.00% 0.169 0.06% 0.174 0.06% Chairman
Options - amount $21.348 $3.451 $0.182 $3.777 $4.007 Reuters says he is Chairman
H&R Portfolio Limited Partnership 6.97 3.58% 6.975 2.54% 6.975 2.49%
10% Holder $168.087 $151.557 $139.840
Increase in O/S Shares 0.311 0.16% 0.499 0.26% 0.023 0.01% 0.194 0.07% 0.072 0.03% 0.100 0.04%
due to SO $7.238 $12.021 $0.482 $4.209 $1.447 $2.244
Book Value $0.000 $3.181 $1.136 $1.178
Insider Buying $0.000 -$1.164 -$1.061 -$0.906
Insider Selling $0.000 $4.153 $0.344 $3.209
Net Insider Selling $3.647 $2.990 -$0.717 $2.303
% of Market Cap 0.06% 0.05% -0.01% 0.04%
Directors 3 5 5 5 6
Women 0 0% 0 0% 0 0% 0 0% 0 0%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 145 45.57% 127 38.34% 161 35.61% 130 26.77% 169 27.18% 185 26.46%
Total Shares Held 88.47 45.44% 103.250 38.24% 97.628 35.53% 73.598 26.78% 76.132 26.69% 75.615 26.51%
Increase/Decrease -1.56 -1.73% 3.299 3.30% 2.257 2.37% 2.065 2.89% -4.300 -5.35% -6.408 -7.81%
Starting No. of Shares 90.03 99.951 95.371 71.532 80.432 82.022
Copyright 2008 Website of SPBrunner. All rights reserved.