The financial statements of Explorer News, Inc., include the following items:

Requirements

1. Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number.

a. Current ratio

b. Quick (acid-test) ratio

c. Inventory turnover and days’ inventory outstanding (DIO)

d. Accounts receivable turnover

e. Days’ sales in average receivables or days’ sales outstanding (DSO)

f. Accounts payable turnover and days’ payable outstanding (DPO). Use cost of goods sold in the formula for accounts payable turnover.

g. Cash conversion cycle (in days)

2. Evaluate the company’s liquidity and current debt-paying ability for 2018. Has it improved or deteriorated from 2017?

3. As a manager of this company, what would you try to improve next year?

Transcribed Image Text:

2018 2017 2016 Balance sheet: $ 77,000 Cash $103,000 Short-term investments 18,000 20,000 Net receivables 81,000 84,000 35,000 Inventory . 96,000 70,000 58,000 Prepaid expenses.. 7,000 6,000 Total current assets 279,000 283,000 Accounts payable 45,000 35,000 40,000 . Total current liabilities.. 130,000 97,000 Income statement: Net credit sales $493,000 $507,000 Cost of goods sold . 280,000 278,000