The first Three questions are the Serial Problem.... The numbers need to go Into the excel sheet on the three additional pictires provided please add the answers to the excel documents Thank You!

CP 11 Bug Off Exterminators provides pest control services and sells extermination products manufactured by other companies. The following six column table contains the company's unadjusted trial balance as of December 31, 2021. Unadjusted Trial Balance Adjusted Trial Balance Adjustments $ 17,000 4,000 $ 828 11,700 32,000 0 45,000 12.200 5,000 1,400 0 0 December 31, 2021 Cash Accounts receivable Allowance for doubtful accounts Merchandise inventory Trucks Accum. depreciation--Trucks Equipment Accum depreciation-Equipment Accounts payable Estimated warranty liability Uneamed services revenue Interest payable Long-term notes payable D. Buggs, Capital D.Buggs. Withdrawals Extermination services revenue Interest revenue Sales (of merchandise) Cost of goods sold Depreciation expense --Trucks Depreciation expense--Equipment Wages expense Interest expense Rent expense Bad debts expense Miscellaneous expense Repairs expense Utilities expense Warranty expense Total 15,000 59,700 10,000 60,000 872 71026 46,300 0 0 35.000 0 9.000 0 1.226 8.000 6.800 $226,020 $226,020 The Tonowmg mormation througy applies to the company at the end of the current year. a. The bank reconciliation as of December 31, 2021. includes the following facts. Cash balance per bank Cash balance per books Outstanding checks Deposit in transit Interest earned (on bank account) Bank service charges (mitcellaneous expense) $15.100 17,000 1,800 2,450 52 15 Reported on the bank statement is a canceled check that the company failed to record. (Information from the bank reconciliation allows you to determine the amount of this check, which is a payment on an account payable.) b. An examination of customers' accounts shows that accounts totaling $679 should be written off as uncollectible. Using an aging of receivables, the company determines that the ending balance of the Allowance for Doubtful Accounts should be $700. c. A truck is purchased and placed in service on January 1, 2021. Its cost is being depreciated with the straight line method using the following facts and estimates. Original cost Expected salvage value Useful life (years) $32,000 $8,000 d. Two items of equipment (a sprayer and an injector) were purchased and put into service in early January 2019. They are being depreciated with the straight line method using these facts and estimates. Original cost Expected salvage value Useful life (years) Sprayer Injector $27,000 $18,000 $ 3.000 $ 2.500 5 e. On August 1, 2021, the company is paid $3,840 cash in advance to provide monthly service for an apartment complex for one year. The company began providing the services in August. When the cash was received the full amount was credited to the Extermination Services Revenue account f. The company offers a warranty for the services it sells. The expected cost of providing warranty service is 2.5% of the extermination services revenue of $57,760 for 2021. No warranty expense has been recorded for 2021. All costs of servicing warranties in 2021 were properly debited to the Estimated Warranty Liability account 1. The company offers a warranty for the services it sells. The expected cost of providing warranty service is 2.5% of the extermination services revenue of $57,760 for 2021. No warranty expense has been recorded for 2021. All costs of servicing warranties in 2021 were properly debited to the Estimated Warranty Liability account 8. The $15,000 long-term note is an 8%, five year, interest bearing note with interest payable annually on December 31. The note was signed with First National Bank on December 31, 2021. h. The ending inventory of merchandise is counted and determined to have a cost of $11,700. Bug-Off uses a perpetual inventory system. Required 1. Use the preceding information to determine amounts for the following items. a. Correct (reconciled) ending balance of Cash; and the amount of the omitted check. Check (1 Reconciled cash bal $15,750 b. Adjustment needed to obtain the correct ending balance of the Allowance for Doubtful Accounts. (16) $551 credit c. Depreciation expense for the truck used during year 2021. d. Depreciation expense for the two items of equipment used during year 2021. e. The adjusted 2021 ending balances of the Extermination Services Revenue and Unearned Services Revenue accounts. 1. The adjusted 2021 ending balances of the Warranty Expense and the Estimated Warranty Liability accounts, in Estimated Warranty aby $2044C 8. The adjusted 2021 ending balances of the Interest Expertise and the Interest Payable accounts. (Round amounts to nearest whole dollar.) 2. Use the results of part I to complete the six column table by first entering the appropriate adjustments for items a through s and then completing the Adjusted Trial Balance columns. Hint. Item b requires two adjustments. 2 Adjusted trial balance totais. $238.207 3. Prepare journal entries to record the adjustments entered on the six-column table. Assume Bug-Off's adjusted balance for Merchandise Inventory matches the yearend physical count, 4. Prepare a single step income statement, a statement of owner's equity (cash withdrawals during 2021 were $10,000 and owner Investments were $0), and a classified balance sheet. 14) Net income $9.274 Total assets $82.771 M N P Adjusted Trial Balance Use Feerences and show supporting csousons on nestab Then do the journal erine Then prepare the Financial Statements from the Add To Blance DLF G H Bug or exterminators 31 Dec 15 Give references for the Unadjusted RE adjustments Ital Balance Adments... Cash 17000 6 Accounts receivable 4000 Allowance for doubtful 828 B Merchandise inventory 11700 9 Trucks 32000 0 Accum. deprec-Trucks 0 T1 Equipment 45000 Accum depres Equip 12200 Accounts payable 5000 * Estim warranty liability 1400 Uneaned services rev 0 Interest payable 0 y long term notes payable 15000 D Bugar. Capital 59700 D Buggs. Withdrawals 10000 Extermination Services 20 60000 Reven Interest revenue 872 22 Sales 71026 23 Cost of goods sold 46300 24 Deprec, expense Trucks 0 25 Depree expense Equip 0 25 Wages expense 35000 27 Interest expense 0 28 Rent expense 9000 0 Bad debts expense 29 30 Miscellaneous expense 1226 31 Repairs expense 3000 Utilities expense 6800 30 Warranty pente 0 34 Totals 9225.0126226.126 35 WORKSHEET Show supporting Calculations General Journal Financial Statements -Good Ready Accessibility investigate GENERAL JOURNAL Name of company and Year Please leave one row che) between each journal entry Date Account Tities and Explanation P.R. Debit Credit 1 2 3 4 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Show supporting Calculations General Journal Financial Statements Good WORKSHEET Sessibility WN A B C D E F G H 1 Prepare an Income Statement, Stmt of Owners' Equity (Cash withdrawals of $10,000 for the year, and a classified Balance Sheet. 2 3 4 5 6 7 8 N- 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 wwwn 28 30 General Journal Financial Statements -Good form Show supporting Calculations are