6 Problem 2-13 (Static) Worksheet (Appendix 2A] 2.22 points 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. Credits Debits 23,300 65,00 75.ee Account Title Cash Accounts receivable Supplies Prepaid rent Inventory office equiprent Accumulated depreciation Accounts payable Salaries payable Notes payable Common stock Retained earnings Dividends Sales revenue Cost of goods sold Interest expense Salarios expense Rent expense Supplies expense Utility expense Totals 10. 26.100 3.0 30.oe 80,00 22,05 180,00 95.000 32.350 14,000 6.ee 351,150 351,150 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 ten useful life with no salvage value. 2 Accrued salaries at year-end should be $4,500. 3. The company borrowed $30,000 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 $500. 5. Prepold rent at year-end should be $1,000. 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. Answer is not complete. Complete this question by entering your answers in the tabs below. Reg: Reg 2A Reg 28 Reg 20 Reg 3 Complete the worksheet below. Balance Sheet Account Title Unadjusted Trial Balance Dr. Cr. 323.200 32.500 Adjusting Entries Dr. Cr. Income Statement Dr. Cr. Dr. Cr. Cash Accounts receivable Supplies Adjusted Trial Balance Dr. Cr. $ 23,300 32,600 500 1.000 500 1.000 85.000 75.000 9.375 19.375 $ 10.000 20.100 3.000 30.000 4.500 7.500 Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable Interest payable Common stock Retained esmings Dividends Sales revenue Cost of goods sold Interest expense Salangs expense Rent expense Supplies expense Utilities expense Depreciation expense 19.375 20,100 7.500 30.000 1.000 80.000 22.060 1,000 80.000 22.050 6.000 0.000 180.000 180,000 95.000 95.000 1,000 X 1.000 4,500 22.260 14.000 2.000 6.000 1,000 500 38.850 13,000 1.500 6.000 0.375 0,275 1$ 0 $ 0 3 0 20.875 Net income Totals S 225 025 $ 251 150 s 10.375 $ 387 025 10.373 20 875 Rea 2A