Assignment #3 Refer to Part B. "Using Ratios to Assess Risk and Profitability" in Chapter 12 for guidance on this section of your project. You will be calculating certain performance ratios for Walmart for 2020 and comparing them to 2 competitors. You will need to use online resources to find the ratio results for the 2 competitors (you may choose the competitors). Liquidity Ratios: Solvency Ratios: Profitability Ratios: Debt to Total Equity Ratio Current Ratio Inventory Turnover Ratio Average Days in Inventory Gross Profit Ratio Return on Assets Ratio Price-Earnings Ratio 1. Using Chapter 12 in your textbook, explain the usefulness of each ratio. 2. Please calculate the ratios above for Walmart on a separate tab in your Excel workbook. Name this tab "Ratio Analysis." (Your excel workbook should now contain 5 tabs total). Also include the results of the 2 competitors on this tab. 3. Using the results of Walmart and the 2 competitors, create a bar graph for each type of ratio comparing the 3 companies. 4. Evaluate how Walmart compares with the 2 other competitors. To receive full credit for this assignment, you need to include cell references from the balance sheet and income statement, formulas for your calculations, and have a professional appearance. Assignment #3 Refer to Part B. "Using Ratios to Assess Risk and Profitability" in Chapter 12 for guidance on this section of your project. You will be calculating certain performance ratios for Walmart for 2020 and comparing them to 2 competitors. You will need to use online resources to find the ratio results for the 2 competitors (you may choose the competitors). Liquidity Ratios: Solvency Ratios: Profitability Ratios: Debt to Total Equity Ratio Current Ratio Inventory Turnover Ratio Average Days in Inventory Gross Profit Ratio Return on Assets Ratio Price-Earnings Ratio 1. Using Chapter 12 in your textbook, explain the usefulness of each ratio. 2. Please calculate the ratios above for Walmart on a separate tab in your Excel workbook. Name this tab "Ratio Analysis." (Your excel workbook should now contain 5 tabs total). Also include the results of the 2 competitors on this tab. 3. Using the results of Walmart and the 2 competitors, create a bar graph for each type of ratio comparing the 3 companies. 4. Evaluate how Walmart compares with the 2 other competitors. To receive full credit for this assignment, you need to include cell references from the balance sheet and income statement, formulas for your calculations, and have a professional appearance
