please give all formulas!!
Format ander Formatting ole Chpboard Font Alignment Number Styles A D E B Name: F Your score: G 0% The B 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. 3 4 5 6 7 8 9 10 11 12 2024 Net sales Cost of goods sold Gross margin Operating expenses Net income B Company Comparative Income Statements For Years Ended December 31, 2025-2022 2025 2023 $198,000 $176,000 $154,000 119,000 100,000 88,000 79,000 76,000 66,000 32,000 30,000 26,000 $47,000 $46,000 $40,000 2022 $110,000 74,000 36,000 14,000 $22.000 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Ratio Summary B Company Comparative Balance Sheets For Years Ended December 31, 2025-2022 2025 2024 2023 $82,000 $74,000 $45,000 55,000 49,000 43,000 54,000 35.000 40,000 130,000 120,000 90,000 $321,000 $278,000 $218.000 2022 $57,000 31.000 26,000 80,000 $194,000 A B D E F Your score: 1 Name: 26 27 28 29 30 Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and equity $36.000 100,000 30,000 155,000 $321,000 $30,000 110,000 30,000 108,000 $278,000 $26,000 100,000 30,000 62,000 $218,000 $22,000 120,000 30,000 22,000 $194,000 2025 2024 2023 31 36 37 38 39 40 41 42 43 44 45 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 46 47 2025 2024 2023 48 49 50 51 52 53 54 55