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/
Metro Inc. TSX: MRU OTC: MTRAF www.metro.ca Fiscal Yr: Sept 30
Year 9/30/06 9/29/07 9/27/08 9/26/09 9/25/10 9/24/11 9/29/12 9/28/13 9/27/14 9/26/15 9/24/16 9/24/17 9/24/18 9/24/19 9/23/20 Value Description #Y Item Total G
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
Revenue* $10,944 $10,645 $10,725 $11,196 $11,349 $11,431 $12,011 $11,403 $11,590 $12,224 $12,788 $13,175 $14,531 $16,697 $16,964 23.77% <-Total Growth 10 Revenue
Increase 63.44% -2.74% 0.76% 4.39% 1.37% 0.72% 5.08% -5.06% 1.65% 5.46% 4.61% 3.03% 10.29% 14.91% 1.60% 2.16% <-IRR #YR-> 10 Revenue 23.77%
5 year Running Average $6,910 $8,010 $9,002 $10,041 $10,972 $11,069 $11,342 $11,478 $11,557 $11,732 $12,003 $12,236 $12,862 $13,883 $14,831 1.87% <-IRR #YR-> 5 Revenue 9.70%
Revenue per Share $31.80 $30.99 $32.34 $34.38 $36.00 $37.69 $41.20 $41.47 $45.59 $50.45 $54.53 $57.86 $63.81 $73.32 $74.50 4.33% <-IRR #YR-> 10 5 yr Running Average 52.76%
Increase 63.0% -2.5% 4.3% 6.3% 4.7% 4.7% 9.3% 0.7% 9.9% 10.7% 8.1% 6.1% 10.3% 14.9% 1.6% 1.53% <-IRR #YR-> 5 5 yr Running Average 7.88%
5 year Running Average $21.78 $24.53 $27.07 $29.80 $33.10 $34.28 $36.32 $38.15 $40.39 $43.28 $46.65 $49.98 $54.45 $59.99 $64.80 6.44% <-IRR #YR-> 10 Revenue per Share 86.68%
P/S (Price/Sales) Med 0.33 0.40 0.29 0.33 0.37 0.41 0.42 0.53 0.49 0.62 0.77 0.74 7.03% <-IRR #YR-> 5 Revenue per Share 40.45%
P/S (Price/Sales) Close 0.35 0.38 0.33 0.34 0.42 0.40 0.47 0.52 0.54 0.71 0.79 0.74 0.63 0.55 0.54 7.38% <-IRR #YR-> 10 5 yr Running Average 103.76%
*Sales in M CDN $  P/S Med 10 yr  0.46 5 yr  0.62 38.08% Diff M/C 6.59% <-IRR #YR-> 5 5 yr Running Average 37.60%
-$10,645 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13,175
-$12,011 $0 $0 $0 $0 $13,175
-$8,010 $0 $0 $0 $0 $0 $0 $0 $0 $0 $12,236
-$11,342 $0 $0 $0 $0 $12,236
-$30.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $57.86
-$41.20 $0.00 $0.00 $0.00 $0.00 $57.86
-$24.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $49.98
-$36.32 $0.00 $0.00 $0.00 $0.00 $49.98
Pre-split 15 $7.52
With ADT Sale $2.51
Pre-split 15 $2.21 $2.40 $2.60 $3.21 $3.67 $3.75 $4.87 $4.92 $5.11
EPS Basic $0.74 $0.80 $0.87 $1.07 $1.22 $1.25 $1.62 $1.64 $1.70 $2.03 $2.41 $2.59 223.75% <-Total Growth 10 EPS Basic
Pre-split 02
Pre-split 15 $2.18 $2.37 $2.58 $3.19 $3.65 $3.73 $4.84 $7.46 $5.07
EPS Diluted* $0.73 $0.79 $0.86 $1.06 $1.22 $1.24 $1.61 $2.49 $1.69 $2.01 $2.39 $2.57 $2.60 $2.95 $3.25 225.32% <-Total Growth 10 EPS Diluted
Increase 13.54% 8.72% 8.86% 23.64% 14.42% 2.19% 29.76% 54.13% -32.04% 18.93% 18.91% 7.53% 1.17% 13.46% 10.17% 12.52% <-IRR #YR-> 10 Earnings per Share 225.32%
Earnings Yield 6.5% 6.8% 8.1% 9.2% 8.1% 8.3% 8.3% 11.5% 6.9% 5.6% 5.5% 6.0% 6.5% 7.3% 8.1% 9.76% <-IRR #YR-> 5 Earnings per Share 59.30%
5 year Running Average $0.59 $0.66 $0.72 $0.82 $0.93 $1.03 $1.20 $1.52 $1.65 $1.81 $2.04 $2.23 $2.25 $2.50 $2.75 12.99% <-IRR #YR-> 10 5 yr Running Average 239.15%
10 year Running Average $0.43 $0.49 $0.56 $0.64 $0.73 $0.81 $0.93 $1.12 $1.23 $1.37 $1.54 $1.71 $1.89 $2.08 $2.28 13.20% <-IRR #YR-> 5 5 yr Running Average 85.88%
* Diluted ESP per share  E/P 10 Yrs 8.10% 5Yrs 5.99%
-$0.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.57
-$1.61 $0.00 $0.00 $0.00 $0.00 $2.57
-$0.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.23
-$1.20 $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
Pre-split 02
Pre-split 15 $0.42 $0.45 $0.49 $0.54 $0.65 $0.73 $0.82 $0.97 $1.15 $0.45
Dividend* $0.14 $0.15 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $0.63 $0.65 $0.65 $0.65 318.33% <-Total Growth 10 Dividends
Increase 7.79% 8.43% 8.89% 9.69% 20.54% 11.90% 12.41% 18.40% 19.17% 17.42% 19.24% 16.92% 3.59% 0.00% 0.00% Count 22 Years of data
Average Increases 5 Year Running 19.4% 16.7% 13.2% 10.7% 11.1% 11.9% 12.7% 14.6% 16.5% 15.9% 17.3% 18.2% 15.3% 11.4% 7.9% 13.92% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.11 $0.12 $0.14 $0.15 $0.17 $0.19 $0.21 $0.25 $0.29 $0.33 $0.39 $0.46 $0.53 $0.58 $0.62 278.15% <-Total Growth 10 Dividends 5 Yr Running
Yield H/L Price 1.31% 1.21% 1.73% 1.60% 1.61% 1.58% 1.56% 1.46% 1.71% 1.44% 1.28% 1.46% 1.50% 1.57% <-Median-> 10 Dividends
Yield on High  Price 1.19% 1.12% 1.38% 1.36% 1.38% 1.48% 1.39% 1.29% 1.56% 1.20% 1.12% 1.33% 1.38% 1.37% <-Median-> 10 Dividends
Yield on Low Price 1.45% 1.32% 2.32% 1.94% 1.94% 1.71% 1.80% 1.69% 1.90% 1.82% 1.49% 1.62% 1.65% 1.81% <-Median-> 10 Dividends
Yield on Close Price 1.24% 1.29% 1.54% 1.55% 1.43% 1.62% 1.40% 1.49% 1.56% 1.25% 1.25% 1.46% 1.61% 1.61% 1.61% 1.48% <-Median-> 10 Dividends
Payout Ratio 19.04% 18.99% 18.99% 16.85% 17.75% 19.44% 16.84% 12.94% 22.68% 22.39% 22.46% 24.42% 25.00% 22.03% 20.00% 19.21% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 17.98% 18.66% 19.17% 18.61% 18.18% 18.37% 17.87% 16.14% 17.39% 18.45% 19.27% 20.81% 23.51% 23.28% 22.63% 18.41% <-Median-> 10 DPR EPS 5 Yr Running
Payout Ratio CF 12.15% 14.18% 12.03% 11.22% 12.43% 13.49% 14.50% 15.60% 22.54% 16.08% 17.79% 20.52% 18.2% #DIV/0! #DIV/0! 15.05% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 11.89% 12.81% 12.65% 12.71% 12.29% 12.60% 12.83% 13.58% 15.65% 16.32% 17.15% 18.36% 18.72% #DIV/0! #DIV/0! 13.20% <-Median-> 10 DPR CF 5 Yr Running
Payout Ratio CF NC 11.83% 11.83% 12.49% 11.19% 11.72% 12.91% 10.16% 10.90% 12.22% 12.56% 13.62% 14.87% 18.2% #DIV/0! #DIV/0! 12.35% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 12.61% 12.81% 13.08% 12.36% 11.78% 12.04% 11.53% 11.24% 11.50% 11.74% 12.06% 13.01% 14.35% #DIV/0! #DIV/0! 11.91% <-Median-> 10 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 1.46% 1.46% 5 Yr Med Payout 22.46% 17.79% 12.56% 15.39% <-IRR #YR-> 10 Dividends 318.33%
* Dividends per share  5 Yr Med and Cur. 10.42% 10.43% Last Div Inc ---> $0.1400 $0.1625 16.1% 18.23% <-IRR #YR-> 5 Dividends 130.98%
15.74% <-IRR #YR-> 15 Dividends 796.43%
17.49% <-IRR #YR-> 20 Dividends 2410.00%
20.70% <-IRR #YR-> 22 Dividends 6175.00%
-$0.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.63
-$0.27 $0.00 $0.00 $0.00 $0.00 $0.63
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.63
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.63
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.63
Historical Dividends Historical High Div 2.00% Low Div 0.89% Ave Div 1.45% Med Div 1.44% Close Div 1.39% Historical Dividends
High/Ave/Median Values Curr diff Exp. -19.25%     81.45% Cheap 11.76% Cheap 12.15% Cheap 15.79% High/Ave/Median 
Future Dividend Yield Div Yd 2.72% earning in 5 Years at IRR of 11.00% Div Inc. 68.51% Future Dividend Yield
Future Dividend Yield Div Yd 4.59% earning in 10 Years at IRR of 11.00% Div Inc. 183.94% Future Dividend Yield
Future Dividend Yield Div Yd 7.73% earning in 15 Years at IRR of 11.00% Div Inc. 378.46% Future Dividend Yield
I am earning GC Div Gr 490.91% 8/10/04 # yrs -> 14 2004 $5.89 Cap Gain 583.36% I am earning GC
I am earning Div org yield 1.87% 12/31/14 Trading Div G Yrly 18.63% Div start $0.11 -1.87% 11.04% I am earning Div
Yield if held 5 yrs 2.98% 2.29% 2.73% 2.69% 2.40% 2.28% 2.20% 3.41% 3.42% 3.37% 3.51% 3.61% 2.96% 2.90% 2.09% 3.05% <-Median-> 10 Paid Median Price
Yield if held 10 yrs 9.02% 6.84% 5.30% 5.31% 7.32% 5.20% 4.15% 5.37% 5.75% 5.00% 5.07% 5.07% 6.88% 5.79% 4.86% 5.25% <-Median-> 10 Paid Median Price
Yield if held 15 yrs 19.09% 17.49% 15.76% 12.40% 10.43% 11.37% 15.25% 11.55% 9.59% 10.85% 9.76% 7.22% 12.40% <-Median-> 9 Paid Median Price
Yield if held 20 yrs 40.85% 36.45% 35.00% 28.63% 21.08% 19.28% 22.02% 35.72% <-Median-> 4 Paid Median Price
Yield if held 25 yrs 69.27% 52.63% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 11.48% 9.37% 11.48% 11.40% 9.41% 8.97% 8.66% 13.03% 12.78% 12.47% 12.86% 13.36% 12.04% 12.99% 9.99% 11.98% <-Median-> 10 Paid Median Price
Cost covered if held 10 years 48.26% 39.47% 32.24% 33.56% 44.02% 31.94% 25.75% 32.01% 32.93% 27.95% 27.50% 27.41% 41.06% 38.76% 35.76% 31.97% <-Median-> 10 Paid Median Price
Cost covered if held 15 years 134.37% 118.77% 110.23% 88.37% 72.14% 76.10% 100.54% 74.21% 61.18% 76.19% 76.67% 62.55% 88.37% <-Median-> 9 Paid Median Price
Cost covered if held 20 years 287.23% 253.87% 238.28% 194.19% 158.01% 162.54% 206.05% 246.07% <-Median-> 4 Paid Median Price
Cost covered if held 25 years 597.81% 506.03% #NUM! <-Median-> 0 Paid Median Price
Graham Price $9.05 $10.00 $10.97 $12.90 $14.57 $15.39 $17.80 $23.90 $19.98 $22.21 $24.79 $27.19 $27.35 $29.13 $30.57 171.88% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.17 1.24 0.86 0.87 0.92 0.99 0.98 0.92 1.12 1.40 1.69 1.58 1.58 0.98 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.28 1.34 1.08 1.02 1.07 1.06 1.10 1.05 1.23 1.69 1.93 1.73 1.72 1.09 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.06 1.13 0.64 0.72 0.76 0.92 0.85 0.79 1.01 1.11 1.45 1.42 1.44 0.88 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.24 1.17 0.97 0.90 1.03 0.97 1.09 0.90 1.23 1.62 1.74 1.58 1.47 1.38 1.32 1.06 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 23.77% 16.67% -3.43% -10.24% 3.33% -3.21% 9.37% -9.69% 23.37% 62.07% 73.72% 57.82% 47.18% 38.18% 31.64% 6.35% <-Median-> 10 Graham Price
Month, Year Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19 Dec-20
Pre-split 15 $37.94 $26.35 $37.00 $39.22 $45.20 $54.00 $63.33 $64.90 $93.30
Price Close $12.65 $8.78 $12.33 $13.07 $15.07 $18.00 $21.11 $21.63 $31.10 $38.74 $40.16 $40.25 $40.25 $40.25 $40.25 358.25% <-Total Growth 10 Stock Price
Increase 24.39% -30.55% 40.42% 6.00% 15.25% 19.47% 17.28% 2.48% 43.76% 24.57% 3.67% 0.22% 0.00% 0.00% 0.00% 16.44% <-IRR #YR-> 10 Stock Price 358.25%
P/E 17.40 11.12 14.34 12.29 12.38 14.48 13.08 8.70 18.40 19.27 16.80 15.66 15.48 13.64 12.38 13.78% <-IRR #YR-> 5 Stock Price 90.67%
Trailer P/E 19.76 12.09 15.61 15.20 14.17 14.79 16.98 13.41 12.51 22.92 19.98 16.84 15.66 15.48 13.64 18.21% <-IRR #YR-> 10 Price & Dividend 398.57%
Median 10, 5 Yrs D.  per yr 1.77% 1.65% % Tot Ret 9.72% 10.70% Price Inc 3.67% P/E:  14.41 16.80 15.43% <-IRR #YR-> 5 Price & Dividend 109.97%
Price & Dividend 15 15.19% <-IRR #YR-> 15 Price & Dividend 640.13%
Price & Dividend 20 16.60% <-IRR #YR-> 20 Price & Dividend 1693.20%
Price & Dividend 25 18.76% <-IRR #YR-> 25 Price & Dividend 5540.43%
-$8.78 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.25
-$21.11 $0.00 $0.00 $0.00 $0.00 $40.25
-$8.78 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $40.88
-$21.11 $0.32 $0.38 $0.45 $0.54 $40.88
$0.14 $0.15 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $40.88
$0.14 $0.15 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $40.88
$0.14 $0.15 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $40.88
Month, Year Sep-06 Sep-07 Sep-08 Sep-09 Sep-10 Sep-11 Sep-12 Sep-13 Sep-14 Sep-15 Sep-16 Sep-17 Sep-18 Sep-19 Sep-20
Pre-split 02
Pre-split 15 $33.60 $35.00 $31.77 $34.73 $45.15 $44.69 $58.40 $64.74 $73.94
Price Close $11.20 $11.67 $10.59 $11.58 $15.05 $14.90 $19.47 $21.58 $24.65 $36.00 $43.07 $42.91 $40.25 $40.25 $40.25 267.80% <-Total Growth 10 Stock Price
Increase -1.00% 4.17% -9.23% 9.32% 30.00% -1.02% 30.68% 10.86% 14.21% 46.06% 19.64% -0.37% -6.20% 0.00% 0.00% 13.91% <-IRR #YR-> 10 Stock Price 267.80%
P/E 15.41 14.77 12.31 10.89 12.37 11.98 12.07 8.68 14.58 17.91 18.02 16.70 15.48 13.64 12.38 17.13% <-IRR #YR-> 5 Stock Price 120.43%
Trailer P/E 17.50 16.06 13.41 13.46 14.15 12.24 15.66 13.38 9.91 21.30 21.43 17.95 15.66 15.48 13.64 15.38% <-IRR #YR-> 10 Price & Dividend 298.15%
Median 10, 5 Yrs D.  per yr 1.47% 1.69% % Tot Ret 9.56% 8.98% Price Inc 14.21% P/E:  12.34 16.70 18.82% <-IRR #YR-> 5 Price & Dividend 141.36%
Price & Dividend 15 15.54% <-IRR #YR-> 15 Price & Dividend 676.34%
Price & Dividend 20 16.30% <-IRR #YR-> 20 Price & Dividend 1631.78%
Price & Dividend 25 20.10% <-IRR #YR-> 25 Price & Dividend 7164.53%
-$11.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.91
-$19.47 $0.00 $0.00 $0.00 $0.00 $42.91
-$11.67 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $43.54
-$19.47 $0.32 $0.38 $0.45 $0.54 $43.54
$0.14 $0.15 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $43.54
$0.14 $0.15 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $43.54
$0.14 $0.15 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $43.54
Price Median H/L $10.59 $12.37 $9.44 $11.22 $13.38 $15.27 $17.36 $21.99 $22.44 $31.17 $41.88 $42.90 $43.27 246.81% <-Total Growth 10 Stock Price
Increase 17.70% 16.77% -23.66% 18.81% 19.21% 14.17% 13.71% 26.67% 2.02% 38.90% 34.38% 2.44% 0.86% 13.24% <-IRR #YR-> 10 Stock Price 246.81%
P/E 14.58 15.66 10.98 10.55 10.99 12.28 10.76 8.84 13.28 15.50 17.52 16.69 16.64 19.83% <-IRR #YR-> 5 Stock Price 147.07%
Trailer P/E 16.55 17.02 11.95 13.05 12.58 12.55 13.97 13.63 9.02 18.44 20.84 17.95 16.84 14.67% <-IRR #YR-> 10 Price & Dividend 275.43%
P/E on Run. 5 yr Ave 17.85 18.82 13.15 13.75 14.36 14.76 14.48 14.43 13.60 17.23 20.55 19.24 19.21 21.64% <-IRR #YR-> 5 Price & Dividend 170.54%
P/E on Run. 10 yr Ave 24.38 25.12 16.95 17.58 18.35 18.76 18.70 19.61 18.20 22.75 27.26 25.02 22.91 11.71 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 1.43% 1.81% % Tot Ret 9.72% 8.37% Price Inc 26.67% P/E:  11.64 15.50 Count 24 Years of data
-$12.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $42.90
-$17.36 $0.00 $0.00 $0.00 $0.00 $42.90
-$12.37 $0.16 $0.18 $0.22 $0.24 $0.27 $0.32 $0.38 $0.45 $0.54 $43.53
-$17.36 $0.32 $0.38 $0.45 $0.54 $43.53
High Month Oct 05 Feb 07 Sep 07 Feb 09 Sep 10 Jul 11 Sep 12 Jul 13 Sep 14 Aug 15 Jul 16 May 17 May 17
Pre-split 02
Pre-split 15 $34.86 $40.25 $35.53 $39.65 $46.92 $49.15 $58.81 $74.97 $73.94
Price High $11.62 $13.42 $11.84 $13.22 $15.64 $16.38 $19.60 $24.99 $24.65 $37.62 $47.83 $47.07 $47.07 250.83% <-Total Growth 10 Stock Price
Increase -0.40% 15.46% -11.73% 11.60% 18.34% 4.75% 19.65% 27.48% -1.37% 52.64% 27.14% -1.59% 0.00% 13.37% <-IRR #YR-> 10 Stock Price 250.83%
P/E 15.99 16.98 13.77 12.43 12.85 13.18 12.15 10.05 14.58 18.72 20.01 18.32 18.10 19.15% <-IRR #YR-> 5 Stock Price 140.11%
Trailing P/E 18.16 18.46 14.99 15.37 14.71 13.47 15.77 15.49 9.91 22.26 23.80 19.69 18.32 14.58 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 27.14% P/E:  13.47 18.32 17.58 P/E Ratio Historical High
-$13.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $47.07
-$19.60 $0.00 $0.00 $0.00 $0.00 $47.07
Low Month Feb 06 Aug 07 Feb 08 Oct 08 Nov 09 Feb 11 Oct 11 Oct 12 Nov 13 Oct 14 Oct 15 Feb 17 Sep 17
Pre-split 02
Pre-split 15 $28.70 $33.97 $21.13 $27.67 $33.33 $42.47 $45.37 $56.99 $60.68
Price Low $9.57 $11.32 $7.04 $9.22 $11.11 $14.16 $15.12 $19.00 $20.23 $24.71 $35.93 $38.73 $39.47 242.04% <-Total Growth 10 Stock Price
Increase 51.05% 18.36% -37.80% 30.95% 20.46% 27.42% 6.83% 25.61% 6.47% 22.17% 45.41% 7.79% 1.91% 13.09% <-IRR #YR-> 10 Stock Price 242.04%
P/E 13.17 14.33 8.19 8.67 9.13 11.39 9.37 7.64 11.97 12.29 15.03 15.07 15.18 20.69% <-IRR #YR-> 5 Stock Price 156.09%
Trailing P/E 14.95 15.58 8.92 10.72 10.45 11.64 12.16 11.77 8.13 14.62 17.88 16.21 15.36 10.01 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 22.17% P/E:  10.38 12.29 7.94 P/E Ratio Historical Low
-$11.32 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38.73
-$15.12 $0.00 $0.00 $0.00 $0.00 $38.73
Long Term Debt $1,145 $1,231 $1,442 Debt
Change 7.50% 17.11% 12.30% <-Median-> 2 Change
Debt/Market Cap Ratio 0.13 0.12 0.15 0.13 <-Median-> 3 Debt/Market Cap Ratio
Goodwill & Intangibles $2,233 $2,221 $2,293 $2,311 $2,347 $2,363 Intangibles Goodwill
Change -0.53% 3.25% 0.78% 1.58% 0.67% 0.78% <-Median-> 5 Change
Intangible/Market Cap Ratio 0.39 0.37 0.37 0.26 0.23 0.24 0.32 <-Median-> 6 Intangible/Market Cap Ratio
Market Cap $M $3,855 $4,007 $3,512 $3,770 $4,744 $4,517 $5,676 $5,933 $6,266 $8,722 $10,100 $9,771 $9,166 $9,166 $9,166 143.86% <-Total Growth 10 Market Cap
Pre-split 15 115.9 116.6 113.3 111.1 107.4 103.6 99.6 95.5 88.1
Diluted # of Share in Million 347.7 349.8 339.9 333.3 322.2 310.8 298.8 286.5 264.3 251.2 239.3 230.6 230.6 230.6 230.6 -34.08% <-Total Growth 10 Diluted
Change 16.60% 0.60% -2.83% -1.94% -3.33% -3.54% -3.86% -4.12% -7.75% -4.96% -4.74% -3.64% 0.00% 0.00% 0.00% -4.08% <-IRR #YR-> 10 Diluted
-5.05% <-IRR #YR-> 5 Diluted
-349.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 230.6
-298.8 0.0 0.0 0.0 0.0 230.6
Pre-split 15 114.6 115.0 112.6 100.4 106.9 103.1 98.9 94.8 87.5
Basic # of Shares in Millions 343.8 345.0 337.8 301.2 320.7 309.3 296.7 284.4 262.5 248.9 237.1 228.7 228.7 228.7 228.7 -33.71% <-Total Growth 10 Average
Change 16.82% 0.35% -2.09% -10.83% 6.47% -3.55% -4.07% -4.15% -7.70% -5.18% -4.74% -3.54% 0.00% 0.00% 0.00% -4.11% <-Median-> 10 Change
Difference 0.1% -0.4% -1.8% 8.1% -1.7% -2.0% -1.7% -3.3% -3.1% -2.7% -1.1% -0.4% -1.77% <-Median-> 10 Difference
Pre-split 02
Pre-split 15 114.7 114.5 110.6 108.5 105.1 101.1 97.2 91.6 84.7
# of Share in M 344.2 343.5 331.7 325.6 315.2 303.3 291.6 274.9 254.2 242.3 234.5 227.7 227.7 227.7 227.7 -4.03% <-IRR #YR-> 10 Shares -33.70%
Change 0.27% -0.21% -3.43% -1.82% -3.21% -3.79% -3.86% -5.70% -7.53% -4.70% -3.21% -2.90% 0.00% 0.00% 0.00% -4.82% <-IRR #YR-> 5 Shares -21.90%
CF fr Op $M $392.0 $363.3 $450.2 $520.1 $547.8 $543.2 $546.1 $566.8 $432.3 $678.3 $707.4 $696.2 $813.0 $0.0 91.63% <-Total Growth 10 Cash Flow
Increase 39.06% -7.32% 23.92% 15.53% 5.33% -0.84% 0.53% 3.79% -23.73% 56.90% 4.29% -1.58% 16.77% S. Issue SO, Buy Backs
5 year Running Average $283.0 $310.5 $359.4 $401.5 $454.7 $484.9 $521.5 $544.8 $527.2 $553.3 $586.2 $616.2 $665.4 98.48% <-Total Growth 10 CF 5 Yr Running
CFPS $1.14 $1.06 $1.36 $1.60 $1.74 $1.79 $1.87 $2.06 $1.70 $2.80 $3.02 $3.06 $3.57 189.03% <-Total Growth 10 Cash Flow per Share
Increase 38.69% -7.12% 28.33% 17.66% 8.81% 3.07% 4.57% 10.06% -17.52% 64.64% 7.75% 1.35% 16.77% 6.72% <-IRR #YR-> 10 Cash Flow 91.63%
5 year Running Average $0.90 $0.96 $1.09 $1.19 $1.38 $1.51 $1.67 $1.81 $1.83 $2.05 $2.29 $2.53 $2.83 4.98% <-IRR #YR-> 5 Cash Flow 27.49%
P/CF on Med Price 9.30 11.69 6.96 7.03 7.70 8.52 9.27 10.67 13.19 11.13 13.88 14.03 12.12 11.20% <-IRR #YR-> 10 Cash Flow per Share 189.03%
P/CF on Closing Price 9.83 11.03 7.80 7.25 8.66 8.32 10.39 10.47 14.49 12.86 14.28 14.04 11.27 10.30% <-IRR #YR-> 5 Cash Flow per Share 63.23%
13.09% Diff M/C 10.19% <-IRR #YR-> 10 CFPS 5 yr Running 163.98%
Excl.Working Capital CF $10.60 $72.20 -$16.30 $1.20 $32.90 $24.4 $233.60 $244.80 $365.10 $189.80 $216.60 $264.70 $0.00 8.62% <-IRR #YR-> 5 CFPS 5 yr Running 51.20%
CF fr Op $M WC $402.6 $435.5 $433.9 $521.3 $580.7 $567.6 $779.7 $811.6 $797.4 $868.1 $924.0 $960.9 $813.0 120.64% <-Total Growth 10 Cash Flow less WC
Increase 47.69% 8.17% -0.37% 20.14% 11.39% -2.26% 37.37% 4.09% -1.75% 8.87% 6.44% 3.99% -15.40% 8.24% <-IRR #YR-> 10 Cash Flow less WC 120.64%
5 year Running Average $268.1 $313.0 $350.9 $413.2 $474.8 $507.8 $576.6 $652.2 $707.4 $764.9 $836.2 $872.4 $872.7 4.27% <-IRR #YR-> 5 Cash Flow less WC 23.24%
CFPS Excl. WC $1.17 $1.27 $1.31 $1.60 $1.84 $1.87 $2.67 $2.95 $3.14 $3.58 $3.94 $4.22 $3.57 10.79% <-IRR #YR-> 10 CF less WC 5 Yr Run 178.69%
Increase 47.30% 8.40% 3.18% 22.37% 15.08% 1.60% 42.88% 10.38% 6.25% 14.23% 9.97% 7.10% -15.40% 8.63% <-IRR #YR-> 5 CF less WC 5 Yr Run 51.29%
5 year Running Average $0.85 $0.96 $1.05 $1.23 $1.44 $1.58 $1.86 $2.19 $2.50 $2.84 $3.26 $3.57 $3.69 12.78% <-IRR #YR-> 10 CFPS - Less WC 232.79%
P/CF on Med Price 9.06 9.76 7.22 7.01 7.26 8.16 6.49 7.45 7.15 8.70 10.63 10.17 12.12 9.55% <-IRR #YR-> 5 CFPS - Less WC 57.79%
P/CF on Closing Price 9.58 9.20 8.09 7.23 8.17 7.96 7.28 7.31 7.86 10.05 10.93 10.17 11.27 14.05% <-IRR #YR-> 10 CFPS 5 yr Running 272.29%
*Operational Cash Flow per share Shares A & B) CF/CF-WC P/CF Med 10 yr 9.97 5 yr  13.19 P/CF Med 10 yr 7.36 5 yr  8.70 53.28% Diff M/C 13.91% <-IRR #YR-> 5 CFPS 5 yr Running 91.79%
-$1.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.06 Cash Flow per Share
-$1.87 $0.00 $0.00 $0.00 $0.00 $3.06 Cash Flow per Share
-$0.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.53 CFPS 5 yr Running
-$1.67 $0.00 $0.00 $0.00 $0.00 $2.53 CFPS 5 yr Running
-$435.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $960.9 Cash Flow less WC
-$779.7 $0.0 $0.0 $0.0 $0.0 $960.9 Cash Flow less WC
-$313.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $872.4 CF less WC 5 Yr Run
-$576.6 $0.0 $0.0 $0.0 $0.0 $872.4 CF less WC 5 Yr Run
-$1.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.22 CFPS - Less WC
-$2.67 $0.00 $0.00 $0.00 $0.00 $4.22 CFPS - Less WC
-$0.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.57 CFPS 5 yr Running
-$1.86 $0.00 $0.00 $0.00 $0.00 $3.57 CFPS 5 yr Running
Net change in non-cash working capital items -$44.40 -$68.90 -$99.50 $10.60 -$9.10 -$21.80
Interest paid -$48.00 -$42.50 -$50.70 -$58.10 -$60.60 -$59.30
Income taxes paid -$141.20 -$133.40 -$214.90 -$142.30 -$146.90 -$183.60
           
