Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with all, Not sure if it is right. Please include formulas, so I can learn! thanks! Setvost selected Hinancial data of Target and

Need help with all, Not sure if it is right. Please include formulas, so I can learn! thanks! image text in transcribed

image text in transcribed

Setvost selected Hinancial data of Target and Wal Mattor 2020 are presented here in moral Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65.357 $408.214 Netsales 304657 4554 15.101 Cost of goods told Selling and administrative Intereste Other Income experte 707 79,607 2.065 (411) 194 Income taxespere 1384 7139 Net Income 52.488 $14.335 Balance Sheet Data (End of Year) Current $18.42 348.331 Noncurrentes 26.109 122375 544533 $170,706 511327 $55561 Total Current abilities Long-term debit Total stockholders equity Total abilities and stockholders equity 17.859 44 089 15.347 71.056 $44533 $170,706 Beginning-of-Year Balances Totalt $44,105 5163429 Total stockholders equity 13.712 65.682 Current brities 10.512 35.370 Totallaties 30394 77,747 Other Data Averagent counts receivable $7.525 $4,025 6442 33.836 Average Inventory Netcash provided by operating activities Capital expenditures 5881 26249 1729 12,114 Dividends 496 4217 a) For each company compute the following ratio.Enter free cash flow in millions. Round Current ratio to 2 decimal places 167. Hound Debt to rate to decimal places, s 18 or 10. Round all other arowers to 1 decimal place 16 or 1.6 Use 365 days for calculation Ratio Target Wal-Mart 11 Current Debt to settle to decimal plans es 18 or 18Round all other answers to 1 decimal places. 16 or 1.6X Use 365 days for calculation Ratio Target Wal-Mart in Current ratio 165 11 11 123 Accounts receivable turnover 17 times 101 times (3) Average collection period 12 days 26 days 4 Inventory turnover ** times 90 times 151 Day In inventory 556 days 105 days (6) Profit margin 350 251 X 17 Asset turnover 15 times times (8) Return on assets 305 X 237 2 191 Return on common stockholders equity 4498 % (10) Debt to assets ratio X (11) Times Interest earned times times (12) Free cash flow $ million $ million e Textbook and Media Attempts:0 of 3 used Submit Answer Save for Using multiple attempts will impact your score 10% score reduction after attempt 2 80 F2 F3 F4 F5 F6 @ $ % &

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

Healthcare Fraud Auditing And Detection Guide

Authors: Rebecca S. Busch

2nd Edition

978-1118179802

More Books

Students also viewed these Accounting questions

Question

2. What is the business value of security and control?

Answered: 1 week ago