Question

The following data (in millions) were adapted from recent financial statements of International Paper Company (IP)...

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."

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Requirement:1 Numerator Net sales 23617 484651 Accounts Recievable Turn over ratio Denominator Avearge Account Recievable 373Requirement: 4 Numerator No of Days in year 365 Days sales in Inventory 7 Denominator 7 Inventory Turn over ratio 6.2 8.1 = !

Add a comment
Know the answer?
Add Answer to:
The following data (in millions) were adapted from recent financial statements of International Paper Company (IP)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • MBA 6-10 Average inventory 11,488 11,039 1. Compute the accounts receivable turnover for Years 1 and...

    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...

    ................. 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)....

    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...

    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...

    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...

    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....

    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...

    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...

    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...

  • 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT