please complete all parts in excel

Prepare joumal entres to record the December transactions in the General Joumal Tab in the excel template file "Accounting Cycle Excel Template xisx". Use the following accounts as appropriate Post all of the December transactions from the "General Joumal" tab to the T-accounts under the "T-Accounts" tab in the excel ternplate file "Accounting Cycle Excel Template xisx". Assume there are no beginning balances in any of the accounts. Compute the balance for each T-account after all of the entries have been posted. Prepare the unadjusted traal balance on the "Unadusted Trial Balance" tab. 1 Provide the total of the credit column from the Unadfusted Trial Balance Record the Decomber adjusting entnies on the "General Journal tab. 31-Dec One month's insurance has expired $80. 31-Dec The remaning imventory of unused office supplios is $90. 31-Dec The estimated depreciation on equipment is $70 31-Dec Salanes incurred from December 29 to December 31 but not yet paid or recorded total $450. Post all of the adjusting entries to the T-accounts on the "T-Accounts" tab. Compute the balance for each T-aocount atter all of the adjusting entries have been posted Prepare the adjusted trial balance on the "Adjusted Trai Balance" tab. Check point 1 Adjusted trial balance total debicredit = 39,990 Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answer should be left biank.) Prepare the income Statement, Staternent of Stociduolster 's Equity and Classified Balance Shoot on tho "Funancial Statements" tab for the month ended Docember 31,20x Prepare the income. Statement, Statement of Stockholder's Equity and Classified Balance Sheet on the "Financial Statements" tab for the month ended December 31,20XX Provide the following amount from the income Statement: (Be sure to enter all numbers as positive and no answer should be left blank.) Provide the following account balances from the Balance Sheet: (Be sure to enter all numbers as positive and no answer should be left blank.) answer should be left blank.) 28 Dividends Record the dosing entries on the "General Journal" tab. Post ail of the closing entines to the T-accounts on the "T. Accounts" tab. Compute the balance for each T-account after all of the closing entries have been posted Prepare the post closing trial balance for the month ended Docember 31,20x on the Post-Closing Trial Balance tab. 29 Provide the total of the debit column from the Post Closing Trial Balance 30 Provide the balance of the Retainod Eamings T-account affer closing entries have been posted. Check Point 2: Total Assets $32,960 JESTION 2 31. Does the ending balance of the Retained Earnings t.account agree with the balance of Retained Earnings on the Balance Sheot? General Journal Description Unadjusted Trial Balance General Journal General Ledger (T-accounts) Adjusted Trial Balance Unadjusted Trial Balance December 31, 20\#\# Account Debit Credit Cash Accounts Receivable Supplies Prepaid Insurance Equipment Land Accumulated Depreciation Accounts Payable Deferred Revenue Salaries Payable Notes Payable Common Stock Retained Earnings Dividends Service Revenue Depreciation Expense Salaries Expense Supplies Expense Rent Expense Insurance Expense Totals \begin{tabular}{l} \multicolumn{1}{c|}{ Account } \\ \hline Debit \\ \hline Cash \\ \hline Accounts Receivable \\ \hline Supplies \\ \hline Prepaid Insurance \\ \hline Equipment \\ \hline Land \\ \hline Accumulated Depreciation \\ \hline Accounts Payable \\ \hline Deferred Revenue \\ \hline Salaries Payable \\ \hline Notes Payable \\ \hline Common Stock \\ \hline Retained Earnings \\ \hline Dividends \\ \hline Service Revenue \\ \hline Depreciation Expense \\ \hline Salaries Expense \\ \hline Supplies Expense \\ \hline Rent Expense \\ \hline Insurance Expense \\ Totals \\ \hline \end{tabular} Prepare joumal entres to record the December transactions in the General Joumal Tab in the excel template file "Accounting Cycle Excel Template xisx". Use the following accounts as appropriate Post all of the December transactions from the "General Joumal" tab to the T-accounts under the "T-Accounts" tab in the excel ternplate file "Accounting Cycle Excel Template xisx". Assume there are no beginning balances in any of the accounts. Compute the balance for each T-account after all of the entries have been posted. Prepare the unadjusted traal balance on the "Unadusted Trial Balance" tab. 1 Provide the total of the credit column from the Unadfusted Trial Balance Record the Decomber adjusting entnies on the "General Journal tab. 31-Dec One month's insurance has expired $80. 31-Dec The remaning imventory of unused office supplios is $90. 31-Dec The estimated depreciation on equipment is $70 31-Dec Salanes incurred from December 29 to December 31 but not yet paid or recorded total $450. Post all of the adjusting entries to the T-accounts on the "T-Accounts" tab. Compute the balance for each T-aocount atter all of the adjusting entries have been posted Prepare the adjusted trial balance on the "Adjusted Trai Balance" tab. Check point 1 Adjusted trial balance total debicredit = 39,990 Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answer should be left biank.) Prepare the income Statement, Staternent of Stociduolster 's Equity and Classified Balance Shoot on tho "Funancial Statements" tab for the month ended Docember 31,20x Prepare the income. Statement, Statement of Stockholder's Equity and Classified Balance Sheet on the "Financial Statements" tab for the month ended December 31,20XX Provide the following amount from the income Statement: (Be sure to enter all numbers as positive and no answer should be left blank.) Provide the following account balances from the Balance Sheet: (Be sure to enter all numbers as positive and no answer should be left blank.) answer should be left blank.) 28 Dividends Record the dosing entries on the "General Journal" tab. Post ail of the closing entines to the T-accounts on the "T. Accounts" tab. Compute the balance for each T-account after all of the closing entries have been posted Prepare the post closing trial balance for the month ended Docember 31,20x on the Post-Closing Trial Balance tab. 29 Provide the total of the debit column from the Post Closing Trial Balance 30 Provide the balance of the Retainod Eamings T-account affer closing entries have been posted. Check Point 2: Total Assets $32,960 JESTION 2 31. Does the ending balance of the Retained Earnings t.account agree with the balance of Retained Earnings on the Balance Sheot? General Journal Description Unadjusted Trial Balance General Journal General Ledger (T-accounts) Adjusted Trial Balance Unadjusted Trial Balance December 31, 20\#\# Account Debit Credit Cash Accounts Receivable Supplies Prepaid Insurance Equipment Land Accumulated Depreciation Accounts Payable Deferred Revenue Salaries Payable Notes Payable Common Stock Retained Earnings Dividends Service Revenue Depreciation Expense Salaries Expense Supplies Expense Rent Expense Insurance Expense Totals \begin{tabular}{l} \multicolumn{1}{c|}{ Account } \\ \hline Debit \\ \hline Cash \\ \hline Accounts Receivable \\ \hline Supplies \\ \hline Prepaid Insurance \\ \hline Equipment \\ \hline Land \\ \hline Accumulated Depreciation \\ \hline Accounts Payable \\ \hline Deferred Revenue \\ \hline Salaries Payable \\ \hline Notes Payable \\ \hline Common Stock \\ \hline Retained Earnings \\ \hline Dividends \\ \hline Service Revenue \\ \hline Depreciation Expense \\ \hline Salaries Expense \\ \hline Supplies Expense \\ \hline Rent Expense \\ \hline Insurance Expense \\ Totals \\ \hline \end{tabular}