complete all parts using excel

do E-13.3 & E-13.4

Instructions Prepare a statement of comprehensive income, beginning with income from continuing operations. Prepare horizontal analysis E13,3 (LO 2), AP Here is financial information for Glitter Inc. Excel Current assets Plant assets (net) Current liabilities Long-term liabilities Common stock, $1 par Retained earnings December 31, 2022 S106,000 400,000 99,000 122.000 130,000 155,000 December 31, 2021 $ 90,000 350.000 65,000 90,000 115,000 170,000 Instructions Prepare a schedule showing a horizontal analysis for 2022, using 2021 as the base year. Prepare vertical analysis E13.4 (LO 2), AP Operating data for Joshua Corporation are presented below. > Excel Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2022 $800,000 520,000 120,000 60,000 30,000 70,000 2021 $600,000 408,000 72,000 48,000 24.000 48.000