Part-B: Using data from Yahoo finance for Walmart and Macys, calculate following for each and provide your analysis. Present the data in a table. Use excel to create the table and cut paste the table in the word document. First column is list of ratios, second column is ratios for Walmart and third column is ratios for Macys and last column (wide column) with your comments. (50% of the grade) Walmart Macy's Comments 1 Current ratio 2 Quick ratio 3. Debt ratio 4. Times interest earned 5. Inventory tums 6 Accounts receivable turns 7. Accounts payable tums & Total asset turnover 9. Profit margin ratio 10. Return on Equity 11. Return on Assets 12. On the website find: a. Earnings per share b. Price to eamings ratios Price/earnings to growth ratio d. Market to book value Part-B: Using data from Yahoo finance for Walmart and Macys, calculate following for each and provide your analysis. Present the data in a table. Use excel to create the table and cut paste the table in the word document. First column is list of ratios, second column is ratios for Walmart and third column is ratios for Macys and last column (wide column) with your comments. (50% of the grade) Walmart Macy's Comments 1 Current ratio 2 Quick ratio 3. Debt ratio 4. Times interest earned 5. Inventory tums 6 Accounts receivable turns 7. Accounts payable tums & Total asset turnover 9. Profit margin ratio 10. Return on Equity 11. Return on Assets 12. On the website find: a. Earnings per share b. Price to eamings ratios Price/earnings to growth ratio d. Market to book value