Question

Nordstrom, Inc. operates department stores in numerous states. Suppose selected financial statement data (in millions) for 2020 are presented below. End of Year Beginning of Year Cash and cash equivalents $ 1,285 $ 122 Accounts receivable (net) 3,500 3,300 Inventory 1,500 1,500 Other current assets 555 515 Total current assets $6,840 $5,437 Total current liabilities $3,420 $2,722 For the year, net credit sales were $13,940 million, cost of goods sold was $9,000 million, and net cash provided by operating activities was $1,254 million. Compute the current ratio, accounts receivable turnover, average collection period, inventory turnover, and days in inventory at the end of the current year. (Round answers to 1 decimal place, e.g. 1.6.)

Answer 1

a. Current ratio = Total current assets/Total current liabilities

Current ratio = $6,840/$3,420

Current ratio = 2 : 1

b. Accounts receivable turnover = Net credit sales / [Net beginning accounts receivables + Net ending accounts receivables / 2]

Accounts receivable turnover = $13,940 / [$3,300+$3,500/2]

Accounts receivable turnover = $13,940 / $3,400

Accounts receivable turnover = 4.1 times

c. Average collection period = 365 / Accounts receivables turnover

Average collection period = 365 / 4.1

Average collection period = 89.0244

Average collection period = 89 days

d. Inventory turnover = Cost of goods sold / [Beginning inventory+Ending inventory/2]

Inventory turnover = $9,000 / [$1,500+$1,500/2]

Inventory turnover = $9,000 / $1,500

Inventory turnover = 6 times

e. Days in inventory at the end of the current year = 365 / Inventory turnover

Days in inventory at the end of the current year = 365 / 6

Days in inventory at the end of the current year = 60.8333

Days in inventory at the end of the current year = 61 days