HOME DATA VIEW Ca Font Name Font Size TabStop Wrap Text EE E Insert Column Delete Col Copy B 4 Overline Merge Cell 3-Insert Row 2 Delete Row CK HERE TO SAVE YOUR WORK B216 A B C D E F G H 239 ABC Limited Bank Statement June 30 Amounts Deducted from Amounts Added, to 56 Date 7 May 31 58 Description Account (Debits) Account (Credits) Balas 15,180 59 Jun. 1 Cheque, No. 2500 1 Deposit 2,560 12,620 4,800 17,420 0 2 Cheque, No. 2501 1,370 16,050 1 4 Deposit 3,720 19,770 72 8 Cheque, No. 2503 6,530 13,240 73 9 Returned cheque- NSF, K. Price 925 12,315 74 NSF Fee 30 12,285 75 11 Deposit 5,875 18,160 76 16 Cheque, No. 2504 3,455 14,705 77 23 Deposit 6,430 21,135 78 29 Cheque, No. 2508 1,375 19,760 79 30 Bank service charges 50 19,710 80 81 ABC's cash receipts and payments for the month of August are presented below: 82 Cash Receipts 83 Date Amount 84 Jun. 4 $3,720 85 86 11 5,875 23 6,430 87 30 8,390 88 $24,415 89 190 91 92 93 Date Cash Payments Number Amount Jun. 6 68352222 2503 $6,530 2504 3,455 13 2505 1,020 15 2506 750 19 2507 1,500 2508 1,375 2509 2,800 29 2510 3,350 $ 20,780 194 Required: 195 i) (3.5 marks). Calculate the cash balance per books at June 30, prior to reconciliation. 03 ii) (1.5 marks). Determine the amount of deposits in transit at June 30. 04 05 06 07 08 09 10 iii) (6 marks). List the outstanding cheques at June 30. 157 C 158 ABC Limited reconciled cash balance per bank, $14,250, agreed with the reconciled cash balance per book after the bank reconciliation at May 31. The 159 reconciliation shows a deposit in transit for $4,800 and three outstanding cheques: #2500-$2,560, #2501-$1,370 and #2502-$1,200. The June bank 160 statement showed the following