A company provides the following information related to its ending cash balance. 1 Cash on hand at the company and not yet deposited at the bank 2 EFT for monthly utility bill not yet recorded by the company 4 Interest collected by the bank from note in #3 not yet recorded by the company 3 Note collected by the bank and not yet recorded by the company 5 Debit card used to purchase supplies not yet recorded by the company 6 Checks written by the company but not yet processed by the bank 7 Service fee charged by bank but not yet recorded by the company 8 Customer checks determined by the bank to have nonsufficient funds Bank balance at the end of the period Company balance at the end of the period Required: $16,200 13,400 1. Complete the bank reconciliation in the spreadsheet. 2. Use a conditional statement to evaluate whether the reconciled balances are equal. 3. Prepare necessary journal entries to update the Cash account. a. Prepare a journal entry for items that increased the Cash account. b. Prepare a journal entry for items that decreased the Cash account.. $4,500 1,400 9,000 600 500 1,900. 100 2,200