Horizontal and vertical analysis with excel formula

December 31, 2023 2022 110,ooo 220,000 120,000 10,000 460,000 880,000 170,000 50,000 90,000 310,000 240,000 550,000 200,000 100,000 110,000 380,000 790,000 Avg Horizontal Analysis Change Change % Vertical 2023 2022 Current assets: Cash NR, net Inventory Prepaid expenses Total current assets Permanent assets: Plant & equipment, net Total assets Current liabilities: 2023 100,000 210,000 110,000 10,000 430,000 900,000 (10,000) 215,000 (10,000) 115,000 (30,000) 20,000 (10,000) (10,000) 10;ooo (50,000) (50,000) 40,000 40,000 (10,000) -9% 0.00% 2.22% 14 16 17 18 31 32 Accounts payable 160,000 Accrued liabilities Other SIT payables Total current liabilities Long-term liabilities: Bonds payable Total liabilities Stockholders' equity: Preferred stock, $100 par value, 10% Common stock, ($1 par ) APIC-Common Stock Retained earnings Total stockholders' equity Total liabilities & stk's equity 50,000 100,000 310,000 190,000 500,000 200,000 1 oo,ooo 110,000 420,000 830,000 AVI