2. Once calculated compare them to the Retail Sector and SP 500 averages provided in Excel with the Ch.2 Ratio Analysis lectures. Highlight any ratios in green where TOT is significantly better than both the SP500 and Retail Sector and highlight in red any ratios where TGT is significantly worse. No written descriptions required. 3. REMOVED 4. You have the following information about a company: Market to Book Ratio - 3 Debt to Equity (Book) Ratio - 2, Share Price $60, Shares outstanding - 200 million, Cash - $800 million. Calculate the Enterprise Value of this company 5. You have the following information on ABC Ine, and XYZ Co. Profit Margin Asset Turnover Equity Multiplier ABC 4% 2 1.5 XYZ 6% 0.8 3 a) Calculate both companies' return on equity b) Calculate the Profit Margin would ABC need to cam to have a return on equity equal to XYZ's Ch. 2 Practice Exercise 1. Using Reuters.com, copy and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tie: TOT) into a new Excel Workbook. Then we Excel to calculate the following ratios: Operating Profitability Liquidity Efficiency and Working Leverage Ratios Returns Ratios Ratios Capital Ratios Book Debt-to-Equity Ratio Accounts Receivable Current Ratio Days Return on Equity Gross Margin Operating Return on Assets Margin Equity Multiplier Fixed Asset Turnover Quick Ratio Net Profit Margin Cash Ratio Total Asset Turnover Interest Coverage Ratios Inventory Turnover Valuation Ratios EBIT/Interest Coverage Market-to-Book Price-to Earnings 2. Once calculated compare them to the Retail Sector and SP 500 averages provided in Excel with the Ch.2 Ratio Analysis lectures. Highlight any ratios in green where TOT is significantly better than both the SP500 and Retail Sector and highlight in red any ratios where TGT is significantly worse. No written descriptions required. 3. REMOVED 4. You have the following information about a company: Market to Book Ratio - 3 Debt to Equity (Book) Ratio - 2, Share Price $60, Shares outstanding - 200 million, Cash - $800 million. Calculate the Enterprise Value of this company 5. You have the following information on ABC Ine, and XYZ Co. Profit Margin Asset Turnover Equity Multiplier ABC 4% 2 1.5 XYZ 6% 0.8 3 a) Calculate both companies' return on equity b) Calculate the Profit Margin would ABC need to cam to have a return on equity equal to XYZ's Ch. 2 Practice Exercise 1. Using Reuters.com, copy and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tie: TOT) into a new Excel Workbook. Then we Excel to calculate the following ratios: Operating Profitability Liquidity Efficiency and Working Leverage Ratios Returns Ratios Ratios Capital Ratios Book Debt-to-Equity Ratio Accounts Receivable Current Ratio Days Return on Equity Gross Margin Operating Return on Assets Margin Equity Multiplier Fixed Asset Turnover Quick Ratio Net Profit Margin Cash Ratio Total Asset Turnover Interest Coverage Ratios Inventory Turnover Valuation Ratios EBIT/Interest Coverage Market-to-Book Price-to Earnings
