B.	Record the adjustments in the adjustments columns on the worksheet. Include the identifying adjustment letter. Then complete the worksheet.
C.	Record the adjustments in the formatted journal entries at the bottom of the worksheet.
D.	Prepare an Income Statement, including a proper heading, on the Income Statement Tab.
E.	Prepare a Statement of Owner's Equity, including a proper heading, on the Statement of Owner's Equity Tab.
	Assume the capital balance on the worksheet is the beginning balance for the period and that there are no
	additional investments.
F.	Prepare a Classified Balance Sheet, including a proper heading, on the Balance Sheet Tab.
G.	Record the closing entries in the formatted journal entries below the adjusting entries on the worksheet.
H.	Prepare a Post Closing Trial Balance, including a proper heading, on the Post-Closing Trial Balance Tab.
I.	Your work should be neat and orderly. Submit this completed assignment by the due date.
	The assignment should be submitted in the "assignment folder" in Blackboard.
J.	You must use Microsoft Excel to complete this assignment. No hand written submissions.
B.	Record the adjustments in the adjustments columns on the worksheet. Include the identifying adjustment letter. Then complete the worksheet.
C.	Record the adjustments in the formatted journal entries at the bottom of the worksheet.
D.	Prepare an Income Statement, including a proper heading, on the Income Statement Tab.
E.	Prepare a Statement of Owner's Equity, including a proper heading, on the Statement of Owner's Equity Tab.
	Assume the capital balance on the worksheet is the beginning balance for the period and that there are no
	additional investments.
F.	Prepare a Classified Balance Sheet, including a proper heading, on the Balance Sheet Tab.
G.	Record the closing entries in the formatted journal entries below the adjusting entries on the worksheet.
H.	Prepare a Post Closing Trial Balance, including a proper heading, on the Post-Closing Trial Balance Tab.
I.	Your work should be neat and orderly. Submit this completed assignment by the due date.
	The assignment should be submitted in the "assignment folder" in Blackboard.
J.

Balance Sheet Debit Credit Name: Problem: Chapter 4 Worksheet Problem Course: ACC 120 - LN281 Date: Spring 2022 Banks Company Worksheet For the month ended December 31, 2021 Trial Balance Adjustments Adjusted Trial Balance Income Statement Debit Credit Debit Credit Debit Credit Debit Credit Cash 6,000 Accounts Receivable 400 Supplies 1,300 Prepaid Insurance 1,200 Office Equipment 3,000 Accum. Depr-Office Equip Accounts Payable 2,100 A. Banks, Capital 6,500 A. Banks, Drawing 160 Fees Earned 5,100 Wages Expense 1,300 Rent Expense 200 Utilities Expense 140 Supplies Expense Insurance Expense Depreciation Expense-Office Equip Totals 13,700 13.700 0 0 0 0 0 Net income or loss Totals 0 0 Adjusting Entries: A. Prepaid Insurance which has expired $300. B. Ending Supplies Inventory is $200. Instructions Worksheet Income Statement Statement of Owner's Equity Balance Sheet Post Closing TE B. Ending Supplies Inventory is $200. C. Fees earned but not yet received is $1,400. D. Depreciation on the Office Equipment for December, $100. (c) Journalize the adjusting entries using the worksheet as a basis. Account Title DR CR (d) Journalize the closing entries using the worksheet as a basis. Account Title E. DR CR F. Instructions Worksheet Income Statement Statement of Owner's Equity Balance Sheet Post Closind NAME: Income Statement $ $ Fees Earned Expenses: Net Income Instructions Worksheet Income Statement Statement of Owner's Equity Balance Shee NAME: Statement of Owner's Equity $ $ NAME: Balance Sheet $ $ Instructions Worksheet Income Statement Statement of Owner's Equity E NAME: Post-Closing Trial Balance DR CR