Answered step by step
Verified Expert Solution
Link Copied!

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... 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

Managerial Accounting Tools for business decision making

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

6th Edition

978-0470477144, 1118096894, 9781118214657, 470477148, 111821465X, 978-1118096895

More Books

Students also viewed these Accounting questions

Question

What are the layers of RMI Architecture?

Answered: 1 week ago