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 $750 $81
Accounts receivable (net) 2,060 1,810
Inventory 880 830
Other current assets 570 429
Total current assets $4,260 $3,150
Total current liabilities $2,060 $1,610

For the year, net credit sales were $8,258 million, cost of goods sold was $5,328 million, and net cash provided by operating activities was $1,251 million.

Required:
Compute the current ratio, current cash debt coverage, accounts receivable turnover, average collection period, inventory turnover, and days in inventory at the end of the current year.

Answer 1

Nordstrom, Inc.

Current Ratio = Current assets/Current liabilities

= $4,260/ $2,060

= 2.1

Current cash debt coverage = Net Operating Cash/Current liabilities

= $1,251/$2,060

= 0.61

Accounts receivable turnover = Net Sales/Average Receivable

= $8,258/$1,935

= 4.27

Average collection period = 365/4.27

= 85.5 days

Inventory turnover = Cost of goods sold/Average inventory

= $5,328/$855

= 6.2 times

Days in inventory = 365/Inventory turnover

= 58.9 days

Step-by-step explanation:

a) Data and Calculations:

End of Year Beginning of Year

Cash and cash equivalents $750 $81

Accounts receivable (net) 2,060 1,810

Inventory 880 830

Other current assets 570 429

Total current assets $4,260 $3,150

Total current liabilities $2,060 $1,610

Net credit sales = $8,258 million

Cost of goods sold = $5,328 million

Net operating cash = $1,251 million

Average receivables = $1,935 ($2,060 + $1,810)/2

Average inventory = $855 ($880 + $830)/2