Current position analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent scal years: Current Year Previous Year Current assets: Cash $443,600 $336,700 Marketable securities 584,300 397,300 Accounts and notes receivable (net) 719,300 478,000 Inventories 1,708,600 1,258,000 Prepaid expenses 845,000 782,200 Total current assets $4,300,800 $3,252,200 ) Current liabilities: Accounts and notes payable (short-term) $812,000 $673,400 Accrued liabilities 308,000 336,600 Total current liabilities $1,120,000 $1,010,000 This information has been collected in the Microsoft Excel Dnline file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet 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 1. Working capital $l $l b. The liquidity of Nilo hasl 'I from the preceding year to the current year. The working capital, current ratio, and quick ratio have all I '1 . Most of these changes are the result of a(n) i m in current assets relative to current liabilities