Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Selected Financial data of Target Corporation and Walmart Stores, Inc. for a recent year are presented here (in millions). Complete section A numbers 7 to
Selected Financial data of Target Corporation and Walmart Stores, Inc. for a recent year are presented here (in millions).
Complete section A numbers 7 to 11
P18-5 Selected financial data of Target Corporation and Wal-Mart Stores, Inc. for a recent year are presented here (in millions). e in millions). ssa y for 000 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $61,471 $374,526 41,895 286,515 16,200 70,847 647 1,798 1,896 4,273 1,776 6,908 $ 2,849 $ 12,731 Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year) $18,906 $ 47,585 25,654 115,929 $44,560 $163,514 Current liabilities Long-term debt Total stockholders' equity | Total liabilities and stockholders' equity $11,782 17,471 15,307 $44,560 $ 58,454 olimo 40,452 64,608 $163,514 Problems 827 Total assets Total stockholders' equity Current liabilities Total liabilities Target Wal-Mart Corporation Stores, Inc. Beginning-of-Year Balances $37,349 $151,587 15,633 61,573 11,117 52,148 21,716 90,014 Average net accounts receivable Average inventory Net cash provided by operating activities Other Data $ 7,124 $ 6,517 4,125 3,247 34,433 20,354 Instructions (a) For each company, compute the following ratios. (1) Current ratio. (7) Asset turnover. (2) Accounts receivable turnover. (8) Return on assets. (3) Average collection period. (9) Return on common stockholders' equity. (4) Inventory turnover. (10) Debt to assets ratio. (5) Days in inventory. (11) Times interest earned. (6) Profit margin. (b) Compare the liquidity, profitability, and solvency of the two companies. (a) (Continued) (All dollars are in millions) Target Wal-Mart 9 1 (7) Asset turnover 11 3 4 14 6 (8) Return on assets 15 7 16 8 17 9 18 10 19 11 (9) Return on common 20 12 stockholders' equity 21 13 22 14 23 15 24 16 (10) Debt to total assets 25 17 27 19 28 20 29 21 (11) Times interest earned 30 22 31 23
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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