please give me ALL FORMULAS if not I will give you a thumbs down.
Alignment Number Styles So A C D B Name: E . BY b Your score: G 0% The comparative income statements of B Company follow. Calculate trend percents for all components of the income statements using 2021 as the base year. Each formula must include the ROUND function, rounding all percents to 2 decimal places. (XXX.XX%) 5 7 8 9 10 11 12 13 14 15 Sales Cost of goods sold Gross profit Operating expenses Net income B Company Comparative Income Statements For Years Ended December 31, 2025-2021 2025 2024 2023 $42,000 $38,000 $35,000 25,000 24,000 19,000 17,000 14,000 16,000 10,000 9,000 8,000 $7,000 $5,000 $8,000 2022 $30,000 18,000 12,000 7,000 $5,000 02 $26,000 17,000 9,000 6,000 $3,000 16 2025 2024 2023 2022 2021 17 18 19 20 21 22 23 24 25 Sales Cost of goods sold Gross profit Operating expenses Net income A D B Name E H 1 CM F Your score Average both tabs G 0% NA The comparative balance sheets of B Company follow Express the balance sheets in common-size percents. Each formula must include the ROUND function rounding all percents to 2 decimal places (XXX.XX%). 0 B Company Comparative Balance Sheets For Years Ended December 31, 2025 2021 2025 2024 2023 $6,000 $7,000 $8,000 13,000 15,000 18,000 39,000 45,000 54,000 49.000 56,000 68,000 $107.000 $123,000 $148,000 2022 $7,000 15,000 45,000 56,000 $123,000 2021 $6,000 13,000 39,000 49,000 $107.000 12 13 14 15 16 17 18 19 20 21 Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Current habilities Long-term liabilities Common stock Retained earnings Total liabilities and equity $14,000 11,000 15,000 67000 $107.000 $17.000 14,000 20,000 72.000 $123,000 $20,000 16,000 22,000 90,000 $148,000 $17,000 14,000 20,000 72.000 $123,000 $14,000 11,000 15,000 67,000 $107.000 22 2025 2024 2023 2022 2021 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Cash Accounts receivable, net Merchandise inventory Plant assets, net Total assets Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and equity 38