The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $487,600 $377,100 Marketable securities 585,000 396,000 Accounts and notes receivable (net) 729,200 546,900 Inventories 116,100 49,900 Prepaid expenses 62,100 38,100 Total current assets $1,980,000 $1,408,000 Current liabilities: Accounts and notes payable (short-term) $742,500 $660,000 Accrued liabilities 247,500 220,000 Total current liabilities $990,000 $880,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine for each year (1) the working capital (2) the current ratio, and (3) the quick ratio. Round the ratios to one decimal place and the working capital to the nearest dollar.

Question

Quinton Ellis

Business

1 December, 16:05

The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $487,600 $377,100 Marketable securities 585,000 396,000 Accounts and notes receivable (net) 729,200 546,900 Inventories 116,100 49,900 Prepaid expenses 62,100 38,100 Total current assets $1,980,000 $1,408,000 Current liabilities: Accounts and notes payable (short-term) $742,500 $660,000 Accrued liabilities 247,500 220,000 Total current liabilities $990,000 $880,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine for each year (1) the working capital (2) the current ratio, and (3) the quick ratio. Round the ratios to one decimal place and the working capital to the nearest dollar.

+4

Answers (1)

Know the Answer?

Teresa Nielsen · Answer 1

(a) $990,000; $528,000

(b) 2; 1.6

(c) 1.82; 1.5

Explanation:

Given that,

(a) Current year working capital:

= Current assets - Current liabilities

= $1,980,000 - $990,000

= $990,000

Previous year working capital:

= Current assets - Current liabilities

= $1,408,000 - $880,000

= $528,000

(b) Current ratio (current year):

= Current assets : Current liabilities

= $1,980,000 : $990,000

= 2

Current ratio (Previous year):

= Current assets : Current liabilities

= $1,408,000 : $880,000

= 1.6

(c) Quick ratio (current year):

= (Current assets - Inventories - Prepaid expenses) : Current liabilities

= ($1,980,000 - $116,100 - $62,100) : $990,000

= 1.82

Quick ratio (Previous year):

= (Current assets - Inventories - Prepaid expenses) : Current liabilities

= ($1,408,000 - $49,900 - $38,100) : $880,000

= 1.5