Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Corporation Walmart Inc. Income Statement Data for Year $66,750 $416,910 43,920 308,320 14,400 79,000 750 1,800 (95) (400) 1,500 6,600 $ 6,085 $ 20,790 Net income Current assets Balance Sheet Data (End of Year) $17,000 $44,800 26,800 120,000 $43,800 $164,800 Noncurrent assets Total assets $10,000 $56,000 Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 17,300 16,500 $43,800 44,000 64,800 $164,800 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $165,000 13,400 64,000 10,000 56,000 29,600 101,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,500 7,200 5,500 1,800 $3,900 32,800 25,900 12,400 4,400 450 (a) For each company, compute the following ratios. (Round current ratio to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 2.5%. Use 365 days in calculation.) Ratio Target Walmart (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 comparative statements of Carla Vista Co. are presented here. CARLA VISTA CO. Income Statements For the Years Ended December 31 2022 Net sales $1,898,790 Cost of goods sold 1,060,095 Gross profit 838,695 Selling and administrative expenses 503,400 Income from operations 335,295 Other expenses and losses Interest expense 23,100 Income before income taxes 312,195 Income tax expense 93,305 Net income $ 218,890 2021 $1,753,900 1,009,400 744,500 482,400 262,100 21,100 241,000 74,100 $ 166,900 CARLA VISTA CO. Balance Sheets December 31 2022 2021 Assets Current assets Cash $ 60.420 $ 64,200 50,000 74,000 121,200 127,100 382,720 662,000 106,200 116,600 337,000 533,300 Debt investments (short-term) Accounts receivable Inventory Total current assets Plant assets (net) Total assets Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Total current liabilities $1,044,720 $870,300 $ 163,400 44,600 208,000 233,000 441,000 $148,800 43,100 191,900 213,000 404,900 Bonds payable Total liabilities Stockholders' equity Common stock ($5 par) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 300,000 290,000 313,720 165,400 603.720 465,400 $870,300 $1,044,720 All sales were on account. Net cash provided by operating activities for 2022 was $239,940. Capital expenditures were $136,000, and cash dividends were $70,570. Compute the following ratios for 2022. (Round current ratio, earnings per share and asset turnover to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 2.5%. Use 365 days in calculation.) (a) Earnings per share $ (b) Return on common stockholders' equity % (c) Return on assets % (d) Current ratio :1 (e) Accounts receivable turnover times (f) Average collection period days (g) Inventory turnover times (h) Days in inventory days (i) Times interest earned times 5 Asset turnover times (k) Debt to assets ratio % (1) Free cash flow $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions