Question: table [ [ , Target Corporation,Walmart Inc. ] , [ , Income Statement Data for Year ] , [ Net sales,$ 6 4 ,

\table[[,Target Corporation,Walmart Inc.],[,Income Statement Data for Year],[Net sales,$64,900,$405,000],[Cost of goods sold,44,000,300,000],[Selling and administrative expenses,14,000,75,000],[Interest expense,650,1,800],[Other income (expense),(70),(380)],[Income tax expense,1,300,6,500],[Net income,$4,880,$21,320],[,Balance Sheet Data (End of Year)],[Current assets,$16.000,$45.000],[Noncurrent assets,25.000,120.000],[Total assets,$41,000,$165,000],[Current liabilities,$10.000,$54,000],[Long-term debt,16.800,43,000],[Total stockholders' equity,14,200,68,000],[Total liabilities and stockholders' equity,$41,000,$165.000],[,Beginning-of-Year Balances],[Total assets,$43,000,$162,000],[Total stockholders' equity,12,500,64,000],[Current liabilities,10,000,54,000],[Total liabilities,30,500,98,000],[,Other Data],[Average net accounts receivable,$7,400,$3,800],[Average inventory,6.800,32,800],[Net cash provided by operating activities,5.500,25,500],[Capital expenditures,1.600,11,500],[Cash dividends paid,450,3,500]]
(a) For each company, compute the following ratios. Assume all sales were on credit. (Round current ratio answers to 2 decimal places, e.8.15.50. Round debt to assets ratio to 0 decimal places, e.g.15%. Enter free cash flow answers in millions. Round all other answers to 1 decimal place, e.8.1.8 or 1.83%. Use 365 days for calculations.)
\table[[Ratio,Target,Walmart],[1.,,:1,,:1],[2. Accounts receivable turnover,,times,,times],[3. Average collection period,,days,,days],[4. Inventory turnover,,times,,times],[5. Days in inventory,,days,,days],[6. Profit margin,,%,,%],[7. Asset turnover,,times,,times],[8. Retum on assets,,%,,%],[9.,,%,,%],[10. Debt to assets ratio,,%,,%],[11. Times interest earned,,times,,times],[12. Free cash flow,$,$,,],[eTextbook and Media,,,,],[,,,Attempts: 0 of 3 used,
\ table [ [ , Target Corporation,Walmart Inc. ] ,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!