Apply Excel (Part 2) Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Cash Accounts receivable Inventory Long-term assets Total assets Current Previous $ 52,000 $ 42,000 22,000 27,000 82,000 62,000 166,900 137,000 $322,900 $268,000 Current liabilities Long-term liabilities Total liabilities Stockholders' equity Total liabilities and stockholders' equity Current $ 62,000 84,000 146,000 176,900 $322,900 Previous $ 52,000 74,000 126,000 142,000 $ 268,809 Net sales Cost of goods sold Operating expenses Interest expense Income tax expense Net income Current $310,000 202,500 42,000 10,200 20,400 $ 34,900 Required: 1. Use your spreadsheet to recalculate the ratios and enter your results here: (Round your answers to 2 decimal places.) Required: 1. Use your spreadsheet to recalculate the ratios and enter your results here: (Round your answers to 2 decimal places.) imes Rotho Receivables turnover ratio Average collection period Inventory tumover ratio Average days in Inventory Current ratio Add test ratio Debt to equity ratio Times interesteamed ratio times days to 1 to 1 3. Every liquidity ratio is calculated using one or more accounts. A high current ratio indicates that a company has Current assets to pay current abilities as they become doo