Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF v Midterm+Exam+BUSI+1004+W22+Workbook-3 Home Insert Draw Page Layout Formulas Data Review View Tell me X v Arial 11 A A = Wrap Text General Paste B 7 U w & A x == Merge & Center %" * Cell Insert Delete Format Conditional Format Formatting as Table Styles L32 x fx A B D E F G H 1 . K L M N 1 Question 1. 7 marks (approx. 12 minutes) Enter your answer below 2 3 The December 31, 2021 bank statement for Microsoft Inc has just arrived. 4 You are asked to prepare the December 31, 2021 bank reconciliation. 5 6 1) The cash account in your general ledger as at Dec 31 has an unadjusted balance of $64,910 7 82) The ending balance on the Dec 31 bank statement was $88,585 10 3) The following is a list of cheques that were wrillen before year-end and their status. Date Withdrawn from Bank Account $1,215 December 2.2021 $955 January 4, 2022 11 12 Cheque N Amount 13 CHQ 001 14 CHQ 002 15 CHQ 003 16 CHQ 004 17 $780 Not yet cashed $2,150 Not yet cashed 18 4) The following cash deposits were made in December. It takes two business days to process all deposits. 19 20 21 22 23 Deposit # Amount Date of Deposit DEP 001 $1,390 December 16, 2021 DEP 002 S650 December 31, 2021 24 5) The December bank statement contained $55 of bank service charges. These have not yet been recorded into the general ledger. 25 26 6) A customer deposited $710 directly into Microsoft Inc's bank account during the month. The accountant saw this on the bank statement for the first time. 27 28 7) The December bank statement contained a returned cheque from a customer (non-sufficient funds) in the amount of $236. This cheque was originally deposited in November. 29 30 Required: 31 A) Prepare the journal entries for any required adjustments to the general ledger and calculate the adjusted balance of cash per books. 32 B) Prepare a bank reconciliation. 33 34 35 36 Provide your solution here 37 38 ) 39 Dr Bank service charge 40 Cr Cash 55 55 41 42 Cash 43 Accounts receivbale 710 710 44 Ready Q1 02 Q3 + 0 WA Sat Mar 5 11:28 AM Share Comments v Sort & Filter Find & Select Analyze Data P Q R S T U V Vi 100%