Please finish the Project with the question in the picture, and type the answer with the Excel. The check point asset is: $122680. Thank you so much!

6 Chrome Tp Chinh sr'ra Xem Lich si'r Diutrang Moinglroi Ct'ra 56 Tro giup M19 2. 6) >8 '5? 1) g amm- 9:300HTh601thg12 Q . . Q wcrchla : x\\1; 4;\" It) g 3mm 9:300HTheo1rhg12 Q m Take Test: I x 7/ C' 0 j i Bo mtl https://dcccd.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_786728_1&course_id=_179492_1&content_id=_11060887_1&step... Q j E Required: #4. Required: #5. Required: #6. Dec31. D6C31. Dec31. Dec31. Required: #7. Required: #8. Compute the balances for each T-account after all of the entries have been posted. These are the unadjusted balance as of December 31. Prepare the unadjusted trial balance under the \"Unadjusted Trial Balance\" tab in the excel template le 'Accounting Cycle project 2 Excel Template.xlsx" . 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 December's adjustment to 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 $5.5 per unit. Make the adjusting entry it necessary. 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 T-acoounts under the \"T-Aocounts (General Ledger)\" 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. Prepare the adjusted trial balance under the \"Adjusted Trial Balance" tab as of December 31 in the excel template file "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 brackets.) Cash Accounts receivable Allowance for uncollectible accounts Inventory Notes receivable Interest receivables Equipment Accumulated depreciation Accounts payable Common stock Retained earnings Sales revenue Interest revenue Cost of goods sold dick Save and Submit to save and submit. Click SaveAll Answers to save all answers. Save All Answers Save and Submit ' @j Spiceland4e_Ch06.pptx 3 Accounting cycle proj....x|sx ' D Lcc Nguyen- Account....xlsx ' i Hi'n thinitca x 6 Chrome Tep Chinh sfra Xem Lich sfr Dutrang Moi nglroi Ct'ras Trogiup M19 R Q {9 >[i \"a? It) 5 81% [ 9:300HTh601 my 12 Q m Take Test: I x i Bo mt i https://dcccd.blackboard.com/webapps/assessment/take/Ieunch.jsp?course_assessment_id=_786728_1&oourse_id=_179492_1&content_id=_11060887_1&step... J Inventory Notes receivable Interest receivables Equlpment Accumulated depreciation Accounts payable Common stock Retained earnings Sales revenue Interest revenue Cost of goods sold Bad debt expense Depreciation expense Income tax expense Prepare the Multi-step Income Statement, Statement of Stockholder's Equity, and Classied Balance Sheet under the Required: #9. \"nancial Statements" tab for the month ended December 31, 20)0( in the excel template le 'Acoounting Cycle proiect 2 Excel Templatexlsx'. Provide the following amount from the Multi-step Income Statement: Net sales Gross prot Operating income Non-operating 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-term assets (Book value) Total liabilities Total stockholdel's equity Check point: Total assets $122,680 " Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers Save and Submit ' Spicelend4e_ch06.pptx ' Accounting cycle proj....xlsx ' Date General Journal Description Debit 1-Dec Equipments Cash $ 1-Dec Notes receivable Cash $ 6-Dec Inventory Accounts payable $ Credit 25,200 $ 25,200 $ 14,000 $ 40,950 $ 67,200 $ 30,000 $ 29,000 $ 16,500 $ 2,900 $ 4,600 $ 9,680 $ 100 $ 3,000 $ 150 14,000 40,950 12-Dec Accounts receivables Sales revenue Cost of goods sold Inventory $ 67,200 $ 30,000 20-Dec Accounts payable Cash $ 23-Dec Cash Accounts receivable $ 28-Dec Allowance for uncollectible accounts Accounts receivables $ 30-Dec Income tax expense Cash $ 31-Dec Bad debt expense Allowance for uncollectible accounts $ 31-Dec Interest receivable Interest revenue $ 31-Dec Cost of goods sold Inventory $ 31-Dec Depreciation expense Accumulated expense $ 29,000 16,500 2,900 4,600 9,680 100 3,000 150 Beginning $ 23-Dec $ Balance $ Cash 68,500 $ 10,800 $ 10,000 17,000 $ 20,000 $ 4,800 39,900 Account receivables Beginning $ 23,000 $ 17,000 12-Dec $ 70,400 $ 3,000 Balance $ 1-Dec 1-Dec 20-Dec 30-Dec 23-Dec 28-Dec 73,400 Allowance for uncollectible accounts 28-Dec $ 3,000 $ 8,000 Beginning $ 5,000 Balance $ 9,680 31-Dec $ 14,680 Balance Beginning $ 6-Dec $ Balance $ 1-Dec $ Inventory 9,000 $ 31,000 44,000 $ 3,000 19,000 Notes receivables 10,000 Interest receivables 31-Dec $ 100 12-Dec 31-Dec Accounts payable 20-Dec $ 20,000 $ 26,000 $ 44,000 $ 50,000 1-Dec $ Equipment 10,800 Accumulated depreciation $ 150 31-Dec ayable Beginning 6-Dec Common stock $ 45,000 Beginning $ 45,000 Balance Balance Retained earnings $ 21,500 Beginning $ 21,500 Balance Sales revenue $ 70,400 $ 12-Dec 70,400 Balance Interest revenue $ 100 Cost of goods sold 12-Dec $ 31,000 31-Dec $ 3,000 Balance $ 34,000 Bad debt expense 31-Dec $ 9,680 31-Dec Depreciation expense 31-Dec $ 150 Income tax expense 30-Dec $ 4,800 Unadjusted Trial Balance Accounts 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 Debit Credit $ 39,900 $ 73,400 $ 5,000 $ 22,000 $ 10,000 $ 10,800 $ $ $ $ $ 31,000 $ 4,800 $ 50,000 45,000 21,500 70,400 191,900 $ 191,900 Adjusted Trial Balance Debit Cash $ 39,900 Accounts receivables $ 73,400 Allowance for uncollectible accounts Inventory $ 19,000 Notes receivables $ 10,000 Interest receivables $ 100 Equipment $ 10,800 Accumulated depreciation Accounts payable Commonstock Retained earnings Sales revenue Interest revenue Cost of goods sold $ 34,000 Bad debt expense $ 9,680 Depreciation expense $ 150 Income tax expense $ 4,800 Totals $ 201,830 Credit $ 14,680 $ $ $ $ $ $ 150 50,000 45,000 21,500 70,400 100 $ 201,830 Multi-step Income Statement For the month Ended December 31, 20XX Net sales Cost of goods sold Gross profit Operating expense Bad debt expense Depreciation expense Total Operating income Non-operating expense Interest revenue Total Income before income tax Income tax expense Net Income $ $ $ $ $ $ 70,400 34,000 36,400 $ $ 9,830 26,570 $ 100 $ $ $ 26,670 4,800 21,870 9,680 150 100 Statement of Stockholders' Equity Classified Balance For the month Ended December 31, 20XX At December 31, Common StRetained Earn Total Stockholder' Assets Beginning $ 45,000 $ 21,500 $ 66,500 Current assets Issuance of common stock Cash Add: Net income $ 21,870 ### Account receivables Less: Dividend Allowance for uncollectibl Ending Balance $ 45,000 $ 43,370 $ 88,370 Net accounts receivable Inventory Notes receivables Interest receivables Total Long-term assets Equipment Accumulated depreciation Net fixed assets Total assets Classified Balance Sheet At December 31, 20XX $ 39,900 $ 73,400 $ (14,680) $ 98,620 $ 19,000 $ 10,000 $ 100 $ 127,720 $ 10,800 $ (150) $ 10,650 $ 138,370 Liabilities Current liabilites Accounts payable Total Stockholders' equity Common stock Retained earnigs Total $ $ 50,000 50,000 $ $ $ 45,000 44,320 88,370 Total liabilities and stockhold $ 138,370