Please use the following template and complete the bank reconciliation

Prepare a bank reconciliation of Chavez Company as of September 30th using the information from the book: BALANCED? 300 Chapter 6 Cash and internal Controls Problem 6-5A Prepare a bank reconciliation and record adjustments P3 Chavez Company most recently reconciled its hank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,028,05 and No. 5893 for $494.25. The following information is available for its September 30, 2015, reconciliation. From Chavez Company's Accounting Records Additional Information Check No, 5904 is correctly drawn for $2,090 to pay for computer equipment; however, the recordkeeper misread the amount and entered it in the accounting reeords with a debit to Computer Equipment and a credit to Cash of $2,060. The NSR check shown in the statement was originally received from a customer, S. Nilson, in payment of her account. Its return has not yet been recorded by the company. The credit memorandum is from the collection of a $1,500 note for Chaver Company by the bank. The bank deducted a $15 collection fee. The collection and fce are not yet recorded. Required 1. Prepare the September 30,2015 , bank reconciliation for this company. 2. Prepare the journal entries (in dollars and eents) to adjust the book balance of cash tn the reconciled balance. Analysis Component 3. The bank statement reveals that some of the prenumbered checks in the sequence are missing. Describe three situations that could explain this. Check its hecmacilid batane. $18,271.45,12)Cr Nates haceivable 11,00000