Please fill out the table using the information provided. (Show mathematical formulas please) 1 Earning per Share

Please fill out the table using the information provided. (Show mathematical formulas please)

Transcribed Image Text:

1 Earning per Share 2 Dividends per Share 3 Return on Assets 4 Return on Equity (book) 5 Interest Coverage Ratio (EBIT/Interest Expense) 6 Quick Ratio 7 Debt-Ratio () Stock Price Analysis 8 Price per Share given current P-E 9 Break-Even P-E at current Stock Price 10 Dividend Yield at current Stock Price 11 Implied Stock Price at current Dividend Yield 12 Total Cash flows payed out to Equity Holders 13 Total Cash flows payed out to Debt Holders 14 Total Cash flows in Tax Expense $ $ $ $ $ $ $ Actual 2011 0% $ $ $ 2.88 0.85 10% 0% - Any formulas and additional work should be included in the shared are on the right. -(1)-> Debt-Ratio = Debt / (Accounts Receivable + Inventory + PP&E + Cash) - Quick Ratio = Current Assets - Inventory / Current Liabilities - Tax Rate = 35.5% 0% 33.88 $ $ $ $ $ $ $ 20% $ $ $ 0% 0% 0% Pro-forma 2011 40% $ $ $ $ $ $ $ - $ $ $ 0% 0% 0% $ $ $ $ 15 Number of Shares Outstanding 16 Market Capitalization 17 Debt 18 Value of Invested Capital Instructions on how to use this template: -Actual 2011 Colum corresponds to 0% debt, and should be populated using the data provided in case exhibit 1 -20%, 40% and 60% columns correspond to the hypothetical capital structures and are not meant as a forecast but rather a restatement of the last fiscal year under different debt-to-value scenarios. Some of the data is already provided and should be populated from case exhibit 5 but others must be calculated assuming 2011 year end is restated. $ $ $ 60% $ $ $ 0% 0% 0% 1 Earning per Share 2 Dividends per Share 3 Return on Assets 4 Return on Equity (book) 5 Interest Coverage Ratio (EBIT/Interest Expense) 6 Quick Ratio 7 Debt-Ratio () Stock Price Analysis 8 Price per Share given current P-E 9 Break-Even P-E at current Stock Price 10 Dividend Yield at current Stock Price 11 Implied Stock Price at current Dividend Yield 12 Total Cash flows payed out to Equity Holders 13 Total Cash flows payed out to Debt Holders 14 Total Cash flows in Tax Expense $ $ $ $ $ $ $ Actual 2011 0% $ $ $ 2.88 0.85 10% 0% - Any formulas and additional work should be included in the shared are on the right. -(1)-> Debt-Ratio = Debt / (Accounts Receivable + Inventory + PP&E + Cash) - Quick Ratio = Current Assets - Inventory / Current Liabilities - Tax Rate = 35.5% 0% 33.88 $ $ $ $ $ $ $ 20% $ $ $ 0% 0% 0% Pro-forma 2011 40% $ $ $ $ $ $ $ - $ $ $ 0% 0% 0% $ $ $ $ 15 Number of Shares Outstanding 16 Market Capitalization 17 Debt 18 Value of Invested Capital Instructions on how to use this template: -Actual 2011 Colum corresponds to 0% debt, and should be populated using the data provided in case exhibit 1 -20%, 40% and 60% columns correspond to the hypothetical capital structures and are not meant as a forecast but rather a restatement of the last fiscal year under different debt-to-value scenarios. Some of the data is already provided and should be populated from case exhibit 5 but others must be calculated assuming 2011 year end is restated. $ $ $ 60% $ $ $ 0% 0% 0%