Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Selected hypothetical financial data of Target and Wal - Mart for 2 0 2 5 are presented here ( in millions ) Target , Wal

Selected hypothetical financial data of Target and Wal-Mart for 2025 are presented here (in millions) Target , Wal-mart Income Statement Data for Year Net sales $66,300, $411,000 COGS $44,000, $305,000 Selling & administrative expenses $14300, $77000 Interest expense $600, $1,900 Other income (expense)(80)(420) Income tax expense $1500, $7200
Net income $5,760 $19,480 Balance Sheet Data (End of Year) Current assets $17000 $48000 Noncurrent assets $26000, $122000 Total assets $43000, $170000 Current liabilities $11,000, $55000 Long-term debt 17700, $45000 Total stockholders' equity $15100, $70000 Total liabilities and stockholders' equity $43800, $170000Beginning-of-Year Balances Total assets $43,000 $164000 Total stockholders' equity $12700, $66,000 Current liabilities $10,500, $55000 Total liabilities $30,300, $98,000 Other data Average net accounts receivable $7400,3,900 Average inventory $7000, $33200 Net cash provided by operating activities$5,500 $26,000 Capital expenditures $1,800 $11,900 Dividends $470 $3900 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, eg: 15.50 round debt to assets ratio to 0 decimal places, eg.15% enter free cash flow answers in millions and all other answers to 1 decimal place, eg.1.8 or 1.83%) use 365 days for calculations Ratio Target Wal-Mart (1) Current ratio (2) Accounts receivable turnover times times (3) Average collection period days days times times (4) Inventory turnover days days (5) Days in inventory %(6) Profit margin 7) Asset turnover times times (8) Return on assets %(9) Return on common stockholders' equity %(10) Debt to assets ratio t (11) Times interest earned (12) free cash flow

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

Recommended Textbook for

Cost Accounting

Authors: Mark Lee Inman

2nd Edition

0434908320, 978-0434908325

More Books

Students also viewed these Accounting questions

Question

What would you do?

Answered: 1 week ago