Please Disregard, Ty.

Again, disregard.

Project Description: In this problem, you will prepare income statements for two companies and evaluate the two companies by comparing key accounting items. Steps to Perform: Step Instructions Points Possible 0 1 Start Excel. Download and open the workbook named. Brooks Chapter_2_1_Start 2 1 In cell F21, by using cell references, calculate the sales revenue for company A. Use the relevant cells from the Given Data section. 3 1 In cell F22, by using cell references, calculate the cost of goods sold for company A. Use the relevant cells from the Given Data section. Note: The output of the expression you typed in this cell is expected as a positive number 4 In cell F23, by using cell references, calculate the gross margin or profit for company A. Use cells F21 and F22. 5 In cell F27, by using cell references, calculate the EBIT for company A. Use cells F23 F24, F25, and F26 6 In cell F28, by using a cell reference, enter the amount of the interest expense for company A Refer to the relevant cell from the Given Data section. Note: The output of the expression you typed in this cell is expected as a positive.number 7 In cell F29, by using cell references, calculate the taxable income for company A: Use cells F27 and F28 8 In cell F30, by using cell references, calculate the income taxes for company A Use cell F29 and the relevant cell from the Given Data section Note: The output of the expression you typed in this cell is expected as a positive number 9 In cell F31, by using cell references, calculate the net income for company A. Use cells F29 and F30 10 In cell F32 by using cell references, calculate the operating cash flow (OCF) for company A Use cells F26. F28, and F31 1 1 11 In cell range G21:H32, by using cell references, construct the income statements for company B. Copy the contents from cell range F21:F32 and paste to the cell range G21:G32 for company B under the situation described in part a and H21:H32 in part b. 12 In cells D36 and G36, type either higher or lower by comparing the accounting items of the two companies under the situation described in part a. 13 In cell D40, type either higher or lower by comparing the accounting items of the two companies under the situation described in part b. 1 1