Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net sales Cost of goods sold Selling and administrative
Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Corporation Walmart, Inc. Income Statement Data for Year $66,800 46,000 14,400 680 (90) 1,400 $4,230 $413,000 308,000 77,000 1,800 (380) 6,900 $18,920 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Total liabilities Balance Sheet Data (End of Year) $18,000 27,500 $45,500 $11,000 16,800 17,700 $45,500 $43,000 13,500 10,500 $47,000 29,500 121,000 $168,000 $54,000 Beginning-of-Year Balances $162,000 45,000 69,000 $168,000 64,000 54,000 98,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,700 6,800 5,600 1,800 450 $3,800 34,200 25,600 12,100 4,300 For each company, compute the following ratios. (Round current ratio to 2 decimal places, e.g. 1.83. Round accounts receivable turnover, average collection period, inventory turnover, days in inventory, profit margin, asset turnover, return on assets, return on common stockholders' equity and times interest earned to 1 decimal places, e.g. 1.8 or 1.8%. Round debt to assets ratio to 0 decimal places, e.g. 15%.) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Ratio Current ratio Accounts receivable turnover Average collection period. Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debt to assets ratio (11) Times interest earned (12) Free cash flow $ times $ times
Step by Step Solution
★★★★★
3.43 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
Step 1 Ratio Analysis Ratio analysis is the relationship between the two items of financial statemen...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started