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 $439,000 $358,400 Marketable securities 578,200 422,900 Accounts and notes receivable (net) 711,800 508,700 Inventories 1,620,900 1,103,000 Prepaid expenses 801,600 685,800 Total current assets $4,151,500 $3,078,800 Current liabilities: Accounts and notes payable (short-term) $688,800 $573,400 Accrued liabilities Total current liabilities 261,200 $950,000 286,600 $860,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 b. 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. 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 $439,000 $358,400 Marketable securities 578,200 422,900 Accounts and notes receivable (net) 711,800 508,700 Inventories 1,620,900 1,103,000 Prepaid expenses 801,600 685,800 Total current assets $4,151,500 $3,078,800 Current liabilities: Accounts and notes payable (short-term) $688,800 $573,400 Accrued liabilities Total current liabilities 261,200 $950,000 286,600 $860,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. Current Year Previous Year Formulas a. 1. Working capital 2. Current ratio 3. Quick ratio