show all steps and reasoning.

Problem 2 (6 marks) On December 31, the balance of cash in DOWELL's books was $25,800, and the bank statement on the same date showed a balance of $28,750. An examination of the bank statement revealed the followings: Deposit in transit: $8,500 Outstanding cheques: $15,400 Electronic fund transfer collections: $7,200 NSF cheque: $9,400; NSF fee: $100 A deposit of $17,500 on December 18 was recorded by the bank as $15,700 Bank charge: $150 - - Instructions Prepare the company's bank reconciliation at December 31 (use the template below) Books ($) Bank (S) Balance per (before reconciliation) 25,800 28,450 Adjusted balance