Question
1) Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for 2022 are presented below. End of Year Beginning
1) Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for 2022 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. Compute the current ratio, accounts receivable turnover, average collection period, inventory turnover and days in inventory at the end of the current year. (Round current ratio to 2 decimal places, e.g. 1.83 and all other answers to 1 decimal place, e.g. 1.8. Use 365 days for calculation.)
Current ratio |
| :1 | |
Accounts receivable turnover |
| times | |
Average collection period |
| days | |
Inventory turnover |
| times | |
Days in inventory |
| days |
2)
Oriole Company has these comparative balance sheet data:
ORIOLE COMPANY Balance Sheets December 31 | ||||
---|---|---|---|---|
2022 | 2021 | |||
Cash | $ 25,635 | $ 51,270 | ||
Accounts receivable (net) | 119,630 | 102,540 | ||
Inventory | 102,540 | 85,450 | ||
Plant assets (net) | 341,800 | 307,620 | ||
$589,605 | $546,880 | |||
Accounts payable | $ 85,450 | $ 102,540 | ||
Mortgage payable (15%) | 170,900 | 170,900 | ||
Common stock, $10 par | 239,260 | 205,080 | ||
Retained earnings | 93,995 | 68,360 | ||
$589,605 | $546,880 |
Additional information for 2022:
1. | Net income was $33,900. | |
2. | Sales on account were $395,200. Sales returns and allowances amounted to $28,100. | |
3. | Cost of goods sold was $217,500. | |
4. | Net cash provided by operating activities was $56,500. | |
5. | Capital expenditures were $26,600, and cash dividends were $20,800. |
Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83 and all other answers to 1 decimal place, e.g. 1.8. Use 365 days for calculation.)
(a) | Current ratio. |
| :1 | ||
(b) | Accounts receivable turnover. |
| times | ||
(c) | Average collection period. |
| days | ||
(d) | Inventory turnover. |
| times | ||
(e) | Days in inventory. |
| days | ||
(f) | Free cash flow. |
|
3) The condensed financial statements of Ivanhoe Company for the years 2021 and 2022 are presented below.
IVANHOE COMPANY Balance Sheets December 31 (in thousands) | ||||
---|---|---|---|---|
2022 | 2021 | |||
Current assets | ||||
Cash and cash equivalents | $330 | $360 | ||
Accounts receivable (net) | 580 | 510 | ||
Inventory | 550 | 480 | ||
Prepaid expenses | 130 | 160 | ||
Total current assets | 1,590 | 1,510 | ||
Property, plant, and equipment (net) | 410 | 380 | ||
Investments | 120 | 120 | ||
Intangibles and other assets | 530 | 510 | ||
Total assets | $2,650 | $2,520 | ||
Current liabilities | $930 | $900 | ||
Long-term liabilities | 570 | 470 | ||
Stockholders equitycommon | 1,150 | 1,150 | ||
Total liabilities and stockholders equity | $2,650 | $2,520 |
IVANHOE COMPANY Income Statements For the Year Ended December 31 (in thousands) | ||||
---|---|---|---|---|
2022 | 2021 | |||
Sales revenue | $3,890 | $3,550 | ||
Costs and expenses | ||||
Cost of goods sold | 1,080 | 1,000 | ||
Selling & administrative expenses | 2,400 | 2,330 | ||
Interest expense | 10 | 20 | ||
Total costs and expenses | 3,490 | 3,350 | ||
Income before income taxes | 400 | 200 | ||
Income tax expense | 160 | 80 | ||
Net income | $ 240 | $ 120 |
Compute the following ratios for 2022 and 2021. (Round current ratio and inventory turnover to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 12.6%.)
2022 | 2021 | |||||
---|---|---|---|---|---|---|
Current ratio. |
| :1 |
| :1 | ||
Inventory turnover. |
|
| ||||
Profit margin. |
| % |
| % | ||
Return on assets. |
| % |
| % | ||
Return on common stockholders equity. |
| % |
| % | ||
Debt to assets ratio. |
| % |
| % | ||
Times interest earned. |
| times |
| times |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started