Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help find the answers thats highlighted in the red. i cant seem to get the correct answers Suppose selected financial data of Target

can you help find the answers thats highlighted in the red. i cant seem to get the correct answers image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $66,400 46,000 $410,000 308,000 78,000 14,200 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income 650 (70) 1,400 $ 4,080 2,200 (390) 7,100 $ 14,310 Balance Sheet Data (End of Year) $19,000 $48,000 26,900 122,000 Current assets Noncurrent assets search nouncements CALCULATOR Balance Sheet Data (End of Year) $48,000 122,000 $170,000 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity $19,000 26,900 $45,900 $10,000 16,900 19,000 $45,900 $56,000 44,000 70,000 $170,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $162.000 14,300 65,000 10,500 55,000 28,700 97,000 Other Data $7,600 $3,900 Average net accounts receivable to search Other Data $7,600 6,900 $3,900 32,900 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends 5,500 26,600 1,700 460 12,400 3,900 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83 Ratio Target Wal-Mart (1) Current ratio 1.9 :1 0.86 (2) Accounts receivable turnover 8.74 times 105.13 times (3) Average collection period T 3.47 days (4) Inventory turnover 6.67 times 9.36 times (5) 54.75 days 28.99 days Days in inventory 38.99 T3.49 6.14 (6) % Profit margin 4 time here to search (3) Average collection period 41.78 days 3.47 days (4) Inventory turnover 6.67 times 9.36 times Days in inventory 54.75 days 38.99 days (6) Profit margin 6.14 % 3.49 % Asset turnover 2.47 times (8) Return on assets % 4.31 (9) Return on common stockholders' equity 24.50 24:50 % 21.20 (10) Debt to assets ratio 78.21 67.06 10.73 times (11) Times interest earned 9.43 times times 12500 3990 (12) Free cash flow Click if you would like to Show Work for this question: Open Show Work

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_2

Step: 3

blur-text-image_3

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

Sound Investing, Chapter 19 - Related-Party Transaction Ruse

Authors: Kate Mooney

1st Edition

0071719415, 9780071719414

More Books

Students also viewed these Accounting questions