horizontal analysis

vertical analysis

A 0% 2 6 7 9 B D Your score Name Jonathan Longwell The comparative income statements of Jonathan Longwell Company follow. Calculate trend percents for all components of the income statements using 2020 as the base year. 3 4 Each formula must include the ROUND function, rounding all percents to 2 decimal places. (XXX.XX%) 5 Jonathan Longwell Company Comparative Income Statements 8 For Years Ended December 31, 2024-2020 2024 2023 2022 2021 10 Sales $56,000 $50,000 $46,000 $39,000 11 Cost of goods sold 33,000 31,000 24,000 23,000 12 Gross profit 23,000 19,000 22,000 16,000 13 Operating expenses 14,000 12,000 12,000 10,000 14 Net income $9,000 $7.000 $10,000 $6,000 15 16 17 18 2024 2023 2022 2021 19 Sales 20 Cost of goods sold 21 Gross profit 22 Operating expenses 23 Net income Instructions Horizontal Vertical 2020 $34,000 22,000 12,000 8,000 $4,000 2020 - 2 H 6 F G Name: Jonathan Longwell Your score 0% Average both tabs: NA The comparative balance sheets of Jonathan Longwell Company follow. Express the balance sheets in common-size 3 percents Each formula must include the ROUND function, rounding all percents to 2 decimal places (XXX.XX%). 5 Jonathan Longwell Company Comparative Balance Sheets 8 For Years Ended December 31, 2024-2020 9 2024 2023 2022 2021 2020 10 Cash $15,000 $17,000 $19,000 $16,000 11 Accounts receivable, net $14,000 33,000 37,000 42.000 35,000 12 31,000 Merchandise inventory 99,000 111,000 126.000 105,000 93,000 13 Plant assets, net 124.000 139,000 158,000 131 000 14 Total assets 116 000 $271.000 $304,000 $345.000 $287.000 $254.000 15 16 Current liabilities $36,000 $41,000 $46,000 $39,000 $34,000 17 Long-term liabilities 29.000 33,000 37,000 31,000 27,000 18 Common stock 41,000 46,000 52,000 43,000 38.000 19 Retained earnings 165,000 184,000 210,000 174,000 155,000 Total liabilities and equity $271.000 $304,000 $345.000 $287.000 $254.000 21 22 23 24 es 2024 2023 2022 2021 2020 26 Cash 27 Accounts receivable, net 28 Merchandise inventory 9 Plant assets, net 0 Total assets 20 1 2 3 4 Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and equity