Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense. 1-Dec Began business by depositing $10500 in a bank account in the name of the company in exchange for 1050 shares of $10 per share common stock. 1-Dec Paid the rent for the current month, $1450 . 1-Dec Paid the premium on a one-year insurance policy, $1320 . 1-Dec Purchased Equipment for $4200 cash. 5-Dec Purchased office supplies from XYZ Company on account, $300 . 15-Dec Provided services to customers for $9200 cash. 16-Dec Provided service to customers ABC Inc. on account, $8200 . 21-Dec Received $3400 cash from ABC Inc., customer on account. 23-Dec Paid $170 to XYZ company for supplies purchased on account on December 5 . 28-Dec Paid wages for the period December 1 through December 28, $5040 . 30-Dec Declared and paid dividend to stockholders $200 . #2. Post all of the December transactions from the General Journal tab to the T-accounts under the T-Accounts tab in the excel template file "Accounting Cycle Excel Template.xlsx". Assume there are no beginning balances in any of the accounts. #3. Compute the balance for each T-account after all of the entries have been posted. These are the unadjusted balance as of December 31. #4. Prepare the unadjusted trial balance under the Unadjusted Trial Balance tab in the excel template file "Accounting Cycle Excel Template.xlsx" . Provide the total of the credit column from the Unadjusted Trial Balance #5. Record the following four transactions as adjusting entries under the General Journal tab. 31-Dec One months insurance has been used by the company $110. 31-Dec The remaining inventory of unused office supplies is $90. 31-Dec The estimated depreciation on equipment is $70. 31-Dec Wages incurred from December 29 to December 31 but not yet paid or recorded total $540. #6. Post all of the adjusting entries to the T-accounts under the T-Accounts tab. Compute the balance for each T-account after all of the adjusting entries have been posted. These are the adjusted balance as of December 31. #7. Prepare the adjusted trial balance under the Adjusted Trial Balance tab as of December 31 in the excel template file "Accounting Cycle Excel Template.xlsx" . Provide the following accounts balances from the Adjusted Trial Balance: Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation Accounts Payable Wages Payable Common Stock Retained Earnings #8. Prepare Income Statement, Statement of Stockholders Equity, and Classified Balance Sheet under the Financial Statements tab for the month ended December 31, 20XX in the excel template file "Accounting Cycle Excel Template.xlsx". Provide the following amount from the Income Statement: Service Revenue Depreciation Expense Wages Expense Supplies Expense Rent Expense Insurance Expense Net Income Provide the following account balance from the Statement of Stockholders' Equity: Dividends Provide the following account balances from the Balance Sheet: Current Assets Long-Term Assets Total Liabilities Total Stockholders Equity Cash #9. Record the closing entries under the General Journal tab. #10. Post all of the closing entries to the T-accounts under the T-Accounts tab. Compute the balance for each T-account after all of the closing entries have been posted. Provide the ending balance of Cash at December 31 from the T-account Provide the balance of the Retained Earnings T-account after closing entries have been posted. Does the ending balance of the Retained Earnings T-account agree with the balance of Retained Earnings on the Balance Sheet? Check Point: Total Assets $ 20,950.00

Just need 8, 9 and 10.

5 Credit Date Account title & explanation 1-Dec Cash Common Stock Debit 10500 10500 1450 1-Dec Rent expense Cash 1450 1320 1-Dec Prepaid Insurance Cash 1320 4200 1-Dec Equipment Cash 4200 300 5-Dec Supplies Accounts Payable 300 15-Dec Cash 9200 Service Revenue 9200 8200 16-Dec Accounts Receivable Service Revenue 8200 3400 21-Dec Cash Accounts Receivable 3400 23-Dec Accounts Payable Cash 170 31 32 33 34 28-Dec Wages expense 5040 Cash 5040 200 30-Dec Dividend Cash 37 200 2. Post all of the December transactions from the "General Journal" tab to the T-accounts 39 40 41 Accounts Receivable 8200 3400 Cash 10500 9200 3400 1450 1320 4200 170 5040 200 46 10720 4800 Supplies 300 Prepaid Insurance 1320 110 210 90 1210 Accumulated Dep. Equipment 4200 4200 Accounts Payable 170 300 Wages Payable 540 130 540 Retained Earnings Common stock 10500 10500 Dividends 200 Service Revenue 9200 8200 17400 200 Depreciation expense Wages expense 5040 540 5,580 70 90 4. Prepare the unadjusted trial balance Credit 0 100 130 Unadjusted Trial Balance Account title Debit Cash 10720 Accounts Receivable 4800 Supplies 300 Prepaid Insurance 1320 Equipment 4200 Accumulated Depreciation Accounts Payable Wages Payable Common Stock Retained Earnings Dividends 200 Service Revenue Depreciation Expense 0 Wages Expense 5040 Supplies Expense Rent Expense 1450 Insurance Expense Total 28030 10500 102 103 17400 106 108 109 28030 111 112 113 5. Record the following four transactions as adjusting entries 114 Date Account title & explanation Debit Credit 116 31-Dec Insurance expense 110 117 Prepaid insurance 115 110 118 210 119 120 31-Dec Supplies expense (300 - 90) Supplies 210 121 122 123 31-Dec Depreciation Expense Accumulated Depreciation 70 540 125 126 127 31-Dec Wages Expense Wages Payable 540 130 131 Credit 133 134 128 7. Prepare the adjusted trial balance 129 Adjusted Trial Balance Account title Debit Cash 10720 Accounts Receivable 4800 Supplies 90 135 Prepaid Insurance 1210 136 Equipment 4200 Accumulated Depreciation Accounts Payable 139 Wages Payable 140 Common Stock 141 Retained Earnings Dividends 200 143 Service Revenue 144 Depreciation Expense Wages Expense 5,580 Supplies Expense 210 Rent Expense 1450 Insurance Expense 110 149 Total 28640 130 540 10500 17400 70 146 147 28640