please show calculations on excel with formulas showing

a) Please make an income statement and balance sheet with the following information. Your income statement should have gross profit, EBITDA, EBIT, and net income. Your balance sheet should have segments for current assets and fixed assets, current liabilities, and long-term liabilities, equity. You can use either excel (question 20) or the blank space to answer this question. (10 points) 2021 $ 22,652 Sales Depreciation 3,050 Cost of goods sold 6,972 Other expenses 1,826 Interest 1,620 Cash 5,689 Accounts receivable 11,167 Short-term notes payable 1,897 Long-term debt 35,991 Net fixed assets 82,654 Accounts payable 7,612 Inventory 23,855 Tax rate 35% Owners' equity $ 77,865