Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

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

Students also viewed these Accounting questions