Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with question 7 & 12 please. Selected hypothetical financial data of Target and Wal-Mart for 2022 are pre Target Corporation Wal-Mart Stores,

I need help with question 7 & 12 please.
image text in transcribed
image text in transcribed
image text in transcribed
Selected hypothetical financial data of Target and Wal-Mart for 2022 are pre Target Corporation Wal-Mart Stores, Inc Income Statement Data for Yea Net sales $65,400 $418,000 Cost of goods sold 44,000 309.000 15,000 79,000 Selling and administrative expenses Interest expense Other income (expense) 740 2,100 (90) (380) Income tax expense 1.400 7.300 Net income $4,170 $ 20,220 Balance Sheet Data (End of Year) Current assets 519.000 $50.000 Noncurrent assets 26.700 121.000 Total assets $45.700 5171.000 Current liabilities $11.000 $55.000 Long-term debt 18.500 45,000 Total stockholders' equity 16,200 71,000 Total liabilities and stockholders' equity $45,700 $171,000 Beginning-of-Year Balances Total assets $44,000 $165,000 Total stockholders' equity 12,800 64,000 Current liabilities 10,600 58,000 Total liabilities 31,200 101,000 Other Data Average net accounts receivable $8,000 $3,900 Average inventory 6,900 34.500 Net cash provided by operating activities 5.500 25.800 Capital expenditures 1.800 11.700 Dividends 450 4.500 For each company, compute the following ratios. (Round current ratio answers to 2 decimal plac cash flow answers to 0 decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83 Ratio Target Wal-Mart (1) Current ratio 1.73 1 0.91 1 (2) Accounts receivable turnover 83 times 107.18 times (3) Average collection period 44.0 days 3.6 days (4) Inventory turnover 6.3 times 9.1 times (5) Days in inventory 57.6 days 402 days (6) Profit margin 6.38 484 % (7) Asset tumover 15 times 249 times (8) Return on assets 9.3 %6 1204 % (9) Return on common stockholders equity 28.76 % 29.96 96 (10) Debt to assets ratio 64 % 58 % (11) Times interest earned 8.6 times 14.10 times (12) Free cash flow $ 3700 14100

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

Financial Accounting And Reporting

Authors: Barry Elliott, Jamie Elliott

20th Edition

1292399805, 978-1292399805

More Books

Students also viewed these Accounting questions