Question

Current Position Analysis 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 $414,000 $320,000 Marketable securities 496,800 336,000 Accounts and notes receivable (net) 619,200 464,000 Inventories 351,900 272,000 Prepaid expenses 188,100 208,000 Total current assets $2,070,000 $1,600,000 Current liabilities: Accounts and notes payable (short-term) $675,000 $600,000 Accrued liabilities 225,000 200,000 Total current liabilities $900,000 $800,000

Determine for each year:

a. The working capital
b. The current ratio
c. The quick ratio.

Answer 1

a. net working capital (current year) = $1,170,000

net working capital (previous year) = $800,000

b. current ratio (current year) = 2.3

current ratio (previous year) = 2

c. quick ratio (current year) = 1.91

quick ratio (previous year) = 1.66

Step-by-step explanation:

net working capital = current assets - current liabilities

current assets = $2,070,000, $1,600,000

current liabilities = $900,000, $800,000

net working capital (current year) = $2,070,000 - $900,000 = $1,170,000

net working capital (previous year) = $1,600,000 - $800,000 = $800,000

current ratio = current assets / current liabilities

current ratio (current year) = $2,070,000 / $900,000 = 2.3

current ratio (previous year) = $1,600,000 / $800,000 = 2

quick ratio = (current assets - inventory) / current liabilities

inventory = $351,900, $272,000

quick ratio (current year) = ($2,070,000 - $351,900) / $900,000 = 1.91

quick ratio (previous year) = ($1,600,000 - $272,000) / $800,000 = 1.66