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/16
Magna International Inc. TSX: MG NYSE: MGA www.magna.com Fiscal Yr: Dec-31 Q3 2016
Year 12/31/04 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 Value Description #Y Item Currency
Accounting Rules C GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP
Fiscal year
Report Currency
CDN$-US$ 1.2036 1.1659 1.1653 0.9881 1.2246 1.0466 0.9946 1.0170 0.9949 1.0636 1.1601 1.3847 1.3535 1.3535 1.3535 18.77% <-Total Growth 10 CDN$-US$
Split Date 3/26/15
Split 2 2
$35,760 <-12 mths 11.28%
Revenue US$ $20,653 $22,811 $24,180 $26,067 $23,704 $17,367 $24,102 $28,748 $30,837 $34,835 $36,641 $32,134 $36,231 $37,534 $40,298 40.87% <-Total Growth 10 Revenue US$
Increase 34.6% 10.4% 6.0% 7.8% -9.1% -26.7% 38.8% 19.3% 7.3% 13.0% 5.2% -12.3% 12.7% 3.6% 7.4% 3.49% <-IRR #YR-> 10 Revenue US$
5 year Running Average $13,998 $16,457 $19,192 $21,811 $23,483 $22,826 $23,084 $23,998 $24,952 $27,178 $31,033 $32,639 $34,136 $35,475 $36,568 5.92% <-IRR #YR-> 5 Revenue US$
Revenue per Share $53.26 $52.19 $55.01 $56.14 $52.63 $38.54 $49.68 $61.61 $66.13 $78.76 $89.30 $79.88 $94.25 $97.64 $104.83 7.09% <-IRR #YR-> 10 5 yr Running Average US$
Increase 33.85% -2.02% 5.42% 2.05% -6.27% -26.77% 28.91% 24.00% 7.34% 19.10% 13.38% -10.54% 17.99% 3.60% 7.36% 7.17% <-IRR #YR-> 5 5 yr Running Average US$
5 year Running Average $38.39 $42.14 $46.84 $51.28 $53.85 $50.90 $50.40 $51.72 $53.72 $58.94 $69.09 $75.13 $81.66 $87.97 $93.18 4.35% <-IRR #YR-> 10 Revenue per Share US$
P/S (Price/Sales) Med 0.40 0.33 0.35 0.37 0.25 0.23 0.40 0.38 0.32 0.44 0.54 0.62 9.96% <-IRR #YR-> 5 Revenue per Share US$
P/S (Price/Sales) Close 0.39 0.34 0.37 0.36 0.14 0.33 0.52 0.27 0.38 0.52 0.61 0.51 0.46 0.45 0.42 5.95% <-IRR #YR-> 10 5 yr Running Average US$
*Revenue in M US$ P/S Med 10 yr 0.38 5 yr 0.44 23.03% Diff M/C 8.31% <-IRR #YR-> 5 5 yr Running Average US$
-$22,811 $0 $0 $0 $0 $0 $0 $0 $0 $0 $32,134
-$24,102 $0 $0 $0 $0 $32,134
-$16,457 $0 $0 $0 $0 $0 $0 $0 $0 $0 $32,639
-$23,084 $0 $0 $0 $0 $32,639
-$52.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $79.88
-$49.68 $0.00 $0.00 $0.00 $0.00 $79.88
-$42.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $75.13
-$50.40 $0.00 $0.00 $0.00 $0.00 $75.13
$48,401 <-12 mths 8.77%
Revenue CDN$* $24,858 $26,595 $28,177 $25,757 $29,028 $18,176 $23,972 $29,237 $30,680 $37,051 $42,507 $44,497 $49,039 $50,802 $54,543 67.31% <-Total Growth 10 Revenue CDN$
Increase 25.4% 7.0% 5.9% -8.6% 12.7% -37.4% 31.9% 22.0% 4.9% 20.8% 14.7% 4.7% 10.2% 3.6% 7.4% 5.28% <-IRR #YR-> 10 Revenue CDN$
5 year Running Average $19,536 $21,701 $23,990 $25,043 $26,883 $25,547 $25,022 $25,234 $26,219 $27,823 $32,689 $36,794 $40,755 $44,779 $48,278 13.17% <-IRR #YR-> 5 Revenue CDN$
Revenue per Share $64.10 $60.84 $64.11 $55.48 $64.45 $40.33 $49.41 $62.65 $65.79 $83.77 $103.59 $110.62 $127.57 $132.16 $141.89 5.42% <-IRR #YR-> 10 5 yr Running Average CDN$
Increase 24.66% -5.09% 5.37% -13.46% 16.17% -37.41% 22.51% 26.80% 5.01% 27.32% 23.67% 6.78% 15.32% 3.60% 7.36% 8.02% <-IRR #YR-> 5 5 yr Running Average CDN$
5 year Running Average $53.90 $56.03 $58.81 $59.19 $61.80 $57.04 $54.76 $54.46 $56.53 $60.39 $73.04 $85.28 $98.27 $111.54 $123.17 6.16% <-IRR #YR-> 10 Revenue per Share CDN$
P/S (Price/Sales) Med 0.41 0.36 0.33 0.41 0.22 0.25 0.40 0.37 0.32 0.42 0.51 0.58 17.49% <-IRR #YR-> 5 Revenue per Share CDN$
P/S (Price/Sales) Close 0.38 0.35 0.36 0.36 0.14 0.33 0.53 0.27 0.38 0.52 0.61 0.51 0.46 0.45 0.42 4.29% <-IRR #YR-> 10 5 yr Running Average CDN$
*Revenue in M Cdn $ (Total Sales) P/S Med 10 yr 0.39 5 yr 0.42 18.90% Diff M/C 9.27% <-IRR #YR-> 5 5 yr Running Average CDN$
-$26,595 $0 $0 $0 $0 $0 $0 $0 $0 $0 $44,497
-$23,972 $0 $0 $0 $0 $44,497
-$21,701 $0 $0 $0 $0 $0 $0 $0 $0 $0 $36,794
-$25,022 $0 $0 $0 $0 $36,794
-$60.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $110.62
-$49.41 $0.00 $0.00 $0.00 $0.00 $110.62
-$56.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $85.28
-$54.76 $0.00 $0.00 $0.00 $0.00 $85.28
$5.09 <-12 mths 4.30%
Pre-Split 2015 $3.59 $3.00 $2.43 $2.98 $0.32 -$2.21 $4.23 $4.26 $6.17 $6.85 $8.81
EPS Basic US$ $1.79 $1.50 $1.22 $1.49 $0.16 -$1.11 $2.12 $2.13 $3.09 $3.43 $4.41 $4.94 229.33% <-Total Growth 10 EPS Basic US$
Pre-Split 2010 $7.13 $5.90 $4.78 $5.86 $0.62 -$4.41
Pre-Split 2015 $3.57 $2.95 $2.39 $2.93 $0.31 -$2.21 $4.18 $4.20 $6.09 $6.76 $8.69
EPS Diluted $1.78 $1.48 $1.20 $1.47 $0.16 -$1.10 $2.09 $2.10 $3.05 $3.38 $4.35 $4.88 $5.22 $5.68 $6.44 230.85% <-Total Growth 10 EPS Diluted US$
Increase 36.9% -17.3% -19.0% 22.6% -89.4% -811.3% -289.6% 0.5% 45.0% 11.0% 28.6% 12.3% 7.0% 8.8% 13.4% 12.71% <-IRR #YR-> 10 Earnings per Share US$
Earnings Yield 8.6% 8.2% 5.9% 7.3% 2.1% -8.7% 8.0% 12.6% 12.2% 8.2% 8.0% 12.0% 12.0% 13.0% 14.8% 18.48% <-IRR #YR-> 5 Earnings per Share US$ 133.49%
5 year Running Average $1.54 $1.51 $1.44 $1.44 $1.21 $0.64 $0.76 $0.94 $1.26 $1.90 $2.99 $3.55 $4.17 $4.70 $5.31 8.90% <-IRR #YR-> 10 5 yr Running Average US$
10 year Running Average $1.15 $1.24 $1.30 $1.36 $1.32 $1.09 $1.14 $1.19 $1.35 $1.56 $1.81 $2.16 $2.56 $2.98 $3.61 36.09% <-IRR #YR-> 5 5 yr Running Average US$
* ESP per share, Diluted (Cdn GAAP) E/P 10 Yrs 8.02% 5Yrs 12.03% US$
-$1.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.88
-$2.09 $0.00 $0.00 $0.00 $0.00 $4.88
-$1.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.55
-$0.76 $0.00 $0.00 $0.00 $0.00 $3.55
$6.89 <-12 mths 1.95%
EPS Basic CDN$ $2.16 $1.75 $1.42 $1.47 $0.20 -$1.16 $2.10 $2.17 $3.07 $3.64 $5.11 $6.84 291.15% <-Total Growth 10 EPS Basic CDN$
Pre-Split 2010
Pre-Split 2015
EPS Diluted $2.15 $1.72 $1.39 $1.45 $0.19 -$1.15 $2.08 $2.14 $3.03 $3.59 $5.04 $6.76 $7.07 $7.69 $8.72 292.95% <-Total Growth 10 EPS Diluted CDN$
Increase 27.5% -19.8% -19.0% 4.0% -86.9% -707.9% -280.2% 2.7% 41.8% 18.7% 40.2% 34.1% 4.6% 8.8% 13.4% 14.67% <-IRR #YR-> 10 Earnings per Share CDN$
Earnings Yield 8.7% 8.2% 6.0% 7.2% 2.1% -8.7% 8.0% 12.6% 12.2% 8.3% 8.0% 12.0% 12.0% 13.0% 14.8% 26.59% <-IRR #YR-> 5 Earnings per Share CDN$
5 year Running Average $2.20 $2.06 $1.85 $1.68 $1.38 $0.72 $0.79 $0.94 $1.26 $1.94 $3.18 $4.11 $5.10 $6.03 $7.05 7.14% <-IRR #YR-> 10 5 yr Running Average CDN$
10 year Running Average $1.65 $1.73 $1.80 $1.82 $1.74 $1.46 $1.43 $1.39 $1.47 $1.66 $1.95 $2.45 $3.02 $3.64 $4.50 39.05% <-IRR #YR-> 5 5 yr Running Average CDN$
* ESP per share, Diluted (Cdn GAAP) E/P 10 Yrs 8.01% 5Yrs 12.04%
-$1.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.76
-$2.08 $0.00 $0.00 $0.00 $0.00 $6.76
-$2.06 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.11
-$0.79 $0.00 $0.00 $0.00 $0.00 $4.11
Special Dividends US$ $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 US$
Pre-Split 2010 $1.48 $1.52 $1.52 $1.15 $1.26 $0.18
Pre-Split 2015 $0.74 $0.76 $0.76 $0.58 $0.63 $0.09 $0.42 $1.00 $1.10 $1.28 $1.52
Dividend US$ $0.37 $0.38 $0.38 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $0.88 $1.00 $1.00 $1.00 131.58% <-Total Growth 10 Dividends US$
Increase 8.82% 2.70% 0.00% -24.34% 9.57% -85.71% 366.67% 138.10% 10.00% 16.36% 18.75% 15.79% 13.64% 0.00% 0.00% Count 24 Years of data US$
Dividends 5 Yr Running $0.34 $0.35 $0.36 $0.35 $0.35 $0.28 $0.25 $0.27 $0.32 $0.39 $0.53 $0.67 $0.77 $0.86 $0.93 88.14% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 1.72% 2.18% 1.99% 1.37% 2.40% 0.51% 1.07% 2.15% 2.62% 1.86% 1.56% 1.77% 2.56% 1.82% <-Median-> 10 Yield H/L Price US$
Yield on High Price 1.74% 1.92% 1.84% 1.19% 1.55% 0.35% 0.81% 1.63% 2.20% 1.48% 1.33% 1.50% 2.14% 1.49% <-Median-> 10 Yield on High Price US$
Yield on Low Price 1.71% 2.51% 2.17% 1.61% 5.36% 0.90% 1.58% 3.19% 3.23% 2.50% 1.89% 2.17% 3.18% 2.17% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 1.79% 2.11% 1.89% 1.43% 4.21% 0.36% 0.81% 3.00% 2.20% 1.56% 1.40% 2.17% 2.29% 2.29% 2.29% 1.72% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 20.76% 25.76% 31.80% 19.62% 203.23% -4.08% 10.05% 23.81% 18.06% 18.93% 17.49% 18.03% 19.16% 17.61% 15.53% 18.50% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 22.08% 23.40% 25.10% 24.34% 28.53% 44.16% 32.54% 28.84% 25.77% 20.45% 17.78% 18.76% 18.35% 18.21% 17.47% 25.43% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 10.39% 9.78% 10.46% 8.38% 13.46% 3.85% 5.44% 19.28% 12.02% 11.03% 11.17% 15.18% 11.61% 10.67% 11.14% 11.10% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 10.82% 10.11% 10.03% 9.95% 10.28% 9.74% 8.58% 10.14% 11.14% 10.80% 11.25% 13.02% 12.12% 11.76% 11.73% 10.21% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 9.69% 10.79% 11.61% 7.91% 10.68% 3.27% 6.01% 12.67% 12.44% 10.51% 10.27% 13.23% 11.61% 10.67% 11.14% 10.59% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 9.50% 9.69% 9.82% 9.99% 10.07% 9.54% 8.40% 8.81% 10.01% 10.06% 10.49% 11.68% 11.54% 11.23% 11.31% 10.00% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 5 Yr Med 5 Yr Cl 1.86% 2.17% 5 Yr Med Payout 18.06% 12.02% 12.44% 8.76% <-IRR #YR-> 5 Dividends US$
* Dividends per share 5 Yr Med and Cur. 23.28% 5.76% Last Div Inc ---> $0.220 $0.250 13.6% 33.18% <-IRR #YR-> 4 Dividends US$
-$0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.88
-$0.21 $0.00 $0.00 $0.00 $0.00 $0.88
Historical Dividends Historical High Div 3.26% Low Div 0.54% Ave Div 1.90% Med Div 1.75% Close Div 1.63% Historical Dividends
High/Ave/Median Values Curr diff Exp. -29.61% 324.93% Cheap 20.77% Cheap 31.12% Cheap 40.83% High/Ave/Median
Special Dividends CDN$ $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 CDN$
Using Currency exchange R. $0.05 $0.21 $0.51 $0.55 $0.68 $0.88 $1.22 $1.35 $1.35 $1.35 Not site values Using Curr. exch R.
Increase 343.48% 143.46% 7.61% 24.40% 29.52% 38.21% 11.07% 0.00% 0.00% Increase
Pre-Split 2010 $0.23
Pre-Split 2015 $0.12 $0.44 $0.99 $1.10 $1.34 $1.68
Dividend CDN$ $0.45 $0.44 $0.44 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $1.14 $1.35 $1.35 $1.35 157.71% <-Total Growth 10 Dividends CDN$
Increase 1.35% -0.51% -0.05% -35.85% 35.79% -84.95% 277.54% 124.65% 11.88% 21.27% 26.04% 35.56% 18.54% 0.00% 0.00% Count 24 Years of data CDN$
Dividends 5 Yr Running $0.49 $0.48 $0.46 $0.41 $0.40 $0.32 $0.28 $0.29 $0.34 $0.40 $0.55 $0.74 $0.91 $1.07 $1.21 53.59% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 1.71% 2.05% 2.07% 1.25% 2.76% 0.58% 1.10% 2.10% 2.62% 1.90% 1.59% 1.77% 2.56% 1.84% <-Median-> 10 Yield H/L Price CDN$
Yield on High Price 1.55% 1.82% 1.90% 1.13% 1.90% 0.43% 0.84% 1.61% 2.22% 1.48% 1.34% 1.55% 2.19% 1.51% <-Median-> 10 Yield on High Price CDN$
Yield on Low Price 1.90% 2.35% 2.27% 1.42% 5.01% 0.90% 1.58% 3.02% 3.20% 2.64% 1.97% 2.08% 3.09% 2.18% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 1.81% 2.11% 1.90% 1.42% 4.20% 0.44% 0.84% 2.90% 2.22% 1.53% 1.34% 2.03% 2.29% 2.29% 2.29% 1.72% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 20.76% 25.76% 31.80% 19.62% 203.23% -5.03% 10.55% 23.06% 18.19% 18.59% 16.71% 16.90% 19.16% 17.61% 15.53% 18.39% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 22.05% 23.33% 24.98% 24.49% 29.02% 44.88% 35.15% 30.65% 27.18% 20.54% 17.46% 17.98% 17.88% 17.78% 17.14% 26.08% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 10.4% 9.8% 10.5% 8.4% 13.5% 4.7% 5.7% 18.7% 12.1% 10.8% 10.7% 14.2% 11.6% 10.7% 11.1% 10.75% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 10.82% 10.09% 9.97% 10.02% 10.37% 9.94% 8.94% 10.32% 11.29% 10.80% 11.05% 12.62% 11.90% 11.54% 11.53% 10.34% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 9.7% 10.8% 11.6% 7.9% 10.7% 4.0% 6.3% 12.3% 12.5% 10.3% 9.8% 12.4% 11.6% 10.7% 11.1% 10.50% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 9.46% 9.61% 9.66% 10.06% 10.15% 9.74% 8.72% 8.92% 10.07% 10.04% 10.29% 11.31% 11.30% 11.02% 11.13% 10.05% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median Values 5 Yr Med 5 Yr Cl 1.90% 2.03% 5 Yr Med Payout 18.19% 12.10% 12.28% 9.93% <-IRR #YR-> 10 Dividends CDN$
* Dividends per share 5 Yr Med and Cur. 20.68% 12.59% Last Div Inc ---> $0.305 $0.338 11.1% 39.10% <-IRR #YR-> 5 Dividends CDN$
-$0.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.14
-$0.22 $0.00 $0.00 $0.00 $0.00 $1.14
Historical Dividends Historical High Div 3.32% Low Div 0.57% Ave Div 1.95% Med Div 1.74% Close Div 1.61% Historical Dividends CDN$
High/Ave/Median Values Curr diff Exp. -31.01% 301.86% Cheap 17.77% Cheap 31.64% Cheap 42.11% High/Ave/Median CDN$
Future Dividend Yield Div Yd 2.66% earning in 5 Years at IRR of 3.00% Div Inc. 15.93% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 3.08% earning in 10 Years at IRR of 3.00% Div Inc. 34.39% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 3.57% earning in 15 Years at IRR of 3.00% Div Inc. 55.80% Future Dividend Yield CDN$
H/LYield held 5 yrs 2.31% 2.65% 2.12% 1.14% 1.62% 0.22% 1.01% 2.30% 2.43% 4.78% 8.38% 5.71% 5.77% 6.43% 3.84% 2.21% <-Median-> 10 Paid Median Price CDN$
H/LYield held 10 yrs 3.06% 3.30% 2.74% 1.35% 1.58% 0.30% 1.31% 2.35% 2.20% 2.80% 3.23% 5.28% 6.32% 5.98% 9.68% 2.28% <-Median-> 10 Paid Median Price CDN$
H/LYield held 15 yrs 14.17% 4.84% 4.20% 0.40% 1.63% 3.05% 2.61% 2.74% 4.37% 6.83% 6.47% 5.41% 5.68% 3.62% <-Median-> 10 Paid Median Price CDN$
H/LYield held 20 yrs 15.76% 9.38% 7.27% 5.80% 8.50% 8.38% 6.42% 5.55% 8.50% <-Median-> 5 Paid Median Price CDN$
H/LYield held 25 yrs 43.31% 23.04% 14.73% #NUM! <-Median-> 0 Paid Median Price CDN$
Cost covered if held 5 years 12.59% 14.39% 11.02% 8.22% 8.40% 6.18% 6.42% 6.73% 7.54% 14.23% 27.58% 18.48% 19.42% 25.48% 17.17% 8.31% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 24.63% 28.61% 25.44% 19.97% 17.98% 20.96% 22.70% 17.90% 15.05% 16.74% 16.80% 23.51% 28.02% 31.20% 57.46% 18.97% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 151.03% 84.62% 57.33% 35.73% 38.95% 34.35% 28.07% 26.13% 35.35% 44.80% 39.67% 36.48% 42.11% 37.34% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 20 years 197.10% 113.67% 78.98% 54.82% 66.46% 62.56% 53.50% 50.92% 78.98% <-Median-> 5 Paid Median Price CDN$
Cost covered if held 25 years 342.92% 204.89% 144.77% #NUM! <-Median-> 0 Paid Median Price CDN$
Graham No. $28.27 $26.03 $24.38 $24.48 $9.25 $8.54 $27.81 $29.26 $37.03 $43.26 $52.69 $68.50 $74.06 $77.25 $82.26 163.18% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 0.92 0.83 0.88 0.93 1.51 1.18 0.72 0.80 0.57 0.81 1.00 0.94 0.71 0.90 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.02 0.94 0.96 1.03 2.19 1.59 0.94 1.05 0.67 1.04 1.19 1.08 0.84 1.04 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.83 0.73 0.80 0.82 0.83 0.76 0.50 0.56 0.47 0.59 0.81 0.80 0.59 0.78 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 0.87 0.81 0.95 0.82 0.99 1.56 0.93 0.58 0.67 1.01 1.19 0.82 0.80 0.76 0.72 0.94 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close -12.84% -19.32% -4.66% -18.10% -0.64% 55.84% -6.67% -41.90% -32.92% 0.66% 19.47% -18.08% -20.21% -23.51% -28.16% -5.66% <-Median-> 10 Graham Price CDN$
Price CDN Close $ $24.64 $21.00 $23.25 $20.05 $9.19 $13.32 $25.96 $17.00 $24.84 $43.55 $62.95 $56.12 $59.09 $59.09 $59.09 167.24% <-Total Growth 10 Stock Price CDN$
Increase -5.26% -14.78% 10.70% -13.78% -54.17% 44.93% 94.93% -34.50% 46.12% 75.32% 44.55% -10.85% 5.29% 0.00% 0.00% 10.33% <-IRR #YR-> 10 Stock Price CDN$
P/E 11.49 12.21 16.69 13.85 48.40 -11.54 12.49 7.96 8.20 12.11 12.49 8.30 8.36 7.69 6.78 16.68% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 14.64 9.79 13.52 14.39 6.35 70.15 -22.49 8.18 11.63 14.38 17.51 11.13 8.74 8.36 7.69 11.75% <-IRR #YR-> 10 Price & Div CDN$
Median 10, 5 Yrs D. per yr 1.43% 2.00% % Tot Ret 12.12% 10.71% Price Inc 44.55% P/E: 12.30 8.30 18.68% <-IRR #YR-> 5 Price & Div CDN$
-$21.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $56.12
-$25.96 $0.00 $0.00 $0.00 $0.00 $56.12
-$21.00 $0.44 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $57.26
-$25.96 $0.49 $0.55 $0.67 $0.84 $57.26
Median H/L CDN$ $26.11 $21.64 $21.40 $22.64 $13.98 $10.05 $20.00 $23.46 $21.04 $35.21 $52.82 $64.41 $52.83 197.71% <-Total Growth 10 Stock Price CDN$
Increase 9.57% -17.15% -1.08% 5.81% -38.25% -28.10% 98.91% 17.33% -10.35% 67.36% 50.04% 21.94% -17.98% 11.53% <-IRR #YR-> 10 Stock Price CDN$
P/E 12.17 12.58 15.37 15.64 73.66 -8.71 9.62 10.99 6.94 9.79 10.48 9.53 7.48 26.36% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 15.51 10.08 12.44 16.26 9.66 52.97 -17.33 11.29 9.85 11.62 14.69 12.78 7.82 12.84% <-IRR #YR-> 10 Price & Div CDN$
P/E on Run. 5 yr Ave 11.86 10.49 11.58 13.50 10.14 13.98 25.28 24.97 16.75 18.18 16.63 15.67 10.36 28.57% <-IRR #YR-> 5 Price & Div CDN$
P/E on Run. 10 yr Ave 15.87 12.47 11.90 12.46 8.02 6.88 14.01 16.83 14.34 21.23 27.12 26.28 17.50 12.58 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.32% 2.21% % Tot Ret 10.24% 8% Price Inc 21.94% P/E: 10.14 9.79 Count 25 Years of data
-$21.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $64.41
-$20.00 $0.00 $0.00 $0.00 $0.00 $64.41
-$21.64 $0.44 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $65.55
-$20.00 $0.49 $0.55 $0.67 $0.84 $65.55
Month Jun Jan Dec- May Jul Jan Jul Dec Jan Dec Nov Nov Jun Dec
Price High CDN$ $28.74 $24.39 $23.33 $25.24 $20.27 $13.63 $26.10 $30.60 $24.84 $45.10 $62.92 $73.87 $61.84 202.93% <-Total Growth 10 Stock Price CDN$
Increase -0.43% -15.15% -4.34% 8.21% -19.71% -32.77% 91.56% 17.22% -18.81% 81.54% 39.53% 17.40% -16.29% 11.72% <-IRR #YR-> 10 Stock Price CDN$
P/E 13.39 14.18 16.75 17.44 106.78 -11.81 12.56 14.33 8.20 12.54 12.48 10.93 8.75 23.13% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 17.07 11.37 13.56 18.13 14.00 71.78 -22.62 14.72 11.63 14.89 17.50 14.65 9.15 14.04 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 17.40% P/E: 12.55 12.48 27.68 P/E Ratio Historical High
-$24.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $73.87
-$26.10 $0.00 $0.00 $0.00 $0.00 $73.87
Month Oct Apr Aug Dec Nov Mar Jan Sep Jan Jan Jan Jan Jul
Pre-Split 2010 $93.95 $75.54 $77.90 $80.18 $30.79 $25.93
Pre-Split 2015 $46.98 $37.77 $38.95 $40.09 $15.40 $12.97 $27.79 $32.66 $34.46 $50.63
Price Low CDN$ $23.49 $18.89 $19.48 $20.05 $7.70 $6.48 $13.90 $16.33 $17.23 $25.32 $42.73 $54.95 $43.82 190.97% <-Total Growth 10 Stock Price CDN$
Increase 24.93% -19.60% 3.12% 2.93% -61.60% -15.78% 114.35% 17.52% 5.51% 46.92% 68.77% 28.61% -20.25% 11.27% <-IRR #YR-> 10 Stock Price CDN$
P/E 10.95 10.98 13.99 13.85 40.55 -5.62 6.68 7.65 5.69 7.04 8.48 8.13 6.20 31.65% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 13.95 8.80 11.32 14.39 5.32 34.15 -12.04 7.86 8.07 8.36 11.88 10.90 6.48 8.94 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 28.61% P/E: 7.89 7.65 6.76 P/E Ratio Historical Low
-$18.89 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $54.95
-$13.90 $0.00 $0.00 $0.00 $0.00 $54.95
Pre-Split 2010 $82.55 $71.98 $80.55 $80.43 $29.93 $50.58
Pre-Split 2015 $41.28 $35.99 $40.28 $40.22 $14.97 $25.29 $52.00 $33.31 $50.02 $82.06
Price Close US$ $20.64 $18.00 $20.14 $20.11 $7.48 $12.65 $26.00 $16.66 $25.01 $41.03 $54.35 $40.56 $43.58 $43.58 $43.58 125.40% <-Total Growth 10 Stock Price US$
Increase 3.12% -12.80% 11.91% -0.15% -62.79% 68.99% 105.61% -35.94% 50.17% 64.05% 32.46% -25.37% 7.45% 0.00% 0.00% 8.47% <-IRR #YR-> 10 Stock Price US$
P/E 11.58 12.20 16.85 13.73 48.27 -11.47 12.44 7.93 8.21 12.14 12.51 8.31 8.35 7.67 6.77 9.30% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 15.84 10.10 13.65 16.83 5.11 81.58 -23.58 7.97 11.91 13.47 16.08 9.33 8.93 8.35 7.67 10.10% <-IRR #YR-> 10 Price & Div US$
Median 10, 5 Yrs D. per yr 1.63% 2.10% % Tot Ret 16.14% 18.43% Price Inc 32.46% P/E: 12.29 8.31 11.40% <-IRR #YR-> 5 Price & Div US$
-$18.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.56
-$26.00 $0.00 $0.00 $0.00 $0.00 $40.56
-$18.00 $0.38 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $41.44
-$26.00 $0.50 $0.55 $0.64 $0.76 $41.44
US Median H/L US$ $21.49 $17.45 $19.12 $21.05 $13.12 $8.87 $19.70 $23.21 $21.01 $34.39 $48.58 $49.65 $39.12 0.00% 184.55% <-Total Growth 10 Stock Price US$
Increase 35.90% -18.81% 9.60% 10.07% -37.67% -32.40% 122.07% 17.83% -9.47% 63.66% 41.28% 2.21% -21.22% 2.29% 11.02% <-IRR #YR-> 10 Stock Price US$
P/E 12.06 11.83 16.00 14.37 84.65 -8.04 9.42 11.05 6.90 10.17 11.18 10.17 7.49 2.29% 20.31% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 16.50 9.79 12.97 17.62 8.96 57.22 -17.86 11.10 10.00 11.29 14.37 11.43 8.02 12.53% <-IRR #YR-> 10 Price & Div US$
P/E on Run. 5 yr Ave 13.96 11.53 13.26 14.58 10.80 13.91 25.90 24.65 16.71 18.07 16.24 13.99 9.37 22.61% <-IRR #YR-> 5 Price & Div US$
P/E on Run. 10 yr Ave 18.68 14.10 14.70 15.47 9.98 8.15 17.33 19.47 15.55 22.06 26.77 23.04 15.29 12.06 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.51% 2.29% % Tot Ret 12.02% 10.15% Price Inc 17.83% P/E: 10.61 10.17 Count 25 Years of data
-$17.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $49.65
-$19.70 $0.00 $0.00 $0.00 $0.00 $49.65
-$17.45 $0.38 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $50.53
-$19.70 $0.50 $0.55 $0.64 $0.76 $50.53
Month Jan Dec Oct Aug Jun Dec
Pre-Split 2010 $85.17 $79.05 $82.83 $96.89 $81.46 $50.96
Pre-Split 2015 $42.59 $39.53 $41.42 $48.45 $40.73 $25.48 $52.14 $61.49 $50.02 $86.25
Price High US$ $21.29 $19.76 $20.71 $24.22 $20.37 $12.74 $26.07 $30.75 $25.01 $43.13 $57.03 $58.74 $46.78 197.23% <-Total Growth 10 Stock Price US$
Increase 4.38% -7.19% 4.78% 16.97% -15.93% -37.44% 104.63% 17.93% -18.65% 72.43% 32.24% 3.00% -20.36% 11.51% <-IRR #YR-> 10 Stock Price US$
P/E 11.95 13.40 17.33 16.53 131.39 -11.56 12.47 14.64 8.21 12.76 13.13 12.04 8.96 17.64% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 16.35 11.09 14.04 20.27 13.90 82.19 -23.65 14.71 11.91 14.16 16.87 13.52 9.59 13.40 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 14.16 P/E: 12.94 12.76 25.74 P/E Ratio Historical High
Month Sep Jan Jan Jan Dec Feb
Price Low US$ $21.69 $15.14 $17.54 $17.88 $5.88 $5.00 $13.32 $15.67 $17.01 $25.65 $40.13 $40.56 $31.45 167.99% <-Total Growth 10 Stock Price US$
Increase 93.19% -30.23% 15.89% 1.92% -67.14% -14.94% 166.53% 17.64% 8.55% 50.76% 56.46% 1.08% -22.46% 10.36% <-IRR #YR-> 10 Stock Price US$
P/E 12.17 10.26 14.68 12.20 37.90 -4.53 6.37 7.46 5.59 7.59 9.23 8.31 6.02 24.94% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 16.65 8.49 11.89 14.96 4.01 32.24 -12.08 7.50 8.10 8.42 11.87 9.33 6.44 8.62 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 8.42 P/E: 7.95 7.59 6.94 P/E Ratio Historical Low
-$15.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.56
-$13.32 $0.00 $0.00 $0.00 $0.00 $40.56
Debt US$ $1,023 $2,529 $2,651 Debt US$
Debt CDN$ $1,187 $3,502 $3,588 Debt CDN$
Ratio to Market Cap 0.05 0.16 0.16 0.10 <-Median-> 2 % of Market Cap CDN$
Goodwill and Intangibles $1,194 $1,196 $1,473 $1,440 $1,350 $1,344 $1,865 Intangibles Goodwill US$
Goodwill and Intangibles $1,188 $1,216 $1,465 $1,532 $1,566 $1,861 $2,524 Intangibles Goodwill CDN$
Ratio to Market Cap 0.09 0.15 0.13 0.08 0.06 0.08 0.11 0.09 <-Median-> 6 % of Market Cap CDN$
Market Cap US$ $8,003 $7,866 $8,851 $9,336 $3,370 $5,698 $12,613 $7,772 $11,662 $18,148 $22,301 $16,316 $16,753 $16,753 $16,753 107.43% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $9,556 $9,179 $10,218 $9,307 $4,138 $6,000 $12,592 $7,933 $11,583 $19,262 $25,830 $22,575 $22,715 $22,715 $22,715 145.93% <-Total Growth 10 Market Cap CDN$
Pre-Split 2015 242.8 235.2 230.8 216.6
Diluted # of Shares in Million 485.6 470.4 461.6 433.2 412.7 395.9 -15.01% <-Total Growth 4 Average
Change -3.13% -1.87% -6.15% -4.73% -4.07% -3.93% <-Median-> 4 Change
Pre-Split 2015 193.4 213.4 217.2 222.8 225.6 223.6 230.0 239.3 232.4 227.9 213.6
Average # of Shares in Millions 386.8 426.8 434.4 445.6 451.2 447.2 460.0 478.6 464.8 455.8 427.2 407.5 393.7 -4.52% <-Total Growth 10 Average
Change 0.83% 10.34% 1.78% 2.58% 1.26% -0.89% 2.86% 4.04% -2.88% -1.94% -6.27% -4.61% -3.39% 0.19% <-Median-> 10 Change
Difference 0.3% 2.4% 1.2% 4.2% -0.2% 0.8% 5.5% -2.5% 0.3% -3.0% -4.0% -1.3% -2.4% 0.08% <-Median-> 10 Difference
$3,028 <-12 mths 13.15%
Pre-Split 2010 96.944 109.278 109.880 116.071 112.606 112.660
Pre-Split 2015 193.889 218.557 219.761 232.142 225.212 225.320 242.565 233.318 233.156 221.152 205.163
# of Share in Millions 387.777 437.114 439.521 464.284 450.424 450.639 485.129 466.636 466.312 442.303 410.325 402.264 384.409 384.409 384.409 -0.83% <-IRR #YR-> 10 Shares
Change 0.56% 12.72% 0.55% 5.63% -2.99% 0.05% 7.65% -3.81% -0.07% -5.15% -7.23% -1.96% -4.44% 0.00% 0.00% -3.68% <-IRR #YR-> 5 Shares
CF fr Op $M US$ $1,381 $1,698 $1,596 $1,593 $1,054 $527 $1,872 $1,210 $2,134 $2,567 $2,792 $2,332 $3,310 $3,602 $3,452 37.34% <-Total Growth 10 Cash Flow US$
Increase 13.57% 22.95% -6.01% -0.19% -33.84% -50.00% 255.22% -35.36% 76.36% 20.29% 8.77% -16.48% 41.93% 8.83% -4.16% SO, DRIP Buy Backs Collapsed Dual Cl. S. Issue
5 year Running Average $1,148 $1,357 $1,470 $1,497 $1,464 $1,294 $1,328 $1,251 $1,359 $1,662 $2,115 $2,207 $2,627 $2,921 $3,098 62.66% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $3.56 $3.88 $3.63 $3.43 $2.34 $1.17 $3.86 $2.59 $4.58 $5.80 $6.80 $5.80 $8.61 $9.37 $8.98 49.24% <-Total Growth 10 Cash Flow per Share US$
Increase 12.94% 9.08% -6.52% -5.51% -31.80% -50.02% 229.96% -32.80% 76.49% 26.82% 17.24% -14.80% 48.52% 8.83% -4.16% 3.22% <-IRR #YR-> 10 Cash Flow US$
5 year Running Average $3.14 $3.50 $3.61 $3.53 $3.37 $2.89 $2.89 $2.68 $2.91 $3.60 $4.73 $5.11 $6.32 $7.28 $7.91 4.49% <-IRR #YR-> 5 Cash Flow US$
P/CF on Med Price 6.03 4.49 5.27 6.14 5.61 7.58 5.10 8.95 4.59 5.92 7.14 8.56 4.08% <-IRR #YR-> 10 Cash Flow per Share US$
P/CF on Closing Price 5.79 4.63 5.55 5.86 3.20 10.81 6.74 6.42 5.47 7.07 7.99 7.00 5.06 4.65 4.85 8.48% <-IRR #YR-> 5 Cash Flow per Share US$
-16.06% Diff M/C 3.86% <-IRR #YR-> 10 CFPS 5 yr Running US$
Excl.Working Capital CF $100.0 -$158.0 -$157.0 $94.0 $275.0 $94.0 -$177.0 $631.0 -$72.0 $127.0 $245.0 $344.0 $0 $0 $0 12.13% <-IRR #YR-> 5 CFPS 5 yr Running US$
CF fr Op $M WC US$ $1,481 $1,540 $1,439 $1,687 $1,329 $621 $1,695 $1,841 $2,062 $2,694 $3,037 $2,676 $3,310 $3,602 $3,452 73.77% <-Total Growth 10 Cash Flow less WC US$
Increase 14.98% 3.98% -6.56% 17.23% -21.22% -53.27% 172.95% 8.61% 12.00% 30.65% 12.73% -11.89% 23.68% 8.83% -4.16% 6.56% <-IRR #YR-> 10 Cash Flow less WC US$
5 year Running Average $1,302 $1,411 $1,491 $1,487 $1,495 $1,323 $1,354 $1,435 $1,510 $1,783 $2,266 $2,462 $2,756 $3,064 $3,215 13.75% <-IRR #YR-> 5 Cash Flow less WC US$
CFPS Excl. WC US$ $3.82 $3.52 $3.27 $3.63 $2.95 $1.38 $3.49 $3.95 $4.42 $6.09 $7.40 $6.65 $8.61 $9.37 $8.98 5.72% <-IRR #YR-> 10 CF less WC 5 Yr Run US$
Increase 14.35% -7.75% -7.07% 10.98% -18.80% -53.30% 153.54% 12.92% 12.08% 37.74% 21.52% -10.12% 29.43% 8.83% -4.16% 12.70% <-IRR #YR-> 5 CF less WC 5 Yr Run US$
5 year Running Average $3.58 $3.65 $3.69 $3.52 $3.44 $2.95 $2.95 $3.08 $3.24 $3.87 $5.07 $5.70 $6.64 $7.62 $8.20 6.56% <-IRR #YR-> 10 CF - Less WC US$
P/CF on Med Price 5.63 4.95 5.84 5.79 4.45 6.44 5.64 5.88 4.75 5.65 6.56 7.46 13.75% <-IRR #YR-> 5 CF - Less WC US$
P/CF on Closing Price 5.40 5.11 6.15 5.53 2.54 9.18 7.44 4.22 5.66 6.74 7.34 6.10 5.06 4.65 4.85 4.55% <-IRR #YR-> 10 CFPS 5 yr Running US$
CF/-WC P/CF Med 10 yr 6.03 5 yr 7.14 P/CF Med 10 yr 5.82 5 yr 5.88 -12.99% Diff M/C 14.12% <-IRR #YR-> 5 CFPS 5 yr Running US$
$4,098 <-12 mths <-12 mths
CF fr Op $M CDN$ $1,662 $1,980 $1,860 $1,574 $1,291 $552 $1,862 $1,231 $2,123 $2,730 $3,239 $3,229 $4,480 $4,875 $4,672 63.12% <-Total Growth 10 Cash Flow CDN$
Increase 5.77% 19.10% -6.06% -15.37% -18.00% -57.27% 237.57% -33.91% 72.53% 28.60% 18.63% -0.30% 38.73% 8.83% -4.16% SO, DRIP Buy Backs Collapsed Dual Cl. S. Issue
5 year Running Average $1,632 $1,832 $1,876 $1,729 $1,673 $1,451 $1,428 $1,302 $1,412 $1,699 $2,237 $2,510 $3,160 $3,711 $4,099 37.06% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $4.29 $4.53 $4.23 $3.39 $2.87 $1.22 $3.84 $2.64 $4.55 $6.17 $7.89 $8.03 $11.65 $12.68 $12.15 77.25% <-Total Growth 10 Cash Flow per Share CDN$
Increase 5.19% 5.66% -6.57% -19.88% -15.48% -57.29% 213.57% -31.29% 72.65% 35.58% 27.88% 1.70% 45.17% 8.83% -4.16% 5.01% <-IRR #YR-> 10 Cash Flow CDN$
5 year Running Average $4.49 $4.77 $4.63 $4.10 $3.86 $3.25 $3.11 $2.79 $3.02 $3.68 $5.02 $5.86 $7.66 $9.29 $10.48 11.64% <-IRR #YR-> 5 Cash Flow CDN$
P/CF on Med Price 6.09 4.78 5.06 6.68 4.88 8.21 5.21 8.90 4.62 5.70 6.69 8.02 5.89% <-IRR #YR-> 10 Cash Flow per Share CDN$
P/CF on Closing Price 5.75 4.64 5.49 5.91 3.21 10.88 6.76 6.45 5.46 7.06 7.97 6.99 5.07 4.66 4.86 15.90% <-IRR #YR-> 5 Cash Flow per Share CDN$
-18.10% Diff M/C 2.08% <-IRR #YR-> 10 CFPS 5 yr Running CDN$
Excl.Working Capital CF $120.4 -$184.2 -$183.0 $92.9 $336.8 $98.4 -$176.0 $641.7 -$71.6 $135.1 $284.2 $476.4 $0.0 $0.0 $0.0 13.50% <-IRR #YR-> 5 CFPS 5 yr Running CDN$
CF fr Op $M WC CDN$ $1,783 $1,795 $1,677 $1,667 $1,627 $650 $1,686 $1,872 $2,051 $2,865 $3,523 $3,706 $4,480 $4,875 $4,672 106.38% <-Total Growth 10 Cash Flow less WC CDN$
Increase 7.09% 0.73% -6.61% -0.59% -2.37% -60.07% 159.39% 11.06% 9.57% 39.67% 22.96% 5.18% 20.89% 8.83% -4.16% 7.51% <-IRR #YR-> 10 Cash Flow less WC CDN$
5 year Running Average $1,858 $1,919 $1,924 $1,717 $1,710 $1,483 $1,461 $1,501 $1,577 $1,825 $2,400 $2,804 $3,325 $3,890 $4,251 17.06% <-IRR #YR-> 5 Cash Flow less WC CDN$
CFPS Excl. WC CDN$ $4.60 $4.11 $3.82 $3.59 $3.61 $1.44 $3.48 $4.01 $4.40 $6.48 $8.59 $9.21 $11.65 $12.68 $12.15 3.86% <-IRR #YR-> 10 CF less WC 5 Yr Run CDN$
Increase 6.50% -10.64% -7.12% -5.89% 0.64% -60.08% 140.94% 15.46% 9.65% 47.25% 32.54% 7.28% 26.51% 8.83% -4.16% 13.92% <-IRR #YR-> 5 CF less WC 5 Yr Run CDN$
5 year Running Average $5.13 $5.01 $4.78 $4.09 $3.94 $3.31 $3.19 $3.23 $3.39 $3.96 $5.39 $6.54 $8.07 $9.72 $10.86 8.41% <-IRR #YR-> 10 CFPS - Less WC CDN$
P/CF on Med Price 5.68 5.27 5.61 6.31 3.87 6.97 5.75 5.85 4.78 5.43 6.15 6.99 21.53% <-IRR #YR-> 5 CFPS - Less WC CDN$
P/CF on Closing Price 5.36 5.11 6.09 5.58 2.54 9.23 7.47 4.24 5.65 6.72 7.33 6.09 5.07 4.66 4.86 2.70% <-IRR #YR-> 10 CFPS 5 yr Running CDN$
*Operational Cash Flow per share (Class A & B) CF/-WC P/CF Med 10 yr 6.19 5 yr 6.69 P/CF Med 10 yr 5.80 5 yr 5.85 -12.59% Diff M/C 15.45% <-IRR #YR-> 5 CFPS 5 yr Running CDN$
OPM 6.7% 7.4% 6.6% 6.1% 4.4% 3.0% 7.8% 4.2% 6.9% 7.4% 7.6% 7.3% -2.51% <-Total Growth 10 OPM CDN$
Increase -15.62% 11.32% -11.33% -7.41% -27.24% -31.76% 155.96% -45.81% 64.42% 6.48% 3.40% -4.76% should be zero, it is a check on calculations CDN$
Diff from Ave -1.1% 10.1% -2.4% -9.6% -34.2% -55.1% 14.9% -37.7% 2.4% 9.0% 12.7% 7.3% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 6.76% 5 Yrs 7.26% Should increase or be stable. CDN$
Current Assets US$ $6,281 $6,603 $7,076 $8,770 $7,351 $6,303 $7,814 $8,146 $9,135 $9,923 $10,007 $11,144 $10,580 Liquidity ratio of 1.5 and up, best US$
Current Liabilities $4,092 $4,388 $4,783 $5,658 $5,093 $4,299 $5,200 $5,724 $6,684 $7,309 $7,611 $7,276 $8,969 1.45 <-Median-> 10 Ratio US$
Liquidity 1.53 1.50 1.48 1.55 1.44 1.47 1.50 1.42 1.37 1.36 1.31 1.53 1.18 1.37 <-Median-> 5 Ratio US$
Current Assets CDN$ $7,560 $7,698 $8,246 $8,666 $9,002 $6,597 $7,772 $8,284 $9,088 $10,554 $11,609 $15,432 $14,320 Liquidity ratio of 1.5 and up, best CDN$
Current Liabilities $4,925 $5,116 $5,574 $5,591 $6,237 $4,499 $5,172 $5,821 $6,650 $7,774 $8,830 $10,075 $12,140 1.45 <-Median-> 10 Ratio CDN$
Liquidity 1.53 1.50 1.48 1.55 1.44 1.47 1.50 1.42 1.37 1.36 1.31 1.53 1.18 1.37 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 1.84 1.85 1.78 1.81 1.62 1.58 1.84 1.60 1.65 1.67 1.64 1.81 1.51 1.65 <-Median-> 5 Ratio CDN$
Liq. CF re Inv+Div 1.40 1.50 1.44 1.57 1.34 1.31 1.61 1.31 1.30 1.43 1.35 1.53 1.51 1.35 <-Median-> 5 Ratio CDN$
Assets US$ $11,615 $12,321 $13,154 $15,343 $13,189 $12,303 $13,898 $14,679 $17,109 $17,990 $18,139 $19,706 $22,948 Debt Ratio of 1.5 and up, best US$
Liabilities $6,280 $5,756 $5,997 $6,701 $5,826 $4,943 $5,759 $6,477 $7,651 $8,351 $9,466 $10,589 $12,676 2.25 <-Median-> 10 Ratio US$
Debt Ratio 1.85 2.14 2.19 2.29 2.26 2.49 2.41 2.27 2.24 2.15 1.92 1.86 1.81 2.15 <-Median-> 5 Ratio US$
Assets CDN$ $13,980 $14,365 $15,328 $15,160 $16,151 $12,876 $13,823 $14,929 $17,022 $19,134 $21,043 $27,288 $31,060 Debt Ratio of 1.5 and up, best CDN$
Liabilities $7,559 $6,711 $6,988 $6,621 $7,135 $5,173 $5,728 $6,587 $7,612 $8,882 $10,982 $14,663 $17,157 2.25 <-Median-> 10 Ratio CDN$
Debt Ratio 1.85 2.14 2.19 2.29 2.26 2.49 2.41 2.27 2.24 2.15 1.92 1.86 1.81 2.15 <-Median-> 5 Ratio CDN$
Total Book Value US$ $5,335 $6,565 $7,157 $8,642 $7,363 $7,360 $8,139 $8,202 $9,458 $9,639 $8,673 $9,117 $10,272
NCI US$ $74 $27 $29 $16 $14 $151 $474
Book Value US $5,335 $6,565 $7,157 $8,642 $7,363 $7,360 $8,065 $8,175 $9,429 $9,623 $8,659 $8,966 $9,798 $9,798 $9,798 36.57% <-Total Growth 10 Book Value US$
Book Value per Share $13.76 $15.02 $16.28 $18.61 $16.35 $16.33 $16.62 $17.52 $20.22 $21.76 $21.10 $22.29 $25.49 $25.49 $25.49 48.40% <-Total Growth 10 Book Value US$
Change 7.62% 9.17% 8.42% 14.31% -12.18% -0.09% 1.79% 5.38% 15.42% 7.60% -3.01% 5.62% 14.36% 0.00% 0.00% 44.95% Current/Historical Book Value US$
P/B Ratio (Median) 1.56 1.16 1.17 1.13 0.80 0.54 1.18 1.32 1.04 1.58 2.30 2.23 1.53 0.00 0.00 1.16 P/BV Ratio Historical Median US$
P/B Ratio (Close) 1.50 1.20 1.24 1.08 0.46 0.77 1.56 0.95 1.24 1.89 2.58 1.82 1.71 1.71 1.71 4.03% <-IRR #YR-> 10 Book Value US$
Change -4.17% -20.13% 3.22% -12.65% -57.63% 69.14% 102.00% -39.21% 30.10% 52.47% 36.57% -29.34% -6.04% 0.00% 0.00% 6.04% <-IRR #YR-> 5 Book Value US$
Leverage (A/BK) 2.18 1.88 1.84 1.78 1.79 1.67 1.72 1.80 1.81 1.87 2.09 2.20 2.34 1.81 <-Median-> 10 A/BV US$
Debt/Equity Ratio 1.18 0.88 0.84 0.78 0.79 0.67 0.71 0.79 0.81 0.87 1.09 1.18 1.29 0.80 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.18 5 yr Med 1.58 44.95% Diff M/C
-$15.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.29
-$16.62 $0.00 $0.00 $0.00 $0.00 $22.29
CDN$ Check $6,421 $7,654 $8,340 $8,539 $9,017 $7,703 $8,095 $8,341 $9,410 $10,252 $10,062 $12,625 $13,903
Total Book Value CDN$ $6,421 $7,654 $8,340 $8,539 $9,017 $7,703 $8,095 $8,341 $9,410 $10,252 $10,062 $12,625 $13,903 64.94% <-Total Growth 10 Book Value CDN$
NCI CDN$ $74 $27 $29 $17 $16 $209 $642
Book Value CDN $6,421 $7,654 $8,340 $8,539 $9,017 $7,703 $8,021 $8,314 $9,381 $10,235 $10,045 $12,416 $13,262 $13,262 $13,262 62.21% <-Total Growth 10 Book Value CDN$
Book Value per Share $16.56 $17.51 $18.98 $18.39 $20.02 $17.09 $16.53 $17.82 $20.12 $23.14 $24.48 $30.86 $34.50 $34.50 $34.50 76.26% <-Total Growth 10 Book Value CDN$
Change 0.23% 5.75% 8.36% -3.07% 8.84% -14.61% -3.27% 7.75% 12.91% 15.03% 5.80% 26.07% 11.78% 0.00% 0.00% 40.36% Current/Historical Book Value CDN$
P/B Ratio (Median) 1.58 1.24 1.13 1.23 0.70 0.59 1.21 1.32 1.05 1.52 2.16 2.09 1.53 1.24 P/BV Ratio Historical Median CDN$
P/B Ratio (Close) 1.49 1.20 1.23 1.09 0.46 0.78 1.57 0.95 1.23 1.88 2.57 1.82 1.71 1.71 1.71 5.83% <-IRR #YR-> 10 Book Value CDN$
Change -5.47% -19.41% 2.16% -11.04% -57.89% 69.72% 101.52% -39.22% 29.41% 52.42% 36.63% -29.29% -5.80% 0.00% 0.00% 13.30% <-IRR #YR-> 5 Book Value CDN$
Leverage (A/BK) 2.18 1.88 1.84 1.78 1.79 1.67 1.72 1.80 1.81 1.87 2.09 2.20 2.34 1.81 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.18 0.88 0.84 0.78 0.79 0.67 0.71 0.79 0.81 0.87 1.09 1.18 1.29 0.80 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.22 5 yr Med 1.52 40.36% Diff M/C
$2,194 <-12 mths 101.28%
Comprehensive Inc US$ $726 $1,506 $1,403 $1,037 $1,082
NCI -$3 -$5 -$17 -$2 -$8
Shareholders $488 $721 $1,202 -$945 $14 $1,052 $729 $1,511 $1,420 $1,039 $1,090 123.36% <-Total Growth 10 Comprehensive Income US$
Increase 47.75% 66.71% -178.62% 101.48% 7414.29% -30.70% 107.27% -6.02% -26.83% 4.91% -6.02% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $296 $409 $410 $472 $945 $1,150 $1,158 8.37% <-IRR #YR-> 10 Comprehensive Income US$ 123.36%
ROE US$ 7.4% 10.1% 13.9% -12.8% 0.2% 12.9% 8.9% 16.0% 14.7% 12.0% 12.0% 0.71% <-IRR #YR-> 5 Comprehensive Income US$ 3.61%
5Yr Median 7.4% 10.1% 8.9% 8.9% 12.9% 12.9% 12.0% 25.52% <-IRR #YR-> 6 5 Yr Running Average US$ #DIV/0!
% Difference from NI -23.6% 36.6% 81.3% -1431.0% -102.8% 7.1% -28.6% 5.1% -9.2% -44.9% -46.7% 23.15% <-IRR #YR-> 5 5 Yr Running Average US$ 183.22%
Median Values Diff 5, 10 yr -18.9% -28.6% 12.0% <-Median-> 5 Return on Equity US$
Current Liability Coverage Ratio US$ 0.36 0.35 0.30 0.30 0.26 0.14 0.33 0.32 0.31 0.37 0.40 0.37 CFO / Current Liabilities US$
5 year Median 0.46 0.37 0.36 0.35 0.30 0.30 0.30 0.30 0.31 0.32 0.33 0.37 0.37 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 12.75% 12.50% 10.94% 11.00% 10.08% 5.05% 12.20% 12.54% 12.05% 14.97% 16.74% 13.58% CFO / Total Assets US$
5 year Median 13.15% 13.12% 12.75% 12.50% 11.00% 10.94% 10.94% 11.00% 12.05% 12.20% 12.54% 13.58% 13.6% <-Median-> 5 Return on Assets US$
Return on Assets ROA US$ 6.0% 5.2% 4.0% 4.3% 0.5% -4.0% 7.0% 6.9% 8.4% 8.7% 10.4% 10.2% Net Income/Assets Return on Assets US$
5Yr Median 6.0% 5.5% 5.3% 5.2% 4.3% 4.0% 4.0% 4.3% 6.9% 7.0% 8.4% 8.7% 8.7% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ 13.0% 9.7% 7.4% 7.7% 1.0% -6.7% 12.1% 12.5% 15.2% 16.2% 21.8% 22.5% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 12.9% 10.6% 10.2% 9.7% 7.7% 7.4% 7.4% 7.7% 12.1% 12.5% 15.2% 16.2% 16.2% <-Median-> 5 Return on Equity US$
$2,029 <-12 mths 0.79%
Net Income US$ $961 $1,015 $1,426 $1,545 $1,882 $2,007 Net Income US$
NCI -$12 -$3 -$7 -$16 -$2 -$6 NCI US$
Shareholders $692 $639 $528 $663 $71 -$493 $973 $1,018 $1,433 $1,561 $1,884 $2,013 $2,065 $2,175 $2,412 215.02% <-Total Growth 10 Shareholders US$
Increase 32.57% -7.66% -17.37% 25.57% -89.29% -794% 297.36% 4.62% 40.77% 8.93% 20.69% 6.85% 2.58% 5.33% 10.90% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $588.6 $597.2 $587.0 $608.8 $518.6 $281.6 $348.4 $446.4 $600.4 $898.4 $1,373.8 $1,581.8 $1,791.2 $1,939.6 $2,109.8 12.16% <-IRR #YR-> 10 Net Income
Operating Cash Flow $1,381 $1,698 $1,596 $1,593 $1,054 $527 $1,872 $1,210 $2,134 $2,567 $2,792 $2,332 15.65% <-IRR #YR-> 5 Net Income US$
Investment Cash Flow -$1,274 -$1,051 -$1,111 -$868 -$1,063 -$876 -$744 -$1,272 -$1,815 -$1,207 -$1,617 -$1,288 10.23% <-IRR #YR-> 10 5 Yr Running Ave. US$
Total Accruals $585 -$8 $43 -$62 $80 -$144 -$155 $1,080 $1,114 $201 $709 $969 35.34% <-IRR #YR-> 5 5 Yr Running Ave.
Total Assets $11,615 $12,321 $13,154 $15,343 $13,189 $12,303 $13,898 $14,679 $17,109 $17,990 $18,139 $19,706 Balance Sheet Assets US$
Accruals Ratio 5.04% -0.06% 0.33% -0.40% 0.61% -1.17% -1.12% 7.36% 6.51% 1.12% 3.91% 4.92% 4.92% <-Median-> 5 Ratio US$
EPS/CF Ratio (WC) 0.47 0.42 0.36 0.40 0.05 -0.80 0.60 0.53 0.69 0.55 0.59 0.73
Financial Cash Flow US$ -$230 -$426 -$386 $44 $89 -$1,164 -$355 -$457 -$216 -$1,300 -$1,378 $741 C F Statement Financial Cash Flow US$
Total Accruals $815 $418 $429 -$106 -$9 $1,020 $200 $1,537 $1,330 $1,501 $2,087 $228 Accruals US$
Accruals Ratio 7.02% 3.39% 3.26% -0.69% -0.07% 8.29% 1.44% 10.47% 7.77% 8.34% 11.51% 1.16% 8.34% <-Median-> 5 Ratio US$
$2,970 <-12 mths 96.74%
Comprehensive Income CDN$ $738 $1,498 $1,492 $1,203 $1,498
NCI -$3 -$5 -$18 -$2 -$11
Shareholders $569 $840 $1,188 -$1,157 $15 $1,046 $741 $1,503 $1,510 $1,205 $1,509 165.29% <-Total Growth 10 Comprehensive Income CDN$
Increase 47.67% 41.36% -197.44% 101.27% 7040.94% -29.14% 102.77% 0.47% -20.19% 25.22% 0.47% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $291 $386 $367 $430 $963 $1,201 $1,294 10.25% <-IRR #YR-> 10 Comprehensive Income CDN$ 165.29%
ROE CDN$ 7.4% 10.1% 13.9% -12.8% 0.2% 12.9% 8.9% 16.0% 14.7% 12.0% 12.0% 7.60% <-IRR #YR-> 5 Comprehensive Income CDN$ 44.26%
5Yr Median 7.4% 10.1% 8.9% 8.9% 12.9% 12.9% 12.0% 28.25% <-IRR #YR-> 6 5 Yr Running Average CDN$ #DIV/0!
% Difference from NI -23.6% 36.6% 81.3% -1431% -102.8% 7.1% -28.6% 5.1% -9.2% -44.9% -46.7% 27.35% <-IRR #YR-> 5 5 Yr Running Average CDN$ 234.94%
Median Values Diff 5, 10 yr -18.9% -28.6% 12.0% <-Median-> 5 Return on Equity CDN$
Current Liability Coverage Ratio CDN$ 0.36 0.35 0.30 0.30 0.26 0.14 0.33 0.32 0.31 0.37 0.40 0.37 CFO / Current Liabilities CDN$
5 year Median 0.46 0.37 0.36 0.35 0.30 0.30 0.30 0.30 0.31 0.32 0.33 0.37 0.37 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 12.75% 12.50% 10.94% 11.00% 10.08% 5.05% 12.20% 12.54% 12.05% 14.97% 16.74% 13.58% CFO / Total Assets CDN$
5 year Median 13.15% 13.12% 12.75% 12.50% 11.00% 10.94% 10.94% 11.00% 12.05% 12.20% 12.54% 13.58% 13.6% <-Median-> 5 Return on Assets CDN$
Return on Assets ROA CDN$ 6.0% 5.2% 4.0% 4.3% 0.5% -4.0% 7.0% 6.9% 8.4% 8.7% 10.4% 10.2% Net Income/Assets Return on Assets CDN$
5Yr Median 6.0% 5.5% 5.3% 5.2% 4.3% 4.0% 4.0% 4.3% 6.9% 7.0% 8.4% 8.7% 8.7% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 13.0% 9.7% 7.4% 7.7% 1.0% -6.7% 12.1% 12.5% 15.2% 16.2% 21.8% 22.5% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 12.9% 10.6% 10.2% 9.7% 7.7% 7.4% 7.4% 7.7% 12.1% 12.5% 15.2% 16.2% 16.2% <-Median-> 5 Return on Equity CDN$
$2,746 <-12 mths -1.48%
Net Income CDN$ $956 $1,032 $1,419 $1,643 $2,183 $2,779 Net Income CDN$
NCI -$12 -$3 -$7 -$17 -$2 -$8 NCI CDN$
Shareholders $833 $745 $615 $655 $87 -$516 $968 $1,035 $1,426 $1,660 $2,186 $2,787 $2,795 $2,944 $3,265 274.15% <-Total Growth 10 Shareholders CDN$
Increase 23.47% -10.55% -17.41% 6.47% -86.73% -693% 287.56% 6.98% 37.71% 16.45% 31.64% 27.54% 0.27% 5.33% 10.90% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $839.8 $809.9 $748.6 $704.6 $587.0 $317.3 $361.8 $445.8 $599.9 $914.6 $1,454.9 $1,818.9 $2,170.8 $2,474.4 $2,795.3 14.11% <-IRR #YR-> 10 Net Income CDN$
Operating Cash Flow $1,662 $1,980 $1,860 $1,574 $1,291 $552 $1,862 $1,231 $2,123 $2,730 $3,239 $3,229 23.56% <-IRR #YR-> 5 Net Income CDN$
Investment Cash Flow -$1,533 -$1,225 -$1,295 -$858 -$1,302 -$917 -$740 -$1,294 -$1,806 -$1,284 -$1,876 -$1,784 8.43% <-IRR #YR-> 10 5 Yr Running Ave. CDN$
Total Accruals $704 -$9 $50 -$61 $98 -$151 -$154 $1,098 $1,108 $214 $823 $1,342 38.12% <-IRR #YR-> 5 5 Yr Running Ave. CDN$
Total Assets $13,980 $14,365 $15,328 $15,160 $16,151 $12,876 $13,823 $14,929 $17,022 $19,134 $21,043 $27,288 Balance Sheet Assets CDN$
Accruals Ratio 5.04% -0.06% 0.33% -0.40% 0.61% -1.17% -1.12% 7.36% 6.51% 1.12% 3.91% 4.92% 4.92% <-Median-> 5 Ratio CDN$
EPS/CF Ratio (WC) 0.47 0.42 0.36 0.40 0.05 -0.80 0.60 0.53 0.69 0.55 0.59 0.73 0.54 <-Median-> 10 EPS/CF Ratio CDN$
Financial Cash Flow CDN$ -$277 -$497 -$450 $43 $109 -$1,218 -$353 -$465 -$215 -$1,383 -$1,599 $1,026 C F Statement Financial Cash Flow CDN$
Total Accruals $981 $487 $500 -$105 -$11 $1,068 $199 $1,563 $1,323 $1,596 $2,421 $316 Accruals CDN$
Accruals Ratio 7.02% 3.39% 3.26% -0.69% -0.07% 8.29% 1.44% 10.47% 7.77% 8.34% 11.51% 1.16% 8.34% <-Median-> 5 Ratio CDN$
Cash US$ $2,757 $1,334 $2,105 $1,325 $1,522 $1,554 $1,253 $2,863 $364 Cash US$
Cash CDN$ $1,623 $1,387 $1,318 $1,348 $1,318 $1,409 $1,537 $1,835 $1,793 Cash CDN$
Cash per Share CDN$ $3.60 $3.08 $2.72 $2.89 $2.83 $3.19 $3.75 $4.56 $4.67 $3.19 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 39.21% 23.11% 10.47% 16.99% 11.38% 7.32% 5.95% 8.13% 7.90% 8.13% <-Median-> 5 % of Stock Price CDN$
Notes:
December 26, 2016. Last estimates were for 2015, 2016 and 2017 of $32412M, $35572M and $37100M US$ for Revenue, $4.47, $5.27 and $6.17 for EPS US$,
$7.50, $8.53and $9.43 for CFPS US$ and $2536M, $2806M and $3139M for Net Income US$.
December 26, 2015. Last estimates were for 2014, 2015 and 2016 of $36213M, $37480M and $38842M US$ for Revenue, $7.94, $9.37 and $10.80 US$ for EPS,
$12.40, $13.50 and $15.60 US$ for CFPS and $1737M, $1974M and $2178M US$ for Net Income.
December 25, 2014. Last estimates were for 2013, 2014 and 2015 of 34385M, $36172M and $37532M for Revenue US$, $6.38, $7.61 and $8.01 for EPS US$, $9.56, $10.80 and $12.40 for CFPS US$.
December 14, 2013. Last estimates were for 2012 and 2013 of $30462M and $31920M for Revenue US$, $5.19 and $5.28 US$ for EPS.
Dec 8, 2012. Last Estimates were for 2010 and 2011 at $28644M and f$29722M US$ Revenue, $4.44 and $4.60 US$ EPS and $6.55 and $7.20 US$ CF.
Nov 12, 2011. Last I looked I got EPS of $3.94 and $4.02 US$ EPS and $13.88 and $13.73 US$ for Cash Flow.
Nov 11, 2010. I have updated spreadsheet for 2 for 1 split of November 2010.
Nov 9, 2010. Stronach sold their interest in this stock to the company and Canadian symbol has changed from MG.A to just MG. Stronach got 9M shares.
2009. My number of shares do not agree with that on G&M site for 2009, but I have recheck 2009 report and my number of shares is correct. G&M missed out Class B shares in 2009.
AR 2005. Needless to say that this stock has not performed liked I would have wanted. TD rates as Hold and I am doing this for now. Since I have bought this in 02 IRR is 7.02%. At least it is not a loss.
AR 2005. It is not a loss because of the dividend only.
AR 2004. Price has gone even lower in 2005.
AR. 2003. Returns have not been great re last 5 years, but we have just come out of a bear market.
Prior to 1998, yr ended July 31
There used to be 2 classes of shares, Class B Multiple voting shares and Class A subordinate Voting Shares. As of August 31, 2010 there are only common shares.
Sector:
Consumer Discretionary
What should this stock accomplish?
You would buy this stock for diversification reasons. There may be volatility in this stock, especially concerning Earnings and Cash Flow.
You should buy it for both rising dividends and capital gain appreciation. You should expect moderate dividend yield and moderate dividend growth.
Would I buy this company and Why.
I would prefer to see a few more years without Frank to see how this company works out. Dividends have been erratic so would not be my first choice as a dividend paying stock to buy.
Dividends
Dividend is paid in Cycle 3 with payment months of March, June, September and December. Dividends on declared in one month for shareholders of record of that month and payble in the following month.
For example, the dividend delcared on November 5, 2013 for shareholders of record on November 29, 2013 is payable on December 13, 2013.
Misson Statement or closes thing I can find.
What I am looking for is a statement that the company wants to do well by their customers, employees, and community and and thereby earn shareholders a reasonable return.
We aim to be our customers' preferred global supplier partner for the automotive industry, by delivering the best value built on innovative products and
processes and World Class Manufacturing. We strive to be the employer of choice, an ethical and responsible corporate citizen and a superior long-term investment for our shareholders.
Why I bought and sold this stock.
I held this company between September 2002 and September 2006 and earned 5% return per year including dividends.
When I bought this stock in 2002, I felt I was paying a good price for it. There were some rumors that it might be bought out in 2006, so I sold.
Why am I following this stock.
Magna is a stock I have tracked for some time. I have always liked Frank Stronach, the entrepreneur who used to run this company.
Manufacturing firms are fairly risky and it is not the sort of company I usually buy.
How they make their money.
Magna International is the most diversified global automotive supplier. They design, develop and manufacture technologically advanced automotive systems, assemblies, modules and components, and
engineer and assemble complete vehicles, primarily for sale to original equipment manufacturers ("OEMs") of cars and light trucks. Their capabilities include the design, engineering, testing
and manufacture of automotive interior systems; seating systems; closure systems; body and chassis systems; vision systems; electronic systems; exterior systems; powertrain systems; roof systems;
hybrid and electric vehicles/systems; as well as complete vehicle engineering and assembly.
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
Date Dec 17 2012 Dec 14 2013 Dec 25 2014 Dec 26 2015 Dec 26 2016
Walker, Donald James 0.423 0.09% 0.534 0.12% 0.511 0.12% 1.522 0.38% 1.974 0.51%
CEO - Shares - Amount $10.510 $23.235 $32.144 $85.395 $116.662
Options - percentage 1.419 0.30% 1.574 0.36% 1.547 0.38% 2.579 0.64% 1.977 0.51%
Options - amount $35.253 $68.560 $97.379 $144.744 $116.820
Galifi, Vincent Joseph 0.228 0.05% 0.271 0.06% 0.402 0.10% 1.579 0.39% 1.348 0.35%
CFO - Shares - Amount $5.664 $11.800 $25.285 $88.599 $79.653
Options - percentage 2.318 0.50% 1.283 0.29% 0.414 0.10% 0.743 0.18% 0.629 0.16%
Options - amount $57.588 $55.891 $26.087 $41.696 $37.147
Apfalter, Guenther Friedrich 0.024 0.01% 0.024 0.01% 0.107 0.03% 0.066 0.02% 53.674 13.96%
Officer - Shares - Amount $0.586 $1.028 $6.744 $3.695 $3,171.619
Options - percentage 0.118 0.03% 0.099 0.02% 0.116 0.03% 0.523 0.13% 0.336 0.09%
Options - amount $2.938 $4.298 $7.285 $29.347 $19.847
Bonham, Scott Barclay 0.000 0.00% 0.000 0.00% 0.000 0.00% 0.000 0.00%
Director - Shares - Amount $0.000 $0.000 $0.000 $0.000
Options - percentage 0.008 0.00% 0.012 0.00% 0.032 0.01% 0.041 0.01%
Options - amount $0.362 $0.755 $1.798 $2.393
Bowie, Peter Guy 0.003 0.00% 0.004 0.00% 0.014 0.00% 0.014 0.00%
Director - Shares - Amount $0.075 $0.220 $0.786 $0.827
Options - percentage 0.003 0.00% 0.010 0.00% 0.025 0.01% 0.031 0.01%
Options - amount $0.073 $0.641 $1.404 $1.850
Young, William L. 0.001 0.00% 0.004 0.00% 0.004 0.00%
Chairman- Shares - Amount $0.059 $0.209 $0.220
Options - percentage 0.026 0.01% 0.059 0.01% 0.073 0.02%
Options - amount $1.667 $3.334 $4.332
Increase in O/S Shares 1.400 0.32% 0.400 0.09% 2.000 0.45% 1.300 0.32% 2.400 0.60%
due to SO $23.800 $9.936 $87.100 $81.835 $134.688
Book Value $69.000 $19.000 $84.000 $63.000 $57.500
Insider Buying -$0.162 -$0.007 -$0.387
Insider Selling $99.238 $47.178 $74.094
Net Insider Selling $99.076 $47.172 $73.706
% of Market Cap 0.79% 0.21% 0.32%
Directors 9 11 11 10
Women 1 11% 3 27% 3 27% 3 30%
Minorities 0 0% 1 9% 1 9% 1 10%
Institutions/Holdings 230 394 31.60% 404 67.11% 408 60.12%
Total Shares Held 159.167 34.13% 127.116 201.93% 271.391 67.47% 231.097 60.12%
Increase/Decrease -4.746 -3.07% -4.745 -3.60% 8.894 3.39% -5.769 -2.44%
Starting No. of Shares 154.422 Nasdaq 131.861 Nasdaq 262.497 Nasdaq 236.865 Nasdaq
Copyright 2008 Website of SPBrunner. All rights reserved.