Current position analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current assets: Current Year Previous Year Cash $561,500 $457,800 Marketable securities 739,600 540,200 Accounts and notes receivable (net) 910,500 650,000 Inventories 1,601,800 1,174,900 Prepaid expenses 792,200 730,600 Total current assets $4,605,600 $3,553,500 Current liabilities: Accounts and notes payable (short-term) $826,500 $686,700 Accrued liabilities 313,500 343,300 Total current liabilities $1,140,000 $1,030,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 a. 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. 1. Working capital 2. Current ratio 3. Quick ratio Current Year Previous Year Current assets: Cash $561,500 $457,800 Marketable securities 739,600 540,200 Accounts and notes receivable (net) 910,500 650,000 Inventories 1,601,800 1,174,900 Prepaid expenses 792,200 730,600 Total current assets $4,605,600 $3,553,500 Current liabilities: Accounts and notes payable (short-term) $826,500 $686,700 Accrued liabilities 313,500 343,300 Total current liabilities $1,140,000 $1,030,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. X Open spreadsheet a. 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. 1. Working capital Current Year Previous Year 2. Current ratio 3. Quick ratio b. The liquidity of Nilo has from the preceding year to the current year. The . Most of these working capital, current ratio, and quick ratio have all i changes are the result of a(n) | in current assets relative to current liabilities