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 $673,300 $585,000 Marketable securities 886,800 690,300 Accounts and notes receivable (net) 1,091,900 830,700 Inventories 504,500 158,700 Prepaid expenses 249,500 98,700 Total current assets $3,406,000 $2,363,400 Current liabilities: Accounts and notes payable (short-term) $942,500 $780,000 Accrued liabilities 357,500 390,000 Total current liabilities $1,300,000 $1,170,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. Current Year Previous Year 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 Current Year Previous Year 1. Working capital 2. Current ratio 3. Quick ratio b. The liquidity of Nilo has from the preceding year to the current year. The worldng capital, current ratio, and quick ratio have all Most of these changes are the result of an) in current assets relative to current liabilities