please do not use other examples i am completely lost on how to complete this

Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2021, appears below. December 31 is the company's reporting year-end. The company uses the perpetual inventory system. Account Title Debits Credits Cash 90,945 Accounts receivable 29,500 Supplies 0 Prepaid rent 0 Inventory 73,500 office equipment Accumulated depreciation. 93,000 12,090 Accounts payable 40,900 5,000 Salaries payable Notes payable Common stock 32,700 145,000 22,450 Retained earnings Dividends 10,875 Sales revenue 200,000. Cost of goods sold 145,000 0 65,950 20,600 Interest expense Salaries expense Rent expense Supplies expense Utility expense Totals 2,720 6,850 538,940 538,940 Supplies expense utility expense Totals 2,720 6,850 538,940 538,940 Information necessary to prepare the year-end adjusting entries appears below. 1. The office equipment was purchased in 2019 and is being depreciated using the straight-line method over an eight-year useful life with no salvage value. 2. Accrued salaries at year-end should be $8,700. 3. The company borrowed $32,700 on September 1, 2021. The principal is due to be repaid in 10 years. Interest is payable twice a year on each August 31 and February 28 at an annual rate of 10% 4. The company debits supplies expense when supplies are purchased. Supplies on hand at year-end cost $680. 5. Prepaid rent at year-end should be $1,550. 1. Complete the worksheet below. 2-a. Use the information in the worksheet to prepare an income statement for 2021 2-b. Use the information in the worksheet to prepare a statement of shareholders' equity for 2021 2-c. Use the information in the worksheet to prepare a balance sheet as of December 31, 2021. 3. Prepare the necessary closing entries assuming that adjusting entries have been correctly posted to the accounts Complete this question by entering your answers in the tabs below. Assignment ney M Complete the worksheet below. Account Title Cash Accounts receivable Supplies Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable Interest payable Common stock Retained earnings Dividends Sales revenue now Unadjusted Trial Balance Dr. Cr. $90,945 29,500 73,500 93,000 10.875 $ 12.090 40,900 5,800 32.700 0 145.000 22.450 280.000 Saved PEN Adjusting Entries Dr. Cr. 0 40 400 850 0 0 Prov 8.125 0 1,500 D 950 1 of 1 Adjusted Trial Balance Dr. Cr Next Income Statement Dhr. Cr. + Help Save & Exit Balance Sheet Dr. Cr Submit Complete this question by entering your answers in the tabs below. Req 1 Reg 2A Reg 28 Reg 2C Reg 3 Use the information in the worksheet to prepare an income statement for 2021. EXCALIBUR CORPORATION Income Statement For the Year Ended December 31, 2021 0 H Prey 1 of 1 VIE Next Reg 1 Reg 2A Reg 28 Req 2C Req 3 Use the information in the worksheet to prepare a statement of shareholders' equity for 2021. EXCALIBUR CORPORATION Statement of Shareholders' Equity For the Year Ended December 31, 2021 Common Stock Retained Earnings Total Shareholders Equity es Balance at January 1, 2021 Balance at December 31, 2021 Reg 1 Reg 2A Req 28 Req 2C Reg 3 Use the information in the worksheet to prepare a balance sheet as of December 31, 2021. (Amounts to be deducted should be indicated by a minus sign.) EXCALIBUR CORPORATION Balance Sheet At December 31, 2021 Assets et Journal entry worksheet