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. 6/30/10
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Magna International Inc NYSE: MGA TSX: MG.A www.magna.com Fiscal Yr: Dec-31
Year 12/31/99 12/31/00 12/31/01 12/31/02 12/31/03 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/30/12
Fiscal year Dec-31
Report Currency US$--> C GAAP US GAAP
CDN$-US$ 1.4733 1.5224 1.5926 1.5796 1.2924 1.2924 1.163 1.1652 0.9881 1.2240 1.0501 0.9970 0.9970 0.9970
split restated restated 2
Rev US$ $9,447 $10,513 $10,507 $12,971 $15,345 $20,653 $22,811 $24,180 $26,067 $23,704 $17,367 $24,102 $28,644 $29,722 129.26% <-Total Growth 10 Revenue US$
Cdn Revenue* $13,918 $16,005 $16,733 $20,489 $19,832 $26,692 $26,529 $28,175 $25,757 $29,014 $18,237 $24,030 $28,558 $29,633 50.14% <-Total Growth 10 Revenue CDN$
Increase 50.3% 15.0% 4.6% 22.4% -3.2% 34.6% -0.6% 6.2% -8.6% 12.6% -37.1% 31.8% 18.8% 3.8% 4.15% <-IRR #YR-> 10 Revenue CDN$
Rev per Share $88.61 $101.86 $100.39 $107.19 $102.85 $137.67 $121.38 $128.21 $110.95 $128.83 $80.94 $99.07 $117.98 $122.42 -1.96% <-IRR #YR-> 5 Revenue CDN$
P/S (Price/Sales) 0.36 0.31 0.50 0.40 0.51 0.36 0.35 0.36 0.36 0.14 0.33 0.52 0.29 0.28 -0.28% <-IRR #YR-> 10 Rev Per share CDN$
*Revenue in M Cdn $ (Total Sales) P/S 10 yr  0.36 5 yr  0.36 -3.98% <-IRR #YR-> 5 Rev Per share CDN$
-$16,005 $0 $0 $0 $0 $0 $0 $0 $0 $0 $24,030
-$26,529 $0 $0 $0 $0 $24,030
-$102 $0 $0 $0 $0 $0 $0 $0 $0 $0 $99
-$121 $0 $0 $0 $0 $99
Pre-Split 2010 $4.65 $6.44 $6.20 $5.82 $5.21 $5.21 $5.90 $4.78 $5.86 $0.62 -$4.41
EPS US$ $2.33 $3.22 $3.10 $2.91 $2.61 $2.61 $2.95 $2.39 $2.93 $0.31 -$2.21 $4.18 $4.44 $4.60 29.81% <-Total Growth 10 Earnings US$
Pre-Split 2010
EPS CDN$* $3.43 $4.90 $4.94 $4.60 $3.37 $3.37 $3.43 $2.78 $2.90 $0.38 -$2.32 $4.17 $4.43 $4.59 -14.99% <-Total Growth 10 Earnings CDN$
Increase 84.2% 43.1% 0.7% -6.9% -26.8% 0.0% 1.9% -18.8% 4.0% -86.9% -710.2% -280.0% 6.2% 3.6% -1.61% <-IRR #YR-> 10 Earnings CDN$
Earnings Yield 10.9% 15.6% 9.8% 10.6% 6.5% 6.8% 8.2% 6.0% 7.2% 2.1% -8.7% 8.0% 12.8% 13.2% 3.97% <-IRR #YR-> 5 Earnings CDN$
* ESP per share, Diluted (Cdn GAAP) E/P 10 Yrs 7.03% 5Yrs 5.99%
-$4.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.17
-$3.43 $0.00 $0.00 $0.00 $0.00 $4.17
stopped
Pre-Split 2010 $1.11 $1.24 $1.36 $1.36 $1.36 $1.48 $1.52 $1.52 $1.15 $1.26 $0.18
Div US$ $0.56 $0.62 $0.68 $0.68 $0.68 $0.74 $0.76 $0.76 $0.58 $0.63 $0.09 $0.42 $1.00 $1.00 -32.26% <-Total Growth 10 Dividends US$
Increase 103.8% 11.7% 9.7% 0.0% 0.0% 8.8% 2.7% 0.0% -24.3% 9.6% -85.7% 366.7% 138.1% 0.0%
Yield on Cl Pr. 2.96% 2.14% 2.45% 1.70% 1.79% 2.11% 1.89% 1.43% 4.21% 0.36% 0.81% 2.91% 2.91% 1.84% <-Median-> 10 Dividends US$
Yield  1.43%
Pre-Split 2010
Div CDN $0.82 $0.94 $1.08 $1.07 $0.88 $0.96 $0.88 $0.89 $0.57 $0.77 $0.09 $0.42 $1.00 $1.00 -55.64% <-Total Growth 10 Dividends CDN$
Increase 94.7% 15.4% 14.7% -0.8% -18.2% 8.8% -7.6% 0.2% -35.8% 35.7% -87.7% 343.1% 138.1% 0.0% -0.31% <-Median-> 10 Dividends CDN$
Yield H/L Pr. 2.12% 2.82% 2.59% 2.15% 1.84% 1.83% 2.04% 2.07% 1.25% 2.76% 0.47% 1.05% 1.94% <-Median-> 10 Dividends CDN$
Yield on High  Pr. 1.74% 2.47% 2.09% 1.78% 1.52% 1.66% 1.81% 1.90% 1.13% 1.90% 0.35% 0.80% 1.72% <-Median-> 10 Dividends CDN$
Yield on Low Pr. 2.73% 3.29% 3.39% 2.70% 2.34% 2.04% 2.34% 2.27% 1.42% 5.01% 0.73% 1.51% 2.31% <-Median-> 10 Dividends CDN$
Yield on Cl Pr. 2.60% 3.00% 2.14% 2.48% 1.69% 1.94% 2.10% 1.90% 1.42% 4.20% 0.35% 0.81% 2.88% 2.88% 1.92% <-Median-> 10 Dividends CDN$
Payout Ratio CDN 23.87% 19.25% 21.94% 23.37% 26.10% 28.41% 25.76% 31.80% 19.62% 203.23% -4.08% 10.05% 22.52% 21.74% 24.57% <-Median-> 10 DPR EPS CDN$
Payout R CF CDN 11.6% 14.9% 11.0% 8.9% 10.8% 10.4% 9.8% 10.5% 8.4% 13.5% 3.8% 5.4% 15.1% 13.7% 10.09% <-Median-> 10 DPR CF CDN$
Payout Ratio CF NC 11.6% 9.8% 10.9% 7.6% 10.2% 9.7% 10.8% 11.6% 7.9% 10.7% 3.3% 6.0% 15.1% 13.7% 9.93% <-Median-> 10 DPR CF NC CDN$
Median 5 Yrs Div Yd 3.34% 5 3.87% 10 Yield  1.25% 1.42% Payout 19.62% 8.38% -7.81% <-IRR #YR-> 10 Dividends CDN$
* Dividends per share  3.0% Years 3.0% Years Last Div Inc ---> $0.18 $0.25 38.9% US$ -13.88% <-IRR #YR-> 5 Dividends CDN$
-$0.94 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.42
-$0.88 $0.00 $0.00 $0.00 $0.00 $0.42
H/LYield held 5 yrs 2.81% 3.51% 3.35% 2.55% 1.80% 2.48% 2.64% 2.12% 1.14% 1.62% 0.18% 0.97% 2.33% 2.20% 1.96% <-Median-> 10 Dividends CDN$
H/LYield held 10 yrs 17.33% 9.14% 4.78% 3.29% 3.29% 2.74% 1.35% 1.58% 0.25% 1.25% 2.38% 1.99% 3.01% <-Median-> 10 Dividends CDN$
H/LYield held 15 yrs 14.17% 4.84% 4.20% 0.33% 1.56% 3.09% 2.37% 4.20% <-Median-> 5 Dividends CDN$
Graham No. $53.94 $67.01 $68.97 $68.07 $50.03 $51.90 $51.93 $48.76 $48.95 $18.48 $17.11 $55.75 $60.03 $61.11 -16.80% <-Total Growth 10 Graham Price CDN$
Prem /Disc.Med H/L -28.50% -50.08% -39.30% -26.54% -4.74% 0.62% -16.68% -12.22% -7.48% 51.30% 17.50% -28.26% -9.85% <-Median-> 10 Graham Price CDN$
Prem /Disc. High -12.63% -42.99% -24.85% -11.49% 15.38% 10.74% -6.08% -4.32% 3.14% 119.30% 59.24% -6.37% -0.59% <-Median-> 10 Graham Price CDN$
Prem /Disc. Low -44.38% -57.17% -53.75% -41.60% -24.85% -9.49% -27.27% -20.12% -18.10% -16.71% -24.24% -50.15% -24.54% <-Median-> 10 Graham Price CDN$
Prem /Disc. Cl -41.60% -53.07% -26.71% -36.28% 3.97% -5.04% -19.12% -4.65% -18.10% -0.59% 55.61% -6.89% -42.32% -43.33% -5.97% <-Median-> 10 Graham Price CDN$
Price Cdn Cl $ $31.50 $31.45 $50.55 $43.38 $52.02 $49.29 $42.00 $46.50 $40.09 $18.38 $26.63 $51.91 $34.63 $34.63 65.06% <-Total Growth 10 Stock Price CDN$
Increase -34.2% -0.2% 60.7% -14.2% 19.9% -5.3% -14.8% 10.7% -13.8% -54.2% 44.9% 94.9% -33.3% 0.0% 5.14% <-IRR #YR-> 10 Stock Price CDN$
P/E 9.2 6.42 10.24 9.44 15.45 14.64 12.24 16.70 13.85 48.43 -11.50 12.46 7.82 7.55 4.33% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 16.9 9.18 10.31 8.79 11.32 14.64 12.48 13.55 14.40 6.35 70.18 -22.42 8.31 7.82 7.23% <-IRR #YR-> 10 Price & Div CDN$
Median 10, 5 Yrs 2.10% 1.23% Div %  Ret. Price Inc 10.70% P/E:  13.15 13.85 5.56% <-IRR #YR-> 5 Price & Div CDN$
-$31.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $51.91
-$42.00 $0.00 $0.00 $0.00 $0.00 $51.91
-$31.45 $1.08 $1.07 $0.88 $0.96 $0.88 $0.89 $0.57 $0.77 $0.09 $52.33
-$42.00 $0.89 $0.57 $0.77 $0.09 $52.33
Pre-Split 2010 $44.00 $41.95 $63.47 $55.50 $80.05 $82.55 $71.98 $80.55 $80.43 $29.93 $50.58
Price Cl US$ $22.00 $20.98 $31.74 $27.75 $40.03 $41.28 $35.99 $40.28 $40.22 $14.97 $25.29 $52.00 $34.34 $34.34 147.91% <-Total Growth 10 Stock Price US$
Increase -35.3% -4.7% 51.3% -12.6% 44.2% 3.1% -12.8% 11.9% -0.1% -62.8% 69.0% 105.6% -34.0% 0.0% 9.50% <-IRR #YR-> 10 Stock Price US$
P/E 9.5 6.51 10.24 9.54 15.36 15.84 12.20 16.85 13.73 48.27 -11.47 12.44 7.73 7.47 7.64% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 18.2 9.02 9.86 8.95 13.75 15.84 13.82 13.65 16.83 5.11 81.58 -23.58 8.22 7.73 11.62% <-IRR #YR-> 10 Price & Div US$
Median 10, 5 Yrs 2.12% 1.24% Div %  Ret. Price Inc 11.91% P/E:  13.08 13.73 8.88% <-IRR #YR-> 5 Price & Div US$
-$20.98 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.00
-$35.99 $0.00 $0.00 $0.00 $0.00 $52.00
-$20.98 $0.68 $0.68 $0.68 $0.74 $0.76 $0.76 $0.58 $0.63 $0.09 $52.42
-$35.99 $0.76 $0.58 $0.63 $0.09 $52.42
Cdn Median H/L CDN$ $38.56 $33.45 $41.87 $50.00 $47.66 $52.23 $43.27 $42.80 $45.29 $27.97 $20.11 $40.00 19.57% <-Total Growth 10 Stock Price CDN$
Increase -20.9% -13.3% 25.2% 19.4% -4.7% 9.6% -17.1% -1.1% 5.8% -38.3% -28.1% 98.9% 1.80% <-IRR #YR-> 10 Stock Price CDN$
P/E 11.3 6.82 8.48 10.88 14.16 15.51 12.61 15.37 15.64 73.70 -8.68 9.60 -1.56% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 20.7 9.77 8.54 10.13 10.37 15.51 12.85 12.48 16.26 9.66 52.99 -17.27 3.99% <-IRR #YR-> 10 Price & Div CDN$
Median 10, 5 Yrs 2.19% 1.30% Div %  Ret. Price Inc -1.08% P/E:  13.38 15.37 -0.26% <-IRR #YR-> 5 Price & Div CDN$
-$33.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.00
-$43.27 $0.00 $0.00 $0.00 $0.00 $40.00
-$33.45 $1.08 $1.07 $0.88 $0.96 $0.88 $0.89 $0.57 $0.77 $0.09 $40.41
-$43.27 $0.89 $0.57 $0.77 $0.09 $40.41
Month Jun Jan Dec- May Jul Jan Jul Dec CDN$
Price Hi CDN$ $47.13 $38.20 $51.83 $60.25 $57.73 $57.48 $48.77 $46.66 $50.49 $40.54 $27.25 $52.20 36.65% <-Total Growth 10 Stock Price CDN$
Increase -14.9% -18.9% 35.7% 16.2% -4.2% -0.4% -15.1% -4.3% 8.2% -19.7% -32.8% 91.6% 3.17% <-IRR #YR-> 10 Stock Price CDN$
P/E 13.8 7.79 10.50 13.11 17.15 17.07 14.22 16.75 17.44 106.83 -11.77 12.53 1.37% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 25.3 11.15 10.57 12.20 12.56 17.07 14.49 13.60 18.13 14.00 71.82 -22.54
Median 10, 5 Yrs Price Inc -4.34% P/E:  15.48 16.75
-$38.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $52.20
-$48.77 $0.00 $0.00 $0.00 $0.00 $52.20
Pre-Split 2010 $64.94 $52.88 $68.30 $77.38 $81.60 $85.17 $79.05 $82.83 $96.89 $81.46 $50.96
Price Hi US$ $32.47 $26.44 $34.15 $38.69 $40.80 $42.59 $39.53 $41.42 $48.45 $40.73 $25.48 $52.14 97.20% <-Total Growth 10 Stock Price US$
Month Oct Apr Aug Dec Nov Mar Jan CDN$
Pre-Split 2010 $60.00 $57.40 $63.80 $79.50 $75.20 $93.95 $75.54 $77.90 $80.18 $30.79 $25.93
Price Low CDN$ $30.00 $28.70 $31.90 $39.75 $37.60 $46.98 $37.77 $38.95 $40.09 $15.40 $12.97 $27.79 -3.17% <-Total Growth 10 Stock Price CDN$
Increase -28.9% -4.3% 11.1% 24.6% -5.4% 24.9% -19.6% 3.1% 2.9% -61.6% -15.8% 114.3% -0.32% <-IRR #YR-> 10 Stock Price CDN$
P/E 8.8 5.85 6.46 8.65 11.17 13.95 11.01 13.99 13.85 40.57 -5.60 6.67 -5.95% <-IRR #YR-> 5 Stock Price CDN$
Trailing P/E 16.1 8.38 6.51 8.05 8.18 13.95 11.22 11.35 14.40 5.32 34.17 -12.00
Median 10, 5 Yrs Price Inc 2.93% P/E:  11.09 13.85
-$28.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $27.79
-$37.77 $0.00 $0.00 $0.00 $0.00 $27.79
Price Low US$ $20.03 $18.91 $21.50 $24.80 $22.46 $43.39 $30.27 $35.08 $35.76 $11.75 $10.00 $26.64 40.88% <-Total Growth 10 Stock Price US$
Market Cap $4,948 $4,942 $8,426 $8,291 $10,030 $9,556 $9,179 $10,218 $9,307 $4,138 $6,000 $12,592 $8,382 $8,382 154.80% <-Total Growth 10 Market Cap CDN$
Pre-Split 2010 78.536 78.565 83.342 95.574 96.407 96.944 109.278 109.880 116.071 112.606 112.660
# of Shares 157.073 157.130 166.685 191.147 192.814 193.889 218.557 219.761 232.142 225.212 225.320 242.565 242.052 242.052 Capital Stock Shares 
Increase 0.2% 0.0% 6.1% 14.7% 0.9% 0.6% 12.7% 0.6% 5.6% -3.0% 0.0% 7.7% -0.2% 0.0% 3.25% <-Median-> 10 Shares 
OCF US $750.0 $655.0 $1,029.0 $1,460.0 $1,216.0 $1,381 $1,698 $1,596 $1,593 $1,054 $527 $1,872 $1,602 $1,762 185.80% <-Total Growth 10 Cash Flow US$
OPS US$ $4.77 $4.17 $6.17 $7.64 $6.31 $7.12 $7.77 $7.26 $6.86 $4.68 $2.34 $7.72 $6.62 $7.28 85.14% <-Total Growth 10 Cash Flow US$
OCF CDN$ $1,105.0 $997.2 $1,638.8 $2,306.2 $1,571.6 $1,785 $1,975 $1,860 $1,574 $1,290 $553 $1,866 $1,598 $1,757 87.17% <-Total Growth 10 Cash Flow CDN$
OPS CDN$ $7.03 $6.35 $9.83 $12.07 $8.15 $9.21 $9.04 $8.46 $6.78 $5.73 $2.46 $7.69 $6.60 $7.26 21.25% <-Total Growth 10 Cash Flow CDN$
Increase 73.50% -9.79% 54.92% 22.72% -32.44% 12.94% -1.84% -6.35% -19.87% -15.52% -57.12% 213.28% -14.22% 9.97% -4.09% <-Median-> 10 Cash Flow CDN$
Non-Cash CF US$ $0.0 $336.0 $10.0 $249.0 $72.0 $100.0 -$158.0 -$157.0 $94.0 $275.0 $94.0 -$177.0 $0.0 $0.0 1.95% <-IRR #YR-> 10 Cash Flow CDN$
Non-Cash CF CDN$ $0.0 $511.5 $15.9 $393.3 $93.1 $129.2 -$183.8 -$182.9 $92.9 $336.6 $98.7 -$176.5 $0.0 $0.0 -3.16% <-IRR #YR-> 5 Cash Flow CDN$
OPS non-cash $7.03 $9.60 $9.93 $14.12 $8.63 $9.87 $8.19 $7.63 $7.18 $7.22 $2.89 $6.97 $6.60 $7.26 -3.16% <-IRR #YR-> 10 Cash Flow CDN$
P/O on Cl 4.48 3.28 5.09 3.07 6.03 4.99 5.13 6.09 5.58 2.54 9.20 7.45 5.25 4.77 -3.19% <-IRR #YR-> 5 Cash Flow CDN$
*Operational Cash Flow per share (Class A & B) P/CF 10 yr 5.35 5 yr  6.09
OPM 7.9% 6.2% 9.8% 11.3% 7.9% 6.7% 7.4% 6.6% 6.1% 4.4% 3.0% 7.8% should be zero, it is a check on calculations CDN$
Diff from Ave 12.4% -11.8% 38.6% 59.3% 12.2% -5.4% 5.4% -6.6% -13.5% -37.1% -57.1% 9.9% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 7.07% 5 Yrs 6.11% CDN$
Curr Assets CDN $4,323 $4,776 $5,666 $6,901 $6,941 $8,118 $7,679 $8,245 $8,666 $8,998 $6,619 $7,791 $8,820 Liq ratio of 1.5 and up, best Assets CDN$
Curr Liab. CDN $3,346 $3,171 $3,575 $4,638 $4,439 $5,289 $5,103 $5,573 $5,591 $6,234 $4,514 $5,184 $5,697 1.50 <-Median-> 10 Liabilities CDN$
Liquidity CDN 1.29 1.51 1.58 1.49 1.56 1.53 1.50 1.48 1.55 1.44 1.47 1.50 1.55 1.48 <-Median-> 5 Ratio CDN$
Assets CDN $10,605 $11,278 $12,583 $16,020 $12,686 $15,011 $14,329 $15,327 $15,160 $16,143 $12,920 $13,856 $15,230 A/L ratio of 1.5 and up, best Assets CDN$
Liab.CDN $9,696 $4,881 $5,445 $7,457 $6,315 $8,116 $6,694 $6,988 $6,621 $7,131 $5,191 $5,742 $6,457 2.23 <-Median-> 10 Liabilities CDN$
Liquidity CDN 1.09 2.31 2.31 2.15 2.01 1.85 2.14 2.19 2.29 2.26 2.49 2.41 2.36 2.29 <-Median-> 5 Ratio CDN$
Minority Int US$ $74 $15
Minority Int CDN$ $74 $15
Book Value US $4,024 $4,202 $4,482 $5,421 $4,930 $5,335 $6,565 $7,157 $8,642 $7,363 $7,360 $8,065 $8,785 91.93% <-Total Growth 10 Book Value US$
BV per share US$ $25.62 $26.74 $26.89 $28.36 $25.57 $27.52 $30.04 $32.57 $37.23 $32.69 $32.66 $33.25 $36.29 24.33% <-Total Growth 10 Book Value US$
CDN$ Check $5,929 $6,397 $7,138 $8,563 $6,372 $6,895 $7,635 $8,339 $8,539 $9,012 $7,729 $8,041 $8,759
Book Value CDN $5,929 $6,397 $7,138 $8,563 $6,372 $6,895 $7,635 $8,339 $8,539 $9,012 $7,729 $8,041 $8,759 25.69% <-Total Growth 10 Book Value CDN$
BV per share $37.74 $40.71 $42.82 $44.80 $33.04 $35.56 $34.93 $37.95 $36.78 $40.02 $34.30 $33.15 $36.19 $36.19 -18.58% <-Total Growth 10 Book Value CDN$
Change 18.70% 7.86% 5.19% 4.61% -26.24% 7.62% -1.76% 8.63% -3.07% 8.79% -14.28% -3.36% 9.16% 0.8033 Current/Historical Book Value CDN$
P/BV (CL) 0.83 0.77 1.18 0.97 1.57 1.39 1.20 1.23 1.09 0.46 0.78 1.57 0.96 -2.03% <-IRR #YR-> 10 Book Value CDN$
Change -44.54% -7.44% 52.81% -17.98% 62.59% -11.96% -13.25% 1.91% -11.05% -57.87% 69.07% 101.71% -38.89% -1.04% <-IRR #YR-> 5 Book Value CDN$
Leverage (A/BK) 1.79 1.76 1.76 1.87 1.99 2.18 1.88 1.84 1.78 1.79 1.67 1.72 1.74 1.81 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 1.64 0.76 0.76 0.87 0.99 1.18 0.88 0.84 0.78 0.79 0.67 0.71 0.74 0.81 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.19 5 yr Med 1.09
ROE 7.4% 10.1% 13.9% -12.8% 0.2% 13.0% 10.07% <-Median-> 5 Compreh. Inc US$
Comprehensive Inc $488 $721 $1,202 -$945 $14 $1,052 Compreh. Inc US$
ROE 7.4% 10.1% 13.9% -12.8% 0.2% 13.0% 10.07% <-Median-> 5 Compreh. Inc CDN$
Comprehensive Inc $568 $840 $1,188 -$1,157 $15 $1,049 Compreh. Inc CDN$
ROE 10.7% 14.2% 12.9% 10.2% 10.6% 13.0% 9.7% 7.4% 7.7% 1.0% -6.7% 24.1% 21.0% <------ Net Income/Shareholders' equity CDN$
5Yr Median 11.6% 12.4% 12.9% 11.8% 10.7% 12.9% 10.6% 10.2% 9.7% 7.7% 7.4% 7.4% 7.7% CDN$
Net Income US$ $430 $596 $579 $554 $522 $692 $639 $528 $663 $71 -$493 $973 $922 <-12 mths 63.26% <-Total Growth 10 Net Income US$
Oper C. F. $750 $655 $1,029 $1,460 $1,216 $1,381 $1,698 $1,596 $1,593 $1,054 $527 $1,872 C F Statement  Oper C. F. US$
Invest. C. F -$950 -$403 -$506 -$1,179 -$1,002 -$1,274 -$1,051 -$1,111 -$868 -$1,063 -$876 -$744 C F Statement  Invest. C. F US$
Total Accruals $630 $344 $56 $273 $308 $585 -$8 $43 -$62 $80 -$144 -$155 Accruals
Total Assets $7,198 $7,408 $7,901 $10,142 $9,816 $11,615 $12,321 $13,154 $15,343 $13,189 $12,303 $13,898 Balance Sheet Assets US$
Accruals Ratio 8.75% 4.64% 0.71% 2.69% 3.14% 5.04% -0.06% 0.33% -0.40% 0.61% -1.17% -1.12% Ratio US$
Net Income $634 $907 $922 $875 $675 $894 $743 $615 $655 $87 -$518 $970 $919 6.91% <-Total Growth 10 Net Income CDN$
Oper C. F. $1,105 $997 $1,639 $2,306 $1,572 $1,785 $1,975 $1,860 $1,574 $1,290 $553 $1,866 C F Statement  Oper C. F. CDN$
Invest. C. F -$1,400 -$614 -$806 -$1,862 -$1,295 -$1,647 -$1,222 -$1,295 -$858 -$1,301 -$920 -$742 C F Statement  Invest. C. F CDN$
Total Accruals $928 $524 $89 $431 $398 $756 -$9 $50 -$61 $98 -$151 -$155 Accruals
Total Assets $10,605 $11,278 $12,583 $16,020 $12,686 $15,011 $14,329 $15,327 $15,160 $16,143 $12,920 $13,856 Balance Sheet Assets CDN$
Accruals Ratio 8.75% 4.64% 0.71% 2.69% 3.14% 5.04% -0.06% 0.33% -0.40% 0.61% -1.17% -1.12% <------- Ratio CDN$
Fin. C. F US$ -$230 -$426 -$386 $44 $89 -$1,164 -$355 C F Statement  Fin. C. F US$
Total Accruals $815 $418 $429 -$106 -$9 $1,020 $200 Accruals US$
Accruals Ratio 7.02% 3.39% 3.26% -0.69% -0.07% 8.29% 1.44% Ratio US$
Fin. C. F CDN -$297 -$495 -$450 $43 $109 -$1,222 -$354 C F Statement  Fin. C. F CDN$
Total Accruals $1,053 $486 $500 -$105 -$11 $1,071 $199 Accruals CDN$
Accruals Ratio 7.02% 3.39% 3.26% -0.69% -0.07% 8.29% 1.44% <------- Ratio CDN$
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.
My 2009 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
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.
Copyright © 2008 Website of SPBrunner. All rights reserved.
$31,000,000 895,178
Walker, Donald James, CEO  $10,233,165 295,500
Galifi, Vincent Joseph, CFO $3,945,534 113,934
182.357
6.614 3.50%
188.971