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 referenc 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 a. Prepare an income statement for the Warner Company. h. Prenare a balance sheet for the Warner Comnanv 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 E 30 for the cost of goods sold is expected as a positive number. ( 1pt.) 3 In cell E31, by using cell references, calculate the gross profit. ( 1 pt.) In cell E33 and E34, by using cell references, determine the general and administrative expense and depreciation 4 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. ( 1pt.) 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 E 38, 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 F51, by using cell references, calculate the total current assets. ( 1pt.) 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 expenses, and notes payable. (1pt.) 17 In cell E63, by wsing 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 liablities. (1pt.) 20 In cells E.67 and E68, by using cell references, detemine the common stock and retained earnings. ( 1 pt.) 21 In cell E69, by using, cell references, calculate the total shareholders' cquity. ( 1 pt.) 22 In cell E70, by using cell references, calculate the total liablities and shareholders' equity. ( 1 pt.) 23 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed
