I need help with this assignment. #1 - #4. The instructor keeps docking points because I don't use double lines under balances. It needs to be in an excel type format. Thank you in advance.

Obj.5 P5-4 Bank reconciliation and entries Rancho Foods deposits all cash receipts each Wednesday and Friday in a night deposi- tory, after banking hours. The data required to reconcile the bank statement as of May 31 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters 1. Adjusted balance: $10,798.88 CASH ACCOUNT: Balance as of May 1 $9,578.00 $5,255.89 CASH RECEIPTS FOR MONTH OF MAY DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in May: Date May 2 Amount $569.50 701.80 189.24 Date May 12 19 Amount $580.70 600.10 701.26 Date May 23 26 31 Amount 731.45 601.50 580.34 CHECKS WRITTEN: Number and amount of each check issued in May: Check No. 614 615 616 617 618 619 620 Amount $243.50 350.10 279.90 395.50 435.40 320.10 238.87 Check No. 621 622 623 624 625 626 627 Amount $309.50 Void Void 707.01 185.63 550.03 318.73 Check No. 628 629 630 631 632 633 634 Amount $ 837.70 329.90 882.80 1,081.56 62.40 310.08 503.30 Total amount of checks issued in May $8,342.01 Chapter 5 Internal Control and Cash PAGE 1 MEMBER FDIC ACCOUNT NUMBER FROM 6/01/20Y8 TO 5/31R0Y8 BALANCE AMERICAN NATIONAL BANK OF DETROIT 8,43R.80 6,086,35 7,482.11 DETROIT, MI 48201-2500 (313)933-8547 9 DEPOSITS 20 WITHDRAWALS Rancho Foods 4 OTHER DEBITS AND CREDITS 3,8B0.00OR NEW BALANCE 11,897.04 * CHECKS AND OTHER DEBITS *-DEPOSITg-r-DATB-.-BALANCE-* No. 580 10,10 No 613 No 808 88.5O No.814 848.50 No.015 50.10 No.e18 79.90 No.017 9,80 No.818 438.40 No.019 320.1O No.e20 238.87 No.621 09.50 No.ea4 707.01 o.626 15.63 No.828 880.03 No.827 18.73 No.83 0.90 No.630 883.80 No.6 1,081.88 NSP 450.00 No.838 8.4O No.883 810.08 08/o1 OB/O8 0B/08 9,801.00 10,041.60 10,118.80 10,101.64 10,18,3 18,106.86 12,358.80 12,809.87 10,096.31 10,434.09 11,185.84 11,757.04 11,897.04 780.80 588.60 01 .80 819.84 580.70 MS 4,000.00 05/18 08/14 600.10 08/20 751.48 OB/84 801.80 80 60.00 BC BRROR CORRECTION OD-OVERDRAFT P8 PAYMENT STOPPED THE HKCONCIL XMRNT OP THIS STATEMENT WITH YOUR REOORDS I3 ESSENTIAL ANY ERROR OR EXCEPIION SHOULD BK REPORTED DMMEDIATRLY BANK RECONCILIATION FOR PRECEDING MONTH (DATED APRIL 30): Cash balance according to bank statement Add deposit of April 30, not recorded by bank 9,422.80 780.80 $10,203.60 Deduct outstanding checks: 310.10 85.50 92.50 137.50 O, O. O. 0. 613 625.60 9,578.00 9,605.70 Adjusted balance Cash balance according to company's records Deduct service charges Adjusted balance Instructions 1. Prepare a bank reconciliation as of May 31. If errors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales except for the note receivable of $4,000 and interest of $160 collected on May 14. All checks were written to satisfy accounts payable. 2. Ilustrate the effects on the accounts and financial statements of the bank reconciliation 3. What is the amount of Cash that should appear on the balance sheet as of May 31? . Assume that a canceled check for $50 has been incorrectly recorded by the bank as $500 Briefly explain how the error would be included in a bank reconciliation and how it should be corrected