Par 5 QUESTION 12 The following information is available for Andersen Company for the month ending June 30, 2013 Balance per the bank statement is $10.241.43. - Balance per books is $9,745.06. . Check #506 for $1.948.52 and check 510 for $1,800.25 were not returned with the June 30 bank statement. A deposit in transit of $5,113.40 had not been received by the bank when the bank statement was generated. . A bank debit memo indicated an NSF check in the amount of $79 written by Bruce Garrett to Andersen Company on June 13. A bank credit momo indicated a note collected by the bank of $1,900 and interest revenue of $75 on June 20. The amount represented settlement of an outstanding balance by one of Andersen's customer The bank statement indicated service charges of $35. Required: 1. Prepare the company's adjusted cash book based on the information presented. (5 Marks) 2. Prepare the bank reconciliation statement based on the info presented