2. Once calculated compare them to the Real Sector and SP 500 averages provided in Excel with the Ch 2 Ratio Analysis lectures Highlight any ratios in green where TGT 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 560 Shares outstanding 200 million, Cash = $800 million Calculate the Enterprise Value of this company 5. You have the followme mformation on ABC Inc. and XYZ Co. Profit M 19 ABC XYZ Asset Turnover Equity Multiplier 2 15 OS 3 a) Calculate both compasmo quy b) Calculate the Profi Marga would ABC need to cars to have a return on y equal to XYZ Ch. 2 Practice Exercise 1. Using Reuters.com, copy and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tic: TGT) into a new Excel Workbook. Then use Excel to calculate the following ratios Operating Returns Profitability Ratios Liquidity Ratios Efficiency and Working Capital Ratios Leverage Ratios Book Debt-to-Equity Ratio Return on Equity Gross Margin Accounts Receivable Current Ratio Days Equity Multiplier Operating Return on Assets Margin Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover interest Coverage Rati Valuation Ration Inventory Turnover Enterest Coverage Market to Book Price to Earnings Show Ch. 2 Practice Exercise 1. Uning Reuters.com, copy and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tie:TOT) into a new Excel Workbook. Then use Excel to calculate the following ratios Operating Profitability Liquidity Efficiency and Working Leverage Ratios Returns Ratios Ratios Capital Ratios Book Debt-to-Equity Accounts Receivable Ratio Return on Equity Gross Margin Current Ratio Days Equity Multiplier Operating Return on Assets Margin Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover Interest Coverage Ratios Valuation Ratios Inventory Turnover EBIT/Interest Coverage Market to Book Price-to-Earning 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 preen 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 560, Shares outstanding 200 million, Cash-$800 million Calculate the Enterprise Value of this company 5. You have the following information on ABC Inc. and XYZ Co. Profil Mar ABC 496 Asset Turnover Equity Multiplier 2 1.5 0.8 3 XYZ a) Calculate both companies return on equity b) Calculate the Profit Margin would ABC need to earn 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 (Ti- following ratios: Operating Returns Profitability Ratios Liquidity Ratios Efficiency and Working Capital Ratios Leverage Ratios Book Debt-to-Equity Ratio Accounts Receivable Current Ratio Days Return on Equity Gross Margin Operating Return on Assets Margin Equity Multiplier Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover Interest Coverage Ratios Valuation Ratios Inventory Turnover EBIT/Interest Coverage Market-to-Book Price-to- Earnings 12328/fullscreen/22641801/View Ch. 2 - Practice Exercise and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tic: TGT) into a new Excel Workbook. Then use Excel to calculate the ating ins Profitability Ratios Liquidity Ratios Efficiency and Working Capital Ratios rn on Equity Gross Margin Accounts Receivable Days Current Ratio Operating rn on Assets Margin Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover ution Ratios Inventory Turnover cet-to-Book -to- ngs o 00 C BI 4141 8/27/2 2. Once calculated compare them to the Real Sector and SP 500 averages provided in Excel with the Ch 2 Ratio Analysis lectures Highlight any ratios in green where TGT 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 560 Shares outstanding 200 million, Cash = $800 million Calculate the Enterprise Value of this company 5. You have the followme mformation on ABC Inc. and XYZ Co. Profit M 19 ABC XYZ Asset Turnover Equity Multiplier 2 15 OS 3 a) Calculate both compasmo quy b) Calculate the Profi Marga would ABC need to cars to have a return on y equal to XYZ Ch. 2 Practice Exercise 1. Using Reuters.com, copy and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tic: TGT) into a new Excel Workbook. Then use Excel to calculate the following ratios Operating Returns Profitability Ratios Liquidity Ratios Efficiency and Working Capital Ratios Leverage Ratios Book Debt-to-Equity Ratio Return on Equity Gross Margin Accounts Receivable Current Ratio Days Equity Multiplier Operating Return on Assets Margin Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover interest Coverage Rati Valuation Ration Inventory Turnover Enterest Coverage Market to Book Price to Earnings Show Ch. 2 Practice Exercise 1. Uning Reuters.com, copy and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tie:TOT) into a new Excel Workbook. Then use Excel to calculate the following ratios Operating Profitability Liquidity Efficiency and Working Leverage Ratios Returns Ratios Ratios Capital Ratios Book Debt-to-Equity Accounts Receivable Ratio Return on Equity Gross Margin Current Ratio Days Equity Multiplier Operating Return on Assets Margin Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover Interest Coverage Ratios Valuation Ratios Inventory Turnover EBIT/Interest Coverage Market to Book Price-to-Earning 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 preen 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 560, Shares outstanding 200 million, Cash-$800 million Calculate the Enterprise Value of this company 5. You have the following information on ABC Inc. and XYZ Co. Profil Mar ABC 496 Asset Turnover Equity Multiplier 2 1.5 0.8 3 XYZ a) Calculate both companies return on equity b) Calculate the Profit Margin would ABC need to earn 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 (Ti- following ratios: Operating Returns Profitability Ratios Liquidity Ratios Efficiency and Working Capital Ratios Leverage Ratios Book Debt-to-Equity Ratio Accounts Receivable Current Ratio Days Return on Equity Gross Margin Operating Return on Assets Margin Equity Multiplier Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover Interest Coverage Ratios Valuation Ratios Inventory Turnover EBIT/Interest Coverage Market-to-Book Price-to- Earnings 12328/fullscreen/22641801/View Ch. 2 - Practice Exercise and paste the 1/31/2020 Income Statement and Balance Sheet for Target (Tic: TGT) into a new Excel Workbook. Then use Excel to calculate the ating ins Profitability Ratios Liquidity Ratios Efficiency and Working Capital Ratios rn on Equity Gross Margin Accounts Receivable Days Current Ratio Operating rn on Assets Margin Quick Ratio Fixed Asset Turnover Net Profit Margin Cash Ratio Total Asset Turnover ution Ratios Inventory Turnover cet-to-Book -to- ngs o 00 C BI 4141 8/27/2