(Do it on microsoft excel and paste it here, so I can copy the answer text easily) Thanks in advance

2. Trial balance column in the worksheet for Peter Roofing at April 30, 2020 are as follows: Credit (S) Debit ($) 9.000 6,400 1,920 2,880 22.000 No Account 1 Cash 2 Account receivables 3 Supplies 4 Prepaid insurance 5 Equipment 6 Accumulated Depreciation - Equipment 7 Account payable 8 Unearned services Revenue 10 Owner's Capital 11 Owner's Drawing 12 Service Revenue 13 Salaries and Wages expenses 2,500 5,000 1,100 25,800 2,200 12,600 2.600 S8/01/20 Page 1 Other data that need to be adjusted at the end of the month (30 April 2020) are a. Supplies on hand is $500 b. Depreciation of the equipment for 1 year is $3.000 e. One-twelfth of the insurance expired d. Accrued utilities expenses S750 Required: a. Enter the trial balance in worksheet and complete the worksheet. b. Prepare income statement c. Prepare owner's equity d. Prepare balance sheet (10 marks) (10 marks) (10 marks) (10 marks)