Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2021, appears below. December 31 is the companys reporting year-end. The company uses the perpetual inventory system.

Account Title	Debits		Credits
Cash	84,030
Accounts receivable	28,000
Supplies	0
Prepaid rent	0
Inventory	69,000
Office equipment	87,000
Accumulated depreciation			11,310
Accounts payable			37,600
Salaries payable			5,200
Notes payable			31,800
Common stock			130,000
Retained earnings			20,800
Dividends	9,750
Sales revenue			265,000
Cost of goods sold	137,500
Interest expense	0
Salaries expense	58,750
Rent expense	18,800
Supplies expense	2,480
Utility expense	6,400
Totals	501,710		501,710

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 $7,800.
3. The company borrowed $31,800 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 $620.
5. Prepaid rent at year-end should be $1,400.

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.