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/ 9/30/17
First Capital Realty TSX: FCR OTC: FCRGF www.firstcapitalrealty.ca Fiscal Yr: Dec 31 Q3 2017
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 Total G
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$690.0 <-12 mths 2.03%
Revenue* $268.6 $332.9 $382.9 $419.6 $447.7 $490.1 $526.7 $583.1 $631.6 $648.4 $656.6 $676.3 $705 $730 $783 103.15% <-Total Growth 10 Revenue
Increase 21.28% 23.92% 15.03% 9.58% 6.70% 9.46% 7.48% 10.70% 8.32% 2.67% 1.26% 2.99% 4.25% 3.55% 7.26% 7.35% <-IRR #YR-> 10 Revenue 103.15%
5 year Running Average $183.2 $221.6 $272.7 $325.1 $370.4 $414.7 $453.4 $493.5 $535.9 $576.0 $609.3 $639.2 $663.6 $683.3 $710.2 5.13% <-IRR #YR-> 5 Revenue 28.39%
Revenue per Share $2.38 $2.76 $3.00 $2.91 $2.91 $3.00 $2.96 $2.82 $3.03 $3.00 $2.91 $2.78 $2.89 $2.99 $3.21 11.17% <-IRR #YR-> 10 5 yr Running Average 188.44%
Increase -11.31% 16.26% 8.70% -3.01% 0.02% 2.90% -1.43% -4.48% 7.38% -1.14% -2.85% -4.61% 4.05% 3.55% 7.26% 7.11% <-IRR #YR-> 5 5 yr Running Average 40.98%
5 year Running Average $3.55 $2.96 $2.72 $2.75 $2.79 $2.92 $2.96 $2.92 $2.94 $2.96 $2.94 $2.91 $2.92 $2.91 $2.96 0.05% <-IRR #YR-> 10 Revenue per Share 0.51%
P/S (Price/Sales) Med 5.53 5.74 5.53 4.38 3.86 4.90 5.47 6.55 6.01 6.11 6.41 7.38 -1.24% <-IRR #YR-> 5 Revenue per Share -6.03%
P/S (Price/Sales) Close 6.05 6.28 5.00 4.07 4.65 5.04 5.85 6.67 5.84 6.23 6.30 7.44 7.23 6.98 7.28 -0.17% <-IRR #YR-> 10 5 yr Running Average -1.68%
*Property Rental Revenue in M CDN$ P/S Med 10 yr 5.77 5 yr 6.41 25.31% Diff M/C -0.33% <-IRR #YR-> 5 5 yr Running Average -1.65%
-$332.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $676.3
-$526.7 $0.0 $0.0 $0.0 $0.0 $676.3
-$221.6 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $639.2
-$453.4 $0.0 $0.0 $0.0 $0.0 $639.2
-$2.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.78
-$2.96 $0.00 $0.00 $0.00 $0.00 $2.78
-$2.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.91
-$2.96 $0.00 $0.00 $0.00 $0.00 $2.91
ACFO
AFFO $0.85 $0.88 $0.91 $0.93 $0.87 $0.91 $0.92 $0.97 $1.01 $1.03 $0.99 $1.08 $1.14 $1.18 16.47% <-Total Growth 10 AFFO fr TD Bank
Increase 3.68% 3.55% 1.37% -5.95% 4.60% 1.10% 5.43% 4.12% 1.98% -3.88% 9.09% 5.56% 3.51% 1.54% <-IRR #YR-> 10 AFFO 16.47% replaced by
AFFO Yield 4.9% 5.9% 7.7% 6.8% 5.8% 5.3% 4.9% 5.5% 5.4% 5.6% 4.8% 5.2% 5.5% 5.0% 1.70% <-IRR #YR-> 5 AFFO 8.79% ACFO '17
5 year Running Average $0.89 $0.90 $0.91 $0.92 $0.94 $0.97 $0.98 $1.02 $1.05 $1.08 1.73% <-IRR #YR-> 6 5 yr Running Average #DIV/0!
Payout Ratio 89.71% 88.65% 87.67% 86.49% 91.95% 87.91% 89.13% 86.60% 83.66% 83.50% 86.87% 79.63% 75.44% 72.88% 1.81% <-IRR #YR-> 5 5 yr Running Average 9.36%
5 year Running Average 90.12% 88.91% 90.36% 91.40% 90.28% 88.84% 87.40% 84.65% 81.90% 79.34% 90.12% <-Median-> 7 Payout 5 yr Running Average
Price/AFFO Median 18.67 18.85 13.99 12.17 16.87 17.77 20.09 18.79 18.12 18.13 20.70 18.92 0.10 0.00 18.12 <-Median-> 10 P/AFFO Med
Price/AFFO High 20.43 20.67 16.71 14.74 18.31 19.09 21.28 20.53 19.23 19.66 23.45 19.76 0.00 0.00 19.44 <-Median-> 10 P/AFFO High
Price/AFFO Low 16.91 17.03 11.27 9.60 15.44 16.45 18.90 17.05 17.02 16.59 17.94 18.07 0.00 0.00 16.81 <-Median-> 10 P/AFFO Low
Price/AFFO Close 20.43 17.04 12.99 14.64 17.37 19.01 20.46 18.26 18.48 17.82 20.88 19.35 18.33 19.81 18.04 <-Median-> 10 P/AFFO Close
Trailing P/AFFO Close 20.43 17.04 12.99 14.64 17.37 19.01 20.46 18.26 18.48 17.82 20.88 19.35 18.33 19.81 18.04 <-Median-> 10 Trailing P/AFFO Close
Median Values DPR 10 Yrs 87.27% 5 Yrs 86.60% P/CF 5 Yrs in order 18.79 20.53 17.05 18.48 3.00% Diff M/C 6.77% Diff M/C 10 DPR 75% to 95% best
* Adjusted Funds From Operations
$1.13 <-12 mths 1.80%
Distributable Cash FFO $0.93 $0.99 $1.00 $1.04 $1.01 $0.98 $0.96 $1.00 $1.03 $0.98 $0.99 $1.11 $1.17 $1.24 $1.30 12.41% <-Total Growth 10 FFO
Increase 0.68% 6.76% 1.27% 3.75% -2.41% -3.21% -2.04% 4.17% 3.00% -4.85% 1.02% 12.12% 5.41% 5.98% 4.84% 1.18% <-IRR #YR-> 10 FFO 12.41%
FFO Yield 6.4% 5.7% 6.7% 8.8% 7.5% 6.5% 5.5% 5.3% 5.8% 5.3% 5.4% 5.4% 5.6% 5.9% 5.6% 2.95% <-IRR #YR-> 5 FFO 15.63%
5 year Running Average $0.91 $0.91 $0.94 $0.97 $0.99 $1.00 $1.00 $1.00 $1.00 $0.99 $0.99 $1.02 $1.06 $1.10 $1.16 1.17% <-IRR #YR-> 10 5 yr Running Average 12.31%
Payout Ratio 81.08% 77.22% 78.13% 77.11% 79.01% 81.63% 83.33% 82.00% 81.55% 86.22% 86.87% 77.48% 73.50% 69.35% 66.15% 0.48% <-IRR #YR-> 5 5 yr Running Average 2.40%
5 year Running Average 82.53% 83.79% 83.22% 82.16% 80.60% 79.72% 80.16% 82.16% 84.30% 85.35% 86.69% 84.15% 81.44% 78.32% 74.01% 82.69% <-Median-> 10 Payout 5 yr Running Average
Price/FFO Median 14.22 16.07 16.61 12.31 11.12 14.98 16.84 18.49 17.69 18.68 18.86 18.46 17.46 0.10 0.00 17.27 <-Median-> 10 P/FFO Med
Price/FFO High 16.11 17.58 18.22 14.70 13.47 16.26 18.09 19.58 19.33 19.82 20.45 20.92 18.24 0.00 0.00 18.77 <-Median-> 10 P/FFO High
Price/FFO Low 12.33 14.56 15.01 9.92 8.77 13.71 15.59 17.39 16.06 17.54 17.26 16.00 16.68 0.00 0.00 15.80 <-Median-> 10 P/FFO Low
Price/FFO Close 15.54 17.58 15.01 11.43 13.37 15.42 18.02 18.82 17.19 19.04 18.54 18.62 17.86 16.85 17.98 17.61 <-Median-> 10 P/FFO Close
Trailing P/FFO Close 15.65 18.77 15.20 11.86 13.05 14.92 17.65 19.60 17.71 18.12 18.72 20.88 18.83 17.86 18.85 17.68 <-Median-> 10 Trailing P/FFO Close
Median Values DPR 10 Yrs 81.59% 5 Yrs 82.00% P/CF 5 Yrs in order 18.49 19.82 17.26 18.62 -3.36% Diff M/C 3.44% Diff M/C 10 DPR 75% to 95% best
* Funds From Operations
$2.48 <-12 mths 55.97%
EPS Basic $0.45 $0.39 $0.24 $0.27 $0.28 $0.26 $2.99 $2.08 $1.03 $0.93 $0.91 $1.62 315.38% <-Total Growth 10 EPS Basic
EPS Diluted $0.31 $0.39 $0.24 $0.27 $0.28 $0.26 $2.75 $1.98 $1.01 $0.92 $0.91 $1.59 $2.32 $0.81 310.32% <-Total Growth 10 EPS Diluted
Increase 11.11% 24.00% -37.10% 10.26% 4.65% -7.56% 957.69% -28.00% -48.99% -8.91% -1.09% 74.73% 45.91% -65.09% 15.16% <-IRR #YR-> 10 Earnings per Share 310.32%
Earnings Yield 2.2% 2.2% 1.6% 2.3% 2.1% 1.7% 15.9% 10.5% 5.7% 4.9% 5.0% 7.7% 11.1% 3.9% -10.38% <-IRR #YR-> 5 Earnings per Share -42.18%
5 year Running Average $0.46 $0.40 $0.36 $0.30 $0.30 $0.29 $0.76 $1.11 $1.26 $1.38 $1.51 $1.28 $1.35 $1.31 12.28% <-IRR #YR-> 10 5 yr Running Average 218.51%
10 year Running Average $0.19 $0.19 $0.19 $0.19 $0.22 $0.37 $0.58 $0.73 $0.78 $0.84 $0.90 $1.02 $1.23 $1.28 11.00% <-IRR #YR-> 5 5 yr Running Average 68.52%
* ESP per share E/P 10 Yrs 4.94% 5Yrs 5.70%
-$0.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.59
-$2.75 $0.00 $0.00 $0.00 $0.00 $1.59
-$0.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.28
-$0.76 $0.00 $0.00 $0.00 $0.00 $1.28
Special Dividend $0.13 $0.00 $0.00 $0.00 $0.28 $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
Pre-split 2010 $1.22 $1.25 $1.28 $1.28
Pre-split 2010 $0.1875 $0.1938 $0.20
Dividend* $0.75 $0.76 $0.78 $0.80 $0.80 $0.80 $0.80 $0.82 $0.84 $0.85 $0.86 $0.86 $0.86 $0.86 $0.86 12.79% <-Total Growth 10 Dividends
Increase 4.17% 1.67% 2.46% 2.40% 0.00% 0.00% 0.00% 2.50% 2.44% 0.60% 1.78% 0.00% 0.00% 0.00% 0.00% Count 23 Increase
Average Increases 5 Year Running 6.1% 5.0% 2.8% 2.1% 2.1% 1.3% 1.0% 1.0% 1.0% 1.1% 1.5% 1.5% 1.0% 0.5% 0.4% 1.38% <-Median-> 10 Average Incr 5 Year Running
5 year running Average $0.72 $0.75 $0.77 $0.79 $0.86 $0.84 $0.85 $0.86 $0.87 $0.82 $0.83 $0.85 $0.85 $0.86 $0.86 12.29% <-Total Growth 10 Dividends
Yield H/L Price 5.70% 4.81% 4.70% 6.27% 7.11% 5.45% 4.95% 4.44% 4.61% 4.62% 4.61% 4.20% 4.21% 4.66% <-Median-> 10 Dividends
Yield on High Price 5.03% 4.39% 4.29% 5.25% 5.87% 5.02% 4.61% 4.19% 4.22% 4.35% 4.25% 3.70% 4.03% 4.32% <-Median-> 10 Dividends
Yield on Low Price 6.58% 5.30% 5.21% 7.78% 9.01% 5.96% 5.34% 4.72% 5.08% 4.92% 5.03% 4.84% 4.41% 5.14% <-Median-> 10 Dividends
Yield on Close Price 5.22% 4.39% 5.20% 6.75% 5.91% 5.29% 4.62% 4.36% 4.74% 4.53% 4.69% 4.16% 4.11% 4.11% 3.68% 4.71% <-Median-> 10 Dividends
Payout Ratio EPS 281.60% 196.77% 320.51% 297.67% 384.00% 307.69% 29.09% 41.41% 83.17% 91.85% 94.51% 54.09% 37.07% 106.17% 93.18% <-Median-> 10 Payout Ratio EPS
DPR EPS 5 Yr Running 158.24% 186.96% 215.40% 264.02% 288.12% 293.06% 112.03% 77.62% 69.09% 59.32% 55.02% 65.91% 63.19% 65.42% 94.82% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CFPS 80.41% 78.15% 73.27% 76.41% 80.75% 72.21% 79.24% 84.74% 82.26% 66.57% 78.69% 78.99% 98.85% 78.84% <-Median-> 10 Payout Ratio CFPS
DPR CF 5 Yr Running 55.27% 60.95% 69.03% 79.20% 85.86% 81.42% 81.61% 83.94% 85.15% 76.36% 77.70% 77.67% 79.84% 80.31% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CFPS WC 99.94% 78.72% 78.08% 75.02% 104.38% 78.95% 38.66% 43.80% 44.57% 41.76% 50.18% 49.91% 59.17% 50.05% <-Median-> 10 Payout Ratio CFPS WC
DPR CF WC 5 Yr Running 52.22% 62.98% 72.97% 80.28% 86.93% 83.09% 68.91% 60.94% 55.12% 46.32% 43.55% 45.84% 48.48% 64.93% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 4.61% 4.53% 5 Yr Med Payout 83.17% 78.99% 44.57% 1.21% <-IRR #YR-> 10 Dividends 12.79%
* Dividends per share 5 Yr Med and Cur. -10.67% -9.13% Last Div Inc ---> $0.210 $0.215 2.4% 1.46% <-IRR #YR-> 5 Dividends 7.50%
-$0.76 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.86
-$0.80 $0.00 $0.00 $0.00 $0.00 $0.86
Historical Dividends Historical High Div 10.82% Low Div 3.92% Ave Div 7.37% Med Div 5.45% Close Div 5.22% Historical Dividends
High/Ave/Median Values Curr diff Exp. -61.97% Exp 4.97% Exp. -44.17% Exp. -24.50% Exp. -21.13% High/Ave/Median
Future Dividend Yield Div Yd 4.42% earning in 5 Years at IRR of 1.45% Div Inc. 7.46% Future Dividend Yield
Future Dividend Yield Div Yd 4.75% earning in 10 Years at IRR of 1.45% Div Inc. 15.48% Future Dividend Yield
Future Dividend Yield Div Yd 5.11% earning in 15 Years at IRR of 1.45% Div Inc. 24.10% Future Dividend Yield
Yield if held 5 yrs 12.00% 11.19% 10.44% 9.14% 7.49% 6.08% 5.04% 4.94% 6.58% 7.50% 5.86% 5.32% 4.65% 4.72% 4.70% 6.33% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 9.97% 7.27% 7.18% 8.95% 12.80% 11.74% 10.96% 9.60% 7.91% 6.54% 5.42% 5.18% 6.74% 7.64% 8.43% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 10.46% 7.63% 7.54% 9.45% 13.76% 12.62% 11.49% 9.83% 8.05% 9.95% <-Median-> 6 Paid Median Price
Yield if held 20 yrs 11.24% 8.00% 7.72% 9.62% 11.24% <-Median-> 1 Paid Median Price
Cost covered if held 5 years 57.60% 55.21% 51.63% 45.07% 40.27% 32.11% 26.85% 25.88% 33.99% 36.46% 28.37% 26.13% 23.07% 23.51% 23.49% 33.05% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 85.39% 63.20% 63.41% 84.83% 125.18% 117.74% 109.10% 94.67% 78.68% 63.78% 53.48% 51.56% 67.55% 74.65% 81.75% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 141.09% 103.20% 102.37% 130.75% 191.82% 179.73% 166.09% 143.64% 118.91% 135.92% <-Median-> 6 Paid Median Price
Cost covered if held 20 years 196.32% 142.87% 140.83% 178.85% 196.32% <-Median-> 1 Paid Median Price
Graham No. FFO $12.46 $12.97 $12.96 $13.33 $12.75 $12.37 $17.13 $18.80 $19.21 $18.81 $18.96 $20.74 $22.32 $22.98 $23.53 59.98% <-Total Growth 10 Graham Price FFO
Price/GP Ratio Med 1.06 1.22 1.28 0.96 0.88 1.19 0.94 0.98 0.95 0.97 0.98 0.99 0.92 0.98 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.20 1.34 1.41 1.14 1.07 1.29 1.01 1.04 1.04 1.03 1.07 1.12 0.96 1.07 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 0.92 1.11 1.16 0.77 0.70 1.09 0.87 0.92 0.86 0.91 0.90 0.86 0.87 0.89 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.15 1.34 1.16 0.89 1.06 1.22 1.01 1.00 0.92 0.99 0.97 1.00 0.94 0.91 0.99 1.00 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 15.41% 33.91% 15.86% -11.03% 6.21% 22.17% 0.98% 0.09% -7.83% -0.77% -3.22% -0.35% -6.38% -9.06% -0.64% -0.13% <-Median-> 10 Graham Price
Graham No. EPS $7.24 $8.12 $6.40 $6.78 $6.72 $6.37 $29.00 $26.46 $19.03 $18.22 $18.18 $24.83 $31.43 $18.57 205.66% <-Total Growth 10 Graham Price EPS
Price/GP Ratio Med 1.82 1.95 2.60 1.88 1.68 2.30 0.56 0.70 0.96 1.00 1.03 0.83 0.65 1.02 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 2.06 2.14 2.85 2.25 2.03 2.50 0.60 0.74 1.05 1.07 1.11 0.94 0.68 1.09 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.58 1.77 2.35 1.52 1.32 2.11 0.52 0.66 0.87 0.94 0.94 0.72 0.62 0.94 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.99 2.14 2.35 1.75 2.02 2.37 0.60 0.71 0.93 1.02 1.01 0.83 0.66 1.13 1.02 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 98.56% 113.76% 134.67% 74.81% 101.52% 137.19% -40.34% -28.87% -6.92% 2.41% 0.95% -16.74% -33.51% 12.52% 1.68% <-Median-> 10 Graham Price
Pre-2010 split $23.00 $27.78 $24.02 $18.97 $21.66
Price Close $14.38 $17.36 $15.01 $11.86 $13.54 $15.11 $17.30 $18.82 $17.71 $18.66 $18.35 $20.67 $20.90 $20.90 $23.38 19.05% <-Total Growth 10 Stock Price
Increase 22.02% 20.78% -13.53% -21.02% 14.18% 11.62% 14.49% 8.79% -5.90% 5.36% -1.66% 12.64% 1.11% 0.00% 11.87% 1.76% <-IRR #YR-> 10 Stock Price 19.05%
P/E 46.00 44.81 61.59 44.12 48.13 58.12 6.29 9.51 17.53 20.28 20.16 13.00 9.01 25.80 #DIV/0! 3.62% <-IRR #YR-> 5 Stock Price 19.48%
Trailing P/E 51.11 55.56 38.74 48.64 50.37 53.72 66.54 6.84 8.94 18.48 19.95 22.71 13.14 9.01 28.86 6.31% <-IRR #YR-> 10 Price & Dividend 72.32%
P/E on Run. 5 yr Ave 31.59 43.14 41.85 39.69 45.31 52.42 22.74 16.99 14.10 13.48 12.12 16.12 8.18% <-IRR #YR-> 5 Price & Dividend 77.57%
P/E on Run. 10 yr Ave 75.07 90.78 80.44 63.92 60.27 40.66 29.74 25.66 22.78 22.18 20.36 20.24 31.59 P/E Ratio Historical Median 5 yr
Median 10, 5 Yrs D. per yr 4.55% 4.56% % Tot Ret 72.12% 55.72% Price Inc 5.36% P/E: 20.22 17.53 35.20 P/E Ratio Historical Median 10 Yr
-$17.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20.67
-$17.30 $0.00 $0.00 $0.00 $0.00 $20.67
-$17.36 $0.78 $0.80 $1.08 $0.80 $0.80 $0.82 $0.84 $0.85 $0.86 $21.53
-$17.30 $0.82 $0.84 $0.85 $0.86 $21.53
Price H/L Median $13.15 $15.87 $16.61 $12.77 $11.26 $14.68 $16.17 $18.49 $18.23 $18.31 $18.67 $20.49 $20.43 11.87% 29.12% <-Total Growth 10 Stock Price
Increase 23.07% 20.65% 4.69% -23.14% -11.82% 30.39% 10.15% 14.32% -1.41% 0.44% 1.99% 9.75% -0.29% 4.11% 2.59% <-IRR #YR-> 10 Stock Price 29.12%
P/E 42.09 40.95 68.15 47.51 40.03 56.46 5.88 9.34 18.04 19.90 20.52 12.89 8.81 15.98% 4.85% <-IRR #YR-> 5 Stock Price 26.72%
Trailing P/E 46.77 50.78 42.87 52.38 41.90 52.20 62.19 6.72 9.20 18.12 20.29 22.52 12.85 7.22% <-IRR #YR-> 10 Price & Dividend 87.40%
P/E on Run. 5 yr Ave 28.91 39.43 46.31 42.74 37.69 50.93 21.26 16.68 14.51 13.23 12.33 15.98 15.13 9.62% <-IRR #YR-> 5 Price & Dividend 83.01%
P/E on Run. 10 yr Ave 68.68 82.97 89.02 68.83 50.13 39.50 27.80 25.21 23.44 21.76 20.72 20.06 16.62 19.90 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 4.64% 4.77% % Tot Ret 64.17% 49.61% Price Inc 1.99% P/E: 20.21 18.04 Count 21 Years of data
-$15.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20.49
-$16.17 $0.00 $0.00 $0.00 $0.00 $20.49
-$15.87 $0.78 $0.80 $0.80 $0.80 $0.80 $0.82 $0.84 $0.85 $0.86 $21.35
-$16.17 $0.82 $0.84 $0.85 $0.86 $21.35
High Months Dec Dec Feb Jun Dec Oct Sep Aug May Aug Apr Jul Feb Stock Price
Pre-2010 split $23.84 $27.78 $29.15 $24.40 $21.82
Price High $14.90 $17.36 $18.22 $15.25 $13.64 $15.93 $17.37 $19.58 $19.91 $19.42 $20.25 $23.22 $21.34 33.74% <-Total Growth 10 Stock Price
Increase 24.17% 16.53% 4.93% -16.30% -10.57% 16.81% 9.04% 12.72% 1.69% -2.46% 4.27% 14.67% -8.10% 2.95% <-IRR #YR-> 10 Stock Price 33.74%
P/E 47.68 44.81 74.74 56.74 48.49 61.27 6.32 9.89 19.71 21.11 22.25 14.60 9.20 5.98% <-IRR #YR-> 5 Stock Price 33.68%
Trailing P/E 52.98 55.56 47.02 62.56 50.74 56.64 66.81 7.12 10.06 19.23 22.01 25.52 13.42 22.25 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 4.27% P/E: 21.68 19.71 48.80 P/E Ratio Historical High
-$17.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23.22
-$17.37 $0.00 $0.00 $0.00 $0.00 $23.22
Low Mths Apr Jul Dec Nov Mar May Aug Mar Sep Feb Aug Jan Oct Stock Price
Price Low $11.41 $14.38 $15.01 $10.29 $8.88 $13.43 $14.97 $17.39 $16.54 $17.19 $17.09 $17.76 $19.52 23.55% <-Total Growth 10 Stock Price
Increase 21.67% 26.03% 4.39% -31.45% -13.67% 51.23% 11.46% 16.17% -4.89% 3.93% -0.58% 3.92% 9.91% 2.14% <-IRR #YR-> 10 Stock Price 23.55%
P/E 36.50 37.10 61.56 38.28 31.58 51.66 5.44 8.78 16.38 18.68 18.78 11.17 8.41 3.48% <-IRR #YR-> 5 Stock Price 18.64%
Trailing P/E 40.56 46.00 38.73 42.21 33.05 47.76 57.58 6.32 8.35 17.02 18.58 19.52 12.28 18.68 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 3.92% P/E: 18.73 16.38 8.48 P/E Ratio Historical Low
-$14.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.76
Long Term Debt $3,206.29 $3,322.58 $3,338.95 $3,418.26 $3,760.05 Debt
Change 3.63% 0.49% 2.38% 10.00% 2.38% <-Median-> 3 Change
Debt/Market Cap Ratio 0.87 0.82 0.81 0.68 0.74 0.81 <-Median-> 4 Debt/Market Cap Ratio
Goodwill & Intangibles $0 $0 $0 $0 $0 $0 $0 Intangibles Goodwill
Change #DIV/0! #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 0.00 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $1,625 $2,092 $1,914 $1,708 $2,080 $2,470 $3,083 $3,887 $3,690 $4,038 $4,139 $5,033 $5,099 $5,099 $5,704 140.62% <-Total Growth 10 Market Cap
Diluted # of Sh in Million 150.19 160.03 189.13 206.57 229.95 230.53 235.87 246.43 248.63 53.99% <-Total Growth 7 Diluted
Change 6.55% 18.18% 9.22% 11.32% 0.25% 2.32% 4.48% 0.89% 6.55% <-Median-> 7 Change
Average # of Sh in Million 101.48 118.04 124.79 139.40 150.01 159.11 168.01 189.01 208.23 212.00 223.64 235.67 244.85 99.65% <-Total Growth 10 Average
Change 42.11% 16.32% 5.72% 11.71% 7.61% 6.07% 5.59% 12.50% 10.17% 1.81% 5.49% 5.38% 3.90% 5.89% <-Median-> 10 Change
Difference 11.4% 2.1% 2.2% 3.3% 2.4% 2.7% 6.1% 9.3% 0.1% 2.1% 0.8% 3.3% -0.4% 2.58% <-Median-> 10 Difference
$259.74 <-12 mths 1.23%
# of Share in Millions 113.033 120.477 127.491 144.044 153.673 163.456 178.225 206.546 208.356 216.374 225.538 243.507 243.964 243.964 243.964 7.29% <-IRR #YR-> 10 Shares 102.12%
Change 36.75% 6.59% 5.82% 12.98% 6.68% 6.37% 9.04% 15.89% 0.88% 3.85% 4.24% 7.97% 0.19% 0.00% 0.00% 6.44% <-IRR #YR-> 5 Shares 36.63%
CF fr Op $M $94.7 $115.2 $133.1 $146.0 $148.6 $176.3 $169.6 $182.9 $212.6 $269.1 $244.4 $256.6 $212.2 122.79% <-Total Growth 10 Cash Flow
Increase 38.36% 21.68% 15.53% 9.70% 1.83% 18.61% -3.78% 7.83% 16.25% 26.56% -9.16% 4.98% -17.28% Conv Deb SO, S Iss
5 year Running Average $60.9 $77.4 $95.2 $111.4 $127.5 $143.8 $154.7 $164.7 $178.0 $202.1 $215.7 $233.1 $239.0 201.02% <-Total Growth 10 CF 5 Yr Running
CFPS $0.93 $0.98 $1.07 $1.05 $0.99 $1.11 $1.01 $0.97 $1.02 $1.27 $1.09 $1.09 $0.87 11.59% <-Total Growth 10 Cash Flow per Share
Increase -2.64% 4.61% 9.28% -1.80% -5.38% 11.83% -8.87% -4.15% 5.52% 24.31% -13.89% -0.38% -20.10% 8.34% <-IRR #YR-> 10 Cash Flow 122.79%
5 year Running Average $1.30 $1.23 $1.12 $1.00 $1.00 $1.04 $1.04 $1.02 $1.02 $1.08 $1.07 $1.09 $1.07 8.63% <-IRR #YR-> 5 Cash Flow 51.28%
P/CF on Med Price 14.10 16.26 15.58 12.20 11.36 13.25 16.02 19.10 17.85 14.42 17.08 18.82 23.48 1.10% <-IRR #YR-> 10 Cash Flow per Share 11.59%
P/CF on Closing Price 15.41 17.79 14.08 11.32 13.66 13.64 17.14 19.45 17.34 14.70 16.79 18.98 24.02 1.52% <-IRR #YR-> 5 Cash Flow per Share 7.84%
52.06% Diff M/C -1.26% <-IRR #YR-> 10 CFPS 5 yr Running -11.87%
$423.96 <-12 mths 4.41% Chg WC Google Fin
Excl.Working Capital CF -$5.3 -$0.8 -$8.2 $2.7 $6.6 -$15.1 $178.0 $171.0 $179.8 $159.9 $138.8 $149.5 $142.3 0.82% <-IRR #YR-> 5 CFPS 5 yr Running 4.18%
CF fr Op $M WC $89.4 $114.3 $124.9 $148.6 $155.2 $161.2 $347.6 $353.9 $392.4 $428.9 $383.3 $406.1 $354.6 255.12% <-Total Growth 10 Cash Flow less WC
Increase 25.56% 27.96% 9.20% 19.05% 4.42% 3.87% 115.60% 1.80% 10.89% 9.31% -10.65% 5.95% -12.68% 13.51% <-IRR #YR-> 10 Cash Flow less WC 255.12%
5 year Running Average $61.7 $75.3 $91.2 $109.7 $126.5 $140.9 $187.5 $233.3 $282.1 $336.8 $381.2 $392.9 $393.1 3.16% <-IRR #YR-> 5 Cash Flow less WC 16.81%
CFPS Excl. WC $0.88 $0.97 $1.00 $1.07 $1.03 $1.01 $2.07 $1.87 $1.88 $2.02 $1.71 $1.72 $1.45 17.96% <-IRR #YR-> 10 CF less WC 5 Yr Run 421.82%
Increase -11.64% 10.01% 3.30% 6.57% -2.97% -2.07% 104.19% -9.52% 0.66% 7.36% -15.30% 0.54% -15.65% 15.94% <-IRR #YR-> 5 CF less WC 5 Yr Run 109.53%
5 year Running Average $1.38 $1.19 $1.06 $0.98 $0.99 $1.02 $1.24 $1.41 $1.57 $1.77 $1.91 $1.84 $1.76 5.93% <-IRR #YR-> 10 CFPS - Less WC 77.87%
P/CF on Med Price 14.94 16.38 16.60 11.97 10.88 14.49 7.81 9.87 9.67 9.05 10.89 11.89 14.06 -3.60% <-IRR #YR-> 5 CFPS - Less WC -16.73%
P/CF on Closing Price 16.33 17.92 15.00 11.12 13.08 14.91 8.36 10.05 9.40 9.22 10.71 12.00 14.38 4.43% <-IRR #YR-> 10 CFPS 5 yr Running 54.28%
*Operational Cash Flow per share CF/CF-WC P/CF Med 10 yr 15.80 5 yr 17.85 P/CF Med 10 yr 10.89 5 yr 9.87 32.08% Diff M/C 8.31% <-IRR #YR-> 5 CFPS 5 yr Running 49.04%
-$0.98 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.09 Cash Flow per Share
-$1.01 $0.00 $0.00 $0.00 $0.00 $1.09 Cash Flow per Share
-$1.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.09 CFPS 5 yr Running
-$1.04 $0.00 $0.00 $0.00 $0.00 $1.09 CFPS 5 yr Running
-$114.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $406.1 Cash Flow less WC
-$347.6 $0.0 $0.0 $0.0 $0.0 $406.1 Cash Flow less WC
-$75.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $392.9 CF less WC 5 Yr Run
-$187.5 $0.0 $0.0 $0.0 $0.0 $392.9 CF less WC 5 Yr Run
-$0.97 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.72 CFPS - Less WC
-$2.07 $0.00 $0.00 $0.00 $0.00 $1.72 CFPS - Less WC
-$1.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.84 CFPS 5 yr Running
-$1.24 $0.00 $0.00 $0.00 $0.00 $1.84 CFPS 5 yr Running
OPM 35.23% 34.60% 34.75% 34.78% 33.19% 35.97% 32.20% 31.37% 33.66% 41.50% 37.22% 37.94% 9.67% <-Total Growth 10 OPM
Increase 14.08% -1.80% 0.43% 0.11% -4.57% 8.36% -10.48% -2.59% 7.32% 23.27% -10.30% 1.93% Should increase or be stable.
Diff from Median 1.3% -0.5% -0.1% 0.1% -4.5% 3.5% -7.4% -9.8% -3.2% 19.4% 7.1% 9.1% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 34.77% 5 Yrs 37.22% should be zero, it is a check on calculations
Current Assets $22.36 $34.88 $46.46 $52.76 $99.39 $133.90 $233.11 $238.42 $340.24 $349.30 $170.35 $173.71 $298.62 Liquidity ratio of 1.5 and up, best
Current Liabilities $56.17 $88.84 $73.86 $166.51 $137.66 $100.05 $495.24 $467.50 $615.49 $493.98 $447.65 $729.08 $658.33 0.53 <-Median-> 10 Ratio
Liquidity Ratio 0.40 0.39 0.63 0.32 0.72 1.34 0.47 0.51 0.55 0.71 0.38 0.24 0.45 0.51 <-Median-> 5 Ratio
Liq. with CF aft div 0.73 0.68 1.11 0.52 0.93 1.83 0.54 0.57 0.61 0.89 0.50 0.31 0.46 0.57 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.08 0.10 0.16 0.18 0.35 0.37 0.27 0.29 0.39 0.54 0.28 0.18 0.46 0.29 <-Median-> 5 Ratio
Exclude current Debt $191.48 $242.95 $257.96 $210.31 $470.71 $405.93
Liquidity Ratio 0.77 1.06 1.48 0.72 0.67 1.18 0.89 <-Median-> 4 Ratio
Liq. with CF aft div 0.88 1.19 1.86 0.94 0.88 1.19 1.06 <-Median-> 4 Ratio
Assets $2,469.3 $3,060.9 $3,409.4 $3,720.3 $3,691.6 $4,120.7 $6,111.1 $7,318.8 $7,596.3 $7,908.2 $8,278.5 $9,104.6 $9,861.3 Debt Ratio of 1.5 and up, best
Liabilities $1,626.7 $2,149.3 $2,458.1 $2,624.5 $2,595.8 $2,986.8 $3,678.9 $4,055.2 $4,273.2 $4,410.3 $4,610.2 $4,871.5 $5,196.1 1.72 <-Median-> 10 Ratio
Debt Ratio 1.52 1.42 1.39 1.42 1.42 1.38 1.66 1.80 1.78 1.79 1.80 1.87 1.90 1.80 <-Median-> 5 Ratio
Total Book Value $842.5 $911.6 $951.3 $1,095.8 $1,095.8 $1,137.8 $2,432.2 $3,263.6 $3,323.0 $3,497.8 $3,668.3 $4,233.1 $4,665.1 $4,665.1 $4,665.1 364.36% <-Total Growth 10 Book Value
NCI $3.9 $10.5 $18.0 $3.6 $27.5 $28.4 $37.8 $47.0 $47.0 $47.0
Net Book Value $842.5 $911.6 $951.3 $1,095.8 $1,095.8 $1,133.9 $2,421.7 $3,245.6 $3,319.4 $3,470.3 $3,640.0 $4,195.3 $4,618.2 $4,618.2 $4,618.2 360.21% <-Total Growth 10 Book Value
Book Value per Share $7.45 $7.57 $7.46 $7.61 $7.13 $6.94 $13.59 $15.71 $15.93 $16.04 $16.14 $17.23 $18.93 $18.93 $18.93 127.69% <-Total Growth 10 Book Value per Share
Change -22.47% 1.51% -1.38% 1.95% -6.26% -2.72% 95.87% 15.64% 1.38% 0.67% 0.63% 6.75% 9.87% 0.00% 0.00% -7.19% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 1.76 2.10 2.23 1.68 1.58 2.12 1.19 1.18 1.14 1.14 1.16 1.19 1.08 1.14 P/B Ratio Historical Median
P/B Ratio (Close) 1.93 2.29 2.01 1.56 1.90 2.18 1.27 1.20 1.11 1.16 1.14 1.20 1.10 1.10 1.24 8.58% <-IRR #YR-> 10 Book Value per Share 127.69%
Change 57.38% 18.99% -12.32% -22.53% 21.81% 14.74% -41.55% -5.93% -7.18% 4.66% -2.27% 5.52% -7.97% 0.00% 11.87% 4.86% <-IRR #YR-> 5 Book Value per Share 26.79%
Leverage (A/BK) 2.93 3.36 3.58 3.40 3.37 3.62 2.51 2.24 2.29 2.26 2.26 2.15 2.11 2.40 <-Median-> 10 A/BV
Debt/Equity Ratio 1.93 2.36 2.58 2.40 2.37 2.63 1.51 1.24 1.29 1.26 1.26 1.15 1.11 1.40 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.19 5 yr Med 1.16 -7.19% Diff M/C 2.51 Historical Leverage (A/BK)
-$7.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17.23
-$13.59 $0.00 $0.00 $0.00 $0.00 $17.23
$641.4 <-12 mths 65.28%
Comprehensive Income $497.13 $391.10 $218.78 $189.55 $195.74 $391.16 -21.32% <-Total Growth 5 Comprehensive Income
NCI $0.03 $0.04 $0.15 $1.46 -$0.14 $3.08
Shareholder $46.37 $18.15 $29.60 $76.62 $42.66 $497.10 $391.07 $218.64 $188.09 $195.87 $388.08 736.99% <-Total Growth 10 Comprehensive Income
Increase -60.85% 63.11% 158.82% -44.33% 1065.28% -21.33% -44.09% -13.97% 4.14% 98.13% -13.97% <-Median-> 5 Comprehensive Income
5 Yr Running Average $42.68 $132.83 $207.41 $245.22 $267.51 $298.15 $276.35 23.67% <-IRR #YR-> 10 Comprehensive Income 736.99%
ROE 5.1% 1.9% 2.7% 7.0% 3.7% 20.4% 12.0% 6.6% 5.4% 5.3% 9.2% -4.83% <-IRR #YR-> 5 Comprehensive Income -21.93%
5Yr Median 3.7% 3.7% 7.0% 7.0% 6.6% 6.6% 6.6% 36.52% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.9% -40.2% -20.9% 82.8% 3.2% -0.9% -0.5% 1.8% -4.4% -3.9% 1.4% 15.78% <-IRR #YR-> 5 5 Yr Running Average 108.05%
Median Values Diff 5, 10 yr -0.7% -0.5% 6.6% <-Median-> 5 Return on Equity
-$46.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $388.1
-$497.1 $0.0 $0.0 $0.0 $0.0 $388.1
-$42.7 $0.0 $0.0 $0.0 $0.0 $0.0 $276.3
-$132.8 $0.0 $0.0 $0.0 $0.0 $276.3
Current Liability Coverage Ratio 1.59 1.29 1.69 0.89 1.13 1.61 0.70 0.76 0.64 0.87 0.86 0.56 0.54 CFO / Current Liabilities
5 year Median 1.59 1.59 1.59 1.59 1.29 1.29 1.13 0.89 0.76 0.76 0.76 0.76 0.64 0.76 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 3.62% 3.74% 3.66% 4.00% 4.20% 3.91% 5.69% 4.84% 5.17% 5.42% 4.63% 4.46% 3.60% CFO / Total Assets
5 year Median 3.76% 3.74% 3.66% 3.74% 3.74% 3.91% 4.00% 4.20% 4.84% 5.17% 5.17% 4.84% 4.63% 4.8% <-Median-> 5 Return on Assets
Return on Assets ROA 1.2% 1.5% 0.9% 1.0% 1.1% 1.0% 8.2% 5.4% 2.8% 2.5% 2.5% 4.2% 0.0% Net Income/Assets Return on Assets
5Yr Median 2.5% 2.0% 1.5% 1.2% 1.1% 1.0% 1.0% 1.1% 2.8% 2.8% 2.8% 2.8% 2.5% 2.8% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 3.5% 5.0% 3.2% 3.4% 3.8% 3.6% 20.6% 12.0% 6.5% 5.6% 5.6% 9.0% 13.2% <-12 mths Net Inc/ Shareholders' equity Return on Equity
5Yr Median 5.8% 5.0% 4.7% 3.5% 3.5% 3.6% 3.6% 3.8% 6.5% 6.5% 6.5% 6.5% 6.5% 6.5% <-Median-> 5 Return on Equity
$616.0 <-12 mths 60.95%
Net Income $501.65 $393.00 $215.01 $198.21 $203.73 $385.79
NCI $0.03 $0.04 $0.15 $1.46 -$0.14 $3.08
Shareholder $29.20 $45.96 $30.35 $37.43 $41.91 $41.34 $501.62 $392.96 $214.86 $196.75 $203.87 $382.71 732.73% <-Total Growth 10 Net Income
Increase -21.70% 57.42% -33.96% 23.32% 11.98% -1.37% 1113.46% -21.66% -45.32% -8.43% 3.62% 87.73% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $34.3 $37.2 $37.4 $36.0 $37.0 $39.4 $130.5 $203.1 $238.5 $269.5 $302.0 $278.2 23.61% <-IRR #YR-> 10 Net Income 732.73%
Operating Cash Flow $94.65 $115.17 $133.06 $145.96 $148.63 $176.29 $169.62 $182.90 $212.62 $269.09 $244.43 $256.60 -5.27% <-IRR #YR-> 5 Net Income -23.70%
Investment Cash Flow -$475.63 -$507.57 -$445.42 -$309.72 -$232.86 -$396.30 -$501.50 -$446.11 -$343.73 -$322.38 -$342.39 -$570.22 22.28% <-IRR #YR-> 10 5 Yr Running Average 647.52%
Total Accruals $410.18 $438.35 $342.72 $201.19 $126.15 $261.35 $833.50 $656.17 $345.98 $250.04 $301.82 $696.33 16.34% <-IRR #YR-> 5 5 Yr Running Average 113.15%
Total Assets $2,469.3 $3,060.9 $3,409.4 $3,720.3 $3,691.6 $4,120.7 $6,111.1 $7,318.8 $7,596.3 $7,908.2 $8,278.5 $9,104.6 Balance Sheet Assets
Accruals Ratio 16.61% 14.32% 10.05% 5.41% 3.42% 6.34% 13.64% 8.97% 4.55% 3.16% 3.65% 7.65% 4.55% <-Median-> 5 Ratio
EPS/CF Ratio 0.35 0.40 0.24 0.25 0.27 0.26 1.33 1.06 0.54 0.45 0.53 0.92 0.49 <-Median-> 10 EPS/CF Ratio
-$46.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $382.7
-$501.6 $0.0 $0.0 $0.0 $0.0 $382.7
-$37.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $278.2
-$130.5 $0.0 $0.0 $0.0 $0.0 $278.2
Chge in Close 22.02% 20.78% -13.53% -21.02% 14.18% 11.62% 14.49% 8.79% -5.90% 5.36% -1.66% 12.64% 1.11% 0.00% 11.87% Count 22 Years of data
up/down/neutral down down down down down down down down Down Count 16 72.73%
Any Predictions? yes yes yes % right Count 7 43.75%
Financial Cash Flow $381.34 $393.51 $316.98 $160.24 $80.20 $247.11 $303.14 $330.41 $72.07 $65.66 $63.57 $326.96 C F Statement Financial Cash Flow
Total Accruals $28.84 $44.84 $25.74 $40.95 $45.95 $14.25 $530.37 $325.76 $273.90 $184.37 $238.25 $369.38 Accruals
Accruals Ratio 1.17% 1.46% 0.75% 1.10% 1.24% 0.35% 8.68% 4.45% 3.61% 2.33% 2.88% 4.06% 3.61% <-Median-> 5 Ratio
Cash $4.55 $31.64 $3.08 $70.16 $4.98 $17.35 -$17.04 -$3.70 -$1.34 Cash
Cash per Share $0.03 $0.19 $0.02 $0.34 $0.02 $0.08 -$0.08 -$0.02 -$0.01 $0.02 <-Median-> 5 Cash per Share
Percentage of Stock Price 0.22% 1.28% 0.10% 1.80% 0.13% 0.43% -0.41% -0.07% -0.03% 0.13% <-Median-> 5 % of Stock Price
Notes:
December 10, 2017. Last estimates were for 2016, 2017 and 2018 of $684M, $717M and $758M for Revenue, $1.00, $1.06 and $1.13 for AFFO, $1.12, $1.17 and $1.24 for FFO,
$1.11 and $1.16 for 2016 and 2017 for EPS, $0.87 for CFPS for 2016.
December 11, 2016. Last estimates were for 2015, 2016 and 2017 of $666M, $686M and $718M for Revenue, $0.93, $0.96 and $1.00 for AFFO, $0.98, $1.07 and $1.12 for FFO, $0.97 for CFPS for 2015.
December 12, 2015. Last estimates were for 2014 and 2015 of $654.2M and $690M for Revenue, $0.97 for 2014 for AFFO, $1.08 for FFO for 2014, $0.81 and $0.87 for CFPS.
December 16, 2014. Last estimates were for 2013, 2014 and 2015 of $631.6M, $654.2M and $690M for Revenue, $0.90 and $0.97 (2013 and 2014)
for AFFO, $1.03 and $1.08 (2013 and 2014) for FFO, $1.37 for EPS for 2013, $0.92, $0.81 and $0.87 for CFPS.
Nov 28, 2012. Last estimates I got were for 2011 and 2012 for Revenue of $525M and $567M, for FFO of $0.96 and $1.04 and for CFPS of $0.90 and $0.96.
The increase in shares includes lots of converted debentures and issuance of shares.
There was a stock split of 3.2:2. This is an odd split. I got values from different places, so some had accounted for split and some had not.
The stock hit a high in March 1998 that it did not match for 7 years, in Nov 2005. They lost money in 1999 and 2000.
Sector:
Real Estate
What should this stock accomplish?
This stock should give you diversification. There will be volitility. You should get good dividends, usually in the 4 to 5% range. Dividend increases at the minimum should be at the rate of inflation over the long term.
Would I buy this company and Why.
As a Real Estate sector firm it provides a good dividend which is affordable. Shareholders are making a reasonable return. It would be nice if dividend growth was better, but dividends are growing.
Why am I following this stock.
Myowneradvistor.com as me to look into this stock.
In 2011 a reader asked me to review this real estate stock. Also, the site Canadian Dividend Stock site mentions this company as a top Canadian REIT.
Dividends
Dividends are paid in Cycle 1. Dividends are paid in January, April, July and October.
For example the dividend declared October 31, 2013 is payable January 9, 2014 for shareholders of record of December 31, 2013.
How they make their money.
First Capital Realty is Canada's leading owner, developer and operator of supermarket and drugstore anchored neighbourhood and community shopping centers
located predominantly in growing metropolitan areas.
First Capital Realty Inc (TSE:FCR) operates as the bank holding company for First Harrison Bank that provides various banking services to individuals
and business customers primarily Harrison, Floyd, Clark, and Washington counties in Indiana.
For most ratios, lower is better when looking for a good stock price. However, there are exceptions such as for yield (dividends and erarnings) 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.
According to Wikipedia it is Gazit-Globe that owns shares in First Capital Realty.
TAXE (Tel-Aviv SE)-GLOB, NYSE-GZT
http://en.wikipedia.org/wiki/Gazit-Globe
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Dec 06 2012 Dec 07 2013 Dec 06 2014 Dec 12 2015 Dec 11 2016 Dec 10 2017
Paul, Adam Elliot 0.041 0.02% 0.041 0.02% 0.041 0.02% 0.00%
CEO - Shares - Amount $0.751 $0.85 $0.86
Options - percentage 0.621 0.28% 1.141 0.47% 1.612 0.66%
Options - amount $11.399 $23.59 $33.68
Reuters Options Value
Brekken, Kay 0.000 0.00% 0.005 0.00% 0.016 0.01% 0.017 0.01% 2.80%
CFO - Shares - Amount $0.000 $0.093 $0.33 $0.35
Options - percentage 0.055 0.03% 0.145 0.06% 0.258 0.11% 0.389 0.16%
Options - amount $1.026 $2.656 $5.33 $8.14
Reuters Options Value
Weaver, Karen H. 0.064 0.03% 0.936 0.45%
CFO - Shares - Amount $1.201 $16.571
Options - percentage 0.554 0.27% 0.517 0.25%
Options - amount $10.422 $9.160
Reuters Options Value 0.235 $0.987
Burton, Gareth 0.000 0.00% 0.000 0.00%
Officer - Shares - Amount $0.000 $0.000
Options - percentage 0.036 0.01% 0.076 0.03%
Options - amount $0.753 $1.583
McDougald, Maryanne 0.014 0.01% 0.017 0.01% 0.024 0.01%
Officer - Shares - Amount $0.253 $0.357 $0.510
Options - percentage 0.230 0.10% 0.286 0.12% 0.346 0.14%
Options - amount $4.227 $5.918 $7.223
Kozak, Brian 0.072 0.03%
Officer - Shares - Amount $1.340
Options - percentage 0.364 0.17%
Options - amount $6.788
Hagan, Jon 0.020 0.01% 0.025 0.01% 0.025 0.01% 0.020 0.01% 0.020 0.01% 0.020 0.01%
Director - Shares - Amount $0.385 $0.438 $0.461 $0.376 $0.423 $0.428
Options - percentage 0.054 0.03% 0.059 0.03% 0.065 0.03% 0.070 0.03% 0.076 0.03% 0.082 0.03%
Options - amount $1.024 $1.051 $1.206 $1.287 $1.57 $1.716
Reuters Options Value 0.000 $0
Katzman, Chaim 0.043 0.02% 0.071 0.03% 0.081 0.04% 0.118 0.05% 0.134 0.06% 0.165 0.07% 23.17%
Director - Shares - Amount $0.818 $1.252 $1.515 $2.160 $2.777 $3.459 Was Chairman
Options - percentage 0.206 0.10% 0.210 0.10% 0.212 0.10% 0.066 0.03% 0.056 0.02% 0.030 0.01% now director
Options - amount $3.878 $3.715 $3.959 $1.204 $1.16 $0.631
Reuters Options Value 0.098 $0.423
Segal, Dori 1.064 0.52% 1.148 0.55% 1.257 0.58% 1.415 0.63% 2.325 0.95% 2.506 1.03% 7.77%
Chairman - Shares - Amt $20.027 $20.336 $23.453 $25.962 $48.057 $52.366 was CEO in 2014
Options - percentage 2.097 1.02% 2.180 1.05% 2.169 1.00% 1.456 0.65% 3.320 1.36% 2.761 1.13%
Options - amount $39.472 $38.605 $40.482 $26.714 $68.63 $57.713
Reuters Options Value 0.962 $1.055
Chouinard, Roger 0.003 0.00% 0.003 0.00% 0.005 0.00% 0.007 0.00% 0.000 0.00% Ceased to be insider Jun 2017
Subsidiary Executive $0.059 $0.060 $0.098 $0.148 $0.000
Options - percentage 0.086 0.04% 0.138 0.06% 0.186 0.08% 0.220 0.09% 0.000 0.00%
Options - amount $1.619 $2.573 $3.417 $4.55 $0.000
Alony-Hetz Properties And Investments Ltd. 21.282 10.30% 17.782 8.22% 13.782 6.11% 12.802 5.26%
10% Holders $400.528 $331.813 $252.900 $264.618 Filed Jan 2016 last
TASE: ALHE
Gazit Canada Inc. 94.135 45.58% 95.137 43.97% 95.137 42.18% 88.637 36.40% 79.637 32.64% -10.15%
10% Holders $1,771.616 $1,775.252 $1,745.759 $1,832.12 $1,664.408 Filed Mar 2017 last
Increase in O/S Shares 0.797 0.38% 0.600 0.29% 1.446 0.67% 1.577 0.70% 1.129 0.46%
due to SO $15.000 $10.626 $26.982 $28.938 $23.336
Book Value $10.560 $8.496 $22.747 $26.379 $20.924
Insider Buying -$0.038 -$0.080 -$0.696
Insider Selling $15.803 $8.578 $4.702
Net Insider Selling $5.414 $15.765 $8.498 $4.006
% of Market Cap 0.13% 0.38% 0.17% 0.08%
Directors 9 8 9 9 8
Women 2 22% 2 25% 2 22% 3 33% 3 38%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 102 21.43% 105 20.03% 153 21.85% 147 21.93% 163 24.58% 184 32.95%
Total Shares Held 43.307 20.97% 41.554 19.94% 47.164 21.80% 49.416 21.91% 59.775 24.55% 80.386 32.95%
Increase/Decrease 1.193 2.83% 0.371 0.90% 1.048 2.27% 1.231 2.55% -0.246 -0.41% -0.202 -0.25%
Starting No. of Shares 42.113 41.183 46.115 48.186 60.022 80.588
Copyright 2008 Website of SPBrunner. All rights reserved.