Work shown on excel

AutoSave OH Excel Project SUM20 (1) Excel Search Daniel Olmodo co File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri 11 AA 89 Wrap Text Ceneral 29 O 4 NI Peste X Out [Copy * Format Painter Cipboard Insert Delete format BIU Idees Merge Center $ -% AutoSum ri Sort & Find & Clear Filter Select Eding Conditional Format as Cell Formatting Table Styles Styles Font Alignment Number Cels dias F66 f A D E F H - J K L M N 0 P R S 37 B Comparative Statement of income For the Years Ended December 31, 2018 and 2017 2019 2018 2019 2018 38 39 40 41 42 43 44 45 46 $700,000 $524,300 $175,700 $600,000 $420,000 $180.000 48 49 50 51 Sales Cost of Goods Sold Gross Marin Operating expenses: Salaries and Wages Expense Rent Expense Depreciation Expense Tutal Operating Expenses Income from Operations Loss on Sale of Equipment Interest Expense Increase (Decrease) in Operating Income Income before Taxes Federal Income Taxes 30% Net Income $47,290 $20,256 $20,000 $87,546 588 154 ($5,213) $3,656 ($8,869 $79,285 $23,786 $55,499 $100,000 $20,000 $10,000 $130.000 $50,000 SU $5,000 ($5,000) $45,000 $13,500 $31.500 54 55 56 total 10 points for this analysis, Excel funtion is needed to conduct calculation 59 60 61 62 63 64 65 Cash FlowStalement Vertical Analysis Horizontal Analysis Ralio Analysis + Ready Type here to search + 1009 12:00 PM 7/16/2020 O EH e E