Please do it in excel or table:

Write your answer in the space provided. Show computations IN GOOD FORM after each problem. (3 to 5 minutes per problem) 1. Reconciliation of Ken Tucky Corp's bank account at January 31 is as follows: Balance per bank statement P.2,155,000 Deposits outstanding 300,000 Checks outstanding ( 50,000) Correct cash balance P 2,405,000 Balance per book P 2,407,000 Bank service charge ( 2,000) Correct cash balance P 2,405,000 February data are as follows: Bank Depositor Checks recorded 2,350,000 2,485,000 Deposits recorded 1,616,000 1,875,000 Collection by bank (w/ interest of 18,000) 418,000 NSF Check 15,000 Balances 1,944,000 1,915,000 a. How much is deposit in transit at February 28? b. How much is outstanding checks at February 28? c. How much is the adjusted cash balance at February 28