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,424 $140
Accounts receivable (net) 4,000 3,800
Inventory 1,800 1,800
Other current assets 636 591
Total current assets $7,860 $6,331
Total current liabilities $3,930 $3,122
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.
Instructions:
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

Answer and Explanation:

The computation is shown below:-

1. Current ratio is

= Current Assets ÷ Current Liabilities

= $7,860 ÷ $3,930

= 2

2. Current cash debt coverage is

= Net Cash Provided by Operating Activities ÷ Average Current Liabilities

Average Current Liabilities = ($3,930 + $3,122) ÷ 2

= $3,526

Current Cash Debt Coverage Ratio = $1,251 ÷ $3,526

= 25.48%

3. Accounts receivable turnover is

= Net Credit Sales ÷ Average Accounts Receivables

= $8,258 ÷ (($4,000 + $3,800) ÷ 2)

= $8,258 ÷ $3,900

= 2.12 times

4. Average collection period is

= 365 ÷ Account Receivable Turnover

= 365 ÷ 2.12

= 172.17

5. Inventory Turnover is

= Cost of Goods Sold ÷ Average Inventory

= $5,328 ÷ ((1,800 + 1,800) ÷ 2

= $5,328 ÷ 1,800

= 2.96

6. Days in Inventory is

= 365 ÷ Inventory Turnover Ratio

= 365 ÷ 2.96

= 123.31 days