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 :

Answer:

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