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		$471,300	$386,400
Marketable securities		620,800	456,000
Accounts and notes receivable (net)		764,300	548,600
Inventories		1,807,400	1,326,100
Prepaid expenses		893,900	824,600
	Total current assets	$4,557,700	$3,541,700
Current liabilities:
Accounts and notes payable (short-term)		$862,800	$713,400
Accrued liabilities		327,200	356,600
	Total current liabilities	$1,190,000	$1,070,000
Using formulas and cell references, perform the required analysis, and input your answers into the Current Year and Previous Year columns respectively. Transfer the numeric results for the green entry cells (C20:D22) into the appropriate fields in CNOWv2 for grading.
a.		Current Year	Previous Year	Formulas
	1. Working capital
	2. Current ratio
	3. Quick ratio

The liquidity of Nilo has_____ from the preceding year to the current year. The working capital, current ratio, and quick ratio have all ________ . Most of these changes are the result of a(n) _____ in current assets relative to current liabilities.