pleasw answer all parts on excel if possible . thank you

2. From the following particulars of Purple New Co., prepare the bank reconciliation statement as on May 31, 2016. a. b. c. d. The bank statement balance is $4,000. The cash account balance is $3,950. Outstanding checks amounted to $960. Deposits in transit are 5900 The bank service charge is $75. Interest added to the checking account by the bank is $150. A check drawn for $65 was incorrectly charged by the bank as $150. e. f. Bank Balance May 31, 2016 Adjusted Bank Balance Cash Balance May 31, 2016 Adjusted Book Balance