vertical analysis using excel

PLEASE DESCRIBE HOW YOU GOT THE ANSWER

G16 x & fx D E 1 %% 100% 43% 58% 12/31/2023 $ 225,000 100,000 125,000 100% 44% 56% B Rosey's Roses 2 Income Statement 3 for the period ended 4 5 12/31/2022 6 Sales $ 200,000.00 7 Less: Cost of Goods Sold $ 85,000.00 8 Gross Margin $ 115,000.00 9 Expenses: 10 Advertising $18,000.00 11 Communications $ 7,500.00 12 Depreciation $ 5,000.00 13 Payroll $32,000.00 14 Rent $11,600.00 15 Supplies $ 1,300.00 16 Utilities $ 4,600.00 $ 80,000.00 17 Net income $ 35,000.00 18 19 20 21 22 23 24 MAPM 25 26 Income Statement Balance Sheet Ratio Analysis $ 17,000 6,500 5,000 54,700 13,000 800 4,000 101,000 $ 24,000 1896 11% Read