The following data (in millions) were adapted from recent financial statements of International Paper Company (IP) and Wal-Mart Stores Inc. (WMT)
International Paper | Wal-Mart | |
Sales | $23,617 | $484,651 |
Cost of goods sold | $16,254 | $365,086 |
Operating income | $1,517 | $27,147 |
Accounts Receivable | ||
Beginning of year | $4,058 | $6,677 |
End of year | $3,414 | $6,778 |
Inventory | ||
Beginning of year | $2,825 | $44,858 |
End of year | $2,424 | $45,141 |
1. Compute the accounts receivable turnover for International Paper and Wal-Mart. Round to one decimal place.
2. Compute the days’ sales in receivables for International Paper and Wal-Mart. Round to International Papernearest day.
3. Compute the inventory turnover for International Paper and Wal-Mart. Round to one decimal place.
4. Compute the days’ sales in inventory for International Paper and Wal-Mart. Round to nearest day.
5. Compute the return on sales for International Paper and Wal-Mart. Round to one decimal place."
The following data (in millions) were adapted from recent financial statements of International Paper Company (IP)...
MBA 6-10
Average inventory 11,488 11,039 1. Compute the accounts receivable turnover for Years 1 and 2. Round to one decimal place. 2. Compute the days' sales in receivables for Years 1 and 2. Round to the nearest day, 3. Compute the inventory turnover for Years 1 and 2. Round to one decimal place. 4. Compute the days' sales in Inventory for Years 1 and 2. Round to one decimal place. 5. Compute the return on sales for Years 1...
.................
Analyze and compare Costco, Wal-Mart, and Nordstrom The general merchandise retail industry has a number of segments represented by the following companies: Company Name Merchandise Concept Costco Wholesale Corporation (COST) Membership warehouse Wal-Mart Stores, Inc. (WMT) Discount general merchandise Nordstrom, Inc. (JWN) Fashion department store For a recent year, the following cost of goods sold and beginning and ending inventories are provided from corporate annual reports in millions) for these three companies: Costco Wal-Mart Nordstrom Cost of goods sold...
3 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 Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 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 Balance...
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 Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 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 Balance...
The following data were taken from the income statements of Mydorf Company. Sales revenue Beginning inventory Purchases 2020 $6,450,000 915,000 4,328,250 1,040,000 2019 $6,230,000 900,000 4,643,250 915,000 Ending inventory Compute for each year the inventory turnover. (Round answers to 1 decimal place, e.g. 1.6.) 2020 2019 Inventory turnover times times LINK TO TEXT Compute for each year the days in inventory. (Use 365 days for calculation. Round answers to 1 decimal place, e.g. 1.6.) 2020 2019 Days in inventory days...
Selected financial data of Target Corporation and Wal-Mart Stores, Inc. for a recent year are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $61,471 $374,526 Cost of goods sold 41,895 286,515 Selling and administrative expenses 16,200 70,847 Interest expense 647 1,798 Other income (expense) 1,896 4,273 Income tax expense 1,776 6,908 Net income $ 2,849 $ 12,731 Balance Sheet Data (End of Year) Current assets $18,906 $ 47,585 Noncurrent assets 25,654 115,929...
Brief Exercise 18-12 a1-a2 The following data were taken from the income statements of Mydorf Company. 2020 2019 Sales revenue $6,470,000 $6,220,000 Beginning inventory 920,000 850,000 Purchases 4,422,000 4,583,500 Ending inventory 1,100,000 920,000 Compute for each year the inventory turnover. (Round answers to 1 decimal place, e.g. 1.6.) 2020 2019 Inventory turnover times times LINK TO TEXT Compute for each year the days in inventory. (Use 365 days for calculation. Round answers to 1 decimal place, e.g. 1.6.) 2020 2019...
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...
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 Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity 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 Balance...
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...