Transcribed Image Text
In: AccountingSelected financial data of Target and Wal-Mart for 2017 arebelow (in millions).TargetWal-MartIncome...Selected financial data of Target and Wal-Mart for 2017 arebelow (in millions).TargetWal-MartIncome Statement Data for YearNet sales$65,357$408,214Cost of goods sold45,583304,657Selling and administrative expenses15,10179,607Interest expense7072,065Other income (expense)(94)(411)Income tax expense1,3847,139Net income$ 2,488$ 14,335Balance Sheet Data (End of Year)Current assets$18,424$ 48,331Noncurrent assets26,109122,375Total assets$44,533$170,706Current liabilities$11,327$ 55,561Long-term debt17,85944,089Total stockholders’ equity15,34771,056Total liabilities and stockholders’ equity$44,533$170,706Beginning-of-Year BalancesTotal assets$44,106$163,429Total stockholders’ equity13,71265,682Current liabilities10,51255,390Total liabilities30,39497,747Other DataAverage net accounts receivable$ 7,525$ 4,025Average inventory6,94233,836Net cash provided by operating activities5,88126,249Capital expenditures1,72912,184Dividends4964,217(a) For each company, compute the following ratios.RatioTargetWal-Mart(1) Current ratio.1.6265560170.869872752(2) Accounts receivable turnover.8.685315615101.4196273(3) Average collection period.42.024955253.598908906(4) Inventory turnover.6.5662633259.003930725(5) Days in inventory.55.5871706640.53785076(6) Gross profit margin %4%4%(7) Return on assets (use net income).6%9%(8) Debt to assets ratio.66%58%Note: Gross profit margin % = (Revenues - COGS)/Revenues, orgross margin/revenues(b) Below, briefly compare the two companies in terms ofliquidity (items 1-5), solvency (item 8), and profitability (items6, 7). By briefly, I mean 1 -3 sentences per category.Liquidity:Solvency:Profitability:
Other questions asked by students
The point P is on the unit circle Find P x y from the given...
In the following exercises evaluate each integral in terms of an inverse trigonometric function 3...
Internal Rate of Return Method The internal rate of return method is used by Testerman...
identify the list of accounts below that would normally all have a credit balance payroll...