Only need the Balance Sheet (Req 4C) Follow the excel sheet Req4C that I upload and answer it as the question ask. Thank you.
Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. Follow the company's unadjusted trial balance as of December 31, 2019. 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 D. Buzes, Capital D. Buzes, 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: Unadjusted Trial Balance $ 17,000 4.000 $ 828 11, 700 32,000 0 45,000 12, 200 5,000 1,400 0 0 15,000 59, 700 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 The following Information in a through h applies to the company at the end of the current year. a. The bank reconciliation as of December 31, 2019, 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 (miscellaneous 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.) Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. Follow the company's unadjusted trial balance as of December 31, 2019. 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 D. Buzes, Capital D. Buzes, 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: Unadjusted Trial Balance $ 17,000 4.000 $ 828 11, 700 32,000 0 45,000 12, 200 5,000 1,400 0 0 15,000 59, 700 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 The following Information in a through h applies to the company at the end of the current year. a. The bank reconciliation as of December 31, 2019, 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 (miscellaneous 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.) f. The adjusted 2019 ending balances of the accounts for Warranty Expense and Estimated Warranty Liability. g. The adjusted 2019 ending balances of the accounts for Interest Expense and Interest Payable. 2. Use the results of part 1 to complete the six-column table by first entering the appropriate adjustments for items a through gand then completing the adjusted trial balance columns. Hint: Item brequires two adjustments. 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 year-end physical count. 4a. Prepare a single-step Income statement for year 2019. 4b. Prepare a statement of owner's equity (cash withdrawals during 2019 were $10,000) for year 2019 and there were no Investments by the owner in the current year. 4c. Prepare a classified balance sheet as at 2019. Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4A Reg 4B Reg 4C Prepare a classified balance sheet as at 2019. (Negative amounts should be indicated by a minus sign. Do not round your intermediate calculations.) BUG-OFF EXTERMINATORS Balance Sheet December 31, 2019 Assets Current assets: Cash S 15,750 S 679 Accounts receivable Allowance for doubtful accounts 679 16,429 Merchandise inventory Total current assets Plant assets Trucks Accum. depreciationTrucks 0 Equipment Accum. depreciationEquipment 0 0 Total plant assets Total assets Liabilities S 16,429 Current liabilities: Accounts payable
