Question: Current Attempt in Progress table [ [ Total assets,$ 4 3 , 8 0 0 , $ 1 7 0 , 0 0 0

 Current Attempt in Progress \table[[Total assets,$43,800,$170,000],[Current liabilities,$11,000,$55,000],[Long-term debt,17,700,45,000],[Total stockholders' equity,15,100,70,000],[Total liabilities
Current Attempt in Progress \table[[Total assets,$43,800,$170,000],[Current liabilities,$11,000,$55,000],[Long-term debt,17,700,45,000],[Total stockholders' equity,15,100,70,000],[Total liabilities and stockholders' equity,$43,800,$170,000]]
\table[[,Beginning-of-Year Balances,],[Total assets,$43,000,$164,000],[Total stockholders' equity,12,700,66,000],[Current liabilities,10,500,55,000],[Total liabilities,30,300,98,000]]
\table[[,Other Data],[Average net accounts receivable,$7,400,$3,900],[Average inventory,7,000,33,200],[Net cash provided by operating activities,5,500,26,200],[Capital expenditures,1,800,11,900],[Cash dividends paid,470,3,900]](a) For each company, compute the following ratios. Assume all sales were on credit. (Round current ratio answers to 2 decimal places, e.g.
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.g.1.8 or 1.83%. Use 365 days for calculations.)
Current ratio
Accounts receivable turnover
Average collection period
Inventory turnover
Days in inventory
Profit margin
Asset turnover
Return on assets
Return on common stockholders' equity
Debt to assets ratio
Walmart
:1
times
days
times
times
days
%
times
%
%
%
%
times
times Question 3 of 3
Inventory turnover
times
times
Days in inventory
days
days
Profit margin
%
%
Asset turnover
times
times
Return on assets
%
%
Return on common stockholders' equity
%
%
Debt to assets ratio
%
%
Times interest earned
times
times
Free cash flow
$
$
eTextbook and Media
Selected hypothetical financial data of Target and Walmart for 2025 are presented here (in millions).
\table[[,\table[[Target],[Corporation]],\table[[Walmart],[Inc.]]],[,Income Statement Data for Year],[Net sales,$66,300,$411,000],[Cost of goods sold,44,000,305,000],[Selling and administrative expenses,14,300,77,000],[Interest expense,660,1,900],[Other income (expense),(80),(420)],[Income tax expense,1,500,7,200],[Net income,$5,760,$19,480]]
\table[[Current assets,\table[[Balance Sheet Data],[(End of Year)]]],[$17,000,$48,000],[Noncurrent assets,26,800,122,000],[Total assets,$43,800,$170,000]]
and stockholders' equity,$43,800,$170,000]] \table[[,Beginning-of-Year Balances,],[Total assets,$43,000,$164,000],[Total stockholders' equity,12,700,66,000],[Current liabilities,10,500,55,000],[Total liabilities,30,300,98,000]] \table[[,Other Data],[Average

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!