Please answer in Excel with formulas and proper labels for a great rating! Thank you!

The following financial data were taken from the annual financial statements of Smith Corporation: a. Based on these data, calculate the following for 2010 and 2011: 1. Working capital 2. Current ratio 3. Acid-test ratio 4. Accounts receivable turnover 5. Merchandise inventory turnover 6. Inventory turnover in days b. Evaluate the results of your computations in regard to the short-term liquidity of the firm