Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions) Wal-Mart Target Corporation Stores, Inc. Income Statement Data

image text in transcribedimage text in transcribedimage text in transcribed

Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions) Wal-Mart Target Corporation Stores, Inc. Income Statement Data for Year Net sales $65,300 $417,000 Cost of goods sold 45,000 301,000 Selling and administrative expenses 79,000 14,000 Interest expense 660 1,800 Other income (expense) (85) (380) Income tax expense 1,500 7,100 $4,055 $27,720 Net income Balance Sheet Data (End of Year) Current assets $16,000 $50,000 Noncurrent assets 27,400 121,000 $43,400 $171,000 Total assets $54,000 Current liabilities $11,000 Long-term debt 17,800 43,000 Total stockholders' equity 14,600 74,000 Total liabilities and stockholders' $43,400 $171,000 equity Beginning-of-Year Balances Total assets $45,000 $162,000 Total stockholders' equity 66,000 12,800 10,800 54,000 Current liabilities Total liabilities 32,200 96,000 Other Data Average net accounts receivable $7,600 $3,800 7,100 Average inventory 33,200 Net cash provided by operating 5,600 27,400 activities Capital expenditures 1,600 12,100 Dividends 470 4,200 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.) Wal-Mart Target Ratio (1) Current ratio :1 :1 (2) Accounts receivable turnover times times days (3) Average collection period days times (4) Inventory turnover times days (5) Days in inventory days Profit margin % % (6) (7) Asset turnover times times % % (8) Return on assets % % (9) Return on common stockholders' equity % (10) Debt to assets ratio (11) Times interest earned times times Free cash flow (12)

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

Tips For The New Auditor

Authors: Marty Sturino

1st Edition

1733097813, 978-1733097819

More Books

Students also viewed these Accounting questions