Please complete in excel

The Abc Company began operations in 2022. Its comparative income statements and balance sheets follow. Use a formula to calculate the ratios below. The AVERAGE formula must be used in any ratios using average accounts receivable, average inventory or average total assets. Net sales Cost of goods sold Gross margin Operating expenses Net income Abc Company Comparative Income Statements For Years Ended December 31, 2025-2022 2025 2024 2023 $180,000 $160,000 $140,000 118,000 96,000 86,000 62,000 64,000 54.000 18.000 18,000 18,000 $44,000 $46,000 $36,000 2022 $100,000 72,000 28,000 16,000 $12,000 Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Abc Company Comparative Balance Sheets For Years Ended December 31, 2025-2022 2025 2024 2023 $40,000 $54,000 $16,000 50,000 45,000 39,000 53,000 24,000 39,000 110,000 90,000 70,000 $253,000 $213,000 $164,000 2022 $28,000 28,000 18,000 60,000 $134,000 Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and equity $35,000 60,000 20,000 138,000 $253,000 $29,000 70,000 20,000 94,000 $213,000 $26,000 70,000 20,000 48,000 $164,000 $22,000 80,000 20,000 12,000 $134,000 2025 2024 2023 2025 2024 2023 Liquidity and Efficiency Current ratio Acid-test ratio Accounts receivable turnover Inventory turnover Total asset turnover Solvency Debt ratio Equity ratio Sum of Debt and Equity ratios Debt-to-equity ratio Profitability Profit margin ratio Gross margin ratio Return on total assets 2025 2024 2023