The following account balances are provided for Privy Piping, Inc. The results are for the month ending July 31, 2019. $ 21,460 359,000 96,740 2,350 150,000 172,100 325,000 241,850 750 120 300 Accounts payable Accounts receivable Accumulated depreciation Advertising expense Bank loan Cash Common stock Furniture and fixtures Interest payable Interest receivable Interest revenue Investments Loss on sale of equipment Parts and supplies Prepaid rent Rent expense Retained earnings Salaries expense Service revenue Supplies expense Unearned revenue Utilities expense 20,000 3,000 24,000 35,000 9,000 144,370 41,000 213,000 76,000 33,000 1,200 The following additional information is provided at July 31, 2019: 1) Prepaid rent expires on November 30. 2) Furniture and fixtures have a useful life of five years. 3) Unbilled services totaled $7,400 at 7/31/19. 4) Provided services worth $17,500 on prepaid contracts. 5) A physical count showed $16,750 of parts and supplies on hand at 7/31/19. 6 $12,100 of wages earned from July 27-31 will be paid in August. 7) The interest rate on the bank loan is 3%. 8) Received a $450 August cell phone bill on August 2. 9) The investment earns interest at a rate of 2.4%. 10) Federal Unemployment Insurance (FUTA) accrues at a rate of .6% of salaries expense, and is added to salary expense. The next payment is due on September 15. 11) The income tax rate is 21%. Required: a. Use Excel to create an unadjusted trial balance for Privy Piping, Inc. at July 31, 2019. b. Post all adjusting journal entries necessary on July 31, 2019 to your Excel trial balance. Create additional accounts as necessary. c. Use Excel to create the adjusted trial balance. d. Prepare a classified balance sheet and income statement at July 31, 2019