a. Calculate the following ratios for both Target and Walmart for 2022 and 2021: The financial statements are provided on the "Walmart Financials" and "Target Financials" tabs Liquidity: 1. Current ratio Current assets divided by current liabilities 2. Quick ratio (Cash + marketable securities + accounts receivable) / current liabilities If the company has marketable securities, they would be listed in the current asset section right below cash) 5. Gross margin Gross profit = sales minus cost of sales Gross margin = gross profit divided by sales Debt 6. Debtratio Total debt (liabilities) divided by total assets 7. Debt to equity ratio Total debt (liabilities) divided by total equity b. Comment on which company has better liquidity, better profitability, and less debt. c. Comment on whether each company has improved or worsened its liquidity, profitability, and debt. Instructions Answer | Walmart Financials Instructions: fill out this answer sheet and upload either the answer Valmart Balance Sheet As of January 31, Assets \begin{tabular}{|l|r|r|r|} \hline Current assets & & & \\ \hline Cash and cash equivalents & 14,760 & 17,741 & 9,465 \\ \hline Receivables, net & 8,280 & 6,516 & 6,284 \\ \hline Inventories & 56,511 & 44,949 & 44,435 \\ \hline Prepaid expenses and other & 1,519 & 20,861 & 1,622 \\ \hline Total current assets & 81,070 & 90,067 & 61,806 \\ \hline \end{tabular} a. Calculate the following ratios for both Target and Walmart for 2022 and 2021: The financial statements are provided on the "Walmart Financials" and "Target Financials" tabs Liquidity: 1. Current ratio Current assets divided by current liabilities 2. Quick ratio (Cash + marketable securities + accounts receivable) / current liabilities If the company has marketable securities, they would be listed in the current asset section right below cash) 5. Gross margin Gross profit = sales minus cost of sales Gross margin = gross profit divided by sales Debt 6. Debtratio Total debt (liabilities) divided by total assets 7. Debt to equity ratio Total debt (liabilities) divided by total equity b. Comment on which company has better liquidity, better profitability, and less debt. c. Comment on whether each company has improved or worsened its liquidity, profitability, and debt. Instructions Answer | Walmart Financials Instructions: fill out this answer sheet and upload either the answer Valmart Balance Sheet As of January 31, Assets \begin{tabular}{|l|r|r|r|} \hline Current assets & & & \\ \hline Cash and cash equivalents & 14,760 & 17,741 & 9,465 \\ \hline Receivables, net & 8,280 & 6,516 & 6,284 \\ \hline Inventories & 56,511 & 44,949 & 44,435 \\ \hline Prepaid expenses and other & 1,519 & 20,861 & 1,622 \\ \hline Total current assets & 81,070 & 90,067 & 61,806 \\ \hline \end{tabular}