Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

View Policies Show Attempt History Current Attempt in Progress Your answer is partially correct. Selected hypothetical financial data of Target and Wal-Mart for 2022 are

View Policies Show Attempt History Current Attempt in Progress Your answer is partially correct. Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $67,000 $410,000 Cost of goods sold 44,000 302,000 Selling and administrative expenses 14,300 81.000 Interest expense 700 2,000 Other income (expense) (85) (390) Income tax expense 1.400 7,000 Net income $6,515 $17,610 Balance Sheet Data (End of Year) Current assets $17,000 $49,000 Noncurrent assets 27,500 122,000 Total assets $44,500 $171,000 Current liabilities $10.000 $55,000 30.000 44.000 MacBook Air Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 18,200 44,000 16,300 72,000 $44,500 $171,000 Beginning-of-Year Balances Total assets Total stockholders' equity Current liabilities Total liabilities $43,000 $164,000 13,200 64,000 10,300 56,000 29,800 100,000 Other Data Average net accounts receivable $7,400 $3,800 Average inventory 6,900 33,000 Net cash provided by operating activities 6,000 27,300 Capital expenditures 1,800 11,700 Dividends 520 3,900 0.25/1 !!! For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, eg. 15.50, debt to assets ratio and free cash flow answers to O decimal places, eg. 5,275 and all answers to 1 decimal place, eg. 1.8 or 1.83%) Ratio 325 (1) Current ratio (2) Accounts receivable turnover (3) Average collection period Target Wal-Mart 1.65 :1 0.875 :1 9.05 times 107.89 times 40 days 3.38 days For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, eg. 15.50, debt to assets ratio and free cash flow answers to O decimal places, eg. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%) (8) (11) Ratio Current ratio Accounts receivable turnover Target Wal-Mart 1.65 :1 0.875 :1 9.05 times 107.89 times Average collection period Inventory turnover Days in inventory Profit margin Asset turnover 40 days 3.38 days 6.38 times 9.15 times days days % % times times Return on assets % % Return on common stockholders' equity % % (10) Debt to assets ratio % % Times interest earned times times (12) Free cash flow $ eTextbook and Media MacBook Airimage text in transcribedimage text in transcribedimage text in transcribed

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

An Introduction To Derivative Securities Financial Markets And Risk Management

Authors: Robert A. Jarrow, Arkadev Chatterjee

2nd Edition

194465965X, 978-1944659653

More Books

Students also viewed these Accounting questions

Question

Excerice 10 chapter Calculating and reporting healthcare statistics

Answered: 1 week ago

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago