IMPORTANT: READ INSTRUCTIONS CAREFULLY. A spreadsheet is provided with the exam on Blackboard. Download the spreadsheet, save it with your name in the file name (301 Final Stout, for example). There are three worksheets/tabs, one for each problem on this exam. Complete the exam in the spreadsheet, then submit the spreadsheet through Blackboard. Problem # 1, 20 points You obtain the following information about a corporate bank account you've been assigned to reconcile. The company is Arthur Corporation. 1. The balance at 4/30/2022 on the bank statement is $14,632.12 2. Checks outstanding (written but not presented to the bank) totaled $1,320.25 3. Cash receipts from March 30, amounting to $575.00, were not deposited at the bank until May 2. 4. A check written in payment of services for $246 was incorrectly recorded by Arthur Corporation's accountants as a $264 amount (the expense was postal services). 5. The bank paid $450 due on a note payable to the bank on March 30, of which interest expense is $350. Arthur's accountant did not record that payment. 6. The bank listed service charges of $14 on the statement, withdrawn from the account on March 30. 7. A deposit of $875 was included in the statement, but the deposit does not belong to Arthur Corporation, it belongs to a different company, whose name is unknown. 8. A check from a customer was returned by the bank (with the statement) for non-sufficient funds. The check had been deposited on March 29, and amounted to $85. 9. A payment of $200 was made by the bank on March 29 for blank checks, ordered by Arthur's accountants. The payment has not been recorded by Arthur. Your assignment: A. Prepare a bank reconciliation showing that you have identified all differences between the bank and Arthur's general ledger. The reconciliation must be clearly organized (look in the book for examples). Illustration 7A-2 (on page 375 or 376 of the book) is a good format. B. Prepare any journal entries for items not recorded by Arthur and to correct any mistakes. For example, items #4 and #5 (there may be others to record).