Homework Answers
Answer:
1.Current Ratio = Current Assets / Current Liabilities
Target Corporation = 19000 / 10000 = 1.90
Wal-Mart Stores inc.= 50000 / 56000 = 0.893
2.Accounts Receivable Turnover = Sales / Avg. Accounts Receivable
Target Corporation = 66500 / 8000 = 8.31
Wal-Mart Stores inc.= 407000 / 4200 = 96.90
3.Average Collection Period = 365 / Accounts Receivable Turnover
Target Corporation = 365 / 8.31 = 43.92 Days
Wal-Mart Stores inc.= 365 / 96.90 = 3.77 Days
4.Inventory Turnover = Cost of goods sold / Avg. Inventory
Target Corporation = 44000 / 6900 = 6.38
Wal - Mart Stores inc.= 310000 / 34300 = 9.04
5.Days in Inventory = 365 / Inventory Turnover
Target Corporation = 365 / 6.38 = 57.21 Days
Wal-Mart Stores inc.= 365 / 9.04 = 40.38 Days
6.Profit Margin = Net Income / Net Sales
Target Corporation = 5290 / 66500 = 7.95%
Wal - Mart Stores inc.= 9020 / 407000 = 2.22%
7.Asset Turnover = Sales / Average Total Assets
Target Corporation = 66500 / ( 44500 + 44000 ) / 2 = 66500 / 44250 = 1.50
Wal - Mart Stores inc.= 407000 / (173000 + 165000 ) / 2 = 407000 / 169000 = 2.41
8.Return on Assets = Net Income / Average Total Assets
Target Corporation = 5290 / ( 44500 + 44000 ) / 2 = 5290 / 44250 = 11.95%
Wal - Mart Stores inc.= 9020 / (173000 + 165000 ) / 2 = 9020 / 169000 = 5.34%
9.Return on Common Stockholders Equity = Net Income / Average Common Stockholders Equity
Target Corporation = 5290 / ( 17300 + 14500 ) / 2 = 5290 / 15900 = 33.27%
Wal - Mart Stores inc.= 9020 / (73000 + 64000 ) / 2 = 9020 / 68500 = 13.17%
10.Debt to Assets Ratio = Total Liabilities / Total Assets
Target Corporation = (10000 + 17200 ) / 44500 = 27200 / 44500 = 0.611
Wal - Mart Stores inc.= (56000 + 44000 ) / 173000 = 100000 / 173000 = 0.58
11.Times Interest Earned = Operating Income / Interest Expense
Target Corporation = (66500 - 44000 - 15100 ) / 730 = 10.14 Times
Wal - Mart Stores inc.= ( 407000 - 310000 - 79000 ) / 1900 = 9.47 Times
12.Free Cashflow = Operating Cash flow - Capital Expenditures
Target Corporation = 5800 - 1600 = 4200
Wal - Mart Stores inc.= 26300 - 11700 = 14600
Add Answer to:
thank you!!
i
dont know how to reply to your comment. what do you mean need...
Is due by tonight at midnight please help. Target Corporation Wal-Mart Stores, Inc. Income Statement Data...
Is due by tonight at midnight please help.
Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $67,000 $410,000 Cost of goods sold 302,000 Selling and administrative expenses 44,000 14,300 700 81,000 Interest expense 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 44,000 Long-term debt 18,200 Total...
Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in...
Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Wal-Mart Target Income Statement Data for Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $66,900 45,000 15,000 $419,000 309,000 80,000 1,900 (80) 1,500 (390) 6,700 4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders" equity Total liabilities and stockholders $17,000...
Help I System Announcements Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017...
Help I System Announcements Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart CTAR Inc. Income Statement Data for Year $66,900 45,000 15,000 700 $419,000 309,000 80,000 1,900 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income (80) (390) 1,500 6,700 $4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term...
can you help find the answers thats highlighted in the red. i cant seem to get...
can you help find the answers thats highlighted in the red. i
cant seem to get the correct answers
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $66,400 46,000 $410,000 308,000 78,000 14,200 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income 650 (70) 1,400 $ 4,080 2,200 (390) 7,100 $ 14,310...
Hypothetical Financial Data
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).TargetCorporationWal-MartStores, Inc.Income Statement Data for YearNet sales$66,700$409,000Cost of goods sold46,000306,000Selling and administrative expenses14,70076,000Interest expense6501,800Other income (expense)(95)(420)Income tax expense1,4007,200Net income$ 3,855$ 17,580Balance Sheet Data(End of Year)Current assets$19,000$48,000Noncurrent assets25,600120,000Total assets$44,600$168,000Current liabilities$10,000$55,000Long-term debt18,20044,000Total stockholders’ equity16,40069,000Total liabilities and stockholders’ equity$44,600$168,000Beginning-of-Year BalancesTotal assets$43,000$162,000Total stockholders’ equity13,50066,000Current liabilities10,50055,000Total liabilities29,50096,000Other DataAverage net accounts receivable$7,800$3,900Average inventory7,00033,700Net cash provided by operating activities5,60026,800Capital expenditures1,80012,400Dividends4604,500For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio...
* Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are...
* Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Stores, Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Wal-Mart Target Corporation Inc. Income Statement Data for Year $66,300 $411,000 44,000 305,000 14,300 77,000 660 1,900 (80) (420) 1,500 7,200 $5,760 $19,480 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and...
Problem 9-5 Your answer is partially correct. Suppose selected financial data of Target and Wal-Mart for...
Problem 9-5 Your answer is partially correct. Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other Income (expense) Income tax expense Net income Wal-Mart Target Corporation Stores Inc. Income Statement Data for Year $66,900 $417,000 44,000 308,000 14,400 79,000 750 1,800 (95) (400) 1,500 6,600 $ 6,155 $ 21,200 Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year)...
Ratio (1) Current ratio (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5)...
Ratio (1) Current ratio (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5) Days in inventory (6) Profit margin (7) Asset turnover (8) Return on assets (9) Return on common stockholders' equity (10) Debt to assets ratio (11) Times interest earned (12) Free cash flow Target 1.63 :1 8.6 times 42.0 days 6.6 times 55.3 days 3.8 % 1.5 times 5.6 % 17.1 % 66 % 6.5 times $3,656 Wal-Mart 0.87 :1 101.4 times 3.6 days 9.0...
Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here...
Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Wal-Mart Target Stores, Corporation Inc. Income Statement Data for Year $66,700 $409,000 46,000 306,000 14,700 76,000 650 1,800 (95) (420) 1,400 7,200 $3,855 $17,580 Net income Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year) $19,000 $48,000 25,600 120,000 $44,600 $168,000...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7,139 $ 2.488 $ 14,335 Net income Current assets Noncurrent assets Total assets Current liabilities Balance Sheet Data (End of Year) $18.424 $48.331 26.109 122.375 $44,533...
Is due by tonight at midnight please help.
Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $67,000 $410,000 Cost of goods sold 302,000 Selling and administrative expenses 44,000 14,300 700 81,000 Interest expense 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 44,000 Long-term debt 18,200 Total...
Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Wal-Mart Target Income Statement Data for Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $66,900 45,000 15,000 $419,000 309,000 80,000 1,900 (80) 1,500 (390) 6,700 4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders" equity Total liabilities and stockholders $17,000...
Help I System Announcements Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart CTAR Inc. Income Statement Data for Year $66,900 45,000 15,000 700 $419,000 309,000 80,000 1,900 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income (80) (390) 1,500 6,700 $4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term...
can you help find the answers thats highlighted in the red. i
cant seem to get the correct answers
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $66,400 46,000 $410,000 308,000 78,000 14,200 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income 650 (70) 1,400 $ 4,080 2,200 (390) 7,100 $ 14,310...
* Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Stores, Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Wal-Mart Target Corporation Inc. Income Statement Data for Year $66,300 $411,000 44,000 305,000 14,300 77,000 660 1,900 (80) (420) 1,500 7,200 $5,760 $19,480 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and...
Problem 9-5 Your answer is partially correct. Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other Income (expense) Income tax expense Net income Wal-Mart Target Corporation Stores Inc. Income Statement Data for Year $66,900 $417,000 44,000 308,000 14,400 79,000 750 1,800 (95) (400) 1,500 6,600 $ 6,155 $ 21,200 Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year)...
Ratio (1) Current ratio (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5) Days in inventory (6) Profit margin (7) Asset turnover (8) Return on assets (9) Return on common stockholders' equity (10) Debt to assets ratio (11) Times interest earned (12) Free cash flow Target 1.63 :1 8.6 times 42.0 days 6.6 times 55.3 days 3.8 % 1.5 times 5.6 % 17.1 % 66 % 6.5 times $3,656 Wal-Mart 0.87 :1 101.4 times 3.6 days 9.0...
Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Wal-Mart Target Stores, Corporation Inc. Income Statement Data for Year $66,700 $409,000 46,000 306,000 14,700 76,000 650 1,800 (95) (420) 1,400 7,200 $3,855 $17,580 Net income Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year) $19,000 $48,000 25,600 120,000 $44,600 $168,000...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7,139 $ 2.488 $ 14,335 Net income Current assets Noncurrent assets Total assets Current liabilities Balance Sheet Data (End of Year) $18.424 $48.331 26.109 122.375 $44,533...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago