Show work and if you can please do in Excel Format

Also answer must include Worksheet, Income Statement, Statement if Owners Equity, Balance Sheet, Journal Entries. Thank your will give good review.

CP 9 Bug-Off Exterminators provides pest control services and sells extermination products manufac- tured by other companies. The following six-column table contains the company's unadjusted trial bal- ance as of December 31, 2019. E 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 15,000 10,000 49,700 December 31, 2019 Cash.. Accounts receivable Allowance for doubtful accounts Merchandise inventory Trucks. Accum. depreciation - Trucks Equipment Accum. depreciation-Equipment Accounts payable Estimated warranty liability. Unearned services revenue Interest payable. Long-term notes payable Common stock Retained earnings. Dividends... 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 Totals 10,000 60,000 872 71,026 46,300 0 0 35,000 0 9,000 0 1,226 8,000 6,800 0 $226,026 $226,026 376 Chapter 9 Ang for Current 12450 52 The following information in through applies to the company at the end of the current year a. The bank reconciliation as of December 31, 2019, includes the following fact Casper 111,100 Cash books 17.000 red on an account Dhe 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 accountable) b. An examination of customer accounts show that accounts totaling $679 should be written off uncollectible. Using an aning of receivables, the computty determines that the ending balance of the Allowance for Doubdul Accounts should be 5700 . A truck is purchased and placed in service on January , 2019. les cost is being depreciated with the straight-line method wing the following facts and estimates $12.000 that the bar d. Two item of equipment fa sprayer and an injector) were purchased and put into service in carly January 2017. They are being depreciated with the straight-line method using these facts and estimates 4 DOO Sorayer Origo Expected age ST.000 53.000 510.000 $7.500 O Aupust 1, 2019, the company is paid 53.840 cash in advance to provide moothly 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 The company offers a warranty for the services itsells. The expected cost of providing warranty vice is 2.3% of the extermination services revenue of 557,760 for 2019. No warranty expense has been recorded for 2019. All costs of servicing warranties in 2019 were property debited to the Estimated Warranty Liability account 9. The SIS.00 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, 2019. h. The ending inventory of merchandise is counted and determined to have a cost of $11.700. Bug-Off wes a perpetual inventory system. Check Record 1.115.750 Host 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 b. Adjustment needed to obtain the correct ending balance of the Allowance for Doubtful Accounts. c. Depreciation expense for the truck used during year 2019, d. Depreciation expense for the two items of equipment used during year 2019, e. The adjusted 2019 ending balances of the Extermination Services Revenue and Unearned Services Revenue accounts The adjusted 2019 ending balances of the Warranty Expense and the Estimated Warranty Liability punts The adjusted 2019 ending balances of the Interest Expense and the Interest Payable accounts, (Round amounts to nearest whole dollar) 2. Use the results of part to complete the six-column table by first entering the appropriate adjustments for item through and then completing the Adjusted Trial Balance columns Mint: Item requires Iwe adjustments 3. Prepare journal entries to record the adjustments entered on the column table. Assume Bug-off's adjusted balance for Merchandise Inventory matches the year-end physical count. 4. Prepare a single-step income statement, a statement of retained earnings (cash dividends during 2019 were $10.000), and a classified balance sheet. QA 5230207