please answer on an excel sheet

3 Problem 2 You are engaged in the audit of Metatron, Inc., and have gathered the following information about the firm's cash account balance at December 31, 20x2. a) The cash account (in summary form) is as follows: Cash $7,173 38,920 Balance Dec 1, 20x2 Disbursements for December Receipts for December 36,620 b) The bank statement for December contained the following: $ 7,182 35,962 39,029 Balance, November 30, 20x2 Total deposits and other credits Cheques and other debits (Including a service charge of S14, an NSF cheque of $58, and interest on the line of credit of $516) The cheques and other debits above also include a cheque written by Silver Corporation in the amount of $135. The bank was advised of this error and will adjust the account in January 20x3. Cheque # 1153 made out to Witches Security Services in the amount of S356 was recorded on the books at $365. The correct amount is $356. d) Deposit in transit, December 31, $500 e) On December 10, the company failed to record a deposit made to the bank totalling $214. The $214 represented the cash sales for the day. The only cheque outstanding at December 31 was cheque # 1046 in the amount of $242, which was also outstanding at November 30. Required Caleulate the correct cash balance at December 31, 20x2 and prepare any adjusting entries. Prepare a bank reconciliation statement for December a) b)