I need help with 7, 8,9 # Financial Data Analysis: Target Corporation vs. Wal-Mart Stores, Inc. (2022)## Income Statement Data for Year (in millions)### Target Corporation- **Net Sales:** $66,100- **Cost of Goods Sold:** $44,000- **Selling and Administrative Expenses:** $15,400- **Interest Expense:** $660- **Other Income (Expense):** $(70)- **Income Tax Expense:** $1,400- **Net Income:** $4,570### Wal-Mart Stores, Inc.- **Net Sales:** $411,000- **Cost of Goods Sold:** $302,000- **Selling and Administrative Expenses:** $81,000- **Interest Expense:** $2,100- **Other Income (Expense):** $(420)- **Income Tax Expense:** $7,300- **Net Income:** $18,180## Balance Sheet Data (End of Year)### Target Corporation- **Current Assets:** $17,000- **Noncurrent Assets:** $26,800- **Total Assets:** $43,800- **Current Liabilities:** $12,000- **Long-Term Debt:** $17,600- **Total Stockholders' Equity:** $14,200- **Total Liabilities and Stockholders’ Equity:** $43,800### Wal-Mart Stores, Inc.- **Current Assets:** $49,000- **Noncurrent Assets:** $120,000- **Total Assets:** $169,000- **Current Liabilities:** $54,000- **Long-Term Debt:** $45,000- **Total Stockholders' Equity:** $70,000- **Total Liabilities and Stockholders’ Equity:** $169,000## Beginning-of-Year Balances### Target Corporation- **Total Assets:** $43,000- **Total Stockholders' Equity:** $14,400- **Current Liabilities:** $10,600- **Total Liabilities:** $28,600### Wal-Mart Stores, Inc.- **Total Assets:** $162,000- **Total Stockholders' Equity:** $66,000- **Current Liabilities:** $57,000- **Total Liabilities:** $96,000---## Analysis and Insights### Income Statement Analysis- **Net Sales Comparison:** Wal ### Financial Ratios for Target and Wal-MartBelow is the financial data for Target and Wal-Mart, which will be used to compute various financial ratios:#### Other Data| | Target | Wal-Mart ||---|---|---|| Average net accounts receivable | $7,900 | $4,200 || Average inventory | 7,200 | 33,700 || Net cash provided by operating activities | 5,800 | 26,200 || Capital expenditures | 1,700 | 12,400 || Dividends | 460 | 3,600 |**Instructions:** For each company, compute the following ratios. *Round current ratio answers to 2 decimal places (e.g., 15.50). Round debt to assets ratio and free cash flow answers to 0 decimal places (e.g., 5,275) and all answers to 1 decimal place (e.g., 1.8 or 1.83%).*#### Ratios to Compute| Ratio | Target | Wal-Mart ||---|---|---|| (1) Current ratio | | :1 | | :1 || (2) Accounts receivable turnover | | times | | times || (3) Average collection period | | days | | days || (4) Inventory turnover | | times | | times || (5) Days in inventory | | days | | days || (6) Profit margin | | % | | % || (7) Asset turnover | | times | | times || (8) Return on assets | | % | | % || (9) Return on common stockholders' equity | | % | | % || (10) Debt to assets ratio | | % | | % || (11) Times interest earned | | times | | times || (12) Free cash flow | $ | $ | $ | $ |The financial ratios above provide a snapshot of each company's financial health, efficiency, and profitability, which are essential for making informed business decisions and comparative analysis.**Graphs or Diagrams:**No graphs or diagrams are present in the image; however, the table is set up for easy calculation and comparison of financial ratios. Each row represents a different ratio, with columns for Target and Wal-Mart to

The details of two companies are given. Required 7. Asset Turnover Ratio 8. Return on Assets…

Other Data Average net accounts receivable $7,900 $4,200 Average inventory 7,200 33,700 Net cash provided by operating activities 5,800 26,200 Capital expenditures 1,700 12,400 Dividends 460 3,600 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to O decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.) Ratio Target Wal-Mart (1) Current ratio :1 :1 (2) Accounts receivable turnover times times (3) Average collection period days days (4) Inventory turnover times times (5) Days in inventory days days (6) Profit margin % (7) Asset turnover times times (8) Return on assets % % Return on common stockholders' (9) % equity (10) Debt to assets ratio (11) Times interest earned times times (12) Free cash flow $ $