can anyone help with this vertical horizontal analysis?

AutoSave Off be 1_ Test 1 ACC102A 2021 Stud HO - Verticla. Horiz - Statement Analysis - Excel Search seana lamphear File Home Insert Page Layout Formulas Data Review View Help Share Comments Times New Roman 12 A == Wrap Text Currency NT TTX TA 280 W TI 5 Paste BIU A E E Merge & Center Insert Delete Format y Ideas $ %) Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas F23 F G H J L M N o P Q R S T U v 1 2 C D E ABC Business Comparitive Summary Income Sheet For The Years Ended December 31, 2021 & 2020 3 4 2020 Dollars 2021 Percentage Dollars Percentage 2021 Calculate The following ratio to? 1) Profit Margin 2020 Industry Average 0.31 740.000 1,500 738,500 540,000 7.500 532,500 $ Comment briefly on your findings S 425,000 $365,000 Answer Here: S 313,500 S 167,500 5 6 7 Revenue: 8 Sales 9 Less: Sales Retums 10 Net Sales 11 12 Cost Of Merchandise Sold: 13 14 Gross Profit On Sales: 15 16 Operating Expenses: 17 Total Selling Expenses 18 Total Administrative Expenses 19 Total Operating Expenses 20 21 Operating Income: 22 23 24 Other Expenses: 25 Interest Expense 74,350 73,450 147.800 69,340 70,480 139.820 S S S 165,700 S 27,680 3,400 3,800 27 Net Income $ 162,300 S 23,880 1) Bond Question - 10 Pts 2) Income St. Analysis - 20 pts 3) Balance Sh Analysis - 20 pts + + 80% Type here to search e a . 12:26 PM 6/25/2020