Question

In: Accounting

Suppose the amounts presented here are basic financial information (in millions) from the 2017 annual reports...

Suppose the amounts presented here are basic financial information (in millions) from the 2017 annual reports of Nike and adidas.

Nike

adidas

Sales revenue

$ 20,161 $ 9,941

Allowance for doubtful accounts, beginning

84.6 108

Allowance for doubtful accounts, ending

120 133

Accounts receivable balance (gross), beginning

3,128 1,797

Accounts receivable balance (gross), ending

3,243.0 1,611

(a)

Calculate the accounts receivable turnover for both companies. (Round answers to 1 decimal place, e.g. 12.5.)

Solutions

Expert Solution

Ans.    Accounts receivables turnover     =   Sales / Average accounts receivables    
Nike 20161 / 3083.2 6.5 times
Adidas 9941 / 1583.5 6.3 times
Average accounts receivables = (Net Beginning accounts receivables + Net Ending accounts receivables) / 2
Nike (3043.4 + 3123) / 2 3083.2
Adidas (1689 + 1478) / 2 1583.5
*Calculations for Nike:
Net beginning accounts receivables = Beginning accounts receivables - Beginning allowance for doubtful accounts
3128 - 84.6
3043.4
Net ending accounts receivables = Ending accounts receivables - Ending allowance for doubtful accounts
3243 - 120
3123
*Calculations for Adidas:
Net beginning accounts receivables = Beginning accounts receivables - Beginning allowance for doubtful accounts
1797 - 108
1689
Net ending accounts receivables = Ending accounts receivables - Ending allowance for doubtful accounts
1611 - 133
1478

Related Solutions

Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).
Problem 13-5ASuppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).TargetCorporationWal-MartStores, Inc.Income Statement Data for YearNet sales$65,900$409,000Cost of goods sold45,000303,000Selling and administrative expenses15,10076,000Interest expense6502,100Other income (expense)(95)(400)Income tax expense1,3006,700Net income$ 3,755$ 20,800Balance Sheet Data(End of Year)Current assets$16,000$49,000Noncurrent assets25,700123,000Total assets$41,700$172,000Current liabilities$11,000$56,000Long-term debt17,30045,000Total stockholders’ equity13,40071,000Total liabilities and stockholders’ equity$41,700$172,000Beginning-of-Year BalancesTotal assets$45,000$163,000Total stockholders’ equity12,50066,000Current liabilities10,00058,000Total liabilities32,50097,000Other DataAverage net accounts receivable$7,700$3,800Average inventory7,20033,600Net cash provided by operating activities5,60026,200Capital expenditures1,70011,500Dividends4603,900(a) For each company, compute the following ratios. (Round all answers to 2 decimal...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).                     Income Statement Data for Year                           Net sales            $6,900     $417,000   cost ot goods sold           44,000     38,000  Selling and administratv  epenses            14400    3,000  Interest...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, 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...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $66,400 $414,000 Cost of goods sold 45,000 302,000 Selling and administrative expenses 15,500 81,000 Interest expense 650 1,900 Other income (expense) (80 ) (400 ) Income tax expense 1,400 7,300 Net income $ 3,770 $ 21,400 Balance Sheet Data (End of Year) Current assets $17,000 $47,000 Noncurrent assets 26,700 120,000 Total assets $43,700...
1--Presented below are select financial data from Major Drug’s annual report: Amounts in millions Year 1...
1--Presented below are select financial data from Major Drug’s annual report: Amounts in millions Year 1 Year 2 Balance sheet Accounts receivable (net) $9,367 $13,765 Inventory 6,860 6,239 Income statement Net sales $52,716 $61,498 Cost of goods sold 7,541 8,525 What can be said about Major Drug’s accounts receivable turnover for Year 2? It improved from Year 1 to Year 2 Major Drug collected receivables less effectively in Year 2 as compared to Year 1 Fewer customers purchased items on...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Income Statement Data for YearTarget CorporationWal-Mart Stores, Inc.Net 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 ofYear)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,056(b) Compare the liquidity, solvency, and profitability of the two companies.
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 Interest expense 707 2,065 Other income (expense) (94) (411) Income tax expense 1,384 7,139 Net income $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18,424 $48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 Interest expense 707 2,065 Other income (expense) (94) (411) Income tax expense 1,384 7,139 Net income $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18,424 $48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 Interest expense 707 2,065 Other income (expense) (94) (411) Income tax expense 1,384 7,139 Net income $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18,424 $48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current...
Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Target...
Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Target Corporation Walmart Inc. Income Statement Data for Year Net sales $66,750 $414,180 Cost of goods sold 44,800 302,400 Selling and administrative expenses 15,500 81,000 Interest expense 650 1,900 Other income (expense) (80 ) (400 ) Income tax expense 1,400 7,300 Net income $ 4,320 $ 21,180 Balance Sheet Data (End of Year) Current assets $17,050 $47,040 Noncurrent assets 26,700 120,000 Total assets $43,750 $167,040...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT