Prepare joumal entries to record the December transactions in the General Joumal Tab in the excel template file "Accounting Cycle Exce Template x is x. Use the following accounts as appropriate: Post all of the December transactions from the "General Journal" tab to the T-accounts under the "General Ledger/T-Accounts" tab in the exce template 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 trial balance on the "Unadjusled Trial Balance" tob. 1 Provide the tolal of the credit column from the Unadjusted Trial Balance Recoed the Docomber ad,usting entries on the "General Journal' tab. 31-Dee One month's insurance has expired $70 31.Dec The remaining inventory of unused office supplies is $90. 31-Dec The estimated depreciation on equipment is $80. 31.Dec Salaries incurred from December 29 to December 31 but not yet paid or recorded total $540. entries have been posted. Step 7 Prepare the adputed trial balance on the "Adjusted Trial Balance" tab. Check point 1: Adjusted trial balance total debitcredit = 533,280 Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answer should be left blank.) 2 Cash Prepare the adjusted trial balance on the "Adjusted Trial Balance" tab 533.280 Check point 1 Adjusted trial balance total debiticredit = Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answer should be left blank.) Prepare the income 5 tatement, Staloment of Stockholders Equity and Clasaifed Batance Sheet on the "Financial Statementa" tab for the morth ended December 31,20xx Provide the following amount trom the income Statament: (Be sure to enter all numbers as positive and no answer should be left. binnk ) Prepare the Income Statement, Statement of Stockholdor's Equity and Classified Balance Sheet on the "Financial Statements" tab for the month ended December 31,20x. Provide the following amount from the Income Statement: (Be sure to enter all numbers as positive and no answer should be left blanki) Provide the following account balances from the Balance Sheet: (Be sure to enter all numbers as positive and no answer should be left blank.) Cument Assets 23. Long-Term Assets 24 Current Liabilities 25. Long-Term Liabillas 26 Total Liatisties 27 Total Stocktolder's Equity Provide the following account balance from the Statement of stockholders' Equity: (Be sure to enter all numbers as positive and no answer should be left blank.) sec10 Post all of the closing ontries 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 Sinp 11: Prepare the post closing trial balance for the month ended December 31,20 on the Post-Closing Trial Balarice tab. 29 Provide the total of the debit column from the Post Closing Trial Balance 30 Provide the balance of the Retained Earnings T-account affer closing entries have been posled. Check Point 2: Total Assets 525,710