The following information is available for Miguel Company for the month ending June 30, 2017 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 s5,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 CARS Company to Miguel Company on June 13. A bank credit memo indicated a note colected by the bank of $1,900 and interest revenue of $75 on June 20 . The bank statement indicated service charges of $34 Requirements: 1. Prepare the necessary joumal entries in the books of 2. Prepare the adjusted cashi book and determine the ending balance based on the 3. Prepare Miguel Company bank reconcilation for June 2017 the information presented. Include a narrationexplanation for journal entry prepared adjustmonts done