please answer in word or Excel

s compute ratios evakuate turnover, liquidity, and current dabt paying ability) The financial statements of Family News, Inc, inctude the following items: 2012 2011 2010 Balance sheet: Cash Short-term investments Net receivables . $ 53,000 17,000 77,000 90,000 8,000 245,000 65,000 131,000 s 89,000 21,000 55,000 60,000 Prepaid expenses.... Total current assets. Accounts Payable... 72,000 6,000 268,000 55,000 90,000 50,000 Net credit sales $494,000 276,000 5502,000 $480,000 254,000 280,000 1. Compute the following ratios for 2012 and 2011: a. Current ratio b. Quick (acid test) ratico c. Inventory turnover and days' inventory outstanding (DIO) dd. Accounts receivable turnover e. Days sales in average receivables or days' sales outstanding (DSO) E. Accounts payable turnover and days' payable outstanding (DPO) t Cash conversion cycle Cin days) (When computing days, round your answer to the nearest whole number) Evaluate the company's liquidity and current debt paying ability for 2012. Has it improved or deteriorated from 20117 As a manager of this company, what would you try to improve next year? 2. 3