The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current assets: Cash Current Year Previous Year $598,200 $501,700 Marketable securities 787,800 592,000 Accounts and notes receivable (net) 970,000 712,300 Inventories 241,500 127,300 Prepaid expenses 119,500 79,100 Total current assets $2,717,000 $2,012,400 Current liabilities: Accounts and notes payable (short-term) $688,800 $573,400 Accrued liabilities 261,200 286,600 Total current liabilities $950,000 $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 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 ng EP 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 Current Year Previous Year 3. Quick ratio b. The liquidity of Nilo has Most of these changes are the result of a(n). from the preceding year to the current year. The working capital, current ratio, and quick ratio have all in current assets relative to current liabilities. Check My Work Previous Next >