Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Project Three: Horizontal and Vertical Analysis Question 3 of 3 - / 1 View Policies Current Attempt in Progress Selected hypothetical financial data of Target
Project Three: Horizontal and Vertical Analysis Question 3 of 3 - / 1 View Policies Current Attempt in Progress Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expensel Income tax expertise Nct income Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,600 $118.000 45,000 310.000 14,300 75,000 720 2,200 190) (380) 1,400 6.900 $4,090 $ 23.520 Current assets Noncurrent assets Total assets Current liabilities Long term dcbt Total stockholders' equity Toslal liabilities and stockholders' equily Balance Sheet Data (End of Year) $18,000 $47.000 26.100 121.000 $44,100 $168.000 $10,000 $55.000 18,300 43,000 15,800 70,000 $44,100 $168,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $14,000 $165.000 13,200 66.000 10,000 54.000 30,800 99,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,900 $4,100 7.100 31.100 5,700 25.900 1,600 11.500 520 4,200 for each company, compute the following ratios. (Round current ratio answers to 2 decimal places, ey. 15.50, debt to caseis ratio and free cash flow aruswers to decimal places, -y 5,275 and all answers to 1 decimal place, ey. 1.8 or 1.83%) Target Wal-Mart Ratio Current ratio (1) :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 $ $ e Textbook and Media Save for Later Attempts: 0 of 3 used Submit
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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