SOLVE A , B , C , D ON EXCEL

P4.3A (LO 1, 2, 4) Financial Statement The completed financial statement columns of the work- sheet for Bray Company are shown as follows. Cr. Bray Company Worksheet For the Year Ended December 31, 2020 Account Income Statement Balance Sheet No. Account Titles Dr. Cr. Dr. 101 Cash 8,800 112 Accounts Receivable 10,800 130 Prepaid Insurance 2,800 157 Equipment 24,000 158 Accumulated Depreciation Equip. 4,200 201 Accounts Payable 9.000 212 Salaries and Wages Payable 2,400 301 Owner's Capital 19,500 306 Owner's Drawings 11.000 400 Service Revenue 60,000 622 Maintenance and Repairs Expense 1,700 711 Depreciation Expense 2,800 722 Insurance Expense 1,800 726 Salaries and Wages Expense 30,000 732 Utilities Expense 1,400 Totals 37.700 60.000 57,400 35.100 Net Income 22,300 22.300 60,000 60,000 57,400 57,400 Instructions a. Prepare an income statement, an owner's equity statement, and a classified balance sheet. b. Prepare the closing entries. L. Bray did not make any additional investments during the year. c. Post the closing entries and underline and balance the accounts. (Use T-accounts.) Income Sum- mary is account No. 350. d. Prepare a post-closing trial balance