no need for this, its done

8 II View Policies Current Attempt in Progress Selected financial data of two competitors. Target and WalMart, are presented here. (All dollars are in millions.) Suppose the data were taken from the 2022 financial statements of each company Net sales Cost of goods sold Selling and administrative expenses Teterest expense Other income Income taxes Net Income Target Walmart (1/31/22) (1/31/22) Income Statement Data for Year $64.948 $401,244 44,157 306,153 16.389 76.651 894 2.103 28 4.213 1.322 7.145 52.214 $13.400 Current assets Noncurrent assess Total asets Current abilities Long term bites Total sockholders uit Tots and stockholders out Target Walmart Balance Sheet Data (End of Year) $17.480 $46.929 26.618 544106 $163.429 $10.522 555390 19 882 2372 65.283 344106 516342 For each component there andatos A (Round Current ratio to 2 decimal places, s. 15.25 and Debt to assets ratio to 1 decimal place, - 3.78.93 Enter negative amounts using either a negative sign preceding the number -45 or parentheseses (451) For each company.compute these values and ratios (All dollars are in millions.) (Round Current ratio to 2 decimal places, es. 15.25 am Debt to assets ratio to 1 decimal place, eg. 78.9%. Enter negative amounts using either a negative sign preceding the number eg.-45 or parentheses es (451) Target (a) Working capita Walmart (b) Current ratio :1 (c) Debt to assets radio 36 (d) Which company has better audity? Which company has better solvency e Textbook and Media View Policies Current Attempt in Progress Holding all other factors constant, indicate whether each of the following signals generally good or bad news about a company, Increase in the current ratio 16 Increase in the debt to assets ratio The Coca-Cola Company and PepsiCo, Inc. provide refreshments to every corner of the world. Selected data from hypothetical consolidated financial statements for The Coca-Cola Company and for PepsiCo, Inc. are presented here (in millions). Total current assets Total current liabilities Net sales Cost of goods sold Net income Average (net) accounts receivable for the year Average Inventories for the year Average total assets Average common stockholders' equity Average current liabilities Average total liabilities Total assets Total abilities Income taxes Interestedense Net cash provided by operating activities Capital expenditures Cash didende Coca-Cola $27.742.0 13.871 31.094 11.136.6 6.321 3.574 2.421 44745 22786 13.505 22110 48.821 20.505 2.190 505 8.335 2143 3.950 PepsiCo $14.250 8.906 45.158 21.216 5.283 4.804 2.720 38.071 14.706 8.922 23.616 39.998 23.999 2250 547 2278 2.892 Coroute the forowingloos toctor the comice (Round current ratio to 2 decimal place.286 25 and all other unswers to 1 decimal place 2. 15.1.) Question 3 of 4 -72 (a1) Compute the following liquidity ratios for the two competitors. (Round current ratio to 2 decimal places, eg. 6.25 and all other answers to 1 decimal place, eg. 15.1.) Coca-Cola Current ratio PepsiCo 1 (2) times times (3) Accounts receivable turnover Average collection period Inventory turnover Days in Inventory days days times (5) times days days Textbook and Media Using molt de attempts will impact you or 50% score reduction frattempt 2 Attempts: 0 of 3 used Submit Ans Question Part Score (61) Question Part Score Question 3 of 4 -/24 Coca-Cola Pepsico Current ratio :1 :1 times times days days (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5) Days in inventory times times days days e Textbook and Media Attempts: 0 of 3 used Submit An Using multiple attempts will impact your score 50% score reduction after attempt 2 Question Part Score -10 (61) The parts of this sonst be completed in order this part wit be able when you complete the part above. Question Part Score Question Part 5 View Policies Current Attempt in Progress HandiMart, a retail store, has an accounts receivable turnover of 4 times. The Industry average is 125 times. Does Handi Mart have a collection problem with its receivables? Hands Mart a problem Textbook and Media