A

S

C

D

E

F

$2$ GB$,$ Inc had a tumultuous first vear in business. Overall the business was successful and enjoyed rapid growth even after some bad press due to an Cnvironmental Protection Agency fine. The owners of the company are fooking to understand and automate the Current Earning: & Profit calculation and have asked you to prepare a worksheet.

Required:

Complete the Current C&P calculation indicating whether cach itam should Add or Subtract.

Total the Add and Subtract items and then Current Carnings & Profit

$($IINT: Utlize the SUMIF function referencing the adfacent cells to computa she Subtotals$)$

Add$/$Suburact

$$14,876,335$

City of Naw York Bond inlerest

DRO

Surtotid ${?}^5$

Ando

Suluthe

Sertracit

Gurrent Carning: $8$ ProfiT

Provide Formulas please.