6 A C 100,000 1 Revenue 40% 2 COGS 40,000 3 Gross Profit 60,000 4 Salaries 20,000 12,000 5 Marketing 6 Rent 5,000 7 Earnings Before Tax 8 Tax 23,000 25% 5,750 17,250 9 Net Income Use goal seek to answer this question. All else equals, to have a net income of 20,000, the COGS margin percentage must be and the gross profit must be 35.9%, 64,067 37.1%, 62,867 36.3%, 63,667 35.2%, 64,830 CO 7 G H D C E A 1 F C 4 A 3 1 2 3 COUNTA(A1:11 4 The formula in the cell above would yield the result: m 8 F C A 6 5 3 4 2 1 12 10 6 4 2 2 18 15 12 C 6 24 20 12 16 4 4 30 25 20 15 10 5 5 36 30 18 24 12 6 6 42 35 28 21 14 7 7 48 40 32 24 16 8 54 45 36 27 18 C C 60 50 40 30 10 20 10 The output of this function is: =INDIRECT(MID(CELL("address",C3),2,1)&CELL("row",D6) t .. 9 The formula MID("ABCDEFGHI",3,4) would yield the result 10 C A 6 5 4 3 1 12 10 4 2 18 19 12 3 3 24 20 16 12 8 4 4 30 25 20 15 10 36 30 24 12 18 6 6 42 35 28 21 14 7 7 48 40 32 24 16 8 8 54 45 36 27 18 60 50 40 30 20 10 10 The output of this function is: =IF(AND(C6>B7,OR(E1*A4=E4,D5