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
Magna International Inc. TSX: MG NYSE: MGA www.magna.com 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 Currency
Accounting Rules C GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP US GAAP
Fiscal year
Report Currency
CDN$-US$ 1.1659 1.1653 0.9881 1.2246 1.0466 0.9946 1.0170 0.9949 1.0636 1.1601 1.3847 1.3427 1.2641 1.2641 1.2641 15.22% <-Total Growth 10 CDN$-US$
Split Date 3/26/15
Split 2 2
$37,591 <-12 mths 3.14%
Revenue US$ $22,811 $24,180 $26,067 $23,704 $17,367 $24,102 $28,748 $30,837 $34,835 $36,641 $32,134 $36,445 $38,682 $41,991 $44,671 50.72% <-Total Growth 10 Revenue US$
Increase 10.4% 6.0% 7.8% -9.1% -26.7% 38.8% 19.3% 7.3% 13.0% 5.2% -12.3% 13.4% 6.1% 8.6% 6.4% 4.19% <-IRR #YR-> 10 Revenue 50.72% US$
5 year Running Average $16,457 $19,192 $21,811 $23,483 $22,826 $23,084 $23,998 $24,952 $27,178 $31,033 $32,639 $34,178 $35,747 $37,179 $38,785 4.86% <-IRR #YR-> 5 Revenue 26.77% US$
Revenue per Share $52.19 $55.01 $56.14 $52.63 $38.54 $49.68 $61.61 $66.13 $78.76 $89.30 $79.88 $95.34 $106.34 $115.43 $122.80 5.94% <-IRR #YR-> 10 5 yr Running Average 78.09% US$
Increase -2.02% 5.42% 2.05% -6.27% -26.77% 28.91% 24.00% 7.34% 19.10% 13.38% -10.54% 19.35% 11.53% 8.55% 6.38% 7.33% <-IRR #YR-> 5 5 yr Running Average 42.42% US$
5 year Running Average $42.14 $46.84 $51.28 $53.85 $50.90 $50.40 $51.72 $53.72 $58.94 $69.09 $75.13 $81.88 $89.92 $97.26 $103.96 5.65% <-IRR #YR-> 10 Revenue per Share 73.31% US$
P/S (Price/Sales) Med 0.33 0.35 0.37 0.25 0.23 0.40 0.38 0.32 0.44 0.54 0.62 0.41 9.13% <-IRR #YR-> 5 Revenue per Share 54.76% US$
P/S (Price/Sales) Close 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.54 0.49 0.51 5.75% <-IRR #YR-> 10 5 yr Running Average 74.83% US$
*Revenue in M US$ P/S Med 10 yr 0.39 5 yr 0.44 38.69% Diff M/C 9.62% <-IRR #YR-> 5 5 yr Running Average 58.32% US$
-$24,180 $0 $0 $0 $0 $0 $0 $0 $0 $0 $36,445
-$28,748 $0 $0 $0 $0 $36,445
-$19,192 $0 $0 $0 $0 $0 $0 $0 $0 $0 $34,178
-$23,998 $0 $0 $0 $0 $34,178
-$55.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $95.34
-$61.61 $0.00 $0.00 $0.00 $0.00 $95.34
-$46.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $81.88
-$51.72 $0.00 $0.00 $0.00 $0.00 $81.88
$47,519 <-12 mths -2.89%
Revenue CDN$* $26,595 $28,177 $25,757 $29,028 $18,176 $23,972 $29,237 $30,680 $37,051 $42,507 $44,497 $48,935 $48,898 $53,081 $56,469 73.67% <-Total Growth 10 Revenue CDN$
Increase 7.0% 5.9% -8.6% 12.7% -37.4% 31.9% 22.0% 4.9% 20.8% 14.7% 4.7% 10.0% -0.1% 8.6% 6.4% 5.68% <-IRR #YR-> 10 Revenue 73.67% CDN$
5 year Running Average $21,701 $23,990 $25,043 $26,883 $25,547 $25,022 $25,234 $26,219 $27,823 $32,689 $36,794 $40,734 $44,378 $47,584 $50,376 10.85% <-IRR #YR-> 5 Revenue 67.37% CDN$
Revenue per Share $60.84 $64.11 $55.48 $64.45 $40.33 $49.41 $62.65 $65.79 $83.77 $103.59 $110.62 $128.02 $134.42 $145.92 $155.23 5.44% <-IRR #YR-> 10 5 yr Running Average 69.80% CDN$
Increase -5.09% 5.37% -13.46% 16.17% -37.41% 22.51% 26.80% 5.01% 27.32% 23.67% 6.78% 15.73% 5.00% 8.55% 6.38% 10.05% <-IRR #YR-> 5 5 yr Running Average 61.43% CDN$
5 year Running Average $56.03 $58.81 $59.19 $61.80 $57.04 $54.76 $54.46 $56.53 $60.39 $73.04 $85.28 $98.36 $112.08 $124.51 $134.84 7.16% <-IRR #YR-> 10 Revenue per Share 99.69% CDN$
P/S (Price/Sales) Med 0.36 0.33 0.41 0.22 0.25 0.40 0.37 0.32 0.42 0.51 0.58 0.41 15.36% <-IRR #YR-> 5 Revenue per Share 104.32% CDN$
P/S (Price/Sales) Close 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.54 0.49 0.51 5.28% <-IRR #YR-> 10 5 yr Running Average 67.23% CDN$
*Revenue in M Cdn $ (Total Sales) P/S Med 10 yr 0.41 5 yr 0.42 31.99% Diff M/C 12.55% <-IRR #YR-> 5 5 yr Running Average 80.59% CDN$
-$28,177 $0 $0 $0 $0 $0 $0 $0 $0 $0 $48,935
-$29,237 $0 $0 $0 $0 $48,935
-$23,990 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40,734
-$25,234 $0 $0 $0 $0 $40,734
-$64.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $128.02
-$62.65 $0.00 $0.00 $0.00 $0.00 $128.02
-$58.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $98.36
-$54.46 $0.00 $0.00 $0.00 $0.00 $98.36
$5.61 <-12 mths 8.72%
Pre-Split 2015 $3.00 $2.43 $2.98 $0.32 -$2.21 $4.23 $4.26 $6.17 $6.85 $8.81
EPS Basic US$ $1.50 $1.22 $1.49 $0.16 -$1.11 $2.12 $2.13 $3.09 $3.43 $4.41 $4.94 $5.19 327.16% <-Total Growth 10 EPS Basic US$
Pre-Split 2010 $5.90 $4.78 $5.86 $0.62 -$4.41
Pre-Split 2015 $2.95 $2.39 $2.93 $0.31 -$2.21 $4.18 $4.20 $6.09 $6.76 $8.69
EPS Diluted $1.48 $1.20 $1.47 $0.16 -$1.10 $2.09 $2.10 $3.05 $3.38 $4.35 $4.88 $5.16 $5.88 $6.64 $7.64 331.80% <-Total Growth 10 EPS Diluted US$
Increase -17.3% -19.0% 22.6% -89.4% -811.3% -289.6% 0.5% 45.0% 11.0% 28.6% 12.3% 5.7% 14.0% 12.9% 15.1% 15.75% <-IRR #YR-> 10 Earnings per Share 331.80% US$
Earnings Yield 8.2% 5.9% 7.3% 2.1% -8.7% 8.0% 12.6% 12.2% 8.2% 8.0% 12.0% 11.9% 10.3% 11.6% 12.3% 19.70% <-IRR #YR-> 5 Earnings per Share 145.71% US$
5 year Running Average $1.51 $1.44 $1.44 $1.21 $0.64 $0.76 $0.94 $1.26 $1.90 $2.99 $3.55 $4.16 $4.73 $5.38 $6.04 11.18% <-IRR #YR-> 10 5 yr Running Average 188.63% US$
10 year Running Average $1.24 $1.30 $1.36 $1.32 $1.09 $1.14 $1.19 $1.35 $1.56 $1.81 $2.16 $2.55 $2.99 $3.64 $4.52 34.62% <-IRR #YR-> 5 5 yr Running Average 342.06% US$
* ESP per share, Diluted (Cdn GAAP) E/P 10 Yrs 8.14% 5Yrs 11.89% US$
-$1.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.16
-$2.10 $0.00 $0.00 $0.00 $0.00 $5.16
-$1.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.16
-$0.94 $0.00 $0.00 $0.00 $0.00 $4.16
$7.09 <-12 mths 2.36%
EPS Basic CDN$ $1.75 $1.42 $1.47 $0.20 -$1.16 $2.10 $2.17 $3.07 $3.64 $5.11 $6.84 $6.97 392.19% <-Total Growth 10 EPS Basic CDN$
Pre-Split 2010
Pre-Split 2015
EPS Diluted $1.72 $1.39 $1.45 $0.19 -$1.15 $2.08 $2.14 $3.03 $3.59 $5.04 $6.76 $6.93 $7.43 $8.39 $9.66 397.53% <-Total Growth 10 EPS Diluted CDN$
Increase -19.8% -19.0% 4.0% -86.9% -707.9% -280.2% 2.7% 41.8% 18.7% 40.2% 34.1% 2.5% 7.3% 12.9% 15.1% 17.40% <-IRR #YR-> 10 Earnings per Share 397.53% CDN$
Earnings Yield 8.2% 6.0% 7.2% 2.1% -8.7% 8.0% 12.6% 12.2% 8.3% 8.0% 12.0% 11.9% 10.3% 11.6% 12.3% 26.54% <-IRR #YR-> 5 Earnings per Share 224.41% CDN$
5 year Running Average $2.06 $1.85 $1.68 $1.38 $0.72 $0.79 $0.94 $1.26 $1.94 $3.18 $4.11 $5.07 $5.95 $6.91 $7.83 10.62% <-IRR #YR-> 10 5 yr Running Average 174.38% CDN$
10 year Running Average $1.73 $1.80 $1.82 $1.74 $1.46 $1.43 $1.39 $1.47 $1.66 $1.95 $2.45 $3.00 $3.60 $4.42 $5.50 40.09% <-IRR #YR-> 5 5 yr Running Average 439.62% CDN$
* ESP per share, Diluted (Cdn GAAP) E/P 10 Yrs 8.13% 5Yrs 11.88%
-$1.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.93
-$2.14 $0.00 $0.00 $0.00 $0.00 $6.93
-$1.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.07
-$0.94 $0.00 $0.00 $0.00 $0.00 $5.07
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 Paid in US$ US$
Pre-Split 2010 $1.52 $1.52 $1.15 $1.26 $0.18
Pre-Split 2015 $0.76 $0.76 $0.58 $0.63 $0.09 $0.42 $1.00 $1.10 $1.28 $1.52
Dividend US$ $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.10 $1.10 $1.10 163.16% <-Total Growth 10 Dividends Paid in US$ US$
Increase 2.70% 0.00% -24.34% 9.57% -85.71% 366.67% 138.10% 10.00% 16.36% 18.75% 15.79% 13.64% 10.00% 0.00% 0.00% Count 25 Years of data Since 1999 US$
Average Increases 5 Year Running 4.2% 2.3% -2.6% -0.7% -19.6% 53.2% 80.9% 87.7% 89.1% 110.0% 39.8% 14.9% 14.9% 11.6% 7.9% 46.52% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $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.88 $0.97 $1.04 111.60% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 2.18% 1.99% 1.37% 2.40% 0.51% 1.07% 2.15% 2.62% 1.86% 1.56% 1.77% 2.56% 2.26% 1.82% <-Median-> 10 Yield H/L Price US$
Yield on High Price 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.90% 1.49% <-Median-> 10 Yield on High Price US$
Yield on Low Price 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.78% 2.33% <-Median-> 10 Yield on Low Price US$
Yield on Close Price 2.11% 1.89% 1.43% 4.21% 0.36% 0.81% 3.00% 2.20% 1.56% 1.40% 2.17% 2.30% 1.93% 1.93% 1.77% 1.86% <-Median-> 10 Yield on Close Price US$
Payout Ratio EPS 25.76% 31.80% 19.62% 203.23% -4.08% 10.05% 23.81% 18.06% 18.93% 17.49% 18.03% 19.38% 18.71% 16.57% 14.40% 18.50% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 23.40% 25.10% 24.34% 28.53% 44.16% 32.54% 28.84% 25.77% 20.45% 17.78% 18.76% 18.40% 18.52% 17.99% 17.15% 25.05% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS 9.78% 10.46% 8.38% 13.46% 3.85% 5.44% 19.28% 12.02% 11.03% 11.17% 15.18% 11.29% 12.32% 11.00% 9.48% 11.23% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 10.11% 10.03% 9.95% 10.28% 9.74% 8.58% 10.14% 11.14% 10.80% 11.25% 13.02% 12.03% 12.10% 11.98% 11.46% 10.54% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC 10.79% 11.61% 7.91% 10.68% 3.27% 6.01% 12.67% 12.44% 10.51% 10.27% 13.23% 11.57% 12.97% 11.00% 9.48% 10.59% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 9.69% 9.82% 9.99% 10.07% 9.54% 8.40% 8.81% 10.01% 10.06% 10.49% 11.68% 11.53% 11.75% 11.75% 11.42% 10.03% <-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% 11.29% 11.57% 10.16% <-IRR #YR-> 10 Dividends 163.16% US$
* Dividends per share 5 Yr Med and Cur. 3.66% -11.07% Last Div Inc ---> $0.250 $0.275 10.0% 14.87% <-IRR #YR-> 5 Dividends 100.00% US$
-$0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.00
-$0.50 $0.00 $0.00 $0.00 $0.00 $1.00
Historical Dividends Historical High Div 3.25% Low Div 0.57% Ave Div 1.91% Med Div 1.77% Close Div 1.70% Historical Dividends
High/Ave/Median Values Curr diff Exp. -40.63% 238.51% Cheap 1.02% Cheap 9.01% Cheap 13.57% 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.34 $1.39 $1.39 $1.39 Not site values Using Curr. exch R.
Increase 343.48% 143.46% 7.61% 24.40% 29.52% 38.21% 10.19% 3.56% 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.44 $0.44 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $1.14 $1.32 $1.39 $1.39 $1.39 197.41% <-Total Growth 10 Dividends Paid in US$ CDN$
Increase -0.51% -0.05% -35.85% 35.79% -84.95% 277.54% 124.65% 11.88% 21.27% 26.04% 35.56% 15.35% 5.58% 0.00% 0.00% Count 25 Years of data Paid in US$ CDN$
Average Increases 5 Year Running -0.3% -3.6% -10.6% 0.1% -17.1% 38.5% 63.4% 73.0% 70.1% 92.3% 43.9% 22.0% 20.8% 16.5% 11.3% 41.19% <-Median-> 10 Average Incr 5 Year Running
Dividends 5 Yr Running $0.48 $0.46 $0.41 $0.40 $0.32 $0.28 $0.29 $0.34 $0.40 $0.55 $0.74 $0.90 $1.07 $1.22 $1.33 95.88% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 2.05% 2.07% 1.25% 2.76% 0.58% 1.10% 2.10% 2.62% 1.90% 1.59% 1.77% 2.49% 2.20% 1.84% <-Median-> 10 Yield H/L Price CDN$
Yield on High Price 1.82% 1.90% 1.13% 1.90% 0.43% 0.84% 1.61% 2.22% 1.48% 1.34% 1.55% 2.13% 1.89% 1.51% <-Median-> 10 Yield on High Price CDN$
Yield on Low Price 2.35% 2.27% 1.42% 5.01% 0.90% 1.58% 3.02% 3.20% 2.64% 1.97% 2.08% 3.01% 2.63% 2.36% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 2.11% 1.90% 1.42% 4.20% 0.44% 0.84% 2.90% 2.22% 1.53% 1.34% 2.03% 2.26% 1.93% 1.93% 1.77% 1.78% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 25.76% 31.80% 19.62% 203.23% -5.03% 10.55% 23.06% 18.19% 18.59% 16.71% 16.90% 19.01% 18.71% 16.57% 14.40% 18.39% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 23.33% 24.98% 24.49% 29.02% 44.88% 35.15% 30.65% 27.18% 20.54% 17.46% 17.98% 17.83% 18.01% 17.60% 16.93% 25.84% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 9.78% 10.46% 8.38% 13.46% 4.74% 5.71% 18.68% 12.10% 10.83% 10.67% 14.22% 11.07% 12.32% 11.00% 9.48% 10.95% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 10.09% 9.97% 10.02% 10.37% 9.94% 8.94% 10.32% 11.29% 10.80% 11.05% 12.62% 11.73% 11.84% 11.75% 11.33% 10.58% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 10.79% 11.61% 7.91% 10.68% 4.03% 6.31% 12.28% 12.53% 10.31% 9.81% 12.39% 11.34% 12.97% 11.00% 9.48% 10.50% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 9.61% 9.66% 10.06% 10.15% 9.74% 8.72% 8.92% 10.07% 10.04% 10.29% 11.31% 11.22% 11.50% 11.53% 11.27% 10.07% <-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% 11.07% 11.34% 11.52% <-IRR #YR-> 10 Dividends 197.41% CDN$
* Dividends per share 5 Yr Med and Cur. 1.59% -5.22% Last Div Inc ---> $0.336 $0.348 3.6% 21.74% <-IRR #YR-> 5 Dividends 167.39% CDN$
-$0.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.32
-$0.49 $0.00 $0.00 $0.00 $0.00 $1.32
Historical Dividends Historical High Div 3.30% Low Div 0.59% Ave Div 1.95% Med Div 1.77% Close Div 1.69% Historical Dividends CDN$
High/Ave/Median Values Curr diff Exp. -41.57% 226.83% Exp. -0.86% Cheap 8.94% Cheap 14.15% High/Ave/Median CDN$
Future Dividend Yield Div Yd 2.24% earning in 5 Years at IRR of 3.00% Div Inc. 15.93% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 2.59% earning in 10 Years at IRR of 3.00% Div Inc. 34.39% Future Dividend Yield CDN$
Future Dividend Yield Div Yd 3.00% earning in 15 Years at IRR of 3.00% Div Inc. 55.80% Future Dividend Yield CDN$
Yield if held 5 years 2.65% 2.12% 1.14% 1.62% 0.22% 1.01% 2.30% 2.43% 4.78% 8.38% 5.71% 5.61% 6.61% 3.95% 2.63% 2.37% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 years 3.30% 2.74% 1.35% 1.58% 0.30% 1.31% 2.35% 2.20% 2.80% 3.23% 5.28% 6.15% 6.14% 9.94% 13.83% 2.28% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 years 14.17% 4.84% 4.20% 0.40% 1.63% 3.05% 2.61% 2.74% 4.37% 6.83% 6.29% 5.56% 5.83% 5.33% 3.62% <-Median-> 10 Paid Median Price CDN$
Yield if held 20 years 15.76% 9.38% 7.27% 5.80% 8.50% 8.15% 6.60% 5.70% 7.21% 8.32% <-Median-> 6 Paid Median Price CDN$
Yield if held 25 years 42.14% 23.67% 15.13% 9.57% 42.14% <-Median-> 1 Paid Median Price CDN$
Cost covered if held 5 years 14.39% 11.02% 8.22% 8.40% 6.18% 6.42% 6.73% 7.54% 14.23% 27.58% 18.48% 19.27% 25.48% 17.28% 12.55% 8.31% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 28.61% 25.44% 19.97% 17.98% 20.96% 22.70% 17.90% 15.05% 16.74% 16.80% 23.51% 27.85% 31.21% 57.72% 93.53% 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.50% 36.48% 42.26% 42.19% 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.34% 53.50% 51.07% 69.73% 72.72% <-Median-> 6 Paid Median Price CDN$
Cost covered if held 25 years 341.75% 204.90% 145.18% 100.45% 341.75% <-Median-> 1 Paid Median Price CDN$
Graham No. $26.03 $24.38 $24.48 $9.25 $8.54 $27.81 $29.26 $37.03 $43.26 $52.69 $68.50 $73.13 $79.95 $84.96 $91.14 199.94% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 0.83 0.88 0.93 1.51 1.18 0.72 0.80 0.57 0.81 1.00 0.94 0.72 0.79 0.87 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 0.94 0.96 1.03 2.19 1.59 0.94 1.05 0.67 1.04 1.19 1.08 0.85 0.92 1.04 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.73 0.80 0.82 0.83 0.76 0.50 0.56 0.47 0.59 0.81 0.80 0.60 0.66 0.68 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 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.90 0.85 0.86 0.88 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close -19.32% -4.66% -18.10% -0.64% 55.84% -6.67% -41.90% -32.92% 0.66% 19.47% -18.08% -20.28% -9.81% -15.13% -13.84% -12.37% <-Median-> 10 Graham Price CDN$
Price CDN Close $ $21.00 $23.25 $20.05 $9.19 $13.32 $25.96 $17.00 $24.84 $43.55 $62.95 $56.12 $58.30 $72.11 $72.11 $78.53 150.78% <-Total Growth 10 Stock Price CDN$
Increase -14.78% 10.70% -13.78% -54.17% 44.93% 94.93% -34.50% 46.12% 75.32% 44.55% -10.85% 3.88% 23.69% 0.00% 8.90% 9.63% <-IRR #YR-> 10 Stock Price 150.78% CDN$
P/E 12.21 16.69 13.85 48.40 -11.54 12.49 7.96 8.20 12.11 12.49 8.30 8.41 9.70 8.59 8.13 27.95% <-IRR #YR-> 5 Stock Price 242.94% CDN$
Trailing P/E 9.79 13.52 14.39 6.35 70.15 -22.49 8.18 11.63 14.38 17.51 11.13 8.63 10.41 9.70 9.36 11.11% <-IRR #YR-> 10 Price & Dividend 420.85% CDN$
Median 10, 5 Yrs D. per yr 1.48% 3.09% % Tot Ret 13.34% 9.95% Price Inc 44.55% P/E: 10.26 8.41 31.04% <-IRR #YR-> 5 Price & Dividend 272.43% CDN$
Price & Dividend 15 7.13% <-IRR #YR-> 15 Price & Dividend 165.52% CDN$
Price & Dividend 20 7.31% <-IRR #YR-> 20 Price & Dividend 264.15% CDN$
Price & Dividend 25 15.25% <-IRR #YR-> 25 Price & Dividend 2022.45% CDN$
-$23.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $58.30
-$17.00 $0.00 $0.00 $0.00 $0.00 $58.30
-$23.25 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $1.14 $59.62
-$17.00 $0.55 $0.67 $0.84 $1.14 $59.62
$0.44 $0.44 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $1.14 $59.62
$0.44 $0.44 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $1.14 $59.62
$0.44 $0.44 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $1.14 $59.62
Median H/L CDN$ $21.64 $21.40 $22.64 $13.98 $10.05 $20.00 $23.46 $21.04 $35.21 $52.82 $64.41 $52.83 $63.26 8.90% 146.85% <-Total Growth 10 Stock Price CDN$
Increase -17.15% -1.08% 5.81% -38.25% -28.10% 98.91% 17.33% -10.35% 67.36% 50.04% 21.94% -17.98% 19.73% 1.93% 9.46% <-IRR #YR-> 10 Stock Price 146.85% CDN$
P/E 12.58 15.37 15.64 73.66 -8.71 9.62 10.99 6.94 9.79 10.48 9.53 7.63 8.51 10.83% 17.63% <-IRR #YR-> 5 Stock Price 125.17% CDN$
Trailing P/E 10.08 12.44 16.26 9.66 52.97 -17.33 11.29 9.85 11.62 14.69 12.78 7.82 9.13 11.08% <-IRR #YR-> 10 Price & Dividend 276.31% CDN$
P/E on Run. 5 yr Ave 10.49 11.58 13.50 10.14 13.98 25.28 24.97 16.75 18.18 16.63 15.67 10.42 10.63 20.28% <-IRR #YR-> 5 Price & Dividend 146.53% CDN$
P/E on Run. 10 yr Ave 12.47 11.90 12.46 8.02 6.88 14.01 16.83 14.34 21.23 27.12 26.28 17.58 17.55 12.38 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.62% 2.65% % Tot Ret 14.64% 13% Price Inc 21.94% P/E: 9.71 9.53 Count 26 Years of data
-$21.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.83
-$23.46 $0.00 $0.00 $0.00 $0.00 $52.83
-$21.40 $0.28 $0.39 $0.06 $0.22 $0.49 $0.55 $0.67 $0.84 $1.14 $54.15
-$23.46 $0.55 $0.67 $0.84 $1.14 $54.15
Month Jan Dec- May Jul Jan Jul Dec Jan Dec Nov Nov Jun Dec Dec
Price High CDN$ $24.39 $23.33 $25.24 $20.27 $13.63 $26.10 $30.60 $24.84 $45.10 $62.92 $73.87 $61.84 $73.73 165.09% <-Total Growth 10 Stock Price CDN$
Increase -15.15% -4.34% 8.21% -19.71% -32.77% 91.56% 17.22% -18.81% 81.54% 39.53% 17.40% -16.29% 19.23% 10.24% <-IRR #YR-> 10 Stock Price 165.09% CDN$
P/E 14.18 16.75 17.44 106.78 -11.81 12.56 14.33 8.20 12.54 12.48 10.93 8.93 9.92 15.11% <-IRR #YR-> 5 Stock Price 102.12% CDN$
Trailing P/E 11.37 13.56 18.13 14.00 71.78 -22.62 14.72 11.63 14.89 17.50 14.65 9.15 10.64 13.39 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 17.40% P/E: 12.51 10.93 27.19 P/E Ratio Historical High
-$23.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $61.84
-$30.60 $0.00 $0.00 $0.00 $0.00 $61.84
Month Apr Aug Dec Nov Mar Jan Sep Jan Jan Jan Jan Jul Apr
Pre-Split 2010 $75.54 $77.90 $80.18 $30.79 $25.93
Pre-Split 2015 $37.77 $38.95 $40.09 $15.40 $12.97 $27.79 $32.66 $34.46 $50.63
Price Low CDN$ $18.89 $19.48 $20.05 $7.70 $6.48 $13.90 $16.33 $17.23 $25.32 $42.73 $54.95 $43.82 $52.78 125.01% <-Total Growth 10 Stock Price CDN$
Increase -19.60% 3.12% 2.93% -61.60% -15.78% 114.35% 17.52% 5.51% 46.92% 68.77% 28.61% -20.25% 20.45% 8.45% <-IRR #YR-> 10 Stock Price 125.01% CDN$
P/E 10.98 13.99 13.85 40.55 -5.62 6.68 7.65 5.69 7.04 8.48 8.13 6.32 7.10 21.83% <-IRR #YR-> 5 Stock Price 168.34% CDN$
Trailing P/E 8.80 11.32 14.39 5.32 34.15 -12.04 7.86 8.07 8.36 11.88 10.90 6.48 7.62 8.65 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 28.61% P/E: 7.34 7.04 6.55 P/E Ratio Historical Low
-$19.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $43.82
-$16.33 $0.00 $0.00 $0.00 $0.00 $43.82
Pre-Split 2010 $71.98 $80.55 $80.43 $29.93 $50.58
Pre-Split 2015 $35.99 $40.28 $40.22 $14.97 $25.29 $52.00 $33.31 $50.02 $82.06
Price Close US$ $18.00 $20.14 $20.11 $7.48 $12.65 $26.00 $16.66 $25.01 $41.03 $54.35 $40.56 $43.40 $57.01 $57.01 $62.12 115.52% <-Total Growth 10 Stock Price US$
Increase -12.80% 11.91% -0.15% -62.79% 68.99% 105.61% -35.94% 50.17% 64.05% 32.46% -25.37% 7.00% 31.36% 0.00% 8.96% 7.98% <-IRR #YR-> 10 Stock Price 115.52% US$
P/E 12.20 16.85 13.73 48.27 -11.47 12.44 7.93 8.21 12.14 12.51 8.31 8.41 9.70 8.59 8.13 21.11% <-IRR #YR-> 5 Stock Price 160.58% US$
Trailing P/E 10.10 13.65 16.83 5.11 81.58 -23.58 7.97 11.91 13.47 16.08 9.33 8.89 11.05 9.70 9.36 9.62% <-IRR #YR-> 10 Price & Dividend 143.17% US$
Median 10, 5 Yrs D. per yr 1.64% 3.08% % Tot Ret 17.07% 12.72% Price Inc 32.46% P/E: 10.27 8.41 24.19% <-IRR #YR-> 5 Price & Dividend 186.58% US$
Price & Dividend 15 8.66% <-IRR #YR-> 15 Price & Dividend 219.76% CDN$
Price & Dividend 20 8.29% <-IRR #YR-> 20 Price & Dividend 327.70% CDN$
Price & Dividend 25 7.07% <-IRR #YR-> 25 Price & Dividend 381.09% CDN$
-$20.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $43.40
-$16.66 $0.00 $0.00 $0.00 $0.00 $43.40
-$20.14 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $0.88 $44.40
-$16.66 $0.55 $0.64 $0.76 $0.88 $44.40
$0.38 $0.38 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $0.88 $44.40
$0.38 $0.38 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $0.88 $44.40
$0.38 $0.38 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $0.88 $44.40
US Median H/L US$ $17.45 $19.12 $21.05 $13.12 $8.87 $19.70 $23.21 $21.01 $34.39 $48.58 $49.65 $39.12 $48.71 104.54% <-Total Growth 10 Stock Price US$
Increase -18.81% 9.60% 10.07% -37.67% -32.40% 122.07% 17.83% -9.47% 63.66% 41.28% 2.21% -21.22% 24.52% 7.42% <-IRR #YR-> 10 Stock Price 104.54% US$
P/E 11.83 16.00 14.37 84.65 -8.04 9.42 11.05 6.90 10.17 11.18 10.17 7.58 8.28 11.01% <-IRR #YR-> 5 Stock Price 68.54% US$
Trailing P/E 9.79 12.97 17.62 8.96 57.22 -17.86 11.10 10.00 11.29 14.37 11.43 8.02 9.44 9.19% <-IRR #YR-> 10 Price & Dividend 133.65% US$
P/E on Run. 5 yr Ave 11.53 13.26 14.58 10.80 13.91 25.90 24.65 16.71 18.07 16.24 13.99 9.40 10.30 13.62% <-IRR #YR-> 5 Price & Dividend 87.20% US$
P/E on Run. 10 yr Ave 14.10 14.70 15.47 9.98 8.15 17.33 19.47 15.55 22.06 26.77 23.04 15.33 16.27 11.94 P/E Ratio Historical Median
Median 10, 5 Yrs D. per yr 1.78% 2.62% % Tot Ret 19.31% 19.22% Price Inc 2.21% P/E: 10.17 10.17 Count 26 Years of data
-$19.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $39.12
-$23.21 $0.00 $0.00 $0.00 $0.00 $39.12
-$19.12 $0.29 $0.32 $0.05 $0.21 $0.50 $0.55 $0.64 $0.76 $0.88 $40.12
-$23.21 $0.55 $0.64 $0.76 $0.88 $40.12
Month Jan Dec Oct Aug Jun Dec Dec
Pre-Split 2010 $79.05 $82.83 $96.89 $81.46 $50.96
Pre-Split 2015 $39.53 $41.42 $48.45 $40.73 $25.48 $52.14 $61.49 $50.02 $86.25
Price High US$ $19.76 $20.71 $24.22 $20.37 $12.74 $26.07 $30.75 $25.01 $43.13 $57.03 $58.74 $46.78 $57.83 125.91% <-Total Growth 10 Stock Price US$
Increase -7.19% 4.78% 16.97% -15.93% -37.44% 104.63% 17.93% -18.65% 72.43% 32.24% 3.00% -20.36% 23.62% 8.49% <-IRR #YR-> 10 Stock Price 125.91% US$
P/E 13.40 17.33 16.53 131.39 -11.56 12.47 14.64 8.21 12.76 13.13 12.04 9.07 9.84 8.76% <-IRR #YR-> 5 Stock Price 52.15% US$
Trailing P/E 11.09 14.04 20.27 13.90 82.19 -23.65 14.71 11.91 14.16 16.87 13.52 9.59 11.21 13.30 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 13.52 P/E: 12.62 12.04 25.17 P/E Ratio Historical High US$
Month Sep Jan Jan Jan Dec Feb Apr
Price Low US$ $15.14 $17.54 $17.88 $5.88 $5.00 $13.32 $15.67 $17.01 $25.65 $40.13 $40.56 $31.45 $39.58 79.30% <-Total Growth 10 Stock Price US$
Increase -30.23% 15.89% 1.92% -67.14% -14.94% 166.53% 17.64% 8.55% 50.76% 56.46% 1.08% -22.46% 25.85% 6.01% <-IRR #YR-> 10 Stock Price 79.30% US$
P/E 10.26 14.68 12.20 37.90 -4.53 6.37 7.46 5.59 7.59 9.23 8.31 6.09 6.73 14.95% <-IRR #YR-> 5 Stock Price 100.70% US$
Trailing P/E 8.49 11.89 14.96 4.01 32.24 -12.08 7.50 8.10 8.42 11.87 9.33 6.44 7.67 8.62 P/E Ratio Historical Median US$
Median 10, 5 Yrs T P/E 8.42 P/E: 7.52 7.59 6.49 P/E Ratio Historical Low US$
-$17.54 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31.45
-$15.67 $0.00 $0.00 $0.00 $0.00 $31.45
Debt US$ $812 $2,346 $2,394 $3,175 Debt US$
Change 188.92% 2.05% 32.62% 95.48% <-Median-> 2 Change US$
Debt CDN$ $942 $3,249 $3,214 $4,014 Debt CDN$
Change 244.86% -1.05% 24.86% 121.91% <-Median-> 2 Change CDN$
Ratio to Market Cap 0.04 0.14 0.14 0.15 0.14 <-Median-> 3 % of Market Cap CDN$
Goodwill and Intangibles $1,194 $1,196 $1,473 $1,440 $1,350 $1,513 $2,544 $2,727 Intangibles Goodwill US$
Change 0.17% 23.16% -2.24% -6.25% 12.07% 68.14% 7.19% 6.12% <-Median-> 6 Change US$
Goodwill and Intangibles $1,188 $1,216 $1,465 $1,532 $1,566 $2,095 $3,416 $3,447 Intangibles Goodwill CDN$
Change 2.42% 20.48% 4.51% 2.26% 33.78% 63.04% 0.92% 12.50% <-Median-> 6 Change CDN$
Ratio to Market Cap 0.09 0.15 0.13 0.08 0.06 0.09 0.15 0.13 0.09 <-Median-> 7 % of Market Cap CDN$
Market Cap US$ $7,866 $8,851 $9,336 $3,370 $5,698 $12,613 $7,772 $11,662 $18,148 $22,301 $16,316 $16,590 $20,738 $20,738 $22,597 87.44% <-Total Growth 10 Market Cap US$
Market Cap CDN$ $9,179 $10,218 $9,307 $4,138 $6,000 $12,592 $7,933 $11,583 $19,262 $25,830 $22,575 $22,285 $26,231 $26,231 $28,565 118.10% <-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 393.2 377.7 -16.41% <-Total Growth 5 Average
Change -3.13% -1.87% -6.15% -4.73% -4.72% -3.94% -4.72% <-Median-> 5 Change
Pre-Split 2015 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 426.8 434.4 445.6 451.2 447.2 460.0 478.6 464.8 455.8 427.2 407.5 391.0 375.9 -9.99% <-Total Growth 10 Average
Change 10.34% 1.78% 2.58% 1.26% -0.89% 2.86% 4.04% -2.88% -1.94% -6.27% -4.61% -4.05% -3.86% -1.41% <-Median-> 10 Change
Difference 2.4% 1.2% 4.2% -0.2% 0.8% 5.5% -2.5% 0.3% -3.0% -4.0% -1.3% -2.2% -3.2% -0.73% <-Median-> 10 Difference
$3,599 <-12 mths 6.29%
Pre-Split 2010 109.278 109.880 116.071 112.606 112.660
Pre-Split 2015 218.557 219.761 232.142 225.212 225.320 242.565 233.318 233.156 221.152 205.163
# of Share in Millions 437.114 439.521 464.284 450.424 450.639 485.129 466.636 466.312 442.303 410.325 402.264 382.253 363.764 363.764 363.764 -1.39% <-IRR #YR-> 10 Shares -13.03%
Change 12.72% 0.55% 5.63% -2.99% 0.05% 7.65% -3.81% -0.07% -5.15% -7.23% -1.96% -4.97% -4.84% 0.00% 0.00% -3.91% <-IRR #YR-> 5 Shares -18.08%
CF fr Op $M US$ $1,698 $1,596 $1,593 $1,054 $527 $1,872 $1,210 $2,134 $2,567 $2,792 $2,332 $3,386 $3,248 $3,638 $4,220 112.16% <-Total Growth 10 Cash Flow US$
Increase 22.95% -6.01% -0.19% -33.84% -50.00% 255.22% -35.36% 76.36% 20.29% 8.77% -16.48% 45.20% -4.06% 11.98% 16.00% SO, DRIP Buy Backs Collapsed Dual Cl. S. Issue
5 year Running Average $1,357 $1,470 $1,497 $1,464 $1,294 $1,328 $1,251 $1,359 $1,662 $2,115 $2,207 $2,642 $2,865 $3,079 $3,365 79.72% <-Total Growth 10 CF 5 Yr Running US$
CFPS US$ $3.88 $3.63 $3.43 $2.34 $1.17 $3.86 $2.59 $4.58 $5.80 $6.80 $5.80 $8.86 $8.93 $10.00 $11.60 143.94% <-Total Growth 10 Cash Flow per Share US$
Increase 9.08% -6.52% -5.51% -31.80% -50.02% 229.96% -32.80% 76.49% 26.82% 17.24% -14.80% 52.80% 0.81% 11.98% 16.00% 7.81% <-IRR #YR-> 10 Cash Flow 112.16% US$
5 year Running Average $3.50 $3.61 $3.53 $3.37 $2.89 $2.89 $2.68 $2.91 $3.60 $4.73 $5.11 $6.37 $7.24 $8.08 $9.04 22.85% <-IRR #YR-> 5 Cash Flow 179.83% US$
P/CF on Med Price 4.49 5.27 6.14 5.61 7.58 5.10 8.95 4.59 5.92 7.14 8.56 4.42 5.45 9.33% <-IRR #YR-> 10 Cash Flow per Share 143.94% US$
P/CF on Closing Price 4.63 5.55 5.86 3.20 10.81 6.74 6.42 5.47 7.07 7.99 7.00 4.90 6.38 5.70 5.36 27.85% <-IRR #YR-> 5 Cash Flow per Share 241.61% US$
5.87% Diff M/C 5.84% <-IRR #YR-> 10 CFPS 5 yr Running 76.40% US$
-$164 <-12 mths 102.47%
Excl.Working Capital CF -$158.0 -$157.0 $94.0 $275.0 $94.0 -$177.0 $631.0 -$72.0 $127.0 $245.0 $344.0 -$81.0 -$164 $0 $0 18.91% <-IRR #YR-> 5 CFPS 5 yr Running 137.74% US$
CF fr Op $M WC US$ $1,540 $1,439 $1,687 $1,329 $621 $1,695 $1,841 $2,062 $2,694 $3,037 $2,676 $3,305 $3,084 $3,638 $4,220 129.67% <-Total Growth 10 Cash Flow less WC US$
Increase 3.98% -6.56% 17.23% -21.22% -53.27% 172.95% 8.61% 12.00% 30.65% 12.73% -11.89% 23.51% -6.67% 17.94% 16.00% 10.20% <-IRR #YR-> 10 Cash Flow less WC 129.67% US$
5 year Running Average $1,411 $1,491 $1,487 $1,495 $1,323 $1,354 $1,435 $1,510 $1,783 $2,266 $2,462 $2,755 $2,959 $3,148 $3,385 16.99% <-IRR #YR-> 5 Cash Flow less WC 79.52% US$
CFPS Excl. WC US$ $3.52 $3.27 $3.63 $2.95 $1.38 $3.49 $3.95 $4.42 $6.09 $7.40 $6.65 $8.65 $8.48 $10.00 $11.60 6.33% <-IRR #YR-> 10 CF less WC 5 Yr Run 84.71% US$
Increase -7.75% -7.07% 10.98% -18.80% -53.30% 153.54% 12.92% 12.08% 37.74% 21.52% -10.12% 29.97% -1.93% 17.94% 16.00% 13.94% <-IRR #YR-> 5 CF less WC 5 Yr Run 92.03% US$
5 year Running Average $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.45 $8.24 $9.08 10.20% <-IRR #YR-> 10 CF - Less WC 164.08% US$
P/CF on Med Price 4.95 5.84 5.79 4.45 6.44 5.64 5.88 4.75 5.65 6.56 7.46 4.52 5.74 16.99% <-IRR #YR-> 5 CF - Less WC 119.15% US$
P/CF on Closing Price 5.11 6.15 5.53 2.54 9.18 7.44 4.22 5.66 6.74 7.34 6.10 5.02 6.72 5.70 5.36 6.07% <-IRR #YR-> 10 CFPS 5 yr Running 80.24% US$
CF/-WC P/CF Med 10 yr 6.03 5 yr 5.92 P/CF Med 10 yr 5.72 5 yr 5.65 17.56% Diff M/C 16.61% <-IRR #YR-> 5 CFPS 5 yr Running 115.65% US$
$4,549 <-12 mths <-12 mths
CF fr Op $M CDN$ $1,980 $1,860 $1,574 $1,291 $552 $1,862 $1,231 $2,123 $2,730 $3,239 $3,229 $4,546 $4,106 $4,598 $5,334 144.45% <-Total Growth 10 Cash Flow CDN$
Increase 19.10% -6.06% -15.37% -18.00% -57.27% 237.57% -33.91% 72.53% 28.60% 18.63% -0.30% 40.79% -9.68% 11.98% 16.00% SO, DRIP Buy Backs Collapsed Dual Cl. S. Issue
5 year Running Average $1,832 $1,876 $1,729 $1,673 $1,451 $1,428 $1,302 $1,412 $1,699 $2,237 $2,510 $3,174 $3,570 $3,944 $4,363 69.18% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS CDN$ $4.53 $4.23 $3.39 $2.87 $1.22 $3.84 $2.64 $4.55 $6.17 $7.89 $8.03 $11.89 $11.29 $12.64 $14.66 181.08% <-Total Growth 10 Cash Flow per Share CDN$
Increase 5.66% -6.57% -19.88% -15.48% -57.29% 213.57% -31.29% 72.65% 35.58% 27.88% 1.70% 48.16% -5.09% 11.98% 16.00% 9.35% <-IRR #YR-> 10 Cash Flow 144.45% CDN$
5 year Running Average $4.77 $4.63 $4.10 $3.86 $3.25 $3.11 $2.79 $3.02 $3.68 $5.02 $5.86 $7.71 $9.06 $10.35 $11.70 29.87% <-IRR #YR-> 5 Cash Flow 269.45% CDN$
P/CF on Med Price 4.78 5.06 6.68 4.88 8.21 5.21 8.90 4.62 5.70 6.69 8.02 4.44 5.60 10.89% <-IRR #YR-> 10 Cash Flow per Share 181.08% CDN$
P/CF on Closing Price 4.64 5.49 5.91 3.21 10.88 6.76 6.45 5.46 7.06 7.97 6.99 4.90 6.39 5.70 5.36 35.16% <-IRR #YR-> 5 Cash Flow per Share 351.01% CDN$
3.18% Diff M/C 5.23% <-IRR #YR-> 10 CFPS 5 yr Running 66.45% CDN$
-$207 <-12 mths <-12 mths
Excl.Working Capital CF -$184.2 -$183.0 $92.9 $336.8 $98.4 -$176.0 $641.7 -$71.6 $135.1 $284.2 $476.4 -$108.8 -$207.3 $0.0 $0.0 22.53% <-IRR #YR-> 5 CFPS 5 yr Running 176.18% CDN$
CF fr Op $M WC CDN$ $1,795 $1,677 $1,667 $1,627 $650 $1,686 $1,872 $2,051 $2,865 $3,523 $3,706 $4,438 $3,899 $4,598 $5,334 164.64% <-Total Growth 10 Cash Flow less WC CDN$
Increase 0.73% -6.61% -0.59% -2.37% -60.07% 159.39% 11.06% 9.57% 39.67% 22.96% 5.18% 19.76% -12.14% 17.94% 16.00% 10.22% <-IRR #YR-> 10 Cash Flow less WC 164.64% CDN$
5 year Running Average $1,919 $1,924 $1,717 $1,710 $1,483 $1,461 $1,501 $1,577 $1,825 $2,400 $2,804 $3,317 $3,686 $4,033 $4,395 18.84% <-IRR #YR-> 5 Cash Flow less WC 137.01% CDN$
CFPS Excl. WC CDN$ $4.11 $3.82 $3.59 $3.61 $1.44 $3.48 $4.01 $4.40 $6.48 $8.59 $9.21 $11.61 $10.72 $12.64 $14.66 5.60% <-IRR #YR-> 10 CF less WC 5 Yr Run 72.40% CDN$
Increase -10.64% -7.12% -5.89% 0.64% -60.08% 140.94% 15.46% 9.65% 47.25% 32.54% 7.28% 26.02% -7.67% 17.94% 16.00% 17.19% <-IRR #YR-> 5 CF less WC 5 Yr Run 121.04% CDN$
5 year Running Average $5.01 $4.78 $4.09 $3.94 $3.31 $3.19 $3.23 $3.39 $3.96 $5.39 $6.54 $8.06 $9.32 $10.55 $11.77 11.77% <-IRR #YR-> 10 CFPS - Less WC 204.29% CDN$
P/CF on Med Price 5.27 5.61 6.31 3.87 6.97 5.75 5.85 4.78 5.43 6.15 6.99 4.55 5.90 23.67% <-IRR #YR-> 5 CFPS - Less WC 189.34% CDN$
P/CF on Closing Price 5.11 6.09 5.58 2.54 9.23 7.47 4.24 5.65 6.72 7.33 6.09 5.02 6.73 5.70 5.36 5.36% <-IRR #YR-> 10 CFPS 5 yr Running 68.58% CDN$
*Operational Cash Flow per share (Class A & B) CF/-WC P/CF Med 10 yr 6.19 5 yr 5.70 P/CF Med 10 yr 5.80 5 yr 5.43 15.97% Diff M/C 20.08% <-IRR #YR-> 5 CFPS 5 yr Running 149.70% CDN$
OPM 7.4% 6.6% 6.1% 4.4% 3.0% 7.8% 4.2% 6.9% 7.4% 7.6% 7.3% 9.3% 40.76% <-Total Growth 10 OPM CDN$
Increase 11.32% -11.33% -7.41% -27.24% -31.76% 155.96% -45.81% 64.42% 6.48% 3.40% -4.76% 28.02% should be zero, it is a check on calculations CDN$
Diff from Ave 5.0% -6.9% -13.8% -37.3% -57.2% 9.6% -40.6% -2.4% 4.0% 7.5% 2.4% 31.1% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 7.09% 5 Yrs 7.37% Should increase or be stable. CDN$
Current Assets US$ $6,603 $7,076 $8,770 $7,351 $6,303 $7,814 $8,146 $9,135 $9,923 $10,007 $11,144 $10,163 $11,564 Liquidity ratio of 1.5 and up, best US$
Current Liabilities $4,388 $4,783 $5,658 $5,093 $4,299 $5,200 $5,724 $6,684 $7,309 $7,611 $7,276 $8,695 $9,166 1.43 <-Median-> 10 Ratio US$
Liquidity 1.50 1.48 1.55 1.44 1.47 1.50 1.42 1.37 1.36 1.31 1.53 1.17 1.26 1.36 <-Median-> 5 Ratio US$
Assets US$ $12,321 $13,154 $15,343 $13,189 $12,303 $13,898 $14,679 $17,109 $17,990 $18,139 $19,706 $22,566 $25,090 Debt Ratio of 1.5 and up, best US$
Liabilities $5,756 $5,997 $6,701 $5,826 $4,943 $5,759 $6,477 $7,651 $8,351 $9,466 $10,589 $12,347 $13,610 2.25 <-Median-> 10 Ratio US$
Debt Ratio 2.14 2.19 2.29 2.26 2.49 2.41 2.27 2.24 2.15 1.92 1.86 1.83 1.84 1.92 <-Median-> 5 Ratio US$
Total Book Value US$ $6,565 $7,157 $8,642 $7,363 $7,360 $8,139 $8,202 $9,458 $9,639 $8,673 $9,117 $10,219 $11,480 42.78% <-Total Growth 10 Book Value US$
NCI US$ $74 $27 $29 $16 $14 $151 $451 $481 NCI US$ US$
Book Value US $6,565 $7,157 $8,642 $7,363 $7,360 $8,065 $8,175 $9,429 $9,623 $8,659 $8,966 $9,768 $10,999 $10,999 $10,999 36.48% <-Total Growth 10 Book Value US$
Book Value per Share $15.02 $16.28 $18.61 $16.35 $16.33 $16.62 $17.52 $20.22 $21.76 $21.10 $22.29 $25.55 $30.24 $30.24 $30.24 56.93% <-Total Growth 10 Book Value US$
Change 9.17% 8.42% 14.31% -12.18% -0.09% 1.79% 5.38% 15.42% 7.60% -3.01% 5.62% 14.65% 18.33% 0.00% 0.00% 50.27% Current/Historical Book Value US$
P/B Ratio (Median) 1.16 1.17 1.13 0.80 0.54 1.18 1.32 1.04 1.58 2.30 2.23 1.53 1.61 0.00 0.00 1.17 P/BV Ratio Historical Median US$
P/B Ratio (Close) 1.20 1.24 1.08 0.46 0.77 1.56 0.95 1.24 1.89 2.58 1.82 1.70 1.89 1.89 2.05 4.61% <-IRR #YR-> 10 Book Value 56.93% US$
Change -20.13% 3.22% -12.65% -57.63% 69.14% 102.00% -39.21% 30.10% 52.47% 36.57% -29.34% -6.67% 11.02% 0.00% 8.96% 7.84% <-IRR #YR-> 5 Book Value 45.86% US$
Leverage (A/BK) 1.88 1.84 1.78 1.79 1.67 1.72 1.80 1.81 1.87 2.09 2.20 2.31 2.28 1.81 <-Median-> 10 A/BV US$
Debt/Equity Ratio 0.88 0.84 0.78 0.79 0.67 0.71 0.79 0.81 0.87 1.09 1.18 1.26 1.24 0.80 <-Median-> 10 Debt/Eq Ratio US$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.25 5 yr Med 1.58 50.27% Diff M/C
-$16.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.55
-$17.52 $0.00 $0.00 $0.00 $0.00 $25.55
Current Assets CDN$ $7,698 $8,246 $8,666 $9,002 $6,597 $7,772 $8,284 $9,088 $10,554 $11,609 $15,432 $13,646 $14,618 Liquidity ratio of 1.5 and up, best CDN$
Current Liabilities $5,116 $5,574 $5,591 $6,237 $4,499 $5,172 $5,821 $6,650 $7,774 $8,830 $10,075 $11,675 $11,587 1.43 <-Median-> 10 Ratio CDN$
Liquidity 1.50 1.48 1.55 1.44 1.47 1.50 1.42 1.37 1.36 1.31 1.53 1.17 1.26 1.36 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 1.85 1.78 1.81 1.62 1.58 1.84 1.60 1.65 1.67 1.64 1.81 1.52 1.57 1.65 <-Median-> 5 Ratio CDN$
Liq. CF re Inv+Div 1.50 1.44 1.57 1.34 1.31 1.61 1.31 1.30 1.43 1.35 1.53 1.02 1.57 1.35 <-Median-> 5 Ratio CDN$
Assets CDN$ $14,365 $15,328 $15,160 $16,151 $12,876 $13,823 $14,929 $17,022 $19,134 $21,043 $27,288 $30,299 $31,716 Debt Ratio of 1.5 and up, best CDN$
Liabilities $6,711 $6,988 $6,621 $7,135 $5,173 $5,728 $6,587 $7,612 $8,882 $10,982 $14,663 $16,578 $17,204 2.25 <-Median-> 10 Ratio CDN$
Debt Ratio 2.14 2.19 2.29 2.26 2.49 2.41 2.27 2.24 2.15 1.92 1.86 1.83 1.84 1.92 <-Median-> 5 Ratio CDN$
CDN$ Check $7,654 $8,340 $8,539 $9,017 $7,703 $8,095 $8,341 $9,410 $10,252 $10,062 $12,625 $13,721 $14,512
Total Book Value CDN$ $7,654 $8,340 $8,539 $9,017 $7,703 $8,095 $8,341 $9,410 $10,252 $10,062 $12,625 $13,721 $14,512 64.52% <-Total Growth 10 Book Value CDN$
NCI CDN$ $74 $27 $29 $17 $16 $209 $606 $608 NCI CDN$
Book Value CDN $7,654 $8,340 $8,539 $9,017 $7,703 $8,021 $8,314 $9,381 $10,235 $10,045 $12,416 $13,115 $13,904 $13,904 $13,904 57.26% <-Total Growth 10 Book Value CDN$
Book Value per Share $17.51 $18.98 $18.39 $20.02 $17.09 $16.53 $17.82 $20.12 $23.14 $24.48 $30.86 $34.31 $38.22 $38.22 $38.22 80.82% <-Total Growth 10 Book Value CDN$
Change 5.75% 8.36% -3.07% 8.84% -14.61% -3.27% 7.75% 12.91% 15.03% 5.80% 26.07% 11.17% 11.40% 0.00% 0.00% 48.08% Current/Historical Book Value CDN$
P/B Ratio (Median) 1.24 1.13 1.23 0.70 0.59 1.21 1.32 1.05 1.52 2.16 2.09 1.54 1.65 1.24 P/BV Ratio Historical Median CDN$
P/B Ratio (Close) 1.20 1.23 1.09 0.46 0.78 1.57 0.95 1.23 1.88 2.57 1.82 1.70 1.89 1.89 2.05 6.10% <-IRR #YR-> 10 Book Value 80.82% CDN$
Change -19.41% 2.16% -11.04% -57.89% 69.72% 101.52% -39.22% 29.41% 52.42% 36.63% -29.29% -6.55% 11.03% 0.00% 8.90% 14.00% <-IRR #YR-> 5 Book Value 92.58% CDN$
Leverage (A/BK) 1.88 1.84 1.78 1.79 1.67 1.72 1.80 1.81 1.87 2.09 2.20 2.31 2.28 1.81 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 0.88 0.84 0.78 0.79 0.67 0.71 0.79 0.81 0.87 1.09 1.18 1.26 1.24 0.80 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.27 5 yr Med 1.54 48.08% Diff M/C
$2,567 <-12 mths 25.34%
Comprehensive Income US$ $726 $1,506 $1,403 $1,037 $1,082 $2,030
NCI -$3 -$5 -$17 -$2 -$8 -$18
Shareholders $488 $721 $1,202 -$945 $14 $1,052 $729 $1,511 $1,420 $1,039 $1,090 $2,048 184.05% <-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% 87.89% 4.91% <-Median-> 5 Comprehensive Income US$
5 Yr Running Average $296 $409 $410 $472 $945 $1,150 $1,158 $1,422 11.00% <-IRR #YR-> 10 Comprehensive Income 184.05% US$
ROE US$ 7.4% 10.1% 13.9% -12.8% 0.2% 12.9% 8.9% 16.0% 14.7% 12.0% 12.0% 20.0% 22.95% <-IRR #YR-> 5 Comprehensive Income 180.93% US$
5Yr Median 7.4% 10.1% 8.9% 8.9% 12.9% 12.9% 12.0% 14.7% 25.13% <-IRR #YR-> 7 5 Yr Running Average #DIV/0! US$
% 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% -5.6% 28.21% <-IRR #YR-> 5 5 Yr Running Average 246.39% US$
Median Values Diff 5, 10 yr -18.9% -9.2% 14.7% <-Median-> 5 Return on Equity US$
Current Liability Coverage Ratio US$ 0.35 0.30 0.30 0.26 0.14 0.33 0.32 0.31 0.37 0.40 0.37 0.38 0.34 CFO / Current Liabilities US$
5 year Median 0.37 0.36 0.35 0.30 0.30 0.30 0.30 0.31 0.32 0.33 0.37 0.37 0.37 0.37 <-Median-> 5 Current Liability Cov Ratio US$
Asset Efficiency Ratio US$ 12.50% 10.94% 11.00% 10.08% 5.05% 12.20% 12.54% 12.05% 14.97% 16.74% 13.58% 14.65% 12.29% CFO / Total Assets US$
5 year Median 13.12% 12.75% 12.50% 11.00% 10.94% 10.94% 11.00% 12.05% 12.20% 12.54% 13.58% 14.65% 14.65% 14.6% <-Median-> 5 Return on Assets US$
Return on Assets ROA US$ 5.2% 4.0% 4.3% 0.5% -4.0% 7.0% 6.9% 8.4% 8.7% 10.4% 10.2% 9.2% 8.8% Net Income/Assets Return on Assets US$
5Yr Median 5.5% 5.3% 5.2% 4.3% 4.0% 4.0% 4.3% 6.9% 7.0% 8.4% 8.7% 9.2% 9.2% 9.2% <-Median-> 5 Asset Efficiency Ratio US$
Return on Equity ROE US$ 9.7% 7.4% 7.7% 1.0% -6.7% 12.1% 12.5% 15.2% 16.2% 21.8% 22.5% 21.2% 20.1% Net Inc/ Shareholders' equity Return on Equity US$
5Yr Median 10.6% 10.2% 9.7% 7.7% 7.4% 7.4% 7.7% 12.1% 12.5% 15.2% 16.2% 21.2% 21.2% 21.2% <-Median-> 5 Return on Equity US$
$2,171 <-12 mths 4.68%
Net Income US$ $961 $1,015 $1,426 $1,545 $1,882 $2,007 $2,031 Net Income US$
NCI -$12 -$3 -$7 -$16 -$2 -$6 -$43 NCI US$
Shareholders $639 $528 $663 $71 -$493 $973 $1,018 $1,433 $1,561 $1,884 $2,013 $2,074 $2,209 $2,390 $2,542 292.80% <-Total Growth 10 Shareholders US$
Increase -7.66% -17.37% 25.57% -89.29% -794% 297.36% 4.62% 40.77% 8.93% 20.69% 6.85% 3.03% 6.51% 8.19% 6.36% EPS/CF Ratio should not be higher than 1.00 US$
5 Yr Running Average $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,793.0 $1,948.2 $2,114.0 $2,245.6 14.66% <-IRR #YR-> 10 Net Income 292.80% US$
Operating Cash Flow $1,698 $1,596 $1,593 $1,054 $527 $1,872 $1,210 $2,134 $2,567 $2,792 $2,332 $3,386 15.30% <-IRR #YR-> 5 Net Income 103.73% US$
Investment Cash Flow -$1,051 -$1,111 -$868 -$1,063 -$876 -$744 -$1,272 -$1,815 -$1,207 -$1,617 -$1,288 -$4,271 11.81% <-IRR #YR-> 10 5 Yr Running Ave. 205.45% US$
Total Accruals -$8 $43 -$62 $80 -$144 -$155 $1,080 $1,114 $201 $709 $969 $2,959 32.06% <-IRR #YR-> 5 5 Yr Running Ave. 301.66% US$
Total Assets $12,321 $13,154 $15,343 $13,189 $12,303 $13,898 $14,679 $17,109 $17,990 $18,139 $19,706 $22,566 Balance Sheet Assets US$
Accruals Ratio -0.06% 0.33% -0.40% 0.61% -1.17% -1.12% 7.36% 6.51% 1.12% 3.91% 4.92% 13.11% 4.92% <-Median-> 5 Ratio US$
EPS/CF Ratio (WC) 0.42 0.36 0.40 0.05 -0.80 0.60 0.53 0.69 0.55 0.59 0.73 0.60
Financial Cash Flow US$ -$426 -$386 $44 $89 -$1,164 -$355 -$457 -$216 -$1,300 -$1,378 $741 -$1,020 C F Statement Financial Cash Flow US$
Total Accruals $418 $429 -$106 -$9 $1,020 $200 $1,537 $1,330 $1,501 $2,087 $228 $3,979 Accruals US$
Accruals Ratio 3.39% 3.26% -0.69% -0.07% 8.29% 1.44% 10.47% 7.77% 8.34% 11.51% 1.16% 17.63% 8.34% <-Median-> 5 Ratio US$
$3,245 <-12 mths 18.00%
Comprehensive Income CDN$ $738 $1,498 $1,492 $1,203 $1,498 $2,726
NCI -$3 -$5 -$18 -$2 -$11 -$24
Shareholders $569 $840 $1,188 -$1,157 $15 $1,046 $741 $1,503 $1,510 $1,205 $1,509 $2,750 227.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% 82.19% 25.22% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $291 $386 $367 $430 $963 $1,201 $1,294 $1,696 12.59% <-IRR #YR-> 10 Comprehensive Income 227.29% CDN$
ROE CDN$ 7.4% 10.1% 13.9% -12.8% 0.2% 12.9% 8.9% 16.0% 14.7% 12.0% 12.0% 20.0% 29.97% <-IRR #YR-> 5 Comprehensive Income 270.90% CDN$
5Yr Median 7.4% 10.1% 8.9% 8.9% 12.9% 12.9% 12.0% 14.7% 28.64% <-IRR #YR-> 7 5 Yr Running Average #DIV/0! CDN$
% Difference from NI -23.6% 36.6% 81.3% -1431% -102.8% 7.1% -28.6% 5.1% -9.2% -44.9% -46.7% -5.6% 35.84% <-IRR #YR-> 5 5 Yr Running Average 362.58% CDN$
Median Values Diff 5, 10 yr -18.9% -9.2% 14.7% <-Median-> 5 Return on Equity CDN$
Current Liability Coverage Ratio CDN$ 0.35 0.30 0.30 0.26 0.14 0.33 0.32 0.31 0.37 0.40 0.37 0.38 0.34 CFO / Current Liabilities CDN$
5 year Median 0.37 0.36 0.35 0.30 0.30 0.30 0.30 0.31 0.32 0.33 0.37 0.37 0.37 0.37 <-Median-> 5 Current Liability Cov Ratio CDN$
Asset Efficiency Ratio CDN$ 12.50% 10.94% 11.00% 10.08% 5.05% 12.20% 12.54% 12.05% 14.97% 16.74% 13.58% 14.65% 12.29% CFO / Total Assets CDN$
5 year Median 13.12% 12.75% 12.50% 11.00% 10.94% 10.94% 11.00% 12.05% 12.20% 12.54% 13.58% 14.65% 14.65% 14.6% <-Median-> 5 Return on Assets CDN$
Return on Assets ROA CDN$ 5.2% 4.0% 4.3% 0.5% -4.0% 7.0% 6.9% 8.4% 8.7% 10.4% 10.2% 9.2% 8.8% Net Income/Assets Return on Assets CDN$
5Yr Median 5.5% 5.3% 5.2% 4.3% 4.0% 4.0% 4.3% 6.9% 7.0% 8.4% 8.7% 9.2% 9.2% 9.2% <-Median-> 5 Asset Efficiency Ratio CDN$
Return on Equity ROE CDN$ 9.7% 7.4% 7.7% 1.0% -6.7% 12.1% 12.5% 15.2% 16.2% 21.8% 22.5% 21.2% 20.1% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 10.6% 10.2% 9.7% 7.7% 7.4% 7.4% 7.7% 12.1% 12.5% 15.2% 16.2% 21.2% 21.2% 21.2% <-Median-> 5 Return on Equity CDN$
$2,744 <-12 mths -1.45%
Net Income CDN$ $956 $1,032 $1,419 $1,643 $2,183 $2,779 $2,727 Net Income CDN$
NCI -$12 -$3 -$7 -$17 -$2 -$8 -$58 NCI CDN$
Shareholders $745 $615 $655 $87 -$516 $968 $1,035 $1,426 $1,660 $2,186 $2,787 $2,785 $2,792 $3,021 $3,213 352.60% <-Total Growth 10 Shareholders CDN$
Increase -10.55% -17.41% 6.47% -86.73% -693% 287.56% 6.98% 37.71% 16.45% 31.64% 27.54% -0.10% 0.27% 8.19% 6.36% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $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,168.8 $2,442.1 $2,714.3 $2,919.8 16.30% <-IRR #YR-> 10 Net Income 352.60% CDN$
Operating Cash Flow $1,980 $1,860 $1,574 $1,291 $552 $1,862 $1,231 $2,123 $2,730 $3,239 $3,229 $4,546 21.88% <-IRR #YR-> 5 Net Income 168.98% CDN$
Investment Cash Flow -$1,225 -$1,295 -$858 -$1,302 -$917 -$740 -$1,294 -$1,806 -$1,284 -$1,876 -$1,784 -$5,735 11.22% <-IRR #YR-> 10 5 Yr Running Ave. 189.72% CDN$
Total Accruals -$9 $50 -$61 $98 -$151 -$154 $1,098 $1,108 $214 $823 $1,342 $3,973 37.22% <-IRR #YR-> 5 5 Yr Running Ave. 386.46% CDN$
Total Assets $14,365 $15,328 $15,160 $16,151 $12,876 $13,823 $14,929 $17,022 $19,134 $21,043 $27,288 $30,299 Balance Sheet Assets CDN$
Accruals Ratio -0.06% 0.33% -0.40% 0.61% -1.17% -1.12% 7.36% 6.51% 1.12% 3.91% 4.92% 13.11% 4.92% <-Median-> 5 Ratio CDN$
EPS/CF Ratio (WC) 0.42 0.36 0.40 0.05 -0.80 0.60 0.53 0.69 0.55 0.59 0.73 0.60 0.57 <-Median-> 10 EPS/CF Ratio CDN$
Change in Close -14.78% 10.70% -13.78% -54.17% 44.93% 94.93% -34.50% 46.12% 75.32% 44.55% -10.85% 3.88% 23.69% 0.00% 8.90% Count 26 Years of data CDN$
up/down down down down Count 9 34.62% CDN$
Meet Prediction? % right Count 1 11.11% CDN$
Financial Cash Flow CDN$ -$497 -$450 $43 $109 -$1,218 -$353 -$465 -$215 -$1,383 -$1,599 $1,026 -$1,370 C F Statement Financial Cash Flow CDN$
Total Accruals $487 $500 -$105 -$11 $1,068 $199 $1,563 $1,323 $1,596 $2,421 $316 $5,343 Accruals CDN$
Accruals Ratio 3.39% 3.26% -0.69% -0.07% 8.29% 1.44% 10.47% 7.77% 8.34% 11.51% 1.16% 17.63% 8.34% <-Median-> 5 Ratio CDN$
Cash US$ $2,757 $1,334 $2,105 $1,325 $1,522 $1,554 $1,253 $2,863 $974 $895 Cash US$
Cash CDN$ $1,623 $1,387 $1,318 $1,348 $1,318 $1,409 $1,537 $1,835 $1,779 $1,675 Cash CDN$
Cash per Share CDN$ $3.60 $3.08 $2.72 $2.89 $2.83 $3.19 $3.75 $4.56 $4.65 $4.60 $3.75 <-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.98% 6.39% 7.98% <-Median-> 5 % of Stock Price CDN$
Notes:
December 23, 2017. Last estimates were for 2016, 2017 and 2018 of $36231M, $37534M and $40298M for Revenue US$, $5.22, $5.68 and $6.44 EPS US$, $8.61, $9.37 and $8.98 CFPS US$,
$2065M, $2175M and $2412M for Net Income US$.
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, Consumer
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.
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.
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.
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.
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 Shares %, Val $M
Date Dec 17 2012 Dec 14 2013 Dec 25 2014 Dec 26 2015 Dec 26 2016 Dec 23 2017
Walker, Donald James 0.423 0.09% 0.534 0.12% 0.511 0.12% 1.522 0.38% 1.974 0.52% 2.260 0.62%
CEO - Shares - Amount $10.510 $23.235 $32.144 $85.395 $115.103 $162.983
Options - percentage 1.419 0.30% 1.574 0.36% 1.547 0.38% 2.579 0.64% 1.977 0.52% 2.161 0.59%
Options - amount $35.253 $68.560 $97.379 $144.744 $115.258 $155.805
Galifi, Vincent Joseph 0.228 0.05% 0.271 0.06% 0.402 0.10% 1.579 0.39% 1.348 0.35% 1.071 0.29%
CFO - Shares - Amount $5.664 $11.800 $25.285 $88.599 $78.588 $77.250
Options - percentage 2.318 0.50% 1.283 0.29% 0.414 0.10% 0.743 0.18% 0.629 0.16% 0.782 0.21%
Options - amount $57.588 $55.891 $26.087 $41.696 $36.650 $56.372
Apfalter, Guenther Friedrich 0.024 0.01% 0.024 0.01% 0.107 0.03% 0.066 0.02% 0.071 0.02% 0.075 0.02%
Officer - Shares - Amount $0.586 $1.028 $6.744 $3.695 $4.141 $5.372
Options - percentage 0.118 0.03% 0.099 0.02% 0.116 0.03% 0.523 0.13% 0.336 0.09% 0.326 0.09%
Options - amount $2.938 $4.298 $7.285 $29.347 $19.581 $23.532
Bonham, Scott Barclay 0.000 0.00% 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 $0.000
Options - percentage 0.008 0.00% 0.012 0.00% 0.032 0.01% 0.041 0.01% 0.049 0.01%
Options - amount $0.362 $0.755 $1.798 $2.361 $3.555
Bowie, Peter Guy 0.003 0.00% 0.004 0.00% 0.014 0.00% 0.014 0.00% 0.014 0.00%
Director - Shares - Amount $0.075 $0.220 $0.786 $0.816 $1.010
Options - percentage 0.003 0.00% 0.010 0.00% 0.025 0.01% 0.031 0.01% 0.037 0.01%
Options - amount $0.073 $0.641 $1.404 $1.825 $2.681
Young, William L. 0.001 0.00% 0.004 0.00% 0.004 0.00% 0.004 0.00%
Chairman- Shares - Amount $0.059 $0.209 $0.217 $0.268
Options - percentage 0.026 0.01% 0.059 0.01% 0.073 0.02% 0.086 0.02%
Options - amount $1.667 $3.334 $4.274 $6.213
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% 2.100 0.55%
due to SO $23.800 $9.936 $87.100 $81.835 $134.688 $122.430
Book Value $69.000 $19.000 $84.000 $63.000 $57.500 $47.000
Insider Buying -$0.162 -$0.007 -$0.387 -$1.113
Insider Selling $99.238 $47.178 $74.094 $44.283
Net Insider Selling $99.076 $47.172 $73.706 $43.170
% of Market Cap 0.79% 0.21% 0.33% 0.16%
Directors 9 11 11 10 11
Women 1 11% 3 27% 3 27% 3 30% 4 36%
Minorities 0 0% 1 9% 1 9% 1 10% 1 9% East Asian Lady
Institutions/Holdings 230 394 31.60% 404 67.11% 408 60.12% 410 61.08%
Total Shares Held 159.167 34.13% 127.116 201.93% 271.391 67.47% 231.097 60.46% 220.405 60.59%
Increase/Decrease -4.746 -3.07% -4.745 -3.60% 8.894 3.39% -5.769 -2.44% -4.866 -2.16%
Starting No. of Shares 154.422 Nasdaq 131.861 Nasdaq 262.497 Nasdaq 236.865 Nasdaq 225.271 Nasdaq
Copyright 2008 Website of SPBrunner. All rights reserved.