Will appreciate it if formulas for questions could be included as well please! Thank you!! :)

Prepare a balance sheet and income statement for the Warner Company from the following scrambled list of items. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the green cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. a. Prepare an income statement for the Warner Company. a. Prepare an income statement for the Warner Company. b. Prepare a balance sheet for the Warner Company. Requirements 1 Start Excel. Income Statement In cells E29 and E30, by using cell references, determine the sales and cost of goods sold. 2 Note: The output of the expression or function you typed in cell E30 for the cost of goods sold is expected as a positive number. (1 pt.) 3 In cell E31, by using cell references, calculate the gross profit. (1 pt.) 4 In cell E33 and E34, by using cell references, determine the general and administrative expense and depreciation expense. Note: The outputs of the expression or function you typed in these cells are expected as negative numbers. (1 pt.) 5 In cell E35, by using cell references, calculate the total operating expenses. (1 pt.) 6 In cell E36, by using cell references, calculate the net operating income. (1 pt.) In cell E37, by using a cell reference, determine the interest expense. 7 Note: The output of the expression or function you typed in this cell is expected as a negative number. (1 pt.) 8 In cell E38, by using cell references, calculate the earnings before taxes. (1 pt.) In cell E39, by using a cell reference, determine the taxes. 9 Note: The output of the expression or function you typed in this cell is expected as a negative number. (1 pt.) 10 In cell E40,, by using cell references, calculate the net income. (1 pt.) Balance Sheet 11 In cells E48, E49, and E50, by using cell references, determine the cash, inventory, and accounts receivable. (1 pt.) 12 In cell E51, by using cell references, calculate the total current assets. (1 pt.) In cells E53 and E54, by using cell references, determine the buildings and equipment asset and accumulated depreciation. 13 Note: The output of the expression or function you typed in cell E54 for the accumulated depreciation is expected as a negative number. (1 pt.) 14 In cell E55, by using cell references, calculate the net buildings and equipment asset. Use cells E53 and E54. (1 pt.) 15 In cell E56, by using cell references, calculate the total assets. (1 pt.) 16 In cells E59, E60, E61, and E62, by using cell references, enter the accounts payable, taxes payable, accrued expenses, and notes payable. (1 pt.) 17 In cell E63, by using cell references, calculate the total current liabilities. (1 pt.) 18 In cell E64, by using a cell reference, determine the long-term debt. (1 pt.) 19 In cell E65, by using cell references, calculate the total liabilities. (1 pt.) 20 In cells E67 and E68, by using cell references, determine the common stock and retained earnings. (1 pt.) 21 In cell E69, by using cell references, calculate the total shareholders' equity. (1 pt.) 22 In cell E70, by using cell references, calculate the total liabilities and shareholders' equity. (1 pt.) 23 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed