Provide the following accounts balances from the Adjusted Trial Balance (Please enter all amounts as a postive number. No brackets.) Cash Accounts receivable Allowance for unccllectible accounts Inventory Notes receivable Interest receivables Equipment Accumulated depreciation Accounts payable Common stock Retained earnlngs Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciatlon expense Income tax expense Prepare the Multi-step lncome Statement, Statement of Stockholder's Equity. and Class'riied Balance Sheet under the Required #5. 'Financial Statements' tab for the month ended December 31. ZUXX in the excel template le "Accounting Cycle proiect 2 Excel Templatexlsx\". Provide the following amount from the Multislep Income Statement Net sales Gross prolil Operating income Nonroperatlng revenue Income before income taxes Net income Provide the following amount from the Classied Balance sheet: Current assets Net accounts receivables [Net realizable value] Long-tenn assets (Book value) Total liabilities Total stockholder's equity Check point Total assets $170,230 Required #5 Dec 31. Dec 31. Dec 31. Dec 31. Required #7 Required #8 Required #5 u, c... we]... 5 .4\".-. .c...piu....n._m . Provide The total of the debit column from The Unadjusted trial balance Record the following four transactions as adjusting entries under the \"General Journal' tab. The company estimates 20% of The ending balance of accounts receivables is not going to be collected [Hint Remember to consider the balance in The allowance for uncollectibe account if any] Record Decembel's adjustmentto accrue interest for the notes receivables. The company uses the lower of cost or net realizable value method for inventory valuation. The net realizable value of the inventory is $12 per unit. Make the adjusting entry ifnecessary. Calculate depreciation using Straight line method. The equipment purchased has a useful life of 72 months and no residual value. Record the depreciation for the monTh of December. Post all of The adjusting entries to the Tsaccounts under the \"TsAccounts (General Ledger)" tah Compute The balance for each Tiaccount after all ofthe adjusting entries have been poed. These are The adjusted balance as of December 31 Prepare The adjusted trial balance under the \"Adjusted Trial Balance" lab as of December 31 in the excel template le "Accounting Cycle project 2 Excel Template.xlsx" . Provide The following accounts balances from the Adjusted Trial Balance. (Please enter all amounts as a postive number. No bmckets.) Cash Accounts receivable Allowance for uncollectible accounts Inventory Notes receivable Interest receivables Equipment Accumulated depreciation Accounts payable Common stock Retained eamlngs Sala revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Prepare The Multi-step income Statement, Statement of Stodcholder's Equity, and Classied Balance Sheet under the \"Financial Statements\" Tab for the month ended December 31, ZDXX in the excel template le "Accounting Cyde project 2 Excel Templatexlsx" Provide The following amount from the Multi-step Income Statement; Net sales Gross profit Operating income The foliowing information is given at the beginning ofDecember. Debit Credit Cash $71500 Accounts receivables 529.000 Allowance for uncoliectibie accounts $11,000 Inventory (1,500 units at $9) 513.500 Accounts payable 527.800 Common stock 545.000 Retained earnings $30200 Total Required. #1 Required. #2. Dec. 1. Dec. 1 Dec. [5 Dec 12. Dec 20. Dec 23. Dec 25'. Dec 30. Required' #3 Required' #4 Required: #5. Required #5 Dec 31. $114,000 $114,000 Enter the beginning balance tor each account in the Teaccounts (General Ledger) tab in the excei template tile "Accounting Cycie Projed 2 Excel Templatexisx". Prepareioumai entries to record the December transactions in the General Journal Tab in the excel template le "Accounting Cycie Projed 2 Excel Template xisx". Use the toiiowing accounts as appropriate: Cash. Accounts receivable. Allowance for uncollectible accounts' inventory, Notes receivabi, Inteer receivabla, Equipment, Accumuiated depreciation Accounts payable. Common stocic Retained earnings, Sales revenue. Interest revenue. Cost of goods sold. Depreciation expense. Bad debt expense. Income tax expense. Used cash to purchase equipment at a purchase price 015511400. plus tax $300, plus shipping $700. Lend $13,001] to an empioyee by receiving a note for six months at annual interest rate of 12% due at the maturity date. Purchase 4.600 units of inventory on account at $14 per unit for a totai cost 01 $64,400. Assuming the perpetuai method is used. the company sold 3200 units at $23 each on account. ten-n5 2110. nill]. Calculate the cost of goods sold using the FIFO method and record the appropriate journal entries tor the saie and the cost of the sale. (Hint. Make sure to consider the beginning inventory balance from the beginning trial balance) Paid $26000 to suppiiers for purchases made on account in the prior month. Received cash 01 $20,000 for sales of inventory made on account on December 12. Writeo $3,500 oi accounts receivables using the ailowance method. Paid $6,000 tor income tax for the month ofDecember Post ali ot the December transadions from the \"General Joumai\" tab to the Teaccou nts under the "TeAccounts (General Ledger)\" tab in the excel tempiate le \"Accounting Cvde proied 2 Excel Template xlsx" Make sure to inciude beginning balances for accounts where necessary Compute the balances for each Taccount after ali of the entries have been posted. These are the unadjusted balance as of December 31. Prepare the unadjusted triai baiance under the 'Unadjusted Trial Balance\" tab in the excel template ie "Accounting Cycle projed 2 Excel Tempiale xlsx" . Provide the totai oi the debit column from the Unadjusted trial balance Record the following four transactions as adjusting entries under the \"Generai Journal' tab. The company estimates 20% of the ending balance of accounts receivables is not going to be coileded [Hint Remember to consider the balance in the allowance for uncollectibe account. it ant! Date General Journal Description Debit Credit Begin Bal. $ Cash 71,550 End Bal. Begin Bal. Account receivables $ 29,000 End Bal. Allowance for uncollectible accounts Begin Bal $ 11,000 Begin Bal $ Inventory 13,500 Notes receivables Begin Bal. Accounts payable $ 27,800 Interest receivables Equipment Accumulated depreciation yable Begin Bal Common stock $ 45,000 Begin Bal. Retained earnings $ 30,200 Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Unadjusted Trial Balance Accounts Debit Cash Accounts receivables Allowance for uncollectible accounts Inventory Notes receivables Interest receivables Equipment Accumulated depreciation Accounts payable Commonstock Retained earnings Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Totals Credit Adjusted Trial Balance Debit Cash Accounts receivables Allowance for uncollectible accounts Inventory Notes receivables Interest receivables Equipment Accumulated depreciation Accounts payable Commonstock Retained earnings Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Totals Credit Multi-step Income Statement For the month Ended December 31, 20XX Statement of Stockholders' Equity For the month Ended December 31, 20XX Classified Balance She At December 31, 20XX Classified Balance Sheet At December 31, 20XX