Please show all excel formulas and processes used Pleaa Fa1122 He me i' n chsnqes 829 264 122 539 588,188 152 378 Insert o raw Page Formulas Data Review Vie Q Tell me Extra Assignment Wrap v vcu lett First, format the Inconw statement below to make It look professional for exhibit purposes Also, format the Net Income cells (row 26) so that they how in red if the number negative, graph on a separate OEQeIsheet tEb showing the breakdow expense categories for the years 2019 2022 Make that for nutting is such that it would be a good chad for professional presentation purposes with a title, legend, etc xaow CONSTRUCTION COMPANY 20 Sat o s Materia' Rent Expen Oflce Staff Salars Supplies Total Cen, Adm Operating Income Interest Expense Taxable Taxes Net Income Total Ad Net Income Readv 2 01g 2,848 304 2,019 040 60 000 58 557 435 7go 133 948 301 843 2019 2 020 5,722 818 058 379 63,000 127,318 53,661 243,979 814 400 147 562 666 B38 299,067 367 771 2020 2 021 6,828 450 8,722 680 105 790 65 000 131 52 63,077 259,597 (153 807) 143 log (296 916) 281 080 577 995 2021 2 022 8,052 187 6 762 104 1 290 083 67,000 136,057 61,928 264 , 1 025098 148 133 876 5 381 477 515 48B 2022 e to 88 e DO NOT HARDCODE

Question

Please show all excel formulas and processes used Pleaa   Fa1122 He me i' n chsnqes 829 264 122 539 588,188 152 378 Insert o raw Page Formulas Data Review Vie Q Tell me Extra Assignment Wrap v vcu lett First, format the Inconw statement below to make It look professional for exhibit purposes  Also, format the Net Income cells (row 26) so that they  how in red if the number negative, graph on a separate OEQeIsheet tEb showing the breakdow expense categories for the years 2019   2022   Make that for nutting is such that it would be a good chad for professional presentation purposes with a title, legend, etc  xaow CONSTRUCTION COMPANY 20 Sat o s Materia' Rent Expen Oflce Staff Salars Supplies Total Cen,   Adm  Operating Income Interest Expense Taxable Taxes Net Income Total   Ad Net Income Readv 2 01g 2,848 304 2,019 040 60 000 58 557 435 7go 133 948 301 843 2019 2 020 5,722 818 058 379 63,000 127,318 53,661 243,979 814 400 147 562 666 B38 299,067 367 771 2020 2 021 6,828 450 8,722 680 105 790 65 000 131 52 63,077 259,597 (153 807) 143  log (296 916) 281 080 577 995 2021 2 022 8,052 187 6 762 104 1 290 083 67,000 136,057 61,928 264 , 1 025098 148 133 876  5 381 477 515 48B 2022 e to 88 e DO NOT HARDCODE

Accepted Answer

The Answer is in the image, click to view ...

Question

Please show all excel formulas and processes used Pleaa - Fa1122 He me i' n chsnqes 829.264 122.539 588,188 152.378 Insert o raw Page Formulas