Sum -$233.60 -$244.80 -$365.10 -$189.80 -$216.60 -$264.70
Google -$244.80 -$365.10 -$189.80 -$216.60 -$264.70
Difference $0.00 $0.00 $0.00 $0.00 $0.00
OPM 3.6% 3.4% 4.2% 4.6% 4.8% 4.8% 4.5% 5.0% 3.7% 5.5% 5.5% 5.3% 54.82% <-Total Growth 10 OPM
Increase -14.92% -4.71% 22.99% 10.67% 3.91% -1.55% -4.32% 9.32% -24.96% 48.77% -0.31% -4.48% Should increase  or be stable.
Diff from Ave -25.2% -28.7% -12.4% -3.0% 0.8% -0.8% -5.1% 3.8% -22.1% 15.9% 15.5% 10.3% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 4.79% 5 Yrs 5.28% should be  zero, it is a   check on calculations
Current Assets $1,061.3 $1,054.7 $1,148.0 $1,283.2 $1,249.0 $1,323.8 $1,211.6 $1,188.5 $1,191.1 $1,172.9 $1,193.0 $1,356.3 Liquidity ratio of 1.5 and up, best
Current Liabilities $1,093.9 $1,069.1 $1,126.8 $1,152.4 $1,142.6 $1,144.9 $1,170.5 $1,206.3 $1,076.9 $1,063.8 $1,067.5 $1,285.9 1.10 <-Median-> 10 Ratio
Liquidity Ratio 0.97 0.99 1.02 1.11 1.09 1.16 1.04 0.99 1.11 1.10 1.12 1.05 1.10 <-Median-> 5 Ratio
Liq. with CF aft div 1.29 1.28 1.37 1.51 1.51 1.57 1.43 1.38 1.42 1.64 1.66 1.49 1.49 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  1.10 1.10 1.17 1.24 1.17 1.31 1.10 1.38 1.11 1.32 1.27 1.18 1.27 <-Median-> 5 Ratio
Curr Long Term Debt $12.4 $12.4 $16.5 $15.5 $15.5 Yes, current port. no change
Liquidity Less CLTD 1.00 1.12 1.12 1.13 1.07 1.12 <-Median-> 5 Ratio
Liq. with CF aft div 1.40 1.43 1.66 1.69 1.50 1.50 <-Median-> 5 Ratio
Assets $4,163.9 $4,273.9 $4,411.1 $4,666.2 $4,821.6 $4,958.8 $5,150.4 $5,061.5 $5,279.5 $5,387.1 $5,606.1 $6,050.7 Debt Ratio of 1.5 and up, best
Liabilities $2,440.1 $2,341.6 $2,350.0 $2,402.1 $2,378.8 $2,390.8 $2,605.3 $2,254.1 $2,595.4 $2,729.9 $2,912.9 $3,126.8 1.98 <-Median-> 10 Ratio
Debt Ratio 1.71 1.83 1.88 1.94 2.03 2.07 1.98 2.25 2.03 1.97 1.92 1.94 1.97 <-Median-> 5 Ratio
Total Book Value $1,724 $1,932 $2,061 $2,264 $2,443 $2,568 $2,545 $2,807 $2,684 $2,657 $2,693 $2,924 51.32% <-Total Growth 10 Book Value
NCI $1 $1 $16 $14 $13 $13
Book Value $1,724 $1,932 $2,061 $2,264 $2,443 $2,568 $2,544 $2,806 $2,669 $2,643 $2,681 $2,911 $2,911 $2,911 $2,911 50.65% <-Total Growth 10 Book Value
BV per share $5.01 $5.63 $6.21 $6.95 $7.75 $8.47 $8.73 $10.21 $10.50 $10.91 $11.43 $12.78 $12.78 $12.78 $12.78 127.23% <-Total Growth 10 Book Value per Share
Change 13.61% 12.34% 10.46% 11.88% 11.47% 9.27% 3.05% 16.95% 2.85% 3.94% 4.77% 11.84% 0.00% 0.00% 0.00% 52.57% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 2.12 2.20 1.52 1.61 1.73 1.80 1.99 2.15 2.14 2.86 3.66 3.36 2.15 P/B Ratio Historical Median
P/B Ratio (Close) 2.24 2.07 1.70 1.67 1.94 1.76 2.23 2.11 2.35 3.30 3.77 3.36 3.15 3.15 3.15 8.55% <-IRR #YR-> 10 Book Value per Share 127.23%
Change -12.86% -7.27% -17.82% -2.29% 16.63% -9.42% 26.81% -5.21% 11.05% 40.53% 14.19% -10.92% -6.20% 0.00% 0.00% 7.94% <-IRR #YR-> 5 Book Value per Share 46.49%
Leverage (A/BK) 2.42 2.21 2.14 2.06 1.97 1.93 2.02 1.80 1.97 2.03 2.08 2.07 2.03 <-Median-> 10 A/BV
Debt/Equity Ratio 1.42 1.21 1.14 1.06 0.97 0.93 1.02 0.80 0.97 1.03 1.08 1.07 1.03 <-Median-> 10 Debt/Eq Ratio
Median Values P/BV 10 yr Med 2.06 5 yr Med 2.86 52.57% Diff M/C
-$5.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12.78
-$8.73 $0.00 $0.00 $0.00 $0.00 $12.78
Comprehensive Income $439.5 $778.6 $439.8 $532.8 $518.3 $680.6 54.86% <-Total Growth 5 Comprehensive Income
NCI $7.5 $8.7 $9.1 $13.2 $14.7 $16.7 122.67% <-Total Growth 5 NCI
Shareholders $277.4 $290.0 $353.4 $393.5 $386.6 $432.0 $769.9 $430.7 $519.6 $503.6 $663.9 139.33% <-Total Growth 10 Comprehensive Income
Increase 4.54% 21.86% 11.35% -1.75% 11.74% 78.22% -44.06% 20.64% -3.08% 31.83% 20.6% <-Median-> 5 Comprehensive Income
5 Yr Running Average $340.2 $371.1 $467.1 $482.5 $507.8 $531.2 $577.5 9.12% <-IRR #YR-> 10 Comprehensive Income 139.33%
ROE 14.4% 14.1% 15.6% 16.1% 15.1% 17.0% 27.4% 16.1% 19.7% 18.8% 22.8% 8.97% <-IRR #YR-> 5 Comprehensive Income 53.68%
5Yr Median 15.1% 15.6% 16.1% 16.1% 17.0% 18.8% 19.7% 9.22% <-IRR #YR-> 6 5 Yr Running Average #DIV/0!
% Difference from NI 0.0% -0.1% 0.0% 0.1% 0.0% -2.0% 2.0% -0.6% 0.5% -2.5% 2.5% 9.25% <-IRR #YR-> 5 5 Yr Running Average 55.63%
Diff 5, 10 yr 0.0% 0.5%
-$277.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $663.9
-$432.0 $0.0 $0.0 $0.0 $0.0 $663.9
-$340.2 $0.0 $0.0 $0.0 $0.0 $0.0 $577.5
-$371.1 $0.0 $0.0 $0.0 $0.0 $577.5
Current Liability Coverage Ratio 0.37 0.41 0.39 0.45 0.51 0.50 0.67 0.67 0.74 0.82 0.87 0.75   CFO / Current Liabilities
5 year Median 0.35 0.35 0.37 0.39 0.41 0.45 0.50 0.51 0.67 0.67 0.74 0.75 0.75 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 9.67% 10.19% 9.84% 11.17% 12.04% 11.45% 15.14% 16.03% 15.10% 16.11% 16.48% 15.88% CFO / Total Assets
5 year Median 13.41% 10.19% 9.84% 9.84% 10.19% 11.17% 11.45% 12.04% 15.10% 15.14% 16.03% 16.03% 16.0% <-Median-> 5 Return on Assets 
Return on Assets ROA 6.1% 6.5% 6.6% 7.6% 8.1% 7.8% 9.4% 14.1% 8.5% 9.4% 10.2% 9.8% Net  Income/Assets Return on Assets
5Yr Median 10.8% 6.5% 6.5% 6.5% 6.6% 7.6% 7.8% 8.1% 8.5% 9.4% 9.4% 9.8% 9.8% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 14.7% 14.3% 14.2% 15.7% 16.0% 15.0% 18.9% 25.4% 16.8% 19.1% 21.3% 20.3% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 19.8% 14.7% 14.3% 14.3% 14.7% 15.0% 15.7% 16.0% 16.8% 18.9% 19.1% 20.3% 20.3% <-Median-> 5 Return on Equity
Net Income $489.3 $721.6 $456.2 $519.3 $586.2 $608.4 Net Income
NCI $7.5 $8.7 $9.1 $13.2 $14.7 $16.7 NCI
Shareholders $253.0 $276.6 $292.7 $354.4 $391.8 $386.3 $481.8 $712.9 $447.1 $506.1 $571.5 $591.7 $624 $745 $795 113.92% <-Total Growth 10 Net Income
Increase 32.88% 9.33% 5.82% 21.08% 10.55% -1.40% 24.72% 47.97% -37.28% 13.20% 12.92% 3.53% 5.46% 19.39% 6.71% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $184.5 $211.1 $236.3 $273.4 $313.7 $340.4 $381.4 $465.4 $484.0 $506.8 $543.9 $565.9 $548.1 $607.7 $665.4 7.90% <-IRR #YR-> 10 Net Income 113.92%
Operating Cash Flow $392.0 $363.3 $450.2 $520.1 $547.8 $543.2 $546.1 $566.8 $432.3 $678.3 $707.4 $696.2 4.20% <-IRR #YR-> 5 Net Income 22.81%
Investment Cash Flow -$181.9 -$169.6 -$188.6 -$258.8 -$339.8 -$227.0 -$357.0 $264.3 -$299.8 -$253.1 -$328.3 -$333.0 10.36% <-IRR #YR-> 10 5 Yr Running Ave. 168.03%
Total Accruals $42.9 $82.9 $31.1 $93.1 $183.8 $70.1 $292.7 -$118.2 $314.6 $80.9 $192.4 $228.5 8.21% <-IRR #YR-> 5 5 Yr Running Ave. 48.36%
Total Assets $4,163.9 $4,273.9 $4,411.1 $4,666.2 $4,821.6 $4,958.8 $5,150.4 $5,061.5 $5,279.5 $5,387.1 $5,606.1 $6,050.7 Balance Sheet Assets
Accruals Ratio 1.03% 1.94% 0.71% 2.00% 3.81% 1.41% 5.68% -2.34% 5.96% 1.50% 3.43% 3.78% 3.43% <-Median-> 5 Ratio
EPS/CF Ratio 0.62 0.62 0.66 0.66 0.66 0.66 0.60 0.84 0.54 0.56 0.61 0.61 0.63 <-Median-> 10 EPS/CF Ratio
Should not be higher than 1.00
-$277 $0 $0 $0 $0 $0 $0 $0 $0 $0 $592
-$482 $0 $0 $0 $0 $592
-$211 $0 $0 $0 $0 $0 $0 $0 $0 $0 $566
-$381 $0 $0 $0 $0 $566
Change in Close -1.0% 4.2% -9.2% 9.3% 30.0% -1.0% 30.7% 10.9% 14.2% 46.1% 19.6% -0.4% -6.2% 0.0% 0.0% Count 24 Years of data
Expected? down down Count 7 29.17%
Happened? Yes % right Count 2 28.57%
Financial Cash Flow -$138.2 -$169.6 -$210.4 -$171.6 -$234.7 -$275.4 -$371.3 -$823.6 -$177.3 -$439.7 -$373.1 -$241.8 C F Statement  Financial CF
Total Accruals $181.1 $252.5 $241.5 $264.7 $418.5 $345.5 $664.0 $705.4 $491.9 $520.6 $565.5 $470.3 Accruals
Accruals Ratio 4.35% 5.91% 5.47% 5.67% 8.68% 6.97% 12.89% 13.94% 9.32% 9.66% 10.09% 7.77% 9.66% <-Median-> 5 Ratio
Cash $151.7 $241.4 $214.7 $255.5 $73.3 $80.7 $36.0 $21.5 $27.5 $148.9 Cash
Cash per Share $0.46 $0.74 $0.68 $0.84 $0.25 $0.29 $0.14 $0.09 $0.12 $0.65 $0.14 <-Median-> 5 Cash per Share
Percentage of Stock Price 4.32% 6.40% 4.53% 5.66% 1.29% 1.36% 0.57% 0.25% 0.27% 1.52% 0.57% <-Median-> 5 % of Stock Price
https://allaboutthedividends.wordpress.com/ 
Notes:
December 30, 2017.  Last estimates were for 2017, 2018 and 2019 of $13175M, $13658M and 13696M for Revenue, $2.85, $2.85 and $2.91 for EPS, $3.57 and 3.84 for CFPS for 2017 and 2018 and $595M and $634M for Net Income for 2017 and 2018.
$3.57 and 3.84 for CFPS for 2017 and 2018 and $595M and $634M for Net Income for 2017 and 2018.
December 31, 2016.  Last estimates were for 2016, 2017 and 2018 of $12578M, $12991M and $13171M for Revenue, $2.22, $2.38 and $2.41 for EPS, 
$2.89, $3.00 and $3.15 for CFPS and $531M, $570M and $577M for Net Income.
December 27, 2015.  Last estimates were for 2015, 2016 and 2017 of $12013M, $12251M and $12504M for Revenue, $1.89, $2.07 and $2.25 for EPS, 
$8.35, $8.87 and $9.01 for CFPS and $482M, $511M and $572M for Net Income.
Dececmember 27, 2014.  Last estimates were for 2014. 2015 and 2016 of $11485M, $11640M and $11867M for Revenue, $5.22, $5.70 and $6.16 for ESP, $7.57, 8.35 and $8.94 for CFPS.
December 27, 2013.  Last Estimates were for 2013 and 2014 of $12076 and $12337M for Revenue, $5.07 and $5.49 for EPS.
January 19, 2012.  Laat estimates were for $11871M and $12074M Revenue, $4.27 and $4.65 EPS and $6.02 and f$6.49 CFPS.
Dec 31, 2011.  Last I checked I got estimates for 2011 and 2012 of $3.88 and $4.19 for EPS and $6.11 and $6.50 for CF.
Dec 31, 2010.  The last time I reviewed this stock, I got estimates for 2010 and 2011 for earnings of 3.40 and $3.70 and CF of $5.10 and $5.55.
Jan 08, 2010.  When I last looked at this stock in Mar 2009, I got 2009 earnings of $2.57
2008.  This stock is doing very well. One concern is lack of Revenue growth for 2007 and 2008.
2007.  I was doing well up to Sept 2007.
2006.  Dividend rate is low, but increasing rapidly.  Sales are not increasing more than earnings.  Accural Ratio is much better.
2005: I am  still happy with this stock.  It seems to be leaverage, which is not good, but sales and Dividends and Earnings per share are increasing. Negatatives are: Accrual Ratio is high, debt is high and earnings 
per share are increasing faster than sales.
2004: This stock is doing what I bought it for.  I am still happy with it.  However, I note current liability and current assets are close.  2004
2003: This stock is doing exactly what I bought it to do.  Good Dividend Growth and reasonable stock price growth. I am still happy with it.
In 2012 the company converted  Class B shares into Class A shares and Class A shares into Common Shares.  There are no longer multiple voting Shares
Class B shares have 16 votes each.  They are mostly owned by independent store owners.  Class B shares have about 8.9% of the vote. 
Serge Ferland is the only director with Class B shares and he has just over 10,000 of the 630,000 outstanding
They have been increasing their dividends since 1995.
Sector:
Consumer Staple
What should this stock accomplish?
Since this is a consumer staple stock, it should have stability to your portfolio.  You should expect low dividends and good increase.  You would buy for increasing dividends and capital gains.
Would I buy this company and Why.
I think that this is a solid dividend growth company and should be considered when looking at Consumer Staple stocks.
Why am I following this stock. 
I was following this stock before I bought it because it was on Mike Higgs' Canadian Dividend Growth stock list and on the other dividend lists that I was following.
Dividends
Dividends are paid between cycle 2 and 3.  Generally, they are paid in November, March, June, and September and each year.  Dividends are declared in one month for shareholders of record in the following month and then paid in the next month.
For example, The dividend declared on January 28, 2013 is for shareholders of record of February 19, 2013 and is payable on March 15, 2013.
Dividend Policy
The Company has a policy of paying dividends representing 20 to 30% of its net earnings from the previous year before extraordinary items.
Misson Statement or closes thing I can find.
Metro inc. employs in Quebec and Ontario over 65,000 people, whose mission is to satisfy their customers every day and earn their long-term loyalty.
Why I bought this stock.
I bought this stock first at the end of 2001 because it is a good time to purchase as market is relatively low and Metro was on my hit list.  Metro's P/E is relatively low for this stock.
I brought this stock in 2004 as I was looking for something I already own, that has increasing dividends and reasonable P/E for stock at this time.
By 2009, Metro stock was over 10% of my portfolio because it had grown so strong, so I sold some to reduce the percentage of it in my portfolio.
How they make their money
Metro Inc.is a leader in food and pharmaceutical distribution in Quebec and Ontario, where it operates a network of more than 600 food stores under several banners including Metro, 
Metro Plus, Super C and Food Basics, as well as over 250 drugstores under the Brunet, Metro Pharmacy and Drug Basics banners.
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.
Copyright © 2008 Website of SPBrunner. All rights reserved.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Jan 19 2012 Dec 27 2013 Dec 27 2014 Dec 27 2015 Dec 31 2016 Dec 30 2017
Richer La Flèche, Eric 0.422 0.15% 0.449 0.18% 0.238 0.10% 0.247 0.11% 0.252 0.11% 0.256 0.11%
CEO - Shares - Amount $9.109 $11.071 $8.567 $10.628 $10.804 $10.295
Options - percentage 1.695 0.62% 1.547 0.61% 1.611 0.66% 1.719 0.73% 1.555 0.68% 1.231 0.54% exclude Sub.Vot. Shares A '17
Options - amount $36.572 $38.129 $57.991 $74.028 $66.723 $49.536 Do not know what they are
Thibault, François 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.001 0.00% 0.012 0.01% 0.018 0.01%
CFO - Shares - Amount $0.000 $0.000 $0.000 $0.043 $0.495 $0.718
Options - percentage 0.078 0.03% 0.035 0.01% 0.169 0.07% 0.299 0.13% 0.208 0.09% 0.225 0.10%
Options - amount $1.683 $0.867 $6.083 $12.885 $8.922 $9.045
Allaire, Martin 0.025 0.01% 0.025 0.01% 0.026 0.01% 0.092 0.04% 0.051 0.02% 0.034 0.02%
Officer - Shares - Amount $0.544 $0.621 $0.943 $3.957 $2.199 $1.384
Options - percentage 0.108 0.04% 0.108 0.04% 0.088 0.04% 0.114 0.05% 0.082 0.04% 0.042 0.02% exclude Sub.Vot. Shares A '17
Options - amount $2.336 $2.668 $3.171 $4.929 $3.515 $1.672
Bich, Geneviève 0.003 0.00% 0.005 0.00% Vice President, 
Officer - Shares - Amount $0.108 $0.194 Human Resources
Options - percentage 0.056 0.02% 0.061 0.03%
Options - amount $2.385 $2.473
DeSerres, Marc 0.008 0.00% 0.008 0.00% 0.000 0.00% 0.043 0.02% 0.043 0.02% 0.043 0.02%
Director - Shares - Amount $0.182 $0.208 $0.000 $1.864 $1.857 $1.742
Options - percentage 0.030 0.01% 0.033 0.01% 0.062 0.03% 0.046 0.02% 0.048 0.02% 0.041 0.02% exclude Sub.Vot. Shares A '17
Options - amount $0.647 $0.805 $2.244 $1.976 $2.045 $1.663
Raymont, Real 0.054 0.02% 0.054 0.02% 0.054 0.02%
Chairman - Shares - Amt $2.326 $2.317 $2.174
Options - percentage 0.045 0.02% 0.048 0.02% 0.034 0.01% exclude Sub.Vot. Shares A '17
Options - amount $1.931 $2.066 $1.351
Lessard, Pierre H. 1.202 0.44% 1.131 0.44% 0.496 0.20%
Chairman - Shares - Amt $25.932 $27.872 $17.848 Chairman in 2014
Options - percentage 0.042 0.02% 0.108 0.04% 0.673 0.28%
Options - amount $0.906 $2.668 $24.243
Pelletier, Guy 1.444 0.53% Last filing in Feb 2005??
10% Holder $31.163
Increase in O/S Shares 0.445 0.16% 0.567 0.22% 0.760 0.31% 0.730 0.31% 0.641 0.28%
due to SO $9.603 $13.975 $18.731 $31.441 $27.505
Book Value $17.400 $8.600 $9.900 $12.400 $12.900
Insider Buying -$0.035 -$0.034 -$0.345 $0.000
Insider Selling $20.474 $16.171 $4.433 $16.198
Net Insider Selling $20.438 $16.137 $4.088 $16.198
% of Market Cap 0.23% 0.16% 0.04% 0.17%
Directors 15 14 14 14 13
Women 3 20% 3 21% 5 36% 5 36% 5 38%
Minorities 0 0% 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 57 68.54% 199 77.38% 249 72.64% 231 46.88% 257 45.71% 257 50.84%
Total Shares Held 129.327 50.87% -210.684 -82.87% 183.756 75.84% 112.234 47.86% 106.320 46.69% 115.776 50.84%
Increase/Decrease 20.869 13.89% -5.418 2.64% 4.769 2.66% -1.124 -0.99% 2.995 2.90% 12.759 12.39%
Starting No. of Shares 150.196 -205.266 178.987 113.358 103.325 103.017
Copyright © 2008 Website of SPBrunner. All rights reserved.