We are using the percentage of sales approach to calculate EFN for Magna International Inc.
The Income Statement: We start with the most recent Income Statement for year 2011 to forecast for year 2012. Magna has projected an increase in sales of 10% for the coming year, so we are anticipating a sales of $31,622.80 in 2012 (see Appendix 1 & Appendix 3). To generate a Pro Forma Income Statement we assume that costs and expenses continue to run at the same percentage of sales as they were in year 2011 (See Appendix 1 & Appendix 3). To check this, notice that our % of Sales in 2011 and 2012 are same; so it is unchanged. We exclude (from 2012 Forecast) Interest Expense, Equity income because they are non-operating loss/income and also Other Expense and Net loss attributable to non-controlling interests because they are Special Items.
Next, we need to project the dividend payment. Magna International has continuously been increasing their dividends. As per Management’s message to Shareholders (see Appendix 6), Magna increased its dividend’s by 39% in 2011 are planning to increase dividends by another 10% in 2012.
Dividend Payout Ratio (2012) = Cash dividend (See Appendix 5) = 236+ (10%*236)/ Net Income 1143.11 (from Appendix 1) = 22.71%
Retention Ratio (2012) = 1 – Dividend Payout Ratio = 1-0.2271 = 0.7729 = 77.29 %
Projected addition to RE = 1143.11*0.7729 = $ 883.51
Projected dividends paid to shareholders = 1143.11*0.2271 = $259.60
The Balance Sheet: To generate a Pro Forma Balance Sheet, we start by calculating the % of sales (2011) the items that are directly related to sales. Long Term Liabilities and Shareholders’ Equity do not vary with sales, thus they have been marked as “n/a” in the % of sales column (See Appendix 2). We have assumed that the ratio remains constant for all the marked items. An example for illustration is given below:
Capital Intensity Ratio 2011: Total assets 14,679 / 28,748=0.51 (See Appendix 4, Appendix...