please fill out the tables clearly preferable in excel

Tar Heel Corporation provides the following information at the end of 2021. Salaries payable to workers at the end of the year Advertising expense for the year Building that has been purchased Supplies at the end of the year Retained earnings Utility expense for the year Note payable to the bank Service revenue recognized during the year Salary expense for the year Accounts payable to suppliers Dividends paid to shareholders during the year Common stock that has been issued, including $4,000 that was issued this year Cash remaining Interest expense for the year Accounts receivable from customers Retained earnings at the beginning of the year $ 1,300 8,400 60,000 2,600 32,000 4,000 15,000 59,400 24,700 5,700 (?) 23,000 3,200 1,100 11,200 19,800 Required: 1. Prepare the income statement for the year ended December 31, 2021. 2. Prepare the statement of stockholders' equity for the year ended December 31, 2021. 3. Prepare the balance sheet for the year ended December 31, 2021. Prepare the income statement for the year ended December 31, 2021. TAR HEEL CORPORATION Income Statement For the year ended December 31, 2021 Expenses: Total Expenses 0 Prepare the statement of stockholders' equity for the year ended December 31, 2021. TAR HEEL CORPORATION Statement of Stockholders' Equity For the year ended December 31, 2021 Common Stock Retained Earnings Total Stockholders' Equity Beginning Balance Ending Balance Prepare the balance sheet for the year ended December 31, 2021. TAR HEEL CORPORATION Balance Sheet December 31, 2021 Assets Liabilities Total Liabilities 0 Stockholders' Equity Total Stockholders' Equity Total Liabilities and Stockholders' Equity oo Total Assets $ 0 $